server.py 60.9 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
import subprocess
22
23

import config
Robin Sonnabend's avatar
Robin Sonnabend committed
24
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
25
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
26
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
27
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
28
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
29
from views.tables import ProtocolsTable, ProtocolTypesTable, ProtocolTypeTable, DefaultTOPsTable, MeetingRemindersTable, ErrorsTable, TodosTable, DocumentsTable, DecisionsTable, TodoTable, ErrorTable, TodoMailsTable, DefaultMetasTable, DecisionCategoriesTable
30
from legacy import import_old_todos, import_old_protocols, import_old_todomails
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53

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
54
app.jinja_env.filters["timify"] = time_filter
55
app.jinja_env.filters["timify_short"] = time_filter_short
Robin Sonnabend's avatar
Robin Sonnabend committed
56
app.jinja_env.filters["datify_short"] = date_filter_short
Robin Sonnabend's avatar
Robin Sonnabend committed
57
app.jinja_env.filters["datify_long"] = date_filter_long
Robin Sonnabend's avatar
Robin Sonnabend committed
58
#app.jinja_env.filters["url_complete"] = url_manager.complete
59
app.jinja_env.filters["class"] = class_filter
Robin Sonnabend's avatar
Robin Sonnabend committed
60
61
app.jinja_env.filters["todo_get_name"] = todostate_name_filter
app.jinja_env.filters["code"] = code_filter
Robin Sonnabend's avatar
Robin Sonnabend committed
62
app.jinja_env.filters["indent_tab"] = indent_tab_filter
Robin Sonnabend's avatar
Robin Sonnabend committed
63
app.jinja_env.filters["fancy_join"] = fancy_join
Robin Sonnabend's avatar
Robin Sonnabend committed
64
app.jinja_env.filters["footnote_hash"] = footnote_hash
65
app.jinja_env.tests["auth_valid"] = security_manager.check_user
Robin Sonnabend's avatar
Robin Sonnabend committed
66
app.jinja_env.tests["needs_date"] = needs_date_test
67

68
69
70
71
72
73
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)
    

74
75
import tasks

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

84
85
86
87
88
89
90
91
92
93
94
95
def get_git_revision():
    gitlab_url = "https://git.fsmpi.rwth-aachen.de/protokollsystem/proto3"
    commit_hash = subprocess.check_output(["git", "log", "-g", "-1", "--pretty=%H"]).decode("UTF-8").strip()
    timestamp = int(subprocess.check_output(["git", "log", "-g", "-1", "--pretty=%at"]).strip())
    commit_date = datetime.fromtimestamp(timestamp)
    return {"url": gitlab_url, "hash": commit_hash, "date": commit_date}

try:
    app.jinja_env.globals["git_revision"] = get_git_revision()
except:
    pass

96
97
# blueprints here

98
99
@manager.command
def import_legacy():
100
    """Import the old todos and protocols from an sql dump"""
101
    filename = prompt("SQL-file")
102
    #filename = "legacy.sql"
103
104
    with open(filename, "rb") as sqlfile:
        content = sqlfile.read().decode("utf-8")
105
106
        import_old_todos(content)
        import_old_protocols(content)
107
        import_old_todomails(content)
108

109
110
111
112
@manager.command
def recompile_all():
    for protocol in sorted(Protocol.query.all(), key=lambda p: p.date):
        if protocol.is_done():
113
            print(protocol.get_short_identifier())
114
115
116
117
118
119
120
121
122
123
124
125
            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)
126
            if todo2.state.value > todo1.state.value:
127
128
129
130
131
132
133
134
135
136
137
138
139
                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():
140
    app.run()
141
142
    make_scheduler()

143
144
145
146
# 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)
147
148
149
150
151
152
153
154
    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"
155
    return response
156

157
158
@app.route("/")
def index():
Robin Sonnabend's avatar
Robin Sonnabend committed
159
160
161
    user = current_user()
    protocols = [
        protocol for protocol in Protocol.query.all()
162
163
        if protocol.protocoltype.has_public_view_right(user,
            check_networks=False)
Robin Sonnabend's avatar
Robin Sonnabend committed
164
    ]
