def newTask():
consulta = """
SELECT id, name, apellidos FROM empleados;
"""
empleados = dbQuery(consulta)
mychoices = [(-1, 'Seleccione Empleado')] + [
(e['id'], '{} {}'.format(e['name'], e['apellidos'])) for e in empleados
]
form = TaskForm(request.form)
form.updateChoices(mychoices)
if request.method == 'GET':
return render_template("task.html", form=form)
if form.validate():
title = request.values.get('title')
desc = request.values.get('description')
fx = request.values.get('fx')
id_employee = request.values.get('id_employee')
if id_employee == '-1':
id_employee == None
consulta = """
INSERT INTO tareas (titulo, descripcion, fecha, id_empleado)
VALUES (?, ?, ?, ?);
"""
dbQuery(consulta, title, desc, fx, id_employee)
return redirect(url_for("index"))
else:
return render_template("task.html", form=form)
