SoundSoftware Code Site

# Redmine - project management software

# Copyright (C) 2006-2012  Jean-Philippe Lang

#

# This program is free software; you can redistribute it and/or

# modify it under the terms of the GNU General Public License

# as published by the Free Software Foundation; either version 2

# of the License, or (at your option) any later version.

#

# This program is distributed in the hope that it will be useful,

# but WITHOUT ANY WARRANTY; without even the implied warranty of

# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

# GNU General Public License for more details.

#

# You should have received a copy of the GNU General Public License

# along with this program; if not, write to the Free Software

# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.

class Board < ActiveRecord::Base

  include Redmine::SafeAttributes

  belongs_to :project

  has_many :topics, :class_name => 'Message', :conditions => "#{Message.table_name}.parent_id IS NULL", :order => "#{Message.table_name}.created_on DESC"

  has_many :messages, :dependent => :destroy, :order => "#{Message.table_name}.created_on DESC"

  belongs_to :last_message, :class_name => 'Message', :foreign_key => :last_message_id

  acts_as_tree :dependent => :nullify

  acts_as_list :scope => '(project_id = #{project_id} AND parent_id #{parent_id ? "= #{parent_id}" : "IS NULL"})'

  acts_as_watchable

  validates_presence_of :name, :description

  validates_length_of :name, :maximum => 30

  validates_length_of :description, :maximum => 255

  validate :validate_board

  scope :visible, lambda {|*args| { :include => :project,

                                          :conditions => Project.allowed_to_condition(args.shift || User.current, :view_messages, *args) } }

  safe_attributes 'name', 'description', 'parent_id', 'move_to'

  def visible?(user=User.current)

    !user.nil? && user.allowed_to?(:view_messages, project)

  end

  def reload(*args)

    @valid_parents = nil

    super

  end

  def to_s

    name

  end

  def valid_parents

    @valid_parents ||= project.boards - self_and_descendants

  end

  def reset_counters!

    self.class.reset_counters!(id)

  end

  # Updates topics_count, messages_count and last_message_id attributes for +board_id+

  def self.reset_counters!(board_id)

    board_id = board_id.to_i

    update_all("topics_count = (SELECT COUNT(*) FROM #{Message.table_name} WHERE board_id=#{board_id} AND parent_id IS NULL)," +

               " messages_count = (SELECT COUNT(*) FROM #{Message.table_name} WHERE board_id=#{board_id})," +

               " last_message_id = (SELECT MAX(id) FROM #{Message.table_name} WHERE board_id=#{board_id})",

               ["id = ?", board_id])

  end

  def self.board_tree(boards, parent_id=nil, level=0)

    tree = []

    boards.select {|board| board.parent_id == parent_id}.sort_by(&:position).each do |board|

      tree << [board, level]

      tree += board_tree(boards, board.id, level+1)

    end

    if block_given?

      tree.each do |board, level|

        yield board, level

      end

    end

    tree

  end

  protected

  def validate_board

    if parent_id && parent_id_changed?

      errors.add(:parent_id, :invalid) unless valid_parents.include?(parent)

    end

  end

end

<%= form_tag({:action => 'edit', :tab => 'authentication'}) do %>

<div class="box tabular settings">

<p><%= setting_check_box :login_required %></p>

<p><%= setting_select :autologin, [[l(:label_disabled), 0]] + [1, 7, 30, 365].collect{|days| [l('datetime.distance_in_words.x_days', :count => days), days.to_s]} %></p>

<p><%= setting_select :self_registration, [[l(:label_disabled), "0"],

                                           [l(:label_registration_activation_by_email), "1"],

                                           [l(:label_registration_manual_activation), "2"],

                                           [l(:label_registration_automatic_activation), "3"]] %></p>

<p><%= setting_check_box :unsubscribe %></p>

<p><%= setting_text_field :password_min_length, :size => 6 %></p>

<p><%= setting_check_box :lost_password, :label => :label_password_lost %></p>

<p><%= setting_check_box :openid, :disabled => !Object.const_defined?(:OpenID) %></p>

<p><%= setting_check_box :rest_api_enabled %></p>

</div>

<fieldset class="box">

  <legend><%= l(:label_session_expiration) %></legend>

  <div class="tabular settings">

    <p><%= setting_select :session_lifetime, [[l(:label_disabled), 0]] + [1, 7, 30, 60, 365].collect{|days| [l('datetime.distance_in_words.x_days', :count => days), (days * 60 * 24).to_s]} %></p>

    <p><%= setting_select :session_timeout, [[l(:label_disabled), 0]] + [1, 2, 4, 8, 12, 24, 48].collect{|hours| [l('datetime.distance_in_words.x_hours', :count => hours), (hours * 60).to_s]} %></p>

  </div>

  <p><em class="info"><%= l(:text_session_expiration_settings) %></em></p>

</fieldset>

<%= submit_tag l(:button_save) %>

<% end %>

# Redmine - project management software

# Copyright (C) 2006-2012  Jean-Philippe Lang

#

# This program is free software; you can redistribute it and/or

# modify it under the terms of the GNU General Public License

# as published by the Free Software Foundation; either version 2

