def get_Col(spreadsheetId, rangeName):
service = google_get_credentials.get_service()
result = service.spreadsheets().values().get(spreadsheetId=spreadsheetId, range=rangeName, majorDimension="COLUMNS").execute()
google_value = result.get('values', [])
# for x in google_value:
# level_type.append(x[0]) # foodid列数据转化格式
return google_value
def get_tragetads(self, spreadsheetId, rangeName):
foodid = []
service = google_get_credentials.get_service()
result = service.spreadsheets().values().get(spreadsheetId=spreadsheetId, range=rangeName).execute()
google_value = result.get('values', [])
for x in google_value:
foodid.append(x[0]) # foodid列数据转化格式
return foodid
def get_timeline_type(self, spreadsheetId, rangeName):
level_type = []
service = google_get_credentials.get_service()
result = service.spreadsheets().values().get(spreadsheetId=spreadsheetId, range=rangeName).execute()
google_value = result.get('values', [])
# for x in google_value:
# level_type.append(x[0]) # foodid列数据转化格式
return google_value
def get_timeline_istime(self, spreadsheetId, rangeName):
istime = []
service = google_get_credentials.get_service()
result = service.spreadsheets().values().get(spreadsheetId=spreadsheetId, range=rangeName).execute()
google_value = result.get('values', [])
# print google_value
for x in google_value:
if x:
x = 0
istime.append(x) # foodid列数据转化格式
return istime
def get_guidefood(self, spreadsheetId, rangeName, col_food):
dic1 = {}
service = google_get_credentials.get_service()
result = service.spreadsheets().values().get(spreadsheetId=spreadsheetId, range=rangeName).execute()
guide_foodvalue = result.get('values', [])
for y in guide_foodvalue:
if len(y) == int(col_food) + 1:
dic1[y[0]] = y[int(col_food)]
# print "食物id：引导id"
# print dic1
return dic1
def get_food_name_map(self, spreadsheetId, rangeName):
food_result = []
try:
service = google_get_credentials.get_service()
result = service.spreadsheets().values().get(spreadsheetId=spreadsheetId, range=rangeName).execute()
food_name_map = result.get('values', [])
for values in food_name_map:
food_result.append(values[0])
# print (food_result)
return food_result
except Exception, e:
raise e
def get_food_name_map(self, spreadsheetId, rangeName):
food_result = []
try:
service = google_get_credentials.get_service()
result = service.spreadsheets().values().get(spreadsheetId=spreadsheetId, range=rangeName).execute()
food_name_map = result.get('values', [])
for values in food_name_map:
food_result.append(values[0])
# print (food_result)
return food_result
except Exception, e:
raise e
def get_food_name_map():
spreadsheetId = "16zNo9Sp9c8kYu4UQLtxKhdxJqIwFMYI27n7Z4sesxew" # google后缀设计4
rangeName = "食物!B3:B47"
food_result = []
try:
service = google_get_credentials.get_service()
result = service.spreadsheets().values().get(spreadsheetId=spreadsheetId, range=rangeName).execute()
food_name_map = result.get('values', [])
for values in food_name_map:
food_result.append(values[0])
print (food_result)
return food_result
except Exception, e:
raise e
def get_guidelevel(self, spreadsheetId, rangeName, col_level):
guidelevel = []
guidefood = []
food = []
dic = {}
service = google_get_credentials.get_service()
result = service.spreadsheets().values().get(spreadsheetId=spreadsheetId, range=rangeName).execute()
guide_levelvalue = result.get('values', [])
for x in guide_levelvalue:
if len(x) == int(col_level) + 1:
dic[x[int(col_level)]] = x[0]
# print "食物id：关卡id"
# print dic
return dic
def get_food_name_map():
spreadsheetId = "16zNo9Sp9c8kYu4UQLtxKhdxJqIwFMYI27n7Z4sesxew" # google后缀设计4
rangeName = "食物!B3:B47"
food_result = []
try:
service = google_get_credentials.get_service()
result = service.spreadsheets().values().get(
spreadsheetId=spreadsheetId, range=rangeName).execute()
food_name_map4 = result.get('values', [])
for values in food_name_map4:
food_result.append(values[0])
print(food_result)
return food_result
except Exception, e:
raise e
def scence1(self, spreadsheetId, rangeName):
food_result = []
try:
service = google_get_credentials.get_service()
result = service.spreadsheets().values().get(spreadsheetId=spreadsheetId, range=rangeName).execute()
food_name_map4 = result.get('values', [])
for x in xrange(0, len(food_name_map4[0])):
num = 0
for values in food_name_map4:
# print values[x]
if values[x]:
num = num + 1
food_result.append(num)
except Exception, e:
raise e
def get_timeline_name(self, spreadsheetId, rangeName):
food_result = []
try:
service = google_get_credentials.get_service()
result = service.spreadsheets().values().get(spreadsheetId=spreadsheetId, range=rangeName).execute()
google_value = result.get('values', [])
for values in google_value:
food_result_value = []
for foodname in values:
food_result_value.append(foodname)
food_result.append(food_result_value)
# print (food_result[8])
return food_result
except Exception, e:
print (e)
def get_timeline_name(self, spreadsheetId, rangeName):
food_result = []
try:
service = google_get_credentials.get_service()
result = service.spreadsheets().values().get(spreadsheetId=spreadsheetId, range=rangeName).execute()
google_value = result.get('values', [])
for values in google_value:
food_result_value = []
for foodname in values:
food_result_value.append(foodname)
food_result.append(food_result_value)
# print (food_result[8])
return food_result
except Exception, e:
print (e)
def get_timeline_allfood_count(self, spreadsheetId, rangeName):
allfood_arr = []
service = google_get_credentials.get_service()
result = service.spreadsheets().values().get(spreadsheetId=spreadsheetId, range=rangeName, majorDimension="COLUMNS").execute()
google_value = result.get('values', [])
for values in google_value:
food_count = 0
for foodname in values:
foodname = foodname.split(",")
if len(foodname) > 1: # 前两个字符没用，删了增加效率
del foodname[1]
del foodname[0]
# print food_count, len(foodname)
food_count += len(foodname)
# print food_count, foodname, len(foodname)
allfood_arr.append(food_count - 1) # 去掉关卡ID
return allfood_arr
def get_timeline_name():
spreadsheetId = "1mNCquKhkZtt99CfstAx0PWq27zsASlMWNLHfa0eWeP4" # map4
rangeName = "Timeline!D1:BK34"
food_result = []
try:
service = google_get_credentials.get_service()
result = service.spreadsheets().values().get(spreadsheetId=spreadsheetId, range=rangeName).execute()
google_value = result.get('values', [])
for values in google_value:
food_result_value = []
for foodname in values:
food_result_value.append(foodname)
food_result.append(food_result_value)
#print (food_result[8])
return food_result
except Exception, e:
print (e)
def check_sum(self, spreadsheetId, rangeName):
r_sum = []
service = google_get_credentials.get_service()
result = service.spreadsheets().values().get(spreadsheetId=spreadsheetId, range=rangeName).execute()
food_name_map4 = result.get('values', [])
for values in food_name_map4:
r_result = []
for n in xrange(0, len(values), 4):
x = values[n]
if x != '0':
num = 1
else:
num = 0
r_result.append(num)
r_sum.append(sum(r_result))
return(r_sum)
def check_sum(self, spreadsheetId, rangeName):
r_sum = []
service = google_get_credentials.get_service()
result = service.spreadsheets().values().get(spreadsheetId=spreadsheetId, range=rangeName).execute()
food_name_map4 = result.get('values', [])
for values in food_name_map4:
r_result = []
for n in xrange(0, len(values), 4):
x = values[n]
if x != '0':
num = 1
else:
num = 0
r_result.append(num)
r_sum.append(sum(r_result))
return(r_sum)
def check_upgrade():
global slot5
dict_value = {}
spreadsheet_id = slot5["slot5map1"]["spreadsheet_id"]
for_range = int(slot5["slot5map1"]["for_range"])
append_range = slot5["slot5map1"]["append_range"]
for i in range(1, for_range):
dict_value[i] = {}
range_names = []
range_names.append("upgrade!B4:B" + str(append_range)) # map1 83
range_names.append("upgrade!c4:c" + str(append_range)) # map4 93
range_names.append("upgrade!i4:I" + str(append_range)) # map2 81
range_names.append("upgrade!j4:j" + str(append_range)) # map3 90
range_names.append("upgrade!A4:A" + str(append_range)) #
# range_names.append("upgrade!m4:m48") # 经验
service = google_get_credentials.get_service()
re = service.spreadsheets().values().batchGet(
spreadsheetId=spreadsheet_id, ranges=range_names).execute()
result = re.get('valueRanges', [])
for i in range(1, for_range):
row_value = []
for line in result:
value = line.get('values', [])
# print value, len(value)
row_value.append(value[i])
dict_value[i]["id"] = row_value[0]
dict_value[i]["level"] = row_value[1]
dict_value[i]["cash"] = row_value[2]
dict_value[i]["diamond"] = row_value[3]
dict_value[i]["name"] = row_value[4]
# dict_value[i]["exp"] = row_value[4]
return dict_value
def scence1(self, spreadsheetId, rangeName):
food_result = []
try:
service = google_get_credentials.get_service()
result = service.spreadsheets().values().get(spreadsheetId=spreadsheetId, range=rangeName).execute()
food_name_map4 = result.get('values', [])
# print food_name_map4
for x in xrange(0, len(food_name_map4[0])):
num = 0
# print len(food_name_map4[0])
for values in food_name_map4:
if(len(values) > x): # 处理越界的问题
try:
if values[x]:
num = num + 1
except Exception, e:
print e, len(values), x, values[x]
else:
pass
food_result.append(num)
# print len(values), x, num, len(food_result), values[x]
except Exception, e:
# raise e
print e
