Example #1
0
    def displayCourseDetails(self):
        res = fetch.course_info(self.course_id) #course_name, course_level, section_name, school_id, code
        #rint'fetch.course_info:', res
        if not res:
            return False
        self.course_name  = res[0]
        self.course_level = res[1]
        self.school_id    = res[2]

        self.origional_name         = '"%s"' % self.course_name
        self.origional_course_level = self.course_level
        self.origional_school_id    = self.school_id

        loadCmb.restore(self.choice_schools, self.school_id)
        loadCmb.courseLevels_forSchool(self.choice_levels, self.school_id)

        txt = "Edit Course %s" % self.course_name
        self.SetTitle(txt)

        self.text_ctrl_course_name.SetValue(self.course_name)

        x = self.choice_levels.GetItems()

        loadCmb.restore_str(self.choice_levels, str(self.course_level) )

        return True
Example #2
0
 def displayData(self, month_from=1):
     self.month_from = month_from
     self.text_ctrl_from.SetValue(self.monthNames[month_from])
     for key in self.monthNames:
         if key > 1: self.choice_to.Append(self.monthNames[key],   key)
         
     loadCmb.restore(self.choice_to, 2)
Example #3
0
    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()
Example #4
0
 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')
Example #5
0
 def setGen(self, selectedItemID, aList, cmb):
     if aList:
         r = aList[0]
         if len(r) != 2:
             fetch.msg('list error')
         
         if len(aList)  > 1: selectedItemID = self.setComboItems(cmb, aList)
         elif len(aList)==1:
             selectedItemID =  aList[0][0]
             loadCmb.restore(cmb, selectedItemID)
         else:               self.clearPostcodeCtrls((cmb,))
     return selectedItemID
Example #6
0
    def displayData(self, guardian_type, guardian_id, student_id):
	if guardian_id:
	    self.editMode = True
	else:
	    if self.student_has_other_guardian(student_id):
		self.editMode = True
	    else:
		self.editMode = False
		
        # #rint'Guardian displayData', guardian_type, guardian_id, student_id
        self.guardian_type = guardian_type
        self.guardian_id   = guardian_id
        self.student_id    = student_id
        
        self.clearCtrls()
  
        if not guardian_id: return
	
	data = self.loadData(guardian_id)
  

	# unpack data (name, address, faith_id, dob, HP, telp, wilayah,
	#	       pob, occupation_main, occupation_other, nationality)
	
	
		
	name, address, faith_id, dob, telp, hp, wilayah, pob, occupation_main_id, occupation_other, nationality_id = data
	    
	self.text_ctrl_name.SetValue(name)
	self.address = address
	self.text_ctrl_address.SetValue(address)
	loadCmb.restore(self.combo_box_faith, faith_id)
	self.date_ctrl_dob.SetValue(dob)
	self.text_ctrl_telp.SetValue(hp)
        self.text_ctrl_hp.SetValue(telp)
	# wilayah
	# pob
        loadCmb.restore(self.combo_occupation_main, occupation_main_id)
        self.text_ctrl_occupation_other.SetValue(str(occupation_other))
	# nationality

        if guardian_type == 'guardian':
	    try:
		relationship = fetch.guardianRelationship(student_id)
                index = self.combo_box_relationship.FindString(relationship)
                self.combo_box_relationship.SetSelection(index)
		self.label_relationship.Show()
		self.combo_box_relationship.Show()
            except:  pass
        else:
            self.label_relationship.Hide()
            self.combo_box_relationship.Hide()
Example #7
0
 def displayDetails(self):
     sql = "SELECT code, code AS code, name FROM acc_accounts"
     DATA = fetch.DATA(sql)
     #rint sql, DATA
     for key in DATA:
         data = DATA[key]
         self.acc_code = str(data[1])
         a, b, c, d = (self.acc_code[:1], self.acc_code[1:3], self.acc_code[3:5], self.acc_code[5:])
         k = '%s.%s.%s.%s' % (a, b, c, d)
         DATA[key] = (data[0], k, data[2])
     
     self.vList.SetItemMap(DATA)
     acc_catagory_id = fetch.acc_catagory_id(self.acc_code)
     loadCmb.restore(self.choice_account_catagory, acc_catagory_id)
