public function getStartDate($id, $ms = 0, $ms_date = null)
 {
     $db = JFactory::getDbo();
     $nd = $db->getNullDate();
     $query = $db->getQuery(true);
     // Get the start date from the task
     $query->select('a.id, a.start_date, a.milestone_id')->select('m.start_date AS m_start')->from('#__pf_tasks AS a')->join('left', '#__pf_milestones AS m ON m.id = a.milestone_id')->where('a.list_id = ' . (int) $id)->where('a.state != -2')->order('a.start_date, a.id ASC');
     $db->setQuery($query, 0, 1);
     $task = $db->loadObject();
     if (empty($task)) {
         if (!empty($ms_date) && $ms_date != $nd) {
             $date = $ms_date;
         } elseif ($ms) {
             $mhelper = new modPFganttHelperMilestones($this->pid);
             $date = $mhelper->getStartDate($ms);
         } else {
             $dates = $this->getDateRange($id);
             $date = $dates[0];
         }
     } elseif ($task->start_date == $nd) {
         $thelper = new modPFganttHelperTasks($this->pid);
         $date = $thelper->getStartDate($task->id, $task->milestone_id, $task->m_start);
     } else {
         $date = $task->start_date;
     }
     return $date;
 }
 public function getEndDate($id, $ms = 0, $ms_date = null)
 {
     $db = JFactory::getDbo();
     $nd = $db->getNullDate();
     if (!empty($ms_date) && $ms_date != $nd) {
         return $ms_date;
     } elseif ($ms) {
         $mhelper = new modPFganttHelperMilestones($this->pid);
         $date = $mhelper->getEndDate($ms);
     } else {
         $dates = $this->getDateRange($id);
         $date = $dates[1];
     }
     return $date;
 }
Esempio n. 3
0
 /**
  * Method to get the end date of a task list
  * based on the latest task assigned to it.
  * Falls back to milestone and then to the project.
  *
  * @param    integer    $id         The task list id
  * @param    integer    $ms         The parent milestone id
  * @param    string     $ms_date    The parent milestone end date
  *
  * @return   string                 The end date
  */
 public static function getEndDate($id, $ms = 0, $ms_date = null)
 {
     static $cache = array();
     // Check the cache
     if (isset($cache[$id])) {
         return $cache[$id];
     }
     $db = JFactory::getDbo();
     $nd = $db->getNullDate();
     $query = $db->getQuery(true);
     // Get the end date from the task
     $query->select('a.id, a.end_date, a.milestone_id')->select('m.end_date AS m_end')->from('#__pf_tasks AS a')->join('left', '#__pf_milestones AS m ON m.id = a.milestone_id')->where('a.list_id = ' . (int) $id)->where('a.state != -2')->order('a.end_date DESC, a.id ASC');
     $db->setQuery($query, 0, 1);
     $task = $db->loadObject();
     if (empty($task)) {
         if (!empty($ms_date) && $ms_date != $nd) {
             $date = $ms_date;
         } elseif ($ms) {
             $date = modPFganttHelperMilestones::getEndDate($ms);
         } else {
             $date = modPFganttHelper::$project_end;
         }
     } elseif ($task->end_date == $nd) {
         $date = modPFganttHelperTasks::getEndDate($task->id, $task->milestone_id, $task->m_end);
     } else {
         $date = $task->end_date;
     }
     $cache[$id] = $date;
     return $cache[$id];
 }
Esempio n. 4
0
 /**
  * Method to get a list of project items:
  * Milestones, task lists and tasks
  *
  * @return    array
  */
 protected static function getProjectDetails()
 {
     $params = self::$params;
     $pid = self::$project;
     $default = array('1', '0', '2');
     $show_lists = $params->get('show_lists', $default);
     // Fix "Show Task Lists" setting from older module versions
     if (!is_array($show_lists)) {
         if ($show_lists == '1') {
             $show_lists = array('1', '0', '2');
         } else {
             $show_lists = array('-1');
         }
     }
     $milestones = modPFganttHelperMilestones::getItems($pid);
     $lists = !in_array('-1', $show_lists) ? modPFganttHelperLists::getItems($pid) : array();
     $tasks = modPFganttHelperTasks::getItems($pid);
     // Sort data by hierarchy
     $items = self::sortByHierarchy($milestones, $lists, $tasks);
     return $items;
 }
Esempio n. 5
0
 /**
  * Method to get the end date of a task
  * based on the parent list, milestone or project.
  *
  * @param    integer    $id          The task id
  * @param    integer    $ms          The parent milestone id
  * @param    string     $ms_date     The parent milestone end date
  *
  * @return   string                  The end date
  */
 public static function getEndDate($id, $ms = 0, $ms_date = null)
 {
     static $cache = array();
     // Check the cache
     if (isset($cache[$id])) {
         return $cache[$id];
     }
     $nd = JFactory::getDbo()->getNullDate();
     if (!empty($ms_date) && $ms_date != $nd) {
         return $ms_date;
     } elseif ($ms) {
         $date = modPFganttHelperMilestones::getEndDate($ms);
     } else {
         $date = modPFganttHelper::$project_end;
     }
     $cache[$id] = $date;
     return $cache[$id];
 }