def report_date(request):
date_start, date_end = Report().set_date(request.user.get_profile().org_active,
request.GET.get('date_start'), request.GET.get('date_end'))
accumulated = request.GET.get('accumulated')
return HttpResponse(simplejson.dumps({'date_start': date_start.strftime('%d/%m/%Y'), 'date_end': date_end.strftime('%d/%m/%Y'), 'accumulated': accumulated}))
def report_save(request, form_class=None, view=None, template='report/report_save_form.html'):
"""
save new report
"""
if request.method == 'POST':
save_form = form_class(request.POST)
if save_form.is_valid():
data = save_form.save( request.user , request.user.get_profile().org_active )
return HttpResponse( data.label )
else:
raise Exception(_('Error to save register'))
report = Report()
date_start , date_end = report.set_date( request.user.get_profile().org_active , request.GET.get('date_start') , request.GET.get('date_end') )
# financial / revenues
if view == 'receive':
form = form_class( date_start=date_start , date_end=date_end , service=request.GET.get('service') , professional=request.GET.get('professional') , pway=request.GET.get('pway'), receive=request.GET.get('receive') , covenant=request.GET.get('covenant') )
# admission / referral
else:
form = form_class( date_start=date_start , date_end=date_end , service=Service.objects.get( organization=request.user.get_profile().org_active, pk=request.GET.get('service')) if request.GET.get('service') else None, accumulated=request.GET.get('accumulated'))
url_post = reverse('report_%s_save' % view) # url to post form
return render_to_response(template, locals(), context_instance=RequestContext(request))
def index(request):
"""
display initial templates
permission:
all:
administrator or secretary can use all.
professional:
professional can filter just yours own services and covenant.
False:
others can't user report
"""
form = ReportForm(request.user.get_profile().org_active.created(), datetime.now(), request.user.get_profile().org_active)
# permission, can't use professional filter
permission = False
if request.user.groups.filter(name__icontains='professional'):
permission = 'professional'
if request.user.groups.filter(Q(name__icontains='administrator')|Q(name__icontains='secretary')).distinct():
permission = 'all'
"""
pass filter itens in right bar
"""
r = Report()
filters = r.filters()
return render_to_response('report/report_index.html', locals(), context_instance=RequestContext(request))
def report_save(request, form_class=None, view=None, template='report/report_save_form.html'):
"""
save new report
render {{ url_post }} at report/report_save_form.html and update <form action> to save report for right section, view.
"""
if request.method == 'POST':
save_form = form_class(request.POST)
if save_form.is_valid():
data = save_form.save(request.user, request.user.get_profile().org_active)
return HttpResponse(data.label)
else:
raise Exception(_('Error to save register'))
report = Report()
date_start, date_end = report.set_date(request.user.get_profile().org_active, request.GET.get('date_start'), request.GET.get('date_end'))
# admission / referral
if view == 'admission':
form = form_class(date_start=date_start, date_end=date_end, accumulated=request.GET.get('accumulated'))
# financial / revenues
if view == 'receive':
form = form_class(date_start=date_start, date_end=date_end, service=request.GET.get('service'), professional=request.GET.get('professional'), pway=request.GET.get('pway'), receive=request.GET.get('receive'), covenant=request.GET.get('covenant'))
# prontuario / medical record
if view == 'formfill':
form = form_class(date_start=date_start, date_end=date_end, professional=request.GET.get('professional'), service=request.GET.get('service'), formfill=request.GET.get('formfill'), attach=request.GET.get('attach'), charge=request.GET.get('charge'))
url_post = reverse('report_%s_save' % view) # update <form action url>
return render_to_response(template, locals(), context_instance=RequestContext(request))
def report_export(request):
"""
export admission data in html or pdf
"""
html = 'report/report_export.html'
if request.method == 'POST':
r = Report()
org_active = request.user.get_profile().org_active
# admission statistcs data
if request.POST.get('view') == '1': # admission
title = _('Admission Report')
view = 'admission'
data = Report().get_admissions_range(org_active, request.POST.get('date_start'), request.POST.get('date_end'), request.POST.get('accumulated'))
if request.POST.get('clients'):
report_clients = ReportAdmission.objects.clients_all(request.user, request.POST.get('date_start'), request.POST.get('date_end'))
data, chart_url, date_start,date_end = data
if request.POST.get('view') == '2': # referral
title = _('Referral Report')
if request.POST.get('service'):
sub_title = u'%s %s' % (_('Service'), Service.objects.get(organization=request.user.get_profile().org_active, pk=request.POST.get('service')))
view = 'referral'
data = Report().get_referral_range(org_active, request.POST.get('date_start'), request.POST.get('date_end'), request.POST.get('service'), request.POST.get('accumulated'))
if request.POST.get('clients'):
report_clients = ReportReferral.objects.clients_all(request.user, request.POST.get('date_start'), request.POST.get('date_end'))
data,date_start,date_end, service = data
# renevues / faturamento
if request.POST.get('view') == '3':
view = 'receive'
title = _('Revenues Report')
html = 'report/report_receive_export.html'
data , colors , date_start , date_end , list_receive , total_receive = Report().get_receive_( org_active, request.POST.get('date_start'), request.POST.get('date_end'), request.POST.get('professional'), request.POST.get('receipt_status'), request.POST.get('service'), request.POST.get('payment_way'), request.POST.get('cove') )
# variables of JS
option_title = u'Estatística de todos os profíssionais, serviços e pagamentos para o período escolhido.'
option_rows = data
option_colors = colors
IMG_PREFIX = '/media/' if int(request.POST.get('format')) == 1 else MEDIA_ROOT.replace('\\','/') + '/' # this a path bug fix. format == 1 (html)
if int(request.POST.get('format')) == 2: # pdf print
return write_pdf( html , locals(), ('%s-%s-%s-%s-%s.pdf' % (view, slugify(_('report-between')), request.POST.get('date_start').replace('/','-'), _('and'), request.POST.get('date_end').replace('/','-'))))
# default out is html format
remove_links = True
export_graph_type = request.POST.get('export_graph_type')
return render_to_response( html , locals(), context_instance=RequestContext(request))
def demographic_data(request, view='admission'):
organization = request.user.get_profile().org_active
report = Report()
date_start,date_end = report.set_date(organization, request.GET.get('date_start'), request.GET.get('date_end'))
if 'admission' in view:
range = AdmissionReferral.objects_inrange.all(organization, date_start, date_end)
if range:
demographic = ReportAdmission.objects_demographic.all(organization, [i.client.id for i in range])
return render_to_response('report/report_demographic_table.html', locals(), context_instance=RequestContext(request))
def report_save(request,
form_class=None,
view=None,
template='report/report_save_form.html'):
"""
save new report
render {{ url_post }} at report/report_save_form.html and update <form action> to save report for right section, view.
"""
if request.method == 'POST':
save_form = form_class(request.POST)
if save_form.is_valid():
data = save_form.save(request.user,
request.user.get_profile().org_active)
return HttpResponse(escape(data.label))
else:
raise Exception(_('Error to save register'))
report = Report()
date_start, date_end = report.set_date(
request.user.get_profile().org_active, request.GET.get('date_start'),
request.GET.get('date_end'))
# admission / referral
if view == 'admission':
form = form_class(date_start=date_start,
date_end=date_end,
accumulated=request.GET.get('accumulated'))
# financial / revenues
if view == 'receive':
form = form_class(date_start=date_start,
date_end=date_end,
service=request.GET.get('service'),
professional=request.GET.get('professional'),
pway=request.GET.get('pway'),
receive=request.GET.get('receive'),
covenant=request.GET.get('covenant'))
# prontuario / medical record
if view == 'formfill':
form = form_class(date_start=date_start,
date_end=date_end,
professional=request.GET.get('professional'),
service=request.GET.get('service'),
formfill=request.GET.get('formfill'),
attach=request.GET.get('attach'),
charge=request.GET.get('charge'))
url_post = reverse('report_%s_save' % view) # update <form action url>
return render_to_response(template,
locals(),
context_instance=RequestContext(request))
def report_date(request):
date_start, date_end = Report().set_date(
request.user.get_profile().org_active, request.GET.get('date_start'),
request.GET.get('date_end'))
accumulated = request.GET.get('accumulated')
return HttpResponse(
simplejson.dumps({
'date_start': date_start.strftime('%d/%m/%Y'),
'date_end': date_end.strftime('%d/%m/%Y'),
'accumulated': accumulated
}))
def report_client_list(request, report_class, view, filter):
"""
fetch client list from selected admission report
"""
organization = request.user.get_profile().org_active
report = Report()
date_start,date_end = report.set_date(organization, request.GET.get('date_start'), request.GET.get('date_end'))
verbose_name, object_list, organization_total = report_class.objects.clients(request.user, date_start, date_end, view, filter, request.GET.get('service'))
not_diplay_count = int(len(organization_total))-int(len(object_list))
return render_to_response('report/report_client_list.html', locals(), context_instance=RequestContext(request))
def index(request):
"""
display initial templates
"""
form = ReportForm(request.user.get_profile().org_active.created(), datetime.now(), request.user.get_profile().org_active)
"""
pass filter itens in right bar
"""
r = Report()
filters = r.filters()
return render_to_response('report/report_index.html', locals(), context_instance=RequestContext(request))
def index(request):
"""
display initial templates
"""
form = ReportForm(request.user.get_profile().org_active.created(), datetime.now(), request.user.get_profile().org_active)
"""
pass filter itens in right bar
"""
r = Report()
filters = r.filters()
return render_to_response('report/report_index.html', locals(), context_instance=RequestContext(request))
def referral_data(request, template='report/report_table.html'):
"""
load referral dashboard reports
"""
data, date_start,date_end,service = Report().get_referral_range(request.user.get_profile().org_active, request.GET.get('date_start'), request.GET.get('date_end'), request.GET.get('service'), request.GET.get('accumulated'))
return render_to_response(template, locals(), context_instance=RequestContext(request))
def admission_data(request, template='report/report_table.html'):
"""
load admission dashboard reports
"""
data, chart_url, date_start,date_end = Report().get_admissions_range(request.user.get_profile().org_active, request.GET.get('date_start'), request.GET.get('date_end'), request.GET.get('accumulated'))
return render_to_response(template, locals(), context_instance=RequestContext(request))
def occurrence_data(request, template='report/report_graphic.html'):
"""
occurrence
"""
data = Report().get_occurrence_( request.user.get_profile().org_active , request.GET.get('date_start') , request.GET.get('date_end') , request.GET.get('service') , request.GET.get('accumulated') )
# variables of JS
option_title = _('Occurrence graphic from selected service')
option_rows = [] # array format
for occurrences in data:
option_rows.append([occurrences['occurrence_type'], occurrences['total'], occurrences["occurrences"]])
return render_to_response(template, locals(), context_instance=RequestContext(request))
def event_data(request, template='report/report_event.html'):
"""
event
"""
data, lines, date_start, date_end, sch_list, total_events = Report().get_event_( request.user.get_profile().org_active , request.GET.get('date_start') , request.GET.get('date_end') , request.GET.get('professional') , request.GET.get('service'), request.GET.get('status'), request.GET.get('accumulated') )
# variables of JS
option_rows = data
column = lines
#option_rows = "([ [new Date(2015, 0, 1), 5], [new Date(2015, 0, 2), 7], [new Date(2015, 0, 3), 3], [new Date(2015, 0, 4), 1], [new Date(2015, 0, 5), 3], [new Date(2015, 0, 6), 4], [new Date(2015, 0, 7), 3], [new Date(2015, 0, 8), 4], [new Date(2015, 0, 9), 2], [new Date(2015, 0, 10), 5], [new Date(2015, 0, 11), 8], [new Date(2015, 0, 12), 6], [new Date(2015, 0, 13), 3], [new Date(2015, 0, 14), 3], [new Date(2015, 0, 15), 5], [new Date(2015, 0, 16), 7], [new Date(2015, 0, 17), 6], [new Date(2015, 0, 18), 6], [new Date(2015, 0, 19), 3], [new Date(2015, 0, 20), 1], [new Date(2015, 0, 21), 2], [new Date(2015, 0, 22), 4], [new Date(2015, 0, 23), 6], [new Date(2015, 0, 24), 5], [new Date(2015, 0, 25), 9], [new Date(2015, 0, 26), 4], [new Date(2015, 0, 27), 9], [new Date(2015, 0, 28), 8], [new Date(2015, 0, 29), 6], [new Date(2015, 0, 30), 4], [new Date(2015, 0, 31), 6], [new Date(2015, 1, 1), 7], [new Date(2015, 1, 2), -10] ]);"
return render_to_response(template, locals(), context_instance=RequestContext(request))
def receive_data(request, template='report/report_receive.html'):
"""
receive
"""
data , colors , date_start, date_end, list_receive, total_receive = Report().get_receive_( request.user.get_profile().org_active , request.GET.get('date_start') , request.GET.get('date_end') , request.GET.get('professional') , request.GET.get('receive') , request.GET.get('service'), request.GET.get('pway'), request.GET.get('covenant') )
# variables of JS
option_title = u'Estatística de todos os profíssionais, serviços e pagamentos para o período escolhido.'
option_rows = data
option_colors = colors
return render_to_response(template, locals(), context_instance=RequestContext(request))
def report_export(request):
"""
export admission data in html or pdf
"""
if request.method == 'POST':
r = Report()
org_active = request.user.get_profile().org_active
# admission statistcs data
if request.POST.get('view') == '1': # admission
title = _('Admission Report')
view = 'admission'
data = Report().get_admissions_range(org_active, request.POST.get('date_start'), request.POST.get('date_end'), request.POST.get('accumulated'))
if request.POST.get('clients'):
report_clients = ReportAdmission.objects.clients_all(request.user, request.POST.get('date_start'), request.POST.get('date_end'))
data, chart_url, date_start,date_end = data
if request.POST.get('view') == '2': # referral
title = _('Referral Report')
if request.POST.get('service'):
sub_title = u'%s %s' % (_('Service'), Service.objects.get(organization=request.user.get_profile().org_active, pk=request.POST.get('service')))
view = 'referral'
data = Report().get_referral_range(org_active, request.POST.get('date_start'), request.POST.get('date_end'), request.POST.get('service'), request.POST.get('accumulated'))
if request.POST.get('clients'):
report_clients = ReportReferral.objects.clients_all(request.user, request.POST.get('date_start'), request.POST.get('date_end'))
data,date_start,date_end, service = data
IMG_PREFIX = '/media/' if int(request.POST.get('format')) == 1 else MEDIA_ROOT.replace('\\','/') + '/' # this a path bug fix. format == 1 (html)
if int(request.POST.get('format')) == 2: # pdf print
user = request.user
return write_pdf('report/report_export.html', locals(), ('%s-%s-%s-%s-%s.pdf' % (view, slugify(_('report-between')), request.POST.get('date_start').replace('/','-'), _('and'), request.POST.get('date_end').replace('/','-'))))
remove_links = True
export_graph_type = request.POST.get('export_graph_type')
return render_to_response('report/report_export.html', locals(), context_instance=RequestContext(request))
def event_data(request, template='report/report_event.html'):
"""
event
"""
data, lines, date_start, date_end, sch_list, total_events, show_filter = Report(
).get_event_(request.user.get_profile().org_active,
request.GET.get('date_start'), request.GET.get('date_end'),
request.GET.get('professional'), request.GET.get('service'),
request.GET.get('status'), request.GET.get('accumulated'))
# variables of JS
option_rows = data
column = lines
return render_to_response(template,
locals(),
context_instance=RequestContext(request))
def formfill_data(request):
"""
check if field is fill of a form.
"""
list_client, list_client_total, date_start, date_end, professional, service, fillform, attach, show_filters = Report(
).get_formfill_(request.user.get_profile().org_active,
request.GET.get('date_start'), request.GET.get('date_end'),
request.GET.get('professional'),
request.GET.get('service'), request.GET.get('formfill'),
request.GET.get('attach'), request.GET.get('charge'))
if request.GET.get('formfill') == '1':
template = 'report/report_medicalrecord.html'
return render_to_response(template,
locals(),
context_instance=RequestContext(request))