<?  require_once('./Connections/BE2.php'); 

if ((isset($_POST["state"])) && ($_POST["state"] == "addCart")) {
  //p_sess 1=add cart  2,    3= 完成購物 	
  
if($_SESSION['login_memid']<>""){
$p_size=$_POST['p_size']=='請選擇'?'':$_POST['p_size'];
$p_percent31=$_POST['p_percent31'] ; // 推廣獎金
$p_percent32=$_POST['p_percent32'] ; // 開發獎金 == > 網店經銷獎金 20250110; ,經銷商經銷獎金 2025-01-10 開發商銷售獎金：1000元
$p_percent33=$_POST['p_percent33']; //  開發商首推獎金 單次 首次開店獎金 = 銷售獎金
$p_percent34=$_POST['p_percent34'] ; // 推廣雲點
$p_percent35=$_POST['p_percent35'] ; // 開發雲點
$p_percent36=$_POST['p_percent36'] ; // 開發商續推獎金
$p_percent37=$_POST['p_percent37'] ; // 經銷獎金
$p_percent38=$_POST['p_percent38'] ; // 分享獎金  new 241209 
$p_percent39=$_POST['p_percent39'] ; // 推薦獎金  new 241209  to sql tablename pptname 
$p_percent39=$_POST['p_percent40'] ; // 銷售獎金  new  250110
$p_demoney=$_POST['p_demoney'] ; // 魏繳金額



/*
開發商銷售獎金：1000元 
經銷商經銷獎金：500元
刷卡一次付清：3000元
*/
//                1         2         3          4            5              6
// $pp1=array("",'推廣獎金','開發獎金','開發商首推獎金','商品未付餘額','開發商續推獎金','經銷獎金');
 
//$puser=$_SESSION['login_puser'] ;//$_POST['mem_num']; // par id
// 檢查  特別開發費 單次 p_percent33

/*
//select b.mem_auto from order_datam as a, order_datas as b where a.dcode=b.dcode 
   AND a.duser=16 AND a.dflag='Y' and b.mem_auto=4139 
*/
mysql_select_db($database_BE2, $BE2);
//$qra1 =sprintf("select b.mem_auto from order_datam as a, order_datas as b where a.dcode=b.dcode AND a.duser='%s' AND a.dflag='Y' and b.mem_auto='%s'",$_SESSION['login_memid'],$_POST['mem_auto']); 
$qra1 =sprintf("select * from member where mem_auto='%s'",$_SESSION['login_memid']); 
$Rqra1 = mysql_query($qra1, $BE2) or die(mysql_error());
$row_Rqra1 = mysql_fetch_assoc($Rqra1);
$totalRows_Rqr2 = mysql_num_rows($Rqra1);

if($row_Rqra1['mem_check']=='N'){ 
    $p_percent36=0; ; //開發商續推獎金 =0
   // $_POST['p_percent33'] ; // 保留 開發商直銷獎金
  } else{ 
   $p_percent31= 0; //  1,保留 開發商續推獎金   開發商直銷獎金=0
  }


mysql_free_result($Rqra1);
$qr_buyonce = sprintf("select b.mem_auto as ct1 from order_datam as a,order_datas as b where a.did=b.ccid AND b.mem_auto='%s' AND a.duser='%s'",$_POST['mem_auto'],$_SESSION['login_memid']);
mysql_select_db($database_BE2, $BE2);
$Rbuyonce = mysql_query($qr_buyonce, $BE2) or die(mysql_error());
$row_b = mysql_fetch_assoc($Rbuyonce);
$totalRows_buyonce = mysql_num_rows($Rbuyonce);
$p_buyonce=0;  
if($totalRows_buyonce>0){$p_buyonce=1;}
//$buynow=isset() //$buynow
$buynow=(isset($_POST['buynow']))?1:0;  
 
$InsertSQL = sprintf("insert into order_tmp (coid,mem_auto,p_count,p_money,member_id,p_sess,p_date,p_size,p_percent,p_percent2,p_percent3,p_percent4,p_percent5,p_percent6,p_percent7,p_percent8,p_percent9,p_demoney,p_express,p_once,p_buynow)VALUES('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s' ,'%s' ,'%s','%s' ,'%s','%s','%s','%s','%s','%s' ,'%s')", $_POST['company_num'], $_POST['mem_auto'],$_POST['p_count'],$_POST['p_money'],$_SESSION['login_memid'],1,date('Y-m-d'),$p_size,$p_percent31,$p_percent32,$p_percent33,$p_percent34,$p_percent35,$p_percent36,$p_percent37,$p_percent38,$p_percent39,$p_demoney,$_POST['p_express'],$p_buyonce,$buynow);
 mysql_select_db($database_BE2, $BE2);
 mysql_query($InsertSQL, $BE2) or die(mysql_error());
 
 if($buynow>0){ 
    
	mysql_select_db($database_BE2, $BE2); //cexpdiff_
    $empt1= sprintf("delete from tmporder1 where sess='%s'",session_id());   
	mysql_query($empt1, $BE2) or die(mysql_error());
	
	
	 
	mysql_select_db($database_BE2, $BE2); //cexpdiff_
	$inst1= sprintf("INSERT INTO tmporder1(coid,mid,mexp,mexpkid,sess) select coid,ccid,'%s','%s','%s' from order_tmp where p_buynow=1 order by ccid desc limit 1",'0','1',session_id());  
	//$inst1= sprintf("INSERT INTO tmporder1(coid,mid,mexp,mexpkid,sess)VALUES('%s','%s','%s','%s','%s')",$_POST['ccidm_'.$i],$value,0,'1',session_id());   
	mysql_query($inst1, $BE2) or die(mysql_error());
				 
    echo '<script>window.location.href="/orderinfo.html";</script>'; 
  } else{
    $write='資料已新增...';
    echo  "<script>alert('".$write."');</script>";
    }
 } else{ echo  "<script>alert('請先登入再購買...');</script>"; }
 
 
}
 


