PurchaseEnquiry.java 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300
  1. package com.trade.purchase.enquiry;
  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.github.xiaoymin.knife4j.annotations.ApiOperationSupport;
  8. import com.trade.purchase.order.dto.OrderSubmitDto;
  9. import com.trade.purchase.order.entity.Order;
  10. import com.trade.purchase.order.entity.OrderFees;
  11. import com.trade.purchase.order.entity.OrderFiles;
  12. import com.trade.purchase.order.entity.OrderItems;
  13. import com.trade.purchase.order.enums.OrderTypeEnum;
  14. import com.trade.purchase.order.service.IOrderFeesService;
  15. import com.trade.purchase.order.service.IOrderFilesService;
  16. import com.trade.purchase.order.service.IOrderItemsService;
  17. import com.trade.purchase.order.service.IOrderService;
  18. import com.trade.purchase.order.vo.OrderVO;
  19. import io.swagger.annotations.Api;
  20. import io.swagger.annotations.ApiOperation;
  21. import io.swagger.annotations.ApiParam;
  22. import lombok.AllArgsConstructor;
  23. import org.springblade.client.entity.CorpsDesc;
  24. import org.springblade.client.feign.ICorpsDescClient;
  25. import org.springblade.core.boot.ctrl.BladeController;
  26. import org.springblade.core.mp.support.Condition;
  27. import org.springblade.core.mp.support.Query;
  28. import org.springblade.core.secure.utils.AuthUtil;
  29. import org.springblade.core.secure.utils.SecureUtil;
  30. import org.springblade.core.tool.api.R;
  31. import org.springblade.core.tool.utils.Func;
  32. import org.springblade.system.user.entity.User;
  33. import org.springblade.system.user.feign.IUserClient;
  34. import org.springframework.web.bind.annotation.*;
  35. import javax.validation.Valid;
  36. import java.math.BigDecimal;
  37. import java.util.List;
  38. /**
  39. * 出口采购询价 控制器
  40. *
  41. * @author BladeX
  42. * @since 2021-09-26
  43. */
  44. @RestController
  45. @AllArgsConstructor
  46. @RequestMapping("/purchase-enquiry")
  47. @Api(value = "出口采购询价", tags = "出口采购询价接口")
  48. public class PurchaseEnquiry extends BladeController {
  49. private final IOrderService orderService;
  50. private final IOrderFeesService orderFeesService;
  51. private final IOrderFilesService orderFilesService;
  52. private final IOrderItemsService orderItemsService;
  53. private final String ERROR_MSG = "缺少查询信息";
  54. private final ICorpsDescClient corpsDescClient;//获取客户信息
  55. private final IUserClient userClient;//获取用户信息
  56. /**
  57. * 详情
  58. */
  59. @GetMapping("/{id}")
  60. @ApiOperationSupport(order = 1)
  61. @ApiOperation(value = "详情", notes = "传入order")
  62. public R<OrderVO> detail(@PathVariable(value = "id") String id) {
  63. return orderService.getOrderMessage(id);
  64. }
  65. /**
  66. * 分页 出口采购询价
  67. */
  68. @GetMapping("/list")
  69. @ApiOperationSupport(order = 2)
  70. @ApiOperation(value = "查询所有", notes = "传入order")
  71. public R<IPage<Order>> list(Order order, Query query) {
  72. order.setIsDeleted(0);
  73. order.setTenantId(AuthUtil.getTenantId());
  74. order.setBillType(OrderTypeEnum.PURCHASE_ENQUIRY.getType());
  75. order.setTradeType(OrderTypeEnum.EXPORT.getType());
  76. IPage<Order> pages = orderService.page(Condition.getPage(query), Condition.getQueryWrapper(order));
  77. return R.data(pages);
  78. }
  79. /**
  80. * 自定义分页 出口采购询价
  81. */
  82. @GetMapping("/page")
  83. @ApiOperationSupport(order = 3)
  84. @ApiOperation(value = "分页", notes = "传入order")
  85. public R<IPage<Order>> page(OrderVO order, Query query) {
  86. LambdaQueryWrapper<Order> lambdaQueryWrapper = new LambdaQueryWrapper<>();
  87. lambdaQueryWrapper.eq(Order::getTenantId, SecureUtil.getTenantId());//租户id
  88. lambdaQueryWrapper.eq(Order::getIsDeleted, 0);//订单是否有效
  89. lambdaQueryWrapper.eq(Order::getBillType, OrderTypeEnum.PURCHASE_ENQUIRY.getType());//订单类型
  90. lambdaQueryWrapper.eq(Order::getTradeType, OrderTypeEnum.EXPORT.getType());//贸易类型
  91. lambdaQueryWrapper.like(Func.isNotEmpty(order.getOrderNo()), Order::getOrderNo, order.getOrderNo());//订单号
  92. lambdaQueryWrapper.like(Func.isNotEmpty(order.getCorpId()), Order::getCorpId, order.getCorpId());//客户id
  93. lambdaQueryWrapper.ge(Func.isNotEmpty(order.getContractStartDate()), Order::getBusinesDate, order.getContractStartDate());//合同日期开始
  94. lambdaQueryWrapper.le(Func.isNotEmpty(order.getContractStartDate()), Order::getBusinesDate, order.getContractStartDate());//合同日期结束
  95. lambdaQueryWrapper.like(Func.isNotEmpty(order.getSrcOrderNo()), Order::getSrcOrderNo, order.getSrcOrderNo());//订单来源
  96. lambdaQueryWrapper.like(Func.isNotEmpty(order.getShippingAddress()), Order::getShippingAddress, order.getShippingAddress());//发货地址
  97. lambdaQueryWrapper.like(Func.isNotEmpty(order.getArrivalAddress()), Order::getArrivalAddress, order.getArrivalAddress());//到货地址
  98. lambdaQueryWrapper.ge(Func.isNotEmpty(order.getActualDeliveryDateStart()), Order::getActualDeliveryDate, order.getActualDeliveryDateStart());//发货日期开始
  99. lambdaQueryWrapper.le(Func.isNotEmpty(order.getActualDeliveryDateEnd()), Order::getActualDeliveryDate, order.getActualDeliveryDateEnd());//发货日期结束
  100. lambdaQueryWrapper.ge(Func.isNotEmpty(order.getDeliveryStartDate()), Order::getRequiredDeliveryDate, order.getDeliveryStartDate());//要求发货日期开始
  101. lambdaQueryWrapper.le(Func.isNotEmpty(order.getDeliveryEndDate()), Order::getRequiredDeliveryDate, order.getDeliveryEndDate());//要求发货日期结束
  102. lambdaQueryWrapper.ge(Func.isNotEmpty(order.getArrivalDateStart()), Order::getRequiredArrivalDate, order.getArrivalDateStart());//要求到货日期开始
  103. lambdaQueryWrapper.le(Func.isNotEmpty(order.getArrivalDateEnd()), Order::getRequiredArrivalDate, order.getArrivalDateEnd());//要求到货日期结束
  104. lambdaQueryWrapper.like(Func.isNotEmpty(order.getOrderStatus()), Order::getOrderStatus, order.getOrderStatus());//单据状态
  105. lambdaQueryWrapper.like(Func.isNotEmpty(order.getSysNo()), Order::getSysNo, order.getSysNo());//系统编号
  106. lambdaQueryWrapper.eq(Func.isNotEmpty(order.getCreateUser()), Order::getCreateUser, order.getCreateUser());//制单人
  107. lambdaQueryWrapper.ge(Func.isNotEmpty(order.getCreateTimeStart()), Order::getCreateTime, order.getCreateTimeStart());//制单日期开始
  108. lambdaQueryWrapper.le(Func.isNotEmpty(order.getCreateTimeEnd()), Order::getCreateTime, order.getCreateTimeEnd());//制单日期结束
  109. lambdaQueryWrapper.ge(Func.isNotEmpty(order.getDateValidityStart()), Order::getDateValidity, order.getDateValidityStart());//有效日期开始
  110. lambdaQueryWrapper.le(Func.isNotEmpty(order.getDateValidityEnd()), Order::getDateValidity, order.getDateValidityEnd());//有效日期结束
  111. lambdaQueryWrapper.ge(Func.isNotEmpty(order.getOrderStartDate()),Order::getBusinesDate,order.getOrderStartDate());//订单日期开始
  112. lambdaQueryWrapper.le(Func.isNotEmpty(order.getOrderEndDate()),Order::getBusinesDate,order.getOrderEndDate());//订单日期结束
  113. lambdaQueryWrapper.like(Func.isNotEmpty(order.getPortOfLoad()),Order::getPortOfLoad,order.getPortOfLoad());//装货港
  114. lambdaQueryWrapper.like(Func.isNotEmpty(order.getPortOfDestination()),Order::getPortOfDestination,order.getPortOfDestination());//目的港
  115. lambdaQueryWrapper.like(Func.isNotEmpty(order.getPlannedDeliveryStart()),Order::getPlannedDeliveryDate,order.getPlannedDeliveryStart());//计划交货开始
  116. lambdaQueryWrapper.like(Func.isNotEmpty(order.getPlannedDeliveryEnd()),Order::getPlannedDeliveryDate,order.getPlannedDeliveryEnd());//计划交货结束
  117. IPage<Order> page = orderService.page(Condition.getPage(query), lambdaQueryWrapper);
  118. if (CollectionUtils.isNotEmpty(page.getRecords())) {
  119. page.getRecords().stream().forEach(item -> {
  120. if (item.getCorpId() != null) {
  121. R<CorpsDesc> corpMessage = corpsDescClient.getCorpMessage(item.getCorpId());//客户
  122. if (corpMessage.isSuccess() && corpMessage.getData() != null) {
  123. item.setCorpName(corpMessage.getData().getCname());
  124. }
  125. }
  126. if (item.getBelongToCorpId() != null) {
  127. R<CorpsDesc> corpMessage = corpsDescClient.getCorpMessage(item.getBelongToCorpId());//销售公司
  128. if (corpMessage.isSuccess() && corpMessage.getData() != null) {
  129. item.setBelongToCorpName(corpMessage.getData().getCname());
  130. }
  131. }
  132. R<User> user = userClient.userInfoById(item.getCreateUser());//制单人
  133. if (user.isSuccess() && user.getData() != null) {
  134. item.setCreateUserName(user.getData().getName());
  135. }
  136. //获取订单明细
  137. List<OrderItems> list = orderItemsService.list(new QueryWrapper<OrderItems>().eq("pid", item.getId()).eq("is_deleted", 0));
  138. if (CollectionUtils.isNotEmpty(list)){
  139. item.setOrderQuantity(list.stream().map(OrderItems::getOrderQuantity).reduce(BigDecimal.ZERO,BigDecimal::add));//数量合计
  140. item.setAmount(list.stream().map(OrderItems::getAmount).reduce(BigDecimal.ZERO,BigDecimal::add));//销售金额
  141. item.setPurchaseAmount(list.stream().map(OrderItems::getPurchaseAmount).reduce(BigDecimal.ZERO,BigDecimal::add));//采购金额
  142. item.setActualQuantity(list.stream().map(OrderItems::getActualQuantity).reduce(BigDecimal.ZERO,BigDecimal::add));//发货数量
  143. }
  144. });
  145. }
  146. return R.data(page);
  147. }
  148. /**
  149. * 新增 出口采购询价
  150. */
  151. @PostMapping("/save")
  152. @ApiOperationSupport(order = 4)
  153. @ApiOperation(value = "新增", notes = "传入order")
  154. public R<String> save(@Valid @RequestBody OrderSubmitDto submitDto) {
  155. submitDto.setBillType(OrderTypeEnum.PURCHASE_ENQUIRY.getType());
  156. submitDto.setTradeTypeEnum(OrderTypeEnum.EXPORT);
  157. return orderService.saveOrderMessage(submitDto);
  158. }
  159. /**
  160. * 修改 出口采购询价
  161. */
  162. @PostMapping("/update")
  163. @ApiOperationSupport(order = 5)
  164. @ApiOperation(value = "修改", notes = "传入order")
  165. public R<String> update(@Valid @RequestBody Order order) {
  166. if (order.getId() == null) {
  167. return R.fail(ERROR_MSG);
  168. }
  169. order.setIsDeleted(1);
  170. return R.status(orderService.updateById(order));
  171. }
  172. /**
  173. * 新增或修改 出口采购询价
  174. */
  175. @PostMapping("/submit")
  176. @ApiOperationSupport(order = 6)
  177. @ApiOperation(value = "新增或修改", notes = "传入order")
  178. public R<OrderSubmitDto> submit(@Valid @RequestBody OrderSubmitDto submitDto) {
  179. submitDto.setBillType(OrderTypeEnum.PURCHASE_ENQUIRY.getType());
  180. submitDto.setTradeTypeEnum(OrderTypeEnum.EXPORT);
  181. return orderService.savePurchase(submitDto);
  182. }
  183. /**
  184. * 采购订单表
  185. */
  186. @PostMapping("/removeByItem")
  187. @ApiOperationSupport(order = 5)
  188. @ApiOperation(value = "删除明细信息", notes = "传入order")
  189. public R<String> update(@Valid @RequestBody OrderItems order) {
  190. if (order.getId() == null) {
  191. return R.fail(500, "请选择要删除的数据");
  192. }
  193. order.setIsDeleted(1);
  194. return R.status(orderItemsService.updateById(order));
  195. }
  196. /**
  197. * 删除 出口采购询价
  198. */
  199. @PostMapping("/remove")
  200. @ApiOperationSupport(order = 8)
  201. @ApiOperation(value = "删除", notes = "传入ids")
  202. public R<String> remove(@Valid @RequestBody Order order) {
  203. if (order.getId() == null){
  204. return R.fail(500,"请选择要删除的数据");
  205. }
  206. return R.status(orderService.removeById(order));
  207. }
  208. @PostMapping("/remove-byItem")
  209. @ApiOperationSupport(order = 5)
  210. @ApiOperation(value = "删除明细信息", notes = "传入order")
  211. public R<String> removeByitem(@Valid @RequestBody OrderItems order) {
  212. if (order.getId() == null) {
  213. return R.fail(500, "请选择要删除的数据");
  214. }
  215. return R.status(orderItemsService.removeById(order));
  216. }
  217. /**
  218. * 删除费用信息
  219. */
  220. @PostMapping("/removeByFees")
  221. @ApiOperationSupport(order = 8)
  222. @ApiOperation(value = "删除费用信息", notes = "传入order")
  223. public R<String> update(@Valid @RequestBody OrderFees order) {
  224. if (order.getId() == null) {
  225. return R.fail(ERROR_MSG);
  226. }
  227. order.setIsDeleted(1);
  228. return R.status(orderFeesService.updateById(order));
  229. }
  230. /**
  231. * 删除订单文件信息
  232. *
  233. * @param order
  234. * @return
  235. */
  236. @PostMapping("/removeByFiles")
  237. @ApiOperationSupport(order = 9)
  238. @ApiOperation(value = "删除文件信息", notes = "传入order")
  239. public R<String> update(@Valid @RequestBody OrderFiles order) {
  240. if (order.getId() == null) {
  241. return R.fail(ERROR_MSG);
  242. }
  243. order.setIsDeleted(1);
  244. return R.status(orderFilesService.updateById(order));
  245. }
  246. /**
  247. * 报价单生成采购询价
  248. * @param order
  249. * @return
  250. */
  251. @PostMapping("/savePurchaseEnquiry")
  252. @ApiOperationSupport(order = 10)
  253. @ApiOperation(value = "报价单生成采购询价单", notes = "传入order的id")
  254. public R<OrderVO> savePurchaseEnquiry(@Valid @RequestBody Order order){
  255. order.setBillType(OrderTypeEnum.PURCHASE_ENQUIRY.getType());
  256. order.setTradeType(OrderTypeEnum.EXPORT.getType());
  257. return orderService.savePurchaseEnquiry(order);
  258. }
  259. /**
  260. * 提交采购询价
  261. * @param order
  262. * @return
  263. */
  264. @PostMapping("/submitMessage")
  265. @ApiOperationSupport(order = 10)
  266. @ApiOperation(value = "提交采购询价", notes = "传入order的id")
  267. public R<OrderVO> submitMessage(@Valid @RequestBody Order order){
  268. if (order.getId() == null){
  269. throw new RuntimeException("请选择确认的单据");
  270. }
  271. if (StringUtils.isNotBlank(order.getIfEnquiry()) && order.getIfEnquiry().equals("询价确认")) {
  272. throw new RuntimeException("请勿重复提交");
  273. }
  274. order.setBillType(OrderTypeEnum.PURCHASE_ENQUIRY.getType());
  275. order.setTradeType(OrderTypeEnum.EXPORT.getType());
  276. return orderService.submit(order);
  277. }
  278. }