Exemplo n.º 1
0
	/**
	 * Declares an association between this object and a Matiere object.
	 *
	 * @param      Matiere $v
	 * @return     JGroupesMatieres The current object (for fluent API support)
	 * @throws     PropelException
	 */
	public function setMatiere(Matiere $v = null)
	{
		if ($v === null) {
			$this->setIdMatiere(NULL);
		} else {
			$this->setIdMatiere($v->getMatiere());
		}

		$this->aMatiere = $v;

		// Add binding for other direction of this n:n relationship.
		// If this object has already been added to the Matiere object, it will not be re-added.
		if ($v !== null) {
			$v->addJGroupesMatieres($this);
		}

		return $this;
	}
Exemplo n.º 2
0
	public function getMatiere(){
		return Matiere::getById($this->getIdMatiere());
	}
	/**
	 * Filter the query by a related Matiere object
	 *
	 * @param     Matiere|PropelCollection $matiere The related object(s) to use as filter
	 * @param     string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
	 *
	 * @return    JProfesseursMatieresQuery The current query, for fluid interface
	 */
	public function filterByMatiere($matiere, $comparison = null)
	{
		if ($matiere instanceof Matiere) {
			return $this
				->addUsingAlias(JProfesseursMatieresPeer::ID_MATIERE, $matiere->getMatiere(), $comparison);
		} elseif ($matiere instanceof PropelCollection) {
			if (null === $comparison) {
				$comparison = Criteria::IN;
			}
			return $this
				->addUsingAlias(JProfesseursMatieresPeer::ID_MATIERE, $matiere->toKeyValue('PrimaryKey', 'Matiere'), $comparison);
		} else {
			throw new PropelException('filterByMatiere() only accepts arguments of type Matiere or PropelCollection');
		}
	}
