server.py 53.7 KB
Newer Older
1
2
3
4
#!/usr/bin/env python3
import locale
locale.setlocale(locale.LC_TIME, "de_DE.utf8")

5
from flask import Flask, g, current_app, request, session, flash, redirect, url_for, abort, render_template, Response, send_file as flask_send_file
6
from werkzeug.utils import secure_filename
7
8
9
10
from flask_script import Manager, prompt
from flask_migrate import Migrate, MigrateCommand
#from flask_socketio import SocketIO
from celery import Celery
Robin Sonnabend's avatar
Robin Sonnabend committed
11
from sqlalchemy import or_, and_
12
13
14
from apscheduler.schedulers.background import BackgroundScheduler
from apscheduler.triggers.cron import CronTrigger
from apscheduler.triggers.interval import IntervalTrigger
Robin Sonnabend's avatar
Robin Sonnabend committed
15
import atexit
Robin Sonnabend's avatar
Robin Sonnabend committed
16
from io import StringIO, BytesIO
17
import os
Robin Sonnabend's avatar
Robin Sonnabend committed
18
from datetime import datetime
Robin Sonnabend's avatar
Robin Sonnabend committed
19
import math
20
import mimetypes
21
22

import config
23
from shared import db, date_filter, datetime_filter, date_filter_long, date_filter_short, time_filter, time_filter_short, ldap_manager, security_manager, current_user, check_login, login_required, group_required, class_filter, needs_date_test, todostate_name_filter, code_filter, indent_tab_filter
Robin Sonnabend's avatar
Robin Sonnabend committed
24
from utils import is_past, mail_manager, url_manager, get_first_unused_int, set_etherpad_text, get_etherpad_text, split_terms, optional_int_arg
Robin Sonnabend's avatar
Robin Sonnabend committed
25
from decorators import db_lookup, require_public_view_right, require_private_view_right, require_modify_right, require_admin_right
26
27
28
from models.database import ProtocolType, Protocol, DefaultTOP, TOP, Document, Todo, Decision, MeetingReminder, Error, TodoMail, DecisionDocument, TodoState, Meta, DefaultMeta, DecisionCategory
from views.forms import LoginForm, ProtocolTypeForm, DefaultTopForm, MeetingReminderForm, NewProtocolForm, DocumentUploadForm, KnownProtocolSourceUploadForm, NewProtocolSourceUploadForm, ProtocolForm, TopForm, SearchForm, DecisionSearchForm, NewProtocolFileUploadForm, NewTodoForm, TodoForm, TodoMailForm, DefaultMetaForm, MetaForm, MergeTodosForm, DecisionCategoryForm
from views.tables import ProtocolsTable, ProtocolTypesTable, ProtocolTypeTable, DefaultTOPsTable, MeetingRemindersTable, ErrorsTable, TodosTable, DocumentsTable, DecisionsTable, TodoTable, ErrorTable, TodoMailsTable, DefaultMetasTable, DecisionCategoriesTable
29
from legacy import import_old_todos, import_old_protocols, import_old_todomails
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52

app = Flask(__name__)
app.config.from_object(config)
db.init_app(app)
migrate = Migrate(app, db)
manager = Manager(app)
manager.add_command("db", MigrateCommand)

def make_celery(app, config):
    celery = Celery(app.import_name, broker=config.CELERY_BROKER_URL)
    celery.conf.update(app.config)
    return celery
celery = make_celery(app, config)

#def make_socketio(app, config):
#    socketio = SocketIO(app)
#    return socketio
#socketio = make_socketio(app, config)

app.jinja_env.trim_blocks = True
app.jinja_env.lstrip_blocks = True
app.jinja_env.filters["datify"] = date_filter
app.jinja_env.filters["datetimify"] = datetime_filter
Robin Sonnabend's avatar
Robin Sonnabend committed
53
app.jinja_env.filters["timify"] = time_filter
54
app.jinja_env.filters["timify_short"] = time_filter_short
Robin Sonnabend's avatar
Robin Sonnabend committed
55
app.jinja_env.filters["datify_short"] = date_filter_short
Robin Sonnabend's avatar
Robin Sonnabend committed
56
app.jinja_env.filters["datify_long"] = date_filter_long
57
app.jinja_env.filters["url_complete"] = url_manager.complete
58
app.jinja_env.filters["class"] = class_filter
Robin Sonnabend's avatar
Robin Sonnabend committed
59
60
app.jinja_env.filters["todo_get_name"] = todostate_name_filter
app.jinja_env.filters["code"] = code_filter
Robin Sonnabend's avatar
Robin Sonnabend committed
61
app.jinja_env.filters["indent_tab"] = indent_tab_filter
62
app.jinja_env.tests["auth_valid"] = security_manager.check_user
Robin Sonnabend's avatar
Robin Sonnabend committed
63
app.jinja_env.tests["needs_date"] = needs_date_test
64
65
66

import tasks

67
68
app.jinja_env.globals.update(check_login=check_login)
app.jinja_env.globals.update(current_user=current_user)
Robin Sonnabend's avatar
Robin Sonnabend committed
69
app.jinja_env.globals.update(zip=zip)
Robin Sonnabend's avatar
Robin Sonnabend committed
70
71
72
app.jinja_env.globals.update(min=min)
app.jinja_env.globals.update(max=max)
app.jinja_env.globals.update(dir=dir)
73

74
75
# blueprints here

76
77
@manager.command
def import_legacy():
78
    """Import the old todos and protocols from an sql dump"""
79
    filename = prompt("SQL-file")
80
    #filename = "legacy.sql"
81
82
    with open(filename, "rb") as sqlfile:
        content = sqlfile.read().decode("utf-8")
83
84
        import_old_todos(content)
        import_old_protocols(content)
85
        import_old_todomails(content)
86

87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
@manager.command
def recompile_all():
    for protocol in sorted(Protocol.query.all(), key=lambda p: p.date):
        if protocol.is_done():
            print(protocol.get_identifier())
            tasks.parse_protocol(protocol)

@manager.command
def merge_todos():
    todo_by_id = {}
    todos = Todo.query.all()
    for todo in todos:
        todo_id = todo.get_id()
        if todo_id in todo_by_id:
            todo1, todo2 = todo, todo_by_id[todo_id]
            print(todo1)
            print(todo2)
            if todo2.id > todo1.id:
                todo2, todo1 = todo1, todo2
            for protocol in todo2.protocols:
                if protocol not in todo1.protocols:
                    todo1.protocols.append(protocol)
                todo2.protocols.remove(protocol)
            db.session.delete(todo2)
            db.session.commit()
            todo_by_id[todo_id] = todo1
        else:
            todo_by_id[todo_id] = todo

@manager.command
def runserver():
118
    app.run()
