Omadbek Qosimov's blog

recourse.py from import_export import resources, fields from .models import Order from import_export.widgets import ForeignKeyWidget,ManyToManyWidget from apps.depreciation.models import DepreciationItem from apps.profile.models import User class OrderResource(resources.ModelResource): customer = fields.Field( column_name='Customer Name', attribute='user', widget=ForeignKeyWidget(User, 'id')) saler = fields.Field( column_name='Saler Name', attribute='user', widget=ForeignKeyWidget(User, 'id')) depreciation = fields.Field(column_name="Depreciation") category = fields.Field(column_name='Category name') class Meta: model = Order fields = ('id', 'status', 'customer','price','category','depreciation','created_at') def dehydrate_category(self, order): return order.product.depreciation_cat.title def dehydrate_depreciation(self, order): deprecation = DepreciationItem.objects.get(office = order.product.office,category = order.product.depreciation_cat) return f"year:{deprecation.year}, office: {deprecation.office.title}, percantage: {deprecation.percentage}" def dehydrate_customer(self, order): if order.user: return f"{order.user.first_name} {order.user.last_name}" return order.user.username def dehydrate_saler(self, order): if order.saler: return order.saler.get_full_name() if order.saler.get_full_name() else order.saler.username return "" admin.py @admin.register(Order) class OrderAdmin(AdminChartMixin, ImportExportModelAdmin): list_display = ('product', 'user', 'status', 'created_at', 'updated_at') list_filter = ('status', 'created_at', 'updated_at') list_editable = ('status', ) list_chart_type = "pie" list_chart_data = {} list_chart_options = {"aspectRatio": 6} list_chart_config = None readonly_fields = ('saler',) resource_cl