package cn.iocoder.yudao.module.trade.controller.admin.domestic;
|
|
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.crm.api.receivable.CrmReceivableApi;
|
import cn.iocoder.yudao.module.crm.api.receivable.dto.CrmReceivableRespDTO;
|
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.domestic.vo.TradeDomesticOrderOutboundReqVO;
|
import cn.iocoder.yudao.module.trade.controller.admin.domestic.vo.TradeDomesticOrderPageReqVO;
|
import cn.iocoder.yudao.module.trade.controller.admin.domestic.vo.TradeDomesticOrderRespVO;
|
import cn.iocoder.yudao.module.trade.controller.admin.domestic.vo.TradeDomesticOrderSaveReqVO;
|
import cn.iocoder.yudao.module.trade.dal.dataobject.domestic.TradeDomesticOrderDO;
|
import cn.iocoder.yudao.module.trade.dal.dataobject.domestic.TradeDomesticOrderItemDO;
|
import cn.iocoder.yudao.module.trade.enums.TradeDomesticOrderStatusEnum;
|
import cn.iocoder.yudao.module.trade.service.domestic.TradeDomesticOrderService;
|
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/domestic-order")
|
@Validated
|
public class TradeDomesticOrderController {
|
|
@Resource
|
private TradeDomesticOrderService orderService;
|
|
@Resource
|
private CrmCustomerApi customerApi;
|
@Resource
|
private CrmReceivableApi receivableApi;
|
@Resource
|
private MdmItemApi mdmItemApi;
|
@Resource
|
private MdmUnitMeasureApi mdmUnitMeasureApi;
|
@Resource
|
private AdminUserApi adminUserApi;
|
@Resource
|
private StorageAttachmentApi storageAttachmentApi;
|
|
@PostMapping("/create")
|
@Operation(summary = "创建内贸订单")
|
@PreAuthorize("@ss.hasPermission('trade:domestic-order:create')")
|
public CommonResult<Long> createOrder(@Valid @RequestBody TradeDomesticOrderSaveReqVO createReqVO) {
|
return success(orderService.createOrder(createReqVO, getLoginUserId()));
|
}
|
|
@PutMapping("/update")
|
@Operation(summary = "更新内贸订单")
|
@PreAuthorize("@ss.hasPermission('trade:domestic-order:update')")
|
public CommonResult<Boolean> updateOrder(@Valid @RequestBody TradeDomesticOrderSaveReqVO updateReqVO) {
|
orderService.updateOrder(updateReqVO);
|
return success(true);
|
}
|
|
@DeleteMapping("/delete")
|
@Operation(summary = "删除内贸订单")
|
@Parameter(name = "id", description = "编号", required = true)
|
@PreAuthorize("@ss.hasPermission('trade:domestic-order:delete')")
|
public CommonResult<Boolean> deleteOrder(@RequestParam("id") Long id) {
|
orderService.deleteOrder(id);
|
return success(true);
|
}
|
|
@GetMapping("/get")
|
@Operation(summary = "获得内贸订单")
|
@Parameter(name = "id", description = "编号", required = true)
|
@PreAuthorize("@ss.hasPermission('trade:domestic-order:query')")
|
public CommonResult<TradeDomesticOrderRespVO> getOrder(@RequestParam("id") Long id) {
|
TradeDomesticOrderDO order = orderService.getOrder(id);
|
if (order == null) {
|
return success(null);
|
}
|
List<TradeDomesticOrderItemDO> items = orderService.getOrderItemListByOrderId(id);
|
return success(buildDetail(order, items));
|
}
|
|
@GetMapping("/page")
|
@Operation(summary = "获得内贸订单分页")
|
@PreAuthorize("@ss.hasPermission('trade:domestic-order:query')")
|
public CommonResult<PageResult<TradeDomesticOrderRespVO>> getOrderPage(@Valid TradeDomesticOrderPageReqVO pageReqVO) {
|
PageResult<TradeDomesticOrderDO> pageResult = orderService.getOrderPage(pageReqVO);
|
return success(buildPage(pageResult));
|
}
|
|
@GetMapping("/simple-list")
|
@Operation(summary = "获得内贸订单精简列表(供回款等下拉选择)")
|
public CommonResult<List<TradeDomesticOrderRespVO>> getOrderSimpleList() {
|
TradeDomesticOrderPageReqVO reqVO = new TradeDomesticOrderPageReqVO();
|
reqVO.setPageSize(PageParam.PAGE_SIZE_NONE);
|
return success(convertList(orderService.getOrderPage(reqVO).getList(),
|
o -> new TradeDomesticOrderRespVO().setId(o.getId()).setNo(o.getNo())
|
.setCustomerId(o.getCustomerId()).setTotalPrice(o.getTotalPrice())
|
.setStatus(o.getStatus())
|
.setStatusName(TradeDomesticOrderStatusEnum.getNameByStatus(o.getStatus()))));
|
}
|
|
@GetMapping("/receivable-list")
|
@Operation(summary = "获得内贸订单的回款列表")
|
@Parameter(name = "id", description = "编号", required = true)
|
@PreAuthorize("@ss.hasPermission('trade:domestic-order:query')")
|
public CommonResult<List<CrmReceivableRespDTO>> getOrderReceivableList(@RequestParam("id") Long id) {
|
return success(receivableApi.getReceivableListByDomesticOrderIds(Collections.singletonList(id)));
|
}
|
|
@GetMapping("/attachments")
|
@Operation(summary = "获得内贸订单附件列表")
|
@PreAuthorize("@ss.hasPermission('trade:domestic-order:query')")
|
public CommonResult<List<StorageBlobRespDTO>> getOrderAttachments(@RequestParam("id") Long id) {
|
return success(storageAttachmentApi.listAttachments("trade_domestic_order", id));
|
}
|
|
@PostMapping("/upload-document")
|
@Operation(summary = "上传内贸订单单据(附件)")
|
@Parameter(name = "id", description = "编号", required = true)
|
@PreAuthorize("@ss.hasPermission('trade:domestic-order:update')")
|
public CommonResult<Boolean> uploadDocuments(@RequestParam("id") Long id,
|
@RequestBody List<Long> blobIds) {
|
orderService.uploadDocuments(id, blobIds);
|
return success(true);
|
}
|
|
@PutMapping("/submit")
|
@Operation(summary = "提交内贸订单审批")
|
@PreAuthorize("@ss.hasPermission('trade:domestic-order:submit')")
|
public CommonResult<Boolean> 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:domestic-order:query')")
|
public CommonResult<List<Map<String, Object>>> getApproveProcessList() {
|
return success(orderService.getApproveProcessDefinitionList());
|
}
|
|
@PutMapping("/complete")
|
@Operation(summary = "完结内贸订单")
|
@Parameter(name = "id", description = "编号", required = true)
|
@PreAuthorize("@ss.hasPermission('trade:domestic-order:complete')")
|
public CommonResult<Boolean> completeOrder(@RequestParam("id") Long id) {
|
orderService.completeOrder(id);
|
return success(true);
|
}
|
|
@PutMapping("/cancel")
|
@Operation(summary = "作废内贸订单")
|
@Parameter(name = "id", description = "编号", required = true)
|
@PreAuthorize("@ss.hasPermission('trade:domestic-order:cancel')")
|
public CommonResult<Boolean> cancelOrder(@RequestParam("id") Long id) {
|
orderService.cancelOrder(id);
|
return success(true);
|
}
|
|
@PostMapping("/archive")
|
@Operation(summary = "归档内贸订单(预留:统一电子档案库)")
|
@PreAuthorize("@ss.hasPermission('trade:domestic-order:update')")
|
public CommonResult<Boolean> archiveOrder(@RequestParam("id") Long id) {
|
orderService.archiveOrder(id);
|
return success(true);
|
}
|
|
@PostMapping("/sync-k3")
|
@Operation(summary = "同步内贸订单到金蝶 K3(预留)")
|
@PreAuthorize("@ss.hasPermission('trade:domestic-order:update')")
|
public CommonResult<Boolean> syncToK3(@RequestParam("id") Long id) {
|
orderService.syncToK3(id);
|
return success(true);
|
}
|
|
@PostMapping("/outbound")
|
@Operation(summary = "内贸订单出库(MES 成品出库,扣库存)")
|
@PreAuthorize("@ss.hasPermission('trade:domestic-order:outbound')")
|
public CommonResult<Boolean> outbound(@Valid @RequestBody TradeDomesticOrderOutboundReqVO outboundReqVO) {
|
orderService.outbound(outboundReqVO, getLoginUserId());
|
return success(true);
|
}
|
|
@GetMapping("/available-stock")
|
@Operation(summary = "按物料获得可用库存记录(供出库选择)")
|
@Parameter(name = "itemId", description = "物料编号", required = true)
|
@PreAuthorize("@ss.hasPermission('trade:domestic-order:query')")
|
public CommonResult<List<MesWmMaterialStockRecordDTO>> getAvailableStock(@RequestParam("itemId") Long itemId) {
|
return success(orderService.getAvailableStock(itemId));
|
}
|
|
@GetMapping("/export-excel")
|
@Operation(summary = "导出内贸订单 Excel")
|
@PreAuthorize("@ss.hasPermission('trade:domestic-order:export')")
|
@ApiAccessLog(operateType = EXPORT)
|
public void exportOrderExcel(@Valid TradeDomesticOrderPageReqVO pageReqVO,
|
HttpServletResponse response) throws IOException {
|
pageReqVO.setPageSize(PageParam.PAGE_SIZE_NONE);
|
List<TradeDomesticOrderRespVO> list = buildPage(orderService.getOrderPage(pageReqVO)).getList();
|
ExcelUtils.write(response, "内贸订单.xls", "数据", TradeDomesticOrderRespVO.class, list);
|
}
|
|
// ==================== 构建响应 ====================
|
|
private TradeDomesticOrderRespVO buildDetail(TradeDomesticOrderDO order, List<TradeDomesticOrderItemDO> items) {
|
TradeDomesticOrderRespVO vo = BeanUtils.toBean(order, TradeDomesticOrderRespVO.class);
|
vo.setStatusName(TradeDomesticOrderStatusEnum.getNameByStatus(order.getStatus()));
|
// 客户
|
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));
|
// 回款 / 未结余额
|
BigDecimal received = buildReceivedMap(Collections.singleton(order.getId()))
|
.getOrDefault(order.getId(), BigDecimal.ZERO);
|
vo.setReceivedPrice(received);
|
vo.setUnpaidPrice(calcUnpaid(vo.getTotalPrice(), received));
|
return vo;
|
}
|
|
private PageResult<TradeDomesticOrderRespVO> buildPage(PageResult<TradeDomesticOrderDO> pageResult) {
|
if (CollUtil.isEmpty(pageResult.getList())) {
|
return PageResult.empty(pageResult.getTotal());
|
}
|
Set<Long> orderIds = convertSet(pageResult.getList(), TradeDomesticOrderDO::getId);
|
// 明细
|
List<TradeDomesticOrderItemDO> items = orderService.getOrderItemListByOrderIds(orderIds);
|
Map<Long, List<TradeDomesticOrderItemDO>> itemMap = convertMultiMap(items, TradeDomesticOrderItemDO::getOrderId);
|
Map<Long, MdmItemRespDTO> mdmItemMap = mdmItemApi.getItemMap(convertSet(items, TradeDomesticOrderItemDO::getItemId));
|
Map<Long, MdmUnitMeasureRespDTO> unitMap = buildUnitMap(items, mdmItemMap);
|
// 客户 / 用户
|
Map<Long, CrmCustomerRespDTO> customerMap = customerApi.getCustomerMap(
|
convertSet(pageResult.getList(), TradeDomesticOrderDO::getCustomerId));
|
Set<Long> userIds = new HashSet<>(convertSet(pageResult.getList(), TradeDomesticOrderDO::getSaleUserId));
|
Map<Long, AdminUserRespDTO> userMap = adminUserApi.getUserMap(userIds);
|
// 回款
|
Map<Long, BigDecimal> receivedMap = buildReceivedMap(orderIds);
|
return BeanUtils.toBean(pageResult, TradeDomesticOrderRespVO.class, vo -> {
|
vo.setStatusName(TradeDomesticOrderStatusEnum.getNameByStatus(vo.getStatus()));
|
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.setReceivedPrice(received);
|
vo.setUnpaidPrice(calcUnpaid(vo.getTotalPrice(), received));
|
});
|
}
|
|
/** 按订单聚合已回款金额 */
|
private Map<Long, BigDecimal> buildReceivedMap(Collection<Long> orderIds) {
|
Map<Long, BigDecimal> result = new HashMap<>();
|
List<CrmReceivableRespDTO> receivables = receivableApi.getReceivableListByDomesticOrderIds(orderIds);
|
for (CrmReceivableRespDTO r : receivables) {
|
if (r.getDomesticOrderId() == null) {
|
continue;
|
}
|
BigDecimal price = r.getPrice() == null ? BigDecimal.ZERO : r.getPrice();
|
result.merge(r.getDomesticOrderId(), price, BigDecimal::add);
|
}
|
return result;
|
}
|
|
private BigDecimal calcUnpaid(BigDecimal totalPrice, BigDecimal received) {
|
BigDecimal total = totalPrice == null ? BigDecimal.ZERO : totalPrice;
|
BigDecimal unpaid = total.subtract(received);
|
// 未结余额不为负:多收/预付时按 0 展示(避免出现负数)
|
return unpaid.compareTo(BigDecimal.ZERO) < 0 ? BigDecimal.ZERO : unpaid;
|
}
|
|
private List<TradeDomesticOrderRespVO.Item> convertItems(List<TradeDomesticOrderItemDO> items) {
|
if (CollUtil.isEmpty(items)) {
|
return Collections.emptyList();
|
}
|
Map<Long, MdmItemRespDTO> mdmItemMap = mdmItemApi.getItemMap(convertSet(items, TradeDomesticOrderItemDO::getItemId));
|
return convertItems(items, mdmItemMap, buildUnitMap(items, mdmItemMap));
|
}
|
|
private Map<Long, MdmUnitMeasureRespDTO> buildUnitMap(List<TradeDomesticOrderItemDO> items, Map<Long, MdmItemRespDTO> mdmItemMap) {
|
Set<Long> unitIds = new HashSet<>(convertSet(items, TradeDomesticOrderItemDO::getItemUnitId));
|
mdmItemMap.values().forEach(i -> {
|
if (i.getUnitMeasureId2() != null) {
|
unitIds.add(i.getUnitMeasureId2());
|
}
|
});
|
return convertMap(mdmUnitMeasureApi.getUnitMeasureList(unitIds).getCheckedData(), MdmUnitMeasureRespDTO::getId);
|
}
|
|
private List<TradeDomesticOrderRespVO.Item> convertItems(List<TradeDomesticOrderItemDO> items,
|
Map<Long, MdmItemRespDTO> mdmItemMap,
|
Map<Long, MdmUnitMeasureRespDTO> unitMap) {
|
if (CollUtil.isEmpty(items)) {
|
return Collections.emptyList();
|
}
|
return BeanUtils.toBean(items, TradeDomesticOrderRespVO.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()));
|
});
|
}
|
|
}
|