def manage(request): """ The manage view """ estimations = Task.get_waiting_estimations().all() invoices = Task.get_waiting_invoices().all() for item in estimations: item.url = request.route_path(item.type_, id=item.id) for item in invoices: item.url = request.route_path(item.type_, id=item.id) expenses = ExpenseSheet.query()\ .filter(ExpenseSheet.status == 'wait')\ .order_by(ExpenseSheet.month)\ .order_by(ExpenseSheet.status_date).all() for expense in expenses: expense.url = request.route_path("expensesheet", id=expense.id) user_id = request.user.id query = Activity.query() query = query.join(Activity.conseillers) query = query.filter( Activity.conseillers.any(User.id == user_id) ) query = query.filter(Activity.status == 'planned') query = query.order_by(Activity.datetime).limit(10) activities = query.all() for activity in activities: activity.url = request.route_path("activity", id=activity.id) return dict( title=u"Documents en attente de validation", invoices=invoices, estimations=estimations, expenses=expenses, activities=activities, )