/** * Update existing event and logs the action * @param int $eventid id in table personal_calendar * @param string $title event title * @param string $start event datetime * @param text $content event details * @param boolean $recursivelly specifies if the update should be applied to all events of the group of recursive events or to the specific one */ function update_event($eventid, $title, $start, $duration, $content, $recursion, $recursivelly = false){ global $uid, $langNotValidInput, $course_id; if (!preg_match('/[0-9]+(:[0-9]+){0,2}/', $duration)) { $duration = '0:00'; } if($recursivelly && !is_null($recursion)){ $oldrec = get_event_recursion($eventid, $course_id); $p = "P".$recursion['repeat'].$recursion['unit']; $e = DateTime::createFromFormat('d-m-Y', $recursion['end'])->format('Y-m-d'); if($oldrec->recursion_period != $p || $oldrec->recursion_end != $e){ delete_recursive_event($eventid); return add_event($title, $content, $start, $duration, $recursion); } } if(!is_null($recursion) && !is_recursive($eventid)) { delete_event($eventid); return add_event($title, $content, $start, $duration, $recursion); } $d1 = DateTime::createFromFormat('d-m-Y H:i', $start); $d2 = DateTime::createFromFormat('d-m-Y H:i:s', $start); $title = trim($title); if(empty($title) || !(($d1 && $d1->format('d-m-Y H:i') == $start) || ($d2 && $d2->format('d-m-Y H:i:s') == $start))) { return array('success'=>false, 'message'=>$langNotValidInput); } else { $start = $d1->format('Y-m-d H:i'); } $where_clause = ($recursivelly)? "WHERE source_event_id = ?d AND course_id = ?d":"WHERE id = ?d AND course_id = ?d"; $startdatetimeformatted = ($recursivelly)? $d1->format('H:i'):$d1->format('Y-m-d H:i'); $start_date_update_clause = ($recursivelly)? "start = CONCAT(date_format(start, '%Y-%m-%d '),?t), ":"start = ?t, "; Database::get()->query("UPDATE agenda SET " . "title = ?s, " . $start_date_update_clause . "duration = ?t, " . "content = ?s " . $where_clause, $title, $startdatetimeformatted, $duration, purify($content), $eventid, $course_id); Log::record($course_id, MODULE_ID_AGENDA, LOG_MODIFY, array('user_id' => $uid, 'id' => $eventid, 'title' => $title, 'recursivelly' => $recursivelly, 'content' => ellipsize_html(canonicalize_whitespace(strip_tags($content)), 50, '+'))); return array('success'=>true, 'message'=>'', 'event'=>$eventid); }
} $agdx->store($id); } else { // add new event $recursion = null; if (!empty($_POST['frequencyperiod']) && intval($_POST['frequencynumber']) > 0 && !empty($_POST['enddate'])) { $recursion = array('unit' => $_POST['frequencyperiod'], 'repeat' => $_POST['frequencynumber'], 'end' => $_POST['enddate']); } $ev = add_event($event_title, $content, $startdate, $duration, $recursion); foreach($ev['event'] as $id) { $agdx->store($id); } } Session::Messages($langStoredOK, 'alert-success'); redirect_to_home_page("modules/agenda/index.php?course=$course_code"); } elseif (isset($_GET['delete']) && $_GET['delete'] == 'yes') { $resp = (isset($_GET['rep']) && $_GET['rep'] == 'yes')? delete_recursive_event($id):delete_event($id); $agdx->remove($id); $msgresp = ($resp['success'])? $langDeleteOK : $langDeleteError.": ".$resp['message']; $alerttype = ($resp['success'])? 'alert-success' : 'alert-error'; Session::Messages($msgresp, $alerttype); redirect_to_home_page("modules/agenda/index.php?course=$course_code"); } $is_recursive_event = false; if (isset($_GET['addEvent']) or isset($_GET['edit'])) { $pageName = $langAddEvent; $tool_content .= action_bar(array( array('title' => $langBack, 'url' => "$_SERVER[SCRIPT_NAME]?course=$course_code", 'icon' => 'fa-reply',