home · contact · privacy
Improve accounting scripts.
[misc] / todo.py
diff --git a/todo.py b/todo.py
index a4d7da0e56fce598906e40ad42fd7a247d3934f7..6c84ee0dbe8e5d7b05fe00d625ef3342b972d97a 100644 (file)
--- a/todo.py
+++ b/todo.py
@@ -11,26 +11,83 @@ server_port = 8082
 DATE_FORMAT = '%Y-%m-%d'
 j2env = JinjaEnv(loader=JinjaFSLoader('todo_templates'))
 
+
+
+def today_date(with_time=False):
+    length = 19 if with_time else 10
+    return str(datetime.now())[:length]
+
+
+
+class AttributeWithHistory:
+
+    def __init__(self, default_if_empty, history=None, then_date='2000-01-01', set_check=None, alt_get=None):
+        self.default = default_if_empty
+        self.then_date = then_date
+        self.history = history if history else {}
+        self.set_check = set_check
+        self.alt_get = alt_get 
+
+    def set(self, value):
+        if self.set_check:
+            self.set_check(value)
+        keys = sorted(self.history.keys())
+        if len(self.history) == 0 or value != self.history[keys[-1]]:
+            self.history[today_date(with_time=True)] = value
+
+    def at(self, queried_date):
+        if self.alt_get:
+            ret = self.alt_get('at', queried_date)
+            if ret is not None:
+                return ret
+        if 0 == len(self.history):
+            return self.default
+        ret = self.history[sorted(self.history.keys())[0]]
+        for date_key, item in self.history.items():
+            if date_key > f'{queried_date} 23:59:59':
+                break
+            ret = item
+        return ret
+
+    @property
+    def now(self):
+        if self.alt_get:
+            ret = self.alt_get('now')
+            if ret is not None:
+                return ret
+        keys = sorted(self.history.keys())
+        return self.default if 0 == len(self.history) else self.history[keys[-1]]
+
+    @property
+    def then(self):
+        if self.alt_get:
+            ret = self.alt_get('then')
+            if ret is not None:
+                return ret
+        return self.at(self.then_date)
+
+
+
 class Task:
 
-    def __init__(self, db, id_, title_history=None, tags_history=None, default_effort_history=None, links_history=None, comment=''):
-        self.id_ = id_
+    def __init__(self,
+            db,
+            id_,
+            title_history=None,
+            tags_history=None,
+            default_effort_history=None,
+            subtask_ids_history=None,
+            comment=''):
         self.db = db
-        self.title_history = title_history if title_history else {}
-        self.tags_history = tags_history if tags_history else {}
-        self.default_effort_history = default_effort_history if default_effort_history else {}
-        self.links_history = links_history if links_history else {}
+        self.id_ = id_
+        self.title = AttributeWithHistory('', title_history, self.db.selected_date)
+        self.tags = AttributeWithHistory(set(), tags_history, self.db.selected_date)
+        self.default_effort = AttributeWithHistory(0.0, default_effort_history, self.db.selected_date, alt_get=self.subtasks_sum_maker())
+        self.subtask_ids = AttributeWithHistory(set(), subtask_ids_history, self.db.selected_date, set_check=self.subtask_loop_checker())
         self.comment = comment
-        self.visible = True
-
-    def _set_with_history(self, history, value):
-        keys = sorted(history.keys())
-        if len(history) == 0 or value != history[keys[-1]]:
-            history[str(datetime.now())[:19]] = value
 
-    def _last_of_history(self, history, default):
-        keys = sorted(history.keys())
-        return default if 0 == len(history) else history[keys[-1]]
+        self.visible = True
+        self.dependers = [] 
 
     @classmethod
     def from_dict(cls, db, d, id_):
@@ -40,157 +97,92 @@ class Task:
                d['title_history'],
                {k: set(v) for k, v in d['tags_history'].items()},
                d['default_effort_history'],
-               {k: set(v) for k, v in d['links_history'].items()},
+               {k: set(v) for k, v in d['subtasks_history'].items()},
                d['comment'])
         return t
 
     def to_dict(self):
         return {
-            'title_history': self.title_history,
-            'default_effort_history': self.default_effort_history,
-            'tags_history': {k: list(v) for k,v in self.tags_history.items()},
-            'links_history': {k: list(v) for k,v in self.links_history.items()},
+            'title_history': self.title.history,
+            'default_effort_history': self.default_effort.history,
+            'tags_history': {k: list(v) for k, v in self.tags.history.items()},
+            'subtasks_history': {k: list(v) for k, v in self.subtask_ids.history.items()},
             'comment': self.comment,
         }
 
     @property
-    def default_effort(self):
-        return self._last_of_history(self.default_effort_history, 1)
-
-    @default_effort.setter
-    def default_effort(self, default_effort):
-        self._set_with_history(self.default_effort_history, default_effort)
-
-    def default_effort_at(self, queried_date):
-        ret = self.default_effort_history[sorted(self.default_effort_history.keys())[0]]
-        for date_key, default_effort in self.default_effort_history.items():
-            if date_key > f'{queried_date} 23:59:59':
-                break
-            ret = default_effort
-        return ret
+    def subtasks(self):
+        subtasks = []
+        for id_ in self.subtask_ids.now:
+            if len(id_) == 0:
+                continue
+            subtasks += [self.db.tasks[id_]]
+        return subtasks
 
-    # @property
-    # def current_default_effort(self):
-    #     return self.default_effort_at(self.db.selected_date)
+    @property
+    def subtask_depth(self):
+        def count_depth(task):
+            sub_count = 1
+            for subtask in task.subtasks:
+                sub_count += count_depth(subtask)
+            return sub_count
+        return count_depth(self) 
+
+    def subtask_loop_checker(self):
+        def f(subtask_ids_now):
+            loop_msg = "can't set subtask, would create loop"
+            for id_ in subtask_ids_now:
+                if id_ == self.id_:
+                    raise PlomException(loop_msg)
+                elif id_ in self.db.tasks.keys():
+                    subtask = self.db.tasks[id_]
+                    f(subtask.subtask_ids.now)
+        return f 
+
+    def subtasks_sum_maker(self):
+        def f(f_name, queried_date=None):
+            subtask_ids_to_check = getattr(self.subtask_ids, f_name)
+            if queried_date:
+                subtasks = [self.db.tasks[id_] for id_ in subtask_ids_to_check(queried_date)]
+            else:
+                subtasks = [self.db.tasks[id_] for id_ in subtask_ids_to_check]
+            if len(self.subtasks) > 0:
+                summe = 0
+                for subtask in self.subtasks:
+                    if queried_date:
+                        to_add = getattr(subtask.default_effort, f_name)
+                        summe += to_add(queried_date)
+                    else:
+                        summe += getattr(subtask.default_effort, f_name)
+                return summe
+            return None
+        return f
 
     def matches(self, search):
         if search is None:
             return False
         else:
-            return search in self.title or search in self.comment or search in '$'.join(self.tags) or search in self.title
-
-    @property
-    def title(self):
-        return self._last_of_history(self.title_history, '')
-
-    @title.setter
-    def title(self, title):
-        self._set_with_history(self.title_history, title)
-
-    def title_at(self, queried_date):
-        ret = self.title_history[sorted(self.title_history.keys())[0]]
-        for date_key, title in self.title_history.items():
-            if date_key > f'{queried_date} 23:59:59':
-                break
-            ret = title
-        return ret
-
-    @property
-    def current_title(self):
-        return self.title_at(self.db.selected_date)
-
-    @property
-    def tags(self):
-        return self._last_of_history(self.tags_history, set())
-
-    @tags.setter
-    def tags(self, tags):
-        self._set_with_history(self.tags_history, set(tags))
-
-    @property
-    def links(self):
-        return self._last_of_history(self.links_history, set())
-
-    @links.setter
-    def links(self, links):
-        self._set_with_history(self.links_history, set(links))
-
-    # @property
-    # def id_(self):
-    #     for k, v in self.db.tasks.items():
-    #         if v == self:
-    #             return k
+            return search in self.title.now or search in self.comment or search in '$'.join(self.tags.now)
 
 
 class Day:
 
-    # def __init__(self, db, todos=None, comment='', date=None):
     def __init__(self, db, date, comment=''):
         self.date = date 
         self.db = db
         self.comment = comment
-        self.archived = True
-        self.todos = {} # legacy
         self.linked_todos_as_list = []
-        # if todos:
-        #     for id_, todo_dict in todos.items():
-        #         self.add_todo(id_, todo_dict)
 
     @classmethod
     def from_dict(cls, db, d, date=None):
-        # todos = {}
         comment = d['comment'] if 'comment' in d.keys() else ''
         day = cls(db, date, comment)
-        # if 'todos' in d.keys():
-        #     for uuid, todo_dict in d['todos'].items():
-        #         day.add_todo(uuid, todo_dict)
-        # if 'linked_todos' in d.keys():
-        for id_ in d['linked_todos']:
-            # if id_ in day.linked_todos.keys():
-            #     continue
-            # if id_ is None:
-            #     continue
-            # linked_todo = db.todos[id_]
-            # linked_todo._day = day 
-            # day.linked_todos_as_list += [linked_todo]
-            day.linked_todos_as_list += [db.todos[id_]]
         return day
 
     def to_dict(self):
-        d = {'comment': self.comment, 'linked_todos': []}
-        for todo_id in self.linked_todos.keys():
-            d['linked_todos'] += [todo_id]
-        # for task_uuid, todo in self.todos.items():
-        # for id_, todo in self.todos.items():
-        # #     d['todos'][task_uuid] = todo.to_dict()
-        #     new_type_todo_id = f'{self.date}_{task_uuid}'
-        #     if not new_type_todo_id in d['linked_todos']:
-        #         # d['linked_todos'] += [todo.id_] 
-        #         d['linked_todos'] += [new_type_todo_id] 
+        d = {'comment': self.comment}
         return d
 
