addons/website_forum/controllers/main.py

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