/**
* 库存调整入库确认 插入库存信息表(TD_STOCK_INFO)信息， 插入出入库流水表(td_stock_flow)一条出库记录
*
* @param sif - 入库信息；
* @return 是否成功标志
*/
public int stockAdjustIn(StockFlowForm sff) throws Exception {
int tag = -1;
StockInfoForm sif = flowToInfo(sff);
StockOutBo sob = StockOutBo.getInstance();
sff.setRestNum(sob.getRestStock(sif.getStuffNo(), sff.getSkuNum(), "I"));
ArrayList al = new ArrayList();
al.add(sif);
al.add(sff);
if (this.getBatchDao().insertBatch(al)) {
tag = 1;
// 把原先0数量的该零件删除
// sob.inMerge(sff.getStuffNo());
}
return tag;
}
public StockInfoForm flowToInfo(StockFlowForm sff) throws Exception {
StockInfoForm sif = new StockInfoForm();
sif.setFlowNo(sff.getFlowId());
sif.setSkuCode(sff.getSkuCode());
sif.setShortCode(sff.getShortCode());
sif.setStandard(sff.getStandard());
sif.setStuffNo(sff.getStuffNo());
sif.setSkuUnit(sff.getSkuUnit());
sif.setSkuNum(sff.getSkuNum());
sif.setPerCost(sff.getPerCost());
sif.setSkuType(sff.getSkuType());
sif.setRemark(sff.getRemark());
sif.setCreateBy(sff.getCreateBy());
sif.setCreateDate(new Date());
sif.setUpdateDate(sff.getUpdateDate());
sif.setOrderDollar(sff.getOrderDollar());
sif.setFreightTW(sff.getFreightTW());
sif.setTransportMode(sff.getTransportMode());
return sif;
}
/**
* 订购入库 接收 1.先将实际收到零件全部入库（临时库存X），插入StockInfoForm和StockFlowForm，各recevie条。 2.修改PO状态，以及拆分PO
* 分析PO数量和到货recevie数量: a. PO<=recevie : 将对应PO直接修改状态（已到货/已分配待领取）； b. PO>recevie :
* 拆分PO，原来记录的num改为PO-recevie，状态不变； 新增recevie条，并修改状态（已到货/已分配待领取）； 3.调用分配逻辑 a.
* 将销售零件进行状态修改或拆分，再判断销售单状态是否需要修改； b. 将销售零件的detailId赋值给库存requestId，保留该库存零件（已分配待领取） ； c.
* 若入库有剩余，将剩余零件再分配给其他需要该零件的单子；
*
* @param para 收货信息
* @param saleNo 销售单号
* @param userId 操作人
* @return tag
*/
public synchronized int orderInReceive(
String[][] para, String saleNo, Long userId, String transportMode) throws Exception {
int tag = -1;
ArrayList poList = new ArrayList();
ArrayList<StockInfoForm> stockList = new ArrayList<StockInfoForm>();
PartPoBo ppb = PartPoBo.getInstance();
PartInfoBo pib = PartInfoBo.getInstance();
// SaleInfoBo sib=SaleInfoBo.getInstance();
StockOutBo sob = StockOutBo.getInstance();
String inStuffNo = "";
for (int i = 0; i < para[0].length; i++) {
PoForm pf = ppb.findById(new Long(para[0][i]));
PartInfoForm pi = pib.find(pf.getStuffNo());
// 零件料号非法
if (pi == null) {
throw new IllegalPoException(pf.getStuffNo());
}
int intPoNum = pf.getOrderNum();
int intReceiveNum = Integer.parseInt(para[1][i]);
if (intReceiveNum > 0) {
// 插入库存信息表
StockInfoForm sif = new StockInfoForm();
sif.setCreateBy(userId);
sif.setStuffNo(pf.getStuffNo());
sif.setSkuCode(pf.getSkuCode());
sif.setShortCode(pi.getShortCode());
sif.setStandard(pi.getStandard());
sif.setSkuUnit(pf.getSkuUnit());
sif.setSkuNum(intReceiveNum);
sif.setPerCost(
calculatePerCost(new Float(para[2][i]), new Float(para[4][i]), new Float(para[6][i])));
sif.setOrderDollar(new Float(para[3][i]));
sif.setFreightTW(new Float(para[4][i]));
sif.setInvoiceNo(para[5][i]);
sif.setBinCode(para[7][i]);
sif.setSkuType("A"); // 默认
sif.setStockStatus("X"); // 临时状态，等待到货分配时修改
sif.setRequestId(pf.getRequestId()); // 申请零件时的saleDetailId，到货分配时调用
sif.setSkuType("S");
sif.setCreateBy(userId);
sif.setCreateDate(new Date());
sif.setFlowNo(FormNumberBuilder.getStockFlowId()); // 流水号fk
sif.setTransportMode(transportMode);
stockList.add(sif);
inStuffNo += "," + sif.getStuffNo();
// 插入出入库流水表
StockFlowForm sff = this.infoToFlow(sif);
sff.setSkuNum(intReceiveNum);
sff.setRestNum(sob.getRestStock(sif.getStuffNo(), intReceiveNum, "I"));
sff.setCustomerName(pf.getCustomerName());
sff.setFlowType("I");
sff.setFlowItem("D"); // 订购入库
sff.setFeeType(pf.getOrderType());
sff.setRequestId(pf.getPoNo());
sff.setFormNo(pf.getSaleNo());
sff.setOrderDollar(sif.getOrderDollar());
sff.setFreightTW(sif.getFreightTW());
sff.setInvoiceNo(sif.getInvoiceNo());
sff.setTransportMode(sif.getTransportMode());
sff.setBinCode(sif.getBinCode());
poList.add(sff);
if (intPoNum <= intReceiveNum) { // a. PO<=recevie
pf.setOrderStatus("C"); // 已到货
pf.setUpdateBy(userId);
pf.setUpdateDate(new Date());
poList.add(pf);
} else { // b. PO>recevie
// 原来记录的num改为PO-recevie，仍然等待PO
pf.setOrderNum(intPoNum - intReceiveNum);
pf.setUpdateBy(userId);
pf.setUpdateDate(new Date());
poList.add(pf);
// 拆分出recevie条，状态已到货
PoForm newPo = new PoForm();
BeanUtils.copyProperties(newPo, pf);
newPo.setPoNo(null);
newPo.setOrderNum(intReceiveNum);
newPo.setOrderStatus("C"); // 已到货
newPo.setCreateBy(userId);
newPo.setCreateDate(new Date());
poList.add(newPo);
}
}
}
if (poList.size() > 0 && this.getBatchDao().saveOrUpdateBatch(poList)) {
if (this.getBatchDao().insertBatch(stockList)) {
tag = new ReceiveAllocateBo().allocate(stockList);
// sob.inMerge(inStuffNo.substring(1).replace(",", "','"));
}
}
return tag;
}