1 from plomlib import PlomDB, run_server, PlomHandler, PlomException
4 from datetime import datetime, timedelta
5 from urllib.parse import parse_qs
6 from jinja2 import Template
7 from urllib.parse import urlparse
8 db_path = '/home/plom/org/todo_new.json'
9 # db_path = '/home/plom/public_repos/misc/todo_new.json'
11 DATE_FORMAT = '%Y-%m-%d'
15 body { font-family: monospace; }
16 table.alternating tr:nth-child(even) {
17 background-color: #f2f2f2;
19 table.alternating tr:nth-child(odd) {
20 background-color: #ffffff;
22 th, td { text-align: left; vertical_align: top; border-bottom: 1px dotted black; }
23 td details { display: inline }
24 td.input { width: 100%; }
25 td.number { text-align: right; }
26 td.checkbox { width: 0.1em; height: 0.1em; padding: 0em; text-align: center; }
27 tr.week_row td { height: 0.1em; border: 0px; background-color: black; }
28 tr.day_row td { background-color: #f2f2f2 }
29 input { font-family: monospace; padding: 0em; margin: 0em; }
30 input[type="number"] { font-family: monospace; text-align: right; }
31 input[type="text"] { width: 100%; box-sizing: border-box; }
34 tasks: <a href="{{db.prefix}}/tasks">list</a> <a href="{{db.prefix}}/add_task">add</a> | day:
35 <a href="{{db.prefix}}/day{% if date %}?date={{date}}{% endif %}">choose tasks</a>
36 <a href="{{db.prefix}}/day?{% if date %}date={{date}}&{% endif %}hide_unchosen=1&hide_done=1">do tasks</a>
37 | <a href="{{db.prefix}}/calendar?t_and=calendar">calendar</a>
40 form_footer = '\n</form>'
41 form_header_tmpl = """
42 <form action="{{action|e}}" method="POST">
46 from: <input name="start" {% if start_date %}value="{{ start_date }}"{% endif %} placeholder="{{ today }}" />
47 to: <input name="end" {% if end_date %}value="{{ end_date }}"{% endif %} placeholder="2030-12-31" />
48 <input type="submit" value="OK" />
51 {% for date, day in days.items() | sort() %}
52 {% if day.weekday == "Mo" %}<tr class="week_row"><td colspan=3></td></tr>{% endif %}
53 <tr class="day_row"><td colspan=3><a href="{{db.prefix}}/day?date={{date}}&hide_unchosen=1">{{ day.weekday }} {{ date }}</a> |{{ '%04.1f' % day.todos_sum|round(2) }}| {{ day.comment|e }}</td></tr>
54 {% for task, todo in day.todos.items() | sort(attribute='1.title', reverse=True) %}
56 <tr><td class="checkbox">{% if todo.done %}✓{% else %} {% endif %}</td><td><a href="{{db.prefix}}/todo?task={{ todo.task.id_ }}&date={{ date }}">{{ todo.title }}</a></td><td>{{ todo.comment|e }}</td></tr>
63 <input type="hidden" name="task_uuid" value="{{ todo.task.id_ }}" />
64 <input type="hidden" name="date" value="{{ todo.day.date }}" />
66 <tr><th>task</th><td><a href="{{db.prefix}}/task?id={{ todo.task.id_ }}">{{ todo.task.title|e }}</a></td></tr>
67 <tr><th>default weight</th><td>{{ todo.default_weight }}</td></tr>
68 <tr><th>day</th><td>{{ todo.day.date }}</td></tr>
69 <tr><th>day weight</th><td class="input"><input type="number" name="day_weight" step=0.1 size=8 value="{{ todo.day_weight }}" /></td></tr>
70 <tr><th>comment</th><td class="input"><input type="text" name="comment" value="{{todo.comment|e}}" /></td></tr>
71 <tr><th>done</th><td class="input"><input type="checkbox" name="done" {% if todo.done %}checked{% endif %}/></td></tr>
73 <input type="submit" value="update" />
76 <input type="hidden" name="id" value="{{ task.id_ }}" />
78 <tr><th>title</th><td class="input"><input name="title" type="text" value="{{ task.title|e }}" /><details><summary>history</summary><ul>{% for k,v in task.title_history.items() | sort(attribute='0', reverse=True) %}<li>{{ k }}: {{ v|e }}{% endfor %}</ul></details></td></tr>
79 <tr><th>default weight</th><td class="input"><input type="number" name="default_weight" value="{{ task.default_weight }}" step=0.1 size=8 required /><details><summary>history</summary><ul>{% for k,v in task.default_weight_history.items() | sort(attribute='0', reverse=True) %}<li>{{ k }}: {{ v|e }}{% endfor %}</ul></details></td></tr>
80 <tr><th>tags</th><td class="input"><input name="tags" type="text" value="{{ task.tags_joined|e }}" ><details><summary>history</summary><ul>{% for k,v in task.tags_history.items() | sort(attribute='0', reverse=True) %}<li>{{ k }}: {{ v|e }}{% endfor %}</ul></details></td></tr>
82 <input type="submit" value="update" />
86 <input name="hide_unchosen" type="checkbox" {% if db.hide_unchosen %}checked{% endif %} /> hide unchosen <input name="hide_done" type="checkbox" {% if db.hide_done %}checked{% endif %} /> hide done |
87 <a href="{{db.prefix}}/day?date={{prev_date}}{% if db.hide_unchosen %}&hide_unchosen=1{% endif %}{% if db.hide_done %}&hide_done=1{% endif %}">prev</a> <a href="{{db.prefix}}/day?date={{next_date}}{% if db.hide_unchosen %}&hide_unchosen=1{% endif %}{% if db.hide_done %}&hide_done=1{% endif %}">next</a> |
88 <input type="hidden" name="original_selected_date" value="{{ db.selected_date }}" />
89 date: <input name="new_selected_date" value="{{ db.selected_date }}" size=10 /> |
90 {{ db.selected_day.todos_sum|round(2) }} ({{ db.selected_day.todos_sum2|round(2)}}) |
91 comment: <input name="day_comment" value="{{ db.selected_day.comment|e }}">
94 <table class="alternating">
95 <tr><th>task</th><th class="checkbox">choose?</th><th class="checkbox">done?</th><th>weight</th><th>comment</th></tr>
96 {% for uuid, t in db.tasks.items() | sort(attribute='1.title') %}
99 <input name="t_uuid" value="{{ uuid }}" type="hidden" >
100 <td><details><summary>] <a href="{{db.prefix}}/task?id={{ uuid }}" />{{ t.current_title|e }}</a></summary>tags: {% for tag in t.tags | sort %}<a href="{{db.prefix}}/day?date={{ db.selected_date }}&t_and={{tag|e}}">{{ tag }}</a> {% endfor %}</details></td>
101 <td class="checkbox"><input name="choose" type="checkbox" value="{{ uuid }}" {% if uuid in db.selected_day.todos.keys() %}checked{% endif %} ></td>
102 <td class="checkbox"><input name="done" type="checkbox" value="{{ uuid }}" {% if uuid in db.selected_day.todos.keys() and db.selected_day.todos[uuid].done %}checked{% endif %} ></td>
103 <td class="checkbox"><input name="day_weight" type="number" step=0.1 size=8 value="{% if uuid in db.selected_day.todos.keys() and db.selected_day.todos[uuid].day_weight %}{{ db.selected_day.todos[uuid].day_weight }}{% endif %}" placeholder={{ t.current_default_weight }} ></td>
104 <td type="input"><input name="todo_comment" type="text" value="{% if uuid in db.selected_day.todos.keys() %}{{ db.selected_day.todos[uuid].comment|e }}{% endif %}" ></td>
109 <input type="submit" value="OK">
111 tag_filters_tmpl = """
112 <p style="float: left; margin-right: 1em;">
113 <input type="submit" value="OK">
117 {% for and_filter in db.t_filter_and %}
118 <select name="t_and">
120 {% for tag in db.t_tags | sort %}
121 <option value="{{tag|e}}" {% if and_filter == tag %}selected{% endif %}>{{tag|e}}</option>
125 <select name="t_and">
127 {% for tag in db.t_tags | sort %}
128 <option value="{{tag|e}}">{{tag|e}}</option>
133 {% for not_filter in db.t_filter_not %}
134 <select name="t_not">
136 {% for tag in db.t_tags | sort %}
137 <option value="{{tag|e}}" {% if not_filter == tag %}selected{% endif %}>{{tag|e}}</option>
141 <select name="t_not">
143 {% for tag in db.t_tags | sort %}
144 <option value="{{tag|e}}">{{tag|e}}</option>
150 <table class="alternating">
151 <tr><th>default<br />weight</th><th>task</th><th>tags</th></tr>
152 {% for uuid, t in db.tasks.items() | sort(attribute='1.title') %}
155 <td class="number">{{ t.default_weight }}</a></td>
156 <td><a href="{{db.prefix}}/task?id={{ uuid }}" />{{ t.title|e }}</a></td>
157 <td>{% for tag in t.tags | sort %}<a href="{{db.prefix}}/tags?t_and={{tag|e}}">{{ tag }}</a> {% endfor %}</td>
165 def __init__(self, db, title_history=None, tags_history=None, default_weight_history=None):
167 self.title_history = title_history if title_history else {}
168 self.tags_history = tags_history if tags_history else {}
169 self.default_weight_history = default_weight_history if default_weight_history else {}
172 def _set_with_history(self, history, value):
173 keys = sorted(history.keys())
174 if len(history) == 0 or value != history[keys[-1]]:
175 history[str(datetime.now())[:19]] = value
177 def _last_of_history(self, history, default):
178 keys = sorted(history.keys())
179 return default if 0 == len(history) else history[keys[-1]]
182 def from_dict(cls, db, d):
186 {k: set(v) for k, v in d['tags_history'].items()},
187 d['default_weight_history'])
190 def default_weight(self):
191 return self._last_of_history(self.default_weight_history, 1)
193 @default_weight.setter
194 def default_weight(self, default_weight):
195 self._set_with_history(self.default_weight_history, default_weight)
197 def default_weight_at(self, queried_date):
198 ret = self.default_weight_history[sorted(self.default_weight_history.keys())[0]]
199 for date_key, default_weight in self.default_weight_history.items():
200 if date_key > f'{queried_date} 23:59:59':
206 def current_default_weight(self):
207 return self.default_weight_at(self.db.selected_date)
211 return self._last_of_history(self.title_history, '')
214 def title(self, title):
215 self._set_with_history(self.title_history, title)
217 def title_at(self, queried_date):
218 ret = self.title_history[sorted(self.title_history.keys())[0]]
219 for date_key, title in self.title_history.items():
220 if date_key > f'{queried_date} 23:59:59':
226 def current_title(self):
227 return self.title_at(self.db.selected_date)
231 return self._last_of_history(self.tags_history, set())
234 def tags(self, tags):
235 self._set_with_history(self.tags_history, set(tags))
238 def tags_joined(self):
239 return ';'.join(sorted(list(self.tags)))
242 def tags_joined(self, tags_string):
244 for tag in [tag.strip() for tag in tags_string.split(';') if tag.strip() != '']:
250 'title_history': self.title_history,
251 'tags_history': {k: list(v) for k,v in self.tags_history.items()},
252 'default_weight_history': self.default_weight_history}
256 for k, v in self.db.tasks.items():
263 def __init__(self, db, todos=None, comment=''):
265 self.todos = todos if todos else {}
266 self.comment = comment
270 def from_dict(cls, db, d):
272 comment = d['comment'] if 'comment' in d.keys() else ''
273 day = cls(db, todos, comment)
274 for uuid, todo_dict in d['todos'].items():
275 day.add_todo(uuid, todo_dict)
279 d = {'comment': self.comment, 'todos': {}}
280 for task_uuid, todo in self.todos.items():
281 d['todos'][task_uuid] = todo.to_dict()
284 def add_todo(self, id_, dict_source=None):
285 self.todos[id_] = Todo.from_dict(self, dict_source) if dict_source else Todo(self)
286 return self.todos[id_]
288 def _todos_sum(self, include_undone=False):
290 for todo in [todo for todo in self.todos.values() if todo.done]:
293 for todo in [todo for todo in self.todos.values() if not todo.done]:
294 s += todo.day_weight if todo.day_weight else 0
299 return self._todos_sum()
302 def todos_sum2(self):
303 return self._todos_sum(True)
307 for k, v in self.db.days.items():
313 def __init__(self, day, done=False, day_weight=None, comment=''):
316 self.day_weight = day_weight
317 self.comment = comment
320 def from_dict(cls, day, d):
321 return cls(day, d['done'], d['day_weight'], d['comment'])
324 return {'done': self.done, 'day_weight': self.day_weight, 'comment': self.comment}
327 def default_weight(self):
328 return self.task.default_weight_at(self.day.date)
333 return self.day_weight
335 return self.day_weight if self.day_weight else self.default_weight
339 for k, v in self.day.todos.items():
341 return self.day.db.tasks[k]
345 return self.task.title_at(self.day.date)
348 class TodoDB(PlomDB):
350 def __init__(self, prefix, selected_date=None, t_filter_and = None, t_filter_not = None, hide_unchosen=False, hide_done=False):
352 self.selected_date = selected_date if selected_date else str(datetime.now())[:10]
353 self.t_filter_and = t_filter_and if t_filter_and else []
354 self.t_filter_not = t_filter_not if t_filter_not else []
355 self.hide_unchosen = hide_unchosen
356 self.hide_done = hide_done
360 super().__init__(db_path)
362 def read_db_file(self, f):
364 for date, day_dict in d['days'].items():
365 self.days[date] = self.add_day(dict_source=day_dict)
366 for uuid, t_dict in d['tasks'].items():
367 t = self.add_task(id_=uuid, dict_source=t_dict)
368 t.visible = len([tag for tag in self.t_filter_and if not tag in t.tags]) == 0\
369 and len([tag for tag in self.t_filter_not if tag in t.tags]) == 0\
370 and ((not self.hide_unchosen) or uuid in self.selected_day.todos)\
371 and ((not self.hide_done) or (uuid in self.selected_day.todos and not self.selected_day.todos[uuid].done))
377 't_filter_and': self.t_filter_and,
378 't_filter_not': self.t_filter_not,
382 for uuid, t in self.tasks.items():
383 d['tasks'][uuid] = t.to_dict()
384 for date, day in self.days.items():
385 d['days'][date] = day.to_dict()
389 def selected_day(self):
390 if not self.selected_date in self.days.keys():
391 self.days[self.selected_date] = self.add_day()
392 return self.days[self.selected_date]
394 def change_selected_days_date(self, new_date):
395 if new_date in self.days.keys():
396 raise PlomException('cannot use same date twice')
398 self.days[new_date] = self.selected_day
399 del self.days[self.selected_date]
400 self.selected_date = new_date
404 for date, day in self.days.items():
405 if len(day.todos) == 0 and len(day.comment) == 0:
406 dates_to_purge += [date]
407 for date in dates_to_purge:
409 self.write_text_to_db(json.dumps(self.to_dict()))
411 def add_task(self, id_=None, dict_source=None, return_id=False):
412 t = Task.from_dict(self, dict_source) if dict_source else Task(self)
413 id_ = id_ if id_ else str(uuid4())
420 def add_day(self, dict_source=None):
421 return Day.from_dict(self, dict_source) if dict_source else Day(self)
424 current_date = datetime.strptime(self.selected_date, DATE_FORMAT)
425 prev_date = current_date - timedelta(days=1)
426 prev_date_str = prev_date.strftime(DATE_FORMAT)
427 next_date = current_date + timedelta(days=1)
428 next_date_str = next_date.strftime(DATE_FORMAT)
429 return Template(form_header_tmpl + tag_filters_tmpl + day_tmpl + form_footer).render(db=self, action=self.prefix+'/day', prev_date=prev_date_str, next_date=next_date_str)
431 def show_calendar(self, start_date_str, end_date_str):
433 target_start = start_date_str if start_date_str else sorted(self.days.keys())[0]
434 # target_start = str(datetime.now())[:10] if 'today' == target_start else target_start
435 target_end = end_date_str if end_date_str else sorted(self.days.keys())[-1]
436 # todays_date = str(datetime.now())[:10]
437 start_date = datetime.strptime(target_start, DATE_FORMAT)
438 end_date = datetime.strptime(target_end, DATE_FORMAT)
439 for n in range(int((end_date - start_date).days) + 1):
440 current_date_obj = start_date + timedelta(n)
441 current_date = current_date_obj.strftime(DATE_FORMAT)
442 if current_date not in self.days.keys():
443 days_to_show[current_date] = self.add_day()
445 days_to_show[current_date] = self.days[current_date]
446 days_to_show[current_date].weekday = datetime.strptime(current_date, DATE_FORMAT).strftime('%A')[:2]
447 for task_uuid, todo in days_to_show[current_date].todos.items():
448 todo.visible = self.tasks[task_uuid].visible
449 return Template(form_header_tmpl + calendar_tmpl + form_footer).render(db=self, days=days_to_show, action=self.prefix+'/calendar', today=str(datetime.now())[:10], start_date=start_date_str, end_date=end_date_str)
451 def show_todo(self, task_uuid, selected_date):
452 todo = self.days[selected_date].todos[task_uuid]
453 return Template(form_header_tmpl + todo_tmpl + form_footer).render(db=self, todo=todo, action=self.prefix+'/todo')
455 def update_todo(self, task_uuid, date, day_weight, done, comment):
456 if task_uuid in self.days[date].todos.keys():
457 todo = self.days[date].todos[task_uuid]
459 todo = self.days[date].add_todo(task_uuid)
460 todo.day_weight = float(day_weight) if len(day_weight) > 0 else None
462 todo.comment = comment
464 def show_task(self, id_):
465 task = self.tasks[id_] if id_ else self.add_task()
466 return Template(form_header_tmpl + task_tmpl + form_footer).render(db=self, task=task, action=self.prefix+'/task')
468 def update_task(self, id_, title, default_weight, tags_joined):
469 task = self.tasks[id_] if id_ in self.tasks.keys() else self.add_task(id_)
471 task.default_weight = float(default_weight) if len(default_weight) > 0 else None
472 task.tags_joined = tags_joined
474 def show_tasks(self):
475 return Template(form_header_tmpl + tag_filters_tmpl + tasks_tmpl + form_footer).render(db=self, action=self.prefix+'/tasks')
479 class TodoHandler(PlomHandler):
481 def app_init(self, handler):
482 default_path = '/todo'
483 handler.add_route('GET', default_path, self.show_db)
484 handler.add_route('POST', default_path, self.write_db)
485 return 'todo', default_path
488 self.try_do(self.write_db)
491 from urllib.parse import urlencode
492 prefix = self.apps['todo'] if hasattr(self, 'apps') else ''
493 length = int(self.headers['content-length'])
494 postvars = parse_qs(self.rfile.read(length).decode(), keep_blank_values=1)
495 parsed_url = urlparse(self.path)
496 db = TodoDB(prefix=prefix)
498 if parsed_url.path == prefix + '/calendar':
499 start = postvars['start'][0] if len(postvars['start'][0]) > 0 else ''
500 end = postvars['end'][0] if len(postvars['end'][0]) > 0 else ''
501 homepage = f'{prefix}/calendar?t_and=calendar&start={start}&end={end}'
503 elif parsed_url.path == prefix + '/todo':
504 task_uuid = postvars['task_uuid'][0]
505 date = postvars['date'][0]
506 db.update_todo(task_uuid, date, postvars['day_weight'][0], 'done' in postvars.keys(), postvars['comment'][0])
507 homepage = f'{prefix}/todo?task={task_uuid}&date={date}'
509 elif parsed_url.path == prefix + '/task':
510 id_ = postvars['id'][0]
511 db.update_task(id_, postvars['title'][0], postvars['default_weight'][0], postvars['tags'][0])
512 homepage = f'{prefix}/task?id={id_}'
514 elif parsed_url.path in {prefix + '/tasks', prefix + '/day'}:
515 for target in postvars['t_and']:
516 if not target in db.t_filter_and:
517 db.t_filter_and += [target]
518 for target in postvars['t_not']:
519 if not target in db.t_filter_not:
520 db.t_filter_not += [target]
521 if 'hide_unchosen' in postvars.keys():
522 db.hide_unchosen = True
523 if 'hide_done' in postvars.keys():
525 data = [('t_and', f) for f in db.t_filter_and] + [('t_not', f) for f in db.t_filter_not] + [('hide_unchosen', int(db.hide_unchosen))] + [('hide_done', int(db.hide_done))]
527 if parsed_url.path == prefix + '/tasks':
528 encoded_params = urlencode(data)
529 homepage = f'{prefix}/tasks?{encoded_params}'
531 elif parsed_url.path == prefix + '/day':
532 db.selected_date = postvars['original_selected_date'][0]
533 new_selected_date = postvars['new_selected_date'][0]
535 datetime.strptime(new_selected_date, DATE_FORMAT)
537 raise PlomException(f"{prefix} bad date string: {new_selected_date}")
538 if new_selected_date != db.selected_date:
539 db.change_selected_days_date(new_selected_date)
540 if 't_uuid' in postvars.keys():
541 for i, uuid in enumerate(postvars['t_uuid']):
543 if uuid in db.selected_day.todos.keys() and ((not 'choose' in postvars) or uuid not in postvars['choose']):
544 del db.selected_day.todos[uuid]
545 if 'choose' in postvars.keys():
546 for i, uuid in enumerate(postvars['t_uuid']):
547 if uuid in postvars['choose']:
548 done = 'done' in postvars and uuid in postvars['done']
549 db.update_todo(uuid, db.selected_date, postvars['day_weight'][i], done, postvars['todo_comment'][i])
550 if 'day_comment' in postvars.keys():
551 db.selected_day.comment = postvars['day_comment'][0]
552 data += [('date', db.selected_date)]
553 encoded_params = urlencode(data)
554 homepage = f'{prefix}/day?{encoded_params}'
557 self.redirect(homepage)
560 self.try_do(self.show_db)
563 prefix = self.apps['todo'] if hasattr(self, 'apps') else ''
564 parsed_url = urlparse(self.path)
565 params = parse_qs(parsed_url.query)
566 selected_date = params.get('date', [None])[0]
567 t_filter_and = params.get('t_and', [])
568 t_filter_not = params.get('t_not', ['deleted'])
569 hide_unchosen_params = params.get('hide_unchosen', [])
570 hide_unchosen = len(hide_unchosen_params) > 0 and hide_unchosen_params[0] != '0'
571 hide_done_params = params.get('hide_done', [])
572 hide_done = len(hide_done_params) > 0 and hide_done_params[0] != '0'
573 db = TodoDB(prefix, selected_date, t_filter_and, t_filter_not, hide_unchosen, hide_done)
574 if parsed_url.path == prefix + '/day':
576 elif parsed_url.path == prefix + '/todo':
577 task_uuid = params.get('task', [None])[0]
578 page = db.show_todo(task_uuid, selected_date)
579 elif parsed_url.path == prefix + '/task':
580 id_ = params.get('id', [None])[0]
581 page = db.show_task(id_)
582 elif parsed_url.path == prefix + '/tasks':
583 page = db.show_tasks()
584 elif parsed_url.path == prefix + '/add_task':
585 page = db.show_task(None)
587 start_date = params.get('start', [None])[0]
588 end_date = params.get('end', [None])[0]
589 page = db.show_calendar(start_date, end_date)
590 header = Template(html_head).render(db=db, prefix=prefix, date=selected_date)
591 self.send_HTML(header + page)
594 if __name__ == "__main__":
595 run_server(server_port, TodoHandler)