Added sortable headers + search + reportable Notes

[rails.git] / app / controllers / issues_controller.rb

diff --git a/app/controllers/issues_controller.rb b/app/controllers/issues_controller.rb
index bcea64be33de10c1f418d18571cd9ed9ee01bc37..ecac5bd1677bc324a1c70dd6a4cff119ea727a54 100644 (file)
--- a/app/controllers/issues_controller.rb
+++ b/app/controllers/issues_controller.rb
@@ -3,46 +3,55 @@ class IssuesController < ApplicationController
 
   before_action :authorize_web
   before_action :require_user
 
   before_action :authorize_web
   before_action :require_user

+  before_action :set_issues

   before_action :check_permission, only: [:index, :show, :resolve,:open,:ignore,:comment]
   before_action :find_issue, only: [:show, :resolve, :reopen, :ignore]
   before_action :check_permission, only: [:index, :show, :resolve,:open,:ignore,:comment]
   before_action :find_issue, only: [:show, :resolve, :reopen, :ignore]

+  before_action :get_user_role, only: [:show, :index]
+
+  helper_method :sort_column, :sort_direction

 
   def index
 
   def index

-    # Get user role
-    if @user.administrator?
-      @user_role = "administrator"
+    if @user.moderator?
+      @issue_types = @moderator_issues

     else
     else

-      @user_role = "moderator"
+      @issue_types = @admin_issues

     end
 
     end
 

+    @issues = Issue.where(issue_type: @user_role).order(sort_column + " " + sort_direction)
+

     # If search
     # If search

-    if params[:search_by_user]
+    if params[:search_by_user] and !params[:search_by_user].blank?

       @find_user = User.find_by_display_name(params[:search_by_user])
       if @find_user
       @find_user = User.find_by_display_name(params[:search_by_user])
       if @find_user

-        @issues = Issue.where(reported_user_id: @find_user.id, issue_type: @user_role).order(:status)
+        @issues = @issues.where(reported_user_id: @find_user.id)

       else 
       else 

-        @issues = Issue.where(issue_type: @user_role).order(:status)

         notice = t('issues.index.search.user_not_found') 
       end
         notice = t('issues.index.search.user_not_found') 
       end

+    end

 
 

-      if @find_user !=nil and @issues.first == nil
-        @issues = Issue.where(issue_type: @user_role).order(:status)
-        notice = t('issues.index.search.issues_not_found')
-      end

 
 

-      if notice
-        redirect_to issues_path, notice: notice
-      end 
-    
-    else
-      @issues = Issue.where(issue_type: @user_role).order(:status)
+    if params[:status] and !params[:status][0].blank?
+      @issues = @issues.where(status: params[:status][0].to_i)
+    end
+
+    if params[:issue_type] and !params[:issue_type][0].blank?
+      @issues = @issues.where(reportable_type: params[:issue_type][0])
+    end
+
+    if @issues.first == nil
+        notice = t('issues.index.search.issues_not_found')      

     end
     end

+
+    if notice
+      redirect_to issues_path, notice: notice
+    end 

   end
 
   def show
     @read_reports = @issue.read_reports
     @unread_reports = @issue.unread_reports
     @comments = @issue.comments
   end
 
   def show
     @read_reports = @issue.read_reports
     @unread_reports = @issue.unread_reports
     @comments = @issue.comments

-    @related_issues = @issue.user.issues
+    @related_issues = @issue.user.issues.where(issue_type: @user_role)

     if @issue.updated_by
       @updated_by_admin = User.find(@issue.updated_by)
     end
     if @issue.updated_by
       @updated_by_admin = User.find(@issue.updated_by)
     end


@@ -57,27 +66,23 @@ class IssuesController < ApplicationController
   end
 
   def create
   end
 
   def create

-
-    # TODO: Find better place to add these
-    admin_issues = [ 'DiaryEntry', 'DiaryComment', 'User']
-    moderator_issues = []
-
-    

     @issue = Issue.find_by_reportable_id_and_reportable_type(params[:reportable_id],params[:reportable_type])
     @issue = Issue.find_by_reportable_id_and_reportable_type(params[:reportable_id],params[:reportable_type])

-    # Check if Issue alrwady exists
+    # Check if Issue already exists

     if !@issue 
       @issue = Issue.find_or_initialize_by(issue_params)
       @issue.updated_by = nil
     if !@issue 
       @issue = Issue.find_or_initialize_by(issue_params)
       @issue.updated_by = nil

