/
home
/
suroeste
/
public_html
/
gorbus.transportessuroeste.com
/
suroeste
/
blank_despacho
/
/home/suroeste/public_html/gorbus.transportessuroeste.com/suroeste/blank_despacho
mkdir
upload
Name
Size
Mode
Actions
blank_despacho.htm
125
0644
edit
dl
rm
blank_despacho.php
62
0644
edit
dl
rm
blank_despacho_det_ltr.css
0
0644
edit
dl
rm
blank_despacho_det_rtl.css
0
0644
edit
dl
rm
blank_despacho_download.php
1877
0644
edit
dl
rm
blank_despacho_erro.class.php
1416
0644
edit
dl
rm
blank_despacho_erro.php
7886
0644
edit
dl
rm
blank_despacho_fil_ltr.css
0
0644
edit
dl
rm
blank_despacho_fil_rtl.css
0
0644
edit
dl
rm
blank_despacho_grid_ltr.css
0
0644
edit
dl
rm
blank_despacho_grid_rtl.css
0
0644
edit
dl
rm
blank_despacho_json.php
37028
0644
edit
dl
rm
blank_despacho_message.js
15230
0644
edit
dl
rm
blank_despacho_res_ltr.css
0
0644
edit
dl
rm
blank_despacho_res_rtl.css
0
0644
edit
dl
rm
blank_despacho_session.php
3065
0644
edit
dl
rm
blank_despacho_teste.php
46
0644
edit
dl
rm
index.php
165773
0644
edit
dl
rm
Edit:
/home/suroeste/public_html/gorbus.transportessuroeste.com/suroeste/blank_despacho/index.php
(165773B)
<?php include_once('blank_despacho_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_despacho']['glo_nm_perfil'] = "conn_mysql"; $_SESSION['scriptcase']['blank_despacho']['glo_nm_path_prod'] = ""; $_SESSION['scriptcase']['blank_despacho']['glo_nm_path_conf'] = ""; $_SESSION['scriptcase']['blank_despacho']['glo_nm_path_imagens'] = ""; $_SESSION['scriptcase']['blank_despacho']['glo_nm_path_imag_temp'] = ""; $_SESSION['scriptcase']['blank_despacho']['glo_nm_path_cache'] = ""; $_SESSION['scriptcase']['blank_despacho']['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_despacho']['glo_nm_path_prod'])) { /*check prod*/$_SESSION['scriptcase']['blank_despacho']['glo_nm_path_prod'] = $str_path_apl_url . "_lib/prod"; } //check img if(empty($_SESSION['scriptcase']['blank_despacho']['glo_nm_path_imagens'])) { /*check img*/$_SESSION['scriptcase']['blank_despacho']['glo_nm_path_imagens'] = $str_path_apl_url . "_lib/file/img"; } //check tmp if(empty($_SESSION['scriptcase']['blank_despacho']['glo_nm_path_imag_temp'])) { /*check tmp*/$_SESSION['scriptcase']['blank_despacho']['glo_nm_path_imag_temp'] = $str_path_apl_url . "_lib/tmp"; } //check cache if(empty($_SESSION['scriptcase']['blank_despacho']['glo_nm_path_cache'])) { /*check tmp*/$_SESSION['scriptcase']['blank_despacho']['glo_nm_path_cache'] = $str_path_apl_dir . "_lib/file/cache"; } //check doc if(empty($_SESSION['scriptcase']['blank_despacho']['glo_nm_path_doc'])) { /*check doc*/$_SESSION['scriptcase']['blank_despacho']['glo_nm_path_doc'] = $str_path_apl_dir . "_lib/file/doc"; } //end check publication with the prod // class blank_despacho_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_despacho']['decimal_db'] = "."; $this->nm_cod_apl = "blank_despacho"; $this->nm_nome_apl = "Imprime Despacho"; $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 = "20230626"; $this->nm_hr_criacao = "115143"; $this->nm_autor_alt = "admin"; $this->nm_dt_ult_alt = "20260612"; $this->nm_hr_ult_alt = "095105"; $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_despacho']['glo_nm_path_prod']; $this->path_conf = $_SESSION['scriptcase']['blank_despacho']['glo_nm_path_conf']; $this->path_imagens = $_SESSION['scriptcase']['blank_despacho']['glo_nm_path_imagens']; $this->path_imag_temp = $_SESSION['scriptcase']['blank_despacho']['glo_nm_path_imag_temp']; $this->path_cache = $_SESSION['scriptcase']['blank_despacho']['glo_nm_path_cache']; $this->path_doc = $_SESSION['scriptcase']['blank_despacho']['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_despacho']['save_session']['save_grid_state_session'])) { $_SESSION['scriptcase']['blank_despacho']['save_session']['save_grid_state_session'] = false; $_SESSION['scriptcase']['blank_despacho']['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_despacho']['sub_cons_schema_all'])) { $this->str_schema_all = $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['sub_cons_schema_all']; $this->str_schema_filter = $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['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_despacho'; $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_despacho']['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_despacho']['session_timeout']['lang'])) { $this->str_lang = $_SESSION['scriptcase']['blank_despacho']['session_timeout']['lang']; } elseif (!isset($_SESSION['scriptcase']['blank_despacho']['actual_lang']) || $_SESSION['scriptcase']['blank_despacho']['actual_lang'] != $this->str_lang) { $_SESSION['scriptcase']['blank_despacho']['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_despacho_json.php"); } $this->SC_Link_View = (isset($_SESSION['sc_session'][$this->sc_page]['blank_despacho']['SC_Link_View'])) ? $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['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_despacho']['embutida']) { $this->SC_Link_View = true; $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['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_despacho']['glo_nm_path_imag_temp'] . $file_name; $orig_img = $_SESSION['scriptcase']['blank_despacho']['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_despacho']['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_despacho']['dashboard_info']['under_dashboard'])) { $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['dashboard_info']['under_dashboard'] = false; $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['dashboard_info']['dashboard_app'] = ''; $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['dashboard_info']['own_widget'] = ''; $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['dashboard_info']['parent_widget'] = ''; $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['dashboard_info']['compact_mode'] = false; $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['dashboard_info']['remove_margin'] = false; $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['dashboard_info']['remove_border'] = false; $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['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_despacho']['dashboard_info']['own_widget'] = $_GET['own_widget']; $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['dashboard_info']['under_dashboard'] = true; if (isset($_GET['dashboard_app'])) { $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['dashboard_info']['dashboard_app'] = $_GET['dashboard_app']; } if (isset($_GET['parent_widget'])) { $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['dashboard_info']['parent_widget'] = $_GET['parent_widget']; } if (isset($_GET['compact_mode'])) { $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['dashboard_info']['compact_mode'] = 1 == $_GET['compact_mode']; } if (isset($_GET['remove_margin'])) { $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['dashboard_info']['remove_margin'] = 1 == $_GET['remove_margin']; } if (isset($_GET['remove_border'])) { $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['dashboard_info']['remove_border'] = 1 == $_GET['remove_border']; } if (isset($_GET['remove_background'])) { $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['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_despacho']['dashboard_info']['own_widget'] = $own_widget; $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['dashboard_info']['under_dashboard'] = true; if (isset($dashboard_app)) { $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['dashboard_info']['dashboard_app'] = $dashboard_app; } if (isset($parent_widget)) { $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['dashboard_info']['parent_widget'] = $parent_widget; } if (isset($compact_mode)) { $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['dashboard_info']['compact_mode'] = 1 == $compact_mode; } if (isset($remove_margin)) { $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['dashboard_info']['remove_margin'] = 1 == $remove_margin; } if (isset($remove_border)) { $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['dashboard_info']['remove_border'] = 1 == $remove_border; } if (isset($remove_background)) { $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['dashboard_info']['remove_background'] = 1 == $remove_background; } } } if (!isset($_SESSION['sc_session'][$this->sc_page]['blank_despacho']['dashboard_info']['maximized'])) { $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['dashboard_info']['maximized'] = false; } if (isset($_GET['maximized'])) { $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['dashboard_info']['maximized'] = 1 == $_GET['maximized']; } if ($_SESSION['sc_session'][$this->sc_page]['blank_despacho']['dashboard_info']['under_dashboard']) { $sTmpDashboardApp = $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['dashboard_info']['dashboard_app']; if ('' != $sTmpDashboardApp && isset($_SESSION['scriptcase']['dashboard_targets'][$sTmpDashboardApp]["blank_despacho"])) { foreach ($_SESSION['scriptcase']['dashboard_targets'][$sTmpDashboardApp]["blank_despacho"] 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_despacho']['link_info'] = array(); } if (isset($link_compact_mode) && 'ok' == $link_compact_mode) { $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['link_info']['compact_mode'] = true; } if (isset($link_remove_margin) && 'ok' == $link_remove_margin) { $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['link_info']['remove_margin'] = true; } if (isset($link_remove_border) && 'ok' == $link_remove_border) { $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['link_info']['remove_border'] = true; } if (isset($link_remove_background) && 'ok' == $link_remove_background) { $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['link_info']['remove_background'] = true; } if (isset($link_margin_top) && '' != $link_margin_top) { $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['link_info']['margin_top'] = $link_margin_top; } if (!isset($_SESSION['sc_session'][$this->sc_page]['blank_despacho']['responsive_chart'])) { $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['responsive_chart'] = array( 'enabled' => false, 'active' => false, ); } if ($_SESSION['sc_session'][$this->sc_page]['blank_despacho']['responsive_chart']['enabled']) { $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['responsive_chart']['active'] = true; } elseif ($_SESSION['sc_session'][$this->sc_page]['blank_despacho']['dashboard_info']['under_dashboard'] && $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['dashboard_info']['compact_mode'] && !$_SESSION['sc_session'][$this->sc_page]['blank_despacho']['dashboard_info']['maximized']) { $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['responsive_chart']['active'] = true; } else { $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['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_despacho']['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_despacho']['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_despacho']['csrf_token'] ) && !isset($_SESSION['sc_session'][$this->sc_page]['blank_despacho']['embutida']) && !isset($_SESSION['sc_session'][$this->sc_page]['blank_despacho']['embutida_form'])) { if (!isset($_POST['csrf_token']) || $_POST['csrf_token'] != $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['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_despacho']['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_despacho']['iframe_menu'] && (!isset($_SESSION['sc_session'][$script_case_init]['blank_despacho']['sc_outra_jan']) || !$_SESSION['sc_session'][$script_case_init]['blank_despacho']['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_despacho_erro.class.php"); $this->Erro = new blank_despacho_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_despacho'); // $this->sc_Include($this->path_lib_php . "/nm_functions.php", "", "") ; global $bol_api_prod; $bol_api_prod = true; if (isset($_SESSION['scriptcase']['blank_despacho']['glo_nm_conexao']) && !empty($_SESSION['scriptcase']['blank_despacho']['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_despacho']['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_despacho']['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_despacho']['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_despacho']['session_timeout']['redir_tp'] == "R") { $SS_cod_html .= " sc_session_redir('" . $_SESSION['scriptcase']['blank_despacho']['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_despacho']['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_despacho']['seq_dir'] = 0; $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['sub_dir'] = array(); $_SESSION['scriptcase']['nm_bases_security'] = "enc_nm_enc_v1DcBwZSFGHANOVWXGHuvmDkBsV5F/VoX7DcJUH9BOHArYV5XGHgNKHErsDWFqDoraHQJKDQJsZ1vCV5FGHuNOV9FeDWB3VoF7HQBiZkBiDSNOHQFGHgrKHErsDuJeHMB/DcXGZ9JeZ1BYHuJeDMNODkB/DWF/HIJsDcNmZ1FUZ1rYHQX7HgNKHErCDuX/DoJeHQNwZ9JeZ1zGVWBqDMvsV9BUDuX7HMF7HQBiZkFUD1rwV5FGDEBeHEXeH5X/DoF7HQNwDQBqDSN7HuBiDMzGVIBsDuX7HMF7HQNwZkFUZ1rYHQFaDMvCDkXKHEFqDoJsHQFYDQBOZ1BYHuraDMBOV9FeDWF/HMFUHQBiZkFUZ1rYHuJwHgBeZSJ3DuFaHIXGHQXODuBOD1BeD5rqHuvmVcBOH5B7VoBqHQXOZkBiDSNOD5JwHgBeHEJqDWr/HMX7DcBiDuBOZ1BYHuBODMBYVcXKDWBmVEF7HQXGVIJwZ1rYHuXGHgveZSJ3DWrGDoJeHQFYDQBOZ1BYHQB/DMvmDkB/DuFGVEFGHQBsVIJwD1rwV5FGDEBeHEXeH5X/DoF7D9NwZSX7D1BeV5raHuzGVcFKDWFaVENUD9JmZ1X7Z1BeHQX7HgBYDkFeV5FaHMJsD9NwH9X7Z1rwD5XGHuzGVIBODWFaDoXGDcBwZ1FGHANOV5JeDEBOHEFiDWFqDoXGHQXGZSBiZ1N7D5JwHuBYVcFeV5FYVoB/D9JmH9B/D1zGD5FaDEvsDkXKHEB7VoFGD9NwDQJsHIrKV5JeDMvsVcBUDWXKVoraD9BiH9FaHIBeZMBODErKVkXeV5FaDoB/D9NmDQBOZ1rwV5BqHgvsDkFCDWJeDoFGD9XOZ1rqD1rKD5rqDMBYHEJGH5FYVoB/HQXGZ9rqD1BeD5rqHuvmVcBOH5B7VoBqD9XOH9B/D1rwD5BiDEBeHEFiV5FaDoXGD9NmDQB/Z1rwHuNUDMNOVcB/H5FqHIraDcFYZ1FGZ1BeHuJwHgvCHArCV5B3DoBqHQNwZ9XGDSBYHuFUDMvmVIBsDWFYHMBiD9BsVIraD1rwV5X7HgBeHErsH5F/ZuXGHQBiZSFUZ1rwHuraHuzGVIB/DuX7HMBOHQNwZSBOHArYHQBODEvsVkJ3DWF/VoBiDcJUZSX7Z1BYHuFaDMrwDkBODWJeDoJeDcBqZ1B/Z1NOV5JsDMNKZSXeH5F/VoB/D9NwZSFGHAveV5FUHgvsDkBODur/VoraHQFYZSFaHArKV5XGDErKHErCDWF/VoBiDcJUZSX7Z1BYHuFaDMvmVcFKV5BmVoBqD9BsZkFGHArKHuFGHgvsVkXeHEFaDoF7HQNmZSX7Z1rwD5JeHgvOVIB/HEF/DoFUDcFYZ1FGHArKV5FUDMrYZSXeV5FqHIJsD9NwDQJsHABYV5raHuNOVcFCHEFYVoFGD9XOZ1B/HIrwD5BiDMBYVkJGDWr/DoB/D9XsH9FGDSN7D5JwDMvmVcFKV5BmVoBqD9BsZkFGHAvsD5XGHgveHErsDWrGZuBOHQBiDQBqHAvCV5XGDMrYDkBsDWXCDoJsDcBwH9B/Z1rYHQJwDEBeDkB/DuFaVoB/D9NmH9FGHAvOVWBqHuBYVIBODWF/HIFUHQBsZSBqD1rKHQFUHgBOHEBUH5F/HIJsD9XsZ9JeD1BeD5F7DMvmVcFKV5F/DoraD9BsZ1rqD1rwD5FaDEBODkFeV5XCDoJeD9XsZSX7D1veV5FUHuzGDkBsDWXCDoF7D9BsZ1B/HABYV5JeDEBOHEFKV5XCDoF7D9XsZSX7Z1BYHuFaHuNOZSrCH5FqDoXGHQJmZ1BiDSvOV5FUHgveHEBOV5JeZura"; $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_despacho']['iframe_menu'] && (!isset($_SESSION['sc_session'][$script_case_init]['blank_despacho']['sc_outra_jan']) || !$_SESSION['sc_session'][$script_case_init]['blank_despacho']['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_despacho']['glo_nm_conexao']) && $_SESSION['scriptcase']['blank_despacho']['glo_nm_conexao'] == $NM_con_orig) { /*NM*/ $_SESSION['scriptcase']['blank_despacho']['glo_nm_conexao'] = $NM_con_dest; } if (isset($_SESSION['scriptcase']['blank_despacho']['glo_nm_perfil']) && $_SESSION['scriptcase']['blank_despacho']['glo_nm_perfil'] == $NM_con_orig) { /*NM*/ $_SESSION['scriptcase']['blank_despacho']['glo_nm_perfil'] = $NM_con_dest; } if (isset($_SESSION['scriptcase']['blank_despacho']['glo_con_' . $NM_con_orig])) { $_SESSION['scriptcase']['blank_despacho']['glo_con_' . $NM_con_orig] = $NM_con_dest; } } } $con_devel = (isset($_SESSION['scriptcase']['blank_despacho']['glo_nm_conexao'])) ? $_SESSION['scriptcase']['blank_despacho']['glo_nm_conexao'] : ""; $perfil_trab = ""; $this->nm_falta_var = ""; $this->nm_falta_var_db = ""; $nm_crit_perfil = false; if (isset($_SESSION['scriptcase']['blank_despacho']['glo_nm_conexao']) && !empty($_SESSION['scriptcase']['blank_despacho']['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_despacho']['glo_nm_perfil']) && !empty($_SESSION['scriptcase']['blank_despacho']['glo_nm_perfil'])) { $perfil_trab = $_SESSION['scriptcase']['blank_despacho']['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_despacho']['embutida_init']) || !$_SESSION['sc_session'][$this->sc_page]['blank_despacho']['embutida_init']) { if (!isset($_SESSION['idturno'])) { $this->nm_falta_var .= "idturno; "; } } // 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_despacho']['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_despacho']['SC_sep_date'] = substr($SC_temp, 0, 1); $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['SC_sep_date1'] = substr($SC_temp, 1, 1); } else { $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['SC_sep_date'] = $SC_temp; $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['SC_sep_date1'] = $SC_temp; } $this->date_delim = $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['SC_sep_date']; $this->date_delim1 = $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['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_despacho']['iframe_menu'] && (!isset($_SESSION['sc_session'][$script_case_init]['blank_despacho']['sc_outra_jan']) || !$_SESSION['sc_session'][$script_case_init]['blank_despacho']['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_despacho']['glo_nm_conexao']) && !empty($_SESSION['scriptcase']['blank_despacho']['glo_nm_conexao'])) { $this->Db = db_conect_devel($_SESSION['scriptcase']['blank_despacho']['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_despacho']['embutida']) || !$_SESSION['sc_session'][$this->sc_page]['blank_despacho']['embutida']) { if (substr($_POST['nmgp_opcao'], 0, 5) == "ajax_") { ob_start(); } } if (!isset($_SESSION['sc_session'][$this->sc_page]['blank_despacho']['embutida']) || !$_SESSION['sc_session'][$this->sc_page]['blank_despacho']['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_despacho']['csrf_token'])) { $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['csrf_token'] = $this->scCsrfGenerateToken(); } return $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['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_despacho']['SC_sep_date']) && !empty($_SESSION['sc_session'][$this->sc_page]['blank_despacho']['SC_sep_date'])) { $delim = $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['SC_sep_date']; $delim1 = $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['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_despacho']['SC_Gb_date_format'][$GB][$cmp])) ? $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['SC_Gb_date_format'][$GB][$cmp] : ""; } function Get_Gb_prefix_date_format($GB, $cmp) { return (isset($_SESSION['sc_session'][$this->sc_page]['blank_despacho']['SC_Gb_prefix_date_format'][$GB][$cmp])) ? $_SESSION['sc_session'][$this->sc_page]['blank_despacho']['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_despacho_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_despacho_ini(); $this->Ini->init(); $this->Change_Menu = false; if (isset($_SESSION['scriptcase']['menu_atual']) && (!isset($_SESSION['sc_session'][$this->Ini->sc_page]['blank_despacho']['sc_outra_jan']) || !$_SESSION['sc_session'][$this->Ini->sc_page]['blank_despacho']['sc_outra_jan'])) { $this->sc_init_menu = "x"; if (isset($_SESSION['scriptcase'][$_SESSION['scriptcase']['menu_atual']]['sc_init']['blank_despacho'])) { $this->sc_init_menu = $_SESSION['scriptcase'][$_SESSION['scriptcase']['menu_atual']]['sc_init']['blank_despacho']; } 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_despacho'])) { $_SESSION['scriptcase']['menu_apls'][$_SESSION['scriptcase']['menu_atual']][$this->sc_init_menu]['blank_despacho']['link'] = $this->Ini->sc_protocolo . $this->Ini->server . $this->Ini->path_link . "" . SC_dir_app_name('blank_despacho') . "/"; $_SESSION['scriptcase']['menu_apls'][$_SESSION['scriptcase']['menu_atual']][$this->sc_init_menu]['blank_despacho']['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_despacho") { $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_despacho']['exit']) && $_SESSION['scriptcase']['sc_apl_conf']['blank_despacho']['exit'] != '') { $_SESSION['scriptcase']['sc_url_saida'][$this->Ini->sc_page] = $_SESSION['scriptcase']['sc_apl_conf']['blank_despacho']['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); $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_despacho_erro.class.php"); $this->Erro = new blank_despacho_erro(); $this->Erro->Ini = $this->Ini; $old_dir = getcwd(); chdir($this->Ini->path_third . "/tcpdf/"); include_once("tcpdf.php"); chdir($old_dir); // header("X-XSS-Protection: 1; mode=block"); header("X-Frame-Options: SAMEORIGIN"); /*----- Scriptcase Locale: Event onExecute ------*/ $_SESSION['scriptcase']['blank_despacho']['contr_erro'] = 'on'; if (!isset($_SESSION['idturno'])) {$_SESSION['idturno'] = "";} if (!isset($this->sc_temp_idturno)) {$this->sc_temp_idturno = (isset($_SESSION['idturno'])) ? $_SESSION['idturno'] : "";} $empresa = 1; $idturno = $this->sc_temp_idturno; $check_sql = "SELECT idestadoturno,fecha,horasalida,ruta" . " FROM enturnar" . " WHERE idturno = '" . $idturno . "'"; $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])) { $estado = $this->rs[0][0]; $fecha = $this->rs[0][1]; $hora = $this->rs[0][2]; $destino = $this->rs[0][3]; } else { $otroa1 = ''; $other_region = ''; } if ($estado == 2) { $check_sql = "SELECT idlibro,idturno,idvehiculo,vrtiquetes,vrseguro,vrindycom,vrfondo,vrotros1,vrotros2,vrotros3,vrconductor,idconductor,anulado,vrempresaencomi,vrventaencomi,numpasajeros,vrpalconductor,idtaquilla,idusuario,idoficina,numlibro" . " FROM librosdespacho" . " WHERE idturno = '" . $idturno . "'"; $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])) { $libro = $this->rs[0][0]; $idturno = $this->rs[0][1]; $idvehiculo = $this->rs[0][2]; $vrtiquetes = $this->rs[0][3]; $vrseguro = $this->rs[0][4]; $vrindycom = $this->rs[0][5]; $vrfondo = $this->rs[0][6]; $vrotros1 = $this->rs[0][7]; $vrotros2 = $this->rs[0][8]; $vrotros3 = $this->rs[0][9]; $vrconductor = $this->rs[0][10]; $idconductor = $this->rs[0][11]; $anulado = $this->rs[0][12]; $vrempresaencomi = $this->rs[0][13]; $vrventaencomi = $this->rs[0][14]; $numpasajeros = $this->rs[0][15]; $vrpalconductor = $this->rs[0][16]; $idtaquilla = $this->rs[0][17]; $idusuario = $this->rs[0][18]; $idoficina = $this->rs[0][19]; $numlibro = $this->rs[0][20]; } else { $other_field = ''; $other_region = ''; } $check_sql = "SELECT documento,nombre" . " FROM terceros" . " WHERE idtercero = '" . $idconductor . "'"; $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])) { $documento = $this->rs[0][0]; $conductor = $this->rs[0][1]; } else { $other_field = ''; $other_region = ''; } $conductor = substr($conductor, 0, 35); $check_sql = "SELECT idtipovehiculo,placa" . " FROM vehiculos" . " WHERE idvehiculo = '" . $idvehiculo . "'"; $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])) { $idtipovehiculo = $this->rs[0][0]; $placa = $this->rs[0][1]; } else { $other_field = ''; $other_region = ''; } $check_sql = "SELECT tipodevehiculo" . " FROM tiposdevehiculos" . " WHERE idtipovehiculo = '" . $idtipovehiculo . "'"; $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])) { $tipovehiculo = $this->rs[0][0]; } else { $other_field = ''; $other_region = ''; } $descuentos = $vrotros1 + $vrotros2 + $vrotros3; $encomiconductor = $vrventaencomi - $vrempresaencomi ; $check_sql = "SELECT empresa,nit" . " FROM empresas" . " WHERE idempresa = '" . $empresa . "'"; $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])) { $empresa = $this->rs[0][0]; $nit = $this->rs[0][1]; } else { $other_field = ''; $other_region = ''; } $check_sql = "SELECT nomoficina" . " FROM oficinas" . " WHERE idoficina = '" . $idoficina . "'"; $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])) { $ofi = $this->rs[0][0]; } else { $other_field = ''; $other_region = ''; } $check_sql = "SELECT nomtaquilla" . " FROM taquillas" . " WHERE idtaquilla = '" . $idtaquilla . "'"; $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])) { $taquilla = $this->rs[0][0]; } else { $other_field = ''; $other_region = ''; } $oficina = $ofi." - ".$taquilla; if($anulado == 1){ $oficina = "***** LIBRO ANULADO ******"; } $pdf = new tcpdf($orientation ='',$unit='mm', array(80,120)); $pdf->AddPage(); $pdf->SetFont('times','B',9); $pdf->setXY(12,0); $pdf->Cell(1,5,''.$empresa); $pdf->setXY(6,3); $pdf->Cell(1,5,' '.$nit); $pdf->setXY(10,6); $pdf->Cell(1,5,' '.$oficina); $pdf->SetFont('Times','',9); $pdf->setXY(5,6); $pdf->Cell(4,15,'Libro No:',0,0); $pdf->setXY(35,6); $pdf->Cell(4,15,$numlibro,0,0); $pdf->setXY(5,10); $pdf->Cell(4,15,'Fecha Viaje:',0,0); $pdf->setXY(35,10); $pdf->Cell(4,15,$fecha,0,0); $pdf->setXY(5,14); $pdf->Cell(4,15,'Hora Salida:',0,0); $pdf->setXY(35,14); $pdf->Cell(4,15,$hora,0,0); $pdf->setXY(5,18); $pdf->Cell(4,15,'Tipo Vehículo:',0,0); $pdf->setXY(35,18); $pdf->Cell(4,15,$tipovehiculo,0,0); $pdf->setXY(5,22); $pdf->Cell(4,15,'Destino:',0,0); $pdf->setXY(35,22); $pdf->Cell(4,15,$destino,0,0); $pdf->setXY(5,26); $pdf->Cell(4,15,'Placa:',0,0); $pdf->setXY(35,26); $pdf->Cell(4,15,$placa,0,0); $pdf->setXY(5,30); $pdf->Cell(4,15,'Conductor:',0,0); $pdf->setXY(5,34); $pdf->Cell(4,15,$conductor,0,0); $pdf->setXY(5,38); $pdf->Cell(4,15,'Venta Tiquetes:',0,0); $pdf->setXY(43,38); $pdf->Cell(4,15,"$ ".number_format($vrtiquetes,0,".",",") ,0,0,"R"); $pdf->setXY(5,42); $pdf->Cell(4,15,'Otros Descuentos:',0,0); $pdf->setXY(43,42); $pdf->Cell(4,15,"$ ".number_format($descuentos,0,".",",") ,0,0,"R"); $pdf->setXY(5,46); $pdf->Cell(4,15,'Seguro:',0,0); $pdf->setXY(43,46); $pdf->Cell(4,15,"$ ".number_format($vrseguro,0,".",",") ,0,0,"R"); $pdf->setXY(5,50); $pdf->Cell(4,15,'Industria y Ccio:',0,0); $pdf->setXY(43,50); $pdf->Cell(4,15,"$ ".number_format($vrindycom,0,".",",") ,0,0,"R"); $pdf->setXY(5,54); $pdf->Cell(4,15,'Fondo Reposicion:',0,0); $pdf->setXY(43,54); $pdf->Cell(4,15,"$ ".number_format($vrfondo,0,".",",") ,0,0,"R"); $pdf->setXY(5,58); $pdf->Cell(4,15,'Recibe x Pasajes:',0,0); $pdf->setXY(43,58); $pdf->Cell(4,15,"$ ".number_format($vrconductor,0,".",",") ,0,0,"R"); $pdf->setXY(5,62); $pdf->Cell(4,15,'Venta Encomiendas:',0,0); $pdf->setXY(43,62); $pdf->Cell(4,15,"$ ".number_format($vrventaencomi,0,".",",") ,0,0,"R"); $pdf->setXY(5,66); $pdf->Cell(4,15,'Recibe x Encomiendas:',0,0); $pdf->setXY(43,66); $pdf->Cell(4,15,"$ ".number_format($encomiconductor,0,".",",") ,0,0,"R"); $pdf->setXY(5,70); $pdf->Cell(4,15,'Numero Pasajeros:',0,0); $pdf->setXY(35,70); $pdf->Cell(4,15,$numpasajeros,0,0); $pdf->setXY(5,74); $pdf->Cell(4,15,'Por Pagar:',0,0); $pdf->setXY(43,74); $pdf->Cell(4,15,"$ ".number_format($vrpalconductor,0,".",",") ,0,0,"R"); $pdf->setXY(5,78); $pdf->Cell(4,15,'-----------------------------------------------------------',0,0); $pdf->setXY(5,82); $pdf->Cell(4,15,' LIBRO DE VIAJE',0,0); if ($numpasajeros > 0) { $pdf->AddPage(); $pdf->SetFont('times','B',8); $pdf->setXY(12,0); $pdf->Cell(1,5,''.$empresa); $pdf->setXY(6,3); $pdf->Cell(1,5,' '.$nit); $pdf->setXY(10,6); $pdf->Cell(1,5,' '.$oficina); $pdf->SetFont('Times','',8); $pdf->setXY(5,6); $pdf->Cell(5,11,' LISTA DE PASAJEROS'); $pdf->setXY(2,8); $pdf->Cell(2,17,"PSTO PASAJERO TELEFONO DESTINO"); $pdf->Cell(5,20,"--------------------------------------------------------------------"); $textypos+=11; $off = $textypos+6; $sql = "SELECT puesto,documento,destino,idrecogeren FROM tiquetes WHERE idturno =". $idturno; $nm_select = $sql; $_SESSION['scriptcase']['sc_sql_ult_comando'] = $nm_select; $_SESSION['scriptcase']['sc_sql_ult_conexao'] = ''; if ($this->ds = $this->Db->Execute($nm_select)) { } elseif (isset($GLOBALS["NM_ERRO_IBASE"]) && $GLOBALS["NM_ERRO_IBASE"] != 1) { $this->ds = false; $this->ds_erro = $this->Db->ErrorMsg(); } if ($this->ds === false){ echo "Error al acceder a la base por = ". $this->ds_erro ; } else { while (!$this->ds->EOF) { $puesto = $this->ds->fields["puesto"]; $documento = $this->ds->fields["documento"]; $destino = $this->ds->fields["destino"]; $idrecogeren = $this->ds->fields["idrecogeren"]; $check_sql = "SELECT nombre,celular" . " 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]; $telefono = $this->rs[0][1]; } else { $other_field = ''; $other_region = ''; } $pdf->setXY(5,$off); $pdf->Cell(5,8,$puesto,0,0); $nom = substr($nombre,0,15); $pdf->Cell(8,8,$nom,0,0); $pdf->setXY(42,$off); $pdf->Cell(8,8,$telefono); $pdf->setXY(60,$off); $dest = substr($destino,0,11); $pdf->Cell(8,8,$dest); $off+=3; $this->ds->MoveNext(); } $this->ds->Close(); } $check_sql = "SELECT idrecogeren" . " FROM tiquetes" . " WHERE idturno = '" . $idturno . "' and idrecogeren > '0'"; $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])) { $recoger = $this->rs[0][0]; $other_region = $this->rs[0][1]; } else { $other_field = ''; $other_region = ''; } if ($recoger > 0) { $pdf->AddPage(); $pdf->SetFont('times','B',9); $pdf->setXY(12,0); $pdf->Cell(1,5,' '.$empresa); $pdf->setXY(6,3); $pdf->Cell(1,5,' '.$nit); $pdf->setXY(10,6); $pdf->Cell(1,5,''.$oficina); $pdf->SetFont('Times','',9); $pdf->setXY(5,6); $pdf->Cell(5,11,' LISTA DE PASAJEROS A RECOGER'); $pdf->setXY(2,8); $pdf->Cell(2,17,"PSTO PASAJERO RECOGER EN"); $pdf->Cell(5,20,"----------------------------------------------------------------------------------------"); $textypos+=1; $off = $textypos+5; $sql = "SELECT puesto,documento,destino,idrecogeren FROM tiquetes WHERE idturno = '" . $idturno . "' and idrecogeren > '0'"; $nm_select = $sql; $_SESSION['scriptcase']['sc_sql_ult_comando'] = $nm_select; $_SESSION['scriptcase']['sc_sql_ult_conexao'] = ''; if ($this->ds = $this->Db->Execute($nm_select)) { } elseif (isset($GLOBALS["NM_ERRO_IBASE"]) && $GLOBALS["NM_ERRO_IBASE"] != 1) { $this->ds = false; $this->ds_erro = $this->Db->ErrorMsg(); } if ($this->ds === false){ echo "Error al acceder a la base por = ". $this->ds_erro ; } else { while (!$this->ds->EOF) { $puesto = $this->ds->fields["puesto"]; $documento = $this->ds->fields["documento"]; $destino = $this->ds->fields["destino"]; $idrecogeren = $this->ds->fields["idrecogeren"]; $check_sql = "SELECT nombre,celular" . " 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]; $telefono = $this->rs[0][1]; } else { $other_field = ''; $other_region = ''; } $check_sql = "SELECT recogeren" . " FROM recogeren" . " WHERE idrecogeren = '" . $idrecogeren . "'"; $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])) { $recogeren = $this->rs[0][0]; } else { $other_field = ''; $other_region = ''; } $pdf->setXY(5,$off); $pdf->Cell(5,8,$puesto,0,0); $nom = substr($nombre,0,15); $pdf->Cell(8,8,$nom,0,0); $pdf->setXY(50,$off); $dest = substr($recogeren,0,18); $pdf->Cell(8,8,$dest); $off+=3; $this->ds->MoveNext(); } $this->ds->Close(); } } } $anulado = 0; if ($vrventaencomi > 0) { $pdf->AddPage(); $pdf->SetFont('times','B',9); $pdf->setXY(12,0); $pdf->Cell(1,5,''.$empresa); $pdf->setXY(6,3); $pdf->Cell(1,5,' '.$nit); $pdf->setXY(10,6); $pdf->Cell(1,5,''.$oficina); $pdf->SetFont('Times','',9); $pdf->setXY(5,6); $pdf->Cell(5,11,' LISTA DE ENCOMIENDAS'); $pdf->setXY(2,6); $pdf->Cell(2,17,"DESTINATARIO EMPAQUE CANT DESTINO "); $pdf->Cell(5,20,"---------------------------------------------------------------------------"); $textypos+=4; $off = $textypos+1; $sql = "SELECT docudestina,empaque,cantidad,idoficinadestino FROM encomiendas WHERE idturno ='" . $idturno . "' and anulado = '" . $anulado . "'" ; $nm_select = $sql; $_SESSION['scriptcase']['sc_sql_ult_comando'] = $nm_select; $_SESSION['scriptcase']['sc_sql_ult_conexao'] = ''; if ($this->ds = $this->Db->Execute($nm_select)) { } elseif (isset($GLOBALS["NM_ERRO_IBASE"]) && $GLOBALS["NM_ERRO_IBASE"] != 1) { $this->ds = false; $this->ds_erro = $this->Db->ErrorMsg(); } if ($this->ds === false){ echo "Error al acceder a la base por = ". $this->ds_erro ; } else { while (!$this->ds->EOF) { $docudestina = $this->ds->fields["docudestina"]; $empaque = $this->ds->fields["empaque"]; $cantidad = $this->ds->fields["cantidad"]; $idoficina = $this->ds->fields["idoficinadestino"]; $check_sql = "SELECT nombre" . " FROM terceros" . " WHERE documento = '" . $docudestina . "'"; $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]; } else { $other_field = ''; $other_region = ''; } $check_sql = "SELECT empaque" . " FROM empaques" . " WHERE idempaque = '" . $empaque . "'"; $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])) { $empaque = $this->rs[0][0]; } else { $other_field = ''; $other_region = ''; } $pdf->setXY(2,$off); $pdf->Cell(5,8,$nombre,0,0); $pdf->setXY(35,$off); $pdf->Cell(5,8,$empaque,0,0); $pdf->setXY(55,$off); $pdf->Cell(8,8,$cantidad); $pdf->setXY(65,$off); $pdf->Cell(8,8,$ofi); $off+=3; $this->ds->MoveNext(); } $this->ds->Close(); } } $pdf->Output('documentos.pdf', 'I'); }else{ $this->nm_mens_alert[] = "Este vehículo no se ha despachado...!";$this->nm_params_alert[] = array();if (isset($this->Campos_Mens_erro) && !empty($this->Campos_Mens_erro)) { if (isset($this->sc_temp_idturno)) {$_SESSION['idturno'] = $this->sc_temp_idturno;} $this->Erro->mensagem(__FILE__, __LINE__, "critica", $this->Campos_Mens_erro); exit; } } if (isset($this->sc_temp_idturno)) {$_SESSION['idturno'] = $this->sc_temp_idturno;} $_SESSION['scriptcase']['blank_despacho']['contr_erro'] = 'off'; /*----- END - Scriptcase Locale: Event onExecute ------*/ $confirmButtonClass = ''; $cancelButtonClass = ''; $confirmButtonText = $this->Ini->Nm_lang['lang_btns_cfrm']; $cancelButtonText = $this->Ini->Nm_lang['lang_btns_cncl']; $confirmButtonFA = ''; $cancelButtonFA = ''; $confirmButtonFAPos = ''; $cancelButtonFAPos = ''; if (isset($this->arr_buttons['bsweetalert_ok']) && isset($this->arr_buttons['bsweetalert_ok']['style']) && '' != $this->arr_buttons['bsweetalert_ok']['style']) { $confirmButtonClass = 'scButton_' . $this->arr_buttons['bsweetalert_ok']['style']; } if (isset($this->arr_buttons['bsweetalert_cancel']) && isset($this->arr_buttons['bsweetalert_cancel']['style']) && '' != $this->arr_buttons['bsweetalert_cancel']['style']) { $cancelButtonClass = 'scButton_' . $this->arr_buttons['bsweetalert_cancel']['style']; } if (isset($this->arr_buttons['bsweetalert_ok']) && isset($this->arr_buttons['bsweetalert_ok']['value']) && '' != $this->arr_buttons['bsweetalert_ok']['value']) { $confirmButtonText = $this->arr_buttons['bsweetalert_ok']['value']; } if (isset($this->arr_buttons['bsweetalert_cancel']) && isset($this->arr_buttons['bsweetalert_cancel']['value']) && '' != $this->arr_buttons['bsweetalert_cancel']['value']) { $cancelButtonText = $this->arr_buttons['bsweetalert_cancel']['value']; } if (isset($this->arr_buttons['bsweetalert_ok']) && isset($this->arr_buttons['bsweetalert_ok']['fontawesomeicon']) && '' != $this->arr_buttons['bsweetalert_ok']['fontawesomeicon']) { $confirmButtonFA = $this->arr_buttons['bsweetalert_ok']['fontawesomeicon']; } if (isset($this->arr_buttons['bsweetalert_cancel']) && isset($this->arr_buttons['bsweetalert_cancel']['fontawesomeicon']) && '' != $this->arr_buttons['bsweetalert_cancel']['fontawesomeicon']) { $cancelButtonFA = $this->arr_buttons['bsweetalert_cancel']['fontawesomeicon']; } if (isset($this->arr_buttons['bsweetalert_ok']) && isset($this->arr_buttons['bsweetalert_ok']['display_position']) && 'img_right' != $this->arr_buttons['bsweetalert_ok']['display_position']) { $confirmButtonFAPos = 'text_right'; } if (isset($this->arr_buttons['bsweetalert_cancel']) && isset($this->arr_buttons['bsweetalert_cancel']['display_position']) && 'img_right' != $this->arr_buttons['bsweetalert_cancel']['display_position']) { $cancelButtonFAPos = 'text_right'; } ?> <script type="text/javascript"> var scSweetAlertConfirmButton = "<?php echo $confirmButtonClass ?>"; var scSweetAlertCancelButton = "<?php echo $cancelButtonClass ?>"; var scSweetAlertConfirmButtonText = "<?php echo $confirmButtonText ?>"; var scSweetAlertCancelButtonText = "<?php echo $cancelButtonText ?>"; var scSweetAlertConfirmButtonFA = "<?php echo $confirmButtonFA ?>"; var scSweetAlertCancelButtonFA = "<?php echo $cancelButtonFA ?>"; var scSweetAlertConfirmButtonFAPos = "<?php echo $confirmButtonFAPos ?>"; var scSweetAlertCancelButtonFAPos = "<?php echo $cancelButtonFAPos ?>"; </script> <script type="text/javascript" src="<?php echo $this->Ini->path_prod ?>/third/jquery/js/jquery.js"></script> <script type="text/javascript" src="<?php echo $this->Ini->path_prod ?>/third/jquery/js/jquery-ui.js"></script> <link rel="stylesheet" href="<?php echo $this->Ini->path_prod ?>/third/jquery/css/smoothness/jquery-ui.css" type="text/css" media="screen" /> <script type="text/javascript" src="<?php echo $_SESSION['scriptcase']['blank_despacho']['glo_nm_path_prod']; ?>/third/sweetalert/sweetalert2.all.min.js"></script> <script type="text/javascript" src="<?php echo $_SESSION['scriptcase']['blank_despacho']['glo_nm_path_prod']; ?>/third/sweetalert/polyfill.min.js"></script> <script type="text/javascript" src="../_lib/lib/js/frameControl.js"></script> <script type="text/javascript" src="blank_despacho_message.js"></script> <script type="text/javascript"> $(function() { <?php if (isset($this->nm_mens_alert) && count($this->nm_mens_alert)) { if (isset($this->Ini->nm_mens_alert) && !empty($this->Ini->nm_mens_alert)) { if (isset($this->nm_mens_alert) && !empty($this->nm_mens_alert)) { $this->nm_mens_alert = array_merge($this->Ini->nm_mens_alert, $this->nm_mens_alert); $this->nm_params_alert = array_merge($this->Ini->nm_params_alert, $this->nm_params_alert); } else { $this->nm_mens_alert = $this->Ini->nm_mens_alert; $this->nm_params_alert = $this->Ini->nm_params_alert; } } if (isset($this->nm_mens_alert) && !empty($this->nm_mens_alert)) { foreach ($this->nm_mens_alert as $i_alert => $mensagem) { $alertParams = array(); if (isset($this->nm_params_alert[$i_alert])) { foreach ($this->nm_params_alert[$i_alert] as $paramName => $paramValue) { if (in_array($paramName, array('title', 'timer', 'confirmButtonText', 'confirmButtonFA', 'confirmButtonFAPos', 'cancelButtonText', 'cancelButtonFA', 'cancelButtonFAPos', 'footer', 'width', 'padding'))) { $alertParams[$paramName] = NM_charset_to_utf8($paramValue); } elseif (in_array($paramName, array('showConfirmButton', 'showCancelButton', 'toast')) && in_array($paramValue, array(true, false))) { $alertParams[$paramName] = NM_charset_to_utf8($paramValue); } elseif ('position' == $paramName && in_array($paramValue, array('top', 'top-start', 'top-end', 'center', 'center-start', 'center-end', 'bottom', 'bottom-start', 'bottom-end'))) { $alertParams[$paramName] = NM_charset_to_utf8($paramValue); } elseif ('type' == $paramName && in_array($paramValue, array('warning', 'error', 'success', 'info', 'question'))) { $alertParams[$paramName] = NM_charset_to_utf8($paramValue); } elseif ('background' == $paramName) { $image_param = $paramValue; preg_match_all('/url\(([\s])?(["|\'])?(.*?)(["|\'])?([\s])?\)/i', $paramValue, $matches, PREG_PATTERN_ORDER); if (isset($matches[3])) { foreach ($matches[3] as $match) { if ('http:' != substr($match, 0, 5) && 'https:' != substr($match, 0, 6) && '/' != substr($match, 0, 1)) { $image_param = str_replace($match, "{$this->Ini->path_img_global}/{$match}", $image_param); } } } $paramValue = $image_param; $alertParams[$paramName] = NM_charset_to_utf8($paramValue); } } } $jsonParams = json_encode($alertParams); if ($_SESSION['sc_session'][$this->Ini->sc_page]['blank_despacho']['ajax_nav']) { $this->Ini->Arr_result['AlertJS'][] = NM_charset_to_utf8($mensagem); $this->Ini->Arr_result['AlertJSParam'][] = $alertParams; } else { ?> scJs_alert('<?php echo $mensagem ?>', <?php echo $jsonParams ?>); <?php } } } } ?> }) </script> <?php //--- $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_despacho']['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_despacho($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_despacho($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_despacho']['glo_nm_path_imag_temp'] . "/sc_apl_default_GorbusWeb.txt")) { $apl_def = explode(",", file_get_contents($root . $_SESSION['scriptcase']['blank_despacho']['glo_nm_path_imag_temp'] . "/sc_apl_default_GorbusWeb.txt")); } if (isset($apl_def)) { if ($apl_def[0] != "blank_despacho") { $_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_despacho']['session_timeout']['redir'] = $apl_def[0]; } else { $_SESSION['scriptcase']['blank_despacho']['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_despacho']['session_timeout']['redir_tp'] = $Redir_tp; } if (isset($_COOKIE['sc_actual_lang_GorbusWeb'])) { $_SESSION['scriptcase']['blank_despacho']['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["idturno"])) { $_SESSION["idturno"] = $_POST["idturno"]; nm_limpa_str_blank_despacho($_SESSION["idturno"]); } if (isset($_GET["idturno"])) { $_SESSION["idturno"] = $_GET["idturno"]; nm_limpa_str_blank_despacho($_SESSION["idturno"]); } if (!isset($_SESSION["idturno"])) { $_SESSION["idturno"] = ""; } 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_despacho']['iframe_menu'])) { $salva_iframe = $_SESSION['sc_session'][$script_case_init]['blank_despacho']['iframe_menu']; unset($_SESSION['sc_session'][$script_case_init]['blank_despacho']['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_despacho"; $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_despacho' || $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_despacho']['iframe_menu'] = true; } else { $_SESSION['sc_session'][$script_case_init]['blank_despacho']['iframe_menu'] = $salva_iframe; } if (!isset($_SESSION['sc_session'][$script_case_init]['blank_despacho']['initialize'])) { $_SESSION['sc_session'][$script_case_init]['blank_despacho']['initialize'] = true; } elseif (!isset($_SERVER['HTTP_REFERER'])) { $_SESSION['sc_session'][$script_case_init]['blank_despacho']['initialize'] = false; } elseif (false === strpos($_SERVER['HTTP_REFERER'], '.php')) { $_SESSION['sc_session'][$script_case_init]['blank_despacho']['initialize'] = true; } else { $sReferer = substr($_SERVER['HTTP_REFERER'], 0, strpos($_SERVER['HTTP_REFERER'], '.php')); $sReferer = substr($sReferer, strrpos($sReferer, '/') + 1); if ('blank_despacho' == $sReferer || 'blank_despacho_' == substr($sReferer, 0, 15)) { $_SESSION['sc_session'][$script_case_init]['blank_despacho']['initialize'] = false; } else { $_SESSION['sc_session'][$script_case_init]['blank_despacho']['initialize'] = true; } } $_POST['script_case_init'] = $script_case_init; $STR_lang = (isset($_SESSION['scriptcase']['str_lang']) && !empty($_SESSION['scriptcase']['str_lang'])) ? $_SESSION['scriptcase']['str_lang'] : "es"; if (isset($_SESSION['scriptcase']['blank_despacho']['session_timeout']['lang'])) { $STR_lang = $_SESSION['scriptcase']['blank_despacho']['session_timeout']['lang']; } $STR_schema_all = (isset($_SESSION['scriptcase']['str_schema_all']) && !empty($_SESSION['scriptcase']['str_schema_all'])) ? $_SESSION['scriptcase']['str_schema_all'] : "Sc7_BlueSky/Sc7_BlueSky"; $NM_arq_lang = "../_lib/lang/" . $STR_lang . ".lang.php"; $Nm_lang = array(); if (is_file($NM_arq_lang)) { $Lixo = file($NM_arq_lang); foreach ($Lixo as $Cada_lin) { if (strpos($Cada_lin, "array()") === false && (trim($Cada_lin) != "<?php") && (trim($Cada_lin) != "?" . ">")) { eval (str_replace("\$this->", "\$", $Cada_lin)); } } } $_SESSION['scriptcase']['charset'] = "UTF-8"; ini_set('default_charset', $_SESSION['scriptcase']['charset']); foreach ($Nm_lang as $ind => $dados) { if ($_SESSION['scriptcase']['charset'] != "UTF-8" && NM_is_utf8($dados)) { $Nm_lang[$ind] = sc_convert_encoding($dados, $_SESSION['scriptcase']['charset'], "UTF-8"); } } if (isset($_SESSION['scriptcase']['sc_outra_jan']) && $_SESSION['scriptcase']['sc_outra_jan'] == 'blank_despacho') { $_SESSION['sc_session'][$script_case_init]['blank_despacho']['sc_outra_jan'] = true; unset($_SESSION['scriptcase']['sc_outra_jan']); } $_SESSION['sc_session'][$script_case_init]['blank_despacho']['menu_desenv'] = false; if (!defined("SC_ERROR_HANDLER")) { define("SC_ERROR_HANDLER", 1); include_once(dirname(__FILE__) . "/blank_despacho_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_despacho($cadapar[1]); if ($cadapar[1] == "@ ") {$cadapar[1] = trim($cadapar[1]); } $Tmp_par = $cadapar[0];; $$Tmp_par = $cadapar[1]; } $ix++; } if (isset($idturno)) { $_SESSION['idturno'] = $idturno; nm_limpa_str_blank_despacho($_SESSION["idturno"]); } } $GLOBALS["NM_ERRO_IBASE"] = 0; if (isset($_SESSION['nm_session']['user']['sec']['flag']) && $_SESSION['nm_session']['user']['sec']['flag'] == "N") { $_SESSION['scriptcase']['sc_apl_seg']['blank_despacho'] = "on"; } if (!$_SESSION['sc_session'][$script_case_init]['blank_despacho']['opc_psq'] && !isset($_SESSION['scriptcase']['blank_despacho']['session_timeout']['redir'])) { if (!isset($_SESSION['scriptcase']['sc_apl_seg']['blank_despacho']) || $_SESSION['scriptcase']['sc_apl_seg']['blank_despacho'] != "on") { $NM_Mens_Erro = $Nm_lang['lang_errm_unth_user']; $nm_botao_ok = ($_SESSION['sc_session'][$script_case_init]['blank_despacho']['iframe_menu']) ? false : true; if (isset($_SESSION['scriptcase']['sc_aba_iframe'])) { foreach ($_SESSION['scriptcase']['sc_aba_iframe'] as $aba => $apls_aba) { if (in_array("blank_despacho", $apls_aba)) { $nm_botao_ok = false; break; } } } $str_schema_app = (isset($_SESSION['scriptcase']['str_schema_all']) && !empty($_SESSION['scriptcase']['str_schema_all'])) ? $_SESSION['scriptcase']['str_schema_all'] : "Sc7_BlueSky/Sc7_BlueSky"; header("X-XSS-Protection: 1; mode=block"); header("X-Frame-Options: SAMEORIGIN"); ?> <!DOCTYPE html> <HTML> <HEAD> <TITLE></TITLE> <META http-equiv="Content-Type" content="text/html; charset=<?php echo $_SESSION['scriptcase']['charset_html'] ?>" /> <?php if ($_SESSION['scriptcase']['proc_mobile']) { ?> <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=0" /> <?php } ?> <META http-equiv="Expires" content="Fri, Jan 01 1900 00:00:00 GMT" /> <META http-equiv="Last-Modified" content="<?php echo gmdate('D, d M Y H:i:s') ?> GMT" /> <META http-equiv="Cache-Control" content="no-store, no-cache, must-revalidate" /> <META http-equiv="Pragma" content="no-cache" /> <META http-equiv="Expires" content="Fri, Jan 01 1900 00:00:00 GMT"/> <META http-equiv="Pragma" content="no-cache"/> <link rel="shortcut icon" href="../_lib/img/grp__NM__bg__NM__bus0004.png"> <link rel="stylesheet" type="text/css" href="../_lib/css/<?php echo $str_schema_app ?>_grid.css" /> <link rel="stylesheet" type="text/css" href="../_lib/css/<?php echo $str_schema_app ?>_grid<?php echo $_SESSION['scriptcase']['reg_conf']['css_dir'] ?>.css" /> </HEAD> <body> <table align="center" class="scGridBorder"><tr><td style="padding: 0"> <table style="width: 100%" class="scGridTabela"><tr class="scGridFieldOdd"><td class="scGridFieldOddFont" style="padding: 15px 30px; text-align: center"> <?php echo $NM_Mens_Erro; ?> <?php if ($nm_botao_ok) { ?> <br /> <form name="Fseg" method="post" action="<?php echo $nm_url_saida; ?>" target="_self"> <input type="hidden" name="script_case_init" value="<?php echo NM_encode_input($script_case_init) ?>"/> <input type="submit" name="sc_sai_seg" value="OK"> </form> <?php } ?> </td></tr></table> </td></tr></table> <?php if (isset($_SESSION['scriptcase']['nm_sc_retorno']) && !empty($_SESSION['scriptcase']['nm_sc_retorno'])) { ?> <br /><br /><br /> <table align="center" class="scGridBorder" style="width: 450px"><tr><td style="padding: 0"> <table style="width: 100%" class="scGridTabela"> <tr class="scGridFieldOdd"> <td class="scGridFieldOddFont" style="padding: 15px 30px"> <?php echo $Nm_lang['lang_errm_unth_hwto']; ?> </td> </tr> </table> </td></tr></table> <?php } ?> </body> </HTML> <?php exit; } } $contr_blank_despacho = new blank_despacho_apl(); $contr_blank_despacho->controle(); // function nm_limpa_str_blank_despacho(&$str) { } ?>
Save
cmd:
run