Du kan inte välja fler än 25 ämnen Ämnen måste starta med en bokstav eller siffra, kan innehålla bindestreck ('-') och vara max 35 tecken långa.
 
 
 
 

505 rader
23 KiB

  1. <?php
  2. if (ALLOW_ORIGIN)
  3. header("Access-Control-Allow-Origin:*");
  4. date_default_timezone_set('PRC');
  5. //require_once '../../Common/Mysql.php';
  6. $user_id = $_COOKIE['user_id'];//getUserId();
  7. $order_from_org_id = isset($_COOKIE['org_id']) ? $_COOKIE['org_id'] : 0;
  8. $top_org_id = $_COOKIE['top_org_id'];
  9. //echo $order_from_org_id;die;
  10. if (!$user_id) {
  11. echo json_encode(array("code" => 1, "iflogin" => 1, "info" => "用户未登录"));
  12. exit;
  13. }
  14. $list_tic = get_memcache('disney_ticket_info');
  15. //reget data from database
  16. if( $list_tic == false ) {
  17. $pdo = conn();
  18. $sql = " SELECT * FROM outside_ticket WHERE prod_code IN('SHDSN','SHDSN2') AND ticket_date >= '{$start_date}' AND cancel_flag = 0 ORDER BY ticket_date ";
  19. $result = $pdo->query($sql);
  20. $rowset = $result->fetchAll();
  21. $disney_ticket_array = array();
  22. foreach( $rowset as $row_info ) {
  23. $ticket_date = $row_info["ticket_date"];
  24. if( !isset($disney_ticket_array[$ticket_date]) ) {
  25. $disney_ticket_array[$ticket_date] = array();
  26. $disney_ticket_array[$ticket_date]["tic_info"] = array(0,0,0,0,0,0);
  27. $disney_ticket_array[$ticket_date]["price"] = array(0,0,0,0,0,0);
  28. $disney_ticket_array[$ticket_date]["ticket_array"] = array();
  29. $disney_ticket_array[$ticket_date]["ticket_array"][] = array( "ticketid" => "", "ticketname" => "单日成人票", "ticketprice" => 499, "ticketcount" => 0, "agentprice" => 464 );
  30. $disney_ticket_array[$ticket_date]["ticket_array"][] = array( "ticketid" => "", "ticketname" => "单日儿童票", "ticketprice" => 499, "ticketcount" => 0, "agentprice" => 464 );
  31. $disney_ticket_array[$ticket_date]["ticket_array"][] = array( "ticketid" => "", "ticketname" => "单日老人票", "ticketprice" => 499, "ticketcount" => 0, "agentprice" => 464 );
  32. $disney_ticket_array[$ticket_date]["ticket_array"][] = array( "ticketid" => "", "ticketname" => "二日成人票", "ticketprice" => 900, "ticketcount" => 0, "agentprice" => 845 );
  33. $disney_ticket_array[$ticket_date]["ticket_array"][] = array( "ticketid" => "", "ticketname" => "二日儿童票", "ticketprice" => 900, "ticketcount" => 0, "agentprice" => 845 );
  34. $disney_ticket_array[$ticket_date]["ticket_array"][] = array( "ticketid" => "", "ticketname" => "二日老人票", "ticketprice" => 900, "ticketcount" => 0, "agentprice" => 845 );
  35. }
  36. $ticket_name = $row_info["ticket_name"];
  37. $ticket_index = 0;
  38. if( mb_strpos($ticket_name, "儿童") ) {
  39. $ticket_index = 1;
  40. } else if( mb_strpos($ticket_name, "老人") ) {
  41. $ticket_index = 2;
  42. }
  43. if( $row_info["prod_code"] == 'SHDSN2' ) {
  44. $ticket_index += 3;
  45. }
  46. $ticket_info_temp = $disney_ticket_array[$ticket_date];
  47. $ticket_info_temp["tic_info"][$ticket_index] = $row_info["ticket_num"];
  48. $ticket_info_temp["price"][$ticket_index] = (int)$row_info["ticket_price"];
  49. $ticket_info_temp["ticket_array"][$ticket_index]["ticketid"] = $row_info["ticket_code"];
  50. $ticket_info_temp["ticket_array"][$ticket_index]["ticketprice"] = (int)$row_info["ticket_price"];
  51. $ticket_info_temp["ticket_array"][$ticket_index]["ticketcount"] = $row_info["ticket_num"];
  52. $ticket_info_temp["ticket_array"][$ticket_index]["agentprice"] = (int)$row_info["agent_price"];
  53. $disney_ticket_array[$ticket_date] = $ticket_info_temp;
  54. }
  55. foreach( $disney_ticket_array as $disney_date => $disney_ticket ) {
  56. $disney_memory[$disney_date] = $disney_ticket;
  57. }
  58. set_memcache('disney_ticket_info', $disney_memory);
  59. $list_tic = $disney_memory;
  60. }
  61. if (isset($_POST['get_tic'])) {
  62. $date = $_POST['get_tic'];
  63. $tic_info = $list_tic[$date];
  64. if ($top_org_id == 136) {
  65. if ($tic_info['price'][0] == 370) {
  66. $tic_info['price'][0] = 320;
  67. } elseif ($tic_info['price'][0] == 499) {
  68. $tic_info['price'][0] = 470;
  69. }
  70. }
  71. echo json_encode(array("code" => 0, "info" => $tic_info['tic_info'], 'price' => $tic_info['price']));
  72. exit;
  73. }
  74. if (isset($_COOKIE['login_type']) || $top_org_id == 0) {
  75. $pay_status = 145;
  76. $pay_type = 278;
  77. } else {
  78. $pay_status = 146;
  79. $pay_type = 275;
  80. }
  81. if (isset($_POST)) {
  82. $date = isset($_POST['date_time']) ? $_POST['date_time'] : '0';
  83. /*
  84. if ($date <= '2016-11-01') {
  85. echo json_encode(array("code" => 1, "info" => "系统维护暂停售票"));
  86. exit;
  87. }
  88. */
  89. $current_day = date('Y-m-d', time());
  90. $diff_seconds = strtotime($date) - strtotime($current_day);
  91. $diff_day = floor($diff_seconds/3600/24);
  92. if( $date >= "2017-01-26" && $date <= "2017-02-03" ) {
  93. echo json_encode(array("code" => 1, "info" => "票已全部售罄"));
  94. exit;
  95. }
  96. if ($diff_day < 0) {
  97. echo json_encode(array("code" => 1, "info" => "不在可预订时间段"));
  98. exit;
  99. }
  100. /*
  101. if ($diff_day <= 1) {
  102. if ($diff_day == 1) {
  103. if (date('H:i:s') >= '22:00:01') {
  104. echo json_encode(array("code" => 1, "info" => "不在预定时间段"));
  105. exit;
  106. } elseif ($diff_day == 0) {
  107. echo json_encode(array("code" => 1, "info" => "不在预定时间段"));
  108. exit;
  109. }
  110. } else {
  111. echo json_encode(array("code" => 1, "info" => "不在预定时间段"));
  112. exit;
  113. }
  114. }
  115. */
  116. $cust_name = isset($_POST['customer_name']) ? $_POST['customer_name'] : '匿名者';
  117. $cust_phone = isset($_POST['customer_phone']) ? $_POST['customer_phone'] : '123456789';
  118. $id_type = isset($_POST['customer_id_type']) ? $_POST['customer_id_type'] : '150'; // 150身份证 153 护照
  119. $customer_id = isset($_POST['customer_id']) ? $_POST['customer_id'] : '123456789';
  120. //票种和数量价格 prod_id=>票的数量
  121. $ticket = array(
  122. 'D' => isset($_POST['D']) ? $_POST['D'] : 0,
  123. 'C' => isset($_POST['C']) ? $_POST['C'] : 0,
  124. 'O' => isset($_POST['O']) ? $_POST['O'] : 0,
  125. 'D2' => isset($_POST['D2']) ? $_POST['D2'] : 0,
  126. 'C2' => isset($_POST['C2']) ? $_POST['C2'] : 0,
  127. 'O2' => isset($_POST['O2']) ? $_POST['O2'] : 0,
  128. );
  129. $ticket_no = array(
  130. '0' => isset($_POST['D']) ? $_POST['D'] : 0,
  131. '1' => isset($_POST['C']) ? $_POST['C'] : 0,
  132. '2' => isset($_POST['O']) ? $_POST['O'] : 0,
  133. '3' => isset($_POST['D2']) ? $_POST['D2'] : 0,
  134. '4' => isset($_POST['C2']) ? $_POST['C2'] : 0,
  135. '5' => isset($_POST['O2']) ? $_POST['O2'] : 0,
  136. );
  137. $ticket_no_b = serialize($ticket_no);
  138. }
  139. $num1 = 0;
  140. $num2 = 0;
  141. foreach ($ticket_no as $k => $v) {
  142. if ($k <= 2) {
  143. $num1 += $v;
  144. } else {
  145. $num2 += $v;
  146. }
  147. }
  148. if ($num1 && $num2) {
  149. echo json_encode(array("code" => 1, "info" => '单日票和双日票不可在同一订单'));
  150. exit;
  151. }
  152. $disney_all_array = $list_tic[$date]["ticket_array"];
  153. /*
  154. $return_no = buy_disney_ticket($cust_name, $cust_phone, $customer_id, $ticket_no, $date,$disney_all_array);
  155. if ( $return_no == false || $return_no == '-1' || $return_no == '0') {
  156. echo json_encode(array("code" => 1, "info" => '出票失败'));
  157. exit;
  158. }
  159. */
  160. $return_no = "0";
  161. $cus_memo = "【提醒】需去驴妈妈手动下单";
  162. $tic_info = $list_tic[$date];
  163. if ($top_org_id == 136) {
  164. if ($tic_info['price'][0] == 370) {
  165. $tic_info['price'][0] = 320;
  166. } elseif ($tic_info['price'][0] == 499) {
  167. $tic_info['price'][0] = 470;
  168. }
  169. }
  170. $pdo = conn();
  171. $sql = "select a.prod_id,a.prod_name,b.prod_price,b.prod_type_id "
  172. . "from opera_product a inner join opera_product_price b on a.prod_id = b.prod_id "
  173. . "where a.parent_id = 448277";
  174. $result = $pdo->query($sql);
  175. $rowset = $result->fetchAll(PDO::FETCH_ASSOC);
  176. $info = array();
  177. foreach ($rowset as $v) {
  178. $info[$v['prod_id']] = $v;
  179. }
  180. $sql_p = "select prod_id,prod_name "
  181. . " from opera_product "
  182. . " where prod_id = 448277";
  183. $result_p = $pdo->query($sql_p);
  184. $rowset_p = $result_p->fetchAll(PDO::FETCH_ASSOC);
  185. $info_p = $rowset_p[0];
  186. /**
  187. * 迪士尼票种信息
  188. * 152990 =>
  189. * array
  190. * 'prod_id' => string '152990' (length=6)
  191. * 'prod_name' => string '迪士尼门票(成人票)' (length=30)
  192. * 'prod_price' => string '20.00' (length=5)
  193. * 'prod_type_id' => string '262' (length=3)
  194. */
  195. $num = 0;
  196. $order_description = "";
  197. $price = 0;
  198. $return_info = '';
  199. $update_product_array = array(
  200. '448278' => 0,
  201. '448279' => 0,
  202. '448328' => 0,
  203. '448324' => 0,
  204. '448323' => 0,
  205. '448327' => 0
  206. );
  207. foreach ($ticket as $k => $v) {
  208. $num += $v;
  209. if ($v) {
  210. switch ($k) {
  211. case 'D':
  212. $price += $tic_info['price'][0] * $v;
  213. $return_info .= '标准一日票 × ' . $v;
  214. $order_description .= " 标准一日票," . date('Y-m-d', time()) . "," . $v . "|";
  215. $update_product_array['448278'] += $v;
  216. break;
  217. case 'C':
  218. $price += $tic_info['price'][1] * $v;
  219. $return_info .= ' 儿童一日票 × ' . $v;
  220. $order_description .= "儿童一日票," . date('Y-m-d', time()) . "," . $v . "|";
  221. $update_product_array['448279'] += $v;
  222. break;
  223. case 'O':
  224. $price += $tic_info['price'][2] * $v;
  225. $return_info .= ' 老人一日票 × ' . $v;
  226. $order_description .= "老人一日票," . date('Y-m-d', time()) . "," . $v . "|";
  227. $update_product_array['448328'] += $v;
  228. break;
  229. case 'C2':
  230. $price += $tic_info['price'][4] * $v;
  231. $return_info .= ' 儿童两日票 × ' . $v;
  232. $order_description .= "儿童两日票," . date('Y-m-d', time()) . "," . $v . "|";
  233. $update_product_array['448324'] += $v;
  234. break;
  235. case 'D2':
  236. $price += $tic_info['price'][3] * $v;
  237. $return_info .= ' 标准两日票 × ' . $v;
  238. $order_description .= "标准两日票," . date('Y-m-d', time()) . "," . $v . "|";
  239. $update_product_array['448323'] += $v;
  240. break;
  241. case 'O2':
  242. $price += $tic_info['price'][5] * $v;
  243. $return_info .= ' 老人两日票 × ' . $v;
  244. $order_description .= "老人两日票," . date('Y-m-d', time()) . "," . $v . "|";
  245. $update_product_array['448327'] += $v;
  246. break;
  247. }
  248. }
  249. }
  250. if ($num > 5 || $num <= 0) {
  251. echo json_encode(array("code" => 1, "info" => "最多定票五张"));
  252. exit;
  253. }
  254. //订单插入需要的字段 id = order_id create_time update_time order_pay_satatus 0 未支付 order_description order_price order_prod_type
  255. // prod_name order_status customer_name customer_mobile customer_id_type customer_id _no
  256. // 至订单需要的之短 parent_order_id prod_id parent_prod_id prod_name parent_prod_name order_price
  257. //function getUniqeId(){
  258. // $pdo= conn();
  259. // $result=$pdo->query("select FUNC_GET_UNIQUE_ID('1','1') id");
  260. // $rowset = $result -> fetchAll(PDO::FETCH_ASSOC);
  261. // return $rowset[0]['id'];
  262. //}
  263. $id_p = getUniqeId();
  264. $order_id_p = $id_p;
  265. $pay_main_id = getUniqeId();
  266. $create_time = date('Y-m-d H:i:s', time());
  267. $update_time = $create_time;
  268. $order_pay_status = 0;
  269. //查找数据库中关于迪士尼的信息
  270. $sql_in = " insert into order_main
  271. (`id`,
  272. `order_id`,`customer_memo`,
  273. `create_time`,`update_time`,
  274. `order_pay_status`,`order_description`,
  275. `order_price`,`order_prod_type`,`prod_name`,`order_status`,
  276. `customer_name`,`customer_mobile`,`customer_id_type`,`customer_id_no`,
  277. `order_book_status`,`PROD_START_STATION_TIME_MINUTES`,`prod_id`,`run_date`,`main_create_user_id`,`order_pay_main_id`,`outside_sale_org_id`,`outside_order_no`)
  278. values ('" . $id_p . "','". $order_id_p . "','{$cus_memo}','" . $create_time . "','" . $update_time . "','0','" . $order_description . "','"
  279. . $price . "','258','" . $info_p['prod_name'] . "','" . $pay_status . "','" . $cust_name . "','" . $cust_phone . "','" . $id_type . "','" . $customer_id . "','1','0','" . $info_p['prod_id'] . "','" . $date . "','" . $user_id . "','" . $pay_main_id . "','" . $order_from_org_id . "','" . $return_no . "')";
  280. for_insert($sql_in);
  281. //插入支付方式等信息
  282. $sql_pay = "insert INTO"
  283. . " `order_pay_main`(id,CREATe_user_id,CREATE_time,update_user_id,pay_total) "
  284. . "VALUES(" . $pay_main_id . "," . $user_id . ",'" . date('Y-m-d H-i-s', time()) . "'," . $user_id . "," . $price . ");"
  285. . "insert INTO `order_pay_detail`
  286. (id,CREATe_user_id,CREATE_time,update_user_id,pay_main_id,pay_type_id_1,pay_money)
  287. VALUES(" . $pay_main_id . "," . $user_id . ",'" . date('Y-m-d H-i-s', time()) . "'," . $user_id . "," . $pay_main_id . "," . $pay_type . "," . $price . ");";
  288. for_insert($sql_pay);
  289. foreach ($ticket as $k => $v) {
  290. if ($v) {
  291. switch ($k) {
  292. case 'D':
  293. for ($i = 1; $i <= $v; $i++) {
  294. $id = $order_id = getUniqeId();
  295. $sql = " insert into order_main
  296. (`id`,
  297. `order_id`,`customer_memo`,
  298. `create_time`,`update_time`,
  299. `order_pay_status`,
  300. `order_prod_type`,`order_status`,
  301. `customer_name`,`customer_mobile`,`customer_id_type`,`customer_id_no`,
  302. `order_book_status`,`PROD_START_STATION_TIME_MINUTES`,`parent_order_id`,`prod_id`,`parent_prod_id`,`prod_name`,`parent_prod_name`,`order_price`,`run_date`,`order_pay_main_id`,`outside_sale_org_id`,`outside_order_no`,`main_create_user_id`)
  303. values ('" . $id . "','"
  304. . $order_id . "','{$cus_memo}','" . $create_time . "','" . $update_time . "','0','258','" .
  305. $pay_status . "','" . $cust_name . "','" . $cust_phone . "','" . $id_type . "','" .
  306. $customer_id . "','0','0','" . $id_p . "','" . $info['448278']['prod_id'] . "','" . $info_p['prod_id'] . "','" . $info['448278']['prod_name'] . "','" . $info_p['prod_name'] . "','" . $tic_info['price'][0] . "','" . $date . "','" . $pay_main_id . "','" . $order_from_org_id . "','" . $return_no . "','" . $user_id . "')";
  307. for_insert($sql);
  308. }
  309. break;
  310. case 'C':
  311. for ($i = 1; $i <= $v; $i++) {
  312. $id = $order_id = getUniqeId();
  313. $sql = " insert into order_main
  314. (`id`,
  315. `order_id`,`customer_memo`,
  316. `create_time`,`update_time`,
  317. `order_pay_status`,
  318. `order_prod_type`,`order_status`,
  319. `customer_name`,`customer_mobile`,`customer_id_type`,`customer_id_no`,
  320. `order_book_status`,`PROD_START_STATION_TIME_MINUTES`,`parent_order_id`,`prod_id`,`parent_prod_id`,`prod_name`,`parent_prod_name`,`order_price`,`run_date`,`order_pay_main_id`,`outside_sale_org_id`,`outside_order_no`,`main_create_user_id`)
  321. values ('" . $id . "','"
  322. . $order_id . "','{$cus_memo}','" . $create_time . "','" . $update_time . "','0','258','"
  323. . $pay_status . "','" . $cust_name . "','" . $cust_phone . "','" . $id_type . "','"
  324. . $customer_id . "','0','0','" . $id_p . "','" . $info['448279']['prod_id'] . "','"
  325. . $info_p['prod_id'] . "','" . $info['448279']['prod_name'] . "','" . $info_p['prod_name'] . "','" . $tic_info['price'][1] . "','" . $date . "','" . $pay_main_id . "','" . $order_from_org_id . "','" . $return_no . "','" . $user_id . "')";
  326. for_insert($sql);
  327. }
  328. break;
  329. case 'O':
  330. for ($i = 1; $i <= $v; $i++) {
  331. $id = $order_id = getUniqeId();
  332. $sql = " insert into order_main
  333. (`id`,
  334. `order_id`,`customer_memo`,
  335. `create_time`,`update_time`,
  336. `order_pay_status`,
  337. `order_prod_type`,`order_status`,
  338. `customer_name`,`customer_mobile`,`customer_id_type`,`customer_id_no`,
  339. `order_book_status`,`PROD_START_STATION_TIME_MINUTES`,`parent_order_id`,`prod_id`,`parent_prod_id`,`prod_name`,`parent_prod_name`,`order_price`,`run_date`,`order_pay_main_id`,`outside_sale_org_id`,`outside_order_no`,`main_create_user_id`)
  340. values ('" . $id . "','". $order_id . "','{$cus_memo}','" . $create_time . "','" . $update_time . "','0','258','"
  341. . $pay_status . "','" . $cust_name . "','" . $cust_phone . "','" . $id_type . "','" . $customer_id . "','0','0','"
  342. . $id_p . "','" . $info['448328']['prod_id'] . "','" . $info_p['prod_id'] . "','" . $info['448328']['prod_name'] . "','" . $info_p['prod_name'] . "','" . $tic_info['price'][2] . "','" . $date . "','" . $pay_main_id . "','" . $order_from_org_id . "','" . $return_no . "','" . $user_id . "')";
  343. for_insert($sql);
  344. }
  345. break;
  346. case 'C2':
  347. for ($i = 1; $i <= $v; $i++) {
  348. $id = $order_id = getUniqeId();
  349. $sql = " insert into order_main
  350. (`id`,
  351. `order_id`,`customer_memo`,
  352. `create_time`,`update_time`,
  353. `order_pay_status`,
  354. `order_prod_type`,`order_status`,
  355. `customer_name`,`customer_mobile`,`customer_id_type`,`customer_id_no`,
  356. `order_book_status`,`PROD_START_STATION_TIME_MINUTES`,`parent_order_id`,`prod_id`,`parent_prod_id`,`prod_name`,`parent_prod_name`,`order_price`,`run_date`,`order_pay_main_id`,`outside_sale_org_id`,`outside_order_no`,`main_create_user_id`)
  357. values ('" . $id . "','". $order_id . "','{$cus_memo}','" . $create_time . "','" . $update_time . "','0','258','" . $pay_status . "','"
  358. . $cust_name . "','" . $cust_phone . "','" . $id_type . "','" . $customer_id . "','0','0','" . $id_p . "','" . $info['448324']['prod_id'] . "','" . $info_p['prod_id'] . "','" . $info['448324']['prod_name'] . "','" . $info_p['prod_name'] . "','" . $tic_info['price'][4] . "','" . $date . "','" . $pay_main_id . "','" . $order_from_org_id . "','" . $return_no . "','" . $user_id . "')";
  359. for_insert($sql);
  360. }
  361. break;
  362. case 'D2':
  363. for ($i = 1; $i <= $v; $i++) {
  364. $id = $order_id = getUniqeId();
  365. $sql = " insert into order_main
  366. (`id`,
  367. `order_id`,`customer_memo`,
  368. `create_time`,`update_time`,
  369. `order_pay_status`,
  370. `order_prod_type`,`order_status`,
  371. `customer_name`,`customer_mobile`,`customer_id_type`,`customer_id_no`,
  372. `order_book_status`,`PROD_START_STATION_TIME_MINUTES`,`parent_order_id`,`prod_id`,`parent_prod_id`,`prod_name`,`parent_prod_name`,`order_price`,`run_date`,`order_pay_main_id`,`outside_sale_org_id`,`outside_order_no`,`main_create_user_id`)
  373. values ('" . $id . "','". $order_id . "','{$cus_memo}','" . $create_time . "','" . $update_time . "','0','258','" . $pay_status . "','" . $cust_name . "','" . $cust_phone . "','" . $id_type . "','"
  374. . $customer_id . "','0','0','" . $id_p . "','" . $info['448323']['prod_id'] . "','" . $info_p['prod_id'] . "','" . $info['448323']['prod_name'] . "','" . $info_p['prod_name'] . "','" . $tic_info['price'][3] . "','" . $date . "','" . $pay_main_id . "','" . $order_from_org_id . "','" . $return_no . "','" . $user_id . "')";
  375. for_insert($sql);
  376. }
  377. break;
  378. case 'O2':
  379. for ($i = 1; $i <= $v; $i++) {
  380. $id = $order_id = getUniqeId();
  381. $sql = " insert into order_main
  382. (`id`,
  383. `order_id`,`customer_memo`,
  384. `create_time`,`update_time`,
  385. `order_pay_status`,
  386. `order_prod_type`,`order_status`,
  387. `customer_name`,`customer_mobile`,`customer_id_type`,`customer_id_no`,
  388. `order_book_status`,`PROD_START_STATION_TIME_MINUTES`,`parent_order_id`,`prod_id`,`parent_prod_id`,`prod_name`,`parent_prod_name`,`order_price`,`run_date`,`order_pay_main_id`,`outside_sale_org_id`,`outside_order_no`,`main_create_user_id`)
  389. values ('" . $id . "','". $order_id . "','{$cus_memo}','" . $create_time . "','" . $update_time . "','0','258','" . $pay_status . "','" . $cust_name . "','"
  390. . $cust_phone . "','" . $id_type . "','" . $customer_id . "','0','0','" . $id_p . "','" . $info['448327']['prod_id'] . "','" . $info_p['prod_id'] . "','" . $info['448327']['prod_name'] . "','" . $info_p['prod_name'] . "','" . $tic_info['price'][5] . "','" . $date . "','" . $pay_main_id . "','" . $order_from_org_id . "','" . $return_no . "','" . $user_id . "')";
  391. for_insert($sql);
  392. }
  393. break;
  394. }
  395. }
  396. }
  397. //更新库存
  398. foreach( $update_product_array as $update_prod_id => $update_prod_num ) {
  399. if( $update_prod_num > 0 ) {
  400. $sql_update_run = " UPDATE opera_product_run SET SALED_COUNT=SALED_COUNT+{$update_prod_num} WHERE PROD_ID={$update_prod_id} AND RUN_DATE='{$date}' ";
  401. $pdo_update = conn();
  402. $pdo_update->exec($sql_update_run);
  403. }
  404. }
  405. function for_insert($sql)
  406. {
  407. $pdo = conn();
  408. $re = $pdo->exec($sql);
  409. writeLog($sql);
  410. if ($re == 0) {
  411. echo json_encode(array("code" => 1, "info" => $sql));
  412. exit;
  413. }
  414. }
  415. // $json=array();
  416. // $code =0;
  417. // $info = 0;
  418. // $massge = 'success';
  419. // $list = "";
  420. // $json['code'] = $code;
  421. // $json['info'] = $info;
  422. // $json['massge'] = $massge;
  423. // $json['list'] = $list;
  424. $list = array();
  425. $list['type'] = $info_p['prod_name'];
  426. $list['date'] = $date;
  427. $list['desc'] = $return_info;
  428. $list['price'] = $price;
  429. $list['name'] = $cust_name;
  430. $list['phone'] = $cust_phone;
  431. $list['order_id'] = $id_p;
  432. /*
  433. if ($_COOKIE['top_org_id']) {
  434. $no = true_buy_disney($return_no);
  435. if( $no == false || $no == "0" || $no == "-1") {
  436. $send_mobile = "13757163513,18221549731";
  437. $content = "警告:迪士尼门票最终确认失败,自在订单号为".$return_no."。";
  438. sendTelMessage($send_mobile, "", $content, 0);
  439. }
  440. $log = 'disney_' . $no . '_from_zizai';
  441. writeLog($log);
  442. } else {
  443. $sql = "INSERT into `disney_order`(order_id,yet,cust_name,cust_phone,customer_id,ticket_no,date,create_time,dis_the,time) VALUES(" . $id_p . ",1,'" . $cust_name . "','" . $cust_phone . "','" . $customer_id . "','" . $ticket_no_b . "','" . $date . "',null,0,'0');";
  444. $result = $pdo->query($sql);
  445. //$rowset = $result -> fetchAll(PDO::FETCH_ASSOC);
  446. if (!$result) {
  447. echo json_encode(array("code" => 1, "info" => '下单失败'));
  448. exit;
  449. }
  450. }
  451. */
  452. echo json_encode(array("code" => 0, 'order_id' => $id_p, "info" => date('H:i:s', time()), 'ifdisney' => 1, "list" => $list));
  453. exit;