Redmine

    scope = scope.on_user(params[:member]) unless params[:member].nil?

    scope = scope.on_activity(params[:activity]) unless params[:activity].nil?

    scope = scope.on_tracker(params[:tracker]) unless params[:tracker].nil?

    scope = scope.on_version(params[:version]) unless params[:version].nil?

    scope = scope.on_category(params[:category]) unless params[:category].nil?

    scope = scope.on_project(Project.find(params[:project].to_i), false) unless params[:project].nil?

    scope = scope.on_project(Project.find(params[:toplevel_project].to_i), true) unless params[:toplevel_project].nil?	

    @issue = Issue.find(params[:issue]) unless params[:issue].nil?

        obj.visible? ? link_to_issue(obj, :project => true) : "##{obj.id}"

      elsif obj.is_a?(User) || obj.is_a?(Project)

        link_to(h(obj.to_s), obj)

  def criteria_date_range(period, value)

    from, to = nil, nil 

    case period 

    when 'day' 

      from = to = value 

    when 'week'

      from = Date.commercial(value.split('-')[0].to_f, value.split('-')[1].to_f, 1); to = from + 6 

    when 'month' 

      from = Date.civil(value.split('-')[0].to_f, value.split('-')[1].to_f, 1); to = (from >> 1) - 1 

    when 'year' 

      from = Date.civil(value.split('-')[0].to_f, 1, 1); to = Date.civil(value.split('-')[0].to_f, 12, 31) 

    end 

    from = params[:from].to_s.to_date if !params[:from].blank? && params[:from].to_s.to_date > from.to_date 

    to = params[:to].to_s.to_date if !params[:to].blank? && params[:to].to_s.to_date < to.to_date 

    return {:from => from, :to => to}

  end

  scope :on_user, lambda {|user| {

    :conditions => ["#{TimeEntry.table_name}.user_id = ?", user]

  }}

  scope :on_activity, lambda {|activity| {

    :conditions => ["#{TimeEntry.table_name}.activity_id = ?", activity]

  }}

  scope :on_tracker, lambda {|tracker| {

    :include => :issue,

    :conditions => ["#{Issue.table_name}.tracker_id = ?", tracker]

  }}

  scope :on_version, lambda {|version| {

    :include => :issue,

    :conditions => ["#{Issue.table_name}.fixed_version_id = ?", version]

  }}

  scope :on_category, lambda {|category| {

    :include => :issue,

    :conditions => ["#{Issue.table_name}.category_id = ?", category]

  }}

<% hours_for_value = grand_total ? hours: select_hours(hours, criterias[level], value) -%>

<tr class="<%= cycle('odd', 'even') %> <%= grand_total ? 'total' : criterias.length > level+1 ? 'subtotal' : 'last-level' %>  <%= 'current-users-row' if criterias[level] == 'member' && User.current.try(:id) == value.to_i %>">

<td><%= grand_total ? l(:label_total) : h(format_criteria_value(@report.available_criteria[criterias[level]], value)) %></td>

  <% total = 0; criteria_values = {} if level == 0 -%>

  <% criteria_level_values = criteria_values.merge({criterias[level].to_sym => value}) -%>

    <td class="hours"><%= link_to html_hours("%.2f" % sum), {:controller => 'timelog', :action => 'index'}.merge(criteria_level_values).merge(criteria_date_range(@report.columns.to_s, period)) if sum > 0 %></td>

  <td class="hours"><%= (link_to html_hours("%.2f" % total), {:controller => 'timelog', :action => 'index', :period => params[:period], :from => @from, :to => @to}.merge(criteria_level_values)) if total > 0 %></td>

<% break if grand_total  %>

  <%= render(:partial => 'report_criteria', :locals => {:criterias => criterias, :criteria_values => criteria_level_values.merge({criterias[level].to_sym => value}), :hours => hours_for_value, :level => (level + 1), :grand_total => false}) %>

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

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