Exemplo n.º 4
0
                 <option value=""></option>
                 <?php
                 $niveaux = Niveau::getAll();
                 foreach ($niveaux as $niveau) {
                     echo '<option value="' . $niveau->getIdNiveau() . '">' . $niveau->getLibelleNiveau() . '</option>';
                 }
                 ?>
             </select>
         </div>
     </td>
     <td>
         Matiere
         <select id="selectMatiere" size="1">
             <option value=""></option>
             <?php
             $matieres = Matiere::getAll();
             foreach ($matieres as $matiere){
                 echo '<option value="' . $matiere->getIdMatiere() . '">' . $matiere->getLibelleMatiere() . '</option>';
             }
             ?>
         </select>
     </td>
 </tr>
 <tr>
     <td>
         Professeur
         <select id="selectProf" size="1">
             <option value=""></option>
             <?php
             $profs = Professeur::getAll();
             foreach ($profs as $prof){
Exemplo n.º 5
0
			foreach($pointsCpt as $pointCpt){
				//$pointCpt = new PointCpt();
				$return[] = "<option value='".$pointCpt->getIdPointCpt()."'>(".$pointCpt->getDomaineCpt()->getLibelleDomaineCpt().") ".$pointCpt->getLibellePointCpt()."</option>";
			}

			echo json_encode($return);
			break;

		case 'getByEleveMatiereTrimestre':
			//idEleve: idEleve, idMatiere: idMatiere, idNiveau: idNiveau, idTrimestre:idTrimestre, action: 'getByEleveMatiereTrimestre
			// ?action=getByEleveMatiereTrimestre&idEleve=19&idMatiere=6&idTrimestre=1&isNiveau=2
			$return = array();

			$eleve=Eleve::getById($_GET['idEleve']);
			$matiere = Matiere::getById($_GET['idMatiere']);
			$niveau = Niveau::getById($_GET['idNiveau']);
			$matiereNiveau = MatiereNiveau::getByMatiereNiveau($matiere->getIdMatiere(), $niveau->getIdNiveau());
			$trimestre = Trimestre::getById($_GET['idTrimestre']);

			$eleveEvalPointCpt = EleveEvaluationPointCpt::getByEleveMatiereTrimestre($eleve->getIdEleve(), $matiere->getIdMatiere(), $trimestre->getIdTrimestre());

			foreach ($eleveEvalPointCpt as $EEPC){
				//$EEPC = new EleveEvaluationPointCpt();

				$tmp = array();
				$tmp['libCpt'] = $EEPC->getEvaluationPointCpt()->getEvaluation()->getLibelleEvaluation();
				$tmp['noteCpt'] = $EEPC->getNiveauCpt()->getCodeNiveauCpt(). ' (' .$EEPC->getNiveauCpt()->getLibelleNiveauCpt() . ')';

				$return[] = $tmp;
			}
Exemplo n.º 6
0
 * Created by PhpStorm.
 * User: Jean-Baptiste
 * Date: 24/08/2015
 * Time: 19:35
 */

header('content-type: text/html; charset=utf-8');
session_start();
require_once('../Require/Objects.php');
if (isset ($_GET['action'])) {
	switch ($_GET['action']) {
		case 'listeMatiereByNiveauUtilisateur' :
			$utilisateur = Utilisateur::getById($_GET['idUtilisateur']);
			$Matieres = Matiere::getByNiveauProfesseur($_GET['idNiveau'], $_GET['idUtilisateur']);
			if ($utilisateur->estAdministrateur())
				$Matieres = Matiere::getByNiveau($_GET['idNiveau']);
			$return = array ();
			foreach ($Matieres as $mat) {
				$return[] = $mat->toArray();
			}
			echo json_encode($return);
			break;
		case 'listeEvaluationByMatiereNiveau':
			$matiereNiveau = MatiereNiveau::getByMatiereNiveau($_GET['idMatiere'], $_GET['idNiveau']);
			$evaluations = Evaluation::getByMatiereNiveau($matiereNiveau->getIdMatiereNiveau());
			$return = array ();
			foreach ($evaluations as $eval) {
				$return[] = $eval->toArray();
			}

			echo json_encode($return);
Exemplo n.º 7
0
header('content-type: text/html; charset=utf-8');
session_start();
require_once('../Require/Objects.php');

//echo json_encode($_GET['action']::getById($_GET['id'.$_GET['action']])->toArray());


switch ($_GET['action']) {
	case 'CarnetLiaison' :
		echo json_encode(CarnetLiaison::getById($_GET['idCarnetLiaison'])->toArray());
		break;
	case 'Evaluation':
		echo json_encode(Evaluation::getById($_GET['idEvaluation'])->toArray());
		break;
    case 'Matiere' :
        echo json_encode(Matiere::getById($_GET['idMatiere'])->toArray());
        break;
    case 'Module' :
        echo json_encode(Module::getById($_GET['idModule'])->toArray());
        break;
    case 'Niveau' :
        echo json_encode(Niveau::getById($_GET['idNiveau'])->toArray());
        break;
    case 'NiveauCpt' :
        echo json_encode(NiveauCpt::getById($_GET['idNiveauCpt'])->toArray());
        break;
	case 'Periode':
		echo json_encode(Periode::getById($_GET['idPeriode'])->toArray());
		break;
	case 'Trimestre':
		echo json_encode(Trimestre::getById($_GET['idTrimestre'])->toArray());
Exemplo n.º 8
0
	/**
	 * Exclude object from result
	 *
	 * @param     Matiere $matiere Object to remove from the list of results
	 *
	 * @return    MatiereQuery The current query, for fluid interface
	 */
	public function prune($matiere = null)
	{
		if ($matiere) {
			$this->addUsingAlias(MatierePeer::MATIERE, $matiere->getMatiere(), Criteria::NOT_EQUAL);
		}

		return $this;
	}
Exemplo n.º 9
0
									<option value=""></option>
									<?php
									foreach ($niveaux as $niveau) {
										echo '<option value="' . $niveau->getIdNiveau() . '"'.($evaluation->getMatiereNiveau()->getNiveau()->getIdNiveau()==$niveau->getIdNiveau()?'selected':'').'>' . $niveau->getLibelleNiveau() . '</option>';
									}
									?>
								</select>
							</td>
						</tr>
						<tr>
							<td width="20%"><label for="addMatiere"> Matiere : </label></td>
							<td width="30%">
								<select id="addMatiere" name="addMatiere">
									<option value=""></option>
									<?php
									$matieres = Matiere::getByNiveau($evaluation->getMatiereNiveau()->getNiveau()->getIdNiveau());
									foreach ($matieres as $matiere){
										echo '<option value="' . $matiere->getIdMatiere() . '"'.($evaluation->getMatiereNiveau()->getMatiere()->getIdMatiere()==$matiere->getIdMatiere()?'selected':'').'>' . $matiere->getLibelleMatiere() . '</option>';
									}
									?>
								</select>
							</td>
						</tr>
						<tr>
							<td><label for="typeEval">Type d'&eacute;valuation : </label></td>
							<td><select id="typeEval" name="addType">
									<option value=""></option>
									<?php
									$typeEval = TypeEvaluation::getAll();
									foreach ($typeEval as $te) {
										echo '<option value="' . $te->getIdTypeEvaluation() . '" ' . ($evaluation->getIdTypeEvaluation() == $te->getIdTypeEvaluation() ? 'selected' : '') . ' >' . $te->getLibelleTypeEvaluation() . '</option>';
 public function execute()
 {
     $anOtherPHPExcelObject = PHPExcel_IOFactory::load($this->inputFileName);
     //var_dump($anOtherPHPExcelObject->setActiveSheetIndex()->getHighestRowAndColumn()["row"]);
     $rowLength = $anOtherPHPExcelObject->setActiveSheetIndex()->getHighestRowAndColumn()["row"];
     $objReader = PHPExcel_IOFactory::createReader($this->inputFileType);
     $filterSubset = new MyReadFilter(1, $rowLength, range(TYPE_ENSEIGNANT, TP));
     $objReader->setReadFilter($filterSubset);
     $onePHPExcelObject = $objReader->load($this->inputFileName);
     $MatiereTemp = new Matiere();
     $ClasseTemp = "";
     $EnseignantTemp = new Enseignant();
     $sheet = $onePHPExcelObject->getSheet(0);
     // On récupère le premier feuillet
     $TeacherInfo = "";
     foreach ($sheet->getRowIterator() as $row) {
         foreach ($row->getCellIterator() as $cell) {
             $column = $cell->getColumn();
             $valeur = $cell->getValue();
             //print_r($cell->getCoordinate());
             //print_r($cell->getColumn());
             if ($column == TYPE_ENSEIGNANT) {
                 //$EnseignantTemp->Type = $valeur;
                 $TeacherInfo = $TeacherInfo . "|" . $valeur;
             }
             if ($column == NOM) {
                 $TeacherInfo = $TeacherInfo . "|" . $valeur;
                 //$EnseignantTemp->Nom = $valeur;
                 //echo $valeur." ";
             }
             if ($column == PRENOM) {
                 $TeacherInfo = $TeacherInfo . "|" . $valeur;
                 //$EnseignantTemp->Prenom = $valeur;
                 //echo $valeur." ";
             }
             if ($column == TITRE) {
                 $TeacherInfo = $TeacherInfo . "|" . $valeur;
                 //$EnseignantTemp->Grade = $valeur;
                 //echo $valeur." ";
             }
             if ($column == TYPE_AFFECTATION) {
                 $TeacherInfo = $TeacherInfo . "|" . $valeur;
                 //$EnseignantTemp->Affectation = $valeur;
             }
             if ($column == CLASSE) {
                 $ClasseTemp = $cell->getValue();
             }
             if ($column == MATIERE) {
                 $matiere = new Matiere($cell->getValue());
                 $enseignant = new Enseignant($TeacherInfo);
                 $matiere->Classe = $ClasseTemp;
                 $matiere->addEnseignant($enseignant);
                 $MatiereTemp = $matiere;
                 array_push($this->MatiereList, $matiere);
                 //print_r($cell->getValue());
                 $TeacherInfo = $TeacherInfo . "\n";
                 //echo $TeacherInfo;
             }
             if ($column == SEMESTRE1) {
                 end($this->MatiereList)->Semestre1 = $valeur;
             }
             if ($column == SEMESTRE2) {
                 end($this->MatiereList)->Semestre2 = $valeur;
             }
             if ($column == CM) {
                 end($this->MatiereList)->CM = $valeur;
                 end($this->MatiereList)->addFirstHoraire("CM", $valeur);
             }
             if ($column == TD) {
                 end($this->MatiereList)->TD = $valeur;
                 end($this->MatiereList)->addFirstHoraire("TD", $valeur);
             }
             if ($column == TP) {
                 end($this->MatiereList)->TP = $valeur;
                 end($this->MatiereList)->addFirstHoraire("TP", $valeur);
             }
         }
         $TeacherInfo = "";
         //Initialize Teacher information
     }
 }
Exemplo n.º 11
0
	/**
	 * Filter the query by a related Matiere object
	 *
	 * @param     Matiere $matiere  the related object to use as filter
	 * @param     string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
	 *
	 * @return    CategorieMatiereQuery The current query, for fluid interface
	 */
	public function filterByMatiere($matiere, $comparison = null)
	{
		if ($matiere instanceof Matiere) {
			return $this
				->addUsingAlias(CategorieMatierePeer::ID, $matiere->getCategorieId(), $comparison);
		} elseif ($matiere instanceof PropelCollection) {
			return $this
				->useMatiereQuery()
				->filterByPrimaryKeys($matiere->getPrimaryKeys())
				->endUse();
		} else {
			throw new PropelException('filterByMatiere() only accepts arguments of type Matiere or PropelCollection');
		}
	}
Exemplo n.º 12
0
	/**
	 * @param	Matiere $matiere The matiere object to add.
	 */
	protected function doAddMatiere($matiere)
	{
		$this->collMatieres[]= $matiere;
		$matiere->setCategorieMatiere($this);
	}
Exemplo n.º 13
0
  * Recherche de tous les profs de l'établissement (pour ce RNE)
  */
 $matieres = $ldap->get_all_matieres();
 $nb_matieres = $matieres['count'];
 /*
  * Ajout des matières
  */
 for ($cpt = 0; $cpt < $matieres['count']; $cpt++) {
     $code_matiere = $matieres[$cpt]['cn'][0];
     $nom_matiere = $matieres[$cpt]['description'][0];
     // On test si on a déjà cette matière
     $nouvelle_matiere = MatierePeer::retrieveByPK($code_matiere);
     if ($nouvelle_matiere != null) {
         echo "La matière " . $nouvelle_matiere->getMatiere() . " (" . $nouvelle_matiere->getNomComplet() . ") existe d&eacute;j&agrave;<br/>";
     } else {
         $nouvelle_matiere = new Matiere();
         $nouvelle_matiere->setMatiere($code_matiere);
         $nouvelle_matiere->setNomComplet($nom_matiere);
         $nouvelle_matiere->save();
     }
     // Maintenant on associe les profs à cette matiere
     $nb_profs = $matieres[$cpt]['memberuid']['count'];
     $matiere_profs = $nouvelle_matiere->getProfesseurs();
     if ($nb_profs > 0) {
         for ($i = 0; $i < $nb_profs; $i++) {
             // On vérifie que le prof existe, quand même...
             $prof = UtilisateurProfessionnelPeer::retrieveByPK($matieres[$cpt]['memberuid'][$i]);
             // Le prof existe, on créer l'association, si elle n'existe pas encore
             if ($prof != null) {
                 // L'association n'existe pas, on la créé
                 // Pour ça, on doit déterminer l'ordre
Exemplo n.º 14
0
echo $prof->getEnvoiCodes() . "</br>";
echo $prof . "</br>";
echo "Cour(s) : </br>";
$cour = new Cours(1, 1, 1, 1);
echo $cour->getNo_cours() . "</br>";
echo $cour->getNo_prof() . "</br>";
echo $cour->getNo_type() . "</br>";
echo $cour->getNo_matiere() . "</br>";
echo $cour . "</br>";
echo "Type(s) : </br>";
$type = new Type(1, "CM");
echo $type->getNo_type() . "</br>";
echo $type->getNom() . "</br>";
echo $type . "</br>";
echo "Matiere(s) : </br>";
$matiere = new Matiere(1, "Base de données", "BdD", 1, 1);
echo $matiere->getNo_matiere() . "</br>";
echo $matiere->getNom() . "</br>";
echo $matiere->getInitiales() . "</br>";
echo $matiere->getNo_module() . "</br>";
echo $matiere->getNo_section() . "</br>";
echo $matiere . "</br>";
echo "Seance(s) : </br>";
$seance = new Seance(1, "21/10/2015", 1, 1, 1, 1, 1);
echo $seance->getNo_seance() . "</br>";
echo $seance->getDate_debut() . "</br>";
echo $seance->getNo_cours() . "</br>";
echo $seance->getNo_ordre() . "</br>";
echo $seance->getNo_section() . "</br>";
echo $seance->getNo_groupe() . "</br>";
echo $seance->getNo_sous_groupe() . "</br>";