| | |
| | | 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") |
| | | .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") |
| | | .gt("PlanDate",startDate).groupBy("CAST(PlanDate AS DATE)") |
| | | .orderByAsc("CAST(PlanDate AS DATE)"); |
| | | List<Map> list=kBBTJPDrawingBPMapper.selectMaps((QueryWrapper)queryWrapper); |
| | | |
| | | List<Map<String, Object>> listTasking1 = baseMapper.selectMaps(new QueryWrapper<TaskingLog>() |