<?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_PEDAGOGIE"))
  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

//                                                                             -
//  Initiations                                                                -
//                                                                             -

function afficheTheme($theme,$niveau="")
{
        echo "<table><tr><td>";
        if ($theme->url_image!="")
           echo "<img src=\"$theme->url_image\" alt=\"$theme->theme\" border=0 height=80>";
        echo "</td>\n";
        echo "<td><h3>$theme->theme";
        if ($niveau!="") echo " - $niveau";
        echo "</h3><p>$theme->commentaire</p></td></tr></table>\n";
}

function rechercheTheme($id)
{
global $sthemeintrouvable;
  $req = "SELECT * FROM themes WHERE id=$id";
  $res = executeRequete($req);
  if (!$res) debug ("$sthemeintrouvable $req");
  return $res;
}

function rechercheInitiation($id, $niveau="", $champ="id_theme")
{
        $req = "SELECT * FROM initiations WHERE $champ=$id";
        if ($niveau!="") $req .=" AND niveau='$niveau'";
        $req .= " ORDER BY niveau, id";
        //debug($req);
        $res = executeRequete($req);
        return $res;
}

function trouveInitiation($id)
{
        $res = recherche("initiations","id",$id);
        return fetch_object($res);
}

// Affichage d'une initiation
function afficheInitiation($id, $format="COMPLET")
{
global $etaussi, $oualors, $sintitule, $sprerequis, $sobjectifs, $smoyenseval,
  $snbmaxpart, $scontenuderoulement, $spreparation, $srolesformateur, $srolesapprenants, $sduree, $sprolongements,
  $sinitauteursversions, $sinitdansparcours, $spublic;
  $initiation=trouveInitiation($id);
  echo "<table border=1 align=center bgcolor=\"".COULEUR_PEDAGOGIE."\">\n";
  echo "<tr><td>$sintitule</td><td><h2>$initiation->initiation</h2></td></tr>\n";
  echo "<tr><td>$sprerequis</td><td>";
  $pr=explode(",", $initiation->prerequis);
  $sep=$sep2=""; // les sparateurs;
  for ($npr=0; $pr[$npr]; $npr++)
  {
    $prou=explode("|", $pr[$npr]);
    $res1 = recherche("initiations", "id", $prou[0]);
    $res2 = recherche("initiations", "id", $prou[1]);
    $res3 = recherche("initiations", "id", $prou[2]); // ca sert pas encore, mais on ne sait jamais
    if ($requis = fetch_object($res1))
      echo " $sep $sep2 <a href=\"initiations.php?id_initiation=$requis->id\">$requis->initiation</a> ";
    if ($requis = fetch_object($res2))
      echo " $oualors <a href=\"initiations.php?id_initiation=$requis->id\">$requis->initiation</a> ";
    if ($requis = fetch_object($res3))
      echo " $oualors <a href=\"initiations.php?id_initiation=$requis->id\">$requis->initiation</a> ";
    $sep="<br>\n";
    $sep2=$etaussi;
  }
  echo "</td></tr>\n";
  if ($initiation->objectifs!="")
          echo "<tr><td>$sobjectifs</td><td>".nl2br($initiation->objectifs)."</td></tr>\n";
  if ($format=="COMPLET")
  {
    if ($initiation->moyen_evaluation!="")
      echo "<tr><td>$smoyenseval</td><td>".nl2br($initiation->moyen_evaluation)."</td></tr>\n";
    if ($initiation->nbmaxparticipants!="")
      echo "<tr><td>$snbmaxpart</td><td>$initiation->nbmaxparticipants</td></tr>\n";
    if ($initiation->contenu!="")
      echo "<tr><td>$scontenuderoulement</td><td>".nl2br($initiation->contenu)."</td></tr>\n";
    if ($initiation->preparation!="")
      echo "<tr><td>$spreparation</td><td>".nl2br($initiation->preparation)."</td></tr>\n";
    if ($initiation->role_formateur!="")
      echo "<tr><td>$srolesformateur</td><td>".nl2br($initiation->role_formateur)."</td></tr>\n";
    if ($initiation->role_apprenants!="")
      echo "<tr><td>$srolesapprenants</td><td>".nl2br($initiation->role_apprenants)."</td></tr>\n";
  }
  if ($format=="COMPLET")
  {
    echo "<tr><td>$sduree</td><td>".datetoheure($initiation->duree)."</td></tr>\n";
    if ($initiation->prolongements!="")
    {
      echo "<tr><td>$sprolongements</td><td>";
      $req = "SELECT * FROM initiations WHERE id IN ($initiation->prolongements)";
      $res1 = executeRequete($req);
      $sep="";
      while ($requis = fetch_object($res1))
      {
        echo "<a href=\"initiations.php?id_initiation=$requis->id\">$sep$requis->initiation</a>";
        $sep="<br>";
      }
      echo "</td></tr>\n";
    }
   }
   if ($format=="COMPLET")
   {
      if ($initiation->auteurs_versions!="")
         echo "<tr><td>$sinitauteursversions</td><td>".nl2br($initiation->auteurs_version)."</td></tr>\n";
      if ($initiation->dans_parcours!="")
         echo "<tr><td>$sinitdansparcours</td><td>$initiation->dans_parcours</td></tr>\n";
      if ($initiation->public!="")
         echo "<tr><td>$spublic</td><td>$initiation->public</td></tr>\n";
   }
   echo "</table>\n";
}

function afficheBilansInitiation($id)
{
global $sbilanscommentairessession, $ssession, $sBilan;
  $res=recherche("sessions", "id_initiation", $id);
  echo "<table border=1 align=center bgcolor=\"".COULEUR_PEDAGOGIE."\">\n";
  echo "<tr><td colspan=2 align=center>$sbilanscommentairessession</td></tr>";
  echo "<tr><th>$ssession</th><th>$sBilan</th></tr>\n";

  while ($session=fetch_object($res))
  if ($session->commentaires)
  {
    echo "<tr><td>".datetodate($session->date)."<br>";
    echo $session->animateur;

    echo "</td><td>".nl2br($session->commentaires)."</td>";
    echo "</tr>\n";
  }
  echo "</table>\n";
}


// Choix du thme ou de l'initiation pour slectionner des sessions (passes et  venir)

function choix_initiation($critere_initiation, $champ="critere_initiation")
{
   $req="SELECT *, initiations.id AS id_initiation FROM initiations
             LEFT JOIN themes ON initiations.id_theme=themes.id
             ORDER BY themes.id, initiations.niveau, initiations.initiation";
   $res = executeRequete($req);
   $theme_prec=$init_prec=-1;

   echo "<select name=\"$champ\">\n";
   echo "<option value=\"*\">toutes</option>\n";
   while ($initiation = fetch_object($res))
   {
      if ($theme_prec != $initiation->id_theme)
      {
        echo "<option value=\"T$initiation->id_theme\"";
        if ($critere_initiation == "T".$initiation->id_theme) echo " selected";
        echo ">$initiation->theme</option>";
        $theme_prec=$initiation->id_theme;
      }

      if ($init_prec != $initiation->id_initiation)
      {
        echo "<option value=\"I$initiation->id_initiation\"";
        if ($critere_initiation == "I".$initiation->id_initiation) echo " selected";
        echo ">".substr($initiation->theme,0,10)." : ".substr($initiation->initiation,0,20)."</option>\n";
        $init_prec=$initiation->id_initiation;
      }
   }

   echo "</select>\n";
}


?>