def updateData(self):
sql ="SELECT courses FROM courses_by_year WHERE schYr = %s" % 2015
sql ="SELECT course_level, course_name FROM courses ORDER BY course_level, course_name"
results = fetch.getAll_dict(sql)
#rint'courses', results
#for
sql = "SELECT cSiswa.Kode , courses.course_name, cSiswa.Nama , cSiswa.Status \
FROM cSiswa INNER JOIN courses ON cSiswa.Kelas = courses.id \
WHERE cSiswa.TahunAjaran = %s" % gVar.schYr
schoolKode = 0
if gVar.school == "CG": schoolKode = 1
if gVar.school == "SD": schoolKode = 2
if gVar.school == "SMP": schoolKode = 3
if gVar.school == "SMA": schoolKode = 4
#rintgVar.school, schoolKode
if schoolKode:
#rint"School"
#sqlSch = " AND courses.school_id = %d" % schoolKode
#sql = "%s%s" % (sql, sqlSch)
sql = "%s%s" % (sql, " ORDER BY courses.course_level, cSiswa.Nama" )
#sql = "SELECT Kode, Nama, Status FROM cSiswa \
# WHERE TahunAjaran = %s" % gVar.schYr
#sql = "SELECT course_name \
# FROM courses "
#rintsql
results = fetch.getAll_dict(sql)
#rintlen(results), "Results "
print
results = fetch.DATA(sql)
##rint"DATA = " , results
self.list.PopulateList(results)
def __do_layout(self):
sizer_main = wx.BoxSizer( wx.VERTICAL)
sizer_main.Add(self.list, 1, wx.EXPAND | wx.ALL, 0)
self.SetSizer(sizer_main)
def appendRes(cmb, sql):
index=1
dict ={}
res=fetch.getAll_dict(sql)
for row in res:
id = row['addrItem_id']
title = row['name']
next_id = fetch.nextItemID(id)
nextItem = fetch.addrItemName(next_id)
cmb.Append(title, id)
dict[index] = id
index += 1
return dict
def populateSelectionList(self):
selection_list =[]
sql = "SELECT courses.id, courses.course_name, courses.course_level \
FROM courses \
INNER JOIN courses_by_year \
ON (int(courses.id) = int(courses_by_year.course_id)) \
WHERE courses_by_year.schYr = %s" % gVar.schYr
results = fetch.getAll_dict(sql)
if results:
self.update = True
for row in results:
course_id, course_name, x = row
course_level = "%02d" % row[2]
selection_list.append((course_id, course_name, course_level))
else:
self.update = False
return selection_list
def teachers(cmb, firsttitle=''):
genAdd(cmb," SELECT id, first_name \
FROM employees \
WHERE status = TRUE AND teacher=1", 'New employee')
return
###rint sql
dataSet = fetch.getAll_dict(sql)
###rint dataSet
originalIndex = int(cmb.GetSelection())
select = 0
if originalIndex > -1: origional_id = cmb.GetClientData(originalIndex)
else: origional_id = 0
cmb.Freeze() # locks the combo so that other events are not called
cmb.Clear()
if firsttitle:
cmb.Append(firsttitle, 0) # add a blank
if schid > 0:
index = 1
for row in dataSet:
schIDs = row['schools'].split(',')
if schid in schIDs:
id = row['id']
title = row['first_name']
cmb.Append(title, id)
if id == origional_id: select = index
index += 1
else:
index = 1
for row in dataSet:
id = row[0]
title = str(row[1])
cmb.Append(title, id)
if id == origional_id:select = index
index += 1
cmb.Select(0)
if originalIndex > -1: cmb.Select(select)
cmb.Thaw()
def schFees(cmb):
origionalItem = cmb.GetSelection()
if origionalItem > -1: origional_id = cmb.GetClientData(origionalItem)
cmb.Freeze()
cmb.Clear()
sql = " SELECT fee_id, feeType, feeAmount, description \
FROM schoolfees \
WHERE validTillYr >= 2010"
###rint sql
res = fetch.getAll_dict(sql)
if res:
cmb.Append('',0)
for row in res:
id = row['fee_id']
title = "%s : %s" % (row['feeType'], row['feeAmount'])
cmb.Append(title, id)
cmb.Select(0)
cmb.Thaw()
if origionalItem > 0: cmb.Select(origional_id)