def get_columns(self):
return [SearchColumn('ncm', title='NCM', data_type=str)]
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),
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
def get_columns(self):
return [SearchColumn('name', _('Name'), str, width=250, expand=True)]
def get_columns(self):
columns = [
IdentifierColumn('identifier', title=_('Sale #')),
SearchColumn('open_date',
title=_('Open date'),
data_type=datetime.date,
visible=False),
SearchColumn('confirm_date',
title=_('Confirm date'),
data_type=datetime.date,
visible=False),
SearchColumn('code', title=_('Code'), data_type=str, sorted=True),
SearchColumn('category',
title=_('Category'),
data_type=str,
visible=False),
SearchColumn('branch_name',
title=_('Branch'),
data_type=str,
visible=False),
SearchColumn('description',
title=_('Description'),
data_type=str,
expand=True),
SearchColumn('manufacturer',
title=_('Manufacturer'),
data_type=str,
visible=False),
SearchColumn('medic_name', title=_('Medic'), data_type=str),
SearchColumn('crm_number', title=_('CRM'), data_type=str),
SearchColumn('partner',
title=_('Partner'),
data_type=bool,
visible=False,
width=40),
SearchColumn('batch_number',
title=_('Batch'),
data_type=str,
visible=False),
SearchColumn('batch_date',
title=_('Batch Date'),
data_type=datetime.date,
visible=False),
SearchColumn('quantity',
title=_('Qty'),
data_type=decimal.Decimal,
format_func=format_quantity),
SearchColumn('total', title=_('Total'), data_type=currency),
]
return columns
def get_columns(self):
return [
IdentifierColumn('identifier', title=_('WO #'), sorted=True),
IdentifierColumn('sale_identifier',
title=_("Sale #"),
visible=False),
SearchColumn('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,
multiple_selection=True,
search_attribute='category_id',
valid_values=self._get_category_values()),
Column('equipment',
title=_(u'Equipment (Description)'),
data_type=str,
expand=True,
pack_end=True),
Column('category_color',
title=_(u'Equipment (Description)'),
column='equipment',
data_type=GdkPixbuf.Pixbuf,
format_func=render_pixbuf),
Column('flag_icon',
title=_(u'Equipment (Description)'),
column='equipment',
data_type=GdkPixbuf.Pixbuf,
format_func=self._format_state_icon,
format_func_data=True),
SearchColumn('client_name', title=_(u'Client'), data_type=str),
SearchColumn('branch_name',
title=_(u'Branch'),
data_type=str,
visible=False),
SearchColumn('current_branch_name',
title=_(u'Current branch'),
data_type=str,
visible=False),
SearchColumn('execution_branch_name',
title=_(u'Execution branch'),
data_type=str,
visible=False),
SearchColumn('supplier_order',
title=_("Supplier Order #"),
visible=False,
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('estimated_start',
title=_(u'Estimated start'),
data_type=datetime.date,
visible=False),
SearchColumn('estimated_finish',
title=_(u'Estimated finish'),
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),
]
def get_columns(self):
self._status_col = SearchColumn('status_name',
title=_('Status'),
data_type=str,
width=80,
visible=True,
search_attribute='status',
valid_values=self._get_status_values())
cols = [
IdentifierColumn('identifier', title=_('Sale #'), sorted=True),
SearchColumn('coupon_id',
title=_('Coupon #'),
width=100,
data_type=int,
visible=False),
SearchColumn('paid',
title=_('Paid'),
width=120,
data_type=bool,
visible=False),
SearchColumn('open_date',
title=_('Open date'),
width=120,
data_type=date,
justify=Gtk.Justification.RIGHT,
visible=False),
SearchColumn('close_date',
title=_('Close date'),
width=120,
data_type=date,
justify=Gtk.Justification.RIGHT,
visible=False),
SearchColumn('confirm_date',
title=_('Confirm date'),
data_type=date,
justify=Gtk.Justification.RIGHT,
visible=False,
width=120),
SearchColumn('cancel_date',
title=_('Cancel date'),
width=120,
data_type=date,
justify=Gtk.Justification.RIGHT,
visible=False),
SearchColumn('return_date',
title=_('Return date'),
width=120,
data_type=date,
justify=Gtk.Justification.RIGHT,
visible=False),
SearchColumn('expire_date',
title=_('Expire date'),
width=120,
data_type=date,
justify=Gtk.Justification.RIGHT,
visible=False), self._status_col
]
if api.sysparam.get_bool('USE_SALE_TOKEN'):
cols.append(
Column('token_str',
title=_(u'Sale token'),
data_type=str,
visible=True))
cols.extend([
SearchColumn('client_name',
title=_('Client'),
data_type=str,
width=140,
expand=True,
ellipsize=Pango.EllipsizeMode.END),
SearchColumn('client_fancy_name',
title=_('Client fancy name'),
data_type=str,
width=140,
expand=True,
visible=False,
ellipsize=Pango.EllipsizeMode.END),
SearchColumn('salesperson_name',
title=_('Salesperson'),
data_type=str,
width=130,
ellipsize=Pango.EllipsizeMode.END),
SearchColumn('total_quantity',
title=_('Items'),
data_type=decimal.Decimal,
width=60,
format_func=format_quantity),
SearchColumn('total',
title=_('Gross total'),
data_type=currency,
width=120,
search_attribute='_total'),
SearchColumn('net_total',
title=_('Net total'),
data_type=currency,
width=120,
search_attribute='_net_total')
])
return cols
def get_columns(self):
return [
IdentifierColumn('identifier',
title=_("Operation #"),
sorted=True,
width=110,
format_func=self._format_identifier),
SearchColumn('operation_nature',
title=_('Operation Nature'),
data_type=str),
SearchColumn('status_str',
title=_(u'Status'),
search_attribute='status',
data_type=str,
valid_values=self._get_status_values()),
SearchColumn('recipient_name',
title=_(u'Recipient'),
data_type=str,
expand=True),
Column('flag_icon',
title=_(u'Status (Description)'),
column='recipient_name',
data_type=GdkPixbuf.Pixbuf,
format_func=self._format_state_icon,
format_func_data=True),
SearchColumn('branch_name',
title=_(u'Branch'),
data_type=str,
visible=False),
SearchColumn('transporter_name',
title=_(u'Transporter'),
data_type=str),
SearchColumn('open_date',
title=_(u'Open date'),
data_type=datetime.date),
SearchColumn('cancel_date',
title=_(u'Cancel date'),
data_type=datetime.date,
visible=False),
SearchColumn('pick_date',
title=_(u'Pick date'),
data_type=datetime.date,
visible=False),
SearchColumn('pack_date',
title=_(u'Pack date'),
data_type=datetime.date,
visible=False),
SearchColumn('send_date',
title=_(u'Send date'),
data_type=datetime.date),
SearchColumn('receive_date',
title=_(u'Receive date'),
data_type=datetime.date,
visible=False),
]
def get_columns(self):
cols = [
SearchColumn('barcode',
title=_('Barcode'),
data_type=str,
sorted=True,
width=130),
SearchColumn('code', title=_('Code'), data_type=str,
visible=False),
SearchColumn('category_description',
title=_(u'Category'),
data_type=str,
width=100),
SearchColumn('subject', title=_(u'Subject'), data_type=str),
SearchColumn('description',
title=_(u'Title'),
expand=True,
data_type=str),
SearchColumn('author',
title=_(u'Author'),
expand=True,
data_type=str),
SearchColumn('publisher',
title=_(u'Publisher'),
expand=True,
data_type=str),
SearchColumn('isbn', title=_(u'ISBN'), data_type=str),
SearchColumn('volume',
title=_(u'Volume'),
data_type=str,
visible=False),
SearchColumn('series',
title=_(u'Series'),
data_type=str,
visible=False),
SearchColumn('language',
title=_(u'Language'),
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(
SearchColumn('stock',
title=_('Stock Total'),
format_func=format_quantity,
data_type=Decimal,
width=100))
return cols
def get_columns(self):
# TODO: Adicionar filtro por card_type
return [
IdentifierColumn('identifier', title=_('Payment #'), sorted=True),
SearchColumn('description',
title=_(u'Description'),
data_type=str,
expand=True),
SearchColumn('card_type',
title=_('Card Type'),
format_func=self._format_card_type,
valid_values=self._get_card_types(),
width=100,
visible=False),
SearchColumn('drawee_name',
title=_(u'Drawee'),
data_type=str,
expand=True),
SearchColumn('device_name',
title=_(u'Card Device'),
data_type=str,
visible=False,
search_attribute='device_id',
valid_values=self._get_device_values()),
SearchColumn('provider_name', title=_(u'Provider'), data_type=str),
SearchColumn('due_date',
title=_(u'Due date'),
data_type=datetime.date),
SearchColumn('open_date',
title=_(u'Open date'),
visible=False,
data_type=datetime.date),
SearchColumn('paid_date',
title=_(u'Paid date'),
visible=False,
data_type=datetime.date),
SearchColumn('status_str',
title=_(u'Status'),
data_type=str,
expand=True,
search_attribute='status',
valid_values=self._get_status_values()),
SearchColumn('value', title=_(u'Value'), data_type=currency),
SearchColumn('fare', title=_(u'Fare'), data_type=currency),
SearchColumn('fee',
title=_(u'% Fee'),
data_type=Decimal,
visible=False),
SearchColumn('fee_calc', title=_(u'Fee'), data_type=currency),
SearchColumn('auth',
title=_(u'Authorization'),
data_type=str,
visible=False)
]