1){
$errorMessage = "Transaction Failed:
You cannot have more than two (2) MAR in a month. ";
$fColor = "red";
}else{
$sql = "INSERT INTO mar_emp_header (
`id`,
`emp_id`,
`pcp_id`,
`mar_year`,
`mar_month`,
`mar_group`,
`mar_description`,
`date_created`,
`created_by`)
VALUES ('',
'$SelectedRecordID',
'$groupKRAid',
'$applyYear',
'$marMonths',
'$marSemester',
'$marName',
'$myTimeStamp',
'$userID')";
if ($conn->query($sql) === TRUE) {
//echo '';
$errorMessage = "Success: New record has been added";
$fColor = "#0573A7";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
}
$getKRAList = "SELECT * FROM `mar_emp_header` WHERE `deleted`=0 AND `pcp_id` ='$groupKRAid' ORDER BY `mar_month` ASC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getKRA = mysqli_query($conn,$getKRAList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
$fontColor="#02470A";
?>".$row['id']."";
echo "| ".$row['mar_year']." | ";
echo "".$row['mar_month']." | ";
echo "".$row['mar_group']." | ";
echo "".$row['mar_description']." | ";
echo "";?>
";
echo " | ";?>
";
echo " |
";
}
echo "
";
echo "| ".$errorMessage." | ";
echo "
";
}
$conn->close();
}
?>