public function delete($id)
{
$id = (int) $id;
$this->_access->query("START TRANSACTION");
$manageRateDomain = new RateDomainManager();
$manageRateQuality = new RateQualityManager();
$manageRateDomain->deleteByActivityId($id);
$manageRateQuality->deleteByActivityId($id);
$manageSlide = new SlideManager();
$slides = $manageSlide->getSlidesOfLesson($id);
foreach ($slides as $slide) {
$manageSlide->delete($slide->id());
}
$lesson = $this->getById($id);
if ($lesson->getPostId() !== 0) {
$this->unpost($lesson);
}
$this->_access->delete(StudyPressDB::getTableNameVisite(), array(StudyPressDB::COL_ID_ACTIVITY_VISITE => $id));
$this->_access->delete(StudyPressDB::getTableNameActivity(), array(StudyPressDB::COL_ID_ACTIVITY => $id));
if ($this->isError()) {
$m = $this->getMessageError();
$this->_access->query("ROLLBACK");
$this->_access->setMsgError($m);
} else {
$this->_access->query("COMMIT");
}
}
public function delete($id)
{
$id = (int) $id;
$this->_access->query("START TRANSACTION");
$manageRateDomain = new RateDomainManager();
$manageRateQuality = new RateQualityManager();
$manageRateDomain->deleteByActivityId($id);
$manageRateQuality->deleteByActivityId($id);
$manageQuestion = new QuestionManager();
$questions = $manageQuestion->getQuestionsOfQuiz($id);
foreach ($questions as $q) {
$manageQuestion->delete($q->getId());
}
$this->deleteResultByQuiz($id);
$quiz = $this->getById($id);
if ($quiz->getPostId() !== 0) {
$this->unpost($quiz);
}
$this->_access->delete(StudyPressDB::getTableNameVisite(), array(StudyPressDB::COL_ID_ACTIVITY_VISITE => $id));
$this->_access->delete(StudyPressDB::getTableNameActivity(), array(StudyPressDB::COL_ID_ACTIVITY => $id));
if ($this->isError()) {
$m = $this->getMessageError();
$this->_access->query("ROLLBACK");
$this->_access->setMsgError($m);
} else {
$this->_access->query("COMMIT");
}
}
