detail_person.php

   1 <?php
   2 header ("Pragma: no-cache");                                            // sempre carregar página (não vai ser armazenada no cache http 1,0
   3 header("Cache-Control: no-cache, must-revalidate"); // idem     http 1,1
   4
   5 require_once("Globals.php");
   6 // realiza conexão com o banco de dados
   7 conecta();
   8
   9
  10 ?>
  11
  12 <html>
  13 <head>
  14 <title>Mensagens Recebidas - Logador PET</title>
  15 <link rel="stylesheet" type="text/css" href="estilo.css">
  16 <script language="JavaScript" type="text/javascript">
  17 window.onbeforeunload = function(){
  18         if (window.opener && !window.opener.closed) {
  19                 window.opener.location.reload();
  20         }
  21 }
  22
  23 </script>
  24 </head>
  25 <body>
  26
  27 <?php
  28         $my_id = $_GET['id'];
  29         $sql = "SELECT
  30                                 login
  31                         FROM
  32                                 usuario
  33                         WHERE
  34                                 usuario.id_user = $my_id";
  35         $result = mysql_query($sql);
  36         $name = mysql_result($result, 0, 'login');
  37
  38         if( isset($_GET['lidos']) && ($_GET['lidos']) )
  39         {
  40                 $sql = "UPDATE mensagem SET lido = TRUE WHERE id_to = '". $my_id ."'";
  41                 mysql_query($sql);
  42                 $existeNaoLido = false;
  43         }
  44         else
  45         {
  46                 $sql = "SELECT
  47                                 mensagem.id
  48                         FROM mensagem
  49                         WHERE mensagem.id_to = '". $my_id ."' AND lido = FALSE
  50                         LIMIT 1";
  51                 $result = mysql_query($sql);
  52                 $existeNaoLido = mysql_num_rows($result);
  53         }
  54
  55         $sql = "SELECT
  56                                 mensagem.id as id,
  57                                 getName(id_from) AS de,
  58                                 DATE_FORMAT(data, '%Y/%m/%d - %H:%i') AS data,
  59                                 texto
  60                         FROM mensagem
  61                         WHERE mensagem.id_to = '". $my_id ."'
  62                         ORDER BY data DESC, de";
  63         $result = mysql_query($sql);
  64
  65   if ($mensagem = mysql_fetch_array($result))
  66 {
  67                         if($existeNaoLido)
  68                         { ?>
  69                         <center>
  70                                 <form action="detail_person.php" method="GET">
  71                                         <input type="hidden" name="id" value="<?php echo $my_id;?>">
  72                                         <input type="submit" name="lidos" value="Marcar todos como lidos">
  73                                 </form>
  74                         </center>
  75                         <?php
  76                         }
  77                         ?>
  78                         <table border="2" class='bordasimples' align="center">
  79                          <thead>
  80                                          <td>
  81                                           <center>
  82                                                          Remetente
  83                                                           </center>
  84                                          </td>
  85                                          <td>
  86                                           <center>
  87                                                          Data
  88                                                           </center>
  89                                          </td>
  90                                          <td width="150">
  91                                           <center>
  92                                                          Mensagem
  93                                                          </center>
  94                                          </td>
  95                                          <td>
  96                                            <center>
  97                                                    Deletar
  98                                                  </center>
  99                                          </td>
 100                                 </thead>
 101
 102        <?php
 103
 104                          do  {
 105                                         $data = $mensagem['data'];
 106                                         /*$year = strtok($data, " /-:");
 107                                         $month = strtok(" /-:");
 108                                         $day = strtok(" /-:");
 109                                         $hour = strtok(" /-:");
 110                                         $min = strtok(" /-:");
 111
 112                                         $data = $day."/".$month."/".$year." - ".$hour.":".$min;*/
 113
 114                                         $temp = explode(" - ", $data);
 115                                         $temp2 = explode("/", $temp[0]);
 116                                         $temp2 = array_reverse($temp2);
 117                                         $temp[0] = implode("/", $temp2);
 118                                         $data = implode(" - ", $temp);
 119
 120                                         ?>
 121                                         <form action="deleta_mensagem.php" method="POST">
 122                                         <tr class='tbrow'>
 123                                                          <td style="padding-right:20px;"><?php echo $mensagem['de']; ?></td>
 124                                                          <td style="padding-right:0 10px;"><?php echo $data; ?></td>
 125                                                          <td><?php echo $mensagem['texto']; ?></td>
 126                                                          <td><input type="submit" name="apagar" value="Deletar"></td>
 127                                                    <input type="hidden" name="id" value="<?php echo $mensagem['id'];?>" />
 128                                                    <input type="hidden" name="detail" value="<?php echo $my_id;?>" />
 129                                         </form>
 130                                         </tr>
 131
 132
 133                                 <?php
 134
 135
 136                                 } while ($mensagem = mysql_fetch_array($result));
 137                                 ?>
 138                                 </table>
 139                                 <?php
 140
 141         }
 142         else
 143         {
 144                                  echo "<center  style='color: #ff0000;'>Sem mensagens!!!</center>";
 145
 146         } // do fetch_array
 147         ?>
 148 </body>
 149 </html>