def get_expert_list(self):
qry = UserQuery(
""" u.loginName, u.blogName, u.nickName,u.trueName, u.blogIntroduce,u.articleCount, subj.subjectId """
)
qry.userTypeId = 3
qry.userStatus = 0
qry.setSubjectCondition(self.subject)
expert_list = qry.query_map(3)
request.setAttribute("expert_list", expert_list)
def get_subject_comissioner(self):
qry = UserQuery(
""" u.loginName, u.nickName, u.trueName,u.userIcon, u.blogName, u.createDate,
u.myArticleCount, u.otherArticleCount, u.resourceCount, u.blogIntroduce,u.articleCount """
)
qry.setSubjectCondition(self.subject)
qry.isComissioner = True
qry.userStatus = 0
qry.bmd = 1
comissioner_list = qry.query_map(6)
#print "comissioner_list = ", comissioner_list
request.setAttribute("comissioner_list", comissioner_list)
def get_hot_list(self):
qry = UserQuery(
""" u.loginName, u.blogName,u.trueName, u.visitCount,u.articleCount """
)
qry.orderType = 1
qry.userStatus = 0
qry.setSubjectCondition(self.subject)
hot_list = qry.query_map(10)
request.setAttribute("hot_list", hot_list)
# 主工作室查询数据.
self.query_blog()
