| | |
| | | jczz_task jt |
| | | LEFT JOIN jczz_house jh ON jt.house_code=jh.house_code and jh.is_deleted = 0 |
| | | LEFT JOIN blade_user bu on bu.id = jt.create_user and bu.is_deleted = 0 |
| | | LEFT JOIN jczz_grid_range jgr on jgr.house_code= jt.house_code |
| | | LEFT JOIN jczz_grid jg on jg.id = jgr.grid_id and jg.is_deleted = 0 |
| | | LEFT JOIN jczz_grid jg on jg.grid_code = jh.grid_code and jg.is_deleted = 0 |
| | | LEFT JOIN blade_region br on br.code = jg.community_code |
| | | <where> |
| | | <if test="task.roleName != null and task.roleName != ''"> |
| | |
| | | 1, bailReporting.getApplyName(), |
| | | AuthUtil.getUserId(), |
| | | bailReporting.getHouseCode(), |
| | | bailReporting.getReportType(),0); |
| | | bailReporting.getReportType(),1); |
| | | if (aLong > 0) { |
| | | bailReporting.setTaskId(aLong); |
| | | bailReporting.setCheckUserId(AuthUtil.getUserId()); |