Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
.pgetadm.php	3.61 KB	-rw-r--r--
PrintAdmissionOrderstudent.php	9.51 KB	-rwxrwxrwx
PrintAdmissionOrderstudent_ru....	11.26 KB	-rwxrwxrwx
acuapplicationFormPGReport.php	26.02 KB	-rwxr-xr-x
add-course.php	5.63 KB	-rwxrwxrwx
admissionorderPGReport.php	15.91 KB	-rwxrwxrwx
admissionordertest.php	356 B	-rwxrwxrwx
app-status.php	2.87 KB	-rwxrwxrwx
applicationFormPGReport.php	43.11 KB	-rwxrwxrwx
bcuapplicationFormPGReport.php	50.46 KB	-rwxrwxrwx
cancelSeat.php	4.51 KB	-rwxrwxrwx
casual-seat-allot.php	16.88 KB	-rwxrwxrwx
category.php	2.95 KB	-rwxrwxrwx
data.json	1.98 KB	-rwxrwxrwx
degree.php	11.73 KB	-rwxrwxrwx
feestr.php	5.7 KB	-rwxrwxrwx
forgot-password.php	2.77 KB	-rwxrwxrwx
generatestudentlistreport.php	11.34 KB	-rwxrwxrwx
getSavedData.php	13.67 KB	-rwxrwxrwx
getSavedData_old_12102019.php	5 KB	-rwxrwxrwx
hallticket.php	7.61 KB	-rwxrwxrwx
leaddetmail.php	2.09 KB	-rwxr-xr-x
login.php	1.21 KB	-rwxrwxrwx
logout.php	44 B	-rwxrwxrwx
option-entry-cr.php	4.76 KB	-rwxrwxrwx
option-entry.php	9.11 KB	-rwxrwxrwx
option-entryPrint.php	9.34 KB	-rwxrwxrwx
printadmissionorder.php	1.38 KB	-rwxrwxrwx
printhostelfeereport.php	11.84 KB	-rwxrwxrwx
report_ra_Notice_Boaed_Chart.p...	9.79 KB	-rwxrwxrwx
report_ra_invigilator_dairy.ph...	9.61 KB	-rwxrwxrwx
reportadm_admission_ticket.php	14.66 KB	-rwxrwxrwx
reprint.php	707 B	-rwxrwxrwx
resetpassword.php	783 B	-rwxrwxrwx
saveApplication.php	24.33 KB	-rwxrwxrwx
saveApplication_BACKUP_15072.p...	48.01 KB	-rwxrwxrwx
saveApplication_BASE_15072.php	23.61 KB	-rwxrwxrwx
saveApplication_LOCAL_15072.ph...	24.27 KB	-rwxrwxrwx
saveApplication_REMOTE_15072.p...	23.67 KB	-rwxrwxrwx
saveApplication_old_12102019.p...	14.67 KB	-rwxrwxrwx
seat-allot.php	9.18 KB	-rwxrwxrwx
seat_allotment_summary.php	8.42 KB	-rwxrwxrwx
sendGridMail.php	1.47 KB	-rwxrwxrwx
sendMobEmailOTP.php	1.41 KB	-rwxrwxrwx
sendsmsapi.php	760 B	-rwxrwxrwx
signin.php	1.24 KB	-rwxrwxrwx
signup.php	1.21 KB	-rwxrwxrwx
validateRegno.php	3.12 KB	-rwxrwxrwx
vkuapplicationFormPGReport cop...	36.61 KB	-rwxrwxrwx
vkuapplicationFormPGReport.php	24.17 KB	-rwxrwxrwx
vkuapplicationFormPGReportOld....	39.28 KB	-rwxrwxrwx

Code Editor : vkuapplicationFormPGReport.php

<?php
ob_start();
$main_src=substr($_SERVER['SCRIPT_FILENAME'],0,strlen($_SERVER['SCRIPT_FILENAME'])-7);
//$pdf_writer_class =$main_src."/tarka_pdf/fpdf.php";
$pdf_writer_class =$main_src."/tcpdf/tcpdf.php";
require_once($pdf_writer_class);
ini_set('memory_limit','900M');
ini_set('max_execution_time',0);

class MYPDF extends TCPDF {
    public $aobj_context;
     
    public function setData($aobj_context){
    	$this->aobj_context = $aobj_context;
    }
    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);
        // set bacground image