165
    def _protocol_sort_key(protocol):
Robin Sonnabend's avatar
Robin Sonnabend committed
166
167
168
        if protocol.date is not None:
            return protocol.date
        return datetime.now().date()
Robin Sonnabend's avatar
Robin Sonnabend committed
169
    current_day = datetime.now().date()
170
    open_protocols = sorted(
Robin Sonnabend's avatar
Robin Sonnabend committed
171
172
173
174
        [
            protocol for protocol in protocols
            if not protocol.done
            and (protocol.date - current_day).days < config.MAX_INDEX_DAYS
175
            and (current_day - protocol.date).days < config.MAX_PAST_INDEX_DAYS
Robin Sonnabend's avatar
Robin Sonnabend committed
176
        ],
177
        key=_protocol_sort_key
Robin Sonnabend's avatar
Robin Sonnabend committed
178
179
    )
    finished_protocols = sorted(
180
181
        [
            protocol for protocol in protocols
182
183
184
            if protocol.done and protocol.public
            and (protocol.has_private_view_right(user)
                or protocol.protocoltype.has_public_view_right(user, check_networks=False))
185
        ],
186
187
        key=_protocol_sort_key,
        reverse=True
Robin Sonnabend's avatar
Robin Sonnabend committed
188
    )
189
190
191
192
193
194
195
    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
196
197
198
    todos = None
    if check_login():
        todos = [
199
            todo for todo in Todo.query.all()
200
            if todo.protocoltype.has_private_view_right(user)
201
            and not todo.is_done()
Robin Sonnabend's avatar
Robin Sonnabend committed
202
        ]
203
204
205
206
207
208
        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
209
210
        def _todo_sort_key(todo):
            protocol = todo.get_first_protocol()
211
            return protocol.date if protocol is not None and protocol.date is not None else datetime.now().date()
212
        todos = sorted(todos, key=_todo_sort_key, reverse=True)
Robin Sonnabend's avatar
Robin Sonnabend committed
213
    todos_table = TodosTable(todos) if todos is not None else None
214
    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)
215

Robin Sonnabend's avatar
Robin Sonnabend committed
216
@app.route("/documentation")
Robin Sonnabend's avatar
Robin Sonnabend committed
217
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
218
def documentation():
Robin Sonnabend's avatar
Robin Sonnabend committed
219
220
221
    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
222

Robin Sonnabend's avatar
Robin Sonnabend committed
223
@app.route("/types/list")
Robin Sonnabend's avatar
Robin Sonnabend committed
224
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
225
226
227
228
229
def list_types():
    is_logged_in = check_login()
    user = current_user()
    types = [
        protocoltype for protocoltype in ProtocolType.query.all()
230
231
        if (protocoltype.has_private_view_right(user)
        or protocoltype.has_public_view_right(user)
Robin Sonnabend's avatar
Robin Sonnabend committed
232
        or protocoltype.is_public)]
233
    types = sorted(types, key=lambda t: t.short_name)
Robin Sonnabend's avatar
Robin Sonnabend committed
234
235
236
237
238
239
240
241
242
243
244
245
    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:
246
247
            protocoltype = ProtocolType()
            form.populate_obj(protocoltype)
Robin Sonnabend's avatar
Robin Sonnabend committed
248
249
250
251
252
253
            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
254
@app.route("/type/edit/<int:protocoltype_id>", methods=["GET", "POST"])
Robin Sonnabend's avatar
Robin Sonnabend committed
255
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
256
@db_lookup(ProtocolType)
Robin Sonnabend's avatar
Robin Sonnabend committed
257
@require_private_view_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
258
def edit_type(protocoltype):
Robin Sonnabend's avatar
Robin Sonnabend committed
259
260
261
262
263
264
265
266
    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
267
            return redirect(request.args.get("next") or url_for("show_type", protocoltype_id=protocoltype.id))
