#!/bin/bash
PATH=/usr/bin:/bin:/usr/sbin:/sbin:/usr/bin/X11:/usr/games:/usr/local/bin:/root/bin


TITLE="Euro3G - Riepilogo clienti serviti"

cd /opt/euro-beta

UBUNTU=`lsb_release -a 2>/dev/null | grep -qi "Ubuntu" && echo "1"`

source /opt/euro-beta/set3g_env
if ! which sysquery >/dev/null 2>&1 
then
  PATH=$PATH:/opt/euro-beta
fi
if [ -z "$DISPLAY" ]
then
  export DISPLAY=:0
fi


TTL=`systools/get_eurodb_config_val TimeToLive`


function prep_report()
{
  LSEP="$1"
  CL_DAY=`get_client_stat "DAY" 0`
  CL_LDAY=`get_client_stat "DAY" -1`
  CL_WEEK=`get_client_stat "WEEK" 0`
  CL_LWEEK=`get_client_stat "WEEK" -1`
  CL_MONTH=`get_client_stat "MONTH" 0`
  CL_LMONTH=`get_client_stat "MONTH" -1` 
  CL_YEAR=`get_client_stat "YEAR" 0` 
  CL_LYEAR=`get_client_stat "YEAR" -1` 

  echo -n "Nel giorno attuale         : $CL_DAY"
  echo $LSEP
  echo -n "Nel giorno precedente      : $CL_LDAY"
  echo $LSEP
  echo -n "Nella settimana attuale    : $CL_WEEK"
  echo $LSEP
  echo -n "Nella settimana precedente : $CL_LWEEK"
  echo $LSEP
  echo -n "Nel mese attuale           : $CL_MONTH"
  echo $LSEP
  echo -n "Nel mese precedente        : $CL_LMONTH"
  echo $LSEP
  echo -n "Nell'anno attuale          : $CL_YEAR"
  echo $LSEP
  echo -n "Nell'anno precedente       : $CL_LYEAR"
  echo $LSEP


}

function get_client_stat()
{
  period="$1"
  offset="$2"

#  echo "SELECT IFNULL(SUM(people_nr),0) FROM accounts_test WHERE $period(DATE_ADD(account_close, INTERVAL $TTL DAY))=$period(NOW())+$offset;" | mysql -BN -ueuro3g -peuro3g eurotest
  echo "SELECT IFNULL(SUM(people_nr),0) FROM payments LEFT JOIN accounts_test ON payments.account_id=accounts_test.account_id WHERE paytype>0 AND $period(DATE_ADD(account_close, INTERVAL $TTL DAY))=$period(NOW())+$offset;" | mysql -BN -ueuro3g -peuro3g eurotest

}

CSV_RESULT=`prep_report "<br>"`

sysmsg "$TITLE" "<pre><b>Clienti serviti dal Euro3G<b><br><br></pre><b><blockquote>$CSV_RESULT<br></b></blockquote>"

