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

Robin Sonnabend's avatar
Robin Sonnabend committed
5
from flask import Flask, g, current_app, request, session, flash, redirect, url_for, abort, render_template, Response, send_file as flask_send_file, Markup
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, time_filter_short, user_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, get_first_unused_int, set_etherpad_text, get_etherpad_text, split_terms, optional_int_arg, fancy_join, footnote_hash
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_publish_right, require_admin_right
Robin Sonnabend's avatar
Robin Sonnabend committed
26
from models.database import ProtocolType, Protocol, DefaultTOP, TOP, LocalTOP, Document, Todo, Decision, MeetingReminder, Error, TodoMail, DecisionDocument, TodoState, Meta, DefaultMeta, DecisionCategory, Like
Robin Sonnabend's avatar
Robin Sonnabend committed
27
from views.forms import LoginForm, ProtocolTypeForm, DefaultTopForm, MeetingReminderForm, NewProtocolForm, DocumentUploadForm, KnownProtocolSourceUploadForm, NewProtocolSourceUploadForm, generate_protocol_form, TopForm, LocalTopForm, SearchForm, DecisionSearchForm, ProtocolSearchForm, TodoSearchForm, NewProtocolFileUploadForm, NewTodoForm, TodoForm, TodoMailForm, DefaultMetaForm, MetaForm, MergeTodosForm, DecisionCategoryForm, DocumentEditForm
28
from views.tables import ProtocolsTable, ProtocolTypesTable, ProtocolTypeTable, DefaultTOPsTable, MeetingRemindersTable, ErrorsTable, TodosTable, DocumentsTable, DecisionsTable, TodoTable, ErrorTable, TodoMailsTable, DefaultMetasTable, DecisionCategoriesTable
29
from legacy import import_old_todos, import_old_protocols, import_old_todomails
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52

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

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

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

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

67
68
69
70
71
72
additional_templates = getattr(config, "LATEX_LOCAL_TEMPLATES", None)
if additional_templates is not None and os.path.isdir(additional_templates):
    if additional_templates not in app.jinja_loader.searchpath:
        app.jinja_loader.searchpath.append(additional_templates)
    

73
74
import tasks

75
76
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
77
app.jinja_env.globals.update(zip=zip)
Robin Sonnabend's avatar
Robin Sonnabend committed
78
79
80
app.jinja_env.globals.update(min=min)
app.jinja_env.globals.update(max=max)
app.jinja_env.globals.update(dir=dir)
Robin Sonnabend's avatar
Robin Sonnabend committed
81
app.jinja_env.globals.update(now=datetime.now)
82

83
84
# blueprints here

85
86
@manager.command
def import_legacy():
87
    """Import the old todos and protocols from an sql dump"""
88
    filename = prompt("SQL-file")
89
    #filename = "legacy.sql"
90
91
    with open(filename, "rb") as sqlfile:
        content = sqlfile.read().decode("utf-8")
92
93
        import_old_todos(content)
        import_old_protocols(content)
94
        import_old_todomails(content)
95

96
97
98
99
@manager.command
def recompile_all():
    for protocol in sorted(Protocol.query.all(), key=lambda p: p.date):
        if protocol.is_done():
100
            print(protocol.get_short_identifier())
101
102
103
104
105
106
107
108
109
110
111
112
            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)
113
            if todo2.state.value > todo1.state.value:
114
115
116
117
118
119
120
121
122
123
124
125
126
                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():
127
    app.run()
128
129
    make_scheduler()

130
131
132
133
# 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)
134
135
136
137
138
139
140
141
    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"
142
    return response
143

144
145
@app.route("/")
def index():
Robin Sonnabend's avatar
Robin Sonnabend committed
146
147
148
    user = current_user()
    protocols = [
        protocol for protocol in Protocol.query.all()
149
150
        if protocol.protocoltype.has_public_view_right(user,
            check_networks=False)
Robin Sonnabend's avatar
Robin Sonnabend committed
151
    ]
152
    def _protocol_sort_key(protocol):
Robin Sonnabend's avatar
Robin Sonnabend committed
153
154
155
        if protocol.date is not None:
            return protocol.date
        return datetime.now().date()
Robin Sonnabend's avatar
Robin Sonnabend committed
156
    current_day = datetime.now().date()
157
    open_protocols = sorted(
Robin Sonnabend's avatar
Robin Sonnabend committed
158
159
160
161
        [
            protocol for protocol in protocols
            if not protocol.done
            and (protocol.date - current_day).days < config.MAX_INDEX_DAYS
162
            and (current_day - protocol.date).days < config.MAX_PAST_INDEX_DAYS
Robin Sonnabend's avatar
Robin Sonnabend committed
163
        ],
164
        key=_protocol_sort_key
Robin Sonnabend's avatar
Robin Sonnabend committed
165
166
    )
    finished_protocols = sorted(
167
168
        [
            protocol for protocol in protocols
169
170
171
            if protocol.done and protocol.public
            and (protocol.has_private_view_right(user)
                or protocol.protocoltype.has_public_view_right(user, check_networks=False))
172
        ],
173
174
        key=_protocol_sort_key,
        reverse=True
Robin Sonnabend's avatar
Robin Sonnabend committed
175
    )
