MAINHACK

Viewing / Editing File: all_comission.php

<?php include'header.php';?>

<div class="main-panel">
			<div class="content">
				<div class="container-fluid">
					<div class="page-header">
						<h4 class="page-title">All Comission</h4>
						
					</div>
					<div class="row">
						<div class="col-md-12">   
						
						<div class="card">
							
								<div class="card-body">
									<div class="table-responsive">
					
					            <table id="basic-datatables" class="display table table-striped table-hover">    
                                             <thead>
                                              <tr>
                                              <th>ID</th>
                                            <th>Date/ Book ID</th>
                                            <th>Maker Name/ID</th>
                                            <th>G.Total</th>
                                             <th>Comission(%)</th>
                                             <th>Product Amt</th>
                                             <th>My Payout</th>
                                            <th>Order Details</th>
                                              </tr> 
                                            </thead>
                                            <tbody>
		
		
<?php
$comi_total=0;			
$count=1;
//$sq="select sajh_comission.book_id,sajh_comission.gross_total,sajh_comission.commission_amt,sajh_comission.commission,sajh_comission.cook_id,sajh_comission.date,sajh_comission.paid_status,sajh_comission.paid_date,sajh_comission.status,food_maker.name,food_maker.title,food_maker.email,food_maker.phone from sajh_comission left join food_maker on food_maker.maker_id=sajh_comission.cook_id where food_maker.maker_id='".$_SESSION['login_id']."'  order by sajh_comission.date desc ";    
//echo  $sq;
 $sq="select place_order.order_id,place_order.user_id,place_order.total,place_order.amount,place_order.maker_id,place_order.date,place_order.status,food_maker.maker_id,food_maker.name,food_maker.title,food_maker.email,food_maker.phone,food_maker.comi_percent from place_order left join food_maker on food_maker.maker_id=place_order.maker_id where place_order.status='PLACED' and food_maker.maker_id='".$_SESSION['login_id']."' order by place_order.date desc ";    
echo $sq;
$stmt=$con->prepare($sq);
$stmt->execute();
$num=$stmt->rowCount();
     if($num>0){
 
           while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
        extract($row);
        $id=$row['id'];  
       // $comi_total +=$row['comi_pe'];
        $payout=$row['total']-($row['total']*($row['comi_percent']/100));
         $pro_id=$row['order_id'];
    
		echo "<tr>
		<td>$count</td>
		<td>".date('d-m-Y',strtotime($row['date']))."<br>".$row['order_id']."</td>
		<td>".$row['title']."<br>".$row['maker_id']."</td>
		<td>".$row['amount']."</td>
		<td>".$row['comi_percent']."</td>
		<td>".$row['total']."</td>
		<td>".$payout."</td>
		<td style='color:red;'><a href='bill_final.php?uid=".base64_encode($row['user_id'])."&bid=".base64_encode($pro_id)."' target='_blank' class='btn btn-xs btn-info'>Order Details</a></td>

</tr>";

++$count;
 }

}else{ echo "<tr><td><h4>No data found</h4></td></tr>";}
?>							
</tbody>
                                    </table>
                                </div>
                            </div></div>
</div>
</div>
</div>
</div>
</div>
<?php include'footer.php';?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: all_comission.php

Server Info

System Features

User Info