defmodule Plausible.Sites do use Plausible.Repo alias Plausible.ClickhouseRepo alias Plausible.Site alias Plausible.Site.SharedLink import Ecto.Query def get_by_domain(domain) do Repo.get_by(Site, domain: domain) end def create(user, params) do site_changeset = Site.changeset(%Site{}, params) Ecto.Multi.new() |> Ecto.Multi.run(:limit, fn _, _ -> limit = Plausible.Billing.sites_limit(user) count = owned_sites_count(user) if count >= limit do {:error, limit} else {:ok, count} end end) |> Ecto.Multi.insert(:site, site_changeset) |> Ecto.Multi.run(:existing_events, fn _, _ -> site_changeset |> Ecto.Changeset.validate_change(:domain, fn :domain, domain -> check_for_existing_events(domain, params) end) |> Ecto.Changeset.apply_action(:insert) end) |> Ecto.Multi.run(:site_membership, fn repo, %{site: site} -> membership_changeset = Site.Membership.changeset(%Site.Membership{}, %{ site_id: site.id, user_id: user.id }) repo.insert(membership_changeset) end) |> maybe_start_trial(user) |> Repo.transaction() end defp maybe_start_trial(multi, user) do case user.trial_expiry_date do nil -> changeset = Plausible.Auth.User.start_trial(user) Ecto.Multi.update(multi, :user, changeset) _ -> multi end end @spec stats_start_date(Plausible.Site.t()) :: Date.t() | nil @doc """ Returns the date of the first event of the given site, or `nil` if the site does not have stats yet. If this is the first time the function is called for the site, it queries Clickhouse and saves the date in the sites table. """ def stats_start_date(site) def stats_start_date(%Site{stats_start_date: %Date{} = date}) do date end def stats_start_date(%Site{} = site) do if start_date = Plausible.Stats.Clickhouse.pageview_start_date_local(site) do updated_site = site |> Site.set_stats_start_date(start_date) |> Repo.update!() updated_site.stats_start_date end end def has_stats?(site) do !!stats_start_date(site) end def has_events?(domain) do q = from e in "events", where: e.domain == ^domain, select: true, limit: 1 ClickhouseRepo.one(q) == true end def create_shared_link(site, name, password \\ nil) do changes = SharedLink.changeset( %SharedLink{ site_id: site.id, slug: Nanoid.generate() }, %{name: name, password: password} ) Repo.insert(changes) end def shared_link_url(site, link) do base = PlausibleWeb.Endpoint.url() domain = "/share/#{URI.encode_www_form(site.domain)}" base <> domain <> "?auth=" <> link.slug end def get_for_user!(user_id, domain, roles \\ [:owner, :admin, :viewer]), do: Repo.one!(get_for_user_q(user_id, domain, roles)) def get_for_user(user_id, domain, roles \\ [:owner, :admin, :viewer]), do: Repo.one(get_for_user_q(user_id, domain, roles)) defp get_for_user_q(user_id, domain, roles) do from(s in Site, join: sm in Site.Membership, on: sm.site_id == s.id, where: sm.user_id == ^user_id, where: sm.role in ^roles, where: s.domain == ^domain, select: s ) end def has_goals?(site) do Repo.exists?( from g in Plausible.Goal, where: g.domain == ^site.domain ) end def is_member?(user_id, site) do role(user_id, site) !== nil end def has_admin_access?(user_id, site) do role(user_id, site) in [:admin, :owner] end def locked?(%Site{locked: locked}) do locked end def role(user_id, site) do Repo.one( from sm in Site.Membership, where: sm.user_id == ^user_id and sm.site_id == ^site.id, select: sm.role ) end def owned_sites_count(user) do user |> owned_sites_query() |> Repo.aggregate(:count) end def owned_sites_domains(user) do user |> owned_sites_query() |> select([site], site.domain) |> Repo.all() end defp owned_sites_query(user) do from(s in Site, join: sm in Site.Membership, on: sm.site_id == s.id, where: sm.role == :owner, where: sm.user_id == ^user.id ) end def owner_for(site) do Repo.one( from u in Plausible.Auth.User, join: sm in Site.Membership, on: sm.user_id == u.id, where: sm.site_id == ^site.id, where: sm.role == :owner ) end defp check_for_existing_events(domain, params) do if has_events?(domain) do Sentry.capture_message("Refused to create a site with existing events", extra: %{params: params} ) [ domain: "This domain has already been taken. Perhaps one of your team members registered it? If that's not the case, please contact support@plausible.io" ] else [] end end end