$menu1=isset($_GET['menu'])?$_GET['menu']:'index';
 
$exmenu=explode("-",htmlspecialchars($menu1));
$mem_auto=$exmenu[1];
 
mysql_select_db($database_BE2, $BE2);
$qr1 =sprintf("SELECT * FROM product_data WHERE mem_auto='%s' ",$mem_auto); 
$Rqr1 = mysql_query($qr1, $BE2) or die(mysql_error());
$row_Rqr1 = mysql_fetch_assoc($Rqr1);
$totalRows_Rqr1 = mysql_num_rows($Rqr1);

mysql_select_db($database_BE2, $BE2);
$qr2 =sprintf("SELECT * FROM product_img WHERE fck='Y' AND mid='%s' ",$mem_auto); 
$Rqr2 = mysql_query($qr2, $BE2) or die(mysql_error());
$row_Rqr2 = mysql_fetch_assoc($Rqr2);
$totalRows_Rqr2 = mysql_num_rows($Rqr2);
 
 
mysql_select_db($database_BE2, $BE2);
//$row_Rt2 b.p_title
$query_Rc2 = sprintf("SELECT * FROM order_tmp WHERE p_sess= '1' AND member_id='%s' ",$_SESSION['login_memid']);
$Rc2 = mysql_query($query_Rc2, $BE2) or die(mysql_error());
$row_Rc2 = mysql_fetch_assoc($Rc2);
$totalRows_Rc2 = mysql_num_rows($Rc2);
$product_count=$totalRows_Rc2;

mysql_free_result($Rc2);

mysql_select_db($database_BE2, $BE2);
$query_Rt3 =  "SELECT * FROM creditcard order by pp1" ;
$Rt3 = mysql_query($query_Rt3, $BE2) or die(mysql_error());
$row_Rt3 = mysql_fetch_assoc($Rt3);
$totalRows_Rt3 = mysql_num_rows($Rt3);


 
 
?>
<style type="text/css">
 
 #Ly {
    width:100%;
	width:screen.width;
	cursor:auto;
    left:0px;
	position: fixed;
	height:70px;
	bottom:0;
	z-index:3;
	color: #fff;
	background-color: #0033FF;  
	font-size:25px;      
	font-weight: bold;
	
}
  
