addons/website_forum/controllers/main.py

   1 # -*- coding: utf-8 -*-
   2
   3 from datetime import datetime
   4 import werkzeug.urls
   5 import simplejson
   6
   7 from openerp import tools
   8 from openerp import SUPERUSER_ID
   9 from openerp.addons.web import http
  10 from openerp.addons.web.controllers.main import login_redirect
  11 from openerp.addons.web.http import request
  12 from openerp.addons.website.controllers.main import Website as controllers
  13 from openerp.addons.website.models.website import slug
  14 from openerp.tools import html2plaintext
  15
  16 controllers = controllers()
  17
  18
  19 class WebsiteForum(http.Controller):
  20     _post_per_page = 10
  21     _user_per_page = 30
  22
  23     def _get_notifications(self):
  24         cr, uid, context = request.cr, request.uid, request.context
  25         Message = request.registry['mail.message']
  26         badge_st_id = request.registry['ir.model.data'].xmlid_to_res_id(cr, uid, 'gamification.mt_badge_granted')
  27         if badge_st_id:
  28             msg_ids = Message.search(cr, uid, [('subtype_id', '=', badge_st_id), ('to_read', '=', True)], context=context)
  29             msg = Message.browse(cr, uid, msg_ids, context=context)
  30         else:
  31             msg = list()
  32         return msg
  33
  34     def _prepare_forum_values(self, forum=None, **kwargs):
  35         user = request.registry['res.users'].browse(request.cr, request.uid, request.uid, context=request.context)
  36         public_uid = request.registry['website'].get_public_user(request.cr, request.uid, request.context)
  37         values = {'user': user, 'is_public_user': user.id == public_uid,
  38                   'notifications': self._get_notifications(),
  39                   'header': kwargs.get('header', dict()),
  40                   'searches': kwargs.get('searches', dict())}
  41         if forum:
  42             values['forum'] = forum
  43         elif kwargs.get('forum_id'):
  44             values['forum'] = request.registry['forum.forum'].browse(request.cr, request.uid, kwargs.pop('forum_id'), context=request.context)
  45         values.update(kwargs)
  46         return values
  47
  48     # Forum
  49     # --------------------------------------------------
  50
  51     @http.route(['/forum'], type='http', auth="public", website=True, multilang=True)
  52     def forum(self, **kwargs):
  53         cr, uid, context = request.cr, request.uid, request.context
  54         Forum = request.registry['forum.forum']
  55         obj_ids = Forum.search(cr, uid, [], context=context)
  56         forums = Forum.browse(cr, uid, obj_ids, context=context)
  57         return request.website.render("website_forum.forum_all", {'forums': forums})
  58
  59     @http.route('/forum/new', type='http', auth="user", multilang=True, website=True)
  60     def forum_create(self, forum_name="New Forum", **kwargs):
  61         forum_id = request.registry['forum.forum'].create(request.cr, request.uid, {
  62             'name': forum_name,
  63         }, context=request.context)
  64         return request.redirect("/forum/%s" % slug(forum_id))
  65
  66     @http.route('/forum/notification_read', type='json', auth="user", multilang=True, methods=['POST'], website=True)
  67     def notification_read(self, **kwargs):
  68         request.registry['mail.message'].set_message_read(request.cr, request.uid, [int(kwargs.get('notification_id'))], read=True, context=request.context)
  69         return True
  70
  71     @http.route(['/forum/<model("forum.forum"):forum>',
  72                  '/forum/<model("forum.forum"):forum>/page/<int:page>',
  73                  '/forum/<model("forum.forum"):forum>/tag/<model("forum.tag"):tag>/questions'
  74                  ], type='http', auth="public", website=True, multilang=True)
  75     def questions(self, forum, tag=None, page=1, filters='all', sorting='date', search='', **post):
  76         cr, uid, context = request.cr, request.uid, request.context
  77         Post = request.registry['forum.post']
  78         user = request.registry['res.users'].browse(cr, uid, uid, context=context)
  79
  80         domain = [('forum_id', '=', forum.id), ('parent_id', '=', False)]
  81         if search:
  82             domain += ['|', ('name', 'ilike', search), ('content', 'ilike', search)]
  83         if tag:
  84             domain += [('tag_ids', 'in', tag.id)]
  85         if filters == 'unanswered':
  86             domain += [('child_ids', '=', False)]
  87         elif filters == 'followed':
  88             domain += [('message_follower_ids', '=', user.partner_id.id)]
  89         else:
  90             filters = 'all'
  91
  92         if sorting == 'answered':
  93             order = 'child_count desc'
  94         elif sorting == 'vote':
  95             order = 'vote_count desc'
  96         else:
  97             sorting = 'date'
  98             order = 'write_date desc'
  99
 100         question_count = Post.search(cr, uid, domain, count=True, context=context)
 101         pager = request.website.pager(url="/forum/%s" % slug(forum), total=question_count, page=page, step=self._post_per_page, scope=self._post_per_page)
 102
 103         obj_ids = Post.search(cr, uid, domain, limit=self._post_per_page, offset=pager['offset'], order=order, context=context)
 104         question_ids = Post.browse(cr, uid, obj_ids, context=context)
 105
 106         values = self._prepare_forum_values(forum=forum, searches=post)
 107         values.update({
 108             'main_object': forum,
 109             'question_ids': question_ids,
 110             'pager': pager,
 111             'tag': tag,
 112             'filters': filters,
 113             'sorting': sorting,
 114             'search': search,
 115         })
 116         return request.website.render("website_forum.forum_index", values)
 117
 118     @http.route(['/forum/<model("forum.forum"):forum>/faq'], type='http', auth="public", website=True, multilang=True)
 119     def forum_faq(self, forum, **post):
 120         values = self._prepare_forum_values(forum=forum, searches=dict(), **post)
 121         return request.website.render("website_forum.faq", values)
 122
 123     @http.route('/forum/get_tags', type='http', auth="public", multilang=True, methods=['GET'], website=True)
 124     def tag_read(self, **post):
 125         tags = request.registry['forum.tag'].search_read(request.cr, request.uid, [], ['name'], context=request.context)
 126         data = [tag['name'] for tag in tags]
 127         return simplejson.dumps(data)
 128
 129     @http.route(['/forum/<model("forum.forum"):forum>/tag'], type='http', auth="public", website=True, multilang=True)
 130     def tags(self, forum, page=1, **post):
 131         cr, uid, context = request.cr, request.uid, request.context
 132         Tag = request.registry['forum.tag']
 133         obj_ids = Tag.search(cr, uid, [('forum_id', '=', forum.id)], limit=None, context=context)
 134         tags = Tag.browse(cr, uid, obj_ids, context=context)
 135         values = self._prepare_forum_values(forum=forum, searches={'tags': True}, **post)
 136         values.update({
 137             'tags': tags,
 138             'main_object': forum,
 139         })
 140         return request.website.render("website_forum.tag", values)
 141
 142     # Questions
 143     # --------------------------------------------------
 144
 145     @http.route(['/forum/<model("forum.forum"):forum>/ask'], type='http', auth="public", website=True, multilang=True)
 146     def question_ask(self, forum, **post):
 147         if not request.session.uid:
 148             return login_redirect()
 149         values = self._prepare_forum_values(forum=forum, searches={},  header={'ask_hide': True})
 150         return request.website.render("website_forum.ask_question", values)
 151
 152     @http.route('/forum/<model("forum.forum"):forum>/question/new', type='http', auth="user", multilang=True, methods=['POST'], website=True)
 153     def question_create(self, forum, **post):
 154         cr, uid, context = request.cr, request.uid, request.context
 155         Tag = request.registry['forum.tag']
 156         question_tag_ids = []
 157         if post.get('question_tags').strip('[]'):
 158             tags = post.get('question_tags').strip('[]').replace('"', '').split(",")
 159             for tag in tags:
 160                 tag_ids = Tag.search(cr, uid, [('name', '=', tag)], context=context)
 161                 if tag_ids:
 162                     question_tag_ids.append((4, tag_ids[0]))
 163                 else:
 164                     question_tag_ids.append((0, 0, {'name': tag, 'forum_id': forum.id}))
 165
 166         new_question_id = request.registry['forum.post'].create(
 167             request.cr, request.uid, {
 168                 'forum_id': forum.id,
 169                 'name': post.get('question_name'),
 170                 'content': post.get('content'),
 171                 'tag_ids': question_tag_ids,
 172             }, context=context)
 173         return werkzeug.utils.redirect("/forum/%s/question/%s" % (slug(forum), new_question_id))
 174
 175     def prepare_question_values(self, forum=None, **kwargs):
 176         '''Overwrite value in website_doc'''
 177         values = self._prepare_forum_values(forum=forum, searches=kwargs)
 178         return values
 179
 180     @http.route(['/forum/<model("forum.forum"):forum>/question/<model("forum.post"):question>'], type='http', auth="public", website=True, multilang=True)
 181     def question(self, forum, question, **post):
 182         cr, uid, context = request.cr, request.uid, request.context
 183         # increment view counter
 184         request.registry['forum.post'].set_viewed(cr, SUPERUSER_ID, [question.id], context=context)
 185
 186         filters = 'question'
 187         values = self.prepare_question_values(forum=forum, kwargs=post)
 188         values.update({
 189             'main_object': question,
 190             'question': question,
 191             'header': {'question_data': True},
 192             'filters': filters,
 193             'reversed': reversed,
 194         })
 195         return request.website.render("website_forum.post_description_full", values)
 196
 197     @http.route('/forum/<model("forum.forum"):forum>/question/<model("forum.post"):question>/toggle_favourite', type='json', auth="user", multilang=True, methods=['POST'], website=True)
 198     def question_toggle_favorite(self, forum, question, **post):
 199         if not request.session.uid:
 200             return {'error': 'anonymous_user'}
 201         # TDE: add check for not public
 202         favourite = False if question.user_favourite else True
 203         if favourite:
 204             favourite_ids = [(4, request.uid)]
 205         else:
 206             favourite_ids = [(3, request.uid)]
 207         request.registry['forum.post'].write(request.cr, request.uid, [question.id], {'favourite_ids': favourite_ids}, context=request.context)
 208         return favourite
 209
 210     @http.route('/forum/<model("forum.forum"):forum>/question/<model("forum.post"):question>/ask_for_close', type='http', auth="user", multilang=True, website=True)
 211     def question_ask_for_close(self, forum, question, **post):
 212         cr, uid, context = request.cr, request.uid, request.context
 213         Reason = request.registry['forum.post.reason']
 214         reason_ids = Reason.search(cr, uid, [], context=context)
 215         reasons = Reason.browse(cr, uid, reason_ids, context)
 216
 217         values = self._prepare_forum_values(**post)
 218         values.update({
 219             'post': question,
 220             'question': question,
 221             'forum': forum,
 222             'reasons': reasons,
 223         })
 224         return request.website.render("website_forum.close_question", values)
 225
 226     @http.route('/forum/<model("forum.forum"):forum>/question/<model("forum.post"):question>/edit_answer', type='http', auth="user", website=True, multilang=True)
 227     def question_edit_answer(self, forum, question, **kwargs):
 228         for record in question.child_ids:
 229             if record.create_uid.id == request.uid:
 230                 answer = record
 231                 break
 232         return werkzeug.utils.redirect("/forum/%s/post/%s/edit" % (slug(forum), slug(answer)))
 233
 234     @http.route('/forum/<model("forum.forum"):forum>/question/<model("forum.post"):question>/close', type='http', auth="user", multilang=True, methods=['POST'], website=True)
 235     def question_close(self, forum, question, **post):
 236         request.registry['forum.post'].write(request.cr, request.uid, [question.id], {
 237             'state': 'close',
 238             'closed_uid': request.uid,
 239             'closed_date': datetime.today().strftime(tools.DEFAULT_SERVER_DATETIME_FORMAT),
 240             'closed_reason_id': int(post.get('reason_id', False)),
 241         }, context=request.context)
 242         return werkzeug.utils.redirect("/forum/%s/question/%s" % (slug(forum), slug(question)))
 243
 244     @http.route('/forum/<model("forum.forum"):forum>/question/<model("forum.post"):question>/reopen', type='http', auth="user", multilang=True, website=True)
 245     def question_reopen(self, forum, question, **kwarg):
 246         request.registry['forum.post'].write(request.cr, request.uid, [question.id], {'state': 'active'}, context=request.context)
 247         return werkzeug.utils.redirect("/forum/%s/question/%s" % (slug(forum), slug(question)))
 248
 249     @http.route('/forum/<model("forum.forum"):forum>/question/<model("forum.post"):question>/delete', type='http', auth="user", multilang=True, website=True)
 250     def question_delete(self, forum, question, **kwarg):
 251         #instead of unlink record just change 'active' to false so user can undelete it.
 252         request.registry['forum.post'].write(request.cr, request.uid, [question.id], {'active': False}, context=request.context)
 253         return werkzeug.utils.redirect("/forum/%s/question/%s" % (slug(forum), slug(question)))
 254
 255     @http.route('/forum/<model("forum.forum"):forum>/question/<model("forum.post"):question>/undelete', type='http', auth="user", multilang=True, website=True)
 256     def question_undelete(self, forum, question, **kwarg):
 257         request.registry['forum.post'].write(request.cr, request.uid, [question.id], {'active': True}, context=request.context)
 258         return werkzeug.utils.redirect("/forum/%s/question/%s" % (slug(forum), slug(question)))
 259
 260     # Post
 261     # --------------------------------------------------
 262
 263     @http.route('/forum/<model("forum.forum"):forum>/post/<model("forum.post"):post>/new', type='http', auth="public", multilang=True, methods=['POST'], website=True)
 264     def post_new(self, forum, post, **kwargs):
 265         if not request.session.uid:
 266             return login_redirect()
 267         request.registry['forum.post'].create(
 268             request.cr, request.uid, {
 269                 'forum_id': forum.id,
 270                 'parent_id': post.id,
 271                 'content': kwargs.get('content'),
 272             }, context=request.context)
 273         return werkzeug.utils.redirect("/forum/%s/question/%s" % (slug(forum), slug(post)))
 274
 275     @http.route('/forum/<model("forum.forum"):forum>/post/<model("forum.post"):post>/comment', type='http', auth="public", methods=['POST'], website=True)
 276     def post_comment(self, forum, post, **kwargs):
 277         if not request.session.uid:
 278             return login_redirect()
 279         question = post.parent_id if post.parent_id else post
 280         cr, uid, context = request.cr, request.uid, request.context
 281         if kwargs.get('comment') and post.forum_id.id == forum.id:
 282             # TDE FIXME: check that post_id is the question or one of its answers
 283             if request.registry['res.users'].has_group(cr, uid, 'website_mail.group_comment'):
 284                 request.registry['forum.post'].message_post(
 285                     cr, uid, post.id,
 286                     body=kwargs.get('comment'),
 287                     type='comment',
 288                     subtype='mt_comment',
 289                     context=dict(context, mail_create_nosubcribe=True))
 290         return werkzeug.utils.redirect("/forum/%s/question/%s" % (slug(forum), slug(question)))
 291
 292     @http.route('/forum/<model("forum.forum"):forum>/post/<model("forum.post"):post>/toggle_correct', type='json', auth="public", website=True)
 293     def post_toggle_correct(self, forum, post, **kwargs):
 294         cr, uid, context = request.cr, request.uid, request.context
 295         if not request.session.uid:
 296             return {'error': 'anonymous_user'}
 297         # if user have not access to accept answer then reise warning
 298         if post.parent_id is False or post.parent_id.create_uid.id != uid:
 299             return {'error': 'own_post'}
 300
 301         # set all answers to False, only one can be accepted
 302         request.registry['forum.post'].write(cr, uid, [c.id for c in post.parent_id.child_ids], {'is_correct': False}, context=context)
 303         request.registry['forum.post'].write(cr, uid, [post.id, post.parent_id.id], {'is_correct': not post.is_correct}, context=context)
 304         return not post.is_correct
 305
 306     @http.route('/forum/<model("forum.forum"):forum>/post/<model("forum.post"):post>/delete', type='http', auth="user", multilang=True, website=True)
 307     def post_delete(self, forum, post, **kwargs):
 308         question = post.parent_id
 309         request.registry['forum.post'].unlink(request.cr, request.uid, [post.id], context=request.context)
 310         if question:
 311             werkzeug.utils.redirect("/forum/%s/question/%s" % (slug(forum), slug(question)))
 312         return werkzeug.utils.redirect("/forum/%s" % slug(forum))
 313
 314     @http.route('/forum/<model("forum.forum"):forum>/post/<model("forum.post"):post>/edit', type='http', auth="user", website=True, multilang=True)
 315     def post_edit(self, forum, post, **kwargs):
 316         tags = ""
 317         for tag_name in post.tag_ids:
 318             tags += tag_name.name + ","
 319         values = self._prepare_forum_values(forum=forum)
 320         values.update({
 321             'tags': tags,
 322             'post': post,
 323             'is_answer': bool(post.parent_id),
 324             'searches': kwargs
 325         })
 326         return request.website.render("website_forum.edit_post", values)
 327
 328     @http.route('/forum/<model("forum.forum"):forum>/post/<model("forum.post"):post>/save', type='http', auth="user", multilang=True, methods=['POST'], website=True)
 329     def post_save(self, forum, post, **kwargs):
 330         cr, uid, context = request.cr, request.uid, request.context
 331         question_tags = []
 332         if kwargs.get('question_tag') and kwargs.get('question_tag').strip('[]'):
 333             Tag = request.registry['forum.tag']
 334             tags = kwargs.get('question_tag').strip('[]').replace('"', '').split(",")
 335             for tag in tags:
 336                 tag_ids = Tag.search(cr, uid, [('name', '=', tag)], context=context)
 337                 if tag_ids:
 338                     question_tags += tag_ids
 339                 else:
 340                     new_tag = Tag.create(cr, uid, {'name': tag, 'forum_id': forum.id}, context=context)
 341                     question_tags.append(new_tag)
 342         vals = {
 343             'tag_ids': [(6, 0, question_tags)],
 344             'name': kwargs.get('question_name'),
 345             'content': kwargs.get('content'),
 346         }
 347         request.registry['forum.post'].write(cr, uid, [post.id], vals, context=context)
 348         question = post.parent_id if post.parent_id else post
 349         return werkzeug.utils.redirect("/forum/%s/question/%s" % (slug(forum), slug(question)))
 350
 351     @http.route('/forum/<model("forum.forum"):forum>/post/<model("forum.post"):post>/upvote', type='json', auth="public", multilang=True, website=True)
 352     def post_upvote(self, forum, post, **kwargs):
 353         # check for karma and not self vote
 354         if not request.session.uid:
 355             return {'error': 'anonymous_user'}
 356         if request.uid == post.create_uid.id:
 357             return {'error': 'own_post'}
 358         user = request.registry['res.users'].browse(request.cr, SUPERUSER_ID, request.uid, context=request.context)
 359         if user.karma <= 5:
 360             return {'error': 'not_enough_karma', 'karma': 1}
 361         return request.registry['forum.post'].vote(request.cr, request.uid, [post.id], upvote=True, context=request.context)
 362
 363     @http.route('/forum/<model("forum.forum"):forum>/post/<model("forum.post"):post>/downvote', type='json', auth="public", multilang=True, website=True)
 364     def post_downvote(self, forum, post, **kwargs):
 365         if not request.session.uid:
 366             return {'error': 'anonymous_user'}
 367         if request.uid == post.create_uid.id:
 368             return {'error': 'own_post'}
 369         user = request.registry['res.users'].browse(request.cr, SUPERUSER_ID, request.uid, context=request.context)
 370         if user.karma <= 50:
 371             return {'error': 'not_enough_karma', 'karma': 50}
 372         return request.registry['forum.post'].vote(request.cr, request.uid, [post.id], upvote=False, context=request.context)
 373
 374     # User
 375     # --------------------------------------------------
 376
 377     @http.route('/forum/<model("forum.forum"):forum>/users', type='http', auth="public", website=True, multilang=True)
 378     def users(self, forum, page=1, **searches):
 379         cr, uid, context = request.cr, request.uid, request.context
 380         User = request.registry['res.users']
 381
 382         step = 30
 383         tag_count = User.search(cr, SUPERUSER_ID, [('karma', '>', 1)], count=True, context=context)
 384         pager = request.website.pager(url="/forum/users", total=tag_count, page=page, step=step, scope=30)
 385
 386         obj_ids = User.search(cr, SUPERUSER_ID, [('karma', '>', 1)], limit=step, offset=pager['offset'], context=context)
 387         users = User.browse(cr, SUPERUSER_ID, obj_ids, context=context)
 388         searches['users'] = 'True'
 389
 390         values = self._prepare_forum_values(forum=forum, searches=searches)
 391         values .update({
 392             'users': users,
 393             'main_object': forum,
 394             'notifications': self._get_notifications(),
 395             'pager': pager,
 396         })
 397
 398         return request.website.render("website_forum.users", values)
 399
 400     @http.route(['/forum/<model("forum.forum"):forum>/user/<int:user_id>'], type='http', auth="public", website=True, multilang=True)
 401     def open_user(self, forum, user_id=0, **post):
 402         cr, uid, context = request.cr, request.uid, request.context
 403         User = request.registry['res.users']
 404         Post = request.registry['forum.post']
 405         Vote = request.registry['forum.post.vote']
 406         Activity = request.registry['mail.message']
 407         Followers = request.registry['mail.followers']
 408         Data = request.registry["ir.model.data"]
 409
 410         user_id = User.search(cr, SUPERUSER_ID, [('id', '=', user_id), ('karma', '>', '1')], context=context)
 411         if not user_id:
 412             return werkzeug.utils.redirect("/forum/%s" % slug(forum))
 413         user = User.browse(cr, SUPERUSER_ID, user_id[0], context=context)
 414
 415         # questions and answers by user
 416         user_questions, user_answers = [], []
 417         user_post_ids = Post.search(
 418             cr, uid, [
 419                 ('forum_id', '=', forum.id), ('create_uid', '=', user.id),
 420                 '|', ('active', '=', False), ('active', '=', True)], context=context)
 421         user_posts = Post.browse(cr, uid, user_post_ids, context=context)
 422         for record in user_posts:
 423             if record.parent_id:
 424                 user_answers.append(record)
 425             else:
 426                 user_questions.append(record)
 427
 428         # showing questions which user following
 429         obj_ids = Followers.search(cr, SUPERUSER_ID, [('res_model', '=', 'forum.post'), ('partner_id', '=', user.partner_id.id)], context=context)
 430         post_ids = [follower.res_id for follower in Followers.browse(cr, SUPERUSER_ID, obj_ids, context=context)]
 431         que_ids = Post.search(cr, uid, [('id', 'in', post_ids), ('forum_id', '=', forum.id), ('parent_id', '=', False)], context=context)
 432         followed = Post.browse(cr, uid, que_ids, context=context)
 433
 434         #showing Favourite questions of user.
 435         fav_que_ids = Post.search(cr, uid, [('favourite_ids', '=', user.id), ('forum_id', '=', forum.id), ('parent_id', '=', False)], context=context)
 436         favourite = Post.browse(cr, uid, fav_que_ids, context=context)
 437
 438         #votes which given on users questions and answers.
 439         data = Vote.read_group(cr, uid, [('post_id.forum_id', '=', forum.id), ('post_id.create_uid', '=', user.id)], ["vote"], groupby=["vote"], context=context)
 440         up_votes, down_votes = 0, 0
 441         for rec in data:
 442             if rec['vote'] == '1':
 443                 up_votes = rec['vote_count']
 444             elif rec['vote'] == '-1':
 445                 down_votes = rec['vote_count']
 446         total_votes = up_votes + down_votes
 447
 448         #Votes which given by users on others questions and answers.
 449         post_votes = Vote.search(cr, uid, [('user_id', '=', user.id)], context=context)
 450         vote_ids = Vote.browse(cr, uid, post_votes, context=context)
 451
 452         #activity by user.
 453         model, comment = Data.get_object_reference(cr, uid, 'mail', 'mt_comment')
 454         activity_ids = Activity.search(cr, uid, [('res_id', 'in', user_post_ids), ('model', '=', 'forum.post'), ('subtype_id', '!=', comment)], context=context)
 455         activities = Activity.browse(cr, uid, activity_ids, context=context)
 456
 457         posts = {}
 458         for act in activities:
 459             posts[act.res_id] = True
 460         posts_ids = Post.browse(cr, uid, posts.keys(), context=context)
 461         posts = dict(map(lambda x: (x.id, (x.parent_id or x, x.parent_id and x or False)), posts_ids))
 462
 463         post['users'] = 'True'
 464
 465         values = self._prepare_forum_values(**post)
 466         values.update({
 467             'uid': uid,
 468             'user': user,
 469             'main_object': user,
 470             'searches': post,
 471             'forum': forum,
 472             'questions': user_questions,
 473             'answers': user_answers,
 474             'followed': followed,
 475             'favourite': favourite,
 476             'total_votes': total_votes,
 477             'up_votes': up_votes,
 478             'down_votes': down_votes,
 479             'activities': activities,
 480             'posts': posts,
 481             'vote_post': vote_ids,
 482         })
 483         return request.website.render("website_forum.user_detail_full", values)
 484
 485     @http.route('/forum/<model("forum.forum"):forum>/user/<model("res.users"):user>/edit', type='http', auth="user", multilang=True, website=True)
 486     def edit_profile(self, forum, user, **kwargs):
 487         country = request.registry['res.country']
 488         country_ids = country.search(request.cr, SUPERUSER_ID, [], context=request.context)
 489         countries = country.browse(request.cr, SUPERUSER_ID, country_ids, context=request.context)
 490         values = self._prepare_forum_values(forum=forum, searches=kwargs)
 491         values.update({
 492             'countries': countries,
 493             'notifications': self._get_notifications(),
 494         })
 495         return request.website.render("website_forum.edit_profile", values)
 496
 497     @http.route('/forum/<model("forum.forum"):forum>/user/<model("res.users"):user>/save', type='http', auth="user", multilang=True, website=True)
 498     def save_edited_profile(self, forum, user, **kwargs):
 499         request.registry['res.users'].write(request.cr, request.uid, [user.id], {
 500             'name': kwargs.get('name'),
 501             'website': kwargs.get('website'),
 502             'email': kwargs.get('email'),
 503             'city': kwargs.get('city'),
 504             'country_id': kwargs.get('country'),
 505             'website_description': kwargs.get('description'),
 506         }, context=request.context)
 507         return werkzeug.utils.redirect("/forum/%s/user/%d" % (slug(forum), user.id))
 508
 509     # Badges
 510     # --------------------------------------------------
 511
 512     @http.route('/forum/<model("forum.forum"):forum>/badge', type='http', auth="public", website=True, multilang=True)
 513     def badges(self, forum, **searches):
 514         cr, uid, context = request.cr, request.uid, request.context
 515         Badge = request.registry['gamification.badge']
 516         badge_ids = Badge.search(cr, SUPERUSER_ID, [('challenge_ids.category', '=', 'forum')], context=context)
 517         badges = Badge.browse(cr, uid, badge_ids, context=context)
 518         values = self._prepare_forum_values(forum=forum, searches={'badges': True})
 519         values.update({
 520             'badges': badges,
 521         })
 522         return request.website.render("website_forum.badge", values)
 523
 524     @http.route(['/forum/<model("forum.forum"):forum>/badge/<model("gamification.badge"):badge>'], type='http', auth="public", website=True, multilang=True)
 525     def badge_users(self, forum, badge, **kwargs):
 526         user_ids = [badge_user.user_id.id for badge_user in badge.owner_ids]
 527         users = request.registry['res.users'].browse(request.cr, SUPERUSER_ID, user_ids, context=request.context)
 528         values = self._prepare_forum_values(forum=forum, searches={'badges': True})
 529         values.update({
 530             'badge': badge,
 531             'users': users,
 532         })
 533         return request.website.render("website_forum.badge_user", values)
 534
 535     # Messaging
 536     # --------------------------------------------------
 537
 538     @http.route('/forum/<model("forum.forum"):forum>/post/<model("forum.post"):post>/comment/<model("mail.message"):comment>/convert_to_answer', type='http', auth="public", multilang=True, website=True)
 539     def convert_comment_to_answer(self, forum, post, comment, **kwarg):
 540         values = {
 541             'content': comment.body,
 542         }
 543         request.registry['mail.message'].unlink(request.cr, request.uid, [comment.id], context=request.context)
 544         question = post.parent_id if post.parent_id else post
 545         return self.post_new(forum, question, **values)
 546
 547     @http.route('/forum/<model("forum.forum"):forum>/post/<model("forum.post"):post>/convert_to_comment', type='http', auth="user", multilang=True, website=True)
 548     def convert_answer_to_comment(self, forum, post, **kwarg):
 549         values = {
 550             'comment': html2plaintext(post.content),
 551         }
 552         question = post.parent_id
 553         request.registry['forum.post'].unlink(request.cr, SUPERUSER_ID, [post.id], context=request.context)
 554         return self.post_comment(forum, question, **values)
 555
 556     @http.route('/forum/<model("forum.forum"):forum>/post/<model("forum.post"):post>/comment/<model("mail.message"):comment>/delete', type='json', auth="user", multilang=True, website=True)
 557     def delete_comment(self, forum, post, comment, **kwarg):
 558         request.registry['mail.message'].unlink(request.cr, SUPERUSER_ID, [comment.id], context=request.context)
 559         return True