jro_apps/redmine Commit - r2604:b557393252cc

0

db/migrate/20090425161243_add_queries_group_by.rb created 644 +9 0

@@ -0,0 +1,9
	1	class AddQueriesGroupBy < ActiveRecord::Migration
	2	def self.up
	3	add_column :queries, :group_by, :string
	4	end
	5
	6	def self.down
	7	remove_column :queries, :group_by
	8	end
	9	end

0

app/controllers/issues_controller.rb +17 -5

                   end
                   @issue_count = Issue.count(:include => [:status, :project], :conditions => @query.statement)
                   @issue_pages = Paginator.new self, @issue_count, limit, params['page']
-                  @issues = Issue.find :all, :order => sort_clause,
+                  @issues = Issue.find :all, :order => [@query.group_by_sort_order, sort_clause].compact.join(','),
                                        :include => [ :assigned_to, :status, :tracker, :project, :priority, :category, :fixed_version ],
                                        :conditions => @query.statement,
                                        :limit  =>  limit,
                                        :offset =>  @issue_pages.current.offset
                   respond_to do |format|
-                    format.html { render :template => 'issues/index.rhtml', :layout => !request.xhr? }
+                    format.html {
+                      if @query.grouped?
+                        # Retrieve the issue count by group
+                        @issue_count_by_group = begin
+                          Issue.count(:group => @query.group_by, :include => [:status, :project], :conditions => @query.statement)
+                        # Rails will raise an (unexpected) error if there's only a nil group value
+                        rescue ActiveRecord::RecordNotFound
+                          {nil => @issue_count}
+                        end
+                      end
+                      render :template => 'issues/index.rhtml', :layout => !request.xhr?
+                    }
                     format.atom { render_feed(@issues, :title => "#{@project || Setting.app_title}: #{l(:label_issue_plural)}") }
                     format.csv  { send_data(issues_to_csv(@issues, @project).read, :type => 'text/csv; header=present', :filename => 'export.csv') }
-                    format.pdf  { send_data(issues_to_pdf(@issues, @project), :type => 'application/pdf', :filename => 'export.pdf') }
+                    format.pdf  { send_data(issues_to_pdf(@issues, @project, @query), :type => 'application/pdf', :filename => 'export.pdf') }
                   end
                 else
                   # Send html if the query is not valid
                         @query.add_short_filter(field, params[field]) if params[field]
                       end
                     end
-                    session[:query] = {:project_id => @query.project_id, :filters => @query.filters}
+                    @query.group_by = params[:group_by]
+                    session[:query] = {:project_id => @query.project_id, :filters => @query.filters, :group_by => @query.group_by}
                   else
                     @query = Query.find_by_id(session[:query][:id]) if session[:query][:id]
-                    @query ||= Query.new(:name => "_", :project => @project, :filters => session[:query][:filters])
+                    @query ||= Query.new(:name => "_", :project => @project, :filters => session[:query][:filters], :group_by => session[:query][:group_by])
                     @query.project = @project
                   end
                 end

0

app/controllers/queries_controller.rb +1 0

                 params[:fields].each do |field|
                   @query.add_filter(field, params[:operators][field], params[:values][field])
                 end if params[:fields]
+                @query.group_by ||= params[:group_by]
                 if request.post? && params[:confirm] && @query.save
                   flash[:notice] = l(:notice_successful_create)

0

app/models/query.rb +33 -9

             # Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
             class QueryColumn
-              attr_accessor :name, :sortable, :default_order
+              attr_accessor :name, :sortable, :groupable, :default_order
               include Redmine::I18n
               def initialize(name, options={})
                 self.name = name
                 self.sortable = options[:sortable]
