def robots_txt(request):
content = 'User-agent: *\n' \
'Disallow: /admin/*\n' \
'Sitemap: https://mervinz.me/sitemap.xml\n'
response = HttpResponse()
response.status_code = 200
response.charset = 'utf-8'
response['Content-Type'] = 'text/plain; charset=UTF-8'
response.write(content.encode(encoding='utf-8'))
return response
def create_excel(columns, content, filename):
"""创建导出csv的函数"""
filename = filename + '.csv'
response = HttpResponse(content_type='text/csv')
response['Content-Disposition'] = 'attachment; filename=' + filename
response.charset = 'gbk'
writer = csv.writer(response)
writer.writerow(columns)
for i in content:
writer.writerow([
i['fileno'], i['filename'], i['filepath'], i['owner'],
i['add_time'].strftime('%Y/%m/%d %H:%M:%S')
])
return response
def create_excel(columns, content, file_name):
"""创建导出csv的函数"""
file_name = file_name + '.csv'
response = HttpResponse(content_type='text/csv')
response['Content-Disposition'] = 'attachment; filename=' + file_name
response.charset = 'gbk'
writer = csv.writer(response)
writer.writerow(columns)
for i in content:
writer.writerow([
i['id'], i['zctype__zctype'], i['ipaddress'], i['description'],
i['brand'], i['zcmodel'], i['zcnumber'], i['zcpz'],
i['owner__username'], i['undernet'], i['guartime'], i['comment']
])
return response
def create_excel(columns, content, file_name):
"""创建导出csv的函数"""
file_name = file_name + '.csv'
response = HttpResponse(content_type='text/csv')
response['Content-Disposition'] = 'attachment; filename=' + file_name
response.charset = 'gbk'
writer = csv.writer(response)
writer.writerow(columns)
for i in content:
writer.writerow([
i['id'], i['zctype__zctype'], i['An'], i['Sn'], i['ServerName'],
i['SysName'], i['Use'], i['Location'], i['Cabinet'],
i['BrandModels'], i['PurchaseDate'], i['Head'], i['Ipaddress'],
i['WDate'], i['Undernet'], i['Comment'], i['Modify_time']
])
return response
def export_to_csv(modeladmin, request, queryset):
response = HttpResponse(content_type='text/csv')
response.charset = 'utf-8-sig' if "Windows" in request.headers.get(
'User-Agent') else 'utf-8'
field_list = EXPORT_LIST
response['Content-Disposition'] = 'attachment; filename=export-%s.csv' % (
datetime.now().strftime('%Y-%m-%d-%H-%M-%S'))
writer = csv.writer(response)
writer.writerow(
[queryset.model._meta.get_field(f).verbose_name for f in field_list], )
for obj in queryset:
csv_line_values = []
for field in field_list:
field_obj = queryset.model._meta.get_field(field)
field_value = field_obj.value_from_object(obj)
csv_line_values.append(field_value)
writer.writerow(csv_line_values)
logging.info("%s exported %s recoreds." % (request.user, len(queryset)))
return response
