File Manager

✏️ Edit File: /home/coemyoza/sms.coeminna.edu.ng/admins/dashboard.php

<?php //include '../db/dbc.php'; 
//page_protect();
//
////check whelther logon users is not from the member or operator
//if(!checkUser()) { 
//header("Location: ../?info=1");
//}
////Function call to log out user if the system is inactive
//checkTimeout();
//
//$err = array();
//$inf = array();
//$war = array();
//$msg = array();

//Scripts to update personal detail
//if(isset($_POST['submit'])) {
//
//$sub = $_POST['subject'];
//$message = $_POST['message'];
//
//if (empty($sub)) 
//	{ $err[] = 'ERROR! Fill all the neccessary fields.'; }
//	
//else { 
//
////scripts for upload
//		$path = "../downloads/"; //Scripts for file upload
//		$valid_formats = array('pdf', 'doc', 'docx', 'jpg', 'png', 'jpeg'); //allow file type
//		
//		if(isset($_POST) and $_SERVER['REQUEST_METHOD'] == "POST") {
//			//if(isset($_POST['attach'])){
//				
//			$name = $_FILES['myfile']['name'];
//			$size = $_FILES['myfile']['size'];
//			if(strlen($name)) {
//				list($txt, $ext) = explode(".", $name);
//				if(in_array($ext,$valid_formats)) {
//					if($size <= 900000) { //900KB
//						$actual_image_name = $name; //orignal name of the image
//						$tmp = $_FILES['myfile']['tmp_name'];
//						@unlink($path.$file); //delete uploaded image from a folder
//						if(move_uploaded_file($tmp, $path.$actual_image_name)) {
//
////insert the records into users table		
//$insert_user = "insert into `mailbox`(subject,message,mid,file_name,file_size,posted) 
//				VALUES('$sub', '$message', '$_SESSION[uid]', '$actual_image_name', '$size', NOW())";
//				$add_user = mysqli_query($link,$insert_user);		
//				$msg[] = 'Document successfully saved';
//				
////Sleep for 3 seconds.
//header("Refresh: 3; url=?option=users_account&view=20220301");
//						} else	$err[] = 'Upload failed';
//						
//					} else $err[] = 'Maximum size allowed (900KB)';
//					
//				} else $err[] = 'Sorry! only PDF, DOC, DOCX, JPG, JPEG, & PNG files are allowed to upload.';
//				
//			} else $err[] = 'Please select valid file to upload';
//			
//			//exit;
//		} 
////end of upload scripts
//	
//	}
//}
//
//
////delete records
//if(isset($_GET['view']) && $_GET['status'] == 'del') {
////update records
//mysqli_query($link,"DELETE FROM `mailbox` WHERE id = '$_GET[id]'");	
//
////insert record into users activities table		
//$insert_activity = "INSERT INTO `users_activities` (user_id, action, module, description, activationdate, activationtime, affected_user_id) 
//VALUES('$_SESSION[uid]','5','1','Mail deleted from mailbox',Now(),Now(),'$_GET[id]')";
//$add_activity = mysqli_query($link,$insert_activity);
//
//$msg[] = "Message successfully deleted"; 
// //Sleep for 3 seconds.
//header("Refresh: 3; url=?option=users_account&view=20220301");			
//}

//sum up the relevant information
$result_all = mysqli_query($link,"select count(*) as total_users from `default_users` where `access_level` < '6'");
$result_active = mysqli_query($link,"select count(*) as total_users from `default_users` where `access_level` < '6' and `banned` = '0'");
$result_inactive = mysqli_query($link,"select count(*) as total_users from `default_users` where `banned` = '1'");
$result_suspend = mysqli_query($link,"select count(*) as total_users from `default_users` where `banned` = '-1'");							   
list($total_users) = mysqli_fetch_row($result_all);
list($total_active) = mysqli_fetch_row($result_active);
list($total_inactive) = mysqli_fetch_row($result_inactive);
list($total_suspended) = mysqli_fetch_row($result_suspend);

