Linux ip-172-26-7-228 5.4.0-1103-aws #111~18.04.1-Ubuntu SMP Tue May 23 20:04:10 UTC 2023 x86_64
Apache
: 172.26.7.228 | : 3.145.15.78
Cant Read [ /etc/named.conf ]
5.6.40-24+ubuntu18.04.1+deb.sury.org+1
www-data
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
HASH IDENTIFIER
README
+ Create Folder
+ Create File
/
var /
www /
html /
orms-gug /
src /
[ HOME SHELL ]
Name
Size
Permission
Action
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
Delete
Unzip
Zip
${this.title}
Close
Code Editor : preview_det_raghu.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}' and fappno = '{$appno}'"; $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 fslno, sum(fpoints) as expfpoints, sum(fexp) as fexp from expdetl where fuserid = '{$userid}' and fappno = '{$appno}' and fstatus = 'Permanent' group by fappno order by fenttype"; $results4 = $aobj_context->mobj_db->GetRow($query4); $expfpoints = $results4['expfpoints']; $fexp = $results4['fexp']; $fslno = $results4['fslno']; $i = 5; for($j=8;$j<60;$j++) { if($fexp >= $j) $fexppoints = $i; else break; $i++; } if($fexppoints > 10) $fexppoints = 10; $sql = "update expdetl set fpoints = '{$fexppoints}' where fslno = '{$fslno}' and fappno = '{$appno}'"; $results20 = $aobj_context->mobj_db->Execute($sql); $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}' and fappno = '{$appno}'"; $results = $aobj_context->mobj_db->GetRow($query); $phd = $results['phd']; //var_dump($query); $query = "SELECT SUM(fpoints) as ug FROM qualdetl where fuserid = '{$userid}' and fappno = '{$appno}'"; $results = $aobj_context->mobj_db->GetRow($query); $ug = $results['ug']; $query = "SELECT SUM(fpoints) as pg FROM qualdetl where fuserid = '{$userid}' and fappno = '{$appno}' and fenttype = 'masters'"; $results = $aobj_context->mobj_db->GetRow($query); $pg = $results['pg']; $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']; $pdf = $results['FPDFPOINTS']; if($postname == 'ASSISTANT PROFESSOR') { $sum = $ug+$phd+$jre+$net+$slet+$pdf; //var_dump($ug.'-'.$phd.'-'.$jre.'-'.$net.'-'.$slet.'-'.$pdf); if($sum > 35) $sum = 35; if($rchpoints > 15) $rchpoints = 15; $total = $sum+$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;">35</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;">15</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;">50</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') { if($postname == 'PROFESSOR') $rcmax = '400'; else $rcmax = '300'; $academic = $pg+$phd+$fexppoints; //$academic = $ug+$phd+$jre+$net+$slet; //$academicper = $academic*0.2; if($academicper > 10) $academicper = 10; 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 and Teaching Experience</td>"; $table.="<td style='width:10%;font-weight: bold;'>20</td>"; $table.="<td style='width:10%'>{$academic}</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 {$rcmax}</td>"; $table.="<td style='width:10%;font-weight: bold;'>{$rcmax}</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%' colspan=9>{$results['fname']}</td>"; $table.='</tr>'; $table.='<tr>'; $table.='<td style="width:10%;font-weight: bold;font-family:italic;"> Father`s Name</td>'; $table.="<td style='width:10%' colspan=9>{$results['ffatname']}</td>"; $table.='</tr>'; $table.='<tr>'; $table.='<td style="width:10%;font-weight: bold;font-family:italic;"> Mother`s Name </td>'; $table.="<td style='width:10%' colspan=9>{$results['fmotname']}</td></tr>"; $table.='</tr>'; $table.='<tr>'; $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>"; $table.='<td style="width:10%;font-weight: bold;font-family:italic;">Place of Birth</td>'; $table.="<td style='width:10%'>{$results['fbirthplace']}</td>"; $table.='</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'].' '.$results['fcomcity'].' - '.$results['fcompincode']; $peradd = $results['fperadd1'].' '.$results['fperadd2'].''.$results['fperadd3'].''.$results['fperadd4'].' '.$results['fpercity'].' - '.$results['fperpincode']; $table.='<tr>'; $table.='<td style="width:10%;font-weight: bold;">Address for Correspondence</td>'; $table.="<td style='width:10%' colspan=2>{$comadd}</td>"; $table.='<td style="width:10%;font-weight: bold;">Address for Correspondence</td>'; $table.="<td style='width:10%' colspan=2>{$peradd}</td>"; $table.="</tr>"; $table.="<tr>"; $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>"; $table.='<td style="width:10%;font-weight: bold;">Mobile No.</td>'; $table.="<td style='width:10%'>{$results['fmobile']}</td>"; $table.="</tr>"; $table.="<tr>"; $table.='<td style="width:10%;font-weight: bold;" >Languages Known</td>'; $table.="<td style='width:10%' colspan=9><div><b>{$div4}</b></div> </td>"; $table.="</tr>"; if($results['fph']=='T') { $phvalue="Yes, Type: ".$results['fphtype'].", Percentage: ".$results['fphper'] ; } else { $phvalue="No"; } $table.="<tr>"; $table.='<td style="width:10%;font-weight: bold;">Physically disabled?</td>'; $table.="<td style='width:10%' colspan=9>{$phvalue}</td>"; $table.="</tr>"; if($results['f371j']==TRUE) { $hkvalue="Yes"; } else { $hkvalue="No"; } $table.='<tr>'; $table.='<td style="width:10%;font-weight: bold;"> Do you come under 371(j)?</td>'; $table.="<td style='width:10%' colspan=9>{$hkvalue}</td>"; $table.="</tr>"; if($results['fexservice']==TRUE) { $exvalue="Yes"; } else { $exvalue="No"; } $table.='<tr>'; $table.='<td style="width:10%;font-weight: bold;">Ex-Servicemen?</td>'; $table.="<td style='width:10%' colspan=9>{$exvalue}</td>"; $table.="</tr>"; if($results['fkanmedium']==TRUE) { $kmvalue="Yes"; } else { $kmvalue="No"; } $table.='<tr>'; $table.='<td style="width:10%;font-weight: bold;">Kannada Medium?</td>'; $table.="<td style='width:10%' colspan=9>{$kmvalue}</td>"; $table.="</tr>"; if($results['frural']==TRUE) { $rrvalue="Yes"; } else { $rrvalue="No"; } $table.='<tr>'; $table.='<td style="width:10%;font-weight: bold;"> Rural Candidate? </td>'; $table.="<td style='width:10%' colspan=9>{$rrvalue}</td>"; $table.="</tr>"; $table.="</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 distinct * from qualdetl where fuserid = '{$userid}' and fappno = '{$appno}' and ifnull(funivname,'') <> '' 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['fmaxmarks']}</td>"; // $table.="<td style='width:10%;font-weight: ;'>{$value['fsecmarks']}</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>'; $query2 = "select * from phddetl where fuserid = '{$userid}' and fappno = '{$appno}' order by fenttype"; $results3 = $aobj_context->mobj_db->GetAll($query2); $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;'>SLET</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.='<tr>'; $table.="<td style='width:10%;font-weight: bold;'>PDF</td>"; $table.="<td style='width:10%;font-weight: ;'>{$results['FPDFSUB']}</td>"; $table.="<td style='width:10%;font-weight: ;'>{$results['FPDFCERTNO']}</td>"; $table.="<td style='width:10%;font-weight: ;'>{$results['FPDFPASSMTH']}</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: ;">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['fenclosureno']}</td>"; $table.='</tr>'; $sumexpfpoints+=$value['fpoints']; $yeararry = explode('.',$value['fexp']); $fexpyear+=$yeararry[0]; $fexpyear1+=$yeararry[1]; } $year = $fexpyear1/12; $year = explode('.',$year); $fexpyear = $fexpyear+$year[0]; $moth = $fexpyear1%12; $fexp = $fexpyear.'.'.$moth; $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.='</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.='<tr style = "font-weight: bold;">'; $table.="<td style='width:10%;text-align:right;' colspan = 8>Total</td>"; $table.="<td style='width:10%;font-weight: ;'>{$otjpoints}</td>"; $table.='</table><br>'; if($postname == 'ASSOCIATE PROFESSOR' || $postname == 'PROFESSOR' || $postname == 'ASSISTANT PROFESSOR') { /*$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; $sumcat1 = ''; $sumcat2 = ''; 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>'; $sumcat1+=$value['fselfscore']; } 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>'; $sumcat1+=$value['fselfscore']; } 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>'; $sumcat1+=$value['fselfscore']; $table.='<tr>'; $table.="<td style='width:40%;' ></td>"; $table.="<td style='width:10%;' ></td>"; $table.="<td style='width:10%;font-weight:bold;' >Total</td>"; $table.="<td style='width:10%;font-weight:bold;float:' >{$sumcat1}</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>'; $sumcat2+=$value['fselfscore']; } 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>'; $sumcat2+=$value['fselfscore']; } 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>'; $sumcat2+=$value['fselfscore']; $table.='<tr>'; $table.="<td style='width:40%;' ></td>"; $table.="<td style='width:10%;' ></td>"; $table.="<td style='width:10%;font-weight:bold;' >Total</td>"; $table.="<td style='width:10%;font-weight:bold;float:' >{$sumcat2}</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'"; $results4 = $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'"; $results4 = $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'"; $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 (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>'; $table.='</table><br>'; $table.="<center><button class='btn btn_3 btn btn-info' onclick = 'submithprint()'>Submit</button></center>"; $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"); } } ?>
Close