Please enter description.";
if(trim($alert_for) != "" )
{
if (empty($alert_for_id) || !is_numeric($alert_for_id) )
$err_msg .= "Please enter a valid ID.";
}
else
$alert_for_id = '';
if(!is_array($roles) || sizeof($roles) <= 0)
$err_msg .= "Please select at least one role.";
$created_by = $_SESSION['S_USERID'];
if($err_msg == "")
{
// create the alert.
$insert_alert = 'insert into alert
(date_created, created_by, description, alert_for, alert_for_id, alert_type_id, link)
values
(now(), ?, ?, ?, ?, 1, ?)';
$data_params = [];
$data_params[] = $created_by;
$data_params[] = $description;
$data_params[] = $alert_for;
$data_params[] = $alert_for_id;
$data_params[] = $link;
$alert_id = $wrapperObj->executeQuery($insert_alert, $data_params, QueryWrapper::RETURN_INSERT_ID);
if ($alert_id === false) {
show_pdo_error($insert_alert, $wrapperObj->getLastStatement());
}
// now enter the roles.
$insert_alert_role = "";
$data_params = [];
foreach($roles as $role)
{
if(is_numeric($role) && $role > 0) {
$insert_alert_role .= ", (?, ?)";
$data_params[] = $alert_id;
$data_params[] = $role;
}
}
$insert_alert_role = trim($insert_alert_role, ",");
if(trim($insert_alert_role) != "")
{
$insert_alert_role = "INSERT INTO alert_roles
(alert_id, orchadmin_role_id)
values " . $insert_alert_role;
if ($wrapperObj->executeQuery($insert_alert_role, $data_params, QueryWrapper::RETURN_INSERT_ID) === false) {
show_pdo_error($insert_alert_role, $wrapperObj->getLastStatement());
}
}
$confirm_msg = "Alert successfully created.";
header("Location: {$_SERVER['PHP_SELF']}?alert_id=$alert_id&confirm_msg=$confirm_msg");
exit();
}
}
?>