<?php
/*
 Author:XM
 Update:Redstop
 Compeny:Spiders Travel
 Descript:添加录入订单时的备注
 */
define( "BASE_TICKET_URL", "http://api.zhizhuchuxing.com/api1.0/ticket.php?orderid=" );

require_once __DIR__.'/../st-xm/Common/Mysql.php';
require_once __DIR__.'/../st-xm/Common/sinaAPI.php';

$return_array = array();
$pdo=conn();
$order_id = isset($_POST['order_id']) ? $_POST['order_id'] : false;
if( $order_id == false ) {
    $return_array["code"] = -1;
    $return_array["info"] = "无效订单号";
    echo json_encode($return_array);
    exit();
}
send_msg($order_id);
$return_array["code"] = 0;
$return_array["info"] = "发送成功";
echo json_encode($return_array);
exit();

//发短信
function send_msg($ORDER_ID) {
    $send_pdo = conn();
    $order_id = $ORDER_ID;
    $res_content = get_msg_info($order_id);
    if( false == $res_content ) {
        return false;
    }
    //$url = BASE_TICKET_URL.$order_id;
    //$short_url = sinaShortenUrl(filterUrl($url));      //根据传入的长网址生产短网址

    $name = $res_content[0];
    $tel = $res_content[1];
    $content = $res_content[2];
    $response=null;
    $send_success="-100";		// 默认-100
    writeLog("短信模板内容：".$name."tel".$tel."【" . $content . "】");
    if($tel!="-1"){
        $send_success="-90";		// 说明手机号不是-1
        $response = sendTelMessage($tel, $name, $content, $order_id);
        writeLog(json_encode($response));
    }else{
        $send_success="-1";		// 说明手机号为-1
        writeLog('send_msg==tel==='.$tel."：内容：＝＝》".$content);
    }
    $comment_type = 0;
    $comment_text = "";

    if($response!=null){
        $send_success=(int)$response;
    }

    $sql1 = "CALL HT_ADD_MSG_COMMENT(2,'addmsg'," . $order_id . "," . $comment_type . ",'" . $comment_text . "','" . $tel . "','" . $content . "','" . date("Y-m-d H:i:s") . "',{$send_success})";
    $result1 = $send_pdo -> query($sql1);
    $rowset1 = $result1 -> fetchAll(PDO::FETCH_ASSOC);
    $result1 -> closeCursor();
    writeLog("hotel_order_status.php HT_ADD_MSG_COMMENT()::" . $sql1);
}

