sharix-guide-webapp-base/SharixAdmin/tables.py

import django_tables2 as tables
from django.contrib.auth import get_user_model

from dbsynce.models import *
from webservice_running.models import *
from django.utils.html import format_html
from django.utils.translation import gettext_lazy as _

class TransactionsWalletTable(tables.Table):
    # id = tables.Column(order_by=True)
    id = tables.Column(verbose_name='#', orderable=False,                                       attrs={"td":{"width":"5%"}})
    wallet = tables.Column(verbose_name=_('Owner'), orderable=False,                            attrs={"td":{"width":"15%"}})
    name_operation = tables.Column(verbose_name=_('Service'), attrs={'th':{'scope':'col'},          "td":{"width":"20%"}}) 
    price = tables.Column(verbose_name=_('Points'), attrs={"class":"row",                           "td":{"width":"10%"}})
    date_operation = tables.Column(verbose_name=_('Registration date'),                              attrs={"td":{"width":"30%"}})
    is_carried_out = tables.BooleanColumn(verbose_name=_('Status'), orderable=False, yesno=_("Successful, not successful"), attrs={"td":{"width":"20%"}})
    
    class Meta:
        #model = TransactionsWallets
        attrs = {"class": "table table-striped"}
        exclude = ("balance_before", 
                   "amount", 
                   "metaservice_id", 
                   "transaction_type",
                   "doc_num",
                   "service_id")
    def render_name_operation(self, value, record):
        return format_html("<a href='{}'>{}</a>", record.get_absolute_url(), value)
        
class PartnersTable(tables.Table):
    id = tables.Column(verbose_name=_('ID'), attrs={"td":{"width":"5%"}})
    legal_name = tables.Column(verbose_name=_('Legal entity'), attrs={'th':{'scope':'col'}, "td":{"width":"20%"}})
    repr_id = tables.Column(accessor='repr_id.full_name', order_by=('repr_id.first_name', 'repr_id.last_name'), verbose_name=_('Responsible'), attrs={"td":{"width":"15%"}})
   
    status = tables.Column(verbose_name=_('Status'), attrs={'th':{'scope':'col'}, "td":{"width":"20%"}}) 
    check = tables.BooleanColumn(verbose_name='', attrs={'th':{'scope':'col'}, "td":{"width":"20%"}})
    # paginate_by = 10
    class Meta:
        model = Company
        attrs = {"class": "table table-layout-fixed"}
        exclude = ('inn','kpp','ogrn', 'bank_name', 
                   'bik', 'ks', 'rs', 
                   'address', 'requirements', 
                   'id_metaservice', 'is_global', 'is_visible', 'ticket_status')

    def render_check(self, value, record):
        if record.status == 'active':
            return format_html('<input class="form-check-input status-toggle" checked type="checkbox" id="flexCheckDefault" data-partners-id="{}">', record.id)
        else:
            return format_html('<input class="form-check-input status-toggle" type="checkbox" id="flexCheckDefault" data-partners-id="{}">', record.id)

class TaskTable(tables.Table):
    id = tables.Column(verbose_name=_('ID'), attrs={"td":{"width":"5%"}})
    legal_name = tables.Column(verbose_name=_('Legal entity'), attrs={'th':{'scope':'col'}, "td":{"width":"20%"}})
    repr_id = tables.Column(accessor='repr_id.full_name', order_by=('repr_id.first_name', 'repr_id.last_name'), verbose_name=_('Responsible'), attrs={"td":{"width":"15%"}})
   
    status = tables.Column(verbose_name=_('Status'), attrs={'th':{'scope':'col'}, "td":{"width":"20%"}}) 
    check = tables.BooleanColumn(verbose_name='', attrs={'th':{'scope':'col'}, "td":{"width":"20%"}})
    # paginate_by = 10
    class Meta:
        model = Company
        attrs = {"class": "table table-layout-fixed"}
        exclude = ('inn','kpp','ogrn', 'bank_name', 
                   'bik', 'ks', 'rs', 
                   'address', 'requirements', 
                   'id_metaservice', 'is_global', 'is_visible', 'ticket_status')

    def render_check(self, value, record):
        if record.status == 'active':
            return format_html('<input class="form-check-input status-toggle" checked type="checkbox" id="flexCheckDefault" data-partners-id="{}">', record.id)
        else:
            return format_html('<input class="form-check-input status-toggle" type="checkbox" id="flexCheckDefault" data-partners-id="{}">', record.id)

