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