public function view_showOrderList() { $pageSize = 50; //一页显示多少个备货单 $where = ''; //where条件语句 $status = isset($_GET['status']) ? trim($_GET['status']) : NULL; //备货单状态 if (!empty($status) && $status !== 'NULL') { $where .= " AND a.status='{$status}' "; } $orderSn = isset($_GET['ordersn']) ? trim($_GET['ordersn']) : NULL; //备货单号 $orderSn = mysql_real_escape_string($orderSn); if (!empty($orderSn)) { $where .= " AND a.ordersn='{$orderSn}' "; } $sku = isset($_GET['sku']) ? trim($_GET['sku']) : NULL; //料号 $sku = mysql_real_escape_string($sku); if (!empty($sku)) { $where .= " AND b.sku = '{$sku}' "; } $con = ''; $skustatus = isset($_GET['skustatus']) ? trim($_GET['skustatus']) : NULL; //料号 if (!empty($skustatus)) { if ($skustatus == 1) { $con .= " AND scantime = 0 "; $where .= " AND a.status NOT IN(3,4) "; } else { if ($skustatus == 2) { $con .= " AND scantime != 0 "; } } } $startTime = isset($_GET['startTime']) ? trim($_GET['startTime']) : NULL; //开始时间 if (!empty($startTime)) { $startTimeStamp = strtotime($startTime); $where .= " and a.createtime>{$startTimeStamp} "; } $endTime = isset($_GET['endTime']) ? trim($_GET['endTime']) : NULL; //结束时间 if (!empty($endTime)) { $endTimeStamp = strtotime($endTime); $where .= " and a.createtime<{$endTimeStamp} "; } $preGoodObj = new PreGoodsOrdderManageModel(); $count = $preGoodObj->getBackOrderInfoCount($where); //culOrderCount($where); if (FALSE === $count) { //计算数量出错 header('location:index.php?mod=owGoodsReplenishManage&act=showOrderList'); exit; } $pageObj = new Page($count, $pageSize); $orderInfoList = $preGoodObj->getBackOrderInfo($where . $pageObj->limit); //getOrderListInfo($where.$pageObj->limit); foreach ($orderInfoList as &$order) { $order['createTimeStr'] = empty($order['createtime']) ? '' : date('Y-m-d H:i:s', $order['createtime']); $order['synctimeStr'] = empty($order['synctime']) ? '' : date('Y-m-d H:i:s', $order['synctime']); $order['statusStr'] = PreGoodsOrdderManageModel::statusCodeToStr($order['status']); $skuDetail = $preGoodObj->getSKUDetail($order['id'], $con); $order['ownerName'] = getUserNameById($order['owner']); foreach ($skuDetail as &$row) { $row['scantime'] = empty($row['scantime']) ? '未配货' : date('Y-m-d H:i:s', $row['scantime']); $row['userName'] = empty($row['scanuser']) ? '' : getUserNameById($row['scanuser']); } $order['skulist'] = $skuDetail; } if ($count > $pageSize) { $pagestr = $pageObj->fpage(array(0, 2, 3, 4, 5, 6, 7, 8, 9)); } else { $pagestr = $pageObj->fpage(array(0, 2, 3)); } $navlist = array(array('url' => '', 'title' => '海外仓补货'), array('url' => '', 'title' => '海外仓备货单')); $toplevel = 2; //顶层菜单 $this->smarty->assign('toplevel', $toplevel); $secondlevel = '214'; //当前的二级菜单 $this->smarty->assign('navlist', $navlist); $this->smarty->assign('secondlevel', $secondlevel); $this->smarty->assign('orderSn', $orderSn); $this->smarty->assign('status', $status); $this->smarty->assign('sku', $sku); $this->smarty->assign('skustatus', $skustatus); $this->smarty->assign('third', 1); $this->smarty->assign('pagestr', $pagestr); $this->smarty->assign('orderList', $orderInfoList); $this->smarty->display('pregoodsorderlist.htm'); }