def OnPopup(self, event): list_ctrl = event.GetEventObject() list_ctrl_id = list_ctrl.GetId() self.excul_id = list_ctrl_id - 1000 self.mnu_abs.SetTitle(fetch.excul_activityTitle_forExcul(self.excul_id )) self.PopupMenu(self.mnu_abs)
def createListCtrl(self, excul_id, itemNo):#posit, excul_id): list_ctrl_id = 1000 + int(excul_id) list_ctrl_name = 'exculid:%d' % excul_id list_ctrl = wx.ListCtrl(self.panel_list_ctrls, list_ctrl_id, size = (200,200), style=wx.LC_REPORT |wx.BORDER_SUNKEN) title = fetch.excul_activityTitle_forExcul(excul_id) self.initListCtrl(list_ctrl, title) r, c = round(itemNo/4), itemNo%4 self.sizer_excul.Add(list_ctrl, (r,c)) sql = "SELECT s.id, s.first_name, b.name \ FROM students s \ JOIN batch_students bs ON s.id = bs.student_id \ JOIN batches b ON b.id = bs.batch_id \ JOIN excul_students es ON s.id = es.student_id \ WHERE es.excul_id =%d" % excul_id lv.populate(list_ctrl, sql) return list_ctrl