Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
DYPIndent.php	6.77 KB	-rw-rw-r--
TDVSValuationReport.php	8.73 KB	-rw-rw-r--
generatebill.php	29.55 KB	-rw-r--r--
generatebillDownload.php	18.18 KB	-rw-rw-r--
generatebill_acu.php	24.14 KB	-rw-r--r--
generatebill_new.php	28.88 KB	-rw-r--r--
generatetadabill.php	18.4 KB	-rw-r--r--
generateworkdonereport.php	19.84 KB	-rw-r--r--
generateworkdonereport_gcg.php	19.35 KB	-rw-r--r--
getPanelViewReport.php	40 KB	-rw-r--r--
getPanelViewReportExcel.php	10.13 KB	-rw-r--r--
getQpStatsReport.php	41.58 KB	-rw-rw-r--
getnumword.php	7.45 KB	-rwxr-xr-x
photocopydownload.php	15.53 KB	-rw-rw-r--
qppatternreport.php	9.59 KB	-rw-r--r--
revaluationReport.php	19.03 KB	-rw-rw-r--
reviewercodeData.php	34.18 KB	-rw-rw-r--
tdvsDecodeReport.php	8.38 KB	-rw-rw-r--
tdvsDecodeReportExcel.php	6.72 KB	-rw-rw-r--
tdvsQpPatranTest.php	10.25 KB	-rw-r--r--
tdvs_TeachValReport.php	14.06 KB	-rw-rw-r--
tdvs_TeachWiseValReport.php	37.71 KB	-rw-rw-r--
tdvs_deviationdet.php	9.19 KB	-rw-rw-r--
tdvs_getQpNotStartedReprot.php	7.28 KB	-rw-rw-r--
tdvs_studentMarksReport.php	18.24 KB	-rw-rw-r--
tdvs_studentMarksReportCOWise....	15.84 KB	-rw-rw-r--
tdvs_studentMarksReportNew.php	11.64 KB	-rw-r--r--
tdvsmarkslist.php	34.84 KB	-rw-rw-r--
teachersList.php	15.47 KB	-rw-rw-r--

Code Editor : getQpStatsReport.php

<?php
ini_set('max_execution_time', 60);
$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);
    
    ob_end_clean();
    // ob_start();
    // 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_end_clean();
    $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
    
    $objWriter->save('php://output');
}

function reportAdmFeeSummary($result, $aobj_context)
{

$objPHPExcel = new PHPExcel();
    $fileName = 'Board wise Statistics';
    $objPHPExcel->getProperties()->setCreator("Me")
    ->setLastModifiedBy("Me")->setTitle("My Excel Sheet")
    ->setSubject("My Excel Sheet")->setDescription("Excel Sheet")
    ->setKeywords("Excel Sheet")->setCategory("Me");

$stype = $aobj_context->mobj_data["stype"];
    
    if($stype == 'boardwise')
        $fileName = 'Board wise Statistics';
    else
        $fileName = 'QP wise Statistics';
    // var_dump($stype);
    // die();
    // $objPHPExcel->setOutputEncoding('UTF-8');
    // Set active sheet index to the first sheet, so Excel opens this as the first sheet
    $objPHPExcel->setActiveSheetIndex(0);

$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);
    if($stype == 'boardwise')
    {
        $objPHPExcel->getActiveSheet()->getHeaderFooter()
        ->setOddHeader('&C&"-,Bold"&16' . $lobj_get_coll_name['FUNIVNAME']."\n"."Board Wise Statistics"."\n");
    }
    else 
    {
        $objPHPExcel->getActiveSheet()->getHeaderFooter()
        ->setOddHeader('&C&"-,Bold"&16' . $lobj_get_coll_name['FUNIVNAME']."\n"."QP Wise Statistics"."\n");
    }
    //->setOddHeader('&C&"-,Bold"&14' . "QP Wise Statistics");

// $objPHPExcel->getActiveSheet()->getHeaderFooter()
    // ->setOddHeader('&D&"-,Bold"&14' . "QP Wise Statistics");

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

// Add column headers and make them bold
    $styleArray = array(
        'borders' => array(
            'allborders' => array(
                'style' => PHPExcel_Style_Border::BORDER_THIN,
                'color' => array('argb' => '000000'),
            ),
        ),
    );

$alpha = ['A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 
                'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z', 'AA', 'AB', 'AC',
                'AD', 'AF', 'AE', 'AF', 'AG', 'AH'
            ];

