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

5
from flask import Flask, g, current_app, request, session, flash, redirect, url_for, abort, render_template, Response, send_file as flask_send_file
6
from werkzeug.utils import secure_filename
7
8
9
10
from flask_script import Manager, prompt
from flask_migrate import Migrate, MigrateCommand
#from flask_socketio import SocketIO
from celery import Celery
Robin Sonnabend's avatar
Robin Sonnabend committed
11
from sqlalchemy import or_, and_
12
13
14
from apscheduler.schedulers.background import BackgroundScheduler
from apscheduler.triggers.cron import CronTrigger
from apscheduler.triggers.interval import IntervalTrigger
Robin Sonnabend's avatar
Robin Sonnabend committed
15
import atexit
Robin Sonnabend's avatar
Robin Sonnabend committed
16
from io import StringIO, BytesIO
17
import os
Robin Sonnabend's avatar
Robin Sonnabend committed
18
from datetime import datetime
Robin Sonnabend's avatar
Robin Sonnabend committed
19
import math
20
import mimetypes
21
22

import config
23
from shared import db, date_filter, datetime_filter, date_filter_long, date_filter_short, time_filter, time_filter_short, ldap_manager, security_manager, current_user, check_login, login_required, group_required, class_filter, needs_date_test, todostate_name_filter, code_filter, indent_tab_filter
Robin Sonnabend's avatar
Robin Sonnabend committed
24
from utils import is_past, mail_manager, url_manager, get_first_unused_int, set_etherpad_text, get_etherpad_text, split_terms, optional_int_arg
Robin Sonnabend's avatar
Robin Sonnabend committed
25
from decorators import db_lookup, require_public_view_right, require_private_view_right, require_modify_right, require_admin_right
26
27
from models.database import ProtocolType, Protocol, DefaultTOP, TOP, LocalTOP, Document, Todo, Decision, MeetingReminder, Error, TodoMail, DecisionDocument, TodoState, Meta, DefaultMeta, DecisionCategory
from views.forms import LoginForm, ProtocolTypeForm, DefaultTopForm, MeetingReminderForm, NewProtocolForm, DocumentUploadForm, KnownProtocolSourceUploadForm, NewProtocolSourceUploadForm, ProtocolForm, TopForm, LocalTopForm, SearchForm, DecisionSearchForm, ProtocolSearchForm, TodoSearchForm, NewProtocolFileUploadForm, NewTodoForm, TodoForm, TodoMailForm, DefaultMetaForm, MetaForm, MergeTodosForm, DecisionCategoryForm
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
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
62
app.jinja_env.tests["auth_valid"] = security_manager.check_user
Robin Sonnabend's avatar
Robin Sonnabend committed
63
app.jinja_env.tests["needs_date"] = needs_date_test
64
65
66

import tasks

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

74
75
# blueprints here

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

87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
@manager.command
def recompile_all():
    for protocol in sorted(Protocol.query.all(), key=lambda p: p.date):
        if protocol.is_done():
            print(protocol.get_identifier())
            tasks.parse_protocol(protocol)

@manager.command
def merge_todos():
    todo_by_id = {}
    todos = Todo.query.all()
    for todo in todos:
        todo_id = todo.get_id()
        if todo_id in todo_by_id:
            todo1, todo2 = todo, todo_by_id[todo_id]
            print(todo1)
            print(todo2)
            if todo2.id > todo1.id:
                todo2, todo1 = todo1, todo2
            for protocol in todo2.protocols:
                if protocol not in todo1.protocols:
                    todo1.protocols.append(protocol)
                todo2.protocols.remove(protocol)
            db.session.delete(todo2)
            db.session.commit()
            todo_by_id[todo_id] = todo1
        else:
            todo_by_id[todo_id] = todo

@manager.command
def runserver():
118
    app.run()
119
120
    make_scheduler()

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

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

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

Robin Sonnabend's avatar
Robin Sonnabend committed
190
@app.route("/types/list")
Robin Sonnabend's avatar
Robin Sonnabend committed
191
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
192
193
194
195
196
197
198
199
def list_types():
    is_logged_in = check_login()
    user = current_user()
    types = [
        protocoltype for protocoltype in ProtocolType.query.all()
        if (protocoltype.public_group in user.groups
        or protocoltype.private_group in user.groups
        or protocoltype.is_public)]
200
    types = sorted(types, key=lambda t: t.short_name)
Robin Sonnabend's avatar
Robin Sonnabend committed
201
202
203
204
205
206
207
208
209
210
211
212
    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:
