/
home
/
suroeste
/
public_html
/
gorbus.transportessuroeste.com
/
suroeste
/
blank_email_pruebas
/
/home/suroeste/public_html/gorbus.transportessuroeste.com/suroeste/blank_email_pruebas
mkdir
upload
Name
Size
Mode
Actions
blank_email_pruebas.htm
125
0644
edit
dl
rm
blank_email_pruebas.php
67
0644
edit
dl
rm
blank_email_pruebas_det_ltr.css
0
0644
edit
dl
rm
blank_email_pruebas_det_rtl.css
0
0644
edit
dl
rm
blank_email_pruebas_download.php
1877
0644
edit
dl
rm
blank_email_pruebas_erro.class.php
1421
0644
edit
dl
rm
blank_email_pruebas_erro.php
7896
0644
edit
dl
rm
blank_email_pruebas_fil_ltr.css
0
0644
edit
dl
rm
blank_email_pruebas_fil_rtl.css
0
0644
edit
dl
rm
blank_email_pruebas_grid_ltr.css
0
0644
edit
dl
rm
blank_email_pruebas_grid_rtl.css
0
0644
edit
dl
rm
blank_email_pruebas_json.php
36980
0644
edit
dl
rm
blank_email_pruebas_res_ltr.css
0
0644
edit
dl
rm
blank_email_pruebas_res_rtl.css
0
0644
edit
dl
rm
blank_email_pruebas_sc_mail_image.php
2728
0644
edit
dl
rm
blank_email_pruebas_session.php
3065
0644
edit
dl
rm
blank_email_pruebas_teste.php
46
0644
edit
dl
rm
index.php
139873
0644
edit
dl
rm
Edit:
/home/suroeste/public_html/gorbus.transportessuroeste.com/suroeste/blank_email_pruebas/index.php
(139873B)
<?php include_once('blank_email_pruebas_session.php'); @ini_set('session.cookie_httponly', 1); @ini_set('session.use_only_cookies', 1); @ini_set('session.cookie_secure', 0); @session_start() ; $_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_perfil'] = "conn_mysql"; $_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_path_prod'] = ""; $_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_path_conf'] = ""; $_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_path_imagens'] = ""; $_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_path_imag_temp'] = ""; $_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_path_cache'] = ""; $_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_path_doc'] = ""; //check publication with the prod $NM_dir_atual = getcwd(); if (empty($NM_dir_atual)) { $str_path_sys = (isset($_SERVER['SCRIPT_FILENAME'])) ? $_SERVER['SCRIPT_FILENAME'] : $_SERVER['ORIG_PATH_TRANSLATED']; $str_path_sys = str_replace("\\", '/', $str_path_sys); } else { $sc_nm_arquivo = explode("/", $_SERVER['PHP_SELF']); $str_path_sys = str_replace("\\", "/", getcwd()) . "/" . $sc_nm_arquivo[count($sc_nm_arquivo)-1]; } $str_path_apl_url = $_SERVER['PHP_SELF']; $str_path_apl_url = str_replace("\\", '/', $str_path_apl_url); $str_path_apl_url = substr($str_path_apl_url, 0, strrpos($str_path_apl_url, "/")); $str_path_apl_url = substr($str_path_apl_url, 0, strrpos($str_path_apl_url, "/")+1); $str_path_apl_dir = substr($str_path_sys, 0, strrpos($str_path_sys, "/")); $str_path_apl_dir = substr($str_path_apl_dir, 0, strrpos($str_path_apl_dir, "/")+1); //check prod if(empty($_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_path_prod'])) { /*check prod*/$_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_path_prod'] = $str_path_apl_url . "_lib/prod"; } //check img if(empty($_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_path_imagens'])) { /*check img*/$_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_path_imagens'] = $str_path_apl_url . "_lib/file/img"; } //check tmp if(empty($_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_path_imag_temp'])) { /*check tmp*/$_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_path_imag_temp'] = $str_path_apl_url . "_lib/tmp"; } //check cache if(empty($_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_path_cache'])) { /*check tmp*/$_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_path_cache'] = $str_path_apl_dir . "_lib/file/cache"; } //check doc if(empty($_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_path_doc'])) { /*check doc*/$_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_path_doc'] = $str_path_apl_dir . "_lib/file/doc"; } //end check publication with the prod // class blank_email_pruebas_ini { var $nm_cod_apl; var $nm_nome_apl; var $nm_seguranca; var $nm_grupo; var $nm_autor; var $nm_versao_sc; var $nm_tp_lic_sc; var $nm_dt_criacao; var $nm_hr_criacao; var $nm_autor_alt; var $nm_dt_ult_alt; var $nm_hr_ult_alt; var $nm_timestamp; var $nm_app_version; var $cor_link_dados; var $root; var $server; var $java_protocol; var $server_pdf; var $Arr_result; var $sc_protocolo; var $path_prod; var $path_link; var $path_aplicacao; var $path_embutida; var $path_botoes; var $path_img_global; var $path_img_modelo; var $path_icones; var $path_imagens; var $path_imag_cab; var $path_imag_temp; var $path_libs; var $path_doc; var $str_lang; var $str_conf_reg; var $str_schema_all; var $Str_btn_grid; var $str_google_fonts; var $path_cep; var $path_secure; var $path_js; var $path_help; var $path_adodb; var $path_grafico; var $path_atual; var $Gd_missing; var $sc_site_ssl; var $Qtd_reg_ajax_grid; var $nm_falta_var; var $nm_falta_var_db; var $nm_tpbanco; var $nm_servidor; var $nm_usuario; var $nm_senha; var $nm_database_encoding; var $nm_arr_db_extra_args = array(); var $nm_con_db2 = array(); var $nm_con_persistente; var $nm_con_use_schema; var $nm_tabela; var $nm_ger_css_emb; var $sc_tem_trans_banco; var $nm_bases_all; var $nm_bases_mysql; var $nm_bases_sqlite; var $sc_page; var $sc_lig_md5 = array(); var $sc_lig_target = array(); var $sc_export_ajax = false; var $sc_export_ajax_img = false; var $force_db_utf8 = true; // function init($Tp_init = "") { global $nm_url_saida, $nm_apl_dependente, $script_case_init, $nmgp_opcao; if (!function_exists("sc_check_mobile")) { include_once("../_lib/lib/php/nm_check_mobile.php"); } include_once("../_lib/lib/php/fix.php"); $_SESSION['scriptcase']['proc_mobile'] = sc_check_mobile(); if (isset($_GET['_sc_force_mobile'])) { $_SESSION['scriptcase']['force_mobile'] = 'Y' == $_GET['_sc_force_mobile']; } if (isset($_SESSION['scriptcase']['force_mobile'])) { $_SESSION['scriptcase']['proc_mobile'] = $_SESSION['scriptcase']['force_mobile']; } @ini_set('magic_quotes_runtime', 0); $this->sc_page = $script_case_init; $_SESSION['scriptcase']['sc_num_page'] = $script_case_init; $_SESSION['scriptcase']['sc_cnt_sql'] = 0; $this->sc_charset['UTF-8'] = 'utf-8'; $this->sc_charset['ISO-2022-JP'] = 'iso-2022-jp'; $this->sc_charset['ISO-2022-KR'] = 'iso-2022-kr'; $this->sc_charset['ISO-8859-1'] = 'iso-8859-1'; $this->sc_charset['ISO-8859-2'] = 'iso-8859-2'; $this->sc_charset['ISO-8859-3'] = 'iso-8859-3'; $this->sc_charset['ISO-8859-4'] = 'iso-8859-4'; $this->sc_charset['ISO-8859-5'] = 'iso-8859-5'; $this->sc_charset['ISO-8859-6'] = 'iso-8859-6'; $this->sc_charset['ISO-8859-7'] = 'iso-8859-7'; $this->sc_charset['ISO-8859-8'] = 'iso-8859-8'; $this->sc_charset['ISO-8859-8-I'] = 'iso-8859-8-i'; $this->sc_charset['ISO-8859-9'] = 'iso-8859-9'; $this->sc_charset['ISO-8859-10'] = 'iso-8859-10'; $this->sc_charset['ISO-8859-13'] = 'iso-8859-13'; $this->sc_charset['ISO-8859-14'] = 'iso-8859-14'; $this->sc_charset['ISO-8859-15'] = 'iso-8859-15'; $this->sc_charset['WINDOWS-1250'] = 'windows-1250'; $this->sc_charset['WINDOWS-1251'] = 'windows-1251'; $this->sc_charset['WINDOWS-1252'] = 'windows-1252'; $this->sc_charset['TIS-620'] = 'tis-620'; $this->sc_charset['WINDOWS-1253'] = 'windows-1253'; $this->sc_charset['WINDOWS-1254'] = 'windows-1254'; $this->sc_charset['WINDOWS-1255'] = 'windows-1255'; $this->sc_charset['WINDOWS-1256'] = 'windows-1256'; $this->sc_charset['WINDOWS-1257'] = 'windows-1257'; $this->sc_charset['KOI8-R'] = 'koi8-r'; $this->sc_charset['BIG-5'] = 'big5'; $this->sc_charset['EUC-CN'] = 'EUC-CN'; $this->sc_charset['GB18030'] = 'GB18030'; $this->sc_charset['GB2312'] = 'gb2312'; $this->sc_charset['EUC-JP'] = 'euc-jp'; $this->sc_charset['SJIS'] = 'shift-jis'; $this->sc_charset['EUC-KR'] = 'euc-kr'; $_SESSION['scriptcase']['charset_entities']['UTF-8'] = 'UTF-8'; $_SESSION['scriptcase']['charset_entities']['ISO-8859-1'] = 'ISO-8859-1'; $_SESSION['scriptcase']['charset_entities']['ISO-8859-5'] = 'ISO-8859-5'; $_SESSION['scriptcase']['charset_entities']['ISO-8859-15'] = 'ISO-8859-15'; $_SESSION['scriptcase']['charset_entities']['WINDOWS-1251'] = 'cp1251'; $_SESSION['scriptcase']['charset_entities']['WINDOWS-1252'] = 'cp1252'; $_SESSION['scriptcase']['charset_entities']['BIG-5'] = 'BIG5'; $_SESSION['scriptcase']['charset_entities']['EUC-CN'] = 'GB2312'; $_SESSION['scriptcase']['charset_entities']['GB2312'] = 'GB2312'; $_SESSION['scriptcase']['charset_entities']['SJIS'] = 'Shift_JIS'; $_SESSION['scriptcase']['charset_entities']['EUC-JP'] = 'EUC-JP'; $_SESSION['scriptcase']['charset_entities']['KOI8-R'] = 'KOI8-R'; $_SESSION['scriptcase']['trial_version'] = 'N'; $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['decimal_db'] = "."; $this->nm_cod_apl = "blank_email_pruebas"; $this->nm_nome_apl = ""; $this->nm_seguranca = ""; $this->nm_grupo = "GorbusWeb"; $this->nm_grupo_versao = "1"; $this->nm_autor = "admin"; $this->nm_script_by = "netmake"; $this->nm_script_type = "PHP"; $this->nm_versao_sc = "v9"; $this->nm_tp_lic_sc = "pe_mysql_bronze"; $this->nm_dt_criacao = "20250721"; $this->nm_hr_criacao = "082912"; $this->nm_autor_alt = "admin"; $this->nm_dt_ult_alt = "20251122"; $this->nm_hr_ult_alt = "163442"; $this->Apl_paginacao = "PARCIAL"; $temp_bug_list = explode(" ", microtime()); list($NM_usec, $NM_sec) = $temp_bug_list; $this->nm_timestamp = (float) $NM_sec; $this->nm_app_version = "1.0.0"; // // $NM_dir_atual = getcwd(); if (empty($NM_dir_atual)) { $str_path_sys = (isset($_SERVER['SCRIPT_FILENAME'])) ? $_SERVER['SCRIPT_FILENAME'] : $_SERVER['ORIG_PATH_TRANSLATED']; $str_path_sys = str_replace("\\", '/', $str_path_sys); } else { $sc_nm_arquivo = explode("/", $_SERVER['PHP_SELF']); $str_path_sys = str_replace("\\", "/", getcwd()) . "/" . $sc_nm_arquivo[count($sc_nm_arquivo)-1]; } $this->sc_site_ssl = $this->appIsSsl(); $this->sc_protocolo = $this->sc_site_ssl ? 'https://' : 'http://'; $this->sc_protocolo = ""; $this->path_prod = $_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_path_prod']; $this->path_conf = $_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_path_conf']; $this->path_imagens = $_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_path_imagens']; $this->path_imag_temp = $_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_path_imag_temp']; $this->path_cache = $_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_path_cache']; $this->path_doc = $_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_path_doc']; if (!isset($_SESSION['scriptcase']['str_lang']) || empty($_SESSION['scriptcase']['str_lang'])) { $_SESSION['scriptcase']['str_lang'] = "es"; } if (!isset($_SESSION['scriptcase']['str_conf_reg']) || empty($_SESSION['scriptcase']['str_conf_reg'])) { $_SESSION['scriptcase']['str_conf_reg'] = "es_co"; } $this->str_lang = $_SESSION['scriptcase']['str_lang']; $this->str_conf_reg = $_SESSION['scriptcase']['str_conf_reg']; if (!isset($_SESSION['scriptcase']['blank_email_pruebas']['save_session']['save_grid_state_session'])) { $_SESSION['scriptcase']['blank_email_pruebas']['save_session']['save_grid_state_session'] = false; $_SESSION['scriptcase']['blank_email_pruebas']['save_session']['data'] = ''; } $this->str_schema_all = (isset($_SESSION['scriptcase']['str_schema_all']) && !empty($_SESSION['scriptcase']['str_schema_all'])) ? $_SESSION['scriptcase']['str_schema_all'] : "Sc7_BlueSky/Sc7_BlueSky"; if (isset($_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['sub_cons_schema_all'])) { $this->str_schema_all = $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['sub_cons_schema_all']; $this->str_schema_filter = $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['sub_cons_schema_filter']; } $_SESSION['scriptcase']['erro']['str_schema'] = $this->str_schema_all . "_error.css"; $_SESSION['scriptcase']['erro']['str_lang'] = $this->str_lang; $this->server = (!isset($_SERVER['HTTP_HOST'])) ? $_SERVER['SERVER_NAME'] : $_SERVER['HTTP_HOST']; if (!isset($_SERVER['HTTP_HOST']) && isset($_SERVER['SERVER_PORT']) && $_SERVER['SERVER_PORT'] != 80 && !$this->sc_site_ssl ) { $this->server .= ":" . $_SERVER['SERVER_PORT']; } $this->java_protocol = ($this->sc_site_ssl) ? 'https://' : 'http://'; $this->server_pdf = $this->java_protocol . $this->server; $this->server = ""; $str_path_web = $_SERVER['PHP_SELF']; $str_path_web = str_replace("\\", '/', $str_path_web); $str_path_web = str_replace('//', '/', $str_path_web); $this->root = substr($str_path_sys, 0, -1 * strlen($str_path_web)); $this->path_aplicacao = substr($str_path_sys, 0, strrpos($str_path_sys, '/')); $this->path_aplicacao = substr($this->path_aplicacao, 0, strrpos($this->path_aplicacao, '/')) . '/blank_email_pruebas'; $this->path_embutida = substr($this->path_aplicacao, 0, strrpos($this->path_aplicacao, '/') + 1); $this->path_aplicacao .= '/'; $this->path_link = substr($str_path_web, 0, strrpos($str_path_web, '/')); $this->path_link = substr($this->path_link, 0, strrpos($this->path_link, '/')) . '/'; $this->path_botoes = $this->path_link . "_lib/img"; $this->path_img_global = $this->path_link . "_lib/img"; $this->path_img_modelo = $this->path_link . "_lib/img"; $this->path_icones = $this->path_link . "_lib/img"; $this->path_imag_cab = $this->path_link . "_lib/img"; $this->path_help = $this->path_link . "_lib/webhelp/"; $this->path_font = $this->root . $this->path_link . "_lib/font/"; $this->path_btn = $this->root . $this->path_link . "_lib/buttons/"; $this->path_css = $this->root . $this->path_link . "_lib/css/"; $this->path_lib_php = $this->root . $this->path_link . "_lib/lib/php"; $this->path_lib_js = $this->root . $this->path_link . "_lib/lib/js"; $pos_path = strrpos($this->path_prod, "/"); $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['path_grid_sv'] = $this->root . substr($this->path_prod, 0, $pos_path) . "/conf/grid_sv/"; $this->path_lang = "../_lib/lang/"; $this->path_lang_js = "../_lib/js/"; $this->path_chart_theme = $this->root . $this->path_link . "_lib/chart/"; $this->path_cep = $this->path_prod . "/cep"; $this->path_cor = $this->path_prod . "/cor"; $this->path_js = $this->path_prod . "/lib/js"; $this->path_libs = $this->root . $this->path_prod . "/lib/php"; $this->path_third = $this->root . $this->path_prod . "/third"; $this->path_adodb = $this->root . $this->path_prod . "/third/adodb"; $_SESSION['scriptcase']['dir_temp'] = $this->root . $this->path_imag_temp; $this->Cmp_Sql_Time = array(); include("../_lib/css/" . $this->str_schema_all . "_grid.php"); $temp_Str_btn_grid = trim($str_button) . "/" . trim($str_button) . $_SESSION['scriptcase']['reg_conf']['css_dir'] . ".php"; include($this->path_btn . $temp_Str_btn_grid); $this->css_help_tooltip_faicon = isset($css_help_tooltip_faicon) && '' != trim($css_help_tooltip_faicon) ? trim($css_help_tooltip_faicon) : "fa fa-question-circle"; $this->css_schema_info_tooltiptheme = isset($css_schema_info_tooltiptheme) && '' != trim($css_schema_info_tooltiptheme) ? trim($css_schema_info_tooltiptheme) : ""; $this->tippy_themes = []; $this->tippy_theme_default = ''; if ('' != $this->css_schema_info_tooltiptheme) { $this->scGetTippyCssTheme($this->tippy_themes, $this->css_schema_info_tooltiptheme); $this->tippy_theme_default = $this->css_schema_info_tooltiptheme; } if (isset($_SESSION['scriptcase']['blank_email_pruebas']['session_timeout']['lang'])) { $this->str_lang = $_SESSION['scriptcase']['blank_email_pruebas']['session_timeout']['lang']; } elseif (!isset($_SESSION['scriptcase']['blank_email_pruebas']['actual_lang']) || $_SESSION['scriptcase']['blank_email_pruebas']['actual_lang'] != $this->str_lang) { $_SESSION['scriptcase']['blank_email_pruebas']['actual_lang'] = $this->str_lang; setcookie('sc_actual_lang_GorbusWeb',$this->str_lang,'0','/', '', ini_get('session.cookie_secure'), ini_get('session.cookie_httponly')); } $_SESSION['scriptcase']['fusioncharts_new'] = true; if (!isset($_SESSION['scriptcase']['phantomjs_charts'])) { $_SESSION['scriptcase']['phantomjs_charts'] = @is_dir($this->path_third . '/phantomjs'); } if (isset($_SESSION['scriptcase']['phantomjs_charts'])) { $aTmpOS = $this->getRunningOS(); $_SESSION['scriptcase']['phantomjs_charts'] = @is_dir($this->path_third . '/phantomjs/' . $aTmpOS['os']); } if (!class_exists('Services_JSON')) { include_once("blank_email_pruebas_json.php"); } $this->SC_Link_View = (isset($_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['SC_Link_View'])) ? $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['SC_Link_View'] : false; if (isset($_GET['SC_Link_View']) && !empty($_GET['SC_Link_View']) && is_numeric($_GET['SC_Link_View'])) { if ($_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['embutida']) { $this->SC_Link_View = true; $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['SC_Link_View'] = true; } } if (isset($_POST['nmgp_opcao']) && 'ajax_check_file' == $_POST['nmgp_opcao'] ){ include_once("../_lib/lib/php/nm_api.php"); switch( $_REQUEST['rsargs'] ){ default: echo 0;exit; break; } $out1_img_cache = $_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_path_imag_temp'] . $file_name; $orig_img = $_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_path_imag_temp']. '/'.basename($_POST['AjaxCheckImg']); copy($__file_download, $_SERVER['DOCUMENT_ROOT'].$orig_img); echo $orig_img . '_@@NM@@_'; if(file_exists($out1_img_cache)){ echo $out1_img_cache; exit; } include_once("../_lib/lib/php/nm_trata_img.php"); copy($__file_download, $_SERVER['DOCUMENT_ROOT'].$out1_img_cache); $sc_obj_img = new nm_trata_img($_SERVER['DOCUMENT_ROOT'].$out1_img_cache, true); if(!empty($img_width) && !empty($img_height)){ $sc_obj_img->setWidth($img_width); $sc_obj_img->setHeight($img_height); } $sc_obj_img->createImg($_SERVER['DOCUMENT_ROOT'].$out1_img_cache); echo $out1_img_cache; exit; } if (isset($_POST['nmgp_opcao']) && $_POST['nmgp_opcao'] == "ajax_save_ancor") { $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['ancor_save'] = $_POST['ancor_save']; $oJson = new Services_JSON(); if ($_SESSION['scriptcase']['sem_session']) { unset($_SESSION['sc_session']); } exit; } if (isset($_SESSION['scriptcase']['user_logout'])) { foreach ($_SESSION['scriptcase']['user_logout'] as $ind => $parms) { if (isset($_SESSION[$parms['V']]) && $_SESSION[$parms['V']] == $parms['U']) { unset($_SESSION['scriptcase']['user_logout'][$ind]); $nm_apl_dest = $parms['R']; $dir = explode("/", $nm_apl_dest); if (count($dir) == 1) { $nm_apl_dest = str_replace(".php", "", $nm_apl_dest); $nm_apl_dest = $this->path_link . SC_dir_app_name($nm_apl_dest) . "/"; } if (isset($_POST['nmgp_opcao']) && ($_POST['nmgp_opcao'] == "ajax_event" || $_POST['nmgp_opcao'] == "ajax_navigate")) { $this->Arr_result = array(); $this->Arr_result['redirInfo']['action'] = $nm_apl_dest; $this->Arr_result['redirInfo']['target'] = $parms['T']; $this->Arr_result['redirInfo']['metodo'] = "post"; $this->Arr_result['redirInfo']['script_case_init'] = $this->sc_page; $oJson = new Services_JSON(); echo $oJson->encode($this->Arr_result); exit; } ?> <html> <body> <form name="FRedirect" method="POST" action="<?php echo $nm_apl_dest; ?>" target="<?php echo $parms['T']; ?>"> </form> <script> document.FRedirect.submit(); </script> </body> </html> <?php exit; } } } global $under_dashboard, $dashboard_app, $own_widget, $parent_widget, $compact_mode, $remove_margin, $remove_border, $remove_background; if (!isset($_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['dashboard_info']['under_dashboard'])) { $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['dashboard_info']['under_dashboard'] = false; $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['dashboard_info']['dashboard_app'] = ''; $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['dashboard_info']['own_widget'] = ''; $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['dashboard_info']['parent_widget'] = ''; $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['dashboard_info']['compact_mode'] = false; $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['dashboard_info']['remove_margin'] = false; $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['dashboard_info']['remove_border'] = false; $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['dashboard_info']['remove_background'] = false; } if (isset($_GET['under_dashboard']) && 1 == $_GET['under_dashboard']) { if (isset($_GET['own_widget']) && 'dbifrm_widget' == substr($_GET['own_widget'], 0, 13)) { $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['dashboard_info']['own_widget'] = $_GET['own_widget']; $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['dashboard_info']['under_dashboard'] = true; if (isset($_GET['dashboard_app'])) { $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['dashboard_info']['dashboard_app'] = $_GET['dashboard_app']; } if (isset($_GET['parent_widget'])) { $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['dashboard_info']['parent_widget'] = $_GET['parent_widget']; } if (isset($_GET['compact_mode'])) { $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['dashboard_info']['compact_mode'] = 1 == $_GET['compact_mode']; } if (isset($_GET['remove_margin'])) { $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['dashboard_info']['remove_margin'] = 1 == $_GET['remove_margin']; } if (isset($_GET['remove_border'])) { $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['dashboard_info']['remove_border'] = 1 == $_GET['remove_border']; } if (isset($_GET['remove_background'])) { $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['dashboard_info']['remove_background'] = 1 == $_GET['remove_background']; } } } elseif (isset($under_dashboard) && 1 == $under_dashboard) { if (isset($own_widget) && 'dbifrm_widget' == substr($own_widget, 0, 13)) { $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['dashboard_info']['own_widget'] = $own_widget; $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['dashboard_info']['under_dashboard'] = true; if (isset($dashboard_app)) { $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['dashboard_info']['dashboard_app'] = $dashboard_app; } if (isset($parent_widget)) { $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['dashboard_info']['parent_widget'] = $parent_widget; } if (isset($compact_mode)) { $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['dashboard_info']['compact_mode'] = 1 == $compact_mode; } if (isset($remove_margin)) { $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['dashboard_info']['remove_margin'] = 1 == $remove_margin; } if (isset($remove_border)) { $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['dashboard_info']['remove_border'] = 1 == $remove_border; } if (isset($remove_background)) { $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['dashboard_info']['remove_background'] = 1 == $remove_background; } } } if (!isset($_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['dashboard_info']['maximized'])) { $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['dashboard_info']['maximized'] = false; } if (isset($_GET['maximized'])) { $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['dashboard_info']['maximized'] = 1 == $_GET['maximized']; } if ($_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['dashboard_info']['under_dashboard']) { $sTmpDashboardApp = $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['dashboard_info']['dashboard_app']; if ('' != $sTmpDashboardApp && isset($_SESSION['scriptcase']['dashboard_targets'][$sTmpDashboardApp]["blank_email_pruebas"])) { foreach ($_SESSION['scriptcase']['dashboard_targets'][$sTmpDashboardApp]["blank_email_pruebas"] as $sTmpTargetLink => $sTmpTargetWidget) { if (isset($this->sc_lig_target[$sTmpTargetLink])) { $this->sc_lig_target[$sTmpTargetLink] = $sTmpTargetWidget; } } } } global $link_compact_mode, $link_remove_margin, $link_remove_border, $link_remove_background, $link_margin_top; if (isset($link_compact_mode) || isset($link_remove_margin) || isset($link_remove_border) || isset($link_remove_background) || isset($link_margin_top)) { $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['link_info'] = array(); } if (isset($link_compact_mode) && 'ok' == $link_compact_mode) { $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['link_info']['compact_mode'] = true; } if (isset($link_remove_margin) && 'ok' == $link_remove_margin) { $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['link_info']['remove_margin'] = true; } if (isset($link_remove_border) && 'ok' == $link_remove_border) { $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['link_info']['remove_border'] = true; } if (isset($link_remove_background) && 'ok' == $link_remove_background) { $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['link_info']['remove_background'] = true; } if (isset($link_margin_top) && '' != $link_margin_top) { $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['link_info']['margin_top'] = $link_margin_top; } if (!isset($_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['responsive_chart'])) { $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['responsive_chart'] = array( 'enabled' => false, 'active' => false, ); } if ($_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['responsive_chart']['enabled']) { $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['responsive_chart']['active'] = true; } elseif ($_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['dashboard_info']['under_dashboard'] && $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['dashboard_info']['compact_mode'] && !$_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['dashboard_info']['maximized']) { $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['responsive_chart']['active'] = true; } else { $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['responsive_chart']['active'] = false; } if ($Tp_init == "Path_sub") { return; } $str_path = substr($this->path_prod, 0, strrpos($this->path_prod, '/') + 1); if (!is_file($this->root . $str_path . 'devel/class/xmlparser/nmXmlparserIniSys.class.php')) { unset($_SESSION['scriptcase']['nm_sc_retorno']); unset($_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_conexao']); } include($this->path_lang . $this->str_lang . ".lang.php"); include($this->path_lang . "config_region.php"); include($this->path_lang . "lang_config_region.php"); asort($this->Nm_lang_conf_region); $_SESSION['scriptcase']['charset'] = "UTF-8"; ini_set('default_charset', $_SESSION['scriptcase']['charset']); $_SESSION['scriptcase']['charset_html'] = (isset($this->sc_charset[$_SESSION['scriptcase']['charset']])) ? $this->sc_charset[$_SESSION['scriptcase']['charset']] : $_SESSION['scriptcase']['charset']; if (!function_exists("mb_convert_encoding")) { echo "<div><font size=6>" . $this->Nm_lang['lang_othr_prod_xtmb'] . "</font></div>";exit; } elseif (!function_exists("sc_convert_encoding")) { echo "<div><font size=6>" . $this->Nm_lang['lang_othr_prod_xtsc'] . "</font></div>";exit; } foreach ($this->Nm_lang_conf_region as $ind => $dados) { if ($_SESSION['scriptcase']['charset'] != "UTF-8" && NM_is_utf8($dados)) { $this->Nm_lang_conf_region[$ind] = sc_convert_encoding($dados, $_SESSION['scriptcase']['charset'], "UTF-8"); } } foreach ($this->Nm_conf_reg[$this->str_conf_reg] as $ind => $dados) { if ($_SESSION['scriptcase']['charset'] != "UTF-8" && NM_is_utf8($dados)) { $this->Nm_conf_reg[$this->str_conf_reg][$ind] = sc_convert_encoding($dados, $_SESSION['scriptcase']['charset'], "UTF-8"); } } foreach ($this->Nm_lang as $ind => $dados) { if ($_SESSION['scriptcase']['charset'] != "UTF-8" && NM_is_utf8($ind)) { $ind = sc_convert_encoding($ind, $_SESSION['scriptcase']['charset'], "UTF-8"); $this->Nm_lang[$ind] = $dados; } if ($_SESSION['scriptcase']['charset'] != "UTF-8" && NM_is_utf8($dados)) { $this->Nm_lang[$ind] = sc_convert_encoding($dados, $_SESSION['scriptcase']['charset'], "UTF-8"); } $this->Nm_lang[$ind] = str_replace('"', '"', $this->Nm_lang[$ind]); } $_SESSION['sc_session']['SC_download_violation'] = $this->Nm_lang['lang_errm_fnfd']; if (isset($_SESSION['sc_session']['SC_parm_violation']) && !isset($_SESSION['scriptcase']['blank_email_pruebas']['session_timeout']['redir'])) { unset($_SESSION['sc_session']['SC_parm_violation']); echo "<html>"; echo "<body>"; echo "<table align=\"center\" width=\"50%\" border=1 height=\"50px\">"; echo "<tr>"; echo " <td align=\"center\">"; echo " <b><font size=4>" . $this->Nm_lang['lang_errm_ajax_data'] . "</font>"; echo " </b></td>"; echo " </tr>"; echo "</table>"; echo "</body>"; echo "</html>"; exit; } if (isset($_POST['nm_grid_submit']) && $_POST['nm_grid_submit'] == 1 && isset($_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['csrf_token'] ) && !isset($_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['embutida']) && !isset($_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['embutida_form'])) { if (!isset($_POST['csrf_token']) || $_POST['csrf_token'] != $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['csrf_token']) { echo "<html>"; echo "<body>"; echo "<table align=\"center\" width=\"50%\" border=1 height=\"50px\">"; echo "<tr>"; echo " <td align=\"center\">"; echo " <b><font size=4>" . $this->Nm_lang['lang_errm_ajax_csrf'] . "</font>"; echo " </b></td>"; echo " </tr>"; echo "</table>"; echo "</body>"; echo "</html>"; exit; } } if (isset($this->Nm_lang['lang_errm_dbcn_conn'])) { $_SESSION['scriptcase']['db_conn_error'] = $this->Nm_lang['lang_errm_dbcn_conn']; } $PHP_ver = str_replace(".", "", phpversion()); if (substr($PHP_ver, 0, 3) < 434) { echo "<div><font size=6>" . $this->Nm_lang['lang_othr_prod_phpv'] . "</font></div>";exit; } if (file_exists($this->path_libs . "/ver.dat")) { $SC_ver = file($this->path_libs . "/ver.dat"); $SC_ver = str_replace(".", "", $SC_ver[0]); if (substr($SC_ver, 0, 5) < 40015) { echo "<div><font size=6>" . $this->Nm_lang['lang_othr_prod_incp'] . "</font></div>";exit; } } $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['path_doc'] = $this->path_doc; $_SESSION['scriptcase']['nm_path_prod'] = $this->root . $this->path_prod . "/"; if (empty($this->path_imag_cab)) { $this->path_imag_cab = $this->path_img_global; } if (!is_dir($this->root . $this->path_prod)) { $str_message = "<html> <head> <title>{var_str_title}</title> <style> body { margin: 0px; padding: 0px; overflow-x: hidden; min-width: 320px; background: #FFFFFF; font-family: 'Lato', 'Helvetica Neue', Arial, Helvetica, sans-serif; font-size: 14px; line-height: 1.4285em; color: rgba(0, 0, 0, 0.87); font-smoothing: antialiased; } html, body { height: 100%; } body { margin: 0; } *, *:before, *:after { box-sizing: inherit; } user agent stylesheet body { display: block; margin: 8px; } html { font-size: 14px; } html { line-height: 1.15; -ms-text-size-adjust: 100%; -webkit-text-size-adjust: 100%; } *, *:before, *:after { box-sizing: inherit; } *, *:before, *:after { box-sizing: inherit; } ::selection { background-color: #CCE2FF; color: rgba(0, 0, 0, 0.87); } .ui.container { width: 933px; min-width: 992px; max-width: 1199px; margin-left: auto !important; margin-right: auto !important; } .ui.container { display: block; max-width: 100% !important; } *, *:before, *:after { box-sizing: inherit; } .ui.message:last-child { margin-bottom: 0em; } .ui.message:first-child { margin-top: 0em; } .ui.message { font-size: 1em; } .ui.message { position: relative; min-height: 1em; margin: 1em 0em; background: #F8F8F9; padding: 1em 1.5em; line-height: 1.4285em; color: rgba(0, 0, 0, 0.87); transition: opacity 0.1s ease, color 0.1s ease, background 0.1s ease, box-shadow 0.1s ease; border-radius: 0.28571429rem; box-shadow: 0px 0px 0px 1px rgba(34, 36, 38, 0.22) inset, 0px 0px 0px 0px rgba(0, 0, 0, 0); } article, aside, footer, header, nav, section { display: block; } *, *:before, *:after { box-sizing: inherit; } .ui.message> :last-child { margin-bottom: 0em; } .ui.message> :first-child { margin-top: 0em; } .ui.message .header+p { margin-top: 0.25em; } .ui.message p { opacity: 0.85; margin: 0.75em 0em; } p { margin: 0em 0em 1em; line-height: 1.4285em; } .ui.message .header:not(.ui) { font-size: 1.14285714em; } .ui.message .header { display: block; font-family: 'Lato', 'Helvetica Neue', Arial, Helvetica, sans-serif; font-weight: bold; margin: -0.14285714em 0em 1.2rem 0em; } .ui.button { cursor: pointer; display: inline-block; min-height: 1em; outline: 0; border: none; vertical-align: baseline; background: #e0e1e2 none; color: rgba(0, 0, 0, .6); font-family: Lato, 'Helvetica Neue', Arial, Helvetica, sans-serif; margin: 0 .25em 0 0; padding: .78571429em 1.5em .78571429em; text-transform: none; text-shadow: none; font-weight: 700; line-height: 1em; font-style: normal; text-align: center; text-decoration: none; border-radius: .28571429rem; box-shadow: 0 0 0 1px transparent inset, 0 0 0 0 rgba(34, 36, 38, .15) inset; -webkit-user-select: none; -moz-user-select: none; -ms-user-select: none; user-select: none; transition: opacity .1s ease, background-color .1s ease, color .1s ease, box-shadow .1s ease, background .1s ease; will-change: ''; -webkit-tap-highlight-color: transparent; } .ui.button, .ui.buttons .button, .ui.buttons .or { font-size: 1rem; flex-flow: row nowrap; justify-content: center; align-items: center; column-gap: .5rem; display: flex; } .ui.primary.button, .ui.primary.buttons .button { background-color: #2185d0; color: #fff; text-shadow: none; background-image: none; } .ui.primary.button { box-shadow: 0 0 0 0 rgba(34, 36, 38, .15) inset; } [type=reset], [type=submit], button, html [type=button] { -webkit-appearance: button; } .icon{ position: relative; width: 1.2rem; height: 1.2rem; display: block; color: inherit; background-repeat: no-repeat; } .icon.database{ background-image: url('data:image/svg+xml,<svg xmlns=\"http://www.w3.org/2000/svg\" viewBox=\"0 0 448 512\" fill=\"%23FFFFFF\"><path d=\"M448 80v48c0 44.2-100.3 80-224 80S0 172.2 0 128V80C0 35.8 100.3 0 224 0S448 35.8 448 80zM393.2 214.7c20.8-7.4 39.9-16.9 54.8-28.6V288c0 44.2-100.3 80-224 80S0 332.2 0 288V186.1c14.9 11.8 34 21.2 54.8 28.6C99.7 230.7 159.5 240 224 240s124.3-9.3 169.2-25.3zM0 346.1c14.9 11.8 34 21.2 54.8 28.6C99.7 390.7 159.5 400 224 400s124.3-9.3 169.2-25.3c20.8-7.4 39.9-16.9 54.8-28.6V432c0 44.2-100.3 80-224 80S0 476.2 0 432V346.1z\"/></svg>'); } </style> </head> <body> <div class='ui container' style='padding-top:2rem'> <section class='ui message'> <div class='content'> <div class='header'> <h1 class='ui header'>{var_str_title}</h1> </div> <p>{var_str_message}</p> <p>{var_str_message_conn}</p> {v_str_btn_inside} </div> </section> </div>"; $str_message_end = "</body> </html>"; $str_message = str_replace('{var_str_title}', $this->Nm_lang['lang_errm_cmlb_nfndtitle'], $str_message); $str_message = str_replace('{var_str_message}', $this->Nm_lang['lang_errm_cmlb_nfnd'], $str_message); $str_message = str_replace('{var_str_message_conn}','', $str_message); $str_message = str_replace('{v_str_btn_inside}', '', $str_message); echo $str_message; if (!$_SESSION['sc_session'][$script_case_init]['blank_email_pruebas']['iframe_menu'] && (!isset($_SESSION['sc_session'][$script_case_init]['blank_email_pruebas']['sc_outra_jan']) || !$_SESSION['sc_session'][$script_case_init]['blank_email_pruebas']['sc_outra_jan'])) { if (isset($_SESSION['scriptcase']['nm_sc_retorno']) && !empty($_SESSION['scriptcase']['nm_sc_retorno'])) if (isset($_SESSION['scriptcase']['nm_sc_retorno']) && !empty($_SESSION['scriptcase']['nm_sc_retorno'])) { $btn_value = "" . $this->Ini->Nm_lang['lang_btns_back'] . ""; if ($_SESSION['scriptcase']['charset'] != "UTF-8" && NM_is_utf8($btn_value)) { $btn_value = sc_convert_encoding($btn_value, $_SESSION['scriptcase']['charset'], "UTF-8"); } $btn_hint = "" . $this->Ini->Nm_lang['lang_btns_back_hint'] . ""; if ($_SESSION['scriptcase']['charset'] != "UTF-8" && NM_is_utf8($btn_hint)) { $btn_hint = sc_convert_encoding($btn_hint, $_SESSION['scriptcase']['charset'], "UTF-8"); } ?> <input type="button" id="sai" onClick="window.location='<?php echo $_SESSION['scriptcase']['nm_sc_retorno'] ?>'; return false" class="scButton_default" value="<?php echo $btn_value ?>" title="<?php echo $btn_hint ?>" style="vertical-align: middle;"> <?php } else { $btn_value = "" . $this->Ini->Nm_lang['lang_btns_exit'] . ""; if ($_SESSION['scriptcase']['charset'] != "UTF-8" && NM_is_utf8($btn_value)) { $btn_value = sc_convert_encoding($btn_value, $_SESSION['scriptcase']['charset'], "UTF-8"); } $btn_hint = "" . $this->Ini->Nm_lang['lang_btns_exit_hint'] . ""; if ($_SESSION['scriptcase']['charset'] != "UTF-8" && NM_is_utf8($btn_hint)) { $btn_hint = sc_convert_encoding($btn_hint, $_SESSION['scriptcase']['charset'], "UTF-8"); } ?> <input type="button" id="sai" onClick="window.location='<?php echo $nm_url_saida ?>'; return false" class="scButton_default" value="<?php echo $btn_value ?>" title="<?php echo $btn_hint ?>" style="vertical-align: middle;"> <?php } } echo $str_message_end; exit ; } $this->nm_ger_css_emb = true; $this->path_atual = getcwd(); $opsys = strtolower(php_uname()); // include_once($this->path_aplicacao . "blank_email_pruebas_erro.class.php"); $this->Erro = new blank_email_pruebas_erro(); include_once($this->path_adodb . "/adodb.inc.php"); $this->sc_Include($this->path_libs . "/nm_sec_prod.php", "F", "nm_reg_prod") ; $this->sc_Include($this->path_libs . "/nm_ini_perfil.php", "F", "perfil_lib") ; // if(function_exists('set_php_timezone')) set_php_timezone('blank_email_pruebas'); // $this->sc_Include($this->path_lib_php . "/nm_functions.php", "", "") ; global $bol_api_prod; $bol_api_prod = true; if (isset($_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_conexao']) && !empty($_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_conexao'])) { $bol_api_prod = false; } $this->sc_Include($this->path_lib_php . "/nm_api.php", "", "") ; $this->sc_Include($this->path_lib_php . "/nm_edit.php", "F", "nmgp_Form_Num_Val") ; $this->sc_Include($this->path_lib_php . "/nm_conv_dados.php", "F", "nm_conv_limpa_dado") ; $this->sc_Include($this->path_lib_php . "/nm_data.class.php", "C", "nm_data") ; $this->nm_data = new nm_data("es"); if (is_file("../_lib/css/" . $this->str_schema_all . "_grid.php")) { include("../_lib/css/" . $this->str_schema_all . "_grid.php"); } else { $str_tree_col = ""; $str_tree_exp = ""; $str_button = ""; } $this->Color_bg_ajax = (!isset($str_ajax_bg) || "" == trim($str_ajax_bg)) ? "#000" : $str_ajax_bg; $this->Border_c_ajax = (!isset($str_ajax_border_c) || "" == trim($str_ajax_border_c)) ? "" : $str_ajax_border_c; $this->Border_s_ajax = (!isset($str_ajax_border_s) || "" == trim($str_ajax_border_s)) ? "" : $str_ajax_border_s; $this->Border_w_ajax = (!isset($str_ajax_border_w) || "" == trim($str_ajax_border_w)) ? "" : $str_ajax_border_w; $this->Tree_img_col = trim($str_tree_col); $this->Tree_img_exp = trim($str_tree_exp); $this->scGridRefinedSearchExpandFAIcon = trim($scGridRefinedSearchExpandFAIcon); $this->scGridRefinedSearchCollapseFAIcon = trim($scGridRefinedSearchCollapseFAIcon); $_SESSION['scriptcase']['nmamd'] = array(); perfil_lib($this->path_libs); if (!isset($_SESSION['sc_session'][$this->sc_page]['SC_Check_Perfil'])) { if(function_exists("nm_check_perfil_exists")) nm_check_perfil_exists($this->path_libs, $this->path_prod); $_SESSION['sc_session'][$this->sc_page]['SC_Check_Perfil'] = true; } if (function_exists("nm_check_pdf_server")) $this->server_pdf = nm_check_pdf_server($this->path_libs, $this->server_pdf); if (!isset($_SESSION['scriptcase']['sc_num_img'])) { $_SESSION['scriptcase']['sc_num_img'] = 1; } $this->str_google_fonts= isset($str_google_fonts)?$str_google_fonts:''; $this->regionalDefault(); $this->Str_btn_grid = trim($str_button) . "/" . trim($str_button) . $_SESSION['scriptcase']['reg_conf']['css_dir'] . ".php"; $this->Str_btn_css = trim($str_button) . "/" . trim($str_button) . ".css"; if (is_file($this->path_btn . $this->Str_btn_grid)) { include($this->path_btn . $this->Str_btn_grid); } $_SESSION['scriptcase']['erro']['str_schema_dir'] = $this->str_schema_all . "_error" . $_SESSION['scriptcase']['reg_conf']['css_dir'] . ".css"; $this->sc_tem_trans_banco = false; if (isset($_SESSION['scriptcase']['blank_email_pruebas']['session_timeout']['redir'])) { $SS_cod_html = '<!DOCTYPE html>'; $SS_cod_html .= "<HTML>\r\n"; $SS_cod_html .= " <HEAD>\r\n"; $SS_cod_html .= " <TITLE></TITLE>\r\n"; $SS_cod_html .= " <META http-equiv=\"Content-Type\" content=\"text/html; charset=" . $_SESSION['scriptcase']['charset_html'] . "\"/>\r\n"; if ($_SESSION['scriptcase']['proc_mobile']) { $SS_cod_html .= " <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=0\"/>\r\n"; } $SS_cod_html .= " <META http-equiv=\"Expires\" content=\"Fri, Jan 01 1900 00:00:00 GMT\"/>\r\n"; $SS_cod_html .= " <META http-equiv=\"Pragma\" content=\"no-cache\"/>\r\n"; if ($_SESSION['scriptcase']['blank_email_pruebas']['session_timeout']['redir_tp'] == "R") { $SS_cod_html .= " </HEAD>\r\n"; $SS_cod_html .= " <body>\r\n"; } else { $SS_cod_html .= " <link rel=\"shortcut icon\" href=\"../_lib/img/grp__NM__bg__NM__bus0004.png\">\r\n"; $SS_cod_html .= " <link rel=\"stylesheet\" type=\"text/css\" href=\"../_lib/css/" . $this->str_schema_all . "_grid.css\"/>\r\n"; $SS_cod_html .= " <link rel=\"stylesheet\" type=\"text/css\" href=\"../_lib/css/" . $this->str_schema_all . "_grid" . $_SESSION['scriptcase']['reg_conf']['css_dir'] . ".css\"/>\r\n"; $SS_cod_html .= " </HEAD>\r\n"; $SS_cod_html .= " <body class=\"scGridPage\">\r\n"; $SS_cod_html .= " <table align=\"center\"><tr><td style=\"padding: 0\"><div class=\"scGridBorder\">\r\n"; $SS_cod_html .= " <table class=\"scGridTabela\" width='100%' cellspacing=0 cellpadding=0><tr class=\"scGridFieldOdd\"><td class=\"scGridFieldOddFont\" style=\"padding: 15px 30px; text-align: center\">\r\n"; $SS_cod_html .= $this->Nm_lang['lang_errm_expired_session'] . "\r\n"; $SS_cod_html .= " <form name=\"Fsession_redir\" method=\"post\"\r\n"; $SS_cod_html .= " target=\"_self\">\r\n"; $SS_cod_html .= " <input type=\"button\" name=\"sc_sai_seg\" value=\"OK\" onclick=\"sc_session_redir('" . $_SESSION['scriptcase']['blank_email_pruebas']['session_timeout']['redir'] . "');\">\r\n"; $SS_cod_html .= " </form>\r\n"; $SS_cod_html .= " </td></tr></table>\r\n"; $SS_cod_html .= " </div></td></tr></table>\r\n"; } $SS_cod_html .= " <script type=\"text/javascript\">\r\n"; if ($_SESSION['scriptcase']['blank_email_pruebas']['session_timeout']['redir_tp'] == "R") { $SS_cod_html .= " sc_session_redir('" . $_SESSION['scriptcase']['blank_email_pruebas']['session_timeout']['redir'] . "');\r\n"; } $SS_cod_html .= " function sc_session_redir(url_redir)\r\n"; $SS_cod_html .= " {\r\n"; $SS_cod_html .= " if (window.parent && window.parent.document != window.document && typeof window.parent.sc_session_redir === 'function')\r\n"; $SS_cod_html .= " {\r\n"; $SS_cod_html .= " window.parent.sc_session_redir(url_redir);\r\n"; $SS_cod_html .= " }\r\n"; $SS_cod_html .= " else\r\n"; $SS_cod_html .= " {\r\n"; $SS_cod_html .= " if (window.opener && typeof window.opener.sc_session_redir === 'function')\r\n"; $SS_cod_html .= " {\r\n"; $SS_cod_html .= " window.close();\r\n"; $SS_cod_html .= " window.opener.sc_session_redir(url_redir);\r\n"; $SS_cod_html .= " }\r\n"; $SS_cod_html .= " else\r\n"; $SS_cod_html .= " {\r\n"; $SS_cod_html .= " window.location = url_redir;\r\n"; $SS_cod_html .= " }\r\n"; $SS_cod_html .= " }\r\n"; $SS_cod_html .= " }\r\n"; $SS_cod_html .= " </script>\r\n"; $SS_cod_html .= " </body>\r\n"; $SS_cod_html .= "</HTML>\r\n"; unset($_SESSION['scriptcase']['blank_email_pruebas']['session_timeout']); unset($_SESSION['sc_session']); } if (isset($SS_cod_html) && isset($_GET['nmgp_opcao']) && (substr($_GET['nmgp_opcao'], 0, 14) == "ajax_aut_comp_" || substr($_GET['nmgp_opcao'], 0, 13) == "ajax_autocomp")) { unset($_SESSION['sc_session']); $oJson = new Services_JSON(); echo $oJson->encode("ss_time_out"); exit; } elseif (isset($SS_cod_html) && ((isset($_POST['nmgp_opcao']) && substr($_POST['nmgp_opcao'], 0, 5) == "ajax_") || (isset($_GET['nmgp_opcao']) && substr($_GET['nmgp_opcao'], 0, 5) == "ajax_"))) { unset($_SESSION['sc_session']); $this->Arr_result = array(); $this->Arr_result['ss_time_out'] = true; $oJson = new Services_JSON(); echo $oJson->encode($this->Arr_result); exit; } elseif (isset($SS_cod_html)) { echo $SS_cod_html; exit; } $this->nm_bases_access = array(); $this->nm_bases_db2 = array(); $this->nm_bases_ibase = array(); $this->nm_bases_informix = array(); $this->nm_bases_mssql = array(); $this->nm_bases_mysql = array("mysql", "mysqlt", "mysqli", "maxsql", "pdo_mysql", "pdo_mariadb", "azure_mysql", "azure_mysqlt", "azure_mysqli", "azure_maxsql", "azure_pdo_mysql", "azure_pdo_mariadb", "googlecloud_mysql", "googlecloud_mysqlt", "googlecloud_mysqli", "googlecloud_maxsql", "googlecloud_pdo_mysql", "googlecloud_pdo_mariadb", "amazonrds_mysql", "amazonrds_mysqlt", "amazonrds_mysqli", "amazonrds_maxsql", "amazonrds_pdo_mysql", "amazonrds_pdo_mariadb"); $this->nm_bases_postgres = array(); $this->nm_bases_oracle = array(); $this->sqlite_version = "old"; $this->nm_bases_sqlite = array("sqlite", "sqlite3", "pdosqlite"); $this->nm_bases_sybase = array(); $this->nm_bases_vfp = array(); $this->nm_bases_odbc = array(); $this->nm_bases_progress = array(); $this->nm_bases_all = array_merge($this->nm_bases_mysql, $this->nm_bases_sqlite); $this->nm_font_ttf = array("ar", "ja", "pl", "ru", "sk", "thai", "zh_cn", "zh_hk", "cz", "el", "ko", "mk"); $this->nm_ttf_arab = array("ar"); $this->nm_ttf_jap = array("ja"); $this->nm_ttf_rus = array("pl", "ru", "sk", "cz", "el", "mk"); $this->nm_ttf_thai = array("thai"); $this->nm_ttf_chi = array("zh_cn", "zh_hk", "ko"); $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['seq_dir'] = 0; $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['sub_dir'] = array(); $_SESSION['scriptcase']['nm_bases_security'] = "enc_nm_enc_v1HQJKZ9F7HABYVWBODMvmVcBODWFaDoJsDcBqZkFGZ1NOV5XGDMBYVkJqDWFqHMX7D9NmDQFaD1BeHuFaHuNOZSrCH5FqDoXGHQJmZ1BiHAN7HQJwDEBODkFeH5FYVoFGHQJKDQB/HAN7HuFGDMvOV9FeDWFYHIFUHQXGH9B/DSvOD5XGDMBYHEJqDWX7HIFGHQXOZSFGHAveHuFaHuNOZSrCH5FqDoXGHQJmZ1rqHArKV5FaDMNKZSXeV5FqZuXGD9NwZSFGHArYD5rqHgrYDkBODWJeVoX7D9BsH9B/Z1NOZMJwDMzGHArCDWF/VoBiDcJUZSX7Z1BYHuFaDMrwDkBODWJeDoJeDcBqZ1B/Z1NOV5JsDMNKZSXeDWFqVoFGDcJeDQX7DSBYD5rqHgrYDkFCDWXCVoX7D9BiZ1B/HArYD5F7DMBYHEJGH5X/VoBiD9NwDQJsHIrKV5JeDMvmVcFKV5BmVoBqD9BsZkFGHAvsD5XGHgrKHArsDuJeDoraD9JKDQFaZ1rwV5FaDMBYDkBsV5X/VoX7DcJUZSBOHArKHQBODMveHErCDWFqDoBOHQJKDQJsZ1vCV5FGHuNOV9FeDWXCHIF7HQBqZSBqHAN7HQF7HgBYHErCHEFaHIBOHQXGDQFUHAN7HuFUHgrwVIB/H5XCHMX7HQFYZkFGD1NaZMB/HgvsHErsDWr/HMFaHQXGDuBqDSzGVWBqDMrYDkB/DuX7HIF7DcBwH9B/HIrwV5JeDMBYDkBsH5FYHIrqHQJeH9BiHAN7HQJsDMNODkB/DuFGVEraHQFYZ1BOHArYHQBqHgBYHEJqHEXCHMJsHQXGDuFaHABYHQB/DMNOVIBsDWFaHIF7HQFYZ1BOHArKHQX7HgBOZSJqHEB7ZuB/DcJUZSX7HIBeD5BqHgvsZSJ3H5FqHMBqHQBqZSBOHIveHQBqHgNOVkJ3DWFqHMJeHQXGDuFaHABYHuF7DMBOZSJqH5FqHIFUHQFYZkFGDSBeHQBqHgNKZSJ3V5XCHMBOHQXGDuBqD1BeHQJsDMzGVcBUHEFYHINUDcBwH9B/HIrwV5JeDMBYDkBsH5FYDoXGDcJeZSFUZ1rwV5JeHgvsVcFCH5XCDoX7DcNwH9BqD1NaZMJwHgvCZSJqDWF/DoJeD9XsZSX7HIrwV5BOHgvsVcBOV5X/VoFaHQBsZSB/DSrYV5FGDMzGHEJGH5X/DoB/HQNmH9X7HABYVWJsDMBYVcBODWFaDoFUDcJUZkFUZ1BeZMBqHgBYHAFKV5FqDoBOD9JKDQJwHANKVWBODMvOV9FiV5X7VEF7D9BiH9FaHIBeD5XGDEBOZSXeV5FaZuFaHQXGZSFGD1BeV5FGHuzGVIBOHEFYVorqD9BiZ1F7D1rwD5NUDErKZSXeH5FGDoB/DcJUZSX7HIBeD5BqHgvsZSJ3H5FqVoFGDcBqH9BOZ1BeV5XGDEBOZSJGH5FYZuFaDcXOZSBiD1veHuraDMBODkBsHEX7HIJsHQBiH9BOHAvsV5X7HgvsDkXKDWX7HMFaHQJeDuFaHIrwHurqDMNOV9FeDWXCDoJsDcBwH9B/Z1rYHQJwHgveDkXKDWBmDoJeHQXODuBqHAvOV5BODMvOZSNiH5XCHMBiD9BsVIraD1rwV5X7HgBeHEBUDuJeHMFaDcXGDQJsZ1vCV5XGDMBYVcBOH5XCVoFGHQBsZSB/Z1rYHQJwDEBODkFeH5FYVoFGHQJKDQJsZ1N7D5JwHuNOVcrsH5FqVoraD9BsVIraZ1NOD5XGDEBOZSXeH5F/DoraD9NwZSBiHAveD5XGHuNOVcBODWFaDoFGD9BsZ1FUZ1NOD5rqDEBOZSXeV5FqHIJsD9XsZ9JeD1BeD5F7DMvmVcBUHEX/DoJsHQNmZ1XGZ1veZMNU"; $this->prep_conect(); $this->conectDB(); if (!in_array(strtolower($this->nm_tpbanco), $this->nm_bases_all)) { echo "<tr>"; echo " <td bgcolor=\"\">"; echo " <b><font size=\"4\">" . $this->Nm_lang['lang_errm_dbcn_nspt'] . "</font>"; echo " " . $perfil_trab; echo " </b></td>"; echo " </tr>"; echo "</table>"; if (!$_SESSION['sc_session'][$script_case_init]['blank_email_pruebas']['iframe_menu'] && (!isset($_SESSION['sc_session'][$script_case_init]['blank_email_pruebas']['sc_outra_jan']) || !$_SESSION['sc_session'][$script_case_init]['blank_email_pruebas']['sc_outra_jan'])) { if (isset($_SESSION['scriptcase']['nm_sc_retorno']) && !empty($_SESSION['scriptcase']['nm_sc_retorno'])) { echo "<a href='" . $_SESSION['scriptcase']['nm_sc_retorno'] . "' target='_self'><img border='0' src='" . $this->path_botoes . "/nm_Scriptcase7_BlueSky_bvoltar.gif' title='" . $this->Nm_lang['lang_btns_rtrn_scrp_hint'] . "' align=absmiddle></a> \n" ; } else { echo "<a href='$nm_url_saida' target='_self'><img border='0' src='" . $this->path_botoes . "/nm_Scriptcase7_BlueSky_bsair.gif' title='" . $this->Nm_lang['lang_btns_exit_appl_hint'] . "' align=absmiddle></a> \n" ; } } exit ; } if (empty($this->nm_tabela)) { $this->nm_tabela = ""; } $this->Nm_accent_mysql = array('cmp_i'=>"",'cmp_f'=>"",'cmp_apos'=>"",'arg_i'=>"",'arg_f'=>"",'arg_apos'=>""); $this->Nm_accent_sqlite = array('cmp_i'=>"",'cmp_f'=>"",'cmp_apos'=>"",'arg_i'=>"",'arg_f'=>"",'arg_apos'=>""); $this->Nm_accent_no = array('cmp_i'=>'','cmp_f'=>'','cmp_apos'=>'','arg_i'=>'','arg_f'=>'','arg_apos'=>''); if (in_array(strtolower($this->nm_tpbanco), $this->nm_bases_mysql)) { $this->Nm_accent_yes = $this->Nm_accent_mysql; } elseif (in_array(strtolower($this->nm_tpbanco), $this->nm_bases_sqlite)) { $this->Nm_accent_yes = $this->Nm_accent_sqlite; } else { $this->Nm_accent_yes = $this->Nm_accent_no; } } function getRunningOS() { $aOSInfo = array(); if (FALSE !== strpos(strtolower(php_uname()), 'windows')) { $aOSInfo['os'] = 'win'; } elseif (FALSE !== strpos(strtolower(php_uname()), 'linux')) { $aOSInfo['os'] = 'linux-i386'; if(strpos(strtolower(php_uname()), 'x86_64') !== FALSE) { $aOSInfo['os'] = 'linux-amd64'; } } elseif (FALSE !== strpos(strtolower(php_uname()), 'darwin')) { $aOSInfo['os'] = 'macos'; } return $aOSInfo; } function scGetTippyCssTheme(&$themeList, $themeName) { if (isset($themeList[$themeName])) { return; } $themeNameParts = explode('__NM__', $themeName); $themeList[$themeName] = [ 'tippy' => $themeNameParts[1], 'file' => '../_lib/freecss/' . $themeName . '.css' ]; } function prep_conect() { if (isset($_SESSION['scriptcase']['sc_connection']) && !empty($_SESSION['scriptcase']['sc_connection'])) { foreach ($_SESSION['scriptcase']['sc_connection'] as $NM_con_orig => $NM_con_dest) { if (isset($_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_conexao']) && $_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_conexao'] == $NM_con_orig) { /*NM*/ $_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_conexao'] = $NM_con_dest; } if (isset($_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_perfil']) && $_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_perfil'] == $NM_con_orig) { /*NM*/ $_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_perfil'] = $NM_con_dest; } if (isset($_SESSION['scriptcase']['blank_email_pruebas']['glo_con_' . $NM_con_orig])) { $_SESSION['scriptcase']['blank_email_pruebas']['glo_con_' . $NM_con_orig] = $NM_con_dest; } } } $con_devel = (isset($_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_conexao'])) ? $_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_conexao'] : ""; $perfil_trab = ""; $this->nm_falta_var = ""; $this->nm_falta_var_db = ""; $nm_crit_perfil = false; if (isset($_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_conexao']) && !empty($_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_conexao'])) { if (!isset($_GET['nmgp_opcao']) || ('pdf' != $_GET['nmgp_opcao'] && 'pdf_res' != $_GET['nmgp_opcao'])) { ob_start(); } else { @ini_set('zlib.output_compression',0); $bufferSize = @ini_get('output_buffering'); if ('' != $bufferSize) { $bufferSize = min($bufferSize * 10, 65536); echo str_repeat(' ', $bufferSize); } } db_conect_devel($con_devel, $this->root . $this->path_prod, 'GorbusWeb', 2, $this->force_db_utf8); if (!isset($this->Ajax_result_set)) {$this->Ajax_result_set = ob_get_contents();} ob_end_clean(); if (empty($_SESSION['scriptcase']['glo_tpbanco']) && empty($_SESSION['scriptcase']['glo_banco'])) { $nm_crit_perfil = true; } } if (isset($_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_perfil']) && !empty($_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_perfil'])) { $perfil_trab = $_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_perfil']; } elseif (isset($_SESSION['scriptcase']['glo_perfil']) && !empty($_SESSION['scriptcase']['glo_perfil'])) { $perfil_trab = $_SESSION['scriptcase']['glo_perfil']; } if (!empty($perfil_trab)) { $_SESSION['scriptcase']['glo_senha_protect'] = ""; carrega_perfil($perfil_trab, $this->path_libs, "S", $this->path_conf); if (empty($_SESSION['scriptcase']['glo_senha_protect'])) { $nm_crit_perfil = true; } } else { $perfil_trab = $con_devel; } if (!isset($_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['embutida_init']) || !$_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['embutida_init']) { if (!isset($_SESSION['usr_perfil'])) { $this->nm_falta_var .= "usr_perfil; "; } if (!isset($_SESSION['idempresa'])) { $this->nm_falta_var .= "idempresa; "; } } // if (!isset($_SESSION['scriptcase']['glo_tpbanco'])) { if (!$nm_crit_perfil) { $this->nm_falta_var_db .= "glo_tpbanco; "; } } else { $this->nm_tpbanco = $_SESSION['scriptcase']['glo_tpbanco']; } if (!isset($_SESSION['scriptcase']['glo_servidor'])) { if (!$nm_crit_perfil) { $this->nm_falta_var_db .= "glo_servidor; "; } } else { $this->nm_servidor = $_SESSION['scriptcase']['glo_servidor']; } if (!isset($_SESSION['scriptcase']['glo_banco'])) { if (!$nm_crit_perfil) { $this->nm_falta_var_db .= "glo_banco; "; } } else { $this->nm_banco = $_SESSION['scriptcase']['glo_banco']; } if (!isset($_SESSION['scriptcase']['glo_usuario'])) { if (!$nm_crit_perfil) { $this->nm_falta_var_db .= "glo_usuario; "; } } else { $this->nm_usuario = $_SESSION['scriptcase']['glo_usuario']; } if (!isset($_SESSION['scriptcase']['glo_senha'])) { if (!$nm_crit_perfil) { $this->nm_falta_var_db .= "glo_senha; "; } } else { $this->nm_senha = $_SESSION['scriptcase']['glo_senha']; } if (isset($_SESSION['scriptcase']['glo_database_encoding'])) { $this->nm_database_encoding = $_SESSION['scriptcase']['glo_database_encoding']; } $this->nm_arr_db_extra_args = array(); if (isset($_SESSION['scriptcase']['glo_use_ssl'])) { $this->nm_arr_db_extra_args['use_ssl'] = $_SESSION['scriptcase']['glo_use_ssl']; } if (isset($_SESSION['scriptcase']['glo_mysql_ssl_key'])) { $this->nm_arr_db_extra_args['mysql_ssl_key'] = $_SESSION['scriptcase']['glo_mysql_ssl_key']; } if (isset($_SESSION['scriptcase']['glo_mysql_ssl_cert'])) { $this->nm_arr_db_extra_args['mysql_ssl_cert'] = $_SESSION['scriptcase']['glo_mysql_ssl_cert']; } if (isset($_SESSION['scriptcase']['glo_mysql_ssl_capath'])) { $this->nm_arr_db_extra_args['mysql_ssl_capath'] = $_SESSION['scriptcase']['glo_mysql_ssl_capath']; } if (isset($_SESSION['scriptcase']['glo_mysql_ssl_ca'])) { $this->nm_arr_db_extra_args['mysql_ssl_ca'] = $_SESSION['scriptcase']['glo_mysql_ssl_ca']; } if (isset($_SESSION['scriptcase']['glo_mysql_ssl_cipher'])) { $this->nm_arr_db_extra_args['mysql_ssl_cipher'] = $_SESSION['scriptcase']['glo_mysql_ssl_cipher']; } if (isset($_SESSION['scriptcase']['use_ssh'])) { $this->nm_arr_db_extra_args['use_ssh'] = $_SESSION['scriptcase']['use_ssh']; } if (isset($_SESSION['scriptcase']['ssh_server'])) { $this->nm_arr_db_extra_args['ssh_server'] = $_SESSION['scriptcase']['ssh_server']; } if (isset($_SESSION['scriptcase']['ssh_user'])) { $this->nm_arr_db_extra_args['ssh_user'] = $_SESSION['scriptcase']['ssh_user']; } if (isset($_SESSION['scriptcase']['ssh_port'])) { $this->nm_arr_db_extra_args['ssh_port'] = $_SESSION['scriptcase']['ssh_port']; } if (isset($_SESSION['scriptcase']['ssh_privatecert'])) { $this->nm_arr_db_extra_args['ssh_privatecert'] = $_SESSION['scriptcase']['ssh_privatecert']; } if (isset($_SESSION['scriptcase']['ssh_localserver'])) { $this->nm_arr_db_extra_args['ssh_localserver'] = $_SESSION['scriptcase']['ssh_localserver']; } if (isset($_SESSION['scriptcase']['ssh_localport'])) { $this->nm_arr_db_extra_args['ssh_localport'] = $_SESSION['scriptcase']['ssh_localport']; } if (isset($_SESSION['scriptcase']['ssh_localportforwarding'])) { $this->nm_arr_db_extra_args['ssh_localportforwarding'] = $_SESSION['scriptcase']['ssh_localportforwarding']; } if (isset($_SESSION['scriptcase']['glo_use_persistent'])) { $this->nm_con_persistente = $_SESSION['scriptcase']['glo_use_persistent']; } if (isset($_SESSION['scriptcase']['glo_use_schema'])) { $this->nm_con_use_schema = $_SESSION['scriptcase']['glo_use_schema']; } $this->date_delim = "'"; $this->date_delim1 = "'"; if (isset($_SESSION['scriptcase']['glo_decimal_db']) && !empty($_SESSION['scriptcase']['glo_decimal_db'])) { $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['decimal_db'] = $_SESSION['scriptcase']['glo_decimal_db']; } if (isset($_SESSION['scriptcase']['glo_date_separator']) && !empty($_SESSION['scriptcase']['glo_date_separator'])) { $SC_temp = trim($_SESSION['scriptcase']['glo_date_separator']); if (strlen($SC_temp) == 2) { $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['SC_sep_date'] = substr($SC_temp, 0, 1); $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['SC_sep_date1'] = substr($SC_temp, 1, 1); } else { $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['SC_sep_date'] = $SC_temp; $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['SC_sep_date1'] = $SC_temp; } $this->date_delim = $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['SC_sep_date']; $this->date_delim1 = $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['SC_sep_date1']; } // if (!empty($this->nm_falta_var) || !empty($this->nm_falta_var_db) || $nm_crit_perfil) { $str_message = "<html> <head> <title>{var_str_title}</title> <style> body { margin: 0px; padding: 0px; overflow-x: hidden; min-width: 320px; background: #FFFFFF; font-family: 'Lato', 'Helvetica Neue', Arial, Helvetica, sans-serif; font-size: 14px; line-height: 1.4285em; color: rgba(0, 0, 0, 0.87); font-smoothing: antialiased; } html, body { height: 100%; } body { margin: 0; } *, *:before, *:after { box-sizing: inherit; } user agent stylesheet body { display: block; margin: 8px; } html { font-size: 14px; } html { line-height: 1.15; -ms-text-size-adjust: 100%; -webkit-text-size-adjust: 100%; } *, *:before, *:after { box-sizing: inherit; } *, *:before, *:after { box-sizing: inherit; } ::selection { background-color: #CCE2FF; color: rgba(0, 0, 0, 0.87); } .ui.container { width: 933px; min-width: 992px; max-width: 1199px; margin-left: auto !important; margin-right: auto !important; } .ui.container { display: block; max-width: 100% !important; } *, *:before, *:after { box-sizing: inherit; } .ui.message:last-child { margin-bottom: 0em; } .ui.message:first-child { margin-top: 0em; } .ui.message { font-size: 1em; } .ui.message { position: relative; min-height: 1em; margin: 1em 0em; background: #F8F8F9; padding: 1em 1.5em; line-height: 1.4285em; color: rgba(0, 0, 0, 0.87); transition: opacity 0.1s ease, color 0.1s ease, background 0.1s ease, box-shadow 0.1s ease; border-radius: 0.28571429rem; box-shadow: 0px 0px 0px 1px rgba(34, 36, 38, 0.22) inset, 0px 0px 0px 0px rgba(0, 0, 0, 0); } article, aside, footer, header, nav, section { display: block; } *, *:before, *:after { box-sizing: inherit; } .ui.message> :last-child { margin-bottom: 0em; } .ui.message> :first-child { margin-top: 0em; } .ui.message .header+p { margin-top: 0.25em; } .ui.message p { opacity: 0.85; margin: 0.75em 0em; } p { margin: 0em 0em 1em; line-height: 1.4285em; } .ui.message .header:not(.ui) { font-size: 1.14285714em; } .ui.message .header { display: block; font-family: 'Lato', 'Helvetica Neue', Arial, Helvetica, sans-serif; font-weight: bold; margin: -0.14285714em 0em 1.2rem 0em; } .ui.button { cursor: pointer; display: inline-block; min-height: 1em; outline: 0; border: none; vertical-align: baseline; background: #e0e1e2 none; color: rgba(0, 0, 0, .6); font-family: Lato, 'Helvetica Neue', Arial, Helvetica, sans-serif; margin: 0 .25em 0 0; padding: .78571429em 1.5em .78571429em; text-transform: none; text-shadow: none; font-weight: 700; line-height: 1em; font-style: normal; text-align: center; text-decoration: none; border-radius: .28571429rem; box-shadow: 0 0 0 1px transparent inset, 0 0 0 0 rgba(34, 36, 38, .15) inset; -webkit-user-select: none; -moz-user-select: none; -ms-user-select: none; user-select: none; transition: opacity .1s ease, background-color .1s ease, color .1s ease, box-shadow .1s ease, background .1s ease; will-change: ''; -webkit-tap-highlight-color: transparent; } .ui.button, .ui.buttons .button, .ui.buttons .or { font-size: 1rem; flex-flow: row nowrap; justify-content: center; align-items: center; column-gap: .5rem; display: flex; } .ui.primary.button, .ui.primary.buttons .button { background-color: #2185d0; color: #fff; text-shadow: none; background-image: none; } .ui.primary.button { box-shadow: 0 0 0 0 rgba(34, 36, 38, .15) inset; } [type=reset], [type=submit], button, html [type=button] { -webkit-appearance: button; } .icon{ position: relative; width: 1.2rem; height: 1.2rem; display: block; color: inherit; background-repeat: no-repeat; } .icon.database{ background-image: url('data:image/svg+xml,<svg xmlns=\"http://www.w3.org/2000/svg\" viewBox=\"0 0 448 512\" fill=\"%23FFFFFF\"><path d=\"M448 80v48c0 44.2-100.3 80-224 80S0 172.2 0 128V80C0 35.8 100.3 0 224 0S448 35.8 448 80zM393.2 214.7c20.8-7.4 39.9-16.9 54.8-28.6V288c0 44.2-100.3 80-224 80S0 332.2 0 288V186.1c14.9 11.8 34 21.2 54.8 28.6C99.7 230.7 159.5 240 224 240s124.3-9.3 169.2-25.3zM0 346.1c14.9 11.8 34 21.2 54.8 28.6C99.7 390.7 159.5 400 224 400s124.3-9.3 169.2-25.3c20.8-7.4 39.9-16.9 54.8-28.6V432c0 44.2-100.3 80-224 80S0 476.2 0 432V346.1z\"/></svg>'); } </style> </head> <body> <div class='ui container' style='padding-top:2rem'> <section class='ui message'> <div class='content'> <div class='header'> <h1 class='ui header'>{var_str_title}</h1> </div> <p>{var_str_message}</p> <p>{var_str_message_conn}</p> {v_str_btn_inside} </div> </section> </div>"; $str_message_end = "</body> </html>"; $str_message = str_replace('{var_str_title}', $this->Nm_lang['lang_errm_dbcn_create'], $str_message); if (empty($this->nm_falta_var_db)) { if (!empty($this->nm_falta_var)) { $str_message = str_replace('{var_str_message}', $this->Nm_lang['lang_errm_glob'] . $this->nm_falta_var, $str_message); $str_message = str_replace('{var_str_message_conn}','', $str_message); } elseif ($nm_crit_perfil) { $str_message = str_replace('{var_str_message}', $this->Nm_lang['lang_errm_dbcn_nfnd'], $str_message); $str_message = str_replace('{var_str_message_conn}', $this->Nm_lang['lang_errm_dbcn_conn_nfnd'] . ' ' . $perfil_trab, $str_message); $str_message = str_replace('{v_str_btn_inside}', "<button class='ui button primary' style='font-size: 16px !important;'><a href='" . $this->path_prod . "' style='color: white;text-decoration:none'><i class='icon database' style='float: left;padding-right: .5rem;'></i>". $this->Nm_lang['lang_errm_dbcn_create'] ."</a></button>", $str_message); } } else { $str_message = str_replace('{var_str_message}', $this->Nm_lang['lang_errm_dbcn_data'], $str_message); } $str_message = str_replace('{var_str_message_conn}','', $str_message); $str_message = str_replace('{v_str_btn_inside}', '', $str_message); echo $str_message; if (!$_SESSION['sc_session'][$script_case_init]['blank_email_pruebas']['iframe_menu'] && (!isset($_SESSION['sc_session'][$script_case_init]['blank_email_pruebas']['sc_outra_jan']) || !$_SESSION['sc_session'][$script_case_init]['blank_email_pruebas']['sc_outra_jan'])) { if (isset($_SESSION['scriptcase']['nm_sc_retorno']) && !empty($_SESSION['scriptcase']['nm_sc_retorno'])) { $btn_value = "" . $this->Ini->Nm_lang['lang_btns_back'] . ""; if ($_SESSION['scriptcase']['charset'] != "UTF-8" && NM_is_utf8($btn_value)) { $btn_value = sc_convert_encoding($btn_value, $_SESSION['scriptcase']['charset'], "UTF-8"); } $btn_hint = "" . $this->Ini->Nm_lang['lang_btns_back_hint'] . ""; if ($_SESSION['scriptcase']['charset'] != "UTF-8" && NM_is_utf8($btn_hint)) { $btn_hint = sc_convert_encoding($btn_hint, $_SESSION['scriptcase']['charset'], "UTF-8"); } ?> <input type="button" id="sai" onClick="window.location='<?php echo $_SESSION['scriptcase']['nm_sc_retorno'] ?>'; return false" class="scButton_default" value="<?php echo $btn_value ?>" title="<?php echo $btn_hint ?>" style="vertical-align: middle;"> <?php } elseif(!empty($nm_url_saida)) { $btn_value = "" . $this->Ini->Nm_lang['lang_btns_exit'] . ""; if ($_SESSION['scriptcase']['charset'] != "UTF-8" && NM_is_utf8($btn_value)) { $btn_value = sc_convert_encoding($btn_value, $_SESSION['scriptcase']['charset'], "UTF-8"); } $btn_hint = "" . $this->Ini->Nm_lang['lang_btns_exit_hint'] . ""; if ($_SESSION['scriptcase']['charset'] != "UTF-8" && NM_is_utf8($btn_hint)) { $btn_hint = sc_convert_encoding($btn_hint, $_SESSION['scriptcase']['charset'], "UTF-8"); } ?> <input type="button" id="sai" onClick="window.location='<?php echo $nm_url_saida ?>'; return false" class="scButton_default" value="<?php echo $btn_value ?>" title="<?php echo $btn_hint ?>" style="vertical-align: middle;"> <?php } } echo $str_message_end; exit ; } if (isset($_SESSION['scriptcase']['glo_db_master_usr']) && !empty($_SESSION['scriptcase']['glo_db_master_usr'])) { $this->nm_usuario = $_SESSION['scriptcase']['glo_db_master_usr']; } if (isset($_SESSION['scriptcase']['glo_db_master_pass']) && !empty($_SESSION['scriptcase']['glo_db_master_pass'])) { $this->nm_senha = $_SESSION['scriptcase']['glo_db_master_pass']; } if (isset($_SESSION['scriptcase']['glo_db_master_cript']) && !empty($_SESSION['scriptcase']['glo_db_master_cript'])) { $_SESSION['scriptcase']['glo_senha_protect'] = $_SESSION['scriptcase']['glo_db_master_cript']; } } function conectDB() { global $glo_senha_protect; $glo_senha_protect = (isset($_SESSION['scriptcase']['glo_senha_protect'])) ? $_SESSION['scriptcase']['glo_senha_protect'] : "S"; if (isset($_SESSION['scriptcase']['nm_sc_retorno']) && !empty($_SESSION['scriptcase']['nm_sc_retorno']) && isset($_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_conexao']) && !empty($_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_conexao'])) { $this->Db = db_conect_devel($_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_conexao'], $this->root . $this->path_prod, 'GorbusWeb', 1, $this->force_db_utf8); } else { ob_start(); $databaseEncoding = $this->force_db_utf8 ? 'utf8' : $this->nm_database_encoding; $this->Db = db_conect($this->nm_tpbanco, $this->nm_servidor, $this->nm_usuario, $this->nm_senha, $this->nm_banco, $glo_senha_protect, "S", $this->nm_con_persistente, $this->nm_con_db2, $databaseEncoding, $this->nm_arr_db_extra_args); if (!isset($this->Ajax_result_set)) {$this->Ajax_result_set = ob_get_contents();} ob_end_clean(); } if (!isset($_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['embutida']) || !$_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['embutida']) { if (substr($_POST['nmgp_opcao'], 0, 5) == "ajax_") { ob_start(); } } if (!isset($_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['embutida']) || !$_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['embutida']) { if (substr($_POST['nmgp_opcao'], 0, 5) == "ajax_") { ob_end_clean(); } } } function regionalDefault() { $_SESSION['scriptcase']['reg_conf']['date_format'] = (isset($this->Nm_conf_reg[$this->str_conf_reg]['data_format'])) ? $this->Nm_conf_reg[$this->str_conf_reg]['data_format'] : "ddmmyyyy"; $_SESSION['scriptcase']['reg_conf']['date_sep'] = (isset($this->Nm_conf_reg[$this->str_conf_reg]['data_sep'])) ? $this->Nm_conf_reg[$this->str_conf_reg]['data_sep'] : "/"; $_SESSION['scriptcase']['reg_conf']['date_week_ini'] = (isset($this->Nm_conf_reg[$this->str_conf_reg]['prim_dia_sema'])) ? $this->Nm_conf_reg[$this->str_conf_reg]['prim_dia_sema'] : "SU"; $_SESSION['scriptcase']['reg_conf']['time_format'] = (isset($this->Nm_conf_reg[$this->str_conf_reg]['hora_format'])) ? $this->Nm_conf_reg[$this->str_conf_reg]['hora_format'] : "hhiiss"; $_SESSION['scriptcase']['reg_conf']['time_sep'] = (isset($this->Nm_conf_reg[$this->str_conf_reg]['hora_sep'])) ? $this->Nm_conf_reg[$this->str_conf_reg]['hora_sep'] : ":"; $_SESSION['scriptcase']['reg_conf']['time_pos_ampm'] = (isset($this->Nm_conf_reg[$this->str_conf_reg]['hora_pos_ampm'])) ? $this->Nm_conf_reg[$this->str_conf_reg]['hora_pos_ampm'] : "right_without_space"; $_SESSION['scriptcase']['reg_conf']['time_simb_am'] = (isset($this->Nm_conf_reg[$this->str_conf_reg]['hora_simbolo_am'])) ? $this->Nm_conf_reg[$this->str_conf_reg]['hora_simbolo_am'] : "am"; $_SESSION['scriptcase']['reg_conf']['time_simb_pm'] = (isset($this->Nm_conf_reg[$this->str_conf_reg]['hora_simbolo_pm'])) ? $this->Nm_conf_reg[$this->str_conf_reg]['hora_simbolo_pm'] : "pm"; $_SESSION['scriptcase']['reg_conf']['simb_neg'] = (isset($this->Nm_conf_reg[$this->str_conf_reg]['num_sinal_neg'])) ? $this->Nm_conf_reg[$this->str_conf_reg]['num_sinal_neg'] : "-"; $_SESSION['scriptcase']['reg_conf']['grup_num'] = (isset($this->Nm_conf_reg[$this->str_conf_reg]['num_sep_agr'])) ? $this->Nm_conf_reg[$this->str_conf_reg]['num_sep_agr'] : "."; $_SESSION['scriptcase']['reg_conf']['dec_num'] = (isset($this->Nm_conf_reg[$this->str_conf_reg]['num_sep_dec'])) ? $this->Nm_conf_reg[$this->str_conf_reg]['num_sep_dec'] : ","; $_SESSION['scriptcase']['reg_conf']['neg_num'] = (isset($this->Nm_conf_reg[$this->str_conf_reg]['num_format_num_neg'])) ? $this->Nm_conf_reg[$this->str_conf_reg]['num_format_num_neg'] : 2; $_SESSION['scriptcase']['reg_conf']['monet_simb'] = (isset($this->Nm_conf_reg[$this->str_conf_reg]['unid_mont_simbolo'])) ? $this->Nm_conf_reg[$this->str_conf_reg]['unid_mont_simbolo'] : "$"; $_SESSION['scriptcase']['reg_conf']['monet_f_pos'] = (isset($this->Nm_conf_reg[$this->str_conf_reg]['unid_mont_format_num_pos'])) ? $this->Nm_conf_reg[$this->str_conf_reg]['unid_mont_format_num_pos'] : 3; $_SESSION['scriptcase']['reg_conf']['monet_f_neg'] = (isset($this->Nm_conf_reg[$this->str_conf_reg]['unid_mont_format_num_neg'])) ? $this->Nm_conf_reg[$this->str_conf_reg]['unid_mont_format_num_neg'] : 13; $_SESSION['scriptcase']['reg_conf']['grup_val'] = (isset($this->Nm_conf_reg[$this->str_conf_reg]['unid_mont_sep_agr'])) ? $this->Nm_conf_reg[$this->str_conf_reg]['unid_mont_sep_agr'] : "."; $_SESSION['scriptcase']['reg_conf']['dec_val'] = (isset($this->Nm_conf_reg[$this->str_conf_reg]['unid_mont_sep_dec'])) ? $this->Nm_conf_reg[$this->str_conf_reg]['unid_mont_sep_dec'] : ","; $_SESSION['scriptcase']['reg_conf']['html_dir'] = (isset($this->Nm_conf_reg[$this->str_conf_reg]['ger_ltr_rtl'])) ? " DIR='" . $this->Nm_conf_reg[$this->str_conf_reg]['ger_ltr_rtl'] . "'" : ""; $_SESSION['scriptcase']['reg_conf']['css_dir'] = (isset($this->Nm_conf_reg[$this->str_conf_reg]['ger_ltr_rtl'])) ? $this->Nm_conf_reg[$this->str_conf_reg]['ger_ltr_rtl'] : "LTR"; $_SESSION['scriptcase']['reg_conf']['num_group_digit'] = (isset($this->Nm_conf_reg[$this->str_conf_reg]['num_group_digit'])) ? $this->Nm_conf_reg[$this->str_conf_reg]['num_group_digit'] : "1"; $_SESSION['scriptcase']['reg_conf']['unid_mont_group_digit'] = (isset($this->Nm_conf_reg[$this->str_conf_reg]['unid_mont_group_digit'])) ? $this->Nm_conf_reg[$this->str_conf_reg]['unid_mont_group_digit'] : "1"; } // function scCsrfGetToken() { if (!isset($_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['csrf_token'])) { $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['csrf_token'] = $this->scCsrfGenerateToken(); } return $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['csrf_token']; } function scCsrfGenerateToken() { $aSources = array( 'abcdefghijklmnopqrstuvwxyz', 'ABCDEFGHIJKLMNOPQRSTUVWXYZ', '1234567890', '!@$*()-_[]{},.;:' ); $sRandom = ''; $aSourcesSizes = array(); $iSourceSize = sizeof($aSources) - 1; for ($i = 0; $i <= $iSourceSize; $i++) { $aSourcesSizes[$i] = strlen($aSources[$i]) - 1; } for ($i = 0; $i < 64; $i++) { $iSource = $this->scCsrfRandom(0, $iSourceSize); $sRandom .= substr($aSources[$iSource], $this->scCsrfRandom(0, $aSourcesSizes[$iSource]), 1); } return $sRandom; } function scCsrfRandom($iMin, $iMax) { return mt_rand($iMin, $iMax); } function sc_Include($path, $tp, $name) { if ((empty($tp) && empty($name)) || ($tp == "F" && !function_exists($name)) || ($tp == "C" && !class_exists($name))) { include_once($path); } } // sc_Include function sc_Sql_Protect($var, $tp, $conex="") { if (empty($conex) || $conex == "conn_mysql") { $TP_banco = $_SESSION['scriptcase']['glo_tpbanco']; } else { eval ("\$TP_banco = \$this->nm_con_" . $conex . "['tpbanco'];"); } if ($tp == "date") { $delim = "'"; $delim1 = "'"; if (isset($_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['SC_sep_date']) && !empty($_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['SC_sep_date'])) { $delim = $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['SC_sep_date']; $delim1 = $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['SC_sep_date1']; } return $delim . $var . $delim1; } else { return $var; } } // sc_Sql_Protect function sc_Date_Protect($val_dt) { $dd = substr($val_dt, 8, 2); $mm = substr($val_dt, 5, 2); $yy = substr($val_dt, 0, 4); $hh = (strlen($val_dt) > 10) ? substr($val_dt, 10) : ""; if ($mm > 12) { $mm = 12; } $dd_max = 31; if ($mm == '04' || $mm == '06' || $mm == '09' || $mm == 11) { $dd_max = 30; } if ($mm == '02') { $dd_max = ($yy % 4 == 0) ? 29 : 28; } if ($dd > $dd_max) { $dd = $dd_max; } return $yy . "-" . $mm . "-" . $dd . $hh; } function appIsSsl() { if (isset($_SERVER['HTTPS'])) { if ('on' == strtolower($_SERVER['HTTPS'])) { return true; } if ('1' == $_SERVER['HTTPS']) { return true; } } if (isset($_SERVER['REQUEST_SCHEME'])) { if ('https' == $_SERVER['REQUEST_SCHEME']) { return true; } } if (isset($_SERVER['SERVER_PORT'])) { if ('443' == $_SERVER['SERVER_PORT']) { return true; } } return false; } function Get_Gb_date_format($GB, $cmp) { return (isset($_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['SC_Gb_date_format'][$GB][$cmp])) ? $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['SC_Gb_date_format'][$GB][$cmp] : ""; } function Get_Gb_prefix_date_format($GB, $cmp) { return (isset($_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['SC_Gb_prefix_date_format'][$GB][$cmp])) ? $_SESSION['sc_session'][$this->sc_page]['blank_email_pruebas']['SC_Gb_prefix_date_format'][$GB][$cmp] : ""; } function GB_date_format($val, $format, $prefix="", $conf_region="S", $mask="") { return $val; } function Get_arg_groupby($val, $format) { return $val; } function Get_format_dimension($ind_ini, $ind_qb, $campo, $rs, $conf_region="S", $mask="") { $retorno = array(); $format = $this->Get_Gb_date_format($ind_qb, $campo); $Prefix_dat = $this->Get_Gb_prefix_date_format($ind_qb, $campo); if (empty($format) || $rs->fields[$ind_ini] == "") { $retorno['orig'] = $rs->fields[$ind_ini]; $retorno['fmt'] = $rs->fields[$ind_ini]; return $retorno; } if ($format == 'YYYYMMDDHHIISS') { $retorno['orig'] = $rs->fields[$ind_ini]; $retorno['fmt'] = $this->GB_date_format($rs->fields[$ind_ini], $format, $Prefix_dat, $conf_region, $mask); return $retorno; } if ($format == 'YYYYMMDDHHII') { $this->Ajust_fields($ind_ini, $rs, "1,2,3,4"); $temp = $rs->fields[$ind_ini] . "-" . $rs->fields[$ind_ini + 1] . "-" . $rs->fields[$ind_ini + 2] . " " . $rs->fields[$ind_ini + 3] . ":" . $rs->fields[$ind_ini + 4]; $retorno['orig'] = $temp; $retorno['fmt'] = $this->GB_date_format($temp, $format, $Prefix_dat, $conf_region, $mask); return $retorno; } if ($format == 'YYYYMMDDHH') { $this->Ajust_fields($ind_ini, $rs, "1,2,3"); $temp = $rs->fields[$ind_ini] . "-" . $rs->fields[$ind_ini + 1] . "-" . $rs->fields[$ind_ini + 2] . " " . $rs->fields[$ind_ini + 3]; $retorno['orig'] = $temp; $retorno['fmt'] = $this->GB_date_format($temp, $format, $Prefix_dat, $conf_region, $mask); return $retorno; } if ($format == 'YYYYMMDD2') { $this->Ajust_fields($ind_ini, $rs, "1,2"); $temp = $rs->fields[$ind_ini] . "-" . $rs->fields[$ind_ini + 1] . "-" . $rs->fields[$ind_ini + 2]; $retorno['orig'] = $temp; $retorno['fmt'] = $this->GB_date_format($temp, $format, $Prefix_dat, $conf_region, $mask); return $retorno; } if ($format == 'YYYYMM') { $this->Ajust_fields($ind_ini, $rs, "1"); $temp = $rs->fields[$ind_ini] . "-" . $rs->fields[$ind_ini + 1]; $retorno['orig'] = $temp; $retorno['fmt'] = $this->GB_date_format($temp, $format, $Prefix_dat, $conf_region, $mask); return $retorno; } if ($format == 'MMDD') { $this->Ajust_fields($ind_ini, $rs, "0,1"); $temp = "0000-" . $rs->fields[$ind_ini] . "-" . $rs->fields[$ind_ini + 1]; $retorno['orig'] = $temp; $retorno['fmt'] = $this->GB_date_format($temp, $format, $Prefix_dat, $conf_region, $mask); return $retorno; } if ($format == 'YYYY') { $retorno['orig'] = $rs->fields[$ind_ini]; $retorno['fmt'] = $this->GB_date_format($rs->fields[$ind_ini], $format, $Prefix_dat, $conf_region, $mask); return $retorno; } if ($format == 'BIMONTHLY' || $format == 'QUARTER' || $format == 'FOURMONTHS' || $format == 'SEMIANNUAL' || $format == 'WEEK') { $temp = (substr($rs->fields[$ind_ini], 0, 1) == 0) ? substr($rs->fields[$ind_ini], 1) : $rs->fields[$ind_ini]; $retorno['orig'] = $rs->fields[$ind_ini]; $retorno['fmt'] = $Prefix_dat . $temp; return $retorno; } if ($format == 'DAYNAME'|| $format == 'YYYYDAYNAME') { if ($format == 'DAYNAME') { $retorno['orig'] = $rs->fields[$ind_ini]; $ano = ""; $daynum = $rs->fields[$ind_ini]; } else { $retorno['orig'] = $rs->fields[$ind_ini] . $rs->fields[$ind_ini + 1]; $ano = " " . $rs->fields[$ind_ini]; $daynum = $rs->fields[$ind_ini + 1]; } if (in_array(strtolower($this->nm_tpbanco), $this->nm_bases_access) || in_array(strtolower($this->nm_tpbanco), $this->nm_bases_oracle) || in_array(strtolower($this->nm_tpbanco), $this->nm_bases_mssql) || in_array(strtolower($this->nm_tpbanco), $this->nm_bases_db2) || in_array(strtolower($this->nm_tpbanco), $this->nm_bases_progress)) { $daynum--; } if (in_array(strtolower($this->nm_tpbanco), $this->nm_bases_mysql)) { $daynum = ($daynum == 6) ? 0 : $daynum + 1; } if ($daynum == 0) { $retorno['fmt'] = $Prefix_dat . $this->Nm_lang['lang_days_sund'] . $ano; } if ($daynum == 1) { $retorno['fmt'] = $Prefix_dat . $this->Nm_lang['lang_days_mond'] . $ano; } if ($daynum == 2) { $retorno['fmt'] = $Prefix_dat . $this->Nm_lang['lang_days_tued'] . $ano; } if ($daynum == 3) { $retorno['fmt'] = $Prefix_dat . $this->Nm_lang['lang_days_wend'] . $ano; } if ($daynum == 4) { $retorno['fmt'] = $Prefix_dat . $this->Nm_lang['lang_days_thud'] . $ano; } if ($daynum == 5) { $retorno['fmt'] = $Prefix_dat . $this->Nm_lang['lang_days_frid'] . $ano; } if ($daynum == 6) { $retorno['fmt'] = $Prefix_dat . $this->Nm_lang['lang_days_satd'] . $ano; } return $retorno; } if ($format == 'HH') { $this->Ajust_fields($ind_ini, $rs, "0"); $temp = "0000-00-00 " . $rs->fields[$ind_ini]; $retorno['orig'] = $rs->fields[$ind_ini]; $retorno['fmt'] = $this->GB_date_format($temp, $format, $Prefix_dat, $conf_region, $mask); return $retorno; } if ($format == 'DD') { $this->Ajust_fields($ind_ini, $rs, "0"); $temp = "0000-00-" . $rs->fields[$ind_ini]; $retorno['orig'] = $rs->fields[$ind_ini]; $retorno['fmt'] = $this->GB_date_format($temp, $format, $Prefix_dat, $conf_region, $mask); return $retorno; } if ($format == 'MM') { $this->Ajust_fields($ind_ini, $rs, "0"); $temp = "0000-" . $rs->fields[$ind_ini]; $retorno['orig'] = $rs->fields[$ind_ini]; $retorno['fmt'] = $this->GB_date_format($temp, $format, $Prefix_dat, $conf_region, $mask); return $retorno; } if ($format == 'YYYY') { $temp = $rs->fields[$ind_ini]; $retorno['orig'] = $rs->fields[$ind_ini]; $retorno['fmt'] = $this->GB_date_format($temp, $format, $Prefix_dat, $conf_region, $mask); return $retorno; } if ($format == 'YYYYHH') { $this->Ajust_fields($ind_ini, $rs, "1"); $temp = $rs->fields[$ind_ini] . "-00-00 " . $rs->fields[$ind_ini + 1]; $retorno['orig'] = $rs->fields[$ind_ini] . $rs->fields[$ind_ini + 1]; $retorno['fmt'] = $this->GB_date_format($temp, $format, $Prefix_dat, $conf_region, $mask); return $retorno; } if ($format == 'YYYYDD') { $this->Ajust_fields($ind_ini, $rs, "1"); $temp = $rs->fields[$ind_ini] . "-00-" . $rs->fields[$ind_ini + 1]; $retorno['orig'] = $rs->fields[$ind_ini] . $rs->fields[$ind_ini + 1]; $retorno['fmt'] = $this->GB_date_format($temp, $format, $Prefix_dat, $conf_region, $mask); return $retorno; } elseif ($format == 'YYYYBIMONTHLY' || $format == 'YYYYQUARTER' || $format == 'YYYYFOURMONTHS' || $format == 'YYYYSEMIANNUAL') { $temp = (substr($rs->fields[$ind_ini + 1], 0, 1) == 0) ? substr($rs->fields[$ind_ini + 1], 1) : $rs->fields[$ind_ini + 1]; $retorno['orig'] = $rs->fields[$ind_ini] . $rs->fields[$ind_ini + 1]; $retorno['fmt'] = $Prefix_dat . $temp . " " . $rs->fields[$ind_ini]; return $retorno; } elseif ($format == 'YYYYWEEK') { $temp = (substr($rs->fields[$ind_ini + 1], 0, 1) == 0) ? substr($rs->fields[$ind_ini + 1], 1) : $rs->fields[$ind_ini + 1]; $retorno['orig'] = (strlen($rs->fields[$ind_ini + 1]) == 1) ? $rs->fields[$ind_ini] . "0" . $rs->fields[$ind_ini + 1] : $rs->fields[$ind_ini] . $rs->fields[$ind_ini + 1]; $retorno['fmt'] = $Prefix_dat . $temp . " " . $rs->fields[$ind_ini]; return $retorno; } if ($format == 'YYYYHH' || $format == 'YYYYDD') { $this->Ajust_fields($ind_ini, $rs, "1"); $retorno['orig'] = $rs->fields[$ind_ini] . $rs->fields[$ind_ini + 1]; $retorno['fmt'] = $rs->fields[$ind_ini] . $_SESSION['scriptcase']['reg_conf']['date_sep'] . $rs->fields[$ind_ini + 1]; return $retorno; } elseif ($format == 'HHIISS') { $this->Ajust_fields($ind_ini, $rs, "0,1,2"); $retorno['orig'] = $rs->fields[$ind_ini] . ":" . $rs->fields[$ind_ini + 1] . ":" . $rs->fields[$ind_ini + 2]; $retorno['fmt'] = $this->GB_date_format("0000-00-00 " . $retorno['orig'], $format, $Prefix_dat, $conf_region, $mask); return $retorno; } elseif ($format == 'HHII') { $this->Ajust_fields($ind_ini, $rs, "0,1"); $retorno['orig'] = $rs->fields[$ind_ini] . ":" . $rs->fields[$ind_ini + 1]; $retorno['fmt'] = $this->GB_date_format("0000-00-00 " . $retorno['orig'], $format, $Prefix_dat, $conf_region, $mask); return $retorno; } else { $retorno['orig'] = $rs->fields[$ind_ini]; $retorno['fmt'] = $rs->fields[$ind_ini]; return $retorno; } } function Ajust_fields($ind_ini, &$rs, $parts) { $prep = explode(",", $parts); foreach ($prep as $ind) { $ind_ok = $ind_ini + $ind; $rs->fields[$ind_ok] = (int) $rs->fields[$ind_ok]; if (strlen($rs->fields[$ind_ok]) == 1) { $rs->fields[$ind_ok] = "0" . $rs->fields[$ind_ok]; } } } function Get_date_order_groupby($sql_def, $order, $format="", $order_old="") { $order = " " . trim($order); $order_old .= (!empty($order_old)) ? ", " : ""; return $order_old . $sql_def . $order; } } //=============================================================================== // class blank_email_pruebas_apl { var $Ini; var $Erro; var $Db; var $Lookup; var $nm_location; // //----- function prep_modulos($modulo) { $this->$modulo->Ini = $this->Ini; $this->$modulo->Db = $this->Db; $this->$modulo->Erro = $this->Erro; } // //----- function controle() { global $nm_saida, $nm_url_saida, $script_case_init, $glo_senha_protect; $this->Ini = new blank_email_pruebas_ini(); $this->Ini->init(); $this->Change_Menu = false; if (isset($_SESSION['scriptcase']['menu_atual']) && (!isset($_SESSION['sc_session'][$this->Ini->sc_page]['blank_email_pruebas']['sc_outra_jan']) || !$_SESSION['sc_session'][$this->Ini->sc_page]['blank_email_pruebas']['sc_outra_jan'])) { $this->sc_init_menu = "x"; if (isset($_SESSION['scriptcase'][$_SESSION['scriptcase']['menu_atual']]['sc_init']['blank_email_pruebas'])) { $this->sc_init_menu = $_SESSION['scriptcase'][$_SESSION['scriptcase']['menu_atual']]['sc_init']['blank_email_pruebas']; } elseif (isset($_SESSION['scriptcase']['menu_apls'][$_SESSION['scriptcase']['menu_atual']])) { foreach ($_SESSION['scriptcase']['menu_apls'][$_SESSION['scriptcase']['menu_atual']] as $init => $resto) { if ($this->Ini->sc_page == $init) { $this->sc_init_menu = $init; break; } } } if ($this->Ini->sc_page == $this->sc_init_menu && !isset($_SESSION['scriptcase']['menu_apls'][$_SESSION['scriptcase']['menu_atual']][$this->sc_init_menu]['blank_email_pruebas'])) { $_SESSION['scriptcase']['menu_apls'][$_SESSION['scriptcase']['menu_atual']][$this->sc_init_menu]['blank_email_pruebas']['link'] = $this->Ini->sc_protocolo . $this->Ini->server . $this->Ini->path_link . "" . SC_dir_app_name('blank_email_pruebas') . "/"; $_SESSION['scriptcase']['menu_apls'][$_SESSION['scriptcase']['menu_atual']][$this->sc_init_menu]['blank_email_pruebas']['label'] = "" . $this->Ini->Nm_lang['lang_othr_blank_title'] . ""; $this->Change_Menu = true; } elseif ($this->Ini->sc_page == $this->sc_init_menu) { $achou = false; foreach ($_SESSION['scriptcase']['menu_apls'][$_SESSION['scriptcase']['menu_atual']][$this->sc_init_menu] as $apl => $parms) { if ($apl == "blank_email_pruebas") { $achou = true; } elseif ($achou) { unset($_SESSION['scriptcase']['menu_apls'][$_SESSION['scriptcase']['menu_atual']][$this->sc_init_menu][$apl]); $this->Change_Menu = true; } } } } $dir_raiz = strrpos($_SERVER['PHP_SELF'],"/") ; $dir_raiz = substr($_SERVER['PHP_SELF'], 0, $dir_raiz + 1) ; $this->nm_location = $this->Ini->sc_protocolo . $this->Ini->server . $dir_raiz; if (isset($_SESSION['scriptcase']['sc_apl_conf']['blank_email_pruebas']['exit']) && $_SESSION['scriptcase']['sc_apl_conf']['blank_email_pruebas']['exit'] != '') { $_SESSION['scriptcase']['sc_url_saida'][$this->Ini->sc_page] = $_SESSION['scriptcase']['sc_apl_conf']['blank_email_pruebas']['exit']; $_SESSION['scriptcase']['sc_force_url_saida'][$this->Ini->sc_page] = true; } $glo_senha_protect = (isset($_SESSION['scriptcase']['glo_senha_protect'])) ? $_SESSION['scriptcase']['glo_senha_protect'] : "S"; $this->Ini->sc_Include($this->Ini->path_libs . "/nm_gc.php", "F", "nm_gc") ; nm_gc($this->Ini->path_libs); if (!function_exists("SC_Mail_Image")) { include_once("blank_email_pruebas_sc_mail_image.php"); } $this->nm_data = new nm_data("es"); $_SESSION['scriptcase']['sc_tab_meses']['int'] = array( $this->Ini->Nm_lang['lang_mnth_janu'], $this->Ini->Nm_lang['lang_mnth_febr'], $this->Ini->Nm_lang['lang_mnth_marc'], $this->Ini->Nm_lang['lang_mnth_apri'], $this->Ini->Nm_lang['lang_mnth_mayy'], $this->Ini->Nm_lang['lang_mnth_june'], $this->Ini->Nm_lang['lang_mnth_july'], $this->Ini->Nm_lang['lang_mnth_augu'], $this->Ini->Nm_lang['lang_mnth_sept'], $this->Ini->Nm_lang['lang_mnth_octo'], $this->Ini->Nm_lang['lang_mnth_nove'], $this->Ini->Nm_lang['lang_mnth_dece']); $_SESSION['scriptcase']['sc_tab_meses']['abr'] = array( $this->Ini->Nm_lang['lang_shrt_mnth_janu'], $this->Ini->Nm_lang['lang_shrt_mnth_febr'], $this->Ini->Nm_lang['lang_shrt_mnth_marc'], $this->Ini->Nm_lang['lang_shrt_mnth_apri'], $this->Ini->Nm_lang['lang_shrt_mnth_mayy'], $this->Ini->Nm_lang['lang_shrt_mnth_june'], $this->Ini->Nm_lang['lang_shrt_mnth_july'], $this->Ini->Nm_lang['lang_shrt_mnth_augu'], $this->Ini->Nm_lang['lang_shrt_mnth_sept'], $this->Ini->Nm_lang['lang_shrt_mnth_octo'], $this->Ini->Nm_lang['lang_shrt_mnth_nove'], $this->Ini->Nm_lang['lang_shrt_mnth_dece']); $_SESSION['scriptcase']['sc_tab_dias']['int'] = array( $this->Ini->Nm_lang['lang_days_sund'], $this->Ini->Nm_lang['lang_days_mond'], $this->Ini->Nm_lang['lang_days_tued'], $this->Ini->Nm_lang['lang_days_wend'], $this->Ini->Nm_lang['lang_days_thud'], $this->Ini->Nm_lang['lang_days_frid'], $this->Ini->Nm_lang['lang_days_satd']); $_SESSION['scriptcase']['sc_tab_dias']['abr'] = array( $this->Ini->Nm_lang['lang_shrt_days_sund'], $this->Ini->Nm_lang['lang_shrt_days_mond'], $this->Ini->Nm_lang['lang_shrt_days_tued'], $this->Ini->Nm_lang['lang_shrt_days_wend'], $this->Ini->Nm_lang['lang_shrt_days_thud'], $this->Ini->Nm_lang['lang_shrt_days_frid'], $this->Ini->Nm_lang['lang_shrt_days_satd']); $this->Db = $this->Ini->Db; include_once($this->Ini->path_aplicacao . "blank_email_pruebas_erro.class.php"); $this->Erro = new blank_email_pruebas_erro(); $this->Erro->Ini = $this->Ini; // header("X-XSS-Protection: 1; mode=block"); header("X-Frame-Options: SAMEORIGIN"); $_SESSION['scriptcase']['blank_email_pruebas']['contr_erro'] = 'on'; if (!isset($_SESSION['idempresa'])) {$_SESSION['idempresa'] = "";} if (!isset($this->sc_temp_idempresa)) {$this->sc_temp_idempresa = (isset($_SESSION['idempresa'])) ? $_SESSION['idempresa'] : "";} if (!isset($_SESSION['usr_perfil'])) {$_SESSION['usr_perfil'] = "";} if (!isset($this->sc_temp_usr_perfil)) {$this->sc_temp_usr_perfil = (isset($_SESSION['usr_perfil'])) ? $_SESSION['usr_perfil'] : "";} $error_test = $this->sc_temp_usr_perfil != '4'; $error_message = 'No autorizado para éste proceso....'; if ($error_test) { if (!isset($this->Campos_Mens_erro)){$this->Campos_Mens_erro = "";} if (!empty($this->Campos_Mens_erro)){$this->Campos_Mens_erro .= "<br>";}$this->Campos_Mens_erro .= $error_message; ; if (isset($this->Campos_Mens_erro) && !empty($this->Campos_Mens_erro)) { if (isset($this->sc_temp_usr_perfil)) {$_SESSION['usr_perfil'] = $this->sc_temp_usr_perfil;} if (isset($this->sc_temp_idempresa)) {$_SESSION['idempresa'] = $this->sc_temp_idempresa;} $this->Erro->mensagem(__FILE__, __LINE__, "critica", $this->Campos_Mens_erro); exit; } } $this->sc_temp_idempresa = 1; $estadoti = 1; if($idestadopto == 1){ $check_sql = "SELECT idtiquete,idturno,valorpto,estadotiquete,fechacompra,taquilla,idusuariovende,fechaviaje,horasalida,ruta,documento,destino,idruta,idvehiculo,idoficina,copias,formapago,nucontrato,numensaje,fechaenvio,horaenvio,modotransporte,mediotransporte,origen,nombre,cude,pasajeroviaja" . " FROM tiquetes" . " WHERE nuptosalida = '" . $nuptosalida . "' and estadotiquete = '" . $estadoti . "'"; $nm_select = $check_sql; $_SESSION['scriptcase']['sc_sql_ult_comando'] = $nm_select; $_SESSION['scriptcase']['sc_sql_ult_conexao'] = ''; $this->rs = array(); if ($SCrx = $this->Db->Execute($nm_select)) { $SCy = 0; $nm_count = $SCrx->FieldCount(); while (!$SCrx->EOF) { for ($SCx = 0; $SCx < $nm_count; $SCx++) { $this->rs[$SCy] [$SCx] = $SCrx->fields[$SCx]; } $SCy++; $SCrx->MoveNext(); } $SCrx->Close(); } elseif (isset($GLOBALS["NM_ERRO_IBASE"]) && $GLOBALS["NM_ERRO_IBASE"] != 1) { $this->rs = false; $this->rs_erro = $this->Db->ErrorMsg(); } if (isset($this->rs[0][0])) { $idtiquete = $this->rs[0][0]; $idturno = $this->rs[0][1]; $valorpto = $this->rs[0][2]; $estadotiquete = $this->rs[0][3]; $fechacompra = $this->rs[0][4]; $taquilla = $this->rs[0][5]; $idusuariovende = $this->rs[0][6]; $fechaviaje = $this->rs[0][7]; $horasalida = $this->rs[0][8]; $ruta = $this->rs[0][9]; $documento = $this->rs[0][10]; $destino = $this->rs[0][11]; $idruta = $this->rs[0][12]; $idvehiculo = $this->rs[0][13]; $idoficina = $this->rs[0][14]; $copias = $this->rs[0][15]; $formapago = $this->rs[0][16]; $nucontrato = $this->rs[0][17]; $numensaje = $this->rs[0][18]; $fechaenvio = $this->rs[0][19]; $horaenvio = $this->rs[0][20]; $modotransporte = $this->rs[0][21]; $mediotransporte = $this->rs[0][22]; $origen = $this->rs[0][23]; $nombre = $this->rs[0][24]; $cude = $this->rs[0][25]; $pasajeroviaje = $this->rs[0][26]; } else { $other_field = ''; $other_region = ''; } $error_test = $cude == '** No Autorizado para Dian **'; $error_message = 'Ruta no autorizada para validación en la Dian....'; if ($error_test) { if (!isset($this->Campos_Mens_erro)){$this->Campos_Mens_erro = "";} if (!empty($this->Campos_Mens_erro)){$this->Campos_Mens_erro .= "<br>";}$this->Campos_Mens_erro .= $error_message; ; if (isset($this->Campos_Mens_erro) && !empty($this->Campos_Mens_erro)) { if (isset($this->sc_temp_usr_perfil)) {$_SESSION['usr_perfil'] = $this->sc_temp_usr_perfil;} if (isset($this->sc_temp_idempresa)) {$_SESSION['idempresa'] = $this->sc_temp_idempresa;} $this->Erro->mensagem(__FILE__, __LINE__, "critica", $this->Campos_Mens_erro); exit; } } $error_test = $cude == '** pendiente de validacion **'; $error_message = 'Tiquete no validado en la Dian....'; if ($error_test) { if (!isset($this->Campos_Mens_erro)){$this->Campos_Mens_erro = "";} if (!empty($this->Campos_Mens_erro)){$this->Campos_Mens_erro .= "<br>";}$this->Campos_Mens_erro .= $error_message; ; if (isset($this->Campos_Mens_erro) && !empty($this->Campos_Mens_erro)) { if (isset($this->sc_temp_usr_perfil)) {$_SESSION['usr_perfil'] = $this->sc_temp_usr_perfil;} if (isset($this->sc_temp_idempresa)) {$_SESSION['idempresa'] = $this->sc_temp_idempresa;} $this->Erro->mensagem(__FILE__, __LINE__, "critica", $this->Campos_Mens_erro); exit; } } $check_sql = "SELECT nombre,email" . " FROM terceros" . " WHERE documento = '" . $documento . "'"; $nm_select = $check_sql; $_SESSION['scriptcase']['sc_sql_ult_comando'] = $nm_select; $_SESSION['scriptcase']['sc_sql_ult_conexao'] = ''; $this->rs = array(); if ($SCrx = $this->Db->Execute($nm_select)) { $SCy = 0; $nm_count = $SCrx->FieldCount(); while (!$SCrx->EOF) { for ($SCx = 0; $SCx < $nm_count; $SCx++) { $this->rs[$SCy] [$SCx] = $SCrx->fields[$SCx]; } $SCy++; $SCrx->MoveNext(); } $SCrx->Close(); } elseif (isset($GLOBALS["NM_ERRO_IBASE"]) && $GLOBALS["NM_ERRO_IBASE"] != 1) { $this->rs = false; $this->rs_erro = $this->Db->ErrorMsg(); } if (isset($this->rs[0][0])) { $nombre = $this->rs[0][0]; $emailcliente = $this->rs[0][1]; } else { $other_field = ''; $other_region = ''; } $codiqr = "Señor: ".$nombre." En este link puede consultar su documento equivalente".'<br>'."Tiquete No. ".$idtiquete.'<br>'." Fecha: ".$fechaenvio.'<br>'." Hora: ".$horaenvio.'<br>'." valor: ".$valorpto.'<br>'." QRCode=" . "https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=" . $cude; $insert_table = 'impretiquete'; $insert_fields = array( 'tiquete' => "'$idtiquete'", 'fechacompra' => "'$fechacompra'", 'fechaviaje' => "'$fechaviaje'", 'rutaviaje' => "'$ruta'", 'origen' => "'$origen'", 'destino' => "'$destino'", 'horasalida' => "'$horasalida'", 'placa' => "'$placa'", 'documento' => "'$documento'", 'pasajero' => "'$nombre'", 'puesto' => "'$puesto'", 'valor' => "'$valorpto'", 'ofivende' => "'$oficina'", 'tipotiquete' => "'$tipo'", 'usuariovende' => "'$idusuariovende'", 'comentario' => "'$comentario'", 'codbarras' => "'$codbarras'", 'empresa' => "'$empresa'", 'nit' => "'$nit'", 'taquilla' => "'$nomtaquilla'", 'detallemensaje' => "'$codiqr'", 'contrato' => "'$archivo'", 'nuptosalida' => "'$nuptosalida'", 'copias' => "'$copias'", 'formapago' => "'$formapago'", 'idtaquilla' => "'$taquilla'", 'tipovehiculo' => "'$mediotransporte'", 'codigoqr' => "'$codiqr'", 'cude' => "'$cude'", 'pasajeroviaja' => "'$pasajero'", ); $mensaje = 'Apreciado cliente. Este es su tiquete de abordaje'; $mail_smtp_server = 'smtp.gmail.com'; $mail_smtp_user = 'aditivo2014@gmail.com'; $mail_smtp_pass = 'ulxunxtvjndticeh'; $mail_from = 'aditivo2014@gmail.com'; $mail_to = $emailcliente; $mail_subject = 'Documento equivalente enviado desde la Plataforma GorbusWeb'; $mail_message = $codiqr; $mail_format = 'H'; $mail_copies = ''; $mail_tp_copies = ''; $mail_port = '465'; $mail_tp_connection = 'S'; include_once($this->Ini->path_third . "/swift/swift_required.php"); $sc_mail_port = "$mail_port"; $sc_mail_tp_port = "$mail_tp_connection"; $sc_mail_tp_mens = "$mail_format"; $sc_mail_tp_copy = "$mail_tp_copies"; $this->sc_mail_count = 0; $this->sc_mail_erro = ""; $this->sc_mail_ok = true; if ($sc_mail_tp_port == "S" || $sc_mail_tp_port == "Y") { $sc_mail_port = !empty($sc_mail_port) ? $sc_mail_port : 465; $Con_Mail = Swift_SmtpTransport::newInstance($mail_smtp_server, $sc_mail_port, 'ssl'); } elseif ($sc_mail_tp_port == "T") { $sc_mail_port = !empty($sc_mail_port) ? $sc_mail_port : 587; $Con_Mail = Swift_SmtpTransport::newInstance($mail_smtp_server, $sc_mail_port, 'tls'); } else { $sc_mail_port = !empty($sc_mail_port) ? $sc_mail_port : 25; $Con_Mail = Swift_SmtpTransport::newInstance($mail_smtp_server, $sc_mail_port); } $Con_Mail->setUsername($mail_smtp_user); $Con_Mail->setpassword($mail_smtp_pass); $Send_Mail = Swift_Mailer::newInstance($Con_Mail); if ($sc_mail_tp_mens == "H") { $Mens_Mail = Swift_Message::newInstance($mail_subject)->setBody($mail_message)->setContentType("text/html"); } else { $Mens_Mail = Swift_Message::newInstance($mail_subject)->setBody($mail_message); } if (!empty($_SESSION['scriptcase']['charset'])) { $Mens_Mail->setCharset($_SESSION['scriptcase']['charset']); } $Temp_mail = $mail_to; if (!is_array($Temp_mail)) { $Temp_mail = explode(";", $mail_to); } foreach ($Temp_mail as $NM_dest) { if (!empty($NM_dest)) { $Arr_addr = SC_Mail_Address($NM_dest); $Mens_Mail->addTo($Arr_addr[0], $Arr_addr[1]); } } $Temp_mail = $mail_copies; if (!is_array($Temp_mail)) { $Temp_mail = explode(";", $mail_copies); } foreach ($Temp_mail as $NM_dest) { if (!empty($NM_dest)) { $Arr_addr = SC_Mail_Address($NM_dest); if (strtoupper(substr($sc_mail_tp_copy, 0, 2)) == "CC") { $Mens_Mail->addCc($Arr_addr[0], $Arr_addr[1]); } else { $Mens_Mail->addBcc($Arr_addr[0], $Arr_addr[1]); } } } $Arr_addr = SC_Mail_Address($mail_from); $Err_mail = array(); $this->sc_mail_count = $Send_Mail->send($Mens_Mail->setFrom($Arr_addr[0], $Arr_addr[1]), $Err_mail); if (!empty($Err_mail)) { $this->sc_mail_erro = $Err_mail; $this->sc_mail_ok = false; } ; if($this->sc_mail_ok ){ $javascript_message = "Email enviado satisfactoriamente.."; $this->sc_ajax_message($javascript_message); }else{ $javascript_message = "** el email no fué enviado.."; $this->sc_ajax_message($javascript_message); } }else{ $javascript_message = "Este puesto no está vendido.."; $this->sc_ajax_message($javascript_message); } if (isset($this->sc_temp_usr_perfil)) {$_SESSION['usr_perfil'] = $this->sc_temp_usr_perfil;} if (isset($this->sc_temp_idempresa)) {$_SESSION['idempresa'] = $this->sc_temp_idempresa;} $_SESSION['scriptcase']['blank_email_pruebas']['contr_erro'] = 'off'; //--- $this->Db->Close(); if ($this->Change_Menu) { $apl_menu = $_SESSION['scriptcase']['menu_atual']; $Arr_rastro = array(); if (isset($_SESSION['scriptcase']['menu_apls'][$apl_menu][$this->sc_init_menu]) && count($_SESSION['scriptcase']['menu_apls'][$apl_menu][$this->sc_init_menu]) > 1) { foreach ($_SESSION['scriptcase']['menu_apls'][$apl_menu][$this->sc_init_menu] as $menu => $apls) { $Arr_rastro[] = "'<a href=\"" . $apls['link'] . "?script_case_init=" . $this->sc_init_menu . "\" target=\"#NMIframe#\">" . $apls['label'] . "</a>'"; } $ult_apl = count($Arr_rastro) - 1; unset($Arr_rastro[$ult_apl]); $rastro = implode(",", $Arr_rastro); ?> <script type="text/javascript"> link_atual = new Array (<?php echo $rastro ?>); if (parent.writeFastMenu) { parent.writeFastMenu(link_atual); } </script> <?php } else { ?> <script type="text/javascript"> if (parent.clearFastMenu) { parent.clearFastMenu(); } </script> <?php } } if (isset($this->redir_modal) && !empty($this->redir_modal)) { ?> <script type="text/javascript" src="<?php echo $this->Ini->path_prod ?>/third/jquery/js/jquery.js"></script> <script type="text/javascript"> var sc_pathToTB = '<?php echo $this->Ini->path_prod ?>/third/jquery_plugin/thickbox/'; var sc_tbLangClose = "<?php echo html_entity_decode($this->Ini->Nm_lang["lang_tb_close"], ENT_COMPAT, $_SESSION["scriptcase"]["charset"]) ?>"; var sc_tbLangEsc = "<?php echo html_entity_decode($this->Ini->Nm_lang["lang_tb_esc"], ENT_COMPAT, $_SESSION["scriptcase"]["charset"]) ?>"; </script> <script type="text/javascript" src="<?php echo $this->Ini->path_prod ?>/third/jquery_plugin/thickbox/thickbox-compressed.js"></script> <link rel="stylesheet" href="<?php echo $this->Ini->path_prod ?>/third/jquery_plugin/thickbox/thickbox.css" type="text/css" media="screen" /> <script type="text/javascript"><?php echo $this->redir_modal ?></script> <?php } exit; } function nm_conv_data_db($dt_in, $form_in, $form_out) { $dt_out = $dt_in; if (strtoupper($form_in) == "DB_FORMAT") { if ($dt_out == "null" || $dt_out == "") { $dt_out = ""; return $dt_out; } $form_in = "AAAA-MM-DD"; } if (strtoupper($form_out) == "DB_FORMAT") { if (empty($dt_out)) { $dt_out = "null"; return $dt_out; } $form_out = "AAAA-MM-DD"; } if (strtoupper($form_out) == "SC_FORMAT_REGION") { $this->nm_data->SetaData($dt_in, strtoupper($form_in)); $prep_out = (strpos(strtolower($form_in), "dd") !== false) ? "dd" : ""; $prep_out .= (strpos(strtolower($form_in), "mm") !== false) ? "mm" : ""; $prep_out .= (strpos(strtolower($form_in), "aa") !== false) ? "aaaa" : ""; $prep_out .= (strpos(strtolower($form_in), "yy") !== false) ? "aaaa" : ""; return $this->nm_data->FormataSaida($this->nm_data->FormatRegion("DT", $prep_out)); } else { nm_conv_form_data($dt_out, $form_in, $form_out); return $dt_out; } } } // //======= ========================= if (!function_exists("NM_is_utf8")) { include_once("../_lib/lib/php/nm_utf8.php"); } if (!function_exists("SC_dir_app_ini")) { include_once("../_lib/lib/php/nm_ctrl_app_name.php"); } SC_dir_app_ini('GorbusWeb'); $_SESSION['scriptcase']['blank_email_pruebas']['contr_erro'] = 'off'; $Sc_lig_md5 = false; $Sem_Session = (!isset($_SESSION['sc_session'])) ? true : false; $_SESSION['scriptcase']['sem_session'] = false; if (!empty($_POST)) { foreach ($_POST as $nmgp_var => $nmgp_val) { if (substr($nmgp_var, 0, 11) == "SC_glo_par_") { $nmgp_var = substr($nmgp_var, 11); $nmgp_val = $_SESSION[$nmgp_val]; } if ($nmgp_var == "nmgp_parms" && substr($nmgp_val, 0, 8) == "@SC_par@") { $SC_Ind_Val = explode("@SC_par@", $nmgp_val); if (count($SC_Ind_Val) == 4 && isset($_SESSION['sc_session'][$SC_Ind_Val[1]][$SC_Ind_Val[2]]['Lig_Md5'][$SC_Ind_Val[3]])) { $nmgp_val = $_SESSION['sc_session'][$SC_Ind_Val[1]][$SC_Ind_Val[2]]['Lig_Md5'][$SC_Ind_Val[3]]; $Sc_lig_md5 = true; } else { $_SESSION['sc_session']['SC_parm_violation'] = true; } } nm_limpa_str_blank_email_pruebas($nmgp_val); $nmgp_val = NM_decode_input($nmgp_val); $$nmgp_var = $nmgp_val; } } if (!empty($_GET)) { foreach ($_GET as $nmgp_var => $nmgp_val) { if (substr($nmgp_var, 0, 11) == "SC_glo_par_") { $nmgp_var = substr($nmgp_var, 11); $nmgp_val = $_SESSION[$nmgp_val]; } if ($nmgp_var == "nmgp_parms" && substr($nmgp_val, 0, 8) == "@SC_par@") { $SC_Ind_Val = explode("@SC_par@", $nmgp_val); if (count($SC_Ind_Val) == 4 && isset($_SESSION['sc_session'][$SC_Ind_Val[1]][$SC_Ind_Val[2]]['Lig_Md5'][$SC_Ind_Val[3]])) { $nmgp_val = $_SESSION['sc_session'][$SC_Ind_Val[1]][$SC_Ind_Val[2]]['Lig_Md5'][$SC_Ind_Val[3]]; $Sc_lig_md5 = true; } else { $_SESSION['sc_session']['SC_parm_violation'] = true; } } nm_limpa_str_blank_email_pruebas($nmgp_val); $nmgp_val = NM_decode_input($nmgp_val); $$nmgp_var = $nmgp_val; } } if (!isset($_SERVER['HTTP_REFERER']) || (!isset($nmgp_parms) && !isset($script_case_init) && !isset($nmgp_start) )) { $Sem_Session = false; } $NM_dir_atual = getcwd(); if (empty($NM_dir_atual)) { $str_path_sys = (isset($_SERVER['SCRIPT_FILENAME'])) ? $_SERVER['SCRIPT_FILENAME'] : $_SERVER['ORIG_PATH_TRANSLATED']; $str_path_sys = str_replace("\\", '/', $str_path_sys); } else { $sc_nm_arquivo = explode("/", $_SERVER['PHP_SELF']); $str_path_sys = str_replace("\\", "/", getcwd()) . "/" . $sc_nm_arquivo[count($sc_nm_arquivo)-1]; } $str_path_web = $_SERVER['PHP_SELF']; $str_path_web = str_replace("\\", '/', $str_path_web); $str_path_web = str_replace('//', '/', $str_path_web); $path_aplicacao = substr($str_path_web, 0, strrpos($str_path_web, '/')); $path_aplicacao = substr($path_aplicacao, 0, strrpos($path_aplicacao, '/')); $root = substr($str_path_sys, 0, -1 * strlen($str_path_web)); if ($Sem_Session && (!isset($nmgp_start) || $nmgp_start != "SC")) { if (isset($_COOKIE['sc_apl_default_GorbusWeb'])) { $apl_def = explode(",", $_COOKIE['sc_apl_default_GorbusWeb']); } elseif (is_file($root . $_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_path_imag_temp'] . "/sc_apl_default_GorbusWeb.txt")) { $apl_def = explode(",", file_get_contents($root . $_SESSION['scriptcase']['blank_email_pruebas']['glo_nm_path_imag_temp'] . "/sc_apl_default_GorbusWeb.txt")); } if (isset($apl_def)) { if ($apl_def[0] != "blank_email_pruebas") { $_SESSION['scriptcase']['sem_session'] = true; if (strtolower(substr($apl_def[0], 0 , 7)) == "http://" || strtolower(substr($apl_def[0], 0 , 8)) == "https://" || substr($apl_def[0], 0 , 2) == "..") { $_SESSION['scriptcase']['blank_email_pruebas']['session_timeout']['redir'] = $apl_def[0]; } else { $_SESSION['scriptcase']['blank_email_pruebas']['session_timeout']['redir'] = $path_aplicacao . "/" . SC_dir_app_name($apl_def[0]) . "/index.php"; } $Redir_tp = (isset($apl_def[1])) ? trim(strtoupper($apl_def[1])) : ""; $_SESSION['scriptcase']['blank_email_pruebas']['session_timeout']['redir_tp'] = $Redir_tp; } if (isset($_COOKIE['sc_actual_lang_GorbusWeb'])) { $_SESSION['scriptcase']['blank_email_pruebas']['session_timeout']['lang'] = $_COOKIE['sc_actual_lang_GorbusWeb']; } } } if (isset($SC_lig_apl_orig) && !$Sc_lig_md5 && (!isset($nmgp_parms) || ($nmgp_parms != "SC_null" && substr($nmgp_parms, 0, 8) != "OrScLink"))) { $_SESSION['sc_session']['SC_parm_violation'] = true; } if (isset($_POST["usr_perfil"])) { $_SESSION["usr_perfil"] = $_POST["usr_perfil"]; nm_limpa_str_blank_email_pruebas($_SESSION["usr_perfil"]); } if (isset($_GET["usr_perfil"])) { $_SESSION["usr_perfil"] = $_GET["usr_perfil"]; nm_limpa_str_blank_email_pruebas($_SESSION["usr_perfil"]); } if (!isset($_SESSION["usr_perfil"])) { $_SESSION["usr_perfil"] = ""; } if (isset($_POST["idempresa"])) { $_SESSION["idempresa"] = $_POST["idempresa"]; nm_limpa_str_blank_email_pruebas($_SESSION["idempresa"]); } if (isset($_GET["idempresa"])) { $_SESSION["idempresa"] = $_GET["idempresa"]; nm_limpa_str_blank_email_pruebas($_SESSION["idempresa"]); } if (!isset($_SESSION["idempresa"])) { $_SESSION["idempresa"] = ""; } if (!empty($glo_perfil)) { $_SESSION['scriptcase']['glo_perfil'] = $glo_perfil; } if (isset($glo_servidor)) { $_SESSION['scriptcase']['glo_servidor'] = $glo_servidor; } if (isset($glo_banco)) { $_SESSION['scriptcase']['glo_banco'] = $glo_banco; } if (isset($glo_tpbanco)) { $_SESSION['scriptcase']['glo_tpbanco'] = $glo_tpbanco; } if (isset($glo_usuario)) { $_SESSION['scriptcase']['glo_usuario'] = $glo_usuario; } if (isset($glo_senha)) { $_SESSION['scriptcase']['glo_senha'] = $glo_senha; } if (isset($glo_senha_protect)) { $_SESSION['scriptcase']['glo_senha_protect'] = $glo_senha_protect; } if (isset($nmgp_outra_jan) && $nmgp_outra_jan == 'true') { $script_case_init = ""; } if (!isset($script_case_init) || empty($script_case_init)) { $script_case_init = rand(2, 10000); } $salva_iframe = false; if (isset($_SESSION['sc_session'][$script_case_init]['blank_email_pruebas']['iframe_menu'])) { $salva_iframe = $_SESSION['sc_session'][$script_case_init]['blank_email_pruebas']['iframe_menu']; unset($_SESSION['sc_session'][$script_case_init]['blank_email_pruebas']['iframe_menu']); } if (isset($nm_run_menu) && $nm_run_menu == 1) { if (isset($_SESSION['scriptcase']['sc_aba_iframe']) && isset($_SESSION['scriptcase']['sc_apl_menu_atual'])) { foreach ($_SESSION['scriptcase']['sc_aba_iframe'] as $aba => $apls_aba) { if ($aba == $_SESSION['scriptcase']['sc_apl_menu_atual']) { unset($_SESSION['scriptcase']['sc_aba_iframe'][$aba]); break; } } } $_SESSION['scriptcase']['sc_apl_menu_atual'] = "blank_email_pruebas"; $achou = false; if (isset($_SESSION['sc_session'][$script_case_init])) { foreach ($_SESSION['sc_session'][$script_case_init] as $nome_apl => $resto) { if ($nome_apl == 'blank_email_pruebas' || $achou) { unset($_SESSION['sc_session'][$script_case_init][$nome_apl]); if (!empty($_SESSION['sc_session'][$script_case_init][$nome_apl])) { $achou = true; } } } if (!$achou && isset($nm_apl_menu)) { foreach ($_SESSION['sc_session'][$script_case_init] as $nome_apl => $resto) { if ($nome_apl == $nm_apl_menu || $achou) { $achou = true; if ($nome_apl != $nm_apl_menu) { unset($_SESSION['sc_session'][$script_case_init][$nome_apl]); } } } } } $_SESSION['sc_session'][$script_case_init]['blank_email_pruebas']['iframe_menu'] = true; } else { $_SESSION['sc_session'][$script_case_init]['blank_email_pruebas']['iframe_menu'] = $salva_iframe; } if (!isset($_SESSION['sc_session'][$script_case_init]['blank_email_pruebas']['initialize'])) { $_SESSION['sc_session'][$script_case_init]['blank_email_pruebas']['initialize'] = true; } elseif (!isset($_SERVER['HTTP_REFERER'])) { $_SESSION['sc_session'][$script_case_init]['blank_email_pruebas']['initialize'] = false; } elseif (false === strpos($_SERVER['HTTP_REFERER'], '.php')) { $_SESSION['sc_session'][$script_case_init]['blank_email_pruebas']['initialize'] = true; } else { $sReferer = substr($_SERVER['HTTP_REFERER'], 0, strpos($_SERVER['HTTP_REFERER'], '.php')); $sReferer = substr($sReferer, strrpos($sReferer, '/') + 1); if ('blank_email_pruebas' == $sReferer || 'blank_email_pruebas_' == substr($sReferer, 0, 20)) { $_SESSION['sc_session'][$script_case_init]['blank_email_pruebas']['initialize'] = false; } else { $_SESSION['sc_session'][$script_case_init]['blank_email_pruebas']['initialize'] = true; } } $_POST['script_case_init'] = $script_case_init; if (isset($_SESSION['scriptcase']['sc_outra_jan']) && $_SESSION['scriptcase']['sc_outra_jan'] == 'blank_email_pruebas') { $_SESSION['sc_session'][$script_case_init]['blank_email_pruebas']['sc_outra_jan'] = true; unset($_SESSION['scriptcase']['sc_outra_jan']); } $_SESSION['sc_session'][$script_case_init]['blank_email_pruebas']['menu_desenv'] = false; if (!defined("SC_ERROR_HANDLER")) { define("SC_ERROR_HANDLER", 1); include_once(dirname(__FILE__) . "/blank_email_pruebas_erro.php"); } if (!empty($nmgp_parms)) { $nmgp_parms = str_replace("@aspass@", "'", $nmgp_parms); $nmgp_parms = str_replace("*scout", "?@?", $nmgp_parms); $nmgp_parms = str_replace("*scin", "?#?", $nmgp_parms); $todox = str_replace("?#?@?@?", "?#?@ ?@?", $nmgp_parms); $todo = explode("?@?", $todox); $ix = 0; while (!empty($todo[$ix])) { $cadapar = explode("?#?", $todo[$ix]); if (1 < sizeof($cadapar)) { if (substr($cadapar[0], 0, 11) == "SC_glo_par_") { $cadapar[0] = substr($cadapar[0], 11); $cadapar[1] = $_SESSION[$cadapar[1]]; } nm_limpa_str_blank_email_pruebas($cadapar[1]); if ($cadapar[1] == "@ ") {$cadapar[1] = trim($cadapar[1]); } $Tmp_par = $cadapar[0];; $$Tmp_par = $cadapar[1]; } $ix++; } if (isset($usr_perfil)) { $_SESSION['usr_perfil'] = $usr_perfil; nm_limpa_str_blank_email_pruebas($_SESSION["usr_perfil"]); } if (isset($idempresa)) { $_SESSION['idempresa'] = $idempresa; nm_limpa_str_blank_email_pruebas($_SESSION["idempresa"]); } } $GLOBALS["NM_ERRO_IBASE"] = 0; $contr_blank_email_pruebas = new blank_email_pruebas_apl(); $contr_blank_email_pruebas->controle(); // function nm_limpa_str_blank_email_pruebas(&$str) { } ?>
Save
cmd:
run