Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
.admin-src.php	3.61 KB	-rw-r--r--
ApplicationFeeSummary.php	10.25 KB	-rwxrwxrwx
ApplicationReport.php	9.96 KB	-rwxrwxrwx
Applicationfeereport.php	9.13 KB	-rwxrwxrwx
Collegewise_SeatAllotedList.ph...	11.13 KB	-rwxrwxrwx
Degreewise_SeatAllotedList.php	11.28 KB	-rwxrwxrwx
PrintDocumentVerification.php	23.98 KB	-rwxrwxrwx
SeatMatrixReport.php	24.02 KB	-rwxrwxrwx
admconfirmation.php	4.43 KB	-rwxrwxrwx
admissionMeritListExcel.php	11.08 KB	-rwxrwxrwx
admissionstatusreport.php	12.62 KB	-rwxrwxrwx
admorder_ru.php	4.53 KB	-rw-rw-r--
applicationFormReportBank.php	11.82 KB	-rw-rw-r--
applicationview.php	4.39 KB	-rwxrwxrwx
bnuAdmissionMeritListExcel.php	12.07 KB	-rwxrwxrwx
bnuAdmissionMeritListExcel_161...	11.88 KB	-rwxrwxrwx
changepasswordadmin.php	1.12 KB	-rwxrwxrwx
collegedegree.php	1.92 KB	-rwxrwxrwx
collegedetails.php	2.49 KB	-rwxrwxrwx
create-user.php	4.96 KB	-rwxrwxrwx
documentverification.php	8.75 KB	-rwxrwxrwx
dudseatallot.php	14.5 KB	-rw-rw-r--
editapp.php	1.38 KB	-rw-rw-r--
getAdmOrderDet.php	1.53 KB	-rw-r--r--
getnumword.php	9.1 KB	-rw-rw-r--
meritlist.php	6.41 KB	-rwxrwxrwx
presealallot.php	7.58 KB	-rw-rw-r--
provisionsellist.php	692 B	-rw-rw-r--
provisionsellistReport.php	13.57 KB	-rw-rw-r--
provisionsellistReport1.php	11.76 KB	-rw-rw-r--
provisionsellistReport1Downloa...	12.84 KB	-rw-rw-r--
provisionsellistReportDownload...	15 KB	-rw-rw-r--
report_merit_list.php	6.82 KB	-rwxrwxrwx
rostertable.php	490 B	-rwxrwxrwx
saveApplication.php	20.67 KB	-rwxrwxrwx
savevacantseats.php	2.57 KB	-rw-rw-r--
seatmatrix.php	8.53 KB	-rwxrwxrwx
signin.php	848 B	-rwxrwxrwx
viewpresealallot2.php	8.05 KB	-rw-rw-r--

Code Editor : seatmatrix.php

