
#!/bin/bash 


TMPDIR=/etc/scripts/hdd_peruser/tmp
TMPFILE=$TMPDIR/tmpcalc.du
repquota /home| awk '{print $3/1024/1024,$1}' | egrep -v "(\#|\*|-|Block|User)" | grep -v "\#" > $TMPFILE


##
# accouts <= 2G
for i in `cat /etc/backup/lists/active_users_home ` ; do grep -w $i $TMPFILE | egrep -v  "(_|-)" | sed 's/\/home\///g' ; done  |  awk '{if ($1 <= 2  ) print $1,$2}' | grep -v "\#" > $TMPDIR/2GB
##
# accouts > 2G <= 5G
for i in `cat /etc/backup/lists/active_users_home ` ; do grep -w $i $TMPFILE | egrep -v  "(_|-)" | sed 's/\/home\///g' ; done  |  awk '{if ($1 > 2 && $1 <= 5) print $1,$2}' | grep -v "\#" > $TMPDIR/2-5GB
##
# accouts > 5G <= 10G
for i in `cat /etc/backup/lists/active_users_home ` ; do grep -w $i $TMPFILE | egrep -v  "(_|-)" | sed 's/\/home\///g' ; done  |  awk '{if ($1 > 5 && $1 <= 10) print $1,$2}' | grep -v "\#" > $TMPDIR/5-10GB
##
# accouts > 10G 
for i in `cat /etc/backup/lists/active_users_home ` ; do grep -w $i $TMPFILE | egrep -v  "(_|-)" | sed 's/\/home\///g' ; done  |  awk '{if ($1 > 10 ) print $1,$2}' | grep -v "\#" > $TMPDIR/a10GB
##
# accouts < 10G
for i in `cat /etc/backup/lists/active_users_home ` ; do grep -w $i $TMPFILE | egrep -v  "(_|-)" | sed 's/\/home\///g' ; done  |  awk '{if ($1 <= 10 ) print $1,$2}' | grep -v "\#" > $TMPDIR/b10GB
##


##
# per package
##
echo "All Acount per package"
for i in `cat /etc/backup/lists/active_users_home ` ; do  egrep "(PLAN)" /var/cpanel/users/$i ; done  | sort -n | uniq -c | sort -n |  egrep -w "(tmdhosting_unlimited|tmdhosting)" 

echo "----------------------------------"

##
echo "Acount <= 2GB per package"
for i in `cat $TMPDIR/2GB | awk '{print $2}'` ; do  egrep "(PLAN)" /var/cpanel/users/$i ; done  | sort -n | uniq -c | sort -n |  egrep -w "(tmdhosting_unlimited|tmdhosting)" 
echo "----------------------------------"

echo "Acount > 2GB <= 5GB per package"
for i in `cat $TMPDIR/2-5GB | awk '{print $2}'` ; do  egrep "(PLAN)" /var/cpanel/users/$i ; done  | sort -n | uniq -c | sort -n |  egrep -w "(tmdhosting_unlimited|tmdhosting)" 
echo "----------------------------------"

echo "Acount > 5GB <= 10GB per package"
for i in `cat $TMPDIR/5-10GB | awk '{print $2}'` ; do  egrep "(PLAN)" /var/cpanel/users/$i ; done  | sort -n | uniq -c | sort -n |  egrep -w "(tmdhosting_unlimited|tmdhosting)" 
echo "----------------------------------"

echo "Acount > 10GB per package"
for i in `cat $TMPDIR/a10GB | awk '{print $2}'` ; do  egrep "(PLAN)" /var/cpanel/users/$i ; done  | sort -n | uniq -c | sort -n  |  egrep -w "(tmdhosting_unlimited|tmdhosting)" 
echo "----------------------------------"

echo "Acount < 10GB per package"
for i in `cat $TMPDIR/b10GB | awk '{print $2}'` ; do  egrep "(PLAN)" /var/cpanel/users/$i ; done  | sort -n | uniq -c | sort -n |  egrep -w "(tmdhosting_unlimited|tmdhosting)"  
echo "----------------------------------"

echo "All active accounts on server:"
wc -l /etc/backup/lists/active_users_home  | awk '{print $1}'

echo "Acount <= 2GB per clients"
echo $(wc -l $TMPDIR/2GB | awk '{print $1}') 
echo "----------------------------------"
echo "Acount > 2GB <= 5GB per clients"
echo $(wc -l $TMPDIR/2-5GB | awk '{print $1}') 
echo "----------------------------------"
echo "Acount > 5GB <= 10GB per clients"
echo $(wc -l $TMPDIR/5-10GB | awk '{print $1}') 
echo "----------------------------------"
echo "Acount > 10GB per clients"
echo $(wc -l $TMPDIR/a10GB | awk '{print $1}') 
echo "----------------------------------"
echo "Acount < 10GB per clients"
echo $(wc -l $TMPDIR/b10GB | awk '{print $1}') 
echo "----------------------------------"

echo "Acount < 10GB average hdd usage per amazing "
ALLCALCS=$(cat $TMPDIR/b10GB)
for i in `grep -w "PLAN=tmdhosting" /var/cpanel/users/* -l  | awk -F"/" '{print $5}' `   ; do echo "$ALLCALCS" | grep -w $i ; done  | awk '{print $1}' | awk  '{sum+=$1} END {print "Average usage of users that use below 10G  of HDD Amazing:", sum/NR}'

echo "Acount < 10GB average hdd usage per unlimited "
for i in `grep -w "PLAN=tmdhosting_unlimited" /var/cpanel/users/* -l  | awk -F"/" '{print $5}' `   ; do echo "$ALLCALCS" | grep -w $i ; done  | awk '{print $1}' | awk  '{sum+=$1} END {print "Average usage of users that use below 10G  of HDD Unlimited:", sum/NR}'


cat $TMPDIR/2GB | awk '{print $1}' | awk '{ sum+=$1} END {print "Sum of all 2GB users  " sum " GB"}'
cat $TMPDIR/2-5GB | awk '{print $1}' | awk '{ sum+=$1} END {print "Sum of all 2-5GB users  " sum " GB"}'
cat $TMPDIR/5-10GB | awk '{print $1}' | awk '{ sum+=$1} END {print "Sum of all 5-10 GB users  " sum " GB"}'
cat $TMPDIR/a10GB | awk '{print $1}' | awk '{ sum+=$1} END {print "Sum of all above 10 GB users  " sum " GB"}'
cat $TMPDIR/b10GB | awk '{print $1}' | awk '{ sum+=$1} END {print "Sum of all below 10 GB users  " sum " GB"}'
cat $TMPDIR/2-5GB   $TMPDIR/5-10GB  $TMPDIR/a10GB  $TMPDIR/2GB | awk '{print $1}' | awk '{ sum+=$1} END {print "Sum of all users  " sum " GB"}'


rm -f /etc/scripts/hdd_peruser/tmp/*