def _get_columns(self):
return [
IdentifierColumn('identifier', title=_("Quote #"), sorted=True),
IdentifierColumn('group_identifier', title=_('Group #')),
Column('supplier_name',
title=_('Supplier'),
data_type=str,
width=300),
Column('open_date', title=_('Open date'), data_type=datetime.date),
Column('deadline', title=_('Deadline'), data_type=datetime.date)
]
def _get_receiving_columns(self):
return [IdentifierColumn("order_identifier", sorted=True),
Column("receival_date", title=_("Date"),
data_type=datetime.date, justify=gtk.JUSTIFY_RIGHT),
IdentifierColumn("purchase_identifier",
title=_("Purchase #")),
Column("supplier_name", title=_("Supplier"), expand=True,
data_type=str),
Column("invoice_number", title=_("Invoice"), data_type=str,
justify=gtk.JUSTIFY_RIGHT),
Column("quantity", title=_("Quantity"), data_type=Decimal,
justify=gtk.JUSTIFY_RIGHT),
Column("unit_description", title=_("Unit"), data_type=str)]
def get_columns(self):
return [
IdentifierColumn('sale_identifier',
title=_('Sale #'),
order=gtk.SORT_DESCENDING),
SearchColumn('status_str',
title=_('Status'),
data_type=str,
search_attribute='status',
valid_values=self._get_status_values()),
Column('address_str',
title=_('Address'),
data_type=str,
expand=True,
ellipsize=pango.ELLIPSIZE_END),
SearchColumn('tracking_code',
title=_('Tracking code'),
data_type=str),
SearchColumn('transporter_name',
title=_('Transporter'),
data_type=str),
SearchColumn('client_name', title=_('Client'), data_type=str),
SearchColumn('open_date',
title=_('Open date'),
data_type=datetime.date,
visible=False),
SearchColumn('deliver_date',
title=_('Sent date'),
data_type=datetime.date,
visible=False),
SearchColumn('receive_date',
title=_('Received date'),
data_type=datetime.date,
visible=False),
]
def _get_payments_columns(self):
return [
IdentifierColumn('identifier', sorted=True),
Column('method.description', _("Method"), data_type=str, width=60),
Column('description', _("Description"), data_type=str,
expand=True),
Column('due_date',
_("Due date"),
visible=False,
data_type=datetime.date,
width=90,
justify=gtk.JUSTIFY_RIGHT),
Column('paid_date',
_("Paid date"),
data_type=datetime.date,
width=90),
Column('status_str', _("Status"), data_type=str, width=80),
Column('value',
_("Value"),
data_type=currency,
justify=gtk.JUSTIFY_RIGHT,
visible=False),
Column('paid_value',
_("Paid value"),
data_type=currency,
justify=gtk.JUSTIFY_RIGHT)
]
def get_columns(self):
columns = [
IdentifierColumn('identifier', title=_('Sale #'), sorted=True),
SearchColumn('salesperson_name', title=_('Salesperson'),
data_type=str, expand=True),
# 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(self.store).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_payments_columns(self):
return [
IdentifierColumn('identifier'),
Column("method_name", title=_("Type"), data_type=str, width=90),
Column("description",
title=_("Description"),
data_type=str,
searchable=True,
width=190,
expand=True),
Column("due_date",
title=_("Due date"),
width=110,
data_type=datetime.date,
sorted=True),
Column("paid_date",
title=_("Paid date"),
width=110,
data_type=datetime.date),
Column("status_str", title=_("Status"), width=80, data_type=str),
ColoredColumn("value",
title=_("Value"),
justify=gtk.JUSTIFY_RIGHT,
data_type=currency,
color='red',
width=100,
data_func=payment_value_colorize),
Column("days_late",
title=_("Days Late"),
width=110,
format_func=(
lambda days_late: days_late and str(days_late) or u""),
justify=gtk.JUSTIFY_RIGHT,
data_type=str)
]
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', title=_(u'#'), sorted=True),
SearchColumn('work_order.status_str',
title=_('Status'),
search_attribute='status',
visible=False,
valid_values=self._get_status_values(),
data_type=str),
SearchColumn('equipment',
title=_('Equipment'),
data_type=str,
expand=True),
SearchColumn('client_name', title=_('Client'), data_type=str),
SearchColumn('open_date',
title=_('Open date'),
data_type=datetime.date),
SearchColumn('approve_date',
title=_('Approval date'),
data_type=datetime.date,
visible=False),
SearchColumn('finish_date',
title=_('Finish date'),
data_type=datetime.date),
SearchColumn('total', title=_('Total'), data_type=currency),
]
def get_columns(self):
return [
IdentifierColumn('loan_identifier', 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):
return [
IdentifierColumn('order.identifier',
title=_('Order #'),
sorted=True),
Column('sellable.code', title=_('Code'), width=70, data_type=str),
Column('sellable.description',
title=_('Description'),
data_type=str,
expand=True,
searchable=True),
Column('quantity_received',
title=_('Consigned'),
data_type=Decimal,
format_func=format_quantity),
Column('quantity_sold',
title=_('Sold'),
data_type=Decimal,
width=90),
Column('quantity_returned',
title=_('Returned'),
data_type=Decimal,
width=90),
Column('cost',
title=_('Cost'),
data_type=currency,
format_func=get_formatted_cost),
Column('total_sold', title=_('Total Sold'), data_type=currency),
]
def get_columns(self):
return [
IdentifierColumn('identifier',
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)
]
def _get_columns(self):
return [
IdentifierColumn('identifier'),
Column('description',
_("Description"),
data_type=str,
width=150,
expand=True,
ellipsize=pango.ELLIPSIZE_END),
Column('due_date',
_("Due date"),
sorted=True,
data_type=datetime.date,
width=90,
justify=gtk.JUSTIFY_RIGHT),
Column('paid_date',
_("Paid date"),
data_type=datetime.date,
width=90),
Column('status_str', _("Status"), data_type=str, width=80),
ColoredColumn('value',
_("Value"),
data_type=currency,
width=90,
color='red',
justify=gtk.JUSTIFY_RIGHT,
data_func=payment_value_colorize),
ColoredColumn('paid_value',
_("Paid value"),
data_type=currency,
width=92,
color='red',
justify=gtk.JUSTIFY_RIGHT,
data_func=payment_value_colorize)
]
def _get_columns(self):
return [
IdentifierColumn('identifier', sorted=True),
SearchColumn('open_date',
title=_('Date Started'),
data_type=datetime.date,
width=100),
SearchColumn('expected_receival_date',
data_type=datetime.date,
title=_('Expected Receival'),
visible=False),
SearchColumn('supplier_name',
title=_('Supplier'),
data_type=str,
searchable=True,
width=130,
expand=True),
SearchColumn('ordered_quantity',
title=_('Qty Ordered'),
data_type=Decimal,
width=110,
format_func=format_quantity),
SearchColumn('received_quantity',
title=_('Qty Received'),
data_type=Decimal,
width=145,
format_func=format_quantity),
SearchColumn('total',
title=_('Order Total'),
data_type=currency,
width=120)
]
def setup_proxies(self):
self.details_btn.set_sensitive(False)
self.workorders.set_columns([
IdentifierColumn('identifier'),
Column('work_order.status_str', _(u"Status"), data_type=str),
Column('equipment',
_(u"Equipment"),
data_type=str,
expand=True,
editable=True),
Column('client_name', _(u"Client"), data_type=str),
Column('salesperson_name',
_(u"Salesperson"),
data_type=str,
visible=False),
Column('open_date',
_(u"Open date"),
data_type=datetime.date,
visible=False),
Column('approve_date',
_(u"Approval date"),
data_type=datetime.date)
])
# Clear first to avoid duplication if the users goes back on the wizard
self.workorders.clear()
self.workorders.extend(self._find_orders())
self.add_proxy(self.model, self.proxy_widgets)
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 [
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 [
IdentifierColumn('purchase_identifier', _('Purchase #')),
SearchColumn('receival_date',
_('Receival date'),
data_type=datetime.date,
sorted=True,
width=110),
SearchColumn('supplier_name',
_('Supplier'),
data_type=str,
expand=True),
SearchColumn('responsible_name',
_('Responsible'),
data_type=str,
visible=False,
expand=True),
SearchColumn('purchase_responsible_name',
_('Purchaser'),
data_type=str,
visible=False,
expand=True),
SearchColumn('invoice_number',
_('Invoice #'),
data_type=int,
width=80),
SearchColumn('invoice_total',
_('Invoice total'),
data_type=currency,
width=120)
]
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)
]
class _CreditInfoListSlave(ModelListSlave):
model_type = Payment
editor_class = None
columns = [
IdentifierColumn('identifier', sorted=True),
Column('date', title=_(u'Date'), data_type=datetime.date, width=150),
Column('description',
title=_(u'Description'),
data_type=str,
width=150,
expand=True),
ColoredColumn('value',
title=_(u'Value'),
color='red',
data_type=currency,
width=100,
data_func=lambda x: x < decimal.Decimal(0))
]
def __init__(self, *args, **kwargs):
ModelListSlave.__init__(self, *args, **kwargs)
self.set_list_type(ListType.ADDONLY)
def populate(self):
return self.parent.person.get_credit_transactions()
def run_editor(self, store, model):
store.savepoint('before_run_editor_credit')
retval = self.run_dialog(CreditEditor,
store=self.store,
client=self.parent.person)
if not retval:
store.rollback_to_savepoint('before_run_editor_credit')
return retval
def _get_purchase_columns(self):
return [IdentifierColumn("identifier", sorted=True),
Column("open_date", title=_("Date"), data_type=datetime.date,
justify=gtk.JUSTIFY_RIGHT, width=80),
Column("status_str", title=_("Status"), width=80,
data_type=str),
Column("total", title=_("Total"), justify=gtk.JUSTIFY_RIGHT,
data_type=currency, width=100)]
def _get_decrease_columns(self):
return [IdentifierColumn("decrease_identifier", sorted=True),
Column("date", title=_("Date"), data_type=datetime.date,
justify=gtk.JUSTIFY_RIGHT),
Column("removed_by_name", title=_("Removed By"), expand=True,
data_type=str),
Column("quantity", title=_("Quantity"), data_type=int),
Column("unit_description", title=_("Unit"), data_type=str)]
def _get_payment_columns(self):
return [
IdentifierColumn("identifier"),
Column("method.description", title=_("Type"), data_type=str),
Column("description", title=_("Description"), data_type=str),
Column("due_date", title=_("Due date"), data_type=datetime.date),
Column("paid_date", title=_("Paid date"), data_type=datetime.date),
Column("value", title=_("Value"), data_type=currency),
Column("paid_value", title=_("Paid value"), data_type=currency),
]
def _get_sale_columns(self):
return [IdentifierColumn("sale_identifier", sorted=True),
Column("sale_date",
title=_("Date Started"), data_type=datetime.date,
justify=gtk.JUSTIFY_RIGHT),
Column("client_name",
title=_("Client"), expand=True, data_type=str),
Column("quantity", title=_("Sold"),
data_type=int),
Column("unit_description",
title=_("Unit"), data_type=str)
]
def get_columns(self, *args):
return [IdentifierColumn('identifier', sorted=True),
SearchColumn('date', title=_('Date'), width=100,
data_type=datetime.date, justify=gtk.JUSTIFY_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.JUSTIFY_RIGHT),
SearchColumn('value', _('Value'), data_type=currency,
width=80)]
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('supplier_name',
title=_('Supplier'),
data_type=str,
width=140,
ellipsize=pango.ELLIPSIZE_END),
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):
return [IdentifierColumn('identifier', title=_(u"Loan #")),
Column('open_date', _('Open date'),
data_type=datetime.date, sorted=True, width=100),
Column('expire_date', _('Expire date'),
data_type=datetime.date, width=100),
Column('branch_name', _('Branch'),
data_type=unicode, expand=True),
Column('client_name', _('Client'),
data_type=unicode, width=120),
Column('removed_by', _('Removed by'), data_type=unicode,
width=120),
]
def get_columns(self):
return [IdentifierColumn('identifier'),
Column('confirm_date', _('Date'),
data_type=datetime.date, sorted=True, width=100),
Column('branch_name', _('Branch'),
data_type=unicode, expand=True),
Column('removed_by_name', _('Removed By'),
data_type=unicode, width=120),
Column('total_items_removed',
_('Items removed'), data_type=Decimal, width=110),
Column('cfop_description', u'CFOP', data_type=unicode,
expand=True)
]
def _get_columns(self):
return [IdentifierColumn('identifier', 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_transfer_columns(self):
return [IdentifierColumn("transfer_order.identifier", sorted=True),
Column("transfer_order.open_date",
title=_("Date Created"), data_type=datetime.date,
justify=gtk.JUSTIFY_RIGHT),
Column("transfer_order.destination_branch_name",
title=_("Destination"), expand=True,
data_type=str),
Column("transfer_order.source_responsible_name",
title=_("Responsible"), expand=True,
data_type=str),
Column("quantity", title=_("Transfered"),
data_type=Decimal)]
def _get_payment_columns(self):
return [
SearchColumn('due_date',
title=_("Due date"),
data_type=datetime.date,
sorted=True),
IdentifierColumn('identifier', title=_("Code")),
SearchColumn('description',
title=_("Description"),
data_type=unicode,
expand=True),
SearchColumn('value', title=_("Value"), data_type=currency)
]