Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
adm_admin.php	35.05 KB	-rw-r--r--
adm_master.php	14.07 KB	-rw-r--r--
adm_register.php	78.86 KB	-rw-r--r--
adm_session_start.php	893 B	-rw-r--r--
cappcontext.php	4.58 KB	-rw-rw-r--
constants.php	818 B	-rw-rw-r--
coutput.php	1.75 KB	-rw-rw-r--
create_user.php	27.69 KB	-rw-rw-r--
creditMaster.php	2.31 KB	-rwxr-xr-x
crequestbroker.php	2.49 KB	-rwxr-xr-x
csessions.php	514 B	-rwxr-xr-x
cuser.php	3.41 KB	-rwxr-xr-x
cuser1.php	3.41 KB	-rwxr-xr-x
customappcontext.php	2.35 KB	-rwxr-xr-x
dailyValuation.php	1.6 KB	-rwxr-xr-x
dashboard.php	3 KB	-rwxr-xr-x
dashboardNew.php	31.05 KB	-rw-r--r--
database.php	744 B	-rw-rw-r--
dateMaster.php	2.83 KB	-rwxr-xr-x
dateupdate.php	8.88 KB	-rw-r--r--
define_heads.php	1.89 KB	-rw-r--r--
degcollege.php	7.32 KB	-rwxr-xr-x
deggrp.php	13.84 KB	-rwxr-xr-x
deggrpNew.php	4.04 KB	-rw-r--r--
degree.php	3.34 KB	-rwxr-xr-x
degreeEntry.php	5.46 KB	-rwxr-xr-x
degreeLoad.php	12.26 KB	-rw-r--r--
dispatchmarkscard.php	19.14 KB	-rwxr-xr-x
drawer.php	552 B	-rw-r--r--
dropDownOptions.php	400 B	-rwxr-xr-x
eGovSignin.php	4.22 KB	-rwxr-xr-x
error_log.php	749 B	-rwxr-xr-x
examAttendance.php	23.9 KB	-rwxr-xr-x
examCntr.php	6.73 KB	-rwxr-xr-x
examCntrdurexm.php	4.05 KB	-rwxr-xr-x
examHappeningCentre.php	19.76 KB	-rwxr-xr-x
examTimetable.php	26.1 KB	-rwxr-xr-x
examTimetableErrorReport.php	7.77 KB	-rwxr-xr-x
exam_app_acknowledge.php	8.41 KB	-rw-r--r--
examapprpt.php	2.9 KB	-rw-r--r--
examattendanceunivadmin.php	19.73 KB	-rwxr-xr-x
exceptionhandler.php	236 B	-rwxr-xr-x
fee-str.php	17.08 KB	-rwxr-xr-x
fee_summary_report.php	43.28 KB	-rwxr-xr-x
fee_summary_report_090120202.p...	43.79 KB	-rwxr-xr-x
finalQp.php	11.07 KB	-rw-r--r--
financeMenuItems.php	1.51 KB	-rw-r--r--
freezeTimetable.php	2.98 KB	-rwxr-xr-x
getBoards.php	1.34 KB	-rwxr-xr-x
getDegSemList.php	7.75 KB	-rwxr-xr-x
getFaculty.php	602 B	-rwxr-xr-x
getMenus.php	3.92 KB	-rwxr-xr-x
getNotifications.php	1.13 KB	-rwxr-xr-x
getPaymentTypes.php	1.77 KB	-rw-rw-r--
getQPdet.php	7 KB	-rw-r--r--
getRvPcReport.php	4.99 KB	-rwxr-xr-x
getStudentRegisteredReport.php	8.91 KB	-rw-r--r--
getUnivName.php	516 B	-rw-r--r--
get_result_table.php	109 B	-rw-r--r--
getdeggrpvalcntr.php	1.88 KB	-rw-r--r--
getinwordstatus.php	3.46 KB	-rw-r--r--
getpgetSavedData.php	4.29 KB	-rwxr-xr-x
getrvpc.php	8.89 KB	-rw-r--r--
getstuddetforrt.php	5.85 KB	-rw-r--r--
getunivs.php	816 B	-rwxr-xr-x
groupMessages.php	9.1 KB	-rwxr-xr-x
grv.php	12.12 KB	-rwxr-xr-x
holidayListing.php	696 B	-rwxr-xr-x
holidayMaster.php	2.11 KB	-rwxr-xr-x
hostNotification.php	1.61 KB	-rwxr-xr-x
htdwonload.php	7.5 KB	-rwxr-xr-x
iNeedHelp.php	3.02 KB	-rwxr-xr-x
iamarkssummary.php	6.25 KB	-rw-r--r--
insertOrEditCollege.php	21.88 KB	-rwxr-xr-x
inward.php	3.09 KB	-rwxr-xr-x
json.php	33.2 KB	-rwxr-xr-x
jwt.php	13.16 KB	-rwxr-xr-x
kswuomr.php	2.8 KB	-rw-r--r--
lastDateUpdate.php	3.95 KB	-rwxr-xr-x
lastDateUpdateCorrection.php	4.81 KB	-rw-r--r--
ledgerview.php	3.2 KB	-rwxr-xr-x
loadclgdettab.php	2.26 KB	-rw-r--r--
loadclgnm.php	1.3 KB	-rw-r--r--
loaddegdet.php	1.45 KB	-rw-r--r--
loaddegreedettab.php	2.49 KB	-rw-r--r--
loadupdclgnm.php	741 B	-rw-r--r--
login.php	1.72 KB	-rwxr-xr-x
loginDet.php	1.04 KB	-rw-r--r--
loginDetails.php	842 B	-rw-r--r--
loginattendance.php	2.21 KB	-rw-r--r--
marks_enter.php	5.74 KB	-rw-r--r--
marksentryupdate.php	4.78 KB	-rw-r--r--
marksmodreport.php	1.49 KB	-rw-r--r--
masQP.php	3.37 KB	-rwxr-xr-x
masterDegree.php	1.16 KB	-rw-r--r--
mcfverify.php	6.65 KB	-rw-r--r--
mpcmanage.php	2.57 KB	-rw-r--r--
mregistry.php	7.59 KB	-rwxr-xr-x
mregistry.php.orig	39.87 KB	-rwxr-xr-x
mregistry_01042021.php	45.75 KB	-rwxr-xr-x
mregistry_arun.php	18.94 KB	-rwxr-xr-x
mregistry_old.php	6.82 KB	-rwxr-xr-x
mregistry_old_03072020.php	33.09 KB	-rwxr-xr-x
mregistry_old_08052020.php	29.86 KB	-rwxr-xr-x
notificationPush.php	9.36 KB	-rwxr-xr-x
oldquestionpaper.php	4.87 KB	-rw-r--r--
omrqnentry.php	8.18 KB	-rw-r--r--
online-test.php	12.77 KB	-rwxr-xr-x
orderReportExcel.php	7.35 KB	-rw-r--r--
paymentReport.php	3.64 KB	-rwxr-xr-x
pgetDashboard.php	0 B	-rwxr-xr-x
pgprevmarks.php	13.41 KB	-rw-r--r--
photoCrop.php	5.57 KB	-rwxr-xr-x
practicalMarks.php	7.09 KB	-rw-r--r--
prbatchdet.php	3.26 KB	-rwxr-xr-x
prifreeze.php	3.11 KB	-rw-r--r--
pushmarks.php	1.18 KB	-rw-r--r--
pushnitification.php	8.1 KB	-rwxr-xr-x
pushnotif_ra.php	3.94 KB	-rwxr-xr-x
qpIndent.php	37.42 KB	-rwxr-xr-x
qpIndent_04032019.php	15.36 KB	-rwxr-xr-x
qpIndent_old.php	37.05 KB	-rwxr-xr-x
qp_dashboard.php	11.31 KB	-rw-r--r--
qp_issue.php	8.46 KB	-rw-r--r--
qp_setter.php	59.66 KB	-rw-r--r--
qp_setter_new.php	53.28 KB	-rw-r--r--
qpboardupdate.php	4.26 KB	-rw-r--r--
qpcrosscheck.php	11.96 KB	-rw-r--r--
qpindentstudlist.php	11.16 KB	-rw-r--r--
qpschemeupload.php	5.84 KB	-rw-r--r--
qpsetterteach.php	22.96 KB	-rw-r--r--
qpsummarynew.php	4.58 KB	-rw-r--r--
qptranlogin.php	1.64 KB	-rw-r--r--
qptranmenu.php	2.22 KB	-rw-r--r--
qpupload.php	8.11 KB	-rwxr-xr-x
qpupload_240621.php	6.49 KB	-rwxr-xr-x
rauspush.php	4.03 KB	-rw-r--r--
razorPayConfig.php	250 B	-rwxr-xr-x
reasonMaster.php	1.73 KB	-rwxr-xr-x
refund.php	2.68 KB	-rwxr-xr-x
register_rrit.php	28.44 KB	-rw-r--r--
releaseTimetable.php	4.73 KB	-rwxr-xr-x
reports_bkp.php	12.25 KB	-rwxr-xr-x
resultStats.php	4.69 KB	-rwxr-xr-x
result_pushnotif_bcu.php	2.33 KB	-rwxr-xr-x
result_pushnotif_bnu.php	2.33 KB	-rwxr-xr-x
result_pushnotif_dud.php	2.33 KB	-rwxr-xr-x
result_pushnotif_kus.php	2.33 KB	-rwxr-xr-x
result_pushnotif_rcub.php	2.33 KB	-rwxr-xr-x
resultdate.php	6.39 KB	-rw-r--r--
resultsApp.php	55 B	-rwxr-xr-x
results_new.php	31.65 KB	-rw-r--r--
resultstat.php	1.72 KB	-rw-r--r--
resultstatsrpt.php	13.82 KB	-rwxr-xr-x
retBatchDet.php	955 B	-rwxr-xr-x
rotation.php	596 B	-rwxr-xr-x
ruaspush.php	618 B	-rw-r--r--
rvMarksEntry.php	4.78 KB	-rwxr-xr-x
rvStatus.php	769 B	-rw-r--r--
rv_result_pushnotif_bcu.php	1.96 KB	-rwxr-xr-x
rvpc.php	1.76 KB	-rw-r--r--
rvrtReport.php	12.39 KB	-rwxr-xr-x
rvrt_Block.php	3.23 KB	-rw-r--r--
rvrtapp.php	22.11 KB	-rw-r--r--
rvrtblock.php	2.97 KB	-rw-r--r--
saveBKMCStdDet.php	2.22 KB	-rw-r--r--
saveBankDetails.php	1.54 KB	-rwxr-xr-x
saveBarcodeDeatils.php	2.87 KB	-rwxr-xr-x
saveDegSemDet.php	14.09 KB	-rwxr-xr-x
saveFinbkmh.php	2.1 KB	-rw-r--r--
savePGETApp.php	4.45 KB	-rwxr-xr-x
savePostNotification.php	2.94 KB	-rwxr-xr-x
scheduleqp.php	2.58 KB	-rw-r--r--
script.php	14.27 KB	-rwxr-xr-x
sdqpmenus.php	163 B	-rw-r--r--
searchregcode.php	5.17 KB	-rw-r--r--
selectFinalQpNew.php	4.69 KB	-rw-r--r--
sendConfMail.php	19.43 KB	-rwxr-xr-x
sendGridMail.php	1.72 KB	-rwxr-xr-x
sendOTP.php	5.51 KB	-rw-r--r--
sendOrder.php	12.33 KB	-rw-r--r--
sendnotification.php	0 B	-rwxr-xr-x
sendsms.php	11.83 KB	-rwxr-xr-x
sendsms_05092020.php	4.34 KB	-rwxr-xr-x
sendsms_15022019.php	6.66 KB	-rwxr-xr-x
sendsms_27012018.php	4.3 KB	-rwxr-xr-x
sendsmsapi.php	802 B	-rwxr-xr-x
sendzohomail.php	1.46 KB	-rw-r--r--
session_start.php	149 B	-rw-r--r--
session_start_rr.php	864 B	-rw-r--r--
sessionmaster.php	1.49 KB	-rw-r--r--
setDGExamTimetableReport.php	19.63 KB	-rwxr-xr-x
setDGExamTimetableReport_bcu_p...	11.51 KB	-rwxr-xr-x
setExamTimetable.php	5.01 KB	-rwxr-xr-x
setExamTimetableReport.php	9.84 KB	-rwxr-xr-x
settlement.php	9.06 KB	-rw-r--r--
sms-new.php	26.55 KB	-rw-r--r--
sms-notification.php	21.17 KB	-rwxr-xr-x
ssp_error_data.php	31.1 KB	-rwxr-xr-x
sspdata-auto-upload.php	11.12 KB	-rwxr-xr-x
sspdata.php	23.9 KB	-rwxr-xr-x
sspdata1.php	11.41 KB	-rw-r--r--
sspdata1_rcub.php	13.96 KB	-rw-r--r--
std_registrtion.php	1.4 KB	-rw-r--r--
studDoc.php	913 B	-rw-r--r--
studReg.php	1.64 KB	-rw-r--r--
stud_ack.php	9.89 KB	-rw-r--r--
stud_det.php	1.62 KB	-rw-r--r--
stud_payments.php	3.24 KB	-rw-rw-r--
student.php	26.71 KB	-rwxr-xr-x
studexamappblock.php	1.18 KB	-rw-r--r--
studymaterial.php	3.07 KB	-rwxr-xr-x
subject.php	2.42 KB	-rwxr-xr-x
subjectEntryScrn.php	8 KB	-rwxr-xr-x
subjectFreeze.php	4.91 KB	-rw-r--r--
sublisting.php	2.39 KB	-rw-r--r--
tdvsCreatePanel.php	1.26 KB	-rw-r--r--
tdvsQPteach.php	2.17 KB	-rw-r--r--
tdvsViewStatus.php	3.52 KB	-rw-r--r--
tdvs_Deviation.php	8.61 KB	-rw-r--r--
tdvs_batch.php	5.89 KB	-rw-r--r--
tdvs_createuser.php	6.5 KB	-rw-r--r--
tdvs_dashboard.php	3.58 KB	-rw-r--r--
tdvs_mail.php	5.93 KB	-rw-r--r--
tdvs_pergeval.php	11.55 KB	-rw-r--r--
tdvs_register.php	1.57 KB	-rw-r--r--
tdvs_saveRecieveQPCount.php	3.53 KB	-rwxr-xr-x
tdvs_saveScript.php	11.74 KB	-rw-r--r--
tdvs_script_cross_check.php	9.35 KB	-rw-r--r--
tdvs_stats.php	21.48 KB	-rw-r--r--
tdvs_subject.php	4.45 KB	-rw-r--r--
tdvs_subjectcreate.php	6.11 KB	-rw-r--r--
tdvs_teacher_valdet.php	2.87 KB	-rw-r--r--
tdvs_teacherpanel.php	3.38 KB	-rw-r--r--
tdvs_teachval.php	1.88 KB	-rw-r--r--
tdvs_teachwisevaldet.php	3.28 KB	-rw-r--r--
tdvs_valcenter.php	2.84 KB	-rw-r--r--
tdvs_verifyqppattern.php	1.03 KB	-rw-r--r--
tdvsdecoding.php	34.16 KB	-rw-r--r--
teachReport.php	5.27 KB	-rwxr-xr-x
teachValBill.php	990 B	-rwxr-xr-x
teachcoderange.php	1.71 KB	-rw-r--r--
teacherEmail.php	20.45 KB	-rw-r--r--
teacherEntry.php	67.04 KB	-rw-r--r--
teacherid.php	2 KB	-rw-r--r--
teachval.php	8.56 KB	-rwxr-xr-x
teachvaluationcount.php	21.07 KB	-rw-r--r--
teachworkapi.php	2.37 KB	-rwxr-xr-x
teachworksum.php	2.42 KB	-rwxr-xr-x
timetablesownload.php	9.98 KB	-rwxr-xr-x
timetablesownload_29062019.php	10.51 KB	-rwxr-xr-x
ttUpload.php	2.5 KB	-rwxr-xr-x
uChangeEmail.php	4.38 KB	-rwxr-xr-x
uChangeMobNum.php	5.17 KB	-rwxr-xr-x
uChangeRegNum.php	4.04 KB	-rwxr-xr-x
uDegPassCrit.php	1.32 KB	-rwxr-xr-x
uDeleteSpecificCollege.php	611 B	-rwxr-xr-x
uExamApplication.php	907 B	-rwxr-xr-x
uExamApplicationForm.php	30.97 KB	-rwxr-xr-x
uForgotPws.php	4.85 KB	-rwxr-xr-x
uGetDetailResult.php	2.17 KB	-rwxr-xr-x
uGetExamCenter.php	1.04 KB	-rwxr-xr-x
uGetResult.php	26.94 KB	-rwxr-xr-x
uGetResultSemester.php	896 B	-rwxr-xr-x
uGetSpecificCollege.php	1.43 KB	-rwxr-xr-x
uGrievances.php	2.97 KB	-rwxr-xr-x
uHallticket.php	5.33 KB	-rwxr-xr-x
uIAMarks.php	3.41 KB	-rwxr-xr-x
uINeedHelp.php	2.82 KB	-rwxr-xr-x
uInsertOrUpdateCollegeDetails....	2.42 KB	-rwxr-xr-x
uMenu_new.php	2.27 KB	-rwxr-xr-x
uNotification.php	3.1 KB	-rwxr-xr-x
uOldQuestionPaper.php	3.46 KB	-rwxr-xr-x
uPracticaltt.php	2.41 KB	-rwxr-xr-x
uProfile.php	1.27 KB	-rwxr-xr-x
uRegistration.php	16.86 KB	-rwxr-xr-x
uRevaluation.php	26.39 KB	-rwxr-xr-x
uRvAppStatus.php	2.42 KB	-rwxr-xr-x
uSubjectList.php	1.53 KB	-rwxr-xr-x
uSupport.php	1023 B	-rwxr-xr-x
uTheorytt.php	2.5 KB	-rwxr-xr-x
uansbookdet.php	2.85 KB	-rwxr-xr-x
uansbookdet0.php	11.83 KB	-rwxr-xr-x
uansbookupdate.php	1.29 KB	-rwxr-xr-x
ulogin.php	2.54 KB	-rwxr-xr-x
ultRoomDet.php	1.96 KB	-rw-r--r--
umenu.php	1.07 KB	-rwxr-xr-x
uniAttEntry.php	1.03 KB	-rw-r--r--
uniContctFrom.php	1.29 KB	-rwxr-xr-x
univRefund.php	9.81 KB	-rwxr-xr-x
unotification.php	3.1 KB	-rwxr-xr-x
upcomingnotification.php	4.55 KB	-rw-r--r--
updateIAMarks.php	1.42 KB	-rw-r--r--
updateRvPcChkList.php	1.13 KB	-rwxr-xr-x
update_dates.php	11.89 KB	-rw-r--r--
upload-sms-excel.php	3.58 KB	-rwxr-xr-x
uploadAnsBook.php	3.38 KB	-rwxr-xr-x
uploadCodeSlips.php	4.1 KB	-rw-r--r--
uploadData.php	6.24 KB	-rwxr-xr-x
uploadDummy.php	761 B	-rw-r--r--
uploadMCdetails.php	4.17 KB	-rw-r--r--
uploadMultipleFiles.php	3.99 KB	-rwxr-xr-x
uploadSSPData.php	5.9 KB	-rw-r--r--
uploadSSPData_bonf.php	11.86 KB	-rw-r--r--
upload_ans_book.php	5.25 KB	-rwxr-xr-x
upload_qp.php	1.85 KB	-rw-r--r--
upload_sms_file.php	7.94 KB	-rw-rw-r--
uploadbackup.php	5.16 KB	-rw-r--r--
uploadcorr_qp.php	4.74 KB	-rw-r--r--
uploadcorrdoc.php	4.09 KB	-rw-r--r--
uploadpwd.php	1.92 KB	-rw-r--r--
uploadqp.php	6.43 KB	-rw-r--r--
uploadqpMultipleFiles.php	678 B	-rw-r--r--
uploadscripts.php	333 B	-rw-r--r--
utils.php	4.19 KB	-rw-r--r--
uucmsdecoding.php	1.86 KB	-rw-r--r--
valuatordet.php	3.29 KB	-rwxr-xr-x

