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