#!/bin/bash
########################################################################################
#	Este programa tem a funcao de obter informacoes sobre o edirectory automaticamente
#	Rafael Carreiro
#	rafael.oliveira@arcasolutions.com
#	https://netuno.arcasolutions.com/rafael.oliveira/v11-tools
#	obter_info_projeto.sh
########################################################################################
#
# Modo de usar
#
# Com o usuario do cliente, na pasta raiz do projeto, execute a seguinte linha de comando:
# wget https://s3-sa-east-1.amazonaws.com/upgradev11/scripts/obter_info_projeto.sh ; chmod +x obter_info_projeto.sh ; ./obter_info_projeto.sh
# Agora apenas confirme que esta no local correto e sera apresentado as informacoes relevantes

main() {
    clear
    if [[ `pwd` = "$HOME/edirectory" ]]; then
        EDIR11_ROOT=`pwd`
        obter_info
    elif [[ `pwd` = "$HOME/public_html" ]]; then
         EDIR_ROOT=`pwd`
         obter_info
    else
        exit
fi

}

obter_info() {
	clear 

	if [[ `pwd` = "$EDIR_ROOT" ]]; then

		cat /dev/null > info_direto
		echo -e "--------------------------------------------------" >> info_direto 
		echo -e "\t\tV11-tools - Obter informacoes sobre o projeto" >> info_direto 
		echo -e "--------------------------------------------------" >> info_direto 

		EDIR_VERSION=`grep -E "define\(\"VERSION\"\,\ \"" $EDIR_ROOT/conf/constants.inc.php | cut -f2,3 -d "."`
			echo -e "\nVersao atual\t\t: $EDIR_VERSION" >> info_direto
		PREFIX=`grep -E "define\(\"DB_NAME_PREFIX\"\," $EDIR_ROOT/conf/config.inc.php | cut -f4 -d '"'`
			echo -e "Prefix\t\t\t: $PREFIX" >> info_direto
		IP_DB_HOST=`grep -E "define\(\"_DIRECTORYDB_HOST\"\," $EDIR_ROOT/conf/config.inc.php | cut -f4 -d '"'`
			echo -e "IP MySQL\t\t: $IP_DB_HOST" >> info_direto
		DB_USER=`grep -E "define\(\"_DIRECTORYDB_USER\"\," $EDIR_ROOT/conf/config.inc.php | cut -f4 -d '"'`
			echo -e "Usuario do MySQL\t: $DB_USER" >> info_direto
		DB_PASS=`grep -E "define\(\"_DIRECTORYDB_PASS\"\," $EDIR_ROOT/conf/config.inc.php  | cut -f4 -d '"'`
			echo -e "Senha do MySQL\t\t: $DB_PASS" >> info_direto
		DB_MAIN_NAME=`grep -E "define\(\"_DIRECTORYDB_NAME\"\," $EDIR_ROOT/conf/config.inc.php | cut -f4 -d '"'`
			echo -e "Database main\t\t: $DB_MAIN_NAME" >> info_direto
		PROJDOMAIN1=`grep -E "domainInfo\[" $EDIR_ROOT/custom/domain/domain.inc.php | cut -f2 -d '"'`
			echo -e "\n--------------------------------------------------\nDominio(os)\t\t\n--------------------------------------------------\n $PROJDOMAIN1" >> info_direto
		DB_DOMAIN1=`mysql -u$DB_USER -p$DB_PASS -e "use $DB_MAIN_NAME ; select database_name from Domain;" | grep "domain"`
			echo -e "\n--------------------------------------------------\nDatabase(s) Domain(s)\n--------------------------------------------------\n $DB_DOMAIN1" >> info_direto
			echo -e "--------------------------------------------------\n\n" >> info_direto 

		sed 's/^[ \t]*/        /' info_direto
		mysql -u$DB_USER -p$DB_PASS -e "use $DB_MAIN_NAME; select id, database_name, url, activation_status from Domain;"


	elif [[ `pwd` = "$EDIR11_ROOT" ]]; then
		cat /dev/null > info_direto
		echo -e "--------------------------------------------------" >> info_direto 
		echo -e "\t\tV11-tools - Obter informacoes sobre o projeto" >> info_direto 
		echo -e "--------------------------------------------------" >> info_direto 
		#$EDIR11_ROOT/src/ArcaSolutions/CoreBundle/Kernel/Kernel.php
		#const VERSION = '11.0.05';
		EDIR_VERSION=`grep -E "define\(\"VERSION\"\,\ \"" $EDIR11_ROOT/web/conf/constants.inc.php | cut -f2,3 -d "."`
			echo -e "\nVersao atual\t\t: $EDIR_VERSION" >> info_direto
		PREFIX=`grep -E "define\(\"DB_NAME_PREFIX\"\," $EDIR11_ROOT/web/conf/config.inc.php | cut -f4 -d '"'`
			echo -e "Prefix\t\t\t: $PREFIX" >> info_direto
		IP_DB_HOST=`grep -E "define\(\"_DIRECTORYDB_HOST\"\," $EDIR11_ROOT/web/conf/config.inc.php | cut -f4 -d '"'`
			echo -e "IP MySQL\t\t: $IP_DB_HOST" >> info_direto
		DB_USER=`grep -E "define\(\"_DIRECTORYDB_USER\"\," $EDIR11_ROOT/web/conf/config.inc.php | cut -f4 -d '"'`
			echo -e "Usuario do MySQL\t: $DB_USER" >> info_direto
		DB_PASS=`grep -E "define\(\"_DIRECTORYDB_PASS\"\," $EDIR11_ROOT/web/conf/config.inc.php | cut -f4 -d '"'`
			echo -e "Senha do MySQL\t\t: $DB_PASS" >> info_direto
		DB_MAIN_NAME=`grep -E "define\(\"_DIRECTORYDB_NAME\"\," $EDIR11_ROOT/web/conf/config.inc.php | cut -f4 -d '"'`
			echo -e "Database main\t\t: $DB_MAIN_NAME" >> info_direto
		PROJDOMAIN1=`grep -E "domainInfo\[" $EDIR11_ROOT/web/custom/domain/domain.inc.php | cut -f2 -d '"'`
			echo -e "\n--------------------------------------------------\nDominio(os)\t\t\n--------------------------------------------------\n $PROJDOMAIN1" >> info_direto
		DB_DOMAIN1=`mysql -u$DB_USER -p$DB_PASS -e "use $DB_MAIN_NAME ; select database_name from Domain;" | grep "domain"` ##Mostrar tambem a url na frente utilizando ER no grep para pegar .com, .br, com.au, .co.uk, etc
			echo -e "\n--------------------------------------------------\nDatabase(s) Domain(s)\n--------------------------------------------------\n $DB_DOMAIN1" >> info_direto
		
		echo -e "\n--------------------------------------------------" >> info_direto 
		echo -e "Dados do app/config/parameters.yml" >> info_direto 		
		echo -e "--------------------------------------------------" >> info_direto 

		echo -e "database_host\t\t: $(grep -E "database_host" app/config/parameters.yml | cut -f2 -d ":")">> info_direto
		echo -e "database_name\t\t: $(grep -E "database_name" app/config/parameters.yml | cut -f2 -d ":")" >> info_direto
		echo -e "database_user\t\t: $(grep -E "database_user" app/config/parameters.yml | cut -f2 -d ":")" >> info_direto
		echo -e "database_password\t: $(grep -E "database_password" app/config/parameters.yml | cut -f2 -d ":")" >> info_direto
		echo -e "elastic_host\t\t: $(grep -E "elastic_host" app/config/parameters.yml | cut -f2 -d ":")" >> info_direto
		echo -e "elastic_port\t\t: $(grep -E "elastic_port" app/config/parameters.yml | cut -f2 -d ":")" >> info_direto

		echo -e "\n--------------------------------------------------" >> info_direto 
		echo -e "Arquivos na pasta app/config/domains" >> info_direto 		
		echo -e "--------------------------------------------------" >> info_direto 

		ls $EDIR11_ROOT/app/config/domains/  >> info_direto

		echo -e "\n--------------------------------------------------" >> info_direto 
		echo -e "\t\tDados do app/config/domain.yml" >> info_direto 
		echo -e "--------------------------------------------------" >> info_direto 
		cat $EDIR11_ROOT/app/config/domain.yml >> info_direto
		echo -e "\n--------------------------------------------------\n\n" >> info_direto 

		sed 's/^[ \t]*/        /' info_direto
		mysql -u$DB_USER -p$DB_PASS -e "use $DB_MAIN_NAME; select id, database_name, url, activation_status from Domain;"

	else
		main
	fi
}

main