Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
SelectionList	[ DIR ]	drwxrwxrwx
SelectionList2	[ DIR ]	drwxrwxrwx
SelectionList3	[ DIR ]	drwxrwxrwx
meritlist	[ DIR ]	drwxrwxrwx
meritlist_2	[ DIR ]	drwxrwxrwx
meritlist_3	[ DIR ]	drwxrwxr-x
.bnu.php	3.61 KB	-rw-r--r--
1.pdf	56.4 KB	-rwxrwxrwx
Admission Rules (1).pdf	765.98 KB	-rw-rw-r--
Admission Rules.pdf	3.58 MB	-rwxrwxrwx
Arts & Science.pdf	767.91 KB	-rw-r--r--
Arts.pdf	11.86 MB	-rwxrwxrwx
Commencment of 1st sem PG Clas...	37.69 KB	-rwxrwxrwx
Commerce (1).pdf	300.4 KB	-rwxrwxrwx
Commerce.pdf	734.5 KB	-rw-r--r--
Courses offered by various Dep...	324.76 KB	-rw-rw-r--
Courses offered by various Dep...	325.17 KB	-rw-r--r--
Degree wise College wise Intak...	3.57 MB	-rwxrwxrwx
Eligibility Criteria.pdf	427.18 KB	-rw-rw-r--
Extension_of_PG_online_admissi...	237.25 KB	-rwxrwxrwx
Extension_of_PG_online_admissi...	482.16 KB	-rwxrwxrwx
Govt & Pvt Fee Structure.pdf	875.77 KB	-rw-rw-r--
MED COUNSELLING .pdf	82.52 KB	-rwxrwxrwx
MEd (2).pdf	206.69 KB	-rwxrwxrwx
MEd (2)_old.pdf	260.38 KB	-rwxrwxrwx
MainPage.html	52.32 KB	-rwxrwxrwx
Merit List _Recounselling.pdf	10.94 MB	-rwxrwxrwx
PG Admission Extension till 26...	53.24 KB	-rw-rw-r--
PG Admission counselling.pdf	514.69 KB	-rwxrwxrwx
PG Counselling.pdf	103.41 KB	-rwxrwxrwx
PG Courses offered and Intake....	718.58 KB	-rw-rw-r--
PG Eligibility Criteria 2020 ....	6.89 MB	-rwxrwxrwx
PG Fee Structure Affiliated Pr...	3.81 MB	-rwxrwxrwx
PG Fee Structure BNU and Govt....	5.23 MB	-rwxrwxrwx
PG MED Extension (1).pdf	242.27 KB	-rwxrwxrwx
PG Merit List Recounselling.pd...	10.83 MB	-rwxrwxrwx
PG Notification English (1).p...	131.02 KB	-rwxrwxrwx
PG Notification Kannada .pdf	146.08 KB	-rwxrwxrwx
PG Offline Councelling.pdf	180.52 KB	-rw-rw-r--
PG Online Admission Provisiona...	50.67 KB	-rw-rw-r--
PG Super Numarary quota.pdf	218.87 KB	-rwxrwxrwx
PG Vacent Seats.pdf	1.32 MB	-rwxrwxrwx
PG_Course_details_in_BNU_Depar...	1.19 MB	-rwxrwxrwx
Procedure for Option Entry and...	80.07 KB	-rw-rw-r--
Schedule_for_PG_admission_Coun...	89.66 KB	-rwxrwxrwx
Science.pdf	14.84 MB	-rwxrwxrwx
Seat Matrix Final_01.01.2021.p...	1.03 MB	-rwxrwxrwx
Seat Matrix for Supernumerary....	284.73 KB	-rwxrwxrwx
Seat Matrix.pdf	6.85 MB	-rwxrwxrwx
Selection_List.php	19.49 KB	-rw-rw-r--
Selection_List2.php	19.49 KB	-rw-rw-r--
Selection_List3.php	19.49 KB	-rw-rw-r--
Supernumerary Quota Seats_2020...	1.03 MB	-rwxrwxrwx
Vacant Seats_PG Admission 2021...	1.36 MB	-rw-rw-r--
Vacant seats for MFA,MTTM and ...	235.97 KB	-rwxrwxrwx
add-course-payment.html	692 B	-rwxrwxrwx
add-course.html	1.23 KB	-rwxrwxrwx
admfee.html	8.54 KB	-rw-rw-r--
admorder_bnu.html	1.86 KB	-rw-r--r--
app-status.html	3.37 KB	-rwxrwxrwx
bnu_seatmatrix_2nd_rnd.pdf	71.47 KB	-rw-rw-r--
bnu_seatmatrix_2nd_rnd_super.p...	41.54 KB	-rw-rw-r--
bnu_seatmatrix_3rd_rnd.pdf	68.95 KB	-rw-rw-r--
bnu_seatmatrix_3rd_rnd_supernu...	41.54 KB	-rw-rw-r--
bnu_seatmatrix_4th_rnd.pdf	55.53 KB	-rw-rw-r--
bnu_seatmatrix_4th_rnd_supernu...	39.79 KB	-rw-rw-r--
dat.json	5.03 KB	-rwxrwxrwx
ent-application.html	106.06 KB	-rwxrwxrwx
ent-application05.10.2020.html	83.65 KB	-rwxrwxrwx
forgotPassword.html	5.11 KB	-rwxrwxrwx
genRankPrio.php	894 B	-rwxrwxrwx
index.html	10.49 KB	-rwxrwxrwx
index1.html	9.86 KB	-rw-rw-r--
index_adm.html	5.42 KB	-rwxrwxrwx
index_wait.html	13.97 KB	-rwxrwxrwx
instruction.html	10.69 KB	-rwxrwxrwx
login.html	6.01 KB	-rwxrwxrwx
make-payment.html	452 B	-rwxrwxrwx
merit_list.php	2.14 KB	-rwxrwxrwx
mock-seat-allotment.html	608 B	-rwxrwxrwx
option-entry.html	1.46 KB	-rwxrwxrwx
pg-forgotPassword.html	4.1 KB	-rwxrwxrwx
pg-sign-up.html	7.81 KB	-rwxrwxrwx
pg_instruction.html	9.62 KB	-rwxrwxrwx
pgadm.html	67.76 KB	-rwxrwxrwx
seat-allotment.html	1.08 KB	-rwxrwxrwx
seatAllot.php	6.75 KB	-rwxrwxrwx
seatvacancy.html	5.77 KB	-rw-rw-r--
second round P.G counseling.pd...	256.08 KB	-rwxrwxrwx
sign-up.html	7.96 KB	-rwxrwxrwx
support.html	4.76 KB	-rwxrwxrwx
upload_file.php	787 B	-rwxrwxrwx
upload_file_pg.php	746 B	-rwxrwxrwx

