scottohara/loot

# Copyright (c) 2016 Scott O'Hara, oharagroup.net
# frozen_string_literal: true

# Category
class Category < ApplicationRecord
    validates :name, presence: true
    validates :direction, presence: true, inclusion: {in: %w[inflow outflow]}
    belongs_to :parent, class_name: 'Category', optional: true
    has_many :children, -> { order :name }, class_name: 'Category', foreign_key: 'parent_id', dependent: :destroy
    has_many :transaction_categories, ->(object) { rewhere(category_id: object.children.ids.unshift(object.id)) }, dependent: :restrict_with_error
    has_many :transactions, through: :transaction_categories, source: :trx do
        def for_ledger(_opts)
            joins(
                [
                    'LEFT OUTER JOIN transaction_accounts ON transaction_accounts.transaction_id = transactions.id',
                    'LEFT OUTER JOIN transaction_splits ON transaction_splits.transaction_id = transactions.id',
                    'LEFT OUTER JOIN transaction_headers ON transaction_headers.transaction_id = transactions.id OR transaction_headers.transaction_id = transaction_splits.parent_id'
                ]
            )
                .where('transactions.transaction_type != \'Subtransfer\'')
        end

        def for_closing_balance(_opts)
            joins [
                'JOIN transaction_headers ON transaction_headers.transaction_id = transactions.id',
                'JOIN transaction_accounts ON transaction_accounts.transaction_id = transactions.id'
            ]
        end

        def for_basic_closing_balance(_opts)
            joins [
                'LEFT OUTER JOIN transaction_splits ON transaction_splits.transaction_id = transactions.id',
                'JOIN transaction_headers ON transaction_headers.transaction_id = transactions.id OR transaction_headers.transaction_id = transaction_splits.parent_id'
            ]
        end
    end

    include ::Transactable
    include ::Favouritable

    class << self
        def find_or_new(category, parent = nil)
            !category.is_a?(::String) && category['id'].present? ? find(category['id']) : new(name: category, direction: parent&.direction || 'outflow', parent:)
        end
    end

    def opening_balance
        0
    end

    def account_type
        nil
    end

    def as_json(options = {fields: %i[id name direction parent_id favourite]})
        # Defer to serializer
        ::ActiveModelSerializers::SerializableResource.new(self, options).as_json
    end
end