| | |
|---|
| | | |
|---|
| | | |
|---|
| | | //人员分类 单独处理人员数据 0劳务访客 1普通访客 2内部员工 3车辆信息 4相关方人员 5货运司机 |
|---|
| | | private static String[] userTypeList = new String[]{"","普通访客","内部人员","","相关方人员","货运司机"}; |
|---|
| | | private static String[] userTypeList = new String[]{"","普通访客","内部人员","","相关方人员"}; |
|---|
| | | |
|---|
| | | |
|---|
| | | /** |
|---|
| | |
|---|
| | | ){ |
|---|
| | | throw new BusinessException(ResponseStatus.BAD_REQUEST); |
|---|
| | | } |
|---|
| | | //查询本周的开始日期和结束日期 |
|---|
| | | Long weekStart = LocalDate.now().with(TemporalAdjusters.previousOrSame(DayOfWeek.MONDAY)).atStartOfDay(ZoneOffset.UTC).toInstant().toEpochMilli(); |
|---|
| | | //查询本周的开始日期 |
|---|
| | | LocalDate today = LocalDate.now(); |
|---|
| | | // 计算周一和周五的日期 |
|---|
| | | LocalDate monday = today.with(DayOfWeek.MONDAY); |
|---|
| | | Long weekStart = DateUtil.fromStringToDate("yyyy-MM-dd HH:mm:ss",monday.toString() + " 00:00:00").getTime();//LocalDate.now().with(TemporalAdjusters.previousOrSame(DayOfWeek.MONDAY)).atStartOfDay(ZoneOffset.UTC).toInstant().toEpochMilli(); |
|---|
| | | InParkUserDataVO inParkUserDataVO = new InParkUserDataVO(); |
|---|
| | | List<InoutRecord> yearList = inoutRecordMapper.selectJoinList(InoutRecord.class,new MPJLambdaWrapper<InoutRecord>() |
|---|
| | | .selectAll(InoutRecord.class) |
|---|
| | |
|---|
| | | for (String categoryName:setList) { |
|---|
| | | GeneralDataVO generalDataVO = new GeneralDataVO(); |
|---|
| | | generalDataVO.setName(categoryName); |
|---|
| | | generalDataVO.setTotal(yearList.stream().filter(j->StringUtils.isNotBlank(j.getCategoryParentName())&&j.getCategoryName().equals(categoryName)).collect(Collectors.toList()).size()); |
|---|
| | | generalDataVO.setTotal(yearList.stream().filter(j->StringUtils.isNotBlank(j.getCategoryParentName())&&j.getCategoryParentName().equals(categoryName)).collect(Collectors.toList()).size()); |
|---|
| | | generalDataVO.setRata(new BigDecimal(generalDataVO.getTotal().toString()).divide(new BigDecimal(yearList.size()+""),2,BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal("100"))); |
|---|
| | | rataList.add(generalDataVO); |
|---|
| | | } |
|---|
| | |
|---|
| | | }else if(Constants.equalsInteger(inParkDataDTO.getDateStr().length(),7)&&Constants.equalsInteger(inParkDataDTO.getType(),Constants.ZERO)){ |
|---|
| | | mpjLambdaWrapper.select("car_code,category_name,DATE_FORMAT(CREATE_DATE, '%Y-%m-%d') as createDateStr "); |
|---|
| | | }else if(Constants.equalsInteger(inParkDataDTO.getDateStr().length(),4)&&Constants.equalsInteger(inParkDataDTO.getType(),Constants.ONE)){ |
|---|
| | | |
|---|
| | | mpjLambdaWrapper.select("member_phone,MEMBER_TYPE,DATE_FORMAT(CREATE_DATE, '%Y-%m') as createDateStr"); |
|---|
| | | }else{ |
|---|
| | | mpjLambdaWrapper.select("member_phone,MEMBER_TYPE,DATE_FORMAT(CREATE_DATE, '%Y-%m-%d') as createDateStr "); |
|---|
