Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
output	[ DIR ]	drwxr-xr-x
AttDateWiseReportexcel.php	4.39 KB	-rw-r--r--
Attdet.php	7.1 KB	-rw-rw-r--
AttdetPdf.php	8.74 KB	-rw-rw-r--
AttdetPdfUniclare.php	7.49 KB	-rw-rw-r--
AttdetexcelUniclare.php	5.48 KB	-rw-rw-r--
CIEAttendanceNotEligiblepdf.ph...	6.83 KB	-rw-rw-r--
CIEpendingListpdf.php	9.05 KB	-rw-rw-r--
DegreeWiseStudLstUSN.php	7.69 KB	-rw-rw-r--
DownloadExamAppFormApplication...	10.92 KB	-rwxr-xr-x
DownloadRvRtAckApplications.ph...	4.6 KB	-rwxr-xr-x
Generatecollegeiamarkspendingr...	7.49 KB	-rwxrwxrwx
PrintChallanEntryDetails.php	8.27 KB	-rwxr-xr-x
RVApplicationsReport.php	8.9 KB	-rwxr-xr-x
RvPcListDetailedReport.php	12.51 KB	-rwxrwxrwx
RvRtApplicationReport.php	8.86 KB	-rwxr-xr-x
absentAndMalReportPdf.php	11.5 KB	-rw-rw-r--
absentandmalpracticereport.php	10.16 KB	-rw-rw-r--
ack_exam_app_form_bulk.php	11.76 KB	-rwxr-xr-x
admlist.php	13.87 KB	-rwxrwxrwx
admregisterlist.php	7.39 KB	-rwxr-xr-x
affliation_detailed_report.php	12.56 KB	-rwxrwxrwx
appear_list_center_qp_wise.php	13.07 KB	-rwxr-xr-x
appear_list_qp_wise.php	6.32 KB	-rwxr-xr-x
appfeedetails.php	7.67 KB	-rwxr-xr-x
approval_report.php	19.63 KB	-rwxr-xr-x
attCisshortList.php	15.61 KB	-rw-r--r--
attCisshortList_sjbit.php	12.82 KB	-rw-r--r--
attDegwiseReport.php	14.2 KB	-rw-r--r--
attendanceReportForm.php	5.69 KB	-rw-rw-r--
attendanceform_pdf.php	12.35 KB	-rw-r--r--
attiacombined.php	9.52 KB	-rw-r--r--
attiacombinedReportnewexcel_sj...	12.94 KB	-rw-rw-r--
attiacombinednew.php	12.66 KB	-rw-r--r--
attiacombinednew_1.php	12.34 KB	-rw-r--r--
attiacombinednew_2.php	12.33 KB	-rw-r--r--
attiacombinednew_sjbit.php	8.7 KB	-rw-r--r--
attshortlist.php	10.72 KB	-rw-r--r--
basic_data_coll.php	6.79 KB	-rwxr-xr-x
basic_data_sum.php	6.98 KB	-rwxr-xr-x
batch_wise_details.php	4.45 KB	-rwxr-xr-x
board.php	3.86 KB	-rw-rw-r--
bundle_ack.php	13.58 KB	-rwxr-xr-x
candidatelist.php	10 KB	-rw-rw-r--
categorywisereport.php	13.27 KB	-rwxr-xr-x
categorywisereportpdf.php	7.57 KB	-rw-rw-r--
cntrtagcollstud.php	4.99 KB	-rw-rw-r--
code39.php	6.38 KB	-rwxr-xr-x
college_pending_markslist.php	6.78 KB	-rwxrwxrwx
college_pending_markslist19032...	6.48 KB	-rwxr-xr-x
convoreport.php	5.56 KB	-rw-rw-r--
copomarksexternalreportexcel.p...	7.02 KB	-rw-rw-r--
daterange.php	6.27 KB	-rw-rw-r--
degreeDetailsReport.php	7 KB	-rw-rw-r--
degreewiseMarksEntryStats.php	8.44 KB	-rw-rw-r--
elememntWiseReport.php	16.11 KB	-rw-rw-r--
empty_report_admission_det.php	8.91 KB	-rw-rw-r--
enterCOPOmarks.php	2.94 KB	-rw-rw-r--
exam_attendance_det.php	8.61 KB	-rwxr-xr-x
exam_attendance_summary.php	9.78 KB	-rwxr-xr-x
excelreport.php	27.36 KB	-rw-rw-r--
fpdf.php	147.08 KB	-rw-rw-r--
generate.php	7.32 KB	-rw-rw-r--
generateCorseRep.php	7.93 KB	-rw-r--r--
generateDaliyReportQpNitteExce...	16.34 KB	-rw-rw-r--
generatePostAdmissionTicket.ph...	51.8 KB	-rwxr-xr-x
generatePostAdmissionTicketJss...	58.53 KB	-rwxr-xr-x
generatePostAdmissionTicket_25...	47.13 KB	-rwxr-xr-x
generatePostAdmissionTicket_ol...	37.45 KB	-rwxr-xr-x
generatePrintIaMarks.php	16.19 KB	-rw-rw-r--
generatePrintIaMarksnew.php	16.28 KB	-rw-r--r--
generatePrintIaMarksnewXl.php	13.22 KB	-rw-rw-r--
generateQuestionWiseIAReportPD...	18.73 KB	-rw-rw-r--
generateThValReport.php	7.4 KB	-rw-r--r--
generateXlGraph.php	3.87 KB	-rw-rw-r--
generateadmissionreg.php	11.81 KB	-rw-r--r--
generatecoporeport_xl.php	21.08 KB	-rw-rw-r--
gerderwiseresultsheet.php	12.08 KB	-rwxr-xr-x
getDegree.php	2.27 KB	-rw-rw-r--
getDegreeAndSem.php	4.32 KB	-rw-r--r--
getIaSubjWiseReport.php	0 B	-rw-rw-r--
getNitteAdmXlreport.php	14.74 KB	-rw-rw-r--
getReportClassStud.php	6.03 KB	-rw-rw-r--
getTestTotalMarksReport.php	9.49 KB	-rw-rw-r--
getiaabsentreport.php	6.8 KB	-rw-r--r--
gradewisesubjectanalysisreport...	24.66 KB	-rw-r--r--
gradewisesubjectanalysisreport...	20.73 KB	-rw-r--r--
headerNfooter.php	4.89 KB	-rw-rw-r--
iaDegwiseIAReport.php	12.58 KB	-rw-rw-r--
iaMarksQnWiseReportExcel.php	25.41 KB	-rw-rw-r--
iaMarksReportPDF.php	10.84 KB	-rw-r--r--
iaSubjectWiseReport.php	10.74 KB	-rw-rw-r--
ia_room_allotment_datewise.php	9.08 KB	-rwxr-xr-x
iaemptyformat.php	9.63 KB	-rwxr-xr-x
iaroomallotmantsummary.php	5.28 KB	-rwxr-xr-x
iasectionwisenew.php	36.02 KB	-rw-rw-r--
invig_report.php	10.18 KB	-rw-rw-r--
invig_report_summary.php	7.74 KB	-rw-rw-r--
latEntryRprt.php	6.4 KB	-rwxr-xr-x
markListReportPdf.php	21.32 KB	-rw-rw-r--
markListReportPdfnew.php	49.6 KB	-rw-r--r--
markListReportPdfnew_24112023....	42.93 KB	-rw-r--r--
marksEntryQnWiseNewReport.php	13.13 KB	-rw-rw-r--
marksentryquestionwise.php	23.83 KB	-rw-rw-r--
mregistry.php	152.75 KB	-rw-rw-r--
pdfacknowledgeAppNo.php	10.95 KB	-rw-rw-r--
pendingcie.php	0 B	-rw-rw-r--
photo_report.php	7.04 KB	-rw-rw-r--
pi_test.php	3.45 KB	-rw-r--r--
picharttesting.php	24.78 KB	-rw-rw-r--
prbillreports.php	16.32 KB	-rw-rw-r--
principalFreeze_report.php	7.23 KB	-rw-rw-r--
printIaMarks.php	12.74 KB	-rw-r--r--
printIaMarks_old.php	12.74 KB	-rw-rw-r--
printMarkListDetailsWisenew.ph...	10.1 KB	-rw-r--r--
printMarkListDetailsWisenewExc...	15.52 KB	-rw-rw-r--
printMarkListDetailsWisenew_CI...	3.98 KB	-rw-r--r--
printMarkListDetailsWisenew_sj...	15.69 KB	-rw-r--r--
printMarkListDetailsWisenew_sj...	14.54 KB	-rw-r--r--
printMarkListSubWiseJssstu.php	28.4 KB	-rw-rw-r--
print_applications_ru.php	26.59 KB	-rw-rw-r--
progDegwiseReportPdf.php	14.15 KB	-rw-rw-r--
provisionExcelReportSrun.php	12.73 KB	-rw-rw-r--
qp_issue.php	8.47 KB	-rwxr-xr-x
qrcodeGeneratePostAdmissionTic...	56.9 KB	-rwxr-xr-x
qrcodeGeneratePostAdmissionTic...	33.16 KB	-rwxr-xr-x
qrhallticket.php	56.1 KB	-rw-rw-r--
r	9.23 KB	-rwxr-xr-x
regNoAllot.php	35.56 KB	-rw-rw-r--
reg_stud_list.php	8.65 KB	-rwxr-xr-x
reportAttClassCreate.php	5.14 KB	-rw-rw-r--
reportAttCount.php	12.89 KB	-rw-r--r--
reportAttCount_old_08112022.ph...	11.11 KB	-rw-r--r--
report_Xl_getpendingstudentLis...	7.93 KB	-rw-rw-r--
report_adm_lat_studwise.php	10.13 KB	-rwxr-xr-x
report_admission_details.php	26.8 KB	-rwxr-xr-x
report_admission_list.php	49.63 KB	-rwxr-xr-x
report_admission_list_bf_gcg.p...	26.39 KB	-rwxr-xr-x
report_admission_list_kswu.php	15.12 KB	-rwxr-xr-x
report_admission_list_rur.php	28 KB	-rw-rw-r--
report_admission_list_wop.php	10.31 KB	-rwxr-xr-x
report_admission_ticket.php	77.87 KB	-rw-rw-r--
report_admission_ticket_bf_uuc...	37.63 KB	-rwxr-xr-x
report_admission_ticket_jsstu....	70.16 KB	-rw-r--r--
report_admission_ticket_new.ph...	65.79 KB	-rw-rw-r--
report_attendance_sheet.php	23.77 KB	-rwxr-xr-x
report_attendance_shortage.php	9.23 KB	-rw-rw-r--
report_attendance_summary.php	11.48 KB	-rwxr-xr-x
report_attendance_summary_old....	7.19 KB	-rwxr-xr-x
report_bacth_preparation_dairy...	7 KB	-rwxr-xr-x
report_batch_practical_dairy.p...	15.35 KB	-rwxr-xr-x
report_batch_wise_details.php	8.86 KB	-rwxr-xr-x
report_batch_worksheet_details...	20.02 KB	-rwxr-xr-x
report_bulk_applications.php	26.15 KB	-rwxr-xr-x
report_bulk_applications_nitte...	26 KB	-rw-rw-r--
report_bundle_dispatch.php	15.36 KB	-rwxr-xr-x
report_candidate_list.php	31.41 KB	-rwxr-xr-x
report_candidate_list_old.php	29.91 KB	-rwxr-xr-x
report_copoMarksList.php	23.88 KB	-rw-rw-r--
report_daliy_report.php	10.47 KB	-rwxr-xr-x
report_daliy_report_qp.php	10.21 KB	-rwxr-xr-x
report_daliy_report_qp_nitte.p...	20.31 KB	-rwxr-xr-x
report_daliy_report_qp_sjbit.p...	17.49 KB	-rwxr-xr-x
report_data_sent.php	8.41 KB	-rwxr-xr-x
report_degree_list.php	4.71 KB	-rwxr-xr-x
report_deviation_report.php	7.67 KB	-rwxr-xr-x
report_evaluation_report.php	9.31 KB	-rwxr-xr-x
report_ia_ra_invigilator_dairy...	20.87 KB	-rwxr-xr-x
report_ia_ra_roomwise_register...	27.06 KB	-rw-r--r--
report_iamarks_pending.php	8.19 KB	-rwxr-xr-x
report_invigilatorDairy.php	46.77 KB	-rw-rw-r--
report_marks_deviation_report....	5.38 KB	-rwxr-xr-x
report_marks_elementwise.php	3.13 KB	-rwxr-xr-x
report_marks_entry_student_lis...	6.55 KB	-rwxr-xr-x
report_marks_entry_subwise_lis...	21.94 KB	-rwxr-xr-x
report_marks_entry_subwise_lis...	10.43 KB	-rwxr-xr-x
report_marks_pending.php	12.02 KB	-rwxr-xr-x
report_online_eam.php	11.59 KB	-rwxr-xr-x
report_practical_marks_details...	13.35 KB	-rwxr-xr-x
report_practical_marks_details...	23.65 KB	-rwxr-xr-x
report_practical_marks_details...	13.33 KB	-rwxr-xr-x
report_practical_marks_details...	13.32 KB	-rwxr-xr-x
report_practical_misc.php	8.24 KB	-rwxr-xr-x
report_qpcount_univ.php	5.17 KB	-rwxr-xr-x
report_ra_exl_report.php	6.89 KB	-rwxr-xr-x
report_ra_invigilator_dairy.ph...	46.94 KB	-rwxr-xr-x
report_ra_invigilator_dairy_bf...	22.69 KB	-rwxr-xr-x
report_ra_invigilator_dairy_gu...	19.86 KB	-rwxr-xr-x
report_ra_invigilator_dairy_ne...	49.39 KB	-rwxr-xr-x
report_ra_invigilator_dairy_sj...	32.35 KB	-rwxr-xr-x
report_ra_invigilator_dairy_st...	19.82 KB	-rw-rw-r--
report_ra_invigilators_dairy.p...	9.27 KB	-rwxr-xr-x
report_ra_qp_wise_student_coun...	10.97 KB	-rwxr-xr-x
report_ra_qp_wise_student_coun...	8.74 KB	-rwxr-xr-x
report_ra_qp_wise_student_coun...	11.21 KB	-rwxr-xr-x
report_ra_roomwise_register_no...	10.67 KB	-rwxr-xr-x
report_ra_roomwise_register_no...	26.44 KB	-rwxr-xr-x
report_ra_roomwise_register_no...	27.15 KB	-rwxr-xr-x
report_ra_roomwise_register_no...	17.6 KB	-rwxr-xr-x
report_reg_list.php	33.33 KB	-rw-rw-r--
report_reg_list_gcg.php	33.55 KB	-rw-rw-r--
report_reg_list_gcg_new_040120...	33.12 KB	-rw-rw-r--
report_registerNoListNoticeBoa...	25.84 KB	-rw-rw-r--
report_registerNoListRoomBoard...	22.08 KB	-rw-rw-r--
report_revaluation.php	6.42 KB	-rwxr-xr-x
report_roomallotmentExcel.php	8.31 KB	-rw-rw-r--
report_subject_admcl_list.php	3.68 KB	-rwxr-xr-x
report_subject_general_list.ph...	4.89 KB	-rwxr-xr-x
resultsheet.php	12.82 KB	-rwxr-xr-x
resultsheetExcel.php	6.37 KB	-rw-r--r--
resultsheet_x.php	9.15 KB	-rwxr-xr-x
resultsheetsubwise.php	11.24 KB	-rwxr-xr-x
revaluation.php	15.65 KB	-rwxr-xr-x
roomAllotment.php	37.45 KB	-rw-rw-r--
room_allotment_datewise_stph.p...	21.46 KB	-rwxr-xr-x
roomallotmantsummary.php	6.66 KB	-rwxr-xr-x
roomallotmantsummarynew.php	7.09 KB	-rwxr-xr-x
roomallotmantsummarysubjwise.p...	9.26 KB	-rw-rw-r--
roomallotmantsummarysubjwisene...	9.89 KB	-rw-r--r--
roomallotmentqpwise.php	10.22 KB	-rw-rw-r--
roomwise_register_nos_list.php	27.87 KB	-rwxr-xr-x
roomwise_register_nos_list_new...	29.38 KB	-rwxr-xr-x
rotation.php	596 B	-rwxr-xr-x
semesterWiseResultReportpdf.ph...	11.03 KB	-rw-rw-r--
shortageReport.php	11.05 KB	-rw-rw-r--
std_regstr_det_reprt_xl.php	7.6 KB	-rw-rw-r--
stringspliter.php	718 B	-rwxr-xr-x
stud_wise_report.php	8.97 KB	-rw-rw-r--
studentHisResult.php	8.34 KB	-rw-r--r--
student_count.php	4.16 KB	-rwxr-xr-x
studentwiseresult.php	18.02 KB	-rw-rw-r--
studentwiseresultExcelReport.p...	10.29 KB	-rw-rw-r--
subWiseFailedStudExcelReport.p...	9.02 KB	-rw-rw-r--
subWiseFailedStudSummary.php	7.78 KB	-rw-rw-r--
subjRegReport.php	8.42 KB	-rw-r--r--
subjectDetailsReport.php	13.93 KB	-rw-rw-r--
subject_wise_student_list.php	6.2 KB	-rwxr-xr-x
subjwisepasspercentage.php	10.99 KB	-rw-rw-r--
subjwisepasspercentagePie.php	10.92 KB	-rw-r--r--
subjwiseressheet.php	12.92 KB	-rwxr-xr-x
subwiseGrafAnalysis.php	20.04 KB	-rw-r--r--
subwiseGrafAnalysis1.php	22.44 KB	-rw-r--r--
subwiseResultReport.php	12.75 KB	-rw-rw-r--
tatkal.php	4.84 KB	-rwxr-xr-x
teachFreeze_report.php	8.96 KB	-rw-r--r--
teacher_report.php	11.26 KB	-rwxr-xr-x
teacher_val_report.php	10.59 KB	-rwxr-xr-x
timetabledegreewiserpt.php	6.73 KB	-rwxrwxrwx
topsheet.php	8.59 KB	-rwxr-xr-x
verifystud.php	8.38 KB	-rwxr-xr-x
viewexamcentrenew.php	20.7 KB	-rw-rw-r--
xl_AckAppReport.php	10.02 KB	-rw-rw-r--

