# This file is a part of Redmine Finance (redmine_finance) plugin,
# simple accounting plugin for Redmine
#
# Copyright (C) 2011-2024 RedmineUP
# http://www.redmineup.com/
#
# redmine_finance 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 3 of the License, or
# (at your option) any later version.
#
# redmine_finance 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.
#
# You should have received a copy of the GNU General Public License
# along with redmine_finance.  If not, see <http://www.gnu.org/licenses/>.

class Account < ApplicationRecord
  include Redmine::SafeAttributes

  before_destroy :check_integrity

  belongs_to :project
  has_many :operations, :dependent => :destroy
  belongs_to :assigned_to, :class_name => 'Principal', :foreign_key => 'assigned_to_id'

  scope :visible, lambda { |*args| joins(:project).where(Project.allowed_to_condition(args.first || User.current, :view_finances)) }
  scope :named, lambda { |arg| where("LOWER(#{table_name}.name) = LOWER(?)", arg.to_s.strip) }
  scope :by_project, lambda { |project_id| where(:project_id => project_id) unless project_id.blank? }

  acts_as_customizable
  acts_as_watchable
  acts_as_attachable :view_permission => :view_finances
  up_acts_as_priceable :amount, :debit, :credit

  before_save :calculate_amount

  validates_presence_of :project, :currency
  validates_uniqueness_of :name

  safe_attributes 'name',
                  'description',
                  'amount',
                  'currency',
                  'project_id',
                  'assigned_to_id'

  def calculate_amount
    @account_amount_was = self[:amount]
    self.amount = operations.current.approved(true).income.sum(:amount) - operations.approved(true).expense.current.sum(:amount)
  end

  def amount
    @amount ||= debit - credit
  end

  def total_amount
    @total_amount ||= operations.approved(true).income.sum(:amount) - operations.approved(true).expense.sum(:amount)
  end

  def debit
    @debit ||= operations.current.approved(true).income.sum(:amount)
  end

  def credit
    @credit ||= operations.current.approved(true).expense.sum(:amount)
  end

  def visible?(usr = nil)
    (usr || User.current).allowed_to?(:view_finances, project)
  end

  def editable_by?(usr = nil)
    (usr || User.current).allowed_to?(:edit_accounts, project)
  end

  def destroyable_by?(usr = nil)
    (usr || User.current).allowed_to?(:delete_accounts, project)
  end

  # def balance(balance_date)
  #   self.operations.income.order("#{Operation.table_name}.operation_date DESC").select{|o| o.operation_date <= balance_date}.sum(&:amount) - self.operations.expense.order("#{Operation.table_name}.operation_date DESC").select{|o| o.operation_date < balance_date}.sum(&:amount)
  # end

  def to_s
    "#{name} (#{currency})"
  end

  def recipients
    notified = []
    # Author and assignee are always notified unless they have been
    # locked or don't want to be notified
    # notified << author if author
    if assigned_to
      notified += (assigned_to.is_a?(Group) ? assigned_to.users : [assigned_to])
    end
    notified = notified.select { |u| u.active? }

    notified += project.notified_users
    notified.uniq!
    # Remove users that can not view the contact
    notified.reject! { |user| !visible?(user) }
    notified.collect(&:mail)
  end

  def created_on
    created_at
  end

  def account_amount_was
    @account_amount_was
    # if amount_changed? && amount_was.present?
    #   @account_amount_was ||= amount_was
    # end
  end

  private

  def check_integrity
    raise Exception.new("Can't delete account") if Operation.where(:account_id => id).any?
  end

  def helpers
    ActionController::Base.helpers
  end
end