public function view_iqcWaitCheck() { $IqcAct = new IqcAct(); $where = "where sellerId=0 and detectStatus=1 and getUserId='{$_SESSION['userId']}' "; $total = $IqcAct->act_getNowWhNum($where); $num = 200; //每页显示的个数 $page = new Page($total, $num, '', 'CN'); $where .= "order by id desc " . $page->limit; $iqcList = $IqcAct->act_getNowWhList('*', $where); if (!empty($_GET['page'])) { if (intval($_GET['page']) <= 1 || intval($_GET['page']) > ceil($total / $num)) { $n = 1; } else { $n = (intval($_GET['page']) - 1) * $num + 1; } } else { $n = 1; } if ($total > $num) { //输出分页显示 $show_page = $page->fpage(array(0, 2, 3, 4, 5, 6, 7, 8, 9)); } else { $show_page = $page->fpage(array(0, 2, 3)); } $this->smarty->assign('show_page', $show_page); $this->smarty->assign('iqcList', $iqcList); $this->smarty->assign('secnev', '1'); //二级导航 $this->smarty->assign('module', 'SKU等待检测'); $this->smarty->assign('username', $_SESSION['userName']); $navarr = array("<a href='index.php?mod=iqc&act=iqcList'>iqc检测领取</a>", ">>", "等待检测"); $this->smarty->assign('navarr', $navarr); $this->smarty->display('iqcWaitCheck.html'); }
function act_getSkuInfo() { $sku = $_POST['sku']; $is_delete = $_POST['is_delete']; if (is_numeric($sku) && $sku > 1000000) { //此sku为goods_code $goods_codes = WhStandardModel::goods_codeTosku($sku); $sku = $goods_codes['sku']; } //$where = "where sku='$sku' and sellerId=0 and detectStatus=0 order by id desc"; if ($is_delete) { //如果是已删数据检索 $where = "where sku='{$sku}' and is_delete=1 order by id desc"; } else { $where = "where sku='{$sku}' and detectStatus=0 and is_delete=0 order by id desc"; } $list = WhStandardModel::getNowWhList("*", $where); foreach ($list as $key => $value) { $list[$key]['printTime'] = date("Y-m-d H:i:s", $value['printTime']); $list[$key]['printerId'] = userModel::getUsernameById($value['printerId']); $list[$key]['purchaseId'] = userModel::getUsernameById($value['purchaseId']); $list[$key]['deleteUserId'] = userModel::getUsernameById($value['deleteUserId']); $list[$key]['getUserId'] = userModel::getUsernameById($value['getUserId']); } if ($list) { return $list; } else { $where = "where sku='{$sku}' order by id desc limit 3"; $list = WhStandardModel::getNowWhList("*", $where); foreach ($list as $key => $value) { if (!empty($value['getTime']) && $value['detectStatus'] == 1) { $user = userModel::getUsernameById($value['getUserId']); $getTime = date('Y-m-d H:i:s', $value['getTime']); self::$errMsg .= "-料号-{$value['sku']} {$value['num']}件-于<font color='green'>{$getTime}</font>被<font color='green'>{$user}</font>领取,请联系他/她。<br>"; } else { if ($value['is_delete'] == 1) { $printer = userModel::getUsernameById($value['printerId']); $printTime = date('Y-m-d H:i:s', $value['printTime']); self::$errMsg .= "-料号-{$value['sku']} {$value['num']}件-于<font color='green'>{$printTime}</font>由<font color='green'>{$printer}</font>打印,已过期删除!<br>"; } else { if ($value['detectStatus'] == 3) { $detector = userModel::getUsernameById($value['detectorId']); $detectTime = date('Y-m-d H:i:s', $value['detectStartTime']); self::$errMsg .= "-料号-{$value['sku']} {$value['num']}件-于<font color='green'>{$detectTime}</font>由<font color='green'>{$detector}</font>检测完成!<br>"; } } } } if (self::$errMsg == '') { if ($is_delete == 0) { self::$errMsg .= "-料号-{$sku}-不在待领取列表中,请联系<font color='green'>仓库或打标人员</font>!<br>"; } else { self::$errMsg .= "-料号-{$sku}-未在删除数据中找到。<br>"; } } self::$errCode = "003"; return false; } }
function act_getSkuInfo() { $sku = $_POST['sku']; $where = "where sku='{$sku}' and sellerId=0 and detectStatus=0 order by id desc"; $list = WhStandardModel::getNowWhList("*", $where); if ($list) { return $list; } else { self::$errCode = "003"; self::$errMsg = "没有找到对应的料号!"; return false; } }
public function view_iqcRestore() { $state = isset($_GET['state']) ? post_check($_GET['state']) : ''; $this->smarty->assign('state', $state); $sku = isset($_GET['sku']) ? post_check($_GET['sku']) : ''; $IqcAct = new IqcAct(); $where = " where sellerId=1 and num>0 and is_delete=1 "; if ($sku) { $where .= "and sku ='{$sku}' "; $this->smarty->assign('sku', $sku); } $total = $IqcAct->act_getNowWhNum($where); $num = 100; //每页显示的个数 $page = new Page($total, $num, '', 'CN'); $where .= "order by id desc " . $page->limit; $iqcList = $IqcAct->act_getNowWhList('*', $where); if (!empty($_GET['page'])) { if (intval($_GET['page']) <= 1 || intval($_GET['page']) > ceil($total / $num)) { $n = 1; } else { $n = (intval($_GET['page']) - 1) * $num + 1; } } else { $n = 1; } if ($total > $num) { //输出分页显示 $show_page = $page->fpage(array(0, 2, 3, 4, 5, 6, 7, 8, 9)); } else { $show_page = $page->fpage(array(0, 2, 3)); } $this->smarty->assign('show_page', $show_page); $this->smarty->assign('iqcList', $iqcList); $sku_arr = array(); $sku_str = ''; foreach ($iqcList as $list) { $sku_str .= "'" . $list['sku'] . "',"; } $sku_str = "(" . trim($sku_str, ',') . ")"; $skuinfo = UserCacheModel::goodsInfosCache("*", base64_encode("sku in {$sku_str}")); foreach ($skuinfo['data'] as $info) { $sku_arr[$info['sku']] = $info['goodsName']; } $this->smarty->assign('sku_arr', $sku_arr); $this->smarty->assign('secnev', '1'); //二级导航 $this->smarty->assign('module', '检索已删SKU'); $this->smarty->assign('username', $_SESSION['userName']); $navarr = array("<a href='index.php?mod=iqc&act=iqcRestore'>QC检测领取</a>", ">>", "搜查已删sku"); $this->smarty->assign('navarr', $navarr); $this->smarty->display('iqcRestore.htm'); }