d.php | searchcode

/d.php

https://bitbucket.org/vincentbii/hkm-legal
PHP | 997 lines | 828 code | 125 blank | 44 comment | 183 complexity | 65fad39f34ba35748e06f160d7d628bf MD5 | raw file

<?php

function getusername($enum) {
$CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR);
  $logSQL = "SELECT * FROM users WHERE authcode = '".$enum."'";
  mysqli_select_db(DB, $CON);
  $done = mysqli_query($logSQL, $CON) or die("ERROR: Trying to retrieve user details - ".mysqli_error());
  $rowuser = mysqli_fetch_assoc($done);
 return $rowuser['fulname'] ;

}

function getauthoriser($enum) {
$CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR);
    $logSQL = "SELECT * FROM employee WHERE id = '".$enum."'";
  mysqli_select_db(DB, $CON);
  $done = mysqli_query($logSQL, $CON) or die("ERROR: Trying to retrieve employee details - ".mysqli_error());
  $rowuser = mysqli_fetch_assoc($done);
 return $rowuser['name'] ;
}

function getdept($enum) {
$CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR);
    $logSQL = "SELECT * FROM employee WHERE id = '".$enum."'";
  mysqli_select_db(DB, $CON);
  $done = mysqli_query($logSQL, $CON) or die("ERROR: Trying to retrieve department details - ".mysqli_error());
  $rowuser = mysqli_fetch_assoc($done);
 return $rowuser['department'] ;
}
function getuserdept($user) {
  $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR); 
  $logSQL = "SELECT department.name FROM department INNER JOIN users ON department.id=users.department WHERE  users.authcode ='".$user."'";
  mysqli_select_db(DB, $CON);
  $done = mysqli_query($logSQL, $CON) or die("ERROR: Trying to user details - ".mysqli_error());
  $rowuser = mysqli_fetch_assoc($done);
  return $rowuser['name'] ;
}


function gettheuserdept($enum) {
$CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR);
    $logSQL = "SELECT * FROM department WHERE id = '".$enum."'";
  mysqli_select_db(DB, $CON);
  $done = mysqli_query($logSQL, $CON) or die("ERROR: Trying to retrieve dept details - ".mysqli_error());
  $rowuser = mysqli_fetch_assoc($done);
 return $rowuser['name'] ;
}



function showbranches($selected = '') {	
	  $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR);
	  $logSQL = "SELECT * FROM companybranch ORDER BY name ASC ";
	  //echo $logSQL;
	  mysqli_select_db(DB, $CON);
	  $done = mysqli_query($logSQL, $CON) or die("ERROR: Trying to retrieve branch - ".mysqli_error());
	  $rowuser = mysqli_fetch_assoc($done);
	  $nums = mysqli_num_rows($done);
		if ($nums > 0) {
		echo "<option> </option>";
		  do {
				
				if ($selected != '' && $selected == $rowuser['id']) 
				{
						echo "<option selected value=\"".$rowuser['id']."\">".$rowuser['name']."</option>";
				} else {
						echo "<option value=\"".$rowuser['id']."\">".$rowuser['name']."</option>";
				}
		  } while($rowuser = mysqli_fetch_assoc($done));
		} else {
				echo "<option>No branch Selected </option>";
		}
}
function showprobations ($selected = '') {	
	  $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR);
	  $logSQL = "SELECT * FROM probationtype ORDER BY name ASC ";
	  //echo $logSQL;
	  mysqli_select_db(DB, $CON);
	  $done = mysqli_query($logSQL, $CON) or die("ERROR: Trying to retrieve probationtype - ".mysqli_error());
	  $rowuser = mysqli_fetch_assoc($done);
	  $nums = mysqli_num_rows($done);
		if ($nums > 0) {
		echo "<option> </option>";
		  do {
				
				if ($selected != '' && $selected == $rowuser['id']) 
				{
						echo "<option selected value=\"".$rowuser['id']."\">".$rowuser['name']."</option>";
				} else {
						echo "<option value=\"".$rowuser['id']."\">".$rowuser['name']."</option>";
				}
		  } while($rowuser = mysqli_fetch_assoc($done));
		} else {
				echo "<option>No probationtype Selected </option>";
		}
}

function showdocuments($selected = '') {	
	  $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR);
	  $logSQL = "SELECT * FROM doc ORDER BY name ASC ";
	  //echo $logSQL;
	  mysqli_select_db(DB, $CON);
	  $done = mysqli_query($logSQL, $CON) or die("ERROR: Trying to retrieve doc - ".mysqli_error());
	  $rowuser = mysqli_fetch_assoc($done);
	  $nums = mysqli_num_rows($done);
		if ($nums > 0) {
		echo "<option> </option>";
		  do {
				
				if ($selected != '' && $selected == $rowuser['id']) 
				{
						echo "<option selected value=\"".$rowuser['id']."\">".$rowuser['name']."</option>";
				} else {
						echo "<option value=\"".$rowuser['id']."\">".$rowuser['name']."</option>";
				}
		  } while($rowuser = mysqli_fetch_assoc($done));
		} else {
				echo "<option>No doc Selected </option>";
		}
}


