def create_filters(self):
self.set_text_field_columns(['description'])
# status filter
statuses = [(desc, i) for i, desc in Loan.statuses.items()]
statuses.insert(0, (_(u'Any'), None))
status_filter = ComboSearchFilter(_(u'with status:'), statuses)
status_filter.select(None)
self.add_filter(status_filter, columns=['loan_status'],
position=SearchFilterPosition.TOP)
def create_filters(self):
self.set_text_field_columns(['name', 'cpf', 'rg_number',
'phone_number', 'mobile_number'])
statuses = [(v, k) for k, v in Client.statuses.items()]
statuses.insert(0, (_('Any'), None))
status_filter = ComboSearchFilter(_('Show clients with status'),
statuses)
status_filter.select(None)
self.add_filter(status_filter, SearchFilterPosition.TOP, ['status'])
def create_filters(self):
self.set_text_field_columns(['description', 'barcode'])
items = [(v, k) for k, v in Sellable.statuses.items()]
items.insert(0, (_('Any'), None))
service_filter = ComboSearchFilter(_('Show services'),
items)
service_filter.select(None)
self.executer.add_query_callback(self._get_query)
self.add_filter(service_filter, SearchFilterPosition.TOP, ['status'])
def create_filters(self):
self.set_text_field_columns(['name', 'phone_number'])
items = [(_('Active'), True),
(_('Inactive'), False)]
items.insert(0, (_('Any'), None))
status_filter = ComboSearchFilter(_('Show transporters with status'),
items)
status_filter.select(None)
self.add_filter(status_filter, SearchFilterPosition.TOP, ['is_active'])
class DeliverySearch(SearchEditor):
"""Delivery search implementation"""
title = _('Delivery Search')
search_table = DeliveryView
editor_class = DeliveryEditor
searchbar_result_strings = _('Delivery'), _('Deliveries')
has_new_button = False
size = (750, 450)
#
# SearchEditor hooks
#
def _get_status_values(self):
items = [(value, key) for key, value in Delivery.statuses.items()]
items.insert(0, (_('Any'), None))
return items
def create_filters(self):
self.set_text_field_columns(['tracking_code', 'transporter_name',
'client_name'])
# Status
statuses = [(desc, st) for st, desc in Delivery.statuses.items()]
statuses.insert(0, (_('Any'), None))
self.status_filter = ComboSearchFilter(_('With status:'), statuses)
self.status_filter.select(None)
self.add_filter(self.status_filter, columns=['status'],
position=SearchFilterPosition.TOP)
def get_editor_model(self, viewable):
return viewable.delivery
def get_columns(self):
return [Column('sale_identifier', title=_('Sale #'), data_type=int,
order=gtk.SORT_DESCENDING),
SearchColumn('status_str', title=_('Status'), data_type=str,
search_attribute='status',
valid_values=self._get_status_values()),
Column('address_str', title=_('Address'), data_type=str,
expand=True, ellipsize=pango.ELLIPSIZE_END),
SearchColumn('tracking_code', title=_('Tracking code'),
data_type=str),
SearchColumn('transporter_name', title=_('Transporter'),
data_type=str),
SearchColumn('client_name', title=_('Client'),
data_type=str),
SearchColumn('open_date', title=_('Open date'),
data_type=datetime.date, visible=False),
SearchColumn('deliver_date', title=_('Sent date'),
data_type=datetime.date, visible=False),
SearchColumn('receive_date', title=_('Received date'),
data_type=datetime.date, visible=False),
]
def create_filters(self):
self.set_text_field_columns(['name', 'acronym', 'phone_number'])
statuses = [(value, key)
for key, value in Branch.statuses.items()]
statuses.insert(0, (_('Any'), None))
status_filter = ComboSearchFilter(_('Show branches with status'),
statuses)
status_filter.select(None)
self.executer.add_filter_query_callback(
status_filter, self._get_status_query)
self.search.add_filter(status_filter, SearchFilterPosition.TOP)
def create_filters(self):
self.set_text_field_columns(['description'])
self.executer.add_query_callback(self._get_query)
# Status
items = [(v, k) for k, v in Till.statuses.items()
if k != Till.STATUS_PENDING]
items.insert(0, (_(u'Any'), None))
status_filter = ComboSearchFilter(_(u'Show entries of type'), items)
status_filter.select(Till.STATUS_OPEN)
self.add_filter(status_filter,
position=SearchFilterPosition.TOP,
columns=['status'])
def create_payment_filter(self, label=None):
from stoqlib.domain.payment.method import PaymentMethod
methods = PaymentMethod.get_active_methods(self.store)
items = [(_('Any'), None)]
for method in methods:
if method.method_name == 'multiple':
continue
items.append((method.description, method))
if not label:
label = _('Method:')
payment_filter = ComboSearchFilter(label, items)
payment_filter.select(None)
return payment_filter
def create_branch_filter(self, label=None):
from stoqlib.domain.person import Branch
branches = Branch.get_active_branches(self.store)
items = [(b.person.name, b.id) for b in branches]
#if not items:
# raise ValueError('You should have at least one branch at '
# 'this point')
items.insert(0, (_("Any"), None))
if not label:
label = _('Branch:')
branch_filter = ComboSearchFilter(label, items)
current = api.get_current_branch(self.store)
if current:
branch_filter.select(current.id)
return branch_filter
def create_filters(self):
self.set_text_field_columns(['description', 'barcode',
'category_description'])
self.executer.set_query(self.executer_query)
# Branch
branch_filter = self.create_branch_filter(_('In branch:'))
branch_filter.select(None)
self.add_filter(branch_filter, columns=[])
self.branch_filter = branch_filter
# Status
statuses = [(desc, id) for id, desc in Sellable.statuses.items()]
statuses.insert(0, (_('Any'), None))
status_filter = ComboSearchFilter(_('with status:'), statuses)
status_filter.select(None)
self.add_filter(status_filter, columns=['status'],
position=SearchFilterPosition.TOP)
self.status_filter = status_filter
class ProductionItemsSearch(SearchDialog):
title = _(u'Production Items')
table = search_table = ProductionItemView
size = (750, 450)
#
# SearchDialog
#
def create_filters(self):
self.set_text_field_columns(['description'])
self.set_searchbar_labels(_(u'matching:'))
statuses = [(desc, i) for i, desc in ProductionOrder.statuses.items()]
statuses.insert(0, (_(u'Any'), None))
self.status_filter = ComboSearchFilter(_('order status:'), statuses)
self.status_filter.select(ProductionOrder.ORDER_PRODUCING)
self.add_filter(self.status_filter, columns=['order_status'],
position=SearchFilterPosition.TOP)
def get_columns(self):
return [SearchColumn('order_identifier', title=_(u'Order'),
data_type=int, sorted=True, format='%04d'),
SearchColumn('category_description', title=_(u'Category'),
data_type=str),
SearchColumn('description', title=_(u'Description'),
data_type=str, expand=True),
SearchColumn('unit_description', title=_(u'Unit'),
data_type=str),
SearchColumn('quantity', title=_(u'To Produce'),
data_type=Decimal),
SearchColumn('produced', title=_(u'Produced'),
data_type=Decimal),
SearchColumn('lost', title=_(u'Lost'), data_type=Decimal,
visible=False)]
#
# Callbacks
#
def on_print_button_clicked(self, widget):
print_report(ProductionItemReport, self.results, list(self.results),
filters=self.search.get_search_filters(), )
class TillApp(SearchableAppWindow):
app_name = _(u'Till')
gladefile = 'till'
search_table = SaleView
search_labels = _(u'matching:')
report_table = SalesReport
embedded = True
#
# Application
#
def create_actions(self):
group = get_accels('app.till')
actions = [
('SaleMenu', None, _('Sale')),
('TillOpen', None, _('Open till...'),
group.get('open_till')),
('TillClose', None, _('Close till...'),
group.get('close_till')),
('TillVerify', None, _('Verify till...'),
group.get('verify_till')),
('TillAddCash', None, _('Cash addition...'), ''),
('TillRemoveCash', None, _('Cash removal...'), ''),
("PaymentReceive", None, _("Payment receival..."),
group.get('payment_receive'),
_("Receive payments")),
("SearchClient", None, _("Clients..."),
group.get('search_clients'),
_("Search for clients")),
("SearchSale", None, _("Sales..."),
group.get('search_sale'),
_("Search for sales")),
("SearchSoldItemsByBranch", None, _("Sold items by branch..."),
group.get('search_sold_items_by_branch'),
_("Search for items sold by branch")),
("SearchTillHistory", None, _("Till history..."),
group.get('search_till_history'),
_("Search for till history")),
("SearchFiscalTillOperations", None, _("Fiscal till operations..."),
group.get('search_fiscal_till_operations'),
_("Search for fiscal till operations")),
("Confirm", gtk.STOCK_APPLY, _("Confirm..."),
group.get('confirm_sale'),
_("Confirm the selected sale, decreasing stock and making it "
"possible to receive it's payments")),
("Return", gtk.STOCK_CANCEL, _("Return..."),
group.get('return_sale'),
_("Return the selected sale, returning stock and the client's "
"payments")),
("Details", gtk.STOCK_INFO, _("Details..."),
group.get('sale_details'),
_("Show details of the selected sale")),
]
self.till_ui = self.add_ui_actions('', actions,
filename="till.xml")
self.set_help_section(_("Till help"), 'app-till')
self.Confirm.set_short_label(_('Confirm'))
self.Return.set_short_label(_('Return'))
self.Details.set_short_label(_('Details'))
self.Confirm.props.is_important = True
self.Return.props.is_important = True
self.Details.props.is_important = True
def create_ui(self):
self.popup = self.uimanager.get_widget('/TillSelection')
self.current_branch = api.get_current_branch(self.store)
# Groups
self.main_vbox.set_focus_chain([self.app_vbox])
self.app_vbox.set_focus_chain([self.search_holder, self.list_vbox])
# Setting up the toolbar
self.list_vbox.set_focus_chain([self.footer_hbox])
self._setup_printer()
self._setup_widgets()
def get_title(self):
return _('Stoq - Till for Branch %03d') % (
api.get_current_branch(self.store).id, )
def activate(self, params):
self.app.launcher.add_new_items([self.TillAddCash,
self.TillRemoveCash])
self.app.launcher.add_search_items([self.SearchFiscalTillOperations,
self.SearchClient,
self.SearchSale])
self.app.launcher.Print.set_tooltip(_("Print a report of these sales"))
self.refresh()
self._printer.run_initial_checks()
self.check_open_inventory()
def deactivate(self):
self.uimanager.remove_ui(self.till_ui)
def new_activate(self):
if not self.TillAddCash.get_sensitive():
return
self._run_add_cash_dialog()
def search_activate(self):
self._run_search_dialog(TillFiscalOperationsSearch)
#
# SearchableAppWindow
#
def set_open_inventory(self):
self.set_sensitive(self._inventory_widgets, False)
def create_filters(self):
self.executer.set_query(self._query_executer)
self.set_text_field_columns(['client_name', 'salesperson_name'])
self.status_filter = ComboSearchFilter(_(u"Show orders"),
self._get_status_values())
self.status_filter.select(Sale.STATUS_CONFIRMED)
self.add_filter(self.status_filter, position=SearchFilterPosition.TOP,
columns=['status'])
def get_columns(self):
return [SearchColumn('identifier', title=_('#'), width=60,
long_title=_('Order number'),
data_type=int, format='%05d', sorted=True),
Column('status_name', title=_(u'Status'), data_type=str,
visible=False),
SearchColumn('open_date', title=_('Date Started'), width=110,
data_type=date, justify=gtk.JUSTIFY_RIGHT),
SearchColumn('client_name', title=_('Client'),
data_type=str, expand=True,
ellipsize=pango.ELLIPSIZE_END),
SearchColumn('salesperson_name', title=_('Salesperson'),
data_type=str, width=180,
ellipsize=pango.ELLIPSIZE_END),
SearchColumn('total_quantity', title=_('Quantity'),
data_type=decimal.Decimal, width=100,
format_func=format_quantity),
SearchColumn('total', title=_('Total'), data_type=currency,
width=100)]
#
# Private
#
def _query_executer(self, store):
# We should only show Sales that
# 1) In the current branch (FIXME: Should be on the same station.
# See bug 4266)
# 2) Are in the status QUOTE or ORDERED.
# 3) For the order statuses, the date should be the same as today
query = And(Sale.branch == self.current_branch,
Or(Sale.status == Sale.STATUS_QUOTE,
Sale.status == Sale.STATUS_ORDERED,
Date(Sale.open_date) == date.today()))
return store.find(self.search_table, query)
def _setup_printer(self):
self._printer = FiscalPrinterHelper(self.store,
parent=self)
self._printer.connect('till-status-changed',
self._on_PrinterHelper__till_status_changed)
self._printer.connect('ecf-changed',
self._on_PrinterHelper__ecf_changed)
self._printer.setup_midnight_check()
def _get_status_values(self):
statuses = [(v, k) for k, v in Sale.statuses.items()]
statuses.insert(0, (_('Any'), None))
return statuses
def _confirm_order(self):
if self.check_open_inventory():
return
store = api.new_store()
selected = self.results.get_selected()
sale = store.fetch(selected.sale)
expire_date = sale.expire_date
if (sale.status == Sale.STATUS_QUOTE and
expire_date and expire_date.date() < date.today() and
not yesno(_("This quote has expired. Confirm it anyway?"),
gtk.RESPONSE_YES,
_("Confirm quote"), _("Don't confirm"))):
store.close()
return
missing = sale.get_missing_items()
if missing:
retval = run_dialog(ConfirmSaleMissingDialog, self, sale, missing)
if retval:
self.refresh()
store.close()
return
coupon = self._open_coupon()
if not coupon:
store.close()
return
subtotal = self._add_sale_items(sale, coupon)
try:
if coupon.confirm(sale, store, subtotal=subtotal):
store.commit()
self.refresh()
else:
coupon.cancel()
except SellError as err:
warning(str(err))
except ModelDataError as err:
warning(str(err))
store.close()
def _open_coupon(self):
coupon = self._printer.create_coupon()
if coupon:
while not coupon.open():
if not yesno(_("Failed to open the fiscal coupon.\n"
"Until it is opened, it's not possible to "
"confirm the sale. Do you want to try again?"),
gtk.RESPONSE_YES, _("Try again"), _("Cancel coupon")):
return None
return coupon
def _add_sale_items(self, sale, coupon):
subtotal = 0
for sale_item in sale.get_items():
coupon.add_item(sale_item)
subtotal += sale_item.price * sale_item.quantity
return subtotal
def _update_total(self):
balance = currency(self._get_till_balance())
text = _(u"Total: %s") % converter.as_string(currency, balance)
self.total_label.set_text(text)
def _get_till_balance(self):
"""Returns the balance of till operations"""
try:
till = Till.get_current(self.store)
except TillError:
till = None
if till is None:
return currency(0)
return till.get_balance()
def _setup_widgets(self):
# SearchSale is here because it's possible to return a sale inside it
self._inventory_widgets = [self.Confirm, self.SearchSale,
self.Return]
self.register_sensitive_group(self._inventory_widgets,
lambda: not self.has_open_inventory())
self.total_label.set_size('xx-large')
self.total_label.set_bold(True)
self.till_status_label.set_size('xx-large')
self.till_status_label.set_bold(True)
def _update_toolbar_buttons(self):
sale_view = self.results.get_selected()
if sale_view:
can_confirm = sale_view.can_confirm()
# when confirming sales in till, we also might want to cancel
# sales
can_return = (sale_view.can_return() or
sale_view.can_cancel())
else:
can_confirm = can_return = False
self.set_sensitive([self.Details], bool(sale_view))
self.set_sensitive([self.Confirm], can_confirm)
self.set_sensitive([self.Return], can_return)
def _check_selected(self):
sale_view = self.results.get_selected()
if not sale_view:
raise StoqlibError("You should have a selected item at "
"this point")
return sale_view
def _run_search_dialog(self, dialog_type, **kwargs):
store = api.new_store()
self.run_dialog(dialog_type, store, **kwargs)
store.close()
def _run_details_dialog(self):
sale_view = self._check_selected()
run_dialog(SaleDetailsDialog, self, self.store, sale_view)
def _run_add_cash_dialog(self):
with api.trans() as store:
try:
run_dialog(CashInEditor, self, store)
except TillError as err:
# Inform the error to the user instead of crashing
warning(str(err))
return
if store.committed:
self._update_total()
def _return_sale(self):
if self.check_open_inventory():
return
sale_view = self._check_selected()
with api.trans() as store:
return_sale(self.get_toplevel(), store.fetch(sale_view.sale), store)
if store.committed:
self._update_total()
self.refresh()
def _update_ecf(self, has_ecf):
# If we have an ecf, let the other events decide what to disable.
if has_ecf:
return
# We dont have an ecf. Disable till related operations
widgets = [self.TillOpen, self.TillClose, self.TillVerify, self.TillAddCash,
self.TillRemoveCash, self.SearchTillHistory, self.app_vbox,
self.Confirm, self.Return, self.Details]
self.set_sensitive(widgets, has_ecf)
text = _(u"Till operations requires a connected fiscal printer")
self.till_status_label.set_text(text)
def _update_till_status(self, closed, blocked):
# Three different situations;
#
# - Till is closed
# - Till is opened
# - Till was not closed the previous fiscal day (blocked)
self.set_sensitive([self.TillOpen], closed)
self.set_sensitive([self.TillClose, self.PaymentReceive],
not closed or blocked)
widgets = [self.TillVerify, self.TillAddCash, self.TillRemoveCash,
self.SearchTillHistory, self.app_vbox]
self.set_sensitive(widgets, not closed and not blocked)
if closed:
text = _(u"Till closed")
self.clear()
self.setup_focus()
elif blocked:
text = _(u"Till blocked from previous day")
else:
till = Till.get_current(self.store)
text = _(u"Till opened on %s") % till.opening_date.strftime('%x')
self.till_status_label.set_text(text)
self._update_toolbar_buttons()
self._update_total()
#
# Callbacks
#
def on_Confirm__activate(self, action):
self._confirm_order()
self._update_total()
def on_results__double_click(self, results, sale):
self._run_details_dialog()
def on_results__selection_changed(self, results, sale):
self._update_toolbar_buttons()
def on_results__has_rows(self, results, has_rows):
self._update_total()
def on_results__right_click(self, results, result, event):
self.popup.popup(None, None, None, event.button, event.time)
def on_Details__activate(self, action):
self._run_details_dialog()
def on_Return__activate(self, action):
self._return_sale()
def _on_PrinterHelper__till_status_changed(self, printer, closed, blocked):
self._update_till_status(closed, blocked)
def _on_PrinterHelper__ecf_changed(self, printer, ecf):
self._update_ecf(ecf)
def on_PaymentReceive__activate(self, action):
self.run_dialog(PaymentReceivingSearch, self.store)
# Till
def on_TillVerify__activate(self, button):
self._printer.verify_till()
def on_TillClose__activate(self, button):
self._printer.close_till()
def on_TillOpen__activate(self, button):
self._printer.open_till()
def on_TillAddCash__activate(self, action):
self._run_add_cash_dialog()
def on_TillRemoveCash__activate(self, action):
with api.trans() as store:
run_dialog(CashOutEditor, self, store)
if store.committed:
self._update_total()
# Search
def on_SearchClient__activate(self, action):
self._run_search_dialog(ClientSearch, hide_footer=True)
def on_SearchSale__activate(self, action):
if self.check_open_inventory():
return
self._run_search_dialog(SaleWithToolbarSearch)
self.refresh()
def on_SearchSoldItemsByBranch__activate(self, button):
self._run_search_dialog(SoldItemsByBranchSearch)
def on_SearchTillHistory__activate(self, button):
self.run_dialog(TillHistoryDialog, self.store)
def on_SearchFiscalTillOperations__activate(self, button):
self._run_search_dialog(TillFiscalOperationsSearch)
class StockApp(SearchableAppWindow):
app_name = _('Stock')
gladefile = "stock"
search_table = ProductFullStockView
search_labels = _('Matching:')
report_table = SimpleProductReport
pixbuf_converter = converter.get_converter(gtk.gdk.Pixbuf)
embedded = True
#
# Application
#
def create_actions(self):
group = get_accels('app.stock')
actions = [
("NewReceiving", STOQ_RECEIVING, _("Order _receival..."),
group.get('new_receiving')),
('NewTransfer', gtk.STOCK_CONVERT, _('Transfer...'),
group.get('transfer_product')),
('NewStockDecrease', None, _('Stock decrease...'),
group.get('stock_decrease')),
('StockInitial', gtk.STOCK_GO_UP, _('Register initial stock...')),
("LoanNew", None, _("Loan...")),
("LoanClose", None, _("Close loan...")),
("SearchPurchaseReceiving", None, _("Received purchases..."),
group.get('search_receiving'),
_("Search for received purchase orders")),
("SearchProductHistory", None, _("Product history..."),
group.get('search_product_history'),
_("Search for product history")),
("SearchStockDecrease", None, _("Stock decreases..."), '',
_("Search for manual stock decreases")),
("SearchPurchasedStockItems", None, _("Purchased items..."),
group.get('search_purchased_stock_items'),
_("Search for purchased items")),
("SearchStockItems", None, _("Stock items..."),
group.get('search_stock_items'),
_("Search for items on stock")),
("SearchTransfer", None, _("Transfers..."),
group.get('search_transfers'),
_("Search for stock transfers")),
("SearchClosedStockItems", None, _("Closed stock Items..."),
group.get('search_closed_stock_items'),
_("Search for closed stock items")),
("LoanSearch", None, _("Loans...")),
("LoanSearchItems", None, _("Loan items...")),
("ProductMenu", None, _("Product")),
("ProductStockHistory", gtk.STOCK_INFO, _("History..."),
group.get('history'),
_('Show the stock history of the selected product')),
("EditProduct", gtk.STOCK_EDIT, _("Edit..."),
group.get('edit_product'),
_("Edit the selected product, allowing you to change it's "
"details")),
]
self.stock_ui = self.add_ui_actions('', actions,
filename='stock.xml')
toggle_actions = [
('StockPictureViewer', None, _('Picture viewer'),
group.get('toggle_picture_viewer')),
]
self.add_ui_actions('', toggle_actions, 'ToggleActions',
'toggle')
self.set_help_section(_("Stock help"), 'app-stock')
self.NewReceiving.set_short_label(_("Receive"))
self.NewTransfer.set_short_label(_("Transfer"))
self.EditProduct.set_short_label(_("Edit"))
self.ProductStockHistory.set_short_label(_("History"))
self.EditProduct.props.is_important = True
self.ProductStockHistory.props.is_important = True
def create_ui(self):
if api.sysparam(self.store).SMART_LIST_LOADING:
self.search.search.enable_lazy_search()
self.popup = self.uimanager.get_widget('/StockSelection')
self.app.launcher.add_new_items([self.NewReceiving, self.NewTransfer,
self.NewStockDecrease, self.LoanNew])
self.app.launcher.add_search_items([
self.SearchStockItems,
self.SearchStockDecrease,
self.SearchClosedStockItems,
self.SearchProductHistory,
self.SearchPurchasedStockItems,
self.SearchTransfer,
])
self.app.launcher.Print.set_tooltip(
_("Print a report of these products"))
self._inventory_widgets = [self.NewTransfer, self.NewReceiving,
self.StockInitial, self.NewStockDecrease,
self.LoanNew, self.LoanClose]
self.register_sensitive_group(self._inventory_widgets,
lambda: not self.has_open_inventory())
self.image_viewer = None
self.image = gtk.Image()
self.edit_button = self.uimanager.get_widget('/toolbar/AppToolbarPH/EditProduct')
self.edit_button.set_icon_widget(self.image)
self.image.show()
self.search.set_summary_label(column='stock',
label=_('<b>Stock Total:</b>'),
format='<b>%s</b>',
parent=self.get_statusbar_message_area())
def activate(self, params):
self.app.launcher.NewToolItem.set_tooltip(
_("Create a new receiving order"))
self.app.launcher.SearchToolItem.set_tooltip(
_("Search for stock items"))
self.check_open_inventory()
self._update_widgets()
def setup_focus(self):
self.search.refresh()
def deactivate(self):
self.uimanager.remove_ui(self.stock_ui)
def new_activate(self):
if not self.NewReceiving.get_sensitive():
warning(_("You cannot receive a purchase with an open inventory."))
return
self._receive_purchase()
def search_activate(self):
self.run_dialog(ProductStockSearch, self.store)
def set_open_inventory(self):
self.set_sensitive(self._inventory_widgets, False)
#
# SearchableAppWindow
#
def create_filters(self):
self.executer.set_query(self._query)
self.set_text_field_columns(['description'])
self.branch_filter = ComboSearchFilter(
_('Show by:'), self._get_branches())
self.branch_filter.select(api.get_current_branch(self.store))
self.add_filter(self.branch_filter, position=SearchFilterPosition.TOP)
def get_columns(self):
return [SearchColumn('code', title=_('Code'), sorted=True,
sort_func=sort_sellable_code,
data_type=str, width=130),
SearchColumn('barcode', title=_("Barcode"), data_type=str,
width=130),
SearchColumn('category_description', title=_("Category"),
data_type=str, width=100, visible=False),
SearchColumn('description', title=_("Description"),
data_type=str, expand=True,
ellipsize=pango.ELLIPSIZE_END),
SearchColumn('manufacturer', title=_("Manufacturer"),
data_type=str, visible=False),
SearchColumn('model', title=_("Model"),
data_type=str, visible=False),
SearchColumn('location', title=_("Location"), data_type=str,
width=100, visible=False),
Column('stock', title=_('Quantity'),
data_type=decimal.Decimal, width=100),
SearchColumn('unit', title=_("Unit"), data_type=str,
width=40, visible=False),
Column('has_image', title=_('Picture'),
data_type=bool, width=80),
]
#
# Private API
#
def _query(self, store):
branch = self.branch_filter.get_state().value
return self.search_table.find_by_branch(store, branch)
def _get_branches(self):
items = [(b.person.name, b)
for b in self.store.find(Branch)]
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):
branch = api.get_current_branch(self.store)
is_main_branch = self.branch_filter.get_state().value is branch
item = self.results.get_selected()
sellable = item and item.product.sellable
if sellable:
if sellable.has_image:
thumbnail = sellable.image.thumbnail
pixbuf = self.pixbuf_converter.from_string(thumbnail)
else:
pixbuf = None
self._update_edit_image(pixbuf)
if self.image_viewer:
self.image_viewer.set_sellable(sellable)
else:
self._update_edit_image()
self.set_sensitive([self.EditProduct], bool(item))
self.set_sensitive([self.ProductStockHistory],
bool(item) and is_main_branch)
# We need more than one branch to be able to do transfers
# Note that 'all branches' is not a real branch
has_branches = len(self.branch_filter.combo) > 2
transfer_active = self.NewTransfer.get_sensitive()
self.set_sensitive([self.NewTransfer],
transfer_active and has_branches)
self.set_sensitive([self.SearchTransfer], has_branches)
def _update_edit_image(self, pixbuf=None):
if not pixbuf:
self.image.set_from_stock(gtk.STOCK_EDIT,
gtk.ICON_SIZE_LARGE_TOOLBAR)
return
# FIXME: get this icon size from settings
icon_size = 24
pixbuf = pixbuf.scale_simple(icon_size, icon_size,
gtk.gdk.INTERP_BILINEAR)
self.image.set_from_pixbuf(pixbuf)
def _update_filter_slave(self, slave):
self.refresh()
def _transfer_stock(self):
if self.check_open_inventory():
return
store = api.new_store()
model = self.run_dialog(StockTransferWizard, store)
store.confirm(model)
store.close()
self.search.refresh()
def _receive_purchase(self):
if self.check_open_inventory():
return
store = api.new_store()
model = self.run_dialog(ReceivingOrderWizard, store)
store.confirm(model)
store.close()
self.search.refresh()
#
# Callbacks
#
def on_image_viewer_closed(self, window, event):
self.StockPictureViewer.props.active = False
self.image_viewer = None
def on_results__has_rows(self, results, product):
self._update_widgets()
def on_results__selection_changed(self, results, product):
self._update_widgets()
def on_results__right_click(self, results, result, event):
self.popup.popup(None, None, None, event.button, event.time)
def on_ProductStockHistory__activate(self, button):
selected = self.results.get_selected()
sellable = selected.sellable
self.run_dialog(ProductStockHistoryDialog, self.store, sellable,
branch=self.branch_filter.combo.get_selected())
def on_EditProduct__activate(self, button):
selected = self.results.get_selected()
assert selected
store = api.new_store()
product = store.fetch(selected.product)
model = self.run_dialog(ProductStockEditor, store, product)
store.confirm(model)
store.close()
# Stock
def on_NewReceiving__activate(self, button):
self._receive_purchase()
def on_NewTransfer__activate(self, button):
self._transfer_stock()
def on_NewStockDecrease__activate(self, action):
if self.check_open_inventory():
return
store = api.new_store()
model = self.run_dialog(StockDecreaseWizard, store)
store.confirm(model)
store.close()
self.search.refresh()
def on_StockInitial__activate(self, action):
if self.check_open_inventory():
return
branch = self.branch_filter.get_state().value
store = api.new_store()
retval = self.run_dialog(InitialStockDialog, store, branch)
store.confirm(retval)
store.close()
self.search.refresh()
def on_StockPictureViewer__activate(self, button):
if self.image_viewer:
self.StockPictureViewer.props.active = False
self.image_viewer.destroy()
self.image_viewer = None
else:
self.StockPictureViewer.props.active = True
self.image_viewer = SellableImageViewer()
selected = self.results.get_selected()
if selected:
self.image_viewer.set_sellable(selected.product.sellable)
self.image_viewer.toplevel.connect(
"delete-event", self.on_image_viewer_closed)
self.image_viewer.toplevel.set_property("visible", True)
# Loan
def on_LoanNew__activate(self, action):
if self.check_open_inventory():
return
store = api.new_store()
model = self.run_dialog(NewLoanWizard, store)
store.confirm(model)
store.close()
self.search.refresh()
def on_LoanClose__activate(self, action):
if self.check_open_inventory():
return
store = api.new_store()
model = self.run_dialog(CloseLoanWizard, store)
store.confirm(model)
store.close()
self.search.refresh()
def on_LoanSearch__activate(self, action):
self.run_dialog(LoanSearch, self.store)
def on_LoanSearchItems__activate(self, action):
self.run_dialog(LoanItemSearch, self.store)
# Search
def on_SearchPurchaseReceiving__activate(self, button):
self.run_dialog(PurchaseReceivingSearch, self.store)
def on_SearchTransfer__activate(self, action):
self.run_dialog(TransferOrderSearch, self.store)
def on_SearchPurchasedStockItems__activate(self, action):
self.run_dialog(PurchasedItemsSearch, self.store)
def on_SearchStockItems__activate(self, action):
self.run_dialog(ProductStockSearch, self.store)
def on_SearchClosedStockItems__activate(self, action):
self.run_dialog(ProductClosedStockSearch, self.store)
def on_SearchProductHistory__activate(self, action):
self.run_dialog(ProductSearchQuantity, self.store)
def on_SearchStockDecrease__activate(self, action):
self.run_dialog(StockDecreaseSearch, self.store)