format("Y-m-d");
//if submit/ save to databasevar
if(isset($_POST['done'])){
$divID = mysql_escape_string($_POST['divID']);
$unitID = mysql_escape_string($_POST['unitID']);
$officerID = mysql_escape_string($_POST['officerID']);
$compID = mysql_escape_string($_POST['compID']);
$templateID = mysql_escape_string($_POST['templateID']);
$userID = mysql_escape_string($_POST['userID']);
$rank = mysql_escape_string($_POST['rank']);
//=====================================================================================================================================================
//=====================================================================================================================================================
$chkIfExist = mysql_result(mysql_query("SELECT COUNT(id) FROM `cl_approving_officers` WHERE `cl_template_id`='$templateID' AND `cl_div_id`= '$divID' AND `cl_unit_id`='$unitID' AND `cl_comp_id`='$compID'"),0);
if($chkIfExist > 0){
mysql_query("UPDATE cl_approving_officers SET `cl_emp_id_b`='$officerID', `cl_sla_b`='3' WHERE `cl_template_id`='$templateID' AND `cl_div_id`= '$divID' AND `cl_unit_id`='$unitID' AND `cl_comp_id`='$compID'");
//echo "SELECTED RECORD HAS BEEN UPDATED
";
}else{
//echo '';
mysql_query("INSERT INTO cl_approving_officers (cl_div_id, cl_template_id, cl_unit_id, cl_comp_id, cl_emp_id_b, cl_sla_b,cl_level)
VALUES('{$divID}','{$templateID}','{$unitID}','{$compID}','{$officerID}','3','{$rank}')");
//echo "NEW RECORD HAS BEEN ADDED.
";
}
//echo '';
exit();
}
?>