| | |
| | | import com.doumee.core.utils.DateUtil; |
| | | import com.doumee.core.utils.Utils; |
| | | import com.doumee.dao.business.CategoryMapper; |
| | | import com.doumee.dao.business.InoutDayCountMapper; |
| | | import com.doumee.dao.business.InoutRecordMapper; |
| | | import com.doumee.dao.business.dto.InParkDataDTO; |
| | | import com.doumee.dao.business.model.Category; |
| | | import com.doumee.dao.business.model.InoutDayCount; |
| | | import com.doumee.dao.business.model.InoutRecord; |
| | | import com.doumee.dao.business.model.Member; |
| | | import com.doumee.dao.business.vo.GeneralDataVO; |
| | | import com.doumee.dao.business.vo.InParkUserDataVO; |
| | | import com.doumee.dao.business.vo.TelecomInParkDataVO; |
| | | import com.doumee.service.business.InoutRecordService; |
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
| | | import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper; |
| | |
| | | |
| | | @Autowired |
| | | private CategoryMapper categoryMapper; |
| | | |
| | | @Autowired |
| | | private InoutDayCountMapper inoutDayCountMapper; |
| | | |
| | | @Override |
| | | public Integer create(InoutRecord inoutRecord) { |
| | |
| | | maxMonth = DateUtil.getNowMonthNum(); |
| | | } |
| | | for (int i = maxMonth; i >0 ; i--) { |
| | | dateList.add(DateUtil.getNowYearNum()+"-"+ StringUtils.leftPad(i+"",2,"0")); |
| | | dateList.add(inParkDataDTO.getDateStr()+"-"+ StringUtils.leftPad(i+"",2,"0")); |
| | | } |
| | | }else { |
| | | //日期 |
| | |
| | | throw new BusinessException(ResponseStatus.EXPORT_EXCEL_ERROR, e); |
| | | } |
| | | } |
| | | |
| | | |
| | | |
| | | @Override |
| | | public TelecomInParkDataVO getInParkDataForTelecom(){ |
| | | TelecomInParkDataVO telecomInParkDataVO = new TelecomInParkDataVO(); |
| | | telecomInParkDataVO.setInCarNum(Constants.ZERO); |
| | | telecomInParkDataVO.setInUserNum(Constants.ZERO); |
| | | |
| | | InoutDayCount inoutDayCount = inoutDayCountMapper.selectOne(new QueryWrapper<InoutDayCount>() |
| | | .lambda() |
| | | .apply(" DATE(TIME_INFO) = CURDATE() ") |
| | | .last(" limit 1 ") |
| | | ); |
| | | |
| | | if(Objects.nonNull(inoutDayCount)){ |
| | | telecomInParkDataVO.setInUserNum(inoutDayCount.getInMemberNum()); |
| | | telecomInParkDataVO.setInCarNum(inoutDayCount.getInCarNum()); |
| | | } |
| | | |
| | | /* List<InoutRecord> listCar = inoutRecordMapper.selectList(new MPJLambdaWrapper<InoutRecord>() |
| | | .eq(InoutRecord::getIsdeleted,Constants.ZERO) |
| | | .eq(InoutRecord::getInOrOut,Constants.ZERO) |
| | | .isNotNull(InoutRecord::getCarCode) |
| | | .apply(" ( DATE_FORMAT(CREATE_DATE, '%Y%m%d') = DATE_FORMAT(now(), '%Y%m%d') ) ")); |
| | | if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(listCar)){ |
| | | telecomInParkDataVO.setInCarNum( |
| | | new HashSet<>(listCar.stream().map(i->i.getCarCode()).collect(Collectors.toList())).size() |
| | | ); |
| | | } |
| | | |
| | | |
| | | List<InoutRecord> listUser = inoutRecordMapper.selectList(new MPJLambdaWrapper<InoutRecord>() |
| | | .eq(InoutRecord::getIsdeleted,Constants.ZERO) |
| | | .eq(InoutRecord::getInOrOut,Constants.ZERO) |
| | | .isNotNull(InoutRecord::getMemberPhone) |
| | | .apply(" ( DATE_FORMAT(CREATE_DATE, '%Y%m%d') = DATE_FORMAT(now(), '%Y%m%d') ) ")); |
| | | if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(listUser)){ |
| | | telecomInParkDataVO.setInUserNum( |
| | | new HashSet<>(listUser.stream().map(i->i.getMemberPhone()).collect(Collectors.toList())).size() |
| | | ); |
| | | }*/ |
| | | |
| | | return telecomInParkDataVO; |
| | | } |
| | | |
| | | |
| | | |
| | | } |