def get_valor_por_venda(id):
conn = conex()
cursor = conn.cursor()
cursor.execute(f"select Total from invoices where InvoiceId={id}")
records = cursor.fetchall()
lista = [dict(zip(cursor.column_names, x)) for x in records]
conn.close()
return jsonify(lista)
def get_anos():
conn = conex()
cursor = conn.cursor()
cursor.execute("select DISTINCT YEAR (InvoiceDate) as Ano from invoices")
records = cursor.fetchall()
lista = [dict(zip(cursor.column_names, x)) for x in records]
conn.close()
return jsonify(lista)
def get_vendas_por_ano(ano):
conn = conex()
cursor = conn.cursor()
cursor.execute(
f"select InvoiceId from invoices WHERE YEAR(InvoiceDate)='{ano}'")
records = cursor.fetchall()
lista = [dict(zip(cursor.column_names, x)) for x in records]
conn.close()
return jsonify(lista)