#!/bin/bash

PROJECT_NAME=$1

### BACKUP PROD DATABASE ###

if [ $PROJECT_NAME = 'gqalpha-prod' ]; then
    mysqldump -u root -p'DigitalOcean@4930' zadmin_odm > /var/www/html/db_bk/zadmin_odm.sql
    cd /var/www/html/db_bk/
    zip zadmin_odm.sql.zip zadmin_odm.sql
    rm zadmin_odm.sql

    mysqldump -u root -p'DigitalOcean@4930' mts_smartturn > /var/www/html/db_bk/mts_smartturn.sql
    cd /var/www/html/db_bk/
    zip mts_smartturn.sql.zip mts_smartturn.sql
    rm mts_smartturn.sql
    php /var/www/html/backup-file-upload-script.php
fi

if [ $PROJECT_NAME = 'senda-prod' ]; then
    mysqldump -u root -p'DigitalOcean@4930' zadmin_odm > /var/www/html/db_bk/zadmin_odm.sql
    cd /var/www/html/db_bk/
    zip zadmin_odm.sql.zip zadmin_odm.sql
    rm zadmin_odm.sql

    mysqldump -u root -p'DigitalOcean@4930' mts_smartturn > /var/www/html/db_bk/mts_smartturn.sql
    cd /var/www/html/db_bk/
    zip mts_smartturn.sql.zip mts_smartturn.sql
    rm mts_smartturn.sql
    php /var/www/html/backup-file-upload-script.php
fi




### BACKUP LOCAL DATABASE ###

if [ $PROJECT_NAME = 'gqalpha-local' ]; then
    mysqldump -u root -p'Root@1234' gq_alpha_zadmin_odm > /var/www/html/db_bk/gq_alpha_zadmin_odm.sql
    cd /var/www/html/db_bk/
    zip gq_alpha_zadmin_odm.sql.zip gq_alpha_zadmin_odm.sql
    rm gq_alpha_zadmin_odm.sql

    mysqldump -u root -p'Root@1234' gq_alpha_zadmin_smartturn > /var/www/html/db_bk/gq_alpha_zadmin_smartturn.sql
    cd /var/www/html/db_bk/
    zip gq_alpha_zadmin_smartturn.sql.zip gq_alpha_zadmin_smartturn.sql
    rm gq_alpha_zadmin_smartturn.sql
    php /var/www/html/db_bk/backup-file-upload-script.php
fi

if [ $PROJECT_NAME = 'senda-local' ]; then
    mysqldump -u root -p'Root@1234' senda_zadmin_odm > /var/www/html/db_bk/senda_zadmin_odm.sql
    cd /var/www/html/db_bk/
    zip senda_zadmin_odm.sql.zip senda_zadmin_odm.sql
    rm senda_zadmin_odm.sql

    mysqldump -u root -p'Root@1234' senda_zadmin_smartturn > /var/www/html/db_bk/senda_zadmin_smartturn.sql
    cd /var/www/html/db_bk/
    zip senda_zadmin_smartturn.sql.zip senda_zadmin_smartturn.sql
    rm senda_zadmin_smartturn.sql
fi


if [ $PROJECT_NAME = 'backup-cron-prod' ]; then
    crontab -l > /var/www/html/crontab-backup/crontab_backup_$(date +%F).txt
    find /var/www/html/crontab-backup/ -type f -name "crontab_backup_*.txt" -mtime +7 -exec rm {} \;
fi