MAINHACK

Viewing / Editing File: all_user_bills.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 Bills-><?=$_REQUEST['name']?></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>Sl</th>
                                    <th>Bill Time</th> 
                                    <th>Bill Id</th>
                                    <th>Customer Details</th>
                                    <th>Amount</th>   
                                    <th>Status</th> 
                                    <th>Pay Status</th> 
                                    <th>TXNID/TXN MSG</th> 	
                                    <th>Bank TXN/BANK TXNID</th> 	
                                    <th>Refunded</th> 
                                    <th>Delivery</th> 
                                    <th>Bill</th>

<th>Show/Delete</th>
								</tr>
							</thead>
							<tbody>

<?php
$show=new Oops($db);

$count=1;
$sr='place_order';
$stmt =$show->readwithdata($sr,'user_id',$_REQUEST['uid']);
$num = $stmt->rowCount();
if($num>0){
 
        while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
        extract($row);
        $id=$row['id'];
$pro_id=$row['order_id'];
	echo "	<tr>
								  <td>$count</td>
								  <td>".date('d-m-Y h:i a',strtotime($row['date']))."</td>
								  <td><a href='show_bill.php?id=".$row['order_id']."'>".$row['order_id']."</a></td>
								  <td>".$row['user_id']."<br>".$row['client_name']."<br>".$row['email']."<br>".$row['phon']."</td>
								  <td>".$row['amount']."</td>
								  	<td>".$row['status']."</td>									
								  	<td>".$row['pay_status']."</td>

<td>".$row['txnid']."<br>".$row['txn_msg']."</td>	
								    <td>".$row['bank_name']."<br>".$row['bank_txn']."</td>	
								";
								?>
								  <td>
                                <script>
                                $(document).ready(function(){
                                $('#status<?=$count;?>').change(function(){
                                var trend=$('#status<?=$count;?>').val();
                                var id=$('#id<?=$count;?>').val();
                                //alert(trend);
                                $.ajax({
                                type: "POST",
                                url: "ajax_check.php", // Name of the php files
                                data: "status="+trend+"&id="+id,
                                async: false,
                                global: false,
                                success: function(result)
                                {
                                window.location.reload();
                                }
                                });
                                });
                                });
                                </script>			   
						   
						     	<?php 
						     	$interests = array('NO','YES'); 
?>
						<select name="refund" id="refund<?=$count;?>">
<?php foreach( $interests as  $interest ): ?>
<option value="<?php echo $interest ?>"<?php if( $interest==$row['refund']): ?> selected="selected"<?php endif; ?>><?php echo $interest ?></option>
<?php endforeach; ?>
</select>	  <input type="hidden" id="id<?=$count?>" value="<?=$row['id']?>" >
                                    </td>    
								  <td>
                                <script>
                                $(document).ready(function(){
                                $('#refund<?=$count;?>').change(function(){
                                var refund=$('#refund<?=$count;?>').val();
                                var id=$('#id<?=$count;?>').val();
                                //alert(trend);
                                $.ajax({
                                type: "POST",
                                url: "ajax_check.php", // Name of the php files
                                data: "refund="+refund+"&id="+id,
                                async: false,
                                global: false,
                                success: function(result)
                                {
                                window.location.reload();
                                }
                                });
                                });
                                });
                                </script>			   
						   
						     	<?php 
						     	$interests = array('DELIVERED','NOT DELIVERED'); 
?>
						<select name="status" id="status<?=$count;?>">
<?php foreach( $interests as  $interest ): ?>
<option value="<?php echo $interest ?>"<?php if( $interest==$row['status']): ?> selected="selected"<?php endif; ?>><?php echo $interest ?></option>
<?php endforeach; ?>
</select>	  <input type="hidden" id="id<?=$count?>" value="<?=$row['id']?>" >
                                    </td>    
								
								<?php

echo "<td><a href='bill_final.php?user=".$row['user_id']."&order=".$pro_id."' target='_blank'class='btn btn-xs btn-success'>Show Bill</a></td>

<td>
		<a href='delete.php?id=$id&table=$sr&url=".$_SERVER['REQUEST_URI']."' class='btn btn-xs btn-danger' onclick='return send();'>Delete</a>
								 </td>
								</tr>";

++$count;
								}

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

Server Info

System Features

User Info