119
120
    make_scheduler()

121
122
123
124
# cause uwsgi currently has a bug
def send_file(file_like, cache_timeout, as_attachment, attachment_filename):
    mimetype, _ = mimetypes.guess_type(attachment_filename)
    response = Response(file_like.read(), mimetype)
125
126
127
128
129
130
131
132
    if as_attachment:
        response.headers["Content-Disposition"] = 'attachment; filename="{}"'.format(attachment_filename)
    content_type = mimetype
    if mimetype.startswith("text/"):
        content_type = "{}; charset=utf-8".format(content_type)
    response.headers["Content-Type"] = content_type
    response.headers["Cache-Control"] = "public, max-age={}".format(cache_timeout)
    response.headers["Connection"] = "close"
133
    return response
134

135
136
@app.route("/")
def index():
Robin Sonnabend's avatar
Robin Sonnabend committed
137
138
139
    user = current_user()
    protocols = [
        protocol for protocol in Protocol.query.all()
140
141
        if protocol.protocoltype.has_public_view_right(user,
            check_networks=False)
Robin Sonnabend's avatar
Robin Sonnabend committed
142
    ]
143
    def _protocol_sort_key(protocol):
Robin Sonnabend's avatar
Robin Sonnabend committed
144
145
146
        if protocol.date is not None:
            return protocol.date
        return datetime.now().date()
Robin Sonnabend's avatar
Robin Sonnabend committed
147
    current_day = datetime.now().date()
148
    open_protocols = sorted(
Robin Sonnabend's avatar
Robin Sonnabend committed
149
150
151
152
153
        [
            protocol for protocol in protocols
            if not protocol.done
            and (protocol.date - current_day).days < config.MAX_INDEX_DAYS
        ],
154
        key=_protocol_sort_key
Robin Sonnabend's avatar
Robin Sonnabend committed
155
156
    )
    finished_protocols = sorted(
157
158
159
160
161
        [
            protocol for protocol in protocols
            if protocol.done
            and (protocol.has_public_view_right(user)
                or protocol.has_private_view_right(user))
162
            and protocol.protocoltype.has_public_view_right(user)
163
        ],
164
165
        key=_protocol_sort_key,
        reverse=True
Robin Sonnabend's avatar
Robin Sonnabend committed
166
167
168
169
170
    )
    protocol = finished_protocols[0] if len(finished_protocols) > 0 else None
    todos = None
    if check_login():
        todos = [
171
            todo for todo in Todo.query.all()
172
            if todo.protocoltype.has_private_view_right(user)
173
            and not todo.is_done()
Robin Sonnabend's avatar
Robin Sonnabend committed
174
        ]
175
176
177
178
        def _todo_sort_key(todo):
            protocol = todo.get_first_protocol()
            return protocol.date if protocol.date is not None else datetime.now().date()
        todos = sorted(todos, key=_todo_sort_key, reverse=True)
Robin Sonnabend's avatar
Robin Sonnabend committed
179
    todos_table = TodosTable(todos) if todos is not None else None
180
    return render_template("index.html", open_protocols=open_protocols, protocol=protocol, todos=todos)
181

Robin Sonnabend's avatar
Robin Sonnabend committed
182
@app.route("/documentation")
Robin Sonnabend's avatar
Robin Sonnabend committed
183
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
184
def documentation():
Robin Sonnabend's avatar
Robin Sonnabend committed
185
186
187
    todostates = list(TodoState)
    name_to_state = TodoState.get_name_to_state()
    return render_template("documentation.html", todostates=todostates, name_to_state=name_to_state)
Robin Sonnabend's avatar
Robin Sonnabend committed
188

Robin Sonnabend's avatar
Robin Sonnabend committed
189
@app.route("/types/list")
Robin Sonnabend's avatar
Robin Sonnabend committed
190
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
191
192
193
194
195
196
197
198
def list_types():
    is_logged_in = check_login()
    user = current_user()
    types = [
        protocoltype for protocoltype in ProtocolType.query.all()
        if (protocoltype.public_group in user.groups
        or protocoltype.private_group in user.groups
        or protocoltype.is_public)]
199
    types = sorted(types, key=lambda t: t.short_name)
Robin Sonnabend's avatar
Robin Sonnabend committed
200
201
202
203
204
205
206
207
208
209
210
211
    types_table = ProtocolTypesTable(types)
    return render_template("types-list.html", types=types, types_table=types_table)

@app.route("/type/new", methods=["GET", "POST"])
@login_required
def new_type():
    form = ProtocolTypeForm()
    if form.validate_on_submit():
        user = current_user()
        if form.private_group.data not in user.groups:
            flash("Du kannst keinen internen Protokolltypen anlegen, zu dem du selbst keinen Zugang hast.", "alert-error")
        else:
212
213
            protocoltype = ProtocolType()
            form.populate_obj(protocoltype)
Robin Sonnabend's avatar
Robin Sonnabend committed
214
215
216
217
218
219
            db.session.add(protocoltype)
            db.session.commit()
            flash("Der Protokolltyp {} wurde angelegt.".format(protocoltype.name), "alert-success")
        return redirect(request.args.get("next") or url_for("list_types"))
    return render_template("type-new.html", form=form)

Robin Sonnabend's avatar
Robin Sonnabend committed
220
@app.route("/type/edit/<int:protocoltype_id>", methods=["GET", "POST"])
Robin Sonnabend's avatar
Robin Sonnabend committed
221
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
222
@db_lookup(ProtocolType)
Robin Sonnabend's avatar
Robin Sonnabend committed
223
@require_private_view_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
224
def edit_type(protocoltype):
Robin Sonnabend's avatar
Robin Sonnabend committed
225
226
227
228
229
230
231
232
    user = current_user()
    form = ProtocolTypeForm(obj=protocoltype)
    if form.validate_on_submit():
        if form.private_group.data not in user.groups:
            flash("Du kannst keinen internen Protokolltypen anlegen, zu dem du selbst keinen Zugang hast.", "alert-error")
        else:
            form.populate_obj(protocoltype)
            db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
233
            return redirect(request.args.get("next") or url_for("show_type", protocoltype_id=protocoltype.id))
Robin Sonnabend's avatar
Robin Sonnabend committed
234
235
    return render_template("type-edit.html", form=form, protocoltype=protocoltype)

Robin Sonnabend's avatar
Robin Sonnabend committed
236
@app.route("/type/show/<int:protocoltype_id>")
Robin Sonnabend's avatar
Robin Sonnabend committed
237
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
238
@db_lookup(ProtocolType)
Robin Sonnabend's avatar
Robin Sonnabend committed
239
@require_private_view_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
240
def show_type(protocoltype):
Robin Sonnabend's avatar
Robin Sonnabend committed
241
242
    protocoltype_table = ProtocolTypeTable(protocoltype)
    default_tops_table = DefaultTOPsTable(protocoltype.default_tops, protocoltype)
