Lines Matching refs:tasks
38 * Delete the all tasks from a given page id
47 $this->db->query('DELETE FROM tasks WHERE page = ?', $id);
66 'INSERT INTO tasks (page,md5,date,text,creator,pos)
87 * Load all tasks with given filters.
92 * - status can be done or undone to filter for (un)completed tasks
94 * - user all tasks to a given user
212 FROM tasks A LEFT JOIN task_status B
242 * Toggles a tasks status.
245 * @param string $md5 tasks md5 hash
270 FROM tasks A LEFT JOIN task_status B
318 * Notify assignees or creators of new tasks and status changes
411 FROM tasks A
423 * Get information about the number of tasks on a specific id.
426 * count - number of all tasks
427 * done - number of all finished tasks
428 * undone - number of all tasks to do
441 $tasks = array();
444 $tasks = $this->loadTasks(array('id' => $id), $checkAccess = false);
448 'count' => count($tasks),
454 foreach ($tasks as $task) {
485 if ($count['undone'] == 0) { // all tasks done
488 } elseif ($count['late'] == 0) { // open tasks - no late
491 } else { // late tasks
507 * Get the html for an icon showing the user's open tasks
509 * If the user has open tasks, a js-overlay is shown on click.
520 $tasks = $this->loadTasks(array('status' => array('undone'), 'user' => $user));
521 $num = count($tasks);
525 $doInner = '<span class="a11y">' . $this->getLang('prefix_tasks_user') . " </span>$svg<span class=\"num\">" . count($tasks) . '</span>';