- // getActiveTasks - returns an array of active tasks for a group.
- static function getActiveTasks($group_id)
- {
- $result = array();
- $mdb2 = getConnection();
-
- $sql = "select id, name, description from tt_tasks where group_id = $group_id and status = 1 order by upper(name)";
- $res = $mdb2->query($sql);
- $result = array();
- if (!is_a($res, 'PEAR_Error')) {
- while ($val = $res->fetchRow()) {
- $result[] = $val;
- }
- }
- return $result;
- }
-
- // getInactiveTasks - returns an array of inactive tasks for a group.
- static function getInactiveTasks($group_id)
- {
- $result = array();
- $mdb2 = getConnection();
-
- $sql = "select id, name, description from tt_tasks
- where group_id = $group_id and status = 0 order by upper(name)";
- $res = $mdb2->query($sql);
- $result = array();
- if (!is_a($res, 'PEAR_Error')) {
- while ($val = $res->fetchRow()) {
- $result[] = $val;
- }
- }
- return $result;
- }
-
- // The getAllTasks obtains all tasks in a group.
- static function getAllTasks($group_id, $all_fields = false) {
- $mdb2 = getConnection();
-
- if ($all_fields)
- $sql = "select * from tt_tasks where group_id = $group_id order by status, upper(name)";
- else
- $sql = "select id, name from tt_tasks where group_id = $group_id order by status, upper(name)";
- $res = $mdb2->query($sql);
- $result = array();
- if (!is_a($res, 'PEAR_Error')) {
- while ($val = $res->fetchRow()) {
- $result[] = $val;
- }
- return $result;
- }
- return false;
- }
-