-    # def add_todo(self, task_id, dict_source=None):
-    #     new_type_todo_id = f'{self.date}_{task_id}'
-    #     task = self.db.tasks[task_id]
-    #     if new_type_todo_id in self.db.todos.keys():
-    #         todo = self.db.todos[new_type_todo_id]
-    #     # elif task_id in self.db.keys():
-    #     #     todo = self.db.todos[task_id]
-    #     else:
-    #         # todo = Todo.from_dict(self.db, dict_source, id_=new_type_todo_id) if dict_source else Todo(db=self.db, day=self)
-    #         todo = Todo.from_dict(self.db, dict_source)
-    #     # todo._id = new_type_todo_id
-    #     todo._task = self.db.tasks[task_id] 
-    #     todo._id = new_type_todo_id
-    #     todo._day = self 
-    #     # self.todos[task_id] = todo 
-    #     self.linked_todos_as_list += [todo]
-    #     self.db.todos[new_type_todo_id] = todo
-    #     # self.db.todos[todo.task_id] = [todo]
-    #     # self.db.todos_as_list += [todo]
-    #     # self.db.all_todos[todo.task_id] = todo
-    #     return todo 
-
     @property
     def linked_todos(self):
         linked_todos = {}
@@ -202,9 +194,10 @@ class Day:
         s = 0
         for todo in [todo for todo in self.linked_todos.values()
                      if self.date in todo.efforts.keys()]:
+                     # and not todo.children]:
             day_effort = todo.efforts[self.date]
             if todo.done:
-                s += day_effort if day_effort else todo.task.default_effort_at(self.date)
+                s += day_effort if day_effort else todo.task.default_effort.at(self.date)
             elif include_undone:
                 s += day_effort if day_effort else 0 
         return s
@@ -213,98 +206,124 @@ class Day:
     def todos_sum(self):
         return self._todos_sum()
 
-    # @property
-    # def todos_sum2(self):
-    #     return self._todos_sum(True)
-
-    # @property
-    # def date(self):
-    #     if self._date:
-    #         return self._date
-    #     else:
-    #         for k, v in self.db.days.items():
-    #             # print("DEBUG date", k, v)
-    #             if v == self:
-    #                 return k
-    #     print("DEBUG FAIL", self.test_date, self)
-
 
 class Todo:
 
-    # def __init__(self, db, id_, task, done=False, day_effort=None, comment='', day_tags=None, importance=1.0, efforts=None):
-    def __init__(self, db, id_, task, done=False, comment='', day_tags=None, importance=1.0, efforts=None, children=None):
+    def __init__(self,
+                 db,
+                 id_,
+                 task,
+                 done=False,
+                 comment='',
+                 day_tags=None,
+                 importance=1.0,
+                 efforts=None,
+                 dep_ids=None):
         self.id_ = id_
         self.db = db 
         self.task = task 
-        self.done = done
-        # self.day_effort = day_effort
+        self._done = done
         self.efforts = efforts if efforts else {}
         self.comment = comment
         self.day_tags = day_tags if day_tags else set()
         self.importance = importance
-        self.children = children if children else [] 
-        self.parent = None 
+        self.dep_ids = dep_ids if dep_ids else [] 
+
+        self.dependers = [] 
 
     @classmethod
     def from_dict(cls, db, d, id_):
-        # todo = cls(db, None, None, d['done'], d['day_effort'], d['comment'], set(d['day_tags']), d['importance'])
-        # todo._task = db.tasks[d['task']] if 'task' in d.keys() else None
-        # todo._efforts = d['efforts'] if 'efforts' in d.keys() else None
-        # todo = cls(db, id_, db.tasks[d['task']], d['done'], d['day_effort'], d['comment'], set(d['day_tags']), d['importance'], d['efforts'])
-        todo = cls(db, id_, db.tasks[d['task']], d['done'], d['comment'], set(d['day_tags']), d['importance'], d['efforts'])
-        if 'children' in d:
-            todo.children = d['children']
+        todo = cls(
+                db,
+                id_,
+                db.tasks[d['task']],
+                d['done'],
+                d['comment'],
+                set(d['day_tags']),
+                d['importance'],
+                d['efforts'],
+                d['deps'])
         return todo
 
-    # @classmethod
-    # def OLD_from_dict(cls, day, d):
-    #     todo = cls(day, d['done'], d['day_effort'], d['comment'], set(d['day_tags']), d['importance'])
-    #     if 'efforts' in d.keys():
-    #         todo._efforts = d['efforts']
-    #     return todo
-
     def to_dict(self):
-        # return {'task': self.task.id_, 'done': self.done, 'day_effort': self.day_effort, 'comment': self.comment, 'day_tags': list(self.day_tags), 'importance': self.importance, 'efforts': self.efforts}
-        return {'task': self.task.id_, 'done': self.done, 'comment': self.comment, 'day_tags': list(self.day_tags), 'importance': self.importance, 'efforts': self.efforts, 'children': self.children}
+        return {
+                'task': self.task.id_,
+                'done': self.done,
+                'comment': self.comment,
+                'day_tags': list(self.day_tags),
+                'importance': self.importance,
+                'efforts': self.efforts,
+                'deps': self.dep_ids}
+
+    @property
+    def title(self):
+        return self.task.title.at(self.earliest_date)
+
+    @property
+    def dated_title(self):
+        return f'{self.earliest_date}:{self.title}'
+
+    @property
+    def deps(self):
+        return [self.db.todos[id_] for id_ in self.dep_ids]
+
+    @deps.setter
+    def deps(self, deps):
+        self.dep_ids = [dep.id_ for dep in deps]
 
     @property
     def default_effort(self):
-        return self.task.default_effort_at(self.sorted_effort_dates[0])
-
-    # @property
-    # def effort(self):
-    #     if self.day_effort:
-    #         return self.day_effort
-    #     else:
-    #         return self.day_effort if self.day_effort else self.default_effort
-
-    # @property
-    # def task(self):
-    #     if self._task:
-    #         return self._task
-    #     # else:
-    #     #     for k, v in self.day.todos.items():
-    #     #         if v == self:
-    #     #             return self.db.tasks[k]
+        return self.task.default_effort.at(self.earliest_date)
 
-    def is_effort_removable(self, date):
-        if not date in self.efforts.keys():
-            return False
-        # if len(self.efforts) == 1:
-        #     return False
-        if self.efforts[date]:
-            return False
-        if self.done and date == self.sorted_effort_dates[-1]:
-            return False
+    @property
+    def done(self):
+        return self.deps_done and self._done
+
+    @done.setter
+    def done(self, doneness):
+        self._done = doneness
+
+    @property
+    def deps_done(self):
+        if len(self.deps) > 0:
+            for dep in self.deps:
+                if not dep.done:
+                    return False
         return True
 
     @property
-    def total_effort(self):
+    def dep_efforts(self):
+        dep_efforts = 0
+        if self.deps:
+            for dep in self.deps: 
+                dep_efforts += dep.all_days_effort
+                dep_efforts += dep.dep_efforts
+        return dep_efforts
+
+    def depender_path(self, dep):
+        if self.dependers:
+            return f'Y{depender.depender_path()}:{self.title}Y'
+        else:
+            return f'X{self.title}X'
+
+    @property
+    def depender_paths(self):
+        paths = []
+        for depender in self.dependers:
+            if len(depender.depender_paths) == 0:
+                 paths += [[depender]]
+            else:
+                for path in depender.depender_paths:
+                    paths += [path + [depender]] 
+        return paths
+
+    @property
+    def all_days_effort(self):
         total = 0
         for effort in self.efforts.values():
             total += effort if effort else 0
         if self.done:
-            total = max(total, self.task.default_effort_at(self.sorted_effort_dates[-1]))
+            total = max(total, self.task.default_effort.at(self.latest_date))
         return total
 
     def matches(self, search):
@@ -313,37 +332,27 @@ class Todo:
         else:
             return search in self.comment or search in '$'.join(self.tags) or search in self.title
 
-    @property
-    def title(self):
-        return self.task.title_at(self.sorted_effort_dates[0])
-
-    @property
-    def path(self):
-        path = ''
-        if self.parent:
-            path = f'{self.parent.path}{self.parent.title}:'
-        return path
+    def is_effort_removable(self, date):
+        if not date in self.efforts.keys():
+            return False
+        if self.efforts[date]:
+            return False
+        if self.done and date == self.latest_date:
+            return False
+        return True
 
     @property
     def tags(self):
-        return self.day_tags | self.task.tags
-
-    # def internals_empty(self):
-    #     return len(self.comment) == 0 and len(self.day_tags) == 0
-
-    # def ensure_day_efforts_table(self):
-    #     # We don't do this yet at __init__ because self.day.date is unknown, since Todo may be imported with Day, and during the import process the Day is not yet keyed in TodoDB.days.
-    #     if not hasattr(self, '_efforts'):
-    #         self._efforts = {} # {self.day.date: self.day_effort}
-
-    # def set_day_effort(self, date, effort):
-    #     self.ensure_day_efforts_table()
-    #     self._efforts[date] = self.day_effort
+        return self.day_tags | self.task.tags.now
 
     @property
     def day_effort(self):
         return self.efforts[self.db.selected_date]
 
+    @property
+    def day(self):
+        return self.db.days[self.earliest_date]
+
     @property
     def sorted_effort_dates(self):
         dates = list(self.efforts.keys())
@@ -351,100 +360,64 @@ class Todo:
         return dates
 
     @property
-    def day(self):
-        if len(self.efforts) == 0:
-            return None
-        todo_start_date = self.sorted_effort_dates[0]
-        return self.db.days[todo_start_date]
-
-    # @property
-    # def efforts(self):
-    #     self.ensure_day_efforts_table()
-    #     return self._efforts
+    def earliest_date(self):
+        return self.sorted_effort_dates[0]
 
