Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
.pkexec	[ DIR ]	drwxr-xr-x
GCONV_PATH=.	[ DIR ]	drwxr-xr-x
custom	[ DIR ]	drwxrwxrwx
AdmApprovalRpt.php	8.81 KB	-rwxrwxrwx
AdmFee_Course_Coll_Cast_Hd.php	10.83 KB	-rwxrwxrwx
AdmFee_Course_Coll_Cast_HdEx.p...	11.33 KB	-rwxrwxrwx
AdmSumCourseColl.php	10.21 KB	-rwxrwxrwx
AdmisionDegReport.php	8.61 KB	-rwxrwxrwx
AdmissionReport.php	10.89 KB	-rwxrwxrwx
AuthoLetterReport.php	10.89 KB	-rwxrwxrwx
Centerwise_Collegewise_Student...	13.69 KB	-rwxrwxrwx
Cntrwiseanswerindent.php	8.05 KB	-rwxrwxrwx
CollCateGenWiseReport_excel.ph...	9.58 KB	-rwxrwxrwx
CollCateGenWiseSumryReport.php	13.15 KB	-rwxrwxrwx
CollCateGenWiseSumryReport_vsk...	13.1 KB	-rwxrwxrwx
CollwiseMalPracticeReport.php	9 KB	-rwxrwxrwx
DYPIndent.php	6.77 KB	-rwxrwxrwx
EGOV_generateBillReport.php	24.03 KB	-rwxrwxrwx
ExamAppSumCourseWiseExcel.php	10.55 KB	-rwxrwxrwx
ExamApplicationSummaryCoursewi...	11.31 KB	-rwxrwxrwx
ExamFeeDetails.php	15.42 KB	-rwxrwxrwx
ExamFeeDetailsExcel.php	14.41 KB	-rwxrwxrwx
ExamRegistrationRprt.php	12.47 KB	-rwxrwxrwx
ExmRegstDetReport.php	12.22 KB	-rwxrwxrwx
GenerateMCQKeyAns.php	5.88 KB	-rwxrwxrwx
Generatecollegeiamarkspendingr...	6.75 KB	-rwxrwxrwx
IAPendingRegNoWise.php	10.41 KB	-rwxrwxrwx
IAPendingRegWiseExcel.php	13.34 KB	-rwxrwxrwx
IAPendingRegWiseExcel_IA_tes.p...	11.63 KB	-rwxrwxrwx
LogReport.php	9.85 KB	-rwxrwxrwx
MPEXCEL.php	7.39 KB	-rwxrwxrwx
MasboardReport.php	5.67 KB	-rwxrwxrwx
MasboardReportPDF.php	6.77 KB	-rwxrwxrwx
PC_RV_Report.php	7.19 KB	-rwxrwxrwx
PRPENDING_REG_NO_WISE_Excel.ph...	10.59 KB	-rwxrwxrwx
PRPENDING_REG_NO_WISE_Excel_ol...	11.3 KB	-rwxrwxrwx
PRPendingDetailed_Report.php	9.38 KB	-rwxrwxrwx
PRPendingDetailed_excelnew.php	10.89 KB	-rwxrwxrwx
PracticalIndent.php	5.79 KB	-rwxrwxrwx
QPINDENT_SRN_WISE.php	7.02 KB	-rwxrwxrwx
QPINDENT_SRN_WISE_old.php	7.02 KB	-rwxrwxrwx
QpSummaryReport.php	14.87 KB	-rwxrwxrwx
QpcodewiseMalPracticeReport.ph...	9.22 KB	-rwxrwxrwx
RVRTFeeSummary.php	12.61 KB	-rwxrwxrwx
RV_RT_PC_Sum.php	10.64 KB	-rwxrwxrwx
RV_RT_PC_Sum_1.php	10.3 KB	-rwxrwxrwx
RV_RT_PC_Sum_2.php	10.27 KB	-rwxrwxrwx
ResultStatsCategoryWise.php	37.55 KB	-rwxrwxrwx
ResultStatsCollegeWise.php	13.2 KB	-rwxrwxrwx
ResultStatsDegreeWise.php	12.65 KB	-rwxrwxrwx
ResultStatsGenderWise.php	13.29 KB	-rwxrwxrwx
RvPcCheckList.php	8.29 KB	-rwxrwxrwx
RvPcListReport.php	12.37 KB	-rwxrwxrwx
RvPcListSummReport.php	11.88 KB	-rwxrwxrwx
RvRtFeeReportPDF.php	11.63 KB	-rwxrwxrwx
Template.php	9.99 KB	-rwxrwxrwx
Template_EXCEL.php	8.11 KB	-rwxrwxrwx
Template_PFD.php	7.07 KB	-rwxrwxrwx
UUCMSReport.php	5.32 KB	-rwxrwxrwx
ViewExamCentreNewReportexcel.p...	12.64 KB	-rwxrwxrwx
admReportDet.php	11.92 KB	-rwxrwxrwx
admapprovereport.php	10.17 KB	-rwxrwxrwx
admapprovereport_detailedexcel...	15.04 KB	-rwxrwxrwx
admapprovereport_summaryexcel....	11.49 KB	-rwxrwxrwx
admissionFeesummary.php	8.45 KB	-rwxrwxrwx
admissioncombinationwiseintake...	11.61 KB	-rwxrwxrwx
admsummmaryexcel.php	11.74 KB	-rwxrwxrwx
admsummmaryreport.php	11.31 KB	-rwxrwxrwx
assignUserMenus_.php	4 KB	-rwxrwxrwx
attendance_block_report.php	7.06 KB	-rwxrwxrwx
attendance_report_det.php	12.98 KB	-rwxrwxrwx
attupd.html	3.46 KB	-rwxrwxrwx
bundledispatch_pdf.php	6.32 KB	-rwxrwxrwx
candidatelist.php	10.53 KB	-rwxrwxrwx
catgoryWiseExamFeeReport.php	13.87 KB	-rwxrwxrwx
centerdegreesemister.php	15.99 KB	-rwxrwxrwx
centerwisedegreewiseqpwise.php	12.54 KB	-rwxrwxrwx
centerwiseqpwisestudentcount.p...	12.48 KB	-rwxrwxrwx
centerwisesemisterwise.php	19.21 KB	-rwxrwxrwx
centerwisestudentcount.php	12.51 KB	-rwxrwxrwx
centrewisedatewise_EXCEL.php	14.04 KB	-rwxrwxrwx
col_deg_sum_report.php	17.24 KB	-rwxrwxrwx
colgwiseDegWiseReport.php	11.18 KB	-rwxrwxrwx
college_reports_xl.php	15.03 KB	-rwxrwxrwx
college_wise_student_count.php	12.08 KB	-rwxrwxrwx
collwisedeglist.php	8.45 KB	-rwxrwxrwx
combwiseStudCunt.php	8.86 KB	-rwxrwxrwx
convodetexl.php	10.16 KB	-rwxrwxrwx
convosummary.php	6.59 KB	-rwxrwxrwx
createboeReport.php	8.41 KB	-rwxrwxrwx
dailyFeeDetReportExcel.php	13.61 KB	-rwxrwxrwx
dailyFeeDetReportPDF.php	12.88 KB	-rwxrwxrwx
dailyvaluationsummary.php	9.17 KB	-rwxrwxrwx
datewWiseValDet.php	8.71 KB	-rwxrwxrwx
decodeMissDet.php	6.12 KB	-rwxrwxrwx
degGrpReport.php	7.4 KB	-rwxrwxrwx
degreeEntryDet.php	10.25 KB	-rwxrwxrwx
degreeGroupReport.php	5.46 KB	-rwxrwxrwx
degreeListDetailed.php	8.92 KB	-rwxrwxrwx
degreeWiseCollegeList.pdf	8.16 KB	-rwxrwxrwx
degreeWiseCollegeList.php	8.83 KB	-rwxrwxrwx
degreeWiseCombinationList.php	6 KB	-rwxrwxrwx
degreeWiseStudentList.php	11.38 KB	-rwxrwxrwx
degreeWiseStudentlist_excel.ph...	9.57 KB	-rwxrwxrwx
degreeWiseSubjectList.php	13.58 KB	-rwxrwxrwx
degree_wise_student_list.php	12.06 KB	-rwxrwxrwx
degreesemister.php	13.44 KB	-rwxrwxrwx
degreewiseqpwise.php	9.96 KB	-rwxrwxrwx
digivalrpt.php	14.73 KB	-rwxrwxrwx
dispmarksreport.php	11.98 KB	-rwxrwxrwx
dispmarksreportclg.php	12.12 KB	-rwxrwxrwx
dispmarksreportdetailed.php	12.17 KB	-rwxrwxrwx
dispmarksreportdetailedclg.php	12.18 KB	-rwxrwxrwx
dispmarksreportsearch.php	11.36 KB	-rwxrwxrwx
dudCovid19Cert.php	6.19 KB	-rwxrwxrwx
duplicatePaymentReport.php	13.71 KB	-rwxrwxrwx
dygeneratebill.php	14.03 KB	-rwxrwxrwx
error_data_ssp.php	22.62 KB	-rwxrwxrwx
exaEeePaidCsv.php	7.68 KB	-rwxrwxrwx
exaEeePaidCsv1.php	7.46 KB	-rwxrwxrwx
examAppFeeDetReport.php	17.82 KB	-rwxrwxrwx
examApplicationFeeSummary.php	14.11 KB	-rwxrwxrwx
examCentrDetCSV.php	6.56 KB	-rwxrwxrwx
examCntrDetQPCSV.php	5.55 KB	-rwxrwxrwx
examTimeTableDegreeWiseExcel.p...	9.67 KB	-rwxrwxrwx
examTimeTableQPWiseExcel.php	8.74 KB	-rwxrwxrwx
exam_tot_student_count_semwise...	14.31 KB	-rwxrwxrwx
examapplicationdegwise.php	8.62 KB	-rwxrwxrwx
exmapp_reg_rep_count.php	11.07 KB	-rwxrwxrwx
exmapp_reg_rep_count_Report.ph...	15.69 KB	-rwxrwxrwx
exmfeedetnewexcel.php	19.38 KB	-rwxrwxrwx
export.php	1.29 KB	-rwxrwxrwx
feeCollection.php	16.96 KB	-rwxrwxrwx
feeReportHeadwise.php	11.18 KB	-rwxrwxrwx
feeReportHeadwisePDF.php	10.63 KB	-rwxrwxrwx
feeReportStudwise.php	12.78 KB	-rwxrwxrwx
feeReportStudwisePDF.php	9.41 KB	-rwxrwxrwx
feepaiddet.php	7.54 KB	-rwxrwxrwx
feepaiddet_1.php	8.52 KB	-rwxrwxrwx
gen_Upload_Report.php	6.73 KB	-rwxrwxrwx
genbonf_EXCEL.php	32.47 KB	-rwxrwxrwx
generateCollegeWiseStudListRep...	14.12 KB	-rwxrwxrwx
generateFeeSummaryReportLink.p...	42.89 KB	-rwxrwxrwx
genrteMailSentReportXL.php	8.64 KB	-rwxrwxrwx
getAbstractForm.php	14.76 KB	-rwxrwxrwx
getIaMarksReport.php	16.86 KB	-rwxrwxrwx
getRvPcDEGSummaryList.php	13.67 KB	-rwxrwxrwx
getStudCourseReport.php	7.47 KB	-rwxrwxrwx
getStudDeletedReport.php	6.5 KB	-rwxrwxrwx
getStudGraduandsReport.php	7.38 KB	-rwxrwxrwx
getStudHistoryReport.php	7.95 KB	-rwxrwxrwx
getStudentRegisteredReport.php	9.1 KB	-rwxrwxrwx
getnumword.php	7.45 KB	-rwxrwxrwx
getrvrtpcsum.php	12.57 KB	-rwxrwxrwx
iaMarksPendingReportStudentwis...	5.45 KB	-rwxrwxrwx
iamarksPendingReportSummary.ph...	6.06 KB	-rwxrwxrwx
iamarkssummry_pdf.php	8.87 KB	-rwxrwxrwx
logreports.php	16.41 KB	-rwxrwxrwx
mainSubjectLevelList.php	11.75 KB	-rwxrwxrwx
mark_list_studwise.php	11.75 KB	-rwxrwxrwx
marks_list_subwise.php	21.63 KB	-rwxrwxrwx
markspushexcel.php	9.1 KB	-rwxrwxrwx
mcfpendingReport.php	8.24 KB	-rwxrwxrwx
multiplePaymetReport.php	13.06 KB	-rwxrwxrwx
omrQpReport.php	30.07 KB	-rwxrwxrwx
omrQpReport_18092024.php	30.05 KB	-rwxrwxrwx
onlineservicereport.php	6.22 KB	-rwxrwxrwx
orderReportExcel.php	7.35 KB	-rwxrwxrwx
pendpaymentrpt.php	5.17 KB	-rwxrwxrwx
pgetFeedetl.php	7.01 KB	-rwxrwxrwx
pgetStatus.php	6.8 KB	-rwxrwxrwx
pgetStudentList.php	7.13 KB	-rwxrwxrwx
pget_invigilator_dairy.php	8.84 KB	-rwxrwxrwx
photoCopyPendingList.php	9.89 KB	-rwxrwxrwx
profile.php	3.58 KB	-rwxrwxrwx
qpWiseSubjectList.php	10.09 KB	-rwxrwxrwx
qpWiseSubjectList_123.php	7.38 KB	-rwxrwxrwx
qpcodewisestudentcount.php	8.59 KB	-rwxrwxrwx
qpm_absent_report.php	7.84 KB	-rwxrwxrwx
qpwiseactivestudcount.php	23.39 KB	-rwxrwxrwx
qpwisestdcountcsv.php	5.57 KB	-rwxrwxrwx
qpwisestdcountcsv_old.php	5.7 KB	-rwxrwxrwx
reconReport.php	9.56 KB	-rwxrwxrwx
reconReportExcel.php	8.5 KB	-rwxrwxrwx
reconReportSummaryExcel.php	8.18 KB	-rwxrwxrwx
refundApplications.php	9.62 KB	-rwxrwxrwx
remunerationReportPdf.php	17.19 KB	-rwxrwxrwx
report.html	232 B	-rwxrwxrwx
report_candidate_list.php	16.09 KB	-rwxrwxrwx
report_degree_list.php	4.81 KB	-rwxrwxrwx
report_merit_list.php	10.62 KB	-rwxrwxrwx
report_merit_list_old.php	10.47 KB	-rwxrwxrwx
report_merit_list_test.php	10.99 KB	-rwxrwxrwx
report_ra_invigilators_dairy.p...	15.09 KB	-rwxrwxrwx
reports.html	9.1 KB	-rwxrwxrwx
reports.js	1.87 KB	-rwxrwxrwx
revaQpindentCsv.php	10.44 KB	-rwxrwxrwx
revaQpindentCsv_old.php	6.89 KB	-rwxrwxrwx
reva_fee_sum.php	24.12 KB	-rwxrwxrwx
roomsummary.php	12.01 KB	-rwxrwxrwx
roomsummaryCollection.php	10.71 KB	-rwxrwxrwx
roomsummarydetail.php	14.16 KB	-rwxrwxrwx
roomwise_register_nos_list.php	8.46 KB	-rwxrwxrwx
rvpcreportpdf.php	15.1 KB	-rwxrwxrwx
screen1.png	70.59 KB	-rwxrwxrwx
ssp_marks_status_report.php	8.04 KB	-rwxrwxrwx
studentWiseReport.php	8.48 KB	-rwxrwxrwx
studwiseCollList.php	8.81 KB	-rwxrwxrwx
studwiseCollListExl.php	10.19 KB	-rwxrwxrwx
sublistexcel.php	9.58 KB	-rwxrwxrwx
sublisting.php	2.22 KB	-rwxrwxrwx
tatkal.php	5.87 KB	-rwxrwxrwx
tdvs_report.php	10.61 KB	-rwxrwxrwx
tdvs_report_board.php	5.83 KB	-rwxrwxrwx
tdvs_report_script.php	6.31 KB	-rwxrwxrwx
teachCsv.php	5 KB	-rwxrwxrwx
teachWorkDone.php	16.75 KB	-rwxrwxrwx
teach_report.php	11.21 KB	-rwxrwxrwx
teacher_report.php	11.56 KB	-rwxrwxrwx
teacher_val_report.php	10.16 KB	-rwxrwxrwx
teachersList.php	15.11 KB	-rwxrwxrwx
testkannda.php	10.36 KB	-rwxrwxrwx
testkannda_pra.php	877 B	-rwxrwxrwx
testrep.html	17.88 KB	-rwxrwxrwx
timeTableClashReport.php	17.66 KB	-rwxrwxrwx
univAdmDeg.php	6.04 KB	-rwxrwxrwx
uploaded_qp_details.php	7.61 KB	-rwxrwxrwx
userTypeList.php	8.09 KB	-rwxrwxrwx
valuationSummaryReport.php	16.18 KB	-rwxrwxrwx
valuationstatsReport.php	15.67 KB	-rwxrwxrwx
valuatorExcelReport.php	8.54 KB	-rwxrwxrwx
valuatorReport.php	10.27 KB	-rwxrwxrwx
verifyappRpt.php	9.4 KB	-rwxrwxrwx

