def _get_received_columns(self): return [Column('description', title=_('Description'), data_type=str, expand=True, searchable=True, sorted=True, ellipsize=Pango.EllipsizeMode.END), QuantityColumn('quantity_received', title=_('Qty Received')), Column('cost', title=_('Cost'), data_type=currency, format_func=get_formatted_cost), Column('total_received', title=_('Total'), data_type=currency), QuantityColumn('current_stock', title=_('Current Stock')), ]
def test_format_func(self): class Fake(object): quantity = 0 column = QuantityColumn('quantity') obj = Fake() obj.quantity = None self.assertEqual(column._format_func(obj, True), '0') obj.quantity = 0 self.assertEqual(column._format_func(obj, True), '0') obj.quantity = 1 self.assertEqual(column._format_func(obj, True), '1') obj.product = self.create_product() obj.sellable = obj.product.sellable # Without a unit, it should still return just the number obj.quantity = 1 self.assertEqual(column._format_func(obj, True), '1') obj.sellable.unit = self.create_sellable_unit(u'Pc') self.assertEqual(column._format_func(obj, True), '1 Pc') obj.product.manage_stock = False self.assertEqual(column._format_func(obj, True), '1 Pc') obj.quantity = 0 self.assertEqual(column._format_func(obj, True), u"\u221E")
def get_columns(self): return [ IdentifierColumn('identifier', title=_(u"Returned #")), SearchColumn('status_str', _('Status'), data_type=str, search_attribute='status', valid_values=self._get_status_values()), SearchColumn('item_description', title=_(u"Item")), QuantityColumn('item_quantity', title=_(u"Qty")), SearchColumn('client_name', _('Client'), expand=True, data_type=str), SearchColumn('return_date', _('Return Date'), data_type=datetime.date, sorted=True), SearchColumn('reason', _('Return Reason'), data_type=str, visible=False), SearchColumn('responsible_name', _('Responsible'), data_type=str), SearchColumn('branch_name', _('Return branch'), data_type=str, visible=False), SearchColumn('invoice_number', _('Invoice number'), data_type=int, visible=False), ]
def get_columns(self): columns = [ SearchColumn('code', title=_('Code'), data_type=str, sorted=True, order=gtk.SORT_DESCENDING), SearchColumn('description', title=_('Description'), data_type=str, expand=True), SearchColumn('client_name', title=_('Client'), data_type=str), SearchColumn('phone_number', title=_('Phone'), data_type=str, visible=False, format_func=format_phone_number), SearchColumn('email', title=_('Email'), data_type=str, visible=False), SearchColumn('sellable_category', title=_('Category'), data_type=str, visible=False), QuantityColumn('quantity', title=_('Qty')), SearchColumn('price', title=_('Avg price'), data_type=currency), SearchColumn( 'total', title=_('Total'), data_type=currency, ) ] return columns
def get_columns(self): cols = [SearchColumn('code', title=_('Code'), data_type=str, sort_func=sort_sellable_code, sorted=True), SearchColumn('barcode', title=_('Barcode'), data_type=str), SearchColumn('category_description', title=_(u'Category'), data_type=str, width=120), SearchColumn('description', title=_(u'Description'), expand=True, data_type=str), SearchColumn('manufacturer', title=_('Manufacturer'), data_type=str, visible=False), SearchColumn('model', title=_('Model'), data_type=str, visible=False), SearchColumn('ncm', title=_('NCM'), data_type=str, visible=False), Column('unit', title=_('Unit'), data_type=str, visible=False), SearchColumn('location', title=_('Location'), data_type=str, visible=False)] # The price/cost columns must be controlled by hide_cost_column and # hide_price_column. Since the product search will be available across # the applications, it's important to restrict such columns depending # of the context. if not self.hide_cost_column: cols.append(SearchColumn('cost', _('Cost'), data_type=currency, format_func=get_formatted_cost, width=90)) if not self.hide_price_column: cols.append(SearchColumn('price', title=_('Price'), data_type=currency, width=90)) cols.append(QuantityColumn('stock', title=_('Stock'))) return cols
def _get_items_columns(self): return [ Column('code', _("Code"), sorted=True, data_type=str, width=130), Column('description', _("Description"), data_type=str, expand=True, width=200), Column('category', _("Category"), data_type=str, visible=False), Column('manufacturer', _("Manufacturer"), data_type=str, visible=False), QuantityColumn('quantity', title=_("Qty"), visible=True), Column('base_price', _("Base price"), data_type=currency, visible=False), Column('price', _("Sale price"), data_type=currency), Column('item_discount', _("Discount"), data_type=currency, visible=False), Column('total', _("Total"), data_type=currency) ]
def get_columns(self): columns = [ SearchColumn('salesperson_name', title=_('Salesperson'), data_type=str), SearchColumn('code', title=_('Code'), data_type=str, sorted=True, order=Gtk.SortType.DESCENDING), SearchColumn('description', title=_('Description'), data_type=str, expand=True), Column('brand', title=_('Brand'), data_type=str), Column('batch_number', title=_('Batch'), data_type=str, visible=False), SearchColumn('category', title=_('Category'), data_type=str, visible=False), QuantityColumn('quantity', title=_('Qty'), use_having=True), SearchColumn('total', title=_('Total'), data_type=currency, use_having=True) ] return columns
def get_columns(self): columns = [SearchColumn('code', title=_(u'Code'), data_type=str), SearchColumn('barcode', title=_('Barcode'), data_type=str, sort_func=sort_sellable_code, width=80), SearchColumn('category_description', title=_('Category'), data_type=str, width=120), SearchColumn('description', title=_('Description'), data_type=str, expand=True, sorted=True), SearchColumn('location', title=_('Location'), data_type=str, visible=False), SearchColumn('manufacturer', title=_('Manufacturer'), data_type=str, visible=False), SearchColumn('model', title=_('Model'), data_type=str, visible=False)] if hasattr(self.search_spec, 'price'): columns.append(SearchColumn('price', title=_(u'Price'), data_type=currency, visible=True)) if hasattr(self.search_spec, 'minimum_quantity'): columns.append(SearchColumn('minimum_quantity', title=_(u'Minimum Qty'), data_type=Decimal, visible=False)) if hasattr(self.search_spec, 'stock'): columns.append(QuantityColumn('stock', title=_(u'In Stock'))) return columns
def get_columns(self): return [ Column('branch_name', title=_('Branch'), data_type=str, expand=True), QuantityColumn('stock', title=_('In Stock')) ]
def get_columns(self): return [Column('code', title=_('Code'), data_type=str, sorted=True), Column('description', title=_('Description'), data_type=str, expand=True), QuantityColumn('quantity', title=_('Sold')), Column('average_cost', title=_('Avg. Cost'), data_type=currency), ]
def _get_returned_items_columns(self): return [Column("sellable.code", title=_("Product Code"), data_type=str, width=130), Column("sellable.description", title=_("Description"), data_type=str, expand=True), QuantityColumn("quantity", title=_("Qty returned")), Column("price", title=_("Price"), data_type=currency), Column("total", title=_("Total"), data_type=currency)]
def get_columns(self): return [ SearchColumn('code', title=_('Code'), data_type=str, sort_func=sort_sellable_code), SearchColumn('category_description', title=_('Category'), data_type=str, width=100), SearchColumn('description', title=_('Description'), data_type=str, expand=True, sorted=True), 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, visible=False), QuantityColumn('maximum_quantity', title=_('Maximum'), visible=False), QuantityColumn('minimum_quantity', title=_('Minimum')), QuantityColumn('stock', title=_('In Stock'), use_having=True), QuantityColumn('to_receive_quantity', title=_('To Receive')), ColoredColumn('difference', title=_('Difference'), color='red', format_func=format_quantity, data_type=Decimal, data_func=lambda x: x <= Decimal(0)) ]
def _get_ordered_columns(self): return [ Column('description', title=_('Description'), data_type=str, expand=True, searchable=True, ellipsize=pango.ELLIPSIZE_END), QuantityColumn('quantity', title=_('Qty')), Column('cost', title=_('Cost'), data_type=currency, format_func=get_formatted_cost), Column('total', title=_('Total'), data_type=currency) ]
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('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), ]
def get_columns(self): return [Column('code', title=_('Code'), data_type=str, sort_func=sort_sellable_code, sorted=True, width=130), Column('description', title=_('Description'), data_type=str, expand=True), QuantityColumn('quantity_sold', title=_('Sold'), visible=not self.show_production_columns), QuantityColumn('quantity_transfered', title=_('Transfered'), visible=not self.show_production_columns), QuantityColumn('quantity_received', title=_('Received'), visible=not self.show_production_columns), QuantityColumn('quantity_produced', title=_('Produced'), visible=self.show_production_columns), QuantityColumn('quantity_consumed', title=_('Consumed'), visible=self.show_production_columns), QuantityColumn('quantity_decreased', title=_('Manualy Decreased'), visible=self.show_production_columns), QuantityColumn('quantity_lost', title=_('Lost'), visible=self.show_production_columns, )]