Code Editor : qpIndent.php

<?php
ini_set('max_execution_time', 300);
$main_src = substr($_SERVER['SCRIPT_FILENAME'], 0, strlen($_SERVER['SCRIPT_FILENAME']) - 7);
//$pdf_writer_class =$main_src."/tarka_pdf/fpdf.php";
$pdf_writer_class = $main_src . "/tcpdf/tcpdf.php";
require_once($pdf_writer_class);
ini_set('memory_limit', '2G');
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 */
require_once($pdf_writer_class = $main_src . '/PHPExcel/Classes/PHPExcel.php');

class MYPDF extends TCPDF
{
    public $aobj_context;

public function setData($aobj_context, $Deggrp, $reportType)
    {
        $this->aobj_context = $aobj_context;
        $this->Deggrp = $Deggrp;
        $this->reportType = $reportType;
        $this->univcode = $this->aobj_context->mobj_data["univcode"];
    }
    public function Header()
    {
        // get the current page break margin
        $bMargin = $this->getBreakMargin();
        // get current auto-page-break mode
        $auto_page_break = $this->AutoPageBreak;
        // disable auto-page-break
        $this->SetAutoPageBreak(false, 0);
        // set bacground image

$this->SetFillColor(248, 248, 255);
        $img_path = $this->aobj_context->main_src . "/img/{$this->univcode}_logo.jpg";

if (file_exists($img_path))
            $this->Image($img_path, 30, 6, 20, 20);

$this->SetFont('Times', 'B', 13);
        $this->SetY(5);
        $this->Cell(0, 4, $this->aobj_context->FUNIVNAME, 0, 1, 'C');
        $this->SetFont('Times', '', 11);
        $this->Cell(0, 4, $this->aobj_context->s_state, 0, 1, 'C');

$this->SetFont('Times', 'BU', 12);
        $this->Ln(1);

$cur_year = date("Y");
        $this->Cell(0, 5, $this->reportType, '0', 1, 'C');
        $this->SetFont('Times', '', 12);

$this->Cell(0, 6, " Degree Group : " . $this->Deggrp . ' - ' . $this->aobj_context->fexamdate . ' EXAMINATION', "0", 1, "C");
        //$this->Cell(0,6," Degree Group: ".$this->Deggrp.' '.$this->aobj_context->fexamdate,"0",1,"C");
        // restore auto-page-break status
        $this->SetAutoPageBreak($auto_page_break, $bMargin);
        // set the starting point for the page content    
    }

public function Footer()
    {
        $this->SetXY(15, -15);
        $this->SetFont('helvetica', 'I', 8);
        $this->Cell(60, 10, 'IP : ' . $_SERVER["REMOTE_ADDR"], 0, 0, 'L');
        $this->Cell(70, 10, 'Date : ' . date("d/m/Y H:i:s"), 0, 0, 'C');

$this->Cell(60, 10, 'Page ' . $this->getPageNumGroupAlias() . '/' . $this->getPageGroupAlias(), 0, 1, 'R');
    }
}