176
177
178
179
180
181
182
    protocol = None
    show_private = False
    has_public_view_right = False
    if len(finished_protocols) > 0:
        protocol = finished_protocols[0]
        show_private = protocol.has_private_view_right(user)
        has_public_view_right = protocol.protocoltype.has_public_view_right(user)
Robin Sonnabend's avatar
Robin Sonnabend committed
183
184
185
    todos = None
    if check_login():
        todos = [
186
            todo for todo in Todo.query.all()
187
            if todo.protocoltype.has_private_view_right(user)
188
            and not todo.is_done()
Robin Sonnabend's avatar
Robin Sonnabend committed
189
        ]
190
191
192
193
194
195
        user_todos = [
            todo for todo in todos
            if user.username.lower() in list(map(str.strip, todo.who.lower().split(",")))
        ]
        if len(user_todos) > 0:
            todos = user_todos
196
197
        def _todo_sort_key(todo):
            protocol = todo.get_first_protocol()
198
            return protocol.date if protocol is not None and protocol.date is not None else datetime.now().date()
199
        todos = sorted(todos, key=_todo_sort_key, reverse=True)
Robin Sonnabend's avatar
Robin Sonnabend committed
200
    todos_table = TodosTable(todos) if todos is not None else None
201
    return render_template("index.html", open_protocols=open_protocols, protocol=protocol, todos=todos, show_private=show_private, has_public_view_right=has_public_view_right)
202

Robin Sonnabend's avatar
Robin Sonnabend committed
203
@app.route("/documentation")
Robin Sonnabend's avatar
Robin Sonnabend committed
204
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
205
def documentation():
Robin Sonnabend's avatar
Robin Sonnabend committed
206
207
208
    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
209

Robin Sonnabend's avatar
Robin Sonnabend committed
210
@app.route("/types/list")
Robin Sonnabend's avatar
Robin Sonnabend committed
211
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
212
213
214
215
216
def list_types():
    is_logged_in = check_login()
    user = current_user()
    types = [
        protocoltype for protocoltype in ProtocolType.query.all()
217
218
        if (protocoltype.has_private_view_right(user)
        or protocoltype.has_public_view_right(user)
Robin Sonnabend's avatar
Robin Sonnabend committed
219
        or protocoltype.is_public)]
220
    types = sorted(types, key=lambda t: t.short_name)
Robin Sonnabend's avatar
Robin Sonnabend committed
221
222
223
224
225
226
227
228
229
230
231
232
    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:
233
234
            protocoltype = ProtocolType()
            form.populate_obj(protocoltype)
Robin Sonnabend's avatar
Robin Sonnabend committed
235
236
237
238
239
240
            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
241
@app.route("/type/edit/<int:protocoltype_id>", methods=["GET", "POST"])
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 edit_type(protocoltype):
Robin Sonnabend's avatar
Robin Sonnabend committed
246
247
248
249
250
251
252
253
    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
254
            return redirect(request.args.get("next") or url_for("show_type", protocoltype_id=protocoltype.id))
Robin Sonnabend's avatar
Robin Sonnabend committed
255
256
    return render_template("type-edit.html", form=form, protocoltype=protocoltype)

Robin Sonnabend's avatar
Robin Sonnabend committed
257
@app.route("/type/show/<int:protocoltype_id>")
Robin Sonnabend's avatar
Robin Sonnabend committed
258
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
259
@db_lookup(ProtocolType)
Robin Sonnabend's avatar
Robin Sonnabend committed
260
@require_private_view_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
261
def show_type(protocoltype):
Robin Sonnabend's avatar
Robin Sonnabend committed
262
263
    protocoltype_table = ProtocolTypeTable(protocoltype)
    default_tops_table = DefaultTOPsTable(protocoltype.default_tops, protocoltype)
264
    reminders_table = MeetingRemindersTable(protocoltype.reminders, protocoltype)
Robin Sonnabend's avatar
Robin Sonnabend committed
265
    metas_table = DefaultMetasTable(protocoltype.metas, protocoltype)
266
267
    categories_table = DecisionCategoriesTable(protocoltype.decisioncategories, protocoltype)
    return render_template("type-show.html", protocoltype=protocoltype, protocoltype_table=protocoltype_table, default_tops_table=default_tops_table, metas_table=metas_table, reminders_table=reminders_table, mail_active=config.MAIL_ACTIVE, categories_table=categories_table)
268

