defmodule HsmElixir.Attendance.Record do
  use Ecto.Schema
  import Ecto.Changeset

  @schema_prefix "hsm_public"
  @primary_key {:id, Ecto.UUID, autogenerate: true}

  schema "attendance_record" do
    field :in, :utc_datetime
    field :notes, :string
    field :out, :utc_datetime
    field :type, :string
    field :duration, EctoInterval, virtual: true
    belongs_to :user, HsmElixir.Accounts.User, type: Ecto.UUID
  end

  @doc false
  def changeset(record, attrs) do
    record
    |> cast(attrs, [:in, :out, :notes, :type])
    |> validate_required([:in, :type])
  end
end

  def record_query() do
    from r in Record,
      as: :attendance_record,
      select_merge: %{
        in: r.in,
        out: r.out,
        type: r.type,
        user_id: r.user_id,
        duration: fragment("hsm_public.attendance_record_duration(?)", r)
      }
  end

  def list_records do
    Repo.all(record_query())
  end

iex(34)> to_string(%Interval{months: 1, days: 2, secs: 3665})
"Every 1 months 2 days 3665 seconds"

iex(37)> format_interval(%Interval{months: 1, days: 2, secs: 3665})
"1 month 2 days 1 hour 1 minute 5 seconds"