/**
* 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;
}
/**
* 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;
}
/**
* Supprime toute les lignes dans la table user_inscrire_module où l'id du module
* passer en param apparait. Permet de raz les liason entre un module et des user.
* Utiliser lors de la modification des user inscrit à un module donnée (voir module_inscription.php)
* @param int $moduleId
* @return bool
*/
public static function razListeStudentInscrit($moduleId)
{
$sql = 'DELETE FROM user_inscrire_module
WHERE user_inscrire_module.module_id = ?';
$param = array('i', &$moduleId);
$deleted = BaseSingleton::delete($sql, $param);
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 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 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;
}
public static function deleteMachine($machineId)
{
$deleted = BaseSingleton::delete('DELETE FROM groupe_has_machine WHERE machine_id = ?', array('i', &$machineId));
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 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;
}
