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();
    }