$objPHPExcel->getActiveSheet()->getStyle('1:1')->getFont()->setBold(true);
    $objPHPExcel->getActiveSheet()->getStyle('1:1')->getFont()->setSize(12);
    $objPHPExcel->getActiveSheet()->freezePane('A1');
    if($stype == 'boardwise')
    {
        $objPHPExcel->getActiveSheet()->setCellValue('A1', 'Sl. No.');
        $objPHPExcel->getActiveSheet()->setCellValue('B1', 'Degree');
        $objPHPExcel->getActiveSheet()->setCellValue('C1', 'Board');
        $objPHPExcel->getActiveSheet()->setCellValue('D1', 'Board Name');
        $objPHPExcel->getActiveSheet()->setCellValue('E1', 'Total Scripts');
        $objPHPExcel->getActiveSheet()->setCellValue('F1', 'Valued');
        $objPHPExcel->getActiveSheet()->setCellValue('G1', 'Balance');
        $objPHPExcel->getActiveSheet()->setCellValue('H1', '% Valued');
        // $objPHPExcel->getActiveSheet()->setCellValue('I1', 'Decoded');
        // $objPHPExcel->getActiveSheet()->setCellValue('J1', 'Decoded Pending');
        // $objPHPExcel->getActiveSheet()->setCellValue('K1', '% Decoded');
        // $objPHPExcel->getActiveSheet()->setCellValue('L1', 'Remarks');

}else if($stype == 'boardsemwise')
    {
        $objPHPExcel->getActiveSheet()->setCellValue('A1', 'Sl. No.');
        $objPHPExcel->getActiveSheet()->setCellValue('B1', 'Degree');
        $objPHPExcel->getActiveSheet()->setCellValue('C1', 'Board');
        $objPHPExcel->getActiveSheet()->setCellValue('D1', 'Board Name');
        $objPHPExcel->getActiveSheet()->setCellValue('E1', 'Sem');
        $objPHPExcel->getActiveSheet()->setCellValue('F1', 'Total Scripts');
        $objPHPExcel->getActiveSheet()->setCellValue('G1', 'Valued');
        $objPHPExcel->getActiveSheet()->setCellValue('H1', 'Balance');
        $objPHPExcel->getActiveSheet()->setCellValue('I1', '% Valued');
        // $objPHPExcel->getActiveSheet()->setCellValue('J1', 'Decoded');
        // $objPHPExcel->getActiveSheet()->setCellValue('K1', 'Decoded Pending');
        // $objPHPExcel->getActiveSheet()->setCellValue('L1', '% Decoded');
        // $objPHPExcel->getActiveSheet()->setCellValue('M1', 'Remarks');
    }elseif($stype === 'degreesemwise'){
        $objPHPExcel->getActiveSheet()->setCellValue('A1', 'Sl. No.');
        $objPHPExcel->getActiveSheet()->setCellValue('B1', 'Degree');
        $objPHPExcel->getActiveSheet()->setCellValue('C1', 'Board');
        $objPHPExcel->getActiveSheet()->setCellValue('D1', 'Board Name');
        $objPHPExcel->getActiveSheet()->setCellValue('E1', 'Sem');
        $objPHPExcel->getActiveSheet()->setCellValue('F1', 'Total Scripts');
        $objPHPExcel->getActiveSheet()->setCellValue('G1', 'Valued');
        $objPHPExcel->getActiveSheet()->setCellValue('H1', 'Balance');
        $objPHPExcel->getActiveSheet()->setCellValue('I1', '% Valued');
    }
    else
    {        
        $objPHPExcel->getActiveSheet()->setCellValue('A1', 'Sl. No.');
        $objPHPExcel->getActiveSheet()->setCellValue('B1', 'Board');
        $objPHPExcel->getActiveSheet()->setCellValue('C1', 'QP Code');
        $objPHPExcel->getActiveSheet()->setCellValue('D1', 'Sbject Name');
        $objPHPExcel->getActiveSheet()->setCellValue('E1', 'Total Scripts');
        $objPHPExcel->getActiveSheet()->setCellValue('F1', 'Faculty');
        $objPHPExcel->getActiveSheet()->setCellValue('G1', 'Mobile No.');
        $objPHPExcel->getActiveSheet()->setCellValue('H1', 'Email');
        $objPHPExcel->getActiveSheet()->setCellValue('I1', 'Valued');
        $objPHPExcel->getActiveSheet()->setCellValue('J1', 'Balance');
        $objPHPExcel->getActiveSheet()->setCellValue('K1', '% Valued');
        // $objPHPExcel->getActiveSheet()->setCellValue('L1', 'Decoded');
        // $objPHPExcel->getActiveSheet()->setCellValue('M1', 'Decoded Pending');
        // $objPHPExcel->getActiveSheet()->setCellValue('N1', '% Decoded');
        // $objPHPExcel->getActiveSheet()->setCellValue('O1', 'Remarks');
    }
  
    
    
    $objPHPExcel->getActiveSheet()->getStyle('A1:K1')->applyFromArray($styleArray);
    // $objPHPExcel->getActiveSheet()->getColumnDimension('G1')->setAutoSize(true);
    $objPHPExcel->getActiveSheet()->getRowDimension('1')->setRowHeight(20);

$objPHPExcel->getActiveSheet()->getStyle('A1:O1')->getAlignment()->setWrapText(true);
    $objPHPExcel->getActiveSheet()->getStyle('A1:O1')->getAlignment()
                ->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
    $objPHPExcel->getActiveSheet()->getStyle('A1:O1')->getAlignment()
                ->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);

// $objPHPExcel->getActiveSheet()->freezePane('A1');  
    $objPHPExcel->getActiveSheet()->freezePane('A2');

$j = 2;
    $slNo = 1;
    $sum = array();
    $totans=0;
    $totval=0;
    $totbal=0;
    $decoded = 0;
    $decodep = 0;
    // setlocale(LC_ALL, 'hi_IN');
    // var_dump($result);die();