Code Editor : seatAllot.php

<?php
include ("../database.php");

$query = "select x.fappno, if( ifnull(x.fcategory,'') = '', 'GM', x.fcategory) as fcategory, x.fhk, x.frank 
from entstudadm x inner join entoptions y on x.fappno = y.fappno 
where ifnull(fpaystatus,'') = 'success' 
and ifnull(fappstatus,'') <> '' group by x.fappno
order by frank limit 10";

$result = mysqli_query($conn,$query);
echo '<style>
table{
width:100%;
table-layout: fixed;
}
</style>	
<table style="text-align: left;width: 100%;"  border="1" cellpadding="10" cellspacing="0">
<thead style = "">
    <tr style = "background-color:#8acc51">
        <th width="5%" align="center"><b>Sl. No.</b></th>
        <th width="10%" align="center"><b>App. No.</b></th>
        <th width="15%" align="left"><b>Name</b></th>
        <th width="25%" align="left"><b>College</b></th>
        <th width="25%" align="left"><b>Degree</b></th>
        <th align="left"><b>Region</b></th>
        <th align="left"><b>Category</b></th>
        <th align="center"><b>Allotment No.</b></th>
        <th align="center"><b>Rank</b></th>
    </tr>
</thead>
</table>
    
<table style="text-align: left;width: 100%;"  border="1" cellpadding="10" cellspacing="0">
<tbody>';
$slno = 1;
while($row = mysqli_fetch_assoc($result)) {
	
	$query = "select fappno, fcollcode, fdegree from entoptions where fappno = '{$row['fappno']}' order by fpriority desc";
	$result1 = mysqli_query($conn,$query);
	while($row1 = mysqli_fetch_assoc($result1)) {

} else if(strtoupper($row['fcategory']) != 'GM') {

$query = "select fdegree, fcollcode, fpendseats from entseatmatrix 
            where  fcollcode = '{$row1['fcollcode']}' and fdegree = '{$row1['fdegree']}' and freserve = 'NHK' and fcatcode = '{$row['fcategory']}'";
            $result3 = mysqli_query($conn,$query);
            $seatmat2 = mysqli_fetch_assoc($result3);
            if($seatmat2['fpendseats'] > 0 ) {
                allotSeat($row['fappno'], $row1['fdegree'], $row1['fcollcode'], $row['fcategory'], 'NHK', $conn, $row['frank']);
                continue;
            }
        } 
        
        if (strtoupper($row['fhk']) == 'YES') {
            $query = "select fdegree, fcollcode, fpendseats from entseatmatrix 
            where  fcollcode = '{$row1['fcollcode']}' and fdegree = '{$row1['fdegree']}' and freserve = 'HK' and fcatcode = 'GM'";
            $result4 = mysqli_query($conn,$query);
            $seatmat3 = mysqli_fetch_assoc($result4);
            if($seatmat3['fpendseats'] > 0 ) {
                allotSeat($row['fappno'], $row1['fdegree'], $row1['fcollcode'], 'GM', 'HK', $conn, $row['frank']);
                continue;
            }
        }

if (strtoupper($row['fhk']) == 'YES' && strtoupper($row['fcategory']) != 'GM') {
            $query = "select fdegree, fcollcode, fpendseats from entseatmatrix 
            where  fcollcode = '{$row1['fcollcode']}' and fdegree = '{$row1['fdegree']}' and freserve = 'HK' and fcatcode = '{$row['fcategory']}'";
            $result5 = mysqli_query($conn,$query);
            $seatmat4 = mysqli_fetch_assoc($result5);
            if($seatmat4['fpendseats'] > 0 ) {
                allotSeat($row['fappno'], $row1['fdegree'], $row1['fcollcode'], $row['fcategory'], 'HK', $conn, $row['frank']);
                continue;
            }
        }
    }
    $query = "select x.fappno, y.fname, concat(x.fdegree,' - ', d.fdescpn) as degree, 
    concat(x.fcollcode, ' - ', c.fcollname) as college, x.fcatcode, 
    x.freserve, x.fallotno, x.frank from entseatallot x inner join entstudadm y on x.fappno = y.fappno 
    inner join entdeg d on x.fdegree = d.fdegree inner join entcoll c on x.fcollcode = c.fcollcode
    where x.fappno = '{$row['fappno']}'";
    
    $res = mysqli_query($conn,$query);
    $seatallot = mysqli_fetch_assoc($res);

