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"})
