/** * Return all items Question of theme. * * @return question All items in the array. */ public static function findAllByTheme($id_theme) { $questions = array(); $data = BaseSingleton::select('SELECT id_question, question, THEME_id_theme ' . 'FROM question WHERE THEME_id_theme= ?', array('i', &$id_theme)); foreach ($data as $row) { $question = new Question(); $question->hydrate($row); $questions[] = $question; } return $questions; }
public static function findByRole($role) { $data = BaseSingleton::select('SELECT role.id as id, ' . 'role.nom_role as nom_role, ' . 'role.description as description ' . ' FROM role' . ' WHERE LOWER(role.nom_role) = LOWER(?)', array('s', &$role)); $roles = new Role(); if (sizeof($data) > 0) { $roles->hydrate($data[0]); } else { $roles = null; } return $roles; }
/** * Return all items Price. * * @return price All items in the array. */ public static function findAll() { $prices = array(); $data = BaseSingleton::select('SELECT id_price, price ' . 'FROM price '); foreach ($data as $row) { $price = new Price(); $price->hydrate($row); $prices[] = $price; } return $prices; }
/** * Return all items Role. * * @return role All items in the array. */ public static function findAll() { $roles = array(); $data = BaseSingleton::select('SELECT id_role, role_name ' . 'FROM role '); foreach ($data as $row) { $role = new Role(); $role->hydrate($row); $roles[] = $role; } return $roles; }
/** * Retourne tous les assignment enregistrés. * * @return array[Assignment] Tous les objets dans un tableau. */ public static function findAll() { $mesAssignments = array(); $data = BaseSingleton::select('SELECT id, module_id, label, description, ' . 'date_creation, date_passage, affiche, prixRattrapage, rattrapage ' . 'FROM assignment '); foreach ($data as $row) { $assignment = new Assignment(); $assignment->hydrate($row); $mesAssignments[] = $assignment; } return $mesAssignments; }
public static function findByLimitant($nbUserMax, $nbVMUser) { $data = BaseSingleton::select('SELECT limitant.id as id, ' . 'limitant.nb_user_max as nb_user_max, ' . 'limitant.nb_vm_user as nb_vm_user ' . ' FROM limitant' . ' WHERE limitant.nb_user_max = ? AND limitant.nb_vm_user = ?', array('ii', &$nbUserMax, &$nbVMUser)); $limitants = new Limitant(); if (sizeof($data) > 0) { $limitants->hydrate($data[0]); } else { $limitants = null; } return $limitants; }
/** * Return all items Module. * * @return module All items in the array. */ public static function findAllByStudent($id) { $modules = array(); $data = BaseSingleton::select('SELECT id_module, title, number, PRICE_id_price ' . 'FROM module, user_has_module ' . 'WHERE module.id_module = user_has_module.MODULE_id_module ' . 'AND user_has_module.USER_id_user = ?', array('i', &$id)); foreach ($data as $row) { $module = new Module(); $module->hydrate($row); $modules[] = $module; } return $modules; }
/** * Retourne toutes les mails enregistrées. * * @return array[Mail] Tous les objets dans un tableau. */ public static function findAll() { $mesMails = array(); $data = BaseSingleton::select('SELECT id, modele_mail_id, user_id, ' . ' contenu, date_envoi ' . 'FROM mail '); foreach ($data as $row) { $mail = new Mail(); $mail->hydrate($row); $mesMails[] = $mail; } return $mesMails; }
/** * Retourne toutes les marks enregistrées. * * @return array[Mark] Tous les objets dans un tableau. */ public static function findAll() { $mesMarks = array(); $data = BaseSingleton::select('SELECT id, bareme_id, maxi, mini, grade ' . 'FROM mark '); foreach ($data as $row) { $mark = new Mark(); $mark->hydrate($row); $mesMarks[] = $mark; } return $mesMarks; }
/** * Retourne tous les bareme enregistrés. * * @return array[Bareme] Tous les objets dans un tableau. */ public static function findAll() { $mesBaremes = array(); $data = BaseSingleton::select('SELECT id, label ' . 'FROM bareme '); foreach ($data as $row) { $bareme = new Bareme(); $bareme->hydrate($row); $mesBaremes[] = $bareme; } return $mesBaremes; }
/** * Retourne toutes les typeUsers enregistrées. * * @return array[TypeUser] Tous les objets dans un tableau. */ public static function findAll() { $mesTypeUsers = array(); $data = BaseSingleton::select('SELECT id, label, code, ' . ' description, date_creation, affiche ' . 'FROM type_user '); foreach ($data as $row) { $typeUser = new TypeUser(); $typeUser->hydrate($row); $mesTypeUsers[] = $typeUser; } return $mesTypeUsers; }
/** * Retourne toutes les typeFichiers enregistrées. * * @return array[TypeFichier] Tous les objets dans un tableau. */ public static function findAll() { $mesTypeFichiers = array(); $data = BaseSingleton::select('SELECT id, label, description, chemin ' . 'FROM type_fichier '); foreach ($data as $row) { $typeFichier = new TypeFichier(); $typeFichier->hydrate($row); $mesTypeFichiers[] = $typeFichier; } return $mesTypeFichiers; }
/** * Return all items Answer. * * @return answer All items in the array. */ public static function findAll() { $answers = array(); $data = BaseSingleton::select('SELECT id_answer, answer, answer_date, LIKERT_id_likert, USER_id_user, QUESTION_id_question ' . 'FROM answer'); foreach ($data as $row) { $answer = new Answer(); $answer->hydrate($row); $answers[] = $answer; } return $answers; }
/** * Return all items Likert. * * @return likert All items in the array. */ public static function findAll() { $likerts = array(); $data = BaseSingleton::select('SELECT id_likert, likert ' . 'FROM likert '); foreach ($data as $row) { $likert = new Likert(); $likert->hydrate($row); $likerts[] = $likert; } return $likerts; }
/** * Return all items Type. * * @return type All items in the array. */ public static function findAll() { $types = array(); $data = BaseSingleton::select('SELECT id_type, type_name ' . 'FROM type '); foreach ($data as $row) { $type = new Type(); $type->hydrate($row); $types[] = $type; } return $types; }
/** * Retourne tous les exam enregistrés. * * @return array[Exam] Tous les objets dans un tableau. */ public static function findAll() { $mesExams = array(); $data = BaseSingleton::select('SELECT id, module_id, label, description, ' . 'date_creation, date_passage, affiche, prixRattrapage, rattrapage ' . 'FROM exam '); foreach ($data as $row) { $exam = new Exam(); $exam->hydrate($row); $mesExams[] = $exam; } return $mesExams; }
/** * Retourne toutes les modeleMails enregistrées. * * @return array[ModeleMail] Tous les objets dans un tableau. */ public static function findAll() { $mesModeleMails = array(); $data = BaseSingleton::select('SELECT id, label, description, contenu' . 'FROM modele_mail '); foreach ($data as $row) { $modeleMail = new ModeleMail(); $modeleMail->hydrate($row); $mesModeleMails[] = $modeleMail; } return $mesModeleMails; }
/** * Retourne toutes les fichiers enregistrées. * * @return array[Fichier] Tous les objets dans un tableau. */ public static function findAll() { $mesFichiers = array(); $data = BaseSingleton::select('SELECT id, type_fichier_id, nom, date_creation, affiche ' . 'FROM fichier '); foreach ($data as $row) { $fichier = new Fichier(); $fichier->hydrate($row); $mesFichiers[] = $fichier; } return $mesFichiers; }
public static function findAll() { $usersHaveModule = array(); $data = BaseSingleton::select('SELECT USER_id_user, MODULE_id_module, date, mustPay, finalMark, has_failed, receipt ' . 'FROM user_has_module'); foreach ($data as $row) { $userHasModule = new UserHasModule(); $userHasModule->hydrate($row); $usersHaveModule[] = $userHasModule; } return $usersHaveModule; }
public static function findByGU($groupeId, $utilisateurId) { $data = BaseSingleton::select('SELECT ' . ' utilisateur_has_groupe.groupe_id as groupe_id, ' . ' utilisateur_has_groupe.utilisateur_id as utilisateur_id ' . ' FROM utilisateur_has_groupe' . ' WHERE utilisateur_has_groupe.groupe_id = ? AND utilisateur_has_groupe.utilisateur_id = ?', array('ii', &$groupeId, &$utilisateurId)); $utilisateurhasGroupe = new Utilisateur_has_Groupe(); if (sizeof($data) > 0) { $utilisateurhasGroupe->hydrate($data[0]); } else { $utilisateurhasGroupe = null; } return $utilisateurhasGroupe; }
public static function findByDN($distribId, $nomComplet) { $data = BaseSingleton::select('SELECT distrib_alias.id as id, ' . 'distrib_alias.distrib_id as distrib_id, ' . 'distrib_alias.nom_complet as nom_complet, ' . 'distrib_alias.pseudo as pseudo, ' . 'distrib_alias.commentaire as commentaire, ' . 'distrib_alias.visible as visible ' . ' FROM distrib_alias' . ' WHERE distrib_alias.distrib_id = ? AND LOWER(distrib_alias.nom_complet) = LOWER(?)', array('is', &$distribId, &$nomComplet)); $distribAlias = new Distrib_Alias(); if (sizeof($data) > 0) { $distribAlias->hydrate($data[0]); } else { $distribAlias = null; } return $distribAlias; }
/** * Methode permettant de retourne rla moyenne des exams lié a un module * * @param int $moduleId id du module dont on veut la moyenne des exams * @return int */ public function moyenneExam($moduleId) { $moyenneExam = 0; $sql = 'SELECT AVG(user_participe_exam.note) as MoyenneExam ' . ' FROM user_participe_exam, exam, module ' . ' WHERE module.id = ? ' . 'AND user_participe_exam.exam_id = exam.id ' . 'AND exam.module_id = module.id'; $param = array('i', &$moduleId); $data = BaseSingleton::select($sql, $param); $moyenneExam = $data[0]["MoyenneExam"]; return (int) $moyenneExam; }
public static function findByNbCoeur($nbCoeur) { $data = BaseSingleton::select('SELECT cpu.id as id, ' . 'cpu.nb_coeur as nb_coeur, ' . 'cpu.visible as visible ' . ' FROM cpu' . ' WHERE LOWER(cpu.nb_coeur) = LOWER(?)', array('i', &$nbCoeur)); $cpus = new Cpu(); if (sizeof($data) > 0) { $cpus->hydrate($data[0]); } else { $cpus = null; } return $cpus; }
public static function findByValeur($valeur) { $data = BaseSingleton::select('SELECT ram.id as id, ' . 'ram.valeur as valeur, ' . 'ram.visible as visible ' . ' FROM ram' . ' WHERE LOWER(ram.valeur) = LOWER(?)', array('i', &$valeur)); $rams = new Ram(); if (sizeof($data) > 0) { $rams->hydrate($data[0]); } else { $rams = null; } return $rams; }
/** * Return all items Student. * * @return user All items in the array where user is a student. */ public static function findAllStudents() { $users = array(); $data = BaseSingleton::select('SELECT id_user, login, passwd, mail, inscription_date, first_name, ' . 'last_name, birth_date, address, phone_number, avatar, ROLE_id_role ' . 'FROM user, role WHERE `role`.`id_role`=`user`.`ROLE_id_role` AND `role`.`role_name`="Student"; '); foreach ($data as $row) { $user = new User(); $user->hydrate($row); $users[] = $user; } return $users; }
public static function findByGM($groupeId, $machineId) { $data = BaseSingleton::select('SELECT ' . ' groupe_has_machine.groupe_id as groupe_id, ' . ' groupe_has_machine.machine_id as machine_id, ' . ' groupe_has_machine.commentaire as commentaire ' . ' FROM groupe_has_machine' . ' WHERE groupe_has_machine.groupe_id = ? AND groupe_has_machine.machine_id = ?', array('ii', &$groupeId, &$machineId)); $groupeHasMachine = new Groupe_has_Machine(); if (sizeof($data) > 0) { $groupeHasMachine->hydrate($data[0]); } else { $groupeHasMachine = null; } return $groupeHasMachine; }
public static function findByValeur($valeur) { $data = BaseSingleton::select('SELECT stockage.id as id, ' . 'stockage.valeur as valeur, ' . 'stockage.visible as visible ' . ' FROM stockage' . ' WHERE LOWER(stockage.valeur) = LOWER(?)', array('i', &$valeur)); $stockages = new Stockage(); if (sizeof($data) > 0) { $stockages->hydrate($data[0]); } else { $stockages = null; } return $stockages; }
public static function findByVisible() { $mesDistrib = array(); $data = BaseSingleton::select('SELECT distrib.id as id, ' . 'distrib.nom as nom, ' . 'distrib.archi as archi, ' . 'distrib.version as version, ' . 'distrib.ihm as ihm, ' . 'distrib.visible as visible ' . ' FROM distrib' . ' WHERE distrib.visible = 1'); foreach ($data as $row) { $distrib = new Distrib(); $distrib->hydrate($row); $mesDistrib[] = $distrib; } return $mesDistrib; }
/** * Return all items Component. * * @return component All items in the array. */ public static function findAll() { $components = array(); $data = BaseSingleton::select('SELECT id_component, mark, date, is_resit, ' . 'USER_id_user, COMPONENT_id_component, MODULE_id_module, TYPE_id_type ' . 'FROM component '); foreach ($data as $row) { $component = new Component(); $component->hydrate($row); $components[] = $component; } return $components; }
public static function connection($pseudo, $password) { $data = BaseSingleton::select('SELECT id, prenom, nom, mail, adresse, date_naissance, ' . 'date_creation, pseudo, password, affiche, fichier_id, type_user_id ' . 'FROM user ' . 'WHERE pseudo = ? ' . 'AND password = ? ', array('ss', &$pseudo, &$password)); if (sizeof($data) === 0) { return false; } else { $user = new User(); $user->hydrate($data[0]); return $user; } }