, move code of main/notebook up here * @package chamilo.library */ class NotebookManager { /** * Constructor */ public function __construct() { } /** * a little bit of javascript to display a prettier warning when deleting a note * * @return string * * @author Patrick Cool , Ghent University, Belgium * @version januari 2009, dokeos 1.8.6 */ public static function javascript_notebook() { return ""; } /** * This functions stores the note in the database * * @param array $values * @param int $userId Optional. The user ID * @param int $courseId Optional. The course ID * @param int $sessionId Optional. The session ID * @return bool * @author Christian Fasanando * @author Patrick Cool , Ghent University, Belgium * @version januari 2009, dokeos 1.8.6 */ public static function save_note($values, $userId = 0, $courseId = 0, $sessionId = 0) { if (!is_array($values) || empty($values['note_title'])) { return false; } // Database table definition $table = Database::get_course_table(TABLE_NOTEBOOK); $userId = $userId ?: api_get_user_id(); $courseId = $courseId ?: api_get_course_int_id(); $courseInfo = api_get_course_info_by_id($courseId); $courseCode = $courseInfo['code']; $sessionId = $sessionId ?: api_get_session_id(); $now = api_get_utc_datetime(); $params = [ 'notebook_id' => 0, 'c_id' => $courseId, 'user_id' => $userId, 'course' => $courseCode, 'session_id' => $sessionId, 'title' => $values['note_title'], 'description' => $values['note_comment'], 'creation_date' => $now, 'update_date' => $now, 'status' => 0 ]; $id = Database::insert($table, $params); if ($id > 0) { $sql = "UPDATE $table SET notebook_id = $id WHERE iid = $id"; Database::query($sql); //insert into item_property api_item_property_update( $courseInfo, TOOL_NOTEBOOK, $id, 'NotebookAdded', $userId ); return $id; } } /** * @param int $notebook_id * @return array|mixed */ public static function get_note_information($notebook_id) { if (empty($notebook_id)) { return array(); } // Database table definition $t_notebook = Database::get_course_table(TABLE_NOTEBOOK); $course_id = api_get_course_int_id(); $sql = "SELECT notebook_id AS notebook_id, title AS note_title, description AS note_comment, session_id AS session_id FROM $t_notebook WHERE c_id = $course_id AND notebook_id = '".intval($notebook_id)."' "; $result = Database::query($sql); if (Database::num_rows($result) != 1) { return array(); } return Database::fetch_array($result); } /** * This functions updates the note in the database * * @param array $values * * @author Christian Fasanando * @author Patrick Cool , Ghent University, Belgium * @version januari 2009, dokeos 1.8.6 */ public static function update_note($values) { if (!is_array($values) or empty($values['note_title'])) { return false; } // Database table definition $table = Database::get_course_table(TABLE_NOTEBOOK); $course_id = api_get_course_int_id(); $sessionId = api_get_session_id(); $params = [ 'user_id' => api_get_user_id(), 'course' => api_get_course_id(), 'session_id' => $sessionId, 'title' => $values['note_title'], 'description' => $values['note_comment'], 'update_date' => api_get_utc_datetime() ]; Database::update( $table, $params, [ 'c_id = ? AND notebook_id = ?' => [ $course_id, $values['notebook_id'] ], ] ); // update item_property (update) api_item_property_update( api_get_course_info(), TOOL_NOTEBOOK, $values['notebook_id'], 'NotebookUpdated', api_get_user_id() ); return true; } /** * @param int $notebook_id * @return bool */ public static function delete_note($notebook_id) { if (empty($notebook_id) || $notebook_id != strval(intval($notebook_id))) { return false; } // Database table definition $t_notebook = Database::get_course_table(TABLE_NOTEBOOK); $course_id = api_get_course_int_id(); $sql = "DELETE FROM $t_notebook WHERE c_id = $course_id AND notebook_id='".intval($notebook_id)."' AND user_id = '" . api_get_user_id()."'"; $result = Database::query($sql); $affected_rows = Database::affected_rows($result); if ($affected_rows != 1) { return false; } //update item_property (delete) api_item_property_update( api_get_course_info(), TOOL_NOTEBOOK, intval($notebook_id), 'delete', api_get_user_id() ); return true; } /** * Display notes */ public static function display_notes() { $_user = api_get_user_info(); if (!isset($_GET['direction'])) { $sort_direction = 'ASC'; $link_sort_direction = 'DESC'; } elseif ($_GET['direction'] == 'ASC') { $sort_direction = 'ASC'; $link_sort_direction = 'DESC'; } else { $sort_direction = 'DESC'; $link_sort_direction = 'ASC'; } // action links echo '

'; if (!api_is_anonymous()) { if (api_get_session_id() == 0) { echo ''. Display::return_icon( 'new_note.png', get_lang('NoteAddNew'), '', '32' ).''; } elseif (api_is_allowed_to_session_edit(false, true)) { echo ''. Display::return_icon('new_note.png', get_lang('NoteAddNew'), '', '32').''; } } else { echo ''. Display::return_icon('new_note.png', get_lang('NoteAddNew'), '', '32').''; } echo ''. Display::return_icon('notes_order_by_date_new.png', get_lang('OrderByCreationDate'), '', '32').''; echo ''. Display::return_icon('notes_order_by_date_mod.png', get_lang('OrderByModificationDate'), '', '32').''; echo ''. Display::return_icon('notes_order_by_title.png', get_lang('OrderByTitle'), '', '32').''; echo '

'; if (!isset($_SESSION['notebook_view']) || !in_array($_SESSION['notebook_view'], array('creation_date', 'update_date', 'title')) ) { $_SESSION['notebook_view'] = 'creation_date'; } // Database table definition $t_notebook = Database::get_course_table(TABLE_NOTEBOOK); if ($_SESSION['notebook_view'] == 'creation_date' || $_SESSION['notebook_view'] == 'update_date') { $order_by = " ORDER BY ".$_SESSION['notebook_view']." $sort_direction "; } else { $order_by = " ORDER BY ".$_SESSION['notebook_view']." $sort_direction "; } //condition for the session $session_id = api_get_session_id(); $condition_session = api_get_session_condition($session_id); $cond_extra = ($_SESSION['notebook_view'] == 'update_date') ? " AND update_date <> ''" : " "; $course_id = api_get_course_int_id(); $sql = "SELECT * FROM $t_notebook WHERE c_id = $course_id AND user_id = '".api_get_user_id()."' $condition_session $cond_extra $order_by "; $result = Database::query($sql); while ($row = Database::fetch_array($result)) { // Validation when belongs to a session $session_img = api_get_session_image($row['session_id'], $_user['status']); $updateValue = ''; if ($row['update_date'] <> $row['creation_date']) { $updateValue = ', '.get_lang('UpdateDate').': '.Display::dateToStringAgoAndLongDate($row['update_date']); } $actions = ''. Display::return_icon('edit.png', get_lang('Edit'), '', ICON_SIZE_SMALL).''; $actions .= ''. Display::return_icon('delete.png', get_lang('Delete'), '', ICON_SIZE_SMALL).''; echo Display::panel( $row['description'], $row['title'].$session_img.'

'.$actions.'

', get_lang('CreationDate').': '.Display::dateToStringAgoAndLongDate($row['creation_date']).$updateValue ); } } }