server.py 49.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
Robin Sonnabend's avatar
Robin Sonnabend committed
23
from shared import db, date_filter, datetime_filter, date_filter_long, date_filter_short, time_filter, 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
Robin Sonnabend's avatar
Robin Sonnabend committed
26
from models.database import ProtocolType, Protocol, DefaultTOP, TOP, Document, Todo, Decision, MeetingReminder, Error, TodoMail, DecisionDocument, TodoState, Meta, DefaultMeta
27
from views.forms import LoginForm, ProtocolTypeForm, DefaultTopForm, MeetingReminderForm, NewProtocolForm, DocumentUploadForm, KnownProtocolSourceUploadForm, NewProtocolSourceUploadForm, ProtocolForm, TopForm, SearchForm, NewProtocolFileUploadForm, NewTodoForm, TodoForm, TodoMailForm, DefaultMetaForm, MetaForm, MergeTodosForm
Robin Sonnabend's avatar
Robin Sonnabend committed
28
from views.tables import ProtocolsTable, ProtocolTypesTable, ProtocolTypeTable, DefaultTOPsTable, MeetingRemindersTable, ErrorsTable, TodosTable, DocumentsTable, DecisionsTable, TodoTable, ErrorTable, TodoMailsTable, DefaultMetasTable
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
Robin Sonnabend's avatar
Robin Sonnabend committed
54
app.jinja_env.filters["datify_short"] = date_filter_short
Robin Sonnabend's avatar
Robin Sonnabend committed
55
app.jinja_env.filters["datify_long"] = date_filter_long
56
app.jinja_env.filters["url_complete"] = url_manager.complete
57
app.jinja_env.filters["class"] = class_filter
Robin Sonnabend's avatar
Robin Sonnabend committed
58
59
app.jinja_env.filters["todo_get_name"] = todostate_name_filter
app.jinja_env.filters["code"] = code_filter
Robin Sonnabend's avatar
Robin Sonnabend committed
60
app.jinja_env.filters["indent_tab"] = indent_tab_filter
61
app.jinja_env.tests["auth_valid"] = security_manager.check_user
Robin Sonnabend's avatar
Robin Sonnabend committed
62
app.jinja_env.tests["needs_date"] = needs_date_test
63
64
65

import tasks

66
67
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
68
app.jinja_env.globals.update(zip=zip)
Robin Sonnabend's avatar
Robin Sonnabend committed
69
70
71
app.jinja_env.globals.update(min=min)
app.jinja_env.globals.update(max=max)
app.jinja_env.globals.update(dir=dir)
72

73
74
# blueprints here

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

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
@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():
117
    app.run()
118
119
    make_scheduler()

120
121
122
123
# 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)
124
125
126
127
128
129
130
131
    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"
132
    return response
133

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

Robin Sonnabend's avatar
Robin Sonnabend committed
181
@app.route("/documentation")
Robin Sonnabend's avatar
Robin Sonnabend committed
182
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
183
def documentation():
Robin Sonnabend's avatar
Robin Sonnabend committed
184
185
186
    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
187

Robin Sonnabend's avatar
Robin Sonnabend committed
188
@app.route("/types/list")
Robin Sonnabend's avatar
Robin Sonnabend committed
189
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
190
191
192
193
194
195
196
197
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)]
198
    types = sorted(types, key=lambda t: t.short_name)
Robin Sonnabend's avatar
Robin Sonnabend committed
199
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:
            protocoltype = ProtocolType(form.name.data, form.short_name.data,
Robin Sonnabend's avatar
Robin Sonnabend committed
212
                form.organization.data, form.usual_time.data, form.is_public.data,
213
                form.modify_group.data, form.private_group.data, form.public_group.data,
Robin Sonnabend's avatar
Robin Sonnabend committed
214
215
                form.private_mail.data, form.public_mail.data,
                form.use_wiki.data, form.wiki_category.data,
216
                form.wiki_only_public.data, form.printer.data,
217
218
                form.calendar.data, form.restrict_networks.data,
                form.allowed_networks.data)
Robin Sonnabend's avatar
Robin Sonnabend committed
219
220
221
222
223
224
            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
225
@app.route("/type/edit/<int:protocoltype_id>", methods=["GET", "POST"])
Robin Sonnabend's avatar
Robin Sonnabend committed
226
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
227
@db_lookup(ProtocolType)
Robin Sonnabend's avatar
Robin Sonnabend committed
228
@require_private_view_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
229
def edit_type(protocoltype):
Robin Sonnabend's avatar
Robin Sonnabend committed
230
231
232
233
234
235
236
237
    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