<?php
function loadSeatMatrix($aobj_context){
  $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);  
	
	
	
	
	$query1 = "SELECT a.fdegree, d.fdescpn, a.fcollcode, c.fcollname, sum(ifnull(a.HKGMTOT,0)) as HKGMTOT, sum(ifnull(a.HKGMALLOT,0)) as HKGMALLOT, sum(ifnull(a.HKGMPEND,0)) as HKGMPEND, sum(ifnull(a.HKGMCAN,0)) as HKGMCAN, 
  sum(ifnull(a.HKCATITOT,0)) as HKCATITOT, sum(ifnull(a.HKCATIALLOT,0)) as HKCATIALLOT, sum(ifnull(a.HKCATIPEND,0)) as HKCATIPEND, sum(ifnull(a.HKCATICAN,0)) as HKCATICAN,
  sum(ifnull(a.HKIIATOT,0)) as HKIIATOT,  sum(ifnull(a.HKIIAALLOT,0)) as HKIIAALLOT, sum(ifnull(a.HKIIAPEND,0)) as HKIIAPEND, sum(ifnull(a.HKIIACAN,0)) as HKIIACAN,
  sum(ifnull(a.HKIIBTOT,0)) as HKIIBTOT, sum(ifnull(a.HKIIBALLOT,0)) as HKIIBALLOT, sum(ifnull(a.HKIIBPEND,0)) as HKIIBPEND, sum(ifnull(a.HKIIBCAN,0)) as HKIIBCAN,
  sum(ifnull(a.HKIIIATOT,0)) as HKIIIATOT, sum(ifnull(a.HKIIIAALLOT,0)) as HKIIIAALLOT, sum(ifnull(a.HKIIIAPEND,0)) as HKIIIAPEND, sum(ifnull(a.HKIIIACAN,0)) as HKIIIACAN,
  sum(ifnull(a.HKIIIBTOT,0)) as HKIIIBTOT, sum(ifnull(a.HKIIIBALLOT,0)) as HKIIIBALLOT, sum(ifnull(a.HKIIIBPEND,0)) as HKIIIBPEND, sum(ifnull(a.HKIIIBCAN,0)) as HKIIIBCAN,
  sum(ifnull(a.HKSCTOT,0)) as HKSCTOT, sum(ifnull(a.HKSCALLOT,0)) as HKSCALLOT, sum(ifnull(a.HKSCPEND,0)) as HKSCPEND, sum(ifnull(a.HKSCCAN,0)) as HKSCCAN,
  sum(ifnull(a.HKSTTOT,0)) as HKSTTOT, sum(ifnull(a.HKSTALLOT,0)) as HKSTALLOT, sum(ifnull(a.HKSTPEND,0)) as HKSTPEND, sum(ifnull(a.HKSTCAN,0)) as HKSTCAN,
  sum(ifnull(a.NHKGMTOT,0)) as NHKGMTOT, sum(ifnull(a.NHKGMALLOT,0)) as NHKGMALLOT, sum(ifnull(a.NHKGMPEND,0)) as NHKGMPEND, sum(ifnull(a.NHKGMCAN,0)) as NHKGMCAN, 
  sum(ifnull(a.NHKCATITOT,0)) as NHKCATITOT, sum(ifnull(a.NHKCATIALLOT,0)) as NHKCATIALLOT, sum(ifnull(a.NHKCATIPEND,0)) as NHKCATIPEND, sum(ifnull(a.NHKCATICAN,0)) as NHKCATICAN,
  sum(ifnull(a.NHKIIATOT,0)) as NHKIIATOT, sum(ifnull(a.NHKIIAALLOT,0)) as NHKIIAALLOT, sum(ifnull(a.NHKIIAPEND,0)) as NHKIIAPEND, sum(ifnull(a.NHKIIACAN,0)) as NHKIIACAN,
  sum(ifnull(a.NHKIIBTOT,0)) as NHKIIBTOT, sum(ifnull(a.NHKIIBALLOT,0)) as NHKIIBALLOT, sum(ifnull(a.NHKIIBPEND,0)) as NHKIIBPEND, sum(ifnull(a.NHKIIBCAN,0)) as NHKIIBCAN,
  sum(ifnull(a.NHKIIIATOT,0)) as NHKIIIATOT, sum(ifnull(a.NHKIIIAALLOT,0)) as NHKIIIAALLOT, sum(ifnull(a.NHKIIIAPEND,0)) as NHKIIIAPEND, sum(ifnull(a.NHKIIIACAN,0)) as NHKIIIACAN,
  sum(ifnull(a.NHKIIIBTOT,0)) as NHKIIIBTOT, sum(ifnull(a.NHKIIIBALLOT,0)) as NHKIIIBALLOT, sum(ifnull(a.NHKIIIBPEND,0)) as NHKIIIBPEND, sum(ifnull(a.NHKIIIBCAN,0)) as NHKIIIBCAN,
  sum(ifnull(a.NHKSCTOT,0)) as NHKSCTOT, sum(ifnull(a.NHKSCALLOT,0)) as NHKSCALLOT, sum(ifnull(a.NHKSCPEND,0)) as NHKSCPEND, sum(ifnull(a.NHKSCCAN,0)) as NHKSCCAN,
  sum(ifnull(a.NHKSTTOT,0)) as NHKSTTOT, sum(ifnull(a.NHKSTALLOT,0)) as NHKSTALLOT, sum(ifnull(a.NHKSTPEND,0)) as NHKSTPEND, sum(ifnull(a.NHKSTCAN,0)) as NHKSTCAN
  from (select fcollcode, fdegree, 
  case when freserve = 'HK' and fcatcode = 'GM' then ftotseats end as HKGMTOT,
  case when freserve = 'HK' and fcatcode = 'GM' then fallotseats end as HKGMALLOT, 
  case when freserve = 'HK' and fcatcode = 'GM' then fpendseats end as HKGMPEND,
  case when freserve = 'HK' and fcatcode = 'GM' then fcanseats end as HKGMCAN,
  case when freserve = 'HK' and fcatcode = 'CAT-I' then ftotseats end as HKCATITOT,
  case when freserve = 'HK' and fcatcode = 'CAT-I' then fallotseats end as HKCATIALLOT, 
  case when freserve = 'HK' and fcatcode = 'CAT-I' then fpendseats end as HKCATIPEND,
  case when freserve = 'HK' and fcatcode = 'CAT-I' then fcanseats end as HKCATICAN, 
  case when freserve = 'HK' and fcatcode = 'IIA' then ftotseats end as HKIIATOT, 
  case when freserve = 'HK' and fcatcode = 'IIA' then fallotseats end as HKIIAALLOT,
  case when freserve = 'HK' and fcatcode = 'IIA' then fpendseats end as HKIIAPEND,
  case when freserve = 'HK' and fcatcode = 'IIA' then fcanseats end as HKIIACAN, 
  case when freserve = 'HK' and fcatcode = 'IIB' then ftotseats end as HKIIBTOT, 
  case when freserve = 'HK' and fcatcode = 'IIB' then fallotseats end as HKIIBALLOT,
  case when freserve = 'HK' and fcatcode = 'IIB' then fpendseats end as HKIIBPEND,
  case when freserve = 'HK' and fcatcode = 'IIB' then fcanseats end as HKIIBCAN,
  case when freserve = 'HK' and fcatcode = 'IIIA' then ftotseats end as HKIIIATOT, 
  case when freserve = 'HK' and fcatcode = 'IIIA' then fallotseats end as HKIIIAALLOT,
  case when freserve = 'HK' and fcatcode = 'IIIA' then fpendseats end as HKIIIAPEND,
  case when freserve = 'HK' and fcatcode = 'IIIA' then fcanseats end as HKIIIACAN,
  case when freserve = 'HK' and fcatcode = 'IIIB' then ftotseats end as HKIIIBTOT, 
  case when freserve = 'HK' and fcatcode = 'IIIB' then fallotseats end as HKIIIBALLOT,
  case when freserve = 'HK' and fcatcode = 'IIIB' then fpendseats end as HKIIIBPEND,
  case when freserve = 'HK' and fcatcode = 'IIIB' then fcanseats end as HKIIIBCAN, 
  case when freserve = 'HK' and fcatcode = 'SC' then ftotseats end as HKSCTOT, 
  case when freserve = 'HK' and fcatcode = 'SC' then fallotseats end as HKSCALLOT,
  case when freserve = 'HK' and fcatcode = 'SC' then fpendseats end as HKSCPEND,
  case when freserve = 'HK' and fcatcode = 'SC' then fcanseats end as HKSCCAN, 
  case when freserve = 'HK' and fcatcode = 'ST' then ftotseats end as HKSTTOT, 
  case when freserve = 'HK' and fcatcode = 'ST' then fallotseats end as HKSTALLOT,
  case when freserve = 'HK' and fcatcode = 'ST' then fpendseats end as HKSTPEND,
  case when freserve = 'HK' and fcatcode = 'ST' then fcanseats end as HKSTCAN, 
  case when freserve = 'NHK' and fcatcode = 'GM' then ftotseats end as NHKGMTOT, 
  case when freserve = 'NHK' and fcatcode = 'GM' then fallotseats end as NHKGMALLOT,
  case when freserve = 'NHK' and fcatcode = 'GM' then fpendseats end as NHKGMPEND,
  case when freserve = 'NHK' and fcatcode = 'GM' then fcanseats end as NHKGMCAN,
  case when freserve = 'NHK' and fcatcode = 'CAT-I' then ftotseats end as NHKCATITOT,
  case when freserve = 'NHK' and fcatcode = 'CAT-I' then fallotseats end as NHKCATIALLOT, 
  case when freserve = 'NHK' and fcatcode = 'CAT-I' then fpendseats end as NHKCATIPEND,
  case when freserve = 'NHK' and fcatcode = 'CAT-I' then fcanseats end as NHKCATICAN, 
  case when freserve = 'NHK' and fcatcode = 'IIA' then ftotseats end as NHKIIATOT, 
  case when freserve = 'NHK' and fcatcode = 'IIA' then fallotseats end as NHKIIAALLOT,
  case when freserve = 'NHK' and fcatcode = 'IIA' then fpendseats end as NHKIIAPEND,
  case when freserve = 'NHK' and fcatcode = 'IIA' then fcanseats end as NHKIIACAN, 
  case when freserve = 'NHK' and fcatcode = 'IIB' then ftotseats end as NHKIIBTOT, 
  case when freserve = 'NHK' and fcatcode = 'IIB' then fallotseats end as NHKIIBALLOT,
  case when freserve = 'NHK' and fcatcode = 'IIB' then fpendseats end as NHKIIBPEND,
  case when freserve = 'NHK' and fcatcode = 'IIB' then fcanseats end as NHKIIBCAN,
  case when freserve = 'NHK' and fcatcode = 'IIIA' then ftotseats end as NHKIIIATOT,
  case when freserve = 'NHK' and fcatcode = 'IIIA' then fallotseats end as NHKIIIAALLOT, 
  case when freserve = 'NHK' and fcatcode = 'IIIA' then fpendseats end as NHKIIIAPEND,
  case when freserve = 'NHK' and fcatcode = 'IIIA' then fcanseats end as NHKIIIACAN,
  case when freserve = 'NHK' and fcatcode = 'IIIB' then ftotseats end as NHKIIIBTOT, 
  case when freserve = 'NHK' and fcatcode = 'IIIB' then fallotseats end as NHKIIIBALLOT,
  case when freserve = 'NHK' and fcatcode = 'IIIB' then fpendseats end as NHKIIIBPEND,
  case when freserve = 'NHK' and fcatcode = 'IIIB' then fcanseats end as NHKIIIBCAN, 
  case when freserve = 'NHK' and fcatcode = 'SC' then ftotseats end as NHKSCTOT, 
  case when freserve = 'NHK' and fcatcode = 'SC' then fallotseats end as NHKSCALLOT,
  case when freserve = 'NHK' and fcatcode = 'SC' then fpendseats end as NHKSCPEND,
  case when freserve = 'NHK' and fcatcode = 'SC' then fcanseats end as NHKSCCAN, 
  case when freserve = 'NHK' and fcatcode = 'ST' then ftotseats end as NHKSTTOT, 
  case when freserve = 'NHK' and fcatcode = 'ST' then fallotseats end as NHKSTALLOT,
  case when freserve = 'NHK' and fcatcode = 'ST' then fpendseats end as NHKSTPEND,
  case when freserve = 'NHK' and fcatcode = 'ST' then fcanseats end as NHKSTCAN 
  from entseatmatrix) a inner join entdeg d on a.fdegree = d.fdegree inner join entcoll c on a.fcollcode = c.fcollcode 
  group by a.fdegree, a.fcollcode";
  $result1 = $aobj_context->mobj_db->GetAll($query1);
  // var_dump($result1);
	if($result1)
	{	
		echo $aobj_context->mobj_output->ToJSONEnvelope($result1,0,"success"); 
	}	
	else
	{	
		$arr = "Some Failure as occured";
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"error"); 
	}
}

${this.title}

Code Editor : seatmatrix.php