Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
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
HT_017_BA160105.pdf	40.2 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
adm_comb_details.php	6.18 KB	-rwxr-xr-x
admreportlist.php	14.87 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
appfeedetails25022017.php	6.46 KB	-rwxr-xr-x
appfeedetails_pdf.php	7.48 KB	-rwxr-xr-x
appfeedetailspdf.php	7.58 KB	-rwxr-xr-x
applicationFormReportSBM.php	22.06 KB	-rwxr-xr-x
basic_data_coll.php	6.74 KB	-rwxr-xr-x
basic_data_sum.php	6.96 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
cntDeclaration.php	13.81 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...	44.75 KB	-rwxr-xr-x
getnumword.php	8.74 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.95 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
reg_stud_list.php	8.34 KB	-rwxr-xr-x
report_ack_registration.php	6.4 KB	-rwxr-xr-x
report_adm_combination.php	10.15 KB	-rwxr-xr-x
report_adm_summary.php	8.45 KB	-rwxr-xr-x
report_admission_details.php	26.8 KB	-rwxr-xr-x
report_admission_list.php	17.32 KB	-rwxr-xr-x
report_admission_list_wop.php	10.31 KB	-rwxr-xr-x
report_admission_listnehu.php	24.67 KB	-rwxr-xr-x
report_admission_ticket.php	42.54 KB	-rwxr-xr-x
report_admission_ticket0802201...	36.96 KB	-rwxr-xr-x
report_admission_ticket0811201...	47.36 KB	-rwxr-xr-x
report_admission_ticket1111201...	40.47 KB	-rwxr-xr-x
report_admission_ticket1711201...	42.51 KB	-rwxr-xr-x
report_admission_ticket_201804...	27.76 KB	-rwxr-xr-x
report_admission_ticket_291120...	43.27 KB	-rwxr-xr-x
report_admission_ticket_311020...	41.69 KB	-rwxr-xr-x
report_admission_ticket_before...	13.33 KB	-rwxr-xr-x
report_admission_ticket_kus (2...	36.42 KB	-rwxr-xr-x
report_admission_ticket_kus.ph...	16.15 KB	-rwxr-xr-x
report_admission_ticket_new.ph...	36.09 KB	-rwxr-xr-x
report_admission_ticket_nitte....	26.22 KB	-rwxr-xr-x
report_admission_ticketcopy.ph...	32.41 KB	-rwxr-xr-x
report_admission_ticketkswu.ph...	15.07 KB	-rwxr-xr-x
report_admission_ticketold.php	30.03 KB	-rwxr-xr-x
report_admission_ticketold0911...	34.52 KB	-rwxr-xr-x
report_admission_ticketoldform...	30.91 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_shortage_271...	8.99 KB	-rwxr-xr-x
report_attendance_summary.php	9.06 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	19.42 KB	-rwxr-xr-x
report_bundle_dispatch.php	8.65 KB	-rwxr-xr-x
report_bundle_dispatch_kusdde....	9.73 KB	-rwxr-xr-x
report_candidate_list.php	29.08 KB	-rwxr-xr-x
report_candidate_list28102017....	29.46 KB	-rwxr-xr-x
report_candidate_list_backup.p...	29.47 KB	-rwxr-xr-x
report_candidate_list_before_f...	25.19 KB	-rwxr-xr-x
report_candidate_list_before_s...	19.8 KB	-rwxr-xr-x
report_candidate_list_loc.php	25.06 KB	-rwxr-xr-x
report_candidate_list_old.php	25.9 KB	-rwxr-xr-x
report_daliy_report.php	10.88 KB	-rwxr-xr-x
report_daliy_report_qp - Copy....	14.31 KB	-rwxr-xr-x
report_daliy_report_qp.php	14.73 KB	-rwxr-xr-x
report_daliy_report_qp_2504201...	12.17 KB	-rwxr-xr-x
report_daliy_report_qp_new.php	9.93 KB	-rwxr-xr-x
report_daliy_report_qp_old_for...	10.13 KB	-rwxr-xr-x
report_daliy_report_qp_wait.ph...	9.9 KB	-rwxr-xr-x
report_data_sent.php	8.41 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_hall_ticket.php	10.6 KB	-rwxr-xr-x
report_iamarks_pending.php	8.19 KB	-rwxr-xr-x
report_iamarks_pending_2112201...	6.58 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_entry_subwise_lis...	10.13 KB	-rwxr-xr-x
report_marks_entry_subwise_lis...	9.16 KB	-rwxr-xr-x
report_marks_entry_subwise_lis...	10.05 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_invigilators_dairy24...	8.83 KB	-rwxr-xr-x
report_ra_invigilators_dairy28...	11.95 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
reportexamcntrdet.php	5.24 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
s	32.36 KB	-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.83 KB	-rwxr-xr-x
testbarcode.php	19.88 KB	-rwxr-xr-x
topsheet.php	8.41 KB	-rwxr-xr-x
upload.js	29.46 KB	-rwxr-xr-x

Code Editor : admreportlist.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;
    protected $last_page_flag = false;
    public function setData($aobj_context){
    	$this->aobj_context = $aobj_context;
    }

public function Close() {
	    $this->last_page_flag = true;
	    parent::Close();
  	}
    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(5,62,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,6,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");
		$nextyear = ($cur_year+1)-2000;
		
		$this->Cell(0,5,'Combination Wise Statement for the Academic Year ('.$cur_year.'-'.$nextyear.')','0',1,'C');
		$this->Cell(0,5,"Degree : {$this->aobj_context->degree}",'0',1,'C');

$this->Ln(1);
		$this->Cell(0,5,"Combination : {$this->aobj_context->combcode}",'0',1,'C');

if($this->aobj_context->laspage != "lastpage")
		{
				$qurey = "select count(*)  as fcombcnt from studadm where 
				fcollcode = '{$this->aobj_context->fcollcode}' and 
				fdegree = '{$this->aobj_context->fdegree}' 
				and fcombcode = '{$this->aobj_context->fcombcode}'
				and IFNULL(FAPPSTATUS,'') = 'verified' and IFNULL(ffinsub,'') = 'T'";

$combcnt = $this->aobj_context->mobj_db->GetRow($qurey);

$this->Cell(250,5,"Sanctioned Intake : ",'0',0,'L');
				$this->Cell(30,5,"No. of Admission Made : ".$combcnt['fcombcnt'],'0',1,'R');
				$this->Ln(1);
			$table5 = '<style>
				td, th {
				    border: 0.5px solid black;
				}
			 </style>
			 <table cellpadding="2" cellspacing="0">
				';
			$table5 .= '<thead><tr nobr="true">';
			$table5 .= '<th width="25" align="center"><b>Sl. No.</b></th>';
			$table5 .= '<th width="60" align="center"><b>App. No.</b></th>';
			$table5 .= '<th width="110" align="center"><b>Name</b></th>';
			$table5 .= '<th width="25" align="center"><b>Sex</b></th>';
			$table5 .= '<th width="55" align="center"><b>DOB</b></th>';
			$table5 .= '<th width="60" align="center"><b>Stud. Type</b></th>';
			$table5 .= '<th width="30" align="center"><b>Cat.</b></th>';
			$table5 .= '<th width="60" align="center"><b>Qual. Exam Passed</b></th>';
			$table5 .= '<th width="50" align="center"><b>Marks Obt.</b></th>';
			$table5 .= '<th width="60" align="center"><b>Second Lan. admitted</b></th>';
			$table5 .= '<th width="55" align="center"><b>DOA</b></th>';
			$table5 .= '<th width="30" align="center"><b>Fee</b></th>';
			$table5 .= '<th width="117" align="center"><b>Documents Enclosed</b></th>';
			$table5 .= '<th width="80" align="center"><b>Remarks</b></th>';
			$table5 .= '</tr></thead></table>';
			$this->writeHTML($table5, false, false, false, false);
		}
        // restore auto-page-break status
        // var_dump($this->aobj_context->laspage);
        $this->SetAutoPageBreak($auto_page_break, $bMargin);
        // set the starting point for the page content    
    }

public function Footer() 
    {
        $this->SetY(-20);
        $this->SetFont('helvetica', 'I', 8);
        $this->Ln(1);
        if($this->aobj_context->laspage != "lastpage")
		{
	        $this->Cell(0, 6,'Note : Documents Enclosed,  ELIGCERT - Eligibility Certificate, SSLCMC - SSLC Marks Card, PUMC - PUC Marks Card.', 0, 1, 'L');
        }
        $this->Cell(100, 10,'IP : '.$_SERVER["REMOTE_ADDR"], 0, 0, 'L');
        $this->Cell(110, 10,'Date : ' .$this->aobj_context->current_date, 0, 0, 'C');

$this->Cell(70, 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->degree = $aobj_context->mobj_data["degree_code"];
		$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(fcollcode,' - ',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'];

$this->current_date = $obj['now_date'];

$get_degree_name="select concat(fdegree,'-',fdescpn) as degree from degree where fdegree='{$this->degree}' and fexamno = 'A'";
		
		$lobj_get_degree_name = $this->aobj_context->mobj_db->GetRow($get_degree_name);
		$aobj_context->degree = $lobj_get_degree_name['degree'];
		
		$this->pdf= new MYPDF('P');
		
		$this->pdf->setData($aobj_context);
	}

function writeReport($admCollData)
	{

$pdf=$this->pdf;

$oldcombcode = '';
		$newcombcode = '';
		$i = 0;
		$Total = 0;
		foreach($admCollData as $key => $value)
		{

$newcombcode = $value['fcombcode'];

if($newcombcode != $oldcombcode) 
			{
				//var_dump($i);
				
				if($i != 0)
				{	
					$table5 .='
						<tr>
							<td colspan = "10">
								<b>Total Amount</b>
							</td>
							<td colspan = "2" align = "right"><b>'.
								moneyFormatIndia($Total).'
							</b></td>
						</tr>
					</table>';
					$pdf->writeHTML($table5, false, false, false, false);
					
					/*$table5 = '<style>
					td, th {
					    border: 0.5px solid black;
					}
				 	</style>
				 	<br><br>
				 	<table cellpadding="2" cellspacing="0">
					<tr nobr="true">
						<td width = "200" >Sanctioned Intake</td>
						<td width = "100"></td>
					</tr>
					<tr nobr="true">
						<td width = "200" >No. of Admission Made</td>
						<td width = "100">'.$i.'</td>
					</tr>
					<tr nobr="true">
						<td width = "200">Total Amount</td>
						<td width = "100">'.moneyFormatIndia($Total).'</td>
					</tr>
					</table>';

if($pdf->getY()>170)
					{
						$this->aobj_context->laspage = "lastpage";
						$pdf->AddPage("L");
						$pdf->writeHTML($table5, false, false, false, false);
						$this->aobj_context->laspage = "";
					}
					else
					{
						$pdf->writeHTML($table5, false, false, false, false);
					}*/
					$i = 0;
					$Total = 0;
					//var_dump($i);
				}
				$this->aobj_context->combcode = $value['FCOMBDESC'];
				$this->aobj_context->fcombcode = $value['fcombcode'];
				$this->aobj_context->fdegree = $value['fdegree'];
				$this->aobj_context->fcollcode = $value['fcollcode'];
				//$pdf->SetMargins(12,30,20,false);
				$pdf->SetMargins(5,62,20,false);
				$pdf->startPageGroup();
				$pdf->AddPage("L");

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

$table5 = '<style>
					td, th {
					    border: 0.5px solid black;
					}
				 </style>
				 <table cellpadding="2" cellspacing="0">
					';

$oldcombcode = $newcombcode;
				
			}

$table5 .= '<tr nobr="true">';
			$table5 .= '<td width="25" align="center">'.++$i.'</td>';
			$table5 .= '<td width="60" align="center">'.$value['fappno'].'</td>';
			$table5 .= '<td width="110" align="left">'.$value['fname'].'</td>';
			$table5 .= '<td width="25" align="center">'.$value['fgender'].'</td>';
			$table5 .= '<td width="55" align="center">'.$value['fdob'].'</td>';
			$table5 .= '<td width="60" align="center">'.$value['FCOMSTATE'].'</td>';
			$table5 .= '<td width="30" align="center">'.$value['fcaste'].'</td>';
			$table5 .= '<td width="60" align="center">'.$value['FTYPEQUALEXAM'].'</td>';
			$table5 .= '<td width="50" align="center">'.$value['fmarks'].'</td>';
			$table5 .= '<td width="60" align="center">'.$value['fsubcode'].'</td>';
			$table5 .= '<td width="55" align="center">'.$value['fdoa'].'</td>';
			$table5 .= '<td width="30" align="center">'.moneyFormatIndia($value['ftotfee']).'</td>';
			$table5 .= '<td width="117" align="left">'.$value['studdoc'].'</td>';
			$table5 .= '<td width="80" align="left"></td>';
			$table5 .= '</tr>';
			$Total += intval($value['ftotfee']);

if($i % 25 == 0)
			{
				$table5 .='</table>';
				$pdf->writeHTML($table5, false, false, true, false, 'L');
				$table5 = '<style>
					td, th {
					    border: 0.5px solid black;
					}
				 </style>
				 <table cellpadding="2" cellspacing="0">';
			}
		}
		$table5 .='
					<tr>
						<td colspan = "10">
							<b>Total Amount</b>
						</td>
						<td colspan = "2" align = "right"><b>'.
							moneyFormatIndia($Total).'
						</b></td>
					</tr>
				</table>';
		$pdf->writeHTML($table5, false, false, true, false, 'L');
		/*$table5 = '<style>
					td, th {
					    border: 0.5px solid black;
					}
				 </style>
				 <br><br>
				 <table cellpadding="2" cellspacing="0">
					<tr nobr="true">
						<td width = "200" >Sanctioned Intake</td>
						<td width = "100"></td>
					</tr>
					<tr nobr="true">
						<td width = "200">No. of Admission Made</td>
						<td>'.$i.'</td>
					</tr>
					<tr nobr="true">
						<td width = "200">Total Amount</td>
						<td width = "100">'.moneyFormatIndia($Total).'</td>
					</tr>
					</table>';
		if($pdf->getY()>160)
		{
			$this->aobj_context->laspage = "lastpage";
			$pdf->AddPage("L");
			$pdf->writeHTML($table5, false, false, false, false);
			$this->aobj_context->laspage = "";
		}
		else
		{
			$pdf->writeHTML($table5, false, false, false, false);
		}*/

$pdf->SetMargins(12,62,20,false);
		// $pdf->startPageGroup();
		$this->aobj_context->laspage = "lastpage";
		$pdf->AddPage("L");

$pdf->SetFont('Times','B',10);
		$pdf->Ln(10);
		
		$pdf->MultiCell(0,'6','1. That all the original documents such as Marks Cards, Transfer Certificate, Migration Certificate, Eligibility Certificate etc., furnished by the candidate admitted during             2018 - 2019 are carefully verified  and they are in order in all respects.',0,'L');

$pdf->MultiCell(0,'6','2. That the particular furnished by me in respect of the above Candidates in the statement of admission are based on original documents produced by them and they are true         to the best of my knowledge and belief.',0,'L');

$pdf->MultiCell(0,'6','3. That all the students recommended in this admission statement for approval for 2018 - 2019 are academically eligible and have satisfied the regulations of the sources for           which they are admitted.',0,'L');	
  
		$pdf->MultiCell(0,'6','4. The students admitted to the courses are within the intake sanctioned by the Government of Karnataka/Bangalore University to the College/ Department .',0,'L');

$pdf->MultiCell(0,'6','5. That the Registration and Eligibility fees from the candidates concerned are duly collected or remitted to the University funds.',0,'L');

$pdf->MultiCell(0,'6','6. That no candidate other than the candidates mentioned in this statement of admission are admitted to any course in this college for the Academic year 2018 - 2019.',0,'L');		
		$pdf->Ln(30);
		$pdf->Cell(250,'6','Signature of the principal with Seal and Date',0,1,'R');		
		
	}
		
	function SendOutput()
	{
		ob_end_clean();
		$this->pdf->Output("Admission_Summary_{$_SESSION['collcode']}.pdf","D");
	}	 
}

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

$degree_code = $aobj_context->mobj_data["degree_code"];
	
	$admCollDataQuery = "SELECT s.fappno,s.fcollcode,s.fdegree,s.fcombcode,
	m.FCOMBDESC, trim(s.fname) as fname, s.fgender, 
	DATE_FORMAT(fdob,'%d/%m/%Y') AS fdob, s.FCOMSTATE, DATE_FORMAT(fadmdate,'%d/%m/%Y') AS fdoa,
	ifnull(s.ftotfee,0) as ftotfee,
	s.fcaste,s.FTYPEQUALEXAM, CONCAT(FQSECMARKS,'/',FQMAXMARKS)  AS fmarks, 
	GROUP_CONCAT(DISTINCT su.fsubname) AS fsubcode, 
	GROUP_CONCAT(DISTINCT if(st.fdoctype = 'GCCERT','ELIGCERT',st.fdoctype)
	,IF(IFNULL(st.file_path,'') = '',' - No',' - Yes') separator ' | ') as studdoc
	FROM studadm s 
	INNER JOIN options o ON s.fappno = o.fappno AND s.fdegree = o.fdegree 
	AND s.fcollcode = o.fcollcode
	INNER JOIN studoc st ON s.fappno = st.login_cnt AND s.fdegree = st.fdegree 
	AND s.fcollcode = st.fcollcode and st.fdoctype in('PUMC','SSLCMC','GCCERT')
	INNER JOIN subject su ON s.fdegree = su.fdegree AND o.fexamno = su.fexamno 
	AND o.fsubcode = su.fsubcode AND
	IFNULL(su.fintass,'') <> 'T' AND su.fsubcode BETWEEN 'A002' AND 'A015'
	INNER JOIN mascomb m ON s.fdegree = m.fdegree AND m.fcombcode = s.fcombcode
	WHERE IFNULL(s.FAPPSTATUS,'') = 'verified' AND 
	s.fcollcode = '{$_SESSION['collcode']}' AND s.fdegree = '{$degree_code}'
	and ifnull(s.fdeleted,'') <> 'T' and IFNULL(s.ffinsub,'') = 'T'
	GROUP BY s.fappno 
	ORDER BY s.fdegree,s.fcombcode,s.fname,s.fappno";
	//var_dump($admCollDataQuery);
	$admCollData = $aobj_context->mobj_db->GetAll($admCollDataQuery);

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

$class_obj->writeReport($admCollData);

$class_obj->SendOutput();
}

${this.title}

Code Editor : admreportlist.php