server.py 60.7 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
162
        [
            protocol for protocol in protocols
            if not protocol.done
            and (protocol.date - current_day).days < config.MAX_INDEX_DAYS
        ],
163
        key=_protocol_sort_key
Robin Sonnabend's avatar
Robin Sonnabend committed
164
165
    )
    finished_protocols = sorted(
166
167
        [
            protocol for protocol in protocols
168
169
170
            if protocol.done and protocol.public
            and (protocol.has_private_view_right(user)
                or protocol.protocoltype.has_public_view_right(user, check_networks=False))
171
        ],
172
173
        key=_protocol_sort_key,
        reverse=True
Robin Sonnabend's avatar
Robin Sonnabend committed
174
    )
175
176
177
178
179
180
181
    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
182
183
184
    todos = None
    if check_login():
        todos = [
185
            todo for todo in Todo.query.all()
186
            if todo.protocoltype.has_private_view_right(user)
187
            and not todo.is_done()
Robin Sonnabend's avatar
Robin Sonnabend committed
188
        ]
189
190
191
192
193
194
        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
195
196
        def _todo_sort_key(todo):
            protocol = todo.get_first_protocol()
197
            return protocol.date if protocol is not None and protocol.date is not None else datetime.now().date()
198
        todos = sorted(todos, key=_todo_sort_key, reverse=True)
Robin Sonnabend's avatar
Robin Sonnabend committed
199
    todos_table = TodosTable(todos) if todos is not None else None
200
    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)
201

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

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

Robin Sonnabend's avatar
Robin Sonnabend committed
256
@app.route("/type/show/<int:protocoltype_id>")
Robin Sonnabend's avatar
Robin Sonnabend committed
257
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
258
@db_lookup(ProtocolType)
Robin Sonnabend's avatar
Robin Sonnabend committed
259
@require_private_view_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
260
def show_type(protocoltype):
Robin Sonnabend's avatar
Robin Sonnabend committed
261
262
    protocoltype_table = ProtocolTypeTable(protocoltype)
    default_tops_table = DefaultTOPsTable(protocoltype.default_tops, protocoltype)
263
    reminders_table = MeetingRemindersTable(protocoltype.reminders, protocoltype)
Robin Sonnabend's avatar
Robin Sonnabend committed
264
    metas_table = DefaultMetasTable(protocoltype.metas, protocoltype)
265
266
    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)
267

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

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

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

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

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

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

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

@app.route("/protocol/new", methods=["GET", "POST"])
@login_required
def new_protocol():
    user = current_user()
Robin Sonnabend's avatar
Robin Sonnabend committed
484
    protocoltypes = ProtocolType.get_modifiable_protocoltypes(user)
Robin Sonnabend's avatar
Robin Sonnabend committed
485
    form = NewProtocolForm(protocoltypes)
Robin Sonnabend's avatar
Robin Sonnabend committed
486
    upload_form = NewProtocolSourceUploadForm(protocoltypes)
487
    file_upload_form = NewProtocolFileUploadForm(protocoltypes)
Robin Sonnabend's avatar
Robin Sonnabend committed
488
    if form.validate_on_submit():
489
        protocoltype = ProtocolType.query.filter_by(id=form.protocoltype_id.data).first()
Robin Sonnabend's avatar
Robin Sonnabend committed
490
491
492
        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"))
493
494
        protocol = Protocol(protocoltype_id=protocoltype.id)
        form.populate_obj(protocol)
495
496
        if form.start_time.data is None:
            protocol.start_time = protocoltype.usual_time
Robin Sonnabend's avatar
Robin Sonnabend committed
497
498
        db.session.add(protocol)
        db.session.commit()
499
        for local_top in protocol.create_localtops():
500
            db.session.add(local_top)
501
502
503
504
        for default_meta in protocoltype.metas:
            if default_meta.prior:
                meta = Meta(protocol_id=protocol.id, name=default_meta.name, internal=default_meta.internal, value=default_meta.value)
                db.session.add(meta)
505
        db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
506
        tasks.push_tops_to_calendar(protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
507
        return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol.id))
508
    type_id = request.args.get("protocoltype_id")
Robin Sonnabend's avatar
Robin Sonnabend committed
509
510
    if type_id is not None:
        form.protocoltype.data = type_id
511
512
        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
513
514

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

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

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

Robin Sonnabend's avatar
Robin Sonnabend committed
661
662
@app.route("/protocol/source/<int:protocol_id>")
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
663
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
664
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
665
def get_protocol_source(protocol):
Robin Sonnabend's avatar
Robin Sonnabend committed
666
    file_like = BytesIO(protocol.source.encode("utf-8"))
667
    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
668

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

Robin Sonnabend's avatar
Robin Sonnabend committed
677
678
@app.route("/protocol/etherpush/<int:protocol_id>")
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
679
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
680
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
681
def etherpush_protocol(protocol):
682
683
684
    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))
685
686
687
    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
688

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

707
708
@app.route("/protocol/publish/<int:protocol_id>")
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
709
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
710
@require_publish_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
711
def publish_protocol(protocol):
712
713
714
715
    protocol.public = True
    db.session.commit()
    return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol.id))

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

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

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

825
826
827
828
829
830
831
832
833
834
835
836
@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
837
838
839
840
841
842
843
844
845
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
846
847
848
849
850
851
852
853
854
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

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