Robin Sonnabend's avatar
Robin Sonnabend committed
268
269
    return render_template("type-edit.html", form=form, protocoltype=protocoltype)

Robin Sonnabend's avatar
Robin Sonnabend committed
270
@app.route("/type/show/<int:protocoltype_id>")
Robin Sonnabend's avatar
Robin Sonnabend committed
271
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
272
@db_lookup(ProtocolType)
Robin Sonnabend's avatar
Robin Sonnabend committed
273
@require_private_view_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
274
def show_type(protocoltype):
Robin Sonnabend's avatar
Robin Sonnabend committed
275
276
    protocoltype_table = ProtocolTypeTable(protocoltype)
    default_tops_table = DefaultTOPsTable(protocoltype.default_tops, protocoltype)
277
    reminders_table = MeetingRemindersTable(protocoltype.reminders, protocoltype)
Robin Sonnabend's avatar
Robin Sonnabend committed
278
    metas_table = DefaultMetasTable(protocoltype.metas, protocoltype)
279
280
    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)
281

Robin Sonnabend's avatar
Robin Sonnabend committed
282
@app.route("/type/delete/<int:protocoltype_id>")
283
@login_required
284
@group_required(config.ADMIN_GROUP)
Robin Sonnabend's avatar
Robin Sonnabend committed
285
@db_lookup(ProtocolType)
Robin Sonnabend's avatar
Robin Sonnabend committed
286
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
287
def delete_type(protocoltype):
288
289
290
291
292
293
    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
294
@app.route("/type/reminders/new/<int:protocoltype_id>", methods=["GET", "POST"])
295
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
296
@db_lookup(ProtocolType)
Robin Sonnabend's avatar
Robin Sonnabend committed
297
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
298
def new_reminder(protocoltype):
299
300
    form = MeetingReminderForm()
    if form.validate_on_submit():
301
302
        meetingreminder = MeetingReminder(protocoltype_id=protocoltype.id)
        form.populate_obj(meetingreminder)
Robin Sonnabend's avatar
Robin Sonnabend committed
303
        db.session.add(meetingreminder)
304
        db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
305
        return redirect(request.args.get("next") or url_for("show_type", protocoltype_id=protocoltype.id))
306
307
    return render_template("reminder-new.html", form=form, protocoltype=protocoltype)

Robin Sonnabend's avatar
Robin Sonnabend committed
308
@app.route("/type/reminder/edit/<int:meetingreminder_id>", methods=["GET", "POST"])
309
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
310
@db_lookup(MeetingReminder)
Robin Sonnabend's avatar
Robin Sonnabend committed
311
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
312
313
def edit_reminder(meetingreminder):
    form = MeetingReminderForm(obj=meetingreminder)
314
    if form.validate_on_submit():
Robin Sonnabend's avatar
Robin Sonnabend committed
315
        form.populate_obj(meetingreminder)
316
        db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
317
        return redirect(request.args.get("next") or url_for("show_type", protocoltype_id=protocoltype.id))
318
    return render_template("reminder-edit.html", form=form, meetingreminder=meetingreminder)
319

Robin Sonnabend's avatar
Robin Sonnabend committed
320
@app.route("/type/reminder/delete/<int:meetingreminder_id>")
321
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
322
@db_lookup(MeetingReminder)
Robin Sonnabend's avatar
Robin Sonnabend committed
323
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
324
325
326
def delete_reminder(meetingreminder):
    protocoltype = meetingreminder.protocoltype
    db.session.delete(meetingreminder)
327
    db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
328
    return redirect(request.args.get("next") or url_for("show_type", protocoltype_id=protocoltype.id))
329

Robin Sonnabend's avatar
Robin Sonnabend committed
330
@app.route("/type/tops/new/<int:protocoltype_id>", methods=["GET", "POST"])
Robin Sonnabend's avatar
Robin Sonnabend committed
331
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
332
@db_lookup(ProtocolType)
Robin Sonnabend's avatar
Robin Sonnabend committed
333
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
334
def new_default_top(protocoltype):
Robin Sonnabend's avatar
Robin Sonnabend committed
335
336
    form = DefaultTopForm()
    if form.validate_on_submit():