243
    reminders_table = MeetingRemindersTable(protocoltype.reminders, protocoltype)
Robin Sonnabend's avatar
Robin Sonnabend committed
244
    metas_table = DefaultMetasTable(protocoltype.metas, protocoltype)
245
246
    categories_table = DecisionCategoriesTable(protocoltype.decisioncategories, protocoltype)
    return render_template("type-show.html", protocoltype=protocoltype, protocoltype_table=protocoltype_table, default_tops_table=default_tops_table, metas_table=metas_table, reminders_table=reminders_table, mail_active=config.MAIL_ACTIVE, categories_table=categories_table)
247

Robin Sonnabend's avatar
Robin Sonnabend committed
248
@app.route("/type/delete/<int:protocoltype_id>")
249
@login_required
250
@group_required(config.ADMIN_GROUP)
Robin Sonnabend's avatar
Robin Sonnabend committed
251
@db_lookup(ProtocolType)
Robin Sonnabend's avatar
Robin Sonnabend committed
252
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
253
def delete_type(protocoltype):
254
255
256
257
258
259
    name = protocoltype.name
    db.session.delete(protocoltype) 
    db.session.commit()
    flash("Der Protokolltype {} wurde gelöscht.".format(name), "alert-success")
    return redirect(request.args.get("next") or url_for("list_types"))

Robin Sonnabend's avatar
Robin Sonnabend committed
260
@app.route("/type/reminders/new/<int:protocoltype_id>", methods=["GET", "POST"])
261
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
262
@db_lookup(ProtocolType)
Robin Sonnabend's avatar
Robin Sonnabend committed
263
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
264
def new_reminder(protocoltype):
265
266
    form = MeetingReminderForm()
    if form.validate_on_submit():
267
268
        meetingreminder = MeetingReminder(protocoltype_id=protocoltype.id)
        form.populate_obj(meetingreminder)
Robin Sonnabend's avatar
Robin Sonnabend committed
269
        db.session.add(meetingreminder)
270
        db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
271
        return redirect(request.args.get("next") or url_for("show_type", protocoltype_id=protocoltype.id))
272
273
    return render_template("reminder-new.html", form=form, protocoltype=protocoltype)

Robin Sonnabend's avatar
Robin Sonnabend committed
274
@app.route("/type/reminder/edit/<int:meetingreminder_id>", methods=["GET", "POST"])
275
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
276
@db_lookup(MeetingReminder)
Robin Sonnabend's avatar
Robin Sonnabend committed
277
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
278
279
def edit_reminder(meetingreminder):
    form = MeetingReminderForm(obj=meetingreminder)
280
    if form.validate_on_submit():
Robin Sonnabend's avatar
Robin Sonnabend committed
281
        form.populate_obj(meetingreminder)
282
        db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
283
        return redirect(request.args.get("next") or url_for("show_type", protocoltype_id=protocoltype.id))
284
    return render_template("reminder-edit.html", form=form, meetingreminder=meetingreminder)
285

Robin Sonnabend's avatar
Robin Sonnabend committed
286
@app.route("/type/reminder/delete/<int:meetingreminder_id>")
287
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
288
@db_lookup(MeetingReminder)
Robin Sonnabend's avatar
Robin Sonnabend committed
289
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
290
291
292
def delete_reminder(meetingreminder):
    protocoltype = meetingreminder.protocoltype
    db.session.delete(meetingreminder)
293
    db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
294
    return redirect(request.args.get("next") or url_for("show_type", protocoltype_id=protocoltype.id))
295

Robin Sonnabend's avatar
Robin Sonnabend committed
296
@app.route("/type/tops/new/<int:protocoltype_id>", methods=["GET", "POST"])
Robin Sonnabend's avatar
Robin Sonnabend committed
297
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
298
@db_lookup(ProtocolType)
Robin Sonnabend's avatar
Robin Sonnabend committed
299
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
300
def new_default_top(protocoltype):
Robin Sonnabend's avatar
Robin Sonnabend committed
301
302
    form = DefaultTopForm()
    if form.validate_on_submit():
303
304
        defaulttop = DefaultTOP(protocoltype_id=protocoltype.id)
        form.populate_obj(defaulttop)
Robin Sonnabend's avatar
Robin Sonnabend committed
305
        db.session.add(defaulttop)
Robin Sonnabend's avatar
Robin Sonnabend committed
306
        db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
307
        flash("Der Standard-TOP {} wurde für dem Protokolltyp {} hinzugefügt.".format(defaulttop.name, protocoltype.name), "alert-success")
Robin Sonnabend's avatar
Robin Sonnabend committed
308
309
310
        return redirect(request.args.get("next") or url_for("index"))
    return render_template("default-top-new.html", form=form, protocoltype=protocoltype)

Robin Sonnabend's avatar
Robin Sonnabend committed
311
@app.route("/type/tops/edit/<int:protocoltype_id>/<int:defaulttop_id>", methods=["GET", "POST"])
Robin Sonnabend's avatar
Robin Sonnabend committed
312
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
313
@db_lookup(ProtocolType, DefaultTOP)
Robin Sonnabend's avatar
Robin Sonnabend committed
314
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
315
316
def edit_default_top(protocoltype, defaulttop):
    form = DefaultTopForm(obj=defaulttop)
Robin Sonnabend's avatar
Robin Sonnabend committed
317
    if form.validate_on_submit():
Robin Sonnabend's avatar
Robin Sonnabend committed
318
        form.populate_obj(defaulttop)
Robin Sonnabend's avatar
Robin Sonnabend committed
319
        db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
320
321
        return redirect(request.args.get("next") or url_for("show_type", protocoltype_id=protocoltype.id))
    return render_template("default-top-edit.html", form=form, protocoltype=protocoltype, defaulttop=defaulttop)
Robin Sonnabend's avatar
Robin Sonnabend committed
322

Robin Sonnabend's avatar
Robin Sonnabend committed
323
@app.route("/type/tops/delete/<int:defaulttop_id>")
Robin Sonnabend's avatar
Robin Sonnabend committed
324
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
325
@db_lookup(DefaultTOP)
Robin Sonnabend's avatar
Robin Sonnabend committed
326
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
327
328
def delete_default_top(defaulttop):
    db.session.delete(defaulttop)
Robin Sonnabend's avatar
Robin Sonnabend committed
329
    db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
330
    return redirect(request.args.get("next") or url_for("show_type", protocoltype_id=protocoltype.id))
Robin Sonnabend's avatar
Robin Sonnabend committed
331

