#!/bin/sh

# Script to email when file changes
#

PATH=/sbin:/usr/sbin:/bin:/usr/bin:/usr/local/bin
RECIPS="email@domain.com email2@domain.com"

mv /home/drware/PRIVATE/scripts/newhire/New_Hires_Listing.csv /home/drware/PRIVATE/scripts/newhire/New_Hires_Listing.old.csv
cp /home/fajita/Forms/Info/New_Hires_Listing.xls /home/drware/PRIVATE/scripts/newhire/New_Hires_Listing.xls

java -jar /home/drware/PRIVATE/scripts/newhire/jexcelapi/jxl.jar -csv /home/drware/PRIVATE/scripts/newhire/New_Hires_Listing.xls > /home/drware/PRIVATE/scripts/newhire/New_Hires_Listing.csv

diff /home/drware/PRIVATE/scripts/newhire/New_Hires_Listing.csv  /home/drware/PRIVATE/scripts/newhire/New_Hires_Listing.old.csv  > /home/drware/PRIVATE/scripts/newhire/diff.csv

echo '' > /home/drware/PRIVATE/scripts/newhire/mail.tmp
echo "This information was diffed from \\\fajita\Forms\Info\New_Hires_Listing.xls" >> /home/drware/PRIVATE/scripts/newhire/mail.tmp
echo '' >> /home/drware/PRIVATE/scripts/newhire/mail.tmp
more /home/drware/PRIVATE/scripts/newhire/diff.csv >> /home/drware/PRIVATE/scripts/newhire/mail.tmp
echo '' >> /home/drware/PRIVATE/scripts/newhire/mail.tmp
echo '' >> /home/drware/PRIVATE/scripts/newhire/mail.tmp
echo " =====================================================================================	" >> /home/drware/PRIVATE/scripts/newhire/mail.tmp
echo '' >> /home/drware/PRIVATE/scripts/newhire/mail.tmp
echo " 		Legend:" >> /home/drware/PRIVATE/scripts/newhire/mail.tmp
echo " 		   Numbers indicate line in excel spreadsheet" >> /home/drware/PRIVATE/scripts/newhire/mail.tmp
echo " 		   > means that something was removed" >> /home/drware/PRIVATE/scripts/newhire/mail.tmp
echo " 		   < means that something was addedd" >> /home/drware/PRIVATE/scripts/newhire/mail.tmp
echo '' >> /home/drware/PRIVATE/scripts/newhire/mail.tmp
echo " 	Email generated via a cron job running on PC0005002" >> /home/drware/PRIVATE/scripts/newhire/mail.tmp
echo " 	darley.ware" >> /home/drware/PRIVATE/scripts/newhire/mail.tmp
echo '' >> /home/drware/PRIVATE/scripts/newhire/mail.tmp

# Lets see what color we need to set
NEW=`cat /home/drware/PRIVATE/scripts/newhire/New_Hires_Listing.csv | wc -m`
OLD=`cat /home/drware/PRIVATE/scripts/newhire/New_Hires_Listing.old.csv | wc -m`

if [ $NEW -lt $OLD ];
then
        cat /home/drware/PRIVATE/scripts/newhire/mail.tmp | mail -s "New Hire File Updated: `date +%Y-%m-%d:%k%M`" $RECIPS
else
        if [ $OLD -lt $NEW ];
        then
                cat /home/drware/PRIVATE/scripts/newhire/mail.tmp | mail -s "New Hire File Updated: `date +%Y-%m-%d:%k%M`" $RECIPS
        fi
fi

#exit 0