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_showPackage() { $navlist = array(array('url' => '', 'title' => '库存管理'), array('url' => '', 'title' => '点货清单')); $toplevel = 0; $secondlevel = 03; $checkUser = isset($_GET['checkUser']) ? $_GET['checkUser'] : ""; $purchase = isset($_GET['purchase']) ? $_GET['purchase'] : ""; $sku = isset($_GET['sku']) ? $_GET['sku'] : ""; $status = isset($_GET['status']) ? $_GET['status'] : 3; $start = isset($_GET['startdate']) ? $_GET['startdate'] : ""; $end = isset($_GET['enddate']) ? $_GET['enddate'] : ""; $this->smarty->assign('navlist', $navlist); $this->smarty->assign('toplevel', $toplevel); $this->smarty->assign('secondlevel', $secondlevel); if (empty($checkUser) && empty($purchase) && empty($sku) && empty($start) && empty($end) && $status == 200) { $where = "where is_delete=0"; } else { if (!empty($checkUser)) { $where[] = "tallyUserId='{$checkUser}'"; $this->smarty->assign("tallyUserId", $checkUser); } if (!empty($purchase)) { $where[] = "purchaseId='{$purchase}'"; $this->smarty->assign("purchase", $purchase); } if (!empty($sku)) { $where[] = "sku = '{$sku}'"; $this->smarty->assign("sku", $sku); } if ($status != 200) { $where[] = "entryStatus = '{$status}'"; $this->smarty->assign("status", $status); } if (!empty($start) && !empty($end)) { $starttime = strtotime($start); $endtime = strtotime($end); $where[] = "(entryTime between {$starttime} and {$endtime})"; $this->smarty->assign("start", $start); $this->smarty->assign("end", $end); } elseif (!empty($start) && empty($end)) { $starttime = strtotime($start); $where[] = "entryTime >{$starttime}"; $this->smarty->assign("start", $start); } elseif (empty($start) && !empty($end)) { $endtime = strtotime($end); $where[] = "entryTime < {$endtime}"; $this->smarty->assign("end", $end); } $where = implode(" AND ", $where); $where = " where is_delete=0 and " . $where; } $where = $where . ' order by id desc'; $nums = packageCheckModel::getTotalNums($where); $pagesize = 50; //$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)); } $userList = packageCheckModel::selectUser(); $usermodel = UserModel::getInstance(); foreach ($lists as $key => $list) { //到货库存 $sku_arrival = OmAvailableModel::getTNameList("wh_sku_location", "arrivalInventory", "where sku='{$list['sku']}'"); $lists[$key]['arrivalInventory'] = $sku_arrival[0]['arrivalInventory']; //获取原始点货数量 $before_num = OmAvailableModel::getTNameList("wh_tallying_adjustment", "beforeNum", "where tallyListId='{$list['id']}' order by id asc limit 1"); $lists[$key]['before_num'] = empty($before_num) ? $list['num'] : $before_num[0]['beforeNum']; } //点货员 $tallyUser = $usermodel->getGlobalUserLists('global_user_id,global_user_name', "where a.global_user_job=209", '', ''); $this->smarty->assign('tallyUser', $tallyUser); //采购员 $purchaseList = CommonModel::getPurchaseList(); $this->smarty->assign('purchaseList', $purchaseList); /** 添加贴标时间、QC检测时间、上架时间 add by GARY(yym)**/ $this->smarty->registerPlugin('function', 'getSkuTime', 'getSkuTime'); //$this->smarty->registerPlugin('function','getSkuInputTime','getSkuInputTime'); /** end**/ $toptitle = '点货清单列表'; //顶部链接 $this->smarty->assign('toptitle', $toptitle); $this->smarty->assign('pagestr', $pagestr); $this->smarty->assign("lists", $lists); $this->smarty->display('packageCheckList1.htm'); }