/**
* Delete the row corresponding to the given id.
*
* @param int $id
* @return bool True if the row has been deleted. False if not.
*/
public static function deleteLikert($id)
{
$deleted = BaseSingleton::delete('delete from likert where id_likert = ?', array('i', &$id));
return $deleted;
}
public static function delete($id)
{
$deleted = BaseSingleton::delete('DELETE FROM limitant WHERE id = ?', array('i', &$id));
return $deleted;
}
public static function delete($id)
{
$deleted = BaseSingleton::delete('DELETE FROM distrib_alias WHERE id = ?', array('i', &$id));
return $deleted;
}
/**
* Delete the row corresponding to the given id.
*
* @param int $id
* @return bool True if the row has been deleted. False if not.
*/
public static function deleteUser($id)
{
$deleted = BaseSingleton::delete('delete from user where id_user = ?', array('i', &$id));
return $deleted;
}
private function disconnect()
{
self::$instance->mysqli->close();
self::$instance = null;
}
public static function inscritStudentModule($studentId, $moduleId)
{
$sql = 'INSERT INTO user_inscrire_module ' . '(user_id, module_id) ' . 'VALUES(?,?)';
$param = array('ii', &$studentId, &$moduleId);
$data = BaseSingleton::insertOrEdit($sql, $param);
}
public static function deleteUtilisateur($utilisateurId)
{
$deleted = BaseSingleton::delete('DELETE FROM utilisateur_has_groupe WHERE utilisateur_id = ?', array('i', &$utilisateurId));
return $deleted;
}
/**
* Delete the row corresponding to the given id.
*
* @param int $id
* @return bool True if the row has been deleted. False if not.
*/
public static function deleteModule($id)
{
$deleted = BaseSingleton::delete('delete from module where id_module = ?', array('i', &$id));
return $deleted;
}
/**
* Delete the row corresponding to the given id.
*
* @param int $id
* @return bool True if the row has been deleted. False if not.
*/
public static function deleteUserHasModule($idUser, $idModule)
{
$deleted = BaseSingleton::delete('delete from user_has_module ' . 'WHERE USER_id_user=? AND MODULE_id_module=?', array('ii', &$idUser, &$idModule));
return $deleted;
}
/**
* Delete the row corresponding to the given id.
*
* @param int $id
* @return bool True if the row has been deleted. False if not.
*/
public static function deleteType($id)
{
$deleted = BaseSingleton::delete('delete from type where id_type = ?', array('i', &$id));
return $deleted;
}
public static function deleteMachine($machineId)
{
$deleted = BaseSingleton::delete('DELETE FROM groupe_has_machine WHERE machine_id = ?', array('i', &$machineId));
return $deleted;
}
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;
}
}
/**
* Delete the row corresponding to the given id.
*
* @param int $id
* @return bool True if the row has been deleted. False if not.
*/
public static function deleteComponent($id)
{
$deleted = BaseSingleton::delete('delete from component where id_component = ?', array('i', &$id));
return $deleted;
}
/**
* Delete the row corresponding to the given id.
*
* @param int $id
* @return bool True if the row has been deleted. False if not.
*/
public static function deletePrice($id)
{
$deleted = BaseSingleton::delete('delete from PRICE where id_price = ?', array('i', &$id));
return $deleted;
}
/**
* Delete the row corresponding to the given id.
*
* @param int $id
* @return bool True if the row has been deleted. False if not.
*/
public static function deleteQuestion($id)
{
$deleted = BaseSingleton::delete('delete from question where id_question = ?', array('i', &$id));
return $deleted;
}