$rs_payment = mysqli_query($link,"select count(*) as total_payment from payment_history where status = '1'");
$rs_hostel = mysqli_query($link,"select count(*) as total_hostel from hostel_applications where approval = '1'");
$rs_transcript = mysqli_query($link,"select count(*) as total_transcript from transcript_application");
$rs_admission = mysqli_query($link,"select count(*) as total_admission from default_users where access_level = '1' and status = '0'");
list($total_payment) = mysqli_fetch_row($rs_payment);
list($total_hostel) = mysqli_fetch_row($rs_hostel);
list($total_transcript) = mysqli_fetch_row($rs_transcript);
list($total_admission) = mysqli_fetch_row($rs_admission);
?>

<?php 
//select query from database
//$rs_settings = mysqli_query($link,"select * from `default_users` where id = '$_SESSION[uid]'");

//while ($info = mysqli_fetch_array($rs_settings)) { ?>
    
    <section class="content-header">
      <h1>
        Dashboard
        <small>Control panel</small>
      </h1>
      <ol class="breadcrumb">
        <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
        <li class="active">Dashboard</li>
      </ol>
    </section>
    
    
    <section class="content">
    
      <div class="row">
        <div class="col-lg-3 col-xs-6">
          
          <div class="small-box bg-aqua">
            <div class="inner">
              <h3><?php echo $total_users; ?></h3>

<p>Total Users</p>
            </div>
            <div class="icon">
              <i class="fa fa-group"></i>
            </div>
<?php if($_SESSION['access_level'] >='8') { ?>
            <a href="./?Account=PortalAccount&view=42020205" class="small-box-footer">
              More info <i class="fa fa-arrow-circle-right"></i>
            </a>
      <?php } ?>
          </div>
        </div>
        
        <div class="col-lg-3 col-xs-6">
          
          <div class="small-box bg-green">
            <div class="inner">
              <h3><?php echo $total_active; ?></h3>

<p>Active Users</p>
            </div>
            <div class="icon">
              <i class="ion ion-person"></i>
            </div>
<?php if($_SESSION['access_level'] >='8') { ?>
            <a href="./?Account=PortalAccount&view=42020205" class="small-box-footer">
              More info <i class="fa fa-arrow-circle-right"></i>
            </a>
    <?php } ?>
          </div>
        </div>
        
        <div class="col-lg-3 col-xs-6">
          
          <div class="small-box bg-yellow">
            <div class="inner">
              <h3><?php echo $total_inactive; ?></h3>

<p>Inactive Users</p>
            </div>
            <div class="icon">
              <i class="ion ion-person"></i>
            </div>
<?php if($_SESSION['access_level'] >='8') { ?>
            <a href="./?Account=PortalAccount&view=42020205" class="small-box-footer">
              More info <i class="fa fa-arrow-circle-right"></i>
            </a>
    <?php } ?>
          </div>
        </div>
        
        <div class="col-lg-3 col-xs-6">
          
          <div class="small-box bg-red">
            <div class="inner">
              <h3><?php echo $total_suspended; ?></h3>

<p>Suspended Users</p>
            </div>
            <div class="icon">
              <i class="fa fa-user"></i>
            </div>
<?php if($_SESSION['access_level'] >='8') { ?>
            <a href="./?Account=PortalAccount&view=42020205" class="small-box-footer">
              More info <i class="fa fa-arrow-circle-right"></i>
            </a>
    <?php } ?>
          </div>
        </div>
        
      </div>

<div class="row">
        <div class="col-md-3 col-sm-6 col-xs-12">
          <div class="info-box">
            <span class="info-box-icon bg-aqua"><i class="fa fa-money"></i></span>

<div class="info-box-content">
              <span class="info-box-text">Received Payment</span>
              <span class="info-box-number"><?php echo $total_payment; ?></span>
<?php if($_SESSION['access_level'] >='8' || $_SESSION['access_level'] >='5') { ?>
              <a href="./?Account=PortalAccount&view=42020212">View Details</a>
      <?php } ?>
            </div>
            
          </div>
          
        </div>
        
        
        <div class="col-md-3 col-sm-6 col-xs-12">
          <div class="info-box">
            <span class="info-box-icon bg-yellow"><i class="fa fa-hotel"></i></span>

<div class="info-box-content">
              <span class="info-box-text">Approved Hostel</span>
              <span class="info-box-number"><?php echo $total_hostel; ?></span>
