Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
PHPExcel	[ DIR ]	drwxr-xr-x
output	[ DIR ]	drwxr-xr-x
DownloadExamAppFormApplication...	5.72 KB	-rwxr-xr-x
DownloadRvRtAckApplications.ph...	5.26 KB	-rwxr-xr-x
ExcelWriterXML.php	16.29 KB	-rwxr-xr-x
ExcelWriterXML_Sheet.php	15.83 KB	-rwxr-xr-x
ExcelWriterXML_Style.php	23.71 KB	-rwxr-xr-x
PrintApplicationFormAdmPOSTOFF...	12.64 KB	-rwxr-xr-x
PrintChallanEntryDetails.php	8.36 KB	-rwxr-xr-x
RvRtApplicationReport.php	8.76 KB	-rwxr-xr-x
ack_exam_app_form_bulk.php	11.63 KB	-rwxr-xr-x
admChallanEntryDetails.php	7.01 KB	-rwxr-xr-x
answer_book_statistics.php	6.79 KB	-rwxr-xr-x
appear_list_center_qp_wise.php	7.33 KB	-rwxr-xr-x
appear_list_qp_wise.php	5.67 KB	-rwxr-xr-x
appfeedetails.php	8.73 KB	-rwxr-xr-x
appfeedetails_pdf.php	7.48 KB	-rwxr-xr-x
appfeedetailspdf.php	7.58 KB	-rwxr-xr-x
batch_wise_details.php	4.45 KB	-rwxr-xr-x
bundle_ despatch_ statement.ph...	5.78 KB	-rwxr-xr-x
cManualMailer.php	1.45 KB	-rwxr-xr-x
cappcontext.php	2.64 KB	-rwxr-xr-x
cconfig.php	1.14 KB	-rwxr-xr-x
code39.php	6.38 KB	-rwxr-xr-x
college_degree_details.php	4.57 KB	-rwxr-xr-x
college_pending_markslist.php	6.74 KB	-rwxr-xr-x
fee_summary.php	13.15 KB	-rwxr-xr-x
fee_summary_oldformat.php	7.47 KB	-rwxr-xr-x
generatePostAdmissionTicket.ph...	38.63 KB	-rwxr-xr-x
getnumword.php	7.43 KB	-rwxr-xr-x
hallticketcomm.php	29.47 KB	-rwxr-xr-x
htstatus.php	6.73 KB	-rwxr-xr-x
iaemptyformat.php	7.1 KB	-rwxr-xr-x
index.php	4.54 KB	-rwxr-xr-x
marklist_studentwise.html	4.29 KB	-rwxr-xr-x
marls_subjectwise.php	10.22 KB	-rwxr-xr-x
mregistry.php	73.81 KB	-rwxr-xr-x
photo_report.php	4.49 KB	-rwxr-xr-x
practical_marks_details.php	12.17 KB	-rwxr-xr-x
practical_marks_report.php	5.45 KB	-rwxr-xr-x
report_ack_registration.php	6.4 KB	-rwxr-xr-x
report_admission_details.php	26.8 KB	-rwxr-xr-x
report_admission_list.php	17.07 KB	-rwxr-xr-x
report_admission_ticket.php	47.1 KB	-rwxr-xr-x
report_answer_book_issued.php	8.41 KB	-rwxr-xr-x
report_attendance_sheet.php	12.75 KB	-rwxr-xr-x
report_attendance_shortage.php	9.23 KB	-rwxr-xr-x
report_attendance_summary.php	7.17 KB	-rwxr-xr-x
report_attendance_summary_back...	7.15 KB	-rwxr-xr-x
report_bacth_preparation_dairy...	7.05 KB	-rwxr-xr-x
report_batch_practical_dairy.p...	15.32 KB	-rwxr-xr-x
report_batch_wise_details.php	7.93 KB	-rwxr-xr-x
report_batch_worksheet_details...	11.18 KB	-rwxr-xr-x
report_bulk_applications.php	21.86 KB	-rwxr-xr-x
report_bundle_dispatch.php	8.65 KB	-rwxr-xr-x
report_candidate_list.php	29.08 KB	-rwxr-xr-x
report_daliy_report.php	10.88 KB	-rwxr-xr-x
report_daliy_report_qp.php	14.73 KB	-rwxr-xr-x
report_degree_list.php	4.71 KB	-rwxr-xr-x
report_deviation_report.php	7.67 KB	-rwxr-xr-x
report_evaluation_report.php	9.31 KB	-rwxr-xr-x
report_iamarks_pending.php	8.19 KB	-rwxr-xr-x
report_marks_deviation_report....	5.38 KB	-rwxr-xr-x
report_marks_elementwise.php	4.35 KB	-rwxr-xr-x
report_marks_elementwisenew.ph...	4.67 KB	-rwxr-xr-x
report_marks_entry_student_lis...	5.6 KB	-rwxr-xr-x
report_marks_entry_subjectwise...	10.99 KB	-rwxr-xr-x
report_marks_entry_subwise_lis...	13.42 KB	-rwxr-xr-x
report_marks_pending.php	12.02 KB	-rwxr-xr-x
report_online_eam.php	11.63 KB	-rwxr-xr-x
report_pr_pending.php	7.48 KB	-rwxr-xr-x
report_practical_marks_details...	13.45 KB	-rwxr-xr-x
report_practical_marks_details...	14.73 KB	-rwxr-xr-x
report_practical_misc.php	8.24 KB	-rwxr-xr-x
report_qpcount_univ.php	5.93 KB	-rwxr-xr-x
report_ra_exl_report.php	5.79 KB	-rwxr-xr-x
report_ra_invigilator_dairy.ph...	15.33 KB	-rwxr-xr-x
report_ra_invigilators_dairy.p...	14.9 KB	-rwxr-xr-x
report_ra_qp_wise_student_coun...	7.66 KB	-rwxr-xr-x
report_ra_roomwise_register_no...	10.44 KB	-rwxr-xr-x
report_ra_roomwise_register_no...	7.57 KB	-rwxr-xr-x
report_revaluation.php	6.42 KB	-rwxr-xr-x
report_sectionwiselist.php	4.61 KB	-rwxr-xr-x
report_subject_admcl_list.php	3.48 KB	-rwxr-xr-x
report_subject_general_list.ph...	4.13 KB	-rwxr-xr-x
resport_attendance_studentwise...	5.96 KB	-rwxr-xr-x
results_pdf.php	19.35 KB	-rwxr-xr-x
revaluation.php	15.65 KB	-rwxr-xr-x
roomallotmantecelsheet.php	5.41 KB	-rwxr-xr-x
roomallotmantsummary.php	4.69 KB	-rwxr-xr-x
roomwise_register_nos_list.php	17.11 KB	-rwxr-xr-x
rotation.php	596 B	-rwxr-xr-x
stringspliter.php	693 B	-rwxr-xr-x
student.php	5.36 KB	-rwxr-xr-x
student_count.php	4.05 KB	-rwxr-xr-x
subject_wise_student_list.php	6.22 KB	-rwxr-xr-x
subjectwise_invigilator_dairy....	10.29 KB	-rwxr-xr-x
tatkal.php	4.8 KB	-rwxr-xr-x
teacher_report.php	10.8 KB	-rwxr-xr-x
testbarcode.php	19.88 KB	-rwxr-xr-x
topsheet.php	8.41 KB	-rwxr-xr-x

