[MERGE] forward port of branch 8.0 up to 591e329
[odoo/odoo.git] / addons / website_forum / controllers / main.py
index 1e1553f..faea931 100644 (file)
@@ -3,9 +3,10 @@
 import werkzeug.urls
 import werkzeug.wrappers
 import simplejson
+import lxml
+from urllib2 import urlopen
 
 from openerp import tools
-from openerp import SUPERUSER_ID
 from openerp.addons.web import http
 from openerp.addons.web.controllers.main import login_redirect
 from openerp.addons.web.http import request
@@ -20,31 +21,28 @@ class WebsiteForum(http.Controller):
     _user_per_page = 30
 
     def _get_notifications(self):
-        cr, uid, context = request.cr, request.uid, request.context
-        Message = request.registry['mail.message']
-        badge_st_id = request.registry['ir.model.data'].xmlid_to_res_id(cr, uid, 'gamification.mt_badge_granted')
-        if badge_st_id:
-            msg_ids = Message.search(cr, uid, [('subtype_id', '=', badge_st_id), ('to_read', '=', True)], context=context)
-            msg = Message.browse(cr, uid, msg_ids, context=context)
+        badge_subtype = request.env.ref('gamification.mt_badge_granted')
+        if badge_subtype:
+            msg = request.env['mail.message'].search([('subtype_id', '=', badge_subtype.id), ('to_read', '=', True)])
         else:
             msg = list()
         return msg
 
     def _prepare_forum_values(self, forum=None, **kwargs):
-        user = request.registry['res.users'].browse(request.cr, request.uid, request.uid, context=request.context)
         values = {
-            'user': user,
-            'is_public_user': user.id == request.website.user_id.id,
+            'user': request.env.user,
+            'is_public_user': request.env.user.id == request.website.user_id.id,
             'notifications': self._get_notifications(),
             'header': kwargs.get('header', dict()),
             'searches': kwargs.get('searches', dict()),
+            'no_introduction_message': request.httprequest.cookies.get('no_introduction_message', False),
             'validation_email_sent': request.session.get('validation_email_sent', False),
             'validation_email_done': request.session.get('validation_email_done', False),
         }
         if forum:
             values['forum'] = forum
         elif kwargs.get('forum_id'):
-            values['forum'] = request.registry['forum.forum'].browse(request.cr, request.uid, kwargs.pop('forum_id'), context=request.context)
+            values['forum'] = request.env['forum.forum'].browse(kwargs.pop('forum_id'))
         values.update(kwargs)
         return values
 
@@ -53,7 +51,8 @@ class WebsiteForum(http.Controller):
 
     @http.route('/forum/send_validation_email', type='json', auth='user', website=True)
     def send_validation_email(self, forum_id=None, **kwargs):
-        request.registry['res.users'].send_forum_validation_email(request.cr, request.uid, request.uid, forum_id=forum_id, context=request.context)
+        if request.env.uid != request.website.user_id.id:
+            request.env.user.send_forum_validation_email(forum_id=forum_id)
         request.session['validation_email_sent'] = True
         return True
 
@@ -64,7 +63,7 @@ class WebsiteForum(http.Controller):
                 forum_id = int(forum_id)
             except ValueError:
                 forum_id = None
-        done = request.registry['res.users'].process_forum_validation_token(request.cr, request.uid, token, int(id), email, forum_id=forum_id, context=request.context)
+        done = request.env['res.users'].sudo().browse(int(id)).process_forum_validation_token(token, email, forum_id=forum_id)[0]
         if done:
             request.session['validation_email_done'] = True
         if forum_id:
@@ -81,22 +80,17 @@ class WebsiteForum(http.Controller):
 
     @http.route(['/forum'], type='http', auth="public", website=True)
     def forum(self, **kwargs):
-        cr, uid, context = request.cr, request.uid, request.context
-        Forum = request.registry['forum.forum']
-        obj_ids = Forum.search(cr, uid, [], context=context)
-        forums = Forum.browse(cr, uid, obj_ids, context=context)
+        forums = request.env['forum.forum'].search([])
         return request.website.render("website_forum.forum_all", {'forums': forums})
 
     @http.route('/forum/new', type='http', auth="user", methods=['POST'], website=True)
     def forum_create(self, forum_name="New Forum", **kwargs):
-        forum_id = request.registry['forum.forum'].create(request.cr, request.uid, {
-            'name': forum_name,
-        }, context=request.context)
-        return request.redirect("/forum/%s" % forum_id)
+        forum_id = request.env['forum.forum'].create({'name': forum_name})
+        return request.redirect("/forum/%s" % slug(forum_id))
 
     @http.route('/forum/notification_read', type='json', auth="user", methods=['POST'], website=True)
     def notification_read(self, **kwargs):
