Gecko [ urlab.iiitd.edu.in ]

/ var / www / html / temppayment / pg / studentsfee / admin / [ HOME SHELL ]

Name	Size	Permission
dist	[ DIR ]	drwxr-xr-x
lib	[ DIR ]	drwxr-xr-x
mailer	[ DIR ]	drwxr-xr-x
DataSource.php	4.57 KB	-rw-r--r--
adAdminUser-o1.php	7.65 KB	-rw-r--r--
adAdminUser.php	7.65 KB	-rw-r--r--
adminDashboard-o1.php	7.73 KB	-rw-r--r--
adminDashboard.php	31.6 KB	-rw-r--r--
adminDashboard.php_old	5.02 KB	-rw-r--r--
batch.php	373 B	-rw-r--r--
bulkUpload.php	11.16 KB	-rw-r--r--
bulkUpload.php--	11.17 KB	-rw-r--r--
changePassword.php	4.75 KB	-rw-r--r--
class.admin-o1.php	4.39 KB	-rw-r--r--
class.admin.php	4.39 KB	-rw-r--r--
class.user-o1.php	2.88 KB	-rw-r--r--
class.user.php	2.88 KB	-rw-r--r--
common-o1.php	2.37 KB	-rw-r--r--
common-old100223.php	2.37 KB	-rw-r--r--
common.php	4.49 KB	-rw-r--r--
common.php_04112019	2.12 KB	-rw-r--r--
common.php_2112019	1.3 KB	-rw-r--r--
dbconfig.php	1.2 KB	-rw-r--r--
delete_member.php	1.01 KB	-rw-r--r--
delete_memberD.php	1.02 KB	-rw-r--r--
error_log	3.19 KB	-rw-r--r--
exportHostelFee.php	1.29 KB	-rw-r--r--
exportTutionFee-o1.php	1.32 KB	-rw-r--r--
exportTutionFee.php	1.29 KB	-rw-r--r--
exportTutionFeeSearch.php	1.28 KB	-rw-r--r--
exportTutionFeem22july22.php	1.3 KB	-rw-r--r--
exportTutionFeem23june23.php	1.3 KB	-rw-r--r--
exportTutionFeem24june24.php	1.3 KB	-rw-r--r--
exportTutionFeemon2021.php	1.31 KB	-rw-r--r--
exportTutionFeew22mar22.php	1.3 KB	-rw-r--r--
exportTutionFeew22nov21.php	1.3 KB	-rw-r--r--
exportTutionFeew23dec22.php	1.3 KB	-rw-r--r--
exportTutionFeew24dec23.php	1.3 KB	-rw-r--r--
exportTutionFeewinapr21.php	1.31 KB	-rw-r--r--
exporthostelfeedatadec23.php	1.1 KB	-rw-r--r--
exporthostelfeedatajan24.php	1.1 KB	-rw-r--r--
exporthostelfeedatam2324.php	1.09 KB	-rw-r--r--
exporthostelfeedatasb2324may24...	1.1 KB	-rw-r--r--
exporthostelfeenewdec23.php	1.43 KB	-rw-r--r--
exporthostelfeenewjan24.php	1.44 KB	-rw-r--r--
exporthostelfeenewm2324aug23.p...	1.44 KB	-rw-r--r--
exporthostelreconsilationdec23...	2.74 KB	-rw-r--r--
exporthostelreconsilationm2324...	2.73 KB	-rw-r--r--
exporthostelreconsilationsb232...	2.72 KB	-rw-r--r--
exporthostelreconsilationw2324...	2.75 KB	-rw-r--r--
exportreconsilationm22july22.p...	2.15 KB	-rw-r--r--
exportreconsilationm23june23.p...	1.46 KB	-rw-r--r--
exportreconsilationm24june24.p...	2.09 KB	-rw-r--r--
exportreconsilationw22mar22.ph...	1.27 KB	-rw-r--r--
exportreconsilationw22nov21.ph...	1.3 KB	-rw-r--r--
exportreconsilationw23dec22.ph...	2.14 KB	-rw-r--r--
exportreconsilationw24dec23.ph...	2.14 KB	-rw-r--r--
exportstudentslist.php	1.08 KB	-rw-r--r--
exportstudentslistm22july22.ph...	1.17 KB	-rw-r--r--
exportstudentslistm23june23.ph...	1.17 KB	-rw-r--r--
exportstudentslistw23dec22.php	1.18 KB	-rw-r--r--
exportupload.php	1.08 KB	-rw-r--r--
feebalancedetails.php	3.5 KB	-rw-r--r--
feereconciliationm22july22.php	4.28 KB	-rw-r--r--
feereconciliationm22july22r.ph...	4.05 KB	-rw-r--r--
feereconciliationm23june23.php	5.05 KB	-rw-r--r--
feereconciliationm24june24.php	4.98 KB	-rw-r--r--
feereconciliationw22mar22.php	4.1 KB	-rw-r--r--
feereconciliationw23dec22.php	4.27 KB	-rw-r--r--
feereconciliationw24dec23.php	5.02 KB	-rw-r--r--
feereconsilationw22nov21.php	4.09 KB	-rw-r--r--
forgotPassword.php	6.49 KB	-rw-r--r--
fpass.php	3.07 KB	-rw-r--r--
hostelAdminDashboard.php	9.85 KB	-rw-r--r--
hostelFeeBulkUpload.php	7.53 KB	-rw-r--r--
hostelFeeNewEntry.php	11.78 KB	-rw-r--r--
hostelFeeReconciliation.php	3.61 KB	-rw-r--r--
hostelfeereconciliationdec23.p...	4.01 KB	-rw-r--r--
hostelfeereconciliationm2324au...	4.74 KB	-rw-r--r--
hostelfeereconciliationsb2324m...	3.99 KB	-rw-r--r--
hostelfeereconciliationw2324ja...	4.02 KB	-rw-r--r--
index-old.php	4.65 KB	-rw-r--r--
index.php	5.12 KB	-rw-r--r--
invoice.php	8.1 KB	-rw-r--r--
invoiceHostel.php	7.23 KB	-rw-r--r--
invoicehostelfeenewdec23.php	8.96 KB	-rw-r--r--
invoicehostelfeenewjan24.php	9.04 KB	-rw-r--r--
invoicehostelfeenewm2324aug23....	8.95 KB	-rw-r--r--
invoicehostelfeenewsb2324may24...	9.02 KB	-rw-r--r--
invoicem22july22.php	9.51 KB	-rw-r--r--
invoicem23june23.php	9.13 KB	-rw-r--r--
invoicem24june24.php	9.11 KB	-rw-r--r--
invoicemon2021btech2021sep21.p...	8.08 KB	-rw-r--r--
invoicemonsoon2020.php	8.08 KB	-rw-r--r--
invoicemonsoon2021.php	8.09 KB	-rw-r--r--
invoicemtechfirst.php	9.51 KB	-rw-r--r--
invoicew22mar22.php	8.11 KB	-rw-r--r--
invoicew22nov21.php	8.11 KB	-rw-r--r--
invoicew23dec22.php	9.13 KB	-rw-r--r--
invoicew24dec23.php	9.13 KB	-rw-r--r--
invoicewinter2020.php	8.09 KB	-rw-r--r--
invoicewinter2021btech2020.php	8.08 KB	-rw-r--r--
jquery-3.2.1.min.js	84.63 KB	-rw-r--r--
jquery.tableToExcel.js	2.82 KB	-rw-r--r--
logout.php	624 B	-rw-r--r--
page-top.php	9.48 KB	-rw-r--r--
register.php	6.8 KB	-rw-r--r--
registeredstudentslist.php	3.6 KB	-rw-r--r--
resetpass.php	5.24 KB	-rw-r--r--
studentslist.php	5.77 KB	-rw-r--r--
studentslistm22july22.php	5.8 KB	-rw-r--r--
studentslistm23june23.php	5.78 KB	-rw-r--r--
studentslistw23dec22.php	5.8 KB	-rw-r--r--
updateBatch.php	6.11 KB	-rw-r--r--
updateBatchFee.php	7.33 KB	-rw-r--r--
updateBatchFee.php_04112019	6.41 KB	-rw-r--r--
updateFeeDate.php	10.14 KB	-rw-r--r--
verify.php	2.54 KB	-rw-r--r--
viewHostelFee.php	9.47 KB	-rw-r--r--
viewHostelFee.php_old	6.23 KB	-rw-r--r--
viewHostelFeeNew.php	9.49 KB	-rw-r--r--
viewHostelFeeNewdec23.php	9.91 KB	-rw-r--r--
viewHostelFeeNewjan24.php	9.8 KB	-rw-r--r--
viewHostelFeeNewsb2324may24.ph...	9.77 KB	-rw-r--r--
viewTutionFee.php	10.5 KB	-rw-r--r--
viewTutionFee.php_old	6.4 KB	-rw-r--r--
viewdocuments.php	5.42 KB	-rw-r--r--
viewhostelfeedatadec23.php	8.72 KB	-rw-r--r--
viewhostelfeedatajan24.php	8.75 KB	-rw-r--r--
viewhostelfeedatam2324.php	8.7 KB	-rw-r--r--
viewhostelfeedatasb2324may24.p...	8.72 KB	-rw-r--r--
viewm22july22Fee-bkpwithoutapp...	7.81 KB	-rw-r--r--
viewm22july22Fee.php	9.96 KB	-rw-r--r--
viewm23june23Fee.php	9.95 KB	-rw-r--r--
viewm24june24Fee.php	9.9 KB	-rw-r--r--
viewmonsoon2020Fee.php	7.57 KB	-rw-r--r--
viewmonsoon2021Fee.php	7.81 KB	-rw-r--r--
viewmonsoon2021Feebtech2021sep...	7.63 KB	-rw-r--r--
viewmtechfirst.php	9.99 KB	-rw-r--r--
vieww22mar22Fee.php	7.86 KB	-rw-r--r--
vieww22nov21Fee.php	7.86 KB	-rw-r--r--
vieww23dec22Fee.php	9.95 KB	-rw-r--r--
vieww24dec23Fee.php	9.94 KB	-rw-r--r--
viewwinter2020Fee.php	7.57 KB	-rw-r--r--
viewwinter2021Feebtech2020.php	7.62 KB	-rw-r--r--

