: !/bin/sh # usage: wb3a SDATE EDATE STIME ETIME SITEID SDATE=$1; EDATE=$2; STIME=$3; ETIME=$4 # extract config and call data for later process by wb3 # generate verification report # generate export csv ########################################################### if [ -n "$5" ]; then SITEID=$5 else SITEID="ALL" fi if [ -n "$6" ]; then thisDIVID="$6" else thisDIVID="all" fi ##################################### MMYYYY=`SDATEtoMMYYYY $SDATE` billperiod=`MMYYYYtobillperiod $MMYYYY _` batchtag="${billperiod}_all_${thisDIVID}" ##################################### # save output if [ -z "$logdir" ]; then logdir="topdat/${billperiod}/log"; export logdir mkdir -p $logdir echo "WARNING: wb3a: logdir not set using [$logdir]" fi exec 2>&1 >${logdir}/wb3a_${batchtag}_log.rtf echo "$0: SDATE=[$SDATE] EDATE=[$EDATE]" echo " MMYYYY = [$MMYYYY]" echo " billperiod = [$billperiod]" ################################### # create t21groups2.unl t21groups2file="t21groups2.unl" #if [ ! -f "$t21groups2file" ]; then gett21groups2 $t21groups2file #fi ## remove previous directory csv t21dircsvfile="T21Eptc.csv" #if [ ! -f "$t21dircsvfile" ]; then #rm -f $t21dircsvfile img/direnq/$t21dircsvfile ## extract directory csv T21Eptc_getcsv #cp $t21dircsvfile img/direnq #fi ######################################################## # make indata folders if [ ! -d "indata/${billperiod}" ]; then mkdir -p "indata" mkdir -p "indata/${billperiod}" mkdir -p "indata/${billperiod}/VICTRACK" mkdir -p "indata/${billperiod}/VICTRACK/PP" mkdir -p "indata/${billperiod}/TELSTRA" mkdir -p "indata/${billperiod}/OPTUS" mkdir -p "indata/${billperiod}/VODAFONE" mkdir -p "indata/${billperiod}/AAPT" mkdir -p "indata/${billperiod}/REST" fi # fix perms find indata/${billperiod} -depth -exec chgrp catcom {} \; find indata/${billperiod} -depth -exec chown catcom {} \; ######################################################## # save input data files if [ ! -f "indata/${billperiod}/"`basename $t21dircsvfile` ]; then cp $t21dircsvfile "indata/${billperiod}" fi if [ ! -f "indata/${billperiod}/"`basename $t21groups2file` ]; then cp $t21groups2file "indata/${billperiod}" fi if [ ! -f "indata/${billperiod}/seidtranslate.csv" ]; then cp "indata/seidtranslate.csv" "indata/${billperiod}" fi ######################################################## # create t21 calls file t21callsfile="indata/${billperiod}/VICTRACK/c9_${MMYYYY}.in" if [ ! -f "$t21callsfile" ]; then echo "Creating T21 calls file: $t21callsfile" time cdr9 "$SDATE" "$EDATE" "Nulls" "Nulls" "ALL" 2>&1 | tee cdr9.log # save calls file mv c9.in $t21callsfile grep VAC $t21callsfile >${t21callsfile}.VAC else echo "Using existing T21 calls file: $t21callsfile" fi ######################################################## # create t21 SWITCHBOARD calls file t21swcallsfile="indata/${billperiod}/VICTRACK/s9_${MMYYYY}.in" if [ ! -f "$t21swcallsfile" ]; then echo "Creating T21 SWITCHBOARD calls file: $t21swcallsfile" time swb9 "$SDATE" "$EDATE" "Nulls" "Nulls" "ALL" 2>&1 | tee swb9.log # save file mv s9.in $t21swcallsfile else echo "Using existing T21 SWITCHBOARD calls file: $t21swcallsfile" fi ######################################################## # create t21 VOICEMAIL calls file t21vmcallsfile="indata/${billperiod}/VICTRACK/v9_${MMYYYY}.in" if [ ! -f "$t21vmcallsfile" ]; then echo "Creating T21 VOICEMAIL calls file: $t21vmcallsfile" time vml9 "$SDATE" "$EDATE" "Nulls" "Nulls" "ALL" 2>&1 | tee vml9.log # save file mv v9.in $t21vmcallsfile else echo "Using existing T21 VOICEMAIL calls file: $t21vmcallsfile" fi ######################################################## # create t21 rent (tec) file t21tecfile="indata/${billperiod}/VICTRACK/r9_${MMYYYY}.in" if [ ! -f "$t21tecfile" ]; then echo "Creating T21 TEC (rent) file: $t21tecfile" time tec9 "$SDATE" "$EDATE" "Nulls" "Nulls" "ALL" 2>&1 | tee tec9.log # save file mv r9.in $t21tecfile grep VAC >${t21tecfile}.VAC else echo "Using existing T21 TEC (rent) file: $t21tecfile" fi ################################## ################################## # make preprossesor input files ppcallsfile="indata/${billperiod}/VICTRACK/PP/c9_${MMYYYY}.txt" sed -e 's/$/ /' <"$t21callsfile" >"$ppcallsfile" ppswcallsfile="indata/${billperiod}/VICTRACK/PP/s9_${MMYYYY}.txt" sed -e 's/$/ /' <"$t21swcallsfile" >"$ppswcallsfile" ppvmcallsfile="indata/${billperiod}/VICTRACK/PP/v9_${MMYYYY}.txt" sed -e 's/$/ /' <"$t21vmcallsfile" >"$ppvmcallsfile" pptecfile="indata/${billperiod}/VICTRACK/PP/r9_${MMYYYY}.txt" sed -e 's/$/ /' <"$t21tecfile" >"$pptecfile" ########################### ## Testing ## create t21 calls file for single thisDIVID #if [ "$thisDIVID" != "all" ]; then # singlet21callsfile="indata/${billperiod}/VICTRACK/c9_${thisDIVID}_${MMYYYY}.in" # if [ ! -f "$singlet21callsfile" ]; then # echo "Creating single T21 calls file: $singlet21callsfile for $thisDIVID" # grep -F "${thisDIVID}," $t21callsfile >$singlet21callsfile # else # echo "Using existing single T21 calls file: $singlet21callsfile" # fi # t21callsfile=$singlet21callsfile #fi ########################### # $generate verification report and csv awk -f wb3.awk -v "MMYYYY=$MMYYYY" -v"sdate=$SDATE" -v"edate=$EDATE" \ -v "logdir=$logdir" \ -v "dot21verify=1" \ -v "thisDIVID=$thisDIVID" \ -v "t21callsfile=$t21callsfile" \ -v "t21swcallsfile=$t21swcallsfile" \ -v "t21vmcallsfile=$t21vmcallsfile" \ -v "t21tecfile=$t21tecfile" \ -v "t21dircsvfile=$t21dircsvfile" \ -v "t21groups2file=$t21groups2file" #################### # get warnings errwarnlogfile="${logdir}/ex3a_ERROR_WARNING_${batchtag}.rtf" rm -f $errwarnlogfile echo "" >>$errwarnlogfile echo "Warning / Error LOG" >>$errwarnlogfile echo "------------------------------------------" >>$errwarnlogfile echo "" >>$errwarnlogfile head -3 ${logdir}/wb3a_${batchtag}_log.rtf >>$errwarnlogfile echo "" >>$errwarnlogfile egrep "^INFO:|^FATAL ERROR:|^WARNING:" ${logdir}/wb3a_${batchtag}_log.rtf | sort -u >>$errwarnlogfile echo "" >>$errwarnlogfile if [ -s wb3a_${batchtag}.out ]; then cat wb3a_${batchtag}.out >>$errwarnlogfile echo "" >>$errwarnlogfile fi # zip log files rm -f ex3a_${batchtag}_LOGS.zip zip -r -9 ex3a_${batchtag}_LOGS.zip "${logdir}" mv "ex3a_${batchtag}_LOGS.zip" "${logdir}" ######################################################################## # email wb3a validation reports / export csv emailex3tot "${logdir}/ex3a" "$billperiod" all "all" "" "" ################################################## exit 0