def get_columns(self):
return [IdentifierColumn('identifier', title=_('Payment #')),
SearchColumn('description', title=_('Description'),
data_type=str, ellipsize=Pango.EllipsizeMode.END,
expand=True, pack_end=True),
Column('color', title=_('Description'), width=20,
data_type=GdkPixbuf.Pixbuf, format_func=render_pixbuf,
column='description'),
SearchColumn('invoice_numbers', title=_('Invoice Numbers'), data_type=str),
Column('comments_number', title=_(u'Comments'),
visible=False),
SearchColumn('supplier_name', title=_('Supplier'),
data_type=str, width=140,
ellipsize=Pango.EllipsizeMode.END),
SearchColumn('open_date', title=_('Open date'),
data_type=datetime.date, width=100, visible=False),
SearchColumn('due_date', title=_('Due date'),
data_type=datetime.date, width=100,
sorted=True),
SearchColumn('paid_date', title=_('Paid date'),
data_type=datetime.date, width=100),
SearchColumn('status_str', title=_('Status'), width=100,
data_type=str, search_attribute='status',
valid_values=self._get_status_values(),
visible=False),
SearchColumn('value', title=_('Value'), data_type=currency,
width=90),
SearchColumn('paid_value', title=_('Paid'), data_type=currency,
long_title=_('Paid value'), width=90),
SearchColumn('category', title=_('Category'), data_type=str,
long_title=_('Payment category'), width=110,
visible=False),
]
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_columns(self):
return [
IdentifierColumn('identifier',
title=_('Production #'),
sorted=True,
order=Gtk.SortType.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),
SearchColumn('cancel_date',
title=_(u'Cancelled'),
data_type=datetime.date,
width=80)
]
def get_columns(self):
return [SearchColumn('brand', title=_('Brand'), data_type=str,
sorted=True, expand=True),
SearchColumn('company', title=_('Branch'), data_type=str),
SearchColumn('manufacturer', title=_('Manufacturer'), data_type=str),
SearchColumn('product_category', title=_('Category'), data_type=str),
Column('quantity', title=_('Quantity'), data_type=Decimal)]
def get_columns(self):
columns = [
IdentifierColumn('identifier', title=_('Sale #'), sorted=True),
SearchColumn('salesperson_name', title=_('Salesperson'),
data_type=str, expand=True),
SearchColumn('method_description', title=_('Method'), data_type=str,
search_attribute='method_name',
valid_values=self._get_method_values()),
# This column evals to an integer, and due to a bug
# in kiwi, its not searchable
Column('commission_percentage', title=_('Commission (%)'),
data_type=Decimal, format="%.2f"),
# negative commissions are shown in red color
ColoredColumn('commission_value', title=_('Commission'),
color='red', data_func=lambda x: x < 0,
data_type=currency)]
# FIXME: The date here depends on the parameter. We could use
# it as a property on the view, but then it would not be searchable.
# Find a better way of handling this sometime in the future.
if sysparam.get_bool('SALE_PAY_COMMISSION_WHEN_CONFIRMED'):
columns.append(SearchColumn('confirm_date', title=_('Date'),
data_type=datetime.date))
else:
columns.append(SearchColumn('paid_date', title=_('Date'),
data_type=datetime.date))
columns.extend([
Column('payment_amount', title=_('Payment value'),
data_type=currency),
Column('total_amount', title=_('Sale total'),
data_type=currency)])
return columns
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),
SearchColumn('maximum_quantity', title=_('Maximum'),
visible=False, format_func=format_data,
data_type=Decimal),
SearchColumn('minimum_quantity', title=_('Minimum'),
format_func=format_data, data_type=Decimal),
SearchColumn('stock', title=_('In Stock'),
format_func=format_data, data_type=Decimal),
SearchColumn('to_receive_quantity', title=_('To Receive'),
format_func=format_data,
data_type=Decimal),
ColoredColumn('difference', title=_('Difference'), color='red',
format_func=format_data, data_type=Decimal,
data_func=lambda x: x <= Decimal(0))]
def _get_payment_columns(self):
return [SearchColumn('due_date', title=_("Due date"), data_type=datetime.date, sorted=True),
IdentifierColumn('identifier', title=_("Payment #")),
SearchColumn('description', title=_("Description"),
data_type=str, expand=True),
SearchColumn('value', title=_("Value"),
data_type=currency)]
def get_columns(self):
return [
IdentifierColumn('loan_identifier', title=_('Loan #'),
sorted=True),
SearchColumn('opened',
title=_(u'Open date'),
data_type=datetime.date,
visible=False),
SearchColumn(
'closed',
title=_(u'Close date'),
data_type=datetime.date,
),
SearchColumn('code',
title=_(u'Code'),
data_type=str,
visible=False),
SearchColumn('category_description',
title=_(u'Category'),
data_type=str,
visible=False),
SearchColumn('description',
title=_(u'Description'),
data_type=str,
expand=True),
SearchColumn('quantity', title=_(u'Quantity'), data_type=Decimal),
SearchColumn('sale_quantity', title=_(u'Sold'), data_type=Decimal),
SearchColumn('return_quantity',
title=_(u'Returned'),
data_type=Decimal),
SearchColumn('price', title=_(u'Price'), data_type=currency),
SearchColumn('total', title=_(u'Total'), data_type=currency)
]
def get_columns(self):
columns = [
SearchColumn('check_date',
title=_('Date'),
data_type=datetime.date,
width=150,
sorted=True),
SearchColumn('identifier',
title=_('Identifier'),
data_type=str,
width=130),
Column('status', title=_('Status'), data_type=str, width=160),
Column('notes',
title=_('Notes'),
data_type=str,
width=100,
expand=True),
SearchColumn('user', title=_('User'), data_type=str, width=100)
]
if not self.client:
columns.insert(
1,
SearchColumn('client_name',
title=_('Client'),
data_type=str,
width=150,
expand=True))
return columns
def get_columns(self):
return [
IdentifierColumn('identifier',
title=_('Inventory #'),
sorted=True,
order=Gtk.SortType.DESCENDING),
SearchColumn('status_str',
title=_('Status'),
data_type=str,
width=100,
valid_values=self._get_status_values(),
search_attribute='status'),
Column('branch.description',
title=_('Branch'),
data_type=str,
expand=True),
SearchColumn('open_date',
title=_('Opened'),
long_title=_('Date Opened'),
data_type=datetime.date,
width=120),
SearchColumn('close_date',
title=_('Closed'),
long_title=_('Date Closed'),
data_type=datetime.date,
width=120)
]
def get_columns(self):
return [
IdentifierColumn('identifier', title=_('Payment #'), sorted=True),
Column('method_description',
title=_(u'Method'),
data_type=str,
expand=True),
SearchColumn('payment_number',
title=_(u'Number'),
data_type=str,
width=100),
SearchColumn('due_date',
title=_('Due date'),
data_type=datetime.date,
width=120),
SearchColumn('paid_date',
title=_('Paid date'),
data_type=datetime.date,
width=120),
SearchColumn('status_str',
title=_('Status'),
data_type=str,
valid_values=self._get_status_values(),
search_attribute='status'),
SearchColumn('value', title=_('Value'), data_type=currency)
]
def get_columns(self):
return [
SearchColumn('description',
title=_('Description'),
data_type=str,
expand=True,
sorted=True),
SearchColumn('purchased',
title=_('Purchased'),
data_type=Decimal,
width=100),
SearchColumn('received',
title=_('Received'),
data_type=Decimal,
width=100),
Column('stocked',
title=_('In Stock'),
data_type=Decimal,
width=100),
SearchColumn('purchased_date',
title=_('Purchased date'),
data_type=datetime.date),
SearchColumn('expected_receival_date',
title=_('Expected receival'),
data_type=datetime.date,
valid_values=self._get_date_options())
]
def get_columns(self):
return [
IdentifierColumn('identifier', title=_('Decrease #')),
Column('confirm_date',
title=_('Date'),
data_type=datetime.date,
sorted=True,
width=100),
Column('branch_name',
title=_('Branch'),
data_type=str,
expand=True),
SearchColumn('removed_by_name',
title=_('Removed By'),
data_type=str,
width=120),
SearchColumn('sent_to_name',
title=_('Sent To'),
data_type=str,
visible=False),
Column('total_items_removed',
title=_('Items removed'),
data_type=Decimal,
width=110),
Column('cfop_description',
title=_('CFOP'),
data_type=str,
expand=True),
SearchColumn('reason', title=_('Reason'), data_type=str),
]
def get_columns(self):
return [
IdentifierColumn('identifier',
title=_('Sale #'),
sorted=True,
order=Gtk.SortType.DESCENDING),
SearchColumn('open_date',
title=_('Date Started'),
width=110,
data_type=datetime.date,
justify=Gtk.Justification.RIGHT),
SearchColumn('client_name',
title=_('Client'),
data_type=str,
expand=True,
ellipsize=Pango.EllipsizeMode.END),
SearchColumn('salesperson_name',
title=_('Salesperson'),
data_type=str,
width=150),
SearchColumn('total_quantity',
title=_('Items'),
data_type=Decimal,
width=60,
format_func=format_quantity),
SearchColumn('total',
title=_('Total'),
data_type=currency,
search_attribute='_total',
width=90)
]
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 = [
Column('date',
title=_('Date'),
data_type=datetime.date,
width=150,
sorted=True),
SearchColumn('description',
title=_('Description'),
data_type=str,
width=150,
expand=True),
SearchColumn('attendant',
title=_('Attendant'),
data_type=str,
width=100,
expand=True)
]
if not self.person:
columns.insert(
1,
SearchColumn('name',
title=self.person_name,
data_type=str,
width=150,
expand=True))
return columns
def get_columns(self):
return [
SearchColumn('code',
title=_('Code'),
data_type=str,
sorted=True,
order=gtk.SORT_DESCENDING),
SearchColumn('description',
title=_('Product'),
data_type=str,
expand=True),
SearchColumn('category',
title=_('Category'),
data_type=str,
visible=False),
SearchColumn('branch_name',
title=_('Branch'),
data_type=str,
width=200),
Column('quantity',
title=_('Quantity'),
data_type=Decimal,
format_func=format_quantity,
width=100),
Column('total', title=_('Total'), data_type=currency, width=80)
]
def get_columns(self):
return [
IdentifierColumn('identifier',
long_title=_('Order #'),
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)
]
def get_columns(self):
return [
IdentifierColumn('identifier'),
SearchColumn('finish_date',
_('Finish Date'),
data_type=datetime.date,
width=100,
visible=False),
SearchColumn('item_description', _('Item'), data_type=str),
SearchColumn('item_quantity',
_('Quantity'),
data_type=Decimal,
format_func=format_quantity,
width=110),
SearchColumn('source_branch_name',
_('Source'),
data_type=str,
expand=True),
SearchColumn('destination_branch_name',
_('Destination'),
data_type=str,
width=220),
Column('transfer_order.status_str',
_('Status'),
data_type=str,
width=100,
visible=False),
Column('open_date',
_('Open date'),
data_type=datetime.date,
sorted=True,
width=100)
]
def get_columns(self):
columns = [
SearchColumn('code',
title=_('Code'),
data_type=str,
sorted=True,
sort_func=sort_sellable_code,
width=130),
SearchColumn('barcode',
title=_('Barcode'),
data_type=str,
visible=True,
width=130),
SearchColumn('description',
title=_('Description'),
data_type=str,
expand=True)
]
if not self.hide_cost_column:
columns.append(
SearchColumn('cost', _('Cost'), data_type=currency, width=80))
if not self.hide_price_column:
columns.append(
SearchColumn('price',
title=_('Price'),
data_type=currency,
width=80))
return columns
def get_columns(self):
return [
IdentifierColumn('identifier', title=_('Transfer #')),
SearchColumn('transfer_order.status_str',
_('Status'),
data_type=str,
valid_values=self._get_status_values(),
search_attribute='status',
width=100),
SearchColumn('open_date',
_('Open date'),
data_type=datetime.date,
sorted=True,
width=100),
SearchColumn('finish_date',
_('Finish Date'),
data_type=datetime.date,
width=100,
visible=False),
SearchColumn('source_branch_name',
_('Source'),
data_type=str,
expand=True),
SearchColumn('destination_branch_name',
_('Destination'),
data_type=str,
width=220),
Column('total_items',
_('Items'),
data_type=Decimal,
format_func=format_quantity,
width=110)
]
def get_columns(self):
return [
IdentifierColumn('identifier',
sorted=True,
order=gtk.SORT_DESCENDING),
SearchColumn('open_date',
title=_('Date Started'),
width=110,
data_type=datetime.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=150),
SearchColumn('total_quantity',
title=_('Items'),
data_type=Decimal,
width=60,
format_func=format_quantity),
SearchColumn('total',
title=_('Total'),
data_type=currency,
width=90)
]
def get_columns(self):
return [SearchColumn('name', title=_('Name'),
data_type=str, sorted=True, expand=True),
SearchColumn('phone_number', _('Phone Number'), str,
format_func=format_phone_number, width=180),
SearchColumn('freight_percentage', _('Freight (%)'), Decimal,
width=150)]
def get_columns(self):
return [SearchColumn('name', _('Name'), str, expand=True, sorted=True),
SearchColumn('role', _('Role'), str, width=225,
valid_values=self._get_role_values()),
SearchColumn('registry_number', _('Registry Number'), str),
SearchColumn('status_string', _('Status'), str,
valid_values=self._get_status_values(),
search_attribute='status')]
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 [SearchColumn('name', _('Name'), str, expand=True, sorted=True),
SearchColumn('acronym', _('Acronym'), data_type=str,
visible=False),
SearchColumn('phone_number', _('Phone Number'), str,
width=150),
SearchColumn('manager_name', _('Manager'), str,
width=250),
Column('status_str', _('Status'), data_type=str)]
def get_columns(self):
return [SearchColumn('name', title=_('Medic Name'), sorted=True,
data_type=str, expand=True),
SearchColumn('phone_number', title=_('Phone Number'),
data_type=str),
SearchColumn('crm_number', title=_('UPID'),
data_type=str),
SearchColumn('partner', title=_('Partner'), data_type=bool,
visible=False)]
def get_columns(self):
return [SearchColumn('date', title=_('Date'), width=80,
data_type=datetime.date, justify=gtk.JUSTIFY_RIGHT),
SearchColumn('invoice_number', title=_('Invoice'),
data_type=int, width=100, sorted=True),
SearchColumn('cfop_code', title=_('C.F.O.P.'),
data_type=str, width=75),
SearchColumn('drawee_name', title=_('Drawee'),
data_type=str, expand=True)]
def get_columns(self):
return [SearchColumn('username', title=_('Login Name'), sorted=True,
data_type=str, width=150, searchable=True),
SearchColumn('profile_name', title=_('Profile'),
data_type=str, width=120,
ellipsize=pango.ELLIPSIZE_END),
SearchColumn('name', title=_('Name'), data_type=str,
expand=True),
Column('status_str', title=_('Status'), data_type=str,
width=80)]
def get_columns(self):
return [IdentifierColumn('identifier', title=_('Payment #'), sorted=True),
SearchColumn('description', title=_('Description'),
data_type=str, expand=True),
SearchColumn('drawee', title=_('Drawee'),
data_type=str, width=200),
SearchColumn('due_date', title=_('Due Date'),
data_type=datetime.date, width=100),
SearchColumn('value', title=_('Value'),
data_type=currency, width=145), ]
