def see_history():
sql_connection = dbconnection.get_db_connection()
payments = payment_repository.get_payments_by_order_id(sql_connection,
txt_order_id.get())
try:
order_details = order_repository.get_order_details_by_order_id(
sql_connection,
txt_order_id.get())
except OrderDetailsFoundException as ex:
tkMessageBox.showinfo("Error", ex.message)
return
total_order = order_utils.get_total_order(order_details)
txt_query.delete(1.0, Tkinter.END)
count = 0
for payment in payments:
count += 1
readable_date = datetime.datetime.fromtimestamp(int(payment.date)).\
strftime('%Y-%m-%d')
payment_str = "payment %d - date:%s - amount:%d" % \
(count, readable_date, payment.amount)
txt_query.insert(Tkinter.INSERT, payment_str)
txt_query.insert(Tkinter.INSERT, "\n-------------------------------\n")
total_payments = sum([payment.amount for payment in payments])
debt = total_order - total_payments
txt_query.insert(Tkinter.INSERT, "****Total payments up date: %d \n" %
total_payments)
txt_query.insert(Tkinter.INSERT, "****Total order price: %d \n" % total_order)
txt_query.insert(Tkinter.INSERT, "****Debt up date: %d \n" % debt)
if debt is 0:
txt_query.insert(Tkinter.INSERT, "****Congratulations, order Ok! :)\n")
sql_connection.close()
def see_history():
sql_connection = dbconnection.get_db_connection()
payments = payment_repository.get_payments_by_order_id(
sql_connection, txt_order_id.get())
try:
order_details = order_repository.get_order_details_by_order_id(
sql_connection, txt_order_id.get())
except OrderDetailsFoundException as ex:
tkMessageBox.showinfo("Error", ex.message)
return
total_order = order_utils.get_total_order(order_details)
txt_query.delete(1.0, Tkinter.END)
count = 0
for payment in payments:
count += 1
readable_date = datetime.datetime.fromtimestamp(int(payment.date)).\
strftime('%Y-%m-%d')
payment_str = "payment %d - date:%s - amount:%d" % \
(count, readable_date, payment.amount)
txt_query.insert(Tkinter.INSERT, payment_str)
txt_query.insert(Tkinter.INSERT,
"\n-------------------------------\n")
total_payments = sum([payment.amount for payment in payments])
debt = total_order - total_payments
txt_query.insert(Tkinter.INSERT,
"****Total payments up date: %d \n" % total_payments)
txt_query.insert(Tkinter.INSERT,
"****Total order price: %d \n" % total_order)
txt_query.insert(Tkinter.INSERT, "****Debt up date: %d \n" % debt)
if debt is 0:
txt_query.insert(Tkinter.INSERT,
"****Congratulations, order Ok! :)\n")
sql_connection.close()
def _validate_payment_before_save(sql_connection, payment):
order_details = order_repository.get_order_details_by_order_id(sql_connection,
payment.order_id)
payments = payment_repository.get_payments_by_order_id(sql_connection,
payment.order_id)
total_order = order_utils.get_total_order(order_details)
total_payments = _get_total_payments_up_date(payments)
if payment.amount + total_payments > total_order:
debt = total_order - total_payments
raise PaymentExceedsValueDebtException("please check the amount, the debt is:%d"
% debt)
if payment.amount <= 0:
raise InvalidAmountToSave("Amount needs to be bigger than 0")
def _validate_payment_before_save(sql_connection, payment):
order_details = order_repository.get_order_details_by_order_id(
sql_connection, payment.order_id)
payments = payment_repository.get_payments_by_order_id(
sql_connection, payment.order_id)
total_order = order_utils.get_total_order(order_details)
total_payments = _get_total_payments_up_date(payments)
if payment.amount + total_payments > total_order:
debt = total_order - total_payments
raise PaymentExceedsValueDebtException(
"please check the amount, the debt is:%d" % debt)
if payment.amount <= 0:
raise InvalidAmountToSave("Amount needs to be bigger than 0")
