function order_list() { $filter['sdate'] = empty($_REQUEST['sdate']) ? '' : trim($_REQUEST['sdate']); $filter['order_sn'] = empty($_REQUEST['order_sn']) ? '' : trim($_REQUEST['order_sn']); $filter['turn'] = empty($_REQUEST['turn']) ? 0 : intval($_REQUEST['turn']); $filter['station'] = empty($_REQUEST['station']) ? '' : intval($_REQUEST['station']); $filter['employee'] = empty($_REQUEST['employee']) ? '' : intval($_REQUEST['employee']); $filter['pack_no'] = empty($_REQUEST['pack_no']) ? '' : trim($_REQUEST['pack_no']); $filter['print_sn'] = empty($_REQUEST['print_sn']) ? '' : trim($_REQUEST['print_sn']); $filter['status'] = empty($_REQUEST['status']) ? '' : intval($_REQUEST['status']); $filter['orderstatus'] = empty($_REQUEST['orderstatus']) ? '' : intval($_REQUEST['orderstatus']); $filter['page'] = empty($_REQUEST['page']) || intval($_REQUEST['page']) <= 0 ? 1 : intval($_REQUEST['page']); $where = " where o.country " . $GLOBALS['city_code'] . " "; if ($filter['sdate']) { $where .= " and best_time > '" . $filter['sdate'] . "' and best_time < '" . $filter['sdate'] . " 23:30:00'"; } if ($filter['turn']) { $where .= " and c.turn = '" . $filter['turn'] . "' "; } if ($filter['employee']) { $where .= " and employee_id = '" . $filter['employee'] . "' "; } if ($filter['pack_no']) { $where .= " and d.route_name = '" . $filter['pack_no'] . "' "; } if ($filter['status']) { $where .= " and a.status = '" . $filter['status'] . "' "; } if ($filter['orderstatus'] == 0) { $where .= " and order_status =0 "; } if ($filter['orderstatus'] == 1) { $where .= " and order_status =1 "; } if ($filter['orderstatus'] == 2) { $where .= " and order_status =2 "; } if ($filter['orderstatus'] == 3) { $where .= " and order_status =3 "; } if ($filter['orderstatus'] == 4) { $where .= " and order_status =4 "; } if ($filter['order_sn']) { if (str_len($filter['order_sn']) == 5) { $where .= " and order_sn like '%" . $filter['order_sn'] . "' "; } else { $where = " where order_sn = '" . $filter['order_sn'] . "' "; } } if ($filter['station'] && $filter['station'] != 100) { $where .= " and d.station_id = '" . $filter['station'] . "' "; } if ($filter['print_sn']) { $where .= "and p.print_sn = '" . $filter['print_sn'] . "' "; } if ($filter['station'] == 100) { $where .= " and shipping_station_name is null "; } if ($filter['sort_by'] == 'shipping_station_name') { $orderby = "shipping_pack_no,best_time "; } elseif ($filter['sort_by'] == 'shipping_pack_no') { $orderby = "shipping_station_name, best_time "; } else { $orderby = "shipping_station_name, shipping_pack_no "; } if ($_SESSION['station'] > 0) { $where .= " and d.station_id = '" . $_SESSION['station'] . "' "; } $size = 30; $sql = "select count(1) " . "from order_delivery as a " . "left join ecs_order_info as o on a.order_id=o.order_id " . "left join order_dispatch as c on a.order_id=c.order_id " . "left join print_log_x as p on a.order_id=p.order_id " . "left join hr_employees as h on a.employee_id=h.id " . "left join ship_route as d on c.route_id=d.route_id " . "left join ship_station as s on d.station_id=s.station_id " . $where; $record_count = $GLOBALS['db_read']->getOne($sql); $page_count = $record_count > 0 ? ceil($record_count / $size) : 1; $sql = "select a.order_id,p.print_sn,o.order_sn,o.city,o.address,o.best_time,c.*,d.*,s.station_name,s.station_code,a.status,h.name as employee_name " . "from order_delivery as a " . "left join ecs_order_info as o on a.order_id=o.order_id " . "left join order_dispatch as c on a.order_id=c.order_id " . "left join print_log_x as p on a.order_id=p.order_id " . "left join hr_employees as h on a.employee_id=h.id " . "left join ship_route as d on c.route_id=d.route_id " . "left join ship_station as s on d.station_id=s.station_id " . $where . "order by d.route_name,c.turn,best_time " . "LIMIT " . ($filter['page'] - 1) * $size . ",{$size}"; $res = $GLOBALS['db_read']->GetAll($sql); $sql = "SELECT a.sender,b.name FROM delivery_plan as a,hr_employees as b WHERE a.sender=b.id and bdate = '" . $filter['sdate'] . "' \r\n\t\t\tand a.station_id = '" . $filter['station'] . "'"; $res2 = $GLOBALS['db_read']->GetAll($sql); foreach ($res as $key => $val) { $res[$key]['i'] = $key + 1; $res[$key]['address'] = region_name($val['city']) . ' ' . $val['address']; } $arr = array('orders' => $res, 'filter' => $filter, 'page_count' => $page_count, 'record_count' => $record_count, 'senders' => $res2); return $arr; }
function order_list() { $os[0] = '未确认'; $os[1] = '已确认'; $os[2] = '已取消'; $os[3] = '无效'; $os[4] = '退货'; $ps[0] = '未付款'; $ps[1] = '付款中'; $ps[2] = '已付款'; $city_arr = $_SESSION['city_arr']; $city_code = array_keys($city_arr); $filter['station'] = empty($_REQUEST['station']) ? '' : intval($_REQUEST['station']); $filter['turn'] = intval($_REQUEST['turn']); $filter['city'] = empty($_REQUEST['city']) ? $city_code[0] : intval($_REQUEST['city']); $filter['diao'] = trim($_REQUEST['diaodu']); $filter['bdate'] = empty($_REQUEST['bdate']) ? date('Y-m-d') : trim($_REQUEST['bdate']); $filter['status'] = empty($_REQUEST['order_status']) ? 1 : intval($_REQUEST['order_status']); $filter['prints'] = trim($_REQUEST['prints']); $filter['ordsn'] = trim($_REQUEST['order_sn']); $filter['page'] = empty($_REQUEST['page']) || intval($_REQUEST['page']) <= 0 ? 1 : intval($_REQUEST['page']); $size = $filter['psize'] = intval($_REQUEST['psize']); $where = "where o.order_status = " . $filter['status'] . " and d.status >0 "; if ($filter['turn']) { $where .= " and d.turn = " . $filter['turn']; } if ($filter['prints'] == 1) { $where .= " and c.ptime > 0 "; } if ($filter['prints'] == 2) { $where .= " and (c.ptime = '' or c.ptime is null) "; } if ($filter['city']) { $where .= " and o.country = " . $filter['city']; } if ($filter['bdate']) { $where .= " and o.best_time > '" . $filter['bdate'] . "' and o.best_time < '" . $filter['bdate'] . " 23:01:01' "; } if ($filter['ordsn']) { $where = " where o.order_sn = '" . $filter['ordsn'] . "' "; } if ($filter['station']) { $where .= " and s.station_id = '" . $filter['station'] . "' "; } /* $sql = "SELECT COUNT(*) FROM order_genid as a left join ecs_order_info AS o on a.order_id=o.order_id ". "left join order_dispatch as d on o.order_id=d.order_id left join print_log as c on o.order_id = c.order_id ". $where;*/ $sql = "SELECT COUNT(*) FROM order_genid as a left join ecs_order_info AS o on a.order_id=o.order_id left join order_dispatch as d on o.order_id=d.order_id left join print_log_x as c on o.order_id = c.order_id left join ship_route as r on d.route_id=r.route_id left join ship_station as s on r.station_id=s.station_id " . $where; $record_count = $GLOBALS['db_read']->getOne($sql); $page_count = $record_count > 0 ? ceil($record_count / $size) : 1; /*$sql = "select o.order_id,o.order_sn,o.order_status,o.orderman,o.ordertel,o.consignee,o.mobile,o.best_time,o.order_amount,o.kfgh,o.add_time,o.pay_status, " . "o.country,o.city,o.district,o.address,c.ptime,c.print_sn,c.pt,c.stime,group_concat(g.goods_name) as goods ". "from order_genid as a left join ecs_order_info as o on a.order_id=o.order_id ". "left join ecs_order_goods as g on o.order_id=g.order_id ". "left join order_dispatch as d on o.order_id=d.order_id ". "left join print_log as c on o.order_id = c.order_id ".$where. "and g.goods_price>40 group by o.order_id order by o.best_time ". "LIMIT " . ($filter['page'] - 1) * $size . ",$size"; */ $sql = "select o.order_id,o.order_sn,o.order_status,o.orderman,o.ordertel,o.consignee,o.mobile,o.best_time,o.order_amount,o.kfgh,o.add_time,o.pay_status, " . "o.country,o.city,o.district,o.address,c.ptime,c.print_sn,c.pt,c.stime,group_concat(g.goods_name) as goods " . "from order_genid as a left join ecs_order_info as o on a.order_id=o.order_id " . "left join ecs_order_goods as g on o.order_id=g.order_id " . "left join order_dispatch as d on o.order_id=d.order_id " . "left join print_log_x as c on o.order_id = c.order_id " . "left join ship_route as r on d.route_id=r.route_id " . "left join ship_station as s on r.station_id=s.station_id " . $where . "and g.goods_price>40 group by o.order_id order by o.best_time " . "LIMIT " . ($filter['page'] - 1) * $size . ",{$size}"; //echo $sql; $rs = $GLOBALS['db_read']->getAll($sql); foreach ($rs as $key => $val) { $sql = "select status from order_dispatch where order_id=" . $val['order_id']; $rs[$key]['status'] = $GLOBALS['db_read']->getOne($sql); $sql = "select b.route_name from order_dispatch as a,ship_route as b where a.route_id=b.route_id and a.order_id=" . $val['order_id']; $rs[$key]['route_name'] = $GLOBALS['db_read']->getOne($sql); $rs[$key]['add_time'] = date('Y-m-d H:i', $val['add_time']); $rs[$key]['best_time'] = substr($val['best_time'], 0, 16); $rs[$key]['order_status'] = $os[$val['order_status']] . ',' . $ps[$val['pay_status']]; $rs[$key]['i'] = $key + 1; $rs[$key]['address'] = region_name($val['city']) . region_name($val['district']) . $val['address']; if ($filter['ordsn']) { $filter['bdate'] = substr($val['best_time'], 0, 10); } } //print_r($filter); $arr = array('list' => $rs, 'filter' => $filter, 'page_count' => $page_count, 'record_count' => $record_count, 'cake_count' => $n); return $arr; }
function order_list() { $filter['status'] = empty($_REQUEST['status']) ? 0 : intval($_REQUEST['status']); $filter['otatus'] = intval($_REQUEST['otatus']); $filter['sdate'] = empty($_REQUEST['sdate']) ? '' : trim($_REQUEST['sdate']); $filter['edate'] = empty($_REQUEST['edate']) ? '' : trim($_REQUEST['edate']); $filter['order_sn'] = empty($_REQUEST['order_sn']) ? '' : trim($_REQUEST['order_sn']); $filter['turn'] = empty($_REQUEST['turn']) ? 0 : intval($_REQUEST['turn']); $filter['station'] = empty($_REQUEST['station']) ? '' : intval($_REQUEST['station']); $filter['route_id'] = empty($_REQUEST['route_s']) ? '' : intval($_REQUEST['route_s']); $filter['page'] = empty($_REQUEST['page']) || intval($_REQUEST['page']) <= 0 ? 1 : intval($_REQUEST['page']); $filter['big_goods'] = intval($_REQUEST['big_goods']); $filter['sort_by'] = empty($_REQUEST['sort_by']) ? 'best_time' : trim($_REQUEST['sort_by']); $filter['sort_order'] = empty($_REQUEST['sort_order']) ? 'ASC' : trim($_REQUEST['sort_order']); $filter['city'] = empty($_REQUEST['city']) ? '' : trim($_REQUEST['city']); $where = " where country " . $GLOBALS['city_code'] . " "; $join = ''; if ($filter['sdate']) { $where .= " and best_time > '" . $filter['sdate'] . "' "; } if ($filter['edate']) { $where .= " and best_time < '" . $filter['edate'] . " 23:30:30' "; } if ($filter['order_sn']) { $where .= " and right(a.order_id,5) ='" . $filter['order_sn'] . "' "; } if ($filter['status'] == 1) { $where .= " and status =0"; } if ($filter['status'] == 2) { $where .= " and status =1"; } if ($filter['otatus'] < 9) { $where .= " and order_status = {$filter['otatus']}"; } if ($filter['turn']) { $where .= " and turn = '" . $filter['turn'] . "' "; } if ($filter['city']) { $where .= " and country = '" . $filter['city'] . "' "; } if ($filter['station'] && $filter['station'] != 100) { $where .= " and s.station_id = '" . $filter['station'] . "' "; } if ($filter['station'] == 100) { $where .= " and c.route_id =0 "; } if ($filter['route_id']) { $where .= " and c.route_id ='" . $filter['route_id'] . "' "; } if ($filter['sort_by'] == 'shipping_station_name') { $orderby = " order by s.station_code desc "; } else { $orderby = " "; } if ($filter['big_goods']) { $join .= " left join ecs_order_goods as g on g.order_id=a.order_id "; $where .= " and g.goods_price > 1000 "; } $size = 20; $sql = "select count(1) " . "from order_genid as a " . "left join ecs_order_info as o on a.order_id=o.order_id " . "left join order_dispatch as c on a.order_id=c.order_id " . "left join ship_route as d on c.route_id=d.route_id " . $join . "left join ship_station as s on d.station_id=s.station_id " . $where; $record_count = $GLOBALS['db_read']->getOne($sql); $page_count = $record_count > 0 ? ceil($record_count / $size) : 1; $sql = "select a.order_id,o.order_sn,o.city,o.address,o.best_time,c.*,d.*,s.station_name,s.station_code " . "from order_genid as a " . "left join ecs_order_info as o on a.order_id=o.order_id " . "left join order_dispatch as c on a.order_id=c.order_id " . "left join ship_route as d on c.route_id=d.route_id " . $join . "left join ship_station as s on d.station_id=s.station_id " . $where . $orderby . " LIMIT " . ($filter['page'] - 1) * $size . ",{$size}"; $res = $GLOBALS['db_read']->GetAll($sql); foreach ($res as $key => $val) { $sql = "select count(1) from ecs_order_goods where goods_price>1000 and order_id=" . $val['order_id']; $res[$key]['big'] = $GLOBALS['db_read']->getOne($sql) ? 1 : 0; $res[$key]['address'] = region_name($val['city']) . ' ' . $val['address']; $res[$key]['i'] = $key + 1; $res[$key]['sname'] = admin_name($val['admin']); } $arr = array('orders' => $res, 'filter' => $filter, 'page_count' => $page_count, 'record_count' => $record_count); return $arr; }
function order_detail($order_id) { $sql = "select * " . "from ecs_order_info as o " . "where o.order_id = '{$order_id}' and o.order_id >0 "; $res = $GLOBALS['db_read']->getRow($sql); //$res = $GLOBALS['db110']->getRow($sql); $res['add_date'] = date('Y-m-d H:i', $res['add_time']); $res['btime'] = substr($res['best_time'], 5, 11); $res['goods_amount'] = intval($res['goods_amount']); $res['fw_fee'] = intval($res['pay_fee'] + $res['shipping_fee']); $r = print_goods($order_id); $r = $r['fj_fee']; $res['fj_fee'] = $r; //附件费 //$res['fj_fee']=$res['pack_fee'];//附件费 $res['amount'] = floatval($res['order_amount'] + $res['money_paid']); $res['money_paid'] = intval($res['money_paid']); $res['address'] = region_name($res['country']) . region_name($res['city']) . $res['address']; //$res['wsts']=str_replace(chr(13),'',$res['wsts']); //$res['wsts']=str_replace(chr(10),'',$res['wsts']); $card_name = explode(";", $res['card_name']); array_pop($card_name); //生日牌标识 $card_m = explode(";", $res['card_message']); array_pop($card_m); //生日牌内容 //print_r($card_m); //print_r($card_name); $card_message = array(); //重新定义生日牌内容数组 foreach ($card_name as $key => $val) { if ($val == '中文') { //生日牌标识:中文 array_push($card_message, '生日快乐'); } elseif ($val == '英文') { //生日牌标识:英文 array_push($card_message, 'Happy Birthday'); } elseif ($val == '无') { //生日牌标识:无 array_push($card_message, '无'); } elseif ($val == '其它') { //生日牌标识:其他 foreach ($card_m as $k => $v) { if (!empty($v)) { if ($key == $k) { array_push($card_message, $card_m[$key]); } } } // array_push($card_message,$card_m[$key]); } } //print_r($card_message); foreach ($card_message as $k => $v) { if ($k != count($card_message) - 1) { $card_mess .= $v . ','; } else { $card_mess .= $v; } } //echo $card_mess; $res['card_mess'] = $card_mess; //生日牌内容字符串 return $res; }