java进销存--采购下单

采购下单主要是采购物料商品，按供应商采购，一个采购单只能对应一个供应商。

采购管理经过采购下单，采购审核，采购入库

1.表设计

 采购单表

 

CREATE TABLE `pms_order_purchase` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `order_no` varchar(100) NOT NULL COMMENT '采购订单编码',
  `warehouse_code` varchar(100) NOT NULL COMMENT '仓库编码',
  `warehouse_name` varchar(100) DEFAULT NULL COMMENT '仓库名称',
  `partner_code` varchar(100) DEFAULT NULL COMMENT '供应商编码',
  `partner_name` varchar(100) DEFAULT NULL COMMENT '供应商名称',
  `order_state` smallint(6) NOT NULL DEFAULT '0' COMMENT '状态',
  `arrival_date` datetime DEFAULT NULL COMMENT '到货日期',
  `remark` varchar(1000) DEFAULT NULL COMMENT '备注',
  `create_user` varchar(50) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_user` varchar(50) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `yn` tinyint(4) DEFAULT NULL,
  `audit_user` varchar(50) DEFAULT NULL COMMENT '审核人',
  `audit_time` datetime DEFAULT NULL COMMENT '审核时间',
  `cancel_user` varchar(50) DEFAULT NULL COMMENT '取消人',
  `cancel_time` datetime DEFAULT NULL COMMENT '取消时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='采购订单表'

采购单明细表

CREATE TABLE `pms_order_purchase_detail` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `order_no` varchar(100) NOT NULL COMMENT '采购订单编码',
  `sku_code` varchar(100) NOT NULL COMMENT '仓库编码',
  `goods_name` varchar(100) DEFAULT NULL COMMENT '仓库名称',
  `goods_model` varchar(100) DEFAULT NULL COMMENT '规格',
  `unit_name` varchar(100) DEFAULT NULL COMMENT '单位',
  `is_fresh` smallint(6) NOT NULL DEFAULT '0' COMMENT '0:否 1:是',
  `plan_num` decimal(18,3) NOT NULL DEFAULT '0.000' COMMENT '计划量',
  `reality_num` decimal(18,3) NOT NULL DEFAULT '0.000' COMMENT '收货量',
  `tax_rate` decimal(18,3) NOT NULL DEFAULT '0.000' COMMENT '税率',
  `tax_price` decimal(18,3) NOT NULL DEFAULT '0.000' COMMENT '单价',
  `create_user` varchar(50) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_user` varchar(50) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `yn` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COMMENT='采购订单明细表'

 2.采购下单

   选择供应商，仓库，添加商品

   

 @RequestMapping("/addItemDetail")
    @ResponseBody
    public ResponseData addItemDetail(@RequestParam("partnerCode") String partnerCode,
                                      @RequestParam("partnerName") String partnerName,
                                      @RequestParam("warehouseCode") String warehouseCode,
                                      @RequestParam("warehouseName") String warehouseName,
                                      @RequestParam("arrivalDate") Date arrivalDate,
                                      @RequestParam("detailStr") String detailStr,
                                      @RequestParam("remark") String remark
    ) {

       List<PmsOrderPurchaseDetailParam>  pmsOrderPurchaseDetailParamList=JSONObject.parseArray(detailStr,PmsOrderPurchaseDetailParam.class);

       if (pmsOrderPurchaseDetailParamList==null||pmsOrderPurchaseDetailParamList.size()==0)
       {
           return ResponseData.error("没有商品明细");
       }
        Map<String, String> replaceMap = new HashMap<String, String>();
        replaceMap.put("warehouseId", warehouseCode);
        String orderNo = this.codeService.generateCode(CodeExpressEnum.billnoPurchase, replaceMap);

        if (Strings.isNullOrEmpty(orderNo))
        {
            return ResponseData.error("采购单号为空");
        }

        for (PmsOrderPurchaseDetailParam pmsOrderPurchaseDetailParam:pmsOrderPurchaseDetailParamList)
        {
            GoodsResult goodsResult=goodsService.getGoodsBySkuCode(pmsOrderPurchaseDetailParam.getSkuCode());
            pmsOrderPurchaseDetailParam.setGoodsModel(goodsResult.getGoodsModel());
            pmsOrderPurchaseDetailParam.setUnitName(goodsResult.getUnitName());
            pmsOrderPurchaseDetailParam.setRealityNum(new BigDecimal(0));
            pmsOrderPurchaseDetailParam.setTaxRate(goodsResult.getTaxRate());
            pmsOrderPurchaseDetailParam.setCreateUser(LoginContextHolder.getContext().getUser().getUsername());
            pmsOrderPurchaseDetailParam.setCreateTime(new Date());
            pmsOrderPurchaseDetailParam.setUpdateUser(LoginContextHolder.getContext().getUser().getUsername());
            pmsOrderPurchaseDetailParam.setUpdateTime(new Date());
            pmsOrderPurchaseDetailParam.setIsFresh(goodsResult.getIsFresh());
            pmsOrderPurchaseDetailParam.setYn(1);
        }

        PmsOrderPurchaseParam pmsOrderPurchaseParam=new PmsOrderPurchaseParam();
        pmsOrderPurchaseParam.setOrderNo(orderNo);
        pmsOrderPurchaseParam.setWarehouseCode(warehouseCode);
        pmsOrderPurchaseParam.setPartnerCode(partnerCode);
        pmsOrderPurchaseParam.setArrivalDate(arrivalDate);
        pmsOrderPurchaseParam.setRemark(remark);
        pmsOrderPurchaseParam.setCreateUser(LoginContextHolder.getContext().getUser().getUsername());
        pmsOrderPurchaseParam.setCreateTime(new Date());
        pmsOrderPurchaseParam.setUpdateUser(LoginContextHolder.getContext().getUser().getUsername());
        pmsOrderPurchaseParam.setUpdateTime(new Date());
        pmsOrderPurchaseParam.setOrderState(PmsPurchaseStatusEnum.NEW.getStatusValue());
        pmsOrderPurchaseParam.setWarehouseName(warehouseName);
        pmsOrderPurchaseParam.setPartnerName(partnerName);
        pmsOrderPurchaseParam.setYn(1);
        pmsOrderPurchaseDetailService.savePmsPurchase(pmsOrderPurchaseParam,pmsOrderPurchaseDetailParamList);
        return ResponseData.success();
    }

