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;
$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['field_custom_ids'] = "";
$data['field_specs_ids'] = "";
$data['profile_name'] = (isset($post['profile_name']) ? noHtml($post['profile_name']) : "");
$data['applied_to'] = (isset($post['applied_to']) && !empty(array_filter($post['applied_to'], function($v) { return !empty($v); })) ? array_map('noHtml', $post['applied_to']) : []);
// $data['applied_to_ids'] = (!empty($data['applied_to']) ? implode(",", $data['applied_to']) : "");
$data['field_serial_number'] = (isset($post['field_serial_number']) ? ($post['field_serial_number'] == "yes" ? 1 : 0) : 0);
$data['field_part_number'] = (isset($post['field_part_number']) ? ($post['field_part_number'] == "yes" ? 1 : 0) : 0);
$data['field_situation'] = (isset($post['field_situation']) ? ($post['field_situation'] == "yes" ? 1 : 0) : 0);
$data['field_net_name'] = (isset($post['field_net_name']) ? ($post['field_net_name'] == "yes" ? 1 : 0) : 0);
$data['field_invoice_number'] = (isset($post['field_invoice_number']) ? ($post['field_invoice_number'] == "yes" ? 1 : 0) : 0);
$data['field_cost_center'] = (isset($post['field_cost_center']) ? ($post['field_cost_center'] == "yes" ? 1 : 0) : 0);
$data['field_price'] = (isset($post['field_price']) ? ($post['field_price'] == "yes" ? 1 : 0) : 0);
$data['field_buy_date'] = (isset($post['field_buy_date']) ? ($post['field_buy_date'] == "yes" ? 1 : 0) : 0);
$data['field_supplier'] = (isset($post['field_supplier']) ? ($post['field_supplier'] == "yes" ? 1 : 0) : 0);
$data['field_assistance_type'] = (isset($post['field_assistance_type']) ? ($post['field_assistance_type'] == "yes" ? 1 : 0) : 0);
$data['field_warranty_type'] = (isset($post['field_warranty_type']) ? ($post['field_warranty_type'] == "yes" ? 1 : 0) : 0);
$data['field_warranty_time'] = (isset($post['field_warranty_time']) ? ($post['field_warranty_time'] == "yes" ? 1 : 0) : 0);
$data['field_extra_info'] = (isset($post['field_extra_info']) ? ($post['field_extra_info'] == "yes" ? 1 : 0) : 0);
/* Sobre a obrigatoriedade */
$data['field_serial_number_required'] = (isset($post['field_serial_number_required']) ? ($post['field_serial_number_required'] == "on" ? 1 : 0) : 0);
$data['field_part_number_required'] = (isset($post['field_part_number_required']) ? ($post['field_part_number_required'] == "on" ? 1 : 0) : 0);
$data['field_situation_required'] = (isset($post['field_situation_required']) ? ($post['field_situation_required'] == "on" ? 1 : 0) : 0);
$data['field_net_name_required'] = (isset($post['field_net_name_required']) ? ($post['field_net_name_required'] == "on" ? 1 : 0) : 0);
$data['field_invoice_number_required'] = (isset($post['field_invoice_number_required']) ? ($post['field_invoice_number_required'] == "on" ? 1 : 0) : 0);
$data['field_cost_center_required'] = (isset($post['field_cost_center_required']) ? ($post['field_cost_center_required'] == "on" ? 1 : 0) : 0);
$data['field_price_required'] = (isset($post['field_price_required']) ? ($post['field_price_required'] == "on" ? 1 : 0) : 0);
$data['field_buy_date_required'] = (isset($post['field_buy_date_required']) ? ($post['field_buy_date_required'] == "on" ? 1 : 0) : 0);
$data['field_supplier_required'] = (isset($post['field_supplier_required']) ? ($post['field_supplier_required'] == "on" ? 1 : 0) : 0);
$data['field_assistance_type_required'] = (isset($post['field_assistance_type_required']) ? ($post['field_assistance_type_required'] == "on" ? 1 : 0) : 0);
$data['field_warranty_type_required'] = (isset($post['field_warranty_type_required']) ? ($post['field_warranty_type_required'] == "on" ? 1 : 0) : 0);
$data['field_warranty_time_required'] = (isset($post['field_warranty_time_required']) ? ($post['field_warranty_time_required'] == "on" ? 1 : 0) : 0);
$data['field_extra_info_required'] = (isset($post['field_extra_info_required']) ? ($post['field_extra_info_required'] == "on" ? 1 : 0) : 0);
/* Para inserções sobre a obrigatoriedade dos campos */
$fields_required = [
'asset_type' => 1,
'manufacturer' => 1,
'model' => 1,
'asset_unit' => 1,
'asset_tag' => 1,
'department' => 1,
'serial_number' => $data['field_serial_number_required'],
'part_number' => $data['field_part_number_required'],
'situation' => $data['field_situation_required'],
'net_name' => $data['field_net_name_required'],
'invoice_number' => $data['field_invoice_number_required'],
'cost_center' => $data['field_cost_center_required'],
'price' => $data['field_price_required'],
'buy_date' => $data['field_buy_date_required'],
'supplier' => $data['field_supplier_required'],
'assistance_type' => $data['field_assistance_type_required'],
'warranty_type' => $data['field_warranty_type_required'],
'warranty_time' => $data['field_warranty_time_required'],
'extra_info' => $data['field_extra_info_required']
];
/* Campos de especificação */
$dataSpecs = [];
$dataSpecs = getPossibleChildsFromManyAssetsTypes($conn, $data['applied_to']);
$specs_ids = [];
if (count($dataSpecs)) {
foreach ($dataSpecs as $spec) {
if (isset($post[str_slug($spec['tipo_nome'],"spec_")]) && $post[str_slug($spec['tipo_nome'],"spec_")] == "yes") {
$specs_ids[] = $spec['tipo_cod'];
}
}
}
/* Composição dos IDs dos campos de especificação */
if (count($specs_ids)) {
$data['field_specs_ids'] = implode(',', $specs_ids);
}
/* Campos personalizados - apenas ativos*/
$dataCustom = [];
$sql = "SELECT * FROM custom_fields WHERE field_table_to = 'equipamentos' 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 = [];
if (count($dataCustom)) {
foreach ($dataCustom as $cfield) {
if (isset($post[$cfield['field_name']]) && $post[$cfield['field_name']] == "yes") {
$fields_ids[] = $cfield['id'];
}
}
}
if (count($fields_ids)) {
$data['field_custom_ids'] = implode(',', $fields_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['applied_to'])) {
$data['success'] = false;
$data['field_id'] = (empty($data['profile_name']) ? 'profile_name' : 'applied_to');
$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;
// }
}
// var_dump($data); exit;
if ($data['action'] == 'edit') {
$sql = "SELECT id FROM assets_fields_profiles WHERE profile_name = '" . $data['profile_name'] . "' AND
id <> '" . $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 = "UPDATE assets_fields_profiles SET
profile_name = '" . $data['profile_name'] . "',
serial_number = '" . $data['field_serial_number'] . "',
part_number = '" . $data['field_part_number'] . "',
situation = '" . $data['field_situation'] . "',
net_name = '" . $data['field_net_name'] . "',
invoice_number = '" . $data['field_invoice_number'] . "',
cost_center = '" . $data['field_cost_center'] . "',
price = '" . $data['field_price'] . "',
buy_date = '" . $data['field_buy_date'] . "',
supplier = '" . $data['field_supplier'] . "',
assistance_type = '" . $data['field_assistance_type'] . "',
warranty_type = '" . $data['field_warranty_type'] . "',
warranty_time = '" . $data['field_warranty_time'] . "',
extra_info = '" . $data['field_extra_info'] . "',
field_specs_ids = " . dbField($data['field_specs_ids'],'text') . " ,
field_custom_ids = " . dbField($data['field_custom_ids'],'text') . "
WHERE id = " . $data['cod'] . " ";
try {
$conn->exec($sql);
$data['success'] = true;
$data['message'] = TRANS('MSG_SUCCESS_EDIT');
/* Primeiro removo da tabela de relacionamentos entre perfis e tipos de ativos */
$sql = "DELETE from profiles_x_assets_types WHERE profile_id = ' " . $data['cod'] . "' ";
try {
$conn->exec($sql);
/* Inserção na tabela de relacionamento entre perfis e tipos de ativos */
foreach ($data['applied_to'] as $apliedTo) {
$sql = "INSERT INTO profiles_x_assets_types
(
profile_id,
asset_type_id
)
VALUES
(
'" . $data['cod'] . "',
'" . $apliedTo . "'
)
";
try {
$conn->exec($sql);
}
catch (Exception $e) {
$exception .= "
" . $e->getMessage();
}
}
}
catch (Exception $e) {
$exception .= "
" . $e->getMessage();
}
/* Obrigatoriedade dos campos */
$sql = "DELETE FROM assets_fields_required WHERE profile_id = '" . $data['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 assets_fields_required
(
profile_id,
field_name,
field_required
)
VALUES
(
'" . $data['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 id FROM assets_fields_profiles WHERE profile_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 = "INSERT INTO assets_fields_profiles
(
profile_name, serial_number,
part_number, situation, net_name,
invoice_number, cost_center, price,
buy_date, supplier, assistance_type,
warranty_type, warranty_time, extra_info,
field_specs_ids, field_custom_ids
)
VALUES
(
'" . $data['profile_name'] . "', " . $data['field_serial_number'] . ",
" . $data['field_part_number'] . ", " . $data['field_situation'] . ", " . $data['field_net_name'] . ",
" . $data['field_invoice_number'] . ", " . $data['field_cost_center'] . ", " . $data['field_price'] . ",
" . $data['field_buy_date'] . ", " . $data['field_supplier'] . ", " . $data['field_assistance_type'] . ",
" . $data['field_warranty_type'] . ", " . $data['field_warranty_time'] . ", " . $data['field_extra_info'] . ",
" . dbField($data['field_specs_ids'],'text') . ", " . dbField($data['field_custom_ids'],'text') . "
)";
try {
$conn->exec($sql);
$data['success'] = true;
$data['message'] = TRANS('MSG_SUCCESS_INSERT');
$data['cod'] = $conn->lastInsertId();
/* Inserção na tabela de relacionamento entre perfis e tipos de ativos */
foreach ($data['applied_to'] as $apliedTo) {
$sql = "INSERT INTO profiles_x_assets_types
(
profile_id,
asset_type_id
)
VALUES
(
'" . $data['cod'] . "',
'" . $apliedTo . "'
)
";
try {
$conn->exec($sql);
}
catch (Exception $e) {
$exception .= "
" . $e->getMessage();
}
}
/* Foreach para inserir a obrigatoriedade dos campos da tela de abertura */
foreach ($fields_required as $field_name => $required) {
$sql = "INSERT INTO assets_fields_required
(
profile_id,
field_name,
field_required
)
VALUES
(
'" . $data['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 id FROM assets_categories WHERE cat_default_profile = '" . $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 assets_fields_profiles WHERE id = '".$data['cod']."'";
try {
$conn->exec($sql);
$data['success'] = true;
$data['message'] = TRANS('OK_DEL');
$sql = "DELETE FROM assets_fields_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);