Robin Sonnabend's avatar
Robin Sonnabend committed
269
@app.route("/type/delete/<int:protocoltype_id>")
270
@login_required
271
@group_required(config.ADMIN_GROUP)
Robin Sonnabend's avatar
Robin Sonnabend committed
272
@db_lookup(ProtocolType)
Robin Sonnabend's avatar
Robin Sonnabend committed
273
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
274
def delete_type(protocoltype):
275
276
277
278
279
280
    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
281
@app.route("/type/reminders/new/<int:protocoltype_id>", methods=["GET", "POST"])
282
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
283
@db_lookup(ProtocolType)
Robin Sonnabend's avatar
Robin Sonnabend committed
284
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
285
def new_reminder(protocoltype):
286
287
    form = MeetingReminderForm()
    if form.validate_on_submit():
288
289
        meetingreminder = MeetingReminder(protocoltype_id=protocoltype.id)
        form.populate_obj(meetingreminder)
Robin Sonnabend's avatar
Robin Sonnabend committed
290
        db.session.add(meetingreminder)
291
        db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
292
        return redirect(request.args.get("next") or url_for("show_type", protocoltype_id=protocoltype.id))
293
294
    return render_template("reminder-new.html", form=form, protocoltype=protocoltype)

Robin Sonnabend's avatar
Robin Sonnabend committed
295
@app.route("/type/reminder/edit/<int:meetingreminder_id>", methods=["GET", "POST"])
296
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
297
@db_lookup(MeetingReminder)
Robin Sonnabend's avatar
Robin Sonnabend committed
298
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
299
300
def edit_reminder(meetingreminder):
    form = MeetingReminderForm(obj=meetingreminder)
301
    if form.validate_on_submit():
Robin Sonnabend's avatar
Robin Sonnabend committed
302
        form.populate_obj(meetingreminder)
303
        db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
304
        return redirect(request.args.get("next") or url_for("show_type", protocoltype_id=protocoltype.id))
305
    return render_template("reminder-edit.html", form=form, meetingreminder=meetingreminder)
306

Robin Sonnabend's avatar
Robin Sonnabend committed
307
@app.route("/type/reminder/delete/<int:meetingreminder_id>")
308
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
309
@db_lookup(MeetingReminder)
Robin Sonnabend's avatar
Robin Sonnabend committed
310
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
311
312
313
def delete_reminder(meetingreminder):
    protocoltype = meetingreminder.protocoltype
    db.session.delete(meetingreminder)
314
    db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
315
    return redirect(request.args.get("next") or url_for("show_type", protocoltype_id=protocoltype.id))
316

