Open source, privacy-first web analytics. Lightweight, cookie-free Google Analytics alternative. Self-hosted or cloud.
TypeScript analyticsanalytics-dashboardclickhouseelixirgoogle-analyticsmarketingopen-source-analyticsphoenixplausible-analyticspostgresqlprivacyprivacy-friendlyself-hostedsimple-analyticsstatisticstailwindcssweb-analyticswebsite-analyticswebsite-statswebsite-tracking
defmodule Plausible.CustomerSupport.Resource.Site do
@moduledoc false
use Plausible.CustomerSupport.Resource, type: "site"
alias Plausible.Repo
@impl true
def path(id) do
~p"/cs/sites/site/#{id}"
end
@impl true
def search(input, opts \\ [])
def search("", opts) do
limit = Keyword.fetch!(opts, :limit)
q =
from s in Plausible.Site.regular(),
inner_join: t in assoc(s, :team),
inner_join: o in assoc(t, :owners),
order_by: [
desc: :id
],
limit: ^limit,
preload: [team: {t, owners: o}]
Repo.all(q)
end
def search(input, opts) do
limit = Keyword.fetch!(opts, :limit)
q =
from s in Plausible.Site.regular(),
inner_join: t in assoc(s, :team),
inner_join: o in assoc(t, :owners),
left_join: tsc in assoc(s, :tracker_script_configuration),
where:
ilike(s.domain, ^"%#{input}%") or ilike(t.name, ^"%#{input}%") or
ilike(o.name, ^"%#{input}%") or ilike(o.email, ^"%#{input}%") or
ilike(s.domain_changed_from, ^"%#{input}%") or tsc.id == ^input,
order_by: [
desc: fragment("?.domain = ?", s, ^input),
desc: fragment("?.domain_changed_from = ?", s, ^input),
desc: fragment("?.name = ?", t, ^input),
desc: fragment("?.name = ?", o, ^input),
desc: fragment("?.email = ?", o, ^input),
asc: s.domain
],
limit: ^limit,
preload: [team: {t, owners: o}]
Repo.all(q)
end
@impl true
def get(id) do
Plausible.Site
|> Repo.get!(id)
|> Repo.preload(:team)
end
end