From 831dbe10d1c0975b0de4251b67b939347b079006 Mon Sep 17 00:00:00 2001 From: pang.jiabao <pang_jiabao@163.com> Date: 星期四, 20 二月 2025 10:35:01 +0800 Subject: [PATCH] 单据管理多选,全选excel导出 --- src/main/java/com/zy/asrs/controller/OrderController.java | 276 ++++++++++++++++++++++++++++++++++++++++++------------- 1 files changed, 211 insertions(+), 65 deletions(-) diff --git a/src/main/java/com/zy/asrs/controller/OrderController.java b/src/main/java/com/zy/asrs/controller/OrderController.java index 57f2eb4..c73d459 100644 --- a/src/main/java/com/zy/asrs/controller/OrderController.java +++ b/src/main/java/com/zy/asrs/controller/OrderController.java @@ -9,21 +9,29 @@ import com.core.annotations.ManagerAuth; import com.core.common.*; import com.core.exception.CoolException; -import com.sun.org.apache.xpath.internal.operations.Or; import com.zy.asrs.entity.*; +import com.zy.asrs.entity.param.DefinedExcelExportParam; import com.zy.asrs.entity.param.OrderDomainParam; +import com.zy.asrs.entity.result.OrderDetlVo; +import com.zy.asrs.mapper.OrderDetlMapper; import com.zy.asrs.service.*; import com.zy.common.CodeRes; import com.zy.common.model.DetlDto; import com.zy.common.web.BaseController; +import com.zy.system.entity.User; +import com.zy.system.service.UserService; +import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.transaction.annotation.Transactional; import org.springframework.web.bind.annotation.*; +import javax.annotation.Resource; import javax.servlet.http.HttpServletResponse; import java.io.IOException; +import java.math.BigDecimal; import java.net.URLEncoder; import java.util.*; +import java.util.stream.Collectors; @RestController public class OrderController extends BaseController { @@ -45,9 +53,15 @@ @Autowired private OrderLogService orderLogService; + @Resource + private UserService userService; + + @Resource + private OrderDetlMapper orderDetlMapper; + @RequestMapping(value = "/order/nav/list/auth") @ManagerAuth - public R navList(@RequestParam(required = false) String orderNo){ + public R navList(@RequestParam(required = false) String orderNo) { EntityWrapper<Order> wrapper = new EntityWrapper<>(); if (!Cools.isEmpty(orderNo)) { wrapper.like("order_no", orderNo); @@ -75,15 +89,32 @@ @RequestMapping(value = "/order/head/page/auth") @ManagerAuth - public R head(@RequestParam(defaultValue = "1")Integer curr, - @RequestParam(defaultValue = "10")Integer limit, - @RequestParam(required = false)String orderByField, - @RequestParam(required = false)String orderByType, - @RequestParam Map<String, Object> param){ + public R head(@RequestParam(defaultValue = "1") Integer curr, + @RequestParam(defaultValue = "10") Integer limit, + @RequestParam(required = false) String orderByField, + @RequestParam(required = false) String orderByType, + @RequestParam Map<String, Object> param) { EntityWrapper<Order> wrapper = new EntityWrapper<>(); excludeTrash(param); + // 闄愬埗閿�鍞鑹插彧鑳界湅鑷繁鍒涘缓鐨勫崟瀛愶紙閿�鍞鑹瞚d鍥哄畾21锛屼笉鑳介殢鎰忎慨鏀癸級 + User user = getUser(); + if (user.getRoleId() != 2 && user.getRoleId() != 24) { + wrapper.eq("create_by", user.getId()); + } + // 璁㈠崟琛ㄥ彧瀛樹簡鎿嶄綔浜篿d,鎵�浠ユ搷浣滀汉濮撳悕鏌ヨ锛屽彧鑳戒粠濮撳悕鍏堝幓鎵緄d锛� + Object userName = param.get("oper_memb"); + if (userName != null && user.getRoleId() != 21) { + List<User> users = userService.selectList(new EntityWrapper<User>().eq("username", param.get("oper_memb"))); + if (users.size() > 0) { + wrapper.in("create_by", users.stream().map(User::getId).collect(Collectors.toList())); + } + } + // 涓婅堪宸茶嚜瀹氫箟鎼滅储锛岀Щ闄ゆ搷浣滀汉濮撳悕鎼滅储 + param.remove("oper_memb"); convert(param, wrapper); - if (!Cools.isEmpty(orderByField)){wrapper.orderBy(humpToLine(orderByField), "asc".equals(orderByType));} else { + if (!Cools.isEmpty(orderByField)) { + wrapper.orderBy(humpToLine(orderByField), "asc".equals(orderByType)); + } else { wrapper.orderBy("settle").orderBy("create_time", false); } wrapper.eq("status", 1); @@ -92,20 +123,29 @@ @RequestMapping(value = "/order/detl/all/auth") @ManagerAuth - public R head(@RequestParam Long orderId){ - return R.ok().add(orderDetlService.selectList(new EntityWrapper<OrderDetl>().eq("order_id", orderId))); + public R head(@RequestParam Long orderId) { + List<OrderDetl> orderDetls = orderDetlService.selectList(new EntityWrapper<OrderDetl>().eq("order_id", orderId)); + List<OrderDetl> orderDetls1 = new ArrayList<>(); + for (OrderDetl orderDetl : orderDetls) { + double v = orderDetl.getAnfme() - orderDetl.getWorkQty(); + double v1 = new BigDecimal(v).setScale(2, BigDecimal.ROUND_HALF_UP).doubleValue(); + if (v1 != 0.0) { + orderDetls1.add(orderDetl); + } + } + return R.ok().add(orderDetls1); } @RequestMapping(value = "/order/form/add/auth") @ManagerAuth(memo = "鎵嬪姩娣诲姞璁㈠崟") @Transactional - public R formAdd(@RequestBody OrderDomainParam param){ + public R formAdd(@RequestBody OrderDomainParam param) { String prefix = ""; DocType docType = docTypeService.selectById(param.getDocType()); - if(!Cools.isEmpty(docType)){ + if (!Cools.isEmpty(docType)) { prefix = docType.getPakin() == 1 ? "RK" : "CK"; } - if(Cools.isEmpty(param.getOrderNo())){ + if (Cools.isEmpty(param.getOrderNo())) { param.setOrderNo(prefix + snowflakeIdWorker.nextId()); } Order order = orderService.selectByNo(param.getOrderNo()); @@ -117,20 +157,24 @@ return R.error("鍗曟嵁缂栧彿鍦ㄥ巻鍙叉。涓凡瀛樺湪"); } Date now = new Date(); + Long itemId = null; + if (param.getDocType() == 16 || param.getDocType() == 19) { + itemId = 1L; + } order = new Order( String.valueOf(snowflakeIdWorker.nextId()), // 缂栧彿[闈炵┖] param.getOrderNo(), // 璁㈠崟缂栧彿 DateUtils.convert(now), // 鍗曟嵁鏃ユ湡 param.getDocType(), // 鍗曟嵁绫诲瀷 - null, // 椤圭洰缂栧彿 - null, // + itemId, // 椤圭洰缂栧彿 + param.getItemName(), // null, // 璋冩嫧椤圭洰缂栧彿 null, // 鍒濆绁ㄦ嵁鍙� - null, // 绁ㄦ嵁鍙� - null, // 瀹㈡埛缂栧彿 - null, // 瀹㈡埛 - null, // 鑱旂郴鏂瑰紡 - null, // 鎿嶄綔浜哄憳 + param.getNumber(), // 绁ㄦ嵁鍙� + param.getCstmr(), // 瀹㈡埛缂栧彿 + param.getCstmrName(), // 瀹㈡埛 + param.getTel(), // 鑱旂郴鏂瑰紡 + getUser().getUsername(), // 鎿嶄綔浜哄憳 null, // 鍚堣閲戦 null, // 浼樻儬鐜� null, // 浼樻儬閲戦 @@ -153,19 +197,13 @@ now, // 淇敼鏃堕棿 null // 澶囨敞 ); + order.setOperMemb(getUser().getUsername()); if (!orderService.insert(order)) { throw new CoolException("淇濆瓨璁㈠崟涓绘。澶辫触"); } List<DetlDto> list = new ArrayList<>(); for (OrderDetl orderDetl : param.getOrderDetlList()) { - if (Cools.isEmpty(orderDetl.getOwner())){ - throw new CoolException("淇濆瓨璁㈠崟鏄庣粏妗eけ璐�,璇疯緭鍏ヨ揣涓荤紪鍙�"); - }else { - LocOwner locOwner = locOwnerService.selectById(orderDetl.getOwner()); - if (Cools.isEmpty(locOwner)){ - throw new CoolException("淇濆瓨璁㈠崟鏄庣粏妗eけ璐�,璇疯緭鍏ュ瓨鍦ㄧ殑璐т富缂栧彿锛堟暣鏁帮級"); - } - } + if (orderDetl.getBatch() == null) { orderDetl.setBatch(""); } @@ -186,9 +224,6 @@ orderDetl.setUpdateTime(now); orderDetl.setStatus(1); orderDetl.setQty(0.0D); - if(orderDetl.getPayment() == null){ - orderDetl.setPayment(1); - } orderDetl.setUuid(String.valueOf(System.currentTimeMillis())); if (!orderDetlService.insert(orderDetl)) { throw new CoolException("淇濆瓨璁㈠崟鏄庣粏妗eけ璐�"); @@ -201,7 +236,7 @@ @RequestMapping(value = "/order/form/modify/auth") @ManagerAuth(memo = "鎵嬪姩淇敼璁㈠崟") @Transactional - public R formModify(@RequestBody OrderDomainParam param){ + public R formModify(@RequestBody OrderDomainParam param) { Order order = orderService.selectById(param.getOrderId()); if (order == null || order.getStatus() == 0) { return R.error("璁㈠崟涓嶅瓨鍦�"); @@ -209,9 +244,14 @@ Date now = new Date(); Long userId = getUserId(); // 淇敼涓绘。 - if (!param.getDocType().equals(order.getDocType())) { + if (!param.getDocType().equals(order.getDocType()) || param.getCstmrName() != order.getCstmrName() || !Cools.eq(param.getItemName(), order.getItemName())) { order.setDocType(param.getDocType()); order.setUpdateBy(userId); + order.setCstmr(param.getCstmr()); + order.setCstmrName(param.getCstmrName()); + order.setTel(param.getTel()); + order.setNumber(param.getNumber()); + order.setItemName(param.getItemName()); order.setUpdateTime(now); if (!orderService.updateById(order)) { throw new CoolException("淇敼璁㈠崟绫诲瀷澶辫触"); @@ -262,42 +302,44 @@ @RequestMapping(value = "/order/list/auth") @ManagerAuth - public R list(@RequestParam(defaultValue = "1")Integer curr, - @RequestParam(defaultValue = "10")Integer limit, - @RequestParam(required = false)String orderByField, - @RequestParam(required = false)String orderByType, - @RequestParam Map<String, Object> param){ + public R list(@RequestParam(defaultValue = "1") Integer curr, + @RequestParam(defaultValue = "10") Integer limit, + @RequestParam(required = false) String orderByField, + @RequestParam(required = false) String orderByType, + @RequestParam Map<String, Object> param) { EntityWrapper<Order> wrapper = new EntityWrapper<>(); excludeTrash(param); convert(param, wrapper); - if (!Cools.isEmpty(orderByField)){wrapper.orderBy(humpToLine(orderByField), "asc".equals(orderByType));} + if (!Cools.isEmpty(orderByField)) { + wrapper.orderBy(humpToLine(orderByField), "asc".equals(orderByType)); + } return R.ok(orderService.selectPage(new Page<>(curr, limit), wrapper)); } - private <T> void convert(Map<String, Object> map, EntityWrapper<T> wrapper){ - for (Map.Entry<String, Object> entry : map.entrySet()){ + private <T> void convert(Map<String, Object> map, EntityWrapper<T> wrapper) { + for (Map.Entry<String, Object> entry : map.entrySet()) { String val = String.valueOf(entry.getValue()); - if (val.contains(RANGE_TIME_LINK)){ + if (val.contains(RANGE_TIME_LINK)) { String[] dates = val.split(RANGE_TIME_LINK); wrapper.ge(entry.getKey(), DateUtils.convert(dates[0])); wrapper.le(entry.getKey(), DateUtils.convert(dates[1])); } else { - wrapper.like(entry.getKey(), val); + wrapper.eq(entry.getKey(), val); } } } @RequestMapping(value = "/order/update/auth") @ManagerAuth - public R update(Order order){ - if (Cools.isEmpty(order) || null == order.getId()){ + public R update(Order order) { + if (Cools.isEmpty(order) || null == order.getId()) { return R.error(); } //璁㈠崟瀹岀粨鍓嶏紝鍒ゆ柇鏄惁瀛樺湪浣滀笟涓暟鎹紝瀛樺湪鍒欎笉鑳藉畬缁� - if(order.getSettle() == 4){ - int wrkCount = wrkDetlService.selectCount(new EntityWrapper<WrkDetl>().eq("order_no",order.getOrderNo())); - int pakinCount = waitPakinService.selectCount(new EntityWrapper<WaitPakin>().eq("order_no",order.getOrderNo())); + if (order.getSettle() == 4) { + int wrkCount = wrkDetlService.selectCount(new EntityWrapper<WrkDetl>().eq("order_no", order.getOrderNo())); + int pakinCount = waitPakinService.selectCount(new EntityWrapper<WaitPakin>().eq("order_no", order.getOrderNo())); if (wrkCount > 0 || pakinCount > 0) { throw new CoolException("瀛樺湪浣滀笟涓暟鎹紝涓嶈兘瀹岀粨銆傝妫�鏌ュ叆搴撻�氱煡妗e拰宸ヤ綔妗�"); } @@ -314,7 +356,7 @@ @RequestMapping(value = "/order/delete/auth") @ManagerAuth(memo = "鎵嬪姩鍒犻櫎璁㈠崟") @Transactional - public R delete(@RequestParam Long orderId){ + public R delete(@RequestParam Long orderId) { orderService.remove(orderId); // Order order = orderService.selectById(orderId); // if (order != null) { @@ -329,7 +371,7 @@ @RequestMapping(value = "/order/export/auth") @ManagerAuth - public R export(@RequestBody JSONObject param){ + public R export(@RequestBody JSONObject param) { EntityWrapper<Order> wrapper = new EntityWrapper<>(); List<String> fields = JSONObject.parseArray(param.getJSONArray("fields").toJSONString(), String.class); Map<String, Object> map = excludeTrash(param.getJSONObject("order")); @@ -339,16 +381,22 @@ } @RequestMapping(value = "/orderQuery/auth") - @ManagerAuth +// @ManagerAuth public R query(String condition) { EntityWrapper<Order> wrapper = new EntityWrapper<>(); - wrapper.like("id", condition); + wrapper.like("order_no", condition); + wrapper.le("settle", 3); Page<Order> page = orderService.selectPage(new Page<>(0, 10), wrapper); List<Map<String, Object>> result = new ArrayList<>(); - for (Order order : page.getRecords()){ + for (Order order : page.getRecords()) { Map<String, Object> map = new HashMap<>(); map.put("id", order.getId()); map.put("value", order.getOrderNo()); + map.put("customer", order.getCstmrName()); + map.put("phone", order.getTel()); + map.put("addr", order.getNumber()); + map.put("allocate", order.getItemName()); + map.put("type", "order"); result.add(map); } return R.ok(result); @@ -358,26 +406,27 @@ @ManagerAuth public R query(@RequestBody JSONObject param) { Wrapper<Order> wrapper = new EntityWrapper<Order>().eq(humpToLine(String.valueOf(param.get("key"))), param.get("val")); - if (null != orderService.selectOne(wrapper)){ + if (null != orderService.selectOne(wrapper)) { return R.parse(BaseRes.REPEAT).add(getComment(Order.class, String.valueOf(param.get("key")))); } return R.ok(); } + @RequestMapping(value = "/order/print/auth") @ManagerAuth(memo = "璁㈠崟缂栫爜鎵撳嵃") public R orderPrint(@RequestParam(value = "param[]") String[] param) { - if(Cools.isEmpty(param)) { + if (Cools.isEmpty(param)) { return R.parse(CodeRes.EMPTY); } List<OrderDetl> res = new ArrayList<>(); - for (String orderNo : param){ + for (String orderNo : param) { res = orderDetlService.selectList(new EntityWrapper<OrderDetl>().eq("order_no", orderNo)); } return R.ok().add(res); } @RequestMapping("/order/in") - public R in(@RequestBody JSONObject param){ + public R in(@RequestBody JSONObject param) { System.out.println("111 = " + 111); return R.ok(); } @@ -387,13 +436,28 @@ public void export(HttpServletResponse response, @RequestParam String orderNo) throws IOException { //浠庢暟鎹簱鏌ヨ鏁版嵁 EntityWrapper<OrderDetl> locCheckEntityWrapper = new EntityWrapper<>(); - locCheckEntityWrapper.eq("order_no",orderNo); + locCheckEntityWrapper.eq("order_no", orderNo); List<OrderDetl> list = orderDetlService.selectList(locCheckEntityWrapper); - + List<OrderDetlVo> orderDetlVos = new ArrayList<>(); + OrderDetlVo orderDetlVo = new OrderDetlVo(); + for (OrderDetl o : + list) { + orderDetlVo.setOrderNo(o.getOrderNo()); + orderDetlVo.setMatnr(o.getMatnr()); + orderDetlVo.setMaktx(o.getMaktx()); + orderDetlVo.setSpecs(o.getSpecs()); + orderDetlVo.setOwner(o.getOwner$()); + orderDetlVo.setPayment(o.getPayment$()); + orderDetlVo.setAnfme(o.getAnfme()); + orderDetlVo.setQty(o.getQty()); + orderDetlVo.setWorkQty(o.getWorkQty()); + orderDetlVo.setWeight(o.getWeight()); + orderDetlVos.add(orderDetlVo); + } response.setContentType("application/vnd.ms-excel"); response.setCharacterEncoding("utf-8"); String fileName = URLEncoder.encode("鍗曟嵁", "UTF-8"); - response.setHeader("Content-disposition", "attachment;filename=" + fileName+ orderNo + ".xlsx"); + response.setHeader("Content-disposition", "attachment;filename=" + fileName + orderNo + ".xlsx"); Set<String> includeColumnFiledNames = new HashSet<String>(); includeColumnFiledNames.add("orderNo"); includeColumnFiledNames.add("matnr"); @@ -405,11 +469,85 @@ includeColumnFiledNames.add("qty"); includeColumnFiledNames.add("workQty"); includeColumnFiledNames.add("weight"); - EasyExcel.write(response.getOutputStream(), OrderDetl.class) + EasyExcel.write(response.getOutputStream(), OrderDetlVo.class) .registerWriteHandler(new LongestMatchColumnWidthStyleStrategy()) .includeColumnFiledNames(includeColumnFiledNames) .sheet("琛�1") - .doWrite(list); + .doWrite(orderDetlVos); + } + + @PostMapping (value = "/order/definedExcelExport/auth") + @ManagerAuth + public void export(HttpServletResponse response, @RequestBody DefinedExcelExportParam definedExcelExportParam) throws IOException { + + EntityWrapper<OrderDetl> orderDetlEntityWrapper = new EntityWrapper<>(); + + if ("all".equals(definedExcelExportParam.getType())) { + DefinedExcelExportParam.QueryWhere queryWhere = definedExcelExportParam.getQueryWhere(); + EntityWrapper<Order> orderEntityWrapper = new EntityWrapper<>(); + + // 闄愬埗閿�鍞鑹插彧鑳界湅鑷繁鍒涘缓鐨勫崟瀛愶紙閿�鍞鑹瞚d鍥哄畾21锛屼笉鑳介殢鎰忎慨鏀癸級 + User user = getUser(); + if (user.getRoleId() != 2 && user.getRoleId() != 24) { + orderEntityWrapper.eq("create_by", user.getId()); + } + // 鎿嶄綔浜猴細璁㈠崟琛ㄥ彧瀛樹簡鎿嶄綔浜篿d,鎵�浠ユ搷浣滀汉濮撳悕鏌ヨ锛屽彧鑳戒粠濮撳悕鍏堝幓鎵緄d锛� + Object userName = queryWhere.getOper_memb(); + if (userName != null && user.getRoleId() != 21) { + List<User> users = userService.selectList(new EntityWrapper<User>().eq("username", queryWhere.getOper_memb())); + if (users.size() > 0) { + orderEntityWrapper.in("create_by", users.stream().map(User::getId).collect(Collectors.toList())); + } + } + // 璁㈠崟缂栧彿 + if (!Cools.isEmpty(queryWhere.getOrder_no())) { + orderEntityWrapper.eq("order_no", queryWhere.getOrder_no()); + } + // 鍒涘缓鏃堕棿 + if (queryWhere.getCreate_time().contains(RANGE_TIME_LINK)) { + String[] dates = queryWhere.getCreate_time().split(RANGE_TIME_LINK); + orderEntityWrapper.ge("create_time", DateUtils.convert(dates[0])); + orderEntityWrapper.le("create_time", DateUtils.convert(dates[1])); + } + // 鍗曟嵁绫诲瀷 + if (!Cools.isEmpty(queryWhere.getDoc_type())) { + orderEntityWrapper.eq("doc_type", queryWhere.getDoc_type()); + } + // 鍗曟嵁鐘舵�� + if (!Cools.isEmpty(queryWhere.getSettle())) { + orderEntityWrapper.eq("settle", queryWhere.getSettle()); + } + // 瀹㈡埛鍚嶇О + if (!Cools.isEmpty(queryWhere.getCstmr_name())) { + orderEntityWrapper.eq("cstmr_name", queryWhere.getCstmr_name()); + } + // 鏈垹闄� + orderEntityWrapper.eq("status", 1); + orderEntityWrapper.setSqlSelect("order_no as orderNo"); + List<Order> orderList = orderService.selectList(orderEntityWrapper); + orderDetlEntityWrapper.in("order_no", orderList.stream().map(Order::getOrderNo).collect(Collectors.toList())); + + } else { + orderDetlEntityWrapper.in("order_no", definedExcelExportParam.getOrderNoList()); + } + + List<OrderDetl> list = orderDetlService.selectList(orderDetlEntityWrapper); + List<OrderDetlExcelVo> orderDetlExcelVoList = new ArrayList<>(); + + for (OrderDetl orderDetl : list) { + OrderDetlExcelVo orderDetlExcelVo = new OrderDetlExcelVo(); + BeanUtils.copyProperties(orderDetl,orderDetlExcelVo); + orderDetlExcelVoList.add(orderDetlExcelVo); + } + + response.setContentType("application/vnd.ms-excel"); + response.setCharacterEncoding("utf-8"); + String fileName = URLEncoder.encode("鍗曟嵁", "UTF-8"); + response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".xlsx"); + EasyExcel.write(response.getOutputStream(), OrderDetlExcelVo.class) + .sheet("琛�1") + .doWrite(orderDetlExcelVoList); + } @RequestMapping(value = "/order/list/all") @@ -418,12 +556,20 @@ return R.ok(orderService.selectAllorderNo()); } + //璁㈠崟缁勬墭2 @RequestMapping(value = "/order/list/orderNo") public R orderListorderNo(@RequestParam String orderNo) { - - return R.ok(orderDetlService.selectList(new EntityWrapper<OrderDetl>().eq("order_no",orderNo))); + //鏁伴噺淇敼鎴愪负瀹屾垚鏁伴噺 + List<OrderDetl> orderDetl1 = orderDetlService.selectList(new EntityWrapper<OrderDetl>().eq("order_no", orderNo)); + List<OrderDetl> orderDetls = new ArrayList<OrderDetl>(); + for (OrderDetl o : orderDetl1) { + o.setAnfme(o.getAnfme() - o.getWorkQty()); + BigDecimal c1 = new BigDecimal(o.getAnfme()).setScale(2, BigDecimal.ROUND_HALF_UP); + o.setAnfme(c1.doubleValue()); + orderDetls.add(o); + } + return R.ok(orderDetls); } - } -- Gitblit v1.9.1