public function RelManifestacao($data_inicial, $data_final) { require_once "../modelo/manifestacao.cls.php"; require_once "../controle/data.gti.php"; $man = new clsManifestacao(); $data = new gtiData(); $data_inicial = implode("-", array_reverse(explode("/", $data_inicial))); $data_final = implode("-", array_reverse(explode("/", $data_final))); $con = new gtiConexao(); $con->gtiConecta(); $SQL = 'SELECT manifestacao_id FROM vw_manifestacao WHERE data_criacao >= \'' . $data_inicial . '\' AND data_criacao <= \'' . $data_final . '\' ORDER BY data_criacao; ;'; $tbl = $con->gtiPreencheTabela($SQL); $con->gtiDesconecta(); $cont = 0; $rel = array(); foreach ($tbl as $chave => $linha) { $i = 0; $man->SetCodigo($linha['manifestacao_id']); $man->ConsultarPorCodigo(); $rel[$cont][$i++] = $cont + 1; $rel[$cont][$i++] = $man->GetCodigo(); $rel[$cont][$i++] = $data->ConverteDataBR($man->GetDataCriacao()); $rel[$cont][$i++] = utf8_decode($man->GetTipo()); switch ($man->GetIdentificacao()) { case 'S': $rel[$cont][$i++] = 'Sigiloso'; $rel[$cont][$i++] = utf8_decode($man->GetNome()); break; case 'I': $rel[$cont][$i++] = 'Identificado'; $rel[$cont][$i++] = utf8_decode($man->GetNome()); break; default: $rel[$cont][$i++] = 'Anônimo'; $rel[$cont][$i++] = utf8_decode('Não Informado'); break; } $rel[$cont][$i++] = utf8_decode($man->GetAssunto()); $rel[$cont][$i++] = utf8_decode($man->GetDepartamentosSimples()); $rel[$cont][$i++] = utf8_decode($man->GetClientela()); $rel[$cont][$i++] = utf8_decode($man->GetStatus()); $cont++; } return $rel; }
<td><strong>CPF:</strong></td> <td>' . $manifestacao->GetCpf() . '</td> </tr> <tr> <td><strong>Tipo de manifestação: </strong></td> <td><label> <select name="dpdTipo" id="dpdTipo"> <option value="' . $manifestacao->GetCodigoTipo() . '">' . $manifestacao->GetTipo() . '</option> ' . $tipo->ListaComboTipo(0) . ' </select> </label></td> </tr> <tr> <td><strong>Clientela: </strong></td> <td> ' . $manifestacao->GetClientela() . ' </td> </tr> <tr> <td><strong>Endereço: </strong></td> <td>' . $manifestacao->GetEndereco() . '</td> </tr> <tr> <td><strong>Email: </strong></td> <td>' . $manifestacao->GetEmail() . '</td> </tr> <tr> <td><strong>Data da manifestação: : </strong></td> <td>' . $data->ConverteDataBR($manifestacao->GetDataCriacao()) . ' às ' . $manifestacao->GetDataHora() . '</td> </tr> <tr>
<td>' . $manifestacao->GetCpf() . '</td> </tr> <tr> <td><strong>Tipo de manifestação: </strong></td> <td><label> <select name="dpdTipo" id="dpdTipo"> <option value="' . $manifestacao->GetCodigoTipo() . '">' . $manifestacao->GetTipo() . '</option> ' . $tipo->ListaComboTipo(0) . ' </select> </label></td> </tr> <tr> <td><strong>Clientela: </strong></td> <td><label> <select name="dpdClientela" id="dpdClientela"> <option value="' . $manifestacao->GetCodigoClientela() . '">' . utf8_encode($manifestacao->GetClientela()) . '</option> ' . $clientela->ListaComboClientela() . ' </select> </label></td> </tr> <tr> <td><strong>Endereço: </strong></td> <td>' . $manifestacao->GetEndereco() . '</td> <td><div align="center"> <label> <input name="btnSalvar" type="button" class="botaoA" id="btnSalvar" value="Salvar Alterações" onClick="submitForm(\'frmDetalhes\',\'salvar\',' . $manifestacao->GetCodigo() . ');"/> </label> </div></td> </tr> <tr> <td><strong>Email: </strong></td>