Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
applicationFormReportPOSTOFFIC...	19.27 KB	-rwxrwxrwx
applicationFormReportSBM.php	8.41 KB	-rwxrwxrwx
caccesscontext.php	1.24 KB	-rwxrwxrwx
cappcontext.php	2.66 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
dropdown.php	844 B	-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
json.php	33.2 KB	-rwxrwxrwx
kusphdadm.php	25.93 KB	-rwxrwxrwx
kusphdadm_01122018.php	17.73 KB	-rwxrwxrwx
kusphdadm_04122018.php	14.16 KB	-rwxrwxrwx
kusphdadm_07032020.php	18.3 KB	-rwxrwxrwx
kusphdadm_16092018.php	11.4 KB	-rwxrwxrwx
kusphdadm_17092018.php	11.72 KB	-rwxrwxrwx
kusphdadm_170920181.php	12 KB	-rwxrwxrwx
kusphdadm_18092018.php	15.92 KB	-rwxrwxrwx
mregistry.php	4.97 KB	-rwxrwxrwx
re_rigistration.php	7.38 KB	-rwxrwxrwx
report_bulk_applications.php	30.29 KB	-rwxrwxrwx
report_bulk_applications_04122...	19.42 KB	-rwxrwxrwx
report_bulk_applications_05082...	24.53 KB	-rwxrwxrwx
report_bulk_applications_08092...	19.42 KB	-rwxrwxrwx
report_bulk_applications_16092...	19.42 KB	-rwxrwxrwx
report_bulk_applications_20092...	19.42 KB	-rwxrwxrwx
report_bulk_applications_xxx.p...	26.92 KB	-rwxrwxrwx
report_hall_ticket.php	11.31 KB	-rwxrwxrwx
reportapplicationform - Copy.p...	19.59 KB	-rwxrwxrwx
reportapplicationform.php	23.92 KB	-rwxrwxrwx
rotation.php	596 B	-rwxrwxrwx
saveApplication.php	8.91 KB	-rwxrwxrwx
saveRerigistration.php	10.87 KB	-rwxrwxrwx
student.php	15.77 KB	-rwxrwxrwx
student_04122018.php	13.67 KB	-rwxrwxrwx
subfeedetl.php	3.39 KB	-rwxrwxrwx

Code Editor : report_bulk_applications_xxx.php

<?php
$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/logo.jpg";
		
		if(file_exists($img_path)) 
			$this->Image($img_path,10,6,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->Cell(0,4,'College : '.$this->aobj_context->col_name,0,1,'C');
				 
		$this->SetFont('Times','B',12);
		$this->Ln(1);
		
		$cur_year = date("Y");
		$this->Cell(180,5,'Application for Admission ('.$cur_year.')','0',1,'C');

$this->Ln(1);
		$this->Cell(180,5,'Course : '.$this->aobj_context->degree,'0',1,'C');
		$this->Ln(1);

$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->FAPPNO, 'C39', '153', '1',90, 16, 0.25, $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'];
		$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);

$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);
		
		$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'];

