feat(deploy): add Jenkins production deployment pipeline

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

.dockerignore

@@ -0,0 +1,13 @@
+node_modules
+.next
+.git
+*.log
+logs
+.env
+.env.*
+!.env.example
+.env.local
+.env.*.local
+.vscode
+.idea
+.DS_Store

.env.example

@@ -1,14 +1,22 @@
-NEXT_PUBLIC_SUPABASE_URL=
-NEXT_PUBLIC_SUPABASE_ANON_KEY=
-SUPABASE_SERVICE_ROLE_KEY=
+NODE_ENV=production
 
 NEXT_PUBLIC_APP_URL=http://localhost:3000
-JOB_SECRET=
-CRON_SECRET=
 
-ENCRYPTION_KEY=
+NEXT_PUBLIC_SUPABASE_URL=
+NEXT_PUBLIC_SUPABASE_ANON_KEY=
+SUPABASE_URL=
+SUPABASE_ANON_KEY=
+SUPABASE_SERVICE_ROLE_KEY=
+
 PLESK_CRED_ENC_KEY=
 
 STRIPE_SECRET_KEY=
 STRIPE_WEBHOOK_SECRET=
+
+CRON_SHARED_SECRET=
+
+# Existing runtime keys used by current codebase
+JOB_SECRET=
+CRON_SECRET=
+ENCRYPTION_KEY=
 STRIPE_PRICE_ID=

Dockerfile

@@ -0,0 +1,32 @@
+FROM cgr.dev/chainguard/node:20-dev AS deps
+WORKDIR /app
+
+COPY package.json package-lock.json ./
+RUN npm ci
+
+FROM cgr.dev/chainguard/node:20-dev AS builder
+WORKDIR /app
+
+COPY --from=deps /app/node_modules ./node_modules
+COPY . .
+RUN npm run build
+
+FROM cgr.dev/chainguard/node:20-dev AS prod-deps
+WORKDIR /app
+
+COPY package.json package-lock.json ./
+RUN npm ci --omit=dev
+
+FROM cgr.dev/chainguard/node:20 AS runner
+WORKDIR /app
+
+ENV NODE_ENV=production
+
+COPY --from=prod-deps /app/node_modules ./node_modules
+COPY --from=builder /app/package.json ./package.json
+COPY --from=builder /app/next.config.mjs ./next.config.mjs
+COPY --from=builder /app/.next ./.next
+
+EXPOSE 3000
+
+CMD ["node", "node_modules/next/dist/bin/next", "start", "-H", "0.0.0.0", "-p", "3000"]

Jenkinsfile

@@ -0,0 +1,85 @@
+pipeline {
+  agent any
+
+  environment {
+    REGISTRY_IMAGE = "plesk-agency-portal"
+    IMAGE_LATEST = "${REGISTRY_IMAGE}:latest"
+    IMAGE_BUILD = "${REGISTRY_IMAGE}:build-${BUILD_NUMBER}"
+  }
+
+  stages {
+    stage('Checkout') {
+      steps {
+        checkout scm
+      }
+    }
+
+    stage('Install dependencies') {
+      steps {
+        sh 'npm ci'
+      }
+    }
+
+    stage('Lint') {
+      steps {
+        script {
+          def hasLint = sh(script: "node -e \"const fs=require('fs');const p=require('./package.json');process.exit(p?.scripts?.lint?0:1)\"", returnStatus: true)
+          if (hasLint == 0) {
+            sh 'npm run lint'
+          } else {
+            echo 'No lint script configured; skipping lint stage.'
+          }
+        }
+      }
+    }
+
+    stage('Build application') {
+      steps {
+        sh 'npm run build'
+      }
+    }
+
+    stage('Build Docker image') {
+      steps {
+        sh 'docker build -t ${IMAGE_LATEST} -t ${IMAGE_BUILD} .'
+      }
+    }
+
+    stage('Deploy') {
+      steps {
+        script {
+          if (!env.DEPLOY_SSH_CREDENTIAL_ID) {
+            error 'DEPLOY_SSH_CREDENTIAL_ID is required'
+          }
+        }
+        sshagent(credentials: ["${env.DEPLOY_SSH_CREDENTIAL_ID}"]) {
+          sh '''
+            set -euo pipefail
+            : "${DEPLOY_SSH_HOST:?Missing DEPLOY_SSH_HOST}"
+            : "${DEPLOY_SSH_USER:?Missing DEPLOY_SSH_USER}"
+            : "${DEPLOY_PATH:?Missing DEPLOY_PATH}"
+
+            rsync -az \
+              docker-compose.prod.yml \
+              scripts/deploy-prod.sh \
+              scripts/smoke-check.sh \
+              scripts/rollback-prod.sh \
+              ${DEPLOY_SSH_USER}@${DEPLOY_SSH_HOST}:${DEPLOY_PATH}/
+
+            docker save ${IMAGE_LATEST} ${IMAGE_BUILD} \
+              | ssh ${DEPLOY_SSH_USER}@${DEPLOY_SSH_HOST} 'docker load'
+
+            ssh ${DEPLOY_SSH_USER}@${DEPLOY_SSH_HOST} \
+              "chmod +x ${DEPLOY_PATH}/deploy-prod.sh ${DEPLOY_PATH}/smoke-check.sh ${DEPLOY_PATH}/rollback-prod.sh && APP_IMAGE='${IMAGE_BUILD}' DEPLOY_PATH='${DEPLOY_PATH}' ${DEPLOY_PATH}/deploy-prod.sh"
+          '''
+        }
+      }
+    }
+
+    stage('Smoke check') {
+      steps {
+        sh 'chmod +x scripts/smoke-check.sh && scripts/smoke-check.sh ${APP_BASE_URL}'
+      }
+    }
+  }
+}

app/api/health/route.ts

