def __init__(self, student, term, parent=None):
super(TermPayDialog, self).__init__(parent)
#term data
self.term = term
terms = self.pullOnes('terms', self.term)
session = self.pullOnes('session', terms['sessionID'])
self.termname = str(
session['name']) + ' ' + terms['name'] + ' Term Report'
self.pagetitle = self.termname
#student data
self.student = student
st = self.pullStudent(self.student)
fullname = str(st['surname'] + ' ' + st['firstname'] + ' ' +
st['othername']).title()
schno = st['schno']
db_class = 'student_class' + str(self.term)
student_clasz = self.pullOne(db_class, {'studentID': self.student})
clasz = self.pullOne('datas', {'id': student_clasz['classID']})
self.clasz = clasz['subID']
armz = self.pullOne('datas', {'id': clasz['subID']})
classname = armz['abbrv'] + ' ' + clasz['abbrv']
#pull all CA
fullNameText = QLabel(fullname)
schnoText = QLabel(schno)
classText = QLabel(classname)
topLay = QGridLayout()
topLay.addWidget(fullNameText, 0, 0)
topLay.addWidget(schnoText, 1, 0)
topLay.addWidget(classText, 2, 0)
groupBox = QGroupBox('Current Payment')
groupBox.setLayout(topLay)
payAmountText = QLabel('Amount')
self.payBalanceText = QLabel('Balance')
self.payBalanceAmount = QLabel('0.0')
self.payAmount = QLineEdit()
self.payAmount.setObjectName("pay")
self.payAmount.setPlaceholderText("000.00")
payText = QLabel('Select Account')
self.payMethod = QComboBox()
accounts = self.pullAccount()
self.holdaccount = {}
i = 0
for h in accounts:
tex = str(h['name']).upper()
self.payMethod.addItem(tex)
self.holdaccount[i] = h['id']
payDateText = QLabel('Balance')
self.payDate = QDateEdit()
self.payDate.setDateTime(QDateTime.currentDateTime())
self.payDate.setCalendarPopup(True)
tellerText = QLabel('Teller/Receipt No.')
self.teller = QLineEdit()
self.teller.setObjectName("teller")
self.teller.textChanged.connect(self.pullTeller)
self.teller.setPlaceholderText("0000000")
self.hw = QGridLayout()
self.hw.addWidget(payAmountText, 0, 0)
self.hw.addWidget(self.payAmount, 0, 1)
self.hw.addWidget(tellerText, 0, 2)
self.hw.addWidget(self.teller, 0, 3)
self.hw.addWidget(payText, 1, 0)
self.hw.addWidget(self.payMethod, 1, 1)
self.hw.addWidget(payDateText, 1, 2)
self.hw.addWidget(self.payDate, 1, 3)
head_col1 = QLabel('ITEM')
head_col2 = QLabel('AMOUNT')
head_col3 = QLabel('FULL PAY')
head_col4 = QLabel('PART PAY')
head_col5 = QLabel('BALANCE')
layout1 = QGridLayout()
layout1.addWidget(head_col1, 0, 0)
layout1.addWidget(head_col2, 0, 1)
layout1.addWidget(head_col3, 0, 2)
layout1.addWidget(head_col4, 0, 3)
layout1.addWidget(head_col5, 0, 4)
arr = self.pullFees()
feex = arr[1]
payx = arr[2]
normal_pay = []
full_pay = []
part_pay = []
bal_pay = []
ko = 1
self.holdval = []
self.holdfee = {}
self.holdtextfee = {}
self.holdtextfeeperm = {}
self.holdpaid = {}
self.holdcpaid = {}
self.holdtextpaid = {}
self.holdpayments = {}
self.holdtextbal = {}
self.holdbal = {}
for val in arr[0]:
paid = False
s_normal_pay = []
s_full_pay = []
s_part_pay = []
self.holdval.append(val)
mz = self.pullOne('datas', {'id': val})
self.num = val
self.d = QLabel('Text')
self.d.setText(str(mz['name']).upper())
self.d1 = QLabel()
if val in feex:
fk = feex[int(val)].values()
normal_pay.append(float(fk[0]))
s_normal_pay.append(float(fk[0]))
self.d1.setText(str("{:,}".format(float(fk[0]))).upper())
else:
self.d1.setText(str('-.-').upper())
nHbo1 = QVBoxLayout()
if val in feex:
fk = feex[int(val)].values()
fky = feex[int(val)].keys()
self.c = QCheckBox('cb' + str(val))
self.c.setEnabled(False)
self.c.setText(str("{:,}".format(float(fk[0]))).upper())
self.c.setObjectName("chk" + str(val))
self.holdfee[int(val)] = self.c
self.holdtextfee[int(val)] = fk[0]
self.holdtextfeeperm[int(val)] = fk[0]
self.c.toggled.connect(lambda state, x=fky[0], fee=int(
val), money=fk[0]: self.chkFunc(x, fee, money, self.c))
if (val in payx) and len(payx[int(val)]) == 1:
pk = payx[int(val)].values()
self.c.setChecked(True)
if float(pk[0]) == float(fk[0]):
full_pay.append(float(fk[0]))
s_full_pay.append(float(fk[0]))
paid = True
else:
self.c.setChecked(False)
nHbo1.addWidget(self.c)
else:
nHbo1.addWidget(QLabel('-.-'))
#nHbo1.hide()
nHbo2 = QHBoxLayout()
fk = feex[int(val)].values()
fky = feex[int(val)].keys()
c2 = QCheckBox()
c2.setEnabled(False)
c2.setMaximumWidth(15)
c2.setObjectName("chk2" + str(val))
p = QLineEdit()
p.setDisabled(True)
p.setMaximumWidth(50)
p.setFixedWidth(51)
p.setObjectName("pay" + str(val))
p.setPlaceholderText("00.0")
self.holdpaid[int(val)] = p
self.holdcpaid[int(val)] = c2
self.holdtextpaid[int(val)] = list()
c2.toggled.connect(
lambda state, x=fky[0], fee=int(val): self.chkFunc1(x, fee, p))
if paid == False:
nHbo2.addWidget(c2)
nHbo2.addWidget(p)
if val in payx and len(payx[val]) > 0:
for j in payx[int(val)]:
self.c1 = QCheckBox('cb1' + str(j))
self.c1.setEnabled(False)
self.c1.setText(str(payx[int(val)][j]).upper())
self.c1.setObjectName("chk" + str(j))
self.c1.toggled.connect(
lambda state, x=j: self.chkFunc1(x))
self.c1.setChecked(True)
part_pay.append(float(fk[0]))
s_part_pay.append(float(fk[0]))
self.holdpayments[j] = self.c1
self.holdtextpaid[val].append(float(fk[0]))
nHbo2.addWidget(self.c1)
else:
pass
else:
p.hide()
c2.hide()
nHbo2.addWidget(c2)
nHbo2.addWidget(p)
s_tot = sum(s_normal_pay) - (sum(s_full_pay) + sum(s_part_pay))
bal_pay.append(float(s_tot))
d2 = QLabel('')
self.holdbal[int(val)] = d2
d2.setText(str("{:,}".format(s_tot)).upper())
self.holdtextbal[int(val)] = s_tot
layout1.addWidget(self.d, ko, 0)
layout1.addWidget(self.d1, ko, 1)
layout1.addLayout(nHbo1, ko, 2)
layout1.addLayout(nHbo2, ko, 3)
layout1.addWidget(d2, ko, 4)
ko += 1
normal_payx = sum(normal_pay)
full_payx = sum(full_pay)
part_payx = sum(part_pay)
bal_payx = sum(bal_pay)
self.head_col1 = QLabel('ITEM')
self.head_col2 = QLabel(str("{:,}".format(normal_payx)).upper())
self.head_col3 = QLabel(str("{:,}".format(full_payx)).upper())
self.head_col4 = QLabel(str("{:,}".format(part_payx)).upper())
self.head_col5 = QLabel(str("{:,}".format(bal_payx)).upper())
layout1.addWidget(self.head_col1, ko, 0)
layout1.addWidget(self.head_col2, ko, 1)
layout1.addWidget(self.head_col3, ko, 2)
layout1.addWidget(self.head_col4, ko, 3)
layout1.addWidget(self.head_col5, ko, 4)
self.hw1 = QGridLayout()
self.hw1.addWidget(self.payBalanceText, 0, 0)
self.hw1.addWidget(self.payBalanceAmount, 1, 0)
second1 = QGridLayout()
second1.addLayout(self.hw, 0, 0)
second1.addLayout(layout1, 1, 0)
second1.addLayout(self.hw1, 2, 0)
groupBox1 = QGroupBox('Current Payment')
groupBox1.setLayout(second1)
self.pb = QPushButton()
self.pb.setObjectName("Add")
self.pb.setText("Add Fees")
self.pb1 = QPushButton()
self.pb1.setObjectName("Cancel")
self.pb1.setText("Cancel")
self.pb2 = QPushButton()
self.pb2.setObjectName("Add")
self.pb2.setText("Print Receipts")
hbo = QHBoxLayout()
hbo.addWidget(self.pb1)
hbo.addStretch()
hbo.addWidget(self.pb)
hbo.addStretch()
hbo.addWidget(self.pb2)
groupBox2 = QGroupBox('')
groupBox2.setLayout(hbo)
grid = QGridLayout()
grid.addWidget(groupBox, 0, 0)
grid.addWidget(groupBox1, 1, 0)
grid.addWidget(groupBox2, 2, 0)
self.setLayout(grid)
self.connect(self.pb, SIGNAL("clicked()"), lambda: self.button_click())
self.connect(self.pb1, SIGNAL("clicked()"),
lambda: self.button_close(self))
self.setWindowTitle(self.pagetitle)
