def displayData(self, student_id, NoInduk, form_id):
#rint'panel_edit_booking_status : displayData'
loadCmb.courses_forYear(self.choice_course, gVar.schYr+1)
self.form_id = form_id
# query for rereg
sql = "SELECT s.id, s.name sbf.rereg_status \
FROM students s \
JOIN students_by_form sbf ON sbf.student_id = s.id \
WHERE s.id = d \
AND sbf.form_id = %d" % (student_id, form_id)
res = fetch.getOneDict(sql)
name = res['name']
self.text_ctrl_name.SetValue(name)
rereg_statusData = res['rereg_status']
if rereg_statusData:
rereg_statusData = rereg_statusData.split(',')
rereg_status = rereg_statusData[0]
if not rereg_status:
rereg_status ='?'
else:
rereg_status = "?"
try:
course_id = rereg_statusData[1]
except:
course_id = 0
try:
refNo = rereg_statusData[2]
except:
refNo = ''
self.showHideCourses(rereg_status =='continue')# or rereg_status =='retake')
if rereg_status =='?':
self.choice_status.Select(0) # ?
else:
if rereg_status == "exit":
self.choice_status.Select(3)
elif rereg_status == "retake":
self.choice_status.Select(2)
#loadCmb.restore(self.choice_course, course_id)
elif rereg_status == "continue":
#rint"rereg_status == continue"
self.choice_status.Select(1)
loadCmb.restore(self.choice_course, course_id)
self.text_ctrl_refNo.SetValue('')
self.Layout()
def displayData(self, student_id, NoInduk, KKelas):
#rint"panel_edit_rereg_status : displayData"
# query for bookings
#sql = "SELECT Kode, Nama, Status FROM CSiswa WHERE Kode%d" % student_id
loadCmb.courses_forYear(self.choice_course, gVar.schYr+1)
self.KKelas = KKelas
self.NoInduk = NoInduk
# query for rereg
sql = "SELECT s.id, s.NoInduk, s.name, sbf.rereg_status, sbf.next_course_id \
FROM students_by_form \
JOIN students ON sbf.student_id = Siswa.id \
WHERE sbf.student_id = '%s' \
AND f.id = %d" % (student_id, form_id)
res = fetch.getOneDict(sql)
self.next_level = fetch.form_level(KKelas)+1
#rintsql, res
if res:
name = res['Nama']
self.text_ctrl_name.SetValue(name)
rereg_status = res['ReregStatus']
course_id = res['NextCourseID']
if rereg_status =='?':
self.choice_status.Select(0) # ?
elif rereg_status == "continue":
#rint "continue"
loadCmb.courses_forLevel_forYear(self.choice_course, gVar.schYr+1, self.next_level)
loadCmb.restore(self.choice_course, course_id)
elif rereg_status == "retake":
self.choice_status.Select(2)
elif rereg_status == "exit":
self.choice_status.Select(3)
self.showHideCourses(rereg_status =='continue' or rereg_status =='retake')
self.text_ctrl_refNo.SetValue('')
self.Layout()
def displayData(self):
self.student_id = student_id = gVar.student_id
#return
#rint"panel_edit_booking : displayData"
self.clearCtrls()
if student_id == 0:
self.enableCtrls(True)
self.button_edit.SetLabelText('Cancel')
sql = "SELECT MAX (id) FROM students"
student_id = fetch.getDig(sql)+1
self.label_ctrl_booking_id.SetLabelText(str(student_id))
else:
self.button_save.Hide()
self.button_edit.SetLabelText('Edit')
self.enableCtrls(False)
loadCmb.courses_forYear(self.choice_joining_course, gVar.schYr)
self.text_ctrl_student_name.Enable(student_id == 0)
if student_id:
sql = "SELECT * FROM students WHERE student_id = %d" % int(student_id)
res = fetch.getOneDict(sql)
name = res['name']
student_id = res['student_id']
gender = res['gender']
register_course_id = res['register_course_id']
registration_status = res['reg_status']
dob = res['dob']
schYr = res['register_schYr']
self.label_heading.SetLabelText('Editing Booking For:')
self.label_ctrl_booking_id.SetLabelText(str(student_id))
self.text_ctrl_student_name.SetValue(name)
if gender:
self.choice_gender.SetSelection(0)
else:
self.choice_gender.SetSelection(1)
self.date_dob.SetValue(dob)
course_id = res['register_course_id']
loadCmb.restore(self.choice_joining_course, course_id)
#KSekolahPindah = res['KSekolahPindah']
#loadCmb.restore(self.choice_previous_school, KSekolahPindah)
#if not registration_status: registration_status = 0
loadCmb.restore(self.choice_status, registration_status)
sql = "SELECT * \
FROM acc_invoices i \
JOIN acc_invoice_items ii ON ii.invoice_id = i.id \
WHERE i.student_id = %d ORDER BY (ck_ref)" % gVar.student_id
res = fetch.getAllDict(sql)
mystr =""
for r in res:
k = r.pop('student_id')
ck_ref = r.pop('ck_ref')
mystr += '%s : %s \n' % ('ck_ref', ck_ref)
date = r.pop('Tanggal')
mystr += '%s : %s \n' % ('Date', date)
for key in r:
val = r[key]
if val:
l = '%s : %s \n' % (key, r[key])
mystr += l
mystr += "\n"
self.text_ctrl_notes.SetValue(mystr)
"""
self.date_booking_fee = DateCtrl(self.panel_booking, -1)
self.text_ctrl_booking_receiptNo = wx.TextCtrl(self.panel_booking, -1, "")
self.date_test = DateCtrl(self.panel_booking, -1)
self.choice_result_test = wx.Choice(self.panel_booking, -1, choices=["A: Strong", "B: Good", "C: Medium", "D:Weak", "E:Very Weak"])
self.date_retest = DateCtrl(self.panel_booking, -1)
self.choice_result_retest = wx.Choice(self.panel_booking, -1, choices=["Acceptable", "Not Acceptable"])
self.date_offer_letter_sent = DateCtrl(self.panel_booking, -1)
self.text_ctrl_offer_ref = wx.TextCtrl(self.panel_booking, -1, "")
self.date_offer_accepted = DateCtrl(self.panel_booking, -1)
self.text_ctrl_accept_receiptNo = wx.TextCtrl(self.panel_booking, -1, "")
self.text_ctrl_notes = wx.TextCtrl(self.panel_notes, -1, "", style=wx.TE_MULTILINE)"""
else:
self.enableCtrls()