Code Editor : getNitteAdmXlreport.php

<?php

function getNitteAdmXlreport($aobj_context)
{
	session_start();
	$collcode=$_SESSION['collcode'];
	
	ini_set('memory_limit','300M');
	ini_set('max_execution_time',3300);
	
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$filename = 'admission_list.csv';
	$f = fopen('php://output', 'w'); 
	
	$degree = trim($aobj_context->mobj_data["degree"]);
	$colfrom = trim($aobj_context->mobj_data["colfrom"]);
	$colto = trim($aobj_context->mobj_data["colto"]);
	$db = trim($aobj_context->mobj_data["db"]);
	$college_code = $_SESSION['collcode'];

$get_studentInfo = "select c.FUNIVCODE from student s, control c 
	where s.fcollcode = '{$college_code}' and s.fdegree ='{$degree}'";

$sessionUnivcode = $_SESSION['FUNIVCODE'];
	
	// var_dump($_SESSION['FUNIVCODE']);
	// die();
	$lobj_get_studentInfo = $aobj_context->mobj_db->getRow($get_studentInfo);
	
	$funicode = $lobj_get_studentInfo['FUNIVCODE'];

if($db =='srun'){
		$cnd = "fcurradd1 as fcommadd1, fcurradd2 as fcommadd2,fpevmonth,feligiblityfee,frecpno,frecpno,frecpdate,
		fscholership,fdocument,fregfee,fregrecpno,fregrecpdate,FSSCPERC,fblood_group,";
	}else{
		$cnd = "fcommadd1, fcommadd2,";	
	}
 $query = "select s.fappno, s.fadmyear, s.fslno, s.fdegree, s.fexamno, s.fcollcode, s.fname, ffatname, fmotname, fgender,
			fdob, fnationality, freligion, fadmdate, fcaste, fcatecode, faadharno, ffatocc, ffatincome, fmotocc,
			fmotincome, fmottong, ftudystate, fmotmob, fmotemail, ffatmob, ffatemail,
			ifnull(fcommstate,'') as fcommstate, 
			ifnull(fperdist,'') as fperdist,
			ifnull(s.fseattype, '')as fseattype, s.frollno,
			{$cnd} fcommtaluk,
			a.subdet as subdets,
			ifnull(fnucatno,'') as fnucatno,
			ifnull(fstudmob,'') as fstudmob,
			ifnull(fstudemail,'') as fstudemail,
			ifnull(fnucatrank,'') as fnucatrank,
			a.puper,
			a.pcmper,
			fcommpin, fcommdist, fperadd1, fperadd2, fpertaluk, fperpin, fperstate, fqual, fqregno, fqcollname, fareatype, 
			fboard, fboardstate, fqyear,if(ifnull(fapprstatus,'') = 'APPROVED',faregno,'') as faregno,fphotopath
			from studadm s
			left join (select sd.fcollcode,sd.fappno,sd.fdegree,
			sum(if(ab.fsubname = 'PU Total',sd.fpercent,0)) as puper,
			round(sum(if((ab.fsubname = 'Chemistry' || ab.fsubname = 'Physics' || ab.fsubname = 'Mathematics'),sd.fsecmarks,0)) / sum(if((ab.fsubname = 'Chemistry' || ab.fsubname = 'Physics' || ab.fsubname = 'Mathematics'),sd.fmaxmarks,0))*100,2) as pcmper,
			group_concat('Sub. Name: ',ab.fsubname,' Max. Marks: ',sd.fmaxmarks,
			' Sec. Marks: ',sd.fsecmarks,
			' Percent: ',sd.fpercent,' '
			 order by ab.forder SEPARATOR ' ') as subdet
			From studprevsub sd 
			inner join admprevsub ab on ab.fdegree = sd.fdegree
			and sd.fsubcode = ab.fsubcode
			where sd.fcollcode = '{$collcode}' and sd.fdegree = '{$degree}'
			group by sd.fappno) a on s.fcollcode = a.fcollcode 
			and s.fdegree = a.fdegree and s.fappno = a.fappno
			where s.fcollcode = '{$collcode}' and s.fdegree='{$degree}'
			and ifnull(s.fdeleted,'') <> 'T'
			order by ifnull(s.faregno,''),s.fname";
			
	$lobj_get_data = $aobj_context->mobj_db->GetAll($query);
	
	$arrW =0;
	$subjRow ='';
		
	if(!empty($lobj_get_data))
	{
		$e_data.="<table cellspacing='0' cellpadding='1' border='1' width = ''>";
		$e_data.="<tr style='height: 25px;'>";
		$e_data.="<td style = 'text-align:center;font-weight: bold;row-height:40px;' >Sl. No.</td>";
		$e_data.="<td style = 'text-align:center;font-weight: bold;row-height:40px;' >Application No.</td>";
		
		if($univcode != '051'){
			$admCnd = "Adm. Year";
		}else{
			$admCnd = "Roll No.";
		}

$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;'>{$admCnd}</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Adm. Date</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Degree</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;'>Exam No</td>"; 
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;'>College Code</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Name</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Father Name</td>";	
 $e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Mother Name</td>";	
 $e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Gender</td>";	
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Date of Birth</td>";	
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Nationality</td>";	
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Religion</td>";
		
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Caste</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Cat. Code</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Adhaar</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Seat Type</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Father Occupation</td>";
		if($db != 'srun'){
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >F. Incode</td>";
		}
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Mother Occupation</td>";	
		if($db != 'srun'){
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Mother Income</td>";
		}
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Mother Tongue</td>";
		// $e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >State</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >M. Mobile</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >M. Email</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >F. Mobile</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >F. Email</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >S. Mobile</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >S. Email</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Address</td>";	
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Permanent Address</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Qualification</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Q. Reg. No.</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >College Name</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Area Type</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Board</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >State</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Year</td>";
		
		if($db != 'srun'){
			$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Subjects</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >PCM Percentage</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >PU Percentage</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >NUCAT No</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >NUCAT Rank</td>";
		$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Reg. No.</td>";
		}
		
		if($db == 'srun'){
			$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Previous Percentage</td>";
			$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Eligiblity Fee</td>";
			$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Registration Fee</td>";
			$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Receipt No(Registration Fee)</td>";
			$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Receipt Date(Registration Fee)</td>";
			$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Receipt No</td>";
			$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Receipt Date</td>";
			$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Scholership / Non-Scholership</td>";
			$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Document Submited</td>";
			$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:80px;' >Student Photo</td>";
			$e_data.="<td style = 'text-align:center;font-weight:bold;row-height:40px;' >Blood Group</td>";		
		}
		$e_data.="</tr>";							
		$k=0;
		$id=0;
		$m=0;
		$filename = 'Admission_List';
		$a = 1;
		
		foreach($lobj_get_data as $key=>$value)
		{
			$imageWidth = '40px';
			$imageHeight = '40px';

// var_dump($funicode);
			// die();
			$photo_path = $value['fphotopath'];
			$curl3 = curl_init();

if($funicode === NULL){
				$univcode = $sessionUnivcode;
			}else{
				$univcode = $funicode;
			}
			$photo_url = 'https://university-student-photos.s3.ap-south-1.amazonaws.com'.'/'.$univcode.'/'.$photo_path;
			// var_dump($photo_url);
			// die();
			curl_setopt($curl3, CURLOPT_URL, $photo_url);
			curl_setopt($curl3, CURLOPT_NOBODY, true);
			$response_photo = curl_exec($curl3);
			$httpCode_photo = curl_getinfo($curl3 , CURLINFO_HTTP_CODE);

if(!empty($photo_path)) 
			{			
				$image_src = $photo_url;
			}else{
				$image_src = 'images/default_photo.jpg';
			}
			
			if($k%2==0)
			{
				$class='tbl_row';
				$inp_class='tbl_row_input';
			}
			else
			{
				$input_class='tbl_row1'; 
				$inp_class='tbl_row1_input';
			} 
			
			$caddress = $value['fcommadd1'].' '.$value['fcommadd2'].' Taluk : '.$value['fcommtaluk'].' Pincode : '.$value['fcommpin'].' District : '.$value['fcommdist'].' State : '.$value['fcommstate']; 
			$paddress = $value['fperadd1'].' '.$value['fperadd2'].' Taluk : '.$value['fpertaluk'].' Pincode : '.$value['fperpin'].' District : '.$value['fperdist'].' State : '.$value['fperstate']; 
			
			$e_data.="<tr style='height: 25px;'>";	
			// $e_data.="<td style = 'vertical-align:middle;' >{$counter_degree}</td>";			
			$e_data.="<td style = 'text-align:center;' >{$a}</td>";
			$e_data.="<td style = 'text-align:center;' >{$value['fappno']}</td>";
			if($univcode != '051'){
				$admYearCnd = $value['fadmyear'];
			}else{
				$admYearCnd = $value['frollno'];
			}
			$e_data.="<td style = 'text-align:center;' >{$admYearCnd}</td>";
			$e_data.="<td style = 'text-align:center;' >{$value['fadmdate']}</td>";
			$e_data.="<td>{$value['fdegree']}</td>"; 
			$e_data.="<td style = 'text-align:center;' >{$value['fexamno']}</td>";
			$e_data.="<td style = 'text-align:center;' >{$value['fcollcode']}</td>";	
 $e_data.="<td>{$value['fname']}</td>";
 $e_data.="<td>{$value['ffatname']}</td>";
			$e_data.="<td>{$value['fmotname']}</td>";
			$e_data.="<td style = 'text-align:center;' >{$value['fgender']}</td>";
			$e_data.="<td style = 'text-align:center;' >{$value['fdob']}</td>";
			$e_data.="<td style = 'text-align:center;' >{$value['fnationality']}</td>";
			$e_data.="<td style = 'text-align:center;' >{$value['freligion']}</td>";
			
 $e_data.="<td style = 'text-align:center;' >{$value['fcaste']}</td>";
			$e_data.="<td style = 'text-align:center;' >{$value['fcatecode']}</td>";
			$e_data.="<td style = 'text-align:center;' >'{$value['faadharno']}</td>";
			$e_data.="<td style = 'text-align:center;' >{$value['fseattype']}</td>";
			$e_data.="<td>{$value['ffatocc']}</td>";
			if($db != 'srun'){
			$e_data.="<td style = 'text-align:center;' >{$value['ffatincome']}</td>";
			}
			$e_data.="<td>{$value['fmotocc']}</td>";
			if($db != 'srun'){
			$e_data.="<td style = 'text-align:center;' >{$value['fmotincome']}</td>";
			}
			$e_data.="<td style = 'text-align:center;' >{$value['fmottong']}</td>";
			// $e_data.="<td style = 'text-align:center;' >{$value['ftudystate']}</td>";
			$e_data.="<td style = 'text-align:center;' >{$value['fmotmob']}</td>";
			$e_data.="<td>{$value['fmotemail']}</td>";
			$e_data.="<td style = 'text-align:center;' >{$value['ffatmob']}</td>";
			$e_data.="<td>{$value['ffatemail']}</td>";

$e_data.="<td style = 'text-align:center;' >{$value['fstudmob']}</td>";
			$e_data.="<td>{$value['fstudemail']}</td>";

$e_data.="<td>{$caddress}</td>";
			$e_data.="<td>{$paddress}</td>";
			$e_data.="<td style = 'text-align:center;' >{$value['fqual']}</td>";
			$e_data.="<td style = 'text-align:center;' >{$value['fqregno']}</td>";
			$e_data.="<td>{$value['fqcollname']}</td>";
			$e_data.="<td style = 'text-align:center;' >{$value['fareatype']}</td>";
			$e_data.="<td>{$value['fboard']}</td>";
			$e_data.="<td>{$value['fboardstate']}</td>";
			if($db == 'srun'){
				$e_data.="<td style = 'text-align:center;' >{$value['fqyear']}-{$value['fpevmonth']}</td>";
			}else{
				$e_data.="<td style = 'text-align:center;' >{$value['fqyear']}</td>";
			}
			
			if($db != 'srun'){
				$e_data.="<td >{$value['subdets']}</td>";
			$e_data.="<td >{$value['pcmper']}</td>";
			$e_data.="<td >{$value['puper']}</td>";
			$e_data.="<td >{$value['fnucatno']}</td>";
			$e_data.="<td style = 'text-align:center;'>{$value['fnucatrank']}</td>";
			$e_data.="<td style = 'text-align:center;' >{$value['faregno']}</td>";
			}
			
			if($db == 'srun'){
				$e_data.="<td style = 'text-align:center;' >{$value['FSSCPERC']}</td>";
				$e_data.="<td style = 'text-align:center;' >{$value['feligiblityfee']}</td>";
				$e_data.="<td style = 'text-align:center;' >{$value['fregfee']}</td>";
				$e_data.="<td style = 'text-align:center;' >{$value['fregrecpno']}</td>";
				$e_data.="<td style = 'text-align:center;' >{$value['fregrecpdate']}</td>";
				$e_data.="<td style = 'text-align:center;' >{$value['frecpno']}</td>";
				$e_data.="<td style = 'text-align:center;' >{$value['frecpdate']}</td>";
				$e_data.="<td style = 'text-align:center;' >{$value['fscholership']}</td>";
				$e_data.="<td style = 'text-align:center;' >{$value['fdocument']}</td>";
				$e_data.="<td style = 'text-align:center;'><img src='{$image_src}' width='70' height ='70' /></td>";
				$e_data.="<td style = 'text-align:center;' >{$value['fblood_group']}</td>";
			}
			
			$e_data.="</tr>";
			$k++;
			$id++;
			$a++;
			$m++;
			// $counter_degree++;
		}
		
		$e_data.="</table>";
		$arr['total_count']= $m;						
		$arr['html']=$e_data;
		$arr['error']=0;
	}
	else
	{
		$arr['html'] = ' No record found ';
	}

header("Content-Type:application/xls");
	header("Content-Disposition: attachment; filename={$filename}.xls"); 
	echo $e_data;
	
}

${this.title}

Code Editor : getNitteAdmXlreport.php