class QPIndentReport
{

function DefaultConstructor($aobj_context, $Deggrp, $reportType)
    {
        $this->aobj_context = $aobj_context;
        $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);

$this->ip = $_SERVER["REMOTE_ADDR"];
        $get_date = "select DATE_FORMAT(now(), '%d/%m/%Y') as now_date";
        $obj = $this->aobj_context->mobj_db->GetRow($get_date);

$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 = $this->aobj_context->pobj_db->GetRow($get_coll_name);

$query = "select * from deggrp where fdeggrp = '{$Deggrp}'";
        $results = $this->aobj_context->pobj_db->GetRow($query);
        $aobj_context->fexamdate = $results['fexamdate'];

$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'];
        $this->Degree = $Deggrp;
        // var_dump($this->Deggrp); 
        $this->current_date = $obj['now_date'];

$this->pdf = new MYPDF('L');
        $this->pdf->setData($aobj_context, $Deggrp, $reportType);
    }

function tableHeader($pdf)
    {
        $pdf->SetFont('Times', 'B', 10);

$pdf->Cell(8, 6, "Sl.", "LRT", 0, "C");
        $pdf->Cell(12, 6, "QP", "LRT", 0, "C");
        $pdf->Cell(65, 6, "Subject Name", "LRT", 0, "C");
        $pdf->Cell(18, 6, "Date", "LRT", 0, "C");
        $pdf->Cell(37, 6, "Session", "LRT", 0, "C");
        $pdf->Cell(12, 6, "QP", "LRT", 0, "C");
        $pdf->Cell(43, 6, "Degree", "LRT", 1, "C");

$pdf->Cell(8, 6, "No", "LRB", 0, "C");
        $pdf->Cell(12, 6, "Code", "LBR", 0, "C");
        $pdf->Cell(65, 6, "", "LBR", 0, "C");
        $pdf->Cell(18, 6, "", "LBR", 0, "C");
        $pdf->Cell(37, 6, "", "LBR", 0, "C");
        $pdf->Cell(12, 6, "Indent", "LBR", 0, "C");
        $pdf->Cell(43, 6, "", "LBR", 1, "C");

$pdf->SetFont('Times', '', 10);
    }