$this->SetMargins(10,34,20,true);	
		$this->SetFillColor(248, 248 ,255);		
		$img_path = $this->aobj_context->main_src."/img/".$this->aobj_context->FUNIVCODE."_logo.jpg";
		// var_dump($img_path);
		if(file_exists($img_path)) 
			$this->Image($img_path,10,6,20,20);

$img_path1 = $this->aobj_context->main_src . "img/".$this->aobj_context->FUNIVCODE."_logo_2.jpeg";
        //var_dump($img_path);
        if (file_exists($img_path1)) {
            $this->Image($img_path1, 178, 3, 20, 20);
        }
		
		$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','B',12);
		$this->Ln(1);
		
		$cur_year = date("Y");
		$this->Cell(180,5,'PHD Application Form  2021-2022','0',1,'C');
		$this->Cell(0,4,'Degree : '.$this->aobj_context->degree,0,1,'C'); 
		// var_dump($this->degree);
		// var_dump($this->degree);
		$style = array(
			'position' => 'right',
			'align' => 'C',
			'stretch' => false,
			'fitwidth' => true,
			'cellfitalign' => '',
			'border' => false,
			'hpadding' => 'auto',
			'vpadding' => 'auto',
			'fgcolor' => array(0,0,0),
			'bgcolor' => false, //array(255,255,255),
			'text' => true,
			'font' => 'helvetica',
			'fontsize' => 8,
			'stretchtext' => 4
		);
		// var_dump($this->aobj_context->FAPPNO);
		$this->write1DBarcode($this->aobj_context->fprefix.$this->aobj_context->appno, 'C39', '130', '20','130', 16, 0.3, $style, 'R');
        // 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);
        $this->Cell(50, 10,'IP : '.$_SERVER["REMOTE_ADDR"], 0, 0, 'L');
        $this->Cell(100, 10,'Date : ' .$this->aobj_context->current_date, 0, 0, 'C');

$this->Cell(50, 10,'Page ' .$this->getPageNumGroupAlias().'/'.$this->getPageGroupAlias(), 0, 1, 'R');
    }
}

class AddmissionApplication
{	
	function DefaultConstructor($aobj_context)
	{
		$this->aobj_context=$aobj_context;
		//$this->pdf=  new FPDF();
		$this->collcode=$_SESSION['collcode'];
		$degree = trim($aobj_context->mobj_data["degree"]);
		$this->ip=$_SERVER["REMOTE_ADDR"];
		$get_date="select DATE_FORMAT(now(), '%d/%m/%Y') as now_date,fprefix from entdeg where fdegree = '{$degree}'";
		$obj=$this->aobj_context->mobj_db->GetRow($get_date);
		$fprefix = $obj['fprefix'];

$get_coll_name="select FUNIVNAME as 'FUNIVNAME',FUNIVCODE,
		FUNIVADD1 as 'state', concat(FUNIVCODE,'_',pdf_logo_path) as 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($this->degree);
		$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->FEXAMAPPREQ=$lobj_get_coll_name['FEXAMAPPREQ'];
		$aobj_context->FUNIVCODE=$lobj_get_coll_name['FUNIVCODE'];

$app_no = trim($aobj_context->mobj_data["appno"]);

$aobj_context->appno = $app_no;
		$aobj_context->fprefix = $fprefix;
		$aobj_context->current_date = $obj['now_date'];
		$this->current_date = $obj['now_date'];

$this->pdf= new MYPDF('P');
		$this->pdf->setData($aobj_context);
		
	}
 
