def filter_button(self):

        name = self.nameEdit.text()
        description_keyword = self.descriptionKeyword.text()
        start_date = self.startDate.text()
        end_date = self.endDate.text()
        duration_low = self.duration1.text()
        duration_high = self.duration2.text()
        totalvisits_low = self.visits1.text()
        totalvists_high = self.visits2.text()
        revenue_low = self.rev1.text()
        revenue_high = self.rev2.text()


        connection = pymysql.connect(host="localhost",
                                    user="root",
                                    password="12345678",
                                    db="beltline")
        cursor = connection.cursor()
        filterquery = f"select event.name, count(distinct assignto.employeeid, assignto.startdate) as StaffCount, DATEDIFF(event.EndDate, event.StartDate) + 1 as Duration, count(visitevent.username) as TotalVisits, count(visitevent.username)*event.price as TotalRevenue from event join assignto on assignto.name = event.name join visitevent on visitevent.name = event.name  group by event.name"
        df = pd.read_sql(filterquery, connection)
        model = PandasModel(df)
        self.tableView.setModel(model)