<?php require_once('../Connections/BE2.php'); ?>
<?php

mysql_select_db($database_BE2, $BE2);
$query_Rt1 = "SELECT distinct(SUBSTRING(pdate, 1, 7)) as mm FROM order_percent where 1 order by pdate desc" ;
$Rt1 = mysql_query($query_Rt1, $BE2) or die(mysql_error());
$row_Rt1 = mysql_fetch_assoc($Rt1);
$mm = $row_Rt1['mm'];
if (isset($_GET['mm'])) {
  $mm = $_GET['mm'];
}
 
$currentPage = "percentpoint.html";//$_SERVER["PHP_SELF"];  
$maxRows_Rt2 = 10;
$pageNum_Rt2 = 0;
if (isset($_GET['pageNum_Rt2'])) {
  $pageNum_Rt2 = $_GET['pageNum_Rt2'];
}
$startRow_Rt2 = $pageNum_Rt2 * $maxRows_Rt2;

mysql_select_db($database_BE2, $BE2);

$query_Rt2 = sprintf("SELECT a.*,b.dcode,b.p_money,b.p_count,c.p_title from order_percent as a, order_datas as b,product_data as c where a.ccid=b.ccid AND b.mem_auto=c.mem_auto AND a.pdate like '%s' AND a.puid='%s' ORDER BY a.pdate DESC",$mm.'%',$_SESSION['login_memid']); 

$query_limit_Rt2 = sprintf("%s LIMIT %d, %d", $query_Rt2, $startRow_Rt2, $maxRows_Rt2);
$Rt2 = mysql_query($query_limit_Rt2, $BE2) or die(mysql_error());
$row_Rt2 = mysql_fetch_assoc($Rt2);

if (isset($_GET['totalRows_Rt2'])) {
  $totalRows_Rt2 = $_GET['totalRows_Rt2'];
} else {
  $all_Rt2 = mysql_query($query_Rt2);
  $totalRows_Rt2 = mysql_num_rows($all_Rt2);
}
$totalPages_Rt2 = ceil($totalRows_Rt2/$maxRows_Rt2)-1;

$queryString_Rt2 = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_Rt2") == false && 
	    stristr($param, "menu") == false && 
        stristr($param, "totalRows_Rt2") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_Rt2 = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_Rt2 = sprintf("&totalRows_Rt2=%d%s", $totalRows_Rt2, $queryString_Rt2);


mysql_select_db($database_BE2, $BE2);
$query_Rta3 =  "SELECT * FROM pptname order by pt1" ;
$Rta3 = mysql_query($query_Rta3, $BE2) or die(mysql_error());
$row_Rta3 = mysql_fetch_assoc($Rta3);
$totalRows_Rta3 = mysql_num_rows($Rta3);
$pp1=array();
$pp1[0]="";
$i=0;
do { 
 $i++;
 $pp1[$i]=$row_Rta3['pdoc'];

}   while ($row_Rta3 = mysql_fetch_assoc($Rta3)); 

mysql_free_result($Rta3); 
?>	
		<!-- start: Content -->
		<div class="main ">
		
			<div class="row">
				<div class="col-lg-12">
					<h3 class="page-header"><i class="fa fa-indent"></i>推廣奨金</h3>
					<ol class="breadcrumb">
						<li><i class="fa fa-home"></i><a href="index.html">首頁</a></li>
						<li><i class="fa fa-list-alt"></i><a href="#">雲點數</a></li>
						<li><i class="fa fa-indent"></i>推廣奨金</li>				
					</ol>
				</div>
			</div>



			<div class="row">	
				<div class="col-md-12">
					<div class="panel panel-default">
						<div class="panel-heading">
							<h2><i class="fa fa-list red"></i><span class="break"></span><strong>奨金記錄清單</strong></h2>
						</div>


						<div class="panel-body">

					<h3 class="panel-title">&nbsp;</h3>
					            <div class="clearfix"></div>  
                    <script type="text/javascript">
function MM_jumpMenu(targ,selObj,restore){ //v3.0
  eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
  if (restore) selObj.selectedIndex=0;
}
</script>
 
                               
 
<div class="col-2">
 
</div>
<div class="col-4"> 
  <select name="selmoon" id="selmoon" class="form-control col-4"  onchange="MM_jumpMenu('self',this,0)">
     <? 
	  do{?>
         <option value="<?php printf("%s?mm=%s", $currentPage, $row_Rt1['mm']); ?>" <? if($mm==$row_Rt1['mm']){ ?>selected="selected" <? }?>><?= $row_Rt1['mm'] ;?> 獎金月份</option>
      <?php } while ($row_Rt1 = mysql_fetch_assoc($Rt1)); ?>
     </select>
     <a href="excel_percentpoint.php?sdate=<?= $mm; ?>"><button type="button" class="btn blue" > 明細下載</button></a>