337
338
        defaulttop = DefaultTOP(protocoltype_id=protocoltype.id)
        form.populate_obj(defaulttop)
Robin Sonnabend's avatar
Robin Sonnabend committed
339
        db.session.add(defaulttop)
Robin Sonnabend's avatar
Robin Sonnabend committed
340
        db.session.commit()
341
342
343
        for protocol in protocoltype.protocols:
            if not protocol.done:
                localtop = LocalTOP(protocol_id=protocol.id,
Administrator's avatar
Administrator committed
344
                    defaulttop_id=defaulttop.id, description="")
345
346
                db.session.add(localtop)
        db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
347
        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
348
349
350
        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
351
@app.route("/type/tops/edit/<int:protocoltype_id>/<int:defaulttop_id>", methods=["GET", "POST"])
Robin Sonnabend's avatar
Robin Sonnabend committed
352
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
353
@db_lookup(ProtocolType, DefaultTOP)
Robin Sonnabend's avatar
Robin Sonnabend committed
354
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
355
356
def edit_default_top(protocoltype, defaulttop):
    form = DefaultTopForm(obj=defaulttop)
Robin Sonnabend's avatar
Robin Sonnabend committed
357
    if form.validate_on_submit():
Robin Sonnabend's avatar
Robin Sonnabend committed
358
        form.populate_obj(defaulttop)
Robin Sonnabend's avatar
Robin Sonnabend committed
359
        db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
360
361
        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
362

Robin Sonnabend's avatar
Robin Sonnabend committed
363
@app.route("/type/tops/delete/<int:defaulttop_id>")
Robin Sonnabend's avatar
Robin Sonnabend committed
364
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
365
@db_lookup(DefaultTOP)
Robin Sonnabend's avatar
Robin Sonnabend committed
366
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
367
368
def delete_default_top(defaulttop):
    db.session.delete(defaulttop)
Robin Sonnabend's avatar
Robin Sonnabend committed
369
    db.session.commit()
370
    return redirect(request.args.get("next") or url_for("show_type", protocoltype_id=defaulttop.protocoltype.id))
Robin Sonnabend's avatar
Robin Sonnabend committed
371

Robin Sonnabend's avatar
Robin Sonnabend committed
372
@app.route("/type/tops/move/<int:defaulttop_id>/<diff>/")
Robin Sonnabend's avatar
Robin Sonnabend committed
373
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
374
@db_lookup(DefaultTOP)
Robin Sonnabend's avatar
Robin Sonnabend committed
375
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
376
def move_default_top(defaulttop, diff):
Robin Sonnabend's avatar
Robin Sonnabend committed
377
    try:
Robin Sonnabend's avatar
Robin Sonnabend committed
378
        defaulttop.number += int(diff)
Robin Sonnabend's avatar
Robin Sonnabend committed
379
380
381
        db.session.commit()
    except ValueError:
        flash("Die angegebene Differenz ist keine Zahl.", "alert-error")
Robin Sonnabend's avatar
Robin Sonnabend committed
382
    return redirect(request.args.get("next") or url_for("show_type", protocoltype_id=defaulttop.protocoltype.id))
Robin Sonnabend's avatar
Robin Sonnabend committed
383
384

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

@app.route("/protocol/new", methods=["GET", "POST"])
@login_required
def new_protocol():
    user = current_user()
Robin Sonnabend's avatar
Robin Sonnabend committed
498
    protocoltypes = ProtocolType.get_modifiable_protocoltypes(user)
Robin Sonnabend's avatar
Robin Sonnabend committed
499
    form = NewProtocolForm(protocoltypes)
Robin Sonnabend's avatar
Robin Sonnabend committed
500
    upload_form = NewProtocolSourceUploadForm(protocoltypes)
