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.
analytics/lib/plausible/sites.ex

202 lines
4.9 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 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