package cn.iocoder.yudao.module.erp.controller.admin.sale;
|
|
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.erp.controller.admin.sale.vo.order.ErpSaleOrderItemRespVO;
|
import cn.iocoder.yudao.module.erp.controller.admin.sale.vo.order.ErpSaleOrderPageReqVO;
|
import cn.iocoder.yudao.module.erp.controller.admin.sale.vo.order.ErpSaleOrderRespVO;
|
import cn.iocoder.yudao.module.erp.controller.admin.sale.vo.order.ErpSaleOrderSaveReqVO;
|
import cn.iocoder.yudao.module.erp.dal.dataobject.sale.ErpSaleOrderDO;
|
import cn.iocoder.yudao.module.erp.dal.dataobject.sale.ErpSaleOrderItemDO;
|
import cn.iocoder.yudao.module.erp.service.sale.ErpSaleOrderService;
|
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.mes.api.wms.MesWmStockApi;
|
import cn.iocoder.yudao.module.system.api.storage.StorageAttachmentApi;
|
import cn.iocoder.yudao.module.system.api.user.AdminUserApi;
|
import cn.iocoder.yudao.module.system.api.user.dto.AdminUserRespDTO;
|
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.List;
|
import java.util.Map;
|
|
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.convertMultiMap;
|
import static cn.iocoder.yudao.framework.common.util.collection.CollectionUtils.convertSet;
|
|
@Tag(name = "管理后台 - ERP 销售订单")
|
@RestController
|
@RequestMapping("/erp/sale-order")
|
@Validated
|
public class ErpSaleOrderController {
|
|
@Resource
|
private ErpSaleOrderService saleOrderService;
|
@Resource
|
private CrmCustomerApi customerApi;
|
|
@Resource
|
private MdmItemApi mdmItemApi;
|
@Resource
|
private AdminUserApi adminUserApi;
|
@Resource
|
private StorageAttachmentApi storageAttachmentApi;
|
@Resource
|
private MdmUnitMeasureApi mdmUnitMeasureApi;
|
@Resource
|
private MesWmStockApi mesWmStockApi;
|
|
@PostMapping("/create")
|
@Operation(summary = "创建销售订单")
|
@PreAuthorize("@ss.hasPermission('erp:sale-order:create')")
|
public CommonResult<Long> createSaleOrder(@Valid @RequestBody ErpSaleOrderSaveReqVO createReqVO) {
|
return success(saleOrderService.createSaleOrder(createReqVO));
|
}
|
|
@PutMapping("/update")
|
@Operation(summary = "更新销售订单")
|
@PreAuthorize("@ss.hasPermission('erp:sale-order:update')")
|
public CommonResult<Boolean> updateSaleOrder(@Valid @RequestBody ErpSaleOrderSaveReqVO updateReqVO) {
|
saleOrderService.updateSaleOrder(updateReqVO);
|
return success(true);
|
}
|
|
@PutMapping("/update-status")
|
@Operation(summary = "更新销售订单的状态")
|
@PreAuthorize("@ss.hasPermission('erp:sale-order:update-status')")
|
public CommonResult<Boolean> updateSaleOrderStatus(@RequestParam("id") Long id,
|
@RequestParam("status") Integer status) {
|
saleOrderService.updateSaleOrderStatus(id, status);
|
return success(true);
|
}
|
|
@PutMapping("/cancel")
|
@Operation(summary = "作废销售订单")
|
@Parameter(name = "id", description = "编号", required = true)
|
@PreAuthorize("@ss.hasPermission('erp:sale-order:cancel')")
|
public CommonResult<Boolean> cancelSaleOrder(@RequestParam("id") Long id) {
|
saleOrderService.cancelSaleOrder(id);
|
return success(true);
|
}
|
|
@PutMapping("/enable")
|
@Operation(summary = "重新启用销售订单")
|
@Parameter(name = "id", description = "编号", required = true)
|
@PreAuthorize("@ss.hasPermission('erp:sale-order:enable')")
|
public CommonResult<Boolean> enableSaleOrder(@RequestParam("id") Long id) {
|
saleOrderService.enableSaleOrder(id);
|
return success(true);
|
}
|
|
@DeleteMapping("/delete")
|
@Operation(summary = "删除销售订单")
|
@Parameter(name = "ids", description = "编号数组", required = true)
|
@PreAuthorize("@ss.hasPermission('erp:sale-order:delete')")
|
public CommonResult<Boolean> deleteSaleOrder(@RequestParam("ids") List<Long> ids) {
|
saleOrderService.deleteSaleOrder(ids);
|
return success(true);
|
}
|
|
@GetMapping("/item/list-by-order-id")
|
@Operation(summary = "查询销售订单的物料明细列表（用于发货通知单创建）")
|
@Parameter(name = "orderId", description = "销售订单编号", required = true, example = "1")
|
@PreAuthorize("@ss.hasPermission('erp:sale-order:query')")
|
public CommonResult<List<ErpSaleOrderItemRespVO>> getSaleOrderItemListByOrderId(@RequestParam("orderId") Long orderId) {
|
List<ErpSaleOrderItemDO> itemList = saleOrderService.getSaleOrderItemListByOrderId(orderId);
|
Map<Long, MdmItemRespDTO> itemMap = mdmItemApi.getItemMap(
|
convertSet(itemList, ErpSaleOrderItemDO::getProductId));
|
return success(BeanUtils.toBean(itemList, ErpSaleOrderItemRespVO.class, vo -> {
|
MapUtils.findAndThen(itemMap, vo.getProductId(), item ->
|
vo.setProductName(item.getName()).setProductBarCode(item.getBarCode()));
|
}));
|
}
|
|
@GetMapping("/get")
|
@Operation(summary = "获得销售订单")
|
@Parameter(name = "id", description = "编号", required = true, example = "1024")
|
@PreAuthorize("@ss.hasPermission('erp:sale-order:query')")
|
public CommonResult<ErpSaleOrderRespVO> getSaleOrder(@RequestParam("id") Long id) {
|
ErpSaleOrderDO saleOrder = saleOrderService.getSaleOrder(id);
|
if (saleOrder == null) {
|
return success(null);
|
}
|
// 1. 查询订单项
|
List<ErpSaleOrderItemDO> saleOrderItemList = saleOrderService.getSaleOrderItemListByOrderId(id);
|
// 2. 批量查询关联数据
|
Map<Long, MdmItemRespDTO> itemMap = mdmItemApi.getItemMap(
|
convertSet(saleOrderItemList, ErpSaleOrderItemDO::getProductId));
|
Map<Long, MdmUnitMeasureRespDTO> unitMeasureMap = mdmUnitMeasureApi.getUnitMeasureMap(
|
convertSet(saleOrderItemList, ErpSaleOrderItemDO::getProductUnitId));
|
// 3. 转换订单项
|
List<ErpSaleOrderRespVO.Item> itemVOList = BeanUtils.toBean(saleOrderItemList, ErpSaleOrderRespVO.Item.class, item -> {
|
item.setStockCount(mesWmStockApi.getStockQuantity(item.getProductId()));
|
MapUtils.findAndThen(itemMap, item.getProductId(), mdmItem ->
|
item.setProductName(mdmItem.getName()).setProductBarCode(mdmItem.getBarCode())
|
.setProductSpecification(mdmItem.getSpecification()));
|
MapUtils.findAndThen(unitMeasureMap, item.getProductUnitId(), unit ->
|
item.setProductUnitName(unit.getName()));
|
});
|
// 4. 组装响应
|
ErpSaleOrderRespVO saleOrderVO = BeanUtils.toBean(saleOrder, ErpSaleOrderRespVO.class);
|
saleOrderVO.setItems(itemVOList);
|
saleOrderVO.setAttachmentList(storageAttachmentApi.listAttachments("erp_sale_order", id));
|
return success(saleOrderVO);
|
}
|
|
@GetMapping("/page")
|
@Operation(summary = "获得销售订单分页")
|
@PreAuthorize("@ss.hasPermission('erp:sale-order:query')")
|
public CommonResult<PageResult<ErpSaleOrderRespVO>> getSaleOrderPage(@Valid ErpSaleOrderPageReqVO pageReqVO) {
|
PageResult<ErpSaleOrderDO> pageResult = saleOrderService.getSaleOrderPage(pageReqVO);
|
return success(buildSaleOrderVOPageResult(pageResult));
|
}
|
|
@GetMapping("/export-excel")
|
@Operation(summary = "导出销售订单 Excel")
|
@PreAuthorize("@ss.hasPermission('erp:sale-order:export')")
|
@ApiAccessLog(operateType = EXPORT)
|
public void exportSaleOrderExcel(@Valid ErpSaleOrderPageReqVO pageReqVO,
|
HttpServletResponse response) throws IOException {
|
pageReqVO.setPageSize(PageParam.PAGE_SIZE_NONE);
|
List<ErpSaleOrderRespVO> list = buildSaleOrderVOPageResult(saleOrderService.getSaleOrderPage(pageReqVO)).getList();
|
// 导出 Excel
|
ExcelUtils.write(response, "销售订单.xls", "数据", ErpSaleOrderRespVO.class, list);
|
}
|
|
private PageResult<ErpSaleOrderRespVO> buildSaleOrderVOPageResult(PageResult<ErpSaleOrderDO> pageResult) {
|
if (CollUtil.isEmpty(pageResult.getList())) {
|
return PageResult.empty(pageResult.getTotal());
|
}
|
// 1.1 订单项
|
List<ErpSaleOrderItemDO> saleOrderItemList = saleOrderService.getSaleOrderItemListByOrderIds(
|
convertSet(pageResult.getList(), ErpSaleOrderDO::getId));
|
Map<Long, List<ErpSaleOrderItemDO>> saleOrderItemMap = convertMultiMap(saleOrderItemList, ErpSaleOrderItemDO::getOrderId);
|
// 1.2 物料信息
|
Map<Long, MdmItemRespDTO> itemMap = mdmItemApi.getItemMap(
|
convertSet(saleOrderItemList, ErpSaleOrderItemDO::getProductId));
|
// 1.3 客户信息（使用 CRM 客户 API）
|
Map<Long, CrmCustomerRespDTO> customerMap = customerApi.getCustomerMap(
|
convertSet(pageResult.getList(), ErpSaleOrderDO::getCustomerId));
|
// 1.4 管理员信息
|
Map<Long, AdminUserRespDTO> userMap = adminUserApi.getUserMap(
|
convertSet(pageResult.getList(), saleOrder -> Long.parseLong(saleOrder.getCreator())));
|
// 1.5 计量单位
|
Map<Long, MdmUnitMeasureRespDTO> unitMeasureMap = mdmUnitMeasureApi.getUnitMeasureMap(
|
convertSet(saleOrderItemList, ErpSaleOrderItemDO::getProductUnitId));
|
// 2. 开始拼接
|
return BeanUtils.toBean(pageResult, ErpSaleOrderRespVO.class, saleOrder -> {
|
saleOrder.setItems(BeanUtils.toBean(saleOrderItemMap.get(saleOrder.getId()), ErpSaleOrderRespVO.Item.class,
|
item -> {
|
MapUtils.findAndThen(itemMap, item.getProductId(), mdmItem ->
|
item.setProductName(mdmItem.getName()).setProductBarCode(mdmItem.getBarCode())
|
.setProductSpecification(mdmItem.getSpecification()));
|
MapUtils.findAndThen(unitMeasureMap, item.getProductUnitId(), unit ->
|
item.setProductUnitName(unit.getName()));
|
}));
|
saleOrder.setProductNames(CollUtil.join(saleOrder.getItems(), "，", ErpSaleOrderRespVO.Item::getProductName));
|
MapUtils.findAndThen(customerMap, saleOrder.getCustomerId(), supplier -> saleOrder.setCustomerName(supplier.getName()));
|
MapUtils.findAndThen(userMap, Long.parseLong(saleOrder.getCreator()), user -> saleOrder.setCreatorName(user.getNickname()));
|
// 设置是否有需要生产的明细
|
boolean hasNeedProduction = saleOrder.getItems().stream()
|
.anyMatch(item -> item.getNeedProduction() != null && item.getNeedProduction() == 1);
|
saleOrder.setNeedProduction(hasNeedProduction ? 1 : 0);
|
});
|
}
|
|
}
|