Code Editor : college_reports_xl.php

<?php

$main_src = substr($_SERVER['SCRIPT_FILENAME'], 0, strlen($_SERVER['SCRIPT_FILENAME']) - 7);
error_reporting(E_ALL);
ini_set('display_errors', TRUE);
ini_set('display_startup_errors', TRUE);
date_default_timezone_set('GMT+5:30');
// PHPExcel_Shared_Font::setAutoSizeMethod(PHPExcel_Shared_Font::AUTOSIZE_METHOD_EXACT);
if (PHP_SAPI == 'cli')
    die('This example should only be run from a Web Browser');

/** Include PHPExcel */
$pdf_writer_class = $main_src . '/PHPExcel/Classes/PHPExcel.php';
require_once($pdf_writer_class);

function getheaders($objPHPExcel, $fileName)
{
    //To Fit To Page while printing
    $objPHPExcel->getActiveSheet()->getPageSetup()->setRowsToRepeatAtTopByStartAndEnd(1);
    $objPHPExcel->getActiveSheet()->getPageSetup()->setFitToWidth(1);
    $objPHPExcel->getActiveSheet()->getPageSetup()->setFitToHeight(0);
    $objPHPExcel->getActiveSheet()->getPageSetup()->setHorizontalCentered(true);
    $objPHPExcel->getActiveSheet()->getPageSetup()->setVerticalCentered(false);

// Redirect output to a client’s web browser (Excel5)
    header('Content-Type: application/vnd.ms-excel');
    header('Content-Disposition: attachment;filename="' . $fileName . '.xls"');
    header('Cache-Control: max-age=0');
    // If you're serving to IE 9, then the following may be needed
    header('Cache-Control: max-age=1');

// If you're serving to IE over SSL, then the following may be needed
    header('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Date in the past
    header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT'); // always modified
    header('Cache-Control: cache, must-revalidate'); // HTTP/1.1
    header('Pragma: public'); // HTTP/1.0
    ob_clean();
    $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
    $objWriter->save('php://output');
    
}

function college_reports_xl($aobj_context)
{
    $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);

$univcode = $aobj_context->mobj_data["univcode"];
    $rtype = $aobj_context->mobj_data["val"];
    $_deggrp = $aobj_context->mobj_data["deggrp"];
    $deggrp = json_decode($_deggrp,true);

$_college = $aobj_context->mobj_data["college"];
    $college = json_decode($_college,true);

$_degree = $aobj_context->mobj_data["degree"];
    $degree = json_decode($_degree,true);

foreach($college as $key => $val){
        $col .= "'".$val."',";
    }

$collarr = substr_replace($col ,"",-1);

if(strpos($collarr,"All") != ""){
        $cnd = "";
    }else{
      $cnd = "and c.FCOLLCODE in ($collarr)";
    }

foreach($deggrp as $key => $val){
        $degg .= "'".$val."',";
    }

$deggrparr = substr_replace($degg ,"",-1);

if(strpos($deggrparr,"All") != ""){
        $cnd1 = "";
    }else{
      $cnd1 = "and d.fdeggrp in ($deggrparr)";
    }

foreach($degree as $key => $val){
        $deg .= "'".$val."',";
    }

$degreearr = substr_replace($deg ,"",-1);

if(strpos($degreearr,"All") != ""){
        $cnd2 = "";
    }else{
      $cnd2 = "and d.fdegree in ($degreearr)";
    }

if($rtype == "Active College List" || $rtype == "All College List"){
    $query = "select c.FCOLLCODE as fcollcode, concat(c.fcollname, ',  ', c.ftown) as fcollname,  c.ftown as town, lcase(c.fcolladd1) as fcolladd1 ,lcase(c.fcolladd2) as fcolladd2,
    ifnull(c.fprincipalname,'') as fprincipalname, ifnull(c.fphone,'') as landline, ifnull(c.fmobile,'') as fmobile, ifnull(c.femail,'') as femail,ifnull(c.faltmobile,'') as faltmobile
    from college c
    inner join student s on s.FCOLLCODE = c.FCOLLCODE
    inner join degree d on d.FDEGREE = s.FDEGREE
    where ifnull(c.fdeleted,'') <> 'T' $cnd $cnd1 
    group by c.fcollcode";
    
    }else if($rtype == "degreeWiseCollegeList"){

$query = "select d.fdegree,d.fdescpn, s.fcollcode, 
        concat(c.fcollname,',  ',c.ftown) as college_name, c.`FPRINCIPALNAME`,  c.fmobile,c.femail 
        from degree d inner join student s on d.fdegree = s.fdegree and d.fexamno = s.fexamno 
        inner join college c on s.fcollcode = c.fcollcode
        where  IFNULL(c.fdeleted,'') <> 'T' 
        $cnd
        $cnd1
        $cnd2
        group by s.fdegree,s.fcollcode
        order by s.fdegree,s.fcollcode";

}else if($rtype == "collwisedeglist"){
        $query = "select d.fdegree,d.fdescpn, s.fcollcode, 
        concat(c.fcollname,',  ',c.ftown) as college_name, c.`FPRINCIPALNAME`,  c.fmobile,c.femail 
        from degree d inner join student s on d.fdegree = s.fdegree and d.fexamno = s.fexamno 
        inner join college c on s.fcollcode = c.fcollcode
        where IFNULL(c.fdeleted,'') <> 'T' 
        $cnd
        $cnd1
        GROUP BY s.fcollcode, s.fdegree
        ORDER BY s.fcollcode, s.fdegree";          
    }

$result = $aobj_context->pobj_db->GetAll($query);

$objPHPExcel = new PHPExcel();
    if($rtype == "Active College List"){
        $fileName = 'Active_College_List';
    }else if($rtype == "All College List"){
        $fileName = 'All_College_List';
    }else if($rtype == "degreeWiseCollegeList"){
        $fileName="Degreewise_College_List";
    }else if($rtype == "collwisedeglist"){
        $fileName = 'Collegewise_Degree_List';
    }
    $objPHPExcel->getProperties()->setCreator("Uniclare")
    ->setLastModifiedBy("Me")->setTitle("My Excel Sheet")
    ->setSubject("My Excel Sheet")->setDescription("Excel Sheet")
    ->setKeywords("Excel Sheet")->setCategory("Me");

// Set active sheet index to the first sheet, so Excel opens this as the first sheet
    $objPHPExcel->setActiveSheetIndex(0);
    
    // Add column headers and make them bold
    $styleArray = array(
        'borders' => array(
            'allborders' => array(
                'style' => PHPExcel_Style_Border::BORDER_THIN,
                'color' => array('argb' => '000000'),
            ),
        ),
    );

if($rtype == "Active College List" || $rtype == "All College List"){
    $objPHPExcel->getActiveSheet()->getStyle('1:1')->getFont()->setBold(true);
    $objPHPExcel->getActiveSheet()->getStyle('1:1')->getFont()->setSize(12);
    $objPHPExcel->getActiveSheet()->freezePane('A1');
    $objPHPExcel->getActiveSheet()->setCellValue('A1', 'Sl. No.')
        ->setCellValue('B1', 'College Code')
        ->setCellValue('C1', 'College Name')
        ->setCellValue('D1', 'Principle Name')
        ->setCellValue('E1', 'Mobile No.')
        ->setCellValue('F1', 'Email')
        ->setCellValue('G1', 'Alt. Contact');
    $objPHPExcel->getActiveSheet()->getStyle('A1:G1')->applyFromArray($styleArray);
        
    
    $objPHPExcel->getActiveSheet()->getRowDimension('1')->setRowHeight(29);
    $objPHPExcel->getActiveSheet()->getStyle('A1:G1')->getAlignment()->setWrapText(true);
    $objPHPExcel->getActiveSheet()->getStyle('A1:G1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
    $objPHPExcel->getActiveSheet()->getStyle('A1:G1')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
  
    foreach ($result as $key => $value) {
    $slNo = $key + 2;
    
      $objPHPExcel->getActiveSheet()->setCellValue('A' . $slNo, $slNo - 1)->getColumnDimension('A')->setwidth(6.5);
      $objPHPExcel->getActiveSheet()->setCellValue('B' . $slNo, $value['fcollcode'])->getColumnDimension('B')->setwidth(15);
      $objPHPExcel->getActiveSheet()->setCellValue('C' . $slNo, $value['fcollname'])->getColumnDimension('C')->setwidth(60);
      $objPHPExcel->getActiveSheet()->setCellValue('D' . $slNo, $value['fprincipalname'])->getColumnDimension('D')->setwidth(35);
      $objPHPExcel->getActiveSheet()->setCellValue('E' . $slNo, $value['fmobile'])->getColumnDimension('E')->setwidth(13);
      $objPHPExcel->getActiveSheet()->setCellValue('F' . $slNo, $value['femail'])->getColumnDimension('F')->setwidth(50);
      $objPHPExcel->getActiveSheet()->setCellValue('G' . $slNo, $value['faltmobile'])->getColumnDimension('G')->setwidth(14);
      
      $objPHPExcel->getActiveSheet()->getStyle('A' . $slNo . ':G'. $slNo)->applyFromArray($styleArray);
      $objPHPExcel->getActiveSheet()->getStyle('A' . $slNo.':B'. $slNo)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
      $objPHPExcel->getActiveSheet()->getStyle('E' . $slNo)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
      $objPHPExcel->getActiveSheet()->getStyle('G' . $slNo)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
    
        }
    }else if($rtype == "degreeWiseCollegeList"){
    
    $objPHPExcel->getActiveSheet()->getStyle('1:1')->getFont()->setBold(true);
    $objPHPExcel->getActiveSheet()->getStyle('1:1')->getFont()->setSize(12);
    $objPHPExcel->getActiveSheet()->freezePane('A1');
    $objPHPExcel->getActiveSheet()->setCellValue('A1', 'Sl. No.')
        ->setCellValue('B1', 'Degree')
        ->setCellValue('C1', 'Description')
        ->setCellValue('D1', 'College Code')
        ->setCellValue('E1', 'College Name')
        ->setCellValue('F1', 'Prinicipal Name')
        ->setCellValue('G1', 'Email')
        ->setCellValue('H1', 'Mobile No.');
    $objPHPExcel->getActiveSheet()->getStyle('A1:H1')->applyFromArray($styleArray);
        
    
    $objPHPExcel->getActiveSheet()->getRowDimension('1')->setRowHeight(29);
    $objPHPExcel->getActiveSheet()->getStyle('A1:H1')->getAlignment()->setWrapText(true);
    $objPHPExcel->getActiveSheet()->getStyle('A1:H1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
    $objPHPExcel->getActiveSheet()->getStyle('A1:H1')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
  
    foreach ($result as $key => $value) {
    $slNo = $key + 2;
    
      $objPHPExcel->getActiveSheet()->setCellValue('A' . $slNo, $slNo - 1)->getColumnDimension('A')->setwidth(6.5);
      $objPHPExcel->getActiveSheet()->setCellValue('B' . $slNo, $value['fdegree'])->getColumnDimension('B')->setwidth(10);
      $objPHPExcel->getActiveSheet()->setCellValue('C' . $slNo, $value['fdescpn'])->getColumnDimension('C')->setwidth(50);
      $objPHPExcel->getActiveSheet()->setCellValue('D' . $slNo, $value['fcollcode'])->getColumnDimension('D')->setwidth(13);
      $objPHPExcel->getActiveSheet()->setCellValue('E' . $slNo, $value['college_name'])->getColumnDimension('E')->setwidth(60);
      $objPHPExcel->getActiveSheet()->setCellValue('F' . $slNo, $value['FPRINCIPALNAME'])->getColumnDimension('F')->setwidth(40);
      $objPHPExcel->getActiveSheet()->setCellValue('G' . $slNo, $value['femail'])->getColumnDimension('G')->setwidth(50);
      $objPHPExcel->getActiveSheet()->setCellValue('H' . $slNo, $value['fmobile'])->getColumnDimension('H')->setwidth(14);
      
      $objPHPExcel->getActiveSheet()->getStyle('A' . $slNo . ':H'. $slNo)->applyFromArray($styleArray);
      $objPHPExcel->getActiveSheet()->getStyle('A' . $slNo.':B'. $slNo)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
      $objPHPExcel->getActiveSheet()->getStyle('D' . $slNo)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
      $objPHPExcel->getActiveSheet()->getStyle('H' . $slNo)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        }
    }else if($rtype == "collwisedeglist"){
        $objPHPExcel->getActiveSheet()->getStyle('1:1')->getFont()->setBold(true);
        $objPHPExcel->getActiveSheet()->getStyle('1:1')->getFont()->setSize(12);
        $objPHPExcel->getActiveSheet()->freezePane('A1');
        $objPHPExcel->getActiveSheet()->setCellValue('A1', 'Sl. No.')
            ->setCellValue('B1', 'Degree')
            ->setCellValue('C1', 'Description')
            ->setCellValue('D1', 'College Code')
            ->setCellValue('E1', 'College Name')
            ->setCellValue('F1', 'Prinicipal Name')
            ->setCellValue('G1', 'Email')
            ->setCellValue('H1', 'Mobile No.');
        $objPHPExcel->getActiveSheet()->getStyle('A1:H1')->applyFromArray($styleArray);
            
        
        $objPHPExcel->getActiveSheet()->getRowDimension('1')->setRowHeight(29);
        $objPHPExcel->getActiveSheet()->getStyle('A1:H1')->getAlignment()->setWrapText(true);
        $objPHPExcel->getActiveSheet()->getStyle('A1:H1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->getActiveSheet()->getStyle('A1:H1')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
    
        foreach ($result as $key => $value) {
        $slNo = $key + 2;
        
        $objPHPExcel->getActiveSheet()->setCellValue('A' . $slNo, $slNo - 1)->getColumnDimension('A')->setwidth(6.5);
        $objPHPExcel->getActiveSheet()->setCellValue('B' . $slNo, $value['fdegree'])->getColumnDimension('B')->setwidth(10);
        $objPHPExcel->getActiveSheet()->setCellValue('C' . $slNo, $value['fdescpn'])->getColumnDimension('C')->setwidth(50);
        $objPHPExcel->getActiveSheet()->setCellValue('D' . $slNo, $value['fcollcode'])->getColumnDimension('D')->setwidth(13);
        $objPHPExcel->getActiveSheet()->setCellValue('E' . $slNo, $value['college_name'])->getColumnDimension('E')->setwidth(60);
        $objPHPExcel->getActiveSheet()->setCellValue('F' . $slNo, $value['FPRINCIPALNAME'])->getColumnDimension('F')->setwidth(40);
        $objPHPExcel->getActiveSheet()->setCellValue('G' . $slNo, $value['femail'])->getColumnDimension('G')->setwidth(50);
        $objPHPExcel->getActiveSheet()->setCellValue('H' . $slNo, $value['fmobile'])->getColumnDimension('H')->setwidth(14);
        
        $objPHPExcel->getActiveSheet()->getStyle('A' . $slNo . ':H'. $slNo)->applyFromArray($styleArray);
        $objPHPExcel->getActiveSheet()->getStyle('A' . $slNo.':B'. $slNo)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->getActiveSheet()->getStyle('D' . $slNo)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->getActiveSheet()->getStyle('H' . $slNo)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
    }
}
    $objPHPExcel->getActiveSheet()->setTitle($fileName);
    $objPHPExcel->getActiveSheet()->getPageSetup()
    ->setOrientation(PHPExcel_Worksheet_PageSetup::ORIENTATION_LANDSCAPE);
    
    $get_coll_name = "select FUNIVNAME as 'FUNIVNAME',FUNIVCODE,
    FUNIVADD1 as 'state', pdf_logo_path,
    ifnull(FEXAMAPPREQ,'F') as FEXAMAPPREQ From control";

$lobj_get_coll_name = $aobj_context->pobj_db->GetRow($get_coll_name);

$aobj_context->FUNIVNAME = $lobj_get_coll_name['FUNIVNAME'];
    $aobj_context->s_state = $lobj_get_coll_name['state'];
    $aobj_context->pdf_logo_path = $lobj_get_coll_name['pdf_logo_path'];
    $aobj_context->FUNIVCODE = $lobj_get_coll_name['FUNIVCODE'];    
// die();

// $objPHPExcel->getActiveSheet()->getHeaderFooter()->addImage($aobj_context->main_src.'img/'.$aobj_context->FUNIVCODE.'_logo.jpg', PHPExcel_Worksheet_HeaderFooter::IMAGE_HEADER_LEFT);
    $objPHPExcel->getActiveSheet()->getHeaderFooter()->setOddHeader('&C&H&"-,Bold"&16' . $aobj_context->FUNIVNAME . "\n" . '&12' . $rtype);
    $objPHPExcel->getActiveSheet()->getHeaderFooter()->setOddHeader('&C&H'.$deggrp);

$objPHPExcel->getActiveSheet()->getHeaderFooter()->setOddFooter('&RPage &P of &N');

getheaders($objPHPExcel, $fileName);
}
?>

${this.title}

Code Editor : college_reports_xl.php