2025 10 10 Leoben Supervisors

defmodule SupervisorAsssigner do
  require Logger

  alias Emie.{
    Repo,
    People.Person,
    People.Team,
  } 

  import Ecto.Query


  def teams_with_prefix(prefix \\ "Team - ") do
    wildcard = "#{prefix}%"

    from( t in Team, where: ilike(t.name, ^wildcard), order_by: [asc: t.name])
    |> Repo.all()
  end

  def teams_with_supervisor_and_members(teams) do
     Enum.map( teams, fn team -> 
       teamlead_id =
         case team.teamlead_ids do
           [tlid] -> tlid
           [tlid|_] -> Logger.warn("Team #{team.name} has more than one TL. Using first #{tlid}")
                      tlid
           err -> Logger.error("Team #{team.name} has no TL. Ignoring team. #{inspect err}")
                  nil
         end
        %{ team: team, teamlead_id: teamlead_id }
     end)
     |> Enum.reject( fn r -> is_nil( r.teamlead_id) end)
     |> Enum.map( fn %{team: team, teamlead_id: teamlead_id} ->
        team_with_members = team |> Repo.preload(:members) 
        %{ team: team, teamlead_id: teamlead_id, members: team_with_members.members }
     end)
     
  end

  def set_supervisor_ids(rec) do
    Enum.map( rec, fn %{team: team, teamlead_id: teamlead_id, members: members } ->
      updates = 
        Enum.map( members, fn person ->
          p = Repo.get_by(Person, id: person.id)
          Ecto.Changeset.change(p, %{supervisor_id: teamlead_id})
          |> Map.put(:action, :update)
          |> Repo.update()
        end)
      %{team: team, teamlead_id: teamlead_id, members: members, updated: updates}
    end)
  end


end