public function actionRemoveAllInfoCourse() { $idcourse = $_REQUEST["idcourse"]; $comm = Yii::app()->db->createCommand(); $comm->reset(); $comm->delete('pls_comment', 'data_id=' . $idcourse . ' AND data_type="course"'); $ListCourseLEcture = WCourseLecture::ArrayIdCourseLecture(WCourseLecture::getListCourseLecture($idcourse)); if (!empty($ListCourseLEcture)) { foreach ($ListCourseLEcture as $idcourselecture) { $comm->reset(); $comm->delete('pls_training_log', 'action_url="r=wLecture/LectureView&course_lecture_id=' . $idcourselecture . '"'); $comm->reset(); $comm->delete('pls_training_randomquestion', 'course_lecture_id=' . $idcourselecture); } } $comm->reset(); $comm->delete('pls_course_lecture', 'course_id=' . $idcourse); $comm->reset(); $comm->delete('pls_course_trainee', 'course_id=' . $idcourse); $comm->reset(); $comm->delete('pls_chat', 'course_id=' . $idcourse); $comm->reset(); $comm->delete('pls_user_test', 'course_id=' . $idcourse); $comm->reset(); $comm->delete('pls_course', 'id=' . $idcourse); echo json_encode(array("result" => "true")); }