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 : DYPIndent.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);
ini_set('max_execution_time', 300);
    ini_set('memory_limit', '512M');
date_default_timezone_set('GMT+5:30');
// PHPExcel_Shared_Font::setAutoSizeMethod(PHPExcel_Shared_Font::AUTOSIZE_METHOD_EXACT);
if (PHP_SAPI == 'cli')
    die('This example should only be run from a Web Browser');

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

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

// Redirect output to a client’s web browser (Excel5)

header('Content-Type: application/vnd.ms-excel');
    header('Content-Disposition: attachment;filename="' . $fileName . '.CSV"');
    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, 'CSV');
    $objWriter->save('php://output');
}

function DYPIndent($aobj_context)
{

$objPHPExcel = new PHPExcel();
    $univcode = $aobj_context->mobj_data["univcode"];
    $fileName = 'QP Indent';
    $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);

$objPHPExcel->getActiveSheet()->setTitle($fileName);
    $objPHPExcel->getActiveSheet()->getPageSetup()
        ->setOrientation(PHPExcel_Worksheet_PageSetup::ORIENTATION_LANDSCAPE);

$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()
        ->setCellValue('A1', 'Exam Date')
        ->setCellValue('B1', 'Session')
        ->setCellValue('C1', 'School Code')
        ->setCellValue('D1', 'School Name')
        ->setCellValue('E1', 'Program Code')
        ->setCellValue('F1', 'Program Name')
        ->setCellValue('G1', 'Exam No')
        ->setCellValue('H1', 'Subject Code')
        ->setCellValue('I1', 'Qpcode')
        ->setCellValue('J1', 'Course Name')
        ->setCellValue('K1', 'Course Code')
        ->setCellValue('L1', 'Subject Type')
        ->setCellValue('M1', 'Student Count')
        ->setCellValue('N1', 'Student Received')
        ->setCellValue('O1', 'Signature');

$j = 3;
    $slNo = 1;
    $sum = array();

//    $query = "select mt.fteachcode, fteachname, mt.fmobile, ifnull(fboardcode,'xxx') as fboard1
    //		 from masteach mt left join teachsub ts on mt.fteachcode = ts.fteachcode
    //		left join masqp mq on ts.fqpcode = mq.fqpcode left join
    //		 masboard mb on mq.fboard = mb.fboardcode
    //		where mt.fcollcode between '0000' and 'zzzz'
    //		and ifnull(fboardcode,'000000') between '0000' and 'zzzz'
    //		group by fteachcode
    //        order by mt.fcollcode, fboardcode, fteachcode";

//$univcode = $aobj_context->mobj_data["fdeggrp"];
    $fdatefrom = $aobj_context->mobj_data["fdatefrom"];
    $fdateto = $aobj_context->mobj_data["fdateto"];
    // $fdeggrp = $aobj_context->mobj_data["fdeggrp"];

//#and fackdate between '{$fdatefrom}' and '{$fdateto}'

$query ="select s.fdoe as fdate, r.fdescpn as fsession, c.fcollcode as college, cl.fcollname as name,c.fdegree as degree,g.fdescpn as descp ,c.fexamno as exam,s.fcsubcode as subcode,s.FQPCODE as qpcode,
		concat(s.fmarkdesc1,s.fmarkdesc2) as fsubname,s.fsubshort as short,s.fssubname as subtype, count(c.fregno) as count
		from subject s,canddet c,candsum d,degree g, college cl, reason r
		where s.fdegree=c.fdegree and s.fsubcode=c.fsubcode 
		and ifnull(c.fpassmth,'')='' and ifnull(c.fpresent,'')='P'
		and c.fregno=d.fregno and ifnull(d.frecptdate,'')<>'' and r.freasoncd = s.fsession
		and c.fdegree like '%'  
		and c.fdegree=g.fdegree and c.fexamno=g.fexamno and c.fcollcode = cl.fcollcode and d.fcollcode =cl.fcollcode
		and ifnull(s.fqpcode,'') <> ''  
		and s.fdoe between date_format(str_to_date('{$fdatefrom}','%d/%m/%Y'),'%Y-%m-%d') 
    	and date_format(str_to_date('{$fdateto}','%d/%m/%Y'),'%Y-%m-%d')
		group by  fdate, fsession, college, name, degree, descp , exam, subcode, qpcode, fsubname, short
		order by s.fdoe, r.fdescpn, c.fcollcode,cl.fcollname,c.fdegree,c.fexamno,s.fcsubcode,s.fqpcode;";
    
    $result = $aobj_context->pobj_db->GetAll($query);

$i = 2;
	$totamt=0;
    foreach ($result as $key => $value) {

$objPHPExcel->getActiveSheet()
            ->setCellValue('A' . $i, $value["fdate"]);
        $objPHPExcel->getActiveSheet()
            ->setCellValue('B' . $i, $value["fsession"]);
        $objPHPExcel->getActiveSheet()
            ->setCellValue('C' . $i, $value["college"]);
        $objPHPExcel->getActiveSheet()
            ->setCellValue('D' . $i, $value["name"]);
        $objPHPExcel->getActiveSheet()
            ->setCellValue('E' . $i, $value["degree"]);
        $objPHPExcel->getActiveSheet()
            ->setCellValue('F' . $i, $value["descp"]);
        $objPHPExcel->getActiveSheet()
            ->setCellValue('G' . $i, $value['examno']);
        $objPHPExcel->getActiveSheet()
            ->setCellValue('H' . $i, $value["subcode"]);
        $objPHPExcel->getActiveSheet()
            ->setCellValue('I' . $i, $value["qpcode"]);
        $objPHPExcel->getActiveSheet()
            ->setCellValue('J' . $i, $value["fsubname"]);
        $objPHPExcel->getActiveSheet()
            ->setCellValue('K' . $i, $value["short"]);
        $objPHPExcel->getActiveSheet()
            ->setCellValue('L' . $i, $value["subtype"]);
        $objPHPExcel->getActiveSheet()
            ->setCellValue('M' . $i, $value["count"]);
        $i++;
    }

getheaders($objPHPExcel, $fileName);
}

${this.title}

Code Editor : DYPIndent.php