# of the License, or (at your option) any later version.

#

# This program is distributed in the hope that it will be useful,

# but WITHOUT ANY WARRANTY; without even the implied warranty of

# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

# GNU General Public License for more details.

#

# You should have received a copy of the GNU General Public License

# along with this program; if not, write to the Free Software

# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.

module Redmine

  module Acts

    module Customizable

      def self.included(base)

        base.extend ClassMethods

      end

      module ClassMethods

        def acts_as_customizable(options = {})

          return if self.included_modules.include?(Redmine::Acts::Customizable::InstanceMethods)

          cattr_accessor :customizable_options

          self.customizable_options = options

          has_many :custom_values, :as => :customized,

                                   :include => :custom_field,

                                   :order => "#{CustomField.table_name}.position",

                                   :dependent => :delete_all,

                                   :validate => false

          send :include, Redmine::Acts::Customizable::InstanceMethods

          validate :validate_custom_field_values

          after_save :save_custom_field_values

        end

      end

      module InstanceMethods

        def self.included(base)

          base.extend ClassMethods

        end

        def available_custom_fields

          CustomField.find(:all, :conditions => "type = '#{self.class.name}CustomField'",

                                 :order => 'position')

        end

        # Sets the values of the object's custom fields

        # values is an array like [{'id' => 1, 'value' => 'foo'}, {'id' => 2, 'value' => 'bar'}]

        def custom_fields=(values)

          values_to_hash = values.inject({}) do |hash, v|

            v = v.stringify_keys

            if v['id'] && v.has_key?('value')

              hash[v['id']] = v['value']

            end

            hash

          end

          self.custom_field_values = values_to_hash

        end

        # Sets the values of the object's custom fields

        # values is a hash like {'1' => 'foo', 2 => 'bar'}

        def custom_field_values=(values)

          values = values.stringify_keys

          custom_field_values.each do |custom_field_value|

            key = custom_field_value.custom_field_id.to_s

            if values.has_key?(key)

              value = values[key]

              if value.is_a?(Array)

                value = value.reject(&:blank?).uniq

                if value.empty?

                  value << ''

                end

              end

              custom_field_value.value = value

            end

          end

          @custom_field_values_changed = true

        end

        def custom_field_values

          @custom_field_values ||= available_custom_fields.collect do |field|

            x = CustomFieldValue.new

            x.custom_field = field

            x.customized = self

            if field.multiple?

              values = custom_values.select { |v| v.custom_field == field }

              if values.empty?

                values << custom_values.build(:customized => self, :custom_field => field, :value => nil)

              end

              x.value = values.map(&:value)

            else

              cv = custom_values.detect { |v| v.custom_field == field }

              cv ||= custom_values.build(:customized => self, :custom_field => field, :value => nil)

              x.value = cv.value

            end

            x

          end

        end

        def visible_custom_field_values

          custom_field_values.select(&:visible?)

        end

        def custom_field_values_changed?

          @custom_field_values_changed == true

        end

        def custom_value_for(c)

          field_id = (c.is_a?(CustomField) ? c.id : c.to_i)

          custom_values.detect {|v| v.custom_field_id == field_id }

        end

        def custom_field_value(c)

          field_id = (c.is_a?(CustomField) ? c.id : c.to_i)

          custom_field_values.detect {|v| v.custom_field_id == field_id }.try(:value)

        end

        def validate_custom_field_values

          if new_record? || custom_field_values_changed?

            custom_field_values.each(&:validate_value)

          end

        end

        def save_custom_field_values

          target_custom_values = []

          custom_field_values.each do |custom_field_value|

            if custom_field_value.value.is_a?(Array)

              custom_field_value.value.each do |v|

                target = custom_values.detect {|cv| cv.custom_field == custom_field_value.custom_field && cv.value == v}

                target ||= custom_values.build(:customized => self, :custom_field => custom_field_value.custom_field, :value => v)

                target_custom_values << target

              end

            else

              target = custom_values.detect {|cv| cv.custom_field == custom_field_value.custom_field}

              target ||= custom_values.build(:customized => self, :custom_field => custom_field_value.custom_field)

              target.value = custom_field_value.value

              target_custom_values << target

            end

          end

          self.custom_values = target_custom_values

          custom_values.each(&:save)

          @custom_field_values_changed = false

          true

        end

        def reset_custom_values!

          @custom_field_values = nil

          @custom_field_values_changed = true

        end

        module ClassMethods

        end

      end

    end

  end

end

scope1:

  id: 1

  body: Top Level

  lft: 1

  rgt: 10

  notable_id: 1

  notable_type: Category

child_1:

  id: 2

  body: Child 1

  parent_id: 1

  lft: 2

  rgt: 3

  notable_id: 1

  notable_type: Category

child_2:

  id: 3

  body: Child 2

  parent_id: 1

  lft: 4

  rgt: 7

  notable_id: 1

  notable_type: Category

child_3:

  id: 4

  body: Child 3

  parent_id: 1

  lft: 8

  rgt: 9

  notable_id: 1

  notable_type: Category

scope2:

  id: 5

  body: Top Level 2

  lft: 1

  rgt: 2

  notable_id: 1

  notable_type: Departments

