Loading...
 

UserTasksDev

Status/RoadMap
  • Where are we?
  1. Creating private tasks (since v.1.8)
  2. Marking tasks with as status a priority and persentage (since v.1.8)
  3. Marting tasks as complited (since v.1.8)
  4. Creating tasks for other users
  5. Having a accepting system between task creater and task user (task user := who received the task)
  6. Message if a shared task has changed
  7. A history of the changes
  8. Make a task public for a group, also with a extra module
  9. Having right to send a tasks, receive, and admin tasks
  10. Marking tasks as deleted
  11. Only the creator can remove a task from the db, or he gave spazial rights to the task user
  12. task description wikiparsed


  • Futures for the next version
  1. sending tasks to different users (table tiki_user_tasks_cc allready exists)
  2. project admin can send tasks to all of his groups
  3. reminder bevor deadline

  • Who is working on what? (Priorities/goals/majors issues/roles)
    • sir-b currently bug fixing
    • Hausi this and that (zbV) (tsu) (you don't know what it is? ask me ;-))

TikiTeam

Who is working here generally?

What is done

  • A Updated table tiki_user_tasks for the new task system in online since (sir-b 26th of Jannuary 2005)

      [-]
      • task tables
        #
        # Table structure for table tiki_user_tasks_history
        #
        # Creation: Jul 03, 2003 at 07:42 PM
        # Last update: Jan 25, 2005 by sir-b & moresun
        #
        DROP TABLE IF EXISTS tiki_user_tasks_history;
        CREATE TABLE tiki_user_tasks_history (
          belongs_to integer(14) NOT NULL,                   -- the fist task in a history it has the same id as the task id
          task_version integer(4) NOT NULL DEFAULT 0,        -- version number for the history it starts with 0
          title varchar(250) NOT NULL,                       -- title
          description text DEFAULT NULL,                     -- description
          start integer(14) DEFAULT NULL,                    -- date of the starting, if it is not set than there is not starting date
          end integer(14) DEFAULT NULL,                      -- date of the end, if it is not set than there is not dealine
          lasteditor varchar(200) NOT NULL,                  -- lasteditor: username of last editior
          lastchanges integer(14) NOT NULL,                  -- date of last changes
          priority integer(2) NOT NULL DEFAULT 3,                     -- priority
          completed integer(14) DEFAULT NULL,                -- date of the completation if it is null it is not yet completed
          deleted integer(14) DEFAULT NULL,                  -- date of the deleteation it it is null it is not deleted
          status char(1) DEFAULT NULL,                       -- null := waiting, 
                                                             -- o := open / in progress, 
                                                             -- c := completed -> (percentage = 100) 
          percentage int(4) DEFAULT NULL,
          accepted_creator char(1) DEFAULT NULL,             -- y - yes, n - no, null - waiting
          accepted_user char(1) DEFAULT NULL,                -- y - yes, n - no, null - waiting
          PRIMARY KEY (belongs_to, task_version)
        ) TYPE=MyISAM AUTO_INCREMENT=1 ;
        
        #
        # Table structure for table tiki_user_tasks
        #
        # Creation: Jul 03, 2003 at 07:42 PM
        # Last update: Jan 25, 2005 by sir-b & moresun
        #
        DROP TABLE IF EXISTS tiki_user_tasks;
        CREATE TABLE tiki_user_tasks (
          taskId integer(14) NOT NULL auto_increment,        -- task id
          last_version integer(4) NOT NULL DEFAULT 0,        -- last version of the task starting with 0
          user varchar(200) NOT NULL,                        -- task user
          creator varchar(200) NOT NULL,                     -- username of creator
          public_for_group varchar(30) DEFAULT NULL,         -- this group can also view the task, if it is null it is not public
          rights_by_creator char(1) DEFAULT NULL,            -- null the user can delete the task, 
          created integer(14) NOT NULL,                      -- date of the creation
          PRIMARY KEY (taskId),
          UNIQUE(creator, created)
        ) TYPE=MyISAM AUTO_INCREMENT=1;

)||

  • A new rights (sir-b 26th of Jannuary 2005)

      [-]
      • new rights
        INSERT INTO users_permissions (permName, permDesc, level,type) VALUES ('tiki_p_tasks_send', 'Can send tasks to other users', 'registered', 'user');
        INSERT INTO users_permissions (permName, permDesc, level,type) VALUES ('tiki_p_tasks_receive', 'Can receive tasks from other users', 'registered', 'user');
        INSERT INTO users_permissions (permName, permDesc, level,type) VALUES ('tiki_p_tasks_admin', 'Can admin public tasks', 'admin', 'user');

