Redmine

  layout 'base'

  before_filter :find_project, :authorize, :except => [ :index, :list, :add ]

  include SortHelper	

  helper :search_filter

  include SearchFilterHelper	

  helper :custom_fields

  include CustomFieldsHelper   

  def index

    list

    render :action => 'list'

  end

  # Show issues list of @project

  def list_issues

    sort_init 'issues.id', 'desc'

    sort_update

    search_filter_init_list_issues

    search_filter_update if params[:set_filter] or request.post?

    @issue_count = Issue.count(:include => :status, :conditions => search_filter_clause)		

    @issue_pages = Paginator.new self, @issue_count, 15, @params['page']								

    @issues =  Issue.find :all, :order => sort_clause,

  end

  # Export filtered/sorted issues list to CSV

  def export_issues_csv

    sort_init 'issues.id', 'desc'

    sort_update

    search_filter_init_list_issues

    @issues =  Issue.find :all, :order => sort_clause,

						:include => [ :author, :status, :tracker ],

						:conditions => search_filter_clause							

    export = StringIO.new

    CSV::Writer.generate(export, ',') do |csv|

      csv << %w(Id Status Tracker Subject Author Created Updated)

      @issues.each do |issue|

        csv << [issue.id, issue.status.name, issue.tracker.name, issue.subject, issue.author.display_name, _('(time)', issue.created_on),  _('(time)', issue.updated_on)]

      end

    end

    export.rewind

    send_data(export.read,

      :type => 'text/csv; charset=utf-8; header=present',

      :filename => 'export.csv')

  end

  def list_news

  end

  # Show changelog of @project

  def changelog

    @fixed_issues = @project.issues.find(:all, 

                                       :include => [ :fixed_version, :status, :tracker ], 

                                       :conditions => [ "issue_statuses.is_closed=? and trackers.is_in_chlog=? and issues.fixed_version_id is not null", true, true]

                                      )

  end

  def search_filter_criteria(name, options = {})

    session[:search_filter] ||= {}

    session[:search_filter][name] ||= {}

    unless session[:search_filter][name][:options] and session[:search_filter][name][:conditions]

      session[:search_filter][name][:options] = []

      session[:search_filter][name][:conditions] = {}

      yield.each { |c|

        session[:search_filter][name][:options] << [c[0], c[1].to_s]

        session[:search_filter][name][:conditions].store(c[1].to_s, c[2])

      }

    end

  end

  def search_filter_update

    session[:search_filter].each_key {|field| session[:search_filter][field][:value] = params[field]  }

  end

  def search_filter_clause

    clause = ["issues.project_id=?", @project.id]

    session[:search_filter].each { |k, v|

      v[:value] ||= v[:options][0][1]

      if (!v[:conditions][v[:value]][0].empty?)

        clause[0] = clause[0] + " AND " + v[:conditions][v[:value]][0]

        clause << v[:conditions][v[:value]][1] if !v[:conditions][v[:value]][1].nil?

      end    

    }

    clause

  end

  def search_filter_tag(criteria)

    content_tag("select", 

				options_for_select(session[:search_filter][criteria][:options], session[:search_filter][criteria][:value]),

				:name => criteria

  end

  def search_filter_init_list_issues

	search_filter_criteria('status_id') { 

    [ ["[Open]", "O", ["issue_statuses.is_closed=?", false]],

      ["[All]", "A", ["", false]]

    ] + IssueStatus.find(:all).collect {|s| [s.name, s.id, ["issues.status_id=?", s.id]] }                                                      

    }

    search_filter_criteria('tracker_id') { 

    [ ["[All]", "A", ["", false]]

    ] + Tracker.find(:all).collect {|s| [s.name, s.id, ["issues.tracker_id=?", s.id]] }                                                      

    }

    search_filter_criteria('priority_id') { 

    [ ["[All]", "A", ["", false]]

    ] + Enumeration.find(:all, :conditions => ['opt=?','IPRI']).collect {|s| [s.name, s.id, ["issues.priority_id=?", s.id]] }                                                      

    }

    search_filter_criteria('category_id') { 

    [ ["[All]", "A", ["", false]],

      ["[None]", "N", ["issues.category_id is null"]]

    ] + @project.issue_categories.find(:all).collect {|s| [s.name, s.id, ["issues.category_id=?", s.id]] }                                                      

    }    

    search_filter_criteria('assigned_to_id') { 

    [ ["[All]", "A", ["", false]],

      ["[Nobody]", "N", ["issues.assigned_to_id is null"]]

    ] + User.find(:all).collect {|s| [s.display_name, s.id, ["issues.assigned_to_id=?", s.id]] }                                                      

    }   	

  end

    <td><%=_('Status')%>:<br /><%= search_filter_tag("status_id") %></td>

    <td><%=_('Tracker')%>:<br /><%= search_filter_tag("tracker_id") %></td>

    <td><%=_('Priority')%>:<br /><%= search_filter_tag("priority_id") %></td>

    <td><%=_('Category')%>:<br /><%= search_filter_tag("category_id") %></td>

    <td><%=_('Assigned to')%>:<br /><%= search_filter_tag("assigned_to_id") %></td>

</table>

  

	   <tr><td colspan="7" align="right">

	   <small><%= link_to 'Export to CSV', :action => 'export_issues_csv', :id => @project.id %></small>

	   </td></tr>

    </p>

                                                "#{field_name}" => row.id %></td>

                                                "status_id" => status.id, 

                                                "#{field_name}" => row.id %></td>

  <td align="center"><%= link_to (aggregate data, { field_name => row.id, "closed" => 0 }),

                                                :controller => 'projects', :action => 'list_issues', :id => @project, 

                                                :set_filter => 1, 

                                                "#{field_name}" => row.id,

                                                "status_id" => "O" %></td>

                                                "#{field_name}" => row.id,

                                                "status_id" => "A" %></td>  

== xx/xx/2006

* More filter options in issues list

* Issues list exportable to CSV

* Fixed: Error on tables creation with PostgreSQL (rev5)

* Fixed: SQL error in "issue reports" view with PostgreSQL (rev5)