from copyright.models import CopyrightCategoryConfig


class CategoryConfigService(object):
    @staticmethod
    def get_category_by_type(category_type):
        if category_type == 3:
            return list(
                CopyrightCategoryConfig.objects.all().filter(type=category_type).values('id', 'name').order_by('-id'))
        return list(CopyrightCategoryConfig.objects.all().filter(type=category_type).values('id', 'name'))

    @staticmethod
    def get_alias_by_type(category_type):
        return list(CopyrightCategoryConfig.objects.all().filter(type=category_type).values('id', 'alias'))

    @staticmethod
    def get_by_name_type(name, category_type):
        return CopyrightCategoryConfig.objects.get(name=name, type=category_type)

    @staticmethod
    def get_in_name(names, category_type):
        return CopyrightCategoryConfig.objects.filter(name__in=names, type=category_type).values('id', 'name')

    @staticmethod
    def get_by_id(category_id):
        return CopyrightCategoryConfig.objects.get(id=category_id)