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"); } }