function headerQPWise($pdf)
    {

$pdf->SetFont('Times', 'B', 10);

$pdf->Cell(30, 6, "", 0, 0);
        $pdf->Cell(8, 6, "Sl.", "LRT", 0, 'C');
        $pdf->Cell(15, 6, "Center", "LRT", 0, "C");
        $pdf->Cell(110, 6, "Center Name", "LRT", 0, "C");
        $pdf->Cell(15, 6, "Total", "LRT", 1, "C");

$pdf->Cell(30, 6, "", 0, 0);
        $pdf->Cell(8, 6, "No.", "LRB", 0, "C");
        $pdf->Cell(15, 6, "Code", "LRB", 0, "C"); //w h txt brd pos align
        $pdf->Cell(110, 6, "", "LBR", 0, "C");
        $pdf->Cell(15, 6, "Count", "LBR", 1, "C");
        $pdf->SetFont('Times', '', 10);
    }

function headerDateWise($pdf)
    {

$pdf->SetFont('Times', 'B', 10);

$pdf->Cell(8, 6, "Sl.", "LRT", 0, "C");
        $pdf->Cell(20, 6, "Date", "LRT", 0, "C");
        $pdf->Cell(41, 6, "Session", "LRT", 0, "C");
        $pdf->Cell(10, 6, "QP", "LRT", 0, "C");
        $pdf->Cell(80, 6, "Subject Name", "LRT", 0, "C");
        $pdf->Cell(100, 6, "Degree", "LRT", 0, "C");
        $pdf->Cell(15, 6, "QP", "LRT", 1, "C");

$pdf->Cell(8, 6, "No", "LRB", 0, "C");
        $pdf->Cell(20, 6, "", "LRB", 0, "C"); //w h txt brd pos align
        $pdf->Cell(41, 6, "", "LBR", 0, "C");
        $pdf->Cell(10, 6, "Code", "LBR", 0, "C");
        $pdf->Cell(80, 6, "", "LBR", 0, "C");
        $pdf->Cell(100, 6, "", "LBR", 0, "C");
        $pdf->Cell(15, 6, "Count", "LBR", 1, "C");
        $pdf->SetFont('Times', '', 10);
    }

