<?php  
include_once("../../cfg/db.php");

if(!isset($_SESSION['user'])){
    exit();
}


$employee_ids = $_POST['employee_ids']; 
$report_type_id = $_POST['report_type_id'];    
$db -> sql_query("DELETE FROM `report_approver` WHERE `report_type_id` = '$report_type_id' "); 

foreach ($employee_ids as $data){
    if(isNotEmpty($data)){ 
             $db -> sql_query("INSERT INTO `report_approver`(`report_type_id`, `employee_id`) VALUES ('$report_type_id','$data')");
    }
   
}
        
function isNotEmpty($data){
    return preg_match('/\S/', $data);
}
?>