</style> 
 
    <!-- Blog Minimal Blocks -->
   <?  
    // echo $row_Rqr1['p_check_time2']; //商品已過期
    if($row_Rqr1['p_check_time2']> date('Y-m-d')){ ?>
    <section class="container">
        <div class="row justify-content-md-center g-mb-50">
         
          <div class="col-xl-5 col-md-5  col-lg-5">
          <h3></h3>
         <? 
		   $imagepath = "/admin/upload_image/".$row_Rqr1['meta_img'];

		   if($row_Rqr1['p_new']==1){
			$imagepath = "/admin/upload2_image/".sprintf("%07d",$row_Rqr1['company_num']).'/'.$row_Rqr1['meta_img'].'.'.$row_Rqr1['p_tag'];  
				
			} 
		   $sp_id=array(4178,4179);	// 首付
		   $bubo_money=1;
		    if( in_array($row_Rqr1['mem_auto'],$sp_id)){
				$bubo_money=3;
				}
 
		 ?>
            <img class="img-fluid w-100" src="<?= $imagepath ?>" alt="<?= $row_Rqr1['p_title']; ?>"> 
           <? /*  <img class="img-fluid w-100" src="/admin/upload_image/2019726155819_7841.jpg" alt="skybni"> */ ?>
          </div>
 
          <div class="col-xl-7 col-lg-7">
              <h3></h3>
              <p class="lead mb-10"><font color="#FF0000"><?= $row_Rqr1['p_num'] ;?></font></p>

              <h2 class="h2 g-color-black g-font-weight-600 mb-2"><?= $row_Rqr1['p_title']; ?></h2>
              <p class="mb-10"><?= nl2br($row_Rqr1['p_explan']); ?>
              <!-- Price -->
              <div class="g-mb-10">
                <br />   
                <label class="g-font-size-14">商品價格：</label>
                <span class="g-color-black g-font-weight-500 g-font-size-30"><?= $row_Rqr1['p_money']; ?></span>
                <span class="g-color-black g-font-weight-500 g-font-size-16">元</span>
                 
              </div>


 
              <?  //經銷商經銷獎金
			 // $doc1=array("","會員推廣獎金","開發商開發獎金","開發商首推獎金","推廣雲點","開發雲點","開發商續推獎金","銷售獎金");
			  $doc1=array("","會員推廣獎金","經銷商經銷獎金","開發商首推獎金","推廣雲點","開發雲點","開發商續推獎金","銷售獎金");
			  $vv=0; 
			  $show1=0;
			  for($i=1;$i<8;$i++){
			   if($row_Rqr1['p_percent3'.$i]>0){
				 $show1=1;    
			   }
			  } 
			  if($show1>0){ echo " 此商品提供: <br>" ;}
			  ?>
              
			  <? for($i=1;$i<8;$i++){ 
			   $vv += $row_Rqr1['p_percent3'.$i];
			   if($row_Rqr1['p_percent3'.$i]>0){?>
               <div class="g-mb-10">
                <span class="g-color-black g-font-weight-400 g-font-size-14">
                  <?=$doc1[$i] ?>：<?= $row_Rqr1['p_percent3'.$i]; ?>元 
                </span><br>
               </div>
              <?  }
			    }  
              if($vv==0){?>
              <div class="g-mb-10">
                <span class="g-color-black g-font-weight-400 g-font-size-14">
                此商品提供會員雲點 :<br>
                2%回饋：<?= round(($row_Rqr1['p_money']*0.02),0 ); ?>點<br>
				3%抽成：<?= round(($row_Rqr1['p_money']*0.03),0 ); ?>點
				</span><br>
             </div>
              <? } ?> 
  
              <div class="g-mb-10">
                <span class="g-font-size-14">
                <?= ($bubo_money==1)?'刷卡一次付清：':'首次付款： '; ?><?= $row_Rqr1['p_money'] ?>元</span><br>
              </div>
              <div class="g-mb-10">
                <label class="g-font-size-14">商品分類：</label>
                <span class="g-color-black g-font-weight-400 g-font-size-16"><?= $row_Rqr1['p_hot2']; ?></span>
              </div>
              <!-- End Price -->
<form name="form5" method="post" action="/categoryDetail-<?= $row_Rqr1['mem_auto']; ?>.html">
<input name="state" id="state" type="hidden" value="addCart">

<input name="url" id="url" type="hidden" value="/categoryDetail-<?= $row_Rqr1['mem_auto']; ?>.html">
<input name="p_title" id="p_title" type="hidden" value="<?= $row_Rqr1['p_title']; ?>">
<input name="p_img" id="p_img" type="hidden" value="2019726155819_7841.jpg">
<input name="mem_auto" id="mem_auto" type="hidden" value="<?= $row_Rqr1['mem_auto']; ?>">
<input name="company_num" id="company_num" type="hidden" value="<?= $row_Rqr1['company_num']; ?>">
<input name="p_num" id="p_num" type="hidden" value="<?= $row_Rqr1['p_num']; ?>">
<input name="p_percent" id="p_percent" type="hidden" value="<?= ($row_Rqr1['p_percent31']==0)?round(($row_Rqr1['p_money']*0.03),0 ):"0"; ?>">
<input name="p_percent2" id="p_percent2" type="hidden" value="<?= ($row_Rqr1['p_percent31']==0)?round(($row_Rqr1['p_money']*0.02),0 ):"0"; ?>">
<input name="p_percent3" id="p_percent3" type="hidden" value="0">
<input name="p_percent31" id="p_percent31" type="hidden" value="<?= $row_Rqr1['p_percent31']; ?>">
<input name="p_percent32" id="p_percent32" type="hidden" value="<?= $row_Rqr1['p_percent32']; ?>">
<input name="p_percent33" id="p_percent33" type="hidden" value="<?= $row_Rqr1['p_percent33']; ?>">
<input name="p_percent34" id="p_percent34" type="hidden" value="<?= $row_Rqr1['p_percent34']; ?>">
<input name="p_percent35" id="p_percent35" type="hidden" value="<?= $row_Rqr1['p_percent35']; ?>">
<input name="p_percent36" id="p_percent36" type="hidden" value="<?= $row_Rqr1['p_percent36']; ?>">
<input name="p_percent37" id="p_percent37" type="hidden" value="<?= $row_Rqr1['p_percent37']; ?>">
<input name="p_percent38" id="p_percent38" type="hidden" value="<?= $row_Rqr1['p_percent38']; ?>">
<input name="p_percent39" id="p_percent39" type="hidden" value="<?= $row_Rqr1['p_percent39']; ?>">
<input name="p_demoney" id="p_demoney" type="hidden" value="<?= $row_Rqr1['p_demoney']; ?>">
<input name="p_hot2" id="p_hot2" type="hidden" value="<?= $row_Rqr1['p_hot2']; ?>">
<input name="mem_code" id="mem_code" type="hidden" value="">
 
<input name="p_money" id="p_money" type="hidden" value="<?= $row_Rqr1['p_money'] ?>">
<input name="p_express" id="p_express" type="hidden" value="<?= $row_Rqr1['p_express']; ?>">

              <div class="row">
              	<div class="col-lg-8 g-mb-20">
                <label class="g-font-size-14">選擇商品規格：</label>
                <select class="custom-select mr-sm-3 mb-3 mb-lg-0" name="p_size" id="p_size" <? ($row_Rqr1['p_kind']<>'')?'required':''?> >
                	<option value="">請選擇</option>
                    <?
                    //洗衣機 3.5KG 、洗衣機 6.5KG、洗衣機 7.5KG
                     $p=explode('、',$row_Rqr1['p_kind']);
					 for($i=0;$i<count($p)-1;$i++){  ?>
                 	<option value="<?= $p[$i] ;?>"><?= $p[$i] ;?></option>
					<? }?>
                	
					</select>
					</div>
              </div>
              
              <div class="row">
              	<div class="col-lg-12 g-mb-20">
                <label class="g-font-size-14">購買數量：</label>
                <select class="custom-select mr-sm-3 mb-3 mb-lg-0" name="p_count" id="p_count">
                 <? for($i=1;$i<101;$i++){ ?>
                 	<option value="<?= $i ;?>"><?= $i ;?></option>
                 <? } ?>	
 				</select>
					</div>
              </div>
              <? // if (  $_SERVER['REMOTE_ADDR']=='220.130.43.118'){?>

              
              
              
              <? // } ?>
              <!-- Buttons -->
              <div class="row g-mx-minus-5 g-mb-20">
              
              
                <div class="col g-px-5 g-mb-10">
                <? if($row_Rqr1['p_check']<>'上架'){?>
                
               
                  <button class="btn btn-block u-btn-red g-font-size-16 g-py-15 g-px-25 g-color-white" type="button">商品補貨中</button>        <? }?>  
                  
                </div>
                <div class="col g-px-5 g-mb-10">
                <input name="p_moneyKind" id="p_moneyKind" type="hidden" value="0" />
                <? if($row_Rqr1['p_check']=='上架'){
					 if($_SESSION['login_memid']==''){?>
						 <input type="button" name="b1" value="加入購物車" onclick="run_login()" />
					 <? }else{ ?>
					      <input type="submit" name="submit" value="加入購物車" />
                           
                          <input type="submit" name="buynow" id="buynow" value="直接購買" />
                             
                          
					 <? } 
				
				     } ?>  
                
 
                </div>
              </div>
              <!-- End Buttons -->
</form>
          </div>
           
        </div>
      </section>

      
    <div class="container g-pt-100 g-pb-20">
      <div class="row justify-content-between">
        <div class="col-lg-12 order-lg-2 g-mb-80" style="background-color: #FCFCFC">

      <!-- Gallery #08 -->

      <!-- End Gallery #08 -->
     <?  
 
   if($totalRows_Rqr2>0){
	  
	  $imagepath = "/admin/upload2_image/".sprintf("%07d",$row_Rqr1['company_num']).'/'.$row_Rqr1['meta_img'];
	 do { 
	  $img = $imagepath.$row_Rqr2['imgname'].'.'.$row_Rqr2['imgext']; 
	 ?>
      <img class="img-fluid" src="<?= $img ?>" title="skybni <?= $row_Rqr1['p_title'] ?>">
 
     <?  } while ($row_Rqr2 = mysql_fetch_assoc($Rqr2)); 
   } 
   ?>
      <? /*    
       <img class="img-fluid" src="/images/28bank.jpg" alt="skybni">
       */ ?>
      <p style="line-height:30px">
       <br>
        <div style="text-align:center; background-color:#D8D8D8;"><h2>商品詳情</h2> </div>
      
        <?= nl2br($row_Rqr1['p_content']); ?>
      
      
        </div>

      </div>
      
      
      
      <div id="Ly" >
     <div class="col-12"><div id="buy_obj">已選商品 <?= $product_count ;?>件</div></div> 
     <div class="col-12" style="font-size:14px; color:#000; text-align:center;"><? if($product_count>0){?> <input type="button" value="我要結帳" onclick="window.location.href='/shoppingcar.html'"> <? }?></div>
 
   
  </div>
      
    </div>
    
    <?   } else { echo '商品已過期...' ;} ?>
    <!-- End Blog Minimal Blocks -->
 <script>
 function run_login(){
 
  alert('請先登入再購買...');
  document.cookie = 'loginpage=categoryDetail-<?= $mem_auto; ?>.html;path=/;';
  location.href='/login.html?loginpage=categoryDetail-<?= $mem_auto; ?>.html';   
 
 
 }
 
 function showbank(){
	//var conceptName = $('#p_channel').find(":selected").val();
	//var conceptName=$("select#p_channel option").filter(":selected").val();
	var section = document.getElementById('bankselect');
	var selectval=$('#p_channel').val();
 
	 if(selectval=='0'){ section.style.display = "none";}
	 else{ section.style.display = "block"; }
	
  }
 
    
 </script>
      
    <?php
mysql_free_result($Rqr1);
mysql_free_result($Rqr2);


?>      