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 : report_verificationlist.php

<?php
function ExportVerificationList($aobj_context)
{	
	session_start();
    $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);

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

$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$query = "SELECT st.fappno,DATE_FORMAT(fappdate,'%d/%m/%Y') AS fappdate, st.fregno, st.fname, st.fcategory, st.ftotal,  
	st.femail, st.fmobile, st.fverifyname DATE_FORMAT(st.fverifydate,'%d/%m/%Y') as fverifydate FROM servtran st INNER JOIN servtype s ON 
	s.fservcode =  st.fservcode
	WHERE st.fappdate BETWEEN DATE_FORMAT(str_to_date('{$fromdate}','%d/%m/%Y'),'%Y-%m-%d') 
	AND DATE_FORMAT(str_to_date('{$todate}','%d/%m/%Y'),'%Y-%m-%d') 
	AND st.fregno BETWEEN '$fromroll' AND '$toroll' 
	 order by st.fappno, st.fregno";
	//var_dump($query);
	$result = $aobj_context->mobj_db->GetAll($query);

$main_src_obj=(explode("/",$_SERVER["REQUEST_URI"]));
	$main_src=$main_src_obj[1];
	$pdf_writer_class=$aobj_context->main_src."/maya-pdf/fpdf.php";	
	$root_pdf_file_download=$aobj_context->main_src."/Report_details/output/report_general_list.pdf";
	// global varibales
	$p_count =1;
	// end global varibales	
	//echo getnumber_to_word("001"); die();
	include($pdf_writer_class);		
	$pdf= new FPDF();
	$pdf->SetFont('Times','',10);
	$pdf->SetMargins(10,8);			
	$pdf->AliasNbPages();	
	// query for the page header
	$page_header_university = "select FUNIVNAME,FTOWN,FUNIVADD1, date_format(now(),'%d/%m/%Y') as date from control";
	$lobj_page_header_university = $aobj_context->mobj_db->GetRow($page_header_university);  //Runs the query provided and puts the first row of data into an array then frees the result set.
	$pdf->FUNIVNAME = $lobj_page_header_university['FUNIVNAME'];
	$pdf->FTOWN = $lobj_page_header_university['FTOWN'];
	$pdf->FUNIVADD1 = $lobj_page_header_university['FUNIVADD1'];
	$pdf->date_1 = $lobj_page_header_university['date'];	
	
	$pdf->aobj_context = $aobj_context ;
	$pdf->WhichReport = 'Verification List Report';  
	
	
	$pdf->AddPage();
	$w = array(10,20,15,15,40,10,45,10,12,15,30);
	writeHeaders($pdf, $w);
	writeFooter($pdf);	
	$adm_ln_counter=0;
	$slno = 1;
	foreach($result as $key => $value)
	{
			$get_x1=$pdf->GetX();
			$get_y1=$pdf->GetY();
			$pdf->SetXY($get_x1+$w[0]+$w[1]+$w[2]+$w[3],$get_y1);	
			$pdf->MultiCell($w[4],6, $value['fname'] ,'LBT','L');   //printing text with line breaks!!! MultiCell( width of cell, height of each line, text content, border, alignment of the
            $get_y2=$pdf->GetY();                                                        //text, fill boolean)
			$height=$get_y2-$get_y1;	
			$pdf->SetXY($get_x1,$get_y1);	
			$pdf->Cell($w[0],$height, $slno,'LBT',0,'C');
			$get_x1=$pdf->GetX(); 
			$pdf->SetXY($get_x1,$get_y1);	
			$pdf->Cell($w[1],$height, $value['fappno'],'LBT',0,'C');
			$pdf->SetXY($get_x1+$w[1],$get_y1);	
			$pdf->Cell($w[2],$height,$value['fappdate'],'LBT',0,'C');
			$pdf->Cell($w[3],$height,$value['fregno'],'LBT',0,'C');
			$get_x1=$pdf->GetX();
			$pdf->SetXY($get_x1+$w[4],$get_y1);
			$pdf->Cell($w[5],$height,$value['fcategory'],'LBT',0,'C');
			$pdf->Cell($w[6],$height,$value['fservname'],'LBT',0,'L');	
			$pdf->Cell($w[7],$height,$value['ftotal'],'LBT',0,'R');	
			$pdf->Cell($w[8],$height,$value['fverifystatus'],'LBT',0,'C');
			$pdf->Cell($w[9],$height,$value['fverifydate'],'LBRT',1,'C');
			$pdf->Cell($w[10],$height,$value['fverifyname'],'LBRT',1,'C');	
			$get_y1=$pdf->GetY();
			++$slno;
			if($get_y1>=250)
			{
				$pdf->Ln(2);
				
				$pdf->AddPage();	
				writeHeaders($pdf,$w);
				writeFooter($pdf);
				
			}
			$adm_ln_counter++;
	}
	 
	$pdf->Output("Verification_list_report.pdf","D");
}

function writeHeaders($pdf,$w)
{
	$pdf->SetFont('Times','B',9);		
	$pdf->Cell($w[0],6,"Sl. No.",'LT',0,'C');//Cell(float w [, float h [, string txt [, mixed border [, int ln [, string align [, boolean fill [, mixed link]]]]]]])
	$pdf->Cell($w[1],6,"App. No.",'LT',0,'C');
	$pdf->Cell($w[2],6,"App. Date.",'LT',0,'C');
	$pdf->Cell($w[3],6,"Reg. No.",'LT',0,'C');	
	$pdf->Cell($w[4],6,"Student Name",'LT',0,'C');
	$pdf->Cell($w[5],6,"Cat.",'LT',0,'C');
	$pdf->Cell($w[6],6,"Amt.",'LT',0,'C');	
	$pdf->Cell($w[7],6,"Emailid",'LRT',0,'C');
	$pdf->Cell($w[8],6,"MobileNo",'LRT',0,'C');
	$pdf->Cell($w[9],6,"Ver. Date",'LRT',1,'C');
	$pdf->Cell($w[10],6,"Ver. Name",'LRT',1,'C');
	$pdf->SetFont('Times','',8);
}

function writeFooter($pdf)
{		
	$get_x1=$pdf->GetX();    //Returns the abscissa of the current position
	$get_y1=$pdf->GetY();
	$pdf->SetY(-30);
	
	//$pdf->Cell(0,4,"Note : Attended / Conducted",'0',1,'L');
	$new_y=$pdf->GetY();
	$pdf->Line(10,$new_y, 220,$new_y);           //line( $sx, $sy, $ex, $ey )
	$pdf->Line(10,$new_y+.5, 220,$new_y+.5);
	//$pdf->Ln();
	//$pdf->Cell(0,6,"Principal's Signature",'0',0,'R');	
	$pdf->SetXY($get_x1,$get_y1);	
}
?>

${this.title}

Code Editor : report_verificationlist.php