def get_all():
all_competitor = []
count = 1
for i in model.competitor.query.filter_by(status=1).all():
i = competitor2dict(i)
i['id'] = count
count += 1
all_competitor.append(i)
all_competitor = random.sample(all_competitor, len(all_competitor))
return all_competitor
def get_range():
range = []
count = 1
for i in model.competitor.query.filter_by(
status=1).order_by("count").all():
i = competitor2dict(i)
i['id'] = count
count += 1
range.append(i)
return range
def get_offline_competitors():
offline_competitors = []
count = 1
for i in model.competitor.query.filter_by(
method=2, status=1).order_by("count").limit(6).all():
i = competitor2dict(i)
i['id'] = count
count += 1
offline_competitors.append(i)
return offline_competitors
def get_detail(name,position):
cur_competitor = competitor.query.filter_by(name=name,position=position).all()[0]
cur_messages = cur_competitor.message
messages = []
for message in cur_messages:
message = message2dict(message)
messages.append(message)
cur_competitor = competitor2dict(cur_competitor)
#return dumps(dict(messages=messages,competitor=cur_competitor))
return render_template('userInfo.html',competitor=cur_competitor,messages=messages)
def login():
if request.method == 'GET':
return render_template('login.html')
phone = request.form['phone']
password = request.form['password']
cur_reference = reference.query.filter_by(phone=phone, password=password).all()[0]
if cur_reference is not None:
competitor = competitor2dict(cur_reference.competitor[0])
#return dumps(competitor)
return render_template('edit.html', competitor=competitor,reference=cur_reference)
return dumps({'statu': 1})
def get_detail_1(phone):
cur_reference = reference.query.filter_by(phone=phone).all()[0]
cur_competitor = cur_reference.competitor[0]
cur_messages = cur_competitor.message
messages = []
for message in cur_messages:
message = message2dict(message)
messages.append(message)
cur_competitor = competitor2dict(cur_competitor)
#return dumps(dict(messages=messages, competitor=cur_competitor))
return render_template('userInfo.html',competitor=cur_competitor,messages=messages)