MAINHACK

Viewing / Editing File: dashboard.php

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

<div class="main-panel">
			<div class="content">
				<div class="container-fluid">
					<div class="page-header">
						<h4 class="page-title">Dashboard</h4>
					
					</div>
					<div class="row">
				 	<div class="col-sm-3 col-md-3">
							<div class="card card-stats card-info card-round">
								<div class="card-body">
									<div class="row">
										<div class="col-5">
											<div class="icon-big text-center">
												<i class="flaticon-interface-6"></i>
											</div>
										</div>
										<div class="col-7 col-stats">
											<div class="numbers">
													<a href="all_user.php"><p class="card-category">All Users</p></a>
												
											</div>
										</div>
									</div>
								</div>
							</div>
						</div>
            	   
            	    	<div class="col-sm-3 col-md-3">
							<div class="card card-stats card-success card-round">
								<div class="card-body">
									<div class="row">
										<div class="col-5">
											<div class="icon-big text-center">
												<i class="flaticon-interface-6"></i>
											</div>
										</div>
										<div class="col-7 col-stats">
											<div class="numbers">
													<a href="all_papers_new.php"><p class="card-category">All Papers</p></a>
												
											</div>
										</div>
									</div>
								</div>
							</div>
						</div>
            	   
            	    	<div class="col-sm-3 col-md-3">
							<div class="card card-stats card-warning card-round">
								<div class="card-body">
									<div class="row">
										<div class="col-5">
											<div class="icon-big text-center">
												<i class="flaticon-interface-6"></i>
											</div>
										</div>
										<div class="col-7 col-stats">
											<div class="numbers">
													<a href="all_package.php"><p class="card-category">All Packages</p></a>
												
											</div>
										</div>
									</div>
								</div>
							</div>
						</div>
            	    	<div class="col-sm-3 col-md-3">
							<div class="card card-stats card-danger card-round">
								<div class="card-body">
									<div class="row">
										<div class="col-5">
											<div class="icon-big text-center">
												<i class="flaticon-interface-6"></i>
											</div>
										</div>
										<div class="col-7 col-stats">
											<div class="numbers">
													<a href="upcoming_package.php"><p class="card-category">Upcoming expiry</p></a>
												
											</div>
										</div>
									</div>
								</div>
							</div>
						</div>
            	   		<div class="col-sm-3 col-md-3">
							<div class="card card-stats card-success card-round">
								<div class="card-body">
									<div class="row">
										<div class="col-5">
											<div class="icon-big text-center">
												<i class="flaticon-interface-6"></i>
											</div>
										</div>
										<div class="col-7 col-stats">
											<div class="numbers">
													<a href="all_tickets.php"><p class="card-category">All Tickets</p></a>
												
											</div>
										</div>
									</div>
								</div>
							</div>
						</div>
						<div class="col-sm-3 col-md-3">
							<div class="card card-stats card-info card-round">
								<div class="card-body">
									<div class="row">
										<div class="col-5">
											<div class="icon-big text-center">
												<i class="flaticon-interface-6"></i>
											</div>
										</div>
										<div class="col-7 col-stats">
											<div class="numbers">
													<a href="all_bill.php"><p class="card-category">All Bills</p></a>
												
											</div>
										</div>
									</div>
								</div>
							</div>
						</div>
					</div>
			<div class="row">
			    
			    						<div class="col-md-12">
			    						    	<h4 class="page-title">Latest Bills</h4>	
							<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>Order Id</th>
                                    <th>Date of Package</th>
                                    <th>Date of Expiry</th>
                                    <th>Name/Email<br>phone</th>
                                    <th>Package Id</th>
                                    <th>Amount</th> 
                                    <th>Txn Id</th>
                                    <th>Pay Status</th>
                                    <th>Show/Delete</th>
								</tr>
							</thead>
							<tbody>

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

$count=1;
$sr='place_order';
$date1=date('Y-m-d 00:00:00');
$date2=date('Y-m-d 23:59:59');
$stmt=$show->readAll_clause('user_package','order by id desc limit 10');
$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>".$pro_id."</td>
                                    <td>".date("d-m-Y",strtotime($row['date']))."</td>
                                    <td>".date("d-m-Y",strtotime($row['expiry']))."</td>
                                    <td>".$row['name']."<br>".$row['email']."<br>".$row['phone']."</td>
                                    <td>".$row['package_id']."</td>
                                    <td>".$row['amount']."</td>
                                    <td>".$row['txn_id']."</td>
                                    <td>".$row['pay_status']."</td>

