| | |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | 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.CostStatisticsDto; |
| | | import com.yuanchu.mom.mapper.InsOrderMapper; |
| | | import com.yuanchu.mom.mapper.InsProductMapper; |
| | | import com.yuanchu.mom.mapper.InsProductUserMapper; |
| | | import com.yuanchu.mom.pojo.InsOrder; |
| | | import com.yuanchu.mom.pojo.InsProduct; |
| | | import com.yuanchu.mom.pojo.InsProductUser; |
| | | import com.yuanchu.mom.mapper.*; |
| | | import com.yuanchu.mom.pojo.*; |
| | | import com.yuanchu.mom.service.ReportService; |
| | | import com.yuanchu.mom.utils.QueryWrappers; |
| | | import lombok.AllArgsConstructor; |
| | |
| | | import java.time.LocalDate; |
| | | import java.time.LocalDateTime; |
| | | import java.time.LocalTime; |
| | | import java.time.format.DateTimeFormatter; |
| | | import java.util.ArrayList; |
| | | import java.util.HashMap; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | import java.util.stream.Collectors; |
| | | |
| | | @Service |
| | | @AllArgsConstructor |
| | |
| | | private InsOrderMapper insOrderMapper; |
| | | private InsProductUserMapper insProductUserMapper; |
| | | private InsProductMapper insProductMapper; |
| | | private GetLook getLook; |
| | | private ScheduleMapper scheduleMapper; |
| | | private UserMapper userMapper; |
| | | |
| | | //每日业务统计 |
| | | @Override |
| | |
| | | /*近十日的项目接收量与完成量*/ |
| | | return map; |
| | | } |
| | | |
| | | //首页-->日历任务图 |
| | | @Override |
| | | public Map<String, Object> calendarWorkByWeek() { |
| | | Map<String, Object> map = new HashMap<>(); |
| | | List<Integer> insState=new ArrayList<>(); |
| | | insState.add(0); |
| | | insState.add(1); |
| | | /*获取后一周日期*/ |
| | | LocalDate currentDate = LocalDate.now(); |
| | | List<LocalDate> weekDays = new ArrayList<>(); |
| | | for (int i = 0; i <7; i++) { |
| | | weekDays.add(currentDate.plusDays(i)); |
| | | //查询当天需要检测的委托订单 |
| | | List<InsOrder> insOrders = insOrderMapper.selectList(Wrappers.<InsOrder>lambdaQuery().eq(InsOrder::getState, 1).in(InsOrder::getInsState, insState).apply("DATE(create_time) = CURDATE() - INTERVAL " + i + " DAY")); |
| | | List<Map<String,Object>> works = insOrders.stream().map(insOrder -> { |
| | | HashMap<String, Object> hashMap = new HashMap<>(); |
| | | hashMap.put("text","委托订单" + insOrder.getEntrustCode() + "检测"); |
| | | hashMap.put("type",insOrder.getType()); |
| | | User user = userMapper.selectById(insOrder.getCreateUser()); |
| | | hashMap.put("name", user.getName()); |
| | | return hashMap; |
| | | }).collect(Collectors.toList()); |
| | | map.put("work"+i, works); |
| | | } |
| | | map.put("weekDays", weekDays); |
| | | return map; |
| | | } |
| | | |
| | | //首页-->添加日程 |
| | | @Override |
| | | public int addSchedule(String time, String text) { |
| | | //获取当前用户id |
| | | Integer userId = getLook.selectPowerByMethodAndUserId(null).get("userId"); |
| | | Schedule schedule = new Schedule(); |
| | | schedule.setUserId(userId); |
| | | schedule.setScheduleTime(LocalDateTime.parse(time, DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"))); |
| | | schedule.setText(text); |
| | | return scheduleMapper.insert(schedule); |
| | | } |
| | | |
| | | //首页-->我的日程 |
| | | @Override |
| | | public List<Schedule> ScheduleByMe(String date) { |
| | | //获取当前用户id |
| | | Integer userId = getLook.selectPowerByMethodAndUserId(null).get("userId"); |
| | | LocalDate localDate = LocalDate.parse(date, DateTimeFormatter.ofPattern("yyyy-MM-dd")); |
| | | LocalDateTime startTime = localDate.atStartOfDay(); |
| | | LocalDateTime endTime = localDate.plusDays(1).atStartOfDay().minusSeconds(1); |
| | | return scheduleMapper.selectList(Wrappers.<Schedule>lambdaQuery().eq(Schedule::getUserId,userId).between(Schedule::getScheduleTime,startTime,endTime)); |
| | | } |
| | | } |