#!/bin/bash
# ==============================================================================
# INSTALADOR SHEYWISP V7 PRO + PHPMYADMIN + PLANTILLA (DB.SQL)
# ==============================================================================

DB_NAME="mikrowisp6"
DB_USER="root"
DB_PASS="manuel29"
URL_SISTEMA="https://peniel-wifi.com/sheyisp_master.zip"
URL_DB="https://peniel-wifi.com/db.sql"

VERDE="\e[32m"
ROJO="\e[31m"
AMARILLO="\e[33m"
RESET="\e[0m"

clear
echo -e "${VERDE}======================================================${RESET}"
echo -e "${VERDE}   INICIANDO INSTALACIÓN MAESTRA V6 (FULL AUTOMÁTICO) ${RESET}"
echo -e "${VERDE}======================================================${RESET}"
sleep 2

echo -e "${AMARILLO}[1/7] Instalando dependencias base...${RESET}"
apt-get update -q && apt-get install apache2 mariadb-server mariadb-client unzip curl wget snmp php libapache2-mod-php php-mysql php-snmp php-curl php-mbstring php-xml php-gd php-zip php-json -y -q

echo -e "${AMARILLO}[2/7] Configurando MariaDB...${RESET}"
systemctl start mariadb
systemctl enable mariadb

MYSQL_CMD="mysql -u root -p${DB_PASS}"
if ! $MYSQL_CMD -e "SELECT 1;" >/dev/null 2>&1; then
    MYSQL_CMD="mysql"
fi

$MYSQL_CMD -e "CREATE DATABASE IF NOT EXISTS ${DB_NAME};"
$MYSQL_CMD -e "ALTER USER '${DB_USER}'@'localhost' IDENTIFIED VIA mysql_native_password USING PASSWORD('${DB_PASS}');"
$MYSQL_CMD -e "GRANT ALL PRIVILEGES ON *.* TO '${DB_USER}'@'localhost' WITH GRANT OPTION;"
$MYSQL_CMD -e "FLUSH PRIVILEGES;"

echo -e "${AMARILLO}[3/7] Descargando y extrayendo sistema web (ZIP)...${RESET}"
rm -rf /var/www/html/*
wget -q --show-progress -O /tmp/sheyisp.zip "${URL_SISTEMA}"

if unzip -t /tmp/sheyisp.zip >/dev/null 2>&1; then
    # AQUÍ ESTÁ LA CORRECCIÓN: Se quitó el -q problemático al final
    unzip -o /tmp/sheyisp.zip -d /var/www/html/
    rm /tmp/sheyisp.zip
    echo -e "${VERDE}Sistema extraído correctamente.${RESET}"
else
    echo -e "${ROJO}ERROR FATAL: El ZIP del sistema no se pudo descargar o está corrupto.${RESET}"
    exit 1
fi

echo -e "${AMARILLO}[4/7] Importando base de datos (db.sql)...${RESET}"
wget -q --show-progress -O /tmp/db.sql "${URL_DB}"
if [ -s /tmp/db.sql ]; then
    mysql -u${DB_USER} -p${DB_PASS} ${DB_NAME} < /tmp/db.sql
    rm /tmp/db.sql
    echo -e "${VERDE}Base de datos inyectada con éxito.${RESET}"
else
    echo -e "${ROJO}Aviso: No se pudo descargar db.sql desde el hosting.${RESET}"
fi

echo -e "${AMARILLO}[5/7] Instalando phpMyAdmin...${RESET}"
wget -q -O /tmp/pma.zip https://www.phpmyadmin.net/downloads/phpMyAdmin-latest-all-languages.zip
unzip -q /tmp/pma.zip -d /var/www/html/
mv /var/www/html/phpMyAdmin-*-all-languages /var/www/html/phpmyadmin
rm /tmp/pma.zip
echo -e "${VERDE}phpMyAdmin listo.${RESET}"

echo -e "${AMARILLO}[6/7] Ajustando permisos globales...${RESET}"
chown -R www-data:www-data /var/www/html/
chmod -R 755 /var/www/html/

echo -e "${AMARILLO}[7/7] Configurando Cron de la OLT...${RESET}"
crontab -l | grep -v 'cron_ont_autorizadas.php' | crontab -
(crontab -l 2>/dev/null; echo "*/5 * * * * /usr/bin/php /var/www/html/admin/onu/cron_ont_autorizadas.php > /dev/null 2>&1") | crontab -

systemctl restart apache2

echo -e "${VERDE}======================================================${RESET}"
echo -e "${VERDE} ¡INSTALACIÓN TOTAL COMPLETADA CON ÉXITO! 🚀          ${RESET}"
echo -e "${VERDE}======================================================${RESET}"
echo -e "Sistema:     http://$(hostname -I | awk '{print $1}')/admin"
echo -e "phpMyAdmin:  http://$(hostname -I | awk '{print $1}')/phpmyadmin"
echo -e "======================================================"