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.
155 lines
3.7 KiB
Elixir
155 lines
3.7 KiB
Elixir
defmodule Plausible.Sites do
|
|
use Plausible.Repo
|
|
alias Plausible.Site.SharedLink
|
|
|
|
def create(user, params) do
|
|
count = Enum.count(owned_by(user))
|
|
limit = Plausible.Billing.sites_limit(user)
|
|
|
|
if count >= limit do
|
|
{:error, :limit, limit}
|
|
else
|
|
site_changeset = Plausible.Site.changeset(%Plausible.Site{}, params)
|
|
|
|
Ecto.Multi.new()
|
|
|> Ecto.Multi.insert(:site, site_changeset)
|
|
|> Ecto.Multi.run(:site_membership, fn repo, %{site: site} ->
|
|
membership_changeset =
|
|
Plausible.Site.Membership.changeset(%Plausible.Site.Membership{}, %{
|
|
site_id: site.id,
|
|
user_id: user.id
|
|
})
|
|
|
|
repo.insert(membership_changeset)
|
|
end)
|
|
|> maybe_start_trial(user)
|
|
|> Repo.transaction()
|
|
end
|
|
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
|
|
|
|
def stats_start_date(site) do
|
|
if site.stats_start_date do
|
|
site.stats_start_date
|
|
else
|
|
start_date = Plausible.Stats.Clickhouse.pageview_start_date_local(site)
|
|
|
|
if start_date do
|
|
Plausible.Site.set_stats_start_date(site, start_date)
|
|
|> Repo.update()
|
|
|
|
start_date
|
|
end
|
|
end
|
|
end
|
|
|
|
def has_stats?(site) do
|
|
!!stats_start_date(site)
|
|
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 Plausible.Site,
|
|
join: sm in Plausible.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 role(user_id, site) do
|
|
Repo.one(
|
|
from sm in Plausible.Site.Membership,
|
|
where: sm.user_id == ^user_id and sm.site_id == ^site.id,
|
|
select: sm.role
|
|
)
|
|
end
|
|
|
|
def owned_by(user) do
|
|
Repo.all(
|
|
from s in Plausible.Site,
|
|
join: sm in Plausible.Site.Membership,
|
|
on: sm.site_id == s.id,
|
|
where: sm.role == :owner,
|
|
where: sm.user_id == ^user.id
|
|
)
|
|
end
|
|
|
|
def count_owned_by(user) do
|
|
Repo.one(
|
|
from s in Plausible.Site,
|
|
join: sm in Plausible.Site.Membership,
|
|
on: sm.site_id == s.id,
|
|
where: sm.role == :owner,
|
|
where: sm.user_id == ^user.id,
|
|
select: count(sm)
|
|
)
|
|
end
|
|
|
|
def owner_for(site) do
|
|
Repo.one(
|
|
from u in Plausible.Auth.User,
|
|
join: sm in Plausible.Site.Membership,
|
|
on: sm.user_id == u.id,
|
|
where: sm.site_id == ^site.id,
|
|
where: sm.role == :owner
|
|
)
|
|
end
|
|
|
|
def delete!(site) do
|
|
Repo.delete!(site)
|
|
Plausible.ClickhouseRepo.clear_stats_for(site.domain)
|
|
end
|
|
end
|