Code Editor : adminDashboard.php

<?php
ob_start();
require __DIR__ . DIRECTORY_SEPARATOR . "lib" . DIRECTORY_SEPARATOR . "config.php";
// HTML
require PATH_LIB . "page-top.php"; 
$tokenAuth = $row[ 'authtokenid' ];?>

<div class="content-wrapper">
    
    <section class="content-header">
      <h1>
        Admin Dashboard
        
      </h1>
      <ol class="breadcrumb">
        <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
        <li class="active"> Admin Dashboard</li>
      </ol>
    </section>

<section class="content">
      <div class="row">
        <?php

$admino=$DB_con->prepare("SELECT count(*) FROM studentdetail");
    $admino->execute();
    $adminrowo = $admino->fetch(PDO::FETCH_NUM);
    $admincounto = $adminrowo[0];
?>
        <div class="col-lg-2 col-xs-6">
          
          <div class="small-box bg-red">
            <div class="inner">
              <p>Demand raised for students</p>
			  <h3><?php echo $admincounto; ?></h3>

<p><a href="viewm24june24Fee.php?authToken=<?php echo $tokenAuth;?>" style="color:#fff; text-decoration:underline;" target="_blank">Fee Collection Details R</a></p>
			  <p><a href="feereconciliationm24june24.php?authToken=<?php echo $tokenAuth;?>" style="color:#fff; text-decoration:underline;" target="_blank">Reconciliation Details</a></p>
            </div>
            <div class="icon">
             <i class="fa fa-user" aria-hidden="true"></i>
            </div>
            <a href="viewm24june24Fee.php?authToken=<?php echo $tokenAuth;?>" class="small-box-footer" target="_blank">Monsoon 24 (June 24) </a>
          </div>
        </div>
		
		  
		  <?php