Robin Sonnabend's avatar
Robin Sonnabend committed
317
@app.route("/type/tops/new/<int:protocoltype_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)
Robin Sonnabend's avatar
Robin Sonnabend committed
320
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
321
def new_default_top(protocoltype):
Robin Sonnabend's avatar
Robin Sonnabend committed
322
323
    form = DefaultTopForm()
    if form.validate_on_submit():
324
325
        defaulttop = DefaultTOP(protocoltype_id=protocoltype.id)
        form.populate_obj(defaulttop)
Robin Sonnabend's avatar
Robin Sonnabend committed
326
        db.session.add(defaulttop)
Robin Sonnabend's avatar
Robin Sonnabend committed
327
        db.session.commit()
328
329
330
        for protocol in protocoltype.protocols:
            if not protocol.done:
                localtop = LocalTOP(protocol_id=protocol.id,
Administrator's avatar
Administrator committed
331
                    defaulttop_id=defaulttop.id, description="")
332
333
                db.session.add(localtop)
        db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
334
        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
335
336
337
        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
338
@app.route("/type/tops/edit/<int:protocoltype_id>/<int:defaulttop_id>", methods=["GET", "POST"])
Robin Sonnabend's avatar
Robin Sonnabend committed
339
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
340
@db_lookup(ProtocolType, DefaultTOP)
Robin Sonnabend's avatar
Robin Sonnabend committed
341
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
342
343
def edit_default_top(protocoltype, defaulttop):
    form = DefaultTopForm(obj=defaulttop)
Robin Sonnabend's avatar
Robin Sonnabend committed
344
    if form.validate_on_submit():
Robin Sonnabend's avatar
Robin Sonnabend committed
345
        form.populate_obj(defaulttop)
Robin Sonnabend's avatar
Robin Sonnabend committed
346
        db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
347
348
        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
349

Robin Sonnabend's avatar
Robin Sonnabend committed
350
@app.route("/type/tops/delete/<int:defaulttop_id>")
Robin Sonnabend's avatar
Robin Sonnabend committed
351
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
352
@db_lookup(DefaultTOP)
Robin Sonnabend's avatar
Robin Sonnabend committed
353
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
354
355
def delete_default_top(defaulttop):
    db.session.delete(defaulttop)
Robin Sonnabend's avatar
Robin Sonnabend committed
356
    db.session.commit()
357
    return redirect(request.args.get("next") or url_for("show_type", protocoltype_id=defaulttop.protocoltype.id))
Robin Sonnabend's avatar
Robin Sonnabend committed
358

Robin Sonnabend's avatar
Robin Sonnabend committed
359
@app.route("/type/tops/move/<int:defaulttop_id>/<diff>/")
Robin Sonnabend's avatar
Robin Sonnabend committed
360
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
361
@db_lookup(DefaultTOP)
Robin Sonnabend's avatar
Robin Sonnabend committed
362
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
363
def move_default_top(defaulttop, diff):
Robin Sonnabend's avatar
Robin Sonnabend committed
364
    try:
Robin Sonnabend's avatar
Robin Sonnabend committed
365
        defaulttop.number += int(diff)
Robin Sonnabend's avatar
Robin Sonnabend committed
366
367
368
        db.session.commit()
    except ValueError:
        flash("Die angegebene Differenz ist keine Zahl.", "alert-error")
Robin Sonnabend's avatar
Robin Sonnabend committed
369
    return redirect(request.args.get("next") or url_for("show_type", protocoltype_id=defaulttop.protocoltype.id))
Robin Sonnabend's avatar
Robin Sonnabend committed
370
371

@app.route("/protocols/list")
372
373
374
def list_protocols():
    is_logged_in = check_login()
    user = current_user()
Robin Sonnabend's avatar
Robin Sonnabend committed
375
376
377
    protocoltype = None
    protocoltype_id = None
    try:
378
        protocoltype_id = int(request.args.get("protocoltype_id"))
Robin Sonnabend's avatar
Robin Sonnabend committed
379
380
    except (ValueError, TypeError):
        pass
Robin Sonnabend's avatar
Robin Sonnabend committed
381
    state_open = -1
Robin Sonnabend's avatar
Robin Sonnabend committed
382
    try:
Robin Sonnabend's avatar
Robin Sonnabend committed
383
        state_open = int(request.args.get("state_open"))
Robin Sonnabend's avatar
Robin Sonnabend committed
384
385
    except (ValueError, TypeError):
        pass
Robin Sonnabend's avatar
Robin Sonnabend committed
386
    search_term = request.args.get("search")
387
    protocoltypes = ProtocolType.get_public_protocoltypes(user, check_networks=False)
Robin Sonnabend's avatar
Robin Sonnabend committed
388
    search_form = ProtocolSearchForm(protocoltypes)
Robin Sonnabend's avatar
Robin Sonnabend committed
389
    if protocoltype_id is not None:
390
        search_form.protocoltype_id.data = protocoltype_id
Robin Sonnabend's avatar
Robin Sonnabend committed
391
        protocoltype = ProtocolType.query.filter_by(id=protocoltype_id).first()
Robin Sonnabend's avatar
Robin Sonnabend committed
392
393
    if state_open is not None:
        search_form.state_open.data = state_open
Robin Sonnabend's avatar
Robin Sonnabend committed
394
395
396
    if search_term is not None:
        search_form.search.data = search_term
    protocol_query = Protocol.query
Robin Sonnabend's avatar
Robin Sonnabend committed
397
398
399
400
401
402
403
404
405
    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))
            ))
406
    protocols = [
Robin Sonnabend's avatar
Robin Sonnabend committed
407
        protocol for protocol in protocol_query.all()
408
        if protocol.protocoltype.has_public_view_right(user, check_networks=False)
409
    ]
Robin Sonnabend's avatar
Robin Sonnabend committed
410
411
412
413
414
415
416
417
418
419
420
421
422
    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
423
424
425
426
427
    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
428
429
    if state_open is not None and state_open != -1:
        protocol_done = bool(state_open)
Robin Sonnabend's avatar
Robin Sonnabend committed
430
431
        protocols = [
            protocol for protocol in protocols
432
            if (protocol.is_done() or False) == protocol_done
Robin Sonnabend's avatar
Robin Sonnabend committed
433
        ]
Robin Sonnabend's avatar
Robin Sonnabend committed
434
435
436
437
438
    if shall_search:
        protocols = [
            protocol for protocol in protocols
            if (protocol.protocoltype.has_private_view_right(user)
                and _matches_search(protocol.content_private))
439
            or (protocol.has_public_view_right(user)
Robin Sonnabend's avatar
Robin Sonnabend committed
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
                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
                ]))
467
            search_results[protocol] = " …<br />\n".join(formatted_lines)
Robin Sonnabend's avatar
Robin Sonnabend committed
468
    protocols = sorted(protocols, key=lambda protocol: protocol.date, reverse=True)
Robin Sonnabend's avatar
Robin Sonnabend committed
469
    page = _get_page()
Robin Sonnabend's avatar
Robin Sonnabend committed
470
471
    page_length = _get_page_length()
    page_count = int(math.ceil(len(protocols) / page_length))
