public function ranking_pesquisa($pk_pesquisa_cat, $pk_serie) { $data = $this->getParametroVisao(); $data['page'] = 'home'; $data['tema'] != '' ? $this->load->setTheme($data['tema']) : ''; $data['msg'] = $this->getMsg(); $data['abaAtiva'] = 8; $data['abaPage'] = 'ranking_pesquisa'; $data['alias'] = 'ranking_pesquisa'; $data['total'] = 0; $sqlGrade = new SqlGrade(); $result = $sqlGrade->get_serie($pk_serie); $data['serie_nome'] = $result[0]['serie_nome']; $data['migalha_pao'] = '<p> <a class="link" href="' . base_url() . 'fap/pesquisa/listar_pes_pesquisas">Índice</a> » <a class="link" href="' . base_url() . 'fap/pesquisa/ranking_pesquisa_cat/' . $this->uri->segment(4) . '">Ranking geral</a> » Ranking por série </p>'; $sqlPesquisa = new SqlPesquisa(); $result = $sqlPesquisa->ranking_pesquisa($pk_pesquisa_cat, $pk_serie, $data['ano_letivo']); $data['total'] = $result['total']; if ($result['total'] > 0) { $this->load->library('table'); $arrHead[] = 'Indicador'; $arrHead[] = 'Professor'; $arrHead[] = 'Turma'; $this->table->set_heading($arrHead); $count = 0; foreach ($result['registros'] as $row) { $count++; $tmpl = Util::zebrar($count, count($result['registros'])); $conceito = View::bgConceito($row['indicadorgeral']); $indicador = array('data' => number_format($row['indicadorgeral'], 1), 'class' => 'tcenter ' . $conceito['class']); $this->table->add_row($indicador, $row['nome'], $row['turma_nome']); } $this->table->set_template($tmpl); } else { $data['msg'] = '<div class="alert atencao">Nenhum registro encontrado</div>'; } // Select turmas $sqlPesquisa = new SqlPesquisa(); $result = $sqlPesquisa->ranking_pesquisa_cat_fitro_turma($pk_pesquisa_cat, $pk_serie, $data['ano_letivo']); $turma = explode("&pk_turma=", $_SERVER['QUERY_STRING']); $turma_url = base_url() . $this->uri->segment(1) . '/' . $this->uri->segment(2) . '/' . $this->uri->segment(3) . '/' . $this->uri->segment(4) . '?' . $turma[0]; $select = '<select name="jumpMenu" id="jumpMenu" class="w300 mr20 mb20" onchange="MM_jumpMenu(\'parent\',this,0)">'; $label_default = isset($_GET['pk_turma']) ? 'Retirar filtro de turma' : 'Filtrar por turma'; $select .= '<option value="' . $turma_url . '">' . $label_default . '</option>'; foreach ($result['registros'] as $row) { $checked = isset($_GET['pk_turma']) && $_GET['pk_turma'] == $row['fk_turma'] ? 'selected' : ''; $select .= '<option value="' . base_url() . $this->uri->segment(1) . '/' . $this->uri->segment(2) . '/ranking_pesquisa_turma/' . $this->uri->segment(4) . '/' . $this->uri->segment(5) . '/' . $row['fk_turma'] . '" ' . $checked . '>' . $row['turma_nome'] . '</option>'; } $select .= '</select>'; $data['filtro_turmas'] = $select; if ($this->input->is_ajax_request()) { echo json_encode(array('content' => $this->load->view($this->uri->segment(3), $data, true))); } else { $this->load->view($this->load->getUrlTema(), $data); } }