213
214
            protocoltype = ProtocolType()
            form.populate_obj(protocoltype)
Robin Sonnabend's avatar
Robin Sonnabend committed
215
216
217
218
219
220
            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
221
@app.route("/type/edit/<int:protocoltype_id>", methods=["GET", "POST"])
Robin Sonnabend's avatar
Robin Sonnabend committed
222
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
223
@db_lookup(ProtocolType)
Robin Sonnabend's avatar
Robin Sonnabend committed
224
@require_private_view_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
225
def edit_type(protocoltype):
Robin Sonnabend's avatar
Robin Sonnabend committed
226
227
228
229
230
231
232
233
    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
234
            return redirect(request.args.get("next") or url_for("show_type", protocoltype_id=protocoltype.id))
Robin Sonnabend's avatar
Robin Sonnabend committed
235
236
    return render_template("type-edit.html", form=form, protocoltype=protocoltype)

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

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

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

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

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

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

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

@app.route("/protocols/list")
346
347
348
def list_protocols():
    is_logged_in = check_login()
    user = current_user()
Robin Sonnabend's avatar
Robin Sonnabend committed
349
350
351
    protocoltype = None
    protocoltype_id = None
    try:
352
        protocoltype_id = int(request.args.get("protocoltype_id"))
Robin Sonnabend's avatar
Robin Sonnabend committed
353
354
    except (ValueError, TypeError):
        pass
Robin Sonnabend's avatar
Robin Sonnabend committed
355
    state_open = -1
Robin Sonnabend's avatar
Robin Sonnabend committed
356
    try:
Robin Sonnabend's avatar
Robin Sonnabend committed
357
        state_open = int(request.args.get("state_open"))
Robin Sonnabend's avatar
Robin Sonnabend committed
358
359
    except (ValueError, TypeError):
        pass
Robin Sonnabend's avatar
Robin Sonnabend committed
360
    search_term = request.args.get("search")
361
    protocoltypes = ProtocolType.get_public_protocoltypes(user, check_networks=False)
Robin Sonnabend's avatar
Robin Sonnabend committed
362
    search_form = ProtocolSearchForm(protocoltypes)
Robin Sonnabend's avatar
Robin Sonnabend committed
363
    if protocoltype_id is not None:
364
        search_form.protocoltype_id.data = protocoltype_id
Robin Sonnabend's avatar
Robin Sonnabend committed
365
        protocoltype = ProtocolType.query.filter_by(id=protocoltype_id).first()
Robin Sonnabend's avatar
Robin Sonnabend committed
366
367
    if state_open is not None:
        search_form.state_open.data = state_open
Robin Sonnabend's avatar
Robin Sonnabend committed
368
369
370
    if search_term is not None:
        search_form.search.data = search_term
    protocol_query = Protocol.query
Robin Sonnabend's avatar
Robin Sonnabend committed
371
372
373
374
375
376
377
378
379
    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))
            ))
380
    protocols = [
Robin Sonnabend's avatar
Robin Sonnabend committed
381
        protocol for protocol in protocol_query.all()
382
        if protocol.protocoltype.has_public_view_right(user, check_networks=False)
383
    ]
Robin Sonnabend's avatar
Robin Sonnabend committed
384
385
386
387
388
389
390
391
392
393
394
395
396
    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
397
398
399
400
401
    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
402
403
    if state_open is not None and state_open != -1:
        protocol_done = bool(state_open)
Robin Sonnabend's avatar
Robin Sonnabend committed
404
405
        protocols = [
            protocol for protocol in protocols
406
            if (protocol.is_done() or False) == protocol_done
Robin Sonnabend's avatar
Robin Sonnabend committed
407
        ]
Robin Sonnabend's avatar
Robin Sonnabend committed
408
409
410
411
412
    if shall_search:
        protocols = [
            protocol for protocol in protocols
            if (protocol.protocoltype.has_private_view_right(user)
                and _matches_search(protocol.content_private))
413
            or (protocol.has_public_view_right(user)
Robin Sonnabend's avatar
Robin Sonnabend committed
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
                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
                ]))
441
            search_results[protocol] = " …<br />\n".join(formatted_lines)
Robin Sonnabend's avatar
Robin Sonnabend committed
442
    protocols = sorted(protocols, key=lambda protocol: protocol.date, reverse=True)
Robin Sonnabend's avatar
Robin Sonnabend committed
443
    page = _get_page()
