Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
output	[ DIR ]	drwxr-sr-x
DownloadExamAppFormApplication...	8.96 KB	-rwxr-xr-x
DownloadRvRtAckApplications.ph...	5.48 KB	-rwxr-xr-x
ExcelWriterXML.php	16.8 KB	-rwxr-xr-x
ExcelWriterXML_Sheet.php	16.26 KB	-rwxr-xr-x
ExcelWriterXML_Style.php	24.5 KB	-rwxr-xr-x
PrintApplicationFormAdmPOSTOFF...	13.15 KB	-rwxr-xr-x
PrintChallanEntryDetails.php	8.63 KB	-rwxr-xr-x
RVApplicationsReport.php	8.42 KB	-rwxr-xr-x
RvRtApplicationReport.php	9.11 KB	-rwxr-xr-x
ack_application.php	4.96 KB	-rwxr-xr-x
ack_exam_app_form_bulk.php	12 KB	-rwxr-xr-x
ack_rv_rt_report.php	10.35 KB	-rwxr-xr-x
admChallanEntryDetails.php	7.26 KB	-rwxr-xr-x
adm_comb_details.php	6.41 KB	-rwxr-xr-x
admregisterlist.php	15.35 KB	-rwxr-xr-x
admreportlist.php	15.35 KB	-rwxr-xr-x
answer_book_statistics.php	7.08 KB	-rwxr-xr-x
appear_list_center_qp_wise.php	7.53 KB	-rwxr-xr-x
appear_list_qp_wise.php	5.82 KB	-rwxr-xr-x
appfeedetails.php	9 KB	-rwxr-xr-x
appfeedetails_pdf.php	7.78 KB	-rwxr-xr-x
appfeedetailspdf.php	7.89 KB	-rwxr-xr-x
approval_report.php	18.34 KB	-rwxr-xr-x
approval_report_wait.php	11.88 KB	-rwxr-xr-x
basic_data_coll.php	7 KB	-rwxr-xr-x
basic_data_sum.php	7.2 KB	-rwxr-xr-x
batch_wise_details.php	4.63 KB	-rwxr-xr-x
bundle_ despatch_ statement.ph...	5.92 KB	-rwxr-xr-x
bundle_ack.php	10.22 KB	-rwxr-xr-x
bundle_ack_wait.php	8.64 KB	-rwxr-xr-x
bundleno_despatch_statement.ph...	11.82 KB	-rwxr-xr-x
bundleno_dispatch_datewise.php	11.59 KB	-rwxr-xr-x
cManualMailer.php	1.5 KB	-rwxr-xr-x
cappcontext.php	2.71 KB	-rwxr-xr-x
cconfig.php	1.18 KB	-rwxr-xr-x
cntDeclaration.php	14.2 KB	-rwxr-xr-x
cntrtagcollstud.php	4.95 KB	-rwxr-xr-x
code39.php	6.56 KB	-rwxr-xr-x
college_degree_details.php	4.74 KB	-rwxr-xr-x
college_pending_markslist.php	6.89 KB	-rwxr-xr-x
collegedet.php	4.9 KB	-rwxr-xr-x
examAppChallan.php	12.57 KB	-rwxr-xr-x
examAppChallanReport.php	8.82 KB	-rwxr-xr-x
exam_attendance_det.php	7.94 KB	-rwxr-xr-x
exam_attendance_summary.php	9.44 KB	-rwxr-xr-x
fee_report_catwise.php	13.49 KB	-rwxr-xr-x
fee_summary.php	13.54 KB	-rwxr-xr-x
fee_summary_oldformat.php	7.67 KB	-rwxr-xr-x
fee_summary_report.php	35.26 KB	-rwxr-xr-x
generatePostAdmissionTicket.ph...	28.14 KB	-rwxr-xr-x
getnumword.php	7.79 KB	-rwxr-xr-x
hallticketcomm.php	30.32 KB	-rwxr-xr-x
htcollsum.php	6.49 KB	-rwxr-xr-x
htstatus.php	7.03 KB	-rwxr-xr-x
htsum.php	3.71 KB	-rwxr-xr-x
iaemptyformat.php	7.46 KB	-rwxr-xr-x
index.php	4.64 KB	-rwxr-xr-x
marls_subjectwise.php	10.49 KB	-rwxr-xr-x
photo_report.php	4.9 KB	-rwxr-xr-x
photo_report_old.php	4.63 KB	-rwxr-xr-x
practical_marks_details.php	12.43 KB	-rwxr-xr-x
practical_marks_report.php	5.74 KB	-rwxr-xr-x
qp_issue.php	8.01 KB	-rwxr-xr-x
qpindent.php	5.19 KB	-rwxr-xr-x
re_cronjob_sendsms_dud.php	4.96 KB	-rwxr-xr-x
reconciliation.php	9.67 KB	-rwxr-xr-x
reg_stud_list.php	8.63 KB	-rwxr-xr-x
report_ack_registration.php	6.63 KB	-rwxr-xr-x
report_adm_combination.php	10.51 KB	-rwxr-xr-x
report_adm_summary.php	8.74 KB	-rwxr-xr-x
report_admission_details.php	27.47 KB	-rwxr-xr-x
report_admission_list.php	17.53 KB	-rwxr-xr-x
report_admission_list_wop.php	10.58 KB	-rwxr-xr-x
report_admission_listnehu.php	25.35 KB	-rwxr-xr-x
report_admission_ticket.php	28.37 KB	-rwxr-xr-x
report_answer_book_issued.php	8.62 KB	-rwxr-xr-x
report_attendance_sheet.php	13.11 KB	-rwxr-xr-x
report_attendance_shortage.php	9.52 KB	-rwxr-xr-x
report_attendance_summary.php	7.42 KB	-rwxr-xr-x
report_bacth_preparation_dairy...	7.34 KB	-rwxr-xr-x
report_batch_practical_dairy.p...	15.78 KB	-rwxr-xr-x
report_batch_wise_details.php	8.18 KB	-rwxr-xr-x
report_batch_worksheet_details...	11.52 KB	-rwxr-xr-x
report_bulk_applications.php	26.25 KB	-rwxr-xr-x
report_bundle_dispatch.php	11.92 KB	-rwxr-xr-x
report_candidate_list.php	29.82 KB	-rwxr-xr-x
report_candidate_list_backup.p...	30.35 KB	-rwxr-xr-x
report_daliy_report.php	11.14 KB	-rwxr-xr-x
report_daliy_report_qp.php	10.67 KB	-rwxr-xr-x
report_data_sent.php	8.71 KB	-rwxr-xr-x
report_degree_list.php	4.88 KB	-rwxr-xr-x
report_deviation_report.php	7.96 KB	-rwxr-xr-x
report_evaluation_report.php	9.6 KB	-rwxr-xr-x
report_iamarks_pending.php	8.4 KB	-rwxr-xr-x
report_marks_deviation_report....	5.58 KB	-rwxr-xr-x
report_marks_elementwise.php	4.46 KB	-rwxr-xr-x
report_marks_elementwisenew.ph...	4.8 KB	-rwxr-xr-x
report_marks_entry_student_lis...	5.72 KB	-rwxr-xr-x
report_marks_entry_subwise_lis...	18.76 KB	-rwxr-xr-x
report_marks_pending.php	12.33 KB	-rwxr-xr-x
report_online_eam.php	11.99 KB	-rwxr-xr-x
report_pr_pending.php	7.65 KB	-rwxr-xr-x
report_practical_marks_details...	13.83 KB	-rwxr-xr-x
report_practical_marks_details...	14.51 KB	-rwxr-xr-x
report_practical_misc.php	8.61 KB	-rwxr-xr-x
report_qpcount_univ.php	6.08 KB	-rwxr-xr-x
report_ra_exl_report.php	5.77 KB	-rwxr-xr-x
report_ra_invigilator_dairy.ph...	22.52 KB	-rwxr-xr-x
report_ra_invigilators_dairy.p...	15.55 KB	-rwxr-xr-x
report_ra_qp_wise_student_coun...	8.62 KB	-rwxr-xr-x
report_ra_roomwise_register_no...	10.91 KB	-rwxr-xr-x
report_revaluation.php	6.58 KB	-rwxr-xr-x
report_sectionwiselist.php	4.73 KB	-rwxr-xr-x
report_subject_admcl_list.php	3.57 KB	-rwxr-xr-x
report_subject_general_list.ph...	4.76 KB	-rwxr-xr-x
reportexamcntrdet.php	5.46 KB	-rwxr-xr-x
resport_attendance_studentwise...	6.14 KB	-rwxr-xr-x
results_pdf.php	19.91 KB	-rwxr-xr-x
resultsheet.php	9.39 KB	-rwxr-xr-x
revaluation.php	15.97 KB	-rwxr-xr-x
roomallotmantecelsheet.php	5.58 KB	-rwxr-xr-x
roomallotmantsummary.php	4.81 KB	-rwxr-xr-x
roomwise_register_nos_list.php	19.13 KB	-rwxr-xr-x
rotation.php	634 B	-rwxr-xr-x
shortageReport.php	11.85 KB	-rwxr-xr-x
stringspliter.php	731 B	-rwxr-xr-x
student.php	5.48 KB	-rwxr-xr-x
student_count.php	4.16 KB	-rwxr-xr-x
subiapending.php	8.14 KB	-rwxr-xr-x
subject_wise_student_list.php	6.38 KB	-rwxr-xr-x
subjectwise_invigilator_dairy....	10.71 KB	-rwxr-xr-x
tatkal.php	4.93 KB	-rwxr-xr-x
teacher_report.php	10.19 KB	-rwxr-xr-x
teacher_val_report.php	10.31 KB	-rwxr-xr-x
teacherreport.php	6.2 KB	-rwxr-xr-x
testbarcode.php	20.58 KB	-rwxr-xr-x
topsheet.php	8.62 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."/".$this->aobj_context->mobj_data["db"]."/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.FSTUTYPE as FCOMSTATE, DATE_FORMAT(fadmdate,'%d/%m/%Y') AS fdoa,
	ifnull(s.ftotfee,0) as ftotfee,s.FQUOTA,
	s.fcaste,s.FTYPEQUALEXAM, CONCAT(FQSECMARKS,'/',FQMAXMARKS)  AS fmarks, 
	GROUP_CONCAT(DISTINCT ifnull(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')
	left  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