#!/bin/bash
# Import SOLO branding MTM su produzione VTE 26 (nessun modulo).
#
# Prerequisito: backup DB + file produzione.
#
# Uso:
#   export VTE_ROOT=/var/www/html/crm-mtm
#   export DB_NAME=vte_mtm
#   export DB_USER=...
#   export DB_PASS='...'
#   bash mtm-import-branding-only.sh /path/to/mtm-branding-only
#
# SPDX-FileCopyrightText: 2026 Pantarei

set -euo pipefail

PKG_DIR="${1:?Uso: mtm-import-branding-only.sh /path/to/mtm-branding-only}"
VTE_ROOT="${VTE_ROOT:?Impostare VTE_ROOT}"
DB_USER="${DB_USER:?Impostare DB_USER}"
DB_NAME="${DB_NAME:?Impostare DB_NAME}"
DB_PASS="${DB_PASS:-}"

FILES="${PKG_DIR}/files"
SQL="${PKG_DIR}/sql"

MYSQL=(mysql -u "${DB_USER}")
[[ -n "${DB_PASS}" ]] && MYSQL+=(-p"${DB_PASS}")
MYSQL+=("${DB_NAME}")

if [[ ! -d "${FILES}" ]]; then
	echo "ERRORE: cartella files/ mancante in ${PKG_DIR}" >&2
	exit 1
fi

echo "=== Import branding MTM su ${VTE_ROOT} ==="

if [[ -d "${FILES}/themes/logos/custom" ]]; then
	mkdir -p "${VTE_ROOT}/themes/logos/custom"
	cp -a "${FILES}/themes/logos/custom/." "${VTE_ROOT}/themes/logos/custom/"
	echo "OK themes/logos/custom"
fi

if [[ -d "${FILES}/themes/wallpapers" ]] && [[ -n "$(ls -A "${FILES}/themes/wallpapers" 2>/dev/null)" ]]; then
	mkdir -p "${VTE_ROOT}/themes/wallpapers"
	cp -a "${FILES}/themes/wallpapers/." "${VTE_ROOT}/themes/wallpapers/"
	echo "OK themes/wallpapers"
fi

if [[ -d "${FILES}/storage/logo" ]]; then
	mkdir -p "${VTE_ROOT}/storage/logo"
	cp -a "${FILES}/storage/logo/." "${VTE_ROOT}/storage/logo/"
	echo "OK storage/logo"
fi

if [[ -f "${SQL}/01-vteprop-theme.sql" ]]; then
	echo "Import theme.* (colori, logo, sfondi)..."
	"${MYSQL[@]}" < "${SQL}/01-vteprop-theme.sql"
	echo "OK vte_vteprop"
fi

if [[ -f "${SQL}/02-organizationdetails.sql" ]]; then
	echo "Import organizationdetails..."
	echo "  (controllare ragione sociale dopo import)"
	"${MYSQL[@]}" < "${SQL}/02-organizationdetails.sql"
	echo "OK organizationdetails"
fi

# Invalida cache proprietà tema
if [[ -f "${VTE_ROOT}/cache/sys/vteprops.json" ]]; then
	rm -f "${VTE_ROOT}/cache/sys/vteprops.json"
	echo "OK rimossa cache vteprops.json"
fi

if [[ -x /var/www/html/server-ops/mypantarei/vte-clear-sdk-class-cache-cli.php ]]; then
	php8.3 /var/www/html/server-ops/mypantarei/vte-clear-sdk-class-cache-cli.php "${VTE_ROOT}" 2>/dev/null || true
fi

echo ""
echo "Fatto. Verifica:"
echo "  1) Logout/login — logo e colore login"
echo "  2) Impostazioni > Logo e sfondi"
echo "  3) Impostazioni > Dati società (correggere se ancora placeholder Acme)"
echo "  4) php8.3 mtm-verify-branding-cli.php ${VTE_ROOT}"