foreach ($result as $key => $value) {

$objPHPExcel->getActiveSheet()->setCellValue('A' . $j, $slNo)
        ->getColumnDimension('A')->setwidth(7.15);

if($stype == 'boardwise')
        {
            $objPHPExcel->getActiveSheet()->setCellValue('B' . $j, $value['fdegree'])
            ->getColumnDimension('B')->setwidth(10.43);

$objPHPExcel->getActiveSheet()->setCellValue('E' . $j, $value['ftotal'])
            ->getColumnDimension('E')->setwidth(15);

$objPHPExcel->getActiveSheet()->setCellValue('F' . $j, $value['fsubmit'])
            ->getColumnDimension('E')->setwidth(15);

$objPHPExcel->getActiveSheet()->setCellValue('G' . $j, $value['fbalance'])
            ->getColumnDimension('F')->setwidth(15);

if($value['fpercent'] == '100')
            {
                $styleArray2 = array(
                    'font'  => array(
                        'bold'  => true,
                        'color' => array('rgb' => '0E9B12'),
                        'name'  => 'Verdana'
                    ));
                $objPHPExcel->getActiveSheet()->getStyle('H'.$j)->applyFromArray($styleArray2);
            }    
            
            $objPHPExcel->getActiveSheet()->setCellValue('H' . $j, $value['fpercent'])
            ->getColumnDimension('H')->setwidth(15);

// $objPHPExcel->getActiveSheet()->setCellValue('I' . $j, $value['decodedone'])
            // ->getColumnDimension('I')->setwidth(15);
            // $objPHPExcel->getActiveSheet()->setCellValue('J' . $j, $value['decodepend'])
            // ->getColumnDimension('J')->setwidth(15);
            
            // if($value['done_per'] == '100')
            // {
            //     $styleArray2 = array(
            //         'font'  => array(
            //             'bold'  => true,
            //             'color' => array('rgb' => '0E9B12'),
            //             'name'  => 'Verdana'
            //         ));
            //     $objPHPExcel->getActiveSheet()->getStyle('K'.$j)->applyFromArray($styleArray2);
            // }

// $objPHPExcel->getActiveSheet()->setCellValue('K' . $j, $value['done_per'])
            // ->getColumnDimension('K')->setwidth(15);
            // $remarks = "";
            // if($value['done_per'] == '100' && $value['fpercent'] == '100')
            // {
            //     $remarks = "VALUATION and DECODING Completed";
            //     $styleArray2 = array(
            //         'font'  => array(
            //             'bold'  => true,
            //             'color' => array('rgb' => '0E9B12'),
            //             'name'  => 'Verdana'
            //         ));
            //     $objPHPExcel->getActiveSheet()->getStyle('L'.$j)->applyFromArray($styleArray2);
            // }else if($value['done_per'] == '100' && $value['fpercent'] != '100')
            // {
            //     $remarks = "DECODING Completed and VALUATION Pending";
                
            //     $styleArray2 = array(
            //         'font'  => array(
            //             'bold'  => true,
            //             'color' => array('rgb' => 'FF7B22'),
            //             'name'  => 'Verdana'
            //         ));
            //     $objPHPExcel->getActiveSheet()->getStyle('L'.$j)->applyFromArray($styleArray2);

// }else if($value['fpercent'] == '100' && $value['done_per'] != '100')
            // {
            //     $remarks = "VALUATION Completed and DECODING Pending";
            //     $styleArray2 = array(
            //         'font'  => array(
            //             'bold'  => true,
            //             'color' => array('rgb' => 'FF7B22'),
            //             'name'  => 'Verdana'
            //         ));
            //     $objPHPExcel->getActiveSheet()->getStyle('L'.$j)->applyFromArray($styleArray2);
            // }else
            // {
            //     $remarks = "VALUATION and DECODING Pending";
            // }

// $objPHPExcel->getActiveSheet()->setCellValue('L' . $j, $remarks)
            // ->getColumnDimension('K')->setwidth(30);

}else if($stype == 'boardsemwise')
        {
            $objPHPExcel->getActiveSheet()->setCellValue('B' . $j, $value['fdegree'])
            ->getColumnDimension('B')->setwidth(10.43);

$objPHPExcel->getActiveSheet()->setCellValue('E' . $j, $value['sem'])
            ->getColumnDimension('E')->setwidth(15);

$objPHPExcel->getActiveSheet()->setCellValue('F' . $j, $value['ftotal'])
            ->getColumnDimension('F')->setwidth(15);

$objPHPExcel->getActiveSheet()->setCellValue('G' . $j, $value['fsubmit'])
            ->getColumnDimension('G')->setwidth(15);

$objPHPExcel->getActiveSheet()->setCellValue('H' . $j, $value['fbalance'])
            ->getColumnDimension('H')->setwidth(15);

if($value['fpercent'] == '100')
            {
                $styleArray2 = array(
                    'font'  => array(
                        'bold'  => true,
                        'color' => array('rgb' => '0E9B12'),
                        'name'  => 'Verdana'
                    ));
                $objPHPExcel->getActiveSheet()->getStyle('I'.$j)->applyFromArray($styleArray2);
            }    
            
            $objPHPExcel->getActiveSheet()->setCellValue('I' . $j, $value['fpercent'])
            ->getColumnDimension('I')->setwidth(15);

// $objPHPExcel->getActiveSheet()->setCellValue('J' . $j, $value['decodedone'])
            // ->getColumnDimension('J')->setwidth(15);
            // $objPHPExcel->getActiveSheet()->setCellValue('K' . $j, $value['decodepend'])
            // ->getColumnDimension('K')->setwidth(15);
            
            // if($value['done_per'] == '100')
            // {
            //     $styleArray2 = array(
            //         'font'  => array(
            //             'bold'  => true,
            //             'color' => array('rgb' => '0E9B12'),
            //             'name'  => 'Verdana'
            //         ));
            //     $objPHPExcel->getActiveSheet()->getStyle('L'.$j)->applyFromArray($styleArray2);
            // }

// $objPHPExcel->getActiveSheet()->setCellValue('L' . $j, $value['done_per'])
            // ->getColumnDimension('L')->setwidth(15);
            // $remarks = "";
            // if($value['done_per'] == '100' && $value['fpercent'] == '100')
            // {
            //     $remarks = "VALUATION and DECODING Completed";
            //     $styleArray2 = array(
            //         'font'  => array(
            //             'bold'  => true,
            //             'color' => array('rgb' => '0E9B12'),
            //             'name'  => 'Verdana'
            //         ));
            //     $objPHPExcel->getActiveSheet()->getStyle('M'.$j)->applyFromArray($styleArray2);
            // }else if($value['done_per'] == '100' && $value['fpercent'] != '100')
            // {
            //     $remarks = "DECODING Completed and VALUATION Pending";
                
            //     $styleArray2 = array(
            //         'font'  => array(
            //             'bold'  => true,
            //             'color' => array('rgb' => 'FF7B22'),
            //             'name'  => 'Verdana'
            //         ));
            //     $objPHPExcel->getActiveSheet()->getStyle('M'.$j)->applyFromArray($styleArray2);

// }else if($value['fpercent'] == '100' && $value['done_per'] != '100')
            // {
            //     $remarks = "VALUATION Completed and DECODING Pending";
            //     $styleArray2 = array(
            //         'font'  => array(
            //             'bold'  => true,
            //             'color' => array('rgb' => 'FF7B22'),
            //             'name'  => 'Verdana'
            //         ));
            //     $objPHPExcel->getActiveSheet()->getStyle('M'.$j)->applyFromArray($styleArray2);
            // }else
            // {
            //     $remarks = "VALUATION and DECODING Pending";
            // }

// $objPHPExcel->getActiveSheet()->setCellValue('M' . $j, $remarks)
            // ->getColumnDimension('L')->setwidth(30);
        }else if($stype == 'degreesemwise')
        {
            $objPHPExcel->getActiveSheet()->setCellValue('B' . $j, $value['fdegree'])
            ->getColumnDimension('B')->setwidth(10.43);

$objPHPExcel->getActiveSheet()->setCellValue('E' . $j, $value['sem'])
            ->getColumnDimension('E')->setwidth(15);

$objPHPExcel->getActiveSheet()->setCellValue('F' . $j, $value['ftotal'])
            ->getColumnDimension('F')->setwidth(15);

$objPHPExcel->getActiveSheet()->setCellValue('G' . $j, $value['fsubmit'])
            ->getColumnDimension('G')->setwidth(15);

$objPHPExcel->getActiveSheet()->setCellValue('H' . $j, $value['fbalance'])
            ->getColumnDimension('H')->setwidth(15);

if($value['perct'] == '100')
            {
                $styleArray2 = array(
                    'font'  => array(
                        'bold'  => true,
                        'color' => array('rgb' => '0E9B12'),
                        'name'  => 'Verdana'
                    ));
                $objPHPExcel->getActiveSheet()->getStyle('I'.$j)->applyFromArray($styleArray2);
            }    
            
            $objPHPExcel->getActiveSheet()->setCellValue('I' . $j, $value['perct'])
            ->getColumnDimension('I')->setwidth(15);
        }
        else
        {

$objPHPExcel->getActiveSheet()->setCellValue('B' . $j, $value['fboard'])
            ->getColumnDimension('B')->setwidth(10.43);

$objPHPExcel->getActiveSheet()->setCellValue('C' . $j, $value['fqpcode'])
            ->getColumnDimension('C')->setwidth(10.43);
            
            $objPHPExcel->getActiveSheet()->setCellValue('D' . $j, $value['fsubname'])
            ->getColumnDimension('D')->setwidth(50);
    
            $objPHPExcel->getActiveSheet()->setCellValue('E' . $j, $value['ftotal'])
            ->getColumnDimension('E')->setwidth(15);

$objPHPExcel->getActiveSheet()->setCellValue('F' . $j, $value['Teachname'])
            ->getColumnDimension('F')->setwidth(50);

$objPHPExcel->getActiveSheet()->setCellValue('G' . $j, $value['fmobile'])
            ->getColumnDimension('G')->setwidth(50);

$objPHPExcel->getActiveSheet()->setCellValue('H' . $j, $value['femail'])
            ->getColumnDimension('H')->setwidth(50);
    
            $objPHPExcel->getActiveSheet()->setCellValue('I' . $j, $value['fsubmit'])
            ->getColumnDimension('I')->setwidth(15);
    
            $objPHPExcel->getActiveSheet()->setCellValue('J' . $j, $value['fbalance'])
            ->getColumnDimension('J')->setwidth(15);

if($value['fpercent'] == '100')
            {
                $styleArray2 = array(
                    'font'  => array(
                        'bold'  => true,
                        'color' => array('rgb' => '0E9B12'),
                        'name'  => 'Verdana'
                    ));
                $objPHPExcel->getActiveSheet()->getStyle('K'.$j)->applyFromArray($styleArray2);
            }

$objPHPExcel->getActiveSheet()->setCellValue('K' . $j, $value['fpercent'])
            ->getColumnDimension('K')->setwidth(15);

// $objPHPExcel->getActiveSheet()->setCellValue('L' . $j, $value['decodedone'])
            // ->getColumnDimension('L')->setwidth(15);

// $objPHPExcel->getActiveSheet()->setCellValue('M' . $j, $value['decodepend'])
            // ->getColumnDimension('M')->setwidth(15);

// if($value['done_per'] == '100')
            // {
            //     $styleArray2 = array(
            //         'font'  => array(
            //             'bold'  => true,
            //             'color' => array('rgb' => '0E9B12'),
            //             'name'  => 'Verdana'
            //         ));
            //     $objPHPExcel->getActiveSheet()->getStyle('N'.$j)->applyFromArray($styleArray2);
            // }

// $objPHPExcel->getActiveSheet()->setCellValue('N' . $j, $value['done_per'])
            // ->getColumnDimension('N')->setwidth(15);

// $remarks = "";
            // if($value['done_per'] == '100' && $value['fpercent'] == '100')
            // {
            //     $remarks = "VALUATION and DECODING Completed";

//     $styleArray2 = array(
            //         'font'  => array(
            //             'bold'  => true,
            //             'color' => array('rgb' => '0E9B12'),
            //             'name'  => 'Verdana'
            //         ));
            //     $objPHPExcel->getActiveSheet()->getStyle('O'.$j)->applyFromArray($styleArray2);

// }else if($value['done_per'] == '100' && $value['fpercent'] != '100')
            // {
            //     $remarks = "DECODING Completed and VALUATION Pending";
            //     $styleArray2 = array(
            //         'font'  => array(
            //             'bold'  => true,
            //             'color' => array('rgb' => 'FF7B22'),
            //             'name'  => 'Verdana'
            //         ));
            //     $objPHPExcel->getActiveSheet()->getStyle('O'.$j)->applyFromArray($styleArray2);
            // }else if($value['fpercent'] == '100' && $value['done_per'] != '100')
            // {
            //     $remarks = "VALUATION Completed and DECODING Pending";
            //     $styleArray2 = array(
            //         'font'  => array(
            //             'bold'  => true,
            //             'color' => array('rgb' => 'FF7B22'),
            //             'name'  => 'Verdana'
            //         ));
            //     $objPHPExcel->getActiveSheet()->getStyle('O'.$j)->applyFromArray($styleArray2);
            // }else
            // {
            //     $remarks = "VALUATION and DECODING Pending";
            // }

// $objPHPExcel->getActiveSheet()->setCellValue('O' . $j, $remarks)
            // ->getColumnDimension('O')->setwidth(30);

}

$totans = $totans + $value['ftotal'];
        $totval = $totval + $value['fsubmit'];
        $totbal = $totbal + $value['fbalance'];
        $decoded = $decoded + $value['decodedone'];
        $decodep = $decodep + $value['decodepend'];

$objPHPExcel->getActiveSheet()->getRowDimension($j)->setRowHeight(20);
        $j++;$slNo++;
     
    }
    if($stype == 'boardwise')
    {
        $objPHPExcel->getActiveSheet()->setCellValue('B' . $j, '')
        ->getColumnDimension('B')->setwidth(10.43);

$objPHPExcel->getActiveSheet()->setCellValue('C' . $j, '')
        ->getColumnDimension('C')->setwidth(10.43);
        
        $objPHPExcel->getActiveSheet()->setCellValue('D' . $j, 'Total')
        ->getColumnDimension('D')->setwidth(50);

$objPHPExcel->getActiveSheet()->setCellValue('E' . $j, $totans)
        ->getColumnDimension('E')->setwidth(15);

$objPHPExcel->getActiveSheet()->setCellValue('F' . $j, $totval)
        ->getColumnDimension('F')->setwidth(15);

$objPHPExcel->getActiveSheet()->setCellValue('G' . $j, $totbal)
        ->getColumnDimension('G')->setwidth(15);

$valper = round(($totval / $totans)*100,2);
        
        $objPHPExcel->getActiveSheet()->setCellValue('H' . $j, $valper)
        ->getColumnDimension('H')->setwidth(15);

// $objPHPExcel->getActiveSheet()->setCellValue('I' . $j, $decoded)
        // ->getColumnDimension('I')->setwidth(15);

// $objPHPExcel->getActiveSheet()->setCellValue('J' . $j, $decodep)
        // ->getColumnDimension('J')->setwidth(15);

// $decodeper = round(($decoded / $totans)*100,2);
        // $objPHPExcel->getActiveSheet()->setCellValue('K' . $j, "")
        // ->getColumnDimension('K')->setwidth(15);
    }else if($stype == 'boardsemwise')
    {
        $objPHPExcel->getActiveSheet()->setCellValue('B' . $j, '')
        ->getColumnDimension('B')->setwidth(10.43);

$objPHPExcel->getActiveSheet()->setCellValue('E' . $j, '')
        ->getColumnDimension('E')->setwidth(15);

$objPHPExcel->getActiveSheet()->setCellValue('F' . $j, $totans)
        ->getColumnDimension('F')->setwidth(15);

$objPHPExcel->getActiveSheet()->setCellValue('G' . $j, $totval)
        ->getColumnDimension('G')->setwidth(15);

$objPHPExcel->getActiveSheet()->setCellValue('H' . $j, $totbal)
        ->getColumnDimension('H')->setwidth(15);

$valper = round(($totval / $totans)*100,2);
        
        $objPHPExcel->getActiveSheet()->setCellValue('I' . $j, $valper)
        ->getColumnDimension('I')->setwidth(15);

// $objPHPExcel->getActiveSheet()->setCellValue('J' . $j, $decoded)
        // ->getColumnDimension('J')->setwidth(15);
        // $objPHPExcel->getActiveSheet()->setCellValue('K' . $j, $decodep)
        // ->getColumnDimension('K')->setwidth(15);
        
        // $decodeper = round(($decoded / $totans)*100,2);

// $objPHPExcel->getActiveSheet()->setCellValue('L' . $j, "")
        // ->getColumnDimension('L')->setwidth(15);

}
    else if($stype == 'degreesemwise')
    {
        $objPHPExcel->getActiveSheet()->setCellValue('B' . $j, '')
        ->getColumnDimension('B')->setwidth(10.43);

$objPHPExcel->getActiveSheet()->setCellValue('E' . $j, '')
        ->getColumnDimension('E')->setwidth(15);

$objPHPExcel->getActiveSheet()->setCellValue('F' . $j, $totans)
        ->getColumnDimension('F')->setwidth(15);

$objPHPExcel->getActiveSheet()->setCellValue('G' . $j, $totval)
        ->getColumnDimension('G')->setwidth(15);

$objPHPExcel->getActiveSheet()->setCellValue('H' . $j, $totbal)
        ->getColumnDimension('H')->setwidth(15);

$valper = round(($totval / $totans)*100,2);
        
        $objPHPExcel->getActiveSheet()->setCellValue('I' . $j, $valper)
        ->getColumnDimension('I')->setwidth(15);

}
    else
    {
             $objPHPExcel->getActiveSheet()->setCellValue('B' . $j, "")
            ->getColumnDimension('B')->setwidth(10.43);

$objPHPExcel->getActiveSheet()->setCellValue('C' . $j, "")
            ->getColumnDimension('C')->setwidth(10.43);
            
            $objPHPExcel->getActiveSheet()->setCellValue('D' . $j, 'Total')
            ->getColumnDimension('D')->setwidth(50);
    
            $objPHPExcel->getActiveSheet()->setCellValue('E' . $j, $totans)
            ->getColumnDimension('E')->setwidth(15);

$objPHPExcel->getActiveSheet()->setCellValue('F' . $j, "")
            ->getColumnDimension('F')->setwidth(50);

$objPHPExcel->getActiveSheet()->setCellValue('G' . $j, "")
            ->getColumnDimension('G')->setwidth(50);

$objPHPExcel->getActiveSheet()->setCellValue('H' . $j, "")
            ->getColumnDimension('H')->setwidth(50);

$objPHPExcel->getActiveSheet()->setCellValue('I' . $j, $totval)
            ->getColumnDimension('I')->setwidth(15);
    
            $objPHPExcel->getActiveSheet()->setCellValue('J' . $j, $totbal)
            ->getColumnDimension('J')->setwidth(15);

$valper = round(($totval / $totans)*100,2);

$objPHPExcel->getActiveSheet()->setCellValue('K' . $j, $valper)
            ->getColumnDimension('K')->setwidth(15);

// $objPHPExcel->getActiveSheet()->setCellValue('L' . $j, $decoded)
            // ->getColumnDimension('L')->setwidth(15);
            // $objPHPExcel->getActiveSheet()->setCellValue('M' . $j, $decodep)
            // ->getColumnDimension('M')->setwidth(15);
            // $decodeper = round(($decoded / $totans)*100,2);
        
            // $objPHPExcel->getActiveSheet()->setCellValue('N' . $j, "")
            // ->getColumnDimension('N')->setwidth(30);

}

