def setup_proxies(self):
self.details_btn.set_sensitive(False)
self.workorders.set_columns([
IdentifierColumn('identifier', title=_('WO #'), sorted=True),
IdentifierColumn('sale_identifier', title=_("Sale #"), visible=False),
Column('status_str', _(u"Status"), data_type=str),
Column('equipment', _(u"Equipment (Description)"), data_type=str,
expand=True, pack_end=True),
Column('category_color', title=_(u'Equipment'),
column='equipment', data_type=GdkPixbuf.Pixbuf,
format_func=render_pixbuf),
Column('flag_icon', title=_(u'Equipment'), column='equipment',
data_type=GdkPixbuf.Pixbuf, format_func_data=True,
format_func=self._format_state_icon),
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_receiving_columns(self):
return [
IdentifierColumn("order_identifier",
title=_('Receiving #'),
sorted=True),
Column('batch_number',
title=_('Batch'),
data_type=str,
visible=self._is_batch),
Column('batch_date',
title=_('Batch Date'),
data_type=datetime.date,
visible=False),
Column("receival_date",
title=_("Date"),
data_type=datetime.date,
justify=Gtk.Justification.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.Justification.RIGHT),
Column("quantity",
title=_("Quantity"),
data_type=Decimal,
justify=Gtk.Justification.RIGHT),
Column("cost", title=_("Cost"), data_type=currency),
Column("unit_description", title=_("Unit"), data_type=str)
]
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_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', 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_returned_columns(self):
return [
IdentifierColumn("returned_identifier",
title=_('Returned #'),
sorted=True),
Column('batch_number',
title=_('Batch'),
data_type=str,
visible=self._is_batch),
Column('batch_date',
title=_('Batch Date'),
data_type=datetime.date,
visible=False),
Column("reason", title=_(u"Reason"), data_type=str, expand=True),
Column("quantity",
title=_(u"Quantity"),
data_type=Decimal,
format_func=format_quantity),
Column("invoice_number",
title=_(u"Invoice"),
data_type=int,
visible=False),
Column("price",
title=_(u"Price"),
data_type=currency,
format_func=get_formatted_cost),
Column("return_date",
title=_(u"Return Date"),
data_type=datetime.date,
justify=Gtk.Justification.RIGHT)
]
def _get_inventory_columns(self):
return [
IdentifierColumn("inventory_identifier",
title=_('Inventory #'),
sorted=True),
Column('batch_number',
title=_('Batch'),
data_type=str,
visible=self._is_batch),
Column('batch_date',
title=_('Batch Date'),
data_type=datetime.date,
visible=False),
Column("responsible_name", title=_("Responsible"), data_type=str),
Column("open_date",
title=_("Open date"),
data_type=datetime.date,
justify=Gtk.Justification.RIGHT),
Column("close_date",
title=_("Close date"),
data_type=datetime.date,
justify=Gtk.Justification.RIGHT),
Column("recorded_quantity",
title=_("Recorded qty"),
data_type=Decimal,
format_func=format_quantity),
Column("actual_quantity",
title=_("Counted qty"),
data_type=Decimal,
format_func=format_quantity),
Column("product_cost",
title=_("Cost"),
data_type=currency,
format_func=get_formatted_cost)
]
def _get_loan_columns(self):
return [
IdentifierColumn("loan_identifier", title=('Loan #'), sorted=True),
Column('batch_number',
title=_('Batch'),
data_type=str,
visible=self._is_batch),
Column('batch_date',
title=_('Batch Date'),
data_type=datetime.date,
visible=False),
Column("opened",
title=_(u"Opened"),
data_type=datetime.date,
justify=Gtk.Justification.RIGHT),
Column("code", title=_(u"Code"), data_type=str, visible=False),
Column("category_description",
title=_(u"Category"),
data_type=str,
visible=False),
Column("description",
title=_(u"Description"),
data_type=str,
expand=True),
Column("unit_description", title=_(u"Unit"), data_type=str),
Column("quantity", title=_(u"Loaned"), data_type=Decimal),
Column("sale_quantity", title=_(u"Sold"), data_type=Decimal),
Column("return_quantity", title=_(u"Returned"), data_type=Decimal)
]
def _get_transfer_columns(self):
return [
IdentifierColumn("transfer_order.identifier",
title=_('Transfer #'),
sorted=True),
Column('batch_number',
title=_('Batch'),
data_type=str,
visible=self._is_batch),
Column('batch_date',
title=_('Batch Date'),
data_type=datetime.date,
visible=False),
Column("transfer_order.open_date",
title=_("Date Created"),
data_type=datetime.date,
justify=Gtk.Justification.RIGHT),
Column("transfer_order.source_branch_name",
title=_("Source"),
expand=True,
data_type=str),
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("item_quantity", title=_("Transfered"), data_type=Decimal)
]
def _get_payments_columns(self):
return [
IdentifierColumn('identifier', title=_('Payment #')),
Column('method.description', _("Type"), data_type=str, width=60),
Column('description',
_("Description"),
data_type=str,
width=150,
expand=True),
Column('due_date',
_("Due date"),
sorted=True,
data_type=datetime.date,
width=90,
justify=Gtk.Justification.RIGHT),
Column('paid_date',
_("Paid date"),
data_type=datetime.date,
width=90),
Column('status_str', _("Status"), data_type=str, width=80),
ColoredColumn('base_value',
_("Value"),
data_type=currency,
width=90,
color='red',
justify=Gtk.Justification.RIGHT,
data_func=payment_value_colorize),
ColoredColumn('paid_value',
_("Paid value"),
data_type=currency,
width=92,
color='red',
justify=Gtk.Justification.RIGHT,
data_func=payment_value_colorize)
]
def _get_payments_columns(self):
return [
IdentifierColumn('identifier', title=_('Payment #')),
Column('description',
_("Description"),
data_type=str,
expand=True,
ellipsize=Pango.EllipsizeMode.END),
Column('due_date',
_("Due date"),
sorted=True,
data_type=datetime.date,
justify=Gtk.Justification.RIGHT),
Column('paid_date', _("Paid date"), data_type=datetime.date),
Column('status_str', _("Status"), data_type=str),
ColoredColumn('value',
_("Value"),
data_type=currency,
justify=Gtk.Justification.RIGHT,
use_data_model=True,
data_func=payment_value_colorize),
ColoredColumn('paid_value',
_("Paid value"),
data_type=currency,
justify=Gtk.Justification.RIGHT,
use_data_model=True,
data_func=payment_value_colorize)
]
def _get_payments_columns(self):
return [
IdentifierColumn("identifier", title=_('Payment #')),
Column("method.description",
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("status_str", title=_("Status"), width=80, data_type=str),
ColoredColumn("base_value",
title=_("Value"),
justify=Gtk.Justification.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.Justification.RIGHT,
data_type=str)
]
def _get_columns(self):
return [
IdentifierColumn('identifier', title=_('Purchase #'), 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 get_columns(self):
return [
IdentifierColumn('purchase_identifier', _('Purchase #')),
SearchColumn('purchase_date',
_('Purchase date'),
data_type=datetime.date,
width=110),
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_payments_columns(self):
return [
IdentifierColumn('identifier', title=_('Payment #'), 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.Justification.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.Justification.RIGHT,
visible=False),
Column('paid_value',
_("Paid value"),
data_type=currency,
justify=Gtk.Justification.RIGHT)
]
def get_columns(self):
return [
IdentifierColumn("identifier", title=_('WO #'), sorted=True),
Column("equipment",
title=_("Equipment"),
data_type=str,
expand=True,
pack_end=True),
Column('category_color',
title=_(u'Equipment'),
column='equipment',
data_type=GdkPixbuf.Pixbuf,
format_func=render_pixbuf),
Column('flag_icon',
title=_(u'Equipment'),
column='equipment',
data_type=GdkPixbuf.Pixbuf,
format_func_data=True,
format_func=self._format_state_icon),
Column("open_date",
title=_("Open date"),
data_type=datetime.date,
width=120),
Column("approve_date",
title=_("Approve date"),
data_type=datetime.date,
width=120),
Column("finish_date",
title=_("Finish date"),
data_type=datetime.date,
width=120),
Column("total", title=_("Total"), data_type=currency, width=100)
]
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):
columns = [
IdentifierColumn('identifier', title=_('Sale #'),
sorted=True),
Column('status_name', title=_(u'Status'), data_type=str,
visible=True),
SearchColumn('open_date', title=_('Date Started'), width=110,
data_type=date, justify=Gtk.Justification.RIGHT),
]
if api.sysparam.get_bool('USE_SALE_TOKEN'):
columns.append(Column('token_str', title=_(u'Sale token'),
data_type=str, visible=True))
columns.extend([
SearchColumn('client_name', title=_('Client'),
data_type=str, expand=True,
ellipsize=Pango.EllipsizeMode.END),
SearchColumn('salesperson_name', title=_('Salesperson'),
data_type=str, width=180,
ellipsize=Pango.EllipsizeMode.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),
SearchColumn('missing_payment', title=_('Missing Payment'), data_type=currency,
width=150),
])
return columns
def get_columns(self):
return [IdentifierColumn('identifier', title=_('Purchase #')),
SearchColumn('status_str', title=_('Status'), width=100,
data_type=str, search_attribute='status',
valid_values=self._get_status_values(),
visible=False),
SearchColumn('invoice_numbers', title=_('Invoice'), width=100,
data_type=str, visible=False),
SearchColumn('open_date', title=_('Opened'),
long_title=_('Date Opened'), width=90,
data_type=datetime.date, sorted=True,
order=Gtk.SortType.DESCENDING),
SearchColumn('receival_date', title=_('Receival'),
long_title=_('Received date'), width=90,
data_type=datetime.date,
order=Gtk.SortType.DESCENDING),
SearchColumn('supplier_name', title=_('Supplier'),
data_type=str, searchable=True, expand=True,
ellipsize=Pango.EllipsizeMode.END),
SearchColumn('ordered_quantity', title=_('Ordered'),
data_type=Decimal, width=90,
format_func=format_quantity),
SearchColumn('received_quantity', title=_('Received'),
data_type=Decimal, width=90,
format_func=format_quantity),
SearchColumn('total', title=_('Total'),
data_type=currency, width=120)]
def get_columns(self):
return [IdentifierColumn('identifier', title=_(u"Returned #")),
IdentifierColumn('sale_identifier', _('Sale #')),
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),
SearchColumn('responsible_name', _('Responsible'),
data_type=str),
SearchColumn('branch_name', _('Returned on Branch'),
data_type=str),
SearchColumn('invoice_number', _('Invoice number'),
data_type=int, visible=False),
]
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):
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=_('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('open_date',
title=_('Open date'),
data_type=datetime.date,
width=120,
visible=False),
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 [
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):
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', title=_('WO #'), sorted=True),
SearchColumn('status_str',
title=_('Status'),
search_attribute='status',
visible=False,
valid_values=self._get_status_values(),
data_type=str),
Column('equipment',
title=_('Equipment (Description)'),
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, *args):
return [IdentifierColumn('identifier', title=_('Entry #'), sorted=True),
Column('date', _('Date'), data_type=datetime.date),
Column('time', _('Time'), data_type=datetime.time),
Column('description', _('Description'), data_type=str,
expand=True),
ColoredColumn('value', _('Value'), data_type=currency,
color='red', data_func=payment_value_colorize,
width=140)]
def _setup_widgets(self):
self._prefill_branches()
for widget in [self.details_btn, self.edit_btn]:
widget.set_sensitive(False)
self.workorders.set_columns([
Column('will_send', _(u"Send"), data_type=bool, editable=True),
IdentifierColumn('identifier', title=_('WO #'), sorted=True),
IdentifierColumn('sale_identifier',
title=_("Sale #"),
visible=False),
Column('status_str', _(u"Status"), data_type=str),
Column('equipment',
_(u"Equipment (Description)"),
data_type=str,
expand=True,
pack_end=True),
Column('category_color',
title=_(u'Equipment'),
column='equipment',
data_type=GdkPixbuf.Pixbuf,
format_func=render_pixbuf),
Column('flag_icon',
title=_(u'Equipment'),
column='equipment',
data_type=GdkPixbuf.Pixbuf,
format_func_data=True,
format_func=self._format_state_icon),
Column('branch_name', _(u"Branch"), data_type=str, visible=False),
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)
])
self._refresh_workorders()
def _get_payment_columns(self):
return [
IdentifierColumn("identifier", title=_('Payment #')),
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_columns(self):
return [Column('selected', title=" ", width=50,
data_type=bool, editable=True),
IdentifierColumn('obj.identifier', title=_(u'Order #')),
Column('obj.description', title=_(u"Description"),
data_type=str, sorted=True),
Column('obj.responsible_name', title=_(u"Responsible"),
data_type=str),
Column('obj.open_date', title=_(u"Opened"),
data_type=datetime.date)]
