def get_columns(self):
return [
SearchColumn('name', _('Name'), str, sorted=True, expand=True),
SearchColumn('phone_number',
_('Phone Number'),
str,
format_func=format_phone_number,
width=110),
# Translators: http://en.wikipedia.org/wiki/Doing_business_as
SearchColumn('fancy_name', _('DBA'), str, width=180),
SearchColumn('cnpj', self.company_doc_l10n.label, str, width=140)
]
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'),
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, *args):
return [IdentifierColumn('identifier', title=_('Payment #'), sorted=True),
SearchColumn('date', title=_('Date'), width=100,
data_type=datetime.date, justify=Gtk.Justification.RIGHT),
SearchColumn('description', title=_('Description'),
data_type=str, expand=True),
SearchColumn('station_name', title=_('Station'), data_type=str,
width=120),
SearchColumn('cfop', title=_('C.F.O.P.'), data_type=str,
width=100, justify=Gtk.Justification.RIGHT),
SearchColumn('value', _('Value'), data_type=currency,
width=80)]
def get_columns(self):
return [
SearchColumn('code',
_('C.F.O.P.'),
data_type=str,
sorted=True,
width=90),
SearchColumn('description',
_('Description'),
data_type=str,
searchable=True,
expand=True)
]
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=unicode,
expand=True),
SearchColumn('value', title=_("Value"), data_type=currency)
]
def _get_columns(self):
return [IdentifierColumn('identifier', title=_('Loan #'), sorted=True),
SearchColumn('responsible_name', title=_(u'Responsible'),
data_type=str, expand=True),
SearchColumn('client_name', title=_(u'Client'),
data_type=str, expand=True),
SearchColumn('open_date', title=_(u'Opened'),
data_type=datetime.date),
SearchColumn('expire_date', title=_(u'Expire'),
data_type=datetime.date),
Column('loaned', title=_(u'Loaned'),
data_type=Decimal),
]
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 [
SearchColumn('name', _('Name'), str, expand=True, sorted=True),
SearchColumn('fancy_name',
_('Fancy name'),
str,
expand=True,
visible=False),
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):
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):
return [IdentifierColumn('order_identifier', title=_(u"Order #")),
SearchColumn('code', title=_(u'Code'), data_type=str,
width=40),
SearchColumn('description', title=_(u'Description'),
data_type=str, width=250, expand=True),
Column('stocked', title=_(u'Stock'),
data_type=Decimal),
Column('received', title=_(u'Consigned'),
data_type=Decimal),
Column('sold', title=_(u'Sold'),
data_type=Decimal),
Column('returned', title=_(u'Returned'),
data_type=Decimal)]
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):
return [IdentifierColumn('identifier', long_title=_("Payment #")),
SearchColumn('description', title=_('Description'),
data_type=str, ellipsize=pango.ELLIPSIZE_END,
expand=True, pack_end=True),
Column('color', title=_('Description'), width=20,
data_type=gtk.gdk.Pixbuf, format_func=render_pixbuf,
column='description'),
Column('comments_number', title=_(u'Comments'),
visible=False),
SearchColumn('drawee', title=_('Drawee'), data_type=str,
ellipsize=pango.ELLIPSIZE_END, width=140),
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'),
long_title=_('Paid value'),
data_type=currency, width=90),
SearchColumn('category', title=_('Category'), data_type=str,
long_title=_('Payment category'), width=110,
visible=False)]
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 [
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('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=_('Production #'), sorted=True,
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),
SearchColumn('cancel_date', title=_(u'Cancelled'),
data_type=datetime.date, width=80)]
def get_columns(self):
return [IdentifierColumn('identifier', title=_('Code'),
sorted=True, order=gtk.SORT_DESCENDING),
SearchColumn('status_str', title=_('Status'),
data_type=str, width=100,
valid_values=self._get_status_values(),
search_attribute='status'),
Column('branch.person.name', 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 [
SearchColumn('name', _('Name'), str, sorted=True, expand=True),
SearchColumn('client_category',
_('Category'),
str,
width=150,
visible=False),
SearchColumn('phone_number',
_('Phone Number'),
str,
format_func=format_phone_number,
width=150),
SearchColumn('mobile_number',
_('Mobile Number'),
str,
format_func=format_phone_number,
width=150,
visible=False),
Column('cnpj_or_cpf', _('Document'), str, width=150),
SearchColumn('cnpj',
self.company_doc_l10n.label,
str,
width=150,
visible=False),
SearchColumn('cpf',
self.person_doc_l10n.label,
str,
width=130,
visible=False),
SearchColumn('rg_number', _('RG'), str, width=120),
SearchColumn('birth_date',
_('Birth Date'),
datetime.date,
visible=False,
search_func=self.birthday_search,
search_label=_('Birthday')),
SearchColumn('fancy_name',
_('Fancy Name'),
data_type=str,
width=150,
visible=False),
SearchColumn('email',
_('Email'),
data_type=str,
width=150,
visible=False)
]
def get_columns(self):
return [
IdentifierColumn('sale_identifier', title=_("Sale #")),
SearchColumn('status_str',
title=_(u'Status'),
search_attribute='status',
data_type=str,
valid_values=self._get_status_values()),
SearchColumn('client_name',
title=_(u'Client'),
data_type=str,
expand=True),
Column('flag_icon',
title=_(u'Status (Description)'),
column='client_name',
data_type=gtk.gdk.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):
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):
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),
Column('method_description', title=_(u'Method'),
data_type=str, width=90),
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('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('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 _setup_ipi_columns(self):
col = SearchColumn('ipi_value',
title=_('IPI Total'),
justify=gtk.JUSTIFY_RIGHT,
data_type=currency, width=100)
self._setup_columns(col, IcmsIpiView, 'ipi_value',
_("IPI Total:"))
def _setup_icms_columns(self):
col = SearchColumn('icms_value',
title=_('ICMS Total'),
justify=Gtk.Justification.RIGHT,
data_type=currency,
width=100)
self._setup_columns(col, IcmsIpiView, 'icms_value', _("ICMS Total:"))
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 [
SearchColumn('manufacturer_name',
title=_('Manufacturer'),
data_type=str,
visible=False)
]
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):
columns = _BaseBillCheckSearch.get_columns(self)
columns.append(
SearchColumn('bill_received', title=_('Bill received'),
data_type=bool, visible=False)
)
return columns
