queries_controller.rb
107 lines
| 3.5 KiB
| text/x-ruby
|
RubyLexer
Jean-Philippe Lang
|
r6066 | # Redmine - project management software | ||
|
Jean-Philippe Lang
|
r9453 | # Copyright (C) 2006-2012 Jean-Philippe Lang | ||
|
Jean-Philippe Lang
|
r92 | # | ||
| # 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. | ||||
Toshi MARUYAMA
|
r6772 | # | ||
|
Jean-Philippe Lang
|
r92 | # 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. | ||||
|
Toshi MARUYAMA
|
r6772 | # | ||
|
Jean-Philippe Lang
|
r92 | # 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 QueriesController < ApplicationController | ||||
|
Jean-Philippe Lang
|
r1062 | menu_item :issues | ||
Etienne Massip
|
r7529 | before_filter :find_query, :except => [:new, :create, :index] | ||
| before_filter :find_optional_project, :only => [:new, :create] | ||||
|
Toshi MARUYAMA
|
r6772 | |||
|
Jean-Philippe Lang
|
r6077 | accept_api_auth :index | ||
|
Toshi MARUYAMA
|
r6772 | |||
|
Etienne Massip
|
r7529 | include QueriesHelper | ||
|
Jean-Philippe Lang
|
r6066 | def index | ||
| case params[:format] | ||||
| when 'xml', 'json' | ||||
| @offset, @limit = api_offset_and_limit | ||||
| else | ||||
| @limit = per_page_option | ||||
| end | ||||
|
Toshi MARUYAMA
|
r6772 | |||
|
Jean-Philippe Lang
|
r6066 | @query_count = Query.visible.count | ||
| @query_pages = Paginator.new self, @query_count, @limit, params['page'] | ||||
| @queries = Query.visible.all(:limit => @limit, :offset => @offset, :order => "#{Query.table_name}.name") | ||||
|
Toshi MARUYAMA
|
r6772 | |||
|
Jean-Philippe Lang
|
r6066 | respond_to do |format| | ||
| format.html { render :nothing => true } | ||||
| format.api | ||||
| end | ||||
| end | ||||
|
Toshi MARUYAMA
|
r6772 | |||
|
Jean-Philippe Lang
|
r563 | def new | ||
|
Etienne Massip
|
r7529 | @query = Query.new | ||
|
Jean-Philippe Lang
|
r906 | @query.user = User.current | ||
|
Etienne Massip
|
r7529 | @query.project = @project | ||
|
Jean-Philippe Lang
|
r2627 | @query.is_public = false unless User.current.allowed_to?(:manage_public_queries, @project) || User.current.admin? | ||
|
Etienne Massip
|
r7529 | build_query_from_params | ||
| end | ||||
|
Toshi MARUYAMA
|
r6772 | |||
|
Etienne Massip
|
r7529 | def create | ||
| @query = Query.new(params[:query]) | ||||
| @query.user = User.current | ||||
| @query.project = params[:query_is_for_all] ? nil : @project | ||||
| @query.is_public = false unless User.current.allowed_to?(:manage_public_queries, @project) || User.current.admin? | ||||
| build_query_from_params | ||||
|
Jean-Philippe Lang
|
r5184 | @query.column_names = nil if params[:default_columns] | ||
|
Toshi MARUYAMA
|
r6772 | |||
|
Etienne Massip
|
r7529 | if @query.save | ||
|
Jean-Philippe Lang
|
r563 | flash[:notice] = l(:notice_successful_create) | ||
|
Jean-Philippe Lang
|
r874 | redirect_to :controller => 'issues', :action => 'index', :project_id => @project, :query_id => @query | ||
|
Etienne Massip
|
r7529 | else | ||
| render :action => 'new', :layout => !request.xhr? | ||||
|
Jean-Philippe Lang
|
r563 | end | ||
| end | ||||
|
Toshi MARUYAMA
|
r6772 | |||
|
Jean-Philippe Lang
|
r92 | def edit | ||
|
Etienne Massip
|
r7529 | end | ||
|
Toshi MARUYAMA
|
r6772 | |||
|
Etienne Massip
|
r7529 | def update | ||
| @query.attributes = params[:query] | ||||
| @query.project = nil if params[:query_is_for_all] | ||||
| @query.is_public = false unless User.current.allowed_to?(:manage_public_queries, @project) || User.current.admin? | ||||
| build_query_from_params | ||||
| @query.column_names = nil if params[:default_columns] | ||||
| if @query.save | ||||
| flash[:notice] = l(:notice_successful_update) | ||||
| redirect_to :controller => 'issues', :action => 'index', :project_id => @project, :query_id => @query | ||||
| else | ||||
| render :action => 'edit' | ||||
|
Jean-Philippe Lang
|
r92 | end | ||
| end | ||||
| def destroy | ||||
|
Etienne Massip
|
r7529 | @query.destroy | ||
|
Jean-Philippe Lang
|
r1296 | redirect_to :controller => 'issues', :action => 'index', :project_id => @project, :set_filter => 1 | ||
|
Jean-Philippe Lang
|
r92 | end | ||
|
Toshi MARUYAMA
|
r6772 | |||
|
Jean-Philippe Lang
|
r92 | private | ||
|
Jean-Philippe Lang
|
r1296 | def find_query | ||
| @query = Query.find(params[:id]) | ||||
| @project = @query.project | ||||
| render_403 unless @query.editable_by?(User.current) | ||||
| rescue ActiveRecord::RecordNotFound | ||||
| render_404 | ||||
| end | ||||
|
Toshi MARUYAMA
|
r6772 | |||
|
Jean-Philippe Lang
|
r1297 | def find_optional_project | ||
| @project = Project.find(params[:project_id]) if params[:project_id] | ||||
|
Jean-Philippe Lang
|
r3497 | render_403 unless User.current.allowed_to?(:save_queries, @project, :global => true) | ||
|
Jean-Philippe Lang
|
r130 | rescue ActiveRecord::RecordNotFound | ||
| render_404 | ||||
|
Jean-Philippe Lang
|
r92 | end | ||
| end | ||||