$admino=$DB_con->prepare("SELECT count(*) FROM studentdetailw24dec23");
    $admino->execute();
    $adminrowo = $admino->fetch(PDO::FETCH_NUM);
    $admincounto = $adminrowo[0];
?>
        <div class="col-lg-2 col-xs-6">
          
          <div class="small-box bg-red">
            <div class="inner">
              <p>Demand raised for students</p>
			  <h3><?php echo $admincounto; ?></h3>

<p><a href="vieww24dec23Fee.php?authToken=<?php echo $tokenAuth;?>" style="color:#fff; text-decoration:underline;" target="_blank">Fee Collection Details R</a></p>
			  <p><a href="feereconciliationw24dec23.php?authToken=<?php echo $tokenAuth;?>" style="color:#fff; text-decoration:underline;" target="_blank">Reconciliation Details</a></p>
            </div>
            <div class="icon">
             <i class="fa fa-user" aria-hidden="true"></i>
            </div>
            <a href="vieww24dec23Fee.php?authToken=<?php echo $tokenAuth;?>" class="small-box-footer" target="_blank">Winter 24 (Dec 23) </a>
          </div>
        </div>
		
		  
		  
		  <?php

$admino=$DB_con->prepare("SELECT count(*) FROM studentdetailm23july23");
    $admino->execute();
    $adminrowo = $admino->fetch(PDO::FETCH_NUM);
    $admincounto = $adminrowo[0];
?>
        <div class="col-lg-2 col-xs-6">
          
          <div class="small-box bg-red">
            <div class="inner">
              <p>Demand raised for students</p>
			  <h3><?php echo $admincounto; ?></h3>

<p><a href="viewm23june23Fee.php?authToken=<?php echo $tokenAuth;?>" style="color:#fff; text-decoration:underline;" target="_blank">Fee Collection Details</a></p>
			  <p><a href="feereconciliationm23june23.php?authToken=<?php echo $tokenAuth;?>" style="color:#fff; text-decoration:underline;" target="_blank">Reconciliation Details</a></p>
            </div>
            <div class="icon">
             <i class="fa fa-user" aria-hidden="true"></i>
            </div>
            <a href="viewm23june23Fee.php?authToken=<?php echo $tokenAuth;?>" class="small-box-footer" target="_blank">Monsoon 23 (June 23) </a>
          </div>
        </div>
		
		  
		  
		<?php  
		  $admino=$DB_con->prepare("SELECT count(*) FROM studentdetailw23dec22");
    $admino->execute();
    $adminrowo = $admino->fetch(PDO::FETCH_NUM);
    $admincounto = $adminrowo[0];
?>
        <div class="col-lg-2 col-xs-6">
          
          <div class="small-box bg-red">
            <div class="inner">
              <p>Demand raised for students</p>
			  <h3><?php echo $admincounto; ?></h3>

<p><a href="vieww23dec22Fee.php?authToken=<?php echo $tokenAuth;?>" style="color:#fff; text-decoration:underline;" target="_blank">Fee Collection Details</a></p>
			  <p><a href="feereconciliationw23dec22.php?authToken=<?php echo $tokenAuth;?>" style="color:#fff; text-decoration:underline;" target="_blank">Reconciliation Details</a></p>
            </div>
            <div class="icon">
             <i class="fa fa-user" aria-hidden="true"></i>
            </div>
            <a href="vieww23dec22Fee.php?authToken=<?php echo $tokenAuth;?>" class="small-box-footer" target="_blank">Winter 23 (Dec 22) </a>
          </div>
        </div>
		
		  
		  
		  <?php