Robin Sonnabend's avatar
Robin Sonnabend committed
332
@app.route("/type/tops/move/<int:defaulttop_id>/<diff>/")
Robin Sonnabend's avatar
Robin Sonnabend committed
333
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
334
@db_lookup(DefaultTOP)
Robin Sonnabend's avatar
Robin Sonnabend committed
335
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
336
def move_default_top(defaulttop, diff):
Robin Sonnabend's avatar
Robin Sonnabend committed
337
    try:
Robin Sonnabend's avatar
Robin Sonnabend committed
338
        defaulttop.number += int(diff)
Robin Sonnabend's avatar
Robin Sonnabend committed
339
340
341
        db.session.commit()
    except ValueError:
        flash("Die angegebene Differenz ist keine Zahl.", "alert-error")
Robin Sonnabend's avatar
Robin Sonnabend committed
342
    return redirect(request.args.get("next") or url_for("show_type", protocoltype_id=defaulttop.protocoltype.id))
Robin Sonnabend's avatar
Robin Sonnabend committed
343
344

@app.route("/protocols/list")
345
346
347
def list_protocols():
    is_logged_in = check_login()
    user = current_user()
Robin Sonnabend's avatar
Robin Sonnabend committed
348
349
350
    protocoltype = None
    protocoltype_id = None
    try:
351
        protocoltype_id = int(request.args.get("protocoltype_id"))
Robin Sonnabend's avatar
Robin Sonnabend committed
352
353
354
355
356
357
    except (ValueError, TypeError):
        pass
    search_term = request.args.get("search")
    protocoltypes = ProtocolType.get_public_protocoltypes(user)
    search_form = SearchForm(protocoltypes)
    if protocoltype_id is not None:
358
        search_form.protocoltype_id.data = protocoltype_id
Robin Sonnabend's avatar
Robin Sonnabend committed
359
360
361
362
        protocoltype = ProtocolType.query.filter_by(id=protocoltype_id).first()
    if search_term is not None:
        search_form.search.data = search_term
    protocol_query = Protocol.query
Robin Sonnabend's avatar
Robin Sonnabend committed
363
364
365
366
367
368
369
370
371
    shall_search = search_term is not None and len(search_term.strip()) > 0
    search_terms = []
    if shall_search:
        search_terms = list(map(str.lower, split_terms(search_term)))
        for term in search_terms:
            protocol_query = protocol_query.filter(or_(
                Protocol.content_public.ilike("%{}%".format(term)),
                Protocol.content_private.ilike("%{}%".format(term))
            ))
372
    protocols = [
Robin Sonnabend's avatar
Robin Sonnabend committed
373
        protocol for protocol in protocol_query.all()
374
        if protocol.protocoltype.has_public_view_right(user, check_networks=False)
375
    ]
Robin Sonnabend's avatar
Robin Sonnabend committed
376
377
378
379
380
381
382
383
384
385
386
387
388
    def _matches_search(content):
        content = content.lower()
        for search_term in search_terms:
            if search_term.lower() not in content:
                return False
        return True
    def _matches_search_lazy(content):
        content = content.lower()
        for search_term in search_terms:
            if search_term.lower() in content:
                return True
        return False
    search_results = {} if shall_search else None
Robin Sonnabend's avatar
Robin Sonnabend committed
389
390
391
392
393
    if protocoltype_id is not None and protocoltype_id != -1:
        protocols = [
            protocol for protocol in protocols
            if protocol.protocoltype.id == protocoltype_id
        ]
Robin Sonnabend's avatar
Robin Sonnabend committed
394
395
396
397
398
    if shall_search:
        protocols = [
            protocol for protocol in protocols
            if (protocol.protocoltype.has_private_view_right(user)
                and _matches_search(protocol.content_private))
399
            or (protocol.has_public_view_right(user)
Robin Sonnabend's avatar
Robin Sonnabend committed
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
                and _matches_search(protocol.content_public))
        ]
        for protocol in protocols:
            content = protocol.content_private if protocol.protocoltype.has_private_view_right(user) else protocol.content_public
            lines = content.splitlines()
            matches = [line for line in lines if _matches_search_lazy(line)]
            formatted_lines = []
            for line in matches:
                parts = []
                lower_line = line.lower()
                last_index = 0
                while last_index < len(line):
                    index_candidates = list(filter(lambda t: t[0] != -1, 
                        [(lower_line.find(term, last_index), term) for term in search_terms]))
                    if len(index_candidates) == 0:
                        parts.append((line[last_index:], False))
                        break
                    else:
                        new_index, term = min(index_candidates, key=lambda t: t[0])
                        new_end_index = new_index + len(term)
                        parts.append((line[last_index:new_index], False))
                        parts.append((line[new_index:new_end_index], True))
                        last_index = new_end_index
                formatted_lines.append("".join([
                    "<b>{}</b>".format(text) if matched else text
                    for text, matched in parts
                ]))
427
            search_results[protocol] = " …<br />\n".join(formatted_lines)
Robin Sonnabend's avatar
Robin Sonnabend committed
428
    protocols = sorted(protocols, key=lambda protocol: protocol.date, reverse=True)
Robin Sonnabend's avatar
Robin Sonnabend committed
429
    page = _get_page()
430
    page_count = int(math.ceil(len(protocols) / config.PAGE_LENGTH))
Robin Sonnabend's avatar
Robin Sonnabend committed
431
432
433
434
435
    if page >= page_count:
        page = 0
    begin_index = page * config.PAGE_LENGTH
    end_index = (page + 1) * config.PAGE_LENGTH
    protocols = protocols[begin_index:end_index]
Robin Sonnabend's avatar
Robin Sonnabend committed
436
    protocols_table = ProtocolsTable(protocols, search_results=search_results)
Robin Sonnabend's avatar
Robin Sonnabend committed
437
    return render_template("protocols-list.html", protocols=protocols, protocols_table=protocols_table, search_form=search_form, page=page, page_count=page_count, page_diff=config.PAGE_DIFF, protocoltype_id=protocoltype_id, search_term=search_term)
Robin Sonnabend's avatar
Robin Sonnabend committed
438
439
440
441
442

@app.route("/protocol/new", methods=["GET", "POST"])
@login_required
def new_protocol():
    user = current_user()
Robin Sonnabend's avatar
Robin Sonnabend committed
443
    protocoltypes = ProtocolType.get_modifiable_protocoltypes(user)
Robin Sonnabend's avatar
Robin Sonnabend committed
444
    form = NewProtocolForm(protocoltypes)
Robin Sonnabend's avatar
Robin Sonnabend committed
445
    upload_form = NewProtocolSourceUploadForm(protocoltypes)
446
    file_upload_form = NewProtocolFileUploadForm(protocoltypes)