-    # @property
-    # def id_(self):
-    #     if self._id:
-    #         return self._id
-    #     for k, v in self.db.todos.items():
-    #         if v == self:
-    #             return k
-    #     # return f'{self.day.date}_{self.task.id_}'
+    @property
+    def latest_date(self):
+        return self.sorted_effort_dates[-1]
 
 
 class TodoDB(PlomDB):
 
-    def __init__(self, prefix, selected_date=None, t_filter_and = None, t_filter_not = None, hide_unchosen=False, hide_done=False):
-        self.prefix = prefix
-        self.selected_date = selected_date if selected_date else str(datetime.now())[:10]
-        self.t_filter_and = t_filter_and if t_filter_and else []
-        self.t_filter_not = t_filter_not if t_filter_not else []
+    def __init__(self,
+            selected_date=None,
+            tag_filter_and = None,
+            tag_filter_not = None,
+            hide_unchosen=False,
+            hide_done=False):
+        self.selected_date = selected_date if selected_date else today_date()
+        self.tag_filter_and = tag_filter_and if tag_filter_and else []
+        self.tag_filter_not = tag_filter_not if tag_filter_not else []
         self.hide_unchosen = hide_unchosen
         self.hide_done = hide_done
+
         self.days = {}
         self.tasks = {}
         self.t_tags = set()
         self.todos = {}
         super().__init__(db_path)
 
+    # savefile I/O
+
     def read_db_file(self, f):
         d = json.load(f)
+
         for id_, t_dict in d['tasks'].items():
             t = self.add_task(id_=id_, dict_source=t_dict)
-            for tag in t.tags:
+            for tag in t.tags.now:
                 self.t_tags.add(tag)
-        # if 'todos' in d.keys():
+        for task in self.tasks.values():
+            for dep in task.subtasks:
+                dep.dependers += [task]
+
         for id_, todo_dict in d['todos'].items():
-            # todo = Todo.from_dict(self, todo_dict, id_)
-            # todo._id = id_ 
-            # self.todos[id_] = todo
-            todo = self.add_todo(todo_dict, id_) # Todo.from_dict(self, todo_dict, id_)
-            self.todos[id_] = todo 
+            todo = self.add_todo(todo_dict, id_, link_into_day=False)
             for tag in todo.day_tags:
                 self.t_tags.add(tag)
+        for todo in self.todos.values():
+            for dep in todo.deps:
+                dep.dependers += [todo]
+
         for date, day_dict in d['days'].items():
             self.add_day(dict_source=day_dict, date=date)
         for todo in self.todos.values():
-            for child_id in todo.children:
-                self.todos[child_id].parent = todo
-            # if len(todo.efforts) == 0:
-            #     print("DEBUG", todo.id_, todo.task.title, todo.efforts)
             for date in todo.efforts.keys():
                 if not date in self.days.keys():
                     self.add_day(date)
-                if not todo in self.days[date].linked_todos_as_list:
-                    self.days[date].linked_todos_as_list += [todo]
-                    # print("DEBUG", todo.title, date)
-                # if type(todo.efforts[date]) == str:
-                #     todo.efforts[date] = float(todo.efforts[date])
-                #     print("DEBUG", todo.title, date, todo.efforts[date])
-        # for todo in self.todos.values():
-        # for day in self.days.values():
-        #     for todo in day.todos.values():
-        #         for tag in todo.day_tags:
-        #             self.t_tags.add(tag)
-        # delete = None
-        # for todo in self.todos.values():
-        #     if len(todo.efforts) == 0:
-        #         print("DEBUG", todo.task.title)
-        #         delete = todo.id_ 
-        # self.delete_todo(delete)
-        self.set_visibilities()
+                self.days[date].linked_todos_as_list += [todo]
 
-    def set_visibilities(self):
-        for uuid, t in self.tasks.items():
-            t.visible = len([tag for tag in self.t_filter_and if not tag in t.tags]) == 0\
-                    and len([tag for tag in self.t_filter_not if tag in t.tags]) == 0\
-                    and ((not self.hide_unchosen) or uuid in self.selected_day.todos.keys())
-        # for day in self.days.values():
-        #     for todo in day.todos.values():
-        #         todo.visible = len([tag for tag in self.t_filter_and if not tag in todo.day_tags | todo.task.tags ]) == 0\
-        #             and len([tag for tag in self.t_filter_not if tag in todo.day_tags | todo.task.tags ]) == 0\
-        #             and ((not self.hide_done) or (not todo.done))
-        for todo in self.todos.values():
-            todo.visible = len([tag for tag in self.t_filter_and if not tag in todo.day_tags | todo.task.tags ]) == 0\
-                and len([tag for tag in self.t_filter_not if tag in todo.day_tags | todo.task.tags ]) == 0\
-                and ((not self.hide_done) or (not todo.done))
+        self.set_visibilities()
 
     def to_dict(self):
         d = {'tasks': {}, 'days': {}, 'todos': {}}
@@ -452,26 +425,10 @@ class TodoDB(PlomDB):
              d['tasks'][uuid] = t.to_dict()
         for date, day in self.days.items():
             d['days'][date] = day.to_dict()
-            for todo in day.todos.values():
-                d['todos'][todo.id_] = todo.to_dict()
         for id_, todo in self.todos.items():
             d['todos'][id_] = todo.to_dict()
         return d
 
-    # @property
-    # def all_todos(self):
-    #     todos = {}
-    #     for todo in self.todos_as_list:
-    #         todos[todo.id_] = todo
-    #     return todos 
-
-    @property
-    def selected_day(self):
-        if not self.selected_date in self.days.keys():
-            self.days[self.selected_date] = self.add_day(date=self.selected_date)
-            # print("DEBUG selected_day", self.days[self.selected_date].date)
-        return self.days[self.selected_date]
-
     def write(self):
         dates_to_purge = []
         for date, day in self.days.items():
@@ -481,193 +438,86 @@ class TodoDB(PlomDB):
             del self.days[date]
         self.write_text_to_db(json.dumps(self.to_dict()))
 
-    def add_task(self, id_=None, dict_source=None, return_id=False):
+    # properties 
+
+    @property
+    def selected_day(self):
+        if not self.selected_date in self.days.keys():
+            self.days[self.selected_date] = self.add_day(date=self.selected_date)
+        return self.days[self.selected_date]
+
+    # table manipulations 
+
+    def add_day(self, date, dict_source=None):
+        day = Day.from_dict(self, dict_source, date) if dict_source else Day(self, date)
+        self.days[date] = day 
+        return day
+
+    def add_task(self, id_=None, dict_source=None):
         id_ = id_ if id_ else str(uuid4())
         t = Task.from_dict(self, dict_source, id_) if dict_source else Task(self, id_)
         self.tasks[id_] = t
-        if return_id:
-            return id_, t
-        else:
-            return t
+        return t
+
+    def update_task(self, id_, title, default_effort, tags, subtask_ids, comment):
+        task = self.tasks[id_] if id_ in self.tasks.keys() else self.add_task(id_)
+        task.title.set(title)
+        task.default_effort.set(default_effort)
+        task.tags.set(tags)
+        task.subtask_ids.set(subtask_ids)
+        task.comment = comment 
+        return task
 
-    def add_todo(self, todo_dict=None, id_=None, task=None, efforts=None):
+    def add_todo(self, todo_dict=None, id_=None, task=None, efforts=None, link_into_day=True, adopt_if_possible=True):
         id_ = id_ if id_ else str(uuid4())
         if todo_dict:
             todo = Todo.from_dict(self, todo_dict, id_)
         elif task and efforts:
             todo = Todo(self, id_, task, efforts=efforts)
-            children = []
-            for child_id in task.links:
-                child_task = self.tasks[child_id]
-                children += [self.add_todo(task=child_task, efforts=efforts)]
-            todo.children = [child.id_ for child in children]
+            deps = []
+            for dep_task in task.subtasks:
+                # if Todo expects dependencies, adopt any compatibles found in DB.selected_date
+                # before creating new depended Todos
+                dep_todo = None
+                if adopt_if_possible and list(efforts.keys())[0] == self.selected_date:
+                    adoptable_todos = [t for t in self.selected_day.linked_todos_as_list
+                                       if t.task.id_ == dep_task.id_]
+                    if len(adoptable_todos) > 0:
+                        dep_todo = adoptable_todos[0]
+                if not dep_todo:
+                    dep_todo = self.add_todo(task=dep_task, efforts=efforts,
+                                               link_into_day=link_into_day,
+                                               adopt_if_possible=adopt_if_possible)
+                deps += [dep_todo]
+            todo.dep_ids = [dep.id_ for dep in deps]
         self.todos[id_] = todo 
+        if link_into_day:
+            self.selected_day.linked_todos_as_list += [todo] 
         return todo
 
