MAINHACK

Viewing / Editing File: all_comission_monthly.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(Monthly)</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>
                                         <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>Payout</th>
                                             <th>Taxes & Delivery</th>
                                            <th>Order Details</th>
                                            <th>Weekly Details</th>
</tr> 
                                        </thead>
<tbody>
		
		
<?php
			$comi_total=0;$ot=0;$total_pay=0;
$count=1;
//$sr='property';
//$stmt =$show->readAll($sr);
//$num = $stmt->rowCount();
// $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 order by sajh_comission.date desc ";    
//echo $sq;
 $sq="select sum(place_order.amount) as AMT,sum(place_order.total) as TOT,place_order.delivery_charge,place_order.amount,place_order.maker_id,place_order.date,place_order.status,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' group by MONTH(place_order.date),place_order.maker_id 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['TOT']-($row['TOT']*($row['comi_percent']/100));
                $ot +=$row['TOT']-($payout);
                $comi=$row['TOT']-($payout);
        $total_pay +=$payout;
		echo "<tr>
		<td>$count</td>
		<td>".date('M',strtotime($row['date']))."</td>
		<td>".$row['title']."<br>".$row['maker_id']."</td>
		<td>".$row['AMT']."</td>
		<td>".round($row['comi_percent'])."%=".$comi."</td>
		<td>".$row['TOT']."</td>
		<td>".$payout."</td>
		<td>".$row['delivery_charge']."</td>
		<td style='color:red;'><a href='payout_details.php?mid=".base64_encode($row['maker_id'])."&mn=".base64_encode($row['date'])."' class='btn btn-xs btn-info'>Details</a></td>
			<td style='color:red;'><a href='payout_details_weekly.php?mid=".base64_encode($row['maker_id'])."&mn=".base64_encode($row['date'])."' class='btn btn-xs btn-success'>Weekly Details</a></td>
	</tr>";

++$count;
 }
 	echo "<tr style='background-color: #d0d0e1;' ><td colspan='3'></td><td>Total Commission :</td><td>$ot</td><td>Total Payout :</td><td>$total_pay</td></tr>";	
}
?>							
						
</tbody></table>								
									
									</div>
				
									</div>
								</div>
							</div>
						</div>

</div>
				</div>
			</div>
			
		</div>

$('#multi-filter-select').DataTable( {
				"pageLength": 5,
				initComplete: function () {
					this.api().columns().every( function () {
						var column = this;
						var select = $('<select class="form-control"><option value=""></option></select>')
						.appendTo( $(column.footer()).empty() )
						.on( 'change', function () {
							var val = $.fn.dataTable.util.escapeRegex(
								$(this).val()
								);

column
							.search( val ? '^'+val+'$' : '', true, false )
							.draw();
						} );

column.data().unique().sort().each( function ( d, j ) {
							select.append( '<option value="'+d+'">'+d+'</option>' )
						} );
					} );
				}
			});

// Add Row
			$('#add-row').DataTable({
				"pageLength": 5,
			});

var action = '<td> <div class="form-button-action"> <button type="button" data-toggle="tooltip" title="" class="btn btn-link btn-primary btn-lg" data-original-title="Edit Task"> <i class="la la-edit"></i> </button> <button type="button" data-toggle="tooltip" title="" class="btn btn-link btn-danger" data-original-title="Remove"> <i class="la la-times"></i> </button> </div> </td>';

$('#addRowButton').click(function() {
				$('#add-row').dataTable().fnAddData([
					$("#addName").val(),
					$("#addPosition").val(),
					$("#addOffice").val(),
					action
					]);
				$('#addRowModal').modal('hide');

});
		});
	</script>
<?php include'footer.php';?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: all_comission_monthly.php

Server Info

System Features

User Info