def populateSubjects(list_ctrl, sql):
selected_id = selectedItemID(list_ctrl)
reselectIndex = selectedItemIndex(list_ctrl)
list_ctrl.DeleteAllItems()
# rint sql
res = fetch.getAll_dict(sql) # 1st col must be 'id'
# rint res
if res:
for row in res:
# rint row
fieldCount = len(str(row).split(","))
subject_title_id = row["id"]
index = list_ctrl.Append(str(subject_title_id))
if subject_title_id == selected_id:
reselectIndex = index
list_ctrl.SetStringItem(index, 0, str(subject_title_id))
list_ctrl.SetStringItem(index, 1, str(row["subject_title"]))
list_ctrl.SetStringItem(index, 2, str(row["short"]))
decorateBanding(list_ctrl)
list_ctrl.Select(reselectIndex)
list_ctrl.SetFocus()
def populateSubjectsAndAspects(list_ctrl, sql):
selected_id = selectedItemID(list_ctrl)
reselectIndex = selectedItemIndex(list_ctrl)
list_ctrl.DeleteAllItems()
return
# #rint sql
res = fetch.getAll_dict(sql) # 1st col must be 'id'
# rint res
if res:
for row in res:
fieldCount = len(str(row).split(","))
subject_title_id = row["id"]
index = list_ctrl.Append(str(subject_title_id))
if subject_title_id == selected_id:
reselectIndex = index
list_ctrl.SetStringItem(index, 0, str(subject_title_id))
list_ctrl.SetStringItem(index, 1, str(row["subject_title"]))
list_ctrl.SetStringItem(index, 2, str(row["short"]))
aspectIDs = row["aspectIDs"]
if aspectIDs:
aspectList = []
aspectIDsList = aspectIDs.split(",")
for id in aspectIDsList:
aspectList.append(fetch.aspectTitle(int(id)))
list_ctrl.SetStringItem(index, 3, ",".join(aspectList))
decorateBanding(list_ctrl)
list_ctrl.Select(reselectIndex)
list_ctrl.SetFocus()
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 update(self, excul_id, activity_id, employee_id=0):
sql = " SELECT id FROM excul \
WHERE id = %d \
AND exculset_id = %d \
AND activity_id = %d \
AND employee_id = %d" % (self.exculset_id, excul_id, activity_id, employee_id)
if fetch.getAll_dict(sql):
pass
#rint'DlgExculActivityListEditor > match found = do nothing'
else:
sql ="UPDATE excul \
SET activity_id = %d, employee_id = %d \
WHERE id = %d" % (activity_id, employee_id, excul_id)
fetch.updateDB(sql)
def populateClasses(list_ctrl, sql):
selected_id = selectedItemID(list_ctrl)
reselectIndex = selectedItemIndex(list_ctrl)
list_ctrl.DeleteAllItems()
res = fetch.getAll_dict(sql) # 1st col must be 'id'
if res:
for row in res:
fieldCount = len(str(row).split(","))
lesson_id = row["id"]
index = list_ctrl.Append(str(lesson_id))
if lesson_id == selected_id:
reselectIndex = index
list_ctrl.SetStringItem(index, 0, str(lesson_id))
subjectTitle = fetch.subjectTitle(row["subject_title_id"])
list_ctrl.SetStringItem(index, 1, str(subjectTitle))
decorateBanding(list_ctrl)
list_ctrl.Select(reselectIndex)
list_ctrl.SetFocus()
def populateEmployees(list_ctrl, employeeIDs=0):
selected_id = selectedItemID(list_ctrl)
reselectIndex = selectedItemIndex(list_ctrl)
list_ctrl.DeleteAllItems()
# if not employeeIDs:
sql = "SELECT id, first_name FROM employees WHERE status > 0"
employees = fetch.getAll_dict(sql)
# rint sql, employees
if not employees:
return
for employee in employees:
employee_id = employee["id"]
employee_name = employee["first_name"]
# sql = "SELECT first_name FROM employees\
# WHERE id = %d" % employee_id
# row = fetch.getOne_dict(sql)
# employeeName = fetch.employeeName(employee_id)
index = list_ctrl.Append(str(employee_id))
list_ctrl.SetStringItem(index, 0, str(employee_id)) # display staff_id
if employee_id == selected_id:
reselectIndex = index
list_ctrl.SetStringItem(index, 1, employee_name) # full name
list_ctrl.SetStringItem(index, 2, row["first_name"]) # short name
# rint "lv.py (line 121): teacher_id;", teacher_id
batch_name = fetch.batchName_forMentor(int(employee_id))
list_ctrl.SetStringItem(index, 3, batch_name) # form
# list_ctrl.SetStringItem(index, 4, row['approbation'])# approbation
list_ctrl.Select(reselectIndex)
decorateBanding(list_ctrl)
list_ctrl.SetFocus()
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)
