def export_voip_report(self, request): """Export a CSV file of VoIP call records **Important variable**: * request.session['admin_voipcall_record_qs'] - stores voipcall query set **Exported fields**: [user, callid, callerid, phone_number, starting_date, duration, disposition, used_gateway] """ # get the response object, this can be used as a stream. response = HttpResponse(mimetype='text/csv') # force download. response['Content-Disposition'] = 'attachment;filename=export.csv' writer = csv.writer(response) # super(VoIPCall_ReportAdmin, self).queryset(request) qs = request.session['admin_voipcall_record_qs'] writer.writerow(['user', 'callid', 'callerid', 'phone_number', 'starting_date', 'duration', 'disposition', 'gateway']) for i in qs: writer.writerow([i.user, i.callid, i.callerid, i.phone_number, i.starting_date, i.duration, get_disposition_name(i.disposition), i.used_gateway, ]) return response
def export_voipcall_report(request): """Export CSV file of VoIP call record **Important variable**: * ``request.session['voipcall_record_qs']`` - stores voipcall query set **Exported fields**: [user, callid, callerid, phone_number, starting_date, duration, disposition, used_gateway] """ # get the response object, this can be used as a stream. response = HttpResponse(mimetype='text/csv') # force download. response['Content-Disposition'] = 'attachment;filename=export.csv' # the csv writer writer = csv.writer(response) # super(VoIPCall_ReportAdmin, self).queryset(request) qs = request.session['voipcall_record_qs'] writer.writerow([ 'user', 'callid', 'callerid', 'phone_number', 'starting_date', 'duration', 'billsec', 'disposition', 'hangup_cause', 'hangup_cause_q850', 'used_gateway' ]) for i in qs: gateway_used = i.used_gateway.name if i.used_gateway else '' writer.writerow([ i.user, i.callid, i.callerid, i.phone_number, i.starting_date, i.duration, i.billsec, get_disposition_name(i.disposition), i.hangup_cause, i.hangup_cause_q850, gateway_used, ]) return response
def export_voipcall_report(request): """Export CSV file of VoIP call record **Important variable**: * ``request.session['voipcall_record_qs']`` - stores voipcall query set **Exported fields**: [user, callid, callerid, phone_number, starting_date, duration, disposition, used_gateway] """ # get the response object, this can be used as a stream. response = HttpResponse(mimetype='text/csv') # force download. response['Content-Disposition'] = 'attachment;filename=export.csv' # the csv writer writer = csv.writer(response) # super(VoIPCall_ReportAdmin, self).queryset(request) qs = request.session['voipcall_record_qs'] writer.writerow(['user', 'callid', 'callerid', 'phone_number', 'starting_date', 'duration', 'billsec', 'disposition', 'hangup_cause', 'hangup_cause_q850', 'used_gateway']) for i in qs: gateway_used = i.used_gateway.name if i.used_gateway else '' writer.writerow([i.user, i.callid, i.callerid, i.phone_number, i.starting_date, i.duration, i.billsec, get_disposition_name(i.disposition), i.hangup_cause, i.hangup_cause_q850, gateway_used, ]) return response