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) ]