流程推进、项目计划分页查询只查审核通过的项目

xiangpei

2025-02-11 c92c21bbe3c3bfff86e9e912441a574fd7103e36

流程推进、项目计划分页查询只查审核通过的项目

 business/src/main/resources/mapper/PlanMapper.xml

@@ -65,7 +65,7 @@
        LEFT JOIN t_plan AS p ON p.project_info_id = pi.id
        LEFT JOIN sys_dept d ON d.dept_id = PI.project_owner_unit
        <where>
            pi.deleted = 0
            pi.deleted = 0 AND pi.used_status = 2
            <if test="query.projectName!= null and query.projectName!= ''">
                AND pi.project_name LIKE CONCAT('%', #{query.projectName}, '%')
            </if>

 business/src/main/resources/mapper/ProjectProcessMapper.xml

@@ -64,9 +64,10 @@
            TPP.process_ins_id
        FROM
            t_project_info PI
                LEFT JOIN t_project_process TPP ON TPP.project_id = PI.id AND TPP.deleted = 0 AND PI.deleted = 0
                LEFT JOIN t_project_process TPP ON TPP.project_id = PI.id AND TPP.deleted = 0
                LEFT JOIN sys_dept d ON d.dept_id = PI.project_owner_unit
        <where>
            AND PI.used_status = 2 AND PI.deleted = 0
            <if test="query.projectName != null and query.projectName != ''">
                AND PI.project_name like concat('%', #{query.projectName}, '%')
            </if>