Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
system	[ DIR ]	drwxr-xr-x
Dispatch_ans_script_setup.php	5.84 KB	-rwxr-xr-x
Dispatch_ans_script_setup_qp.p...	5.18 KB	-rwxr-xr-x
FormulaEvaluate.php	14.15 KB	-rwxr-xr-x
MarkEntry-Setup.php	20.82 KB	-rwxr-xr-x
MarkEntry-SetupTEST.php	21.01 KB	-rwxr-xr-x
MarkEntry-Setup_28102014.php	22.99 KB	-rwxr-xr-x
TAGMAY2013.pdf	331.03 KB	-rwxr-xr-x
TarkaFormatStyles.php	15.37 KB	-rwxr-xr-x
TarkaFormatStyles_old.php	3.71 KB	-rwxr-xr-x
absent_entry_setup.php	8.13 KB	-rwxr-xr-x
absent_entry_setupQp.php	7.3 KB	-rwxr-xr-x
absent_entry_setup_old.php	7.61 KB	-rwxr-xr-x
ack_exam_app_form.php	12.09 KB	-rwxr-xr-x
ack_exam_app_form_07032014.php	9 KB	-rwxr-xr-x
ack_exam_app_form_14032014.php	9.6 KB	-rwxr-xr-x
ack_rv_rt_application.php	7.57 KB	-rwxr-xr-x
ack_rv_rt_application_5days.ph...	7.41 KB	-rwxr-xr-x
ack_rv_rt_application_before_l...	6.02 KB	-rwxr-xr-x
actClass.php	6.21 KB	-rwxr-xr-x
admission_entry_status.php	2.73 KB	-rwxr-xr-x
attendance.php	6.07 KB	-rwxr-xr-x
auto-complete.php	4.89 KB	-rwxr-xr-x
backup_restore.php	8.14 KB	-rwxr-xr-x
backupandrestore.php	10.18 KB	-rwxr-xr-x
bundle_dispatch.php	2.84 KB	-rwxr-xr-x
cManualMailer.php	2.54 KB	-rwxr-xr-x
caccesscontext.php	1.24 KB	-rwxr-xr-x
candidate-entry-new.php	53.14 KB	-rw-rw-r--
candidate-entry.php	53.85 KB	-rwxr-xr-x
candidate-entry1.php	37 KB	-rwxr-xr-x
candidate-entry24082012.php	33.21 KB	-rwxr-xr-x
candidate-entry_02122017.php	42.72 KB	-rwxr-xr-x
candidate-entry_220413.php	33.21 KB	-rwxr-xr-x
candidate-entry_bf_aws.php	50.79 KB	-rwxr-xr-x
candidate-entry_new.php	43 KB	-rwxr-xr-x
candidate-entry_old_01122019.p...	43.31 KB	-rwxr-xr-x
candidate-entry_without_iapr_i...	34.88 KB	-rwxr-xr-x
candidate-entrybefore yearexam...	34.55 KB	-rwxr-xr-x
candidate-entrykus.php	33.23 KB	-rwxr-xr-x
candidate-entryold.php	34.55 KB	-rwxr-xr-x
cappcontext.php	3.19 KB	-rwxr-xr-x
challan_entries.php	13.34 KB	-rwxr-xr-x
challan_preparation.php	10.28 KB	-rwxr-xr-x
cmailer.php	6.83 KB	-rwxr-xr-x
college.php	4.61 KB	-rwxr-xr-x
college_BEFORE_LOGINPOPUP.php	3.5 KB	-rwxr-xr-x
college_degree_status.php	5.86 KB	-rwxr-xr-x
coutput.php	1.75 KB	-rwxr-xr-x
create_all_grid_files.php	8.57 KB	-rwxr-xr-x
create_all_grid_group_files.ph...	9.94 KB	-rwxr-xr-x
create_all_grid_group_files_ol...	9.61 KB	-rwxr-xr-x
create_all_popup_files.php	5.93 KB	-rwxr-xr-x
create_all_schema_files.php	4.31 KB	-rwxr-xr-x
create_all_views.php	16.52 KB	-rwxr-xr-x
create_html_files.php	52.03 KB	-rwxr-xr-x
create_html_files_without_tab....	44.49 KB	-rwxr-xr-x
create_module_meta_columns.php	5.16 KB	-rwxr-xr-x
crequestbroker.php	2.49 KB	-rwxr-xr-x
csessions.php	514 B	-rwxr-xr-x
cuser.php	3.41 KB	-rwxr-xr-x
custom_mregistry.php	122 B	-rwxr-xr-x
datadictionary.php	3.96 KB	-rwxr-xr-x
daterange.php	4.86 KB	-rwxr-xr-x
degree.php	6.51 KB	-rwxr-xr-x
degree1.php	6.78 KB	-rwxr-xr-x
display_details_in_grid.php	104.96 KB	-rwxr-xr-x
display_details_in_grid22.php	103.04 KB	-rwxr-xr-x
display_details_in_grid_240320...	98.86 KB	-rwxr-xr-x
display_details_in_grid_before...	98.71 KB	-rwxr-xr-x
display_details_in_grid_custom...	2.68 KB	-rwxr-xr-x
display_details_in_grid_studta...	96.56 KB	-rwxr-xr-x
display_details_in_grid_withde...	97.45 KB	-rwxr-xr-x
download_misc_files.php	3.3 KB	-rwxr-xr-x
download_misc_files_19062014.p...	3.25 KB	-rwxr-xr-x
download_photo.php	6.98 KB	-rwxr-xr-x
download_photo_befor_newzip_fo...	6.97 KB	-rwxr-xr-x
download_photo_old.php	3.51 KB	-rwxr-xr-x
download_upload.php	3.86 KB	-rwxr-xr-x
dynamicmastersdetails.php	117.45 KB	-rwxr-xr-x
dynamicmastersdetails_23.php	120 KB	-rwxr-xr-x
dynamicmastersdetails_one.php	119.36 KB	-rwxr-xr-x
entryexitevents.php	3.09 KB	-rwxr-xr-x
error_log.php	749 B	-rwxrwxrwx
execute_query.php	2.5 KB	-rwxr-xr-x
execute_query27062012.php	2.51 KB	-rwxr-xr-x
export_import_setup.php	7.62 KB	-rwxr-xr-x
export_import_utility.php	2.67 KB	-rwxr-xr-x
format.php	7.43 KB	-rwxr-xr-x
freeze_Ad_Cl_Me.php	6.64 KB	-rwxr-xr-x
freeze_module_at_admin_college...	7.24 KB	-rwxr-xr-x
freeze_module_at_admin_college...	7.24 KB	-rwxr-xr-x
freeze_module_at_university_co...	7.45 KB	-rwxr-xr-x
general_report_format.php	11 KB	-rwxr-xr-x
getAutoCompleteFromFrameWork.p...	2.97 KB	-rwxr-xr-x
getdata.php	33.59 KB	-rwxr-xr-x
getdata110911.php	16.03 KB	-rwxr-xr-x
getdata18112016.php	32.82 KB	-rwxr-xr-x
getdata27062012.php	16.8 KB	-rwxr-xr-x
getdata_24032015.php	20.96 KB	-rwxr-xr-x
getdataold.php	23.25 KB	-rwxr-xr-x
getfeeinformation.php	6.14 KB	-rwxr-xr-x
getmoduledetails.php	23.7 KB	-rwxr-xr-x
getnumword.php	7.42 KB	-rwxr-xr-x
getreportdetails.php	3.21 KB	-rwxr-xr-x
getreportfilefordisplay.php	1.37 KB	-rwxr-xr-x
getsearchcondition.php	1.3 KB	-rwxr-xr-x
ggridmodel.php	9.27 KB	-rwxr-xr-x
golden_palm_payslip.php	12.48 KB	-rwxr-xr-x
helptext.php	5.38 KB	-rwxr-xr-x
identify_transactions.php	6.4 KB	-rwxr-xr-x
import_marks.php	4.11 KB	-rwxr-xr-x
json.php	33.22 KB	-rwxr-xr-x
login.php	12.28 KB	-rwxr-xr-x
login.php_1	3.25 KB	-rwxr-xr-x
login11052016.php	4.48 KB	-rwxr-xr-x
login27062012.php	2.85 KB	-rwxr-xr-x
login_03032015.php	3.6 KB	-rwxr-xr-x
login_BEFORE_LOGINPOPUP.php	3.25 KB	-rwxr-xr-x
login_old.php	3.15 KB	-rwxr-xr-x
markEntry-Setup2.php	21.93 KB	-rwxr-xr-x
message_board.php	4.67 KB	-rwxr-xr-x
module_setup.php	2.48 KB	-rwxr-xr-x
mregistry.php	72.49 KB	-rwxr-xr-x
mregistry22.php	66.7 KB	-rwxr-xr-x
mregistry24042015.php	55.01 KB	-rwxr-xr-x
mregistry_13012017.php	63.53 KB	-rwxr-xr-x
mregistry_before_subupdtostud_...	52.68 KB	-rwxr-xr-x
mregistry_beforedownload.php	53.04 KB	-rwxr-xr-x
mrn_approval.php	9 KB	-rwxr-xr-x
printapp_sum.php	31.82 KB	-rwxr-xr-x
receive_rv_rt_application.php	7.65 KB	-rwxr-xr-x
report_setup.php	25.12 KB	-rwxr-xr-x
report_tool.php	73.03 KB	-rwxr-xr-x
revaluation.php	16.66 KB	-rwxr-xr-x
revaluation_oldtype.php	8.45 KB	-rwxr-xr-x
revaluation_withdegree.php	16.77 KB	-rwxr-xr-x
room_allotment.php	7.21 KB	-rwxr-xr-x
rvdates.php	6.46 KB	-rwxr-xr-x
savesspdetails.php	9.8 KB	-rw-rw-r--
sendLoginPassword.php	3.09 KB	-rwxr-xr-x
serchbygrid.php	822 B	-rwxr-xr-x
student_entry.php	36.46 KB	-rwxr-xr-x
student_entry1307.php	37.71 KB	-rwxr-xr-x
student_entry27062012.php	30.47 KB	-rwxr-xr-x
student_entryold.php	30.33 KB	-rwxr-xr-x
subjectList_display.php	11.01 KB	-rwxr-xr-x
subject_freshExam.php	18.92 KB	-rwxr-xr-x
subjectfreez.html	2.8 KB	-rwxr-xr-x
subjectfreez.php	12.98 KB	-rwxr-xr-x
system_utility.php	1.84 KB	-rwxr-xr-x
systemsetup.php	75.5 KB	-rwxr-xr-x
teachers.php	10.33 KB	-rwxr-xr-x
transaction-series.php	4.86 KB	-rwxr-xr-x
updateSection.php	3.86 KB	-rwxr-xr-x
update_defined_flag.php	3.41 KB	-rwxr-xr-x
upload_studentPhoto.php	10.06 KB	-rwxr-xr-x
upload_studentPhoto02062015.ph...	11.58 KB	-rwxr-xr-x
upload_studentPhoto_before_dow...	8.02 KB	-rwxr-xr-x
uploadmoduledetails.php	39.65 KB	-rwxr-xr-x
usersetup.php	24.11 KB	-rwxr-xr-x
usersubj_identification.php	4.54 KB	-rwxr-xr-x

