From 35d9446131124e12616c7b6b9dfd79e23d20e1c9 Mon Sep 17 00:00:00 2001 From: cuijian <cuijian@xalxzn.com> Date: 星期五, 06 六月 2025 17:23:11 +0800 Subject: [PATCH] 工具台账功能 --- lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/ToolsStocktakingBoundController.java | 20 ++ lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/IToolsStocktakingBoundDetailService.java | 2 lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/OutStoreDetailController.java | 20 ++ lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/ToolSharpeningController.java | 20 ++ lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/ToolsStocktakingBoundDetailMapper.java | 3 lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/ToolsSharpeningMapper.xml | 21 ++ lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/IToolsLossBoundDetailService.java | 2 lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/InStoreDetailMapper.xml | 3 lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/ToolsSharpeningServiceImpl.java | 32 +++ lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/ToolsLossBoundController.java | 24 ++ lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/ToolLedgerDetailController.java | 19 ++ lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/ToolLedgerController.java | 19 ++ lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/ToolLedgerMapper.xml | 29 +++ lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/OutStoreDetailMapper.xml | 38 ++++ lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/ToolsLossBoundDetailMapper.xml | 24 ++ lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/IToolLedgerService.java | 4 lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/IOutStoreDetailService.java | 2 lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/ToolsStocktakingBoundDetailMapper.xml | 26 ++ lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/ToolLedgerDetailMapper.java | 2 lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/ToolLedgerServiceImpl.java | 38 ++++ lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/ToolsStocktakingBoundDetailServiceImpl.java | 32 +++ lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/InboundOrderServiceImpl.java | 17 + lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/ToolLedgerDetailMapper.xml | 20 ++ lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/IToolsSharpeningService.java | 2 lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/ToolsLossBoundDetailMapper.java | 3 lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/ToolLedgerMapper.java | 5 lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/ToolsSharpeningMapper.java | 4 lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/IToolLedgerDetailService.java | 2 lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/OutStoreDetailServiceImpl.java | 33 +++ lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/ToolLedgerDetailServiceImpl.java | 25 ++ lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/ToolsLossBoundDetailServiceImpl.java | 33 +++ lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/OutStoreDetailMapper.java | 3 32 files changed, 521 insertions(+), 6 deletions(-) diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/OutStoreDetailController.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/OutStoreDetailController.java index 68bf76b..1871876 100644 --- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/OutStoreDetailController.java +++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/OutStoreDetailController.java @@ -16,6 +16,7 @@ import org.jeecg.common.system.vo.LoginUser; import org.jeecg.common.util.oConvertUtils; import org.jeecg.modules.tms.entity.OutStoreDetail; +import org.jeecg.modules.tms.entity.ToolLedger; import org.jeecg.modules.tms.entity.vo.OutStoreDetailVo; import org.jeecg.modules.tms.service.IOutStoreDetailService; @@ -197,4 +198,23 @@ return super.importExcel(request, response, OutStoreDetail.class); } + /** + * 宸ュ叿鍙拌处-鍑哄簱瀛愰〉闈㈠垪琛ㄦ煡璇� + * + * @param outStoreDetail + * @param pageNo + * @param pageSize + * @param query + * @return + */ + @ApiOperation(value="宸ュ叿鍙拌处-鍑哄簱瀛愰〉闈㈠垪琛ㄦ煡璇�", notes="宸ュ叿鍙拌处-鍑哄簱瀛愰〉闈㈠垪琛ㄦ煡璇�") + @GetMapping(value = "/outStoreDetailList") + public Result<?> outStoreDetailList(OutStoreDetail outStoreDetail, + @RequestParam(name="pageNo", defaultValue="1") Integer pageNo, + @RequestParam(name="pageSize", defaultValue="10") Integer pageSize, + @RequestParam Map<String, String> query) { + IPage<Map<String, Object>> pageList = outStoreDetailService.outStoreDetailList(pageNo,pageSize, query); + return Result.OK(pageList); + } + } diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/ToolLedgerController.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/ToolLedgerController.java index 0d98d03..4a74035 100644 --- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/ToolLedgerController.java +++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/ToolLedgerController.java @@ -215,4 +215,23 @@ return super.importExcel(request, response, ToolLedger.class); } + /** + * 宸ュ叿鍙拌处-鍒楄〃鏌ヨ + * + * @param toolLedger + * @param pageNo + * @param pageSize + * @param query + * @return + */ + @ApiOperation(value="宸ュ叿鍙拌处-鍒楄〃鏌ヨ", notes="宸ュ叿鍙拌处-鍒楄〃鏌ヨ") + @GetMapping(value = "/toolLedgerList") + public Result<?> toolLedgerList(ToolLedger toolLedger, + @RequestParam(name="pageNo", defaultValue="1") Integer pageNo, + @RequestParam(name="pageSize", defaultValue="10") Integer pageSize, + @RequestParam Map<String, String> query) { + IPage<Map<String, Object>> pageList = toolLedgerService.toolLedgerList(pageNo,pageSize, query); + return Result.OK(pageList); + } + } diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/ToolLedgerDetailController.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/ToolLedgerDetailController.java index d7b84a1..45e226a 100644 --- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/ToolLedgerDetailController.java +++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/ToolLedgerDetailController.java @@ -213,4 +213,23 @@ return Result.OK(pageList); } + /** + * 宸ュ叿鍙拌处-鏌ヨ鎶婂彿 + * + * @param toolLedgerDetail + * @param pageNo + * @param pageSize + * @param query + * @return + */ + @ApiOperation(value="宸ュ叿鍙拌处-鏌ヨ鎶婂彿", notes="宸ュ叿鍙拌处-鏌ヨ鎶婂彿") + @GetMapping(value = "/queryToolLedgerDetailList") + public Result<?> queryToolLedgerDetailList(ToolLedgerDetail toolLedgerDetail, + @RequestParam(name="pageNo", defaultValue="1") Integer pageNo, + @RequestParam(name="pageSize", defaultValue="10") Integer pageSize, + @RequestParam Map<String, String> query) { + IPage<Map<String, Object>> pageList = toolLedgerDetailService.queryToolLedgerDetailList(pageNo, pageSize, query); + return Result.OK(pageList); + } + } diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/ToolSharpeningController.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/ToolSharpeningController.java index bd1031a..f514f72 100644 --- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/ToolSharpeningController.java +++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/ToolSharpeningController.java @@ -6,6 +6,7 @@ import org.jeecg.common.api.vo.Result; import org.jeecg.common.aspect.annotation.AutoLog; import org.jeecg.common.system.query.QueryGenerator; +import org.jeecg.modules.tms.entity.OutStoreDetail; import org.jeecg.modules.tms.entity.ToolLedger; import org.jeecg.modules.tms.entity.ToolSharpening; import org.jeecg.modules.tms.entity.ToolsLossBoundDetail; @@ -115,4 +116,23 @@ toolSharpeningService.removeById(id); return Result.OK("鍒犻櫎鎴愬姛!"); } + + /** + * 宸ュ叿鍙拌处-鍒冪(瀛愰〉闈㈠垪琛ㄦ煡璇� + * + * @param toolSharpening + * @param pageNo + * @param pageSize + * @param query + * @return + */ + @ApiOperation(value="宸ュ叿鍙拌处-鍒冪(瀛愰〉闈㈠垪琛ㄦ煡璇�", notes="宸ュ叿鍙拌处-鍒冪(瀛愰〉闈㈠垪琛ㄦ煡璇�") + @GetMapping(value = "/toolSharpeningList") + public Result<?> toolSharpeningList(ToolSharpening toolSharpening, + @RequestParam(name="pageNo", defaultValue="1") Integer pageNo, + @RequestParam(name="pageSize", defaultValue="10") Integer pageSize, + @RequestParam Map<String, String> query) { + IPage<Map<String, Object>> pageList = toolSharpeningService.toolSharpeningList(pageNo,pageSize, query); + return Result.OK(pageList); + } } diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/ToolsLossBoundController.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/ToolsLossBoundController.java index d610f05..8641d9c 100644 --- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/ToolsLossBoundController.java +++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/ToolsLossBoundController.java @@ -13,10 +13,7 @@ import org.jeecg.common.system.query.QueryGenerator; import org.jeecg.common.system.vo.LoginUser; import org.jeecg.common.util.oConvertUtils; -import org.jeecg.modules.tms.entity.OutboundDetail; -import org.jeecg.modules.tms.entity.OutboundOrder; -import org.jeecg.modules.tms.entity.ToolsLossBound; -import org.jeecg.modules.tms.entity.ToolsLossBoundDetail; +import org.jeecg.modules.tms.entity.*; import org.jeecg.modules.tms.entity.dto.LossBoundFlowDto; import org.jeecg.modules.tms.entity.dto.OutBoundOrderFlowDto; import org.jeecg.modules.tms.entity.vo.OutboundDetailVo; @@ -324,4 +321,23 @@ IPage<ToolsLossBoundDetail> pageList = toolsLossBoundDetailService.queryPageList(page, parameterMap); return Result.OK(pageList); } + + /** + * 宸ュ叿鍙拌处-鎶ユ崯瀛愰〉闈㈠垪琛ㄦ煡璇� + * + * @param toolsLossBoundDetail + * @param pageNo + * @param pageSize + * @param query + * @return + */ + @ApiOperation(value="宸ュ叿鍙拌处-鎶ユ崯瀛愰〉闈㈠垪琛ㄦ煡璇�", notes="宸ュ叿鍙拌处-鎶ユ崯瀛愰〉闈㈠垪琛ㄦ煡璇�") + @GetMapping(value = "/toolLossDetailList") + public Result<?> toolLossDetailList(ToolsLossBoundDetail toolsLossBoundDetail, + @RequestParam(name="pageNo", defaultValue="1") Integer pageNo, + @RequestParam(name="pageSize", defaultValue="10") Integer pageSize, + @RequestParam Map<String, String> query) { + IPage<Map<String, Object>> pageList = toolsLossBoundDetailService.toolLossDetailList(pageNo,pageSize, query); + return Result.OK(pageList); + } } diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/ToolsStocktakingBoundController.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/ToolsStocktakingBoundController.java index ffef65a..b818afc 100644 --- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/ToolsStocktakingBoundController.java +++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/ToolsStocktakingBoundController.java @@ -16,6 +16,7 @@ import org.jeecg.common.system.vo.LoginUser; import org.jeecg.modules.system.service.ISysBusinessCodeRuleService; import org.jeecg.modules.tms.entity.BaseTools; +import org.jeecg.modules.tms.entity.ToolSharpening; import org.jeecg.modules.tms.entity.ToolsStocktakingBound; import org.jeecg.modules.tms.entity.ToolsStocktakingBoundDetail; import org.jeecg.modules.tms.entity.dto.LossBoundFlowDto; @@ -283,4 +284,23 @@ return Result.OK("鏂囦欢瀵煎叆澶辫触锛�"); } + /** + * 宸ュ叿鍙拌处-鐩樼偣瀛愰〉闈㈠垪琛ㄦ煡璇� + * + * @param toolsStocktakingBound + * @param pageNo + * @param pageSize + * @param query + * @return + */ + @ApiOperation(value="宸ュ叿鍙拌处-鐩樼偣瀛愰〉闈㈠垪琛ㄦ煡璇�", notes="宸ュ叿鍙拌处-鐩樼偣瀛愰〉闈㈠垪琛ㄦ煡璇�") + @GetMapping(value = "/toolsStocktakingList") + public Result<?> toolsStocktakingList(ToolsStocktakingBound toolsStocktakingBound, + @RequestParam(name="pageNo", defaultValue="1") Integer pageNo, + @RequestParam(name="pageSize", defaultValue="10") Integer pageSize, + @RequestParam Map<String, String> query) { + IPage<Map<String, Object>> pageList = toolsStocktakingBoundDetailService.toolsStocktakingList(pageNo,pageSize, query); + return Result.OK(pageList); + } + } diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/OutStoreDetailMapper.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/OutStoreDetailMapper.java index 08a2c06..e4d25cf 100644 --- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/OutStoreDetailMapper.java +++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/OutStoreDetailMapper.java @@ -1,6 +1,7 @@ package org.jeecg.modules.tms.mapper; import java.util.List; +import java.util.Map; import com.baomidou.mybatisplus.core.conditions.Wrapper; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; @@ -22,4 +23,6 @@ IPage<OutStoreDetailVo> queryPageList(Page<OutStoreDetailVo> page, @Param(Constants.WRAPPER) Wrapper<OutStoreDetailVo> queryWrapper); + + public IPage<Map<String, Object>> outStoreDetailList(IPage<Map> pageData, @Param(Constants.WRAPPER) Wrapper<Map> wrapper); } diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/ToolLedgerDetailMapper.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/ToolLedgerDetailMapper.java index 190910a..b20e527 100644 --- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/ToolLedgerDetailMapper.java +++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/ToolLedgerDetailMapper.java @@ -26,4 +26,6 @@ IPage<Map<String, Object>> queryLendTool(IPage<Map> pageData, @Param(Constants.WRAPPER) Wrapper<Map> wrapper); IPage<Map<String, Object>> querySharpenTool(IPage<Map> pageData, @Param(Constants.WRAPPER) Wrapper<Map> wrapper); + + IPage<Map<String, Object>> queryToolLedgerDetailList(IPage<Map> pageData, @Param(Constants.WRAPPER) Wrapper<Map> wrapper); } diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/ToolLedgerMapper.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/ToolLedgerMapper.java index e250875..e150300 100644 --- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/ToolLedgerMapper.java +++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/ToolLedgerMapper.java @@ -1,7 +1,11 @@ package org.jeecg.modules.tms.mapper; import java.util.List; +import java.util.Map; +import com.baomidou.mybatisplus.core.conditions.Wrapper; +import com.baomidou.mybatisplus.core.metadata.IPage; +import com.baomidou.mybatisplus.core.toolkit.Constants; import org.apache.ibatis.annotations.Param; import org.jeecg.modules.tms.entity.ToolLedger; import com.baomidou.mybatisplus.core.mapper.BaseMapper; @@ -14,4 +18,5 @@ */ public interface ToolLedgerMapper extends BaseMapper<ToolLedger> { + public IPage<Map<String, Object>> toolLedgerList(IPage<Map> pageData, @Param(Constants.WRAPPER) Wrapper<Map> wrapper); } diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/ToolsLossBoundDetailMapper.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/ToolsLossBoundDetailMapper.java index 0989e79..224cf89 100644 --- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/ToolsLossBoundDetailMapper.java +++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/ToolsLossBoundDetailMapper.java @@ -10,6 +10,7 @@ import org.jeecg.modules.tms.entity.ToolsLossBoundDetail; import java.util.List; +import java.util.Map; /** * @Description: 鎹熻�楀崟鏄庣粏 @@ -38,4 +39,6 @@ IPage<ToolsLossBoundDetail> queryPageList(Page<ToolsLossBoundDetail> page, @Param(Constants.WRAPPER) Wrapper<ToolsLossBoundDetail> queryWrapper); + + public IPage<Map<String, Object>> toolLossDetailList(IPage<Map> pageData, @Param(Constants.WRAPPER) Wrapper<Map> wrapper); } diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/ToolsSharpeningMapper.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/ToolsSharpeningMapper.java index 5a951cc..5bf23b5 100644 --- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/ToolsSharpeningMapper.java +++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/ToolsSharpeningMapper.java @@ -12,6 +12,8 @@ import org.jeecg.modules.tms.entity.vo.OutboundDetailVo; import org.jeecg.modules.tms.entity.vo.ToolSharpeningVo; +import java.util.Map; + /** * @Description: tms_tool_sharpening Mapper 鎺ュ彛 * @Author: 渚澃 @@ -20,4 +22,6 @@ public interface ToolsSharpeningMapper extends BaseMapper<ToolSharpening> { IPage<ToolSharpeningVo> queryPageList(Page<ToolSharpeningVo> page, @Param(Constants.WRAPPER) Wrapper<ToolSharpeningVo> queryWrapper); + + public IPage<Map<String, Object>> toolSharpeningList(IPage<Map> pageData, @Param(Constants.WRAPPER) Wrapper<Map> wrapper); } diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/ToolsStocktakingBoundDetailMapper.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/ToolsStocktakingBoundDetailMapper.java index 06f3982..cfe725e 100644 --- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/ToolsStocktakingBoundDetailMapper.java +++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/ToolsStocktakingBoundDetailMapper.java @@ -10,6 +10,7 @@ import org.jeecg.modules.tms.entity.ToolsStocktakingBoundDetail; import java.util.List; +import java.util.Map; public interface ToolsStocktakingBoundDetailMapper extends BaseMapper<ToolsStocktakingBoundDetail> { @@ -38,4 +39,6 @@ IPage<ToolsStocktakingBoundDetail> selectByMainId(Page<ToolsStocktakingBoundDetail> page, @Param(Constants.WRAPPER) Wrapper<ToolsStocktakingBoundDetail> queryWrapper); + public IPage<Map<String, Object>> toolsStocktakingList(IPage<Map> pageData, @Param(Constants.WRAPPER) Wrapper<Map> wrapper); + } diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/InStoreDetailMapper.xml b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/InStoreDetailMapper.xml index 5dd036e..18e7b39 100644 --- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/InStoreDetailMapper.xml +++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/InStoreDetailMapper.xml @@ -7,7 +7,7 @@ t.id, t.tool_id onlyCode, t.in_storehouse_type inStorehouseType, - t.goods_shelves_id goodsShelvesId, + t10.location_code locationCode, t.in_number inNumber, t.in_storehouse_id inStorehouseId, t.inbound_time inboundTime, @@ -39,6 +39,7 @@ LEFT JOIN (select * from v_sys_dict where dict_code='in_status') t7 on t7.item_value = t3.in_status LEFT JOIN (select * from v_sys_dict where dict_code='in_bill_status') t8 on t8.item_value = t3.order_status left join (select * from v_sys_dict where dict_code='in_storehouse_type') t9 on t9.item_value = t.in_storehouse_type + left join tms_goods_shelves t10 on t10.id = t.goods_shelves_id ${ew.customSqlSegment} </select> </mapper> \ No newline at end of file diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/OutStoreDetailMapper.xml b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/OutStoreDetailMapper.xml index 1233eaf..3cf8653 100644 --- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/OutStoreDetailMapper.xml +++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/OutStoreDetailMapper.xml @@ -84,4 +84,42 @@ </choose> ${ew.customSqlSegment} </select> + + <select id="outStoreDetailList" resultType="map" parameterType="String"> + SELECT + t1.id, + t1.tool_id onlyCode, + t1.out_storehouse_type outStorehouseType, + t1.out_number outNumber, + t1.out_storehouse_id outStorehouseId, + t4.outbound_time outboundTime, + t1.create_by createBy, + t1.create_time createTime, + t1.update_by updateBy, + t1.update_time updateTime, + t2.tool_code toolCode, + t2.chinese_name chineseName, + t2.tool_model toolModel, + t3.classify_id classifyNum, + t4.out_num outNum, + t4.subject_matter subjectMatter, + t5.realname handler, + t6.realname reviewer, + t7.item_text inStatus, + t8.item_text orderStatus, + t9.item_text outStorehouseTypeName, + t10.item_text operateType + FROM + tms_out_store_detail t1 + LEFT JOIN tms_base_tools t2 ON t2.id = t1.tool_code + LEFT JOIN tms_tools_classify t3 ON t3.id = t2.classify_id + LEFT JOIN tms_outbound_order t4 ON t4.id = t1.out_storehouse_id + LEFT JOIN sys_user t5 ON t5.username = t4.handler + LEFT JOIN sys_user t6 ON t6.username = t4.reviewer + LEFT JOIN ( SELECT * FROM v_sys_dict WHERE dict_code = 'out_status' ) t7 ON t7.item_value = t4.out_status + LEFT JOIN ( SELECT * FROM v_sys_dict WHERE dict_code = 'out_bill_status' ) t8 ON t8.item_value = t4.order_status + LEFT JOIN ( SELECT * FROM v_sys_dict WHERE dict_code = 'out_storehouse_type' ) t9 ON t9.item_value = t1.out_storehouse_type + LEFT JOIN ( SELECT * FROM v_sys_dict WHERE dict_code = 'inbound_operate_type' ) t10 ON t10.item_value = t1.operate_type + ${ew.customSqlSegment} + </select> </mapper> \ No newline at end of file diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/ToolLedgerDetailMapper.xml b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/ToolLedgerDetailMapper.xml index 9d8a3db..78cb6cf 100644 --- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/ToolLedgerDetailMapper.xml +++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/ToolLedgerDetailMapper.xml @@ -172,4 +172,24 @@ ) ) temp </select> + <select id="queryToolLedgerDetailList" resultType="map" parameterType="String"> + SELECT + t1.id, + t1.tool_code toolCodeId, + t2.tool_code toolCode, + t1.tool_id onlyCode, + t2.chinese_name chineseName, + t2.tool_model toolModel, + t1.quantity, + t1.warehouse_id warehouseId, + ISNULL(t3.warehouse_id, '') + '/' + ISNULL(t3.warehouse_name, '') warehouseName, + t1.position_code positionCode, + t5.item_text applicationType + FROM tms_tool_ledger_detail t1 + LEFT JOIN tms_base_tools t2 on t1.tool_code = t2.id + LEFT JOIN tms_warehouse t3 on t1.warehouse_id = t3.id + left join tms_tools_config_property t4 on t4.tool_code = t2.id + left join (select * from v_sys_dict where dict_code ='application_type') t5 on t5.item_value = t4.application_type + ${ew.customSqlSegment} + </select> </mapper> \ No newline at end of file diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/ToolLedgerMapper.xml b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/ToolLedgerMapper.xml index 93626d9..b87ca82 100644 --- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/ToolLedgerMapper.xml +++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/ToolLedgerMapper.xml @@ -2,4 +2,33 @@ <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="org.jeecg.modules.tms.mapper.ToolLedgerMapper"> + <select id="toolLedgerList" resultType="map" parameterType="String"> + select + t1.id, + t1.total_count totalCount, + t1.available_count availableCount, + t1.lend_count lendCount, + t1.loss_count lossCount, + t1.repair_count repairCount, + t1.sharpening_count sharpeningCount, + t1.detection_count detectionCount, + t2.id toolCodeId, + t2.tool_code toolCode, + t2.chinese_name chineseName, + t2.tool_model toolModel, + t2.sign_code signCode, + t2.accuracy_class accuracyClass, + t2.standard_code standardCode, + t2.standard_level standardLevel, + t3.position_code positionCode, + t3.storage_location storageLocation, + t3.highest_inventory highestInventory, + t3.lower_inventory lowerInventory, + t4.item_text applicationType + from tms_tool_ledger t1 + left join tms_base_tools t2 on t1.tool_id = t2.id + left join tms_tools_config_property t3 on t3.tool_code = t2.id + left join (select * from v_sys_dict where dict_code = 'application_type') t4 on t4.item_value = t3.application_type + ${ew.customSqlSegment} + </select> </mapper> \ No newline at end of file diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/ToolsLossBoundDetailMapper.xml b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/ToolsLossBoundDetailMapper.xml index 40abda6..046ee4f 100644 --- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/ToolsLossBoundDetailMapper.xml +++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/ToolsLossBoundDetailMapper.xml @@ -81,4 +81,28 @@ </choose> ${ew.customSqlSegment} </select> + + + <select id="toolLossDetailList" resultType="map" parameterType="String"> + SELECT + t1.id, + t1.tool_id onlyCode, + t1.loss_number lossNumber, + t1.loss_reason lossReason, + t2.order_code orderCode, + t2.loss_time lossTime, + t3.id toolCodeId, + t3.tool_code toolCode, + t3.chinese_name chineseName, + t3.tool_model toolModel, + t4.classify_id classifyNum, + t5.item_text handler + FROM + tms_loss_bound_detail t1 + LEFT JOIN tms_loss_bound t2 ON t2.id = t1.loss_bound_id + LEFT JOIN tms_base_tools t3 ON t3.id = t1.tool_code + LEFT JOIN tms_tools_classify t4 ON t4.id = t3.classify_id + LEFT JOIN ( SELECT * FROM v_sys_dict WHERE dict_code = 'sys_user' ) t5 ON t5.item_value = t2.handler + ${ew.customSqlSegment} + </select> </mapper> \ No newline at end of file diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/ToolsSharpeningMapper.xml b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/ToolsSharpeningMapper.xml index 34e329a..db23bc1 100644 --- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/ToolsSharpeningMapper.xml +++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/ToolsSharpeningMapper.xml @@ -23,4 +23,25 @@ LEFT JOIN tms_tool_ledger_detail t4 ON t4.tool_code = t.tool_id ${ew.customSqlSegment} </select> + + <select id="toolSharpeningList" resultType="map" parameterType="String"> + SELECT + t1.id, + t1.tool_id onlyCode, + t1.sharpening_time sharpeningTime, + t1.sharpening_result sharpeningResult, + t1.sharpening_status sharpeningStatus, + t1.responsible_person responsiblePerson, + t2.tool_code toolCode, + t2.chinese_name chineseName, + t2.tool_model toolModel, + t3.classify_id classifyNum, + t4.item_text sharpeningStatusName + FROM + tms_tool_sharpening t1 + LEFT JOIN tms_base_tools t2 ON t2.id = t1.tool_code + LEFT JOIN tms_tools_classify t3 ON t3.id = t2.classify_id + LEFT JOIN ( SELECT * FROM v_sys_dict WHERE dict_code = 'sharpening_status' ) t4 ON t4.item_value = t1.sharpening_status + ${ew.customSqlSegment} + </select> </mapper> \ No newline at end of file diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/ToolsStocktakingBoundDetailMapper.xml b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/ToolsStocktakingBoundDetailMapper.xml index 214d4dd..0b5066b 100644 --- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/ToolsStocktakingBoundDetailMapper.xml +++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/ToolsStocktakingBoundDetailMapper.xml @@ -88,4 +88,30 @@ ${ew.customSqlSegment} </select> + + <select id="toolsStocktakingList" resultType="map" parameterType="String"> + SELECT + t1.id, + t1.tool_id onlyCode, + t1.book_quantity bookQuantity, + t1.available_quantity availableQuantity, + t1.practical_quantity practicalQuantity, + t1.surplus_deficit surplusDeficit, + t1.stocktaking_date stocktakingDate, + t2.order_code orderCode, + t2.stocktaking_type stocktakingType, + t2.stocktaking_name stocktakingName, + t3.tool_code toolCode, + t3.chinese_name chineseName, + t3.tool_model toolModel, + t4.classify_id classifyNum, + t5.item_text handler + FROM + tms_stocktaking_bound_detail t1 + LEFT JOIN tms_stocktaking_bound t2 ON t2.id = t1.stocktaking_bound_id + LEFT JOIN tms_base_tools t3 ON t3.id = t1.tool_code + LEFT JOIN tms_tools_classify t4 ON t4.id = t3.classify_id + LEFT JOIN ( SELECT * FROM v_sys_dict WHERE dict_code = 'sys_user' ) t5 ON t5.item_value = t2.handler + ${ew.customSqlSegment} + </select> </mapper> \ No newline at end of file diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/IOutStoreDetailService.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/IOutStoreDetailService.java index ef66d57..5c9fb1b 100644 --- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/IOutStoreDetailService.java +++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/IOutStoreDetailService.java @@ -17,4 +17,6 @@ public interface IOutStoreDetailService extends IService<OutStoreDetail> { IPage<OutStoreDetailVo> queryPageList(Page<OutStoreDetailVo> page, Map<String, String[]> parameterMap); + + IPage<Map<String, Object>> outStoreDetailList(Integer pageNo, Integer pageSize, Map<String, String> query); } diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/IToolLedgerDetailService.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/IToolLedgerDetailService.java index fb4c435..69f3499 100644 --- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/IToolLedgerDetailService.java +++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/IToolLedgerDetailService.java @@ -20,4 +20,6 @@ IPage<Map<String, Object>> queryLendTool(Integer pageNo, Integer pageSize, Map<String, String> query); IPage<Map<String, Object>> querySharpenTool(Integer pageNo, Integer pageSize, Map<String, String> query); + + IPage<Map<String, Object>> queryToolLedgerDetailList(Integer pageNo, Integer pageSize, Map<String, String> query); } diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/IToolLedgerService.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/IToolLedgerService.java index 0b541bf..056ab47 100644 --- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/IToolLedgerService.java +++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/IToolLedgerService.java @@ -1,7 +1,10 @@ package org.jeecg.modules.tms.service; +import com.baomidou.mybatisplus.core.metadata.IPage; import org.jeecg.modules.tms.entity.ToolLedger; import com.baomidou.mybatisplus.extension.service.IService; + +import java.util.Map; /** * @Description: tms_tool_ledger @@ -11,4 +14,5 @@ */ public interface IToolLedgerService extends IService<ToolLedger> { + IPage<Map<String, Object>> toolLedgerList(Integer pageNo, Integer pageSize, Map<String, String> query); } diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/IToolsLossBoundDetailService.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/IToolsLossBoundDetailService.java index 30a5be5..beb9635 100644 --- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/IToolsLossBoundDetailService.java +++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/IToolsLossBoundDetailService.java @@ -19,4 +19,6 @@ */ public interface IToolsLossBoundDetailService extends IService<ToolsLossBoundDetail> { IPage<ToolsLossBoundDetail> queryPageList(Page<ToolsLossBoundDetail> page, Map<String, String[]> parameterMap); + + IPage<Map<String, Object>> toolLossDetailList(Integer pageNo, Integer pageSize, Map<String, String> query); } diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/IToolsSharpeningService.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/IToolsSharpeningService.java index 060d369..a6f6eb9 100644 --- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/IToolsSharpeningService.java +++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/IToolsSharpeningService.java @@ -16,4 +16,6 @@ */ public interface IToolsSharpeningService extends IService<ToolSharpening> { IPage<ToolSharpeningVo> queryPageList(Page<ToolSharpeningVo> page, Map<String, String[]> parameterMap); + + IPage<Map<String, Object>> toolSharpeningList(Integer pageNo, Integer pageSize, Map<String, String> query); } diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/IToolsStocktakingBoundDetailService.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/IToolsStocktakingBoundDetailService.java index da0bde5..e28f7a4 100644 --- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/IToolsStocktakingBoundDetailService.java +++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/IToolsStocktakingBoundDetailService.java @@ -27,5 +27,5 @@ */ public IPage<ToolsStocktakingBoundDetail> selectByMainId(Page<ToolsStocktakingBoundDetail> page, Map<String, String[]> parameterMap); - + IPage<Map<String, Object>> toolsStocktakingList(Integer pageNo, Integer pageSize, Map<String, String> query); } diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/InboundOrderServiceImpl.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/InboundOrderServiceImpl.java index 0671b37..ad52aa3 100644 --- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/InboundOrderServiceImpl.java +++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/InboundOrderServiceImpl.java @@ -68,6 +68,9 @@ @Autowired private IInboundDetailService inboundDetailService; + + @Autowired + private IGoodsShelvesService goodsShelvesService; @Override public boolean submit(String id) { InboundOrder inboundOrder = this.getById(id); @@ -215,6 +218,7 @@ @Override public void addInStorage(JSONObject jSONObject) { String inStorehouseType = jSONObject.getString("inStorehouseType"); + String locationCodeId = jSONObject.getString("locationCodeId"); String classifyId = jSONObject.getString("classifyId"); Date inboundTime = jSONObject.getDate("inboundTime"); //鑾峰彇鍏ュ簱鏄庣粏 @@ -266,6 +270,7 @@ inStoreDetail.setInStorehouseType("1"); inStoreDetail.setToolCode(inboundDetailVo.getToolCodeId()); inStoreDetail.setToolId(inboundDetailVo.getToolCode()+"-"+result); + inStoreDetail.setGoodsShelvesId(locationCodeId); inStoreDetailService.save(inStoreDetail); //澧炲姞搴撳瓨鏄庣粏 ToolLedgerDetail toolLedgerDetail = new ToolLedgerDetail(); @@ -287,6 +292,7 @@ inStoreDetail.setInNumber(inboundDetailVo.getInStorageQuantity()); inStoreDetail.setInStorehouseType("1"); inStoreDetail.setToolCode(inboundDetailVo.getToolCodeId()); + inStoreDetail.setGoodsShelvesId(locationCodeId); inStoreDetailService.save(inStoreDetail); //鏌ヨ搴撳瓨鏄庣粏涓槸鍚﹀瓨鍦ㄨ宸ュ叿 ToolLedgerDetail toolLedgerDetail = toolLedgerDetailService.lambdaQuery().eq(ToolLedgerDetail::getToolCode,inboundDetailVo.getToolCodeId()).one(); @@ -331,6 +337,7 @@ inStoreDetail.setInStorehouseType("2"); inStoreDetail.setToolCode(inboundDetailVo.getToolCodeId()); inStoreDetail.setToolId(inboundDetailVo.getOnlyCode()); + inStoreDetail.setGoodsShelvesId(locationCodeId); inStoreDetailService.save(inStoreDetail); //涓嶇鍒版妸 }else { @@ -346,6 +353,7 @@ inStoreDetail.setInNumber(inboundDetailVo.getInStorageQuantity()); inStoreDetail.setInStorehouseType("2"); inStoreDetail.setToolCode(inboundDetailVo.getToolCodeId()); + inStoreDetail.setGoodsShelvesId(locationCodeId); inStoreDetailService.save(inStoreDetail); } @@ -378,6 +386,7 @@ inStoreDetail.setInStorehouseType("5"); inStoreDetail.setToolCode(inboundDetailVo.getToolCodeId()); inStoreDetail.setToolId(inboundDetailVo.getOnlyCode()); + inStoreDetail.setGoodsShelvesId(locationCodeId); inStoreDetailService.save(inStoreDetail); //涓嶇鍒版妸 }else { @@ -393,6 +402,7 @@ inStoreDetail.setInNumber(inboundDetailVo.getInStorageQuantity()); inStoreDetail.setInStorehouseType("5"); inStoreDetail.setToolCode(inboundDetailVo.getToolCodeId()); + inStoreDetail.setGoodsShelvesId(locationCodeId); inStoreDetailService.save(inStoreDetail); } @@ -403,6 +413,7 @@ @Override public void addApplyInStorage(JSONObject jSONObject) { String inStorehouseType = jSONObject.getString("inStorehouseType"); + String locationCodeId = jSONObject.getString("locationCodeId"); //鍏ュ簱鐢宠鍗昳d String orderId = jSONObject.getString("orderId"); //鑾峰彇鍏ュ簱鏄庣粏 @@ -455,6 +466,7 @@ inStoreDetail.setInStorehouseType("1"); inStoreDetail.setToolCode(inboundDetailVo.getToolCodeId()); inStoreDetail.setToolId(inboundDetailVo.getToolCode()+"-"+result); + inStoreDetail.setGoodsShelvesId(locationCodeId); inStoreDetailService.save(inStoreDetail); //澧炲姞搴撳瓨鏄庣粏 ToolLedgerDetail toolLedgerDetail = new ToolLedgerDetail(); @@ -477,6 +489,7 @@ inStoreDetail.setInStorehouseType("1"); inStoreDetail.setInStorehouseId(orderId); inStoreDetail.setToolCode(inboundDetailVo.getToolCodeId()); + inStoreDetail.setGoodsShelvesId(locationCodeId); inStoreDetailService.save(inStoreDetail); //鏌ヨ搴撳瓨鏄庣粏涓槸鍚﹀瓨鍦ㄨ宸ュ叿 ToolLedgerDetail toolLedgerDetail = toolLedgerDetailService.lambdaQuery().eq(ToolLedgerDetail::getToolCode,inboundDetailVo.getToolCodeId()).one(); @@ -527,6 +540,7 @@ inStoreDetail.setInStorehouseId(orderId); inStoreDetail.setToolCode(inboundDetailVo.getToolCodeId()); inStoreDetail.setToolId(inboundDetailVo.getOnlyCode()); + inStoreDetail.setGoodsShelvesId(locationCodeId); inStoreDetailService.save(inStoreDetail); //涓嶇鍒版妸 }else { @@ -543,6 +557,7 @@ inStoreDetail.setInStorehouseType("2"); inStoreDetail.setInStorehouseId(orderId); inStoreDetail.setToolCode(inboundDetailVo.getToolCodeId()); + inStoreDetail.setGoodsShelvesId(locationCodeId); inStoreDetailService.save(inStoreDetail); } //鏇存敼鏄庣粏鍏ュ簱鐘舵�佸強瀹為檯鍏ュ簱鏁伴噺 @@ -580,6 +595,7 @@ inStoreDetail.setInStorehouseId(orderId); inStoreDetail.setToolCode(inboundDetailVo.getToolCodeId()); inStoreDetail.setToolId(inboundDetailVo.getOnlyCode()); + inStoreDetail.setGoodsShelvesId(locationCodeId); inStoreDetailService.save(inStoreDetail); //涓嶇鍒版妸 }else { @@ -596,6 +612,7 @@ inStoreDetail.setInStorehouseType("5"); inStoreDetail.setInStorehouseId(orderId); inStoreDetail.setToolCode(inboundDetailVo.getToolCodeId()); + inStoreDetail.setGoodsShelvesId(locationCodeId); inStoreDetailService.save(inStoreDetail); } //鏇存敼鏄庣粏鍏ュ簱鐘舵�佸強瀹為檯鍏ュ簱鏁伴噺 diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/OutStoreDetailServiceImpl.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/OutStoreDetailServiceImpl.java index 7a7015c..8555fea 100644 --- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/OutStoreDetailServiceImpl.java +++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/OutStoreDetailServiceImpl.java @@ -2,8 +2,11 @@ import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; +import com.baomidou.mybatisplus.core.metadata.OrderItem; import com.baomidou.mybatisplus.core.toolkit.Wrappers; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; +import org.apache.commons.lang.StringUtils; +import org.jeecg.common.exception.ExceptionCast; import org.jeecg.modules.tms.entity.OutStoreDetail; import org.jeecg.modules.tms.entity.vo.OutStoreDetailVo; import org.jeecg.modules.tms.mapper.OutStoreDetailMapper; @@ -12,6 +15,8 @@ import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; +import java.util.ArrayList; +import java.util.List; import java.util.Map; /** @@ -41,4 +46,32 @@ queryWrapper.orderByDesc("t1.create_time"); return this.baseMapper.queryPageList(page, queryWrapper); } + + @Override + public IPage<Map<String, Object>> outStoreDetailList(Integer pageNo, Integer pageSize, Map<String, String> query) { + if (pageNo == null || pageNo < 1 || pageSize == null || pageSize < 1) { + ExceptionCast.cast("鍙傛暟閿欒"); + } + IPage<Map> pageData = new Page<Map>(pageNo, pageSize); + QueryWrapper<Map> queryWrapper = Wrappers.query(); + if (null != query) { + String classifyId = query.get("classifyId"); + if (StringUtils.isNotBlank(classifyId)) { + queryWrapper.eq("t2.classify_id", classifyId); + } + String toolCode = query.get("toolCode"); + if (StringUtils.isNotBlank(toolCode)) { + queryWrapper.like("t2.tool_code", toolCode); + } + String toolModel = query.get("toolModel"); + if (StringUtils.isNotBlank(toolModel)) { + queryWrapper.like("t2.tool_mode", toolModel); + } + // 鎺掑簭鍐欐硶 + List<OrderItem> orderItems = new ArrayList<>(); + orderItems.add(OrderItem.desc("t1.create_time")); + ((Page<Map>) pageData).setOrders(orderItems); + } + return super.getBaseMapper().outStoreDetailList(pageData,queryWrapper); + } } diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/ToolLedgerDetailServiceImpl.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/ToolLedgerDetailServiceImpl.java index 17e916c..83ef7b0 100644 --- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/ToolLedgerDetailServiceImpl.java +++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/ToolLedgerDetailServiceImpl.java @@ -98,4 +98,29 @@ } return this.baseMapper.querySharpenTool(pageData,queryWrapper); } + + @Override + public IPage<Map<String, Object>> queryToolLedgerDetailList(Integer pageNo, Integer pageSize, Map<String, String> query) { + + if (pageNo == null || pageNo < 1 || pageSize == null || pageSize < 1) { + ExceptionCast.cast("鍙傛暟閿欒"); + } + IPage<Map> pageData = new Page<Map>(pageNo, pageSize); + QueryWrapper<Map> queryWrapper = Wrappers.query(); + if (null != query) { + String toolCode = query.get("toolCode"); + if (StringUtils.isNotBlank(toolCode)) { + queryWrapper.like("t2.tool_code", toolCode); + } + String status = query.get("status"); + if (StringUtils.isNotBlank(status)) { + queryWrapper.eq("t1.status", status); + } + String classifyId = query.get("classifyId"); + if (StringUtils.isNotBlank(classifyId)) { + queryWrapper.like("t2.classify_id", classifyId); + } + } + return this.baseMapper.queryToolLedgerDetailList(pageData,queryWrapper); + } } diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/ToolLedgerServiceImpl.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/ToolLedgerServiceImpl.java index 87d4e0b..eaf1988 100644 --- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/ToolLedgerServiceImpl.java +++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/ToolLedgerServiceImpl.java @@ -1,11 +1,22 @@ package org.jeecg.modules.tms.service.impl; +import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; +import com.baomidou.mybatisplus.core.metadata.IPage; +import com.baomidou.mybatisplus.core.metadata.OrderItem; +import com.baomidou.mybatisplus.core.toolkit.Wrappers; +import com.baomidou.mybatisplus.extension.plugins.pagination.Page; +import org.apache.commons.lang.StringUtils; +import org.jeecg.common.exception.ExceptionCast; import org.jeecg.modules.tms.entity.ToolLedger; import org.jeecg.modules.tms.mapper.ToolLedgerMapper; import org.jeecg.modules.tms.service.IToolLedgerService; import org.springframework.stereotype.Service; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; + +import java.util.ArrayList; +import java.util.List; +import java.util.Map; /** * @Description: tms_tool_ledger @@ -16,4 +27,31 @@ @Service public class ToolLedgerServiceImpl extends ServiceImpl<ToolLedgerMapper, ToolLedger> implements IToolLedgerService { + @Override + public IPage<Map<String, Object>> toolLedgerList(Integer pageNo, Integer pageSize, Map<String, String> query) { + if (pageNo == null || pageNo < 1 || pageSize == null || pageSize < 1) { + ExceptionCast.cast("鍙傛暟閿欒"); + } + IPage<Map> pageData = new Page<Map>(pageNo, pageSize); + QueryWrapper<Map> queryWrapper = Wrappers.query(); + if (null != query) { + String classifyId = query.get("classifyId"); + if (StringUtils.isNotBlank(classifyId)) { + queryWrapper.eq("t1.classify_id", classifyId); + } + String toolCode = query.get("toolCode"); + if (StringUtils.isNotBlank(toolCode)) { + queryWrapper.like("t2.tool_code", toolCode); + } + String toolModel = query.get("toolModel"); + if (StringUtils.isNotBlank(toolModel)) { + queryWrapper.like("t2.tool_mode", toolModel); + } + // 鎺掑簭鍐欐硶 + List<OrderItem> orderItems = new ArrayList<>(); + orderItems.add(OrderItem.desc("t1.create_time")); + ((Page<Map>) pageData).setOrders(orderItems); + } + return super.getBaseMapper().toolLedgerList(pageData,queryWrapper); + } } diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/ToolsLossBoundDetailServiceImpl.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/ToolsLossBoundDetailServiceImpl.java index 2d44481..eea9938 100644 --- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/ToolsLossBoundDetailServiceImpl.java +++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/ToolsLossBoundDetailServiceImpl.java @@ -3,8 +3,11 @@ import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; +import com.baomidou.mybatisplus.core.metadata.OrderItem; import com.baomidou.mybatisplus.core.toolkit.Wrappers; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; +import org.apache.commons.lang.StringUtils; +import org.jeecg.common.exception.ExceptionCast; import org.jeecg.modules.tms.entity.OutboundDetail; import org.jeecg.modules.tms.entity.ToolsLossBound; import org.jeecg.modules.tms.entity.ToolsLossBoundDetail; @@ -15,6 +18,8 @@ import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; +import java.util.ArrayList; +import java.util.List; import java.util.Map; /** @@ -35,4 +40,32 @@ } return this.baseMapper.queryPageList(page, queryWrapper); } + + @Override + public IPage<Map<String, Object>> toolLossDetailList(Integer pageNo, Integer pageSize, Map<String, String> query) { + if (pageNo == null || pageNo < 1 || pageSize == null || pageSize < 1) { + ExceptionCast.cast("鍙傛暟閿欒"); + } + IPage<Map> pageData = new Page<Map>(pageNo, pageSize); + QueryWrapper<Map> queryWrapper = Wrappers.query(); + if (null != query) { + String classifyId = query.get("classifyId"); + if (StringUtils.isNotBlank(classifyId)) { + queryWrapper.eq("t3.classify_id", classifyId); + } + String toolCode = query.get("toolCode"); + if (StringUtils.isNotBlank(toolCode)) { + queryWrapper.like("t3.tool_code", toolCode); + } + String toolModel = query.get("toolModel"); + if (StringUtils.isNotBlank(toolModel)) { + queryWrapper.like("t3.tool_mode", toolModel); + } + // 鎺掑簭鍐欐硶 + List<OrderItem> orderItems = new ArrayList<>(); + orderItems.add(OrderItem.desc("t1.create_time")); + ((Page<Map>) pageData).setOrders(orderItems); + } + return super.getBaseMapper().toolLossDetailList(pageData,queryWrapper); + } } diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/ToolsSharpeningServiceImpl.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/ToolsSharpeningServiceImpl.java index f05572d..0290d51 100644 --- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/ToolsSharpeningServiceImpl.java +++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/ToolsSharpeningServiceImpl.java @@ -2,8 +2,11 @@ import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; +import com.baomidou.mybatisplus.core.metadata.OrderItem; import com.baomidou.mybatisplus.core.toolkit.Wrappers; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; +import org.apache.commons.lang.StringUtils; +import org.jeecg.common.exception.ExceptionCast; import org.jeecg.modules.tms.entity.ToolSharpening; import org.jeecg.modules.tms.entity.ToolsLossBoundDetail; import org.jeecg.modules.tms.entity.vo.ToolSharpeningVo; @@ -12,6 +15,8 @@ import org.springframework.stereotype.Service; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; +import java.util.ArrayList; +import java.util.List; import java.util.Map; /** @@ -48,5 +53,32 @@ return this.baseMapper.queryPageList(page, queryWrapper); } + @Override + public IPage<Map<String, Object>> toolSharpeningList(Integer pageNo, Integer pageSize, Map<String, String> query) { + if (pageNo == null || pageNo < 1 || pageSize == null || pageSize < 1) { + ExceptionCast.cast("鍙傛暟閿欒"); + } + IPage<Map> pageData = new Page<Map>(pageNo, pageSize); + QueryWrapper<Map> queryWrapper = Wrappers.query(); + if (null != query) { + String classifyId = query.get("classifyId"); + if (StringUtils.isNotBlank(classifyId)) { + queryWrapper.eq("t2.classify_id", classifyId); + } + String toolCode = query.get("toolCode"); + if (StringUtils.isNotBlank(toolCode)) { + queryWrapper.like("t2.tool_code", toolCode); + } + String toolModel = query.get("toolModel"); + if (StringUtils.isNotBlank(toolModel)) { + queryWrapper.like("t2.tool_mode", toolModel); + } + // 鎺掑簭鍐欐硶 + List<OrderItem> orderItems = new ArrayList<>(); + orderItems.add(OrderItem.desc("t1.create_time")); + ((Page<Map>) pageData).setOrders(orderItems); + } + return super.getBaseMapper().toolSharpeningList(pageData,queryWrapper); + } } diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/ToolsStocktakingBoundDetailServiceImpl.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/ToolsStocktakingBoundDetailServiceImpl.java index d3e4149..c8cb77a 100644 --- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/ToolsStocktakingBoundDetailServiceImpl.java +++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/ToolsStocktakingBoundDetailServiceImpl.java @@ -2,15 +2,19 @@ import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; +import com.baomidou.mybatisplus.core.metadata.OrderItem; import com.baomidou.mybatisplus.core.toolkit.Wrappers; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; +import org.apache.commons.lang.StringUtils; +import org.jeecg.common.exception.ExceptionCast; import org.jeecg.modules.tms.entity.ToolsStocktakingBoundDetail; import org.jeecg.modules.tms.mapper.ToolsStocktakingBoundDetailMapper; import org.jeecg.modules.tms.service.IToolsStocktakingBoundDetailService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; +import java.util.ArrayList; import java.util.List; import java.util.Map; @@ -36,4 +40,32 @@ return toolsStocktakingBoundDetailMapper.selectByMainId(page, queryWrapper); } + @Override + public IPage<Map<String, Object>> toolsStocktakingList(Integer pageNo, Integer pageSize, Map<String, String> query) { + if (pageNo == null || pageNo < 1 || pageSize == null || pageSize < 1) { + ExceptionCast.cast("鍙傛暟閿欒"); + } + IPage<Map> pageData = new Page<Map>(pageNo, pageSize); + QueryWrapper<Map> queryWrapper = Wrappers.query(); + if (null != query) { + String classifyId = query.get("classifyId"); + if (StringUtils.isNotBlank(classifyId)) { + queryWrapper.eq("t3.classify_id", classifyId); + } + String toolCode = query.get("toolCode"); + if (StringUtils.isNotBlank(toolCode)) { + queryWrapper.like("t3.tool_code", toolCode); + } + String toolModel = query.get("toolModel"); + if (StringUtils.isNotBlank(toolModel)) { + queryWrapper.like("t3.tool_mode", toolModel); + } + // 鎺掑簭鍐欐硶 + List<OrderItem> orderItems = new ArrayList<>(); + orderItems.add(OrderItem.desc("t1.create_time")); + ((Page<Map>) pageData).setOrders(orderItems); + } + return super.getBaseMapper().toolsStocktakingList(pageData,queryWrapper); + } + } -- Gitblit v1.9.3