-    def add_day(self, date, dict_source=None):
-        day = Day.from_dict(self, dict_source, date) if dict_source else Day(self, date)
-        self.days[date] = day 
-        return day
-
-    # def show_day(self, task_sort=None):
-    #     task_sort = task_sort if task_sort else 'title' 
-    #     current_date = datetime.strptime(self.selected_date, DATE_FORMAT)
-    #     prev_date = current_date - timedelta(days=1)
-    #     prev_date_str = prev_date.strftime(DATE_FORMAT)
-    #     next_date = current_date + timedelta(days=1)
-    #     next_date_str = next_date.strftime(DATE_FORMAT)
-    #     task_rows = []
-    #     for uuid, task in self.tasks.items():
-    #         if not task.visible:
-    #             continue
-    #         todo = None
-    #         if uuid in self.selected_day.todos.keys():
-    #             todo = self.selected_day.todos[uuid]
-    #             if not todo.visible:
-    #                 continue
-    #         task_rows += [{'uuid': uuid, 'task': task, 'todo': todo}] 
-    #     if task_sort == 'title':
-    #         task_rows.sort(key=lambda r: r['task'].title)
-    #     elif task_sort == 'default_effort':
-    #         task_rows.sort(key=lambda r: r['task'].default_effort, reverse=True)
-    #     elif task_sort == 'done':
-    #         task_rows.sort(key=lambda r: 0 if not r['todo'] else r['todo'].day_effort if r['todo'].day_effort else r['task'].default_effort if r['todo'].done else 0, reverse=True)
-    #     elif task_sort == 'importance':
-    #         task_rows.sort(key=lambda r: 0.0 if not r['todo'] else r['todo'].importance, reverse=True)
-    #     elif task_sort == 'chosen':
-    #         task_rows.sort(key=lambda r: False if not r['todo'] else True, reverse=True)
-    #     elif task_sort == 'comment':
-    #         task_rows.sort(key=lambda r: '' if not r['todo'] else r['todo'].comment, reverse=True)
-    #     done_tasks = []
-    #     for uuid, task in self.tasks.items():
-    #         if uuid in self.selected_day.todos.keys():
-    #             todo = self.selected_day.todos[uuid]
-    #             if todo.done:
-    #                 done_tasks += [todo]
-    #     done_tasks.sort(key=lambda t: t.effort, reverse=True)
-    #     return j2env.get_template('day.html').render(db=self, action=self.prefix+'/day', prev_date=prev_date_str, next_date=next_date_str, task_rows=task_rows, sort=task_sort, done_tasks=done_tasks)
-
-    def neighbor_dates(self):
-        current_date = datetime.strptime(self.selected_date, DATE_FORMAT)
-        prev_date = current_date - timedelta(days=1)
-        prev_date_str = prev_date.strftime(DATE_FORMAT)
-        next_date = current_date + timedelta(days=1)
-        next_date_str = next_date.strftime(DATE_FORMAT)
-        return prev_date_str, next_date_str
-
-    def show_do_day(self, sort_order=None):
-        prev_date_str, next_date_str = self.neighbor_dates()
-        todos = [t for t in self.selected_day.linked_todos_as_list if t.visible]
-        if sort_order == 'title':
-            todos.sort(key=lambda t: t.task.title)
-        elif sort_order == 'done':
-            todos.sort(key=lambda t: t.day_effort if t.day_effort else t.default_effort if t.done else 0, reverse=True)
-        elif sort_order == 'default_effort':
-            todos.sort(key=lambda t: t.default_effort, reverse=True)
-        elif sort_order == 'importance':
-            todos.sort(key=lambda t: t.importance, reverse=True)
-        return j2env.get_template('do_day.html').render(
-                day=self.selected_day,
-                tags=self.t_tags,
-                filter_and=self.t_filter_and,
-                filter_not=self.t_filter_not,
-                prev_date=prev_date_str,
-                next_date=next_date_str,
-                todos=todos,
-                sort=sort_order,
-                hide_done=self.hide_done)
-
-    def show_calendar(self, start_date_str, end_date_str):
-        self.t_filter_and = ['calendar']
-        self.t_filter_not = ['deleted']
-        self.set_visibilities()
-        days_to_show = {}
-        todays_date_str = str(datetime.now())[:10]
-        todays_date_obj = datetime.strptime(todays_date_str, DATE_FORMAT) 
-        yesterdays_date_obj = todays_date_obj - timedelta(1)
-        yesterdays_date_str = yesterdays_date_obj.strftime(DATE_FORMAT) 
-        start_date_obj = datetime.strptime(sorted(self.days.keys())[0], DATE_FORMAT)
-        if start_date_str and len(start_date_str) > 0:
-            if start_date_str in {'today', 'yesterday'}:
-                start_date_obj = todays_date_obj if start_date_str == 'today' else yesterdays_date_obj
-            else:
-                start_date_obj = datetime.strptime(start_date_str, DATE_FORMAT)
-        end_date_obj = datetime.strptime(sorted(self.days.keys())[-1], DATE_FORMAT)
-        if end_date_str and len(end_date_str) > 0:
-            if end_date_str in {'today', 'yesterday'}:
-                end_date_obj = todays_date_obj if end_date_str == 'today' else yesterdays_date_obj
-            else:
-                end_date_obj = datetime.strptime(end_date_str, DATE_FORMAT)
-        for n in range(int((end_date_obj - start_date_obj).days) + 1):
-            current_date_obj = start_date_obj + timedelta(n)
-            current_date_str = current_date_obj.strftime(DATE_FORMAT)
-            if current_date_str not in self.days.keys():
-                days_to_show[current_date_str] = self.add_day(current_date_str)
-            else:
-                days_to_show[current_date_str] = self.days[current_date_str]
-            days_to_show[current_date_str].weekday = datetime.strptime(current_date_str, DATE_FORMAT).strftime('%A')[:2]
-        return j2env.get_template('calendar.html').render(db=self, days=days_to_show, action=self.prefix+'/calendar', start_date=start_date_str, end_date=end_date_str)
-
-    def show_todo(self, id_, return_to):
-        todo = self.todos[id_]
-        # if selected_date not in self.days.keys():
-        #     self.days[selected_date] = self.add_day(test_date=f'3:{selected_date}') 
-        #     # print("DEBUG show_todo", self.days[selected_date].date)
-        # if task_uuid in self.days[selected_date].todos:
-        #     todo = self.days[selected_date].todos[task_uuid]
-        # else:
-        #     todo = self.days[selected_date].add_todo(task_uuid)
-        linked_todos = [self.todos[c] for c in todo.children]
-        filtered_todos = [] #[t for t in self.todos.values() if t.visible and t != self and (t not in linked_todos) and (len(search) == 0 or t.matches(search))] 
-        return j2env.get_template('todo.html').render(
-                db=self,
-                todo=todo,
-                filtered_todos=filtered_todos,
-                linked_todos=linked_todos,
-                return_to=return_to)
-
-    # def update_todo_mini(self, task_uuid, date, day_effort, done, importance):
-    #     if date not in self.days.keys():
-    #         self.days[date] = self.add_day(test_date=f'Y:{date}') 
-    #         # print("DEBUG update_todo_min", self.days[date].date)
-    #     if task_uuid in self.days[date].todos.keys():
-    #         todo = self.days[date].todos[task_uuid]
-    #     else:
-    #         todo = self.days[date].add_todo(task_uuid)
-    #     todo.day_effort = day_effort
-    #     todo.done = done
-    #     todo.importance = importance
-    #     return todo
-
-    def collect_tags(self, tags_joined, tags_checked):
-        tags = set()
-        for tag in [tag.strip() for tag in tags_joined.split(';') if tag.strip() != '']:
-            tags.add(tag)
-        for tag in tags_checked:
-            tags.add(tag)
-        return tags
-
-    def update_todo_for_day(self, id_, date, effort, done, comment, importance):
+    def _update_todo_shared(self, id_, done, comment, importance):
         todo = self.todos[id_]
         todo.done = done
-        todo.efforts[date] = effort 
         todo.comment = comment 
         todo.importance = importance 
+        return todo
+
+    def update_todo_for_day(self, id_, date, effort, done, comment, importance):
+        todo = self._update_todo_shared(id_, done, comment, importance)
+        todo.efforts[date] = effort 
 
-    def update_todo(self, id_, efforts, done, comment, day_tags_joined, day_tags_checked, importance):
-        if len(efforts) == 0:
+    def update_todo(self, id_, efforts, done, comment, tags, importance, deps):
+        todo = self._update_todo_shared(id_, done, comment, importance)
+        if len(efforts) == 0 and not todo.deps:
             raise PlomException('todo must have at least one effort!')
-        todo = self.todos[id_]
-        todo.done = done
+        todo.deps = deps 
         todo.efforts = efforts 
-        for date in todo.efforts:
+        for date in todo.efforts.keys():
             if not date in self.days.keys():
                 self.add_day(date=date) 
             if not self in self.days[date].linked_todos_as_list:
                 self.days[date].linked_todos_as_list += [todo]
-        todo.comment = comment 
-        todo.day_tags = self.collect_tags(day_tags_joined, day_tags_checked) 
-        todo.importance = importance 
+        todo.day_tags = tags
 
     def delete_todo(self, id_):
         todo = self.todos[id_]
@@ -676,102 +526,228 @@ class TodoDB(PlomDB):
             dates_to_delete += [date]
         for date in dates_to_delete:
             self.delete_effort(todo, date, force=True)
+        for depender in todo.dependers:
+            depender.dep_ids.remove(todo.id_)
         del self.todos[id_]
 
+    def delete_task(self, id_):
+        del self.tasks[id_]
+
     def delete_effort(self, todo, date, force=False):
         if (not force) and len(todo.efforts) == 1:
             raise PlomException('todo must retain at least one effort!')
         self.days[date].linked_todos_as_list.remove(todo)
         del todo.efforts[date]
 
+    # views
 
-    # def update_todo(self, task_uuid, date, day_effort, done, comment, day_tags_joined, day_tags_checked, importance):
-    #     day_effort = float(day_effort) if len(day_effort) > 0 else None
-    #     importance = float(importance)
-    #     todo = self.update_todo_mini(task_uuid, date, day_effort, done, importance)
-    #     todo.comment = comment
-    #     todo.day_tags = self.collect_tags(day_tags_joined, day_tags_checked) 
-
-    # def link_day_with_todo(self, date, todo_id):
-    #     print("DEBUG link", date, todo_id)
-    #     todo_creation_date, task_uuid = todo_id.split('_')
-    #     todo = self.days[todo_creation_date].todos[task_uuid]
-    #     if date in todo.efforts.keys():
-    #         raise PlomException('todo already linked to respective day')
-    #     todo.set_day_effort(date, None)
-    #     if date not in self.days.keys():
-    #         print("DEBUG link_day_with_todo", date)
-    #         self.days[date] = self.add_day(test_date=f'Z:{date}') 
-    #     self.days[date].linked_todos_as_list += [todo]
-    #     print("DEBUG", date, self.days[date].linked_todos)
-
-    def show_task(self, id_, return_to='', search=''):
-        task = self.tasks[id_] if id_ else self.add_task()
-        selected = task.id_ in self.selected_day.todos.keys()
-        linked_tasks = [self.tasks[l] for l in task.links]
-        filtered_tasks = [t for t in self.tasks.values() if t.visible and t != self and (t not in linked_tasks) and (len(search) == 0 or t.matches(search))] 
-        return j2env.get_template('task.html').render(
-                db=self,
-                search=search,
-                tags=self.t_tags, 
-                filter_and=self.t_filter_and,
-                filter_not=self.t_filter_not,
-                filtered_tasks=filtered_tasks,
-                linked_tasks=linked_tasks,
-                task=task,
-                return_to=return_to)
+    def show_message(self, message):
+        return j2env.get_template('message.html').render(message=message)
 
