def questions(self): try: #import pdb;pdb.set_trace() questionList = Questions.select().order_by(Questions.id.desc()) Listtemp=[] for item in questionList: length = Answers.select().where(item.id ==Answers.question).count() Listtemp.append([item,length]) self.privData['QUESTIONS_LIST'] = Listtemp return self.display('questions-list') except Exception,e: print e return self.error(msg='获取问题列表信息失败!')
def list(self): inputParams = self.getInput() page = int(inputParams['page']) if inputParams.has_key('page') else 1 count = config.COUNT_PER_PAGE questionsList = Questions.select() current_user = Users.get(Users.name == self.isLogin()) if not self.isAdmin(): questionsList = current_user.questions_owner questionsList = questionsList.order_by(Questions.id.desc()) pageString = self.getPageStr(self.makeUrl('/admin/agents/list'), page, count, questionsList.count()) self.privData['QUESTIONS_LIST'] = questionsList.paginate(page, count) self.privData['PAGE_STRING'] = pageString return self.display('questionsList')
def search(self): inputParams = self.getInput() keywords = inputParams['keywords'].strip().lower() if inputParams.has_key('keywords') else '' page = int(inputParams['page']) if inputParams.has_key('page') else 1 count = config.COUNT_PER_PAGE current_user = Users.get(Users.name == self.isLogin()) questionsList = Questions.select().where(Questions.title.contains(keywords)) if not self.isAdmin(): questionsList = current_user.questions_owner questionsList = questionsList.order_by(Questions.id.desc()) pageString = self.getPageStr(self.makeUrl('/admin/questions/list'), page, count, questionsList.count()) self.privData['QUESTIONS_LIST'] = questionsList.paginate(page, count) self.privData['PAGE_STRING'] = pageString return self.display('questionsList')