Trackers
  • Bugs
    [-]
  • RFEs
    [-]
  • tech support
  • patches
    • Update script to update the tiki_user_tasks table from 1.8 to 1.9 with new tasks system, you need to update the database ore your task module will not show your tasks
      [-]
      • update_task_table_1.8to1.9.php
        # To not use this update if you have allready the new task system where you 
        # it will set all assigned task to other users back to the creator
        # you need to update the database ore your task module will not show your tasks
        
        
        DROP TABLE IF EXISTS tiki_user_tasks_history;
        CREATE TABLE tiki_user_tasks_history (
          belongs_to integer(14) NOT NULL,                   -- the fist task in a history it has the same id as the task id
          task_version integer(4) NOT NULL DEFAULT 0,        -- version number for the history it starts with 0
          title varchar(250) NOT NULL,                       -- title
          description text DEFAULT NULL,                     -- description
          start integer(14) DEFAULT NULL,                    -- date of the starting, if it is not set than there is not starting date
          end integer(14) DEFAULT NULL,                      -- date of the end, if it is not set than there is not dealine
          lasteditor varchar(200) NOT NULL,                  -- lasteditor: username of last editior
          lastchanges integer(14) NOT NULL,                  -- date of last changes
          priority integer(2) NOT NULL DEFAULT 3,                     -- priority
          completed integer(14) DEFAULT NULL,                -- date of the completation if it is null it is not yet completed
          deleted integer(14) DEFAULT NULL,                  -- date of the deleteation it it is null it is not deleted
          status char(1) DEFAULT NULL,                       -- null := waiting, 
                                                             -- o := open / in progress, 
                                                             -- c := completed -> (percentage = 100) 
          percentage int(4) DEFAULT NULL,
          accepted_creator char(1) DEFAULT NULL,             -- y - yes, n - no, null - waiting
          accepted_user char(1) DEFAULT NULL,                -- y - yes, n - no, null - waiting
          PRIMARY KEY (belongs_to, task_version)
        ) TYPE=MyISAM AUTO_INCREMENT=1 ;
        
        UPDATE tiki_user_tasks set title = '-'  where title IS NULL;
        INSERT INTO tiki_user_tasks_history (belongs_to, title, start, description, lasteditor, lastchanges, priority, completed, status, percentage) SELECT  taskId, title, date, description, user, date, priority, completed, status, percentage FROM tiki_user_tasks;
        
        ALTER TABLE tiki_user_tasks DROP description;
        ALTER TABLE tiki_user_tasks DROP title;
        ALTER TABLE tiki_user_tasks ADD last_version integer(4) NOT NULL DEFAULT 0 AFTER taskId;
        ALTER TABLE tiki_user_tasks MODIFY user varchar(200) NOT NULL AFTER last_version;
        ALTER TABLE tiki_user_tasks ADD creator varchar(200) NOT NULL AFTER user;
        ALTER TABLE tiki_user_tasks ADD public_for_group varchar(30) DEFAULT NULL AFTER creator;
        ALTER TABLE tiki_user_tasks ADD rights_by_creator char(1) DEFAULT NULL AFTER public_for_group;
        ALTER TABLE tiki_user_tasks CHANGE date created integer(14) NOT NULL AFTER rights_by_creator;
        
        INSERT INTO users_permissions (permName, permDesc, level,type) VALUES ('tiki_p_tasks_send', 'Can send tasks to other users', 'registered', 'user');
        INSERT INTO users_permissions (permName, permDesc, level,type) VALUES ('tiki_p_tasks_receive', 'Can receive tasks from other users', 'registered', 'user');
        INSERT INTO users_permissions (permName, permDesc, level,type) VALUES ('tiki_p_tasks_admin', 'Can admin public tasks', 'admin', 'user');


Competition and standards


The task system should be similar to the MS-Outlook, but with less futures.


Here I would like to see some "editorial" content. How do our features compare to others?

CVS Doc section

This is where new features being developed and only in CVS are documented. When the CVS becomes RC/official release, the info in the CVS docs is transferred to update the official docs (FeatureXDoc).


Discussion/participation

Where ideas can be exchanged, debated, etc. Interested people can subscribe to the wiki page and/or to these forums as they would a mailing list.


Page last modified on Tuesday 01 February 2005 15:02:17 GMT-0000

Upcoming Events

No records to display

Why Register?

Register at tiki.org and you'll be able to use the account at any *.tiki.org site, thanks to the InterTiki feature. A valid email address is required to receive site notifications and occasional newsletters. You can opt out of these items at any time.