2.采购审核

采购下单后，需要经过审核，看是否还能继续操作

审核过后的采购单才有效

 

@RequestMapping("/audit")
    @ResponseBody
    public ResponseData audit(PmsOrderPurchaseParam pmsOrderPurchaseParam) {
        pmsOrderPurchaseParam.setOrderState(PmsPurchaseStatusEnum.AUDIT.getStatusValue());
        pmsOrderPurchaseParam.setAuditUser(LoginContextHolder.getContext().getUser().getUsername());
        pmsOrderPurchaseParam.setUpdateUser(LoginContextHolder.getContext().getUser().getUsername());
        this.pmsOrderPurchaseService.updateAudit(pmsOrderPurchaseParam);
        return ResponseData.success();
    }

    @RequestMapping("/cancel")
    @ResponseBody
    public ResponseData cancel(PmsOrderPurchaseParam pmsOrderPurchaseParam) {
        pmsOrderPurchaseParam.setOrderState(PmsPurchaseStatusEnum.CANCEL.getStatusValue());
        pmsOrderPurchaseParam.setCancelUser(LoginContextHolder.getContext().getUser().getUsername());
        pmsOrderPurchaseParam.setUpdateUser(LoginContextHolder.getContext().getUser().getUsername());
        this.pmsOrderPurchaseService.updateCancel(pmsOrderPurchaseParam);
        return ResponseData.success();
    }