class Reports::SchoolMovesExporter

# File app/lib/reports/school_moves_exporter.rb, line 27
def initialize(team:, start_date:, end_date:)
  @team = team
  @start_date = start_date
  @end_date = end_date
end

# File app/lib/reports/school_moves_exporter.rb, line 35
def csv_data
  CSV.generate(headers: HEADERS, write_headers: true) do |csv|
    school_move_log_entries
      .includes(:patient, :school)
      .order(:created_at)
      .find_each { |log_entry| csv << row(log_entry) }
  end
end

# File app/lib/reports/school_moves_exporter.rb, line 92
def row(log_entry)
  patient = log_entry.patient
  location = log_entry.school

  systm_one_school_code =
    if location&.gias_school?
      location.systm_one_code
    else
      patient&.school&.systm_one_code
    end

  [
    patient.nhs_number,
    patient.family_name,
    patient.given_name,
    patient.gender_code.humanize,
    patient.date_of_birth.iso8601,
    patient.address_line_1,
    patient.address_line_2,
    nil,
    patient.address_town,
    patient.address_postcode,
    nil,
    nil,
    nil,
    systm_one_school_code || school_urn(log_entry),
    location&.name,
    log_entry.created_at.iso8601,
    nil,
    nil
  ]
end

# File app/lib/reports/school_moves_exporter.rb, line 33
  def row_count = school_move_log_entries.count

  def csv_data
    CSV.generate(headers: HEADERS, write_headers: true) do |csv|
      school_move_log_entries
        .includes(:patient, :school)
        .order(:created_at)
        .find_each { |log_entry| csv << row(log_entry) }
    end
  end

  private

  attr_reader :team, :start_date, :end_date

  def school_move_log_entries
    @school_move_log_entries ||=
      begin
        historical_patients =
          Patient
            .where.not(id: team.patients.select(:id))
            .where(
              SchoolMoveLogEntry
                .where("patient_id = patients.id")
                .where(school: team.gias_schools)
                .arel
                .exists
            )

        scope =
          SchoolMoveLogEntry
            .where(school: team.gias_schools)
            .or(SchoolMoveLogEntry.where(patient: team.patients, school: nil))
            .or(
              SchoolMoveLogEntry
                .where.not(patient: team.patients)
                .where(patient: historical_patients)
            )

        if start_date.present?
          scope =
            scope.where(
              "school_move_log_entries.created_at >= ?",
              start_date.beginning_of_day
            )
        end

        if end_date.present?
          scope =
            scope.where(
              "school_move_log_entries.created_at <= ?",
              end_date.end_of_day
            )
        end

        scope
      end
  end

  def row(log_entry)
    patient = log_entry.patient
    location = log_entry.school

    systm_one_school_code =
      if location&.gias_school?
        location.systm_one_code
      else
        patient&.school&.systm_one_code
      end

    [
      patient.nhs_number,
      patient.family_name,
      patient.given_name,
      patient.gender_code.humanize,
      patient.date_of_birth.iso8601,
      patient.address_line_1,
      patient.address_line_2,
      nil,
      patient.address_town,
      patient.address_postcode,
      nil,
      nil,
      nil,
      systm_one_school_code || school_urn(log_entry),
      location&.name,
      log_entry.created_at.iso8601,
      nil,
      nil
    ]
  end

  def school_urn(log_entry)
    if log_entry.school
      log_entry.school.urn
    elsif log_entry.home_educated?
      "999999"
    else
      "888888"
    end
  end
end

# File app/lib/reports/school_moves_exporter.rb, line 48
def school_move_log_entries
  @school_move_log_entries ||=
    begin
      historical_patients =
        Patient
          .where.not(id: team.patients.select(:id))
          .where(
            SchoolMoveLogEntry
              .where("patient_id = patients.id")
              .where(school: team.gias_schools)
              .arel
              .exists
          )

      scope =
        SchoolMoveLogEntry
          .where(school: team.gias_schools)
          .or(SchoolMoveLogEntry.where(patient: team.patients, school: nil))
          .or(
            SchoolMoveLogEntry
              .where.not(patient: team.patients)
              .where(patient: historical_patients)
          )

      if start_date.present?
        scope =
          scope.where(
            "school_move_log_entries.created_at >= ?",
            start_date.beginning_of_day
          )
      end

      if end_date.present?
        scope =
          scope.where(
            "school_move_log_entries.created_at <= ?",
            end_date.end_of_day
          )
      end

      scope
    end
end

# File app/lib/reports/school_moves_exporter.rb, line 125
def school_urn(log_entry)
  if log_entry.school
    log_entry.school.urn
  elsif log_entry.home_educated?
    "999999"
  else
    "888888"
  end
end