获取未关阀记录接口，返回多条记录

zhubaomin

2024-11-13 ba2c5cb35e1bd1a81bf4027b7aeab16a0a26bb05

获取未关阀记录接口，返回多条记录

 pipIrr-platform/pipIrr-global/src/main/resources/mapper/RmCommandHistoryMapper.xml

@@ -259,7 +259,6 @@
        </where>
        GROUP BY inta.name, rtus.isOnLine, com.rtu_addr, com.param ->> '$.icCardNo', com.command_code, com.send_time, dt, waterInstant
        ORDER BY com.send_time DESC
        LIMIT 1
    </select>

    <!--根据取水口ID获取该取水口未关阀参数-->

 pipIrr-platform/pipIrr-web/pipIrr-web-app/src/main/java/com/dy/pipIrrApp/issue/IssueSv.java

@@ -4,7 +4,9 @@
import com.dy.pipIrrApp.issue.dto.DtoDeleteParam;
import com.dy.pipIrrApp.issue.qo.QoIssueReport;
import com.dy.pipIrrGlobal.daoOp.OpeIssueReportMapper;
import com.dy.pipIrrGlobal.daoOp.OpeReportReplyMapper;
import com.dy.pipIrrGlobal.pojoOp.OpeIssueReport;
import com.dy.pipIrrGlobal.pojoOp.OpeReportReply;
import com.dy.pipIrrGlobal.voOp.VoIssueReport;
import lombok.extern.slf4j.Slf4j;
import org.apache.dubbo.common.utils.PojoUtils;
@@ -27,6 +29,9 @@
public class IssueSv {
    @Autowired
    private OpeIssueReportMapper opeIssueReportMapper;

    @Autowired
    private OpeReportReplyMapper opeReportReplyMapper;

    /**
     * 添加巡检员问题上报
@@ -95,4 +100,21 @@
        return "success";
    }

    /**
     * 添加巡检员问题上报回复
     *  添加问题上报回复记录
     *  问题上报状态改为已回复
     * @param po
     * @return
     */
    public String replyReport(OpeReportReply po) {
        po.setReplyTime(new Date());
        opeReportReplyMapper.insert(po);
        if(po.getId() == 0) {
            return "回复记录添加失败";
        }

        return "sucess";
    }

}