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