load_interview_panels_table.php

/recruitment/admin/load_interview_panels_table.php

https://bitbucket.org/lecturer34/hrmis
PHP | 183 lines | 126 code | 32 blank | 25 comment | 15 complexity | 39d2658a24906b408cb48169265c66ff MD5 | raw file
Possible License(s): LGPL-2.1

<?php

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

	openConnection();



	function load_table_of_interview_parameters(){

	

		$returnVal = '';

 

		$q = "SELECT scoreitemid, scoreitemdescription FROM tblinterviewscoreitems ORDER BY scoreitemdescription";

		

		$query = mysql_query($q);

		$foundRecord = mysql_num_rows($query);



		$returnVal .= '<table border="1px" style="border-collapse: collapse; width:100%; margin-top:10px" cellpadding="5px" cellspacing="10px">';

			

		if ($foundRecord > 0) {

			$i = 0;

			$returnVal .= '<tr style="border: solid 1px;font-weight:bold"><td align="center">SN</td><td>SCORE ITEM / CRITERION</td><td align="right">ACTION</td></tr>';

			while ($row = mysql_fetch_assoc($query)){

				$i ++;

				$returnVal .= '<tr style="border: solid 1px;"><td align="center">' . $i . '</td>';

				$returnVal .= '<td>' . $row['scoreitemdescription'] . '</td>';

				$ePointer = $row['scoreitemid'] + 1024; $dPointer = $ePointer;



				$returnVal .= '<td><div class="div_square_link"><a href="interview_panel_edit.php?edit_pointer=' . $ePointer . '" title="click to edit this interview panel">[edit]</a>&nbsp;&nbsp;&nbsp;<a href="interview_panel_delete.php?delete_pointer=' . $dPointer . '" title="click to delete this interview panel">[delete]</a></div></td></tr>';

			}//end while

		}else {

			$returnVal .= '<tr style="border: solid 1px;font-weight:bold" colspan="6" align="center"><td>THERE IS NO INTERVIEW SCORE CRITERIA DEFINED YET</td></tr>';

		}//end if ($foundRecord == 1)

		$returnVal .= '</table></br>';

		return $returnVal;

	}





	function load_table_of_interview_panels($flag_parameter){

		

		$returnVal = '';

 

		$q = "SELECT rowid, panelname, dateconstituted, constitutedby FROM tblinterviewpanels ORDER BY dateconstituted, panelname";

		

		$query = mysql_query($q);

		$foundRecord = mysql_num_rows($query);



		$returnVal .= '<table border="1px" style="border-collapse: collapse; width:100%; margin-top:10px" cellpadding="5px" cellspacing="10px">';

			

		if ($foundRecord > 0) {

			$i = 0;

			$returnVal .= '<tr style="border: solid 1px;font-weight:bold"><td>SN</td><td>PANEL NAME</td><td>DATE CONSTITUTED</td><td>CONSTITUTED BY</td><td align="center">ACTION</td></tr>';

			while ($row = mysql_fetch_assoc($query)){

				$i ++;							

				$returnVal .= '<tr style="border: solid 1px;"><td align="center">' . $i . '</td>';

				$returnVal .= '<td>' . $row['panelname'] . '</td>';

				$returnVal .= '<td>' . get_my_date_format($row['dateconstituted'], 'L') . '</td>';

				$returnVal .= '<td>' . $row['constitutedby'] . '</td>';

				$ePointer = $row['rowid'] + 1024; $dPointer = $ePointer;

				if ($flag_parameter == 'manage'){

					$returnVal .= '<td><div class="div_square_link"><a href="interview_panel_edit.php?edit_pointer=' . $ePointer . '" title="click to edit this interview panel">[edit]</a>&nbsp;&nbsp;&nbsp;<a href="interview_panel_delete.php?delete_pointer=' . $dPointer . '" title="click to delete this interview panel">[delete]</a>&nbsp;&nbsp;&nbsp;<a href="interview_schedule_details.php?schedule_pointer=' . $ePointer . '" title="click to set work schedule for this interview panel">[schedule]</a></div></td></tr>';

				}else{

					$returnVal .= '<td><div class="div_square_link"><a href="interview_schedule_details.php?schedule_pointer=' . $ePointer . '" title="click to set work schedule for this interview panel">[schedule]</a></div></td></tr>';

				}

			}//end while

		}else {

			$returnVal .= '<tr style="border: solid 1px;font-weight:bold" colspan="6" align="center"><td>THERE IS NO INTERVIEW PANEL CREATED YET</td></tr>';

		}//end if ($foundRecord == 1)

		$returnVal .= '</table></br>';

		return $returnVal;

	}

	

	/*

	function load_interview_panels_into_combo($sess_panelID){		

		$returnVal = ''; 

		$q = "SELECT rowid, panelname FROM tblinterviewpanels ORDER BY panelname";

		

		$query = mysql_query($q);

		$foundRecord = mysql_num_rows($query);

		

		if ($foundRecord > 0) {

			$returnVal .= "<option value = '-1'>-- Please Select --</option>";

			while ($row = mysql_fetch_assoc($query)){

				if($row['rowid'] == $sess_panelID){

					$returnVal .= "<option value='" . $row['rowid'] . "' selected='selected'>" . $row['panelname'] . "</option>";

				}else{

					$returnVal .= "<option value='" . $row['rowid'] . "'>" . $row['panelname'] . "</option>";

				}

			}

		}else{

			$returnVal = "<option value = '-1'>No Data in Interview Panels Table</option>";

		}//end if ($foundRecord == 1)



		return $returnVal;

	}

	

	*/

	function get_table_of_interview_panel_members($panelID, $allow_edit_delete){

		$returnVal = '';

		$panelID = clean($panelID);

		

		$q = "SELECT tblinterviewpanelmembers.rowid, memberfullname, personnelnumber, memberdepartmentid, memberrole, tbldepartment.name as department ";

		$q .= "FROM tblinterviewpanelmembers LEFT JOIN tbldepartment ON tblinterviewpanelmembers.memberdepartmentid = tbldepartment.departmentid ";

		$q .= "WHERE panelrowid = $panelID ORDER BY memberfullname";

		

		$query = mysql_query($q);

		$foundRecord = mysql_num_rows($query);



		$returnVal .= '<table border="1px" style="border-collapse: collapse; width:100%; margin-top:10px" cellpadding="5px" cellspacing="10px">';

		

		if ($foundRecord > 0) {

			$i = 0;

			$returnVal .= '<tr style="border: solid 1px;font-weight:bold"><td>SN</td><td>PANEL MEMBERS</td><td>P.NUMBER</td><td>DEPT / DIVISION</td><td>ROLE</td><td align="right">ACTION</td></tr>';

			while ($row = mysql_fetch_assoc($query)){

				$i ++;

				$returnVal .= '<tr style="border: solid 1px;"><td align="center">' . $i . '</td>';

				$returnVal .= '<td>' . $row['memberfullname'] . '</td>';

				$returnVal .= '<td>' . $row['personnelnumber'] . '</td>';

				$returnVal .= '<td>' . $row['department'] . '</td>';

				$returnVal .= '<td>' . $row['memberrole'] . '</td>';

				

				if ($allow_edit_delete == true){

					$ePointer = $row['rowid'] + 1024; $dPointer = $ePointer;

					$returnVal .= '<td><div class="div_square_link"><a href="interview_panel_member_edit.php?edit_pointer=' . $ePointer . '" title="click to edit this panel member">[edit]</a>&nbsp;&nbsp;&nbsp;<a href="interview_panel_member_delete.php?delete_pointer=' . $dPointer . '" title="click to delete this panel member">[delete]</a></div></td></tr>';

				}else{

					$returnVal .= '<td>&mdash;</td></tr>';

				}	

			}//end while

		}else {

			$returnVal .= '<tr style="border: solid 1px;font-weight:bold" colspan="6" align="center"><td>THERE IS NO INTERVIEW PANEL MEMBERS ADDED YET</td></tr>';

		}//end if ($foundRecord == 1)

		$returnVal .= '</table></br>';



		return $returnVal;

	}

	

	

	function get_panel_name_from_id($panel_ID){

		$returnVal = '';

 		$panel_ID = clean($panel_ID);

		

		$q = "SELECT panelname FROM tblinterviewpanels WHERE rowid = $panel_ID";

		

		$query = mysql_query($q);

		$foundRecord = mysql_num_rows($query);

		

		if ($foundRecord == 1) {

			$row = mysql_fetch_assoc($query);

			$returnVal = $row['panelname'];			

		}else {

			$returnVal = 'Invalid Panel ID';

		}

		return $returnVal;

	}

	

	function get_members_panelname_from_member_id($member_id){

		$returnVal = '';

		$member_id = clean($member_id);

		

		$q = "SELECT memberfullname, panelname FROM tblinterviewpanelmembers LEFT JOIN ";

		$q .= "tblinterviewpanels ON tblinterviewpanelmembers.panelrowid = tblinterviewpanels.rowid WHERE tblinterviewpanelmembers.rowid = $member_id";



		$query = mysql_query($q);

		$foundRecord = mysql_num_rows($query);

		

		if ($foundRecord == 1) {

			$row = mysql_fetch_assoc($query);

			$returnVal = $row['panelname'];			

		}else {

			$returnVal = 'Invalid Panel Member ID';

		}

		return $returnVal;

	}

	

	

	function count_interview_panels(){

		$q = "SELECT COUNT(rowid) as pnlCount FROM tblinterviewpanels";

		$c = 0;

		$query = mysql_query($q);

		$foundRecord = mysql_num_rows($query);

		if ($foundRecord > 0) {

			$row = mysql_fetch_assoc($query);

			$c = $row['pnlCount'];

		}

		return $c;

	}

?>