top.window.location = '../../index.php'";
exit;
}
require_once __DIR__ . "/" . "../../includes/include_basics_only.php";
require_once __DIR__ . "/" . "../../includes/classes/ConnectPDO.php";
use includes\classes\ConnectPDO;
$conn = ConnectPDO::getInstance();
$post = $_POST;
// var_dump($post); exit();
$erro = false;
$exception = "";
$mensagem = "";
$data = [];
// $data['success'] = true;
// $data['message'] = "";
// $data['cod'] = (isset($post['cod']) ? intval($post['cod']) : "");
// $data['action'] = $post['action'];
// $data['field_id'] = "";
// $data['profile_name'] = (isset($post['profile_name']) ? noHtml($post['profile_name']) : "");
// $data['allow_user_open'] = (isset($post['allow_user_open']) ? ($post['allow_user_open'] == "yes" ? 1 : 0) : "");
// $data['area_to'] = (isset($post['area_to']) ? $post['area_to'] : "");
$data['field_client'] = (isset($post['field_client']) ? ($post['field_client'] == "yes" ? 1 : 0) : 0);
$data['field_area'] = (isset($post['field_area']) ? ($post['field_area'] == "yes" ? 1 : 0) : 0);
$data['field_issue'] = (isset($post['field_issue']) ? ($post['field_issue'] == "yes" ? 1 : 0) : 0);
$data['field_description'] = (isset($post['field_description']) ? ($post['field_description'] == "yes" ? 1 : 0) : 0);
$data['field_unit'] = (isset($post['field_unit']) ? ($post['field_unit'] == "yes" ? 1 : 0) : 0);
$data['field_tag_number'] = (isset($post['field_tag_number']) ? ($post['field_tag_number'] == "yes" ? 1 : 0) : 0);
$data['field_tag_check'] = (isset($post['field_tag_check']) ? ($post['field_tag_check'] == "yes" ? 1 : 0) : 0);
$data['field_tag_tickets'] = (isset($post['field_tag_tickets']) ? ($post['field_tag_tickets'] == "yes" ? 1 : 0) : 0);
$data['field_contact'] = (isset($post['field_contact']) ? ($post['field_contact'] == "yes" ? 1 : 0) : 0);
$data['field_contact_email'] = (isset($post['field_contact_email']) ? ($post['field_contact_email'] == "yes" ? 1 : 0) : 0);
$data['field_phone'] = (isset($post['field_phone']) ? ($post['field_phone'] == "yes" ? 1 : 0) : 0);
$data['field_department'] = (isset($post['field_department']) ? ($post['field_department'] == "yes" ? 1 : 0) : 0);
$data['field_load_department'] = (isset($post['field_load_department']) ? ($post['field_load_department'] == "yes" ? 1 : 0) : 0);
$data['field_search_dep_tags'] = (isset($post['field_search_dep_tags']) ? ($post['field_search_dep_tags'] == "yes" ? 1 : 0) : 0);
$data['field_operator'] = (isset($post['field_operator']) ? ($post['field_operator'] == "yes" ? 1 : 0) : 0);
$data['field_date'] = (isset($post['field_date']) ? ($post['field_date'] == "yes" ? 1 : 0) : 0);
$data['field_schedule'] = (isset($post['field_schedule']) ? ($post['field_schedule'] == "yes" ? 1 : 0) : 0);
$data['field_forward'] = (isset($post['field_forward']) ? ($post['field_forward'] == "yes" ? 1 : 0) : 0);
$data['field_status'] = (isset($post['field_status']) ? ($post['field_status'] == "yes" ? 1 : 0) : 0);
$data['field_replicate'] = (isset($post['field_replicate']) ? ($post['field_replicate'] == "yes" ? 1 : 0) : 0);
$data['field_attach_file'] = (isset($post['field_attach_file']) ? ($post['field_attach_file'] == "yes" ? 1 : 0) : 0);
$data['field_priority'] = (isset($post['field_priority']) ? ($post['field_priority'] == "yes" ? 1 : 0) : 0);
$data['field_send_mail'] = (isset($post['field_send_mail']) ? ($post['field_send_mail'] == "yes" ? 1 : 0) : 0);
$data['field_channel'] = (isset($post['field_channel']) ? ($post['field_channel'] == "yes" ? 1 : 0) : 0);
/* Checar se pelo menos um campo da listagem padrão foi selecionado */
$minDefaultFields = false;
foreach ($data as $key => $val) {
if ($val == 1) {
$minDefaultFields = true;
}
}
$data['success'] = true;
$data['message'] = "";
$data['cod'] = (isset($post['cod']) ? intval($post['cod']) : "");
$data['action'] = $post['action'];
$data['field_id'] = "";
$data['profile_name'] = (isset($post['profile_name']) ? noHtml($post['profile_name']) : "");
$data['allow_user_open'] = (isset($post['allow_user_open']) ? ($post['allow_user_open'] == "yes" ? 1 : 0) : "");
$data['is_default'] = (isset($post['is_default']) ? ($post['is_default'] == "yes" ? 1 : "") : "");
$data['area_to'] = (isset($post['area_to']) ? $post['area_to'] : "");
$data['opening_message'] = (isset($post['opening_message']) ? noHtml($post['opening_message']) : "");
$data['field_custom_ids'] = "";
$data['field_only_edition_ids'] = "";
$data['field_user_hidden_ids'] = "";
$data['field_client_required'] = (isset($post['field_client_required']) ? ($post['field_client_required'] == "on" ? 1 : 0) : 0);
$data['field_area_required'] = (isset($post['field_area_required']) ? ($post['field_area_required'] == "on" ? 1 : 0) : 0);
$data['field_issue_required'] = (isset($post['field_issue_required']) ? ($post['field_issue_required'] == "on" ? 1 : 0) : 0);
$data['field_description_required'] = (isset($post['field_description_required']) ? ($post['field_description_required'] == "on" ? 1 : 0) : 0);
$data['field_unit_required'] = (isset($post['field_unit_required']) ? ($post['field_unit_required'] == "on" ? 1 : 0) : 0);
$data['field_tag_number_required'] = (isset($post['field_tag_number_required']) ? ($post['field_tag_number_required'] == "on" ? 1 : 0) : 0);
$data['field_contact_required'] = (isset($post['field_contact_required']) ? ($post['field_contact_required'] == "on" ? 1 : 0) : 0);
$data['field_contact_email_required'] = (isset($post['field_contact_email_required']) ? ($post['field_contact_email_required'] == "on" ? 1 : 0) : 0);
$data['field_phone_required'] = (isset($post['field_phone_required']) ? ($post['field_phone_required'] == "on" ? 1 : 0) : 0);
$data['field_department_required'] = (isset($post['field_department_required']) ? ($post['field_department_required'] == "on" ? 1 : 0) : 0);
$data['field_forward_required'] = (isset($post['field_forward_required']) ? ($post['field_forward_required'] == "on" ? 1 : 0) : 0);
$data['field_attach_file_required'] = (isset($post['field_attach_file_required']) ? ($post['field_attach_file_required'] == "on" ? 1 : 0) : 0);
/* Para inserções sobre a obrigatoriedade dos campos */
$fields_required = [
'conf_scr_client' => $data['field_client_required'],
'conf_scr_area' => $data['field_area_required'],
'conf_scr_prob' => $data['field_issue_required'],
'conf_scr_desc' => $data['field_description_required'],
'conf_scr_unit' => $data['field_unit_required'],
'conf_scr_tag' => $data['field_tag_number_required'],
'conf_scr_contact' => $data['field_contact_required'],
'conf_scr_contact_email' => $data['field_contact_email_required'],
'conf_scr_fone' => $data['field_phone_required'],
'conf_scr_local' => $data['field_department_required'],
'conf_scr_foward' => $data['field_forward_required'],
'conf_scr_upload' => $data['field_attach_file_required']
];
/* Campos personalizados - apenas ativos*/
$dataCustom = [];
$sql = "SELECT * FROM custom_fields WHERE field_table_to = 'ocorrencias' AND field_active = 1";
try {
$res = $conn->query($sql);
if ($res->rowCount()) {
foreach ($res->fetchAll() as $cfield) {
$dataCustom[] = $cfield;
}
}
}
catch (Exception $e) {
$exception .= "
" . $e->getMessage();
}
/* Composição dos IDs dos campos personalizados */
$fields_ids = [];
$fields_only_edition_ids = [];
$fields_user_hidden_ids = [];
if (count($dataCustom)) {
foreach ($dataCustom as $cfield) {
if (isset($post[$cfield['field_name']]) && $post[$cfield['field_name']] == "yes") {
$fields_ids[] = $cfield['id'];
if (isset($post['only_edition_' . $cfield['field_name']]) && $post['only_edition_' . $cfield['field_name']] == "on") {
$fields_only_edition_ids[] = $cfield['id'];
if (isset($post['hidden_' . $cfield['field_name']]) && $post['hidden_' . $cfield['field_name']] == "on") {
$fields_user_hidden_ids[] = $cfield['id'];
}
}
}
}
}
if (count($fields_ids)) {
$data['field_custom_ids'] = implode(',', $fields_ids);
$data['field_only_edition_ids'] = implode(',', $fields_only_edition_ids);
$data['field_user_hidden_ids'] = implode(',', $fields_user_hidden_ids);
}
/* Checar se pelo menos um campo personalizado foi selecionado */
$minCustomFields = false;
if (!empty($data['field_custom_ids'])) {
$minCustomFields = true;
}
$screenNotification = "";
/* Validações */
if ($data['action'] == "new" || $data['action'] == "edit") {
if (empty($data['profile_name']) || empty($data['opening_message'])) {
$data['success'] = false;
$data['field_id'] = (empty($data['profile_name']) ? 'profile_name' : 'opening_message');
$data['message'] = message('warning', 'Ooops!', TRANS('MSG_EMPTY_DATA'),'');
echo json_encode($data);
return false;
}
if (!$minDefaultFields && !$minCustomFields) {
$data['success'] = false;
$data['field_id'] = '';
$data['message'] = message('warning', 'Ooops!', TRANS('AT_LEAST_FIELD'),'');
echo json_encode($data);
return false;
}
}
if ($data['action'] == 'edit') {
$sql = "SELECT conf_cod FROM configusercall WHERE conf_name = '" . $data['profile_name'] . "' AND
conf_cod <> '" . $data['cod'] . "' ";
$res = $conn->query($sql);
if ($res->rowCount()) {
$data['success'] = false;
$data['field_id'] = "profile_name";
$data['message'] = message('warning', '', TRANS('MSG_RECORD_EXISTS'), '');
echo json_encode($data);
return false;
}
if (!csrf_verify($post)) {
$data['success'] = false;
$data['message'] = message('warning', 'Ooops!', TRANS('FORM_ALREADY_SENT'),'');
echo json_encode($data);
return false;
}
$sql = "SELECT conf_cod FROM configusercall WHERE conf_is_default = 1 AND conf_cod <> '" . $data['cod'] . "' ";
$res = $conn->query($sql);
if (!$res->rowCount()) {
$data['is_default'] = 1;
}
if ($data['is_default'] == 1) {
$sql = "UPDATE configusercall SET conf_is_default = NULL ";
$conn->exec($sql);
}
$sql = "UPDATE configusercall SET
conf_name= '" . $data['profile_name'] . "',
conf_user_opencall= " . $data['allow_user_open'] . ",
conf_is_default = " . dbField($data['is_default']) . ",
conf_opentoarea = " . $data['area_to'] . ",
conf_scr_client = " . $data['field_client'] . ",
conf_scr_area = " . $data['field_area'] . ", conf_scr_prob = " . $data['field_issue'] . ",
conf_scr_desc = " . $data['field_description'] . ", conf_scr_unit = " . $data['field_unit'] . ",
conf_scr_tag = " . $data['field_tag_number'] . ", conf_scr_chktag = " . $data['field_tag_check'] . ",
conf_scr_chkhist = " . $data['field_tag_tickets'] . ", conf_scr_contact = " . $data['field_contact'] . ",
conf_scr_contact_email = " . $data['field_contact_email'] . ",
conf_scr_fone = " . $data['field_phone'] . ", conf_scr_local = " . $data['field_department'] . ",
conf_scr_btloadlocal = " . $data['field_load_department'] . ", conf_scr_searchbylocal = " . $data['field_search_dep_tags'] . " ,
conf_scr_operator = " . $data['field_operator'] . ", conf_scr_date = " . $data['field_date'] . ",
conf_scr_schedule = " . $data['field_schedule'] . ",
conf_scr_foward = " . $data['field_forward'] . ",
conf_scr_status = " . $data['field_status'] . ", conf_scr_replicate = " . $data['field_replicate'] . " ,
conf_scr_upload = " . $data['field_attach_file'] . " ,
conf_scr_mail = " . $data['field_send_mail'] . ", conf_scr_msg = '" . $data['opening_message'] . "' ,
conf_scr_prior = " . $data['field_priority'] . ",
conf_scr_channel = " . $data['field_channel'] . ",
conf_scr_custom_ids = " . dbField($data['field_custom_ids'],'text') . ",
cfields_only_edition = " . dbField($data['field_only_edition_ids'],'text') . ",
cfields_user_hidden = " . dbField($data['field_user_hidden_ids'],'text') . "
WHERE conf_cod=" . $data['cod'] . " ";
try {
$conn->exec($sql);
$data['success'] = true;
$data['message'] = TRANS('MSG_SUCCESS_EDIT');
$data['profile_cod'] = $data['cod'];
/* Obrigatoriedade dos campos */
$sql = "DELETE FROM screen_field_required WHERE profile_id = '" . $data['profile_cod'] . "' ";
try {
$conn->exec($sql);
/* Foreach para inserir a obrigatoriedade dos campos da tela de abertura */
foreach ($fields_required as $field_name => $required) {
$sql = "INSERT INTO screen_field_required
(
profile_id,
field_name,
field_required
)
VALUES
(
'" . $data['profile_cod'] . "',
'" . $field_name . "',
'" . $required . "'
)
";
try {
$conn->exec($sql);
}
catch (Exception $e) {
$exception .= "
" . $e->getMessage();
}
}
}
catch (Exception $e) {
$exception .= "
" . $e->getMessage();
}
$_SESSION['flash'] = message('success', '', $data['message'], '');
echo json_encode($data);
return false;
} catch (Exception $e) {
$data['success'] = false;
$data['message'] = TRANS('MSG_ERR_DATA_UPDATE');
$_SESSION['flash'] = message('danger', '', $data['message'], '');
echo json_encode($data);
return false;
}
} elseif ($data['action'] == 'new') {
$sql = "SELECT conf_cod FROM configusercall WHERE conf_name = '" . $data['profile_name'] . "' ";
$res = $conn->query($sql);
if ($res->rowCount()) {
$data['success'] = false;
$data['field_id'] = "profile_name";
$data['message'] = message('warning', '', TRANS('MSG_RECORD_EXISTS'), '');
echo json_encode($data);
return false;
}
if (!csrf_verify($post)) {
$data['success'] = false;
$data['message'] = message('warning', 'Ooops!', TRANS('FORM_ALREADY_SENT'),'');
echo json_encode($data);
return false;
}
$sql = "SELECT conf_cod FROM configusercall WHERE conf_is_default = 1 ";
$res = $conn->query($sql);
if (!$res->rowCount()) {
$data['is_default'] = 1;
}
if ($data['is_default'] == 1) {
$sql = "UPDATE configusercall SET conf_is_default = NULL ";
$conn->exec($sql);
}
$sql = "INSERT INTO configusercall
(
conf_name, conf_user_opencall, conf_is_default, conf_opentoarea, conf_scr_client, conf_scr_area, conf_scr_prob, conf_scr_desc,
conf_scr_unit, conf_scr_tag, conf_scr_chktag, conf_scr_chkhist, conf_scr_contact, conf_scr_contact_email,
conf_scr_fone,
conf_scr_local, conf_scr_btloadlocal, conf_scr_searchbylocal, conf_scr_operator, conf_scr_date,
conf_scr_schedule, conf_scr_foward, conf_scr_status, conf_scr_replicate, conf_scr_upload,
conf_scr_mail, conf_scr_msg, conf_scr_prior, conf_scr_channel, conf_scr_custom_ids, cfields_only_edition,
cfields_user_hidden
)
VALUES
(
'" . $data['profile_name'] . "', " . $data['allow_user_open'] . ", " . dbField($data['is_default']) . ", " . $data['area_to'] . ", " . $data['field_client'] . ", " . $data['field_area'] . ",
" . $data['field_issue'] . ", " . $data['field_description'] . ", " . $data['field_unit'] . ", " . $data['field_tag_number'] . ",
" . $data['field_tag_check'] . ", " . $data['field_tag_tickets'] . ", " . $data['field_contact'] . ",
" . $data['field_contact_email'] . ", " . $data['field_phone'] . ",
" . $data['field_department'] . ", " . $data['field_load_department'] . ", " . $data['field_search_dep_tags'] . " , " . $data['field_operator'] . ",
" . $data['field_date'] . ", " . $data['field_schedule'] . ", " . $data['field_forward'] . ", " . $data['field_status'] . ",
" . $data['field_replicate'] . " ," . $data['field_attach_file'] . " , " . $data['field_send_mail'] . ", '" . $data['opening_message'] . "',
" . $data['field_priority'] . ", " . $data['field_channel'] . ", " . dbField($data['field_custom_ids'],'text') . ",
" . dbField($data['field_only_edition_ids'],'text') . ",
" . dbField($data['field_user_hidden_ids'],'text') . "
)";
try {
$conn->exec($sql);
$data['success'] = true;
$data['message'] = TRANS('MSG_SUCCESS_INSERT');
$data['profile_cod'] = $conn->lastInsertId();
/* Foreach para inserir a obrigatoriedade dos campos da tela de abertura */
foreach ($fields_required as $field_name => $required) {
$sql = "INSERT INTO screen_field_required
(
profile_id,
field_name,
field_required
)
VALUES
(
'" . $data['profile_cod'] . "',
'" . $field_name . "',
'" . $required . "'
)
";
try {
$conn->exec($sql);
}
catch (Exception $e) {
$exception .= "
" . $e->getMessage();
}
}
$_SESSION['flash'] = message('success', '', $data['message'] . $exception, '');
echo json_encode($data);
return false;
} catch (Exception $e) {
$exception .= "
" . $e->getMessage();
$data['success'] = false;
$data['message'] = TRANS('MSG_ERR_SAVE_RECORD');
$_SESSION['flash'] = message('danger', '', $data['message'] . $exception, '');
echo json_encode($data);
return false;
}
} elseif ($data['action'] == 'delete') {
$sql = "SELECT conf_cod FROM configusercall WHERE conf_cod = " . $data['cod'] . " AND conf_is_default = 1 ";
$res = $conn->query($sql);
if ($res->rowCount()) {
$data['success'] = false;
$data['message'] = TRANS('CANT_REMOVE_DEFAULT_PROFILE');
$_SESSION['flash'] = message('danger', '', $data['message'], '');
echo json_encode($data);
return false;
}
$sql = "SELECT * FROM sistemas where sis_screen='" . $data['cod'] . "'";
$res = $conn->query($sql);
$achou = $res->rowCount();
if ($achou) {
$data['success'] = false;
$data['message'] = TRANS('MSG_CANT_DEL');
$_SESSION['flash'] = message('danger', '', $data['message'], '');
echo json_encode($data);
return false;
}
$sql = "SELECT * FROM problemas where prob_profile_form = '" . $data['cod'] . "'";
$res = $conn->query($sql);
$achou = $res->rowCount();
if ($achou) {
$data['success'] = false;
$data['message'] = TRANS('MSG_CANT_DEL');
$_SESSION['flash'] = message('danger', '', $data['message'], '');
echo json_encode($data);
return false;
}
$sql = "DELETE FROM configusercall WHERE conf_cod='".$data['cod']."'";
try {
$conn->exec($sql);
$data['success'] = true;
$data['message'] = TRANS('OK_DEL');
$sql = "DELETE FROM screen_field_required WHERE profile_id = '" . $data['cod'] . "' ";
try {
$conn->exec($sql);
}
catch (Exception $e) {
$exception .= "
" . $e->getMessage();
}
$_SESSION['flash'] = message('success', '', $data['message'] . $exception, '');
echo json_encode($data);
return false;
} catch (Exception $e) {
$data['success'] = false;
$data['message'] = TRANS('MSG_ERR_DATA_REMOVE');
$_SESSION['flash'] = message('danger', '', $data['message'], '');
echo json_encode($data);
return false;
}
}
echo json_encode($data);