def po_event_feedback_list(event_id): ids = rank_po_id_list(event_id, CID_EVENT_FEEDBACK, 'confidence') li = Po.mc_get_list(ids) Zsite.mc_bind(li, 'user', 'user_id') return li
def po_user_id_list(question_id): question = Po.mc_get(question_id) user_id = question.user_id po_id_list = rank_po_id_list(question_id, CID_QUESTION, 'confidence') po_list = Po.mc_get_list(po_id_list) user_id_list = [i.user_id for i in po_list] user_id_list.append(user_id) return set(user_id_list)
def event_joiner_by_owner_id(user_id): event_id_list = event_id_list_by_zsite_id(user_id, False, None, None) result = [] if event_id_list: event_id_list_with_count = [] event_id_count_list = [] for id, count in zip(event_id_list, event_joiner_new_count.get_list(event_id_list)): if count: event_id_list_with_count.append(id) event_id_count_list.append(count) for po, count in zip(Po.mc_get_list(event_id_list_with_count), event_id_count_list): result.append((po.id, po.name, count)) return result
def event_joiner_by_owner_id(user_id): event_id_list = event_id_list_by_zsite_id(user_id, False, None, None) result = [] if event_id_list: event_id_list_with_count = [] event_id_count_list = [] for id, count in zip( event_id_list, event_joiner_new_count.get_list(event_id_list) ): if count: event_id_list_with_count.append(id) event_id_count_list.append(count) for po, count in zip( Po.mc_get_list(event_id_list_with_count), event_id_count_list ): result.append((po.id, po.name, count)) return result
def po_answer_list(question_id, zsite_id=0, user_id=0): ids = rank_po_id_list(question_id, CID_QUESTION, 'confidence') if zsite_id == user_id: zsite_id = 0 user_ids = filter(bool, (zsite_id, user_id)) if user_ids: _ids = [] for i in user_ids: user_answer_id = answer_id_get(i, question_id) if user_answer_id: _ids.append(user_answer_id) if user_answer_id in ids: ids.remove(user_answer_id) if _ids: _ids.extend(ids) ids = _ids li = Po.mc_get_list(ids) Zsite.mc_bind(li, 'user', 'user_id') return li
def po_list_by_zsite_id(zsite_id, cid , limit, offset): return Po.mc_get_list(po_id_list_by_zsite_id( zsite_id, cid , limit, offset ))
def event_list_join_by_user_id(user_id, limit, offset): id_list = event_id_list_join_by_user_id(user_id, limit, offset) return zip(Event.mc_get_list(id_list), Po.mc_get_list(id_list))
def event_end_list_by_city_pid(city_pid, limit, offset): id_list = event_end_id_list_by_city_pid(city_pid, limit, offset) return zip(Event.mc_get_list(id_list), Po.mc_get_list(id_list))
def event_list_by_city_pid_cid(city_pid, cid, limit=10, offset=0): id_list = event_id_list_by_city_pid_cid(city_pid, cid, limit, offset) return zip(Event.mc_get_list(id_list), Po.mc_get_list(id_list))
if user_id: return self.user_id == user_id def mc_flush_reply_id_list(cid, rid): key = '%s_%s' % (cid, rid) mc_reply_id_list.delete(key) mc_reply_id_list_reversed.delete(key) mc_reply_count.delete(key) mc_reply_zsite_id_list.delete(key) if __name__ == '__main__': r = Reply.raw_sql( 'select *,count(rid) from reply where cid = 62 group by rid order by count(rid) desc limit 50' ).fetchall() from po import Po p_l, c_l = [], [] for i in r: p_l.append(i[1]) c_l.append(i[-1]) p = Po.mc_get_list(p_l) p = filter(lambda x: x, p) p = map(lambda x: (x.name, x.txt, 'http:%s' % x.link), p) res = zip(p, c_l[1:]) for n, ((i, l, j), k) in enumerate(res): print '#' * 20 print '第%s名:' % (n + 1), i, j, '\n', '回复数:', k, print l, '\n\n' pass
def po_review_list_active_by_zsite_id(id): return Po.mc_get_list(po_review_id_list_active_by_zsite_id(id))
def count_po_list_by_zsite_tag_id_cid(zsite_tag_id, cid, limit=6): return ( zsite_tag_cid_count(zsite_tag_id, cid), Po.mc_get_list(po_id_list_by_zsite_tag_id_cid(zsite_tag_id, cid, limit)) )
def can_admin(self, user_id): if user_id: return self.user_id == user_id def mc_flush_reply_id_list(cid, rid): key = '%s_%s' % (cid, rid) mc_reply_id_list.delete(key) mc_reply_id_list_reversed.delete(key) mc_reply_count.delete(key) mc_reply_zsite_id_list.delete(key) if __name__ == '__main__': r = Reply.raw_sql('select *,count(rid) from reply where cid = 62 group by rid order by count(rid) desc limit 50').fetchall() from po import Po p_l,c_l = [],[] for i in r: p_l.append(i[1]) c_l.append(i[-1]) p = Po.mc_get_list(p_l) p = filter(lambda x:x,p) p = map(lambda x:(x.name,x.txt,'http:%s'%x.link),p) res = zip(p,c_l[1:]) for n,((i,l,j),k) in enumerate(res): print '#'*20 print '第%s名:'%(n+1),i,j,'\n','回复数:',k, print l,'\n\n' pass
def fav_po_list_by_user_id_cid(user_id, cid, limit, offset=0): id_list = fav_po_id_list_by_user_id_cid(user_id, cid, limit, offset) if cid == CID_EVENT: return zip(Event.mc_get_list(id_list), Po.mc_get_list(id_list)) return Po.mc_get_list(id_list)
def event_list_by_zsite_id(zsite_id, can_admin, limit, offset): id_list = event_id_list_by_zsite_id(zsite_id, bool(can_admin), limit, offset) return zip(Event.mc_get_list(id_list), Po.mc_get_list(id_list))
def event_all_list(limit, offset): id_list = event_all_id_list(limit, offset) return zip(Event.mc_get_list(id_list), Po.mc_get_list(id_list))
def po_event_notice_list_by_event_id(event_id): return Po.mc_get_list( po_event_notice_id_list_by_event_id(event_id) )
def po_event_notice_list_by_event_id(event_id): return Po.mc_get_list(po_event_notice_id_list_by_event_id(event_id))
def po_review_show_list_with_user(id): review_list = Po.mc_get_list(po_review_show_id_list(id)) po_review_bind(review_list) return review_list
def product_show_list(limit=None, offset=None): return Po.mc_get_list(product_show_id_list(limit, offset))
def count_po_list_by_zsite_tag_id_cid(zsite_tag_id, cid, limit=6): return (zsite_tag_cid_count(zsite_tag_id, cid), Po.mc_get_list( po_id_list_by_zsite_tag_id_cid(zsite_tag_id, cid, limit)))
def product_list_by_com_id(com_id): return Po.mc_get_list(product_id_list_by_com_id(com_id))
def po_show_list(limit, offset): ids = feed_rt_list(0, limit, offset) li = Po.mc_get_list(ids) li = Po.mc_get_list(i.rid for i in li) Zsite.mc_bind(li, 'user', 'user_id') return li
def po_review_list_active_by_zsite_id(id): return Po.mc_get_list( po_review_id_list_active_by_zsite_id(id) )
def po_list_by_zsite_id(zsite_id, cid, limit, offset): return Po.mc_get_list(po_id_list_by_zsite_id(zsite_id, cid, limit, offset))