+                self.groupable = options[:groupable] || false
                 self.default_order = options[:default_order]
               end
               cattr_reader :operators_by_filter_type
               @@available_columns = [
-                QueryColumn.new(:project, :sortable => "#{Project.table_name}.name"),
+                QueryColumn.new(:project, :sortable => "#{Project.table_name}.name", :groupable => true),
-                QueryColumn.new(:tracker, :sortable => "#{Tracker.table_name}.position"),
+                QueryColumn.new(:tracker, :sortable => "#{Tracker.table_name}.position", :groupable => true),
-                QueryColumn.new(:status, :sortable => "#{IssueStatus.table_name}.position"),
+                QueryColumn.new(:status, :sortable => "#{IssueStatus.table_name}.position", :groupable => true),
-                QueryColumn.new(:priority, :sortable => "#{Enumeration.table_name}.position", :default_order => 'desc'),
+                QueryColumn.new(:priority, :sortable => "#{Enumeration.table_name}.position", :default_order => 'desc', :groupable => true),
                 QueryColumn.new(:subject, :sortable => "#{Issue.table_name}.subject"),
                 QueryColumn.new(:author),
-                QueryColumn.new(:assigned_to, :sortable => ["#{User.table_name}.lastname", "#{User.table_name}.firstname"]),
+                QueryColumn.new(:assigned_to, :sortable => ["#{User.table_name}.lastname", "#{User.table_name}.firstname", "#{User.table_name}.id"], :groupable => true),
                 QueryColumn.new(:updated_on, :sortable => "#{Issue.table_name}.updated_on", :default_order => 'desc'),
-                QueryColumn.new(:category, :sortable => "#{IssueCategory.table_name}.name"),
+                QueryColumn.new(:category, :sortable => "#{IssueCategory.table_name}.name", :groupable => true),
-                QueryColumn.new(:fixed_version, :sortable => ["#{Version.table_name}.effective_date", "#{Version.table_name}.name"], :default_order => 'desc'),
+                QueryColumn.new(:fixed_version, :sortable => ["#{Version.table_name}.effective_date", "#{Version.table_name}.name"], :default_order => 'desc', :groupable => true),
                 QueryColumn.new(:start_date, :sortable => "#{Issue.table_name}.start_date"),
                 QueryColumn.new(:due_date, :sortable => "#{Issue.table_name}.due_date"),
                 QueryColumn.new(:estimated_hours, :sortable => "#{Issue.table_name}.estimated_hours"),
-                QueryColumn.new(:done_ratio, :sortable => "#{Issue.table_name}.done_ratio"),
+                QueryColumn.new(:done_ratio, :sortable => "#{Issue.table_name}.done_ratio", :groupable => true),
                 QueryColumn.new(:created_on, :sortable => "#{Issue.table_name}.created_on", :default_order => 'desc'),
               ]
               cattr_reader :available_columns
                                        ).collect {|cf| QueryCustomFieldColumn.new(cf) }
               end
+              # Returns an array of columns that can be used to group the results
+              def groupable_columns
+                available_columns.select {|c| c.groupable}
+              end
               def columns
                 if has_default_columns?
                   available_columns.select do |c|
                 sort_criteria && sort_criteria[arg] && sort_criteria[arg].last
               end
+              # Returns the SQL sort order that should be prepended for grouping
+              def group_by_sort_order
+                if grouped? && (column = group_by_column)
+                  column.sortable.is_a?(Array) ?
+                    column.sortable.collect {|s| "#{s} #{column.default_order}"}.join(',') :
+                    "#{column.sortable} #{column.default_order}"
+                end
+              end
+              # Returns true if the query is a grouped query
+              def grouped?
+                !group_by.blank?
+              end
+              def group_by_column
+                groupable_columns.detect {|c| c.name.to_s == group_by}
+              end
               def project_statement
                 project_clauses = []
                 if project && !@project.descendants.active.empty?

0

app/views/issues/_list.rhtml +10 0

                       <%= column_header(column) %>
                     <% end %>
             	</tr></thead>
+            	<% group = false %>
             	<tbody>
             	<% issues.each do |issue| -%>
+              <% if @query.grouped? && issue.send(@query.group_by) != group %>
+                <% group = issue.send(@query.group_by) %>
+                <% reset_cycle %>
+                <tr class="group">
+                	<td colspan="<%= query.columns.size + 2 %>">
+                  	<%= group.blank? ? 'None' : group %> <span class="count">(<%= @issue_count_by_group[group] %>)</span>
+                	</td>
+            		</tr>
+              <% end %>
             	<tr id="issue-<%= issue.id %>" class="hascontextmenu <%= cycle('odd', 'even') %> <%= issue.css_classes %>">
             	    <td class="checkbox"><%= check_box_tag("ids[]", issue.id, false, :id => nil) %></td>
             		<td><%= link_to issue.id, :controller => 'issues', :action => 'show', :id => issue %></td>

