You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
202 lines
5.0 KiB
Elixir
202 lines
5.0 KiB
Elixir
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 cannot be registered. Perhaps one of your colleagues registered it? Or did you recently delete it from your account? The deletion may take up to 48 hours before you can add the same site again. If that's not the case, please contact support@plausible.io"
|
|
]
|
|
else
|
|
[]
|
|
end
|
|
end
|
|
end
|