コード例 #1
0
ファイル: tasks.php プロジェクト: eureka2/web2project
     //$q->addTable('user_tasks');
     $q->addTable('user_tasks');
     $q->addWhere('user_tasks.user_id = ' . (int) $user_id);
     $q->addWhere('user_tasks.task_id = tasks.task_id');
     $q->addWhere('task_percent_complete = 100');
     //TODO: use date class to construct date.
     $q->addWhere('task_end_date >= \'' . date('Y-m-d 00:00:00', mktime(0, 0, 0, date('m'), date('d') - 7, date('Y'))) . '\'');
     break;
 case 'children':
     $q->addWhere('task_parent = ' . (int) $task_id);
     $q->addWhere('tasks.task_id <> ' . $task_id);
     break;
 case 'deepchildren':
     $taskobj = new CTask();
     $taskobj->load((int) $task_id);
     $deepchildren = $taskobj->getDeepChildren();
     $q->addWhere('tasks.task_id IN (' . implode(',', $deepchildren) . ')');
     $q->addWhere('tasks.task_id <> ' . $task_id);
     break;
 case 'myproj':
     $q->addWhere('project_owner = ' . (int) $user_id);
     break;
 case 'mycomp':
     if (!$AppUI->user_company) {
         $AppUI->user_company = 0;
     }
     $q->addWhere('project_company = ' . (int) $AppUI->user_company);
     break;
 case 'myunfinished':
     $q->addTable('user_tasks');
     $q->addWhere('user_tasks.user_id = ' . (int) $user_id);
コード例 #2
0
ファイル: tasks.class.php プロジェクト: eureka2/web2project
 public function getDeepChildren()
 {
     $children = $this->getChildren();
     if ($children) {
         $deep_children = array();
         $tempTask = new CTask();
         foreach ($children as $child) {
             $tempTask->load($child);
             $deep_children = array_merge($deep_children, $tempTask->getDeepChildren());
         }
         return array_merge($children, $deep_children);
     }
     return array();
 }
コード例 #3
0
 function getDeepChildren()
 {
     $q = new DBQuery();
     $q->addTable('tasks');
     $q->addQuery('task_id');
     $q->addWhere("task_id <> '" . $this->task_id . "' AND task_parent = '" . $this->task_id . "'");
     $sql = $q->prepare();
     $q->clear();
     $children = db_loadColumn($sql);
     if ($children) {
         $deep_children = array();
         $tempTask = new CTask();
         foreach ($children as $child) {
             $tempTask->peek($child);
             $deep_children = array_merge($deep_children, $tempTask->getDeepChildren());
         }
         return array_merge($children, $deep_children);
     }
     return array();
 }