Robin Sonnabend's avatar
Robin Sonnabend committed
447
    if form.validate_on_submit():
448
        protocoltype = ProtocolType.query.filter_by(id=form.protocoltype_id.data).first()
Robin Sonnabend's avatar
Robin Sonnabend committed
449
450
451
        if protocoltype is None or not protocoltype.has_modify_right(user):
            flash("Dir fehlen die nötigen Zugriffsrechte.", "alert-error")
            return redirect(request.args.get("next") or url_for("index"))
452
453
        protocol = Protocol(protocoltype_id=protocoltype.id)
        form.populate_obj(protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
454
455
        db.session.add(protocol)
        db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
456
        tasks.push_tops_to_calendar(protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
457
        return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol.id))
458
    type_id = request.args.get("protocoltype_id")
Robin Sonnabend's avatar
Robin Sonnabend committed
459
460
    if type_id is not None:
        form.protocoltype.data = type_id
461
462
        upload_form.protocoltype.data = type_id
    return render_template("protocol-new.html", form=form, upload_form=upload_form, file_upload_form=file_upload_form, protocoltypes=protocoltypes)
Robin Sonnabend's avatar
Robin Sonnabend committed
463
464

@app.route("/protocol/show/<int:protocol_id>")
Robin Sonnabend's avatar
Robin Sonnabend committed
465
466
@db_lookup(Protocol)
def show_protocol(protocol):
Robin Sonnabend's avatar
Robin Sonnabend committed
467
468
    user = current_user()
    errors_table = ErrorsTable(protocol.errors)
469
    if not protocol.protocoltype.has_public_view_right(user, check_networks=False): # yes, feature
Robin Sonnabend's avatar
Robin Sonnabend committed
470
        flash("Die fehlen die nötigen Zugriffsrechte.", "alert-error")
471
        return redirect(request.args.get("next") or url_for("login", next=request.url))
Robin Sonnabend's avatar
Robin Sonnabend committed
472
473
    visible_documents = [
        document for document in protocol.documents
474
        if (not document.is_private and document.protocol.has_public_view_right(user))
Robin Sonnabend's avatar
Robin Sonnabend committed
475
476
477
        or (document.is_private and document.protocol.protocoltype.has_private_view_right(user))
    ]
    documents_table = DocumentsTable(visible_documents)
478
    document_upload_form = DocumentUploadForm()
Robin Sonnabend's avatar
Robin Sonnabend committed
479
    source_upload_form = KnownProtocolSourceUploadForm()
480
481
482
    time_diff = protocol.date - datetime.now().date()
    large_time_diff = not protocol.is_done() and time_diff.days > 0
    return render_template("protocol-show.html", protocol=protocol, errors_table=errors_table, documents_table=documents_table, document_upload_form=document_upload_form, source_upload_form=source_upload_form, time_diff=time_diff, large_time_diff=large_time_diff)
Robin Sonnabend's avatar
Robin Sonnabend committed
483

Robin Sonnabend's avatar
Robin Sonnabend committed
484
485
@app.route("/protocol/delete/<int:protocol_id>")
@login_required
486
@group_required(config.ADMIN_GROUP)
Robin Sonnabend's avatar
Robin Sonnabend committed
487
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
488
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
489
def delete_protocol(protocol):
Robin Sonnabend's avatar
Robin Sonnabend committed
490
    name = protocol.get_identifier()
Robin Sonnabend's avatar
Robin Sonnabend committed
491
    protocol.delete_orphan_todos()
Robin Sonnabend's avatar
Robin Sonnabend committed
492
493
494
495
496
    db.session.delete(protocol)
    db.session.commit()
    flash("Protokoll {} ist gelöscht.".format(name), "alert-success")
    return redirect(request.args.get("next") or url_for("list_protocols"))

Robin Sonnabend's avatar
Robin Sonnabend committed
497
@app.route("/protocol/etherpull/<int:protocol_id>")
Robin Sonnabend's avatar
Robin Sonnabend committed
498
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
499
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
500
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
501
def etherpull_protocol(protocol):
502
503
504
    if not config.ETHERPAD_ACTIVE:
        flash("Die Etherpadfunktion ist nicht aktiviert.", "alert-error")
        return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol_id))
Robin Sonnabend's avatar
Robin Sonnabend committed
505
    protocol.source = get_etherpad_text(protocol.get_identifier())
Robin Sonnabend's avatar
Robin Sonnabend committed
506
507
508
509
510
    db.session.commit()
    tasks.parse_protocol(protocol)
    flash("Das Protokoll wird kompiliert.", "alert-success")
    return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol.id))

Robin Sonnabend's avatar
Robin Sonnabend committed
511
512
@app.route("/protocol/upload/known/<int:protocol_id>", methods=["POST"])
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
513
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
514
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
515
def upload_source_to_known_protocol(protocol):
516
    form = KnownProtocolSourceUploadForm()
Robin Sonnabend's avatar
Robin Sonnabend committed
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
    if form.validate_on_submit():
        if form.source.data is None:
            flash("Es wurde keine Datei ausgewählt.", "alert-error")
        else:
            file = form.source.data
            if file.filename == "":
                flash("Es wurde keine Datei ausgewählt.", "alert-error")
            else:
                # todo: Prüfen, ob es Text ist?
                source = file.stream.read().decode("utf-8")
                protocol.source = source
                db.session.commit()
                tasks.parse_protocol(protocol)
                flash("Das Protokoll wird kompiliert.", "alert-success")
    return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol.id))

@app.route("/protocol/upload/new/", methods=["POST"])
@login_required
def upload_new_protocol():
    user = current_user()
537
    available_types = ProtocolType.get_modifiable_protocoltypes(user)
Robin Sonnabend's avatar
Robin Sonnabend committed
538
539
540
541
    form = NewProtocolSourceUploadForm(protocoltypes=available_types)
    if form.validate_on_submit():
        if form.source.data is None:
            flash("Es wurde keine Datei ausgewählt.", "alert-error")
542
543
544
545
546
547
            return redirect(request.args.get("fail") or url_for("new_protocol"))
        file = form.source.data
        if file.filename == "":
            flash("Es wurde keine Datei ausgewählt.", "alert-error")
            return redirect(request.args.get("fail") or url_for("new_protocol"))
        source = file.stream.read().decode("utf-8")
548
        protocoltype = ProtocolType.query.filter_by(id=form.protocoltype_id.data).first()
549
550
551
        if protocoltype is None or not protocoltype.has_modify_right(user):
            flash("Invalider Protokolltyp oder keine Rechte.", "alert-error")
            return redirect(request.args.get("fail") or url_for("new_protocol"))
