| | |
| | | <!-- <if test="query.reserveOrPrevious != null and query.reserveOrPrevious == 'previous'">--> |
| | | <!-- and TPP.process_ins_id is not null--> |
| | | <!-- </if>--> |
| | | <if test="query.projectPhase == 3"> |
| | | and (TPI.project_status = 'working' or TPI.project_status = 'stop') |
| | | </if> |
| | | <!-- <if test="query.projectPhase == 3">--> |
| | | <!-- and (TPI.project_status = 'working' or TPI.project_status = 'stop')--> |
| | | <!-- </if>--> |
| | | /* 为空表示在库项目 */ |
| | | <if test="query.projectPhase == null"> |
| | | <if test="query.role != null and query.role == 1"> |
| | | and TPI.used_status = 1 and FIND_IN_SET(#{query.competentDepartment}, TPI.competent_department) > 0 |
| | | and TPI.competent_department = #{query.competentDepartment} |
| | | </if> |
| | | </if> |
| | | <!-- 业主数据权限 --> |