module Ecom
  module Core
    class AttendanceSheet < ApplicationRecord
      OPEN = 'Open'.freeze
      SUBMITTED = 'Submitted'.freeze
      APPROVED = 'Approved'.freeze

      validates :date, presence: true, uniqueness: true
      validates :status, inclusion: [OPEN, SUBMITTED, APPROVED]

      belongs_to :project

      has_many :attendance_sheet_entries
      has_many :crew_times, through: :attendance_sheet_entries

      scope :open, ->(id) { where(status: OPEN, project_id: id) }
      scope :submitted, ->(id) { where(status: SUBMITTED, project_id: id) }
      scope :current, ->(id) { where(date: Date.today, project_id: id) }
      scope :current_open, ->(id) { where(date: Date.today, project_id: id, status: OPEN) }

      def self.open_for_date(date, project_id)
        AttendanceSheet.find_by(status: OPEN, date: date, project_id: project_id)
      end

      def self.open_exists?(project_id)
        AttendanceSheet.open(project_id).exists?
      end

      def self.exists_for_today?(project_id)
        AttendanceSheet.current(project_id).exists?
      end

      def self.open_exists_for_today?(project_id)
        AttendanceSheet.current_open(project_id).exists?
      end

      # Attendance sheet should be created using the
      # method below only. This is because we need to
      # check if there is an open attendance already,
      # and also that we have only one attendace sheet
      # per day.
      def self.create_current(project_id)
        raise 'Attendance sheet already created for the day.' if AttendanceSheet.exists_for_today?(project_id)

        if AttendanceSheet.open_exists?(project_id)
          raise 'There is an open attendance sheet which needs to be submitted before creating a new one.'
        end

        AttendanceSheet.create(date: Date.today, opened_at: Time.now, status: OPEN, project_id: project_id)
      end

      def self.submit_current(project_id)
        sheet = AttendanceSheet.find_by(date: Date.today, status: OPEN, project_id: project_id)

        raise 'There is no open attendance sheet to submit.' if sheet.nil?

        sheet.closed_at = Time.now
        sheet.status = SUBMITTED
        sheet.save
        sheet
      end

      # This method should be used by privileged users
      # to submit the attendance sheet after the date has
      # passed. Normally, timekeepers need to open and close
      # an attendance sheet of a date on the specific date.
      def self.submit(date, project_id)
        sheet = AttendanceSheet.open_for_date(date, project_id)
        raise 'There is no open attendance sheet to submit for the selected day.' unless sheet

        sheet.closed_at = Time.now
        sheet.status = SUBMITTED
        sheet.save
        sheet
      end
    end
  end
end