问题描述
在我的应用程序中,我使用搜索和显示输出的搜索功能。包括搜索 fromdate和todate
, code>等。
In my application i am using a search function which search and display the output.I include search for fromdate and todate
,Keyword search
etc.
我要导出搜索结果到 .csv
写了一个名为 csv_export
的函数,并导出了所有的报告.csv.I想知道如何在.csv文件中导出搜索的项目。
I want to export the searched result in a .csv
file.Currently i had written a function called csv_export
and exporting all the report in .csv.I want to know how to export the searched item in a .csv file.
forms.py搜寻
forms.py for search
class SearchFilterForm(Form):
location = forms.ChoiceField(widget=forms.Select(), choices='',required=False)
type = forms.ChoiceField(widget=forms.Select(), choices='',required=False)
fromdate = forms.CharField(widget=forms.TextInput(attrs={'placeholder': 'dd/mm/yyyy','class':'datefield','readonly':'readonly'}))
todate = forms.CharField(widget=forms.TextInput(attrs={'placeholder': 'dd/mm/yyyy','class':'datefield','readonly':'readonly'}))
search_keyword = forms.CharField(widget=forms.TextInput(attrs={'placeholder': 'Keyword Search','class':'keyword-search'}))
views.py for search
views.py for search
def search(request):
"""Search reports using filters
"""
user = request.user
report_list = []
searchfilter = SearchFilterForm(user)
reports = Report.objects.filter(user=user)
if request.method == 'POST':
if 'search' in request.POST:
search_keyword = request.POST.get('search_keyword') #reports filter by keywords
reports = reports.filter(Q(incident_description__icontains=search_keyword)|Q(incident_number__icontains=search_keyword))
elif 'filter' in request.POST:
searchfilter = SearchFilterForm(user,request.POST)
loc_id = request.POST.get('location')
type_id = request.POST.get('type')
start_date = request.POST.get('fromdate')
end_date = request.POST.get('todate')
reportlist = []
""""""""""" #some stuff for search come here
if start_date or end_date:
if start_date and not end_date:
reports = reports.filter(created_date_time__gte=start_date)
elif not start_date and end_date:
reports = reports.filter(created_date_time__lte=end_date)
elif start_date and end_date:
reports = reports.filter(created_date_time__gt=start_date,created_date_time__lt=end_date)
for report in reports:
"""""" report iteration goes here
report_list.append(items)
return render(request, 'incident/search.html',
{'SearchKeywordForm':searchform,})
除了搜索按钮之外,还有一个保存电子表格
是他们在同一个搜索页面上,点击搜索按钮搜索的项目显示,而点击保存电子表格
按钮显示的项目导出为 .csv
档案。
Apart from search button a button called save-spreadsheet
is their on the same search page,on clicking search button the searched items are come to display and while clicking save-spreadsheet
button the displayed items are exported to .csv
file.
需要协助。
感谢
推荐答案
Check the django documentation about outputting CSV.
您可以显示搜索结果列表,如:
You can display a list of search results like:
<ul>
<li><form method="GET" action="/reports/1/csv/"><input type="submit" value="Get Report 1 csv" /></form></li>
<li><form method="GET" action="/reports/30/csv/"><input type="submit" value="Get Report 30 csv" /></from></li>
...
</ul>
并创建一个视图,输出给定报告ID的CSV:
And create a view that outputs a CSV for given report id:
urls.py
url(r'^reports/(?P<report_id>\d+)/csv/$', 'reports.views.csv_report')
views.py
def csv_report(request, report_id):
report = Reports.objects.get(pk=report_id)
response = HttpResponse(content_type='text/csv')
response['Content-Disposition'] = 'attachment; filename="report.csv"'
response.write(report.to_csv()) # TODO to_csv
return response
这篇关于使用django以.csv格式搜索和导出数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!