Example #8
0
 def setComboItems(self, cmb, itemsList):
     selectedID = fetch.cmbID(cmb)
     cmb.Freeze()
     cmb.Clear()
     for row in itemsList:
         cmb.Append(str(row[1]), row[0])
     cmb.Insert(' ', 0)
     cmb.Thaw()
     
     selectedID = loadCmb.restore(cmb, selectedID)
     if not selectedID:
         if len(itemsList) == 1:
             selectedID = itemsList[0][0]
             loadCmb.restore(cmb, selectedID)
     return selectedID
Example #9
0
    def loadCmbsUnderKecID(self, kecamatanID):
        loadCmb.restore(self.combo_kecamatan, kecamatanID)
        
        selectedKabupatenID = fetch.cmbID(self.combo_kabupaten)
        selectedProvinceID  = fetch.cmbID(self.combo_province)
        # step 1: working down -------------------------------
        
        # do for kabupaten --------------------------------
        kabupatenList       = fetch.kabupatenForKecamatanID(kecamatanID)
        if selectedKabupatenID in self.idList(kabupatenList):
            return

        kabupatenID = self.setGen(selectedKabupatenID, kabupatenList, self.combo_kabupaten)              
        provinceID  = self.provincesForKabupaten(kabupatenID, selectedKabupatenID)
        
        self.countriesForProvince(provinceID, selectedProvinceID)
        
        loadCmb.address_items(self.combo_kelurahan, 'kelurahan', kecamatanID)
Example #10
0
    def OnPostcode(self, evt):
        #rint'OnPostcode'
        if self.numCtrlActive:  return
        
        postcode = self.num_ctrl_postcode.GetValue()
        if postcode:
            for c in self.combos: c.SetSelection(-1)
            sql = "SELECT id, itemName \
                     FROM address_items \
                    WHERE itemType= 'kecamatan' \
		      AND postcode = %d" % postcode
            res = fetch.getOneDict(sql)
            if res:
                iid  = res['id']
                kecamatan = res['itemName']
                loadCmb.restore(self.combo_kecamatan, iid)
                #fetch.msg('postcode')
                self.loadCmbsUnderKecID(iid)
Example #11
0
    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()
Example #12
0
    def displayData(self, jid=0):
        self.jurnal_id = jid
        
        
        self.loadSuppliers()
        self.loadDivisions()
        self.loadAccounts()
        
        if jid:
            self.jurnal_id = jid
            txt = 'Edit Transaction No. %d' % self.jurnal_id
            self.SetTitle(txt)
            
            sql = "SELECT Kode, Tanggal, Transaksi + Keterangan AS description, \
                          NoBuktiKantor, NoBuktiSuplier, KSuplier, KDivisi, PettyCash \
                     FROM Jurnal \
                    WHERE Kode = %d" % self.jurnal_id
            res = fetch.getOneDict(sql)
            #rintsql, res

            
            
            
            self.checkbox_pettycash.SetValue(res['PettyCash'])
            #self.text_ctrl_nobuktikantor.SetValue(res['NoBuktiKantor'])
            self.datepicker_ctrl_1.SetValue(res['Tanggal'])
            self.text_ctrl_tans_descript.SetValue(res['description'])
            self.text_ctrl_supplierrefno.SetValue(res['NoBuktiSuplier'])
            
            loadCmb.restore(self.choice_supplier, res['KSuplier'])
            loadCmb.restore(self.choice_division, res['KDivisi'])
            
            self.listDebitItems()
            self.listCreditItems()
            
        else:
            self.jurnal_id = fetch.nextID('Jurnal')
            
        self.text_ctrl_ckrefno.SetValue(str(self.jurnal_id))    
Example #13
0
 def displaySelected(self):
     #rint'displaySelected : self.acc_code=', self.acc_code
     codeStr = str(self.acc_code)
     a = codeStr[ :1]
     b = codeStr[1:3]
     c = codeStr[3:5]
     d = codeStr[5: ]
     
     self.text_ctrl_acc_code_1.SetValue(a)
     self.text_ctrl_acc_code_2.SetValue(b)
     self.text_ctrl_acc_code_3.SetValue(c)
     self.text_ctrl_acc_code_4.SetValue(d)
     
     name = fetch.acc_name(self.acc_code)
     self.text_ctrl_section_name.SetValue(name)
     
     acc_catagory_id = fetch.acc_catagory_id(self.acc_code)
     loadCmb.restore(self.choice_account_catagory, acc_catagory_id)
     
     bal = fetch.acc_balance(self.acc_code)
     bal = "{:,}".format(bal)
     self.text_ctrl_balance.SetValue(bal)
