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