Файловый менеджер

Файловый менеджер - Редактировать - /home2/isose750/public_html/sc_saude/grid_aniversariante/grid_aniversariante_xls.class.php

Назад
<?php class grid_aniversariante_xls { var $Db; var $Erro; var $Ini; var $Lookup; var $nm_data; var $Xls_dados; var $Xls_workbook; var $Xls_col; var $Xls_row; var $sc_proc_grid; var $NM_cmp_hidden = array(); var $NM_ctrl_style = array(); var $Arquivo; var $Tit_doc; var $count_ger; var $sexo_movimentacao_Old; var $arg_sum_sexo_movimentacao; var $Label_sexo_movimentacao; var $sc_proc_quebra_sexo_movimentacao; var $count_sexo_movimentacao; var $mes_aniver_mov_Old; var $arg_sum_mes_aniver_mov; var $Label_mes_aniver_mov; var $sc_proc_quebra_mes_aniver_mov; var $count_mes_aniver_mov; var $nome_empresa_Old; var $arg_sum_nome_empresa; var $Label_nome_empresa; var $sc_proc_quebra_nome_empresa; var $count_nome_empresa; var $nome_produto_Old; var $arg_sum_nome_produto; var $Label_nome_produto; var $sc_proc_quebra_nome_produto; var $count_nome_produto; //---- function __construct() { } function actionBar_isValidState($buttonName, $buttonState) { switch ($buttonName) { } return false; } function actionBar_displayState($buttonName) { switch ($buttonName) { } } function actionBar_getStateHint($buttonName) { switch ($buttonName) { } } function actionBar_getStateConfirm($buttonName) { switch ($buttonName) { } } function actionBar_getStateDisable($buttonName) { if (isset($this->sc_actionbar_disabled[$buttonName]) && $this->sc_actionbar_disabled[$buttonName]) { return ' disabled'; } return ''; } function actionBar_getStateHide($buttonName) { if (isset($this->sc_actionbar_hidden[$buttonName]) && $this->sc_actionbar_hidden[$buttonName]) { return ' sc-actionbar-button-hidden'; } return ''; } //---- function monta_xls() { $this->inicializa_vars(); $this->grava_arquivo(); if (!$_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { if ($this->Ini->sc_export_ajax) { $this->Arr_result['file_export'] = NM_charset_to_utf8($this->Xls_f); $this->Arr_result['title_export'] = NM_charset_to_utf8($this->Tit_doc); $Temp = ob_get_clean(); $oJson = new Services_JSON(); echo $oJson->encode($this->Arr_result); exit; } else { $this->progress_bar_end(); } } else { $_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['opcao'] = ""; } } //----- function inicializa_vars() { global $nm_lang; if (isset($GLOBALS['nmgp_parms']) && !empty($GLOBALS['nmgp_parms'])) { $GLOBALS['nmgp_parms'] = str_replace("@aspass@", "'", $GLOBALS['nmgp_parms']); $todox = str_replace("?#?@?@?", "?#?@ ?@?", $GLOBALS["nmgp_parms"]); $todo = explode("?@?", $todox); foreach ($todo as $param) { $cadapar = explode("?#?", $param); if (1 < sizeof($cadapar)) { if (substr($cadapar[0], 0, 11) == "SC_glo_par_") { $cadapar[0] = substr($cadapar[0], 11); $cadapar[1] = $_SESSION[$cadapar[1]]; } if (isset($GLOBALS['sc_conv_var'][$cadapar[0]])) { $cadapar[0] = $GLOBALS['sc_conv_var'][$cadapar[0]]; } elseif (isset($GLOBALS['sc_conv_var'][strtolower($cadapar[0])])) { $cadapar[0] = $GLOBALS['sc_conv_var'][strtolower($cadapar[0])]; } nm_limpa_str_grid_aniversariante($cadapar[1]); nm_protect_num_grid_aniversariante($cadapar[0], $cadapar[1]); if ($cadapar[1] == "@ ") {$cadapar[1] = trim($cadapar[1]); } $Tmp_par = $cadapar[0]; $$Tmp_par = $cadapar[1]; if ($Tmp_par == "nmgp_opcao") { $_SESSION['sc_session'][$script_case_init]['grid_aniversariante']['opcao'] = $cadapar[1]; } } } } if (isset($usr_login)) { $_SESSION['usr_login'] = $usr_login; nm_limpa_str_grid_aniversariante($_SESSION["usr_login"]); } $this->Use_phpspreadsheet = (phpversion() >= "7.3.9" && is_dir($this->Ini->path_third . '/phpspreadsheet')) ? true : false; $this->SC_top = array(); $this->SC_bot = array(); $this->SC_top[] = "sexo_movimentacao"; $this->SC_top[] = "mes_aniver_mov"; $this->SC_top[] = "nome_empresa"; $this->SC_top[] = "nome_produto"; $this->Xls_tot_col = 0; $this->Xls_row = 0; $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 (!$_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { if ($this->Use_phpspreadsheet) { require_once $this->Ini->path_third . '/phpspreadsheet/vendor/autoload.php'; } else { set_include_path(get_include_path() . PATH_SEPARATOR . $this->Ini->path_third . '/phpexcel/'); require_once $this->Ini->path_third . '/phpexcel/PHPExcel.php'; require_once $this->Ini->path_third . '/phpexcel/PHPExcel/IOFactory.php'; require_once $this->Ini->path_third . '/phpexcel/PHPExcel/Cell/AdvancedValueBinder.php'; } } $orig_form_dt = strtoupper($_SESSION['scriptcase']['reg_conf']['date_format']); $this->SC_date_conf_region = ""; for ($i = 0; $i < 8; $i++) { if ($i > 0 && substr($orig_form_dt, $i, 1) != substr($this->SC_date_conf_region, -1, 1)) { $this->SC_date_conf_region .= $_SESSION['scriptcase']['reg_conf']['date_sep']; } $this->SC_date_conf_region .= substr($orig_form_dt, $i, 1); } $this->Xls_tp = ".xlsx"; if (isset($_REQUEST['nmgp_tp_xls']) && !empty($_REQUEST['nmgp_tp_xls'])) { $this->Xls_tp = "." . $_REQUEST['nmgp_tp_xls']; } $this->groupby_show = "S"; if (isset($_REQUEST['nmgp_tot_xls']) && !empty($_REQUEST['nmgp_tot_xls'])) { $this->groupby_show = $_REQUEST['nmgp_tot_xls']; } $this->Xls_col = 0; $this->Tem_xls_res = false; $this->Xls_password = ""; $this->nm_data = new nm_data("pt_br"); if (!$_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->Tem_xls_res = true; if (isset($_REQUEST['SC_module_export']) && $_REQUEST['SC_module_export'] != "") { $this->Tem_xls_res = (strpos(" " . $_REQUEST['SC_module_export'], "resume") !== false \|\| strpos(" " . $_REQUEST['SC_module_export'], "chart") !== false) ? true : false; } if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['SC_Ind_Groupby'] == "sc_free_group_by" && empty($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['SC_Gb_Free_cmp'])) { $this->Tem_xls_res = false; } if (!is_file($this->Ini->root . $this->Ini->path_link . "grid_aniversariante/grid_aniversariante_res_xls.class.php")) { $this->Tem_xls_res = false; } if ($this->Tem_xls_res) { require_once($this->Ini->path_aplicacao . "grid_aniversariante_res_xls.class.php"); $this->Res_xls = new grid_aniversariante_res_xls(); $this->prep_modulos("Res_xls"); } $this->Arquivo = "sc_xls"; $this->Arquivo .= "_" . date("YmdHis") . "_" . rand(0, 1000); $this->Arq_zip = $this->Arquivo . "_grid_aniversariante.zip"; $this->Arquivo .= "_grid_aniversariante" . $this->Xls_tp; $this->Tit_doc = "grid_aniversariante" . $this->Xls_tp; $this->Tit_zip = "grid_aniversariante.zip"; $this->Xls_f = $this->Ini->root . $this->Ini->path_imag_temp . "/" . $this->Arquivo; $this->Zip_f = $this->Ini->root . $this->Ini->path_imag_temp . "/" . $this->Arq_zip; if ($this->Use_phpspreadsheet) { $this->Xls_dados = new PhpOffice\PhpSpreadsheet\Spreadsheet(); \PhpOffice\PhpSpreadsheet\Cell\Cell::setValueBinder( new \PhpOffice\PhpSpreadsheet\Cell\AdvancedValueBinder() ); } else { PHPExcel_Cell::setValueBinder( new PHPExcel_Cell_AdvancedValueBinder() ); $this->Xls_dados = new PHPExcel(); } $this->Xls_dados->setActiveSheetIndex(0); $this->Nm_ActiveSheet = $this->Xls_dados->getActiveSheet(); $this->Nm_ActiveSheet->setTitle($this->Ini->Nm_lang['lang_othr_grid_titl']); if ($_SESSION['scriptcase']['reg_conf']['css_dir'] == "RTL") { $this->Nm_ActiveSheet->setRightToLeft(true); } } require_once($this->Ini->path_aplicacao . "grid_aniversariante_total.class.php"); $this->Tot = new grid_aniversariante_total($this->Ini->sc_page); $this->prep_modulos("Tot"); $Gb_geral = "quebra_geral_" . $_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['SC_Ind_Groupby']; $this->Tot->$Gb_geral(); $this->count_ger = $_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['tot_geral'][1]; if (!$_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida'] && !$this->Ini->sc_export_ajax) { require_once($this->Ini->path_lib_php . "/sc_progress_bar.php"); $this->pb = new scProgressBar(); $this->pb->setRoot($this->Ini->root); $this->pb->setDir($_SESSION['scriptcase']['grid_aniversariante']['glo_nm_path_imag_temp'] . "/"); $this->pb->setProgressbarMd5($_GET['pbmd5']); $this->pb->initialize(); $this->pb->setReturnUrl("./"); $this->pb->setReturnOption($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['xls_return']); if ($this->Tem_xls_res) { $PB_plus = intval ($this->count_ger * 0.04); $PB_plus = ($PB_plus < 2) ? 2 : $PB_plus; } else { $PB_plus = intval ($this->count_ger * 0.02); $PB_plus = ($PB_plus < 1) ? 1 : $PB_plus; } $PB_tot = $this->count_ger + $PB_plus; $this->PB_dif = $PB_tot - $this->count_ger; $this->pb->setTotalSteps($PB_tot ); } } //---- function prep_modulos($modulo) { $this->$modulo->Ini = $this->Ini; $this->$modulo->Db = $this->Db; $this->$modulo->Erro = $this->Erro; $this->$modulo->Lookup = $this->Lookup; } //----- function grava_arquivo() { global $nm_nada, $nm_lang; $_SESSION['scriptcase']['sc_sql_ult_conexao'] = ''; $this->sc_proc_grid = false; $nm_raiz_img = ""; if (isset($_SESSION['scriptcase']['sc_apl_conf']['grid_aniversariante']['field_display']) && !empty($_SESSION['scriptcase']['sc_apl_conf']['grid_aniversariante']['field_display'])) { foreach ($_SESSION['scriptcase']['sc_apl_conf']['grid_aniversariante']['field_display'] as $NM_cada_field => $NM_cada_opc) { $this->NM_cmp_hidden[$NM_cada_field] = $NM_cada_opc; } } if (isset($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['usr_cmp_sel']) && !empty($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['usr_cmp_sel'])) { foreach ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['usr_cmp_sel'] as $NM_cada_field => $NM_cada_opc) { $this->NM_cmp_hidden[$NM_cada_field] = $NM_cada_opc; } } if (isset($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['php_cmp_sel']) && !empty($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['php_cmp_sel'])) { foreach ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['php_cmp_sel'] as $NM_cada_field => $NM_cada_opc) { $this->NM_cmp_hidden[$NM_cada_field] = $NM_cada_opc; } } foreach ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['field_order'] as $Cada_cmp) { if (!isset($this->NM_cmp_hidden[$Cada_cmp]) \|\| $this->NM_cmp_hidden[$Cada_cmp] != "off") { $this->Xls_tot_col++; } } $this->sc_where_orig = $_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['where_orig']; $this->sc_where_atual = $_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['where_pesq']; $this->sc_where_filtro = $_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['where_pesq_filtro']; if (isset($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['campos_busca']) && !empty($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['campos_busca'])) { $Busca_temp = $_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['campos_busca']; if ($_SESSION['scriptcase']['charset'] != "UTF-8") { $Busca_temp = NM_conv_charset($Busca_temp, $_SESSION['scriptcase']['charset'], "UTF-8"); } $this->nome_empresa = (isset($Busca_temp['nome_empresa'])) ? $Busca_temp['nome_empresa'] : ""; $tmp_pos = (is_string($this->nome_empresa)) ? strpos($this->nome_empresa, "##@@") : false; if ($tmp_pos !== false && !is_array($this->nome_empresa)) { $this->nome_empresa = substr($this->nome_empresa, 0, $tmp_pos); } $this->nome_produto = (isset($Busca_temp['nome_produto'])) ? $Busca_temp['nome_produto'] : ""; $tmp_pos = (is_string($this->nome_produto)) ? strpos($this->nome_produto, "##@@") : false; if ($tmp_pos !== false && !is_array($this->nome_produto)) { $this->nome_produto = substr($this->nome_produto, 0, $tmp_pos); } $this->data_nascimento_ano = (isset($Busca_temp['data_nascimento_ano'])) ? $Busca_temp['data_nascimento_ano'] : ""; $tmp_pos = (is_string($this->data_nascimento_ano)) ? strpos($this->data_nascimento_ano, "##@@") : false; if ($tmp_pos !== false && !is_array($this->data_nascimento_ano)) { $this->data_nascimento_ano = substr($this->data_nascimento_ano, 0, $tmp_pos); } $this->data_nascimento_ano_2 = (isset($Busca_temp['data_nascimento_ano_input_2'])) ? $Busca_temp['data_nascimento_ano_input_2'] : ""; } $this->nm_where_dinamico = ""; $_SESSION['scriptcase']['grid_aniversariante']['contr_erro'] = 'on'; if (!isset($_SESSION['usr_login'])) {$_SESSION['usr_login'] = "";} if (!isset($this->sc_temp_usr_login)) {$this->sc_temp_usr_login = (isset($_SESSION['usr_login'])) ? $_SESSION['usr_login'] : "";} ?> <?php echo $this->css_grid(); ?> <?php $this->sc_temp_usr_login = $this->sc_temp_usr_login; if (isset($this->sc_temp_usr_login)) {$_SESSION['usr_login'] = $this->sc_temp_usr_login;} $_SESSION['scriptcase']['grid_aniversariante']['contr_erro'] = 'off'; if (!empty($this->nm_where_dinamico)) { $_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['where_pesq'] .= $this->nm_where_dinamico; } if (isset($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['xls_name'])) { $Pos = strrpos($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['xls_name'], "."); if ($Pos === false) { $_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['xls_name'] .= $this->Xls_tp; } $this->Arquivo = $_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['xls_name']; $this->Arq_zip = $_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['xls_name']; $this->Tit_doc = $_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['xls_name']; $Pos = strrpos($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['xls_name'], "."); if ($Pos !== false) { $this->Arq_zip = substr($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['xls_name'], 0, $Pos); } $this->Arq_zip .= ".zip"; $this->Tit_zip = $this->Arq_zip; unset($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['xls_name']); $this->Xls_f = $this->Ini->root . $this->Ini->path_imag_temp . "/" . $this->Arquivo; $this->Zip_f = $this->Ini->root . $this->Ini->path_imag_temp . "/" . $this->Arq_zip; } $this->arr_export = array('label' => array(), 'lines' => array()); $this->arr_span = array(); if (isset($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida_label']) && $_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida_label']) { $this->count_span = 0; $this->Xls_row++; $this->proc_label(); $_SESSION['scriptcase']['export_return'] = $this->arr_export; return; } $this->nm_field_dinamico = array(); $this->nm_order_dinamico = array(); $nmgp_select_count = "SELECT count(*) AS countTest from (SELECT cod_movimentacao, id_empresa_movimentacao, data_nascimento_ano, idade_ano, id_produto_movimentacao, matricula_movimentacao, cpf_movimentacao, nome_movimentacao, id_parentesco_movimentacao, data_nascimento_movimentacao, ano_aniver_mov, mes_aniver_mov, dia_aniver_mov, idade_contato, id_acomodacao_movimentacao, data_inicio_vigencia_movimentacao, data_movimentacao_movimentacao, idade_movimentacao, sexo_movimentacao, id_situacao_beneficiario_movimentacao, fone_fixo_movimentacao, fone_celular_movimentacao, fone_whatsapp_movimentacao, email_movimentacao, id_tipo_classe_movimentacao, obs_movimentacao, criado_data_movimentacao, criado_user_movimentacao, nome_empresa, cnpj_empresa, municipio_empresa, uf_empresa, ref_produto, nome_produto, nome_lista_parentesco, nome_lista_acomodacao, nome_lista_situacao_beneficiario, nome_lista_tipo_classe, id_data_mov, idade_fatura FROM view_movimentacao WHERE EXISTS (SELECT 1 FROM sec_users_empresa WHERE id_empresa_movimentacao = sec_users_empresa.id_empresa AND sec_users_empresa.id_login = '" . $_SESSION['usr_login'] . "') ) nm_sel_esp"; if (in_array(strtolower($this->Ini->nm_tpbanco), $this->Ini->nm_bases_sybase)) { $nmgp_select = "SELECT matricula_movimentacao, cpf_movimentacao, nome_movimentacao, str_replace (convert(char(10),data_nascimento_movimentacao,102), '.', '-') + ' ' + convert(char(8),data_nascimento_movimentacao,20), dia_aniver_mov, idade_contato, idade_ano, sexo_movimentacao, nome_empresa, ref_produto, nome_produto, nome_lista_parentesco, nome_lista_acomodacao, nome_lista_situacao_beneficiario, nome_lista_tipo_classe, cod_movimentacao, str_replace (convert(char(10),data_inicio_vigencia_movimentacao,102), '.', '-') + ' ' + convert(char(8),data_inicio_vigencia_movimentacao,20), str_replace (convert(char(10),data_movimentacao_movimentacao,102), '.', '-') + ' ' + convert(char(8),data_movimentacao_movimentacao,20), idade_movimentacao, fone_fixo_movimentacao, fone_celular_movimentacao, fone_whatsapp_movimentacao, email_movimentacao, obs_movimentacao, str_replace (convert(char(10),criado_data_movimentacao,102), '.', '-') + ' ' + convert(char(8),criado_data_movimentacao,20), criado_user_movimentacao, cnpj_empresa, municipio_empresa, uf_empresa, mes_aniver_mov from (SELECT cod_movimentacao, id_empresa_movimentacao, data_nascimento_ano, idade_ano, id_produto_movimentacao, matricula_movimentacao, cpf_movimentacao, nome_movimentacao, id_parentesco_movimentacao, data_nascimento_movimentacao, ano_aniver_mov, mes_aniver_mov, dia_aniver_mov, idade_contato, id_acomodacao_movimentacao, data_inicio_vigencia_movimentacao, data_movimentacao_movimentacao, idade_movimentacao, sexo_movimentacao, id_situacao_beneficiario_movimentacao, fone_fixo_movimentacao, fone_celular_movimentacao, fone_whatsapp_movimentacao, email_movimentacao, id_tipo_classe_movimentacao, obs_movimentacao, criado_data_movimentacao, criado_user_movimentacao, nome_empresa, cnpj_empresa, municipio_empresa, uf_empresa, ref_produto, nome_produto, nome_lista_parentesco, nome_lista_acomodacao, nome_lista_situacao_beneficiario, nome_lista_tipo_classe, id_data_mov, idade_fatura FROM view_movimentacao WHERE EXISTS (SELECT 1 FROM sec_users_empresa WHERE id_empresa_movimentacao = sec_users_empresa.id_empresa AND sec_users_empresa.id_login = '" . $_SESSION['usr_login'] . "') ) nm_sel_esp"; } elseif (in_array(strtolower($this->Ini->nm_tpbanco), $this->Ini->nm_bases_mysql)) { $nmgp_select = "SELECT matricula_movimentacao, cpf_movimentacao, nome_movimentacao, data_nascimento_movimentacao, dia_aniver_mov, idade_contato, idade_ano, sexo_movimentacao, nome_empresa, ref_produto, nome_produto, nome_lista_parentesco, nome_lista_acomodacao, nome_lista_situacao_beneficiario, nome_lista_tipo_classe, cod_movimentacao, data_inicio_vigencia_movimentacao, data_movimentacao_movimentacao, idade_movimentacao, fone_fixo_movimentacao, fone_celular_movimentacao, fone_whatsapp_movimentacao, email_movimentacao, obs_movimentacao, criado_data_movimentacao, criado_user_movimentacao, cnpj_empresa, municipio_empresa, uf_empresa, mes_aniver_mov from (SELECT cod_movimentacao, id_empresa_movimentacao, data_nascimento_ano, idade_ano, id_produto_movimentacao, matricula_movimentacao, cpf_movimentacao, nome_movimentacao, id_parentesco_movimentacao, data_nascimento_movimentacao, ano_aniver_mov, mes_aniver_mov, dia_aniver_mov, idade_contato, id_acomodacao_movimentacao, data_inicio_vigencia_movimentacao, data_movimentacao_movimentacao, idade_movimentacao, sexo_movimentacao, id_situacao_beneficiario_movimentacao, fone_fixo_movimentacao, fone_celular_movimentacao, fone_whatsapp_movimentacao, email_movimentacao, id_tipo_classe_movimentacao, obs_movimentacao, criado_data_movimentacao, criado_user_movimentacao, nome_empresa, cnpj_empresa, municipio_empresa, uf_empresa, ref_produto, nome_produto, nome_lista_parentesco, nome_lista_acomodacao, nome_lista_situacao_beneficiario, nome_lista_tipo_classe, id_data_mov, idade_fatura FROM view_movimentacao WHERE EXISTS (SELECT 1 FROM sec_users_empresa WHERE id_empresa_movimentacao = sec_users_empresa.id_empresa AND sec_users_empresa.id_login = '" . $_SESSION['usr_login'] . "') ) nm_sel_esp"; } else { $nmgp_select = "SELECT matricula_movimentacao, cpf_movimentacao, nome_movimentacao, data_nascimento_movimentacao, dia_aniver_mov, idade_contato, idade_ano, sexo_movimentacao, nome_empresa, ref_produto, nome_produto, nome_lista_parentesco, nome_lista_acomodacao, nome_lista_situacao_beneficiario, nome_lista_tipo_classe, cod_movimentacao, data_inicio_vigencia_movimentacao, data_movimentacao_movimentacao, idade_movimentacao, fone_fixo_movimentacao, fone_celular_movimentacao, fone_whatsapp_movimentacao, email_movimentacao, obs_movimentacao, criado_data_movimentacao, criado_user_movimentacao, cnpj_empresa, municipio_empresa, uf_empresa, mes_aniver_mov from (SELECT cod_movimentacao, id_empresa_movimentacao, data_nascimento_ano, idade_ano, id_produto_movimentacao, matricula_movimentacao, cpf_movimentacao, nome_movimentacao, id_parentesco_movimentacao, data_nascimento_movimentacao, ano_aniver_mov, mes_aniver_mov, dia_aniver_mov, idade_contato, id_acomodacao_movimentacao, data_inicio_vigencia_movimentacao, data_movimentacao_movimentacao, idade_movimentacao, sexo_movimentacao, id_situacao_beneficiario_movimentacao, fone_fixo_movimentacao, fone_celular_movimentacao, fone_whatsapp_movimentacao, email_movimentacao, id_tipo_classe_movimentacao, obs_movimentacao, criado_data_movimentacao, criado_user_movimentacao, nome_empresa, cnpj_empresa, municipio_empresa, uf_empresa, ref_produto, nome_produto, nome_lista_parentesco, nome_lista_acomodacao, nome_lista_situacao_beneficiario, nome_lista_tipo_classe, id_data_mov, idade_fatura FROM view_movimentacao WHERE EXISTS (SELECT 1 FROM sec_users_empresa WHERE id_empresa_movimentacao = sec_users_empresa.id_empresa AND sec_users_empresa.id_login = '" . $_SESSION['usr_login'] . "') ) nm_sel_esp"; } $nmgp_select .= " " . $_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['where_pesq']; $nmgp_select_count .= " " . $_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['where_pesq']; if (isset($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['where_resumo']) && !empty($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['where_resumo'])) { if (empty($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['where_pesq'])) { $nmgp_select .= " where " . $_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['where_resumo']; $nmgp_select_count .= " where " . $_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['where_resumo']; } else { $nmgp_select .= " and (" . $_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['where_resumo'] . ")"; $nmgp_select_count .= " and (" . $_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['where_resumo'] . ")"; } } $nmgp_order_by = $_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['order_grid']; $nmgp_select .= $nmgp_order_by; if (!empty($this->Ini->nm_col_dinamica)) { foreach ($this->Ini->nm_col_dinamica as $nm_cada_col => $nm_nova_col) { $nmgp_select = str_replace($nm_cada_col, $nm_nova_col, $nmgp_select); } } $_SESSION['scriptcase']['sc_sql_ult_comando'] = $nmgp_select; $rs = $this->Db->Execute($nmgp_select); if ($rs === false && !$rs->EOF && $GLOBALS["NM_ERRO_IBASE"] != 1) { $this->Erro->mensagem(__FILE__, __LINE__, "banco", $this->Ini->Nm_lang['lang_errm_dber'], $this->Db->ErrorMsg()); exit; } $this->SC_seq_register = 0; $prim_reg = true; $prim_gb = true; $nm_houve_quebra = "N"; $PB_tot = (isset($this->count_ger) && $this->count_ger > 0) ? "/" . $this->count_ger : ""; while (!$rs->EOF) { $this->SC_seq_register++; $prim_reg = false; if (!$_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida'] && !$this->Ini->sc_export_ajax) { $Mens_bar = NM_charset_to_utf8($this->Ini->Nm_lang['lang_othr_prcs']); $this->pb->setProgressbarMessage($Mens_bar . ": " . $this->SC_seq_register . $PB_tot); $this->pb->addSteps(1); } $this->Xls_col = 0; $this->Xls_row++; $this->matricula_movimentacao = $rs->fields[0] ; $this->cpf_movimentacao = $rs->fields[1] ; $this->nome_movimentacao = $rs->fields[2] ; $this->data_nascimento_movimentacao = $rs->fields[3] ; $this->dia_aniver_mov = $rs->fields[4] ; $this->dia_aniver_mov = (string)$this->dia_aniver_mov; $this->idade_contato = $rs->fields[5] ; $this->idade_contato = (string)$this->idade_contato; $this->idade_ano = $rs->fields[6] ; $this->idade_ano = (string)$this->idade_ano; $this->sexo_movimentacao = $rs->fields[7] ; $this->nome_empresa = $rs->fields[8] ; $this->ref_produto = $rs->fields[9] ; $this->nome_produto = $rs->fields[10] ; $this->nome_lista_parentesco = $rs->fields[11] ; $this->nome_lista_acomodacao = $rs->fields[12] ; $this->nome_lista_situacao_beneficiario = $rs->fields[13] ; $this->nome_lista_tipo_classe = $rs->fields[14] ; $this->cod_movimentacao = $rs->fields[15] ; $this->cod_movimentacao = (string)$this->cod_movimentacao; $this->data_inicio_vigencia_movimentacao = $rs->fields[16] ; $this->data_movimentacao_movimentacao = $rs->fields[17] ; $this->idade_movimentacao = $rs->fields[18] ; $this->idade_movimentacao = (string)$this->idade_movimentacao; $this->fone_fixo_movimentacao = $rs->fields[19] ; $this->fone_celular_movimentacao = $rs->fields[20] ; $this->fone_whatsapp_movimentacao = $rs->fields[21] ; $this->email_movimentacao = $rs->fields[22] ; if (in_array(strtolower($this->Ini->nm_tpbanco), $this->Ini->nm_bases_ibase)) { $this->obs_movimentacao = $this->Db->BlobDecode($rs->fields[23]) ; } else { $this->obs_movimentacao = $rs->fields[23] ; } $this->criado_data_movimentacao = $rs->fields[24] ; $this->criado_user_movimentacao = $rs->fields[25] ; $this->cnpj_empresa = $rs->fields[26] ; $this->municipio_empresa = $rs->fields[27] ; $this->uf_empresa = $rs->fields[28] ; $this->mes_aniver_mov = $rs->fields[29] ; $this->mes_aniver_mov = (string)$this->mes_aniver_mov; $this->arg_sum_sexo_movimentacao = " = " . $this->Db->qstr($this->sexo_movimentacao); $this->arg_sum_nome_empresa = " = " . $this->Db->qstr($this->nome_empresa); $this->arg_sum_nome_produto = " = " . $this->Db->qstr($this->nome_produto); $this->arg_sum_mes_aniver_mov = ($this->mes_aniver_mov == "") ? " is null " : " = " . $this->mes_aniver_mov; if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['SC_Ind_Groupby'] == "sc_free_group_by") { $SC_arg_Gby = array(); $SC_arg_Sql = array(); foreach ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['SC_Gb_Free_cmp'] as $cmp => $sql) { $Cmp_orig = (isset($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['SC_Gb_Free_orig'][$cmp])) ? $_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['SC_Gb_Free_orig'][$cmp] : $cmp; $Format_tst = $this->Ini->Get_Gb_date_format('sc_free_group_by', $cmp); $TP_Time = (in_array($Cmp_orig, $this->Ini->Cmp_Sql_Time)) ? "0000-00-00 " : ""; $SC_arg_Gby[$cmp] = $this->Ini->Get_arg_groupby($TP_Time . $this->$Cmp_orig, $Format_tst); } $SC_lst_Gby = array(); $gb_ok = false; foreach ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['SC_Gb_Free_cmp'] as $cmp => $sql) { $Format_tst = $this->Ini->Get_Gb_date_format('sc_free_group_by', $cmp); $SC_arg_Sql[$cmp] = $sql; $Fun_GB = (isset($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['SC_Gb_Free_orig'][$cmp])) ? $_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['SC_Gb_Free_orig'][$cmp] : $cmp; if (!empty($Format_tst)) { $temp = $this->$cmp; if (!empty($temp)) { $SC_arg_Sql[$cmp] = $this->Ini->Get_sql_date_groupby($sql, $Format_tst); } } $temp = $cmp . "_Old"; if ($SC_arg_Gby[$cmp] != $this->$temp \|\| $gb_ok \|\| $NM_prim_qb) { $SC_lst_Gby[] = $cmp; $gb_ok = true; } } $this->Nivel_gbBot = count($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['SC_Gb_Free_cmp']); krsort ($SC_lst_Gby); $Qb_page = true; foreach ($SC_lst_Gby as $Ind => $cmp) { if (in_array($cmp, $this->SC_bot) && !$prim_gb) { $tmp = "quebra_" . $cmp . "_sc_free_group_by_bot"; $this->$tmp($cmp); $this->Nivel_gbBot--; if ($this->groupby_show == "S") { $this->Xls_col = 0; $this->Xls_row++; } } $sql_where = ""; $cmp_qb = $this->$cmp; foreach ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['SC_Gb_Free_cmp'] as $Col_Gb => $Sql) { $tmp = "arg_sum_" . $Col_Gb; $sql_where .= (!empty($sql_where)) ? " and " : ""; $sql_where .= $SC_arg_Sql[$Col_Gb] . $this->$tmp; if ($Col_Gb == $cmp) { break; } } $tmp = "quebra_" . $cmp . "_sc_free_group_by"; $this->$tmp($cmp_qb, $sql_where, $cmp); } if (!empty($SC_lst_Gby) && !$prim_gb && $this->groupby_show == "S" && $this->groupby_show == "S") { $this->Xls_col = 0; $this->Xls_row++; if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = ""; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "left"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "char"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = ""; } } $this->Nivel_gbBot = count($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['SC_Gb_Free_cmp']); ksort ($SC_lst_Gby); foreach ($SC_lst_Gby as $Ind => $cmp) { if (in_array($cmp, $this->SC_top)) { $tmp = "quebra_" . $cmp . "_sc_free_group_by_top"; $this->$tmp($cmp); if ($this->groupby_show == "S") { $this->Xls_col = 0; $this->Xls_row++; } } } if (!empty($SC_lst_Gby)) { $nm_houve_quebra = "S"; foreach ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['SC_Gb_Free_cmp'] as $cmp => $sql) { $Cmp_orig = (isset($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['SC_Gb_Free_orig'][$cmp])) ? $_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['SC_Gb_Free_orig'][$cmp] : $cmp; $Format_tst = $this->Ini->Get_Gb_date_format('sc_free_group_by', $cmp); $Cmp_Old = $cmp . '_Old'; $TP_Time = (in_array($Cmp_orig, $this->Ini->Cmp_Sql_Time)) ? "0000-00-00 " : ""; $this->$Cmp_Old = $this->Ini->Get_arg_groupby($TP_Time . $this->$Cmp_orig, $Format_tst); } } $NM_prim_qb = false; } if ($this->groupby_show == "S") { if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { if ($prim_gb) { $this->count_span = 0; $this->proc_label(); } if ($prim_gb \|\| $nm_houve_quebra == "S") { $this->xls_sub_cons_copy_label($this->Xls_row); $this->Xls_row++; } } elseif ($prim_gb \|\| $nm_houve_quebra == "S") { $this->count_span = 0; $this->proc_label(); } } else { if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { if ($prim_gb) { $this->count_span = 0; $this->proc_label(); $this->xls_sub_cons_copy_label($this->Xls_row); $this->Xls_row++; } } elseif ($prim_gb) { $this->count_span = 0; $this->proc_label(); } } $prim_gb = false; $nm_houve_quebra = "N"; $this->sc_proc_grid = true; foreach ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['field_order'] as $Cada_col) { if (!isset($this->NM_cmp_hidden[$Cada_col]) \|\| $this->NM_cmp_hidden[$Cada_col] != "off") { if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $NM_func_exp = "NM_sub_cons_" . $Cada_col; $this->$NM_func_exp(); } else { $NM_func_exp = "NM_export_" . $Cada_col; $this->$NM_func_exp(); } } } if (isset($this->NM_Row_din) && !$_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { foreach ($this->NM_Row_din as $row => $height) { $this->Nm_ActiveSheet->getRowDimension($row)->setRowHeight($height); } } $rs->MoveNext(); } $this->xls_set_style(); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida'] && $prim_reg) { $this->proc_label(); $this->xls_sub_cons_copy_label($this->Xls_row); $nm_grid_sem_reg = $this->Ini->Nm_lang['lang_errm_empt']; $nm_grid_sem_reg = NM_charset_to_utf8($nm_grid_sem_reg); $this->Xls_row++; $this->arr_export['lines'][$this->Xls_row][1]['data'] = $nm_grid_sem_reg; $this->arr_export['lines'][$this->Xls_row][1]['align'] = "right"; $this->arr_export['lines'][$this->Xls_row][1]['type'] = "char"; $this->arr_export['lines'][$this->Xls_row][1]['format'] = ""; } if (isset($this->NM_Col_din) && !$_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { foreach ($this->NM_Col_din as $col => $width) { $this->Nm_ActiveSheet->getColumnDimension($col)->setWidth($width / 5); } } if ($this->groupby_show == "S") { $this->Xls_col = 0; $this->Xls_row++; if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['SC_Ind_Groupby'] == "sc_free_group_by") { $SC_lst_Gby = array(); foreach ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['SC_Gb_Free_cmp'] as $cmp => $sql) { $SC_lst_Gby[] = $cmp; } $this->Nivel_gbBot = count($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['SC_Gb_Free_cmp']); krsort ($SC_lst_Gby); foreach ($SC_lst_Gby as $Ind => $cmp) { if (in_array($cmp, $this->SC_bot) && !$prim_gb) { $tmp = "quebra_" . $cmp . "_sc_free_group_by_bot"; $this->$tmp($cmp); $this->Nivel_gbBot--; if ($this->groupby_show == "S") { $this->Xls_col = 0;; $this->Xls_row++;; } } } } } if (!$_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { if ($this->Tem_xls_res) { $_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['xls_res_grid'] = true; if (!$this->Ini->sc_export_ajax) { $this->PB_dif = intval ($this->PB_dif / 2); $Mens_bar = NM_charset_to_utf8($this->Ini->Nm_lang['lang_othr_prcs']); $Mens_smry = NM_charset_to_utf8($this->Ini->Nm_lang['lang_othr_smry_titl']); $this->pb->setProgressbarMessage($Mens_bar . ": " . $Mens_smry); $this->pb->addSteps($this->PB_dif); } $this->Res_xls->monta_xls(); if ($this->Use_phpspreadsheet) { $Xls_res = \PhpOffice\PhpSpreadsheet\IOFactory::load($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['xls_res_sheet']); } else { $Xls_res = PHPExcel_IOFactory::load($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['xls_res_sheet']); } foreach($Xls_res->getAllSheets() as $sheet) { $this->Xls_dados->addExternalSheet($sheet); } unset($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['xls_res_grid']); unlink($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['xls_res_sheet']); } if (!$this->Ini->sc_export_ajax) { $Mens_bar = NM_charset_to_utf8($this->Ini->Nm_lang['lang_btns_export_finished']); $this->pb->setProgressbarMessage($Mens_bar); $this->pb->addSteps($this->PB_dif); } if ($this->Use_phpspreadsheet) { if ($this->Xls_tp == ".xlsx") { $objWriter = new PhpOffice\PhpSpreadsheet\Writer\Xlsx($this->Xls_dados); } else { $objWriter = new PhpOffice\PhpSpreadsheet\Writer\Xls($this->Xls_dados); } } else { if ($this->Xls_tp == ".xlsx") { $objWriter = new PHPExcel_Writer_Excel2007($this->Xls_dados); } else { $objWriter = new PHPExcel_Writer_Excel5($this->Xls_dados); } } $objWriter->save($this->Xls_f); if ($this->Xls_password != "") { $str_zip = ""; $Zip_f = (FALSE !== strpos($this->Zip_f, ' ')) ? " \"" . $this->Zip_f . "\"" : $this->Zip_f; $Arq_input = (FALSE !== strpos($this->Xls_f, ' ')) ? " \"" . $this->Xls_f . "\"" : $this->Xls_f; if (is_file($Zip_f)) { unlink($Zip_f); } if (FALSE !== strpos(strtolower(php_uname()), 'windows')) { chdir($this->Ini->path_third . "/zip/windows"); $str_zip = "zip.exe -P -j " . $this->Xls_password . " " . $Zip_f . " " . $Arq_input; } elseif (FALSE !== strpos(strtolower(php_uname()), 'linux')) { if (FALSE !== strpos(strtolower(php_uname()), 'i686')) { chdir($this->Ini->path_third . "/zip/linux-i386/bin"); } else { chdir($this->Ini->path_third . "/zip/linux-amd64/bin"); } $str_zip = "./7za -p" . $this->Xls_password . " a " . $Zip_f . " " . $Arq_input; } elseif (FALSE !== strpos(strtolower(php_uname()), 'darwin')) { chdir($this->Ini->path_third . "/zip/mac/bin"); $str_zip = "./7za -p" . $this->Xls_password . " a " . $Zip_f . " " . $Arq_input; } if (!empty($str_zip)) { exec($str_zip); } // ----- ZIP log $fp = @fopen(trim(str_replace(array(".zip",'"'), array(".log",""), $Zip_f)), 'w'); if ($fp) { @fwrite($fp, $str_zip . "\r\n\r\n"); @fclose($fp); } unlink($Arq_input); $this->Arquivo = $this->Arq_zip; $this->Xls_f = $this->Zip_f; $this->Tit_doc = $this->Tit_zip; } } else { $_SESSION['scriptcase']['export_return'] = $this->arr_export; } if(isset($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['export_sel_columns']['field_order'])) { $_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['field_order'] = $_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['export_sel_columns']['field_order']; unset($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['export_sel_columns']['field_order']); } if(isset($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['export_sel_columns']['usr_cmp_sel'])) { $_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['usr_cmp_sel'] = $_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['export_sel_columns']['usr_cmp_sel']; unset($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['export_sel_columns']['usr_cmp_sel']); } $rs->Close(); } function proc_label() { foreach ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['field_order'] as $Cada_col) { $SC_Label = (isset($this->New_label['matricula_movimentacao'])) ? $this->New_label['matricula_movimentacao'] : "Matricula"; if ($Cada_col == "matricula_movimentacao" && (!isset($this->NM_cmp_hidden[$Cada_col]) \|\| $this->NM_cmp_hidden[$Cada_col] != "off")) { $this->count_span++; $current_cell_ref = $this->calc_cell($this->Xls_col); $SC_Label = NM_charset_to_utf8($SC_Label); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['label'][$this->Xls_col]['data'] = $SC_Label; $this->arr_export['label'][$this->Xls_col]['align'] = "left"; $this->arr_export['label'][$this->Xls_col]['autosize'] = "s"; $this->arr_export['label'][$this->Xls_col]['bold'] = "s"; } else { if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getFont()->setBold(true); $this->Nm_ActiveSheet->getColumnDimension($current_cell_ref)->setAutoSize(true); } $this->Xls_col++; } $SC_Label = (isset($this->New_label['cpf_movimentacao'])) ? $this->New_label['cpf_movimentacao'] : "CPF"; if ($Cada_col == "cpf_movimentacao" && (!isset($this->NM_cmp_hidden[$Cada_col]) \|\| $this->NM_cmp_hidden[$Cada_col] != "off")) { $this->count_span++; $current_cell_ref = $this->calc_cell($this->Xls_col); $SC_Label = NM_charset_to_utf8($SC_Label); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['label'][$this->Xls_col]['data'] = $SC_Label; $this->arr_export['label'][$this->Xls_col]['align'] = "left"; $this->arr_export['label'][$this->Xls_col]['autosize'] = "s"; $this->arr_export['label'][$this->Xls_col]['bold'] = "s"; } else { if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getFont()->setBold(true); $this->Nm_ActiveSheet->getColumnDimension($current_cell_ref)->setAutoSize(true); } $this->Xls_col++; } $SC_Label = (isset($this->New_label['nome_movimentacao'])) ? $this->New_label['nome_movimentacao'] : "Nome"; if ($Cada_col == "nome_movimentacao" && (!isset($this->NM_cmp_hidden[$Cada_col]) \|\| $this->NM_cmp_hidden[$Cada_col] != "off")) { $this->count_span++; $current_cell_ref = $this->calc_cell($this->Xls_col); $SC_Label = NM_charset_to_utf8($SC_Label); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['label'][$this->Xls_col]['data'] = $SC_Label; $this->arr_export['label'][$this->Xls_col]['align'] = "left"; $this->arr_export['label'][$this->Xls_col]['autosize'] = "s"; $this->arr_export['label'][$this->Xls_col]['bold'] = "s"; } else { if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getFont()->setBold(true); $this->Nm_ActiveSheet->getColumnDimension($current_cell_ref)->setAutoSize(true); } $this->Xls_col++; } $SC_Label = (isset($this->New_label['data_nascimento_movimentacao'])) ? $this->New_label['data_nascimento_movimentacao'] : "Data Nascimento"; if ($Cada_col == "data_nascimento_movimentacao" && (!isset($this->NM_cmp_hidden[$Cada_col]) \|\| $this->NM_cmp_hidden[$Cada_col] != "off")) { $this->count_span++; $current_cell_ref = $this->calc_cell($this->Xls_col); $SC_Label = NM_charset_to_utf8($SC_Label); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['label'][$this->Xls_col]['data'] = $SC_Label; $this->arr_export['label'][$this->Xls_col]['align'] = "center"; $this->arr_export['label'][$this->Xls_col]['autosize'] = "s"; $this->arr_export['label'][$this->Xls_col]['bold'] = "s"; } else { if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getFont()->setBold(true); $this->Nm_ActiveSheet->getColumnDimension($current_cell_ref)->setAutoSize(true); } $this->Xls_col++; } $SC_Label = (isset($this->New_label['dia_aniver_mov'])) ? $this->New_label['dia_aniver_mov'] : "Dia"; if ($Cada_col == "dia_aniver_mov" && (!isset($this->NM_cmp_hidden[$Cada_col]) \|\| $this->NM_cmp_hidden[$Cada_col] != "off")) { $this->count_span++; $current_cell_ref = $this->calc_cell($this->Xls_col); $SC_Label = NM_charset_to_utf8($SC_Label); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['label'][$this->Xls_col]['data'] = $SC_Label; $this->arr_export['label'][$this->Xls_col]['align'] = "center"; $this->arr_export['label'][$this->Xls_col]['autosize'] = "s"; $this->arr_export['label'][$this->Xls_col]['bold'] = "s"; } else { if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getFont()->setBold(true); $this->Nm_ActiveSheet->getColumnDimension($current_cell_ref)->setAutoSize(true); } $this->Xls_col++; } $SC_Label = (isset($this->New_label['idade_contato'])) ? $this->New_label['idade_contato'] : "Idade Atual"; if ($Cada_col == "idade_contato" && (!isset($this->NM_cmp_hidden[$Cada_col]) \|\| $this->NM_cmp_hidden[$Cada_col] != "off")) { $this->count_span++; $current_cell_ref = $this->calc_cell($this->Xls_col); $SC_Label = NM_charset_to_utf8($SC_Label); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['label'][$this->Xls_col]['data'] = $SC_Label; $this->arr_export['label'][$this->Xls_col]['align'] = "center"; $this->arr_export['label'][$this->Xls_col]['autosize'] = "s"; $this->arr_export['label'][$this->Xls_col]['bold'] = "s"; } else { if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getFont()->setBold(true); $this->Nm_ActiveSheet->getColumnDimension($current_cell_ref)->setAutoSize(true); } $this->Xls_col++; } $SC_Label = (isset($this->New_label['idade_ano'])) ? $this->New_label['idade_ano'] : "Idade Aniversário"; if ($Cada_col == "idade_ano" && (!isset($this->NM_cmp_hidden[$Cada_col]) \|\| $this->NM_cmp_hidden[$Cada_col] != "off")) { $this->count_span++; $current_cell_ref = $this->calc_cell($this->Xls_col); $SC_Label = NM_charset_to_utf8($SC_Label); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['label'][$this->Xls_col]['data'] = $SC_Label; $this->arr_export['label'][$this->Xls_col]['align'] = "center"; $this->arr_export['label'][$this->Xls_col]['autosize'] = "s"; $this->arr_export['label'][$this->Xls_col]['bold'] = "s"; } else { if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getFont()->setBold(true); $this->Nm_ActiveSheet->getColumnDimension($current_cell_ref)->setAutoSize(true); } $this->Xls_col++; } $SC_Label = (isset($this->New_label['sexo_movimentacao'])) ? $this->New_label['sexo_movimentacao'] : "Sexo"; if ($Cada_col == "sexo_movimentacao" && (!isset($this->NM_cmp_hidden[$Cada_col]) \|\| $this->NM_cmp_hidden[$Cada_col] != "off")) { $this->count_span++; $current_cell_ref = $this->calc_cell($this->Xls_col); $SC_Label = NM_charset_to_utf8($SC_Label); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['label'][$this->Xls_col]['data'] = $SC_Label; $this->arr_export['label'][$this->Xls_col]['align'] = "left"; $this->arr_export['label'][$this->Xls_col]['autosize'] = "s"; $this->arr_export['label'][$this->Xls_col]['bold'] = "s"; } else { if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getFont()->setBold(true); $this->Nm_ActiveSheet->getColumnDimension($current_cell_ref)->setAutoSize(true); } $this->Xls_col++; } $SC_Label = (isset($this->New_label['nome_empresa'])) ? $this->New_label['nome_empresa'] : "Empresa"; if ($Cada_col == "nome_empresa" && (!isset($this->NM_cmp_hidden[$Cada_col]) \|\| $this->NM_cmp_hidden[$Cada_col] != "off")) { $this->count_span++; $current_cell_ref = $this->calc_cell($this->Xls_col); $SC_Label = NM_charset_to_utf8($SC_Label); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['label'][$this->Xls_col]['data'] = $SC_Label; $this->arr_export['label'][$this->Xls_col]['align'] = "left"; $this->arr_export['label'][$this->Xls_col]['autosize'] = "s"; $this->arr_export['label'][$this->Xls_col]['bold'] = "s"; } else { if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getFont()->setBold(true); $this->Nm_ActiveSheet->getColumnDimension($current_cell_ref)->setAutoSize(true); } $this->Xls_col++; } $SC_Label = (isset($this->New_label['ref_produto'])) ? $this->New_label['ref_produto'] : "Cód. Produto"; if ($Cada_col == "ref_produto" && (!isset($this->NM_cmp_hidden[$Cada_col]) \|\| $this->NM_cmp_hidden[$Cada_col] != "off")) { $this->count_span++; $current_cell_ref = $this->calc_cell($this->Xls_col); $SC_Label = NM_charset_to_utf8($SC_Label); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['label'][$this->Xls_col]['data'] = $SC_Label; $this->arr_export['label'][$this->Xls_col]['align'] = "left"; $this->arr_export['label'][$this->Xls_col]['autosize'] = "s"; $this->arr_export['label'][$this->Xls_col]['bold'] = "s"; } else { if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getFont()->setBold(true); $this->Nm_ActiveSheet->getColumnDimension($current_cell_ref)->setAutoSize(true); } $this->Xls_col++; } $SC_Label = (isset($this->New_label['nome_produto'])) ? $this->New_label['nome_produto'] : "Produto"; if ($Cada_col == "nome_produto" && (!isset($this->NM_cmp_hidden[$Cada_col]) \|\| $this->NM_cmp_hidden[$Cada_col] != "off")) { $this->count_span++; $current_cell_ref = $this->calc_cell($this->Xls_col); $SC_Label = NM_charset_to_utf8($SC_Label); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['label'][$this->Xls_col]['data'] = $SC_Label; $this->arr_export['label'][$this->Xls_col]['align'] = "left"; $this->arr_export['label'][$this->Xls_col]['autosize'] = "s"; $this->arr_export['label'][$this->Xls_col]['bold'] = "s"; } else { if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getFont()->setBold(true); $this->Nm_ActiveSheet->getColumnDimension($current_cell_ref)->setAutoSize(true); } $this->Xls_col++; } $SC_Label = (isset($this->New_label['nome_lista_parentesco'])) ? $this->New_label['nome_lista_parentesco'] : "Parentesco"; if ($Cada_col == "nome_lista_parentesco" && (!isset($this->NM_cmp_hidden[$Cada_col]) \|\| $this->NM_cmp_hidden[$Cada_col] != "off")) { $this->count_span++; $current_cell_ref = $this->calc_cell($this->Xls_col); $SC_Label = NM_charset_to_utf8($SC_Label); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['label'][$this->Xls_col]['data'] = $SC_Label; $this->arr_export['label'][$this->Xls_col]['align'] = "left"; $this->arr_export['label'][$this->Xls_col]['autosize'] = "s"; $this->arr_export['label'][$this->Xls_col]['bold'] = "s"; } else { if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getFont()->setBold(true); $this->Nm_ActiveSheet->getColumnDimension($current_cell_ref)->setAutoSize(true); } $this->Xls_col++; } $SC_Label = (isset($this->New_label['nome_lista_acomodacao'])) ? $this->New_label['nome_lista_acomodacao'] : "Acomodação"; if ($Cada_col == "nome_lista_acomodacao" && (!isset($this->NM_cmp_hidden[$Cada_col]) \|\| $this->NM_cmp_hidden[$Cada_col] != "off")) { $this->count_span++; $current_cell_ref = $this->calc_cell($this->Xls_col); $SC_Label = NM_charset_to_utf8($SC_Label); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['label'][$this->Xls_col]['data'] = $SC_Label; $this->arr_export['label'][$this->Xls_col]['align'] = "left"; $this->arr_export['label'][$this->Xls_col]['autosize'] = "s"; $this->arr_export['label'][$this->Xls_col]['bold'] = "s"; } else { if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getFont()->setBold(true); $this->Nm_ActiveSheet->getColumnDimension($current_cell_ref)->setAutoSize(true); } $this->Xls_col++; } $SC_Label = (isset($this->New_label['nome_lista_situacao_beneficiario'])) ? $this->New_label['nome_lista_situacao_beneficiario'] : "Situação do beneficiário"; if ($Cada_col == "nome_lista_situacao_beneficiario" && (!isset($this->NM_cmp_hidden[$Cada_col]) \|\| $this->NM_cmp_hidden[$Cada_col] != "off")) { $this->count_span++; $current_cell_ref = $this->calc_cell($this->Xls_col); $SC_Label = NM_charset_to_utf8($SC_Label); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['label'][$this->Xls_col]['data'] = $SC_Label; $this->arr_export['label'][$this->Xls_col]['align'] = "left"; $this->arr_export['label'][$this->Xls_col]['autosize'] = "s"; $this->arr_export['label'][$this->Xls_col]['bold'] = "s"; } else { if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getFont()->setBold(true); $this->Nm_ActiveSheet->getColumnDimension($current_cell_ref)->setAutoSize(true); } $this->Xls_col++; } $SC_Label = (isset($this->New_label['nome_lista_tipo_classe'])) ? $this->New_label['nome_lista_tipo_classe'] : "Tipo de classe"; if ($Cada_col == "nome_lista_tipo_classe" && (!isset($this->NM_cmp_hidden[$Cada_col]) \|\| $this->NM_cmp_hidden[$Cada_col] != "off")) { $this->count_span++; $current_cell_ref = $this->calc_cell($this->Xls_col); $SC_Label = NM_charset_to_utf8($SC_Label); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['label'][$this->Xls_col]['data'] = $SC_Label; $this->arr_export['label'][$this->Xls_col]['align'] = "left"; $this->arr_export['label'][$this->Xls_col]['autosize'] = "s"; $this->arr_export['label'][$this->Xls_col]['bold'] = "s"; } else { if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getFont()->setBold(true); $this->Nm_ActiveSheet->getColumnDimension($current_cell_ref)->setAutoSize(true); } $this->Xls_col++; } $SC_Label = (isset($this->New_label['cod_movimentacao'])) ? $this->New_label['cod_movimentacao'] : "#"; if ($Cada_col == "cod_movimentacao" && (!isset($this->NM_cmp_hidden[$Cada_col]) \|\| $this->NM_cmp_hidden[$Cada_col] != "off")) { $this->count_span++; $current_cell_ref = $this->calc_cell($this->Xls_col); $SC_Label = NM_charset_to_utf8($SC_Label); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['label'][$this->Xls_col]['data'] = $SC_Label; $this->arr_export['label'][$this->Xls_col]['align'] = "left"; $this->arr_export['label'][$this->Xls_col]['autosize'] = "s"; $this->arr_export['label'][$this->Xls_col]['bold'] = "s"; } else { if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getFont()->setBold(true); $this->Nm_ActiveSheet->getColumnDimension($current_cell_ref)->setAutoSize(true); } $this->Xls_col++; } $SC_Label = (isset($this->New_label['data_inicio_vigencia_movimentacao'])) ? $this->New_label['data_inicio_vigencia_movimentacao'] : "Data Início Vigência"; if ($Cada_col == "data_inicio_vigencia_movimentacao" && (!isset($this->NM_cmp_hidden[$Cada_col]) \|\| $this->NM_cmp_hidden[$Cada_col] != "off")) { $this->count_span++; $current_cell_ref = $this->calc_cell($this->Xls_col); $SC_Label = NM_charset_to_utf8($SC_Label); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['label'][$this->Xls_col]['data'] = $SC_Label; $this->arr_export['label'][$this->Xls_col]['align'] = "center"; $this->arr_export['label'][$this->Xls_col]['autosize'] = "s"; $this->arr_export['label'][$this->Xls_col]['bold'] = "s"; } else { if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getFont()->setBold(true); $this->Nm_ActiveSheet->getColumnDimension($current_cell_ref)->setAutoSize(true); } $this->Xls_col++; } $SC_Label = (isset($this->New_label['data_movimentacao_movimentacao'])) ? $this->New_label['data_movimentacao_movimentacao'] : "Data Movimentação"; if ($Cada_col == "data_movimentacao_movimentacao" && (!isset($this->NM_cmp_hidden[$Cada_col]) \|\| $this->NM_cmp_hidden[$Cada_col] != "off")) { $this->count_span++; $current_cell_ref = $this->calc_cell($this->Xls_col); $SC_Label = NM_charset_to_utf8($SC_Label); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['label'][$this->Xls_col]['data'] = $SC_Label; $this->arr_export['label'][$this->Xls_col]['align'] = "center"; $this->arr_export['label'][$this->Xls_col]['autosize'] = "s"; $this->arr_export['label'][$this->Xls_col]['bold'] = "s"; } else { if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getFont()->setBold(true); $this->Nm_ActiveSheet->getColumnDimension($current_cell_ref)->setAutoSize(true); } $this->Xls_col++; } $SC_Label = (isset($this->New_label['idade_movimentacao'])) ? $this->New_label['idade_movimentacao'] : "Idade Movimentação"; if ($Cada_col == "idade_movimentacao" && (!isset($this->NM_cmp_hidden[$Cada_col]) \|\| $this->NM_cmp_hidden[$Cada_col] != "off")) { $this->count_span++; $current_cell_ref = $this->calc_cell($this->Xls_col); $SC_Label = NM_charset_to_utf8($SC_Label); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['label'][$this->Xls_col]['data'] = $SC_Label; $this->arr_export['label'][$this->Xls_col]['align'] = "center"; $this->arr_export['label'][$this->Xls_col]['autosize'] = "s"; $this->arr_export['label'][$this->Xls_col]['bold'] = "s"; } else { if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getFont()->setBold(true); $this->Nm_ActiveSheet->getColumnDimension($current_cell_ref)->setAutoSize(true); } $this->Xls_col++; } $SC_Label = (isset($this->New_label['fone_fixo_movimentacao'])) ? $this->New_label['fone_fixo_movimentacao'] : "Fone Fixo"; if ($Cada_col == "fone_fixo_movimentacao" && (!isset($this->NM_cmp_hidden[$Cada_col]) \|\| $this->NM_cmp_hidden[$Cada_col] != "off")) { $this->count_span++; $current_cell_ref = $this->calc_cell($this->Xls_col); $SC_Label = NM_charset_to_utf8($SC_Label); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['label'][$this->Xls_col]['data'] = $SC_Label; $this->arr_export['label'][$this->Xls_col]['align'] = "left"; $this->arr_export['label'][$this->Xls_col]['autosize'] = "s"; $this->arr_export['label'][$this->Xls_col]['bold'] = "s"; } else { if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getFont()->setBold(true); $this->Nm_ActiveSheet->getColumnDimension($current_cell_ref)->setAutoSize(true); } $this->Xls_col++; } $SC_Label = (isset($this->New_label['fone_celular_movimentacao'])) ? $this->New_label['fone_celular_movimentacao'] : "Celular"; if ($Cada_col == "fone_celular_movimentacao" && (!isset($this->NM_cmp_hidden[$Cada_col]) \|\| $this->NM_cmp_hidden[$Cada_col] != "off")) { $this->count_span++; $current_cell_ref = $this->calc_cell($this->Xls_col); $SC_Label = NM_charset_to_utf8($SC_Label); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['label'][$this->Xls_col]['data'] = $SC_Label; $this->arr_export['label'][$this->Xls_col]['align'] = "left"; $this->arr_export['label'][$this->Xls_col]['autosize'] = "s"; $this->arr_export['label'][$this->Xls_col]['bold'] = "s"; } else { if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getFont()->setBold(true); $this->Nm_ActiveSheet->getColumnDimension($current_cell_ref)->setAutoSize(true); } $this->Xls_col++; } $SC_Label = (isset($this->New_label['fone_whatsapp_movimentacao'])) ? $this->New_label['fone_whatsapp_movimentacao'] : "Whatsapp"; if ($Cada_col == "fone_whatsapp_movimentacao" && (!isset($this->NM_cmp_hidden[$Cada_col]) \|\| $this->NM_cmp_hidden[$Cada_col] != "off")) { $this->count_span++; $current_cell_ref = $this->calc_cell($this->Xls_col); $SC_Label = NM_charset_to_utf8($SC_Label); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['label'][$this->Xls_col]['data'] = $SC_Label; $this->arr_export['label'][$this->Xls_col]['align'] = "left"; $this->arr_export['label'][$this->Xls_col]['autosize'] = "s"; $this->arr_export['label'][$this->Xls_col]['bold'] = "s"; } else { if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getFont()->setBold(true); $this->Nm_ActiveSheet->getColumnDimension($current_cell_ref)->setAutoSize(true); } $this->Xls_col++; } $SC_Label = (isset($this->New_label['email_movimentacao'])) ? $this->New_label['email_movimentacao'] : "E-mail"; if ($Cada_col == "email_movimentacao" && (!isset($this->NM_cmp_hidden[$Cada_col]) \|\| $this->NM_cmp_hidden[$Cada_col] != "off")) { $this->count_span++; $current_cell_ref = $this->calc_cell($this->Xls_col); $SC_Label = NM_charset_to_utf8($SC_Label); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['label'][$this->Xls_col]['data'] = $SC_Label; $this->arr_export['label'][$this->Xls_col]['align'] = "left"; $this->arr_export['label'][$this->Xls_col]['autosize'] = "s"; $this->arr_export['label'][$this->Xls_col]['bold'] = "s"; } else { if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getFont()->setBold(true); $this->Nm_ActiveSheet->getColumnDimension($current_cell_ref)->setAutoSize(true); } $this->Xls_col++; } $SC_Label = (isset($this->New_label['obs_movimentacao'])) ? $this->New_label['obs_movimentacao'] : "Observação"; if ($Cada_col == "obs_movimentacao" && (!isset($this->NM_cmp_hidden[$Cada_col]) \|\| $this->NM_cmp_hidden[$Cada_col] != "off")) { $this->count_span++; $current_cell_ref = $this->calc_cell($this->Xls_col); $SC_Label = NM_charset_to_utf8($SC_Label); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['label'][$this->Xls_col]['data'] = $SC_Label; $this->arr_export['label'][$this->Xls_col]['align'] = "left"; $this->arr_export['label'][$this->Xls_col]['autosize'] = "s"; $this->arr_export['label'][$this->Xls_col]['bold'] = "s"; } else { if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getFont()->setBold(true); $this->Nm_ActiveSheet->getColumnDimension($current_cell_ref)->setAutoSize(true); } $this->Xls_col++; } $SC_Label = (isset($this->New_label['criado_data_movimentacao'])) ? $this->New_label['criado_data_movimentacao'] : "Data de criação"; if ($Cada_col == "criado_data_movimentacao" && (!isset($this->NM_cmp_hidden[$Cada_col]) \|\| $this->NM_cmp_hidden[$Cada_col] != "off")) { $this->count_span++; $current_cell_ref = $this->calc_cell($this->Xls_col); $SC_Label = NM_charset_to_utf8($SC_Label); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['label'][$this->Xls_col]['data'] = $SC_Label; $this->arr_export['label'][$this->Xls_col]['align'] = "center"; $this->arr_export['label'][$this->Xls_col]['autosize'] = "s"; $this->arr_export['label'][$this->Xls_col]['bold'] = "s"; } else { if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getFont()->setBold(true); $this->Nm_ActiveSheet->getColumnDimension($current_cell_ref)->setAutoSize(true); } $this->Xls_col++; } $SC_Label = (isset($this->New_label['criado_user_movimentacao'])) ? $this->New_label['criado_user_movimentacao'] : "Criado por"; if ($Cada_col == "criado_user_movimentacao" && (!isset($this->NM_cmp_hidden[$Cada_col]) \|\| $this->NM_cmp_hidden[$Cada_col] != "off")) { $this->count_span++; $current_cell_ref = $this->calc_cell($this->Xls_col); $SC_Label = NM_charset_to_utf8($SC_Label); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['label'][$this->Xls_col]['data'] = $SC_Label; $this->arr_export['label'][$this->Xls_col]['align'] = "left"; $this->arr_export['label'][$this->Xls_col]['autosize'] = "s"; $this->arr_export['label'][$this->Xls_col]['bold'] = "s"; } else { if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getFont()->setBold(true); $this->Nm_ActiveSheet->getColumnDimension($current_cell_ref)->setAutoSize(true); } $this->Xls_col++; } $SC_Label = (isset($this->New_label['cnpj_empresa'])) ? $this->New_label['cnpj_empresa'] : "CNPJ"; if ($Cada_col == "cnpj_empresa" && (!isset($this->NM_cmp_hidden[$Cada_col]) \|\| $this->NM_cmp_hidden[$Cada_col] != "off")) { $this->count_span++; $current_cell_ref = $this->calc_cell($this->Xls_col); $SC_Label = NM_charset_to_utf8($SC_Label); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['label'][$this->Xls_col]['data'] = $SC_Label; $this->arr_export['label'][$this->Xls_col]['align'] = "left"; $this->arr_export['label'][$this->Xls_col]['autosize'] = "s"; $this->arr_export['label'][$this->Xls_col]['bold'] = "s"; } else { if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getFont()->setBold(true); $this->Nm_ActiveSheet->getColumnDimension($current_cell_ref)->setAutoSize(true); } $this->Xls_col++; } $SC_Label = (isset($this->New_label['municipio_empresa'])) ? $this->New_label['municipio_empresa'] : "Municipio"; if ($Cada_col == "municipio_empresa" && (!isset($this->NM_cmp_hidden[$Cada_col]) \|\| $this->NM_cmp_hidden[$Cada_col] != "off")) { $this->count_span++; $current_cell_ref = $this->calc_cell($this->Xls_col); $SC_Label = NM_charset_to_utf8($SC_Label); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['label'][$this->Xls_col]['data'] = $SC_Label; $this->arr_export['label'][$this->Xls_col]['align'] = "left"; $this->arr_export['label'][$this->Xls_col]['autosize'] = "s"; $this->arr_export['label'][$this->Xls_col]['bold'] = "s"; } else { if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getFont()->setBold(true); $this->Nm_ActiveSheet->getColumnDimension($current_cell_ref)->setAutoSize(true); } $this->Xls_col++; } $SC_Label = (isset($this->New_label['uf_empresa'])) ? $this->New_label['uf_empresa'] : "UF"; if ($Cada_col == "uf_empresa" && (!isset($this->NM_cmp_hidden[$Cada_col]) \|\| $this->NM_cmp_hidden[$Cada_col] != "off")) { $this->count_span++; $current_cell_ref = $this->calc_cell($this->Xls_col); $SC_Label = NM_charset_to_utf8($SC_Label); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['label'][$this->Xls_col]['data'] = $SC_Label; $this->arr_export['label'][$this->Xls_col]['align'] = "left"; $this->arr_export['label'][$this->Xls_col]['autosize'] = "s"; $this->arr_export['label'][$this->Xls_col]['bold'] = "s"; } else { if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $SC_Label, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getFont()->setBold(true); $this->Nm_ActiveSheet->getColumnDimension($current_cell_ref)->setAutoSize(true); } $this->Xls_col++; } } $this->Xls_col = 0; $this->Xls_row++; } //----- matricula_movimentacao function NM_export_matricula_movimentacao() { $current_cell_ref = $this->calc_cell($this->Xls_col); if (!isset($this->NM_ctrl_style[$current_cell_ref])) { $this->NM_ctrl_style[$current_cell_ref]['ini'] = $this->Xls_row; $this->NM_ctrl_style[$current_cell_ref]['align'] = "LEFT"; } $this->NM_ctrl_style[$current_cell_ref]['end'] = $this->Xls_row; $this->matricula_movimentacao = html_entity_decode($this->matricula_movimentacao, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $this->matricula_movimentacao = strip_tags($this->matricula_movimentacao); $this->matricula_movimentacao = NM_charset_to_utf8($this->matricula_movimentacao); if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->matricula_movimentacao, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->matricula_movimentacao, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Xls_col++; } //----- cpf_movimentacao function NM_export_cpf_movimentacao() { $current_cell_ref = $this->calc_cell($this->Xls_col); if (!isset($this->NM_ctrl_style[$current_cell_ref])) { $this->NM_ctrl_style[$current_cell_ref]['ini'] = $this->Xls_row; $this->NM_ctrl_style[$current_cell_ref]['align'] = "LEFT"; } $this->NM_ctrl_style[$current_cell_ref]['end'] = $this->Xls_row; $this->cpf_movimentacao = html_entity_decode($this->cpf_movimentacao, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $this->cpf_movimentacao = strip_tags($this->cpf_movimentacao); $this->cpf_movimentacao = NM_charset_to_utf8($this->cpf_movimentacao); if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->cpf_movimentacao, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->cpf_movimentacao, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Xls_col++; } //----- nome_movimentacao function NM_export_nome_movimentacao() { $current_cell_ref = $this->calc_cell($this->Xls_col); if (!isset($this->NM_ctrl_style[$current_cell_ref])) { $this->NM_ctrl_style[$current_cell_ref]['ini'] = $this->Xls_row; $this->NM_ctrl_style[$current_cell_ref]['align'] = "LEFT"; } $this->NM_ctrl_style[$current_cell_ref]['end'] = $this->Xls_row; $this->nome_movimentacao = html_entity_decode($this->nome_movimentacao, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $this->nome_movimentacao = strip_tags($this->nome_movimentacao); $this->nome_movimentacao = NM_charset_to_utf8($this->nome_movimentacao); if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->nome_movimentacao, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->nome_movimentacao, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Xls_col++; } //----- data_nascimento_movimentacao function NM_export_data_nascimento_movimentacao() { $current_cell_ref = $this->calc_cell($this->Xls_col); if (!isset($this->NM_ctrl_style[$current_cell_ref])) { $this->NM_ctrl_style[$current_cell_ref]['ini'] = $this->Xls_row; $this->NM_ctrl_style[$current_cell_ref]['align'] = "CENTER"; } $this->NM_ctrl_style[$current_cell_ref]['end'] = $this->Xls_row; $this->data_nascimento_movimentacao = substr($this->data_nascimento_movimentacao, 0, 10); if (empty($this->data_nascimento_movimentacao) \|\| $this->data_nascimento_movimentacao == "0000-00-00") { if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->data_nascimento_movimentacao, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->data_nascimento_movimentacao, PHPExcel_Cell_DataType::TYPE_STRING); } } else { $this->Nm_ActiveSheet->setCellValue($current_cell_ref . $this->Xls_row, $this->data_nascimento_movimentacao); $this->NM_ctrl_style[$current_cell_ref]['format'] = $this->SC_date_conf_region; } $this->Xls_col++; } //----- dia_aniver_mov function NM_export_dia_aniver_mov() { $current_cell_ref = $this->calc_cell($this->Xls_col); if (!isset($this->NM_ctrl_style[$current_cell_ref])) { $this->NM_ctrl_style[$current_cell_ref]['ini'] = $this->Xls_row; $this->NM_ctrl_style[$current_cell_ref]['align'] = "CENTER"; } $this->NM_ctrl_style[$current_cell_ref]['end'] = $this->Xls_row; $this->dia_aniver_mov = NM_charset_to_utf8($this->dia_aniver_mov); if (is_numeric($this->dia_aniver_mov)) { $this->NM_ctrl_style[$current_cell_ref]['format'] = '#,##0'; } $this->Nm_ActiveSheet->setCellValue($current_cell_ref . $this->Xls_row, $this->dia_aniver_mov); $this->Xls_col++; } //----- idade_contato function NM_export_idade_contato() { $current_cell_ref = $this->calc_cell($this->Xls_col); if (!isset($this->NM_ctrl_style[$current_cell_ref])) { $this->NM_ctrl_style[$current_cell_ref]['ini'] = $this->Xls_row; $this->NM_ctrl_style[$current_cell_ref]['align'] = "CENTER"; } $this->NM_ctrl_style[$current_cell_ref]['end'] = $this->Xls_row; $this->idade_contato = NM_charset_to_utf8($this->idade_contato); if (is_numeric($this->idade_contato)) { $this->NM_ctrl_style[$current_cell_ref]['format'] = '#,##0'; } $this->Nm_ActiveSheet->setCellValue($current_cell_ref . $this->Xls_row, $this->idade_contato); $this->Xls_col++; } //----- idade_ano function NM_export_idade_ano() { $current_cell_ref = $this->calc_cell($this->Xls_col); if (!isset($this->NM_ctrl_style[$current_cell_ref])) { $this->NM_ctrl_style[$current_cell_ref]['ini'] = $this->Xls_row; $this->NM_ctrl_style[$current_cell_ref]['align'] = "CENTER"; } $this->NM_ctrl_style[$current_cell_ref]['end'] = $this->Xls_row; $this->idade_ano = NM_charset_to_utf8($this->idade_ano); if (is_numeric($this->idade_ano)) { $this->NM_ctrl_style[$current_cell_ref]['format'] = '#,##0'; } $this->Nm_ActiveSheet->setCellValue($current_cell_ref . $this->Xls_row, $this->idade_ano); $this->Xls_col++; } //----- sexo_movimentacao function NM_export_sexo_movimentacao() { $current_cell_ref = $this->calc_cell($this->Xls_col); if (!isset($this->NM_ctrl_style[$current_cell_ref])) { $this->NM_ctrl_style[$current_cell_ref]['ini'] = $this->Xls_row; $this->NM_ctrl_style[$current_cell_ref]['align'] = "LEFT"; } $this->NM_ctrl_style[$current_cell_ref]['end'] = $this->Xls_row; $this->sexo_movimentacao = html_entity_decode($this->sexo_movimentacao, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $this->sexo_movimentacao = strip_tags($this->sexo_movimentacao); $this->sexo_movimentacao = NM_charset_to_utf8($this->sexo_movimentacao); if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->sexo_movimentacao, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->sexo_movimentacao, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Xls_col++; } //----- nome_empresa function NM_export_nome_empresa() { $current_cell_ref = $this->calc_cell($this->Xls_col); if (!isset($this->NM_ctrl_style[$current_cell_ref])) { $this->NM_ctrl_style[$current_cell_ref]['ini'] = $this->Xls_row; $this->NM_ctrl_style[$current_cell_ref]['align'] = "LEFT"; } $this->NM_ctrl_style[$current_cell_ref]['end'] = $this->Xls_row; $this->nome_empresa = html_entity_decode($this->nome_empresa, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $this->nome_empresa = strip_tags($this->nome_empresa); $this->nome_empresa = NM_charset_to_utf8($this->nome_empresa); if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->nome_empresa, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->nome_empresa, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Xls_col++; } //----- ref_produto function NM_export_ref_produto() { $current_cell_ref = $this->calc_cell($this->Xls_col); if (!isset($this->NM_ctrl_style[$current_cell_ref])) { $this->NM_ctrl_style[$current_cell_ref]['ini'] = $this->Xls_row; $this->NM_ctrl_style[$current_cell_ref]['align'] = "LEFT"; } $this->NM_ctrl_style[$current_cell_ref]['end'] = $this->Xls_row; $this->ref_produto = html_entity_decode($this->ref_produto, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $this->ref_produto = strip_tags($this->ref_produto); $this->ref_produto = NM_charset_to_utf8($this->ref_produto); if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->ref_produto, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->ref_produto, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Xls_col++; } //----- nome_produto function NM_export_nome_produto() { $current_cell_ref = $this->calc_cell($this->Xls_col); if (!isset($this->NM_ctrl_style[$current_cell_ref])) { $this->NM_ctrl_style[$current_cell_ref]['ini'] = $this->Xls_row; $this->NM_ctrl_style[$current_cell_ref]['align'] = "LEFT"; } $this->NM_ctrl_style[$current_cell_ref]['end'] = $this->Xls_row; $this->nome_produto = html_entity_decode($this->nome_produto, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $this->nome_produto = strip_tags($this->nome_produto); $this->nome_produto = NM_charset_to_utf8($this->nome_produto); if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->nome_produto, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->nome_produto, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Xls_col++; } //----- nome_lista_parentesco function NM_export_nome_lista_parentesco() { $current_cell_ref = $this->calc_cell($this->Xls_col); if (!isset($this->NM_ctrl_style[$current_cell_ref])) { $this->NM_ctrl_style[$current_cell_ref]['ini'] = $this->Xls_row; $this->NM_ctrl_style[$current_cell_ref]['align'] = "LEFT"; } $this->NM_ctrl_style[$current_cell_ref]['end'] = $this->Xls_row; $this->nome_lista_parentesco = html_entity_decode($this->nome_lista_parentesco, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $this->nome_lista_parentesco = strip_tags($this->nome_lista_parentesco); $this->nome_lista_parentesco = NM_charset_to_utf8($this->nome_lista_parentesco); if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->nome_lista_parentesco, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->nome_lista_parentesco, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Xls_col++; } //----- nome_lista_acomodacao function NM_export_nome_lista_acomodacao() { $current_cell_ref = $this->calc_cell($this->Xls_col); if (!isset($this->NM_ctrl_style[$current_cell_ref])) { $this->NM_ctrl_style[$current_cell_ref]['ini'] = $this->Xls_row; $this->NM_ctrl_style[$current_cell_ref]['align'] = "LEFT"; } $this->NM_ctrl_style[$current_cell_ref]['end'] = $this->Xls_row; $this->nome_lista_acomodacao = html_entity_decode($this->nome_lista_acomodacao, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $this->nome_lista_acomodacao = strip_tags($this->nome_lista_acomodacao); $this->nome_lista_acomodacao = NM_charset_to_utf8($this->nome_lista_acomodacao); if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->nome_lista_acomodacao, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->nome_lista_acomodacao, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Xls_col++; } //----- nome_lista_situacao_beneficiario function NM_export_nome_lista_situacao_beneficiario() { $current_cell_ref = $this->calc_cell($this->Xls_col); if (!isset($this->NM_ctrl_style[$current_cell_ref])) { $this->NM_ctrl_style[$current_cell_ref]['ini'] = $this->Xls_row; $this->NM_ctrl_style[$current_cell_ref]['align'] = "LEFT"; } $this->NM_ctrl_style[$current_cell_ref]['end'] = $this->Xls_row; $this->nome_lista_situacao_beneficiario = html_entity_decode($this->nome_lista_situacao_beneficiario, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $this->nome_lista_situacao_beneficiario = strip_tags($this->nome_lista_situacao_beneficiario); $this->nome_lista_situacao_beneficiario = NM_charset_to_utf8($this->nome_lista_situacao_beneficiario); if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->nome_lista_situacao_beneficiario, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->nome_lista_situacao_beneficiario, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Xls_col++; } //----- nome_lista_tipo_classe function NM_export_nome_lista_tipo_classe() { $current_cell_ref = $this->calc_cell($this->Xls_col); if (!isset($this->NM_ctrl_style[$current_cell_ref])) { $this->NM_ctrl_style[$current_cell_ref]['ini'] = $this->Xls_row; $this->NM_ctrl_style[$current_cell_ref]['align'] = "LEFT"; } $this->NM_ctrl_style[$current_cell_ref]['end'] = $this->Xls_row; $this->nome_lista_tipo_classe = html_entity_decode($this->nome_lista_tipo_classe, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $this->nome_lista_tipo_classe = strip_tags($this->nome_lista_tipo_classe); $this->nome_lista_tipo_classe = NM_charset_to_utf8($this->nome_lista_tipo_classe); if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->nome_lista_tipo_classe, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->nome_lista_tipo_classe, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Xls_col++; } //----- cod_movimentacao function NM_export_cod_movimentacao() { $current_cell_ref = $this->calc_cell($this->Xls_col); if (!isset($this->NM_ctrl_style[$current_cell_ref])) { $this->NM_ctrl_style[$current_cell_ref]['ini'] = $this->Xls_row; $this->NM_ctrl_style[$current_cell_ref]['align'] = "LEFT"; } $this->NM_ctrl_style[$current_cell_ref]['end'] = $this->Xls_row; $this->cod_movimentacao = html_entity_decode($this->cod_movimentacao, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $this->cod_movimentacao = strip_tags($this->cod_movimentacao); $this->cod_movimentacao = NM_charset_to_utf8($this->cod_movimentacao); if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->cod_movimentacao, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->cod_movimentacao, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Xls_col++; } //----- data_inicio_vigencia_movimentacao function NM_export_data_inicio_vigencia_movimentacao() { $current_cell_ref = $this->calc_cell($this->Xls_col); if (!isset($this->NM_ctrl_style[$current_cell_ref])) { $this->NM_ctrl_style[$current_cell_ref]['ini'] = $this->Xls_row; $this->NM_ctrl_style[$current_cell_ref]['align'] = "CENTER"; } $this->NM_ctrl_style[$current_cell_ref]['end'] = $this->Xls_row; $this->data_inicio_vigencia_movimentacao = substr($this->data_inicio_vigencia_movimentacao, 0, 10); if (empty($this->data_inicio_vigencia_movimentacao) \|\| $this->data_inicio_vigencia_movimentacao == "0000-00-00") { if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->data_inicio_vigencia_movimentacao, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->data_inicio_vigencia_movimentacao, PHPExcel_Cell_DataType::TYPE_STRING); } } else { $this->Nm_ActiveSheet->setCellValue($current_cell_ref . $this->Xls_row, $this->data_inicio_vigencia_movimentacao); $this->NM_ctrl_style[$current_cell_ref]['format'] = $this->SC_date_conf_region; } $this->Xls_col++; } //----- data_movimentacao_movimentacao function NM_export_data_movimentacao_movimentacao() { $current_cell_ref = $this->calc_cell($this->Xls_col); if (!isset($this->NM_ctrl_style[$current_cell_ref])) { $this->NM_ctrl_style[$current_cell_ref]['ini'] = $this->Xls_row; $this->NM_ctrl_style[$current_cell_ref]['align'] = "CENTER"; } $this->NM_ctrl_style[$current_cell_ref]['end'] = $this->Xls_row; $this->data_movimentacao_movimentacao = substr($this->data_movimentacao_movimentacao, 0, 10); if (empty($this->data_movimentacao_movimentacao) \|\| $this->data_movimentacao_movimentacao == "0000-00-00") { if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->data_movimentacao_movimentacao, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->data_movimentacao_movimentacao, PHPExcel_Cell_DataType::TYPE_STRING); } } else { $this->Nm_ActiveSheet->setCellValue($current_cell_ref . $this->Xls_row, $this->data_movimentacao_movimentacao); $this->NM_ctrl_style[$current_cell_ref]['format'] = $this->SC_date_conf_region; } $this->Xls_col++; } //----- idade_movimentacao function NM_export_idade_movimentacao() { $current_cell_ref = $this->calc_cell($this->Xls_col); if (!isset($this->NM_ctrl_style[$current_cell_ref])) { $this->NM_ctrl_style[$current_cell_ref]['ini'] = $this->Xls_row; $this->NM_ctrl_style[$current_cell_ref]['align'] = "CENTER"; } $this->NM_ctrl_style[$current_cell_ref]['end'] = $this->Xls_row; $this->idade_movimentacao = NM_charset_to_utf8($this->idade_movimentacao); if (is_numeric($this->idade_movimentacao)) { $this->NM_ctrl_style[$current_cell_ref]['format'] = '#,##0'; } $this->Nm_ActiveSheet->setCellValue($current_cell_ref . $this->Xls_row, $this->idade_movimentacao); $this->Xls_col++; } //----- fone_fixo_movimentacao function NM_export_fone_fixo_movimentacao() { $current_cell_ref = $this->calc_cell($this->Xls_col); if (!isset($this->NM_ctrl_style[$current_cell_ref])) { $this->NM_ctrl_style[$current_cell_ref]['ini'] = $this->Xls_row; $this->NM_ctrl_style[$current_cell_ref]['align'] = "LEFT"; } $this->NM_ctrl_style[$current_cell_ref]['end'] = $this->Xls_row; $this->fone_fixo_movimentacao = html_entity_decode($this->fone_fixo_movimentacao, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $this->fone_fixo_movimentacao = strip_tags($this->fone_fixo_movimentacao); $this->fone_fixo_movimentacao = NM_charset_to_utf8($this->fone_fixo_movimentacao); if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->fone_fixo_movimentacao, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->fone_fixo_movimentacao, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Xls_col++; } //----- fone_celular_movimentacao function NM_export_fone_celular_movimentacao() { $current_cell_ref = $this->calc_cell($this->Xls_col); if (!isset($this->NM_ctrl_style[$current_cell_ref])) { $this->NM_ctrl_style[$current_cell_ref]['ini'] = $this->Xls_row; $this->NM_ctrl_style[$current_cell_ref]['align'] = "LEFT"; } $this->NM_ctrl_style[$current_cell_ref]['end'] = $this->Xls_row; $this->fone_celular_movimentacao = html_entity_decode($this->fone_celular_movimentacao, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $this->fone_celular_movimentacao = strip_tags($this->fone_celular_movimentacao); $this->fone_celular_movimentacao = NM_charset_to_utf8($this->fone_celular_movimentacao); if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->fone_celular_movimentacao, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->fone_celular_movimentacao, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Xls_col++; } //----- fone_whatsapp_movimentacao function NM_export_fone_whatsapp_movimentacao() { $current_cell_ref = $this->calc_cell($this->Xls_col); if (!isset($this->NM_ctrl_style[$current_cell_ref])) { $this->NM_ctrl_style[$current_cell_ref]['ini'] = $this->Xls_row; $this->NM_ctrl_style[$current_cell_ref]['align'] = "LEFT"; } $this->NM_ctrl_style[$current_cell_ref]['end'] = $this->Xls_row; $this->fone_whatsapp_movimentacao = html_entity_decode($this->fone_whatsapp_movimentacao, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $this->fone_whatsapp_movimentacao = strip_tags($this->fone_whatsapp_movimentacao); $this->fone_whatsapp_movimentacao = NM_charset_to_utf8($this->fone_whatsapp_movimentacao); if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->fone_whatsapp_movimentacao, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->fone_whatsapp_movimentacao, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Xls_col++; } //----- email_movimentacao function NM_export_email_movimentacao() { $current_cell_ref = $this->calc_cell($this->Xls_col); if (!isset($this->NM_ctrl_style[$current_cell_ref])) { $this->NM_ctrl_style[$current_cell_ref]['ini'] = $this->Xls_row; $this->NM_ctrl_style[$current_cell_ref]['align'] = "LEFT"; } $this->NM_ctrl_style[$current_cell_ref]['end'] = $this->Xls_row; $this->email_movimentacao = NM_charset_to_utf8($this->email_movimentacao); if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->email_movimentacao, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->email_movimentacao, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Xls_col++; } //----- obs_movimentacao function NM_export_obs_movimentacao() { $current_cell_ref = $this->calc_cell($this->Xls_col); if (!isset($this->NM_ctrl_style[$current_cell_ref])) { $this->NM_ctrl_style[$current_cell_ref]['ini'] = $this->Xls_row; $this->NM_ctrl_style[$current_cell_ref]['align'] = "LEFT"; } $this->NM_ctrl_style[$current_cell_ref]['end'] = $this->Xls_row; $this->obs_movimentacao = html_entity_decode($this->obs_movimentacao, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $this->obs_movimentacao = strip_tags($this->obs_movimentacao); $this->obs_movimentacao = NM_charset_to_utf8($this->obs_movimentacao); if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->obs_movimentacao, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->obs_movimentacao, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Xls_col++; } //----- criado_data_movimentacao function NM_export_criado_data_movimentacao() { $current_cell_ref = $this->calc_cell($this->Xls_col); if (!isset($this->NM_ctrl_style[$current_cell_ref])) { $this->NM_ctrl_style[$current_cell_ref]['ini'] = $this->Xls_row; $this->NM_ctrl_style[$current_cell_ref]['align'] = "CENTER"; } $this->NM_ctrl_style[$current_cell_ref]['end'] = $this->Xls_row; if (!empty($this->criado_data_movimentacao)) { if (substr($this->criado_data_movimentacao, 10, 1) == "-") { $this->criado_data_movimentacao = substr($this->criado_data_movimentacao, 0, 10) . " " . substr($this->criado_data_movimentacao, 11); } if (substr($this->criado_data_movimentacao, 13, 1) == ".") { $this->criado_data_movimentacao = substr($this->criado_data_movimentacao, 0, 13) . ":" . substr($this->criado_data_movimentacao, 14, 2) . ":" . substr($this->criado_data_movimentacao, 17); } $conteudo_x = $this->criado_data_movimentacao; nm_conv_limpa_dado($conteudo_x, "YYYY-MM-DD HH:II:SS"); if (is_numeric($conteudo_x) && strlen($conteudo_x) > 0) { $this->nm_data->SetaData($this->criado_data_movimentacao, "YYYY-MM-DD HH:II:SS "); $this->criado_data_movimentacao = $this->nm_data->FormataSaida($this->nm_data->FormatRegion("DH", "ddmmaaaa;hhiiss")); } } $this->criado_data_movimentacao = NM_charset_to_utf8($this->criado_data_movimentacao); if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->criado_data_movimentacao, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->criado_data_movimentacao, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Xls_col++; } //----- criado_user_movimentacao function NM_export_criado_user_movimentacao() { $current_cell_ref = $this->calc_cell($this->Xls_col); if (!isset($this->NM_ctrl_style[$current_cell_ref])) { $this->NM_ctrl_style[$current_cell_ref]['ini'] = $this->Xls_row; $this->NM_ctrl_style[$current_cell_ref]['align'] = "LEFT"; } $this->NM_ctrl_style[$current_cell_ref]['end'] = $this->Xls_row; $this->criado_user_movimentacao = html_entity_decode($this->criado_user_movimentacao, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $this->criado_user_movimentacao = strip_tags($this->criado_user_movimentacao); $this->criado_user_movimentacao = NM_charset_to_utf8($this->criado_user_movimentacao); if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->criado_user_movimentacao, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->criado_user_movimentacao, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Xls_col++; } //----- cnpj_empresa function NM_export_cnpj_empresa() { $current_cell_ref = $this->calc_cell($this->Xls_col); if (!isset($this->NM_ctrl_style[$current_cell_ref])) { $this->NM_ctrl_style[$current_cell_ref]['ini'] = $this->Xls_row; $this->NM_ctrl_style[$current_cell_ref]['align'] = "LEFT"; } $this->NM_ctrl_style[$current_cell_ref]['end'] = $this->Xls_row; if (!empty($this->cnpj_empresa)) { if (strlen($this->cnpj_empresa) < 14) { $this->cnpj_empresa = str_repeat(0, 14 - strlen($this->cnpj_empresa)) . $this->cnpj_empresa; } elseif (strlen($this->cnpj_empresa) > 14) { $this->cnpj_empresa = substr($this->cnpj_empresa, strlen($this->cnpj_empresa) - 14); } nmgp_Form_CicCnpj($this->cnpj_empresa) ; } $this->cnpj_empresa = NM_charset_to_utf8($this->cnpj_empresa); if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->cnpj_empresa, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->cnpj_empresa, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Xls_col++; } //----- municipio_empresa function NM_export_municipio_empresa() { $current_cell_ref = $this->calc_cell($this->Xls_col); if (!isset($this->NM_ctrl_style[$current_cell_ref])) { $this->NM_ctrl_style[$current_cell_ref]['ini'] = $this->Xls_row; $this->NM_ctrl_style[$current_cell_ref]['align'] = "LEFT"; } $this->NM_ctrl_style[$current_cell_ref]['end'] = $this->Xls_row; $this->municipio_empresa = html_entity_decode($this->municipio_empresa, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $this->municipio_empresa = strip_tags($this->municipio_empresa); $this->municipio_empresa = NM_charset_to_utf8($this->municipio_empresa); if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->municipio_empresa, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->municipio_empresa, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Xls_col++; } //----- uf_empresa function NM_export_uf_empresa() { $current_cell_ref = $this->calc_cell($this->Xls_col); if (!isset($this->NM_ctrl_style[$current_cell_ref])) { $this->NM_ctrl_style[$current_cell_ref]['ini'] = $this->Xls_row; $this->NM_ctrl_style[$current_cell_ref]['align'] = "LEFT"; } $this->NM_ctrl_style[$current_cell_ref]['end'] = $this->Xls_row; $this->uf_empresa = html_entity_decode($this->uf_empresa, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $this->uf_empresa = strip_tags($this->uf_empresa); $this->uf_empresa = NM_charset_to_utf8($this->uf_empresa); if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->uf_empresa, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); } else { $this->Nm_ActiveSheet->setCellValueExplicit($current_cell_ref . $this->Xls_row, $this->uf_empresa, PHPExcel_Cell_DataType::TYPE_STRING); } $this->Xls_col++; } //----- matricula_movimentacao function NM_sub_cons_matricula_movimentacao() { $this->matricula_movimentacao = html_entity_decode($this->matricula_movimentacao, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $this->matricula_movimentacao = strip_tags($this->matricula_movimentacao); $this->matricula_movimentacao = NM_charset_to_utf8($this->matricula_movimentacao); $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = $this->matricula_movimentacao; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "left"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "char"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = ""; $this->Xls_col++; } //----- cpf_movimentacao function NM_sub_cons_cpf_movimentacao() { $this->cpf_movimentacao = html_entity_decode($this->cpf_movimentacao, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $this->cpf_movimentacao = strip_tags($this->cpf_movimentacao); $this->cpf_movimentacao = NM_charset_to_utf8($this->cpf_movimentacao); $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = $this->cpf_movimentacao; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "left"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "char"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = ""; $this->Xls_col++; } //----- nome_movimentacao function NM_sub_cons_nome_movimentacao() { $this->nome_movimentacao = html_entity_decode($this->nome_movimentacao, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $this->nome_movimentacao = strip_tags($this->nome_movimentacao); $this->nome_movimentacao = NM_charset_to_utf8($this->nome_movimentacao); $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = $this->nome_movimentacao; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "left"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "char"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = ""; $this->Xls_col++; } //----- data_nascimento_movimentacao function NM_sub_cons_data_nascimento_movimentacao() { $this->data_nascimento_movimentacao = substr($this->data_nascimento_movimentacao, 0, 10); $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = $this->data_nascimento_movimentacao; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "data"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "center"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = $this->SC_date_conf_region; $this->Xls_col++; } //----- dia_aniver_mov function NM_sub_cons_dia_aniver_mov() { $this->dia_aniver_mov = NM_charset_to_utf8($this->dia_aniver_mov); $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = $this->dia_aniver_mov; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "center"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "num"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = "#,##0"; $this->Xls_col++; } //----- idade_contato function NM_sub_cons_idade_contato() { $this->idade_contato = NM_charset_to_utf8($this->idade_contato); $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = $this->idade_contato; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "center"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "num"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = "#,##0"; $this->Xls_col++; } //----- idade_ano function NM_sub_cons_idade_ano() { $this->idade_ano = NM_charset_to_utf8($this->idade_ano); $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = $this->idade_ano; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "center"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "num"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = "#,##0"; $this->Xls_col++; } //----- sexo_movimentacao function NM_sub_cons_sexo_movimentacao() { $this->sexo_movimentacao = html_entity_decode($this->sexo_movimentacao, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $this->sexo_movimentacao = strip_tags($this->sexo_movimentacao); $this->sexo_movimentacao = NM_charset_to_utf8($this->sexo_movimentacao); $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = $this->sexo_movimentacao; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "left"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "char"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = ""; $this->Xls_col++; } //----- nome_empresa function NM_sub_cons_nome_empresa() { $this->nome_empresa = html_entity_decode($this->nome_empresa, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $this->nome_empresa = strip_tags($this->nome_empresa); $this->nome_empresa = NM_charset_to_utf8($this->nome_empresa); $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = $this->nome_empresa; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "left"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "char"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = ""; $this->Xls_col++; } //----- ref_produto function NM_sub_cons_ref_produto() { $this->ref_produto = html_entity_decode($this->ref_produto, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $this->ref_produto = strip_tags($this->ref_produto); $this->ref_produto = NM_charset_to_utf8($this->ref_produto); $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = $this->ref_produto; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "left"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "char"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = ""; $this->Xls_col++; } //----- nome_produto function NM_sub_cons_nome_produto() { $this->nome_produto = html_entity_decode($this->nome_produto, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $this->nome_produto = strip_tags($this->nome_produto); $this->nome_produto = NM_charset_to_utf8($this->nome_produto); $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = $this->nome_produto; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "left"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "char"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = ""; $this->Xls_col++; } //----- nome_lista_parentesco function NM_sub_cons_nome_lista_parentesco() { $this->nome_lista_parentesco = html_entity_decode($this->nome_lista_parentesco, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $this->nome_lista_parentesco = strip_tags($this->nome_lista_parentesco); $this->nome_lista_parentesco = NM_charset_to_utf8($this->nome_lista_parentesco); $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = $this->nome_lista_parentesco; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "left"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "char"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = ""; $this->Xls_col++; } //----- nome_lista_acomodacao function NM_sub_cons_nome_lista_acomodacao() { $this->nome_lista_acomodacao = html_entity_decode($this->nome_lista_acomodacao, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $this->nome_lista_acomodacao = strip_tags($this->nome_lista_acomodacao); $this->nome_lista_acomodacao = NM_charset_to_utf8($this->nome_lista_acomodacao); $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = $this->nome_lista_acomodacao; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "left"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "char"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = ""; $this->Xls_col++; } //----- nome_lista_situacao_beneficiario function NM_sub_cons_nome_lista_situacao_beneficiario() { $this->nome_lista_situacao_beneficiario = html_entity_decode($this->nome_lista_situacao_beneficiario, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $this->nome_lista_situacao_beneficiario = strip_tags($this->nome_lista_situacao_beneficiario); $this->nome_lista_situacao_beneficiario = NM_charset_to_utf8($this->nome_lista_situacao_beneficiario); $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = $this->nome_lista_situacao_beneficiario; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "left"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "char"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = ""; $this->Xls_col++; } //----- nome_lista_tipo_classe function NM_sub_cons_nome_lista_tipo_classe() { $this->nome_lista_tipo_classe = html_entity_decode($this->nome_lista_tipo_classe, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $this->nome_lista_tipo_classe = strip_tags($this->nome_lista_tipo_classe); $this->nome_lista_tipo_classe = NM_charset_to_utf8($this->nome_lista_tipo_classe); $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = $this->nome_lista_tipo_classe; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "left"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "char"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = ""; $this->Xls_col++; } //----- cod_movimentacao function NM_sub_cons_cod_movimentacao() { $this->cod_movimentacao = html_entity_decode($this->cod_movimentacao, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $this->cod_movimentacao = strip_tags($this->cod_movimentacao); $this->cod_movimentacao = NM_charset_to_utf8($this->cod_movimentacao); $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = $this->cod_movimentacao; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "left"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "char"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = ""; $this->Xls_col++; } //----- data_inicio_vigencia_movimentacao function NM_sub_cons_data_inicio_vigencia_movimentacao() { $this->data_inicio_vigencia_movimentacao = substr($this->data_inicio_vigencia_movimentacao, 0, 10); $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = $this->data_inicio_vigencia_movimentacao; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "data"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "center"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = $this->SC_date_conf_region; $this->Xls_col++; } //----- data_movimentacao_movimentacao function NM_sub_cons_data_movimentacao_movimentacao() { $this->data_movimentacao_movimentacao = substr($this->data_movimentacao_movimentacao, 0, 10); $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = $this->data_movimentacao_movimentacao; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "data"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "center"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = $this->SC_date_conf_region; $this->Xls_col++; } //----- idade_movimentacao function NM_sub_cons_idade_movimentacao() { $this->idade_movimentacao = NM_charset_to_utf8($this->idade_movimentacao); $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = $this->idade_movimentacao; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "center"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "num"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = "#,##0"; $this->Xls_col++; } //----- fone_fixo_movimentacao function NM_sub_cons_fone_fixo_movimentacao() { $this->fone_fixo_movimentacao = html_entity_decode($this->fone_fixo_movimentacao, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $this->fone_fixo_movimentacao = strip_tags($this->fone_fixo_movimentacao); $this->fone_fixo_movimentacao = NM_charset_to_utf8($this->fone_fixo_movimentacao); $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = $this->fone_fixo_movimentacao; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "left"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "char"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = ""; $this->Xls_col++; } //----- fone_celular_movimentacao function NM_sub_cons_fone_celular_movimentacao() { $this->fone_celular_movimentacao = html_entity_decode($this->fone_celular_movimentacao, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $this->fone_celular_movimentacao = strip_tags($this->fone_celular_movimentacao); $this->fone_celular_movimentacao = NM_charset_to_utf8($this->fone_celular_movimentacao); $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = $this->fone_celular_movimentacao; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "left"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "char"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = ""; $this->Xls_col++; } //----- fone_whatsapp_movimentacao function NM_sub_cons_fone_whatsapp_movimentacao() { $this->fone_whatsapp_movimentacao = html_entity_decode($this->fone_whatsapp_movimentacao, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $this->fone_whatsapp_movimentacao = strip_tags($this->fone_whatsapp_movimentacao); $this->fone_whatsapp_movimentacao = NM_charset_to_utf8($this->fone_whatsapp_movimentacao); $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = $this->fone_whatsapp_movimentacao; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "left"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "char"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = ""; $this->Xls_col++; } //----- email_movimentacao function NM_sub_cons_email_movimentacao() { $this->email_movimentacao = NM_charset_to_utf8($this->email_movimentacao); $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = $this->email_movimentacao; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "left"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "char"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = ""; $this->Xls_col++; } //----- obs_movimentacao function NM_sub_cons_obs_movimentacao() { $this->obs_movimentacao = html_entity_decode($this->obs_movimentacao, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $this->obs_movimentacao = strip_tags($this->obs_movimentacao); $this->obs_movimentacao = NM_charset_to_utf8($this->obs_movimentacao); $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = $this->obs_movimentacao; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "left"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "char"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = ""; $this->Xls_col++; } //----- criado_data_movimentacao function NM_sub_cons_criado_data_movimentacao() { if (!empty($this->criado_data_movimentacao)) { if (substr($this->criado_data_movimentacao, 10, 1) == "-") { $this->criado_data_movimentacao = substr($this->criado_data_movimentacao, 0, 10) . " " . substr($this->criado_data_movimentacao, 11); } if (substr($this->criado_data_movimentacao, 13, 1) == ".") { $this->criado_data_movimentacao = substr($this->criado_data_movimentacao, 0, 13) . ":" . substr($this->criado_data_movimentacao, 14, 2) . ":" . substr($this->criado_data_movimentacao, 17); } $conteudo_x = $this->criado_data_movimentacao; nm_conv_limpa_dado($conteudo_x, "YYYY-MM-DD HH:II:SS"); if (is_numeric($conteudo_x) && strlen($conteudo_x) > 0) { $this->nm_data->SetaData($this->criado_data_movimentacao, "YYYY-MM-DD HH:II:SS "); $this->criado_data_movimentacao = $this->nm_data->FormataSaida($this->nm_data->FormatRegion("DH", "ddmmaaaa;hhiiss")); } } $this->criado_data_movimentacao = NM_charset_to_utf8($this->criado_data_movimentacao); $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = $this->criado_data_movimentacao; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "center"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "char"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = ""; $this->Xls_col++; } //----- criado_user_movimentacao function NM_sub_cons_criado_user_movimentacao() { $this->criado_user_movimentacao = html_entity_decode($this->criado_user_movimentacao, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $this->criado_user_movimentacao = strip_tags($this->criado_user_movimentacao); $this->criado_user_movimentacao = NM_charset_to_utf8($this->criado_user_movimentacao); $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = $this->criado_user_movimentacao; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "left"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "char"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = ""; $this->Xls_col++; } //----- cnpj_empresa function NM_sub_cons_cnpj_empresa() { if (!empty($this->cnpj_empresa)) { if (strlen($this->cnpj_empresa) < 14) { $this->cnpj_empresa = str_repeat(0, 14 - strlen($this->cnpj_empresa)) . $this->cnpj_empresa; } elseif (strlen($this->cnpj_empresa) > 14) { $this->cnpj_empresa = substr($this->cnpj_empresa, strlen($this->cnpj_empresa) - 14); } nmgp_Form_CicCnpj($this->cnpj_empresa) ; } $this->cnpj_empresa = NM_charset_to_utf8($this->cnpj_empresa); $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = $this->cnpj_empresa; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "left"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "char"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = ""; $this->Xls_col++; } //----- municipio_empresa function NM_sub_cons_municipio_empresa() { $this->municipio_empresa = html_entity_decode($this->municipio_empresa, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $this->municipio_empresa = strip_tags($this->municipio_empresa); $this->municipio_empresa = NM_charset_to_utf8($this->municipio_empresa); $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = $this->municipio_empresa; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "left"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "char"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = ""; $this->Xls_col++; } //----- uf_empresa function NM_sub_cons_uf_empresa() { $this->uf_empresa = html_entity_decode($this->uf_empresa, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $this->uf_empresa = strip_tags($this->uf_empresa); $this->uf_empresa = NM_charset_to_utf8($this->uf_empresa); $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = $this->uf_empresa; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "left"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "char"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = ""; $this->Xls_col++; } function xls_sub_cons_copy_label($row) { if (!isset($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['nolabel']) \|\| $_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['nolabel']) { foreach ($this->arr_export['label'] as $col => $dados) { $this->arr_export['lines'][$row][$col] = $dados; } } } function xls_set_style() { if (!empty($this->NM_ctrl_style)) { foreach ($this->NM_ctrl_style as $col => $dados) { $cell_ref = $col . $dados['ini'] . ":" . $col . $dados['end']; if ($this->Use_phpspreadsheet) { if ($dados['align'] == "LEFT") { $this->Nm_ActiveSheet->getStyle($cell_ref)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT); } elseif ($dados['align'] == "RIGHT") { $this->Nm_ActiveSheet->getStyle($cell_ref)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_RIGHT); } else { $this->Nm_ActiveSheet->getStyle($cell_ref)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER); } } else { if ($dados['align'] == "LEFT") { $this->Nm_ActiveSheet->getStyle($cell_ref)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); } elseif ($dados['align'] == "RIGHT") { $this->Nm_ActiveSheet->getStyle($cell_ref)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT); } else { $this->Nm_ActiveSheet->getStyle($cell_ref)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); } } if (isset($dados['format'])) { $this->Nm_ActiveSheet->getStyle($cell_ref)->getNumberFormat()->setFormatCode($dados['format']); } } $this->NM_ctrl_style = array(); } } function quebra_sexo_movimentacao_sc_free_group_by($Cmp_qb, $Where_qb, $Cmp_Name) { $Var_name_gb = "SC_tot_" . $Cmp_Name; $Cmps_Gb_Free = "campos_quebra_" . $Cmp_Name; $Desc_Gb_Ant = $Cmp_Name . "_ant_desc"; global $$Var_name_gb, $Desc_Gb_Ant; $this->sc_proc_quebra_mes_aniver_mov = false; $this->sc_proc_quebra_nome_empresa = false; $this->sc_proc_quebra_nome_produto = false; $this->sc_proc_quebra_sexo_movimentacao = true; $this->Tot->quebra_sexo_movimentacao_sc_free_group_by($Cmp_qb, $Where_qb, $Cmp_Name); $tot_sexo_movimentacao = $$Var_name_gb; $conteudo = $tot_sexo_movimentacao[0] ; $this->count_sexo_movimentacao = $tot_sexo_movimentacao[1]; $Temp_cmp_quebra = array(); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['opcao'] == "pdf" && isset($_SESSION['nm_session']['sys_wkhtmltopdf_show_html_content']) && $_SESSION['nm_session']['sys_wkhtmltopdf_show_html_content'] == 'Y') { $conteudo = NM_encode_input(sc_strip_script($this->sexo_movimentacao)); } else { $conteudo = sc_strip_script($this->sexo_movimentacao); } $Temp_cmp_quebra[0]['cmp'] = $conteudo; if (isset($this->nmgp_label_quebras['sexo_movimentacao'])) { $Temp_cmp_quebra[0]['lab'] = $this->nmgp_label_quebras['sexo_movimentacao']; } else { $Temp_cmp_quebra[0]['lab'] = "Sexo"; } $this->$Cmps_Gb_Free = $Temp_cmp_quebra; $this->sc_proc_quebra_sexo_movimentacao = false; } function quebra_mes_aniver_mov_sc_free_group_by($Cmp_qb, $Where_qb, $Cmp_Name) { $Var_name_gb = "SC_tot_" . $Cmp_Name; $Cmps_Gb_Free = "campos_quebra_" . $Cmp_Name; $Desc_Gb_Ant = $Cmp_Name . "_ant_desc"; global $$Var_name_gb, $Desc_Gb_Ant; $this->sc_proc_quebra_sexo_movimentacao = false; $this->sc_proc_quebra_nome_empresa = false; $this->sc_proc_quebra_nome_produto = false; $this->sc_proc_quebra_mes_aniver_mov = true; $this->Tot->quebra_mes_aniver_mov_sc_free_group_by($Cmp_qb, $Where_qb, $Cmp_Name); $tot_mes_aniver_mov = $$Var_name_gb; $conteudo = $tot_mes_aniver_mov[0] ; $this->count_mes_aniver_mov = $tot_mes_aniver_mov[1]; $Temp_cmp_quebra = array(); $conteudo = NM_encode_input(sc_strip_script($this->mes_aniver_mov)); nmgp_Form_Num_Val($conteudo, $_SESSION['scriptcase']['reg_conf']['grup_num'], $_SESSION['scriptcase']['reg_conf']['dec_num'], "0", "S", "2", "", "N:" . $_SESSION['scriptcase']['reg_conf']['neg_num'] , $_SESSION['scriptcase']['reg_conf']['simb_neg'], $_SESSION['scriptcase']['reg_conf']['num_group_digit']) ; $Temp_cmp_quebra[0]['cmp'] = $conteudo; if (isset($this->nmgp_label_quebras['mes_aniver_mov'])) { $Temp_cmp_quebra[0]['lab'] = $this->nmgp_label_quebras['mes_aniver_mov']; } else { $Temp_cmp_quebra[0]['lab'] = "Mês"; } $this->$Cmps_Gb_Free = $Temp_cmp_quebra; $this->sc_proc_quebra_mes_aniver_mov = false; } function quebra_nome_empresa_sc_free_group_by($Cmp_qb, $Where_qb, $Cmp_Name) { $Var_name_gb = "SC_tot_" . $Cmp_Name; $Cmps_Gb_Free = "campos_quebra_" . $Cmp_Name; $Desc_Gb_Ant = $Cmp_Name . "_ant_desc"; global $$Var_name_gb, $Desc_Gb_Ant; $this->sc_proc_quebra_sexo_movimentacao = false; $this->sc_proc_quebra_mes_aniver_mov = false; $this->sc_proc_quebra_nome_produto = false; $this->sc_proc_quebra_nome_empresa = true; $this->Tot->quebra_nome_empresa_sc_free_group_by($Cmp_qb, $Where_qb, $Cmp_Name); $tot_nome_empresa = $$Var_name_gb; $conteudo = $tot_nome_empresa[0] ; $this->count_nome_empresa = $tot_nome_empresa[1]; $Temp_cmp_quebra = array(); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['opcao'] == "pdf" && isset($_SESSION['nm_session']['sys_wkhtmltopdf_show_html_content']) && $_SESSION['nm_session']['sys_wkhtmltopdf_show_html_content'] == 'Y') { $conteudo = NM_encode_input(sc_strip_script($this->nome_empresa)); } else { $conteudo = sc_strip_script($this->nome_empresa); } $Temp_cmp_quebra[0]['cmp'] = $conteudo; if (isset($this->nmgp_label_quebras['nome_empresa'])) { $Temp_cmp_quebra[0]['lab'] = $this->nmgp_label_quebras['nome_empresa']; } else { $Temp_cmp_quebra[0]['lab'] = "Empresa"; } $this->$Cmps_Gb_Free = $Temp_cmp_quebra; $this->sc_proc_quebra_nome_empresa = false; } function quebra_nome_produto_sc_free_group_by($Cmp_qb, $Where_qb, $Cmp_Name) { $Var_name_gb = "SC_tot_" . $Cmp_Name; $Cmps_Gb_Free = "campos_quebra_" . $Cmp_Name; $Desc_Gb_Ant = $Cmp_Name . "_ant_desc"; global $$Var_name_gb, $Desc_Gb_Ant; $this->sc_proc_quebra_sexo_movimentacao = false; $this->sc_proc_quebra_mes_aniver_mov = false; $this->sc_proc_quebra_nome_empresa = false; $this->sc_proc_quebra_nome_produto = true; $this->Tot->quebra_nome_produto_sc_free_group_by($Cmp_qb, $Where_qb, $Cmp_Name); $tot_nome_produto = $$Var_name_gb; $conteudo = $tot_nome_produto[0] ; $this->count_nome_produto = $tot_nome_produto[1]; $Temp_cmp_quebra = array(); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['opcao'] == "pdf" && isset($_SESSION['nm_session']['sys_wkhtmltopdf_show_html_content']) && $_SESSION['nm_session']['sys_wkhtmltopdf_show_html_content'] == 'Y') { $conteudo = NM_encode_input(sc_strip_script($this->nome_produto)); } else { $conteudo = sc_strip_script($this->nome_produto); } $Temp_cmp_quebra[0]['cmp'] = $conteudo; if (isset($this->nmgp_label_quebras['nome_produto'])) { $Temp_cmp_quebra[0]['lab'] = $this->nmgp_label_quebras['nome_produto']; } else { $Temp_cmp_quebra[0]['lab'] = "Produto"; } $this->$Cmps_Gb_Free = $Temp_cmp_quebra; $this->sc_proc_quebra_nome_produto = false; } function quebra_sexo_movimentacao_sc_free_group_by_top() { if ($this->groupby_show != "S") { return; } $this->xls_set_style(); $lim_col = 1; $temp_cmp = ""; $cont_col = 0; foreach ($this->campos_quebra_sexo_movimentacao as $cada_campo) { if ($cont_col == $lim_col) { $temp_cmp = html_entity_decode($temp_cmp, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $temp_cmp = strip_tags($temp_cmp); $temp_cmp = NM_charset_to_utf8($temp_cmp); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = $temp_cmp; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "left"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "char"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = ""; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['bold'] = ""; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['col_span_f'] = $this->Xls_tot_col; } else { $current_cell_ref = $this->calc_cell($this->Xls_col); if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT); } else { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); } $this->Nm_ActiveSheet->setCellValue($current_cell_ref . $this->Xls_row, $temp_cmp); $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getFont()->setBold(true); } $temp_cmp = ""; $cont_col = 0; $this->Xls_row++; } $temp_cmp .= $cada_campo['lab'] . " => " . $cada_campo['cmp'] . " "; $cont_col++; } if (!empty($temp_cmp)) { $temp_cmp = html_entity_decode($temp_cmp, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $temp_cmp = strip_tags($temp_cmp); $temp_cmp = NM_charset_to_utf8($temp_cmp); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = $temp_cmp; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "left"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "char"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = ""; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['bold'] = ""; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['col_span_f'] = $this->Xls_tot_col; } else { $current_cell_ref = $this->calc_cell($this->Xls_col); if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT); } else { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); } $this->Nm_ActiveSheet->setCellValue($current_cell_ref . $this->Xls_row, $temp_cmp); $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getFont()->setBold(true); } } } function quebra_sexo_movimentacao_sc_free_group_by_bot() { if ($this->groupby_show != "S") { return; } $this->xls_set_style(); $prim_cmp = true; $mens_tot_base = ""; $mens_tot = ""; foreach ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['field_order'] as $Cada_cmp) { if (!isset($this->NM_cmp_hidden[$Cada_cmp]) \|\| $this->NM_cmp_hidden[$Cada_cmp] != "off") { if ($prim_cmp) { $mens_tot = html_entity_decode($mens_tot, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $mens_tot = strip_tags($mens_tot); $mens_tot = NM_charset_to_utf8($mens_tot); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = $mens_tot; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "left"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "char"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = ""; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['bold'] = ""; } else { $current_cell_ref = $this->calc_cell($this->Xls_col); if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT); } else { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); } $this->Nm_ActiveSheet->setCellValue($current_cell_ref . $this->Xls_row, $mens_tot); $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getFont()->setBold(true); } } elseif ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = ""; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "left"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "char"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = ""; } $this->Xls_col++; $prim_cmp = false; } } } function quebra_mes_aniver_mov_sc_free_group_by_top() { if ($this->groupby_show != "S") { return; } $this->xls_set_style(); $lim_col = 1; $temp_cmp = ""; $cont_col = 0; foreach ($this->campos_quebra_mes_aniver_mov as $cada_campo) { if ($cont_col == $lim_col) { $temp_cmp = html_entity_decode($temp_cmp, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $temp_cmp = strip_tags($temp_cmp); $temp_cmp = NM_charset_to_utf8($temp_cmp); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = $temp_cmp; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "left"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "char"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = ""; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['bold'] = ""; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['col_span_f'] = $this->Xls_tot_col; } else { $current_cell_ref = $this->calc_cell($this->Xls_col); if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT); } else { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); } $this->Nm_ActiveSheet->setCellValue($current_cell_ref . $this->Xls_row, $temp_cmp); $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getFont()->setBold(true); } $temp_cmp = ""; $cont_col = 0; $this->Xls_row++; } $temp_cmp .= $cada_campo['lab'] . " => " . $cada_campo['cmp'] . " "; $cont_col++; } if (!empty($temp_cmp)) { $temp_cmp = html_entity_decode($temp_cmp, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $temp_cmp = strip_tags($temp_cmp); $temp_cmp = NM_charset_to_utf8($temp_cmp); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = $temp_cmp; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "left"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "char"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = ""; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['bold'] = ""; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['col_span_f'] = $this->Xls_tot_col; } else { $current_cell_ref = $this->calc_cell($this->Xls_col); if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT); } else { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); } $this->Nm_ActiveSheet->setCellValue($current_cell_ref . $this->Xls_row, $temp_cmp); $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getFont()->setBold(true); } } } function quebra_mes_aniver_mov_sc_free_group_by_bot() { if ($this->groupby_show != "S") { return; } $this->xls_set_style(); $prim_cmp = true; $mens_tot_base = ""; $mens_tot = ""; foreach ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['field_order'] as $Cada_cmp) { if (!isset($this->NM_cmp_hidden[$Cada_cmp]) \|\| $this->NM_cmp_hidden[$Cada_cmp] != "off") { if ($prim_cmp) { $mens_tot = html_entity_decode($mens_tot, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $mens_tot = strip_tags($mens_tot); $mens_tot = NM_charset_to_utf8($mens_tot); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = $mens_tot; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "left"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "char"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = ""; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['bold'] = ""; } else { $current_cell_ref = $this->calc_cell($this->Xls_col); if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT); } else { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); } $this->Nm_ActiveSheet->setCellValue($current_cell_ref . $this->Xls_row, $mens_tot); $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getFont()->setBold(true); } } elseif ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = ""; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "left"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "char"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = ""; } $this->Xls_col++; $prim_cmp = false; } } } function quebra_nome_empresa_sc_free_group_by_top() { if ($this->groupby_show != "S") { return; } $this->xls_set_style(); $lim_col = 1; $temp_cmp = ""; $cont_col = 0; foreach ($this->campos_quebra_nome_empresa as $cada_campo) { if ($cont_col == $lim_col) { $temp_cmp = html_entity_decode($temp_cmp, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $temp_cmp = strip_tags($temp_cmp); $temp_cmp = NM_charset_to_utf8($temp_cmp); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = $temp_cmp; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "left"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "char"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = ""; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['bold'] = ""; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['col_span_f'] = $this->Xls_tot_col; } else { $current_cell_ref = $this->calc_cell($this->Xls_col); if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT); } else { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); } $this->Nm_ActiveSheet->setCellValue($current_cell_ref . $this->Xls_row, $temp_cmp); $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getFont()->setBold(true); } $temp_cmp = ""; $cont_col = 0; $this->Xls_row++; } $temp_cmp .= $cada_campo['lab'] . " => " . $cada_campo['cmp'] . " "; $cont_col++; } if (!empty($temp_cmp)) { $temp_cmp = html_entity_decode($temp_cmp, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $temp_cmp = strip_tags($temp_cmp); $temp_cmp = NM_charset_to_utf8($temp_cmp); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = $temp_cmp; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "left"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "char"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = ""; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['bold'] = ""; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['col_span_f'] = $this->Xls_tot_col; } else { $current_cell_ref = $this->calc_cell($this->Xls_col); if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT); } else { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); } $this->Nm_ActiveSheet->setCellValue($current_cell_ref . $this->Xls_row, $temp_cmp); $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getFont()->setBold(true); } } } function quebra_nome_empresa_sc_free_group_by_bot() { if ($this->groupby_show != "S") { return; } $this->xls_set_style(); $prim_cmp = true; $mens_tot_base = ""; $mens_tot = ""; foreach ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['field_order'] as $Cada_cmp) { if (!isset($this->NM_cmp_hidden[$Cada_cmp]) \|\| $this->NM_cmp_hidden[$Cada_cmp] != "off") { if ($prim_cmp) { $mens_tot = html_entity_decode($mens_tot, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $mens_tot = strip_tags($mens_tot); $mens_tot = NM_charset_to_utf8($mens_tot); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = $mens_tot; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "left"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "char"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = ""; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['bold'] = ""; } else { $current_cell_ref = $this->calc_cell($this->Xls_col); if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT); } else { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); } $this->Nm_ActiveSheet->setCellValue($current_cell_ref . $this->Xls_row, $mens_tot); $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getFont()->setBold(true); } } elseif ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = ""; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "left"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "char"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = ""; } $this->Xls_col++; $prim_cmp = false; } } } function quebra_nome_produto_sc_free_group_by_top() { if ($this->groupby_show != "S") { return; } $this->xls_set_style(); $lim_col = 1; $temp_cmp = ""; $cont_col = 0; foreach ($this->campos_quebra_nome_produto as $cada_campo) { if ($cont_col == $lim_col) { $temp_cmp = html_entity_decode($temp_cmp, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $temp_cmp = strip_tags($temp_cmp); $temp_cmp = NM_charset_to_utf8($temp_cmp); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = $temp_cmp; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "left"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "char"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = ""; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['bold'] = ""; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['col_span_f'] = $this->Xls_tot_col; } else { $current_cell_ref = $this->calc_cell($this->Xls_col); if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT); } else { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); } $this->Nm_ActiveSheet->setCellValue($current_cell_ref . $this->Xls_row, $temp_cmp); $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getFont()->setBold(true); } $temp_cmp = ""; $cont_col = 0; $this->Xls_row++; } $temp_cmp .= $cada_campo['lab'] . " => " . $cada_campo['cmp'] . " "; $cont_col++; } if (!empty($temp_cmp)) { $temp_cmp = html_entity_decode($temp_cmp, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $temp_cmp = strip_tags($temp_cmp); $temp_cmp = NM_charset_to_utf8($temp_cmp); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = $temp_cmp; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "left"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "char"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = ""; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['bold'] = ""; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['col_span_f'] = $this->Xls_tot_col; } else { $current_cell_ref = $this->calc_cell($this->Xls_col); if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT); } else { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); } $this->Nm_ActiveSheet->setCellValue($current_cell_ref . $this->Xls_row, $temp_cmp); $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getFont()->setBold(true); } } } function quebra_nome_produto_sc_free_group_by_bot() { if ($this->groupby_show != "S") { return; } $this->xls_set_style(); $prim_cmp = true; $mens_tot_base = ""; $mens_tot = ""; foreach ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['field_order'] as $Cada_cmp) { if (!isset($this->NM_cmp_hidden[$Cada_cmp]) \|\| $this->NM_cmp_hidden[$Cada_cmp] != "off") { if ($prim_cmp) { $mens_tot = html_entity_decode($mens_tot, ENT_COMPAT, $_SESSION['scriptcase']['charset']); $mens_tot = strip_tags($mens_tot); $mens_tot = NM_charset_to_utf8($mens_tot); if ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = $mens_tot; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "left"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "char"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = ""; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['bold'] = ""; } else { $current_cell_ref = $this->calc_cell($this->Xls_col); if ($this->Use_phpspreadsheet) { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT); } else { $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); } $this->Nm_ActiveSheet->setCellValue($current_cell_ref . $this->Xls_row, $mens_tot); $this->Nm_ActiveSheet->getStyle($current_cell_ref . $this->Xls_row)->getFont()->setBold(true); } } elseif ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['embutida']) { $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['data'] = ""; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['align'] = "left"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['type'] = "char"; $this->arr_export['lines'][$this->Xls_row][$this->Xls_col]['format'] = ""; } $this->Xls_col++; $prim_cmp = false; } } } function quebra_geral_sc_free_group_by_bot() { } function calc_cell($col) { $arr_alfa = array("","A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z"); $val_ret = ""; $result = $col + 1; while ($result > 26) { $cel = $result % 26; $result = $result / 26; if ($cel == 0) { $cel = 26; $result--; } $val_ret = $arr_alfa[$cel] . $val_ret; } $val_ret = $arr_alfa[$result] . $val_ret; return $val_ret; } 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; } } function progress_bar_end() { unset($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['xls_file']); if (is_file($this->Xls_f)) { $_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['xls_file'] = $this->Xls_f; } $path_doc_md5 = md5($this->Ini->path_imag_temp . "/" . $this->Arquivo); $_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante'][$path_doc_md5][0] = $this->Ini->path_imag_temp . "/" . $this->Arquivo; $_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante'][$path_doc_md5][1] = $this->Tit_doc; $Mens_bar = $this->Ini->Nm_lang['lang_othr_file_msge']; if ($_SESSION['scriptcase']['charset'] != "UTF-8") { $Mens_bar = sc_convert_encoding($Mens_bar, "UTF-8", $_SESSION['scriptcase']['charset']); } $this->pb->setProgressbarMessage($Mens_bar); $this->pb->setDownloadLink($this->Ini->path_imag_temp . "/" . $this->Arquivo); $this->pb->setDownloadMd5($path_doc_md5); $this->pb->completed(); } //---- function monta_html() { global $nm_url_saida, $nm_lang; include($this->Ini->path_btn . $this->Ini->Str_btn_grid); unset($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['xls_file']); if (is_file($this->Xls_f)) { $_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['xls_file'] = $this->Xls_f; } $path_doc_md5 = md5($this->Ini->path_imag_temp . "/" . $this->Arquivo); $_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante'][$path_doc_md5][0] = $this->Ini->path_imag_temp . "/" . $this->Arquivo; $_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante'][$path_doc_md5][1] = $this->Tit_doc; ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/1999/REC-html401-19991224/loose.dtd"> <HTML<?php echo $_SESSION['scriptcase']['reg_conf']['html_dir'] ?>> <HEAD> <TITLE>Aniversariantes :: Excel</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="Cache-Control" content="post-check=0, pre-check=0"/> <META http-equiv="Pragma" content="no-cache"/> <link rel="shortcut icon" href="../_lib/img/grp__NM__bg__NM__iso_iso_saude.png"> <link rel="stylesheet" type="text/css" href="../_lib/css/<?php echo $this->Ini->str_schema_all ?>_export.css" /> <link rel="stylesheet" type="text/css" href="../_lib/css/<?php echo $this->Ini->str_schema_all ?>_export<?php echo $_SESSION['scriptcase']['reg_conf']['css_dir'] ?>.css" /> <?php if(isset($this->Ini->str_google_fonts) && !empty($this->Ini->str_google_fonts)) { ?> <link rel="stylesheet" type="text/css" href="<?php echo $this->Ini->str_google_fonts ?>" /> <?php } ?> <link rel="stylesheet" type="text/css" href="../_lib/buttons/<?php echo $this->Ini->Str_btn_css ?>" /> </HEAD> <BODY class="scExportPage"> <?php echo $this->Ini->Ajax_result_set ?> <table style="border-collapse: collapse; border-width: 0; height: 100%; width: 100%"><tr><td style="padding: 0; text-align: center; vertical-align: middle"> <table class="scExportTable" align="center"> <tr> <td class="scExportTitle" style="height: 25px">XLS</td> </tr> <tr> <td class="scExportLine" style="width: 100%"> <table style="border-collapse: collapse; border-width: 0; width: 100%"><tr><td class="scExportLineFont" style="padding: 3px 0 0 0" id="idMessage"> <?php echo $this->Ini->Nm_lang['lang_othr_file_msge'] ?> </td><td class="scExportLineFont" style="text-align:right; padding: 3px 0 0 0"> <?php echo nmButtonOutput($this->arr_buttons, "bexportview", "document.Fview.submit()", "document.Fview.submit()", "idBtnView", "", "", "", "", "", "", $this->Ini->path_botoes, "", "", "", "", "", "only_text", "text_right", "", "", "", "", "", "", ""); ?> <?php echo nmButtonOutput($this->arr_buttons, "bdownload", "document.Fdown.submit()", "document.Fdown.submit()", "idBtnDown", "", "", "", "", "", "", $this->Ini->path_botoes, "", "", "", "", "", "only_text", "text_right", "", "", "", "", "", "", ""); ?> <?php echo nmButtonOutput($this->arr_buttons, "bvoltar", "document.F0.submit()", "document.F0.submit()", "idBtnBack", "", "", "", "", "", "", $this->Ini->path_botoes, "", "", "", "", "", "only_text", "text_right", "", "", "", "", "", "", ""); ?> </td></tr></table> </td> </tr> </table> </td></tr></table> <form name="Fview" method="get" action="<?php echo $this->Ini->path_imag_temp . "/" . $this->Arquivo ?>" target="_blank" style="display: none"> </form> <form name="Fdown" method="get" action="grid_aniversariante_download.php" target="_blank" style="display: none"> <input type="hidden" name="script_case_init" value="<?php echo NM_encode_input($this->Ini->sc_page); ?>"> <input type="hidden" name="nm_tit_doc" value="grid_aniversariante"> <input type="hidden" name="nm_name_doc" value="<?php echo $path_doc_md5 ?>"> </form> <FORM name="F0" method=post action="./"> <INPUT type="hidden" name="script_case_init" value="<?php echo NM_encode_input($this->Ini->sc_page); ?>"> <INPUT type="hidden" name="nmgp_opcao" value="<?php echo NM_encode_input($_SESSION['sc_session'][$this->Ini->sc_page]['grid_aniversariante']['xls_return']); ?>"> </FORM> </BODY> </HTML> <?php } function nm_gera_mask(&$nm_campo, $nm_mask) { $trab_campo = $nm_campo; $trab_mask = $nm_mask; $tam_campo = strlen($nm_campo); $trab_saida = ""; $str_highlight_ini = ""; $str_highlight_fim = ""; if(substr($nm_campo, 0, 23) == '<div class="highlight">' && substr($nm_campo, -6) == '</div>') { $str_highlight_ini = substr($nm_campo, 0, 23); $str_highlight_fim = substr($nm_campo, -6); $trab_campo = substr($nm_campo, 23, -6); $tam_campo = strlen($trab_campo); } $mask_num = false; for ($x=0; $x < strlen($trab_mask); $x++) { if (substr($trab_mask, $x, 1) == "#") { $mask_num = true; break; } } if ($mask_num ) { $ver_duas = explode(";", $trab_mask); if (isset($ver_duas[1]) && !empty($ver_duas[1])) { $cont1 = count(explode("#", $ver_duas[0])) - 1; $cont2 = count(explode("#", $ver_duas[1])) - 1; if ($tam_campo >= $cont2) { $trab_mask = $ver_duas[1]; } else { $trab_mask = $ver_duas[0]; } } $tam_mask = strlen($trab_mask); $xdados = 0; for ($x=0; $x < $tam_mask; $x++) { if (substr($trab_mask, $x, 1) == "#" && $xdados < $tam_campo) { $trab_saida .= substr($trab_campo, $xdados, 1); $xdados++; } elseif ($xdados < $tam_campo) { $trab_saida .= substr($trab_mask, $x, 1); } } if ($xdados < $tam_campo) { $trab_saida .= substr($trab_campo, $xdados); } $nm_campo = $str_highlight_ini . $trab_saida . $str_highlight_ini; return; } for ($ix = strlen($trab_mask); $ix > 0; $ix--) { $char_mask = substr($trab_mask, $ix - 1, 1); if ($char_mask != "x" && $char_mask != "z") { $trab_saida = $char_mask . $trab_saida; } else { if ($tam_campo != 0) { $trab_saida = substr($trab_campo, $tam_campo - 1, 1) . $trab_saida; $tam_campo--; } else { $trab_saida = "0" . $trab_saida; } } } if ($tam_campo != 0) { $trab_saida = substr($trab_campo, 0, $tam_campo) . $trab_saida; $trab_mask = str_repeat("z", $tam_campo) . $trab_mask; } $iz = 0; for ($ix = 0; $ix < strlen($trab_mask); $ix++) { $char_mask = substr($trab_mask, $ix, 1); if ($char_mask != "x" && $char_mask != "z") { if ($char_mask == "." \|\| $char_mask == ",") { $trab_saida = substr($trab_saida, 0, $iz) . substr($trab_saida, $iz + 1); } else { $iz++; } } elseif ($char_mask == "x" \|\| substr($trab_saida, $iz, 1) != "0") { $ix = strlen($trab_mask) + 1; } else { $trab_saida = substr($trab_saida, 0, $iz) . substr($trab_saida, $iz + 1); } } $nm_campo = $str_highlight_ini . $trab_saida . $str_highlight_ini; } function css_form() { $_SESSION['scriptcase']['grid_aniversariante']['contr_erro'] = 'on'; $aux = " <style> .scFormHeaderFont{Padding: 3px 10px !important; font-size: 18px !important; font-weight: bold !important;} </style>"; return $aux; $_SESSION['scriptcase']['grid_aniversariante']['contr_erro'] = 'off'; } function css_grid() { $_SESSION['scriptcase']['grid_aniversariante']['contr_erro'] = 'on'; $aux = " <style> .scGridHeaderFont{Padding: 3px 10px !important; font-size: 18px !important; font-weight: bold !important;} </style>"; return $aux; $_SESSION['scriptcase']['grid_aniversariante']['contr_erro'] = 'off'; } function css_filter() { $_SESSION['scriptcase']['grid_aniversariante']['contr_erro'] = 'on'; $aux = " <style> .scFilterHeader{Padding: 3px 10px !important; font-size: 18px !important; font-weight: bold !important;} </style>"; return $aux; $_SESSION['scriptcase']['grid_aniversariante']['contr_erro'] = 'off'; } } ?>

| ver. 1.4 | Github | . | PHP 8.2.18 | Генерация страницы: 0.02 | proxy | phpinfo | Настройка