def voipcall_record_common_fun(request):
"""Return Form with Initial data or Array (kwargs) for Voipcall_Report
Changelist_view"""
start_date = ''
end_date = ''
if request.POST.get('from_date'):
from_date = request.POST.get('from_date')
start_date = ceil_strdate(from_date, 'start')
if request.POST.get('to_date'):
to_date = request.POST.get('to_date')
end_date = ceil_strdate(to_date, 'end')
# Assign form field value to local variable
disposition = variable_value(request, 'status')
campaign_id = variable_value(request, 'campaign_id')
leg_type = variable_value(request, '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 campaign_id != '0':
kwargs['callrequest__campaign_id'] = campaign_id
if leg_type and leg_type != '':
kwargs['leg_type__exact'] = leg_type
if len(kwargs) == 0:
tday = datetime.today()
kwargs['starting_date__gte'] = datetime(tday.year,
tday.month,
tday.day, 0, 0, 0, 0)
kwargs['starting_date__lte'] = datetime(tday.year,
tday.month,
tday.day, 23, 59, 59)
return kwargs
def voipcall_record_common_fun(request):
"""Return Form with Initial data or Array (kwargs) for Voipcall_Report
Changelist_view"""
start_date = ''
end_date = ''
if request.POST.get('from_date'):
from_date = request.POST.get('from_date')
start_date = ceil_strdate(from_date, 'start')
if request.POST.get('to_date'):
to_date = request.POST.get('to_date')
end_date = ceil_strdate(to_date, 'end')
# Assign form field value to local variable
disposition = variable_value(request, 'status')
campaign_id = variable_value(request, 'campaign_id')
leg_type = variable_value(request, '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 campaign_id != '0':
kwargs['callrequest__campaign_id'] = campaign_id
if leg_type and leg_type != '':
kwargs['leg_type__exact'] = leg_type
if len(kwargs) == 0:
tday = datetime.today()
kwargs['starting_date__gte'] = datetime(tday.year, tday.month,
tday.day, 0, 0, 0, 0)
kwargs['starting_date__lte'] = datetime(tday.year, tday.month,
tday.day, 23, 59, 59)
return kwargs
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(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 request.method == 'POST':
form = SubscriberReportForm(request.POST)
if form.is_valid():
start_date = ''
end_date = ''
if request.POST.get('from_date'):
from_date = request.POST.get('from_date')
start_date = ceil_strdate(from_date, 'start')
if request.POST.get('to_date'):
to_date = request.POST.get('to_date')
end_date = ceil_strdate(to_date, 'end')
campaign_id = variable_value(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 survey_report(request):
"""
Survey detail report for the logged in user
**Attributes**:
* ``template`` - frontend/survey/survey_report.html
**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,
initial={
'from_date': from_date,
'to_date': to_date
})
search_tag = 1
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'
]
default_sort_field = 'starting_date'
pagination_data =\
get_pagination_vars(request, sort_col_field_list, default_sort_field)
PAGE_SIZE = pagination_data['PAGE_SIZE']
sort_order = pagination_data['sort_order']
start_page = pagination_data['start_page']
end_page = pagination_data['end_page']
campaign_obj = ''
action = 'tabs-1'
if request.method == 'POST':
#search_tag = 1
form = SurveyDetailReportForm(request.user, request.POST)
if form.is_valid():
# set session var value
request.session['session_from_date'] = ''
request.session['session_to_date'] = ''
request.session['session_campaign_id'] = ''
request.session['session_surveycalls_kwargs'] = ''
request.session['session_survey_cdr_daily_data'] = {}
if "from_date" in request.POST:
# From
from_date = request.POST['from_date']
request.session['session_from_date'] = from_date
if "to_date" in request.POST:
# To
to_date = request.POST['to_date']
request.session['session_to_date'] = to_date
campaign_id = variable_value(request, 'campaign')
if campaign_id:
request.session['session_campaign_id'] = campaign_id
else:
rows = []
campaign_id = ''
try:
if request.GET.get('page') or request.GET.get('sort_by'):
from_date = request.session.get('session_from_date')
to_date = request.session.get('session_to_date')
campaign_id = request.session.get('session_campaign_id')
search_tag = request.session.get('session_search_tag')
else:
from_date
except NameError:
tday = datetime.today()
from_date = tday.strftime('%Y-%m-01')
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)
search_tag = 0
# unset session var value
request.session['session_from_date'] = from_date
request.session['session_to_date'] = to_date
request.session['session_campaign_id'] = ''
request.session['session_surveycalls_kwargs'] = ''
request.session['session_search_tag'] = search_tag
start_date = ceil_strdate(from_date, 'start')
end_date = ceil_strdate(to_date, 'end')
kwargs = {}
if not request.user.is_superuser:
kwargs['user'] = request.user
kwargs['disposition__exact'] = VOIPCALL_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:
campaign_obj = Campaign.objects.get(id=int(campaign_id))
survey_result_kwargs['campaign'] = campaign_obj
survey_result = get_survey_result(survey_result_kwargs)
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(sort_order)[start_page:end_page]
except:
rows = []
if request.method == 'POST':
request.session["err_msg"] = _('no campaign attached with survey.')
template = 'frontend/survey/survey_report.html'
data = {
'rows': rows,
'all_call_list': all_call_list,
'call_count': all_call_list.count() if all_call_list else 0,
'PAGE_SIZE': PAGE_SIZE,
'SURVEY_CALL_RESULT_NAME': SURVEY_CALL_RESULT_NAME,
'col_name_with_order': pagination_data['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'],
'module': current_view(request),
'msg': request.session.get('msg'),
'err_msg': request.session.get('err_msg'),
'form': form,
'survey_result': survey_result,
'action': action,
'search_tag': search_tag,
'start_date': start_date,
'end_date': end_date,
'campaign_obj': campaign_obj,
}
request.session['msg'] = ''
request.session['err_msg'] = ''
return render_to_response(template,
data,
context_instance=RequestContext(request))
def subscriber_list(request):
"""Subscriber list for the logged in user
**Attributes**:
* ``template`` - frontend/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",
]
default_sort_field = "id"
pagination_data = get_pagination_vars(request, sort_col_field_list, default_sort_field)
PAGE_SIZE = pagination_data["PAGE_SIZE"]
sort_order = pagination_data["sort_order"]
start_page = pagination_data["start_page"]
end_page = pagination_data["end_page"]
form = SubscriberSearchForm(request.user)
search_tag = 1
campaign_id = ""
agent_id = ""
status = "all"
if request.method == "POST":
form = SubscriberSearchForm(request.user, request.POST)
if form.is_valid():
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)
if request.POST.get("from_date"):
# From
from_date = request.POST["from_date"]
start_date = ceil_strdate(from_date, "start")
request.session["session_start_date"] = start_date
if request.POST.get("to_date"):
# To
to_date = request.POST["to_date"]
end_date = ceil_strdate(to_date, "end")
request.session["session_end_date"] = end_date
status = request.POST.get("status")
if status != "all":
request.session["session_status"] = status
post_var_with_page = 0
try:
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")
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,
},
)
else:
post_var_with_page = 1
if request.method == "GET":
post_var_with_page = 0
except:
pass
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
# if contact_name:
# # Search on contact name
# q = (Q(last_name__icontains=contact_name) |
# Q(first_name__icontains=contact_name))
# if q:
# contact_list = contact_list.filter(q)
all_subscriber_list = subscriber_list.order_by(sort_order)
subscriber_list = all_subscriber_list[start_page:end_page]
subscriber_count = all_subscriber_list.count()
template = "frontend/subscriber/list.html"
data = {
"subscriber_list": subscriber_list,
"all_subscriber_list": all_subscriber_list,
"total_subscribers": subscriber_count,
"PAGE_SIZE": PAGE_SIZE,
"SUBSCRIBER_COLUMN_NAME": SUBSCRIBER_COLUMN_NAME,
"col_name_with_order": pagination_data["col_name_with_order"],
"msg": request.session.get("msg"),
"error_msg": request.session.get("error_msg"),
"form": form,
"dialer_setting_msg": user_dialer_setting_msg(request.user),
"search_tag": search_tag,
}
request.session["msg"] = ""
request.session["error_msg"] = ""
return render_to_response(template, data, context_instance=RequestContext(request))
def voipcall_report(request):
"""VoIP Call Report
**Attributes**:
* ``form`` - VoipSearchForm
* ``template`` - frontend/report/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']
default_sort_field = 'starting_date'
pagination_data =\
get_pagination_vars(request, sort_col_field_list, default_sort_field)
PAGE_SIZE = pagination_data['PAGE_SIZE']
sort_order = pagination_data['sort_order']
start_page = pagination_data['start_page']
end_page = pagination_data['end_page']
search_tag = 1
action = 'tabs-1'
if request.method == 'POST':
form = VoipSearchForm(request.user, request.POST)
if form.is_valid():
field_list = ['start_date', 'end_date',
'disposition', 'campaign_id']
unset_session_var(request, field_list)
if request.POST.get('from_date'):
# From
from_date = request.POST['from_date']
start_date = ceil_strdate(from_date, 'start')
request.session['session_start_date'] = start_date
if request.POST.get('to_date'):
# To
to_date = request.POST['to_date']
end_date = ceil_strdate(to_date, 'end')
request.session['session_end_date'] = end_date
disposition = request.POST.get('status')
if disposition != 'all':
request.session['session_disposition'] = disposition
campaign_id = request.POST.get('campaign_id')
if campaign_id and int(campaign_id) != 0:
request.session['session_campaign_id'] = int(campaign_id)
post_var_with_page = 0
try:
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')
disposition = request.session.get('session_disposition')
campaign_id = request.session.get('session_campaign_id')
form = VoipSearchForm(request.user,
initial={'from_date': start_date.strftime('%Y-%m-%d'),
'to_date': end_date.strftime('%Y-%m-%d'),
'status': disposition,
'campaign_id': campaign_id})
else:
post_var_with_page = 1
if request.method == 'GET':
post_var_with_page = 0
except:
pass
if post_var_with_page == 0:
# default
tday = datetime.today()
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)
end_date = datetime(tday.year, tday.month, tday.day, 23, 59, 59, 999999)
disposition = 'all'
campaign_id = 0
form = VoipSearchForm(request.user,
initial={'from_date': from_date, 'to_date': to_date,
'status': disposition, 'campaign_id': campaign_id})
# 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'] = ''
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 not request.user.is_superuser:
kwargs['user'] = request.user
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(sort_order)[start_page:end_page]
template = 'frontend/report/voipcall_report.html'
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'],
'module': current_view(request),
'dialer_setting_msg': user_dialer_setting_msg(request.user),
'all_voipcall_list': all_voipcall_list,
'voipcall_list': voipcall_list,
'PAGE_SIZE': PAGE_SIZE,
'CDR_REPORT_COLUMN_NAME': CDR_REPORT_COLUMN_NAME,
'col_name_with_order': pagination_data['col_name_with_order'],
'search_tag': search_tag,
'start_date': start_date,
'end_date': end_date,
'action': action,
'AMD': settings.AMD,
}
request.session['msg'] = ''
request.session['error_msg'] = ''
return render_to_response(template, data,
context_instance=RequestContext(request))
def survey_report(request):
"""
Survey detail report for the logged in user
**Attributes**:
* ``template`` - frontend/survey/survey_report.html
**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,
initial={'from_date': from_date,
'to_date': to_date})
search_tag = 1
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']
default_sort_field = 'starting_date'
pagination_data =\
get_pagination_vars(request, sort_col_field_list, default_sort_field)
PAGE_SIZE = pagination_data['PAGE_SIZE']
sort_order = pagination_data['sort_order']
start_page = pagination_data['start_page']
end_page = pagination_data['end_page']
campaign_obj = ''
action = 'tabs-1'
if request.method == 'POST':
#search_tag = 1
form = SurveyDetailReportForm(request.user, request.POST)
if form.is_valid():
# set session var value
request.session['session_from_date'] = ''
request.session['session_to_date'] = ''
request.session['session_campaign_id'] = ''
request.session['session_surveycalls_kwargs'] = ''
request.session['session_survey_cdr_daily_data'] = {}
if "from_date" in request.POST:
# From
from_date = request.POST['from_date']
request.session['session_from_date'] = from_date
if "to_date" in request.POST:
# To
to_date = request.POST['to_date']
request.session['session_to_date'] = to_date
campaign_id = variable_value(request, 'campaign')
if campaign_id:
request.session['session_campaign_id'] = campaign_id
else:
rows = []
campaign_id = ''
try:
if request.GET.get('page') or request.GET.get('sort_by'):
from_date = request.session.get('session_from_date')
to_date = request.session.get('session_to_date')
campaign_id = request.session.get('session_campaign_id')
search_tag = request.session.get('session_search_tag')
else:
from_date
except NameError:
tday = datetime.today()
from_date = tday.strftime('%Y-%m-01')
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)
search_tag = 0
# unset session var value
request.session['session_from_date'] = from_date
request.session['session_to_date'] = to_date
request.session['session_campaign_id'] = ''
request.session['session_surveycalls_kwargs'] = ''
request.session['session_search_tag'] = search_tag
start_date = ceil_strdate(from_date, 'start')
end_date = ceil_strdate(to_date, 'end')
kwargs = {}
if not request.user.is_superuser:
kwargs['user'] = request.user
kwargs['disposition__exact'] = VOIPCALL_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:
campaign_obj = Campaign.objects.get(id=int(campaign_id))
survey_result_kwargs['campaign'] = campaign_obj
survey_result = get_survey_result(survey_result_kwargs)
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(sort_order)[start_page:end_page]
except:
rows = []
if request.method == 'POST':
request.session["err_msg"] = _('no campaign attached with survey.')
template = 'frontend/survey/survey_report.html'
data = {
'rows': rows,
'all_call_list': all_call_list,
'call_count': all_call_list.count() if all_call_list else 0,
'PAGE_SIZE': PAGE_SIZE,
'SURVEY_CALL_RESULT_NAME': SURVEY_CALL_RESULT_NAME,
'col_name_with_order': pagination_data['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'],
'module': current_view(request),
'msg': request.session.get('msg'),
'err_msg': request.session.get('err_msg'),
'form': form,
'survey_result': survey_result,
'action': action,
'search_tag': search_tag,
'start_date': start_date,
'end_date': end_date,
'campaign_obj': campaign_obj,
}
request.session['msg'] = ''
request.session['err_msg'] = ''
return render_to_response(template, data,
context_instance=RequestContext(request))
def voipcall_report(request):
"""VoIP Call Report
**Attributes**:
* ``form`` - VoipSearchForm
* ``template`` - frontend/report/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']
default_sort_field = 'starting_date'
pagination_data =\
get_pagination_vars(request, sort_col_field_list, default_sort_field)
PAGE_SIZE = pagination_data['PAGE_SIZE']
sort_order = pagination_data['sort_order']
start_page = pagination_data['start_page']
end_page = pagination_data['end_page']
search_tag = 1
action = 'tabs-1'
if request.method == 'POST':
form = VoipSearchForm(request.user, request.POST)
if form.is_valid():
field_list = ['start_date', 'end_date',
'disposition', 'campaign_id', 'leg_type']
unset_session_var(request, field_list)
if request.POST.get('from_date'):
# From
from_date = request.POST['from_date']
start_date = ceil_strdate(from_date, 'start')
request.session['session_start_date'] = start_date
if request.POST.get('to_date'):
# To
to_date = request.POST['to_date']
end_date = ceil_strdate(to_date, 'end')
request.session['session_end_date'] = end_date
disposition = request.POST.get('status')
if disposition != 'all':
request.session['session_disposition'] = disposition
campaign_id = request.POST.get('campaign_id')
if campaign_id and int(campaign_id) != 0:
request.session['session_campaign_id'] = int(campaign_id)
leg_type = request.POST.get('leg_type')
if leg_type and leg_type != '':
request.session['session_leg_type'] = leg_type
post_var_with_page = 0
try:
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')
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'),
'status': disposition,
'campaign_id': campaign_id,
'leg_type': leg_type})
else:
post_var_with_page = 1
if request.method == 'GET':
post_var_with_page = 0
except:
pass
if post_var_with_page == 0:
# default
tday = datetime.today()
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)
end_date = datetime(tday.year, tday.month, tday.day, 23, 59, 59, 999999)
disposition = 'all'
campaign_id = 0
leg_type = ''
form = VoipSearchForm(request.user,
initial={'from_date': from_date,
'to_date': to_date,
'status': 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'] = request.user
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(sort_order)[start_page:end_page]
template = 'frontend/report/voipcall_report.html'
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'],
'module': current_view(request),
'dialer_setting_msg': user_dialer_setting_msg(request.user),
'all_voipcall_list': all_voipcall_list,
'voipcall_list': voipcall_list,
'PAGE_SIZE': PAGE_SIZE,
'CDR_REPORT_COLUMN_NAME': CDR_REPORT_COLUMN_NAME,
'col_name_with_order': pagination_data['col_name_with_order'],
'search_tag': search_tag,
'start_date': start_date,
'end_date': end_date,
'action': action,
'AMD': settings.AMD,
}
request.session['msg'] = ''
request.session['error_msg'] = ''
return render_to_response(template, data,
context_instance=RequestContext(request))
def sms_report(request):
"""SMS Report
**Attributes**:
* ``form`` - SMSSearchForm
* ``template`` - frontend/sms_campaign/sms_report.html
**Logic Description**:
* Get SMS list according to search parameters for logged-in user
**Important variable**:
* ``request.session['sms_record_qs']`` - stores sms query set
"""
sort_col_field_list = ['send_date', 'recipient_number', 'uuid',
'status', 'status_message', 'gateway']
default_sort_field = 'send_date'
pagination_data = get_pagination_vars(
request, sort_col_field_list, default_sort_field)
PAGE_SIZE = pagination_data['PAGE_SIZE']
sort_order = pagination_data['sort_order']
start_page = pagination_data['start_page']
end_page = pagination_data['end_page']
from_date = ''
to_date = ''
status = 'all'
smscampaign = ''
form = SMSSearchForm(request.user)
search_tag = 1
action = 'tabs-1'
kwargs = {}
if request.method == 'POST':
form = SMSSearchForm(request.user, request.POST)
if form.is_valid():
request.session['session_start_date'] = ''
request.session['session_end_date'] = ''
request.session['session_status'] = ''
request.session['session_smscampaign'] = ''
if request.POST.get('from_date'):
# From
from_date = request.POST['from_date']
start_date = ceil_strdate(from_date, 'start')
request.session['session_start_date'] = start_date
if request.POST.get('to_date'):
# To
to_date = request.POST['to_date']
end_date = ceil_strdate(to_date, 'end')
request.session['session_end_date'] = end_date
status = request.POST.get('status')
if status != 'all':
request.session['session_status'] = status
smscampaign = request.POST.get('smscampaign')
if smscampaign != '0':
request.session['session_smscampaign'] = smscampaign
post_var_with_page = 0
try:
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')
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})
else:
post_var_with_page = 1
if request.method == 'GET':
post_var_with_page = 0
except:
pass
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(sort_order)[start_page:end_page]
# Session variable is used to get record set with searched option
# into export file
request.session['sms_record_qs'] = smslist
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
template = 'frontend/sms_campaign/sms_report.html'
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,
'PAGE_SIZE': PAGE_SIZE,
'col_name_with_order': pagination_data['col_name_with_order'],
'start_date': start_date,
'end_date': end_date,
'to_date': to_date,
'search_tag': search_tag,
'action': action,
'status': status,
'total_data': total_data.reverse(),
'total_sms': total_sms,
'dialer_setting_msg': user_dialer_setting_msg(request.user),
}
return render_to_response(
template, data, context_instance=RequestContext(request))
def event_list(request):
"""Event list for the logged in user
**Attributes**:
* ``template`` - frontend/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,
initial={'start': today.strftime('%Y-%m-%d %H:%M:%S')})
sort_col_field_list = ['id', 'start', 'end', 'title',
'calendar', 'status', 'created_on']
default_sort_field = 'id'
pagination_data = get_pagination_vars(
request, sort_col_field_list, default_sort_field)
PAGE_SIZE = pagination_data['PAGE_SIZE']
sort_order = pagination_data['sort_order']
start_page = pagination_data['start_page']
end_page = pagination_data['end_page']
#search_tag = 1
start_date = ''
calendar_id = ''
calendar_user_id = ''
if request.method == 'POST':
form = EventSearchForm(request.user, request.POST)
if form.is_valid():
field_list = ['start_date', 'calendar_id', 'calendar_user_id']
unset_session_var(request, field_list)
if request.POST.get('start_date'):
# start date
start_date = ceil_strdate(request.POST['start_date'], 'start')
request.session['session_start_date'] = start_date
calendar_id = getvar(request, 'calendar_id', setsession=True)
calendar_user_id = getvar(request, 'calendar_user_id', setsession=True)
post_var_with_page = 0
try:
if request.GET.get('page') or request.GET.get('sort_by'):
post_var_with_page = 1
start_date = request.session.get('session_start_date')
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,
'calendar_id': calendar_id,
'calendar_user_id': calendar_user_id,
})
else:
post_var_with_page = 1
if request.method == 'GET':
post_var_with_page = 0
except:
pass
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 = {}
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
calendar_user_id_list = get_calendar_user_id_list(request.user)
event_list = Event.objects.filter(
calendar__user_id__in=calendar_user_id_list).order_by(sort_order)
if kwargs:
event_list = event_list.filter(**kwargs)
event_list = event_list[start_page:end_page]
template = 'frontend/appointment/event/list.html'
data = {
'form': form,
'msg': request.session.get('msg'),
'event_list': event_list,
'total_event': event_list.count(),
'PAGE_SIZE': PAGE_SIZE,
'EVENT_COLUMN_NAME': EVENT_COLUMN_NAME,
'col_name_with_order': pagination_data['col_name_with_order'],
'dialer_setting_msg': user_dialer_setting_msg(request.user),
}
request.session['msg'] = ''
request.session['error_msg'] = ''
return render_to_response(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(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 request.method == 'POST':
form = SubscriberReportForm(request.POST)
if form.is_valid():
start_date = ''
end_date = ''
if request.POST.get('from_date'):
from_date = request.POST.get('from_date')
start_date = ceil_strdate(from_date, 'start')
if request.POST.get('to_date'):
to_date = request.POST.get('to_date')
end_date = ceil_strdate(to_date, 'end')
campaign_id = variable_value(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 survey_report(request):
"""
Survey detail report for the logged in user
**Attributes**:
* ``template`` - frontend/survey/survey_report.html
**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, initial={"from_date": from_date, "to_date": to_date})
search_tag = 1
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"]
default_sort_field = "starting_date"
pagination_data = get_pagination_vars(request, sort_col_field_list, default_sort_field)
PAGE_SIZE = pagination_data["PAGE_SIZE"]
sort_order = pagination_data["sort_order"]
start_page = pagination_data["start_page"]
end_page = pagination_data["end_page"]
survey_id = ""
action = "tabs-1"
campaign_obj = ""
if request.method == "POST":
# search_tag = 1
form = SurveyDetailReportForm(request.user, request.POST)
if form.is_valid():
# set session var value
request.session["session_from_date"] = ""
request.session["session_to_date"] = ""
request.session["session_survey_id"] = ""
request.session["session_surveycalls_kwargs"] = ""
request.session["session_survey_cdr_daily_data"] = {}
if "from_date" in request.POST:
# From
from_date = request.POST["from_date"]
request.session["session_from_date"] = from_date
if "to_date" in request.POST:
# To
to_date = request.POST["to_date"]
request.session["session_to_date"] = to_date
survey_id = variable_value(request, "survey_id")
if survey_id:
request.session["session_survey_id"] = survey_id
else:
rows = []
survey_id = ""
try:
if request.GET.get("page") or request.GET.get("sort_by"):
from_date = request.session.get("session_from_date")
to_date = request.session.get("session_to_date")
survey_id = request.session.get("session_survey_id")
search_tag = request.session.get("session_search_tag")
else:
from_date
except NameError:
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)
search_tag = 0
# 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"] = ""
request.session["session_search_tag"] = search_tag
start_date = ceil_strdate(from_date, "start")
end_date = ceil_strdate(to_date, "end")
kwargs = {}
if not request.user.is_superuser:
kwargs["user"] = request.user
kwargs["disposition__exact"] = VOIPCALL_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(sort_order)[start_page:end_page]
except:
rows = []
if request.method == "POST":
request.session["err_msg"] = _("no campaign attached with survey.")
template = "frontend/survey/survey_report.html"
data = {
"rows": rows,
"all_call_list": all_call_list,
"call_count": all_call_list.count() if all_call_list else 0,
"PAGE_SIZE": PAGE_SIZE,
"SURVEY_CALL_RESULT_NAME": SURVEY_CALL_RESULT_NAME,
"col_name_with_order": pagination_data["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,
"search_tag": search_tag,
"start_date": start_date,
"end_date": end_date,
"campaign_obj": campaign_obj,
}
request.session["msg"] = ""
request.session["err_msg"] = ""
return render_to_response(template, data, context_instance=RequestContext(request))