552
        protocol = Protocol(protocoltype_id=protocoltype.id, source=source)
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
        db.session.add(protocol)
        db.session.commit()
        tasks.parse_protocol(protocol)
        return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol.id))
    return redirect(request.args.get("fail") or url_for("new_protocol"))

@app.route("/protocol/upload/new/file/", methods=["POST"])
@login_required
def upload_new_protocol_by_file():
    user = current_user()
    available_types = ProtocolType.get_modifiable_protocoltypes(user)
    form = NewProtocolFileUploadForm(protocoltypes=available_types)
    if form.validate_on_submit():
        if form.file.data is None:
            flash("Es wurde keine Datei ausgewählt.", "alert-error")
            return redirect(request.args.get("fail") or url_for("new_protocol"))
        file = form.file.data
        if file.filename == "":
            flash("Es wurde keine Datei ausgewählt.", "alert-error")
            return redirect(request.args.get("fail") or url_for("new_protocol"))
        filename = secure_filename(file.filename)
574
        protocoltype = ProtocolType.query.filter_by(id=form.protocoltype_id.data).first()
575
576
577
        if protocoltype is None or not protocoltype.has_modify_right(user):
            flash("Invalider Protokolltyp oder keine Rechte.", "alert-error")
            return redirect(request.args.get("fail") or url_for("new_protocol"))
578
        protocol = Protocol(protocoltype_id=protocoltype.id, date=datetime.now().date(), done=True)
579
580
        db.session.add(protocol)
        db.session.commit()
581
582
583
        document = Document(protocol_id=protocol.id, name=filename,
            filename="", is_compiled=False)
        form.populate_obj(document)
584
585
586
587
588
589
590
        db.session.add(document)
        db.session.commit()
        internal_filename = "{}-{}-{}".format(protocol.id, document.id, filename)
        document.filename = internal_filename
        file.save(os.path.join(config.DOCUMENTS_PATH, internal_filename))
        db.session.commit()
        return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol.id))
Robin Sonnabend's avatar
Robin Sonnabend committed
591
592
    return redirect(request.args.get("fail") or url_for("new_protocol"))

Administrator's avatar
Administrator committed
593
594
595
@app.route("/protocol/recompile/<int:protocol_id>")
@login_required
@group_required(config.ADMIN_GROUP)
Robin Sonnabend's avatar
Robin Sonnabend committed
596
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
597
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
598
def recompile_protocol(protocol):
Administrator's avatar
Administrator committed
599
600
    tasks.parse_protocol(protocol)
    return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol.id))
601

Robin Sonnabend's avatar
Robin Sonnabend committed
602
603
@app.route("/protocol/source/<int:protocol_id>")
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
604
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
605
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
606
def get_protocol_source(protocol):
Robin Sonnabend's avatar
Robin Sonnabend committed
607
608
609
    file_like = BytesIO(protocol.source.encode("utf-8"))
    return send_file(file_like, cache_timeout=1, as_attachment=True, attachment_filename="{}.txt".format(protocol.get_identifier()))

Robin Sonnabend's avatar
Robin Sonnabend committed
610
611
@app.route("/protocol/template/<int:protocol_id>")
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
612
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
613
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
614
def get_protocol_template(protocol):
Robin Sonnabend's avatar
Robin Sonnabend committed
615
616
617
    file_like = BytesIO(protocol.get_template().encode("utf-8"))
    return send_file(file_like, cache_timeout=1, as_attachment=True, attachment_filename="{}-template.txt".format(protocol.get_identifier()))

Robin Sonnabend's avatar
Robin Sonnabend committed
618
619
@app.route("/protocol/etherpush/<int:protocol_id>")
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
620
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
621
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
622
def etherpush_protocol(protocol):
623
624
625
    if not config.ETHERPAD_ACTIVE:
        flash("Die Etherpadfunktion ist nicht aktiviert.", "alert-error")
        return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol_id))
626
627
628
    if not protocol.is_done():
        tasks.set_etherpad_content(protocol)
    return redirect(request.args.get("next") or protocol.get_etherpad_link())
Robin Sonnabend's avatar
Robin Sonnabend committed
629

Robin Sonnabend's avatar
Robin Sonnabend committed
630
@app.route("/protocol/update/<int:protocol_id>", methods=["GET", "POST"])
Robin Sonnabend's avatar
Robin Sonnabend committed
631
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
632
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
633
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
634
def update_protocol(protocol):
Robin Sonnabend's avatar
Robin Sonnabend committed
635
    upload_form = KnownProtocolSourceUploadForm()
Robin Sonnabend's avatar
Robin Sonnabend committed
636
    edit_form = ProtocolForm(obj=protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
637
638
639
    if edit_form.validate_on_submit():
        edit_form.populate_obj(protocol)
        db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
640
        tasks.push_tops_to_calendar(protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
641
        return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol.id))
Robin Sonnabend's avatar
Robin Sonnabend committed
642
    return render_template("protocol-update.html", upload_form=upload_form, edit_form=edit_form, protocol=protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
643

644
645
@app.route("/protocol/publish/<int:protocol_id>")
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
646
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
647
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
648
def publish_protocol(protocol):
649
650
651
652
    protocol.public = True
    db.session.commit()
    return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol.id))

653
654
@app.route("/prococol/send/<int:protocol_id>")
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
655
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
656
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
657
def send_protocol(protocol):
658
659
660
    if not config.MAIL_ACTIVE:
        flash("Die Mailfunktion ist nicht aktiviert.", "alert-error")
        return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol_id))
661
662
663
664
    tasks.send_protocol(protocol)
    flash("Das Protokoll wurde versandt.", "alert-success")
    return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol.id))

665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
@app.route("/protocol/reminder/<int:protocol_id>")
@login_required
@db_lookup(Protocol)
@require_modify_right()
def send_protocol_reminder(protocol):
    if not config.MAIL_ACTIVE:
        flash("Die Mailfunktion ist nicht aktiviert.", "alert-error")
        return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol_id))
    meetingreminders = MeetingReminder.query.filter_by(protocoltype_id=protocol.protocoltype.id).all()
    if len(meetingreminders) == 0:
        flash("Für diesen Protokolltyp sind keine Einladungsmails konfiguriert.", "alert-error")
        return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol_id))
    day_difference = (protocol.date - datetime.now().date()).days
    past_reminders = [
        meetingreminder for meetingreminder in meetingreminders
        if meetingreminder.days_before > day_difference
    ]
    if len(past_reminders) == 0:
        flash("Bisher hätte keine Einladungsmail verschickt werden sollen, schicke letzte.", "alert-info")
        past_reminders = meetingreminders
    past_reminders = sorted(past_reminders, key=lambda r: r.days_before)
    choosen_reminder = past_reminders[0]
    tasks.send_reminder(choosen_reminder, protocol)
    flash("Einladungsmail ist versandt.", "alert-success")
    return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol.id))
        

