291F19-GroupProject1/ProcessPayment.py at master · JohnYujj/291F19-GroupProject1 · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
import tkinter
from tkinter import *
import SQLControlClass
import RegistryAgentApp
import ErrorWindowPopup
import datetime
from datetime import datetime
import random

class ProcessPaymentApp(tkinter.Tk):
    #should pass the uid when creating registryAgentApp to determine who is currently logged in
    def __init__(self, dbPath, uid):
        tkinter.Tk.__init__(self)
        self.title("Process Payment")
        self.currentUser = uid
        self.database = dbPath
        self.SQLController = SQLControlClass.SQLController(self.database)

        # |ticket no.|ticket input box |
        # |payment   |payment input box|
        # |cancel button|ok button       |

        self.lbltno = Label(self, text="Ticket Number: ", height = 1, width = 15)
        self.lbltno.grid(sticky="W", row = 1, column = 1)
        self.lblamt = Label(self, text="Payment Amount: ", height = 1, width = 15)
        self.lblamt.grid(sticky="W", row = 2, column = 1)

        self.enttno = Entry(self, width = 20)
        self.enttno.grid(sticky="W", row = 1, column = 2)
        self.entamt = Entry(self, width = 20)
        self.entamt.grid(sticky="W", row = 2, column = 2)

        self.btnCancel = Button(self, text ="Cancel", command=self.CancelClick)
        self.btnCancel.grid(row = 3, column = 1)
        self.btnOk = Button(self, text ="Ok", command=self.OkClick)
        self.btnOk.grid(row = 3, column = 2)

    def OkClick(self):
        #TODO: handle empty inputs
        #from user entry
        tno = self.enttno.get()
        if len(tno) == 0:
            winErr = ErrorWindowPopup.ErrorWindowPopup("Error: Ticket Number must not be Empty")
            winErr.mainloop()
            return
        amount = self.entamt.get()
        if (len(amount) == 0) or not amount.isdigit():

            winErr = ErrorWindowPopup.ErrorWindowPopup("Error: Payment Amount must be a digit")
            winErr.mainloop()
            return
        amount = int(amount)
        #todays date
        pdate = datetime.date(datetime.now())

        #get ticket fine and all payments
        fine = self.SQLController.GetTicketFine(tno)
        if fine is None:
            winErr = ErrorWindowPopup.ErrorWindowPopup("Error: Fine not Found. Verify ticket number.")
            winErr.mainloop()
            return
        fine = int(fine[0])
        payments = self.SQLController.GetAllPayments(tno)
        previousPayments = 0
        for payment in payments:
            previousPayments += payment[0]
        balanceAfterPayment = fine - previousPayments - amount
        maxPayment = fine - previousPayments

        #if all payments + current payment > fine, show invalid msg and return no action
        if balanceAfterPayment < 0:
            msg = "Error: Total Payments Exceed Fine. Max Payment is %d." %(maxPayment)
            winErr = ErrorWindowPopup.ErrorWindowPopup(msg)
            return

        #otherwise, process payment
        error = self.SQLController.ProcessPayment(tno,pdate,amount)
        if error:
            winErr = ErrorWindowPopup.ErrorWindowPopup("Error: SQL Error in Process Payment. Please check your Ticket Number. Ticket Number and Date are the Unique ID (Maximum 1 payment per ticket per day).")
            winErr.mainloop()
        else:
            self.SQLController.CommitAndClose()
            self.destroy()
            msg = "Payment Success. Remaining Balance %d." %(balanceAfterPayment)
            winErr = ErrorWindowPopup.ErrorWindowPopup(msg)
            winErr.mainloop()
            winReg = RegistryAgentApp.RegistryAgentApp(self.database,self.currentUser)
            winReg.mainloop()

    def CancelClick(self):
        self.SQLController.CommitAndClose()
        self.destroy()
        winReg = RegistryAgentApp.RegistryAgentApp(self.database,self.currentUser)
        winReg.mainloop()