#!/bin/sh
# File	: collect_versions.sh
# By	: Maarten.deBoer@Atos.net
# Subject	: Script to collect version information of all countries for dashboard(data)
#(0.2)	: Mod; Only filer-name-loc-model-os-fw-sn-partner.csv (no dfm-filer-name-loc-model-os-fw-sn-partner.csv)
#(0.3)	: Mod. 1st write to TMP-file; When VERSION <> "", the write
#(0.4)	: Added GVER; Mod . in version to \.
#(0.5),171208	: Changed to DB.asc-files
#(0.6),171227	: Mod's for counts
#set -x
PGM="`basename $0|cut -d\. -f1`"
VER="0.6"
TMP="/tmp/${PGM}.$$"

MAILTO="maarten.deboer@atos.net"

#BASEDIR="/appl/mdr/afsp/NL"
BASEDIR="`pwd | sed 's/scripts//'|sed 's/bin//'`"
LOG="${BASEDIR}/log/${PGM}.log"

# Vesions
OUT="${BASEDIR}/data/dashboard/versions.csv"

echo "`date` ${PGM} v${VER} started."|tee -a ${LOG}
echo "BASEDIR=${BASEDIR}"
echo "OUT=${OUT}"
sleep 1

touch ${TMP}
# Read Functions file
source ./afsp-db_functions.sh
DB_FUNC_VER

cp /dev/null ${TMP}
# Get all models with filername for undoubling
echo "  Getting Country, Model & Version info ..."
for COUNTRY in `cd /appl/mdr/mdrglob/afsp/; ls -1d ??`
do
  echo -n " ${COUNTRY} "
  MODELVERSIONFILE="/appl/mdr/mdrglob/afsp/${COUNTRY}/data/model-version/model-version.csv"
  cp /dev/null ${MODELVERSIONFILE}
  for DBFILE in `ls -1 /appl/mdr/mdrglob/afsp/${COUNTRY}/data/database/[_0-9]*.asc`
  do
    DB_READ ${DBFILE}
#    echo "${COUNTRY};${DB_SERIAL_NUMBER};${DB_CONTROLER_NAME};${DB_MODEL_NAME};${DB_OS_VERSION};" >> ${MODELVERSIONFILE}
    echo "${DB_MODEL_NAME};${DB_OS_VERSION};" >> ${MODELVERSIONFILE}
    echo "${DB_OS_VERSION}" >> ${TMP}
  done  # DBFILE
done  # COUNTRY
echo ""

# Remove blanks in 1st part of Version by cat | while read LINE
cat ${TMP}|while read LINE
do
  echo ${LINE} >> ${TMP}.2
done
cat ${TMP}.2 > ${TMP}
rm ${TMP}.2

echo "  Counting os-versions"|tee -a ${LOG}
# From ${TMP}-file
echo -n "versions;" |tee ${OUT}
for COUNTRY in `cd /appl/mdr/mdrglob/afsp/; ls -1d ??`
do
  echo -n "${COUNTRY};"|tee -a ${OUT}
done
echo ""|tee -a ${OUT}

cat ${TMP}|sort -u|while read VERSION
do
  if [ "${VERSION}" != "" ]; then
    echo -n "${VERSION};"|tee -a  ${OUT}
    for COUNTRY in `cd /appl/mdr/mdrglob/afsp/; ls -1d ??`
    do
      CNT=""
      if [ -f /appl/mdr/mdrglob/afsp/${COUNTRY}/data/model-version/model-version.csv ]; then
        CNT=`grep -F "${VERSION};" /appl/mdr/mdrglob/afsp/${COUNTRY}/data/model-version/model-version.csv|wc -l`
#         echo "CNT=${CNT}"
      fi  # -f
      echo -n "${CNT};" |tee -a ${OUT}
    done  # COUNTRY
    echo ""|tee -a ${OUT}
  fi  # VERSION
done  # cat

# date |mailx -a ${OUT} -a ${TMP} -s "${PGM} v${VER}" ${MAILTO}

# Update LifeCycleManagamenet page
cd /appl/mdr/instance/GLOB/cur/bin/
./GLOB_scanner_INPUTDATA

#rm ${TMP}
echo "`date` ${PGM} v${VER} finished."|tee -a ${LOG}
exit 0