#!/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 \.
PGM="`basename $0|cut -d\. -f1`"
VER="0.4"
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"

echo "`date` ${PGM} v${VER} started."|tee -a ${LOG}
touch ${TMP}
echo "BASEDIR=${BASEDIR}"

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

# Get all models with filername for undoubling
cat /appl/mdr/mdrglob/afsp/??/data/model-version/filer-name-loc-model-os-fw-sn-partner.csv|egrep -v 'Controller|Total'|sort|while read LINE
do
  FILER="`echo ${LINE}|awk -F\; '{print $1}'`"
  MODEL="`echo ${LINE}|awk -F\; '{print $3}'`"
  VERSION="`echo ${LINE}|awk -F\; '{print $4}'`"
  if [ "${VERSION}" != "" ]; then
    echo "${VERSION};${FILER};" >> ${TMP}
  fi  # VERSION
done  # cat

# date | mailx -a ${TMP} -s "${TMP}" ${MAILTO}

echo "  Counting 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}|awk -F\; '{print $1}'|sort -u|while read VERSION
do
  echo -n "${VERSION};"|tee -a ${OUT}
  GVER="`echo "${VERSION}"|sed 's/\./\\\./g'`"
  for COUNTRY in `cd /appl/mdr/mdrglob/afsp/; ls -1d ??`
  do
    CNT=""
    if [ -f /appl/mdr/mdrglob/afsp/${COUNTRY}/data/model-version/filer-name-loc-model-os-fw-sn-partner.csv ]; then
      CNT="`grep \"${GVER}\" /appl/mdr/mdrglob/afsp/${COUNTRY}/data/model-version/filer-name-loc-model-os-fw-sn-partner.csv|wc -l`" 
	fi
	echo -n "${CNT};"|tee -a ${OUT}
  done  # COUNTRY
  echo ""|tee -a ${OUT}
done  # cat

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

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

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