-      @admins = UserRole.where(role: "administrator")
-      @admins.each do |admin|
-        Notifier.new_issue_notification(User.find(admin.user_id)).deliver_now
-      end

 
       # Reassign to moderators if it is a moderator issue
       @issue.issue_type = "administrator"
 
       # Reassign to moderators if it is a moderator issue
       @issue.issue_type = "administrator"

-      if moderator_issues.include? @issue.reportable.class.name
+      if @moderator_issues.include? @issue.reportable.class.name

         reassign_issue
       end
         reassign_issue
       end

+
+      @admins_or_mods = UserRole.where(role: @issue.issue_type)
+      @admins_or_mods.each do |user|
+        Notifier.new_issue_notification(User.find(user.user_id)).deliver_now
+      end
+

     end
 
     # Check if details provided are sufficient
     end
 
     # Check if details provided are sufficient


@@ -86,7 +91,6 @@ class IssuesController < ApplicationController
       details =  get_report_details
       @report.reporter_user_id = @user.id
       @report.details = details
       details =  get_report_details
       @report.reporter_user_id = @user.id
       @report.details = details

-

       # Checking if instance has been updated since last report
       @last_report = @issue.reports.order(updated_at: :desc).last
       if check_if_updated
       # Checking if instance has been updated since last report
       @last_report = @issue.reports.order(updated_at: :desc).last
       if check_if_updated


@@ -96,6 +100,8 @@ class IssuesController < ApplicationController
       end
 
       if @issue.save!
       end
 
       if @issue.save!

+        @issue.report_count = @issue.reports.count
+        @issue.save!

         redirect_to root_path, notice: t('issues.create.successful_report')
       end
     else
         redirect_to root_path, notice: t('issues.create.successful_report')
       end
     else


@@ -129,7 +135,10 @@ class IssuesController < ApplicationController
         notice = t('issues.update.successful_update')
       end
 
         notice = t('issues.update.successful_update')
       end
 

+

       if @report.save!
       if @report.save!

+        @issue.report_count = @issue.reports.count
+        @issue.save!

         redirect_to root_path, notice: notice
       end
     else
         redirect_to root_path, notice: notice
       end
     else


@@ -139,16 +148,21 @@ class IssuesController < ApplicationController
 
   def comment
     @issue = Issue.find(params[:id])
 
   def comment
     @issue = Issue.find(params[:id])

-    @issue_comment = @issue.comments.build(issue_comment_params)
-    @issue_comment.commenter_user_id = @user.id
-    if params[:reassign]
-      reassign_issue
-      @issue_comment.reassign = true
-    end
-    @issue_comment.save!
-    @issue.updated_by = @user.id
-    @issue.save!
-    redirect_to @issue
+    if issue_comment_params.blank?
+      notice = t('issues.comment.provide_details')
+    else
+      @issue_comment = @issue.comments.build(issue_comment_params)
+      @issue_comment.commenter_user_id = @user.id
+      if params[:reassign]
+        reassign_issue
+        @issue_comment.reassign = true
+      end
+      @issue_comment.save!
+      @issue.updated_by = @user.id
+      @issue.save!
+      notice = t('issues.comment.comment_created')
+    end
+    redirect_to @issue, notice: notice

   end
 
   # Status Transistions
   end
 
   # Status Transistions


@@ -193,8 +207,22 @@ class IssuesController < ApplicationController
 
   private
 
 
   private
 

+    def set_issues
+      @admin_issues = [ 'DiaryEntry', 'DiaryComment', 'User']
+      @moderator_issues = [ 'Changeset', 'Note' ]
+    end
+
+    def get_user_role
+      # Get user role
+      if @user.administrator?
+        @user_role = "administrator"
+      else
+        @user_role = "moderator"
+      end      
+    end
+    

     def check_if_updated
     def check_if_updated

-      if @issue.reportable and (@issue.ignored? or @issue.resolved?) and @issue.reportable.updated_at > @last_report.updated_at
+      if @issue.reportable and (@issue.ignored? or @issue.resolved?) and @issue.reportable.has_attribute?(:updated_by) and @issue.reportable.updated_at > @last_report.updated_at

         return true
       else
         return false
         return true
       else
         return false


@@ -241,4 +269,11 @@ class IssuesController < ApplicationController
       params.require(:issue_comment).permit(:body)
     end
 
       params.require(:issue_comment).permit(:body)
     end
 

+    def sort_column
+      Issue.column_names.include?(params[:sort]) ? params[:sort] : "status"
+    end
+
+    def sort_direction
+      %w[asc desc].include?(params[:direction]) ? params[:direction] : "asc"
+    end

 end
 end