-    def update_task(self, id_, title, default_effort, tags_joined, tags_checked, links, comment):
-        task = self.tasks[id_] if id_ in self.tasks.keys() else self.add_task(id_)
-        task.title = title
-        task.default_effort = float(default_effort) if len(default_effort) > 0 else None
-        task.tags = self.collect_tags(tags_joined, tags_checked) 
-        task.links = links
-        task.comment = comment 
+    def show_calendar(self, start_date_str, end_date_str):
+        self.tag_filter_and = ['calendar']
+        self.tag_filter_not = ['deleted']
+        self.set_visibilities()
+        start_date_obj, end_date_obj = self.get_limit_days_from_date_strings(start_date_str, end_date_str)
+        days_to_show = {}
+        for n in range(int((end_date_obj - start_date_obj).days) + 1):
+            date_obj = start_date_obj + timedelta(n)
+            date_str = date_obj.strftime(DATE_FORMAT)
+            if date_str not in self.days.keys():
+                days_to_show[date_str] = self.add_day(date_str)
+            else:
+                days_to_show[date_str] = self.days[date_str]
+            days_to_show[date_str].month_title = date_obj.strftime('%B') if date_obj.day == 1 else None 
+            days_to_show[date_str].weekday = datetime.strptime(date_str, DATE_FORMAT).strftime('%A')[:2]
 
-    def show_tasks(self, expand_uuid):
-        expanded_tasks = {}
-        if expand_uuid:
-            for uuid in self.tasks[expand_uuid].links:
-                expanded_tasks[uuid] = self.tasks[uuid]
-        return j2env.get_template('tasks.html').render(db=self, action=self.prefix+'/tasks', expand_uuid=expand_uuid, expanded_tasks=expanded_tasks)
+        return j2env.get_template('calendar.html').render(
+                selected_date=self.selected_date,
+                days=days_to_show,
+                start_date=start_date_str,
+                end_date=end_date_str)
 
-    def show_new_day(self, search, hide_chosen_tasks, sort_order=None):
+    def show_do_todos(self, sort_order=None):
         prev_date_str, next_date_str = self.neighbor_dates()
-        chosen_todos = self.selected_day.linked_todos_as_list
-        relevant_todos = []
+        adoptable_past_todos = []
         for todo in self.todos.values():
-            if todo.done or (not todo.visible) or (not todo.matches(search)) or todo in self.selected_day.linked_todos_as_list: # or todo.day.date == self.selected_day.date:  # TODO or todo is linked by day  
-                continue
-            relevant_todos += [todo] 
-        tasks = []
-        chosen_tasks = [todo.task for todo in self.selected_day.linked_todos_as_list]
-        for uuid, task in self.tasks.items():
-            if (not task.visible) or (not task.matches(search)) or (hide_chosen_tasks and task in chosen_tasks):
+            if todo.done\
+                    or (not todo.visible)\
+                    or todo.earliest_date >= self.selected_date:
                 continue
-            tasks += [task]
+            adoptable_past_todos += [todo] 
+        todos = [t for t in self.selected_day.linked_todos_as_list
+                 if t.visible]
+                 # and not t.deps]
         if sort_order == 'title':