function showbanks($selected = '') {	
	  $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR);
	  $logSQL = "SELECT * FROM bank ORDER BY name ASC ";
	  //echo $logSQL;
	  mysqli_select_db(DB, $CON);
	  $done = mysqli_query($logSQL, $CON) or die("ERROR: Trying to retrieve Bank - ".mysqli_error());
	  $rowuser = mysqli_fetch_assoc($done);
	  $nums = mysqli_num_rows($done);
		if ($nums > 0) {
		echo "<option> </option>";
		  do {
				
				if ($selected != '' && $selected == $rowuser['id']) 
				{
						echo "<option selected value=\"".$rowuser['id']."\">".$rowuser['name']."</option>";
				} else {
						echo "<option value=\"".$rowuser['id']."\">".$rowuser['name']."</option>";
				}
		  } while($rowuser = mysqli_fetch_assoc($done));
		} else {
				echo "<option>No Bank Selected </option>";
		}
}

function showbankbranches($bank,$selected = '') {	
	  $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR);
	  $logSQL = "SELECT * FROM bankbranch  WHERE bank='".$bank."'ORDER BY name ASC ";
	  //echo $logSQL;
	  mysqli_select_db(DB, $CON);
	  $done = mysqli_query($logSQL, $CON) or die("ERROR: Trying to retrieve Bank branch - ".mysqli_error());
	  $rowuser = mysqli_fetch_assoc($done);
	  $nums = mysqli_num_rows($done);
		if ($nums > 0) {
		echo "<option> </option>";
		  do {
				
				if ($selected != '' && $selected == $rowuser['id']) 
				{
						echo "<option selected value=\"".$rowuser['id']."\">".$rowuser['name']."</option>";
				} else {
						echo "<option value=\"".$rowuser['id']."\">".$rowuser['name']."</option>";
				}
		  } while($rowuser = mysqli_fetch_assoc($done));
		} else {
				echo "<option>No Bank branch Selected </option>";
		}
}




function shownationality($selected = '') {	
	  $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR);
	  $logSQL = "SELECT * FROM nationality ORDER BY  name ASC ";
	  //echo $logSQL;
	  mysqli_select_db(DB, $CON);
	  $done = mysqli_query($logSQL, $CON) or die("ERROR: Trying to retrieve nationality list - ".mysqli_error());
	  $rowuser = mysqli_fetch_assoc($done);
	  $nums = mysqli_num_rows($done);
		if ($nums > 0) {
		echo "<option> </option>";
		  do {
				
				if ($selected != '' && $selected == $rowuser['id']) 
				{
						echo "<option selected value=\"".$rowuser['id']."\">".$rowuser['name']."</option>";
				} else {
						echo "<option value=\"".$rowuser['id']."\">".$rowuser['name']."</option>";
				}
		  } while($rowuser = mysqli_fetch_assoc($done));
		} else {
				echo "<option>No Nationality Selected </option>";
		}
}

function showdeptemployees($selected) {	
	  $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR);
	  $logSQL = "SELECT * FROM employee WHERE department='".$selected."' ORDER BY  name ASC ";
	  //echo $logSQL;
	  mysqli_select_db(DB, $CON);
	  $done = mysqli_query($logSQL, $CON) or die("ERROR: Trying to retrieve employee list - ".mysqli_error());
	  $rowuser = mysqli_fetch_assoc($done);
	  $nums = mysqli_num_rows($done);
		if ($nums > 0) {
		echo "<option> </option>";
		  do {
				
				if ($selected != '' && $selected == $rowuser['id']) 
				{
						echo "<option selected value=\"".$rowuser['id']."\">".$rowuser['name']."   (".$rowuser['empcode'].")"."</option>";
				} else {
						echo "<option value=\"".$rowuser['id']."\">".$rowuser['name']."   (".$rowuser['empcode'].")"."</option>";
				}
		  } while($rowuser = mysqli_fetch_assoc($done));
		} else {
				echo "<option>No EmployeeSelected </option>";
		}
}

function showpretaxdeductions($selected = '') {	
	  $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR);
	  $logSQL = "SELECT * FROM pretaxdeduction ORDER BY  name ASC ";
	  //echo $logSQL;
	  mysqli_select_db(DB, $CON);
	  $done = mysqli_query($logSQL, $CON) or die("ERROR: Trying to retrieve pretaxdeductions list - ".mysqli_error());
	  $rowuser = mysqli_fetch_assoc($done);
	  $nums = mysqli_num_rows($done);
		if ($nums > 0) {
		echo "<option> </option>";
		  do {
				
				if ($selected != '' && $selected == $rowuser['id']) 
				{
						echo "<option selected value=\"".$rowuser['id']."\">".$rowuser['name']."</option>";
				} else {
						echo "<option value=\"".$rowuser['id']."\">".$rowuser['name']." </option>";
				}
		  } while($rowuser = mysqli_fetch_assoc($done));
		} else {
				echo "<option>No pretaxdeductions Selected </option>";
		}
}