Code Editor : printapp_sum.php

<?php
$main_src=substr($_SERVER['SCRIPT_FILENAME'],0,strlen($_SERVER['SCRIPT_FILENAME'])-7);
$pdf_writer_class =$main_src."/tcpdf/tcpdf.php";
require_once($pdf_writer_class);
include_once("stringspliter.php");	
class certificate_print  extends TCPDF
{
		function DefaultConstructor($aobj_context)
		{
			$this->aobj_context=$aobj_context;
			$this->pdf=  new TCPDF();
			$this->pdf=$this;
			$this->from_app = trim($this->aobj_context->mobj_data["from_app"]);
			$this->to_app = trim($this->aobj_context->mobj_data["to_app"]);
			$this->subject = trim($this->aobj_context->mobj_data["subject"]);
			$this->post = trim($this->aobj_context->mobj_data["post"]);
			
			
			$this->ip=$_SERVER["REMOTE_ADDR"];
			$get_date="select now() as now_date,fuserid from postdet where fappno = '{$this->app_no}'";
			$obj=$this->aobj_context->mobj_db->GetRow($get_date);
			$this->current_date=$obj[now_date];	
			$this->fuserid=$obj[fuserid]; 
			$cource = substr($this->app_no,-3);
			$get_date="select fdescpn as dept from mascourse where fdegree = '{$cource}'";
			$result = $this->aobj_context->mobj_db->GetRow($get_date);
			$this->dept = $result['dept'];
		}
		 
		 
		function Header()
		{

}	
		function Footer()
		{
		 	
			//$this->SetY(-10);
			//$this->pdf->SetFont('Times','B',8);
			//$this->Cell(100,6,'Printed   : IP Address : '.$this->ip." Date ".$this->current_date.'','0','0','C');                                                                 Page No. ".$this->PageNo(),'0',0,'L')
		}
	 
	 function formcolldata()
	 {
		$get_coll_name="select concat(FUNIVNAME,', ',FTOWN) as 'college_name',FTOWN,
				FUNIVADD1 as 'state',FLOGOPATH as pdf_logo_path From control";
		$lobj_get_coll_name=$this->aobj_context->mobj_db->GetRow($get_coll_name);
		$this->college_name=$lobj_get_coll_name['college_name'];
		$this->s_state=$lobj_get_coll_name['state'];
		$this->FTOWN=$lobj_get_coll_name['FTOWN'];
		$this->pdf_logo_path=$lobj_get_coll_name['pdf_logo_path'];	
	 }
	 
