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; $exception = ""; $data = []; $data['success'] = true; $data['message'] = ""; // var_dump($post); $data['action'] = (isset($post['action']) ? noHtml($post['action']) : ""); if (empty($data['action'])) { $data['success'] = false; $data['message'] = message('warning', '', TRANS('MSG_SOMETHING_GOT_WRONG'), ''); echo json_encode($data); return false; } $data['text_assets_ids'] = (isset($post['assets_ids']) ? noHtml($post['assets_ids']) : ""); if (empty($data['text_assets_ids'])) { $data['success'] = false; $data['message'] = message('warning', '', TRANS('MSG_SOMETHING_GOT_WRONG'), ''); echo json_encode($data); return false; } $data['assets_ids'] = explode(',', $data['text_assets_ids']); $data['assets_ids'] = array_filter($data['assets_ids']); $data['assets_ids'] = array_map('intval', $data['assets_ids']); /* Para manter a compatibilidade com versões antigas */ $table = "equipxpieces"; $sqlTest = "SELECT * FROM {$table}"; try { $conn->query($sqlTest); } catch (Exception $e) { $table = "equipXpieces"; } if ($data['action'] == "delete") { /* Só permite exclusão se for admin */ if ($_SESSION['s_nivel'] != 1) { $data['success'] = false; $data['message'] = message('danger', 'Ooops!', TRANS('PERMISSIONS_NOT_SUFFICIENT') . $exception, ''); echo json_encode($data); return false; } $data['cant_be_deleted'] = []; $data['reason'] = []; foreach ($data['assets_ids'] as $asset_id) { /* Verificações e ações necessárias para a remoção dos ativos */ /* Busco os dados do ativo */ $assetInfo = getEquipmentInfo($conn, null, null, $asset_id); if (empty($assetInfo)) { $data['success'] = false; $data['message'] = message('warning', '', TRANS('MSG_SOMETHING_GOT_WRONG'), ''); echo json_encode($data); return false; } $tag = $assetInfo['comp_inv']; $unit = $assetInfo['comp_inst']; $unit_name = getUnits($conn, null, (int)$unit)['inst_nome']; /* Checa se está vinculado a algum usuário */ $sql = "SELECT id FROM users_x_assets WHERE asset_id = '{$asset_id}' AND is_current = 1 "; $res = $conn->query($sql); if ($res->rowCount()) { $data['cant_be_deleted'][$asset_id] = $tag . " - " . $unit_name; $data['reason'][$asset_id] = TRANS('CANT_DELETE_DUE_ALLOCATION'); $data['success'] = false; continue; } /* 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['cant_be_deleted'][$asset_id] = $tag . " - " . $unit_name; $data['reason'][$asset_id] = TRANS('CANT_DELETE_DUE_LEGACY_AGREGATION'); $data['success'] = false; continue; } /* Checa se há chamados associados */ $sql = "SELECT * FROM ocorrencias WHERE equipamento = '{$tag}' AND instituicao = '{$unit}' "; $res = $conn->query($sql); if ($res->rowCount()) { $data['cant_be_deleted'][$asset_id] = $tag . " - " . $unit_name; $data['reason'][$asset_id] = TRANS('CANT_DELETE_DUE_TICKETS'); $data['success'] = false; continue; } /* Checa se há ativos agregados */ $hasAggregated = getAssetSpecs($conn, $asset_id, true); if (!empty($hasAggregated)) { $data['cant_be_deleted'][$asset_id] = $tag . " - " . $unit_name; $data['reason'][$asset_id] = TRANS('CANT_DELETE_DUE_AGGREGATION'); $data['success'] = false; continue; } /* Checa se o ativo possui um ativo pai */ $hasParent = getAssetParentId($conn, $asset_id); if (!empty($hasParent)) { $data['cant_be_deleted'][$asset_id] = $tag . " - " . $unit_name; $data['reason'][$asset_id] = TRANS('CANT_DELETE_DUE_AGGREGATED_PARENT'); $data['success'] = false; continue; } } if (!empty($data['cant_be_deleted'])) { foreach ($data['cant_be_deleted'] as $asset_id => $asset_name) { $data['reason'][$asset_id] = '