$admino=$DB_con->prepare("SELECT count(*) FROM studentdetailm22july22");
    $admino->execute();
    $adminrowo = $admino->fetch(PDO::FETCH_NUM);
    $admincounto = $adminrowo[0];
?>
        <div class="col-lg-2 col-xs-6">
          
          <div class="small-box bg-red">
            <div class="inner">
              <p>Demand raised for students</p>
			  <h3><?php echo $admincounto; ?></h3>

<p><a href="viewm22july22Fee.php?authToken=<?php echo $tokenAuth;?>" style="color:#fff; text-decoration:underline;" target="_blank">Fee Collection Details</a></p>
			  <p><a href="feereconciliationm22july22.php?authToken=<?php echo $tokenAuth;?>" style="color:#fff; text-decoration:underline;" target="_blank">Reconciliation Details</a></p>
            </div>
            <div class="icon">
             <i class="fa fa-user" aria-hidden="true"></i>
            </div>
            <a href="viewm22july22Fee.php?authToken=<?php echo $tokenAuth;?>" class="small-box-footer" target="_blank">Monsoon 22 (July 22) </a>
          </div>
        </div>
		
		
		<?php

$admino=$DB_con->prepare("SELECT count(*) FROM studentdetailw22mar22");
    $admino->execute();
    $adminrowo = $admino->fetch(PDO::FETCH_NUM);
    $admincounto = $adminrowo[0];
?>
        <div class="col-lg-2 col-xs-6">
          
          <div class="small-box bg-red">
            <div class="inner">
              <p>Demand raised for students</p>
			  <h3><?php echo $admincounto; ?></h3>

<p><a href="vieww22mar22Fee.php?authToken=<?php echo $tokenAuth;?>" style="color:#fff; text-decoration:underline;" target="_blank">Fee Collection Details</a></p>
			  <p><a href="feereconciliationw22mar22.php?authToken=<?php echo $tokenAuth;?>" style="color:#fff; text-decoration:underline;" target="_blank">Reconciliation Details</a></p>
            </div>
            <div class="icon">
             <i class="fa fa-user" aria-hidden="true"></i>
            </div>
            <a href="adminDashboard.php?authToken=<?php echo $tokenAuth;?>" class="small-box-footer" target="_blank">Winter 22 (Mar 22) </a>
          </div>
        </div>
		
		
		<?php

$adminw22nov21=$DB_con->prepare("SELECT count(*) FROM studentdetailw22nov21");
    $adminw22nov21->execute();
    $adminroww22nov21 = $adminw22nov21->fetch(PDO::FETCH_NUM);
    $admincountw22nov21 = $adminroww22nov21[0];
?>
        <div class="col-lg-2 col-xs-6">
          
          <div class="small-box bg-red">
            <div class="inner">
              <p>Demand raised for students</p><h3><?php echo $admincountw22nov21; ?></h3>

<p><a href="vieww22nov21Fee.php?authToken=<?php echo $tokenAuth;?>" style="color:#fff; text-decoration:underline;" target="_blank">Fee Collection Details</a></p>
			  <p><a href="feereconsilationw22nov21.php?authToken=<?php echo $tokenAuth;?>" style="color:#fff; text-decoration:underline;" target="_blank">Reconciliation Details</a></p>
            </div>
            <div class="icon">
             <i class="fa fa-user" aria-hidden="true"></i>
            </div>
            <a href="vieww22nov21Fee.php?authToken=<?php echo $tokenAuth;?>" class="small-box-footer" target="_blank">Winter 22 (Nov 21) </a>
          </div>
        </div>
		
		
		
		
		<?php

$adminsep21=$DB_con->prepare("SELECT count(*) FROM studentdetailsep21");
    $adminsep21->execute();
    $adminrowsep21 = $adminsep21->fetch(PDO::FETCH_NUM);
    $admincountsep21 = $adminrowsep21[0];
?>
        <div class="col-lg-2 col-xs-6">
          
          <div class="small-box bg-red">
            <div class="inner">
              <p>Demand raised for students</p><h3><?php echo $admincountsep21; ?></h3>

<p>Fee Collection Details</p>
			  <p>&nbsp;</p>
            </div>
            <div class="icon">
             <i class="fa fa-user" aria-hidden="true"></i>
            </div>
            <a href="viewmonsoon2021Feebtech2021sep21.php?authToken=<?php echo $tokenAuth;?>" class="small-box-footer" target="_blank">Monsoon 21 (Sep 21)  </a>
          </div>
        </div>
		
		
		<?php

$adminmjuly21=$DB_con->prepare("SELECT count(*) FROM studentdetailmjuly21");
    $adminmjuly21->execute();
    $adminrowmjuly21 = $adminmjuly21->fetch(PDO::FETCH_NUM);
    $admincountmjuly21 = $adminrowmjuly21[0];
?>
        <div class="col-lg-2 col-xs-6">
          
          <div class="small-box bg-red">
            <div class="inner">
              <p>Demand raised for students</p><h3><?php echo $admincountmjuly21; ?></h3>

