1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
|
# -*- coding: UTF-8 -*-
__revision__ = '$Id: quick_filter.py 305 2006-04-11 13:37:11Z piotrek $'
# Copyright (c) 2005-2006 Vasco Nunes
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2 of the License, or
# (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU Library General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA
# You may use and distribute this software under the terms of the
# GNU General Public License, version 2 or later
from gettext import gettext as _
import gutils
def change_filter(self):
self.all_movies.set_active(2)
collection_id = self.collection_combo_ids[self.f_col.get_active()]
where_clause = ''
text = gutils.gescape(self.e_filter.get_text())
if(len(text)==0):
if collection_id != 0:
where_clause = " collection_id = '%s'" % collection_id
data = self.db.get_all_data(where=where_clause, order_by="number ASC")
else:
text = gutils.gescape(text)
criteria = self.sort_criteria[self.filter_criteria.get_active()]
if {"year":None, "runtime":None, "num_media":None, "rating":None}.has_key(criteria):
where_clause = criteria + " = '"+text+"'"
else:
where_clause = criteria + " LIKE '%" + text + "%'"
if collection_id != 0:
where_clause += " AND collection_id = '%s'" % collection_id
data = self.db.get_all_data(where=where_clause, order_by="number ASC")
self.total_filter = len(data)
self.populate_treeview(data)
self.go_last()
def clear_filter(self):
self.e_filter.set_text("")
self.filter_criteria.set_active(0)
self.total_filter = self.total
self.go_last()
|