//..短信模板-改为17：30后OK，当天下单也OK
function get_msg_info($ORDER_ID) {
    $not_send_prod = array(451023,451024,451025,451026,451027,451028);
    $msg_pdo = conn();
    $msg_sql = "CALL SP_GET_MESSAGE_TEMPLATE('" . $ORDER_ID . "')";
    $content = '';
    if (is_object($msg_pdo)) {
        $msg_result = $msg_pdo -> query($msg_sql);
        $i = 1;
        $data = array();
        if ($msg_result) {
            $data['code'] = "0";
            $data['info'] = "";
            do {
                $row = $msg_result -> fetchAll(PDO::FETCH_ASSOC);
                if ($i == 1) {
                    $data['seat'] = isset($row) ? $row : array();
                } else if ($i == 2) {
                    $data['run_info'] = isset($row) ? $row : array();
                } else if ($i == 3) {
                    $data['driver'] = isset($row) ? $row : array();
                } else if($i==4){
                    $data['dsn_prod']=isset($row) ? $row : array();
                }else if($i==5){
                    $data['zhou_su_prod']=isset($row) ? $row : array();
                }
                $i++;
            } while($msg_result->nextRowset());
        }
        $json_obj = json_decode(json_encode($data), TRUE);
        $seat = isset($json_obj['seat'][0]) ? $json_obj['seat'][0] : array();
        $run_info = isset($json_obj['run_info'][0]) ? $json_obj['run_info'][0] : array();
        $driver = isset($json_obj['driver'][0]) ? $json_obj['driver'][0] : array();
        $dsn_prod = isset($json_obj['dsn_prod'])?$json_obj['dsn_prod']:array();
        $zhou_su_prod=isset($json_obj['zhou_su_prod'])?$json_obj['zhou_su_prod']:array();
        $bus_res_id = isset($json_obj['driver'][0]) ? $json_obj['driver'][0]["bus_res_id"] : 0;
        if (in_array($run_info['parent_prod_id'], $not_send_prod)) {
            return false;
        }
        // 得到明天的时间
        date_default_timezone_set('PRC');
        //解决时区问题
        $tomorrow = date("Y-m-d", strtotime("+1 day"));
        $now_time = date('H:i:s', time());
        //判断当前时间是否在17:30:00之后
        $cur_date = date('Y-m-d', time());
        //迪士尼特殊情况parent_prod_id
        $dsn_arr_prod = array(); //用来保存迪士尼产品的prod_id
        foreach($dsn_prod as $temp){
            $dsn_arr_prod[]=$temp['prod_id'];
        }

        $zhou_su_arr_prod = array();
        foreach($zhou_su_prod as $temp){
            $zhou_su_arr_prod[]=$temp['prod_id'];
        }
        $short_url = false;
        $ticket_url = TICKET_QR_URL.$ORDER_ID;
        $short_url = sinaShortenUrl($ticket_url);
        $extra_message = "";
        if( $short_url != false ) {
            $extra_message = "您的电子车票链接 {$short_url} ，请在上车前点开，扫码乘车。";
        }

        $new_message_array5 = array(451440,451441);
        $new_message_array6 = array(448780,450008,448781);

        if( in_array( $run_info['parent_prod_id'], $new_message_array5 ) ) {
            $content = "订单号{订单号}，{出发日期} {出发时间}{上车站点}—{目的地}标准票{张数}张预定成功。发车前一天19点会短信通知您车牌号及司机电话，如未收到短信请拨打客服电话021-33280519。";
        } else if( in_array( $run_info['parent_prod_id'], $new_message_array6 ) ) {
            $content = "订单号{订单号}，{出发日期} {出发时间}{上车站点}—{目的地}标准票{张数}张预定成功。发车前一天19点会短信通知您乘车信息，如未收到短信请拨打客服电话021-33280519。";
        } else if (($now_time > "18:30:00" && $run_info['start_date'] == $tomorrow) || $cur_date == $run_info['start_date']) {//17：30之后的订单或者下单时间为今天出行为今天下午  发送短信模板
            $content = "订单号{订单号}，{出发地}—{目的地}标准票{张数}张将于{出发日期} {出发时间}准点发车。车牌号{车牌号}，司机电话{司机姓司机电话}，请提前10分钟抵达上车地点：{上车站点详细地址}并点开电子车票 {$short_url} 进行验票。如有疑问请拨打客服电话021-33280519。";
        } else {
            $content = "订单号{订单号}，{出发日期} {出发时间}{出发地}—{目的地}标准票{张数}张预定成功。发车前一天19点会短信通知您车牌号及司机电话，如未收到短信请拨打客服电话021-33280519。";
        }
        $new_message_array3 = array(450517,450522);
        if( in_array( $run_info['parent_prod_id'], $new_message_array3 ) ) {
            if( $run_info['parent_prod_id'] == 450517 ) {
                $address_txt = "上车地点：吴山广场西侧河坊巷8号（吴山广场旅游集散中心候车室）； 上车方式：请至吴山广场旅游集散中心候车室服务台，凭预定姓名和手机号码上车。";
            } else {
                $address_txt = "上车地点：普陀城北长途客运中心；取票方式：请提前到达（学运路18号）普陀城北长途客运中心候车大厅服务台报预订名字和电话取票。";
            }
            $content = "您已成功预定{出发日期} {出发时间} {出发地}-{目的地}汽车票{张数}张（请最晚提前10分钟到达）。{$address_txt}紧急电话：15888866564。";
        }
        $new_message_array4 = array(450588,450589);
        if( in_array( $run_info['parent_prod_id'], $new_message_array4 ) ) {
            $content .= "紧急联系电话：18100158199。";
        }
        $new_message_array5 = array(451437,451438);
        if( in_array( $run_info['parent_prod_id'], $new_message_array5 ) ) {
            $content .= "司机会提前与您联系，如有疑问，请联系021-33280578 。";
        }

        if ($seat) {
            $seat_x = isset($seat['seat_x']) ? $seat['seat_x'] : "";
            $seat_y = isset($seat['seat_y']) ? $seat['seat_y'] : "";
            $seat_name = isset($seat['seat_name']) ? $seat['seat_name'] : "";
            $order_main_id = isset($seat['order_main_id']) ? $seat['order_main_id'] : "";
        } else {

        }
        if ($run_info) {
            $order_count = $run_info['order_count'];
            $start_date = $run_info['start_date'];
            $start_time = $run_info['start_time'];
            $parent_order_id = $run_info['parent_order_id'];
            $end_date = $run_info['end_date'];
            $start_area = $run_info['start_area'];
            $end_area = $run_info['end_area'];
            $res_name = $run_info['res_name'];
            $parent_prod_id = $run_info['parent_prod_id'];
            $prod_name = $run_info['prod_name'];
            $prod_name = "标准票";
            $customer_name = $run_info['customer_name'];
            $customer_mobile = $run_info['customer_mobile'];
            $start_station_address = $run_info['start_station_address'];
            $start_end_date = $start_date . "," . $start_time;
            if( $parent_prod_id == 450504 && $start_date >= "2017-01-27" && $start_date <= "2017-02-02" ) {
                $res_name = "迪士尼唐老鸭P停车场";
                $start_station_address = "上海迪士尼度假区迪士尼唐老鸭P停车场";
            }
            $content = str_replace("{下车站点}", $run_info['end_res_name'], $content);
            $content = str_replace("{出发日期}", $start_date, $content);
            $content = str_replace("{出发时间}", $start_time, $content);
            $content = str_replace("{上车站点}", $res_name, $content);
            $content = str_replace("{出发地}", $start_area, $content);
            $content = str_replace("{目的地}", $end_area, $content);
            $content = str_replace("{票种名}", $prod_name, $content);
            $content = str_replace("{张数}", $order_count, $content);
            $content = str_replace("{上车站点详细地址}", $start_station_address, $content);
            $content = str_replace("{订单号}", $ORDER_ID, $content);
        } else {
            $content = str_replace("{下车站点}", "", $content);
            $content = str_replace("{出发日期}", "", $content);
            $content = str_replace("{出发时间}", "", $content);
            $content = str_replace("{出发地}", "", $content);
            $content = str_replace("{目的地}", "", $content);
            $content = str_replace("{票种名}", "", $content);
            $content = str_replace("{张数}", "", $content);
            $content = str_replace("{订单号}", "", $content);
            $content = str_replace("{上车站点详细地址}", "", $content);
        }
        if ($driver) {
            $bus_no = isset($driver['bus_no']) ? $driver['bus_no'] : "";
            $driver_name = isset($driver['driver_name']) ? $driver['driver_name'] : "";
            $driver_mobile = isset($driver['driver_mobile']) ? $driver['driver_mobile'] : "";

            if ($bus_no == "") {
                $content = str_replace("，车牌号{车牌号}", "", $content);
            } else {
                $content = str_replace("{车牌号}", $bus_no, $content);
            }
            if ($driver_name == "") {
                $content = str_replace("，司机电话{司机姓司机电话}，", "。", $content);
            } else {
                $driver_xing = mb_substr($driver_name, 0, 1, 'utf-8');
                $driver_name_mobile = $driver_xing . $driver_mobile;
                $content = str_replace("{司机姓司机电话}", $driver_name_mobile, $content);
            }
        } else {
            $content = str_replace("车牌号{车牌号}，", "", $content);
            $content = str_replace("司机电话{司机姓司机电话}，", "", $content);
        }
        $content .= "提前一天19点之前，如未收到司机电话，请速与021-52218088联系。";
        return array(isset($customer_name) ? $customer_name : "", isset($customer_mobile) ? $customer_mobile : "", isset($content) ? $content : "短信错误，联系客服!!!");
    }
}