<p><a href="viewmonsoon2021Fee.php?authToken=<?php echo $tokenAuth;?>" style="color:#fff; text-decoration:underline;" target="_blank">Fee Collection Details</a></p>
			  <p>&nbsp;</p>
            </div>
            <div class="icon">
             <i class="fa fa-user" aria-hidden="true"></i>
            </div>
            <a href="viewmonsoon2021Fee.php?authToken=<?php echo $tokenAuth;?>" class="small-box-footer" target="_blank">Monsoon 21 (July 21) </a>
          </div>
        </div>
		
		
		
		<?php

$adminapr21=$DB_con->prepare("SELECT count(*) FROM studentdetailapr21");
    $adminapr21->execute();
    $adminrowapr21 = $adminapr21->fetch(PDO::FETCH_NUM);
    $admincountapr21 = $adminrowapr21[0];
?>
        <div class="col-lg-2 col-xs-6">
          
          <div class="small-box bg-red">
            <div class="inner">
              <p>Demand raised for students</p><h3><?php echo $admincountapr21; ?></h3>

<p><a href="viewwinter2021Feebtech2020.php?authToken=<?php echo $tokenAuth;?>" style="color:#fff; text-decoration:underline;" target="_blank">Fee Collection Details</a></p>
			  <p>&nbsp;</p>
            </div>
            <div class="icon">
             <i class="fa fa-user" aria-hidden="true"></i>
            </div>
            <a href="viewwinter2021Feebtech2020.php?authToken=<?php echo $tokenAuth;?>" class="small-box-footer" target="_blank">Winter 21 (Apr 21) BTech 2020 </a>
          </div>
        </div>
		
		
		
		
		<?php

$adminwnov20=$DB_con->prepare("SELECT count(*) FROM studentdetailwnov20");
    $adminwnov20->execute();
    $adminrowwnov20 = $adminwnov20->fetch(PDO::FETCH_NUM);
    $admincountwnov20 = $adminrowwnov20[0];
?>
        <div class="col-lg-2 col-xs-6">
          
          <div class="small-box bg-red">
            <div class="inner">
              <p>Demand raised for students</p><h3><?php echo $admincountwnov20; ?></h3>

<p><a href="viewwinter2020Fee.php?authToken=<?php echo $tokenAuth;?>" style="color:#fff; text-decoration:underline;" target="_blank">Fee Collection Details</a></p>
			  <p>&nbsp;</p>
            </div>
            <div class="icon">
             <i class="fa fa-user" aria-hidden="true"></i>
            </div>
            <a href="viewwinter2020Fee.php?authToken=<?php echo $tokenAuth;?>" class="small-box-footer" target="_blank">Winter 20 (Nov 20) </a>
          </div>
        </div>
		
		
		<?php

$admindec19=$DB_con->prepare("SELECT count(*) FROM studentdetaildec19");
    $admindec19->execute();
    $adminrowdec19 = $admindec19->fetch(PDO::FETCH_NUM);
    $admincountdec19 = $adminrowdec19[0];
?>
        <div class="col-lg-2 col-xs-6">
          
          <div class="small-box bg-red">
            <div class="inner">
              <p>Demand raised for students</p><h3><?php echo $admincountdec19; ?></h3>

<p><a href="viewmonsoon2020Fee.php?authToken=<?php echo $tokenAuth;?>" style="color:#fff; text-decoration:underline;" target="_blank">Fee Collection Details</a></p>
			  <p>&nbsp;</p>
            </div>
            <div class="icon">
             <i class="fa fa-user" aria-hidden="true"></i>
            </div>
            <a href="viewmonsoon2020Fee.php?authToken=<?php echo $tokenAuth;?>" class="small-box-footer" target="_blank">Monsoon 20 (Dec 19) </a>
          </div>
        </div>
		
		
		
		
		
		
		<!--<div class="col-xs-12" style="padding-left: 0px;  padding-right: 0px;">
          <div class="box">
            <div class="box-header">
              <h3 class="box-title"><strong>Tution Fee Details (Monsoon 2023) June 23</strong></h3><hr/>
			  
			  
			  <?php
						
								 
								$totaldemand = $DB_con->prepare("select SUM(totalFee) from studentdetail");
								$valsum= $totaldemand->execute();
								//$totalsum=$valsum-160;
								$row1 = $totaldemand->fetch();
								//select sum(paidFee) from tutionfee where feeType in (select distinct feeType from tutionfee )group by feeType having count(*) ;

