| | |
|---|
| | | left join YWXT."BLADE_DICT_BIZ" as dict on de.device_type=dict.DICT_KEY and dict.CODE='SG_DEVICE_TYPE' |
|---|
| | | LEFT JOIN ywxt.sg_report_user userR ON report.id = userR.report_id |
|---|
| | | WHERE |
|---|
| | | 1 = 1 and report."STATUS" != 4 and si.CONTROL_UNIT=#{dto.userUnit} and userR.roleId=#{dto.roleUnit} |
|---|
| | | 1 = 1 and report."STATUS" != 4 |
|---|
| | | <if test="dto.userUnit != null and dto.userUnit != ''"> |
|---|
| | | and si.CONTROL_UNIT=#{dto.userUnit} |
|---|
| | | </if> |
|---|
| | | <if test="dto.roleUnit != null and dto.roleUnit != ''"> |
|---|
| | | and userR.role_id=#{dto.roleUnit} |
|---|
| | | </if> |
|---|
| | | <!-- AND userR.is_his = 0 --> |
|---|
| | | <if test="dto.projectName != null and dto.projectName != ''"> |
|---|
| | | and report.PROGRAM_NAME like CONCAT(CONCAT('%',#{dto.projectName}),'%') |
|---|