class ResourceTable(tables.Table):

    id = tables.Column(verbose_name=_('ID'), attrs={"td":{"width":"5%"}})
    #В user_id ссылка LinkColumn на страницу Аси "Информация о партнере" страница partner_information_form
    user_id = tables.Column(accessor='user_id.full_name', order_by=('user_id.first_name', 'user_id.last_name'), verbose_name=_('Responsible'), attrs={"td":{"width":"15%"}})
    status = tables.Column(verbose_name=_('Status'), attrs={'th':{'scope':'col'}, "td":{"width":"20%"}}) 
    check = tables.BooleanColumn(verbose_name='', attrs={'th':{'scope':'col'}, "td":{"width":"20%"}})
    # paginate_by = 10
    class Meta:
        model = Resource
        attrs = {"class": "table table-layout-fixed"}
        exclude = ('type_id','requirements','ticket_status', 'id_metaservice', 
                   'is_global', 'is_visible')

    def render_check(self, value, record):
        if record.status == 'active':
            return format_html('<input class="form-check-input status-toggle" checked type="checkbox" id="flexCheckDefault" data-resource-id="{}">', record.id)
        else:
            return format_html('<input class="form-check-input status-toggle" type="checkbox" id="flexCheckDefault" data-resource-id="{}">', record.id)

class ProviderTable(tables.Table):

    id = tables.Column(verbose_name=_('ID'), attrs={"td":{"width":"5%"}})
    user_id = tables.Column(accessor='user_id.full_name', order_by=('user_id.first_name', 'user_id.last_name'), verbose_name=_('Full Name'), attrs={"td":{"width":"15%"}})

    status = tables.Column(verbose_name=_('Status'), attrs={'th':{'scope':'col'}, "td":{"width":"20%"}}) 
    check = tables.BooleanColumn(verbose_name='', attrs={'th':{'scope':'col'}, "td":{"width":"20%"}})
    paginate_by = 10
    class Meta:
        model = Provider
        attrs = {"class": "table table-layout-fixed"}
        exclude = ('type','company_id','id_metaservice', 'requirements', 
                   'ticket_status', 'location_type', 'default_location', 
                   'is_global', 'is_visible')

    def render_check(self, value, record):
        if record.status == 'active':
            return format_html('<input class="form-check-input status-toggle" checked type="checkbox" id="flexCheckDefault" data-provider-id="{}">', record.id)
        else:
            return format_html('<input class="form-check-input status-toggle" type="checkbox" id="flexCheckDefault" data-provider-id="{}">', record.id)

class ServiceTariffTable(tables.Table):

    id = tables.Column(verbose_name=_('ID'), attrs={"td":{"width":"5%"}})
    servicetype_id = tables.LinkColumn('service_tariff/edit/', verbose_name=_('Name of the tariff'), text = lambda record: record.servicetype_id.caption,
        args=[tables.A('pk')], attrs={'th':{'scope':'col'}, "td":{"width":"20%"}})
    ticket_status = tables.Column(verbose_name=_('Name of the service scheme'), attrs={'th':{'scope':'col'}, "td":{"width":"20%"}}) 
    check = tables.BooleanColumn(verbose_name=_('Activity'), orderable=False, attrs={'th':{'scope':'col'}, "td":{"width":"20%"}})


    class Meta:
        model = Service
        attrs = {"class": "table table-layout-fixed"}
        exclude = ('resource_id','id_provider','price_alg',
                   'price_min','price_amount','id_metaservice', 
                   'requirements', 'service_status', 'price_km',
                   'is_global', 'is_visible','status')

    def render_check(self, value, record):
        if record.status == 'active':
            return format_html('<input class="form-check-input status-toggle" disabled  checked type="checkbox"')
        else:
            return format_html('<input class="form-check-input status-toggle" disabled  type="checkbox"')

class ServiceTypeTable(tables.Table):

    id = tables.Column( attrs={"td":{"width":"50px"}})
    codename = tables.LinkColumn('service_type/edit/', verbose_name='Услуга', orderable=False, text = lambda record: record.codename,
        args=[tables.A('pk')], attrs= {"a": {"style": "pointer-events: none;"}, 'th':{'scope':'col'}, "td":{"class":"name_col"}})
    description = tables.LinkColumn('service_type/edit/', orderable=False, verbose_name='Описание', text = lambda record: record.description,
        args=[tables.A('pk')], attrs= {"a": {"style": "pointer-events: none;"}, 'th':{'scope':'col'}, "td":{"class":"description_col"}})
    edit = tables.LinkColumn('service_type/edit/', verbose_name='', orderable=False, text = "E",
        args=[tables.A('pk')], attrs={'th':{'scope':'col'}, "td":{"class":"edit_col"}})
    delete = tables.LinkColumn('service_type/delete/', verbose_name='', orderable=False, text = "D",
        args=[tables.A('pk')], attrs={'th':{'scope':'col'}, "td":{"class":"delete_col"}})
    
    
    class Meta:
        model = ServiceType
        attrs = {"class": "table table-layout-fixed text-start"}
        exclude = ('requirements',
                   'price_type','status','ticket_status', 
                   'id_metaservice', 'link_agreement',
                   'is_global', 'is_visible', 'caption')

    # def render_delete(self, value, record):
    #     return format_html('<a href="/service_type/delete" class="btn btn-outline-danger">_(Delete)</a>')
        
    # def render_name_operation(self, value, record):
    #     return format_html("<a href='{}'>{}</a>", record.get_absolute_url(), value)
   
