<?php
if (ALLOW_ORIGIN)
    header("Access-Control-Allow-Origin:*");
date_default_timezone_set('PRC'); 
//require_once '../../Common/Mysql.php';
$user_id =$_COOKIE['user_id'] ;//getUserId();
$back_order_id=0;
if($_POST || 1){
    $method = isset($_POST['iffirst']) ? $_POST['iffirst'] : "2";
    $order_id = isset($_POST['order_id']) ? $_POST['order_id'] : "204351";
    $ifback = "0";
   $to_order_id=$order_id;
        $pdo = conn();
        $sql_s = "select * from to_from where  to_orderid=".$order_id." or back_orderid=".$order_id;
        $result=$pdo->query($sql_s);
        $rowset = $result -> fetchAll(PDO::FETCH_ASSOC);
        if($rowset){
            $ifback=1;
        $to_order_id = $rowset[0]['to_orderid'];
        $back_order_id = $rowset[0]['back_orderid'];
        if ($method == "2") {
	$sql = "CALL SP_CANCEL_ORDER(" . 0 . "," . $to_order_id . ")";
	$result = $pdo -> query($sql);
        $sql = "CALL SP_CANCEL_ORDER(" . 0 . "," . $back_order_id . ")";
	$result = $pdo -> query($sql);
          
            if($list['to'] &&  Find($back_order_id)){
            $code = 0;
            $info = 'success';
            $massge = '成功';
            }
	$result -> closeCursor();
    }else{
        $list['to'] = Find($to_order_id);
        $time_cut = time()-strtotime($list['to']['run_date'].' '.$list['to']['run_time']);
        
        $list['back'] = Find($back_order_id);
        if($list['to'] &&  Find($back_order_id)){
            
        $code = 0;
        $info = 'success';
        $massge = '成功';
        $list = $list;
         if($time_cut<=1800){
             $code =1;
            $info = 'fail';
            $massge = '开车前30分钟禁止退票,请刷新页面确认时间';
            $list = "";
         }
        }else{
            $code =1;
            $info = 'fail';
            $massge = '失败';
            $list = "";
        }
        
        
    }
    $time_cut = time()-strtotime($list['to']['run_time']); ///时间在开场30分钟前可以退票
    }else{
        //单程情况
    if ($method == "2") {
	$pdo = conn();
	$sql = "CALL SP_CANCEL_ORDER(" . 0 . "," . $order_id . ")";
	$result = $pdo -> query($sql);
            $code = 0;
            $info = 'success';
            $massge = '订单已取消';
           
	$result -> closeCursor();
    }else{
        if($list = Find($order_id)){
        $code = 0;
        $info = 'success';
        $massge = '成功';
         
        $list = $list;
        $time_cut = time()-strtotime($list['run_date'].' '.$list['run_time']);
          if($time_cut<=1800){
             $code =1;
            $info = 'fail';
            $massge = '开车前30分钟禁止退票';
            $list = "";
         }
        }else{
            $code =1;
            $info = 'fail';
            $massge = '失败';
            $list = "";
        }
    }
     $time_cut = time()-strtotime($list['run_time']); ///时间在开场30分钟前可以退票   
    }
    
} else {
    $code =1;
    $info = 'fail';
    $massge = '失败';
    $list = "";
}
$json['ifback'] =$ifback;
$json['code'] = $code;
$json['info'] = $massge;
$json['order_id']=$to_order_id;
$json['back_order_id']=$back_order_id;


echo json_encode($json);
die;
function Find($order_id){
    $pdo=  conn();
        $sql = "select  order_description,order_price "
                . "from order_main "
                . "where order_id=".$order_id;
        $result=$pdo->query($sql);
        $rowset = $result -> fetchAll(PDO::FETCH_ASSOC);
        $order_price = $rowset[0];//订单总价格  订单票的数量
        $sql = "SELECT DISTINCT 
            order_description,parent_order_id,run_date,run_time,PROD_START_STATION_AREA_NAME,PROD_START_STATION_RES_NAME,PROD_END_STATION_AREA_NAME,PROD_END_STATION_RES_NAME  
            FROM `order_main` 
            where  PARENT_ORDER_ID=".$order_id;
        $result=$pdo->query($sql);
        $rowset = $result -> fetchAll(PDO::FETCH_ASSOC);
        $order_station = $rowset[0];//订单来往地址  订单时间 订单好
        if(empty($order_station))
            return false;
        $array_order_desc=array();

        $arr_temp = explode('|',$order_price['order_description']);
        $arr=array();
        foreach ($arr_temp as $k=>$v2) {
            if(!empty($v2))
            $array_order_desc[]=  explode (',', $v2);   //订单票  * 数量
        }  
        $list = array();  
        //上海（黄浦旅游集散站）    -      乌镇（西栅1号停车场）//反的数组
        $list['station'] = $order_station['PROD_START_STATION_AREA_NAME'].'('.$order_station['PROD_START_STATION_RES_NAME'].')'
                            .'-'.$order_station['PROD_END_STATION_AREA_NAME'].'('.$order_station['PROD_END_STATION_RES_NAME'].')';
        $list['start_station']=$order_station['PROD_START_STATION_AREA_NAME'];
        $list['end_station']=$order_station['PROD_END_STATION_AREA_NAME'];
        $list['start_res_name'] = $order_station['PROD_START_STATION_RES_NAME'];
         $list['end_res_name'] = $order_station['PROD_END_STATION_RES_NAME'];
         $list['run_date'] = $order_station['run_date'];
        $list['run_time'] = $order_station['run_date'].'  '.$order_station['run_time'];
         $list['count']=''; 
        foreach ($array_order_desc as $v){
            $list['count'] .= ' '.$v[0].' × '.$v[2];
        }
        $list['order_price'] = $order_price['order_price'];
        return $list;
}