nizongfeng
/
ZZWX
1
0
派生 0
代码 工单 0 合并请求 0 版本发布 0 百科 动态
您最多选择25个主题 主题必须以字母或数字开头，可以包含连字符 (-)，并且长度不得超过35个字符
2 提交
1 分支
38 MiB
 
 
 
 
 
 
分支: master
分支列表 标签列表
${ item.name }
创建分支 ${ searchTerm }
从 'master'
${ noResults }
ZZWX/php_include/add_disney.php

543 行
27 KiB
原始文件 永久链接 Blame 文件历史 

  1. <?php

  2. /* 

  3. * wechat 2.0

  4. * Copyright (c) 2016 yixi wei  http://zhizhuchuxing.com/ 

  5. * Date: 2016.7.12

  6. * Something is to pay QQ1062140302

  7. */ 

  8. 

  9. require_once './Mysql.php';

  10. /**

  11.  * @param type $user_id             下单用户id

  12.  * @param type $playdate            游玩日期

  13.  * @param type $create_time         订单创建时间

  14.  * @param type $customer_name       顾客姓名

  15.  * @param type $customer_phone      顾客电话

  16.  * @param type $customer_id_type    id类型  150身份证 153 护照

  17.  * @param type $customer_id         顾客id号

  18.  * @param type $ticket              订票类型   $ticket=array(

  19.                                                     'D'=>0,//成人票

  20.                                                     'C'=>0,//儿童票

  21.                                                     'O'=>0,//老人票

  22.                                                     'D2'=>0,//成人两日票

  23.                                                     'C2'=>0,//儿童两日票

  24.                                                     'O2'=>0,//老人两日票          

  25.                                                 ); 

  26.  * @param type $return_no           外部订单号

  27.  * @param $order_from_org_id        订单对应组织id

  28.  */

  29. 

  30. //addtheater('998', '111', '2122','111', '1111', '22222', '222', '2222', array( 'AA'=>1,'AB'=>1, 'BB'=>0,  'BA'=>0,  'CA'=>0,'CB'=>0), 1111,'0');

  31. //adddisney('998', '111', '2122', '1111', '22222', '222', '2222', array('D'=>1,'C'=>0,'O'=>0,'D2'=>1,'C2'=>0,'O2'=>0), 1111,'0');

  32. 

  33. function adddisney($user_id,$playdate,$create_time,$customer_name,$customer_phone,$customer_id_type,$customer_id,$ticket,$return_no,$order_from_org_id){

  34.     

  35. $date =isset($playdate)?$playdate:'0';

  36. $cust_name = isset($customer_name)?$customer_name:'匿名';

  37. $cust_phone = isset($customer_phone)?$customer_phone:'0';

  38. $id_type = isset($customer_id_type)? $customer_id_type:'150';                  // 150身份证  153  护照  

  39. $customer_id = isset($customer_id)?$customer_id:'0';

  40. $return_no = isset($return_no)? $return_no:'0';

  41.    $order_status =146;

  42.    $pay_type_id_1 = 275;

  43. $pdo = conn();

  44. $sql = "select  a.prod_id,a.prod_name,b.prod_price,b.prod_type_id "

  45.         . "from opera_product a inner join opera_product_price b on a.prod_id = b.prod_id  "

  46.         . "where a.parent_id = 387267";

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

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

  49. $info = array();

  50. foreach ($rowset as $v) {

  51.     $info[$v['prod_id']] = $v;  

  52. }

  53. $sql_p = "select prod_id,prod_name  "

  54.         . " from opera_product "

  55.         . " where prod_id = 387267";

  56. $result_p=$pdo->query($sql_p);

  57. $rowset_p = $result_p -> fetchAll(PDO::FETCH_ASSOC);

  58. $info_p = $rowset_p[0];

  59. $num=0;

  60. $order_description = "";

  61. $price=0;

  62. foreach ($ticket as $k=>$v) {

  63.     $num+=$v;

  64.     if($v){

  65.         switch ($k){

  66.         case 'D':

  67.             $price+=$info['387538']['prod_price']*$v;

  68.             $order_description.=" 标准一日票,".  date('Y-m-d',time()).",".$v."|";

  69.             break;

  70.         case 'C':

  71.             $price+=$info['387540']['prod_price']*$v;

  72.            $order_description.="儿童一日票,".  date('Y-m-d',time()).",".$v."|";

  73.             break;

  74.         case 'O':

  75.             $price+=$info['387539']['prod_price']*$v;

  76.             $order_description.="老人一日票,".  date('Y-m-d',time()).",".$v."|";

  77.             break;

  78.         case 'C2':

  79.             $price+=$info['387543']['prod_price']*$v;

  80.            $order_description.="儿童两日票,".  date('Y-m-d',time()).",".$v."|";

  81.             break;

  82.         case 'D2':

  83.             $price+=$info['387541']['prod_price']*$v;

  84.            $order_description.="标准两日票,".  date('Y-m-d',time()).",".$v."|"; 

  85.             break;

  86.         case 'O2':

  87.             $price+=$info['387542']['prod_price']*$v;

  88.             $order_description.="老人两日票,".  date('Y-m-d',time()).",".$v."|";

  89.             break;

  90.         }

  91.     }

  92. }

  93. $id_p = getUniqeId();

  94. $order_id_p = $id_p;

  95. $pay_main_id = getUniqeId();

  96. $create_time;

  97. $update_time = $create_time;

  98. $order_pay_status = 0;

  99. //查找数据库中关于迪士尼的信息

  100. $sql_in=" insert  into order_main

  101. (`id`,

  102. `order_id`,

  103. `create_time`,`update_time`,

  104. `order_pay_status`,`order_description`,

  105. `order_price`,`order_prod_type`,`prod_name`,`order_status`,

  106. `customer_name`,`customer_mobile`,`customer_id_type`,`customer_id_no`,

  107. `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`) 

  108. values ('".$id_p."','"

  109.         .$order_id_p."',

  110.         '".$create_time."','".$update_time."','0','".$order_description."','"

  111.         .$price."','258','".$info_p['prod_name']."','".$order_status."','

  112.         ".$cust_name."','".$cust_phone."','".$id_type."','".$customer_id."','0','0','".$info_p['prod_id']."','".$date."','".$user_id."','".$pay_main_id."','".$order_from_org_id."','".$return_no."')";

  113.  for_insert($sql_in);

  114.  //插入支付方式等信息

  115.  $sql_pay="insert INTO"

  116.          . "  `order_pay_main`(id,CREATe_user_id,CREATE_time,update_user_id,pay_total) "

  117.          . "VALUES(".$pay_main_id.",".$user_id.",'".date('Y-m-d H-i-s',  time())."',".$user_id.",".$price.");"

  118.          . "insert INTO  `order_pay_detail`

  119.                 (id,CREATe_user_id,CREATE_time,update_user_id,pay_main_id,pay_type_id_1,pay_money) 

  120.                     VALUES(".$pay_main_id.",".$user_id.",'".date('Y-m-d H-i-s',  time())."',".$user_id.",".$pay_main_id.",'".$pay_type_id_1."',".$price.");";

  121.  for_insert($sql_pay);

  122.  

  123. foreach ($ticket as $k => $v) {

  124.     if($v){

  125.          switch ($k){

  126.         case 'D':

  127.              for($i=1;$i<=$v;$i++){

  128.             $id =$order_id =getUniqeId();

  129.             $sql = " insert  into order_main

  130.                     (`id`,

  131.                     `order_id`,

  132.                     `create_time`,`update_time`,

  133.                     `order_pay_status`,

  134.                     `order_prod_type`,`order_status`,

  135.                     `customer_name`,`customer_mobile`,`customer_id_type`,`customer_id_no`,

  136.                     `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`) 

  137.                     values ('".$id."','"

  138.                     .$order_id."',

  139.                     '".$create_time."','".$update_time."',

  140.                      '0','258','".$order_status."','

  141.                     ".$cust_name."','".$cust_phone."','".$id_type."','".$customer_id."',

  142.                      '0','0','".$id_p."','".$info['387538']['prod_id']."','".$info_p['prod_id']."','".$info['387538']['prod_name']."','".$info_p['prod_name']."','".$info['387538']['prod_price']."','".$date."','".$pay_main_id."','".$order_from_org_id."','".$return_no."','".$user_id."')";

  143.             for_insert($sql);

  144.              }

  145.             break;

  146.    

  147.         case 'C':

  148.              for($i=1;$i<=$v;$i++){

  149.             $id =$order_id =getUniqeId();

  150.             $sql = " insert  into order_main

  151.                     (`id`,

  152.                     `order_id`,

  153.                     `create_time`,`update_time`,

  154.                     `order_pay_status`,

  155.                     `order_prod_type`,`order_status`,

  156.                     `customer_name`,`customer_mobile`,`customer_id_type`,`customer_id_no`,

  157.                     `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`) 

  158.                     values ('".$id."','"

  159.                     .$order_id."',

  160.                     '".$create_time."','".$update_time."',

  161.                      '0','258','".$order_status."','

  162.                     ".$cust_name."','".$cust_phone."','".$id_type."','".$customer_id."',

  163.                      '0','0','".$id_p."','".$info['387540']['prod_id']."','".$info_p['prod_id']."','".$info['387540']['prod_name']."','".$info_p['prod_name']."','".$info['387540']['prod_price']."','".$date."','".$pay_main_id."','".$order_from_org_id."','".$return_no."','".$user_id."')";

  164.              for_insert($sql);

  165.              }

  166.             break;

  167.         case 'O':

  168.             for($i=1;$i<=$v;$i++){

  169.             $id =$order_id =getUniqeId();

  170.             $sql = " insert  into order_main

  171.                     (`id`,

  172.                     `order_id`,

  173.                     `create_time`,`update_time`,

  174.                     `order_pay_status`,

  175.                     `order_prod_type`,`order_status`,

  176.                     `customer_name`,`customer_mobile`,`customer_id_type`,`customer_id_no`,

  177.                     `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`) 

  178.                     values ('".$id."','"

  179.                     .$order_id."',

  180.                     '".$create_time."','".$update_time."',

  181.                      '0','258','".$order_status."','

  182.                     ".$cust_name."','".$cust_phone."','".$id_type."','".$customer_id."',

  183.                      '0','0','".$id_p."','".$info['387539']['prod_id']."','".$info_p['prod_id']."','".$info['387539']['prod_name']."','".$info_p['prod_name']."','".$info['387539']['prod_price']."','".$date."','".$pay_main_id."','".$order_from_org_id."','".$return_no."','".$user_id."')";

  184.             for_insert($sql);

  185.              }

  186.             break;

  187.         case 'C2':

  188.              for($i=1;$i<=$v;$i++){

  189.            $id =$order_id =getUniqeId();

  190.             $sql = " insert  into order_main

  191.                     (`id`,

  192.                     `order_id`,

  193.                     `create_time`,`update_time`,

  194.                     `order_pay_status`,

  195.                     `order_prod_type`,`order_status`,

  196.                     `customer_name`,`customer_mobile`,`customer_id_type`,`customer_id_no`,

  197.                     `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`) 

  198.                     values ('".$id."','"

  199.                     .$order_id."',

  200.                     '".$create_time."','".$update_time."',

  201.                      '0','258','".$order_status."','

  202.                     ".$cust_name."','".$cust_phone."','".$id_type."','".$customer_id."',

  203.                      '0','0','".$id_p."','".$info['387543']['prod_id']."','".$info_p['prod_id']."','".$info['387543']['prod_name']."','".$info_p['prod_name']."','".$info['387543']['prod_price']."','".$date."','".$pay_main_id."','".$order_from_org_id."','".$return_no."','".$user_id."')";

  204.              for_insert($sql);

  205.              }

  206.             break;

  207.         case 'D2':

  208.             for($i=1;$i<=$v;$i++){

  209.             $id =$order_id =getUniqeId();

  210.             $sql = " insert  into order_main

  211.                     (`id`,

  212.                     `order_id`,

  213.                     `create_time`,`update_time`,

  214.                     `order_pay_status`,

  215.                     `order_prod_type`,`order_status`,

  216.                     `customer_name`,`customer_mobile`,`customer_id_type`,`customer_id_no`,

  217.                     `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`) 

  218.                     values ('".$id."','"

  219.                     .$order_id."',

  220.                     '".$create_time."','".$update_time."',

  221.                      '0','258','".$order_status."','

  222.                     ".$cust_name."','".$cust_phone."','".$id_type."','".$customer_id."',

  223.                      '0','0','".$id_p."','".$info['387541']['prod_id']."','".$info_p['prod_id']."','".$info['387541']['prod_name']."','".$info_p['prod_name']."','".$info['387541']['prod_price']."','".$date."','".$pay_main_id."','".$order_from_org_id."','".$return_no."','".$user_id."')";

  224.             for_insert($sql);

  225.              }

  226.             break;

  227.         case 'O2':

  228.             for($i=1;$i<=$v;$i++){

  229.             $id =$order_id =getUniqeId();

  230.             $sql = " insert  into order_main

  231.                     (`id`,

  232.                     `order_id`,

  233.                     `create_time`,`update_time`,

  234.                     `order_pay_status`,

  235.                     `order_prod_type`,`order_status`,

  236.                     `customer_name`,`customer_mobile`,`customer_id_type`,`customer_id_no`,

  237.                     `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`) 

  238.                     values ('".$id."','"

  239.                     .$order_id."',

  240.                     '".$create_time."','".$update_time."',

  241.                      '0','258','".$order_status."','

  242.                     ".$cust_name."','".$cust_phone."','".$id_type."','".$customer_id."',

  243.                      '0','0','".$id_p."','".$info['387542']['prod_id']."','".$info_p['prod_id']."','".$info['387542']['prod_name']."','".$info_p['prod_name']."','".$info['387542']['prod_price']."','".$date."','".$pay_main_id."','".$order_from_org_id."','".$return_no."','".$user_id."')";

  244.             for_insert($sql);

  245.              }

  246.             break;

  247.     }

  248.     } 

  249. }

  250.     

  251. }

  252. /**

  253.  * 

  254.  * @param type $user_id             下单用户id

  255.  * @param type $playdate            游玩日期

  256.  * @param type $playtime            开场时间

  257.  * @param type $create_time         订单创建时间

  258.  * @param type $customer_name       顾客姓名

  259.  * @param type $customer_phone      顾客电话

  260.  * @param type $customer_id_type    id类型  150身份证 153 护照

  261.  * @param type $customer_id         顾客id号

  262. * @param type $ticket              订票类型   $ticket=array(

  263.                                                     'AA'=>0,

  264.                                                     'AB'=>0,

  265.                                                     'BB'=>0,

  266.                                                     'BA'=>0,

  267.                                                     'CA'=>0,

  268.                                                     'CB'=>0,          

  269.                                                 );            

  270.  * @param type $return_no           外部订单号

  271.  * @param $order_from_org_id        订单对应组织id

  272.  * 

  273.  */

  274. function addtheater($user_id,$playdate,$playtime,$create_time,$customer_name,$customer_phone,$customer_id_type,$customer_id,$ticket,$return_no,$order_from_org_id){

  275.     $date = $playdate;

  276.     $time = $playtime;

  277.     $cust_name = $customer_name;

  278.     $cust_phone =$customer_phone;

  279.     $id_type =$customer_id_type;                  // 150身份证  153  护照  

  280.     $customer_id = $customer_id;

  281. //    $ticket=array(

  282. //        'AA'=>isset($_POST['AA'])?$_POST['AA']:0,

  283. //        'AB'=>isset($_POST['AB'])?$_POST['AB']:0,

  284. //        'BB'=>isset($_POST['BB'])?$_POST['BB']:0,

  285. //        'BA'=>isset($_POST['BA'])?$_POST['BA']:0,

  286. //        'CA'=>isset($_POST['CA'])?$_POST['CA']:0,

  287. //        'CB'=>isset($_POST['CB'])?$_POST['CB']:0,          

  288. //    );

  289. 

  290. 

  291.  $tic_buy =$return_no;

  292. $pdo = conn();

  293. $sql = "select  a.prod_id,a.prod_name,b.prod_price,b.prod_type_id "

  294.         . "from opera_product a inner join opera_product_price b on a.prod_id = b.prod_id  "

  295.         . "where a.parent_id = 387544";

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

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

  298. $info = array();

  299. foreach ($rowset as $v) {

  300.     $info[$v['prod_id']] = $v;  

  301. }

  302. $sql_p = "select prod_id,prod_name  "

  303.         . " from opera_product "

  304.         . " where prod_id = 387544";

  305. $result_p=$pdo->query($sql_p);

  306. $rowset_p = $result_p -> fetchAll(PDO::FETCH_ASSOC);

  307. $info_p = $rowset_p[0];

  308. $num=0;

  309. $order_description = "";

  310. $price=0;

  311. $return_info='';

  312. //var_dump($info);die;

  313. foreach ($ticket as $k=>$v) {

  314.     $num+=$v;

  315.     if($v){

  316.         switch ($k){

  317.         case 'AA':

  318.             $price+=$info['387545']['prod_price']*$v;

  319.             $return_info.='  AA区 × '.$v;

  320.             $order_description.="迪士尼剧场AA区,".  date('Y-m-d',time()).",".$v."|";

  321.             break;

  322.         case 'AB':

  323.             $price+=$info['387546']['prod_price']*$v;

  324.              $return_info.='    AB区 × '.$v;

  325.            $order_description.="迪士尼剧场AB区,".  date('Y-m-d',time()).",".$v."|";

  326.             break;

  327.         case 'BB':

  328.             $price+=$info['387547']['prod_price']*$v;

  329.              $return_info.='    BB区 × '.$v;

  330.             $order_description.="迪士尼剧场BB区,".  date('Y-m-d',time()).",".$v."|";

  331.             break;

  332.         case 'BA':

  333.             $price+=$info['387548']['prod_price']*$v;

  334.              $return_info.='    BA区 × '.$v;

  335.            $order_description.="迪士尼剧场BA区,".  date('Y-m-d',time()).",".$v."|";

  336.             break;

  337.         case 'CA':

  338.             $price+=$info['387549']['prod_price']*$v;

  339.              $return_info.='    CA区 × '.$v;

  340.            $order_description.="迪士尼剧场CA区,".  date('Y-m-d',time()).",".$v."|"; 

  341.             break;

  342.         case 'CB':

  343.             $price+=$info['387550']['prod_price']*$v;

  344.              $return_info.='    CB区 × '.$v;

  345.             $order_description.="迪士尼剧场CB区,".  date('Y-m-d',time()).",".$v."|";

  346.             break;

  347.         }

  348.     }

  349. }

  350. 

  351. 

  352.      $pay_status =146;

  353.     $pay_type_id_1 = 275;

  354. 

  355. $id_p = $order_id_p = getUniqeId();

  356. $pay_main_id = getUniqeId();

  357. $update_time =$create_time;

  358. $order_pay_status = 0;

  359. //查找数据库中关于迪士尼的信息

  360. $sql_in=" insert  into order_main

  361. (`id`,

  362. `order_id`,

  363. `create_time`,`update_time`,

  364. `order_pay_status`,`order_description`,

  365. `order_price`,`order_prod_type`,`prod_name`,`order_status`,

  366. `customer_name`,`customer_mobile`,`customer_id_type`,`customer_id_no`,

  367. `order_book_status`,`PROD_START_STATION_TIME_MINUTES`,`prod_id`,`run_date`,`run_time`,`main_create_user_id`,`order_pay_main_id`,`outside_sale_org_id`,`outside_order_no`) 

  368. values ('".$id_p."','"

  369.         .$order_id_p."',

  370.         '".$create_time."','".$update_time."','0','".$order_description."','"

  371.         .$price."','259','".$info_p['prod_name']."','".$pay_status."','

  372.         ".$cust_name."','".$cust_phone."','".$id_type."','".$customer_id."','1','0','".$info_p['prod_id']."','".$date."','".$time."','".$user_id."','".$pay_main_id."','".$order_from_org_id."','".$tic_buy."')";

  373.  for_insert($sql_in);

  374.  

  375.   $sql_pay="insert INTO"

  376.          . "  `order_pay_main`(id,CREATe_user_id,CREATE_time,update_user_id,pay_total) "

  377.          . "VALUES(".$pay_main_id.",".$user_id.",'".date('Y-m-d H-i-s',  time())."',".$user_id.",".$price.");"

  378.          . "insert INTO  `order_pay_detail`

  379.                 (id,CREATe_user_id,CREATE_time,update_user_id,pay_main_id,pay_type_id_1,pay_money) 

  380.                     VALUES(".$pay_main_id.",".$user_id.",'".date('Y-m-d H-i-s',  time())."',".$user_id.",".$pay_main_id.",".$pay_type_id_1.",".$price.");";

  381.  for_insert($sql_pay);

  382. 

  383. foreach ($ticket as $k => $v) {

  384.     if($v){

  385.          switch ($k){

  386.         case 'AA':

  387.              for($i=1;$i<=$v;$i++){

  388.             $id =$order_id =getUniqeId();

  389.             $sql = " insert  into order_main

  390.                     (`id`,

  391.                     `order_id`,

  392.                     `create_time`,`update_time`,

  393.                     `order_pay_status`,

  394.                     `order_prod_type`,`order_status`,

  395.                     `customer_name`,`customer_mobile`,`customer_id_type`,`customer_id_no`,

  396.                     `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`,`run_time`,`order_pay_main_id`,`outside_sale_org_id`,`outside_order_no`,`main_create_user_id`) 

  397.                     values ('".$id."','"

  398.                     .$order_id."',

  399.                     '".$create_time."','".$update_time."',

  400.                      '0','259','".$pay_status."','

  401.                     ".$cust_name."','".$cust_phone."','".$id_type."','".$customer_id."',

  402.                      '0','0','".$id_p."','".$info['387545']['prod_id']."','".$info_p['prod_id']."','".$info['387545']['prod_name']."','".$info_p['prod_name']."','".$info['387545']['prod_price']."','".$date."','".$time."','".$pay_main_id."','".$order_from_org_id."','".$tic_buy."','".$user_id."')";

  403.             for_insert($sql);

  404.              }

  405.             break;

  406.    

  407.         case 'AB':

  408.              for($i=1;$i<=$v;$i++){

  409.             $id =$order_id =getUniqeId();

  410.             $sql = " insert  into order_main

  411.                     (`id`,

  412.                     `order_id`,

  413.                     `create_time`,`update_time`,

  414.                     `order_pay_status`,

  415.                     `order_prod_type`,`order_status`,

  416.                     `customer_name`,`customer_mobile`,`customer_id_type`,`customer_id_no`,

  417.                     `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`,`run_time`,`order_pay_main_id`,`outside_sale_org_id`,`outside_order_no`,`main_create_user_id`) 

  418.                     values ('".$id."','"

  419.                     .$order_id."',

  420.                     '".$create_time."','".$update_time."',

  421.                      '0','259','".$pay_status."','

  422.                     ".$cust_name."','".$cust_phone."','".$id_type."','".$customer_id."',

  423.                      '0','0','".$id_p."','".$info['387546']['prod_id']."','".$info_p['prod_id']."','".$info['387546']['prod_name']."','".$info_p['prod_name']."','".$info['387546']['prod_price']."','".$date."','".$time."','".$pay_main_id."','".$order_from_org_id."','".$tic_buy."','".$user_id."')";

  424.              for_insert($sql);

  425.              }

  426.             break;

  427.         case 'BB':

  428.             for($i=1;$i<=$v;$i++){

  429.             $id =$order_id =getUniqeId();

  430.             $sql = " insert  into order_main

  431.                     (`id`,

  432.                     `order_id`,

  433.                     `create_time`,`update_time`,

  434.                     `order_pay_status`,

  435.                     `order_prod_type`,`order_status`,

  436.                     `customer_name`,`customer_mobile`,`customer_id_type`,`customer_id_no`,

  437.                     `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`,`run_time`,`order_pay_main_id`,`outside_sale_org_id`,`outside_order_no`,`main_create_user_id`) 

  438.                     values ('".$id."','"

  439.                     .$order_id."',

  440.                     '".$create_time."','".$update_time."',

  441.                      '0','259','".$pay_status."','

  442.                     ".$cust_name."','".$cust_phone."','".$id_type."','".$customer_id."',

  443.                      '0','0','".$id_p."','".$info['387547']['prod_id']."','".$info_p['prod_id']."','".$info['387547']['prod_name']."','".$info_p['prod_name']."','".$info['387547']['prod_price']."','".$date."','".$time."','".$pay_main_id."','".$order_from_org_id."','".$tic_buy."','".$user_id."')";

  444.             for_insert($sql);

  445.              }

  446.             break;

  447.         case 'BA':

  448.              for($i=1;$i<=$v;$i++){

  449.            $id =$order_id =getUniqeId();

  450.             $sql = " insert  into order_main

  451.                     (`id`,

  452.                     `order_id`,

  453.                     `create_time`,`update_time`,

  454.                     `order_pay_status`,

  455.                     `order_prod_type`,`order_status`,

  456.                     `customer_name`,`customer_mobile`,`customer_id_type`,`customer_id_no`,

  457.                     `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`,`run_time`,`order_pay_main_id`,`outside_sale_org_id`,`outside_order_no`,`main_create_user_id`) 

  458.                     values ('".$id."','"

  459.                     .$order_id."',

  460.                     '".$create_time."','".$update_time."',

  461.                      '0','259','".$pay_status."','

  462.                     ".$cust_name."','".$cust_phone."','".$id_type."','".$customer_id."',

  463.                      '0','0','".$id_p."','".$info['387548']['prod_id']."','".$info_p['prod_id']."','".$info['387548']['prod_name']."','".$info_p['prod_name']."','".$info['387548']['prod_price']."','".$date."','".$time."','".$pay_main_id."','".$order_from_org_id."','".$tic_buy."','".$user_id."')";

  464.              for_insert($sql);

  465.              }

  466.             break;

  467.         case 'CA':

  468.             for($i=1;$i<=$v;$i++){

  469.             $id =$order_id =getUniqeId();

  470.             $sql = " insert  into order_main

  471.                     (`id`,

  472.                     `order_id`,

  473.                     `create_time`,`update_time`,

  474.                     `order_pay_status`,

  475.                     `order_prod_type`,`order_status`,

  476.                     `customer_name`,`customer_mobile`,`customer_id_type`,`customer_id_no`,

  477.                     `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`,`run_time`,`order_pay_main_id`,`outside_sale_org_id`,`outside_order_no`,`main_create_user_id`) 

  478.                     values ('".$id."','"

  479.                     .$order_id."',

  480.                     '".$create_time."','".$update_time."',

  481.                      '0','259','".$pay_status."','

  482.                     ".$cust_name."','".$cust_phone."','".$id_type."','".$customer_id."',

  483.                      '0','0','".$id_p."','".$info['387549']['prod_id']."','".$info_p['prod_id']."','".$info['387549']['prod_name']."','".$info_p['prod_name']."','".$info['387549']['prod_price']."','".$date."','".$time."','".$pay_main_id."','".$order_from_org_id."','".$tic_buy."','".$user_id."')";

  484.             for_insert($sql);

  485.              }

  486.             break;

  487.         case 'CB':

  488.             for($i=1;$i<=$v;$i++){

  489.             $id =$order_id =getUniqeId();

  490.             $sql = " insert  into order_main

  491.                     (`id`,

  492.                     `order_id`,

  493.                     `create_time`,`update_time`,

  494.                     `order_pay_status`,

  495.                     `order_prod_type`,`order_status`,

  496.                     `customer_name`,`customer_mobile`,`customer_id_type`,`customer_id_no`,

  497.                     `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`,`run_time`,`order_pay_main_id`,`outside_sale_org_id`,`outside_order_no`,`main_create_user_id`) 

  498.                     values ('".$id."','"

  499.                     .$order_id."',

  500.                     '".$create_time."','".$update_time."',

  501.                      '0','259','".$pay_status."','

  502.                     ".$cust_name."','".$cust_phone."','".$id_type."','".$customer_id."',

  503.                      '0','0','".$id_p."','".$info['387550']['prod_id']."','".$info_p['prod_id']."','".$info['387550']['prod_name']."','".$info_p['prod_name']."','".$info['387550']['prod_price']."','".$date."','".$time."','".$pay_main_id."','".$order_from_org_id."','".$tic_buy."','".$user_id."')";

  504.             for_insert($sql);

  505.              }

  506.             break;

  507.     }

  508. }} 

  509. }

  510. 

  511. 

  512. function  for_insert($sql){

  513. $pdo = conn();

  514. $re = $pdo->exec($sql); 

  515. if($re==0){

  516.     echo $sql;

  517.     exit ;

  518. }

  519. } 

  520. 

  521. 

  522. 

  523. 

  524. 

  525. 

  526. 

  527. 

  528. 

  529. 

  530. 

  531. 

  532. 

  533. 

  534. 

  535. 

  536. 

  537. 

  538. 

  539. 

  540. 

  541.