#!/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)
#(0.3),171208	: Changed to DB.asc-files
PGM="`basename $0|cut -d\. -f1`"
VER="0.3"
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"

# Models
OUT="${BASEDIR}/data/dashboard/models.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/sernr-name-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}" >> ${TMP}
  done  # DBFILE
done  # COUNTRY
echo ""
  
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}|sort -u|while read MODEL REST
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/sernr-name-model-version.csv ]; then
      CNT="`grep -F \"${MODEL}\" /appl/mdr/mdrglob/afsp/${COUNTRY}/data/model-version/sernr-name-model-version.csv|wc -l`"
#	  echo "CNT=${CNT}"
    fi  # -f
    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
# OUT-file will be processed.
cd /appl/mdr/instance/GLOB/cur/bin/
./GLOB_scanner_INPUTDATA

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