#!/bin/bash
#!/usr/bin/php

# Leer credenciales del .env de Laravel
ENV_FILE="/home/forge/taxes.com.ar/.env"
DB_USER=$(grep "^DB_USERNAME=" "$ENV_FILE" | cut -d '=' -f2)
DB_PASS=$(grep "^DB_PASSWORD=" "$ENV_FILE" | cut -d '=' -f2)

#variables
#DIA_ACTUAL=`date +%a`
#FECHA_ACTUAL=`date +%Y-%m-%d`
#HORA_ACTUAL=`date +%H-%M`

#nombre del archivo
#ARCH_RESP="$FECHA_ACTUAL-$HORA_ACTUAL"

#DIRECTORIO DE RESPALDO
#DIR_RESP="/var/www/respaldos"

SV_ARRAY=('localhost')
U_ARRAY=("$DB_USER")
C_ARRAY=("$DB_PASS")
BD_ARRAY=('dbtaxes')

#VARIABLES DEL SCRIPT
index=0
count="${#SV_ARRAY[*]}"


##CREAR EL DIRECTORIO DE RESPALDO PARA LA FECHA ACTUAL
#if [ ! -d $ARCH_RESP ];
#then echo -n "Creando directorio de respaldo DIR_RESP/$ARCH_RESP "
#     mkdir $DIR_RESP/$ARCH_RESP ] && continue
#     echo "done."
#fi


while [ $index -lt $count ];
	do
#contraseña de mysql
export USER=${U_ARRAY[$index]-i}
export MYSQL_PWD=${C_ARRAY[$index]-i}

#echo 'Servidor: '${SV_ARRAY[$index]-i}'---usuario: '$MYUSER'---clave: '$MYPASSWORD
echo 'conectando a-->'${SV_ARRAY[$index]-i}'<....'

# Realizar Backup de las DB'S
basedatos=$(mysql -u ${U_ARRAY[$index]-i} -h ${SV_ARRAY[$index]-i} -se "select distinct p.document from user_persons up join tusers u on up.user_id = u.iduser and u.user_type_id = 1 join persons p on up.person_id = p.id where up.parent_person_id is null;" -D ${BD_ARRAY[$index]-i} -N)

	#echo "las bases de datos madres: ${basedatos}";

		for d in $basedatos;
		   do
            #php session_vars.php "bd=${d}"
		    php artisan2.php migrate:rollback "--db=${d}"

		   done

    unset USER
    unset MYSQL_PWD

	##i=$((i+1))
	let "index = $index + 1"

done