<?php if($_SESSION['access_level'] >='8' || $_SESSION['access_level'] >='5') { ?>
             <a href="./?Account=PortalAccount&view=42020214">View Details</a>
     <?php } ?>
            </div>
            
          </div>
          
        </div>

<div class="clearfix visible-sm-block"></div>

<div class="info-box-content">
              <span class="info-box-text">Transcripts Req.</span>
              <span class="info-box-number"><?php echo $total_transcript; ?></span>
<?php if($_SESSION['access_level'] >='8' || $_SESSION['access_level'] >='4') { ?>
              <a href="./?Account=PortalAccount&view=42020213">View Details</a>
       <?php } ?>
            </div>
            
          </div>
          
        </div>
        
        
        <div class="col-md-3 col-sm-6 col-xs-12">
          <div class="info-box">
            <span class="info-box-icon bg-purple"><i class="fa fa-edit"></i></span>

<div class="info-box-content">
              <span class="info-box-text">Admission Req.</span>
              <span class="info-box-number"><?php echo $total_admission; ?></span>
<?php if($_SESSION['access_level'] >='8') { ?>
              
    <?php } ?>
            </div>
            
          </div>
          
        </div>
        
   
      </div>

<div class="row">
        
        <div class="col-md-8">
          
          
          
          <div class="box box-info">
            <div class="box-header with-border">
              <h3 class="box-title">Payment Logs</h3>

<?php $rs_mem = mysqli_query($link,"select * from `default_users` where id = '$info[matid]'"); 
				while ($rec = mysqli_fetch_array($rs_mem)) { $matno = $rec['username']; $fname = $rec['first_name']; $lname = $rec['last_name']; } ?>
          		<td><?php echo $matno; ?></td>
                
                 
                 <td><?php echo $info['description']; ?></td>
                <td><?php echo number_format($info['amount'],2); ?></td>
                 
                <td><?php if($info['status'] == 1) { echo '<span class="label label-success"> Successful</span>'; } 
				elseif($info['status'] == 0) { echo '<span class="label label-danger"> Pending</span>'; }
				elseif($info['status'] == 2) { echo '<span class="label label-primary"> Cancelled</span>'; } ?></td>
                
                <td><?php if($info['payment_type'] == 1) { echo 'Transfer'; }
				 elseif($info['payment_type'] == 2) { echo 'Bank Teller'; } 
				 else { echo 'Online'; } ?></td>
                 
                <td><?php echo $info['date_applied']; ?></td>
              </tr>
     	 <?php } ?>                
                  </tbody>
                </table>
              </div>
              
            </div>
            
 <?php if($_SESSION['access_level'] >='8' || $_SESSION['access_level'] >='5') { ?>
            <div class="box-footer clearfix">
              
              <a href="./?Account=PortalAccount&view=42020212" class="btn btn-sm btn-default btn-flat pull-right">View All</a>
            </div>
      <?php } ?>
            
          </div>
          
          <div class="box box-info">
            <div class="box-header with-border">
              <h3 class="box-title">Admission Seekers</h3>

<div class="box-tools pull-right">
                <button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i>
                </button>
                <button type="button" class="btn btn-box-tool" data-widget="remove"><i class="fa fa-times"></i></button>
              </div>
            </div>
            
            <div class="box-body">
              <div class="table-responsive">
