Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
.admin-src.php	3.61 KB	-rw-r--r--
ApplicationFeeSummary.php	10.25 KB	-rwxrwxrwx
ApplicationReport.php	9.96 KB	-rwxrwxrwx
Applicationfeereport.php	9.13 KB	-rwxrwxrwx
Collegewise_SeatAllotedList.ph...	11.13 KB	-rwxrwxrwx
Degreewise_SeatAllotedList.php	11.28 KB	-rwxrwxrwx
PrintDocumentVerification.php	23.98 KB	-rwxrwxrwx
SeatMatrixReport.php	24.02 KB	-rwxrwxrwx
admconfirmation.php	4.43 KB	-rwxrwxrwx
admissionMeritListExcel.php	11.08 KB	-rwxrwxrwx
admissionstatusreport.php	12.62 KB	-rwxrwxrwx
admorder_ru.php	4.53 KB	-rw-rw-r--
applicationFormReportBank.php	11.82 KB	-rw-rw-r--
applicationview.php	4.39 KB	-rwxrwxrwx
bnuAdmissionMeritListExcel.php	12.07 KB	-rwxrwxrwx
bnuAdmissionMeritListExcel_161...	11.88 KB	-rwxrwxrwx
changepasswordadmin.php	1.12 KB	-rwxrwxrwx
collegedegree.php	1.92 KB	-rwxrwxrwx
collegedetails.php	2.49 KB	-rwxrwxrwx
create-user.php	4.96 KB	-rwxrwxrwx
documentverification.php	8.75 KB	-rwxrwxrwx
dudseatallot.php	14.5 KB	-rw-rw-r--
editapp.php	1.38 KB	-rw-rw-r--
getAdmOrderDet.php	1.53 KB	-rw-r--r--
getnumword.php	9.1 KB	-rw-rw-r--
meritlist.php	6.41 KB	-rwxrwxrwx
presealallot.php	7.58 KB	-rw-rw-r--
provisionsellist.php	692 B	-rw-rw-r--
provisionsellistReport.php	13.57 KB	-rw-rw-r--
provisionsellistReport1.php	11.76 KB	-rw-rw-r--
provisionsellistReport1Downloa...	12.84 KB	-rw-rw-r--
provisionsellistReportDownload...	15 KB	-rw-rw-r--
report_merit_list.php	6.82 KB	-rwxrwxrwx
rostertable.php	490 B	-rwxrwxrwx
saveApplication.php	20.67 KB	-rwxrwxrwx
savevacantseats.php	2.57 KB	-rw-rw-r--
seatmatrix.php	8.53 KB	-rwxrwxrwx
signin.php	848 B	-rwxrwxrwx
viewpresealallot2.php	8.05 KB	-rw-rw-r--

Code Editor : Applicationfeereport.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;
ini_set('max_execution_time', 600);
ini_set("memory_limit",'2048M');

class MYPDF extends TCPDF
{

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("Application Fee Report");
        
        // set bacground image
        $this->SetFillColor(248, 244, 255);
        $img_path = $this->aobj_context->main_src . "/img/".$this->aobj_context->FUNIVCODE."_logo.jpg";

if (file_exists($img_path)) {
            $this->Image($img_path, 4, 6, 23, 23);
        }

$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, 'PG Admission Registration 2020-21', '0', 1, 'C');
        $this->SetFont('Times', 'B', 11);
        $this->Cell(0, 5, ' Application Fee  Report', '0', 1, 'C');

// $this->Cell(0, 5, 'College Range : ' . $this->aobj_context->mobj_data['cntr_from'].' - '.$this->aobj_context->mobj_data['cntr_end'], '0', 1, 'C');
        // $this->Cell(0, 5, 'Degree Range : ' . $this->aobj_context->mobj_data['degree_from'].' - '.$this->aobj_context->mobj_data['degree_to'], '0', 1, 'C');
        // $this->Cell(0, 5, 'Degree Group : ' . $this->aobj_context->mobj_data['Degree'], '0', 1, 'C');
        $this->Cell(0, 6, " Degree: " . $this->aobj_context->degree, "0", 1, "C");
        
        //restore auto-page-break status
        $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);
        // var_dump();
        if($this->CurOrientation == 'P')
        {
            $this->Cell(60, 10, 'IP : ' . $_SERVER["REMOTE_ADDR"], 0, 0, 'L');
            $this->Cell(60, 10, 'Date : ' . date("d-m-Y h:i:s A"), 0, 0, 'C');
            $this->Cell(60, 10, 'Page ' . $this->getPageNumGroupAlias() . '/' . $this->getPageGroupAlias(), 0, 1, 'R');
        }
        else {
            $this->Cell(90, 10, 'IP : ' . $_SERVER["REMOTE_ADDR"], 0, 0, 'L');
            $this->Cell(90, 10, 'Date : ' . date("d-m-Y h:i:s A"), 0, 0, 'C');
            $this->Cell(90, 10, 'Page ' . $this->getPageNumGroupAlias() . '/' . $this->getPageGroupAlias(), 0, 1, 'R');
        }
    }
}

class Report{

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->mobj_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->fdept = $aobj_context->mobj_data["fdept"];

//$this->current_date = $obj['now_date'];
    // $deggrp = $this->aobj_context->mobj_data["degree"];

// $get_coll_name = "select concat(fdeggrp, ' - ', fdescpn) as fdeggrp 
    // from deggrp where fdeggrp = '{$deggrp}'";
     //$lobj_get_degree = $this->aobj_context->mobj_db->GetRow($get_coll_name);
    
