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_columns(self):
# TODO: Add status column
return [
IdentifierColumn('identifier', title=_(u"Item #")),
IdentifierColumn('sale_identifier',
_('Sale #'),
data_type=str,
search_attribute='sale_identifier_str'),
SearchColumn('status_str',
_('Status'),
data_type=str,
search_attribute='status',
valid_values=self._get_status_values()),
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',
_('Branch'),
data_type=str,
visible=False),
SearchColumn('invoice_number',
_('Invoice number'),
data_type=int,
visible=False),
]
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=gtk.gdk.Pixbuf,
format_func=render_pixbuf),
Column('flag_icon', title=_(u'Equipment'), column='equipment',
data_type=gtk.gdk.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.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("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('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_payments_columns(self):
return [
IdentifierColumn('identifier', title=_('Payment #')),
Column('description',
_("Description"),
data_type=str,
expand=True,
ellipsize=pango.ELLIPSIZE_END),
Column('due_date',
_("Due date"),
sorted=True,
data_type=datetime.date,
justify=gtk.JUSTIFY_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.JUSTIFY_RIGHT,
use_data_model=True,
data_func=payment_value_colorize),
ColoredColumn('paid_value',
_("Paid value"),
data_type=currency,
justify=gtk.JUSTIFY_RIGHT,
use_data_model=True,
data_func=payment_value_colorize)
]
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_sales_columns(self):
return [IdentifierColumn('identifier', title=_('Sale #'), sorted=True),
Column('salesperson', title=_('Sales Person'), data_type=str),
Column('client', title=_('Client'), data_type=str, expand=True),
Column('branch', title=_('Branch'), data_type=str, visible=False),
Column('value', title=_('Value'), data_type=str,
justify=Gtk.Justification.RIGHT)]
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', title=_('Purchase #')),
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_work_order_columns(self):
return [
IdentifierColumn("identifier", sorted=True),
Column("equipment",
title=_("Equipment"),
data_type=str,
expand=True,
pack_end=True),
Column('category_color',
title=_(u'Equipment'),
column='equipment',
data_type=gtk.gdk.Pixbuf,
format_func=render_pixbuf),
Column('flag_icon',
title=_(u'Equipment'),
column='equipment',
data_type=gtk.gdk.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_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.JUSTIFY_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.JUSTIFY_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 #'), 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_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('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):
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_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_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.JUSTIFY_RIGHT),
Column("close_date",
title=_("Close date"),
data_type=datetime.date,
justify=gtk.JUSTIFY_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_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.JUSTIFY_RIGHT)
]
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_payments_columns(self):
return [
IdentifierColumn('identifier'),
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.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', 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',
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('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_lonely_payments_columns(self):
return [IdentifierColumn('identifier', title=_('Payment #'), sorted=True),
Column('method', title=_('Method'), data_type=str),
Column('description', title=_('Description'), expand=True,
data_type=str),
Column('branch', title=_('Branch'), data_type=str, visible=False),
Column('value', title=_('Payment Value'), data_type=currency)]
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=_('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 [
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)
]