Code Editor : report_bulk_applications.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);
		// var_dump($this->aobj_context);
		$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', '140', '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'];
		$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='{$this->collcode}'";
		$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];

$query = "select d.fdescpn as degree from studadm s inner join degree d on s.fdegree = d.fdegree and d.fexamno = 'a'";
		$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)
	{

$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: #afaaa9; 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);
		
		$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">'.$per_details['FAPPNO'].'</td>
				<td width="100" rowspan="5"><img width="100" height="100" src="'.$this->aobj_context->main_src.$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">Place of Birth:</td>
				<td width="270" colspan="2">'.$per_details['FPOB'].'</td></tr>';

$table1 .='<tr nobr="true">
				<td width="150" class="lable">Date of Birth:</td>
				<td width="135">'.$per_details['fdob'].'</td>
				<td width="135" class="lable">Gender:</td>
				<td width="100">'.$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="135" class="lable">Religion:</td>
				<td width="100">'.$per_details['freligion'].'</td>
				</tr>';

$table1 .='<tr nobr="true">
				<td width="150" class="lable">Category:</td>
				<td width="135">'.$per_details['FCATBIRTH'].'</td>
				<td width="135" class="lable">Caste:</td>
				<td width="100" >'.$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">Area</td>
				<td width="135">'.$per_details['FAREA'].'</td>
				<td width="135" class="lable">Annual family Income:</td>
				<td width="100">'.$per_details['FFATINCOME'].'</td>
				</tr>';

$table1 .= '</table>';

$pdf->SetX(11);
		$pdf->writeHTML($table1, true, true, false, false, 'L');

$html = '<h3 style="background-color: #afaaa9; 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['fmobileno'].'</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="370">'.$per_details['FCONTACT_NO'].'</td>
		</tr>';
		
		$table2 .= '</table>';
		$pdf->SetX(11);
		$pdf->writeHTML($table2, true, true, false, false, 'L');

//====================Admission Quota====================================
		/*$table3 = '<style>
			td {
			    border: 0.5px solid black;
			}
			th {
			    border: 0.5px solid black;
			}
			.lable {
				font-weight: bold;
			}
		 </style>
		<table cellpadding="3" cellspacing="0">
			<tr nobr="true">
				<th width="520" colspan="2" class="lable">Are you claiming admission under any of the following quota?</th>
		</tr>';

$table3 .= '<tr nobr="true">
				<td width="150" class="lable">Diffrently-abled</td>
				<td width="370">'.$per_details['FHANDICAP'].'</td>
		</tr>';

$table3 .= '<tr nobr="true">
				<td width="150" class="lable">NCC / Scouts & Guides</td>
				<td width="370">'.$per_details['FNCC'].'</td>
		</tr>';

$table3 .= '<tr nobr="true">
				<td width="150" class="lable">NSS</td>
				<td width="370">'.$per_details['FNSS'].'</td>
		</tr>';

$table3 .= '<tr nobr="true">
				<td width="150" class="lable">Sports</td>
				<td width="370">'.$per_details['FSPORTS'].'</td>
		</tr>';

$table3 .= '<tr nobr="true">
				<td width="150" class="lable">Defense Personnel</td>
				<td width="370">'.$per_details['FDEFENCE'].'</td>
		</tr>';

$table3 .= '<tr nobr="true">
				<td width="150" class="lable">Ex-Serviceman</td>
				<td width="370">'.$per_details['FEXSERVE'].'</td>
		</tr>';

$table3 .= '<tr nobr="true">
				<td width="150" class="lable">Kashmirie Immigrants</td>
				<td width="370">'.$per_details['FKASHIMG'].'</td>
		</tr>';

$table3 .= '<tr nobr="true">
				<td width="150" class="lable">Transgender</td>
				<td width="370">'.$per_details['FTRANS'].'</td>
		</tr>';

$table3 .= '<tr nobr="true">
				<td width="150" class="lable">Other boards within state</td>
				<td width="370">'.$per_details['FWOBSATE'].'</td>
		</tr>';

$table3 .= '<tr nobr="true">
				<td width="150" class="lable">Other state board student</td>
				<td width="370">'.$per_details['FOBSATE'].'</td>
		</tr>';

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

$html = '<h3 style="background-color: #afaaa9; 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);

$table4 = '<style>
			td {
			    border: 0.5px solid black;
			}
		 </style><table cellpadding="3" cellspacing="0">
		  <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 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, true, 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->writeHTML($table5, true, false, true, false, 'L');

//====================Degree Details====================================
		$pdf->AddPage("P");
		$html = '<h3 style="background-color: #afaaa9; 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="3" 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');
		
		//=============================Details of Qualifying Examination===========
		//$pdf->AddPage("P");
		
		$html = '<h3 style="background-color: #afaaa9; color: rgb(255, 255, 255);">PAYMENT DETAILS</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="4" cellspacing="0">
		<tr nobr="true">
			<th width="100" align="center"><b>Amount Paid</b></th>
			<th width="100" align="center"><b>Date</b></th>
			<th width="100" align="center"><b>Fine Amount</b></th>
			<th width="80" align="center"><b>Total</b></th>
		</tr>
		<tr nobr="true">
			<td width="100"></td>
			<td width="100"></td>
			<td width="100"></td>
			<td width="80"></td>
		</tr>';//Percentage

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

/*	$html = '<h3>FOR OFFICE USE ONLY</h3>';
		$pdf->ln(4);
		$x = $pdf->GetX();
		$y = $pdf->GetY();
		$pdf->writeHTMLCell(188,0,$x,$y,$html, false,1, false, true, 'C', false);
		$pdf->ln(4);*/

$pdf->SetFont('Times','B',10);
		$pdf->Cell(160,4,'Thumb Impression of the Student',0,0,'L');
		$pdf->Cell(30,4,'Signature of the Student ',0,1,'R');
		$pdf->ln(10);		
		$pdf->SetFont('Times','BU',10);
		$pdf->Cell(180,4,'Note:',0,1,'L');
		$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(10);
		$pdf->Cell(160,4,'Date:',0,0,'L');
		$pdf->Cell(30,4,'Signature of the Principal with Seal',0,1,'R');
		$pdf->ln(2);

$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">'.$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(13);
		$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);

