Modul Qualitätssicherung
http://www.superx-projekt.de/doku/qa_modul/index.htm
You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
49 lines
2.3 KiB
49 lines
2.3 KiB
#!/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}" |
|
|
|
|
|
|