$insqry = "insert into {$skills_table} set skill_name='{$v[$skname]}',DATE_OF_ADDITION=now(),added_by='{$emp_id}',over_used='{$v[$ovused]}',career_killer='{$v[$crklr]}',compensator='{$v[$cmptr]}',";
if ($v[$sktp] == "t") {
$subqry = "skill_description='{$v[$skdes]}',unskilled_desc=NULL,skill_type='{$v[$sktp]}'";
} else {
$subqry = "skill_description=NULL,unskilled_desc='{$v[$skdes]}',skill_type='{$v[$sktp]}'";
}
$insqry = $insqry . $subqry;
// echo $insqry;
$db_object->insert($insqry);
$insqry = "";
$subqry = "";
}
}
if (count($skillids) > 0) {
$skills_id = @implode(",", $skillids);
$skill_ids = "(" . $skills_id . ")";
//$delqry="delete from $unapskill where emp_id='$emp_id'";
$delqry = "delete from {$unapskill} where skill_id in {$skill_ids}";
$db_object->insert($delqry);
}
echo $alert_msg["cApproved"];
//print_r($skill_set);
}
}
$aprobj = new Approval();
if ($fApproval) {
$aprobj->approve($common, $db_object, $_POST, $emp_id, $gbl_skill_type, $alert_msg);
} else {
$aprobj->display($common, $db_object, $emp_id);
}
include "footer.php";