-        request.registry['mail.message'].set_message_read(request.cr, request.uid, [int(kwargs.get('notification_id'))], read=True, context=request.context)
+        request.env['mail.message'].browse([int(kwargs.get('notification_id'))]).set_message_read(read=True)
         return True
 
     @http.route(['/forum/<model("forum.forum"):forum>',
@@ -104,10 +98,8 @@ class WebsiteForum(http.Controller):
                  '''/forum/<model("forum.forum"):forum>/tag/<model("forum.tag", "[('forum_id','=',forum[0])]"):tag>/questions''',
                  '''/forum/<model("forum.forum"):forum>/tag/<model("forum.tag", "[('forum_id','=',forum[0])]"):tag>/questions/page/<int:page>''',
                  ], type='http', auth="public", website=True)
-    def questions(self, forum, tag=None, page=1, filters='all', sorting='date', search='', **post):
-        cr, uid, context = request.cr, request.uid, request.context
-        Post = request.registry['forum.post']
-        user = request.registry['res.users'].browse(cr, uid, uid, context=context)
+    def questions(self, forum, tag=None, page=1, filters='all', sorting=None, search='', post_type=None, **post):
+        Post = request.env['forum.post']
 
         domain = [('forum_id', '=', forum.id), ('parent_id', '=', False), ('state', '=', 'active')]
         if search:
@@ -117,39 +109,32 @@ class WebsiteForum(http.Controller):
         if filters == 'unanswered':
             domain += [('child_ids', '=', False)]
         elif filters == 'followed':
-            domain += [('message_follower_ids', '=', user.partner_id.id)]
-        else:
-            filters = 'all'
-
-        if sorting == 'answered':
-            order = 'child_count desc'
-        elif sorting == 'vote':
-            order = 'vote_count desc'
-        elif sorting == 'date':
-            order = 'write_date desc'
-        else:
-            sorting = 'creation'
-            order = 'create_date desc'
+            domain += [('message_follower_ids', '=', request.env.user.partner_id.id)]
+        if post_type:
+            domain += [('post_type', '=', post_type)]
+
+        if not sorting:
+            sorting = forum.default_order
+
+        question_count = Post.search_count(domain)
 
-        question_count = Post.search(cr, uid, domain, count=True, context=context)
         if tag:
             url = "/forum/%s/tag/%s/questions" % (slug(forum), slug(tag))
         else:
             url = "/forum/%s" % slug(forum)
 
-        url_args = {}
+        url_args = {
+            'sorting': sorting
+        }
         if search:
             url_args['search'] = search
         if filters:
             url_args['filters'] = filters
-        if sorting:
-            url_args['sorting'] = sorting
         pager = request.website.pager(url=url, total=question_count, page=page,
                                       step=self._post_per_page, scope=self._post_per_page,
                                       url_args=url_args)
 
-        obj_ids = Post.search(cr, uid, domain, limit=self._post_per_page, offset=pager['offset'], order=order, context=context)
-        question_ids = Post.browse(cr, uid, obj_ids, context=context)
+        question_ids = Post.search(domain, limit=self._post_per_page, offset=pager['offset'], order=sorting)
 
         values = self._prepare_forum_values(forum=forum, searches=post)
         values.update({
@@ -161,6 +146,7 @@ class WebsiteForum(http.Controller):
             'filters': filters,
             'sorting': sorting,
             'search': search,
+            'post_type': post_type,
         })
         return request.website.render("website_forum.forum_index", values)
 
@@ -170,26 +156,17 @@ class WebsiteForum(http.Controller):
         return request.website.render("website_forum.faq", values)
 
     @http.route('/forum/get_tags', type='http', auth="public", methods=['GET'], website=True)
