PurchaseDealerOrderController.java 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489
  1. package com.trade.purchase.dealer;
  2. import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
  3. import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
  4. import com.baomidou.mybatisplus.core.metadata.IPage;
  5. import com.baomidou.mybatisplus.core.toolkit.CollectionUtils;
  6. import com.baomidou.mybatisplus.core.toolkit.StringUtils;
  7. import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
  8. import com.github.xiaoymin.knife4j.annotations.ApiOperationSupport;
  9. import com.trade.purchase.order.dto.OrderSubmitDto;
  10. import com.trade.purchase.order.entity.Order;
  11. import com.trade.purchase.order.entity.OrderFees;
  12. import com.trade.purchase.order.entity.OrderFiles;
  13. import com.trade.purchase.order.entity.OrderItems;
  14. import com.trade.purchase.order.enums.OrderTypeEnum;
  15. import com.trade.purchase.order.service.IOrderFeesService;
  16. import com.trade.purchase.order.service.IOrderFilesService;
  17. import com.trade.purchase.order.service.IOrderItemsService;
  18. import com.trade.purchase.order.service.IOrderService;
  19. import com.trade.purchase.order.vo.OrderDTO;
  20. import com.trade.purchase.order.vo.OrderVO;
  21. import io.swagger.annotations.Api;
  22. import io.swagger.annotations.ApiOperation;
  23. import io.swagger.annotations.ApiParam;
  24. import lombok.AllArgsConstructor;
  25. import org.springblade.client.entity.CorpsDesc;
  26. import org.springblade.client.feign.ICorpsDescClient;
  27. import org.springblade.client.feign.IGoodsDescClient;
  28. import org.springblade.client.vo.GoodsDescVO;
  29. import org.springblade.core.boot.ctrl.BladeController;
  30. import org.springblade.core.secure.utils.AuthUtil;
  31. import org.springblade.core.tool.api.R;
  32. import org.springblade.core.tool.utils.Func;
  33. import org.springblade.system.user.entity.User;
  34. import org.springblade.system.user.feign.IUserClient;
  35. import org.springframework.web.bind.annotation.*;
  36. import javax.validation.Valid;
  37. import java.math.BigDecimal;
  38. import java.util.Collections;
  39. import java.util.Date;
  40. import java.util.List;
  41. import java.util.stream.Collectors;
  42. /**
  43. * 进口采购订单表 控制器
  44. *
  45. * @author BladeX
  46. * @since 2021-09-26
  47. */
  48. @RestController
  49. @AllArgsConstructor
  50. @RequestMapping("/dealer/purchaseOrder")
  51. @Api(value = "经销商采购订单", tags = "经销商采购订单")
  52. public class PurchaseDealerOrderController extends BladeController {
  53. private final IOrderService orderService;
  54. private final IOrderFeesService orderFeesService;
  55. private final IOrderFilesService orderFilesService;
  56. private final IOrderItemsService orderItemsService;
  57. private final String ERROR_MSG = "缺少查询信息";
  58. private ICorpsDescClient corpsDescClient;//获取客户信息
  59. private IGoodsDescClient goodsDescClient;
  60. private IUserClient userClient;
  61. /**
  62. * 详情
  63. */
  64. @GetMapping("/{id}")
  65. @ApiOperationSupport(order = 1)
  66. @ApiOperation(value = "采购订单查看详情", notes = "传入order")
  67. public R<OrderVO> detail(@PathVariable(value = "id") String id) {
  68. R<OrderVO> orderMessage = orderService.getOrderMessage(id);
  69. if(orderMessage.isSuccess()&&orderMessage.getData()!=null)
  70. {
  71. R<User> user1 = userClient.userInfoById(orderMessage.getData().getUpdateUser());
  72. if (user1.isSuccess() && user1.getData() != null){
  73. orderMessage.getData().setUpdateUserName(user1.getData().getName());
  74. }
  75. R<User> user = userClient.userInfoById(orderMessage.getData().getCreateUser());
  76. if (user.isSuccess() && user.getData() != null){
  77. orderMessage.getData().setCreateUserName(user.getData().getName());
  78. }
  79. orderMessage.getData().getOrderItemsList().forEach(e->{
  80. R<User> user2 = userClient.userInfoById(e.getUpdateUser());
  81. if (user2.isSuccess() && user2.getData() != null){
  82. e.setUpdateUserName(user2.getData().getName());
  83. }
  84. R<User> user3 = userClient.userInfoById(e.getCreateUser());
  85. if (user3.isSuccess() && user3.getData() != null){
  86. e.setCreateUserName(user3.getData().getName());
  87. }
  88. });
  89. }
  90. return orderMessage;
  91. }
  92. /**
  93. * 分页 销售或采购订单表
  94. */
  95. @GetMapping("/list")
  96. @ApiOperationSupport(order = 2)
  97. @ApiOperation(value = "采购订单表列表(内贸 外贸 出口)", notes = "传入order")
  98. public R<?> list( @RequestParam(name = "current", defaultValue = "1") Integer current,
  99. @RequestParam(name = "size", defaultValue = "10") Integer size,
  100. @RequestParam(value = "billNo",required = false) String billNo,//提单号
  101. @RequestParam(value = "orderNo",required = false) String orderNo,//合同号
  102. @RequestParam(value = "tradeType",required = false) String tradeType,//贸易类型
  103. @RequestParam(value = "strCorpName",required = false) String strCorpName,//供应商名称
  104. @RequestParam(value = "corpId",required = false) String corpId,//供应商id
  105. @RequestParam(value = "strPurchaserName",required = false) String strPurchaserName,//采购商名称
  106. @RequestParam(value = "salesName",required = false) String salesName,//业务员
  107. @RequestParam(value = "banksAccountName",required = false) String banksAccountName,//公司户头
  108. @RequestParam(value = "packageRemarks",required = false) String packageRemarks,//包装要求
  109. @RequestParam(value = "createUser",required = false) Long createUser,//制单人
  110. @RequestParam(value = "paymentType",required = false) String paymentType,//付款方式
  111. @RequestParam(value = "createStartTime",required = false) String createStartTime,//制单日期
  112. @RequestParam(value = "createEndTime",required = false) String createEndTime,//制单日期
  113. @RequestParam(value = "businesStartDate",required = false) String businesStartDate,//订单开始时间 busines_date
  114. @RequestParam(value = "businesEndDate",required = false) String businesEndDate,//订单结束时间
  115. @RequestParam(value = "accountsCollectionStartDate",required = false) String accountsCollectionStartDate,//应收(付)款开始时间 accounts_collection_date
  116. @RequestParam(value = "accountsCollectionEndDate",required = false) String accountsCollectionEndDate,//应收(付)款结束时间
  117. @RequestParam(value = "dateOfStartArrival",required = false) String dateOfStartArrival,//实际到港开始日期 date_of_arrival
  118. @RequestParam(value = "dateOfEndArrival",required = false) String dateOfEndArrival,//实际到港结束时间,
  119. @RequestParam(value = "requiredDeliveryStartDate",required = false) String requiredDeliveryStartDate,//要求发货开始日期 required_delivery_date
  120. @RequestParam(value = "requiredDeliveryEndDate",required = false) String requiredDeliveryEndDate,//要求发货结束时间
  121. @RequestParam(value = "requiredArrivalStartDate",required = false) String requiredArrivalStartDate,//要求到货开始日期 required_arrival_date
  122. @RequestParam(value = "requiredArrivalEndDate",required = false) String requiredArrivalEndDate,//要求到货结束日期
  123. @RequestParam(value = "creditStartDate",required = false) String creditStartDate,//信用证到期日-开始日期 credit_date
  124. @RequestParam(value = "creditEndDate",required = false) String creditEndDate,//信用证到期日-结束时间
  125. Order order
  126. )
  127. {
  128. QueryWrapper<Order> queryWrapper =new QueryWrapper<>();
  129. //供应商
  130. if(StringUtils.isNotBlank(strCorpName))
  131. {
  132. List<CorpsDesc> corpsDescs = corpsDescClient.listCorpByName(strCorpName);
  133. if(CollectionUtils.isNotEmpty(corpsDescs))
  134. {
  135. List<Long> corpIds = corpsDescs.stream().map(CorpsDesc::getId).collect(Collectors.toList());
  136. queryWrapper.in("corp_id",corpIds);
  137. }
  138. else
  139. {
  140. return R.data(Collections.EMPTY_LIST,"暂无相关数据");
  141. }
  142. }
  143. //采购商
  144. if(StringUtils.isNotBlank(strPurchaserName))
  145. {
  146. List<CorpsDesc> corpsDescs = corpsDescClient.listCorpByName(strPurchaserName);
  147. if(CollectionUtils.isNotEmpty(corpsDescs))
  148. {
  149. List<Long> purchaserIds = corpsDescs.stream().map(CorpsDesc::getId).collect(Collectors.toList());
  150. queryWrapper.in("purchaser_id",purchaserIds);
  151. }
  152. else
  153. {
  154. return R.data(Collections.EMPTY_LIST,"暂无相关数据");
  155. }
  156. }
  157. queryWrapper.like(StringUtils.isNotBlank(banksAccountName),"banks_account_name",banksAccountName);
  158. queryWrapper.like(StringUtils.isNotBlank(packageRemarks),"package_remarks",packageRemarks);
  159. queryWrapper.like(StringUtils.isNotBlank(salesName),"sales_name",salesName);
  160. queryWrapper.like(StringUtils.isNotBlank(orderNo),"order_no",orderNo);
  161. queryWrapper.like(StringUtils.isNotBlank(paymentType),"payment_type",paymentType);
  162. queryWrapper.eq(StringUtils.isNotBlank(corpId),"corp_id",corpId);
  163. queryWrapper.eq("tenant_id",AuthUtil.getTenantId());
  164. queryWrapper.eq(createUser!=null,"create_user",createUser);
  165. queryWrapper.eq("bill_type",OrderTypeEnum.PURCHASE.getType());
  166. queryWrapper.eq("trade_type",OrderTypeEnum.DEALER.getType());
  167. queryWrapper.like(StringUtils.isNotBlank(billNo),"bill_no",billNo);
  168. queryWrapper.between(StringUtils.isNotBlank(createStartTime)&&StringUtils.isNotBlank(createEndTime),"create_time",createStartTime,createEndTime);
  169. queryWrapper.between(StringUtils.isNotBlank(businesStartDate)&&StringUtils.isNotBlank(businesEndDate),"busines_date",businesStartDate,businesEndDate);
  170. queryWrapper.between(StringUtils.isNotBlank(accountsCollectionStartDate)&&StringUtils.isNotBlank(accountsCollectionEndDate),"accounts_collection_date",accountsCollectionStartDate,accountsCollectionEndDate);
  171. queryWrapper.between(StringUtils.isNotBlank(dateOfStartArrival)&&StringUtils.isNotBlank(dateOfEndArrival),"date_of_arrival",dateOfStartArrival,dateOfEndArrival);
  172. queryWrapper.between(StringUtils.isNotBlank(requiredDeliveryStartDate)&&StringUtils.isNotBlank(requiredDeliveryEndDate),"required_delivery_date",requiredDeliveryStartDate,requiredDeliveryEndDate);
  173. queryWrapper.between(StringUtils.isNotBlank(requiredArrivalStartDate)&&StringUtils.isNotBlank(requiredArrivalEndDate),"required_arrival_date",requiredArrivalStartDate,requiredArrivalEndDate);
  174. queryWrapper.between(StringUtils.isNotBlank(creditStartDate)&&StringUtils.isNotBlank(creditEndDate),"credit_date",creditStartDate,creditEndDate);
  175. queryWrapper.orderByDesc("create_time");
  176. Page<Order> page=new Page<>(current,size);
  177. IPage<Order> pages = orderService.page(page,queryWrapper);
  178. List<Order> records = pages.getRecords();
  179. if(CollectionUtils.isNotEmpty(records))
  180. {
  181. records.forEach(e->{
  182. if(e.getBelongToCorpId()!=null)
  183. {
  184. R<CorpsDesc> corpMessage3 = corpsDescClient.getCorpMessage(e.getBelongToCorpId());
  185. if(corpMessage3.getData()!=null)
  186. {
  187. e.setBelongToCorpName(corpMessage3.getData().getCname());
  188. }
  189. }
  190. //制单人名字
  191. if(e.getCreateUser()!=null)
  192. {
  193. R<User> userR = userClient.userInfoById(e.getCreateUser());
  194. if(userR.isSuccess())
  195. {
  196. e.setCreateUserName(userR.getData().getRealName());
  197. }
  198. }
  199. //修改制单人名字
  200. if(e.getUpdateUser()!=null)
  201. {
  202. R<User> userR = userClient.userInfoById(e.getUpdateUser());
  203. if(userR.isSuccess())
  204. {
  205. e.setUpdateUserName(userR.getData().getRealName());
  206. }
  207. }
  208. //获取供应商中文名
  209. if (e.getCorpId() != null){
  210. R<CorpsDesc> corpMessage1 = corpsDescClient.getCorpMessage(e.getCorpId());
  211. if(corpMessage1.getData()!=null)
  212. {
  213. e.setStrCorpName(corpMessage1.getData().getCname());
  214. }
  215. }
  216. //获取采购商中文名
  217. if (e.getPurchaserId() != null){
  218. R<CorpsDesc> corpMessage2 = corpsDescClient.getCorpMessage(e.getPurchaserId());
  219. if(corpMessage2.getData()!=null)
  220. {
  221. e.setStrPurchaserName(corpMessage2.getData().getCname());
  222. }
  223. }
  224. List<OrderItems> orderItemsList = orderItemsService.list(new LambdaQueryWrapper<OrderItems>().eq(OrderItems::getIsDeleted, 0).eq(OrderItems::getPid, e.getId()));
  225. //是否有子项
  226. Boolean flag=orderItemsService.count(new LambdaQueryWrapper<OrderItems>().eq(OrderItems::getPid,e.getId()))>0?true:false;
  227. if(CollectionUtils.isNotEmpty(orderItemsList))
  228. {
  229. //子项总件数
  230. BigDecimal orderQuantity = orderItemsList.stream().filter(it -> it.getOrderQuantity() != null)
  231. .map(OrderItems::getOrderQuantity)
  232. .reduce(BigDecimal.ZERO, BigDecimal::add);
  233. e.setOrderQuantity(orderQuantity);
  234. //子项总收货数
  235. BigDecimal actualQuantity = orderItemsList.stream().filter(it -> it.getActualQuantity() != null)
  236. .map(OrderItems::getActualQuantity)
  237. .reduce(BigDecimal.ZERO, BigDecimal::add);
  238. e.setActualQuantity(actualQuantity);
  239. //已收重量
  240. BigDecimal actualWeight = orderItemsList.stream().filter(it -> it.getActualWeight() != null)
  241. .map(OrderItems::getActualWeight)
  242. .reduce(BigDecimal.ZERO, BigDecimal::add);
  243. e.setActualWeight(actualWeight);
  244. }
  245. });
  246. }
  247. return R.data(pages);
  248. }
  249. /* *//**
  250. * 自定义分页 销售或采购订单表
  251. *//*
  252. @GetMapping("/page")
  253. @ApiOperationSupport(order = 3)
  254. @ApiOperation(value = "分页", notes = "传入order")
  255. public R<IPage<OrderVO>> page(OrderVO order, Query query) {
  256. order.setIsDeleted(0);
  257. order.setTenantId(AuthUtil.getTenantId());
  258. order.setBillType(OrderTypeEnum.PURCHASE.getType());
  259. order.setTradeType(OrderTypeEnum.IMPORT.getType());
  260. IPage<OrderVO> pages = orderService.selectOrderPage(Condition.getPage(query), order);
  261. return R.data(pages);
  262. }*/
  263. /**
  264. * 新增 销售或采购订单表
  265. */
  266. /*@PostMapping("/save")
  267. @ApiOperationSupport(order = 4)
  268. @ApiOperation(value = "新增", notes = "传入order")
  269. public R<String> save(@Valid @RequestBody OrderSubmitDto submitDto) {
  270. return orderService.saveOrderMessage(submitDto);
  271. }*/
  272. /**
  273. * 修改 销售或采购订单表
  274. */
  275. /*@PostMapping("/update")
  276. @ApiOperationSupport(order = 5)
  277. @ApiOperation(value = "修改", notes = "传入order")
  278. public R<String> update(@Valid @RequestBody Order order) {
  279. if (order.getId() == null) {
  280. return R.fail(ERROR_MSG);
  281. }
  282. order.setIsDeleted(1);
  283. return R.status(orderService.updateById(order));
  284. }*/
  285. /**
  286. * 新增或修改 销售或采购订单表
  287. */
  288. @PostMapping("/submit")
  289. @ApiOperationSupport(order = 6)
  290. @ApiOperation(value = "新增或修改", notes = "传入order")
  291. public R<String> submit(@Valid @RequestBody OrderSubmitDto submitDto)
  292. {
  293. /*if(ObjectUtil.isEmpty(submitDto.getBillType())||ObjectUtil.isEmpty(submitDto.getSrcId())||ObjectUtil.isEmpty(submitDto.getBusinesDate()))
  294. {
  295. throw new ServiceException("来源、合同日期、贸易类型不能为空!");
  296. }*/
  297. submitDto.setOrderTypeEnum(OrderTypeEnum.PURCHASE);
  298. submitDto.setBillType(OrderTypeEnum.PURCHASE.getType());
  299. submitDto.setTradeType(OrderTypeEnum.DEALER.getType());
  300. return orderService.submitOrderMessage(submitDto);
  301. }
  302. /**
  303. * 删除 销售或采购订单表
  304. */
  305. @PostMapping("/remove")
  306. @ApiOperationSupport(order = 7)
  307. @ApiOperation(value = "删除", notes = "传入ids")
  308. public R<String> remove(@ApiParam(value = "主键集合", required = true) @RequestParam String ids) {
  309. return R.status(orderService.removeByIds(Func.toLongList(ids)));
  310. }
  311. /**
  312. * 删除采购明细信息
  313. */
  314. @PostMapping("/removeByItem")
  315. @ApiOperationSupport(order = 8)
  316. @ApiOperation(value = "删除采购明细信息", notes = "传入order")
  317. public R<String> update(@Valid @RequestBody OrderItems items) {
  318. if (items.getId() == null) {
  319. return R.fail(ERROR_MSG);
  320. }
  321. return R.status(orderItemsService.removeById(items.getId()));
  322. }
  323. /**
  324. * 删除费用信息
  325. */
  326. @PostMapping("/removeByFees")
  327. @ApiOperationSupport(order = 8)
  328. @ApiOperation(value = "删除费用信息", notes = "传入order")
  329. public R<String> update(@Valid @RequestBody OrderFees order) {
  330. if (order.getId() == null) {
  331. return R.fail(ERROR_MSG);
  332. }
  333. return R.status(orderFeesService.removeById(order.getId()));
  334. }
  335. /**
  336. * 删除订单文件信息
  337. *
  338. * @param order
  339. * @return
  340. */
  341. @PostMapping("/removeByFiles")
  342. @ApiOperationSupport(order = 9)
  343. @ApiOperation(value = "删除文件信息", notes = "传入order")
  344. public R<String> update(@Valid @RequestBody OrderFiles order) {
  345. if (order.getId() == null) {
  346. return R.fail(ERROR_MSG);
  347. }
  348. return R.status(orderFilesService.removeById(order.getId()));
  349. }
  350. @GetMapping("getItemByPid")
  351. @ApiOperation(value = "查询采购订单的子明细", notes = "通过采购订单的id查询")
  352. public R getItemByPid(@RequestParam(value = "id",required = true)Long id)
  353. {
  354. LambdaQueryWrapper<OrderItems> lambdaQueryWrapper=new LambdaQueryWrapper<>();
  355. lambdaQueryWrapper.eq(OrderItems::getPid,id);
  356. List<OrderItems> itemsList = orderItemsService.list(lambdaQueryWrapper);
  357. return R.data(itemsList);
  358. }
  359. @GetMapping("getSysNo")
  360. @ApiOperation(value = "采购订单获取系统编号prefix=GN JK CK", notes = "采购订单获取系统编号prefix=GN JK CK")
  361. public R getSysNo(@RequestParam(value = "prefix",required = true)String prefix,
  362. @RequestParam(value = "tradeType",required = true)String tradeType)
  363. {
  364. return orderService.getSysNo(prefix,tradeType);
  365. }
  366. @GetMapping("getItemListByConditions")
  367. @ApiOperation(value = "收发单-获取商品明细", notes = "收发单-获取商品明细")
  368. public R getItemListByConditions(@RequestParam(name = "current", defaultValue = "1") Integer current,
  369. @RequestParam(name = "size", defaultValue = "10") Integer size,
  370. @RequestParam(name = "tradeType", required = true) String tradeType,
  371. @RequestParam(name = "orderNo", required = false) String orderNo,
  372. @RequestParam(name = "corpId", required = false) Long corpId,
  373. @RequestParam(name = "startDate", required = false) String startDate,
  374. @RequestParam(name = "endDate", required = false) String endDate
  375. )
  376. {
  377. Page<OrderDTO> page=new Page<>(current,size);
  378. IPage<OrderDTO> iPage = orderService.listOrderItem(page, tradeType, orderNo, corpId, startDate, endDate);
  379. if(CollectionUtils.isNotEmpty(iPage.getRecords()))
  380. {
  381. iPage.getRecords().forEach(e->{
  382. //商品信息
  383. R<GoodsDescVO> goodsDescVOR = goodsDescClient.selectGoodsMessage(e.getItemId());
  384. if(goodsDescVOR.isSuccess())
  385. {
  386. GoodsDescVO descVO = goodsDescVOR.getData();
  387. if(descVO!=null)
  388. {
  389. e.setPriceCategoryNames(descVO.getCname());
  390. }
  391. }
  392. //供应商信息
  393. if (e.getCorpId() != null){
  394. R<CorpsDesc> corpMessage = corpsDescClient.getCorpMessage(e.getCorpId());
  395. if(corpMessage.getData()!=null)
  396. {
  397. e.setCorpName(corpMessage.getData().getCname());
  398. }
  399. }
  400. });
  401. }
  402. return R.data(iPage);
  403. }
  404. /**
  405. * 更改打印时间和打印次数
  406. */
  407. @GetMapping("/print")
  408. @ApiOperationSupport(order = 11)
  409. @ApiOperation(value = "更改打印时间和打印次数", notes = "传入order")
  410. public R<Order> print(Order order) {
  411. if (order.getId() == null){
  412. throw new SecurityException("请选择要打印的单据");
  413. }
  414. Order service = orderService.getById(order.getId());
  415. service.setPrintNumber(service.getPrintNumber() +1);
  416. service.setPrintTime(new Date());
  417. return R.status(orderService.updateById(service));
  418. }
  419. /**
  420. * 确认或取消订单
  421. */
  422. @GetMapping("/dealerSubmit")
  423. @ApiOperationSupport(order = 12)
  424. @ApiOperation(value = "确认或取消订单", notes = "传入order")
  425. public R<Order> dealerSubmit(Order order) {
  426. if (order.getDealer() != 1 && order.getDealer() != 2){
  427. throw new SecurityException("缺少必要的参数");
  428. }
  429. if (order.getId() == null){
  430. throw new SecurityException("缺少必要的参数");
  431. }
  432. return orderService.dealerSubmit(order);
  433. }
  434. }