// var_dump($totamt);die();

$objPHPExcel->getActiveSheet()->getStyle('A2' . ':K' . $j)->applyFromArray($styleArray);

$objPHPExcel->getActiveSheet()->getStyle('A2'.':K' . $j)->getAlignment()
    ->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);

$objPHPExcel->getActiveSheet()->getStyle('A2'.':K' . $j)->getAlignment()
    ->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);

$objPHPExcel->getActiveSheet()->getRowDimension($j)->setRowHeight(20);
    
    $objPHPExcel->getActiveSheet()->getStyle('D2'.':D' . $j)->getAlignment()
    ->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
    
    $objPHPExcel->getActiveSheet()->getStyle('F2'.':H' . $j)->getAlignment()
    ->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);

$objPHPExcel->getActiveSheet()->getStyle('A3' . ':K' . $j)->getAlignment()
    ->setWrapText(true);

// $objPHPExcel->getActiveSheet()->setCellValue('G'.$j, moneyFormatIndia($totamt));
    // $objPHPExcel->getActiveSheet()->setCellValue('F'.$j, moneyFormatIndia($totapp));

// $objPHPExcel->getActiveSheet()->getStyle('A'.$j.':G'.$j)->getFont()->setBold(true);
    // $objPHPExcel->getActiveSheet()->getStyle('A'.$j.':G'.$j)->getFont()->setSize(12);
    
    // $objPHPExcel->getActiveSheet()->mergeCells('A'.$j.':E'.$j)->setCellValue('A'.$j, 'Total');