-            chosen_todos.sort(key=lambda t: t.title)
-            relevant_todos.sort(key=lambda t: t.title)
-            tasks.sort(key=lambda t: t.title)
-        elif sort_order == 'effort':
-            chosen_todos.sort(key=lambda t: t.day_effort if t.day_effort else t.default_effort if t.done else 0, reverse=True)
-            relevant_todos.sort(key=lambda t: t.total_effort, reverse=True)
-            tasks.sort(key=lambda t: t.default_effort, reverse=True)
-        return j2env.get_template('new_day.html').render(
-                sort=sort_order,
-                tags=self.t_tags,
-                chosen_todos=chosen_todos,
-                filter_and=self.t_filter_and,
-                filter_not=self.t_filter_not,
+            todos.sort(key=lambda t: t.task.title.then)
+        elif sort_order == 'done':
+            todos.sort(key=lambda t: t.day_effort if t.day_effort else t.default_effort if t.done else 0, reverse=True)
+        elif sort_order == 'default_effort':
+            todos.sort(key=lambda t: t.default_effort, reverse=True)
+        elif sort_order == 'importance':
+            todos.sort(key=lambda t: t.importance, reverse=True)
+        return j2env.get_template('do_todos.html').render(
                 day=self.selected_day,
+                tags=self.t_tags,
+                filter_and=self.tag_filter_and,
+                filter_not=self.tag_filter_not,
                 prev_date=prev_date_str,
+                adoptable_past_todos=adoptable_past_todos,
                 next_date=next_date_str,
-                tasks=tasks,
-                hide_chosen_tasks=hide_chosen_tasks,
-                relevant_todos=relevant_todos,
+                all_tasks=[t for t in self.tasks.values()],
+                todos=todos,
+                sort=sort_order,
+                hide_done=self.hide_done)
+
+    def show_todo(self, id_, start_date, end_date):
+        todo = self.todos[id_]
+        filtered_tasks = [t for t in self.tasks.values()
+                          if t != todo.task] 
+        filtered_todos = [t for t in self.todos.values()
+                          if t != todo]
+
+        # if going into the past, only allow 3-day ranges 
+        start_day, end_day = self.get_limit_days_from_date_strings(start_date, end_date)
+        if start_day < datetime.now() - timedelta(days=2):
+            end_day = start_day + timedelta(days=3)
+            end_date = end_day.strftime(DATE_FORMAT)
+        legal_dates = []
+        for n in range(int((end_day - start_day).days) + 1):
+            day = start_day + timedelta(n)
+            legal_dates += [day.strftime(DATE_FORMAT)]
+        date_filtered_todos = [] 
+        for date in legal_dates:
+            for filtered_todo in filtered_todos:
+                if filtered_todo in date_filtered_todos:
+                    continue
+                if date in filtered_todo.efforts.keys():
+                    date_filtered_todos += [filtered_todo]
+
+        return j2env.get_template('todo.html').render(
+                tags=self.t_tags,
+                todo=todo,
+                filtered_todos=date_filtered_todos,
+                filtered_tasks=filtered_tasks,
+                dep_todos=todo.deps,
+                start_date=start_date,
+                end_date=end_date)
+
+    def show_task(self, id_):
+        task = self.tasks[id_] if id_ else self.add_task()
+        if not id_:
+            task.default_effort.set(1.0)
+        filtered_tasks = [t for t in self.tasks.values()
+                          if t != task
+                          and (t not in task.subtasks)]
+        return j2env.get_template('task.html').render(
+                selected_date=self.selected_date,
+                tags=self.t_tags, 
+                filtered_tasks=filtered_tasks,
+                task=task)
+
+    def show_tasks(self, search, sort_order=None):
+        filtered_tasks = [] 
+        for task in [t for t in self.tasks.values() if (not search) or t.matches(search)]:
+            filtered_tasks += [task]
+        if sort_order == 'title':
+            filtered_tasks.sort(key=lambda t: t.title.now)
+        elif sort_order == 'default_effort':
+            filtered_tasks.sort(key=lambda t: t.default_effort.now, reverse=True)
+        elif sort_order == 'depth':
+            filtered_tasks.sort(key=lambda t: t.subtask_depth, reverse=True)
+        return j2env.get_template('tasks.html').render(
+                sort=sort_order,
+                tasks=filtered_tasks,
+                tags=self.t_tags,
+                filter_and=self.tag_filter_and,
+                filter_not=self.tag_filter_not,
                 search=search)
 
+    # def show_pick_tasks(self, search, hide_chosen_tasks, sort_order=None):
+    #     prev_date_str, next_date_str = self.neighbor_dates()
+
+    #     chosen_todos = self.selected_day.linked_todos_as_list
+
+    #     relevant_todos = []
+    #     for todo in self.todos.values():
+    #         if todo.done\
+    #                 or (not todo.visible)\
+    #                 or (not todo.matches(search))\
+    #                 or todo.earliest_date >= self.selected_date:
+    #             continue
+    #         relevant_todos += [todo] 
+
+    #     filtered_tasks = []
+    #     chosen_tasks = [todo.task for todo in self.selected_day.linked_todos_as_list]
+    #     for uuid, task in self.tasks.items():
+    #         if (not task.visible)\
+    #                 or (not task.matches(search))\
+    #                 or (hide_chosen_tasks and task in chosen_tasks):
+    #             continue
+    #         filtered_tasks += [task]
+
+    #     if sort_order == 'title':
+    #         chosen_todos.sort(key=lambda t: t.title)
+    #         relevant_todos.sort(key=lambda t: t.dated_title)
+    #         tasks.sort(key=lambda t: t.title.then)
+    #     elif sort_order == 'effort':
+    #         chosen_todos.sort(key=lambda t:
+    #                           t.day_effort if t.day_effort else (t.default_effort if t.done else 0),
+    #                           reverse=True)
+    #         relevant_todos.sort(key=lambda t: t.all_days_effort, reverse=True)
+    #         filtered_tasks.sort(key=lambda t: t.default_effort.then, reverse=True)
+
+    #     return j2env.get_template('pick_tasks.html').render(
+    #             sort=sort_order,
+    #             tags=self.t_tags,
+    #             chosen_todos=chosen_todos,
+    #             filter_and=self.tag_filter_and,
+    #             filter_not=self.tag_filter_not,
+    #             day=self.selected_day,
+    #             prev_date=prev_date_str,
+    #             next_date=next_date_str,
+    #             all_tasks=[t for t in self.tasks.values()],
+    #             filtered_tasks=filtered_tasks,
+    #             hide_chosen_tasks=hide_chosen_tasks,
+    #             relevant_todos=relevant_todos,
+    #             search=search)
+
+    # helpers
+
+    def set_visibilities(self):
+        for uuid, t in self.tasks.items():
+            t.visible = len([tag for tag in self.tag_filter_and if not tag in t.tags.now]) == 0\
+                    and len([tag for tag in self.tag_filter_not if tag in t.tags.now]) == 0\
+                    and ((not self.hide_unchosen) or uuid in self.selected_day.todos.keys())
+        for todo in self.todos.values():
+            todo.visible = len([tag for tag in self.tag_filter_and if not tag in todo.day_tags | todo.task.tags.now ]) == 0\
+                and len([tag for tag in self.tag_filter_not if tag in todo.day_tags | todo.task.tags.now ]) == 0\
+                and ((not self.hide_done) or (not todo.done))
+
+    def get_limit_days_from_date_strings(self, start_date_str, end_date_str):
+        todays_date_obj = datetime.strptime(today_date(), DATE_FORMAT) 
+        yesterdays_date_obj = todays_date_obj - timedelta(1)
+        def get_day_limit_obj(index, day_limit_string):
+            date_obj = datetime.strptime(sorted(self.days.keys())[index], DATE_FORMAT)
+            if day_limit_string and len(day_limit_string) > 0:
+                if day_limit_string in {'today', 'yesterday'}:
+                    date_obj = todays_date_obj if day_limit_string == 'today' else yesterdays_date_obj
+                else:
+                    date_obj = datetime.strptime(day_limit_string, DATE_FORMAT)
+            return date_obj
+        start_date_obj = get_day_limit_obj(0, start_date_str)
+        end_date_obj = get_day_limit_obj(-1, end_date_str)
+        return start_date_obj, end_date_obj
+
+    def neighbor_dates(self):
+        current_date = datetime.strptime(self.selected_date, DATE_FORMAT)
+        prev_date = current_date - timedelta(days=1)
+        prev_date_str = prev_date.strftime(DATE_FORMAT)
+        next_date = current_date + timedelta(days=1)
+        next_date_str = next_date.strftime(DATE_FORMAT)
+        return prev_date_str, next_date_str
+
+
 
 class ParamsParser:
 
@@ -786,38 +762,71 @@ class ParamsParser:
             param = param != '0' 
         return param 
 
-    def get_cookied(self, key, default=None):
+    def cookie_key_from_params_key(self, prefix, key):
+        return f'{prefix}:{key}' if prefix else key
+
+    def get_cookied(self, key, default=None, prefix=None):
+        cookie_key = self.cookie_key_from_params_key(prefix, key) 
         param = self.get(key, default)
         if param == '-':
             param = None
-            if key in self.cookie_db.keys():
-                del self.cookie_db[key]
-        if param is None and key in self.cookie_db.keys():
-            param = self.cookie_db[key]
+            if cookie_key in self.cookie_db.keys():
+                del self.cookie_db[cookie_key]
+        if param is None and cookie_key in self.cookie_db.keys():
+            param = self.cookie_db[cookie_key]
         if param is not None:
-            self.cookie_db[key] = param
+            self.cookie_db[cookie_key] = param
         return param
 
-    def get_cookied_chain(self, key, default=None):
-        # default = default if default else ['-']
+    def get_cookied_chain(self, key, default=None, prefix=None):
+        cookie_key = self.cookie_key_from_params_key(prefix, key) 
         params = self.params.get(key, default)
         if params == ['-']:
             params = None 
-            if key in self.cookie_db.keys():
-                del self.cookie_db[key]
-        if params is None and key in self.cookie_db.keys():
-            params = self.cookie_db[key]
+            if cookie_key in self.cookie_db.keys():
+                del self.cookie_db[cookie_key]
+        if params is None and cookie_key in self.cookie_db.keys():
+            params = self.cookie_db[cookie_key]
         if params is not None:
-            self.cookie_db[key] = params
+            self.cookie_db[cookie_key] = params
         return params
 
 
+class PostvarsParser:
+
+    def __init__(self, postvars):
+        self.postvars = postvars
+
+    def has(self, key):
+        return key in self.postvars.keys()
+
+    def get(self, key, on_empty=None, float_if_possible=False):
+        return self.get_at_index(key, 0, on_empty, float_if_possible)
+
+    def get_at_index(self, key, i, on_empty=None, float_if_possible=False):
+        if self.has(key) and len(self.postvars[key][i]) > 0:
+            val = self.postvars[key][i] 
+        else:
+            val = on_empty 
+        if float_if_possible and val is not None:
+            return float(val)
+        else:
+            return val 
+
+    def get_all(self, key, on_empty=None):
+        if self.has(key) and len(self.postvars[key]) > 0:
+            return [v for v in self.postvars[key] if len(v) > 0]
+        return on_empty
+
+    def set(self, key, value):
+        self.postvars[key] = [value]
+
+
 class TodoHandler(PlomHandler):
 
     def config_init(self):
         return {
             'cookie_name': 'todo_cookie',
-            'prefix': '',
             'cookie_path': '/'
         }
 
@@ -825,291 +834,241 @@ class TodoHandler(PlomHandler):
         default_path = '/todo'
         handler.add_route('GET', default_path, self.show_db)
         handler.add_route('POST', default_path, self.write_db)
-        return 'todo', {'cookie_name': 'todo_cookie', 'prefix': default_path, 'cookie_path': default_path}
+        return 'todo', {'cookie_name': 'todo_cookie', 'cookie_path': default_path}
 
     def do_POST(self):
-        self.try_do(self.config_init)
         self.try_do(self.write_db)
 
     def write_db(self):
         from urllib.parse import urlencode
         config = self.apps['todo'] if hasattr(self, 'apps') else self.config_init()
-        length = int(self.headers['content-length'])
-        postvars = parse_qs(self.rfile.read(length).decode(), keep_blank_values=1)
         parsed_url = urlparse(self.path)
-        site = path_split(urlparse(self.path).path)[1]
-        # site = path_split(parsed_url.path)[1]
-        db = TodoDB(prefix=config['prefix'])
+        site = path_split(parsed_url.path)[1]
+        length = int(self.headers['content-length'])
+        postvars = PostvarsParser(parse_qs(self.rfile.read(length).decode(), keep_blank_values=1))
+
+        db = TodoDB()
         redir_params = []
-        for param_name, filter_db_name in {('t_and', 't_filter_and'), ('t_not', 't_filter_not')}:
+        # if we do encounter a filter post, we repost it (and if empty, the emptying command '-')
+        for param_name, filter_db_name in {('and_tag', 'tag_filter_and'), ('not_tag', 'tag_filter_not')}:
             filter_db = getattr(db, filter_db_name)
-            if param_name in postvars.keys():
-                for target in postvars[param_name]:
+            if postvars.has(param_name): 
+                for target in postvars.get_all(param_name, []):
                     if len(target) > 0 and not target in filter_db:
                         filter_db += [target]
                 if len(filter_db) == 0:
                     redir_params += [(param_name, '-')]
             redir_params += [(param_name, f) for f in filter_db]
-
-        def collect_checked(prefix, postvars):
-            tags_checked = []
-            for k in postvars.keys():
-                if k.startswith(prefix):
-                    tags_checked += [k[len(prefix):]]
-            return tags_checked
+        if site in {'calendar', 'todo'}:
+            redir_params += [('end', postvars.get('end', '-'))]
+            redir_params += [('start', postvars.get('start', '-'))]
+        # if site in {'tasks', 'pick_tasks'}:
+        #     redir_params += [('search', postvars.get('search', ''))]
+        if postvars.has('filter'): 
+            postvars.set('return_to', '')
         
-        if 'calendar' == site:
-            redir_params += [('start', postvars['start'][0] if len(postvars['start'][0]) > 0 else '-')]
-            redir_params += [('end', postvars['end'][0] if len(postvars['end'][0]) > 0 else '-')]
+        if 'tasks' == site:
+            redir_params += [('search', postvars.get('search', ''))]
 
         elif 'todo' == site:
-            # task_uuid = postvars['task_uuid'][0]
-            todo_id = postvars['todo_id'][0]
-            # date = postvars['date'][0]
-            old_todo = db.todos[todo_id] 
+            todo_id = postvars.get('todo_id')
+            redir_params += [('id', todo_id)]
+            old_todo = db.todos[todo_id] if todo_id in db.todos.keys() else None
             efforts = {}
-            for i, date in enumerate(postvars['effort_date']):
+            latest_date = db.selected_date 
+            for i, date in enumerate(postvars.get_all('effort_date', [])):
                 if '' == date:
                     continue
-                efforts[date] = float(postvars['effort'][i]) if len(postvars['effort'][i]) > 0 else None 
-            if 'delete_effort' in postvars.keys():
-                for date in postvars['delete_effort']:
-                    del efforts[date]
-            if 'delete' in postvars.keys():
-                # old_todo = db.days[date].todos[task_uuid]
-                if 'done' in postvars or postvars['comment'][0] != '' or len(collect_checked('day_tag_', postvars)) > 0 or postvars['joined_day_tags'][0] != '' or len(efforts) > 0:
+                try:
+                    datetime.strptime(date, DATE_FORMAT)
+                except ValueError:
+                    raise PlomException(f'bad date string')
+                latest_date = date
+                efforts[date] = None
+                if not (old_todo and old_todo.deps):
+                    efforts[date] = postvars.get_at_index('effort', i, on_empty=None,
+                                                          float_if_possible=True)
+            if postvars.has('delete'): 
+                has_day_effort = len([e for e in efforts.values() if e is not None]) > 0
+                if postvars.has('done')\
+                        or postvars.get('comment')\
+                        or postvars.get_all('tag', [])\
+                        or has_day_effort:
                     raise PlomException('will not remove todo of preserve-worthy values')
                 db.delete_todo(todo_id) 
-                # db.write()
-                # self.redirect('new_day')
-            else:
-                # redir_params += [('task', task_uuid), ('date', date)]
-                redir_params += [('id', todo_id)]
-                # db.update_todo(task_uuid, date, postvars['day_effort'][0], 'done' in postvars.keys(), postvars['comment'][0], postvars['joined_day_tags'][0], collect_checked('day_tag_', postvars), postvars['importance'][0])
-                # efforts = {}
-                # for i, date in enumerate(postvars['effort_date']):
-                #     if '' == date:
-                #         continue
-                #     efforts[date] = postvars['effort'][i] if len(postvars['effort'][i]) > 0 else None 
-                if 'delete_effort' in postvars.keys():
-                    for date in postvars['delete_effort']:
+                postvars.set('return_to', 'calendar')
+            elif postvars.has('update'):
+                if postvars.has('delete_effort'):
+                    for date in postvars.get_all('delete_effort'):
                         db.delete_effort(old_todo, date)
+                        del efforts[date]
+                deps = [db.todos[id_] for id_ in postvars.get_all('adopt_dep', [])
+                        if id_ in db.todos.keys()] 
+                for dep in deps:
+                    if not todo_id in [t.id_ for t in dep.dependers]:
+                        dep.dependers += [db.todos[todo_id]]
+                tasks_to_birth = [db.tasks[id_] for id_ in postvars.get_all('birth_dep', [])]
+                for task in tasks_to_birth:
+                    deps += [db.add_todo(task=task, efforts={latest_date: None})]
                 db.update_todo(id_=todo_id,
                                efforts=efforts,
-                               done='done' in postvars.keys(),
-                               comment=postvars['comment'][0],
-                               day_tags_joined=postvars['joined_day_tags'][0],
-                               day_tags_checked=collect_checked('day_tag_', postvars),
-                               importance=float(postvars['importance'][0]))
+                               done=postvars.has('done'),
+                               comment=postvars.get('comment', ''),
+                               tags=postvars.get_all('tag', []),
+                               importance=float(postvars.get('importance')),
+                               deps=deps)
 
         elif 'task' == site:
-            id_ = postvars['id'][0]
-            redir_params += [('id', id_)]
-            if 'filter' in postvars.keys():
-                redir_params += [('search', postvars['search'][0])]
-            elif 'title' in postvars.keys():
-                links = [] if not 'link_task' in postvars.keys() else postvars['link_task']
-                # db.update_task(id_, postvars['title'][0], postvars['default_effort'][0], postvars['joined_tags'][0], collect_checked('tag_', postvars), collect_checked('link_', postvars), postvars['comment'][0])
-                db.update_task(id_, postvars['title'][0], postvars['default_effort'][0], postvars['joined_tags'][0], collect_checked('tag_', postvars), links, postvars['comment'][0])
-                # if 'as_todo' in postvars.keys() and id_ not in db.selected_day.todos.keys():
-                #     db.update_todo_mini(id_, db.selected_date, None, False, 1.0)
-                # elif 'as_todo' not in postvars.keys() and id_ in db.selected_day.todos.keys():
-                #     todo = db.selected_day.todos[id_]
-                #     if todo.internals_empty() and (not todo.done) and todo.day_effort is None:
-                #         del db.selected_day.todos[id_]
-                #     else:
-                #         raise PlomException('cannot deselect task as todo of preserve-worthy values')
-
-        elif 'new_day' == site:
-            if 'filter' in postvars.keys():
-                redir_params += [('search', postvars['search'][0])]
-                redir_params += [('hide_chosen_tasks', int('hide_chosen_tasks' in postvars.keys()))]
-            else:
-                db.selected_date = postvars['date'][0]
-                todos_to_shrink = []
-                todos_to_delete = []
-                for todo in db.selected_day.linked_todos_as_list:
-                    if todo.visible and not ('chosen_todo' in postvars.keys() and todo.id_ in postvars['chosen_todo']):
-                        if len(todo.comment) > 0 or len(todo.day_tags) > 0 or not todo.is_effort_removable(db.selected_date):
-                            # print("DEBUG", len(todo.comment) > 0, len(todo.day_tags) > 0, todo.is_effort_removable(db.selected_date))
-                            raise PlomException('will not remove effort of preserve-worthy values')
-                        if len(todo.efforts) > 1:
-                            todos_to_shrink += [todo]
-                            # db.delete_effort(todo, db.selected_date)
-                        else:
-                            todos_to_delete += [todo]
-                            # db.delete_todo(todo.id_)
-                for todo in todos_to_shrink:
-                    db.delete_effort(todo, db.selected_date)
-                for todo in todos_to_delete:
-                    db.delete_todo(todo.id_)
-                if 'choose_task' in postvars.keys():
-                    for id_ in postvars['choose_task']:
-                        db.add_todo(task=db.tasks[id_], efforts={db.selected_date: None})
-                if 'choose_todo' in postvars.keys():
-                    for id_ in postvars['choose_todo']:
-                        todo = db.todos[id_]
-                        todo.efforts[db.selected_date] = None
-
-            # if 'choose_task' in postvars.keys():
-            #     for i, uuid in enumerate(postvars['choose_task']):
-            #          if not uuid in db.selected_day.todos.keys():
-            #             # task = db.tasks[uuid]
-            #              db.update_todo_mini(uuid, db.selected_date, None, False, 1.0)
-            # if 'choose_todo' in postvars.keys():
-            #     for i, id_ in enumerate(postvars['choose_todo']):
-            #         if not id_ in [todo.id_ for todo in db.selected_day.linked_todos_as_list]:
-            #             db.link_day_with_todo(db.selected_date, id_)
-
-        elif 'do_day' == site:
-            if 'filter' in postvars.keys():
-                redir_params += [('hide_done', int('hide_done' in postvars.keys()))]
-            else:
-                db.selected_date = postvars['date'][0]
+            task_id = postvars.get('task_id')
+            if postvars.has('delete') and task_id in db.tasks.keys():
+                if [t for t in db.todos.values() if task_id == t.task.id_]:
+                    raise PlomException('will not remove Task describing existing Todos')
+                if postvars.get('title', '')\
+                        or postvars.get_all('tag', [])\
+                        or postvars.get_all('subtask', [])\
+                        or postvars.get('comment', ''):
+                    raise PlomException('will not remove Task of preserve-worthy values')
+                db.delete_task(task_id)
+            elif postvars.has('update'):
+                task = db.update_task(
+                        id_=task_id,
+                        title=postvars.get('title', ''),
+                        default_effort=postvars.get('default_effort', float_if_possible=True), 
+                        tags=postvars.get_all('tag', []),
+                        subtask_ids=postvars.get_all('subtask', []),
+                        comment=postvars.get('comment', ''))
+                if postvars.has('add_as_todo'):
+                    db.add_todo(task=task, efforts={postvars.get('selected_date'): None})
+            redir_params += [('id', task_id)]
+
+        # elif 'pick_tasks' == site:
+        #     redir_params += [('hide_chosen_tasks', int(postvars.has('hide_chosen_tasks')))]
+        #     if postvars.has('update'):
+        #         db.selected_date = postvars.get('date')
+        #         todos_to_shrink = []
+        #         todos_to_delete = []
+        #         for todo in db.selected_day.linked_todos_as_list:
+        #             if todo.visible and not todo.id_ in postvars.get_all('chosen_todo', []):
+        #                 if len(todo.comment) > 0\
+        #                         or len(todo.day_tags) > 0\
+        #                         or not todo.is_effort_removable(db.selected_date):
+        #                     raise PlomException('will not remove effort of preserve-worthy values')
+        #                 if len(todo.efforts) > 1:
+        #                     todos_to_shrink += [todo]
+        #                 else:
+        #                     todos_to_delete += [todo]
+        #         for todo in todos_to_shrink:
+        #             db.delete_effort(todo, db.selected_date)
+        #         for todo in todos_to_delete:
+        #             db.delete_todo(todo.id_)
+        #         for id_ in postvars.get_all('choose_task', []):
+        #             db.add_todo(task=db.tasks[id_], efforts={db.selected_date: None})
+        #         for id_ in postvars.get_all('choose_todo', []):
+        #             db.todos[id_].efforts[db.selected_date] = None
+
+        elif 'do_todos' == site:
+            redir_params += [('hide_done', int(postvars.has('hide_done')))]
+            if postvars.has('update'): 
+                db.selected_date = postvars.get('date') 
                 redir_params += [('date', db.selected_date)]