@@ -0,0 +1,13 @@
+import { NextResponse } from "next/server";
+
+export async function GET() {
+  return NextResponse.json(
+    {
+      ok: true,
+      service: "plesk-agency-portal",
+      timestamp: new Date().toISOString(),
+      environment: process.env.NODE_ENV ?? "development",
+    },
+    { status: 200 },
+  );
+}

components/dashboard/dashboard-controls.tsx

@@ -160,6 +160,23 @@ function getDomainHref(domainName: string) {
   return `https://${normalized}`;
 }
 
+function getLatestTimestamp(values: Array<string | null | undefined>) {
+  let latest: string | null = null;
+  let latestMs = Number.NEGATIVE_INFINITY;
+
+  for (const value of values) {
+    if (!value) continue;
+    const ms = new Date(value).getTime();
+    if (Number.isNaN(ms)) continue;
+    if (ms > latestMs) {
+      latestMs = ms;
+      latest = value;
+    }
+  }
+
+  return latest;
+}
+
 export function DashboardControls({
   instances,
   subscriptions,
@@ -184,6 +201,7 @@ export function DashboardControls({
   const [message, setMessage] = useState<string | null>(null);
   const [loading, setLoading] = useState(false);
   const [isConnectPanelOpen, setIsConnectPanelOpen] = useState(!hasInstances);
+  const [isInstancesPanelOpen, setIsInstancesPanelOpen] = useState(true);
 
   useEffect(() => {
     if (!hasInstances) {
@@ -217,6 +235,38 @@ export function DashboardControls({
     );
   }, [hasInstances, isConnectPanelOpen]);
 
+  useEffect(() => {
+    if (!hasInstances) {
+      setIsInstancesPanelOpen(true);
+      return;
+    }
+
+    const savedState = window.localStorage.getItem(
+      "dashboard_instances_panel_open",
+    );
+
+    if (savedState === "true") {
+      setIsInstancesPanelOpen(true);
+      return;
+    }
+
+    if (savedState === "false") {
+      setIsInstancesPanelOpen(false);
+      return;
+    }
+
+    setIsInstancesPanelOpen(true);
+  }, [hasInstances]);
+
+  useEffect(() => {
+    if (!hasInstances) return;
+
+    window.localStorage.setItem(
+      "dashboard_instances_panel_open",
+      isInstancesPanelOpen ? "true" : "false",
+    );
+  }, [hasInstances, isInstancesPanelOpen]);
+
   const healthCounts = instances.reduce(
     (acc, instance) => {
       if (instance.status === "connected") acc.connected += 1;
@@ -245,6 +295,30 @@ export function DashboardControls({
     return statusMatches && searchMatches;
   });
 
+  const instanceHealthSummary = instances.reduce(
+    (acc, instance) => {
+      const status = (instance.health_status ?? "unknown").toLowerCase();
+      if (status === "ok") acc.ok += 1;
+      else if (status === "degraded") acc.degraded += 1;
+      else if (status === "down") acc.down += 1;
+      else acc.unknown += 1;
+      return acc;
+    },
+    { ok: 0, degraded: 0, down: 0, unknown: 0 },
+  );
+
+  const autoSyncEnabledCount = instances.filter(
+    (instance) => instance.auto_sync_enabled,
+  ).length;
+
+  const latestInstanceSyncAt = getLatestTimestamp(
+    instances.map((instance) => instance.last_sync_at),
+  );
+
+  const latestInstanceHealthCheckAt = getLatestTimestamp(
+    instances.map((instance) => instance.health_last_checked_at),
+  );
+
   async function runRequest(url: string, body?: unknown) {
     const response = await fetch(url, {
       method: "POST",
@@ -548,380 +622,440 @@ export function DashboardControls({
         </div>
 
         <div className="space-y-3 rounded-xl border border-slate-200 bg-white p-4">
-          <h2 className="text-lg font-semibold">Plesk Instances</h2>
+          <div className="flex items-center justify-between gap-3">
+            <h2 className="text-lg font-semibold">Plesk Instances</h2>
+            {hasInstances ? (
+              <button
+                type="button"
+                onClick={() => setIsInstancesPanelOpen((open) => !open)}
+                className="rounded border border-slate-300 px-3 py-1.5 text-xs font-medium text-slate-700"
+              >
+                {isInstancesPanelOpen ? "Hide" : "Show"}
+              </button>
+            ) : null}
+          </div>
 
-          <div className="space-y-2">
-            {instances.length === 0 ? (
-              <p className="text-sm text-slate-500">
-                No Plesk instances connected yet.
+          {!isInstancesPanelOpen && hasInstances ? (
+            <div className="rounded border border-slate-200 bg-slate-50 px-3 py-2 text-xs text-slate-700">
+              <p className="font-medium text-slate-900">
+                {instances.length} instance{instances.length === 1 ? "" : "s"}
               </p>
-            ) : (
-              instances.map((instance) => (
-                <div
-                  key={instance.id}
-                  className="rounded border border-slate-200 p-3"
-                >
-                  {(() => {
-                    const health = getHealthBadge(instance.health_status);
+              <p className="mt-1">
+                Health — OK: {instanceHealthSummary.ok}, Degraded:{" "}
+                {instanceHealthSummary.degraded}, Down:{" "}
+                {instanceHealthSummary.down}, Unknown:{" "}
+                {instanceHealthSummary.unknown}
+              </p>
+              <p className="mt-1">
+                Auto-sync enabled on {autoSyncEnabledCount} instance
+                {autoSyncEnabledCount === 1 ? "" : "s"}
+              </p>
+              <p className="mt-1">
+                Last sync: {formatDateTime(latestInstanceSyncAt)}
+              </p>
+              <p className="mt-1">
+                Last health check: {formatDateTime(latestInstanceHealthCheckAt)}
+              </p>
+            </div>
+          ) : null}
 
-                    return (
-                      <div className="flex items-start justify-between gap-2">
-                        <div>
-                          {autoSyncByInstance[instance.id] ? (
-                            <span
-                              className={`inline-flex rounded px-2 py-0.5 text-[11px] font-medium ${
-                                autoSyncByInstance[instance.id].status ===
-                                "success"
-                                  ? "bg-emerald-100 text-emerald-700"
-                                  : "bg-rose-100 text-rose-700"
-                              }`}
-                            >
-                              Auto-sync {autoSyncByInstance[instance.id].status}
-                            </span>
-                          ) : null}
-                          <p className="text-sm font-semibold text-slate-900">
-                            {instance.name}
-                          </p>
-                          <p className="text-xs text-slate-500">
-                            {instance.base_url}
-                          </p>
-                          <p className="mt-1 text-xs text-slate-600">
-                            Status:{" "}
-                            <span className="font-medium">
-                              {instance.status}
-                            </span>
-                          </p>
-                          <p className="text-xs text-slate-500">
-                            Health:{" "}
-                            <span
-                              title={instance.health_last_error ?? undefined}
-                              className={`inline-flex rounded px-2 py-0.5 text-[11px] font-medium ${health.className}`}
-                            >
-                              {health.label}
-                            </span>
-                          </p>
-                          <p className="text-xs text-slate-500">
-                            Health last checked:{" "}
-                            {formatDateTime(instance.health_last_checked_at)}
-                          </p>
-                          <p className="text-xs text-slate-500">
-                            Health latency:{" "}
-                            {instance.health_last_latency_ms != null
-                              ? `${instance.health_last_latency_ms} ms`
-                              : "—"}
-                          </p>
-                          <p className="text-xs text-slate-500">
-                            Subscriptions:{" "}
-                            {instance.last_sync_subscriptions ?? 0}
-                          </p>
-                          <p className="text-xs text-slate-500">
-                            Domains: {instance.last_sync_domains ?? 0}
-                          </p>
-                          <p className="text-xs text-slate-500">
-                            Last sync status:{" "}
-                            <span
-                              className={`inline-flex rounded px-2 py-0.5 text-[11px] font-medium ${
-                                instance.last_sync_status === "success"
-                                  ? "bg-emerald-100 text-emerald-700"
-                                  : instance.last_sync_status === "failed" ||
-                                      instance.last_sync_status === "error"
-                                    ? "bg-rose-100 text-rose-700"
-                                    : "bg-slate-100 text-slate-600"
-                              }`}
-                            >
-                              {instance.last_sync_status ?? "unknown"}
-                            </span>
-                          </p>
-                          <p className="text-xs text-slate-500">
-                            Last sync time:{" "}
-                            {formatDateTime(instance.last_sync_at)}
-                          </p>
-                          <p className="text-xs text-slate-500">
-                            Last connected:{" "}
-                            {instance.last_connected_at
-                              ? formatDateTime(instance.last_connected_at)
-                              : "never"}
-                          </p>
-                          <p className="text-xs text-slate-500">
-                            Auto-sync:{" "}
-                            {instance.auto_sync_enabled
-                              ? "Enabled"
-                              : "Disabled"}
-                          </p>
-                          <p className="text-xs text-slate-500">
-                            Auto-sync frequency:{" "}
-                            {instance.auto_sync_frequency_minutes ?? 60} min
-                          </p>
-                          <p className="text-xs text-slate-500">
-                            Last auto-sync:{" "}
-                            {formatDateTime(instance.last_auto_sync_at)}
-                          </p>
-                          <p className="text-xs text-slate-500">
-                            Next auto-sync:{" "}
-                            {formatDateTime(instance.next_auto_sync_at)}
-                          </p>
-                          <p className="text-xs text-slate-500">
-                            Lock status:{" "}
-                            {instance.auto_sync_lock_until &&
-                            new Date(instance.auto_sync_lock_until).getTime() >
-                              Date.now()
-                              ? "Sync in progress"
-                              : "Idle"}
-                          </p>
-                          {autoSyncByInstance[instance.id] ? (
-                            <p className="text-xs text-slate-500">
-                              Last auto-sync:{" "}
-                              {formatDateTime(
-                                autoSyncByInstance[instance.id].created_at,
-                              )}
-                            </p>
-                          ) : null}
-                          {instance.error_message ? (
-                            <p className="mt-1 text-xs text-rose-600">
-                              {instance.error_message}
-                            </p>
-                          ) : null}
-                          {instance.last_sync_error ? (
-                            <p className="mt-1 text-xs text-rose-600">
-                              Last sync error: {instance.last_sync_error}
-                            </p>
-                          ) : null}
-                          {autoSyncByInstance[instance.id]?.error_message ? (
-                            <p className="mt-1 text-xs text-rose-600">
-                              Auto-sync error:{" "}
-                              {autoSyncByInstance[instance.id].error_message}
-                            </p>
-                          ) : null}
-                          {instance.health_last_error ? (
-                            <p
-                              className="mt-1 text-xs text-rose-600"
-                              title={instance.health_last_error}
-                            >
-                              Health error: {instance.health_last_error}
-                            </p>
-                          ) : null}
-                        </div>
-                        <div className="flex flex-col gap-2">
-                          <div className="flex items-center gap-2">
-                            <label className="text-xs text-slate-600">
-                              Auto-sync
-                            </label>
-                            <input
-                              type="checkbox"
-                              checked={instance.auto_sync_enabled}
-                              onChange={(e: ChangeEvent<HTMLInputElement>) =>
-                                onUpdateAutoSync(instance.id, {
-                                  auto_sync_enabled: e.target.checked,
-                                  auto_sync_frequency_minutes:
-                                    instance.auto_sync_frequency_minutes ?? 60,
-                                })
-                              }
-                              disabled={loading}
-                            />
-                          </div>
-                          <select
-                            value={String(
-                              instance.auto_sync_frequency_minutes ?? 60,
-                            )}
-                            onChange={(e: ChangeEvent<HTMLSelectElement>) =>
-                              onUpdateAutoSync(instance.id, {
-                                auto_sync_enabled: instance.auto_sync_enabled,
-                                auto_sync_frequency_minutes: Number(
-                                  e.target.value,
-                                ),
-                              })
-                            }
-                            disabled={loading}
-                            className="rounded border px-2 py-1 text-xs"
-                          >
-                            {autoSyncFrequencyOptions.map((minutes) => (
-                              <option key={minutes} value={minutes}>
-                                Every {minutes} min
-                              </option>
-                            ))}
-                          </select>
-                          <button
-                            onClick={() => onTestConnection(instance.id)}
-                            disabled={loading}
-                            className="rounded border px-3 py-1.5 text-xs"
-                          >
-                            Test Connection
-                          </button>
-                          <button
-                            onClick={() => onRunHealthCheck(instance.id)}
-                            disabled={loading}
-                            className="rounded border px-3 py-1.5 text-xs"
-                          >
-                            Run Health Check
-                          </button>
-                          <button
-                            onClick={() => onSync(instance.id)}
-                            disabled={loading}
-                            className="rounded border px-3 py-1.5 text-xs"
-                          >
-                            Sync Now
-                          </button>
-                        </div>
-                      </div>
-                    );
-                  })()}
+          {isInstancesPanelOpen ? (
+            <>
+              <div className="space-y-2">
+                {instances.length === 0 ? (
+                  <p className="text-sm text-slate-500">
+                    No Plesk instances connected yet.
+                  </p>
+                ) : (
+                  instances.map((instance) => (
+                    <div
+                      key={instance.id}
+                      className="rounded border border-slate-200 p-3"
+                    >
+                      {(() => {
+                        const health = getHealthBadge(instance.health_status);
 
-                  <div className="mt-3 rounded border border-slate-100 bg-slate-50 p-3">
-                    <p className="text-xs font-semibold uppercase tracking-wide text-slate-600">
-                      Health Panel
-                    </p>
-                    <div className="mt-2 grid gap-1 text-xs text-slate-600 sm:grid-cols-2">
-                      <p>
-                        Current Status:{" "}
-                        <span className="font-medium">
-                          {getHealthBadge(instance.health_status).label}
-                        </span>
-                      </p>
-                      <p>
-                        Last Checked:{" "}
-                        <span className="font-medium">
-                          {formatDateTime(instance.health_last_checked_at)}
-                        </span>
-                      </p>
-                      <p>
-                        Last Successful Check:{" "}
-                        <span className="font-medium">
-                          {formatDateTime(instance.health_last_ok_at)}
-                        </span>
-                      </p>
-                      <p>
-                        Latency:{" "}
-                        <span className="font-medium">
-                          {instance.health_last_latency_ms != null
-                            ? `${instance.health_last_latency_ms} ms`
-                            : "—"}
-                        </span>
-                      </p>
-                      <p className="sm:col-span-2">
-                        Last Error:{" "}
-                        <span className="font-medium">
-                          {instance.health_last_error ?? "—"}
-                        </span>
-                      </p>
-                    </div>
-
-                    <div className="mt-3 overflow-x-auto">
-                      <table className="min-w-full text-left text-xs">
-                        <thead>
-                          <tr className="border-b border-slate-200 text-slate-500">
-                            <th className="px-2 py-1">Time</th>
-                            <th className="px-2 py-1">Event</th>
-                            <th className="px-2 py-1">Result</th>
-                            <th className="px-2 py-1">Message</th>
-                          </tr>
-                        </thead>
-                        <tbody>
-                          {(healthEventsByInstance[instance.id] ?? [])
-                            .length === 0 ? (
-                            <tr>
-                              <td
-                                className="px-2 py-2 text-slate-500"
-                                colSpan={4}
-                              >
-                                No health events yet.
-                              </td>
-                            </tr>
-                          ) : (
-                            (healthEventsByInstance[instance.id] ?? []).map(
-                              (event) => (
-                                <tr
-                                  key={event.id}
-                                  className="border-b border-slate-100 align-top"
+                        return (
+                          <div className="flex items-start justify-between gap-2">
+                            <div>
+                              {autoSyncByInstance[instance.id] ? (
+                                <span
+                                  className={`inline-flex rounded px-2 py-0.5 text-[11px] font-medium ${
+                                    autoSyncByInstance[instance.id].status ===
+                                    "success"
+                                      ? "bg-emerald-100 text-emerald-700"
+                                      : "bg-rose-100 text-rose-700"
+                                  }`}
                                 >
-                                  <td className="px-2 py-1">
-                                    {formatDateTime(event.created_at)}
-                                  </td>
-                                  <td className="px-2 py-1">{event.action}</td>
-                                  <td className="px-2 py-1">
-                                    {mapHealthResult(event.action)}
-                                  </td>
-                                  <td className="px-2 py-1">
-                                    {event.error_message ?? "—"}
-                                    {event.metadata ? (
-                                      <details>
-                                        <summary className="cursor-pointer text-[11px] text-brand-700">
-                                          metadata
-                                        </summary>
-                                        <pre className="mt-1 max-w-[440px] overflow-auto rounded bg-white p-2 text-[10px] text-slate-700">
-                                          {JSON.stringify(
-                                            event.metadata,
-                                            null,
-                                            2,
-                                          )}
-                                        </pre>
-                                      </details>
-                                    ) : null}
+                                  Auto-sync{" "}
+                                  {autoSyncByInstance[instance.id].status}
+                                </span>
+                              ) : null}
+                              <p className="text-sm font-semibold text-slate-900">
+                                {instance.name}
+                              </p>
+                              <p className="text-xs text-slate-500">
+                                {instance.base_url}
+                              </p>
+                              <p className="mt-1 text-xs text-slate-600">
+                                Status:{" "}
+                                <span className="font-medium">
+                                  {instance.status}
+                                </span>
+                              </p>
+                              <p className="text-xs text-slate-500">
+                                Health:{" "}
+                                <span
+                                  title={
+                                    instance.health_last_error ?? undefined
+                                  }
+                                  className={`inline-flex rounded px-2 py-0.5 text-[11px] font-medium ${health.className}`}
+                                >
+                                  {health.label}
+                                </span>
+                              </p>
+                              <p className="text-xs text-slate-500">
+                                Health last checked:{" "}
+                                {formatDateTime(
+                                  instance.health_last_checked_at,
+                                )}
+                              </p>
+                              <p className="text-xs text-slate-500">
+                                Health latency:{" "}
+                                {instance.health_last_latency_ms != null
+                                  ? `${instance.health_last_latency_ms} ms`
+                                  : "—"}
+                              </p>
+                              <p className="text-xs text-slate-500">
+                                Subscriptions:{" "}
+                                {instance.last_sync_subscriptions ?? 0}
+                              </p>
+                              <p className="text-xs text-slate-500">
+                                Domains: {instance.last_sync_domains ?? 0}
+                              </p>
+                              <p className="text-xs text-slate-500">
+                                Last sync status:{" "}
+                                <span
+                                  className={`inline-flex rounded px-2 py-0.5 text-[11px] font-medium ${
+                                    instance.last_sync_status === "success"
+                                      ? "bg-emerald-100 text-emerald-700"
+                                      : instance.last_sync_status ===
+                                            "failed" ||
+                                          instance.last_sync_status === "error"
+                                        ? "bg-rose-100 text-rose-700"
+                                        : "bg-slate-100 text-slate-600"
+                                  }`}
+                                >
+                                  {instance.last_sync_status ?? "unknown"}
+                                </span>
+                              </p>
+                              <p className="text-xs text-slate-500">
+                                Last sync time:{" "}
+                                {formatDateTime(instance.last_sync_at)}
+                              </p>
+                              <p className="text-xs text-slate-500">
+                                Last connected:{" "}
+                                {instance.last_connected_at
+                                  ? formatDateTime(instance.last_connected_at)
+                                  : "never"}
+                              </p>
+                              <p className="text-xs text-slate-500">
+                                Auto-sync:{" "}
+                                {instance.auto_sync_enabled
+                                  ? "Enabled"
+                                  : "Disabled"}
+                              </p>
+                              <p className="text-xs text-slate-500">
+                                Auto-sync frequency:{" "}
+                                {instance.auto_sync_frequency_minutes ?? 60} min
+                              </p>
+                              <p className="text-xs text-slate-500">
+                                Last auto-sync:{" "}
+                                {formatDateTime(instance.last_auto_sync_at)}
+                              </p>
+                              <p className="text-xs text-slate-500">
+                                Next auto-sync:{" "}
+                                {formatDateTime(instance.next_auto_sync_at)}
+                              </p>
+                              <p className="text-xs text-slate-500">
+                                Lock status:{" "}
+                                {instance.auto_sync_lock_until &&
+                                new Date(
+                                  instance.auto_sync_lock_until,
+                                ).getTime() > Date.now()
+                                  ? "Sync in progress"
+                                  : "Idle"}
+                              </p>
+                              {autoSyncByInstance[instance.id] ? (
+                                <p className="text-xs text-slate-500">
+                                  Last auto-sync:{" "}
+                                  {formatDateTime(
+                                    autoSyncByInstance[instance.id].created_at,
+                                  )}
+                                </p>
+                              ) : null}
+                              {instance.error_message ? (
+                                <p className="mt-1 text-xs text-rose-600">
+                                  {instance.error_message}
+                                </p>
+                              ) : null}
+                              {instance.last_sync_error ? (
+                                <p className="mt-1 text-xs text-rose-600">
+                                  Last sync error: {instance.last_sync_error}
+                                </p>
+                              ) : null}
+                              {autoSyncByInstance[instance.id]
+                                ?.error_message ? (
+                                <p className="mt-1 text-xs text-rose-600">
+                                  Auto-sync error:{" "}
+                                  {
+                                    autoSyncByInstance[instance.id]
+                                      .error_message
+                                  }
+                                </p>
+                              ) : null}
+                              {instance.health_last_error ? (
+                                <p
+                                  className="mt-1 text-xs text-rose-600"
+                                  title={instance.health_last_error}
+                                >
+                                  Health error: {instance.health_last_error}
+                                </p>
+                              ) : null}
+                            </div>
+                            <div className="flex flex-col gap-2">
+                              <div className="flex items-center gap-2">
+                                <label className="text-xs text-slate-600">
+                                  Auto-sync
+                                </label>
+                                <input
+                                  type="checkbox"
+                                  checked={instance.auto_sync_enabled}
+                                  onChange={(
+                                    e: ChangeEvent<HTMLInputElement>,
+                                  ) =>
+                                    onUpdateAutoSync(instance.id, {
+                                      auto_sync_enabled: e.target.checked,
+                                      auto_sync_frequency_minutes:
+                                        instance.auto_sync_frequency_minutes ??
+                                        60,
+                                    })
+                                  }
+                                  disabled={loading}
+                                />
+                              </div>
+                              <select
+                                value={String(
+                                  instance.auto_sync_frequency_minutes ?? 60,
+                                )}
+                                onChange={(e: ChangeEvent<HTMLSelectElement>) =>
+                                  onUpdateAutoSync(instance.id, {
+                                    auto_sync_enabled:
+                                      instance.auto_sync_enabled,
+                                    auto_sync_frequency_minutes: Number(
+                                      e.target.value,
+                                    ),
+                                  })
+                                }
+                                disabled={loading}
+                                className="rounded border px-2 py-1 text-xs"
+                              >
+                                {autoSyncFrequencyOptions.map((minutes) => (
+                                  <option key={minutes} value={minutes}>
+                                    Every {minutes} min
+                                  </option>
+                                ))}
+                              </select>
+                              <button
+                                onClick={() => onTestConnection(instance.id)}
+                                disabled={loading}
+                                className="rounded border px-3 py-1.5 text-xs"
+                              >
+                                Test Connection
+                              </button>
+                              <button
+                                onClick={() => onRunHealthCheck(instance.id)}
+                                disabled={loading}
+                                className="rounded border px-3 py-1.5 text-xs"
+                              >
+                                Run Health Check
+                              </button>
+                              <button
+                                onClick={() => onSync(instance.id)}
+                                disabled={loading}
+                                className="rounded border px-3 py-1.5 text-xs"
+                              >
+                                Sync Now
+                              </button>
+                            </div>
+                          </div>
+                        );
+                      })()}
+
+                      <div className="mt-3 rounded border border-slate-100 bg-slate-50 p-3">
+                        <p className="text-xs font-semibold uppercase tracking-wide text-slate-600">
+                          Health Panel
+                        </p>
+                        <div className="mt-2 grid gap-1 text-xs text-slate-600 sm:grid-cols-2">
+                          <p>
+                            Current Status:{" "}
+                            <span className="font-medium">
+                              {getHealthBadge(instance.health_status).label}
+                            </span>
+                          </p>
+                          <p>
+                            Last Checked:{" "}
+                            <span className="font-medium">
+                              {formatDateTime(instance.health_last_checked_at)}
+                            </span>
+                          </p>
+                          <p>
+                            Last Successful Check:{" "}
+                            <span className="font-medium">
+                              {formatDateTime(instance.health_last_ok_at)}
+                            </span>
+                          </p>
+                          <p>
+                            Latency:{" "}
+                            <span className="font-medium">
+                              {instance.health_last_latency_ms != null
+                                ? `${instance.health_last_latency_ms} ms`
+                                : "—"}
+                            </span>
+                          </p>
+                          <p className="sm:col-span-2">
+                            Last Error:{" "}
+                            <span className="font-medium">
+                              {instance.health_last_error ?? "—"}
+                            </span>
+                          </p>
+                        </div>
+
+                        <div className="mt-3 overflow-x-auto">
+                          <table className="min-w-full text-left text-xs">
+                            <thead>
+                              <tr className="border-b border-slate-200 text-slate-500">
+                                <th className="px-2 py-1">Time</th>
+                                <th className="px-2 py-1">Event</th>
+                                <th className="px-2 py-1">Result</th>
+                                <th className="px-2 py-1">Message</th>
+                              </tr>
+                            </thead>
+                            <tbody>
+                              {(healthEventsByInstance[instance.id] ?? [])
+                                .length === 0 ? (
+                                <tr>
+                                  <td
+                                    className="px-2 py-2 text-slate-500"
+                                    colSpan={4}
+                                  >
+                                    No health events yet.
                                   </td>
                                 </tr>
-                              ),
-                            )
-                          )}
-                        </tbody>
-                      </table>
+                              ) : (
+                                (healthEventsByInstance[instance.id] ?? []).map(
+                                  (event) => (
+                                    <tr
+                                      key={event.id}
+                                      className="border-b border-slate-100 align-top"
+                                    >
+                                      <td className="px-2 py-1">
+                                        {formatDateTime(event.created_at)}
+                                      </td>
+                                      <td className="px-2 py-1">
+                                        {event.action}
+                                      </td>
+                                      <td className="px-2 py-1">
+                                        {mapHealthResult(event.action)}
+                                      </td>
+                                      <td className="px-2 py-1">
+                                        {event.error_message ?? "—"}
+                                        {event.metadata ? (
+                                          <details>
+                                            <summary className="cursor-pointer text-[11px] text-brand-700">
+                                              metadata
+                                            </summary>
+                                            <pre className="mt-1 max-w-[440px] overflow-auto rounded bg-white p-2 text-[10px] text-slate-700">
+                                              {JSON.stringify(
+                                                event.metadata,
+                                                null,
+                                                2,
+                                              )}
+                                            </pre>
+                                          </details>
+                                        ) : null}
+                                      </td>
+                                    </tr>
+                                  ),
+                                )
+                              )}
+                            </tbody>
+                          </table>
+                        </div>
+                      </div>
                     </div>
-                  </div>
-                </div>
-              ))
-            )}
-          </div>
+                  ))
+                )}
+              </div>
 
-          <div className="space-y-2">
-            <label className="text-sm font-medium">Subscription Action</label>
-            <select
-              value={actionSubId}
-              onChange={(e: ChangeEvent<HTMLSelectElement>) =>
-                setActionSubId(e.target.value)
-              }
-              className="w-full rounded border border-slate-300 px-3 py-2 text-sm"
-            >
-              {subscriptions.map((subscription) => (
-                <option key={subscription.id} value={subscription.id}>
-                  {subscription.name ?? subscription.plesk_subscription_id}
-                </option>
-              ))}
-            </select>
-            <select
-              value={actionType}
-              onChange={(e: ChangeEvent<HTMLSelectElement>) =>
-                setActionType(e.target.value as "suspend" | "unsuspend")
-              }
-              className="w-full rounded border border-slate-300 px-3 py-2 text-sm"
-            >
-              <option value="suspend">Suspend</option>
-              <option value="unsuspend">Unsuspend</option>
-            </select>
-            <button
-              onClick={onSubscriptionAction}
-              disabled={loading || !actionSubId}
-              className="rounded border px-3 py-2 text-sm"
-            >
-              Execute Action
-            </button>
-          </div>
+              <div className="space-y-2">
+                <label className="text-sm font-medium">
+                  Subscription Action
+                </label>
+                <select
+                  value={actionSubId}
+                  onChange={(e: ChangeEvent<HTMLSelectElement>) =>
+                    setActionSubId(e.target.value)
+                  }
+                  className="w-full rounded border border-slate-300 px-3 py-2 text-sm"
+                >
+                  {subscriptions.map((subscription) => (
+                    <option key={subscription.id} value={subscription.id}>
+                      {subscription.name ?? subscription.plesk_subscription_id}
+                    </option>
+                  ))}
+                </select>
+                <select
+                  value={actionType}
+                  onChange={(e: ChangeEvent<HTMLSelectElement>) =>
+                    setActionType(e.target.value as "suspend" | "unsuspend")
+                  }
+                  className="w-full rounded border border-slate-300 px-3 py-2 text-sm"
+                >
+                  <option value="suspend">Suspend</option>
+                  <option value="unsuspend">Unsuspend</option>
+                </select>
+                <button
+                  onClick={onSubscriptionAction}
+                  disabled={loading || !actionSubId}
+                  className="rounded border px-3 py-2 text-sm"
+                >
+                  Execute Action
+                </button>
+              </div>
 
-          <div className="flex gap-2 pt-2">
-            <button
-              onClick={onCheckout}
-              disabled={loading}
-              className="rounded bg-brand-600 px-3 py-2 text-sm text-white"
-            >
-              Start Checkout
-            </button>
-            <button
-              onClick={onPortal}
-              disabled={loading}
-              className="rounded border px-3 py-2 text-sm"
-            >
-              Billing Portal
-            </button>
-          </div>
+              <div className="flex gap-2 pt-2">
+                <button
+                  onClick={onCheckout}
+                  disabled={loading}
+                  className="rounded bg-brand-600 px-3 py-2 text-sm text-white"
+                >
+                  Start Checkout
+                </button>
+                <button
+                  onClick={onPortal}
+                  disabled={loading}
+                  className="rounded border px-3 py-2 text-sm"
+                >
+                  Billing Portal
+                </button>
+              </div>
 
-          {message ? <p className="text-sm text-slate-600">{message}</p> : null}
+              {message ? (
+                <p className="text-sm text-slate-600">{message}</p>
+              ) : null}
+            </>
+          ) : null}
         </div>
 
         <div className="space-y-3 rounded-xl border border-slate-200 bg-white p-4 lg:col-span-2">

docker-compose.prod.yml

@@ -0,0 +1,24 @@
+services:
+  web:
+    container_name: plesk-agency-portal
+    image: ${APP_IMAGE:-plesk-agency-portal:latest}
+    build:
+      context: .
+      dockerfile: Dockerfile
+    restart: unless-stopped
+    env_file:
+      - .env
+    ports:
+      - "3000:3000"
+    healthcheck:
+      test:
+        [
+          "CMD",
+          "node",
+          "-e",
+          "fetch('http://127.0.0.1:3000/api/health').then((r)=>{if(!r.ok)process.exit(1)}).catch(()=>process.exit(1))",
+        ]
+      interval: 30s
+      timeout: 5s
+      retries: 3
+      start_period: 20s

docs/deployment-production.md

@@ -0,0 +1,121 @@
+# Production Deployment Runtime Foundation
+
+This project can be deployed in a dedicated Proxmox container using Docker Compose. The files added here establish a minimal production runtime baseline without changing application business logic or Supabase security boundaries.
+
+## Dockerfile purpose
+
+The `Dockerfile` uses a multi-stage build on Node 20:
+
+- installs dependencies
+- runs `next build`
+- prepares a lean runtime image with production dependencies
+- runs the app with `next start` on port `3000`
+
+This keeps the runtime image small and focused on serving the built Next.js app.
+
+## docker-compose.prod.yml purpose
+
+`docker-compose.prod.yml` defines one service:
+
+- service name: `web`
+- container name: `plesk-agency-portal`
+- restart policy: `unless-stopped`
+- environment from `.env`
+- port mapping `3000:3000`
+- health check against `/api/health`
+
+## External Supabase requirement
+
+Supabase remains external to this application container. The app container must only connect to Supabase via environment variables. No local Supabase container is included in this production compose file.
+
+## Health endpoint usage
+
+`GET /api/health` provides a fast, dependency-light runtime check for container orchestration and uptime checks.
+
+Example:
+
+```bash
+curl -s http://localhost:3000/api/health
+```
+
+Expected response shape:
+
+- `ok: true`
+- `service: "plesk-agency-portal"`
+- `timestamp`
+- `environment`
+
+## Production environment expectations
+
+Before deploying, set production-safe values in `.env` (using `.env.example` as the template), including:
+
+- app URL and `NODE_ENV`
+- Supabase public and server credentials
+- Plesk credential encryption key
+- Stripe secrets
+- cron/job shared secrets
+
+Keep secrets out of source control.
+
+## Jenkins pipeline flow
+
+The repository includes a declarative `Jenkinsfile` with the following stages:
+
+1. **Checkout**
+2. **Install dependencies** (`npm ci`)
+3. **Lint** (runs only when `package.json` contains a `lint` script)
+4. **Build application** (`npm run build`)
+5. **Build Docker image** (tags `latest` and `build-${BUILD_NUMBER}`)
+6. **Deploy** over SSH to the app host
+7. **Smoke check** against `/api/health`
+
+## Required Jenkins configuration
+
+Configure these values in Jenkins job/folder/global environment or credentials-backed environment variables:
+
+- `DEPLOY_SSH_HOST` - remote app host
+- `DEPLOY_SSH_USER` - SSH user on remote host
+- `DEPLOY_SSH_CREDENTIAL_ID` - Jenkins SSH Agent credential ID
+- `DEPLOY_PATH` - remote deployment path (for example `/opt/plesk-agency-portal`)
+- `APP_BASE_URL` - externally reachable app URL used by smoke check
+
+The pipeline assumes Jenkins credentials are managed outside this repository.
+
+## Deploy flow
+
+Deployment is intentionally simple and bash-based:
+
+1. Jenkins builds Docker image tags locally.
+2. Jenkins syncs deployment files (`docker-compose.prod.yml`, deploy/smoke/rollback scripts) to the remote deploy path.
+3. Jenkins streams Docker images to the remote host (`docker save | ssh docker load`).
+4. Jenkins runs `scripts/deploy-prod.sh` remotely.
+5. Script applies the selected image tag via:
+
+```bash
+APP_IMAGE=<tag> docker compose -f docker-compose.prod.yml up -d --no-build
+```
+
+6. Script prints `docker compose ps` status.
+
+## Rollback flow
+
+Rollback uses `scripts/rollback-prod.sh` with a previously built image tag:
+
+```bash
+DEPLOY_PATH=/opt/plesk-agency-portal \
+APP_BASE_URL=https://your-app.example.com \
+scripts/rollback-prod.sh plesk-agency-portal:build-123
+```
+
+Rollback redeploys that image with compose, then immediately reruns smoke checks.
+
+## Smoke check behavior
+
+`scripts/smoke-check.sh`:
+
+- accepts a base URL argument
+- requests `${BASE_URL}/api/health`
+- fails on non-200 responses
+- fails on invalid JSON or missing expected fields (`ok: true`, `service` string)
+
+This gives a quick post-deploy validation gate for both deploy and rollback operations.

scripts/deploy-prod.sh

@@ -0,0 +1,30 @@
+#!/usr/bin/env bash
+
+set -euo pipefail
+
+DEPLOY_PATH="${DEPLOY_PATH:-/opt/plesk-agency-portal}"
+APP_IMAGE="${APP_IMAGE:-plesk-agency-portal:latest}"
+SOURCE_PATH="${SOURCE_PATH:-${DEPLOY_PATH}}"
+
+mkdir -p "${DEPLOY_PATH}"
+
+for file in docker-compose.prod.yml deploy-prod.sh smoke-check.sh rollback-prod.sh; do
+  if [ -f "${SOURCE_PATH}/${file}" ]; then
+    cp "${SOURCE_PATH}/${file}" "${DEPLOY_PATH}/${file}"
+  fi
+done
+
+chmod +x "${DEPLOY_PATH}/deploy-prod.sh" \
+  "${DEPLOY_PATH}/smoke-check.sh" \
+  "${DEPLOY_PATH}/rollback-prod.sh" 2>/dev/null || true
+
+if [ ! -f "${DEPLOY_PATH}/docker-compose.prod.yml" ]; then
+  echo "Missing docker-compose.prod.yml in ${DEPLOY_PATH}" >&2
+  exit 1
+fi
+
+cd "${DEPLOY_PATH}"
+
+APP_IMAGE="${APP_IMAGE}" docker compose -f docker-compose.prod.yml up -d --no-build
+
+docker compose -f docker-compose.prod.yml ps

scripts/rollback-prod.sh

@@ -0,0 +1,30 @@
+#!/usr/bin/env bash
+
+set -euo pipefail
+
+PREVIOUS_IMAGE_TAG="${1:-}"
+DEPLOY_PATH="${DEPLOY_PATH:-/opt/plesk-agency-portal}"
+APP_BASE_URL="${APP_BASE_URL:-}"
+
+if [ -z "${PREVIOUS_IMAGE_TAG}" ]; then
+  echo "Usage: $0 <previous-image-tag>" >&2
+  exit 1
+fi
+
+if [ -z "${APP_BASE_URL}" ]; then
+  echo "APP_BASE_URL is required" >&2
+  exit 1
+fi
+
+if [ ! -f "${DEPLOY_PATH}/docker-compose.prod.yml" ]; then
+  echo "Missing docker-compose.prod.yml in ${DEPLOY_PATH}" >&2
+  exit 1
+fi
+
+cd "${DEPLOY_PATH}"
+
+APP_IMAGE="${PREVIOUS_IMAGE_TAG}" docker compose -f docker-compose.prod.yml up -d --no-build
+
+"${DEPLOY_PATH}/smoke-check.sh" "${APP_BASE_URL}"
+
+docker compose -f docker-compose.prod.yml ps

scripts/smoke-check.sh

@@ -0,0 +1,27 @@
+#!/usr/bin/env bash
+
+set -euo pipefail
+
+BASE_URL="${1:-}"
+
+if [ -z "${BASE_URL}" ]; then
+  echo "Usage: $0 <base-url>" >&2
+  exit 1
+fi
+
+URL="${BASE_URL%/}/api/health"
+TMP_FILE="$(mktemp)"
+
+trap 'rm -f "${TMP_FILE}"' EXIT
+
+HTTP_CODE=$(curl -sS -o "${TMP_FILE}" -w "%{http_code}" "${URL}")
+
+if [ "${HTTP_CODE}" != "200" ]; then
+  echo "Smoke check failed: ${URL} returned ${HTTP_CODE}" >&2
+  cat "${TMP_FILE}" >&2 || true
+  exit 1
+fi
+
+node -e "const fs=require('fs');const d=JSON.parse(fs.readFileSync(process.argv[1],'utf8'));if(d?.ok!==true||typeof d?.service!=='string'){process.exit(1)}" "${TMP_FILE}"
+
+echo "Smoke check passed: ${URL}"