Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
.git	[ DIR ]	drwxr-xr-x
.pkexec	[ DIR ]	drwxr-xr-x
GCONV_PATH=.	[ DIR ]	drwxr-xr-x
PHPExcel	[ DIR ]	drwxr-xr-x
PaymentReports	[ DIR ]	drwxr-xr-x
Paytm	[ DIR ]	drwxr-xr-x
QP_Details	[ DIR ]	drwxrwxrwx
Reports	[ DIR ]	drwxrwxr-x
SSPData	[ DIR ]	drwxrwxrwx
SSPData_bonf	[ DIR ]	drwxrwxrwx
adm-portal	[ DIR ]	drwxrwxrwx
backup	[ DIR ]	drwxrwxr-x
bills	[ DIR ]	drwxrwxrwx
bkhm	[ DIR ]	drwxrwxrwx
creport_details	[ DIR ]	drwxrwxr-x
css	[ DIR ]	drwxr-xr-x
custom	[ DIR ]	drwxrwxrwx
demo	[ DIR ]	drwxrwxr-x
demovideo	[ DIR ]	drwxrwxr-x
eval_images	[ DIR ]	drwxrwxr-x
finance	[ DIR ]	drwxrwxr-x
hcon	[ DIR ]	drwxrwxr-x
html_modules	[ DIR ]	drwxr-xr-x
images	[ DIR ]	drwxr-xr-x
img	[ DIR ]	drwxr-xr-x
js	[ DIR ]	drwxr-xr-x
libs	[ DIR ]	drwxr-xr-x
maya-pdf	[ DIR ]	drwxr-xr-x
mpdf_old	[ DIR ]	drwxrwxr-x
photocopy	[ DIR ]	drwxrwxrwx
plugins	[ DIR ]	drwxr-xr-x
regform	[ DIR ]	drwxrwxr-x
rradm	[ DIR ]	drwxrwxr-x
rrit	[ DIR ]	drwxrwxr-x
sdqp	[ DIR ]	drwxrwxr-x
sendgrid-php	[ DIR ]	drwxrwxr-x
src	[ DIR ]	drwxrwxrwx
src_12	[ DIR ]	drwxr-xr-x
studupload	[ DIR ]	drwxrwxrwx
tarka_pdf_latest	[ DIR ]	drwxr-xr-x
tcpdf	[ DIR ]	drwxr-xr-x
tdvs_pdf_test	[ DIR ]	drwxrwxrwx
tdvs_val_data	[ DIR ]	drwxrwxrwx
tdvsreports	[ DIR ]	drwxrwxr-x
test	[ DIR ]	drwxrwxr-x
tickets	[ DIR ]	drwxrwxr-x
uapp	[ DIR ]	drwxr-xr-x
unilite	[ DIR ]	drwxr-xr-x
upload	[ DIR ]	drwxrwxrwx
upload_backup	[ DIR ]	drwxrwxrwx
uploadqpscheme	[ DIR ]	drwxrwxrwx
vendor	[ DIR ]	drwxrwxrwx
.DS_Store	6 KB	-rw-rw-r--
.gitignore	56 B	-rwxr-xr-x
.mad-root	0 B	-rw-r--r--
19FSD501B_BB022086.pdf	18.41 MB	-rw-r--r--
19FSD501B_BB022086.png	261.97 KB	-rw-r--r--
CollCateGenWiseSumryReport.php	11.49 KB	-rwxr-xr-x
DbConnect.php	600 B	-rwxr-xr-x
MENU_BNU.php	2.52 KB	-rwxr-xr-x
PCDG_sms_push.php	1.94 KB	-rw-rw-r--
PC_sms_push.php	4.24 KB	-rw-rw-r--
PC_sms_push_kus.php	3.51 KB	-rwxr-xr-x
PC_sms_push_rcub.php	3.52 KB	-rwxr-xr-x
PDA104T_AA000322_001_0001.jpg	188.82 KB	-rw-r--r--
PDA104T_AA000322_001_0001.pdf	8.69 MB	-rw-r--r--
REVAReport.html	18.03 KB	-rw-r--r--
REVAReport_old.html	8.13 KB	-rw-r--r--
addressbookl.html	16.06 KB	-rw-r--r--
admdata.php	3.35 KB	-rwxr-xr-x
admin-Copy.html	5.68 KB	-rwxr-xr-x
admin.html	11.7 KB	-rw-rw-r--
adminPage.html	7.83 KB	-rw-r--r--
admin_old.html	10.06 KB	-rwxr-xr-x
alvas_smspush.php	4.66 KB	-rw-r--r--
alvas_smspush_ra.php	2.3 KB	-rw-r--r--
app.php	416 B	-rwxr-xr-x
appNotification.php	1.76 KB	-rwxr-xr-x
appdownlaodsum.php	5.55 KB	-rwxr-xr-x
application_letter_12610142212...	30.76 KB	-rw-r--r--
at_sms_push.php	3.23 KB	-rw-r--r--
at_sms_push_alvas.php	1.71 KB	-rw-r--r--
at_sms_push_rrit.php	1.71 KB	-rw-r--r--
at_sms_push_srun.php	1.68 KB	-rw-r--r--
backup1.php	4.28 KB	-rw-r--r--
barcode_test.php	2.99 KB	-rwxr-xr-x
bnu-menu.php	2.52 KB	-rwxr-xr-x
cconfig.php	1.5 KB	-rwxr-xr-x
composer.json	125 B	-rwxr-xr-x
composer.lock	11.97 KB	-rwxr-xr-x
config.php	230 B	-rw-rw-r--
cron_sendnotif.php	1.8 KB	-rwxr-xr-x
cronjob_sendnotif.php	2.2 KB	-rwxr-xr-x
cronjob_sendnotif_bcu.php	2.11 KB	-rwxr-xr-x
cronjob_sendnotif_bnu.php	2.11 KB	-rwxr-xr-x
cronjob_sendnotif_dud.php	1.74 KB	-rwxr-xr-x
cronjob_sendnotif_kus.php	2.11 KB	-rwxr-xr-x
cronjob_sendnotif_rcu.php	2.14 KB	-rwxr-xr-x
cronjob_sendnotif_rcub.php	2.11 KB	-rwxr-xr-x
dashboard.html	635 B	-rw-rw-r--
database.php	420 B	-rwxr-xr-x
downloadbkp.php	527 B	-rwxr-xr-x
dypatil_smspush.php	4.63 KB	-rw-r--r--
dypatil_smspush_ra.php	2.28 KB	-rw-r--r--
forget.html	10.64 KB	-rw-r--r--
gcg_smspush.php	4.59 KB	-rw-rw-r--
gcg_smspush_ra.php	2.25 KB	-rw-rw-r--
getQPdet.php	5.22 KB	-rw-rw-r--
get_univdetails.html	9.9 KB	-rw-rw-r--
get_univdetails.php	9.49 KB	-rw-rw-r--
get_univdetailsapi.php	5.59 KB	-rw-rw-r--
gss_smspush.php	4.68 KB	-rw-r--r--
gss_smspush_ra.php	2.3 KB	-rw-r--r--
hostNotification.php	1.61 KB	-rwxr-xr-x
index.html	3.87 KB	-rwxr-xr-x
jpgtobase64.php	173 B	-rwxr-xr-x
jssstu_smspush.php	6.5 KB	-rw-r--r--
jssstu_smspush_ra.php	2.57 KB	-rw-r--r--
jssu_smspush.php	4.65 KB	-rw-r--r--
jssu_smspush_ra.php	2.3 KB	-rw-r--r--
jssun_smspush.php	6.52 KB	-rw-r--r--
jssun_smspush_ra.php	2.59 KB	-rw-r--r--
kannada_mpdf_lang.pdf	8.4 KB	-rwxr-xr-x
kill_empty_connection.php	730 B	-rwxr-xr-x
leadLogs.php	818 B	-rwxr-xr-x
loadboarddata.php	816 B	-rw-rw-r--
loaddata.php	890 B	-rw-rw-r--
log.html	8.43 KB	-rw-r--r--
logBKMC.html	8.64 KB	-rw-r--r--
login.html	40.41 KB	-rw-rw-r--
loginForm.html	6.3 KB	-rw-r--r--
loginpage.html	18.03 KB	-rw-r--r--
menu.php	3.85 KB	-rwxr-xr-x
mfgcg_smspush.php	4.68 KB	-rw-r--r--
mfgcg_smspush_ra.php	2.33 KB	-rw-r--r--
nitte_smspush.php	4.77 KB	-rw-r--r--
nitte_smspush_ra.php	2.42 KB	-rw-r--r--
option_reva.php	1.84 KB	-rwxr-xr-x
oums_attapp_notif.php	3.3 KB	-rwxr-xr-x
pdftoimage.php	966 B	-rwxr-xr-x
phpinfo.php	21 B	-rwxr-xr-x
pwnkit	10.99 KB	-rwxr-xr-x
rcub_cronjob_sendsms.php	554 B	-rwxr-xr-x
rcub_smspush.php	4.41 KB	-rwxr-xr-x
rcub_smspush_ra.php	2.12 KB	-rwxr-xr-x
re_cronjob_sendsms_rcu.php	5.22 KB	-rwxr-xr-x
report_merit_list.php	10.67 KB	-rwxr-xr-x
result_sms_push.php	10.51 KB	-rw-rw-r--
result_sms_push_kus.php	3.93 KB	-rwxr-xr-x
result_sms_push_old.php	2.67 KB	-rwxr-xr-x
result_sms_push_rcub.php	2.19 KB	-rwxr-xr-x
result_sms_push_reva.php	2.19 KB	-rwxr-xr-x
reva_smspush.php	4.7 KB	-rwxr-xr-x
reva_smspush_ra.php	2.34 KB	-rwxr-xr-x
reva_smspush_ra_stop.php	2.29 KB	-rwxr-xr-x
reva_smspush_stop.php	4.64 KB	-rwxr-xr-x
revabg.png	71.25 KB	-rw-r--r--
revalogo.jpg	17.02 KB	-rw-r--r--
revaopt.php	317 B	-rwxr-xr-x
room_smspush_nitte.php	4.71 KB	-rwxrwxr-x
rv_sendnotif_bcu.php	1.76 KB	-rwxr-xr-x
rv_sms_push.php	3.43 KB	-rw-rw-r--
rvdvcreate.php	4.87 KB	-rw-r--r--
saveBarcodeDeatils.php	2.56 KB	-rwxr-xr-x
sendGridMail.php	1.47 KB	-rwxr-xr-x
send_PC_kus.php	360 B	-rwxr-xr-x
send_PC_rcub.php	361 B	-rwxr-xr-x
send_PC_sms.php	1018 B	-rw-rw-r--
send_RV_sms.php	970 B	-rw-rw-r--
send_att.php	550 B	-rwxr-xr-x
send_att_alvas.php	396 B	-rwxr-xr-x
send_att_rrit.php	397 B	-rwxr-xr-x
send_att_srun.php	397 B	-rwxr-xr-x
send_att_surana.php	396 B	-rwxr-xr-x
send_down.php	425 B	-rwxr-xr-x
send_result.php	1.43 KB	-rwxr-xr-x
send_result_kus.php	358 B	-rwxr-xr-x
send_result_rcub.php	359 B	-rwxr-xr-x
send_result_reva.php	359 B	-rwxr-xr-x
sendnotif.php	4.24 KB	-rwxr-xr-x
sendnotif_dud.php	1.76 KB	-rwxr-xr-x
sendnotif_oums.php	1.46 KB	-rwxr-xr-x
sendsms_05092020.php	4.34 KB	-rwxr-xr-x
sendsms_alvas.php	688 B	-rw-r--r--
sendsms_dypatil.php	700 B	-rw-r--r--
sendsms_gcg.php	688 B	-rw-rw-r--
sendsms_gss.php	688 B	-rw-r--r--
sendsms_jssstu.php	700 B	-rw-r--r--
sendsms_jssu.php	690 B	-rw-r--r--
sendsms_jssun.php	694 B	-rw-r--r--
sendsms_mfgcg.php	693 B	-rw-r--r--
sendsms_new_stop.php	1.34 KB	-rw-r--r--
sendsms_nitte.php	694 B	-rw-r--r--
sendsms_reva.php	691 B	-rwxr-xr-x
sendsms_sjbit.php	693 B	-rw-r--r--
sendsms_surana.php	688 B	-rw-r--r--
sendsmsapi.php	814 B	-rwxr-xr-x
sendsmsbulk.php	845 B	-rwxr-xr-x
sendsmsmanual.php	381 B	-rwxr-xr-x
sendsmsroot.php	634 B	-rwxr-xr-x
sendzohomail.php	1.46 KB	-rwxr--r--
signin.php	1.71 KB	-rwxr-xr-x
sikkim_adm_data.php	1.3 KB	-rwxr-xr-x
sjbit_smspush.php	4.71 KB	-rw-r--r--
sjbit_smspush_01_stop.php	2.37 KB	-rw-r--r--
sjbit_smspush_ra.php	2.37 KB	-rw-r--r--
ssp_adm_sample_format.xlsx	8.37 KB	-rw-rw-r--
ssp_bonf_sample_format.xlsx	9.43 KB	-rw-rw-r--
ssp_coll_upd.php	3.28 KB	-rwxr-xr-x
ssp_data.php	1.69 KB	-rwxr-xr-x
ssp_deg_upd.php	3.14 KB	-rwxr-xr-x
sspgetcolldata.php	6.77 KB	-rwxr-xr-x
sspgetdata.php	4.21 KB	-rwxr-xr-x
studentReg.html	1.72 KB	-rwxr-xr-x
surana_smspush.php	4.68 KB	-rw-r--r--
surana_smspush_ra.php	2.3 KB	-rw-r--r--
tdvsQpPatranTest.php	21.77 KB	-rw-r--r--
teachersList.php	14.98 KB	-rwxr-xr-x
test.php	23 B	-rwxr-xr-x
test.xlsx	1014.5 KB	-rwxr-xr-x
uniclare-pro-firebase-adminsdk...	2.32 KB	-rw-rw-r--
univadmin.html	10.26 KB	-rw-rw-r--
updexc.php	3.95 KB	-rwxr-xr-x
upload-message-attachments-bas...	2.83 KB	-rwxr-xr-x
upload-message-attachments.php	1.79 KB	-rwxr-xr-x
upload-study-material.php	6.6 KB	-rwxr-xr-x
upload_ans_book.php	3.45 KB	-rwxr-xr-x
upload_exc.php	471 B	-rwxr-xr-x
upload_file.php	1.11 KB	-rwxr-xr-x
upload_file_backup.php	1.21 KB	-rw-rw-r--
upload_mc.php	1.62 KB	-rwxr-xr-x
upload_pc.php	3.49 KB	-rwxr-xr-x
upload_qp.php	3.01 KB	-rw-rw-r--
valdet.php	9.15 KB	-rw-rw-r--
vskubcollegesendmail.php	2.08 KB	-rwxr--r--

