Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
Thumbs.db	19 KB	-rwxr-xr-x
applicationFormReportNEFT.php	39.95 KB	-rwxr-xr-x
applicationFormReportNEFT22.ph...	21.49 KB	-rwxr-xr-x
applicationFormReportNETBANKIN...	18.3 KB	-rwxr-xr-x
applicationFormReportPOSTOFFIC...	18.13 KB	-rwxr-xr-x
applicationFormReportSBM.php	17.02 KB	-rwxr-xr-x
candidate_list.php	64.47 KB	-rwxr-xr-x
candidate_list25.php	49.9 KB	-rwxr-xr-x
candidate_list_1112019.php	50.96 KB	-rwxr-xr-x
candidate_list_17092018.php	50.43 KB	-rwxr-xr-x
candidate_list_before_paygate....	43.83 KB	-rwxr-xr-x
cappcontext.php	3.19 KB	-rwxr-xr-x
cappdu.php	3.53 KB	-rwxr-xr-x
code39.php	6.38 KB	-rwxr-xr-x
coutput.php	1.75 KB	-rwxr-xr-x
crequestbroker.php	2.49 KB	-rwxr-xr-x
csessions.php	516 B	-rwxr-xr-x
cuser.php	3.41 KB	-rwxr-xr-x
customappcontext.php	2.34 KB	-rwxr-xr-x
download_upload.html	2.6 KB	-rwxr-xr-x
ean13.php	2.83 KB	-rwxr-xr-x
getnumword.php	7.15 KB	-rwxr-xr-x
json.php	33.22 KB	-rwxr-xr-x
mregistry.php	1.57 KB	-rwxr-xr-x
mregistry_before_paygate.php	1.17 KB	-rwxr-xr-x
mregistry_before_postoffice.ph...	1.04 KB	-rwxr-xr-x
razorpay_order_api.php	24.07 KB	-rw-rw-r--
report_admission_ticket.php	51.49 KB	-rwxr-xr-x
report_admission_ticket2211201...	34.94 KB	-rwxr-xr-x
report_admission_ticket_080620...	46.64 KB	-rwxr-xr-x
report_admission_ticket_bf_cov...	46.96 KB	-rwxr-xr-x
report_hall_ticket.php	11.36 KB	-rwxr-xr-x
report_hall_ticketold.php	11.36 KB	-rwxr-xr-x
revaluation.php	17.12 KB	-rwxr-xr-x
rotation.php	596 B	-rwxr-xr-x
stringspliter.php	693 B	-rwxr-xr-x
student.php	4.75 KB	-rwxr-xr-x
subjectfreez.php	12.99 KB	-rwxr-xr-x
verifiedlistReport.php	7.01 KB	-rw-rw-r--

Code Editor : verifiedlistReport.php

<?php