Robin Sonnabend's avatar
Robin Sonnabend committed
444
445
    page_length = _get_page_length()
    page_count = int(math.ceil(len(protocols) / page_length))
Robin Sonnabend's avatar
Robin Sonnabend committed
446
447
    if page >= page_count:
        page = 0
Robin Sonnabend's avatar
Robin Sonnabend committed
448
449
    begin_index = page * page_length
    end_index = (page + 1) * page_length
450
    max_page_length_exp = math.ceil(math.log10(len(protocols))) if len(protocols) > 0 else 1
Robin Sonnabend's avatar
Robin Sonnabend committed
451
    protocols = protocols[begin_index:end_index]
Robin Sonnabend's avatar
Robin Sonnabend committed
452
    protocols_table = ProtocolsTable(protocols, search_results=search_results)
Robin Sonnabend's avatar
Robin Sonnabend committed
453
    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
454
455
456
457
458

@app.route("/protocol/new", methods=["GET", "POST"])
@login_required
def new_protocol():
    user = current_user()
Robin Sonnabend's avatar
Robin Sonnabend committed
459
    protocoltypes = ProtocolType.get_modifiable_protocoltypes(user)
Robin Sonnabend's avatar
Robin Sonnabend committed
460
    form = NewProtocolForm(protocoltypes)
Robin Sonnabend's avatar
Robin Sonnabend committed
461
    upload_form = NewProtocolSourceUploadForm(protocoltypes)
462
    file_upload_form = NewProtocolFileUploadForm(protocoltypes)
Robin Sonnabend's avatar
Robin Sonnabend committed
463
    if form.validate_on_submit():
464
        protocoltype = ProtocolType.query.filter_by(id=form.protocoltype_id.data).first()
Robin Sonnabend's avatar
Robin Sonnabend committed
465
466
467
        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"))
468
469
        protocol = Protocol(protocoltype_id=protocoltype.id)
        form.populate_obj(protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
470
471
        db.session.add(protocol)
        db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
472
        tasks.push_tops_to_calendar(protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
473
        return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol.id))
474
    type_id = request.args.get("protocoltype_id")
Robin Sonnabend's avatar
Robin Sonnabend committed
475
476
    if type_id is not None:
        form.protocoltype.data = type_id
477
478
        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
479
480

@app.route("/protocol/show/<int:protocol_id>")
Robin Sonnabend's avatar
Robin Sonnabend committed
481
482
@db_lookup(Protocol)
def show_protocol(protocol):
Robin Sonnabend's avatar
Robin Sonnabend committed
483
484
    user = current_user()
    errors_table = ErrorsTable(protocol.errors)
485
    if not protocol.protocoltype.has_public_view_right(user, check_networks=False): # yes, feature
Robin Sonnabend's avatar
Robin Sonnabend committed
486
        flash("Die fehlen die nötigen Zugriffsrechte.", "alert-error")
487
        return redirect(request.args.get("next") or url_for("login", next=request.url))
Robin Sonnabend's avatar
Robin Sonnabend committed
488
489
    visible_documents = [
        document for document in protocol.documents
490
        if (not document.is_private and document.protocol.has_public_view_right(user))
Robin Sonnabend's avatar
Robin Sonnabend committed
491
492
        or (document.is_private and document.protocol.protocoltype.has_private_view_right(user))
    ]
493
    documents_table = DocumentsTable(visible_documents, protocol)
494
    document_upload_form = DocumentUploadForm()
Robin Sonnabend's avatar
Robin Sonnabend committed
495
    source_upload_form = KnownProtocolSourceUploadForm()
496
497
498
    time_diff = protocol.date - datetime.now().date()
    large_time_diff = not protocol.is_done() and time_diff.days > 0
    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)
Robin Sonnabend's avatar
Robin Sonnabend committed
499

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

@app.route("/protocol/upload/new/file/", methods=["POST"])
@login_required
def upload_new_protocol_by_file():
    user = current_user()
    available_types = ProtocolType.get_modifiable_protocoltypes(user)
    form = NewProtocolFileUploadForm(protocoltypes=available_types)
    if form.validate_on_submit():
        if form.file.data is None:
            flash("Es wurde keine Datei ausgewählt.", "alert-error")
            return redirect(request.args.get("fail") or url_for("new_protocol"))
        file = form.file.data
        if file.filename == "":
            flash("Es wurde keine Datei ausgewählt.", "alert-error")
            return redirect(request.args.get("fail") or url_for("new_protocol"))
        filename = secure_filename(file.filename)
