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
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
|
# -*- Mode: Python; coding: iso-8859-1 -*-
# vi:si:et:sw=4:sts=4:ts=4
##
## Copyright (C) 2005-2007 Async Open Source <http://www.async.com.br>
## All rights reserved
##
## 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 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
## Foundation, Inc., or visit: http://www.gnu.org/.
##
## Author(s): Stoq Team <stoq-devel@async.com.br>
##
""" Main gui definition for inventory application. """
import gettext
import datetime
import gtk
from kiwi.enums import SearchFilterPosition
from kiwi.ui.search import ComboSearchFilter
from kiwi.ui.objectlist import Column, SearchColumn
from stoqlib.database.runtime import new_transaction, finish_transaction
from stoqlib.domain.interfaces import IBranch
from stoqlib.domain.inventory import Inventory
from stoqlib.domain.person import Person
from stoqlib.domain.product import ProductStockItem
from stoqlib.exceptions import DatabaseInconsistency
from stoq.gui.application import SearchableAppWindow
from stoqlib.gui.dialogs.openinventorydialog import OpenInventoryDialog
from stoqlib.gui.dialogs.productadjustmentdialog import ProductsAdjustmentDialog
from stoqlib.gui.dialogs.productcountingdialog import ProductCountingDialog
from stoqlib.lib.message import yesno
from stoqlib.reporting.product import ProductCountingReport
_ = gettext.gettext
class InventoryApp(SearchableAppWindow):
app_name = _('Inventory')
app_icon_name = 'stoq-inventory-app'
gladefile = "inventory"
search_table = Inventory
search_labels = _('Matching:')
klist_selection_mode = gtk.SELECTION_MULTIPLE
def __init__(self, app):
SearchableAppWindow.__init__(self, app)
self._update_widgets()
#
# SearchableAppWindow
#
def create_filters(self):
self.set_text_field_columns(["id"])
self.branch_filter = ComboSearchFilter(
_('Show inventories at:'), self._get_branches_for_filter())
self.add_filter(self.branch_filter,
position=SearchFilterPosition.TOP,
columns=["branchID"])
def get_columns(self):
return [SearchColumn('id', title=_('Code'), sorted=True,
order=gtk.SORT_DESCENDING,
data_type=int, format='%03d', width=80),
SearchColumn('status_str', title=_('Status'),
data_type=str, width=100,
valid_values=self._get_status_values(),
search_attribute='status'),
Column('branch.person.name', title=_('Branch'),
data_type=str, expand=True),
SearchColumn('open_date', title=_('Opened'),
long_title='Date Opened',
data_type=datetime.date, width=120),
SearchColumn('close_date', title=_(u'Closed'),
long_title='Date Closed',
data_type=datetime.date, width=120)]
#
# Private API
#
def _get_status_values(self):
values = [(v, k) for k, v in Inventory.statuses.items()]
values.insert(0, (_("Any"), None))
return values
def _get_branches(self):
return Person.iselect(IBranch, connection=self.conn)
def _get_branches_for_filter(self):
items = [(b.person.name, b.id) for b in self._get_branches()]
if not items:
raise DatabaseInconsistency('You should have at least one '
'branch on your database.'
'Found zero')
items.insert(0, [_('All branches'), None])
return items
def _update_widgets(self):
has_open = False
all_counted = False
has_adjusted = False
rows = self.results.get_selected_rows()
if len(rows) == 1:
all_counted = rows[0].all_items_counted()
has_open = rows[0].is_open()
has_adjusted = rows[0].has_adjusted_items()
self.print_button.set_sensitive(has_open)
self.cancel_button.set_sensitive(has_open and not has_adjusted)
self.new_inventory.set_sensitive(self._can_open())
self.counting_action.set_sensitive(has_open)
self.adjust_action.set_sensitive(has_open and all_counted)
def _get_available_branches_to_inventory(self):
"""Returns a list of branches where we can open an inventory.
Note that we can open a inventory if:
- There's no inventory opened yet (in the same branch)
- The branch must have some stock
"""
available_branches = []
for branch in self._get_branches():
has_open_inventory = Inventory.has_open(self.conn, branch)
if not has_open_inventory:
stock = ProductStockItem.selectBy(branch=branch,
connection=self.conn)
if stock.count() > 0:
available_branches.append(branch)
return available_branches
def _can_open(self):
# we can open an inventory if we have at least one branch
# available
return bool(self._get_available_branches_to_inventory())
def _open_inventory(self):
trans = new_transaction()
branches = self._get_available_branches_to_inventory()
model = self.run_dialog(OpenInventoryDialog, trans, branches)
finish_transaction(trans, model)
trans.close()
self.refresh()
self._update_widgets()
def _cancel_inventory(self):
if yesno(_(u'Are you sure you want to cancel this inventory ?'),
gtk.RESPONSE_YES, _(u'No'), _(u'Cancel Inventory')):
return
trans = new_transaction()
inventory = trans.get(self.results.get_selected_rows()[0])
inventory.cancel()
trans.commit()
def _register_product_counting(self):
trans = new_transaction()
inventory = trans.get(self.results.get_selected_rows()[0])
model = self.run_dialog(ProductCountingDialog, inventory, trans)
finish_transaction(trans, model)
trans.close()
self._update_widgets()
def _adjust_product_quantities(self):
trans = new_transaction()
inventory = trans.get(self.results.get_selected_rows()[0])
model = self.run_dialog(ProductsAdjustmentDialog, inventory, trans)
finish_transaction(trans, model)
trans.close()
self._update_widgets()
def _update_filter_slave(self, slave):
self.refresh()
def _get_sellables_by_inventory(self, inventory):
for item in inventory.get_items():
yield item.product.sellable
#
# Callbacks
#
def on_new_inventory__activate(self, action):
self._open_inventory()
def on_counting_action__activate(self, action):
self._register_product_counting()
def on_adjust_action__activate(self, action):
self._adjust_product_quantities()
def on_results__selection_changed(self, results, product):
self._update_widgets()
def on_cancel_button__clicked(self, widget):
self._cancel_inventory()
def on_print_button__clicked(self, button):
selected = self.results.get_selected_rows()[0]
sellables = list(self._get_sellables_by_inventory(selected))
if sellables:
self.print_report(ProductCountingReport, sellables)
|