238
            return redirect(request.args.get("next") or url_for("show_type", protocoltype_id=protocoltype.id))
Robin Sonnabend's avatar
Robin Sonnabend committed
239
240
    return render_template("type-edit.html", form=form, protocoltype=protocoltype)

Robin Sonnabend's avatar
Robin Sonnabend committed
241
@app.route("/type/show/<int:protocoltype_id>")
Robin Sonnabend's avatar
Robin Sonnabend committed
242
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
243
@db_lookup(ProtocolType)
Robin Sonnabend's avatar
Robin Sonnabend committed
244
@require_private_view_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
245
def show_type(protocoltype):
Robin Sonnabend's avatar
Robin Sonnabend committed
246
247
    protocoltype_table = ProtocolTypeTable(protocoltype)
    default_tops_table = DefaultTOPsTable(protocoltype.default_tops, protocoltype)
248
    reminders_table = MeetingRemindersTable(protocoltype.reminders, protocoltype)
Robin Sonnabend's avatar
Robin Sonnabend committed
249
250
    metas_table = DefaultMetasTable(protocoltype.metas, 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)
251

Robin Sonnabend's avatar
Robin Sonnabend committed
252
@app.route("/type/delete/<int:protocoltype_id>")
253
@login_required
254
@group_required(config.ADMIN_GROUP)
Robin Sonnabend's avatar
Robin Sonnabend committed
255
@db_lookup(ProtocolType)
Robin Sonnabend's avatar
Robin Sonnabend committed
256
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
257
def delete_type(protocoltype):
258
259
260
261
262
263
    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
264
@app.route("/type/reminders/new/<int:protocoltype_id>", methods=["GET", "POST"])
265
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
266
@db_lookup(ProtocolType)
Robin Sonnabend's avatar
Robin Sonnabend committed
267
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
268
def new_reminder(protocoltype):
269
270
    form = MeetingReminderForm()
    if form.validate_on_submit():
Robin Sonnabend's avatar
Robin Sonnabend committed
271
272
        meetingreminder = MeetingReminder(protocoltype.id, form.days_before.data, form.send_public.data, form.send_private.data, form.additional_text.data)
        db.session.add(meetingreminder)
273
        db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
274
        return redirect(request.args.get("next") or url_for("show_type", protocoltype_id=protocoltype.id))
275
276
    return render_template("reminder-new.html", form=form, protocoltype=protocoltype)

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

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

Robin Sonnabend's avatar
Robin Sonnabend committed
299
@app.route("/type/tops/new/<int:protocoltype_id>", methods=["GET", "POST"])
Robin Sonnabend's avatar
Robin Sonnabend committed
300
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
301
@db_lookup(ProtocolType)
Robin Sonnabend's avatar
Robin Sonnabend committed
302
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
303
def new_default_top(protocoltype):
Robin Sonnabend's avatar
Robin Sonnabend committed
304
305
    form = DefaultTopForm()
    if form.validate_on_submit():
Robin Sonnabend's avatar
Robin Sonnabend committed
306
307
        defaulttop = DefaultTOP(protocoltype.id, form.name.data, form.number.data)
        db.session.add(defaulttop)
Robin Sonnabend's avatar
Robin Sonnabend committed
308
        db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
309
        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
310
311
312
        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
313
@app.route("/type/tops/edit/<int:protocoltype_id>/<int:defaulttop_id>", methods=["GET", "POST"])
Robin Sonnabend's avatar
Robin Sonnabend committed
314
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
315
@db_lookup(ProtocolType, DefaultTOP)
Robin Sonnabend's avatar
Robin Sonnabend committed
316
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
317
318
def edit_default_top(protocoltype, defaulttop):
    form = DefaultTopForm(obj=defaulttop)
Robin Sonnabend's avatar
Robin Sonnabend committed
319
    if form.validate_on_submit():
Robin Sonnabend's avatar
Robin Sonnabend committed
320
        form.populate_obj(defaulttop)
Robin Sonnabend's avatar
Robin Sonnabend committed
321
        db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
322
323
        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
324

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

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

@app.route("/protocols/list")
347
348
349
def list_protocols():
    is_logged_in = check_login()
    user = current_user()
Robin Sonnabend's avatar
Robin Sonnabend committed
350
351
352
    protocoltype = None
    protocoltype_id = None
    try:
