| | |
| | | queryWrapper.lambda().eq(Sites::getInfo, pageWrap.getModel().getInfo()); |
| | | } |
| | | if (pageWrap.getModel().getName() != null) { |
| | | queryWrapper.lambda().eq(Sites::getName, pageWrap.getModel().getName()); |
| | | queryWrapper.lambda().like(Sites::getName, pageWrap.getModel().getName()); |
| | | } |
| | | if (pageWrap.getModel().getCode() != null) { |
| | | queryWrapper.lambda().eq(Sites::getCode, pageWrap.getModel().getCode()); |
| | | queryWrapper.lambda().like(Sites::getCode, pageWrap.getModel().getCode()); |
| | | } |
| | | if (pageWrap.getModel().getStatus() != null) { |
| | | queryWrapper.lambda().eq(Sites::getStatus, pageWrap.getModel().getStatus()); |
| | |
| | | |
| | | @Override |
| | | public PageData<Sites> findSitesMonitorDTOPage(PageWrap<SitesMonitorDTO> pageWrap) { |
| | | |
| | | // IPage page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); |
| | | IPage<Sites> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); |
| | | QueryWrapper<Sites> queryWrapper = new QueryWrapper<>(); |
| | | Utils.MP.blankToNull(pageWrap.getModel()); |
| | | queryWrapper.select("*,(select count(r.id) from locks r where r.site_id = sites.id) as localCount" + |
| | | ",(select count(r.bike_code) from locks r where r.site_id = sites.id and r.bike_code is null and r.bike_code !='' ) as bikeCount"); |
| | | // queryWrapper.select("*,(select count(r.id) from locks r where r.site_id = sites.id) as localCount" + |
| | | queryWrapper.select( "*,(select count(r.bike_code) from locks r where r.site_id = sites.id and r.bike_code is null and r.bike_code !='' ) as bikeCount"); |
| | | // Page<SitesMonitorDTO> sitesMonitorDTO = sitesMapper.getSitesMonitorDTO(page, pageWrap.getModel().getCode(), pageWrap.getModel().getName()); |
| | | queryWrapper.lambda().like(StringUtils.isNotBlank(pageWrap.getModel().getCode()),Sites::getCode,pageWrap.getModel().getCode()); |
| | | queryWrapper.lambda().like(StringUtils.isNotBlank(pageWrap.getModel().getName()),Sites::getCode,pageWrap.getModel().getName()); |
| | |
| | | |
| | | if (!CollectionUtils.isEmpty(sitesMonitorDTO.getRecords())){ |
| | | sitesMonitorDTO.getRecords().forEach(s->{ |
| | | s.setRate(new BigDecimal(s.getBikeCount()).divide(new BigDecimal(s.getLocalCount()).setScale(2))); |
| | | s.setRate(new BigDecimal(s.getBikeCount()).divide(new BigDecimal(s.getLockNum()).setScale(2))); |
| | | }); |
| | | } |
| | | |
| | |
| | | @Override |
| | | public void siteReservesNotice(String siteId) throws Exception { |
| | | |
| | | } |
| | | |
| | | @Override |
| | | public PageData<SitesMonitorBikeDTO> getSitesMonitorBikeDTO(PageWrap<SitesMonitorDTO> pageWrap) { |
| | | IPage page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); |
| | | Page<SitesMonitorBikeDTO> sitesMonitorDTO = sitesMapper.getSitesMonitorBikeDTO(page, |
| | | pageWrap.getModel().getCode(), |
| | | pageWrap.getModel().getName(), |
| | | pageWrap.getModel().getLockCode(), |
| | | pageWrap.getModel().getHasBike()); |
| | | |
| | | |
| | | return PageData.from(sitesMonitorDTO); |
| | | } |
| | | } |