1 # Pleroma: A lightweight social networking server
2 # Copyright © 2017-2021 Pleroma Authors <https://pleroma.social/>
3 # SPDX-License-Identifier: AGPL-3.0-only
5 defmodule Pleroma.Conversation.Participation do
7 alias Pleroma.Conversation
8 alias Pleroma.Conversation.Participation.RecipientShip
11 alias Pleroma.Web.ActivityPub.ActivityPub
15 schema "conversation_participations" do
16 belongs_to(:user, User, type: FlakeId.Ecto.CompatType)
17 belongs_to(:conversation, Conversation)
18 field(:read, :boolean, default: false)
19 field(:last_activity_id, FlakeId.Ecto.CompatType, virtual: true)
21 has_many(:recipient_ships, RecipientShip)
22 has_many(:recipients, through: [:recipient_ships, :user])
27 def creation_cng(struct, params) do
29 |> cast(params, [:user_id, :conversation_id, :read])
30 |> validate_required([:user_id, :conversation_id])
33 def create_for_user_and_conversation(user, conversation, opts \\ []) do
35 invisible_conversation = !!opts[:invisible_conversation]
38 if(invisible_conversation, do: [], else: [read: read])
39 |> Keyword.put(:updated_at, NaiveDateTime.utc_now())
44 conversation_id: conversation.id,
45 read: invisible_conversation || read
48 on_conflict: [set: update_on_conflict],
50 conflict_target: [:user_id, :conversation_id]
54 def read_cng(struct, params) do
56 |> cast(params, [:read])
57 |> validate_required([:read])
60 def mark_as_read(%User{} = user, %Conversation{} = conversation) do
61 with %__MODULE__{} = participation <- for_user_and_conversation(user, conversation) do
62 mark_as_read(participation)
66 def mark_as_read(%__MODULE__{} = participation) do
72 def mark_all_as_read(%User{local: true} = user, %User{} = target_user) do
73 target_conversation_ids =
75 |> where([p], p.user_id == ^target_user.id)
76 |> select([p], p.conversation_id)
80 |> where([p], p.user_id == ^user.id)
81 |> where([p], p.conversation_id in ^target_conversation_ids)
82 |> update([p], set: [read: true])
83 |> Repo.update_all([])
88 def mark_all_as_read(%User{} = user, %User{}), do: {:ok, user, []}
90 def mark_all_as_read(%User{} = user) do
93 |> where([p], p.user_id == ^user.id)
94 |> where([p], not p.read)
95 |> update([p], set: [read: true])
97 |> Repo.update_all([])
99 {:ok, user, participations}
102 def mark_as_unread(participation) do
104 |> read_cng(%{read: false})
108 def for_user(user, params \\ %{}) do
109 from(p in __MODULE__,
110 where: p.user_id == ^user.id,
111 order_by: [desc: p.updated_at],
112 preload: [conversation: [:users]]
114 |> restrict_recipients(user, params)
115 |> Pleroma.Pagination.fetch_paginated(params)
118 def restrict_recipients(query, user, %{recipients: user_ids}) do
124 conversation_subquery =
126 |> group_by([p], p.conversation_id)
129 count(p.user_id) == ^length(user_binary_ids) and
130 fragment("array_agg(?) @> ?", p.user_id, ^user_binary_ids)
132 |> select([p], %{id: p.conversation_id})
135 |> join(:inner, [p], c in subquery(conversation_subquery), on: p.conversation_id == c.id)
138 def restrict_recipients(query, _, _), do: query
140 def for_user_and_conversation(user, conversation) do
141 from(p in __MODULE__,
142 where: p.user_id == ^user.id,
143 where: p.conversation_id == ^conversation.id
148 def for_user_with_last_activity_id(user, params \\ %{}) do
149 for_user(user, params)
150 |> Enum.map(fn participation ->
152 ActivityPub.fetch_latest_direct_activity_id_for_context(
153 participation.conversation.ap_id,
162 | last_activity_id: activity_id
165 |> Enum.reject(&is_nil(&1.last_activity_id))
169 def get(nil, _), do: nil
171 def get(id, params) do
173 if preload = params[:preload] do
174 from(p in __MODULE__,
184 def set_recipients(participation, user_ids) do
186 [participation.user_id | user_ids]
189 Repo.transaction(fn ->
191 from(r in RecipientShip,
192 where: r.participation_id == ^participation.id
195 Repo.delete_all(query)
199 where: u.id in ^user_ids
203 RecipientShip.create(users, participation)
207 {:ok, Repo.preload(participation, :recipients, force: true)}
210 @spec unread_count(User.t()) :: integer()
211 def unread_count(%User{id: user_id}) do
212 from(q in __MODULE__, where: q.user_id == ^user_id and q.read == false)
213 |> Repo.aggregate(:count, :id)
216 def unread_conversation_count_for_user(user) do
217 from(p in __MODULE__,
218 where: p.user_id == ^user.id,
220 select: %{count: count(p.id)}
224 def delete(%__MODULE__{} = participation) do
225 Repo.delete(participation)