$main_src=substr($_SERVER['SCRIPT_FILENAME'],0,strlen($_SERVER['SCRIPT_FILENAME'])-7);
	$this->pdf_writer_class =$main_src."/tarka_pdf/fpdf.php";
	require_once($this->pdf_writer_class);
	require('rotation.php');	
	require_once("getnumword.php");
	include_once("stringspliter.php");
	class applicationfrom  extends PDF_Rotate
	{
		function DefaultConstructor($aobj_context)
		{
			$this->aobj_context=$aobj_context;
			// $this->pdf=  new PDF_Rotate();
			// $this->pdf=$this;
			// $this->app_no = trim($this->aobj_context->mobj_data["app_no"]);

$this->fromdate = trim($this->aobj_context->mobj_data["fromdate"]);
			$this->todate = trim($this->aobj_context->mobj_data["todate"]);
			$this->fromroll = trim($this->aobj_context->mobj_data["fromroll"]);
			$this->toroll = trim($this->aobj_context->mobj_data["toroll"]);
			$this->fromref = trim($this->aobj_context->mobj_data["fromref"]);
			$this->toref = trim($this->aobj_context->mobj_data["toref"]);

// var_dump($this->fromdate);
			// var_dump($this->fromroll);

$this->ip=$_SERVER["REMOTE_ADDR"];
			$query = "SELECT st.fappno,DATE_FORMAT(fappdate,'%d/%m/%Y') AS fappdate,IFNULL(st.FAPPASSIGN,'') AS FAPPASSIGN, st.fregno, st.fname, st.fcategory, st.ftotal, 
			st.femail,st.fmobile,st.fpaystatus, st.fverifyuser,
			s.fservname,IFNULL(st.fverifystatus,'') AS fverifystatus, IFNULL(DATE_FORMAT(st.fverifydate,'%d/%m/%Y'),'')  AS fverifydate FROM servtran st INNER JOIN servtype s ON 
			s.fservcode =  st.fservcode
			WHERE LEFT(st.fverifydate,10) BETWEEN DATE_FORMAT(STR_TO_DATE('{$this->fromdate}','%d/%m/%Y'),'%Y-%m-%d') 
			AND DATE_FORMAT(STR_TO_DATE('{$this->todate}','%d/%m/%Y'),'%Y-%m-%d') 
			AND st.fregno BETWEEN '0' AND 'Z' AND st.fservcode='KS06' AND IFNULL(st.fverifystatus,'') = 'Verified'   AND 1=1 AND fpaystatus ='success'
			ORDER BY st.fappno, st.fregno";

$obj=$this->aobj_context->mobj_db->GetAll($query);

include_once("stringspliter.php");
            $this->current_date=$obj['now_date'];	
			$this->obj=$obj;	
			$query = "select now() as now_date";
			$obj=$this->aobj_context->mobj_db->GetRow($query);
			// var_dump($obj);
			$this->current_date = $obj['now_date'];
			$this->pdf = new PDF_Rotate("P","mm","A4");	
			$this->pdf->cMargin = 0;
		
            
		}

function Footer()
		{
			$this->pdf->SetY(-15);

$this->pdf->SetFont('Times','B',8);
			$this->pdf->Cell(140,6,'Printed   : IP Address : '.$this->ip." Date ".$this->current_date,'0',0,'L');
		}

function formcolldata()
		{
			$get_coll_name="select FUNIVCODE, FUNIVNAME as FUNIVNAME,FUNIVNAME as college_name,FTOWN,
			FUNIVADD1 as 'state', pdf_logo_path,ifnull(FEXAMAPPREQ,'F') as FEXAMAPPREQ, FSHORTUNIV,
			if(FUNIVCODE = '003','Regular','Distance') as rpmode From control";
			$lobj_get_coll_name=$this->aobj_context->mobj_db->GetRow($get_coll_name);
			
			$this->FUNIVCODE=$lobj_get_coll_name['FUNIVCODE'];
			$this->FUNIVNAME=$lobj_get_coll_name['FUNIVNAME'];
			$this->FSHORTUNIV=$lobj_get_coll_name['FSHORTUNIV'];
			$this->s_state=$lobj_get_coll_name['state'];
			$this->f_year=$lobj_get_coll_name['f_year'];
			$this->pdf_logo_path=$lobj_get_coll_name['pdf_logo_path'];
			$this->FEXAMAPPREQ=$lobj_get_coll_name['FEXAMAPPREQ'];
			$this->college_name=$lobj_get_coll_name['college_name'];
			$this->FTOWN=$lobj_get_coll_name['FTOWN'];
			$this->pdf_Postlogo_path="/img/post_logo.jpg";	
			$this->rpmode=$lobj_get_coll_name['rpmode'];
			$this->SetTitle("Verified List");

}

function Header(){
			 
			
			if(!empty($this->pdf_logo_path))
			{
				$img_logo_path=$this->aobj_context->main_src.$this->pdf_logo_path;
				$this->pdf->Image($img_logo_path,80,5,20);
			}
			
			//$this->pdf->Rect(9,10,279,190);
			$this->pdf->SetFont('Times','B',15);
			$this->pdf->cell(0,6,$this->FUNIVNAME,"0",1,"C");
			$this->pdf->SetFont('Times','B',12);
			$this->pdf->cell(0,7, $this->s_state,"0",1,"C");
			$this->pdf->SetFont('Times','B',12);
			// $this->pdf->Ln(8);
			$this->pdf->SetFont('Times','BU',15);
			$this->pdf->cell(0,6,"Verified List","0",1,"C");
			$this->pdf->Ln(1);
  
		$this->pdf->SetFont('Times', 'B', 10);
        $this->pdf->Cell(5, 7, "Sl", "LTR", 0, "C");
        $this->pdf->Cell(22, 7, "Application ", "LTR", 0, "C");
		$this->pdf->Cell(19, 7, "Application ", "LTR", 0, "C");
		$this->pdf->Cell(18, 7, "Register", "LTR", 0, "C");
		$this->pdf->Cell(74, 7, "Student ", "LTR", 0, "C");
		$this->pdf->Cell(15, 7, "Category", "LRT", 0, "C");
		$this->pdf->Cell(14, 7, "Amount", "LRT", 0, "C");
        $this->pdf->Cell(56, 7, "E-mail", "LTR", 0, "C");
        $this->pdf->Cell(23, 7, "Mobile ", "LRT", 0, "C");
		$this->pdf->Cell(18, 7, "Verified ", "LRT", 0, "C");
		$this->pdf->Cell(18, 7, "Verified", "LRT", 1, "C");

$this->pdf->Cell(5, 4, "No", "LR", 0, "C");
        $this->pdf->Cell(22, 4, "Number", "LR", 0, "C");
		$this->pdf->Cell(19, 4, " Date", "LR", 0, "C");
		$this->pdf->Cell(18, 4, "number", "LR", 0, "C");
		$this->pdf->Cell(74, 4, "Name", "LR", 0, "C");
		$this->pdf->Cell(15, 4, " ", "LR", 0, "C");
		$this->pdf->Cell(14, 4, " ", "LR", 0, "C");
        $this->pdf->Cell(56, 4, " ", "LR", 0, "C");
        $this->pdf->Cell(23, 4, " number", "LR", 0, "C");
		$this->pdf->Cell(18, 4, "user name", "LR", 0, "C");
        $this->pdf->Cell(18, 4, " Date", "LR", 1, "C");
	   }

function AcknowledgementForm()
	{
		$this->pdf->SetMargins(5,-10,0);
		$this->pdf->SetAutoPageBreak(true,0);
		// $this->pdf->SetTopMargin("2");
			
		$this->pdf->AddPage("L");
		$this->Header();

$z= 0;
		$sl_no = 1;
		
       foreach ($this->obj as $key => $value) {
		//var_dump($value['fappno']);
       if ($this->pdf->getY() > 180){
		//    $this->pdf->AddPage("L");
		 
		$this->pdf->SetMargins(5,-10,0);
		$this->pdf->SetAutoPageBreak(true,0);
		// $this->pdf->SetTopMargin("2");
		$this->Footer();
		$this->pdf->AddPage("L");
		$this->Header();

}

$this->pdf->SetFont('Times', '', 10);
        $this->pdf->Cell(5, 7, $sl_no, "LTRB", 0, "C");
        $this->pdf->Cell(22, 7, $value['fappno'], "1", 0, "C");
		$this->pdf->Cell(19, 7, $value['fappdate'], "1", 0, "C");
        $this->pdf->Cell(18, 7, $value['fregno'], "1", 0, "C");
        $this->pdf->Cell(74, 7, " ".$value['fname'], "1", 0, "L");
		$this->pdf->Cell(15, 7, $value['fcategory'], "1", 0, "C");
		$this->pdf->Cell(14, 7, $value['ftotal'], "1", 0, "C");
        $this->pdf->Cell(56, 7, " ".$value['femail'], "1", 0, "L");
        $this->pdf->Cell(23, 7, $value['fmobile'], "1", 0, "C");
		$this->pdf->Cell(18, 7, $value['fverifyuser'], "1", 0, "C");
        $this->pdf->Cell(18, 7, $value['fverifydate'], "1", 1, "C");
        
          
   
           $sl_no++;
           $z++;
       }
		// $oldCode = $value['fappno'];

}    
    
		
		function SendOutput()
		{
			$this->pdf->Output("Verified_list.pdf","I");
		}
			
			 
	}
	
	function verifiedlistReport($aobj_context)
	{
		$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
		$class_obj=new applicationfrom();
		$class_obj->DefaultConstructor($aobj_context);
		$class_obj->formcolldata();
		$class_obj->AcknowledgementForm();
		$class_obj->SendOutput();
	}

${this.title}

Code Editor : verifiedlistReport.php