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 = ""; $screenNotification = ""; $data = []; $data['success'] = true; $data['message'] = ""; $data['cod'] = (isset($post['cod']) ? intval($post['cod']) : ""); $data['action'] = $post['action']; $data['field_id'] = ""; $data['csrf_session_key'] = (isset($post['csrf_session_key']) ? $post['csrf_session_key'] : ""); $data['mt_name'] = (isset($post['mt_name']) ? noHtml($post['mt_name']) : ""); $data['mt_description'] = (isset($post['mt_description']) ? noHtml($post['mt_description']) : ""); /* array_filter com callback null: apenas no PHP 8 */ $data['unit_name'] = (isset($post['unit_name']) && !empty(array_filter($post['unit_name'], function($v) { return !empty($v); })) ? array_map('noHtml', $post['unit_name']) : []); $data['unit_abbrev'] = (isset($post['unit_abbrev']) && !empty(array_filter($post['unit_abbrev'], function($v) { return !empty($v); })) ? array_map('noHtml', $post['unit_abbrev']) : []); $data['equity_factor'] = (isset($post['equity_factor']) && !empty(array_filter($post['equity_factor'], function($v) { return !empty($v); })) ? array_map('noHtml', $post['equity_factor']) : []); $data['operation'] = (isset($post['operation']) && !empty($post['operation']) ? $post['operation'] : []); $data['unit_id'] = (isset($post['unit_id']) && !empty(array_filter($post['unit_id'], function($v) { return !empty($v); })) ? array_map('noHtml', $post['unit_id']) : []); $data['unit_name_update'] = (isset($post['unit_name_update']) && !empty(array_filter($post['unit_name_update'], function($v) { return !empty($v); })) ? array_map('noHtml', $post['unit_name_update']) : []); $data['unit_abbrev_update'] = (isset($post['unit_abbrev_update']) && !empty(array_filter($post['unit_abbrev_update'], function($v) { return !empty($v); })) ? array_map('noHtml', $post['unit_abbrev_update']) : []); $data['equity_factor_update'] = (isset($post['equity_factor_update']) && !empty(array_filter($post['equity_factor_update'], function($v) { return !empty($v); })) ? array_map('noHtml', $post['equity_factor_update']) : []); $data['operation_update'] = (isset($post['operation_update']) && !empty($post['operation_update']) ? $post['operation_update'] : []); $data['delete_unit'] = (isset($post['delete_unit']) ? $post['delete_unit'] : []); /* Validações */ if ($data['action'] == "new" || $data['action'] == "edit") { if (empty($data['mt_name'])) { $data['success'] = false; $data['field_id'] = "mt_name"; } elseif ($data['action'] == "new" && empty($data['unit_name'])) { $data['success'] = false; $data['field_id'] = "unit_name"; } if ($data['success'] == false) { $data['message'] = message('warning', 'Ooops!', TRANS('MSG_EMPTY_DATA'),''); echo json_encode($data); return false; } if (!empty($data['unit_name'])) { $i = 0; foreach ($data['unit_name'] as $unitRow) { if ($unitRow != "" && (empty($data['unit_abbrev'][$i]) || empty($data['equity_factor'][$i]))) { $data['success'] = false; break; } $i++; } } /* action edit */ if (!empty($data['unit_id'])) { $i = 0; foreach ($data['unit_id'] as $unitRow) { if ($unitRow != "" && (empty($data['unit_name_update']) || empty($data['unit_abbrev_update'][$i]) || empty($data['equity_factor_update'][$i]))) { $data['success'] = false; break; } $i++; } } if ($data['success'] == false) { $data['field_id'] = "unit_name"; $data['message'] = message('warning', '', TRANS('MSG_EMPTY_UNIT_INFO'), ''); echo json_encode($data); return false; } if (!empty($data['equity_factor'])) { $i = 0; foreach ($data['equity_factor'] as $factor) { if (!filter_var($factor, FILTER_VALIDATE_FLOAT)) { $data['success'] = false; break; } $i++; } } if ($data['success'] == false) { $data['field_id'] = ""; $data['message'] = message('warning', '', TRANS('MSG_ERROR_WRONG_FORMATTED'), ''); echo json_encode($data); return false; } if ($data['action'] == "new") { if (count(array_unique($data['unit_name'])) != count($data['operation']) || count(array_unique($data['unit_abbrev'])) != count($data['operation'])) { $data['success'] = false; } /* Checa se há valores == 1 no $data['equity_factor'] - Esse valor é aceito apenas uma vez como unidade de referência */ $referenceUnit = array_filter($data['equity_factor'], function($v) { return $v == 1; }); if (count($referenceUnit) > 1) { $data['success'] = false; }; /* Concateno o operation com o equity_factor para checar se há duplicações */ $arrayCombo = []; $i = 0; foreach ($data['operation'] as $operation) { $arrayCombo[] = $operation . $data['equity_factor'][$i]; $i++; } if (count(array_unique($arrayCombo)) != count($data['operation'])) { $data['success'] = false; } } if ($data['action'] == "edit") { $countUnitNames = count(array_unique(array_merge($data['unit_name'], $data['unit_name_update']))); $countUnitAbbrevs = count(array_unique(array_merge($data['unit_abbrev'], $data['unit_abbrev_update']))); $countUnitOperation = count(array_merge($data['unit_abbrev'], $data['unit_abbrev_update'])); if ($countUnitNames != $countUnitOperation || $countUnitAbbrevs != $countUnitOperation) { $data['success'] = false; } /* Checa se há valores == 1 no $data['equity_factor'] - Esse valor é aceito apenas uma vez como unidade de referência */ $mergedEquityFactor = array_merge($data['equity_factor'], $data['equity_factor_update']); $referenceUnit = array_filter($mergedEquityFactor, function($v) { return $v == 1; }); if (count($referenceUnit) > 1) { $data['success'] = false; }; /* Concateno o operation com o equity_factor para checar se há duplicações */ $arrayCombo = []; $mergedOperation = array_merge($data['operation'], $data['operation_update']); $i = 0; foreach ($mergedOperation as $operation) { $arrayCombo[] = $operation . $mergedEquityFactor[$i]; $i++; } if (count(array_unique($arrayCombo)) != count($mergedOperation)) { $data['success'] = false; } } if ($data['success'] == false) { $data['field_id'] = ""; $data['message'] = message('warning', '', TRANS('MSG_INCONSISTENCY_FILLING'), ''); echo json_encode($data); return false; } } if ($data['action'] == 'new') { /* verifica se um registro com esse nome já existe */ $sql = "SELECT id FROM measure_types WHERE mt_name = '" . $data['mt_name'] . "' "; $res = $conn->query($sql); if ($res->rowCount()) { $data['success'] = false; $data['field_id'] = "mt_name"; $data['message'] = message('warning', '', TRANS('MSG_RECORD_EXISTS'), ''); echo json_encode($data); return false; } /* */ if (!csrf_verify($post, $data['csrf_session_key'])) { $data['success'] = false; $data['message'] = message('warning', 'Ooops!', TRANS('FORM_ALREADY_SENT'),''); echo json_encode($data); return false; } $sql = "INSERT INTO measure_types ( mt_name, mt_description ) VALUES ( '" . $data['mt_name'] . "', " . dbField($data['mt_description'], 'text') . " )"; try { $conn->exec($sql); $data['success'] = true; $data['message'] = TRANS('MSG_SUCCESS_INSERT'); $data['cod'] = $conn->lastInsertId(); if (!empty($data['unit_name'])) { $i = 0; foreach ($data['unit_name'] as $unitRow) { $sql = "INSERT INTO measure_units ( type_id, unit_name, unit_abbrev, equity_factor, operation ) VALUES ( " . $data['cod'] . ", '" . $unitRow . "', '" . $data['unit_abbrev'][$i] . "', '" . $data['equity_factor'][$i] . "', '" . $data['operation'][$i] . "' )"; try { $conn->exec($sql); } catch (Exception $e) { $exception .= "