def listaClientesMes():
if 'fecha' in request.form:
fecha = request.form['fecha']
mes = request.form['mes']
anio = request.form['anio']
umbral = request.form['minimo']
intervalo = request.form['intervalo']
use_prepare = 'prepare' in request.form
break0 = 'break0' in request.form
niter = request.form['iter']
# connect fuera para comparar tiempos con más precisión
db_conn = database.dbConnect()
t0=round(time.time() * 1000)
dbr = database.getListaCliMes(db_conn, mes, anio, int(umbral), int(intervalo), use_prepare, break0, int(niter))
t1=round(time.time() * 1000)
database.dbCloseConnect(db_conn)
return render_template('listaClientesMes.html',
fecha = fecha,
mes = mes,
anio = anio,
umbral = int(umbral),
intervalo = int(intervalo),
use_prepare = use_prepare,
break0 = break0,
tiempo = str(int(t1-t0)),
dbr=dbr
)
else:
return render_template('listaClientesMes.html')
def index(methods = ['POST', 'GET']):
if request.method == 'GET':
return render_template('index.html')
if request.method == 'POST':
mes = request.form.get('mes')
anio = request.form.get('anio')
iumbral = request.form.get('iumbral')
iintervalo = request.form.get('iintervalo')
use_prepare = request.form.get('use_repare')
break0 = request.form.get('break0')
niter = request.form.get('niter')
results = db.getListaCliMes(int(mes), int(anio), int(iumbral), int(iintervalo), int(use_prepare), int(break0), int(niter))
print(results)
return render_template('lista.html', results=results)