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