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
54
55
56
57
58
59
60
61
62
63
64
|
# -*- coding: UTF-8 -*-
__revision__ = '$Id: view.py 275 2006-03-05 01:10:12Z iznogoud $'
# Copyright (c) 2005 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 _
def filter_not_seen(self):
data = self.db.get_not_seen_movies()
self.update_statusbar(_("Filter activated. Showing only not seen movies."))
self.populate_treeview(data)
self.total_filter = self.db.count_records('movies', 'seen=0')
self.go_last()
def filter_loaned(self):
data = self.db.get_loaned_movies()
self.update_statusbar(_("Filter activated. Showing only loaned movies."))
self.populate_treeview(data)
self.total_filter = self.db.count_records('movies', 'loaned=1')
self.go_last()
def filter_all(self):
data = self.db.get_all_data(order_by="number ASC")
self.count_statusbar()
self.populate_treeview(data)
argum = self.total
self.total_filter = self.total
self.go_last()
def filter_by_volume(self, volume_id):
self.db.cursor.execute("SELECT name FROM volumes WHERE id = '%s'" % volume_id)
volume_name = self.db.cursor.fetchone()[0]
self.update_statusbar(_("Filter activated. Showing only movies from volume: %s")%volume_name)
data = self.db.select_movies_by_volume(volume_id)
self.populate_treeview(data)
self.total_filter = self.db.count_records('movies', 'volume_id="%s"'%volume_id)
self.go_last()
def filter_by_collection(self, collection_id):
self.db.cursor.execute("SELECT name FROM collections WHERE id = '%s'" % collection_id)
collection_name = self.db.cursor.fetchone()[0]
self.update_statusbar(_("Filter activated. Showing only movies from collection: %s")%collection_name)
data = self.db.select_movies_by_collection(collection_id)
self.populate_treeview(data)
self.total_filter = self.db.count_records('movies', 'collection_id="%s"'%collection_id)
self.go_last()
|
