#!/bin/bash

# Verzeichnis in dem Die Dateien abgelegt werden sollen
FILE_DIR="$QA_PFAD/tmp"
mkdir -p $FILE_DIR

# Dateiname
export FILE_NAME="Testfall_Protokoll"

# Masken TID
export MASKEN_TID=37020

# Datum für das Feld "Ab Datum"
export DATUM_EXEC=$(date "+%d.%m.%Y")

# Masken Parameter
export MASK_PARAM="Ausführungs-Status=1,2&Ab Datum=${DATUM_EXEC}"


# ExecuteMask funktioniert nur im WEB-INF Ordner
cd $WEBAPP/WEB-INF

#echo CMD -cp "$JDBC_CLASSPATH" $JAVA_OPTS de.superx.bin.ExecuteMask -tid:$MASKEN_TID -out:$FILE_DIR/$FILE_NAME.pdf -user:admin "-params:${MASK_PARAM}&stylesheet=tabelle_fo_pdf.xsl&contenttype=application/pdf" -logger:$SUPERX_DIR/db/conf/logging.properties

# XLSX
java -cp "$JDBC_CLASSPATH" $JAVA_OPTS de.superx.bin.ExecuteMask -tid:$MASKEN_TID -out:$FILE_DIR/$FILE_NAME.xlsx -user:admin "-params:${MASK_PARAM}&Zusammenfassung=0&stylesheet=tabelle_37020_mit_summary.jrxml&contenttype=application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" -logger:$SUPERX_DIR/db/conf/logging.properties
#HTML
java -cp "$JDBC_CLASSPATH" $JAVA_OPTS de.superx.bin.ExecuteMask -tid:$MASKEN_TID -out:$FILE_DIR/$FILE_NAME.htm -user:admin "-params:${MASK_PARAM}&Zusammenfassung=1&stylesheet=tabelle_37020_mit_summary.jrxml&contenttype=text/html" -logger:$SUPERX_DIR/db/conf/logging.properties


# XML
#java -cp "$JDBC_CLASSPATH" $JAVA_OPTS de.superx.bin.ExecuteMask -tid:$MASKEN_TID -out:$FILE_DIR/$FILE_NAME.xml -user:admin "-params:${MASK_PARAM}&stylesheet=tabelle_fo_pdf.xsl&contenttype=application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" -logger:$SUPERX_DIR/db/conf/logging.properties

# CSV
java -cp "$JDBC_CLASSPATH" $JAVA_OPTS de.superx.bin.ExecuteMask -tid:$MASKEN_TID -out:$FILE_DIR/$FILE_NAME.csv -user:admin "-params:${MASK_PARAM}&stylesheet=tabelle_fo_pdf.xsl&contenttype=text/csv" -logger:$SUPERX_DIR/db/conf/logging.properties

# Verzeichnis in dem die Dateien abgelegt wurden. Zum zählen und verschicken.
cd $FILE_DIR
sed -i 's/\^/ \| /g' $FILE_DIR/$FILE_NAME.csv

#Zuerst Warnungen und Fehler zählen
export W_ANZ=$(grep -c Warnung $FILE_DIR/$FILE_NAME.csv)
export F_ANZ=$(grep -c Fehler $FILE_DIR/$FILE_NAME.csv)


#Mail Versand
cat $FILE_DIR/$FILE_NAME.htm | $MAILPROG -s "Testfall-Protokoll | $W_ANZ Warnungen | $F_ANZ Fehler" -M "text/html" -a $FILE_DIR/$FILE_NAME.xlsx "${LOGMAIL}"