Robin Sonnabend's avatar
Robin Sonnabend committed
472
473
    if page >= page_count:
        page = 0
Robin Sonnabend's avatar
Robin Sonnabend committed
474
475
    begin_index = page * page_length
    end_index = (page + 1) * page_length
476
    max_page_length_exp = math.ceil(math.log10(len(protocols))) if len(protocols) > 0 else 1
Robin Sonnabend's avatar
Robin Sonnabend committed
477
    protocols = protocols[begin_index:end_index]
Robin Sonnabend's avatar
Robin Sonnabend committed
478
    protocols_table = ProtocolsTable(protocols, search_results=search_results)
Robin Sonnabend's avatar
Robin Sonnabend committed
479
    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, state_open=state_open, page_length=page_length, max_page_length_exp=max_page_length_exp)
Robin Sonnabend's avatar
Robin Sonnabend committed
480
481
482
483
484

@app.route("/protocol/new", methods=["GET", "POST"])
@login_required
def new_protocol():
    user = current_user()
Robin Sonnabend's avatar
Robin Sonnabend committed
485
    protocoltypes = ProtocolType.get_modifiable_protocoltypes(user)
Robin Sonnabend's avatar
Robin Sonnabend committed
486
    form = NewProtocolForm(protocoltypes)
Robin Sonnabend's avatar
Robin Sonnabend committed
487
    upload_form = NewProtocolSourceUploadForm(protocoltypes)
488
    file_upload_form = NewProtocolFileUploadForm(protocoltypes)
Robin Sonnabend's avatar
Robin Sonnabend committed
489
    if form.validate_on_submit():
490
        protocoltype = ProtocolType.query.filter_by(id=form.protocoltype_id.data).first()
Robin Sonnabend's avatar
Robin Sonnabend committed
491
492
493
        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"))
494
495
        protocol = Protocol.create_new_protocol(protocoltype,
            form.date.data, form.start_time.data)
Robin Sonnabend's avatar
Robin Sonnabend committed
496
        return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol.id))
497
    type_id = request.args.get("protocoltype_id")
Robin Sonnabend's avatar
Robin Sonnabend committed
498
499
    if type_id is not None:
        form.protocoltype.data = type_id
500
501
        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
502
503

@app.route("/protocol/show/<int:protocol_id>")
Robin Sonnabend's avatar
Robin Sonnabend committed
504
505
@db_lookup(Protocol)
def show_protocol(protocol):
Robin Sonnabend's avatar
Robin Sonnabend committed
506
507
    user = current_user()
    errors_table = ErrorsTable(protocol.errors)
508
    if not protocol.protocoltype.has_public_view_right(user, check_networks=False):
509
510
511
        flash("Dir fehlen die nötigen Zugriffsrechte.", "alert-error")
        if check_login():
            return redirect(url_for("index"))
512
        return redirect(request.args.get("next") or url_for("login", next=request.url))
Robin Sonnabend's avatar
Robin Sonnabend committed
513
514
    visible_documents = [
        document for document in protocol.documents
515
        if (not document.is_private and document.protocol.has_public_view_right(user))
Robin Sonnabend's avatar
Robin Sonnabend committed
516
517
        or (document.is_private and document.protocol.protocoltype.has_private_view_right(user))
    ]
518
    documents_table = DocumentsTable(visible_documents, protocol)
519
    document_upload_form = DocumentUploadForm()
Robin Sonnabend's avatar
Robin Sonnabend committed
520
    source_upload_form = KnownProtocolSourceUploadForm()
521
522
    time_diff = protocol.date - datetime.now().date()
    large_time_diff = not protocol.is_done() and time_diff.days > 0
523
524
525
    content_html = (protocol.content_html_private
        if protocol.has_private_view_right(user)
        else protocol.content_html_public)
526
527
528
    if content_html is not None:
        content_html = Markup(content_html)
    return render_template("protocol-show.html", protocol=protocol, errors_table=errors_table, documents_table=documents_table, document_upload_form=document_upload_form, source_upload_form=source_upload_form, time_diff=time_diff, large_time_diff=large_time_diff, content_html=content_html)
Robin Sonnabend's avatar
Robin Sonnabend committed
529

Robin Sonnabend's avatar
Robin Sonnabend committed
530
531
@app.route("/protocol/delete/<int:protocol_id>")
@login_required
532
@group_required(config.ADMIN_GROUP)
Robin Sonnabend's avatar
Robin Sonnabend committed
533
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
534
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
535
def delete_protocol(protocol):
536
    name = protocol.get_short_identifier()
Robin Sonnabend's avatar
Robin Sonnabend committed
537
    protocol.delete_orphan_todos()
Robin Sonnabend's avatar
Robin Sonnabend committed
538
539
540
541
542
    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
543
@app.route("/protocol/etherpull/<int:protocol_id>")
Robin Sonnabend's avatar
Robin Sonnabend committed
544
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
545
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
546
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
547
def etherpull_protocol(protocol):
548
549
550
    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
