query($sql); $rowset = $result -> fetchAll(PDO::FETCH_ASSOC); $result -> closeCursor(); if(!isset($rowset[0]["CREATE_TIME"])){ echo json_encode(array('code'=>1,'info'=>'未知订单号')); die; } $CREATE_TIME = $rowset[0]["CREATE_TIME"]; $NOW_TIME = time(); $CREATE_TIME = strtotime($CREATE_TIME); $CREATE_TIME = $CREATE_TIME + 600; //时间差 $time_left = $CREATE_TIME - $NOW_TIME; //去程订单详情 $go_list = array(); //返程订单详情 $back_list = array(); //判断是否存在往返订单 //单程票 $sql = "SELECT ORDER_ID,ORDER_DESCRIPTION,ORDER_STATUS,ORDER_PRICE,CUSTOMER_MOBILE,CUSTOMER_NAME FROM ORDER_MAIN WHERE CANCEL_FLAG=0 AND PARENT_ORDER_ID=0 AND ORDER_ID=" . $ORDER_ID; $result = $pdo -> query($sql); $rowset = $result -> fetchAll(PDO::FETCH_ASSOC); $result -> closeCursor(); // echo $is_back; // echo $main_to_order_id; // echo $main_back_order_id; //var_dump($rowset); $contact_name = $rowset[0]["CUSTOMER_NAME"]; //联系人姓名 $contact_mobile = $rowset[0]["CUSTOMER_MOBILE"]; //联系人电话 $go_ORDER_DESCRIPTION = $rowset[0]["ORDER_DESCRIPTION"]; //去程订单详情 $temp_temp = explode(',', $go_ORDER_DESCRIPTION); $seat_type = str_replace("票", "", $temp_temp[0]); //座位类型 $seat_num = str_replace("|", "", $temp_temp[2]); //座位数量 $total_price = $rowset[0]["ORDER_PRICE"]; //订单总价 $order_status = $rowset[0]["ORDER_STATUS"]; //订单状态 //查询去程子订单 $sql = "SELECT CUSTOMER_MEMO,PROD_START_STATION_AREA_NAME,PROD_START_STATION_RES_NAME,PROD_END_STATION_AREA_NAME,PROD_END_STATION_RES_NAME,PROD_START_STATION_DATE,PROD_START_STATION_TIME,ORDER_PRICE FROM ORDER_MAIN WHERE CANCEL_FLAG=0 AND PARENT_ORDER_ID=" . $ORDER_ID; $result = $pdo -> query($sql); $rowset = $result -> fetchAll(PDO::FETCH_ASSOC); $result -> closeCursor(); $rowset = $rowset[0]; // var_dump($rowset); $start_date = $rowset["PROD_START_STATION_DATE"]; //出发日期 $start_time = $rowset["PROD_START_STATION_TIME"]; //出发时间 $start_area_name = $rowset["PROD_START_STATION_AREA_NAME"]; //出发地区名 $start_res_name = $rowset["PROD_START_STATION_RES_NAME"]; //出发res名字 $end_area_name = $rowset["PROD_END_STATION_AREA_NAME"]; $end_res_name = $rowset["PROD_END_STATION_RES_NAME"]; $price = $rowset["ORDER_PRICE"]; //单价 $str_cus_memo = $rowset["CUSTOMER_MEMO"]; //乘客信息 $arr_str_cus_memo = explode('/', $str_cus_memo); //var_dump($arr_str_cus_memo); $customer_info = array(); $i = 0; foreach ($arr_str_cus_memo as $temp) { if (!is_null($temp)) { $temp_temp = explode('*', $temp); $customer_info[$i]["name"] = $temp_temp[0]; $customer_info[$i]["id_num"] = isset($temp_temp[1])?$temp_temp[1]:''; $len = 4; $id_num_f = substr($temp_temp[1], 0, $len); $id_num_l = substr($temp_temp[1], 14, $len); $id_num_encrypt = $id_num_f . "**********" . $id_num_l; $customer_info[$i]["id_num_encrypt"] = $id_num_encrypt; $i++; } } //var_dump($customer_info); $go_list["contact_name"] = $contact_name; $go_list["contact_mobile"] = $contact_mobile; $go_list["seat_type"] = $seat_type; $go_list["seat_num"] = $seat_num; $go_list["total_price"] = (int)$total_price; $go_list["order_status"] = $order_status; $go_list["start_date"] = $start_date; $go_list["start_time"] = $start_time; $go_list["start_area_name"] = $start_area_name; $go_list["start_res_name"] = $start_res_name; $go_list["end_area_name"] = $end_area_name; $go_list["end_res_name"] = $end_res_name; $go_list["price"] = (int)$price; $go_list["customer_info"] = $customer_info; $go_list["time_left"] = $time_left; $go_list["order_id"]= $ORDER_ID; if($order_status==145){ $go_list["order_status_info"]="未支付"; $go_list["can_do"] = "1"; $back_list["order_status"] = "145"; }else if($order_status==146){ $go_list["order_status_info"]="已出票"; $temp_now_time=time(); $temp_start_time=$start_date." ".$start_time; $temp_start_time=strtotime($temp_start_time); if(($temp_start_time-$temp_now_time)<1800){ $go_list["can_do"] = "0"; }else{ $go_list["can_do"] = "1"; } $back_list["order_status"] = "146"; }else if($order_status==147){ $go_list["order_status_info"]="已完成"; $go_list["can_do"] = "1"; $back_list["order_status"] = "147"; }else{ $go_list["order_status_info"]="已取消"; $go_list["can_do"] = "1"; $back_list["order_status"] = "148"; } $jason_array = array(); $jason_array["code"] = "0"; $jason_array["info"] = "返回成功"; $jason_array["go_list"] = $go_list; echo json_encode($jason_array); exit(); } else { //输入order_id为空 $jason_array = array(); $jason_array["code"] = "1"; $jason_array["info"] = "没有输入"; $jason_array["go_list"] = ""; $jason_array["back_list"] = ""; $jason_array["order_id"] = ""; $jason_array["is_back"] = 0; $jason_array["time_left"] = 0; echo json_encode($jason_array); exit(); }