123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666 |
- <?php
- require_once 'Course.class.php';
- class CourseRecycler
- {
-
- public $course;
- public $type;
-
- public function __construct($course)
- {
- $this->course = $course;
- $this->course_info = api_get_course_info($this->course->code);
- $this->course_id = $this->course_info['real_id'];
- }
-
- public function recycle($type)
- {
- if (empty($type)) {
- return false;
- }
- $this->type = $type;
- $table_tool_intro = Database::get_course_table(TABLE_TOOL_INTRO);
- $table_linked_resources = Database::get_course_table(TABLE_LINKED_RESOURCES);
- $table_item_properties = Database::get_course_table(TABLE_ITEM_PROPERTY);
- $this->recycle_links();
- $this->recycle_link_categories();
- $this->recycle_events();
- $this->recycle_announcements();
- $this->recycle_documents();
- $this->recycle_forums();
- $this->recycle_forum_categories();
- $this->recycle_quizzes();
- $this->recycle_test_category();
- $this->recycle_surveys();
- $this->recycle_learnpaths();
- $this->recycle_cours_description();
- $this->recycle_wiki();
- $this->recycle_glossary();
- $this->recycle_thematic();
- $this->recycle_attendance();
- $this->recycle_work();
- foreach ($this->course->resources as $type => $resources) {
- foreach ($resources as $id => $resource) {
- $sql = "DELETE FROM ".$table_linked_resources."
- WHERE
- c_id = ".$this->course_id." AND
- (source_type = '".$type."' AND source_id = '".$id."') OR
- (resource_type = '".$type."' AND resource_id = '".$id."') ";
- Database::query($sql);
- if (is_numeric($id)) {
- $sql = "DELETE FROM ".$table_item_properties."
- WHERE c_id = ".$this->course_id." AND tool ='".$resource->get_tool()."' AND ref=".$id;
- Database::query($sql);
- } elseif ($type == RESOURCE_TOOL_INTRO) {
- $sql = "DELETE FROM $table_tool_intro
- WHERE c_id = ".$this->course_id." AND id='$id'";
- Database::query($sql);
- }
- }
- }
- }
-
- public function recycle_documents()
- {
- $table = Database :: get_course_table(TABLE_DOCUMENT);
- $tableItemProperty = Database :: get_course_table(TABLE_ITEM_PROPERTY);
- if ($this->type == 'full_backup') {
- $sql = "DELETE FROM $tableItemProperty
- WHERE
- c_id = ".$this->course_id." AND
- tool = '".TOOL_DOCUMENT."'";
- Database::query($sql);
- $sql = "DELETE FROM $table WHERE c_id = ".$this->course_id;
- Database::query($sql);
-
- rmdirr($this->course->backup_path.'/document', true);
- } else {
- if ($this->course->has_resources(RESOURCE_DOCUMENT)) {
- foreach ($this->course->resources[RESOURCE_DOCUMENT] as $document) {
- rmdirr($this->course->backup_path.'/'.$document->path);
- }
- $ids = implode(',', (array_keys($this->course->resources[RESOURCE_DOCUMENT])));
- $sql = "DELETE FROM $table
- WHERE c_id = ".$this->course_id." AND id IN(".$ids.")";
- Database::query($sql);
- }
- }
- }
-
- public function recycle_wiki()
- {
- if ($this->course->has_resources(RESOURCE_WIKI)) {
- $table_wiki = Database::get_course_table(TABLE_WIKI);
- $table_wiki_conf = Database::get_course_table(TABLE_WIKI_CONF);
- $pages = array();
- foreach ($this->course->resources[RESOURCE_WIKI] as $resource) {
- $pages[] = $resource->page_id;
- }
- $wiki_ids = implode(',', (array_keys($this->course->resources[RESOURCE_WIKI])));
- $page_ids = implode(',', $pages);
- $sql = "DELETE FROM ".$table_wiki."
- WHERE c_id = ".$this->course_id." AND id IN(".$wiki_ids.")";
- Database::query($sql);
- $sql = "DELETE FROM ".$table_wiki_conf."
- WHERE c_id = ".$this->course_id." AND page_id IN(".$page_ids.")";
- Database::query($sql);
- }
- }
-
- public function recycle_glossary()
- {
- if ($this->course->has_resources(RESOURCE_GLOSSARY)) {
- $table_glossary = Database::get_course_table(TABLE_GLOSSARY);
- $ids = implode(',', (array_keys($this->course->resources[RESOURCE_GLOSSARY])));
- $sql = "DELETE FROM ".$table_glossary." WHERE c_id = ".$this->course_id." AND glossary_id IN(".$ids.")";
- Database::query($sql);
- }
- }
-
- public function recycle_links()
- {
- if ($this->course->has_resources(RESOURCE_LINK)) {
- $table = Database :: get_course_table(TABLE_LINK);
- $ids = implode(',', (array_keys($this->course->resources[RESOURCE_LINK])));
- $sql = "DELETE FROM ".$table." WHERE c_id = ".$this->course_id." AND id IN(".$ids.")";
- Database::query($sql);
- }
- }
-
- public function recycle_forums()
- {
- $table_category = Database :: get_course_table(TABLE_FORUM_CATEGORY);
- $table_forum = Database :: get_course_table(TABLE_FORUM);
- $table_thread = Database :: get_course_table(TABLE_FORUM_THREAD);
- $table_post = Database :: get_course_table(TABLE_FORUM_POST);
- $table_attachment = Database::get_course_table(TABLE_FORUM_ATTACHMENT);
- $table_notification = Database::get_course_table(TABLE_FORUM_NOTIFICATION);
- $table_mail_queue = Database::get_course_table(TABLE_FORUM_MAIL_QUEUE);
- $table_thread_qualify = Database::get_course_table(TABLE_FORUM_THREAD_QUALIFY);
- $table_thread_qualify_log = Database::get_course_table(TABLE_FORUM_THREAD_QUALIFY_LOG);
- if ($this->type == 'full_backup') {
- $sql = "DELETE FROM ".$table_category." WHERE c_id = ".$this->course_id;
- Database::query($sql);
- $sql = "DELETE FROM ".$table_forum." WHERE c_id = ".$this->course_id;
- Database::query($sql);
- $sql = "DELETE FROM ".$table_thread." WHERE c_id = ".$this->course_id;
- Database::query($sql);
- $sql = "DELETE FROM ".$table_post." WHERE c_id = ".$this->course_id;
- Database::query($sql);
- $sql = "DELETE FROM ".$table_attachment." WHERE c_id = ".$this->course_id;
- Database::query($sql);
- $sql = "DELETE FROM ".$table_notification." WHERE c_id = ".$this->course_id;
- Database::query($sql);
- $sql = "DELETE FROM ".$table_mail_queue." WHERE c_id = ".$this->course_id;
- Database::query($sql);
- $sql = "DELETE FROM ".$table_thread_qualify." WHERE c_id = ".$this->course_id;
- Database::query($sql);
- $sql = "DELETE FROM ".$table_thread_qualify_log." WHERE c_id = ".$this->course_id;
- Database::query($sql);
- $sql = "DELETE FROM ".$table_thread_qualify_log." WHERE c_id = ".$this->course_id;
- Database::query($sql);
- }
- if ($this->course->has_resources(RESOURCE_FORUMCATEGORY)) {
- $forum_ids = implode(',', (array_keys($this->course->resources[RESOURCE_FORUMCATEGORY])));
- $sql = "DELETE FROM ".$table_category." WHERE c_id = ".$this->course_id." AND cat_id IN(".$forum_ids.");";
- Database::query($sql);
- }
- if ($this->course->has_resources(RESOURCE_FORUM)) {
- $forum_ids = implode(',', (array_keys($this->course->resources[RESOURCE_FORUM])));
- $sql = "DELETE FROM $table_attachment USING $table_attachment
- INNER JOIN $table_post
- WHERE ".$table_post.".c_id = ".$this->course_id." AND
- ".$table_attachment.".c_id = ".$this->course_id." AND
- ".$table_attachment.".post_id = ".$table_post.".post_id".
- " AND ".$table_post.".forum_id IN(".$forum_ids.");";
- Database::query($sql);
- $sql = "DELETE FROM ".$table_mail_queue." USING ".$table_mail_queue." INNER JOIN $table_post
- WHERE
- ".$table_post.".c_id = ".$this->course_id." AND
- ".$table_mail_queue.".c_id = ".$this->course_id." AND
- ".$table_mail_queue.".post_id = ".$table_post.".post_id AND
- ".$table_post.".forum_id IN(".$forum_ids.");";
- Database::query($sql);
-
- $sql = "DELETE FROM $table_mail_queue
- USING ".$table_mail_queue." INNER JOIN $table_thread
- WHERE
- $table_mail_queue.c_id = ".$this->course_id." AND
- $table_thread.c_id = ".$this->course_id." AND
- $table_mail_queue.thread_id = ".$table_thread.".thread_id AND
- $table_thread.forum_id IN(".$forum_ids.");";
- Database::query($sql);
- $sql = "DELETE FROM $table_thread_qualify
- USING $table_thread_qualify INNER JOIN $table_thread
- WHERE
- $table_thread_qualify.c_id = ".$this->course_id." AND
- $table_thread.c_id = ".$this->course_id." AND
- $table_thread_qualify.thread_id = $table_thread.thread_id AND
- $table_thread.forum_id IN(".$forum_ids.");";
- Database::query($sql);
- $sql = "DELETE FROM ".$table_thread_qualify_log.
- " USING ".$table_thread_qualify_log." INNER JOIN ".$table_thread.
- " WHERE
- $table_thread_qualify_log.c_id = ".$this->course_id." AND
- $table_thread.c_id = ".$this->course_id." AND
- ".$table_thread_qualify_log.".thread_id = ".$table_thread.".thread_id AND
- ".$table_thread.".forum_id IN(".$forum_ids.");";
- Database::query($sql);
- $sql = "DELETE FROM ".$table_notification."
- WHERE c_id = ".$this->course_id." AND forum_id IN(".$forum_ids.")";
- Database::query($sql);
- $sql = "DELETE FROM ".$table_post."
- WHERE c_id = ".$this->course_id." AND forum_id IN(".$forum_ids.")";
- Database::query($sql);
- $sql = "DELETE FROM ".$table_thread."
- WHERE c_id = ".$this->course_id." AND forum_id IN(".$forum_ids.")";
- Database::query($sql);
- $sql = "DELETE FROM ".$table_forum."
- WHERE c_id = ".$this->course_id." AND forum_id IN(".$forum_ids.")";
- Database::query($sql);
- }
- }
-
- public function recycle_forum_categories()
- {
- $table_forum = Database :: get_course_table(TABLE_FORUM);
- $table_forumcat = Database :: get_course_table(TABLE_FORUM_CATEGORY);
- $sql = "SELECT fc.cat_id FROM ".$table_forumcat." fc
- LEFT JOIN ".$table_forum." f
- ON
- fc.cat_id=f.forum_category AND
- fc.c_id = ".$this->course_id." AND
- f.c_id = ".$this->course_id."
- WHERE f.forum_id IS NULL";
- $res = Database::query($sql);
- while ($obj = Database::fetch_object($res)) {
- $sql = "DELETE FROM ".$table_forumcat."
- WHERE c_id = ".$this->course_id." AND cat_id = ".$obj->cat_id;
- Database::query($sql);
- }
- }
-
- public function recycle_link_categories()
- {
- $link_cat_table = Database :: get_course_table(TABLE_LINK_CATEGORY);
- $link_table = Database :: get_course_table(TABLE_LINK);
- $sql = "SELECT lc.id FROM ".$link_cat_table." lc
- LEFT JOIN ".$link_table." l
- ON
- lc.id=l.category_id AND
- lc.c_id = ".$this->course_id." AND
- l.c_id = ".$this->course_id."
- WHERE l.id IS NULL";
- $res = Database::query($sql);
- while ($obj = Database::fetch_object($res)) {
- $sql = "DELETE FROM ".$link_cat_table."
- WHERE c_id = ".$this->course_id." AND id = ".$obj->id;
- Database::query($sql);
- }
- }
-
- public function recycle_events() {
- if ($this->course->has_resources(RESOURCE_EVENT)) {
- $table = Database :: get_course_table(TABLE_AGENDA);
- $table_attachment = Database :: get_course_table(TABLE_AGENDA_ATTACHMENT);
- $ids = implode(',', (array_keys($this->course->resources[RESOURCE_EVENT])));
- $sql = "DELETE FROM ".$table."
- WHERE c_id = ".$this->course_id." AND id IN(".$ids.")";
- Database::query($sql);
- $sql = "DELETE FROM ".$table_attachment."
- WHERE c_id = ".$this->course_id." AND agenda_id IN(".$ids.")";
- Database::query($sql);
- }
- }
-
- public function recycle_announcements()
- {
- if ($this->course->has_resources(RESOURCE_ANNOUNCEMENT)) {
- $table = Database :: get_course_table(TABLE_ANNOUNCEMENT);
- $table_attachment = Database :: get_course_table(TABLE_ANNOUNCEMENT_ATTACHMENT);
- $ids = implode(',', (array_keys($this->course->resources[RESOURCE_ANNOUNCEMENT])));
- $sql = "DELETE FROM ".$table."
- WHERE c_id = ".$this->course_id." AND id IN(".$ids.")";
- Database::query($sql);
- $sql = "DELETE FROM ".$table_attachment."
- WHERE c_id = ".$this->course_id." AND announcement_id IN(".$ids.")";
- Database::query($sql);
- }
- }
-
- public function recycle_quizzes()
- {
- if ($this->course->has_resources(RESOURCE_QUIZ)) {
- $table_qui_que = Database :: get_course_table(TABLE_QUIZ_QUESTION);
- $table_qui_ans = Database :: get_course_table(TABLE_QUIZ_ANSWER);
- $table_qui = Database :: get_course_table(TABLE_QUIZ_TEST);
- $table_rel = Database :: get_course_table(TABLE_QUIZ_TEST_QUESTION);
- $table_qui_que_opt = Database :: get_course_table(TABLE_QUIZ_QUESTION_OPTION);
- $table_qui_que_cat = Database :: get_course_table(TABLE_QUIZ_QUESTION_CATEGORY);
- $table_qui_que_rel_cat = Database :: get_course_table(TABLE_QUIZ_QUESTION_REL_CATEGORY);
- $ids = array_keys($this->course->resources[RESOURCE_QUIZ]);
-
-
-
- $delete_orphan_questions = in_array(-1, $ids);
- $ids = implode(',', $ids);
- if (!empty($ids)) {
-
-
- $sql = "DELETE FROM ".$table_qui." WHERE c_id = ".$this->course_id." AND id IN(".$ids.")";
- Database::query($sql);
- $sql = "DELETE FROM ".$table_rel." WHERE c_id = ".$this->course_id." AND exercice_id IN(".$ids.")";
- Database::query($sql);
- }
-
- if ($delete_orphan_questions) {
- $sql = " (
- SELECT q.id, ex.c_id FROM $table_qui_que q
- INNER JOIN $table_rel r
- ON (q.c_id = r.c_id AND q.id = r.question_id)
- INNER JOIN $table_qui ex
- ON (ex.id = r.exercice_id AND ex.c_id = r.c_id)
- WHERE ex.c_id = ".$this->course_id." AND (ex.active = '-1' OR ex.id = '-1')
- )
- UNION
- (
- SELECT q.id, r.c_id FROM $table_qui_que q
- LEFT OUTER JOIN $table_rel r
- ON (q.c_id = r.c_id AND q.id = r.question_id)
- WHERE q.c_id = ".$this->course_id." AND r.question_id is null
- )
- UNION
- (
- SELECT q.id, r.c_id FROM $table_qui_que q
- INNER JOIN $table_rel r
- ON (q.c_id = r.c_id AND q.id = r.question_id)
- WHERE r.c_id = ".$this->course_id." AND (r.exercice_id = '-1' OR r.exercice_id = '0')
- )";
- $db_result = Database::query($sql);
- if (Database::num_rows($db_result) > 0) {
- $orphan_ids = array();
- while ($obj = Database::fetch_object($db_result)) {
- $orphan_ids[] = $obj->id;
- }
- $orphan_ids = implode(',', $orphan_ids);
- $sql = "DELETE FROM ".$table_rel." WHERE c_id = ".$this->course_id." AND question_id IN(".$orphan_ids.")";
- Database::query($sql);
- $sql = "DELETE FROM ".$table_qui_ans." WHERE c_id = ".$this->course_id." AND question_id IN(".$orphan_ids.")";
- Database::query($sql);
- $sql = "DELETE FROM ".$table_qui_que." WHERE c_id = ".$this->course_id." AND id IN(".$orphan_ids.")";
- Database::query($sql);
- }
-
- $sql = "DELETE FROM $table_qui_que_rel_cat WHERE c_id = ".$this->course_id;
- Database::query($sql);
- $sql = "DELETE FROM $table_qui_que_cat WHERE c_id = ".$this->course_id;
- Database::query($sql);
- $sql = "DELETE FROM $table_qui_que_opt WHERE c_id = ".$this->course_id;
- Database::query($sql);
- }
-
-
- $sql = "DELETE FROM ".$table_qui." WHERE c_id = ".$this->course_id." AND active = -1";
- Database::query($sql);
- }
- }
-
- public function recycle_test_category()
- {
- if (isset($this->course->resources[RESOURCE_TEST_CATEGORY])) {
- foreach ($this->course->resources[RESOURCE_TEST_CATEGORY] as $tab_test_cat) {
- $obj_cat = new TestCategory($tab_test_cat->source_id);
- $obj_cat->removeCategory();
- }
- }
- }
-
- public function recycle_surveys()
- {
- if ($this->course->has_resources(RESOURCE_SURVEY)) {
- $table_survey = Database :: get_course_table(TABLE_SURVEY);
- $table_survey_q = Database :: get_course_table(TABLE_SURVEY_QUESTION);
- $table_survey_q_o = Database :: get_course_table(TABLE_SURVEY_QUESTION_OPTION);
- $table_survey_a = Database :: get_course_Table(TABLE_SURVEY_ANSWER);
- $table_survey_i = Database :: get_course_table(TABLE_SURVEY_INVITATION);
- $ids = implode(',', (array_keys($this->course->resources[RESOURCE_SURVEY])));
- $sql = "DELETE FROM ".$table_survey_i." WHERE c_id = ".$this->course_id." ";
- Database::query($sql);
- $sql = "DELETE FROM ".$table_survey_a." WHERE c_id = ".$this->course_id." AND survey_id IN(".$ids.")";
- Database::query($sql);
- $sql = "DELETE FROM ".$table_survey_q_o." WHERE c_id = ".$this->course_id." AND survey_id IN(".$ids.")";
- Database::query($sql);
- $sql = "DELETE FROM ".$table_survey_q." WHERE c_id = ".$this->course_id." AND survey_id IN(".$ids.")";
- Database::query($sql);
- $sql = "DELETE FROM ".$table_survey." WHERE c_id = ".$this->course_id." AND survey_id IN(".$ids.")";
- Database::query($sql);
- }
- }
-
- public function recycle_learnpaths()
- {
- if ($this->course->has_resources(RESOURCE_LEARNPATH)) {
- $table_main = Database :: get_course_table(TABLE_LP_MAIN);
- $table_item = Database :: get_course_table(TABLE_LP_ITEM);
- $table_view = Database :: get_course_table(TABLE_LP_VIEW);
- $table_iv = Database :: get_course_table(TABLE_LP_ITEM_VIEW);
- $table_iv_int = Database::get_course_table(TABLE_LP_IV_INTERACTION);
- $table_tool = Database::get_course_table(TABLE_TOOL_LIST);
- foreach($this->course->resources[RESOURCE_LEARNPATH] as $id => $learnpath) {
-
- if ($learnpath->lp_type == 2) {
-
-
- if (trim($learnpath->path) != '') {
-
-
- $scorm_package_dir = realpath($this->course->path . 'scorm/' . $learnpath->path);
- rmdirr($scorm_package_dir);
- }
- }
-
- $sql = "DELETE FROM $table_tool
- WHERE c_id = ".$this->course_id." AND link LIKE '%lp_controller.php%lp_id=$id%' AND image='scormbuilder.gif'";
- Database::query($sql);
-
- $sql_items = "SELECT id FROM $table_item
- WHERE c_id = ".$this->course_id." AND lp_id=$id";
- $res_items = Database::query($sql_items);
- while ($row_item = Database::fetch_array($res_items)) {
-
- $sql_iv = "SELECT id FROM $table_iv
- WHERE c_id = ".$this->course_id." AND lp_item_id=".$row_item['id'];
- $res_iv = Database::query($sql_iv);
- while ($row_iv = Database::fetch_array($res_iv)) {
-
- $sql_iv_int_del = "DELETE FROM $table_iv_int
- WHERE c_id = ".$this->course_id." AND lp_iv_id = ".$row_iv['id'];
- Database::query($sql_iv_int_del);
- }
-
- $sql_iv_del = "DELETE FROM $table_iv
- WHERE c_id = ".$this->course_id." AND lp_item_id=".$row_item['id'];
- Database::query($sql_iv_del);
- }
-
- $sql_items_del = "DELETE FROM $table_item WHERE c_id = ".$this->course_id." AND lp_id=$id";
- Database::query($sql_items_del);
-
- $sql_views_del = "DELETE FROM $table_view WHERE c_id = ".$this->course_id." AND lp_id=$id";
- Database::query($sql_views_del);
-
- $sql_del = "DELETE FROM $table_main WHERE c_id = ".$this->course_id." AND id = $id";
- Database::query($sql_del);
- }
- }
- }
-
- public function recycle_cours_description()
- {
- if ($this->course->has_resources(RESOURCE_COURSEDESCRIPTION)) {
- $table = Database :: get_course_table(TABLE_COURSE_DESCRIPTION);
- $ids = implode(',', (array_keys($this->course->resources[RESOURCE_COURSEDESCRIPTION])));
- $sql = "DELETE FROM ".$table." WHERE c_id = ".$this->course_id." AND id IN(".$ids.")";
- Database::query($sql);
- }
- }
-
- public function recycle_thematic($session_id = 0)
- {
- if ($this->course->has_resources(RESOURCE_THEMATIC)) {
- $table_thematic = Database :: get_course_table(TABLE_THEMATIC);
- $table_thematic_advance = Database :: get_course_table(TABLE_THEMATIC_ADVANCE);
- $table_thematic_plan = Database :: get_course_table(TABLE_THEMATIC_PLAN);
- $resources = $this->course->resources;
- foreach ($resources[RESOURCE_THEMATIC] as $last_id => $thematic) {
- if (is_numeric($last_id)) {
- foreach($thematic->thematic_advance_list as $thematic_advance) {
- $cond = array('id = ? AND c_id = ?'=>array($thematic_advance['id'], $this->course_id));
- api_item_property_update($this->course_info, 'thematic_advance', $thematic_advance['id'],'ThematicAdvanceDeleted', api_get_user_id());
- Database::delete($table_thematic_advance, $cond);
- }
- foreach($thematic->thematic_plan_list as $thematic_plan) {
- $cond = array('id = ? AND c_id = ?'=>array($thematic_plan['id'], $this->course_id));
- api_item_property_update($this->course_info, 'thematic_plan', $thematic_advance['id'], 'ThematicPlanDeleted', api_get_user_id());
- Database::delete($table_thematic_plan, $cond);
- }
- $cond = array('id = ? AND c_id = ?'=>array($last_id, $this->course_id));
- api_item_property_update($this->course_info, 'thematic', $last_id,'ThematicDeleted', api_get_user_id());
- Database::delete($table_thematic,$cond);
- }
- }
- }
- }
-
- public function recycle_attendance($session_id = 0)
- {
- if ($this->course->has_resources(RESOURCE_ATTENDANCE)) {
- $table_attendance = Database :: get_course_table(TABLE_ATTENDANCE);
- $table_attendance_calendar = Database :: get_course_table(TABLE_ATTENDANCE_CALENDAR);
- $resources = $this->course->resources;
- foreach ($resources[RESOURCE_ATTENDANCE] as $last_id => $obj) {
- if (is_numeric($last_id)) {
- foreach($obj->attendance_calendar as $attendance_calendar) {
- $cond = array('id = ? AND c_id = ? '=>array($attendance_calendar['id'], $this->course_id));
- Database::delete($table_attendance_calendar, $cond);
- }
- $cond = array('id = ? AND c_id = ?'=>array($last_id, $this->course_id));
- Database::delete($table_attendance, $cond);
- api_item_property_update(
- $this->course_info,
- TOOL_ATTENDANCE,
- $last_id,
- 'AttendanceDeleted',
- api_get_user_id()
- );
- }
- }
- }
- }
-
- public function recycle_work($session_id = 0)
- {
- if ($this->course->has_resources(RESOURCE_WORK)) {
- $table_work = Database :: get_course_table(TABLE_STUDENT_PUBLICATION);
- $table_work_assignment = Database :: get_course_table(TABLE_STUDENT_PUBLICATION_ASSIGNMENT);
- $resources = $this->course->resources;
- foreach ($resources[RESOURCE_WORK] as $last_id => $obj) {
- if (is_numeric($last_id)) {
- $cond = array('publication_id = ? AND c_id = ? '=>array($last_id, $this->course_id));
- Database::delete($table_work_assignment, $cond);
-
- $cond = array('parent_id = ? AND c_id = ?'=>array($last_id, $this->course_id));
- Database::delete($table_work, $cond);
-
- $cond = array('id = ? AND c_id = ?'=>array($last_id, $this->course_id));
- Database::delete($table_work, $cond);
- api_item_property_update(
- $this->course_info,
- TOOL_STUDENTPUBLICATION,
- $last_id,
- 'StudentPublicationDeleted',
- api_get_user_id()
- );
- }
- }
- }
- }
- }
|