function bookable_rooms_action()
{
if (!getGlobalPerms($GLOBALS['user']->id) == 'admin') {
$resList = new ResourcesUserRoomsList($GLOBALS['user']->id, false, false, false);
if (!$resList->roomsExist()) {
throw new AccessDeniedException();
}
}
$select_options = Request::optionArray('rooms');
$rooms = array_filter($select_options, function ($v) {
return strlen($v) === 32;
});
$events = array();
$dates = array();
$timestamps = array();
if (count(Request::getArray('new_date'))) {
$new_date = array();
foreach (Request::getArray('new_date') as $one) {
if ($one['name'] == 'startDate') {
$dmy = explode('.', $one['value']);
$new_date['day'] = (int) $dmy[0];
$new_date['month'] = (int) $dmy[1];
$new_date['year'] = (int) $dmy[2];
}
$new_date[$one['name']] = (int) $one['value'];
}
if (check_singledate($new_date['day'], $new_date['month'], $new_date['year'], $new_date['start_stunde'], $new_date['start_minute'], $new_date['end_stunde'], $new_date['end_minute'])) {
$start = mktime($new_date['start_stunde'], $new_date['start_minute'], 0, $new_date['month'], $new_date['day'], $new_date['year']);
$ende = mktime($new_date['end_stunde'], $new_date['end_minute'], 0, $new_date['month'], $new_date['day'], $new_date['year']);
$timestamps[] = $start;
$timestamps[] = $ende;
$event = new AssignEvent('new_date', $start, $ende, null, null, '');
$events[$event->getId()] = $event;
}
}
foreach (Request::optionArray('selected_dates') as $one) {
$date = new SingleDate($one);
if ($date->getStartTime()) {
$timestamps[] = $date->getStartTime();
$timestamps[] = $date->getEndTime();
$event = new AssignEvent($date->getTerminID(), $date->getStartTime(), $date->getEndTime(), null, null, '');
$events[$event->getId()] = $event;
$dates[$date->getTerminID()] = $date;
}
}
if (count($events)) {
$result = array();
$checker = new CheckMultipleOverlaps();
$checker->setTimeRange(min($timestamps), max($timestamps));
foreach ($rooms as $room) {
$checker->addResource($room);
}
$checker->checkOverlap($events, $result, "assign_id");
foreach ((array) $result as $room_id => $details) {
foreach ($details as $termin_id => $conflicts) {
if ($termin_id == 'new_date' && Request::option('singleDateID')) {
$assign_id = SingleDateDB::getAssignID(Request::option('singleDateID'));
} else {
$assign_id = SingleDateDB::getAssignID($termin_id);
}
$filter = function ($a) use($assign_id) {
if ($a['assign_id'] && $a['assign_id'] == $assign_id) {
return false;
}
return true;
};
if (!count(array_filter($conflicts, $filter))) {
unset($result[$room_id][$termin_id]);
}
}
}
$result = array_filter($result);
$this->render_json(array_keys($result));
return;
}
$this->render_nothing();
}
function deleteIssueID($issue_id)
{
$this->readIssueIDs();
unset($this->issues[$issue_id]);
SingleDateDB::deleteIssueID($issue_id, $this->termin_id);
return true;
}
/**
* Deletes the current seminar
*
* @return void returns success-message if seminar could be deleted
* otherwise an error-message
*/
public function delete()
{
$s_id = $this->id;
// Delete that Seminar.
// Alle Benutzer aus dem Seminar rauswerfen.
$query = "DELETE FROM seminar_user WHERE Seminar_id = ?";
$statement = DBManager::get()->prepare($query);
$statement->execute(array($s_id));
if (($db_ar = $statement->rowCount()) > 0) {
$this->createMessage(sprintf(_("%s Teilnehmende und Lehrende archiviert."), $db_ar));
}
// Alle Benutzer aus Wartelisten rauswerfen
$query = "DELETE FROM admission_seminar_user WHERE seminar_id = ?";
$statement = DBManager::get()->prepare($query);
$statement->execute(array($s_id));
// Alle beteiligten Institute rauswerfen
$query = "DELETE FROM seminar_inst WHERE Seminar_id = ?";
$statement = DBManager::get()->prepare($query);
$statement->execute(array($s_id));
if (($db_ar = $statement->rowCount()) > 0) {
$this->createMessage(sprintf(_("%s Zuordnungen zu Einrichtungen archiviert."), $db_ar));
}
// user aus den Statusgruppen rauswerfen
$count = DeleteAllStatusgruppen($s_id);
if ($count > 0) {
$this->createMessage(_("Einträge aus Funktionen / Gruppen gelöscht."));
}
// Alle Eintraege aus dem Vorlesungsverzeichnis rauswerfen
$db_ar = StudipSemTree::DeleteSemEntries(null, $s_id);
if ($db_ar > 0) {
$this->createMessage(sprintf(_("%s Zuordnungen zu Bereichen archiviert."), $db_ar));
}
// Alle Termine mit allem was dranhaengt zu diesem Seminar loeschen.
if (($db_ar = SingleDateDB::deleteAllDates($s_id)) > 0) {
$this->createMessage(sprintf(_("%s Veranstaltungstermine archiviert."), $db_ar));
}
//Themen
IssueDB::deleteAllIssues($s_id);
//Cycles
SeminarCycleDate::deleteBySQL('seminar_id = ' . DBManager::get()->quote($s_id));
// Alle weiteren Postings zu diesem Seminar in den Forums-Modulen löschen
foreach (PluginEngine::getPlugins('ForumModule') as $plugin) {
$plugin->deleteContents($s_id); // delete content irrespective of plugin-activation in the seminar
if ($plugin->isActivated($s_id)) { // only show a message, if the plugin is activated, to not confuse the user
$this->createMessage(sprintf(_('Einträge in %s archiviert.'), $plugin->getPluginName()));
}
}
// Alle Dokumente zu diesem Seminar loeschen.
if (($db_ar = delete_all_documents($s_id)) > 0) {
$this->createMessage(sprintf(_("%s Dokumente und Ordner archiviert."), $db_ar));
}
// Freie Seite zu diesem Seminar löschen
$query = "DELETE FROM scm WHERE range_id = ?";
$statement = DBManager::get()->prepare($query);
$statement->execute(array($s_id));
if (($db_ar = $statement->rowCount()) > 0) {
$this->createMessage(_("Freie Seite der Veranstaltung archiviert."));
}
// delete literatur
$del_lit = StudipLitList::DeleteListsByRange($s_id);
if ($del_lit) {
$this->createMessage(sprintf(_("%s Literaturlisten archiviert."),$del_lit['list']));
}
// Alle News-Verweise auf dieses Seminar löschen
if ( ($db_ar = StudipNews::DeleteNewsRanges($s_id)) ) {
$this->createMessage(sprintf(_("%s Ankündigungen gelöscht."), $db_ar));
}
//delete entry in news_rss_range
StudipNews::UnsetRssId($s_id);
//kill the datafields
DataFieldEntry::removeAll($s_id);
//kill all wiki-pages
$query = "DELETE FROM wiki WHERE range_id = ?";
$statement = DBManager::get()->prepare($query);
$statement->execute(array($s_id));
if (($db_wiki = $statement->rowCount()) > 0) {
$this->createMessage(sprintf(_("%s Wiki-Seiten archiviert."), $db_wiki));
}
$query = "DELETE FROM wiki_links WHERE range_id = ?";
$statement = DBManager::get()->prepare($query);
$statement->execute(array($s_id));
$query = "DELETE FROM wiki_locks WHERE range_id = ?";
$statement = DBManager::get()->prepare($query);
$statement->execute(array($s_id));
// kill all the ressources that are assigned to the Veranstaltung (and all the linked or subordinated stuff!)
if (Config::get()->RESOURCES_ENABLE) {
$killAssign = new DeleteResourcesUser($s_id);
$killAssign->delete();
if ($rr = RoomRequest::existsByCourse($s_id)) {
RoomRequest::find($rr)->delete();
}
}
// kill virtual seminar-entries in calendar
$query = "DELETE FROM schedule_seminare WHERE seminar_id = ?";
$statement = DBManager::get()->prepare($query);
$statement->execute(array($s_id));
if(get_config('ELEARNING_INTERFACE_ENABLE')){
global $connected_cms;
$del_cms = 0;
$cms_types = ObjectConnections::GetConnectedSystems($s_id);
if(count($cms_types)){
foreach($cms_types as $system){
ELearningUtils::loadClass($system);
$del_cms += $connected_cms[$system]->deleteConnectedModules($s_id);
}
$this->createMessage(sprintf(_("%s Verknüpfungen zu externen Systemen gelöscht."), $del_cms ));
}
}
//kill the object_user_vists for this seminar
object_kill_visits(null, $s_id);
// Logging...
$query = "SELECT CONCAT(seminare.VeranstaltungsNummer, ' ', seminare.name, '(', semester_data.name, ')')
FROM seminare
LEFT JOIN semester_data ON (seminare.start_time = semester_data.beginn)
WHERE seminare.Seminar_id='$s_id'";
$statement = DBManager::get()->prepare($query);
$statement->execute(array($s_id));
$semlogname = $statement->fetchColumn() ?: sprintf('unknown sem_id: %s', $s_id);
StudipLog::log("SEM_ARCHIVE",$s_id,NULL,$semlogname);
// ...logged
// delete deputies if necessary
deleteAllDeputies($s_id);
UserDomain::removeUserDomainsForSeminar($s_id);
AutoInsert::deleteSeminar($s_id);
//Anmeldeset Zordnung entfernen
$cs = $this->getCourseSet();
if ($cs) {
CourseSet::removeCourseFromSet($cs->getId(), $this->getId());
$cs->load();
if (!count($cs->getCourses())
&& $cs->isGlobal()
&& $cs->getUserid() != '') {
$cs->delete();
}
}
AdmissionPriority::unsetAllPrioritiesForCourse($this->getId());
// und das Seminar loeschen.
$this->course->delete();
$this->restore();
return true;
}
//wurde Code fuer Anlegen von Ordnern der obersten Ebene ubermittelt (=id+"_a_"),
//wird entsprechende Funktion aufgerufen
if ($open_cmd == 'a') {
$permission = 7;
if ($open_id == $SessSemName[1]) {
$titel=_("Allgemeiner Dateiordner");
$description= sprintf(_("Ablage für allgemeine Ordner und Dokumente der %s"), $SessSemName["art_generic"]);
} else if ($open_id == md5('new_top_folder')){
$titel = Request::get('top_folder_name') ? Request::get('top_folder_name') : _("Neuer Ordner");
$open_id = md5($SessSemName[1] . 'top_folder');
} elseif($titel = GetStatusgruppeName($open_id)) {
$titel = _("Dateiordner der Gruppe:") . ' ' . $titel;
$description = _("Ablage für Ordner und Dokumente dieser Gruppe");
$permission = 15;
} else if ($data = SingleDateDB::restoreSingleDate($open_id)) {
// If we create a folder which has not yet an issue, we just create one
$issue = new Issue(array('seminar_id' => $SessSemName[1]));
$issue->setTitle(_("Ohne Titel"));
$termin = new SingleDate($open_id);
$termin->addIssueID($issue->getIssueID());
$issue->store();
$termin->store();
$open_id = $issue->getIssueID();
$titel = $issue->getTitle();
$description= _("Themenbezogener Dateiordner");
} else {
$query = "SELECT title FROM themen WHERE issue_id = ?";
$statement = DBManager::get()->prepare($query);
$statement->execute(array($open_id));