echo "<tr>
        <td width='5%' align='center'>{$slno}</td>
        <td width='10%' align='center'>{$seatallot['fappno']}</td>
        <td width='15%' align='left'>{$seatallot['fname']}</td>
        <td width='25%' align='left'>{$seatallot['college']}</td>
        <td width='25%' align='left'>{$seatallot['degree']}</td>
        <td align='center'>{$seatallot['freserve']}</td>
        <td align='center'>{$seatallot['fcatcode']}</td>
        <td align='center'>{$seatallot['fallotno']}</td>
        <td align='center'>{$seatallot['frank']}</td>
    </tr>";
    
    flush();
    ob_flush();
    $slno++;
}

function allotSeat($fappno, $allotdeg, $allotcoll, $allotcat, $allotres, $conn, $rank) {
    $query = "select fdegree, fcollcode, freserve, fcatcode from entseatallot where fappno = '{$fappno}'";
    $result3 = mysqli_query($conn,$query);
    $count = mysqli_num_rows($result3);
    if($count > 0) {
        $seat_allot =  mysqli_fetch_assoc($result3);

$query = "delete from entseatallot where fappno = '{$fappno}'";
        $result4 = mysqli_query($conn,$query);

$query = "update entseatmatrix set fpendseats = ifnull(fpendseats,0) + 1, fallotseats = ifnull(fallotseats,0) - 1 
        where fdegree = '{$seat_allot['fdegree']}' and fcollcode = '{$seat_allot['fcollcode']}' 
        and freserve = '{$seat_allot['freserve']}' and fcatcode = '{$seat_allot['fcatcode']}'";
        $result5 = mysqli_query($conn,$query);

$query = "update entoptions set freserve = '', fcatcode = '' 
        where fdegree = '{$seat_allot['fdegree']}' and fcollcode = '{$seat_allot['fcollcode']}' 
        and fappno = '{$fappno}'";
        $result7 = mysqli_query($conn,$query);

}

// echo "$fappno -- $allotdeg -- $allotcoll -- $allotcat -- $allotres";

$insert = "insert into entseatallot(fappno, fdegree, fcollcode, freserve, fcatcode, frank, fallotdate, fallotround) 
    values('{$fappno}', '{$allotdeg}', '{$allotcoll}', '{$allotres}', '{$allotcat}', '{$rank}', now(), 0)";
    $result6 = mysqli_query($conn,$insert);

$query = "update entseatmatrix set fpendseats = ifnull(fpendseats,0) - 1, fallotseats = ifnull(fallotseats,0) + 1 
    where fdegree = '{$allotdeg}' and fcollcode = '{$allotcoll}' 
    and freserve = '{$allotres}' and fcatcode = '{$allotcat}'";
    $result7 = mysqli_query($conn,$query);

$query = "update entoptions set freserve = '{$allotres}', fcatcode = '{$allotcat}' 
    where fdegree = '{$allotdeg}' and fcollcode = '{$allotcoll}' 
    and fappno = '{$fappno}'";
    $result7 = mysqli_query($conn,$query);
}

mysqli_close($conn);

${this.title}

Code Editor : seatAllot.php