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; // var_dump($post);exit; $config = getConfig($conn); // $rowLogado = getUserInfo($conn, $_SESSION['s_uid']); $recordFile = []; $erro = false; $exception = ""; $screenNotification = ""; $data = []; $data['success'] = true; $data['message'] = ""; $data['cod'] = (isset($post['cod']) ? intval($post['cod']) : ""); $data['numero'] = (isset($post['numero']) ? intval($post['numero']) : ""); $data['action'] = $post['action']; $data['field_id'] = ""; $data['csrf_session_key'] = (isset($post['csrf_session_key']) ? $post['csrf_session_key'] : ""); $data['type'] = (isset($post['type']) ? noHtml($post['type']) : ""); $data['manufacturer'] = (isset($post['manufacturer']) ? noHtml($post['manufacturer']) : ""); $data['model_name'] = (isset($post['model_name']) ? noHtml($post['model_name']) : ""); $data['measure_type'] = (isset($post['measure_type']) && !empty(array_filter($post['measure_type'], function($v) { return !empty($v); })) ? array_map('noHtml', $post['measure_type']) : []); $data['measure_unit'] = (isset($post['measure_unit']) && !empty(array_filter($post['measure_unit'], function($v) { return !empty($v); })) ? array_map('noHtml', $post['measure_unit']) : []); $data['measure_value'] = (isset($post['measure_value']) && !empty(array_filter($post['measure_value'], function($v) { return !empty($v); })) ? array_map('noHtml', $post['measure_value']) : []); $data['spec_id'] = (isset($post['spec_id']) ? $post['spec_id'] : []); $data['measure_type_update'] = (isset($post['measure_type_update']) && !empty(array_filter($post['measure_type_update'], function($v) { return !empty($v); })) ? array_map('noHtml', $post['measure_type_update']) : []); $data['measure_unit_update'] = (isset($post['measure_unit_update']) && !empty(array_filter($post['measure_unit_update'], function($v) { return !empty($v); })) ? array_map('noHtml', $post['measure_unit_update']) : []); $data['measure_value_update'] = (isset($post['measure_value_update']) && !empty(array_filter($post['measure_value_update'], function($v) { return !empty($v); })) ? array_map('noHtml', $post['measure_value_update']) : []); $data['deleteSpec'] = (isset($post['deleteSpec']) ? $post['deleteSpec'] : []); $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_name'] == "") { $data['success'] = false; $data['field_id'] = "model_name"; } if ($data['success'] == false) { $data['message'] = message('warning', '', TRANS('MSG_EMPTY_DATA'), ''); echo json_encode($data); return false; } if (!empty($data['measure_type'])) { $i = 0; foreach ($data['measure_type'] as $attr) { if ($attr != "" && (empty($data['measure_unit'][$i]) || empty($data['measure_value'][$i]))) { $data['success'] = false; break; } $i++; } } /* action edit */ if (!empty($data['spec_id'])) { $i = 0; foreach ($data['spec_id'] as $attr) { if ($attr != "" && (empty($data['measure_unit_update'][$i]) || empty($data['measure_value_update'][$i]))) { $data['success'] = false; break; } $i++; } } if ($data['success'] == false) { $data['field_id'] = "measure_type"; $data['message'] = message('warning', '', TRANS('MSG_EMPTY_ATTRIBUTE'), ''); echo json_encode($data); return false; } if (!empty($data['measure_value'])) { $i = 0; foreach ($data['measure_value'] as $attr) { if (!filter_var($attr, FILTER_VALIDATE_FLOAT)) { $data['success'] = false; break; } $i++; } } if (!empty($data['measure_value_update'])) { $i = 0; foreach ($data['measure_value_update'] as $attr) { if (!filter_var($attr, FILTER_VALIDATE_FLOAT)) { $data['success'] = false; break; } $i++; } } if ($data['success'] == false) { $data['field_id'] = "measure_type"; $data['message'] = message('warning', '', TRANS('MSG_ERROR_WRONG_FORMATTED'), ''); echo json_encode($data); return false; } } // var_dump($post); exit; /* 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") { $sql = "SELECT * FROM marcas_comp WHERE marc_manufacturer = '" . $data['manufacturer'] . "' AND marc_nome = '" . $data['model_name'] . "'"; $res = $conn->query($sql); if ($res->rowCount()) { $data['success'] = false; $data['field_id'] = "model_name"; $data['message'] = message('warning', '', TRANS('MSG_RECORD_EXISTS'), ''); echo json_encode($data); return false; } /* Verificação de CSRF */ // if (!csrf_verify($post)) { 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 marcas_comp ( marc_nome, marc_tipo, marc_manufacturer ) VALUES ( '" . $data['model_name'] . "', '" . $data['type'] . "', '" . $data['manufacturer'] . "' )"; try { $conn->exec($sql); $data['success'] = true; $data['cod'] = $conn->lastInsertId(); /* Inserções das características do modelo */ if (!empty($data['measure_type'])) { $i = 0; foreach ($data['measure_type'] as $attr) { if (!empty($attr)) { $sql = "INSERT INTO model_x_specs ( model_id, measure_unit_id, spec_value ) VALUES ( '" . $data['cod'] . "', '" . $data['measure_unit'][$i] . "', '" . $data['measure_value'][$i] . "' )"; try { $conn->exec($sql); } catch (Exception $e) { $exception .= "