pipIrr-SV.git - Gitblit

			@@ -188,12 +188,12 @@
			com.command_code AS commandCode,
			inta.name AS intakeNum,
			rtus.isOnLine,
			com.rtuAddr,
			com.rtu_addr AS rtuAddr,
			com.param ->>'$.orderNo' AS orderNo,
			com.param ->>'$.icCardNo' AS vcNum,
			com.send_time AS openTime
			FROM rm_command_history com
			INNER JOIN pr_controller con ON com.rtuAddr = con.rtuAddr
			INNER JOIN pr_controller con ON com.rtu_addr = con.rtuAddr
			INNER JOIN pr_intake inta ON con.intakeId = inta.id
			INNER JOIN JSON_TABLE(
			<!--'[{"rtuAddr":"37142501020100215","isOnLine":true},{"rtuAddr":"4000004","isOnLine":true},{"rtuAddr":"dy20240325","isOnLine":false}]',-->
			@@ -202,7 +202,7 @@
			rtuAddr VARCHAR(20) PATH '$.rtuAddr',
			isOnLine BOOLEAN PATH '$.isOnLine'
			)
			) rtus ON com.rtuAddr = rtus.rtuAddr
			) rtus ON com.rtu_addr = rtus.rtuAddr
			WHERE (com.command_code = '92' OR com.command_code = 'A2') AND com.operator = #{operator}
			AND NOT EXISTS (SELECT * FROM rm_command_history WHERE (command_code = '93' OR command_code = 'A3') AND param ->>'$.orderNo' = com.param ->>'$.orderNo')
			ORDER BY com.send_time DESC

			@@ -138,6 +138,7 @@
			// 发送命令
			JSONObject response_SendCom= (JSONObject) JSON.toJSON(sendCom2Mw(com));
			if(response_SendCom != null && response_SendCom.getString("code").equals("0001")) {
			//if(1 > 0) {
			// 请求成功

			// 创建命令日志对象并添加到数据库中

	pipIrr-platform/pipIrr-global/src/main/resources/mapper/RmCommandHistoryMapper.xml	6 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	pipIrr-platform/pipIrr-web/pipIrr-web-remote/src/main/java/com/dy/pipIrrRemote/valve/ValveCtrl.java	1 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史