Exemple #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;
    }
Exemple #2
0
					<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>
				  </tr>
				  <tr>
					<td><strong>Assunto:</strong> ' . $manifestacao->GetAssunto() . ' </td>
				  </tr>
				  <tr>
					<td><strong>Conte&uacute;do da manifesta&ccedil;&atilde;o:</strong> ' . $manifestacao->GetConteudo() . ' </td>
				  </tr>
				  ' . $feedback . '
				  <tr>
					<td><strong>Setores por onde a manifesta&ccedil;&atilde;o passou:</strong> ' . $manifestacao->GetDepartamentos() . '<img src="../imagens/info.png" alt="" width="17" height="17" onmouseover="Tip(\'Legenda de Cores <br> Verde - Respondida <br> Amarelo - Aguardando resposta <br> Vermelho - Aguardando há mais de 05 dias\', BGCOLOR, \'#FFFFFF\')" onmouseout="UnTip()" /></td>
				  </tr>
				  <tr>';
                if ($manifestacao->VerificaRespondida($reg_andamento) == false) {
                    echo '<tr>
					<td><strong>Responder:</strong><br>
                            <td><strong>Clientela: </strong></td>
                            <td>
                            ' . $manifestacao->GetClientela() . '
                            </td>
  </tr>
                          <tr>
                            <td><strong>Endere&ccedil;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&ccedil;&atilde;o: : </strong></td>
                            <td>' . $data->ConverteDataBR($manifestacao->GetDataCriacao()) . ' &agrave;s ' . $manifestacao->GetDataHora() . '</td>
  </tr>
                          <tr>
                            <td><strong>J&aacute; passou por: </strong></td>
                            <td>' . $manifestacao->GetDepartamentos() . '
							<img src="imagens/info.png" alt="" width="17" height="17" onmouseover="Tip(\'Legenda de Cores <br> Verde - Respondida <br> Amarelo - Aguardando resposta <br> Vermelho - Aguardando há mais de 05 dias\', BGCOLOR, \'#FFFFFF\')" onmouseout="UnTip()" />
							</td>
  </tr>
                          <tr>
                            <td><strong>Status da Manifestacao: </strong></td>
                            <td><label>
                              <select name="dpdStatus" id="dpdStatus">
							  <option value="' . $manifestacao->GetCodigoStatus() . '">' . $manifestacao->GetStatus() . '</option>
							  ' . $status->ListaComboStatus() . '
                              </select>
                            </label></td>