| | |
| | | List<InterestedListVO> lwList = new ArrayList<>(); |
| | | List<InterestedListVO> internalList = new ArrayList<>(); |
| | | //查询七天前的访客记录数量 |
| | | List<Visits> visitsList = visitsMapper.selectList(new QueryWrapper<Visits>().lambda().in(Visits::getStatus, |
| | | Constants.VisitStatus.signin,Constants.VisitStatus.signout) |
| | | .apply(" STARTTIME > CURDATE() - INTERVAL 7 DAY " ) |
| | | ); |
| | | // List<Visits> visitsList = visitsMapper.selectList(new QueryWrapper<Visits>().lambda().in(Visits::getStatus, |
| | | // Constants.VisitStatus.signin,Constants.VisitStatus.signout) |
| | | // .apply(" STARTTIME > CURDATE() - INTERVAL 7 DAY " ) |
| | | // ); |
| | | |
| | | List<InoutRecord> inoutRecordList = inoutRecordMapper.selectList(new QueryWrapper<InoutRecord>().lambda() |
| | | .eq(InoutRecord::getInOrOut,Constants.ZERO).eq(InoutRecord::getIsdeleted,Constants.ZERO) |
| | | .apply(" STARTTIME > CURDATE() - INTERVAL 7 DAY " ) |
| | | .apply(" TIME_INFO > CURDATE() - INTERVAL 7 DAY " ) |
| | | ); |
| | | |
| | | List<CarEvent> carEventList = carEventMapper.selectList(new QueryWrapper<CarEvent>().lambda() |
| | | .in(CarEvent::getEventType,"771760131","771760130") |
| | | .apply(" STR_TO_DATE(happen_time, '%Y-%m-%dT%H:%i:%s') > CURDATE() - INTERVAL 7 DAY " ) |
| | | ); |
| | | // List<CarEvent> carEventList = carEventMapper.selectList(new QueryWrapper<CarEvent>().lambda() |
| | | // .in(CarEvent::getEventType,"771760131","771760130") |
| | | // .apply(" STR_TO_DATE(happen_time, '%Y-%m-%dT%H:%i:%s') > CURDATE() - INTERVAL 7 DAY " ) |
| | | // ); |
| | | |
| | | for (String days:weekDays) { |
| | | InterestedListVO visitVO = new InterestedListVO(); |
| | |
| | | .eq(Company::getType,Constants.ZERO) |
| | | .eq(Company::getIsdeleted,Constants.ZERO) |
| | | ); |
| | | |
| | | |
| | | |
| | | if(CollectionUtils.isNotEmpty(companyList)){ |
| | | List<Company> lwCompanyList = companyList.stream().filter(i->Constants.equalsInteger(i.getType(),Constants.ZERO)).collect(Collectors.toList()); |