0){
$errorMSG="Record already exist.";
}else{
//store data
$sql = "INSERT INTO pms_officers (
`id`,
`comp_id`,
`pms_officer_id`,
`role_level`,
`date_created`,
`created_by`)
VALUES (
'',
'$selUnitID',
'$employeeSearchID',
'$selRole',
'$myTimeStamp',
'$userID')";
if ($conn->query($sql) === TRUE) {
$errorMSG="Record has been saved.";
} else {
$errorMSG="Error saving record. SQL Error detected at line: 49 loadCompanyApprover @ swtich #2";
}
}
break;
case 3: //DELETE aprID
$userID = $_POST['userID'];
$aprID = $_POST['aprID'];
$selUnitID = $_POST['selUnitID'];
$sql = "UPDATE pms_officers SET deleted = 1,date_modified='$myTimeStamp',modified_by='$userID',`last_action`='Deleted' WHERE `id`='$aprID' AND `comp_id`='$selUnitID'";
if ($conn->query($sql) === TRUE) {
$errorMSG="Record has been updated.";
} else {
$errorMSG="Error saving record. SQL Error detected at line: 63 loadCompanyApprover @ swtich #3";
}
break;
}
$getCApprover = "SELECT * FROM `pms_officers` WHERE `deleted`=0 AND `comp_id`='$selUnitID' ORDER BY `id` ASC";
$getApr = mysqli_query($conn,$getCApprover);
$statRow = mysqli_num_rows($getApr);
while($row = mysqli_fetch_array($getApr)){
$pmsOfficer = $row['pms_officer_id'];
$empLevel = $row['role_level'];
$getEmpInfo = "SELECT * FROM `pms_employee_data` WHERE `deleted`=0 AND `id` ='$pmsOfficer' ORDER BY `last_name` ASC";
$getEmp = mysqli_query($conn,$getEmpInfo);
$statRow = mysqli_num_rows($getEmp);
if($statRow > 0){
while($eow = mysqli_fetch_array($getEmp)){
$empLName = $eow['last_name'];
$empFName = $eow['first_name'];
$empID = $eow['emp_id'];
}
}
?>".$row['id']."";
echo "| ";
echo $empID;
echo " | ";
echo "";
echo strtoupper($empFName);
echo " | ";
echo "";
echo strtoupper($empLName);
echo " | ";
echo "";
echo strtoupper($empLevel);
echo " | ";
echo "
| ";
echo "
";
}
echo "
| ".$errorMSG." |
";
$conn->close();
}
?>