/** 提交 */
@Before(Tx.class)
public String[] submit(String id, String company_id, String uid, String now, String nowtime) {
String[] billsnList = new String[2];
Db.update(
"update "
+ tableName
+ " set submit_status=1 where id=? and company_id=? and (head_id=? or creater_id=?) ",
id,
company_id,
uid,
uid);
StockAllot po = this.findById(id, company_id);
String to_depot_id = po.getStr("to_depot_id");
String out_depot_id = po.getStr("out_depot_id");
billsnList[0] = SnCreater.dao.create("OUTSTOCK", company_id);
billsnList[1] = SnCreater.dao.create("INSTOCK", company_id);
// 生成出入库
StorageBill sb = new StorageBill();
// 出库单
sb.set("billsn", billsnList[0]);
sb.set("type", 2); // 2调拨出库 6调拨入库
sb.set("depot_id", out_depot_id);
sb.set("head_id", po.getStr("head_id"));
sb.set("creater_id", uid);
sb.set("create_datetime", nowtime);
sb.set("bill_date", now);
sb.set("company_id", company_id);
sb.save();
String bill_id = sb.getStr("id");
Db.update(
"insert into "
+ StorageBillList.tableName
+ " (id,product_id,amount) select '"
+ bill_id
+ "',product_id,amount from "
+ StockAllotList.tableName
+ " a where a.id=?",
id);
// 入库单
sb.set("id", null);
sb.set("type", 6); // 6调拨入库
sb.set("depot_id", to_depot_id);
sb.set("billsn", billsnList[1]);
sb.save();
bill_id = sb.getStr("id");
Db.update(
"insert into "
+ StorageBillList.tableName
+ " (id,product_id,amount) select '"
+ bill_id
+ "',product_id,amount from "
+ StockAllotList.tableName
+ " a where a.id=?",
id);
return billsnList;
}
