Patch #26030

Like issues and news comments, want to specify the display order of the forum's reply.

Added by Minoru Maeda about 2 years ago. Updated about 1 month ago.

Status:NewStart date:
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:Forums
Target version:4.1.0

Description

This patch also applies the setting order of comments in "My account" to the forum.

reply_order.patch Magnifier (2.82 KB) Minoru Maeda, 2017-05-24 11:23

reply_display_order_with_pre_page.patch Magnifier (3.87 KB) Minoru Maeda, 2017-05-25 08:51


Related issues

Related to Redmine - Feature #26033: Respect "Objects per page" option when displaying forum r... Closed
Related to Redmine - Patch #11120: Order replies of messages boards based on user preference New

History

#1 Updated by Go MAEDA about 2 years ago

Thank you for posting the patch.
But I think it would be better not to assume that the value of REPLIES_PER_PAGE constant is always 25. The test in your patch may fail if #26033 is implemented.

#2 Updated by Minoru Maeda about 2 years ago

Hello, Go MAEDA. Thank you for your advice.
I improved it in order of reply display considering "per_page".

#3 Updated by Toshi MARUYAMA about 2 years ago

  • Related to Feature #26033: Respect "Objects per page" option when displaying forum replies added

#4 Updated by Toshi MARUYAMA about 2 years ago

  • Related to Patch #11120: Order replies of messages boards based on user preference added

#5 Updated by Go MAEDA about 2 years ago

  • Target version set to 4.1.0

The patch works fine for me. And it also implements #26033.
Setting target version to 3.5.0.

#6 Updated by Popoki Tom (@cat_in_136) about 1 month ago

This patch is great work but sometimes did not work well on my environment.

my environment:
  • MySQL 5.6.42 (ClearDB)
  • Ruby 2.5.5p157
  • Redmine 4.0.3 + reply_display_order_with_pre_page.patch
When showing the topic where
  • count of the topic children is larger than per_page_option, and
  • some children has more than one attachment files

In which case, r=xx parameter may not be expanded correctly due to incorrect paging.

On my environment, @replies.pluck(:id) generated an array containing duplicate IDs.
I could not identify the root cause, but I found a line includes(:author, :attachments, {:board => :project}) cause this problem.
Therefore, I corrected this problem as follows to avoid this problem:

--- a/app/controllers/messages_controller.rb
+++ b/app/controllers/messages_controller.rb
@@ -34,7 +34,6 @@ class MessagesController < ApplicationController
     # Find the page of the requested reply
     replies_order = User.current.wants_comments_in_reverse_order? ? 'DESC' : 'ASC'
     @replies = @topic.children.
-      includes(:author, :attachments, {:board => :project}).
       reorder("#{Message.table_name}.created_on #{replies_order}, #{Message.table_name}.id #{replies_order}")

     if params[:r] && page.nil?
@@ -45,6 +44,7 @@ class MessagesController < ApplicationController
     @reply_count = @replies.count
     @reply_pages = Paginator.new @reply_count, per_page_option, page
     @replies = @replies.
+      includes(:author, :attachments, {:board => :project}).
       limit(@reply_pages.per_page).
       offset(@reply_pages.offset).
       to_a

Also available in: Atom PDF