PHPXRef 0.7.1 : IEUF : /gestion/f_representation.php source

[Summary view] [Print] [Text view]
   1  <?php
   2  //Vérification accès
   3  require  'inc/autorisation.inc.php';
   4  if (NonCA()) include  'inc/404.php';
   5  include  "../inclus/connect_bdi.inc.php";
   6  ?>
   7  <!DOCTYPE html>
   8  <html>
   9    <head>
  10      <meta content="text/html; charset=ISO-8859-1" http-equiv="content-type">
  11      <title> Gestion des représentations </title>
  12      <link rel="stylesheet" href="formulaire.css" type="text/css">
  13      <style type="text/css">
  14      body {
  15        background-color: #999999;
  16      }
  17  
  18      label {
  19        display: inline-block;  
  20        width: 110px;
  21        text-align: right;
  22        vertical-align: top;
  23        height: 30px;
  24        padding-right: 5px;
  25      }
  26  
  27      input, select {
  28        margin-left: 10pt;
  29      }
  30      .panneaux {
  31        height: 410px;
  32        margin-top: 15px;
  33        margin-left: 15px;
  34      }
  35      </style>
  36      <?php
  37      function Enregistre($data) {
  38        global $mysqli;
  39        extract ($data);
  40        $verif_date=date_create($date);
  41        if ($verif_date===false) return "date non conforme";
  42        $date=$date."T".$heure;
  43        $verif_date=date_create($date);
  44        if ($verif_date===false) return "heure non conforme";
  45        $date=date_format($verif_date, "Y-m-d H:i");
  46        echo $date;
  47        $set="SET id_spectacle='$id_spectacle', salle='$salle', lieu='$lieu', ville='$ville', duree='$duree', preparation='$preparation',
  48              bilan='$bilan', date='$date'";
  49        if ($id==0) $requete="INSERT representation $set";
  50        else $requete="UPDATE representation $set WHERE id='$id'";
  51        $mysqli->query($requete);
  52        echo "<script type='text/JavaScript'>
  53            if (opener && opener.document.parametres) opener.document.parametres.submit();
  54             window.close();
  55            </script>";
  56        exit;
  57      }
  58      
  59      $an=date('n')>8?date('Y')+1:date('Y');
  60      $id= $id_spectacle=0;
  61      $salle= $lieu= $ville= $preparation= $bilan= $media= "";
  62      $duree= 0;
  63      $date= date("Y-m-d");
  64      $heure= date("H:i");
  65      $message="";
  66      if (isset ($_POST['id'])) {
  67        if (get_magic_quotes_gpc() == 0)
  68            foreach ($_POST as $i=>$n)
  69              if (is_string($n))$_POST[$i]= addslashes($n);
  70        $message=Enregistre($_POST);
  71        extract ($_POST);
  72      }
  73      else {
  74        if (isset($_GET['id']) && !empty($_GET['id'])) {
  75          $id=$_GET['id'];
  76          $requete="SELECT id, id_spectacle, salle, lieu, ville, duree, preparation, bilan, media,
  77                    DATE_FORMAT(date,'%Y-%m-%d') as date, DATE_FORMAT(date,'%H:%i') as heure
  78                    FROM representation WHERE id='$id'";
  79          $recherche=$mysqli->query($requete);
  80          if ($recherche === false) die($mysqli->error);
  81          if (($col=$recherche->fetch_assoc())) {
  82            foreach($col as $i=>$v)
  83              if (is_string($v))
  84                $col[$i]= htmlspecialchars ($v, ENT_QUOTES, "ISO-8859-1");
  85              extract($col);
  86            }
  87          $recherche->free();
  88        }
  89      }
  90      ?>
  91    </head>
  92    <body>
  93      <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>" name="repres" id="repres" onsubmit="return Controle()">
  94        <input name="id" type="hidden" value="<?php echo $id; ?>">
  95        <div class="panneaux">
  96        <label for="id_spectacle">Spectacle :</label>
  97        <select name="id_spectacle">
  98          <?php
  99          $requete="SELECT id, titre FROM spectacle ORDER BY id DESC";
 100          $recherche=$mysqli->query($requete);
 101          if ($recherche === false) die($mysqli->error);
 102          while (($col=$recherche->fetch_assoc())) {
 103            foreach($col as $i=>$v)
 104              if (is_string($v))
 105                $col[$i]= htmlspecialchars ($v, ENT_QUOTES, "ISO-8859-1");
 106            if ($col['id'] == $id_spectacle) {
 107              $sel='selected="selected"';
 108            }
 109            else $sel ="";
 110            echo "<option value='{$col['id']}' $sel> {$col['titre']} </option>";
 111          }
 112          $recherche->free();
 113          ?>     
 114        </select>
 115        <br>
 116        <label for="salle">Salle :</label> <input maxlength="254" size="40" name="salle" value="<?php echo $salle;?>"><br>
 117        <label for="lieu">Lieu :</label> <input maxlength="255" size="40" name="lieu" value="<?php echo $lieu;?>"><br>
 118        <label for="ville">Ville :</label> <input maxlength="254" size="40" name="ville" placeholder="Obligatoire"
 119                                                  value="<?php echo $ville;?>" required><br>
 120        <label for="date">Date :</label> <input type="date" name="date" placeholder="Obligatoire"
 121                                                value="<?php echo $date;?>" required><br>
 122        <label for="heure">Heure :</label> <input type="time" name="heure" value="<?php echo $heure;?>"><br>
 123        <label for="duree">Durée (min) :</label> <input type="number" min="15" max="240" step="5" name="duree" id="duree"
 124                                                        value="<?php echo $duree;?>" onchange="Affiche_duree()"> <span id="aff_duree"></span><br>
 125        <label for="preparation">Préparation :</label> <textarea cols="45" rows="5" name="preparation"><?php echo $preparation;?></textarea><br>
 126        <label for="bilan">Bilan :</label> <textarea cols="45" rows="5" name="bilan"><?php echo $bilan;?></textarea>
 127        </div>
 128        <p style="position:absolute; top:150px; left: 500px; text-align: center; width: 200px">
 129          <input type="submit" value="VALIDER"><br><br>
 130          <input type="button" value="Abandonner" onclick="self.close()"><br><br>
 131          <input type="button" value="Supprimer" onclick="Supprimer()">
 132        </p>
 133      </form>
 134      <script type="text/javascript">
 135        function Controle() {
 136          var message ="";
 137          if (document.repres.ville.value =="") message += "Ville non saisie\n";
 138          if (document.repres.date.value =="") message += "Date non saisie\n";
 139          if (message!="") {
 140            alert(message);
 141            return false;
 142          }
 143          return true;
 144       }
 145       function Supprimer() {
 146        if (confirm("Voulez-vous vraiment supprimer cette ragoûtante, remarquable, belle et merveilleuse représentation ?"))
 147          location.replace("suppr_repres.php?id=<?php echo $id; ?>");
 148       }
 149       function Affiche_duree() {
 150         duree=document.getElementById('duree').value;
 151         heure=Math.floor(duree/60);
 152         minute=duree-heure*60;
 153         if (minute<10) minute="0"+minute;
 154         document.getElementById("aff_duree").innerHTML=heure+"h "+minute;
 155       }
 156       Affiche_duree();
 157      <?php
 158        if (!empty($message)) echo "alert ('$message');";
 159      ?>
 160      </script>
 161    </body>
 162  </html>
PHP Cross Reference of IEUF

/gestion/ -> f_representation.php (source)
