def interface(request,webgis_id):
config = Config.objects.get(site=1)
webgis = get_object_or_404(WebGis,pk=webgis_id)
maps = webgis.map_set.all()
webgisinfo = ContextualInfo.objects.filter(webgis=webgis.id)
#WEBGIS CATALOGO DATI
# catalogodati = CatalogoDatiW.objects.all()
# catalogobase = CatalogoBase.objects.all()
# #enviro
# ambito_spaziale = AmbitoSpaziale.objects.all()
# ambito_climatico = AmbitoClimatico.objects.all()
# ambito_temporale = AmbitoTemporale.objects.all()
# ambito_variabile = AmbitoVariabile.objects.all()
results = list(maps) + list([webgis]) + list(webgisinfo) + list([config])
# results = results + list(catalogodati) + list(catalogobase)
# results = results + list(ambito_spaziale) + list(ambito_climatico) + list(ambito_temporale) + list(ambito_variabile)
t = loader.get_template('webgis/webgisinterface.html')
c = RequestContext(request, {
'maps': serializers.serialize(
"json", results, ensure_ascii=True, extras=('mapbaselayer_set',),
relations='max_extent'
)
})
return HttpResponse(t.render(c))
def ajax_load_matches(request):
if not request.is_ajax():
raise Http404
league_id = request.GET.get('sendValue')
sql_string = "SELECT MATCH_ID, HOME_TEAM_ID, VISITOR_TEAM_ID FROM sentiosp_drupal6.tf_match WHERE MATCH_LEAGUE_ID =" + league_id + ";"
cursor = connection.cursor()
cursor.execute(sql_string)
matches = cursor.fetchall()
home_team_ids = list(match[1] for match in matches)
away_team_ids = list(match[2] for match in matches)
team_ids = list(set(home_team_ids + away_team_ids))
sql_string = "SELECT TEAM_ID, TEAM_NAME FROM sentiosp_drupal6.td_team WHERE "
for team_id in team_ids:
sql_string += " TEAM_ID = " + str(team_id) + " OR"
sql_string += " FALSE"
cursor = connection.cursor()
cursor.execute(sql_string)
returned_data = cursor.fetchall()
team_names = dict(returned_data)
data = list()
for match in matches:
try:
data.append((match[0], team_names[match[1]], team_names[match[2]] ))
except:
print match
return HttpResponse(simplejson.dumps(data), mimetype='application/json')
def load_players(request): # TODO : Gereksiz fazla cagiriliyor olabilir, kontrol et.
if not request.is_ajax():
raise Http404
match_id = 17
match = Match_info(match_id = match_id)
match.save()
teams = get_teams(match_id)
rosters = [None,None]
rosters[0] = get_match_roster(match_id, teams[0][0])
rosters[1] = get_match_roster(match_id, teams[0][1])
players = [list(),list()]
for i in range(len(rosters)):
for element in rosters[i]:
name_string = element[1][0] + ". " + element[2]
players[i].append((name_string,element[3]))
players.append(teams[0])
# TODO: Buradan sonrasi degisecek. Players list'indeki data ile doldur.
# data = load_match_roster_with_id(17)
# data_dict = dict((y, x) for x, y in data)
#
# team_1_id = data_dict.values()[0]
# sql_strings = ["", ""]
# for key, value in data_dict.iteritems():
# if value == team_1_id:
# sql_strings[0] += " PLAYER_ID = " + str(key) + " OR"
# else:
# sql_strings[1] += " PLAYER_ID = " + str(key) + " OR"
#
# team_players = list()
# cursor = connection.cursor()
# sql_string_base = "SELECT PLAYER_FULL_NAME, PLAYER_ID FROM sentiosp_drupal6.td_player WHERE "
# for sql_string in sql_strings:
# sql_string = sql_string_base + sql_string + " FALSE"
# cursor.execute(sql_string)
#
# data = cursor.fetchall()
# data_list = list()
#
# for element in data:
# element_list = list(element)
# element_list[0] = element[0].title()
# data_list.append(element_list)
#
# team_players.append(data_list)
return HttpResponse(simplejson.dumps(players), mimetype='application/json')
def add_matix():
data = xlrd.open_workbook(r'模糊关联实验数据.xlsx')
table = data.sheets()[2]
arr = []
name = []
x = table.row_values(0)[0]
drgnum = {}
rowc = table.nrows
for i in range(rowc + 1):
if i == rowc:
arr.append(drgnum)
else:
if table.row_values(i)[0] != x:
arr.append(drgnum)
drgnum = {}
x = table.row_values(i)[0]
name.append(table.row_values(i)[1] + 'low')
name.append(table.row_values(i)[1] + 'middle')
name.append(table.row_values(i)[1] + 'high')
if table.row_values(i)[3] != 0:
drgnum[table.row_values(i)[1] + 'low'] = table.row_values(i)[3]
if table.row_values(i)[4] != 0:
drgnum[table.row_values(i)[1] +
'middle'] = table.row_values(i)[4]
if table.row_values(i)[5] != 0:
drgnum[table.row_values(i)[1] +
'high'] = table.row_values(i)[5]
name = list(set(name))
name1 = []
for i in name:
s = []
s.append(i)
name1.append(s)
return name1, arr
def update_chart(request):
if not request.is_ajax():
raise Http404
player_info_str = request.GET.getlist('sendValue[]')
slider_values = player_info_str.pop(0).split(';')
player_info = (player.split('-') for player in player_info_str) # Team_id , jersey_num
match_id = Match_info.objects.all().reverse()[0].match_id # Latest match id
# match_min_lower = '0'
# match_min_upper = '90'
match_min_lower = slider_values[0]
match_min_upper = slider_values[1]
data = list()
if(len(player_info_str)):
sql_string_base = "SELECT JERSEY_NUMBER, SUM(DISTANCE) FROM sentiosp_drupal6.tf_match_stats_processed WHERE MATCH_ID = "\
+ str(match_id) + " AND MATCH_MINUTE <= " + match_min_upper \
+ " AND MATCH_MINUTE >= " + match_min_lower
cursor = connection.cursor()
for player in player_info:
sql_string = sql_string_base + " AND JERSEY_NUMBER = " + player[1] + " AND TEAM_ID = " + player[0]
cursor.execute(sql_string)
returned_data = cursor.fetchone()
if returned_data[0] is not None and returned_data[1] is not None:
data.append(returned_data)
print 'test'
# for player in player_info:
# sql_string += "( JERSEY_NUMBER = " + player[1] + " AND TEAM_ID = " + player[0] + " ) OR "
# sql_string += "FALSE )"
# cursor.execute(sql_string)
# returned_data = cursor.fetchall()
# player_ids = request.GET.getlist('sendValue[]')
# sql_string = "SELECT PLAYER_FULL_NAME, PLAYER_ID FROM sentiosp_drupal6.td_player WHERE "
# for id in player_ids:
# sql_string += " PLAYER_ID = " + id + " OR"
# sql_string += " FALSE"
# print sql_string
# cursor = connection.cursor()
# cursor.execute(sql_string)
# data = cursor.fetchall()
return HttpResponse(simplejson.dumps(data), mimetype='application/json')
def makenext(a):
List = []
for i in range(len(a)):
for j in range(i + 1, len(a)):
s = a[i] + a[j]
s1 = list(set(s))
if len(s1) == len(a[i]) + 1:
flat = 0
for k in List:
if set(s1).issubset(k) == True:
flat = 1
if flat == 0:
List.append(s1)
return List
def create_token(instance, created, *args, **kwargs):
from multiprocessing.dummy import list
ALPHABET = list('abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789')
if created:
i = instance.id
if i == 0:
return ALPHABET[0]
s = ''
base = len(ALPHABET)
while i > 0:
s += ALPHABET[i % base]
i /= base
instance.token = s[::-1]
instance.save()
def add_matix():
data=xlrd.open_workbook(r'分组准备表1.xlsx')
dic={}
table=data.sheets()[1]
rowc=table.nrows
for i in range(rowc):
str1=table.row_values(i)[0].strip()
dic[str1]=[]
dic[str1].append(round(table.row_values(i)[1],2))
dic[str1].append(round(table.row_values(i)[2],2))
dic[str1].append(round(table.row_values(i)[3],2))
#print(str,dic[str])
table=data.sheets()[0]
arr=[]
name=[]
x=table.row_values(0)[0]
drgnum={}
rowc=table.nrows
for i in range(rowc+1):
if i==rowc:
arr.append(drgnum)
else:
if table.row_values(i)[0]!=x:
arr.append(drgnum)
drgnum={}
x=table.row_values(i)[0]
name.append(table.row_values(i)[1]+'low('+str(dic[table.row_values(i)[1]][0])+')')
name.append(table.row_values(i)[1]+'middle('+str(dic[table.row_values(i)[1]][1])+')')
name.append(table.row_values(i)[1]+'high('+str(dic[table.row_values(i)[1]][2])+')')
if table.row_values(i)[3]!=0:
drgnum[table.row_values(i)[1]+'low('+str(dic[table.row_values(i)[1]][0])+')']=table.row_values(i)[3]
if table.row_values(i)[4]!=0:
drgnum[table.row_values(i)[1]+'middle('+str(dic[table.row_values(i)[1]][1])+')']=table.row_values(i)[4]
if table.row_values(i)[5]!=0:
drgnum[table.row_values(i)[1]+'high('+str(dic[table.row_values(i)[1]][2])+')']=table.row_values(i)[5]
name = list(set(name))
name1=[]
for i in name:
s=[]
s.append(i)
name1.append(s)
return name1,arr
from multiprocessing.dummy import list
__author__ = 'cingusoft'
ALPHABET = list("abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789")
#Bijective methods for encode and decode id
def url_encode(i):
if i == 0:
return ALPHABET[0]
s = ''
base = len(ALPHABET)
while i > 0:
s += ALPHABET[i % base]
i /= base
return s[::-1]
def url_decode(s):
i = 0
base = len(ALPHABET)
for char in s:
i = i*base+ALPHABET.index(char)
return i
from multiprocessing.dummy import list
__author__ = 'cingusoft'
ALPHABET = list(
"abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789")
#Bijective methods for encode and decode id
def url_encode(i):
if i == 0:
return ALPHABET[0]
s = ''
base = len(ALPHABET)
while i > 0:
s += ALPHABET[i % base]
i /= base
return s[::-1]
def url_decode(s):
i = 0
base = len(ALPHABET)
for char in s:
i = i * base + ALPHABET.index(char)
return i
