def project(id = 0): data = Columns.query.filter_by(project_id = id).order_by(Columns.id).all() card = {} for d in data: c = Cards.query.filter_by(column_id = d.id).order_by(Cards.id).all() card[d.id] = c form = AddColumnForm(prefix="form") formCard = AddCardForm(prefix="formCard") formUpdate = UpdateColumnForm(prefix="formUpdate") formUpdateCard = UpdateCardForm(prefix="formUpdateCard") if form.validate_on_submit() and form.submit.data: a.createColumn(session['author_id'], session['session_id'], id, form.name.data, form.description.data) if formCard.validate_on_submit() and formCard.submit.data: a.createCard(session['author_id'], session['session_id'], id, formCard.name.data, formCard.description.data, int(formCard.idColumn.data)) if formUpdate.validate_on_submit() and formUpdate.submit.data: c = Columns.query.filter_by(id = int(formUpdate.idColumn.data)).all() c = c[0] a.modifyColumn(session['author_id'], session['session_id'], int(formUpdate.idColumn.data), c.project_id, formUpdate.name.data, formUpdate.description.data) if formUpdateCard.validate_on_submit() and formUpdateCard.submit.data: c = Cards.query.filter_by(id = int(formUpdateCard.idCard.data)).all() c = c[0] a.modifyCard(session['author_id'], session['session_id'], int(formUpdateCard.idCard.data), c.project_id, formUpdateCard.name.data, formUpdateCard.description.data, c.column_id) return render_template('project.html', columns=data, card=card, form=form, formCard = formCard, formUpdate = formUpdate, formUpdateCard = formUpdateCard, id = id)
def modifCard(): c = Cards.query.filter_by(id = int(request.form['idCard'])).all() c = c[0] a.modifyCard(session['author_id'], session['session_id'], int(request.form['idCard']), c.project_id, c.name, c.content, int(request.form['idColumn'])) return "OK"