addons/website_forum/controllers/main.py

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