Ejemplo n.º 1
0
    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&atilde;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;
    }
Ejemplo n.º 2
0
				<br>';
        }
        //indica que a manifestacao nao existe
        if (trim($manifestacao->GetCodigo()) == '') {
            echo '<br><strong>Essa manifesta&ccedil;&atilde;o n&atilde;o existe!</strong>';
        } else {
            if (trim($manifestacao->GetIdentificacao()) == 'I') {
                echo '
								
				<table width="100%" border="0">
				  <tr>
					<td><strong>MANIFESTA&Ccedil;&Atilde;O IDENTIFICADA</strong></td>
				  </tr>
				  <br>
				  <tr>
					<td><strong>Nome do Manifestante:</strong> ' . $manifestacao->GetNome() . '					</td>
				  </tr>
				  <tr>
					<td><strong>CPF:</strong> ' . $manifestacao->GetCpf() . '</td>
				  </tr>
				  <tr>
					<td><strong>Endere&ccedil;o:</strong> ' . $manifestacao->GetEndereco() . '</td>
				  </tr>
				  <tr>
					<td><strong>Telefone:</strong> ' . $manifestacao->GetTelefone() . '</td>
				  </tr>
				  <tr>
					<td><strong>Email:</strong> ' . $manifestacao->GetEmail() . '</td>
				  </tr>
				  <tr>
					<td><strong>Data de envio da manifesta&ccedil;&atilde;o:</strong> ' . $data->ConverteDataBR($manifestacao->GetDataCriacao()) . ' &agrave;s ' . $manifestacao->GetDataHora() . '</td>
Ejemplo n.º 3
0
                            <td width="147" rowspan="11" valign="bottom"><div align="center">
                              <table width="100%" border="0">
  <tr>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
</table>
</p>
                              <img src="imagens/save.png" width="70" height="70" /><br><br><input name="btnAlterar" type="button" class="botaoA" id="btnAlterar" value="Salvar Altera&ccedil;&otilde;es"  onClick="submitForm(\'frmDetalhes\',\'alterar\',' . $manifestacao->GetCodigo() . ');"/>
                              </div></td>
                          </tr>
                          <tr>
                            <td><strong>Nome do manifestante:</strong></td>
                            <td>' . $manifestacao->GetNome() . '</td>
  </tr>
						  <tr>
                            <td><strong>CPF:</strong></td>
                			<td>' . $manifestacao->GetCpf() . '</td>
  </tr>
                          <tr>
                            <td><strong>Tipo de manifesta&ccedil;&atilde;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>