function writeReport($cntrlist)
    {
        $pdf = $this->pdf;

$pdf->SetMargins(6, 30);
        $pdf->startPageGroup();
        $pdf->AddPage("P");
        $orientation = 'P';
        $pdf->SetFont('Times', '', 10);

// $this->tableHeader($pdf);

$old_cntr = '';
        $new_cntr = $cntrlist[0]['fcntrcode'];
        // var_dump($cntrlist);
        $sl_no = 1;
        foreach ($cntrlist as $key => $value) {
            $new_cntr = $value['fcntrcode'];
            // $value['fcntrname']
            $str = explode(',', $value['fdegree']);
            $str1 = implode(',', array_slice($str, 0, 4));
            $str2 = implode(',', array_slice($str, 4));

$sub1 = substr($value['fsubname'], 0, 38);
            $sub2 = substr($value['fsubname'], 38);

if ($old_cntr !== $new_cntr) {
                if ($pdf->getY() > 240)
                    $pdf->AddPage();
                $pdf->SetFont('Times', 'B', 12);
                // var_dump($value['fcntrcode'] . ' - ' . $value['fcntrname']);
                // echo "<br>";
                $pdf->Cell(0, 12, $value['fcntrcode'] . ' - ' . $value['fcntrname'], 0, 1, "C");
                $this->tableHeader($pdf);
                $old_cntr = $value['fcntrcode'];
                $sl_no = 1;
            }

// var_dump($value['fqpcode'].'--'.$value['fdoe']);
            // echo "<br/>";

$x = $pdf->GetX();
            $y = $pdf->GetY();
            $pdf->SetX($x + 20);
            $pdf->MultiCell(65, 6, $value['fsubname'], 1, "L");
            $y1 = $pdf->GetY();
            $h = $y1 - $y;
            $pdf->SetXY($x, $y);

$pdf->Cell(8, $h, $sl_no, "1", 0, "C");
            $pdf->cell(12, $h, $value['fqpcode'], "1", 0, "L");
            // $pdf->cell(65, 6, $value['fsubname'], "1", 0, "L");
            $pdf->SetXY($x + 85, $y);
            $pdf->cell(18, $h, $value['fdoe'], "1", 0, "R");
            $pdf->cell(37, $h, $value['fsession'], "1", 0, "R");
            $pdf->cell(12, $h, moneyFormatIndia($value['frounded']), "1", 0, "C");
            $pdf->cell(43, $h, $str1, "1", 1, "L");
        
            if ($pdf->getY() > 260) {
                $pdf->AddPage();
                $pdf->SetFont('Times', 'B', 12);
                $pdf->Cell(0, 12, $value['fcntrcode'] . ' - ' . $value['fcntrname'], 0, 1, "C");
                $this->tableHeader($pdf);
            }
            $sl_no++;
            
        }
    }

function writeQPReport($qpList)
    {

$pdf = $this->pdf;

$pdf->SetMargins(0, 35);
        $pdf->startPageGroup();
        $pdf->AddPage("P");

$pdf->SetFont('Times', '', 10);

$this->headerQPWise($pdf);
        $sl_no = 0;
        foreach ($qpList as $key => $value) {

$colname1 = strtolower(substr($value['fcntrname'], 0, 65));
            $colname2 = strtolower(substr($value['fcntrname'], 65));

$sl_no++;

if ($pdf->getY() > 260) {
                $pdf->AddPage("P");
                $this->headerQPWise($pdf);
            }
            if ($colname2) {
                $pdf->Cell(30, 6, "", 0, 0);
                $pdf->Cell(8, 6, $sl_no, "LRT", 0, "C");
                $pdf->Cell(15, 6, $value['fcntrcode'], "LRT", 0, "C");
                $pdf->Cell(110, 6, ucwords($colname1, '\',. '), "LRT", 0, "L");
                $pdf->Cell(15, 6, moneyFormatIndia($value['fcount']), "LRT", 1, "R");

$pdf->Cell(30, 6, "", 0, 0);
                $pdf->Cell(8, 6, "", "LBR", 0);
                $pdf->Cell(15, 6, "", "LBR", 0, "C");
                $pdf->Cell(110, 6, $colname2, "LBR", 0, "L");
                $pdf->Cell(15, 6, "", "LBR", 1, "R");
            } else {
                $pdf->Cell(30, 6, "", 0, 0);
                $pdf->Cell(8, 6, $sl_no, "1", 0, "C");
                $pdf->Cell(15, 6, $value['fcntrcode'], "1", 0, "C");
                $pdf->Cell(110, 6, ucwords($colname1, '\',. '), "1", 0, "L");
                $pdf->Cell(15, 6, moneyFormatIndia($value['fcount']), "1", 1, "R");
            }

if ($pdf->getY() > 260) {
                $pdf->AddPage("P");
                $this->headerQPWise($pdf);
            }
        }
    }

