Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
phpmailer	[ DIR ]	drwxrwxrwx
.htaccess	602 B	-rwxr-xr-x
ApplicationReport.php	11.81 KB	-rwxrwxrwx
CreateUser.php	5.23 KB	-rwxrwxrwx
appForm.php	23.31 KB	-rwxrwxrwx
applicationFormReportPOSTOFFIC...	19.32 KB	-rwxrwxrwx
applicationStatus.php	6.84 KB	-rwxrwxrwx
applicationStatus_31012018.php	2.94 KB	-rwxrwxrwx
cManualMailer.php	1.52 KB	-rwxrwxrwx
caccesscontext.php	1.24 KB	-rwxrwxrwx
candidate_list.php	54.71 KB	-rwxrwxrwx
cappcontext.php	2.66 KB	-rwxrwxrwx
ceckFile.php	1.12 KB	-rwxrwxrwx
cmailer.php	6.83 KB	-rwxrwxrwx
code39.php	6.38 KB	-rwxrwxrwx
coutput.php	1.76 KB	-rwxrwxrwx
crequestbroker.php	2.49 KB	-rwxrwxrwx
csessions.php	514 B	-rwxrwxrwx
cuser.php	3.41 KB	-rwxrwxrwx
customappcontext.php	2.35 KB	-rwxrwxrwx
download.php	5.65 KB	-rwxrwxrwx
dropdown.php	844 B	-rwxrwxrwx
everifyMc.php	6.36 KB	-rwxrwxrwx
feehead.php	1.51 KB	-rwxrwxrwx
format.php	7.43 KB	-rwxrwxrwx
fpdf_protection.php	5.61 KB	-rwxrwxrwx
getdata.php	1.06 KB	-rwxrwxrwx
getnumword.php	7.15 KB	-rwxrwxrwx
home.html	14.48 KB	-rwxrwxrwx
json.php	33.2 KB	-rwxrwxrwx
login.php	1.88 KB	-rwxrwxrwx
mc-verify.php	6.65 KB	-rwxrwxrwx
mregistry.php	4.55 KB	-rwxrwxrwx
mregistry_31012018.php	2.65 KB	-rwxrwxrwx
report_appstatus.php	6.42 KB	-rwxrwxrwx
report_verificationlist.php	4.99 KB	-rwxrwxrwx
reportapplicationform.php	19.59 KB	-rwxrwxrwx
reportapplicationform_old.php	28 KB	-rwxrwxrwx
rotation.php	596 B	-rwxrwxrwx
sendGridMail.php	1.29 KB	-rwxrwxrwx
servfee.php	1.38 KB	-rwxrwxrwx
servicedet.php	1.6 KB	-rwxrwxrwx
stringspliter.php	693 B	-rwxrwxrwx
student.php	25.37 KB	-rwxrwxrwx
verifiedlistReport.php	7 KB	-rwxrwxrwx

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