{
  "diffTableNo": 0,
  "isRESTful": true,
  "base": {
    "connName": "ConnIdc",
    "isRearEnd": true,
    "isFrontEnd": true
  },
  "responseField": {
    "month": {
      "copy": {
        "connName": "ConnIdc",

        "rules": [
              {
            "regex": "fromDataTime==null ||targetDataTime==null  ",
            "message": "来源年月和目标年月都必须填写",
            "sortId": 1
          },
          {
            //时间列 字符串转 时间,作为下一个研究条件参数
            "dateField": "targetDataTime,fromDataTime",
            "regex": "fromDataTime==targetDataTime",
            "message": "来源年月和目标年月不能相同",
            "sortId": 5
          },
          {
            "regex": "fromDataTimeD>targetDataTimeD||targetDataTimeD>_currentDate",
            "message": "来源年月必须小于目标年月且小于当前时间",
            "sortId": 6
          }      ],
        "sql": [         
          {
            "value": "delete from idc_resource_statistics_warm_system where data_time=@fromDataTime; ",
            "sortId": 15
          },
          {
            "value": "insert into idc_resource_statistics_cool (audit_status,audit_time,audit_user_id,back_water_in,back_water_out,cooling_tower,create_time,create_user_id,data_date,group_id,modify_time,modify_user_id,opinion,res_enum_id,sys_id,water_storage,water_supply_in,water_supply_out) ",
            "sortId": 20
          },
          {
            "value": "select audit_status,audit_time,audit_user_id,back_water_in,back_water_out,cooling_tower,create_time,create_user_id,@targetDataTime,group_id,modify_time,modify_user_id,opinion,CONCAT(substring_index(res_enum_id, '-', 3),'-',FLOOR(RAND() * 100000),'-',@_primaryIdV)   res_enum_id,sys_id,water_storage,water_supply_in,water_supply_out from idc_resource_statistics_cool where data_time=@fromDataTime;",
            "sortId": 25
          }
        ]
      }
    }
  }
}
文档更新时间: 2022-01-03 22:55   作者:admin