getNextStart() public method

Takes recurring tasks into account.
public getNextStart ( ) : Horde_Date
return Horde_Date The next start date.
Beispiel #1
0
 /**
  * Retrieves tasks from the database.
  *
  * @param integer $completed  Which tasks to retrieve (1 = all tasks,
  *                            0 = incomplete tasks, 2 = complete tasks,
  *                            3 = future tasks, 4 = future and incomplete
  *                            tasks).
  * @param boolean $include_history  Include created/changed data from
  *                                  Horde_History.
  *
  * @throws Nag_Exception
  */
 public function retrieve($completed = Nag::VIEW_ALL, $include_history = true)
 {
     /* Build the SQL query. */
     $query = 'SELECT * FROM nag_tasks WHERE task_owner = ?';
     $values = array($this->_tasklist);
     switch ($completed) {
         case Nag::VIEW_INCOMPLETE:
             $query .= ' AND task_completed = 0 AND (task_start IS NULL OR task_completions IS NOT NULL OR task_start = 0 OR task_start < ?)';
             $values[] = $_SERVER['REQUEST_TIME'];
             break;
         case Nag::VIEW_COMPLETE:
             $query .= ' AND task_completed = 1';
             break;
         case Nag::VIEW_FUTURE:
             $query .= ' AND task_completed = 0 AND (task_completions IS NOT NULL OR task_start > ?)';
             $values[] = $_SERVER['REQUEST_TIME'];
             break;
         case Nag::VIEW_FUTURE_INCOMPLETE:
             $query .= ' AND task_completed = 0';
             break;
     }
     try {
         $result = $this->_db->select($query, $values);
     } catch (Horde_Db_Exception $e) {
         throw new Nag_Exception($e->getMessage());
     }
     /* Store the retrieved values in a fresh task list. */
     $this->tasks = new Nag_Task();
     $dict = array();
     foreach ($result as $row) {
         $task = new Nag_Task($this, $this->_buildTask($row, $include_history));
         if (($completed == Nag::VIEW_INCOMPLETE || $completed == Nag::VIEW_FUTURE) && $task->start && $task->recurs()) {
             $start = $task->getNextStart();
             if ($completed == Nag::VIEW_INCOMPLETE && $start->after($_SERVER['REQUEST_TIME']) || $completed == Nag::VIEW_FUTURE && $start->before($_SERVER['REQUEST_TIME'])) {
                 continue;
             }
         }
         /* Add task directly if it is a root task, otherwise store it in
          * the dictionary. */
         if (empty($row['task_parent'])) {
             $this->tasks->add($task);
         } else {
             $dict[$row['task_id']] = $task;
         }
     }
     /* Build a tree from the subtasks. */
     foreach (array_keys($dict) as $key) {
         $task = $this->tasks->get($dict[$key]->parent_id);
         if ($task) {
             $task->add($dict[$key]);
         } elseif (isset($dict[$dict[$key]->parent_id])) {
             $dict[$dict[$key]->parent_id]->add($dict[$key]);
         } else {
             $this->tasks->add($dict[$key]);
         }
     }
 }