	function formcolldata()
	{
		$get_coll_name="select FUNIVNAME as 'FUNIVNAME',FUNIVCODE,
		FUNIVADD1 as 'state', concat(FUNIVCODE,'_',pdf_logo_path) as pdf_logo_path,
		ifnull(FEXAMAPPREQ,'F') as FEXAMAPPREQ From control";

$lobj_get_coll_name=$this->aobj_context->mobj_db->GetRow($get_coll_name);
		
		$this->FUNIVNAME=$lobj_get_coll_name['FUNIVNAME'];
		$this->s_state=$lobj_get_coll_name['state'];
		$this->pdf_logo_path=$lobj_get_coll_name['pdf_logo_path'];
		$this->FEXAMAPPREQ=$lobj_get_coll_name['FEXAMAPPREQ'];
		$this->FUNIVCODE=$lobj_get_coll_name['FUNIVCODE']; 
	}
	
		
	function writeApplication($per_details,$rltacad,$rltexp,$rltpub,$rltoth,$rltugc)
	{

//var_dump($degdet[$per_details['FDEGREE1']]);
	// var_dump($db,$per_details, $fee_det,$res_optopns,$per_details['FDEGREE1'], $res_prevmarks,$res_lanmarks);

$pdf=$this->pdf;

// var_dump($per_details);

$pdf->SetMargins(10,35,25,false);
		$pdf->startPageGroup();
		$pdf->AddPage("P");

if($per_details){

}else{
			$pdf->SetFont('Times','UB',25);
			$pdf->cell(0,5, "Fee Not Paid","",0,"C");
			return;
		}

$pdf->SetFont('Times','UB',10);
		$this->degree = $degdet[$degree];
		//$pdf->cell(0,7,"Courses Preference : ".$degree." - ".$degdet[$degree],0,1,'C');

$head = '<style>
		td {
			border: 0.5px solid black;
		}
	 </style>
	 <table cellpadding="3" cellspacing="0" border="0" width="100%">';

//====================Subject Details====================================
	$table2 = '<style>
		td, th {
			border: 0.5px solid black;
		}
	 </style>
	<table cellpadding="2" cellspacing="0" border="0" width="100%">';
	$i = 1;
	$fprefix = "";
	$fprefix = $res_optopns[0]['fprefix'];
	// foreach ($res_optopns as $value) {
	// 	$degr_desn = $value['fdescpn'];
	// 	$table2 .= '<tr nobr="true">
	// 	<td align="center">' . 'Application for ' . $value['fdescpn'] . ' ['  . $value['fdegree'] . ']' . '</td>			
	// 	</tr>';

// 	$i++;
	// }

$table2 .= '</table>';

$x = $pdf->GetX();
	$y = $pdf->GetY();
	$pdf->SetX(11);
	$pdf->writeHTMLcell(185, 0, $x, $y, $table2, false, true, false, false, 'C');
	//var_dump($fprefix);
	$pdf->ln(2);
		//====================Personal Details====================================
		$pdf->SetFont('Times','',10);
		$html = '<h3 style="background-color: #918988; color: rgb(255, 255, 255);">I. Personal Details</h3>';
		$x = $pdf->GetX();
		$y = $pdf->GetY();		
		$pdf->writeHTMLCell(188,0,$x,$y,$html, false,1, false, true, '', false);

$path = realpath(__DIR__ .'/..');
		//var_dump($path.'/pget_photos'.'/'.$per_details['fphotopath']);
		//var_dump($path.'/'.$per_details['fphotopath']);
		$photo_url = "https://admission-certificates.s3.ap-south-1.amazonaws.com";
		$i= 1;
		// var_dump($photo_url);
		// var_dump($per_details['FPHOTOPATH']);
		
		
		$table1 = '<style>
			td {
			    border: 0.5px solid black;
			}
			.lable {
				font-weight: bold;
			}
		 </style>
		<table cellpadding="3" cellspacing="0">
			<tr nobr="true">
				<td width="150" class="lable">Application No.</td>
				<td width="270" colspan="3" style = "font-size:15px;">'.$per_details['fappno'].'</td>
				<td width="100" rowspan="5"><img width="100" height="100" src="'.$photo_url.'/'.$per_details['fphotopath'].'" /></td>
		</tr>';

$table1 .='<tr nobr="true">
				<td width="150" class="lable">Name of the Applicant</td>
				<td width="270" colspan="3">'.$per_details['fname'].'</td></tr>';

$table1 .='<tr nobr="true">
				<td width="80" class="lable">Gender </td>
				<td width="70">'.$per_details['fgender'].'</td>
				<td width="150" class="lable">Date of Birth (DD/MM/YYYY)</td>
				<td width="120">'.$per_details['fdob'].'</td>
				</tr>';

$table1 .='<tr nobr="true">								
				<td width="80" class="lable">Nationality </td>
				<td width="70">'.$per_details['fnational'].'</td>

<td width="150" class="lable">Aadhar Number</td>
				<td width="120">'.$per_details['faadharno'].'</td>
				</tr>';

$table1 .='<tr nobr="true">				
							
				<td width="80" class="lable">Category</td>
				<td width="70">'.$per_details['fcategory'].'</td>

<td width="150" class="lable">Kalyana Karnataka</td>
				<td width="120">'.$per_details['fhk'].'</td>
				
				</tr>';

$table1 .='<tr nobr="true">
				<td width="150" class="lable">Father Name</td>
				<td width="370">'.$per_details['ffatname'].'</td>
				</tr>';
		$table1 .='<tr nobr="true">
				<td width="150" class="lable">Mother Name</td>
				<td width="370">'.$per_details['fmotname'].'</td>
				</tr>';

$table1 .= '</table>';
		// echo $table1;

$pdf->SetX(11);
		// $pdf->SetY(42);
		
		$pdf->writeHTML($table1, false, true, false, false, 'L');
		$pdf->ln(7);
		$html = '<h3 style="background-color: #918988; color: rgb(255, 255, 255);">II. Communication Details</h3>';
		$x = $pdf->GetX();
		$y = $pdf->GetY();
		$pdf->writeHTMLCell(188,0,$x,$y,$html, false,1, false, true, '', false);

$per_details['fperadd'] = $per_details['fpermadd1'].' '.$per_details['fpermadd2'].' '.$per_details['fpermadd3'].' '.$per_details['fpermdist'].' '.$per_details['fpermstate'].' - '.$per_details['fpermpin'];
		$per_details['fcuradd'] = $per_details['fcurradd1'].' '.$per_details['fcurradd2'].' '.$per_details['fcurradd3'].' '.$per_details['fcurrdist'].' '.$per_details['fcurrstate'].' - '.$per_details['fcurrpin'];
		$table2 = '<style>
			td {
			    border: 0.5px solid black;
			}
			.lable {
				font-weight: bold;
			}
		 </style>
		<table cellpadding="3" cellspacing="0">
			<tr nobr="true">
				<td width="150" class="lable">Permanent Address</td>
				<td width="370">'.$per_details['fperadd'].'</td>
		</tr>';

$table2 .= '<tr nobr="true">
				<td width="150" class="lable">Communication Address</td>
				<td width="370">'.$per_details['fcuradd'].'</td>
		</tr>';

$table2 .= '<tr nobr="true">
				<td width="150" class="lable">Mobile No.</td>
				<td width="370">'.$per_details['fmobileno'].'</td>
		</tr>'; 
		$table2 .= '<tr nobr="true">
				<td width="150" class="lable">Email Address</td>
				<td width="370">'.$per_details['femail'].'</td>
		</tr>';

$table2 .= '</table>';
		$pdf->SetX(11);
		$pdf->writeHTML($table2, false, true, false, false, 'L');
		$pdf->ln(7);

$html = '<h3 style="background-color: #918988; color: rgb(255, 255, 255);">III. Academic Details </h3>';
			$x = $pdf->GetX();
			$y = $pdf->GetY();
			$pdf->writeHTMLCell(188,0,$x,$y,$html, false,1, false, true, '', false);

// $pdf->SetX(2);
			
			$pdf = $this->pdf;

$x=1;
			$pdf->SetFont('Times', 'B', 9);
			$pdf->cell(15,5, "Degree","LRT",0,"C");
			$pdf->cell(45,5, "Subject","LRT",0,"C");
			$pdf->cell(50,5, "Institute/College","LRT",0,"C");
			$pdf->cell(15,5, "Year","LRT",0,"C");
			$pdf->cell(15,5, "Year","LRT",0,"C");
			$pdf->cell(15,5, "Max.","LRT",0,"C");
			$pdf->cell(15,5, "Obtained","LRT",0,"C");
			$pdf->cell(15,5, "% Marks","LRT",1,"C");

$pdf->SetFont('Times', 'B', 9);
			$pdf->cell(15,1, "","LB",0,"C");
			$pdf->cell(45,1, "","LB",0,"C");
			$pdf->cell(50,1, "","LB",0,"C");
			$pdf->cell(15,1, "of Adm","LB",0,"C");
			$pdf->cell(15,1, "of Passing","LB",0,"C");
			$pdf->cell(15,1, "Marks","LB",0,"C");
			$pdf->cell(15,1, "Marks","LBR",0,"C");
			$pdf->cell(15,1, "CGPA","LBR",1,"C");

foreach($rltacad as $key => $value){
			
            $pdf->SetFont('Times','',9);
            $pdf->cell(15,7, $value['fdegree'],"1",0,"C");						
            $pdf->cell(45,7, $value['fsubject'],"1",0,"C");
			$pdf->cell(50,7, $value['fcollege'],"1",0,"L");						
            $pdf->cell(15,7, $value['fadmyear'],"1",0,"C");
			$pdf->cell(15,7, $value['fpassyear'],"1",0,"C");						
            $pdf->cell(15,7, $value['fmaxmarks'],"1",0,"C");
			$pdf->cell(15,7, $value['fobtmarks'],"1",0,"C");						
            $pdf->cell(15,7, $value['fpercgpa'],"1",1,"C");
			
            
			}

$pdf->ln(7);

$html = '<h3 style="background-color: #918988; color: rgb(255, 255, 255);">IV. UGC-NET Details </h3>';
			$x = $pdf->GetX();
			$y = $pdf->GetY();
			$pdf->writeHTMLCell(188,0,$x,$y,$html, false,1, false, true, '', false);

// $pdf->SetX(2);
			
			$pdf = $this->pdf;

$x=1;
			$pdf->SetFont('Times', 'B', 9);
			$pdf->cell(20,5, "Roll No,","LRT",0,"C");
			$pdf->cell(30,5, "Award Letter","LRT",0,"C");
			$pdf->cell(20,5, "Award Letter","LRT",0,"C");
			$pdf->cell(40,5, "Subject","LRT",0,"C");
			$pdf->cell(12,5, "Max.","LRT",0,"C");
			$pdf->cell(12,5, "Marks","LRT",0,"C");
			$pdf->cell(12,5, "%","LRT",0,"C");
			$pdf->cell(40,5, "Qual for","LRT",1,"C");

$pdf->SetFont('Times', 'B', 9);
			$pdf->cell(20,1, "","LB",0,"C");
			$pdf->cell(30,1, "Ref No.","LB",0,"C");
			$pdf->cell(20,1, "Date","LB",0,"C");
			$pdf->cell(40,1, "","LB",0,"C");
			$pdf->cell(12,1, "Marks","LB",0,"C");
			$pdf->cell(12,1, "Obt.","LB",0,"C");
			$pdf->cell(12,1, "","LBR",0,"C");
			$pdf->cell(40,1, "(JRF/Asst Prof)","LBR",1,"C");

foreach($rltugc as $key => $value){
            $pdf->SetFont('Times','',9);
            $pdf->cell(20,7, $value['frollno'],"1",0,"C");						
			$pdf->cell(30,7, $value['frefno'],"1",0,"L");						
            $pdf->cell(20,7, $value['fawdate'],"1",0,"C");
			$pdf->cell(40,7, $value['fsubject'],"1",0,"C");
			$pdf->cell(12,7, $value['fmaxmarks'],"1",0,"C");						
			$pdf->cell(12,7, $value['fmarksobt'],"1",0,"C");						
            $pdf->cell(12,7, $value['fper'],"1",0,"C");
			$pdf->cell(40,7, $value['fqual'],"1",1,"C");
			
            
			}

$pdf->ln(7);

$html = '<h3 style="background-color: #918988; color: rgb(255, 255, 255);">V. Teacher Experience </h3>';
			$x = $pdf->GetX();
			$y = $pdf->GetY();
			$pdf->writeHTMLCell(188,0,$x,$y,$html, false,1, false, true, '', false);

// $pdf->SetX(2);
			
			$pdf = $this->pdf;

$x=1;
			$pdf->SetFont('Times', 'B', 9);
			$pdf->cell(35,5, "Organization","LRT",0,"C");
			$pdf->cell(30,5, "Position","LRT",0,"C");
			$pdf->cell(20,5, "Pay","LRT",0,"C");
			$pdf->cell(20,5, "Total ","LRT",0,"C");
			$pdf->cell(25,5, "Period","LRT",0,"C");
			$pdf->cell(23,5, "Period","LRT",0,"C");
			$pdf->cell(35,5, "Nature","LRT",1,"C");

$pdf->SetFont('Times', 'B', 9);
			$pdf->cell(35,1, "","LB",0,"C");
			$pdf->cell(30,1, "","LB",0,"C");
			$pdf->cell(20,1, "","LB",0,"C");
			$pdf->cell(20,1, "Experience","LB",0,"C");
			$pdf->cell(25,1, "Of Emp (from)","LB",0,"C");
			$pdf->cell(23,1, "Of Emp (to)","LB",0,"C");
			$pdf->cell(35,1, "Of Duty","LBR",1,"C");

foreach($rltexp as $key => $value){
			
            $pdf->SetFont('Times','',9);
            $pdf->cell(35,7, $value['forganization'],"1",0,"C");						
            $pdf->cell(30,7, $value['fposition'],"1",0,"C");
			$pdf->cell(20,7, $value['fpay'],"1",0,"C");						
            $pdf->cell(20,7, $value['ftotexp'],"1",0,"C");
			$pdf->cell(25,7, $value['ffrom'],"1",0,"C");						
            $pdf->cell(23,7, $value['fto'],"1",0,"C");
			$pdf->cell(35,7, $value['fduty'],"1",1,"C");						
			
            
			}

$pdf->ln(2);

$html = '<h3 style="background-color: #918988; color: rgb(255, 255, 255);">VI. Particulars of Publications </h3>';
			$x = $pdf->GetX();
			$y = $pdf->GetY();
			$pdf->writeHTMLCell(188,0,$x,$y,$html, false,1, false, true, '', false);

// $pdf->SetX(2);
			
			$pdf = $this->pdf;

$x=1;
			$pdf->SetFont('Times', 'B', 9);
			$pdf->cell(65,5, "Title of the Paper/Book","LRT",0,"C");
			$pdf->cell(65,5, "Name of the Journal/Publisher	","LRT",0,"C");
			$pdf->cell(56,5, "Place and year of Publication	","LRT",1,"C");

foreach($rltpub as $key => $value){
			
            $pdf->SetFont('Times','',9);
            $pdf->cell(65,7, $value['ftitle'],"1",0,"C");						
            $pdf->cell(65,7, $value['fjournal'],"1",0,"C");
			$pdf->cell(56,7, $value['fplace'],"1",1,"C");							
			
            
			}

$pdf->ln(7);

// $html = '<h3 style="background-color: #918988; color: rgb(255, 255, 255);">VI. Other Details </h3>';
			// $x = $pdf->GetX();
			// $y = $pdf->GetY();
			// $pdf->writeHTMLCell(188,0,$x,$y,$html, false,1, false, true, '', false);

// // $pdf->SetX(2);
			
			// $pdf = $this->pdf;

// $x=1;
			// $pdf->SetFont('Times', 'B', 9);
			// $pdf->cell(93,5, "Details of Professional experience","LRT",0,"C");
			// $pdf->cell(93,5, "Any other Achievements / Awards / Contribution","LRT",1,"C");

// foreach($rltoth as $key => $value){
			
            // $pdf->SetFont('Times','',9);
            // $pdf->cell(93,7, $value['fprofexp'],"1",0,"C");						
            // $pdf->cell(93,7, $value['fawards'],"1",1,"C");
										
			
            
			// }

$html = '<h3 style="background-color: #918988; color: rgb(255, 255, 255);">VII. Other Details</h3>';
		$x = $pdf->GetX();
		$y = $pdf->GetY();
		$pdf->writeHTMLCell(188,0,$x,$y,$html, false,1, false, true, '', false);

$per_details['fperadd'] = $per_details['fpermadd1'].' '.$per_details['fpermadd2'].' '.$per_details['fpermadd3'].' '.$per_details['fpermdist'].' '.$per_details['fpermstate'].' - '.$per_details['fpermpin'];
		$per_details['fcuradd'] = $per_details['fcurradd1'].' '.$per_details['fcurradd2'].' '.$per_details['fcurradd3'].' '.$per_details['fcurrdist'].' '.$per_details['fcurrstate'].' - '.$per_details['fcurrpin'];
		$table2 = '<style>
			td {
			    border: 0.5px solid black;
			}
			.lable {
				font-weight: bold;
			}
		 </style> 
		<table cellpadding="3" cellspacing="0">
			<tr nobr="true">
				<td width="175" style="text-align: center;" class="lable">Period of professional experience</td>
				<td width="175" style="text-align: center;" class="lable">The Institute where professional experience gained</td>
				
				<td width="175" style="text-align: center;" class="lable">Any other Achievements / Awards / Contribution</td>
		</tr>';

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

$table2 .= '<tr nobr="true">
				<td width="175">'.$value['fprofexp'].'</td>
				<td width="175">'.$value['fproexpgain'].'</td>
				<td width="175">'.$value['fawards'].'</td>
		</tr>'; 
		}

$table2 .= '</table>';
		$pdf->SetX(11);
		$pdf->writeHTML($table2, false, true, false, false, 'L');

$pdf->ln(7);

$html = '<h3 style="background-color: #918988; color: rgb(255, 255, 255);">VIII. Payment Details</h3>';
		$x = $pdf->GetX();
		$y = $pdf->GetY();
		$pdf->writeHTMLCell(188,0,$x,$y,$html, false,1, false, true, '', false);
		
