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):
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_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):
return [
Column('branch_name',
title=_('Branch'),
data_type=str,
expand=True),
QuantityColumn('stock', title=_('In Stock'))
]
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)
]
user = api.get_current_user(self.store)
if user.profile.check_app_permission('purchase'):
columns.append(
SearchColumn('cost',
title=_(u'Cost'),
data_type=currency,
visible=True))
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('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),
Column('total_sold', title=_('Total sold'), 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_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'),
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),
]
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.SortType.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'), use_having=True),
SearchColumn('price',
title=_('Avg price'),
data_type=currency,
use_having=True),
SearchColumn('total',
title=_('Total'),
data_type=currency,
use_having=True)
]
return columns
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,
)
]
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),
SearchColumn('status',
title=_('Status'),
data_type=str,
valid_values=self._get_status_values(),
visible=False),
SearchColumn('brand',
title=_('Brand'),
data_type=str,
visible=False),
SearchColumn('family',
title=_('Family'),
data_type=str,
visible=False),
SearchColumn('internal_use',
title=_('Is internal'),
data_type=bool,
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'), use_having=True))
return cols
