X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=WEB-INF%2Flib%2FttTaskHelper.class.php;h=b4644d5131cc182fbae4e7507a15e7e9b6160cc4;hb=d79a4bb229f2ce666fdb8d663e51e55e39a91827;hp=e09c882d31173a6d9fd3d65b9611d486760d0bd0;hpb=45c855269d952873285f7a835e82fc2b3eff3971;p=timetracker.git diff --git a/WEB-INF/lib/ttTaskHelper.class.php b/WEB-INF/lib/ttTaskHelper.class.php index e09c882d..b4644d51 100644 --- a/WEB-INF/lib/ttTaskHelper.class.php +++ b/WEB-INF/lib/ttTaskHelper.class.php @@ -136,13 +136,14 @@ class ttTaskHelper { $mdb2 = getConnection(); $group_id = (int) $fields['group_id']; + $org_id = (int) $fields['org_id']; $name = $fields['name']; $description = $fields['description']; $projects = $fields['projects']; $status = $fields['status']; - $sql = "insert into tt_tasks (group_id, name, description, status) - values ($group_id, ".$mdb2->quote($name).", ".$mdb2->quote($description).", ".$mdb2->quote($status).")"; + $sql = "insert into tt_tasks (group_id, org_id, name, description, status) + values ($group_id, $org_id, ".$mdb2->quote($name).", ".$mdb2->quote($description).", ".$mdb2->quote($status).")"; $affected = $mdb2->exec($sql); $last_id = 0; if (is_a($affected, 'PEAR_Error')) @@ -184,7 +185,7 @@ class ttTaskHelper { return $last_id; } - // update function updates a task in the database. + // update function updates a task in the database. static function update($fields) { global $user; @@ -219,7 +220,7 @@ class ttTaskHelper { // Handle task binds in the tasks field of the tt_projects table. // We need to either delete or insert task id in all affected projects. - // Get all not deleted projects for team. + // Get all not deleted projects for group. $sql = "select id, tasks from tt_projects where group_id = $user->group_id and status is not NULL"; $res = $mdb2->query($sql); if (is_a($res, 'PEAR_Error')) @@ -237,14 +238,14 @@ class ttTaskHelper { if ($task_ids) { $task_ids .= ",$task_id"; $task_ids = ttTaskHelper::sort($task_ids); - } else - $task_ids = $task_id; + } else + $task_ids = $task_id; - $sql = "update tt_projects set tasks = ".$mdb2->quote($task_ids)." where id = $project_id"; - $affected = $mdb2->exec($sql); - if (is_a($affected, 'PEAR_Error')) - die($affected->getMessage()); - } + $sql = "update tt_projects set tasks = ".$mdb2->quote($task_ids)." where id = $project_id"; + $affected = $mdb2->exec($sql); + if (is_a($affected, 'PEAR_Error')) + die($affected->getMessage()); + } } else { // Task needs to be removed from this project. if (in_array($task_id, $task_arr)) {