/**
* Update existing note and logs the action
* @param int $noteid id in table note
* @param string $title note title
* @param text $content note body
* @param string $reference_obj_id refernced object by note. It contains the object type (from $ref_object_types) and object id (id in the corresponding db table), e.g., video_link:5
*/
public static function update_note($noteid, $title, $content, $reference_obj_id = NULL){
global $uid;
$refobjinfo = References::get_ref_obj_field_values($reference_obj_id);
Database::get()->query("UPDATE note SET title = ?s, content = ?s, reference_obj_module = ?d, reference_obj_type = ?s, reference_obj_id = ?d, reference_obj_course = ?d WHERE id = ?d", $title, purify($content), $refobjinfo['objmodule'], $refobjinfo['objtype'], $refobjinfo['objid'], $refobjinfo['objcourse'], $noteid);
Indexer::queueAsync(Indexer::REQUEST_STORE, Indexer::RESOURCE_NOTE, $noteid);
Log::record(0, MODULE_ID_NOTES, LOG_MODIFY, array('user_id' => $uid, 'id' => $noteid,
'title' => $title,
'content' => ellipsize_html(canonicalize_whitespace(strip_tags($content)), 50, '+')));
}
/**
* 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
* @param string $reference_obj_id refernced object by note. It contains the object type (from $ref_object_types) and object id (id in the corresponding db table), e.g., video_link:5
*/
public static function update_event($eventid, $title, $start, $duration, $content, $recursivelly = false, $reference_obj_id = NULL)
{
global $uid, $langNotValidInput;
$refobjinfo = References::get_ref_obj_field_values($reference_obj_id);
$d1 = DateTime::createFromFormat('Y-m-d H:i', $start);
$d2 = DateTime::createFromFormat('Y-m-d H:i:s', $start);
$title = trim($title);
if (empty($title) || !($d1 && $d1->format('Y-m-d H:i') == $start || $d2 && $d2->format('Y-m-d H:i:s') == $start)) {
return array('success' => false, 'message' => $langNotValidInput);
}
$where_clause = $recursivelly ? "WHERE source_event_id = ?d" : "WHERE id = ?d";
Database::get()->query("UPDATE personal_calendar SET " . "title = ?s, " . "start = ?t, " . "duration = ?t, " . "content = ?s, " . "reference_obj_module = ?d, " . "reference_obj_type = ?s, " . "reference_obj_id = ?d, " . "reference_obj_course = ?d " . $where_clause, $title, $start, $duration, purify($content), $refobjinfo['objmodule'], $refobjinfo['objtype'], $refobjinfo['objid'], $refobjinfo['objcourse'], $eventid);
Log::record(0, MODULE_ID_PERSONALCALENDAR, LOG_MODIFY, array('user_id' => $uid, 'id' => $eventid, 'title' => $title, 'content' => ellipsize_html(canonicalize_whitespace(strip_tags($content)), 50, '+')));
return array('success' => true, 'message' => '', 'event' => $eventid);
}
/**
* 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
* @param string $reference_obj_id refernced object by note. It contains the object type (from $ref_object_types) and object id (id in the corresponding db table), e.g., video_link:5
*/
public static function update_event($eventid, $title, $start, $duration, $content, $recursivelly = false, $recursion = NULL, $reference_obj_id = NULL) {
global $uid, $langNotValidInput;
if($recursivelly && !is_null($recursion)){
$oldrec = Calendar_Events::get_event_recursion($eventid, 'personal');
$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){
Calendar_Events::delete_recursive_event($eventid, 'personal');
return Calendar_Events::add_event($title, $content, $start, $duration, $recursion, $reference_obj_id);
}
}
if(!is_null($recursion) && !Calendar_Events::is_recursive($eventid, 'personal')){
Calendar_Events::delete_event($eventid, 'personal');
return Calendar_Events::add_event($title, $content, $start, $duration, $recursion, $reference_obj_id);
}
$refobjinfo = References::get_ref_obj_field_values($reference_obj_id);
$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);
}
$where_clause = ($recursivelly)? "WHERE source_event_id = ?d":"WHERE 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 personal_calendar SET "
. "title = ?s, "
. $start_date_update_clause
. "duration = ?t, "
. "content = ?s, "
. "reference_obj_module = ?d, "
. "reference_obj_type = ?s, "
. "reference_obj_id = ?d, "
. "reference_obj_course = ?d "
. $where_clause,
$title, $startdatetimeformatted, $duration, purify($content), $refobjinfo['objmodule'], $refobjinfo['objtype'], $refobjinfo['objid'], $refobjinfo['objcourse'], $eventid);
Log::record(0, MODULE_ID_PERSONALCALENDAR, LOG_MODIFY, array('user_id' => $uid, 'id' => $eventid,
'title' => $title,
'content' => ellipsize_html(canonicalize_whitespace(strip_tags($content)), 50, '+')));
return array('success' => true, 'message' => '', 'event' => $eventid);
}
