| | |
|---|
| | | left join tr_hidden_danger_check c on c.check_id = a.check_id |
|---|
| | | left join tr_troubleshoot_type b on c.troubleshoot_type_id = b.type_id |
|---|
| | | </sql> |
|---|
| | | |
|---|
| | | <!-- todo 查隐患台账--> |
|---|
| | | <select id="selectHiddenDangerCheckPointListNewCount" parameterType="HiddenDangerCheckPoint" |
|---|
| | | resultMap="HiddenDangerCheckPointResult"> |
|---|
| | |
|---|
| | | </if> |
|---|
| | | <if test="acceptStatus != null and acceptStatus != ''">and a.accept_status = #{acceptStatus}</if> |
|---|
| | | <if test="dangerSources != null and dangerSources != ''">and a.danger_sources = #{dangerSources}</if> |
|---|
| | | <if test="dangerName != null and dangerName != ''">and a.danger_name like concat('%', #{dangerName}, '%') |
|---|
| | | </if> |
|---|
| | | |
|---|
| | | <!-- <if test="rectifyUserIdIsNotNull != null and rectifyUserIdIsNotNull != ''">and a.rectify_user_id is not null</if>--> |
|---|
| | | |
|---|