function writedoeReport($doelist)
    {

$pdf = $this->pdf;

$pdf->SetMargins(10, 35);
        $pdf->startPageGroup();
        $pdf->AddPage("L");

$pdf->SetFont('Times', '', 10);

$this->headerDateWise($pdf);
        $sl_no = 0;
        foreach ($doelist as $key => $value) {

$sub = explode(',', $value['fdegree']);

$degstr = implode(', ', $sub);

$sub1 = substr($value['fsubname'], 0, 40);
            $sub2 = substr($value['fsubname'], 40);

$sl_no++;

if ($sub2) {
                $x = $pdf->GetX();
                $y = $pdf->GetY();
                $pdf->SetX($x + 159);
                $pdf->MultiCell(100, 6, $degstr, "LRT", "L");
                $y1 = $pdf->GetY();
                $h = $y1 - $y;
                $pdf->SetXY($x, $y);

$pdf->Cell(8, $h, $sl_no, "LRT", 0, "C");
                $pdf->Cell(20, $h, $value['fdoe'], "LRT", 0, "C");
                $pdf->Cell(41, $h, $value['fsession'], "LRT", 0, "C");
                $pdf->Cell(10, $h, $value['fqpcode'], "LRT", 0, "C");
                $pdf->Cell(80, $h, $sub1, "LRT", 0, "L");

$pdf->SetX($x + 259);
                $pdf->Cell(15, $h, moneyFormatIndia($value['fforcoll']), "LRT", 1, "C");

if ($sub2) {
                    $pdf->Cell(8, $h, "", "LBR", 0);
                    $pdf->Cell(20, $h, "", "LBR", 0, "C");
                    $pdf->Cell(41, $h, "", "LBR", 0, "C");
                    $pdf->Cell(10, $h, "", "LBR", 0, "C");
                    $pdf->Cell(80, $h, $sub2, "LBR", 0, "L");
                    $pdf->Cell(100, $h, "", "LBR", 0, "L");
                    $pdf->Cell(15, $h, "", "LBR", 1, "R");
                }
                if ($pdf->getY() > 170) {
                    $pdf->AddPage();
                    $this->headerDateWise($pdf);
                }
            } else {
                $x = $pdf->GetX();
                $y = $pdf->GetY();
                $pdf->SetX($x + 159);
                $pdf->MultiCell(100, 6, $degstr, 1, "L");
                $y1 = $pdf->GetY();
                $h = $y1 - $y;
                $pdf->SetXY($x, $y);

$pdf->Cell(8, $h, $sl_no, "1", 0, "C");
                $pdf->Cell(20, $h, $value['fdoe'], "1", 0, "C");
                $pdf->Cell(41, $h, $value['fsession'], "1", 0, "C");
                $pdf->Cell(10, $h, $value['fqpcode'], "1", 0, "C");
                $pdf->Cell(80, $h, $sub1, "1", 0, "L");

$pdf->SetX($x + 259);
                $pdf->Cell(15, $h, moneyFormatIndia($value['fforcoll']), "1", 1, "C");
                if ($pdf->getY() > 170) {
                    $pdf->AddPage();
                    $this->headerDateWise($pdf);
                }
            }

if ($pdf->getY() > 180) {
                $this->headerDateWise($pdf);
            }
        }
    }
    function SendOutput()
    {
        // ob_end_clean();
        $this->pdf->Output("{$this->reportType}_QPIndent{$this->univcode}.pdf", "I");
    }
}

function getqpIndentReport($aobj_context)
{

$univcode = $aobj_context->mobj_data["univcode"];
    $deggrp = $aobj_context->mobj_data["dgp"];
    $reportType = $aobj_context->mobj_data["rt"];
    $reportFormat = $aobj_context->mobj_data["rf"];
    $examrange = $aobj_context->mobj_data["examrange"];
    
    $examnoStr = strtoupper($examrange);
    $splitexamno = str_split($examnoStr);

$examno = implode("','", $splitexamno);

// var_dump($deggrp,$reportType,$resetData,$reportFormat);
    header("Access-Control-Allow-Origin: *");
    header('Content-Type: application/json');
    header("Access-Control-Allow-Methods: GET, POST, PUT, DELETE, OPTIONS");
    header("Access-Control-Allow-Headers: Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With");

$class_obj = new QPIndentReport();
    $class_obj->univcode = $univcode;
    $class_obj->reportType = $reportType;

$class_obj->DefaultConstructor($aobj_context, $deggrp, $reportType);

if ($reportType == 'Centrewise Indent') {

//and (fdegree like '%4' or fdegree = 'BFAD3')
        $query = "SELECT fcntrcode,fcntrname,fqpcode,fsubname, 
        DATE_FORMAT(fdoe, '%d/%m/%Y') AS fdoe,ifnull(r.fdescpn,'') as fsession,
        fcnt,fextra,ftotal,frounded,fdegree
        FROM tmpqpindsum s left join reason r on s.fsession = r.freasoncd 
        where s.fqpcode in (select fqpcode from subject where fexamno in ('{$examno}'))
        ORDER BY fcntrcode, fqpcode";
        $result = $aobj_context->pobj_db->GetAll($query);
        // var_dump($query);die();
        // var_dump($result);

if (count($result) > 0) {
            if ($reportFormat == 'Excel Format')
                writeReport($result, $aobj_context);
            else {
                $class_obj->writeReport($result);
                $class_obj->SendOutput();
            }
        }
    }
    if ($reportType == 'Answer Book Indent') {

$query = "SELECT q.fcntrcode, q.fcntrname,SUM(q.frounded) AS fcount
        FROM tmpqpindsum q
        GROUP BY q.fcntrcode, q.fcntrname
        ORDER BY q.fcntrcode, q.fcntrname";
        // var_dump($query);die();
        $result = $aobj_context->pobj_db->GetAll($query);

if (count($result) > 0) {
            if ($reportFormat == 'Excel Format')
                writeABIReport($result, $aobj_context);
            else {
                $class_obj->writeQPReport($result);
                $class_obj->SendOutput();
            }
        }
    }

if ($reportType == 'Total Indent') {

//and (fdegree like '%4' or fdegree = 'BFAD3')
        $query = "SELECT DATE_FORMAT(q.fdoe, '%d/%m/%Y') as fdoe , ifnull(re.fdescpn,'') as fsession,
         q.fqpcode, q.fsubname, r.fdegree, q.fforcoll, q.fforuniv
        FROM tmpqpindtot q inner join tmpqpinddeg r on q.fqpcode = r.fqpcode 
        left join reason re on q.fsession = re.freasoncd 
        where q.fqpcode in (select fqpcode from subject where fexamno in ('{$examno}'))
        GROUP BY q.fdoe, q.fsession, q.fqpcode, q.fsubname
        ORDER BY q.fdoe, q.fsession, q.fqpcode";
        $result = $aobj_context->pobj_db->GetAll($query);
        // var_dump($query);die();
        
        if (count($result) > 0) {
            if ($reportFormat == 'Excel Format')
                writedoeReport($result, $aobj_context);
            else {
                $class_obj->writedoeReport($result);
                $class_obj->SendOutput();
            }
        }
    }
}

