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"
