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