function showallowances($selected = '') {	
	  $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR);
	  $logSQL = "SELECT * FROM allowance ORDER BY  name ASC ";
	  //echo $logSQL;
	  mysqli_select_db(DB, $CON);
	  $done = mysqli_query($logSQL, $CON) or die("ERROR: Trying to retrieve allowance list - ".mysqli_error());
	  $rowuser = mysqli_fetch_assoc($done);
	  $nums = mysqli_num_rows($done);
		if ($nums > 0) {
		echo "<option> </option>";
		  do {
				
				if ($selected != '' && $selected == $rowuser['id']) 
				{
						echo "<option selected value=\"".$rowuser['id']."\">".$rowuser['name']."</option>";
				} else {
						echo "<option value=\"".$rowuser['id']."\">".$rowuser['name']." </option>";
				}
		  } while($rowuser = mysqli_fetch_assoc($done));
		} else {
				echo "<option>No allowance Selected </option>";
		}
}

function showleavetypes($selected = '') {	
	  $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR);
	  $logSQL = "SELECT * FROM leavetype ORDER BY  name ASC ";
	  //echo $logSQL;
	  mysqli_select_db(DB, $CON);
	  $done = mysqli_query($logSQL, $CON) or die("ERROR: Trying to retrieve leave type list - ".mysqli_error());
	  $rowuser = mysqli_fetch_assoc($done);
	  $nums = mysqli_num_rows($done);
		if ($nums > 0) {
		echo "<option> </option>";
		  do {
				
				if ($selected != '' && $selected == $rowuser['id']) 
				{
						echo "<option selected value=\"".$rowuser['id']."\">".$rowuser['name']."</option>";
				} else {
						echo "<option value=\"".$rowuser['id']."\">".$rowuser['name']." </option>";
				}
		  } while($rowuser = mysqli_fetch_assoc($done));
		} else {
				echo "<option>No leave type Selected </option>";
		}
}
function showempleaves($selected = '',$emp) {	
	  $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR);
	  $logSQL = "SELECT  leavetype.* FROM empleave INNER JOIN leavetype ON empleave.empleave=leavetype.id WHERE  empleave.employee='".$emp."'  ORDER BY leavetype.name ASC ";
	 // echo $logSQL;
	  mysqli_select_db(DB, $CON);
	  $done = mysqli_query($logSQL, $CON) or die("ERROR: Trying to retrieve leave type list - ".mysqli_error());
	  $rowuser = mysqli_fetch_assoc($done);
	  $nums = mysqli_num_rows($done);
		if ($nums > 0) {
		echo "<option> </option>";
		  do {
				
				if ($selected != '' && $selected == $rowuser['id']) 
				{
						echo "<option selected value=\"".$rowuser['id']."\">".$rowuser['name']."</option>";
				} else {
						echo "<option value=\"".$rowuser['id']."\">".$rowuser['name']." </option>";
				}
		  } while($rowuser = mysqli_fetch_assoc($done));
		} else {
				echo "<option>No leave type Selected </option>";
		}
}



function showlevels($selected = '',$leave) {	
	  $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR);
	  $logSQL = "SELECT level FROM leavetype  WHERE id='".$leave."'ORDER BY  name ASC ";
	  //echo $logSQL;
	  mysqli_select_db(DB, $CON);
	  $done = mysqli_query($logSQL, $CON) or die("ERROR: Trying to retrieve leave type list - ".mysqli_error());
	  $rowuser = mysqli_fetch_assoc($done);
	  $nums = mysqli_num_rows($done);
		if ($nums > 0) {
		echo "<option> </option>";
		
		  for($i=1;$i<=$rowuser['level'];$i++){
				
				if ($selected != '' && $selected == $i) 
				{
						echo "<option selected value=\"".$i."\">".$i."</option>";
				} else {
						echo "<option value=\"".$i."\">".$i." </option>";
				}
		  } 
		} else {
				echo "<option>No leave level defined  </option>";
		}
}


function showdeductions($selected = '') {	
	  $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR);
	  $logSQL = "SELECT * FROM pretaxdeduction ORDER BY  name ASC ";
	  //echo $logSQL;
	  mysqli_select_db(DB, $CON);
	  $done = mysqli_query($logSQL, $CON) or die("ERROR: Trying to retrieve deduction list - ".mysqli_error());
	  $rowuser = mysqli_fetch_assoc($done);
	  $nums = mysqli_num_rows($done);
		if ($nums > 0) {
		echo "<option> </option>";
		  do {
				
				if ($selected != '' && $selected == $rowuser['id']) 
				{
						echo "<option selected value=\"".$rowuser['id']."\">".$rowuser['name']."</option>";
				} else {
						echo "<option value=\"".$rowuser['id']."\">".$rowuser['name']." </option>";
				}
		  } while($rowuser = mysqli_fetch_assoc($done));
		} else {
				echo "<option>No deduction Selected </option>";
		}
}

