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(host="192.168.0.13")
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
    all_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
156
157
158
    open_protocols = [
        protocol for protocol in all_open_protocols
        if protocol.protocoltype.has_public_view_right(user)
    ]
Robin Sonnabend's avatar
Robin Sonnabend committed
159
    finished_protocols = sorted(
160
161
162
163
164
        [
            protocol for protocol in protocols
            if protocol.done
            and (protocol.has_public_view_right(user)
                or protocol.has_private_view_right(user))
165
            and protocol.protocoltype.has_public_view_right(user)
166
        ],
167
168
        key=_protocol_sort_key,
        reverse=True
Robin Sonnabend's avatar
Robin Sonnabend committed
169
170
171
172
173
    )
    protocol = finished_protocols[0] if len(finished_protocols) > 0 else None
    todos = None
    if check_login():
        todos = [
174
            todo for todo in Todo.query.all()
175
            if todo.protocoltype.has_private_view_right(user)
176
            and not todo.is_done()
Robin Sonnabend's avatar
Robin Sonnabend committed
177
        ]
178
179
180
181
        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
182
    todos_table = TodosTable(todos) if todos is not None else None
183
    return render_template("index.html", open_protocols=open_protocols, protocol=protocol, todos=todos, todos_table=todos_table, all_open_protocols=all_open_protocols)
184

Robin Sonnabend's avatar
Robin Sonnabend committed
185
@app.route("/documentation")
Robin Sonnabend's avatar
Robin Sonnabend committed
186
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
187
def documentation():
Robin Sonnabend's avatar
Robin Sonnabend committed
188
189
190
    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
191

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

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

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

Robin Sonnabend's avatar
Robin Sonnabend committed
281
@app.route("/type/reminder/edit/<int:meetingreminder_id>", methods=["GET", "POST"])
282
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
283
@db_lookup(MeetingReminder)
Robin Sonnabend's avatar
Robin Sonnabend committed
284
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
285
286
def edit_reminder(meetingreminder):
    form = MeetingReminderForm(obj=meetingreminder)
287
    if form.validate_on_submit():
Robin Sonnabend's avatar
Robin Sonnabend committed
288
        form.populate_obj(meetingreminder)
289
        db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
290
291
        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)
292

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

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

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

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

@app.route("/protocols/list")
351
352
353
def list_protocols():
    is_logged_in = check_login()
    user = current_user()
Robin Sonnabend's avatar
Robin Sonnabend committed
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
    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
    protocol_query = Protocol.query
Robin Sonnabend's avatar
Robin Sonnabend committed
369
370
371
372
373
374
375
376
377
    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))
            ))
378
    protocols = [
Robin Sonnabend's avatar
Robin Sonnabend committed
379
        protocol for protocol in protocol_query.all()
380
381
        if protocol.protocoltype.has_public_view_right(user)
    ]
Robin Sonnabend's avatar
Robin Sonnabend committed
382
383
384
385
386
387
388
389
390
391
392
393
394
    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
395
396
397
398
399
    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
400
401
402
403
404
    if shall_search:
        protocols = [
            protocol for protocol in protocols
            if (protocol.protocoltype.has_private_view_right(user)
                and _matches_search(protocol.content_private))
405
            or (protocol.has_public_view_right(user)
Robin Sonnabend's avatar
Robin Sonnabend committed
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
                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
                ]))
433
            search_results[protocol] = " …<br />\n".join(formatted_lines)
Robin Sonnabend's avatar
Robin Sonnabend committed
434
    protocols = sorted(protocols, key=lambda protocol: protocol.date, reverse=True)
Robin Sonnabend's avatar
Robin Sonnabend committed
435
    page = _get_page()
436
    page_count = int(math.ceil(len(protocols) / config.PAGE_LENGTH))
Robin Sonnabend's avatar
Robin Sonnabend committed
437
438
439
440
441
    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
442
    protocols_table = ProtocolsTable(protocols, search_results=search_results)
Robin Sonnabend's avatar
Robin Sonnabend committed
443
    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
444
445
446
447
448

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

@app.route("/protocol/show/<int:protocol_id>")
Robin Sonnabend's avatar
Robin Sonnabend committed
470
471
@db_lookup(Protocol)
def show_protocol(protocol):
Robin Sonnabend's avatar
Robin Sonnabend committed
472
473
    user = current_user()
    errors_table = ErrorsTable(protocol.errors)
Robin Sonnabend's avatar
Robin Sonnabend committed
474
475
476
    if not protocol.protocoltype.has_public_view_right(user): # yes, feature
        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
477
478
    visible_documents = [
        document for document in protocol.documents
479
        if (not document.is_private and document.protocol.has_public_view_right(user))
Robin Sonnabend's avatar
Robin Sonnabend committed
480
481
482
        or (document.is_private and document.protocol.protocoltype.has_private_view_right(user))
    ]
    documents_table = DocumentsTable(visible_documents)
