| | |
| | | /** |
| | | * 水库水位情况信息填报 url |
| | | */ |
| | | public static final String fillWaterInfoUrl = "sk.hubeishuiyi.cn/znwh/index.html"; |
| | | public static final String fillWaterInfoUrl = "https://sk.hubeishuiyi.cn/znwh/index.html"; |
| | | |
| | | /** |
| | | * 前缀(未接电话发送短息记录),用于判断是否已发过短息 |
| | |
| | | TRIM(BOTH '"' FROM JSON_EXTRACT(ctc.call_task_callee_content,'$."$用户名$"')) as userName |
| | | from call_task_callee ctc left join call_task_result ctr on ctc.call_id = ctr.call_id |
| | | where ctc.task_id = #{taskId} |
| | | and ctc.call_status = 4 and ctr.call_result!='200000' |
| | | and ctr.call_result!='200000' |
| | | <if test="callId!=null and callId!=''"> |
| | | and ctc.call_id = #{callId} |
| | | </if> |
| | |
| | | // } |
| | | builder.append(map.get("userPhone") + ",") |
| | | .append(time + ",") |
| | | .append(map.get("waterName")) |
| | | .append(MinConstant.fillWaterInfoUrl +"?" + "callId=" + map.get("callId") + ",") |
| | | .append(map.get("waterName") + ",") |
| | | .append(MinConstant.fillWaterInfoUrl +"?" + "callId=" + map.get("callId")) |
| | | .append(";"); |
| | | } |
| | | String datas = builder.toString(); |