function showpostdeductions($selected = '') {	
	  $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR);
	  $logSQL = "SELECT * FROM posttaxdeduction ORDER BY  name ASC ";
	  //echo $logSQL;
	  mysqli_select_db(DB, $CON);
	  $done = mysqli_query($logSQL, $CON) or die("ERROR: Trying to retrieve deduction list - ".mysqli_error());
	  $rowuser = mysqli_fetch_assoc($done);
	  $nums = mysqli_num_rows($done);
		if ($nums > 0) {
		echo "<option> </option>";
		  do {
				
				if ($selected != '' && $selected == $rowuser['id']) 
				{
						echo "<option selected value=\"".$rowuser['id']."\">".$rowuser['name']."</option>";
				} else {
						echo "<option value=\"".$rowuser['id']."\">".$rowuser['name']." </option>";
				}
		  } while($rowuser = mysqli_fetch_assoc($done));
		} else {
				echo "<option>No deduction Selected </option>";
		}
}


function showpositions($selected = '') {	
	  $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR);
	  $logSQL = "SELECT * FROM jobposition ORDER BY  name ASC ";
	  //echo $logSQL;
	  mysqli_select_db(DB, $CON);
	  $done = mysqli_query($logSQL, $CON) or die("ERROR: Trying to retrieve job position list - ".mysqli_error());
	  $rowuser = mysqli_fetch_assoc($done);
	  $nums = mysqli_num_rows($done);
		if ($nums > 0) {
		echo "<option> </option>";
		  do {
				
				if ($selected != '' && $selected == $rowuser['id']) 
				{
						echo "<option selected value=\"".$rowuser['id']."\">".$rowuser['name']."</option>";
				} else {
						echo "<option value=\"".$rowuser['id']."\">".$rowuser['name']."</option>";
				}
		  } while($rowuser = mysqli_fetch_assoc($done));
		} else {
				echo "<option>No Job Position Selected </option>";
		}
}

function showacademiccourses($selected = '') {	
	  $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR);
	  $logSQL = "SELECT * FROM academiccourse ORDER BY  name ASC ";
	  //echo $logSQL;
	  mysqli_select_db(DB, $CON);
	  $done = mysqli_query($logSQL, $CON) or die("ERROR: Trying to retrieve Academic Course list - ".mysqli_error());
	  $rowuser = mysqli_fetch_assoc($done);
	  $nums = mysqli_num_rows($done);
		if ($nums > 0) {
		echo "<option> </option>";
		  do {
				
				if ($selected != '' && $selected == $rowuser['id']) 
				{
						echo "<option selected value=\"".$rowuser['id']."\">".$rowuser['name']."</option>";
				} else {
						echo "<option value=\"".$rowuser['id']."\">".$rowuser['name']."</option>";
				}
		  } while($rowuser = mysqli_fetch_assoc($done));
		} else {
				echo "<option>No Academic Course Selected </option>";
		}
}

function showproffesionalcourses($selected = '') {	
	  $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR);
	  $logSQL = "SELECT * FROM proffesionalcourse ORDER BY  name ASC ";
	  //echo $logSQL;
	  mysqli_select_db(DB, $CON);
	  $done = mysqli_query($logSQL, $CON) or die("ERROR: Trying to retrieve proffesional Course list - ".mysqli_error());
	  $rowuser = mysqli_fetch_assoc($done);
	  $nums = mysqli_num_rows($done);
		if ($nums > 0) {
		echo "<option> </option>";
		  do {
				
				if ($selected != '' && $selected == $rowuser['id']) 
				{
						echo "<option selected value=\"".$rowuser['id']."\">".$rowuser['name']."</option>";
				} else {
						echo "<option value=\"".$rowuser['id']."\">".$rowuser['name']."</option>";
				}
		  } while($rowuser = mysqli_fetch_assoc($done));
		} else {
				echo "<option>No proffesional Course Selected </option>";
		}
}


function showacademicawards($selected = '') {	
	  $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR);
	  $logSQL = "SELECT * FROM academicaward ORDER BY  name ASC ";
	  //echo $logSQL;
	  mysqli_select_db(DB, $CON);
	  $done = mysqli_query($logSQL, $CON) or die("ERROR: Trying to retrieve Academic award list - ".mysqli_error());
	  $rowuser = mysqli_fetch_assoc($done);
	  $nums = mysqli_num_rows($done);
		if ($nums > 0) {
		echo "<option> </option>";
		  do {
				
				if ($selected != '' && $selected == $rowuser['id']) 
				{
						echo "<option selected value=\"".$rowuser['id']."\">".$rowuser['name']."</option>";
				} else {
						echo "<option value=\"".$rowuser['id']."\">".$rowuser['name']."</option>";
				}
		  } while($rowuser = mysqli_fetch_assoc($done));
		} else {
				echo "<option>No Academic award Selected </option>";
		}
}

function showproffesionalawards($selected = '') {	
	  $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR);
	  $logSQL = "SELECT * FROM proffesionalaward ORDER BY  name ASC ";
	  //echo $logSQL;
	  mysqli_select_db(DB, $CON);
	  $done = mysqli_query($logSQL, $CON) or die("ERROR: Trying to retrieve proffesional award list - ".mysqli_error());
	  $rowuser = mysqli_fetch_assoc($done);
	  $nums = mysqli_num_rows($done);
		if ($nums > 0) {
		echo "<option> </option>";
		  do {
				
				if ($selected != '' && $selected == $rowuser['id']) 
				{
						echo "<option selected value=\"".$rowuser['id']."\">".$rowuser['name']."</option>";
				} else {
						echo "<option value=\"".$rowuser['id']."\">".$rowuser['name']."</option>";
				}
		  } while($rowuser = mysqli_fetch_assoc($done));
		} else {
				echo "<option>No proffesional award Selected </option>";
		}
}



