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