MAINHACK

Viewing / Editing File: upcoming_package.php

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

.col-md-4,.col-md-2{ display:inline-block !important;}
    
    
</style>
		<div class="main-panel">
			<div class="content">
				<div class="container-fluid">
					<div class="page-header">
						<h4 class="page-title">Upcoming Expiry</h4>
						
					</div>
					<div class="row">
						<div class="col-md-12">
							<div class="card">
				<form method="post">
		    <div class="col-md-4">
		        <label>From</label>
		    <input type="date" class="form-control" name="from"></div>
		    <div class="col-md-4">    
		    <label>To</label>
		  <input type="date" class="form-control" name="to"></div>
		    </div>
		    <div class="col-md-2"><input type="submit" name="sub" class="btn btn-xs btn-info" value="Search"></div>
		</form>
				
								<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>Package Name/Id</th>
                                <th>Name </th>
                                <th>Email/Phone</th>
                                <th>Date of Purchase</th>
                                <th>Date of Expiry</th>
                                <th>Txn Id</th>
                                <th>Status</th>
                                <th>Payment Status</th>
                               <th>Action</th>
								</tr>
							 </thead>
			 <tbody>

<?php
if(isset($_POST['sub'])){
      $sr='user';
   $from=date('Y-m-d',strtotime($_POST['from']));
    $to=date('Y-m-d',strtotime($_POST['to']));
   $sq="select * from user left join user_package on user.user_id=user_package.user_id  where user_package.expiry between '$from' and '$to' order by user_package.expiry asc";
    $stmt=$con->prepare($sq);
    $stmt->execute();
    $num = $stmt->rowCount();
    if($num>0){
    $count=1;
    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
    extract($row);
    $id=$row['id']; 
    
    $s11=$show->readwithdata('user_package','user_id',$row['user_id']);
    $n11=$s11->rowCount();
      while ($row11 = $s11->fetch(PDO::FETCH_ASSOC)){
 
   $s1=$show->readwithdata('package','package_id',$row11['package_id']);
      while ($row1 = $s1->fetch(PDO::FETCH_ASSOC)){
      $package_name=$row1['package_name'];     
      }
   
    //echo $n1;
    echo "<tr>
    <td>$count</td>
      <td>".$row11['package_id']."<br>".$package_name."</td>
  <td>".$row['user_id']."<br>".$row['name']."</td>
    <td>".$row['email']."<br>".$row['phone']."</td>
    <td>".date('d-m-Y',strtotime($row11['date']))."</td>
    <td><b>".date('d-m-Y',strtotime($row11['expiry']))."</b></td>
     <td>".$row11['txn_id']."</td>
      <td>".$row11['status']."</td>
     <td>".$row11['pay_status']."</td>
  ";
    
?>
<?php    
    
    echo "
    <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;
 }
        
    }
}
    
}else{			
    $count=1;
    $sr='user';
    // $stmt =$show->readAll($sr);
   $sq="select * from user left join user_package on user.user_id=user_package.user_id order by user_package.expiry asc";
    $stmt=$con->prepare($sq);
    $stmt->execute();
    $num = $stmt->rowCount();
    if($num>0){
    $count=1;
    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
    extract($row);
    $id=$row['id']; 
    
    $s11=$show->readwithdata('user_package','user_id',$row['user_id']);
    $n11=$s11->rowCount();
      while ($row11 = $s11->fetch(PDO::FETCH_ASSOC)){
 
   $s1=$show->readwithdata('package','package_id',$row11['package_id']);
      while ($row1 = $s1->fetch(PDO::FETCH_ASSOC)){
      $package_name=$row1['package_name'];     
      }
   
    //echo $n1;
    echo "<tr>
    <td>$count</td>
      <td>".$row11['package_id']."<br>".$package_name."</td>
  <td>".$row['user_id']."<br>".$row['name']."</td>
    <td>".$row['email']."<br>".$row['phone']."</td>
    <td>".date('d-m-Y',strtotime($row11['date']))."</td>
    <td><b>".date('d-m-Y',strtotime($row11['expiry']))."</b></td>
     <td>".$row11['txn_id']."</td>
      <td>".$row11['status']."</td>
     <td>".$row11['pay_status']."</td>
  ";
    
?>
<?php    
    
    echo "
    <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: upcoming_package.php

Server Info

System Features

User Info