function showempterms($selected = '') {	
	  $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR);
	  $logSQL = "SELECT * FROM employmentterm ORDER BY  name ASC ";
	  //echo $logSQL;
	  mysqli_select_db(DB, $CON);
	  $done = mysqli_query($logSQL, $CON) or die("ERROR: Trying to retrieve employement term list - ".mysqli_error());
	  $rowuser = mysqli_fetch_assoc($done);
	  $nums = mysqli_num_rows($done);
		if ($nums > 0) {
		echo "<option> </option>";
		  do {
				
				if ($selected != '' && $selected == $rowuser['id']) 
				{
						echo "<option selected value=\"".$rowuser['id']."\">".$rowuser['name']."</option>";
				} else {
						echo "<option value=\"".$rowuser['id']."\">".$rowuser['name']."</option>";
				}
		  } while($rowuser = mysqli_fetch_assoc($done));
		} else {
				echo "<option>No Employment term  Selected </option>";
		}
}

function showdepartments($selected = '') {	
	  $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR);
	  $logSQL = "SELECT * FROM department ORDER BY  name ASC ";
	  //echo $logSQL;
	  mysqli_select_db(DB, $CON);
	  $done = mysqli_query($logSQL, $CON) or die("ERROR: Trying to retrieve department list - ".mysqli_error());
	  $rowuser = mysqli_fetch_assoc($done);
	  $nums = mysqli_num_rows($done);
		if ($nums > 0) {
		echo "<option> </option>";
		  do {
				
				if ($selected != '' && $selected == $rowuser['id']) 
				{
						echo "<option selected value=\"".$rowuser['id']."\">".$rowuser['name']."</option>";
				} else {
						echo "<option value=\"".$rowuser['id']."\">".$rowuser['name']."</option>";
				}
		  } while($rowuser = mysqli_fetch_assoc($done));
		} else {
				echo "<option>No department Selected </option>";
		}
}
function showcategory($selected = '') {	
	  $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR);
	  $logSQL = "SELECT * FROM  employeecategory ORDER BY  name ASC ";
	  //echo $logSQL;
	  mysqli_select_db(DB, $CON);
	  $done = mysqli_query($logSQL, $CON) or die("ERROR: Trying to retrieve staffcategory list - ".mysqli_error());
	  $rowuser = mysqli_fetch_assoc($done);
	  $nums = mysqli_num_rows($done);
		if ($nums > 0) {
		echo "<option> </option>";
		  do {
				
				if ($selected != '' && $selected == $rowuser['id']) 
				{
						echo "<option selected value=\"".$rowuser['id']."\">".$rowuser['name']."</option>";
				} else {
						echo "<option value=\"".$rowuser['id']."\">".$rowuser['name']."</option>";
				}
		  } while($rowuser = mysqli_fetch_assoc($done));
		} else {
				echo "<option>No employee category Selected </option>";
		}
}

function showreligion($selected = '') {	
	  $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR);
	  $logSQL = "SELECT * FROM religion ORDER BY  name ASC ";
	  //echo $logSQL;
	  mysqli_select_db(DB, $CON);
	  $done = mysqli_query($logSQL, $CON) or die("ERROR: Trying to retrieve religions list - ".mysqli_error());
	  $rowuser = mysqli_fetch_assoc($done);
	  $nums = mysqli_num_rows($done);
		if ($nums > 0) {
		echo "<option> </option>";
		  do {
				
				if ($selected != '' && $selected == $rowuser['id']) 
				{
						echo "<option selected value=\"".$rowuser['id']."\">".$rowuser['name']."</option>";
				} else {
						echo "<option value=\"".$rowuser['id']."\">".$rowuser['name']."</option>";
				}
		  } while($rowuser = mysqli_fetch_assoc($done));
		} else {
				echo "<option>No religion Selected </option>";
		}
}




 

  function getcourse($field) {
 $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR); 
$logSQL =  "SELECT  * FROM academiccourse  WHERE id='".$field."' LIMIT 1";
//echo $logSQL;
  mysqli_select_db(DB, $CON);
	$prq1 = mysqli_query($logSQL, $CON) or die(mysqli_error());
	$row_prq1 = mysqli_fetch_assoc($prq1);
	$nums = mysqli_num_rows($prq1);	
		return $row_prq1['name'];	
  }
  
  function getpcourse($field) {
 $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR); 
$logSQL =  "SELECT  * FROM proffesionalcourse  WHERE id='".$field."' LIMIT 1";
//echo $logSQL;
  mysqli_select_db(DB, $CON);
	$prq1 = mysqli_query($logSQL, $CON) or die(mysqli_error());
	$row_prq1 = mysqli_fetch_assoc($prq1);
	$nums = mysqli_num_rows($prq1);	
		return $row_prq1['name'];
	
  }
  
  function getaward($field) {
 $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR); 