<td><a href='bill_final.php?user=".$row['user_id']."&order=".$pro_id."' target='_blank'class='btn btn-xs btn-success'>Show Bill</a>
						   
		<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 class="row">
			    
			    						<div class="col-md-12">
			    						    	<h4 class="page-title">Latest Users</h4>	
							<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>Date</th>
                                <th>Name </th>
                                <th>Email/Phone</th>
                                <th>City/Address</th>
                                <th>Status</th>
                                <th>Exam Given</th>
                                <th>Packages</th>
                               
                                 <th>Password</th>
                               <th>Action</th>
								</tr>
							 </thead>
			 <tbody>

<?php
			
    $count=1;
    $sr='user';
     $stmt =$show->readAll_clause($sr,'order by id desc limit 10');
    $num = $stmt->rowCount();
    if($num>0){
    $count=1;
    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
    extract($row);
    $id=$row['id']; 
    $s1=$show->readwithdata('result','user_id',$row['user_id']);
    $n1=$s1->rowCount();
    $s11=$show->readwithdata('user_package','user_id',$row['user_id']);
    $n11=$s11->rowCount();
    
    
    //echo $n1;
    echo "<tr>
    <td>$count</td>
    <td>".date('d-m-Y',strtotime($row['date_of_creation']))."</td>
    <td>".$row['name']."</td>
    <td>".$row['email']."<br>".$row['phone']."</td>
    <td>".$row['city']."<br>".$row['address']."</td>";
    
?>
  <td>
                                         <script>
                                function status(Value){
									//alert(Value);
								var st="#status"+Value;
                                var id_txt="#id"+Value;
                                
								var status=$(st).val();
                                var id=$(id_txt).val();	
								var table='<?php echo $sr ?>';
                               
                                $.ajax({
                                type: "POST",
                                url: "ajax_check.php", // Name of the php files
                                data: "ustatus="+status+"&id="+id+"&table="+table,
                                async: false,
                                global: false,
								 beforeSend: function(){
								/* Show image container */
								$("#loader").show();
							   },
                                success: function(result)
                                { 
								  $( "#basic-datatables" ).load( "all_user.php #basic-datatables" );
                                //window.location.reload();

//table.ajax.reload();

}
								
                                });
                                }
                                </script>			   
						   
						     	<?php 
						     	$interests = array('ACTIVE','INACTIVE'); 
?>
						<select name="status" onchange="status(<?=$count;?>)"   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']?>" >
                         
						 
<div id='loader' style='display: none;'>
  <img src='loader.gif' width='32px' height='32px'>
</div>
  </td>
<?php    
    
    echo "<td>Exam Appired: $n1<br> <a href='all_exam_user.php?id=$id&table=$sr&uid=".$row['user_id']."&name=".$row['name']."&url=".$_SERVER['REQUEST_URI']."' class='btn btn-xs btn-info' >User Exams</a></td>
     <td>Packages : $n11<a href='edit_package_show.php?id=$id&table=$sr&uid=".$row['user_id']."&url=".$_SERVER['REQUEST_URI']."' class='btn btn-xs btn-info' >User Packages</a></td>
   <td>
  <a href='change_password.php?id=$id&table=$sr&uid=".$row['user_id']."&name=".$row['name']."&url=".$_SERVER['REQUEST_URI']."' class='btn btn-xs btn-warning' >Change Password</a></td>
  <td>
  <a href='edit_user.php?id=$id&table=$sr&url=".$_SERVER['REQUEST_URI']."' class='btn btn-xs btn-success' >Edit User</a>
    <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 class="quick-sidebar">
			<a href="#" class="close-quick-sidebar">
				<i class="flaticon-cross"></i>
			</a>
			<div class="quick-sidebar-wrapper">
				<ul class="nav nav-tabs nav-line nav-color-primary" role="tablist">
					<li class="nav-item"> <a class="nav-link active show" data-toggle="tab" href="#messages" role="tab" aria-selected="true">Messages</a> </li>
					<li class="nav-item"> <a class="nav-link" data-toggle="tab" href="#tasks" role="tab" aria-selected="false">Tasks</a> </li>
					<li class="nav-item"> <a class="nav-link" data-toggle="tab" href="#settings" role="tab" aria-selected="false">Settings</a> </li>
				</ul>
				<div class="tab-content mt-3">
					<div class="tab-chat tab-pane fade show active" id="messages" role="tabpanel">
						<div class="messages-contact">
							<div class="quick-wrapper">
								<div class="quick-scroll scrollbar-outer">
									<div class="quick-content contact-content">
										<span class="category-title mt-0">Recent</span>
										<div class="contact-list contact-list-recent">
											<div class="user">
												<a href="#">
													<div class="user-image">
														<img src="assets/img/jm_denis.jpg" alt="denis">
														<span class="status online"></span>
													</div>
													<div class="user-data">
														<span class="name">Jimmy Denis</span>
														<span class="message">How are you ?</span>
													</div>
												</a>
											</div>
											<div class="user">
												<a href="#">
													<div class="user-image">
														<img src="assets/img/chadengle.jpg" alt="chad">
														<span class="status away"></span>
													</div>
													<div class="user-data">
														<span class="name">Chad</span>
														<span class="message">Ok, Thanks !</span>
													</div>
												</a>
											</div>
											<div class="user">
												<a href="#">
													<div class="user-image">
														<img src="assets/img/mlane.jpg" alt="john doe">
														<span class="status offline"></span>
													</div>
													<div class="user-data">
														<span class="name">John Doe</span>
														<span class="message">Ready for the meeting today with...</span>
													</div>
												</a>
											</div>
										</div>
										<span class="category-title">Contacts</span>
										<div class="contact-list">
											<div class="user">
												<a href="#">
													<div class="user-image">
														<img src="assets/img/jm_denis.jpg" alt="denis">
														<span class="status"></span>
													</div>
													<div class="user-data2">
														<span class="name">Jimmy Denis</span>
													</div>
												</a>
											</div>
											<div class="user">
												<a href="#">
													<div class="user-image">
														<img src="assets/img/chadengle.jpg" alt="chad">
														<span class="status away"></span>
													</div>
													<div class="user-data2">
														<span class="name">Chad</span>
													</div>
												</a>
											</div>
											<div class="user">
												<a href="#">
													<div class="user-image">
														<img src="assets/img/talha.jpg" alt="talha">
														<span class="status offline"></span>
													</div>
													<div class="user-data2">
														<span class="name">Talha</span>
													</div>
												</a>
											</div>
										</div>
									</div>
								</div>
							</div>
						</div>
						<div class="messages-wrapper">
							<div class="messages-title">
								<div class="user">
									<img src="assets/img/chadengle.jpg" alt="chad">
									<span class="name">Chad</span>
									<span class="last-active">Active 2h ago</span>
								</div>
								<button class="return">
									<i class="flaticon-left-arrow-3"></i>
								</button>
							</div>
							<div class="messages-body messages-scroll scrollbar-outer">
								<div class="message-content-wrapper">
									<div class="message message-in">
										<div class="message-pic">
											<img src="assets/img/chadengle.jpg" alt="chad">
										</div>
										<div class="message-body">
											<div class="message-content">
												<div class="name">Chad</div>
												<div class="content">Hello, Rian</div>
											</div>
										</div>
									</div>
								</div>
								<div class="message-content-wrapper">
									<div class="message message-out">
										<div class="message-body">
											<div class="message-content">
												<div class="content">
													Hello, Chad
												</div>
											</div>
										</div>
									</div>
								</div>
								<div class="message-content-wrapper">
									<div class="message message-in">
										<div class="message-pic">
											<img src="assets/img/chadengle.jpg" alt="chad">
										</div>
										<div class="message-body">
											<div class="message-content">
												<div class="name">Chad</div>
												<div class="content">
													When is the deadline of the project we are working on ?
												</div>
											</div>
										</div>
									</div>
								</div>
								<div class="message-content-wrapper">
									<div class="message message-out">
										<div class="message-body">
											<div class="message-content">
												<div class="content">
													The deadline is about 2 months away
												</div>
											</div>
										</div>
									</div>
								</div>
								<div class="message-content-wrapper">
									<div class="message message-in">
										<div class="message-pic">
											<img src="assets/img/chadengle.jpg" alt="chad">
										</div>
										<div class="message-body">
											<div class="message-content">
												<div class="name">Chad</div>
												<div class="content">
													Ok, Thanks !
												</div>
											</div>
										</div>
									</div>
								</div>
							</div>
							<div class="messages-form">
								<div class="messages-form-control">
									<input type="text" placeholder="Type here" class="form-control input-pill input-solid message-input">
								</div>
								<div class="messages-form-tool">
									<a href="#" class="attachment">
										<i class="flaticon-file"></i>
									</a>
								</div>
							</div>
						</div>
					</div>

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

<script >
		$(document).ready(function() {
			$('#basic-datatables').DataTable({
			});

$('#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: dashboard.php

Server Info

System Features

User Info