		$table2 = '<style>
			td {
			    border: 0.5px solid black;
			}
			.lable {
				font-weight: bold;
			}
		 </style>
		<table cellpadding="3" cellspacing="0">
			<tr nobr="true">
				<td width="150" class="lable">Payment Type</td>
				<td width="370">'.$per_details['FPAYTYPE'].'</td>
		</tr>';

$table2 .= '<tr nobr="true">
				<td width="150" class="lable">Order ID</td>
				<td width="370">'.$per_details['FORDERID'].'</td>
		</tr>';

$table2 .= '<tr nobr="true">
				<td width="150" class="lable">Payment ID</td>
				<td width="370">'.$per_details['FPAYID'].'</td>
		</tr>'; 
		$table2 .= '<tr nobr="true">
				<td width="150" class="lable">Payment Status</td>
				<td width="370">'.$per_details['FPAYSTATUS'].'</td>
		</tr>';

$table2 .= '<tr nobr="true">
				<td width="150" class="lable">Amount Paid</td>
				<td width="370">'.$per_details['famount'].'</td>
		</tr>';

$table2 .= '<tr nobr="true">
				<td width="150" class="lable">Date</td>
				<td width="370">'.$per_details['FPAYDATE'].'</td>
		</tr>';

$table2 .= '</table>';
		$pdf->SetX(11);
		$pdf->writeHTML($table2, false, true, false, false, 'L');
		$pdf->ln(2);

$pdf->SetFont('Times','BU',13);

$pdf->Cell(180,7,'Declaration by the Candidate',0,1,'C');

$str = "I hereby declare that the information given above and in the enclosed documents is true to the best of my knowledge and belief and nothing has been concealed therein. I am well aware of the fact that if the information given by me is proved false / not true at any point of time, my candidature will be rejected / admission will be cancelled without assigning any reasons thereof.";
	
