#! /bin/sh
SDATE=`date +%d/%m/%Y`

dd=`echo $SDATE | sed -e 's/\/..\/....$//g'`
mm=`echo $SDATE | sed -e 's/^..\///g;s/\/....$//g'`
yyyy=`echo $SDATE | sed -e 's/^..\/..\///g'`
if [ "$dd" -eq 01 ]
then
        if [ "$mm" -eq 01 ]
        then
                yyyy=`expr $yyyy - 1`
                mm=12
                dd=31
        else
                mm=`expr $mm - 1 | awk '{printf("%02d\n",$1)}'`
                dd=`lastdayinmonth $mm $yyyy`
        fi
else
        dd=`expr $dd - 1 | awk '{printf("%02d\n",$1)}'`
fi
dodate="$dd/$mm/$yyyy"
tbldate=`echo $dodate | sed -e 's/\//_/g'`
cdrtable="c$tbldate"

fstdate="01/$mm/$yyyy"

# verify data exists in history tables
do_histverify()
{
        #histverify hist_gg  "$fstdate" "$dodate" 2>&1
        #histverify hist_gn  "$fstdate" "$dodate" 2>&1
        #histverify hist_gne "$fstdate" "$dodate" 2>&1
        #histverify hist_dt  "$fstdate" "$dodate" 2>&1
        #histverify hist_dm  "$fstdate" "$dodate" 2>&1
        #histverify hist_dc  "$fstdate" "$dodate" 2>&1
        echo "select \"TAG1\", tabname from systables where tabname matches \"hist_*\" order by tabname" | runisql 2>&1 | \
        while read tag hist_table
        do
                if [ "$tag" = "TAG1" ]; then
			histverify "$hist_table" "$fstdate" "$dodate" 2>&1
                fi
        done
}

do_histverify