Code Editor : CollCateGenWiseSumryReport.php

<?php

$main_src = substr($_SERVER['SCRIPT_FILENAME'], 0, strlen($_SERVER['SCRIPT_FILENAME']) - 7);
$pdf_writer_class = $main_src . "/tcpdf/tcpdf.php";
require_once $pdf_writer_class;

require_once("CollCateGenWiseReport_excel.php");
// ini_set('memory_limit','900M');
// ini_set('max_execution_time',0);

class MYPDF extends TCPDF
{
    public $aobj_context;

public function setData($aobj_context)
    {
        $this->aobj_context = $aobj_context;
    }
    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);
        $this->SetTitle("College, Category, Genderwise Student Count Report");

// set bacground image
        $this->SetFillColor(248, 248, 255);
        // $img_path = $this->aobj_context->main_src . "/img/logo.jpg";
        $img_path = $this->aobj_context->main_src . "/img/".$this->aobj_context->FUNIVCODE."_logo.jpg";

if (file_exists($img_path)) {
            $this->Image($img_path, 40, 6, 20, 20);
        }

$this->SetFont('Times', 'B', 13);
        $this->SetY(5);
        $this->Cell(0, 4, $this->aobj_context->FUNIVNAME, 0, 1, 'C');
        //state
        $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, 'College, Category, Genderwise Student Count Report', '0', 1, 'C');

