/**
* 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;
}
}