function writeReport($result, $aobj_context)
{

$objPHPExcel = new PHPExcel();
    $fileName = 'CenterwiseIndent';

// Set document properties
    $objPHPExcel->getProperties()->setCreator("Me")->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'),
            ),
        ),
    );

$objPHPExcel->getActiveSheet()->getStyle('1:1')->getFont()->setBold(true);
    $objPHPExcel->getActiveSheet()->getStyle('1:1')->getFont()->setSize(12);
    $objPHPExcel->getActiveSheet()->freezePane('A2');
    $objPHPExcel->getActiveSheet()
        ->setCellValue('A1', 'Sl. No.')
        ->setCellValue('B1', 'QP Code')
        ->setCellValue('C1', 'Center Code')
        ->setCellValue('D1', 'Center Name')
        ->setCellValue('E1', 'Subject Name')
        ->setCellValue('F1', 'Date')
        ->setCellValue('G1', 'Session')
        ->setCellValue('H1', 'Qp Indent')
        // ->setCellValue('I1','Degree')
    ;
    $objPHPExcel->getActiveSheet()->getStyle('A1:H1')->applyFromArray($styleArray);
    // $objPHPExcel->getActiveSheet()->getColumnDimension('G1')->setAutoSize(true);
    $objPHPExcel->getActiveSheet()->getRowDimension('1')->setRowHeight(40);
    $objPHPExcel->getActiveSheet()->getStyle('A1:I1')->getAlignment()->setWrapText(true);
    $objPHPExcel->getActiveSheet()->getStyle('A1:I1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
    $objPHPExcel->getActiveSheet()->getStyle('A1:I1')->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(5);
        $objPHPExcel->getActiveSheet()->setCellValue('C' . $slNo, $value['fcntrcode'])->getColumnDimension('C')->setwidth(8.43);
        $objPHPExcel->getActiveSheet()->setCellValue('D' . $slNo, $value['fcntrname'])->getColumnDimension('D')->setwidth(50);
        $objPHPExcel->getActiveSheet()->setCellValue('B' . $slNo, $value['fqpcode'])->getColumnDimension('B')->setwidth(8.43);
        $objPHPExcel->getActiveSheet()->setCellValue('E' . $slNo, $value['fsubname'])->getColumnDimension('E')->setwidth(34);
        $objPHPExcel->getActiveSheet()->setCellValue('F' . $slNo, $value['fdoe'])->getColumnDimension('F')->setwidth(12.29);
        $objPHPExcel->getActiveSheet()->setCellVAlue('G' . $slNo, $value['fsession'])->getColumnDimension('G')->setwidth(20.29);
        $objPHPExcel->getActiveSheet()->setCellValue('H' . $slNo, $value['frounded'])->getColumnDimension('H')->setwidth(8);
        // $objPHPExcel->getActiveSheet()->setCellValue('I'.$slNo, $value['fdegree'])->getColumnDimension('I')->setwidth(45);

// $objPHPExcel->getActiveSheet()->getColumnDimension('D')->setwidth(12);
        $objPHPExcel->getActiveSheet()->getStyle('A' . $slNo . ':H' . $slNo)->applyFromArray($styleArray);
        $objPHPExcel->getActiveSheet()->getRowDimension($slNo)->setRowHeight(33);
        $objPHPExcel->getActiveSheet()->getStyle('A' . $slNo . ':C' . $slNo)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->getActiveSheet()->getStyle('A' . $slNo . ':C' . $slNo)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);

$objPHPExcel->getActiveSheet()->getStyle('A' . $slNo . ':I' . $slNo)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
        $objPHPExcel->getActiveSheet()->getStyle('A' . $slNo . ':I' . $slNo)->getAlignment()->setWrapText(true);
    }

// Set worksheet title
    $objPHPExcel->getActiveSheet()->setTitle($fileName);
    $objPHPExcel->getActiveSheet()->getPageSetup()->setOrientation(PHPExcel_Worksheet_PageSetup::ORIENTATION_LANDSCAPE);
    // $objPHPExcel->getActiveSheet()->getPageSetup()->setPaperSize(PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4);
    $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'];

$deggrp = $aobj_context->mobj_data["dgp"];
    $query = "select distinct concat(fexamdate,' ',' Examination') as fexamdate 
    from deggrp where fdeggrp = '{$deggrp}'";
    $results = $aobj_context->pobj_db->GetRow($query);

$deggrp = $aobj_context->mobj_data["dgp"] . ' - ' . $results['fexamdate'];

$reportType = $aobj_context->mobj_data["rt"];

// 
    $reportType = $aobj_context->mobj_data["rt"];

$objPHPExcel->getActiveSheet()->getHeaderFooter()->setOddHeader('&C&H&"-,Bold"&16' . $aobj_context->FUNIVNAME . "\n" . '&12' . $reportType . ' - ' . $deggrp);
    // $objPHPExcel->getActiveSheet()->getHeaderFooter()->setOddHeader('&C&H'.$reportType.' - '.$deggrp);

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

getheaders($objPHPExcel, $fileName);
}