		function GetQry()
		{
			$get_data="SELECT s.FNAME,DATE_FORMAT(s.FDATE,'%d/%m/%Y') AS FDATE,d.FDESCPN,s.FPHOTO,
						s.FAPPNO,s.FDEGREE,s.FQUALEXAM,s.FBOARDNAME,
						s.FBOARDADDRESS,s.FQAULEXAMREGNO,s.FPASSYEAR
				FROM student s inner join degree d on d.FDEGREE=s.FDEGREE WHERE s.FAPPNO='{$this->app_no}'";
				$lobj_get_data= $this->aobj_context->mobj_db->GetRow($get_data);
			// echo $get_data
			 $this->FNAME=$lobj_get_data['FNAME'];
			 $this->FDATE=$lobj_get_data['FDATE'];
			 $this->FDEGREE=$lobj_get_data['FDEGREE'];
			 $this->FQUALEXAM=$lobj_get_data['FQUALEXAM'];
			 $this->FBOARDNAME=$lobj_get_data['FBOARDNAME'];
			 $this->FBOARDADDRESS=$lobj_get_data['FBOARDADDRESS'];
			 $this->FQAULEXAMREGNO=$lobj_get_data['FQAULEXAMREGNO'];
			 $this->FPASSYEAR=$lobj_get_data['FPASSYEAR'];
			 $this->FCOURSE=$lobj_get_data['FDESCPN'];
			 $this->FPHOTO=$lobj_get_data['FPHOTO'];
			$this->full_photo_path=trim($this->aobj_context->main_src."/". $this->FPHOTO);		 
		}
		