Robin Sonnabend's avatar
Robin Sonnabend committed
692
693
@app.route("/protocol/tops/new/<int:protocol_id>", methods=["GET", "POST"])
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
694
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
695
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
696
def new_top(protocol):
Robin Sonnabend's avatar
Robin Sonnabend committed
697
698
    form = TopForm()
    if form.validate_on_submit():
699
700
        top = TOP(protocol_id=protocol.id, planned=True)
        form.populate_obj(top)
Robin Sonnabend's avatar
Robin Sonnabend committed
701
702
        db.session.add(top)
        db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
703
        tasks.push_tops_to_calendar(top.protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
704
705
706
707
708
709
710
711
712
        return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol.id))
    else:
        current_numbers = list(map(lambda t: t.number, protocol.tops))
        suggested_number = get_first_unused_int(current_numbers)
        form.number.data = suggested_number
    return render_template("top-new.html", form=form, protocol=protocol)

@app.route("/protocol/top/edit/<int:top_id>", methods=["GET", "POST"])
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
713
@db_lookup(TOP)
Robin Sonnabend's avatar
Robin Sonnabend committed
714
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
715
def edit_top(top):
Robin Sonnabend's avatar
Robin Sonnabend committed
716
717
718
719
    form = TopForm(obj=top)
    if form.validate_on_submit():
        form.populate_obj(top)
        db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
720
        tasks.push_tops_to_calendar(top.protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
721
722
723
724
725
        return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=top.protocol.id))
    return render_template("top-edit.html", form=form, top=top)

@app.route("/protocol/top/delete/<int:top_id>")
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
726
@db_lookup(TOP)
Robin Sonnabend's avatar
Robin Sonnabend committed
727
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
728
def delete_top(top):
Robin Sonnabend's avatar
Robin Sonnabend committed
729
    name = top.name
Robin Sonnabend's avatar
Robin Sonnabend committed
730
    protocol = top.protocol
Robin Sonnabend's avatar
Robin Sonnabend committed
731
732
    db.session.delete(top)
    db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
733
    tasks.push_tops_to_calendar(protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
734
    flash("Der TOP {} wurde gelöscht.".format(name), "alert-success")
Robin Sonnabend's avatar
Robin Sonnabend committed
735
    return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol.id))
Robin Sonnabend's avatar
Robin Sonnabend committed
736
737
738

@app.route("/protocol/top/move/<int:top_id>/<diff>")
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
739
@db_lookup(TOP)
Robin Sonnabend's avatar
Robin Sonnabend committed
740
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
741
def move_top(top, diff):
Robin Sonnabend's avatar
Robin Sonnabend committed
742
743
744
    try:
        top.number += int(diff)
        db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
745
        tasks.push_tops_to_calendar(top.protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
746
747
748
749
    except ValueError:
        flash("Die angegebene Differenz ist keine Zahl.", "alert-error")
    return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=top.protocol.id))

Robin Sonnabend's avatar
Robin Sonnabend committed
750
751
752
753
754
755
756
757
758
def _get_page():
    try:
        page = request.args.get("page")
        if page is None:
            return 0
        return int(page)
    except ValueError:
        return 0

759
@app.route("/todos/list")
Robin Sonnabend's avatar
Robin Sonnabend committed
760
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
761
762
def list_todos():
    user = current_user()
Robin Sonnabend's avatar
Robin Sonnabend committed
763
764
765
    protocoltype = None
    protocoltype_id = None
    try:
766
        protocoltype_id = int(request.args.get("protocoltype_id"))
Robin Sonnabend's avatar
Robin Sonnabend committed
767
768
769
    except (ValueError, TypeError):
        pass
    search_term = request.args.get("search")
Robin Sonnabend's avatar
Robin Sonnabend committed
770
    protocoltypes = ProtocolType.get_public_protocoltypes(user)
Robin Sonnabend's avatar
Robin Sonnabend committed
771
772
    search_form = SearchForm(protocoltypes)
    if protocoltype_id is not None:
773
        search_form.protocoltype_id.data = protocoltype_id
Robin Sonnabend's avatar
Robin Sonnabend committed
774
        protocoltype = ProtocolType.query.filter_by(id=protocoltype_id).first()
775
776
    if search_term is not None:
        search_form.search.data = search_term
Robin Sonnabend's avatar
Robin Sonnabend committed
777
778
779
780
    todos = [
        todo for todo in Todo.query.all()
        if todo.protocoltype.has_public_view_right(user)
    ]
Robin Sonnabend's avatar
Robin Sonnabend committed
781
    if protocoltype_id is not None and protocoltype_id != -1:
Robin Sonnabend's avatar
Robin Sonnabend committed
782
783
784
785
        todos = [
            todo for todo in todos
            if todo.protocoltype.id == protocoltype_id
        ]
Robin Sonnabend's avatar
Robin Sonnabend committed
786
    if search_term is not None and len(search_term.strip()) > 0:
Robin Sonnabend's avatar
Robin Sonnabend committed
787
788
789
        todos = [
            todo for todo in todos
            if search_term.lower() in todo.description.lower()
790
            or search_term.lower() in todo.who.lower()
Robin Sonnabend's avatar
Robin Sonnabend committed
791
        ]
Robin Sonnabend's avatar
Robin Sonnabend committed
792
    def _sort_key(todo):
Administrator's avatar
Administrator committed
793
        return (not todo.is_done(), todo.get_id())
Robin Sonnabend's avatar
Robin Sonnabend committed
794
    todos = sorted(todos, key=_sort_key, reverse=True)
Robin Sonnabend's avatar
Robin Sonnabend committed
795
    page = _get_page()
Robin Sonnabend's avatar
Robin Sonnabend committed
796
    page_count = int(math.ceil(len(todos) / config.PAGE_LENGTH))
Robin Sonnabend's avatar
Robin Sonnabend committed
797
798
799
800
    if page >= page_count:
        page = 0
    begin_index = page * config.PAGE_LENGTH
    end_index = (page + 1) * config.PAGE_LENGTH
Robin Sonnabend's avatar
Robin Sonnabend committed
801
    todos = todos[begin_index:end_index]
Robin Sonnabend's avatar
Robin Sonnabend committed
802
    todos_table = TodosTable(todos)
Robin Sonnabend's avatar
Robin Sonnabend committed
803
    return render_template("todos-list.html", todos=todos, todos_table=todos_table, search_form=search_form, page=page, page_count=page_count, page_diff=config.PAGE_DIFF, protocoltype_id=protocoltype_id, search_term=search_term)
