问题sql修复

heheng

2025-06-25 99ecffd1c97443f6e30d251b5fb563b673f5d662

问题sql修复

 src/main/resources/mybatis/tr/TbSpecialCheckScoreAndDangerLogMapper.xml

@@ -193,7 +193,7 @@
    </select>
<!--    void updateItemDangerReportStatusById(HandlerSpecialCheckReportParam handlerCJReportParam);-->
    <update id="updateItemDangerReportStatusById" >
        update tb_special_check_score_and_danger_log
        update tb_special_check_score_and_danger_log set
            report_status =  #{reportStatus},
            report_time = #{reportTime}
        where id = #{id}  and deleted = 0

 src/main/resources/mybatis/tr/TbSpecialCheckTaskLogMapper.xml

@@ -158,7 +158,7 @@

<!--    void updateCheckTaskReportStatusById(HandlerCJReportParam handlerCJReportParam);-->
    <update id="updateCheckTaskReportStatusById">
        update tb_special_check_task_log
        update tb_special_check_task_log set
            report_status =  #{reportStatus},
            report_time = #{reportTime}
        where id = #{id}  and deleted = 0