| | |
| | | import com.vincent.rsf.server.manager.entity.StockStatistic; |
| | | import com.vincent.rsf.server.manager.enums.TaskType; |
| | | import com.vincent.rsf.server.manager.service.StockStatisticService; |
| | | import com.vincent.rsf.server.manager.utils.buildPageRowsUtils; |
| | | import com.vincent.rsf.server.system.controller.BaseController; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.security.access.prepost.PreAuthorize; |
| | |
| | | public R page(@RequestBody Map<String, Object> map) { |
| | | BaseParam baseParam = buildParam(map, BaseParam.class); |
| | | PageParam<StockStatistic, BaseParam> pageParam = new PageParam<>(baseParam, StockStatistic.class); |
| | | return R.ok().add(stockStatisticService.page(pageParam, pageParam.buildWrapper(true))); |
| | | PageParam<StockStatistic, BaseParam> page = stockStatisticService.page(pageParam, pageParam.buildWrapper(true)); |
| | | buildPageRowsUtils.userNameMap(page.getRecords()); |
| | | return R.ok().add(page); |
| | | } |
| | | |
| | | @PreAuthorize("hasAuthority('manager:stockStatistic:list')") |
| | |
| | | "MAX(maktx) AS maktx, matnr_code, MAX(batch) AS batch, " + |
| | | "SUM(anfme) AS anfme, MAX(unit) AS unit"); |
| | | wrapper.groupBy("day_time, task_type, task_status, matnr_code"); |
| | | return R.ok().add(stockStatisticService.page(pageParam, wrapper)); |
| | | PageParam<StockStatistic, BaseParam> page = stockStatisticService.page(pageParam, wrapper); |
| | | buildPageRowsUtils.userNameMap(page.getRecords()); |
| | | return R.ok().add(page); |
| | | } |
| | | |
| | | @PreAuthorize("hasAuthority('manager:stockStatistic:list')") |
| | |
| | | "MAX(maktx) AS maktx, matnr_code, MAX(batch) AS batch, " + |
| | | "SUM(anfme) AS anfme, MAX(unit) AS unit"); |
| | | wrapper.groupBy("day_time, task_type, task_status, matnr_code"); |
| | | return R.ok().add(stockStatisticService.page(pageParam, wrapper)); |
| | | PageParam<StockStatistic, BaseParam> page = stockStatisticService.page(pageParam, wrapper); |
| | | buildPageRowsUtils.userNameMap(page.getRecords()); |
| | | return R.ok().add(page); |
| | | } |
| | | |
| | | @PreAuthorize("hasAuthority('manager:stockStatistic:list')") |
| | |
| | | "MAX(maktx) AS maktx, matnr_code, MAX(batch) AS batch, SUM(anfme) AS anfme, " + |
| | | "MAX(unit) AS unit, create_by, update_by, create_time, update_time"); |
| | | wrapper.groupBy("loc_code, day_time, task_type, task_status, barcode, matnr_code, create_by, update_by, create_time, update_time"); |
| | | return R.ok().add(stockStatisticService.page(pageParam, wrapper)); |
| | | PageParam<StockStatistic, BaseParam> page = stockStatisticService.page(pageParam, wrapper); |
| | | buildPageRowsUtils.userNameMap(page.getRecords()); |
| | | return R.ok().add(page); |
| | | } |
| | | |
| | | @PreAuthorize("hasAuthority('manager:stockStatistic:list')") |
| | |
| | | "MAX(maktx) AS maktx, matnr_code, MAX(batch) AS batch, SUM(anfme) AS anfme, " + |
| | | "MAX(unit) AS unit, create_by, update_by, create_time, update_time"); |
| | | wrapper.groupBy("loc_code, day_time, task_type, task_status, barcode, matnr_code, create_by, update_by, create_time, update_time"); |
| | | return R.ok().add(stockStatisticService.page(pageParam, wrapper)); |
| | | PageParam<StockStatistic, BaseParam> page = stockStatisticService.page(pageParam, wrapper); |
| | | buildPageRowsUtils.userNameMap(page.getRecords()); |
| | | return R.ok().add(page); |
| | | } |
| | | |
| | | @PreAuthorize("hasAuthority('manager:stockStatistic:list')") |
| | |
| | | "SUM( CASE WHEN task_type = 1 THEN anfme ELSE 0 END ) in_anfme," + |
| | | "SUM( CASE WHEN task_type = 101 THEN anfme ELSE 0 END ) out_anfme"); |
| | | wrapper.in("task_type", Arrays.asList(TaskType.TASK_TYPE_IN.type, TaskType.TASK_TYPE_OUT.type)).groupBy("day_time"); |
| | | return R.ok().add(stockStatisticService.page(pageParam, wrapper)); |
| | | PageParam<StockStatistic, BaseParam> page = stockStatisticService.page(pageParam, wrapper); |
| | | buildPageRowsUtils.userNameMap(page.getRecords()); |
| | | return R.ok().add(page); |
| | | } |
| | | |
| | | @PreAuthorize("hasAuthority('manager:stockStatistic:list')") |