551
    protocol.source = get_etherpad_text(protocol.get_identifier())
Robin Sonnabend's avatar
Robin Sonnabend committed
552
553
554
555
556
    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
557
558
@app.route("/protocol/upload/known/<int:protocol_id>", methods=["POST"])
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
559
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
560
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
561
def upload_source_to_known_protocol(protocol):
562
    form = KnownProtocolSourceUploadForm()
Robin Sonnabend's avatar
Robin Sonnabend committed
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
    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()
583
    available_types = ProtocolType.get_modifiable_protocoltypes(user)
Robin Sonnabend's avatar
Robin Sonnabend committed
584
585
586
587
    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")
588
589
590
591
592
593
            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")
594
        protocoltype = ProtocolType.query.filter_by(id=form.protocoltype_id.data).first()
595
596
597
        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"))
598
        protocol = Protocol(protocoltype_id=protocoltype.id, source=source)
599
600
        db.session.add(protocol)
        db.session.commit()
601
602
603
        for local_top in protocol.create_localtops:
            db.session.add(local_top)
        db.session.commit()
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
        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)
623
        protocoltype = ProtocolType.query.filter_by(id=form.protocoltype_id.data).first()
624
625
626
        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"))
627
        protocol = Protocol(protocoltype_id=protocoltype.id, date=datetime.now().date(), done=True)
628
629
        db.session.add(protocol)
        db.session.commit()
630
631
632
        for local_top in protocol.create_localtops:
            db.session.add(local_top)
        db.session.commit()
633
634
635
        document = Document(protocol_id=protocol.id, name=filename,
            filename="", is_compiled=False)
        form.populate_obj(document)
636
637
638
639
640
641
642
        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
643
644
    return redirect(request.args.get("fail") or url_for("new_protocol"))

Administrator's avatar
Administrator committed
645
646
647
@app.route("/protocol/recompile/<int:protocol_id>")
@login_required
@group_required(config.ADMIN_GROUP)
Robin Sonnabend's avatar
Robin Sonnabend committed
648
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
649
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
650
def recompile_protocol(protocol):
Administrator's avatar
Administrator committed
651
652
    tasks.parse_protocol(protocol)
    return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol.id))
653

Robin Sonnabend's avatar
Robin Sonnabend committed
654
655
@app.route("/protocol/source/<int:protocol_id>")
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
656
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
657
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
658
def get_protocol_source(protocol):
Robin Sonnabend's avatar
Robin Sonnabend committed
659
    file_like = BytesIO(protocol.source.encode("utf-8"))
660
    return send_file(file_like, cache_timeout=1, as_attachment=True, attachment_filename="{}.txt".format(protocol.get_short_identifier()))
Robin Sonnabend's avatar
Robin Sonnabend committed
661

Robin Sonnabend's avatar
Robin Sonnabend committed
662
663
@app.route("/protocol/template/<int:protocol_id>")
@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 get_protocol_template(protocol):
Robin Sonnabend's avatar
Robin Sonnabend committed
667
    file_like = BytesIO(protocol.get_template().encode("utf-8"))
668
    return send_file(file_like, cache_timeout=1, as_attachment=True, attachment_filename="{}-template.txt".format(protocol.get_short_identifier()))
Robin Sonnabend's avatar
Robin Sonnabend committed
669

Robin Sonnabend's avatar
Robin Sonnabend committed
670
671
@app.route("/protocol/etherpush/<int:protocol_id>")
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
672
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
673
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
674
def etherpush_protocol(protocol):
675
676
677
    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))
678
679
680
    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
681

Robin Sonnabend's avatar
Robin Sonnabend committed
682
@app.route("/protocol/update/<int:protocol_id>", methods=["GET", "POST"])
Robin Sonnabend's avatar
Robin Sonnabend committed
683
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
684
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
685
@require_publish_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
686
def update_protocol(protocol):
Robin Sonnabend's avatar
Robin Sonnabend committed
687
    upload_form = KnownProtocolSourceUploadForm()
688
    edit_form = generate_protocol_form(protocol)(obj=protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
689
690
    if edit_form.validate_on_submit():
        edit_form.populate_obj(protocol)
691
692
        for meta in protocol.metas:
            meta.value = getattr(edit_form.metas, meta.name).data
Robin Sonnabend's avatar
Robin Sonnabend committed
693
        db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
694
        tasks.push_tops_to_calendar(protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
695
        return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol.id))
696
697
    for meta in protocol.metas:
        getattr(edit_form.metas, meta.name).data = meta.value
Robin Sonnabend's avatar
Robin Sonnabend committed
698
    return render_template("protocol-update.html", upload_form=upload_form, edit_form=edit_form, protocol=protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
699

700
701
@app.route("/protocol/publish/<int:protocol_id>")
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
702
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
703
@require_publish_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
704
def publish_protocol(protocol):
705
706
707
708
    protocol.public = True
    db.session.commit()
    return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol.id))

