def update(self): super(SearchUsers, self).update() request = self.request uids = request.POST.getall('uid') if 'activate' in request.POST and uids: Session.query(MemberProperties)\ .filter(MemberProperties.uri.in_(uids))\ .update({'suspended': False}, False) self.message("Selected accounts have been activated.", 'info') if 'suspend' in request.POST and uids: Session.query(MemberProperties).filter( MemberProperties.uri.in_(uids))\ .update({'suspended': True}, False) self.message("Selected accounts have been suspended.", 'info') if 'validate' in request.POST and uids: Session.query(MemberProperties).filter( MemberProperties.uri.in_(uids))\ .update({'validated': True}, False) self.message("Selected accounts have been validated.", 'info') term = request.session.get('ptah-search-term', '') if term: self.users = Session.query(CrowdUser) \ .filter(CrowdUser.email.contains('%%%s%%'%term))\ .order_by(sqla.sql.asc('name')).all() else: self.size = Session.query(CrowdUser).count() try: current = int(request.params.get('batch', None)) if not current: current = request.session.get('crowd-current-batch') if not current: current = 1 else: request.session['crowd-current-batch'] = current except: current = request.session.get('crowd-current-batch') if not current: current = 1 self.current = current self.pages, self.prev, self.next = self.page(self.size,self.current) offset, limit = self.page.offset(current) self.users = Session.query(CrowdUser)\ .offset(offset).limit(limit).all()
def update(self): super(CrowdModuleView, self).update() request = self.request uids = request.POST.getall("uid") if "activate" in request.POST and uids: Session.query(MemberProperties).filter(MemberProperties.uri.in_(uids)).update({"suspended": False}, False) self.message("Selected accounts have been activated.", "info") if "suspend" in request.POST and uids: Session.query(MemberProperties).filter(MemberProperties.uri.in_(uids)).update({"suspended": True}, False) self.message("Selected accounts have been suspended.", "info") if "validate" in request.POST and uids: Session.query(MemberProperties).filter(MemberProperties.uri.in_(uids)).update({"validated": True}, False) self.message("Selected accounts have been validated.", "info") term = request.session.get("ptah-search-term", "") if term: self.users = ( Session.query(CrowdUser) .filter(CrowdUser.email.contains("%%%s%%" % term)) .order_by(sqla.sql.asc("name")) .all() ) else: self.size = Session.query(CrowdUser).count() try: current = int(request.params.get("batch", None)) if not current: current = 1 request.session["crowd-current-batch"] = current except: current = request.session.get("crowd-current-batch") if not current: current = 1 self.current = current self.pages, self.prev, self.next = self.page(self.size, self.current) offset, limit = self.page.offset(current) self.users = Session.query(CrowdUser).offset(offset).limit(limit).all()