def pilot_detail(request,pilot_id):
print "in detail"
pilot1=get_pilot_by_id(pilot_id)
if not pilot1: raise Http404
#pilot1["id"]=pilot_id
name=get_object_or_404(pilot,id=pilot_id)
#name=pilot.objects.filter(pk=pilot_id)
#pilot1["name"]=name.name
print "get json"
kills_data=get_json_pilot(characterID=pilot_id)
print "add_json"
#db_add_json(kills_data)
#add_pilots_corps_to_db(kills_data)
print "add_json1"
#add_json2db(kills_data,pilot_id=pilot_id)
kills,loss=json_utils.divide_kill_lose(pilotID=pilot_id, kills_data=kills_data)
pilot1["number_kills"]=len(kills)
pilot1["number_loss"]=len(loss)
pilot1["last_kill_time"]=json_utils.get_last_kill_time(kills_data=kills_data)
loss=kill.objects.filter(characterID=pilot_id)
print "pre render"
return render(request,"analizer/pilot_detail.html",
{"pilot":pilot1,
"victim_list":get_victim_list(kills_data),
"loss":loss,
})
def mates_page(request,pilot_id):
cursor = connection.cursor()
cursor.execute("""select "characterID","characterName",count(*) as cnt from analizer_attacker
where "characterID" <> %s and "characterID" <> 0 and
"killID_id" in (select "killID_id" from analizer_attacker where "characterID"=%s)
group by "characterID","characterName" order by count(*) desc;
""",[pilot_id,pilot_id])
r=cursor.fetchall()
p=Paginator(r,mates_per_page)
mate_page = request.GET.get('mate_page', 1)
try:
page=p.page(mate_page)
except PageNotAnInteger:
page=p.page(1)
except EmptyPage:
page=p.page(p.num_pages)
mates=[]
for i in page.object_list:
d=get_pilot_by_id(i[0])
#if int(i[0])==int(pilot_id): continue
d["id"]=i[0]
d["name"]=i[1]
d["kills"]=i[2]
#print d
mates.append(d)
mates_pages={}
mates_pages["pilot"]=pilot_id
if page.has_next():
mates_pages["next"]=page.next_page_number()
if page.has_previous():
mates_pages["prev"]=page.previous_page_number()
return mates,mates_pages