def my_qc_list(): start, limit, orderQuery, filterQuery = ExtJS.getExtPaging(request) # return dict(locals()) # if filter != None: # episodes= db((db.episode.created_by == auth.user.id) & (filterQuery)).select(limitby=(start,limit),orderby=orderQuery) # else: totalCount= db(db.episode.created_by == auth.user.id).count() episodes= db(db.episode.created_by == auth.user.id).select(limitby=(start,limit),orderby=orderQuery) return dict(episodes = episodes, totalCount=totalCount, metaData= {"totalProperty": "totalCount"})
def subs_list(): id=None key=None subs = None totalCount=0 start, limit, orderQuery, filterQuery = ExtJS.getExtPaging(request, limit=50) if orderQuery is not None: orderQuery = orderQuery.replace("comments_nb","sub.comments_nb") orderQuery = orderQuery.replace("lastcomment_date","sub.lastcomment_date") if len(request.args)>=2: id = request.args[0] key = request.args[1] totalCount= db((db.sub.episode == id) & (db.episode.key==key)).count() subs = db((db.sub.episode == id) & (db.episode.key==key)).select(db.sub.ALL,limitby=(start,limit),orderby=orderQuery) return dict(subs = subs, totalCount=totalCount, metaData= {"totalProperty": "totalCount"})