$logSQL =  "SELECT  * FROM academicaward  WHERE id='".$field."' LIMIT 1";
//echo $logSQL;
  mysqli_select_db(DB, $CON);
	$prq1 = mysqli_query($logSQL, $CON) or die(mysqli_error());
	$row_prq1 = mysqli_fetch_assoc($prq1);
	$nums = mysqli_num_rows($prq1);	
		return $row_prq1['name'];	
  }
  
   function getpaward($field) {
 $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR); 
$logSQL =  "SELECT  * FROM proffesionalaward  WHERE id='".$field."' LIMIT 1";
//echo $logSQL;
  mysqli_select_db(DB, $CON);
	$prq1 = mysqli_query($logSQL, $CON) or die(mysqli_error());
	$row_prq1 = mysqli_fetch_assoc($prq1);
	$nums = mysqli_num_rows($prq1);	
		return $row_prq1['name'];	
  }
  
  function getuserid() {
 $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR); 
$logSQL =  "SELECT  employee  FROM users  WHERE authcode='".$_SESSION['UNQ']."' LIMIT 1";
//echo $logSQL;
  mysqli_select_db(DB, $CON);
	$prq1 = mysqli_query($logSQL, $CON) or die(mysqli_error());
	$row_prq1 = mysqli_fetch_assoc($prq1);
	$nums = mysqli_num_rows($prq1);	
		return $row_prq1['employee'];	
  } 
    
  function getusrdept() {
 $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR); 
$logSQL =  "SELECT  department  FROM employee  WHERE id='".getuserid()."' LIMIT 1";
//echo $logSQL;
  mysqli_select_db(DB, $CON);
	$prq1 = mysqli_query($logSQL, $CON) or die(mysqli_error());
	$row_prq1 = mysqli_fetch_assoc($prq1);
	$nums = mysqli_num_rows($prq1);
	
		return $row_prq1['department'];
	
  }

  function getdepartment($field) {
 $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR); 
$logSQL =  "SELECT  * FROM  department  WHERE id='".$field."' LIMIT 1";
//echo $logSQL;
  mysqli_select_db(DB, $CON);
	$prq1 = mysqli_query($logSQL, $CON) or die(mysqli_error());
	$row_prq1 = mysqli_fetch_assoc($prq1);
	$nums = mysqli_num_rows($prq1);	
		return $row_prq1['name'];	
  }
  
  function getdeduction($field) {
 $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR); 
$logSQL =  "SELECT  * FROM pretaxdeduction  WHERE id='".$field."' LIMIT 1";
//echo $logSQL;
  mysqli_select_db(DB, $CON);
	$prq1 = mysqli_query($logSQL, $CON) or die(mysqli_error());
	$row_prq1 = mysqli_fetch_assoc($prq1);
	$nums = mysqli_num_rows($prq1);	
		return $row_prq1['name'];	
  }
  
   function getjobposition($field) {
 $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR); 
$logSQL =  "SELECT  * FROM jobposition  WHERE id='".$field."' LIMIT 1";
//echo $logSQL;
  mysqli_select_db(DB, $CON);
	$prq1 = mysqli_query($logSQL, $CON) or die(mysqli_error());
	$row_prq1 = mysqli_fetch_assoc($prq1);
	$nums = mysqli_num_rows($prq1);	
		return $row_prq1['name'];	
  }
  
   function getjobpos($field) {
 $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR); 
$logSQL =  "SELECT jobposition FROM employee  WHERE id='".$field."' LIMIT 1";
//echo $logSQL;
  mysqli_select_db(DB, $CON);
	$prq1 = mysqli_query($logSQL, $CON) or die(mysqli_error());
	$row_prq1 = mysqli_fetch_assoc($prq1);
	$nums = mysqli_num_rows($prq1);	
		return getjobposition($row_prq1['jobposition']);	
  }
  
   function getallowance($field) {
 $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR); 
$logSQL =  "SELECT  * FROM allowance  WHERE id='".$field."' LIMIT 1";
//echo $logSQL;
  mysqli_select_db(DB, $CON);
	$prq1 = mysqli_query($logSQL, $CON) or die(mysqli_error());
	$row_prq1 = mysqli_fetch_assoc($prq1);
	$nums = mysqli_num_rows($prq1);	
		return $row_prq1['name'];	
  }
   function getleave($field) {
 $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR); 
$logSQL =  "SELECT  * FROM leavetype  WHERE id='".$field."' LIMIT 1";
//echo $logSQL;
  mysqli_select_db(DB, $CON);
	$prq1 = mysqli_query($logSQL, $CON) or die(mysqli_error());
	$row_prq1 = mysqli_fetch_assoc($prq1);
	$nums = mysqli_num_rows($prq1);	
		return $row_prq1['name'];	
  }  
  


   function getempid() {
 $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR); 
$logSQL =  "SELECT  * FROM users WHERE authcode='".$_SESSION['UNQ']."' LIMIT 1";
//echo $logSQL;
  mysqli_select_db(DB, $CON);
	$prq1 = mysqli_query($logSQL, $CON) or die(mysqli_error());
	$row_prq1 = mysqli_fetch_assoc($prq1);
	$nums = mysqli_num_rows($prq1);	
		return $row_prq1['uid'];	
  }
   function getmyempid() {
 $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR); 
