/** * 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; }
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'); } }
<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){
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; }
* 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);
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());
/** * 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; }
<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'é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 } }
/** * 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'); } }
/** * @param Matiere $matiere The matiere object to add. */ protected function doAddMatiere($matiere) { $this->collMatieres[]= $matiere; $matiere->setCategorieMatiere($this); }
* 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éjà<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
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>";