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 OnNewDivision(self, evt):
dlg = wx.TextEntryDialog(self, 'Division Name', 'New Division Name', '')
if dlg.ShowModal() == wx.ID_OK:
new_name = dlg.GetValue().strip()
if new_name:
sql = "SELECT Nama FROM Divisi WHERE Nama = '%s'" % new_name
if fetch.getCount(sql):
msg = "Sorry division '%s' already exists" % new_name
fetch.msg(msg)
else:
next_id = fetch.nextID('Divisi')
sql = "INSERT INTO Divisi (Kode, Nama) VALUES (%d, '%s')" % (next_id, new_name)
#rintsql
fetch.updateDB(sql)
self.loadDivisions()
loadCmb.restore_str(self.choice_division, new_name)
dlg.Destroy()
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))
