def select(self,event): t = self.team_list.GetSelection() self.team_name = self.team_list.GetString(t) query = "Select Team_ID from Scoreboard.Team where T_Name='%s'"%(self.team_name) data = conn1(query) for row in data : self.T_ID = row[0] if self.add_o_play == 1 : self.select = wx.Button(self,8,'Select',(200,400)) self.Bind(wx.EVT_BUTTON,self.newplay,id=8) else : self.proceed = wx.Button(self,10,'Proceed',(200,400)) self.Bind(wx.EVT_BUTTON,self.selectplay,id=10)
def selectplay(self,event): self.static_s.Hide() self.team_list.Hide() self.proceed.Destroy() query = "Select Name,ID from Scoreboard.Bat_car where Team_ID = '%s'"%(self.T_ID) data = conn1(query) print(data) self.list_box(data) self.next_team = wx.Button(self,11,'Next Team',(200,400)) self.Bind(wx.EVT_BUTTON,self.teams,id=11) if self.team1_o_2 == 9 : self.Bind(wx.EVT_LISTBOX,self.first_team,id=7) elif self.team1_o_2 == 11 : self.Bind(wx.EVT_LISTBOX,self.second_team,id =7)
def new_player(self): self.score.Hide() self.textbox.Hide() self.textbox2.Hide() query2 = "Select ID,Name from Scoreboard.c_bat where Match_ID ='%d' And Team_ID = '%d' and Status ='%d'"%(self.match_ID,self.team1,0) data = conn1(query2) self.select = wx.ListCtrl(self,32,(100,50),wx.Size(100,100),style = wx.LC_REPORT) self.select.InsertColumn(0,'ID',width=50) self.select.InsertColumn(1,'Name',width =50) index_c = 0 for row in data: self.select.InsertStringItem(index_c,str(row[0])) self.select.SetStringItem(index_c,1,str(row[1])) index_c = index_c +1 self.select.Bind(wx.EVT_LIST_ITEM_SELECTED,self.ADD_new)
def teams(self,event): self.Hide_all() self.static_s = wx.StaticText(self,label = 'Click to select Your team',pos =(100,50)) # add_o_play is an integer for checking if the team list is called to add or play self.add_o_play = event.GetId() # team1_o_2 checks if the function is called for first team or second self.team1_o_2 = event.GetId() if self.team1_o_2 == 11: #hiding the previous widgets self.player_list.Hide() self.next_team.Hide() self.team_list.Hide() list = "SELECT T_name from Scoreboard.Team" data = conn1(list) mylist = []; for row in data : mylist.append(str(row[0])) self.team_list = wx.ListBox(self,7,(100,100),wx.Size(200,200),mylist) self.Bind(wx.EVT_LISTBOX,self.select,id=7)
def get_player(self): query = "Update Scoreboard.c_bow SET Runs = Runs +'%d',Overs = Overs + '%d',Wickets = Wickets +'%d' where ID = '%d' AND Team_ID = '%d' AND Match_ID = '%d'"%(self.runs,1,self.wickets,self.bowl_ID,self.team2,self.match_ID) conn(query) self.runs = 0 self.wickets = 0 query2 = "Select ID,Name from scoreboard.c_bow where Match_ID='%d' AND Team_ID ='%d'"%(self.match_ID,self.team2) data = conn1(query2) self.select_2 = wx.ListCtrl(self,32,(350,350),wx.Size(100,100),style = wx.LC_REPORT) self.select_2.InsertColumn(0,'ID',width=50) self.select_2.InsertColumn(1,'Name',width =50) index_c = 0 for row in data: if int(row[0]) != self.bowl_ID: self.select_2.InsertStringItem(index_c,str(row[0])) self.select_2.SetStringItem(index_c,1,str(row[1])) index_c = index_c +1 self.select_2.Bind(wx.EVT_LIST_ITEM_SELECTED,self.Get_bowl) self.bowl.SetStringItem(0,2,str(0)) self.bowl.SetStringItem(0,3,str(0)) self.bowl.SetStringItem(0,4,str(0)) self.bowl.SetStringItem(0,5,str(0)) self.bowl.SetStringItem(0,6,str(0)) self.bowl.SetStringItem(0,7,str(0))
def score_b(self,event): self.Hide_all() self.show_team1.Destroy() self.show_team2.Destroy() self.Go.Destroy() self.static_Bat.Destroy() self.static_Bowl.Destroy() self.set_itb.Destroy() if self.agla == 45: temp = self.team1 self.team1 = self.team2 self.team2 = temp print("working") query = "Select ID,Name from c_bat where Team_ID = '%d' AND Match_ID = '%d' AND Status='%d'"%(self.team1,self.match_ID,1) query2= "Select ID,Name from C_bow where Team_ID ='%d' AND Match_ID = '%d' AND Status = '%d'"%(self.team2,self.match_ID,1) data = conn1(query) data2 = conn1(query2) print('working') self.textbox = wx.StaticText(self,label='Batting',pos= (50,30)) self.score = wx.ListCtrl(self,20,(50,50),wx.Size(400,100),style = wx.LC_REPORT) self.score.InsertColumn(0,'ID',width=50) self.score.InsertColumn(1,'Name',width=100) self.score.InsertColumn(2,'Runs',width=50) self.score.InsertColumn(3,'Balls',width=50) self.score.InsertColumn(4,"1's",width=40) self.score.InsertColumn(5,"2's",width=40) self.score.InsertColumn(6,"3's",width=40) self.score.InsertColumn(7,"4's",width=40) self.score.InsertColumn(8,"6's",width=40) self.score.InsertColumn(9,'SR',width=40) self.textbox2 = wx.StaticText(self,label='Bowling',pos= (50,180)) self.bowl =wx.ListCtrl(self,28,(50,200),wx.Size(400,50),style = wx.LC_REPORT) self.bowl.InsertColumn(0,'ID',width =50) self.bowl.InsertColumn(1,'Name',width =100) self.bowl.InsertColumn(2,'1',width =40) self.bowl.InsertColumn(3,'2',width =40) self.bowl.InsertColumn(4,'3',width =40) self.bowl.InsertColumn(5,'4',width =40) self.bowl.InsertColumn(6,'5',width =40) self.bowl.InsertColumn(7,'6',width =40) index = 0 for row in data: print("Works !!") self.score.InsertStringItem(index,str(row[0])) self.score.SetStringItem(index,1,str(row[1])) print(row[0],row[1]) if index == 0: self.ID_1 = row[0] else : self.ID_2 = row[0] index = index+1 index_2 = 0 for row in data2: print("Works!!") self.bowl.InsertStringItem(index_2,str(row[0])) self.bowl_ID = int(row[0]) self.bowl.SetStringItem(index_2,1,str(row[1])) print(row[0],row[1]) self.one_1 =0 self.one_2 =0 self.balls_1 = 0 self.balls_2 =0 self.overs = 0 self.over_count = 0 self.one = wx.Button(self,15,'1',(0,300)) self.Bind(wx.EVT_BUTTON,self.add_one,id=15) self.two_1 =0 self.two_2 =0 self.two = wx.Button(self,16,'2',(0,350)) self.Bind(wx.EVT_BUTTON,self.add_two,id=16) self.three_1 =0 self.three_2 =0 self.three = wx.Button(self,17,'3',(100,300)) self.Bind(wx.EVT_BUTTON,self.add_three,id=17) self.four_1 =0 self.four_2 =0 self.four= wx.Button(self,18,'4',(100,350)) self.Bind(wx.EVT_BUTTON,self.add_four,id=18) self.six_1 =0 self.six_2 =0 self.six = wx.Button(self,19,'6',(200,300)) self.Bind(wx.EVT_BUTTON,self.add_six,id=19) self.score.Bind(wx.EVT_LIST_ITEM_SELECTED,self.change) self.run_1 = 0 self.run_2 = 0 self.t_runs = 0 self.count = 1 self.wicket = wx.Button(self,30,'Wicket',(200,350)) self.wickets = 0 self.tot_wickets = 0 self.runs = 0 self.wicket.Bind(wx.EVT_BUTTON,self.wicket_func) self.line1 = wx.StaticLine(self,pos =(0,440),size=(500,10)) self.run_bar = wx.StaticText(self,label = 'Runs:',pos = (0,450)) self.run_bar1 = wx.StaticText(self,label =str(self.t_runs),pos = (50,450)) self.over_bar = wx.StaticText(self,label ='Overs',pos = (400,450)) self.over_bar1 = wx.StaticText(self,label = str(self.overs),pos = (450,450))