<?php //select query from database
$rs_settings = mysqli_query($link,"select * from default_users where access_level = '1' and status = '0' order by id desc limit 10"); ?>
                <table class="table no-margin">
                  <thead>
                    <tr>
                      <th>Matric No.</th>
                 <th>Name</th>
                <th>Email</th>
                <th>Department</th>
                <th>Phone</th>
                <th>Status</th>
                <th>Date Reg.</th>
                <th>Actions</th>
                    </tr>
                  </thead>
                  <tbody>
          <?php while ($info = mysqli_fetch_array($rs_settings)) { ?>
              <tr>
                <td><?php if(!empty($info['md5'])) { echo '<span class="label label-warning">Processing</span>'; } else { echo $info['username']; } ?></td>
                <td><?php echo $info['last_name'].', '.$info['first_name']; ?></td>
                <td><?php echo $info['email']; ?></td>
                
          		<td><?php $rs_mem = mysqli_query($link,"select * from `default_groups` where id = '$info[access_level]'"); 
				while ($rec = mysqli_fetch_array($rs_mem)) { echo $rec['title']; } ?>
                </td>
                
                <td><?php echo $info['phone']; ?></td>
                <td><?php if($info['status'] == 1) { echo '<span class="label label-success">Active</span>'; } 
					elseif($info['status'] == 0) { echo '<span class="label label-warning">Pending</span>'; }
					else { echo '<span class="label label-info">Graduated</span>'; } ?></td>
                    
          <td><?php $vdate = date_create($info['date_created']); //create date to be formated
	echo strtoupper (date_format($vdate,"d/m/Y")); //output date formated ?></td>
   
<?php if($_SESSION['access_level'] >='8') { //to control buttons for admin only?>              
 <td><?php if($info['status'] == 0) { ?>
 <a href="./?Account=PortalAccount&view=42020209&action=view&id=<?php echo $info['id']; ?>"><span class="label label-primary">Review Application</span></a> 
  <a href="<?php echo $url."fps/actionAdmission.fps.php?action=inactive&uid=$_SESSION[uid]&id=$info[id]"; ?>" onClick="return confirm('WARNING: Do you really want to APPROVE this application? \n\n NOTE: Matric number will be generated if approved');"><span class="label label-danger">Approve</span></a>

<?php } else { ?>
 <a href="./?Account=PortalAccount&view=42020209&action=view&id=<?php echo $info['id']; ?>"><span class="label label-info">Check Details</span></a>  

 <?php } ?>
</td>
<?php } else { echo '<td>&nbsp;</td>'; } ?>
              </tr>
     	 <?php } ?>
                  </tbody>
                </table>
              </div>
              
            </div>
            
<?php if($_SESSION['access_level'] >='8') { ?>
            <div class="box-footer clearfix">
              <a href="./?Account=PortalAccount&view=42020209" class="btn btn-sm btn-default btn-flat pull-right">View All</a>
            </div>
     <?php } ?>
            
          </div>
          
        </div>

<div class="col-md-4">
         
          
          <div class="box box-primary">
            <div class="box-header with-border">
              <h3 class="box-title">Hostel Request</h3>

<div class="box-tools pull-right">
                <button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i>
                </button>
                <button type="button" class="btn btn-box-tool" data-widget="remove"><i class="fa fa-times"></i></button>
              </div>
            </div>
            
            <div class="table-responsive">
<?php //select query from database
$rs_settings = mysqli_query($link,"select * from hostel_applications where approval = '0' order by id desc limit 10"); ?>
              <table class="table no-margin">
                <thead>
                  <tr>
                 <th>Matric No.</th>
                 <th>Name</th>
                 <th>Hostel/Category</th>
                 <th>Room</th>
                 <th>Bunk/Bed No.</th>
                 <th>Status</th>
                <th>Date</th>
                
                  </tr>
                </thead>
                <tbody>
  <?php while ($info = mysqli_fetch_array($rs_settings)) { ?>
              <tr>               
                <td><?php $rs_mem = mysqli_query($link,"select * from `default_users` where id = '$info[studid]'"); 
				while ($rec = mysqli_fetch_array($rs_mem)) { echo $rec['username']; $fname = $rec['last_name'].' '.$rec['last_name']; } ?></td>
                
                <td><?php echo strtoupper($fname); ?></td>
                
                <td><?php $rs_mem = mysqli_query($link,"select * from `hostel_category` where id = '$info[catid]'"); 
				while ($rec = mysqli_fetch_array($rs_mem)) { echo $rec['title']; } ?></td>
                
                <td><?php $rs_mem = mysqli_query($link,"select * from `hostel_room` where id = '$info[roomid]'"); 
				while ($rec = mysqli_fetch_array($rs_mem)) { echo $rec['room_no']; } ?></td>
                
                 <td><?php $rs_mem = mysqli_query($link,"select * from `hostel_bed` where id = '$info[bedid]'"); 
				while ($rec = mysqli_fetch_array($rs_mem)) { echo $rec['bed_no']; } ?>
                </td>
                 
                <td><?php if($info['status'] == 1) { echo '<span class="label label-success">Available</span>'; } 
				elseif($info['status'] == 0) { echo '<span class="label label-danger">Unavailable</span>'; } ?></td> 
                 
          <td><?php $vdate = date_create($info['date_created']); //create date to be formated
				echo strtoupper (date_format($vdate,"d/m/Y")); //output date formated ?></td>

</tr>
     	 <?php } ?>
                </tbody>
              </table>
            </div>
            