501
    file_upload_form = NewProtocolFileUploadForm(protocoltypes)
Robin Sonnabend's avatar
Robin Sonnabend committed
502
    if form.validate_on_submit():
503
        protocoltype = ProtocolType.query.filter_by(id=form.protocoltype_id.data).first()
Robin Sonnabend's avatar
Robin Sonnabend committed
504
505
506
        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"))
507
508
        protocol = Protocol.create_new_protocol(protocoltype,
            form.date.data, form.start_time.data)
Robin Sonnabend's avatar
Robin Sonnabend committed
509
        return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol.id))
510
    type_id = request.args.get("protocoltype_id")
Robin Sonnabend's avatar
Robin Sonnabend committed
511
512
    if type_id is not None:
        form.protocoltype.data = type_id
513
514
        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
515
516

@app.route("/protocol/show/<int:protocol_id>")
Robin Sonnabend's avatar
Robin Sonnabend committed
517
518
@db_lookup(Protocol)
def show_protocol(protocol):
Robin Sonnabend's avatar
Robin Sonnabend committed
519
520
    user = current_user()
    errors_table = ErrorsTable(protocol.errors)
521
    if not protocol.protocoltype.has_public_view_right(user, check_networks=False):
522
523
524
        flash("Dir fehlen die nötigen Zugriffsrechte.", "alert-error")
        if check_login():
            return redirect(url_for("index"))
525
        return redirect(request.args.get("next") or url_for("login", next=request.url))
Robin Sonnabend's avatar
Robin Sonnabend committed
526
527
    visible_documents = [
        document for document in protocol.documents
528
        if (not document.is_private and document.protocol.has_public_view_right(user))
Robin Sonnabend's avatar
Robin Sonnabend committed
529
530
        or (document.is_private and document.protocol.protocoltype.has_private_view_right(user))
    ]
531
    documents_table = DocumentsTable(visible_documents, protocol)
532
    document_upload_form = DocumentUploadForm()
Robin Sonnabend's avatar
Robin Sonnabend committed
533
    source_upload_form = KnownProtocolSourceUploadForm()
534
535
    time_diff = protocol.date - datetime.now().date()
    large_time_diff = not protocol.is_done() and time_diff.days > 0
536
537
538
    content_html = (protocol.content_html_private
        if protocol.has_private_view_right(user)
        else protocol.content_html_public)
539
540
541
    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
542

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

Administrator's avatar
Administrator committed
658
659
660
@app.route("/protocol/recompile/<int:protocol_id>")
@login_required
@group_required(config.ADMIN_GROUP)
Robin Sonnabend's avatar
Robin Sonnabend committed
661
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
662
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
663
def recompile_protocol(protocol):
Administrator's avatar
Administrator committed
664
665
    tasks.parse_protocol(protocol)
    return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol.id))
666

Robin Sonnabend's avatar
Robin Sonnabend committed
667
668
@app.route("/protocol/source/<int:protocol_id>")
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
669
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
670
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
671
def get_protocol_source(protocol):
Robin Sonnabend's avatar
Robin Sonnabend committed
672
    file_like = BytesIO(protocol.source.encode("utf-8"))
673
    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
674

Robin Sonnabend's avatar
Robin Sonnabend committed
675
676
@app.route("/protocol/template/<int:protocol_id>")
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
677
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
678
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
679
def get_protocol_template(protocol):
Robin Sonnabend's avatar
Robin Sonnabend committed
680
    file_like = BytesIO(protocol.get_template().encode("utf-8"))
681
    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
682

Robin Sonnabend's avatar
Robin Sonnabend committed
683
684
@app.route("/protocol/etherpush/<int:protocol_id>")
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
685
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
686
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
687
def etherpush_protocol(protocol):
688
689
690
    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))
691
692
693
    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
694

Robin Sonnabend's avatar
Robin Sonnabend committed
695
@app.route("/protocol/update/<int:protocol_id>", methods=["GET", "POST"])
Robin Sonnabend's avatar
Robin Sonnabend committed
696
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
697
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
698
@require_publish_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
699
def update_protocol(protocol):
Robin Sonnabend's avatar
Robin Sonnabend committed
700
    upload_form = KnownProtocolSourceUploadForm()
