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 : tdvs_studentMarksReportNew.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', '5M');
ini_set('memory_limit', '1024M');

// 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,$univcode,$valno,$qpcode,$year,$examtype)
{
    //To Fit To Page while printing
    ini_set('max_execution_time', '300');

$fileName = $univcode."_".$qpcode."_".$valno."_".$year."_".$examtype.".xls";

$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);

// var_dump(dirname(__FILE__));
    // die();

// Redirect output to a client’s web browser (Excel5)
    header('Content-Type: application/vnd.ms-excel');
    header('Content-Disposition: attachment;filename='.$fileName);
    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');
   
    mkdir("/var/www/html/univadmin/tdvs_val_data/".$univcode);
   
    $objWriter->save('/var/www/html/univadmin/tdvs_val_data/'.$univcode.'/'.$fileName);
    
}

function tdvs_studentMarksReportNew($aobj_context)
{

$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
    $univcode = $aobj_context->mobj_data['univcode'];
    // $board = $aobj_context->mobj_data['board'];
    // $qpcode = $aobj_context->mobj_data['qpcode'];
    // $valno = $aobj_context->mobj_data['valno'];
    // $type = $aobj_context->mobj_data['type'];
    // $year = $aobj_context->mobj_data['year'];
    // $examtype = $aobj_context->mobj_data['examtype'];

$req = $aobj_context->req_body;
    var_dump($req);
    $data = $req;
    //$data = [];
   
    var_dump($data);
    die();

foreach($data as $val)
    {  
      $fqpcode = $val['fqpcode'];
      $fyear = $val['fyear'];
      $fexamtype = $val['fexamtype'];

$query = "select fqpcode,fvalno,fyear,fexamtype 
      from tdvs_tabsum
      where fqpcode = '{$fqpcode}'
      and fyear = '{$fyear}'
      and fexamtype = '{$fexamtype}'";
      
      $resultall = $aobj_context->pobj_db->GetAll($query);
      foreach($resultall as $value)
      {

$qpcode = $value['fqpcode'];
        $valno = $value['fvalno'];
        $type = $value['type'];
        $year = $value['fyear'];
        $examtype = $value['fexamtype'];
        
        $bkp = "";
        
        $query1="select concat(fsubname, ' - ', fqpcode) as fsubname from tdvs_masqp 
                where fqpcode='{$qpcode}'";
        $result1 = $aobj_context->pobj_db->GetRow($query1);

$objPHPExcel = new PHPExcel();
      
        
        $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);
        
        // Add column headers and make them bold
        $styleArray = array(
            'borders' => array(
                'allborders' => array(
                    'style' => PHPExcel_Style_Border::BORDER_THIN,
                    'color' => array('argb' => '000000'),
                ),
            ),
        );

$query2 = "select h.fpartcode, h.fpartdesc, h.fmaxqn, h.fmandqn from tdvs_qptemphead$bkp h inner join tdvs_masqp m on 
        m.ftempcode = h.ftempcode where m.fqpcode='{$qpcode}'";
    
      $result2 = $aobj_context->pobj_db->GetAll($query2);

$alpha=['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', 'AE', 
              'AF', 'AG', 'AH', 'AI', 'AJ', 'AK', 'AL', 'AM', 'AN', 'AO', 'AP', 'AQ', 'AR', 'AS', 'AT', 'AU', 'AV', 'AW', 'AX', 'AY', 'AZ'];
      
      $index = 0;
      $i=0;
      foreach($result2 as $val){

$query3 = "select d.fqnno, d.fpartcode, d.ftempcode 
          from tdvs_masqp m 
          inner join tdvs_qptempdetl d on 
          m.ftempcode = d.ftempcode
          where m.fqpcode='{$qpcode}' 
          and d.fsubqp = 'F' and d.fpartcode='{$val['fpartcode']}' 
          order by fqncode";
        
        $result3 = $aobj_context->pobj_db->GetAll($query3);

$len = $index + count($result3)-1;
        $objPHPExcel->getActiveSheet()->getStyle($alpha[$index].'4:'. $alpha[$len].'4')->getFont()->setBold(true);
        $objPHPExcel->getActiveSheet()->mergeCells($alpha[$index].'4:'. $alpha[$len].'4')->setCellValue($alpha[$index].'4', $val['fpartdesc'].' ('.$val['fmandqn'].' out of '.$val['fmaxqn'].') ');
        
        foreach($result3 as $value)
        {
            $objPHPExcel->getActiveSheet()->getStyle($alpha[$i].'5:'. $alpha[$i].'5')->getFont()->setBold(true);
            $objPHPExcel->getActiveSheet()->setCellValue($alpha[$i].'5', $value['fqnno']);
            $i++;
        }
        
        $index = $len+1;
      }
      
      
        $tdvs_tabsum = "tdvs_tabsum";
        $tdvs_tabulate = "tdvs_tabulate";
        $tdvs_tabdetl = "tdvs_tabdetl";
        $tdvs_masqp = "tdvs_masqp";
        $examyear = "";
        $mode = "";
      
      
          $query4 = "select t.fregno, st.fname, s.fqpcode, s.fregcode,
          group_concat(qd.fqnno, '*', td.fmarks11 order by fpartcode,fqncode )as fmarks,
          s.ftotmarks, s.fsysmarks 
          from $tdvs_tabsum s 
          inner join $tdvs_tabulate t on 
          s.fregcode = t.fregcode and s.fqpcode = t.fqpcode 
          inner join $tdvs_masqp m on m.fqpcode = s.fqpcode
          inner join tdvs_qptempdetl qd on qd.ftempcode = m.ftempcode
          inner join $tdvs_tabdetl td on s.fregcode = td.fregcode 
          and s.fqpcode = td.fqpcode and qd.fqncode = td.fqnno 
          left join student st on st.fregno = t.fregno 
          where m.fqpcode = '{$qpcode}'
          and qd.fsubqp = 'F'
          and s.fvalno = '{$valno}'
          {$examyear} {$mode}
          group by t.fregno 
          order by fregno";
      
      
      $result4 = $aobj_context->pobj_db->GetAll($query4);

$objPHPExcel->getActiveSheet()->getStyle('1:5')->getFont()->setBold(true);
      $objPHPExcel->getActiveSheet()->getStyle('1:5')->getFont()->setSize(12);
      $objPHPExcel->getActiveSheet()->getStyle('A1:A5')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
      $objPHPExcel->getActiveSheet()->freezePane('A6');
      $objPHPExcel->getActiveSheet()->getStyle('A1:'. $alpha[$index+1]. '5')->applyFromArray($styleArray);
      $objPHPExcel->getActiveSheet()->mergeCells('A1:'. $alpha[$index+1]. '1')->setCellValue('A1', 'Board :- '. $board);
      $objPHPExcel->getActiveSheet()->mergeCells('A2:'. $alpha[$index+1]. '2')->setCellValue('A2', 'Subject Name :- '. $result1['fsubname']);
      $objPHPExcel->getActiveSheet()->mergeCells('A3:'. $alpha[$index+1]. '3')->setCellValue('A3', 'Valuation No. :- '. $valno);
      $objPHPExcel->getActiveSheet()->mergeCells('A4:A5')->setCellValue('A4', 'Sl. No.');
      $objPHPExcel->getActiveSheet()->mergeCells('B4:B5')->setCellValue('B4', 'USN');
      $objPHPExcel->getActiveSheet()->mergeCells('C4:C5')->setCellValue('C4', 'Student Name');
      $objPHPExcel->getActiveSheet()->getColumnDimension('1')->setAutoSize(true);
      
      for($i=1; $i<=5; $i++){
        $objPHPExcel->getActiveSheet()->getRowDimension($i)->setRowHeight(30);
      }

$objPHPExcel->getActiveSheet()->mergeCells($alpha[$index].'4:'.$alpha[$index].'5')->setCellValue($alpha[$index].'4', 'Sys. Allotted Marks');
      $objPHPExcel->getActiveSheet()->mergeCells($alpha[$index+1].'4:'.$alpha[$index+1].'5')->setCellValue($alpha[$index+1].'4', 'Total Marks');
      $objPHPExcel->getActiveSheet()->getStyle('A1:'. $alpha[$index+1]. '5')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
      $objPHPExcel->getActiveSheet()->getStyle('A1:'. $alpha[$index+1]. '5')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);

if(count($result4) > 0){
        foreach($result4 as $key => $value){
            $slNo = $key + 6;
            $split = explode(',', $value['fmarks']);
            $i=0;
            $objPHPExcel->getActiveSheet()->getRowDimension($slNo)->setRowHeight(25);
            $objPHPExcel->getActiveSheet()->setCellValue('A' . $slNo, $slNo - 5)->getColumnDimension('A')->setwidth(8);
            $objPHPExcel->getActiveSheet()->setCellValue('B' . $slNo, $value['fregno'])->getColumnDimension('B')->setwidth(18);
            $objPHPExcel->getActiveSheet()->setCellValue('C' . $slNo, $value['fname'])->getColumnDimension('C')->setwidth(40);
            foreach($split as $val){
                $split_marks = explode('*', $val);
                if($split_marks[1] < 0){
                    $marks = "";
                }else{
                    $marks = $split_marks[1];
                }
                $objPHPExcel->getActiveSheet()->setCellValue($alpha[$i] . $slNo, $marks)->getColumnDimension($alpha[$i])->setwidth(8);

$objPHPExcel->getActiveSheet()->getStyle($alpha[$i].$slNo.':'.$alpha[$i].$slNo)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
                $objPHPExcel->getActiveSheet()->getStyle($alpha[$i].$slNo.':'.$alpha[$i].$slNo)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::VERTICAL_CENTER); 
                
                $i++;
                
            }
            $objPHPExcel->getActiveSheet()->setCellValue($alpha[$i] . $slNo, $value['fsysmarks'])->getColumnDimension($alpha[$i])->setwidth(20);
            $objPHPExcel->getActiveSheet()->setCellValue($alpha[$i+1] . $slNo, $value['ftotmarks'])->getColumnDimension($alpha[$i+1])->setwidth(15);

$objPHPExcel->getActiveSheet()->getStyle('A'.$slNo.':'.'B'.$slNo)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
            $objPHPExcel->getActiveSheet()->getStyle('A'.$slNo.':'.'B'.$slNo)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::VERTICAL_CENTER); 
            
            $objPHPExcel->getActiveSheet()->getStyle($alpha[$i].$slNo.':'.$alpha[$i+1].$slNo)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
            $objPHPExcel->getActiveSheet()->getStyle($alpha[$i].$slNo.':'.$alpha[$i+1].$slNo)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::VERTICAL_CENTER); 
            
            $objPHPExcel->getActiveSheet()->getStyle('A'.$slNo.':'.$alpha[$i+1].$slNo)->applyFromArray($styleArray);
        }
      }else{
        echo 'no data found';
        return;
      }
        getheaders($objPHPExcel,$univcode,$valno,$qpcode,$year,$examtype);
      }
    }
  }
?>

${this.title}

Code Editor : tdvs_studentMarksReportNew.php