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'), SearchColumn('invoice_numbers', title=_('Invoice Numbers'), data_type=str), 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): 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 [ 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 [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 get_columns(self): columns = [ IdentifierColumn('identifier', title=_('Sale #'), sorted=True), SearchColumn('salesperson_name', title=_('Salesperson'), data_type=str, expand=True), SearchColumn('method_description', title=_('Method'), data_type=str, search_attribute='method_name', valid_values=self._get_method_values()), # 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.get_bool('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_columns(self): return [SearchColumn('code', title=_('Code'), data_type=str, sort_func=sort_sellable_code), SearchColumn('category_description', title=_('Category'), data_type=str, width=100), SearchColumn('description', title=_('Description'), data_type=str, expand=True, sorted=True), SearchColumn('manufacturer', title=_('Manufacturer'), data_type=str, visible=False), SearchColumn('model', title=_('Model'), data_type=str, visible=False), SearchColumn('location', title=_('Location'), data_type=str, visible=False), SearchColumn('maximum_quantity', title=_('Maximum'), visible=False, format_func=format_data, data_type=Decimal), SearchColumn('minimum_quantity', title=_('Minimum'), format_func=format_data, data_type=Decimal), SearchColumn('stock', title=_('In Stock'), format_func=format_data, data_type=Decimal), SearchColumn('to_receive_quantity', title=_('To Receive'), format_func=format_data, data_type=Decimal), ColoredColumn('difference', title=_('Difference'), color='red', format_func=format_data, data_type=Decimal, data_func=lambda x: x <= Decimal(0))]
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('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): 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=_('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): 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('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('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 [ 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): 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): columns = [ SearchColumn('salesperson_name', title=_('Salesperson'), data_type=str), SearchColumn('code', title=_('Code'), data_type=str, sorted=True, order=Gtk.SortType.DESCENDING), SearchColumn('description', title=_('Description'), data_type=str, expand=True), Column('brand', title=_('Brand'), data_type=str), Column('batch_number', title=_('Batch'), data_type=str, visible=False), SearchColumn('category', title=_('Category'), data_type=str, visible=False), QuantityColumn('quantity', title=_('Qty'), use_having=True), SearchColumn('total', title=_('Total'), data_type=currency, use_having=True) ] return columns
def get_columns(self): columns = [ Column('date', title=_('Date'), data_type=datetime.date, width=150, sorted=True), SearchColumn('description', title=_('Description'), data_type=str, width=150, expand=True), SearchColumn('attendant', title=_('Attendant'), data_type=str, width=100, expand=True) ] if not self.person: columns.insert( 1, SearchColumn('name', title=self.person_name, data_type=str, width=150, expand=True)) return columns
def get_columns(self): return [ SearchColumn('code', title=_('Code'), data_type=str, sorted=True, order=gtk.SORT_DESCENDING), SearchColumn('description', title=_('Product'), data_type=str, expand=True), SearchColumn('category', title=_('Category'), data_type=str, visible=False), SearchColumn('branch_name', title=_('Branch'), data_type=str, width=200), Column('quantity', title=_('Quantity'), data_type=Decimal, format_func=format_quantity, width=100), Column('total', title=_('Total'), data_type=currency, width=80) ]
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'), 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): columns = [ SearchColumn('code', title=_('Code'), data_type=str, sorted=True, sort_func=sort_sellable_code, width=130), SearchColumn('barcode', title=_('Barcode'), data_type=str, visible=True, width=130), SearchColumn('description', title=_('Description'), data_type=str, expand=True) ] if not self.hide_cost_column: columns.append( SearchColumn('cost', _('Cost'), data_type=currency, width=80)) if not self.hide_price_column: columns.append( SearchColumn('price', title=_('Price'), data_type=currency, width=80)) return columns
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, 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 [SearchColumn('name', title=_('Name'), data_type=str, sorted=True, expand=True), SearchColumn('phone_number', _('Phone Number'), str, format_func=format_phone_number, width=180), SearchColumn('freight_percentage', _('Freight (%)'), Decimal, width=150)]
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('code', title=_(u'Code'), data_type=str), SearchColumn('barcode', title=_('Barcode'), data_type=str, sort_func=sort_sellable_code, width=80), SearchColumn('category_description', title=_('Category'), data_type=str, width=120), SearchColumn('description', title=_('Description'), data_type=str, expand=True, sorted=True), SearchColumn('location', title=_('Location'), data_type=str, visible=False), SearchColumn('manufacturer', title=_('Manufacturer'), data_type=str, visible=False), SearchColumn('model', title=_('Model'), data_type=str, visible=False) ] user = api.get_current_user(self.store) if user.profile.check_app_permission('purchase'): columns.append( SearchColumn('cost', title=_(u'Cost'), data_type=currency, visible=True)) if hasattr(self.search_spec, 'price'): columns.append( SearchColumn('price', title=_(u'Price'), data_type=currency, visible=True)) if hasattr(self.search_spec, 'minimum_quantity'): columns.append( SearchColumn('minimum_quantity', title=_(u'Minimum Qty'), data_type=Decimal, visible=False)) if hasattr(self.search_spec, 'stock'): columns.append(QuantityColumn('stock', title=_(u'In Stock'))) return columns
def get_columns(self): return [SearchColumn('name', _('Name'), str, expand=True, sorted=True), 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): 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('date', title=_('Date'), width=80, data_type=datetime.date, justify=gtk.JUSTIFY_RIGHT), SearchColumn('invoice_number', title=_('Invoice'), data_type=int, width=100, sorted=True), SearchColumn('cfop_code', title=_('C.F.O.P.'), data_type=str, width=75), SearchColumn('drawee_name', title=_('Drawee'), data_type=str, expand=True)]
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 [IdentifierColumn('identifier', title=_('Payment #'), sorted=True), SearchColumn('description', title=_('Description'), data_type=str, expand=True), SearchColumn('drawee', title=_('Drawee'), data_type=str, width=200), SearchColumn('due_date', title=_('Due Date'), data_type=datetime.date, width=100), SearchColumn('value', title=_('Value'), data_type=currency, width=145), ]