jro_apps/redmine Files · app/models/time_entry.rb

Added per user custom queries....

Added per user custom queries. Any logged in user can now save queries (they are not visible to the other users). Only users with explicit permission can manage queries that are visible to anyone. The queries list is removed from the "Reports" view. It can now be accessed from the issues list. git-svn-id: http://redmine.rubyforge.org/svn/trunk@566 e93f8b46-1217-0410-a6f0-8f06a7374b81

Jean-Philippe Lang - - Load All Authors

File last commit:

r476:52547466f0f1


                r563:1c44600c62dc

Download file

             time_entry.rb
        
                    33 lines
            
             | 1.3 KiB
            
                | text/x-ruby
            
             |
                RubyLexer
            
             / app / models / time_entry.rb
          
                    History
                
                 |
                  Annotation
                 | Raw
                 |Copy content
                 |Copy permalink

      class TimeEntry < ActiveRecord::Base

        # could have used polymorphic association

        # project association here allows easy loading of time entries at project level with one database trip

        belongs_to :project

        belongs_to :issue

        belongs_to :user

        belongs_to :activity, :class_name => 'Enumeration', :foreign_key => :activity_id

        attr_protected :project_id, :user_id, :tyear, :tmonth, :tweek

        validates_presence_of :user_id, :activity_id, :project_id, :hours, :spent_on

        validates_numericality_of :hours, :allow_nil => true

        validates_length_of :comments, :maximum => 255

        def before_validation

          self.project = issue.project if issue && project.nil?

        end

        def validate

          errors.add :hours, :activerecord_error_invalid if hours && (hours < 0 || hours >= 1000)

          errors.add :project_id, :activerecord_error_invalid if project.nil?

          errors.add :issue_id, :activerecord_error_invalid if (issue_id && !issue) || (issue && project!=issue.project)

        end

        # tyear, tmonth, tweek assigned where setting spent_on attributes

        # these attributes make time aggregations easier

        def spent_on=(date)

          super

          self.tyear = spent_on ? spent_on.year : nil

          self.tmonth = spent_on ? spent_on.month : nil

          self.tweek = spent_on ? Date.civil(spent_on.year, spent_on.month, spent_on.day).cweek : nil

        end  

      end

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
g 0-9	Goto bookmarked items from 0-9
n r	New repository page
n g	New gist page

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings
t s	Toggle sidebar on some pages

				class TimeEntry < ActiveRecord::Base
				# could have used polymorphic association
				# project association here allows easy loading of time entries at project level with one database trip
				belongs_to :project
				belongs_to :issue
				belongs_to :user
				belongs_to :activity, :class_name => 'Enumeration', :foreign_key => :activity_id

				attr_protected :project_id, :user_id, :tyear, :tmonth, :tweek

				validates_presence_of :user_id, :activity_id, :project_id, :hours, :spent_on
				validates_numericality_of :hours, :allow_nil => true
				validates_length_of :comments, :maximum => 255

				def before_validation
				self.project = issue.project if issue && project.nil?
				end

				def validate
				errors.add :hours, :activerecord_error_invalid if hours && (hours < 0 \|\| hours >= 1000)
				errors.add :project_id, :activerecord_error_invalid if project.nil?
				errors.add :issue_id, :activerecord_error_invalid if (issue_id && !issue) \|\| (issue && project!=issue.project)
				end

				# tyear, tmonth, tweek assigned where setting spent_on attributes
				# these attributes make time aggregations easier
				def spent_on=(date)
				super
				self.tyear = spent_on ? spent_on.year : nil
				self.tmonth = spent_on ? spent_on.month : nil
				self.tweek = spent_on ? Date.civil(spent_on.year, spent_on.month, spent_on.day).cweek : nil
				end
				end