//$paidfee = $DB_con->prepare("select feeType, paidFee,studentID from tutionfee where feeType in (select distinct studentID from tutionfee) group by studentID having count(1)");
								//$paidfee = $DB_con->prepare("select SUM(paidFee) from tutionfee");
								$paidfee = $DB_con->prepare("select SUM(payment) from tutionfee");
								//"select feeType, paidFee from tutionfee where feeType in (select distinct feeType from tutionfee) group by feeType having count(*)");
								$paidfee->execute();
								//$totalsum=$valsum-160;
								$paidfee11 = $paidfee->fetch();
								//for($k=0; $rowpf = $paidfee->fetch(); $k++){
							
								//$pfee +=  $rowpf['paidFee'];
								//echo $k . "<br/>";
								//}
								//echo $pfee;
													
								$totalRec = $DB_con->prepare("select distinct studentID, count(*) from tutionfee where studentID in (select distinct studentID from tutionfee) ");
								$totalRec->execute();
								//$totalsum=$valsum-160;
								$rows1 = $totalRec->fetch(PDO:: FETCH_NUM);
								$tRecord = $rows1[0];
								//echo $tRecord;
								//group by feeType having count(*)
								
								
					//----------------------------------------------------------------------------------------------------//
								$lastid1 = $DB_con->prepare("select id from studentdetail order by id desc limit 0,1");
								$lastid11= $lastid1->execute();
								//$totalsum=$valsum-160;
								$rowid1 = $lastid1->fetch();
								
								//$lastidt1 = $DB_con->prepare("select tutionfeeid from tutionfee order by id desc limit 0,1");
								//$lastidt11= $lastidt1->execute();
								//$rowidt1 = $lastidt1->fetch();
    //print_r($row1[0]);
	  //  print_r($row1[0]-160);
									
							?>
							<!/--<h3> Total Value of Demand Raised on 1615 Students: <?php print_r($row1[0]-100); ?> Rs.</h3> --/>
			  <!/--<h3> Demand Raised for <?php print_r($rowid1[0]-1160); ?> Students: <?php print_r($row1[0]); $dr=$row1[0];?> Rs. </h3>  --/>
			 <!/--(-1160 because the table id starting from 1161 on 1st Dec 2021)--/>
			  
			  
			  <h3> Demand Raised for <?php print_r($rowid1[0]); ?> Students: Rs. <?php print_r($row1[0]); $dr=$row1[0];?> </h3> 
			  <h3> Amount Collected <!/--from <?php print_r($rowidt1[0]); ?> Students --/>: Rs. <?php print_r($paidfee11[0]); $ac=$paidfee11[0];?> </h3>
			  <h3> Balance Amount <!/--from <?php print_r($rowidt1[0]); ?> Students --/>: Rs. <?php $ba=$dr-$ac; echo $ba; ?> </h3>
			  
            </div>
            <!/-- /.box-header --/>
            <div class="box-body">
              <table id="example1" class="table table-bordered table-striped">
                <thead>
					<tr>
					<th>Roll No.</th>
					<th>Student Name</th>
                  <th>Program</th>
                  <!/--<th>Branch</th> --/>
                  <th>Semester</th>
						 <!/--<th>Batch</th> --/>
						 <th>Student Email</th>
					<!/--<th>Tution Fee</th>
					<th>Caution Fee</th>
					<th>Alumni Fee</th>
					<th>Fine</th> --/>
                  <th>Total Fee Due</th>
				  <th>Fee Paid</th>
				  <th>Total  Fee Paid</th>
				  <th>Balance Fee</th> 
				 <th>Payment Mode</th>
				 <th>Payment ID</th>
                  <th>View Receipt</th>
                </tr>
                </thead>
                <tbody>
					<?php
						//SELECT tf.*,pay.Paymentstatus,pay.TransactionID FROM tutionfee tf, paymentstatus pay  where pay.studentID = tf.studentEmail and pay.TransactionID = tf.feetype and tf.feetype !='TUTIONFEE';
					
						
								 
								 $result = $DB_con->prepare("SELECT pay.TransactionID, tf.*,pay.Paymentstatus FROM tutionfee tf, paymentstatus pay  where 
								  pay.studentID = tf.studentEmail
								 and pay.TransactionID = tf.feetype
								 and tf.feetype !='TUTIONFEE'  group by pay.TransactionID having count(*)");

//SELECT SUM(tf.paidfee),(select Paymentstatus from paymentstatus where studentID =  tf.studentEmail and TransactionID =tf.feetype) as Paymentstatus, (select TransactionID from paymentstatus where studentID =  tf.studentEmail and TransactionID =tf.feetype) as TransactionID FROM  tutionfee tf  where   tf.feetype !='TUTIONFEE';

/*$result = $DB_con->prepare("SELECT tf.*,pay.Paymentstatus,pay.TransactionID FROM tutionfee tf, paymentstatus pay  where 
								  pay.studentID = tf.studentEmail
								 and pay.TransactionID = tf.feetype
								 and tf.feetype !='TUTIONFEE'
								 and tf.balanceFee ='0'");*/
								 
								 $result->execute();
								for($i=0; $row = $result->fetch(); $i++){
									
									
									//Encryption
 $original_string = $row['tutionfeeID'];  // Plain text/String
$cipher_algo = "AES-128-CTR"; //The cipher method, in our case, AES 
$iv_length = openssl_cipher_iv_length($cipher_algo); //The length of the initialization vector
$option = 0; //Bitwise disjunction of flags
$encrypt_iv = '8746376827619797'; //Initialization vector, non-null
$encrypt_key = "encryption"; // The encryption key
// Use openssl_encrypt() encrypt the given string
$encrypted_string = openssl_encrypt($original_string, $cipher_algo,$encrypt_key, $option, $encrypt_iv);
									
									
									
							?>
                <tr>
                 <td><?php echo $row ['rollNumber']; ?></td>
                  <td><?php echo $row ['studentName']; ?></td>
                  <td><?php echo $row ['programID']; ?></td>
					<!/--<td><?php echo $row ['branch']; ?></td> --/>
                  <td><?php echo $row ['semester']; ?></td>
					 <!/--<td><?php echo $row ['batch']; ?></td> --/>
					 <td><?php echo $row ['studentEmail']; ?></td>
					<!/--<td><?php echo $row ['tutionFee']; ?></td>
					<td><?php echo $row ['cautionFee']; ?></td>
					<td><?php echo $row ['alumnifee']; ?></td>
					<td><?php echo $row ['fine']; ?></td> --/>
				<td><?php echo $row ['totalfee']; ?></td>
				<td><?php echo $row ['payment']; ?></td>
				<td><?php echo $row ['paidFee']; ?></td>
				<td><?php echo $row ['balanceFee']; ?></td> 
					<td><?php echo $row ['paymentmode']; $id =  base64_encode( $row['tutionfeeID']);?></td>
					<td><?php echo $row ['Paymentstatus']; ?></td>
              <!/--<td><a href="invoicem22july22.php?in=<?php echo $id; ?>&authToken=<?php  echo $tokenAuth; ?>" target="_blank"><i class="fa fa-eye" style="font-size: 25px;"></i></a>
					
					</td> --/>
					
					<td><a href="invoicew23dec22.php?in=<?php echo $encrypted_string; ?>&authToken=<?php  echo $tokenAuth; ?>" target="_blank"><i class="fa fa-eye" style="font-size: 25px;"></i></a></td>
                </tr>
					 <?php } ?>
              
                </tfoot>
              </table>
			  <div class="form-group">
         <form class="form-horizontal" action="exportTutionFeew23dec22.php" method="post" name="upload_excel"   
                      enctype="multipart/form-data">
                  <div class="form-group">
                            
								
                                <input type="submit" name="Export" onclick="Export()"  style="margin-left: 20px;" class="btn btn-success" value="Export to Excel"/>
                           
                   </div>                    
            </form>     
    </div>
            </div>
            <!/-- /.box-body --/>
  
          </div>
          <!/-- /.box --/>
        </div>-->
        
      </div>
      
    </section> 
	  <section class="content">
      <div class="row">
        <div class="col-xs-12" style="padding-left: 0px;  padding-right: 0px;">
          <div class="box">
            <div class="box-header">
              <h3 class="box-title"><strong>Hostel Fee Details</strong></h3>
			  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(<a href="https://payments.iiitd.edu.in/pg/fees/vpayments-hostel.php" target="_blank"><strong>Payment Portal Link</strong></a>)
            </div>

<?php

$adminohh=$DB_con->prepare("SELECT count(*) FROM studenthosteldetail");
    $adminohh->execute();
    $adminrowohh = $adminohh->fetch(PDO::FETCH_NUM);
    $admincountohh = $adminrowohh[0];
?>
        <div class="col-lg-2 col-xs-6">
          
          <div class="small-box bg-red">
            <div class="inner">
              <p>Demand raised for students</p>
			  <h3><?php echo $admincountohh; ?></h3>

<p><a href="viewHostelFeeNewsb2324may24.php?authToken=<?php echo $tokenAuth;?>" style="color:#fff; text-decoration:underline;" target="_blank">Hostel Fee Collection Details</a></p>
				<p><a href="viewhostelfeedatasb2324may24.php?authToken=<?php echo $tokenAuth;?>" style="color:#fff; text-decoration:underline;" target="_blank">Demand Raised Data</a></p>
			 <p><a href="hostelfeereconciliationsb2324may24.php?authToken=<?php echo $tokenAuth;?>" style="color:#fff; text-decoration:underline;" target="_blank">Reconciliation Details</a></p>
            </div>
            <div class="icon">
             <i class="fa fa-user" aria-hidden="true"></i>
            </div>
            <a href="viewHostelFeeNewsb2324may24.php?authToken=<?php echo $tokenAuth;?>" class="small-box-footer" target="_blank">Summer Break 23-24 (May 24) </a>
          </div>
        </div>
		
		  
			  
			  
			  
			  
			  
			  <?php

$adminohh=$DB_con->prepare("SELECT count(*) FROM studenthosteldetailw23jan24");
    $adminohh->execute();
    $adminrowohh = $adminohh->fetch(PDO::FETCH_NUM);
    $admincountohh = $adminrowohh[0];
?>
        <div class="col-lg-2 col-xs-6">
          
          <div class="small-box bg-red">
            <div class="inner">
              <p>Demand raised for students</p>
			  <h3><?php echo $admincountohh; ?></h3>

<p><a href="viewHostelFeeNewjan24.php?authToken=<?php echo $tokenAuth;?>" style="color:#fff; text-decoration:underline;" target="_blank">Hostel Fee Collection Details</a></p>
				<p><a href="viewhostelfeedatajan24.php?authToken=<?php echo $tokenAuth;?>" style="color:#fff; text-decoration:underline;" target="_blank">Demand Raised Data</a></p>
			 <p><a href="hostelfeereconciliationw2324jan24.php?authToken=<?php echo $tokenAuth;?>" style="color:#fff; text-decoration:underline;" target="_blank">Reconciliation Details</a></p>
            </div>
            <div class="icon">
             <i class="fa fa-user" aria-hidden="true"></i>
            </div>
            <a href="viewHostelFeeNewjan24.php?authToken=<?php echo $tokenAuth;?>" class="small-box-footer" target="_blank">Winter 23-24 (Jan 24) </a>
          </div>
        </div>
		
		  
			  
			  
			  
			  
			  
			  <?php

$adminohh=$DB_con->prepare("SELECT count(*) FROM studenthosteldetailwbdec23");
    $adminohh->execute();
    $adminrowohh = $adminohh->fetch(PDO::FETCH_NUM);
    $admincountohh = $adminrowohh[0];
?>
        <div class="col-lg-2 col-xs-6">
          
          <div class="small-box bg-red">
            <div class="inner">
              <p>Demand raised for students</p>
			  <h3><?php echo $admincountohh; ?></h3>

<p><a href="viewHostelFeeNewdec23.php?authToken=<?php echo $tokenAuth;?>" style="color:#fff; text-decoration:underline;" target="_blank">Hostel Fee Collection Details</a></p>
				<p><a href="viewhostelfeedatadec23.php?authToken=<?php echo $tokenAuth;?>" style="color:#fff; text-decoration:underline;" target="_blank">Demand Raised Data</a></p>
			 <p><a href="hostelfeereconciliationdec23.php?authToken=<?php echo $tokenAuth;?>" style="color:#fff; text-decoration:underline;" target="_blank">Reconciliation Details</a></p>
            </div>
            <div class="icon">
             <i class="fa fa-user" aria-hidden="true"></i>
            </div>
            <a href="viewHostelFeeNewdec23.php?authToken=<?php echo $tokenAuth;?>" class="small-box-footer" target="_blank">Winter Break 23-24 (Dec 23) </a>
          </div>
        </div>
		
		  
			  
			  
			  
			  
			  
			  <?php

$adminohh=$DB_con->prepare("SELECT count(*) FROM studenthosteldetailaug23");
    $adminohh->execute();
    $adminrowohh = $adminohh->fetch(PDO::FETCH_NUM);
    $admincountohh = $adminrowohh[0];
?>
        <div class="col-lg-2 col-xs-6">
          
          <div class="small-box bg-red">
            <div class="inner">
              <p>Demand raised for students</p>
			  <h3><?php echo $admincountohh; ?></h3>

<p><a href="viewHostelFeeNew.php?authToken=<?php echo $tokenAuth;?>" style="color:#fff; text-decoration:underline;" target="_blank">Hostel Fee Collection Details</a></p>
				<p><a href="viewhostelfeedatam2324.php?authToken=<?php echo $tokenAuth;?>" style="color:#fff; text-decoration:underline;" target="_blank">Demand Raised Data</a></p>
			  <p><a href="hostelfeereconciliationm2324aug23.php?authToken=<?php echo $tokenAuth;?>" style="color:#fff; text-decoration:underline;" target="_blank">Reconciliation Details</a></p>
            </div>
            <div class="icon">
             <i class="fa fa-user" aria-hidden="true"></i>
            </div>
            <a href="viewHostelFeeNew.php?authToken=<?php echo $tokenAuth;?>" class="small-box-footer" target="_blank">Monsoon 23-24 (Aug 23) </a>
          </div>
        </div>
		
		  
			  
			  
			  <div style="clear: both;"></div>
			  <hr/>
			  
            <div class="box-body">
              <table id="example3" class="table table-bordered table-striped">
                <thead>
				<tr>
					<th>Roll No.</th>
					<th>Student Name</th>
                  
					<th>Payment</th>
				 <th>Payment Mode</th>
                  <th>View Receipt</th>
                </tr>

</thead>
                <tbody>
					<?php
						
								$result = $DB_con->prepare("SELECT * FROM hostelfee");
								$result->execute();
								for($i=0; $row = $result->fetch(); $i++){
									
							?>
                <tr>
					<td><?php echo $row ['rollNumber']; ?></td>
                  <td><?php echo $row ['studentName']; ?></td>
                  
					<td><?php $payment = $row ['payment'];
					 if($payment == "Other"){
					echo $payment . "-" . $row ['otherAmount'];  
					 } else {
					 
					 echo  $payment;
					 } 
					 
					 ?>
					</td>
					<td><?php echo $row ['paymentMode']; $id =  base64_encode( $row['hostelfeeID']); $studentID ?></td>
					
                  <td><a href="invoiceHostel.php?in=<?php echo $id; ?>&authToken=<?php echo $tokenAuth; ?>"><i class="fa fa-eye" style="font-size: 25px;"></i></a>
					
					</td>
                </tr>
					 <?php } ?>
              
                </tfoot>
              </table>
			   <div class="form-group">
         <form class="form-horizontal" action="exportHostelFee.php" method="post" name="upload_excel"   
                      enctype="multipart/form-data">
                  <div class="form-group">
                            
								
                                <input type="submit" name="exportHostel"  style="margin-left: 20px;" class="btn btn-success" value="Export Hostel Fee detail to Excel"/>
                           
                   </div>                    
            </form>     
    </div>
            </div> 
            
  
          </div> 
           
        </div> 
        
      </div> 
       
    </section> 
	  
  </div>
  <?php ob_end_flush(); require PATH_LIB . "page-bottom.php"; ?>

Urban Research Lab

The Urban Research Lab (URL) at IIIT-Delhi was established in 2020, during a time when the pandemic brought the complexities of urban life more visible than ever. What started as an initiative by faculty and students has grown into a collaborative space for critically exploring and reimagining the urban questions through research, dialogue, and interdisciplinary engagement.

${this.title}

Code Editor : adminDashboard.php

Urban Research Lab