PageRenderTime 67ms CodeModel.GetById 27ms RepoModel.GetById 1ms app.codeStats 0ms

/staffportal/career/viewcv.php

https://bitbucket.org/lecturer34/hrmis
PHP | 996 lines | 868 code | 109 blank | 19 comment | 99 complexity | 5a3bcdfa21d5b7406a40836b92384874 MD5 | raw file
Possible License(s): LGPL-2.1
  1. <?php require_once('../Connections/cnpgdataport.php'); ?>
  2. <?php require_once('../Connections/cnpgdataport.php'); ?>
  3. <?php
  4. require_once('../Date.php');
  5. /* initialize the session */
  6. if (!isset($_SESSION)) {
  7. session_start();
  8. }
  9. if (!function_exists("GetSQLValueString")) {
  10. function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
  11. {
  12. if (PHP_VERSION < 6) {
  13. $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  14. }
  15. $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
  16. switch ($theType) {
  17. case "text":
  18. $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
  19. break;
  20. case "long":
  21. case "int":
  22. $theValue = ($theValue != "") ? intval($theValue) : "NULL";
  23. break;
  24. case "double":
  25. $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
  26. break;
  27. case "date":
  28. $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
  29. break;
  30. case "defined":
  31. $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
  32. break;
  33. }
  34. return $theValue;
  35. }
  36. }
  37. $employid_emploeeRec = "-1";
  38. if (isset($_SESSION['employeeid'])) {
  39. $employid_emploeeRec = $_SESSION['employeeid'];
  40. }
  41. mysql_select_db($database_cnpgdataport, $cnpgdataport);
  42. $query_emploeeRec = sprintf("SELECT tblemployee.firstname, tblemployee.surname, tblemployee.othernames, tblemployee.dateoffirstappointment,
  43. tblemployee.salaryonappointment, countryname, tblemployee.dateofbirth, tblemployee.placeofbirth, tblemployee.maritalstatus,
  44. tblemployee.gender, tblemployee.permanentaddress, tblpromotions.effectivedate, tbldepartment.name as department, tblstate.statename as state, tbllga.lganame as lga,
  45. tblrank.name as rank FROM tblemployee, tblconfirmation, tbldepartment, tblrank, tblstate, tbllga, tblcountries,tblpromotions
  46. WHERE tblemployee.departmentid=tbldepartment.deptid AND tblemployee.rankonemployment=tblrank.rankid AND tblemployee.lgaoforigin=tbllga.lgaid AND
  47. tbllga.stateid=tblstate.stateid AND tblemployee.nationality=tblcountries.countryid AND tblemployee.employeeid=tblpromotions.employeeid and tblemployee.employeeid=%s",
  48. GetSQLValueString($employid_emploeeRec, "int"));
  49. $emploeeRec = mysql_query($query_emploeeRec, $cnpgdataport) or die(mysql_error());
  50. $row_emploeeRec = mysql_fetch_assoc($emploeeRec);
  51. $totalRows_emploeeRec = mysql_num_rows($emploeeRec);
  52. $colname_confirmation = "-1";
  53. if (isset($_SESSION['employeeid'])) {
  54. $colname_confirmation = $_SESSION['employeeid'];
  55. }
  56. mysql_select_db($database_cnpgdataport, $cnpgdataport);
  57. $query_confirmation = sprintf("SELECT effectivedate FROM tblconfirmation WHERE employeeid = %s", GetSQLValueString($colname_confirmation, "int"));
  58. $confirmation = mysql_query($query_confirmation, $cnpgdataport) or die(mysql_error());
  59. $row_confirmation = mysql_fetch_assoc($confirmation);
  60. $totalRows_confirmation = mysql_num_rows($confirmation);
  61. $colname_promotion = "-1";
  62. if (isset($_SESSION['employeeid'])) {
  63. $colname_promotion = $_SESSION['employeeid'];
  64. }
  65. mysql_select_db($database_cnpgdataport, $cnpgdataport);
  66. $query_promotion = sprintf("SELECT personnelno, rank, salaryid, effectivedate FROM tblpromotions WHERE employeeid = %s", GetSQLValueString($colname_promotion, "int"));
  67. $promotion = mysql_query($query_promotion, $cnpgdataport) or die(mysql_error());
  68. $row_promotion = mysql_fetch_assoc($promotion);
  69. $totalRows_promotion = mysql_num_rows($promotion);
  70. $colname_contactaddr = "-1";
  71. if (isset($_SESSION['employeeid'])) {
  72. $colname_contactaddr = $_SESSION['employeeid'];
  73. }
  74. mysql_select_db($database_cnpgdataport, $cnpgdataport);
  75. $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"));
  76. $contactaddr = mysql_query($query_contactaddr, $cnpgdataport) or die(mysql_error());
  77. $row_contactaddr = mysql_fetch_assoc($contactaddr);
  78. $totalRows_contactaddr = mysql_num_rows($contactaddr);
  79. $colname_workexp = "-1";
  80. if (isset($_SESSION['employeeid'])) {
  81. $colname_workexp = $_SESSION['employeeid'];
  82. }
  83. mysql_select_db($database_cnpgdataport, $cnpgdataport);
  84. $query_workexp = sprintf("SELECT * FROM tblempworkingexp WHERE employeeid = %s ORDER BY `from` DESC", GetSQLValueString($colname_workexp, "int"));
  85. $workexp = mysql_query($query_workexp, $cnpgdataport) or die(mysql_error());
  86. $row_workexp = mysql_fetch_assoc($workexp);
  87. $totalRows_workexp = mysql_num_rows($workexp);
  88. $colname_qualifications = "-1";
  89. if (isset($_SESSION['employeeid'])) {
  90. $colname_qualifications = $_SESSION['employeeid'];
  91. }
  92. mysql_select_db($database_cnpgdataport, $cnpgdataport);
  93. $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"));
  94. $qualifications = mysql_query($query_qualifications, $cnpgdataport) or die(mysql_error());
  95. $row_qualifications = mysql_fetch_assoc($qualifications);
  96. $totalRows_qualifications = mysql_num_rows($qualifications);
  97. $colname__profQualification = "-1";
  98. if (isset($_SESSION['employeeid'])) {
  99. $colname__profQualification = $_SESSION['employeeid'];
  100. }
  101. mysql_select_db($database_cnpgdataport, $cnpgdataport);
  102. $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"));
  103. $profQualification = mysql_query($query__profQualification, $cnpgdataport) or die(mysql_error());
  104. $row__profQualification = mysql_fetch_assoc($profQualification);
  105. $totalRows__profQualification = mysql_num_rows($profQualification);
  106. $colname_languages = "-1";
  107. if (isset($_SESSION['employeeid'])) {
  108. $colname_languages = $_SESSION['employeeid'];
  109. }
  110. mysql_select_db($database_cnpgdataport, $cnpgdataport);
  111. $query_languages = sprintf("SELECT * FROM tbllanguagesspoken WHERE employeeid = %s", GetSQLValueString($colname_languages, "int"));
  112. $languages = mysql_query($query_languages, $cnpgdataport) or die(mysql_error());
  113. $row_languages = mysql_fetch_assoc($languages);
  114. $totalRows_languages = mysql_num_rows($languages);
  115. $colname_positions = "-1";
  116. if (isset($_SESSION['employeeid'])) {
  117. $colname_positions = $_SESSION['employeeid'];
  118. }
  119. mysql_select_db($database_cnpgdataport, $cnpgdataport);
  120. $query_positions = sprintf("SELECT * FROM tblpositionsheld WHERE employeeid = %s", GetSQLValueString($colname_positions, "int"));
  121. $positions = mysql_query($query_positions, $cnpgdataport) or die(mysql_error());
  122. $row_positions = mysql_fetch_assoc($positions);
  123. $totalRows_positions = mysql_num_rows($positions);
  124. $colname_profSoc = "-1";
  125. if (isset($_SESSION['employeeid'])) {
  126. $colname_profSoc = $_SESSION['employeeid'];
  127. }
  128. mysql_select_db($database_cnpgdataport, $cnpgdataport);
  129. $query_profSoc = sprintf("SELECT * FROM tblprofmembership WHERE employeeid = %s", GetSQLValueString($colname_profSoc, "int"));
  130. $profSoc = mysql_query($query_profSoc, $cnpgdataport) or die(mysql_error());
  131. $row_profSoc = mysql_fetch_assoc($profSoc);
  132. $totalRows_profSoc = mysql_num_rows($profSoc);
  133. $colname_teaching = "-1";
  134. if (isset($_SESSION['employeeid'])) {
  135. $colname_teaching = $_SESSION['employeeid'];
  136. }
  137. mysql_select_db($database_cnpgdataport, $cnpgdataport);
  138. $query_teaching = sprintf("SELECT * FROM tblteaching WHERE employeeid = %s", GetSQLValueString($colname_teaching, "int"));
  139. $teaching = mysql_query($query_teaching, $cnpgdataport) or die(mysql_error());
  140. $row_teaching = mysql_fetch_assoc($teaching);
  141. $totalRows_teaching = mysql_num_rows($teaching);
  142. $colname_adminduties = "-1";
  143. if (isset($_SESSION['employeeid'])) {
  144. $colname_adminduties = $_SESSION['employeeid'];
  145. }
  146. mysql_select_db($database_cnpgdataport, $cnpgdataport);
  147. $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"));
  148. $adminduties = mysql_query($query_adminduties, $cnpgdataport) or die(mysql_error());
  149. $row_adminduties = mysql_fetch_assoc($adminduties);
  150. $totalRows_adminduties = mysql_num_rows($adminduties);
  151. $colname_localconferences = "-1";
  152. if (isset($_SESSION['employeeid'])) {
  153. $colname_localconferences = $_SESSION['employeeid'];
  154. }
  155. mysql_select_db($database_cnpgdataport, $cnpgdataport);
  156. $query_localconferences = sprintf("SELECT * FROM tblconferences WHERE employeeid = %s AND tblconferences.conferencetype='local' ORDER BY datefrom DESC", GetSQLValueString($colname_localconferences, "int"));
  157. //echo $query_localconferences; exit;
  158. $localconferences = mysql_query($query_localconferences, $cnpgdataport) or die(mysql_error());
  159. $row_localconferences = mysql_fetch_assoc($localconferences);
  160. $totalRows_localconferences = mysql_num_rows($localconferences);
  161. $colname_internationalconf = "-1";
  162. if (isset($_SESSION['employeeid'])) {
  163. $colname_internationalconf = $_SESSION['employeeid'];
  164. }
  165. mysql_select_db($database_cnpgdataport, $cnpgdataport);
  166. $query_internationalconf = sprintf("SELECT * FROM tblconferences WHERE employeeid = %s AND tblconferences.conferencetype='international' ORDER BY datefrom DESC", GetSQLValueString($colname_internationalconf, "int"));
  167. $internationalconf = mysql_query($query_internationalconf, $cnpgdataport) or die(mysql_error());
  168. $row_internationalconf = mysql_fetch_assoc($internationalconf);
  169. $totalRows_internationalconf = mysql_num_rows($internationalconf);
  170. $emplid_publications = "-1";
  171. if (isset($_SESSION['employeeid'])) {
  172. $emplid_publications = $_SESSION['employeeid'];
  173. }
  174. mysql_select_db($database_cnpgdataport, $cnpgdataport);
  175. $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"));
  176. $publications = mysql_query($query_publications, $cnpgdataport) or die(mysql_error());
  177. $row_publications = mysql_fetch_assoc($publications);
  178. $totalRows_publications = mysql_num_rows($publications);
  179. $emplid_cpublications = "-1";
  180. if (isset($_SESSION['employeeid'])) {
  181. $emplid_cpublications = $_SESSION['employeeid'];
  182. }
  183. mysql_select_db($database_cnpgdataport, $cnpgdataport);
  184. $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"));
  185. $cpublications = mysql_query($query_cpublications, $cnpgdataport) or die(mysql_error());
  186. $row_cpublications = mysql_fetch_assoc($cpublications);
  187. $totalRows_cpublications = mysql_num_rows($cpublications);
  188. $lastPromo=$row_emploeeRec['effectivedate'];
  189. $emplid_publicationsp = "-1";
  190. if (isset($_SESSION['employeeid'])) {
  191. $emplid_publicationsp = $_SESSION['employeeid'];
  192. }
  193. mysql_select_db($database_cnpgdataport, $cnpgdataport);
  194. $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"));
  195. $publicationsp = mysql_query($query_publicationsp, $cnpgdataport) or die(mysql_error());
  196. $row_publicationsp = mysql_fetch_assoc($publicationsp);
  197. $totalRows_publicationsp = mysql_num_rows($publicationsp);
  198. $emplid_cpublicationsp = "-1";
  199. if (isset($_SESSION['employeeid'])) {
  200. $emplid_cpublicationsp = $_SESSION['employeeid'];
  201. }
  202. mysql_select_db($database_cnpgdataport, $cnpgdataport);
  203. $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"));
  204. $cpublicationsp = mysql_query($query_cpublicationsp, $cnpgdataport) or die(mysql_error());
  205. $row_cpublicationsp = mysql_fetch_assoc($cpublicationsp);
  206. $totalRows_cpublicationsp = mysql_num_rows($cpublicationsp);
  207. $colname_commservice = "-1";
  208. if (isset($_SESSION['employeeid'])) {
  209. $colname_commservice = $_SESSION['employeeid'];
  210. }
  211. mysql_select_db($database_cnpgdataport, $cnpgdataport);
  212. $query_commservice = sprintf("SELECT * FROM tblcommunityservice WHERE employeeid = %s", GetSQLValueString($colname_commservice, "int"));
  213. $commservice = mysql_query($query_commservice, $cnpgdataport) or die(mysql_error());
  214. $row_commservice = mysql_fetch_assoc($commservice);
  215. $totalRows_commservice = mysql_num_rows($commservice);
  216. mysql_select_db($database_cnpgdataport, $cnpgdataport);
  217. $query_pubtypes = "SELECT * FROM tblpublictiontype ORDER BY publictiontypeid ASC";
  218. $pubtypes = mysql_query($query_pubtypes, $cnpgdataport) or die(mysql_error());
  219. $row_pubtypes = mysql_fetch_assoc($pubtypes);
  220. $totalRows_pubtypes = mysql_num_rows($pubtypes);
  221. $colname_Recordset1 = "-1";
  222. if (isset($_SESSION['employeeid'])) {
  223. $colname_Recordset1 = $_SESSION['employeeid'];
  224. }
  225. mysql_select_db($database_cnpgdataport, $cnpgdataport);
  226. $query_Recordset1 = sprintf("SELECT * FROM tblconferences WHERE employeeid = %s and conferencetype='international'", GetSQLValueString($colname_Recordset1, "int"));
  227. $Recordset1 = mysql_query($query_Recordset1, $cnpgdataport) or die(mysql_error());
  228. $row_Recordset1 = mysql_fetch_assoc($Recordset1);
  229. $totalRows_Recordset1 = mysql_num_rows($Recordset1);
  230. mysql_select_db($database_cnpgdataport, $cnpgdataport);
  231. $query_Recordset2 = sprintf("SELECT * FROM tblconferences WHERE employeeid = %s and conferencetype='local'", GetSQLValueString($colname_Recordset1, "int"));
  232. $Recordset2 = mysql_query($query_Recordset2, $cnpgdataport) or die(mysql_error());
  233. $row_Recordset2 = mysql_fetch_assoc($Recordset2);
  234. $totalRows_Recordset2 = mysql_num_rows($Recordset2);
  235. mysql_select_db($database_cnpgdataport, $cnpgdataport);
  236. $query_Recordset1 = sprintf("SELECT * FROM tblpositionsheld WHERE employeeid = %s", GetSQLValueString($colname_Recordset1, "int"));
  237. $Recordset1 = mysql_query($query_Recordset1, $cnpgdataport) or die(mysql_error());
  238. $row_Recordset1 = mysql_fetch_assoc($Recordset1);
  239. $totalRows_Recordset1 = mysql_num_rows($Recordset1);
  240. $empid_Recordset1 = "-1";
  241. if (isset($_SESSION['employeeid'])) {
  242. $empid_Recordset1 = $_SESSION['employeeid'];
  243. }
  244. mysql_select_db($database_cnpgdataport, $cnpgdataport);
  245. $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"));
  246. $Recordset1 = mysql_query($query_Recordset1, $cnpgdataport) or die(mysql_error());
  247. $row_Recordset1 = mysql_fetch_assoc($Recordset1);
  248. $totalRows_Recordset1 = mysql_num_rows($Recordset1);
  249. mysql_select_db($database_cnpgdataport, $cnpgdataport);
  250. $query_Recordset1 = sprintf("SELECT * FROM tblreferees WHERE employeeid=%s and current=1 limit 3", GetSQLValueString($empid_Recordset1, "int"));
  251. $Recordset2 = mysql_query($query_Recordset1, $cnpgdataport) or die(mysql_error());
  252. $row_tblreferees = mysql_fetch_assoc($Recordset2);
  253. $totalRows_tblreferees2 = mysql_num_rows($Recordset2);
  254. mysql_select_db($database_cnpgdataport, $cnpgdataport);
  255. $query_Recordset1 = sprintf("SELECT * FROM tblteaching WHERE employeeid=%s ORDER BY `session` DESC", GetSQLValueString($empid_Recordset1, "int"));
  256. $Recordset1 = mysql_query($query_Recordset1, $cnpgdataport) or die(mysql_error());
  257. $tblteaching = mysql_fetch_assoc($Recordset1);
  258. $totalRows_tblteaching = mysql_num_rows($Recordset1);
  259. mysql_select_db($database_cnpgdataport, $cnpgdataport);
  260. $query_Recordset1 = sprintf("SELECT * FROM tblwhoiswho WHERE employeeid=%s ORDER BY `year` DESC", GetSQLValueString($empid_Recordset1, "int"));
  261. $Recordset1 = mysql_query($query_Recordset1, $cnpgdataport) or die(mysql_error());
  262. $row_tblwhoiswho = mysql_fetch_assoc($Recordset1);
  263. $totalRows_tblwhoiswho = mysql_num_rows($Recordset1);
  264. mysql_select_db($database_cnpgdataport, $cnpgdataport);
  265. $query_Recordset1 = sprintf("SELECT * FROM tblhobbies WHERE employeeid=%s", GetSQLValueString($empid_Recordset1, "int"));
  266. $hobby = mysql_query($query_Recordset1, $cnpgdataport) or die(mysql_error());
  267. $row_tblhobbies = mysql_fetch_assoc($hobby);
  268. $totalRows_tblhobbies = mysql_num_rows($hobby);
  269. mysql_select_db($database_cnpgdataport, $cnpgdataport);
  270. $query_Recordset1 = sprintf("SELECT * FROM tblempworkingexp WHERE employeeid=%s ORDER BY `from` DESC", GetSQLValueString($empid_Recordset1, "int"));
  271. $Recordset1 = mysql_query($query_Recordset1, $cnpgdataport) or die(mysql_error());
  272. $row_tblempworkingexp = mysql_fetch_assoc($Recordset1);
  273. $totalRows_tblempworkingexp = mysql_num_rows($Recordset1);
  274. mysql_select_db($database_cnpgdataport, $cnpgdataport);
  275. $query_Recordset1 = sprintf("SELECT * FROM tblinventions WHERE employeeid=%s ORDER BY `invention` DESC", GetSQLValueString($empid_Recordset1, "int"));
  276. $Recordset1 = mysql_query($query_Recordset1, $cnpgdataport) or die(mysql_error());
  277. $row_tblinventions = mysql_fetch_assoc($Recordset1);
  278. $totalRows_tblinventions = mysql_num_rows($Recordset1);
  279. /*
  280. $pubtypes = array();
  281. for($i=0; $i<$totalRows_publications; $i++){
  282. $pubtypes[]=$row_pubtypes['eventoractivity'];
  283. }
  284. var_dump($pubtypes);
  285. exit;
  286. */
  287. ?>
  288. <!DOCTYPE html>
  289. <html>
  290. <head>
  291. <title>ABU Registration Portal: Home</title>
  292. <script src="../js/jquery/jquery-1.6.2.min.js" type="text/javascript"></script>
  293. <script src="../js/jquery/jquery-ui.min.js" type="text/javascript"></script>
  294. <script src="../js/jquery/jquery.unobtrusive-ajax.min.js" type="text/javascript"></script>
  295. <script src="../js/jquery/jquery.validate.min.js" type="text/javascript"></script>
  296. <script src="../js/jquery/jquery.validate.unobtrusive.min.js" type="text/javascript"></script>
  297. <script src="../js/jquery/jquery_ui_datepicker.js" type="text/javascript"></script>
  298. <script src="../js/jquery/jquery.unobtrusive-ajax.min.js" type="text/javascript"></script>
  299. <script src="../js/site/Site.js" type="text/javascript"></script>
  300. <script src="../js/jquery.leanModal.min.js" type="text/javascript"></script>
  301. <script src="../SpryAssets/SpryValidationTextField.js" type="text/javascript"></script>
  302. <!-- CSS Imports -->
  303. <link href="../css/jquery/jquery_ui_datepicker.css" rel="stylesheet" type="text/css" />
  304. <link href="../css/site/css3buttons.css" rel="stylesheet" type="text/css" />
  305. <link href="../css/centeredmenu.css" rel="stylesheet" type="text/css" />
  306. <link href="../css/site/site.css" rel="stylesheet" type="text/css" />
  307. <link href="../SpryAssets/SpryValidationTextField.css" rel="stylesheet" type="text/css" />
  308. </head>
  309. <body>
  310. <div id="page">
  311. <div id="main">
  312. <div id="header" style="position: relative;">
  313. <img alt="abu-logo" height="129" src="../images/banner.png" style="z-index: 10; width: 950px;">
  314. <div id="site-nav" style="position: absolute; bottom: 0; right: 0;">
  315. <ul>
  316. </ul>
  317. </div>
  318. <noscript>
  319. <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>
  320. <?php
  321. //exit;
  322. ?>
  323. </noscript>
  324. <!-- #sitenav --></div>
  325. <p><!-- #header -->
  326. <?php
  327. //include("footer.html");
  328. ?>
  329. </p>
  330. <h1 align="center">CURRICULUM VITAE</h1>
  331. <table width="97%" border="0">
  332. <tr>
  333. <td>1.</td>
  334. <td width="40%"><strong>Name in Full:</strong></td>
  335. <td><?php echo strtoupper($row_emploeeRec['surname']).", ". ucfirst(strtolower($row_emploeeRec['firstname'])). " ". ucfirst(strtolower($row_emploeeRec['othernames'])); ?></td>
  336. </tr>
  337. <tr>
  338. <td>2.</td>
  339. <td><strong>Personnel No:</strong></td>
  340. <td><?php echo $row_promotion['personnelno']; ?></td>
  341. </tr>
  342. <tr>
  343. <td>3.</td>
  344. <td><strong>Department:</strong></td>
  345. <td><?php echo $row_emploeeRec['department']; ?></td>
  346. </tr>
  347. <tr>
  348. <td>4.</td>
  349. <td><strong>Date and Place of Birth:</strong></td>
  350. <td><?php
  351. $yr=substr($row_emploeeRec['dateofbirth'], 0,4);
  352. $mth =substr($row_emploeeRec['dateofbirth'], 5,2);
  353. $dd=substr($row_emploeeRec['dateofbirth'], 8,2);
  354. $date = new Pos_Date();
  355. $date->setDate($yr, $mth, $dd);
  356. echo $date->getDayOrdinal(). " ". $date->getMonthName().", ". $date->getFullYear();?><?php echo " / ". $row_emploeeRec['placeofbirth']; ?></td>
  357. </tr>
  358. <tr>
  359. <td>5.</td>
  360. <td><strong>State of Origin;</strong></td>
  361. <td><?php echo $row_emploeeRec['state']; ?></td>
  362. </tr>
  363. <tr>
  364. <td>6.</td>
  365. <td><strong>Local Government of Origin:</strong></td>
  366. <td><?php echo $row_emploeeRec['lga']; ?></td>
  367. </tr>
  368. <tr>
  369. <td>7.</td>
  370. <td><strong>Nationality:</strong></td>
  371. <td><?php echo $row_emploeeRec['countryname']; ?></td>
  372. </tr>
  373. <tr>
  374. <td>8.</td>
  375. <td><strong>Marital Status:</strong></td>
  376. <td><?php echo $row_emploeeRec['maritalstatus']; ?></td>
  377. </tr>
  378. <tr>
  379. <td>9.</td>
  380. <td><strong>Gender:</strong></td>
  381. <td><?php echo $row_emploeeRec['gender']; ?></td>
  382. </tr>
  383. <tr>
  384. <td>10.</td>
  385. <td><strong>International Languages Spoken:</strong></td>
  386. <td>
  387. <?php if($totalRows_languages>0){
  388. do {
  389. echo $row_languages['language']. ", ";
  390. }while($row_languages = mysql_fetch_assoc($languages));
  391. }else{
  392. echo "Nil";
  393. }
  394. ?>
  395. </td>
  396. </tr>
  397. <tr>
  398. <td>11.</td>
  399. <td><strong>Current Contact Address:</strong></td>
  400. <td><?php
  401. if($totalRows_contactaddr>0){
  402. echo $row_contactaddr['contactaddress']."<br />";
  403. echo $row_contactaddr['city']."<br />";
  404. echo $row_contactaddr['statename']." State<br />";
  405. //echo $row_contactaddr['zip']."<br />";
  406. }
  407. ?></td>
  408. </tr>
  409. <tr>
  410. <td>12.</td>
  411. <td><strong>Permanent Home Address:</strong></td>
  412. <td>
  413. <?php if(isset($row_emploeeRec['permanentaddress']) && strlen(trim($row_emploeeRec['permanentaddress'])) !=0){
  414. echo $row_emploeeRec['permanentaddress'];
  415. }else{
  416. echo "<b>Not set</b>";
  417. }?>
  418. </td>
  419. </tr>
  420. <tr>
  421. <td>13.</td>
  422. <td><strong>Date of First Appointment with the University:</strong></td>
  423. <td><?php if(isset($row_emploeeRec['dateoffirstappointment'])){
  424. $yr=substr($row_emploeeRec['dateoffirstappointment'], 0,4);
  425. $mth =substr($row_emploeeRec['dateoffirstappointment'], 5,2);
  426. $dd=substr($row_emploeeRec['dateoffirstappointment'], 8,2);
  427. $date = new Pos_Date();
  428. $date->setDate($yr, $mth, $dd);
  429. echo $date->getDayOrdinal(). " ". $date->getMonthName().", ". $date->getFullYear();
  430. //echo $row_emploeeRec['dateoffirstappointment'];
  431. }else{
  432. echo "Not set";
  433. }?></td>
  434. </tr>
  435. <td>14.</td>
  436. <td><strong>Date of Last Promotion:</strong></td>
  437. <td><?php if(isset($row_emploeeRec['effectivedate'])){
  438. $yr=substr($row_emploeeRec['effectivedate'], 0,4);
  439. $mth =substr($row_emploeeRec['effectivedate'], 5,2);
  440. $dd=substr($row_emploeeRec['effectivedate'], 8,2);
  441. $date = new Pos_Date();
  442. $date->setDate($yr, $mth, $dd);
  443. echo $date->getDayOrdinal(). " ". $date->getMonthName().", ". $date->getFullYear();
  444. //echo $row_emploeeRec['effectivedate'];
  445. }else{
  446. echo "Not set";
  447. }?>
  448. </td>
  449. </tr>
  450. <tr>
  451. <td>15.</td>
  452. <td><strong>Date of Confirmation:</strong></td>
  453. <td>
  454. <?php if(isset($row_confirmation['effectivedate'])){
  455. $yr=substr($row_confirmation['effectivedate'], 0,4);
  456. $mth =substr($row_confirmation['effectivedate'], 5,2);
  457. $dd=substr($row_confirmation['effectivedate'], 8,2);
  458. $date = new Pos_Date();
  459. $date->setDate($yr, $mth, $dd);
  460. echo $date->getDayOrdinal(). " ". $date->getMonthName().", ". $date->getFullYear();
  461. //echo $row_confirmation['effectivedate'];
  462. }else{
  463. echo "Not set";
  464. }?>
  465. </td>
  466. </tr>
  467. <tr>
  468. <td>16.</td>
  469. <td><strong>Present Rank and Salary:</strong></td>
  470. <td><?php
  471. if(isset($row_promotion['rank'])&& $row_promotion['rank']>0){
  472. $rankid= $row_promotion['rank'];
  473. $sql=mysql_query("select name from tblrank where rankid=$rankid");
  474. echo mysql_result($sql, 0, 'name');
  475. }
  476. ?></td>
  477. </tr>
  478. <tr>
  479. <td>17.</td>
  480. <td><strong>Qualifications, Educational Institutions with Dates:</strong></td>
  481. <td> <?php
  482. if($totalRows_qualifications<=0){ echo "Nil"; }?></td> </tr>
  483. <?php
  484. if($totalRows_qualifications>0){ ?>
  485. <tr><td>&nbsp;</td>
  486. <td colspan="2">
  487. <ol type="i">
  488. <?php do { ?>
  489. <li> <?php echo $row_qualifications['institutionobtained'].", ". $row_qualifications['certificate']. ", ";
  490. $yr=substr($row_qualifications['yearobtained'], 0,4);
  491. $mth =substr($row_qualifications['yearobtained'], 5,2);
  492. $dd=substr($row_qualifications['yearobtained'], 8,2);
  493. $date = new Pos_Date();
  494. $date->setDate($yr, $mth, $dd);
  495. echo $date->getMonthName().", ". $date->getFullYear();
  496. //.$row_qualifications['yearobtained']; ?>
  497. <?php }while($row_qualifications=mysql_fetch_assoc($qualifications)) ?>
  498. </ol>
  499. <?php } ?></td>
  500. </tr>
  501. <tr>
  502. <td>18.</td>
  503. <td><strong>Additional Qualifications/Education with Addresses & Dates</strong></td>
  504. <td> <?php
  505. if($totalRows__profQualification<=0){ echo "Nil"; }?></td> </tr>
  506. <?php
  507. if($totalRows__profQualification>0){ ?>
  508. <tr><td>&nbsp;</td>
  509. <td colspan="2">
  510. <ol type="i">
  511. <?php do { ?>
  512. <li> <?php echo $row__profQualification['institutionobtained'].", ". $row__profQualification['certificate']. ", ".$row__profQualification['institutionobtained'];
  513. $yr=substr($row__profQualification['yearobtained'], 0,4);
  514. $mth =substr($row__profQualification['yearobtained'], 5,2);
  515. $dd=substr($row__profQualification['yearobtained'], 8,2);
  516. $date = new Pos_Date();
  517. $date->setDate($yr, $mth, $dd);
  518. echo ", ".$date->getMonthName().", ". $date->getFullYear();
  519. ?>
  520. <?php }while($row__profQualification=mysql_fetch_assoc($profQualification)) ?>
  521. </ol>
  522. <?php } ?></td>
  523. </tr>
  524. </tr>
  525. <tr>
  526. <td>19.</td>
  527. <td><strong>Working Experience with Dates:</strong></td>
  528. <td> <?php
  529. if($totalRows_workexp<=0){ echo "Nil"; }?></td> </tr>
  530. <?php
  531. if($totalRows_workexp>0){ ?>
  532. <tr><td>&nbsp;</td>
  533. <td colspan="2">
  534. <ol type="i">
  535. <?php do { ?>
  536. <li> <?php echo $row_workexp['positionheld'].", ". $row_workexp['place']. ", From ";
  537. $yr=substr($row_workexp['from'], 0,4);
  538. $mth =substr($row_workexp['from'], 5,2);
  539. $dd=substr($row_workexp['from'], 8,2);
  540. $date = new Pos_Date();
  541. $date->setDate($yr, $mth, $dd);
  542. echo $date->getMonthName().", ". $date->getFullYear();
  543. echo " To ";
  544. $yr=substr($row_workexp['to'], 0,4);
  545. $mth =substr($row_workexp['to'], 5,2);
  546. $dd=substr($row_workexp['to'], 8,2);
  547. $date = new Pos_Date();
  548. $date->setDate($yr, $mth, $dd);
  549. echo $date->getMonthName().", ". $date->getFullYear();
  550. echo "<br />";
  551. echo "<b>Responsibilities:</b> ".$row_workexp['responsibilities']; ?></li>
  552. <?php }while($row_workexp=mysql_fetch_assoc($workexp)) ?>
  553. </ol>
  554. <?php } ?></td>
  555. </tr>
  556. <tr>
  557. <td>20.</td>
  558. <td><strong>Routine Teaching Experience with Dates:</strong></td>
  559. <td> <?php
  560. if($totalRows_teaching<=0){ echo "Nil"; }?></td> </tr>
  561. <?php
  562. if($totalRows_teaching>0){ ?>
  563. <tr><td>&nbsp;</td>
  564. <td colspan="2">
  565. <ol type="i">
  566. <?php do { ?>
  567. <li> <?php echo $row_teaching['coursecode']." - ". $row_teaching['title']." (". $row_teaching['session']." session) ". $row_teaching['level']." Student type: ". $row_teaching['level'];?></li>
  568. <?php }while($row_teaching=mysql_fetch_assoc($teaching)) ?>
  569. </ol>
  570. <?php } ?>
  571. </td>
  572. </tr>
  573. <tr>
  574. <td>21.</td>
  575. <td><strong>Research/Extension Experience and Dates:</strong></td>
  576. <td><?php ?></td>
  577. </tr>
  578. <tr>
  579. <td>22.</td>
  580. <td><strong>Routine Administrative Duties with Dates:</strong></td>
  581. <td> <?php
  582. if($totalRows_adminduties<=0){ echo "Nil"; }?></td> </tr>
  583. <?php
  584. if($totalRows_adminduties>0){ ?>
  585. <tr><td>&nbsp;</td>
  586. <td colspan="2">
  587. <ol type="i">
  588. <?php do { ?>
  589. <li> <?php echo $totalRows_adminduties['dutyname'].", ". $totalRows_adminduties['institution']." (". $totalRows_adminduties['dutylevel']."), From ". $totalRows_adminduties['datefrom']." To ". $totalRows_adminduties['dateto'];?></li>
  590. <?php }while($totalRows_adminduties=mysql_fetch_assoc($adminduties)) ?>
  591. </ol>
  592. <?php } ?>
  593. </td>
  594. </tr>
  595. </tr>
  596. <tr>
  597. <td>23.</td>
  598. <td><strong>Positions Held with Dates:</strong></td>
  599. <td> <?php
  600. if($totalRows_positions<=0){ echo "Nil"; }?></td> </tr>
  601. <?php
  602. if($totalRows_positions>0){ ?>
  603. <tr><td>&nbsp;</td>
  604. <td colspan="2">
  605. <ol type="i">
  606. <?php do { ?>
  607. <li> <?php echo $row_positions['position'].", (". $row_positions['capacity']. " capacity) ".$row_positions['place'].", From ";
  608. $yr=substr($row_positions['fromdate'], 0,4);
  609. $mth =substr($row_positions['fromdate'], 5,2);
  610. $dd=substr($row_positions['fromdate'], 8,2);
  611. $date = new Pos_Date();
  612. $date->setDate($yr, $mth, $dd);
  613. echo $date->getMonthName().", ". $date->getFullYear();
  614. echo " To ";
  615. $yr=substr($row_positions['todate'], 0,4);
  616. $mth =substr($row_positions['todate'], 5,2);
  617. $dd=substr($row_positions['todate'], 8,2);
  618. $date = new Pos_Date();
  619. $date->setDate($yr, $mth, $dd);
  620. echo $date->getMonthName().", ". $date->getFullYear();
  621. echo "<br />";?></li>
  622. <?php }while($row_positions=mysql_fetch_assoc($positions)) ?>
  623. </ol>
  624. <?php } ?>
  625. </td>
  626. </tr>
  627. <tr>
  628. <td>24.</td>
  629. <td><strong>Professional Service / Honour Societies:</strong></td>
  630. <td> <?php
  631. if($totalRows_profSoc<=0){ echo "Nil"; }?></td> </tr>
  632. <?php
  633. if($totalRows_profSoc>0){ ?>
  634. <tr><td>&nbsp;</td>
  635. <td colspan="2">
  636. <ol type="i">
  637. <?php do { ?>
  638. <li> <?php echo $row_profSoc['position'].", ". $row_profSoc['society'];?></li>
  639. <?php }while($row_profSoc=mysql_fetch_assoc($profSoc)) ?>
  640. </ol>
  641. <?php } ?>
  642. </td>
  643. </tr>
  644. <tr>
  645. <td>25.</td>
  646. <td><strong>Community Service:</strong></td>
  647. <td> <?php
  648. if($totalRows_commservice<=0){ echo "Nil"; }?></td> </tr>
  649. <?php
  650. if($totalRows_commservice>0){ ?>
  651. <tr><td>&nbsp;</td>
  652. <td colspan="2">
  653. <ol type="i">
  654. <?php do { ?>
  655. <li> <?php echo $row_commservice['description'].", (". $row_commservice['servicelevel']."), ".$row_commservice['beneficiary']." From ".$row_commservice['yearfrom']. " To ".$row_commservice['yearto'] ;?></li>
  656. <?php }while($row_commservice=mysql_fetch_assoc($commservice)) ?>
  657. </ol>
  658. <?php } ?>
  659. </td>
  660. </tr>
  661. <tr>
  662. <td>26.</td>
  663. <td><strong>International Conferences Attended:</strong></td>
  664. <td> <?php
  665. if($totalRows_internationalconf<=0){ echo "Nil"; }?></td> </tr>
  666. <?php
  667. if($totalRows_internationalconf>0){ ?>
  668. <tr><td>&nbsp;</td>
  669. <td colspan="2">
  670. <ol type="i">
  671. <?php do { ?>
  672. <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>
  673. <?php }while($row_internationalconf=mysql_fetch_assoc($internationalconf)) ?>
  674. </ol>
  675. <?php } ?>
  676. </td>
  677. </tr>
  678. <tr>
  679. <td>27.</td>
  680. <td><strong>Local Conferences Attended/Organized with Dates:</strong></td>
  681. <td> <?php
  682. if($totalRows_localconferences<=0){ echo "Nil"; }?></td> </tr>
  683. <?php
  684. if($totalRows_localconferences>0){ ?>
  685. <tr><td>&nbsp;</td>
  686. <td colspan="2">
  687. <ol type="i">
  688. <?php do { ?>
  689. <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>
  690. <?php }while($row_localconferences=mysql_fetch_assoc($localconferences)) ?>
  691. </ol>
  692. <?php } ?>
  693. </td>
  694. </tr>
  695. <tr>
  696. <td>28.</td>
  697. <td><strong>Publications/Articles:</strong></td>
  698. <td> <?php
  699. if($totalRows_publications<=0 || $totalRows_cpublications<=0){ echo "Nil"; }?></td> </tr>
  700. <tr><td>&nbsp;</td>
  701. <?php if($totalRows_publications>0){ ?>
  702. <td colspan="2"> <strong> In peer-reviewed journals </strong>
  703. <ol type="i">
  704. <?php do { ?>
  705. <li>
  706. <?php
  707. echo $row_publications['authors'];
  708. echo " (". substr($row_publications['publicationdate'], 0, 4).") \"".$row_publications['title']."\". <i><strong> ".$row_publications['journalname'].".</strong></i> ";
  709. if(isset($row_publications['vol'])&& $row_publications['vol']>0){
  710. echo $row_publications['vol'];
  711. }
  712. if(isset($row_publications['num']) && $row_publications['num']>0){
  713. echo " (";
  714. echo $row_publications['num'];
  715. echo ")";
  716. }
  717. if(isset($row_publications['pages']) && $row_publications['pages'] !=""){
  718. echo ":".$row_publications['pages'] ;
  719. } ?>
  720. </li>
  721. <?php }while($row_publications=mysql_fetch_assoc($publications)) ?>
  722. </ol>
  723. <?php } ?>
  724. </td></tr>
  725. <?php if($totalRows_cpublications>0){ ?>
  726. <tr><td>&nbsp; </td>
  727. <td colspan="2"> <strong> In Conference Proceedings </strong>
  728. <ol type="i">
  729. <?php do { ?>
  730. <li>
  731. <?php
  732. echo $row_cpublications['authors'];
  733. echo " (". substr($row_cpublications['publicationdate'], 0, 4).") \"".$row_cpublications['title']."\". <i><strong> ".$row_cpublications['journalname'].".</strong></i> ";
  734. if(isset($row_cpublications['vol'])&& $row_pcublications['vol']>0){
  735. echo $row_cpublications['vol'];
  736. }
  737. if(isset($row_cpublications['num']) && $row_cpublications['num']>0){
  738. echo " (";
  739. echo $row_cpublications['num'];
  740. echo ")";
  741. }
  742. if(isset($row_cpublications['pages']) && $row_cpublications['pages'] !=""){
  743. echo ": ".$row_cpublications['pages'] ;
  744. }
  745. ?></li>
  746. <?php }while($row_cpublications=mysql_fetch_assoc($cpublications)) ?>
  747. </ol>
  748. <?php } ?>
  749. </tr>
  750. <tr>
  751. <td>29.</td>
  752. <td><strong>Invention/Innovation/Award:</strong></td>
  753. <td> <?php
  754. if($totalRows_tblinventions <=0){ echo "Nil"; }?></td> </tr>
  755. <?php
  756. if($totalRows_tblinventions>0){ ?>
  757. <tr><td>&nbsp;</td>
  758. <td colspan="2">
  759. <ol type="i">
  760. <?php do { ?>
  761. <li> <?php echo ucfirst($row_tblinventions['invention'])." - ". $row_tblinventions['description'].", ". $row_tblinventions['year'].".";
  762. if(isset($row_tblinventions['patentref']) && trim($row_tblinventions['patentref']) !=''){
  763. echo "<b> Patent Reference Number: ".$row_tblinventions['patentref'] ."</b>" ;
  764. }?></li>
  765. <?php }while($row_tblinventions = mysql_fetch_assoc($Recordset1)) ?>
  766. </ol>
  767. <?php } ?>
  768. </td>
  769. </tr>
  770. <tr>
  771. <td>30.</td>
  772. <td><strong>Citation in "Who-is-Who", etc:</strong></td>
  773. <td> <?php
  774. if($totalRows_tblwhoiswho <=0){ echo "Nil"; }?></td> </tr>
  775. <?php
  776. if($totalRows_tblwhoiswho>0){ ?>
  777. <tr><td>&nbsp;</td>
  778. <td colspan="2">
  779. <ol type="i">
  780. <?php do { ?>
  781. <li> <?php echo ucfirst($row_tblwhoiswho['achivement'])." - ". $row_tblwhoiswho['year'];?></li>
  782. <?php }while($row_tblwhoiswho = mysql_fetch_assoc($Recordset1)) ?>
  783. </ol>
  784. <?php } ?>
  785. </td>
  786. </tr>
  787. <tr>
  788. <td>31.</td>
  789. <td><strong>Additional Publications since Last Promotion:</strong></td>
  790. <td> <?php
  791. if($totalRows_publicationsp<=0 || $totalRows_cpublicationsp<=0){ echo "Nil"; }?></td> </tr>
  792. <tr><td>&nbsp;</td>
  793. <?php if($totalRows_publicationsp>0){ ?>
  794. <td colspan="2"> <strong> In peer-reviewed journals </strong>
  795. <ol type="i">
  796. <?php do { ?>
  797. <li>
  798. <?php
  799. echo $row_publicationsp['authors'];
  800. echo " (". substr($row_publicationsp['publicationdate'], 0, 4).") \"".$row_publicationsp['title']."\". <i><strong> ".$row_publicationsp['journalname'].".</strong></i> ";
  801. if(isset($row_publicationsp['vol'])&& $row_publicationsp['vol']>0){
  802. echo $row_publicationsp['vol'];
  803. }
  804. if(isset($row_publicationsp['num']) && $row_publicationsp['num']>0){
  805. echo " (";
  806. echo $row_publicationsp['num'];
  807. echo ")";
  808. }
  809. if(isset($row_publicationsp['pages']) && $row_publicationsp['pages'] !=""){
  810. echo ":".$row_publicationsp['pages'] ;
  811. } ?>
  812. </li>
  813. <?php }while($row_publicationsp=mysql_fetch_assoc($publicationsp)) ?>
  814. </ol>
  815. <?php } ?>
  816. </td></tr>
  817. <?php if($totalRows_cpublicationsp>0){ ?>
  818. <tr><td>&nbsp; </td>
  819. <td colspan="2"> <strong> In Conference Proceedings </strong>
  820. <ol type="i">
  821. <?php do { ?>
  822. <li>
  823. <?php
  824. echo $row_cpublicationsp['authors'];
  825. echo " (". substr($row_cpublicationsp['publicationdate'], 0, 4).") \"".$row_cpublicationsp['title']."\". <i><strong> ".$row_cpublicationsp['journalname'].".</strong></i> ";
  826. if(isset($row_cpublicationsp['vol'])&& $row_cpublicationsp['vol']>0){
  827. echo $row_cpublicationsp['vol'];
  828. }
  829. if(isset($row_cpublicationsp['num']) && $row_cpublicationsp['num']>0){
  830. echo " (";
  831. echo $row_cpublicationsp['num'];
  832. echo ")";
  833. }
  834. if(isset($row_cpublicationsp['pages']) && $row_cpublicationsp['pages'] !=""){
  835. echo ":".$row_cpublicationsp['pages'] ;
  836. } ?>
  837. </li>
  838. <?php }while($row_cpublicationsp=mysql_fetch_assoc($cpublicationsp)) ?>
  839. </ol>
  840. <?php } ?>
  841. </tr>
  842. <tr>
  843. <td>32.</td>
  844. <td><strong>Hobbies:</strong></td>
  845. <td> <?php
  846. if($totalRows_tblhobbies <=0){ echo "Nil"; }?></td> </tr>
  847. <?php
  848. if($totalRows_tblhobbies>0){ ?>
  849. <tr><td>&nbsp;</td>
  850. <td colspan="2">
  851. <ol type="i">
  852. <?php for($i=0;$i<$totalRows_tblhobbies; $i++) { ?>
  853. <li> <?php echo ucfirst(mysql_result($hobby,$i, 'hobby'))?></li>
  854. <?php } while($row_tblhobbies = mysql_fetch_assoc($Recordset1)) ?>
  855. </ol>
  856. <?php } ?>
  857. </td> </tr>
  858. <tr>
  859. <td>33.</td>
  860. <td><strong>Names and Addresses of Three Referees:</strong></td>
  861. <td> <?php
  862. if($totalRows_tblreferees2 <=0){ echo "Nil"; }?></td> </tr>
  863. <?php
  864. if($totalRows_tblreferees2>0){ ?>
  865. <tr><td>&nbsp;</td>
  866. <td colspan="2">
  867. <ol type="i">
  868. <?php do { ?>
  869. <li> <?php echo "<strong>".ucfirst($row_tblreferees['title'])." ". $row_tblreferees['Fullname']. "</strong><br/>";
  870. echo $row_tblreferees['position']. "<br />";
  871. echo $row_tblreferees['address']. "<br />";
  872. echo $row_tblreferees['email']. "<br />";
  873. echo $row_tblreferees['mobile']. "<br /><br />";
  874. ?></li>
  875. <?php }while($row_tblreferees = mysql_fetch_assoc($Recordset2)) ?>
  876. </ol>
  877. <?php } ?>
  878. </td>
  879. </tr>
  880. </table>
  881. <p align="center">&nbsp;</p>
  882. </div>
  883. </div>
  884. </body>
  885. </html>