湖北水库项目
parent: c9b01b6b | patch | commit | ignore whitespace
shenyijian
2024-06-18 956f4ea5435ca0e2d591c34ef2d99ecc44351f64 
湖北水库：施工：APP待办数量统计
1 files modified
10 ■■■■■ changed files
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/mapper/SgProgressReportMapper.xml 10 ●●●●● patch | view | raw | blame | history 
 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/mapper/SgProgressReportMapper.xml


@@ -48,6 +48,11 @@


        <if test="dto.approvalStatus != null">


            and userR.approval_status = #{dto.approvalStatus}


        </if>


        <choose >


            <when test="dto.approvalStatus != null and dto.approvalStatus == 0">


                and report.audit_person = #{dto.approvalStatus}


            </when>


        </choose>


    </select>


    <select id="countList" resultType="java.lang.Long">


        select count(1) from  ywxt.SG_PROGRESS_REPORT report


@@ -60,6 +65,11 @@


        <if test="dto.approvalStatus != null ">


            and userR.approval_status = #{dto.approvalStatus}


        </if>


        <choose >


            <when test="dto.approvalStatus != null and dto.approvalStatus == 0">


                and report.audit_person = #{dto.approvalStatus}


            </when>


        </choose>


    </select>


    <select id="selectByDeviceId" resultType="cn.gistack.sm.sg.VO.SgStepReportVO">


        SELECT