djangoadmin导出csv

from django.contrib import admin
from .models import Order,OrderItem
from django.http import HttpResponse
import datetime
# Register your models here.
import csv
def export_to_csv(modeladmin, request, queryset):
    opts=modeladmin.model._meta
    response=HttpResponse(content_type=‘text/csv‘)
    response[‘Content-Disposition‘]=‘attachment;filename={}.csv‘.format(opts.verbose_name)
    writer=csv.writer(response)
    fields = [field for field in opts.get_fields() if not field.many_to_many and not field.one_to_many]
    writer.writerow([field.verbose_name.encode(‘utf-8‘) for field in fields])
    for obj in queryset:
        data_row=[]
        for field in fields:
            value=getattr(obj,field.name)
            if isinstance(value,datetime.datetime):
                value=value.strftime(‘%d/%m/%Y‘)
            data_row.append(value)
        writer.writerow(data_row)
    return response
export_to_csv.short_description = ‘导出ESV‘

class OrderItemInline(admin.TabularInline):
    model = OrderItem
    raw_id_fields = [‘product‘]



class OrderAdmin(admin.ModelAdmin):
    list_display = [‘id‘, ‘name‘, ‘email‘,
                    ‘address‘, ‘postal_code‘, ‘city‘, ‘paid‘,
                    ‘created‘, ‘updated‘]
    list_filter = [‘paid‘, ‘created‘, ‘updated‘]
    inlines = [OrderItemInline]
    actions = [export_to_csv]

admin.site.register(Order, OrderAdmin)