/staffportal/career/viewcv.php
PHP | 996 lines | 868 code | 109 blank | 19 comment | 99 complexity | 5a3bcdfa21d5b7406a40836b92384874 MD5 | raw file
Possible License(s): LGPL-2.1
- <?php require_once('../Connections/cnpgdataport.php'); ?>
- <?php require_once('../Connections/cnpgdataport.php'); ?>
- <?php
- require_once('../Date.php');
- /* initialize the session */
- if (!isset($_SESSION)) {
- session_start();
- }
-
-
- 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;
- }
- }
-
- $employid_emploeeRec = "-1";
- if (isset($_SESSION['employeeid'])) {
- $employid_emploeeRec = $_SESSION['employeeid'];
- }
- mysql_select_db($database_cnpgdataport, $cnpgdataport);
- $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, tblpromotions.effectivedate, tbldepartment.name as department, tblstate.statename as state, tbllga.lganame as lga,
- tblrank.name as rank FROM tblemployee, tblconfirmation, tbldepartment, tblrank, tblstate, tbllga, tblcountries,tblpromotions
- WHERE tblemployee.departmentid=tbldepartment.deptid AND tblemployee.rankonemployment=tblrank.rankid AND tblemployee.lgaoforigin=tbllga.lgaid AND
- tbllga.stateid=tblstate.stateid AND tblemployee.nationality=tblcountries.countryid AND tblemployee.employeeid=tblpromotions.employeeid and tblemployee.employeeid=%s",
- GetSQLValueString($employid_emploeeRec, "int"));
- $emploeeRec = mysql_query($query_emploeeRec, $cnpgdataport) or die(mysql_error());
- $row_emploeeRec = mysql_fetch_assoc($emploeeRec);
- $totalRows_emploeeRec = mysql_num_rows($emploeeRec);
-
- $colname_confirmation = "-1";
- if (isset($_SESSION['employeeid'])) {
- $colname_confirmation = $_SESSION['employeeid'];
- }
- mysql_select_db($database_cnpgdataport, $cnpgdataport);
- $query_confirmation = sprintf("SELECT effectivedate FROM tblconfirmation WHERE employeeid = %s", GetSQLValueString($colname_confirmation, "int"));
- $confirmation = mysql_query($query_confirmation, $cnpgdataport) or die(mysql_error());
- $row_confirmation = mysql_fetch_assoc($confirmation);
- $totalRows_confirmation = mysql_num_rows($confirmation);
-
- $colname_promotion = "-1";
- if (isset($_SESSION['employeeid'])) {
- $colname_promotion = $_SESSION['employeeid'];
- }
- mysql_select_db($database_cnpgdataport, $cnpgdataport);
- $query_promotion = sprintf("SELECT personnelno, rank, salaryid, effectivedate FROM tblpromotions WHERE employeeid = %s", GetSQLValueString($colname_promotion, "int"));
- $promotion = mysql_query($query_promotion, $cnpgdataport) or die(mysql_error());
- $row_promotion = mysql_fetch_assoc($promotion);
- $totalRows_promotion = mysql_num_rows($promotion);
-
- $colname_contactaddr = "-1";
- if (isset($_SESSION['employeeid'])) {
- $colname_contactaddr = $_SESSION['employeeid'];
- }
- mysql_select_db($database_cnpgdataport, $cnpgdataport);
- $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, $cnpgdataport) or die(mysql_error());
- $row_contactaddr = mysql_fetch_assoc($contactaddr);
- $totalRows_contactaddr = mysql_num_rows($contactaddr);
-
- $colname_workexp = "-1";
- if (isset($_SESSION['employeeid'])) {
- $colname_workexp = $_SESSION['employeeid'];
- }
- mysql_select_db($database_cnpgdataport, $cnpgdataport);
- $query_workexp = sprintf("SELECT * FROM tblempworkingexp WHERE employeeid = %s ORDER BY `from` DESC", GetSQLValueString($colname_workexp, "int"));
- $workexp = mysql_query($query_workexp, $cnpgdataport) or die(mysql_error());
- $row_workexp = mysql_fetch_assoc($workexp);
- $totalRows_workexp = mysql_num_rows($workexp);
-
- $colname_qualifications = "-1";
- if (isset($_SESSION['employeeid'])) {
- $colname_qualifications = $_SESSION['employeeid'];
- }
- mysql_select_db($database_cnpgdataport, $cnpgdataport);
- $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, $cnpgdataport) or die(mysql_error());
- $row_qualifications = mysql_fetch_assoc($qualifications);
- $totalRows_qualifications = mysql_num_rows($qualifications);
-
- $colname__profQualification = "-1";
- if (isset($_SESSION['employeeid'])) {
- $colname__profQualification = $_SESSION['employeeid'];
- }
- mysql_select_db($database_cnpgdataport, $cnpgdataport);
- $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, $cnpgdataport) or die(mysql_error());
- $row__profQualification = mysql_fetch_assoc($profQualification);
- $totalRows__profQualification = mysql_num_rows($profQualification);
-
- $colname_languages = "-1";
- if (isset($_SESSION['employeeid'])) {
- $colname_languages = $_SESSION['employeeid'];
- }
- mysql_select_db($database_cnpgdataport, $cnpgdataport);
- $query_languages = sprintf("SELECT * FROM tbllanguagesspoken WHERE employeeid = %s", GetSQLValueString($colname_languages, "int"));
- $languages = mysql_query($query_languages, $cnpgdataport) or die(mysql_error());
- $row_languages = mysql_fetch_assoc($languages);
- $totalRows_languages = mysql_num_rows($languages);
-
- $colname_positions = "-1";
- if (isset($_SESSION['employeeid'])) {
- $colname_positions = $_SESSION['employeeid'];
- }
- mysql_select_db($database_cnpgdataport, $cnpgdataport);
- $query_positions = sprintf("SELECT * FROM tblpositionsheld WHERE employeeid = %s", GetSQLValueString($colname_positions, "int"));
- $positions = mysql_query($query_positions, $cnpgdataport) or die(mysql_error());
- $row_positions = mysql_fetch_assoc($positions);
- $totalRows_positions = mysql_num_rows($positions);
-
- $colname_profSoc = "-1";
- if (isset($_SESSION['employeeid'])) {
- $colname_profSoc = $_SESSION['employeeid'];
- }
- mysql_select_db($database_cnpgdataport, $cnpgdataport);
- $query_profSoc = sprintf("SELECT * FROM tblprofmembership WHERE employeeid = %s", GetSQLValueString($colname_profSoc, "int"));
- $profSoc = mysql_query($query_profSoc, $cnpgdataport) or die(mysql_error());
- $row_profSoc = mysql_fetch_assoc($profSoc);
- $totalRows_profSoc = mysql_num_rows($profSoc);
-
- $colname_teaching = "-1";
- if (isset($_SESSION['employeeid'])) {
- $colname_teaching = $_SESSION['employeeid'];
- }
- mysql_select_db($database_cnpgdataport, $cnpgdataport);
- $query_teaching = sprintf("SELECT * FROM tblteaching WHERE employeeid = %s", GetSQLValueString($colname_teaching, "int"));
- $teaching = mysql_query($query_teaching, $cnpgdataport) or die(mysql_error());
- $row_teaching = mysql_fetch_assoc($teaching);
- $totalRows_teaching = mysql_num_rows($teaching);
-
- $colname_adminduties = "-1";
- if (isset($_SESSION['employeeid'])) {
- $colname_adminduties = $_SESSION['employeeid'];
- }
- mysql_select_db($database_cnpgdataport, $cnpgdataport);
- $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, $cnpgdataport) or die(mysql_error());
- $row_adminduties = mysql_fetch_assoc($adminduties);
- $totalRows_adminduties = mysql_num_rows($adminduties);
-
- $colname_localconferences = "-1";
- if (isset($_SESSION['employeeid'])) {
- $colname_localconferences = $_SESSION['employeeid'];
- }
- mysql_select_db($database_cnpgdataport, $cnpgdataport);
- $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, $cnpgdataport) or die(mysql_error());
- $row_localconferences = mysql_fetch_assoc($localconferences);
- $totalRows_localconferences = mysql_num_rows($localconferences);
-
- $colname_internationalconf = "-1";
- if (isset($_SESSION['employeeid'])) {
- $colname_internationalconf = $_SESSION['employeeid'];
- }
- mysql_select_db($database_cnpgdataport, $cnpgdataport);
- $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, $cnpgdataport) or die(mysql_error());
- $row_internationalconf = mysql_fetch_assoc($internationalconf);
- $totalRows_internationalconf = mysql_num_rows($internationalconf);
-
- $emplid_publications = "-1";
- if (isset($_SESSION['employeeid'])) {
- $emplid_publications = $_SESSION['employeeid'];
- }
- mysql_select_db($database_cnpgdataport, $cnpgdataport);
- $query_publications = sprintf("SELECT tbljournalspublication.title, pages, tbljournalspublication.journalname, tbljournalspublication.authors, tbljournalspublication.vol, tbljournalspublication.num, 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, $cnpgdataport) or die(mysql_error());
- $row_publications = mysql_fetch_assoc($publications);
- $totalRows_publications = mysql_num_rows($publications);
-
- $emplid_cpublications = "-1";
- if (isset($_SESSION['employeeid'])) {
- $emplid_cpublications = $_SESSION['employeeid'];
- }
- mysql_select_db($database_cnpgdataport, $cnpgdataport);
- $query_cpublications = sprintf("SELECT tbljournalspublication.title, tbljournalspublication.journalname, tbljournalspublication.authors, tbljournalspublication.vol, tbljournalspublication.num,tbljournalspublication.publicationdate, tbljournalspublication.url, tblpublictiontype.publictiontypeid, tblpublictiontype.eventoractivity, pages FROM tbljournalspublication, tblpublictiontype WHERE tblpublictiontype.publictiontypeid=tbljournalspublication.typeid AND tbljournalspublication.employeeid=%s and typeid=2", GetSQLValueString($emplid_cpublications, "int"));
- $cpublications = mysql_query($query_cpublications, $cnpgdataport) or die(mysql_error());
- $row_cpublications = mysql_fetch_assoc($cpublications);
- $totalRows_cpublications = mysql_num_rows($cpublications);
-
-
- $lastPromo=$row_emploeeRec['effectivedate'];
- $emplid_publicationsp = "-1";
- if (isset($_SESSION['employeeid'])) {
- $emplid_publicationsp = $_SESSION['employeeid'];
- }
- mysql_select_db($database_cnpgdataport, $cnpgdataport);
- $query_publicationsp = sprintf("SELECT tbljournalspublication.title, tbljournalspublication.journalname, tbljournalspublication.authors, tbljournalspublication.vol, tbljournalspublication.num, tbljournalspublication.publicationdate, tbljournalspublication.url, tblpublictiontype.publictiontypeid, tblpublictiontype.eventoractivity, pages FROM tbljournalspublication, tblpublictiontype WHERE tblpublictiontype.publictiontypeid=tbljournalspublication.typeid AND tbljournalspublication.employeeid=%s and typeid=1 and publicationdate>'$lastPromo'", GetSQLValueString($emplid_publicationsp, "int"));
- $publicationsp = mysql_query($query_publicationsp, $cnpgdataport) or die(mysql_error());
- $row_publicationsp = mysql_fetch_assoc($publicationsp);
- $totalRows_publicationsp = mysql_num_rows($publicationsp);
-
- $emplid_cpublicationsp = "-1";
- if (isset($_SESSION['employeeid'])) {
- $emplid_cpublicationsp = $_SESSION['employeeid'];
- }
- mysql_select_db($database_cnpgdataport, $cnpgdataport);
- $query_cpublicationsp = sprintf("SELECT tbljournalspublication.title, tbljournalspublication.journalname, tbljournalspublication.authors, tbljournalspublication.vol, tbljournalspublication.num,tbljournalspublication.publicationdate, tbljournalspublication.url, tblpublictiontype.publictiontypeid, tblpublictiontype.eventoractivity, pages FROM tbljournalspublication, tblpublictiontype WHERE tblpublictiontype.publictiontypeid=tbljournalspublication.typeid AND tbljournalspublication.employeeid=%s and typeid=2 and publicationdate>'$lastPromo'", GetSQLValueString($emplid_cpublicationsp, "int"));
- $cpublicationsp = mysql_query($query_cpublicationsp, $cnpgdataport) or die(mysql_error());
- $row_cpublicationsp = mysql_fetch_assoc($cpublicationsp);
- $totalRows_cpublicationsp = mysql_num_rows($cpublicationsp);
-
-
- $colname_commservice = "-1";
- if (isset($_SESSION['employeeid'])) {
- $colname_commservice = $_SESSION['employeeid'];
- }
- mysql_select_db($database_cnpgdataport, $cnpgdataport);
- $query_commservice = sprintf("SELECT * FROM tblcommunityservice WHERE employeeid = %s", GetSQLValueString($colname_commservice, "int"));
- $commservice = mysql_query($query_commservice, $cnpgdataport) or die(mysql_error());
- $row_commservice = mysql_fetch_assoc($commservice);
- $totalRows_commservice = mysql_num_rows($commservice);
-
-
- mysql_select_db($database_cnpgdataport, $cnpgdataport);
- $query_pubtypes = "SELECT * FROM tblpublictiontype ORDER BY publictiontypeid ASC";
- $pubtypes = mysql_query($query_pubtypes, $cnpgdataport) or die(mysql_error());
- $row_pubtypes = mysql_fetch_assoc($pubtypes);
- $totalRows_pubtypes = mysql_num_rows($pubtypes);
-
- $colname_Recordset1 = "-1";
- if (isset($_SESSION['employeeid'])) {
- $colname_Recordset1 = $_SESSION['employeeid'];
- }
- mysql_select_db($database_cnpgdataport, $cnpgdataport);
- $query_Recordset1 = sprintf("SELECT * FROM tblconferences WHERE employeeid = %s and conferencetype='international'", GetSQLValueString($colname_Recordset1, "int"));
- $Recordset1 = mysql_query($query_Recordset1, $cnpgdataport) or die(mysql_error());
- $row_Recordset1 = mysql_fetch_assoc($Recordset1);
- $totalRows_Recordset1 = mysql_num_rows($Recordset1);
-
- mysql_select_db($database_cnpgdataport, $cnpgdataport);
- $query_Recordset2 = sprintf("SELECT * FROM tblconferences WHERE employeeid = %s and conferencetype='local'", GetSQLValueString($colname_Recordset1, "int"));
- $Recordset2 = mysql_query($query_Recordset2, $cnpgdataport) or die(mysql_error());
- $row_Recordset2 = mysql_fetch_assoc($Recordset2);
- $totalRows_Recordset2 = mysql_num_rows($Recordset2);
-
- mysql_select_db($database_cnpgdataport, $cnpgdataport);
- $query_Recordset1 = sprintf("SELECT * FROM tblpositionsheld WHERE employeeid = %s", GetSQLValueString($colname_Recordset1, "int"));
- $Recordset1 = mysql_query($query_Recordset1, $cnpgdataport) or die(mysql_error());
- $row_Recordset1 = mysql_fetch_assoc($Recordset1);
- $totalRows_Recordset1 = mysql_num_rows($Recordset1);
-
- $empid_Recordset1 = "-1";
- if (isset($_SESSION['employeeid'])) {
- $empid_Recordset1 = $_SESSION['employeeid'];
- }
- mysql_select_db($database_cnpgdataport, $cnpgdataport);
- $query_Recordset1 = sprintf("SELECT tblposting.positionid, tblposting.employeeid, tblposting.fromdate, tblposting.todate, tblposting.designation, tbldepartment.name FROM tblposting, tbldepartment WHERE tblposting.unitid =tbldepartment.deptid AND tblposting.employeeid=%s ORDER BY tblposting.fromdate DESC", GetSQLValueString($empid_Recordset1, "int"));
- $Recordset1 = mysql_query($query_Recordset1, $cnpgdataport) or die(mysql_error());
- $row_Recordset1 = mysql_fetch_assoc($Recordset1);
- $totalRows_Recordset1 = mysql_num_rows($Recordset1);
-
- mysql_select_db($database_cnpgdataport, $cnpgdataport);
- $query_Recordset1 = sprintf("SELECT * FROM tblreferees WHERE employeeid=%s and current=1 limit 3", GetSQLValueString($empid_Recordset1, "int"));
- $Recordset2 = mysql_query($query_Recordset1, $cnpgdataport) or die(mysql_error());
- $row_tblreferees = mysql_fetch_assoc($Recordset2);
- $totalRows_tblreferees2 = mysql_num_rows($Recordset2);
-
- mysql_select_db($database_cnpgdataport, $cnpgdataport);
- $query_Recordset1 = sprintf("SELECT * FROM tblteaching WHERE employeeid=%s ORDER BY `session` DESC", GetSQLValueString($empid_Recordset1, "int"));
- $Recordset1 = mysql_query($query_Recordset1, $cnpgdataport) or die(mysql_error());
- $tblteaching = mysql_fetch_assoc($Recordset1);
- $totalRows_tblteaching = mysql_num_rows($Recordset1);
-
- mysql_select_db($database_cnpgdataport, $cnpgdataport);
- $query_Recordset1 = sprintf("SELECT * FROM tblwhoiswho WHERE employeeid=%s ORDER BY `year` DESC", GetSQLValueString($empid_Recordset1, "int"));
- $Recordset1 = mysql_query($query_Recordset1, $cnpgdataport) or die(mysql_error());
- $row_tblwhoiswho = mysql_fetch_assoc($Recordset1);
- $totalRows_tblwhoiswho = mysql_num_rows($Recordset1);
-
- mysql_select_db($database_cnpgdataport, $cnpgdataport);
- $query_Recordset1 = sprintf("SELECT * FROM tblhobbies WHERE employeeid=%s", GetSQLValueString($empid_Recordset1, "int"));
- $hobby = mysql_query($query_Recordset1, $cnpgdataport) or die(mysql_error());
- $row_tblhobbies = mysql_fetch_assoc($hobby);
- $totalRows_tblhobbies = mysql_num_rows($hobby);
-
- mysql_select_db($database_cnpgdataport, $cnpgdataport);
- $query_Recordset1 = sprintf("SELECT * FROM tblempworkingexp WHERE employeeid=%s ORDER BY `from` DESC", GetSQLValueString($empid_Recordset1, "int"));
- $Recordset1 = mysql_query($query_Recordset1, $cnpgdataport) or die(mysql_error());
- $row_tblempworkingexp = mysql_fetch_assoc($Recordset1);
- $totalRows_tblempworkingexp = mysql_num_rows($Recordset1);
-
- mysql_select_db($database_cnpgdataport, $cnpgdataport);
- $query_Recordset1 = sprintf("SELECT * FROM tblinventions WHERE employeeid=%s ORDER BY `invention` DESC", GetSQLValueString($empid_Recordset1, "int"));
- $Recordset1 = mysql_query($query_Recordset1, $cnpgdataport) or die(mysql_error());
- $row_tblinventions = mysql_fetch_assoc($Recordset1);
- $totalRows_tblinventions = mysql_num_rows($Recordset1);
-
- /*
- $pubtypes = array();
-
- for($i=0; $i<$totalRows_publications; $i++){
- $pubtypes[]=$row_pubtypes['eventoractivity'];
- }
-
- var_dump($pubtypes);
- exit;
- */
- ?>
- <!DOCTYPE html>
- <html>
-
- <head>
- <title>ABU Registration Portal: Home</title>
- <script src="../js/jquery/jquery-1.6.2.min.js" type="text/javascript"></script>
- <script src="../js/jquery/jquery-ui.min.js" type="text/javascript"></script>
- <script src="../js/jquery/jquery.unobtrusive-ajax.min.js" type="text/javascript"></script>
- <script src="../js/jquery/jquery.validate.min.js" type="text/javascript"></script>
- <script src="../js/jquery/jquery.validate.unobtrusive.min.js" type="text/javascript"></script>
- <script src="../js/jquery/jquery_ui_datepicker.js" type="text/javascript"></script>
- <script src="../js/jquery/jquery.unobtrusive-ajax.min.js" type="text/javascript"></script>
- <script src="../js/site/Site.js" type="text/javascript"></script>
- <script src="../js/jquery.leanModal.min.js" type="text/javascript"></script>
- <script src="../SpryAssets/SpryValidationTextField.js" type="text/javascript"></script>
- <!-- CSS Imports -->
- <link href="../css/jquery/jquery_ui_datepicker.css" rel="stylesheet" type="text/css" />
- <link href="../css/site/css3buttons.css" rel="stylesheet" type="text/css" />
- <link href="../css/centeredmenu.css" rel="stylesheet" type="text/css" />
- <link href="../css/site/site.css" rel="stylesheet" type="text/css" />
- <link href="../SpryAssets/SpryValidationTextField.css" rel="stylesheet" type="text/css" />
- </head>
-
- <body>
-
- <div id="page">
- <div id="main">
- <div id="header" style="position: relative;">
- <img alt="abu-logo" height="129" src="../images/banner.png" style="z-index: 10; width: 950px;">
- <div id="site-nav" style="position: absolute; bottom: 0; right: 0;">
- <ul>
-
- </ul>
- </div>
- <noscript>
- <marquee><h4> It is observed that your browser does not support JavaScript! Some vital portions of this application may not work optimally if javascript is not enabled. You are thus advised to enable javascript for this application to function as expected.</h4></marquee>
- <?php
- //exit;
- ?>
- </noscript>
-
- <!-- #sitenav --></div>
- <p><!-- #header -->
-
- <?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
- $yr=substr($row_emploeeRec['dateofbirth'], 0,4);
- $mth =substr($row_emploeeRec['dateofbirth'], 5,2);
- $dd=substr($row_emploeeRec['dateofbirth'], 8,2);
- $date = new Pos_Date();
- $date->setDate($yr, $mth, $dd);
- echo $date->getDayOrdinal(). " ". $date->getMonthName().", ". $date->getFullYear();?><?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'])){
-
- $yr=substr($row_emploeeRec['dateoffirstappointment'], 0,4);
- $mth =substr($row_emploeeRec['dateoffirstappointment'], 5,2);
- $dd=substr($row_emploeeRec['dateoffirstappointment'], 8,2);
- $date = new Pos_Date();
- $date->setDate($yr, $mth, $dd);
- echo $date->getDayOrdinal(). " ". $date->getMonthName().", ". $date->getFullYear();
-
- //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'])){
-
- $yr=substr($row_emploeeRec['effectivedate'], 0,4);
- $mth =substr($row_emploeeRec['effectivedate'], 5,2);
- $dd=substr($row_emploeeRec['effectivedate'], 8,2);
- $date = new Pos_Date();
- $date->setDate($yr, $mth, $dd);
- echo $date->getDayOrdinal(). " ". $date->getMonthName().", ". $date->getFullYear();
-
- //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'])){
-
- $yr=substr($row_confirmation['effectivedate'], 0,4);
- $mth =substr($row_confirmation['effectivedate'], 5,2);
- $dd=substr($row_confirmation['effectivedate'], 8,2);
- $date = new Pos_Date();
- $date->setDate($yr, $mth, $dd);
- echo $date->getDayOrdinal(). " ". $date->getMonthName().", ". $date->getFullYear();
-
- //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']. ", ";
-
- $yr=substr($row_qualifications['yearobtained'], 0,4);
- $mth =substr($row_qualifications['yearobtained'], 5,2);
- $dd=substr($row_qualifications['yearobtained'], 8,2);
- $date = new Pos_Date();
- $date->setDate($yr, $mth, $dd);
- echo $date->getMonthName().", ". $date->getFullYear();
-
-
- //.$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'];
-
-
- $yr=substr($row__profQualification['yearobtained'], 0,4);
- $mth =substr($row__profQualification['yearobtained'], 5,2);
- $dd=substr($row__profQualification['yearobtained'], 8,2);
- $date = new Pos_Date();
- $date->setDate($yr, $mth, $dd);
- echo ", ".$date->getMonthName().", ". $date->getFullYear();
-
- ?>
- <?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 ";
-
- $yr=substr($row_workexp['from'], 0,4);
- $mth =substr($row_workexp['from'], 5,2);
- $dd=substr($row_workexp['from'], 8,2);
- $date = new Pos_Date();
- $date->setDate($yr, $mth, $dd);
- echo $date->getMonthName().", ". $date->getFullYear();
-
- echo " To ";
-
- $yr=substr($row_workexp['to'], 0,4);
- $mth =substr($row_workexp['to'], 5,2);
- $dd=substr($row_workexp['to'], 8,2);
- $date = new Pos_Date();
- $date->setDate($yr, $mth, $dd);
- echo $date->getMonthName().", ". $date->getFullYear();
-
- echo "<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']." 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']. " capacity) ".$row_positions['place'].", From ";
-
- $yr=substr($row_positions['fromdate'], 0,4);
- $mth =substr($row_positions['fromdate'], 5,2);
- $dd=substr($row_positions['fromdate'], 8,2);
- $date = new Pos_Date();
- $date->setDate($yr, $mth, $dd);
- echo $date->getMonthName().", ". $date->getFullYear();
-
- echo " To ";
- $yr=substr($row_positions['todate'], 0,4);
- $mth =substr($row_positions['todate'], 5,2);
- $dd=substr($row_positions['todate'], 8,2);
- $date = new Pos_Date();
- $date->setDate($yr, $mth, $dd);
- echo $date->getMonthName().", ". $date->getFullYear();
-
-
- echo "<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 || $totalRows_cpublications<=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 $row_publications['authors'];
-
- echo " (". substr($row_publications['publicationdate'], 0, 4).") \"".$row_publications['title']."\". <i><strong> ".$row_publications['journalname'].".</strong></i> ";
- if(isset($row_publications['vol'])&& $row_publications['vol']>0){
- echo $row_publications['vol'];
- }
- if(isset($row_publications['num']) && $row_publications['num']>0){
- echo " (";
- echo $row_publications['num'];
- echo ")";
- }
- if(isset($row_publications['pages']) && $row_publications['pages'] !=""){
- echo ":".$row_publications['pages'] ;
- } ?>
- </li>
- <?php }while($row_publications=mysql_fetch_assoc($publications)) ?>
- </ol>
- <?php } ?>
- </td></tr>
-
- <?php if($totalRows_cpublications>0){ ?>
- <tr><td> </td>
- <td colspan="2"> <strong> In Conference Proceedings </strong>
- <ol type="i">
- <?php do { ?>
- <li>
- <?php
- echo $row_cpublications['authors'];
-
- echo " (". substr($row_cpublications['publicationdate'], 0, 4).") \"".$row_cpublications['title']."\". <i><strong> ".$row_cpublications['journalname'].".</strong></i> ";
- if(isset($row_cpublications['vol'])&& $row_pcublications['vol']>0){
- echo $row_cpublications['vol'];
- }
- if(isset($row_cpublications['num']) && $row_cpublications['num']>0){
- echo " (";
- echo $row_cpublications['num'];
- echo ")";
- }
- if(isset($row_cpublications['pages']) && $row_cpublications['pages'] !=""){
- echo ": ".$row_cpublications['pages'] ;
- }
- ?></li>
- <?php }while($row_cpublications=mysql_fetch_assoc($cpublications)) ?>
- </ol>
- <?php } ?>
-
-
- </tr>
-
- <tr>
- <td>29.</td>
- <td><strong>Invention/Innovation/Award:</strong></td>
- <td> <?php
- if($totalRows_tblinventions <=0){ echo "Nil"; }?></td> </tr>
- <?php
- if($totalRows_tblinventions>0){ ?>
- <tr><td> </td>
- <td colspan="2">
- <ol type="i">
- <?php do { ?>
- <li> <?php echo ucfirst($row_tblinventions['invention'])." - ". $row_tblinventions['description'].", ". $row_tblinventions['year'].".";
- if(isset($row_tblinventions['patentref']) && trim($row_tblinventions['patentref']) !=''){
- echo "<b> Patent Reference Number: ".$row_tblinventions['patentref'] ."</b>" ;
- }?></li>
- <?php }while($row_tblinventions = mysql_fetch_assoc($Recordset1)) ?>
- </ol>
- <?php } ?>
- </td>
-
- </tr>
-
- <tr>
- <td>30.</td>
- <td><strong>Citation in "Who-is-Who", etc:</strong></td>
- <td> <?php
- if($totalRows_tblwhoiswho <=0){ echo "Nil"; }?></td> </tr>
- <?php
- if($totalRows_tblwhoiswho>0){ ?>
- <tr><td> </td>
- <td colspan="2">
- <ol type="i">
- <?php do { ?>
- <li> <?php echo ucfirst($row_tblwhoiswho['achivement'])." - ". $row_tblwhoiswho['year'];?></li>
- <?php }while($row_tblwhoiswho = mysql_fetch_assoc($Recordset1)) ?>
- </ol>
- <?php } ?>
- </td>
-
- </tr>
-
- <tr>
- <td>31.</td>
- <td><strong>Additional Publications since Last Promotion:</strong></td>
- <td> <?php
- if($totalRows_publicationsp<=0 || $totalRows_cpublicationsp<=0){ echo "Nil"; }?></td> </tr>
- <tr><td> </td>
- <?php if($totalRows_publicationsp>0){ ?>
- <td colspan="2"> <strong> In peer-reviewed journals </strong>
-
- <ol type="i">
- <?php do { ?>
- <li>
- <?php
- echo $row_publicationsp['authors'];
-
- echo " (". substr($row_publicationsp['publicationdate'], 0, 4).") \"".$row_publicationsp['title']."\". <i><strong> ".$row_publicationsp['journalname'].".</strong></i> ";
- if(isset($row_publicationsp['vol'])&& $row_publicationsp['vol']>0){
- echo $row_publicationsp['vol'];
- }
- if(isset($row_publicationsp['num']) && $row_publicationsp['num']>0){
- echo " (";
- echo $row_publicationsp['num'];
- echo ")";
- }
- if(isset($row_publicationsp['pages']) && $row_publicationsp['pages'] !=""){
- echo ":".$row_publicationsp['pages'] ;
- } ?>
- </li>
- <?php }while($row_publicationsp=mysql_fetch_assoc($publicationsp)) ?>
- </ol>
-
- <?php } ?>
- </td></tr>
-
- <?php if($totalRows_cpublicationsp>0){ ?>
- <tr><td> </td>
- <td colspan="2"> <strong> In Conference Proceedings </strong>
- <ol type="i">
- <?php do { ?>
- <li>
- <?php
- echo $row_cpublicationsp['authors'];
-
- echo " (". substr($row_cpublicationsp['publicationdate'], 0, 4).") \"".$row_cpublicationsp['title']."\". <i><strong> ".$row_cpublicationsp['journalname'].".</strong></i> ";
- if(isset($row_cpublicationsp['vol'])&& $row_cpublicationsp['vol']>0){
- echo $row_cpublicationsp['vol'];
- }
- if(isset($row_cpublicationsp['num']) && $row_cpublicationsp['num']>0){
- echo " (";
- echo $row_cpublicationsp['num'];
- echo ")";
- }
- if(isset($row_cpublicationsp['pages']) && $row_cpublicationsp['pages'] !=""){
- echo ":".$row_cpublicationsp['pages'] ;
- } ?>
- </li>
- <?php }while($row_cpublicationsp=mysql_fetch_assoc($cpublicationsp)) ?>
- </ol>
- <?php } ?>
-
- </tr>
-
- <tr>
- <td>32.</td>
- <td><strong>Hobbies:</strong></td>
- <td> <?php
- if($totalRows_tblhobbies <=0){ echo "Nil"; }?></td> </tr>
- <?php
- if($totalRows_tblhobbies>0){ ?>
- <tr><td> </td>
- <td colspan="2">
- <ol type="i">
- <?php for($i=0;$i<$totalRows_tblhobbies; $i++) { ?>
- <li> <?php echo ucfirst(mysql_result($hobby,$i, 'hobby'))?></li>
- <?php } while($row_tblhobbies = mysql_fetch_assoc($Recordset1)) ?>
- </ol>
-
-
- <?php } ?>
- </td> </tr>
-
- <tr>
- <td>33.</td>
- <td><strong>Names and Addresses of Three Referees:</strong></td>
- <td> <?php
- if($totalRows_tblreferees2 <=0){ echo "Nil"; }?></td> </tr>
- <?php
- if($totalRows_tblreferees2>0){ ?>
- <tr><td> </td>
- <td colspan="2">
- <ol type="i">
- <?php do { ?>
- <li> <?php echo "<strong>".ucfirst($row_tblreferees['title'])." ". $row_tblreferees['Fullname']. "</strong><br/>";
- echo $row_tblreferees['position']. "<br />";
- echo $row_tblreferees['address']. "<br />";
- echo $row_tblreferees['email']. "<br />";
- echo $row_tblreferees['mobile']. "<br /><br />";
-
- ?></li>
- <?php }while($row_tblreferees = mysql_fetch_assoc($Recordset2)) ?>
- </ol>
- <?php } ?>
- </td>
-
- </tr>
-
-
- </table>
- <p align="center"> </p>
- </div>
- </div>
- </body>
-
- </html>