#!/bin/sh

echo "**The Mitgaard Census Report Maker**" ;
echo "" ;
echo "Please enter the filename for this report: " ;
read filenameresponse;
echo "What is the last census sample date? (yy-mm-dd)";
read dateresponse ;
echo "Please pardon me while I generate the report.  This takes a moment...";

echo "** The Mitgaard Census, " `date` " **" > $filenameresponse;
echo "Census as of" $dateresponse >> $filenameresponse ;
echo "" >> $filenameresponse;

echo "Header made...";

set ${totalcount=`more ${dateresponse}".samp" | wc -l`};
echo "Total number of mitgaard@athena subscribers: " $totalcount >> $filenameresponse ;
echo "" >> $filenameresponse;

echo "Subscribers who have been on from previous period: "  >> $filenameresponse ;
sort -f *.MARK > /tmp/tempsorted1 ;
sort -f ${dateresponse}.samp > /tmp/tempsorted2 ;
comm -12 /tmp/tempsorted1 /tmp/tempsorted2  >> $filenameresponse;
echo ""  >> $filenameresponse ;
set ${prevsubscount=`comm -12 /tmp/tempsorted1 /tmp/tempsorted2 | wc -l `};
echo "Total count of previous subscribers: " $prevsubscount  >> $filenameresponse ;
echo ""  >> $filenameresponse ;
rm /tmp/tempsorted1 /tmp/tempsorted2 ;

echo "Done with prevsubs...";

echo "Unsubscriptions as of" $dateresponse >> $filenameresponse ;
sort -f *.MARK > /tmp/tempsorted1 ;
sort -f ${dateresponse}.samp > /tmp/tempsorted2 ;
comm -23 /tmp/tempsorted1 /tmp/tempsorted2  >> $filenameresponse;
echo ""  >> $filenameresponse ;
set ${exsubscount=`comm -23 /tmp/tempsorted1 /tmp/tempsorted2 | wc -l `};
echo "Total count of unsubscriptions: " $exsubscount >> $filenameresponse ;
echo "" >> $filenameresponse ;
rm /tmp/tempsorted1 /tmp/tempsorted2 ;

echo "Done with exsubs...";

echo "New subscriptions as of" $dateresponse >> $filenameresponse ;
sort -f *.MARK > /tmp/tempsorted1 ;
sort -f ${dateresponse}.samp > /tmp/tempsorted2 ;
comm -13 /tmp/tempsorted1 /tmp/tempsorted2  >> $filenameresponse;
echo ""  >> $filenameresponse ;
set ${newsubscount=`comm -13 /tmp/tempsorted1 /tmp/tempsorted2 | wc -l `};
echo "Total count of new subscriptions: " $newsubscount >> $filenameresponse ;
rm /tmp/tempsorted1 /tmp/tempsorted2 ;

echo "Done with newsubs...";

echo "Done."