#!/bin/sh
# File	: ana_resports.sh
# By	: Maarten.deBoer@AtosOrigin.com, 100413
# Subject	: Analyze DFM-custom-reports for SLB

PGM="`basename $0|cut -d. -f1`"
TMP="/tmp/${PGM}.$$"
LOG="${HOME}/log/${PGM}.log"

PREFIX="dfm-report-Volume-Perf-Custom-SLB"
YEARS="2010"
MONS="04"
DAYS="12 13 14 15 16 17"
DAYS="12"
HRS="00 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23"
MINS="00 05 10 15 20 25 30 35 40 45 50 55"


cd ${HOME}/data/reports/

for YEAR in ${YEARS}
do
  for MON in ${MONS}
  do
    for DAY in ${DAYS}
    do
      for HR in ${HRS}
      do
        for MIN in ${MINS}
        do
          FILE="${PREFIX}-${YEAR}-${MON}-${DAY}_${HR}-${MIN}-last.csv"
          if [ -f ${FILE} ]; then
            echo "file ${FILE} found" | tee -a ${LOG}
            DATI="; ${YEAR}-${MON}-${DAY} ; ${HR}:${MIN} ;"
            DAYY="${YEAR}-${MON}-${DAY}"
            cat ${FILE} | sed -e 's/,/;/g'|sed -e 's/\./\,/g' > ${FILE}.tmp
            cat ${FILE}.tmp|grep -v Totals| while read LINE
            do
#              echo $DATI ${LINE} | awk -F\; '{print $1";"$2";"$3";"$4";"$5";"$6";"$7";"}' >> ${DAYY}.csv
              echo ${LINE} ${DATI} >> ${DAYY}.csv
            done
          else
            echo "${FILE} NOT found"

          fi

        done
      done
    done
  done
done





exit