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