def tarp_subsidies(request):
estimated_subsidies = []
subsidy_rates = []
amounts_received = []
names = []
colors = []
for r in SubsidyRecord.objects.all():
estimated_subsidies.append(r.estimated_subsidy)
subsidy_rates.append(r.subsidy_rate)
amounts_received.append(r.amount_received)
names.append(r.name)
colors.append(r.color)
# reverse names (API wrapper bug?)
names.reverse()
# estimated subsidies chart
estimates_subsidies_normalized = _normalize_chart_range(
estimated_subsidies)
estimated_subsidies_chart = GChart('bhs',
estimates_subsidies_normalized.values())
estimated_subsidies_chart.size((500, 250))
estimated_subsidies_chart.color('|'.join(colors))
estimated_subsidies_chart.bar(18, 2, 0)
estimated_subsidies_chart.axes.type('xy')
estimated_subsidies_chart_xlabels = range(
0, (_get_scale_bound(estimated_subsidies) + 1), 5)
estimated_subsidies_chart_xlabels = map((lambda x: str(x)),
estimated_subsidies_chart_xlabels)
estimated_subsidies_chart.axes.label(
str('|'.join(estimated_subsidies_chart_xlabels)))
estimated_subsidies_chart.axes.label('|'.join(names))
estimated_subsidies_chart.axes.style('000000')
estimated_subsidies_chart.axes.style('000000')
i = 0
for x in estimated_subsidies:
marker_text = 't $%.1f' % x
estimated_subsidies_chart.marker(marker_text, '000000', 0, i, 10, -1)
i = i + 1
# subsidy rates chart
subsidy_rates_normalized = _normalize_chart_range(subsidy_rates)
subsidy_rate_chart = GChart('bhs', subsidy_rates_normalized.values())
subsidy_rate_chart.size((500, 250))
subsidy_rate_chart.color('|'.join(colors))
subsidy_rate_chart.bar(18, 2, 0)
subsidy_rate_chart.axes.type('xy')
subsidy_rate_chart_xlabels = range(0,
(_get_scale_bound(subsidy_rates) + 1),
10)
subsidy_rate_chart_xlabels = map((lambda x: str(x)),
subsidy_rate_chart_xlabels)
subsidy_rate_chart.axes.label(str('|'.join(subsidy_rate_chart_xlabels)))
subsidy_rate_chart.axes.label('|'.join(names))
subsidy_rate_chart.axes.style('000000')
subsidy_rate_chart.axes.style('000000')
i = 0
for x in subsidy_rates:
marker_text = 't %d%%' % x
subsidy_rate_chart.marker(marker_text, '000000', 0, i, 10, -1)
i = i + 1
# amounts received chart
amounts_received_normalized = _normalize_chart_range(amounts_received)
amounts_received_chart = GChart('bhs',
amounts_received_normalized.values())
amounts_received_chart.size((500, 250))
amounts_received_chart.color('|'.join(colors))
amounts_received_chart.bar(18, 2, 0)
amounts_received_chart.axes.type('xy')
amounts_received_chart_xlabels = range(
0, (_get_scale_bound(amounts_received) + 1), 10)
amounts_received_chart_xlabels = map((lambda x: str(x)),
amounts_received_chart_xlabels)
amounts_received_chart.axes.label(
str('|'.join(amounts_received_chart_xlabels)))
amounts_received_chart.axes.label('|'.join(names))
amounts_received_chart.axes.style('000000')
amounts_received_chart.axes.style('000000')
i = 0
for x in amounts_received:
marker_text = 't $%.1f' % x
amounts_received_chart.marker(marker_text, '000000', 0, i, 10, -1)
i = i + 1
return render_to_response(
'bailout/tarp_subsidy_table.html', {
'estimated_subsidies_chart': estimated_subsidies_chart.img(),
'subsidy_rate_chart': subsidy_rate_chart.img(),
'amounts_received_chart': amounts_received_chart.img(),
'estimated_subsidies': estimated_subsidies,
'subsidy_rates': subsidy_rates,
'amounts_received': amounts_received,
'names': ' '.join(names),
'colors': '|'.join(colors)
},
context_instance=RequestContext(request))
def get_context_data(self, **kwargs):
context = super(RedDetailView, self).get_context_data(**kwargs)
app_label = 'rtg'
model = models.get_model(app_label, 'ReservaIp')
self.admin_object = admin_rtg._registry[model] #IGNORE:protected-access
self.admin_object.red_ips = Red_Ips(self.object)
if self.object.externa:
ips_activas = "No disponible (red externa)"
else:
ips_activas = self.admin_object.red_ips.ips_activas
if self.object.asignacion_ip: #gestionamos las IPs
ips_asignadas = len(self.admin_object.red_ips.asignadas)
ips_libres = self.admin_object.red_ips.ips_libres
self.admin_object.change_list_template = 'rtg/red_detail.django.html'
else: #no gestionamos las IPs
ips_asignadas = 'No se gestionan las IPs de la red'
ips_libres = ''
self.admin_object.change_list_template = 'rtg/red_detail_sin_ips.django.html'
hist_asignadas = []
hist_activas = []
for i in range(1,13):
d=HistoricoIpsEnRed.objects.filter(red=self.object).filter(fecha__month=i).aggregate(Max('ips_asignadas'),Max('ips_activas')) #IGNORE:no-member
hist_asignadas.append(d['ips_asignadas__max'])
hist_activas.append(d['ips_activas__max'])
hist_libres = deque(map(lambda x:'_' if x==None else str(self.admin_object.red_ips.num_ips-x), hist_asignadas)) #IGNORE:bad-builtin)
hist_asignadas = deque(map(lambda x:'_' if x==None else str(x), hist_asignadas)) #IGNORE:bad-builtin
hist_activas = deque(map(lambda x:'_' if x==None else str(x), hist_activas)) #IGNORE:bad-builtin
meses = deque(['Ene','Feb','Mar','Abr','May','Jun','Jul','Ago','Sep','Oct','Nov','Dic'])
mes_actual = datetime.date.today().month
# rotamos los datos para que apareza en la grafica el mes actual como último mes
meses.rotate(-mes_actual)
hist_libres.rotate(-mes_actual)
hist_asignadas.rotate(-mes_actual)
hist_activas.rotate(-mes_actual)
#Creamos el GChart pasando el dataset porque no se soporta el parametro t2
G = GChart(ctype="bvs", chd="t2:" + ','.join(hist_asignadas)+'|'+','.join(hist_libres)+'|'+','.join(hist_activas))
G.bar('a',1)
G.size(350,200)
G.color('4D89F9','C6D9FD','0000FF')
G.marker('D','0000FF','2','0','2')
G.marker('s','0000FF','2','-1','8')
G.title('Historico Utilizacion') #Fallan los acentos
G.legend('Asignadas','Libres','Activas')
G['chdlp'] = 'b|l'
G.scale(0,self.admin_object.red_ips.num_ips)
G.margin(0,0,5,0)
G.axes.type('yx')
G.axes.label(1,*meses) #IGNORE:W0142
G.axes.range(0,0,self.admin_object.red_ips.num_ips)
context.update( { 'model_name': 'red',
'num_ips': self.admin_object.red_ips.num_ips,
'ips_asignadas': ips_asignadas,
'ips_libres': ips_libres,
'ips_activas': ips_activas,
'admin_url': get_admin_url(self.request.get_full_path()),
'chart_ips_libres': G,
}
)
return context
