Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
phpmailer	[ DIR ]	drwxr-xr-x
cManualMailer.php	3.68 KB	-rwxr-xr-x
cManualMailermohan.php	3.68 KB	-rwxr-xr-x
caccesscontext.php	1.24 KB	-rwxr-xr-x
caccesscontextold.php	1.24 KB	-rwxr-xr-x
cappcontext.php	2.68 KB	-rwxr-xr-x
cappcontext_02032018.php	2.69 KB	-rwxr-xr-x
cconfig.php	1.08 KB	-rwxr-xr-x
cmailer.php	6.83 KB	-rwxr-xr-x
coutput.php	1.76 KB	-rwxr-xr-x
crequestbroker.php	2.49 KB	-rwxr-xr-x
csessions.php	518 B	-rwxr-xr-x
csessionsold.php	514 B	-rwxr-xr-x
curricular.php	4.41 KB	-rwxr-xr-x
cuser.php	3.41 KB	-rwxr-xr-x
customappcontext.php	2.34 KB	-rwxr-xr-x
customappcontext_old.php	2.35 KB	-rwxr-xr-x
educationdet.php	19.85 KB	-rwxr-xr-x
eperience_det.php	23.08 KB	-rwxr-xr-x
eperience_det_old.php	23.69 KB	-rwxr-xr-x
foreigndetails.php	1.66 KB	-rwxr-xr-x
format.php	6.75 KB	-rwxr-xr-x
getdata.php	6.97 KB	-rwxr-xr-x
json.php	33.22 KB	-rwxr-xr-x
login.php	1.9 KB	-rwxr-xr-x
login_11102017.php	1.62 KB	-rwxr-xr-x
mregistry.php	9.76 KB	-rwxr-xr-x
orientiondet.php	1.82 KB	-rwxr-xr-x
other_det.php	2.93 KB	-rwxr-xr-x
otherexpdetails.php	821 B	-rwxr-xr-x
payment_det.php	11.42 KB	-rwxr-xr-x
payment_det1.php	11.27 KB	-rwxr-xr-x
personaldet.php	8.11 KB	-rwxr-xr-x
post.php	8.39 KB	-rwxr-xr-x
post_22.php	7.12 KB	-rwxr-xr-x
postdetails.php	1.57 KB	-rwxr-xr-x
preview_det.php	75.63 KB	-rwxr-xr-x
preview_det_22.php	55.56 KB	-rwxr-xr-x
preview_det_old.php	55.89 KB	-rwxr-xr-x
preview_det_raghu.php	60.1 KB	-rwxr-xr-x
printapp_det.php	69.18 KB	-rwxr-xr-x
printapp_det.php1	69.09 KB	-rwxr-xr-x
publicationdet.php	2.09 KB	-rwxr-xr-x
referencesdet.php	1.82 KB	-rwxr-xr-x
registration.php	5.37 KB	-rwxr-xr-x
registration_11102017.php	3.3 KB	-rwxr-xr-x
research_det.php	53.96 KB	-rwxr-xr-x
research_det2.php	112.53 KB	-rwxr-xr-x
researchdetails.php	1.77 KB	-rwxr-xr-x
sendGridMail.php	1.17 KB	-rwxr-xr-x
stringspliter.php	693 B	-rwxr-xr-x
upload_det.php	1.91 KB	-rwxr-xr-x
upload_file.php	585 B	-rwxr-xr-x
uploaddocuments.php	3.98 KB	-rwxr-xr-x
workexpdetails.php	1.53 KB	-rwxr-xr-x

Code Editor : preview_det_22.php

