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();
$auth = new AuthNew($_SESSION['s_logado'], $_SESSION['s_nivel'], 2, 2);
$post = $_POST;
$config = getConfig($conn);
// $rowLogado = getUserInfo($conn, $_SESSION['s_uid']);
/* Para manter a compatibilidade com versões antigas */
$table = "equipxpieces";
$sqlTest = "SELECT * FROM {$table}";
try {
$conn->query($sqlTest);
}
catch (Exception $e) {
$table = "equipXpieces";
}
$exception = "";
$screenNotification = "";
$data = [];
$data['success'] = true;
$data['message'] = "";
$data['cod'] = (isset($post['cod']) ? intval($post['cod']) : "");
$data['action'] = $post['action'];
$data['field_id'] = "";
$data['type'] = (isset($post['type']) ? noHtml($post['type']) : "");
$data['manufacturer'] = (isset($post['manufacturer']) ? noHtml($post['manufacturer']) : "");
$data['model_full'] = (isset($post['model_full']) ? noHtml($post['model_full']) : "");
$data['serial_number'] = (isset($post['serial_number']) ? noHtml($post['serial_number']) : "");
$data['department'] = (isset($post['department']) ? noHtml($post['department']) : "");
$data['old_department'] = (isset($post['old_department']) ? noHtml($post['old_department']) : "");
$data['old_unit'] = (isset($post['old_unit']) ? noHtml($post['old_unit']) : "");
$data['old_tag'] = (isset($post['old_tag']) ? noHtml($post['old_tag']) : "");
$data['condition'] = (isset($post['condition']) ? noHtml($post['condition']) : "");
$data['net_name'] = (isset($post['net_name']) && !empty($post['net_name']) ? noHtml($post['net_name']) : "");
$data['net_name'] = (!empty($post['net_name']) ? noSpace($post['net_name']) : $data['net_name']);
$data['motherboard'] = (isset($post['motherboard']) ? noHtml($post['motherboard']) : "");
$data['processor'] = (isset($post['processor']) ? noHtml($post['processor']) : "");
$data['memory'] = (isset($post['memory']) ? noHtml($post['memory']) : "");
$data['video'] = (isset($post['video']) ? noHtml($post['video']) : "");
$data['sound'] = (isset($post['sound']) ? noHtml($post['sound']) : "");
$data['network'] = (isset($post['network']) ? noHtml($post['network']) : "");
$data['modem'] = (isset($post['modem']) ? noHtml($post['modem']) : "");
$data['hdd'] = (isset($post['hdd']) ? noHtml($post['hdd']) : "");
$data['recorder'] = (isset($post['recorder']) ? noHtml($post['recorder']) : "");
$data['cdrom'] = (isset($post['cdrom']) ? noHtml($post['cdrom']) : "");
$data['dvdrom'] = (isset($post['dvdrom']) ? noHtml($post['dvdrom']) : "");
$data['printer_type'] = (isset($post['printer_type']) ? noHtml($post['printer_type']) : "");
$data['monitor_size'] = (isset($post['monitor_size']) ? noHtml($post['monitor_size']) : "");
$data['scanner_resolution'] = (isset($post['scanner_resolution']) ? noHtml($post['scanner_resolution']) : "");
$data['asset_unit'] = (isset($post['asset_unit']) ? noHtml($post['asset_unit']) : "");
$data['asset_tag'] = (isset($post['asset_tag']) ? noHtml($post['asset_tag']) : "");
$data['invoice_number'] = (isset($post['invoice_number']) ? noHtml($post['invoice_number']) : "");
$data['cost_center'] = (isset($post['cost_center']) ? noHtml($post['cost_center']) : "");
$data['price'] = (isset($post['price']) && $post['price'] != "0,00" ? noHtml($post['price']) : "");
$data['price'] = (!empty($data['price']) ? priceDB($data['price']) : $data['price']);
$data['purchase_date'] = (isset($post['purchase_date']) ? noHtml($post['purchase_date']) : "");
$data['purchase_date'] = (!empty($data['purchase_date']) ? dateDB($data['purchase_date']) : "");
$data['supplier'] = (isset($post['supplier']) ? noHtml($post['supplier']) : "");
$data['assistance'] = (isset($post['assistance']) ? noHtml($post['assistance']) : "");
$data['warranty_type'] = (isset($post['warranty_type']) ? noHtml($post['warranty_type']) : "");
$data['time_of_warranty'] = (isset($post['time_of_warranty']) ? noHtml($post['time_of_warranty']) : "");
$data['additional_info'] = (isset($post['additional_info']) ? noHtml($post['additional_info']) : "");
$data['total_files_to_deal'] = (isset($post['cont']) ? noHtml($post['cont']) : 0);
/* Checagem de preenchimento dos campos obrigatórios*/
if ($data['action'] == "new" || $data['action'] == "edit") {
if ($data['type'] == "") {
$data['success'] = false;
$data['field_id'] = "type";
} elseif ($data['manufacturer'] == "") {
$data['success'] = false;
$data['field_id'] = "manufacturer";
} elseif ($data['model_full'] == "") {
$data['success'] = false;
$data['field_id'] = "model_full";
} elseif ($data['department'] == "") {
$data['success'] = false;
$data['field_id'] = "department";
} elseif ($data['condition'] == "") {
$data['success'] = false;
$data['field_id'] = "condition";
} elseif ($data['asset_unit'] == "") {
$data['success'] = false;
$data['field_id'] = "asset_unit";
} elseif ($data['asset_tag'] == "") {
$data['success'] = false;
$data['field_id'] = "asset_tag";
}
if ($data['success'] == false) {
$data['message'] = message('warning', '', TRANS('MSG_EMPTY_DATA'), '');
echo json_encode($data);
return false;
}
if (strpos($data['asset_tag'], " ")) {
$data['success'] = false;
$data['field_id'] = "asset_tag";
$data['message'] = message('warning', '', TRANS('MSG_ERROR_WRONG_FORMATTED'), '');
echo json_encode($data);
return false;
}
/* Checagem do número de série */
if (!empty($data['serial_number'])) {
$terms = ($data['action'] == "edit" ? " AND comp_cod <> '" . $data['cod'] . "' " : "");
$sql = "SELECT comp_cod FROM equipamentos WHERE comp_marca = '" . $data['model_full'] . "'
AND comp_sn = '" . $data['serial_number'] . "' {$terms} ";
$res = $conn->query($sql);
if ($res->rowCount()) {
$data['success'] = false;
$data['field_id'] = "serial_number";
$data['message'] = message('warning', '', TRANS('MSG_SERIAL_NUMBER_CAD_IN_SYSTEM'), ''); /* . "
" . $sql */
echo json_encode($data);
return false;
}
}
if (!empty($data['printer_type']) && $data['type'] != 3) {
$data['success'] = false;
$data['field_id'] = "printer_type";
$data['message'] = message('warning', '', TRANS('INCONSISTENT_EQUIPMENT_TYPE'), '');
echo json_encode($data);
return false;
}
if (!empty($data['monitor_size']) && $data['type'] != 5) {
$data['success'] = false;
$data['field_id'] = "monitor_size";
$data['message'] = message('warning', '', TRANS('INCONSISTENT_EQUIPMENT_TYPE'), '');
echo json_encode($data);
return false;
}
if (!empty($data['scanner_resolution']) && $data['type'] != 4) {
$data['success'] = false;
$data['field_id'] = "scanner_resolution";
$data['message'] = message('warning', '', TRANS('INCONSISTENT_EQUIPMENT_TYPE'), '');
echo json_encode($data);
return false;
}
/* Checagem da etiqueta e unidade para equipamentos existentes*/
$terms = ($data['action'] == "edit" ? " AND comp_cod <> '" . $data['cod'] . "' " : "");
$sql = "SELECT comp_cod FROM equipamentos WHERE
comp_inv = '" . $data['asset_tag'] . "' AND
comp_inst = '" . $data['asset_unit'] . "'
{$terms}
";
$res = $conn->query($sql);
if ($res->rowCount()) {
$data['success'] = false;
$data['field_id'] = "asset_tag";
$data['message'] = message('warning', '', TRANS('MSG_RECORD_EXISTS_WITH_THIS_TAG'), '');
echo json_encode($data);
return false;
}
/* Checagem da etiqueta e unidade para componentes avulsos existentes*/
$sql = "SELECT estoq_cod FROM estoque WHERE estoq_tag_inv = '".$data['asset_tag']."' AND
estoq_tag_inst = '".$data['asset_unit']."' ";
$res = $conn->query($sql);
if ($res->rowCount()) {
$data['success'] = false;
$data['field_id'] = "asset_tag";
$data['message'] = message('warning', '', TRANS('MSG_RECORD_EXISTS_WITH_THIS_TAG'), '');
echo json_encode($data);
return false;
}
if ($data['price'] != "" && !filter_var($data['price'], FILTER_VALIDATE_FLOAT)) {
$data['success'] = false;
$data['field_id'] = "price";
$data['message'] = message('warning', '', TRANS('MSG_ERROR_WRONG_FORMATTED'), '');
echo json_encode($data);
return false;
}
if ($data['success'] == false) {
$data['message'] = message('warning', '', TRANS('MSG_EMPTY_DATA'), '');
echo json_encode($data);
return false;
}
}
/* Checagens para upload de arquivos - vale para todos os actions */
$totalFiles = ($_FILES ? count($_FILES['anexo']['name']) : 0);
$filesClean = [];
if ($totalFiles > $config['conf_qtd_max_anexos']) {
$data['success'] = false;
$data['message'] = message('warning', 'Ooops!', 'Too many files','');
echo json_encode($data);
return false;
}
$uploadMessage = "";
$emptyFiles = 0;
/* Testa os arquivos enviados para montar os índices do recordFile*/
if ($totalFiles) {
foreach ($_FILES as $anexo) {
$file = array();
for ($i = 0; $i < $totalFiles; $i++) {
/* fazer o que precisar com cada arquivo */
/* acessa: $anexo['name'][$i] $anexo['type'][$i] $anexo['tmp_name'][$i] $anexo['size'][$i]*/
if (!empty($anexo['name'][$i])) {
$file['name'] = $anexo['name'][$i];
$file['type'] = $anexo['type'][$i];
$file['tmp_name'] = $anexo['tmp_name'][$i];
$file['error'] = $anexo['error'][$i];
$file['size'] = $anexo['size'][$i];
$upld = upload('anexo', $config, $config['conf_upld_file_types'], $file);
if ($upld == "OK") {
$recordFile[$i] = true;
$filesClean[] = $file;
} else {
$recordFile[$i] = false;
$uploadMessage .= $upld;
}
} else {
$emptyFiles++;
}
}
}
$totalFiles -= $emptyFiles;
if (strlen((string)$uploadMessage) > 0) {
$data['success'] = false;
$data['field_id'] = "idInputFile";
$data['message'] = message('warning', 'Ooops!', $uploadMessage, '');
echo json_encode($data);
return false;
}
}
/* Processamento */
if ($data['action'] == "new") {
/* Verificação de CSRF */
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 equipamentos
(
comp_inv, comp_sn, comp_marca, comp_mb, comp_proc, comp_memo, comp_video, comp_som,
comp_rede, comp_modelohd, comp_modem, comp_cdrom, comp_dvd, comp_grav, comp_nome,
comp_local, comp_fornecedor, comp_nf, comp_coment, comp_data, comp_valor, comp_data_compra,
comp_inst, comp_ccusto, comp_tipo_equip, comp_tipo_imp, comp_resolucao, comp_polegada,
comp_fab, comp_situac, comp_tipo_garant, comp_garant_meses, comp_assist
)
VALUES
(
'" . $data['asset_tag'] . "',
" . dbField($data['serial_number'], 'text') . ",
'" . $data['model_full'] . "',
" . dbField($data['motherboard'], 'int') . ",
" . dbField($data['processor'], 'int') . ",
" . dbField($data['memory'], 'int') . ",
" . dbField($data['video'], 'int') . ",
" . dbField($data['sound'], 'int') . ",
" . dbField($data['network'], 'int') . ",
" . dbField($data['hdd'], 'int') . ",
" . dbField($data['modem'], 'int') . ",
" . dbField($data['cdrom'], 'int') . ",
" . dbField($data['dvdrom'], 'int') . ",
" . dbField($data['recorder'], 'int') . ",
" . dbField($data['net_name'], 'text') . ",
'" . $data['department'] . "',
" . dbField($data['supplier'], 'int') . ",
" . dbField($data['invoice_number'], 'text') . ",
" . dbField($data['additional_info'], 'text') . ",
'" . date('Y-m-d H:i:s') . "',
" . dbField($data['price'], 'float') . ",
" . dbField($data['purchase_date'], 'date') . ",
" . dbField($data['asset_unit'], 'text') . ",
" . dbField($data['cost_center'], 'int') . ",
'" . $data['type'] . "',
" . dbField($data['printer_type'], 'int') . ",
" . dbField($data['scanner_resolution'], 'int') . ",
" . dbField($data['monitor_size'], 'int') . ",
'" . $data['manufacturer'] . "',
" . dbField($data['condition'], 'int') . ",
" . dbField($data['warranty_type'], 'int') . ",
" . dbField($data['time_of_warranty'], 'int') . ",
" . dbField($data['assistance'], 'int') . "
)";
try {
$conn->exec($sql);
$data['success'] = true;
// $data['equipment_id'] = $conn->lastInsertId();
/* Historico de localizacao */
$sql = "INSERT INTO historico
(
hist_inv, hist_inst, hist_local
)
VALUES
('" . $data['asset_tag'] . "', '" . $data['asset_unit'] . "', '" . $data['department'] . "')";
try {
$conn->exec($sql);
}
catch (Exception $e) {
$exception .= "
" . $e->getMessage();
}
$data['message'] = TRANS('MSG_SUCCESS_INSERT') . $exception;
} catch (Exception $e) {
$exception .= $e->getMessage();
$data['success'] = false;
$data['message'] = TRANS('MSG_ERR_SAVE_RECORD') . $exception;
$_SESSION['flash'] = message('danger', '', $data['message'], '');
echo json_encode($data);
return false;
}
} elseif ($data['action'] == 'edit') {
if (!csrf_verify($post)) {
$data['success'] = false;
$data['message'] = message('warning', 'Ooops!', TRANS('FORM_ALREADY_SENT'),'');
echo json_encode($data);
return false;
}
/* Para comparar os registros e checar alterações de componentes a serem gravadas no histórico */
$sql = "SELECT * FROM equipamentos WHERE comp_cod = '". $data['cod'] ."' ";
$res = $conn->query($sql);
$oldData = $res->fetch();
// var_dump([
// 'data' => $data,
// 'oldData' => $oldData,
// ]); exit;
$sql = "UPDATE equipamentos SET
comp_inv = '" . $data['asset_tag'] . "',
comp_inst = '" . $data['asset_unit'] . "',
comp_marca = '" . $data['model_full'] . "',
comp_local = '" . $data['department'] . "',
comp_tipo_equip = '" . $data['type'] . "',
comp_fab = '" . $data['manufacturer'] . "',
comp_sn = " . dbField($data['serial_number'], 'text') . ",
comp_nome = " . dbField($data['net_name'], 'text') . ",
comp_mb = " . dbField($data['motherboard'], 'int') . ",
comp_proc = " . dbField($data['processor'], 'int') . ",
comp_memo = " . dbField($data['memory'], 'int') . ",
comp_video = " . dbField($data['video'], 'int') . ",
comp_som = " . dbField($data['sound'], 'int') . ",
comp_rede = " . dbField($data['network'], 'int') . ",
comp_modelohd = " . dbField($data['hdd'], 'int') . ",
comp_modem = " . dbField($data['modem'], 'int') . ",
comp_cdrom = " . dbField($data['cdrom'], 'int') . ",
comp_dvd = " . dbField($data['dvdrom'], 'int') . ",
comp_grav = " . dbField($data['recorder'], 'int') . ",
comp_tipo_imp = " . dbField($data['printer_type'], 'int') . ",
comp_resolucao = " . dbField($data['scanner_resolution'], 'int') . ",
comp_polegada = " . dbField($data['monitor_size'], 'int') . ",
comp_fornecedor = " . dbField($data['supplier'], 'int') . ",
comp_nf = " . dbField($data['invoice_number'], 'text') . ",
comp_coment = " . dbField($data['additional_info'], 'text') . ",
comp_data_compra = " . dbField($data['purchase_date'], 'date') . ",
comp_valor = " . dbField($data['price'], 'float') . ",
comp_ccusto = " . dbField($data['cost_center'], 'int') . ",
comp_situac = " . dbField($data['condition'], 'int') . ",
comp_tipo_garant = " . dbField($data['warranty_type'], 'int') . ",
comp_garant_meses = " . dbField($data['time_of_warranty'], 'int') . ",
comp_assist = " . dbField($data['assistance'], 'int') . "
WHERE
comp_cod = '" . $data['cod'] . "'";
try {
$conn->exec($sql);
$data['success'] = true;
if ($data['department'] != $data['old_department']) {
//Se a Localização do equipamento for alterada é gravado na tabela de histórico!!!
$sql = "INSERT INTO historico
(
hist_inv, hist_inst, hist_local
)
VALUES
(
'" . $data['asset_tag'] . "',
'" . $data['asset_unit'] . "',
" . dbField($data['department'],'int') . "
)";
try {
$conn->exec($sql);
}
catch (Exception $e) {
$exception .= "
" . $e->getMessage();
}
}
/* Atualizar a localização dos componentes avulsos associados - a referência sao os
dados de etiqueta anteriores (caso tenham sofrido alteração)
*/
$sql = "SELECT * FROM {$table}
WHERE
eqp_equip_inv = '" . $data['old_tag'] . "' AND
eqp_equip_inst = '" . $data['old_unit'] . "'
";
try {
$res = $conn->query($sql);
$piecesIds = "";
if ($res->rowCount()) {
foreach ($res->fetchall() as $rowPieces) {
if (strlen((string)$piecesIds > 0))
$piecesIds .= ",";
$piecesIds .= $rowPieces['eqp_piece_id'];
}
}
if (!empty($piecesIds)) {
$sql = "UPDATE estoque SET
estoq_local = '" . $data['department'] . "'
WHERE
estoq_cod IN ({$piecesIds})
";
try {
$conn->exec($sql);
}
catch (Exception $e) {
$exception .= "
" . $e->getMessage(). "
" . $sql;
}
}
}
catch (Exception $e) {
$exception .= "
" . $e->getMessage() . "
" . $sql;
}
/**
* Atualização das informações relacionadas diretamente à etiqueta/unidade
* - Componentes avulsos
* - Ocorrências
* - Arquivos
*/
if ($data['old_tag'] != $data['asset_tag'] || $data['old_unit'] != $data['asset_unit']) {
/* indica que algum dos valores de etiqueta foi alterado */
$sql = "UPDATE {$table} SET
eqp_equip_inv = '" . $data['asset_tag'] . "',
eqp_equip_inst = '" . $data['asset_unit'] . "'
WHERE
eqp_equip_inv = '" . $data['old_tag'] . "' AND
eqp_equip_inst = '" . $data['old_unit'] . "'
";
try {
$conn->exec($sql);
}
catch (Exception $e) {
$exception .= "
" . $e->getMessage() . "
" . $sql;
}
/* ATualização da referência para ocorrências relacionadas */
$sql = "UPDATE ocorrencias SET
equipamento = '" . $data['asset_tag'] . "',
instituicao = '" . $data['asset_unit'] . "'
WHERE
equipamento = '" . $data['old_tag'] . "' AND
instituicao = '" . $data['old_unit'] . "'
";
try {
$conn->exec($sql);
}
catch (Exception $e) {
$exception .= "
" . $e->getMessage() . "" . $sql;
}
/* Atualizacao dos arquivos diretamente relacionados */
$sql = "UPDATE imagens SET
img_inv = '" . $data['asset_tag'] . "',
img_inst = '" . $data['asset_unit'] . "'
WHERE
img_inv = '" . $data['old_tag'] . "' AND
img_inst = '" . $data['old_unit'] . "'
";
try {
$conn->exec($sql);
}
catch (Exception $e) {
$exception .= "
" . $e->getMessage() . "" . $sql;
}
}
/* Final da atualização dos registros relacionados à etiqueta e unidade */
if ($data['processor'] != $oldData['comp_proc']) {
$sql = "INSERT INTO hw_alter (hwa_inst, hwa_inv, hwa_item, hwa_user, hwa_data)
VALUES (
'" . $data['asset_unit'] . "', '" . $data['asset_tag'] . "',
" . dbField($oldData['comp_proc']) . ", '" . $_SESSION['s_uid'] . "',
'" . date('Y-m-d H:i:s') . "'
)
";
try {
$conn->exec($sql);
}
catch (Exception $e) {
$exception .= "
" . $e->getMessage();
}
}
if ($data['motherboard'] != $oldData['comp_mb']) {
$sql = "INSERT INTO hw_alter (hwa_inst, hwa_inv, hwa_item, hwa_user, hwa_data)
VALUES (
'" . $data['asset_unit'] . "', '" . $data['asset_tag'] . "',
" . dbField($oldData['comp_mb']) . ", '" . $_SESSION['s_uid'] . "',
'" . date('Y-m-d H:i:s') . "'
)
";
try {
$conn->exec($sql);
}
catch (Exception $e) {
$exception .= "
" . $e->getMessage();
}
}
if ($data['memory'] != $oldData['comp_memo']) {
$sql = "INSERT INTO hw_alter (hwa_inst, hwa_inv, hwa_item, hwa_user, hwa_data)
VALUES (
'" . $data['asset_unit'] . "', '" . $data['asset_tag'] . "',
" . dbField($oldData['comp_memo']) . ", '" . $_SESSION['s_uid'] . "',
'" . date('Y-m-d H:i:s') . "'
)
";
try {
$conn->exec($sql);
}
catch (Exception $e) {
$exception .= "
" . $sql. "
" . $e->getMessage();
}
}
if ($data['video'] != $oldData['comp_video']) {
$sql = "INSERT INTO hw_alter (hwa_inst, hwa_inv, hwa_item, hwa_user, hwa_data)
VALUES (
'" . $data['asset_unit'] . "', '" . $data['asset_tag'] . "',
" . dbField($oldData['comp_video']) . ", '" . $_SESSION['s_uid'] . "',
'" . date('Y-m-d H:i:s') . "'
)
";
try {
$conn->exec($sql);
}
catch (Exception $e) {
$exception .= "
" . $e->getMessage();
}
}
if ($data['sound'] != $oldData['comp_som']) {
$sql = "INSERT INTO hw_alter (hwa_inst, hwa_inv, hwa_item, hwa_user, hwa_data)
VALUES (
'" . $data['asset_unit'] . "', '" . $data['asset_tag'] . "',
" . dbField($oldData['comp_som']) . ", '" . $_SESSION['s_uid'] . "',
'" . date('Y-m-d H:i:s') . "'
)
";
try {
$conn->exec($sql);
}
catch (Exception $e) {
$exception .= "
" . $e->getMessage();
}
}
if ($data['network'] != $oldData['comp_rede']) {
$sql = "INSERT INTO hw_alter (hwa_inst, hwa_inv, hwa_item, hwa_user, hwa_data)
VALUES (
'" . $data['asset_unit'] . "', '" . $data['asset_tag'] . "',
" . dbField($oldData['comp_rede']) . ", '" . $_SESSION['s_uid'] . "',
'" . date('Y-m-d H:i:s') . "'
)
";
try {
$conn->exec($sql);
} catch (Exception $e) {
$exception .= "
" . $e->getMessage();
}
}
if ($data['hdd'] != $oldData['comp_modelohd']) {
$sql = "INSERT INTO hw_alter (hwa_inst, hwa_inv, hwa_item, hwa_user, hwa_data)
VALUES (
'" . $data['asset_unit'] . "', '" . $data['asset_tag'] . "',
" . dbField($oldData['comp_modelohd']) . ", '" . $_SESSION['s_uid'] . "',
'" . date('Y-m-d H:i:s') . "'
)
";
try {
$conn->exec($sql);
}
catch (Exception $e) {
$exception .= "
" . $e->getMessage();
}
}
if ($data['modem'] != $oldData['comp_modem']) {
$sql = "INSERT INTO hw_alter (hwa_inst, hwa_inv, hwa_item, hwa_user, hwa_data)
VALUES (
'" . $data['asset_unit'] . "', '" . $data['asset_tag'] . "',
" . dbField($oldData['comp_modem']) . ", '" . $_SESSION['s_uid'] . "',
'" . date('Y-m-d H:i:s') . "'
)
";
try {
$conn->exec($sql);
}
catch (Exception $e) {
$exception .= "
" . $e->getMessage();
}
}
if ($data['cdrom'] != $oldData['comp_cdrom']) {
$sql = "INSERT INTO hw_alter (hwa_inst, hwa_inv, hwa_item, hwa_user, hwa_data)
VALUES (
'" . $data['asset_unit'] . "', '" . $data['asset_tag'] . "',
" . dbField($oldData['comp_cdrom']) . ", '" . $_SESSION['s_uid'] . "',
'" . date('Y-m-d H:i:s') . "'
)
";
try {
$conn->exec($sql);
}
catch (Exception $e) {
$exception .= "
" . $e->getMessage();
}
}
if ($data['dvdrom'] != $oldData['comp_dvd']) {
$sql = "INSERT INTO hw_alter (hwa_inst, hwa_inv, hwa_item, hwa_user, hwa_data)
VALUES (
'" . $data['asset_unit'] . "', '" . $data['asset_tag'] . "',
" . dbField($oldData['comp_dvd']) . ", '" . $_SESSION['s_uid'] . "',
'" . date('Y-m-d H:i:s') . "'
)
";
try {
$conn->exec($sql);
}
catch (Exception $e) {
$exception .= "
" . $e->getMessage();
}
}
if ($data['recorder'] != $oldData['comp_grav']) {
$sql = "INSERT INTO hw_alter (hwa_inst, hwa_inv, hwa_item, hwa_user, hwa_data)
VALUES (
'" . $data['asset_unit'] . "', '" . $data['asset_tag'] . "',
" . dbField($oldData['comp_grav']) . ", '" . $_SESSION['s_uid'] . "',
'" . date('Y-m-d H:i:s') . "'
)
";
try {
$conn->exec($sql);
}
catch (Exception $e) {
$exception .= "
" . $e->getMessage();
}
}
$data['message'] = TRANS('MSG_SUCCESS_EDIT') . $exception;
} catch (Exception $e) {
$data['success'] = false;
$data['message'] = TRANS('MSG_ERR_DATA_UPDATE') . "
". $sql . "
" . $e->getMessage();
$_SESSION['flash'] = message('danger', 'Ooops!', $data['message'], '');
echo json_encode($data);
return false;
}
} elseif ($data['action'] == 'delete') {
/* Só permite exclusão se for admin */
if ($_SESSION['s_nivel'] != 1) {
$data['success'] = false;
$data['message'] = TRANS('ACTION_NOT_ALLOWED');
$_SESSION['flash'] = message('danger', '', $data['message'] . $exception, '');
echo json_encode($data);
return false;
}
/* Busco os dados do equipamento */
$equipmentInfo = getEquipmentInfo($conn, null, null, $data['cod']);
$tag = $equipmentInfo['comp_inv'];
$unit = $equipmentInfo['comp_inst'];
/* Checa se há componentes avulsos associados */
$sql = "SELECT * FROM {$table} WHERE eqp_equip_inv = '{$tag}' AND eqp_equip_inst = '{$unit}' ";
$res = $conn->query($sql);
if ($res->rowCount()) {
$data['success'] = false;
$data['message'] = TRANS('MSG_CANT_DEL');
$_SESSION['flash'] = message('danger', '', $data['message'] . $exception, '');
echo json_encode($data);
return false;
}
/* Checa se há chamados associados associados */
$sql = "SELECT * FROM ocorrencias WHERE equipamento = '{$tag}' AND instituicao = '{$unit}' ";
$res = $conn->query($sql);
if ($res->rowCount()) {
$data['success'] = false;
$data['message'] = TRANS('MSG_CANT_DEL');
$_SESSION['flash'] = message('danger', '', $data['message'] . $exception, '');
echo json_encode($data);
return false;
}
/* Sem restrições para excluir o registro */
$sql = "DELETE FROM equipamentos WHERE comp_cod = '" . $data['cod'] . "'";
try {
$conn->exec($sql);
$data['success'] = true;
/* Remover do historico de localizacao (hist_inv, hist_inst) */
$sql = "DELETE FROM historico WHERE hist_inv = '{$tag}' AND hist_inst = '{$unit}' ";
try {
$conn->exec($sql);
}
catch (Exception $e) {
$exception .= "
" . $e->getMessage();
}
/* Remover do historico de alteração de hardware (hwa_inst, hwa_inv) */
$sql = "DELETE FROM hw_alter WHERE hwa_inv = '{$tag}' AND hwa_inst = '{$unit}' ";
try {
$conn->exec($sql);
}
catch (Exception $e) {
$exception .= "
" . $e->getMessage();
}
/* Remover do hw_sw (hws_hw_inst, hws_hw_cod) também */
$sql = "DELETE FROM hw_sw WHERE hws_hw_cod = '{$tag}' AND hws_hw_inst = '{$unit}' ";
try {
$conn->exec($sql);
}
catch (Exception $e) {
$exception .= "
" . $e->getMessage();
}
$data['message'] = TRANS('OK_DEL');
$_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_DATA_REMOVE');
$_SESSION['flash'] = message('danger', '', $data['message'] . $exception, '');
echo json_encode($data);
return false;
}
}
/* Upload de arquivos - Todos os actions */
foreach ($filesClean as $attach) {
$fileinput = $attach['tmp_name'];
$tamanho = getimagesize($fileinput);
$tamanho2 = filesize($fileinput);
if (!$tamanho) {
/* Nâo é imagem */
unset ($tamanho);
$tamanho = [];
$tamanho[0] = "";
$tamanho[1] = "";
}
if (chop($fileinput) != "") {
// $fileinput should point to a temp file on the server
// which contains the uploaded file. so we will prepare
// the file for upload with addslashes and form an sql
// statement to do the load into the database.
// $file = addslashes(fread(fopen($fileinput, "r"), 10000000));
$file = addslashes(fread(fopen($fileinput, "r"), $config['conf_upld_size']));
$sqlFile = "INSERT INTO imagens (img_nome, img_inst, img_inv, img_tipo, img_bin, img_largura, img_altura, img_size) values " .
"('" . noSpace($attach['name']) . "', '" . $data['asset_unit'] . "', '" . $data['asset_tag'] . "','" . $attach['type'] . "', " .
"'" . $file . "', " . dbField($tamanho[0]) . ", " . dbField($tamanho[1]) . ", " . dbField($tamanho2) . ")";
// now we can delete the temp file
unlink($fileinput);
}
try {
$exec = $conn->exec($sqlFile);
}
catch (Exception $e) {
$data['message'] = $data['message'] . "
" . TRANS('MSG_ERR_NOT_ATTACH_FILE');
$exception .= "
" . $e->getMessage();
}
}
/* Final do upload de arquivos */
//Exclui os anexos marcados - Action edit || close
if ( $data['total_files_to_deal'] > 0 ) {
for ($j = 1; $j <= $data['total_files_to_deal']; $j++) {
if (isset($post['delImg'][$j])) {
$qryDel = "DELETE FROM imagens WHERE img_cod = " . $post['delImg'][$j] . "";
try {
$conn->exec($qryDel);
} catch (Exception $e) {
$exception .= "
" . $e->getMessage();
}
}
}
}
$_SESSION['flash'] = message('success', '', $data['message'] . $exception, '');
echo json_encode($data);
return false;