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)