/** * cron job to process the export queue * @param string $id Specify which row of export_queue table you want to run - could be used for debugging purposes */ function export_process_queue($id = false) { $where = 'starttime IS NULL'; $values = array(); if ($id) { $where .= ' AND id = ?'; $values = array($id); } // Try getting the first 100 items in queue - TODO; work out a good number to get at once if (!($ready = get_records_select_array('export_queue', $where, $values, 'ctime', '*', 0, 100))) { return true; } $now = date('Y-m-d H:i:s', time()); foreach ($ready as $row) { // If there server is getting too busy we abort and wait for next cron run. if (server_busy()) { log_info('too busy'); return true; } $errors = array(); // update the item with start process time execute_sql('UPDATE {export_queue} SET starttime = ? WHERE id = ?', array($now, $row->id)); $items = get_records_select_array('export_queue_items', 'exportqueueid = ?', array($row->id), 'id'); if (!$items && $row->type == 'all') { $items = array(); $row->what = 'all'; } $views = array(); // To make sure we process the item with this id only once we keep a track of the $lastid // We don't know if the $item will be a collection or view (or artefact possibly in the future) // In the case of a user exporting to leap2a there can be a number of collections/views to deal // with so we want to deal with each collection or view only once. $lastid = ''; $submitted = false; foreach ($items as $key => $item) { if (!empty($item->collection) && $lastid != 'collection_' . $item->collection) { $row->what = 'collections'; $lastid = 'collection_' . $item->collection; $views = array_merge($views, get_column('collection_view', 'view', 'collection', $item->collection)); $submitted = get_record('collection', 'id', $item->collection); } else { if (empty($item->collection) && !empty($item->view) && $lastid != 'view_' . $item->view) { $row->what = 'views'; $lastid = 'view_' . $item->view; $views = array_merge($views, array($item->view)); $submitted = get_record('view', 'id', $item->view); } } } $views = array_unique($views); // Bail if we don't have enough data to do an export if (!isset($row->exporttype) || !isset($row->what) || !isset($views)) { $errors[] = get_string('unabletogenerateexport', 'export'); log_warn(get_string('unabletogenerateexport', 'export')); continue; } safe_require('export', $row->exporttype); $user = new User(); $user->find_by_id($row->usr); $class = generate_class_name('export', $row->exporttype); switch ($row->what) { case 'all': $exporter = new $class($user, PluginExport::EXPORT_ALL_VIEWS, PluginExport::EXPORT_ALL_ARTEFACTS); break; case 'views': $exporter = new $class($user, $views, PluginExport::EXPORT_ARTEFACTS_FOR_VIEWS); break; case 'collections': $exporter = new $class($user, $views, PluginExport::EXPORT_COLLECTIONS); break; default: $errors[] = get_string('unabletoexportportfoliousingoptionsadmin', 'export'); log_warn(get_string('unabletoexportportfoliousingoptionsadmin', 'export')); } $exporter->includefeedback = false; // currently only doing leap2a exports and they can't handle feedback // Get an estimate of how big the unzipped export file would be // so we can check that we have enough disk space for it $space = $exporter->is_diskspace_available(); if (!$space) { $errors[] = get_string('exportfiletoobig', 'mahara'); log_warn(get_string('exportfiletoobig', 'mahara')); } try { $zipfile = $exporter->export(); } catch (SystemException $e) { $errors[] = get_string('exportzipfileerror', 'export', $e->getMessage()); log_warn($e->getMessage()); } $filepath = $exporter->get('exportdir'); // If export is a submission we need to save this from being deleted by the export_cleanup_old_exports cron // so we need to put it somewhere safe if (!empty($submitted->submittedtime)) { // Now set up the export submission directories $submissiondir = get_config('dataroot') . 'submission/' . $row->usr . '/'; if (!check_dir_exists($submissiondir)) { $errors[] = get_string('submissiondirnotwritable', 'export', $submissiondir); } else { copy($filepath . $zipfile, $submissiondir . $zipfile); $filepath = $submissiondir; } } $filetitle = ''; if (!empty($row->type)) { switch ($row->type) { case 'all': $filetitle = get_string('allmydata', 'export'); break; default: $filetitle = get_string('exporting' . $row->type, 'export'); } } else { $filetitle = !empty($submitted->name) ? $submitted->name : $submitted->title; } $externalhost = !empty($submitted->submittedhost) ? $submitted->submittedhost : null; db_begin(); // Need to record this in the export_archive table so one can fetch the file via a download link $archiveid = insert_record('export_archive', (object) array('usr' => $row->usr, 'filename' => $zipfile, 'filetitle' => $filetitle, 'filepath' => $filepath, 'submission' => !empty($submitted->submittedtime) ? 1 : 0, 'ctime' => db_format_timestamp(time())), 'id', true); if (!$archiveid) { $errors[] = get_string('exportarchivesavefailed', 'export'); } // If the export row is for a submitted view/collection if (!empty($submitted->submittedtime)) { $inserted = insert_record('archived_submissions', (object) array('archiveid' => $archiveid, 'group' => $submitted->submittedgroup, 'externalhost' => $externalhost, 'externalid' => $row->externalid)); if (!$inserted) { $errors[] = get_string('archivedsubmissionfailed', 'export'); } require_once get_config('docroot') . 'lib/view.php'; if ($submitted->submittedstatus == View::PENDING_RELEASE) { // we are running this export as part of the releasing submission process if ($row->what == 'collections') { require_once get_config('docroot') . 'lib/collection.php'; $id = substr($lastid, strlen('collection_')); $collection = new Collection($id); try { $collection->release($row->submitter); } catch (SystemException $e) { $errors[] = get_string('submissionreleasefailed', 'export'); log_warn($e->getMessage()); } } else { if ($row->what == 'views') { $id = substr($lastid, strlen('view_')); $view = new View($id); try { $view->release($row->submitter); } catch (SystemException $e) { $errors[] = get_string('submissionreleasefailed', 'export'); log_warn($e->getMessage()); } } else { $errors[] = get_string('submissionreleasefailed', 'export'); } } } } else { // Need to send emails with the download link in them - so we add the data to the activity_queue table $arg = display_name($row->usr); $data = (object) array('subject' => false, 'message' => false, 'strings' => (object) array('subject' => (object) array('key' => 'exportdownloademailsubject', 'section' => 'admin', 'args' => array($filetitle)), 'message' => (object) array('key' => 'exportdownloademailmessage', 'section' => 'admin', 'args' => array(hsc($arg), $filetitle)), 'urltext' => (object) array('key' => 'exportdownloadurl', 'section' => 'admin')), 'users' => array($row->usr), 'url' => get_config('webroot') . 'downloadarchive.php?id=' . $archiveid); activity_occurred('maharamessage', $data); } // finally delete the queue item if (!delete_records('export_queue_items', 'exportqueueid', $row->id)) { $errors[] = get_string('deleteexportqueueitems', 'export', $row->id); log_warn('Unable to delete export queue items for ID: ' . $row->id); } if (!delete_records('export_queue', 'id', $row->id)) { $errors[] = get_string('deleteexportqueuerow', 'export', $row->id); log_warn('Unable to delete export queue row ID: ' . $row->id); } // if there are any errors then we need to alert the site and institution admins if (!empty($errors)) { $admins = get_column('usr', 'id', 'admin', 1, 'deleted', 0); $institutions = $user->get('institutions'); if (!empty($institutions)) { foreach ($institutions as $key => $value) { require_once get_config('docroot') . 'lib/institution.php'; $institution = new Institution($key); $admins = array_merge($admins, $institution->admins()); } } $arg = "\n\n -" . implode("\n - ", $errors); $data = (object) array('subject' => false, 'message' => false, 'strings' => (object) array('subject' => (object) array('key' => 'exportqueueerrorsadminsubject', 'section' => 'export'), 'message' => (object) array('key' => 'exportqueueerrorsadminmessage', 'section' => 'export', 'args' => array(hsc($row->id), hsc($arg))), 'urltext' => (object) array('key' => 'exportdownloadurl', 'section' => 'admin')), 'users' => $admins, 'url' => get_config('webroot') . 'admin/users/exportqueue.php'); activity_occurred('maharamessage', $data); db_rollback(); } else { db_commit(); } } return true; }
/** * Deletes a group. * * All group deleting should be done through this function, even though it is * simple. What is required to perform group deletion may change over time. * * @param int $groupid The group to delete * @param string $shortname shortname of the group * @param string $institution institution of the group * * {{@internal Maybe later we can have a group_can_be_deleted function if * necessary}} */ function group_delete($groupid, $shortname = null, $institution = null, $notifymembers = true) { if (empty($groupid) && !empty($institution) && !is_null($shortname) && strlen($shortname)) { // External call to delete a group, check permission of $USER. global $USER; if (!$USER->can_edit_institution($institution)) { throw new AccessDeniedException("group_delete: cannot delete a group in this institution"); } $group = get_record('group', 'shortname', $shortname, 'institution', $institution); } else { $groupid = group_param_groupid($groupid); $group = get_record('group', 'id', $groupid); } db_begin(); // Leave the group_member table alone, it's needed for the deleted // group notification that's about to happen on cron. delete_records('group_member_invite', 'group', $group->id); delete_records('group_member_request', 'group', $group->id); delete_records('view_access', 'group', $group->id); // Delete views owned by the group require_once get_config('libroot') . 'view.php'; foreach (get_column('view', 'id', 'group', $group->id) as $viewid) { $view = new View($viewid); $view->delete(); } // Release views submitted to the group foreach (get_column('view', 'id', 'submittedgroup', $group->id) as $viewid) { $view = new View($viewid); $view->release(); } // Delete artefacts require_once get_config('docroot') . 'artefact/lib.php'; ArtefactType::delete_by_artefacttype(get_column('artefact', 'id', 'group', $group->id)); // Delete forums require_once get_config('docroot') . 'interaction/lib.php'; foreach (get_column('interaction_instance', 'id', 'group', $group->id) as $forumid) { $forum = interaction_instance_from_id($forumid); $forum->delete(); } if ($notifymembers) { require_once 'activity.php'; activity_occurred('groupmessage', array('group' => $group->id, 'deletedgroup' => true, 'strings' => (object) array('subject' => (object) array('key' => 'deletegroupnotificationsubject', 'section' => 'group', 'args' => array(hsc($group->name))), 'message' => (object) array('key' => 'deletegroupnotificationmessage', 'section' => 'group', 'args' => array(hsc($group->name), get_config('sitename')))))); } // make sure the group name + deleted suffix will fit within 128 chars $delete_name = $group->name; if (strlen($delete_name) > 100) { $delete_name = substr($delete_name, 0, 100) . '(...)'; } update_record('group', array('deleted' => 1, 'name' => $delete_name . '.deleted.' . time(), 'shortname' => null, 'institution' => null, 'category' => null, 'urlid' => null), array('id' => $group->id)); db_commit(); }
if ($what == 'collections') { require_once get_config('docroot') . 'lib/collection.php'; $id = substr($lastid, strlen('collection_')); $collection = new Collection($id); try { $collection->release($USER->get('id')); } catch (SystemException $e) { $errors[] = get_string('submissionreleasefailed', 'export'); log_warn($e->getMessage()); } } else { if ($what == 'views') { $id = substr($lastid, strlen('view_')); $view = new View($id); try { $view->release($USER->get('id')); } catch (SystemException $e) { $errors[] = get_string('submissionreleasefailed', 'export'); log_warn($e->getMessage()); } } else { $errors[] = get_string('submissionreleasefailed', 'export'); } } } if (!delete_records('export_queue_items', 'exportqueueid', $rowid)) { log_warn('Unable to delete export queue items for ID: ' . $rowid); db_rollback(); } if (!delete_records('export_queue', 'id', $rowid)) { log_warn('Unable to delete export queue row ID: ' . $rowid);