#!/bin/bash

cd /home/nawn2219/public_html/transfert_pra

echo $(date +%F-%T)   "***************************************" >> logs/log_`date +%Y%m`.log
echo $(date +%F-%T)   "Restauration sites et bases PRA********" >> logs/log_`date +%Y%m`.log
echo $(date +%F-%T)   "***************************************" >> logs/log_`date +%Y%m`.log

#***************************************************
#********Decompression des archives
#***************************************************
echo $(date +%F-%T)   "Decompression des archives" >> logs/log_`date +%Y%m`.log

cd /home/nawn2219/public_html/transfert_pra/sites
tar -xzvf match.tar.gz --directory /home/nawn2219/public_html/pra_elan_retail/match
echo $(date +%F-%T)   "Archive Match OK" >> /home/nawn2219/public_html/transfert_pra/logs/log_`date +%Y%m`.log
tar -xzvf sfr.tar.gz --directory /home/nawn2219/public_html/pra_elan_retail/sfr
echo $(date +%F-%T)   "Archive SFR OK" >> /home/nawn2219/public_html/transfert_pra/logs/log_`date +%Y%m`.log
tar -xzvf sedadi.tar.gz --directory /home/nawn2219/public_html/pra_elan_retail/sedadi
echo $(date +%F-%T)   "Archive SEDADI OK" >> /home/nawn2219/public_html/transfert_pra/logs/log_`date +%Y%m`.log

tar -xzvf effimaintenance.tar.gz --directory /home/nawn2219/public_html/pra_elan_providers/effimaintenance
echo $(date +%F-%T)   "Archive EFFIMAINTENANCE OK" >> /home/nawn2219/public_html/transfert_pra/logs/log_`date +%Y%m`.log
tar -xzvf europfacilities.tar.gz --directory /home/nawn2219/public_html/pra_elan_providers/europfacilities
echo $(date +%F-%T)   "Archive EUROPFACILITIES OK" >> /home/nawn2219/public_html/transfert_pra/logs/log_`date +%Y%m`.log
tar -xzvf sequoia.tar.gz --directory /home/nawn2219/public_html/pra_elan_providers/sequoia
echo $(date +%F-%T)   "Archive SEQUOIA OK" >> /home/nawn2219/public_html/transfert_pra/logs/log_`date +%Y%m`.log


#***************************************************
#copie des fichiers de configuration .env
#***************************************************

#Etape 1, on copie les fichiers originaux
cp /home/nawn2219/public_html/pra_elan_retail/match/.env /home/nawn2219/public_html/pra_elan_retail/match/.env_original
cp /home/nawn2219/public_html/pra_elan_retail/sfr/.env /home/nawn2219/public_html/pra_elan_retail/sfr/.env_original
cp /home/nawn2219/public_html/pra_elan_retail/sedadi/.env /home/nawn2219/public_html/pra_elan_retail/sedadi/.env_original

cp /home/nawn2219/public_html/pra_elan_providers/effimaintenance/.env /home/nawn2219/public_html/pra_elan_providers/effimaintenance/.env_original
cp /home/nawn2219/public_html/pra_elan_providers/europfacilities/.env /home/nawn2219/public_html/pra_elan_providers/europfacilities/.env_original
cp /home/nawn2219/public_html/pra_elan_providers/sequoia/.env /home/nawn2219/public_html/pra_elan_providers/sequoia/.env_original

#Etape 2, on ecrase les fichiers des sites pour pouvoir tester les PRA
cp /home/nawn2219/public_html/pra_elan_retail/_configs/match/.env /home/nawn2219/public_html/pra_elan_retail/match/.env
cp /home/nawn2219/public_html/pra_elan_retail/_configs/sfr/.env /home/nawn2219/public_html/pra_elan_retail/sfr/.env
cp /home/nawn2219/public_html/pra_elan_retail/_configs/sedadi/.env /home/nawn2219/public_html/pra_elan_retail/sedadi/.env

cp /home/nawn2219/public_html/pra_elan_providers/_configs/effimaintenance/.env /home/nawn2219/public_html/pra_elan_providers/effimaintenance/.env
cp /home/nawn2219/public_html/pra_elan_providers/_configs/europfacilities/.env /home/nawn2219/public_html/pra_elan_providers/europfacilities/.env
cp /home/nawn2219/public_html/pra_elan_providers/_configs/sequoia/.env /home/nawn2219/public_html/pra_elan_providers/sequoia/.env

#***************************************************
#GESTION DES BASES DE DONNEES
#***************************************************

#********Decompression des bases de données
echo $(date +%F-%T)   "Decompression des bases de données" >> /home/nawn2219/public_html/transfert_pra/logs/log_`date +%Y%m`.log

cd /home/nawn2219/public_html/transfert_pra/bases
tar -xzvf `date +%Y%m%d`_20h00.tar.gz

#*******Traitement des bases de données
echo $(date +%F-%T)   "Traitement des bases de données" >> /home/nawn2219/public_html/transfert_pra/logs/log_`date +%Y%m`.log

cd /home/nawn2219/public_html/transfert_pra/bases/`date +%Y%m%d`
mysql --host='localhost' --user='nawn2219_demouser' --password='Faw443wz!30' nawn2219_pra_match< match.sql
mysql --host='localhost' --user='nawn2219_demouser' --password='Faw443wz!30' nawn2219_pra_sfr< sfr.sql
mysql --host='localhost' --user='nawn2219_demouser' --password='Faw443wz!30' nawn2219_pra_sedadi< sedadi.sql

mysql --host='localhost' --user='nawn2219_demouser' --password='Faw443wz!30' nawn2219_pra_effimaintenance< effimaintenance.sql
mysql --host='localhost' --user='nawn2219_demouser' --password='Faw443wz!30' nawn2219_pra_europfacilities< europfacilities.sql
mysql --host='localhost' --user='nawn2219_demouser' --password='Faw443wz!30' nawn2219_pra_sequoia< sequoia.sql

cd ..
rm -r `date +%Y%m%d`

echo $(date +%F-%T)   "*****************FIN traitement ****************" >> /home/nawn2219/public_html/transfert_pra/logs/log_`date +%Y%m`.log