def create_filters(self): 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'])
def create_filters(self): # 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): 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) executer = self.search.get_query_executer() executer.add_filter_query_callback(status_filter, self._get_status_query) self.search.add_filter(status_filter, SearchFilterPosition.TOP)
def create_sellable_filter(self, label=None): from stoqlib.domain.sellable import Sellable items = [(desc, status) for status, desc in Sellable.statuses.items()] items.insert(0, (_(u"Any"), None)) if label is None: label = _('With status:') sellable_filter = ComboSearchFilter(label, items) # Select status available by default sellable_filter.select(Sellable.STATUS_AVAILABLE) return sellable_filter
def create_filters(self): self.set_text_field_columns(['description', 'identifier_str']) executer = self.search.get_query_executer() 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_filters(self): 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']) if self._birth_date: birthday_filter = self.search.add_filter_by_attribute( 'birth_date', _('Birthday'), datetime.date, callback=self.birthday_search) # FIXME: The fifth position is a search by day. This is done # elsewhere too but we should not hardcode it. Try to # find a better solution in the future and fix everything birthday_filter.mode.select_item_by_position(5) birthday_filter.start_date.set_date(self._birth_date) self.search.refresh()
class ProductionItemsSearch(ProductSearch): title = _(u'Production Items') search_spec = ProductionItemView report_class = ProductionItemReport csv_data = None has_print_price_button = False text_field_columns = [ProductionItemView.description, ProductionItemView.order_identifier_str] def __init__(self, store, hide_footer=True, hide_toolbar=True): ProductSearch.__init__(self, store, hide_footer=hide_footer, hide_toolbar=hide_toolbar) # # SearchDialog # def create_filters(self): 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 [IdentifierColumn('order_identifier', title=_(u"Order #"), sorted=True), 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)]
def create_branch_filter(self, label=None, column=None): """Returns a new branch filter. :param label: The label to be used for the filter :param column: When provided, besides creating the filter, we will also add it to the interface, filtering by the informed column. """ items = api.get_branches_for_filter(self.store, use_id=True) if not label: label = _('Branch:') if column and not isinstance(column, list): column = [column] branch_filter = ComboSearchFilter(label, items) current = api.get_current_branch(self.store) branch_filter.select(current.id) if column: self.add_filter(branch_filter, columns=column, position=SearchFilterPosition.TOP) return branch_filter
class TransferOrderSearch(SearchDialog): title = _(u"Transfer Order Search") size = (750, 500) search_spec = TransferOrderView report_class = TransferOrderReport selection_mode = Gtk.SelectionMode.MULTIPLE def __init__(self, store): SearchDialog.__init__(self, store) self._setup_widgets() def _show_transfer_order_details(self, order_view): transfer_order = order_view.transfer_order with api.new_store() as store: model = store.fetch(transfer_order) run_dialog(TransferOrderDetailsDialog, self, store, model) store.retval = store.get_pending_count() > 0 def _setup_widgets(self): self.results.connect('row_activated', self.on_row_activated) self.update_widgets() def _get_status_values(self): items = [(str(value), key) for key, value in TransferOrder.statuses.items()] items.insert(0, (_('Any'), None)) return items # # SearchDialog Hooks # def update_widgets(self): orders = self.results.get_selected_rows() has_one_selected = len(orders) == 1 self.set_details_button_sensitive(has_one_selected) self.set_print_button_sensitive(has_one_selected) def create_filters(self): self.set_text_field_columns([ 'source_branch_name', 'destination_branch_name', 'identifier_str' ]) # Date self.date_filter = DateSearchFilter(_('Date:')) self.add_filter(self.date_filter, columns=['open_date', 'finish_date']) # Status self.status_filter = ComboSearchFilter(_('With status:'), self._get_status_options()) self.status_filter.select('pending') executer = self.search.get_query_executer() executer.add_filter_query_callback(self.status_filter, self._get_status_query) self.add_filter(self.status_filter, position=SearchFilterPosition.TOP) def _get_status_options(self): return [ (_('All transfers'), None), (_('Pending receive'), 'pending'), (_('Received'), 'received'), (_('Sent'), 'sent'), (_('Cancelled'), 'cancelled'), ] def _get_status_query(self, state): current_branch = api.get_current_branch(self.store) if state.value == 'pending': return And( TransferOrder.status == TransferOrder.STATUS_SENT, TransferOrder.destination_branch_id == current_branch.id) elif state.value == 'received': return And( TransferOrder.status == TransferOrder.STATUS_RECEIVED, TransferOrder.destination_branch_id == current_branch.id) elif state.value == 'sent': return And( TransferOrder.source_branch_id == current_branch.id, Not(TransferOrder.status == TransferOrder.STATUS_CANCELLED)) elif state.value == 'cancelled': return And(TransferOrder.status == TransferOrder.STATUS_CANCELLED, TransferOrder.source_branch_id == current_branch.id) else: return Or(TransferOrder.source_branch_id == current_branch.id, TransferOrder.destination_branch_id == current_branch.id) def get_columns(self): return [ IdentifierColumn('identifier', title=_('Transfer #')), SearchColumn('transfer_order.status_str', _('Status'), data_type=str, valid_values=self._get_status_values(), search_attribute='status', width=100), SearchColumn('open_date', _('Open date'), data_type=datetime.date, sorted=True, width=100), SearchColumn('finish_date', _('Finish Date'), data_type=datetime.date, width=100, visible=False), SearchColumn('source_branch_name', _('Source'), data_type=str, expand=True), SearchColumn('destination_branch_name', _('Destination'), data_type=str, width=220), Column('total_items', _('Items'), data_type=Decimal, format_func=format_quantity, width=110) ] # # Callbacks # def on_row_activated(self, klist, view): self._show_transfer_order_details(view) def on_details_button_clicked(self, button): self._show_transfer_order_details(self.results.get_selected_rows()[0])
class StockApp(ShellApp): app_title = _('Stock') gladefile = "stock" search_spec = ProductFullStockView search_labels = _('Matching:') report_table = SimpleProductReport pixbuf_converter = converter.get_converter(GdkPixbuf.Pixbuf) # # Application # def create_actions(self): group = get_accels('app.stock') actions = [ ("NewReceiving", None, _("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")), ("SearchBrandItems", None, _("Brand items..."), group.get('search_brand_items'), _("Search for brand items on stock")), ("SearchBrandItemsByBranch", None, _("Brand item by branch..."), group.get('search_brand_by_branch'), _("Search for brand items by branch on stock")), ("SearchBatchItems", None, _("Batch items..."), group.get('search_batch_items'), _("Search for batch items on stock")), ("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...")), ("SearchTransferItems", None, _("Transfer items...")), ("SearchReturnedItems", None, _("Returned items...")), ("SearchPendingReturnedSales", None, _("Pending returned sales...")), ("ProductMenu", None, _("Product")), ("PrintLabels", None, _("Print labels...")), ("ManageStock", None, _("Manage stock...")), ("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) toggle_actions = [ ('StockPictureViewer', None, _('Picture viewer'), group.get('toggle_picture_viewer')), ] self.add_ui_actions(toggle_actions, 'ToggleActions') self.set_help_section(_("Stock help"), 'app-stock') def create_ui(self): if api.sysparam.get_bool('SMART_LIST_LOADING'): self.search.enable_lazy_search() self.window.add_print_items([self.PrintLabels]) self.window.add_export_items() self.window.add_extra_items( [self.StockInitial, self.LoanClose, self.StockPictureViewer]) self.window.add_new_items([ self.NewReceiving, self.NewTransfer, self.NewStockDecrease, self.LoanNew ]) self.window.add_search_items([ self.SearchPurchaseReceiving, self.SearchProductHistory, self.SearchTransfer, self.SearchTransferItems, self.SearchStockDecrease, self.SearchReturnedItems, self.SearchPurchasedStockItems, self.SearchStockItems, self.SearchBrandItems, self.SearchBrandItemsByBranch, self.SearchBatchItems, self.SearchClosedStockItems, self.SearchPendingReturnedSales, # Separator self.LoanSearch, self.LoanSearchItems, ]) 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() # FIXME: How are we goint to display an image preview? #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 get_domain_options(self): options = [ ('fa-info-circle-symbolic', _('History'), 'stock.ProductStockHistory', True), ('fa-edit-symbolic', _('Edit'), 'stock.EditProduct', True), ('', _('Print labels'), 'stock.PrintLabels', False), ('', _('Manage stock'), 'stock.ManageStock', False), ] return options def activate(self, refresh=True): if refresh: self.refresh() open_inventory = self.check_open_inventory() if not open_inventory: self.transfers_bar = self._create_pending_info_message() self.returned_bar = self._create_pending_returned_sale_message() else: self.transfers_bar = None self.returned_bar = None self._update_widgets() self.search.focus_search_entry() def deactivate(self): if self.transfers_bar: self.transfers_bar.hide() if self.returned_bar: self.returned_bar.hide() self._close_image_viewer() def set_open_inventory(self): self.set_sensitive(self._inventory_widgets, False) def create_filters(self): self.search.set_query(self._query) self.set_text_field_columns([ 'description', 'code', 'barcode', 'category_description', 'manufacturer' ]) branches = Branch.get_active_branches(self.store) self.branch_filter = ComboSearchFilter( _('Show by:'), api.for_combo(branches, empty=_("All 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.EllipsizeMode.END), SearchColumn('manufacturer', title=_("Manufacturer"), data_type=str, visible=False), SearchColumn('brand', title=_("Brand"), 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), QuantityColumn('stock', title=_('Quantity'), width=100, use_having=True), SearchColumn('has_image', title=_('Picture'), data_type=bool, width=80), ] # # Private API # def _open_image_viewer(self): assert self.image_viewer is None self.image_viewer = SellableImageViewer(size=(325, 325)) self.image_viewer.toplevel.connect('delete-event', self.on_image_viewer_closed) self.image_viewer.show_all() self._update_widgets() def _close_image_viewer(self): if self.image_viewer is None: return self.image_viewer.destroy() self.image_viewer = None def _query(self, store): branch = self.branch_filter.get_state().value return self.search_spec.find_by_branch(store, branch) 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 item.has_image: # XXX:Workaround for a bug caused by the image domain refactoring # which left some existent thumbnail as None thumbnail = sellable.image.thumbnail if thumbnail is None: # Create new store to create the thumbnail with api.new_store() as new_store: image = sellable.image image = new_store.fetch(image) size = (Image.THUMBNAIL_SIZE_WIDTH, Image.THUMBNAIL_SIZE_HEIGHT) image.thumbnail = get_thumbnail(image.image, size) thumbnail = 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() # Always let the user choose the manage stock option and do a proper # check there (showing a warning if he can't) self.set_sensitive([self.ManageStock], bool(item)) self.set_sensitive([self.EditProduct, self.PrintLabels], 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_enabled() self.set_sensitive([self.NewTransfer], transfer_active and has_branches) # Building a list of searches that we must disable if there is no # branches other than the main company searches = [ self.SearchTransfer, self.SearchTransferItems, self.SearchPendingReturnedSales ] self.set_sensitive(searches, has_branches) def _update_edit_image(self, pixbuf=None): if not pixbuf: self.image.set_from_stock(Gtk.STOCK_EDIT, Gtk.IconSize.LARGE_TOOLBAR) return # FIXME: get this icon size from settings icon_size = 24 pixbuf = pixbuf.scale_simple(icon_size, icon_size, GdkPixbuf.InterpType.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.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.refresh() def _create_pending_info_message(self): branch = api.get_current_branch(self.store) n_transfers = TransferOrder.get_pending_transfers(self.store, branch).count() if not n_transfers: return None msg = stoqlib_ngettext(_(u"You have %s incoming transfer"), _(u"You have %s incoming transfers"), n_transfers) % n_transfers info_bar = self.window.add_info_bar(Gtk.MessageType.QUESTION, msg) button = info_bar.add_button(_(u"Receive"), Gtk.ResponseType.OK) button.connect('clicked', self._on_info_transfers__clicked) return info_bar def _create_pending_returned_sale_message(self): branch = api.get_current_branch(self.store) n_returned = ReturnedSale.get_pending_returned_sales( self.store, branch).count() if not n_returned: return None msg = stoqlib_ngettext(_(u"You have %s returned sale to receive"), _(u"You have %s returned sales to receive"), n_returned) % n_returned info_returned_bar = self.window.add_info_bar(Gtk.MessageType.QUESTION, msg) button = info_returned_bar.add_button(_(u"Returned sale"), Gtk.ResponseType.OK) button.connect('clicked', self._on_info_returned_sales__clicked) return info_returned_bar def _search_transfers(self): branch = api.get_current_branch(self.store) self.run_dialog(TransferOrderSearch, self.store) # After the search is closed we may want to update , or even hide the # message, if there is no pending transfer to receive if self.transfers_bar: n_transfers = TransferOrder.get_pending_transfers( self.store, branch).count() if n_transfers > 0: msg = stoqlib_ngettext(_(u"You have %s incoming transfer"), _(u"You have %s incoming transfers"), n_transfers) % n_transfers self.transfers_bar.set_message(msg) else: self.transfers_bar.hide() self.refresh() def _search_pending_returned_sales(self): with api.new_store() as store: self.run_dialog(PendingReturnedSaleSearch, store) branch = api.get_current_branch(self.store) # After the search is closed we may want to update , or even hide the # message, if there is no pending returned sale to receive if self.returned_bar: n_returned = ReturnedSale.get_pending_returned_sales( self.store, branch).count() if n_returned > 0: msg = stoqlib_ngettext( _(u"You have %s returned sale to receive"), _(u"You have %s returned sales to receive"), n_returned) % n_returned self.returned_bar.set_message(msg) else: self.returned_bar.hide() self.refresh() # # Callbacks # def on_image_viewer_closed(self, window, event): self.image_viewer = None self.StockPictureViewer.set_state(GLib.Variant.new_boolean(False)) def on_results__has_rows(self, results, product): self._update_widgets() def on_results__selection_changed(self, results, product): self._update_widgets() 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_ManageStock__activate(self, action): user = api.get_current_user(self.store) if not user.profile.check_app_permission(u'inventory'): return warning( _('Only users with access to the inventory app can' ' change the stock quantity')) product = self.results.get_selected().product if product.is_grid: return warning(_("Can't change stock quantity of a grid parent")) if product.storable and product.storable.is_batch: return warning( _("It's not possible to change the stock quantity of" " a batch product")) branch = self.branch_filter.combo.get_selected() if not branch: return warning(_('You must select a branch first')) with api.new_store() as store: self.run_dialog(ProductStockQuantityEditor, store, store.fetch(product), branch=branch) if store.committed: self.refresh() def on_PrintLabels__activate(self, button): selected = self.results.get_selected() sellable = selected.sellable label_data = self.run_dialog(PrintLabelEditor, None, self.store, sellable) if label_data: print_labels(label_data, self.store) 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() if model: self.refresh() def _on_info_transfers__clicked(self, button): self._search_transfers() def _on_info_returned_sales__clicked(self, button): self._search_pending_returned_sales() # 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.refresh() def on_StockInitial__activate(self, action): if self.check_open_inventory(): return with api.new_store() as store: self.run_dialog(InitialStockDialog, store) if store.committed: self.refresh() def on_StockPictureViewer__change_state(self, action, value): action.set_state(value) if value.get_boolean(): self._open_image_viewer() else: self._close_image_viewer() # 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.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.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._search_transfers() def on_SearchTransferItems__activate(self, action): self.run_dialog(TransferItemSearch, self.store) def on_SearchPendingReturnedSales__activate(self, action): self._search_pending_returned_sales() def on_SearchReturnedItems__activate(self, action): self.run_dialog(ReturnedItemSearch, 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_SearchBrandItems__activate(self, action): self.run_dialog(ProductBrandSearch, self.store) def on_SearchBrandItemsByBranch__activate(self, action): self.run_dialog(ProductBrandByBranchSearch, self.store) def on_SearchBatchItems__activate(self, action): self.run_dialog(ProductBatchSearch, 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)
class DeliverySearch(SearchEditor): """Delivery search implementation""" title = _('Delivery Search') search_spec = DeliveryView editor_class = DeliveryEditor has_new_button = False size = (750, 450) # # Private # def _get_status_values(self): items = [(value, key) for key, value in Delivery.statuses.items()] items.insert(0, (_('Any'), None)) return items # # SearchEditor # def create_filters(self): self.set_text_field_columns([ 'tracking_code', 'transporter_name', 'recipient_name', 'identifier_str' ]) # 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 [ IdentifierColumn('identifier', title=_('Sale #'), order=Gtk.SortType.DESCENDING, sorted=True), 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.EllipsizeMode.END), SearchColumn('tracking_code', title=_('Tracking code'), data_type=str), SearchColumn('transporter_name', title=_('Transporter'), data_type=str), SearchColumn('recipient_name', title=_('Recipient'), data_type=str), SearchColumn('open_date', title=_('Open date'), data_type=datetime.date, visible=False), SearchColumn('send_date', title=_('Sent date'), data_type=datetime.date, visible=False), SearchColumn('receive_date', title=_('Received date'), data_type=datetime.date, visible=False), ]
class InventoryApp(ShellApp): # TODO: Change all widget.set_sensitive to self.set_sensitive([widget]) app_title = _('Inventory') gladefile = "inventory" search_spec = Inventory search_labels = _('Matching:') report_table = InventoryReport # # Application # def create_actions(self): group = get_accels('app.inventory') actions = [ # File ('NewInventory', None, _('Inventory...'), group.get('new_inventory'), _('Create a new inventory for product counting')), # Inventory ('Details', Gtk.STOCK_INFO, _('Details...'), group.get('inventory_details'), _('See details about this inventory')), ('CountingAction', Gtk.STOCK_INDEX, _('_Count...'), group.get('inventory_count'), _('Register the actual stock of products in the selected ' 'inventory')), ('AdjustAction', Gtk.STOCK_CONVERT, _('_Adjust...'), group.get('inventory_adjust'), _('Adjust the stock accordingly to the counting in the selected ' 'inventory')), ('Cancel', Gtk.STOCK_CANCEL, _('Cancel...'), group.get('inventory_cancel'), _('Cancel the selected inventory')), ('Export', Gtk.STOCK_SAVE, _('Export for external counting...'), None, _('Export the list of products for external counting')), ('PrintProductListing', Gtk.STOCK_PRINT, _('Print product listing...'), group.get('inventory_print'), _('Print the product listing for this inventory')) ] self.inventory_ui = self.add_ui_actions(actions) self.set_help_section(_("Inventory help"), 'app-inventory') def create_ui(self): self.window.add_new_items([self.NewInventory]) self.window.add_print_items([self.PrintProductListing]) self.window.add_export_items([self.Export]) def activate(self, refresh=True): if refresh: # Avoid letting this sensitive if has-rows is never emitted self.refresh() self._update_widgets() self.search.focus_search_entry() def create_filters(self): # Disable string search right now, until we use a proper Viewable # for this application self.search.disable_search_entry() self.branch_filter = ComboSearchFilter(_('Show inventories at:'), self._get_branches_for_filter()) current = api.get_current_branch(self.store) self.branch_filter.select(current.id) self.add_filter(self.branch_filter, SearchFilterPosition.TOP, columns=["branch_id"]) def get_domain_options(self): options = [ ('fa-info-circle-symbolic', _('Details'), 'inventory.Details', True), ('fa-list-ol-symbolic', _('Count'), 'inventory.CountingAction', True), ('fa-tasks-symbolic', _('Adjust'), 'inventory.AdjustAction', True), ('fa-ban-symbolic', _('Cancel'), 'inventory.Cancel', True), ] return options def get_columns(self): return [ IdentifierColumn('identifier', title=_('Inventory #'), sorted=True, order=Gtk.SortType.DESCENDING), SearchColumn('status_str', title=_('Status'), data_type=str, width=100, valid_values=self._get_status_values(), search_attribute='status'), Column('branch.description', 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=_('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 self.store.find(Branch) def _get_branches_for_filter(self): items = [(b.get_description(), 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 selected = self.results.get_selected() if selected: all_counted = selected.all_items_counted() has_open = selected.is_open() has_adjusted = selected.has_adjusted_items() self.set_sensitive([self.PrintProductListing, self.Details], bool(selected)) self.set_sensitive([self.Cancel], has_open and not has_adjusted) self.set_sensitive([self.NewInventory], self._can_open()) self.set_sensitive([self.CountingAction], has_open and not all_counted) self.set_sensitive([self.AdjustAction], has_open and all_counted) def _can_open(self): branch = api.get_current_branch(self.store) if Inventory.has_open(self.store, branch): return False # It doesn't make sense to open an inventory if we don't have any stock return self.store.find(ProductStockItem, branch=branch).count() > 0 def _open_inventory(self): with api.new_store() as store: rv = self.run_dialog(InventoryOpenEditor, store) if rv: self.refresh() self._update_widgets() def _cancel_inventory(self): if not yesno(_('Are you sure you want to cancel this inventory ?'), Gtk.ResponseType.NO, _("Cancel inventory"), _("Don't cancel")): return store = api.new_store() inventory = store.fetch(self.results.get_selected()) inventory.cancel() store.commit() store.close() self.refresh() self._update_widgets() def _export_product_list(self): filename = save(_("Save products file"), self.get_toplevel(), "%s.txt" % (_('products'))) if not filename: return tables = [ Sellable, Join(Storable, Storable.id == Sellable.id), ] sellables = self.store.using(*tables).find(Sellable) with open(filename, 'w') as fh: for sellable in sellables: # TODO: Add a dialog for the user to choose the format for # exporting fh.write('%-20s%s\n' % (sellable.barcode, sellable.description)) def _register_product_counting(self): store = api.new_store() inventory = store.fetch(self.results.get_selected()) model = self.run_dialog(InventoryCountWizard, store, inventory) store.confirm(model) store.close() self.refresh() self._update_widgets() def _adjust_product_quantities(self): store = api.new_store() inventory = store.fetch(self.results.get_selected()) model = self.run_dialog(InventoryAdjustmentEditor, store, inventory) store.confirm(model) store.close() self.refresh() 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 def _show_inventory_details(self): store = api.new_store() inventory = store.fetch(self.results.get_selected()) self.run_dialog(InventoryDetailsDialog, store, inventory) store.close() # # Callbacks # def on_NewInventory__activate(self, action): self._open_inventory() def on_CountingAction__activate(self, action): self._register_product_counting() def on_AdjustAction__activate(self, action): self._adjust_product_quantities() def on_Details__activate(self, action): self._show_inventory_details() def on_results__selection_changed(self, results, product): self._update_widgets() def on_results__double_click(self, results, inventory): self._show_inventory_details() def on_Cancel__activate(self, widget): self._cancel_inventory() def on_Export__activate(self, widget): self._export_product_list() def on_PrintProductListing__activate(self, button): selected = self.results.get_selected() sellables = list(self._get_sellables_by_inventory(selected)) if not sellables: warning(_("No products found in the inventory.")) return self.print_report(ProductCountingReport, sellables)