590
        protocoltype = ProtocolType.query.filter_by(id=form.protocoltype_id.data).first()
591
592
593
        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"))
594
        protocol = Protocol(protocoltype_id=protocoltype.id, date=datetime.now().date(), done=True)
595
596
        db.session.add(protocol)
        db.session.commit()
597
598
599
        document = Document(protocol_id=protocol.id, name=filename,
            filename="", is_compiled=False)
        form.populate_obj(document)
600
601
602
603
604
605
606
        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
607
608
    return redirect(request.args.get("fail") or url_for("new_protocol"))

Administrator's avatar
Administrator committed
609
610
611
@app.route("/protocol/recompile/<int:protocol_id>")
@login_required
@group_required(config.ADMIN_GROUP)
Robin Sonnabend's avatar
Robin Sonnabend committed
612
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
613
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
614
def recompile_protocol(protocol):
Administrator's avatar
Administrator committed
615
616
    tasks.parse_protocol(protocol)
    return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol.id))
617

Robin Sonnabend's avatar
Robin Sonnabend committed
618
619
@app.route("/protocol/source/<int:protocol_id>")
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
620
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
621
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
622
def get_protocol_source(protocol):
Robin Sonnabend's avatar
Robin Sonnabend committed
623
624
625
    file_like = BytesIO(protocol.source.encode("utf-8"))
    return send_file(file_like, cache_timeout=1, as_attachment=True, attachment_filename="{}.txt".format(protocol.get_identifier()))

Robin Sonnabend's avatar
Robin Sonnabend committed
626
627
@app.route("/protocol/template/<int:protocol_id>")
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
628
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
629
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
630
def get_protocol_template(protocol):
Robin Sonnabend's avatar
Robin Sonnabend committed
631
632
633
    file_like = BytesIO(protocol.get_template().encode("utf-8"))
    return send_file(file_like, cache_timeout=1, as_attachment=True, attachment_filename="{}-template.txt".format(protocol.get_identifier()))

Robin Sonnabend's avatar
Robin Sonnabend committed
634
635
@app.route("/protocol/etherpush/<int:protocol_id>")
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
636
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
637
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
638
def etherpush_protocol(protocol):
639
640
641
    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))
642
643
644
    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
645

Robin Sonnabend's avatar
Robin Sonnabend committed
646
@app.route("/protocol/update/<int:protocol_id>", methods=["GET", "POST"])
Robin Sonnabend's avatar
Robin Sonnabend committed
647
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
648
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
649
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
650
def update_protocol(protocol):
Robin Sonnabend's avatar
Robin Sonnabend committed
651
    upload_form = KnownProtocolSourceUploadForm()
Robin Sonnabend's avatar
Robin Sonnabend committed
652
    edit_form = ProtocolForm(obj=protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
653
654
655
    if edit_form.validate_on_submit():
        edit_form.populate_obj(protocol)
        db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
656
        tasks.push_tops_to_calendar(protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
657
        return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol.id))
Robin Sonnabend's avatar
Robin Sonnabend committed
658
    return render_template("protocol-update.html", upload_form=upload_form, edit_form=edit_form, protocol=protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
659

660
661
@app.route("/protocol/publish/<int:protocol_id>")
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
662
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
663
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
664
def publish_protocol(protocol):
665
666
667
668
    protocol.public = True
    db.session.commit()
    return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol.id))

669
670
@app.route("/prococol/send/<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 send_protocol(protocol):
674
675
676
    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))
677
678
679
680
    tasks.send_protocol(protocol)
    flash("Das Protokoll wurde versandt.", "alert-success")
    return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol.id))

