MDL-21437 data - checkbox and multimenu fields search working + require all too
[moodle.git] / notes / lib.php
CommitLineData
1d422980 1<?php
83e70cc2 2
3/**
4 * Library of functions and constants for notes
5 */
6
7/**
8 * Constants for states.
9 */
10define('NOTES_STATE_DRAFT', 'draft');
11define('NOTES_STATE_PUBLIC', 'public');
12define('NOTES_STATE_SITE', 'site');
13
14/**
15 * Constants for note parts (flags used by note_print and note_print_list).
16 */
17define('NOTES_SHOW_FULL', 0x07);
18define('NOTES_SHOW_HEAD', 0x02);
19define('NOTES_SHOW_BODY', 0x01);
20define('NOTES_SHOW_FOOT', 0x04);
21
22/**
23 * Retrieves a list of note objects with specific atributes.
24 *
25 * @param int $courseid id of the course in which the notes were posted (0 means any)
26 * @param int $userid id of the user to which the notes refer (0 means any)
27 * @param string $state state of the notes (i.e. draft, public, site) ('' means any)
28 * @param int $author id of the user who modified the note last time (0 means any)
29 * @param string $order an order to sort the results in
30 * @param int $limitfrom number of records to skip (offset)
31 * @param int $limitnum number of records to fetch
32 * @return array of note objects
33 */
34function note_list($courseid=0, $userid=0, $state = '', $author = 0, $order='lastmodified DESC', $limitfrom=0, $limitnum=0) {
b3829d0a 35 global $DB;
36
83e70cc2 37 // setup filters
db4ff7f8 38 $selects = array();
b3829d0a 39 $params = array();
40 if ($courseid) {
41 $selects[] = 'courseid=?';
42 $params[] = $courseid;
83e70cc2 43 }
b3829d0a 44 if ($userid) {
45 $selects[] = 'userid=?';
46 $params[] = $userid;
83e70cc2 47 }
b3829d0a 48 if ($author) {
49 $selects[] = 'usermodified=?';
50 $params[] = $author;
83e70cc2 51 }
b3829d0a 52 if ($state) {
53 $selects[] = 'publishstate=?';
54 $params[] = $state;
83e70cc2 55 }
b3829d0a 56 $selects[] = "module=?";
57 $params[] = 'notes';
58
83e70cc2 59 $select = implode(' AND ', $selects);
60 $fields = 'id,courseid,userid,content,format,created,lastmodified,usermodified,publishstate';
61 // retrieve data
b3829d0a 62 return $DB->get_records_select('post', $select, $params, $order, $fields, $limitfrom, $limitnum);
83e70cc2 63}
64
65/**
66 * Retrieves a note object based on its id.
67 *
68 * @param int $note_id id of the note to retrieve
69 * @return note object
70 */
71function note_load($note_id) {
b3829d0a 72 global $DB;
73
83e70cc2 74 $fields = 'id,courseid,userid,content,format,created,lastmodified,usermodified,publishstate';
b3829d0a 75 return $DB->get_record('post', array('id'=>$note_id, 'module'=>'notes'), $fields);
83e70cc2 76}
77
78/**
1519cdeb 79 * Saves a note object. The note object is passed by reference and its fields (i.e. id)
83e70cc2 80 * might change during the save.
81 *
82 * @param note $note object to save
83 * @return boolean true if the object was saved; false otherwise
84 */
85function note_save(&$note) {
b3829d0a 86 global $USER, $DB;
87
83e70cc2 88 // setup & clean fields
b3829d0a 89 $note->module = 'notes';
83e70cc2 90 $note->lastmodified = time();
91 $note->usermodified = $USER->id;
241bcec5 92 if (empty($note->format)) {
83e70cc2 93 $note->format = FORMAT_PLAIN;
94 }
241bcec5 95 if (empty($note->publishstate)) {
83e70cc2 96 $note->publishstate = NOTES_STATE_PUBLIC;
97 }
98 // save data
241bcec5 99 if (empty($note->id)) {
83e70cc2 100 // insert new note
101 $note->created = $note->lastmodified;
a9637e7d
PS
102 $id = $DB->insert_record('post', $note);
103 $note = $DB->get_record('post', array('id'=>$id));
83e70cc2 104 } else {
105 // update old note
a9637e7d 106 $DB->update_record('post', $note);
83e70cc2 107 }
108 unset($note->module);
a9637e7d 109 return true;
83e70cc2 110}
111
112/**
113 * Deletes a note object based on its id.
114 *
115 * @param int $note_id id of the note to delete
116 * @return boolean true if the object was deleted; false otherwise
117 */
118function note_delete($noteid) {
b3829d0a 119 global $DB;
120
121 return $DB->delete_records('post', array('id'=>$noteid, 'module'=>'notes'));
83e70cc2 122}
123
124/**
125 * Converts a state value to its corespondent name
126 *
127 * @param string $state state value to convert
128 * @return string corespondent state name
129 */
130function note_get_state_name($state) {
131 // cache state names
132 static $states;
133 if (empty($states)) {
134 $states = note_get_state_names();
135 }
b3829d0a 136 if (isset($states[$state])) {
137 return $states[$state];
138 } else {
139 return null;
140 }
83e70cc2 141}
142
143/**
144 * Returns an array of mappings from state values to state names
145 *
146 * @return array of mappings
147 */
148function note_get_state_names() {
149 return array(
150 NOTES_STATE_DRAFT => get_string('personal', 'notes'),
151 NOTES_STATE_PUBLIC => get_string('course', 'notes'),
152 NOTES_STATE_SITE => get_string('site', 'notes'),
153 );
154}
155
156/**
157 * Prints a note object
158 *
159 * @param note $note the note object to print
160 * @param int $detail OR-ed NOTES_SHOW_xyz flags that specify which note parts to print
161 */
162function note_print($note, $detail = NOTES_SHOW_FULL) {
4fa7dc61 163 global $CFG, $USER, $DB, $OUTPUT;
83e70cc2 164
b3829d0a 165 if (!$user = $DB->get_record('user', array('id'=>$note->userid))) {
807188eb 166 debugging("User $note->userid not found");
167 return;
168 }
b3829d0a 169 if (!$author = $DB->get_record('user', array('id'=>$note->usermodified))) {
807188eb 170 debugging("User $note->usermodified not found");
171 return;
172 }
83e70cc2 173 $context = get_context_instance(CONTEXT_COURSE, $note->courseid);
241bcec5 174 $systemcontext = get_context_instance(CONTEXT_SYSTEM);
807188eb 175
6d63fb5c 176 $authoring = new stdClass();
807188eb 177 $authoring->name = '<a href="'.$CFG->wwwroot.'/user/view.php?id='.$author->id.'&amp;course='.$note->courseid.'">'.fullname($author).'</a>';
83e70cc2 178 $authoring->date = userdate($note->lastmodified);
807188eb 179
1519cdeb 180 echo '<div class="notepost '. $note->publishstate . 'notepost' .
83e70cc2 181 ($note->usermodified == $USER->id ? ' ownnotepost' : '') .
182 '" id="note-'. $note->id .'">';
183
184 // print note head (e.g. author, user refering to, etc)
241bcec5 185 if ($detail & NOTES_SHOW_HEAD) {
83e70cc2 186 echo '<div class="header">';
187 echo '<div class="user">';
812dbaf7 188 echo $OUTPUT->user_picture($user, array('courseid'=>$note->courseid));
83e70cc2 189 echo fullname($user) . '</div>';
1519cdeb 190 echo '<div class="info">' .
191 get_string('bynameondate', 'notes', $authoring) .
83e70cc2 192 ' (' . get_string('created', 'notes') . ': ' . userdate($note->created) . ')</div>';
193 echo '</div>';
194 }
1519cdeb 195
83e70cc2 196 // print note content
241bcec5 197 if ($detail & NOTES_SHOW_BODY) {
83e70cc2 198 echo '<div class="content">';
367a75fa 199 echo format_text($note->content, $note->format, array('overflowdiv'=>true));
83e70cc2 200 echo '</div>';
201 }
1519cdeb 202
83e70cc2 203 // print note options (e.g. delete, edit)
241bcec5 204 if ($detail & NOTES_SHOW_FOOT) {
205 if (has_capability('moodle/notes:manage', $systemcontext) && $note->publishstate == NOTES_STATE_SITE ||
83e70cc2 206 has_capability('moodle/notes:manage', $context) && ($note->publishstate == NOTES_STATE_PUBLIC || $note->usermodified == $USER->id)) {
207 echo '<div class="footer"><p>';
241bcec5 208 echo '<a href="'.$CFG->wwwroot.'/notes/edit.php?id='.$note->id. '">'. get_string('edit') .'</a> | ';
209 echo '<a href="'.$CFG->wwwroot.'/notes/delete.php?id='.$note->id. '">'. get_string('delete') .'</a>';
83e70cc2 210 echo '</p></div>';
211 }
212 }
213 echo '</div>';
214}
215
216/**
217 * Prints a list of note objects
218 *
219 * @param array $notes array of note objects to print
220 * @param int $detail OR-ed NOTES_SHOW_xyz flags that specify which note parts to print
221 */
222function note_print_list($notes, $detail = NOTES_SHOW_FULL) {
223
224 /// Start printing of the note
225 echo '<div class="notelist">';
226 foreach ($notes as $note) {
227 note_print($note, $detail);
228 }
229 echo '</div>';
230}
231
232/**
233 * Retrieves and prints a list of note objects with specific atributes.
234 *
235 * @param string $header HTML to print above the list
236 * @param int $addcourseid id of the course for the add notes link (0 hide link)
237 * @param boolean $viewnotes true if the notes should be printed; false otherwise (print notesnotvisible string)
238 * @param int $courseid id of the course in which the notes were posted (0 means any)
239 * @param int $userid id of the user to which the notes refer (0 means any)
240 * @param string $state state of the notes (i.e. draft, public, site) ('' means any)
241 * @param int $author id of the user who modified the note last time (0 means any)
242 */
b3829d0a 243function note_print_notes($header, $addcourseid = 0, $viewnotes = true, $courseid = 0, $userid = 0, $state = '', $author = 0) {
83e70cc2 244 global $CFG;
b3829d0a 245
83e70cc2 246 if ($header) {
247 echo '<h3 class="notestitle">' . $header . '</h3>';
248 echo '<div class="notesgroup">';
249 }
250 if ($addcourseid) {
9f26cce6 251 if ($userid) {
241bcec5 252 echo '<p><a href="'. $CFG->wwwroot .'/notes/edit.php?courseid=' . $addcourseid . '&amp;userid=' . $userid . '&amp;publishstate=' . $state . '">' . get_string('addnewnote', 'notes') . '</a></p>';
9f26cce6 253 } else {
254 echo '<p><a href="'. $CFG->wwwroot .'/user/index.php?id=' . $addcourseid. '">' . get_string('addnewnoteselect', 'notes') . '</a></p>';
255 }
83e70cc2 256 }
257 if ($viewnotes) {
b3829d0a 258 $notes = note_list($courseid, $userid, $state, $author);
83e70cc2 259 if ($notes) {
260 note_print_list($notes);
261 }
262 } else {
263 echo '<p>' . get_string('notesnotvisible', 'notes') . '</p>';
264 }
265 if ($header) {
266 echo '</div>'; // notesgroup
267 }
268}
269
0b5a80a1 270/**
271 * Delete all notes about users in course-
272 * @param int $courseid
273 * @return bool success
274 */
275function note_delete_all($courseid) {
b3829d0a 276 global $DB;
277
278 return $DB->delete_records('post', array('module'=>'notes', 'courseid'=>$courseid));
0b5a80a1 279}