public function view_tmpReturnPros() { $tmpReturnProsAct = new TmpReturnProsAct(); $productsAct = new ProductsAct(); //ProductsAct //添加sku $type = isset($_GET['type']) ? $_GET['type'] : ''; $sku = isset($_GET['sku']) ? post_check(trim($_GET['sku'])) : ''; if ($type == 'add') { if (!empty($sku)) { $skuList = getSkuBygoodsCode($sku); if (empty($skuList)) { $status = "{$_GET['sku']} 找不到对应料号"; header('Location:index.php?mod=products&act=tmpReturnPros&status=' . $status); exit; } $sku = $skuList[0]['sku']; $whereProducts = "where sku='{$sku}' and productsStatus=3"; $isExsit = $productsAct->act_getProductsCount($whereProducts); //查看添加的sku是否是pc_products中状态为3的(归还) $status = ''; if ($isExsit > 0) { //如果存在 $where = "where sku='{$sku}'"; $now = time(); $skuExistCount = $tmpReturnProsAct->act_getTmpReturnProsCount($where); //查看添加的sku是否在退料临时表中存在 $flag = 0; //标识是添加成功还是由于数量导致添加失败 if ($skuExistCount > 0) { //如果存在 $productsCountArr = $productsAct->act_getProducts('productsCount', $whereProducts); $productsCount = $productsCountArr[0]['productsCount']; //该sku在products表中的数量 $skuCountArr = $tmpReturnProsAct->act_getTmpReturnPros("count", $where); //该sku在退料临时表中的数量 $skuCount = $skuCountArr[0]['count'] + 1; if ($skuCount > $productsCount) { $flag = 1; //改变标识变量,输出提示 $status = "添加失败,{$sku} 已经扫描过且数量达到上限"; } else { $set = "set count='{$skuCount}',createdTime='{$now}'"; $tmpReturnProsAct->act_updateTmpReturnPros($set, "where sku='{$sku}'"); } } else { $userId = intval($_SESSION['userId']); if ($userId <= 0) { $status = "登陆超时,请重试"; header('Location:index.php?mod=products&act=tmpReturnPros&status=' . $status); exit; } $tmpReturnProsAct->act_addTmpReturnPros("set sku='{$sku}',addUserId={$userId},createdTime='{$now}'"); } if ($flag == 0) { $status = $sku . ' 添加成功'; } } else { $status = "添加失败,制作完成列表中找不到 {$sku}"; } } header('Location:index.php?mod=products&act=tmpReturnPros&status=' . $status); } //展示tmp表中的记录 $select = "*"; $where = "WHERE returnType=1 order by createdTime desc"; $tmpReturnProsList = $tmpReturnProsAct->act_getTmpReturnPros($select, $where); $navlist = array(array('url' => 'index.php?mod=products&act=getProductsComfirmList', 'title' => '产品制作'), array('url' => 'index.php?mod=products&act=tmpReturnPros', 'title' => '新品归还')); $this->smarty->assign('navlist', $navlist); $this->smarty->assign('onevar', 5); $this->smarty->assign('twovar', 56); $this->smarty->assign('show_page', $show_page); $this->smarty->assign('title', '新品归还'); $this->smarty->assign('status', $status); if (!empty($tmpReturnProsList)) { $whInfoList = getWhInfo(); //根据接口取得对应仓库信息 $whArr = array(); foreach ($whInfoList as $value) { if (intval($value['id']) > 0) { $whArr[$value['id']] = $value['whName']; } } $countProsList = count($tmpReturnProsList); for ($i = 0; $i < $countProsList; $i++) { $sku = $tmpReturnProsList[$i]['sku']; $tName = 'pc_goods'; $select = 'goodsName'; $where = "WHERE sku='{$sku}'"; $skuInfoList = OmAvailableModel::getTNameList($tName, $select, $where); $tmpReturnProsList[$i]['goodsName'] = $skuInfoList[0]['goodsName']; $tName = 'pc_goods_whId_location_raletion'; $select = 'location,whId'; $where = "WHERE sku='{$sku}'"; $skuLocWhInfoList = OmAvailableModel::getTNameList($tName, $select, $where); $tmpReturnProsList[$i]['location'] = $skuLocWhInfoList[0]['location']; $tmpReturnProsList[$i]['whName'] = $whArr[$skuLocWhInfoList[0]['whId']]; } } $this->smarty->assign('tmpReturnProsList', empty($tmpReturnProsList) ? array() : $tmpReturnProsList); $this->smarty->display("tmpReturnPros.htm"); }
public function view_tmpReturnPros() { if (!isset($_SESSION['userId'])) { header('Location:index.php?mod=login&act=index'); } $tmpReturnProsAct = new TmpReturnProsAct(); $productsAct = new ProductsAct(); //ProductsAct //添加sku $type = isset($_GET['type']) ? $_GET['type'] : ''; $sku = isset($_GET['sku']) ? post_check($_GET['sku']) : ''; if ($type == 'add') { if (!empty($sku)) { $whereProducts = "where sku='{$sku}' and productsStatus=3"; $isExsit = $productsAct->act_getProductsCount($whereProducts); //查看添加的sku是否是pc_products中状态为5的(状态为文员确认归还) $status = ''; if ($isExsit > 0) { //如果存在 $where = "where sku='{$sku}'"; $now = time(); $skuExistCount = $tmpReturnProsAct->act_getTmpReturnProsCount($where); //查看添加的sku是否在退料临时表中存在 $flag = 0; //标识是添加成功还是由于数量导致添加失败 if ($skuExistCount > 0) { //如果存在 $productsCountArr = $productsAct->act_getProducts('productsCount', $whereProducts); $productsCount = $productsCountArr[0]['productsCount']; //该sku在products表中的数量 $skuCountArr = $tmpReturnProsAct->act_getTmpReturnPros("count", $where); //该sku在退料临时表中的数量 $skuCount = $skuCountArr[0]['count'] + 1; if ($skuCount > $productsCount) { $flag = 1; //改变标识变量,输出提示 $status = '添加失败,该sku已经扫描过且数量达到上限'; } else { $set = "set count='{$skuCount}',createdTime='{$now}'"; $tmpReturnProsAct->act_updateTmpReturnPros($set, "where sku='{$sku}'"); } } else { $tmpReturnProsAct->act_addTmpReturnPros("set sku='{$sku}',count=1,createdTime='{$now}'"); } if ($flag == 0) { $status = '添加成功'; } } else { $status = '添加失败,文员确认收到列表中找不到该料号'; } } header('Location:index.php?mod=TmpReturnPros&act=tmpReturnPros&status=' . $status); } //展示tmp表中的记录 $select = "*"; $where = "order by createdTime desc"; $productsList = $tmpReturnProsAct->act_getTmpReturnPros($select, $where); //删除tmp中的记录 $this->tp->set_file("productsList", "tmpReturnPros.html"); $this->tp->set_file("header", "header.html"); $this->tp->set_file("link", "productsLink.html"); $this->tp->set_file("footer", "footer.html"); $this->tp->parse("header", "header"); $this->tp->parse("link", "link"); $this->tp->parse("footer", "footer"); $this->tp->set_var("title", "退还料号临时表"); $this->tp->set_block("productsList", "list", "lists"); $this->tp->set_var("username", $_SESSION['username']); $this->tp->set_var("status", $_GET['status']); if (!empty($productsList)) { foreach ($productsList as $products) { $this->tp->set_var("t_id", $products['id']); $this->tp->set_var("t_sku", $products['sku']); $this->tp->set_var("t_count", $products['count']); $this->tp->set_var("t_createdTime", date("Y-m-d H:m:s", $products['createdTime'])); $this->tp->parse("lists", "list", true); } } $this->tp->parse("buff", "productsList"); $this->tp->p("buff"); }