FILTER_SANITIZE_FULL_SPECIAL_CHARS, 'remember_user' => FILTER_SANITIZE_FULL_SPECIAL_CHARS, 'pass' => FILTER_DEFAULT, ]); $data['user'] = (isset($post['user']) && !empty($post['user']) ? noHtml($post['user']) : ""); $data['pass'] = (isset($post['pass']) && !empty($post['pass']) ? $post['pass'] : ""); $data['remember_user'] = (isset($post['remember_user']) && $post['remember_user'] == "1" ? true : false); $_SESSION['session_expired'] = 0; $data['max_tries'] = 5; /* Número de tentativas mal sucedidas até o bloqueio */ $data['time_to_wait'] = 60; /* Tempo de espera, em segundos, após o número máximo de tentativas ser atingido*/ /* Validações */ if (empty($data['user']) || empty($data['pass'])) { $data['success'] = false; $data['field_id'] = (empty($data['user']) ? 'user' : 'pass'); $data['message'] = message('warning', 'Ooops!', TRANS('MSG_EMPTY_DATA'),''); echo json_encode($data); return false; } if (!valida(TRANS('FIELD_USER'), $data['user'], 'MAIL', 1, $ERRO) && !valida(TRANS('FIELD_USER'), $data['user'], 'USUARIO', 1, $ERRO)) { $data['success'] = false; $data['field_id'] = "user"; $data['message'] = message('warning', '', $ERRO, ''); echo json_encode($data); return false; } } if ($authType == "SYSTEM") { /* Controle de quantidade de tentativas de acesso sem sucesso */ if (isset($_SESSION['attempt']) && $_SESSION['attempt']['try'] > $data['max_tries']) { if (time() < $_SESSION['attempt']['time'] + $data['time_to_wait']) { $data['success'] = false; $data['message'] = message('warning', 'Ooops!', TRANS('EXCEEDED_OF_LOGON_ATTEMPTS'), ''); echo json_encode($data); return false; } else { $_SESSION['attempt']['try'] = 1; } } /* Validação de user e pass */ if (!(pass($conn, $data['user'], $data['pass']))) { /* Contabilização das tentativas de acesso */ if (!isset($_SESSION['attempt'])) { $_SESSION['attempt']['try'] = 1; $_SESSION['attempt']['time'] = time(); } else { $_SESSION['attempt']['try'] = $_SESSION['attempt']['try'] + 1; $_SESSION['attempt']['time'] = time(); } $data['success'] = false; $data['field_id'] = (empty($data['user']) ? 'user' : 'pass'); $data['message'] = message('danger', 'Ooops!', TRANS('ERR_LOGON') . ".
" . TRANS('TRY') . " " . $_SESSION['attempt']['try'], ''); echo json_encode($data); return false; } } elseif ($authType == "LDAP") { /* Controle de quantidade de tentativas de acesso sem sucesso */ if (isset($_SESSION['attempt']) && $_SESSION['attempt']['try'] > $data['max_tries']) { if (time() < $_SESSION['attempt']['time'] + $data['time_to_wait']) { $data['success'] = false; $data['message'] = message('warning', 'Ooops!', TRANS('EXCEEDED_OF_LOGON_ATTEMPTS'), ''); echo json_encode($data); return false; } else { $_SESSION['attempt']['try'] = 1; } } /* Validação de user e pass - LDAP */ $configValues = getConfigValues($conn); $ldapConfig = [ 'LDAP_HOST' => $configValues['LDAP_HOST'] ?? '', 'LDAP_PORT' => $configValues['LDAP_PORT'] ?? '', 'LDAP_DOMAIN' => $configValues['LDAP_DOMAIN'] ?? '', 'LDAP_BASEDN' => $configValues['LDAP_BASEDN'] ?? '', 'LDAP_FIELD_FULLNAME' => $configValues['LDAP_FIELD_FULLNAME'] ?? '', 'LDAP_FIELD_EMAIL' => $configValues['LDAP_FIELD_EMAIL'] ?? '', 'LDAP_FIELD_PHONE' => $configValues['LDAP_FIELD_PHONE'] ?? '', ]; if (!passLdap($data['user'], $data['pass'], $ldapConfig)) { /* Contabilização das tentativas de acesso */ if (!isset($_SESSION['attempt'])) { $_SESSION['attempt']['try'] = 1; $_SESSION['attempt']['time'] = time(); } else { $_SESSION['attempt']['try'] = $_SESSION['attempt']['try'] + 1; $_SESSION['attempt']['time'] = time(); } $data['success'] = false; $data['field_id'] = (empty($data['user']) ? 'user' : 'pass'); $data['message'] = message('danger', 'Ooops!', TRANS('ERR_LOGON_LDAP'), ''); echo json_encode($data); return false; } /* Checa se o usuário existe na base local */ if (!isLocalUser($conn, $data['user'])) { /* Caso o usuário não exista localmente, deverá ser criado */ /* getUserLdapData() */ $userData = getUserLdapData($data['user'], $data['pass'], $ldapConfig); $data['hash'] = pass_hash(md5($data['pass'])); $data['fullname'] = $userData['LDAP_FIELD_FULLNAME'] ?? ''; $data['email'] = $userData['LDAP_FIELD_EMAIL'] ?? ''; $data['phone'] = $userData['LDAP_FIELD_PHONE'] ?? ''; $data['client_to_bind'] = (array_key_exists('LDAP_CLIENT_TO_BIND_NEWUSERS', $configValues) ? $configValues['LDAP_CLIENT_TO_BIND_NEWUSERS'] : ""); $sql = "INSERT INTO usuarios ( login, user_client, nome, hash, data_inc, data_admis, email, fone, nivel, AREA, user_admin ) VALUES ( '" . $data['user'] . "', " . dbField($data['client_to_bind']) . ", '" . $data['fullname'] . "', '" . $data['hash'] . "', '" . $now . "', NULL, '" . $data['email'] . "', '" . $data['phone'] . "', '3', '" . $configValues['LDAP_AREA_TO_BIND_NEWUSERS'] . "', 0 )"; try { $conn->exec($sql); // $data['success'] = true; // $data['message'] = message('success', '', TRANS('LDAP_SUCCESS_NEW_USER'), ''); // echo json_encode($data); // return false; } catch (Exception $e) { $exception .= "
" . $e->getMessage(); $data['success'] = false; $data['field_id'] = (empty($data['user']) ? 'user' : 'pass'); $data['message'] = message('danger', 'Ooops!', TRANS('LDAP_FAIL_NEW_USER'), ''); echo json_encode($data); return false; } } } elseif ($authType == "OIDC") { /* Configurações OIDC */ $configValues = getConfigValues($conn); $oidcConfig = [ 'OIDC_ISSUER' => $configValues['OIDC_ISSUER'] ?? '', 'OIDC_CLIENT_ID' => $configValues['OIDC_CLIENT_ID'] ?? '', 'OIDC_CLIENT_SECRET' => $configValues['OIDC_CLIENT_SECRET'] ?? '', 'OIDC_FIELD_USERNAME' => $configValues['OIDC_FIELD_USERNAME'] ?? 'preferred_username', 'OIDC_FIELD_FULLNAME' => $configValues['OIDC_FIELD_FULLNAME'] ?? 'name', 'OIDC_FIELD_EMAIL' => $configValues['OIDC_FIELD_EMAIL'] ?? 'email', 'OIDC_FIELD_PHONE' => $configValues['OIDC_FIELD_PHONE'] ?? '', ]; $oidc = new OpenIDConnectClient( $oidcConfig['OIDC_ISSUER'], $oidcConfig['OIDC_CLIENT_ID'], $oidcConfig['OIDC_CLIENT_SECRET'] ); // $sid = $oidc->getSidFromBackChannel(); // $_SESSION['s_oidc_sid'] = $sid; if (isLocalhost()) { $oidc->setVerifyHost(false); //dev only $oidc->setVerifyPeer(false); //dev only $oidc->setHttpUpgradeInsecureRequests(false); //dev only } // $oidc->setCertPath('/path/to/my.cert'); // Configure a proxy //$oidc->setHttpProxy("http://my.proxy.com:80/"); // Sets redirect URL for auth flow // $oidc->setRedirectURL($oidcConfig['OIDC_REDIRECT_URL']); try { $oidc->authenticate(); } catch (Exception $e) { $data['success'] = false; $data['message'] = message('danger', 'Ooops!', TRANS('MSG_CANT_CONNECT_TO_IDENTITY_PROVIDER') . $e->getMessage(), '', '', true); echo $data['message']; // echo json_encode($data); return false; } $accessToken = $oidc->getAccessToken(); $idToken = $oidc->getIdToken(); $refreshToken = $oidc->getRefreshToken(); $_SESSION['s_oidc_id_token'] = $idToken; $_SESSION['s_oidc_access_token'] = $accessToken; $_SESSION['s_oidc_refresh_token'] = $refreshToken; $tokenResp = $oidc->getTokenResponse(); $_SESSION['s_token_response'] = $tokenResp; // var_dump($accessToken); exit; // $_SESSION['s_oidc_issuer'] = $oidcConfig['OIDC_ISSUER']; // $_SESSION['s_oidc_client_id'] = $oidcConfig['OIDC_CLIENT_ID']; // $_SESSION['s_oidc_client_secret'] = $oidcConfig['OIDC_CLIENT_SECRET']; // var_dump($oidc); $userData = $oidc->requestUserInfo(); $data['user'] = $userData->{$oidcConfig['OIDC_FIELD_USERNAME']}; /* $oidc->name $oidc->email $oidc->phone $oidc->preferred_username */ /* Checa se o usuário existe na base local */ if (!isLocalUser($conn, $data['user'])) { /* Caso o usuário não exista localmente, deverá ser criado */ $data['hash'] = pass_hash(md5($userData->sub)); $data['fullname'] = $userData->{$oidcConfig['OIDC_FIELD_FULLNAME']}; $data['email'] = $userData->{$oidcConfig['OIDC_FIELD_EMAIL']}; $data['phone'] = (isset($userData->{$oidcConfig['OIDC_FIELD_PHONE']}) ? $userData->{$oidcConfig['OIDC_FIELD_PHONE']} : ""); $data['client_to_bind'] = (array_key_exists('OIDC_CLIENT_TO_BIND_NEWUSERS', $configValues) ? $configValues['OIDC_CLIENT_TO_BIND_NEWUSERS'] : ""); $sql = "INSERT INTO usuarios ( login, user_client, nome, hash, data_inc, data_admis, email, fone, nivel, AREA, user_admin ) VALUES ( '" . $data['user'] . "', " . dbField($data['client_to_bind']) . ", '" . $data['fullname'] . "', '" . $data['hash'] . "', '" . $now . "', NULL, '" . $data['email'] . "', '" . $data['phone'] . "', '3', '" . $configValues['OIDC_AREA_TO_BIND_NEWUSERS'] . "', 0 )"; try { $conn->exec($sql); } catch (Exception $e) { $exception .= "
" . $e->getMessage(); $data['success'] = false; $data['field_id'] = (empty($data['user']) ? 'user' : 'pass'); $data['message'] = message('danger', 'Ooops!', TRANS('LDAP_FAIL_NEW_USER') . $exception, ''); echo json_encode($data); return false; } } } else { $data['success'] = false; $data['field_id'] = (empty($data['user']) ? 'user' : 'pass'); $data['message'] = message('danger', 'Ooops!', TRANS('AUTH_TYPE_NOT_IDENTIFIED'), ''); echo json_encode($data); return false; } $userInfo = getUserInfo($conn, 0, $data['user']); $userClient = (!empty($userInfo['user_client']) ? getClients($conn, $userInfo['user_client']) : ''); /* Permissão de acesso */ if ($userInfo['nivel'] > 3 || (!empty($userClient) && $userClient['is_active'] == 0)) { $data['success'] = false; $data['field_id'] = "user"; $data['message'] = message('warning', '', TRANS('ERR_LOGON'), ''); echo json_encode($data); return false; } $_SESSION['attempt']['try'] = 0; /* Cookie para o nome de usuário : 30 dias */ if (isset($data['remember_user']) && !empty($data['remember_user'])) { setcookie("oc_login", $data['user'], time() + 60 * 60 * 24 * 30, "/"); } else { setcookie("oc_login", "", time() - 60 * 60 * 24 * 30, "/"); } $firstLogon = ($userInfo['last_logon'] == "" ? true : false); updateLastLogon($conn, $userInfo['user_id']); $area = $userInfo['area_id']; $secondaryAreas = ""; $secondaryAreas .= getUserAreas($conn, $userInfo['user_id']); /* apenas secundárias */ $allAreas = (!empty($secondaryAreas) ? $area . "," . $secondaryAreas : $area); $mod_tickets = getModuleAccess($conn, 1, $allAreas); $mod_inventory = getModuleAccess($conn, 2, $allAreas); $modulos = ""; if ($mod_tickets) $modulos = '1'; if ($mod_inventory) { if (strlen((string)$modulos)) $modulos .= ","; $modulos .= '2'; } $_SESSION['s_permissoes'] = $modulos; $config = getConfig($conn); $_SESSION['s_logado'] = 1; $_SESSION['csrf_token'] = ""; $_SESSION['s_usuario'] = $data['user']; $_SESSION['s_usuario_nome'] = $userInfo['nome']; $_SESSION['s_uid'] = $userInfo['user_id']; $_SESSION['s_nivel_real'] = $userInfo['nivel']; $_SESSION['s_nivel'] = $userInfo['nivel']; $_SESSION['s_nivel_desc'] = $userInfo['nivel']; $_SESSION['s_area'] = $userInfo['area_id']; $_SESSION['s_uareas'] = $allAreas; $areaInfo = getAreaInfo($conn, $userInfo['area_id']); $opening_mode = (!isset($areaInfo['sis_opening_mode']) || empty($areaInfo['sis_opening_mode']) ? 1 : $areaInfo['sis_opening_mode']); $_SESSION['s_opening_mode'] = $opening_mode; /* 1: clássico | 2: dinâmico */ $_SESSION['s_area_admin'] = $userInfo['user_admin']; $_SESSION['s_can_route'] = $userInfo['can_route']; $_SESSION['s_can_get_routed'] = $userInfo['can_get_routed']; $_SESSION['s_ocomon'] = $mod_tickets; $_SESSION['s_invmon'] = $mod_inventory; /* Variáveis básicas para os relatórios */ $_SESSION['s_rep_filters']['client'] = ''; $_SESSION['s_rep_filters']['units'] = []; $_SESSION['s_rep_filters']['area'] = $userInfo['area_id']; $_SESSION['s_rep_filters']['d_ini'] = date("01/m/Y"); $_SESSION['s_rep_filters']['d_fim'] = date("d/m/Y"); $_SESSION['s_rep_filters']['issue'] = -1; $_SESSION['s_rep_filters']['resource'] = -1; $_SESSION['s_rep_filters']['state'] = 1; $_SESSION['s_rep_filters']['cat1'] = -1; $_SESSION['s_rep_filters']['cat2'] = -1; $_SESSION['s_rep_filters']['cat3'] = -1; $_SESSION['s_rep_filters']['cat4'] = -1; $_SESSION['s_rep_filters']['cat5'] = -1; $_SESSION['s_rep_filters']['cat6'] = -1; /** * Limitação de visualização de itens do inventário a unidades específicas * Vazio indica que não há limitação de visualização */ $allowedUnits = getAreaAllowedUnits($conn, $userInfo['area_id']); if ($userInfo['nivel'] != 1 && !empty($allowedUnits)) { $_SESSION['s_allowed_units'] = implode(',', array_column($allowedUnits, 'unit_id')); } else { $_SESSION['s_allowed_units'] = ""; } $allowedClients = implode(',', array_column(getAreaAllowedClients($conn, $_SESSION['s_area']), 'inst_client')); if ($userInfo['nivel'] != 1 && !empty($allowedClients)) { $_SESSION['s_allowed_clients'] = $allowedClients; } else { $_SESSION['s_allowed_clients'] = ""; } // $_SESSION['s_screen'] = $userInfo['sis_screen'] ?? 2; /* Segundo registro - criado no install */ $defaultScreenProfile = getDefaultScreenProfile($conn); $_SESSION['s_screen'] = $userInfo['sis_screen'] ?? $defaultScreenProfile ; // $_SESSION['s_screen'] = $userInfo['sis_screen']; $_SESSION['s_wt_areas'] = $config['conf_wt_areas']; //1: origem , 2: destino $_SESSION['s_formatBarOco'] = 0; $_SESSION['s_formatBarMural'] = 0; if (strpos($config['conf_formatBar'], '%oco%')) { $_SESSION['s_formatBarOco'] = 1; } if (strpos($config['conf_formatBar'], '%mural%')) { $_SESSION['s_formatBarMural'] = 1; } $_SESSION['s_language'] = (!empty($userInfo['language']) ? $userInfo['language'] : $config['conf_language']); $_SESSION['s_date_format'] = $config['conf_date_format']; $_SESSION['s_paging_full'] = 0; $_SESSION['s_page_size'] = $config['conf_page_size']; $_SESSION['s_allow_reopen'] = $config['conf_allow_reopen']; $_SESSION['s_ocomon_site'] = $config['conf_ocomon_site']; $_SESSION['s_colorDestaca'] = "#CCCCCC"; $_SESSION['s_colorMarca'] = "#FFFFCC"; $_SESSION['s_colorLinPar'] = "#E3E1E1"; $_SESSION['s_colorLinImpar'] = "#F6F6F6"; /* Generate hash if it doesnt exist - versões anteriores à versão 4.x*/ if (empty($userInfo['hash'])) { $sql = "UPDATE usuarios SET password = null, hash = '" . pass_hash($data['pass']) . "' WHERE user_id = :user_id "; try { $res = $conn->prepare($sql); $res->bindParam(':user_id', $userInfo['user_id'], PDO::PARAM_INT); $res->execute(); } catch (Exception $e) { $exception .= "
" . $e->getMessage(); } } $data['success'] = true; $message = ($firstLogon ? TRANS('MSG_WELCOME') : TRANS('MSG_WELCOME_BACK')); $_SESSION['flash'] = message('success', TRANS('MSG_HELLO') . " " . firstLetterUp(firstWord($userInfo['nome'])) . "!", $message . $exception, ''); if ($authType == "OIDC") { redirect('../../login.php'); } echo json_encode($data);