public function updUnusualSkuConfirmQty($data)
{
$skuact = new SkuAct();
$purorder = new PurchaseOrderAct();
if (!empty($data)) {
foreach ($data as $k => $v) {
$id = $v['id'];
$sku = $v['sku'];
$status = $v['status'];
$totalAmount = $v['totalAmount'];
//总共到货数量
$onWayAmount = $purorder->checkSkuOnWayNum($sku);
//在途数量
$waitOnAmount = $skuact->getTallySkuNum($sku);
//等待上架数量
$waitOnAmount = !empty($waitOnAmount) ? $waitOnAmount : 0;
$confirmAmount = $totalAmount + $waitOnAmount - $onWayAmount;
if ($status == 0) {
PurToWhModel::updUnusualSkuConfirmQty($id, $confirmAmount);
//重新计算待确认数量
}
}
}
}
public function secondComfirm()
{
error_reporting(-1);
global $dbConn;
$dataArr = $_POST['data'];
$orderIdArr = array();
$skuOrder = new PurchaseOrderAct();
$tallyObj = new SkuAct();
foreach ($dataArr as $item) {
$onWayNum = $skuOrder->checkSkuOnWayNum($item['sku']);
$tallyNum = $tallyObj->getTallySkuNum($item['sku']);
//$nowNum = $onWayNum - $tallyNum;
$nowNum = $onWayNum;
if ($nowNum >= $item['qty']) {
//var_dump($onWayNum,$item['qty'],$item['id']);
//if($onWayNum >= $item['qty']){
$orderIdArr[] = $item['unorderid'];
$tallyObj->tallySkuRecord($item['sku'], $item['qty'], 1);
$sql = "UPDATE `ph_sku_reach_record` SET status=2 where id={$item['id']}";
$dbConn->execute($sql);
}
}
$rtn = $this->setTallyIsUse($orderIdArr);
$rtn = json_decode($rtn, true);
if ($rtn['errCode'] == 0) {
return 1;
} else {
return 0;
}
}
public function addSkuReach()
{
global $dbconn;
$orderArr = $_POST["orderArr"];
$orderArr = json_decode($orderArr, true);
$now = time();
$sql = "INSERT INTO ph_sku_reach_record(sku,purchaseId, amount, totalAmount,tallymanId,note,addtime,partnerName,unOrderId) VALUES ";
$sqlarr = array();
$rollback = false;
$purchaseOrder = new PurchaseOrderAct();
foreach ($orderArr as $orderItem) {
$sku = $orderItem["sku"];
$amount = $orderItem["amount"];
$unOrderId = $orderItem["orderid"];
$user = getUserIdBySku($sku);
$purchaseId = $user["purchaseId"];
$partnerName = getPartnerBySku($sku);
$tallymanId = $orderItem["tallymanId"];
$onWayNum = $purchaseOrder->checkSkuOnWayNum($sku);
//在途数量
//$tallyAmount = $this->getTallySkuNum($sku); //已经点货的数量
//$nowUnReach = $onWayNum - $tallyAmount;
$unSkuNum = $amount - $onWayNum;
$note = "当时的在途数量是{$onWayNum}个，总共到货数量{$amount}个，异常到货数量{$unSkuNum}个";
$sqlarr[] = " ('{$sku}','{$purchaseId}',{$unSkuNum},{$amount},'{$tallymanId}','{$note}',{$now},'{$partnerName}',{$unOrderId}) ";
}
$sqlStr = implode(",", $sqlarr);
$sql .= $sqlStr;
if ($dbconn->execute($sql)) {
$rtn["msg"] = "添加数据成功";
$rtn["errCode"] = 0;
} else {
$rtn["msg"] = "添加数据成功";
$rtn["errCode"] = 0;
}
return json_encode($rtn);
}
