addons/website_forum/controllers/main.py

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