hbwri/skjcmanager.git

			@@ -22,6 +22,9 @@
			<if test="dto.status != null ">
			and report.status = #{dto.status}
			</if>
			<if test="dto.reportPerson != null ">
			and report.report_user = #{dto.reportPerson}
			</if>
			</select>
			<select id="queryById" resultType="cn.gistack.sm.sg.VO.SgProgressReportVO">
			select * from SG_PROGRESS_REPORT report where id = #{id}
			@@ -41,17 +44,20 @@
			WHERE
			1 = 1
			AND userR.is_his = 0
			AND userR.approval_order != 0
			<if test="dto.userId != null and dto.userId != ''">
			and userR.user_id = #{dto.userId}
			</if>
			<if test="dto.approvalStatus != null">
			<if test="dto.approvalStatus != null and dto.approvalStatus != 3">
			and userR.approval_status = #{dto.approvalStatus}
			AND userR.approval_order != 0
			</if>
			<choose >
			<when test="dto.approvalStatus != null and dto.approvalStatus == 0">
			and report.audit_person = #{dto.userId}
			</when>
			<when test="dto.approvalStatus != null and dto.approvalStatus == 3">
			and report.report_user = #{dto.userId}
			</when>
			</choose>
			</select>
			<select id="countList" resultType="java.lang.Long">

	skjcmanager/skjcmanager-service-api/skjcmanager-sm-api/src/main/java/cn/gistack/sm/sg/DTO/ProjectSearchDTO.java	1 ●●●●● patch \| view \| raw \| blame \| history
	skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/mapper/SgProgressReportMapper.xml	10 ●●●●● patch \| view \| raw \| blame \| history

			@@ -19,4 +19,5 @@
			private String projectId;
			private Integer approvalStatus;
			private Integer status;
			private Long reportPerson;
			}