MAINHACK

Viewing / Editing File: all_paid_payoutweekly.php

<?php include'header.php';?>
<style>
    .col-md-2,.col-md-3,.col-md-4{
    display:inline-block !important;
}
</style>
<script src="jquery-1.11.1.min.js"></script>

<div class="main-panel">
			<div class="content">
				<div class="container-fluid">
					<div class="page-header">
						<h4 class="page-title">All Payout Details(Weekly)</h4>
						
					</div>
					<div class="row">
        
						<div class="col-md-12">
							<div class="card">
							
								<div class="card-body">
									<div class="table-responsive">
	<form method="post">			
					            <table id="basic-datatables" class="display table table-striped table-hover">                                        <thead>
                                         <thead>
                                            <tr>
                                            <th>ID</th>
                                            <th>Week</th>
                                            <th>Maker Details</th>
                                             <th>Total Bill</th>
                                             <th>Product Amt</th>
                                             <th>Comission(%)</th>
                                             <th>Payout</th>
</tr> 
                                        </thead>
<tbody>
		
		
<?php
function getStartAndEndDate($week, $year) {
  $dateTime = new DateTime();
  $dateTime->setISODate($year, $week);
  $result['start_date'] = $dateTime->format('d-m-Y');
  $dateTime->modify('+6 days');
  $result['end_date'] = $dateTime->format('d-m-Y');
  return $result;
}
$dates=getStartAndEndDate($week,$year);
//print_r($dates);

//SELECT WEEK(date) WeekNumber, COUNT(order_id) orders FROM place_order GROUP BY WEEK(date) ORDER BY WEEK(date);

$comi_total=0;
$count=1;

$sq="select *,WEEK(date) as WeekNumber,SUM(total) as TOT,SUM(amount) as AMT from place_order GROUP BY WEEK(date) ORDER BY WEEK(date)";
//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'];  
        extract($row);
 
       // $ot=$row['gst']+($row['delivery_charge']);
        $payout=$row['TOT']-($row['TOT']*($comi_percent/100));
        if($pay_status=='CLEARED'){
            $pstatus='checked';
        }else $pstatus='';
      //  echo $pstatus;
      $week=$row['WeekNumber'];
      $year=date('Y');
      
      $date=getStartAndEndDate($week,$year);
      //echo ;
		echo "<tr>
		<td>$count</td>
		
		<input type='hidden' name='start_date[]' value='".$date['start_date']."'>
		<input type='hidden' name='end_date[]' value='".$date['end_date']."'>
	
	
		<td>".$date['start_date']." to ".$date['end_date']."</td>
		<td>".$row['maker_id']."<br>".$ftitle."</td>
		<td style='background-color:#fb6161;color:#fff'>".$row['AMT']."</td>
		<td style='background-color:#58b567;color:#fff'>".$row['TOT']."</td>
		<td>".round($comi_percent)." % of ".$row['TOT']." = ".($row['TOT']*($comi_percent/100))."</td>
		<td style='background-color:#84df63;color:#fff'><a href='payout_details.php?mid=".base64_encode($mid)."&mn=".base64_encode($mn)."'>".$payout."</a></td>
		";

<?php	
		echo "</tr>";

++$count;
 }
}
?>							
	
</tbody></table>	
		<input type="hidden" name="mkid" value="<?=base64_decode($_REQUEST['mid'])?>">

<input type="submit" value="Clear Payout" name="sub" class="btn btn-xs btn-success">
						</form>	
									
<?php
if(isset($_POST['sub'])){
 
    if(isset($_POST['clear'])){
        foreach ($_POST['clear'] as $key=>$value){
            
$date1=date("Y-m-d",strtotime($_POST['start_date'][$key]))." 00:00:00";
$date2=date("Y-m-d",strtotime($_POST['end_date'][$key]))." 23:59:59";

$sq="select * from place_order where date between '$date1' and '$date2'";            
            
$insert="insert INTO payout_log (maker_id,date,order_id,total_amount,payout,payout_status,comission,p_amount)
SELECT place_order.maker_id,place_order.date,place_order.order_id,place_order.amount,place_order.total-(place_order.total*(food_maker.comi_percent/100)),'CLEARED',food_maker.comi_percent,place_order.total
FROM place_order inner join food_maker on place_order.maker_id=food_maker.maker_id
WHERE place_order.date between '$date1' and '$date2'";
echo $insert;
$s12=$con->prepare($insert);
$s12->execute();

/*
$s1="select * from payout_log where order_id='".$_POST['order_id'][$key]."' and payout_status='CLEARED'";
$s12=$con->prepare($s1);
$s12->execute();
$num=$s12->rowCount();

if($num==0){

$data=array(
    'maker_id'=>$_POST['maker_id'][$key],
    'order_id'=>$_POST['order_id'][$key],
    'payout'=>$_POST['payout'][$key],
    'total_amount'=>$_POST['amount'][$key],
    'p_amount'=>$_POST['total'][$key],
    'comission'=>$_POST['comi_percent'][$key],
    'payout_status'=>'CLEARED',
    'date'=>date('Y-m-d')
    
    );
    $r=$show->insert('payout_log',$data);
    
    if($r){
 //       	echo "<script>sweetAlert('Ok','Payout is cleared now','success');window.location.href='cleared_payout.php?mkid='.$mid.';</script>";
  echo"<script>
        setTimeout(function() {
        swal({
            title: 'Ok!',
            text: 'Payout is cleared now',
            type: 'success'
        }, function() {
            window.location ='".$_SERVER['REQUEST_URI']."';
        });
    }, 1000);
</script>";
    }
   
}
*/
    }
    
}
}

?>
	
									</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_paid_payoutweekly.php

Server Info

System Features

User Info