<?php
/*
    Copyright (C) 2003 Loc Dayot Ville de Pierrefitte (93)

    EPNadmin - Version 0.7

    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");
if (!defined("FCT_SITES") && !defined("FCT_COURRIELS"))
{
  echo $fctnonactive;
  exit;
}
require_once("constantes.inc.php");             // dfinition des constantes
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

$ptitr=$sdomaines;
$titr = $sdomtitre;
$datemaj="24 juillet 2003";
define("COULEUR", COULEUR_SITES);
require("entete.inc.php");

if (SITES_AUTRES<"w" && COURRIELS_AUTRES<"w")
{
  echo $pasledroit;
  include("basdepage.inc.php");
  require("footer.inc.php");
  exit;
}

// Dbut du contenu de la page

switch($operation)
{
case 3 : // Confirmation d'effacement
  echo cadre_debut($sdomsuppr);
  echo "<form name=\"form\" method=\"post\" action=\"\">
          <input type=\"hidden\" name=\"id_usage\" value=\"$id_dom\">
          <input type=\"hidden\" name=\"operation\" value=\"31\">
        <p><b><font color=\"#FF0000\">";
  $res=recherche("domaines", "id", $id_dom);
  $dom=fetch_object($res);
  printf($sdomdemandesuppr, $dom->domaine);
  echo "</font></b></p>
        <p><input type=\"submit\" name=\"Annuler\" value=\"$sdomconfirmesuppr\"></p>
      </form>";
	echo cadre_fin();
	break;

case 31:  // Efface final   
  echo cadre_debut($sdomsuppr);
	$query = "DELETE FROM domaines WHERE id='$id_dom'";
	$result = executeRequete($query);
	echo "<p>$sdomsupprok</p>";
  echo cadre_fin();
  break;

case 2:   // Formulaire modification
  echo cadre_debut($sdommaj);
  $query = "SELECT * FROM domaines WHERE id='$id_dom'";
  $result = executeRequete($query);
  if (!$u=fetch_object($result))
  {
    echo "<p>$sdomintrouvable</p>\n";
    echo cadre_fin();
    break;
  }
  $operations=21;
  $domaine=$u->domaine;
  $visible=$u->visible;

case 1:  // Ajoute d'une nouvelle session
  if ($operation==1)
	  cadre_debut($sdomnouv);
  if (!$operations) $operations=11;
  echo "<table align=center border=1>
        <tr><td align=center>$sDomaine :</td></tr><tr><td align=center>
        <form name=\"modi\" method=\"post\" action=\"$PHP_SELF\">\n";
  if ($id_dom)
      echo "<input type=\"hidden\" name=\"id_dom\" value=\"$id_dom\">\n";
  echo "<input type=\"hidden\" name=\"operation\" value=\"$operations\">
        <input type=\"text\" name=\"domaine\" value=\"$domaine\" size=\"32\" maxlength=\"30\">
        <br />
        <input name=\"visible\" type=\"radio\" value=\"non\"";
  if ($visible=="non") echo " checked";
  echo "/>non
        <input name=\"visible\" type=\"radio\" value=\"oui\"";
  if ($visible=="oui") echo " checked";
  echo "/>oui
        </td></tr><tr><td align=center>
					<input type=\"submit\" name=\"Envoyer\" value=\"$sconfirmer\">
        </td></tr></table></form>\n";
  echo cadre_fin();
  break;

case 11:  // Ajout final
  echo cadre_debut($sdomnouv);
  $query = "INSERT INTO domaines (domaine, visible) VALUES (\"$domaine\", \"$visible\")";
  if ($result = executeRequete($query))
    echo "<p>$sdomajouteok</p>";
	echo cadre_fin();
	break;

case 21:  // Modif final
  echo cadre_debut($sdommaj);
	$query = "UPDATE domaines SET domaine=\"$domaine\", visible=\"$visible\" WHERE id='$id_dom'";
	if ($result = executeRequete($query))
		echo "<p>$sdommodiok</p>";
	echo cadre_fin();
	break;

default : // liste des usages
  echo cadre_debut($sdomliste);
	$req = "SELECT * FROM domaines ORDER BY domaine";
	$res = executeRequete($req);
	echo "<table align=center border=1>\n";
	while ($dom= fetch_object($res))
	{
    echo "<tr><td>$dom->domaine (";
    if ($dom->visible=="oui") echo $svisible; else echo $scache;
    echo ")</td>";
    echo "<td><a href=\"?operation=2&id_dom=$dom->id\">$modifier</a></td>";
    echo "<td><a href=\"?operation=3&id_dom=$dom->id\">$supprimer</a></td></tr>\n";
	}
	echo "<tr><td colspan=3 align=right><a href=\"?operation=1\">$ajouter</a></td></tr>\n";
	echo "</table>\n";
	echo cadre_fin();
	break;
}  // switch

printf ("<p>$sdomvoirliste</p>\n", $PHP_SELF);

include("basdepage.inc.php");
require("footer.inc.php");
?>