353
        protocoltype_id = int(request.args.get("protocoltype_id"))
Robin Sonnabend's avatar
Robin Sonnabend committed
354
355
356
357
358
359
360
361
362
363
364
    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:
        search_form.protocoltype.data = protocoltype_id
        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
365
366
367
368
369
370
371
372
373
    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))
            ))
374
    protocols = [
Robin Sonnabend's avatar
Robin Sonnabend committed
375
        protocol for protocol in protocol_query.all()
376
        if protocol.protocoltype.has_public_view_right(user, check_networks=False)
377
    ]
Robin Sonnabend's avatar
Robin Sonnabend committed
378
379
380
381
382
383
384
385
386
387
388
389
390
    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
391
392
393
394
395
    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
396
397
398
399
400
    if shall_search:
        protocols = [
            protocol for protocol in protocols
            if (protocol.protocoltype.has_private_view_right(user)
                and _matches_search(protocol.content_private))
401
            or (protocol.has_public_view_right(user)
Robin Sonnabend's avatar
Robin Sonnabend committed
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
427
428
                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
                ]))
429
            search_results[protocol] = " …<br />\n".join(formatted_lines)
Robin Sonnabend's avatar
Robin Sonnabend committed
430
    protocols = sorted(protocols, key=lambda protocol: protocol.date, reverse=True)
Robin Sonnabend's avatar
Robin Sonnabend committed
431
    page = _get_page()
432
    page_count = int(math.ceil(len(protocols) / config.PAGE_LENGTH))
Robin Sonnabend's avatar
Robin Sonnabend committed
433
434
435
436
437
    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
438
    protocols_table = ProtocolsTable(protocols, search_results=search_results)
Robin Sonnabend's avatar
Robin Sonnabend committed
439
    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
440
441
442
443
444

@app.route("/protocol/new", methods=["GET", "POST"])
@login_required
def new_protocol():
    user = current_user()
Robin Sonnabend's avatar
Robin Sonnabend committed
445
    protocoltypes = ProtocolType.get_modifiable_protocoltypes(user)
Robin Sonnabend's avatar
Robin Sonnabend committed
446
    form = NewProtocolForm(protocoltypes)
Robin Sonnabend's avatar
Robin Sonnabend committed
447
    upload_form = NewProtocolSourceUploadForm(protocoltypes)
448
    file_upload_form = NewProtocolFileUploadForm(protocoltypes)
Robin Sonnabend's avatar
Robin Sonnabend committed
449
450
451
452
453
454
455
456
    if form.validate_on_submit():
        protocoltype = ProtocolType.query.filter_by(id=form.protocoltype.data).first()
        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"))
        protocol = Protocol(protocoltype.id, form.date.data)
        db.session.add(protocol)
        db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
457
        tasks.push_tops_to_calendar(protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
458
        return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol.id))
459
    type_id = request.args.get("protocoltype_id")
Robin Sonnabend's avatar
Robin Sonnabend committed
460
461
    if type_id is not None:
        form.protocoltype.data = type_id
462
463
        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
464
465

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

Robin Sonnabend's avatar
Robin Sonnabend committed
483
484
@app.route("/protocol/delete/<int:protocol_id>")
@login_required
485
@group_required(config.ADMIN_GROUP)
Robin Sonnabend's avatar
Robin Sonnabend committed
486
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
487
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
488
def delete_protocol(protocol):
Robin Sonnabend's avatar
Robin Sonnabend committed
489
    name = protocol.get_identifier()
Robin Sonnabend's avatar
Robin Sonnabend committed
490
    protocol.delete_orphan_todos()
Robin Sonnabend's avatar
Robin Sonnabend committed
491
492
493
494
495
    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
496
@app.route("/protocol/etherpull/<int:protocol_id>")
Robin Sonnabend's avatar
Robin Sonnabend committed
497
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
498
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
499
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
500
def etherpull_protocol(protocol):
501
502
503
    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
504
    protocol.source = get_etherpad_text(protocol.get_identifier())
Robin Sonnabend's avatar
Robin Sonnabend committed
505
506
507
508
509
    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
510
511
@app.route("/protocol/upload/known/<int:protocol_id>", methods=["POST"])
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
512
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
513
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
514
def upload_source_to_known_protocol(protocol):
515
    form = KnownProtocolSourceUploadForm()
Robin Sonnabend's avatar
Robin Sonnabend committed
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
    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()
