public function view_list()
{
global $mod, $act;
$this->smarty->assign('title', '到货查询');
$skuItem = new SkuAct();
$listInfo = $skuItem->show_reach_list();
$perNum = 100;
$totalNum = $listInfo["totalNum"];
$list = $listInfo["skuInfo"];
$pageobj = new Page($totalNum, $perNum);
$pageStr = $pageobj->fpage();
$this->smarty->assign('pageStr', $pageStr);
//分页输出
$this->smarty->assign('list', $list);
//循环赋值
$this->smarty->display('reach_list.htm');
}
public function view_oversea()
{
error_reporting(0);
$skuData = new SkuAanalyzeAct();
$skulists = $skuData->overseaAlertInfo();
$total = $skulists["totalNum"];
$skuInfo = $skulists["skuInfo"];
$pagenum = 100;
$page = new Page($total, $pagenum);
$pageStr = $page->fpage();
$this->smarty->assign('title', '海外仓下单预警');
$this->smarty->assign('skuInfo', $skuInfo);
$overCguserArr = array('龚永喜', '陈珠艺', '陈剑锋', '郑珍', '王芳', '英爱', '陈奕宏', '汤东东', '胡威');
$loginName = $_SESSION['userCnName'];
$this->smarty->assign('loginName', $loginName);
$this->smarty->assign('overCguserArr', $overCguserArr);
$platformInfo = $skuData->getSalePlatform();
$this->smarty->assign('platformInfo', $platformInfo);
//销售平台数据
$skuAct = new SkuAct();
$setContion = $skuAct->getSetting();
$this->smarty->assign("setContion", $setContion);
$totalPageNum = ceil($total / $pagenum);
$purchaseList = getPurchaseUserList();
$this->smarty->assign('purchaseList', $purchaseList);
//采购列表
$partnerList = getPartnerlist();
$this->smarty->assign('partnerList', $partnerList);
//供应商列表
$allPurchaser = getPurchaseUserList();
$tableColor = array("active", "success", " ", "warning", " ", "danger");
$this->smarty->assign("tableColor", $tableColor);
$this->smarty->assign('allPurchaser', $allPurchaser);
$this->smarty->assign('pageStr', $pageStr);
//分页输出
$this->smarty->assign('totalPageNum', $totalPageNum);
$this->smarty->display('oversea.htm');
}
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 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 addUnStock()
{
global $dbconn;
$sku = $_REQUEST["sku"];
$amount = $_REQUEST["amount"];
$sql = "select a.count ,a.stockqty,a.id as detail_id,a.sku, b.recordnumber,b.id from ph_order_detail as a left join ph_order as b on a.po_id=b.id where a.is_delete=0\n\t\t\t\tand b.status=3 \n\t\t\t\tand a.sku='{$sku}'\n\t\t\t\torder by b.aduittime ASC\n\t\t\t";
//查找在途订单sku 未到货的数量
$sql = $dbconn->execute($sql);
$skuInfoArr = $dbconn->getResultArray($sql);
$now = time();
$flag = array();
$skuObj = new SkuAct();
$skuObj->tallySkuRecord($sku, $amount, 2);
foreach ($skuInfoArr as $item) {
if ($amount <= 0) {
//匹配完成 跳出
break;
}
$unArriveNum = $item["count"] - $item["stockqty"];
if ($unArriveNum <= $amount) {
//订单的数量小于等于入库数量
$nowNeedAmount = $unArriveNum;
} else {
$nowNeedAmount = $amount;
}
$amount = $amount - $nowNeedAmount;
//入库后剩余数量
//$sql = "update ph_order_detail set stockqty=stockqty+{$nowNeedAmount},ungoodqty=ungoodqty+{$nowNeedAmount},reach_time={$now} where id={$item['detail_id']}";
$sql = "update ph_order_detail set ungoodqty=ungoodqty+{$nowNeedAmount},reach_time={$now} where id={$item['detail_id']}";
if ($dbconn->execute($sql)) {
//写入批次到货记录表
if ($nowNeedAmount > 0) {
$sql = "INSERT INTO `ph_order_arrive_log`(`ordersn`, `sku`, `amount`, `arrive_time`) VALUES ('{$item['recordnumber']}','{$item['sku']}',{$nowNeedAmount},{$now})";
$dbconn->execute($sql);
}
$this->checkOrderFinish($item["id"]);
} else {
//如果入库不成功
$flag[] = 0;
}
}
if (in_array(0, $flag)) {
//插入数据不成功
$data["errorCode"] = 500;
$data["msg"] = "部分数据插入失败";
} else {
$data["errorCode"] = 0;
$data["msg"] = "success";
}
return json_encode($data);
}
