| | |
| | | import com.baomidou.mybatisplus.core.toolkit.Wrappers; |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import com.yuanchu.mom.common.GetLook; |
| | | import com.yuanchu.mom.dto.AuxiliaryOutputWorkingHoursDto; |
| | | import com.yuanchu.mom.dto.CostStatisticsDto; |
| | | import com.yuanchu.mom.mapper.*; |
| | | import com.yuanchu.mom.pojo.*; |
| | | import com.yuanchu.mom.service.ReportService; |
| | | import lombok.AllArgsConstructor; |
| | | import org.springframework.beans.BeanUtils; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import java.math.BigDecimal; |
| | |
| | | private UserMapper userMapper; |
| | | private RoleMapper roleMapper; |
| | | private InsSampleUserMapper insSampleUserMapper; |
| | | private AuxiliaryOutputWorkingHoursMapper auxiliaryOutputWorkingHoursMapper; |
| | | |
| | | //æ¯æ¥ä¸å¡ç»è®¡ |
| | | @Override |
| | | public Map<String, Object> businessStatisticsByDay() { |
| | | public Map<String, Object> businessStatisticsByDay(String startTime,String endTime,String type) { |
| | | DateTimeFormatter format = DateTimeFormatter.ofPattern("yyyy-MM-dd"); |
| | | LocalDateTime start = LocalDate.parse(startTime, format).atStartOfDay(); |
| | | LocalDateTime end = LocalDate.parse(endTime, format).atTime(23, 59, 59); |
| | | LocalDateTime oldStart=start ; |
| | | LocalDateTime oldEnd=end ; |
| | | switch (type){ |
| | | case "å¨": |
| | | oldStart = start.minusDays(7); |
| | | oldEnd = end.minusDays(7); |
| | | break; |
| | | case "æ": |
| | | oldStart = start.minusMonths(1); |
| | | oldEnd = end.minusMonths(1); |
| | | break; |
| | | case "å¹´": |
| | | oldStart = start.minusYears(1); |
| | | oldEnd = end.minusYears(1); |
| | | break; |
| | | } |
| | | Map<String, Object> map = new HashMap<>(); |
| | | /*任塿¥æ¶*/ |
| | | //仿¥ä»»å¡æ¥æ¶ |
| | | Long receive = insOrderMapper.selectCount(Wrappers.<InsOrder>lambdaQuery().eq(InsOrder::getState, 1).apply("DATE(create_time) = CURDATE()")); |
| | | Long receive = insOrderMapper.selectCount(Wrappers.<InsOrder>lambdaQuery() |
| | | .eq(InsOrder::getState, 1) |
| | | .between(InsOrder::getCreateTime, start, end)); |
| | | map.put("RECEIVE", receive); |
| | | //æ¨æ¥ä»»å¡æ¥æ¶ |
| | | Long received = insOrderMapper.selectCount(Wrappers.<InsOrder>lambdaQuery().eq(InsOrder::getState, 1).apply("DATE(create_time) = CURDATE() - INTERVAL 1 DAY")); |
| | | Long received = insOrderMapper.selectCount(Wrappers.<InsOrder>lambdaQuery() |
| | | .eq(InsOrder::getState, 1) |
| | | .between(InsOrder::getCreateTime, oldStart, oldEnd)); |
| | | //æ¯ä¾=(ä»å¤©-æ¨å¤©)/æ¨å¤© |
| | | BigDecimal ratio = new BigDecimal(receive - received).divide(new BigDecimal(received == 0 ? 1 : received), 2, BigDecimal.ROUND_HALF_UP); |
| | | map.put("RECEIVE_RATIO", ratio); |
| | | |
| | | /*ä»»å¡å·²å®æ*/ |
| | | //仿¥ä»»å¡å®æ |
| | | Long finishe = insOrderMapper.selectCount(Wrappers.<InsOrder>lambdaQuery().eq(InsOrder::getState, 4).apply("DATE(create_time) = CURDATE()")); |
| | | Long finishe = insOrderMapper.selectCount(Wrappers.<InsOrder>lambdaQuery() |
| | | .eq(InsOrder::getState, 4) |
| | | .between(InsOrder::getCreateTime, start, end)); |
| | | map.put("FINISHE", finishe); |
| | | //æ¨æ¥ä»»å¡å®æ |
| | | Long finished = insOrderMapper.selectCount(Wrappers.<InsOrder>lambdaQuery().eq(InsOrder::getState, 4).apply("DATE(create_time) = CURDATE() - INTERVAL 1 DAY")); |
| | | Long finished = insOrderMapper.selectCount(Wrappers.<InsOrder>lambdaQuery() |
| | | .eq(InsOrder::getState, 4) |
| | | .between(InsOrder::getCreateTime, oldStart, oldEnd)); |
| | | //ä»»å¡å®ææ¯ä¾=(ä»å¤©-æ¨å¤©)/æ¨å¤© |
| | | BigDecimal finishedRatio = new BigDecimal(finishe - finished).divide(new BigDecimal(finished == 0 ? 1 : finished), 2, BigDecimal.ROUND_HALF_UP); |
| | | map.put("FINISHE_RATIO", finishedRatio); |
| | |
| | | /*æ£æµè´¹ç¨*/ |
| | | //仿¥æ£æµè´¹ç¨ |
| | | QueryWrapper<CostStatisticsDto> costStatisticsDtoQueryWrappers = new QueryWrapper<>(); |
| | | costStatisticsDtoQueryWrappers.eq("create_time", LocalDateTime.now()); |
| | | costStatisticsDtoQueryWrappers.between("create_time", start,end); |
| | | IPage<CostStatisticsDto> page = new Page<>(); |
| | | page.setSize(-1); |
| | | page.setCurrent(-1); |
| | |
| | | map.put("PRICE", price); |
| | | //æ¨æ¥æ£æµè´¹ç¨ |
| | | QueryWrapper<CostStatisticsDto> costWrappers = new QueryWrapper<>(); |
| | | costWrappers.eq("create_time", LocalDateTime.now().minusDays(1)); |
| | | costWrappers.between("create_time", oldStart,oldEnd); |
| | | IPage<CostStatisticsDto> dtoIPage = insOrderMapper.selectCostStatistics(page, costWrappers); |
| | | BigDecimal priced = BigDecimal.ZERO; |
| | | for (CostStatisticsDto record : dtoIPage.getRecords()) { |
| | |
| | | |
| | | /*æ£æµäººå*/ |
| | | //仿¥æ£æµäººå |
| | | List<InsProductUser> insProductUsers = insProductUserMapper.selectList(Wrappers.<InsProductUser>lambdaQuery().apply("DATE(create_time) = CURDATE()")); |
| | | List<InsProductUser> insProductUsers = insProductUserMapper.selectList(Wrappers.<InsProductUser>lambdaQuery() |
| | | .between(InsProductUser::getCreateTime, start, end)); |
| | | long person = insProductUsers.stream().map(InsProductUser::getCreateUser).distinct().count(); |
| | | map.put("PERSON", person); |
| | | //æ¨æ¥æ£æµäººå |
| | | List<InsProductUser> insProductUserss = insProductUserMapper.selectList(Wrappers.<InsProductUser>lambdaQuery().apply("DATE(create_time) = CURDATE() - INTERVAL 1 DAY")); |
| | | List<InsProductUser> insProductUserss = insProductUserMapper.selectList(Wrappers.<InsProductUser>lambdaQuery() |
| | | .between(InsProductUser::getCreateTime, oldStart, oldEnd)); |
| | | long persons = insProductUserss.stream().map(InsProductUser::getCreateUser).distinct().count(); |
| | | //æ¯ä¾=(ä»å¤©-æ¨å¤©)/æ¨å¤© |
| | | BigDecimal personRatio = new BigDecimal(person - persons).divide(new BigDecimal(persons == 0 ? 1 : persons), 2, BigDecimal.ROUND_HALF_UP); |
| | |
| | | |
| | | /*è¿åæ¥ä»»å¡æ¥æ¶éä¸å®æé*/ |
| | | //è·åè¿åæ¥çæ¨ªåæ |
| | | LocalDate currentDate = LocalDate.now(); |
| | | LocalDate startDate = LocalDate.parse(startTime, format); |
| | | LocalDate endDate = LocalDate.parse(endTime, format); |
| | | List<LocalDate> lastTenDays = new ArrayList<>(); |
| | | List<Long> receTenDays = new ArrayList<>(); |
| | | List<Long> finTenDays = new ArrayList<>(); |
| | | for (int i = 9; i > -1; i--) { |
| | | lastTenDays.add(currentDate.minusDays(i)); |
| | | receTenDays.add(insOrderMapper.selectCount(Wrappers.<InsOrder>lambdaQuery().eq(InsOrder::getState, 1).apply("DATE(create_time) = CURDATE() - INTERVAL " + i + " DAY"))); |
| | | finTenDays.add(insOrderMapper.selectCount(Wrappers.<InsOrder>lambdaQuery().eq(InsOrder::getState, 4).apply("DATE(create_time) = CURDATE() - INTERVAL " + i + " DAY"))); |
| | | while (!startDate.isAfter(endDate)) { |
| | | lastTenDays.add(startDate); |
| | | receTenDays.add(insOrderMapper.selectCount(Wrappers.<InsOrder>lambdaQuery() |
| | | .eq(InsOrder::getState, 1) |
| | | .between(InsOrder::getCreateTime,startDate.atStartOfDay(),startDate.atTime(23,59,59)))); |
| | | finTenDays.add(insOrderMapper.selectCount(Wrappers.<InsOrder>lambdaQuery() |
| | | .eq(InsOrder::getState, 4) |
| | | .between(InsOrder::getCreateTime,startDate.atStartOfDay(),startDate.atTime(23,59,59)))); |
| | | startDate = startDate.plusDays(1); |
| | | } |
| | | map.put("DAYS", lastTenDays); |
| | | map.put("RECETENDAYS", receTenDays); |
| | |
| | | |
| | | //æ£æµé¡¹ç®ç»è®¡ |
| | | @Override |
| | | public Map<String, Object> testProductByDay() { |
| | | public Map<String, Object> testProductByDay(String startTime,String endTime,String type) { |
| | | DateTimeFormatter format = DateTimeFormatter.ofPattern("yyyy-MM-dd"); |
| | | LocalDateTime start = LocalDate.parse(startTime, format).atStartOfDay(); |
| | | LocalDateTime end = LocalDate.parse(endTime, format).atTime(23, 59, 59); |
| | | LocalDateTime oldStart=start ; |
| | | LocalDateTime oldEnd=end ; |
| | | Map<String, Object> map = new HashMap<>(); |
| | | /*é¡¹ç®æ¥æ¶*/ |
| | | //仿¥é¡¹ç®æ¥æ¶é |
| | | Long receive = insProductMapper.selectCount(Wrappers.<InsProduct>lambdaQuery().eq(InsProduct::getState, 1).apply("DATE(create_time) = CURDATE()")); |
| | | Long receive = insProductMapper.selectCount(Wrappers.<InsProduct>lambdaQuery() |
| | | .eq(InsProduct::getState, 1) |
| | | .between(InsProduct::getCreateTime, start, end)); |
| | | map.put("RECEVICE", receive); |
| | | //æ¨æ¥é¡¹ç®æ¥æ¶é |
| | | Long received = insProductMapper.selectCount(Wrappers.<InsProduct>lambdaQuery().eq(InsProduct::getState, 1).apply("DATE(create_time) = CURDATE() - INTERVAL 1 DAY")); |
| | | Long received = insProductMapper.selectCount(Wrappers.<InsProduct>lambdaQuery() |
| | | .eq(InsProduct::getState, 1) |
| | | .between(InsProduct::getCreateTime, oldStart, oldEnd)); |
| | | //æ¯ä¾=(ä»å¤©-æ¨å¤©)/æ¨å¤© |
| | | BigDecimal ratio = new BigDecimal(receive - received).divide(new BigDecimal(received == 0 ? 1 : received), 2, BigDecimal.ROUND_HALF_UP); |
| | | map.put("RECEIVE_RATIO", ratio); |
| | | |
| | | /*项ç®å®æ*/ |
| | | //仿¥é¡¹ç®å®æé |
| | | Long finishe = insProductMapper.selectCount(Wrappers.<InsProduct>lambdaQuery().eq(InsProduct::getState, 1).isNotNull(InsProduct::getInsResult).apply("DATE(create_time) = CURDATE()")); |
| | | Long finishe = insProductMapper.selectCount(Wrappers.<InsProduct>lambdaQuery() |
| | | .eq(InsProduct::getState, 1) |
| | | .isNotNull(InsProduct::getInsResult) |
| | | .between(InsProduct::getCreateTime, start, end)); |
| | | map.put("FINISHE", finishe); |
| | | //æ¨æ¥é¡¹ç®å®æé |
| | | Long finished = insProductMapper.selectCount(Wrappers.<InsProduct>lambdaQuery().eq(InsProduct::getState, 1).isNotNull(InsProduct::getInsResult).apply("DATE(create_time) = CURDATE() - INTERVAL 1 DAY")); |
| | | Long finished = insProductMapper.selectCount(Wrappers.<InsProduct>lambdaQuery() |
| | | .eq(InsProduct::getState, 1) |
| | | .isNotNull(InsProduct::getInsResult) |
| | | .between(InsProduct::getCreateTime, oldStart, oldEnd)); |
| | | //ä»»å¡å®ææ¯ä¾=(ä»å¤©-æ¨å¤©)/æ¨å¤© |
| | | BigDecimal finishedRatio = new BigDecimal(finishe - finished).divide(new BigDecimal(finished == 0 ? 1 : finished), 2, BigDecimal.ROUND_HALF_UP); |
| | | map.put("FINISHE_RATIO", finishedRatio); |
| | |
| | | |
| | | /*仿¥é¡¹ç®åæ ¼ç*/ |
| | | //仿¥å®æéä¸çåæ ¼é/仿¥å®æé |
| | | Long accept = insProductMapper.selectCount(Wrappers.<InsProduct>lambdaQuery().eq(InsProduct::getState, 1).eq(InsProduct::getInsResult,1).apply("DATE(create_time) = CURDATE()")); |
| | | Long accept = insProductMapper.selectCount(Wrappers.<InsProduct>lambdaQuery() |
| | | .eq(InsProduct::getState, 1) |
| | | .eq(InsProduct::getInsResult, 1) |
| | | .between(InsProduct::getCreateTime, start, end)); |
| | | map.put("ACCEPT", accept); |
| | | BigDecimal acceptRate = new BigDecimal(accept).divide(new BigDecimal(finishe == 0 ? 1 : finishe), 2, BigDecimal.ROUND_HALF_UP); |
| | | map.put("ACCEPT_RATE_TODAY", acceptRate); |
| | |
| | | |
| | | /*è¿åæ¥çé¡¹ç®æ¥æ¶éä¸å®æé*/ |
| | | //è·åè¿åæ¥çæ¨ªåæ |
| | | LocalDate currentDate = LocalDate.now(); |
| | | LocalDate startDate = LocalDate.parse(startTime, format); |
| | | LocalDate endDate = LocalDate.parse(endTime, format); |
| | | List<LocalDate> lastTenDays = new ArrayList<>(); |
| | | List<Long> receTenDays = new ArrayList<>(); |
| | | List<Long> finTenDays = new ArrayList<>(); |
| | | for (int i = 9; i > -1; i--) { |
| | | lastTenDays.add(currentDate.minusDays(i)); |
| | | receTenDays.add(insProductMapper.selectCount(Wrappers.<InsProduct>lambdaQuery().eq(InsProduct::getState, 1).apply("DATE(create_time) = CURDATE() - INTERVAL " + i + " DAY"))); |
| | | finTenDays.add(insProductMapper.selectCount(Wrappers.<InsProduct>lambdaQuery().eq(InsProduct::getState, 1).isNotNull(InsProduct::getInsResult).apply("DATE(create_time) = CURDATE() - INTERVAL " + i + " DAY"))); |
| | | while (!startDate.isAfter(endDate)) { |
| | | lastTenDays.add(startDate); |
| | | receTenDays.add(insProductMapper.selectCount(Wrappers.<InsProduct>lambdaQuery() |
| | | .eq(InsProduct::getState, 1) |
| | | .between(InsProduct::getCreateTime,startDate.atStartOfDay(),startDate.atTime(23,59,59)))); |
| | | finTenDays.add(insProductMapper.selectCount(Wrappers.<InsProduct>lambdaQuery() |
| | | .eq(InsProduct::getState, 1) |
| | | .isNotNull(InsProduct::getInsResult) |
| | | .between(InsProduct::getCreateTime,startDate.atStartOfDay(),startDate.atTime(23,59,59)))); |
| | | startDate = startDate.plusDays(1); |
| | | } |
| | | map.put("DAYS", lastTenDays); |
| | | map.put("RECETENDAYS", receTenDays); |
| | |
| | | .in(InsOrder::getInsState, insState) |
| | | .apply("DATE(create_time) = CURDATE() - INTERVAL " + j + " DAY")); |
| | | //妿å½åç»å½äººæ¯æµè¯å·¥ç¨å¸æè
æ¯æ£æµç»é¿,éè¦è¿æ»¤åºæ£éªäººæ¯ä»ä»¬ç订åæè
æ¯è¿æ²¡æ£éªç订å |
| | | if (name.equals("æµè¯å·¥ç¨å¸") || name.equals("æ£æµç»é¿")){ |
| | | if (name.equals("æµè¯å·¥ç¨å¸") || name.equals("æ£æµç»é¿")) { |
| | | insOrders = insOrders.stream().filter(insOrder -> { |
| | | List<InsSample> insSamples = insSampleMapper.selectList(Wrappers.<InsSample>lambdaQuery().eq(InsSample::getInsOrderId, insOrder.getId())); |
| | | List<Integer> sampleId = insSamples.stream().map(InsSample::getId).collect(Collectors.toList()); |
| | | List<InsSampleUser> insSampleUsers = insSampleUserMapper.selectList(Wrappers.<InsSampleUser>lambdaQuery() |
| | | .in(InsSampleUser::getInsSampleId, sampleId) |
| | | .eq(InsSampleUser::getState, 0) //æ£éªäºº |
| | | .in(InsSampleUser::getInsSampleId, sampleId)); |
| | | ); |
| | | return insSampleUsers.size() == 0 || insSampleUsers.stream().map(InsSampleUser::getUserId).collect(Collectors.toList()).contains(userId); |
| | | }).collect(Collectors.toList()); |
| | | } |
| | | //妿å½åç»å½äººæ¯éæ ·å,éè¿æ»¤åºååçéæ ·åæ¯å½å人ç订å |
| | | else if (name.equals("éæ ·å")){ |
| | | else if (name.equals("éæ ·å")) { |
| | | insOrders = insOrders.stream().filter(insOrder -> |
| | | ObjectUtils.isNotEmpty(insOrder.getIssueUser()) && insOrder.getIssueUser().equals(userId) |
| | | ).collect(Collectors.toList()); |
| | |
| | | LocalDateTime endTime = localDate.plusDays(1).atStartOfDay().minusSeconds(1); |
| | | return scheduleMapper.selectList(Wrappers.<Schedule>lambdaQuery().eq(Schedule::getUserId, userId).between(Schedule::getScheduleTime, startTime, endTime)); |
| | | } |
| | | |
| | | //é¦é¡µ-->åç«ç¹çå·¥æ¶ |
| | | @Override |
| | | public Map<String, Double> manHourByStation(String startTime, String endTime) { |
| | | DateTimeFormatter format = DateTimeFormatter.ofPattern("yyyy-MM-dd"); |
| | | LocalDateTime start = LocalDate.parse(startTime, format).atStartOfDay(); |
| | | LocalDateTime end = LocalDate.parse(endTime, format).atTime(23, 59, 59); |
| | | //æ¥è¯¢è¿ä¸ªæ¶é´å
ææçå·¥æ¶ |
| | | List<AuxiliaryOutputWorkingHours> auxiliaryOutputWorkingHours = auxiliaryOutputWorkingHoursMapper.selectList(Wrappers.<AuxiliaryOutputWorkingHours>lambdaQuery() |
| | | .between(AuxiliaryOutputWorkingHours::getCreateTime, start, end)); |
| | | //æ ¹æ®æ£éªé¡¹æ¥åºæ¥çç«ç¹è¿è¡åç±» |
| | | List<AuxiliaryOutputWorkingHoursDto> outputWorkingHoursDtos = auxiliaryOutputWorkingHours.stream().map(auxiliaryOutputWorkingHours1 -> { |
| | | AuxiliaryOutputWorkingHoursDto auxiliaryOutputWorkingHoursDto = new AuxiliaryOutputWorkingHoursDto(); |
| | | BeanUtils.copyProperties(auxiliaryOutputWorkingHours1, auxiliaryOutputWorkingHoursDto); |
| | | InsProduct insProduct = insProductMapper.selectById(auxiliaryOutputWorkingHours1.getInsProductId()); |
| | | auxiliaryOutputWorkingHoursDto.setSonLaboratory(insProduct.getSonLaboratory()); |
| | | return auxiliaryOutputWorkingHoursDto; |
| | | }).collect(Collectors.toList()); |
| | | Map<String, Double> map = outputWorkingHoursDtos.stream() |
| | | .collect(Collectors.groupingBy( |
| | | AuxiliaryOutputWorkingHoursDto::getSonLaboratory, |
| | | Collectors.summingDouble(AuxiliaryOutputWorkingHours::getOutputWorkTime))); |
| | | return map; |
| | | } |
| | | |
| | | //é¦é¡µ-->åç«ç¹å·¥æ¶æ¯ä¸ªäººæå ç¾åæ¯ |
| | | @Override |
| | | public Map<String, Map<String, Double>> manHourByPerson(String startTime, String endTime) { |
| | | DateTimeFormatter format = DateTimeFormatter.ofPattern("yyyy-MM-dd"); |
| | | LocalDateTime start = LocalDate.parse(startTime, format).atStartOfDay(); |
| | | LocalDateTime end = LocalDate.parse(endTime, format).atTime(23, 59, 59); |
| | | //æ¥è¯¢è¿ä¸ªæ¶é´å
ææçå·¥æ¶ |
| | | List<AuxiliaryOutputWorkingHours> auxiliaryOutputWorkingHours = auxiliaryOutputWorkingHoursMapper.selectList(Wrappers.<AuxiliaryOutputWorkingHours>lambdaQuery() |
| | | .between(AuxiliaryOutputWorkingHours::getCreateTime, start, end)); |
| | | //æ ¹æ®æ£éªé¡¹æ¥åºæ¥çç«ç¹è¿è¡åç±» |
| | | List<AuxiliaryOutputWorkingHoursDto> outputWorkingHoursDtos = auxiliaryOutputWorkingHours.stream().map(auxiliaryOutputWorkingHours1 -> { |
| | | AuxiliaryOutputWorkingHoursDto auxiliaryOutputWorkingHoursDto = new AuxiliaryOutputWorkingHoursDto(); |
| | | BeanUtils.copyProperties(auxiliaryOutputWorkingHours1, auxiliaryOutputWorkingHoursDto); |
| | | InsProduct insProduct = insProductMapper.selectById(auxiliaryOutputWorkingHours1.getInsProductId()); |
| | | auxiliaryOutputWorkingHoursDto.setSonLaboratory(insProduct.getSonLaboratory()); |
| | | return auxiliaryOutputWorkingHoursDto; |
| | | }).collect(Collectors.toList()); |
| | | Map<String, Map<String, Double>> mapMap = outputWorkingHoursDtos.stream() |
| | | .collect(Collectors.groupingBy( |
| | | AuxiliaryOutputWorkingHoursDto::getSonLaboratory, |
| | | Collectors.groupingBy( |
| | | t -> userMapper.selectById(t.getCheck()).getName(), |
| | | Collectors.summingDouble(AuxiliaryOutputWorkingHours::getOutputWorkTime)))); |
| | | |
| | | return mapMap; |
| | | } |
| | | } |