Redmine

<h3><%=l(:label_activity_latest)%></h3>

<%  date_from = Date.today - 1

    date_to = Date.today + 1

    events = []

    logger.debug "Gather activity between #{date_from} and #{date_to} ..."

    User.current.projects.each { |p| 

      logger.debug "Gather activity for #{p.name} ..."

      events += p.issues.find(:all, 

                               :conditions => ["#{Issue.table_name}.created_on >= ? and #{Issue.table_name}.created_on <= ?", 

                                               date_from, date_to])

      logger.debug "Gathered issues #{events.size} events..."

      events += p.issues_status_changes(date_from, date_to)

      logger.debug "Gathered notes #{events.size} events..."

      events += p.news.find(:all, 

                             :conditions => ["#{News.table_name}.created_on>=? and #{News.table_name}.created_on<=?", 

                                             date_from, date_to],

                             :include => :author )

      logger.debug "Gathered news #{events.size} events..."

      events += Attachment.find(:all, 

                                 :select => "#{Attachment.table_name}.*", :joins => "LEFT JOIN #{Version.table_name} ON #{Version.table_name}.id = #{Attachment.table_name}.container_id", 

                                 :conditions => ["#{Attachment.table_name}.container_type='Version' and #{Version.table_name}.project_id=? and #{Attachment.table_name}.created_on>=? and #{Attachment.table_name}.created_on<=?", 

                                                 p.id, date_from, date_to], 

                                 :include => :author )

      logger.debug "Gathered attachments #{events.size} events..."

      select = "#{WikiContent.versioned_table_name}.updated_on, #{WikiContent.versioned_table_name}.comments, " +

               "#{WikiContent.versioned_table_name}.#{WikiContent.version_column}, #{WikiPage.table_name}.title, " +

               "#{WikiContent.versioned_table_name}.page_id, #{WikiContent.versioned_table_name}.author_id, " +

               "#{WikiContent.versioned_table_name}.id"

      joins = "LEFT JOIN #{WikiPage.table_name} ON #{WikiPage.table_name}.id = #{WikiContent.versioned_table_name}.page_id " +

              "LEFT JOIN #{Wiki.table_name} ON #{Wiki.table_name}.id = #{WikiPage.table_name}.wiki_id "

      conditions = ["#{Wiki.table_name}.project_id = ? AND #{WikiContent.versioned_table_name}.updated_on BETWEEN ? AND ?",

                    p.id, date_from, date_to]

      events += WikiContent.versioned_class.find(:all, 

                                                  :select => select, 

                                                  :joins => joins, 

                                                  :conditions => conditions)

      logger.debug "Gathered wiki #{events.size} events..."

      events += Changeset.find(:all, 

                                :include => :repository, 

                                :conditions => ["#{Repository.table_name}.project_id = ? AND #{Changeset.table_name}.committed_on BETWEEN ? AND ?", 

                                                p.id, date_from, date_to])

      logger.debug "Gathered SCM #{events.size} events..."

      events += Message.find(:all, 

                              :include => [:board, :author], 

                              :conditions => ["#{Board.table_name}.project_id=? AND #{Message.table_name}.parent_id IS NULL AND #{Message.table_name}.created_on BETWEEN ? AND ?", 

                                              p.id, date_from, date_to])

      logger.debug "Gathered messages #{events.size} events..."

    }

    logger.debug "Gathered #{events.size} events between #{date_from} and #{date_to} ..."

    events_by_day = events.group_by(&:event_date)

%>

<% events_by_day.keys.sort {|x,y| y <=> x }.each do |day| %>

  <h3><%= day_name(day.cwday) %> <%= day.day %></h3>

  <ul>

  <% events_by_day[day].sort {|x,y| y.event_datetime <=> x.event_datetime }.each do |e| %>

    <li><p><%= format_time(e.event_datetime, false) %> <%= link_to truncate(e.event_title, 100), e.event_url %><br />

    <% unless e.event_description.blank? %><em><%= truncate(e.event_description, 500) %></em><br /><% end %>

    <span class="author"><%= e.event_author if e.respond_to?(:event_author) %></span></p></li>

  <% end %>

  </ul>

<% end %>

<% if events_by_day.empty? %><p class="nodata"><%= l(:label_no_data) %></p><% end %>