package cn.iocoder.yudao.module.trade.controller.admin.foreign; import cn.hutool.core.collection.CollUtil; import cn.iocoder.yudao.framework.apilog.core.annotation.ApiAccessLog; import cn.iocoder.yudao.framework.common.pojo.CommonResult; import cn.iocoder.yudao.framework.common.pojo.PageParam; import cn.iocoder.yudao.framework.common.pojo.PageResult; import cn.iocoder.yudao.framework.common.util.collection.MapUtils; import cn.iocoder.yudao.framework.common.util.object.BeanUtils; import cn.iocoder.yudao.framework.excel.core.util.ExcelUtils; import cn.iocoder.yudao.module.crm.api.customer.CrmCustomerApi; import cn.iocoder.yudao.module.crm.api.customer.dto.CrmCustomerRespDTO; import cn.iocoder.yudao.module.mdm.api.item.MdmItemApi; import cn.iocoder.yudao.module.mdm.api.item.dto.MdmItemRespDTO; import cn.iocoder.yudao.module.mdm.api.unit.MdmUnitMeasureApi; import cn.iocoder.yudao.module.mdm.api.unit.dto.MdmUnitMeasureRespDTO; import cn.iocoder.yudao.module.system.api.storage.StorageAttachmentApi; import cn.iocoder.yudao.module.system.api.storage.dto.StorageBlobRespDTO; import cn.iocoder.yudao.module.system.api.user.AdminUserApi; import cn.iocoder.yudao.module.system.api.user.dto.AdminUserRespDTO; import cn.iocoder.yudao.module.mes.api.wms.dto.MesWmMaterialStockRecordDTO; import cn.iocoder.yudao.module.trade.controller.admin.foreign.vo.TradeForeignOrderOutboundReqVO; import cn.iocoder.yudao.module.trade.controller.admin.foreign.vo.TradeForeignOrderPageReqVO; import cn.iocoder.yudao.module.trade.controller.admin.foreign.vo.TradeForeignOrderRespVO; import cn.iocoder.yudao.module.trade.controller.admin.foreign.vo.TradeForeignOrderSaveReqVO; import cn.iocoder.yudao.module.trade.controller.admin.foreign.vo.TradeForeignReceiveSaveReqVO; import cn.iocoder.yudao.module.trade.dal.dataobject.foreign.TradeForeignOrderDO; import cn.iocoder.yudao.module.trade.dal.dataobject.foreign.TradeForeignOrderItemDO; import cn.iocoder.yudao.module.trade.dal.dataobject.foreign.TradeForeignReceiveDO; import cn.iocoder.yudao.module.trade.enums.foreign.TradeForeignDeliveryModeEnum; import cn.iocoder.yudao.module.trade.enums.foreign.TradeForeignOrderStatusEnum; import cn.iocoder.yudao.module.trade.service.foreign.TradeForeignDocumentService; import cn.iocoder.yudao.module.trade.service.foreign.TradeForeignOrderService; import io.swagger.v3.oas.annotations.Operation; import io.swagger.v3.oas.annotations.Parameter; import io.swagger.v3.oas.annotations.tags.Tag; import jakarta.annotation.Resource; import jakarta.servlet.http.HttpServletResponse; import jakarta.validation.Valid; import org.springframework.security.access.prepost.PreAuthorize; import org.springframework.validation.annotation.Validated; import org.springframework.web.bind.annotation.*; import java.io.IOException; import java.math.BigDecimal; import java.util.*; import static cn.iocoder.yudao.framework.apilog.core.enums.OperateTypeEnum.EXPORT; import static cn.iocoder.yudao.framework.common.pojo.CommonResult.success; import static cn.iocoder.yudao.framework.common.util.collection.CollectionUtils.*; import static cn.iocoder.yudao.framework.security.core.util.SecurityFrameworkUtils.getLoginUserId; @Tag(name = "管理后台 - 外贸订单") @RestController @RequestMapping("/trade/foreign-order") @Validated public class TradeForeignOrderController { @Resource private TradeForeignOrderService orderService; @Resource private CrmCustomerApi customerApi; @Resource private MdmItemApi mdmItemApi; @Resource private MdmUnitMeasureApi mdmUnitMeasureApi; @Resource private AdminUserApi adminUserApi; @Resource private StorageAttachmentApi storageAttachmentApi; @Resource private TradeForeignDocumentService documentService; @PostMapping("/create") @Operation(summary = "创建外贸订单") @PreAuthorize("@ss.hasPermission('trade:foreign-order:create')") public CommonResult createOrder(@Valid @RequestBody TradeForeignOrderSaveReqVO reqVO) { return success(orderService.createOrder(reqVO, getLoginUserId())); } @PutMapping("/update") @Operation(summary = "更新外贸订单") @PreAuthorize("@ss.hasPermission('trade:foreign-order:update')") public CommonResult updateOrder(@Valid @RequestBody TradeForeignOrderSaveReqVO reqVO) { orderService.updateOrder(reqVO); return success(true); } @DeleteMapping("/delete") @Operation(summary = "删除外贸订单") @PreAuthorize("@ss.hasPermission('trade:foreign-order:delete')") public CommonResult deleteOrder(@RequestParam("id") Long id) { orderService.deleteOrder(id); return success(true); } @GetMapping("/get") @Operation(summary = "获得外贸订单") @PreAuthorize("@ss.hasPermission('trade:foreign-order:query')") public CommonResult getOrder(@RequestParam("id") Long id) { TradeForeignOrderDO order = orderService.getOrder(id); if (order == null) { return success(null); } return success(buildDetail(order, orderService.getOrderItemListByOrderId(id))); } @GetMapping("/page") @Operation(summary = "获得外贸订单分页") @PreAuthorize("@ss.hasPermission('trade:foreign-order:query')") public CommonResult> getOrderPage(@Valid TradeForeignOrderPageReqVO pageReqVO) { return success(buildPage(orderService.getOrderPage(pageReqVO))); } @PutMapping("/submit") @Operation(summary = "提交外贸订单审批") @PreAuthorize("@ss.hasPermission('trade:foreign-order:submit')") public CommonResult submitOrder(@RequestParam("id") Long id, @RequestParam("processDefinitionKey") String processDefinitionKey) { orderService.submitOrder(id, processDefinitionKey, getLoginUserId()); return success(true); } @GetMapping("/approve-process-list") @Operation(summary = "获得外贸订单可发起的审批流程列表") @PreAuthorize("@ss.hasPermission('trade:foreign-order:query')") public CommonResult>> getApproveProcessList() { return success(orderService.getApproveProcessDefinitionList()); } @PutMapping("/complete") @Operation(summary = "完结外贸订单") @PreAuthorize("@ss.hasPermission('trade:foreign-order:complete')") public CommonResult completeOrder(@RequestParam("id") Long id) { orderService.completeOrder(id); return success(true); } @PostMapping("/upload-document") @Operation(summary = "上传外贸订单单据(附件)") @PreAuthorize("@ss.hasPermission('trade:foreign-order:update')") public CommonResult uploadDocuments(@RequestParam("id") Long id, @RequestBody List blobIds) { orderService.uploadDocuments(id, blobIds); return success(true); } @GetMapping("/attachments") @Operation(summary = "获得外贸订单附件列表") @PreAuthorize("@ss.hasPermission('trade:foreign-order:query')") public CommonResult> getOrderAttachments(@RequestParam("id") Long id) { return success(storageAttachmentApi.listAttachments("trade_foreign_order", id)); } @PostMapping("/receive") @Operation(summary = "外贸订单收汇登记") @PreAuthorize("@ss.hasPermission('trade:foreign-order:receive')") public CommonResult createReceive(@Valid @RequestBody TradeForeignReceiveSaveReqVO reqVO) { return success(orderService.createReceive(reqVO)); } @GetMapping("/receive-list") @Operation(summary = "获得外贸订单收汇列表") @PreAuthorize("@ss.hasPermission('trade:foreign-order:query')") public CommonResult> getReceiveList(@RequestParam("id") Long id) { return success(orderService.getReceiveListByOrderId(id)); } @PostMapping("/archive") @Operation(summary = "归档外贸订单(预留:统一电子档案库)") @PreAuthorize("@ss.hasPermission('trade:foreign-order:update')") public CommonResult archiveOrder(@RequestParam("id") Long id) { orderService.archiveOrder(id); return success(true); } @PostMapping("/sync-k3") @Operation(summary = "同步外贸订单到金蝶 K3(预留)") @PreAuthorize("@ss.hasPermission('trade:foreign-order:update')") public CommonResult syncToK3(@RequestParam("id") Long id) { orderService.syncToK3(id); return success(true); } @PostMapping("/outbound") @Operation(summary = "外贸订单出库(厂区直发绑定厂区出库单,MES 成品出库扣库存)") @PreAuthorize("@ss.hasPermission('trade:foreign-order:outbound')") public CommonResult outbound(@Valid @RequestBody TradeForeignOrderOutboundReqVO reqVO) { orderService.outbound(reqVO, getLoginUserId()); return success(true); } @GetMapping("/available-stock") @Operation(summary = "按物料获得可用库存记录(供出库选择)") @Parameter(name = "itemId", description = "物料编号", required = true) @PreAuthorize("@ss.hasPermission('trade:foreign-order:query')") public CommonResult> getAvailableStock(@RequestParam("itemId") Long itemId) { return success(orderService.getAvailableStock(itemId)); } @GetMapping("/export-excel") @Operation(summary = "导出外贸订单 Excel") @PreAuthorize("@ss.hasPermission('trade:foreign-order:export')") @ApiAccessLog(operateType = EXPORT) public void exportOrderExcel(@Valid TradeForeignOrderPageReqVO pageReqVO, HttpServletResponse response) throws IOException { pageReqVO.setPageSize(PageParam.PAGE_SIZE_NONE); List list = buildPage(orderService.getOrderPage(pageReqVO)).getList(); ExcelUtils.write(response, "外贸订单.xls", "数据", TradeForeignOrderRespVO.class, list); } // ==================== 构建响应 ==================== private TradeForeignOrderRespVO buildDetail(TradeForeignOrderDO order, List items) { TradeForeignOrderRespVO vo = BeanUtils.toBean(order, TradeForeignOrderRespVO.class); vo.setStatusName(TradeForeignOrderStatusEnum.getNameByStatus(order.getStatus())); vo.setDeliveryModeName(TradeForeignDeliveryModeEnum.getNameByMode(order.getDeliveryMode())); if (order.getCustomerId() != null) { CrmCustomerRespDTO customer = customerApi.getCustomer(order.getCustomerId()); if (customer != null) { vo.setCustomerName(customer.getName()); } } if (order.getSaleUserId() != null) { AdminUserRespDTO user = adminUserApi.getUser(order.getSaleUserId()); if (user != null) { vo.setSaleUserName(user.getNickname()); } } if (order.getCreator() != null) { try { AdminUserRespDTO user = adminUserApi.getUser(Long.valueOf(order.getCreator())); if (user != null) { vo.setCreatorName(user.getNickname()); } } catch (NumberFormatException ignored) { } } vo.setItems(convertItems(items)); fillForeignReceive(vo, Collections.singletonList(order.getId())); fillMissingDocs(vo); return vo; } private PageResult buildPage(PageResult pageResult) { if (CollUtil.isEmpty(pageResult.getList())) { return PageResult.empty(pageResult.getTotal()); } Set orderIds = convertSet(pageResult.getList(), TradeForeignOrderDO::getId); List items = orderService.getOrderItemListByOrderIds(orderIds); Map> itemMap = convertMultiMap(items, TradeForeignOrderItemDO::getOrderId); Map mdmItemMap = mdmItemApi.getItemMap(convertSet(items, TradeForeignOrderItemDO::getItemId)); Map unitMap = buildUnitMap(items, mdmItemMap); Map customerMap = customerApi.getCustomerMap( convertSet(pageResult.getList(), TradeForeignOrderDO::getCustomerId)); Set userIds = new HashSet<>(convertSet(pageResult.getList(), TradeForeignOrderDO::getSaleUserId)); Map userMap = adminUserApi.getUserMap(userIds); Map receivedMap = buildReceivedMap(orderIds); Map> missingMap = documentService.getMissingRequiredDocNamesByOrderIds(orderIds); return BeanUtils.toBean(pageResult, TradeForeignOrderRespVO.class, vo -> { vo.setStatusName(TradeForeignOrderStatusEnum.getNameByStatus(vo.getStatus())); vo.setDeliveryModeName(TradeForeignDeliveryModeEnum.getNameByMode(vo.getDeliveryMode())); MapUtils.findAndThen(customerMap, vo.getCustomerId(), c -> vo.setCustomerName(c.getName())); MapUtils.findAndThen(userMap, vo.getSaleUserId(), u -> vo.setSaleUserName(u.getNickname())); vo.setItems(convertItems(itemMap.get(vo.getId()), mdmItemMap, unitMap)); BigDecimal received = receivedMap.getOrDefault(vo.getId(), BigDecimal.ZERO); vo.setReceivedForeignAmount(received); vo.setUnreceivedForeignAmount(clampUnreceived(vo.getTotalForeignPrice(), received)); java.util.List missingDocs = missingMap.getOrDefault(vo.getId(), Collections.emptyList()); vo.setMissingDocs(missingDocs); vo.setMissingDocCount(missingDocs.size()); }); } private void fillForeignReceive(TradeForeignOrderRespVO vo, Collection orderIds) { BigDecimal received = buildReceivedMap(orderIds).getOrDefault(vo.getId(), BigDecimal.ZERO); vo.setReceivedForeignAmount(received); vo.setUnreceivedForeignAmount(clampUnreceived(vo.getTotalForeignPrice(), received)); } /** 填充缺失的必填单据信息(按出货模式,全部必填口径) */ private void fillMissingDocs(TradeForeignOrderRespVO vo) { List missingDocs = documentService.getMissingRequiredDocNames(vo.getId(), false); vo.setMissingDocs(missingDocs); vo.setMissingDocCount(missingDocs.size()); } private Map buildReceivedMap(Collection orderIds) { Map result = new HashMap<>(); for (TradeForeignReceiveDO r : orderIds.isEmpty() ? Collections.emptyList() : nullSafeReceives(orderIds)) { if (r.getOrderId() == null) { continue; } result.merge(r.getOrderId(), r.getForeignAmount() == null ? BigDecimal.ZERO : r.getForeignAmount(), BigDecimal::add); } return result; } private List nullSafeReceives(Collection orderIds) { List list = new ArrayList<>(); for (Long id : orderIds) { list.addAll(orderService.getReceiveListByOrderId(id)); } return list; } private BigDecimal clampUnreceived(BigDecimal total, BigDecimal received) { BigDecimal t = total == null ? BigDecimal.ZERO : total; BigDecimal u = t.subtract(received); return u.compareTo(BigDecimal.ZERO) < 0 ? BigDecimal.ZERO : u; } private List convertItems(List items) { if (CollUtil.isEmpty(items)) { return Collections.emptyList(); } Map mdmItemMap = mdmItemApi.getItemMap(convertSet(items, TradeForeignOrderItemDO::getItemId)); return convertItems(items, mdmItemMap, buildUnitMap(items, mdmItemMap)); } private Map buildUnitMap(List items, Map mdmItemMap) { Set unitIds = new HashSet<>(convertSet(items, TradeForeignOrderItemDO::getItemUnitId)); mdmItemMap.values().forEach(i -> { if (i.getUnitMeasureId2() != null) { unitIds.add(i.getUnitMeasureId2()); } }); return convertMap(mdmUnitMeasureApi.getUnitMeasureList(unitIds).getCheckedData(), MdmUnitMeasureRespDTO::getId); } private List convertItems(List items, Map mdmItemMap, Map unitMap) { if (CollUtil.isEmpty(items)) { return Collections.emptyList(); } return BeanUtils.toBean(items, TradeForeignOrderRespVO.Item.class, item -> { MdmItemRespDTO mdmItem = mdmItemMap.get(item.getItemId()); if (mdmItem != null) { item.setItemCode(mdmItem.getCode()); item.setItemName(mdmItem.getName()); item.setItemSpecification(mdmItem.getSpecification()); } MapUtils.findAndThen(unitMap, item.getItemUnitId(), unit -> item.setItemUnitName(unit.getName())); }); } }