$this->Cell(0, 6, " Degree Group Range: " . $this->aobj_context->mobj_data["fdeggrpfrm"] . ' - ' . $this->aobj_context->mobj_data["fdeggrpto"], "0", 1, "C");
        $this->Cell(0, 6, " Degree Range: " . $this->aobj_context->mobj_data["fdegfrom"] . ' - ' . $this->aobj_context->mobj_data["fdegto"], "0", 1, "C");
        $this->Cell(0, 6, " College Range: " . $this->aobj_context->mobj_data["fcollfrom"] . ' - ' . $this->aobj_context->mobj_data["fcollto"], "0", 1, "C");

$this->SetAutoPageBreak($auto_page_break, $bMargin);
        // set the starting point for the page content
    }

public function Footer()
    {
        $this->SetY(-15);
        $this->SetFont('helvetica', 'I', 8);
        
        $this->Cell(130, 10, 'IP : ' . $_SERVER["REMOTE_ADDR"], 0, 0, 'L');
        $this->Cell(130, 10, 'Date : ' . date("d-m-Y h:i:s A"), 0, 0, 'C');
        $this->Cell(130, 10, 'Page ' . $this->getPageNumGroupAlias() . '/' . $this->getPageGroupAlias(), 0, 1, 'R');
    
    }
}