681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
@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
708
709
@app.route("/protocol/tops/new/<int:protocol_id>", methods=["GET", "POST"])
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
710
@db_lookup(Protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
711
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
712
def new_top(protocol):
Robin Sonnabend's avatar
Robin Sonnabend committed
713
714
    form = TopForm()
    if form.validate_on_submit():
715
716
        top = TOP(protocol_id=protocol.id, planned=True)
        form.populate_obj(top)
Robin Sonnabend's avatar
Robin Sonnabend committed
717
718
        db.session.add(top)
        db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
719
        tasks.push_tops_to_calendar(top.protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
720
721
722
723
724
725
726
727
728
        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
729
@db_lookup(TOP)
Robin Sonnabend's avatar
Robin Sonnabend committed
730
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
731
def edit_top(top):
Robin Sonnabend's avatar
Robin Sonnabend committed
732
733
734
735
    form = TopForm(obj=top)
    if form.validate_on_submit():
        form.populate_obj(top)
        db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
736
        tasks.push_tops_to_calendar(top.protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
737
738
739
740
741
        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
742
@db_lookup(TOP)
Robin Sonnabend's avatar
Robin Sonnabend committed
743
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
744
def delete_top(top):
Robin Sonnabend's avatar
Robin Sonnabend committed
745
    name = top.name
Robin Sonnabend's avatar
Robin Sonnabend committed
746
    protocol = top.protocol
Robin Sonnabend's avatar
Robin Sonnabend committed
747
748
    db.session.delete(top)
    db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
749
    tasks.push_tops_to_calendar(protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
750
    flash("Der TOP {} wurde gelöscht.".format(name), "alert-success")
Robin Sonnabend's avatar
Robin Sonnabend committed
751
    return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol.id))
Robin Sonnabend's avatar
Robin Sonnabend committed
752
753
754

@app.route("/protocol/top/move/<int:top_id>/<diff>")
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
755
@db_lookup(TOP)
Robin Sonnabend's avatar
Robin Sonnabend committed
756
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
757
def move_top(top, diff):
Robin Sonnabend's avatar
Robin Sonnabend committed
758
759
760
    try:
        top.number += int(diff)
        db.session.commit()
Robin Sonnabend's avatar
Robin Sonnabend committed
761
        tasks.push_tops_to_calendar(top.protocol)
Robin Sonnabend's avatar
Robin Sonnabend committed
762
763
764
765
    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))

766
767
768
769
770
771
772
773
774
775
776
777
@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
778
779
780
781
782
783
784
785
786
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
787
788
789
790
791
792
793
794
795
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

796
@app.route("/todos/list")
Robin Sonnabend's avatar
Robin Sonnabend committed
797
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
798
799
def list_todos():
    user = current_user()
Robin Sonnabend's avatar
Robin Sonnabend committed
800
801
802
    protocoltype = None
    protocoltype_id = None
    try:
803
        protocoltype_id = int(request.args.get("protocoltype_id"))
Robin Sonnabend's avatar
Robin Sonnabend committed
804
805
    except (ValueError, TypeError):
        pass
Robin Sonnabend's avatar
Robin Sonnabend committed
806
    state_open = -1
Robin Sonnabend's avatar
Robin Sonnabend committed
807
    try:
Robin Sonnabend's avatar
Robin Sonnabend committed
808
        state_open = int(request.args.get("state_open"))
Robin Sonnabend's avatar
Robin Sonnabend committed
809
810
    except (ValueError, TypeError):
        pass
Robin Sonnabend's avatar
Robin Sonnabend committed
811
    search_term = request.args.get("search")
Robin Sonnabend's avatar
Robin Sonnabend committed
812
    protocoltypes = ProtocolType.get_public_protocoltypes(user)
Robin Sonnabend's avatar
Robin Sonnabend committed
813
    search_form = TodoSearchForm(protocoltypes)
Robin Sonnabend's avatar
Robin Sonnabend committed
814
    if protocoltype_id is not None:
815
        search_form.protocoltype_id.data = protocoltype_id
Robin Sonnabend's avatar
Robin Sonnabend committed
816
        protocoltype = ProtocolType.query.filter_by(id=protocoltype_id).first()
Robin Sonnabend's avatar
Robin Sonnabend committed
817
818
    if state_open is not None:
        search_form.state_open.data = state_open
819
820
    if search_term is not None:
        search_form.search.data = search_term
Robin Sonnabend's avatar
Robin Sonnabend committed
821
822
823
824
    todos = [
        todo for todo in Todo.query.all()
        if todo.protocoltype.has_public_view_right(user)
    ]
Robin Sonnabend's avatar
Robin Sonnabend committed
825
    if protocoltype_id is not None and protocoltype_id != -1:
Robin Sonnabend's avatar
Robin Sonnabend committed
826
827
828
829
        todos = [
            todo for todo in todos
            if todo.protocoltype.id == protocoltype_id
        ]
Robin Sonnabend's avatar
Robin Sonnabend committed
830
831
    if state_open is not None and state_open != -1:
        todo_done = bool(state_open)
Robin Sonnabend's avatar
Robin Sonnabend committed
832
833
834
835
        todos = [
            todo for todo in todos
            if todo.is_done() == todo_done
        ]
Robin Sonnabend's avatar
Robin Sonnabend committed
836
    if search_term is not None and len(search_term.strip()) > 0:
