def create_transaction():
tag = tag_repository.select(request.form["tag_id"])
merchant = merchant_repository.select(request.form["merchant_id"])
amount = request.form["amount"]
new_transaction = Transaction(tag, merchant, amount)
transaction_repository.save(new_transaction)
return redirect("/transactions")
def select(id):
sql = "SELECT * FROM transactions WHERE id = %s"
values = [id]
result = run_sql(sql, values)[0]
merchant = merchant_repository.select(result["merchant_id"])
tag = tag_repository.select(result["tag_id"])
transaction = Transaction(merchant, result["date"], result["amount"], tag, result["id"])
return transaction
def show_tag(id):
tag = tag_repository.select(id)
transactions = tag_repository.transactions(id)
total_amounts = tag_repository.amounts_total(id)
return render_template("tags/show.html",
tag=tag,
transactions=transactions,
total_amounts=total_amounts)
def select(id):
sql = "SELECT * FROM transactions WHERE id=%s"
values = [id]
result = run_sql(sql, values)[0]
company = company_repository.select(result["company_id"])
tag = tag_repository.select(result["tag_id"])
transaction = Transaction(result["amount"], company, tag, result["id"])
return transaction
def select(id):
sql = "SELECT * FROM transactions WHERE id = %s"
values = [id]
result = run_sql(sql, values)[0]
tag = tag_repository.select(result['tag_id'])
merchant = merchant_repository.select(result['merchant_id'])
user = user_repository.select(result['user_id'])
transaction = Transaction(tag, merchant, user, result['amount'], result['date'], result['id'])
return transaction
def create_transaction():
amount = request.form["amount"]
merchant_id = request.form["merchant_id"]
tag_id = request.form["tag_id"]
merchant = merchant_repository.select(merchant_id)
tag = tag_repository.select(tag_id)
new_transaction = Transaction(amount, merchant, tag)
transaction_repository.save(new_transaction)
return redirect("/transactions")
def create_transaction():
amount = request.form["amount"]
company_id = request.form["company_id"]
tag_id = request.form["tag_id"]
company = company_repository.select(company_id)
tag = tag_repository.select(tag_id)
new_transaction = Transaction(amount, company, tag)
transaction_repository.save(new_transaction)
return redirect("/")
def create_transaction():
merchant_id = request.form['merchant_id']
tag_id = request.form['tag_id']
amount = request.form['amount']
merchant = merchant_repository.select(merchant_id)
tag = tag_repository.select(tag_id)
transaction = Transaction(merchant, tag, amount)
transaction_repository.save(transaction)
return redirect('/transactions')
def select_all():
transactions = []
sql = "SELECT * FROM transactions ORDER BY date DESC"
results = run_sql(sql)
for row in results:
merchant = merchant_repository.select(row["merchant_id"])
tag = tag_repository.select(row["tag_id"])
transaction = Transaction(merchant, row["date"], row["amount"], tag, row["id"])
transactions.append(transaction)
return transactions
def select_all():
transactions = []
sql = "SELECT * FROM transactions"
results = run_sql(sql)
for result in results:
company = company_repository.select(result["company_id"])
tag = tag_repository.select(result["tag_id"])
transaction = Transaction(result["amount"], company, tag, result["id"])
transactions.append(transaction)
return transactions
def create_transaction():
merchant_id = request.form["merchant_id"]
merchant = merchant_repository.select(merchant_id)
date = request.form["date"]
amount = float(request.form["amount"])
tag_id = request.form["tag_id"]
tag = tag_repository.select(tag_id)
new_transaction = Transaction(merchant, date, amount, tag)
transaction_repository.save(new_transaction)
return redirect("/transactions")
def update_transaction(id):
merchant_id = request.form["merchant_id"]
merchant = merchant_repository.select(merchant_id)
date = request.form["date"]
amount = request.form["amount"]
tag_id = request.form["tag_id"]
tag = tag_repository.select(tag_id)
transaction = Transaction(merchant, date, amount, tag, id)
transaction_repository.update(transaction)
return redirect("/transactions")
def sort_all_by_tag_z2a():
transactions = []
sql = "select t.* from transactions as t join tags as tg on tg.id = t.tag_id order by tg.name DESC"
results = run_sql(sql)
for row in results:
merchant = merchant_repository.select(row["merchant_id"])
tag = tag_repository.select(row["tag_id"])
transaction = Transaction(merchant, row["date"], row["amount"], tag, row["id"])
transactions.append(transaction)
return transactions
def sort_all_by_merchant_a2z():
transactions = []
sql = "select t.* from transactions as t join merchants as m on m.id = t.merchant_id order by m.name ASC"
results = run_sql(sql)
for row in results:
merchant = merchant_repository.select(row["merchant_id"])
tag = tag_repository.select(row["tag_id"])
transaction = Transaction(merchant, row["date"], row["amount"], tag, row["id"])
transactions.append(transaction)
return transactions
def select_all():
transactions = []
sql = "SELECT * FROM transactions"
results = run_sql(sql)
for row in results:
tag = tag_repository.select(row['tag_id'])
merchant = merchant_repository.select(row['merchant_id'])
user = user_repository.select(row['user_id'])
transaction = Transaction(tag, merchant, user, row['amount'], row['date'], row['id'])
transactions.append(transaction)
return transactions
def edit(id):
tag = tag_repository.select(id)
transactions = transaction_repository.select_all()
total = 0
for transaction in transactions:
if transaction.tag.id == tag.id:
total += transaction.amount
return render_template("tags/edit.html",
tag=tag,
transactions=transactions,
total=total)
def log_new_transaction():
merchant_id = request.form['merchant-name']
tag_id = request.form['tag-category']
amount = request.form['amount']
merchant = merchant_repository.select(merchant_id)
tag = tag_repository.select(tag_id)
transaction = Transaction(merchant, tag, amount)
transaction_repository.save(transaction)
return redirect("/transactions")
def select(id):
transaction = None
sql = "SELECT * FROM transactions WHERE id = %s"
values = [id]
result = run_sql(sql, values)
if result is not None:
merchant = merchant_repository.select(result['merchant_id'])
tag = tag_repository.select(result['tag_id'])
transaction = Transaction(merchant, tag, result['amount'], result['id'], result['time_stamp'])
return transaction
def tag_transactions():
tag_id = request.form["tag_id"]
tag = tag_repository.select(tag_id)
transactions = transaction_repository.select_by_tag(tag_id)
total_amount = 0.00
for transaction in transactions:
total_amount += float(transaction.amount)
return render_template("transactions/tag_index.html",
transactions=transactions,
tag=tag,
total_amount=format(total_amount, '.2f'),
title="Tag Transactions")
def update_transaction(id):
tag_id = request.form['tag_id']
merchant_id = request.form['merchant_id']
user_id = request.form['user_id']
amount = request.form['amount']
date = request.form['date']
tag = tag_repository.select(tag_id)
merchant = merchant_repository.select(merchant_id)
user = user_repository.select(user_id)
updated_transaction = Transaction(tag, merchant, user, amount, date, id)
transaction_repository.update(updated_transaction)
return redirect("/transactions")
def select_all():
transactions = []
sql = "SELECT * FROM transactions"
results = run_sql(sql)
for result in results:
merchant = merchant_repository.select(result["merchant_id"])
tag = tag_repository.select(result["tag_id"])
transaction = Transaction(merchant, tag, result['amount'], result["id"])
transactions.append(transaction)
return transactions
def select_all():
transactions = []
sql = "SELECT * FROM transactions"
results = run_sql(sql)
for row in results:
merchant = merchant_repository.select(row['merchant_id'])
tag = tag_repository.select(row['tag_id'])
transaction = Transaction(merchant, tag, row['amount'], row['id'], row['time_stamp'])
transactions.append(transaction)
return transactions
def transactions(id):
transactions = []
sql = "SELECT * FROM transactions WHERE merchant_id = %s ORDER BY date DESC"
values = [id]
results = run_sql(sql, values)
for row in results:
merchant = select(row["merchant_id"])
tag = tag_repository.select(row["tag_id"])
transaction = Transaction(merchant, row["date"], row["amount"], tag,
row["id"])
transactions.append(transaction)
return transactions
def create_transaction():
amount = request.form["amount"]
user = user_repository.select(request.form["user"])
merchant = merchant_repository.select(request.form["merchant"])
tag = tag_repository.select(request.form["tag"])
new_transaction = Transaction(amount, user, merchant, tag)
transaction_repository.save(new_transaction)
tags = tag_repository.select_all()
transactions = user_repository.select_transactions(user)
total = 0
for transaction in transactions:
total += transaction.amount
return render_template("/users/dashboard.html", user = user, transactions = transactions, total = total, tags = tags)
def select_all():
transactions = []
sql = "SELECT * FROM transactions"
results = run_sql(sql)
for result in results:
amount = float(result["amount"])
merchant = merchant_repository.select(result["merchant_id"])
tag = tag_repository.select(result["tag_id"])
transaction = Transaction(amount, merchant, tag, result["id"],
result["time_created"])
transactions.append(transaction)
transactions.reverse()
return transactions
def select_all():
transactions = []
sql = "SELECT * FROM transactions"
results = run_sql(sql)
for result in results:
user = user_repository.select(result["user_id"])
merchant = merchant_repository.select(result["merchant_id"])
tag = tag_repository.select(result["tag_id"])
transaction = Transaction(user, result["date"], result["time"],
merchant, result["amount"], tag,
result["id"])
transactions.append(transaction)
return transactions
def update_transaction(id):
transaction = transaction_repository.select(id)
user = user_repository.select(transaction.user.id)
amount = request.form['amount']
merchant = merchant_repository.select(request.form['merchant'])
tag = tag_repository.select(request.form['tag'])
updated_transaction = Transaction(amount, user, merchant, tag, transaction.id)
transaction_repository.update(updated_transaction)
transactions = user_repository.select_transactions(user)
tags = tag_repository.select_all()
total = 0
for transaction in transactions:
total += transaction.amount
return render_template("/users/dashboard.html", user = user, transactions = transactions, total = total, tags = tags)
def select_transactions(user):
transactions = []
sql = "SELECT T.id, T.amount, T.tag_id, T.merchant_id, T.user_id, TA.name, M.name FROM transactions as T LEFT JOIN tags as TA on T.tag_id = TA.id LEFT JOIN merchants as M on T.merchant_id = M.id WHERE T.user_id = %s;"
values = [user.id]
results = run_sql(sql, values)
for row in results:
merchant = Merchant(row['name'], row['merchant_id'])
tag = tag_repository.select(row['tag_id'])
user = user_repository.select(row['user_id'])
transaction = Transaction(row['amount'], user, merchant, tag, row['id'])
transactions.append(transaction)
return transactions
def select_by_tag(id):
transactions = []
sql = "SELECT * FROM transactions where tag_id = %s"
values = [id]
results = run_sql(sql, values)
for result in results:
user = user_repository.select(result["user_id"])
merchant = merchant_repository.select(result["merchant_id"])
tag = tag_repository.select(result["tag_id"])
transaction = Transaction(user, result["date"], result["time"],
merchant, result["amount"], tag,
result["id"])
transactions.append(transaction)
return transactions
def create_transaction():
user_id = request.form["user_id"]
date = request.form["date"]
time = request.form["time"]
merchant_id = request.form["merchant_id"]
amount = float(request.form["amount"])
tag_id = request.form["tag_id"]
user = user_repository.select(user_id)
merchant = merchant_repository.select(merchant_id)
tag = tag_repository.select(tag_id)
if user.can_afford(amount) == True:
transaction = Transaction(user, date, time, merchant, amount, tag)
transaction_repository.save(transaction)
return redirect("/transactions")
else:
error = "I'm sorry, this transaction will put you over your budget."
return render_template("/transactions/error.html",
error=error,
title="Error")