536
    available_types = ProtocolType.get_modifiable_protocoltypes(user)
Robin Sonnabend's avatar
Robin Sonnabend committed
537
538
539
540
    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")
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
            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")
        protocoltype = ProtocolType.query.filter_by(id=form.protocoltype.data).first()
        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"))
        protocol = Protocol(protocoltype.id, None, source)
        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)
        protocoltype = ProtocolType.query.filter_by(id=form.protocoltype.data).first()
        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"))
        protocol = Protocol(protocoltype.id, datetime.now().date(), done=True)
        db.session.add(protocol)
        db.session.commit()
        document = Document(protocol.id, filename, "", False, form.private.data)
        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
588
589
    return redirect(request.args.get("fail") or url_for("new_protocol"))

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

Robin Sonnabend's avatar
Robin Sonnabend committed
599
600
@app.route("/protocol/source/<int:protocol_id>")
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
601
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
602
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
603
def get_protocol_source(protocol):
Robin Sonnabend's avatar
Robin Sonnabend committed
604
605
606
    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
607
608
@app.route("/protocol/template/<int:protocol_id>")
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
609
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
610
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
611
def get_protocol_template(protocol):
Robin Sonnabend's avatar
Robin Sonnabend committed
612
613
614
    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
615
616
@app.route("/protocol/etherpush/<int:protocol_id>")
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
617
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
618
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
619
def etherpush_protocol(protocol):
620
621
622
    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))
623
624
625
    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
626

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

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

650
651
@app.route("/prococol/send/<int:protocol_id>")
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
652
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
653
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
654
def send_protocol(protocol):
655
656
657
    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))
658
659
660
661
    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))

Robin Sonnabend's avatar
Robin Sonnabend committed
662
663
@app.route("/protocol/tops/new/<int:protocol_id>", methods=["GET", "POST"])
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
664
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
665
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
666
def new_top(protocol):
Robin Sonnabend's avatar
Robin Sonnabend committed
667
668
    form = TopForm()
    if form.validate_on_submit():
669
        top = TOP(protocol_id=protocol.id, name=form.name.data, number=form.number.data, planned=True, description=form.description.data)
Robin Sonnabend's avatar
Robin Sonnabend committed
670
671
        db.session.add(top)
        db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
