def sms_daily_report(self, request):
opts = SMSMessage._meta
kwargs = {}
form = AdminSMSSearchForm(request.POST or None)
if form.is_valid():
kwargs = sms_record_common_fun(request)
request.session["from_date"] = request.POST.get("from_date")
request.session["to_date"] = request.POST.get("to_date")
request.session["status"] = request.POST.get("status")
request.session["smscampaign"] = request.POST.get("smscampaign")
else:
kwargs = sms_record_common_fun(request)
tday = datetime.utcnow().replace(tzinfo=utc)
if len(kwargs) == 0:
kwargs["send_date__gte"] = datetime(tday.year, tday.month, tday.day, 0, 0, 0, 0).replace(tzinfo=utc)
select_data = {"send_date": "SUBSTR(CAST(send_date as CHAR(30)),1,10)"}
# Get Total Records from VoIPCall Report table for Daily Call Report
total_data = (
SMSMessage.objects.extra(select=select_data)
.values("send_date")
.filter(**kwargs)
.annotate(Count("send_date"))
.order_by("-send_date")
)
# Following code will count total sms calls, duration
if total_data.count() != 0:
total_sms = sum([x["send_date__count"] for x in total_data])
else:
total_sms = 0
ctx = RequestContext(
request,
{
"form": form,
"total_data": total_data.reverse(),
"total_sms": total_sms,
"opts": opts,
"model_name": opts.object_name.lower(),
"app_label": _("SMS module"),
"title": _("SMS aggregate report"),
},
)
return render_to_response("admin/mod_sms/smsmessage/sms_report.html", context_instance=ctx)
def sms_daily_report(self, request):
opts = SMSMessage._meta
kwargs = {}
form = AdminSMSSearchForm(request.POST or None)
if form.is_valid():
kwargs = sms_record_common_fun(request)
request.session['from_date'] = request.POST.get('from_date')
request.session['to_date'] = request.POST.get('to_date')
request.session['status'] = request.POST.get('status')
request.session['smscampaign'] = request.POST.get('smscampaign')
else:
kwargs = sms_record_common_fun(request)
tday = datetime.utcnow().replace(tzinfo=utc)
if len(kwargs) == 0:
kwargs['send_date__gte'] = datetime(tday.year, tday.month,
tday.day, 0, 0, 0,
0).replace(tzinfo=utc)
select_data = {"send_date": "SUBSTR(CAST(send_date as CHAR(30)),1,10)"}
# Get Total Records from VoIPCall Report table for Daily Call Report
total_data = SMSMessage.objects.extra(select=select_data)\
.values('send_date').filter(**kwargs).annotate(Count('send_date'))\
.order_by('-send_date')
# Following code will count total sms calls, duration
if total_data.count() != 0:
total_sms = sum([x['send_date__count'] for x in total_data])
else:
total_sms = 0
ctx = RequestContext(
request, {
'form': form,
'total_data': total_data.reverse(),
'total_sms': total_sms,
'opts': opts,
'model_name': opts.object_name.lower(),
'app_label': _('SMS module'),
'title': _('SMS aggregate report'),
})
return render_to_response('admin/mod_sms/smsmessage/sms_report.html',
context_instance=ctx)
def sms_daily_report(self, request):
opts = SMSMessage._meta
kwargs = {}
form = AdminSMSSearchForm(request.POST or None)
if form.is_valid():
kwargs = sms_record_common_fun(request)
request.session['from_date'] = request.POST.get('from_date')
request.session['to_date'] = request.POST.get('to_date')
request.session['status'] = request.POST.get('status')
request.session['smscampaign'] = request.POST.get('smscampaign')
else:
kwargs = sms_record_common_fun(request)
tday = datetime.utcnow().replace(tzinfo=utc)
if len(kwargs) == 0:
kwargs['send_date__gte'] = datetime(tday.year, tday.month, tday.day,
0, 0, 0, 0).replace(tzinfo=utc)
select_data = {"send_date": "SUBSTR(CAST(send_date as CHAR(30)),1,10)"}
# Get Total Records from VoIPCall Report table for Daily Call Report
total_data = SMSMessage.objects.extra(select=select_data)\
.values('send_date').filter(**kwargs).annotate(Count('send_date'))\
.order_by('-send_date')
# Following code will count total sms calls, duration
if total_data.count() != 0:
total_sms = sum([x['send_date__count'] for x in total_data])
else:
total_sms = 0
ctx = RequestContext(request, {
'form': form,
'total_data': total_data.reverse(),
'total_sms': total_sms,
'opts': opts,
'model_name': opts.object_name.lower(),
'app_label': _('SMS module'),
'title': _('SMS aggregate report'),
})
return render_to_response('admin/mod_sms/smsmessage/sms_report.html', context_instance=ctx)
def changelist_view(self, request, extra_context=None):
"""Override changelist_view method of django-admin for search parameters
**Attributes**:
* ``form`` - AdminSMSSearchForm
* ``template`` - admin/mod_sms/smsmessage/sms_report.html
**Logic Description**:
* SMSMessage report Record Listing with search option
search Parameters: by date, by status and by billed.
"""
opts = SMSMessage._meta
query_string = ''
form = AdminSMSSearchForm(request.POST or None)
if form.is_valid():
query_string = sms_search_admin_form_fun(request)
return HttpResponseRedirect("/admin/" + opts.app_label + "/" +
opts.object_name.lower() + "/?" +
query_string)
else:
status = ''
from_date = ''
to_date = ''
smscampaign = ''
if request.GET.get('send_date__gte'):
from_date = variable_value(request, 'send_date__gte')
if request.GET.get('send_date__lte'):
to_date = variable_value(request, 'send_date__lte')[0:10]
if request.GET.get('status__exact'):
status = variable_value(request, 'status__exact')
if request.GET.get('sms_campaign'):
smscampaign = variable_value(request, 'sms_campaign')
form = AdminSMSSearchForm(
initial={
'status': status,
'from_date': from_date,
'to_date': to_date,
'smscampaign': smscampaign
})
ChangeList = self.get_changelist(request)
try:
cl = ChangeList(request, self.model, self.list_display,
self.list_display_links, self.list_filter,
self.date_hierarchy, self.search_fields,
self.list_select_related, self.list_per_page,
self.list_max_show_all, self.list_editable, self)
except IncorrectLookupParameters:
if ERROR_FLAG in request.GET.keys():
return render_to_response('admin/invalid_setup.html',
{'title': _('Database error')})
return HttpResponseRedirect(request.path + '?' + ERROR_FLAG + '=1')
kwargs = {}
if request.META['QUERY_STRING'] == '':
tday = datetime.utcnow().replace(tzinfo=utc)
kwargs['send_date__gte'] = datetime(tday.year, tday.month,
tday.day, 0, 0, 0,
0).replace(tzinfo=utc)
cl.root_query_set.filter(**kwargs)
cl.formset = None
# Session variable is used to get record set with searched option into export file
request.session['admin_sms_record_qs'] = cl.root_query_set
selection_note_all = ungettext('%(total_count)s selected',
'All %(total_count)s selected',
cl.result_count)
ctx = {
'selection_note': _('0 of %(cnt)s selected') % {
'cnt': len(cl.result_list)
},
'selection_note_all': selection_note_all % {
'total_count': cl.result_count
},
'cl': cl,
'form': form,
'opts': opts,
'model_name': opts.object_name.lower(),
'app_label': _('SMS module'),
'title': _('SMS report'),
}
return super(SMSMessageAdmin, self).changelist_view(request,
extra_context=ctx)
def changelist_view(self, request, extra_context=None):
"""Override changelist_view method of django-admin for search parameters
**Attributes**:
* ``form`` - AdminSMSSearchForm
* ``template`` - admin/mod_sms/smsmessage/sms_report.html
**Logic Description**:
* SMSMessage report Record Listing with search option
search Parameters: by date, by status and by billed.
"""
opts = SMSMessage._meta
query_string = ""
form = AdminSMSSearchForm(request.POST or None)
if form.is_valid():
query_string = sms_search_admin_form_fun(request)
return HttpResponseRedirect(
"/admin/" + opts.app_label + "/" + opts.object_name.lower() + "/?" + query_string
)
else:
status = ""
from_date = ""
to_date = ""
smscampaign = ""
if request.GET.get("send_date__gte"):
from_date = variable_value(request, "send_date__gte")
if request.GET.get("send_date__lte"):
to_date = variable_value(request, "send_date__lte")[0:10]
if request.GET.get("status__exact"):
status = variable_value(request, "status__exact")
if request.GET.get("sms_campaign"):
smscampaign = variable_value(request, "sms_campaign")
form = AdminSMSSearchForm(
initial={"status": status, "from_date": from_date, "to_date": to_date, "smscampaign": smscampaign}
)
ChangeList = self.get_changelist(request)
try:
cl = ChangeList(
request,
self.model,
self.list_display,
self.list_display_links,
self.list_filter,
self.date_hierarchy,
self.search_fields,
self.list_select_related,
self.list_per_page,
self.list_max_show_all,
self.list_editable,
self,
)
except IncorrectLookupParameters:
if ERROR_FLAG in request.GET.keys():
return render_to_response("admin/invalid_setup.html", {"title": _("Database error")})
return HttpResponseRedirect(request.path + "?" + ERROR_FLAG + "=1")
kwargs = {}
if request.META["QUERY_STRING"] == "":
tday = datetime.utcnow().replace(tzinfo=utc)
kwargs["send_date__gte"] = datetime(tday.year, tday.month, tday.day, 0, 0, 0, 0).replace(tzinfo=utc)
cl.root_query_set.filter(**kwargs)
cl.formset = None
# Session variable is used to get record set with searched option into export file
request.session["admin_sms_record_qs"] = cl.root_query_set
selection_note_all = ungettext("%(total_count)s selected", "All %(total_count)s selected", cl.result_count)
ctx = {
"selection_note": _("0 of %(cnt)s selected") % {"cnt": len(cl.result_list)},
"selection_note_all": selection_note_all % {"total_count": cl.result_count},
"cl": cl,
"form": form,
"opts": opts,
"model_name": opts.object_name.lower(),
"app_label": _("SMS module"),
"title": _("SMS report"),
}
return super(SMSMessageAdmin, self).changelist_view(request, extra_context=ctx)
def changelist_view(self, request, extra_context=None):
"""Override changelist_view method of django-admin for search parameters
**Attributes**:
* ``form`` - AdminSMSSearchForm
* ``template`` - admin/mod_sms/smsmessage/sms_report.html
**Logic Description**:
* SMSMessage report Record Listing with search option
search Parameters: by date, by status and by billed.
"""
opts = SMSMessage._meta
query_string = ''
form = AdminSMSSearchForm(request.POST or None)
if form.is_valid():
query_string = sms_search_admin_form_fun(request)
return HttpResponseRedirect(
"/admin/" + opts.app_label + "/" + opts.object_name.lower() + "/?" + query_string)
else:
status = ''
from_date = ''
to_date = ''
smscampaign = ''
if request.GET.get('send_date__gte'):
from_date = variable_value(request, 'send_date__gte')
if request.GET.get('send_date__lte'):
to_date = variable_value(request, 'send_date__lte')[0:10]
if request.GET.get('status__exact'):
status = variable_value(request, 'status__exact')
if request.GET.get('sms_campaign'):
smscampaign = variable_value(request, 'sms_campaign')
form = AdminSMSSearchForm(initial={'status': status,
'from_date': from_date,
'to_date': to_date,
'smscampaign': smscampaign})
ChangeList = self.get_changelist(request)
try:
cl = ChangeList(request, self.model, self.list_display,
self.list_display_links, self.list_filter, self.date_hierarchy,
self.search_fields, self.list_select_related,
self.list_per_page, self.list_max_show_all, self.list_editable,
self)
except IncorrectLookupParameters:
if ERROR_FLAG in request.GET.keys():
return render_to_response('admin/invalid_setup.html',
{'title': _('Database error')})
return HttpResponseRedirect(request.path + '?' + ERROR_FLAG + '=1')
kwargs = {}
if request.META['QUERY_STRING'] == '':
tday = datetime.utcnow().replace(tzinfo=utc)
kwargs['send_date__gte'] = datetime(tday.year, tday.month, tday.day,
0, 0, 0, 0).replace(tzinfo=utc)
cl.root_query_set.filter(**kwargs)
cl.formset = None
# Session variable is used to get record set with searched option into export file
request.session['admin_sms_record_qs'] = cl.root_query_set
selection_note_all = ungettext('%(total_count)s selected',
'All %(total_count)s selected', cl.result_count)
ctx = {
'selection_note': _('0 of %(cnt)s selected') % {'cnt': len(cl.result_list)},
'selection_note_all': selection_note_all % {'total_count': cl.result_count},
'cl': cl,
'form': form,
'opts': opts,
'model_name': opts.object_name.lower(),
'app_label': _('SMS module'),
'title': _('SMS report'),
}
return super(SMSMessageAdmin, self).changelist_view(request, extra_context=ctx)