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

Fixed: 10342 Creation of Schema in Oracle...

Fixed: 10342 Creation of Schema in Oracle Comment is a reserved keyword for Oracle. The five 'Comment' columns are renamed to 'Commments'. Migration scripts were modified to let oracle users create the database. For the others, migration 41 will rename the columns (only if columns have the 'old' name). Fixed also a few oracle specific issues. Note: currently (in Rails 1.2.3), there's bug in Rails oracle adapter. See: http://dev.rubyonrails.org/ticket/7344 Attached patch is required for redMine to work properly. git-svn-id: http://redmine.rubyforge.org/svn/trunk@479 e93f8b46-1217-0410-a6f0-8f06a7374b81

Jean-Philippe Lang - - Load All Authors

File last commit:

r476:52547466f0f1


                r476:52547466f0f1

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