0

app/views/issues/index.rhtml +7 -1

                 <% form_tag({ :controller => 'queries', :action => 'new' }, :id => 'query_form') do %>
                 <%= hidden_field_tag('project_id', @project.to_param) if @project %>
+            		<div id="query_form_content">
                 <fieldset id="filters"><legend><%= l(:label_filter_plural) %></legend>
                 <%= render :partial => 'queries/filters', :locals => {:query => @query} %>
+                </fieldset>
+            		<p><%= l(:field_group_by) %>
+            		<%= select_tag('group_by', options_for_select([[]] + @query.groupable_columns.collect {|c| [c.caption, c.name.to_s]}, @query.group_by)) %></p>
+            		</div>
                 <p class="buttons">
                 <%= link_to_remote l(:button_apply),
                                    { :url => { :set_filter => 1 },
                                      :update => "content",
                 <%= link_to l(:button_save), {}, :onclick => "$('query_form').submit(); return false;", :class => 'icon icon-save' %>
                 <% end %>
                 </p>
-                </fieldset>
                 <% end %>
             <% else %>
                 <div class="contextual">
                 <div id="query_form"></div>
                 <% html_title @query.name %>
             <% end %>
             <%= error_messages_for 'query' %>
             <% if @query.valid? %>
             <% if @issues.empty? %>

0

app/views/queries/_form.rhtml +3 0

             <p><label for="query_default_columns"><%=l(:label_default_columns)%></label>
             <%= check_box_tag 'default_columns', 1, @query.has_default_columns?, :id => 'query_default_columns',
                   :onclick => 'if (this.checked) {Element.hide("columns")} else {Element.show("columns")}' %></p>
+            <p><label for="query_group_by"><%= l(:field_group_by) %></label>
+            <%= select 'query', 'group_by', @query.groupable_columns.collect {|c| [c.caption, c.name.to_s]}, :include_blank => true %></p>
             </div>
             <fieldset><legend><%= l(:label_filter_plural) %></legend>

0

config/locales/bg.yml +1 0

               text_wiki_page_nullify_children: Keep child pages as root pages
               text_wiki_page_destroy_children: Delete child pages and all their descendants
               setting_password_min_length: Minimum password length
+              field_group_by: Group results by

0

config/locales/bs.yml +1 0

               text_wiki_page_nullify_children: Keep child pages as root pages
               text_wiki_page_destroy_children: Delete child pages and all their descendants
               setting_password_min_length: Minimum password length
+              field_group_by: Group results by

0

config/locales/ca.yml +1 0

               text_wiki_page_nullify_children: Keep child pages as root pages
               text_wiki_page_destroy_children: Delete child pages and all their descendants
               setting_password_min_length: Minimum password length
+              field_group_by: Group results by

0

config/locales/cs.yml +1 0

               text_wiki_page_nullify_children: Keep child pages as root pages
               text_wiki_page_destroy_children: Delete child pages and all their descendants
               setting_password_min_length: Minimum password length
+              field_group_by: Group results by

0

config/locales/da.yml +1 0

               text_wiki_page_nullify_children: Keep child pages as root pages
               text_wiki_page_destroy_children: Delete child pages and all their descendants
               setting_password_min_length: Minimum password length
+              field_group_by: Group results by

0

config/locales/de.yml +1 0

               text_wiki_page_nullify_children: Keep child pages as root pages
               text_wiki_page_destroy_children: Delete child pages and all their descendants
               setting_password_min_length: Minimum password length
+              field_group_by: Group results by

0

config/locales/en.yml +1 0

               field_watcher: Watcher
               field_identity_url: OpenID URL
               field_content: Content
+              field_group_by: Group results by
               setting_app_title: Application title
               setting_app_subtitle: Application subtitle

0

config/locales/es.yml +1 0

               text_wiki_page_nullify_children: Keep child pages as root pages
               text_wiki_page_destroy_children: Delete child pages and all their descendants
               setting_password_min_length: Minimum password length
+              field_group_by: Group results by

0

config/locales/fi.yml +1 0

               text_wiki_page_nullify_children: Keep child pages as root pages
               text_wiki_page_destroy_children: Delete child pages and all their descendants
               setting_password_min_length: Minimum password length
+              field_group_by: Group results by

0

config/locales/fr.yml +1 0

               field_watcher: Observateur
               field_identity_url: URL OpenID
               field_content: Contenu
+              field_group_by: Grouper par
               setting_app_title: Titre de l'application
               setting_app_subtitle: Sous-titre de l'application

0

config/locales/gl.yml +1 0

               text_wiki_page_nullify_children: Keep child pages as root pages
               text_wiki_page_destroy_children: Delete child pages and all their descendants
               setting_password_min_length: Minimum password length
+              field_group_by: Group results by

0

config/locales/he.yml +1 0

               text_wiki_page_nullify_children: Keep child pages as root pages
               text_wiki_page_destroy_children: Delete child pages and all their descendants
               setting_password_min_length: Minimum password length
+              field_group_by: Group results by

0

config/locales/hu.yml +1 0

               text_wiki_page_nullify_children: Keep child pages as root pages
               text_wiki_page_destroy_children: Delete child pages and all their descendants
               setting_password_min_length: Minimum password length
+              field_group_by: Group results by

0

config/locales/it.yml +1 0

               text_wiki_page_nullify_children: Keep child pages as root pages
               text_wiki_page_destroy_children: Delete child pages and all their descendants
               setting_password_min_length: Minimum password length
+              field_group_by: Group results by

0

config/locales/ja.yml +1 0

               text_wiki_page_nullify_children: Keep child pages as root pages
               text_wiki_page_destroy_children: Delete child pages and all their descendants
               setting_password_min_length: Minimum password length
+              field_group_by: Group results by

0

config/locales/ko.yml +1 0

               text_wiki_page_nullify_children: Keep child pages as root pages
               text_wiki_page_destroy_children: Delete child pages and all their descendants
               setting_password_min_length: Minimum password length
+              field_group_by: Group results by

0

config/locales/lt.yml +1 0

               text_wiki_page_nullify_children: Keep child pages as root pages
               text_wiki_page_destroy_children: Delete child pages and all their descendants
               setting_password_min_length: Minimum password length
+              field_group_by: Group results by

0

config/locales/nl.yml +1 0

               text_wiki_page_nullify_children: Keep child pages as root pages
               text_wiki_page_destroy_children: Delete child pages and all their descendants
               setting_password_min_length: Minimum password length
+              field_group_by: Group results by

0

config/locales/no.yml +1 0

               text_wiki_page_nullify_children: Keep child pages as root pages
               text_wiki_page_destroy_children: Delete child pages and all their descendants
               setting_password_min_length: Minimum password length
+              field_group_by: Group results by

0

config/locales/pl.yml +1 0

               text_wiki_page_nullify_children: Keep child pages as root pages
               text_wiki_page_destroy_children: Delete child pages and all their descendants
               setting_password_min_length: Minimum password length
+              field_group_by: Group results by

0

config/locales/pt-BR.yml +1 0

               text_wiki_page_nullify_children: Keep child pages as root pages
               text_wiki_page_destroy_children: Delete child pages and all their descendants
               setting_password_min_length: Minimum password length
+              field_group_by: Group results by

0

config/locales/pt.yml +1 0

               text_wiki_page_nullify_children: Keep child pages as root pages
               text_wiki_page_destroy_children: Delete child pages and all their descendants
               setting_password_min_length: Minimum password length
+              field_group_by: Group results by

0

config/locales/ro.yml +1 0

               text_wiki_page_nullify_children: Keep child pages as root pages
               text_wiki_page_destroy_children: Delete child pages and all their descendants
               setting_password_min_length: Minimum password length
+              field_group_by: Group results by

0

config/locales/ru.yml +1 0

               text_wiki_page_nullify_children: Keep child pages as root pages
               text_wiki_page_destroy_children: Delete child pages and all their descendants
               setting_password_min_length: Minimum password length
+              field_group_by: Group results by

0

config/locales/sk.yml +1 0

               text_wiki_page_nullify_children: Keep child pages as root pages
               text_wiki_page_destroy_children: Delete child pages and all their descendants
               setting_password_min_length: Minimum password length
+              field_group_by: Group results by

0

config/locales/sl.yml +1 0

               text_wiki_page_nullify_children: Keep child pages as root pages
               text_wiki_page_destroy_children: Delete child pages and all their descendants
               setting_password_min_length: Minimum password length
+              field_group_by: Group results by

0

config/locales/sr.yml +1 0

               text_wiki_page_nullify_children: Keep child pages as root pages
               text_wiki_page_destroy_children: Delete child pages and all their descendants
               setting_password_min_length: Minimum password length
+              field_group_by: Group results by

0

config/locales/sv.yml +1 0

               text_wiki_page_nullify_children: Keep child pages as root pages
               text_wiki_page_destroy_children: Delete child pages and all their descendants
               setting_password_min_length: Minimum password length
+              field_group_by: Group results by

0

config/locales/th.yml +1 0

               text_wiki_page_nullify_children: Keep child pages as root pages
               text_wiki_page_destroy_children: Delete child pages and all their descendants
               setting_password_min_length: Minimum password length
+              field_group_by: Group results by

0

config/locales/tr.yml +1 0

               text_wiki_page_nullify_children: Keep child pages as root pages
               text_wiki_page_destroy_children: Delete child pages and all their descendants
               setting_password_min_length: Minimum password length
+              field_group_by: Group results by

0

config/locales/uk.yml +1 0

               text_wiki_page_nullify_children: Keep child pages as root pages
               text_wiki_page_destroy_children: Delete child pages and all their descendants
               setting_password_min_length: Minimum password length
+              field_group_by: Group results by

0

config/locales/vi.yml +1 0

               text_wiki_page_nullify_children: Keep child pages as root pages
               text_wiki_page_destroy_children: Delete child pages and all their descendants
               setting_password_min_length: Minimum password length
+              field_group_by: Group results by

0

config/locales/zh-TW.yml +1 0

               text_wiki_page_nullify_children: Keep child pages as root pages
               text_wiki_page_destroy_children: Delete child pages and all their descendants
               setting_password_min_length: Minimum password length
+              field_group_by: Group results by

0

config/locales/zh.yml +1 0

               text_wiki_page_nullify_children: Keep child pages as root pages
               text_wiki_page_destroy_children: Delete child pages and all their descendants
               setting_password_min_length: Minimum password length
+              field_group_by: Group results by

0

lib/redmine/export/pdf.rb +13 -2

                   end
                   # Returns a PDF string of a list of issues
-                  def issues_to_pdf(issues, project)
+                  def issues_to_pdf(issues, project, query)
                     pdf = IFPDF.new(current_language)
                     title = project ? "#{project} - #{l(:label_issue_plural)}" : "#{l(:label_issue_plural)}"
                     pdf.SetTitle(title)
                     # rows
                     pdf.SetFontStyle('',9)
                     pdf.SetFillColor(255, 255, 255)
-                    issues.each do |issue|
+                    group = false
+                    issues.each do |issue|
+                      if query.grouped? && issue.send(query.group_by) != group
+                        group = issue.send(query.group_by)
+                        pdf.SetFontStyle('B',10)
+                        pdf.Cell(0, row_height, "#{group.blank? ? 'None' : group.to_s}", 0, 1, 'L')
+                        pdf.Line(10, pdf.GetY, 287, pdf.GetY)
+                        pdf.SetY(pdf.GetY() + 0.5)
+                        pdf.Line(10, pdf.GetY, 287, pdf.GetY)
+                        pdf.SetY(pdf.GetY() + 1)
+                        pdf.SetFontStyle('',9)
+                      end
                       pdf.Cell(15, row_height, issue.id.to_s, 0, 0, 'L', 1)
                       pdf.Cell(30, row_height, issue.tracker.name, 0, 0, 'L', 1)
                       pdf.Cell(30, row_height, issue.status.name, 0, 0, 'L', 1)

0

public/stylesheets/application.css +10 -2

             table.list td { vertical-align: top; }
             table.list td.id { width: 2%; text-align: center;}
             table.list td.checkbox { width: 15px; padding: 0px;}
             tr.project td.name a { padding-left: 16px; white-space:nowrap; }
             tr.project.parent td.name a { background: url('../images/bullet_toggle_minus.png') no-repeat; }
             table.plugins span.description { display: block; font-size: 0.9em; }
             table.plugins span.url { display: block; font-size: 0.9em; }
+            table.list tbody tr.group td { padding: 0.8em 0 0.5em 0.3em; font-weight: bold; border-bottom: 1px solid #ccc; }
+            table.list tbody tr.group span.count { color: #aaa; font-size: 80%; }
             table.list tbody tr:hover { background-color:#ffffdd; }
+            table.list tbody tr.group:hover { background-color:inherit; }
             table td {padding:2px;}
             table p {margin:0;}
             .odd {background-color:#f6f7f8;}
             p.subtitle { font-size: 0.9em; margin: -6px 0 12px 0; font-style: italic; }
             p.footnote { font-size: 0.9em; margin-top: 0px; margin-bottom: 0px; }
+            #query_form_content { font-size: 0.9em; padding: 4px; background: #f6f6f6; border: 1px solid #e4e4e4; }
+            #query_form_content fieldset#filters { border-left: 0; border-right: 0; }
+            #query_form_content p { margin-top: 0.5em; margin-bottom: 0.5em; }
             fieldset#filters, fieldset#date-range { padding: 0.7em; margin-bottom: 8px; }
             fieldset#filters p { margin: 1.2em 0 0.8em 2px; }
             fieldset#filters table { border-collapse: collapse; }
             fieldset#filters table td { padding: 0; vertical-align: middle; }
             fieldset#filters tr.filter { height: 2em; }
             fieldset#filters td.add-filter { text-align: right; vertical-align: top; }
-            .buttons { font-size: 0.9em; }
+            .buttons { font-size: 0.9em; margin-bottom: 1.4em; }
             div#issue-changesets {float:right; width:45%; margin-left: 1em; margin-bottom: 1em; background: #fff; padding-left: 1em; font-size: 90%;}
             div#issue-changesets .changeset { padding: 4px;}

0

test/fixtures/queries.yml +20 0

@@ -73,6 +73,7 queries_005:
73	is_public: true	73	is_public: true
74	name: Open issues by priority and tracker	74	name: Open issues by priority and tracker
75	filters: \|	75	filters: \|
		76	---
76	status_id:	77	status_id:
77	:values:	78	:values:
78	- "1"	79	- "1"
@@ -86,4 +87,23 queries_005:
86	- desc	87	- desc
87	- - tracker	88	- - tracker
88	- asc	89	- asc
		90	queries_006:
		91	id: 6
		92	project_id:
		93	is_public: true
		94	name: Open issues grouped by tracker
		95	filters: \|
		96	---
		97	status_id:
		98	:values:
		99	- "1"
		100	:operator: o
		101
		102	user_id: 1
		103	column_names:
		104	group_by: tracker
		105	sort_criteria: \|
		106	---
		107	- - priority
		108	- desc
89	No newline at end of file	109

0

test/functional/issues_controller_test.rb +21 0

@@ -161,6 +161,22 class IssuesControllerTest < Test::Unit::TestCase
161	assert_not_nil assigns(:issues)	161	assert_not_nil assigns(:issues)
162	end	162	end
163		163
		164	def test_index_with_query
		165	get :index, :project_id => 1, :query_id => 5
		166	assert_response :success
		167	assert_template 'index.rhtml'
		168	assert_not_nil assigns(:issues)
		169	assert_nil assigns(:issue_count_by_group)
		170	end
		171
		172	def test_index_with_grouped_query
		173	get :index, :project_id => 1, :query_id => 6
		174	assert_response :success
		175	assert_template 'index.rhtml'
		176	assert_not_nil assigns(:issues)
		177	assert_not_nil assigns(:issue_count_by_group)
		178	end
		179
164	def test_index_csv_with_project	180	def test_index_csv_with_project
165	get :index, :format => 'csv'	181	get :index, :format => 'csv'
166	assert_response :success	182	assert_response :success
@@ -194,6 +210,11 class IssuesControllerTest < Test::Unit::TestCase
194	assert_response :success	210	assert_response :success
195	assert_not_nil assigns(:issues)	211	assert_not_nil assigns(:issues)
196	assert_equal 'application/pdf', @response.content_type	212	assert_equal 'application/pdf', @response.content_type
		213
		214	get :index, :project_id => 1, :query_id => 6, :format => 'pdf'
		215	assert_response :success
		216	assert_not_nil assigns(:issues)
		217	assert_equal 'application/pdf', @response.content_type
197	end	218	end
198		219
199	def test_index_sort	220	def test_index_sort

	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