672
        tasks.push_tops_to_calendar(top.protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
673
674
675
676
677
678
679
680
681
        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
682
@db_lookup(TOP)
Robin Sonnabend's avatar
Robin Sonnabend committed
683
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
684
def edit_top(top):
Robin Sonnabend's avatar
Robin Sonnabend committed
685
686
687
688
    form = TopForm(obj=top)
    if form.validate_on_submit():
        form.populate_obj(top)
        db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
689
        tasks.push_tops_to_calendar(top.protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
690
691
692
693
694
        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
695
@db_lookup(TOP)
Robin Sonnabend's avatar
Robin Sonnabend committed
696
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
697
def delete_top(top):
Robin Sonnabend's avatar
Robin Sonnabend committed
698
    name = top.name
Robin Sonnabend's avatar
Robin Sonnabend committed
699
    protocol = top.protocol
Robin Sonnabend's avatar
Robin Sonnabend committed
700
701
    db.session.delete(top)
    db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
702
    tasks.push_tops_to_calendar(protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
703
    flash("Der TOP {} wurde gelöscht.".format(name), "alert-success")
Robin Sonnabend's avatar
Robin Sonnabend committed
704
    return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol.id))
Robin Sonnabend's avatar
Robin Sonnabend committed
705
706
707

@app.route("/protocol/top/move/<int:top_id>/<diff>")
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
708
@db_lookup(TOP)
Robin Sonnabend's avatar
Robin Sonnabend committed
709
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
710
def move_top(top, diff):
Robin Sonnabend's avatar
Robin Sonnabend committed
711
712
713
    try:
        top.number += int(diff)
        db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
714
        tasks.push_tops_to_calendar(top.protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
715
716
717
718
    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
719
720
721
722
723
724
725
726
727
def _get_page():
    try:
        page = request.args.get("page")
        if page is None:
            return 0
        return int(page)
    except ValueError:
        return 0

728
@app.route("/todos/list")
Robin Sonnabend's avatar
Robin Sonnabend committed
729
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
730
731
def list_todos():
    user = current_user()
Robin Sonnabend's avatar
Robin Sonnabend committed
732
733
734
    protocoltype = None
    protocoltype_id = None
    try:
735
        protocoltype_id = int(request.args.get("protocoltype_id"))
Robin Sonnabend's avatar
Robin Sonnabend committed
736
737
738
    except (ValueError, TypeError):
        pass
    search_term = request.args.get("search")
Robin Sonnabend's avatar
Robin Sonnabend committed
739
    protocoltypes = ProtocolType.get_public_protocoltypes(user)
Robin Sonnabend's avatar
Robin Sonnabend committed
740
741
    search_form = SearchForm(protocoltypes)
    if protocoltype_id is not None:
742
        search_form.protocoltype.data = protocoltype_id
Robin Sonnabend's avatar
Robin Sonnabend committed
743
        protocoltype = ProtocolType.query.filter_by(id=protocoltype_id).first()
744
745
    if search_term is not None:
        search_form.search.data = search_term
Robin Sonnabend's avatar
Robin Sonnabend committed
746
747
748
749
    todos = [
        todo for todo in Todo.query.all()
        if todo.protocoltype.has_public_view_right(user)
    ]
Robin Sonnabend's avatar
Robin Sonnabend committed
750
    if protocoltype_id is not None and protocoltype_id != -1:
Robin Sonnabend's avatar
Robin Sonnabend committed
751
752
753
754
        todos = [
            todo for todo in todos
            if todo.protocoltype.id == protocoltype_id
        ]
Robin Sonnabend's avatar
Robin Sonnabend committed
755
    if search_term is not None and len(search_term.strip()) > 0:
Robin Sonnabend's avatar
Robin Sonnabend committed
756
757
758
        todos = [
            todo for todo in todos
            if search_term.lower() in todo.description.lower()
759
            or search_term.lower() in todo.who.lower()
Robin Sonnabend's avatar
Robin Sonnabend committed
760
        ]
Robin Sonnabend's avatar
Robin Sonnabend committed
761
    def _sort_key(todo):
Administrator's avatar
Administrator committed
762
        return (not todo.is_done(), todo.get_id())
Robin Sonnabend's avatar
Robin Sonnabend committed
763
    todos = sorted(todos, key=_sort_key, reverse=True)
Robin Sonnabend's avatar
Robin Sonnabend committed
764
    page = _get_page()
Robin Sonnabend's avatar
Robin Sonnabend committed
765
    page_count = int(math.ceil(len(todos) / config.PAGE_LENGTH))
Robin Sonnabend's avatar
Robin Sonnabend committed
766
767
768
769
    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
770
    todos = todos[begin_index:end_index]
Robin Sonnabend's avatar
Robin Sonnabend committed
771
    todos_table = TodosTable(todos)
Robin Sonnabend's avatar
Robin Sonnabend committed
772
    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
773

Robin Sonnabend's avatar
Robin Sonnabend committed
774
775
776
777
@app.route("/todo/new", methods=["GET", "POST"])
@login_required
def new_todo():
    user = current_user()
778
    protocoltype_id = optional_int_arg("protocoltype_id")
Robin Sonnabend's avatar
Robin Sonnabend committed
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
    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"))
        todo = Todo(type_id=form.protocoltype_id.data, who=form.who.data,
            description=form.description.data, tags=form.tags.data,
            done=form.done.data)
        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
816
@db_lookup(Todo)
Robin Sonnabend's avatar
Robin Sonnabend committed
817
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
818
def edit_todo(todo):
Robin Sonnabend's avatar
Robin Sonnabend committed
819
820
821
822
    form = TodoForm(obj=todo)
    if form.validate_on_submit():
        form.populate_obj(todo)
        db.session.commit()
823
        return redirect(request.args.get("next") or url_for("list_todos", protocoltype_id=todo.protocoltype.id))
Robin Sonnabend's avatar
Robin Sonnabend committed
824
825
826
827
    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
828
@db_lookup(Todo)
Robin Sonnabend's avatar
Robin Sonnabend committed
829
@require_private_view_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
830
def show_todo(todo):
Robin Sonnabend's avatar
Robin Sonnabend committed
831
832
833
834
835
    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
836
@db_lookup(Todo)
Robin Sonnabend's avatar
Robin Sonnabend committed
837
@require_private_view_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
838
def delete_todo(todo):
Robin Sonnabend's avatar
Robin Sonnabend committed
839
840
841
842
    type_id = todo.protocoltype.id
    db.session.delete(todo)
    db.session.commit()
    flash("Todo gelöscht.", "alert-success")
843
    return redirect(request.args.get("next") or url_for("list_todos", protocoltype_id=type_id))
Robin Sonnabend's avatar
Robin Sonnabend committed
844

845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
@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")
865
            return redirect(request.args.get("next") or url_for("list_todos"))
866
867
    return render_template("todos-merge.html", form=form, next_url=request.args.get("next"))

Robin Sonnabend's avatar
Robin Sonnabend committed
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
@app.route("/decisions/list")
def list_decisions():
    is_logged_In = check_login()
    user = current_user()
    protocoltype = None
    protocoltype_id = None
    try:
        protocoltype_id = int(request.args.get("protocoltype"))
    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:
        search_form.protocoltype.data = protocoltype_id
        protocoltype = ProtocolType.query.filter_by(id=protocoltype_id).first()
    if search_term is not None:
        search_form.search.data = search_term
    decisions = [
        decision for decision in Decision.query.all()
888
        if decision.protocol.has_public_view_right(user)
Robin Sonnabend's avatar
Robin Sonnabend committed
889
890
891
892
893
894
895
896
897
898
899
    ]
    if protocoltype_id is not None and protocoltype_id != -1:
        decisions = [
            decision for decision in decisions 
            if decision.protocol.protocoltype.id == protocoltype_id
        ]
    if search_term is not None and len(search_term.strip()) > 0:
        decisions = [
            decision for decision in decisions
            if search_term.lower() in decision.content.lower()
        ]
Robin Sonnabend's avatar
Robin Sonnabend committed
900
901
    decisions = sorted(decisions, key=lambda d: d.protocol.date, reverse=True)
        
Robin Sonnabend's avatar
Robin Sonnabend committed
902
903
904
905
906
907
908
909
910
911
    page = _get_page()
    page_count = int(math.ceil(len(decisions) / config.PAGE_LENGTH))
    if page >= page_count:
        page = 0
    begin_index = page * config.PAGE_LENGTH
    end_index = (page + 1) * config.PAGE_LENGTH
    decisions = decisions[begin_index:end_index]
    decisions_table = DecisionsTable(decisions)
    return render_template("decisions-list.html", decisions=decisions, decisions_table=decisions_table, search_form=search_form, page=page, page_count=page_count, page_diff=config.PAGE_DIFF, protocoltype_id=protocoltype_id, search_term=search_term)

912
@app.route("/document/download/<int:document_id>")
Robin Sonnabend's avatar
Robin Sonnabend committed
913
914
@db_lookup(Document)
def download_document(document):
915
916
917
918
    user = current_user()
    if ((document.is_private
            and not document.protocol.protocoltype.has_private_view_right(user))
        or (not document.is_private
919
            and not document.protocol.has_public_view_right(user))):
Robin Sonnabend's avatar
Robin Sonnabend committed
920
        flash("Dir fehlen die nötigen Zugriffsrechte.", "alert-error")
921
        return redirect(request.args.get("next") or url_for("index"))
922
    return send_file(document.as_file_like(), cache_timeout=1, as_attachment=True, attachment_filename=document.name)
923
924
925

@app.route("/document/upload/<int:protocol_id>", methods=["POST"])
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
926
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
927
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
928
def upload_document(protocol):
929
930
    form = DocumentUploadForm()
    if form.document.data is None:
Robin Sonnabend's avatar
Robin Sonnabend committed
931
        flash("Es wurde keine Datei ausgewählt.", "alert-error")
932
933
934
        return redirect(request.args.get("next") or url_for("index"))
    file = form.document.data
    if file.filename == "":
Robin Sonnabend's avatar
Robin Sonnabend committed
935
        flash("Es wurde keine Datei ausgewählt.", "alert-error")
936
        return redirect(request.args.get("next") or url_for("index"))
Robin Sonnabend's avatar
Robin Sonnabend committed
937
    # todo: Dateitypen einschränken?
938
939
    if file:
        filename = secure_filename(file.filename)
Robin Sonnabend's avatar
Robin Sonnabend committed
940
        document = Document(protocol.id, filename, "", False, form.private.data)
941
942
        db.session.add(document)
        db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
943
944
945
946
947
948
949
950
951
952
        internal_filename = "{}-{}-{}".format(protocol.id, document.id, filename)
        document.filename = internal_filename
        file.save(os.path.join(config.DOCUMENTS_PATH, internal_filename))
        if datetime.now().date() >= protocol.date: