MAINHACK

Viewing / Editing File: payout_details.php

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

$date=date('m',strtotime($mn));
?>

<div class="main-panel">
			<div class="content">
				<div class="container-fluid">
					<div class="page-header">
						<h4 class="page-title">All Payout Details(Datewise)(<?=$mid?>)</h4>
						
					</div>
					<div class="row">
					
									<div class="col-md-12">
				    	<div class="card-body">
		    <div class="form-group form-show-validation row">
				<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 text-right">Business<br>Name<span class="required-label">*</span></label>
				<div class="col-lg-3 col-md-9 col-sm-8">
					<input type="text" class="form-control" id="name" name="title" value="<?=$ftitle?>" placeholder="Enter Name" readonly>
				</div>
		
				<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 text-right">Maker ID <span class="required-label">*</span></label>
				<div class="col-lg-3 col-md-9 col-sm-8">
					<input type="text" class="form-control" id="name" name="name" value="<?=$mid?>" placeholder="Enter Maker ID " readonly>
				</div>
				<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 text-right">Name <span class="required-label">*</span></label>
				<div class="col-lg-2 col-md-9 col-sm-8">
					<input type="text" class="form-control" id="name" name="name" value="<?=$uname?>" placeholder="Enter Name" readonly>
				</div>
			</div>
			
			<div class="form-group form-show-validation row">
				<label for="email" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 text-right">Email <span class="required-label"></span></label>
				<div class="col-lg-3 col-md-9 col-sm-8">
					<input type="email" class="form-control" value="<?=$uemail?>" name="email" id="email" placeholder="Enter Email"readonly>
				</div>
		
				<label for="email" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 text-right">Phone<span class="required-label">*</span></label>
				<div class="col-lg-2 col-md-9 col-sm-8">
					<input type="text" class="form-control" id="phn"  value="<?=$uphone?>"  name="phone" placeholder="Enter Phone" readonly>

</div>
					<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 text-right">Comission <span class="required-label">*</span></label>
				<div class="col-lg-2 col-md-9 col-sm-8">
					<input type="number" class="form-control" name="comi_percent" value="<?=$comi_percent?>" readonly>
				</div>
			</div>
					<div class="form-group form-show-validation row">
		<label for="email" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 text-right">A/C No <span class="required-label"></span></label>
				<div class="col-lg-2 col-md-9 col-sm-8">
					<input type="text" class="form-control" value="<?=$ac_no?>" name="ac_no" id="email" placeholder="A/C No" readonly>
				</div>
		<label for="email" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 text-right">Bank Name<span class="required-label"></span></label>
				<div class="col-lg-2 col-md-9 col-sm-8">
					<input type="text" class="form-control" value="<?=$bank?>" name="bank" id="email" placeholder="Bank Name" readonly>
				</div>	
		              
		  <label for="email" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 text-right">Branch<span class="required-label"></span></label>
				<div class="col-lg-2 col-md-9 col-sm-8">
					<input type="text" class="form-control" value="<?=$branch?>" name="branch" id="email" placeholder="Branch" readonly>
				</div>            
		                </div>

<div class="form-group form-show-validation row">
		<label for="email" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 text-right">IFSC<span class="required-label"></span></label>
				<div class="col-lg-2 col-md-9 col-sm-8">
					<input type="text" class="form-control" value="<?=$ifsc?>" name="ifsc" id="email" placeholder="IFSC" readonly>
				</div>
				
			 </div>	
                </div>
</div>

<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>Clear</th>
                                            <th>Date</th>
                                            <th>Maker Details</th>
                                            <th>Bill Id</th>
                                             <th>Total Bill</th>
                                             <th>Product Amt</th>
                                             <th>Comission(%)</th>
                                             <th>Taxes & Delivery</th>
                                             <th>Payout</th>
</tr> 
                                        </thead>
<tbody>
		
		
<?php

$comi_total=0;
$count=1;
$sq1=$show->readwithdata('food_maker','maker_id',$mid);
       while ($row1 = $sq1->fetch(PDO::FETCH_ASSOC)){
           $ftitle=$row1['title'];
            $comi_percent=$row1['comi_percent'];
      }
// $sq="select * from payout_log order by id desc ";    
 // $sq="select *,place_order.order_id as oid,place_order.date as pdate,place_order.maker_id as mid from place_order left join payout_log on place_order.maker_id=payout_log.maker_id where MONTH(place_order.date)='".$date."' and place_order.maker_id='".$mid."' group by place_order.order_id order by place_order.date desc ";   
//echo $sq;
$sq="select * ,place_order.order_id as oid,place_order.date as pdate,place_order.maker_id as mid from place_order where MONTH(place_order.date)='".$date."' and place_order.maker_id='".$mid."' group by place_order.order_id order by place_order.date desc";
//echo $q;
$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'];
       
        extract($row);
  $s1=$show->readwithdata('payout_log','order_id',$row['order_id']);
        while ($row1 = $s1->fetch(PDO::FETCH_ASSOC)){
        $pay_status=$row1['payout_status'];
        $payid=$row1['id'];
            
        }
        
        $ot=$row['gst']+($row['delivery_charge']);
        $payout=$row['total']-($row['total']*($comi_percent/100));
        if($pay_status=='CLEARED'){
            $pstatus='checked';
            $bill='<a href="receipt.php?payid='.$payid.'&oid='.$row['oid'].'&mid='.$row['mid'].'" class="btn btn-xs btn-warning" target="_blank">Bill</a>';
        }else $pstatus='';
      //  echo $pstatus;
		echo "<tr>
		<td>$count</td>
		<td>
		<input type='checkbox' name='clear[]' $pstatus value='clear'><br>
		$bill
		<input type='hidden' name='maker_id[]' value='".$row['mid']."'>
		<input type='hidden' name='order_id[]' value='".$row['oid']."'>
		<input type='hidden' name='payout[]' value='".$payout."'>
		<input type='hidden' name='amount[]' value='".$row['amount']."'>
		<input type='hidden' name='total[]' value='".$row['total']."'>
		<input type='hidden' name='comi_percent[]' value='".$row['total']*($comi_percent/100)."'>
		
		</td>
		<td>".date('d-m-Y',strtotime($row['pdate']))."</td>
		<td>".$row['maker_id']."<br>".$ftitle."</td>
		<td>".$row['oid']."</td>
		<td style='background-color:#fb6161;color:#fff'>".$row['amount']."</td>
		<td style='background-color:#58b567;color:#fff'>".$row['total']."</td>
		<td>".round($comi_percent)." % of ".$row['total']." = ".($row['total']*($comi_percent/100))."</td>
		<td >".$ot."</td>
		<td style='background-color:#639fdf;color:#fff'>".$payout."</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'])){
   // $url="cleared_payout.php?mkid=".$_POST['mkid'];
   // echo $url;
    if(isset($_POST['clear'])){
        foreach ($_POST['clear'] as $key=>$value){
// echo $_POST['maker_id'][$key];
$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: payout_details.php

Server Info

System Features

User Info