709
@app.route("/prococol/send/private/<int:protocol_id>")
710
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
711
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
712
@require_modify_right()
713
def send_protocol_private(protocol):
714
715
716
    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))
717
718
719
720
721
722
723
    tasks.send_protocol_private(protocol)
    flash("Das Protokoll wurde versandt.", "alert-success")
    return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol.id))

@app.route("/prococol/send/public/<int:protocol_id>")
@login_required
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
724
@require_publish_right()
725
726
727
728
729
def send_protocol_public(protocol):
    if not config.MAIL_ACTIVE:
        flash("Die Mailfunktion ist nicht aktiviert.", "alert-error")
        return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol_id))
    tasks.send_protocol_public(protocol)
730
731
732
    flash("Das Protokoll wurde versandt.", "alert-success")
    return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol.id))

733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
@app.route("/protocol/reminder/<int:protocol_id>")
@login_required
@db_lookup(Protocol)
@require_modify_right()
def send_protocol_reminder(protocol):
    if not config.MAIL_ACTIVE:
        flash("Die Mailfunktion ist nicht aktiviert.", "alert-error")
        return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol_id))
    meetingreminders = MeetingReminder.query.filter_by(protocoltype_id=protocol.protocoltype.id).all()
    if len(meetingreminders) == 0:
        flash("Für diesen Protokolltyp sind keine Einladungsmails konfiguriert.", "alert-error")
        return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol_id))
    day_difference = (protocol.date - datetime.now().date()).days
    past_reminders = [
        meetingreminder for meetingreminder in meetingreminders
        if meetingreminder.days_before > day_difference
    ]
    if len(past_reminders) == 0:
        flash("Bisher hätte keine Einladungsmail verschickt werden sollen, schicke letzte.", "alert-info")
        past_reminders = meetingreminders
    past_reminders = sorted(past_reminders, key=lambda r: r.days_before)
    choosen_reminder = past_reminders[0]
    tasks.send_reminder(choosen_reminder, protocol)
    flash("Einladungsmail ist versandt.", "alert-success")
    return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol.id))
        

Robin Sonnabend's avatar
Robin Sonnabend committed
760
761
@app.route("/protocol/tops/new/<int:protocol_id>", methods=["GET", "POST"])
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
762
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
763
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
764
def new_top(protocol):
Robin Sonnabend's avatar
Robin Sonnabend committed
765
766
    form = TopForm()
    if form.validate_on_submit():
767
768
        top = TOP(protocol_id=protocol.id, planned=True)
        form.populate_obj(top)
Robin Sonnabend's avatar
Robin Sonnabend committed
769
770
        db.session.add(top)
        db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
771
        tasks.push_tops_to_calendar(top.protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
772
773
774
775
776
777
778
779
780
        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
781
@db_lookup(TOP)
Robin Sonnabend's avatar
Robin Sonnabend committed
782
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
783
def edit_top(top):
Robin Sonnabend's avatar
Robin Sonnabend committed
784
785
786
787
    form = TopForm(obj=top)
    if form.validate_on_submit():
        form.populate_obj(top)
        db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
788
        tasks.push_tops_to_calendar(top.protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
789
790
791
792
793
        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
794
@db_lookup(TOP)
Robin Sonnabend's avatar
Robin Sonnabend committed
795
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
796
def delete_top(top):
Robin Sonnabend's avatar
Robin Sonnabend committed
797
    name = top.name
Robin Sonnabend's avatar
Robin Sonnabend committed
798
    protocol = top.protocol
Robin Sonnabend's avatar
Robin Sonnabend committed
799
800
    db.session.delete(top)
    db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
801
    tasks.push_tops_to_calendar(protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
802
    flash("Der TOP {} wurde gelöscht.".format(name), "alert-success")
Robin Sonnabend's avatar
Robin Sonnabend committed
803
    return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol.id))
Robin Sonnabend's avatar
Robin Sonnabend committed
804
805
806

@app.route("/protocol/top/move/<int:top_id>/<diff>")
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
807
@db_lookup(TOP)
Robin Sonnabend's avatar
Robin Sonnabend committed
808
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
809
def move_top(top, diff):
Robin Sonnabend's avatar
Robin Sonnabend committed
810
811
812
    try:
        top.number += int(diff)
        db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
813
        tasks.push_tops_to_calendar(top.protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
814
815
816
817
    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))

818
819
820
821
822
823
824
825
826
827
828
829
@app.route("/protocol/localtop/edit/<int:localtop_id>", methods=["GET", "POST"])
@login_required
@db_lookup(LocalTOP)
@require_modify_right()
def edit_localtop(localtop):
    form = LocalTopForm(obj=localtop)
    if form.validate_on_submit():
        form.populate_obj(localtop)
        db.session.commit()
        return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=localtop.protocol.id))
    return render_template("localtop-edit.html", form=form, localtop=localtop)

