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']) # 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(['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_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 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 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']) 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)
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(), )
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
def create_main_filter(self): self.main_filter = ComboSearchFilter(_('Show'), []) combo = self.main_filter.combo combo.color_attribute = 'color' combo.set_row_separator_func(self._on_main_filter__row_separator_func) self._update_filter_items() self.executer.add_filter_query_callback( self.main_filter, self._on_main_filter__query_callback) self.add_filter(self.main_filter, SearchFilterPosition.TOP)
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 _create_filters(self): categories = [(c.name, c.id) for c in Category.select()] categories.insert(0, ('Any', None)) self.category_filter = ComboSearchFilter( 'Category:', categories) self.search.add_filter( self.category_filter, SearchFilterPosition.TOP, ['categoryID']) self.search.set_text_field_columns(['title']) self.search.add_filter(DateSearchFilter('Date:'), columns=['date'])
def create_filters(self): self.set_text_field_columns(['equipment', 'client_name']) self.main_filter = ComboSearchFilter(_('Show'), []) combo = self.main_filter.combo combo.color_attribute = 'color' combo.set_row_separator_func(self._on_main_filter__row_separator_func) self.executer.add_filter_query_callback( self.main_filter, self._on_main_filter__query_callback) self.add_filter(self.main_filter, SearchFilterPosition.TOP) self._update_filters()
class TaskViewer(gtk.Window): def __init__(self): gtk.Window.__init__(self) self.set_title('Tasks') self.search = SearchContainer(self.get_columns()) self.add(self.search) self._setup_searching() self._create_filters() def _setup_searching(self): self.query = SQLObjectQueryExecuter() self.query.set_query(self._executer_query) self.search.set_query_executer(self.query) self.query.set_table(Task) def _create_filters(self): categories = [(c.name, c.id) for c in Category.select()] categories.insert(0, ('Any', None)) self.category_filter = ComboSearchFilter( 'Category:', categories) self.search.add_filter( self.category_filter, SearchFilterPosition.TOP, ['categoryID']) self.search.set_text_field_columns(['title']) self.search.add_filter(DateSearchFilter('Date:'), columns=['date']) def _executer_query(self, query, conn): category_id = self.category_filter.get_state().value if category_id is not None: query = AND(Category.q.id == category_id, query) return Task.select(query) def get_columns(self): return [ Column('title', data_type=str, title='Title', expand=True), Column('category.name', title='Category'), Column('date', data_type=datetime.date, width=90) ]
class MaintenanceApp(SearchableAppWindow): """Maintenance app""" app_name = _(u'Maintenance') gladefile = 'maintenance' search_table = WorkOrderView search_label = _(u'matching:') report_table = WorkOrdersReport embedded = True _status_mapper = { 'pending': Or(WorkOrder.status == WorkOrder.STATUS_OPENED, WorkOrder.status == WorkOrder.STATUS_APPROVED), 'in-progress': WorkOrder.status == WorkOrder.STATUS_WORK_IN_PROGRESS, 'finished': WorkOrder.status == WorkOrder.STATUS_WORK_FINISHED, 'closed': Or(WorkOrder.status == WorkOrder.STATUS_CANCELLED, WorkOrder.status == WorkOrder.STATUS_CLOSED), } # # Application # def create_actions(self): group = get_accels('app.maintenance') actions = [ # File ("OrderMenu", None, _(u"Order")), ("NewOrder", None, _(u"Work order..."), group.get("new_order")), # Search ("Products", None, _(u"Products..."), group.get("search_products")), ("Services", None, _(u"Services..."), group.get("search_services")), ("Categories", None, _(u"Categories..."), group.get("search_categories")), # Order ("Edit", gtk.STOCK_EDIT, _(u"Edit..."), group.get('order_edit'), _(u"Edit the selected order")), ("Finish", gtk.STOCK_APPLY, _(u"Finish..."), group.get('order_finish'), _(u"Finish the selected order")), ("Cancel", gtk.STOCK_CANCEL, _(u"Cancel..."), group.get('order_cancel'), _(u"Cancel the selected order")), ("Details", gtk.STOCK_INFO, _(u"Details..."), group.get('order_details'), _(u"Show details of the selected order")), ("PrintQuote", None, _(u"Print quote..."), group.get('order_print_quote'), _(u"Print a quote report of the selected order")), ("PrintReceipt", None, _(u"Print receipt..."), group.get('order_print_receipt'), _(u"Print a receipt of the selected order")), ] self.maintenance_ui = self.add_ui_actions("", actions, filename="maintenance.xml") self.Edit.set_short_label(_(u"Edit")) self.Finish.set_short_label(_(u"Finish")) self.Edit.props.is_important = True self.Finish.props.is_important = True self.set_help_section(_(u"Maintenance help"), 'app-maintenance') self.popup = self.uimanager.get_widget('/MaintenanceSelection') def create_ui(self): if api.sysparam(self.store).SMART_LIST_LOADING: self.search.search.enable_lazy_search() self.app.launcher.add_new_items([ self.NewOrder, ]) self.app.launcher.add_search_items([ self.Products, self.Services, self.Categories, ]) self.search.set_summary_label( column='total', label=('<b>%s</b>' % api.escape(_('Total:'))), format='<b>%s</b>', parent=self.get_statusbar_message_area()) self.results.set_cell_data_func(self._on_results__cell_data_func) def activate(self, params): self.app.launcher.NewToolItem.set_tooltip( _(u"Create a new work order")) self.app.launcher.SearchToolItem.set_tooltip( _(u"Search for work order categories")) self._update_view() def deactivate(self): self.uimanager.remove_ui(self.maintenance_ui) def setup_focus(self): self.search.refresh() def new_activate(self): self._new_order() def search_activate(self): self.run_dialog(ProductSearch, self.store, hide_footer=True, hide_toolbar=True) def search_completed(self, results, states): if len(results): return base_msg = '' url_msg = '' state = states[1] if state and state.value is None: # Base search with no filters base_msg = _(u"No work orders could be found.") url = u"<a href='new_order'>%s</a>" % ( api.escape(_(u"create a new work order")), ) url_msg = _(u"Would you like to %s ?") % (url, ) else: kind, value = state.value.value.split(':') # Search filtering by status if kind == 'status': if value == 'pending': base_msg = _(u"No pending work orders could be found.") elif value == 'in-progress': base_msg = _(u"No work orders in progress could be found.") elif value == 'finished': base_msg = _(u"No finished work orders could be found.") elif value == 'closed': base_msg = _(u"No closed or cancelled work " u"orders could be found.") # Search filtering by category elif kind == 'category': base_msg = _(u"No work orders in the category %s " u"could be found.") % ( '<b>%s</b>' % (value, ), ) url = u"<a href='new_order?%s'>%s</a>" % ( urllib.quote(value.encode('utf-8')), api.escape(_(u"create a new work order")), ) url_msg = _(u"Would you like to %s ?") % (url, ) if not base_msg: return msg = '\n\n'.join([base_msg, url_msg]) self.search.set_message(msg) # # SearchableAppWindow # def create_filters(self): self.set_text_field_columns(['equipment', 'client_name']) self.main_filter = ComboSearchFilter(_('Show'), []) combo = self.main_filter.combo combo.color_attribute = 'color' combo.set_row_separator_func(self._on_main_filter__row_separator_func) self.executer.add_filter_query_callback( self.main_filter, self._on_main_filter__query_callback) self.add_filter(self.main_filter, SearchFilterPosition.TOP) self._update_filters() def get_columns(self): return [ SearchColumn('identifier', title=_(u'#'), data_type=int, width=60, sorted=True, format='%04d'), SearchColumn('work_order.status_str', title=_(u'Status'), search_attribute='status', data_type=str, valid_values=self._get_status_values(), visible=False), SearchColumn('category_name', title=_(u'Category'), data_type=str, visible=False), SearchColumn('equipment', title=_(u'Equipment'), data_type=str, expand=True, pack_end=True), Column('category_color', title=_(u'Equipment'), column='equipment', data_type=gtk.gdk.Pixbuf, format_func=render_pixbuf), SearchColumn('client_name', title=_(u'Client'), data_type=str), SearchColumn('open_date', title=_(u'Open date'), data_type=datetime.date), SearchColumn('approve_date', title=_(u'Approval date'), data_type=datetime.date, visible=False), SearchColumn('finish_date', title=_(u'Finish date'), data_type=datetime.date, visible=False), SearchColumn('total', title=_(u'Total'), data_type=currency), ] # # Private # def _get_main_query(self, state): item = state.value if item is None: return kind, value = item.value.split(':') if kind == 'category': return WorkOrder.category_id == item.id if kind == 'status': return self._status_mapper[value] else: raise AssertionError(kind, value) def _get_status_values(self): return ([(_('Any'), None)] + [(v, k) for k, v in WorkOrder.statuses.items()]) def _update_view(self): self.search.refresh() self._update_list_aware_view() def _update_list_aware_view(self): selection = self.results.get_selected() has_selected = bool(selection) has_quote = has_selected and bool(selection.work_order.defect_detected) can_edit = (has_selected and (selection.work_order.can_approve() or selection.work_order.can_start() or selection.work_order.can_finish())) self.set_sensitive([self.Edit], can_edit) self.set_sensitive([self.Details], has_selected) self.set_sensitive([self.Finish], has_selected and selection.work_order.can_finish()) self.set_sensitive([self.Cancel], has_selected and selection.work_order.can_cancel()) self.set_sensitive([self.PrintReceipt], has_selected and selection.work_order.is_finished()) self.set_sensitive([self.PrintQuote], has_quote) def _update_filters(self): options = [ _FilterItem(_(u'Pending'), 'status:pending'), _FilterItem(_(u'In progress'), 'status:in-progress'), _FilterItem(_(u'Finished'), 'status:finished'), _FilterItem(_(u'Closed or cancelled'), 'status:closed'), ] categories = list(self.store.find(WorkOrderCategory)) if len(categories): options.append(_FilterItem('sep', 'sep')) for category in categories: value = 'category:%s' % (category.name, ) options.append(_FilterItem(category.name, value, color=category.color, obj_id=category.id)) self.main_filter.update_values( [(_(u'All work orders'), None)] + [(item.name, item) for item in options]) def _new_order(self, category=None): with api.trans() as store: self.run_dialog(WorkOrderEditor, store, category=store.fetch(category)) if store.committed: self._update_view() # A category may have been created on the editor self._update_filters() def _edit_order(self): selection = self.results.get_selected() with api.trans() as store: self.run_dialog(WorkOrderEditor, store, model=store.fetch(selection.work_order)) if store.committed: self._update_view() # A category may have been created on the editor self._update_filters() def _finish_order(self): if yesno(_(u"This will finish the selected order, marking the " u"work as done. Are you sure?"), gtk.RESPONSE_NO, _(u"Don't finish"), _(u"Finish order")): return selection = self.results.get_selected() with api.trans() as store: work_order = store.fetch(selection.work_order) work_order.finish() self._update_view() def _cancel_order(self): if yesno(_(u"This will cancel the selected order. Are you sure?"), gtk.RESPONSE_NO, _(u"Don't cancel"), _(u"Cancel order")): return selection = self.results.get_selected() with api.trans() as store: work_order = store.fetch(selection.work_order) work_order.cancel() self._update_view() def _run_order_details_dialog(self): selection = self.results.get_selected() self.run_dialog(WorkOrderEditor, self.store, model=selection.work_order, visual_mode=True) def _run_order_category_dialog(self): with api.trans() as store: self.run_dialog(WorkOrderCategoryDialog, store) self._update_view() self._update_filters() # # Kiwi Callbacks # def _on_main_filter__row_separator_func(self, model, titer): if model[titer][0] == 'sep': return True return False def _on_main_filter__query_callback(self, state): return self._get_main_query(state) def _on_results__cell_data_func(self, column, renderer, wov, text): if not isinstance(renderer, gtk.CellRendererText): return text work_order = wov.work_order is_finished = work_order.status == WorkOrder.STATUS_WORK_FINISHED is_closed = work_order.status in [WorkOrder.STATUS_CANCELLED, WorkOrder.STATUS_CLOSED] is_late = work_order.is_late() for prop, is_set, value in [ ('strikethrough', is_closed, True), ('style', is_finished, pango.STYLE_ITALIC), ('weight', is_late, pango.WEIGHT_BOLD) ]: renderer.set_property(prop + '-set', is_set) if is_set: renderer.set_property(prop, value) return text def on_results__right_click(self, results, result, event): self.popup.popup(None, None, None, event.button, event.time) def on_results__row_activated(self, klist, purchase_order_view): if self.Edit.get_sensitive(): self._edit_order() elif self.Details.get_sensitive(): self._run_order_details_dialog() else: assert False def _on_results__double_click(self, results, order): if self.Edit.get_sensitive(): self._edit_order() elif self.Details.get_sensitive(): self._run_order_details_dialog() else: assert False def on_results__selection_changed(self, results, selected): self._update_list_aware_view() def on_results__activate_link(self, results, uri): if not uri.startswith('new_order'): return if '?' in uri: category_name = unicode(urllib.unquote(uri.split('?', 1)[1])) category = self.store.find(WorkOrderCategory, name=category_name).one() else: category = None self._new_order(category=category) def on_NewOrder__activate(self, action): self._new_order() def on_Edit__activate(self, action): self._edit_order() def on_Finish__activate(self, action): self._finish_order() def on_Cancel__activate(self, action): self._cancel_order() def on_Details__activate(self, action): self._run_order_details_dialog() def on_PrintQuote__activate(self, action): workorderview = self.results.get_selected() print_report(WorkOrderQuoteReport, workorderview.work_order) def on_PrintReceipt__activate(self, action): workorderview = self.results.get_selected() print_report(WorkOrderReceiptReport, workorderview.work_order) def on_Products__activate(self, action): self.run_dialog(ProductSearch, self.store, hide_footer=True, hide_toolbar=True) def on_Services__activate(self, action): self.run_dialog(ServiceSearch, self.store) def on_Categories__activate(self, action): self._run_order_category_dialog()
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)
def create_filters(self): self.set_text_field_columns(['supplier_name']) self.status_filter = ComboSearchFilter(_('Show orders'), self._get_status_values()) self.add_filter(self.status_filter, SearchFilterPosition.TOP, ['status'])
class PurchaseApp(SearchableAppWindow): # TODO: Change all widget.set_sensitive to self.set_sensitive([widget]) app_name = _('Purchase') gladefile = "purchase" search_table = PurchaseOrderView search_label = _('matching:') report_table = PurchaseReport embedded = True action_permissions = { 'ProductUnits': ('ProductUnit', PermissionManager.PERM_SEARCH), 'NewProduct': ('Product', PermissionManager.PERM_CREATE), 'Products': ('Product', PermissionManager.PERM_SEARCH), 'Services': ('Service', PermissionManager.PERM_SEARCH), } # # Application # def create_actions(self): group = get_accels('app.purchase') actions = [ # File ("OrderMenu", None, _("Order")), ("NewOrder", gtk.STOCK_NEW, _("Order..."), group.get('new_order'), _("Create a new purchase order")), ("NewQuote", gtk.STOCK_INDEX, _("Quote..."), group.get('new_quote'), _("Create a new purchase quote")), ("NewConsignment", None, _("Consignment..."), group.get('new_consignment'), _("Create a new purchase consignment")), ("NewProduct", None, _("Product..."), group.get('new_product'), _("Create a new product")), ("CloseInConsignment", None, _("Close consigment...")), # Edit ("StockCost", None, _("_Stock cost...")), # Search ("Categories", None, _("Categories..."), group.get("search_categories")), ("Products", STOQ_PRODUCTS, _("Products..."), group.get("search_products")), ("ProductUnits", None, _("Product units..."), group.get("search_product_units")), ("ProductManufacturers", None, _("Manufacturers..."), group.get("search_product_manufacturers")), ("Services", None, _("Services..."), group.get("search_services")), ("SearchStockItems", None, _("Stock items..."), group.get("search_stock_items")), ("SearchClosedStockItems", None, _("Closed stock items..."), group.get("search_closed_stock_items")), ("Suppliers", STOQ_SUPPLIERS, _("Suppliers..."), group.get("search_suppliers")), ("Transporter", None, _("Transporters..."), group.get("search_transporters")), ("SearchQuotes", None, _("Quotes..."), group.get("search_quotes")), ("SearchPurchasedItems", None, _("Purchased items..."), group.get("search_purchased_items")), ("ProductsSoldSearch", None, _("Sold products..."), group.get("search_products_sold")), ("ProductsPriceSearch", None, _("Prices..."), group.get("search_prices")), ("SearchInConsignmentItems", None, _("Search consigment items..."), group.get("search_consignment_items")), # Order ("Confirm", gtk.STOCK_APPLY, _("Confirm..."), group.get('order_confirm'), _("Confirm the selected order(s), marking it as sent to the " "supplier")), ("Cancel", gtk.STOCK_CANCEL, _("Cancel..."), group.get('order_cancel'), _("Cancel the selected order")), ("Edit", gtk.STOCK_EDIT, _("Edit..."), group.get('order_edit'), _("Edit the selected order, allowing you to change it's details")), ("Details", gtk.STOCK_INFO, _("Details..."), group.get('order_details'), _("Show details of the selected order")), ("Finish", gtk.STOCK_APPLY, _("Finish..."), group.get('order_finish'), _('Complete the selected partially received order')), ] self.purchase_ui = self.add_ui_actions("", actions, filename="purchase.xml") self.Confirm.props.is_important = True self.NewOrder.set_short_label(_("New order")) self.NewQuote.set_short_label(_("New quote")) self.Products.set_short_label(_("Products")) self.Suppliers.set_short_label(_("Suppliers")) self.Confirm.set_short_label(_("Confirm")) self.Cancel.set_short_label(_("Cancel")) self.Finish.set_short_label(_("Finish")) self.Edit.set_short_label(_("Edit")) self.Details.set_short_label(_("Details")) self.set_help_section(_("Purchase help"), 'app-purchase') self.popup = self.uimanager.get_widget('/PurchaseSelection') def create_ui(self): if api.sysparam(self.store).SMART_LIST_LOADING: self.search.search.enable_lazy_search() self.app.launcher.add_new_items([ self.NewOrder, self.NewQuote, self.NewProduct, self.NewConsignment]) self.app.launcher.add_search_items([ self.Products, self.Suppliers, self.SearchQuotes, self.Services]) self.search.set_summary_label(column='total', label=('<b>%s</b>' % api.escape(_('Orders total:'))), format='<b>%s</b>', parent=self.get_statusbar_message_area()) self.results.set_selection_mode(gtk.SELECTION_MULTIPLE) self.Confirm.set_sensitive(False) self._inventory_widgets = [self.NewConsignment, self.CloseInConsignment] self.register_sensitive_group(self._inventory_widgets, lambda: not self.has_open_inventory()) def activate(self, params): self.app.launcher.NewToolItem.set_tooltip( _("Create a new purchase order")) self.app.launcher.SearchToolItem.set_tooltip( _("Search for purchase orders")) self.app.launcher.Print.set_tooltip( _("Print a report of these orders")) if not params.get('no-refresh'): self._update_view() self.results.set_selection_mode(gtk.SELECTION_MULTIPLE) self.check_open_inventory() def setup_focus(self): self.search.refresh() def deactivate(self): self.uimanager.remove_ui(self.purchase_ui) def new_activate(self): self._new_order() def search_activate(self): self.run_dialog(ProductSearch, self.store, hide_price_column=True) def search_completed(self, results, states): if len(results): return supplier, status = states[:2] if len(states) > 2 or (supplier.text == '' and status.value is None): self.search.set_message("%s\n\n%s" % ( _("No orders could be found."), _("Would you like to %s ?") % ( '<a href="new_order">%s</a>' % ( api.escape(_("create a new order"), ))) )) # FIXME: Push number of results to Statusbar def set_open_inventory(self): self.set_sensitive(self._inventory_widgets, False) # # SearchableAppWindow # def create_filters(self): self.set_text_field_columns(['supplier_name']) self.status_filter = ComboSearchFilter(_('Show orders'), self._get_status_values()) self.add_filter(self.status_filter, SearchFilterPosition.TOP, ['status']) def get_columns(self): return [SearchColumn('identifier', title=_('#'), long_title=_('Order number'), data_type=int, justify=gtk.JUSTIFY_RIGHT, width=60), SearchColumn('status_str', title=_('Status'), width=100, data_type=str, search_attribute='status', valid_values=self._get_status_values(), visible=False), SearchColumn('open_date', title=_('Opened'), long_title=_('Date Opened'), width=90, data_type=datetime.date, sorted=True, order=gtk.SORT_DESCENDING), SearchColumn('supplier_name', title=_('Supplier'), data_type=str, searchable=True, expand=True, ellipsize=pango.ELLIPSIZE_END), SearchColumn('ordered_quantity', title=_('Ordered'), data_type=Decimal, width=90, format_func=format_quantity), SearchColumn('received_quantity', title=_('Received'), data_type=Decimal, width=90, format_func=format_quantity), SearchColumn('total', title=_('Total'), data_type=currency, width=120)] def print_report(self, *args, **kwargs): # PurchaseReport needs a status arg kwargs['status'] = self.status_filter.get_state().value super(PurchaseApp, self).print_report(*args, **kwargs) def search_for_date(self, date): dfilter = DateSearchFilter(_("Expected receival date")) dfilter.set_removable() dfilter.mode.select_item_by_position(5) self.add_filter(dfilter, columns=["expected_receival_date"]) dfilter.start_date.set_date(date) self.search.refresh() # # Private # def _update_totals(self): self._update_view() def _update_list_aware_widgets(self, has_items): for widget in (self.Edit, self.Details): widget.set_sensitive(has_items) def _update_view(self): self._update_list_aware_widgets(len(self.results)) selection = self.results.get_selected_rows() can_edit = one_selected = len(selection) == 1 can_finish = False if selection: can_send_supplier = all( order.status == PurchaseOrder.ORDER_PENDING for order in selection) can_cancel = all(order_view.purchase.can_cancel() for order_view in selection) else: can_send_supplier = False can_cancel = False if one_selected: can_edit = (selection[0].status == PurchaseOrder.ORDER_PENDING or selection[0].status == PurchaseOrder.ORDER_QUOTING) can_finish = (selection[0].status == PurchaseOrder.ORDER_CONFIRMED and selection[0].received_quantity > 0) self.Cancel.set_sensitive(can_cancel) self.Edit.set_sensitive(can_edit) self.Confirm.set_sensitive(can_send_supplier) self.Details.set_sensitive(one_selected) self.Finish.set_sensitive(can_finish) def _new_order(self, order=None, edit_mode=False): with api.trans() as store: order = store.fetch(order) self.run_dialog(PurchaseWizard, store, order, edit_mode) if store.committed: self.refresh() res = self.store.find(PurchaseOrderView, id=store.retval.id).one() self.select_result(res) def _edit_order(self): selected = self.results.get_selected_rows() qty = len(selected) if qty != 1: raise ValueError('You should have only one order selected, ' 'got %d instead' % qty) purchase = selected[0].purchase if purchase.status == PurchaseOrder.ORDER_PENDING: self._new_order(purchase, edit_mode=False) else: self._quote_order(purchase) def _run_details_dialog(self): order_views = self.results.get_selected_rows() qty = len(order_views) if qty != 1: raise ValueError('You should have only one order selected ' 'at this point, got %d' % qty) self.run_dialog(PurchaseDetailsDialog, self.store, model=order_views[0].purchase) def _send_selected_items_to_supplier(self): orders = self.results.get_selected_rows() valid_order_views = [ order for order in orders if order.status == PurchaseOrder.ORDER_PENDING] if not valid_order_views: warning(_("There are no pending orders selected.")) return msg = stoqlib_ngettext( _("The selected order will be marked as sent."), _("The %d selected orders will be marked as sent.") % len(valid_order_views), len(valid_order_views)) confirm_label = stoqlib_ngettext(_("Confirm order"), _("Confirm orders"), len(valid_order_views)) if yesno(msg, gtk.RESPONSE_NO, _("Don't confirm"), confirm_label): return with api.trans() as store: for order_view in valid_order_views: order = store.fetch(order_view.purchase) order.confirm() self.refresh() self.select_result(orders) def _finish_order(self): order_views = self.results.get_selected_rows() qty = len(order_views) if qty != 1: raise ValueError('You should have only one order selected ' 'at this point, got %d' % qty) with api.trans() as store: order = store.fetch(order_views[0].purchase) self.run_dialog(PurchaseFinishWizard, store, order) self.refresh() self.select_result(order_views) def _cancel_order(self): order_views = self.results.get_selected_rows() assert all(ov.purchase.can_cancel() for ov in order_views) cancel_label = stoqlib_ngettext(_("Cancel order"), _("Cancel orders"), len(order_views)) select_label = stoqlib_ngettext(_('The selected order will be cancelled.'), _('The selected orders will be cancelled.'), len(order_views)) if yesno(select_label, gtk.RESPONSE_NO, _("Don't cancel"), cancel_label): return with api.trans() as store: for order_view in order_views: order = store.fetch(order_view.purchase) order.cancel() self._update_totals() self.refresh() self.select_result(order_views) def _get_status_values(self): items = [(text, value) for value, text in PurchaseOrder.statuses.items()] items.insert(0, (_('Any'), None)) return items def _quote_order(self, quote=None): with api.trans() as store: quote = store.fetch(quote) self.run_dialog(QuotePurchaseWizard, store, quote) if store.committed: self.refresh() res = self.store.find(PurchaseOrderView, id=store.retval.id).one() self.select_result(res) def _new_product(self): with api.trans() as store: self.run_dialog(ProductEditor, store, model=None) def _new_consignment(self): with api.trans() as store: self.run_dialog(ConsignmentWizard, store, model=None) if store.committed: self.refresh() res = self.store.find(PurchaseOrderView, id=store.retval.id).one() self.select_result(res) # # Kiwi Callbacks # def on_results__right_click(self, results, result, event): self.popup.popup(None, None, None, event.button, event.time) def on_results__row_activated(self, klist, purchase_order_view): self._run_details_dialog() def on_results__selection_changed(self, results, selected): self._update_view() def on_results__activate_link(self, results, uri): if uri == 'new_order': self._new_order() def _on_results__double_click(self, results, order): self._run_details_dialog() def _on_results__has_rows(self, results, has_items): self._update_list_aware_widgets(has_items) def on_Details__activate(self, action): self._run_details_dialog() def on_Edit__activate(self, action): self._edit_order() def on_Cancel__activate(self, action): self._cancel_order() def on_Confirm__activate(self, button): self._send_selected_items_to_supplier() def on_Finish__activate(self, action): self._finish_order() # Order def on_StockCost__activate(self, action): self.run_dialog(StockCostDialog, self.store, None) # Consignment def on_CloseInConsignment__activate(self, action): with api.trans() as store: self.run_dialog(CloseInConsignmentWizard, store) def on_SearchInConsignmentItems__activate(self, action): self.run_dialog(ConsignmentItemSearch, self.store) def on_Categories__activate(self, action): self.run_dialog(SellableCategorySearch, self.store) def on_SearchQuotes__activate(self, action): with api.trans() as store: self.run_dialog(ReceiveQuoteWizard, store) self.refresh() def on_SearchPurchasedItems__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_Suppliers__activate(self, action): self.run_dialog(SupplierSearch, self.store, hide_footer=True) def on_Products__activate(self, action): self.run_dialog(ProductSearch, self.store, hide_price_column=True) def on_ProductUnits__activate(self, action): self.run_dialog(SellableUnitSearch, self.store) def on_ProductManufacturers__activate(self, action): self.run_dialog(ProductManufacturerDialog, self.store) def on_Services__activate(self, action): self.run_dialog(ServiceSearch, self.store, hide_price_column=True) def on_Transporter__activate(self, action): self.run_dialog(TransporterSearch, self.store, hide_footer=True) def on_ProductsSoldSearch__activate(self, action): self.run_dialog(ProductsSoldSearch, self.store) def on_ProductsPriceSearch__activate(self, action): from stoqlib.domain.person import ClientCategory if not self.store.find(ClientCategory).count(): warning(_("Can't use prices editor without client categories")) return with api.trans() as store: self.run_dialog(SellablePriceDialog, store) # Toolitem def on_NewOrder__activate(self, action): self._new_order() def on_NewQuote__activate(self, action): self._quote_order() def on_NewProduct__activate(self, action): self._new_product() def on_NewConsignment__activate(self, action): self._new_consignment()
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)
def create_filters(self): self.set_text_field_columns(['description']) self.status_filter = ComboSearchFilter( _(u'Show productions with status'), self._get_status_values()) self.add_filter(self.status_filter, SearchFilterPosition.TOP, ['status'])
class ProductionApp(SearchableAppWindow): app_name = _(u'Production') gladefile = "production" search_table = ProductionOrder search_label = _(u'matching:') report_table = ProductionReport embedded = True # # Application # def create_actions(self): group = get_accels('app.production') actions = [ ('menubar', None, ''), # File ('NewProduction', gtk.STOCK_NEW, _('Production order...'), group.get('new_production_order'), _('Create a new production')), ('ProductionPurchaseQuote', STOQ_PRODUCTION_APP, _('Purchase quote...'), group.get('new_production_quote')), # Production ('ProductionMenu', None, _('Production')), ('StartProduction', gtk.STOCK_CONVERT, _('Start production...'), group.get('production_start'), _('Start the selected production')), ('EditProduction', gtk.STOCK_EDIT, _('Edit production...'), group.get('production_edit'), _('Edit the selected production')), ('ProductionDetails', gtk.STOCK_INFO, _('Production details...'), group.get('production_details'), _('Show production details and register produced items')), # Search ("SearchProduct", None, _("Production products..."), group.get('search_production_products'), _("Search for production products")), ("SearchService", None, _("Services..."), group.get('search_services'), _("Search for services")), ("SearchProductionItem", STOQ_PRODUCTION_APP, _("Production items..."), group.get('search_production_items'), _("Search for production items")), ("SearchProductionHistory", None, _("Production history..."), group.get('search_production_history'), _("Search for production history")), ] self.production_ui = self.add_ui_actions("", actions, filename="production.xml") self.set_help_section(_("Production help"), 'app-production') self.NewProduction.set_short_label(_("New Production")) self.ProductionPurchaseQuote.set_short_label(_("Purchase")) self.SearchProductionItem.set_short_label(_("Search items")) self.StartProduction.set_short_label(_('Start')) self.EditProduction.set_short_label(_('Edit')) self.ProductionDetails.set_short_label(_('Details')) self.StartProduction.props.is_important = True def create_ui(self): self.popup = self.uimanager.get_widget('/ProductionSelection') self.app.launcher.add_new_items([self.NewProduction, self.ProductionPurchaseQuote]) self.app.launcher.add_search_items([ self.SearchProduct, self.SearchService, self.SearchProductionItem, ]) self.app.launcher.Print.set_tooltip( _("Print a report of these productions")) self._inventory_widgets = [self.StartProduction] self.register_sensitive_group(self._inventory_widgets, lambda: not self.has_open_inventory()) def activate(self, params): self.search.refresh() self._update_widgets() self.check_open_inventory() def deactivate(self): self.uimanager.remove_ui(self.production_ui) def new_activate(self): self._open_production_order() def search_activate(self): self.run_dialog(ProductionProductSearch, self.store) def create_filters(self): self.set_text_field_columns(['description']) self.status_filter = ComboSearchFilter( _(u'Show productions with status'), self._get_status_values()) self.add_filter(self.status_filter, SearchFilterPosition.TOP, ['status']) def get_columns(self): return [SearchColumn('identifier', title=_(u'# '), sorted=True, data_type=int, format='%04d', width=80, order=gtk.SORT_DESCENDING), Column('status_string', title=_(u'Status'), data_type=str, visible=False), SearchColumn('description', title=_(u'Description'), data_type=str, expand=True), Column('responsible.person.name', title=_(u'Responsible'), data_type=str, width=150), SearchColumn('open_date', title=_(u'Opened'), data_type=datetime.date, width=80), SearchColumn('close_date', title=_(u'Closed'), data_type=datetime.date, width=80)] def print_report(self, *args, **kwargs): # ProductionReport needs a status kwarg kwargs['status'] = self.status_filter.get_state().value super(ProductionApp, self).print_report(*args, **kwargs) def set_open_inventory(self): self.set_sensitive(self._inventory_widgets, False) # # Private # def _update_widgets(self): selected = self.results.get_selected() can_edit = False can_start = False if selected: can_edit = (selected.status == ProductionOrder.ORDER_OPENED or selected.status == ProductionOrder.ORDER_WAITING) can_start = can_edit self.set_sensitive([self.EditProduction], can_edit) self.set_sensitive([self.StartProduction], can_start) self.set_sensitive([self.ProductionDetails], bool(selected)) def _get_status_values(self): items = [(text, value) for value, text in ProductionOrder.statuses.items()] items.insert(0, (_(u'Any'), None)) return items def _open_production_order(self, order=None): store = api.new_store() order = store.fetch(order) retval = self.run_dialog(ProductionWizard, store, order) store.confirm(retval) store.close() self.refresh() def _start_production_order(self): store = api.new_store() order = store.fetch(self.results.get_selected()) assert order is not None retval = self.run_dialog(StartProductionDialog, store, order) store.confirm(retval) store.close() self.refresh() def _production_details(self): order = self.results.get_selected() assert order is not None store = api.new_store() model = store.fetch(order) self.run_dialog(ProductionDetailsDialog, store, model) store.confirm(True) store.close() # # Kiwi Callbacks # def on_EditProduction__activate(self, widget): order = self.results.get_selected() assert order is not None self._open_production_order(order) def on_ProductionDetails__activate(self, widget): self._production_details() def on_results__selection_changed(self, results, selected): self._update_widgets() def on_results__has_rows(self, widget, has_rows): self._update_widgets() def on_results__row_activated(self, widget, order): self._production_details() def on_results__right_click(self, results, result, event): self.popup.popup(None, None, None, event.button, event.time) # Production def on_NewProduction__activate(self, action): self._open_production_order() def on_StartProduction__activate(self, action): self._start_production_order() def on_ProductionPurchaseQuote__activate(self, action): with api.trans() as store: self.run_dialog(ProductionQuoteDialog, store) # Search def on_SearchProduct__activate(self, action): self.run_dialog(ProductionProductSearch, self.store) def on_SearchService__activate(self, action): self.run_dialog(ServiceSearch, self.store, hide_price_column=True) def on_SearchProductionItem__activate(self, action): self.run_dialog(ProductionItemsSearch, self.store) def on_SearchProductionHistory__activate(self, action): self.run_dialog(ProductionHistorySearch, self.store)
class BaseAccountWindow(SearchableAppWindow): embedded = True # # Application # def create_ui(self): if api.sysparam(self.store).SMART_LIST_LOADING: self.search.search.enable_lazy_search() self.results.set_selection_mode(gtk.SELECTION_MULTIPLE) self.search.set_summary_label(column='value', label='<b>%s</b>' % (_('Total'), ), format='<b>%s</b>', parent=self.get_statusbar_message_area()) self.results.set_cell_data_func(self._on_results__cell_data_func) def search_completed(self, results, states): if len(results): return state = states[1] if state and state.value is None: not_found = _("No payments found.") payment_url = '<a href="new_payment">%s</a>?' % ( api.escape(_("create a new payment"))) new_payment = _("Would you like to %s") % (payment_url, ) msg = "%s\n\n%s" % (not_found, new_payment) else: v = state.value.value if v == 'status:late': msg = _("No late payments found.") elif v == 'status:paid': msg = _("No paid payments found.") elif v == 'status:not-paid': if self.search_table == InPaymentView: msg = _("No payments to receive found.") else: msg = _("No payments to pay found.") elif v.startswith('category:'): category = v.split(':')[1].encode('utf-8') not_found = _("No payments in the <b>%s</b> category were found.") % ( api.escape(category), ) payment_url = '<a href="new_payment?%s">%s</a>?' % ( urllib.quote(category), _("create a new payment")) msg = "%s\n\n%s" % ( not_found, _("Would you like to %s") % (payment_url, )) else: return self.search.set_message(msg) # # Public API # def add_payment(self, category=None): with api.trans() as store: self.run_dialog(self.editor_class, store, category=category) if store.committed: self._update_filter_items() self.search.refresh() self.select_result(self.store.find(self.search_table, id=store.retval.id).one()) def show_details(self, payment_view): """Shows some details about the payment, allowing to edit a few properties """ with api.trans() as store: payment = store.fetch(payment_view.payment) run_dialog(self.editor_class, self, store, payment) if store.committed: payment_view.sync() self.results.update(payment_view) return payment def show_comments(self, payment_view): """Shows a dialog with comments saved on the payment @param payment_view: an OutPaymentView or InPaymentView instance """ with api.trans() as store: run_dialog(PaymentCommentsDialog, self, store, payment_view.payment) if store.committed: payment_view.sync() self.results.update(payment_view) def change_due_date(self, payment_view, order): """ Receives a payment_view and change the payment due date related to the view. @param payment_view: an OutPaymentView or InPaymentView instance @param order: a Sale or Purchase instance related to this payment. This will be used to show the identifier of the order """ assert payment_view.can_change_due_date() with api.trans() as store: payment = store.fetch(payment_view.payment) order = store.fetch(order) run_dialog(PaymentDueDateChangeDialog, self, store, payment, order) if store.committed: # We need to refresh the whole list as the payment(s) can possibly # disappear for the selected view self.refresh() def change_status(self, payment_view, order, status): """Show a dialog do enter a reason for status change @param payment_view: an OutPaymentView or InPaymentView instance @param order: a Sale or Purchase instance related to this payment. This will be used to show the identifier of the order @param status: The new status to set the payment to """ with api.trans() as store: payment = store.fetch(payment_view.payment) order = store.fetch(payment_view.sale) if order is None: order = store.fetch(payment_view.purchase) run_dialog(PaymentStatusChangeDialog, self, store, payment, status, order) if store.committed: # We need to refresh the whole list as the payment(s) can possibly # disappear for the selected view self.refresh() def create_main_filter(self): self.main_filter = ComboSearchFilter(_('Show'), []) combo = self.main_filter.combo combo.color_attribute = 'color' combo.set_row_separator_func(self._on_main_filter__row_separator_func) self._update_filter_items() self.executer.add_filter_query_callback( self.main_filter, self._on_main_filter__query_callback) self.add_filter(self.main_filter, SearchFilterPosition.TOP) def add_filter_items(self, category_type, options): categories = PaymentCategory.get_by_type(self.store, category_type) items = [(_('All payments'), None)] if categories.count() > 0: options.append(FilterItem('sep', 'sep')) items.extend([(item.name, item) for item in options]) for c in categories: item = FilterItem(c.name, 'category:%s' % (c.name, ), color=c.color, item_id=c.id) items.append((item.name, item)) self.main_filter.update_values(items) # # Private # def _create_main_query(self, state): item = state.value if item is None: return None kind, value = item.value.split(':') payment_view = self.search_table if kind == 'status': if value == 'paid': return payment_view.status == Payment.STATUS_PAID elif value == 'not-paid': return payment_view.status == Payment.STATUS_PENDING elif value == 'late': tolerance = api.sysparam(self.store).TOLERANCE_FOR_LATE_PAYMENTS return And( payment_view.status == Payment.STATUS_PENDING, payment_view.due_date < datetime.date.today() - relativedelta(days=tolerance)) elif kind == 'category': return payment_view.category == value raise AssertionError(kind, value) def _show_payment_categories(self): store = api.new_store() self.run_dialog(PaymentCategoryDialog, store, self.payment_category_type) self._update_filter_items() store.close() # # Callbacks # def _on_main_filter__row_separator_func(self, model, titer): if model[titer][0] == 'sep': return True return False def _on_main_filter__query_callback(self, state): return self._create_main_query(state) def _on_results__cell_data_func(self, column, renderer, pv, text): if not isinstance(renderer, gtk.CellRendererText): return text state = self.main_filter.get_state() def show_strikethrough(): if state.value is None: return True if state.value.value.startswith('category:'): return True return False is_pending = (pv.status == Payment.STATUS_PENDING) show_strikethrough = not is_pending and show_strikethrough() is_late = pv.is_late() renderer.set_property('strikethrough-set', show_strikethrough) renderer.set_property('weight-set', is_late) if show_strikethrough: renderer.set_property('strikethrough', True) if is_late: renderer.set_property('weight', pango.WEIGHT_BOLD) return text def on_results__activate_link(self, results, uri): if uri.startswith('new_payment'): if '?' in uri: category = urllib.unquote(uri.split('?', 1)[1]) else: category = None self.add_payment(category=category) def on_PaymentFlowHistory__activate(self, action): self.run_dialog(PaymentFlowHistoryDialog, self.store) def on_PaymentCategories__activate(self, action): self._show_payment_categories()