public function view_printLabelList()
{
$storeId = intval(trim($_GET['storeId']));
$storeId = $storeId ? $storeId : 1;
$navlist = array(array('url' => '', 'title' => '入库'), array('url' => 'index.php?mod=printLabel&act=printLabel&storeId=' . $storeId, 'title' => '打标操作'), array('url' => '', 'title' => '打标清单'));
$toplevel = 1;
$secondlevel = $storeId == 1 ? 12 : 19;
$this->smarty->assign('navlist', $navlist);
$this->smarty->assign('toplevel', $toplevel);
$this->smarty->assign('secondlevel', $secondlevel);
$this->smarty->assign('storeId', $storeId);
$checkUser = isset($_GET['checkUser']) ? $_GET['checkUser'] : "";
$sku = isset($_GET['sku']) ? $_GET['sku'] : "";
$start = isset($_GET['start']) ? $_GET['start'] : "";
$end = isset($_GET['end']) ? $_GET['end'] : "";
if (empty($checkUser) && empty($sku) && empty($start) && empty($end)) {
$where = "";
} else {
if (!empty($checkUser)) {
$where[] = "printerId='{$checkUser}'";
$this->smarty->assign("checkUser", $checkUser);
}
if (!empty($sku)) {
$where[] = "sku = '{$sku}'";
$this->smarty->assign("sku", $sku);
}
if (!empty($start) && !empty($end)) {
$starttime = strtotime($start . " 00:00:00");
$endtime = strtotime($start . " 23:59:59");
$where[] = "(entryTime between {$starttime} and {$endtime})";
$this->smarty->assign("start", $start);
$this->smarty->assign("end", $end);
} elseif (!empty($start) && empty($end)) {
$starttime = strtotime($start . " 00:00:00");
$where[] = "entryTime >{$starttime}";
$this->smarty->assign("start", $start);
} elseif (empty($start) && !empty($end)) {
$endtime = strtotime($start . " 23:59:59");
$where[] = "entryTime < {$endtime}";
$this->smarty->assign("end", $end);
}
$where = " AND " . implode(" AND ", $where);
//$where = "where ".$where;
}
$where = "where printerId IS NOT NULL and is_delete=0" . $where . " and storeId = '{$storeId}' order by id desc";
$pagesize = 20;
//$lists = packageCheckModel::selectList($where);
//$nums = count($lists);
$nums = packageCheckModel::getTotalNums($where);
$pager = new Page($nums, $pagesize);
$lists = packageCheckModel::selectList($where . " " . $pager->limit);
if ($nums > $pagesize) {
//分页
$pagestr = $pager->fpage(array(0, 2, 3, 4, 5, 6, 7, 8, 9));
} else {
$pagestr = $pager->fpage(array(0, 2, 3));
}
$usermodel = UserModel::getInstance();
//打标员
$Marking_user = $usermodel->getGlobalUserLists('global_user_id,global_user_name', "where a.global_user_job=168", '', '');
$this->smarty->assign('Marking_user', $Marking_user);
foreach ($lists as $key => $list) {
//到货库存
$sku_arrival = OmAvailableModel::getTNameList("wh_sku_location", "arrivalInventory", "where sku='{$list['sku']}'");
$lists[$key]['arrivalInventory'] = $sku_arrival[0]['arrivalInventory'];
}
$this->smarty->assign('pagestr', $pagestr);
$this->smarty->assign("lists", $lists);
$toptitle = '打标清单列表';
//顶部链接
$this->smarty->assign('toptitle', $toptitle);
$userList = packageCheckModel::selectUser();
$this->smarty->display('printLabelList.htm');
}
public function view_abnormal()
{
$storeId = intval(trim($_GET['storeId']));
$storeId = $storeId ? $storeId : 1;
//仓库ID
$navlist = array(array('url' => '', 'title' => '入库'), array('url' => 'index.php?mod=packageCheck&act=packageCheck&storeId=' . $storeId, 'title' => '点货操作'), array('url' => '', 'title' => '异常录入'));
$toplevel = 1;
$secondlevel = $storeId == 1 ? "11" : 18;
$this->smarty->assign('navlist', $navlist);
$this->smarty->assign('toplevel', $toplevel);
$this->smarty->assign('secondlevel', $secondlevel);
$this->smarty->assign('storeId', $storeId);
$checkUser = isset($_GET['checkUser']) ? $_GET['checkUser'] : "";
$status = isset($_GET['status']) ? $_GET['status'] : 1;
$sku = isset($_GET['sku']) ? $_GET['sku'] : "";
$start = isset($_GET['start']) ? $_GET['start'] : "";
$end = isset($_GET['end']) ? $_GET['end'] : "";
$where[] = "entryStatus='{$status}'";
$this->smarty->assign("status", $status);
if (!empty($checkUser)) {
$where[] = "tallyUserId='{$checkUser}'";
$this->smarty->assign("checkUser", $checkUser);
}
if (!empty($sku)) {
$where[] = "sku = '{$sku}'";
$this->smarty->assign("sku", $sku);
}
if (!empty($start)) {
$start_time = strtotime($start . " 00:00:00");
$where[] = "entryTime >={$start_time}";
$this->smarty->assign("start", $start);
}
if (!empty($end)) {
$end_time = strtotime($end . " 23:59:59");
$where[] = "entryTime <={$end_time}";
$this->smarty->assign("end", $end);
}
$where = " AND " . implode(" AND ", $where);
$where = "where is_delete=0 and entryStatus!=0" . $where;
$where .= " and storeId ='{$storeId}'";
$pagesize = 200;
//print_r($where);exit;
$lists = packageCheckModel::selectList($where);
$nums = count($lists);
$pager = new Page($nums, $pagesize);
$lists = packageCheckModel::selectList($where . " " . $pager->limit);
if ($nums > $pagesize) {
//分页
$pagestr = $pager->fpage(array(0, 2, 3, 4, 5, 6, 7, 8, 9));
} else {
$pagestr = $pager->fpage(array(0, 2, 3));
}
$usermodel = UserModel::getInstance();
//点货员
$Marking_user = $usermodel->getGlobalUserLists('global_user_id,global_user_name', "where a.global_user_job=209", '', '');
$this->smarty->assign('Marking_user', $Marking_user);
$toptitle = '异常录入';
//顶部链接
$this->smarty->assign('toptitle', $toptitle);
$this->smarty->assign('pagestr', $pagestr);
$this->smarty->assign("lists", $lists);
$userList = packageCheckModel::selectUser();
$this->smarty->display('abnormal.htm');
}
