ZZWX/fx/order_confirm.php

<?php
require_once '../wechat/Common_fx/Mysql.php';
require_once '../wechat/Common_fx/zizai_api.inc';
require_once '../wechat/Common_fx/sinaAPI.php';
if (ALLOW_ORIGIN)
    header("Access-Control-Allow-Origin:*");

$pdo = conn();
$order_id = $_GET['orderno'];
$paynum = $_GET['paynum'];
if (!$order_id) {
    echo '订单号没有接收到';
    die;
}
$status_sql = "select order_status from order_main where order_id = " . $order_id;
$result = $pdo->query($status_sql);
$rowset = $result->fetchAll(PDO::FETCH_ASSOC);
if($rowset['order_status'] == 146){
    echo "支付成功";
    die;
}

$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'];
    $sql = "select order_id from order_main where order_id in (" . $rowset[0]['to_orderid'] . "," . $rowset[0]['back_orderid'] . ") or parent_order_id in (" . $rowset[0]['to_orderid'] . "," . $rowset[0]['back_orderid'] . ")";
    $result = $pdo->query($sql);
    $rowset = $result->fetchAll(PDO::FETCH_ASSOC);
    foreach ($rowset as $v) {
        $list[] = $v['order_id'];
    }

} else {
    $sql = "select order_id from order_main where order_id = " . $order_id . " or parent_order_id = " . $order_id;
    $result = $pdo->query($sql);
    $rowset = $result->fetchAll(PDO::FETCH_ASSOC);
    foreach ($rowset as $v) {
        $list[] = $v['order_id'];
    }
}
//是否有至订单


$list = implode(",", $list);

$sql = "select a.order_id,a.order_price,a.outside_order_no,a.order_pay_main_id,a.customer_name,a.customer_mobile,count(b.order_id) as num,b.run_date,b.run_time,b.PROD_START_STATION_AREA_NAME AS start_area,b.PROD_END_STATION_AREA_NAME AS end_area,b.PROD_START_STATION_RES_NAME AS start_res,b.PROD_END_STATION_RES_NAME AS end_res "
    . "from order_main a,order_main b "
    . "where a.order_id = b.PARENT_ORDER_ID and a.order_id in (" . $list . ") group by a.order_id";

$result = $pdo->query($sql);
$order_info = $result->fetchAll(PDO::FETCH_ASSOC);
foreach ($order_info as $v) {
    $list_P[] = $v['order_pay_main_id'];
}
$list_P = implode(",", $list_P);
$sql_pay = "update order_pay_detail set pay_type_id_1 =278,PAY_SERIAL_NUMBER='" . $order_id . "-" . $paynum . "'  where pay_main_id in (" . $list_P . ")";
$rs = $pdo->query($sql_pay);
$sql_order_status = "update order_main set order_status =146,ORDER_PAY_STATUS=1  where  order_id in(" . $list . ")";
$rs2 = $pdo->query($sql_order_status);


$sql = "update `disney_order` set yet =0 where order_id =" . $order_id;
$res = $pdo->query($sql);

$sql_s = "select * from disney_order where order_id = " . $order_id;
$result = $pdo->query($sql_s);
$rows_d = $result->fetchAll(PDO::FETCH_ASSOC);
$list_d = Find($order_id);
if (!isset($rows_d[0]['order_id']) && $list_d['prod_id'] != 450517 && $list_d['prod_id'] != 450522) {
    if (isset($ifback)) {
        send_msg($to_order_id);
        send_msg($back_order_id);
    } else {
        send_msg($order_id);
    }
}
$log = $sql . '##' . $sql_pay . "##" . $sql_order_status;
success_notify($log);
function success_notify($result)
{
    file_put_contents('./order_confirm.txt', date("Y-m-d H:i:s") . "  " . $result . PHP_EOL, FILE_APPEND);//订单成功后通知后台日志
}

echo "支付成功";
die;


function send_msg($ORDER_ID)
{
    $send_pdo = conn();
    $order_id = $ORDER_ID;

    $url='http://cs1.zhizhuchuxing.com/api/msg/order-send-msg';
    $sendInfo=array();
    $sendInfo['order_id']=$order_id;
    $sendInfo['msg_type']='wx';
    $res_content = httpRequest($url,$sendInfo);

    //insert order extra
    $hotelPrice = isset($_GET['hotelPrice']) ? $_GET['hotelPrice'] : "";
    $doorPrice = isset($_GET["doorPrice"]) ? $_GET["doorPrice"] : "";
    if ($hotelPrice != "" || $doorPrice != "") {
        $sqlInsert = " INSERT INTO order_extra_info (order_id,hotel_price,gate_price) VALUE(" . $ORDER_ID . ",'" . $hotelPrice . "','" . $doorPrice . "')  ";
        writeLog("insert extra info: " . $sqlInsert);
        $result = $send_pdo->exec($sqlInsert);
    }
}

//..短信模板-改为17：30后OK，当天下单也OK
function get_msg_info($ORDER_ID)
{
    $url='http://cs1.zhizhuchuxing.com/api/msg/get-msg-info';
    $sendInfo=array();
    $sendInfo['order_id']=	$ORDER_ID;
    $sendInfo['msg_type']='wx';
    $res_content = httpRequest($url,$sendInfo);
    $result_array = json_decode($res_content,true);
    return array(isset($result_array['name']) ? $result_array['name'] : "", isset($result_array['mobile']) ? $result_array['mobile'] : "", isset($result_array['content']) ? $result_array['content'] : "短信错误，联系客服!!!");
}


function Find($order_id)
{
    $pdo = conn();
    $sql = "select  order_description,order_price,order_status "
        . "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,create_time,parent_prod_id,prod_name,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['prod_name'] = $order_station['prod_name'];
    $list['prod_id'] = $order_station['parent_prod_id'];
    $list['create_time'] = $order_station['create_time'];
    $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'];
    $list['order_status'] = $order_price['order_status'];
    return $list;
}