#!Important: Make sure that the file format is LF in stead of CRLF, otherwise it goes wrong
# You can run this, by executing the script: 
# cd /home/obos/docker/sponsorkliks_mysql/transactions && /bin/bash sync.sh >> "./storage/log/sync.sh_log_$(date +\%F_\%H-\%M-\%S.txt)" 2>&1 && find ./storage/log/sync.sh_log_* -maxdepth 0 -type f -mtime +30 -delete
#!/bin/bash

php -q log.php "INFO" "transaction/sync.sh" "Starting ..." "T01"

php -q log.php "INFO" "transaction/sync.sh" "Collecting transaction from the last day ..." "T02"

php get.php -v --history=1

php -q log.php "INFO" "transaction/sync.sh" "Collecting transactions and create insert.sql script ..." "T03"

php insert.php > insert.sql

php -q log.php "INFO" "transaction/sync.sh" "Executing insert.sql script ..." "T04"

docker exec -i sponsorkliks_mysql mysql -uroot -pXCEgYzPp4BBAw4 -f sponsorkliks < insert.sql

php -q log.php "INFO" "transaction/sync.sh" "Completed executing insert.sql script!" "T05"

php -q log.php "INFO" "transaction/sync.sh" "Collecting transactions and create update.sql script ..." "T06"

php update.php > update.sql

php -q log.php "INFO" "transaction/sync.sh" "Executing update.sql script ..." "T07"

docker exec -i sponsorkliks_mysql mysql -uroot -pXCEgYzPp4BBAw4 -f sponsorkliks < update.sql

php -q log.php "INFO" "transaction/sync.sh" "Completed executing insert.sql script!" "T08"

php -q log.php "INFO" "transaction/sync.sh" "Collecting transactions and create update_awin.sql script ..." "T09"

php update_awin.php > update_awin.sql

php -q log.php "INFO" "transaction/sync.sh" "Executing update_awin.sql script ..." "T10"

docker exec -i sponsorkliks_mysql mysql -uroot -pXCEgYzPp4BBAw4 -f sponsorkliks < update_awin.sql

php -q log.php "INFO" "transaction/sync.sh" "Completed executing update_awin.sql script!" "T11"

php -q log.php "INFO" "transaction/sync.sh" "Collecting transactions and create updates.sql script ..." "T12"

php updates.php > updates.sql

php -q log.php "INFO" "transaction/sync.sh" "Executing updates.sql script ..." "T13"

docker exec -i sponsorkliks_mysql mysql -uroot -pXCEgYzPp4BBAw4 -f sponsorkliks < updates.sql

php -q log.php "INFO" "transaction/sync.sh" "Completed executing updates.sql script!" "T14"

php -q log.php "INFO" "transaction/sync.sh" "Collecting transactions and create export.sql script ..." "T15"

php export.php

php -q log.php "INFO" "transaction/sync.sh" "Executing export.sql script ..." "T16"

# two step export
docker exec -i sponsorkliks_mysql mysql -uroot -pXCEgYzPp4BBAw4 -f sponsorkliks < export.sql

php -q log.php "INFO" "transaction/sync.sh" "Completed executing export.sql script!" "T17"

php -q log.php "INFO" "transaction/sync.sh" "Exporting log_all_sales_new data to log_all_sales_new.sql ..." "T18"

docker exec -i sponsorkliks_mysql mysqldump --extended-insert=FALSE -uroot -pXCEgYzPp4BBAw4 --opt sponsorkliks log_all_sales_new > /home/obos/docker/sponsorkliks_mysql/transactions/log_all_sales_new.sql

php -q log.php "INFO" "transaction/sync.sh" "Completed exporting data to log_all_sales_new.sql script!" "T19"

php -q log.php "INFO" "transaction/sync.sh" "Executing log_all_sales_new.sql script to DB01 ..." "T20"

mysql -unetural -hdb01.server.sponsorkliks.com -P3306 -p10T@lpa2005 -Dsponsorkliks < log_all_sales_new.sql

php -q log.php "INFO" "transaction/sync.sh" "Executing fix.sql script to DB01 ..." "T21"

mysql -unetural -hdb01.server.sponsorkliks.com -P3306 -p10T@lpa2005 -Dsponsorkliks < fix.sql

# Fase 5: zet op 0 na 3 groene schaduwnachten (zie cronjobs.sh)
FASE5_PAYFACTOR_RECALC=1

if [ "$FASE5_PAYFACTOR_RECALC" = "1" ]; then
  php -q log.php "INFO" "transaction/sync.sh" "Generating update_pay_factor_web03.sql from DB01 ..." "T21A"

  mysql -N -unetural -hdb01.server.sponsorkliks.com -P3306 -p10T@lpa2005 -Dsponsorkliks < update_pay_factor.sql > update_pay_factor_web03.sql

  php -q log.php "INFO" "transaction/sync.sh" "Executing update_pay_factor_web03.sql script to WEB03 ..." "T21B"

  mysql -uroot -hweb03.server.sponsorkliks.com -P3307 -pXCEgYzPp4BBAw4 -Dsponsorkliks < update_pay_factor_web03.sql
else
  php -q log.php "INFO" "transaction/sync.sh" "Fase 5: payfactor-herberekening OVERGESLAGEN ..." "T21F"
fi

php -q log.php "INFO" "transaction/sync.sh" "Generating update_payout_date_web03.sql from DB01 ..." "T21C"

mysql -N -unetural -hdb01.server.sponsorkliks.com -P3306 -p10T@lpa2005 -Dsponsorkliks < update_payout_date.sql > update_payout_date_web03.sql

php -q log.php "INFO" "transaction/sync.sh" "Executing update_payout_date_web03.sql script to WEB03 ..." "T21D"

mysql -uroot -hweb03.server.sponsorkliks.com -P3307 -pXCEgYzPp4BBAw4 -Dsponsorkliks < update_payout_date_web03.sql

php -q log.php "INFO" "transaction/sync.sh" "Running cronjob_v2.php on the web01 ..." "T22"

# We run the web01 script directly, so it can be processed directly after the updates
/usr/bin/wget -O /dev/null -q --tries=1 --no-check-certificate http://www.sponsorkliks.com/sync/cronjob_v2.php?_SPK_API_CRONJOB_KEY=dhKsnnbxc38sh774KKj411kAz12

php -q log.php "INFO" "transaction/sync.sh" "Running cronjob_v2.php completed on the web01, but now we wait 2 minutes to do the follow up!" "T23"

sleep 2m

php -q log.php "INFO" "transaction/sync.sh" "Renaming log_all_sales_new to log_all_sales ..." "T24"

mysql -unetural -hdb01.server.sponsorkliks.com -P3306 -p10T@lpa2005 -Dsponsorkliks < export_swap.sql

php -q log.php "INFO" "transaction/sync.sh" "MySQL WEB02 (Importing) ..." "T25"

# dynamic banner
mysql -uroot -hweb02.server.sponsorkliks.com -P3306 -pXCEgYzPp4BBAw4 -Dsponsorkliks < log_all_sales_new.sql
mysql -uroot -hweb02.server.sponsorkliks.com -P3306 -pXCEgYzPp4BBAw4 -Dsponsorkliks < fix.sql

php -q log.php "INFO" "transaction/sync.sh" "Cleaning Up ..." "T26"

# get.php
rm storage/*_requests_*

php -q log.php "INFO" "transaction/sync.sh" "Ready!" "T27"