PageRenderTime 48ms CodeModel.GetById 18ms RepoModel.GetById 0ms app.codeStats 1ms

/promotion/summary/computecv.php

https://bitbucket.org/lecturer34/hrmis
PHP | 712 lines | 596 code | 87 blank | 29 comment | 63 complexity | 9f8bbdd693fb7f7debf1470ae94a12a4 MD5 | raw file
Possible License(s): LGPL-2.1
  1. <!DOCTYPE html>
  2. <html lang="en">
  3. <head>
  4. <meta charset="utf-8">
  5. <title>Promotion Summary</title>
  6. <style type="text/css">
  7. </style>
  8. <link href="bootstrap.min.css" rel="stylesheet">
  9. </head>
  10. <body >
  11. <?php
  12. session_start();
  13. require_once('../../lib/globals.php');
  14. require_once('../../lib/database.php');
  15. openConnection();
  16. require_once('../func.php');
  17. require_once('../promotionfunctions.php');
  18. //require_once("../../partials/cssimports.php");
  19. /*
  20. $_SESSION['A_complex'] = sanitizeInput($_POST['complex']);
  21. $_SESSION['A_cadre'] = sanitizeInput($_POST['cadre']);
  22. $_SESSION['A_faculty'] = sanitizeInput($_POST['faculty']);
  23. $_SESSION['A_dept'] = sanitizeInput($_POST['dept']);
  24. $_SESSION['A_year'] = sanitizeInput($_POST['year']);
  25. */
  26. $complex = $_GET['complex'];
  27. $cadre = $_GET['cadre'];
  28. $faculty = $_GET['faculty'];
  29. $dept = $_GET['dept'];
  30. $year = $_GET['year'];
  31. $employeeid=$_GET['employeeid'];
  32. if($complex==""){$complex="%";}
  33. if($cadre==""){$cadre="%";}
  34. if($dept==""){$dept="%";}
  35. if($faculty==""){$faculty="%";}
  36. //echo $complex." ".$cadre." ".$faculty." ".$dept." ".$year."".$employeeid;
  37. if($employeeid == "All")
  38. {
  39. $query = "SELECT tblemployee.employeeid, tblfaccentres.complexid,tbldepartment.departmentid,
  40. tblrank.cadreid FROM tblrecommendations INNER JOIN
  41. tblemployee ON tblemployee.employeeid = tblrecommendations.employeeid INNER JOIN
  42. tbldepartment ON tbldepartment.departmentid = tblemployee.department INNER JOIN
  43. tblfaccentres ON tblfaccentres.facultyid = tbldepartment.facultyid INNER JOIN
  44. tblrank ON tblrank.rankid = tblrecommendations.rankinview INNER JOIN
  45. tblcadre ON tblcadre.cadreid = tblrank.cadreid
  46. WHERE (tblcadre.cadreid like '$cadre' and tbldepartment.departmentid like '$dept' and tblrecommendations.year = '$year')";
  47. //echo $query;
  48. $result = @mysql_query($query) or die(mysql_error());
  49. if (mysql_num_rows($result)>0){
  50. while ($row = mysql_fetch_array($result)){
  51. $employeeid1 = $row['employeeid'];
  52. $departmentid = $row['departmentid'];
  53. $complexid1 = $row['complexid'];
  54. $cadreid1 = $row['cadreid'];
  55. //echo" sumary for $employeeid<br>";
  56. generatecv($employeeid1, $year);
  57. }
  58. }
  59. }
  60. else
  61. {
  62. //specific personnel get his data
  63. $query = "SELECT tblpromotions.personnelno, tblemployee.employeeid, tblfaccentres.complexid,tbldepartment.departmentid,
  64. tblrank.cadreid FROM tblpromotions INNER JOIN
  65. tblemployee ON tblemployee.employeeid = tblpromotions.employeeid INNER JOIN
  66. tbldepartment ON tbldepartment.departmentid = tblemployee.department INNER JOIN
  67. tblfaccentres ON tblfaccentres.facultyid = tbldepartment.facultyid INNER JOIN
  68. tblrecommendations ON tblrecommendations.employeeid = tblemployee.employeeid INNER JOIN
  69. tblrank ON tblrank.rankid = tblpromotions.rank INNER JOIN
  70. tblcadre ON tblcadre.cadreid = tblrank.cadreid
  71. WHERE (tblemployee.employeeid='$employeeid' and tblcadre.cadreid like '$cadre' and tbldepartment.departmentid like '$dept' and tblrecommendations.year = '$year')";
  72. //echo $query;
  73. $result = @mysql_query($query) or die(mysql_error());
  74. if (mysql_num_rows($result)>0){
  75. $employeeid1 = mysql_result($result,0,'employeeid');
  76. $departmentid = mysql_result($result,0,'departmentid');
  77. $complexid1 = mysql_result($result,0,'complexid');
  78. $cadreid1 =mysql_result($result,0,'cadreid');
  79. generatecv($employeeid1, $year);
  80. }
  81. else
  82. {
  83. echo"Staff not yet initialized for $year Promotion Exercise";
  84. }
  85. }
  86. //end
  87. ?>
  88. <?php
  89. //if (!function_exists("GetSQLValueString")) {
  90. function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
  91. {
  92. if (PHP_VERSION < 6) {
  93. $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  94. }
  95. $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
  96. switch ($theType) {
  97. case "text":
  98. $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
  99. break;
  100. case "long":
  101. case "int":
  102. $theValue = ($theValue != "") ? intval($theValue) : "NULL";
  103. break;
  104. case "double":
  105. $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
  106. break;
  107. case "date":
  108. $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
  109. break;
  110. case "defined":
  111. $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
  112. break;
  113. }
  114. return $theValue;
  115. }
  116. //}
  117. function generatecv($employeeid,$year)
  118. {
  119. $employid_emploeeRec=$employeeid;
  120. $query_emploeeRec = sprintf("SELECT tblemployee.firstname, tblemployee.surname, tblemployee.othernames, tblemployee.dateoffirstappointment,
  121. tblemployee.salaryonappointment, countryname, tblemployee.dateofbirth, tblemployee.placeofbirth, tblemployee.maritalstatus,
  122. tblemployee.gender, tblemployee.permanentaddress, tbldepartment.name as department, tblstate.statename as state, tbllga.lganame as lga,
  123. tblrank.name as rank FROM tblemployee, tblconfirmation, tbldepartment, tblrank, tblstate, tbllga, tblcountries
  124. WHERE tblemployee.department=tbldepartment.departmentid AND tblemployee.rankonemployment=tblrank.rankid AND tblemployee.lgaoforigin=tbllga.lgaid AND
  125. tbllga.stateid=tblstate.stateid AND tblemployee.nationality=tblcountries.countryid AND tblemployee.employeeid=%s",
  126. GetSQLValueString($employid_emploeeRec, "int"));
  127. $emploeeRec = mysql_query($query_emploeeRec) or die(mysql_error());
  128. $row_emploeeRec = mysql_fetch_assoc($emploeeRec);
  129. $totalRows_emploeeRec = mysql_num_rows($emploeeRec);
  130. $colname_confirmation = "-1";
  131. if (isset($employeeid)) {
  132. $colname_confirmation = $employeeid;
  133. }
  134. $query_confirmation = sprintf("SELECT effectivedate FROM tblconfirmation WHERE employeeid = %s", GetSQLValueString($colname_confirmation, "int"));
  135. $confirmation = mysql_query($query_confirmation) or die(mysql_error());
  136. $row_confirmation = mysql_fetch_assoc($confirmation);
  137. $totalRows_confirmation = mysql_num_rows($confirmation);
  138. $colname_promotion = "-1";
  139. if (isset($employeeid)) {
  140. $colname_promotion = $employeeid;
  141. }
  142. $query_promotion = sprintf("SELECT personnelno, rank, salaryid, effectivedate FROM tblpromotions WHERE employeeid = %s", GetSQLValueString($colname_promotion, "int"));
  143. $promotion = mysql_query($query_promotion) or die(mysql_error());
  144. $row_promotion = mysql_fetch_assoc($promotion);
  145. $totalRows_promotion = mysql_num_rows($promotion);
  146. $colname_contactaddr = "-1";
  147. if (isset($employeeid)) {
  148. $colname_contactaddr = $employeeid;
  149. }
  150. $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"));
  151. $contactaddr = mysql_query($query_contactaddr) or die(mysql_error());
  152. $row_contactaddr = mysql_fetch_assoc($contactaddr);
  153. $totalRows_contactaddr = mysql_num_rows($contactaddr);
  154. $colname_workexp = "-1";
  155. if (isset($employeeid)) {
  156. $colname_workexp = $employeeid;
  157. }
  158. $query_workexp = sprintf("SELECT * FROM tblempworkingexp WHERE employeeid = %s ORDER BY `from` DESC", GetSQLValueString($colname_workexp, "int"));
  159. $workexp = mysql_query($query_workexp) or die(mysql_error());
  160. $row_workexp = mysql_fetch_assoc($workexp);
  161. $totalRows_workexp = mysql_num_rows($workexp);
  162. $colname_qualifications = "-1";
  163. if (isset($employeeid)) {
  164. $colname_qualifications = $employeeid;
  165. }
  166. $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"));
  167. $qualifications = mysql_query($query_qualifications) or die(mysql_error());
  168. $row_qualifications = mysql_fetch_assoc($qualifications);
  169. $totalRows_qualifications = mysql_num_rows($qualifications);
  170. $colname__profQualification = "-1";
  171. if (isset($employeeid)){
  172. $colname__profQualification = $employeeid;
  173. }
  174. $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"));
  175. $profQualification = mysql_query($query__profQualification) or die(mysql_error());
  176. $row__profQualification = mysql_fetch_assoc($profQualification);
  177. $totalRows__profQualification = mysql_num_rows($profQualification);
  178. $colname_languages = "-1";
  179. if (isset($employeeid)) {
  180. $colname_languages = $employeeid;
  181. }
  182. $query_languages = sprintf("SELECT * FROM tbllanguagesspoken WHERE employeeid = %s", GetSQLValueString($colname_languages, "int"));
  183. $languages = mysql_query($query_languages) or die(mysql_error());
  184. $row_languages = mysql_fetch_assoc($languages);
  185. $totalRows_languages = mysql_num_rows($languages);
  186. $colname_positions = "-1";
  187. if (isset($employeeid)) {
  188. $colname_positions = $employeeid;
  189. }
  190. $query_positions = sprintf("SELECT * FROM tblpositionsheld WHERE employeeid = %s", GetSQLValueString($colname_positions, "int"));
  191. $positions = mysql_query($query_positions) or die(mysql_error());
  192. $row_positions = mysql_fetch_assoc($positions);
  193. $totalRows_positions = mysql_num_rows($positions);
  194. $colname_profSoc = "-1";
  195. if (isset($employeeid)) {
  196. $colname_profSoc = $employeeid;
  197. }
  198. $query_profSoc = sprintf("SELECT * FROM tblprofmembership WHERE employeeid = %s", GetSQLValueString($colname_profSoc, "int"));
  199. $profSoc = mysql_query($query_profSoc) or die(mysql_error());
  200. $row_profSoc = mysql_fetch_assoc($profSoc);
  201. $totalRows_profSoc = mysql_num_rows($profSoc);
  202. $colname_teaching = "-1";
  203. if (isset($employeeid)) {
  204. $colname_teaching = $employeeid;
  205. }
  206. $query_teaching = sprintf("SELECT * FROM tblteaching WHERE employeeid = %s", GetSQLValueString($colname_teaching, "int"));
  207. $teaching = mysql_query($query_teaching) or die(mysql_error());
  208. $row_teaching = mysql_fetch_assoc($teaching);
  209. $totalRows_teaching = mysql_num_rows($teaching);
  210. $colname_adminduties = "-1";
  211. if (isset($employeeid)) {
  212. $colname_adminduties = $employeeid;
  213. }
  214. $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"));
  215. $adminduties = mysql_query($query_adminduties) or die(mysql_error());
  216. $row_adminduties = mysql_fetch_assoc($adminduties);
  217. $totalRows_adminduties = mysql_num_rows($adminduties);
  218. $colname_localconferences = "-1";
  219. if (isset($employeeid)) {
  220. $colname_localconferences = $employeeid;
  221. }
  222. $query_localconferences = sprintf("SELECT * FROM tblconferences WHERE employeeid = %s AND tblconferences.conferencetype='local' ORDER BY datefrom DESC", GetSQLValueString($colname_localconferences, "int"));
  223. //echo $query_localconferences; exit;
  224. $localconferences = mysql_query($query_localconferences) or die(mysql_error());
  225. $row_localconferences = mysql_fetch_assoc($localconferences);
  226. $totalRows_localconferences = mysql_num_rows($localconferences);
  227. $colname_internationalconf = "-1";
  228. if (isset($employeeid)) {
  229. $colname_internationalconf = $employeeid;
  230. }
  231. $query_internationalconf = sprintf("SELECT * FROM tblconferences WHERE employeeid = %s AND tblconferences.conferencetype='international' ORDER BY datefrom DESC", GetSQLValueString($colname_internationalconf, "int"));
  232. $internationalconf = mysql_query($query_internationalconf) or die(mysql_error());
  233. $row_internationalconf = mysql_fetch_assoc($internationalconf);
  234. $totalRows_internationalconf = mysql_num_rows($internationalconf);
  235. $emplid_publications = "-1";
  236. if (isset($employeeid)) {
  237. $emplid_publications = $employeeid;
  238. }
  239. $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"));
  240. $publications = mysql_query($query_publications) or die(mysql_error());
  241. $row_publications = mysql_fetch_assoc($publications);
  242. $totalRows_publications = mysql_num_rows($publications);
  243. $emplid_cpublications = "-1";
  244. if (isset($employeeid)) {
  245. $emplid_cpublications = $employeeid;
  246. }
  247. $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"));
  248. $cpublications = mysql_query($query_cpublications) or die(mysql_error());
  249. $row_cpublications = mysql_fetch_assoc($cpublications);
  250. $totalRows_cpublications = mysql_num_rows($cpublications);
  251. $colname_commservice = "-1";
  252. if (isset($employeeid)) {
  253. $colname_commservice = $employeeid;
  254. }
  255. $query_commservice = sprintf("SELECT * FROM tblcommunityservice WHERE employeeid = %s", GetSQLValueString($colname_commservice, "int"));
  256. $commservice = mysql_query($query_commservice) or die(mysql_error());
  257. $row_commservice = mysql_fetch_assoc($commservice);
  258. $totalRows_commservice = mysql_num_rows($commservice);
  259. $query_pubtypes = "SELECT * FROM tblpublictiontype ORDER BY publictiontypeid ASC";
  260. $pubtypes = mysql_query($query_pubtypes) or die(mysql_error());
  261. $row_pubtypes = mysql_fetch_assoc($pubtypes);
  262. $totalRows_pubtypes = mysql_num_rows($pubtypes);
  263. /*
  264. $pubtypes = array();
  265. for($i=0; $i<$totalRows_publications; $i++){
  266. $pubtypes[]=$row_pubtypes['eventoractivity'];
  267. }
  268. var_dump($pubtypes);
  269. exit;
  270. */
  271. ?>
  272. <?php
  273. //include("footer.html");
  274. ?>
  275. </p>
  276. <h1 align="center">CURRICULUM VITAE</h1>
  277. <table width="97%" border="0">
  278. <tr>
  279. <td>1.</td>
  280. <td width="40%"><strong>Name in Full:</strong></td>
  281. <td><?php echo strtoupper($row_emploeeRec['surname']).", ". ucfirst(strtolower($row_emploeeRec['firstname'])). " ". ucfirst(strtolower($row_emploeeRec['othernames'])); ?></td>
  282. </tr>
  283. <tr>
  284. <td>2.</td>
  285. <td><strong>Personnel No:</strong></td>
  286. <td><?php echo $row_promotion['personnelno']; ?></td>
  287. </tr>
  288. <tr>
  289. <td>3.</td>
  290. <td><strong>Department:</strong></td>
  291. <td><?php echo $row_emploeeRec['department']; ?></td>
  292. </tr>
  293. <tr>
  294. <td>4.</td>
  295. <td><strong>Date and Place of Birth:</strong></td>
  296. <td><?php echo $row_emploeeRec['dateofbirth']; ?><?php echo $row_emploeeRec['placeofbirth']; ?></td>
  297. </tr>
  298. <tr>
  299. <td>5.</td>
  300. <td><strong>State of Origin;</strong></td>
  301. <td><?php echo $row_emploeeRec['state']; ?></td>
  302. </tr>
  303. <tr>
  304. <td>6.</td>
  305. <td><strong>Local Government of Origin:</strong></td>
  306. <td><?php echo $row_emploeeRec['lga']; ?></td>
  307. </tr>
  308. <tr>
  309. <td>7.</td>
  310. <td><strong>Nationality:</strong></td>
  311. <td><?php echo $row_emploeeRec['countryname']; ?></td>
  312. </tr>
  313. <tr>
  314. <td>8.</td>
  315. <td><strong>Marital Status:</strong></td>
  316. <td><?php echo $row_emploeeRec['maritalstatus']; ?></td>
  317. </tr>
  318. <tr>
  319. <td>9.</td>
  320. <td><strong>Gender:</strong></td>
  321. <td><?php echo $row_emploeeRec['gender']; ?></td>
  322. </tr>
  323. <tr>
  324. <td>10.</td>
  325. <td><strong>International Languages Spoken:</strong></td>
  326. <td>
  327. <?php if($totalRows_languages>0){
  328. do {
  329. echo $row_languages['language']. ", ";
  330. }while($row_languages = mysql_fetch_assoc($languages));
  331. }else{
  332. echo "Nil";
  333. }
  334. ?>
  335. </td>
  336. </tr>
  337. <tr>
  338. <td>11.</td>
  339. <td><strong>Current Contact Address:</strong></td>
  340. <td><?php
  341. if($totalRows_contactaddr>0){
  342. echo $row_contactaddr['contactaddress']."<br />";
  343. echo $row_contactaddr['city']."<br />";
  344. echo $row_contactaddr['statename']." State<br />";
  345. //echo $row_contactaddr['zip']."<br />";
  346. }
  347. ?></td>
  348. </tr>
  349. <tr>
  350. <td>12.</td>
  351. <td><strong>Permanent Home Address:</strong></td>
  352. <td>
  353. <?php if(isset($row_emploeeRec['permanentaddress']) && strlen(trim($row_emploeeRec['permanentaddress'])) !=0){
  354. echo $row_emploeeRec['permanentaddress'];
  355. }else{
  356. echo "<b>Not set</b>";
  357. }?>
  358. </td>
  359. </tr>
  360. <tr>
  361. <td>13.</td>
  362. <td><strong>Date of First Appointment with the University:</strong></td>
  363. <td><?php if(isset($row_emploeeRec['dateoffirstappointment'])){
  364. echo $row_emploeeRec['dateoffirstappointment'];
  365. }else{
  366. echo "Not set";
  367. }?></td>
  368. </tr>
  369. <td>14.</td>
  370. <td><strong>Date of Last Promotion:</strong></td>
  371. <td><?php if(isset($row_emploeeRec['effectivedate'])){
  372. echo $row_emploeeRec['effectivedate'];
  373. }else{
  374. echo "Not set";
  375. }?>
  376. </td>
  377. </tr>
  378. <tr>
  379. <td>15.</td>
  380. <td><strong>Date of Confirmation:</strong></td>
  381. <td>
  382. <?php if(isset($row_confirmation['effectivedate'])){
  383. echo $row_confirmation['effectivedate'];
  384. }else{
  385. echo "Not set";
  386. }?>
  387. </td>
  388. </tr>
  389. <tr>
  390. <td>16.</td>
  391. <td><strong>Present Rank and Salary:</strong></td>
  392. <td><?php
  393. if(isset($row_promotion['rank'])&& $row_promotion['rank']>0){
  394. $rankid= $row_promotion['rank'];
  395. $sql=mysql_query("select name from tblrank where rankid=$rankid");
  396. echo mysql_result($sql, 0, 'name');
  397. }
  398. ?></td>
  399. </tr>
  400. <tr>
  401. <td>17.</td>
  402. <td><strong>Qualifications, Educational Institutions with Dates:</strong></td>
  403. <td> <?php
  404. if($totalRows_qualifications<=0){ echo "Nil"; }?></td> </tr>
  405. <?php
  406. if($totalRows_qualifications>0){ ?>
  407. <tr><td>&nbsp;</td>
  408. <td colspan="2">
  409. <ol type="i">
  410. <?php do { ?>
  411. <li> <?php echo $row_qualifications['institutionobtained'].", ". $row_qualifications['certificate']. ", ".$row_qualifications['yearobtained']; ?>
  412. <?php }while($row_qualifications=mysql_fetch_assoc($qualifications)) ?>
  413. </ol>
  414. <?php } ?></td>
  415. </tr>
  416. <tr>
  417. <td>18.</td>
  418. <td><strong>Additional Qualifications/Education with Addresses & Dates</strong></td>
  419. <td> <?php
  420. if($totalRows__profQualification<=0){ echo "Nil"; }?></td> </tr>
  421. <?php
  422. if($totalRows__profQualification>0){ ?>
  423. <tr><td>&nbsp;</td>
  424. <td colspan="2">
  425. <ol type="i">
  426. <?php do { ?>
  427. <li> <?php echo $row__profQualification['institutionobtained'].", ". $row__profQualification['certificate']. ", ".$row__profQualification['institutionobtained']; ?>
  428. <?php }while($row__profQualification=mysql_fetch_assoc($profQualification)) ?>
  429. </ol>
  430. <?php } ?></td>
  431. </tr>
  432. </tr>
  433. <tr>
  434. <td>19.</td>
  435. <td><strong>Working Experience with Dates:</strong></td>
  436. <td> <?php
  437. if($totalRows_workexp<=0){ echo "Nil"; }?></td> </tr>
  438. <?php
  439. if($totalRows_workexp>0){ ?>
  440. <tr><td>&nbsp;</td>
  441. <td colspan="2">
  442. <ol type="i">
  443. <?php do { ?>
  444. <li> <?php echo $row_workexp['positionheld'].", ". $row_workexp['place']. ", From ".$row_workexp['from']. " To ". $row_workexp['to']. "<br />";
  445. echo "<b>Responsibilities:</b> ".$row_workexp['responsibilities']; ?></li>
  446. <?php }while($row_workexp=mysql_fetch_assoc($workexp)) ?>
  447. </ol>
  448. <?php } ?></td>
  449. </tr>
  450. <tr>
  451. <td>20.</td>
  452. <td><strong>Routine Teaching Experience with Dates:</strong></td>
  453. <td> <?php
  454. if($totalRows_teaching<=0){ echo "Nil"; }?></td> </tr>
  455. <?php
  456. if($totalRows_teaching>0){ ?>
  457. <tr><td>&nbsp;</td>
  458. <td colspan="2">
  459. <ol type="i">
  460. <?php do { ?>
  461. <li> <?php echo $row_teaching['coursecode']." - ". $row_teaching['title']." (". $row_teaching['session'].") ". $row_teaching['level']." Student type: ". $row_teaching['level'];?></li>
  462. <?php }while($row_teaching=mysql_fetch_assoc($teaching)) ?>
  463. </ol>
  464. <?php } ?>
  465. </td>
  466. </tr>
  467. <tr>
  468. <td>21.</td>
  469. <td><strong>Research/Extension Experience and Dates:</strong></td>
  470. <td><?php ?></td>
  471. </tr>
  472. <tr>
  473. <td>22.</td>
  474. <td><strong>Routine Administrative Duties with Dates:</strong></td>
  475. <td> <?php
  476. if($totalRows_adminduties<=0){ echo "Nil"; }?></td> </tr>
  477. <?php
  478. if($totalRows_adminduties>0){ ?>
  479. <tr><td>&nbsp;</td>
  480. <td colspan="2">
  481. <ol type="i">
  482. <?php do { ?>
  483. <li> <?php echo $totalRows_adminduties['dutyname'].", ". $totalRows_adminduties['institution']." (". $totalRows_adminduties['dutylevel']."), From ". $totalRows_adminduties['datefrom']." To ". $totalRows_adminduties['dateto'];?></li>
  484. <?php }while($totalRows_adminduties=mysql_fetch_assoc($adminduties)) ?>
  485. </ol>
  486. <?php } ?>
  487. </td>
  488. </tr>
  489. </tr>
  490. <tr>
  491. <td>23.</td>
  492. <td><strong>Positions Held with Dates:</strong></td>
  493. <td> <?php
  494. if($totalRows_positions<=0){ echo "Nil"; }?></td> </tr>
  495. <?php
  496. if($totalRows_positions>0){ ?>
  497. <tr><td>&nbsp;</td>
  498. <td colspan="2">
  499. <ol type="i">
  500. <?php do { ?>
  501. <li> <?php echo $row_positions['position'].", (". $row_positions['capacity']. "".$row_positions['place'].", From ".$row_positions['fromdate']. " To ". $row_positions['todate']. "<br />";?></li>
  502. <?php }while($row_positions=mysql_fetch_assoc($positions)) ?>
  503. </ol>
  504. <?php } ?>
  505. </td>
  506. </tr>
  507. <tr>
  508. <td>24.</td>
  509. <td><strong>Professional Service / Honour Societies:</strong></td>
  510. <td> <?php
  511. if($totalRows_profSoc<=0){ echo "Nil"; }?></td> </tr>
  512. <?php
  513. if($totalRows_profSoc>0){ ?>
  514. <tr><td>&nbsp;</td>
  515. <td colspan="2">
  516. <ol type="i">
  517. <?php do { ?>
  518. <li> <?php echo $row_profSoc['position'].", ". $row_profSoc['society'];?></li>
  519. <?php }while($row_profSoc=mysql_fetch_assoc($profSoc)) ?>
  520. </ol>
  521. <?php } ?>
  522. </td>
  523. </tr>
  524. <tr>
  525. <td>25.</td>
  526. <td><strong>Community Service:</strong></td>
  527. <td> <?php
  528. if($totalRows_commservice<=0){ echo "Nil"; }?></td> </tr>
  529. <?php
  530. if($totalRows_commservice>0){ ?>
  531. <tr><td>&nbsp;</td>
  532. <td colspan="2">
  533. <ol type="i">
  534. <?php do { ?>
  535. <li> <?php echo $row_commservice['description'].", (". $row_commservice['servicelevel']."), ".$row_commservice['beneficiary']." From ".$row_commservice['yearfrom']. " To ".$row_commservice['yearto'] ;?></li>
  536. <?php }while($row_commservice=mysql_fetch_assoc($commservice)) ?>
  537. </ol>
  538. <?php } ?>
  539. </td>
  540. </tr>
  541. <tr>
  542. <td>26.</td>
  543. <td><strong>International Conferences Attended:</strong></td>
  544. <td> <?php
  545. if($totalRows_internationalconf<=0){ echo "Nil"; }?></td> </tr>
  546. <?php
  547. if($totalRows_internationalconf>0){ ?>
  548. <tr><td>&nbsp;</td>
  549. <td colspan="2">
  550. <ol type="i">
  551. <?php do { ?>
  552. <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>
  553. <?php }while($row_internationalconf=mysql_fetch_assoc($internationalconf)) ?>
  554. </ol>
  555. <?php } ?>
  556. </td>
  557. </tr>
  558. <tr>
  559. <td>27.</td>
  560. <td><strong>Local Conferences Attended/Organized with Dates:</strong></td>
  561. <td> <?php
  562. if($totalRows_localconferences<=0){ echo "Nil"; }?></td> </tr>
  563. <?php
  564. if($totalRows_localconferences>0){ ?>
  565. <tr><td>&nbsp;</td>
  566. <td colspan="2">
  567. <ol type="i">
  568. <?php do { ?>
  569. <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>
  570. <?php }while($row_localconferences=mysql_fetch_assoc($localconferences)) ?>
  571. </ol>
  572. <?php } ?>
  573. </td>
  574. </tr>
  575. <tr>
  576. <td>28.</td>
  577. <td><strong>Publications/Articles:</strong></td>
  578. <td> <?php
  579. if($totalRows_publications<=0){ echo "Nil"; }?></td> </tr>
  580. <tr><td>&nbsp;</td>
  581. <?php if($totalRows_publications>0){ ?>
  582. <td colspan="2"> <strong> In peer-reviewed journals </strong>
  583. <ol type="i">
  584. <?php do { ?>
  585. <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>
  586. <?php }while($totalRows_publications=mysql_fetch_assoc($publications)) ?>
  587. </ol>
  588. <?php } ?>
  589. </tr>
  590. <tr>
  591. <td>29.</td>
  592. <td><strong>Invention/Innovvation/Award:</strong></td>
  593. <td><?php ?></td>
  594. </tr>
  595. <tr>
  596. <td>30.</td>
  597. <td><strong>Citation in "Who-is-Who", etc:</strong></td>
  598. <td><?php ?></td>
  599. </tr>
  600. <tr>
  601. <td>31.</td>
  602. <td><strong>Additional Publications since Last Promotion:</strong></td>
  603. <td><?php ?></td>
  604. </tr>
  605. <tr>
  606. <td>32.</td>
  607. <td><strong>Hobbies:</strong></td>
  608. <td><?php ?></td>
  609. </tr>
  610. <tr>
  611. <td>33.</td>
  612. <td><strong>Names and Addresses of Three Referees:</strong></td>
  613. <td><?php ?></td>
  614. </tr>
  615. </table>
  616. <p align="center">&nbsp;</p>
  617. </div>
  618. </div>
  619. <?php
  620. }
  621. ?>
  622. </body>
  623. </html>