# Redmine - project management software

# Copyright (C) 2006-2012  Jean-Philippe Lang

#

# This program is free software; you can redistribute it and/or

# modify it under the terms of the GNU General Public License

# as published by the Free Software Foundation; either version 2

# of the License, or (at your option) any later version.

#

# This program is distributed in the hope that it will be useful,

# but WITHOUT ANY WARRANTY; without even the implied warranty of

# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

# GNU General Public License for more details.

#

# You should have received a copy of the GNU General Public License

# along with this program; if not, write to the Free Software

# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.

require File.expand_path('../../test_helper', __FILE__)

class CommentTest < ActiveSupport::TestCase

  fixtures :users, :news, :comments, :projects, :enabled_modules

  def setup

    @jsmith = User.find(2)

    @news = News.find(1)

  end

  def test_create

    comment = Comment.new(:commented => @news, :author => @jsmith, :comments => "my comment")

    assert comment.save

    @news.reload

    assert_equal 2, @news.comments_count

  end

  def test_create_should_send_notification

    Watcher.create!(:watchable => @news, :user => @jsmith)

    with_settings :notified_events => %w(news_comment_added) do

      assert_difference 'ActionMailer::Base.deliveries.size' do

        Comment.create!(:commented => @news, :author => @jsmith, :comments => "my comment")

      end

    end

  end

  def test_validate

    comment = Comment.new(:commented => @news)

    assert !comment.save

    assert_equal 2, comment.errors.count

  end

  def test_destroy

    comment = Comment.find(1)

    assert comment.destroy

    @news.reload

    assert_equal 0, @news.comments_count

  end

end

<div class="contextual">

<%= link_to_if_authorized l(:button_log_time), {:controller => 'timelog', :action => 'new', :project_id => @project, :issue_id => @issue}, :class => 'icon icon-time-add' %>

</div>

<%= render_timelog_breadcrumb %>

<h2><%= l(:label_spent_time) %></h2>

<%= form_tag({:controller => 'timelog', :action => 'report',

              :project_id => @project, :issue_id => @issue},

            :method => :get, :id => 'query_form') do %>

  <% @report.criteria.each do |criterion| %>

    <%= hidden_field_tag 'criteria[]', criterion, :id => nil %>

  <% end %>

  <%= render :partial => 'timelog/date_range' %>

  <p><label for='columns'><%= l(:label_details) %></label>: <%= select_tag 'columns', options_for_select([[l(:label_year), 'year'],

                                                                            [l(:label_month), 'month'],

                                                                            [l(:label_week), 'week'],

                                                                            [l(:label_day_plural).titleize, 'day']], @report.columns),

                                                        :onchange => "this.form.submit();" %>

  <label for='criterias'><%= l(:button_add) %></label>: <%= select_tag('criteria[]', options_for_select([[]] + (@report.available_criteria.keys - @report.criteria).collect{|k| [l_or_humanize(@report.available_criteria[k][:label]), k]}),

                                                          :onchange => "this.form.submit();",

                                                          :style => 'width: 200px',

                                                          :id => nil,

                                                          :disabled => (@report.criteria.length >= 3), :id => "criterias") %>

     <%= link_to l(:button_clear), {:project_id => @project, :issue_id => @issue, :period_type => params[:period_type], :period => params[:period], :from => @from, :to => @to, :columns => @report.columns}, :class => 'icon icon-reload' %></p>

<% end %>

<% unless @report.criteria.empty? %>

<div class="total-hours">

<p><%= l(:label_total) %>: <%= html_hours(l_hours(@report.total_hours)) %></p>

</div>

<% unless @report.hours.empty? %>

<div class="autoscroll">

<table class="list" id="time-report">

<thead>

<tr>

<% @report.criteria.each do |criteria| %>

  <th><%= l_or_humanize(@report.available_criteria[criteria][:label]) %></th>

<% end %>

<% columns_width = (40 / (@report.periods.length+1)).to_i %>

<% @report.periods.each do |period| %>

  <th class="period" width="<%= columns_width %>%"><%= period %></th>

<% end %>

  <th class="total" width="<%= columns_width %>%"><%= l(:label_total) %></th>

</tr>

</thead>

<tbody>

<%= render :partial => 'report_criteria', :locals => {:criterias => @report.criteria, :hours => @report.hours, :level => 0} %>

  <tr class="total">

  <td><%= l(:label_total) %></td>

  <%= ('<td></td>' * (@report.criteria.size - 1)).html_safe %>

  <% total = 0 -%>

  <% @report.periods.each do |period| -%>

    <% sum = sum_hours(select_hours(@report.hours, @report.columns, period.to_s)); total += sum -%>

    <td class="hours"><%= html_hours("%.2f" % sum) if sum > 0 %></td>

  <% end -%>

  <td class="hours"><%= html_hours("%.2f" % total) if total > 0 %></td>

  </tr>

</tbody>

</table>

</div>

<% other_formats_links do |f| %>

  <%= f.link_to 'CSV', :url => params %>

<% end %>

<% end %>

<% end %>

<% html_title l(:label_spent_time), l(:label_report) %>