    // $aobj_context->deggrp = $lobj_get_degree['fdeggrp'];
    $get_coll_name = "select concat(fdegree, ' - ', fdescpn) as degree 
        from entdeg where fdegree = '{$this->fdept}'";
        $lobj_get_degree = $this->aobj_context->mobj_db->GetRow($get_coll_name);
        
        $aobj_context->degree = $lobj_get_degree['degree'];
    $this->pdf = new MYPDF('L');
     $this->pdf->aobj_context = $aobj_context;    
  }

public function TblHeader($pdf)
  {
    $pdf->SetFont('Times', 'B', 10);
    $pdf->Cell(15, 6, "Sl.No", "1", 0, "C");
    $pdf->Cell(30, 6, "App.no.", "1", 0, "C");
    $pdf->Cell(25, 6, "Applied date", "1", 0, "C");
    $pdf->Cell(50, 6, "Student Name", "1", 0, "C");
    $pdf->Cell(20, 6, "Total Fees", "1", 0, "C");
    $pdf->Cell(25, 6, "Payment Type", "1", 0, "C");
    $pdf->Cell(70, 6, "Payment ID", "1", 0, "C");
    $pdf->Cell(30, 6, "Payment Date", "1", 1, "C");

// $pdf->Cell(20, 6, "No", "LRB", 0, "C");
    //  $pdf->Cell(30, 6, "", "LRB", 0, "C");
    // $pdf->Cell(25, 6, "date", "LRB", 0, "C");
    // $pdf->Cell(50, 6, "Name", "LRB", 0, "C");
    // $pdf->Cell(30, 6, "Fees", "LRB", 0, "C");
    // $pdf->Cell(30, 6, "Type", "LRB", 0, "C");
    // $pdf->Cell(30, 6, "ID", "LRB", 0, "C");      
    // $pdf->Cell(30, 6, "Date", "LRB", 1, "C");

}

public function writeReport($data)
  {
      $pdf = $this->pdf;
      $pdf->SetMargins(15,33);
      $pdf->startPageGroup();
      $pdf->AddPage("L");
      $sl_no = 1;
      $this->TblHeader($pdf);
      $pdf->SetFont('Times', '', 10);

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

$pdf->Cell(15, 6,$sl_no, "1", 0, "C");
      $pdf->Cell(30, 6,$value['fappno'], "1", 0, "C");
      // $pdf->Cell(40, 6, $value['fcollname'], "1", 0, "L");
    
      $pdf->Cell(25, 6, $value['fappdate'], "1", 0, "C");
      $pdf->Cell(50, 6, $value['fname'], "1", 0, "L");
      $pdf->Cell(20, 6, $value['ftotfee'], "1", 0, "C"); 
      $pdf->Cell(25, 6, $value['fpaytype'], "1", 0, "C");
      $pdf->Cell(70, 6, $value['fpayid'], "1", 0, "C");  
      $pdf->Cell(30, 6, $value['fpaydate'], "1", 1, "C");
  
      $sl_no++;
      if ($pdf->getY() > 230) {
        //$pdf->Cell(193,0,"","T",1);
        $pdf->AddPage("L");
        $this->TblHeader($pdf);
        $pdf->SetFont('Times', '', 10);
      }
    }
   // $pdf->Cell(193,1,"","T",1);
  }
  public function SendOutput()
  {
      // ob_end_clean();
      $this->pdf->Output("Applicationfeereport.pdf", "I");
  }
}

function Applicationfeereport($aobj_context){
  // $univcode = $aobj_context->mobj_data["univcode"];  
  // $rformat = $aobj_context->mobj_data["Screentype"];     
  // $fcollfrm = $aobj_context->mobj_data["cntr_from"];  
  // $fcollto = $aobj_context->mobj_data["cntr_end"];  
  // $fdegfrm = $aobj_context->mobj_data["degree_from"];  
  // $fdegto = $aobj_context->mobj_data["degree_to"];  
  // $exmrange = $aobj_context->mobj_data["examno_from"];  
  // $deggrp = $aobj_context->mobj_data["Degree"];  
  // $rtype = $aobj_context->mobj_data["ReportType"]; 
  // $rftype = $aobj_context->mobj_data["rftype"];  
  
  
  $dtfrom = $aobj_context->mobj_data["dtfrom"];
  $dtto = $aobj_context->mobj_data["dtto"];
  $fdept = $aobj_context->mobj_data["fdept"];

$cond ="";
  if($fdept != 'All'){
		$cond = "and b.fdegree = '{$fdept}'";
	}

$query = "SELECT a.fappno, DATE_FORMAT(fpaydate, '%d/%m/%Y') AS fappdate, fname, ftotfee, fpaytype, fpayid, 
  DATE_FORMAT(fpaydate, '%d/%m/%Y') AS fpaydate FROM entstudadm a, entoptdeg b
  WHERE IFNULL(fpaystatus,'') = 'success' and a.fappno = b.fappno
  AND IFNULL(fpayid,'') <> '' AND fpaydate 
  BETWEEN DATE_FORMAT(STR_TO_DATE('{$dtfrom}','%d/%m/%Y'), '%Y-%m-%d') 
  AND DATE_FORMAT(STR_TO_DATE('{$dtto}','%d/%m/%Y'), '%Y-%m-%d')
  $cond
  group by a.fappno
  ORDER BY fpaydate";

$result = $aobj_context->mobj_db->GetAll($query);
  
  $class_obj = new Report();
  $class_obj->univcode=$univcode;
  $class_obj->DefaultConstructor($aobj_context);
  
  if(count($result)>0)
    $class_obj->writeReport($result);
  
  $class_obj->SendOutput();
}

${this.title}

Code Editor : Applicationfeereport.php