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