$logSQL =  "SELECT  * FROM users WHERE authcode='".$_SESSION['UNQ']."' LIMIT 1";
//echo $logSQL;
  mysqli_select_db(DB, $CON);
	$prq1 = mysqli_query($logSQL, $CON) or die(mysqli_error());
	$row_prq1 = mysqli_fetch_assoc($prq1);
	$nums = mysqli_num_rows($prq1);	
		return $row_prq1['uid'];	
  }

  
  function getemployee($enum) {
  $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR);
  $logSQL = "SELECT * FROM employee WHERE  id = '".$enum."'";
  mysqli_select_db(DB, $CON);
  $done = mysqli_query($logSQL, $CON) or die("ERROR: Trying to retrieve  employee - ".mysqli_error());
  $rowuser = mysqli_fetch_assoc($done);
  $result="EMP CODE : ".$rowuser['empcode']."&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Name : ".$rowuser['name'];
 // echo $result
  return  $result;
}

function getempl($enum) {
  $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR);
  $logSQL = "SELECT * FROM employee WHERE  id = '".$enum."'";
  mysqli_select_db(DB, $CON);
  $done = mysqli_query($logSQL, $CON) or die("ERROR: Trying to retrieve  employee - ".mysqli_error());
  $rowuser = mysqli_fetch_assoc($done);
  $result= $rowuser['name'];
 // echo $result
  return  $result;
}


function getuseremail($enum) {
  $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR);
  $logSQL = "SELECT * FROM employee WHERE  id = '".$enum."'";
  mysqli_select_db(DB, $CON);
  $done = mysqli_query($logSQL, $CON) or die("ERROR: Trying to retrieve  teacher - ".mysqli_error());
  $rowuser = mysqli_fetch_assoc($done);
  return $rowuser['email'];
}
function getusertel($enum) {
  $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR);
  $logSQL = "SELECT * FROM employee WHERE  id = '".$enum."'";
  mysqli_select_db(DB, $CON);
  $done = mysqli_query($logSQL, $CON) or die("ERROR: Trying to retrieve  teacher - ".mysqli_error());
  $rowuser = mysqli_fetch_assoc($done);
  return $rowuser['hometel'];
}
function getauthusername($enum) {
  $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR);
  $logSQL = "SELECT * FROM employee WHERE  id = '".$enum."'";
  mysqli_select_db(DB, $CON);
  $done = mysqli_query($logSQL, $CON) or die("ERROR: Trying to retrieve  teacher - ".mysqli_error());
  $rowuser = mysqli_fetch_assoc($done);
  return $rowuser['name'];
}


function create_temppayroll () { 	
	drop_temppayroll ();	
	$CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR); 
   	mysqli_select_db(DB, $CON);	
	$_SESSION['temppayroll'] = "temppayroll".$_SESSION['UNQ'];
	  $sql = 'CREATE TABLE `'.$_SESSION['temppayroll'].'` ('
		. ' `employee` INT(10) NOT NULL ,'
		. ' `pretax` DECIMAL(10,2) NOT NULL  DEFAULT "0.00",  '
		. ' `posttax` DECIMAL(10,2)  NOT NULL  DEFAULT "0.00",  '
		. ' `allowance` DECIMAL(10,2)  NOT NULL  DEFAULT "0.00",  '
		. ' `grosspay` DECIMAL(10,2)  NOT NULL  DEFAULT "0.00", '
		. ' `taxableamount` DECIMAL(10,2)  NOT NULL  DEFAULT "0.00" , '
		. ' `Payee` DECIMAL(10,2)  NOT NULL  DEFAULT "0.00" ,'
		. ' `deduction` DECIMAL(10,2)  NOT NULL  DEFAULT "0.00" , '
		. ' `tdeduction` DECIMAL(10,2)  NOT NULL  DEFAULT "0.00" ,'
		. ' `netpay` DECIMAL(10,2)  NOT NULL  DEFAULT "0.00" '		
								
		. ' )'
		. ' ENGINE = innodb;';

	$done = mysqli_query($sql, $CON) or die("ERROR: Trying to create temppayroll  table- ".mysqli_error());
	
} 


function drop_temppayroll () { 	
	$CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR); 
   	mysqli_select_db(DB, $CON);
	
	$_SESSION['temppayroll'] = "temppayroll".$_SESSION['UNQ'];		  
	$deleteSQL = "DROP TABLE IF EXISTS ".$_SESSION['temppayroll']."";
	$done = mysqli_query($deleteSQL, $CON) or die("ERROR: Trying to delete temppayroll table - ".mysqli_error());
	
}

function insertrecords ($table,$field1,$val1) { 	
	$CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR); 
   	mysqli_select_db(DB, $CON);	
		  $sql = "INSERT INTO  ".$table." (".$field1.") VALUES(".$val1.")";
		$done = mysqli_query($sql, $CON) or die("ERROR: Trying to save record- ".mysqli_error());
	
} 

