public function view_getPendingProductsList() { if (!isset($_SESSION['userId'])) { //检测用户是否登陆 header('location:index.php?mod=login&act=index'); exit; } //$type = isset($_GET['type'])?$_GET['type']:''; $status = isset($_GET['status']) ? $_GET['status'] : ''; $pendingProductsAct = new PendingProductsAct(); $where = 'WHERE 1=1 '; $total = $pendingProductsAct->act_getPendingProductsCount($where); $num = 100; //每页显示的个数 $page = new Page($total, $num, '', 'CN'); $where .= "ORDER BY id " . $page->limit; $pendingProductsList = $pendingProductsAct->act_getPendingProductsList('*', $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)); } $navarr = array("<a href='index.php?mod=iqcInfo&act=iqcScanList'>IQC检测信息</a>", ">>", "IQC待定信息列表"); $this->smarty->assign('navarr', $navarr); $this->smarty->assign('module', 'IQC待定信息列表'); $this->smarty->assign('secnev', '3'); $this->smarty->assign("show_page", $show_page); $this->smarty->assign("status", $status); $this->smarty->assign('username', $_SESSION['userName']); $this->smarty->assign("pendingProductsList", $pendingProductsList ? $pendingProductsList : null); $this->smarty->display("pendingProducts.html"); }
public function view_getPendingProductsList() { if (!isset($_SESSION['sysUserId'])) { //检测用户是否登陆 header('location:index.php?mod=login&act=index'); exit; } //$type = isset($_GET['type'])?$_GET['type']:''; $status = isset($_GET['status']) ? $_GET['status'] : ''; $state = isset($_GET['state']) ? post_check($_GET['state']) : ''; $this->smarty->assign('state', $state); $pendingProductsAct = new PendingProductsAct(); $where = 'WHERE 1=1 AND is_delete=0 '; $startTime = date("Y-m-d H:i:s", time()); $endTime = date("Y-m-d H:i:s", time()); $sku = ''; if (isset($_POST) && !empty($_POST)) { $sku = trim($_POST['sku']); if (!empty($sku)) { $where .= " AND sku = '{$sku}' "; } if (!empty($_POST['startTime']) && !empty($_POST['endTime'])) { $start_time = strtotime($_POST['startTime']); $end_time = strtotime($_POST['endTime']); $where .= " AND startTime BETWEEN {$start_time} AND {$end_time} "; $startTime = $_POST['startTime']; $endTime = $_POST['endTime']; } } $total = $pendingProductsAct->act_getPendingProductsCount($where); $num = 100; //每页显示的个数 $page = new Page($total, $num, '', 'CN'); $where .= "ORDER BY id " . $page->limit; $pendingProductsList = $pendingProductsAct->act_getPendingProductsList('*', $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)); } $navarr = array("<a href='index.php?mod=iqcInfo&act=iqcScanList'>QC检测信息</a>", ">>", "QC待定信息列表"); $this->smarty->assign('navarr', $navarr); $this->smarty->assign('module', 'QC待定信息列表'); $this->smarty->assign('secnev', '3'); $this->smarty->assign("show_page", $show_page); $this->smarty->assign('sku', $sku); $this->smarty->assign('startTime', $startTime); $this->smarty->assign('endTime', $endTime); $this->smarty->assign("status", $status); $this->smarty->assign('username', $_SESSION['userName']); $this->smarty->assign("pendingProductsList", $pendingProductsList ? $pendingProductsList : null); $this->smarty->display("pendingProducts.htm"); }