コード例 #4
0
ファイル: organize.php プロジェクト: kaz190/dotproject
        //$user_id = $AppUI->getState('user_id');
    }
}
// check permissions
$canEdit = $perms->checkModule($m, 'edit');
// if task priority set and items selected, do some work
$action = dPgetParam($_POST, 'action', 99);
$selected = dPgetParam($_POST, 'selected', 0);
if ($selected && count($selected)) {
    $new_task = dPgetParam($_POST, 'new_task', -1);
    $new_project = dPgetParam($_POST, 'new_project', $project_id);
    foreach ($selected as $key => $val) {
        $t = new CTask();
        $t->load($val);
        if (isset($_POST['include_children']) && $_POST['include_children']) {
            $children = $t->getDeepChildren();
        }
        if ($action == 'f') {
            //mark task as completed
            if ($perms->checkModuleItem('tasks', 'edit', $t->task_id)) {
                $t->task_percent_complete = 100;
                $t->store();
            }
            if (isset($children)) {
                foreach ($children as $child_id) {
                    if ($perms->checkModuleItem('tasks', 'edit', $child_t->task_id)) {
                        $child_t = new CTask();
                        $child_t->load($child_id);
                        $child_t->task_percent_complete = 100;
                        $child_t->store();
                    }
コード例 #5
0
ファイル: gantt.php プロジェクト: hightechcompany/dotproject
$q->addGroup('project_id');
$q->addOrder('project_name');
$project->setAllowedSQL($AppUI->user_id, $q);
$projects = $q->loadHashList('project_id');
$q->clear();
$caller = defVal(@$_REQUEST['caller'], null);
/**
 * if task filtering has been requested create the list of task_ids
 * which will be used to filter the query
 */
if ($ganttTaskFilter > 0) {
    $task_child_search = new CTask();
    $task_child_search->peek($ganttTaskFilter);
    //$childrenlist[] = $ganttTaskFilter;
    //print_r($childrenlist);
    $childrenlist = $task_child_search->getDeepChildren();
    //print_r($childrenlist);
    $where .= ' t.task_id IN (' . $ganttTaskFilter . ', ' . implode(', ', $childrenlist) . ')';
}
//else {
//	$where = '';
//}
//echo '<pre> $where = ' . $where . '</pre>';
//die;
// gantt is called now by the todo page, too. There is a different filter approach in todo
// so we have to tweak a little bit, also we do not have a special project available
if ($caller == 'todo') {
    $user_id = defVal(@$_REQUEST['user_id'], 0);
    $projects[$project_id]['project_name'] = $AppUI->_('Todo for') . ' ' . dPgetUsernameFromID($user_id);
    $projects[$project_id]['project_color_identifier'] = 'ff6000';
    $q->addTable('tasks', 't');
コード例 #6
0
/**
 * @param $f
 * @param $q
 * @param $user_id
 * @param $task_id
 * @param $AppUI
 * @return string
 */
function __extract_from_tasks3($f, $q, $user_id, $task_id, $AppUI)
{
    $f = $f ? $f : '';
    if ($task_id) {
        //if we are on a task context make sure we show ALL the children tasks
        $f = 'deepchildren';
    }
    switch ($f) {
        case 'myfinished7days':
            $q->addWhere('ut.user_id = ' . (int) $user_id);
        case 'allfinished7days':
            $q->addTable('user_tasks');
            $q->addWhere('user_tasks.user_id = ' . (int) $user_id);
            $q->addWhere('user_tasks.task_id = tasks.task_id');
            $q->addWhere('task_percent_complete = 100');
            //TODO: use date class to construct date.
            $q->addWhere('task_end_date >= \'' . date('Y-m-d 00:00:00', mktime(0, 0, 0, date('m'), date('d') - 7, date('Y'))) . '\'');
            break;
        case 'children':
            $q->addWhere('task_parent = ' . (int) $task_id);
            $q->addWhere('tasks.task_id <> ' . $task_id);
            break;
        case 'deepchildren':
            $taskobj = new CTask();
            $taskobj->load((int) $task_id);
            $deepchildren = $taskobj->getDeepChildren();
            $q->addWhere('tasks.task_id IN (' . implode(',', $deepchildren) . ')');
            $q->addWhere('tasks.task_id <> ' . $task_id);
            break;
        case 'myproj':
            $q->addWhere('project_owner = ' . (int) $user_id);
            break;
        case 'mycomp':
            if (!$AppUI->user_company) {
                $AppUI->user_company = 0;
            }
            $q->addWhere('project_company = ' . (int) $AppUI->user_company);
            break;
        case 'myunfinished':
            $q->addTable('user_tasks');
            $q->addWhere('user_tasks.user_id = ' . (int) $user_id);
            $q->addWhere('user_tasks.task_id = tasks.task_id');
            $q->addWhere('(task_percent_complete < 100 OR task_end_date = \'\')');
            break;
        case 'allunfinished':
            $q->addWhere('(task_percent_complete < 100 OR task_end_date = \'\')');
            break;
        case 'unassigned':
            $q->leftJoin('user_tasks', 'ut_empty', 'tasks.task_id = ut_empty.task_id');
            $q->addWhere('ut_empty.task_id IS NULL');
            break;
        case 'taskcreated':
            $q->addWhere('task_creator = ' . (int) $user_id);
            break;
        case 'taskowned':
            $q->addWhere('task_owner = ' . (int) $user_id);
            break;
        case 'all':
            //break;
        //break;
        default:
            if ($user_id) {
                $q->addTable('user_tasks');
                $q->addWhere('user_tasks.user_id = ' . (int) $user_id);
                $q->addWhere('user_tasks.task_id = tasks.task_id');
            }
            break;
    }
    return $q;
}