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