$degree_code = trim($aobj_context->mobj_data["degree_code"]);
	$appfrom = trim($aobj_context->mobj_data["appfrom"]);
	$appto = trim($aobj_context->mobj_data["appto"]);

$per_details_query = "select sa.FNAME,sa.FAPPNO, sa.FFATNAME,sa.FCOLLCODE, 
	ifnull(sa.fregno,'') as fregno,sa.FMOTNAME, sa.FFAT_OCC, 
	ifnull(sa.FSEX,fgender) as FSEX, ifnull(sa.FPOB,'') as FPOB,  
	ifnull(sa.fblood_group,'') as fblood_group, ifnull(sa.freligion,'') as freligion,
	ifnull(FCATBIRTH,'') as FCATBIRTH, ifnull(sa.FCASTE,'') as FCASTE,
	if(ifnull(sa.fhk,'')='' or sa.fhk = 'No', 'No', 'Yes') as fhk,
	sa.FNATIONAL,'Post Offices' as FPAYMENTTYPE, sa.FFEEPAID as FTOTFEE, 
	sa.fphotopath, 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.FCURRADD4,''), ' ') as fcuradd, 
	concat(ifnull(sa.FPERMADD1,''),' ', 
	ifnull(sa.FPERMADD2,''), ' ', ifnull(sa.FPERMADD3,''),' ', 
	ifnull(sa.FPERMADD4,''),' ') 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(FFATINCOME,'') as FFATINCOME,
	sa.FPERCENT, sa.FAADHARNO, ifnull(sa.TOTAL_FEE,'') as FUNIVFEE, 
	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.FSTATEQUALEXM,'') as FSTATEQUALEXM, ifnull(sa.FUNIVADD,'') as FUNIVADD,
	ifnull(sa.FUNIVPHONE,'') as FUNIVPHONE,
	ifnull(sa.FINSTNAME,'') as FINSTNAME, ifnull(sa.FINSTLOCAT,'') as FINSTLOCAT,
	ifnull(sa.FCOLLADD,'') as FCOLLADD, ifnull(sa.FCOLLPHONE,'') as FCOLLPHONE,
	ifnull(sa.FCOLLSTATE,'') as FCOLLSTATE, ifnull(sa.FPRNNO,'') as FPRNNO,
	ifnull(sa.FQUALEXREGNO,'') as FQUALEXREGNO, ifnull(sa.FPASSMNTH,'') as FPASSMNTH,
	ifnull(sa.FPASSYER,'') as FPASSYER, ifnull(sa.FMARKSECURED,'') as FMARKSECURED,
	ifnull(sa.FMARKTOTAL,'') as FMARKTOTAL, ifnull(sa.FPERMARK,'') as FPERMARK,
	ifnull(sa.FAREA,'') as FAREA,ifnull(sa.FHANDICAP,'') as FHANDICAP, 
	ifnull(sa.FNCC,'') as FNCC, ifnull(sa.FNSS,'') as FNSS, 
	ifnull(sa.FDEFENCE,'') as FDEFENCE, ifnull(sa.FEXSERVE,'') as FEXSERVE, 
	ifnull(sa.FTRANS,'') as FTRANS, ifnull(sa.FKASHIMG,'') as FKASHIMG,
	ifnull(sa.FOBSATE,'') as FOBSATE,ifnull(sa.FWOBSATE,'') as FWOBSATE,
	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.FPRNNO,'') as FPRNNO,
	ifnull(sa.FSPORTS,'') as FSPORTS
	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 between '{$appfrom}' and '{$appto}' 
	and sa.fdegree = '{$degree_code}'
	and sa.fcollcode = '{$_SESSION['collcode']}'";//FINSTLOCAT
	//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'];
		$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);
	
		$class_obj->writeApplication($value, $subjects);
	}
	
	$class_obj->SendOutput();
}

${this.title}

Code Editor : report_bulk_applications.php