NO_REMOVE_PERMISSION = StatusCodeField(402007, u'No Remove Permission', description=u'没有移除权限')
- NO_PASS_PERMISSION = StatusCodeField(402008, u'No Pass Permission', description=u'没有通过权限')
- NO_REFUSE_PERMISSION = StatusCodeField(402009, u'No Refuse Permission', description=u'没有拒绝权限')
- DUPLICATE_JOIN_REQUEST = StatusCodeField(402010, u'Duplicate Join Request', description=u'重复加群申请')
- JOIN_REQUEST_NOT_FOUND = StatusCodeField(402011, u'Join Request Not Found', description=u'加群申请不存在')
+ NO_QUIT_PERMISSION = StatusCodeField(402008, u'No Quit Permission', description=u'没有退出权限')
+ NO_PASS_PERMISSION = StatusCodeField(402009, u'No Pass Permission', description=u'没有通过权限')
+ NO_REFUSE_PERMISSION = StatusCodeField(402010, u'No Refuse Permission', description=u'没有拒绝权限')
+ DUPLICATE_JOIN_REQUEST = StatusCodeField(402011, u'Duplicate Join Request', description=u'重复加群申请')
+ JOIN_REQUEST_NOT_FOUND = StatusCodeField(402012, u'Join Request Not Found', description=u'加群申请不存在')
class GroupUserStatusCode(BaseStatusCode):
@@ -12,6 +12,7 @@ GROUP_USERS_APPLYING_SET = 'group:users:applying:set:%s' # SET，群组用户 |
||
| 12 | 12 |
GROUP_USERS_PASSED_SET = 'group:users:passed:set:%s' # SET，群组用户通过集合，group_id |
| 13 | 13 |
GROUP_USERS_REFUSED_SET = 'group:users:refused:set:%s' # SET，群组用户拒绝集合，group_id |
| 14 | 14 |
GROUP_USERS_DELETED_SET = 'group:users:deleted:set:%s' # SET，群组用户移除集合，group_id |
| 15 |
+GROUP_USERS_QUIT_SET = 'group:users:quit:set:%s' # SET，群组用户退出集合，group_id |
|
| 15 | 16 |
|
| 16 | 17 |
# 群组照片相关 |
| 17 | 18 |
GROUP_LAST_PHOTO_PK = 'group:last:photo:pk:%s' # STRING，群组最后一张照片PK，group_id |
@@ -1,10 +1,14 @@ |
||
| 1 | 1 |
# -*- coding: utf-8 -*- |
| 2 | 2 |
|
| 3 |
-PAI2_HOME_API = r"select " \ |
|
| 4 |
- r"T1.group_id, T2.group_name, T2.group_default_avatar, T2.group_avatar, T3.id, T3.photo_path, T3.photo_w, T3.photo_h, T3.photo_thumbnail_path, T3.photo_thumbnail_w, T3.photo_thumbnail_h, T3.user_id, T3.nickname, T3.avatar, T3.comment_num, T3.thumbup_num, T3.created_at " \ |
|
| 5 |
- r"from (select * from group_groupuserinfo where user_id='{user_id}' and user_status=1) as T1 " \
|
|
| 6 |
- r"left outer join group_groupinfo as T2 on T1.group_id = T2.group_id " \ |
|
| 7 |
- r"left outer join group_groupphotoinfo as T3 on T1.group_id = T3.group_id and T3.id > T1.current_id " \ |
|
| 8 |
- r"where T3.status = 1 " \ |
|
| 9 |
- r"order by DATE(T3.created_at) desc, T3.thumbup_num desc " \ |
|
| 10 |
- r"limit {offset}, {rows};"
|
|
| 3 |
+PAI2_HOME_API = ( |
|
| 4 |
+ r"select " |
|
| 5 |
+ r"T1.group_id, T2.group_name, T2.group_default_avatar, T2.group_avatar, T3.id, T3.photo_path, T3.photo_w, " |
|
| 6 |
+ r"T3.photo_h, T3.photo_thumbnail_path, T3.photo_thumbnail_w, T3.photo_thumbnail_h, T3.user_id, T3.nickname, " |
|
| 7 |
+ r"T3.avatar, T3.comment_num, T3.thumbup_num, T3.created_at " |
|
| 8 |
+ r"from (select * from group_groupuserinfo where user_id='{user_id}' and user_status=1) as T1 "
|
|
| 9 |
+ r"left outer join group_groupinfo as T2 on T1.group_id = T2.group_id " |
|
| 10 |
+ r"left outer join group_groupphotoinfo as T3 on T1.group_id = T3.group_id and T3.id > T1.current_id " |
|
| 11 |
+ r"where T3.status = 1 " |
|
| 12 |
+ r"order by DATE(T3.created_at) desc, T3.thumbup_num desc " |
|
| 13 |
+ r"limit {offset}, {rows};"
|
|
| 14 |
+) |