483
    document_upload_form = DocumentUploadForm()
Robin Sonnabend's avatar
Robin Sonnabend committed
484
485
    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
486

Robin Sonnabend's avatar
Robin Sonnabend committed
487
488
@app.route("/protocol/delete/<int:protocol_id>")
@login_required
489
@group_required(config.ADMIN_GROUP)
Robin Sonnabend's avatar
Robin Sonnabend committed
490
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
491
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
492
def delete_protocol(protocol):
Robin Sonnabend's avatar
Robin Sonnabend committed
493
    name = protocol.get_identifier()
Robin Sonnabend's avatar
Robin Sonnabend committed
494
    protocol.delete_orphan_todos()
Robin Sonnabend's avatar
Robin Sonnabend committed
495
496
497
498
499
    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
500
@app.route("/protocol/etherpull/<int:protocol_id>")
Robin Sonnabend's avatar
Robin Sonnabend committed
501
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
502
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
503
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
504
def etherpull_protocol(protocol):
505
506
507
    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
508
    protocol.source = get_etherpad_text(protocol.get_identifier())
Robin Sonnabend's avatar
Robin Sonnabend committed
509
510
511
512
513
    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
514
515
@app.route("/protocol/upload/known/<int:protocol_id>", methods=["POST"])
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
516
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
517
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
518
def upload_source_to_known_protocol(protocol):
Robin Sonnabend's avatar
Robin Sonnabend committed
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
    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()
539
    available_types = ProtocolType.get_modifiable_protocoltypes()
Robin Sonnabend's avatar
Robin Sonnabend committed
540
541
542
543
    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")
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
588
589
590
            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
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))

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

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

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

Robin Sonnabend's avatar
Robin Sonnabend committed
776
777
778
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
816
817
@app.route("/todo/new", methods=["GET", "POST"])
@login_required
def new_todo():
    user = current_user()
    protocoltype_id = optional_int_arg("type_id")
    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
818
@db_lookup(Todo)
Robin Sonnabend's avatar
Robin Sonnabend committed
819
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
820
def edit_todo(todo):
Robin Sonnabend's avatar
Robin Sonnabend committed
821
822
823
824
825
826
827
828
829
    form = TodoForm(obj=todo)
    if form.validate_on_submit():
        form.populate_obj(todo)
        db.session.commit()
        return redirect(request.args.get("next") or url_for("list_todos", protocoltype=todo.protocoltype.id))
    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
830
@db_lookup(Todo)
Robin Sonnabend's avatar
Robin Sonnabend committed
831
@require_private_view_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
832
def show_todo(todo):
Robin Sonnabend's avatar
Robin Sonnabend committed
833
834
835
836
837
    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
838
@db_lookup(Todo)
Robin Sonnabend's avatar
Robin Sonnabend committed
839
@require_private_view_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
840
def delete_todo(todo):
Robin Sonnabend's avatar
Robin Sonnabend committed
841
842
843
844
845
846
    type_id = todo.protocoltype.id
    db.session.delete(todo)
    db.session.commit()
    flash("Todo gelöscht.", "alert-success")
    return redirect(request.args.get("next") or url_for("list_todos", protocoltype=type_id))

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

Robin Sonnabend's avatar
Robin Sonnabend committed
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
@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()
890
        if decision.protocol.has_public_view_right(user)
Robin Sonnabend's avatar
Robin Sonnabend committed
891
892
893
894
895
896
897
898
899
900
901
    ]
    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
902
903
    decisions = sorted(decisions, key=lambda d: d.protocol.date, reverse=True)
        
Robin Sonnabend's avatar
Robin Sonnabend committed
904
905
906
907
908
909
910
911
912
913
    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)

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

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

@app.route("/document/delete/<int:document_id>")
@login_required
955
@group_required(config.ADMIN_GROUP)
Robin Sonnabend's avatar
Robin Sonnabend committed
956
@db_lookup(Document)
Robin Sonnabend's avatar
Robin Sonnabend committed
957
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
958
def delete_document(document):
Robin Sonnabend's avatar
Robin Sonnabend committed
959
960
961
962
963
    name = document.name
    protocol = document.protocol
    db.session.delete(document)
    db.session.commit()
    flash("Das Dokument {} wurde gelöscht.".format(name), "alert-success")
964
    return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol.id))
Robin Sonnabend's avatar
Robin Sonnabend committed
965

Robin Sonnabend's avatar
Robin Sonnabend committed
966
967
@app.route("/document/print/<int:document_id>")
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
968
@db_lookup(Document)
Robin Sonnabend's avatar
Robin Sonnabend committed
969
@require_modify_right()