def insertNewStudent(self): name = self.text_ctrl_student_name.GetValue() gender = fetch.cmbID(self.choice_gender) register_course_id = fetch.cmbID(self.choice_joining_course) registration_status = self.choice_status.GetCurrentSelection() sql = "SELECT MAX (student_id) \ FROM students" student_id = fetch.getDig(sql)+1 try: dob = self.date_dob.caldate except: dob = 0 if name and register_course_id and registration_status and dob and gender <2: sql = "INSERT INTO students (student_id, name, dob, schYr, \ registration_status, register_course_id, gender) \ VALUES (%d, '%s', '%s', %d, %d, %d, %d)" % ( student_id, name, dob, gVar.schYr, registration_status, register_course_id, gender) return sql, [] """ sql = "INSERT INTO students (student_id, name, dob, schYr, registration_status, register_course_id, gender) \ VALUES (?, ?, ?, ?, ?, ?, ?)" return sql, (student_id, name, dob, gVar.schYr, registration_status, register_course_id, gender)""" else: fetch.msg('Fields Name, Course, DOB, registration_status & Gender need to be filled') return 'fail', []
def activityNameAvailable(self, activity_name): sql = "SELECT * FROM excul_activities WHERE name = '%s'" % (activity_name,) if fetch.getDig(sql): fetch.ask("Duplicate course name, please try another") return False else: return True
def OnAddYear(self, evt): if not self.new_year: res = fetch.getDig( "SELECT MAX(schYr) FROM schYrs" ) yid = fetch.nextID('schYrs') if res : self.new_year = res + 1 self.choice_schYr.Append(str(self.new_year), yid) loadCmb.restore(self.choice_schYr, yid) else: fetch.msg('A new year has already been added. Save First')
def schoolNameAvailable(self, school_name): sql = ( "SELECT id FROM schools \ WHERE name = %s " % (school_name) ) if self.editMode: sql += " AND NOT id = %d" % gVar.school_id # rint sql if fetch.getDig(sql): fetch.msg("Duplicate name, please try another") return False else: return True
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()