def get():
resp_suc = success_dic().dic
resp_fail = fail_dic().dic
resp_suc['list'] = []
resp_suc = get_province_city(resp_suc)
return resp_suc
def get():
"""
activity_id: 活动id
"""
parser = reqparse.RequestParser()
parser.add_argument('activity_id', type=str, required=True, help=u'activity_id 必须')
parser.add_argument('user_id', type=str, required=True, help=u'user_id 必须')
args = parser.parse_args()
activity_id = args['activity_id']
user_id = args['user_id']
success = success_dic().dic
fail = fail_dic().dic
success['activity_picture'] = []
activity = get_activity_by_id(activity_id, user_id)
if activity:
result = get_activity_picture(activity_id)
if type(result) is list:
success['activity_picture'] = result
else:
success['activity_picture'].append(result)
success['activity'] = activity
return success
else:
return fail
def get():
"""
参数
content: 反馈内容
user_id: 登录用户id
"""
parser = reqparse.RequestParser()
parser.add_argument('content', type=str, required=True, help=u'content必须。')
parser.add_argument('user_id', type=str, required=True, help=u'user_id必须。')
args = parser.parse_args()
resp_suc = success_dic().dic
resp_fail = fail_dic().dic
content = args['content']
user_id = args['user_id']
feed_back = FeedBack(content=content, user_id=user_id)
try:
db.add(feed_back)
db.commit()
except:
return resp_fail
return resp_suc
def get():
success = success_dic().dic
city = get_city()
success['city'] = city
return success
def get():
"""
参数：
user_id：用户登录id
"""
parser = reqparse.RequestParser()
parser.add_argument('user_id', type=str, required=True, help=u'user_id必须.')
args = parser.parse_args()
user_id = args['user_id']
resp_suc = success_dic().dic
resp_fail = fail_dic().dic
message_count = Message.query.filter(Message.receiver_id == user_id).count()
if message_count > 1:
messages = Message.query.filter(Message.receiver_id == user_id).all()
for message in messages:
db.delete(message)
try:
db.commit()
except:
return resp_fail
return resp_suc
else:
message = Message.query.filter(Message.receiver_id == user_id).first()
db.delete(message)
try:
db.commit()
except:
return resp_fail
return resp_suc
def get():
"""
参数
receiver_id: 接受用户id
sender_id: 发送用户id
"""
parser = reqparse.RequestParser()
parser.add_argument('sender_id', type=str, required=True, help=u'sender_id必须')
parser.add_argument('receiver_id', type=str, required=True, help=u'receiver_id必须')
args = parser.parse_args()
resp_suc = success_dic().dic
resp_fail = fail_dic().dic
resp_suc['list'] = []
sender_id = args['sender_id']
receiver_id = int(args['receiver_id'])
#message_count = db.query(Message).\
# filter((Message.sender_id == sender_id, Message.receiver_id == receiver_id) | (Message.sender_id == receiver_id, Message.receiver_id == sender_id)).count()
message_count = Message.query.filter(or_(and_(Message.sender_id == sender_id, Message.receiver_id == receiver_id, Message.delete_id != receiver_id), and_(Message.sender_id == receiver_id, Message.receiver_id == sender_id, Message.delete_id != receiver_id))).count()
if message_count > 1:
message = Message.query.filter(or_(and_(Message.sender_id == sender_id, Message.receiver_id == receiver_id, Message.delete_id != receiver_id), and_(Message.sender_id == receiver_id, Message.receiver_id == sender_id, Message.delete_id != receiver_id))).order_by(Message.time).all()
traverse_user_sender_messages(message, resp_suc, receiver_id)
else:
message = Message.query.filter(or_(and_(Message.sender_id == sender_id, Message.receiver_id == receiver_id, Message.delete_id != receiver_id), and_(Message.sender_id == receiver_id, Message.receiver_id == sender_id, Message.delete_id != receiver_id))).order_by(Message.time).first()
if message:
traverse_user_sender_one(message, resp_suc, receiver_id)
else:
resp_suc['message'] = '没有数据'
return resp_suc
def get():
"""
参数
1.pub_id：酒吧id
2.user_id： 登录用户id
"""
parser = reqparse.RequestParser()
parser.add_argument('pub_id', type=str, required=True, help=u'pub_id 必须')
parser.add_argument('user_id', type=str, required=True, help=u'user_id 必须')
args = parser.parse_args()
success = success_dic().dic
fail = fail_dic().dic
pub_id = args['pub_id']
user_id = args['user_id']
collect = Collect.query.filter(Collect.user_id == user_id, Collect.pub_id == pub_id).first()
try:
db.delete(collect)
db.commit()
return success
except:
return fail
def get():
"""
参数
longitude: 经度
latitude: 维度
"""
parser = reqparse.RequestParser()
parser.add_argument('longitude', type=str, required=True, help=u'longitude必须')
parser.add_argument('latitude', type=str, required=True, help=u'latitude必须')
parser.add_argument('page', type=str, required=True, help=u'page当前页必须')
parser.add_argument('user_id', type=str, required=False)
args = parser.parse_args()
longitude = float(args['longitude'])
latitude = float(args['latitude'])
page = int(args['page'])
user_id = args.get('user_id', 0)
resp_suc = success_dic().dic
resp_suc['pub_list'] = []
scope = 5000
pubs = Pub.query.filter().all()
longitude_left = longitude + 0.00001 * scope
longitude_right = longitude - 0.00001 * scope
latitude_top = latitude + 0.00001 * 1.1 * scope
latitude_bottom = latitude - 0.00001 * 1.1 * scope
distance = get_distance_hav(latitude_top, longitude_left, latitude_bottom, longitude_right)
east_west_longitude = 2 * asin(sin(distance / (2 * EARTH_RADIUS)) / cos(latitude))
east_west_longitude = degrees(east_west_longitude) # 弧度转换成角度
south_north_latitude = distance / EARTH_RADIUS
south_north_latitude = degrees(south_north_latitude) # 弧度转换成角度
array = {'left_top': (latitude + south_north_latitude, longitude - east_west_longitude),
'right_top': (latitude + south_north_latitude, longitude + east_west_longitude),
'left_bottom': (latitude - south_north_latitude, longitude - east_west_longitude),
'right_bottom': (latitude - south_north_latitude, longitude + east_west_longitude)}
left_top = array['left_top']
right_top = array['right_top']
left_bottom = array['left_bottom']
right_bottom = array['right_bottom']
pub_count = Pub.query.filter(Pub.latitude > right_bottom[0], Pub.latitude < left_top[0],
Pub.longitude > left_bottom[1], Pub.longitude < right_top[1]).count()
temp_page = page
page, per_page, max = page_utils(pub_count, page)
is_max = max_page(temp_page, max, resp_suc)
if is_max:
return resp_suc
if pub_count > 1:
pubs = Pub.query.filter(Pub.latitude > right_bottom[0], Pub.latitude < left_top[0],
Pub.longitude > left_bottom[1], Pub.longitude < right_top[1], Pub.stopped == 0)[per_page*(int(temp_page)-1):per_page*int(temp_page)]
is_collect_pub(pubs, user_id, resp_suc)
else:
pub = Pub.query.filter(Pub.latitude > right_bottom[0], Pub.latitude < left_top[0],
Pub.longitude > left_bottom[1], Pub.longitude < right_top[1], Pub.stopped == 0).first()
is_collect_pub(pub, user_id, resp_suc)
return resp_suc
def get():
"""
user_id: 登陆id
"""
parser = reqparse.RequestParser()
parser.add_argument('user_id', type=str, required=True, help=u'user_id 必须')
parser.add_argument('page', type=str, required=True, help=u'page 必须')
args = parser.parse_args()
success = success_dic().dic
fail = fail_dic().dic
success['activity_collect'] = []
user_id = args['user_id']
page = int(args['page'])
result = activity_collect_list(user_id, page, success)
if result != 0:
return success
else:
success['message'] = '没有数据'
return success
#class ActivityInfo(restful.Resource):
# """
# 活动详情
# """
# @staticmethod
# def get():
# """
# 参数
# activity_id: 活动id
# """
# parser = reqparse.RequestParser()
# parser.add_argument('activity_id', type=str, required=True, help=u'activity_id必须.')
#
# args = parser.parse_args()
#
# activity_id = args['activity_id']
#
# resp_suc = success_dic().dic
# resp_fail = fail_dic().dic
# resp_suc['activity_list'] = []
#
# activity = Activity.query.filter(Activity.id == activity_id).first()
# if activity:
# activity_pic = pub_activity(activity)
# activity_comment_count = ActivityComment.query.filter(ActivityComment.activity_id == activity.id).count()
# activity_pic['comment_count'] = activity_comment_count
# resp_suc['activity_list'].append(activity_pic)
# return resp_suc
# else:
# return resp_fail
def get():
"""
参数:
sender_id:发送的id
receiver_id:接收的id
content: 发送内容
"""
parser = reqparse.RequestParser()
parser.add_argument('sender_id', type=str, required=True, help=u'sender_id必须。')
parser.add_argument('receiver_id', type=str, required=True, help=u'receiver_id必须。')
parser.add_argument('content', type=str, required=True, help=u'content必须。')
# parser.add_argument('date', type=str, required=True, help=u'date必须.')
args = parser.parse_args()
sender_id = args['sender_id']
receiver_id = args['receiver_id']
content = args['content']
resp_suc = success_dic().dic
resp_fail = fail_dic().dic
resp_suc['sender_list'] = []
if sender_id == receiver_id:
resp_fail['message'] = '您不能发给自己！'
return resp_fail
message = Message(sender_id=sender_id, receiver_id=receiver_id, content=content, view=0)
db.add(message)
try:
db.commit()
result = db.query(Message).\
filter(Message.sender_id == sender_id).\
group_by(Message.sender_id).count()
if result == 0:
user_info = UserInfo.query.filter(UserInfo.user_id == receiver_id).first()
user_info.add_credit('message')
db.commit()
sender_info = UserInfo.query.filter(UserInfo.user_id == sender_id).first()
sender_info.add_reputation('message')
db.commit()
except:
return resp_fail
message = Message.query.filter(Message.id == message.id).first()
traverse_message_sender(message, resp_suc)
return resp_suc
def get():
parser = reqparse.RequestParser()
parser.add_argument('sender_id', type=str, required=True, help=u'sender_id 必须')
parser.add_argument('receiver_id', type=str, required=True, help=u'receiver_id')
args = parser.parse_args()
success = success_dic().dic
sender_id = args['sender_id']
receiver_id = args['receiver_id']
is_true = delete_message_info(sender_id, receiver_id)
if is_true:
success['message'] = '清除成功'
return success
else:
success['message'] = '清除失败'
return success
def get():
"""
name: city_name 客户端穿过来的城市name
"""
parser = reqparse.RequestParser()
parser.add_argument('name', type=str, required=True, help=u'name 必须')
args = parser.parse_args()
name = args['name']
success = success_dic().dic
fail = fail_dic().dic
city = get_province_by_name(name)
if city:
success['province_id'] = city
return success
else:
fail['message'] = '未查询到数据'
return fail
def get():
"""
参数，
type: 详细类型
user_id: 用户登录id
"""
parser = reqparse.RequestParser()
parser.add_argument('types', type=str, required=True, help=u'types选择信息类型,0:系统，1私信')
parser.add_argument('user_id', type=str, required=True, help=u'user_id。用户登陆id')
args = parser.parse_args()
types = args['types']
user_id = args['user_id']
resp_suc = success_dic().dic
resp_fail = fail_dic().dic
resp_suc['sender_list'] = []
system_message = traverse_system_message(user_id, resp_suc)
direct_message = traverse_direct_message(user_id, resp_suc)
if types == '0':
user = User.query.filter(User.id == user_id).first()
if type(system_message) is list:
for system in system_message:
system_message_pickler(system, resp_suc)
user.system_message_time = todayfstr()
db.commit()
else:
if system_message:
system_message_pickler(system_message, resp_suc)
user.system_message_time = todayfstr()
db.commit()
else:
if type(direct_message) is list:
traverse_messages_sender(direct_message, resp_suc)
else:
traverse_message_sender(direct_message, resp_suc)
return resp_suc
def get():
"""
activity_id: 活动id
user_id: 用户id
"""
parser = reqparse.RequestParser()
parser.add_argument('activity_id', type=str, required=True, help=u'activity_id 必须')
parser.add_argument('user_id', type=str, required=True, help=u'user_id 必须')
args = parser.parse_args()
success = success_dic().dic
fail = fail_dic().dic
activity_id = args['activity_id']
user_id = args['user_id']
result = collect_or_cancel_activity(user_id, activity_id)
if result:
return success
else:
success['message'] = '没有数据'
return success
def get():
"""
参数
user_id:用户登录id
"""
parser = reqparse.RequestParser()
parser.add_argument('user_id', type=str, required=True, help=u'user_id必须。')
args = parser.parse_args()
resp_suc = success_dic().dic
resp_fail = fail_dic().dic
resp_suc['sender_list'] = []
resp_suc['system_message_list'] = []
user_id = args['user_id']
system_message = traverse_system_message(user_id, resp_suc)
direct_message = traverse_direct_message(user_id, resp_suc)
if system_message or direct_message:
message_type(user_id, system_message)
direct_message_count(direct_message)
return resp_suc
else:
resp_suc['message'] = '没有数据'
return resp_suc
