def cdr_export_to_csv(request): """ **Logic Description**: Retrieve calls records from Postgresql according to search parameters, then export the result into CSV/XLS/JSON file """ format_type = request.GET['format'] # get the response object, this can be used as a stream response = HttpResponse(content_type='text/%s' % format_type) # force download response[ 'Content-Disposition'] = 'attachment;filename=export.%s' % format_type # get query_var from request.session start_date = request.session.get('session_start_date') end_date = request.session.get('session_end_date') start_date = ceil_strdate(start_date, 'start', True) end_date = ceil_strdate(end_date, 'end', True) if request.session.get('session_export_kwargs'): kwargs = request.session.get('session_export_kwargs') if start_date: kwargs['starting_date__gte'] = start_date if end_date: kwargs['starting_date__lte'] = end_date cdrs = CDR.objects.filter(**kwargs) headers = ('Call-date', 'CLID', 'Destination', 'Duration', 'Bill sec', 'Hangup cause', 'AccountCode', 'Direction') list_val = [] for cdr in cdrs: starting_date = str(cdr.starting_date) list_val.append(( starting_date, cdr.caller_id_number + '-' + cdr.caller_id_name, cdr.destination_number, cdr.duration, cdr.billsec, get_hangupcause_name(cdr.hangup_cause_id), cdr.accountcode, cdr.direction, )) data = tablib.Dataset(*list_val, headers=headers) if format_type == Export_choice.XLS: response.write(data.xls) elif format_type == Export_choice.CSV: response.write(data.csv) elif format_type == Export_choice.JSON: response.write(data.json) return response
def cdr_export_to_csv(request): """ **Logic Description**: Retrieve calls records from Postgresql according to search parameters, then export the result into CSV/XLS/JSON file """ format_type = request.GET['format'] # get the response object, this can be used as a stream response = HttpResponse(content_type='text/%s' % format_type) # force download response['Content-Disposition'] = 'attachment;filename=export.%s' % format_type # get query_var from request.session start_date = request.session.get('session_start_date') end_date = request.session.get('session_end_date') start_date = ceil_strdate(start_date, 'start', True) end_date = ceil_strdate(end_date, 'end', True) if request.session.get('session_export_kwargs'): kwargs = request.session.get('session_export_kwargs') if start_date: kwargs['starting_date__gte'] = start_date if end_date: kwargs['starting_date__lte'] = end_date cdrs = CDR.objects.filter(**kwargs) headers = ('Call-date', 'CLID', 'Destination', 'Duration', 'Bill sec', 'Hangup cause', 'AccountCode', 'Direction') list_val = [] for cdr in cdrs: starting_date = str(cdr.starting_date) list_val.append(( starting_date, cdr.caller_id_number + '-' + cdr.caller_id_name, cdr.destination_number, cdr.duration, cdr.billsec, get_hangupcause_name(cdr.hangup_cause_id), cdr.accountcode, cdr.direction, )) data = tablib.Dataset(*list_val, headers=headers) if format_type == Export_choice.XLS: response.write(data.xls) elif format_type == Export_choice.CSV: response.write(data.csv) elif format_type == Export_choice.JSON: response.write(data.json) return response
def subscriber_report(self, request): """ Get subscriber report **Attributes**: * ``form`` - SubscriberReportForm * ``template`` - admin/dialer_campaign/subscriber/subscriber_report.html """ opts = Subscriber._meta tday = datetime.today() form = SubscriberReportForm(request.POST or None, initial={"from_date": tday.strftime("%Y-%m-%d"), "to_date": tday.strftime("%Y-%m-%d")}) total_subscriber = 0 total_pending = 0 total_pause = 0 total_abort = 0 total_fail = 0 total_sent = 0 total_in_process = 0 total_not_auth = 0 total_completed = 0 if form.is_valid(): start_date = '' end_date = '' from_date = getvar(request, 'from_date') to_date = getvar(request, 'to_date') start_date = ceil_strdate(str(from_date), 'start') end_date = ceil_strdate(str(to_date), 'end') campaign_id = getvar(request, 'campaign_id') kwargs = {} if start_date and end_date: kwargs['updated_date__range'] = (start_date, end_date) if start_date and end_date == '': kwargs['updated_date__gte'] = start_date if start_date == '' and end_date: kwargs['updated_date__lte'] = end_date if campaign_id and campaign_id != '0': kwargs['campaign_id'] = campaign_id select_data = {"updated_date": "SUBSTR(CAST(updated_date as CHAR(30)),1,10)"} subscriber = Subscriber.objects.filter(**kwargs).extra(select=select_data)\ .values('updated_date', 'status')\ .annotate(Count('updated_date'))\ .order_by('updated_date') for i in subscriber: total_subscriber += i['updated_date__count'] if i['status'] == SUBSCRIBER_STATUS.PENDING: total_pending += i['updated_date__count'] elif i['status'] == SUBSCRIBER_STATUS.PAUSE: total_pause += i['updated_date__count'] elif i['status'] == SUBSCRIBER_STATUS.ABORT: total_abort += i['updated_date__count'] elif i['status'] == SUBSCRIBER_STATUS.FAIL: total_fail += i['updated_date__count'] elif i['status'] == SUBSCRIBER_STATUS.SENT: total_sent += i['updated_date__count'] elif i['status'] == SUBSCRIBER_STATUS.IN_PROCESS: total_in_process += i['updated_date__count'] elif i['status'] == SUBSCRIBER_STATUS.NOT_AUTHORIZED: total_not_auth += i['updated_date__count'] else: # status COMPLETED total_completed += i['updated_date__count'] ctx = RequestContext(request, { 'form': form, 'opts': opts, 'total_subscriber': total_subscriber, 'total_pending': total_pending, 'total_pause': total_pause, 'total_abort': total_abort, 'total_fail': total_fail, 'total_sent': total_sent, 'total_in_process': total_in_process, 'total_not_auth': total_not_auth, 'total_completed': total_completed, 'SUBSCRIBER_STATUS_NAME': SUBSCRIBER_STATUS_NAME, 'model_name': opts.object_name.lower(), 'app_label': _('Dialer Campaign'), 'title': _('subscriber report'), }) return render_to_response('admin/dialer_campaign/subscriber/subscriber_report.html', context_instance=ctx)
def subscriber_list(request): """ Subscriber list for the logged in user **Attributes**: * ``template`` - dialer_campaign/subscriber/list.html * ``form`` - SubscriberSearchForm **Logic Description**: * List all subscribers belonging to the logged in user & their campaign """ sort_col_field_list = ['contact', 'updated_date', 'count_attempt', 'completion_count_attempt', 'status', 'disposition', 'collected_data', 'agent'] pag_vars = get_pagination_vars(request, sort_col_field_list, default_sort_field='id') form = SubscriberSearchForm(request.user, request.POST or None) campaign_id = '' agent_id = '' status = 'all' start_date = end_date = None post_var_with_page = 0 if form.is_valid(): post_var_with_page = 1 field_list = ['start_date', 'end_date', 'status', 'campaign_id', 'agent_id'] unset_session_var(request, field_list) campaign_id = getvar(request, 'campaign_id', setsession=True) agent_id = getvar(request, 'agent_id', setsession=True) from_date = getvar(request, 'from_date') to_date = getvar(request, 'to_date') start_date = ceil_strdate(str(from_date), 'start') end_date = ceil_strdate(str(to_date), 'end') converted_start_date = start_date.strftime('%Y-%m-%d') converted_end_date = end_date.strftime('%Y-%m-%d') request.session['session_start_date'] = converted_start_date request.session['session_end_date'] = converted_end_date status = getvar(request, 'status', setsession=True) if request.GET.get('page') or request.GET.get('sort_by'): post_var_with_page = 1 start_date = request.session.get('session_start_date') end_date = request.session.get('session_end_date') start_date = ceil_strdate(str(start_date), 'start') end_date = ceil_strdate(str(end_date), 'end') campaign_id = request.session.get('session_campaign_id') agent_id = request.session.get('session_agent_id') status = request.session.get('session_status') form = SubscriberSearchForm( request.user, initial={'from_date': start_date.strftime('%Y-%m-%d'), 'to_date': end_date.strftime('%Y-%m-%d'), 'campaign_id': campaign_id, 'agent_id': agent_id, 'status': status}) if post_var_with_page == 0: # default tday = datetime.utcnow().replace(tzinfo=utc) from_date = tday.strftime('%Y-%m-%d') to_date = tday.strftime('%Y-%m-%d') start_date = datetime(tday.year, tday.month, tday.day, 0, 0, 0, 0).replace(tzinfo=utc) end_date = datetime(tday.year, tday.month, tday.day, 23, 59, 59, 999999).replace(tzinfo=utc) form = SubscriberSearchForm(request.user, initial={'from_date': from_date, 'to_date': to_date}) # unset session var request.session['session_start_date'] = start_date request.session['session_end_date'] = end_date request.session['session_status'] = '' request.session['session_campaign_id'] = '' request.session['session_agent_id'] = '' kwargs = {} # updated_date might be replaced with last_attempt if start_date and end_date: kwargs['updated_date__range'] = (start_date, end_date) if start_date and end_date == '': kwargs['updated_date__gte'] = start_date if start_date == '' and end_date: kwargs['updated_date__lte'] = end_date if campaign_id and campaign_id != '0': kwargs['campaign_id'] = campaign_id # if agent_id and agent_id != '0': # kwargs['agent_id'] = agent_id if status and status != 'all': kwargs['status'] = status subscriber_list = [] all_subscriber_list = [] subscriber_count = 0 if request.user.is_superuser: subscriber_list = Subscriber.objects.all() else: subscriber_list = Subscriber.objects.filter(campaign__user=request.user) if kwargs: subscriber_list = subscriber_list.filter(**kwargs) request.session['subscriber_list_kwargs'] = kwargs all_subscriber_list = subscriber_list.order_by(pag_vars['sort_order']) subscriber_list = all_subscriber_list[pag_vars['start_page']:pag_vars['end_page']] subscriber_count = all_subscriber_list.count() data = { 'subscriber_list': subscriber_list, 'all_subscriber_list': all_subscriber_list, 'total_subscribers': subscriber_count, 'SUBSCRIBER_COLUMN_NAME': SUBSCRIBER_COLUMN_NAME, 'col_name_with_order': pag_vars['col_name_with_order'], 'msg': request.session.get('msg'), 'error_msg': request.session.get('error_msg'), 'form': form, } request.session['msg'] = '' request.session['error_msg'] = '' return render_to_response('dialer_campaign/subscriber/list.html', data, context_instance=RequestContext(request))
def subscriber_list(request): """ Subscriber list for the logged in user **Attributes**: * ``template`` - dialer_campaign/subscriber/list.html * ``form`` - SubscriberSearchForm **Logic Description**: * List all subscribers belonging to the logged in user & their campaign """ sort_col_field_list = [ 'contact', 'updated_date', 'count_attempt', 'completion_count_attempt', 'status', 'disposition', 'collected_data', 'agent' ] pag_vars = get_pagination_vars(request, sort_col_field_list, default_sort_field='id') form = SubscriberSearchForm(request.user, request.POST or None) campaign_id = '' agent_id = '' status = 'all' start_date = end_date = None post_var_with_page = 0 if form.is_valid(): post_var_with_page = 1 field_list = [ 'start_date', 'end_date', 'status', 'campaign_id', 'agent_id' ] unset_session_var(request, field_list) campaign_id = getvar(request, 'campaign_id', setsession=True) agent_id = getvar(request, 'agent_id', setsession=True) from_date = getvar(request, 'from_date') to_date = getvar(request, 'to_date') start_date = ceil_strdate(str(from_date), 'start') end_date = ceil_strdate(str(to_date), 'end') converted_start_date = start_date.strftime('%Y-%m-%d') converted_end_date = end_date.strftime('%Y-%m-%d') request.session['session_start_date'] = converted_start_date request.session['session_end_date'] = converted_end_date status = getvar(request, 'status', setsession=True) if request.GET.get('page') or request.GET.get('sort_by'): post_var_with_page = 1 start_date = request.session.get('session_start_date') end_date = request.session.get('session_end_date') start_date = ceil_strdate(str(start_date), 'start') end_date = ceil_strdate(str(end_date), 'end') campaign_id = request.session.get('session_campaign_id') agent_id = request.session.get('session_agent_id') status = request.session.get('session_status') form = SubscriberSearchForm(request.user, initial={ 'from_date': start_date.strftime('%Y-%m-%d'), 'to_date': end_date.strftime('%Y-%m-%d'), 'campaign_id': campaign_id, 'agent_id': agent_id, 'status': status }) if post_var_with_page == 0: # default tday = datetime.utcnow().replace(tzinfo=utc) from_date = tday.strftime('%Y-%m-%d') to_date = tday.strftime('%Y-%m-%d') start_date = datetime(tday.year, tday.month, tday.day, 0, 0, 0, 0).replace(tzinfo=utc) end_date = datetime(tday.year, tday.month, tday.day, 23, 59, 59, 999999).replace(tzinfo=utc) form = SubscriberSearchForm(request.user, initial={ 'from_date': from_date, 'to_date': to_date }) # unset session var request.session['session_start_date'] = start_date request.session['session_end_date'] = end_date request.session['session_status'] = '' request.session['session_campaign_id'] = '' request.session['session_agent_id'] = '' kwargs = {} # updated_date might be replaced with last_attempt if start_date and end_date: kwargs['updated_date__range'] = (start_date, end_date) if start_date and end_date == '': kwargs['updated_date__gte'] = start_date if start_date == '' and end_date: kwargs['updated_date__lte'] = end_date if campaign_id and campaign_id != '0': kwargs['campaign_id'] = campaign_id # if agent_id and agent_id != '0': # kwargs['agent_id'] = agent_id if status and status != 'all': kwargs['status'] = status subscriber_list = [] all_subscriber_list = [] subscriber_count = 0 if request.user.is_superuser: subscriber_list = Subscriber.objects.all() else: subscriber_list = Subscriber.objects.filter( campaign__user=request.user) if kwargs: subscriber_list = subscriber_list.filter(**kwargs) request.session['subscriber_list_kwargs'] = kwargs all_subscriber_list = subscriber_list.order_by(pag_vars['sort_order']) subscriber_list = all_subscriber_list[ pag_vars['start_page']:pag_vars['end_page']] subscriber_count = all_subscriber_list.count() data = { 'subscriber_list': subscriber_list, 'all_subscriber_list': all_subscriber_list, 'total_subscribers': subscriber_count, 'SUBSCRIBER_COLUMN_NAME': SUBSCRIBER_COLUMN_NAME, 'col_name_with_order': pag_vars['col_name_with_order'], 'msg': request.session.get('msg'), 'error_msg': request.session.get('error_msg'), 'form': form, } request.session['msg'] = '' request.session['error_msg'] = '' return render_to_response('dialer_campaign/subscriber/list.html', data, context_instance=RequestContext(request))
def subscriber_report(self, request): """ Get subscriber report **Attributes**: * ``form`` - SubscriberReportForm * ``template`` - admin/dialer_campaign/subscriber/subscriber_report.html """ opts = Subscriber._meta tday = datetime.today() form = SubscriberReportForm( request.POST or None, initial={"from_date": tday.strftime("%Y-%m-%d"), "to_date": tday.strftime("%Y-%m-%d")} ) total_subscriber = 0 total_pending = 0 total_pause = 0 total_abort = 0 total_fail = 0 total_sent = 0 total_in_process = 0 total_not_auth = 0 total_completed = 0 if form.is_valid(): start_date = "" end_date = "" from_date = getvar(request, "from_date") to_date = getvar(request, "to_date") start_date = ceil_strdate(str(from_date), "start") end_date = ceil_strdate(str(to_date), "end") campaign_id = getvar(request, "campaign_id") kwargs = {} if start_date and end_date: kwargs["updated_date__range"] = (start_date, end_date) if start_date and end_date == "": kwargs["updated_date__gte"] = start_date if start_date == "" and end_date: kwargs["updated_date__lte"] = end_date if campaign_id and campaign_id != "0": kwargs["campaign_id"] = campaign_id select_data = {"updated_date": "SUBSTR(CAST(updated_date as CHAR(30)),1,10)"} subscriber = ( Subscriber.objects.filter(**kwargs) .extra(select=select_data) .values("updated_date", "status") .annotate(Count("updated_date")) .order_by("updated_date") ) for i in subscriber: total_subscriber += i["updated_date__count"] if i["status"] == SUBSCRIBER_STATUS.PENDING: total_pending += i["updated_date__count"] elif i["status"] == SUBSCRIBER_STATUS.PAUSE: total_pause += i["updated_date__count"] elif i["status"] == SUBSCRIBER_STATUS.ABORT: total_abort += i["updated_date__count"] elif i["status"] == SUBSCRIBER_STATUS.FAIL: total_fail += i["updated_date__count"] elif i["status"] == SUBSCRIBER_STATUS.SENT: total_sent += i["updated_date__count"] elif i["status"] == SUBSCRIBER_STATUS.IN_PROCESS: total_in_process += i["updated_date__count"] elif i["status"] == SUBSCRIBER_STATUS.NOT_AUTHORIZED: total_not_auth += i["updated_date__count"] else: # status COMPLETED total_completed += i["updated_date__count"] ctx = RequestContext( request, { "form": form, "opts": opts, "total_subscriber": total_subscriber, "total_pending": total_pending, "total_pause": total_pause, "total_abort": total_abort, "total_fail": total_fail, "total_sent": total_sent, "total_in_process": total_in_process, "total_not_auth": total_not_auth, "total_completed": total_completed, "SUBSCRIBER_STATUS_NAME": SUBSCRIBER_STATUS_NAME, "model_name": opts.object_name.lower(), "app_label": _("Dialer Campaign"), "title": _("subscriber report"), }, ) return render_to_response("admin/dialer_campaign/subscriber/subscriber_report.html", context_instance=ctx)
def voipcall_report(request): """VoIP Call Report **Attributes**: * ``form`` - VoipSearchForm * ``template`` - dialer_cdr/voipcall_report.html **Logic Description**: * Get VoIP call list according to search parameters for loggedin user **Important variable**: * ``request.session['voipcall_record_kwargs']`` - stores voipcall kwargs """ sort_col_field_list = ['starting_date', 'leg_type', 'disposition', 'used_gateway', 'callerid', 'callid', 'phone_number', 'duration', 'billsec', 'amd_status'] pag_vars = get_pagination_vars(request, sort_col_field_list, default_sort_field='starting_date') action = 'tabs-1' form = VoipSearchForm(request.user, request.POST or None) if form.is_valid(): # Valid form field_list = ['start_date', 'end_date', 'disposition', 'campaign_id', 'leg_type'] unset_session_var(request, field_list) from_date = getvar(request, 'from_date') to_date = getvar(request, 'to_date') start_date = ceil_strdate(str(from_date), 'start') end_date = ceil_strdate(str(to_date), 'end') converted_start_date = start_date.strftime('%Y-%m-%d') converted_end_date = end_date.strftime('%Y-%m-%d') request.session['session_start_date'] = converted_start_date request.session['session_end_date'] = converted_end_date disposition = getvar(request, 'disposition', setsession=True) campaign_id = getvar(request, 'campaign_id', setsession=True) leg_type = getvar(request, 'leg_type', setsession=True) form = VoipSearchForm(request.user, initial={'from_date': start_date.strftime('%Y-%m-%d'), 'to_date': end_date.strftime('%Y-%m-%d'), 'disposition': disposition, 'campaign_id': campaign_id, 'leg_type': leg_type}) elif request.GET.get('page') or request.GET.get('sort_by'): # Pagination / Sort start_date = request.session.get('session_start_date') end_date = request.session.get('session_end_date') start_date = ceil_strdate(start_date, 'start') end_date = ceil_strdate(end_date, 'end') disposition = request.session.get('session_disposition') campaign_id = request.session.get('session_campaign_id') leg_type = request.session.get('session_leg_type') form = VoipSearchForm(request.user, initial={'from_date': start_date.strftime('%Y-%m-%d'), 'to_date': end_date.strftime('%Y-%m-%d'), 'disposition': disposition, 'campaign_id': campaign_id, 'leg_type': leg_type}) else: # Default tday = datetime.utcnow().replace(tzinfo=utc) from_date = tday.strftime('%Y-%m-%d') to_date = tday.strftime('%Y-%m-%d') start_date = datetime(tday.year, tday.month, tday.day, 0, 0, 0, 0).replace(tzinfo=utc) end_date = datetime(tday.year, tday.month, tday.day, 23, 59, 59, 999999).replace(tzinfo=utc) disposition = 'all' campaign_id = 0 leg_type = '' form = VoipSearchForm(request.user, initial={'from_date': from_date, 'to_date': to_date, 'disposition': disposition, 'campaign_id': campaign_id, 'leg_type': leg_type}) # unset session var request.session['session_start_date'] = start_date request.session['session_end_date'] = end_date request.session['session_disposition'] = disposition request.session['session_campaign_id'] = '' request.session['session_leg_type'] = '' kwargs = {} if start_date and end_date: kwargs['starting_date__range'] = (start_date, end_date) if start_date and end_date == '': kwargs['starting_date__gte'] = start_date if start_date == '' and end_date: kwargs['starting_date__lte'] = end_date if disposition and disposition != 'all': kwargs['disposition__exact'] = disposition if campaign_id and int(campaign_id) != 0: kwargs['callrequest__campaign_id'] = campaign_id if leg_type and leg_type != '': kwargs['leg_type__exact'] = leg_type if not request.user.is_superuser: kwargs['user_id'] = request.user.id voipcall_list = VoIPCall.objects.filter(**kwargs) all_voipcall_list = voipcall_list.values_list('id', flat=True) # Session variable is used to get record set with searched option # into export file request.session['voipcall_record_kwargs'] = kwargs if request.GET.get('page') or request.GET.get('sort_by'): daily_data = request.session['voipcall_daily_data'] else: if not voipcall_list: request.session['voipcall_daily_data'] = '' daily_data = get_voipcall_daily_data(voipcall_list) request.session['voipcall_daily_data'] = daily_data voipcall_list = voipcall_list.order_by(pag_vars['sort_order'])[pag_vars['start_page']:pag_vars['end_page']] data = { 'form': form, 'total_data': daily_data['total_data'], 'total_duration': daily_data['total_duration'], 'total_calls': daily_data['total_calls'], 'total_avg_duration': daily_data['total_avg_duration'], 'max_duration': daily_data['max_duration'], 'all_voipcall_list': all_voipcall_list, 'voipcall_list': voipcall_list, 'CDR_REPORT_COLUMN_NAME': CDR_REPORT_COLUMN_NAME, 'col_name_with_order': pag_vars['col_name_with_order'], 'start_date': start_date, 'end_date': end_date, 'action': action, } request.session['msg'] = '' request.session['error_msg'] = '' return render_to_response('dialer_cdr/voipcall_report.html', data, context_instance=RequestContext(request))
def cdr_concurrent_calls(request): """CDR view of concurrent calls **Attributes**: * ``template`` - cdr/graph_concurrent_calls.html * ``form`` - ConcurrentCallForm * ``mongodb_data_set`` - MONGO_CDRSTATS['CONC_CALL_AGG'] (map-reduce collection) **Logic Description**: get all concurrent call records from mongodb map-reduce collection for current date """ logging.debug('CDR concurrent view start') now = datetime.today() from_date = now.strftime('%Y-%m-%d') start_date = datetime(now.year, now.month, now.day, 0, 0, 0, 0) end_date = datetime(now.year, now.month, now.day, 23, 59, 59, 0) query_var = {} switch_id = 0 form = ConcurrentCallForm(request.POST or None, initial={'from_date': from_date}) logging.debug('CDR concurrent view with search option') if form.is_valid(): from_date = getvar(request, 'from_date') switch_id = getvar(request, 'switch_id') start_date = ceil_strdate(from_date, 'start') end_date = ceil_strdate(from_date, 'end') if switch_id and int(switch_id) != 0: query_var['switch_id'] = int(switch_id) query_var['date'] = {'$gte': start_date, '$lt': end_date} if not request.user.is_superuser: # not superuser query_var['accountcode'] = request.user.userprofile.accountcode xdata = [] charttype = "stackedAreaChart" call_count_res = defaultdict(list) if query_var: # calls_in_day = mongodb.conc_call_agg.find(query_var).sort([('date', 1)]) calls_in_day = {} for d in calls_in_day: # convert date into timestamp value ts = time.mktime(d['date'].timetuple()) tsint = int(ts * 1000) xdata.append(str(tsint)) call_count_res[d['switch_id']].append(d['numbercall']) int_count = 1 chartdata = {'x': xdata} extra_serie = {"tooltip": {"y_start": "", "y_end": " concurrent calls"}, "date_format": "%d %b %Y %I:%M:%S %p"} for i in call_count_res: chartdata['name' + str(int_count)] = str(get_switch_ip_addr(i)) chartdata['y' + str(int_count)] = call_count_res[i] chartdata['extra' + str(int_count)] = extra_serie int_count += 1 logging.debug('CDR concurrent view end') data = { 'form': form, 'start_date': start_date, 'chartdata': chartdata, 'charttype': charttype, 'chartcontainer': 'stacked_area_container', 'chart_extra': { 'x_is_date': True, 'x_axis_format': '%d %b %Y %H:%S', 'tag_script_js': True, 'jquery_on_ready': True, }, } return render_to_response('cdr/graph_concurrent_calls.html', data, context_instance=RequestContext(request))
def event_list(request): """Event list for the logged in user **Attributes**: * ``template`` - appointment/event/list.html **Logic Description**: * List all events which belong to the logged in user. """ today = datetime.utcnow().replace(tzinfo=utc) form = EventSearchForm(request.user, request.POST or None, initial={'start': today.strftime('%Y-%m-%d %H:%M')}) sort_col_field_list = [ 'id', 'start', 'end', 'title', 'calendar', 'status', 'created_on' ] pag_vars = get_pagination_vars(request, sort_col_field_list, default_sort_field='id') start_date = '' calendar_id = '' calendar_user_id = '' post_var_with_page = 0 if form.is_valid(): field_list = ['start_date', 'calendar_id', 'calendar_user_id'] unset_session_var(request, field_list) start_date = getvar(request, 'start_date') start_date = ceil_strdate(str(start_date), 'start') converted_start_date = start_date.strftime('%Y-%m-%d') request.session['session_start_date'] = converted_start_date calendar_id = getvar(request, 'calendar_id', setsession=True) calendar_user_id = getvar(request, 'calendar_user_id', setsession=True) post_var_with_page = 1 if request.GET.get('page') or request.GET.get('sort_by'): post_var_with_page = 1 start_date = request.session.get('session_start_date') start_date = ceil_strdate(start_date, 'start') calendar_id = request.session.get('session_calendar_id') calendar_user_id = request.session.get('session_calendar_user_id') form = EventSearchForm(request.user, initial={ 'start_date': start_date.strftime('%Y-%m-%d %H:%M'), 'calendar_id': calendar_id, 'calendar_user_id': calendar_user_id, }) if post_var_with_page == 0: # default unset session var field_list = ['start_date', 'calendar_id', 'calendar_user_id'] unset_session_var(request, field_list) kwargs = {} calendar_user_id_list = get_calendar_user_id_list(request.user) kwargs['calendar__user_id__in'] = calendar_user_id_list if start_date: kwargs['start__gte'] = start_date if calendar_id and int(calendar_id) != 0: kwargs['calendar_id'] = calendar_id if calendar_user_id and int(calendar_user_id) != 0: kwargs['creator_id'] = calendar_user_id all_event_list = Event.objects.filter(**kwargs).order_by( pag_vars['sort_order']) event_list = all_event_list[pag_vars['start_page']:pag_vars['end_page']] data = { 'form': form, 'msg': request.session.get('msg'), 'all_event_list': all_event_list, 'event_list': event_list, 'total_event': all_event_list.count(), 'EVENT_COLUMN_NAME': EVENT_COLUMN_NAME, 'col_name_with_order': pag_vars['col_name_with_order'], } request.session['msg'] = '' request.session['error_msg'] = '' return render_to_response('appointment/event/list.html', data, context_instance=RequestContext(request))
def event_list(request): """Event list for the logged in user **Attributes**: * ``template`` - appointment/event/list.html **Logic Description**: * List all events which belong to the logged in user. """ today = datetime.utcnow().replace(tzinfo=utc) form = EventSearchForm(request.user, request.POST or None, initial={"start": today.strftime("%Y-%m-%d %H:%M")}) sort_col_field_list = ["id", "start", "end", "title", "calendar", "status", "created_on"] pag_vars = get_pagination_vars(request, sort_col_field_list, default_sort_field="id") start_date = "" calendar_id = "" calendar_user_id = "" post_var_with_page = 0 if form.is_valid(): field_list = ["start_date", "calendar_id", "calendar_user_id"] unset_session_var(request, field_list) start_date = getvar(request, "start_date") start_date = ceil_strdate(str(start_date), "start") converted_start_date = start_date.strftime("%Y-%m-%d") request.session["session_start_date"] = converted_start_date calendar_id = getvar(request, "calendar_id", setsession=True) calendar_user_id = getvar(request, "calendar_user_id", setsession=True) post_var_with_page = 1 if request.GET.get("page") or request.GET.get("sort_by"): post_var_with_page = 1 start_date = request.session.get("session_start_date") start_date = ceil_strdate(start_date, "start") calendar_id = request.session.get("session_calendar_id") calendar_user_id = request.session.get("session_calendar_user_id") form = EventSearchForm( request.user, initial={ "start_date": start_date.strftime("%Y-%m-%d %H:%M"), "calendar_id": calendar_id, "calendar_user_id": calendar_user_id, }, ) if post_var_with_page == 0: # default unset session var field_list = ["start_date", "calendar_id", "calendar_user_id"] unset_session_var(request, field_list) kwargs = {} calendar_user_id_list = get_calendar_user_id_list(request.user) kwargs["calendar__user_id__in"] = calendar_user_id_list if start_date: kwargs["start__gte"] = start_date if calendar_id and int(calendar_id) != 0: kwargs["calendar_id"] = calendar_id if calendar_user_id and int(calendar_user_id) != 0: kwargs["creator_id"] = calendar_user_id all_event_list = Event.objects.filter(**kwargs).order_by(pag_vars["sort_order"]) event_list = all_event_list[pag_vars["start_page"] : pag_vars["end_page"]] data = { "form": form, "msg": request.session.get("msg"), "all_event_list": all_event_list, "event_list": event_list, "total_event": all_event_list.count(), "EVENT_COLUMN_NAME": EVENT_COLUMN_NAME, "col_name_with_order": pag_vars["col_name_with_order"], } request.session["msg"] = "" request.session["error_msg"] = "" return render_to_response("appointment/event/list.html", data, context_instance=RequestContext(request))
def voipcall_report(request): """VoIP Call Report **Attributes**: * ``form`` - VoipSearchForm * ``template`` - dialer_cdr/voipcall_report.html **Logic Description**: * Get VoIP call list according to search parameters for loggedin user **Important variable**: * ``request.session['voipcall_record_kwargs']`` - stores voipcall kwargs """ sort_col_field_list = ['starting_date', 'leg_type', 'disposition', 'used_gateway', 'callerid', 'callid', 'phone_number', 'duration', 'billsec', 'amd_status'] pag_vars = get_pagination_vars(request, sort_col_field_list, default_sort_field='starting_date') action = 'tabs-1' form = VoipSearchForm(request.user, request.POST or None) if form.is_valid(): # Valid form field_list = ['start_date', 'end_date', 'disposition', 'campaign_id', 'leg_type'] unset_session_var(request, field_list) from_date = getvar(request, 'from_date') to_date = getvar(request, 'to_date') start_date = ceil_strdate(str(from_date), 'start') end_date = ceil_strdate(str(to_date), 'end') converted_start_date = start_date.strftime('%Y-%m-%d') converted_end_date = end_date.strftime('%Y-%m-%d') request.session['session_start_date'] = converted_start_date request.session['session_end_date'] = converted_end_date disposition = getvar(request, 'disposition', setsession=True) campaign_id = getvar(request, 'campaign_id', setsession=True) leg_type = getvar(request, 'leg_type', setsession=True) form = VoipSearchForm(request.user, initial={'from_date': start_date.strftime('%Y-%m-%d'), 'to_date': end_date.strftime('%Y-%m-%d'), 'disposition': disposition, 'campaign_id': campaign_id, 'leg_type': leg_type}) elif request.GET.get('page') or request.GET.get('sort_by'): # Pagination / Sort start_date = request.session.get('session_start_date') end_date = request.session.get('session_end_date') start_date = ceil_strdate(str(start_date), 'start') end_date = ceil_strdate(str(end_date), 'end') disposition = request.session.get('session_disposition') campaign_id = request.session.get('session_campaign_id') leg_type = request.session.get('session_leg_type') form = VoipSearchForm(request.user, initial={'from_date': start_date.strftime('%Y-%m-%d'), 'to_date': end_date.strftime('%Y-%m-%d'), 'disposition': disposition, 'campaign_id': campaign_id, 'leg_type': leg_type}) else: # Default tday = datetime.utcnow().replace(tzinfo=utc) from_date = tday.strftime('%Y-%m-%d') to_date = tday.strftime('%Y-%m-%d') start_date = datetime(tday.year, tday.month, tday.day, 0, 0, 0, 0).replace(tzinfo=utc) end_date = datetime(tday.year, tday.month, tday.day, 23, 59, 59, 999999).replace(tzinfo=utc) disposition = 'all' campaign_id = 0 leg_type = '' form = VoipSearchForm(request.user, initial={'from_date': from_date, 'to_date': to_date, 'disposition': disposition, 'campaign_id': campaign_id, 'leg_type': leg_type}) # unset session var request.session['session_start_date'] = start_date request.session['session_end_date'] = end_date request.session['session_disposition'] = disposition request.session['session_campaign_id'] = '' request.session['session_leg_type'] = '' kwargs = {} if start_date and end_date: kwargs['starting_date__range'] = (start_date, end_date) if start_date and end_date == '': kwargs['starting_date__gte'] = start_date if start_date == '' and end_date: kwargs['starting_date__lte'] = end_date if disposition and disposition != 'all': kwargs['disposition__exact'] = disposition if campaign_id and int(campaign_id) != 0: kwargs['callrequest__campaign_id'] = campaign_id if leg_type and leg_type != '': kwargs['leg_type__exact'] = leg_type if not request.user.is_superuser: kwargs['user_id'] = request.user.id voipcall_list = VoIPCall.objects.filter(**kwargs) all_voipcall_list = voipcall_list.values_list('id', flat=True) # Session variable is used to get record set with searched option # into export file request.session['voipcall_record_kwargs'] = kwargs if request.GET.get('page') or request.GET.get('sort_by'): daily_data = request.session['voipcall_daily_data'] else: if not voipcall_list: request.session['voipcall_daily_data'] = '' daily_data = get_voipcall_daily_data(voipcall_list) request.session['voipcall_daily_data'] = daily_data voipcall_list = voipcall_list.order_by(pag_vars['sort_order'])[pag_vars['start_page']:pag_vars['end_page']] data = { 'form': form, 'total_data': daily_data['total_data'], 'total_duration': daily_data['total_duration'], 'total_calls': daily_data['total_calls'], 'total_avg_duration': daily_data['total_avg_duration'], 'max_duration': daily_data['max_duration'], 'all_voipcall_list': all_voipcall_list, 'voipcall_list': voipcall_list, 'CDR_REPORT_COLUMN_NAME': CDR_REPORT_COLUMN_NAME, 'col_name_with_order': pag_vars['col_name_with_order'], 'start_date': start_date, 'end_date': end_date, 'action': action, } request.session['msg'] = '' request.session['error_msg'] = '' return render_to_response('dialer_cdr/voipcall_report.html', data, context_instance=RequestContext(request))
def cdr_view(request): """List of CDRs **Attributes**: * ``template`` - cdr/list.html * ``form`` - CdrSearchForm **Logic Description**: * get the call records as well as daily call analytics from postgresql according to search parameters """ logging.debug('CDR View Start') result = 1 # default min switch_id = 0 # default all hangup_cause_id = 0 # default all destination, destination_type, accountcode, call_record, custom_carrier = '', '', '', '', '' direction, duration, duration_type = '', '', '' caller_id_number, caller_id_number_type, country_id = '', '', '' action = 'tabs-1' menu = 'on' records_per_page = settings.PAGE_SIZE form = CdrSearchForm(request.POST or None) if form.is_valid(): logging.debug('CDR Search View') # set session var value field_list = ['destination', 'result', 'destination_type', 'accountcode', 'caller_id_number', 'caller_id_number_type', 'duration', 'duration_type', 'hangup_cause_id', 'switch_id', 'direction', 'country_id', 'export_query_var'] unset_session_var(request, field_list) from_date = getvar(request, 'from_date', setsession=False) to_date = getvar(request, 'to_date', setsession=False) result = getvar(request, 'result', setsession=True) destination = getvar(request, 'destination', setsession=True) destination_type = getvar(request, 'destination_type', setsession=True) accountcode = getvar(request, 'accountcode', setsession=True) caller_id_number = getvar(request, 'caller_id_number', setsession=True) caller_id_number_type = getvar(request, 'caller_id_number_type', setsession=True) duration = getvar(request, 'duration', setsession=True) duration_type = getvar(request, 'duration_type', setsession=True) direction = getvar(request, 'direction', setsession=True) if direction and direction != 'all' and direction != '0': request.session['session_direction'] = str(direction) switch_id = getvar(request, 'switch_id', setsession=True) hangup_cause_id = getvar(request, 'hangup_cause_id', setsession=True) records_per_page = getvar(request, 'records_per_page', setsession=True) logging.debug(records_per_page) country_id = form.cleaned_data.get('country_id') # convert list value in int country_id = [int(row) for row in country_id] if len(country_id) >= 1: request.session['session_country_id'] = country_id start_date = ceil_strdate(str(from_date), 'start', True) end_date = ceil_strdate(str(to_date), 'end', True) converted_start_date = start_date.strftime('%Y-%m-%d %H:%M') converted_end_date = end_date.strftime('%Y-%m-%d %H:%M') request.session['session_start_date'] = converted_start_date request.session['session_end_date'] = converted_end_date call_record = getvar(request, 'call_record', setsession=True) custom_carrier = getvar(request, 'custom_carrier', setsession=True) menu = show_menu(request) using_session = False # Display a specific page or sort if request.GET.get('page') or request.GET.get('sort_by'): using_session = True from_date = start_date = request.session.get('session_start_date') to_date = end_date = request.session.get('session_end_date') start_date = ceil_strdate(start_date, 'start', True) end_date = ceil_strdate(end_date, 'end', True) destination = request.session.get('session_destination') destination_type = request.session.get('session_destination_type') accountcode = request.session.get('session_accountcode') caller_id_number = request.session.get('session_caller_id_number') caller_id_number_type = request.session.get('session_caller_id_number_type') duration = request.session.get('session_duration') duration_type = request.session.get('session_duration_type') direction = request.session.get('session_direction') switch_id = request.session.get('session_switch_id') hangup_cause_id = request.session.get('session_hangup_cause_id') result = request.session.get('session_result') records_per_page = request.session.get('session_records_per_page') logging.debug(records_per_page) country_id = request.session['session_country_id'] #call_record = request.session['call_record'] # Set default cause we display page for the first time if request.method == 'GET' and not using_session: tday = datetime.today() from_date = datetime(tday.year, tday.month, 1, 0, 0, 0, 0) last_day = ((datetime(tday.year, tday.month, 1, 23, 59, 59, 999999) + relativedelta(months=1)) - relativedelta(days=1)).strftime('%d') # to_date = tday.strftime('%Y-%m-' + last_day + ' 23:59') to_date = datetime(tday.year, tday.month, int(last_day), 23, 59, 59, 999999) start_date = ceil_strdate(str(from_date), 'start', True) end_date = ceil_strdate(str(to_date), 'end', True) converted_start_date = start_date.strftime('%Y-%m-%d %H:%M') converted_end_date = end_date.strftime('%Y-%m-%d %H:%M') request.session['session_start_date'] = converted_start_date request.session['session_end_date'] = converted_end_date request.session['session_result'] = 1 field_list = [ 'destination', 'destination_type', 'accountcode', 'caller_id_number', 'caller_id_number_type', 'duration', 'duration_type', 'hangup_cause_id', 'switch_id', 'direction', 'country_id'] unset_session_var(request, field_list) request.session['session_records_per_page'] = records_per_page logging.debug("test 2: %s", request.session['session_records_per_page']) request.session['session_country_id'] = '' # Define no of records per page records_per_page = int(records_per_page) logging.debug(records_per_page) sort_col_field_list = ['id', 'caller_id_number', 'destination_number', 'starting_date'] page_vars = get_pagination_vars(request, sort_col_field_list, default_sort_field='id') # Build filter for CDR.object kwargs = {} if hangup_cause_id and hangup_cause_id != '0': kwargs['hangup_cause_id'] = int(hangup_cause_id) if switch_id and switch_id != '0': kwargs['switch_id'] = int(switch_id) if direction and direction != 'all' and direction != "0": kwargs['direction'] = direction if len(country_id) >= 1 and country_id[0] != 0: kwargs['country_id__in'] = country_id if start_date: kwargs['starting_date__gte'] = start_date if end_date: kwargs['starting_date__lte'] = end_date if destination: operator_query = get_filter_operator_str('destination_number', destination_type) kwargs[operator_query] = destination if duration: operator_query = get_filter_operator_int('duration', duration_type) kwargs[operator_query] = duration if caller_id_number: operator_query = get_filter_operator_str('caller_id_number', caller_id_number_type) kwargs[operator_query] = caller_id_number # kwargs[operator_query] = "asd" # user are restricted to their own CDRs if not request.user.is_superuser: kwargs['user_id'] = request.user.id if request.user.is_superuser and accountcode: try: acc = AccountCode.objects.get(accountcode=accountcode) kwargs['user_id'] = acc.user.id # on specific accountcode filter let only display that one kwargs['accountcode'] = accountcode except AccountCode.DoesNotExist: # cannot find a user for this accountcode pass #kwargs['call_record'] = destination cdrs = CDR.objects.filter(**kwargs).order_by(page_vars['sort_order']) if page_vars['PAGE_NUMBER']: page_vars['start_page'] = ( page_vars['PAGE_NUMBER'] - 1 ) * records_per_page page_vars['end_page'] = page_vars['start_page'] + records_per_page page_cdr_list = cdrs[page_vars['start_page']:page_vars['end_page']] cdr_count = cdrs.count() logging.debug('Create cdr result') # store query_var in session without date export_kwargs = kwargs.copy() if 'starting_date__gte' in export_kwargs: export_kwargs['starting_date__gte'] = export_kwargs['starting_date__gte'].strftime('%Y-%m-%dT%H:%M:%S') if 'starting_date__lte' in export_kwargs: export_kwargs['starting_date__lte'] = export_kwargs['starting_date__lte'].strftime('%Y-%m-%dT%H:%M:%S') request.session['session_export_kwargs'] = export_kwargs form = CdrSearchForm( initial={ 'from_date': from_date, 'to_date': to_date, 'destination': destination, 'destination_type': destination_type, 'accountcode': accountcode, 'caller_id_number': caller_id_number, 'caller_id_number_type': caller_id_number_type, 'duration': duration, 'duration_type': duration_type, 'result': result, 'direction': direction, 'hangup_cause_id': hangup_cause_id, 'switch_id': switch_id, 'country_id': country_id, 'records_per_page': records_per_page } ) template_data = { 'page_cdr_list': page_cdr_list, 'cdrs': cdrs, 'form': form, 'cdr_count': cdr_count, 'cdr_daily_data': {}, 'col_name_with_order': page_vars['col_name_with_order'], 'menu': menu, 'start_date': start_date, 'end_date': end_date, 'action': action, 'result': result, 'CDR_COLUMN_NAME': CDR_COLUMN_NAME, 'records_per_page': records_per_page, 'up_icon': '<i class="glyphicon glyphicon-chevron-up"></i>', 'down_icon': '<i class="glyphicon glyphicon-chevron-down"></i>' } logging.debug('CDR View End') return render_to_response('cdr/list.html', template_data, context_instance=RequestContext(request))
def cdr_daily_comparison(request): """ Hourly CDR graph that compare with previous dates **Attributes**: * ``template`` - cdr/daily_comparison.html * ``form`` - CompareCallSearchForm **Logic Description**: get the call records aggregated from the CDR table using the materialized view and compare with other date records # hourly_charttype = "lineWithFocusChart" # daily_charttype = "lineWithFocusChart" # hourly_chartdata = {'x': []} # daily_chartdata = {'x': []} # metric = 'nbcalls' # Default metric """ # Default metric = 'nbcalls' switch_id = 0 hourly_charttype = "multiBarChart" hourly_chartdata = {'x': []} compare_days = 2 compare_type = COMPARE_WITH.previous_days today_date = datetime.today() form = CompareCallSearchForm(request.POST or None, initial={'from_date': today_date.strftime('%Y-%m-%d'), 'compare_days': compare_days, 'compare_type': compare_type, 'switch_id': 0}) today_date = datetime(today_date.year, today_date.month, today_date.day) current_date = today_date if form.is_valid(): from_date = getvar(request, 'from_date') current_date = ceil_strdate(str(from_date), 'start') # current_date = trunc_date_start(from_date) switch_id = getvar(request, 'switch_id') compare_days = int(getvar(request, 'compare_days')) metric = getvar(request, 'metric') kwargs = {} if switch_id and switch_id != '0': kwargs['switch_id'] = int(switch_id) xdata = [i for i in range(0, 24)] hourly_chartdata = {'x': xdata} y_count = 1 for nday in range(1, compare_days + 1): start_date = current_date + relativedelta(days=-int(nday-1)) start_date = datetime(start_date.year, start_date.month, start_date.day, 0, 0, 0, 0) end_date = current_date + relativedelta(days=-int(nday-1)) end_date = datetime(end_date.year, end_date.month, end_date.day, 23, 59, 59, 999999) # Get hourly Data hourly_data = get_report_compare_cdr(request.user, 'hour', start_date, end_date, switch_id) extra_serie = { "tooltip": {"y_start": "", "y_end": " " + metric} } # We only need to set x axis once, so let's do it for nbcalls # hourly_chartdata['x'] = hourly_data["nbcalls"]["x_timestamp"] for switch in hourly_data[metric]["columns"]: serie = get_switch_ip_addr(switch) + "_day_" + str(nday) hourly_chartdata['name' + str(y_count)] = serie hourly_chartdata['y' + str(y_count)] = hourly_data[metric]["values"][str(switch)] hourly_chartdata['extra' + str(y_count)] = extra_serie y_count += 1 variables = { 'form': form, 'from_date': current_date, 'metric': metric, 'compare_days': compare_days, 'hourly_charttype': hourly_charttype, 'hourly_chartdata': hourly_chartdata, 'hourly_chartcontainer': 'hourly_chartcontainer', 'hourly_extra': { 'x_is_date': False, 'x_axis_format': '', 'tag_script_js': True, 'jquery_on_ready': True, }, } return render_to_response('cdr/daily_comparison.html', variables, context_instance=RequestContext(request))
def event_list(request): """Event list for the logged in user **Attributes**: * ``template`` - appointment/event/list.html **Logic Description**: * List all events which belong to the logged in user. """ today = datetime.utcnow().replace(tzinfo=utc) form = EventSearchForm(request.user, request.POST or None, initial={'start': today.strftime('%Y-%m-%d %H:%M')}) sort_col_field_list = ['id', 'start', 'end', 'title', 'calendar', 'status', 'created_on'] pag_vars = get_pagination_vars(request, sort_col_field_list, default_sort_field='id') start_date = '' calendar_id = '' calendar_user_id = '' post_var_with_page = 0 if form.is_valid(): field_list = ['start_date', 'calendar_id', 'calendar_user_id'] unset_session_var(request, field_list) start_date = getvar(request, 'start_date') start_date = ceil_strdate(str(start_date), 'start') converted_start_date = start_date.strftime('%Y-%m-%d') request.session['session_start_date'] = converted_start_date calendar_id = getvar(request, 'calendar_id', setsession=True) calendar_user_id = getvar(request, 'calendar_user_id', setsession=True) post_var_with_page = 1 if request.GET.get('page') or request.GET.get('sort_by'): post_var_with_page = 1 start_date = request.session.get('session_start_date') start_date = ceil_strdate(start_date, 'start') calendar_id = request.session.get('session_calendar_id') calendar_user_id = request.session.get('session_calendar_user_id') form = EventSearchForm(request.user, initial={'start_date': start_date.strftime('%Y-%m-%d %H:%M'), 'calendar_id': calendar_id, 'calendar_user_id': calendar_user_id, }) if post_var_with_page == 0: # default unset session var field_list = ['start_date', 'calendar_id', 'calendar_user_id'] unset_session_var(request, field_list) kwargs = {} calendar_user_id_list = get_calendar_user_id_list(request.user) kwargs['calendar__user_id__in'] = calendar_user_id_list if start_date: kwargs['start__gte'] = start_date if calendar_id and int(calendar_id) != 0: kwargs['calendar_id'] = calendar_id if calendar_user_id and int(calendar_user_id) != 0: kwargs['creator_id'] = calendar_user_id all_event_list = Event.objects.filter(**kwargs).order_by(pag_vars['sort_order']) event_list = all_event_list[pag_vars['start_page']:pag_vars['end_page']] data = { 'form': form, 'msg': request.session.get('msg'), 'all_event_list': all_event_list, 'event_list': event_list, 'total_event': all_event_list.count(), 'EVENT_COLUMN_NAME': EVENT_COLUMN_NAME, 'col_name_with_order': pag_vars['col_name_with_order'], } request.session['msg'] = '' request.session['error_msg'] = '' return render_to_response('appointment/event/list.html', data, context_instance=RequestContext(request))
def cdr_daily_comparison(request): """ Hourly CDR graph that compare with previous dates **Attributes**: * ``template`` - cdr/daily_comparison.html * ``form`` - CompareCallSearchForm **Logic Description**: get the call records aggregated from the CDR table using the materialized view and compare with other date records # hourly_charttype = "lineWithFocusChart" # daily_charttype = "lineWithFocusChart" # hourly_chartdata = {'x': []} # daily_chartdata = {'x': []} # metric = 'nbcalls' # Default metric """ # Default metric = 'nbcalls' switch_id = 0 hourly_charttype = "multiBarChart" hourly_chartdata = {'x': []} compare_days = 2 compare_type = COMPARE_WITH.previous_days today_date = datetime.today() form = CompareCallSearchForm(request.POST or None, initial={'from_date': today_date.strftime('%Y-%m-%d'), 'compare_days': compare_days, 'compare_type': compare_type, 'switch_id': 0}) today_date = datetime(today_date.year, today_date.month, today_date.day) current_date = today_date if form.is_valid(): from_date = getvar(request, 'from_date') current_date = ceil_strdate(str(from_date), 'start') # current_date = trunc_date_start(from_date) switch_id = getvar(request, 'switch_id') compare_days = int(getvar(request, 'compare_days')) metric = getvar(request, 'metric') kwargs = {} if switch_id and switch_id != '0': kwargs['switch_id'] = int(switch_id) xdata = [i for i in range(0, 24)] hourly_chartdata = {'x': xdata} y_count = 1 for nday in range(1, compare_days + 1): start_date = current_date + relativedelta(days=-int(nday-1)) start_date = datetime(start_date.year, start_date.month, start_date.day, 0, 0, 0, 0) end_date = current_date + relativedelta(days=-int(nday-1)) end_date = datetime(end_date.year, end_date.month, end_date.day, 23, 59, 59, 999999) # Get hourly Data hourly_data = get_report_compare_cdr(request.user, 'hour', start_date, end_date, switch_id) extra_serie = { "tooltip": {"y_start": "", "y_end": " " + metric} } # We only need to set x axis once, so let's do it for nbcalls # hourly_chartdata['x'] = hourly_data["nbcalls"]["x_timestamp"] for switch in hourly_data[metric]["columns"]: serie = get_switch_ip_addr(switch) + "_day_" + str(nday) hourly_chartdata['name' + str(y_count)] = serie hourly_chartdata['y' + str(y_count)] = hourly_data[metric]["values"][str(switch)] hourly_chartdata['extra' + str(y_count)] = extra_serie y_count += 1 variables = { 'form': form, 'from_date': current_date, 'metric': metric, 'compare_days': compare_days, 'hourly_charttype': hourly_charttype, 'hourly_chartdata': hourly_chartdata, 'hourly_chartcontainer': 'hourly_chartcontainer', 'hourly_extra': { 'x_is_date': False, 'x_axis_format': '', 'tag_script_js': True, 'jquery_on_ready': True, }, } return render_to_response('cdr/daily_comparison.html', variables, context_instance=RequestContext(request))
def rebilling(self, request): """ Re-billing successful VoIP Calls """ opts = VoIPPlan._meta # default values for form tday = datetime.today() to_date = from_date = tday.strftime('%Y-%m-%d') form = RebillForm(request.POST or None, initial={'from_date': from_date, 'to_date': to_date, 'confirmation': CONFIRMATION_TYPE.NO}) call_rebill_count = 0 if request.method == 'POST': form = RebillForm(request.POST) if "from_date" in request.POST: # From from_date = request.POST['from_date'] start_date = ceil_strdate(from_date, 'start') if "to_date" in request.POST: # To to_date = request.POST['to_date'] end_date = ceil_strdate(to_date, 'end') call_kwargs = {} daily_kwargs = {} monthly_kwargs = {} if start_date and end_date: call_kwargs['start_uepoch'] = {'$gte': start_date, '$lt': end_date} # get kwargs for aggregate daily_kwargs['metadata.date'] = {'$gte': start_date.strftime('%Y-%m-%d'), '$lt': end_date.strftime('%Y-%m-%d')} monthly_kwargs['metadata.date'] = {'$gte': start_date.strftime('%Y-%m'), '$lt': end_date.strftime('%Y-%m')} if not request.user.is_superuser: # not superuser call_kwargs['accountcode'] = request.user.userprofile.accountcode monthly_kwargs['metadata.accountcode'] =\ daily_kwargs['metadata.accountcode'] = call_kwargs['accountcode'] # Get total no of calls which are going to rebill # call_rebill_count = mongodb.cdr_common.find(call_kwargs).count() if "confirmation" in request.POST: confirmation = request.POST.get('confirmation') # To confirm re-billing if confirmation == CONFIRMATION_TYPE.NO: request.POST['confirmation'] = CONFIRMATION_TYPE.YES form.fields['from_date'].widget = form.fields['to_date'].widget = forms.HiddenInput() ctx = RequestContext(request, { 'form': form, 'start_date': start_date, 'end_date': end_date, 'opts': opts, 'model_name': opts.object_name.lower(), 'title': _('Rebill VoIP Call'), 'call_rebill_count': call_rebill_count, 'CONFIRMATION_TYPE': CONFIRMATION_TYPE, }) return render_to_response('admin/voip_billing/voipplan/rebilling.html', context_instance=ctx) voipplan_id = request.user.userprofile.voipplan_id # re-billing is confirmed by user if confirmation == CONFIRMATION_TYPE.YES: if call_rebill_count != 0: # Rebill all calls RebillingTask.delay(call_kwargs, voipplan_id) msg = _('Re-billing is done') messages.info(request, msg) request.POST['confirmation'] = CONFIRMATION_TYPE.NO call_rebill_count = 0 ctx = RequestContext(request, { 'form': form, 'opts': opts, 'model_name': opts.object_name.lower(), 'title': _('Rebill VoIP Call'), 'call_rebill_count': call_rebill_count, }) return render_to_response('admin/voip_billing/voipplan/rebilling.html', context_instance=ctx)
def cdr_view(request): """List of CDRs **Attributes**: * ``template`` - cdr/list.html * ``form`` - CdrSearchForm **Logic Description**: * get the call records as well as daily call analytics from postgresql according to search parameters """ logging.debug('CDR View Start') result = 1 # default min switch_id = 0 # default all hangup_cause_id = 0 # default all destination, destination_type, accountcode = '', '', '' direction, duration, duration_type = '', '', '' caller_id_number, caller_id_number_type, country_id = '', '', '' action = 'tabs-1' menu = 'on' records_per_page = settings.PAGE_SIZE form = CdrSearchForm(request.POST or None) if form.is_valid(): logging.debug('CDR Search View') # set session var value field_list = ['destination', 'result', 'destination_type', 'accountcode', 'caller_id_number', 'caller_id_number_type', 'duration', 'duration_type', 'hangup_cause_id', 'switch_id', 'direction', 'country_id', 'export_query_var'] unset_session_var(request, field_list) from_date = getvar(request, 'from_date', setsession=False) to_date = getvar(request, 'to_date', setsession=False) result = getvar(request, 'result', setsession=True) destination = getvar(request, 'destination', setsession=True) destination_type = getvar(request, 'destination_type', setsession=True) accountcode = getvar(request, 'accountcode', setsession=True) caller_id_number = getvar(request, 'caller_id_number', setsession=True) caller_id_number_type = getvar(request, 'caller_id_number_type', setsession=True) duration = getvar(request, 'duration', setsession=True) duration_type = getvar(request, 'duration_type', setsession=True) direction = getvar(request, 'direction', setsession=True) if direction and direction != 'all' and direction != '0': request.session['session_direction'] = str(direction) switch_id = getvar(request, 'switch_id', setsession=True) hangup_cause_id = getvar(request, 'hangup_cause_id', setsession=True) records_per_page = getvar(request, 'records_per_page', setsession=True) country_id = form.cleaned_data.get('country_id') # convert list value in int country_id = [int(row) for row in country_id] if len(country_id) >= 1: request.session['session_country_id'] = country_id start_date = ceil_strdate(str(from_date), 'start', True) end_date = ceil_strdate(str(to_date), 'end', True) converted_start_date = start_date.strftime('%Y-%m-%d %H:%M') converted_end_date = end_date.strftime('%Y-%m-%d %H:%M') request.session['session_start_date'] = converted_start_date request.session['session_end_date'] = converted_end_date menu = show_menu(request) using_session = False # Display a specific page or sort if request.GET.get('page') or request.GET.get('sort_by'): using_session = True from_date = start_date = request.session.get('session_start_date') to_date = end_date = request.session.get('session_end_date') start_date = ceil_strdate(start_date, 'start', True) end_date = ceil_strdate(end_date, 'end', True) destination = request.session.get('session_destination') destination_type = request.session.get('session_destination_type') accountcode = request.session.get('session_accountcode') caller_id_number = request.session.get('session_caller_id_number') caller_id_number_type = request.session.get('session_caller_id_number_type') duration = request.session.get('session_duration') duration_type = request.session.get('session_duration_type') direction = request.session.get('session_direction') switch_id = request.session.get('session_switch_id') hangup_cause_id = request.session.get('session_hangup_cause_id') result = request.session.get('session_result') records_per_page = request.session.get('session_records_per_page') country_id = request.session['session_country_id'] # Set default cause we display page for the first time if request.method == 'GET' and not using_session: tday = datetime.today() from_date = datetime(tday.year, tday.month, 1, 0, 0, 0, 0) last_day = ((datetime(tday.year, tday.month, 1, 23, 59, 59, 999999) + relativedelta(months=1)) - relativedelta(days=1)).strftime('%d') # to_date = tday.strftime('%Y-%m-' + last_day + ' 23:59') to_date = datetime(tday.year, tday.month, int(last_day), 23, 59, 59, 999999) start_date = ceil_strdate(str(from_date), 'start', True) end_date = ceil_strdate(str(to_date), 'end', True) converted_start_date = start_date.strftime('%Y-%m-%d %H:%M') converted_end_date = end_date.strftime('%Y-%m-%d %H:%M') request.session['session_start_date'] = converted_start_date request.session['session_end_date'] = converted_end_date request.session['session_result'] = 1 field_list = [ 'destination', 'destination_type', 'accountcode', 'caller_id_number', 'caller_id_number_type', 'duration', 'duration_type', 'hangup_cause_id', 'switch_id', 'direction', 'country_id'] unset_session_var(request, field_list) request.session['session_records_per_page'] = records_per_page request.session['session_country_id'] = '' # Define no of records per page records_per_page = int(records_per_page) sort_col_field_list = ['id', 'caller_id_number', 'destination_number', 'starting_date'] page_vars = get_pagination_vars(request, sort_col_field_list, default_sort_field='id') # Build filter for CDR.object kwargs = {} if hangup_cause_id and hangup_cause_id != '0': kwargs['hangup_cause_id'] = int(hangup_cause_id) if switch_id and switch_id != '0': kwargs['switch_id'] = int(switch_id) if direction and direction != 'all' and direction != "0": kwargs['direction'] = direction if len(country_id) >= 1 and country_id[0] != 0: kwargs['country_id__in'] = country_id if start_date: kwargs['starting_date__gte'] = start_date if end_date: kwargs['starting_date__lte'] = end_date if destination: operator_query = get_filter_operator_str('destination_number', destination_type) kwargs[operator_query] = destination if duration: operator_query = get_filter_operator_int('duration', duration_type) kwargs[operator_query] = duration if caller_id_number: operator_query = get_filter_operator_str('caller_id_number', caller_id_number_type) kwargs[operator_query] = caller_id_number # user are restricted to their own CDRs if not request.user.is_superuser: kwargs['user_id'] = request.user.id if request.user.is_superuser and accountcode: try: user_prof = UserProfile.objects.get(accountcode=accountcode) kwargs['user_id'] = user_prof.user.id except UserProfile.DoesNotExist: # cannot find a user for this accountcode pass cdrs = CDR.objects.filter(**kwargs).order_by(page_vars['sort_order']) page_cdr_list = cdrs[page_vars['start_page']:page_vars['end_page']] cdr_count = cdrs.count() logging.debug('Create cdr result') # store query_var in session without date export_kwargs = kwargs.copy() if 'starting_date__gte' in export_kwargs: export_kwargs['starting_date__gte'] = export_kwargs['starting_date__gte'].strftime('%Y-%m-%dT%H:%M:%S') if 'starting_date__lte' in export_kwargs: export_kwargs['starting_date__lte'] = export_kwargs['starting_date__lte'].strftime('%Y-%m-%dT%H:%M:%S') request.session['session_export_kwargs'] = export_kwargs form = CdrSearchForm( initial={ 'from_date': from_date, 'to_date': to_date, 'destination': destination, 'destination_type': destination_type, 'accountcode': accountcode, 'caller_id_number': caller_id_number, 'caller_id_number_type': caller_id_number_type, 'duration': duration, 'duration_type': duration_type, 'result': result, 'direction': direction, 'hangup_cause_id': hangup_cause_id, 'switch_id': switch_id, 'country_id': country_id, 'records_per_page': records_per_page } ) template_data = { 'page_cdr_list': page_cdr_list, 'cdrs': cdrs, 'form': form, 'cdr_count': cdr_count, 'cdr_daily_data': {}, 'col_name_with_order': page_vars['col_name_with_order'], 'menu': menu, 'start_date': start_date, 'end_date': end_date, 'action': action, 'result': result, 'CDR_COLUMN_NAME': CDR_COLUMN_NAME, 'records_per_page': records_per_page, 'up_icon': '<i class="glyphicon glyphicon-chevron-up"></i>', 'down_icon': '<i class="glyphicon glyphicon-chevron-down"></i>' } logging.debug('CDR View End') return render_to_response('cdr/list.html', template_data, context_instance=RequestContext(request))
def subscriber_report(self, request): """ Get subscriber report **Attributes**: * ``form`` - SubscriberReportForm * ``template`` - admin/dialer_campaign/subscriber/subscriber_report.html """ opts = Subscriber._meta tday = datetime.today() form = SubscriberReportForm(request.POST or None, initial={"from_date": tday.strftime("%Y-%m-%d"), "to_date": tday.strftime("%Y-%m-%d")}) total_subscriber = 0 total_pending = 0 total_pause = 0 total_abort = 0 total_fail = 0 total_sent = 0 total_in_process = 0 total_not_auth = 0 total_completed = 0 if form.is_valid(): start_date = '' end_date = '' from_date = getvar(request, 'from_date') to_date = getvar(request, 'to_date') start_date = ceil_strdate(str(from_date), 'start') end_date = ceil_strdate(str(to_date), 'end') campaign_id = getvar(request, 'campaign_id') kwargs = {} if start_date and end_date: kwargs['updated_date__range'] = (start_date, end_date) if start_date and end_date == '': kwargs['updated_date__gte'] = start_date if start_date == '' and end_date: kwargs['updated_date__lte'] = end_date if campaign_id and campaign_id != '0': kwargs['campaign_id'] = campaign_id select_data = {"updated_date": "SUBSTR(CAST(updated_date as CHAR(30)),1,10)"} subscriber = Subscriber.objects.filter(**kwargs).extra(select=select_data)\ .values('updated_date', 'status')\ .annotate(Count('updated_date'))\ .order_by('updated_date') for i in subscriber: total_subscriber += i['updated_date__count'] if i['status'] == SUBSCRIBER_STATUS.PENDING: total_pending += i['updated_date__count'] elif i['status'] == SUBSCRIBER_STATUS.PAUSE: total_pause += i['updated_date__count'] elif i['status'] == SUBSCRIBER_STATUS.ABORT: total_abort += i['updated_date__count'] elif i['status'] == SUBSCRIBER_STATUS.FAIL: total_fail += i['updated_date__count'] elif i['status'] == SUBSCRIBER_STATUS.SENT: total_sent += i['updated_date__count'] elif i['status'] == SUBSCRIBER_STATUS.IN_PROCESS: total_in_process += i['updated_date__count'] elif i['status'] == SUBSCRIBER_STATUS.NOT_AUTHORIZED: total_not_auth += i['updated_date__count'] else: #status COMPLETED total_completed += i['updated_date__count'] ctx = RequestContext(request, { 'form': form, 'opts': opts, 'total_subscriber': total_subscriber, 'total_pending': total_pending, 'total_pause': total_pause, 'total_abort': total_abort, 'total_fail': total_fail, 'total_sent': total_sent, 'total_in_process': total_in_process, 'total_not_auth': total_not_auth, 'total_completed': total_completed, 'SUBSCRIBER_STATUS_NAME': SUBSCRIBER_STATUS_NAME, 'model_name': opts.object_name.lower(), 'app_label': APP_LABEL, 'title': _('subscriber report'), }) return render_to_response('admin/dialer_campaign/subscriber/subscriber_report.html', context_instance=ctx)
def cdr_concurrent_calls(request): """CDR view of concurrent calls **Attributes**: * ``template`` - cdr/graph_concurrent_calls.html * ``form`` - ConcurrentCallForm * ``mongodb_data_set`` - MONGO_CDRSTATS['CONC_CALL_AGG'] (map-reduce collection) **Logic Description**: get all concurrent call records from mongodb map-reduce collection for current date """ logging.debug("CDR concurrent view start") now = datetime.today() from_date = now.strftime("%Y-%m-%d") start_date = datetime(now.year, now.month, now.day, 0, 0, 0, 0) end_date = datetime(now.year, now.month, now.day, 23, 59, 59, 0) query_var = {} switch_id = 0 form = ConcurrentCallForm(request.POST or None, initial={"from_date": from_date}) logging.debug("CDR concurrent view with search option") if form.is_valid(): from_date = getvar(request, "from_date") switch_id = getvar(request, "switch_id") start_date = ceil_strdate(from_date, "start") end_date = ceil_strdate(from_date, "end") if switch_id and int(switch_id) != 0: query_var["switch_id"] = int(switch_id) query_var["date"] = {"$gte": start_date, "$lt": end_date} if not request.user.is_superuser: # not superuser query_var["accountcode"] = request.user.userprofile.accountcode xdata = [] charttype = "stackedAreaChart" call_count_res = defaultdict(list) if query_var: # calls_in_day = mongodb.conc_call_agg.find(query_var).sort([('date', 1)]) calls_in_day = {} for d in calls_in_day: # convert date into timestamp value ts = time.mktime(d["date"].timetuple()) tsint = int(ts * 1000) xdata.append(str(tsint)) call_count_res[d["switch_id"]].append(d["numbercall"]) int_count = 1 chartdata = {"x": xdata} extra_serie = {"tooltip": {"y_start": "", "y_end": " concurrent calls"}, "date_format": "%d %b %Y %I:%M:%S %p"} for i in call_count_res: chartdata["name" + str(int_count)] = str(get_switch_ip_addr(i)) chartdata["y" + str(int_count)] = call_count_res[i] chartdata["extra" + str(int_count)] = extra_serie int_count += 1 logging.debug("CDR concurrent view end") data = { "form": form, "start_date": start_date, "chartdata": chartdata, "charttype": charttype, "chartcontainer": "stacked_area_container", "chart_extra": { "x_is_date": True, "x_axis_format": "%d %b %Y %H:%S", "tag_script_js": True, "jquery_on_ready": True, }, } return render_to_response("cdr/graph_concurrent_calls.html", data, context_instance=RequestContext(request))
def survey_report(request): """ Survey detail report for the logged in user **Attributes**: * ``template`` - survey/survey_report.html * ``form`` - SurveyDetailReportForm **Logic Description**: * List all survey_report which belong to the logged in user. """ tday = datetime.today() from_date = tday.strftime("%Y-%m-%d") to_date = tday.strftime("%Y-%m-%d") form = SurveyDetailReportForm(request.user, request.POST or None, initial={'from_date': from_date, 'to_date': to_date}) survey_result = '' survey_cdr_daily_data = { 'total_data': '', 'total_duration': '', 'total_calls': '', 'total_avg_duration': '', 'max_duration': '', } sort_col_field_list = ['starting_date', 'phone_number', 'duration', 'disposition', 'id'] pag_vars = get_pagination_vars(request, sort_col_field_list, default_sort_field='starting_date') survey_id = '' action = 'tabs-1' campaign_obj = '' rows = [] survey_id = '' post_var_with_page = 0 if form.is_valid(): post_var_with_page = 1 # set session var value request.session['session_surveycalls_kwargs'] = {} request.session['session_survey_cdr_daily_data'] = {} # set session var value field_list = ['from_date', 'to_date', 'survey_id'] unset_session_var(request, field_list) from_date = getvar(request, 'from_date') to_date = getvar(request, 'to_date') start_date = ceil_strdate(str(from_date), 'start') end_date = ceil_strdate(str(to_date), 'end') converted_start_date = start_date.strftime('%Y-%m-%d') converted_end_date = end_date.strftime('%Y-%m-%d') request.session['session_start_date'] = converted_start_date request.session['session_end_date'] = converted_end_date survey_id = getvar(request, 'survey_id', setsession=True) if request.GET.get('page') or request.GET.get('sort_by'): post_var_with_page = 1 start_date = request.session.get('session_start_date') end_date = request.session.get('session_end_date') start_date = ceil_strdate(start_date, 'start') end_date = ceil_strdate(end_date, 'end') survey_id = request.session.get('session_survey_id') form = SurveyDetailReportForm(request.user, initial={'from_date': start_date.strftime('%Y-%m-%d'), 'to_date': end_date.strftime('%Y-%m-%d'), 'survey_id': survey_id}) if post_var_with_page == 0: # default # unset session var tday = datetime.utcnow().replace(tzinfo=utc) from_date = tday.strftime('%Y-%m-01') last_day = ((datetime(tday.year, tday.month, 1, 23, 59, 59, 999999).replace(tzinfo=utc) + relativedelta(months=1)) - relativedelta(days=1)).strftime('%d') to_date = tday.strftime('%Y-%m-' + last_day) start_date = ceil_strdate(from_date, 'start') end_date = ceil_strdate(to_date, 'end') # unset session var value request.session['session_from_date'] = from_date request.session['session_to_date'] = to_date request.session['session_survey_id'] = '' request.session['session_surveycalls_kwargs'] = '' kwargs = {} if not request.user.is_superuser: kwargs['user'] = request.user kwargs['disposition__exact'] = CALL_DISPOSITION.ANSWER survey_result_kwargs = {} if start_date and end_date: kwargs['starting_date__range'] = (start_date, end_date) survey_result_kwargs['created_date__range'] = (start_date, end_date) if start_date and end_date == '': kwargs['starting_date__gte'] = start_date survey_result_kwargs['created_date__gte'] = start_date if start_date == '' and end_date: kwargs['starting_date__lte'] = end_date survey_result_kwargs['created_date__lte'] = end_date all_call_list = [] try: survey_result_kwargs['survey_id'] = survey_id survey_result = get_survey_result(survey_result_kwargs) campaign_obj = Survey.objects.get(id=int(survey_id)).campaign kwargs['callrequest__campaign'] = campaign_obj # List of Survey VoIP call report voipcall_list = VoIPCall.objects.filter(**kwargs) request.session['session_surveycalls_kwargs'] = kwargs all_call_list = voipcall_list.values_list('id', flat=True) # Get daily report from session while using pagination & sorting if request.GET.get('page') or request.GET.get('sort_by'): survey_cdr_daily_data = request.session['session_survey_cdr_daily_data'] action = 'tabs-2' else: survey_cdr_daily_data = survey_cdr_daily_report(voipcall_list) request.session['session_survey_cdr_daily_data'] = survey_cdr_daily_data rows = voipcall_list.order_by(pag_vars['sort_order'])[pag_vars['start_page']:pag_vars['end_page']] except: rows = [] if request.method == 'POST': request.session["err_msg"] = _('no campaign attached with survey.') data = { 'rows': rows, 'all_call_list': all_call_list, 'call_count': all_call_list.count() if all_call_list else 0, 'SURVEY_CALL_RESULT_NAME': SURVEY_CALL_RESULT_NAME, 'col_name_with_order': pag_vars['col_name_with_order'], 'total_data': survey_cdr_daily_data['total_data'], 'total_duration': survey_cdr_daily_data['total_duration'], 'total_calls': survey_cdr_daily_data['total_calls'], 'total_avg_duration': survey_cdr_daily_data['total_avg_duration'], 'max_duration': survey_cdr_daily_data['max_duration'], 'msg': request.session.get('msg'), 'err_msg': request.session.get('err_msg'), 'form': form, 'survey_result': survey_result, 'action': action, 'start_date': start_date, 'end_date': end_date, 'campaign_obj': campaign_obj, } request.session['msg'] = '' request.session['err_msg'] = '' return render_to_response('survey/survey_report.html', data, context_instance=RequestContext(request))
def sms_report(request): """SMS Report **Attributes**: * ``form`` - SMSSearchForm * ``template`` - mod_sms/sms_report.html **Logic Description**: * Get SMS list according to search parameters for logged-in user **Important variable**: * ``request.session['sms_record_kwargs']`` - stores sms kwargs """ sort_col_field_list = ['send_date', 'recipient_number', 'uuid', 'status', 'status_message', 'gateway'] pag_vars = get_pagination_vars(request, sort_col_field_list, default_sort_field='send_date') from_date = '' to_date = '' status = 'all' smscampaign = '' form = SMSSearchForm(request.user, request.POST or None) action = 'tabs-1' kwargs = {} post_var_with_page = 0 if form.is_valid(): post_var_with_page = 1 field_list = ['start_date', 'end_date', 'status', 'smscampaign'] unset_session_var(request, field_list) from_date = getvar(request, 'from_date') to_date = getvar(request, 'to_date') start_date = ceil_strdate(str(from_date), 'start') end_date = ceil_strdate(str(to_date), 'end') converted_start_date = start_date.strftime('%Y-%m-%d') converted_end_date = end_date.strftime('%Y-%m-%d') request.session['session_start_date'] = converted_start_date request.session['session_end_date'] = converted_end_date status = getvar(request, 'status', setsession=True) smscampaign = getvar(request, 'smscampaign', setsession=True) if request.GET.get('page') or request.GET.get('sort_by'): post_var_with_page = 1 start_date = request.session.get('session_start_date') end_date = request.session.get('session_end_date') start_date = ceil_strdate(start_date, 'start') end_date = ceil_strdate(end_date, 'end') status = request.session.get('session_status') smscampaign = request.session.get('session_smscampaign') form = SMSSearchForm(request.user, initial={'from_date': start_date.strftime('%Y-%m-%d'), 'to_date': end_date.strftime('%Y-%m-%d'), 'status': status, 'smscampaign': smscampaign}) if post_var_with_page == 0: # default tday = datetime.utcnow().replace(tzinfo=utc) from_date = tday.strftime('%Y-%m-%d') to_date = tday.strftime('%Y-%m-%d') start_date = datetime(tday.year, tday.month, tday.day, 0, 0, 0, 0).replace(tzinfo=utc) end_date = datetime(tday.year, tday.month, tday.day, 23, 59, 59, 999999).replace(tzinfo=utc) status = 'all' smscampaign = '' form = SMSSearchForm(request.user, initial={'from_date': from_date, 'to_date': to_date, 'status': status, 'smscampaign': smscampaign}) # unset session var request.session['session_start_date'] = start_date request.session['session_end_date'] = end_date request.session['session_status'] = status request.session['session_smscampaign'] = smscampaign kwargs['sender'] = request.user if start_date and end_date: kwargs['send_date__range'] = (start_date, end_date) if start_date and end_date == '': kwargs['send_date__gte'] = start_date if start_date == '' and end_date: kwargs['send_date__lte'] = end_date if status and status != 'all': kwargs['status__exact'] = status if smscampaign and smscampaign != '0': kwargs['sms_campaign_id'] = smscampaign smslist = SMSMessage.objects.filter(**kwargs) all_sms_list = smslist.values_list('id', flat=True) sms_list = smslist.order_by(pag_vars['sort_order'])[pag_vars['start_page']:pag_vars['end_page']] # Session variable is used to get record set with searched option # into export file request.session['sms_record_kwargs'] = kwargs select_data = {"send_date": "SUBSTR(CAST(send_date as CHAR(30)),1,10)"} # Get Total Rrecords from SMSMessage Report table for Daily SMS Report total_data = all_sms_list.extra(select=select_data).values('send_date')\ .annotate(Count('send_date')).order_by('-send_date') # Following code will count total sms if total_data.count() != 0: total_sms = sum([x['send_date__count'] for x in total_data]) else: total_sms = 0 data = { 'form': form, 'from_date': from_date, 'all_sms_list': all_sms_list, 'sms_list': sms_list, 'sms_count': all_sms_list.count() if all_sms_list else 0, 'SMS_REPORT_COLUMN_NAME': SMS_REPORT_COLUMN_NAME, 'col_name_with_order': pag_vars['col_name_with_order'], 'start_date': start_date, 'end_date': end_date, 'to_date': to_date, 'action': action, 'status': status, 'total_data': total_data.reverse(), 'total_sms': total_sms, } return render_to_response('mod_sms/sms_report.html', data, context_instance=RequestContext(request))
def sms_report(request): """SMS Report **Attributes**: * ``form`` - SMSSearchForm * ``template`` - mod_sms/sms_report.html **Logic Description**: * Get SMS list according to search parameters for logged-in user **Important variable**: * ``request.session['sms_record_kwargs']`` - stores sms kwargs """ sort_col_field_list = [ 'send_date', 'recipient_number', 'uuid', 'status', 'status_message', 'gateway' ] pag_vars = get_pagination_vars(request, sort_col_field_list, default_sort_field='send_date') from_date = '' to_date = '' status = 'all' smscampaign = '' form = SMSSearchForm(request.user, request.POST or None) action = 'tabs-1' kwargs = {} post_var_with_page = 0 if form.is_valid(): post_var_with_page = 1 field_list = ['start_date', 'end_date', 'status', 'smscampaign'] unset_session_var(request, field_list) from_date = getvar(request, 'from_date') to_date = getvar(request, 'to_date') start_date = ceil_strdate(str(from_date), 'start') end_date = ceil_strdate(str(to_date), 'end') converted_start_date = start_date.strftime('%Y-%m-%d') converted_end_date = end_date.strftime('%Y-%m-%d') request.session['session_start_date'] = converted_start_date request.session['session_end_date'] = converted_end_date status = getvar(request, 'status', setsession=True) smscampaign = getvar(request, 'smscampaign', setsession=True) if request.GET.get('page') or request.GET.get('sort_by'): post_var_with_page = 1 start_date = request.session.get('session_start_date') end_date = request.session.get('session_end_date') start_date = ceil_strdate(start_date, 'start') end_date = ceil_strdate(end_date, 'end') status = request.session.get('session_status') smscampaign = request.session.get('session_smscampaign') form = SMSSearchForm(request.user, initial={ 'from_date': start_date.strftime('%Y-%m-%d'), 'to_date': end_date.strftime('%Y-%m-%d'), 'status': status, 'smscampaign': smscampaign }) if post_var_with_page == 0: # default tday = datetime.utcnow().replace(tzinfo=utc) from_date = tday.strftime('%Y-%m-%d') to_date = tday.strftime('%Y-%m-%d') start_date = datetime(tday.year, tday.month, tday.day, 0, 0, 0, 0).replace(tzinfo=utc) end_date = datetime(tday.year, tday.month, tday.day, 23, 59, 59, 999999).replace(tzinfo=utc) status = 'all' smscampaign = '' form = SMSSearchForm(request.user, initial={ 'from_date': from_date, 'to_date': to_date, 'status': status, 'smscampaign': smscampaign }) # unset session var request.session['session_start_date'] = start_date request.session['session_end_date'] = end_date request.session['session_status'] = status request.session['session_smscampaign'] = smscampaign kwargs['sender'] = request.user if start_date and end_date: kwargs['send_date__range'] = (start_date, end_date) if start_date and end_date == '': kwargs['send_date__gte'] = start_date if start_date == '' and end_date: kwargs['send_date__lte'] = end_date if status and status != 'all': kwargs['status__exact'] = status if smscampaign and smscampaign != '0': kwargs['sms_campaign_id'] = smscampaign smslist = SMSMessage.objects.filter(**kwargs) all_sms_list = smslist.values_list('id', flat=True) sms_list = smslist.order_by( pag_vars['sort_order'])[pag_vars['start_page']:pag_vars['end_page']] # Session variable is used to get record set with searched option # into export file request.session['sms_record_kwargs'] = kwargs select_data = {"send_date": "SUBSTR(CAST(send_date as CHAR(30)),1,10)"} # Get Total Rrecords from SMSMessage Report table for Daily SMS Report total_data = all_sms_list.extra(select=select_data).values('send_date')\ .annotate(Count('send_date')).order_by('-send_date') # Following code will count total sms if total_data.count() != 0: total_sms = sum([x['send_date__count'] for x in total_data]) else: total_sms = 0 data = { 'form': form, 'from_date': from_date, 'all_sms_list': all_sms_list, 'sms_list': sms_list, 'sms_count': all_sms_list.count() if all_sms_list else 0, 'SMS_REPORT_COLUMN_NAME': SMS_REPORT_COLUMN_NAME, 'col_name_with_order': pag_vars['col_name_with_order'], 'start_date': start_date, 'end_date': end_date, 'to_date': to_date, 'action': action, 'status': status, 'total_data': total_data.reverse(), 'total_sms': total_sms, } return render_to_response('mod_sms/sms_report.html', data, context_instance=RequestContext(request))