def user_get_friend():
if "token" not in request.args:
error = {"status": -1, "message": u"非法请求(未找到token字段)"}
resp = jsonify(error)
return resp
token = request.args['token']
db = sql.UserHelper()
user = db.get_user_by_token(str(token))
if len(user) == 0:
error = {"status": -2, "message": u"用户不存在,请重新登录"}
resp = jsonify(error)
return resp
user = user[0]
phone = user[0]
friends = db.get_friend(phone)
active_list = []
for value in friends:
phone = value[0]
rphone = value[1]
list_item = {"phone": phone, "rphone": rphone}
active_list.append(list_item)
res = {"status": 0, "message": "获取成功", "list": active_list}
print res
return jsonify(res)
def active_comment():
if "token" not in request.args:
error = {"status": -1, "message": u"非法请求(未找到token字段)"}
resp = jsonify(error)
return resp
if "id" not in request.args:
error = {"status": -1, "message": u"非法请求(未找到ID字段)"}
resp = jsonify(error)
return resp
token = request.args['token']
active_id = request.args['id']
content = request.args['content']
db = sql.UserHelper()
user = db.get_user_by_token(str(token))
if len(user) == 0:
error = {"status": -2, "message": u"用户不存在,请重新登录"}
resp = jsonify(error)
return resp
user = user[0]
phone = user[0]
nick_name = user[6]
if nick_name is None:
nick_name = phone
db.comment_active(active_id, nick_name, content)
res = {"status": 0, "message": "评论成功"}
return jsonify(res)
def api_register():
if "phone" not in request.args:
error = {"status": -1, "message": u"非法请求(未找到phone字段)"}
resp = jsonify(error)
return resp
if "password" not in request.args:
error = {"status": -1, "message": u"非法请求(未找到password字段)"}
resp = jsonify(error)
return resp
phone = request.args['phone']
psd = request.args['password']
db = sql.UserHelper()
user = db.get_user(phone)
ct = utils.get_current_time()
if len(user) == 0:
time = ct + token_time
token = utils.get_md5(phone + psd + str(time))
db.save_user(phone, psd, token, time)
res = {
"token": token,
"time": time,
"message": u"注册成功",
"phone": phone
}
db.save_user_coin(token, 30, 0)
return jsonify(res)
else:
error = {"status": -1, "message": u"账号已存在"}
return jsonify(error)
def daikuan_user_coin():
if "token" not in request.args:
error = {"status": -1, "message": u"非法请求(未找到token字段)"}
resp = jsonify(error)
return resp
if "url" in request.args:
url = request.args['url']
else:
url = None
token = request.args['token']
db = sql.UserHelper()
user = db.get_user_by_token(str(token))
if len(user) == 0:
error = {"status": -2, "message": u"用户不存在,请重新登录"}
resp = jsonify(error)
return resp
user = user[0]
phone = user[0]
blue_coin = float(user[4])
orange_coin = float(user[5])
if blue_coin is None:
blue_coin = 0.00
if orange_coin is None:
orange_coin = 0.00
db.save_loan(phone, "30")
res = {
"status": 0,
"blue_coin": blue_coin,
"orange_coin": orange_coin,
"message": u"申请贷款成功,审核通过后到账"
}
return jsonify(res)
def user_delete_friend():
if "token" not in request.args:
error = {"status": -1, "message": u"非法请求(未找到token字段)"}
resp = jsonify(error)
return resp
if "rphone" not in request.args:
error = {"status": -1, "message": u"非法请求(未找到phone字段)"}
resp = jsonify(error)
return resp
token = request.args['token']
rphone = request.args['rphone']
db = sql.UserHelper()
user = db.get_user_by_token(str(token))
if len(user) == 0:
error = {"status": -2, "message": u"用户不存在,请重新登录"}
resp = jsonify(error)
return resp
user = user[0]
phone = user[0]
# if phone == rphone:
# error = {"status": -1, "message": u"不能自己添加自己为好友"}
# resp = jsonify(error)
# return resp
db.delete_friend(phone, rphone)
error = {"status": 0, "message": u"删除好友成功"}
resp = jsonify(error)
return resp
def loan_list():
db = sql.UserHelper()
loans = db.get_loan("1")
if len(loans) == 0:
return render_template("loan.html", loans=[])
return render_template("loan.html", loans=loans)
def api_login():
if "phone" not in request.args:
error = {"status": -1, "message": u"非法请求(未找到phone字段)"}
resp = jsonify(error)
return resp
if "password" not in request.args:
error = {"status": -1, "message": u"非法请求(未找到password字段)"}
resp = jsonify(error)
return resp
phone = request.args['phone']
psd = request.args['password']
db = sql.UserHelper()
user = db.get_user(phone)
ct = utils.get_current_time()
if len(user) == 0:
res = {"status": -1, "message": u"用户不存在"}
return jsonify(res)
else:
user = user[0]
phone = user[0]
password = user[1]
token = user[2]
time = user[3]
title = user[6]
profile = user[7]
head = user[8]
if not password == psd:
error = {"status": -1, "message": u"密码错误"}
return jsonify(error)
else:
if ct > long(time):
time = ct + token_time
token = utils.get_md5(phone + psd + str(time))
db.save_user_token(phone, token)
res = {
"token": token,
"time": time,
"message": "登录成功",
"phone": phone,
"title": title,
"profile": profile,
"head": head
}
return jsonify(res)
else:
res = {
"token": token,
"time": time,
"message": "登录成功",
"phone": phone,
"title": title,
"profile": profile,
"head": head
}
return jsonify(res)
def loan_submit():
loan_id = request.args['id']
db = sql.UserHelper()
db.finish_loan(loan_id)
need_deal_loan = db.get_loan_by_id(loan_id)[0]
phone = need_deal_loan[1]
money = need_deal_loan[2]
finish_user_loan(phone, money)
loans = db.get_loan("1")
return render_template("loan.html", loans=loans)
def user_pay():
if "token" not in request.args:
error = {"status": -1, "message": u"非法请求(未找到token字段)"}
resp = jsonify(error)
return resp
if "phone" not in request.args:
error = {"status": -1, "message": u"非法请求(未找到phone字段)"}
resp = jsonify(error)
return resp
if "money" not in request.args:
error = {"status": -1, "message": u"非法请求(未找到money字段)"}
resp = jsonify(error)
return resp
if "id" not in request.args:
error = {"status": -1, "message": u"非法请求(未找到id字段)"}
resp = jsonify(error)
return resp
token = request.args['token']
to_phone = request.args['phone']
to_money = float(request.args['money'])
active_id = request.args['id']
db = sql.UserHelper()
user = db.get_user_by_token(str(token))
if len(user) == 0:
error = {"status": -2, "message": u"用户不存在,请重新登录"}
resp = jsonify(error)
return resp
user = user[0]
phone = user[0]
if phone == to_phone:
error = {"status": -1, "message": u"不能自己向自己请求付时间"}
resp = jsonify(error)
return resp
to_user = db.get_user(to_phone)
if len(to_user) == 0:
error = {"status": -1, "message": u"支付的用户不存在"}
resp = jsonify(error)
return resp
db.save_active_pay_request(active_id, phone, to_phone, to_money)
db.update_active_status(active_id, "2")
error = {"status": 0, "message": u"发起收款请求成功,对方付款后会直接将时间打到你的账户"}
resp = jsonify(error)
return resp
def get_active():
if "token" not in request.args:
error = {"status": -1, "message": u"非法请求(未找到token字段)"}
resp = jsonify(error)
return resp
if "type" not in request.args:
get_type = 0
else:
get_type = request.args['type']
db = sql.UserHelper()
if "city" not in request.args:
actives = db.get_active(get_type)
else:
actives = db.get_active_with_area(get_type, request.args['city'])
if len(actives) == 0:
res = {"status": 0, "list": []}
print res
return jsonify(res)
else:
active_list = []
for value in actives:
id = value[0]
phone = value[1]
title = value[2]
profile = value[3]
cost = value[4]
address = value[5]
detail = value[6]
time = value[7]
url = value[8]
active_type = value[9]
status = value[11]
list_item = {
"id": id,
"phone": phone,
"title": title,
"profile": profile,
"cost": cost,
"address": address,
"detail": detail,
"time": time,
"url": url,
"type": active_type,
"status": status
}
active_list.append(list_item)
res = {"status": 0, "message": "获取成功", "list": active_list}
print res
return jsonify(res)
def finish_user_loan(loan_phone, loan_money):
db = sql.UserHelper()
user = db.get_user(str(loan_phone))
if len(user) == 0:
error = {"status": -2, "message": u"用户不存在,请重新登录"}
resp = jsonify(error)
return resp
user = user[0]
print user
token = user[2]
blue_coin = float(user[4])
orange_coin = float(user[5])
if blue_coin is None:
blue_coin = 0.00
if orange_coin is None:
orange_coin = 0.00
blue_coin = blue_coin + float(loan_money)
db.save_user_coin(token, blue_coin, orange_coin)
db.save_transaction_history(user[0], u"时间贷款", 30, 1, None)
def save_user_information():
if "token" not in request.args:
error = {"status": -1, "message": u"非法请求(未找到token字段)"}
resp = jsonify(error)
return resp
token = request.args['token']
db = sql.UserHelper()
user = db.get_user_by_token(str(token))
if len(user) == 0:
error = {"status": -2, "message": u"用户不存在,请重新登录"}
resp = jsonify(error)
return resp
db.save_user_info(request.args['title'], request.args['profile'],
request.args['head'], request.args['type'],
request.args['mobile'], request.args['card'], token)
res = {"status": 0, "message": "上传成功"}
print res
return jsonify(res)
def save_active():
if "token" not in request.args:
error = {"status": -1, "message": u"非法请求(未找到token字段)"}
resp = jsonify(error)
return resp
token = request.args['token']
title = request.args['title']
profile = request.args['profile']
cost = request.args['cost']
address = request.args['address']
detail_address = request.args['details']
time = request.args['time']
url = request.args['url']
active_type = request.args['kind']
if 'id' not in request.args:
active_id = None
else:
active_id = request.args['id']
db = sql.UserHelper()
user = db.get_user_by_token(str(token))
if len(user) == 0:
error = {"status": -2, "message": u"用户不存在,请重新登录"}
resp = jsonify(error)
return resp
user = user[0]
phone = user[0]
if active_id is not None:
db.update_active(active_id, phone, title, profile, cost, address,
detail_address, time, url, active_type)
error = {"status": 0, "message": u"更新活动成功"}
resp = jsonify(error)
else:
db.save_active(phone, title, profile, cost, address, detail_address,
time, url, active_type)
error = {"status": 0, "message": u"添加活动成功"}
resp = jsonify(error)
return resp
def user_transactio_history():
if "token" not in request.args:
error = {"status": -1, "message": u"非法请求(未找到token字段)"}
resp = jsonify(error)
return resp
token = request.args['token']
db = sql.UserHelper()
user = db.get_user_by_token(str(token))
if len(user) == 0:
error = {"status": -2, "message": u"用户不存在,请重新登录"}
resp = jsonify(error)
return resp
user = user[0]
print user
phone = user[0]
histories = db.get_transaction_history(phone)
if len(histories) == 0:
res = {"status": 0, "list": [], "message": "暂无记录"}
return jsonify(res)
else:
history_list = []
for value in histories:
phone = value[0]
title = value[1]
count = value[2]
pay_type = value[3]
list_item = {
"phone": phone,
"title": title,
"count": count,
"type": pay_type
}
history_list.append(list_item)
res = {"status": 0, "message": "获取成功", "list": history_list}
return jsonify(res)
def get_user_coin():
if "token" not in request.args:
error = {"status": -1, "message": u"非法请求(未找到token字段)"}
resp = jsonify(error)
return resp
token = request.args['token']
db = sql.UserHelper()
user = db.get_user_by_token(str(token))
if len(user) == 0:
error = {"status": -2, "message": u"用户不存在,请重新注册"}
resp = jsonify(error)
return resp
user = user[0]
if len(user) > 5:
blue_coin = user[4]
orange_coin = user[5]
title = user[6]
profile = user[7]
head = user[8]
if blue_coin is None:
blue_coin = 0.00
if orange_coin is None:
orange_coin = 0.00
res = {
"status": 0,
"blue_coin": blue_coin,
"orange_coin": orange_coin,
"title": title,
"profile": profile,
"head": head
}
return jsonify(res)
else:
res = {"status": 0, "blue_coin": 0.00, "orange_coin": 0.00}
return jsonify(res)
def user_get_friend_actives():
if "token" not in request.args:
error = {"status": -1, "message": u"非法请求(未找到token字段)"}
resp = jsonify(error)
return resp
token = request.args['token']
db = sql.UserHelper()
user = db.get_user_by_token(str(token))
if len(user) == 0:
error = {"status": -2, "message": u"用户不存在,请重新登录"}
resp = jsonify(error)
return resp
user = user[0]
phone = user[0]
friends = db.get_my_friend_active(phone)
active_list = []
for value in friends:
active_id = value[0]
phone = value[1]
active_title = value[2]
active_profile = value[3]
cost = value[4]
address = value[5]
details_address = value[6]
time = value[7]
url = value[8]
active_type = value[9]
post_time = value[10]
head = value[17]
title = value[18]
profile = value[19]
list_item = {
"id": active_id,
"phone": phone,
"active_title": active_title,
"active_profile": active_profile,
"cost": cost,
"address": address,
"details_address": details_address,
"time": time,
"url": url,
"type": active_type,
"post_time": post_time,
"head": head,
"title": title,
"profile": profile
}
likes = db.get_active_like(active_id)
if len(likes) == 0:
list_item['likes'] = []
else:
likes_item = []
for like in likes:
nick_name = like[2]
likes_item.append(nick_name)
list_item['likes'] = likes_item
comments = db.get_active_comment(active_id)
if len(comments) == 0:
list_item["comments"] = []
else:
comment_item = []
for comment in comments:
comment_people = comment[1]
content = comment[2]
item = {"name": comment_people, "content": content}
comment_item.append(item)
list_item["comments"] = comment_item
active_list.append(list_item)
res = {"status": 0, "message": "获取成功", "list": active_list}
print res
return jsonify(res)
def user_transfer():
if "token" not in request.args:
error = {"status": -1, "message": u"非法请求(未找到token字段)"}
resp = jsonify(error)
return resp
if "phone" not in request.args:
error = {"status": -1, "message": u"非法请求(未找到phone字段)"}
resp = jsonify(error)
return resp
if "money" not in request.args:
error = {"status": -1, "message": u"非法请求(未找到money字段)"}
resp = jsonify(error)
return resp
token = request.args['token']
to_phone = request.args['phone']
to_money = float(request.args['money'])
db = sql.UserHelper()
user = db.get_user_by_token(str(token))
if len(user) == 0:
error = {"status": -2, "message": u"用户不存在,请重新登录"}
resp = jsonify(error)
return resp
user = user[0]
phone = user[0]
if phone == to_phone:
error = {"status": -1, "message": u"不能自己给自己转入时间"}
resp = jsonify(error)
return resp
to_user = db.get_user(to_phone)
if len(to_user) == 0:
error = {"status": -1, "message": u"转出的用户不存在"}
resp = jsonify(error)
return resp
blue_coin = float(user[4])
orange_coin = float(user[5])
print "谁转的信息%s,%s" % (blue_coin, orange_coin)
if blue_coin is None:
blue_coin = 0.0
if orange_coin is None:
orange_coin = 0.0
if blue_coin + orange_coin < to_money:
error = {"status": -1, "message": u"转出时间超出限额"}
resp = jsonify(error)
return resp
if blue_coin > to_money:
blue_coin = blue_coin - to_money
db.save_user_coin(token, blue_coin, orange_coin)
elif blue_coin < to_money:
blue_coin = 0.0
orange_coin = orange_coin + blue_coin - to_money
db.save_user_coin(token, 0.0, orange_coin)
else:
blue_coin = 0.0
orange_coin = orange_coin
db.save_user_coin(token, 0.0, orange_coin)
db.save_transaction_history(phone,
str(phone) + u"转账给" + str(to_phone), to_money,
0, None)
db.save_transaction_history(to_phone,
str(to_phone) + u"从" + str(phone) + u"入账",
to_money, 1, None)
to_user = to_user[0]
to_blue_coin = float(to_user[4])
to_orange_coin = float(to_user[5])
if to_blue_coin is None:
to_blue_coin = 0.00
if to_orange_coin is None:
to_orange_coin = 0.00
db.save_user_coin(to_user[2], to_blue_coin + to_money, to_orange_coin)
error = {
"status": 0,
"message": u"转出时间成功",
"blue_coin": blue_coin,
"orange_coin": orange_coin
}
resp = jsonify(error)
return resp
def user_get_money():
if "token" not in request.args:
error = {"status": -1, "message": u"非法请求(未找到token字段)"}
resp = jsonify(error)
return resp
if "phone" not in request.args:
error = {"status": -1, "message": u"非法请求(未找到phone字段)"}
resp = jsonify(error)
return resp
if "money" not in request.args:
error = {"status": -1, "message": u"非法请求(未找到money字段)"}
resp = jsonify(error)
return resp
if "reason" not in request.args:
error = {"status": -1, "message": u"非法请求(未找到reason字段)"}
resp = jsonify(error)
return resp
token = request.args['token']
from_phone = request.args['phone']
from_money = float(request.args['money'])
reason = request.args['reason']
if "url" in request.args:
url = request.args['url']
else:
url = None
db = sql.UserHelper()
user = db.get_user_by_token(str(token))
if len(user) == 0:
error = {"status": -2, "message": u"用户不存在,请重新登录"}
resp = jsonify(error)
return resp
user = user[0]
phone = user[0]
if phone == from_phone:
error = {"status": -1, "message": u"不能自己给自己付时间"}
resp = jsonify(error)
return resp
from_user = db.get_user(from_phone)
if len(from_user) == 0:
error = {"status": -1, "message": u"该收款码的用户不存在"}
resp = jsonify(error)
return resp
from_user = from_user[0]
from_token = from_user[2]
blue_coin = float(from_user[4])
orange_coin = float(from_user[5])
print "谁收的信息%s,%s" % (blue_coin, orange_coin)
if blue_coin is None:
blue_coin = 0.0
if orange_coin is None:
orange_coin = 0.0
if blue_coin + orange_coin < from_money:
error = {"status": -1, "message": u"对方时间额度不足"}
resp = jsonify(error)
return resp
if blue_coin > from_money:
blue_coin = blue_coin - from_money
db.save_user_coin(from_token, blue_coin, orange_coin)
elif blue_coin < from_money:
blue_coin = 0.0
orange_coin = orange_coin + blue_coin - from_money
db.save_user_coin(from_token, 0.0, orange_coin)
else:
blue_coin = 0.0
orange_coin = orange_coin
db.save_user_coin(from_token, blue_coin, orange_coin)
db.save_transaction_history(phone, u"二维码收款:" + reason, from_money, 1, url)
db.save_transaction_history(from_phone, u"二维码付款:" + reason, from_money, 0,
url)
to_blue_coin = float(user[4])
to_orange_coin = float(user[5])
if to_blue_coin is None:
to_blue_coin = 0.00
if to_orange_coin is None:
to_orange_coin = 0.00
db.save_user_coin(token, to_blue_coin + from_money, to_orange_coin)
error = {
"status": 0,
"message": u"收时间成功",
"blue_coin": to_blue_coin + from_money,
"orange_coin": to_orange_coin
}
resp = jsonify(error)
return resp
def pay_for():
if "token" not in request.args:
error = {"status": -1, "message": u"非法请求(未找到token字段)"}
resp = jsonify(error)
return resp
if "phone" not in request.args:
error = {"status": -1, "message": u"非法请求(未找到phone字段)"}
resp = jsonify(error)
return resp
if "money" not in request.args:
error = {"status": -1, "message": u"非法请求(未找到money字段)"}
resp = jsonify(error)
return resp
if "id" not in request.args:
error = {"status": -1, "message": u"非法请求(未找到id字段)"}
resp = jsonify(error)
return resp
token = request.args['token']
money = float(request.args['money'])
active_id = request.args['id']
db = sql.UserHelper()
user = db.get_user_by_token(str(token))
if len(user) == 0:
error = {"status": -2, "message": u"用户不存在,请重新登录"}
resp = jsonify(error)
return resp
user = user[0]
phone = user[0]
active_request = db.get_active_pa_request(phone)
if len(active_request) == 0:
error = {"status": -2, "message": u"活动的支付信息未找到"}
resp = jsonify(error)
return resp
to_phone = active_request[0][2]
db.update_active_status(active_id, "3")
to_user = db.get_user(to_phone)
if len(to_user) == 0:
error = {"status": -1, "message": u"支付的用户不存在"}
resp = jsonify(error)
return resp
blue_coin = float(user[4])
orange_coin = float(user[5])
print "谁转的信息%s,%s" % (blue_coin, orange_coin)
if blue_coin is None:
blue_coin = 0.0
if orange_coin is None:
orange_coin = 0.0
if blue_coin + orange_coin < money:
error = {"status": -1, "message": u"支付时间超出限额"}
resp = jsonify(error)
return resp
if blue_coin > money:
blue_coin = blue_coin - money
db.save_user_coin(token, blue_coin, orange_coin)
elif blue_coin < money:
orange_coin = orange_coin + blue_coin - money
db.save_user_coin(token, 0.0, orange_coin)
blue_coin = 0.0
else:
blue_coin = 0.0
orange_coin = orange_coin
db.save_user_coin(token, 0.0, orange_coin)
db.save_transaction_history(phone, u"活动支出", money, 0, None)
db.save_transaction_history(to_phone, u"活动收入", money, 1, None)
to_user = to_user[0]
to_blue_coin = float(to_user[4])
to_orange_coin = float(to_user[5])
if to_blue_coin is None:
to_blue_coin = 0.00
if to_orange_coin is None:
to_orange_coin = 0.00
db.save_user_coin(to_user[2], to_blue_coin + money, to_orange_coin)
error = {
"status": 0,
"message": u"支付时间成功",
"blue_coin": blue_coin,
"orange_coin": orange_coin
}
resp = jsonify(error)
return resp