<?php
function loadPreviewDetails($aobj_context)
{
	session_start();
	$userid = $_SESSION['userid'];
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$appno = trim($aobj_context->mobj_data["appno"]);
	$postname = trim($aobj_context->mobj_data["postname"]);
	$post_subject = trim($aobj_context->mobj_data["post_subject"]); 
	
	$ug = 0;
	$mphil = 0;
	$phd = 0;
	$pg = 0;
	$jre = 0;
	$net = 0;
	$slet = 0;
	
	$query = "select p.*,group_concat(distinct fspoken,'->',fspoken) as lang 
				from perdetl p inner join languagedetl l  on l.fuserid = p.fuserid
				where p.fuserid = '{$userid}' 
				group by p.fuserid";
	$results  = $aobj_context->mobj_db->GetRow($query);	
	
	$query2 = "select * from qualdetl where fuserid = '{$userid}'";
	$results2  = $aobj_context->mobj_db->GetAll($query2);
	
	
	$query3 = "select sum(fselfscore) as cat2 from tleact where fuserid = '{$userid}' and fappno = '{$appno}' and fenttype = 'cat2' order by fenttype";
	$results3  = $aobj_context->mobj_db->GetRow($query3);
	$cat2 = $results3['cat2'];
	
	$query3 = "select sum(fpoints) as lecture from rclecture where fuserid = '{$userid}' and fappno = '{$appno}' order by fenttype";
	$results3  = $aobj_context->mobj_db->GetRow($query3);
	$lecture = $results3['lecture'];
	
	$query3 = "select sum(fpoints) as projct from rcprojct where fuserid = '{$userid}' and fappno = '{$appno}' order by fenttype";
	$results3  = $aobj_context->mobj_db->GetRow($query3);
	$projct = $results3['projct'];
	
	$query3 = "select sum(fpoints) as guid from rechguid where fuserid = '{$userid}' and fappno = '{$appno}' order by fenttype";
	$results3  = $aobj_context->mobj_db->GetRow($query3);
	$guid = $results3['guid'];
	
	$query4 = "select sum(fpoints) as expfpoints,sum(fexp) as fexp  from expdetl where fuserid = '{$userid}' and fappno = '{$appno}' order by fenttype";
	$results4  = $aobj_context->mobj_db->GetRow($query4);
	$expfpoints = $results4['expfpoints'];
	
	$query5 = "select sum(fpoints) as researchexpfpoints from researchexp where fuserid = '{$userid}' and fappno = '{$appno}' order by fenttype";
	$results5  = $aobj_context->mobj_db->GetRow($query5);
	$rchpoints = $results5['researchexpfpoints'];
	
	$query = "SELECT SUM(fpoints) as phd FROM phddetl where fuserid = '{$userid}'";
	$results  = $aobj_context->mobj_db->GetRow($query);
	$phd = $results['phd'];
	
	$query = "SELECT SUM(fpoints) as ug FROM qualdetl where fuserid = '{$userid}'";
	$results  = $aobj_context->mobj_db->GetRow($query);
	$ug = $results['ug'];
	
	$query = "select p.*,GROUP_CONCAT(DISTINCT flanguage,'->',fwrite,'->',fread,'->',fspoken) AS lang,c.fcatcode as fcatcode
	from perdetl p inner join languagedetl l  on l.fuserid = p.fuserid
	inner join mascat c on p.fcatcode = c.fcatid
	where p.fuserid = '{$userid}' 
	group by p.fuserid";
	$results  = $aobj_context->mobj_db->GetRow($query);	
	
		$table = '<table class="table table-bordered" border-color:"black"; style="width:90%;" id="">';
		$table.='<tr>'; 								
		$table.='<td style="width:10%;font-weight: bold;font-family:italic;">Summary of points earned for Educational Qualifications and Academic Performance Indicator(API) Score as per the UGC guidelines</td>';
		$table.='</tr></table><br>';
	
	$slet = $results['fsletpoints'];
	$net = $results['fnetpoints'];
	$jre = $results['fjrpoints'];
	if($postname == 'ASSISTANT PROFESSOR')	
	{
		$sum = $ug+$phd+$jre+$net+$slet;
		if($sum > 47)
			$sum = 47;
		
		if($rchpoints > 33)
			$rchpoints = 33;
		
		if($expfpoints > 20)
			$expfpoints = 20;	
		
		$total = $sum+$expfpoints+$rchpoints;
		
		$table.= '<table class="table table-bordered" border-color:"black"; style="width:90%;" id="postdettable">';
		$table.='<tr>'; 								
		$table.='<td style="width:10%;font-weight:bold;text-align:center;background-color:lightblue;font-family:italic;font-size:120%;" colspan=3>SUMMARY OF POINTS</td>';
		$table.='</tr>';
		$table.='<tr>'; 								
		$table.='<td style="width:10%;font-weight: bold;font-family:italic;">Criteria</td>';
		$table.='<td style="width:10%;font-weight: bold;font-family:italic;">Maximum Points</td>';
		$table.='<td style="width:10%;font-weight: bold;font-family:italic;">Points Obtained</td>';
		$table.='</tr>'; 								
		$table.="<td style='width:10%;font-family:italic;'>Academic Qualifications</td>";		
		$table.='<td style="width:10%;font-weight: bold;">47</td>';
		$table.="<td style='width:10%'>{$sum}</td>"; 
		$table.="</tr>";
		$table.='</tr>'; 								
		$table.="<td style='width:10%;font-family:italic;'>Research Publications</td>";		
		$table.='<td style="width:10%;font-weight: bold;">33</td>';
		$table.="<td style='width:10%'>{$rchpoints}</td>"; 
		$table.="</tr>";
		
		$table.='</tr>'; 								
		$table.="<td style='width:10%;font-family:italic;'>Teaching experience</td>";		
		$table.='<td style="width:10%;font-weight:bold;">20</td>';
		$table.="<td style='width:10%'>{$expfpoints}</td>"; 
		$table.="</tr>";
		$table.='</tr>'; 								
		$table.="<td style='width:10%;font-family:italic;'>Total</td>";		
		$table.='<td style="width:10%;font-weight: bold;">100</td>';
		$table.="<td style='width:10%'>{$total}</td>"; 
		$table.="</tr>";
		$percent = $total*0.5;
		$table.='<tr style = "font-weight: bold;">'; 
		$table.="<td style='width:10%;text-align:right;' colspan=2 >50% of total score will be considered</td>";		
		$table.="<td style='width:10%;font-weight: bold;'>{$percent}</td>";
		$table.="</tr>";
		$table.="</table><br>";
		
	}else if($postname == 'ASSOCIATE PROFESSOR' || $postname == 'PROFESSOR')
	{
		
		$academic = $ug+$phd+$jre+$net+$slet;
		$academicper = $academic*0.2;
		if($academicper > 47)
			$academicper = 47;
		
		if($cat2 >45)
			$cat2 = 45;
		
		$percent = $rchpoints*0.4;
		
		$rc = $rchpoints+$lecture+$projct+$guid; 	
		
		$total = $academicper+$rc+$cat2;
		
		$table = '<table class="table table-bordered" border-color:"black"; style="width:90%;" id="postdettable">';
		$table.='<tr>'; 								
		$table.='<td style="width:10%;font-weight:bold;text-align:center;background-color:lightblue;font-family:italic;font-size:120%;" colspan=3>SUMMARY OF POINTS</td>';
		$table.='</tr>';
		$table.='<tr>'; 								
		$table.='<td style="width:10%;font-weight: bold;font-family:italic;">Criteria</td>';
		$table.='<td style="width:10%;font-weight: bold;font-family:italic;">Maximum Points</td>';
		$table.='<td style="width:10%;font-weight: bold;font-family:italic;">Points Obtained</td>';
		$table.='</tr>'; 								
		$table.='<tr>';
		$table.="<td style='width:10%;font-family:italic;'>Academic Background (20%)</td>";		
		$table.="<td style='width:10%;font-weight: bold;'>47</td>";
		$table.="<td style='width:10%'>{$academic}({$academicper})</td>"; 
		$table.="</tr>";
		$table.='<tr>';
		$table.="<td style='width:10%;font-family:italic;'>Category II</td>";		
		$table.="<td style='width:10%;font-weight: bold;'>45</td>";
		$table.="<td style='width:10%'>{$cat2}</td>"; 
		$table.="</tr>";
		
		$table.='<tr>';
		$table.="<td style='width:10%;font-family:italic;'>Category III ( A+B+Ci+Cii+Ciii+Di+Dii+Ei+Eii+F) Minimum 300</td>";		
		$table.="<td style='width:10%;font-weight: bold;'>300</td>";
		$table.="<td style='width:10%'>{$rc}</td>"; 
		$table.="</tr>";
		/* $table.='<tr>'; 								
		$table.="<td style='width:10%;font-family:italic;'>Research Publications</td>";		
		$table.='<td style="width:10%;font-weight: bold;">33</td>';
		$table.="<td style='width:10%'>{$rchpoints}</td>"; 
		$table.="</tr>"; 
		
		$table.='<tr>'; 								
		$table.="<td style='width:10%;font-family:italic;'>Total</td>";		
		$table.='<td style="width:10%;font-weight: bold;">392</td>';
		$table.="<td style='width:10%'>{$total}</td>"; 
		$table.="</tr>";*/
		//$percent = $total*0.5;
		$table.='<tr style = "font-weight: bold;">'; 
		$table.="<td style='width:10%;text-align:right;' colspan=2 >Research performance based on API score and quality of publications(40%)</td>";		
		$table.="<td style='width:10%;font-weight: bold;'>{$percent}</td>";
		$table.="</tr>";
		$table.="</table><br>";
		
	}	
	$lan = $results['lang'];
	$lang = explode(',',$lan);
	$div3.= "<span>Language</span>";
	$div3.= "<span>Write</span>";
	$div3.= "<span>Read</span>";
	$div3.= "<span>Spoken</span>";
	foreach($lang as $value)
	{
		$lang = explode('->',$value);
		$div4.="<span>{$lang[0]}, </span>";
		$div1.="<span>{$lang[1]}, </span>";
		$div2.="<span>{$lang[2]}, </span>";
		$div5.="<span>{$lang[3]}, </span>";
	}
	if($results)
	{
		$table.='<table class="table table-bordered" style="width:90%;" id="postdettable">';
		$table.='<thead>';
		$table.='<th colspan=6 style="text-align:center;font-weight:bold;background-color:lightblue;font-family:italic;font-size:110%;">Personal Details</th> ';	
		$table.='</thead>';
		$table.='<tbody>';
		$table.='<tr>'; 								
		$table.='<td style="width:10%;font-weight: bold;font-family:italic;">Name</td>';
		$table.="<td style='width:10%'>{$results['fname']}</td>";		
		$table.='<td style="width:10%;font-weight: bold;;font-family:italic;">Date of Birth</td>';
		$table.="<td style='width:10%'>{$results['fdob']}</td>"; 
		$table.='<td style="width:10%;font-weight: bold;font-family:italic;">Age</td>';
		$table.="<td style='width:10%'>{$results['fage']}</td></tr>";
		$table.='<tr>'; 								
		$table.='<td style="width:10%;font-weight: bold;font-family:italic;">Place of Birth</td>';
		$table.="<td style='width:10%'>{$results['fbirthplace']}</td>";		
		$table.='<td style="width:10%;font-weight: bold;font-family:italic;"> Father`s Name</td>';
		$table.="<td style='width:10%'>{$results['ffatname']}</td>"; 
		$table.='<td style="width:10%;font-weight: bold;font-family:italic;"> Mother`s Name </td>';
		$table.="<td style='width:10%'>{$results['fmotname']}</td></tr>";
		$table.='<tr>'; 								
		$table.='<td style="width:10%;font-weight: bold;font-family:italic;">Religion</td>';
		$table.="<td style='width:10%'>{$results['freligion']}</td>";		
		$table.='<td style="width:10%;font-weight: bold;font-family:italic;"> Nationality</td>';
		$table.="<td style='width:10%'>{$results['fnational']}</td>"; 
		$table.='<td style="width:10%;font-weight: bold;font-family:italic;"> Gender</td>';
		$table.="<td style='width:10%'>{$results['fgender']}</td></tr>";		
		$table.='<tr>'; 								
		$table.='<td style="width:10%;font-weight: bold;">Category</td>';
		$table.="<td style='width:10%'>{$results['fcatcode']}</td>";		
		$table.='<td style="width:10%;font-weight: bold;"> Marital Status </td>';
		$table.="<td style='width:10%'>{$results['fmarstatus']}</td>"; 
		$table.='<td style="width:10%;font-weight: bold;">Aadhar No.</td>';
		$table.="<td style='width:10%'>{$results['faadhar']}</td></tr>";
		
		$comadd = $results['fcomadd1'].' '.$results['fcomadd2'].''.$results['fcomadd3'].''.$results['fcomadd4'];
		$peradd = $results['fperadd1'].' '.$results['fperadd2'].''.$results['fperadd3'].''.$results['fperadd4'];
		$table.='<tr>'; 								
		$table.='<td style="width:10%;font-weight: bold;">Address for Correspondence</td>';
		$table.="<td style='width:10%'>{$comadd}</td>";		
		$table.='<td style="width:10%;font-weight: bold;">Address for Correspondence</td>';
		$table.="<td style='width:10%'>{$peradd}</td>";		
		
		$table.='<td style="width:10%;font-weight: bold;"> Marital Status </td>';
		$table.="<td style='width:10%'>{$results['fmarstatus']}</td>"; 
		$table.="</tr>";
		$table.='<td style="width:10%;font-weight: bold;"> If physically challenged,indicate relevant particulars</td>';
		$table.="<td style='width:10%'>{$results['fphtype']}</td>";								
		$table.='<td style="width:10%;font-weight: bold;">Email</td>';
		$table.="<td style='width:10%'>{$results['femailid']}</td>";		
		$table.='<td style="width:10%;font-weight: bold;">Phone No. </td>';
		$table.="<td style='width:10%'>{$results['fphone']}</td></tr>";
		$table.="</tr>";
		$table.='<td style="width:10%;font-weight: bold;">Mobile No.</td>';
		$table.="<td style='width:10%'>{$results['fmobile']}</td>";								
		$table.='<td style="width:10%;font-weight: bold;" >Languages Known</td>';
		$table.="<td style='width:10%' colspan=3><div><b>{$div3}</b></div><div>{$div4}</div><div>{$div1}</div><div>{$div2}</div><div>{$div5}</div> </td></tr></tbody></table><br>";
		
		$table.='<table class="table table-bordered" style="width:90%;" id="postdettable">';
		$table.='<thead>';
		$table.='<th colspan=8 style="text-align:center;background-color:lightblue;font-family:italic;font-size:110%;">Educational details</th>';	
		$table.='</thead>';
		$table.='<tbody>';
		$table.='<tr>'; 								
		$table.='<td style="width:10%;font-weight: bold;">Degree</td>';
		$table.="<td style='width:10%'>Name of the Board / University</td>";		
		$table.='<td style="width:10%;font-weight: ;">Year</td>';
		$table.="<td style='width:10%'>Max. Marks</td>"; 
		$table.='<td style="width:10%;font-weight: ;">Sec. Marks</td>';
		$table.="<td style='width:10%'>Percentage / CGPA</td>";
		$table.='<td style="width:10%;font-weight: ;">Division</td>';
		$table.='<td style="width:10%;font-weight: ;">Subject studied</td>';
		$table.='</tr>';
			
		
		$query2 = "select * from qualdetl where fuserid = '{$userid}' order by fenttype";
		$results2  = $aobj_context->mobj_db->GetAll($query2);
		
		foreach($results2 as $value)
		{
			$table.='<tr>'; 								
			$table.="<td style='width:10%;font-weight: bold;'>{$value[fdegree]}</td>";
			$table.="<td style='width:10%'>{$value[funivname]}</td>";		
			$table.="<td style='width:10%;font-weight: ;'>{$value[fyear]}</td>";
			$table.="<td style='width:10%'>{$value[fsecmarks]}</td>"; 
			$table.="<td style='width:10%;font-weight: ;'>{$value[fmaxmarks]}</td>";
			$table.="<td style='width:10%'>{$value[fpercentage]}</td>";
			$table.="<td style='width:10%;font-weight: ;'>{$value[fdivision]}</td>";
			$table.="<td style='width:10%;font-weight: ;'>{$value[fsubjects]}</td>";
			$table.='</tr>';
		}
		$table.='</table><br>';
		
		$table.='<table class="table table-bordered" style="width:90%;" id="postdettable">';
		$table.='<tr>';
		$table.="<td style='width:10%;font-weight: bold;'>Degree</td>";
		$table.="<td style='width:10%;font-weight: bold;'>Date of Registration / Admission</td>";
		$table.="<td style='width:10%;font-weight: bold;'>Date of Submission</td>";
		$table.="<td style='width:10%;font-weight: bold;'>Date of Award</td>";
		$table.="<td style='width:10%;font-weight: bold;'>University / Institute</td>";
		$table.="<td style='width:10%;font-weight: bold;'>Thesis / DissertationTitle</td>";
		$table.="<td style='width:10%;font-weight: bold;'>Overall % / GP(Out of 10)</td>";
		$table.='</tr>';
		
		foreach($results3 as $value)
		{
			$table.='<tr>';
			$table.="<td style='width:10%;font-weight: bold;'>{$value[fdegree]}</td>";
			$table.="<td style='width:10%;font-weight: ;'>{$value[fdor]}</td>";
			$table.="<td style='width:10%;font-weight: ;'>{$value[fdos]}</td>";
			$table.="<td style='width:10%;font-weight: ;'>{$value[fdoa]}</td>";
			$table.="<td style='width:10%;font-weight: ;'>{$value[funivname]}</td>";
			$table.="<td style='width:10%;font-weight: ;'>{$value[ftitle]}</td>";
			$table.="<td style='width:10%;font-weight: ;'>{$value[fpercent]}</td>";
			$table.='</tr>';
		}
		$table.="</table>";
		$table.='<table class="table table-bordered" style="width:90%;" id="postdettable">';
		$table.='<tr>';
		$table.="<td style='width:10%;font-weight: bold;'>Details of JRF /NET / SLET</td>";
		$table.="<td style='width:10%;font-weight: bold;'>NET Subject</td>";
		$table.="<td style='width:10%;font-weight: bold;'>Certificate No. / Roll No.</td>";
		$table.="<td style='width:10%;font-weight: bold;'>Year of Passing</td>";
		$table.='</tr>';
		$table.='<tr>';
		$table.="<td style='width:10%;font-weight: bold;'>NET - JRF</td>";
		$table.="<td style='width:10%;font-weight: ;'>{$results[fjrfsub]}</td>";
		$table.="<td style='width:10%;font-weight: ;'>{$results[fjrfcertno]}</td>";
		$table.="<td style='width:10%;font-weight: ;'>{$results[fjrfpassmth]}</td>";
		$table.='</tr>';
		$table.='<tr>';
		$table.="<td style='width:10%;font-weight: bold;'>NET</td>";
		$table.="<td style='width:10%;font-weight: ;'>{$results[fnetsub]}</td>";
		$table.="<td style='width:10%;font-weight: ;'>{$results[fnetcertno]}</td>";
		$table.="<td style='width:10%;font-weight: ;'>{$results[fnetpassmth]}</td>";
		$table.='</tr>';
		$table.='<tr>';
		$table.="<td style='width:10%;font-weight: bold;'>SELET</td>";
		$table.="<td style='width:10%;font-weight: ;'>{$results[fsletsub]}</td>";
		$table.="<td style='width:10%;font-weight: ;'>{$results[fsletcertno]}</td>";
		$table.="<td style='width:10%;font-weight: ;'>{$results[fsletpassmth]}</td>";
		$table.='</tr>';
		$table.="</table><br>";
		
		$query4 = "select * from expdetl where fuserid = '{$userid}' and fappno = '{$appno}' and fenttype = 'teach' order by fenttype";
		$results4  = $aobj_context->mobj_db->GetAll($query4);
		
		
		$table.='<table class="table table-bordered" style="width:90%;" id="postdettable">';
		$table.='<thead>';
		$table.='<th colspan = 9 style = "text-align:center;background-color:lightblue;font-family:italic;font-size=110%;">3.1 Full-time Teaching Experience</th> ';	
		$table.='</thead>';
		$table.='<tbody>';
		$table.='<tr>'; 								
		$table.='<td style="width:10%;font-weight: ;">Name of University / College / Institute / Organization</td>';
		$table.="<td style='width:10%'>Designation</td>";		
		$table.='<td style="width:10%;font-weight: ;">Status</td>';
		$table.="<td style='width:10%'>Pay Scale / Consolidated salary</td>"; 
		$table.='<td style="width:10%;font-weight: ;">From</td>';
		$table.="<td style='width:10%'>To</td>";
		$table.='<td style="width:10%;font-weight: ;">Effective Time Period (Excluding 2 years of Residency Period)</td>';
		$table.='<td style="width:10%;font-weight: ;">Points</td>';
		$table.='<td style="width:10%;font-weight: ;">Enclosure No.</td>';
		$table.='</tr>';
		
		$sumexpfpoints = '';
		$fexp = '';
		foreach($results4 as $value)
		{
			$table.='<tr>'; 								
			$table.="<td style='width:10%'>{$value[funivname]}</td>";		
			$table.="<td style='width:10%;font-weight: ;'>{$value[fdegncode]}</td>";
			$table.="<td style='width:10%'>{$value[fstatus]}</td>"; 
			$table.="<td style='width:10%;font-weight: ;'>{$value[fpayscale]}</td>";
			$table.="<td style='width:10%'>{$value[ffromdate]}</td>";
			$table.="<td style='width:10%'>{$value[ftodate]}</td>";
			$table.="<td style='width:10%;font-weight: ;'>{$value[fexp]}</td>";
			$table.="<td style='width:10%;font-weight: ;'>{$value[fpoints]}</td>";
			$table.="<td style='width:10%;font-weight: ;'>{$value[fenclosureno]}</td>";
			$table.='</tr>';
			$sumexpfpoints+=$value[fpoints];
			$fexp+=$value[fexp];
		}

$table.='<tr style = "font-weight: bold;">'; 								
		$table.="<td style='width:10%;text-align:right;' colspan = 6>Total</td>";		
		$table.="<td style='width:10%;font-weight: ;'>{$fexp}</td>";
		$table.="<td style='width:10%' >{$sumexpfpoints}</td><tr>";
		$table.='</table><br>';
		$query4 = "select * from expdetl where fuserid = '{$userid}' and fappno = '{$appno}' and fenttype = 'phd' order by fenttype";
		$results4  = $aobj_context->mobj_db->GetAll($query4);
		
		
		$table.='<table class="table table-bordered" style="width:90%;" id="postdettable">';
		$table.='<thead>';
		$table.='<th colspan = 8 style = "text-align:center;background-color:lightblue;font-family:italic;font-size:110%;">3.2 Full-time Post-Ph.D. Research Experience</th> ';	
		$table.='</thead>';
		$table.='<tbody>';
		$table.='<tr>'; 								
		$table.='<td style="width:10%;font-weight: ;">University / Institute / Industry</td>';
		$table.="<td style='width:10%'>Designation</td>";		
		$table.='<td style="width:10%;font-weight: ;">Pay scale / consolidated salary</td>';
		$table.='<td style="width:10%;font-weight: ;">From</td>';
		$table.="<td style='width:10%'>To</td>";
		$table.='<td style="width:10%;font-weight: ;">Time Period</td>';
		$table.='<td style="width:10%;font-weight: ;">Points</td>';
		$table.='<td style="width:10%;font-weight: ;">Enclosure No.</td>';
		$table.='</tr>';
		$sumexpfpoints = '';
		$fexp = '';
		foreach($results4 as $value)
		{
			$table.='<tr>'; 								
			$table.="<td style='width:10%'>{$value[funivname]}</td>";		
			$table.="<td style='width:10%;font-weight: ;'>{$value[fdegncode]}</td>"; 
			$table.="<td style='width:10%;font-weight: ;'>{$value[fpayscale]}</td>";
			$table.="<td style='width:10%'>{$value[ffromdate]}</td>";
			$table.="<td style='width:10%'>{$value[ftodate]}</td>";
			$table.="<td style='width:10%;font-weight: ;'>{$value[fexp]}</td>";
			$table.="<td style='width:10%;font-weight: ;'>{$value[fpoints]}</td>";
			$table.="<td style='width:10%;font-weight: ;'>{$value[fenclosureno]}</td>";
			$table.='</tr>';
			$sumexpfpoints+=$value[fpoints];
			$fexp+=$value[fexp];
		}
		$table.='<tr style = "font-weight: bold;">'; 								
		$table.="<td style='width:10%;text-align:right;' colspan = 5>Total</td>";		
		$table.="<td style='width:10%;font-weight: ;'>{$fexp}</td>";
		$table.="<td style='width:10%'>{$sumexpfpoints}</td><tr>";
		$table.='</table><br>';
		
		$query4 = "select * from expdetl where fuserid = '{$userid}' and fappno='{$appno}' and fenttype='present' order by fenttype";
		$results4  = $aobj_context->mobj_db->GetAll($query4);
		
		$table.='<table class="table table-bordered" style="width:90%;" id="postdettable">';
		$table.='<thead>';
		$table.='<th colspan=8 style="text-align:center background-color:lightblue;font-family:italic;font-size:110%;">3.3 Present Employment Details</th> ';	
		$table.='</thead>';
		$table.='<tbody>';
		$table.='<tr>'; 								
		$table.='<td style="width:10%;font-weight: ;">Organization Name</td>';
		$table.="<td style='width:10%'>Position Held</td>";		
		$table.='<td style="width:10%;font-weight: ;">Date of Appointment</td>';
		$table.='<td style="width:10%;font-weight: ;">Present Status</td>';
		$table.='</tr>';
		
		foreach($results4 as $value)
		{
			$table.='<tr>'; 								
			$table.="<td style='width:10%'>{$value[funivname]}</td>";		
			$table.="<td style='width:10%;font-weight: ;'>{$value[fdegncode]}</td>"; 
			$table.="<td style='width:10%'>{$value[ffromdate]}</td>";
			$table.="<td style='width:10%;font-weight: ;'>{$value[fstatus]}</td>";
			$table.='</tr>';
		}
		$table.='</table><br>';
		
		
		
		$query4 = "select fenttype,fslno,fpublication,r1.freasonname as fpublicationname, ftitle,fjournalname,fyear,
				fvolno,fpageno,fissnno,frefereed,r2.freasonname as ffauthorname, fauthor,fpoints,fimpfact,fjournalno,fenclosureno,fautaddrs
				from researchexp 
				left join reason r1 on researchexp.fpublication = r1.freasoncode
				left join reason r2 on researchexp.fauthor = r2.freasoncode
				where fuserid = '{$userid}' and fappno = '{$appno}' order by fenttype desc";
		$results4  = $aobj_context->mobj_db->getAll($query4);
		
		$table.='<table class="table table-bordered" style="width:90%;" id="postdettable">';
		$table.='<thead>';
		$table.='<th colspan=12 style="text-align:center;background-color:lightblue;font-family:italic;font-size:110%;">III (A-1) Research Papers Published (Listed in UGC website)</th> ';	
		$table.='</thead>';
		$table.='<tbody>';
		$table.='<tr>'; 								
		$table.='<td style="width:10%;font-weight: ;">Publication Type</td>';
		$table.="<td style='width:10%'>Title of the Paper</td>";		
		$table.='<td style="width:10%;font-weight: ;">Journal Name</td>';
		$table.='<td style="width:10%;font-weight: ;">Year</td>';
		$table.="<td style='width:10%'>Vol. No.</td>";
		$table.='<td style="width:10%;font-weight: ;">Page No.</td>';
		$table.='<td style="width:10%;font-weight: ;">ISSN / ISBN No.</td>';
		$table.='<td style="width:10%;font-weight: ;">Journal No. Given By UGC</td>'; 
		$table.='<td style="width:10%;font-weight: ;">Author</td>';
		$table.='<td style="width:10%;font-weight: ;">Impact Factors</td>';
		$table.='<td style="width:10%;font-weight: ;">Points</td>'; 
		$table.='<td style="width:10%;font-weight: ;">Enclosure No.</td>';
		$table.='</tr>';
		$first = true;
		$second = true;
		$otjpoints = '';
		$phdpoints = '';
		foreach($results4 as $value)
		{
			if($value[fenttype] == 'rcphd')
			{
				$table.='<tr>'; 								
				$table.="<td style='width:10%'>{$value[fpublicationname]}</td>";		
				$table.="<td style='width:10%;font-weight: ;'>{$value[ftitle]}</td>"; 
				$table.="<td style='width:10%;font-weight: ;'>{$value[fjournalname]}</td>";
				$table.="<td style='width:10%'>{$value[fyear]}</td>";
				$table.="<td style='width:10%'>{$value[fvolno]}</td>";
				$table.="<td style='width:10%'>{$value[fpageno]}</td>"; 
				$table.="<td style='width:10%;font-weight: ;'>{$value[fissnno]}</td>";
				$table.="<td style='width:10%;font-weight: ;'>{$value[fjournalno]}</td>";
				$table.="<td style='width:10%;font-weight: ;'>{$value[ffauthorname]}</td>";
				$table.="<td style='width:10%;font-weight: ;'>{$value[fimpfact]}</td>";
				$table.="<td style='width:10%;font-weight: ;'>{$value[fpoints]}</td>";
				$table.="<td style='width:10%;font-weight: ;'>{$value[fenclosureno]}</td>";
				$table.='</tr>';
				$phdpoints+=$value[fpoints];
			}
			else if($value[fenttype] == 'rcoth')
			{
				if($first)
				{
					$table.="<tr style = 'font-weight: bold;'><td style='width:10%;text-align:right;' colspan = 8>Total</td><td style='width:10%;font-weight: ;'>{$otjpoints}</td></tr><table class='table table-bordered' style='width:90%;' id='postdettable'>";
					$table.='<thead>';
					$table.='<th colspan=10 style="text-align:center;background-color:lightblue;font-family:italic;font-size:110%;">III (A-2) Research Papers Published (Not Listed in UGC website)</th> ';	
					$table.='</thead>';
					$table.='<tbody>';
					$table.='<tr>'; 								
					$table.='<td style="width:10%;font-weight: ;">Publication Type</td>';
					$table.="<td style='width:10%'>Title of the Paper</td>";		
					$table.='<td style="width:10%;font-weight: ;">Journal Name</td>';
					$table.='<td style="width:10%;font-weight: ;">Year</td>';
					$table.="<td style='width:10%'>Vol. No.</td>";
					$table.='<td style="width:10%;font-weight: ;">Page No.</td>';
					$table.='<td style="width:10%;font-weight: ;">ISSN / ISBN No.</td>';
					$table.='<td style="width:10%;font-weight: ;">Author</td>';
					$table.='<td style="width:10%;font-weight: ;">Enclosure No.</td>';
					$table.='</tr>';
					$first = false;
				}
				$table.='<tr>'; 								
				$table.="<td style='width:10%'>{$value[fpublicationname]}</td>";		
				$table.="<td style='width:10%;font-weight: ;'>{$value[ftitle]}</td>"; 
				$table.="<td style='width:10%;font-weight: ;'>{$value[fjournalname]}</td>";
				$table.="<td style='width:10%'>{$value[fyear]}</td>";
				$table.="<td style='width:10%'>{$value[fvolno]}</td>";
				$table.="<td style='width:10%'>{$value[fpageno]}</td>"; 
				$table.="<td style='width:10%;font-weight: ;'>{$value[fissnno]}</td>";
				$table.="<td style='width:10%;font-weight: ;'>{$value[ffauthorname]}</td>";
				$table.="<td style='width:10%;font-weight: ;'>{$value[fenclosureno]}</td>";
				$table.='</tr>';
								
				
			}else if($value[fenttype] == 'rcotj')
			{
				if($second)
				{
					$table.="<tr style = 'font-weight: bold;'><td style='width:10%;text-align:right;' colspan = 10>Total</td><td style='width:10%;font-weight: ;'>{$phdpoints}</td></tr><table class='table table-bordered' style='width:90%;' id='postdettable'>";
					$table.='<thead>';
					$table.='<th colspan = 10 style = "text-align:center;background-color:lightblue;font-family:italic;font-size110%;">III (B) Publications Other than journal articles (books, chapters in books)</th> ';	
					$table.='</thead>';
					$table.='<tbody>';
					$table.='<tr>'; 								
					$table.='<td style="width:10%;font-weight: ;">Publication Type</td>';
					$table.="<td style='width:10%'>Title of the Book</td>";		
					$table.='<td style="width:10%;font-weight: ;">Title of the Paper</td>';
					$table.='<td style="width:10%;font-weight: ;">Year</td>';
					$table.="<td style='width:10%'>Page No.</td>";
					$table.='<td style="width:10%;font-weight: ;">ISSN/ ISBN No.</td>';
					$table.='<td style="width:10%;font-weight: ;">Publisher Details & Address</td>';
					$table.='<td style="width:10%;font-weight: ;">Author</td>';
					$table.='<td style="width:10%;font-weight: ;">Points</td>';
					$table.='<td style="width:10%;font-weight: ;">Enclosure No.</td>';
					$table.='</tr>';
					$second = false;
				}
				$table.='<tr>'; 								
				$table.="<td style='width:10%'>{$value[fpublicationname]}</td>";		
				$table.="<td style='width:10%;font-weight: ;'>{$value[ftitle]}</td>"; 
				$table.="<td style='width:10%;font-weight: ;'>{$value[fjournalname]}</td>";
				$table.="<td style='width:10%'>{$value[fyear]}</td>";
				$table.="<td style='width:10%'>{$value[fpageno]}</td>";
				$table.="<td style='width:10%'>{$value[fissnno]}</td>"; 
				$table.="<td style='width:10%;font-weight: ;'>{$value[fautaddrs]}</td>";
				$table.="<td style='width:10%;font-weight: ;'>{$value[ffauthorname]}</td>";
				$table.="<td style='width:10%;font-weight: ;'>{$value[fpoints]}</td>";
				$table.="<td style='width:10%;font-weight: ;'>{$value[fenclosureno]}</td>";
				$table.='</tr>';
				$otjpoints+=$value[fpoints];				
				
			}
		}
		$table.='</table><br>';
		
		$query1 = "SELECT * FROM tleact 
			where fuserid = '{$userid}' and fappno = '{$appno}' order by fenttype,factivity";
		$result = $aobj_context->mobj_db->GetAll($query1);
		$cat11 ="a. Direct Teaching (Actual Hours Spent ÷ 7.75)*";
		$cat12 ="b. Contribution to corporate life and management of the department and institution through participation in academic and administrative committees and responsibilities.<br>
		<li>Administrative responsibility (including as Dean/ Principal /Chairperson/Convener/Teacher-in-charge/similar other duties that require regular office hrs for its discharge).</li>
		<li>Participation in Board of Studies, Academic and Administrative Committees</li>";
		$cat13 ="c. Professional Development activities (such as participation in seminars, conferences, short term training courses, industrial experience, talks, lectures in refresher / faculty development courses, dissemination and general articles and any other contribution)";
		
		
		$cat21 ="a. Student related co-curricular, extension and field based activities.<br>
	<li>Discipline related co-curricular activities (e.g. remedial classes, career counselling, study visit, student seminar and other events).<li>
	<li>Other co-curricular activities (Cultural, Sports, NSS, NCC etc).<br></li>
	<li>Extension and dissemination activities (public /popular lectures/talks/seminars etc.)</li>";
		$cat22 ="b.Examination duties (question paper setting, Invigilation, evaluation of answer scripts) as per allotment(Actual Hours Spent ÷ 10)";
		$cat23 ="c.Innovative Teaching - learning methodologies, updating of subject contents/courses, mentoring etc.(Actual Hours Spent ÷ 10)";
		
		
		$table.='<table class="table table-bordered" style="width:90%;" id="postdettable">';
		$table.='<thead>';
		$table.='<th colspan = 7 style = "text-align:center;background-color:lightblue;font-family:italic;font-size:110%;">CATEGORY I - TEACHING, LEARNING AND EVALUATION RELATED ACTIVITIES</th> ';	
		$table.='</thead>';
		$table.='<tbody>';
		$table.='<tr>';
		$table.='<td>Nature of Activity</td>';	
		$table.='<td>Max. Score</td>';
		$table.='<td></td>';		
		$table.='<td>Self Score</td>';
		$table.='</tr>';
		$first=true;
		foreach($result as $value)
		{
			if($value['fenttype'] == 'cat1')
			{	
				if($value['factivity'] == 'a')
				{
					$table.='<tr>';
					$table.="<td style='width:40%;font-weight: ;'>{$cat11}</td>";
					$table.="<td style='width:10%;font-weight: ;'>{$value[fmaxscore]}</td>";
					$table.="<td style='width:10%;font-weight: ;'>{$value[fspent]}</td>";
					$table.="<td style='width:10%;font-weight: ;'>{$value[fselfscore]}</td>";
					$table.='</tr>';
				}
				if($value['factivity'] == 'b')
				{
					$table.='<tr>';
					$table.="<td style='width:40%;font-weight: ;'>{$cat12}</td>";
					$table.="<td style='width:10%;font-weight: ;'>{$value[fmaxscore]}</td>";
					$table.="<td style='width:10%;font-weight: ;'>{$value[fspent]}</td>";
					$table.="<td style='width:10%;font-weight: ;'>{$value[fselfscore]}</td>";
					$table.='</tr>';
				}
				if($value['factivity'] == 'c')
				{
					$table.='<tr>';
					$table.="<td style='width:40%;font-weight: ;'>{$cat13}</td>";
					$table.="<td style='width:10%;font-weight: ;'>{$value[fmaxscore]}</td>";
					$table.="<td style='width:10%;font-weight: ;'>{$value[fspent]}</td>";
					$table.="<td style='width:10%;font-weight: ;'>{$value[fselfscore]}</td>";
					$table.='</tr>';
				}
				
			}
			if($value['fenttype'] == 'cat2')
			{
				if($first)
				{
					$table.='</table><br><table class="table table-bordered" style="width:90%;" id="postdettable">';
					$table.='<thead>';
					$table.='<th colspan = 7 style = "text-align:center;background-color:lightblue;font-family:italic;font-size:110%;">CATEGORY II - PROFESSIONAL DEVELOPMENT,CO-CURRICULAR AND EXTENSION ACTIVITIES</th> ';	
					$table.='</thead>';
					$table.='<tbody>';
					$table.='<tr>';
					$table.='<td>Nature of Activity</td>';	
					$table.='<td>Max. Score</td>';
					$table.='<td>Actual Hours Spent ÷ 10</td>';		
					$table.='<td>Self Score</td>';
					$table.='</tr>';
					
					$first=false;
				}	
				if($value['factivity'] == 'a')
				{
					$table.='<tr>';
					$table.="<td style='width:50%;font-weight: ;'>{$cat21}</td>";
					$table.="<td style='width:10%;font-weight: ;'>{$value[fmaxscore]}</td>";
					$table.="<td style='width:10%;font-weight: ;'>{$value[fspent]}</td>";
					$table.="<td style='width:10%;font-weight: ;'>{$value[fselfscore]}</td>";
					$table.='</tr>';
				}
				if($value['factivity'] == 'b')
				{
					$table.='<tr>';
					$table.="<td style='width:50%;font-weight: ;'>{$cat22}</td>";
					$table.="<td style='width:10%;font-weight: ;'>{$value[fmaxscore]}</td>";
					$table.="<td style='width:10%;font-weight: ;'>{$value[fspent]}</td>";
					$table.="<td style='width:10%;font-weight: ;'>{$value[fselfscore]}</td>";
					$table.='</tr>';
				}
				if($value['factivity'] == 'c')
				{
					$table.='<tr>';
					$table.="<td style='width:50%;font-weight: ;'>{$cat23}</td>";
					$table.="<td style='width:10%;font-weight: ;'>{$value[fmaxscore]}</td>";
					$table.="<td style='width:10%;font-weight: ;'>{$value[fspent]}</td>";
					$table.="<td style='width:10%;font-weight: ;'>{$value[fselfscore]}</td>";
					$table.='</tr>';
				}
				
			}	
		}
		
		$table.='</table><br>';
		
		
		$query4 = "	select fslno,ffaculty,r1.freasonname as ffacultyname, ftitle,fagency,fperiod,famount,fpoints,fenclosureno,fenttype
					from rcprojct 
					left join reason r1 on rcprojct.ffaculty = r1.freasoncode
					where fuserid = '{$userid}' and fappno = '{$appno}' and fenttype = 'rcspon'";
		$results4  = $aobj_context->mobj_db->GetAll($query4);
		
		$table.='<table class="table table-bordered" style="width:90%;" id="postdettable">';
		$table.='<thead>';
		$table.='<th colspan = 7 style = "text-align:center;background-color:lightblue;font-family:italic;font-size:110%;">III (C) i. Sponsered projects</th> ';	
		$table.='</thead>';
		$table.='<tbody>';
		$table.='<tr>'; 								
		$table.='<td style="width:10%;font-weight: ;">Faculty</td>';
		$table.="<td style='width:10%'>Title of the Project</td>";		
		$table.='<td style="width:10%;font-weight: ;">Funding Agency / Agency</td>';
		$table.='<td style="width:10%;font-weight: ;">Period</td>';
		$table.="<td style='width:10%'>Amount</td>";
		$table.='<td style="width:10%;font-weight: ;">Points</td>';
		$table.='<td style="width:10%;font-weight: ;">Enclosure No.</td>';
		$table.='</tr>';
		$sumexpfpoints = '';
		$fexp = '';
		foreach($results4 as $value)
		{
			$table.='<tr>'; 								
			$table.="<td style='width:10%'>{$value[ffacultyname]}</td>";		
			$table.="<td style='width:10%;font-weight: ;'>{$value[ftitle]}</td>"; 
			$table.="<td style='width:10%;font-weight: ;'>{$value[fagency]}</td>";
			$table.="<td style='width:10%'>{$value[fperiod]}</td>";
			$table.="<td style='width:10%'>{$value[famount]}</td>";
			$table.="<td style='width:10%;font-weight: ;'>{$value[fpoints]}</td>";
			$table.="<td style='width:10%;font-weight: ;'>{$value[fenclosureno]}</td>";
			$table.='</tr>';
			$sumexpfpoints+=$value[fpoints];
		}
		$table.='<tr style = "font-weight: bold;">'; 								
		$table.="<td style='width:10%;text-align:right;' colspan = 5>Total</td>";		
		$table.="<td style='width:10%;font-weight: ;'>{$sumexpfpoints}</td>";
		$table.='</table><br>';
		
		$query4 = "select fslno,ffaculty,r1.freasonname as ffacultyname, ftitle,fagency,fperiod,famount,fpoints,fenclosureno,fenttype
		from rcprojct 
		left join reason r1 on rcprojct.ffaculty = r1.freasoncode
		where fuserid = '{$userid}' and fappno = '{$appno}' and fenttype = 'rccons'";
		$results4  = $aobj_context->mobj_db->GetAll($query4);
		
		$table.='<table class="table table-bordered" style="width:90%;" id="postdettable">';
		$table.='<thead>';
		$table.='<th colspan = 7 style = "text-align:center;background-color:lightblue;font-family:italic;font-size:110%;">III (C) ii. Consultancy projects</th> ';	
		$table.='</thead>';
		$table.='<tbody>';
		$table.='<tr>'; 								
		$table.='<td style="width:10%;font-weight: ;">Faculty</td>';
		$table.="<td style='width:10%'>Title of the Project</td>";		
		$table.='<td style="width:10%;font-weight: ;">Funding Agency / Agency</td>';
		$table.='<td style="width:10%;font-weight: ;">Period</td>';
		$table.="<td style='width:10%'>Amount</td>";
		$table.='<td style="width:10%;font-weight: ;">Points</td>';
		$table.='<td style="width:10%;font-weight: ;">Enclosure No.</td>';
		$table.='</tr>';
		$sumexpfpoints = '';
		$fexp = '';
		foreach($results4 as $value)
		{
			$table.='<tr>'; 								
			$table.="<td style='width:10%'>{$value[ffacultyname]}</td>";		
			$table.="<td style='width:10%;font-weight: ;'>{$value[ftitle]}</td>"; 
			$table.="<td style='width:10%;font-weight: ;'>{$value[fagency]}</td>";
			$table.="<td style='width:10%'>{$value[fperiod]}</td>";
			$table.="<td style='width:10%'>{$value[famount]}</td>";
			$table.="<td style='width:10%;font-weight: ;'>{$value[fpoints]}</td>";
			$table.="<td style='width:10%;font-weight: ;'>{$value[fenclosureno]}</td>";
			$table.='</tr>';
			$sumexpfpoints+=$value[fpoints];
		}
		$table.='<tr style = "font-weight: bold;">'; 								
		$table.="<td style='width:10%;text-align:right;' colspan = 5>Total</td>";		
		$table.="<td style='width:10%;font-weight: ;'>{$sumexpfpoints}</td>";
		$table.='</table><br>';
		
		
		$query4 = "select fslno,ffaculty,r1.freasonname as flevelname, flevel,ftitle,fagency,fperiod,famount,fpoints,fenclosureno,fenttype
				from rcprojct 
				left join reason r1 on rcprojct.flevel = r1.freasoncode
				where fuserid = '{$userid}' and fappno = '{$appno}' and fenttype = 'rcpout'";
		$results4  = $aobj_context->mobj_db->GetAll($query4);
		$table.='<table class="table table-bordered" style="width:90%;" id="postdettable">';
		$table.='<thead>';
		$table.='<th colspan = 6 style = "text-align:center;background-color:lightblue;font-family:italic;font-size:110%;">III (C) iii. Projects Outcome / Outputs</th> ';	
		$table.='</thead>';
		$table.='<tbody>';
		$table.='<tr>'; 								
		$table.='<td style="width:10%;font-weight: ;">Policy Document</td>';
		$table.="<td style='width:10%'>Title of the Outcomes</td>";		
		$table.='<td style="width:10%;font-weight: ;">Funding Agency / Agency</td>';
		$table.='<td style="width:10%;font-weight: ;">Level</td>';
		$table.="<td style='width:10%'>Points</td>";
		$table.='<td style="width:10%;font-weight: ;">Enclosure No.</td>';
		$table.='</tr>';
		$sumexpfpoints = '';
		$fexp = '';
		foreach($results4 as $value)
		{
			$table.='<tr>'; 								
			$table.="<td style='width:10%'>{$value[ffacultyname]}</td>";		
			$table.="<td style='width:10%;font-weight: ;'>{$value[ftitle]}</td>"; 
			$table.="<td style='width:10%;font-weight: ;'>{$value[fagency]}</td>";
			$table.="<td style='width:10%'>{$value[flevelname]}</td>";
			$table.="<td style='width:10%;font-weight: ;'>{$value[fpoints]}</td>";
			$table.="<td style='width:10%;font-weight: ;'>{$value[fenclosureno]}</td>";
			$table.='</tr>';
			$sumexpfpoints+=$value[fpoints];
		}
		$table.='<tr style = "font-weight: bold;">'; 								
		$table.="<td style='width:10%;text-align:right;' colspan = 4>Total</td>";		
		$table.="<td style='width:10%;font-weight: ;'>{$sumexpfpoints}</td>";
		$table.='</table><br>';
		
		$query = "select fslno,fuserid,fappno,fnostud,fpoints,fenclosureno,fenttype
				from rechguid 
				where fuserid = '{$userid}' and fappno = '{$appno}' and fenttype = 'rcgm'";
		$results  = $aobj_context->mobj_db->getAll($query);
		
		$table.='<table class="table table-bordered" style="width:90%;" id="postdettable">';
		$table.='<thead>';
		$table.='<th colspan = 3 style = "text-align:center;background-color:lightblue;font-family:italic;font-size:110%;">III (D) i. Research Guidance - M.Phil.</th> ';	
		$table.='</thead>';
		$table.='<tbody>';
		$table.='<tr>'; 								
		$table.='<td style="width:10%;font-weight: ;">No. of students</td>';
		$table.="<td style='width:10%'>Points</td>";		
		$table.='<td style="width:10%;font-weight: ;">Enclosure No.</td>';
		$table.='</tr>';
		$sumexpfpoints = '';
		$fexp = '';
		foreach($results4 as $value)
		{
			$table.='<tr>'; 								
			$table.="<td style='width:10%'>{$value[fnostud]}</td>";		
			$table.="<td style='width:10%;font-weight: ;'>{$value[fpoints]}</td>";
			$table.="<td style='width:10%;font-weight: ;'>{$value[fenclosureno]}</td>";
			$table.='</tr>';
			$sumexpfpoints+=$value[fpoints];
		}
		$table.='<tr style = "font-weight: bold;">'; 								
		$table.="<td style='width:10%;text-align:right;' colspan = 1>Total</td>";		
		$table.="<td style='width:10%;font-weight: ;'>{$sumexpfpoints}</td>";
		$table.='</table><br>';
		
		$query = "select fslno,fuserid,fappno,fnostud,fpoints,fenclosureno,fenttype,fawareded,r1.freasonname as fawarededname
		from rechguid
		left join reason r1 on rechguid.fawareded = r1.freasoncode	
		where fuserid = '{$userid}' and fappno = '{$appno}' and fenttype = 'rcgp'";
		$results  = $aobj_context->mobj_db->getAll($query);
		
		$table.='<table class="table table-bordered" style="width:90%;" id="postdettable">';
		$table.='<thead>';
		$table.='<th colspan = 4 style = "text-align:center;background-color:lightblue;font-family:italic;font-size:110%;">III (D) ii. Research Guidance - Ph.D</th> ';	
		$table.='</thead>';
		$table.='<tbody>';
		$table.='<tr>'; 								
		$table.='<td style="width:10%;font-weight: ;">Awareded / Submitted</td>';
		$table.="<td style='width:10%'>No of students</td>";
		$table.="<td style='width:10%'>Points</td>";		
		$table.='<td style="width:10%;font-weight: ;">Enclosure No.</td>';
		$table.='</tr>';
		$sumexpfpoints = '';
		$fexp = '';
		foreach($results4 as $value)
		{
			$table.='<tr>'; 								
			$table.="<td style='width:10%'>{$value[fawarededname]}</td>";
			$table.="<td style='width:10%'>{$value[fnostud]}</td>";		
			$table.="<td style='width:10%;font-weight: ;'>{$value[fpoints]}</td>";
			$table.="<td style='width:10%;font-weight: ;'>{$value[fenclosureno]}</td>";
			$table.='</tr>';
			$sumexpfpoints+=$value[fpoints];
		}
		$table.='<tr style = "font-weight: bold;">'; 								
		$table.="<td style='width:10%;text-align:right;' colspan = 2>Total</td>";		
		$table.="<td style='width:10%;font-weight: ;'>{$sumexpfpoints}</td>";
		$table.='</table><br>';
		
		$query4 = "select fslno,fuserid,fappno,fname,facademic,flevel,fawareded,fpoints,fenclosureno,fenttype,
		r1.freasonname as fawarededname,r2.freasonname as flevelname
		from rechguid
		left join reason r1 on rechguid.fawareded = r1.freasoncode	
		left join reason r2 on rechguid.flevel = r2.freasoncode
		where fuserid = '{$userid}' and fappno = '{$appno}' and fenttype = 'rcfs'";
		$results  = $aobj_context->mobj_db->getAll($query4);
		
		$table.='<table class="table table-bordered" style="width:90%;" id="postdettable">';
		$table.='<thead>';
		$table.='<th colspan = 7 style = "text-align:center;background-color:lightblue;font-family:italic;font-size:110%;">III (E) i. Fellowships and Awards</th> ';	
		$table.='</thead>';
		$table.='<tbody>';
		$table.='<tr>'; 								
		$table.='<td style="width:10%;font-weight: ;">Name of the Fellowship / Award</td>';
		$table.="<td style='width:10%'>Academic body / association</td>";
		$table.="<td style='width:10%'>Type</td>";
		$table.="<td style='width:10%'>Level</td>";
		$table.="<td style='width:10%'>Points</td>";		
		$table.='<td style="width:10%;font-weight: ;">Enclosure No.</td>';
		$table.='</tr>';
		$sumexpfpoints = '';
		$fexp = '';
		foreach($results4 as $value)
		{
			$table.='<tr>'; 								
			$table.="<td style='width:10%'>{$value[fname]}</td>";
			$table.="<td style='width:10%'>{$value[facademic]}</td>";
			$table.="<td style='width:10%'>{$value[fawarededname]}</td>";
			$table.="<td style='width:10%'>{$value[flevelname]}</td>";			
			$table.="<td style='width:10%;font-weight: ;'>{$value[fpoints]}</td>";
			$table.="<td style='width:10%;font-weight: ;'>{$value[fenclosureno]}</td>";
			$table.='</tr>';
			$sumexpfpoints+=$value[fpoints];
		}
		$table.='<tr style = "font-weight: bold;">'; 								
		$table.="<td style='width:10%;text-align:right;' colspan = 4>Total</td>";		
		$table.="<td style='width:10%;font-weight: ;'>{$sumexpfpoints}</td>";
		$table.='</table><br>';
		
		$query4 = "select fslno,fuserid,fappno,ftitle,fsubmitted,forganized,flevel,date_format(fdate,'%d/%m/%Y') as fdate,ftype,fpoints,fenclosureno,
				r1.freasonname as ftypename,r2.freasonname as flevelname
				from rclecture
				left join reason r1 on rclecture.ftype = r1.freasoncode
				left join reason r2 on rclecture.flevel = r2.freasoncode		
				where fuserid = '{$userid}' and fappno = '{$appno}' and fenttype = 'rcil'";
		
		$results4  = $aobj_context->mobj_db->getAll($query4);
		$table.='<table class="table table-bordered" style="width:90%;" id="postdettable">';
		$table.='<thead>';
		$table.='<th colspan = 8 style = "text-align:center;background-color:lightblue;font-family:italic;font-size:110%;">III (E) ii. Invited lectures / papers</th> ';	
		$table.='</thead>';
		$table.='<tbody>';
		$table.='<tr>'; 								
		$table.='<td style="width:10%;font-weight: ;">Title of the Invited Lecture Delivered / Paper Presented</td>';
		$table.="<td style='width:10%'>Title of the conference / Seminar</td>";
		$table.="<td style='width:10%'>Organized By</td>";
		$table.="<td style='width:10%'>Date</td>";
		$table.="<td style='width:10%'>Type</td>";
		$table.="<td style='width:10%'>Level</td>";
		$table.="<td style='width:10%'>Points</td>";		
		$table.='<td style="width:10%;font-weight: ;">Enclosure No.</td>';
		$table.='</tr>';
		$sumexpfpoints = '';
		$fexp = '';
		foreach($results4 as $value)
		{
			$table.='<tr>'; 								
			$table.="<td style='width:10%'>{$value[ftitle]}</td>";
			$table.="<td style='width:10%'>{$value[fsubmitted]}</td>";
			$table.="<td style='width:10%'>{$value[forganized]}</td>";
			$table.="<td style='width:10%'>{$value[fdate]}</td>";
			$table.="<td style='width:10%'>{$value[flevelname]}</td>";
			$table.="<td style='width:10%'>{$value[ftypename]}</td>";			
			$table.="<td style='width:10%;font-weight: ;'>{$value[fpoints]}</td>";
			$table.="<td style='width:10%;font-weight: ;'>{$value[fenclosureno]}</td>";
			$table.='</tr>';
			$sumexpfpoints+=$value[fpoints];
		}
		$table.='<tr style = "font-weight: bold;">'; 								
		$table.="<td style='width:10%;text-align:right;' colspan = 6>Total</td>";		
		$table.="<td style='width:10%;font-weight: ;'>{$sumexpfpoints}</td>";
		$table.='</table><br>';
		
		$query4 = "select fslno,fuserid,fappno,ftitle,fsubmitted,fnom,fpoints,fenclosureno,fenttype
		from rclecture
		where fuserid = '{$userid}' and fappno = '{$appno}' and fenttype = 'rcde'";

$results4  = $aobj_context->mobj_db->getAll($query4);
		
		$table.='<table class="table table-bordered" style="width:90%;" id="postdettable">';
		$table.='<thead>';
		$table.='<th colspan =6  style = "text-align:center;background-color:lightblue;font-family:italic;font-size:110%;">III (F) Development of e-learning delivery process / material</th> ';	
		$table.='</thead>';
		$table.='<tbody>';
		$table.='<tr>'; 								
		$table.='<td style="width:10%;font-weight: ;">Title of module</td>';
		$table.="<td style='width:10%'>Recognized by / Submitted at / Delivered at</td>";
		$table.="<td style='width:10%'>No. of Modules</td>";
		$table.="<td style='width:10%'>Points</td>";
		$table.="<td style='width:10%'>Points</td>";		
		$table.='<td style="width:10%;font-weight: ;">Enclosure No.</td>';
		$table.='</tr>';
		$sumexpfpoints = '';
		$fexp = '';
		foreach($results4 as $value)
		{
			$table.='<tr>'; 								
			$table.="<td style='width:10%'>{$value[ftitle]}</td>";
			$table.="<td style='width:10%'>{$value[fsubmitted]}</td>";
			$table.="<td style='width:10%'>{$value[fnom]}</td>";			
			$table.="<td style='width:10%;font-weight: ;'>{$value[fpoints]}</td>";
			$table.="<td style='width:10%;font-weight: ;'>{$value[fenclosureno]}</td>";
			$table.='</tr>';
			$sumexpfpoints+=$value[fpoints];
		}
		$table.='<tr style = "font-weight: bold;">'; 								
		$table.="<td style='width:10%;text-align:right;' colspan = 3>Total</td>";		
		$table.="<td style='width:10%;font-weight: ;'>{$sumexpfpoints}</td>";
		$table.='</table><br>';
		
		
		
		
		
		
		
		
		
		
		
		
		
		
		
		
		
		
		
		$query4 = "select * from otherdet
				where fuserid = '{$userid}' and fappno = '{$appno}'";
		$results4  = $aobj_context->mobj_db->getRow($query4);
		
		$table.='<table class="table table-bordered" style="width:90%;" id="postdettable">';
		$table.='<thead>';
		$table.='<th colspan = 2 style = "text-align:center;background-color:lightblue;font-family:italic;font-size110%;">Other Activities / Reponsibilities</th> ';	
		$table.='</thead>';
		$table.='<tbody>';
		$table.='<tr>';
		$table.="<td>{$results4[FANYDET]}</td>";
		$table.='</tr>';
		$table.='</tbody>';
		$table.='</html><br>';
		
		$table.='<table class="table table-bordered" style="width:90%;" id="postdettable">';
		$table.='<thead>';
		$table.='<th colspan = 2 style = "text-align:center;background-color:lightblue;font-family:italic;font-size110%;">6.1 Miscellaneous Information</th> ';	
		$table.='</thead>';
		$table.='<tbody>';
		$table.='<tr>'; 								
		$table.="<td style='width:10%'>Have you ever been punished for Gender/Caste related offences or convicted by a court of law? If yes, give details.</td>";		
		$table.="<td style='width:10%;font-weight: ;'>{$results4[FPUNISHEDGC]}</td>"; 
		$table.='</tr>';
		$table.='<tr>'; 								
		$table.="<td style='width:10%'>Were you at any time declared medically unfit or asked to submit your resignation or discharged or dismissed? If yes, give details</td>";		
		$table.="<td style='width:10%;font-weight: ;'>{$results4[FUNFIT]}</td>"; 
		$table.='</tr>';
		$table.='<tr>'; 								
		$table.="<td style='width:10%'>Do you have any criminal case pending against you in a court of law? If yes, give details.</td>";		
		$table.="<td style='width:10%;font-weight: ;'>{$results4[FCRIMINAL]}</td>"; 
		$table.='</tr></table>';
		$table.='<table class="table table-bordered" style="width:90%;" id="postdettable">';
		$table.='<thead>';
		$table.='<th colspan=7 style="text-align:center;background-color:lightblue;font-family:italic;font-size110%;">Two References familiar with your academic work</th> ';	
		$table.='</thead>';
		$table.='<tbody>';
		$table.='<tr>'; 								
		$table.="<td style='width:10%'>Sl. No.</td>";		
		$table.="<td style='width:10%;font-weight: ;'>Full Name</td>"; 
		$table.="<td style='width:10%;font-weight: ;'>Institutional Affiliation (Present/Former)</td>"; 
		$table.="<td style='width:10%;font-weight: ;'>Designation</td>"; 
		$table.="<td style='width:10%;font-weight: ;'>Address</td>";
		$table.="<td style='width:10%;font-weight: ;'>Mobile / Phone No.</td>";
		$table.="<td style='width:10%;font-weight: ;'>Email</td>";	
		$table.='</tr>';
		$table.='<tr>'; 								
		$table.="<td style='width:10%'>1</td>";		
		$table.="<td style='width:10%;font-weight: ;'>{$results4[FREFNAME1]}</td>"; 
		$table.="<td style='width:10%;font-weight: ;'>{$results4[FREFINST1]}</td>"; 
		$table.="<td style='width:10%;font-weight: ;'>{$results4[FREFDESG1]}</td>"; 
		$table.="<td style='width:10%;font-weight: ;'>{$results4[FREFADD1]}</td>";
		$table.="<td style='width:10%;font-weight: ;'>{$results4[FREFMOBILE1]}</td>";
		$table.="<td style='width:10%;font-weight: ;'>{$results4[FREFEMAIL1]}</td>";	
		$table.='</tr>';
		$table.='<tr>'; 								
		$table.="<td style='width:10%'>2</td>";		
		$table.="<td style='width:10%;font-weight: ;'>{$results4[FREFNAME2]}</td>"; 
		$table.="<td style='width:10%;font-weight: ;'>{$results4[FREFINST2]}</td>"; 
		$table.="<td style='width:10%;font-weight: ;'>{$results4[FREFDESG2]}</td>"; 
		$table.="<td style='width:10%;font-weight: ;'>{$results4[FREFADD2]}</td>";
		$table.="<td style='width:10%;font-weight: ;'>{$results4[FREFMOBILE2]}</td>";
		$table.="<td style='width:10%;font-weight: ;'>{$results4[FREFEMAIL2]}</td>";	
		$table.='</tr>';

$rst['table'] = $table;
		echo $aobj_context->mobj_output->ToJSONEnvelope($rst,0,"success");
			
	}else
	{
		$query = "select md.fdegndesc,mc.fdescpn,p.fappno from postdet p inner join mascourse mc on p.fdegree = mc.fdegree
		inner join masdegn md on md.fdegncode = p.fdegncode
		where fuserid = '{$userid}'";
		$results  = $aobj_context->mobj_db->getAll($query);
		
		/* $table ='<table class="table table-bordered" style="width:900px;" id="postdettable">';
		$table.='<thead>';
		$table.='<tr>'; 								
		$table.='<th style="width:50px;">Sl. No.</th>';		
		$table.='<th style="width:200px;">Post Applied for</th>';
		$table.='<th style="width:250px;">Department Name (subject)</th>'; 
		$table.='<th style="width:100px;">Application Number</th>';	
		$table.='<th style="width:50px;">Action</th>';									
		$table.='</tr></thead><tbody>'; */
		$i = 1;
		$table ='';
		foreach($results as $value)
		{
			
			$table.="<tr style = 'height:25px;'>"; 										
			$table.="<td><input type = 'text' id='postid_{$i}' disabled class='form-control1' value = '{$i}'></td>";
			$table.="<td><input type = 'text' id='postdeg_{$i}' value = '{$value['fdegndesc']}' disabled class='form-control1'></td>";
			$table.="<td><input type = 'text' id='postsub_{$i}' disabled value = '{$value['fdescpn']}' class='form-control1'></td>";
			$table.="<td><input type = 'text' id='postapplication_{$i}' disabled value = '{$value['fappno']}' class='form-control1'></td>";
			$table.="<td><button  id='postapp_{$i}' onclick = 'main_menu({$i});' class='form-control1'>Apply<button></td>";
			$table.='</tr>';
			$i++;
		}

$rst['table'] = $table;
		echo $aobj_context->mobj_output->ToJSONEnvelope($rst,-1,"success");
	}		
	
}	
	
