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; }
} $order_count = $goods_count = 0; $html = ""; $bdate = trim($_REQUEST['sdate']); $order_sn_list = explode(',', $_REQUEST['order_id']); $num = 0; $cakesum_sn = '0'; foreach ($order_sn_list as $order_id) { if ($order_id != 'all') { $admin_id = $_SESSION['admin_id']; $group = $_SESSION['city_group']; $psn = get_print_sn($order_id, $bdate, $admin_id, $group, 1); //$psn = get_print_sn1($order_id,$bdate,$admin_id,$group,1); $res = pro_print1($order_id); //print_r($res); $result = print_goods($order_id); //$candle=$result['candle']; //$candle=$res[0]['candle']; $cakesum = $result['cakenum']; $cakesum_array = array(); for ($i = 1; $i <= $cakesum; $i++) { if ($i < 10) { $cakesum_array[] = '0' . $i; } else { $cakesum_array[] = $i; } //$cakesum_sn=$cakesum_array[$i]; //$smarty->assign('cake_sn', $cakesum_sn); } //echo $cakesum; // print_r($cakesum_array);
} $order_count = $goods_count = 0; $html = ''; $bdate = trim($_REQUEST['sdate']); $order_sn_list = explode(',', $_REQUEST['order_id']); $n = in_array('all', $order_sn_list) ? count($order_sn_list) - 2 : count($order_sn_list) - 1; foreach ($order_sn_list as $key => $order_id) { if ($order_id != 'all') { $admin_id = $_SESSION['admin_id']; $group = $_SESSION['city_group']; $psn = get_print_sn($order_id, $bdate, $admin_id, $group, 2); @($order = order_detail($order_id)); //print_r($order); @($pay = pay_info($order_id)); //print_r($pay); @($goods = print_goods($order_id)); //print_r($goods); $sql = "select a.turn,b.route_name from order_dispatch as a,ship_route as b where a.route_id=b.route_id and a.order_id=" . $order_id; $pack = $db_read->getRow($sql); //print_r($pack); //获取冰包号 $sql = "select ice_bag_num from order_ice_bag where order_id = {$order_id} limit 1"; $ice_bag_arr = $db_read->getAll($sql); //print_r($ice_bag_arr); $ice_bage_str = ''; foreach ($ice_bag_arr as $v) { if ($v['ice_bag_num'] < 10) { $v['ice_bag_num'] = '0' . $v['ice_bag_num']; } $ice_bage_str .= empty($ice_bage_str) ? $v['ice_bag_num'] : ',' . $v['ice_bag_num']; }