		function formData()
		{

$lquery = "select p.*,pd.fuserid, pd.fappno,p.fname,c.fcatdespn,d.fdescpn,ugper, ug,bed, 
			bedper, pgper,pg, phd,phdper,
			medper, med,mphil,mphilper, jrep, netp, sletp,rcphp,rgphp,rgshp, rcdehp,rclhp,fexp,fexpphd,
			rphp, rghp, rclhp, catII,teach,phdtch,rcotj,rcphd,rcophp, 
			ifnull(ug,0)+ifnull(phd,0)+ifnull(jrep,0)+ifnull(netp,0)+ifnull(sletp,0)+ifnull(bed,0)+ifnull(med,0)+ifnull(pg,0)+ifnull(mphil,0) as education, 
			ifnull(rcotj,0)+ifnull(rphp,0)+ifnull(rghp,0)+ifnull(rclhp,0)+ifnull(rcphd,0) as rechapi
			from mascat c,mascourse d, perdetl p, postdet pd
			left outer join(select qd.fuserid, qd.fappno,qd.fpercentage as ugper, sum(ifnull(qd.fpoints,0)) as ug from qualdetl qd where qd.fenttype = 'bachelor' group by qd.fuserid) as qdtab
			on pd.fuserid = qdtab.fuserid  
			left outer join(select qd.fuserid, qd.fappno,qd.fpercentage as pgper, sum(ifnull(qd.fpoints,0)) as pg from qualdetl qd where qd.fenttype = 'masters' group by qd.fuserid) as pgtab
			on pd.fuserid = pgtab.fuserid  
			left outer join(select qd.fuserid, qd.fappno,qd.fpercentage as bedper, sum(ifnull(qd.fpoints,0)) as bed from qualdetl qd where qd.fenttype = 'BEd' group by qd.fuserid) as bedtab
			on pd.fuserid = bedtab.fuserid
			left outer join(select qd.fuserid, qd.fappno,qd.fpercentage as medper, sum(ifnull(qd.fpoints,0)) as med from qualdetl qd where qd.fenttype = 'MEd' group by qd.fuserid) as medtab
			on pd.fuserid = medtab.fuserid
			left outer join(select phd.fuserid, phd.fappno,fpercent as mphilper,sum(ifnull(phd.fpoints,0)) as mphil from phddetl phd  where fenttype = 'mphil' group by phd.fuserid) as mphiltab
			on pd.fuserid = mphiltab.fuserid
			left outer join(select phd.fuserid, phd.fappno, fpercent as phdper,sum(ifnull(phd.fpoints,0)) as phd from phddetl phd where fenttype = 'phd' group by phd.fuserid) as phdtab
			on pd.fuserid = phdtab.fuserid
			left outer join(select jre.fuserid, jre.fappno, sum(ifnull(jre.fjrpoints,0)) as jrep from perdetl jre group by jre.fuserid) as jretab
			on pd.fuserid = jretab.fuserid
			left outer join(select net.fuserid, net.fappno, sum(ifnull(net.fnetpoints,0)) as netp from perdetl net group by net.fuserid) as nettab
			on pd.fuserid = nettab.fuserid
			left outer join(select slet.fuserid, slet.fappno, sum(ifnull(slet.fsletpoints,0)) as sletp from perdetl slet group by slet.fuserid) as slettab
			on pd.fuserid = slettab.fuserid
			left outer join(select catII.fuserid, catII.fappno, sum(ifnull(catII.fselfscore,0)) as catII 
			from tleact catII where fenttype = 'cat2' and ifnull(fuserid,'') <> '' and ifnull(fappno,'') <> ''	 group by catII.fuserid,fenttype) as catIItab
			on pd.fuserid = catIItab.fuserid and  pd.fappno = catIItab.fappno 
			left outer join(select teach.fuserid, teach.fappno, sum(ifnull(teach.fpoints,0)) as teach from expdetl teach where fenttype = 'teach' and ifnull(fuserid,'') <> '' and ifnull(fappno,'') <> '' group by teach.fuserid,teach.fappno) as teachtab
			on pd.fuserid = teachtab.fuserid and  pd.fappno = teachtab.fappno
			left outer join(select fexpphd.fuserid, fexpphd.fappno, sum(ifnull(fexpphd.fexp,0)) as fexpphd from expdetl fexpphd where fenttype = 'phd' and ifnull(fexpphd.fuserid,'') <> '' and ifnull(fexpphd.fappno,'') <> '' group by fexpphd.fuserid,fexpphd.fappno) as teachfexpphdptab
			on pd.fuserid = teachfexpphdptab.fuserid and  pd.fappno = teachfexpphdptab.fappno
			left outer join(select fexp.fuserid, fexp.fappno, sum(ifnull(fexp.fexp,0)) as fexp from expdetl fexp where fenttype = 'teach' and ifnull(fuserid,'') <> '' and ifnull(fappno,'') <> '' group by fexp.fuserid,fexp.fappno) as teachfexptab
			on pd.fuserid = teachfexptab.fuserid and  pd.fappno = teachfexptab.fappno
			left outer join(select phdtch.fuserid, phdtch.fappno, sum(ifnull(phdtch.fpoints,0)) as phdtch 
			from expdetl phdtch where fenttype = 'phd' and ifnull(fuserid,'') <> '' and ifnull(fappno,'') <> '' group by phdtch.fuserid) as phdtchtab
			on pd.fuserid = phdtchtab.fuserid and  pd.fappno = phdtchtab.fappno
			left outer join(select rcphd.fuserid, rcphd.fappno, sum(ifnull(rcphd.fpoints,0)) as rcphd from researchexp rcphd where fenttype = 'rcphd' and ifnull(fuserid,'') <> '' and ifnull(fappno,'') <> '' group by rcphd.fuserid, rcphd.fappno) as rcphdtab
			on pd.fuserid = rcphdtab.fuserid and pd.fappno = rcphdtab.fappno
			left outer join(select rcotj.fuserid, rcotj.fappno, sum(ifnull(rcotj.fpoints,0)) as rcotj from researchexp rcotj where fenttype = 'rcotj' and ifnull(fuserid,'') <> '' and ifnull(fappno,'') <> '' group by rcotj.fuserid, rcotj.fappno) as rcotjtab
			on pd.fuserid = rcotjtab.fuserid and pd.fappno = rcotjtab.fappno
			left outer join(select rp.fuserid, rp.fappno, sum(ifnull(rp.fpoints,0)) as rphp from rcprojct rp where fenttype = 'rcspon' and ifnull(fuserid,'') <> '' and ifnull(fappno,'') <> '' group by rp.fuserid, rp.fappno) as rptab 
			on pd.fuserid = rptab.fuserid and pd.fappno = rptab.fappno
			left outer join(select rp.fuserid, rp.fappno, sum(ifnull(rp.fpoints,0)) as rcphp from rcprojct rp where fenttype = 'rccons' and ifnull(fuserid,'') <> '' and ifnull(fappno,'') <> '' group by rp.fuserid, rp.fappno) as rcptab 
			on pd.fuserid = rcptab.fuserid and pd.fappno = rcptab.fappno
			left outer join(select rp.fuserid, rp.fappno, sum(ifnull(rp.fpoints,0)) as rcophp from rcprojct rp where fenttype = 'rcpout' and ifnull(fuserid,'') <> '' and ifnull(fappno,'') <> '' group by rp.fuserid, rp.fappno) as rcoptab 
			on pd.fuserid = rcoptab.fuserid and pd.fappno = rcoptab.fappno
			left outer join(select rg.fuserid, rg.fappno, sum(ifnull(rg.fpoints,0)) as rghp from rechguid rg where fenttype = 'rcgm' and ifnull(fuserid,'') <> '' and ifnull(fappno,'') <> '' group by rg.fuserid, rg.fappno) as rgtab
			on pd.fuserid = rgtab.fuserid and pd.fappno = rgtab.fappno
			left outer join(select rg.fuserid, rg.fappno, sum(ifnull(rg.fpoints,0)) as rgphp from rechguid rg where fenttype = 'rcgp' and ifnull(fuserid,'') <> '' and ifnull(fappno,'') <> '' group by rg.fuserid, rg.fappno) as rgptab
			on pd.fuserid = rgptab.fuserid and pd.fappno = rgptab.fappno
			left outer join(select rg.fuserid, rg.fappno, sum(ifnull(rg.fpoints,0)) as rgshp from rechguid rg where fenttype = 'rcfs' and ifnull(fuserid,'') <> '' and ifnull(fappno,'') <> '' group by rg.fuserid, rg.fappno) as rgstab
			on pd.fuserid = rgstab.fuserid and pd.fappno = rgstab.fappno
			left outer join(select rcl.fuserid, rcl.fappno, sum(ifnull(rcl.fpoints,0)) as rclhp from rclecture rcl where fenttype = 'rcil' and ifnull(fuserid,'') <> '' and ifnull(fappno,'') <> '' group by rcl.fuserid, rcl.fappno) as rcltab
			on pd.fuserid = rcltab.fuserid and pd.fappno = rcltab.fappno
			left outer join(select rcl.fuserid, rcl.fappno, sum(ifnull(rcl.fpoints,0)) as rcdehp from rclecture rcl where fenttype = 'rcde' and ifnull(fuserid,'') <> '' and ifnull(fappno,'') <> '' group by rcl.fuserid, rcl.fappno) as rcdetab
			on pd.fuserid = rcdetab.fuserid and pd.fappno = rcdetab.fappno
			where pd.fappstatus = 'T' and ifnull(pd.fdegncode,'') = '{$this->post}' and p.fuserid = pd.fuserid and 
			pd.fappno between '{$this->from_app}' and '{$this->to_app}' and pd.fdegree = '{$this->subject}'
			and p.fcatcode = c.fcatid and d.fdegree = pd.fdegree
			order by  rechapi  desc";
			
			$lresuls = $this->aobj_context->mobj_db->GetAll($lquery);
			//var_dump($lquery);
			
			
			if($this->post == 'A')
				$post = "Assistant Professor";
			if($this->post == 'S')
				$post = "Associate Professor";
			if($this->post == 'P')
				$post = "Professor";
			
			
			
			
			foreach($lresuls as $lresuls)
			{
				
			$this->pdf->AddPage("P");
			$this->pdf->SetFont('Times','B',11);
			
			$sql = "select catII.fuserid, catII.fappno, sum(ifnull(catII.fselfscore,0)) as catII 
			from tleact catII where fenttype = 'cat2' and ifnull(fuserid,'') <> '' and ifnull(fappno,'') <> '' and fappno = '{$lresuls['fappno']}' group by catII.fuserid,fenttype";
			$res = $this->aobj_context->mobj_db->GetRow($sql);
			$cat11 = $res['catII'];

$this->pdf->cell(180,5,"GULBARGA UNIVERSITY","0",1,"C");
			$this->pdf->cell(180,5,"Notification No. GUK/ADM/EST(T)/2017-18/1990/1991 DATED 26/02/2018","0",1,"C");
			$this->pdf->Ln(1);
			$this->pdf->SetFont('Times','',8);
			$this->pdf->cell(180,4,"SCRUTINY COMMITTEE SUMMRY SHEET","0",1,"C");
			$this->pdf->cell(80,4,"Post Applied","1",0,"L");
			$this->pdf->cell(110,4,"".$post,"1",1,"L");

$this->pdf->cell(80,4,"Subject","1",0,"L");
			$this->pdf->cell(110,4,"".$lresuls['fdescpn'],"1",1,"L");

$this->pdf->cell(80,4,"Application No","1",0,"L");
			$this->pdf->cell(110,4,"".$lresuls['fappno'],"1",1,"L");

$this->pdf->cell(80,4,"Inward No","1",0,"L");
			$this->pdf->cell(110,4,"","1",1,"L");
			
			$this->pdf->Ln(1);
			$this->pdf->SetFont('Times','UB',11);
			$this->pdf->cell(40,5,"Personal Details","0",1,"L");
			$this->pdf->SetFont('Times','',8);	
			$this->pdf->cell(80,5,"Name","1",0,"L");
			$this->pdf->cell(110,5,"".$lresuls['fname'],"1",1,"L");

$this->pdf->cell(80,5,"DOB / Age","1",0,"L");
			$this->pdf->cell(110,5,"".$lresuls['fdob'] ." / ".$lresuls['fage'],"1",1,"L");

$this->pdf->cell(80,5,"Gender / Marital Status","1",0,"L");
			$this->pdf->cell(110,5,"".$lresuls['fgender']." / ".$lresuls['fmarstatus'],"1",1,"L");

$this->pdf->cell(80,5,"Category","1",0,"L");
			$this->pdf->cell(110,5,"".$lresuls['fcatdespn'],"1",1,"L");
			
			$this->pdf->cell(80,5,"Nationality","1",0,"L");
			$this->pdf->cell(110,5,"".$lresuls['fnational'],"1",1,"L");

$this->pdf->cell(80,5,"Mobile No ","1",0,"L");
			$this->pdf->cell(110,5,"".$lresuls['fmobile'],"1",1,"L");
			
			$this->pdf->cell(80,5,"Email Address ","1",0,"L");
			$this->pdf->cell(110,5,"".$lresuls['femailid'],"1",1,"L");
			
			$this->pdf->cell(80,5,"Aadhar Number ","1",0,"L");
			$this->pdf->cell(110,5,"".$lresuls['faadhar'],"1",1,"L");
				
			$address1 = $lresuls['fcomadd1'].''.$lresuls['fcomadd2'];
			$address2 = $lresuls['fcomadd3'].''.$lresuls['fcomadd4'];

$this->pdf->cell(80,3,"Address for Correspondence","LRT",0,"L");
			$this->pdf->Cell(110,3,"".$address1,"LTR","1","L");

$this->pdf->cell(80,3,"","LBR",0,"L");
			$this->pdf->Cell(110,3,"".$address2,"LRB","1","L");
			
			$j = "NO";
			if($lresuls['f371j'] == 'TRUE')
				$j = "YES";

$pd = "NO";
			if($lresuls['fpd'] == 'TRUE')
				$pd = "YES";
				
			$ex = "NO";
			if($lresuls['fexservice'] == 'TRUE')
				$ex = "YES";

$rural = "NO";
			if($lresuls['frural'] == 'TRUE')
				$rural = "YES";
						 
			$kan = "NO";
			if($lresuls['fkanmedium'] == 'TRUE')
				$kan = "YES";
							 
			$this->pdf->cell(80,5,"371 (J) - RD No. : ","1",0,"L");
			$this->pdf->cell(110,5,"".$j,"1",1,"L");

$this->pdf->cell(80,5,"Physically Disabled","1",0,"L");
			$this->pdf->cell(110,5,"".$pd,"1",1,"L");

$this->pdf->cell(80,5,"Ex-servicemen","1",0,"L");
			$this->pdf->cell(110,5,"".$ex,"1",1,"L");
			
			$this->pdf->cell(80,5,"Kannada Medium","1",0,"L");
			$this->pdf->cell(110,5,"".$kan,"1",1,"L");

$this->pdf->cell(80,5,"Rural","1",0,"L");
			$this->pdf->cell(110,5,"".$rural,"1",1,"L");

$this->pdf->Ln(1);

$sql = "select * from qualdetl where fenttype = 'masters' 
			and ifnull(fuserid,'') <> '' and ifnull(fappno,'') <> '' 
			and fappno = '{$lresuls['fappno']}'";
			$res = $this->aobj_context->mobj_db->GetRow($sql);	
			
			$this->pdf->SetFont('Times','BU',11);	
			$this->pdf->cell(40,5,"PG Details","0",1,"L");
			$this->pdf->SetFont('Times','',8);	
			
			$this->pdf->cell(20,5,"Degree","1",0,"L");
			$this->pdf->cell(60,5,"Subject","1",0,"L");
			$this->pdf->cell(40,5,"Funivname","1",0,"L");
			$this->pdf->cell(20,5,"Max. Marks","1",0,"L");
			$this->pdf->cell(20,5,"Sec. Marks","1",0,"L");
			$this->pdf->cell(10,5,"%","1",0,"L");
			$this->pdf->cell(20,5,"points","1",1,"L");
			
			$this->pdf->cell(20,5,"".$res['fdegree'],"1",0,"L");
			$this->pdf->cell(60,5,"".$res['fsubjects'],"1",0,"L");
			$this->pdf->cell(40,5,"".$res['funivname'],"1",0,"L");
			$this->pdf->cell(20,5,"".$res['fmaxmarks'],"1",0,"L");
			$this->pdf->cell(20,5,"".$res['fsecmarks'],"1",0,"L");
			$this->pdf->cell(10,5,"".$res['fpercentage'],"1",0,"L");
			$this->pdf->cell(20,5,"".$res['fpoints'],"1",1,"L");
			$pg = $res['fpoints'];

$this->pdf->Ln(1);

$sql = "select fdegree,left(funivname,40) as funivname,left(ftitle,50) as ftitle,
			date_format(fdoa,'%d/%m/%Y') as fdoa,
			fpercent,fpoints from phddetl where 
			fenttype = 'mphil' and ifnull(ftitle,'') <> ''
			and ifnull(fuserid,'') <> '' and ifnull(fappno,'') <> '' 
			and fappno = '{$lresuls['fappno']}'";
			$res = $this->aobj_context->mobj_db->GetRow($sql);	
			
			$this->pdf->SetFont('Times','UB',11);
			$this->pdf->cell(40,5,"M.Phil Details","0",1,"L");
			$this->pdf->SetFont('Times','',8);

$this->pdf->cell(20,5,"Degree","1",0,"L");
			$this->pdf->cell(70,5,"Subject","1",0,"L");
			$this->pdf->cell(50,5,"Funivname","1",0,"L");
			$this->pdf->cell(20,5,"Date Award","1",0,"L");
			$this->pdf->cell(10,5,"%","1",0,"L");
			$this->pdf->cell(20,5,"points","1",1,"L");
			
			$this->pdf->cell(20,5,"".$res['fdegree'],"1",0,"L");
			$this->pdf->cell(70,5,"".$res['ftitle'],"1",0,"L");
			$this->pdf->cell(50,5,"".$res['funivname'],"1",0,"L");
			$this->pdf->cell(20,5,"".$res['fdoa'],"1",0,"L");
			$this->pdf->cell(10,5,"".$res['fpercent'],"1",0,"L");
			$this->pdf->cell(20,5,"".$res['fpoints'],"1",1,"L");
			$mphil = $res['fpoints'];
			$this->pdf->Ln(1);

$sql = "select fdegree,left(funivname,40) as funivname ,left(ftitle,50) as ftitle,
			date_format(fdoa,'%d/%m/%Y') as fdoa,
			fpercent,fpoints from phddetl where 
			fenttype = 'phd' and ifnull(ftitle,'') <> ''
			and ifnull(fuserid,'') <> '' and ifnull(fappno,'') <> '' 
			and fappno = '{$lresuls['fappno']}'";
			$res = $this->aobj_context->mobj_db->GetRow($sql);	
		//	var_dump($sql);
			$this->pdf->SetFont('Times','UB',11);
			$this->pdf->cell(40,5,"PhD Details","0",1,"L");
			$this->pdf->SetFont('Times','',8);

//	var_dump($lresuls['f371j']);die();
		//*** phd and mhil ************* */
			$phd = $res['fpoints'];
			$phdmmphil = $mphil + $phd;

if($phdmmphil > 8)
				$phdmmphil = 8;
		//************* net /slet pdf */
			$netpdf = $lresuls['jrep']+$lresuls['netp']+$lresuls['sletp']+$lresuls['FPDFPOINTS'];
			if($netpdf > 7)
				$netpdf = 7;

$this->pdf->cell(180,5,"JRF / SRF / NET / SLET / PDF","0",1,"L");	
			$this->pdf->cell(70,5,"NET-JRF","1",0,"L");
			$this->pdf->cell(30,5,$lresuls['jrep'],"1",0,"C");
			$this->pdf->cell(90,5,"","1",1,"C");

$this->pdf->cell(70,5,"NET","1",0,"L");
			$this->pdf->cell(30,5,$lresuls['netp'],"1",0,"C");
			$this->pdf->cell(90,5,"","1",1,"C");
			
			$this->pdf->cell(70,5,"SLET","1",0,"L");
			$this->pdf->cell(30,5,$lresuls['sletp'],"1",0,"C");
			$this->pdf->cell(90,5,"","1",1,"C");

$this->pdf->cell(70,5,"PDF","1",0,"L");
			$this->pdf->cell(30,5,$lresuls['FPDFPOINTS'],"1",0,"C");
			$this->pdf->cell(90,5,"","1",1,"C");
			
			$this->pdf->SetFont('Times','UB',11);
			$this->pdf->Ln(1);
			$this->pdf->cell(180,5,"Calculation of Academic Record (Qualifications) - Maximum 35 points","0",1,"C");	
			$this->pdf->SetFont('Times','',8);

$this->pdf->cell(15,5,"Sl. No.","1",0,"C");
			$this->pdf->cell(90,5,"Examination","1",0,"C");
			$this->pdf->cell(30,5,"Max Points","1",0,"C");
			$this->pdf->cell(30,5,"Points obtained","1",1,"C");

$this->pdf->cell(15,5,"1","1",0,"C");
			$this->pdf->cell(90,5,"PG","1",0,"L");
			$this->pdf->cell(30,5,"20","1",0,"C");
			$this->pdf->cell(30,5,"".$pg,"1",1,"C");	
			
			$this->pdf->cell(15,5,"2","1",0,"C");
			$this->pdf->cell(90,5,"M.Phil / Ph.D","1",0,"L");
			$this->pdf->cell(30,5,"4 / 8 ","1",0,"C");
			$this->pdf->cell(30,5,"".$phdmmphil,"1",1,"C");
			
			$this->pdf->cell(15,5,"3","1",0,"C");
			$this->pdf->cell(90,5,"SLET / NET / NET-JRF / PDF","1",0,"L");
			$this->pdf->cell(30,5,"2 / 3 / 5 / 7","1",0,"C");
			$this->pdf->cell(30,5,"".$netpdf,"1",1,"C");
			
			$actotal = $netpdf+$phdmmphil+$pg;	
			$this->pdf->cell(15,5,"","1",0,"C");
			$this->pdf->cell(90,5,"Total","1",0,"C");
			$this->pdf->cell(30,5,"35","1",0,"C");
			$this->pdf->cell(30,5,"".$actotal,"1",1,"C");

//$phdmmphil

$this->pdf->Ln(1);
			$this->pdf->SetFont('Times','UB',11);
			$this->pdf->cell(180,4,"MINIMUM QUALIFICATION (REQUIREMENTS)","0",1,"C");
			$this->pdf->SetFont('Times','',8);
			$this->pdf->cell(180,4,$post,"0",1,"C");
			if($this->post == 'A')
			{	
				$this->pdf->SetFont('Times','B',8);	
				$this->pdf->cell(30,5,"Sl. No.","1",0,"L");
				$this->pdf->cell(65,5,"Course","1",0,"L");
				$this->pdf->cell(30,5,"Yes / No ","1",0,"L");
				$this->pdf->cell(65,5,"Remarks","1",1,"L");
				
				$this->pdf->cell(30,2,"1.","LRT",0,"C");
				$this->pdf->cell(65,2,"PG Degree (55% marks)","LRT",0,"L");
				$this->pdf->cell(30,2,"","LRT",0,"L");
				$this->pdf->cell(65,2,"","LRT",1,"L");
				
				$this->pdf->cell(30,2,"","LRB",0,"C");
				$this->pdf->cell(65,2,"(5% relaxation to SC/ST/OBC/PWD)","LRB",0,"L");
				$this->pdf->cell(30,2,"","LRB",0,"L");
				$this->pdf->cell(65,2,"","LRB",1,"L");

$this->pdf->cell(30,5,"2.","1",0,"C");
				$this->pdf->cell(65,5,"Ph.D. with course work","1",0,"L");
				$this->pdf->cell(30,5,"","1",0,"L");
				$this->pdf->cell(65,5,"","1",1,"L");
				
				$this->pdf->cell(30,5,"3.","1",0,"C");
				$this->pdf->cell(65,5,"Ph.D. before 2009 with UGC norms","1",0,"L");
				$this->pdf->cell(30,5,"","1",0,"L");
				$this->pdf->cell(65,5,"","1",1,"L");
				
				$this->pdf->cell(30,5,"4.","1",0,"C");
				$this->pdf->cell(65,5,"NET/SLET","1",0,"L");
				$this->pdf->cell(30,5,"","1",0,"L");
				$this->pdf->cell(65,5,"","1",1,"L");

$this->pdf->cell(30,3,"5.","LRT",0,"C");
				$this->pdf->cell(65,3,"Any Other :","LRT",0,"L");
				$this->pdf->cell(30,3,"","LRT",0,"L");
				$this->pdf->cell(65,3,"","LRT",1,"L");
				
				$this->pdf->cell(30,3,"","LR",0,"C");
				$this->pdf->cell(65,3,"A.","LR",0,"L");
				$this->pdf->cell(30,3,"","LR",0,"L");
				$this->pdf->cell(65,3,"","LR",1,"L");
				
				$this->pdf->cell(30,3,"","LR",0,"C");
				$this->pdf->cell(65,3,"B","LR",0,"L");
				$this->pdf->cell(30,3,"","LR",0,"L");
				$this->pdf->cell(65,3,"","LR",1,"L");
				
				$this->pdf->cell(30,3,"","LRB",0,"C");
				$this->pdf->cell(65,3,"C","LRB",0,"L");
				$this->pdf->cell(30,3,"","LRB",0,"L");
				$this->pdf->cell(65,3,"","LRB",1,"L");
			}

$this->pdf->Ln(2);
			$sql = "select funivname,fdegncode,fstatus,fpayscale,date_format(ffromdate,'%d/%m%Y') as ffromdate, date_format(ftodate,'%d/%m%Y') as ftodate, fexp, fstatus  from expdetl where ifnull(fuserid,'') <> '' and ifnull(fappno,'') <> '' 
			and fappno = '{$lresuls['fappno']}' and fenttype = 'present'";
			$res = $this->aobj_context->mobj_db->GetRow($sql);
			
			$this->pdf->SetFont('Times','BU',11);	
			$this->pdf->cell(40,5,"Present Employment","0",1,"L");
			$this->pdf->SetFont('Times','',8);

$this->pdf->cell(80,5,"Univ. name","1",0,"L");
			$this->pdf->cell(60,5,"Deg. Name","1",0,"L");
			$this->pdf->cell(20,5,"Status","1",0,"L");
			$this->pdf->cell(30,5,"Join Date","1",1,"L");
			
			$this->pdf->cell(80,5,"".$res['funivname'],"1",0,"L");
			$this->pdf->cell(60,5,"".$res['fdegncode'],"1",0,"L");
			$this->pdf->cell(20,5,"".$res['fstatus'],"1",0,"L");
			$this->pdf->cell(30,5,"".$res['ffromdate'],"1",1,"L");

$this->pdf->Ln(2);

$sql = "select left(funivname,40) as funivname,fdegncode,fstatus,fpayscale,date_format(ffromdate,'%d/%m/%Y') as ffromdate, date_format(ftodate,'%d/%m/%Y') as ftodate, fexp, fstatus  from expdetl where ifnull(fuserid,'') <> '' and ifnull(fappno,'') <> '' 
			and fappno = '{$lresuls['fappno']}' and fenttype = 'teach'";
			$res = $this->aobj_context->mobj_db->GetAll($sql);

$this->pdf->SetFont('Times','BU',11);	
			$this->pdf->cell(40,5,"Teaching Experience (Full Time)","0",1,"L");
			$this->pdf->SetFont('Times','',8);	
			$this->pdf->cell(70,5,"Univ. name","1",0,"L");
			$this->pdf->cell(50,5,"Deg. Name","1",0,"L");
			$this->pdf->cell(20,5,"Status","1",0,"L");
			$this->pdf->cell(20,5,"From Date","1",0,"L");
			$this->pdf->cell(20,5,"To Date","1",0,"L");
			$this->pdf->cell(10,5,"Exp.","1",1,"L");
			
			foreach ($res as $key => $value)
			{
				$this->pdf->cell(70,5,"".$value['funivname'],"1",0,"L");
				$this->pdf->cell(50,5,"".$value['fdegncode'],"1",0,"L");
				$this->pdf->cell(20,5,"".$value['fstatus'],"1",0,"L");
				$this->pdf->cell(20,5,"".$value['ffromdate'],"1",0,"L");
				$this->pdf->cell(20,5,"".$value['ftodate'],"1",0,"L");
				$this->pdf->cell(10,5,"".$value['fexp'],"1",1,"L");
			}

$IIE = '';
			if($lresuls['rgshp'] != '' || $lresuls['rclhp'] != '') 
				$IIE = ($lresuls['rgshp']+$lresuls['rclhp']);
	
			$total = ($cat11+$lresuls['rcphd']+$lresuls['rcotj']+$lresuls['rphp']+$lresuls['rcphp']+$lresuls['rcophp']+$lresuls['rghp']+$lresuls['rgphp']+$IIE+$lresuls['rcdehp']);
					
			$this->pdf->Ln(2);
			
			$this->pdf->SetFont('Times','BU',11);	
			$this->pdf->cell(180,5,"Calculation of Research Performance (15)","0",1,"C");
			$this->pdf->SetFont('Times','',9);

$str = '<table border="1" cellpadding="0" cellspacing="0">
			<thead>
			 <tr style="">
			  <td  align="center"><b>Category</b></td>
			  <td  align="center"><b>Activity</b></td>
			  <td  align="center"><b>Publication Type</b></td>
			  <td  align="center"> <b>Points </b></td>
			  <td  align="center"><b>Screen Points Obt.</b></td>
			  <td  align="center"><b>Points Obtained </b></td>
			 </tr>
			</thead>
			 <tr>
			  <td  align="center" style = "vertical-align:center" rowspan="2">III (A)</td>
			  <td rowspan="2">Research Papers Published in:</td>
			  <td >Refereed Journals as notified by UGC</td>
			  <td >01 per Publication Max of 25</td>
			  <td align="right">'.$lresuls['rcphd'].'</td>
			  <td  ></td>
			 </tr>
			 <tr>
			  <td >Other Reputed Journals as notified by the UGC</td>
			  <td >02 per Publication Max of 10</td>
			  <td align="right">'.$lresuls['rcphdj'].'</td>
			  <td >&nbsp;&nbsp;&nbsp;&nbsp;</td>
			 </tr>
			 <tr>
			  <td  align="center" rowspan="5">III (B)</td>
			  <td rowspan="5">Publications other than journals articles (books, chapters in books)</td>
			  <td >Text/Reference, Books published by International publishers, with ISBN/ISSN number</td>
			  <td >05 per Book Max 30</td>
			  <td align="right">'.$lresuls['rcotj'].'</td>
			  <td ></td>
			 </tr>
			 <tr>
			  <td >Subject Books, published by National level publisher, with ISBN/ISSN number of State/Central Govt.</td>
			  <td >05 per Book Max 20</td>
			  <td align="right">'.$lresuls['rcsub'].'</td>
			  <td ></td>
			 </tr>
			 <tr>
			  <td >Subject Books, published by other local publisher, with ISBN/ISSN number</td>
			  <td >05 per Book Max 15</td>
			  <td align="right">'.$lresuls['rcsubloc'].'</td>
			  <td ></td>
			 </tr>
			 <tr>
			  <td rowspan="2">Chapters in Books, published by National and International level publisher, with ISBN/ISSN number. International National</td>
			  <td >International - 2.5  Per Chapter Max -10 </td>
			  <td align="right">'.$lresuls['rcsubinter'].'</td>
			  <td ></td>
			 </tr>
			 <tr>
			  <td >National - 2.5 Per Chapter Max-05</td>
			  <td align="right">'.$lresuls['rcsublocl'].'</td>
			  <td ></td>
			 </tr>
			</table>';

$this->pdf->writeHTML($str, true, false, false, false, '');	
				
			$this->pdf->Ln(2);

$this->pdf->SetFont('Times','BU',11);
			$this->pdf->cell(180,4,"API Summary Points","0",1,"C"); 
			$this->pdf->SetFont('Times','',8);
			$this->pdf->cell(13,5,"Cat-II","1",0,"C");
			$this->pdf->cell(13,5,"III A","1",0,"C");
			$this->pdf->cell(13,5,"III B","1",0,"C");
			$this->pdf->cell(13,5,"III C(i)","1",0,"C");
			$this->pdf->cell(13,5,"III C(ii)","1",0,"C");
			$this->pdf->cell(13,5,"III C(iii)","1",0,"C");
			$this->pdf->cell(13,5,"III D(i)","1",0,"C");
			$this->pdf->cell(13,5,"III D(ii)","1",0,"C");
			$this->pdf->cell(13,5,"III E(i)","1",0,"C");
			$this->pdf->cell(13,5,"III E(ii)","1",0,"C");
			$this->pdf->cell(13,5,"III F","1",0,"C");
			$this->pdf->cell(13,5,"Total","1",1,"C");
			//$this->pdf->cell(13,5,"40%","1",1,"C");
			
			$percentage = ($total*0.4);
			
			$this->pdf->cell(13,5,$cat11,"1",0,"C");
			$this->pdf->cell(13,5,$lresuls['rcphd'],"1",0,"C");
			$this->pdf->cell(13,5,$lresuls['rcotj'],"1",0,"C");
			$this->pdf->cell(13,5,$lresuls['rphp'],"1",0,"C");
			$this->pdf->cell(13,5,$lresuls['rcphp'],"1",0,"C");
			$this->pdf->cell(13,5,$lresuls['rcophp'],"1",0,"C");
			$this->pdf->cell(13,5,$lresuls['rghp'],"1",0,"C");
			$this->pdf->cell(13,5,$lresuls['rgphp'],"1",0,"C");
			$this->pdf->cell(13,5,$lresuls['rgshp'],"1",0,"C");
			$this->pdf->cell(13,5,$lresuls['rclhp'],"1",0,"C");
			$this->pdf->cell(13,5,$lresuls['rcdehp'],"1",0,"C");
			$this->pdf->cell(13,5,$total,"1",1,"C");
			//$this->pdf->cell(13,5,$percentage,"1",1,"C");
			
			$sql = "select distinct * from otherdet where ifnull(fuserid,'') <> '' and ifnull(fappno,'') <> '' 
			and fappno = '{$lresuls['fappno']}'";
			$res = $this->aobj_context->mobj_db->GetRow($sql);

$this->pdf->Ln(2);
			$this->pdf->SetFont('Times','BU',11);
			$this->pdf->cell(40,5,"Other Details","0",1,"L");
			$this->pdf->SetFont('Times','',8);

$this->pdf->cell(150,5,"Gender / Caste related offences","1",0,"L");
			$this->pdf->cell(40,5,$res['FPUNISHEDGC'],"1",1,"C");

$this->pdf->cell(150,5,"Resignation / Discharged / Dismissed","1",0,"L");
			$this->pdf->cell(40,5,$res['FPUNISHEDGC'],"1",1,"C");

$this->pdf->cell(150,5,"Criminal Cases","1",0,"L");
			$this->pdf->cell(40,5,$res['FCRIMINAL'],"1",1,"C");
			
			$this->pdf->Ln(2);
			$this->pdf->SetFont('Times','BU',11);
			$this->pdf->cell(190,5,"Other Activities","0",1,"L");
			$this->pdf->SetFont('Times','',8);
			$this->pdf->MultiCell(190,4,$res['FANYDET'],"1","L");

$this->pdf->Ln(2);
			$this->pdf->SetFont('Times','BU',11);
			$this->pdf->cell(40,5,"Two Referees (Contact Details)","0",1,"L");
			$this->pdf->SetFont('Times','',8);
			$this->pdf->cell(30,5,"Sl. No.","1",0,"L");
			$this->pdf->cell(70,5,"Name","1",0,"L");
			$this->pdf->cell(40,5,"Mobile No.","1",0,"L");
			$this->pdf->cell(50,5,"Email Id.","1",1,"L");

$this->pdf->cell(30,5,"1. ","1",0,"L");
			$this->pdf->cell(70,5,$res['FREFNAME1'],"1",0,"L");
			$this->pdf->cell(40,5,$res['FREFMOBILE1'],"1",0,"L");
			$this->pdf->cell(50,5,$res['FREFEMAIL1'],"1",1,"L");

$this->pdf->cell(30,5,"2. ","1",0,"L");
			$this->pdf->cell(70,5,$res['FREFNAME2'],"1",0,"L");
			$this->pdf->cell(40,5,$res['FREFMOBILE2'],"1",0,"L");
			$this->pdf->cell(50,5,$res['FREFEMAIL2'],"1",1,"L");

$this->pdf->Ln(2);
			$y = $this->pdf->getY();
			if($y >170)
				$this->pdf->AddPage("P");
				$this->pdf->SetFont('Times','BU',11);
			$this->pdf->cell(190,6,"SUMMARY OF POINTS","1",1,"C");
			$this->pdf->SetFont('Times','B',8);
			$this->pdf->cell(130,6,"Criteria","1",0,"L");
			$this->pdf->cell(30,6,"Maximum Points","1",0,"C");
			$this->pdf->cell(30,6,"Points Obtained","1",1,"C");
			if($this->post == 'A')
			{	
				$this->pdf->cell(130,6,"Academic Background","1",0,"L");
				$this->pdf->cell(30,6,"35","1",0,"C");
				$this->pdf->cell(30,6,$edusum,"1",1,"C");	
			
				$this->pdf->cell(130,6,"Research Performance","1",0,"L");
				$this->pdf->cell(30,6,"15","1",0,"C");
				$this->pdf->cell(30,6,$rechsum,"1",1,"C");		
				
				$this->pdf->cell(130,6,"Total","1",0,"L");
				$this->pdf->cell(30,6,"50","1",0,"C");
				$this->pdf->cell(30,6,$atotal,"1",1,"C");		
				
			}
			$this->pdf->Ln(2);
			$this->pdf->cell(190,5,"Scrutiny Committee Observations / Recommendations","0",1,"C");
			$this->pdf->cell(100,5,"Observations/Recommendations","1",0,"L");
			$this->pdf->cell(90,5,"Remarks","1",1,"L");
			$this->pdf->cell(100,5," Application not in prescribed format/incomplete/No proof ","LRT",0,"L");
			$this->pdf->cell(90,5,"","LRT",1,"L");

$this->pdf->cell(100,5," produced for claims made or experience/Does not possess ","LR",0,"L");
			$this->pdf->cell(90,5,"","LR",1,"L");
			$this->pdf->cell(100,5," prescribed minimum qualifications or requirements.","LRB",0,"L");
			$this->pdf->cell(90,5,"","LRB",1,"L");
		
			$this->pdf->Ln(15);

$this->pdf->cell(90,5,"Signature of the Dean of Faculty (Chairman / Chairperson)","0",0,"L");
			$this->pdf->cell(100,5,"Signature of Chairman / Chairperson / Professor (Member)","0",1,"R");
			$this->pdf->Ln(15);
			$this->pdf->cell(90,5,"Signature of External Subject Expert (Member)","0",0,"L");
			$this->pdf->cell(100,5,"Director, IQAC, GUK (Convenor)","0",1,"R");

}
		}
		// teach,phdtch
		
		function SendOutput()
		{
			$this->pdf->Output("Application_{$this->app_no}.pdf","D");
		}
		
		 
}
function Printapplicationsum($aobj_context)
{
$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
$class_obj=new certificate_print();
// $class_obj->AliasNbPages();
$class_obj->DefaultConstructor($aobj_context);
$class_obj->formcolldata();
$class_obj->GetQry();
$class_obj->formData();

$class_obj->SendOutput();
}

${this.title}

Code Editor : printapp_sum.php