def _multi_record_export_as_zip_file(request):
"Esportazione multifile in formato zip"""
import os
import contextlib
import zipfile
d = request.GET.dict()
start_date = request.GET.get("start_date", "")
end_date = request.GET.get("end_date", "")
start_time = request.GET.get("start_time", "00:00")
end_time = request.GET.get("end_time", "23:59")
pincode = request.GET.get("pincode", "")
q_obj = Q(pincode__icontains=pincode)
if start_date != '':
start_date = Helper.convert_datestring_format(
start_date, "%d-%m-%Y", "%Y-%m-%d")
start_date = "%s %s:00" % (start_date, start_time)
q_obj.add(Q(calldate__gte=start_date), Q.AND)
if end_date != '':
end_date = Helper.convert_datestring_format(
end_date, "%d-%m-%Y", "%Y-%m-%d")
end_date = "%s %s:59" % (end_date, end_time)
q_obj.add(Q(calldate__lte=end_date), Q.AND)
items_list = Record.objects.filter(q_obj).order_by('-calldate')
filename = 'registrazioni'
if pincode != '':
phoneuser = PhoneUser.get_from_pincode(pincode)
filename = 'registrazioni %s' % phoneuser
zipname = "%s.zip" % filename
tmpzippath = os.path.join(settings.TMP_ZIP_ROOT, zipname)
file_counter = 0
with contextlib.closing(zipfile.ZipFile(tmpzippath, 'w')) as myzip:
for item in items_list:
detail = Detail.objects.get(uniqueid=item.uniqueid)
if detail.custom_valid and (detail.dcontext == 'cabs-dial-number' or detail.dcontext == 'outgoing-operator-dial-number' or detail.dcontext == 'incoming-operator-dial-number'):
file_counter += 1
path = os.path.join(settings.RECORDS_ROOT, item.filename)
myzip.write(path, arcname = item.filename)
if not file_counter:
return redirect("/records/?err=1&err_msg=Nessuno dei file soddisfa i criteri per l'esportazione&%s" % urlencode(d))
response = Helper.file_export(tmpzippath)
# logghiamo azione
audit = Audit()
audit.user_id = request.user.id
detail = Helper.get_filter_detail(d)
audit.what = "Esportazione registrazioni corrispondenti ai seguenti criteri: %s" \
% (detail)
audit.save()
return response
def _multi_record_remove(request):
import os
d = request.POST.dict()
start_date = request.POST.get("data[start_date]", "")
end_date = request.POST.get("data[end_date]", "")
start_time = request.POST.get("data[start_time]", "00:00")
end_time = request.POST.get("data[end_time]", "23:59")
dst = request.POST.get("data[dst]", "")
pincode = request.POST.get("data[pincode]", "")
q_obj = Q(pincode__icontains=pincode)
if start_date != '':
start_date = Helper.convert_datestring_format(
start_date, "%d-%m-%Y", "%Y-%m-%d")
start_date = "%s %s:00" % (start_date, start_time)
q_obj.add(Q(calldate__gte=start_date), Q.AND)
if end_date != '':
end_date = Helper.convert_datestring_format(
end_date, "%d-%m-%Y", "%Y-%m-%d")
end_date = "%s %s:59" % (end_date, end_time)
q_obj.add(Q(calldate__lte=end_date), Q.AND)
items_list = Record.objects.filter(q_obj).order_by('-calldate')
if dst != '':
filtered_item_list = []
for item in items_list:
try:
detail = Detail.objects.get(uniqueid=item.uniqueid)
if dst in detail.custom_dst:
filtered_item_list.append(item)
except:
pass
items_list = filtered_item_list
for item in items_list:
path = os.path.join(settings.RECORDS_ROOT, item.filename)
try:
os.remove(path)
item.delete()
# logghiamo azione
audit = Audit()
audit.user_id = request.user.id
detail = Helper.get_filter_detail(d)
audit.what = "Eliminazione registrazioni corrispondenti ai seguenti criteri: %s" \
% (detail)
audit.save()
except Exception as e:
return redirect("/records/?err=1&err_msg=ELiminazione registrazioni non avvenuta")
return redirect("/records/?ok=1&msg=ELiminazione registrazioni avvenuta con successo")
def phonecab_realtime(request):
"""Show current calls"""
import time
import datetime
variables = Acl.get_permissions_for_user(request.user.id, request.user.is_staff)
variables["actual_nightmode"] = Helper.get_nightmode()
return render_to_response("realtime.html", RequestContext(request, variables))
def _single_record_export(request, record_id="0"):
"""Esportazione singolo file"""
import os
record_id = int(record_id)
try:
record = Record.objects.get(pk=record_id)
except ObjectDoesNotExist:
pass
path = os.path.join(settings.RECORDS_ROOT, record.filename)
response = Helper.file_export(path)
# logghiamo azione
audit = Audit()
audit.user = request.user
audit.what = "L'utente %s ha scaricato il seguente file: %s" \
% (request.user.username, record.filename)
audit.save()
return response
def record_items(request):
"""Record Items"""
from urllib import urlencode
variables = {}
items_per_page = settings.ITEMS_PER_PAGE
start_date = request.GET.get("start_date", "")
end_date = request.GET.get("end_date", "")
start_time = request.GET.get("start_time", "00:00")
end_time = request.GET.get("end_time", "23:59")
pincode = request.GET.get("pincode", "")
dst = request.GET.get("dst", "")
page = int(request.GET.get("page", "1"))
d = request.GET.dict()
page = 1
if 'page' in d.keys():
page = int(d['page'])
# elimino la pagina dal dizionario
del d['page']
q_obj = Q(pincode__icontains=pincode)
if start_date != '':
start_date = Helper.convert_datestring_format(
start_date, "%d-%m-%Y", "%Y-%m-%d")
if start_time:
start_time = "%s:00" % start_time
else:
start_time = "00:00:00"
start_date = "%s %s" % (start_date, start_time)
q_obj.add(Q(calldate__gte=start_date), Q.AND)
if end_date != '':
end_date = Helper.convert_datestring_format(
end_date, "%d-%m-%Y", "%Y-%m-%d")
if end_time:
end_time = "%s:59" % end_time
else:
end_time = "23:59:59"
end_date = "%s %s" % (end_date, end_time)
q_obj.add(Q(calldate__lte=end_date), Q.AND)
items_list = Record.objects.filter(q_obj).order_by('-calldate')
if dst != '':
filtered_item_list = []
for item in items_list:
try:
detail = Detail.objects.get(uniqueid=item.uniqueid)
if dst in detail.custom_dst:
filtered_item_list.append(item)
except:
pass
items_list = filtered_item_list
#total_items = items_list.count()
total_items = len(items_list)
items, items_range, items_next_page = Helper.make_pagination(
items_list, page, items_per_page)
for item in items:
item.phoneuser = PhoneUser.get_from_pincode(item.pincode)
try:
details = Detail.objects.filter(uniqueid=item.uniqueid)
if not details:
item.detail = Detail
item.detail.custom_dst = ''
else:
item.detail = details[0]
src_name = Extension.get_extension_name(item.detail.custom_src)
if src_name:
item.detail.custom_src = "%s (%s)" % (src_name, item.detail.custom_src)
item.whitelist = Whitelist.objects.get(
phoneuser_id=item.phoneuser.id, phonenumber=item.detail.custom_dst)
except Exception as e:
return redirect("/records/?err=1&err_msg=Impossibile caricare la lista dei record")
if item.filename != '':
item.filename = "/recordings/%s" % item.filename
prev_page = page - 1
prev_page_disabled = ''
if prev_page < 1:
prev_page = 1
prev_page_disabled = 'disabled'
next_page = 1
next_page_disabled = ''
if items:
next_page = page + 1
if next_page > items.paginator.num_pages:
next_page = items.paginator.num_pages
next_page_disabled = 'disabled'
start_item = 1
if page > 0:
start_item = (page - 1) * items_per_page + 1
end_item = start_item + items_per_page - 1
if end_item > total_items:
end_item = total_items
variables['items'] = items
variables['total_items'] = total_items
variables['prev_page'] = prev_page
variables['next_page'] = next_page
variables['prev_page_disabled'] = prev_page_disabled
variables['next_page_disabled'] = next_page_disabled
variables['current_page'] = page
variables['start_item'] = start_item
variables['end_item'] = end_item
variables['d'] = d
variables['query_string'] = urlencode(d)
if request.is_ajax():
return render_to_response(
'records/table.html', RequestContext(request, variables))
return render_to_string(
'records/table.html', RequestContext(request, variables))
def profile_items(request):
"""Phoneuser Items Table"""
#variables = Acl.get_permissions_for_user(request.user.id, request.user.is_staff)
variables = {}
items_per_page = settings.ITEMS_PER_PAGE
keyword = request.GET.get("keyword", "")
page = int(request.GET.get("page", "1"))
d = request.GET.dict()
page = 1
if 'page' in d.keys():
page = int(d['page'])
# elimino la pagina dal dizionario
del d['page']
q_obj = Q(last_name__icontains=keyword)
q_obj.add(Q(username__icontains=keyword), Q.OR)
items_list = User.objects.filter(q_obj).order_by('last_name').exclude(is_superuser=True)
total_items = items_list.count()
items, items_range, items_next_page = Helper.make_pagination(
items_list, page, items_per_page)
prev_page = page - 1
prev_page_disabled = ''
if prev_page < 1:
prev_page = 1
prev_page_disabled = 'disabled'
next_page = 1
next_page_disabled = ''
if items:
next_page = page + 1
if next_page > items.paginator.num_pages:
next_page = items.paginator.num_pages
next_page_disabled = 'disabled'
start_item = 1
if page > 0:
start_item = (page - 1) * items_per_page + 1
end_item = start_item + items_per_page - 1
if end_item > total_items:
end_item = total_items
variables['items'] = items
variables['total_items'] = total_items
variables['prev_page'] = prev_page
variables['next_page'] = next_page
variables['prev_page_disabled'] = prev_page_disabled
variables['next_page_disabled'] = next_page_disabled
variables['current_page'] = page
variables['start_item'] = start_item
variables['end_item'] = end_item
variables['query_string'] = urlencode(d)
variables['d'] = d
if request.is_ajax():
return render_to_response(
'profiles/table.html', RequestContext(request, variables))
return render_to_string(
'profiles/table.html', RequestContext(request, variables))
def archive_cdrs_export_excel(request):
import time
import xlwt
book = xlwt.Workbook(encoding='utf8')
sheet = book.add_sheet('Esportazione')
default_style = xlwt.Style.default_style
datetime_style = xlwt.easyxf(num_format_str='dd/mm/yyyy hh:mm')
start_date = request.GET.get("start_date", "")
end_date = request.GET.get("end_date", "")
start_time = request.GET.get("start_time", "00:00")
end_time = request.GET.get("end_time", "23:59")
accountcode = request.GET.get("accountcode", "")
dst = request.GET.get("dst", "")
q_obj = Q(accountcode__icontains=accountcode)
q_obj.add(Q(custom_dst__icontains=dst), Q.AND)
q_obj.add(Q(dcontext='cabs-dial-number')|Q(dcontext='outgoing-operator-dial-number')|Q(dcontext='incoming-operator-dial-number'), Q.AND)
q_obj.add(Q(custom_valid=1), Q.AND) # esportiamo solo le chiamate ritenute valide
if start_date != '':
start_date = Helper.convert_datestring_format(
start_date, "%d-%m-%Y", "%Y-%m-%d")
start_date = "%s %s:00" % (start_date, start_time)
q_obj.add(Q(calldate__gte=start_date), Q.AND)
if end_date != '':
end_date = Helper.convert_datestring_format(
end_date, "%d-%m-%Y", "%Y-%m-%d")
end_date = "%s %s:59" % (end_date, end_time)
q_obj.add(Q(calldate__lte=end_date), Q.AND)
details = ArchivedDetail.objects.filter(q_obj).order_by('-calldate')
sheet.write(0, 0, "Data e ora", style=default_style)
sheet.write(0, 1, "Codice", style=default_style)
sheet.write(0, 2, "Matricola", style=default_style)
sheet.write(0, 3, "Cognome e Nome", style=default_style)
sheet.write(0, 4, "Sorgente", style=default_style)
sheet.write(0, 5, "Destinazione", style=default_style)
sheet.write(0, 6, "Numero Autorizzato", style=default_style)
sheet.write(0, 7, "Durata", style=default_style)
sheet.write(0, 8, "Costo", style=default_style)
for row, rowdata in enumerate(details):
try:
archived_phoneuser = ArchivedPhoneUser.objects.get(pincode=rowdata.accountcode)
fullname = archived_phoneuser.get_full_name()
matricola = archived_phoneuser.serial_no
whitelist = ArchivedWhitelist.objects.get(phonenumber=rowdata.custom_dst,
archived_phoneuser_id=archived_phoneuser.id)
whitelist_label = whitelist.label
except:
fullname = '-'
matricola = '-'
whitelist_label = '-'
calldate = time.strftime("%d-%m-%Y %H:%M:%S",
time.strptime(str(rowdata.calldate),
"%Y-%m-%d %H:%M:%S"))
billsec = "%sm %ss" % (int(rowdata.billsec / 60), rowdata.billsec % 60)
rowdata.price = rowdata.price > 0 and rowdata.price or 0
sheet.write(row + 1, 0, calldate, style=datetime_style)
sheet.write(row + 1, 1, rowdata.accountcode, style=default_style)
sheet.write(row + 1, 2, matricola, style=default_style)
sheet.write(row + 1, 3, fullname, style=default_style)
sheet.write(row + 1, 4, rowdata.custom_src, style=default_style)
sheet.write(row + 1, 5, rowdata.custom_dst, style=default_style)
sheet.write(row + 1, 6, whitelist_label, style=default_style)
sheet.write(row + 1, 7, billsec, style=default_style)
sheet.write(row + 1, 8, rowdata.price, style=default_style)
response = HttpResponse(content_type='application/vnd.ms-excel')
filename = 'Dettaglio_chiamate_archiviate.xls'
response[
'Content-Disposition'] = 'attachment; filename=%s' % filename
book.save(response)
# logghiamo azione
audit = Audit()
audit.user = request.user
d = request.GET.dict()
audit.what = "Esportazione lista chiamate archiviate corrispondenti ai seguenti criteri: %s" \
% (urlencode(d))
audit.save()
return response
def archive_records_items(request):
"""Record Items"""
from urllib import urlencode
variables = {}
items_per_page = settings.ITEMS_PER_PAGE
start_date = request.GET.get("start_date", "")
end_date = request.GET.get("end_date", "")
start_time = request.GET.get("start_time", "00:00")
end_time = request.GET.get("end_time", "23:59")
archived_phoneuser_id = request.GET.get("archived_phoneuser_id", "")
pincode = request.GET.get("pincode", "")
page = int(request.GET.get("page", "1"))
d = request.GET.dict()
page = 1
if 'page' in d.keys():
page = int(d['page'])
# elimino la pagina dal dizionario
del d['page']
q_obj = Q(pincode__icontains=pincode)
if archived_phoneuser_id:
q_obj.add(Q(archived_phoneuser_id=archived_phoneuser_id), Q.AND)
if start_date != '':
start_date = Helper.convert_datestring_format(
start_date, "%d-%m-%Y", "%Y-%m-%d")
start_date = "%s %s:00" % (start_date, start_time)
q_obj.add(Q(calldate__gte=start_date), Q.AND)
if end_date != '':
end_date = Helper.convert_datestring_format(
end_date, "%d-%m-%Y", "%Y-%m-%d")
end_date = "%s %s:59" % (end_date, end_time)
q_obj.add(Q(calldate__lte=end_date), Q.AND)
items_list = ArchivedRecord.objects.filter(q_obj).order_by('-calldate')
total_items = items_list.count()
items, items_range, items_next_page = Helper.make_pagination(
items_list, page, items_per_page)
for item in items:
try:
details = ArchivedDetail.objects.filter(uniqueid=item.uniqueid)
if not details:
item.detail = Detail
item.detail.custom_dst = ''
else:
item.detail = details[0]
item.whitelist = ArchivedWhitelist.objects.get(
archived_phoneuser_id=item.archived_phoneuser_id, phonenumber=item.detail.custom_dst)
except Exception as e:
pass # TODO gestire
print "Errore nel recupero delle informazioni sulla chiamata"
if item.filename != '':
item.filename = "/recordings/%s" % item.filename
prev_page = page - 1
prev_page_disabled = ''
if prev_page < 1:
prev_page = 1
prev_page_disabled = 'disabled'
next_page = 1
next_page_disabled = ''
if items:
next_page = page + 1
if next_page > items.paginator.num_pages:
next_page = items.paginator.num_pages
next_page_disabled = 'disabled'
start_item = 1
if page > 0:
start_item = (page - 1) * items_per_page + 1
end_item = start_item + items_per_page - 1
if end_item > total_items:
end_item = total_items
variables['items'] = items
variables['total_items'] = total_items
variables['prev_page'] = prev_page
variables['next_page'] = next_page
variables['prev_page_disabled'] = prev_page_disabled
variables['next_page_disabled'] = next_page_disabled
variables['current_page'] = page
variables['start_item'] = start_item
variables['end_item'] = end_item
variables['d'] = d
variables['query_string'] = urlencode(d)
if request.is_ajax():
return render_to_response(
'archives/records/table.html', RequestContext(request, variables))
return render_to_string(
'archives/records/table.html', RequestContext(request, variables))
def archive_cdrs_items(request):
variables = {}
items_per_page = settings.ITEMS_PER_PAGE
start_date = request.GET.get("start_date", "")
end_date = request.GET.get("end_date", "")
start_time = request.GET.get("start_time", None)
end_time = request.GET.get("end_time", None)
accountcode = request.GET.get("accountcode", "")
archived_phoneuser_id = request.GET.get("archived_phoneuser_id", "")
dst = request.GET.get("dst", "")
custom_calltype = request.GET.get("custom_calltype", None)
page = int(request.GET.get("page", "1"))
d = request.GET.dict()
page = 1
if 'page' in d.keys():
page = int(d['page'])
# elimino la pagina dal dizionario
del d['page']
q_obj = Q(accountcode__icontains=accountcode)
q_obj.add(Q(custom_dst__icontains=dst), Q.AND)
if archived_phoneuser_id:
q_obj.add(Q(archived_phoneuser_id=archived_phoneuser_id), Q.AND)
if start_date != '':
start_date = Helper.convert_datestring_format(
start_date, "%d-%m-%Y", "%Y-%m-%d")
if start_time:
start_time = "%s:00" % start_time
else:
start_time = "00:00:00"
start_date = "%s %s" % (start_date, start_time)
q_obj.add(Q(calldate__gte=start_date), Q.AND)
if end_date != '':
end_date = Helper.convert_datestring_format(
end_date, "%d-%m-%Y", "%Y-%m-%d")
if end_time:
end_time = "%s:59" % end_time
else:
end_time = "23:59:59"
end_date = "%s %s" % (end_date, end_time)
q_obj.add(Q(calldate__lte=end_date), Q.AND)
if custom_calltype:
q_obj.add(Q(custom_calltype=custom_calltype), Q.AND)
items_list = ArchivedDetail.objects.filter(q_obj).order_by('-calldate')
total_items = items_list.count()
total_costs = 0.0
# calcoliamo numero e costo complessivo
for item in items_list:
if float(item.price) > 0:
total_costs += float(item.price)
items, items_range, items_next_page = Helper.make_pagination(
items_list, page, items_per_page)
for item in items:
if item.price < 0:
item.price = "0.00"
try:
item.whitelist = ArchivedWhitelist.objects.filter(
archived_phoneuser=item.archived_phoneuser_id, phonenumber=item.custom_dst)[0]
except Exception as e:
pass # TODO gestire errore
prev_page = page - 1
prev_page_disabled = ''
if prev_page < 1:
prev_page = 1
prev_page_disabled = 'disabled'
next_page = 1
next_page_disabled = ''
if items:
next_page = page + 1
if next_page > items.paginator.num_pages:
next_page = items.paginator.num_pages
next_page_disabled = 'disabled'
# print "range: %s - next: %s" % (items_range, next_page)
start_item = 1
if page > 0:
start_item = (page - 1) * items_per_page + 1
end_item = start_item + items_per_page - 1
if end_item > total_items:
end_item = total_items
variables['items'] = items
variables['total_costs'] = total_costs
variables['total_items'] = total_items
variables['prev_page'] = prev_page
variables['next_page'] = next_page
variables['prev_page_disabled'] = prev_page_disabled
variables['next_page_disabled'] = next_page_disabled
variables['current_page'] = page
variables['start_item'] = start_item
variables['end_item'] = end_item
variables['query_string'] = urlencode(d)
variables['d'] = d
variables['archived_phoneuser_id'] = archived_phoneuser_id
if request.is_ajax():
return render_to_response(
'archives/cdrs/table.html', RequestContext(request, variables))
return render_to_string(
'archives/cdrs/table.html', RequestContext(request, variables))
def credit_items(request, phoneuser_id):
items_per_page = int(settings.ITEMS_PER_PAGE)
d = request.GET.dict()
phoneuser_id = int(phoneuser_id)
user = request.user
variables = Acl.get_permissions_for_user(user.id, user.is_staff)
items_list = Credit.objects.filter(
phoneuser_id=phoneuser_id).order_by('-recharge_date')
total_items = items_list.count()
try:
phoneuser = PhoneUser.objects.get(pk=phoneuser_id)
except ObjectDoesNotExist:
raise Http404
page = 1
if 'page' in d.keys():
page = int(d['page'])
# elimino la pagina dal dizionario
del d['page']
items, items_range, items_next_page = Helper.make_pagination(
items_list, page, items_per_page)
prev_page = page - 1
prev_page_disabled = ''
if prev_page < 1:
prev_page = 1
prev_page_disabled = 'disabled'
next_page = 1
next_page_disabled = ''
if items:
next_page = page + 1
if next_page > items.paginator.num_pages:
next_page = items.paginator.num_pages
next_page_disabled = 'disabled'
start_item = 1
if page > 0:
start_item = (page - 1) * items_per_page + 1
end_item = start_item + items_per_page - 1
if end_item > total_items:
end_item = total_items
variables['items'] = items
variables['total_items'] = total_items
variables['prev_page'] = prev_page
variables['next_page'] = next_page
variables['prev_page_disabled'] = prev_page_disabled
variables['next_page_disabled'] = next_page_disabled
variables['current_page'] = page
variables['start_item'] = start_item
variables['end_item'] = end_item
variables['d'] = d
variables['balance'] = phoneuser.balance
variables['phoneuser_id'] = phoneuser_id
if request.is_ajax():
return render_to_response(
'phoneusers/credits/table.html', RequestContext(request, variables))
return render_to_string(
'phoneusers/credits/table.html', RequestContext(request, variables))
def audit_items(request):
"""CDR Items"""
variables = {}
items_per_page = 10 #settings.ITEMS_PER_PAGE
start_date = request.GET.get("start_date", "")
end_date = request.GET.get("end_date", "")
start_time = request.GET.get("start_time", None)
end_time = request.GET.get("end_time", None)
keyword = request.GET.get("keyword", "")
what = request.GET.get("what", "")
page = int(request.GET.get("page", "1"))
d = request.GET.dict()
page = 1
if 'page' in d.keys():
page = int(d['page'])
# elimino la pagina dal dizionario
del d['page']
q_obj = Q(user__username__icontains=keyword) | Q(user__last_name__icontains=keyword)
if what != '':
q_obj.add(Q(what__icontains=what), Q.AND)
if start_date != '':
start_date = Helper.convert_datestring_format(
start_date, "%d-%m-%Y", "%Y-%m-%d")
if start_time:
start_time = "%s:00" % start_time
else:
start_time = "00:00:00"
start_date = "%s %s" % (start_date, start_time)
q_obj.add(Q(when__gte=start_date), Q.AND)
if end_date != '':
end_date = Helper.convert_datestring_format(
end_date, "%d-%m-%Y", "%Y-%m-%d")
if end_time:
end_time = "%s:59" % end_time
else:
end_time = "23:59:59"
end_date = "%s %s" % (end_date, end_time)
q_obj.add(Q(when__lte=end_date), Q.AND)
items_list = Audit.objects.filter(q_obj).order_by('-when')
total_items = items_list.count()
items, items_range, items_next_page = Helper.make_pagination(
items_list, page, items_per_page)
prev_page = page - 1
prev_page_disabled = ''
if prev_page < 1:
prev_page = 1
prev_page_disabled = 'disabled'
next_page = 1
next_page_disabled = ''
if items:
next_page = page + 1
if next_page > items.paginator.num_pages:
next_page = items.paginator.num_pages
next_page_disabled = 'disabled'
start_item = 1
if page > 0:
start_item = (page - 1) * items_per_page + 1
end_item = start_item + items_per_page - 1
if end_item > total_items:
end_item = total_items
variables['items'] = items
variables['total_items'] = total_items
variables['prev_page'] = prev_page
variables['next_page'] = next_page
variables['prev_page_disabled'] = prev_page_disabled
variables['next_page_disabled'] = next_page_disabled
variables['current_page'] = page
variables['start_item'] = start_item
variables['end_item'] = end_item
variables['query_string'] = urlencode(d)
variables['d'] = d
if request.is_ajax():
return render_to_response(
'audits/table.html', RequestContext(request, variables))
return render_to_string(
'audits/table.html', RequestContext(request, variables))
def cdr_items(request):
"""CDR Items"""
variables = {}
items_per_page = settings.ITEMS_PER_PAGE
start_date = request.GET.get("start_date", "")
end_date = request.GET.get("end_date", "")
start_time = request.GET.get("start_time", None)
end_time = request.GET.get("end_time", None)
accountcode = request.GET.get("accountcode", "")
dst = request.GET.get("dst", "")
custom_calltype = request.GET.get("custom_calltype", None)
page = int(request.GET.get("page", "1"))
d = request.GET.dict()
page = 1
if 'page' in d.keys():
page = int(d['page'])
# elimino la pagina dal dizionario
del d['page']
q_obj = Q(accountcode__icontains=accountcode)
q_obj.add(Q(custom_dst__icontains=dst), Q.AND)
q_obj.add(Q(dcontext='cabs-dial-number')|Q(dcontext='outgoing-operator-dial-number')|Q(dcontext='incoming-operator-dial-number'), Q.AND)
if start_date != '':
start_date = Helper.convert_datestring_format(
start_date, "%d-%m-%Y", "%Y-%m-%d")
if start_time:
start_time = "%s:00" % start_time
else:
start_time = "00:00:00"
start_date = "%s %s" % (start_date, start_time)
q_obj.add(Q(calldate__gte=start_date), Q.AND)
if end_date != '':
end_date = Helper.convert_datestring_format(
end_date, "%d-%m-%Y", "%Y-%m-%d")
if end_time:
end_time = "%s:59" % end_time
else:
end_time = "23:59:59"
end_date = "%s %s" % (end_date, end_time)
q_obj.add(Q(calldate__lte=end_date), Q.AND)
if custom_calltype:
q_obj.add(Q(custom_calltype=custom_calltype), Q.AND)
items_list = Detail.objects.filter(q_obj).order_by('-calldate')
total_items = items_list.count()
total_costs = 0.0
# calcoliamo numero e costo complessivo
for item in items_list:
if float(item.price) > 0:
total_costs += float(item.price)
items, items_range, items_next_page = Helper.make_pagination(
items_list, page, items_per_page)
for item in items:
if item.price < 0:
item.price = "0.00"
# cerchiamo di recuperare informazioni sul phoneuser
item.phoneuser = PhoneUser.get_from_pincode(item.accountcode)
try:
item.whitelist = Whitelist.objects.filter(
phoneuser_id=item.phoneuser.id, phonenumber=item.custom_dst)[0]
except Exception as e:
pass
src_name = Extension.get_extension_name(item.custom_src)
if src_name:
item.custom_src = "%s (%s)" % (src_name, item.custom_src)
prev_page = page - 1
prev_page_disabled = ''
if prev_page < 1:
prev_page = 1
prev_page_disabled = 'disabled'
next_page = 1
next_page_disabled = ''
if items:
next_page = page + 1
if next_page > items.paginator.num_pages:
next_page = items.paginator.num_pages
next_page_disabled = 'disabled'
start_item = 1
if page > 0:
start_item = (page - 1) * items_per_page + 1
end_item = start_item + items_per_page - 1
if end_item > total_items:
end_item = total_items
variables['items'] = items
variables['total_costs'] = total_costs
variables['total_items'] = total_items
variables['prev_page'] = prev_page
variables['next_page'] = next_page
variables['prev_page_disabled'] = prev_page_disabled
variables['next_page_disabled'] = next_page_disabled
variables['current_page'] = page
variables['start_item'] = start_item
variables['end_item'] = end_item
variables['query_string'] = urlencode(d)
variables['d'] = d
if request.is_ajax():
return render_to_response(
'cdrs/table.html', RequestContext(request, variables))
return render_to_string(
'cdrs/table.html', RequestContext(request, variables))
def phonecab_get_nightmode(request):
"""Recupera la modalita giorno notte"""
return HttpResponse(
status=200, content=('{ "nightmode" : %d }' % Helper.get_nightmode()), content_type="application/json"
)
