/**
* Save Single Date
* @throws Trails_DoubleRenderError
*/
public function saveSingleDate_action()
{
CSRFProtection::verifyRequest();
$start_time = strtotime(sprintf('%s %s:00', Request::get('date'), Request::get('start_time')));
$end_time = strtotime(sprintf('%s %s:00', Request::get('date'), Request::get('end_time')));
if ($start_time > $end_time) {
$this->storeRequest();
PageLayout::postMessage(MessageBox::error(_('Die Zeitangaben sind nicht korrekt. Bitte überprüfen Sie diese!')));
$this->redirect('course/timesrooms/createSingleDate');
return;
}
$termin = new CourseDate();
$termin->termin_id = $termin->getNewId();
$termin->range_id = $this->course->id;
$termin->date = $start_time;
$termin->end_time = $end_time;
$termin->autor_id = $GLOBALS['user']->id;
$termin->date_typ = Request::get('dateType');
$teachers = $this->course->getMembers('dozent');
foreach (Request::getArray('related_teachers') as $dozent_id) {
if (in_array($dozent_id, array_keys($teachers))) {
$related_persons[] = User::find($dozent_id);
}
}
if (isset($related_persons)) {
$termin->dozenten = $related_persons;
}
foreach (Request::getArray('related_statusgruppen') as $statusgruppe_id) {
$related_groups[] = Statusgruppen::find($statusgruppe_id);
}
if (isset($related_groups)) {
$termin->statusgruppen = $related_groups;
}
if (!Request::get('room') || Request::get('room') === 'nothing') {
$termin->raum = Request::get('freeRoomText');
$termin->store();
} else {
$termin->store();
$room = new ResourceAssignment();
$room->assign_user_id = $termin->termin_id;
$room->resource_id = Request::get('room');
$room->begin = $termin->date;
$room->end = $termin->end_time;
$room->repeat_end = $termin->end_time;
if (!$room->store()) {
$termin->delete();
}
}
if ($start_time < $this->course->filterStart || $end_time > $this->course->filterEnd) {
$this->course->setFilter('all');
}
$this->course->createMessage(sprintf(_('Der Termin %s wurde hinzugefügt!'), $termin->getFullname()));
$this->course->store();
$this->displayMessages();
if (Request::get('fromDialog') == 'true') {
$this->redirect('course/timesrooms/index');
} else {
$this->relocate('course/timesrooms/index');
}
}
/**
* Import and update the dates
*/
public function afterUpdate(SimpleORMap $object, $line)
{
$weekdays = array('so' => 0, 'su' => 0, 'mo' => 1, 'di' => 2, 'die' => 2, 'tue' => 2, 'mi' => 3, 'we' => 3, 'do' => 4, 'thu' => 4, 'fr' => 5, 'fri' => 5, 'sa' => 6);
$zeiten = $line['zeit'];
$zeiten = preg_split("/\\s*,\\s*/", $zeiten, null, PREG_SPLIT_NO_EMPTY);
$singledates = array();
$metadates = array();
$import_type_dates = "karlsruhe_coursedates_import_" . $object->getId();
$import_type_metadates = "karlsruhe_coursemetadates_import_" . $object->getId();
foreach ($zeiten as $zeit) {
if (!is_numeric(trim($zeit[0]))) {
preg_match("/(\\w+) (\\d+):(\\d+)\\s*-\\s*(\\d+):(\\d+)/", $zeit, $matches);
$day = strtolower($matches[1]);
if (isset($weekdays[$day])) {
$statement = DBManager::get()->prepare("\n SELECT metadate_id \n FROM seminar_cycle_dates \n WHERE seminar_id = :course_id\n AND start_time = :start_time\n AND end_time = :end_time\n AND weekday = :weekday\n ");
$statement->execute(array('course_id' => $object->getId(), 'start_time' => $matches[2] . ":" . $matches[3] . ":00", 'end_time' => $matches[4] . ":" . $matches[5] . ":00", 'weekday' => $weekdays[$day]));
$found = false;
foreach ($statement->fetchAll(PDO::FETCH_COLUMN) as $cycle_id) {
if (FleximportMappedItem::findbyItemId($cycle_id, $import_type_metadates)) {
$found = $cycle_id;
break;
}
}
if (!$found) {
/*$semester = $object->end_semester;
$cycle = new SeminarCycleDate(); //Does not work yet
$cycle['seminar_id'] = $object->getId();
$cycle->start_hour = $matches[2];
$cycle->start_minute = $matches[3];
$cycle->end_hour = $matches[4];
$cycle->end_minute = $matches[5];
$cycle['weekday'] = $weekdays[$day];
$cycle['week_offset'] = 0;
$cycle['end_offset'] = floor(($semester->ende - $semester->beginn) / (7*24*60*60)) - 2;
$cycle['cycle'] = 0; //wöchentlich
$cycle->store();
$cycle_id = $cycle->getId();*/
$seminar = new Seminar($object->getId());
$cycle_id = $seminar->addCycle(array('day' => $weekdays[$day], 'start_stunde' => $matches[2], 'start_minute' => $matches[3], 'end_stunde' => $matches[4], 'end_minute' => $matches[5], 'week_offset' => 0, 'startWeek' => 0, 'turnus' => 0));
$mapped = new FleximportMappedItem();
$mapped['table_id'] = $import_type_metadates;
$mapped['item_id'] = $cycle_id;
$mapped->store();
$metadates[] = $cycle_id;
} else {
$seminar = new Seminar($object->getId());
$seminar->editCycle(array('cycle_id' => $found, 'day' => $weekdays[$day], 'start_stunde' => $matches[2], 'start_minute' => $matches[3], 'end_stunde' => $matches[4], 'end_minute' => $matches[5], 'week_offset' => 0, 'startWeek' => 0, 'turnus' => 0));
/*$semester = $object->end_semester;
$cycle = new SeminarCycleDate($found);
$cycle['seminar_id'] = $object->getId();
$cycle->start_hour = $matches[2];
$cycle->start_minute = $matches[3];
$cycle->end_hour = $matches[4];
$cycle->end_minute = $matches[5];
$cycle['weekday'] = $weekdays[$day];
$cycle['cycle'] = 0; //wöchentlich
$cycle['week_offset'] = 0;
$cycle['end_offset'] = floor(($semester->ende - $semester->beginn) / (7*24*60*60)) - 2;
$cycle->store();*/
$metadates[] = $found;
}
}
} else {
//$zeit = explode("-", $zeit);
preg_match("/(\\d{4}-\\d{1,2}-\\d{1,2}\\s+\\d{1,2}:\\d{1,2})\\s*-\\s(\\d{4}-\\d{1,2}-\\d{1,2}\\s+\\d{1,2}:\\d{1,2})/", $zeit, $matches);
$begin = strtotime($matches[1]);
$end = strtotime($matches[2]);
$found = false;
$dates = CourseDate::findBySQL("range_id = :course_id AND date = :begin AND end_time = :end", array('course_id' => $object->getId(), 'begin' => $begin, 'end' => $end));
foreach ($dates as $date) {
if (FleximportMappedItem::findbyItemId($date->getId(), $import_type_dates)) {
$found = true;
$singledates[] = $date->getId();
break;
}
}
if (!$found) {
$date = new CourseDate();
$date['range_id'] = $object->getId();
$date['date'] = $begin;
$date['end_time'] = $end;
$date->store();
$mapped = new FleximportMappedItem();
$mapped['table_id'] = $import_type_dates;
$mapped['item_id'] = $date->getId();
$mapped->store();
$singledates[] = $date->getId();
}
}
}
$items = FleximportMappedItem::findBySQL("table_id = :table_id AND item_id NOT IN (:ids)", array('table_id' => $import_type_dates, 'ids' => $singledates ?: ""));
foreach ($items as $item) {
$date = new CourseDate($item['item_id']);
$date->delete();
$item->delete();
}
$items = FleximportMappedItem::findBySQL("table_id = :table_id AND item_id NOT IN (:ids)", array('table_id' => $import_type_metadates, 'ids' => $metadates ?: ""));
foreach ($items as $item) {
$cycle = new SeminarCycleDate($item['item_id']);
$cycle->delete();
}
}