</div>     
     
                     <div style="overflow:scroll;">
				 <table class="table table-striped table-bordered bootstrap-datatable" style="min-width:700px;">
 
						<thead>
							<tr class="replace-inputs">
                                 <th class="center">#</th>
                                 <th align="center" nowrap="nowrap">訂單號</th>
								 <th align="center">訂單日期</th>
						         <th align="center">商品說明</th>
								 <th align="center">商品金額</th>
								 <th align="center">數量</th>
								 <th align="center">推廣/經銷</th>
								 <th align="center">金額</th>
								 <th align="center">未繳商品餘額</th>
								<? /* <th align="center">已申請</th> */ ?>
                                 
							</tr>
						</thead>
						<tbody>
                           <?php 
						   //              1          2        3              4            5              6        7    new 8        9
                           // $pp1=array("",'推廣獎金','經銷獎金','開發商首推獎金','商品未付餘額','開發商續推獎金','銷售獎金','獎金支付','分享獎金','推薦獎金');   new 241209  to sql tablename pptname   
						   //                  1       2 分享獎金<=經銷獎金   3         4            5          6        7        8       9     10    11      12              
						    //   $pp1=array("",'推廣獎金','經銷獎金','開發商首推獎金','商品未付餘額','開發商續推獎金','銷售獎金','經銷獎金','分享獎金','推薦獎金','暫無','暫無','暫無','獎金支付');
					 
						    // ($row_Rt2['pkid']==2)?'開發獎金':'推廣獎金'
						    $pmoney=0;
							$demoney=0;
							if($totalRows_Rt2>0){
							$i=0;	
							
						 do { $i++;
						    
						     $pmoney = $pmoney+$row_Rt2['pmoney'];
							 $demoney = $demoney+$row_Rt2['depmoney'];  
						   ?>
							<tr>
                             <td class="center"><?= $i ?></td>
						     <td><?= $row_Rt2['dcode'] ?></td>
						     <td><?= $row_Rt2['pdate'];?></td>
						     <td><?= $row_Rt2['p_title'];?></td>
						     <td align="right"><?= $row_Rt2['p_money'];?></td>
						     <td align="right"><?= $row_Rt2['p_count'];?></td>
						     <td align="right"><?= $pp1[$row_Rt2['pkid']] ;?></td>
						     <td align="right"><?= $row_Rt2['pmoney']; ?></td>
						     <td align="right"><?= $row_Rt2['depmoney']; ?></td>
				 
							</tr>
						
                        <?php } while ($row_Rt2 = mysql_fetch_assoc($Rt2)); ?>
							
							<tr>
                             <td class="center">&nbsp;</td>
						     <td>本頁累計</td>
						     <td>&nbsp;</td>
						     <td>&nbsp;</td>
						     <td align="right">&nbsp;</td>
						     <td align="right">&nbsp;</td>
						     <td align="right">&nbsp;</td>
						     <td align="right"><?= $pmoney; ?></td>
						     <td align="right"><?= $demoney ?></td>
					 
							</tr>
						<?	}
						  	?></tbody>
                       
					</table>
                    
                     <div class="form-group form-actions col-md-6 ">
                    
                    發放推廣獎金申請，根據申請當下幾月，會在下一個月15號錢匯入指定帳戶(例如1月申請，在1月底的時候會有總表出來，在2月15之前會匯入指定帳戶)
                    </div>
				  <? /* if($pmoney<0){?>	
                    <div class="form-group form-actions col-md-5 ">
						 
				        <input type="button" name="Sub1" value="申請提領獎金" class="btn btn-3d btn-black btn-md" onclick="location.href='percent2cash.html'">        
                                </div>
                   <div class="form-group form-actions col-md-5">
						 <input type="button" name="Sub2" value="獎金轉入雲點數" class="btn btn-3d btn-black btn-md" onclick="location.href='percent2point.html'">
				                轉為雲點數將無法再轉為獎金</div>  
                 <?  } */ ?>                          		      
                   <ul class="pagination">
                    <?    
                     if( $totalPages_Rt2 >0){	 
						    //分頁程式
if($totalPages_Rt2<5){
		 $start=0;
		 $end=$totalPages_Rt2;
		}else{  
	    $start=$pageNum_Rt2-5;
		$end=$pageNum_Rt2+5;
        if ($start<0){
		 $start=0;
		 $end=10; } 
		 else { $end=$start+10 ;}
		 if ($end>$totalPages_Rt2){ 
		   $start = $end-$totalPages_Rt2-5;
		   $end=$totalPages_Rt2;
		   }
		 if ($end-$start>10){ 
		   $start = $end-10;
		   }  
		 } ?> 
                     <?php if ($pageNum_Rt2 > 0) { // Show if not first page ?>
                     <li><a href="<?php printf("%s?pageNum_Rt2=%d%s", $currentPage, max(0, $pageNum_Rt2 - 1), $queryString_Rt2); ?>">上一頁</a></li><?php } // Show if not first page ?>
                    	<?	   
		for($i=$start;$i<=$end;$i++){
		if($i==$pageNum_Rt2){ echo '<li class="active"><a href="#">'.($i+1).'</a></li>';} else {?>
            <li><a href="<?php printf("%s?pageNum_Rt2=%d%s", $currentPage, min($totalPages_Rt2, $i), $queryString_Rt2); ?>"><? echo $i+1 ;?></a></li>
                 
                        <?	}   }  ?>

                      <?php if ($pageNum_Rt2 < $totalPages_Rt2) { // Show if not last page ?>
            <li><a href="<?php printf("%s?pageNum_Rt2=%d%s", $currentPage, min($totalPages_Rt2, $pageNum_Rt2 + 1), $queryString_Rt2); ?>">下一頁</a></li>
                        <?php }  
						             }  
									 
								 	 ?>
								
						  </ul>

                   </div>