Robin Sonnabend's avatar
Robin Sonnabend committed
830
831
832
833
834
835
836
837
838
def _get_page():
    try:
        page = request.args.get("page")
        if page is None:
            return 0
        return int(page)
    except ValueError:
        return 0

Robin Sonnabend's avatar
Robin Sonnabend committed
839
840
841
842
843
844
845
846
847
def _get_page_length():
    try:
        page_length = request.args.get("page_length")
        if page_length is None:
            return config.PAGE_LENGTH
        return int(page_length)
    except ValueError:
        return config.PAGE_LENGTH

848
@app.route("/todos/list")
Robin Sonnabend's avatar
Robin Sonnabend committed
849
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
850
851
def list_todos():
    user = current_user()
Robin Sonnabend's avatar
Robin Sonnabend committed
852
853
854
    protocoltype = None
    protocoltype_id = None
    try:
855
        protocoltype_id = int(request.args.get("protocoltype_id"))
Robin Sonnabend's avatar
Robin Sonnabend committed
856
857
    except (ValueError, TypeError):
        pass
Robin Sonnabend's avatar
Robin Sonnabend committed
858
    state_open = -1
Robin Sonnabend's avatar
Robin Sonnabend committed
859
    try:
Robin Sonnabend's avatar
Robin Sonnabend committed
860
        state_open = int(request.args.get("state_open"))
Robin Sonnabend's avatar
Robin Sonnabend committed
861
862
    except (ValueError, TypeError):
        pass
Robin Sonnabend's avatar
Robin Sonnabend committed
863
    search_term = request.args.get("search")
Robin Sonnabend's avatar
Robin Sonnabend committed
864
    protocoltypes = ProtocolType.get_public_protocoltypes(user)
Robin Sonnabend's avatar
Robin Sonnabend committed
865
    search_form = TodoSearchForm(protocoltypes)
Robin Sonnabend's avatar
Robin Sonnabend committed
866
    if protocoltype_id is not None:
867
        search_form.protocoltype_id.data = protocoltype_id
Robin Sonnabend's avatar
Robin Sonnabend committed
868
        protocoltype = ProtocolType.query.filter_by(id=protocoltype_id).first()
Robin Sonnabend's avatar
Robin Sonnabend committed
869
870
    if state_open is not None:
        search_form.state_open.data = state_open
871
872
    if search_term is not None:
        search_form.search.data = search_term
Robin Sonnabend's avatar
Robin Sonnabend committed
873
874
875
876
    todos = [
        todo for todo in Todo.query.all()
        if todo.protocoltype.has_public_view_right(user)
    ]
Robin Sonnabend's avatar
Robin Sonnabend committed
877
    if protocoltype_id is not None and protocoltype_id != -1:
Robin Sonnabend's avatar
Robin Sonnabend committed
878
879
880
881
        todos = [
            todo for todo in todos
            if todo.protocoltype.id == protocoltype_id
        ]
Robin Sonnabend's avatar
Robin Sonnabend committed
882
883
    if state_open is not None and state_open != -1:
        todo_done = bool(state_open)
Robin Sonnabend's avatar
Robin Sonnabend committed
884
885
886
887
        todos = [
            todo for todo in todos
            if todo.is_done() == todo_done
        ]
Robin Sonnabend's avatar
Robin Sonnabend committed
888
    if search_term is not None and len(search_term.strip()) > 0:
Robin Sonnabend's avatar
Robin Sonnabend committed
889
890
891
        todos = [
            todo for todo in todos
            if search_term.lower() in todo.description.lower()
892
            or search_term.lower() in todo.who.lower()
Robin Sonnabend's avatar
Robin Sonnabend committed
893
        ]
Robin Sonnabend's avatar
Robin Sonnabend committed
894
    def _sort_key(todo):
Administrator's avatar
Administrator committed
895
        return (not todo.is_done(), todo.get_id())
Robin Sonnabend's avatar
Robin Sonnabend committed
896
    todos = sorted(todos, key=_sort_key, reverse=True)
Robin Sonnabend's avatar
Robin Sonnabend committed
897
    page = _get_page()
Robin Sonnabend's avatar
Robin Sonnabend committed
898
899
    page_length = _get_page_length()
    page_count = int(math.ceil(len(todos) / page_length))
Robin Sonnabend's avatar
Robin Sonnabend committed
900
901
    if page >= page_count:
        page = 0
Robin Sonnabend's avatar
Robin Sonnabend committed
902
903
    begin_index = page * page_length
    end_index = (page + 1) * page_length
904
    max_page_length_exp = math.ceil(math.log10(len(todos))) if len(todos) > 0 else 1