Robin Sonnabend's avatar
Robin Sonnabend committed
837
838
839
        todos = [
            todo for todo in todos
            if search_term.lower() in todo.description.lower()
840
            or search_term.lower() in todo.who.lower()
Robin Sonnabend's avatar
Robin Sonnabend committed
841
        ]
Robin Sonnabend's avatar
Robin Sonnabend committed
842
    def _sort_key(todo):
Administrator's avatar
Administrator committed
843
        return (not todo.is_done(), todo.get_id())
Robin Sonnabend's avatar
Robin Sonnabend committed
844
    todos = sorted(todos, key=_sort_key, reverse=True)
Robin Sonnabend's avatar
Robin Sonnabend committed
845
    page = _get_page()
Robin Sonnabend's avatar
Robin Sonnabend committed
846
847
    page_length = _get_page_length()
    page_count = int(math.ceil(len(todos) / page_length))
Robin Sonnabend's avatar
Robin Sonnabend committed
848
849
    if page >= page_count:
        page = 0
Robin Sonnabend's avatar
Robin Sonnabend committed
850
851
    begin_index = page * page_length
    end_index = (page + 1) * page_length
852
    max_page_length_exp = math.ceil(math.log10(len(todos))) if len(todos) > 0 else 1
Robin Sonnabend's avatar
Robin Sonnabend committed
853
    todos = todos[begin_index:end_index]
Robin Sonnabend's avatar
Robin Sonnabend committed
854
    todos_table = TodosTable(todos)
Robin Sonnabend's avatar
Robin Sonnabend committed
855
    return render_template("todos-list.html", todos=todos, todos_table=todos_table, search_form=search_form, page=page, page_count=page_count, page_diff=config.PAGE_DIFF, protocoltype_id=protocoltype_id, search_term=search_term, state_open=state_open, page_length=page_length, max_page_length_exp=max_page_length_exp)
Robin Sonnabend's avatar
Robin Sonnabend committed
856

Robin Sonnabend's avatar
Robin Sonnabend committed
857
858
859
860
@app.route("/todo/new", methods=["GET", "POST"])
@login_required
def new_todo():
    user = current_user()
861
    protocoltype_id = optional_int_arg("protocoltype_id")
Robin Sonnabend's avatar
Robin Sonnabend committed
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
    protocol_id = optional_int_arg("protocol_id")
    protocoltype = ProtocolType.query.filter_by(id=protocoltype_id).first()
    protocol = Protocol.query.filter_by(id=protocol_id).first()
    if protocoltype is not None and protocol is not None:
        if protocol.protocoltype != protocoltype:
            flash("Ungültige Protokoll-Typ-Kombination", "alert-error")
            return redirect(request.args.get("next") or url_for("index"))
    if protocoltype is None and protocol is not None:
        protocoltype = protocol.protocoltype
    protocoltypes = ProtocolType.get_modifiable_protocoltypes(user)
    form = NewTodoForm(protocoltypes)
    if form.validate_on_submit():
        added_protocoltype = ProtocolType.query.filter_by(id=form.protocoltype_id.data).first()
        if added_protocoltype is None or not added_protocoltype.has_modify_right(user):
            flash("Invalider Protokolltyp.")
            return redirect(request.args.get("next") or url_for("index"))
878
879
        todo = Todo()
        form.populate_obj(todo)
Robin Sonnabend's avatar
Robin Sonnabend committed
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
        if protocol is not None:
            todo.protocols.append(protocol)
        db.session.add(todo)
        db.session.commit()
        todo.number = todo.id
        db.session.commit()
        flash("Todo wurde angelegt.", "alert-success")
        if protocol is not None:
            return redirect(request.args.get("next") or url_for("show_protocol", protocol_id=protocol.id))
        else:
            return redirect(request.args.get("next") or url_for("list_todos", protocoltype_id=protocoltype_id))
    else:
        if protocoltype is not None:
            form.protocoltype_id.data = protocoltype.id
    return render_template("todo-new.html", form=form, protocol=protocol, protocoltype=protocoltype)

@app.route("/todo/edit/<int:todo_id>", methods=["GET", "POST"])
@login_required
Robin Sonnabend's avatar
Robin Sonnabend committed
898
@db_lookup(Todo)
Robin Sonnabend's avatar
Robin Sonnabend committed
899
@require_modify_right()
Robin Sonnabend's avatar
Robin Sonnabend committed
900
def edit_todo(todo):