		$pdf->SetFont('Times','',13);
		$pdf->MultiCell(180,4,$str,0,'J');
		// $pdf->writeHTML($str, false, true, false, false, 'L');
		$pdf->ln(20);
		$pdf->SetFont('Times','B',10);
		$pdf->Cell(160,4,'Date',0,0,'L');
		$pdf->Cell(30,4,'Signature of the Student ',0,1,'R');
		$pdf->ln(8);

$pdf->SetFont('Times','BU',13);

// $pdf->Cell(180,7,'Declaration by the Candidate',0,1,'C');

$str = "Please send the completed application form to the respective Department Heads with “Application for PhD Admission in the department ....................” written on the envelop.
		To
		The Chairman,
		Department of ____________________
		Vijayanagara Sri Krishnadevaraya University,
		Vinayaka Nagar, Cantonment, Ballari -583105, Karnataka";
	
		$pdf->SetFont('Times','',14);
		$pdf->MultiCell(180,4,$str,1,'L');
			
		
		
		
	}
		
	function SendOutput()
	{
		// ob_end_clean();
		// ob_end_flush();
		// ob_end_clean();
		$this->pdf->Output("PHD_Application.pdf","D");
	}	 
}

function applicationFormPGReport($aobj_context)
{
	
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);

$appno=$_SESSION["APPNO"];

