/**
* 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',
