| | |
| | | @ExcelProperty("发生地点") |
| | | private String happenAddr; |
| | | @ExcelProperty("事件类型") |
| | | private String photoType = "其他"; |
| | | private String photoType; |
| | | @ExcelProperty("联系电话") |
| | | private String phone; |
| | | @ExcelProperty("创建时间") |
| | |
| | | cmActEasyPhotoDO.setFeedbackAt(nowDate); |
| | | cmActEasyPhotoDO.setStatus(ComActEasyPhotoDO.status.ywc); |
| | | cmActEasyPhotoDO.setCompleteId(comActEasyPhotoVO.getUserId()); |
| | | if(comActEasyPhotoVO.getUrbanStatus()!=null&&comActEasyPhotoVO.getUrbanStatus()==2){ |
| | | cmActEasyPhotoDO.setUrbanStatus(2); |
| | | } |
| | | break; |
| | | default: |
| | | break; |
| | |
| | | ComActReserveDO comActReserveDO=comActReserveMapper.selectById(comActReserveCommitVO.getId()); |
| | | if(comActReserveDO!=null){ |
| | | //查询当前用户是否已预约并判断是否能继续预约 |
| | | if(comActReserveDO.getJoinAllCount()!=0){ |
| | | Integer count=comActReserveRecordMapper.selectCount(new QueryWrapper<ComActReserveRecordDO>().eq("reserve_id",comActReserveCommitVO.getId())); |
| | | if(count>=comActReserveDO.getJoinCount()){ |
| | | return R.fail("预约已上限"); |
| | | } |
| | | } |
| | | |
| | | |
| | | List<ComActReserveRecordDO> list=comActReserveRecordMapper.selectList(new QueryWrapper<ComActReserveRecordDO>().eq("reserve_id",comActReserveCommitVO.getId()).eq("user_id",comActReserveCommitVO.getUserId()).in("status",1,2,3)); |
| | | if(!list.isEmpty()&&list.size()>1&&comActReserveDO.getIsRepeat()==ComActReserveDO.isRepeat.no){ |
| | | return R.fail("提交失败,不可重复预约"); |
| | |
| | | p.examine_at, |
| | | c.name communityName, |
| | | p.is_report_urban, |
| | | p.urban_status |
| | | p.urban_status, |
| | | ca.`name` as photoType |
| | | FROM |
| | | com_act_easy_photo p |
| | | LEFT JOIN sys_user u ON p.sponsor_id = u.user_id |
| | | LEFT JOIN com_act_easy_photo_user pu ON p.id = pu.easy_photo_id |
| | | LEFT JOIN sys_user su ON p.handler_id = su.user_id |
| | | left join com_act c on p.community_id =c.community_id |
| | | left join com_act_easy_photo_classify ca on ca.id = p.classify_id |
| | | WHERE |
| | | p.del_tag = 0 and p.`is_report_urban` =1 |
| | | <if test='communityId != null and communityId != 0'> |
| | |
| | | p.examine_at, |
| | | c.name communityName, |
| | | p.is_report_urban, |
| | | p.urban_status |
| | | p.urban_status, |
| | | ca.`name` as photoType |
| | | FROM |
| | | com_act_easy_photo p |
| | | LEFT JOIN sys_user u ON p.sponsor_id = u.user_id |
| | | LEFT JOIN com_act_easy_photo_user pu ON p.id = pu.easy_photo_id |
| | | LEFT JOIN sys_user su ON p.handler_id = su.user_id |
| | | left join com_act c on p.community_id =c.community_id |
| | | left join com_act_easy_photo_classify ca on ca.id = p.classify_id |
| | | WHERE |
| | | p.id in |
| | | <foreach collection="list" item="ids" index="index" |