$per_details_query = "select ifnull(ps.fappno,'')as fappno, ifnull(ps.fmobileno,'')as fmobileno, ifnull(ps.fregno,'')as fregno,
    ifnull(ps.fname,'')as fname, ifnull(ps.fphotopath,'')as fphotopath, ifnull(ps.fnational,'')as fnational,
    if(ifnull(ps.fgender,'') = 'M','Male',if(ifnull(ps.fgender,'') = 'F','Female',if(ifnull(ps.fgender,'') = 'T','Transgender',''))) as fgender, date_format(ifnull(ps.fdob,''),'%d/%m/%Y') as fdob, ifnull(ps.ffatname,'')as ffatname, 
    ifnull(ps.fmotname,'')as fmotname, ifnull(ps.fcategory,'')as fcategory, ifnull(ps.faadharno,'')as faadharno,
    ifnull(ps.fpermadd1,'')as fpermadd1, ifnull(ps.fpermadd2,'')as fpermadd2, ifnull(ps.fpermadd3,'')as fpermadd3,
    ifnull(fpermdist,'')as fpermdist, ifnull(fpermstate,'')as fpermstate,ifnull(fpermpin,'')as fpermpin ,
   ifnull(fcurradd1,'')as fcurradd1, ifnull(fcurradd2,'')as fcurradd2, ifnull(fcurradd3,'')as fcurradd3,
    ifnull(fcurrdist,'')as fcurrdist, ifnull(fcurrpin,'')as fcurrpin, ifnull(fcurrstate,'')as fcurrstate,
    ifnull(femail,'')as femail, ifnull(fph,'')as fph, ifnull(fhk,'')as fhk, ifnull(po.fprofexp,'')as fprofexp,       
	ifnull(ps.FPAYTYPE,'')as FPAYTYPE,
	ifnull(ps.FORDERID,'')as FORDERID,
	ifnull(ps.FPAYID,'')as FPAYID,
	ifnull(ps.FPAYSTATUS,'')as FPAYSTATUS,
	date_format(ifnull(ps.FPAYDATE,''),'%d/%m/%Y')as FPAYDATE,
	ifnull(ps.famount,'')as famount,
	ifnull(po.fawards,'')as fawards,
	ifnull(ps.fhk,'')as fhk
	from phdstudadm ps left join phdothdet po on 
    ps.fappno=po.fappno
    where ps.fappno='{$appno}' and ps.FPAYSTATUS = 'success'";
	
	$per_details = $aobj_context->mobj_db->GetRow($per_details_query);

