Use Plesk CLI subscription info to populate status; domains inherit status; UI badges

Reviewed-on: http://gitea.lan:3000/robbond/pleskSaas/pulls/4

components/dashboard/dashboard-controls.tsx

@@ -52,11 +52,17 @@ type Props = {
 function getDomainStatusBadge(status: string | null) {
   const normalized = (status ?? "unknown").toLowerCase();
 
-  if (normalized === "active") return "bg-emerald-100 text-emerald-700";
+  if (normalized.includes("suspend") || normalized.includes("disabled")) {
+    return "bg-rose-100 text-rose-700";
+  }
 
-  if (normalized === "suspended") return "bg-rose-100 text-rose-700";
+  if (normalized.includes("active") || normalized.includes("enabled")) {
+    return "bg-emerald-100 text-emerald-700";
+  }
 
-  if (normalized === "inactive") return "bg-amber-100 text-amber-700";
+  if (normalized.includes("ok")) {
+    return "bg-emerald-100 text-emerald-700";
+  }
 
   return "bg-slate-100 text-slate-600";
 }

lib/plesk/client.ts

@@ -9,6 +9,7 @@ export type PleskConnection = {
 };
 
 export type PleskSubscription = {
+  plesk_subscription_id?: string;
   id?: string | number;
   guid?: string;
   subscription_id?: string | number;
@@ -137,51 +138,60 @@ export async function testPleskConnection(connection: PleskConnection) {
 }
 
 export async function listPleskSubscriptions(connection: PleskConnection) {
-  try {
+  const listResult = await pleskCliCall(connection, "subscription", ["--list"]);
-    const all: PleskSubscription[] = [];
 
-    for (let page = 1; page <= 20; page += 1) {
+  const subscriptionNames = (listResult.stdout ?? "")
-      const payload = await pleskRequest<PleskSubscription[]>(
-        connection,
-        `/api/v2/subscriptions?page=${page}&per_page=100`,
-      );
-      const rows = Array.isArray(payload) ? payload : [];
-      all.push(...rows);
-      if (rows.length < 100) break;
-    }
-
-    return all;
-  } catch {
-    const cli = await pleskRequest<PleskCliResult>(
-      connection,
-      "/api/v2/cli/subscription/call",
-      {
-        method: "POST",
-        body: JSON.stringify({ params: ["--list"] }),
-      },
-    );
-
-    const stdout = cli?.stdout ?? "";
-    if (!stdout.trim()) {
-      return [];
-    }
-
-    return stdout
     .split(/\r?\n/)
     .map((line) => line.trim())
-      .filter(Boolean)
+    .filter(Boolean);
-      .map((line) => {
+
-        const columns = line.split(/\s+/);
+  const subscriptions: PleskSubscription[] = [];
-        const externalId = columns[0] ?? line;
+
-        return {
+  for (const subscriptionName of subscriptionNames.slice(0, 500)) {
-          id: externalId,
+    let status: "active" | "suspended" | "unknown" = "unknown";
-          subscription_id: externalId,
+
-          external_id: externalId,
+    try {
-          name: columns.slice(1).join(" ") || externalId,
+      const infoResult = await pleskCliCall(connection, "subscription", [
-          status: null,
+        "--info",
-        };
+        subscriptionName,
+      ]);
+      status = parseSubscriptionStatusFromInfo(infoResult.stdout ?? "");
+    } catch {
+      status = "unknown";
+    }
+
+    subscriptions.push({
+      plesk_subscription_id: subscriptionName,
+      subscription_id: subscriptionName,
+      name: subscriptionName,
+      status,
     });
   }
+
+  return subscriptions;
+}
+
+export function parseSubscriptionStatusFromInfo(
+  stdout: string,
+): "active" | "suspended" | "unknown" {
+  const line = stdout
+    .split(/\r?\n/)
+    .map((entry) => entry.trim())
+    .find((entry) => /^domain\s+status\s*:/i.test(entry));
+
+  if (!line) return "unknown";
+
+  const value = line
+    .replace(/^domain\s+status\s*:/i, "")
+    .trim()
+    .toLowerCase();
+
+  if (value.includes("ok")) return "active";
+  if (value.includes("suspend") || value.includes("disabled")) {
+    return "suspended";
+  }
+
+  return "unknown";
 }
 
 export async function pleskCliCall(

lib/plesk/sync.ts

@@ -82,14 +82,19 @@ export async function syncPleskInstance(
 
     const subscriptionsForUpsert = subscriptionsRaw
       .map((item: any) => {
-        const sourceId = item?.id ?? item?.guid ?? item?.subscription_id;
+        const sourceId =
+          item?.plesk_subscription_id ??
+          item?.name ??
+          item?.id ??
+          item?.guid ??
+          item?.subscription_id;
         if (!sourceId) return null;
         return {
           agency_id: instance.agency_id,
           plesk_instance_id: instance.id,
           plesk_subscription_id: String(sourceId),
-          name: item?.name ? String(item.name) : null,
+          name: item?.name ? String(item.name) : String(sourceId),
-          status: item?.status ? String(item.status) : null,
+          status: item?.status ? String(item.status) : "unknown",
           owner_login: item?.owner_login
             ? String(item.owner_login)
             : item?.owner?.login
@@ -113,15 +118,44 @@ export async function syncPleskInstance(
       if (error) throw new Error(error.message);
     }
 
+    const { data: localSubscriptions, error: localSubscriptionsError } =
+      await supabase
+        .from("plesk_subscriptions")
+        .select("id, plesk_subscription_id, status")
+        .eq("agency_id", instance.agency_id)
+        .eq("plesk_instance_id", instance.id);
+
+    if (localSubscriptionsError) {
+      throw new Error(localSubscriptionsError.message);
+    }
+
+    const subscriptionByExternalId = new Map<
+      string,
+      { id: string; status: string | null }
+    >(
+      (localSubscriptions ?? [])
+        .filter((row: any) => row?.plesk_subscription_id && row?.id)
+        .map((row: any) => [
+          String(row.plesk_subscription_id),
+          {
+            id: String(row.id),
+            status: row?.status ? String(row.status) : null,
+          },
+        ]),
+    );
+
     const domainsForUpsert = domainsRaw
       .map((item: any) => {
         const domainId = item?.id ?? item?.guid ?? item?.name;
         const domainName = item?.name ?? item?.domain_name ?? item?.domain;
-        const status =
+        const subExternalId =
-          item?.status ??
-          (item?.hosting_type === "virtual" ? "active" : "inactive");
-        const externalSubscriptionId =
           item?.subscription?.id ?? item?.subscription_id ?? item?.webspace_id;
+        const externalSubscriptionId = subExternalId
+          ? String(subExternalId)
+          : null;
+        const localSubscription = externalSubscriptionId
+          ? subscriptionByExternalId.get(externalSubscriptionId)
+          : undefined;
         const rawCreated = item?.created_at ?? item?.created;
         const sourceCreatedAt = rawCreated
           ? new Date(String(rawCreated)).toISOString()
@@ -138,13 +172,11 @@ export async function syncPleskInstance(
         return {
           agency_id: instance.agency_id,
           plesk_instance_id: instance.id,
-          subscription_id: null,
+          subscription_id: localSubscription?.id ?? null,
-          external_subscription_id: externalSubscriptionId
+          external_subscription_id: externalSubscriptionId,
-            ? String(externalSubscriptionId)
-            : null,
           plesk_domain_id: String(domainId),
           domain_name: String(domainName),
-          status: status ? String(status) : "unknown",
+          status: localSubscription?.status ?? "unknown",
           hosting_type: item?.hosting_type ? String(item.hosting_type) : null,
           source_created_at: sourceCreatedAt,
           aliases_count: aliasesCount,

supabase/migrations/CL37_domain_status_backfill_from_subscription.sql

@@ -0,0 +1,6 @@
+-- One-time backfill: align existing domain status with linked subscription status
+update public.plesk_domains d
+set status = coalesce(s.status, 'unknown')
+from public.plesk_subscriptions s
+where d.subscription_id = s.id
+  and d.agency_id = s.agency_id;