#################################################################
# cleanwork - clean tmp* files from work directory that are at 
#             X days older than any files left there by a 
#             current job in "WAITING" status
#
# J. David Schronce - Thu Mar 29 08:44:09 CDT 2007
#################################################################
#
# CONFIGURATION:
#  Set Variables below as required by your business needs
#   NUM_DAYS = number of days older than the oldest "WAITING"
#       job.  If no jobs in "WAITING" then number of days before
#       today.
#
#
#set -xv
#################################################################
NUM_DAYS=8

#################################################################
#
# END OF CONFIGURATION
#
#################################################################
# Test for current env
#if [ -f ! $GENDIR/bin/jqstatus ]; then
#   echo "\nNo Environment Set\n"
#   exit
#fi

OLDEST=`jqstatus -w | cut -d, -f9 | sort -n | head -1`
if [ "X$OLDEST" = "X" ]; then
   OLDEST=`date '+%Y%m%d'`
   RM_DAYS=$NUM_DAYS
else
#Calculate days from today to OLDEST - $NUM_DAYS
   NOW_YEAR=`date '+%Y'`
   NOW_MON=`date '+%m'`
   NOW_DAY=`date '+%d'`
   OLD_YEAR=`echo $OLDEST | cut -c 1-4`
   OLD_MON=`echo $OLDEST | cut -c 5-6`
   OLD_DAY=`echo $OLDEST | cut -c 7-8`
   
   YEAR_DAYS=`echo "($NOW_YEAR - $OLD_YEAR) * 365" | bc`
   DAYS=`echo "$NOW_DAY - $OLD_DAY" | bc`
   MONTH_DAYS=`echo "($NOW_MON - $OLD_MON) * 31" | bc` # Err on the side of caution

   RM_DAYS=`echo "$YEAR_DAYS + $MONTH_DAYS + $DAYS + $NUM_DAYS" | bc`
fi 
echo $RM_DAYS
# Get list of Productlines
for prodline in `rngdbdump -cnt gen prodline -f ProductLine | grep -v "GEN" | grep -v "LOGAN" | sed 's/\"//g' | tr [:upper:] [:lower:]`
do
   echo "$LAWDIR/$prodline"
   cd $LAWDIR/$prodline/work
   find . -name "tmp[0-9]*" -mtime +$RM_DAYS -prune -exec ls -lrt {} \;
   find . -name "tmp[0-9]*" -mtime +$RM_DAYS -prune -exec rm {} \;
done