chklist_func.php | searchcode

/promotion/chklist_func.php

https://bitbucket.org/lecturer34/hrmis
PHP | 691 lines | 509 code | 110 blank | 72 comment | 23 complexity | 264be34f94515a4fd6b3573bd477b22e MD5 | raw file
Possible License(s): LGPL-2.1

<?php

	// In this script contains various utility functions for generating the checklist of a staffs

	

	

	

	

	

	

	/*********************************************************************************

		This function (get_active_guideline_code) will return the current active guidelinecode

	*********************************************************************************/

	function get_active_guideline_code()

		{

			$sql_active_guideline_code="select guidelinecode from tblpromotionguideline where status = 1 limit 1";

			$result_active_guideline_code= mysql_query($sql_active_guideline_code) or die(mysql_error());

			$row_active_guideline_code= mysql_fetch_array($result_active_guideline_code);

			$active_guideline_code= $row_active_guideline_code['guidelinecode'];

			return $active_guideline_code;

		}

	

	

	

	

	

	/*********************************************************************************

		This function (get_active_guideline_description) will return the current active guideline description

	*********************************************************************************/

	function get_active_guideline_description()

		{

			$sql_active_guideline_description="select description from tblpromotionguideline where status = 1 limit 1";

			$result_active_guideline_description= mysql_query($sql_active_guideline_description) or die(mysql_error());

			$row_active_guideline_description= mysql_fetch_array($result_active_guideline_description);

			$active_guideline_description= $row_active_guideline_description['description'];

			return $active_guideline_description;

		}

	

	

	

	

	

	/************************************************************************************

		This function (get_category) will return the catetory based on rank, complex and guideline. 

		Returns 0 of no category is defined for the above criteria.

	*************************************************************************************/

	

	function get_category($rnkid /**rank id of staff**/, $cmpxid /**complex id of staff**/, $act_guideline_code /**current guildeline**/ )

		{

			$sql_cat_id= "select categoryid from tblpromotioncategory where (rankid = $rnkid && complexid = $cmpxid && guidelinecode = $act_guideline_code)";

			$result_cat_id= mysql_query($sql_cat_id) or die(mysql_error());

			$row_cat_id= mysql_fetch_array($result_cat_id);

			$cat_id=$row_cat_id['categoryid'];

			return ($cat_id) ? $cat_id:0;

		}

	

	

	

	

	

	/*********************************************************************************

		This function (get_possible_options_count) will return the total number of options available for a staff of which a staff can get promoted

		Returns 0 of no option is available.

	*********************************************************************************/

	

	function get_possible_options_count($cat_id /**category for getting available options**/)

		{

			$sql_possible_options= "select count(categoryid) as catid from tblpromotionplan where categoryid= $cat_id";

			$result_possible_options= mysql_query($sql_possible_options) or die(mysql_error());

			$row_possible_options= mysql_fetch_array($result_possible_options);

			$options_count= $row_possible_options['catid'];

			return ($options_count) ? $options_count:0;

		}

		

		

		

		

	

	/*******************************************************************************

		This function (get_options) returns an array of plan ids which can be used to query staffs record from various requirement tables

		Returns null if no option is available for the category

	*******************************************************************************/

	function get_options($cat_id /**category for getting available options**/)

		{

			$sql_available_options= "select planid from tblpromotionplan where categoryid= $cat_id";

			$result_available_options= mysql_query($sql_available_options) or die(mysql_error());

			if (mysql_num_rows($result_available_options)>0) // if options are available

				{		

					while($row_available_options= mysql_fetch_array($result_available_options))

						{

							$options[]= $row_available_options['planid'];

						}

						

					return $options;

				}//else return null by default

		}

		

		

		

		

		

	/******************************************************************************

		This function (get_publication_req) returns an array of requirements for publication based on plan id (option)

		Returns null if no requirement is specified for a specific plan

	******************************************************************************/

	

	function get_publication_req($plan_id /** The plan for the publication requirement**/)

		{

			$sql_pub_req ="select publicationtype, publicationlevel, number from tblreqpublication where planid = $plan_id";

			$result_pub_req= mysql_query($sql_pub_req) or die(mysql_error());

			if (mysql_num_rows($result_pub_req)>0) // if publication requirements are available

				{		

					$row_pub_req= mysql_fetch_array($result_pub_req);

					for($i=0; $i< count($row_pub_req); $i++)

						$pub_req[]= $row_pub_req[$i];

						

					return $pub_req;

				}//else return null by default

		}

		

		

		

		

	/*****************************************************************************

		This function (get_publication_achvt) returns a count of the number of publication published by a staff at a given criteria

	*****************************************************************************/

	

	function get_publication_achvt($empid /** The Employee's id**/, $type /**The type of publication**/)

		{

			if($type == 'Any') 

				$sql_pub_achvt ="select count(*) as count from tbljournalspublication where employeeid = $empid";

			else

				$sql_pub_achvt ="select count(*) from tbljournalspublication where employeeid = $empid && typeid= $type";

				

			$result_pub_achvt= mysql_query($sql_pub_achvt) or die(mysql_error());

			$row_pub_achvt= mysql_fetch_array($result_pub_achvt);

			$pub_achvt= $row_pub_achvt['count'];

			return $pub_achvt;

		}

		

		

	

	

	/******************************************************************************

		This function (get_supervision_req) returns an array of requirements for supervision based on plan id (option)

		Returns null if no requirement is specified for a specific plan

	******************************************************************************/

	

	function get_supervision_req($plan_id /** The plan for the supervsion requirement**/)

		{

			$sql_superv_req ="select supervisionlevel, number from tblreqsupervision where planid = $plan_id";

			$result_superv_req= mysql_query($sql_superv_req) or die(mysql_error());

			if (mysql_num_rows($result_superv_req)>0) // if supervision requirements are available

				{		

					$row_superv_req= mysql_fetch_array($result_superv_req);

					for($i=0; $i< count($row_superv_req); $i++)

						$superv_req[]= $row_superv_req[$i];

						

					return $superv_req;

				}//else return null by default

		}

		

		

		

		

	/*****************************************************************************

		This function (get_supervision_achvt) returns a count of the number of supervision made by a staff

	*****************************************************************************/

	

	function get_supervision_achvt($empid /** The Employee's id**/)

		{

			$sql_superv_achvt ="select count(*) as count from tblsupervision where employeeid = $empid";

			$result_superv_achvt= mysql_query($sql_superv_achvt) or die(mysql_error());

			$row_superv_achvt= mysql_fetch_array($result_superv_achvt);

			$superv_achvt= $row_superv_achvt['count'];

			return $superv_achvt;

		}

		

		

	

	

	/******************************************************************************

		This function (get_qualification_req) returns an array of requirements for qualification based on plan id (option)

		Returns null if no requirement is specified for a specific plan

	******************************************************************************/

	

	function get_qualification_req($plan_id /** The plan for the qualification requirement**/)

		{

			$sql_qual_req ="select qualification from tblreqqualification where planid = $plan_id";

			$result_qual_req= mysql_query($sql_qual_req) or die(mysql_error());

			if (mysql_num_rows($result_qual_req)>0) // if qual requirements are available

				{		

					$row_qual_req= mysql_fetch_array($result_qual_req);

					for($i=0; $i< count($row_qual_req); $i++)

						$qual_req[]= $row_qual_req[$i];

						

					$sql_qual_name ="select certificate from tblqualifications_lookup where id = $qual_req[0]";

					$result_qual_name= mysql_query($sql_qual_name) or die(mysql_error());

					$row_qual_name= mysql_fetch_array($result_qual_name);

					$qual_name= $row_qual_name['certificate'];

					$qual_req[0] = $qual_name;

					return $qual_req;

				}//else return null by default

		}

		

		

		

		

	/*****************************************************************************

		This function (get_qualification_achvt) returns  the highest qualification obtained by a staff

	*****************************************************************************/

	

	function get_qualification_achvt($empid /** The Employee's id**/)

		{

			$sql_qual_achvt ="select max(qualificationtype) as qualtype from tblqualification where employeeid = $empid";

			$result_qual_achvt= mysql_query($sql_qual_achvt) or die(mysql_error());

			$row_qual_achvt= mysql_fetch_array($result_qual_achvt);

			$qual_achvt= $row_qual_achvt['qualtype'];

			$sql_qual_achvt2 ="select certificate from tblqualifications_lookup where id = $qual_achvt";

			$result_qual_achvt2= mysql_query($sql_qual_achvt2) or die(mysql_error());

			$row_qual_achvt2= mysql_fetch_array($result_qual_achvt2);

			$qual_achvt2= $row_qual_achvt2['certificate'];

			return $qual_achvt2;

		}

		

		

	

	

	/******************************************************************************

		This function (get_waitperiod_req) returns an array of requirements for waiting based on plan id (option)

		Returns null if no requirement is specified for a specific plan

	******************************************************************************/

	

	function get_waitperiod_req($plan_id /** The plan for the qualification requirement**/)

		{

			$sql_wait_req ="select duration from tblreqwaitingperiod where planid = $plan_id";

			$result_wait_req= mysql_query($sql_wait_req) or die(mysql_error());

			if (mysql_num_rows($result_wait_req)>0) // if qual requirements are available

				{		

					$row_wait_req= mysql_fetch_array($result_wait_req);

					for($i=0; $i< count($row_wait_req); $i++)

						$wait_req[]= $row_wait_req[$i];

						return $wait_req;

				}//else return null by default

		}

		

		

		

		

	/*****************************************************************************

		This function (get_waitperiod_achvt) returns  the highest wait period obtained by a staff since the last promotion

	*****************************************************************************/

	

	function get_waitperiod_achvt($empid /** The Employee's id**/)

		{

			$sql_wait_achvt ="select year(effectivedate) as yr from tblpromotions where employeeid = $empid";

			$result_wait_achvt= mysql_query($sql_wait_achvt) or die(mysql_error());

			$row_wait_achvt= mysql_fetch_array($result_wait_achvt);

			$wait_achvt= $row_wait_achvt['yr'];

			$currdate = getdate();

			$wait_achvt = $currdate['year'] - $wait_achvt;

			return $wait_achvt;

		}

		

		

	

	

	/******************************************************************************

		This function (get_comservice_req) returns an array of requirements for community service based on plan id (option)

		Returns null if no requirement is specified for a specific plan

	******************************************************************************/

	

	function get_comservice_req($plan_id /** The plan for the qualification requirement**/)

		{

			$sql_cs_req ="select servicelevel from tblreqcomunityservice where planid = $plan_id";

			$result_cs_req= mysql_query($sql_cs_req) or die(mysql_error());

			if (mysql_num_rows($result_cs_req)>0) // if qual requirements are available

				{		

					$row_cs_req= mysql_fetch_array($result_cs_req);

					for($i=0; $i< count($row_cs_req); $i++)

						$cs_req[]= $row_cs_req[$i];

						return $cs_req;

				}//else return null by default

		}

		

		

		

		

	/*****************************************************************************

		This function (get_comservice_achvt) returns  the service level of the last community serivice done by a staff

	*****************************************************************************/

	

	function get_comservice_achvt($empid /** The Employee's id**/)

		{

			$sql_cs_achvt ="select servicelevel from tblcommunityservice where employeeid = $empid";

			$result_cs_achvt= mysql_query($sql_cs_achvt) or die(mysql_error());

			$row_cs_achvt= mysql_fetch_array($result_cs_achvt);

			$cs_achvt= $row_cs_achvt['servicelevel'];

			return $cs_achvt;

		}

		

		

	

	

	/******************************************************************************

		This function (get_adminduty_req) returns an array of requirements for Duty service based on plan id (option)

		Returns null if no requirement is specified for a specific plan

	******************************************************************************/

	

	function get_adminduty_req($plan_id /** The plan for the qualification requirement**/)

		{

			$sql_ad_req ="select dutylevel from tblreqadminduty where planid = $plan_id";

			$result_ad_req= mysql_query($sql_ad_req) or die(mysql_error());

			if (mysql_num_rows($result_ad_req)>0) // if qual requirements are available

				{		

					$row_ad_req= mysql_fetch_array($result_ad_req);

					for($i=0; $i< count($row_ad_req); $i++)

						$ad_req[]= $row_ad_req[$i];

						return $ad_req;

				}//else return null by default

		}

		

		

		

		

	/*****************************************************************************

		This function (get_adminduty_achvt) returns  the duty level of the last community serivice done by a staff

	*****************************************************************************/

	

	function get_adminduty_achvt($empid /** The Employee's id**/)

		{

			$sql_ad_achvt ="select dutylevel from tbladminduty where employeeid = $empid";

			$result_ad_achvt= mysql_query($sql_ad_achvt) or die(mysql_error());

			$row_ad_achvt= mysql_fetch_array($result_ad_achvt);

			$ad_achvt= $row_ad_achvt['servicelevel'];

			return $ad_achvt;

		}

		

		

	

	

	/******************************************************************************

		This function (get_minage_req) returns an array of requirements for Duty service based on plan id (option)

		Returns null if no requirement is specified for a specific plan

	******************************************************************************/

	

	function get_minage_req($plan_id /** The plan for the qualification requirement**/)

		{

			$sql_ma_req ="select age from tblreqage where planid = $plan_id";

			$result_ma_req= mysql_query($sql_ma_req) or die(mysql_error());

			if (mysql_num_rows($result_ma_req)>0) // if qual requirements are available

				{		

					$row_ma_req= mysql_fetch_array($result_ma_req);

					for($i=0; $i< count($row_ma_req); $i++)

						$ma_req[]= $row_ma_req[$i];

						return $ma_req;

				}//else return null by default

		}

		

		

		

		

	/*****************************************************************************

		This function (get_minage_achvt) returns  the duty level of the last community serivice done by a staff

	*****************************************************************************/

	

	function get_minage_achvt($empid /** The Employee's id**/)

		{

			$sql_ma_achvt ="select dateofbirth from tblemployee where employeeid = $empid";

			$result_ma_achvt= mysql_query($sql_ma_achvt) or die(mysql_error());

			$row_ma_achvt= mysql_fetch_array($result_ma_achvt);

			$ma_achvt= $row_ma_achvt['dateofbirth'];

			$currdate = getdate();

			$ma_achvt = $currdate['year'] - $ma_achvt;

			return $ma_achvt;

		}

		

		

	

	

	/*********************************************************************************

		This function (design_table_heading) designs and returns (as a string) the headings of the resulting table based on the number of options available.

		If no option is available it returns String "No options".

	*********************************************************************************/

	function design_table_heading($col_count, $yr, $cmpx)

		{

			if($col_count==0) // if there is no option defined

				return "No options";

			else

				{

					$tbdata="<tr><th rowspan='2' class='criteria'>Criteria</th>";

					for ($i=0; $i<$col_count; $i++)

						{

							$tbdata .= "<th colspan='3' class='options'>Option". ($i + 1) . "</th>";

						}

					

					$tbdata .="</tr><tr class='subtitle'>";

					

					for ($i=0; $i<$col_count; $i++)

						{

							$tbdata .= "<td class='req'>Requirement</td><td class='achieve'>Individual's Attainment</td><td class='remark'>Remark</td>";

						}

					

					$tbdata .= "</tr>";

					return $tbdata;

				}

		}

		

		

		

		

		

	/*******************************************************************************

		This function (design_publication_record) generates the row that holds the publication status of the staff in each option

	*******************************************************************************/

	

	function design_publication_record( $plans /**options available to a staff**/, $empid /**staff employee id**/)

		{

			$na=0;

			$row="<tr title='Publications'><td>Publications</td>";

			for($i=0; $i<count($plans); $i++)

				{

					$publ_req= get_publication_req($plans[$i]);

					if(!isset($publ_req))

						{

							$row .= "<td>N/A</td><td>N/A</td><td class='rmk'><img src = '../../assets/img/naicon.jpg' alt='not applicable' width='20px' height='20px'/></td>";

							$na++;

							continue;

						}

					$publ_ach= get_publication_achvt($empid , $publ_req[0]);

					$row .= "<td>".$publ_req[2]."</td><td> $publ_ach </td><td class='rmk'>";

					if($publ_ach >= $publ_req[2])

						$row .= "<img src = '../../assets/img/checkicon.jpg' alt='passed' width='20px' height='20px'/></td>";

					else 

						$row .= "<img src = '../../assets/img/crossicon.jpg' alt='' width='20px' height='20px'/></td>";

					

				}

			$row .= "</tr>";

			if($na ==count($plans))

			return "";

			

			return $row;

		}

		

		

		

		

	/*******************************************************************************

		This function (design_supervision_record) generates the row that holds the supervision status of the staff in each option

	*******************************************************************************/

	

	function design_supervision_record( $plans /**options available to a staff**/, $empid /**staff employee id**/)

		{

			$na=0;

			$row="<tr title='Supervisions'><td>Supervisions</td>";

			for($i=0; $i<count($plans); $i++)// for each option

				{

					$superv_req= get_supervision_req($plans[$i]);

					if(!isset($superv_req))

						{

							$row .= "<td>N/A</td><td>N/A</td><td class='rmk'><img src = '../../assets/img/naicon.jpg' alt='not applicable' width='20px' height='20px'/></td>";

							$na++;

							continue;

						}

					$superv_ach= get_supervision_achvt($empid);

					$row .= "<td>".$superv_req[1]."</td><td> $superv_ach </td><td class='rmk'>";

					if($superv_ach >= $superv_req[1])

						$row .= "<img src = '../../assets/img/checkicon.jpg' alt='passed' width='20px' height='20px'/></td>";

					else 

						$row .= "<img src = '../../assets/img/crossicon.jpg' alt='' width='20px' height='20px'/></td>";

					

				}

			$row .= "</tr>";

			if($na ==count($plans))

			return "";

			

			return $row;

		}

		

		

		

		

	/*******************************************************************************

		This function (design_qualification_record) generates the row that holds the qualification status of the staff in each option

	*******************************************************************************/

	

	function design_qualification_record( $plans /**options available to a staff**/, $empid /**staff employee id**/)

		{

			$na=0;

			$row="<tr title='Qualification'><td>Qualification</td>";

			for($i=0; $i<count($plans); $i++)

				{

					$qual_req= get_qualification_req($plans[$i]);

					if(!isset($qual_req))

						{

							$row .= "<td>N/A</td><td>N/A</td><td class='rmk'><img src = '../../assets/img/naicon.jpg' alt='not applicable' width='20px' height='20px'/></td>";

							$na++;

							continue;

						}

					$qual_ach= get_qualification_achvt($empid);

					$row .= "<td>".$qual_req[0]."</td><td> $qual_ach </td><td class='rmk'>";

					if($qual_ach == $qual_req[0])

						$row .= "<img src = '../../assets/img/checkicon.jpg' alt='passed' width='20px' height='20px'/></td>";

					else 

						$row .= "<img src = '../../assets/img/crossicon.jpg' alt='' width='20px' height='20px'/></td>";

					

				}

			$row .= "</tr>";

			if($na ==count($plans))

			return "";

			

			return $row;

		}

		

		

		

		

	/*******************************************************************************

		This function (design_waitperiod_record) generates the row that holds the wait period of the staff in each option

	*******************************************************************************/

	

	function design_waitperiod_record( $plans /**options available to a staff**/, $empid /**staff employee id**/)

		{

			$na=0;

			$row="<tr title='Wait Period'><td>Wait Period</td>";

			for($i=0; $i<count($plans); $i++)

				{

					$wait_req= get_waitperiod_req($plans[$i]);

					if(!isset($wait_req))

						{

							$row .= "<td>N/A</td><td>N/A</td><td class='rmk'><img src = '../../assets/img/naicon.jpg' alt='not applicable' width='20px' height='20px'/></td>";

							$na++;

							continue;

						}

					$wait_ach= get_waitperiod_achvt($empid);

					$row .= "<td>".$wait_req[0]."</td><td> $wait_ach </td><td class='rmk'>";

					if($wait_ach >= $wait_req[0])

						$row .= "<img src = '../../assets/img/checkicon.jpg' alt='passed' width='20px' height='20px'/></td>";

					else 

						$row .= "<img src = '../../assets/img/crossicon.jpg' alt='' width='20px' height='20px'/></td>";

					

				}

			$row .= "</tr>";

			if($na ==count($plans))

			return "";

			

			return $row;

		}

		

		

		

		

	/*******************************************************************************

		This function (design_comservice_record) generates the row that holds the community serivice achievement of the staff in each option

	*******************************************************************************/

	

	function design_comservice_record( $plans /**options available to a staff**/, $empid /**staff employee id**/)

		{

			$na=0;

			$row="<tr title='Community Service'><td>Community Service</td>";

			for($i=0; $i<count($plans); $i++)//for each option

				{

					$comservice_req= get_comservice_req($plans[$i]);

					if(!isset($comservice_req))

						{

							$row .= "<td>N/A</td><td>N/A</td><td class='rmk'><img src = '../../assets/img/naicon.jpg' alt='not applicable' width='20px' height='20px'/></td>";

							$na++;

							continue;

						}

					$comservice_ach= get_comservice_achvt($empid);

					$row .= "<td>".$comservice_req[0]."</td><td> $comservice_ach </td><td class='rmk'>";

					if($comservice_ach >= $comservice_req[0])

						$row .= "<img src = '../../assets/img/checkicon.jpg' alt='passed' width='20px' height='20px'/></td>";

					else 

						$row .= "<img src = '../../assets/img/crossicon.jpg' alt='' width='20px' height='20px'/></td>";

					

				}

			$row .= "</tr>";

			if($na ==count($plans))

			return "";

			

			return $row;

		}

		

		

		

		

	/*******************************************************************************

		This function (design_adminduty_record) generates the row that holds the administrative duty  achievement of the staff in each option

	*******************************************************************************/

	

	function design_adminduty_record( $plans /**options available to a staff**/, $empid /**staff employee id**/)

		{

			$na=0;

			$row="<tr title='Administrative Duties'><td>Administrative Duties</td>";

			for($i=0; $i<count($plans); $i++)//for each option

				{

					$adminduty_req= get_adminduty_req($plans[$i]);

					if(!isset($adminduty_req))

						{

							$row .= "<td>N/A</td><td>N/A</td><td class='rmk'><img src = '../../assets/img/naicon.jpg' alt='not applicable' width='20px' height='20px'/></td>";

							$na++;

							continue;

						}

					$adminduty_ach= get_adminduty_achvt($empid);

					$row .= "<td>".$adminduty_req[0]."</td><td> $adminduty_ach </td><td class='rmk'>";

					if($adminduty_ach >= $adminduty_req[0])

						$row .= "<img src = '../../assets/img/checkicon.jpg' alt='passed' width='20px' height='20px'/></td>";

					else 

						$row .= "<img src = '../../assets/img/crossicon.jpg' alt='' width='20px' height='20px'/></td>";

					

				}

			$row .= "</tr>";

			if($na ==count($plans))

			return "";

			

			return $row;

		}

		

		

		

		

	/*******************************************************************************

		This function (design_minage_record) generates the row that holds the age achievement of the staff in each option

	*******************************************************************************/

	

	function design_minage_record( $plans /**options available to a staff**/, $empid /**staff employee id**/)

		{

			$na=0;

			$row="<tr title='Minimum Age'><td>Minimum Age</td>";

			for($i=0; $i<count($plans); $i++)//for each option

				{

					$minage_req= get_minage_req($plans[$i]);

					if(!isset($minage_req))

						{

							$row .= "<td>N/A</td><td>N/A</td><td class='rmk'><img src = '../../assets/img/naicon.jpg' alt='not applicable' width='20px' height='20px'/></td>";

							$na++;

							continue;

						}

					$minage_ach= get_minage_achvt($empid);

					$row .= "<td>".$minage_req[0]."</td><td> $minage_ach </td><td class='rmk'>";

					if($minage_ach >= $minage_req[0])

						$row .= "<img src = '../../assets/img/checkicon.jpg' alt='passed' width='20px' height='20px'/></td>";

					else 

						$row .= "<img src = '../../assets/img/crossicon.jpg' alt='' width='20px' height='20px'/></td>";

					

				}

			$row .= "</tr>";

			if($na ==count($plans))

			return "";

			

			return $row;

		}

		











		function generate_cklist_Summary($employeeid, $yr, $cadreid, $complexid, $departmentid, $fullname, $rnk, $dname, $rnkinv)

			{

				$guideline_code= get_active_guideline_code();

				//echo $guideline_code;

				$category= get_category($rnkinv, $complexid, $guideline_code);

				$num_options= get_possible_options_count($category);

				//echo $category;

				//echo $guideline_code." ".$yr." ".$cadreid." ".$complexid." ".$departmentid." ".$rnk." ".$dname." ".$fullname." ".$employeeid;

				if($num_options == 0) return;

				$options= get_options($category);

				$final_table ="<table id='opttb'> <caption><h2 style='text-align:center'>AHMADU BELLO UNIVERSITY, ZARIA-NIGERIA</h2><h3>Case of Recomendation for the year " .$year. " Promotion Exercise</h3><br /><h4 style = 'text-align:left;'>CHECKLIST SHEET<br /><br />COMPLEX: ".getComplexName($complexid)."</h4><br /><h5 style = 'text-align:left;'>DEPARTMENT: ".$dname."</h5><h5 style = 'text-align:left;'><br />EMPLOYEE NAME: ".$fullname."</h5><h5 style = 'text-align:left;'><br />RANK IN VIEW: ".getRankName($rnkinv)."</h5></caption>";

				$table_heading= design_table_heading($num_options, $yr, $complexid);

				$final_table .= $table_heading;

				$publications= design_publication_record($options, $employeeid);

				$final_table .= $publications;

				$supervisions = design_supervision_record($options, $employeeid);

				$final_table .= $supervisions;

				$qualifications = design_qualification_record($options, $employeeid);

				$final_table .= $qualifications;

				$waitperiod= design_waitperiod_record($options, $employeeid);

				$final_table .= $waitperiod;

				$comservice = design_comservice_record($options, $employeeid);

				$final_table .= $comservice;

				$adminduty = design_adminduty_record($options, $employeeid);

				$final_table .= $adminduty;

				$minage = design_minage_record($options, $employeeid);

				$final_table .= $minage. "</table><br /><br />";

				echo $final_table;

		

			}



		

	

?>