Sel_Groupby_init(); class grid_movimentacao_sel_Groupby { function Sel_Groupby_init() { global $opc_ret, $sc_init, $path_img, $path_btn, $groupby_atual, $embbed, $tbar_pos, $_POST, $_GET; if (isset($_POST['script_case_init'])) { $opc_ret = (isset($_POST['opc_ret'])) ? strip_tags($_POST['opc_ret']) : ""; $path_img = (isset($_POST['path_img'])) ? strip_tags($_POST['path_img']) : ""; $path_btn = (isset($_POST['path_btn'])) ? strip_tags($_POST['path_btn']) : ""; $tbar_pos = (isset($_POST['toolbar_pos'])) ? strip_tags($_POST['toolbar_pos']) : ""; $sc_init = filter_input(INPUT_POST, 'script_case_init', FILTER_SANITIZE_NUMBER_INT); $embbed = isset($_POST['embbed_groupby']) && 'Y' == $_POST['embbed_groupby']; } elseif (isset($_GET['script_case_init'])) { $opc_ret = (isset($_GET['opc_ret'])) ? strip_tags($_GET['opc_ret']) : ""; $path_img = (isset($_GET['path_img'])) ? strip_tags($_GET['path_img']) : ""; $path_btn = (isset($_GET['path_btn'])) ? strip_tags($_GET['path_btn']) : ""; $tbar_pos = (isset($_GET['toolbar_pos'])) ? strip_tags($_GET['toolbar_pos']) : ""; $sc_init = filter_input(INPUT_GET, 'script_case_init', FILTER_SANITIZE_NUMBER_INT); $embbed = isset($_GET['embbed_groupby']) && 'Y' == $_GET['embbed_groupby']; } $this->restore = isset($_POST['restore']) ? true : false; if ($this->restore && !class_exists('Services_JSON')) { include_once("grid_movimentacao_json.php"); } $this->Arr_result = array(); $this->static_gb_ok = ""; if ($this->restore) { $groupby_atual = $_SESSION['sc_session'][$sc_init]['grid_movimentacao']['dados_orig_gb']['all']['SC_Ind_Groupby']; } else { $groupby_atual = $_SESSION['sc_session'][$sc_init]['grid_movimentacao']['SC_Ind_Groupby']; } if (isset($_POST['fsel_ok']) && $_POST['fsel_ok'] == "OK" && isset($_POST['sel_groupby']) && !$this->restore) { $this->campos_sel = isset($_POST['campos_sel']) ? $_POST['campos_sel'] : ""; $this->xaxys_fields = isset($_POST['xaxys_fields']) ? $_POST['xaxys_fields'] : ""; $this->summ_fields = isset($_POST['summ_fields']) ? $_POST['summ_fields'] : ""; $this->drill_down = isset($_POST['drill_down']) ? 'Y' == $_POST['drill_down'] : false; $this->Sel_processa_out($_POST['sel_groupby']); } else { if ($embbed) { ob_start(); $this->Sel_processa_form(); $Temp = ob_get_clean(); echo NM_charset_to_utf8($Temp); } else { if ($this->restore) { ob_start(); } $this->Sel_processa_form(); } } exit; } function Sel_processa_out($sel_groupby) { global $sc_init, $groupby_atual, $opc_ret, $embbed; $Change_free_groupby = false; $campos_sel = explode("@?@", $this->campos_sel); if ($sel_groupby == "sc_free_group_by") { if (count($campos_sel) != count($_SESSION['sc_session'][$sc_init]['grid_movimentacao']['SC_Gb_Free_cmp'])) { $Change_free_groupby = true; } else { $Arr_temp = array(); foreach ($_SESSION['sc_session'][$sc_init]['grid_movimentacao']['SC_Gb_Free_cmp'] as $Cada_cmp => $Resto) { $Arr_temp[] = $Cada_cmp; } foreach ($campos_sel as $ind => $cada_cmp) { if ($Arr_temp[$ind] != $cada_cmp) { $Change_free_groupby = true; break; } } } } if ($sel_groupby == "sc_free_group_by" && $opc_ret == "resumo" && empty($this->campos_sel)) { } elseif ($sel_groupby != $groupby_atual || $Change_free_groupby) { if (isset($_SESSION['sc_session'][$sc_init]['grid_movimentacao']['using_summary_cache'])) { unset($_SESSION['sc_session'][$sc_init]['grid_movimentacao']['using_summary_cache']); } $_SESSION['sc_session'][$sc_init]['grid_movimentacao']['SC_Ind_Groupby'] = $sel_groupby; $_SESSION['sc_session'][$sc_init]['grid_movimentacao']['contr_array_resumo'] = "NAO"; $_SESSION['sc_session'][$sc_init]['grid_movimentacao']['contr_total_geral'] = "NAO"; unset($_SESSION['sc_session'][$sc_init]['grid_movimentacao']['ordem_quebra']); unset($_SESSION['sc_session'][$sc_init]['grid_movimentacao']['ordem_select']); unset($_SESSION['sc_session'][$sc_init]['grid_movimentacao']['tot_geral']); unset($_SESSION['sc_session'][$sc_init]['grid_movimentacao']['Page_break_PDF']); unset($_SESSION['sc_session'][$sc_init]['grid_movimentacao']['arr_total']); unset($_SESSION['sc_session'][$sc_init]['grid_movimentacao']['pivot_group_by']); unset($_SESSION['sc_session'][$sc_init]['grid_movimentacao']['pivot_x_axys']); unset($_SESSION['sc_session'][$sc_init]['grid_movimentacao']['pivot_y_axys']); unset($_SESSION['sc_session'][$sc_init]['grid_movimentacao']['pivot_fill']); unset($_SESSION['sc_session'][$sc_init]['grid_movimentacao']['pivot_order']); unset($_SESSION['sc_session'][$sc_init]['grid_movimentacao']['pivot_order_col']); unset($_SESSION['sc_session'][$sc_init]['grid_movimentacao']['pivot_order_level']); unset($_SESSION['sc_session'][$sc_init]['grid_movimentacao']['pivot_order_sort']); unset($_SESSION['sc_session'][$sc_init]['grid_movimentacao']['pivot_order_start']); unset($_SESSION['sc_session'][$sc_init]['grid_movimentacao']['pivot_tabular']); $tab_arr_groubby_cmp = array(); $tab_arr_groubby_sql = array(); $tab_arr_groubby_cmp['nome_empresa'] = array('cmp' => "nome_empresa", 'ind' => 0, 'format' => ""); $tab_arr_groubby_cmp['nome_produto'] = array('cmp' => "nome_produto", 'ind' => 1, 'format' => ""); $tab_arr_groubby_cmp['matricula_movimentacao'] = array('cmp' => "matricula_movimentacao", 'ind' => 2, 'format' => ""); $tab_arr_groubby_cmp['sexo_movimentacao'] = array('cmp' => "sexo_movimentacao", 'ind' => 3, 'format' => ""); $tab_arr_groubby_cmp['nome_lista_parentesco'] = array('cmp' => "nome_lista_parentesco", 'ind' => 4, 'format' => ""); $tab_arr_groubby_cmp['nome_lista_situacao_beneficiario'] = array('cmp' => "nome_lista_situacao_beneficiario", 'ind' => 5, 'format' => ""); $tab_arr_groubby_cmp['nome_lista_tipo_classe'] = array('cmp' => "nome_lista_tipo_classe", 'ind' => 6, 'format' => ""); $tab_arr_groubby_cmp['nome_lista_acomodacao'] = array('cmp' => "nome_lista_acomodacao", 'ind' => 7, 'format' => ""); $tab_arr_groubby_sql[0] = array('cmp' => "nome_empresa", 'ord' => 'asc'); $tab_arr_groubby_sql[1] = array('cmp' => "nome_produto", 'ord' => 'asc'); $tab_arr_groubby_sql[2] = array('cmp' => "matricula_movimentacao", 'ord' => 'asc'); $tab_arr_groubby_sql[3] = array('cmp' => "sexo_movimentacao", 'ord' => 'asc'); $tab_arr_groubby_sql[4] = array('cmp' => "nome_lista_parentesco", 'ord' => 'asc'); $tab_arr_groubby_sql[5] = array('cmp' => "nome_lista_situacao_beneficiario", 'ord' => 'asc'); $tab_arr_groubby_sql[6] = array('cmp' => "nome_lista_tipo_classe", 'ord' => 'asc'); $tab_arr_groubby_sql[7] = array('cmp' => "nome_lista_acomodacao", 'ord' => 'asc'); $_SESSION['sc_session'][$sc_init]['grid_movimentacao']['SC_Gb_Free_cmp'] = array(); $_SESSION['sc_session'][$sc_init]['grid_movimentacao']['SC_Gb_Free_sql'] = array(); $_SESSION['sc_session'][$sc_init]['grid_movimentacao']['SC_Gb_date_format']['sc_free_group_by'] = array(); $_SESSION['sc_session'][$sc_init]['grid_movimentacao']['SC_Gb_Free_orig'] = array(); foreach ($campos_sel as $cada_cmp) { if (!empty($cada_cmp)) { $ind = $tab_arr_groubby_cmp[$cada_cmp]['ind']; $_SESSION['sc_session'][$sc_init]['grid_movimentacao']['SC_Gb_Free_cmp'][$cada_cmp] = $tab_arr_groubby_cmp[$cada_cmp]['cmp']; $_SESSION['sc_session'][$sc_init]['grid_movimentacao']['SC_Gb_Free_sql'][$cada_cmp][$tab_arr_groubby_sql[$ind]['cmp']] = $tab_arr_groubby_sql[$ind]['ord']; $_SESSION['sc_session'][$sc_init]['grid_movimentacao']['SC_Gb_date_format']['sc_free_group_by'][$cada_cmp] = $tab_arr_groubby_cmp[$cada_cmp]['format']; } } } if ($sel_groupby == "sc_free_group_by") { $groupby_this = 0; $groupby_count = sizeof($campos_sel); $xaxys_count = '' == $this->xaxys_fields ? 0 : sizeof(explode("@?@", $this->xaxys_fields)); $xaxys_list = array(); $yaxys_list = array(); for ($i = 0; $i < $groupby_count; $i++) { if (0 == $xaxys_count) { $yaxys_list[$groupby_this] = $groupby_this; } else { $xaxys_list[$groupby_this] = $groupby_this; $xaxys_count--; } $groupby_this++; } if (array_key_exists('pivot_x_axys', $_SESSION['sc_session'][$sc_init]['grid_movimentacao'])) { if ($_SESSION['sc_session'][$sc_init]['grid_movimentacao']['pivot_x_axys'] != $xaxys_list || $_SESSION['sc_session'][$sc_init]['grid_movimentacao']['pivot_y_axys'] != $yaxys_list) { $_SESSION['sc_session'][$sc_init]['grid_movimentacao']['contr_array_resumo'] = "NAO"; $_SESSION['sc_session'][$sc_init]['grid_movimentacao']['contr_total_geral'] = "NAO"; } } $_SESSION['sc_session'][$sc_init]['grid_movimentacao']['pivot_x_axys'] = $xaxys_list; $_SESSION['sc_session'][$sc_init]['grid_movimentacao']['pivot_y_axys'] = $yaxys_list; } if ($opc_ret == "resumo") { $summ_fields = explode("@?@", $this->summ_fields); if(isset($_SESSION['sc_session'][$sc_init]['grid_movimentacao']['summarizing_fields_display'][ $sel_groupby ])) { foreach ($_SESSION['sc_session'][$sc_init]['grid_movimentacao']['summarizing_fields_display'][ $sel_groupby ] as $i_sum => $d_sum) { $_SESSION['sc_session'][$sc_init]['grid_movimentacao']['summarizing_fields_display'][ $sel_groupby ][$i_sum]['display'] = in_array($i_sum, $summ_fields); } } $_SESSION['sc_session'][$sc_init]['grid_movimentacao']['summarizing_fields_order'][ $sel_groupby ] = $summ_fields; $_SESSION['sc_session'][$sc_init]['grid_movimentacao']['summarizing_drill_down'] = $this->drill_down; } ?> Nm_lang = array(); if (is_file($NM_arq_lang)) { include_once($NM_arq_lang); } $_SESSION['scriptcase']['charset'] = "UTF-8"; foreach ($this->Nm_lang as $ind => $dados) { if ($_SESSION['scriptcase']['charset'] != "UTF-8" && NM_is_utf8($ind)) { $ind = sc_convert_encoding($ind, $_SESSION['scriptcase']['charset'], "UTF-8"); $this->Nm_lang[$ind] = $dados; } if ($_SESSION['scriptcase']['charset'] != "UTF-8" && NM_is_utf8($dados)) { $this->Nm_lang[$ind] = sc_convert_encoding($dados, $_SESSION['scriptcase']['charset'], "UTF-8"); } $this->Nm_lang[$ind] = str_replace('"', '"', $this->Nm_lang[$ind]); } $display_free_gb = false; $arr_campos_free = array(); $arr_date_format = array(); $arr_campos_free['nome_empresa'] = "Empresa"; $arr_campos_free['nome_produto'] = "Produto"; $arr_campos_free['matricula_movimentacao'] = "Matricula"; $arr_campos_free['sexo_movimentacao'] = "Sexo"; $arr_campos_free['nome_lista_parentesco'] = "Parentesco"; $arr_campos_free['nome_lista_situacao_beneficiario'] = "Situação do beneficiário"; $arr_campos_free['nome_lista_tipo_classe'] = "Tipo de classe"; $arr_campos_free['nome_lista_acomodacao'] = "Acomodação"; $str_schema_all = (isset($_SESSION['scriptcase']['str_schema_all']) && !empty($_SESSION['scriptcase']['str_schema_all'])) ? $_SESSION['scriptcase']['str_schema_all'] : "Sc9_SoftCloud_sm/Sc9_SoftCloud_sm"; include("../_lib/css/" . $str_schema_all . "_grid.php"); $Str_btn_grid = trim($str_button) . "/" . trim($str_button) . $_SESSION['scriptcase']['reg_conf']['css_dir'] . ".php"; include("../_lib/buttons/" . $Str_btn_grid); if (!function_exists("nmButtonOutput")) { include_once("../_lib/lib/php/nm_gp_config_btn.php"); } $bStartFree = true; $bSummaryPage = (isset($_GET['opc_ret']) && 'resumo' == $_GET['opc_ret']) || ($this->restore && $_POST['SummaryPage'] == "S"); if (!$embbed) { ?> > Movimentação GMT"/>
"; echo ""; } elseif ($_SESSION['scriptcase']['reg_conf']['html_dir'] == " DIR='RTL'") { echo "
"; } else { echo "
"; } ?>
Nm_lang['lang_btns_grpby_hint']; ?>
restore) { ob_end_clean(); ob_start(); } ?> restore) { $this->Arr_result['set_html'][] = array('field' => 'sc_id_tabs_groupby', 'value' => NM_charset_to_utf8(ob_get_contents())); } ?> restore) { ob_end_clean(); ob_start(); } ?> restore) { $this->Arr_result['set_html'][] = array('field' => 'sc_id_free_groupby', 'value' => NM_charset_to_utf8(ob_get_contents())); } ?> restore) ? $_SESSION['sc_session'][$sc_init]['grid_movimentacao']['dados_orig_gb']['res']['summarizing_fields_control'] : $_SESSION['sc_session'][$sc_init]['grid_movimentacao']['summarizing_fields_control']; } if (isset($arr_filds)) { ?> '> restore) { ob_end_clean(); ob_start(); } ?> restore) { $this->Arr_result['set_html'][] = array('field' => 'sc_id_summary', 'value' => NM_charset_to_utf8(ob_get_contents())); } ?> restore) { $oJson = new Services_JSON(); ob_end_clean(); if ($_SESSION['sc_session'][$sc_init]['grid_movimentacao']['dados_orig_gb']['all']['SC_Ind_Groupby'] == "sc_free_group_by") { $this->Arr_result['run_js'][] = "scShowFree()"; } else { $this->Arr_result['set_var'][] = array('var' => 'actual_static_gb', 'value' => $_SESSION['sc_session'][$sc_init]['grid_movimentacao']['dados_orig_gb']['all']['SC_Ind_Groupby']); $this->Arr_result['run_js'][] = "scShowStatic()"; } $this->Arr_result['run_js'][] = "init_js()"; if (!$embbed) { $this->Arr_result['run_js'][] = "ajusta_window()"; } echo $oJson->encode($this->Arr_result); exit; } ?>
/>

Nm_lang['lang_othr_groupby_required']; ?>
Nm_lang['lang_othr_groupby_selected_fld']; if ($bSummaryPage) { $sYAxysLabel = $this->Nm_lang['lang_othr_groupby_axis_y']; } $arr_tmp = ($this->restore) ? $_SESSION['sc_session'][$sc_init]['grid_movimentacao']['dados_orig_gb']['all']['SC_Gb_Free_cmp'] : $_SESSION['sc_session'][$sc_init]['grid_movimentacao']['SC_Gb_Free_cmp']; foreach ($arr_tmp as $NM_cada_field => $resto) { $aYAxysFields[$NM_cada_field] = $resto; } ?> restore) ? $_SESSION['sc_session'][$sc_init]['grid_movimentacao']['dados_orig_gb']['res']['pivot_x_axys'] : $_SESSION['sc_session'][$sc_init]['grid_movimentacao']['pivot_x_axys']; foreach ($arr_pivot_x_axys as $temp) { reset($aTmpGroupBy); $temp_key = key($aTmpGroupBy); $aXAxysFields[$temp_key] = $aTmpGroupBy[$temp_key]; unset($aYAxysFields[$temp_key]); unset($aTmpGroupBy[$temp_key]); } } ?>
Nm_lang['lang_othr_groupby_available_fld']; ?>
    $NM_cada_label) { if (!isset($arr_tmp[$NM_cada_field])) { ?>
    restore) { $xAxysGroupCount = count($_SESSION['sc_session'][$sc_init]['grid_movimentacao']['dados_orig_gb']['res']['pivot_x_axys']); } else { $xAxysGroupCount = count($_SESSION['sc_session'][$sc_init]['grid_movimentacao']['pivot_x_axys']); } } foreach ($aYAxysFields as $NM_cada_field => $resto) { if ($bSummaryPage && 0 != $xAxysGroupCount) { $xAxysGroupCount--; continue; } ?>
Nm_lang['lang_othr_groupby_axis_x']; ?>
    $resto) { ?>
Nm_lang['lang_othr_totals']; ?>
$_arr_fields_totals) { ?>
Nm_lang['lang_othr_groupby_totals_fld']; ?>
    $d_field) { $l_field = $d_field['cmp_res']; $aSummStatus[$l_field] = array(); $sLabel = (isset($d_field['label']) && !empty($d_field['label'])) ? $d_field['label'] : $d_field['label_field']; $sOpDisplay = ''; if('NM_Count' == $l_field || (isset($d_field['options']) && count($d_field['options']) == 1)) { $sOpDisplay = '; display: none'; } ?>
  •  
Nm_lang['lang_othr_groupby_selected_fld']; ?>
    restore) ? $_SESSION['sc_session'][$sc_init]['grid_movimentacao']['dados_orig_gb']['res']['summarizing_fields_display'] : $_SESSION['sc_session'][$sc_init]['grid_movimentacao']['summarizing_fields_display']; } if (!isset($_SESSION['sc_session'][$sc_init]['grid_movimentacao']['summarizing_fields_order'])) { $arr_ord = array(); } else { $arr_ord = ($this->restore) ? $_SESSION['sc_session'][$sc_init]['grid_movimentacao']['dados_orig_gb']['res']['summarizing_fields_order'] : $_SESSION['sc_session'][$sc_init]['grid_movimentacao']['summarizing_fields_order']; } if(isset($arr_ord[ $nome_quebra ]) && is_array($arr_ord[$nome_quebra]) && !empty($arr_ord[$nome_quebra])) { foreach ($arr_ord[$nome_quebra] as $i_sum) { if ('' != $i_sum && isset($arr_disp[$nome_quebra][$i_sum])) { $d_sum = $arr_disp[$nome_quebra][$i_sum]; if ($d_sum['display']) { $sLabel = $d_sum['label']; $sId = ''; $bFound = false; $iKey = $key_total; if(isset($arr_filds[$nome_quebra])) { foreach ($arr_filds[$nome_quebra] as $_key_total => $d_field) { if(is_array($d_field)) { $l_field = $d_field['cmp_res']; foreach ($d_field['options'] as $d_option) { if ($d_option['index'] == $i_sum) { $sLabel = (isset($d_field['label']) && !empty($d_field['label'])) ? $d_field['label'] : $d_field['label_field']; $sId = $l_field; $bFound = true; $iKey = $_key_total; $arr_start_selected[ $nome_quebra ][] = $_key_total; } } if ($bFound) { break; } } } } $sSelDisplay = ''; if('NM_Count' == $sId || (isset($d_field['options']) && count($d_field['options']) == 1)) { $sSelDisplay = ' style="display: none"'; } ?>

$fields) { foreach ($fields as $name => $data) { if (isset($_SESSION['sc_session'][$sc_init]['grid_movimentacao'][$name])) { if ($tp == "all" && ($name != "SC_Gb_Free_cmp" || $_SESSION['sc_session'][$sc_init]['grid_movimentacao']['SC_Ind_Groupby'] == "sc_free_group_by")) { if ($data != $_SESSION['sc_session'][$sc_init]['grid_movimentacao'][$name]) { $disp_rest = ""; break; } } elseif ($tp == "res" && $bSummaryPage && $data != $_SESSION['sc_session'][$sc_init]['grid_movimentacao'][$name]) { $disp_rest = ""; break; } } } } if (!$embbed) { ?> arr_buttons, "bok_appdiv", "proc_btn_gb('f_sel_sub_gb','scPackGroupBy();buttonunselectedGROUP();document.Fsel_quebras.submit()')", "proc_btn_gb('f_sel_sub_gb','scPackGroupBy();buttonunselectedGROUP();document.Fsel_quebras.submit()')", "f_sel_sub_gb", "", "", "", "absmiddle", "", "0px", $path_btn, "", "", "", "", "", "only_text", "text_right", "", "", "", "", "", "", ""); ?> arr_buttons, "bapply_appdiv", "proc_btn_gb('f_sel_sub_gb','scPackGroupBy();scSubmitGroupBy(\\'" . $tbar_pos . "\\')')", "proc_btn_gb('f_sel_sub_gb','scPackGroupBy();scSubmitGroupBy(\\'" . $tbar_pos . "\\')')", "f_sel_sub_gb", "", "", "", "absmiddle", "", "0px", $path_btn, "", "", "", "", "", "only_text", "text_right", "", "", "", "", "", "", ""); ?>     arr_buttons, "brestore_appdiv", "proc_btn_gb('Brestore_gb','restore_gb()')", "proc_btn_gb('Brestore_gb','restore_gb()')", "Brestore_gb", "", "", "", "absmiddle", "", "0px", $path_btn, "", "", "", "", "", "only_text", "text_right", "", "", "", "", "", "", ""); ?> arr_buttons, "brestore_appdiv", "proc_btn_gb('Brestore_gb','restore_gb()')", "proc_btn_gb('Brestore_gb','restore_gb()')", "Brestore_gb", "", "", "", "absmiddle", "", "0px", $path_btn, "", "", "", "", "", "only_text", "text_right", "", "", "", "", "", "", ""); ?>     arr_buttons, "bsair_appdiv", "self.parent.tb_remove(); buttonunselectedGROUP();", "self.parent.tb_remove(); buttonunselectedGROUP();", "Bsair_gb", "", "", "", "absmiddle", "", "0px", $path_btn, "", "", "", "", "", "only_text", "text_right", "", "", "", "", "", "", ""); ?> arr_buttons, "bcancelar_appdiv", "closeAllModalPanes();", "closeAllModalPanes();", "Bsair_gb", "", "", "", "absmiddle", "", "0px", $path_btn, "", "", "", "", "", "only_text", "text_right", "", "", "", "", "", "", ""); ?> arr_buttons, "bcancelar_appdiv", "scBtnGroupByHide('" . $tbar_pos . "'); buttonunselectedGROUP();", "scBtnGroupByHide('" . $tbar_pos . "'); buttonunselectedGROUP();", "Bsair_gb", "", "", "", "absmiddle", "", "0px", $path_btn, "", "", "", "", "", "only_text", "text_right", "", "", "", "", "", "", ""); ?>