<? 


//$query_Rt3 =  sprintf("SELECT a.*,d.scode,d.mem_user2,d.m_bankcode,d.m_bankname,d.m_bank,d.m_bank2 from order_permoon as a, member as d where a.pall>0 AND a.pmpay ='Y' AND a.puid=d.mem_auto AND a.puid='%s' group by a.puid ORDER BY a.puid",$_SESSION['login_memid']); //$sdate
$query_Rt3 =  sprintf("SELECT a.*,d.scode,d.mem_user2,d.m_bankcode,d.m_bankname,d.m_bank,d.m_bank2 from order_permoon as a, member as d where a.pmpay ='Y' AND a.puid=d.mem_auto AND a.puid='%s' ",$_SESSION['login_memid']); //$sdate

// $query_Rt2 =  sprintf("SELECT a.*,b.dcode,b.p_money,b.p_count,d.scode,d.mem_user2,d.m_bankcode,d.m_bankname from order_percent as a, order_datas as b,member as d where a.ccid=b.ccid AND a.puid=d.mem_auto AND a.pdate like '%s' ORDER BY a.pdate DESC",$sdate.'%') ; 
mysql_select_db($database_BE2, $BE2);
$Rt3 = mysql_query($query_Rt3, $BE2) or die(mysql_error());
$row_Rt3 = mysql_fetch_assoc($Rt3);
$totalRows_Rt3 = mysql_num_rows($Rt3);
//echo $query_Rt3; 
if($totalRows_Rt3>0){
?>
  <br><br>累計已發獎金  
 <table class="table table-striped table-bordered bootstrap-datatable" style="min-width:700px;">
 
						<thead>
							<tr class="replace-inputs">
                                 <th class="center">單據月份</th>
								 <th class="center">應發獎金</th>
						         <th class="center">所得稅10%	</th>
								 <th class="center">平台服務費5%</th>
								 <th class="center">金流服務費2.8%</th>
								 <th class="center">實發獎金</th>
                                
							</tr>
						</thead>
                        <tbody>
                      <? 
					    $payall=0;
						 do {  
 
						   ?>
							<tr>
                             <td class="center"><?= $row_Rt3['pmoon']; ?></td>
						     <td align="center"> <? $payall += $row_Rt3['pall']; 
							    echo $row_Rt3['pall'];
							 ?></td>
                             <td align="center"> <?= ($row_Rt3['pall']>0)?($row_Rt3['pall']*0.10):'0'; ?></td>
                             <td align="center"> <?= ($row_Rt3['pall']>0)?($row_Rt3['pall']*0.05):'0'; ?></td>
                             <td align="center"> <?= ($row_Rt3['pall']>0)?($row_Rt3['pall']*0.028):'0'; ?></td>
                             <td align="center"> <?= ($row_Rt3['pall']>0)? $row_Rt3['pall']-($row_Rt3['pall']*0.178):'0'; ?></td>
				 
							</tr>
						
                        <?php } while ($row_Rt3 = mysql_fetch_assoc($Rt3)); ?>
							
							<tr>
                             <td class="center">&nbsp;</td>
						     <td>&nbsp;</td>
						     <td align="right">&nbsp;</td>
                             <td align="right">累計已發獎金</td>
						     <td align="right">$ <?= $payall; ?></td>
						     <td align="right">&nbsp;</td>
					 
							</tr>
						</tbody>
                       
					</table>
                      <?	} 	?>
					  </div>
					</div>
				</div><!--/col-->
			
			</div><!--/row-->

    
		</div>
		 
		<!-- end: Content -->
 