def download_excel_url(request, group_id):
'''
组装excel表,将文件传给前台返回
'''
try:
data_type = request.GET.get('data_type','')
group_info = Query_task_group.objects.get(id=int(group_id))
biz_cc_id = group_info.biz_cc_id
tasks = Query_task_record.objects.filter(query_task_group__id=int(group_id))
if data_type == 'excel':
xls_data = create_all_data_excel(tasks)
filename = u"{file_name}全量数据_{timestamp}".format(file_name = biz_cc_id,timestamp = int(time.time()))
group_info.delete()
return excel_to_response(xls_data, filename+".xls")
elif data_type == 'txt':
txt_data = create_all_data_txt(tasks)
file = open(txt_data)
filename = u"{file_name}全量数据_{timestamp}".format(file_name = biz_cc_id,timestamp = int(time.time()))
group_info.delete()
return txt_to_response(file.read(), filename+".txt")
except Exception,e:
logger.error('【download_data】 error: %s' %e)