Omadbek Qosimov's blog
RispostaFotorecourse.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_class = OrderResource
def get_list_chart_data(self, queryset):
if not queryset:
return {}
data = queryset.values('status').annotate(count=Count('id'))
labels = [entry['status'] for entry in data]
counts = [entry['count'] for entry in data]
return {
"labels": labels,
"datasets": [
{
"data": counts,
"backgroundColor": [
"#79aec8", "#b6d6f2", "#aac3e4", "#8aafd4",
][:len(labels)],
},
],
}
def save_model(self, request, obj, form, change):
if obj.status == 'purchased' and not obj.saler:
obj.saler = request.user
super().save_model(request, obj, form, change)
pip install django-import-export
#csv #admin
197 ·