// $objPHPExcel->getActiveSheet()->getStyle('G2:G'.$j)->getNumberFormat()->setFormatCode("#,##0");
    // $objPHPExcel->getActiveSheet()->getStyle('F'.$j)->getNumberFormat()->setFormatCode("#,##0");
    getheaders($objPHPExcel, $fileName);
}

function getQpStatsReport($aobj_context) {

$fdeggrp = $aobj_context->mobj_data["fdeggrp"];
    $fboard = $aobj_context->mobj_data["fboard"];  
    $fqpcodefrm = $aobj_context->mobj_data["fqpcodefrm"];
    $fqpcodeto = $aobj_context->mobj_data["fqpcodeto"];
    $stype = trim($aobj_context->mobj_data["stype"]);
    $fvalno = trim($aobj_context->mobj_data["fvalno"]);
    $status = trim($aobj_context->mobj_data["status"]);
    $fdegree = trim($aobj_context->mobj_data["fdegree"]);
    $ssem = trim($aobj_context->mobj_data["ssem"]);
    
    // var_dump($status);die();
    $cond = "";
    $cond1 = "";
    if ($fdeggrp == "All") {
        $cond = "";
    } else {
      $cond = "and  dg.fdeggrp = '{$fdeggrp}'";
    }

if ($fboard == "All") {
      $cond1 = "";
    } else {
      $cond1 = "and  qp.fboard = '{$fboard}'";
    } 
    if($fdegree == "All"){
        $degcond = "";
    }else{
        $degcond ="and deg.fdegree = '{$fdegree}'";
    }
    if($ssem == "All"){
        $semcond = "";
    }else{
      $semcond ="and  qp.fexamno = '{$ssem}'";
    }
    
    if ( strtolower($status) == "valued") {
        $constatus = "and ifnull(ts.fstatus,'') = 'final'";
    } else if (strtolower($status) == "pending") {
        $constatus = "and ifnull(ts.fstatus,'') <> 'final'";
    }else if(strtolower($status) == "rejected")
    {
        $constatus = "and ifnull(ts.fstatus,'') = 'REJECTED'";
    }
    else{
        $constatus = "";
    }
    
    
    if($stype == 'boardwise')
    {
        $query = "select  mb.fboard as fqpcode, mb.fboardname as fsubname, count(*)  as ftotal,
        qp.fboard,
        sum(case when ifnull(ts.fstatus,'')='final' then 1 else 0 end) as fsubmit,
        sum(case when ifnull(ts.fstatus,'')='rejected' then 1 else 0 end) as freject,
        sum(case when ifnull(ts.fstatus,'')='assigned' then 1 else 0 end) as fassign,
        (count(*) - 
        sum(case when ifnull(ts.fstatus,'')='final' then 1 else 0 end) ) as fbalance,
        TRUNCATE((sum(case when ifnull(ts.fstatus,'')='final' then 1 else 0 end) / (count(*))*100),2) as fpercent,
        sum(if(ifnull(de.fregno,'')='',1,0)) as decodepend,
        sum(if(ifnull(de.fregno,'')='',0,1)) as decodedone,
        TRUNCATE((sum(if(ifnull(de.fregno,'')='',0,1)) / count(*)*100),2) as done_per,'-' as fdegree
        from tdvs_deggrp dg  
        inner join tdvs_masqp qp on dg.fdeggrp = qp.fdeggrp 
        inner join tdvs_tabsum ts on ts.fqpcode = qp.fqpcode
        inner join tdvs_masboard mb on dg.fdeggrp = mb.fdeggrp and mb.fdeggrp = qp.fdeggrp and qp.fboard = mb.fboard
        left join tdvs_tabulate de on ts.fqpcode = de.fqpcode
        and ts.fregcode = de.fregcode
        
        where qp.fqpcode between '{$fqpcodefrm}' and '{$fqpcodeto}' and ts.fvalno = '{$fvalno}'
        {$cond1}
        {$cond}
        {$constatus} {$degcond} {$semcond}
        group by qp.fboard
        order by qp.fboard,qp.fqpcode";
    }else if($stype == 'boardsemwise')
    {
        $query = "select  mb.fboard as fqpcode, mb.fboardname as fsubname, qp.fexamno as sem, count(*)  as ftotal,
        qp.fboard,
        sum(case when ifnull(ts.fstatus,'')='final' then 1 else 0 end) as fsubmit,
        sum(case when ifnull(ts.fstatus,'')='rejected' then 1 else 0 end) as freject,
        sum(case when ifnull(ts.fstatus,'')='assigned' then 1 else 0 end) as fassign,
        (count(*) - 
        sum(case when ifnull(ts.fstatus,'')='final' then 1 else 0 end) ) as fbalance,
        TRUNCATE((sum(case when ifnull(ts.fstatus,'')='final' then 1 else 0 end) / (count(*))*100),2) as fpercent,
        sum(if(ifnull(de.fregno,'')='',1,0)) as decodepend,
        sum(if(ifnull(de.fregno,'')='',0,1)) as decodedone,
        TRUNCATE((sum(if(ifnull(de.fregno,'')='',0,1)) / count(*)*100),2) as done_per,'-' as fdegree
        from tdvs_deggrp dg  
        inner join tdvs_masqp qp on dg.fdeggrp = qp.fdeggrp 
        inner join tdvs_tabsum ts on ts.fqpcode = qp.fqpcode
        inner join tdvs_masboard mb on dg.fdeggrp = mb.fdeggrp and mb.fdeggrp = qp.fdeggrp and qp.fboard = mb.fboard
        left join tdvs_tabulate de on ts.fqpcode = de.fqpcode
        and ts.fregcode = de.fregcode
       
        where qp.fqpcode between '{$fqpcodefrm}' and '{$fqpcodeto}' and ts.fvalno = '{$fvalno}'
        {$cond1}
        {$cond}
        {$constatus} {$degcond} {$semcond}
        group by qp.fboard,qp.fexamno
        order by qp.fboard,qp.fexamno,qp.fqpcode";
    }
    else if($stype == 'degreesemwise')
    {
        $query = "select qp.fboard as fqpcode, mb.fboardname as fsubname, qp.fexamno as fexamno, count(*)  as ftotal,
        sum(case when ifnull(ts.fstatus,'')='final' then 1 else 0 end) as fsubmit,
        sum(case when ifnull(ts.fstatus,'')='rejected' then 1 else 0 end) as freject,
        sum(case when ifnull(ts.fstatus,'')='assigned' then 1 else 0 end) as fassign,
        (count(*) -
        sum(case when ifnull(ts.fstatus,'')='final' then 1 else 0 end)) as fbalance,
        TRUNCATE((sum(case when ifnull(ts.fstatus,'')='final' then 1 else 0 end) / (count(*))*100),2) as perct,deg.fdegree
        from tdvs_deggrp dg
        inner join tdvs_masqp qp on dg.fdeggrp = qp.fdeggrp
        inner join tdvs_tabsum ts on ts.fqpcode = qp.fqpcode
        inner join tdvs_masboard mb on dg.fdeggrp = mb.fdeggrp and mb.fdeggrp = qp.fdeggrp
        and qp.fboard = mb.fboard 
        inner join subject sub on ts.fqpcode = sub.fqpcode 
        and ts.fqpcode = sub.fqpcode
        inner join degree deg on sub.fdegree = deg.fdegree and sub.fexamno = deg.fexamno
        where qp.fqpcode between '{$fqpcodefrm}' and '{$fqpcodeto}' and ts.fvalno = '{$fvalno}'
        {$cond1}
        {$cond}
        {$constatus} {$degcond} {$semcond}
        group by sub.fdegree,qp.fexamno
        order by perct, qp.fboard";
    }
    else
    {

$query = "select qp.fqpcode, qp.fsubname, count(*)  as ftotal,
        qp.fboard,
        sum(case when ifnull(ts.fstatus,'')='final' then 1 else 0 end) as fsubmit,
        sum(case when ifnull(ts.fstatus,'')='rejected' then 1 else 0 end) as freject,
        sum(case when ifnull(ts.fstatus,'')='assigned' then 1 else 0 end) as fassign,
        (count(*) - 
        sum(case when ifnull(ts.fstatus,'')='final' then 1 else 0 end)) as fbalance,
        TRUNCATE((sum(case when ifnull(ts.fstatus,'')='final' then 1 else 0 end) / (count(*))*100),2) as fpercent,
        sum(if(ifnull(de.fregno,'')='',1,0)) as decodepend,
        sum(if(ifnull(de.fregno,'')='',0,1)) as decodedone,
        TRUNCATE((sum(if(ifnull(de.fregno,'')='',0,1)) / count(*)*100),2) as done_per,'-' as fdegree,
        group_concat(distinct concat(ts.fteachcode,' - ', mt.fteachname, ' - Assigned: ', mr.FMAXSCR,'; valued: ',x.cnt) separator ', ') as Teachname,
        group_concat(distinct concat(ts.fteachcode,' - MOB: ',mt.fmobile) separator ', ') as fmobile,
		group_concat(distinct concat(ts.fteachcode,' - Email: ',mt.femail) separator ', ') as femail
        from tdvs_deggrp dg  
        inner join tdvs_masqp qp on dg.fdeggrp = qp.fdeggrp 
        inner join tdvs_tabsum ts on ts.fqpcode = qp.fqpcode
        inner join tdvs_masboard mb on dg.fdeggrp = mb.fdeggrp and mb.fdeggrp = qp.fdeggrp and qp.fboard = mb.fboard
        left join (select fqpcode,fteachcode,fvalno,
		sum(if(ifnull(fstatus,'') ='FINAL',1, 0)) as cnt from 
		tdvs_tabsum where ifnull(fstatus,'') = 'final'
		group by fteachcode,fqpcode,fvalno) x on ts.fteachcode = x.fteachcode
		and ts.fqpcode = x.fqpcode and ts.fvalno = x.fvalno
        left join tdvs_tabulate de on ts.fqpcode = de.fqpcode
        and ts.fregcode = de.fregcode
        left join tdvs_masrev mr on mr.fqpcode = ts.fqpcode 
        and mr.fteachcode = ts.fteachcode 
		and mr.fvalno = ts.fvalno
        left join tdvs_masteach mt on mt.fteachcode = mr.fteachcode and mt.fteachcode = ts.fteachcode
        where qp.fqpcode between '{$fqpcodefrm}' and '{$fqpcodeto}' and ts.fvalno = '{$fvalno}'
        {$cond1}
        {$cond}
        {$constatus} {$degcond} {$semcond}
          
        group by qp.fqpcode
        order by qp.fboard,qp.fqpcode";

}
     //ifnull(fdeggrp,'') = '{$deggrp}' and -------------(removed )
     //var_dump($query);die();
    $result = $aobj_context->pobj_db->GetAll($query);

reportAdmFeeSummary($result, $aobj_context);

}

${this.title}

Code Editor : getQpStatsReport.php