#!/bin/bash
# Post-import su istanza MTM PRODUZIONE (dopo upload pacchetto mtm-config-26)
#
# 1) Estrae branding in VTE root
# 2) Import SQL theme + sdk (opzionale, dopo backup)
# 3) Estrae EventiMacchine-extra in modules/
# 4) Clear cache SDK
#
# Uso:
#   export VTE_ROOT=/var/www/html/crm-mtm
#   export DB_NAME=vte_mtm
#   export DB_USER=...
#   export DB_PASS=...
#   sudo -u www-data bash mtm-import-on-target.sh /path/to/mtm-config-26
#
# SPDX-FileCopyrightText: 2026 Pantarei

set -euo pipefail

PKG_DIR="${1:?Uso: mtm-import-on-target.sh /path/to/mtm-config-26}"
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:-}"

MYSQL=(mysql -u "${DB_USER}")
if [[ -n "${DB_PASS}" ]]; then
	MYSQL+=( -p"${DB_PASS}" )
fi
MYSQL+=( "${DB_NAME}" )

echo "=== MTM import su ${VTE_ROOT} ==="

if [[ -f "${PKG_DIR}/branding/themes/logos/custom/login.png" ]]; then
	mkdir -p "${VTE_ROOT}/themes/logos/custom"
	cp -a "${PKG_DIR}/branding/themes/logos/custom/." "${VTE_ROOT}/themes/logos/custom/"
	echo "OK logo custom"
fi

if [[ -d "${PKG_DIR}/branding/themes/wallpapers" ]]; then
	mkdir -p "${VTE_ROOT}/themes/wallpapers"
	cp -a "${PKG_DIR}/branding/themes/wallpapers/." "${VTE_ROOT}/themes/wallpapers/"
	echo "OK wallpapers"
fi

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

if [[ -f "${PKG_DIR}/sql/mtm-vteprop-theme.sql" ]]; then
	echo "Import vte_vteprop theme.* ..."
	"${MYSQL[@]}" < "${PKG_DIR}/sql/mtm-vteprop-theme.sql"
fi

if [[ -f "${PKG_DIR}/sql/mtm-sdk-config.sql" ]]; then
	echo "Import sdk_language/config ..."
	"${MYSQL[@]}" < "${PKG_DIR}/sql/mtm-sdk-config.sql"
fi

if [[ -f "${PKG_DIR}/modules/EventiMacchine-extra-files.tar.gz" ]]; then
	tar -xzf "${PKG_DIR}/modules/EventiMacchine-extra-files.tar.gz" -C "${VTE_ROOT}/modules"
	echo "OK EventiMacchine extra (modules/)"
	# SQL opzionale JSON constraint
	if [[ -f "${VTE_ROOT}/modules/EventiMacchine/sql/20260317_eventimacchine_json_storage.sql" ]]; then
		echo "Eseguire manualmente se non già applicato:"
		echo "  mysql ... < modules/EventiMacchine/sql/20260317_eventimacchine_json_storage.sql"
	fi
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}" || true
fi

echo ""
echo "Completato. Verificare:"
echo "  - Moduli importati da UI Module Manager (cartella ${PKG_DIR}/modules/*.zip)"
echo "  - Impostazioni > Logo e sfondi"
echo "  - Smoke test Cantieri / EventiMacchine"