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")