<?php require_once('../Connections/BE2.php'); ?>
<? 
 
   $logpath="/www2/skybni/log/wanpaylog.txt";

   $fp = fopen($logpath, "a");
   //$_SERVER['HTTP_REFERER'];  
   $ref=isset($_SERVER['HTTP_REFERER'])?$_SERVER['HTTP_REFERER']:"";
   fwrite($fp,"start log ".$ref." response " .date('Y-m-d H:i:s')."\r\n");
   $a=count($_POST);
   fwrite($fp,"=====POST====================="."\r\n"); 
   if($a>0){	
     foreach($_POST as $key=>$value){
      // echo "$key=$value";
	   fwrite($fp,"$key=$value"."\r\n");
       }  	
	  //====== start respone====================//
	 $pass_data=0; 
	 $td= isset($_POST['out_trade_no'])?$_POST['out_trade_no']:'0'; //out_trade_no=2025031416194900006
	 mysql_select_db($database_BE2, $BE2);
	 //2025031307563300062
     //2025031223104800431
     $q1 = sprintf("SELECT * FROM order_tmp2 WHERE dcode='%s' order by did desc limit 1",$td);
     $Rq1 = mysql_query($q1, $BE2) or die(mysql_error());
     $row_Rq1 = mysql_fetch_assoc($Rq1);
	 $totalRows_Rq1 = mysql_num_rows($Rq1);
	 //fwrite($fp,"found  order_tmp2 $q1"."\r\n");
	 
	 if($totalRows_Rq1==1){
	    if($row_Rq1['dwanpay']==1){
			//fwrite($fp,"update order_tmp2 set dwanpay=2"."\r\n");
			$UpSQL1 = sprintf("update order_tmp2 set dwanpay='2' where dcode='%s' AND did='%s'",$td,$row_Rq1['did'] );
		    mysql_select_db($database_BE2, $BE2);
            mysql_query($UpSQL1, $BE2) or die(mysql_error());
			//fwrite($fp,$UpSQL1."\r\n");
			$pass_data=1;
		} 
			 
	 } 
	 mysql_free_result($Rq1); 
	 if($pass_data>0){
         // start excel data	 
	  // fwrite($fp,$td ."pass_data"."\r\n");	 
	  if( strlen($td)==19 ){
     //fwrite($fp,$td ." ==>ok"."\r\n");
	 
	 mysql_select_db($database_BE2, $BE2);
     $query_Rtn = sprintf("SELECT a.*,b.mem_num FROM order_tmp2 as a,member as b WHERE a.duser=b.mem_auto AND a.dcode='%s'",$td);
     $Rtn = mysql_query($query_Rtn, $BE2) or die(mysql_error());
     $row_Rtn = mysql_fetch_assoc($Rtn);
     $ssid=$row_Rtn['dsess'];
	 $dpay=$row_Rtn['dpay'];// ,1,2,3,4 
	 $duser=$row_Rtn['duser']; // user id
	 $puser=$row_Rtn['mem_num']; // par id
	 $ppuser=0; // par id
	 //fwrite($fp,"step 2 ==>".$query_Rtn ."\r\n");
	 mysql_free_result($Rtn);  
	 
	 // 開發商  company_boss
	 mysql_select_db($database_BE2, $BE2);
    // $query_Rtp1 = sprintf("SELECT a.mem_auto,a.mem_num as ppid FROM member as a, company as b WHERE a.mem_num=b.mid AND b.company_boss='Y' AND a.mem_auto='%s' " ,$puser);
     $query_Rtp1 = sprintf("SELECT mem_auto,mem_num FROM member WHERE mem_auto='%s' AND mem_check<>'N'" ,$puser);

	 $Rtp1 = mysql_query($query_Rtp1, $BE2) or die(mysql_error());
     $row_Rtp1 = mysql_fetch_assoc($Rtp1);
	 $totalRows_Rtp1 = mysql_num_rows($Rtp1);
	 // fwrite($fp,"step 3 ==>".$query_Rtp1 ."\r\n");
	 if($totalRows_Rtp1>0){ $ppuser=$row_Rtp1['mem_num'] ;}
	 mysql_free_result($Rtp1); 
	 
	 
	 
	 $testpay=isset($_POST['testpay'])?1:0;  
	 // esafe in
	 $write="";
	 $errcode= isset($_POST['errcode'])?$_POST['errcode']:'XX'; 
	 //if(($errcode=='00')||($dpay>2)|| ($testpay>0) ){  // local pay
	 
	   mysql_select_db($database_BE2, $BE2);
       $query_Rtb = sprintf("SELECT * From order_bill WHERE dcode='%s'",$td) ;
       $Rtb = mysql_query($query_Rtb, $BE2) or die(mysql_error());
       $row_Rtb = mysql_fetch_assoc($Rtb); 
	   
	   if( $row_Rtb['ck']=='N'){ // 檢查發票檔
        $buyid=$row_Rtb['mem_id']; // buyer id
		
		
	    mysql_select_db($database_BE2, $BE2);
        $qr_paycoid = sprintf("SELECT distinct(coid) FROM order_tmp WHERE dcode='%s'",$td);
        $Rtco = mysql_query($qr_paycoid, $BE2) or die(mysql_error());
        $row_Rtco = mysql_fetch_assoc($Rtco);
	    $coid=$row_Rtco['coid']; // companyid
		
		mysql_free_result($Rtco); 
	 
   	    $write="Y";	
		$tdate=date('Y-m-d'); 
	 	$pay1[0]='N' ;// 付款flag
		$pay1[1]='' ; //  付款銀行 紅陽金 dbank
		$pay1[2]='' ; // pay dpaydate
		if($dpay<3){
			$pay1[0]='Y';
			$pay1[1]='Wanpay金流' ;// 紅陽金流 付款銀行 紅陽金 dban
			$pay1[2]=$tdate ;// pay dpaydate
		}
	
	
	
		// 分頁 end
	    $insertSQL1 = sprintf("insert into order_datam(dcode,dmoney,dexpess,dall,dcash,dsky,ddate,dpay,duser,dpaydate,dflag,dbank,coid)select dcode,dmoney,dexpess,dall,dcash,dsky,ddate,dpay,duser,concat('%s'),concat('%s'),concat('%s'),concat('%s') from order_tmp2 where dcode='%s'",$pay1[2],$pay1[0],$pay1[1],$coid,$td);
		//echo $insertSQL1 ."<br>";
        mysql_select_db($database_BE2, $BE2);
		mysql_query($insertSQL1, $BE2) or die(mysql_error());
        
		
		/* order_rtype 7 使用雲點數   did saveto eccid      */
		$insQ6 =sprintf("insert into order_point(eccid,euid,e_type,e_oval,e_date,e_flag) select did,duser,concat('7'),dsky,concat('%s'),concat('Y') from order_datam where dsky>0 AND dcode='%s'",date('Y-m-d'), $td);
 
		mysql_select_db($database_BE2, $BE2);
	    mysql_query($insQ6 ,$BE2) or die(mysql_error());
		
		 fwrite($fp,$insQ6 ." ==> 7 使用雲點數"."\r\n");
		 //order_tmp p_percent  p_percent31 
		 //p_percent   p_percent*p_count 推廣獎金 
		 //p_percent2  p_percent2*p_count 開發獎金
		 //p_percent3  p_percent3 33 首次開店獎金 
		 //p_percent4  p_percent4 34  推廣雲點
		 //p_percent5  p_percent5 35  開發雲點
		 //p_percent6  p_percent6 36  開發商續推獎金
         //p_percent7  p_percent37  經銷獎金
         //p_percent8  p_percent38  分享獎金  new 241209 
         //p_percent9  p_percent39  推薦獎金  new 241209  to sql tablename pptname 

		 //p_demoney   p_demoney   繳金額
		 //                 1         2         3          4            5               6
		 // $pp1=array("",'推廣獎金','開發獎金','開發商首推獎金','商品未付餘額','開發商續推獎金','經銷獎金');
	    // dis ,p_demoney
	    $insertSQL2 = sprintf("insert into order_datas(dcode,mem_auto,p_money,p_count,p_size,p_percent,p_percent2,p_percent3,p_percent4,p_percent5,p_percent6,p_percent7,p_demoney,p_once)select dcode,mem_auto,p_money,p_count,p_size,p_percent*p_count,p_percent2*p_count,p_percent3,p_percent4,p_percent5,p_percent6,p_percent7,p_demoney,p_once from order_tmp where dcode='%s'",$td);
		// echo $insertSQL2 ."<br>";
		 
        mysql_select_db($database_BE2, $BE2);
		mysql_query($insertSQL2, $BE2) or die(mysql_error());
     
	    // 分頁 end
 
        $UpSQL1 = sprintf("update order_tmp2 set dsess='',dcode='' where dcode='%s'",$td );
		//echo $UpSQL1 ."<br>";
		 
		mysql_select_db($database_BE2, $BE2);
        mysql_query($UpSQL1, $BE2) or die(mysql_error());
		 
        
	    $UpSQL2 = sprintf("update order_tmp set p_sess='',dcode='' where dcode='%s'",$td );
		//echo $UpSQL2 ."<br>";
		mysql_select_db($database_BE2, $BE2);
        mysql_query($UpSQL2, $BE2) or die(mysql_error());
        
		// p_percent31
		// ccid data slave id , pid ,duid , money ,date ,
        // pid ,ccid, puid ,duid, pmoney ,pdate ,pflag
 
		//mysql_free_result($Rtcp); 
		
		$puser_mck = sprintf("select mem_check  from member where mem_auto='%s'",$puser );
		mysql_select_db($database_BE2, $BE2);
		$Rfck = mysql_query($puser_mck, $BE2) or die(mysql_error());
        $row_Rfck = mysql_fetch_assoc($Rfck);
	    $fpck=$row_Rfck['mem_check']; // companyid
		
		mysql_free_result($Rfck);
		
		/*
		 p_percent ($row_Rqr1['p_percent31']==0)?round(($row_Rqr1['p_money']*0.03),0 ):"0";  
         p_percent2($row_Rqr1['p_percent31']==0)?round(($row_Rqr1['p_money']*0.02),0 ):"0";  
         p_percent3 =0
         p_percent31  推廣獎金
         p_percent32  開發獎金 
         p_percent33  首次特別開發費 單次 首次開店獎金
         p_percent34  推廣雲點
         p_percent35   開發雲點
		 p_demoney 未繳金額
		*/
		
		// 首次(1年內)開店獎金 介紹人必需開發商 給上線 -->開發商直銷獎金  
		// 直推獎金 續約1年以後 開發商直銷獎金   
		if($fpck=='Y'|| $fpck=='V'){
			//              1         2         3          4              5               6
			//$pp1=array("",'推廣獎金','開發獎金','開發商直銷獎金','商品未付餘額','開發商續推獎金','直銷獎金');
 
 
		   $insertSQLp0 =sprintf("insert into order_percent(ccid,puid,duid,pmoney,pdate,pkid) 
		select ccid,concat('%s'),concat('%s'),p_percent3,concat('%s'), concat('3') from order_datas where p_percent3>0 AND p_once=0 AND dcode='%s'",$puser,$duser,date('Y-m-d'),$td);
		   mysql_select_db($database_BE2, $BE2);
	       mysql_query($insertSQLp0, $BE2) or die(mysql_error());
		   
		   $insertSQLp1 =sprintf("insert into order_percent(ccid,puid,duid,pmoney,pdate,pkid) 
		select ccid,concat('%s'),concat('%s'),p_percent6,concat('%s'), concat('5') from order_datas where p_percent6>0 AND p_once=1 AND dcode='%s'",$puser,$duser,date('Y-m-d'),$td);
		   mysql_select_db($database_BE2, $BE2);
	       mysql_query($insertSQLp1, $BE2) or die(mysql_error());
		////////////////////////////////
		  
		  	   // 直銷獎金
	     $insertSQLp3 =sprintf("insert into order_percent(ccid,puid,duid,pmoney,pdate,pkid) 
		select ccid,concat('%s'),concat('%s'),p_percent7,concat('%s'), concat('6') from order_datas where p_percent7>0 AND dcode='%s'",$puser,$duser,date('Y-m-d'),$td);
		  mysql_select_db($database_BE2, $BE2);
	      mysql_query($insertSQLp3, $BE2) or die(mysql_error());
		   
		   
		 } else{
	    //推廣獎金  (一般會員) 給上線 ->會員推廣獎金
		   $insertSQLp =sprintf("insert into order_percent(ccid,puid,duid,pmoney,pdate,pkid) 
		select ccid,concat('%s'),concat('%s'),p_percent,concat('%s'),concat('1') from order_datas where p_percent>0 AND dcode='%s'",$puser,$duser,date('Y-m-d'),$td);
		   mysql_select_db($database_BE2, $BE2);
	       mysql_query($insertSQLp, $BE2) or die(mysql_error());
		 }
		  /*
		 //推廣獎金  (一般會員) 給上線 ->會員推廣獎金
		 $insertSQLp =sprintf("insert into order_percent(ccid,puid,duid,pmoney,pdate,pkid) 
		select ccid,concat('%s'),concat('%s'),p_percent,concat('%s'),concat('1') from order_datas where p_percent>0 AND dcode='%s'",$puser,$duser,date('Y-m-d'),$td);
		 mysql_select_db($database_BE2, $BE2);
	     mysql_query($insertSQLp, $BE2) or die(mysql_error());
		  */  
		
 		 
		//開發獎金  p_percent2 必需開發商 給上線 -> 開發商開發獎金 
	    if($ppuser>0){ 
		  //確定 開發商開發獎金  
	      $insertSQLp2 =sprintf("insert into order_percent(ccid,puid,duid,pmoney,pdate,pkid) 
		select ccid,concat('%s'),concat('%s'),p_percent2,concat('%s'),concat('2') from order_datas where p_percent2>0 AND dcode='%s'",$ppuser,$duser,date('Y-m-d'),$td);
		   mysql_select_db($database_BE2, $BE2);
	       mysql_query($insertSQLp2, $BE2) or die(mysql_error());
		
		 }
 
		 // '推廣獎金','開發獎金','開發商直銷獎金','商品未付餘額','開發商續推獎金','直銷獎金';
        $insertSQLp2a =sprintf("insert into order_percent(ccid,puid,duid,depmoney,pdate,pkid) 
		select ccid,concat('%s'),concat('%s'),p_demoney,concat('%s'),concat('4') from order_datas where p_demoney>0 AND dcode='%s'",$duser,$duser,date('Y-m-d'),$td);
		   mysql_select_db($database_BE2, $BE2);
	       mysql_query($insertSQLp2a, $BE2) or die(mysql_error());
  		
	    $order2 = sprintf("select * from order_datas where dcode='%s'",$td );
		mysql_select_db($database_BE2, $BE2);
		$R2 = mysql_query($order2, $BE2) or die(mysql_error());
        $row_R2 = mysql_fetch_assoc($R2);
		$fR2=0;
		$fR2=$row_R2['p_percent']+$row_R2['p_percent2']+$row_R2['p_percent3']+$row_R2['p_percent4']+$row_R2['p_percent5']+$row_R2['p_percent6']+$row_R2['p_percent7'];
		mysql_free_result($R2);
		
	   //echo $fR2.' ,' .$td."<br>";;
		
		/*  order_datas,mem_auto - 2% to 抽成  order_rtype */
		if($fR2==0){ // 有獎金 無抽成,回饋
			
	  	 $insertSQL3 =sprintf("insert into order_point(eccid,euid,e_type,e_ival,e_date) 
		select ccid,concat('%s'),concat('%s'),(p_money*0.03),concat('%s') from order_datas where p_percent=0 AND dcode='%s'",$puser,"1",date('Y-m-d'),$td);
		 mysql_select_db($database_BE2, $BE2);
	     mysql_query($insertSQL3, $BE2) or die(mysql_error());
		/*  1 - 2% to 抽成 介紹人  */
		
         $insertSQL4 =sprintf("insert into order_point(eccid,euid,e_type,e_ival,e_date) 
		select ccid,concat('%s'),concat('%s'),(p_money*0.02),concat('%s') from order_datas where p_percent=0 AND dcode='%s'",$duser,"2",date('Y-m-d'),$td);
		 mysql_select_db($database_BE2, $BE2);
	     mysql_query($insertSQL4, $BE2) or die(mysql_error());
		/*  2 - 3% to 回饋 自己  */
		}
		
		
        $insertSQL4 =sprintf("insert into order_point(eccid,euid,e_type,e_ival,e_date) 
		select ccid,concat('%s'),concat('%s'),p_percent4,concat('%s') from order_datas where p_percent4>0 AND dcode='%s'",$puser,"10",date('Y-m-d'),$td);
		mysql_select_db($database_BE2, $BE2);
	    mysql_query($insertSQL4, $BE2) or die(mysql_error());
		/*  10 - 3% to 推廣雲點 介紹人 order_rtype */	
		
        $insertSQL4 =sprintf("insert into order_point(eccid,euid,e_type,e_ival,e_date) 
		select ccid,concat('%s'),concat('%s'),p_percent5,concat('%s') from order_datas where p_percent5>0 AND dcode='%s'",$ppuser,"11",date('Y-m-d'),$td);
		mysql_select_db($database_BE2, $BE2);
	    mysql_query($insertSQL4, $BE2) or die(mysql_error());
	
		/*  11 - to 開發雲點 介紹人 必需開發商 給上上線  order_rtype 
		1 未繳 x 上線
		2 首次推動金,金額不對
		3 購買購買
		*/		
		$insertSQL5 =sprintf("insert into order_point(eccid,euid,e_type,e_ival,e_date) 
		select ccid,concat('%s'),concat('%s'),(p_money*0.05),concat('%s') from order_datas where dcode='%s'","1","3",date('Y-m-d'),$td);
		mysql_select_db($database_BE2, $BE2);
	    mysql_query($insertSQL5, $BE2) or die(mysql_error());
		/*  3 - 5% to 官網收  */
		
		$insertSQL6 =sprintf("insert into order_point(eccid,euid,e_type,e_ival,e_date) 
		select ccid,concat('%s'),concat('%s'),(p_money*0.05),concat('%s') from order_datas where dcode='%s'","1","4",date('Y-m-d'),$td);
		mysql_select_db($database_BE2, $BE2);
	    mysql_query($insertSQL6, $BE2) or die(mysql_error());
		/*  4 - 5% to 營業稅  */
		
		$insertSQL7 =sprintf("insert into order_point(eccid,euid,e_type,e_ival,e_date) 
		select ccid,concat('%s'),concat('%s'),(p_money*0.028),concat('%s') from order_datas where dcode='%s'","1","5",date('Y-m-d'),$td);
		mysql_select_db($database_BE2, $BE2);
	    mysql_query($insertSQL7, $BE2) or die(mysql_error());
		/*  5 - 2% to 紅陽金流  */

	 // mem_check  N:無, Y:網店 , V:開發商網店 
	 $update10 =sprintf("update member as a,order_datas as b,order_datam as c,sp_product as d SET a.mem_check=d.ss_ck WHERE b.mem_auto=d.ss_id AND b.dcode=c.dcode AND c.duser=a.mem_auto AND a.mem_auto='%s' AND a.mem_check='N' AND  b.dcode='%s'",$buyid,$td);
	 mysql_select_db($database_BE2, $BE2);
	 mysql_query($update10, $BE2) or die(mysql_error());		
	 fwrite($fp,$update10." ==>  更新網店資訊"."\r\n");	
	 // m_addemo   N:無, Y:廣告會員 , 廣告會員
	 //
	 
	 /*
	 $update11 =sprintf("update member as a,order_datas as b,order_datam as c,sp_product as d SET a.mem_check=d.ss_ck WHERE b.mem_auto=d.ss_id AND b.dcode=c.dcode AND c.duser=a.mem_auto AND a.mem_auto='%s' AND a.mem_check='N' AND  b.dcode='%s'",$buyid,$td);
	 mysql_select_db($database_BE2, $BE2);
	 mysql_query($update11, $BE2) or die(mysql_error());		
	 fwrite($fp,$update10." ==>  更新網店獎金 尚未付款金額(開設開發商"."\r\n");	
	 	*/ 	
	  //開立發票檔 
 
     mysql_select_db($database_BE2, $BE2);
     $query_Rt2 = sprintf("SELECT * From order_bill WHERE dcode='%s'",$td) ;
     $Rt2 = mysql_query($query_Rt2, $BE2) or die(mysql_error());
     $row_Rt2 = mysql_fetch_assoc($Rt2);
	
    //update order_bill set ck='Y',billcode='%s' //發票檔
	 // $enable_bill0=true; and($enable_bill0==true)
     if( $row_Rt2['ck']=='N'){ 
	
    $url='https://www.giveme.com.tw/invoice.do?action=addB2C';
    if($row_Rt2['selb2c']==0){ $url='https://www.giveme.com.tw/invoice.do?action=addB2B';}
 
     fwrite($fp,"======發票檔============"."\r\n");
  // b2b
    if($row_Rt2['selb2c']==0){
     $data = '{"timeStamp":"","uncode":"","idno":"","sign":"","customerName":"","phone":"","datetime":"","email":"","taxState":"0","taxType":0,"sales":0,"amount":0,"totalFee":0,"content":"","items":[]}';
    } else { $data = '{"timeStamp":"","uncode":"","idno":"","sign":"","customerName":"","phone":"","orderCode":"","datetime":"","email":"","state":"0","donationCode":"","taxType":0,"sales":0,"amount":0,"totalFee":0,"content":"","items":[]}'; }
			
    $decoded_json = json_decode($data, true);

    $decoded_json["timeStamp"]=time().rand(100,999);
    $decoded_json["uncode"]="42656789";
    $decoded_json["idno"]="A126569032";  
    $decoded_json["datetime"]=date('Y-m-d');  
    $decoded_json["email"]=$row_Rt2['email'];
    $pwd= "AX6789";
    $sign= $decoded_json['timeStamp'].$decoded_json['idno'].$pwd ;// 822344324
    $sign= strtoupper(md5($sign));
    $decoded_json['sign']=$sign;
	
  //  $rtInsertSQL2 = sprintf("select * From order_bill
  // (dcode,mem_id,selb2c,uncode,qphone,donationcode,email,ordertime,billcode,ck) VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')",


    if($row_Rt2['selb2c']==1){
	 $decoded_json["customerName"]=$td;//'82401230082' 
	 if($row_Rt2['donationcode']<>''){
		 $decoded_json["donationCode"]=$row_Rt2['donationcode'];
		 $decoded_json["state"]="1";
		 $decoded_json["phone"]="";
		 $decoded_json["email"]="";
		// "content":"82403270111",
	 }else{
		 $decoded_json["state"]="0";
		 $decoded_json["phone"]= $row_Rt2['qphone'];
		 $decoded_json["email"]= $row_Rt2['email'];
		 } 
  }else{
	   //content
	   $decoded_json["content"]=$td;//'82401230082'; 
	   $decoded_json["phone"]= $row_Rt2['qphone'];
	  
	  }

  mysql_select_db($database_BE2, $BE2);
  $query_Rt3 =sprintf("SELECT a.*,b.p_title FROM order_datas as a,product_data as b WHERE a.mem_auto=b.mem_auto AND a.dcode='%s'",$td );
  $Rt3 = mysql_query($query_Rt3, $BE2) or die(mysql_error());
  $row_Rt3 = mysql_fetch_assoc($Rt3);
  $totalRows_Rt3 = mysql_num_rows($Rt3);	 
  
  $sales=0;
  $totalFee=0;
  do { 
      $arrne['name'] = $row_Rt3['p_title'] ;
	  $arrne['money'] = intval($row_Rt3['p_money']);
	  $arrne['number'] = intval($row_Rt3['p_count']);
	  $sales=$sales+$row_Rt3['p_money'];
	  
	  array_push( $decoded_json['items'], $arrne );
	} while ($row_Rt3 = mysql_fetch_assoc($Rt3));  
  
  $decoded_json["sales"]= $sales;
  $decoded_json["totalFee"]= $sales; 
  
 
  // print json_encode($decoded_json);
  
  fwrite($fp,  json_encode($decoded_json) ."\r\n");// 822344324
  
  $jss=json_encode($decoded_json);	
  
  $ch = curl_init();
  curl_setopt($ch, CURLOPT_URL, $url);
  curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
  curl_setopt($ch, CURLOPT_HTTPHEADER, array("Content-Type: application/json","Authorization: OAuth 2.0 token here"));
  curl_setopt($ch, CURLOPT_POST, 1);
  curl_setopt($ch, CURLOPT_POSTFIELDS, $jss);
  $result = curl_exec($ch);
 
  fwrite($fp,"=============giveme result ======="."\r\n");
  fwrite($fp,$result."\r\n");
 
  $test_dejson = json_decode($result, true);
 //  echo 'billcode,'.$result_dejson['code'] ;//"code":"VJ59556740",
   
   if(isset($test_dejson['msg']) && $test_dejson['msg']=="開立成功！"){	  	
 
	 $UpSQL2 = sprintf("update order_bill set ck='Y',billcode='%s' where dcode='%s'",$test_dejson['code'],$td );
		//echo $UpSQL2 ."<br>";
	 mysql_select_db($database_BE2, $BE2);
     mysql_query($UpSQL2, $BE2) or die(mysql_error());
	
       }  // fclose($fp);
 
  

      } //$errcode=='00'
	  
	  
	  
	  
	 
	 } //發票檔
  
    // } // 00  
  
   }
		 
		 
		 // end excel data
	 }
	   //========end respone pos =============// 

    } else {
 
      $b=count($_GET);
      fwrite($fp,"=====GET====================="."\r\n"); 
      if($b>0){	
      foreach($_GET as $key=>$value){
      // echo "$key=$value";
	   fwrite($fp,"$key=$value"."\r\n");
       }  	
      }
	
      fwrite($fp,"==========信用卡-連線交易成功========="."\r\n");
       echo  "<script>alert('信用卡-連線交易成功');location.href='/';</script>";
	   
	}
 
 
 
 
 
 
 
 
  
  fclose($fp);
 
  
 ?>