701
    edit_form = generate_protocol_form(protocol)(obj=protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
702
703
    if edit_form.validate_on_submit():
        edit_form.populate_obj(protocol)
704
705
        for meta in protocol.metas:
            meta.value = getattr(edit_form.metas, meta.name).data
Robin Sonnabend's avatar
Robin Sonnabend committed
706
        db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
707
        tasks.push_tops_to_calendar(protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
708
        return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol.id))
709
710
    for meta in protocol.metas:
        getattr(edit_form.metas, meta.name).data = meta.value
Robin Sonnabend's avatar
Robin Sonnabend committed
711
    return render_template("protocol-update.html", upload_form=upload_form, edit_form=edit_form, protocol=protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
712

713
714
@app.route("/protocol/publish/<int:protocol_id>")
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
715
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
716
@require_publish_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
717
def publish_protocol(protocol):
718
719
720
721
    protocol.public = True
    db.session.commit()
    return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol.id))

722
@app.route("/prococol/send/private/<int:protocol_id>")
723
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
724
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
725
@require_modify_right()
726
def send_protocol_private(protocol):
727
728
729
    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))
730
731
732
733
734
735
736
    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
737
@require_publish_right()
738
739
740
741
742
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)
743
744
745
    flash("Das Protokoll wurde versandt.", "alert-success")
    return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol.id))

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

@app.route("/protocol/top/move/<int:top_id>/<diff>")
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
820
@db_lookup(TOP)
Robin Sonnabend's avatar
Robin Sonnabend committed
821
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
822
def move_top(top, diff):
Robin Sonnabend's avatar
Robin Sonnabend committed
823
824
825
    try:
        top.number += int(diff)
        db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
826
        tasks.push_tops_to_calendar(top.protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
827
828
829
830
    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))

831
832
833
834
835
836
837
838
839
840
841
842
@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
843
844
845
846
847
848
849
850
851
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
852
853
854
855
856
857
858
859
860
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

861
@app.route("/todos/list")
Robin Sonnabend's avatar
Robin Sonnabend committed
862
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
863
864
def list_todos():
    user = current_user()
Robin Sonnabend's avatar
Robin Sonnabend committed
865
866
867
    protocoltype = None
    protocoltype_id = None
    try:
868
        protocoltype_id = int(request.args.get("protocoltype_id"))
Robin Sonnabend's avatar
Robin Sonnabend committed
869
870
    except (ValueError, TypeError):
        pass
Robin Sonnabend's avatar
Robin Sonnabend committed
871
    state_open = -1
Robin Sonnabend's avatar
Robin Sonnabend committed
872
    try:
Robin Sonnabend's avatar
Robin Sonnabend committed
873
        state_open = int(request.args.get("state_open"))
Robin Sonnabend's avatar
Robin Sonnabend committed
874
875
    except (ValueError, TypeError):
        pass
Robin Sonnabend's avatar
Robin Sonnabend committed
876
    search_term = request.args.get("search")
Robin Sonnabend's avatar
Robin Sonnabend committed
877
    protocoltypes = ProtocolType.get_public_protocoltypes(user)
Robin Sonnabend's avatar
Robin Sonnabend committed
878
    search_form = TodoSearchForm(protocoltypes)
Robin Sonnabend's avatar
Robin Sonnabend committed
879
    if protocoltype_id is not None:
880
        search_form.protocoltype_id.data = protocoltype_id
Robin Sonnabend's avatar
Robin Sonnabend committed
881
        protocoltype = ProtocolType.query.filter_by(id=protocoltype_id).first()
Robin Sonnabend's avatar
Robin Sonnabend committed
882
883
    if state_open is not None:
        search_form.state_open.data = state_open
884
885
    if search_term is not None:
        search_form.search.data = search_term