<?php if($_SESSION['access_level'] >='8') { ?>
            <div class="box-footer text-center">
              <a href="./?Account=PortalAccount&view=42020214" class="uppercase">View All</a>
            </div>
      <?php } ?>
            
          </div>
          
          
          
          
          <div class="box box-primary">
            <div class="box-header with-border">
              <h3 class="box-title">Transcript Request</h3>

<td><?php $rs_mem = mysqli_query($link,"select * from `payment_history` where id = '$row[paymentid]'"); 
				while ($rec = mysqli_fetch_array($rs_mem)) { echo $rec['transid']; $status = $rec['status']; } ?></td>
                
<td><?php $rs_mem = mysqli_query($link,"select * from `default_users` where id = '$row[matid]'"); 
				while ($rec = mysqli_fetch_array($rs_mem)) { echo $rec['username']; } ?></td>
                
                
                <td><?php echo $row['email']; ?></td>
                <td><?php echo $row['phone']; ?></td>
                
                <td><?php $rs_mem = mysqli_query($link,"select * from `default_region_countries` where id = '$row[countryid]'"); 
				while ($rec = mysqli_fetch_array($rs_mem)) { echo $rec['title']; } ?></td>
                
  <td><?php $rs_mem = mysqli_query($link,"select * from `default_region_states` where id = '$row[stateid]'"); 
				while ($rec = mysqli_fetch_array($rs_mem)) { echo $rec['title']; } ?></td>              
                 
                <td><?php if($row['status'] == 1) { echo '<span class="label label-success">Successful</span>'; } 
				elseif($row['status'] == 0) { echo '<span class="label label-danger">Pending</span>'; } 
                elseif($row['status'] == -1) { echo '<span class="label label-success">Completed</span>'; } ?></td>
                
                <td><?php echo $row['date_applied']; ?></td>
                 
<!-- <td><?php //if($row['status'] == 0) { ?>
  <a href="#"><span class="label label-warning">Pending</span></a>

<?php //} if($row['status'] == 1) { ?>
 <a href="./?Account=PortalAccount&view=42020213&action=view&id=<?php //echo $row['id']; ?>"><span class="label label-info">Review & Treat</span></a> 
 <?php //} else { echo ''; } ?> 
</td>-->
              </tr>
     	 <?php } ?>
                </tbody>
              </table>
            </div>
            
 <?php if($_SESSION['access_level'] >='8' || $_SESSION['access_level'] >='4') { ?>
            <div class="box-footer text-center">
              <a href="./?Account=PortalAccount&view=42020213" class="uppercase">View All</a>
            </div>
      <?php } ?>
            
          </div>
          
          
        </div>
        
      </div>
      
    </section>

<script src="plugins/jQuery/jquery-3.1.1.min.js"></script>

<script src="bootstrap/js/bootstrap.min.js"></script>

<script src="plugins/fastclick/fastclick.js"></script>

<script src="dist/js/adminlte.js"></script>

<script src="plugins/sparkline/jquery.sparkline.min.js"></script>

<script src="plugins/jvectormap/jquery-jvectormap-1.2.2.min.js"></script>
<script src="plugins/jvectormap/jquery-jvectormap-world-mill-en.js"></script>

<script src="plugins/slimScroll/jquery.slimscroll.min.js"></script>

<script src="plugins/chartjs/Chart.min.js"></script>

<script src="dist/js/pages/dashboard2.js"></script>

<script src="dist/js/demo.js"></script>

Batal

⬅ Naik ke sms.coeminna.edu.ng 41 item

