
#!/bin/bash 


if [[ $1 == ""  ]] ;  then
echo "=-=-=-=-=-=-=-=-=-=-=-=-=-=-"
echo "Welcome to Hard Disk Related Part"
echo "Possible options are:"
echo "--------------------"
echo -e "\e[33m----------\e[0m"
echo -e "\e[32mbackup-check \e[0m" - compare backup of users
echo -e "\e[31mexample: 112h backup-check  \e[0m"
echo -e "\e[33m----------\e[0m"
echo -e "\e[32mbackup-cur \e[0m" - create backup of public_html of current user
echo -e "\e[31mexample: 112h backup-cur COMMENT  \e[0m"
echo -e "\e[31mWithout comment: magnusis-public_html-from-08.04.2016-keep-until-11.04.2016-/ \e[0m"
echo -e "\e[31mWith comment:  magnusis-public_html-from-08.04.2016-keep-until-11.04.2016-pavlin_ala-Bala/ \e[0m"
echo -e "\e[33m----------\e[0m"
echo -e "\e[32minodes \e[0m" - count inodes in current directory
echo -e "\e[31mexample: 112h inodes  \e[0m"
echo -e "\e[33m----------\e[0m"
echo -e "\e[32mdbsize \e[0m" - check mysql databases larger than 500M
echo -e "\e[31mexample: 112h dbsize  \e[0m"
echo -e "\e[33m----------\e[0m"
echo -e "\e[32mcheckdb \e[0m" - check mysql databases 
echo -e "\e[31mexample: 112h checkdb  \e[0m"
echo -e "\e[33m----------\e[0m"
echo -e "\e[32mhdd-h \e[0m" - search of account disk usage in archives
echo -e "\e[31mexample: 112h hdd-h aggresol\e[0m"
echo -e "\e[33m----------\e[0m"
echo "Have a nice work"
echo ""
fi


#=====backup check part===

ACUSER=`cat /etc/backup/lists/active_users_home | wc -l `
LBACKUPDATE=`date -dlast-saturday +%d_%b_%Y | sed 's/^0//g'` 
BCKUSER=`cat /var/log/backup/home-backup-log_$LBACKUPDATE.log | grep "Finished rsync for home folder of user" | awk '{print $14}' | wc -l `

if [[ $1 == "backup-check"  ]] ;  then

if [[ $ACUSER = $BCKUSER ]]
then
echo "OK ! All accounts that are in active list have backup"
else
echo -e "\e[31mWARNING NOT OK!\e[0m Please check it manualy"
echo -e "The accounts from active list is: \e[31m $ACUSER \e[0m"
echo -e "The accounts that have backup is: \e[31m $BCKUSER \e[0m"

fi

fi


#find inodes in current folder 

if [[ $1 == "inodes"  ]] ;  then
echo "Detailed Inode usage for: $(pwd)" ; for d in `find -maxdepth 1 -type d |cut -d\/ -f2 |grep -xv . |sort`; do c=$(find $d |wc -l) ; printf "$c\t\t- $d\n" ; done ; printf "Total: \t\t$(find $(pwd) | wc -l)\n"
fi

#find large db

if [[ $1 == "dbsize"  ]] ;  then
/etc/scripts/mysql_db_size/dbcheck.sh
fi


#find account hdd space 

if [[ $1 == "hdd-h"  ]] ;  then
echo ""
echo "---------------------------------------------info for $2---------------------------------------------"
grep $2 /etc/scripts/hdd_size/home/*   | sed -e 's/du-home.//g' -e 's/\.log:/ - /g'
echo "---------------------------------------------end---------------------------------------------"
echo ""
fi


#backup
PATHCHECK=$(pwd | awk -F"/" '{print $2}')
FDATE=`date --date='3 day' +"%d.%m.%Y"`
NDATE=`date  +"%d.%m.%Y"`

if [[ $1 == "backup-cur"  ]] && [[ "$PATHCHECK" == "home" ]] ;  then


USERNAME=$(pwd | awk -F"/" '{print $3}')


#PATH2=/home/$USERNAME/public_html/
mkdir -p /home/BACKUP/$USERNAME-public_html-from-$NDATE-keep-until-$FDATE-$2

rsync  -avHr /home/$USERNAME/public_html* /home/BACKUP/$USERNAME-public_html-from-$NDATE-keep-until-$FDATE-$2/

else 
echo ""
fi

#find single dbs ize 

if [[ $1 == "checkdb"  ]] ;  then

mysql -e "SELECT table_schema AS \"Database\", ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS \"Size (MB)\" FROM information_schema.TABLES WHERE table_schema = \"$2\" GROUP BY table_schema;"
fi