select t.ID,t.ID,t.STATIONS,t.SHOPID,
t.WORKID,t.RUMMAGER,t.CHECK_DATE,t.SECTION,
t.LOCATION,t.ISSUE,
t.HIDDEN_PICTURES,t.RECTIFICATION_MEASURES,
t.DEADLINE,t.PRINCIPAL,
t.SECURITY_MEASURES,t.REORGANIZE_THE_SITUATION,
t.RECTIFICATION_TIME,
t.RECTIFICATION_PHOTOS,t.REMARK,t.CREATOR,t.UPDATEPEOPLE,
t.DATE_CREATED,t.DATE_UPDATED,
d.DEPT_NAME
from JCW_JF_FLOOD t
left join sys_dept d on d.dept_id=t.ID
left join sys_dept d on d.dept_id=t.ID
where 1=1
<!-- 按部门权限查询,service层调用该接口时,需要手动调用BaseVo.loadDeptCondsSql方法生成sql -->
<if test="model.id != null and model.id != ''">
and t.ID=#{model.id}
</if>
<!-- 站段 -->
<if test="model.stations != null and model.stations != ''">
and t.STATIONS=#{model.stations}
</if>
<!-- 车间 -->
<if test="model.shopid != null and model.shopid != ''">
and t.SHOPID=#{model.shopid}
</if>
<!-- 班组 -->
<if test="model.workid != null and model.workid != ''">
and t.WORKID=#{model.workid}
</if>
<!-- 开始和结束时间 -->
<if test="model.statDate != null and model.statDate !=