-                db.selected_day.comment = postvars['day_comment'][0]
-                if 'todo_id' in postvars.keys():
-                    for i, todo_id in enumerate(postvars['todo_id']):
-                        old_todo = None if not todo_id in db.todos.keys() else db.todos[todo_id]
-                        done = ('done' in postvars) and (todo_id in postvars['done'])
-                        day_effort_input = postvars['effort'][i]
-                        day_effort = float(day_effort_input) if len(day_effort_input) > 0 else None
-                        comment = postvars['effort_comment'][i]
-                        importance = float(postvars['importance'][i])
-                        if old_todo and old_todo.done == done and old_todo.day_effort == day_effort and comment == old_todo.comment and old_todo.importance == importance:
-                            continue
-                        db.update_todo_for_day(todo_id, db.selected_date, day_effort, done, comment, importance)
-
-        elif 'day' == site:
-            # always store the two hide params in the URL if possible … TODO: find out if really necessary
-            if 'expect_unchosen_done' in postvars.keys():
-                redir_params += [('hide_unchosen', int('hide_unchosen' in postvars.keys()))] + [('hide_done', int('hide_done' in postvars.keys()))]
-
-            if 'date' in postvars.keys():
-                db.selected_date = postvars['date'][0]
-                if 'day_comment' in postvars.keys():
-                    db.selected_day.comment = postvars['day_comment'][0]
-                redir_params += [('date', db.selected_date)]
-
-                # handle todo list updates via task UUIDs
-                if 't_uuid' in postvars.keys():
-                    for i, uuid in enumerate(postvars['t_uuid']):
-                        task = db.tasks[uuid]
-                        old_todo = None if not uuid in db.selected_day.todos.keys() else db.selected_day.todos[uuid]
-                        selects_as_todo = 'choose' in postvars and uuid in postvars['choose']
-                        too_much_keepworthy_data = ('done' in postvars and uuid in postvars['done']) or postvars['day_effort'][i] != '' or (old_todo and not old_todo.internals_empty())
-                        if old_todo and too_much_keepworthy_data and not selects_as_todo:
-                            raise PlomException('cannot deselect task as todo of preserve-worthy values')
-                        elif old_todo and not selects_as_todo:
-                            del db.selected_day.todos[uuid]
-                        elif too_much_keepworthy_data or selects_as_todo:
-                            done = ('done' in postvars) and (uuid in postvars['done'])
-                            day_effort_input = postvars['day_effort'][i]
-                            day_effort = float(day_effort_input) if len(day_effort_input) > 0 else None
-                            importance = float(postvars['importance'][i])
-                            if old_todo and old_todo.done == done and old_todo.day_effort == day_effort and old_todo.importance == importance:
-                                continue
-                            db.update_todo_mini(uuid, db.selected_date, day_effort, done, importance)
-
-        if 'return_to' in postvars.keys() and len(postvars['return_to'][0]) > 0:
-            homepage = postvars['return_to'][0]
-        else:
+                db.selected_day.comment = postvars.get('day_comment', '') 
+                task_id = postvars.get('choose_task', None)
+                if task_id:
+                    if task_id not in db.tasks.keys():
+                        raise PlomException('illegal task ID entered')
+                    db.add_todo(task=db.tasks[task_id], efforts={db.selected_date: None},
+                                adopt_if_possible=(not postvars.has('dont_adopt')))
+                for id_ in postvars.get_all('choose_todo', []):
+                    db.todos[id_].efforts[db.selected_date] = None
+                for i, todo_id in enumerate(postvars.get_all('todo_id', [])):
+                    old_todo = db.todos[todo_id]
+                    done = todo_id in postvars.get_all('done', [])
+                    day_effort_input = postvars.get_at_index('effort', i, '') 
+                    day_effort = float(day_effort_input) if len(day_effort_input) > 0 else None
+                    comment = postvars.get_at_index('effort_comment', i, '') 
+                    if (day_effort is not None) and (not done) and day_effort < 0 and 0 == len(comment):
+                        if len(old_todo.efforts) > 1:
+                            db.delete_effort(old_todo, db.selected_date) 
+                        else:
+                            db.delete_todo(todo_id)
+                        continue
+                    importance = float(postvars.get_at_index('importance', i))
+                    if old_todo\
+                            and old_todo.done == done\
+                            and old_todo.day_effort == day_effort\
+                            and comment == old_todo.comment\
+                            and old_todo.importance == importance:
+                        continue
+                    db.update_todo_for_day(
+                            todo_id,
+                            db.selected_date,
+                            day_effort,
+                            done,
+                            comment,
+                            importance)
+
+        homepage = postvars.get('return_to')
+        if not homepage:
             encoded_params = urlencode(redir_params)
-            # homepage = f'{parsed_url.path}?{encoded_params}'
             homepage = f'{site}?{encoded_params}'
         db.write()
         self.redirect(homepage)
 
     def do_GET(self):
-        self.try_do(self.config_init)
         self.try_do(self.show_db)
 
     def show_db(self):
         config = self.apps['todo'] if hasattr(self, 'apps') else self.config_init()
-        cookie_db = self.get_cookie_db(config['cookie_name'])
         parsed_url = urlparse(self.path)
         site = path_split(parsed_url.path)[1]
-        # params = parse_qs(parsed_url.query)
+        cookie_db = self.get_cookie_db(config['cookie_name'])
         params = ParamsParser(parsed_url.query, cookie_db)
 
-        # def get_param(param_name, boolean=False, chained=False, none_as_empty_string=False):
-        #     if chained:
-        #         param = params.get(param_name, None)
-        #     elif none_as_empty_string:
-        #         param = params.get(param_name, [''])[0]
-        #     else: 
-        #         param = params.get(param_name, [None])[0]
-        #     if (not chained and param == '-') or (chained and param == ['-']):
-        #         param = None
-        #         if param_name in cookie_db.keys():
-        #             del cookie_db[param_name]
-        #     if param is None and param_name in cookie_db.keys():
-        #         param = cookie_db[param_name]
-        #     if param is not None:
-        #         if boolean:
-        #             param = param != '0'
-        #             cookie_db[param_name] = str(int(param))
-        #         else:
-        #             cookie_db[param_name] = param
-        #     elif param is boolean:
-        #         param = False
-        #     return param
-
-        selected_date = t_filter_and = t_filter_not = None
+        selected_date = tag_filter_and = tag_filter_not = None
         hide_unchosen = hide_done = False
-        # return_to = params.get('return_to', [''])[0]
         return_to = params.get('return_to', '')
-        if site in {'do_day', 'new_day'}:
+        if site in {'do_todos', 'calendar', 'task'}:
             selected_date = params.get_cookied('date')
-        if site in {'do_day', 'new_day', 'task'}:
-            t_filter_and = params.get_cookied_chain('t_and')
-            # t_filter_not = params.get_cookied_chain('t_not', ['deleted', 'cancelled'])
-            t_filter_not = params.get_cookied_chain('t_not')
-        # if site in {'day','tasks', 'task', 'new_day'}:
-        #     t_filter_and = get_param('t_and', chained=True)
-        #     t_filter_not = get_param('t_not', chained=True)
-        if 'do_day' == site:
-            # hide_unchosen = get_param('hide_unchosen', boolean=True)
+        if site in {'do_todos', 'tasks'}:
+            tag_filter_and = params.get_cookied_chain('and_tag', prefix=site)
+            tag_filter_not = params.get_cookied_chain('not_tag', prefix=site)
+        if 'do_todos' == site:
             hide_done = params.get('hide_done', False) 
-        db = TodoDB(config['prefix'], selected_date, t_filter_and, t_filter_not, hide_unchosen, hide_done)
-        if 'do_day' == site:
-            sort_order = params.get_cookied('sort')
-            page = db.show_do_day(sort_order)
-        elif 'new_day' == site:
-            sort_order = params.get_cookied('sort')
-            hide_chosen_tasks = params.get('hide_chosen_tasks', False)
-            search = params.get('search', '')
-            page = db.show_new_day(search, hide_chosen_tasks, sort_order)
+        db = TodoDB(selected_date, tag_filter_and, tag_filter_not, hide_unchosen, hide_done)
+        if site in {'todo', 'task'}:
+            id_ = params.get('id')
+        if site in {'do_todos', 'tasks'}:
+            sort_order = params.get_cookied('sort', prefix=site)
+        if site in {'', 'calendar', 'todo'}:
+            start_date = params.get_cookied('start', prefix=site)
+            end_date = params.get_cookied('end', prefix=site)
+        if 'reset_cookie' == site:
+            cookie_db = {  # sensible defaults
+                # params.cookie_key_from_params_key('pick_tasks', 'and_tag'): ['default'],
+                # params.cookie_key_from_params_key('pick_tasks', 'not_tag'): ['ignore'],
+                params.cookie_key_from_params_key('todo', 'and_tag'): ['default'],
+                params.cookie_key_from_params_key('todo', 'not_tag'): ['ignore'],
+                params.cookie_key_from_params_key('todo', 'start'): 'yesterday',
+                params.cookie_key_from_params_key('todo', 'end'): 'today'}
+            page = db.show_message('cookie unset!')
+        elif 'do_todos' == site:
+            page = db.show_do_todos(sort_order)
+        # elif 'pick_tasks' == site:
+        #     hide_chosen_tasks = params.get('hide_chosen_tasks', False)
+        #     page = db.show_pick_tasks(search, hide_chosen_tasks, sort_order)
         elif site == 'todo':
-            todo_id = params.get('id')
-            page = db.show_todo(todo_id, return_to)
-            # todo_id = params.get('id')
-            # if todo_id:
-            #     todo_date, task_uuid = todo_id.split('_') 
-            # else:
-            #     todo_date = params.get('date')
-            #     task_uuid = params.get('task')
-            # page = db.show_todo(task_uuid, todo_date, return_to)
+            page = db.show_todo(id_, start_date, end_date)
         elif 'task' == site:
-            id_ = params.get('id')
-            search = params.get('search', '')
-            page = db.show_task(id_, return_to, search)
+            page = db.show_task(id_)
         elif 'tasks' == site:
-            expand_uuid = params.get('expand_uuid')
-            page = db.show_tasks(expand_uuid)
+            search = params.get('search', '')
+            page = db.show_tasks(search, sort_order)
         elif 'add_task' == site:
             page = db.show_task(None)
-        elif 'unset_cookie' == site:
-            page = 'no cookie to unset.'
-            if len(cookie_db) > 0:
-                self.unset_cookie(config['cookie_name'], config['cookie_path'])
-                page = 'cookie unset!'
-        else:
-            start_date = params.get_cookied('start')
-            end_date = params.get_cookied('end')
+        else:  # 'calendar' == site
             page = db.show_calendar(start_date, end_date)
-        if 'unset_cookie' != site:
-            self.set_cookie(config['cookie_name'], config['cookie_path'], cookie_db)
+
+        self.set_cookie(config['cookie_name'], config['cookie_path'], cookie_db)
         self.send_HTML(page)