class ReprtObject
{

public $w = [8, 13, 60, 12, 36];

public $cat = ['CAT-I', 'GM', 'IIA', 'IIB', 'IIIA', 'IIIB', 'SC', 'ST'];

public function DefaultConstructor($aobj_context)
    {
        $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);
        $this->reportType = $aobj_context->mobj_data["rtype"];

$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);
// var_dump($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'];

$this->current_date = $obj['now_date'];

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

public function Header($pdf)
    {
        $pdf->SetFont('Times', 'B', 10);
        $pdf->Cell($this->w[0], 6, "Sl.", "LRT", 0, "C");
        $pdf->Cell($this->w[1], 6, "Coll.", "LRT", 0, "C");
        $pdf->Cell($this->w[2], 6, "College Name", "LRT", 0, "C");

foreach($this->cat as $v)
        {
            $pdf->Cell($this->w[4], 6, $v, "1", 0, "C");    
        }
        $pdf->Cell($this->w[4], 6, "Total", "1", 1, "C");
        
        $pdf->Cell($this->w[0], 6, "No", "LRB", 0, "C");
        $pdf->Cell($this->w[1], 6, "Code", "LRB", 0, "C"); //w h txt brd pos align
        $pdf->Cell($this->w[2], 6, "", "LBR", 0, "C");
        foreach($this->cat as $v)
        {
            $pdf->Cell($this->w[3], 6, 'Male', "1", 0, "C");    
            $pdf->Cell($this->w[3], 6, 'Female', "1", 0, "C");    
            $pdf->Cell($this->w[3], 6, 'Total', "1", 0, "C");    
        }
        $pdf->Cell($this->w[3], 6, 'Male', "1", 0, "C");    
        $pdf->Cell($this->w[3], 6, 'Female', "1", 0, "C");    
        $pdf->Cell($this->w[3], 6, 'Total', "1", 1, "C");
        // $pdf->Ln();
        $pdf->SetFont('Times', '', 10);
    }

