Chris@1296: # Redmine - project management software Chris@1296: # Copyright (C) 2006-2012 Jean-Philippe Lang Chris@1296: # Chris@1296: # This program is free software; you can redistribute it and/or Chris@1296: # modify it under the terms of the GNU General Public License Chris@1296: # as published by the Free Software Foundation; either version 2 Chris@1296: # of the License, or (at your option) any later version. Chris@1296: # Chris@1296: # This program is distributed in the hope that it will be useful, Chris@1296: # but WITHOUT ANY WARRANTY; without even the implied warranty of Chris@1296: # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the Chris@1296: # GNU General Public License for more details. Chris@1296: # Chris@1296: # You should have received a copy of the GNU General Public License Chris@1296: # along with this program; if not, write to the Free Software Chris@1296: # Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA. Chris@1296: Chris@1296: class CalendarsController < ApplicationController Chris@1296: menu_item :calendar Chris@1296: before_filter :find_optional_project Chris@1296: Chris@1296: rescue_from Query::StatementInvalid, :with => :query_statement_invalid Chris@1296: Chris@1296: helper :issues Chris@1296: helper :projects Chris@1296: helper :queries Chris@1296: include QueriesHelper Chris@1296: helper :sort Chris@1296: include SortHelper Chris@1296: Chris@1296: def show Chris@1296: if params[:year] and params[:year].to_i > 1900 Chris@1296: @year = params[:year].to_i Chris@1296: if params[:month] and params[:month].to_i > 0 and params[:month].to_i < 13 Chris@1296: @month = params[:month].to_i Chris@1296: end Chris@1296: end Chris@1296: @year ||= Date.today.year Chris@1296: @month ||= Date.today.month Chris@1296: Chris@1296: @calendar = Redmine::Helpers::Calendar.new(Date.civil(@year, @month, 1), current_language, :month) Chris@1296: retrieve_query Chris@1296: @query.group_by = nil Chris@1296: if @query.valid? Chris@1296: events = [] Chris@1296: events += @query.issues(:include => [:tracker, :assigned_to, :priority], Chris@1296: :conditions => ["((start_date BETWEEN ? AND ?) OR (due_date BETWEEN ? AND ?))", @calendar.startdt, @calendar.enddt, @calendar.startdt, @calendar.enddt] Chris@1296: ) Chris@1296: events += @query.versions(:conditions => ["effective_date BETWEEN ? AND ?", @calendar.startdt, @calendar.enddt]) Chris@1296: Chris@1296: @calendar.events = events Chris@1296: end Chris@1296: Chris@1296: render :action => 'show', :layout => false if request.xhr? Chris@1296: end Chris@1296: end