/promotion/summary/computecv.php
PHP | 712 lines | 596 code | 87 blank | 29 comment | 63 complexity | 9f8bbdd693fb7f7debf1470ae94a12a4 MD5 | raw file
Possible License(s): LGPL-2.1
- <!DOCTYPE html>
- <html lang="en">
- <head>
- <meta charset="utf-8">
- <title>Promotion Summary</title>
- <style type="text/css">
-
- </style>
- <link href="bootstrap.min.css" rel="stylesheet">
- </head>
-
- <body >
- <?php
- session_start();
- require_once('../../lib/globals.php');
- require_once('../../lib/database.php');
- openConnection();
- require_once('../func.php');
- require_once('../promotionfunctions.php');
- //require_once("../../partials/cssimports.php");
- /*
- $_SESSION['A_complex'] = sanitizeInput($_POST['complex']);
- $_SESSION['A_cadre'] = sanitizeInput($_POST['cadre']);
- $_SESSION['A_faculty'] = sanitizeInput($_POST['faculty']);
- $_SESSION['A_dept'] = sanitizeInput($_POST['dept']);
- $_SESSION['A_year'] = sanitizeInput($_POST['year']);
- */
- $complex = $_GET['complex'];
- $cadre = $_GET['cadre'];
- $faculty = $_GET['faculty'];
- $dept = $_GET['dept'];
- $year = $_GET['year'];
- $employeeid=$_GET['employeeid'];
-
- if($complex==""){$complex="%";}
- if($cadre==""){$cadre="%";}
- if($dept==""){$dept="%";}
- if($faculty==""){$faculty="%";}
-
-
- //echo $complex." ".$cadre." ".$faculty." ".$dept." ".$year."".$employeeid;
- if($employeeid == "All")
- {
-
- $query = "SELECT tblemployee.employeeid, tblfaccentres.complexid,tbldepartment.departmentid,
- tblrank.cadreid FROM tblrecommendations INNER JOIN
- tblemployee ON tblemployee.employeeid = tblrecommendations.employeeid INNER JOIN
- tbldepartment ON tbldepartment.departmentid = tblemployee.department INNER JOIN
- tblfaccentres ON tblfaccentres.facultyid = tbldepartment.facultyid INNER JOIN
- tblrank ON tblrank.rankid = tblrecommendations.rankinview INNER JOIN
- tblcadre ON tblcadre.cadreid = tblrank.cadreid
- WHERE (tblcadre.cadreid like '$cadre' and tbldepartment.departmentid like '$dept' and tblrecommendations.year = '$year')";
-
- //echo $query;
- $result = @mysql_query($query) or die(mysql_error());
- if (mysql_num_rows($result)>0){
- while ($row = mysql_fetch_array($result)){
- $employeeid1 = $row['employeeid'];
- $departmentid = $row['departmentid'];
- $complexid1 = $row['complexid'];
- $cadreid1 = $row['cadreid'];
-
- //echo" sumary for $employeeid<br>";
-
- generatecv($employeeid1, $year);
- }
- }
- }
- else
- {
- //specific personnel get his data
- $query = "SELECT tblpromotions.personnelno, tblemployee.employeeid, tblfaccentres.complexid,tbldepartment.departmentid,
- tblrank.cadreid FROM tblpromotions INNER JOIN
- tblemployee ON tblemployee.employeeid = tblpromotions.employeeid INNER JOIN
- tbldepartment ON tbldepartment.departmentid = tblemployee.department INNER JOIN
- tblfaccentres ON tblfaccentres.facultyid = tbldepartment.facultyid INNER JOIN
- tblrecommendations ON tblrecommendations.employeeid = tblemployee.employeeid INNER JOIN
- tblrank ON tblrank.rankid = tblpromotions.rank INNER JOIN
- tblcadre ON tblcadre.cadreid = tblrank.cadreid
- WHERE (tblemployee.employeeid='$employeeid' and tblcadre.cadreid like '$cadre' and tbldepartment.departmentid like '$dept' and tblrecommendations.year = '$year')";
-
- //echo $query;
- $result = @mysql_query($query) or die(mysql_error());
- if (mysql_num_rows($result)>0){
-
- $employeeid1 = mysql_result($result,0,'employeeid');
- $departmentid = mysql_result($result,0,'departmentid');
- $complexid1 = mysql_result($result,0,'complexid');
- $cadreid1 =mysql_result($result,0,'cadreid');
- generatecv($employeeid1, $year);
-
- }
- else
- {
- echo"Staff not yet initialized for $year Promotion Exercise";
- }
-
-
- }
-
- //end
-
- ?>
-
- <?php
- //if (!function_exists("GetSQLValueString")) {
-
- function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
- {
- if (PHP_VERSION < 6) {
- $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
- }
-
- $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
-
- switch ($theType) {
- case "text":
- $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
- break;
- case "long":
- case "int":
- $theValue = ($theValue != "") ? intval($theValue) : "NULL";
- break;
- case "double":
- $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
- break;
- case "date":
- $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
- break;
- case "defined":
- $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
- break;
- }
- return $theValue;
- }
- //}
-
- function generatecv($employeeid,$year)
- {
-
- $employid_emploeeRec=$employeeid;
-
- $query_emploeeRec = sprintf("SELECT tblemployee.firstname, tblemployee.surname, tblemployee.othernames, tblemployee.dateoffirstappointment,
- tblemployee.salaryonappointment, countryname, tblemployee.dateofbirth, tblemployee.placeofbirth, tblemployee.maritalstatus,
- tblemployee.gender, tblemployee.permanentaddress, tbldepartment.name as department, tblstate.statename as state, tbllga.lganame as lga,
- tblrank.name as rank FROM tblemployee, tblconfirmation, tbldepartment, tblrank, tblstate, tbllga, tblcountries
- WHERE tblemployee.department=tbldepartment.departmentid AND tblemployee.rankonemployment=tblrank.rankid AND tblemployee.lgaoforigin=tbllga.lgaid AND
- tbllga.stateid=tblstate.stateid AND tblemployee.nationality=tblcountries.countryid AND tblemployee.employeeid=%s",
- GetSQLValueString($employid_emploeeRec, "int"));
- $emploeeRec = mysql_query($query_emploeeRec) or die(mysql_error());
- $row_emploeeRec = mysql_fetch_assoc($emploeeRec);
- $totalRows_emploeeRec = mysql_num_rows($emploeeRec);
-
- $colname_confirmation = "-1";
- if (isset($employeeid)) {
- $colname_confirmation = $employeeid;
- }
-
- $query_confirmation = sprintf("SELECT effectivedate FROM tblconfirmation WHERE employeeid = %s", GetSQLValueString($colname_confirmation, "int"));
- $confirmation = mysql_query($query_confirmation) or die(mysql_error());
- $row_confirmation = mysql_fetch_assoc($confirmation);
- $totalRows_confirmation = mysql_num_rows($confirmation);
-
- $colname_promotion = "-1";
- if (isset($employeeid)) {
- $colname_promotion = $employeeid;
- }
-
- $query_promotion = sprintf("SELECT personnelno, rank, salaryid, effectivedate FROM tblpromotions WHERE employeeid = %s", GetSQLValueString($colname_promotion, "int"));
- $promotion = mysql_query($query_promotion) or die(mysql_error());
- $row_promotion = mysql_fetch_assoc($promotion);
- $totalRows_promotion = mysql_num_rows($promotion);
-
- $colname_contactaddr = "-1";
- if (isset($employeeid)) {
- $colname_contactaddr = $employeeid;
- }
-
- $query_contactaddr = sprintf("SELECT tblcontactaddr.city, tblcontactaddr.`state`, tblcontactaddr.contactaddress, tblstate.statename FROM tblcontactaddr, tblstate WHERE employeeid = %s AND tblstate.stateid=tblcontactaddr.`state`", GetSQLValueString($colname_contactaddr, "int"));
- $contactaddr = mysql_query($query_contactaddr) or die(mysql_error());
- $row_contactaddr = mysql_fetch_assoc($contactaddr);
- $totalRows_contactaddr = mysql_num_rows($contactaddr);
-
- $colname_workexp = "-1";
- if (isset($employeeid)) {
- $colname_workexp = $employeeid;
- }
-
- $query_workexp = sprintf("SELECT * FROM tblempworkingexp WHERE employeeid = %s ORDER BY `from` DESC", GetSQLValueString($colname_workexp, "int"));
- $workexp = mysql_query($query_workexp) or die(mysql_error());
- $row_workexp = mysql_fetch_assoc($workexp);
- $totalRows_workexp = mysql_num_rows($workexp);
-
- $colname_qualifications = "-1";
- if (isset($employeeid)) {
- $colname_qualifications = $employeeid;
- }
-
- $query_qualifications = sprintf("SELECT tblqualifications_lookup.`certificate`, tblqualification.qualificationid, tblqualification.employeeid, tblqualification.yearobtained, tblqualification.institutionobtained, tblqualification.course, tblqualification.grade FROM tblqualification, tblqualificationcategory,tblqualifications_lookup WHERE employeeid = %s AND tblqualification.category=tblqualificationcategory.id and tblqualification.category=1 AND tblqualifications_lookup.id=tblqualification.qualificationtype", GetSQLValueString($colname_qualifications, "int"));
- $qualifications = mysql_query($query_qualifications) or die(mysql_error());
- $row_qualifications = mysql_fetch_assoc($qualifications);
- $totalRows_qualifications = mysql_num_rows($qualifications);
-
- $colname__profQualification = "-1";
- if (isset($employeeid)){
- $colname__profQualification = $employeeid;
- }
-
- $query__profQualification = sprintf("SELECT tblqualifications_lookup.`certificate`, tblqualification.qualificationid, tblqualification.employeeid, tblqualification.yearobtained, tblqualification.institutionobtained, tblqualification.course, tblqualification.grade FROM tblqualification, tblqualificationcategory,tblqualifications_lookup WHERE employeeid = %s AND tblqualification.category=tblqualificationcategory.id and tblqualification.category='2' AND tblqualifications_lookup.id=tblqualification.qualificationtype", GetSQLValueString($colname_qualifications, "int"));
- $profQualification = mysql_query($query__profQualification) or die(mysql_error());
- $row__profQualification = mysql_fetch_assoc($profQualification);
- $totalRows__profQualification = mysql_num_rows($profQualification);
-
- $colname_languages = "-1";
- if (isset($employeeid)) {
- $colname_languages = $employeeid;
- }
-
- $query_languages = sprintf("SELECT * FROM tbllanguagesspoken WHERE employeeid = %s", GetSQLValueString($colname_languages, "int"));
- $languages = mysql_query($query_languages) or die(mysql_error());
- $row_languages = mysql_fetch_assoc($languages);
- $totalRows_languages = mysql_num_rows($languages);
-
- $colname_positions = "-1";
- if (isset($employeeid)) {
- $colname_positions = $employeeid;
- }
-
- $query_positions = sprintf("SELECT * FROM tblpositionsheld WHERE employeeid = %s", GetSQLValueString($colname_positions, "int"));
- $positions = mysql_query($query_positions) or die(mysql_error());
- $row_positions = mysql_fetch_assoc($positions);
- $totalRows_positions = mysql_num_rows($positions);
-
- $colname_profSoc = "-1";
- if (isset($employeeid)) {
- $colname_profSoc = $employeeid;
- }
-
- $query_profSoc = sprintf("SELECT * FROM tblprofmembership WHERE employeeid = %s", GetSQLValueString($colname_profSoc, "int"));
- $profSoc = mysql_query($query_profSoc) or die(mysql_error());
- $row_profSoc = mysql_fetch_assoc($profSoc);
- $totalRows_profSoc = mysql_num_rows($profSoc);
-
- $colname_teaching = "-1";
- if (isset($employeeid)) {
- $colname_teaching = $employeeid;
- }
-
- $query_teaching = sprintf("SELECT * FROM tblteaching WHERE employeeid = %s", GetSQLValueString($colname_teaching, "int"));
- $teaching = mysql_query($query_teaching) or die(mysql_error());
- $row_teaching = mysql_fetch_assoc($teaching);
- $totalRows_teaching = mysql_num_rows($teaching);
-
- $colname_adminduties = "-1";
- if (isset($employeeid)) {
- $colname_adminduties = $employeeid;
- }
-
- $query_adminduties = sprintf("SELECT tbladminduty.dutylevel, tbladminduty.datefrom, tbladminduty.dateto, tbladminduty.institution, tbladmindutytype.dutyname FROM tbladminduty, tbladmindutytype WHERE employeeid = %s AND tbladminduty.dutytype=tbladmindutytype.dutytypeid", GetSQLValueString($colname_adminduties, "int"));
- $adminduties = mysql_query($query_adminduties) or die(mysql_error());
- $row_adminduties = mysql_fetch_assoc($adminduties);
- $totalRows_adminduties = mysql_num_rows($adminduties);
-
- $colname_localconferences = "-1";
- if (isset($employeeid)) {
- $colname_localconferences = $employeeid;
- }
-
- $query_localconferences = sprintf("SELECT * FROM tblconferences WHERE employeeid = %s AND tblconferences.conferencetype='local' ORDER BY datefrom DESC", GetSQLValueString($colname_localconferences, "int"));
- //echo $query_localconferences; exit;
- $localconferences = mysql_query($query_localconferences) or die(mysql_error());
- $row_localconferences = mysql_fetch_assoc($localconferences);
- $totalRows_localconferences = mysql_num_rows($localconferences);
-
- $colname_internationalconf = "-1";
- if (isset($employeeid)) {
- $colname_internationalconf = $employeeid;
- }
-
- $query_internationalconf = sprintf("SELECT * FROM tblconferences WHERE employeeid = %s AND tblconferences.conferencetype='international' ORDER BY datefrom DESC", GetSQLValueString($colname_internationalconf, "int"));
- $internationalconf = mysql_query($query_internationalconf) or die(mysql_error());
- $row_internationalconf = mysql_fetch_assoc($internationalconf);
- $totalRows_internationalconf = mysql_num_rows($internationalconf);
-
- $emplid_publications = "-1";
- if (isset($employeeid)) {
- $emplid_publications = $employeeid;
- }
-
- $query_publications = sprintf("SELECT tbljournalspublication.title, tbljournalspublication.journalname, tbljournalspublication.authors, tbljournalspublication.publicationdate, tbljournalspublication.url, tblpublictiontype.publictiontypeid, tblpublictiontype.eventoractivity FROM tbljournalspublication, tblpublictiontype WHERE tblpublictiontype.publictiontypeid=tbljournalspublication.typeid AND tbljournalspublication.employeeid=%s and typeid=1", GetSQLValueString($emplid_publications, "int"));
- $publications = mysql_query($query_publications) or die(mysql_error());
- $row_publications = mysql_fetch_assoc($publications);
- $totalRows_publications = mysql_num_rows($publications);
-
- $emplid_cpublications = "-1";
- if (isset($employeeid)) {
- $emplid_cpublications = $employeeid;
- }
-
- $query_cpublications = sprintf("SELECT tbljournalspublication.title, tbljournalspublication.journalname, tbljournalspublication.authors, tbljournalspublication.publicationdate, tbljournalspublication.url, tblpublictiontype.publictiontypeid, tblpublictiontype.eventoractivity FROM tbljournalspublication, tblpublictiontype WHERE tblpublictiontype.publictiontypeid=tbljournalspublication.typeid AND tbljournalspublication.employeeid=%s and typeid=2", GetSQLValueString($emplid_cpublications, "int"));
- $cpublications = mysql_query($query_cpublications) or die(mysql_error());
- $row_cpublications = mysql_fetch_assoc($cpublications);
- $totalRows_cpublications = mysql_num_rows($cpublications);
-
-
- $colname_commservice = "-1";
- if (isset($employeeid)) {
- $colname_commservice = $employeeid;
- }
-
- $query_commservice = sprintf("SELECT * FROM tblcommunityservice WHERE employeeid = %s", GetSQLValueString($colname_commservice, "int"));
- $commservice = mysql_query($query_commservice) or die(mysql_error());
- $row_commservice = mysql_fetch_assoc($commservice);
- $totalRows_commservice = mysql_num_rows($commservice);
-
-
-
- $query_pubtypes = "SELECT * FROM tblpublictiontype ORDER BY publictiontypeid ASC";
- $pubtypes = mysql_query($query_pubtypes) or die(mysql_error());
- $row_pubtypes = mysql_fetch_assoc($pubtypes);
- $totalRows_pubtypes = mysql_num_rows($pubtypes);
- /*
- $pubtypes = array();
-
- for($i=0; $i<$totalRows_publications; $i++){
- $pubtypes[]=$row_pubtypes['eventoractivity'];
- }
-
- var_dump($pubtypes);
- exit;
- */
- ?>
-
- <?php
- //include("footer.html");
- ?>
- </p>
- <h1 align="center">CURRICULUM VITAE</h1>
- <table width="97%" border="0">
- <tr>
- <td>1.</td>
- <td width="40%"><strong>Name in Full:</strong></td>
- <td><?php echo strtoupper($row_emploeeRec['surname']).", ". ucfirst(strtolower($row_emploeeRec['firstname'])). " ". ucfirst(strtolower($row_emploeeRec['othernames'])); ?></td>
- </tr>
- <tr>
- <td>2.</td>
- <td><strong>Personnel No:</strong></td>
- <td><?php echo $row_promotion['personnelno']; ?></td>
- </tr>
- <tr>
- <td>3.</td>
- <td><strong>Department:</strong></td>
- <td><?php echo $row_emploeeRec['department']; ?></td>
- </tr>
- <tr>
- <td>4.</td>
- <td><strong>Date and Place of Birth:</strong></td>
- <td><?php echo $row_emploeeRec['dateofbirth']; ?><?php echo $row_emploeeRec['placeofbirth']; ?></td>
- </tr>
- <tr>
- <td>5.</td>
- <td><strong>State of Origin;</strong></td>
- <td><?php echo $row_emploeeRec['state']; ?></td>
- </tr>
- <tr>
- <td>6.</td>
- <td><strong>Local Government of Origin:</strong></td>
- <td><?php echo $row_emploeeRec['lga']; ?></td>
- </tr>
- <tr>
- <td>7.</td>
- <td><strong>Nationality:</strong></td>
- <td><?php echo $row_emploeeRec['countryname']; ?></td>
- </tr>
- <tr>
- <td>8.</td>
- <td><strong>Marital Status:</strong></td>
- <td><?php echo $row_emploeeRec['maritalstatus']; ?></td>
- </tr>
- <tr>
- <td>9.</td>
- <td><strong>Gender:</strong></td>
- <td><?php echo $row_emploeeRec['gender']; ?></td>
- </tr>
- <tr>
- <td>10.</td>
- <td><strong>International Languages Spoken:</strong></td>
- <td>
- <?php if($totalRows_languages>0){
- do {
- echo $row_languages['language']. ", ";
- }while($row_languages = mysql_fetch_assoc($languages));
- }else{
- echo "Nil";
- }
- ?>
- </td>
- </tr>
- <tr>
- <td>11.</td>
- <td><strong>Current Contact Address:</strong></td>
- <td><?php
- if($totalRows_contactaddr>0){
- echo $row_contactaddr['contactaddress']."<br />";
- echo $row_contactaddr['city']."<br />";
- echo $row_contactaddr['statename']." State<br />";
- //echo $row_contactaddr['zip']."<br />";
- }
- ?></td>
- </tr>
- <tr>
- <td>12.</td>
- <td><strong>Permanent Home Address:</strong></td>
- <td>
- <?php if(isset($row_emploeeRec['permanentaddress']) && strlen(trim($row_emploeeRec['permanentaddress'])) !=0){
- echo $row_emploeeRec['permanentaddress'];
- }else{
- echo "<b>Not set</b>";
- }?>
- </td>
- </tr>
- <tr>
- <td>13.</td>
- <td><strong>Date of First Appointment with the University:</strong></td>
- <td><?php if(isset($row_emploeeRec['dateoffirstappointment'])){
- echo $row_emploeeRec['dateoffirstappointment'];
- }else{
- echo "Not set";
- }?></td>
- </tr>
- <td>14.</td>
- <td><strong>Date of Last Promotion:</strong></td>
- <td><?php if(isset($row_emploeeRec['effectivedate'])){
- echo $row_emploeeRec['effectivedate'];
- }else{
- echo "Not set";
- }?>
-
-
- </td>
- </tr>
-
- <tr>
- <td>15.</td>
- <td><strong>Date of Confirmation:</strong></td>
- <td>
-
- <?php if(isset($row_confirmation['effectivedate'])){
- echo $row_confirmation['effectivedate'];
- }else{
- echo "Not set";
- }?>
- </td>
- </tr>
- <tr>
- <td>16.</td>
- <td><strong>Present Rank and Salary:</strong></td>
- <td><?php
- if(isset($row_promotion['rank'])&& $row_promotion['rank']>0){
- $rankid= $row_promotion['rank'];
- $sql=mysql_query("select name from tblrank where rankid=$rankid");
- echo mysql_result($sql, 0, 'name');
- }
- ?></td>
- </tr>
- <tr>
- <td>17.</td>
- <td><strong>Qualifications, Educational Institutions with Dates:</strong></td>
- <td> <?php
- if($totalRows_qualifications<=0){ echo "Nil"; }?></td> </tr>
-
-
- <?php
- if($totalRows_qualifications>0){ ?>
- <tr><td> </td>
- <td colspan="2">
- <ol type="i">
- <?php do { ?>
- <li> <?php echo $row_qualifications['institutionobtained'].", ". $row_qualifications['certificate']. ", ".$row_qualifications['yearobtained']; ?>
- <?php }while($row_qualifications=mysql_fetch_assoc($qualifications)) ?>
- </ol>
- <?php } ?></td>
- </tr>
-
- <tr>
- <td>18.</td>
- <td><strong>Additional Qualifications/Education with Addresses & Dates</strong></td>
- <td> <?php
- if($totalRows__profQualification<=0){ echo "Nil"; }?></td> </tr>
-
- <?php
- if($totalRows__profQualification>0){ ?>
- <tr><td> </td>
- <td colspan="2">
- <ol type="i">
- <?php do { ?>
- <li> <?php echo $row__profQualification['institutionobtained'].", ". $row__profQualification['certificate']. ", ".$row__profQualification['institutionobtained']; ?>
- <?php }while($row__profQualification=mysql_fetch_assoc($profQualification)) ?>
- </ol>
- <?php } ?></td>
- </tr>
-
- </tr>
-
- <tr>
- <td>19.</td>
- <td><strong>Working Experience with Dates:</strong></td>
- <td> <?php
- if($totalRows_workexp<=0){ echo "Nil"; }?></td> </tr>
-
- <?php
- if($totalRows_workexp>0){ ?>
- <tr><td> </td>
- <td colspan="2">
- <ol type="i">
- <?php do { ?>
- <li> <?php echo $row_workexp['positionheld'].", ". $row_workexp['place']. ", From ".$row_workexp['from']. " To ". $row_workexp['to']. "<br />";
- echo "<b>Responsibilities:</b> ".$row_workexp['responsibilities']; ?></li>
- <?php }while($row_workexp=mysql_fetch_assoc($workexp)) ?>
- </ol>
- <?php } ?></td>
- </tr>
- <tr>
- <td>20.</td>
- <td><strong>Routine Teaching Experience with Dates:</strong></td>
- <td> <?php
- if($totalRows_teaching<=0){ echo "Nil"; }?></td> </tr>
- <?php
- if($totalRows_teaching>0){ ?>
- <tr><td> </td>
- <td colspan="2">
- <ol type="i">
- <?php do { ?>
- <li> <?php echo $row_teaching['coursecode']." - ". $row_teaching['title']." (". $row_teaching['session'].") ". $row_teaching['level']." Student type: ". $row_teaching['level'];?></li>
- <?php }while($row_teaching=mysql_fetch_assoc($teaching)) ?>
- </ol>
- <?php } ?>
- </td>
- </tr>
-
- <tr>
- <td>21.</td>
- <td><strong>Research/Extension Experience and Dates:</strong></td>
- <td><?php ?></td>
- </tr>
-
- <tr>
- <td>22.</td>
- <td><strong>Routine Administrative Duties with Dates:</strong></td>
- <td> <?php
- if($totalRows_adminduties<=0){ echo "Nil"; }?></td> </tr>
- <?php
- if($totalRows_adminduties>0){ ?>
- <tr><td> </td>
- <td colspan="2">
- <ol type="i">
- <?php do { ?>
- <li> <?php echo $totalRows_adminduties['dutyname'].", ". $totalRows_adminduties['institution']." (". $totalRows_adminduties['dutylevel']."), From ". $totalRows_adminduties['datefrom']." To ". $totalRows_adminduties['dateto'];?></li>
- <?php }while($totalRows_adminduties=mysql_fetch_assoc($adminduties)) ?>
- </ol>
- <?php } ?>
- </td>
- </tr>
-
- </tr>
-
- <tr>
- <td>23.</td>
- <td><strong>Positions Held with Dates:</strong></td>
- <td> <?php
- if($totalRows_positions<=0){ echo "Nil"; }?></td> </tr>
- <?php
- if($totalRows_positions>0){ ?>
- <tr><td> </td>
- <td colspan="2">
- <ol type="i">
- <?php do { ?>
- <li> <?php echo $row_positions['position'].", (". $row_positions['capacity']. "".$row_positions['place'].", From ".$row_positions['fromdate']. " To ". $row_positions['todate']. "<br />";?></li>
- <?php }while($row_positions=mysql_fetch_assoc($positions)) ?>
- </ol>
- <?php } ?>
- </td>
- </tr>
-
- <tr>
- <td>24.</td>
- <td><strong>Professional Service / Honour Societies:</strong></td>
- <td> <?php
- if($totalRows_profSoc<=0){ echo "Nil"; }?></td> </tr>
- <?php
- if($totalRows_profSoc>0){ ?>
- <tr><td> </td>
- <td colspan="2">
- <ol type="i">
- <?php do { ?>
- <li> <?php echo $row_profSoc['position'].", ". $row_profSoc['society'];?></li>
- <?php }while($row_profSoc=mysql_fetch_assoc($profSoc)) ?>
- </ol>
- <?php } ?>
- </td>
- </tr>
-
- <tr>
- <td>25.</td>
- <td><strong>Community Service:</strong></td>
- <td> <?php
- if($totalRows_commservice<=0){ echo "Nil"; }?></td> </tr>
- <?php
- if($totalRows_commservice>0){ ?>
- <tr><td> </td>
- <td colspan="2">
- <ol type="i">
- <?php do { ?>
- <li> <?php echo $row_commservice['description'].", (". $row_commservice['servicelevel']."), ".$row_commservice['beneficiary']." From ".$row_commservice['yearfrom']. " To ".$row_commservice['yearto'] ;?></li>
- <?php }while($row_commservice=mysql_fetch_assoc($commservice)) ?>
- </ol>
- <?php } ?>
- </td>
- </tr>
-
- <tr>
- <td>26.</td>
- <td><strong>International Conferences Attended:</strong></td>
- <td> <?php
- if($totalRows_internationalconf<=0){ echo "Nil"; }?></td> </tr>
- <?php
- if($totalRows_internationalconf>0){ ?>
- <tr><td> </td>
- <td colspan="2">
- <ol type="i">
- <?php do { ?>
- <li> <?php echo $row_internationalconf['role']." ". $row_internationalconf['conferencename']." by ".$row_internationalconf['organizers']." held from ".$row_internationalconf['datefrom']." to ".$row_internationalconf['dateto']. ". ".$row_internationalconf['url'] ;?></li>
- <?php }while($row_internationalconf=mysql_fetch_assoc($internationalconf)) ?>
- </ol>
- <?php } ?>
- </td>
- </tr>
-
- <tr>
- <td>27.</td>
- <td><strong>Local Conferences Attended/Organized with Dates:</strong></td>
- <td> <?php
- if($totalRows_localconferences<=0){ echo "Nil"; }?></td> </tr>
- <?php
- if($totalRows_localconferences>0){ ?>
- <tr><td> </td>
- <td colspan="2">
- <ol type="i">
- <?php do { ?>
- <li> <?php echo $row_localconferences['role']." ". $row_localconferences['conferencename']." by ".$row_localconferences['organizers']." held from ".$row_internationalconf['datefrom']." to ".$row_internationalconf['datefrom']. ". ".$row_localconferences['url'] ;?></li>
- <?php }while($row_localconferences=mysql_fetch_assoc($localconferences)) ?>
- </ol>
- <?php } ?>
- </td>
- </tr>
-
- <tr>
- <td>28.</td>
- <td><strong>Publications/Articles:</strong></td>
- <td> <?php
- if($totalRows_publications<=0){ echo "Nil"; }?></td> </tr>
- <tr><td> </td>
- <?php if($totalRows_publications>0){ ?>
- <td colspan="2"> <strong> In peer-reviewed journals </strong>
- <ol type="i">
- <?php do { ?>
- <li> <?php echo $totalRows_publications['authors']." ". substr($totalRows_publications['title'], 0, 4)." ".$totalRows_publications['title'].". <i> ".$totalRows_publications['journalname']."</i> Vol. ".$totalRows_publications['vol']." No. ".$totalRows_publications['num'] ;?></li>
- <?php }while($totalRows_publications=mysql_fetch_assoc($publications)) ?>
- </ol>
- <?php } ?>
- </tr>
-
- <tr>
- <td>29.</td>
- <td><strong>Invention/Innovvation/Award:</strong></td>
- <td><?php ?></td>
- </tr>
-
- <tr>
- <td>30.</td>
- <td><strong>Citation in "Who-is-Who", etc:</strong></td>
- <td><?php ?></td>
- </tr>
-
- <tr>
- <td>31.</td>
- <td><strong>Additional Publications since Last Promotion:</strong></td>
- <td><?php ?></td>
- </tr>
-
- <tr>
- <td>32.</td>
- <td><strong>Hobbies:</strong></td>
- <td><?php ?></td>
- </tr>
-
- <tr>
- <td>33.</td>
- <td><strong>Names and Addresses of Three Referees:</strong></td>
- <td><?php ?></td>
- </tr>
-
-
- </table>
- <p align="center"> </p>
- </div>
- </div>
- <?php
- }
- ?>
- </body>
- </html>