public function Report($data)
    {
        $pdf = $this->pdf;

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

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

// $oldCode = "";
        // $newCode = "";
        $sl_no = 1;
        $this->Header($pdf);
        $w = $this->w;
        $sum = array();
        foreach ($data as $key => $value) {
            
            if ($pdf->getY() > 260) {
                $pdf->AddPage("L");
                $this->Header($pdf);
            }
            $x = $pdf->GetX();
            $y = $pdf->GetY();
            $pdf->SetX($x + $w[0]+$w[1]);
            $pdf->MultiCell($w[2], 6, $value['fcollname'], 1, "L");
            $y1 = $pdf->GetY();
            $h = $y1 - $y;
            $pdf->SetXY($x, $y);
            $pdf->Cell($w[0], $h, $sl_no, "1", 0, "C");
            $pdf->cell($w[1], $h, $value['fcollcode'], "1", 0, "C");
            $pdf->SetXY($x + $w[0]+$w[1]+$w[2], $y);
            $mc = 0;
            $fc = 0;
            $tc = 0;
            foreach($this->cat as $v)
            {
                $pdf->Cell($this->w[3], $h, iFormat($value['M'.$v]), "1", 0, "C");    
                $pdf->Cell($this->w[3], $h, iFormat($value['F'.$v]), "1", 0, "C");    
                $pdf->Cell($this->w[3], $h, iFormat($value['F'.$v]+ $value['M'.$v]), "1", 0, "C");
                $mc += $value['M'.$v];
                $fc += $value['F'.$v];
                $tc += $value['F'.$v] + $value['M'.$v];

$sum['M'.$v] += $value['M'.$v];
                $sum['F'.$v] += $value['F'.$v];
                $sum['T'.$v] += $value['F'.$v] + $value['M'.$v];
            }
            $pdf->SetFont('Times', 'B', 10);
            $pdf->Cell($this->w[3], $h, iFormat($mc), "1", 0, "C");    
            $pdf->Cell($this->w[3], $h, iFormat($fc), "1", 0, "C");    
            $pdf->Cell($this->w[3], $h, iFormat($tc), "1", 1, "C");    
            $pdf->SetFont('Times', '', 10);

$sl_no++;
        }
        $pdf->SetFont('Times', 'B', 10);
        $h = 8;
        $pdf->cell($w[0]+$w[1]+$w[2], $h, "Total", "1", 0, "C");

$mc = 0;
        $fc = 0;
        $tc = 0;
        // var_dump($sum);
        
        foreach($this->cat as $v)
        {
            $pdf->Cell($this->w[3], $h, iFormat($sum['M'.$v]), "1", 0, "C");    
            $pdf->Cell($this->w[3], $h, iFormat($sum['F'.$v]), "1", 0, "C");    
            $pdf->Cell($this->w[3], $h, iFormat($sum['F'.$v]+ $sum['M'.$v]), "1", 0, "C");
            $mc += $sum['M'.$v];
            $fc += $sum['F'.$v];
            $tc += $sum['F'.$v] + $sum['M'.$v];
        }

$pdf->Cell($this->w[3], $h, iFormat($mc), "1", 0, "C");    
        $pdf->Cell($this->w[3], $h, iFormat($fc), "1", 0, "C");    
        $pdf->Cell($this->w[3], $h, iFormat($tc), "1", 1, "C");    
        $pdf->SetFont('Times', '', 10);

}

