| | |
| | | <if test="query.projectCategory == 3"> |
| | | and (TPI.project_status = 'working' or TPI.project_status = 'stop') |
| | | </if> |
| | | <!-- 业主数据权限 --> |
| | | <if test="query.role == 0"> |
| | | and TPI.project_owner_unit = #{query.projectOwnerUnit} |
| | | </if> |
| | | <if test="query.projectCategory == 6"> |
| | | <!-- <if test="query.role == 0">--> |
| | | <!-- and TPI.used_status != 2--> |
| | |
| | | and TPI.used_status = 1 and FIND_IN_SET(#{query.competentDepartment}, TPI.competent_department) > 0 |
| | | </if> |
| | | </if> |
| | | <!--${query.params.dataScope}--> |
| | | <!-- 业主数据权限 --> |
| | | <if test="query.role == 0"> |
| | | ${query.params.dataScope} |
| | | </if> |
| | | </where> |
| | | order by TPI.gmt_create |
| | | </select> |