Robin Sonnabend's avatar
Robin Sonnabend committed
804

Robin Sonnabend's avatar
Robin Sonnabend committed
805
806
807
808
@app.route("/todo/new", methods=["GET", "POST"])
@login_required
def new_todo():
    user = current_user()
809
    protocoltype_id = optional_int_arg("protocoltype_id")
Robin Sonnabend's avatar
Robin Sonnabend committed
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
    protocol_id = optional_int_arg("protocol_id")
    protocoltype = ProtocolType.query.filter_by(id=protocoltype_id).first()
    protocol = Protocol.query.filter_by(id=protocol_id).first()
    if protocoltype is not None and protocol is not None:
        if protocol.protocoltype != protocoltype:
            flash("Ungültige Protokoll-Typ-Kombination", "alert-error")
            return redirect(request.args.get("next") or url_for("index"))
    if protocoltype is None and protocol is not None:
        protocoltype = protocol.protocoltype
    protocoltypes = ProtocolType.get_modifiable_protocoltypes(user)
    form = NewTodoForm(protocoltypes)
    if form.validate_on_submit():
        added_protocoltype = ProtocolType.query.filter_by(id=form.protocoltype_id.data).first()
        if added_protocoltype is None or not added_protocoltype.has_modify_right(user):
            flash("Invalider Protokolltyp.")
            return redirect(request.args.get("next") or url_for("index"))
826
827
        todo = Todo()
        form.populate_obj(todo)
Robin Sonnabend's avatar
Robin Sonnabend committed
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
        if protocol is not None:
            todo.protocols.append(protocol)
        db.session.add(todo)
        db.session.commit()
        todo.number = todo.id
        db.session.commit()
        flash("Todo wurde angelegt.", "alert-success")
        if protocol is not None:
            return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol.id))
        else:
            return redirect(request.args.get("next") or url_for("list_todos", protocoltype_id=protocoltype_id))
    else:
        if protocoltype is not None:
            form.protocoltype_id.data = protocoltype.id
    return render_template("todo-new.html", form=form, protocol=protocol, protocoltype=protocoltype)

@app.route("/todo/edit/<int:todo_id>", methods=["GET", "POST"])
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
846
@db_lookup(Todo)
Robin Sonnabend's avatar
Robin Sonnabend committed
847
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
848
def edit_todo(todo):
Robin Sonnabend's avatar
Robin Sonnabend committed
849
850
851
852
    form = TodoForm(obj=todo)
    if form.validate_on_submit():
        form.populate_obj(todo)
        db.session.commit()
853
        return redirect(request.args.get("next") or url_for("list_todos", protocoltype_id=todo.protocoltype.id))
Robin Sonnabend's avatar
Robin Sonnabend committed
854
855
856
857
    return render_template("todo-edit.html", form=form, todo=todo)

@app.route("/todo/show/<int:todo_id>")
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
858
@db_lookup(Todo)
Robin Sonnabend's avatar
Robin Sonnabend committed
859
@require_private_view_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
860
def show_todo(todo):
Robin Sonnabend's avatar
Robin Sonnabend committed
861
862
863
864
865
    todo_table = TodoTable(todo)
    return render_template("todo-show.html", todo=todo, todo_table=todo_table)

@app.route("/todo/delete/<int:todo_id>")
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
866
@db_lookup(Todo)
Robin Sonnabend's avatar
Robin Sonnabend committed
867
@require_private_view_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
868
def delete_todo(todo):
Robin Sonnabend's avatar
Robin Sonnabend committed
869
870
871
872
    type_id = todo.protocoltype.id
    db.session.delete(todo)
    db.session.commit()
    flash("Todo gelöscht.", "alert-success")
873
    return redirect(request.args.get("next") or url_for("list_todos", protocoltype_id=type_id))
Robin Sonnabend's avatar
Robin Sonnabend committed
874

875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
@app.route("/todo/merge", methods=["GET", "POST"])
@login_required
@group_required(config.ADMIN_GROUP)
def merge_todos():
    form = MergeTodosForm(request.args.get("todo_id"))
    if form.validate_on_submit():
        todo1 = Todo.query.filter_by(id=form.todo1.data).first()
        todo2 = Todo.query.filter_by(id=todo.todo2.data).first()
        if todo1 is None or todo2 is None:
            flash("Missing todos.", "alert-error")
        else:
            id1 = todo1.id
            id2 = todo2.id
            for protocol in todo2.protocols:
                if protocol not in todo1.protocols:
                    todo1.protocols.append(protocol)
                todo2.protocols.remove(protocol)
            db.session.delete(todo2)
            db.session.commit()
            flash("Merged todos {} and {}.".format(id1, id2), "alert-success")
895
            return redirect(request.args.get("next") or url_for("list_todos"))
896
897
    return render_template("todos-merge.html", form=form, next_url=request.args.get("next"))

Robin Sonnabend's avatar
Robin Sonnabend committed
898
899
900
901
902
903
@app.route("/decisions/list")
def list_decisions():
    is_logged_In = check_login()
    user = current_user()
    protocoltype = None
    protocoltype_id = None
904
905
    decisioncategory = None
    decisioncategory_id = None
Robin Sonnabend's avatar
Robin Sonnabend committed
906
    try:
907
        protocoltype_id = int(request.args.get("protocoltype_id"))
Robin Sonnabend's avatar
Robin Sonnabend committed
908
909
    except (ValueError, TypeError):
        pass
910
911
912
913
    try:
        decisioncategory_id = int(request.args.get("decisioncategory_id"))
    except (ValueError, TypeError):
        pass
Robin Sonnabend's avatar
Robin Sonnabend committed
914
915
    search_term = request.args.get("search")
    protocoltypes = ProtocolType.get_public_protocoltypes(user)
916
917
918
919
920
921
    decisioncategories = [
        category
        for protocoltype in protocoltypes
        for category in protocoltype.decisioncategories
    ]
    search_form = DecisionSearchForm(protocoltypes, decisioncategories)
Robin Sonnabend's avatar
Robin Sonnabend committed
922
    if protocoltype_id is not None:
923
        search_form.protocoltype_id.data = protocoltype_id
Robin Sonnabend's avatar
Robin Sonnabend committed
924
        protocoltype = ProtocolType.query.filter_by(id=protocoltype_id).first()
925
926
927
    if decisioncategory_id is not None:
        search_form.decisioncategory_id.data = decisioncategory_id
        decisioncategory = DecisionCategory.query.filter_by(id=decisioncategory_id).first()
Robin Sonnabend's avatar
Robin Sonnabend committed
928
929
930
931
    if search_term is not None:
        search_form.search.data = search_term
    decisions = [
        decision for decision in Decision.query.all()
932
        if decision