<?php
/*
    Copyright (C) 2001, 2002 Bertand Pallie, Loc Dayot - Mairie Pierrefitte (93)

    EPNadmin - Version 0.6 - 13/05/2003

    This program is free software; you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation; either version 2 of the License, or
    (at your option) any later version.

    This program is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU General Public License for more details.

    You should have received a copy of the GNU General Public License
    along with this program; if not, write to the Free Software
    Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA

    http://epnadmin.pierrefitte93.fr/
*/

//require_once("header.inc.php");
require_once("constantes.inc.php");             // dfinition des constantes
if (!defined("FCT_UTILISATIONS"))
  return $fctnonactive;

//require_once("fonctions.inc.php");              // concernant des fonctions transversales inclassables
require_once("mysql.inc.php");                  // concernant mysql
//require_once("sessions.inc.php");             // concernant les sessions et initiations
//require_once("usagers.inc.php");              // concernant la gestion des usagers
//require_once("reservations.inc.php");         // concernant les rservations des postes en accs individuel par des usagers
//require_once("tableaux.inc.php");             // Concernant l'affichage transpos d'un tableau
//require_once("siteweb.inc.php");              // concernant les pages perso des usagers et les sites web des structures
require_once("dateheure.inc.php");            // concernant la manipulation des heures et des dates, formulaire, conversion...
//require_once("structures.inc.php");           // concernant les structures
//require_once("initiations.inc.php");          // concernant les initiations et les thmes
//require_once("parcours.inc.php");             // concernant les parcours des usagers et leur positionnement

//                                                                             -
//  Rservation de postes individuels                                          -
//                                                                             -

function trouveUsage($id)
{
        $req = "SELECT * FROM usages WHERE id=$id";
        $res = executeRequete($req);
        return fetch_object($res);
}

function affiche_utilisations($id, $temps=FUTUR)
{
global $sDate, $sHoraire, $sPoste, $sUtilisation, $sEtat, $sAnnuler, $savec, $sseul, $sTotal, $sutilisationaucune;
  $query = "SELECT * FROM utilisation_postes WHERE id_usager='$id'";
  if ($temps==PASSE) $query .= " AND (date<CURRENT_DATE OR (date=CURRENT_DATE AND debut<=CURRENT_TIME))";
  if ($temps==FUTUR) $query .= " AND (date>CURRENT_DATE OR (date=CURRENT_DATE AND debut>CURRENT_TIME))";
  $query.=" ORDER BY date, debut";
  if ($result = executeRequete($query))
  {
    // echo "<h3 align=center>Utilisations des postes dans le $temps</h3>\n";
    echo "<table align=center border=\"1\">
      <tr><th>$sDate</th>
        <th>$sHoraire</th>
        <th>$sPoste</th>
        <th>$sUtilisation</th>
        <th>$sEtat</th>
      </tr>\n";
    $totalheures="00:00";
    while($tab = fetch_object($result))
    {
      if ($result2 = recherche("usages", "id", $tab->id_usage))
        $tab2 = fetch_object($result2);
      if ($result2 = recherche("materiels", "id", $tab->id_materiel))
        $tab3 = fetch_object($result2);
      //if ($result2 = recherche("horaires", "id", $tab->id_horaire))
      //  $tabhoraire = fetch_object($result2);

      echo "<tr><td>". datetodate($tab->date) . "</td>\n";
      echo "<td>". datetoheure($tab->debut) . "  " . datetoheure($tab->fin) . "</td>\n";
      if ($tab->etat!="annule")
      {
        $heure=differenceHeure($tab->fin, $tab->debut);
        $totalheures=additionHeure($totalheures, $heure);
      }
      echo "<td><A HREF=\"materiels.php?id_materiel=$tab3->id&id_usager=$id\">$tab3->materiel</td>\n";
      echo "<td>$tab2->nom";
      if ($tab->id_usager2!="" && $tab->id_usager2!="0")
      {
         $res4 = recherche("usagers", "id", "$tab->id_usager2");
         $tab4=fetch_object($res4);
         if ($tab4)
           echo " ($savec $tab4->prenom $tab4->nom)";
         else
           echo " ($sseul)";
      }
      else
        echo " ($sseul)";
      echo "</td>\n";
      echo "<td>$tab->etat ";
      if (($tab->etat!="annule") & ($tab->etat!="non tenue") & ($temps==FUTUR))
         echo "<a href=\"reservations.php?operation=2&id_utilisation=$tab->id&id_usager=$id\">$sAnnuler</a>";
      echo "</td></tr>\n";
    }
    echo "<tr><td>$sTotal :</td><td>".datetoheure($totalheures)."</td><td colspan=3></td></tr>";
    echo "</table>\n";
  }
  else
      echo "<h3>$sutilisationaucune $temps</h3>\n";
}

?>