nizongfeng
/
XMWXC
1
0
Fork 0
Code Issues 0 Pull Requests 0 Releases 0 Wiki Activity
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
2 Commits
1 Branch
29 MiB
 
 
 
 
 
Branch: master
Branches Tags
${ item.name }
Create branch ${ searchTerm }
from 'master'
${ noResults }
XMWXC/fx/order_confirm.php

362 lines
20 KiB
Raw Permalink Blame History 

  1. <?php

  2. require_once '../wechat/Common_fx/Mysql.php';

  3. require_once '../wechat/Common_fx/zizai_api.inc';

  4. require_once '../wechat/Common_fx/sinaAPI.php';

  5. if (ALLOW_ORIGIN)

  6.     header("Access-Control-Allow-Origin:*");

  7. 

  8. $pdo = conn();

  9. $order_id = $_GET['orderno'];

  10. $paynum = $_GET['paynum'];

  11. if (!$order_id) {

  12.     echo '订单号没有接收到';

  13.     die;

  14. }

  15. $sql_s = "select * from to_from where  to_orderid=" . $order_id . " or back_orderid=" . $order_id;

  16. $result = $pdo->query($sql_s);

  17. $rowset = $result->fetchAll(PDO::FETCH_ASSOC);

  18. //发送短信

  19. 

  20. if ($rowset) {

  21.     $ifback = 1;

  22.     $to_order_id = $rowset[0]['to_orderid'];

  23.     $back_order_id = $rowset[0]['back_orderid'];

  24.     $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'] . ")";

  25.     $result = $pdo->query($sql);

  26.     $rowset = $result->fetchAll(PDO::FETCH_ASSOC);

  27.     foreach ($rowset as $v) {

  28.         $list[] = $v['order_id'];

  29.     }

  30. 

  31. } else {

  32.     $sql = "select order_id from order_main where order_id = " . $order_id . " or parent_order_id = " . $order_id;

  33.     $result = $pdo->query($sql);

  34.     $rowset = $result->fetchAll(PDO::FETCH_ASSOC);

  35.     foreach ($rowset as $v) {

  36.         $list[] = $v['order_id'];

  37.     }

  38. }

  39. //是否有至订单

  40. 

  41. 

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

  43. 

  44. $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 "

  45.     . "from order_main a,order_main b "

  46.     . "where a.order_id = b.PARENT_ORDER_ID and a.order_id in (" . $list . ") group by a.order_id";

  47. 

  48. $result = $pdo->query($sql);

  49. $order_info = $result->fetchAll(PDO::FETCH_ASSOC);

  50. foreach ($order_info as $v) {

  51.     $list_P[] = $v['order_pay_main_id'];

  52. }

  53. $list_P = implode(",", $list_P);

  54. $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 . ")";

  55. $rs = $pdo->query($sql_pay);

  56. $sql_order_status = "update order_main set order_status =146  where  order_id in(" . $list . ")";

  57. $rs2 = $pdo->query($sql_order_status);

  58. 

  59. 

  60. $sql = "update `disney_order` set yet =0 where order_id =" . $order_id;

  61. $res = $pdo->query($sql);

  62. 

  63. $sql_s = "select * from disney_order where order_id = " . $order_id;

  64. $result = $pdo->query($sql_s);

  65. $rows_d = $result->fetchAll(PDO::FETCH_ASSOC);

  66. $list_d = Find($order_id);

  67. if (!isset($rows_d[0]['order_id']) && $list_d['prod_id'] != 450517 && $list_d['prod_id'] != 450522) {

  68.     if (isset($ifback)) {

  69.         send_msg($to_order_id);

  70.         send_msg($back_order_id);

  71.     } else {

  72.         send_msg($order_id);

  73.     }

  74. }

  75. $log = $sql . '##' . $sql_pay . "##" . $sql_order_status;

  76. success_notify($log);

  77. function success_notify($result)

  78. {

  79.     file_put_contents('./order_confirm.txt', date("Y-m-d H:i:s") . "  " . $result . PHP_EOL, FILE_APPEND);//订单成功后通知后台日志

  80. }

  81. 

  82. echo "支付成功";

  83. die;

  84. 

  85. 

  86. function send_msg($ORDER_ID)

  87. {

  88.     $send_pdo = conn();

  89.     $order_id = $ORDER_ID;

  90.     $res_content = get_msg_info($order_id);

  91.     $name = $res_content[0];

  92.     $tel = $res_content[1];

  93.     $content = $res_content[2];

  94.     writeLog("短信模板内容：【" . $content . "】");

  95. 

  96.     //..发短信先取消

  97.     $response = sendTelMessage($tel, $name, $content, $order_id);

  98.     writeLog(json_encode($response));

  99. 

  100.     $comment_type = 0;

  101.     $comment_text = "";

  102.     $send_success = (int)$response;

  103.     $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})";

  104.     $result1 = $send_pdo->query($sql1);

  105.     $rowset1 = $result1->fetchAll(PDO::FETCH_ASSOC);

  106.     $result1->closeCursor();

  107.     writeLog("hotel_order_status.php HT_ADD_MSG_COMMENT()::" . $sql1);

  108.     //insert order extra

  109.     $hotelPrice = isset($_GET['hotelPrice']) ? $_GET['hotelPrice'] : "";

  110.     $doorPrice = isset($_GET["doorPrice"]) ? $_GET["doorPrice"] : "";

  111.     if ($hotelPrice != "" || $doorPrice != "") {

  112.         $sqlInsert = " INSERT INTO order_extra_info (order_id,hotel_price,gate_price) VALUE(" . $ORDER_ID . ",'" . $hotelPrice . "','" . $doorPrice . "')  ";

  113.         writeLog("insert extra info: " . $sqlInsert);

  114.         $result = $send_pdo->exec($sqlInsert);

  115.     }

  116. }

  117. 

  118. //..短信模板-改为17：30后OK，当天下单也OK

  119. function get_msg_info($ORDER_ID)

  120. {

  121.     $msg_pdo = conn();

  122.     $msg_sql = "CALL SP_GET_MESSAGE_TEMPLATE('" . $ORDER_ID . "')";

  123.     $content = '';

  124.     if (is_object($msg_pdo)) {

  125.         $msg_result = $msg_pdo->query($msg_sql);

  126.         $i = 1;

  127.         $data = array();

  128.         if ($msg_result) {

  129.             $data['code'] = "0";

  130.             $data['info'] = "";

  131.             do {

  132.                 $row = $msg_result->fetchAll(PDO::FETCH_ASSOC);

  133.                 if ($i == 1) {

  134.                     $data['seat'] = isset($row) ? $row : array();

  135.                 } else if ($i == 2) {

  136.                     $data['run_info'] = isset($row) ? $row : array();

  137.                 } else if ($i == 3) {

  138.                     $data['driver'] = isset($row) ? $row : array();

  139.                 } else if ($i == 4) {

  140.                     $data['dsn_prod'] = isset($row) ? $row : array();

  141.                 } else if ($i == 5) {

  142.                     $data['zhou_su_prod'] = isset($row) ? $row : array();

  143.                 }

  144.                 $i++;

  145.             } while ($msg_result->nextRowset());

  146.         }

  147.         $json_obj = json_decode(json_encode($data), TRUE);

  148.         $seat = isset($json_obj['seat'][0]) ? $json_obj['seat'][0] : array();

  149.         $run_info = isset($json_obj['run_info'][0]) ? $json_obj['run_info'][0] : array();

  150.         $driver = isset($json_obj['driver'][0]) ? $json_obj['driver'][0] : array();

  151.         $dsn_prod = isset($json_obj['dsn_prod']) ? $json_obj['dsn_prod'] : array();

  152.         $zhou_su_prod = isset($json_obj['zhou_su_prod']) ? $json_obj['zhou_su_prod'] : array();

  153.         $bus_res_id = isset($json_obj['driver'][0]) ? $json_obj['driver'][0]["bus_res_id"] : 0;

  154.         $short_url = false;

  155.         if ($bus_res_id != 0) {

  156.             $ary_sell_ary = array(916, 917);

  157.             if (in_array($bus_res_id, $ary_sell_ary)) {

  158.                 $ticket_url = TICKET_QR_URL . $ORDER_ID;

  159.                 $short_url = sinaShortenUrl($ticket_url);

  160.             }

  161.         }

  162.         $extra_message = "";

  163.         if ($short_url != false) {

  164.             $extra_message = "点击以下链接获取您的电子票扫码上车：{$short_url}";

  165.         }

  166. 

  167.         //出票成功

  168.         //		$content = "您预订的{出发日期　出发时间}{出发地}-{目的地}{票种名}{张数}张，已购票成功。乘车订单号为{订单号}，请凭订单号或绑定微信（微信服务号“蜘蛛出行”）扫码上车，车牌号{车牌号}，司机电话{司机姓司机电话}。";

  169.         // 得到明天的时间

  170.         date_default_timezone_set('PRC');

  171.         //解决时区问题

  172.         $tomorrow = date("Y-m-d", strtotime("+1 day"));

  173.         $now_time = date('H:i:s', time());

  174.         //判断当前时间是否在17:30:00之后

  175.         $cur_date = date('Y-m-d', time());

  176.         //迪士尼特殊情况parent_prod_id

  177. 

  178. //		$dsn_arr_prod = array(152752, 152759, 152763, 152770, 152777, 152784, 152791, 152801, 152808, 152815, 152822, 152832, 152842, 152852, 152859, 152866, 152873, 152877, 152884, 152891, 152898, 152905, 152915, 152922, 152929, 152936, 152946, 152956, 152966, 152973, 152980, 152990, 153003, 153016, 153023, 153033, 153034, 153044, 153057, 153070, 153083, 153090, 153100, 153110);

  179.         $dsn_arr_prod = array(); //用来保存迪士尼产品的prod_id

  180.         foreach ($dsn_prod as $temp) {

  181.             $dsn_arr_prod[] = $temp['prod_id'];

  182.         }

  183. 

  184.         $zhou_su_arr_prod = array();

  185.         foreach ($zhou_su_prod as $temp) {

  186.             $zhou_su_arr_prod[] = $temp['prod_id'];

  187.         }

  188. 

  189.         $new_message_array = array(448569, 448568);

  190.         $new_message_array2 = array(449860, 449865, 450036, 450037);

  191.         if (($now_time > "18:30:00" && $run_info['start_date'] == $tomorrow) || $cur_date == $run_info['start_date']) {//17：30之后的订单或者下单时间为今天出行为今天下午  发送短信模板

  192.             //		if("18:30:00">"17:30:00" && $run_info['start_date']==$tomorrow){	//17：30之后的订单  发送短信模板

  193.             //			$content = "您预订的{出发日期　出发时间}{出发地}-{目的地}{票种名}{张数}张，已购票成功。乘车订单号为{订单号}，请凭订单号或绑定微信（微信服务号“蜘蛛出行”）扫码上车，车牌号{车牌号}，司机电话{司机姓司机电话}。";

  194. 

  195.             if (in_array($run_info['parent_prod_id'], $new_message_array)) {

  196.                 $content = "您预订的{出发日期}{出发地}-{目的地}{票种名}{张数}张，已成功出票，请在{出发时间}前十五分钟到达{上车站点}。您的乘车订单号为{订单号}，车牌号{车牌号}，司机电话{司机姓司机电话}，请凭短信订单号乘车{$extra_message}，预祝您旅途愉快。";

  197.             } elseif (in_array($run_info['parent_prod_id'], $new_message_array2)) {

  198.                 $content = "您已成功预订{出发地}-{目的地}城际商务车{张数}张车票，车型为奔驰7座，发车时间为{出发日期} {出发时间}，请提前10分钟到达{上车站点}。您的乘车订单号为{订单号}，车牌号{车牌号}，司机电话{司机姓司机电话}，请凭短信订单号乘车{$extra_message}，预祝您旅途愉快。";

  199.             } else {

  200.                 $content = "您预订的{出发日期}{出发地}-{目的地}{票种名}{张数}张，已成功出票，请在{出发时间}前三十分钟到达{上车站点}。您的乘车订单号为{订单号}，车牌号{车牌号}，司机电话{司机姓司机电话}，请凭短信订单号乘车{$extra_message}，预祝您旅途愉快。";

  201.             }

  202.             if (in_array($run_info['parent_prod_id'], $dsn_arr_prod)) {

  203.                 $content = "您预订的{上车站点}-{下车站点}车票{张数}张（订单号{订单号}）已经预订成功。发车时间为{出发日期} {出发时间}，请提前10分钟到达并向司机出示手机二维码／预订号乘车。上车地址为{上车站点}：{上车站点详细地址}。{$extra_message}请关注微信公众号“蜘蛛出行”，可以实时查询大巴定位、司机号码、车牌号等。";

  204.                 $start_station_address = $run_info['start_station_address'];

  205. 

  206.                 $content = str_replace("{上车站点详细地址}", $start_station_address, $content);

  207.                 $content = str_replace("{上车站点}", $run_info['res_name'], $content);

  208.                 $content = str_replace("{下车站点}", $run_info['end_res_name'], $content);

  209.                 $content = str_replace("{订单号}", $ORDER_ID, $content);

  210.             }

  211.         } else {

  212.             //			$content = "您预订的{出发日期　出发时间}{出发地}-{目的地}{票种名}{张数}张，已购票成功。乘车订单号为{订单号}，请凭订单号或绑定微信（微信服务号“蜘蛛出行”）扫码上车。";

  213.             $content = "您预订的{出发日期}{出发地}-{目的地}{票种名}{张数}张，已成功出票，请在{出发时间}前十分钟到达{上车站点}。您的乘车订单号为{订单号}，请凭短信订单号乘车。出行前一天下午的18:30会将车牌号与司机电话发送给您，预祝您旅途愉快。";

  214.             if (in_array($run_info['parent_prod_id'], $dsn_arr_prod)) {

  215.                 $ticket_url = TICKET_QR_URL . $ORDER_ID;

  216.                 $short_url = sinaShortenUrl($ticket_url);

  217.                 $extra_content = "";

  218.                 if ($short_url != false) {

  219.                     $extra_content = "或点击以下链接获取乘车二维码扫码上车(" . $short_url . ")";

  220.                 }

  221.                 $content = "您预订的{上车站点}-{下车站点}车票{张数}张（订单号{订单号}）已经预订成功。发车时间为{出发日期} {出发时间}，请提前10分钟到达并向司机出示手机二维码／预订号乘车。上车地址为{上车站点}：{上车站点详细地址}。{$extra_message}请关注微信公众号“蜘蛛出行”，可以实时查询大巴定位、司机号码、车牌号等。";

  222.                 $start_station_address = $run_info['start_station_address'];

  223. 

  224.                 $content = str_replace("{上车站点详细地址}", $start_station_address, $content);

  225.                 $content = str_replace("{上车站点}", $run_info['res_name'], $content);

  226.                 $content = str_replace("{下车站点}", $run_info['end_res_name'], $content);

  227.                 $content = str_replace("{订单号}", $ORDER_ID, $content);

  228.             }

  229.         }

  230.         $new_message_array3 = array(450517, 450522);

  231.         if (in_array($run_info['parent_prod_id'], $new_message_array3)) {

  232.             if ($run_info['parent_prod_id'] == 450517) {

  233.                 $address_txt = "上车地点：吴山广场西侧河坊巷8号（吴山广场旅游集散中心候车室）； 上车方式：请至吴山广场旅游集散中心候车室服务台，凭预定姓名和手机号码上车。";

  234.             } else {

  235.                 $address_txt = "上车地点：普陀城北长途客运中心； 上车方式：请提前到达，凭票上车。取票方式：（学运路18号）普陀城北长途客运中心旅客出口处，97自驾服务中心，报预订名字取票。";

  236.             }

  237.             $content = "您已成功预定{出发日期} {出发时间} {出发地}-{目的地}汽车票{张数}张（请最晚提前10分钟到达）。{$address_txt}联系电话4006-726-756。";

  238.         }

  239.         //		$content = "您预订的{出发日期　出发时间}{出发地}-{目的地}{票种名}{张数}张，已购票成功。乘车订单号为{订单号}，请凭订单号或绑定微信（微信服务号“蜘蛛出行”）扫码上车。";

  240.         if ($seat) {

  241.             $seat_x = isset($seat['seat_x']) ? $seat['seat_x'] : "";

  242.             $seat_y = isset($seat['seat_y']) ? $seat['seat_y'] : "";

  243.             $seat_name = isset($seat['seat_name']) ? $seat['seat_name'] : "";

  244.             $order_main_id = isset($seat['order_main_id']) ? $seat['order_main_id'] : "";

  245.         } else {

  246. 

  247.         }

  248.         if ($run_info) {

  249.             $order_count = $run_info['order_count'];

  250.             $start_date = $run_info['start_date'];

  251.             $start_time = $run_info['start_time'];

  252.             $parent_order_id = $run_info['parent_order_id'];

  253.             $end_date = $run_info['end_date'];

  254.             $start_area = $run_info['start_area'];

  255.             $end_area = $run_info['end_area'];

  256.             $res_name = $run_info['res_name'];

  257.             $parent_prod_id = $run_info['parent_prod_id'];

  258.             $prod_name = $run_info['prod_name'];

  259.             $prod_name = "标准票";

  260.             $customer_name = $run_info['customer_name'];

  261.             $customer_mobile = $run_info['customer_mobile'];

  262.             $start_end_date = $start_date . "," . $start_time;

  263.             $content = str_replace("{出发日期}", $start_date, $content);

  264.             $content = str_replace("{出发时间}", $start_time, $content);

  265.             $content = str_replace("{上车站点}", $res_name, $content);

  266.             $content = str_replace("{出发地}", $start_area, $content);

  267.             $content = str_replace("{目的地}", $end_area, $content);

  268.             $content = str_replace("{票种名}", $prod_name, $content);

  269.             $content = str_replace("{张数}", $order_count, $content);

  270.             $content = str_replace("{订单号}", $ORDER_ID, $content);

  271.         } else {

  272.             $content = str_replace("{出发日期}", "", $content);

  273.             $content = str_replace("{出发时间}", "", $content);

  274.             $content = str_replace("{出发地}", "", $content);

  275.             $content = str_replace("{目的地}", "", $content);

  276.             $content = str_replace("{票种名}", "", $content);

  277.             $content = str_replace("{张数}", "", $content);

  278.             $content = str_replace("{订单号}", "", $content);

  279.         }

  280.         if ($driver) {

  281.             $bus_no = isset($driver['bus_no']) ? $driver['bus_no'] : "";

  282.             $driver_name = isset($driver['driver_name']) ? $driver['driver_name'] : "";

  283.             $driver_mobile = isset($driver['driver_mobile']) ? $driver['driver_mobile'] : "";

  284. 

  285.             if ($bus_no == "") {

  286.                 $content = str_replace("，车牌号{车牌号}", "", $content);

  287.             } else {

  288.                 $content = str_replace("{车牌号}", $bus_no, $content);

  289.             }

  290.             if ($driver_name == "") {

  291.                 $content = str_replace("，司机电话{司机姓司机电话}，", "。", $content);

  292.             } else {

  293.                 $driver_xing = mb_substr($driver_name, 0, 1, 'utf-8');

  294.                 $driver_name_mobile = $driver_xing . $driver_mobile;

  295.                 $content = str_replace("{司机姓司机电话}", $driver_name_mobile, $content);

  296.             }

  297.         } else {

  298.             $content = str_replace("车牌号{车牌号}，", "", $content);

  299.             $content = str_replace("司机电话{司机姓司机电话}，", "", $content);

  300.         }

  301.         /*

  302.         if( $now_time < "18:30:00" ) {

  303.             //判断是不是苏州或周庄

  304.             // 判断如果不是迪士尼的票就不发短信

  305.             if (!in_array($run_info['parent_prod_id'], $dsn_arr_prod) && !in_array($run_info['parent_prod_id'], $zhou_su_arr_prod)) {

  306.                 return array("", "-1", "不是迪士尼、苏州、周庄的票，目前不发送短信");

  307.             }

  308.         }*/

  309. 

  310.         return array(isset($customer_name) ? $customer_name : "", isset($customer_mobile) ? $customer_mobile : "", isset($content) ? $content : "短信错误，联系客服!!!");

  311.     }

  312. }

  313. 

  314. 

  315. function Find($order_id)

  316. {

  317.     $pdo = conn();

  318.     $sql = "select  order_description,order_price,order_status "

  319.         . "from order_main "

  320.         . "where order_id=" . $order_id;

  321.     $result = $pdo->query($sql);

  322.     $rowset = $result->fetchAll(PDO::FETCH_ASSOC);

  323.     $order_price = $rowset[0];//订单总价格  订单票的数量

  324.     $sql = "SELECT DISTINCT 

  325.             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  

  326.             FROM `order_main` 

  327.             where  PARENT_ORDER_ID=" . $order_id;

  328.     $result = $pdo->query($sql);

  329.     $rowset = $result->fetchAll(PDO::FETCH_ASSOC);

  330.     $order_station = $rowset[0];//订单来往地址  订单时间 订单好

  331.     if (empty($order_station))

  332.         return false;

  333.     $array_order_desc = array();

  334. 

  335.     $arr_temp = explode('|', $order_price['order_description']);

  336.     $arr = array();

  337.     foreach ($arr_temp as $k => $v2) {

  338.         if (!empty($v2))

  339.             $array_order_desc[] = explode(',', $v2);   //订单票  * 数量

  340.     }

  341.     $list = array();

  342.     //上海（黄浦旅游集散站）    -      乌镇（西栅1号停车场）//反的数组

  343.     $list['station'] = $order_station['PROD_START_STATION_AREA_NAME'] . '(' . $order_station['PROD_START_STATION_RES_NAME'] . ')'

  344.         . '-' . $order_station['PROD_END_STATION_AREA_NAME'] . '(' . $order_station['PROD_END_STATION_RES_NAME'] . ')';

  345.     $list['start_station'] = $order_station['PROD_START_STATION_AREA_NAME'];

  346.     $list['end_station'] = $order_station['PROD_END_STATION_AREA_NAME'];

  347.     $list['start_res_name'] = $order_station['PROD_START_STATION_RES_NAME'];

  348.     $list['end_res_name'] = $order_station['PROD_END_STATION_RES_NAME'];

  349.     $list['run_date'] = $order_station['run_date'];

  350.     $list['prod_name'] = $order_station['prod_name'];

  351.     $list['prod_id'] = $order_station['parent_prod_id'];

  352.     $list['create_time'] = $order_station['create_time'];

  353.     $list['run_time'] = $order_station['run_date'] . '  ' . $order_station['run_time'];

  354.     $list['count'] = '';

  355.     foreach ($array_order_desc as $v) {

  356.         $list['count'] .= ' ' . $v[0] . ' × ' . $v[2];

  357.     }

  358.     $list['order_price'] = $order_price['order_price'];

  359.     $list['order_status'] = $order_price['order_status'];

  360.     return $list;

  361. }