From 83b51a5a0774ea8ecb9a06304af3b956a21307c8 Mon Sep 17 00:00:00 2001 From: pjb <123456> Date: 星期六, 08 三月 2025 09:06:55 +0800 Subject: [PATCH] CUT库条码T开头,截取后10位 --- zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/controller/statistics/ViewStayTimeController.java | 91 +++++++++++++++++++++++---------------------- 1 files changed, 46 insertions(+), 45 deletions(-) diff --git a/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/controller/statistics/ViewStayTimeController.java b/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/controller/statistics/ViewStayTimeController.java index e0927f0..2065039 100644 --- a/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/controller/statistics/ViewStayTimeController.java +++ b/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/controller/statistics/ViewStayTimeController.java @@ -1,45 +1,46 @@ -package com.zy.asrs.wms.asrs.controller.statistics; - -import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; -import com.zy.asrs.framework.common.R; -import com.zy.asrs.wms.asrs.entity.statistics.ViewStayTime; -import com.zy.asrs.wms.asrs.mapper.statistics.ViewStayTimeMapper; -import com.zy.asrs.wms.common.annotation.CacheData; -import com.zy.asrs.wms.common.domain.BaseParam; -import com.zy.asrs.wms.common.domain.PageParam; -import com.zy.asrs.wms.system.controller.BaseController; -import com.zy.asrs.wms.utils.ExcelUtil; -import org.springframework.beans.factory.annotation.Autowired; -import org.springframework.security.access.prepost.PreAuthorize; -import org.springframework.web.bind.annotation.*; - -import javax.servlet.http.HttpServletResponse; -import java.util.Map; - -@RestController -@RequestMapping("/api") -public class ViewStayTimeController extends BaseController { - - @Autowired - private ViewStayTimeMapper viewStayTimeMapper; - - @PreAuthorize("hasAuthority('asrs:viewStayTime:list')") - @PostMapping("/viewStayTime/page") - @CacheData(tableName = {"view_stay_time", "man_loc_detl", "man_loc"}) - public R page(@RequestBody Map<String, Object> map) { - BaseParam baseParam = buildParam(map, BaseParam.class); - PageParam<ViewStayTime, BaseParam> pageParam = new PageParam<>(baseParam, ViewStayTime.class); - QueryWrapper<ViewStayTime> queryWrapper = pageParam.buildWrapper(true, wrapper -> wrapper.orderByDesc("stay_time")); - PageParam<ViewStayTime, BaseParam> page = viewStayTimeMapper.selectPage(pageParam, queryWrapper); - return R.ok().add(page); - } - - @PreAuthorize("hasAuthority('asrs:viewStayTime:list')") - @PostMapping("/viewStayTime/export") - @CacheData(tableName = {"view_stay_time", "man_loc_detl", "man_loc"}) - public void export(@RequestBody Map<String, Object> map, HttpServletResponse response) throws Exception { - QueryWrapper<ViewStayTime> wrapper = new QueryWrapper<>(); - ExcelUtil.build(ExcelUtil.create(viewStayTimeMapper.selectList(wrapper), ViewStayTime.class), response); - } - -} +package com.zy.asrs.wms.asrs.controller.statistics; + +import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; +import com.zy.asrs.framework.common.R; +import com.zy.asrs.wms.asrs.entity.statistics.ViewStayTime; +import com.zy.asrs.wms.asrs.mapper.statistics.ViewStayTimeMapper; +import com.zy.asrs.wms.common.annotation.CacheData; +import com.zy.asrs.wms.common.domain.BaseParam; +import com.zy.asrs.wms.common.domain.PageParam; +import com.zy.asrs.wms.system.controller.BaseController; +import com.zy.asrs.wms.utils.ExcelUtil; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.security.access.prepost.PreAuthorize; +import org.springframework.web.bind.annotation.*; + +import javax.servlet.http.HttpServletResponse; +import java.util.Map; + +@RestController +@RequestMapping("/api") +public class ViewStayTimeController extends BaseController { + + @Autowired + private ViewStayTimeMapper viewStayTimeMapper; + + @PreAuthorize("hasAuthority('asrs:viewStayTime:list')") + @PostMapping("/viewStayTime/page") + @CacheData(tableName = {"view_stay_time", "man_loc_detl", "man_loc"}) + public R page(@RequestBody Map<String, Object> map) { + BaseParam baseParam = buildParam(map, BaseParam.class); + PageParam<ViewStayTime, BaseParam> pageParam = new PageParam<>(baseParam, ViewStayTime.class); + QueryWrapper<ViewStayTime> queryWrapper = pageParam.buildWrapper(true, wrapper -> wrapper.orderByDesc("stay_time")); + PageParam<ViewStayTime, BaseParam> page = viewStayTimeMapper.selectPage(pageParam, queryWrapper); + return R.ok().add(page); + } + + @PreAuthorize("hasAuthority('asrs:viewStayTime:list')") + @PostMapping("/viewStayTime/export") + public void export(@RequestBody Map<String, Object> map, HttpServletResponse response) throws Exception { + BaseParam baseParam = buildParam(map, BaseParam.class); + PageParam<ViewStayTime, BaseParam> pageParam = new PageParam<>(baseParam, ViewStayTime.class); + QueryWrapper<ViewStayTime> queryWrapper = pageParam.buildWrapper(true, wrapper -> wrapper.orderByDesc("stay_time")); + ExcelUtil.build(ExcelUtil.create(viewStayTimeMapper.selectList(queryWrapper), ViewStayTime.class), response); + } + +} -- Gitblit v1.9.1