Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
ApplicationFeeSummary.php	10.14 KB	-rwxr-xr-x
ApplicationReport.php	9.8 KB	-rwxr-xr-x
Applicationfeereport.php	8.56 KB	-rwxr-xr-x
Collegewise_SeatAllotedList.ph...	11.13 KB	-rwxr-xr-x
Degreewise_SeatAllotedList.php	11.34 KB	-rwxr-xr-x
SeatMatrixReport.php	24.02 KB	-rwxr-xr-x
admconfirmation.php	4.43 KB	-rwxr-xr-x
admissionfeedetails.php	1.56 KB	-rw-rw-r--
admissionfeereport.php	11.59 KB	-rw-rw-r--
admissionstatusreport.php	12.62 KB	-rwxr-xr-x
applicationview.php	9.5 KB	-rwxr-xr-x
collegedegree.php	1.92 KB	-rwxr-xr-x
collegedetails.php	1.96 KB	-rwxr-xr-x
create-stud_login.php	4.09 KB	-rwxr-xr-x
create-user.php	4.17 KB	-rwxr-xr-x
documentverification.php	4.91 KB	-rwxr-xr-x
dudseatallot.php	4.11 KB	-rw-rw-r--
meritlist.php	3.22 KB	-rwxr-xr-x
report_merit_list.php	6.82 KB	-rwxr-xr-x
report_rcub_merit_list.php	12.77 KB	-rwxr-xr-x
reportadm_admission_ticket.php	13.73 KB	-rwxr-xr-x
rostertable.php	490 B	-rwxr-xr-x
saveApplication.php	19.01 KB	-rwxr-xr-x
seatmatrix.php	8.53 KB	-rwxr-xr-x
signin.php	849 B	-rwxr-xr-x

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