viewcv.php | searchcode

/promotion/summary/viewcv.php

https://bitbucket.org/lecturer34/hrmis
PHP | 654 lines | 565 code | 75 blank | 14 comment | 56 complexity | 880064a5acbc26e994ac9a5e4c7b738b MD5 | raw file
Possible License(s): LGPL-2.1

<?php

if (!function_exists("GetSQLValueString")) {

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 

{

  if (PHP_VERSION < 6) {

    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  }



  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);



  switch ($theType) {

    case "text":

      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

      break;    

    case "long":

    case "int":

      $theValue = ($theValue != "") ? intval($theValue) : "NULL";

      break;

    case "double":

      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";

      break;

    case "date":

      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

      break;

    case "defined":

      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;

      break;

  }

  return $theValue;

}

}



function generatecv($employeeid,$year)

{

$employid_emploeeRec=$employeeid;



$query_emploeeRec = sprintf("SELECT tblemployee.firstname, tblemployee.surname, tblemployee.othernames, tblemployee.dateoffirstappointment,   

tblemployee.salaryonappointment, countryname, tblemployee.dateofbirth, tblemployee.placeofbirth, tblemployee.maritalstatus, 

tblemployee.gender, tblemployee.permanentaddress,  tbldepartment.name as department, tblstate.statename as state, tbllga.lganame as lga,  

tblrank.name as rank FROM tblemployee, tblconfirmation, tbldepartment, tblrank, tblstate, tbllga, tblcountries 

WHERE tblemployee.department=tbldepartment.departmentid  AND tblemployee.rankonemployment=tblrank.rankid  AND tblemployee.lgaoforigin=tbllga.lgaid  AND 

tbllga.stateid=tblstate.stateid  AND tblemployee.nationality=tblcountries.countryid  AND tblemployee.employeeid=%s", 

GetSQLValueString($employid_emploeeRec, "int"));

$emploeeRec = mysql_query($query_emploeeRec) or die(mysql_error());

$row_emploeeRec = mysql_fetch_assoc($emploeeRec);

$totalRows_emploeeRec = mysql_num_rows($emploeeRec);



$colname_confirmation = "-1";

if (isset($employeeid)) {

  $colname_confirmation = $employeeid;

}



$query_confirmation = sprintf("SELECT effectivedate FROM tblconfirmation WHERE employeeid = %s", GetSQLValueString($colname_confirmation, "int"));

$confirmation = mysql_query($query_confirmation) or die(mysql_error());

$row_confirmation = mysql_fetch_assoc($confirmation);

$totalRows_confirmation = mysql_num_rows($confirmation);



$colname_promotion = "-1";

if (isset($employeeid)) {

  $colname_promotion = $employeeid;

}



$query_promotion = sprintf("SELECT personnelno, rank, salaryid, effectivedate FROM tblpromotions WHERE employeeid = %s", GetSQLValueString($colname_promotion, "int"));

$promotion = mysql_query($query_promotion) or die(mysql_error());

$row_promotion = mysql_fetch_assoc($promotion);

$totalRows_promotion = mysql_num_rows($promotion);



$colname_contactaddr = "-1";

if (isset($employeeid)) {

  $colname_contactaddr = $employeeid;

}



$query_contactaddr = sprintf("SELECT tblcontactaddr.city, tblcontactaddr.`state`, tblcontactaddr.contactaddress, tblstate.statename  FROM tblcontactaddr, tblstate WHERE employeeid = %s AND tblstate.stateid=tblcontactaddr.`state`", GetSQLValueString($colname_contactaddr, "int"));

$contactaddr = mysql_query($query_contactaddr) or die(mysql_error());

$row_contactaddr = mysql_fetch_assoc($contactaddr);

$totalRows_contactaddr = mysql_num_rows($contactaddr);



$colname_workexp = "-1";

if (isset($employeeid)) {

  $colname_workexp = $employeeid;

}



$query_workexp = sprintf("SELECT * FROM tblempworkingexp WHERE employeeid = %s ORDER BY `from` DESC", GetSQLValueString($colname_workexp, "int"));

$workexp = mysql_query($query_workexp) or die(mysql_error());

$row_workexp = mysql_fetch_assoc($workexp);

$totalRows_workexp = mysql_num_rows($workexp);



$colname_qualifications = "-1";

if (isset($employeeid)) {

  $colname_qualifications = $employeeid;

}



$query_qualifications = sprintf("SELECT tblqualifications_lookup.`certificate`, tblqualification.qualificationid, tblqualification.employeeid, tblqualification.yearobtained, tblqualification.institutionobtained, tblqualification.course, tblqualification.grade FROM tblqualification, tblqualificationcategory,tblqualifications_lookup WHERE employeeid = %s AND tblqualification.category=tblqualificationcategory.id and tblqualification.category=1 AND tblqualifications_lookup.id=tblqualification.qualificationtype", GetSQLValueString($colname_qualifications, "int"));

$qualifications = mysql_query($query_qualifications) or die(mysql_error());

$row_qualifications = mysql_fetch_assoc($qualifications);

$totalRows_qualifications = mysql_num_rows($qualifications);



$colname__profQualification = "-1";

if (isset($employeeid)){

  $colname__profQualification = $employeeid;

}



$query__profQualification = sprintf("SELECT tblqualifications_lookup.`certificate`, tblqualification.qualificationid, tblqualification.employeeid, tblqualification.yearobtained, tblqualification.institutionobtained, tblqualification.course, tblqualification.grade FROM tblqualification, tblqualificationcategory,tblqualifications_lookup WHERE employeeid = %s AND tblqualification.category=tblqualificationcategory.id and  tblqualification.category='2' AND tblqualifications_lookup.id=tblqualification.qualificationtype", GetSQLValueString($colname_qualifications, "int"));

$profQualification = mysql_query($query__profQualification) or die(mysql_error());

$row__profQualification = mysql_fetch_assoc($profQualification);

$totalRows__profQualification = mysql_num_rows($profQualification);



$colname_languages = "-1";

if (isset($employeeid)) {

  $colname_languages = $employeeid;

}



$query_languages = sprintf("SELECT * FROM tbllanguagesspoken WHERE employeeid = %s", GetSQLValueString($colname_languages, "int"));

$languages = mysql_query($query_languages) or die(mysql_error());

$row_languages = mysql_fetch_assoc($languages);

$totalRows_languages = mysql_num_rows($languages);



$colname_positions = "-1";

if (isset($employeeid)) {

  $colname_positions = $employeeid;

}



$query_positions = sprintf("SELECT * FROM tblpositionsheld WHERE employeeid = %s", GetSQLValueString($colname_positions, "int"));

$positions = mysql_query($query_positions) or die(mysql_error());

$row_positions = mysql_fetch_assoc($positions);

$totalRows_positions = mysql_num_rows($positions);



$colname_profSoc = "-1";

if (isset($employeeid)) {

  $colname_profSoc = $employeeid;

}



$query_profSoc = sprintf("SELECT * FROM tblprofmembership WHERE employeeid = %s", GetSQLValueString($colname_profSoc, "int"));

$profSoc = mysql_query($query_profSoc) or die(mysql_error());

$row_profSoc = mysql_fetch_assoc($profSoc);

$totalRows_profSoc = mysql_num_rows($profSoc);



$colname_teaching = "-1";

if (isset($employeeid)) {

  $colname_teaching = $employeeid;

}



$query_teaching = sprintf("SELECT * FROM tblteaching WHERE employeeid = %s", GetSQLValueString($colname_teaching, "int"));

$teaching = mysql_query($query_teaching) or die(mysql_error());

$row_teaching = mysql_fetch_assoc($teaching);

$totalRows_teaching = mysql_num_rows($teaching);



$colname_adminduties = "-1";

if (isset($employeeid)) {

  $colname_adminduties = $employeeid;

}



$query_adminduties = sprintf("SELECT tbladminduty.dutylevel, tbladminduty.datefrom, tbladminduty.dateto, tbladminduty.institution, tbladmindutytype.dutyname  FROM tbladminduty, tbladmindutytype WHERE employeeid = %s AND tbladminduty.dutytype=tbladmindutytype.dutytypeid", GetSQLValueString($colname_adminduties, "int"));

$adminduties = mysql_query($query_adminduties) or die(mysql_error());

$row_adminduties = mysql_fetch_assoc($adminduties);

$totalRows_adminduties = mysql_num_rows($adminduties);



$colname_localconferences = "-1";

if (isset($employeeid)) {

  $colname_localconferences = $employeeid;

}



$query_localconferences = sprintf("SELECT * FROM tblconferences WHERE employeeid = %s AND tblconferences.conferencetype='local' ORDER BY datefrom DESC", GetSQLValueString($colname_localconferences, "int"));

//echo $query_localconferences; exit;

$localconferences = mysql_query($query_localconferences) or die(mysql_error());

$row_localconferences = mysql_fetch_assoc($localconferences);

$totalRows_localconferences = mysql_num_rows($localconferences);



$colname_internationalconf = "-1";

if (isset($employeeid)) {

  $colname_internationalconf = $employeeid;

}



$query_internationalconf = sprintf("SELECT * FROM tblconferences WHERE employeeid = %s AND tblconferences.conferencetype='international' ORDER BY datefrom DESC", GetSQLValueString($colname_internationalconf, "int"));

$internationalconf = mysql_query($query_internationalconf) or die(mysql_error());

$row_internationalconf = mysql_fetch_assoc($internationalconf);

$totalRows_internationalconf = mysql_num_rows($internationalconf);



$emplid_publications = "-1";

if (isset($employeeid)) {

  $emplid_publications = $employeeid;

}



$query_publications = sprintf("SELECT  tbljournalspublication.title, tbljournalspublication.journalname, tbljournalspublication.authors, tbljournalspublication.publicationdate, tbljournalspublication.url, tblpublictiontype.publictiontypeid, tblpublictiontype.eventoractivity FROM tbljournalspublication, tblpublictiontype WHERE tblpublictiontype.publictiontypeid=tbljournalspublication.typeid AND tbljournalspublication.employeeid=%s and typeid=1", GetSQLValueString($emplid_publications, "int"));

$publications = mysql_query($query_publications) or die(mysql_error());

$row_publications = mysql_fetch_assoc($publications);

$totalRows_publications = mysql_num_rows($publications);



$emplid_cpublications = "-1";

if (isset($employeeid)) {

  $emplid_cpublications = $employeeid;

}



$query_cpublications = sprintf("SELECT  tbljournalspublication.title, tbljournalspublication.journalname, tbljournalspublication.authors, tbljournalspublication.publicationdate, tbljournalspublication.url, tblpublictiontype.publictiontypeid, tblpublictiontype.eventoractivity FROM tbljournalspublication, tblpublictiontype WHERE tblpublictiontype.publictiontypeid=tbljournalspublication.typeid AND tbljournalspublication.employeeid=%s and typeid=2", GetSQLValueString($emplid_cpublications, "int"));

$cpublications = mysql_query($query_cpublications) or die(mysql_error());

$row_cpublications = mysql_fetch_assoc($cpublications);

$totalRows_cpublications = mysql_num_rows($cpublications);





$colname_commservice = "-1";

if (isset($employeeid)) {

  $colname_commservice = $employeeid;

}



$query_commservice = sprintf("SELECT * FROM tblcommunityservice WHERE employeeid = %s", GetSQLValueString($colname_commservice, "int"));

$commservice = mysql_query($query_commservice) or die(mysql_error());

$row_commservice = mysql_fetch_assoc($commservice);

$totalRows_commservice = mysql_num_rows($commservice);







$query_pubtypes = "SELECT * FROM tblpublictiontype ORDER BY publictiontypeid ASC";

$pubtypes = mysql_query($query_pubtypes) or die(mysql_error());

$row_pubtypes = mysql_fetch_assoc($pubtypes);

$totalRows_pubtypes = mysql_num_rows($pubtypes);

/*

$pubtypes = array();



for($i=0; $i<$totalRows_publications; $i++){

	$pubtypes[]=$row_pubtypes['eventoractivity'];

}



var_dump($pubtypes);

exit;

*/

?>

<!DOCTYPE html>

<html>



    <head>

        <title>CV</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 echo $row_emploeeRec['dateofbirth']; ?><?php echo $row_emploeeRec['placeofbirth']; ?></td>

                </tr>

                <tr>

                  <td>5.</td>

                  <td><strong>State of Origin;</strong></td>

                  <td><?php echo $row_emploeeRec['state']; ?></td>

                </tr>

                <tr>

                  <td>6.</td>

                  <td><strong>Local Government of Origin:</strong></td>

                  <td><?php echo $row_emploeeRec['lga']; ?></td>

                </tr>

                <tr>

                  <td>7.</td>

                  <td><strong>Nationality:</strong></td>

                  <td><?php echo $row_emploeeRec['countryname']; ?></td>

                </tr>

                <tr>

                  <td>8.</td>

                  <td><strong>Marital Status:</strong></td>

                  <td><?php echo $row_emploeeRec['maritalstatus']; ?></td>

                </tr>

                <tr>

                  <td>9.</td>

                  <td><strong>Gender:</strong></td>

                  <td><?php echo $row_emploeeRec['gender']; ?></td>

                </tr>

                <tr>

                  <td>10.</td>

                  <td><strong>International Languages Spoken:</strong></td>

                  <td>

                  <?php if($totalRows_languages>0){

					  do {

						  echo $row_languages['language']. ", ";

					  }while($row_languages = mysql_fetch_assoc($languages));

				  }else{

					  echo "Nil";

				  }

					  ?>

                  </td>

                </tr>

                <tr>

                  <td>11.</td>

                  <td><strong>Current Contact Address:</strong></td>

                  <td><?php 

				  if($totalRows_contactaddr>0){

					  echo $row_contactaddr['contactaddress']."<br />";

					  echo $row_contactaddr['city']."<br />";

					  echo $row_contactaddr['statename']." State<br />";

					  //echo $row_contactaddr['zip']."<br />";					  					  					  

				  }

				  ?></td>

                </tr>

                <tr>

                  <td>12.</td>

                  <td><strong>Permanent Home Address:</strong></td>

                  <td>

				  <?php if(isset($row_emploeeRec['permanentaddress']) && strlen(trim($row_emploeeRec['permanentaddress'])) !=0){

					  echo $row_emploeeRec['permanentaddress']; 

				  }else{

					  echo "<b>Not set</b>";

				  }?>

				</td>

                </tr>

                <tr>

                  <td>13.</td>

                  <td><strong>Date of First Appointment with the University:</strong></td>

                  <td><?php if(isset($row_emploeeRec['dateoffirstappointment'])){

					  echo $row_emploeeRec['dateoffirstappointment']; 

				  }else{

					  echo "Not set";

				  }?></td>

                </tr>

                  <td>14.</td>

                  <td><strong>Date of Last Promotion:</strong></td>

                  <td><?php if(isset($row_emploeeRec['effectivedate'])){

					  echo $row_emploeeRec['effectivedate']; 

				  }else{

					  echo "Not set";

				  }?>

				  

				  

</td>

                </tr>



                <tr>

                  <td>15.</td>

                  <td><strong>Date of Confirmation:</strong></td>

                  <td>



				  <?php if(isset($row_confirmation['effectivedate'])){

					  echo $row_confirmation['effectivedate']; 

				  }else{

					  echo "Not set";

				  }?>

</td>

                </tr>

                <tr>

                  <td>16.</td>

                  <td><strong>Present Rank and Salary:</strong></td>

                  <td><?php 

				  if(isset($row_promotion['rank'])&& $row_promotion['rank']>0){

					  $rankid= $row_promotion['rank']; 

					  $sql=mysql_query("select name from tblrank where rankid=$rankid");

					  echo mysql_result($sql, 0, 'name');

					} 

				  ?></td>

                </tr>

                <tr>

                  <td>17.</td>

                  <td><strong>Qualifications, Educational Institutions with Dates:</strong></td>

                  <td> <?php 

				  if($totalRows_qualifications<=0){ echo "Nil"; }?></td> </tr>





                <?php 

				  if($totalRows_qualifications>0){ ?>

				<tr><td>&nbsp;</td>

                <td colspan="2"> 

					  <ol type="i">

                      	<?php do { ?>

						<li> <?php echo $row_qualifications['institutionobtained'].", ". $row_qualifications['certificate']. ", ".$row_qualifications['yearobtained']; ?>

						<?php }while($row_qualifications=mysql_fetch_assoc($qualifications)) ?>

                      </ol>

				  <?php } ?></td>

                </tr>

    

                <tr>

                  <td>18.</td>

                  <td><strong>Additional Qualifications/Education with Addresses & Dates</strong></td>

                  <td> <?php 

				  if($totalRows__profQualification<=0){ echo "Nil"; }?></td> </tr>



                <?php 

				  if($totalRows__profQualification>0){ ?>

				<tr><td>&nbsp;</td>

                <td colspan="2"> 

					  <ol type="i">

                      	<?php do { ?>

						<li> <?php echo $row__profQualification['institutionobtained'].", ". $row__profQualification['certificate']. ", ".$row__profQualification['institutionobtained']; ?>

						<?php }while($row__profQualification=mysql_fetch_assoc($profQualification)) ?>

                      </ol>

				  <?php } ?></td>

                </tr>



                </tr>



                <tr>

                  <td>19.</td>

                  <td><strong>Working Experience with Dates:</strong></td>

                  <td> <?php 

				  if($totalRows_workexp<=0){ echo "Nil"; }?></td> </tr>



                <?php 

				  if($totalRows_workexp>0){ ?>

				<tr><td>&nbsp;</td>

                <td colspan="2"> 

					  <ol type="i">

                      	<?php do { ?>

						<li> <?php echo $row_workexp['positionheld'].", ". $row_workexp['place']. ", From ".$row_workexp['from']. " To ". $row_workexp['to']. "<br />";

						echo "<b>Responsibilities:</b> ".$row_workexp['responsibilities']; ?></li>

						<?php }while($row_workexp=mysql_fetch_assoc($workexp)) ?>

                      </ol>

				  <?php } ?></td>

                </tr>

                <tr>

                  <td>20.</td>

                  <td><strong>Routine Teaching Experience with Dates:</strong></td>

                  <td> <?php 

				  if($totalRows_teaching<=0){ echo "Nil"; }?></td> </tr>

                <?php 

				  if($totalRows_teaching>0){ ?>

				<tr><td>&nbsp;</td>

                <td colspan="2"> 

					  <ol type="i">

                      	<?php do { ?>

						<li> <?php echo $row_teaching['coursecode']." - ". $row_teaching['title']." (". $row_teaching['session'].")  ". $row_teaching['level']." Student type: ". $row_teaching['level'];?></li>

						<?php }while($row_teaching=mysql_fetch_assoc($teaching)) ?>

                      </ol>

				  <?php } ?>

                  </td>

                </tr>



                <tr>

                  <td>21.</td>

                  <td><strong>Research/Extension Experience and Dates:</strong></td>

                  <td><?php  ?></td>

                </tr>



                <tr>

                  <td>22.</td>

                  <td><strong>Routine Administrative Duties with Dates:</strong></td>

                <td> <?php 

				  if($totalRows_adminduties<=0){ echo "Nil"; }?></td> </tr>

                <?php 

				  if($totalRows_adminduties>0){ ?>

				<tr><td>&nbsp;</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>&nbsp;</td>

                <td colspan="2"> 

					  <ol type="i">

                      	<?php do { ?>

						<li> <?php echo $row_positions['position'].", (". $row_positions['capacity']. "".$row_positions['place'].",  From ".$row_positions['fromdate']. " To ". $row_positions['todate']. "<br />";?></li>

						<?php }while($row_positions=mysql_fetch_assoc($positions)) ?>

                      </ol>

				  <?php } ?>

                  </td>

                </tr>



                <tr>

                  <td>24.</td>

                  <td><strong>Professional Service / Honour Societies:</strong></td>

                  <td> <?php 

				  if($totalRows_profSoc<=0){ echo "Nil"; }?></td> </tr>

                <?php 

				  if($totalRows_profSoc>0){ ?>

				<tr><td>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</td>

                <td colspan="2"> 

					  <ol type="i">

                      	<?php do { ?>

						<li> <?php echo $row_localconferences['role']." ". $row_localconferences['conferencename']." by ".$row_localconferences['organizers']." held from  ".$row_internationalconf['datefrom']." to ".$row_internationalconf['datefrom']. ".  ".$row_localconferences['url'] ;?></li>

						<?php }while($row_localconferences=mysql_fetch_assoc($localconferences)) ?>

                      </ol>

				  <?php } ?>

                  </td>

                </tr>



                <tr>

                  <td>28.</td>

                  <td><strong>Publications/Articles:</strong></td>

                  <td> <?php 

				  if($totalRows_publications<=0){ echo "Nil"; }?></td> </tr>

				<tr><td>&nbsp;</td>

                  <?php if($totalRows_publications>0){ ?>

				  <td colspan="2"> <strong> In peer-reviewed journals </strong>

                  	<ol type="i">

                      	<?php do { ?>

						<li> <?php echo $totalRows_publications['authors']." ". substr($totalRows_publications['title'], 0, 4)." ".$totalRows_publications['title'].". <i> ".$totalRows_publications['journalname']."</i> Vol. ".$totalRows_publications['vol']."  No. ".$totalRows_publications['num'] ;?></li>

						<?php }while($totalRows_publications=mysql_fetch_assoc($publications)) ?>

                      </ol>

				  <?php } ?>

                </tr>



                <tr>

                  <td>29.</td>

                  <td><strong>Invention/Innovvation/Award:</strong></td>

                  <td><?php  ?></td>

                </tr>



                <tr>

                  <td>30.</td>

                  <td><strong>Citation in "Who-is-Who", etc:</strong></td>

                  <td><?php  ?></td>

                </tr>



                <tr>

                  <td>31.</td>

                  <td><strong>Additional Publications since Last Promotion:</strong></td>

                  <td><?php  ?></td>

                </tr>



                <tr>

                  <td>32.</td>

                  <td><strong>Hobbies:</strong></td>

                  <td><?php  ?></td>

                </tr>



                <tr>

                  <td>33.</td>

                  <td><strong>Names and Addresses of Three Referees:</strong></td>

                  <td><?php  ?></td>

                </tr>





              </table>

              <p align="center">&nbsp;</p>

            </div>

        </div>

    </body>



</html>

<?php

}



require_once('../../lib/database.php');

openConnection();

generatecv(5466,2011);

?>