Nama	Tipe	Ukuran	Diubah	Aksi
📁bootstrap	dir	—	2024-08-05 07:57	📂 Buka
📁dist	dir	—	2024-08-05 07:57	📂 Buka
📁downloads	dir	—	2024-08-05 07:54	📂 Buka
📁export_file	dir	—	2024-08-05 07:55	📂 Buka
📁fps	dir	—	2024-08-05 07:56	📂 Buka
📁inc	dir	—	2024-08-05 07:56	📂 Buka
📁pages	dir	—	2024-08-05 07:59	📂 Buka
📁plugins	dir	—	2024-08-05 08:03	📂 Buka
📁templates	dir	—	2024-08-05 07:56	📂 Buka
📁uploads	dir	—	2024-08-05 08:03	📂 Buka
🐘academic_records_mgt.php	php	32 KB	2024-08-07 10:19	✏️ Edit 👁️ View
🐘admission.php	php	13.8 KB	2024-08-07 10:19	✏️ Edit 👁️ View
🐘audit_trail.php	php	11.1 KB	2024-08-07 10:19	✏️ Edit 👁️ View
🐘bed_mgt.php	php	13 KB	2024-08-07 10:19	✏️ Edit 👁️ View
🐘bookstore_mgt.php	php	13.2 KB	2024-08-07 10:19	✏️ Edit 👁️ View
🐘category_mgt.php	php	10.5 KB	2024-08-07 10:20	✏️ Edit 👁️ View
🐘change_pass.php	php	6 KB	2024-08-07 10:20	✏️ Edit 👁️ View
🐘course_mgt.php	php	44.1 KB	2024-08-07 10:20	✏️ Edit 👁️ View
🐘dashboard.php	php	25.8 KB	2024-08-07 10:20	✏️ Edit 👁️ View
🐘department_mgt.php	php	20.5 KB	2024-08-07 10:20	✏️ Edit 👁️ View
🐘edit_details.php	php	6.5 KB	2024-08-07 10:20	✏️ Edit 👁️ View
🐘error_page.php	php	402 B	2024-08-07 10:20	✏️ Edit 👁️ View
🐘faculty_mgt.php	php	17.4 KB	2024-08-07 10:20	✏️ Edit 👁️ View
🐘findDetails.php	php	1.9 KB	2024-08-07 10:20	✏️ Edit 👁️ View
🐘findName.php	php	1.2 KB	2024-08-07 10:20	✏️ Edit 👁️ View
🐘findType.php	php	1.5 KB	2024-08-07 10:20	✏️ Edit 👁️ View
🐘find_audit_mode.php	php	1.9 KB	2024-08-07 10:20	✏️ Edit 👁️ View
🐘hostel_mgt.php	php	19.9 KB	2024-08-07 10:20	✏️ Edit 👁️ View
🐘index.php	php	3.8 KB	2024-08-07 10:20	✏️ Edit 👁️ View
🐘notification_mgt.php	php	11.2 KB	2024-08-07 10:20	✏️ Edit 👁️ View
🐘payment_history.php	php	13.6 KB	2024-08-07 10:20	✏️ Edit 👁️ View
🐘print_document.php	php	7.9 KB	2024-08-07 10:20	✏️ Edit 👁️ View
🐘profile_details.php	php	7.9 KB	2024-08-07 10:20	✏️ Edit 👁️ View
🐘result_mgt.php	php	44 KB	2024-08-07 10:20	✏️ Edit 👁️ View
🐘room_mgt.php	php	13.5 KB	2024-08-07 10:20	✏️ Edit 👁️ View
🐘settings.php	php	18.1 KB	2024-08-07 10:20	✏️ Edit 👁️ View
🐘student_wall.php	php	12.3 KB	2024-08-07 10:20	✏️ Edit 👁️ View
🐘support_mgt.php	php	11.5 KB	2024-08-07 10:20	✏️ Edit 👁️ View
🐘tickets.php	php	18.6 KB	2024-08-07 10:20	✏️ Edit 👁️ View
🐘transcripts_mgt.php	php	22.4 KB	2024-08-07 10:20	✏️ Edit 👁️ View
🐘users_mgt.php	php	34.5 KB	2024-08-07 10:20	✏️ Edit 👁️ View