public function inscritos($pk_exa_area, $pk_exa_prova, $lingua = '')
{
$data = $this->getParametroVisao();
$data['page'] = 'home';
$data['abaPage'] = __FUNCTION__;
$data['alias'] = __FUNCTION__;
$data['abaAtiva'] = $this->AbaAtiva;
$data['pk_exa_area'] = $pk_exa_area;
$sqlConcurso = new SqlConcurso();
$result = $sqlConcurso->get_prova_nome($pk_exa_prova);
$data['titulo_concurso'] = str_replace(' / geral', '', $result[0]['concurso_tipo_nome'] . ' / ' . $result[0]['concurso_nome'] . ' / ' . $result[0]['bloco_nome'] . ' / ' . $result[0]['area_nome'] . ' / ' . $result[0]['prova_nome']);
$result = $sqlConcurso->listar_inscritos($pk_exa_prova);
$data['total'] = $result['total'];
if (isset($_GET['print']) && $_GET['print'] != '') {
$data['tema'] = $this->load->setTheme('cartoes');
if ($result['total'] > 0) {
$count = 0;
$coluna = 1;
$tabela = '<div class="pagina"><table><tr>';
foreach ($result['registros'] as $row) {
$binario = decbin($row['fk_usuario_aluno']);
$nCaracteres = strlen($binario);
$nome_coluna = $coluna % 2 == 0 ? 'coluna2' : 'coluna1';
$tabela .= '<td class="' . $nome_coluna . ' altura_pagina" valign="top">
<div class="cabecalho">' . $row['nome'] . '<br/>
Matrícula: ' . $row['matricula'] . ' - Id: ' . $row['fk_usuario_aluno'] . ' (' . $nCaracteres . ') ' . $binario . '<br />
' . $row['turma_nome'] . '<br />
' . $data['titulo_concurso'] . '<br />
Data: ' . View::converteDataBr($row['data_realizacao']) . '<br />
</div>
<table class="codigos">
<tr>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/branco.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/branco.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/branco.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/branco.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/branco.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/branco.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/branco.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/branco.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/branco.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/branco.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/branco.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/branco.jpg" /></td>
</tr>
<tr>
<td class="separador_vertical" colspan="23"></td>
</tr>
<tr>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/branco.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/branco.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/branco.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/branco.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/branco.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/branco.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/branco.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/branco.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/branco.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/branco.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/branco.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/branco.jpg" /></td>
</tr>
<tr>
<td class="separador_vertical" colspan="23"></td>
</tr>
<tr>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/branco.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/branco.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/branco.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/branco.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/branco.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/branco.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/branco.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/branco.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/' . View::trataCodigoBinario($binario, $nCaracteres, 16) . '.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/' . View::trataCodigoBinario($binario, $nCaracteres, 15) . '.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/' . View::trataCodigoBinario($binario, $nCaracteres, 14) . '.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/' . View::trataCodigoBinario($binario, $nCaracteres, 13) . '.jpg" /></td>
</tr>
<tr>
<td class="separador_vertical" colspan="23"></td>
</tr>
<tr>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/' . View::trataCodigoBinario($binario, $nCaracteres, 12) . '.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/' . View::trataCodigoBinario($binario, $nCaracteres, 11) . '.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/' . View::trataCodigoBinario($binario, $nCaracteres, 10) . '.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/' . View::trataCodigoBinario($binario, $nCaracteres, 9) . '.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/' . View::trataCodigoBinario($binario, $nCaracteres, 8) . '.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/' . View::trataCodigoBinario($binario, $nCaracteres, 7) . '.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/' . View::trataCodigoBinario($binario, $nCaracteres, 6) . '.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/' . View::trataCodigoBinario($binario, $nCaracteres, 5) . '.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/' . View::trataCodigoBinario($binario, $nCaracteres, 4) . '.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/' . View::trataCodigoBinario($binario, $nCaracteres, 3) . '.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/' . View::trataCodigoBinario($binario, $nCaracteres, 2) . '.jpg" /></td>
<td class="separador_horizontal"></td>
<td class="retangulo"><img src="' . base_url() . 'themes/cartoes/images/' . View::trataCodigoBinario($binario, $nCaracteres, 1) . '.jpg" /></td>
</tr>
<tr>
<td class="separador_vertical" colspan="23"></td>
</tr>
</table>
</td>';
if ($coluna % 2 == 0) {
$tabela .= '</tr><tr>';
}
$coluna++;
}
$tabela .= '<table></div>';
}
$data['tabela'] = $tabela;
} else {
if ($result['total'] > 0) {
$this->load->library('table');
$arrHead[] = 'Código';
$arrHead[] = 'Cod. Aluno';
$arrHead[] = 'Matricula';
$arrHead[] = 'Aluno';
$arrHead[] = 'Turma';
$this->table->set_heading($arrHead);
$count = 0;
foreach ($result['registros'] as $row) {
$count++;
$tmpl = Util::zebrar($count, count($result['registros']));
$cell_1 = array('data' => $row['pk_usuario'], 'class' => 'tright');
$cell_2 = array('data' => $row['fk_usuario_aluno'], 'class' => 'tright');
$cell_3 = array('data' => $row['matricula'], 'class' => 'tright');
$cell_4 = array('data' => $row['nome'], 'class' => 'tleft');
$cell_5 = array('data' => $row['turma_nome'], 'class' => 'tleft');
$this->table->add_row($cell_1, $cell_2, $cell_3, $cell_4, $cell_5);
}
$this->table->set_template($tmpl);
$sqlConcurso = new SqlConcurso();
$result = $sqlConcurso->get_unidades_inscritos($pk_exa_prova);
$unidade = explode("&pk_unidade=", $_SERVER['QUERY_STRING']);
$unidade_url = base_url() . $this->uri->segment(1) . '/' . $this->uri->segment(2) . '/' . $this->uri->segment(3) . '/' . $this->uri->segment(4) . '/' . $this->uri->segment(5) . '?' . $unidade[0];
$select = '<select name="jumpMenu" id="jumpMenu" class="w250 right mr20 mb20" onchange="MM_jumpMenu(\'parent\',this,0)">';
$label_default = isset($_GET['pk_unidade']) ? 'Retirar filtro de escola' : 'Filtrar por escola';
$select .= '<option value="' . $unidade_url . '">' . $label_default . '</option>';
foreach ($result as $row) {
$checked = isset($_GET['pk_unidade']) && $_GET['pk_unidade'] == $row['fk_unidade'] ? 'selected' : '';
$select .= '<option value="' . $unidade_url . '&pk_unidade=' . $row['fk_unidade'] . '" ' . $checked . '>' . $row['unidade_nome'] . '</option>';
}
$select .= '</select>';
$data['filtro_unidades'] = $select;
} else {
$data['msg'] = '<div class="alert atencao">Nenhum aluno incluído. Para cadastrar por turma, clique no botão acima.</div>';
}
}
$data['importar_inscritos_mestre'] = isset($_SESSION['psi_exaseq']) ? '<a class="incluir right" href="' . base_url() . 'exames/concurso/importar_inscritos/' . $pk_exa_area . '/' . $pk_exa_prova . '">Importar inscritos do Mestre</a>' : '';
$_SESSION['redirect'] = $data['urlAtual'];
$this->load->view($this->load->getUrlTema(), $data);
}
