| | |
|---|
| | | @PostMapping("/findDayNotCompleteOutput") |
|---|
| | | @ResponseBody |
|---|
| | | public Result findDayNotCompleteOutput(@RequestBody Map<String, String> map) { |
|---|
| | | int dayCount=0-Integer.valueOf(map.get("dayCount").toString()); |
|---|
| | | int dayCount=1-Integer.valueOf(map.get("dayCount").toString()); |
|---|
| | | Calendar cal = Calendar.getInstance(); |
|---|
| | | //设置当前时间 |
|---|
| | | cal.setTime(new Date()); |
|---|
| | |
|---|
| | | cal.set(Calendar.MILLISECOND, 0); |
|---|
| | | cal.add(Calendar.DATE, dayCount); |
|---|
| | | QueryWrapper<KBBTJPDrawingBP> queryWrapper = new QueryWrapper<>(); |
|---|
| | | queryWrapper.select("scan_id,(task_quantity-isNull(report_count,0)) as notComplete,isNull((length*width*(task_quantity-isNull(report_count,0)))/1000000,0) as area_sum"). |
|---|
| | | gt("CreateDate",cal.getTime()).apply("task_quantity>isNull(report_count,0)"); |
|---|
| | | queryWrapper.select("OrderNo,(sum(task_quantity-isNull(report_count,0))) as notComplete,sum(isNull((length*width*(task_quantity-isNull(report_count,0)))/1000000,0)) as area_sum"). |
|---|
| | | gt("PlanDate",cal.getTime()).having("sum(task_quantity-isNull(report_count,0))>0") |
|---|
| | | .groupBy("OrderNo"); |
|---|
| | | List<Map> list=kBBTJPDrawingBPMapper.selectMaps((QueryWrapper)queryWrapper); |
|---|
| | | return Result.build(200,"成功",list); |
|---|
| | | } |
|---|
| | |
|---|
| | | cal.set(Calendar.MINUTE, 0); |
|---|
| | | cal.set(Calendar.SECOND, 0); |
|---|
| | | cal.set(Calendar.MILLISECOND, 0); |
|---|
| | | cal.add(Calendar.DATE, 0-dayCount); |
|---|
| | | cal.add(Calendar.DATE, 1-dayCount); |
|---|
| | | Date startDate = cal.getTime(); |
|---|
| | | |
|---|
| | | QueryWrapper<KBBTJPDrawingBP> queryWrapper = new QueryWrapper<>(); |
|---|
| | | queryWrapper.select("CAST(CreateDate AS DATE) AS CreateDate,isNull(sum(task_quantity),0) as task_quantity_sum,isNull(sum(length*width*task_quantity)/1000000,0) as area_sum") |
|---|
| | | .gt("CreateDate",startDate).groupBy("CAST(CreateDate AS DATE)") |
|---|
| | | .orderByAsc("CAST(CreateDate AS DATE)");; |
|---|
| | | queryWrapper.select("CAST(PlanDate AS DATE) AS CreateDate,isNull(sum(task_quantity),0) as task_quantity_sum,isNull(sum(length*width*task_quantity)/1000000,0) as area_sum") |
|---|
| | | .gt("PlanDate",startDate).groupBy("CAST(PlanDate AS DATE)") |
|---|
| | | .orderByAsc("CAST(PlanDate AS DATE)");; |
|---|
| | | List<Map> list=kBBTJPDrawingBPMapper.selectMaps((QueryWrapper)queryWrapper); |
|---|
| | | List<Map> resultDate=new ArrayList<>(); |
|---|
| | | for (int i=0;i<dayCount;i++){ |
|---|
