| Server IP : 172.64.80.1 / Your IP : 172.70.131.126 Web Server : Apache System : Linux mail.federalpolyede.edu.ng 5.10.0-32-amd64 #1 SMP Debian 5.10.223-1 (2024-08-10) x86_64 User : federalpolyede.edu.ng_idh35skikv ( 10000) PHP Version : 7.4.33 Disable Function : opcache_get_status MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /var/www/vhosts/federalpolyede.edu.ng/httpdocs_backup/admin_main/ |
Upload File : |
<?php
session_start();
include('../connect.php');
$db=db_connect();
$userLogin=$_SESSION['sName'];
$sql="select * from report_setting where username='$userLogin'";
$sql_exe=$db->query($sql);
$sql_count=$sql_exe->rowCount();
if ($sql_count==1) {
$sql_fetch=$sql_exe->fetch(PDO::FETCH_BOTH);
$to=$sql_fetch['to_v'];
$from=$sql_fetch['from_v'];
}else{
$to='True';
$from='True';
}
if (isset($_SESSION['sName'])){
$password=$_SESSION['pass'];
$k=$db->query("select * from useraccount where user='$userLogin' and pass='$password'");
$k_fetch=$k->fetch(PDO::FETCH_BOTH);
$kr=$k_fetch['status'];
$kr_item=explode(',',$kr);
$k_value='';
for ($i=0;$i<count($kr_item);++$i){
$k_value=$k_value."','".$kr_item[$i];
}
}else{
header('location:login.html');
}
?>
<!DOCTYPE html>
<html lang="en" xmlns="http://www.w3.org/1999/html">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="">
<meta name="author" content="">
<title>Bursary CPanel | Federal Poly Ede</title>
<!-- Bootstrap Core CSS -->
<link href="../bower_components/bootstrap/dist/css/bootstrap.min.css" rel="stylesheet">
<!-- MetisMenu CSS-->
<link href="../bower_components/metisMenu/dist/metisMenu.min.css" rel="stylesheet">
<!-- DataTables CSS-->
<link href="../bower_components/datatables-plugins/integration/bootstrap/3/dataTables.bootstrap.css" rel="stylesheet">
<!-- DataTables Responsive CSS -->
<link href="../bower_components/datatables-responsive/css/dataTables.responsive.css" rel="stylesheet">
<!-- Custom CSS -->
<link href="../dist/css/sb-admin-2.css" rel="stylesheet">
<!-- Custom Fonts -->
<link href="../bower_components/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css">
<!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
<!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
<!--[if lt IE 9]>
<script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
<script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script>
<![endif]-->
</head>
<body>
<div id="wrapper">
<!-- Navigation -->
<nav class="navbar navbar-default navbar-static-top alert-info" role="navigation" style="margin-bottom: 0">
<div class="navbar-header">
<button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="navbar-brand" href="../index.php">FEDERAL POLYTECHNIC EDE</a>
</div>
<!-- /.navbar-header -->
<ul class="nav navbar-top-links navbar-right">
<li class="dropdown">
<a class="dropdown-toggle" data-toggle="dropdown" href="#">
<i class="fa fa-envelope fa-fw"></i> <i class="fa fa-caret-down"></i>
</a>
<ul class="dropdown-menu dropdown-messages">
<li>
<a href="#">
<div>
<strong>John Smith</strong>
<span class="pull-right text-muted">
<em>Yesterday</em>
</span>
</div>
<div>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque eleifend...</div>
</a>
</li>
<li class="divider"></li>
<li>
<a href="#">
<div>
<strong>John Smith</strong>
<span class="pull-right text-muted">
<em>Yesterday</em>
</span>
</div>
<div>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque eleifend...</div>
</a>
</li>
<li class="divider"></li>
<li>
<a href="#">
<div>
<strong>John Smith</strong>
<span class="pull-right text-muted">
<em>Yesterday</em>
</span>
</div>
<div>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque eleifend...</div>
</a>
</li>
<li class="divider"></li>
<li>
<a class="text-center" href="#">
<strong>Read All Messages</strong>
<i class="fa fa-angle-right"></i>
</a>
</li>
</ul>
<!-- /.dropdown-messages -->
</li>
<!-- /.dropdown -->
<li class="dropdown">
<a class="dropdown-toggle" data-toggle="dropdown" href="#">
<i class="fa fa-tasks fa-fw"></i> <i class="fa fa-caret-down"></i>
</a>
<ul class="dropdown-menu dropdown-tasks">
<li>
<a href="#">
<div>
<p>
<strong>Task 1</strong>
<span class="pull-right text-muted">40% Complete</span>
</p>
<div class="progress progress-striped active">
<div class="progress-bar progress-bar-success" role="progressbar" aria-valuenow="40" aria-valuemin="0" aria-valuemax="100" style="width: 40%">
<span class="sr-only">40% Complete (success)</span>
</div>
</div>
</div>
</a>
</li>
<li class="divider"></li>
<li>
<a href="#">
<div>
<p>
<strong>Task 2</strong>
<span class="pull-right text-muted">20% Complete</span>
</p>
<div class="progress progress-striped active">
<div class="progress-bar progress-bar-info" role="progressbar" aria-valuenow="20" aria-valuemin="0" aria-valuemax="100" style="width: 20%">
<span class="sr-only">20% Complete</span>
</div>
</div>
</div>
</a>
</li>
<li class="divider"></li>
<li>
<a href="#">
<div>
<p>
<strong>Task 3</strong>
<span class="pull-right text-muted">60% Complete</span>
</p>
<div class="progress progress-striped active">
<div class="progress-bar progress-bar-warning" role="progressbar" aria-valuenow="60" aria-valuemin="0" aria-valuemax="100" style="width: 60%">
<span class="sr-only">60% Complete (warning)</span>
</div>
</div>
</div>
</a>
</li>
<li class="divider"></li>
<li>
<a href="#">
<div>
<p>
<strong>Task 4</strong>
<span class="pull-right text-muted">80% Complete</span>
</p>
<div class="progress progress-striped active">
<div class="progress-bar progress-bar-danger" role="progressbar" aria-valuenow="80" aria-valuemin="0" aria-valuemax="100" style="width: 80%">
<span class="sr-only">80% Complete (danger)</span>
</div>
</div>
</div>
</a>
</li>
<li class="divider"></li>
<li>
<a class="text-center" href="#">
<strong>See All Tasks</strong>
<i class="fa fa-angle-right"></i>
</a>
</li>
</ul>
<!-- /.dropdown-tasks -->
</li>
<!-- /.dropdown -->
<!-- /.dropdown -->
<li class="dropdown">
<a class="dropdown-toggle" data-toggle="dropdown" href="#">
<i class="fa fa-user fa-fw"></i> <i class="fa fa-caret-down"></i>
</a>
<ul class="dropdown-menu dropdown-user">
<li><a href="#"><i class="fa fa-user fa-fw"></i> User Profile</a>
</li>
<li><a href="#"><i class="fa fa-gear fa-fw"></i> Settings</a>
</li>
<li class="divider"></li>
<li><a href="logout.php"><i class="fa fa-sign-out fa-fw"></i> Logout</a>
</li>
</ul>
<!-- /.dropdown-user -->
</li>
<!-- /.dropdown -->
</ul>
<!-- /.navbar-top-links -->
<div class="navbar-default sidebar alert-danger" role="navigation">
<div class="sidebar-nav navbar-collapse">
<ul class="nav" id="side-menu">
<li class="sidebar-search">
<div class="input-group custom-search-form">
<input type="text" class="form-control" placeholder="Search...">
<span class="input-group-btn">
<button class="btn btn-default" type="button">
<i class="fa fa-search"></i>
</button>
</span>
</div>
<!-- /input-group -->
</li>
<li>
<a href="admin.php"><i class="fa fa-dashboard fa-fw"></i> Dashboard <?php echo '('.$_SESSION['sName'].')';?></a>
</li>
<li>
<a href="../../index.php"><i class="fa fa-home"></i> Back to Main portal </a>
<!-- /.nav-second-level -->
</li>
<?php
//$sql_menu="select distinct menu_group from admin_menu order by menu_group";
$sql_menu="select distinct(menu_group)from admin_menu where sn in('$k_value') order by menu_group";
$result_menu=$db->query($sql_menu);
$num_menu=$result_menu->rowCount();
// $k_menu=0;
while ($row2=$result_menu->fetch(PDO::FETCH_BOTH)){
?>
<li>
<a href="#"><i class="fa fa-list-ul fa-fw"></i> <?php echo $menuG=$row2['menu_group'];?><span class="fa arrow"></span></a>
<ul class="nav nav-second-level">
<?php
$sql_item="select * from admin_menu where menu_group='$menuG' and sn in('$k_value') order by menu_group ";
$result_item=$db->query($sql_item);
$num_item=$result_item->rowCount();
// $k_item=0;
while ($row=$result_item->fetch(PDO::FETCH_BOTH)) {
?>
<li>
<a target="_blank" href="<?php echo $menuN=$row['url'];?>"><?php echo $menuN=$row['menu_name'];?></a>
</li>
<?php
// ++$k_item;
}
// echo '<li><a href="a">bjjh</a></li>'.$k_value;
?>
</ul>
<!-- /.nav-second-level -->
</li>
<?php
// ++$k_menu;
}
?>
</ul>
<!-- /.nav-second-level -->
</div>
<!-- /.sidebar-collapse -->
</div>
<!-- /.navbar-static-side -->
</nav>
<!-- Page Content -->
<div id="page-wrapper">
<div class="container-fluid">
<div class="row">
<div class="col-lg-12">
<h1 class="page-header">Bursary CPanel</h1>
</div>
<div style="font-size: 20px; color: #FF0035; text-align: center"><hr>Current Date Range :
<?php
$sql="select * from report_setting where username='$userLogin'";
$sql_exe=$db->query($sql);
$sql_count=$sql_exe->rowCount();
if ($sql_count==1) {
$sql_fetch=$sql_exe->fetch(PDO::FETCH_BOTH);
$to=$sql_fetch['to_v'];
$from=$sql_fetch['from_v'];
echo "From: <b>". $from."</b> To: <b>".$to."</b>";
}else{
echo "Not Set Yet";
}
?>
<hr>
</div>
<!-- /.col-lg-12 -->
</div>
<!-- /.row -->
<!-- /.row -->
<div class="row">
<div class="col-lg-3 col-md-6">
<div class="panel panel-primary">
<div class="panel-heading">
<div class="row">
<div class="col-xs-3">
<i class="fa fa-comments fa-5x"></i>
</div>
<div class="col-xs-9 text-right">
<?php
//require_once('..../connect.php');
$query=$db->query('select * from admitted');
$admitted=$query->rowCount();
?>
<div class="huge"><?php echo $admitted;?></div>
<div></div>
</div>
</div>
</div>
<a href="reportTable.php">
<div class="panel-footer">
<span class="pull-left">Admitted Students</span>
<span class="pull-right"><i class="fa fa-arrow-circle-right"></i></span>
<div class="clearfix"></div>
</div>
</a>
</div>
</div>
<div class="col-lg-3 col-md-6">
<div class="panel panel-yellow">
<div class="panel-heading">
<div class="row">
<div class="col-xs-3">
<i class="fa fa-shopping-cart fa-5x"></i>
</div>
<div class="col-xs-9 text-right">
<div class="huge">
<?php
// $sqla="select * from realdata where fresher in ('50','5') ";
// $querya=$db->query($sqla);
// $numa=$querya->rowCount();
// echo $numa;
$sqltA="select count(sn) as snAmt from remitaorder where paymentType in ('Acceptance Fee') and transApproved='True'";
//$sqlt="select * from vwallpaymentforrealstudent2 where course='Accountancy' and levelID=1";
$sqltKA=$db->query($sqltA);
$numtA=$sqltKA->fetch(PDO::FETCH_BOTH);
echo $numtkQA=$numtA['snAmt'];
$sqltQA="select sum(amtPaid) as Amt from remitaorder where paymentType in ('Acceptance Fee') and transApproved='True'";
$querytQA=$db->query($sqltQA);
$kkqQA=$querytQA->fetch(PDO::FETCH_BOTH);
?>
</div>
<div><?php echo '<div style="font-size: 20px">N'.number_format($kkqQA['Amt']);?></div></div>
</div>
</div>
</div>
<a href="accptancePaid.php">
<div class="panel-footer">
<span class="pull-left">All Acceptance Fee</span>
<span class="pull-right"><i class="fa fa-arrow-circle-right"></i></span>
<div class="clearfix"></div>
</div>
</a>
</div>
</div>
<div class="col-lg-3 col-md-6">
<div class="panel panel-green">
<div class="panel-heading">
<div class="row">
<div class="col-xs-3">
<i class="fa fa-tasks fa-5x"></i>
</div>
<div class="col-xs-9 text-right">
<div class="huge">
<?php
$sqlr="select * from realdata where fresher='50' order by course,levelID,matNo ";
$queryr=$db->query($sqlr);
$numr=$queryr->rowCount();
echo $numr;
$q="select sum(amtPaid"
?>
</div>
<div></div>
</div>
</div>
</div>
<a href="studentWithMatNo.php">
<div class="panel-footer">
<span class="pull-left">New Students with Matric No.</span>
<span class="pull-right"><i class="fa fa-arrow-circle-right"></i></span>
<div class="clearfix"></div>
</div>
</a>
</div>
</div>
<div class="col-lg-3 col-md-6">
<div class="panel panel-red">
<div class="panel-heading">
<div class="row">
<div class="col-xs-3">
<i class="fa fa-support fa-5x"></i>
</div>
<div class="col-xs-9 text-right">
<div class="huge">
<?php
// $sqlt="select * from vw_schoolfees_2018_2019";
//$sqlt="select * from vwallpaymentforrealstudent2 where course='Accountancy' and levelID=1";
// $queryt=$db->query($sqlt);
// echo $numt=$queryt->rowCount();
$sqltK="select count(sn) as snAmt from remitaorder where paymentType in ('School Fees') and transApproved='True'";
//$sqlt="select * from vwallpaymentforrealstudent2 where course='Accountancy' and levelID=1";
$sqltKQ=$db->query($sqltK);
$numtQ=$sqltKQ->fetch(PDO::FETCH_BOTH);
echo $numtkQ=$numtQ['snAmt'];
$sqltQ="select sum(amtPaid) as amountTotal from remitaorder where paymentType in ('School Fees') and transApproved='True'";
$querytQ=$db->query($sqltQ);
$kkqQ=$querytQ->fetch(PDO::FETCH_BOTH);
// $sqlt_sco="select * from scholar where matNo not in (select matNo from vw_schoolfees_2018_2019)";
// $queryt_sco=$db->query($sqlt_sco);
// $numt_sco=$queryt_sco->rowCount();
// echo "(".$numt_sco.")";
?>
</div>
<div><?php echo '<div style="font-size: 20px">N'.number_format($kkqQ['amountTotal']);?></div></div>
</div>
</div>
</div>
<a href="schoolFeesPaid2.php">
<div class="panel-footer">
<span class="pull-left">All School Fees</span>
<span class="pull-right"><i class="fa fa-arrow-circle-right"></i></span>
<div class="clearfix"></div>
</div>
</a>
</div>
<!-- /.row -->
</div>
<div class="col-lg-3 col-md-6">
<div class="panel panel-primary">
<div class="panel-heading">
<div class="row">
<div class="col-xs-3">
<i class="fa fa-shopping-cart fa-5x"></i>
</div>
<div class="col-xs-9 text-right">
<div class="huge">
<?php
//require_once('..../connect.php');
$sqltA="select count(sn) as snAmt from remitaorder where paymentType not in ('Acceptance Fee','Summer School Fees','Admission Slip','School Fees') and transDate>='$from' and transDate<='$to' and transApproved='True'";
//$sqlt="select * from vwallpaymentforrealstudent2 where course='Accountancy' and levelID=1";
$sql=$db->query($sqltA);
$num=$sql->fetch(PDO::FETCH_BOTH);
echo $num=$num['snAmt'];
// $queryOther="select sum(totalAmt) as amountTotal from vw_payment_summary where paymentType not in ('Acceptance Fee','Summer School Fees','Admission Slip','School Fees')";
$queryOther="select sum(amtPaid) as amountTotal from remitaorder where paymentType not in ('Acceptance Fee','Summer School Fees','Admission Slip','School Fees') and transDate>='$from' and transDate<='$to' and transApproved='True'";
// $queryOther=$db->query("select sum(sn) as snAmt from vw_payment_summary where paymentType in ('Summer School Fees')");
// $queryOther=$db->query('select * from vw_payment_summary where paymentType not in ("School Fees","Acceptance Fee", "Admission Slip","Summer School Fees") and transApproved="True"');
// $otherPay=$queryOther->rowCount();
$querytQOther=$db->query($queryOther);
$kkqQOther=$querytQOther->fetch(PDO::FETCH_BOTH);
?>
</div>
<div class="" style="text-align: right; font-size: 25px">N<?php $j=$kkqQOther['amountTotal']; echo number_format($j);?></div>
</div>
</div>
</div>
<a href="reportTable.php">
<div class="panel-footer">
<span class="pull-left">Other Payment</span>
<span class="pull-right"><i class="fa fa-arrow-circle-right"></i></span>
<div class="clearfix"></div>
</div>
</a>
</div>
</div>
<div class="col-lg-3 col-md-6">
<div class="panel panel-yellow">
<div class="panel-heading">
<div class="row">
<div class="col-xs-3">
<i class="fa fa-shopping-cart fa-5x"></i>
</div>
<div class="col-xs-9 text-right">
<div class="huge">
<?php
// $sqla="select * from realdata where fresher in ('50','5') ";
// $querya=$db->query($sqla);
// $numa=$querya->rowCount();
// echo $numa;
$sqltA="select count(sn) as snAmt from remitaorder where paymentType in ('Acceptance Fee') and transDate>='$from' and transDate<='$to' and transApproved='True'";
//$sqlt="select * from vwallpaymentforrealstudent2 where course='Accountancy' and levelID=1";
$sqltKA=$db->query($sqltA);
$numtA=$sqltKA->fetch(PDO::FETCH_BOTH);
echo $numtkQA=$numtA['snAmt'];
$sqltQA="select sum(amtPaid) as Amt from remitaorder where paymentType in ('Acceptance Fee') and transDate>='$from' and transDate<='$to' and transApproved='True'";
$querytQA=$db->query($sqltQA);
$kkqQA=$querytQA->fetch(PDO::FETCH_BOTH);
?>
</div>
<div><?php echo '<div style="font-size: 20px">N'.number_format($kkqQA['Amt']);?></div></div>
</div>
</div>
</div>
<a href="accptancePaid.php">
<div class="panel-footer">
<span class="pull-left">Acceptance Fee</span>
<span class="pull-right"><i class="fa fa-arrow-circle-right"></i></span>
<div class="clearfix"></div>
</div>
</a>
</div>
</div>
<div class="col-lg-3 col-md-6">
<div class="panel panel-green">
<div class="panel-heading">
<div class="row">
<div class="col-xs-3">
<!-- <i class="fa fa-support fa-5x"></i>-->
</div>
<div class="col-xs-9 text-right">
<div class="huge">
<?php
// $sqltQ="select * from vw_summer_sch_fees";
$sqltQ="select count(sn) as snAmt from remitaorder where paymentType in ('Summer School Fees') and transDate>='$from' and transDate<='$to' and transApproved='True'";
$querytQ=$db->query($sqltQ);
$numt=$querytQ->fetch(PDO::FETCH_BOTH);
echo $numtk=$numt['snAmt'];
// echo $numt=$querytQ->rowCount();
$sqlt="select sum(amtPaid) as amountTotal from remitaorder where paymentType in ('Summer School Fees') and transDate>='$from' and transDate<='$to' and transApproved='True'";
$queryt=$db->query($sqlt);
$kkq=$queryt->fetch(PDO::FETCH_BOTH);
// $sqlt_sco="select * from scholar where matNo not in (select matNo from vw_schoolfees_2018_2019)";
// $queryt_sco=$db->query($sqlt_sco);
// $numt_sco=$queryt_sco->rowCount();
// echo "(".$numt_sco.")";
?>
</div>
<div> <?php echo '<div style="font-size: 20px">'.$kkq['amountTotal'];?></div></div>
</div>
</div>
</div>
<a href="schoolFeesPaid2.php">
<div class="panel-footer">
<span class="pull-left">Summer School Fees</span>
<span class="pull-right"><i class="fa fa-arrow-circle-right"></i></span>
<div class="clearfix"></div>
</div>
</a>
</div>
</div>
<div class="col-lg-3 col-md-6">
<div class="panel panel-red">
<div class="panel-heading">
<div class="row">
<div class="col-xs-3">
<i class="fa fa-support fa-5x"></i>
</div>
<div class="col-xs-9 text-right">
<div class="huge">
<?php
// $sqlt="select * from vw_schoolfees_2018_2019";
//$sqlt="select * from vwallpaymentforrealstudent2 where course='Accountancy' and levelID=1";
// $queryt=$db->query($sqlt);
// echo $numt=$queryt->rowCount();
$sqltK="select count(sn) as snAmt from remitaorder where paymentType in ('School Fees') and transDate>='$from' and transDate<='$to' and transApproved='True'";
//$sqlt="select * from vwallpaymentforrealstudent2 where course='Accountancy' and levelID=1";
$sqltKQ=$db->query($sqltK);
$numtQ=$sqltKQ->fetch(PDO::FETCH_BOTH);
echo $numtkQ=$numtQ['snAmt'];
$sqltQ="select sum(amtPaid) as amountTotal from remitaorder where paymentType in ('School Fees') and transDate>='$from' and transDate<='$to' and transApproved='True'";
$querytQ=$db->query($sqltQ);
$kkqQ=$querytQ->fetch(PDO::FETCH_BOTH);
// $sqlt_sco="select * from scholar where matNo not in (select matNo from vw_schoolfees_2018_2019)";
// $queryt_sco=$db->query($sqlt_sco);
// $numt_sco=$queryt_sco->rowCount();
// echo "(".$numt_sco.")";
?>
</div>
<div><?php echo '<div style="font-size: 20px">N'.number_format($kkqQ['amountTotal']);?></div></div>
</div>
</div>
</div>
<a href="schoolFeesPaid2.php">
<div class="panel-footer">
<span class="pull-left">School Fees</span>
<span class="pull-right"><i class="fa fa-arrow-circle-right"></i></span>
<div class="clearfix"></div>
</div>
</a>
</div>
<!-- /.container-fluid -->
<!-- /#wrapper -->