moreminimore-chat/app/models/customer_daily_metric.rb

# == Schema Information
#
# Table name: customer_daily_metrics
#
#  id                           :bigint           not null, primary key
#  account_id                   :bigint           not null
#  contact_id                   :bigint           not null
#  date                         :date             not null
#  timezone                     :string
#  message_count                :integer          default(0), not null
#  conversation_count           :integer          default(0), not null
#  resolved_count               :integer          default(0), not null
#  unresolved_count             :integer          default(0), not null
#  avg_session_duration_seconds :float            default(0.0), not null
#  top_tags                     :jsonb            default([]), not null
#  deal_outcomes                :jsonb            default({}), not null
#  agent_ids                    :jsonb            default([]), not null
#  created_at                   :datetime         not null
#  updated_at                   :datetime         not null
#
class CustomerDailyMetric < ApplicationRecord
  belongs_to :account
  belongs_to :contact

  validates :account_id, presence: true
  validates :contact_id, presence: true
  validates :date, presence: true
  validates :date, uniqueness: { scope: %i[account_id contact_id] }

  def top_tags
    self[:top_tags] || []
  end

  def deal_outcomes
    self[:deal_outcomes] || {}
  end

  def agent_ids
    self[:agent_ids] || []
  end
end