Example #14
0
    def displayData(self, student_id):
        self.student_details = student_details = fetch.studentDetails_id(student_id)
        if not student_details:
            # rint'not details found'
            return
        else:
            pass
            # rint'student_details : ', student_details

        name = student_details["name"]
        self.text_ctrl_name.SetValue(name)

        dob = student_details["dob"]
        self.datectrl_dob.SetValue(dob)

        faith_id = student_details["faith_id"]
        loadCmb.restore(self.choice_faith, faith_id)

        pob = str(student_details["pob"])
        loadCmb.restore_str(self.choice_pob, pob)

        blood_group_id = str(student_details["blood_type_id"])

        if student_details["gender"]:
            self.choice_gender.SetSelection(1)
        else:
            self.choice_gender.SetSelection(2)

        self.setCmb(self.choice_siblings_by_birth, student_details["siblings_by_birth"])
        self.setCmb(self.choice_siblings_step, student_details["siblings_step"])
        self.setCmb(self.choice_siblings_adopted, student_details["siblings_adopted"])

        if student_details["child_no"]:
            child_no = student_details["child_no"]
        else:
            child_no = 1
        self.choice_birth_order.SetSelection(child_no - 1)
Example #15
0
    def displayData(self, student_id):
        #rintself.GetName(), "make student id open to class   student_id=", student_id
        self.clearCtrls()
        
        self.student_id = student_id
        if not student_id:  return
        
        student_details = fetch.studentDetails_id(student_id)
        #rint student_details
        if not student_details: return
        name = student_details['Nama']
        x  = str(student_details['TgLahir'])
        dob              = x.split(' ')[0]
        
        ailment          = ''#str(student_details['student_ailment'])
        faith_id         = student_details['Agama']
        
        previous_school_id = student_details['KSekolahAsal']
        
        birth_place      = str(student_details['TempatLahir'])
        edu_status       = ''     # ??? is this still needed
        edu_notes        = ''    # ??? seperate quiry on  table "edu_notes"
        #address          = ''#str(student_details['address_line1']) + "\n" + str(student_details['address_line2'])
        #address         += str(student_details['city'])          + "\n" + str(student_details['state'])
        #address         += str(student_details['pin_code'])      + "\n" + str(student_details['country_id'])
        #telephone        = ''# str(student_details['phone1'])        + "\n" + str(student_details['phone2'])
        
        blood_group_id   = str(student_details['GolDarah'])
        blood_group      = ''#fetch.bloodGroup(blood_group_id)
        
        siblings_birth    = student_details['SaudaraKandung']
        siblings_step     = student_details['SaudaraTiri']
        siblings_adopted  = student_details['SaudaraAngkat']
        if not siblings_step: siblings_step=0
        if not siblings_adopted: siblings_adopted =0
        birth_order      = student_details['AnakKe']
        if not birth_order:   birth_order = 1
        
        if student_details['Pria']:
            gender_index = 1
        else:
            gender_index = 2 

        self.text_ctrl_name.SetValue(name)
        
        self.text_ctrl_current_edu_status.SetValue(edu_status)
        self.text_ctrl_edu_notes.SetValue(edu_notes)
        self.text_ctrl_medical_notes.SetValue(ailment)

        #self.text_ctrl_address.SetValue('')
        #self.text_ctrl_telephone.SetValue('') 
        
        if dob: # "should be of format : 2012-06-26"                
            self.date_ctrl_dob.SetValue(dob)
            
        self.spin_sibling_by_birth.SetValue(siblings_birth)
        self.spin_sibling_step.SetValue(siblings_step)
        self.spin_sib_adopted.SetValue(siblings_adopted)
        self.spin_birth_order.SetValue(birth_order)
        
        self.choice_gender.SetSelection(gender_index)
        
        loadCmb.restore(self.choice_faith,  faith_id)
        loadCmb.restore_str(self.choice_pob,  birth_place)
        loadCmb.restore(self.choice_schools,     previous_school_id)
        loadCmb.restore_str(self.choice_status,    edu_status)
        loadCmb.restore_str(self.choice_blood_group, blood_group)
Example #16
0
    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()
Example #17
0
 def restore_id(self, cmb):
     if not loadCmb.restore(self.combo_province, self.restoreID):
         self.combo_province.SetSelection(0)
     self.enableCombos()