// var_dump($per_details_query);
	// die();

$qrypub = "select ftitle,fjournal,fplace from phdpub
    where fappno = '{$appno}'";

$rltpub = $aobj_context->mobj_db->GetAll($qrypub);

$qryexp="select forganization,fposition,fpay,ftotexp,ffrom,fto,fduty 
    from phdexp
    where fappno = '{$appno}'";

$rltexp = $aobj_context->mobj_db->GetAll($qryexp);

$qryacad = "select fdegree,fsubject,fcollege,fadmyear,fpassyear,fmaxmarks,fobtmarks,fpercgpa 
    from phdacademic
    where fappno = '{$appno}'";

$rltacad = $aobj_context->mobj_db->GetAll($qryacad);

$qryugc = "select ifnull(frollno,'') as frollno,ifnull(fsubject,'') as fsubject,
    ifnull(frefno,'') as frefno,date_format(ifnull(fawdate,''),'%d/%m/%Y') as fawdate,
    ifnull(fmaxmarks,'') as fmaxmarks,ifnull(fqual,'') as fqual,
    ifnull(fmarksobt,'') as fmarksobt,ifnull(fper,'') as fper from phdugcnet
    where fappno = '{$appno}'";

$rltugc = $aobj_context->mobj_db->GetAll($qryugc);

$qryoth = "select fprofexp,fawards,fproexpgain
    from phdothdet
    where fappno = '{$appno}'";

$rltoth = $aobj_context->mobj_db->GetAll($qryoth);

$qrydeg = "select pd.fdegcode as fdegcode ,pd.fdespcn as fdespcn 
    from phddeg pd
    inner join phdstudadm ps on ps.fphddeg = pd.fdegcode
    where ps.fappno = '{$appno}'";

$per_deg = $aobj_context->mobj_db->GetRow($qrydeg);

// var_dump($per_deg);
	// die();

$aobj_context->degree=$per_deg['fdespcn'];

// var_dump($rltacad);
	// die();

$cnt = 0;

$class_obj = new AddmissionApplication();
	
	$class_obj->DefaultConstructor($aobj_context);

$class_obj->writeApplication($per_details,$rltacad,$rltexp,$rltpub,$rltoth,$rltugc);
	// $class_obj->Header($per_deg);

$class_obj->SendOutput();
}

${this.title}

Code Editor : vkuapplicationFormPGReport.php