MiraitSystems/enju_trunk

class BudgetsController < ApplicationController
  before_filter :check_client_ip_address
  load_and_authorize_resource

  def index
    if params[:user_id]
      @budgets = Budget.where(["user_id = ?", params[:user_id]]).order("user_id, term_id DESC, budget_type_id")
    else
      @budgets = Budget.find(:all, :order => "user_id, term_id DESC, budget_type_id")
    end
  end

  def new
    prepare_options
    @budget = Budget.new(:budget_class => "usual")
  end

  def create
    @budget = Budget.new(params[:budget])

    respond_to do |format|
      if @budget.save
        flash[:notice] = t('controller.successfully_created', :model => t('activerecord.models.budget'))
        format.html { redirect_to(@budget) }
        format.json { render :json => @budget, :status => :created, :location => @budget }
      else
        prepare_options
        format.html { render :action => "new" }
        format.json { render :json => @budget.errors, :status => :unprocessable_entity }
      end
    end
  end

  def edit
    prepare_options
    @budget = Budget.find(params[:id])
  end

  def update
    @budget = Budget.find(params[:id])

    respond_to do |format|
      if @budget.update_attributes(params[:budget])
        flash[:notice] = t('controller.successfully_updated', :model => t('activerecord.models.budget'))
        format.html { redirect_to(@budget) }
        format.json { head :no_content }
      else
        prepare_options
        format.html { render :action => "edit" }
        format.json { render :json => @budget.errors, :status => :unprocessable_entity }
      end
    end
  end

  def show
    @budget = Budget.find(params[:id])
    @sum = 0
    @balance = 0
    if @budget.usual? || @budget.revised?
      # 全予算　金額＋繰越額　補正含む
      amounts = Budget.sum(:amount, :conditions => {:user_id => @budget.user_id, :term_id => @budget.term_id})
      transferreds = Budget.sum(:transferred, :conditions => {:user_id => @budget.user_id, :term_id => @budget.term_id})
      @sum = amounts + transferreds
      # 補正予算　金額＋繰越額
      revised_amounts = Budget.sum(:amount, :conditions => {:user_id => @budget.user_id, :term_id => @budget.term_id, :budget_class => "revised"})
      revised_transferreds = Budget.sum(:transferred, :conditions => {:user_id => @budget.user_id, :term_id => @budget.term_id, :budget_class => "revised"})
      @sum_revised = revised_amounts + revised_transferreds
      budget_ids = Budget.where(:user_id => @budget.user_id, :term_id => @budget.term_id).inject([]){|ids, budget| ids << budget.id}
      expense = Expense.sum(:price, :conditions => ["budget_id IN (?)", budget_ids])
    else
      @sum = @budget.amount.to_i + @budget.transferred.to_i
    end
#    @sum = Budget.sum(:amount, :conditions => {:library_id => @budget.library_id, :term_id => @budget.term_id})
#    budget_ids = Budget.where(:library_id => @budget.library_id, :term_id => @budget.term_id).inject([]){|ids, budget| ids << budget.id}
#    expense = Expense.sum(:price, :conditions => ["budget_id IN (?)", budget_ids])
#    @balance = @sum - expense
  end

  def destroy
    @budget = Budget.find(params[:id])
    @budget.destroy

    respond_to do |format|
      format.html { redirect_to(budgets_url) }
      format.json { head :no_content }
    end
  end

private
  def prepare_options
#    @libraries = Library.all
    @terms = Term.all
    @budget_types = BudgetType.all
    @users = User.librarians # ライブラリアンの権限と予算執行者の権限を持つもの
    @budget_classes = t('activerecord.attributes.budget.budget_classes')
  end
end