def reportbypriceinventory():
if session['logged_in'] and request.method == 'POST':
report=Report(True)
if session['usuario_completo']['codigosucursal']:
results= report.priceandquantity()
return jsonify(results=json.loads(json.dumps(results,default=json_serial)))
else:
return render_template('index.html')
def reportbymonth():
if session['logged_in'] and request.method == 'POST':
report=Report(True)
if session['usuario_completo']['codigosucursal']:
results = report.salesbymonthtomonth( date.today().year ,str (session['usuario_completo']['codigosucursal']));
results += report.salesbymonthtomonth( date.today().year -1 ,str (session['usuario_completo']['codigosucursal']));
results += report.salesbymonthtomonth( date.today().year -2 ,str (session['usuario_completo']['codigosucursal']));
results = [results[0] and results[2] and results[4],{date.today().year:results[1],date.today().year -1:results[3],date.today().year -2:results[5]}]
return jsonify(results=json.loads(json.dumps(results,default=json_serial)))
else:
return render_template('index.html')
def reportbysubs():
if session['logged_in'] and request.method == 'POST':
report=Report(True)
if session['usuario_completo']['codigosucursal']:
results=report.clientebysub()
results+=report.userbysub()
results+=report.inventorybysub()
results+=report.salesbysub()
results = [results[0] and results[2] and results[4] and results[6],{"ventas":results[7],"inventario":results[5],"personal":results[3],"cliente":results[1]}]
return jsonify(results=json.loads(json.dumps(results,default=json_serial)))
else:
return render_template('index.html')