class CommentsTable(tables.Table):

    id = tables.Column( attrs={"td":{"width":"50px"}})
    user_id = tables.Column(accessor='user_id.full_name', order_by=('user_id.first_name', 'user_id.last_name'), verbose_name=_('User'), attrs={"td":{"width":"15%"}})

    check = tables.BooleanColumn(verbose_name='', attrs={'th':{'scope':'col'}, "td":{"width":"5%"}})
    delete = tables.LinkColumn('comments/delete/', verbose_name='', orderable=False, text = "D",
        args=[tables.A('pk')], attrs={'th':{'scope':'col'}, "td":{"class":"delete_col"}})
    status = tables.Column(verbose_name=_('Status'), attrs={'th':{'scope':'col'}, "td":{"width":"20%"}}) 
    
    class Meta:
        model = Comments
        attrs = {"class": "table table-layout-fixed text-start"}
        exclude = ('ticket_status', 'id_metaservice',
                   'is_global', 'is_visible')
        
    def render_check(self, value, record):
        if record.status == 'active':
            return format_html('<input class="form-check-input status-toggle" checked type="checkbox" id="flexCheckDefault" data-comments-id="{}">', record.id)
        else:
            return format_html('<input class="form-check-input status-toggle" type="checkbox" id="flexCheckDefault" data-comments-id="{}">', record.id)

class TechSupTable(tables.Table):

    id = tables.Column( attrs={"td":{"width":"50px"}})
    user_id = tables.Column(accessor='user_id.full_name', order_by=('user_id.first_name', 'user_id.last_name'), verbose_name=_('User'), attrs={"td":{"width":"15%"}})
    description = tables.LinkColumn('tech_support/edit/', orderable=False, verbose_name='Описание', text = lambda record: record.description,
        args=[tables.A('pk')], attrs= {"a": {"style": "pointer-events: none;"}, 'th':{'scope':'col'}, "td":{"class":"description_col"}})
    edit = tables.LinkColumn('tech_support/edit/', verbose_name='', orderable=False, text = "E",
        args=[tables.A('pk')], attrs={'th':{'scope':'col'}, "td":{"class":"edit_col"}})
    delete = tables.LinkColumn('tech_support/delete/', verbose_name='', orderable=False, text = "D",
        args=[tables.A('pk')], attrs={'th':{'scope':'col'}, "td":{"class":"delete_col"}})
    status = tables.Column(verbose_name=_('Status'), attrs={'th':{'scope':'col'}, "td":{"width":"20%"}}) 
    
    class Meta:
        model = Comments
        attrs = {"class": "table table-layout-fixed text-start"}
        exclude = ('ticket_status', 'id_metaservice',
                   'is_global', 'is_visible')

class ServiceTable(tables.Table):

    id = tables.Column(attrs={"td":{"width":"5%"}})
    servicetype_id = tables.Column(verbose_name=_('Description of the service'), accessor = 'servicetype_id.caption',
        attrs={'th':{'scope':'col'}, "td":{"width":"20%"}})
    
    id_provider = tables.Column(verbose_name=_('Организатор'))
    name_service = tables.Column(verbose_name=_('Экскурсия'))
    rating = tables.Column(verbose_name=_('Рейтинг'))
    price = tables.Column(verbose_name=_('Цена'))

    class Meta:
        model = Service
        attrs = {"class": "table table-layout-fixed"}
        exclude = ('resource_id','servicetype_id', 'requirements',
                   'id_metaservice', 'price_alg','price_km', 'price_min', 'price_amount', 'service_status', 'ticket_status',
                    'is_global', 'is_visible', 'place_start', 'place_end', 'movement_way', 'discription', 'status')

    def render_check(self, value, record):
        if record.status == 'active':
            return format_html('<input class="form-check-input status-toggle" checked type="checkbox" id="flexCheckDefault" data-service-id="{}">', record.id)
        else:
            return format_html('<input class="form-check-input status-toggle" type="checkbox" id="flexCheckDefault" data-service-id="{}">', record.id)     

class UserInfoTable(tables.Table):

    id = tables.Column(verbose_name=_('ID'), attrs={"td":{"width":"5%"}})

    delete = tables.LinkColumn('user_information/delete/', verbose_name='', orderable=False, text = "D",
        args=[tables.A('pk')], attrs={'th':{'scope':'col'}, "td":{"class":"delete_col"}})
    
    class Meta:
        model = get_user_model()
        attrs = {"class": "table table-layout-fixed"}
        exclude = ('password', 'phone_number', "avatar",
                   'last_login','is_staff', 'is_superuser',
                   'date_joined')