-    def tag_read(self, q='', l=25, t='texttext', **post):
-        data = request.registry['forum.tag'].search_read(
-            request.cr,
-            request.uid,
+    def tag_read(self, q='', l=25, **post):
+        data = request.env['forum.tag'].search_read(
             domain=[('name', '=ilike', (q or '') + "%")],
             fields=['id', 'name'],
             limit=int(l),
-            context=request.context
         )
-        if t == 'texttext':
-            # old tag with texttext - Retro for V8 - #TODO Remove in master
-            data = [tag['name'] for tag in data]
         return simplejson.dumps(data)
 
     @http.route(['/forum/<model("forum.forum"):forum>/tag'], type='http', auth="public", website=True)
     def tags(self, forum, page=1, **post):
-        cr, uid, context = request.cr, request.uid, request.context
-        Tag = request.registry['forum.tag']
-        obj_ids = Tag.search(cr, uid, [('forum_id', '=', forum.id), ('posts_count', '>', 0)], limit=None, order='posts_count DESC', context=context)
-        tags = Tag.browse(cr, uid, obj_ids, context=context)
+        tags = request.env['forum.tag'].search([('forum_id', '=', forum.id), ('posts_count', '>', 0)], limit=None, order='posts_count DESC')
         values = self._prepare_forum_values(forum=forum, searches={'tags': True}, **post)
         values.update({
             'tags': tags,
@@ -200,52 +177,18 @@ class WebsiteForum(http.Controller):
     # Questions
     # --------------------------------------------------
 
-    @http.route(['/forum/<model("forum.forum"):forum>/ask'], type='http', auth="public", website=True)
-    def question_ask(self, forum, **post):
-        if not request.session.uid:
-            return login_redirect()
-        values = self._prepare_forum_values(forum=forum, searches={}, header={'ask_hide': True})
-        return request.website.render("website_forum.ask_question", values)
-
-    @http.route('/forum/<model("forum.forum"):forum>/question/new', type='http', auth="user", methods=['POST'], website=True)
-    def question_create(self, forum, **post):
-        cr, uid, context = request.cr, request.uid, request.context
-        Tag = request.registry['forum.tag']
-        Forum = request.registry['forum.forum']
-        question_tag_ids = []
-        tag_version = post.get('tag_type', 'texttext')
-        if tag_version == "texttext":  # TODO Remove in master
-            if post.get('question_tags').strip('[]'):
-                tags = post.get('question_tags').strip('[]').replace('"', '').split(",")
-                for tag in tags:
-                    tag_ids = Tag.search(cr, uid, [('name', '=', tag)], context=context)
-                    if tag_ids:
-                        question_tag_ids.append((4, tag_ids[0]))
-                    else:
-                        question_tag_ids.append((0, 0, {'name': tag, 'forum_id': forum.id}))
-                question_tag_ids = {forum.id: question_tag_ids}
-        elif tag_version == "select2":
-            question_tag_ids = Forum._tag_to_write_vals(cr, uid, [forum.id], post.get('question_tags', ''), context)
-
-        new_question_id = request.registry['forum.post'].create(
-            request.cr, request.uid, {
-                'forum_id': forum.id,
-                'name': post.get('question_name'),
-                'content': post.get('content'),
-                'tag_ids': question_tag_ids[forum.id],
-            }, context=context)
-        return werkzeug.utils.redirect("/forum/%s/question/%s" % (slug(forum), new_question_id))
+    @http.route('/forum/get_url_title', type='json', auth="user", methods=['POST'], website=True)
+    def get_url_title(self, **kwargs):
+        arch = lxml.html.parse(urlopen(kwargs.get('url')))
+        return arch.find(".//title").text
 
     @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)
     def question(self, forum, question, **post):
-        cr, uid, context = request.cr, request.uid, request.context
         # increment view counter
-        request.registry['forum.post'].set_viewed(cr, SUPERUSER_ID, [question.id], context=context)
-
+        question.sudo().set_viewed()
         if question.parent_id:
             redirect_url = "/forum/%s/question/%s" % (slug(forum), slug(question.parent_id))
             return werkzeug.utils.redirect(redirect_url, 301)
-
         filters = 'question'
         values = self._prepare_forum_values(forum=forum, searches=post)
         values.update({
@@ -267,15 +210,12 @@ class WebsiteForum(http.Controller):
             favourite_ids = [(4, request.uid)]
         else:
             favourite_ids = [(3, request.uid)]
-        request.registry['forum.post'].write(request.cr, request.uid, [question.id], {'favourite_ids': favourite_ids}, context=request.context)
+        question.sudo().write({'favourite_ids': favourite_ids})
         return favourite
 
     @http.route('/forum/<model("forum.forum"):forum>/question/<model("forum.post"):question>/ask_for_close', type='http', auth="user", methods=['POST'], website=True)
     def question_ask_for_close(self, forum, question, **post):
-        cr, uid, context = request.cr, request.uid, request.context
-        Reason = request.registry['forum.post.reason']
-        reason_ids = Reason.search(cr, uid, [], context=context)
-        reasons = Reason.browse(cr, uid, reason_ids, context)
+        reasons = request.env['forum.post.reason'].search([])
 
         values = self._prepare_forum_values(**post)
         values.update({
@@ -284,7 +224,7 @@ class WebsiteForum(http.Controller):
             'forum': forum,
             'reasons': reasons,
         })
-        return request.website.render("website_forum.close_question", values)
+        return request.website.render("website_forum.close_post", values)
 
     @http.route('/forum/<model("forum.forum"):forum>/question/<model("forum.post"):question>/edit_answer', type='http', auth="user", website=True)
     def question_edit_answer(self, forum, question, **kwargs):
@@ -296,92 +236,95 @@ class WebsiteForum(http.Controller):
 
     @http.route('/forum/<model("forum.forum"):forum>/question/<model("forum.post"):question>/close', type='http', auth="user", methods=['POST'], website=True)
     def question_close(self, forum, question, **post):
-        request.registry['forum.post'].close(request.cr, request.uid, [question.id], reason_id=int(post.get('reason_id', False)), context=request.context)
+        question.close(reason_id=int(post.get('reason_id', False)))
         return werkzeug.utils.redirect("/forum/%s/question/%s" % (slug(forum), slug(question)))
 
     @http.route('/forum/<model("forum.forum"):forum>/question/<model("forum.post"):question>/reopen', type='http', auth="user", methods=['POST'], website=True)
     def question_reopen(self, forum, question, **kwarg):
-        request.registry['forum.post'].reopen(request.cr, request.uid, [question.id], context=request.context)
+        question.reopen()
         return werkzeug.utils.redirect("/forum/%s/question/%s" % (slug(forum), slug(question)))
 
     @http.route('/forum/<model("forum.forum"):forum>/question/<model("forum.post"):question>/delete', type='http', auth="user", methods=['POST'], website=True)
     def question_delete(self, forum, question, **kwarg):
-        request.registry['forum.post'].write(request.cr, request.uid, [question.id], {'active': False}, context=request.context)
+        question.active = False
         return werkzeug.utils.redirect("/forum/%s/question/%s" % (slug(forum), slug(question)))
 
     @http.route('/forum/<model("forum.forum"):forum>/question/<model("forum.post"):question>/undelete', type='http', auth="user", methods=['POST'], website=True)
     def question_undelete(self, forum, question, **kwarg):
-        request.registry['forum.post'].write(request.cr, request.uid, [question.id], {'active': True}, context=request.context)
+        question.active = True
         return werkzeug.utils.redirect("/forum/%s/question/%s" % (slug(forum), slug(question)))
 
     # Post
     # --------------------------------------------------
-
-    @http.route('/forum/<model("forum.forum"):forum>/post/<model("forum.post"):post>/new', type='http', auth="public", methods=['POST'], website=True)
-    def post_new(self, forum, post, **kwargs):
+    @http.route(['/forum/<model("forum.forum"):forum>/ask'], type='http', auth="public", website=True)
+    def forum_post(self, forum, post_type=None, **post):
         if not request.session.uid:
             return login_redirect()
-        cr, uid, context = request.cr, request.uid, request.context
-        user = request.registry['res.users'].browse(cr, SUPERUSER_ID, uid, context=context)
+        user = request.env.user
+        if not post_type in ['question', 'link', 'discussion']:  # fixme: make dynamic
+            return werkzeug.utils.redirect('/forum/%s' % slug(forum))
         if not user.email or not tools.single_email_re.match(user.email):
-            return werkzeug.utils.redirect("/forum/%s/user/%s/edit?email_required=1" % (slug(forum), uid))
-        request.registry['forum.post'].create(
-            request.cr, request.uid, {
-                'forum_id': forum.id,
-                'parent_id': post.id,
-                'content': kwargs.get('content'),
-            }, context=request.context)
-        return werkzeug.utils.redirect("/forum/%s/question/%s" % (slug(forum), slug(post)))
+            return werkzeug.utils.redirect("/forum/%s/user/%s/edit?email_required=1" % (slug(forum), request.session.uid))
+        values = self._prepare_forum_values(forum=forum, searches={}, header={'ask_hide': True})
+        return request.website.render("website_forum.new_%s" % post_type, values)
+
+    @http.route(['/forum/<model("forum.forum"):forum>/new',
+                 '/forum/<model("forum.forum"):forum>/<model("forum.post"):post_parent>/reply'],
+                type='http', auth="public", methods=['POST'], website=True)
+    def post_create(self, forum, post_parent=None, post_type=None, **post):
+        cr, uid, context = request.cr, request.uid, request.context
+        if not request.session.uid:
+            return login_redirect()
+        post_tag_ids = forum._tag_to_write_vals(post.get('post_tags', ''))
+        new_question = request.env['forum.post'].create({
+            'forum_id': forum.id,
+            'name': post.get('post_name', ''),
+            'content': post.get('content', False),
+            'content_link': post.get('content_link', False),
+            'parent_id': post_parent and post_parent.id or False,
+            'tag_ids': post_tag_ids,
+            'post_type': post_parent and post_parent.post_type or post_type,  # tde check in selection field
+        })
+        return werkzeug.utils.redirect("/forum/%s/question/%s" % (slug(forum), post_parent and slug(post_parent) or new_question.id))
 
     @http.route('/forum/<model("forum.forum"):forum>/post/<model("forum.post"):post>/comment', type='http', auth="public", methods=['POST'], website=True)
     def post_comment(self, forum, post, **kwargs):
         if not request.session.uid:
             return login_redirect()
         question = post.parent_id if post.parent_id else post
-        cr, uid, context = request.cr, request.uid, request.context
         if kwargs.get('comment') and post.forum_id.id == forum.id:
             # TDE FIXME: check that post_id is the question or one of its answers
-            request.registry['forum.post'].message_post(
-                cr, uid, post.id,
+            post.with_context(mail_create_nosubcribe=True).message_post(
                 body=kwargs.get('comment'),
                 type='comment',
-                subtype='mt_comment',
-                context=dict(context, mail_create_nosubcribe=True))
+                subtype='mt_comment')
         return werkzeug.utils.redirect("/forum/%s/question/%s" % (slug(forum), slug(question)))
 
     @http.route('/forum/<model("forum.forum"):forum>/post/<model("forum.post"):post>/toggle_correct', type='json', auth="public", website=True)
     def post_toggle_correct(self, forum, post, **kwargs):
-        cr, uid, context = request.cr, request.uid, request.context
         if post.parent_id is False:
             return request.redirect('/')
         if not request.session.uid:
             return {'error': 'anonymous_user'}
 
         # set all answers to False, only one can be accepted
-        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)
-        request.registry['forum.post'].write(cr, uid, [post.id], {'is_correct': not post.is_correct}, context=context)
+        (post.parent_id.child_ids - post).write(dict(is_correct=False))
+        post.is_correct = not post.is_correct
         return post.is_correct
 
     @http.route('/forum/<model("forum.forum"):forum>/post/<model("forum.post"):post>/delete', type='http', auth="user", methods=['POST'], website=True)
     def post_delete(self, forum, post, **kwargs):
         question = post.parent_id
-        request.registry['forum.post'].unlink(request.cr, request.uid, [post.id], context=request.context)
+        post.unlink()
         if question:
             werkzeug.utils.redirect("/forum/%s/question/%s" % (slug(forum), slug(question)))
         return werkzeug.utils.redirect("/forum/%s" % slug(forum))
 
     @http.route('/forum/<model("forum.forum"):forum>/post/<model("forum.post"):post>/edit', type='http', auth="user", website=True)
     def post_edit(self, forum, post, **kwargs):
-        tag_version = kwargs.get('tag_type', 'texttext')
-        if tag_version == "texttext":  # old version - retro v8 - #TODO Remove in master
-            tags = ""
-            for tag_name in post.tag_ids:
-                tags += tag_name.name + ","
-        elif tag_version == "select2":  # new version
-            tags = [dict(id=tag.id, name=tag.name) for tag in post.tag_ids]
-            tags = simplejson.dumps(tags)
+        tags = [dict(id=tag.id, name=tag.name) for tag in post.tag_ids]
+        tags = simplejson.dumps(tags)
         values = self._prepare_forum_values(forum=forum)
-
         values.update({
             'tags': tags,
             'post': post,
@@ -390,40 +333,15 @@ class WebsiteForum(http.Controller):
         })
         return request.website.render("website_forum.edit_post", values)
 
-    @http.route('/forum/<model("forum.forum"):forum>/post/<model("forum.post"):post>/edition', type='http', auth="user", website=True)
-    def post_edit_retro(self, forum, post, **kwargs):
-        # This function is only there for retrocompatibility between old template using texttext and template using select2
-        # It should be removed into master  #TODO JKE: remove in master all condition with tag_type
-        kwargs.update(tag_type="select2")
-        return self.post_edit(forum, post, **kwargs)
-
     @http.route('/forum/<model("forum.forum"):forum>/post/<model("forum.post"):post>/save', type='http', auth="user", methods=['POST'], website=True)
     def post_save(self, forum, post, **kwargs):
-        cr, uid, context = request.cr, request.uid, request.context
-        question_tags = []
-        Tag = request.registry['forum.tag']
-        Forum = request.registry['forum.forum']
-        tag_version = kwargs.get('tag_type', 'texttext')
-        
+        post_tags = forum._tag_to_write_vals(kwargs.get('post_tag', ''))
         vals = {
-            'name': kwargs.get('question_name'),
+            'tag_ids': post_tags,
+            'name': kwargs.get('post_name'),
             'content': kwargs.get('content'),
         }
-        if tag_version == "texttext":  # old version - retro v8 - #TODO Remove in master
-            if kwargs.get('question_tag') and kwargs.get('question_tag').strip('[]'):
-                tags = kwargs.get('question_tag').strip('[]').replace('"', '').split(",")
-                for tag in tags:
-                    tag_ids = Tag.search(cr, uid, [('name', '=', tag)], context=context)
-                    if tag_ids:
-                        question_tags += tag_ids
-                    else:
-                        new_tag = Tag.create(cr, uid, {'name': tag, 'forum_id': forum.id}, context=context)
-                        question_tags.append(new_tag)
-                vals['tag_ids'] = [(6, 0, question_tags)]
-        elif tag_version == "select2":  # new version
-            vals['tag_ids'] = Forum._tag_to_write_vals(cr, uid, [forum.id], kwargs.get('question_tag', ''), context)[forum.id]
-
-        request.registry['forum.post'].write(cr, uid, [post.id], vals, context=context)
+        post.write(vals)
         question = post.parent_id if post.parent_id else post
         return werkzeug.utils.redirect("/forum/%s/question/%s" % (slug(forum), slug(question)))
 
@@ -434,7 +352,7 @@ class WebsiteForum(http.Controller):
         if request.uid == post.create_uid.id:
             return {'error': 'own_post'}
         upvote = True if not post.user_vote > 0 else False
-        return request.registry['forum.post'].vote(request.cr, request.uid, [post.id], upvote=upvote, context=request.context)
+        return post.vote(upvote=upvote)
 
     @http.route('/forum/<model("forum.forum"):forum>/post/<model("forum.post"):post>/downvote', type='json', auth="public", website=True)
     def post_downvote(self, forum, post, **kwargs):
@@ -443,7 +361,7 @@ class WebsiteForum(http.Controller):
         if request.uid == post.create_uid.id:
             return {'error': 'own_post'}
         upvote = True if post.user_vote < 0 else False
-        return request.registry['forum.post'].vote(request.cr, request.uid, [post.id], upvote=upvote, context=request.context)
+        return post.vote(upvote=upvote)
 
     # User
     # --------------------------------------------------
@@ -452,18 +370,15 @@ class WebsiteForum(http.Controller):
                  '/forum/<model("forum.forum"):forum>/users/page/<int:page>'],
                 type='http', auth="public", website=True)
     def users(self, forum, page=1, **searches):
-        cr, uid, context = request.cr, request.uid, request.context
-        User = request.registry['res.users']
-
+        User = request.env['res.users']
         step = 30
-        tag_count = User.search(cr, SUPERUSER_ID, [('karma', '>', 1), ('website_published', '=', True)], count=True, context=context)
+        tag_count = len(User.search([('karma', '>', 1), ('website_published', '=', True)]))
         pager = request.website.pager(url="/forum/%s/users" % slug(forum), total=tag_count, page=page, step=step, scope=30)
-
-        obj_ids = User.search(cr, SUPERUSER_ID, [('karma', '>', 1), ('website_published', '=', True)], limit=step, offset=pager['offset'], order='karma DESC', context=context)
+        user_obj = User.sudo().search([('karma', '>', 1), ('website_published', '=', True)], limit=step, offset=pager['offset'], order='karma DESC')
         # put the users in block of 3 to display them as a table
-        users = [[] for i in range(len(obj_ids)/3+1)]
-        for index, user in enumerate(User.browse(cr, SUPERUSER_ID, obj_ids, context=context)):
-            users[index/3].append(user)
+        users = [[] for i in range(len(user_obj) / 3 + 1)]
+        for index, user in enumerate(user_obj):
+            users[index / 3].append(user)
         searches['users'] = 'True'
 
         values = self._prepare_forum_values(forum=forum, searches=searches)
@@ -478,49 +393,47 @@ class WebsiteForum(http.Controller):
 
     @http.route(['/forum/<model("forum.forum"):forum>/partner/<int:partner_id>'], type='http', auth="public", website=True)
     def open_partner(self, forum, partner_id=0, **post):
-        cr, uid, context = request.cr, request.uid, request.context
         if partner_id:
-            partner = request.registry['res.partner'].browse(cr, SUPERUSER_ID, partner_id, context=context)
-            if partner.exists() and partner.user_ids:
+            partner = request.env['res.partner'].sudo().search([('id', '=', partner_id)])
+            if partner and partner.user_ids:
                 return werkzeug.utils.redirect("/forum/%s/user/%d" % (slug(forum), partner.user_ids[0].id))
         return werkzeug.utils.redirect("/forum/%s" % slug(forum))
 
     @http.route(['/forum/user/<int:user_id>/avatar'], type='http', auth="public", website=True)
     def user_avatar(self, user_id=0, **post):
-        cr, uid, context = request.cr, request.uid, request.context
         response = werkzeug.wrappers.Response()
-        User = request.registry['res.users']
-        Website = request.registry['website']
-        user = User.browse(cr, SUPERUSER_ID, user_id, context=context)
+        User = request.env['res.users']
+        Website = request.env['website']
+        user = User.sudo().search([('id', '=', user_id)])
         if not user.exists() or (user_id != request.session.uid and user.karma < 1):
             return Website._image_placeholder(response)
-        return Website._image(cr, SUPERUSER_ID, 'res.users', user.id, 'image', response)
+        return Website._image('res.users', user.id, 'image', response)
 
     @http.route(['/forum/<model("forum.forum"):forum>/user/<int:user_id>'], type='http', auth="public", website=True)
     def open_user(self, forum, user_id=0, **post):
-        cr, uid, context = request.cr, request.uid, request.context
-        User = request.registry['res.users']
-        Post = request.registry['forum.post']
-        Vote = request.registry['forum.post.vote']
-        Activity = request.registry['mail.message']
-        Followers = request.registry['mail.followers']
-        Data = request.registry["ir.model.data"]
+        User = request.env['res.users']
+        Post = request.env['forum.post']
+        Vote = request.env['forum.post.vote']
+        Activity = request.env['mail.message']
+        Followers = request.env['mail.followers']
+        Data = request.env["ir.model.data"]
 
-        user = User.browse(cr, SUPERUSER_ID, user_id, context=context)
-        current_user = User.browse(cr, SUPERUSER_ID, uid, context=context)
+        user = User.sudo().search([('id', '=', user_id)])
+        current_user = request.env.user.sudo()
+        if not user or user.karma < 1:
 
         # Users with high karma can see users with karma <= 0 for
         # moderation purposes, IFF they have posted something (see below)
-        if (not user.exists() or
+        if (not user or
                (user.karma < 1 and current_user.karma < forum.karma_unlink_all)):
             return werkzeug.utils.redirect("/forum/%s" % slug(forum))
         values = self._prepare_forum_values(forum=forum, **post)
 
         # questions and answers by user
-        user_question_ids = Post.search(cr, uid, [
-                ('parent_id', '=', False),
-                ('forum_id', '=', forum.id), ('create_uid', '=', user.id),
-            ], order='create_date desc', context=context)
+        user_question_ids = Post.search([
+            ('parent_id', '=', False),
+            ('forum_id', '=', forum.id), ('create_uid', '=', user.id)],
+            order='create_date desc')
         count_user_questions = len(user_question_ids)
 
         if (user_id != request.session.uid and not
@@ -529,28 +442,25 @@ class WebsiteForum(http.Controller):
             return request.website.render("website_forum.private_profile", values)
 
         # displaying only the 20 most recent questions
-        user_questions = Post.browse(cr, uid, user_question_ids[:20], context=context)
+        user_questions = user_question_ids[:20]
 
-        user_answer_ids = Post.search(cr, uid, [
-                ('parent_id', '!=', False),
-                ('forum_id', '=', forum.id), ('create_uid', '=', user.id),
-            ], order='create_date desc', context=context)
+        user_answer_ids = Post.search([
+            ('parent_id', '!=', False),
+            ('forum_id', '=', forum.id), ('create_uid', '=', user.id)],
+            order='create_date desc')
         count_user_answers = len(user_answer_ids)
         # displaying only the 20  most recent answers
-        user_answers = Post.browse(cr, uid, user_answer_ids[:20], context=context)
+        user_answers = user_answer_ids[:20]
 
         # showing questions which user following
-        obj_ids = Followers.search(cr, SUPERUSER_ID, [('res_model', '=', 'forum.post'), ('partner_id', '=', user.partner_id.id)], context=context)
-        post_ids = [follower.res_id for follower in Followers.browse(cr, SUPERUSER_ID, obj_ids, context=context)]
-        que_ids = Post.search(cr, uid, [('id', 'in', post_ids), ('forum_id', '=', forum.id), ('parent_id', '=', False)], context=context)
-        followed = Post.browse(cr, uid, que_ids, context=context)
+        post_ids = [follower.res_id for follower in Followers.sudo().search([('res_model', '=', 'forum.post'), ('partner_id', '=', user.partner_id.id)])]
+        followed = Post.search([('id', 'in', post_ids), ('forum_id', '=', forum.id), ('parent_id', '=', False)])
 
-        #showing Favourite questions of user.
-        fav_que_ids = Post.search(cr, uid, [('favourite_ids', '=', user.id), ('forum_id', '=', forum.id), ('parent_id', '=', False)], context=context)
-        favourite = Post.browse(cr, uid, fav_que_ids, context=context)
+        # showing Favourite questions of user.
+        favourite = Post.search([('favourite_ids', '=', user.id), ('forum_id', '=', forum.id), ('parent_id', '=', False)])
 
-        #votes which given on users questions and answers.
-        data = Vote.read_group(cr, uid, [('forum_id', '=', forum.id), ('recipient_id', '=', user.id)], ["vote"], groupby=["vote"], context=context)
+        # votes which given on users questions and answers.
+        data = Vote.read_group([('forum_id', '=', forum.id), ('recipient_id', '=', user.id)], ["vote"], groupby=["vote"])
         up_votes, down_votes = 0, 0
         for rec in data:
             if rec['vote'] == '1':
@@ -558,29 +468,28 @@ class WebsiteForum(http.Controller):
             elif rec['vote'] == '-1':
                 down_votes = rec['vote_count']
 
-        #Votes which given by users on others questions and answers.
-        post_votes = Vote.search(cr, uid, [('user_id', '=', user.id)], context=context)
-        vote_ids = Vote.browse(cr, uid, post_votes, context=context)
+        # Votes which given by users on others questions and answers.
+        vote_ids = Vote.search([('user_id', '=', user.id)])
 
-        #activity by user.
-        model, comment = Data.get_object_reference(cr, uid, 'mail', 'mt_comment')
-        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)
-        activities = Activity.browse(cr, uid, activity_ids, context=context)
+        # activity by user.
+        model, comment = Data.get_object_reference('mail', 'mt_comment')
+        activities = Activity.search([('res_id', 'in', (user_question_ids + user_answer_ids).ids), ('model', '=', 'forum.post'), ('subtype_id', '!=', comment)],
+                                     order='date DESC', limit=100)
 
         posts = {}
         for act in activities:
             posts[act.res_id] = True
-        posts_ids = Post.browse(cr, uid, posts.keys(), context=context)
+        posts_ids = Post.search([('id', 'in', posts.keys())])
         posts = dict(map(lambda x: (x.id, (x.parent_id or x, x.parent_id and x or False)), posts_ids))
 
         # TDE CLEANME MASTER: couldn't it be rewritten using a 'menu' key instead of one key for each menu ?
-        if user.id == uid:
+        if user == request.env.user:
             post['my_profile'] = True
         else:
             post['users'] = True
 
         values.update({
-            'uid': uid,
+            'uid': request.env.user.id,
             'user': user,
             'main_object': user,
             'searches': post,
@@ -600,9 +509,7 @@ class WebsiteForum(http.Controller):
 
     @http.route('/forum/<model("forum.forum"):forum>/user/<model("res.users"):user>/edit', type='http', auth="user", website=True)
     def edit_profile(self, forum, user, **kwargs):
-        country = request.registry['res.country']
-        country_ids = country.search(request.cr, SUPERUSER_ID, [], context=request.context)
-        countries = country.browse(request.cr, SUPERUSER_ID, country_ids, context=request.context)
+        countries = request.env['res.country'].search([])
         values = self._prepare_forum_values(forum=forum, searches=kwargs)
         values.update({
             'email_required': kwargs.get('email_required'),
@@ -623,7 +530,7 @@ class WebsiteForum(http.Controller):
         }
         if request.uid == user.id:  # the controller allows to edit only its own privacy settings; use partner management for other cases
             values['website_published'] = kwargs.get('website_published') == 'True'
-        request.registry['res.users'].write(request.cr, request.uid, [user.id], values, context=request.context)
+        user.write(values)
         return werkzeug.utils.redirect("/forum/%s/user/%d" % (slug(forum), user.id))
 
     # Badges
@@ -631,10 +538,8 @@ class WebsiteForum(http.Controller):
 
     @http.route('/forum/<model("forum.forum"):forum>/badge', type='http', auth="public", website=True)
     def badges(self, forum, **searches):
-        cr, uid, context = request.cr, request.uid, request.context
-        Badge = request.registry['gamification.badge']
-        badge_ids = Badge.search(cr, SUPERUSER_ID, [('challenge_ids.category', '=', 'forum')], context=context)
-        badges = Badge.browse(cr, uid, badge_ids, context=context)
+        Badge = request.env['gamification.badge']
+        badges = Badge.sudo().search([('challenge_ids.category', '=', 'forum')])
         badges = sorted(badges, key=lambda b: b.stat_count_distinct, reverse=True)
         values = self._prepare_forum_values(forum=forum, searches={'badges': True})
         values.update({
@@ -644,8 +549,7 @@ class WebsiteForum(http.Controller):
 
     @http.route(['''/forum/<model("forum.forum"):forum>/badge/<model("gamification.badge"):badge>'''], type='http', auth="public", website=True)
     def badge_users(self, forum, badge, **kwargs):
-        user_ids = [badge_user.user_id.id for badge_user in badge.owner_ids]
-        users = request.registry['res.users'].browse(request.cr, SUPERUSER_ID, user_ids, context=request.context)
+        users = [badge_user.user_id for badge_user in badge.sudo().owner_ids]
         values = self._prepare_forum_values(forum=forum, searches={'badges': True})
         values.update({
             'badge': badge,
@@ -658,17 +562,16 @@ class WebsiteForum(http.Controller):
 
     @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)
     def convert_comment_to_answer(self, forum, post, comment, **kwarg):
-        new_post_id = request.registry['forum.post'].convert_comment_to_answer(request.cr, request.uid, comment.id, context=request.context)
-        if not new_post_id:
+        post = request.env['forum.post'].convert_comment_to_answer(comment.id)
+        if not post:
             return werkzeug.utils.redirect("/forum/%s" % slug(forum))
-        post = request.registry['forum.post'].browse(request.cr, request.uid, new_post_id, context=request.context)
         question = post.parent_id if post.parent_id else post
         return werkzeug.utils.redirect("/forum/%s/question/%s" % (slug(forum), slug(question)))
 
     @http.route('/forum/<model("forum.forum"):forum>/post/<model("forum.post"):post>/convert_to_comment', type='http', auth="user", methods=['POST'], website=True)
     def convert_answer_to_comment(self, forum, post, **kwarg):
         question = post.parent_id
-        new_msg_id = request.registry['forum.post'].convert_answer_to_comment(request.cr, request.uid, post.id, context=request.context)
+        new_msg_id = post.convert_answer_to_comment()[0]
         if not new_msg_id:
             return werkzeug.utils.redirect("/forum/%s" % slug(forum))
         return werkzeug.utils.redirect("/forum/%s/question/%s" % (slug(forum), slug(question)))
@@ -677,4 +580,4 @@ class WebsiteForum(http.Controller):
     def delete_comment(self, forum, post, comment, **kwarg):
         if not request.session.uid:
             return {'error': 'anonymous_user'}
-        return request.registry['forum.post'].unlink_comment(request.cr, request.uid, post.id, comment.id, context=request.context)
+        return post.unlink_comment(comment.id)[0]