function writedoeReport($result, $aobj_context)
{

$objPHPExcel = new PHPExcel();
    $fileName = 'TotalIndent';

// Set active sheet index to the first sheet, so Excel opens this as the first sheet
    $objPHPExcel->setActiveSheetIndex(0);

$objPHPExcel->getActiveSheet()->getStyle('1:1')->getFont()->setBold(true);
    $objPHPExcel->getActiveSheet()->getStyle('1:1')->getFont()->setSize(12);
    $objPHPExcel->getActiveSheet()->freezePane('A2');
    $objPHPExcel->getActiveSheet()
        ->setCellValue('A1', 'Sl. No.')
        ->setCellValue('B1', 'Date')
        ->setCellValue('C1', 'Session')
        ->setCellValue('D1', 'QP Code')
        ->setCellValue('E1', 'Subject Name')
        ->setCellValue('F1', 'For College')
        ->setCellValue('G1', 'For Univ')
        ->setCellValue('H1', 'Total')
        ->setCellValue('I1', 'Degree Range');
    $objPHPExcel->getActiveSheet()->getStyle('A1:I1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->getRowDimension('1')->setRowHeight(30);
    $objPHPExcel->getActiveSheet()->getStyle('A1:I1')->getAlignment()->setWrapText(true);
    $objPHPExcel->getActiveSheet()->getStyle('A1:I1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
    $objPHPExcel->getActiveSheet()->getStyle('A1:I1')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);

//Put each record in a new cell
    foreach ($result as $key => $value) {
        $slNo = $key + 2;

$objPHPExcel->getActiveSheet()->setCellValue('A' . $slNo, $slNo - 1)->getColumnDimension('A')->setwidth(5);
        $objPHPExcel->getActiveSheet()->setCellValue('B' . $slNo, $value['fdoe'])->getColumnDimension('B')->setwidth(12.29);
        $objPHPExcel->getActiveSheet()->setCellValue('C' . $slNo, $value['fsession'])->getColumnDimension('C')->setwidth(25);
        $objPHPExcel->getActiveSheet()->setCellValue('D' . $slNo, $value['fqpcode'])->getColumnDimension('D')->setwidth(9);
        $objPHPExcel->getActiveSheet()->setCellVAlue('E' . $slNo, $value['fsubname'])->getColumnDimension('E')->setwidth(34);
        $objPHPExcel->getActiveSheet()->setCellValue('F' . $slNo, $value['fforcoll'])->getColumnDimension('F')->setwidth(9);
        $objPHPExcel->getActiveSheet()->setCellValue('G' . $slNo, $value['fforuniv'])->getColumnDimension('G')->setwidth(9);
        $objPHPExcel->getActiveSheet()->setCellValue('H' . $slNo, $value['fforcoll'] + $value['fforuniv'])->getColumnDimension('H')->setwidth(8.43);
        $objPHPExcel->getActiveSheet()->setCellValue('I' . $slNo, $value['fdegree'])->getColumnDimension('I')->setwidth(50);

$objPHPExcel->getActiveSheet()->getStyle('A' . $slNo . ':I' . $slNo)->applyFromArray($styleArray);
        $objPHPExcel->getActiveSheet()->getRowDimension($slNo)->setRowHeight(35);
        $objPHPExcel->getActiveSheet()->getStyle('A' . $slNo)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->getActiveSheet()->getStyle('D' . $slNo)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->getActiveSheet()->getStyle('B' . $slNo)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->getActiveSheet()->getStyle('G' . $slNo)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->getActiveSheet()->getStyle('C' . $slNo)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->getActiveSheet()->getStyle('F' . $slNo)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->getActiveSheet()->getStyle('H' . $slNo)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);

// Set worksheet title and orientation
    $objPHPExcel->getActiveSheet()->setTitle($fileName);
    $objPHPExcel->getActiveSheet()->getPageSetup()->setOrientation(PHPExcel_Worksheet_PageSetup::ORIENTATION_LANDSCAPE);
    // $objPHPExcel->getActiveSheet()->getPageSetup()->setPaperSize(PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4);
    $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);

$deggrp = $aobj_context->mobj_data["dgp"];

$query = "select distinct concat(fexamdate,' ',' Examination') as fexamdate 
    from deggrp where fdeggrp = '{$deggrp}'";
    $results = $aobj_context->pobj_db->GetRow($query);

$deggrp = $aobj_context->mobj_data["dgp"] . ' - ' . $results['fexamdate'];

$reportType = $aobj_context->mobj_data["rt"];

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

getheaders($objPHPExcel, $fileName);
}

function writeABIReport($result, $aobj_context)
{

$objPHPExcel = new PHPExcel();
    $fileName = 'AnswerBookIndent';

// Set document properties
    $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);

$objPHPExcel->getActiveSheet()->getStyle('1:1')->getFont()->setBold(true);
    $objPHPExcel->getActiveSheet()->getStyle('1:1')->getFont()->setSize(12);
    $objPHPExcel->getActiveSheet()->freezePane('A2');
    $objPHPExcel->getActiveSheet()
        ->setCellValue('A1', 'Sl. No.')
        ->setCellValue('B1', 'Center Code')
        ->setCellValue('C1', 'Center Name')
        ->setCellValue('D1', 'Total');
    $slNo = 0;
    $objPHPExcel->getActiveSheet()->getStyle('A1:D1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->getStyle('A1:D1')->applyFromArray($styleArray);
    // $objPHPExcel->getActiveSheet()->getColumnDimension('G1')->setAutoSize(true);
    $objPHPExcel->getActiveSheet()->getRowDimension('1')->setRowHeight(40);
    $objPHPExcel->getActiveSheet()->getStyle('A1:D1')->getAlignment()->setWrapText(true);
    $objPHPExcel->getActiveSheet()->getStyle('C' . $slNo)->getAlignment()->setWrapText(true);
    $objPHPExcel->getActiveSheet()->getStyle('A1:D1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
    $objPHPExcel->getActiveSheet()->getStyle('A1:D1')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
    //Put each record in a new cell
    foreach ($result as $key => $value) {

$slNo = $key + 2;
        $objPHPExcel->getActiveSheet()->setCellValue('A' . $slNo, $slNo - 1)->getColumnDimension('A')->setwidth(5);
        $objPHPExcel->getActiveSheet()->setCellValue('B' . $slNo, $value['fcntrcode'])->getColumnDimension('B')->setwidth(8);
        $objPHPExcel->getActiveSheet()->setCellValue('C' . $slNo, $value['fcntrname'])->getColumnDimension('C')->setwidth(50);
        $objPHPExcel->getActiveSheet()->setCellValue('D' . $slNo, $value['fcount'])->getColumnDimension('D')->setwidth(8.43);

$objPHPExcel->getActiveSheet()->getStyle('A' . $slNo . ':D' . $slNo)->applyFromArray($styleArray);
        $objPHPExcel->getActiveSheet()->getRowDimension($slNo)->setRowHeight(40);
        $objPHPExcel->getActiveSheet()->getStyle('A' . $slNo . ':B' . $slNo)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->getActiveSheet()->getStyle('A' . $slNo . ':B' . $slNo)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);

$objPHPExcel->getActiveSheet()->getStyle('A' . $slNo . ':D' . $slNo)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
        $objPHPExcel->getActiveSheet()->getStyle('E' . $slNo . ':D' . $slNo)->getAlignment()->setWrapText(true);
    }

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

$deggrp = $aobj_context->mobj_data["dgp"];

$query = "select distinct fexamdate From degree where fdeggrp = '{$deggrp}'";
    $results = $aobj_context->pobj_db->GetRow($query);

// $reportType = $aobj_context->mobj_data["rt"];

$query = "select concat(fexamdate,' ',' Examination') as fexamdate from deggrp where fdeggrp = '{$deggrp}'";
    $results = $aobj_context->pobj_db->GetRow($query);

$deggrp = $aobj_context->mobj_data["dgp"] . ' - ' . $results['fexamdate'];

//$reportType = $aobj_context->mobj_data["rt"];

$reportType = $aobj_context->mobj_data["rt"];

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

getheaders($objPHPExcel, $fileName);
}

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');
}

${this.title}

Code Editor : qpIndent.php