#!/bin/sh
# File	: collect_models.sh
# By	: Maarten.deBoer@Atos.net
# Subject	: Script to collect model 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)
PGM="`basename $0|cut -d\. -f1`"
VER="0.2"
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/models.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}'`"
  echo "${MODEL};${FILER};" >> ${TMP}
done  # cat


echo "  Counting models"|tee -a ${LOG}
# From ${TMP}-file

echo -n "models;" |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 MODEL
do
  echo -n "${MODEL};"|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/filer-name-loc-model-os-fw-sn-partner.csv ]; then
      CNT="`grep \"${MODEL}\" /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