function loadapplieddetails($aobj_context)
{
		$userid = $_SESSION['userid'];
		$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
		$query = "select md.fdegndesc,mc.fdescpn,p.fappno from postdet p inner join mascourse mc on p.fdegree = mc.fdegree
				inner join masdegn md on md.fdegncode = p.fdegncode
				where fuserid = '{$userid}'";
		$results  = $aobj_context->mobj_db->getAll($query);
		
		/* $table ='<table class="table table-bordered" style="width:900px;" id="postdettable">';
		$table.='<thead>';
		$table.='<tr>'; 								
		$table.='<th style="width:50px;">Sl. No.</th>';		
		$table.='<th style="width:200px;">Post Applied for</th>';
		$table.='<th style="width:250px;">Department Name (subject)</th>'; 
		$table.='<th style="width:100px;">Application Number</th>';	
		$table.='<th style="width:50px;">Action</th>';									
		$table.='</tr></thead><tbody>'; */
		$i = 1;
		$table ='';
		foreach($results as $value)
		{
			
			$table.="<tr style = 'height:25px;'>"; 										
			$table.="<td><input type = 'text' id='postid_{$i}' disabled class='form-control1' value = '{$i}'></td>";
			$table.="<td><input type = 'text' id='postdeg_{$i}' value = '{$value['fdegndesc']}' disabled class='form-control1'></td>";
			$table.="<td><input type = 'text' id='postsub_{$i}' disabled value = '{$value['fdescpn']}' class='form-control1'></td>";
			$table.="<td><input type = 'text' id='postapplication_{$i}' disabled value = '{$value['fappno']}' class='form-control1'></td>";
			$table.="<td><button  id='postapp_{$i}' onclick = 'main_menu({$i});' class='form-control1'>Apply<button></td>";
			$table.='</tr>';
			$i++;
		}

if($results)
	{	
		$rst['table'] = $table;
		echo $aobj_context->mobj_output->ToJSONEnvelope($rst,0,"success");
	}else
	{
		$rst['msg'] = '';
		echo $aobj_context->mobj_output->ToJSONEnvelope($rst,-1,"Failure");
	}		
}

${this.title}

Code Editor : preview_det_22.php