function deleterecords () { 	
	$CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR); 
   	mysqli_select_db(DB, $CON);	
		  $sql1 = "DELETE FROM  ".$_SESSION['temppayroll']." ";
		  $done1 = mysqli_query($sql1, $CON) or die("ERROR: Trying to delete record- ".mysqli_error());	  
		 	
} 

function updaterecords ($table,$field1,$val1,$emp) { 	
	$CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR); 
   	mysqli_select_db(DB, $CON);	
		  $sql = "UPDATE  ".$table." SET ".$field1."=".$val1." WHERE employee=".$emp."";
		  //echo  $sql."<BR>";
		$done = mysqli_query($sql, $CON) or die("ERROR: Trying to update record- ".mysqli_error());
	
} 

function create_temppayee  () { 	
	drop_temppayee ();	
	$CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR); 
   	mysqli_select_db(DB, $CON);	
	$_SESSION['temppayee'] = "temppayee".$_SESSION['UNQ'];
	  $sql = 'CREATE TABLE `'.$_SESSION['temppayee'].'` ('
		. ' `employee` INT(10)  NULL ,'
		. ' `total` DECIMAL(10,2)  NULL  '
								
		. ' )'
		. ' ENGINE = innodb;';

	$done = mysqli_query($sql, $CON) or die("ERROR: Trying to create temppayee   table- ".mysqli_error());
	
} 


function drop_temppayee  () { 	
	$CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR); 
   	mysqli_select_db(DB, $CON);	
	$_SESSION['temppayee'] = "temppayee".$_SESSION['UNQ'];		  
	$deleteSQL = "DROP TABLE IF EXISTS ".$_SESSION['temppayee']."";
	//echo $deleteSQL;
	$done = mysqli_query($deleteSQL, $CON) or die("ERROR: Trying to delete temppayee  table - ".mysqli_error());
	
}


function showempls($selected = '') {	
	  $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR);
	  $logSQL = "SELECT * FROM users ORDER BY  fulname ASC ";
	  //echo $logSQL;
	  mysqli_select_db(DB, $CON);
	  $done = mysqli_query($logSQL, $CON) or die("ERROR: Trying to retrieve user list - ".mysqli_error());
	  $rowuser = mysqli_fetch_assoc($done);
	  $nums = mysqli_num_rows($done);
		if ($nums > 0) {
		echo "<option> </option>";
		  do {
				
				if ($selected != '' && $selected == $rowuser['uid']) 
				{
						echo "<option selected value=\"".$rowuser['uid']."\">".$rowuser['fulname']." (".$rowuser['authcode'].")</option>";
				} else {
						echo "<option value=\"".$rowuser['uid']."\">".$rowuser['fulname']." (".$rowuser['authcode'].")</option>";
				}
		  } while($rowuser = mysqli_fetch_assoc($done));
		} else {
				echo "<option>No user Selected </option>";
		}
}

  function getdesignation($enum) {
  $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR);
  $logSQL = "SELECT * FROM users WHERE  authcode = '".$enum."'";
  mysqli_select_db(DB, $CON);
  $done = mysqli_query($logSQL, $CON) or die("ERROR: Trying to retrieve  usertype - ".mysqli_error());
  $rowuser = mysqli_fetch_assoc($done);
  return $rowuser['designation'];
}
 

function showemployees($selected = '') {
	
	  $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR);
	  $logSQL = "SELECT * FROM employee ORDER BY  name ASC ";
	  //echo $logSQL;
	  mysqli_select_db(DB, $CON);
	  $done = mysqli_query($logSQL, $CON) or die("ERROR: Trying to retrieve employee list - ".mysqli_error());
	  $rowuser = mysqli_fetch_assoc($done);
	  $nums = mysqli_num_rows($done);
		if ($nums > 0) {
		echo "<option> </option>";
		  do {
				
				if ($selected != '' && $selected == $rowuser['id']) 
				{
						echo "<option selected value=\"".$rowuser['id']."\">".$rowuser['name']."</option>";
				} else {
						echo "<option value=\"".$rowuser['id']."\">".$rowuser['name']."</option>";
				}
		  } while($rowuser = mysqli_fetch_assoc($done));
		} else {
				echo "<option>No employee Selected </option>";
		}
}


function showweekno($selected = '') {	
	  $CON = mysqli_pconnect(HOSTNAME, username, PWD) or trigger_error(mysqli_error(),E_USER_ERROR);
	  $logSQL = "SELECT * FROM weekno ORDER BY  name ASC ";
	  //echo $logSQL;
	  mysqli_select_db(DB, $CON);
	  $done = mysqli_query($logSQL, $CON) or die("ERROR: Trying to retrieve weeks list - ".mysqli_error());
	  $rowuser = mysqli_fetch_assoc($done);
	  $nums = mysqli_num_rows($done);
		if ($nums > 0) {
		echo "<option> </option>";
		  do {
				
				if ($selected != '' && $selected == $rowuser['name']) 
				{
						echo "<option selected value=\"".$rowuser['name']."\">".$rowuser['name']."</option>";
				} else {
						echo "<option value=\"".$rowuser['name']."\">".$rowuser['name']."</option>";
				}
		  } while($rowuser = mysqli_fetch_assoc($done));
		} else {
				echo "<option>No Week Selected </option>";
		}
}


?>