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.41 KB	-rw-r--r--
generatebillDownload.php	18.18 KB	-rw-rw-r--
generatebill_acu.php	22.55 KB	-rw-r--r--
generatebill_new.php	28.88 KB	-rw-r--r--
generatetadabill.php	18.4 KB	-rw-r--r--
generateworkdonereport.php	19.06 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--
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	36 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.1 KB	-rw-rw-r--
tdvs_studentMarksReportCOWise....	15.84 KB	-rw-rw-r--
tdvs_studentMarksReportNew.php	11.64 KB	-rw-r--r--
tdvsmarkslist.php	34.79 KB	-rw-rw-r--
teachersList.php	15.47 KB	-rw-rw-r--

Code Editor : TDVSValuationReport.php

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

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

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

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

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

if($type === "Total"){
            $cond = " ";
            $join = "left";
        }else if($type === "Balance"){
            $cond = " and ifnull(t.fstatus, '')<>'final'";
            $join = "left";
        }else{
            $cond = " and ifnull(t.fstatus, '')='{$type}'";
            $join = "inner";
        }

$query = "select date_format(t.fsysdate, '%d/%m/%Y')as assigned_date, t.fteachcode, m.fteachname, t.fcollcode, 
                  t.fqpcode, t.fregcode, ifnull(t.fstatus, '')as fstatus, m.fmobile,
                  date_format(t.fstdate, '%d/%m/%Y %H:%i:%s') as fstartdate, 
                  date_format(t.fendate, '%d/%m/%Y %H:%i:%s') as fendate, fbatchno   
                  from tdvs_tabsum t {$join} join tdvs_masteach m
                  on t.fteachcode = m.fteachcode 
                  where fvalno = '{$valno}' {$cond} 
                  {$qpcond}
                  order by t.fqpcode";
        
        $result = $aobj_context->pobj_db->GetAll($query);

$objPHPExcel = new PHPExcel();
        $objPHPExcel->setActiveSheetIndex(0);
        $styleArray = array(
        'borders' => array(
            'allborders' => array(
                'style' => PHPExcel_Style_Border::BORDER_THIN,
                'color' => array('argb' => '000000'),
            ),),);

$objPHPExcel->getActiveSheet()->getRowDimension('1')->setRowHeight(30);
        $objPHPExcel->getActiveSheet()->getStyle('1:1')->getFont()->setBold(true);
        $objPHPExcel->getActiveSheet()->freezePane('A2'); 
        $objPHPExcel->getActiveSheet()->setCellValue('A1', 'Sl.No.')
        ->setCellValue('B1', 'QP Code')
        ->setCellValue('C1', 'Reg. Code');

if($type === "Assigned" || $type === "Final" || $type === "Rejected"){
            $objPHPExcel->getActiveSheet()->setCellValue('D1', 'Batch No.')
            ->setCellValue('E1', 'Assigned Date')
            ->setCellValue('F1', 'Valuation. No.')
            ->setCellValue('G1', 'College Code')
            ->setCellValue('H1', 'Teach Code')
            ->setCellValue('I1', 'Teach Name')
            ->setCellValue('J1', 'Mobile No.')
            ->setCellValue('K1', 'Status');
        }
        if($type === "Final"){
            $objPHPExcel->getActiveSheet()->setCellValue('L1', 'Start Date')
             ->setCellValue('M1', 'End Date');
             $fromto = 'A1:M1';
        }else if($type === "Assigned" || $type === "Rejected"){
            $fromto = 'A1:K1';
        }else{
            $fromto = 'A1:C1';
        }

$objPHPExcel->getActiveSheet()->getStyle($fromto)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->getActiveSheet()->getStyle($fromto)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
        $objPHPExcel->getActiveSheet()->getStyle($fromto)->applyFromArray($styleArray);

foreach($result as $key => $val){
            $slNo = $key + 2;
            $objPHPExcel->getActiveSheet()->getRowDimension($slNo)->setRowHeight(30);
            $objPHPExcel->getActiveSheet()->setCellValue('A' . $slNo, $slNo - 1)->getColumnDimension('A')->setwidth(8);
            $objPHPExcel->getActiveSheet()->setCellValue('B' . $slNo, $val['fqpcode'])->getColumnDimension('B')->setwidth(10);
            $objPHPExcel->getActiveSheet()->setCellValue('C' . $slNo, "'".$val['fregcode'])->getColumnDimension('C')->setwidth(16);
            
            if($type === "Assigned" || $type === "Final" || $type === "Rejected"){
                $objPHPExcel->getActiveSheet()->setCellValue('D' . $slNo, $val['fbatchno'])->getColumnDimension('D')->setwidth(14);
                $objPHPExcel->getActiveSheet()->setCellValue('E' . $slNo, $val['assigned_date'])->getColumnDimension('E')->setwidth(16);
                $objPHPExcel->getActiveSheet()->setCellValue('F' . $slNo, $valno)->getColumnDimension('F')->setwidth(16);
                $objPHPExcel->getActiveSheet()->setCellValue('G' . $slNo, $val['fcollcode'])->getColumnDimension('G')->setwidth(14);
                $objPHPExcel->getActiveSheet()->setCellValue('H' . $slNo, $val['fteachcode'])->getColumnDimension('H')->setwidth(14);
                $objPHPExcel->getActiveSheet()->setCellValue('I' . $slNo, $val['fteachname'])->getColumnDimension('I')->setwidth(30);
                $objPHPExcel->getActiveSheet()->setCellValue('J' . $slNo, $val['fmobile'])->getColumnDimension('J')->setwidth(15);
                $objPHPExcel->getActiveSheet()->setCellValue('K' . $slNo, $val['fstatus'])->getColumnDimension('K')->setwidth(15);
            }

if($type === "Final"){
                $objPHPExcel->getActiveSheet()->setCellValue('L' . $slNo, $val['fstartdate'])->getColumnDimension('L')->setwidth(18);
                $objPHPExcel->getActiveSheet()->setCellValue('M' . $slNo, $val['fendate'])->getColumnDimension('M')->setwidth(18);
                $fromto = 'A' . $slNo . ':M'. $slNo;
            }else if($type === "Assigned" || $type === "Rejected"){
                $fromto = 'A' . $slNo . ':K'. $slNo;
            }   
            else{
                $fromto = 'A' . $slNo . ':C'. $slNo;
            }

$objPHPExcel->getActiveSheet()->getStyle($fromto)->applyFromArray($styleArray);
            $objPHPExcel->getActiveSheet()->getStyle('A' . $slNo . ':H' . $slNo)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
            $objPHPExcel->getActiveSheet()->getStyle('A' . $slNo . ':H' . $slNo)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
            $objPHPExcel->getActiveSheet()->getStyle('J' . $slNo . ':M' . $slNo)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
            $objPHPExcel->getActiveSheet()->getStyle('J' . $slNo . ':M' . $slNo)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
            // $objPHPExcel->getActiveSheet()->getStyle('H' . $slNo)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
            $objPHPExcel->getActiveSheet()->getStyle('I' . $slNo)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
        }
        
        $fileName = "ValuationStatusReport";
        getheaders($objPHPExcel, $fileName);
    }

${this.title}

Code Editor : TDVSValuationReport.php