ShippingEnquiry.java 13 KB

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