$get_college_name="select concat(FCOLLNAME,', ',FTOWN) as col_name from college where FCOLLCODE='{$aobj_context->fcollcode}'";
		$lobj_get_college_name = $this->aobj_context->mobj_db->GetRow($get_college_name);
		$aobj_context->col_name = $lobj_get_college_name['col_name'];
		$this->aobj_context->current_date =  $obj['now_date'];
		$app_no = trim($aobj_context->mobj_data["app_no"]);
		$query = "select d.fdescpn as degree from studadm s inner join degree d on s.fdegree = d.fdegree and d.fexamno = 'a' and fappno = '{$app_no}'";
		$result = $this->aobj_context->mobj_db->GetRow($query);
		$aobj_context->degree = $result['degree'];
		$this->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', 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, $subjects,$upload,$feedet)
	{

$pdf=$this->pdf;

$pdf->SetMargins(10,30,20,false);
		$pdf->startPageGroup();
		$pdf->AddPage("P");

$pdf->SetFont('Times','',11);

//====================Personal Details====================================
		$html = '<h3 style="background-color: #918988; color: rgb(255, 255, 255);"> Personal Details</h3>';
		$x = $pdf->GetX();
		$y = $pdf->GetY();
		$pdf->writeHTMLCell(188,0,$x,$y,$html, false,1, false, true, '', false);
		// $pdf->ln(2);
		// $path = realpath(__DIR__ . '/../..');
		// var_dump($path.'/'.$per_details['fphotopath']);
		$path = "https://university-student-photos.s3.ap-south-1.amazonaws.com/027";
		$i= 1;

$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="2" style = "font-size:15px;">'.$per_details['FAPPNO'].'</td>
				<td width="100" rowspan="5"><img width="100" height="100" src="'.$path.'/'.$per_details['fphotopath'].'" ></td>
		</tr>';

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

$table1 .='<tr nobr="true">
				<td width="150" class="lable" >Father`s /Guardian`s Name</td>
				<td width="270" colspan="2">'.$per_details['FFATNAME'].'</td></tr>';

$table1 .='<tr nobr="true">
				<td width="150" class="lable">Mother`s Name</td>
				<td width="270" colspan="2">'.$per_details['FMOTNAME'].'</td></tr>';

$table1 .='<tr nobr="true">
				<td width="150" class="lable">Date of Birth</td>
				<td width="135">'.$per_details['fdob'].'</td>
				<td width="70" class="lable">Gender</td>
				<td width="65">'.$per_details['FSEX'].'</td>
				</tr>';

$table1 .='<tr nobr="true">
				<td width="150" class="lable">Nationality</td>
				<td width="135">'.$per_details['FNATIONAL'].'</td>
				<td width="70" class="lable">Religion</td>
				<td width="65">'.$per_details['freligion'].'</td>
				<td width="100" rowspan="2"><img width="100" height="30" src="'.$path.'/'.$per_details['fsignpath'].'" ></td>
				</tr>';

$table1 .='<tr nobr="true">
				<td width="150" class="lable">Caste</td>
				<td width="135">'.$per_details['FCATBIRTH'].'</td>
				<td width="70" class="lable">Category</td>
				<td width="65" >'.$per_details['FCASTE'].'</td>
				</tr>';

$table1 .='<tr nobr="true">
				<td width="150" class="lable">Aadhaar No.</td>
				<td width="135">'.$per_details['FAADHARNO'].'</td>
				<td width="135" class="lable">Blood Group</td>
				<td width="100" >'.$per_details['fblood_group'].'</td>
				</tr>';

$table1 .='<tr nobr="true">
				<td width="150" class="lable">Rural / Urban</td>
				<td width="135">'.$per_details['FAREA'].'</td>
				<td width="135" class="lable">Annual family Income</td>
				<td width="100">'.$per_details['FINCOME'].'</td>
				</tr>';

$table1 .='<tr nobr="true">
				<td width="150" class="lable">Admission Quota</td>
				<td width="135">'.$per_details['fquota'].'</td>
				<td width="135" class="lable">Medium</td>
				<td width="100">'.$per_details['fmedium'].'</td>
				</tr>';
		$table1 .='<tr nobr="true">
				<td width="150" class="lable">Income Certificate No.</td>
				<td width="135">'.$per_details['fincomecert'].'</td>
				<td width="135" class="lable">Caste Certificate No.</td>
				<td width="100">'.$per_details['fcastecert'].'</td>
				</tr>';
		$table1 .='<tr nobr="true">
				<td width="150" class="lable">Physicaly disabled</td>
				<td width="370">'.$per_details['fph'].'</td>
				</tr>';

$table1 .= '</table>';

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

$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">Email Address</td>
				<td width="370">'.$per_details['FEMAIL'].'</td>
		</tr>';

$table2 .= '<tr nobr="true">
				<td width="150" class="lable">Mobile No.</td>
				<td width="110">'.$per_details['FCONTACT_NO'].'</td>
				<td width="150" class="lable">Contact No.</td>
				<td width="110">'.$per_details['fmobileno'].'</td>
		</tr>';

$table2 .= '<tr nobr="true">
				<td width="150" class="lable">Parents mobile No.</td>
				<td width="110">'.$per_details['fmobileno'].'</td>
				<td width="150" class="lable">Student Type.</td>
				<td width="110">'.$per_details['FSTUTYPE'].'</td>
		</tr>';
		
		$table2 .= '</table>';
		$pdf->SetX(11);
		$pdf->writeHTML($table2, false, true, false, false, 'L');
		$pdf->ln(2);
		//====================Degree Details====================================
		$html = '<h3 style="background-color: #918988; color: rgb(255, 255, 255);"> Subjects Opted</h3>';
		$x = $pdf->GetX();
		$y = $pdf->GetY();
		$pdf->SetMargins(10,30);
		$pdf->writeHTMLCell(188,0,$x,$y,$html, false,1, false, true, '', false);
		// $pdf->ln(2);
		
		$i = 1;
		$head = '<style>
			td {
			    border: 0.5px solid black;
			}
		 </style>
		 <table cellpadding="3" cellspacing="0">';
		
		//====================Subject Details====================================
		$table2 = '<style>
			td, th {
			    border: 0.5px solid black;
			}
		 </style>
		<table cellpadding="1" cellspacing="0">
			<tr nobr="true"><th width="40" align="center"><b>Sl. No.</b></th>
				<th width="60" align="center"><b>Subject Code</b></th>
				<th width="360" align="center"><b>Subject Name</b></th>
				<th width="60" align="center"><b>Short Name</b></th>
			</tr>';
		$i=1;
		foreach ($subjects as $key => $value) 
		{
			$table2 .= '<tr nobr="true">
				<td width="40" align="center">'.$i.'</td>
				<td width="60" align="center">'.$value['fsubcode'].'</td>
				<td width="360">'.$value['fsubname'].'</td>
				<td width="60" align="center">'.$value['fsubshort'].'</td></tr>';
			$i++;
		}

$table2 .='</table>';
		$pdf->SetX(11);
		if(count($subjects)>0)
			$pdf->writeHTML($table2, true, true, false, false, 'L');
		
		$pdf->AddPage("P");
		// $pdf->SetMargins(10,30);
		$pdf->ln(3);
		$html = '<h3 style="background-color: #918988; color: rgb(255, 255, 255);"> Qualifying Examination Details</h3>';
		$x = $pdf->GetX();
		$y = $pdf->GetY();
		$pdf->writeHTMLCell(188,0,$x,$y,$html, false,1, false, true, '', false);
		$pdf->ln(1);

$pdf->SetX(11);
		
		// $query = "SELECT fboardname FROM masboard WHERE fboardcode = '{$per_details['FUNIVNAME']}'";
		// $obj_univ =  $this->aobj_context->mobj_db->GetRow($query); 
		// $per_details['FUNIVNAME'] = $obj_univ['fboardname'];

$table4 = '<style>
			td {
			    border: 0.5px solid black;
			}
		 </style><table cellpadding="3" cellspacing="0">
		 <tr nobr="true">
				<td width="200"><b>Passed in supplementary examination ?</b></td>
				<td width="320">'.$per_details['fsupstud'].'</td>
		</tr> 
		 <tr nobr="true">
				<td width="200"><b>Name of the Class / qualifying examination last studied</b></td>
				<td width="320">'.$per_details['FTYPEQUALEXAM'].'</td>
		</tr>
		 <tr nobr="true">
				<td width="200" ><b>Name of the board / University last studied</b></td>
				<td width="320" >'.$per_details['FUNIVNAME'].'</td>
		</tr>';

/*$table4 .= '<tr nobr="true">
				<td width="200" ><b>Subjects studied along with Languages</b></td>
				<td width="320" >'.'Kannada, English, Physics, Chemistry, Mathematics'.'</td>
		</tr>';*/

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

$table5 = '<style>
			td, th {
			    border: 0.5px solid black;
			}
		 </style>
		 <table cellpadding="3" cellspacing="0">
			<tr nobr="true">
			<thead>
				<th width="100" align="center"><b>Reg. No.</b></th>
				<th width="100" align="center"><b>Month & Year</b></th>
				<th width="110" align="center"><b>Max. Marks</b></th>
				<th width="110" align="center"><b>Marks Obtained</b></th>
				<th width="100" align="center"><b>Percentage</b></th>
			</thead>
			</tr>';//Percentage

$table5 .= '<tr nobr="true">
				<td width="100" align="center">'.$per_details['FQUALEXREGNO'].'</td>
				<td width="100" align="center">'.$per_details['FQMONTH'].' / '.$per_details['FQYEAR'].'</td>
				<td width="110" align="center">'.$per_details['FQMAXMARKS'].'</td>
				<td width="110" align="center">'.$per_details['FQSECMARKS'].'</td>
				<td width="100" align="center">'.$per_details['FQPERCENTAGE'].'</td>
			</tr>';

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

$query = "select fappno, fsubcode, fsubname, fsecmarksa, fmaxmarksa, fsecmarksb, fmaxmarksb, fsecmarksc, fmaxmarksc,
		fsecmarksd, fmaxmarksd, fsecmarkse, fmaxmarkse, fsecmarksf, fmaxmarksf, ftotsecmarks, ftotmaxmarks, fsubpercent  
		from qualsubdet where fappno = '{$per_details['FAPPNO']}'  order by fsubname";
		$result = $this->aobj_context->mobj_db->GetAll($query);	
		
		$pdf->SetFont('Times','',10);
		if(count($result) > 0)
		{
			$table5 = '<style>
				td, th {
					border: 0.5px solid black;
				}
			</style>
			<table cellpadding="2" cellspacing="0">
				<tr nobr="true">
					<th width="520" colspan="7" align="center"><b>Details of the marks obtained in all the optional subjects in qualifying Degree Examination</b></th>
				</tr>
				<thead>
					<tr nobr="true">
						<th width="20" rowspan="2" align="center"><b>Sl. No</b></th>
						<th width="115" align="center" rowspan="2"><b>Subject</b></th>
						<th width="50" colspan="2" align="center"><b>Sem I / Year</b></th>
						<th width="50" colspan="2" align="center"><b>Sem II / Year</b></th>
						<th width="50" colspan="2" align="center"><b>Sem III / Year</b></th>
						<th width="50" colspan="2" align="center"><b>Sem IV / Year</b></th>
						<th width="50" colspan="2" align="center"><b>Sem V / Year</b></th>
						<th width="50" colspan="2" align="center"><b>Sem VI / Year</b></th>
						<th width="50" colspan="2" align="center"><b>Total Marks</b></th>
						<th width="35" align="center" rowspan="2"><b>%</b></th>
					</tr>
					<tr nobr="true">
						<th width="25" align="center"><b>Obt</b></th>
						<th width="25" align="center"><b>Max</b></th>
						<th width="25" align="center"><b>Obt</b></th>
						<th width="25" align="center"><b>Max</b></th>
						<th width="25" align="center"><b>Obt</b></th>
						<th width="25" align="center"><b>Max</b></th>
						<th width="25" align="center"><b>Obt</b></th>
						<th width="25" align="center"><b>Max</b></th>
						<th width="25" align="center"><b>Obt</b></th>
						<th width="25" align="center"><b>Max</b></th>
						<th width="25" align="center"><b>Obt</b></th>
						<th width="25" align="center"><b>Max</b></th>
						<th width="25" align="center"><b>Obt</b></th>
						<th width="25" align="center"><b>Max</b></th>
					</tr>
				</thead>';//Percentage
				$i = 1;
			foreach($result as $value) 
			{	
				$table5 .= '<tr nobr="true">
						<td width="20" align="center">'.$i.'</td>
						<td width="115" align="left">'.$value['fsubname'].'</td>
						<td width="25" align="center">'.$value['fsecmarksa'].'</td>
						<td width="25" align="center">'.$value['fmaxmarksa'].'</td>
						<td width="25" align="center">'.$value['fsecmarksb'].'</td>
						<td width="25" align="center">'.$value['fmaxmarksb'].'</td>
						<td width="25" align="center">'.$value['fsecmarksc'].'</td>
						<td width="25" align="center">'.$value['fmaxmarksc'].'</td>
						<td width="25" align="center">'.$value['fsecmarksd'].'</td>
						<td width="25" align="center">'.$value['fmaxmarksd'].'</td>
						<td width="25" align="center">'.$value['fsecmarkse'].'</td>
						<td width="25" align="center">'.$value['fmaxmarkse'].'</td>
						<td width="25" align="center">'.$value['fsecmarksf'].'</td>
						<td width="25" align="center">'.$value['fmaxmarksf'].'</td>
						<td width="25" align="center">'.$value['ftotsecmarks'].'</td>
						<td width="25" align="center">'.$value['ftotmaxmarks'].'</td>
						<td width="35" align="center">'.$value['fsubpercent'].'</td>
					</tr>';
					$i++;
			}	
			$table5 .='</table>';
			//$pdf->SetX(11);
			
			// $pdf->writeHTML($table5, true, false, true, false, 'L');

}

$pdf->SetFont('Times','',11);
		$pdf->ln(1);
		$html = '<h3 style="background-color: #918988; color: rgb(255, 255, 255);"> Documents Check List</h3>';
		$x = $pdf->GetX();
		$y = $pdf->GetY();
		$pdf->writeHTMLCell(188,0,$x,$y,$html, false,1, false, true, '', false);
		// $pdf->ln(1);
		
		
		$table5 = '<style>
		td, th {
		    border: 0.5px solid black;
		}
	 	</style>
	 	<table cellpadding="2" cellspacing="0">
		<tr nobr="true">
			<th width="50" align="center"><b>Sl. No.</b></th>
			<th width="400" align="center"><b>Document</b></th>
			<th width="70" align="center"><b>Uploaded</b></th>
		</tr>';

$i=1;
		
		foreach ($upload as $key => $value) 
		{

$table5 .= '<tr nobr="true">
				<td width="50" align="center">'.$i.'</td>
				<td width="400" >'.$value['fcertdesc'].'</td>
				<td width="70" align="center" >'.$value['fstatus'].'</td></tr>';
				
			$i++;
		}

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

$html = '<h3 style="background-color: #918988; color: rgb(255, 255, 255);"> Fee Details</h3>';
		$x = $pdf->GetX();
		$y = $pdf->GetY();
		$pdf->SetMargins(10,30);
		$pdf->writeHTMLCell(188,0,$x,$y,$html, false,1, false, true, '', false);
		// $pdf->ln(2);
		
		$pdf->ln(4);
			$pdf->SetFont('Times','B',11); 
			$pdf->Cell(185,6,'Payment Details',1,1,'C');				
			
			$pdf->SetFont('Times','',11); 			
			$pdf->Cell(35,6,'Total Fee',1,0,'L');
			$pdf->Cell(50,6,"{$per_details['FTOTFEE']}/-",1,0,'L');

$pdf->Cell(35,6,'Payment Date',1,0,'L');
			$pdf->Cell(65,6,"{$per_details['FPAYDATE']}",1,1,'L');

$pdf->Cell(35,6,'Transaction id',1,0,'L');	
			$pdf->Cell(150,6,"{$per_details['FPAYID']}",1,1,'L'); 
			
			$pdf->Cell(35,6,'Payment Type',1,0,'L');			
			$pdf->Cell(50,6,"{$per_details['FPAYTYPE']}",1,0,'L');

$pdf->Cell(35,6,'Payment Status',1,0,'L');
			$pdf->Cell(65,6,"{$per_details['FPAYSTATUS']}",1,1,'L');
			$pdf->ln(2);
		$i = 1;
		$head = '<style>
			td {
			    border: 0.5px solid black;
			}
		 </style>
		 <table cellpadding="3" cellspacing="0">';
		
		//====================Subject Details====================================
		$table2 = '<style>
			td, th {
			    border: 0.5px solid black;
			}
		 </style>
		<table cellpadding="1" cellspacing="0">
			<tr nobr="true"><th width="40" align="center"><b>Sl. No.</b></th>
				<th width="420" align="center"><b>Head Code</b></th>
				<th width="60" align="center"><b>Amount</b></th>
			</tr>';
		$i=1;
		$totamount = 0;
		foreach ($feedet as $key => $value) 
		{
			$table2 .= '<tr nobr="true">
				<td width="40" align="center">'.$i.'</td>
				<td width="420">'.$value['fheadcode'].'</td>
				<td width="60" align="center">'.$value['famount'].'</td></tr>';
			$i++;
			$totamount += $value['famount'];
		}
		$table2 .= '<tr nobr="true">
		<td width="40" align="center">'.$i.'</td>
		<td width="420">Total</td>
		<td width="60" align="center">'.$totamount.'</td></tr>';
		$table2 .='</table>';
		$pdf->SetX(11);
		if(count($feedet)>0)
			$pdf->writeHTML($table2, true, true, false, false, 'L');
			
		$pdf->ln(10);
		
		if($pdf->GetY() > 210)
		{
			$pdf->AddPage();
		}

$pdf->ln(10);
		
		$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(1);

// if($pdf->GetY() > 210)
		// {
		// 	$pdf->AddPage();
		// }
		$pdf->SetFont('Times','BU',10);
		$pdf->Cell(180,4,'Note:',0,1,'C');
		$pdf->SetFont('Times','',11);
		$pdf->MultiCell(180,4,"1.  Merely submitting the application form and payment of admission fees does not entitle the candidate's",0,'J');
		$pdf->MultiCell(180,4,"       admission to the course unless and until all the documents are verified and found correct.",0,'L');
		$pdf->MultiCell(180,4,"2.   Any information given, if later found to be incorrect, the admission of the candidate will be cancelled without",0,'J');
		$pdf->MultiCell(180,4,"      prior notice to the concerned Principal or candidate.",0,'L');
		$pdf->MultiCell(180,4,"3.  The Principal will be solely held responsible for fake certificates / documents submitted from fake / non",0,'J');
		$pdf->MultiCell(180,4,"       recognized Boards / Institutions.",0,'L');
		$pdf->SetFont('Times','B',10);
		$pdf->ln(8);
		$pdf->Cell(160,4,'Date:',0,0,'L');
		$pdf->Cell(30,4,'Signature of the Principal with Seal',0,1,'R');
		$pdf->ln(2);
		
		// $pdf->ln(10);	
		$table6 = '<style>
		td, th {
		    border: 0.5px solid black;
		}
	 	</style>
	 	<table cellpadding="3" cellspacing="0">
	 	<tr nobr="true">
				<th width="530" colspan="4" align="center"><b><b>FOR OFFICE USE ONLY ( UNIVERSITY )</b></b></th>
			</tr>
			<tr nobr="true"><th width="120" align="center"><b>Application No.</b></th>
				<th width="100" align="center"><b>Approved</b></th>
				<th width="100" align="center"><b>Approval Sl. No.</b></th>
				<th width="210" align="center"><b>Remarks</b></th>
			</tr>';

$table6 .= '<tr nobr="true">
		<td width="120" style = "text-align:center;">'.$per_details['FAPPNO'].'</td>
		<td width="100"></td>
		<td width="100"></td>
		<td width="210"></td>
			</tr>';
		$table6 .='</table>';
		$pdf->SetX(11);
		$pdf->writeHTML($table6, true, false, true, false, 'L');
		
		$pdf->ln(2);
		$pdf->Cell(180,4,'Signature of the Verifier:',0,1,'C');
		$pdf->ln(5);
		$pdf->Cell(160,4,'Signature of the Superintendent',0,0,'L');	
		$pdf->Cell(30,4,'Signature of the Asst.Reg.',0,1,'R');	
		$pdf->ln(10);
		$pdf->Cell(180,4,'Registrar',0,1,'C');
	}
		
	function SendOutput()
	{
		$this->pdf->Output("Application_letter{$this->current_date}.pdf","D");
	}	 
}

function printApplication($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	
	$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=$aobj_context->mobj_db->GetRow($get_coll_name);

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

$per_details_query = "select sa.FNAME,sa.FAPPNO, sa.FFATNAME,sa.FCOLLCODE,sa.fslno, sa.fcollcode,
	sa.FMOTNAME, if(ifnull(sa.fgender,'') = 'M','Male',if(ifnull(sa.fgender,'') = 'F','Female','Transgender')) as FSEX,
	replace(replace(ifnull(sa.fblood_group,''),'P','+'),'M','-') as fblood_group,
	ifnull(sa.freligion,'') as freligion, ifnull(sa.fquota,'') as fquota, ifnull(sa.fmedium,'') as fmedium,
	ifnull(sa.FSTUTYPE,'') as FSTUTYPE,  
	ifnull(sa.fincomecert,'') as fincomecert,
	ifnull(sa.fcastecert,'') as fcastecert,
	ifnull(sa.fph,'') as fph,
	ifnull(FCATBIRTH,'') as FCATBIRTH, ifnull(sa.FCASTE,'') as FCASTE,
	sa.FNATIONAL, date_format(sa.FDOB,'%d/%m/%Y') as fdob, 
	date_format(sa.FADMDATE,'%d/%m/%Y') as FADMDATE, sa.FAADHARNO,
	concat(ifnull(sa.FCURRADD1,''),' ', ifnull(sa.FCURRADD2,''), ' ', 
	ifnull(sa.FCURRADD3,''),' ', ifnull(sa.FCOMDIST,''), ' ', 
	ifnull(sa.FCOMSTATE,''), ' - ', ifnull(sa.FCOMPINCODE,'') ) as fcuradd, 
	concat(ifnull(sa.FPERMADD1,''),' ', ifnull(sa.FPERMADD2,''), ' ', 
	ifnull(sa.FPERMADD3,''),' ', ifnull(sa.FPERDIST,''), ' ', 
	ifnull(sa.FPERSATE,''), ' - ', ifnull(sa.FPERPINCODE,'')) as fperadd, 
	ifnull(FMOBILE_NO,'') as fmobileno, 
	ifnull(sa.FCONTACT_NO,'') as FCONTACT_NO, ifnull(sa.FEMAIL,'') as FEMAIL, 
	sa.FINCOME, sa.FDEGREE, sa.FCOMBCODE,
	ifnull(sa.fsupstud,'No') as fsupstud,
	sa.FAADHARNO, dg.FEXAMNO, dg.fdescpn as fdegname,
	dg.fexamname as fexamname, CONCAT(cl.FCOLLNAME,', ',cl.FTOWN) as FCOLLNAME,
	ifnull(sa.FTYPEQUALEXAM,'') as FTYPEQUALEXAM, ifnull(sa.FUNIVNAME,'') as FUNIVNAME,
	ifnull(sa.FQUALEXREGNO,'') as FQUALEXREGNO,
	ifnull(sa.FAREA,'') as FAREA, ifnull(sa.FQMONTH,'') as FQMONTH, 
	ifnull(sa.FQYEAR,'') as FQYEAR, ifnull(sa.FQMAXMARKS,'') as FQMAXMARKS, 
	ifnull(sa.FQSECMARKS,'') as FQSECMARKS, ifnull(sa.FQPERCENTAGE,'') as FQPERCENTAGE, 
	ifnull(sa.fphotopath,'') as fphotopath, ifnull(FSIGNPATH,'') as fsignpath, 
	ifnull(sa.FTOTFEE,0) as FTOTFEE, ifnull(FADMFINE,0) as FADMFINE,
	ifnull(sa.FPAYID,'-') as FPAYID,
	ifnull(sa.FPAYSTATUS,'-') as FPAYSTATUS,
	DATE_FORMAT(sa.FPAYDATE,'%d/%m/%Y %h:%s:%i %p') as FPAYDATE
	FROM studadm sa inner join degree dg 
	on sa.fdegree = dg.fdegree
	and sa.fexamno = dg.fexamno inner join college cl
	on sa.fcollcode = cl.fcollcode
	WHERE sa.FAPPNO = '{$app_no}'
	and ifnull(sa.FPAYSTATUS,'') = 'success'";
	//var_dump($per_details_query);
	$per_details = $aobj_context->mobj_db->GetAll($per_details_query);

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

foreach($per_details as $key => $value)
	{
		$class_obj = new AddmissionApplication();
		$aobj_context->FAPPNO = $value['FAPPNO'];
		$aobj_context->fcollcode = $value['fcollcode'];
		$aobj_context->fdegree = $value['FDEGREE'];
		$class_obj->DefaultConstructor($aobj_context);

$subject_query = "select distinct su.fsubcode, su.fsubname, su.fsubshort
		from subject su inner join options op 
		on su.fdegree = op.fdegree
		and su.fexamno = op.fexamno
		and su.fsubcode = op.fsubcode
		where fappno = '{$value['FAPPNO']}'
		order by su.fsubcode";
		$subjects = $aobj_context->mobj_db->GetAll($subject_query);

$fee_query = "select distinct fheadcode, famount
		from admfeedetl
		where fappno = '{$value['FAPPNO']}'
		order by fheadcode";
		$fee_res = $aobj_context->mobj_db->GetAll($fee_query);

$query = "SELECT m.fcertdesc, m.FFILENAME, 
		IF(IFNULL(s.file_path,'') = '','No','Yes') AS fstatus ,
		s.file_path FROM masdoc m inner join studoc s ON 
		m.ffilename = s.fdoctype 
		and IFNULL(s.login_cnt,'') = '{$aobj_context->FAPPNO}' 
		AND s.fdegree = '{$aobj_context->fdegree}' 
		AND s.fcollcode = '{$aobj_context->fcollcode}' 
		GROUP BY m.FFILENAME ORDER BY m.forder";

$upload = $aobj_context->mobj_db->GetAll($query);

$class_obj->writeApplication($value, $subjects,$upload,$fee_res);
	}
	
	$class_obj->SendOutput();
}

${this.title}

Code Editor : report_bulk_applications_xxx.php