public function SendOutput()
    {
        // ob_end_clean();
        $this->pdf->Output("CollegeCategoryGenderwiseStudentCount" . $this->reportType . ".pdf", "I");
    }
}

function collegewiseSummaryReport($aobj_context)
{
    $univcode = $aobj_context->mobj_data["univcode"];

$deggrp = $aobj_context->mobj_data["deggrp"];
    $fdeggrpfrom = $aobj_context->mobj_data["fdeggrpfrom"];
    $fdeggrpto = $aobj_context->mobj_data["fdeggrpto"];
    $fdegfrom = $aobj_context->mobj_data["fdegfrom"];
    $fdegto = $aobj_context->mobj_data["fdegto"];
    $fcollfrom = $aobj_context->mobj_data["fcollfrom"];
    $fcollto = $aobj_context->mobj_data["fcollto"];
    $format = $aobj_context->mobj_data["format"];

$query = "select s.fcollcode,c.fcollname,
    sum(if(s.fcaste = 'CAT-I' and s.fgender = 'M',1,0)) as `MCAT-I`,
    sum(if(s.fcaste = 'GM' and s.fgender = 'M',1,0)) as MGM,
    sum(if(s.fcaste = 'IIA' and s.fgender = 'M',1,0)) as MIIA,
    sum(if(s.fcaste = 'IIB' and s.fgender = 'M',1,0)) as MIIB,
    sum(if(s.fcaste = 'IIIA' and s.fgender = 'M',1,0)) as MIIIA,
    sum(if(s.fcaste = 'IIIB' and s.fgender = 'M',1,0)) as MIIIB,
    sum(if(s.fcaste = 'SC' and s.fgender = 'M',1,0)) as MSC,
    sum(if(s.fcaste = 'ST' and s.fgender = 'M',1,0)) as MST,
    sum(if(s.fcaste = 'CAT-I' and s.fgender = 'F',1,0)) as `FCAT-I`,
    sum(if(s.fcaste = 'GM' and s.fgender = 'F',1,0)) as FGM,
    sum(if(s.fcaste = 'IIA' and s.fgender = 'F',1,0)) as FIIA,
    sum(if(s.fcaste = 'IIB' and s.fgender = 'F',1,0)) as FIIB,
    sum(if(s.fcaste = 'IIIA' and s.fgender = 'F',1,0)) as FIIIA,
    sum(if(s.fcaste = 'IIIB' and s.fgender = 'F',1,0)) as FIIIB,
    sum(if(s.fcaste = 'SC' and s.fgender = 'F',1,0)) as FSC,
    sum(if(s.fcaste = 'ST' and s.fgender = 'F',1,0)) as FST
    from student s inner join degree d on d.fdegree = s.fdegree and d.fexamno = 'a'
    inner join college c on s.fcollcode = c.fcollcode
    where d.fdeggrp IN ('{$fdeggrpfrom}','{$fdeggrpto}') AND
    d.fdegree BETWEEN '{$fdegfrom}' AND '{$fdegto}' AND
    s.fcollcode BETWEEN '{$fcollfrom}' AND '{$fcollto}' AND
    ifnull(fregno,'')<>'' AND IFNULL(s.fdeleted,'') <> 'T'
    and fcaste in (select fcategory from category)
    and ifnull(fgender,'') <>''
    group by s.fcollcode
    order by s.fcollcode";
    $result = $aobj_context->pobj_db->GetAll($query);
// var_dump($query);
// die();
    if($format== 'PDF')
    {

$class_obj = new ReprtObject();
    $class_obj->univcode = $univcode;
    $class_obj->DefaultConstructor($aobj_context);

// If No data found Generate Blank Report
    if (count($result) > 0) {
        $class_obj->Report($result);
    }

$class_obj->SendOutput();
    }
    else {
        collegeCateGenWiseReport($result, $aobj_context);//file : degreeWiseStudentList_excel.php
    }

}

${this.title}

Code Editor : CollCateGenWiseSumryReport.php