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