<?php
session_start();
require("connessione_database.php");

$risultato1 = mysql_query ("SELECT * FROM parknet WHERE gestore='00001'");
$righe1 = mysql_num_rows($risultato1);

//TABELLA SCAF
?>

<table width="980" border="0" align="center">
  <?php 
  if ($righe1 > 0) { 
  for ($i=0; $i<$righe1; $i++){
    $riga1 = mysql_fetch_row($risultato1);
  
  ?>
  <tr style="cursor: hand" onClick="openpopup('<?php echo $riga1[1];?>')"> 
    <td width="130"><font face="calibri"><strong><?php echo "$riga1[1]";?></strong></font></td>
    <td width="200"><pre><?php echo "$riga1[2]";?></pre></td>
    <td><div align="center"><font face="calibri"><?php if ($riga1[14]=="X"){echo "";} else {echo htmlentities($riga1[8], ENT_QUOTES);}//"$riga[8]";}?>
    </font></div></td>
    <td><div align="center"><font face="calibri"><?php
  
  //posti auto liberi
  if ($riga1[14]=="X"){
     echo "";
  } 
  else {
    if ($riga1[6] >= $riga1[7]){
      echo "$riga1[7]";
    }
    else {
      echo "$riga1[6]";
    }
  }
  
  ?></font></div></td>
    <td><div align="center"><font face="calibri"><?php 
  
  echo "$riga1[7]";
  
  ?></font></div></td>
    <td><div align="center"><font face="calibri"><?php 
  
  if ($riga1[14]=="X"){
    echo "";
  } 
  else {
  //echo "$riga1[7]-$riga1[6]";
    if ($riga1[6] >= $riga1[7]){
      $perc1 = 0;
    }
    else {
    //echo "$riga1[7]-$riga1[6]";
      $perc1 = (int)((100*($riga1[7]-$riga1[6]))/($riga[7]));
    }
    echo "$perc1 %";
  }
  
  ?></font></div></td>
  <?php 
  if ($riga1[14]=="X"){
    ?><td width="150" bgcolor="#FF0000"><div align="center"><font face="calibri">OFFLINE</font></div></td><?php
  } 
  else {
    if ($_SESSION['agg_old'][$riga1[0]] != $riga1[12]){ 
      ?>
      <td bgcolor="#33CC00"><div align="center"><font face="calibri">
    <?php 
      $aggiornamento1 = substr($riga1[12], 11, 2).":".substr($riga1[12], 14, 2)." ".substr($riga1[12], 8, 2)."/".substr($riga1[12], 5, 2)."/".substr($riga1[12], 0, 4);
      echo "$aggiornamento1";
      ?></font></div></td>
      <?php 
    }
    else{
      ?>
      <td><div align="center"><font face="calibri">
      <?php 
      $aggiornamento1 = substr($riga1[12], 11, 2).":".substr($riga1[12], 14, 2)." ".substr($riga1[12], 8, 2)."/".substr($riga1[12], 5, 2)."/".substr($riga1[12], 0, 4);
      echo "$aggiornamento1";
      ?></font></div></td>
      <?php 
    }
    $_SESSION['agg_old'][$riga1[0]] = $riga1[12];
  }
  ?>
  </tr>
  <?php
    }
  }
   ?>
</table>
<?php 

mysql_free_result($risultato1);
?>