#!/bin/bash -x
#
# It generates programmer activity status report
# This script can be invoked
#         % scriptfilename
# Prabu, 6/13/04

# trap commandstring OS_signal_number
# When OS generates the signal_number, the commandstring will be executed
# When a script completes normally, OS generates signal 0
#  2> => std error messages of rm command will be redirected to null device
#          i.e. std error message will not be sent to the console
trap "rm  ./t[1-3]*  2> /dev/null; exit" 0

# cut only the 4th field (project number) of project file
# -d: => field delimiter is ':'
# uniq -c => output each line (without duplicates) along with
#             a prefix count (no. of occurrences of that line)
cut -d: -f4 project | sort | uniq -c | awk '{printf "%s:%s\n", $2, $1}' > t1pnum
echo
echo ==== output of the first cut command ====
cat t1pnum

# cut fields 1 (leftmost field) through 4 of programmer file
#  +0 => sort according to the zeroth (leftmost) field
#  -1 => output format in single column
cut -d: -f1-4 programmer | sort -t: +0 -1 | uniq > t2pnn
echo
echo ==== output of the second cut command ====
cat t2pnn

# -t: => field delimiter is ':'
# -1 n => join on the nth field of file 1
# -1 1 => join on the 1st (leftmost) field of file 1
# -2 n => join on the nth field of file 2
# -2 1 => join on the 1st (leftmost) field of file 2 (i.e. t1pnum)
# -a1 => also print unpairable lines from file 1 (i.e. t2pnn)
join -t:  -1 1  -2 1  -a1  t2pnn t1pnum > t3pactrep
echo
echo ==== output of the join command ====
cat t3pactrep

echo
echo ==== output of the awk command ====
# print the report
# BEGIN segment will be performed first (only one time)
#  before each line of the input file is processed for 'pattern {action}'
awk '
 BEGIN {
   { FS=":" }
   { print "\tProgrammer Activity Status Report" }
   { "date" | getline d }
   { printf "\t   %s\n\n", d }
   { print "Prog#\t*-Name-*\t\t      Projects" }
   { print "==============================================" }
 }
 { printf "%-s\t%-12.12s %-12.12s %s\t%d\n", $1,$2,$3,$4,$5 }' t3pactrep