<?php
session_start();

require 'config.php';

?>


        <div class="col-sm-10">
        <form class="form-inline" method="POST" action="diex.php">
        <div class="form-group">
        <label for="email">Nome:</label>
        <input type="text" class="form-control" id="email" placeholder="nome" name="nome_responsavel">
        </div>
        <div class="form-group">
        <label for="pwd">Número:</label>
        <input type="text" class="form-control" id="pwd" placeholder="numero do documento" name="numero">
        </div>
        <div class="form-group">
        <label for="email">Assunto:</label>
        <input type="text" class="form-control" id="email" placeholder="assunto" name="assunto">
        </div>
        <div class="form-group">
        <label for="pwd">texto:</label>
        <input type="text" class="form-control" id="pwd" placeholder="texto" name="texto">
        </div>
        <br><br>

        <div class="form-group">
        <label for="pwd">Solução:</label>
        <input type="text" class="form-control" id="pwd" placeholder="solução" name="solucao">
        </div>

        <div class="form-group">
        <label for="email">Destinatário:</label>
        <input type="text" class="form-control" id="email" placeholder="destinatário" name="destinatario">
        </div>
        <br><br>

        <button type="submit" class="btn btn-default">Enviar</button>
        </form>
                </div>
  <div class="col-sm-10">


  <h3 style="background-color:#ddd;text-align:center">Histórico de Documentos Enviados</h3>



  <br><br>

  <table class="table table-bordered table-condensed table-hover table-striped">

  <tr>

  <th>Nome Responsável</th>
  <th>Numero</th>
  <th>Assunto</th>
  <th><button class="btn-xs " data-toggle="collapse" data-target="#demo2">Texto</button></th>
  <th>Destinatário</th>
  <th>Solução</th>
  <th>Data de Envio</th>
  <th>IP</th>

  </tr>


<?php
if (!empty($_POST['nome_responsavel'])) {

$nome_responsavel = addslashes($_POST['nome_responsavel']);
$numero = addslashes($_POST['numero']);
$assunto = addslashes($_POST['assunto']);
$texto = addslashes($_POST['texto']);
$destinatario = addslashes($_POST['destinatario']);
$ip = $_SERVER['REMOTE_ADDR'];;
$solucao = addslashes($_POST['solucao']);



$sql = "INSERT INTO controle_diex SET  nome_responsavel ='$nome_responsavel', data_envio=NOW(), numero = '$numero',assunto = '$assunto',texto = '$texto',destinatario = '$destinatario',solucao = '$solucao',ip='$ip' ";
$pdo->query($sql);

$ip=$_SERVER['REMOTE_ADDR'];

}else{

  // header("Location: index.php");
}

$sql = "SELECT * FROM controle_diex ORDER BY id_diex DESC  LIMIT 200";
$sql = $pdo->query($sql);


if($sql->rowCount()> 0){

foreach ($sql->fetchAll() as $logs) :
?>
<tr>
<td><?php  echo $logs ['nome_responsavel']; ?></td>
<td><?php  echo $logs ['numero']; ?></td>
<td><?php  echo $logs ['assunto']; ?></td>
<td><div id="demo2" class="collapse"  style='text-align:center;'><?php  echo $logs ['texto']; ?>  </div></td>
<td><?php  echo $logs ['destinatario']; ?></td>
<td><?php  echo $logs ['solucao']; ?></td>
<td><?php  echo ajustar_data($logs ['data_envio']); ?></td>
<td><?php  echo $logs ['ip']; ?></td>
</tr>
<?php  endforeach; }?>
                    </table>

                </div>
                <div class="col-sm-1"></div>

            </div>
        </div>

</div>
</body>
</html>