#!/bin/sh

FROM="Stefan Hagen <sh@uugrn.org>"
CC="Stefan Hagen <sh@uugrn.org>"
SUBJECT="Test Mail"

# Liste has Format:
# ID|VORNAME|VORNAME NACHNAME <EMAIL>|IGNORED|REDUCED|IGNORED|PAYED|IGNORED|IGNORED|KOMMENTAR|STRASSE|PLZ|ORT|TELNR|MOBILNR

cat liste.txt | grep -v "^#" | while read line
do
    ID=$(echo "$line" | cut -d"|" -f1)
    NAME=$(echo "$line" | cut -d"|" -f2)
    MAILTO=$(echo "$line" | cut -d"|" -f3)
    FULLNAME=$(echo "$MAILTO" | cut -d"<" -f1)
    MAIL=$(echo "$MAILTO" | cut -d"<" -f2 |tr -d '>')

    REDUCED=$(echo "$line" | cut -d"|" -f5)
    PAYED=$(echo "$line" | cut -d"|" -f7)
    STR=$(echo "$line" | cut -d"|" -f11)
    PLZ=$(echo "$line" | cut -d"|" -f12)
    ORT=$(echo "$line" | cut -d"|" -f13)
    TEL=$(echo "$line" | cut -d"|" -f14)
    MOBIL=$(echo "$line" | cut -d"|" -f15)

    [ "$PAYED" == "o.k." ] && PAYED="bezahlt"
    [ "$PAYED" == "no" ] && PAYED="ausstehend"

    [ -z "$ID" ] && continue
    [ -z "$NAME" ] && continue
    [ -z "$MAILTO" ] && continue

# test.txt has format:
# Hallo %NAME%,
# 
# Dies ist eine TestMail
# 
# Mitgliedsnummer: %ID%
# Name:            %FULLNAME%
# Adresse:         %STR%
#                  %PLZ% %ORT%
# Telefonnummer:   %TEL%
# Mobilnummer:     %MOBIL%
# Reduzierter Beitrag: %REDUCED%
# Beitragstatus 2024: %PAYED%

    cat test.txt \
        | sed "s|%ID%|$ID|g" \
        | sed "s|%MAILTO%|$MAILTO|g" \
        | sed "s|%NAME%|$NAME|g" \
        | sed "s|%FULLNAME%|$FULLNAME|g" \
        | sed "s|%REDUCED%|$REDUCED|g" \
        | sed "s|%PAYED%|$PAYED|g" \
        | sed "s|%STR%|$STR|g" \
        | sed "s|%PLZ%|$PLZ|g" \
        | sed "s|%ORT%|$ORT|g" \
        | sed "s|%TEL%|$TEL|g" \
        | sed "s|%MOBIL%|$MOBIL|g" \
        | tee logs/$ID.log \
        | echo mail -r "$FROM" -c "$CC" -s "$SUBJECT" "$MAILTO"

cat <<EOF
Sendereport für Mitglied $ID:
    Datum: $(date)
    From: $FROM Cc: $CC To: $MAILTO
    Subject: $SUBJECT
    Daten:
      Name: $FULLNAME
      Adresse: $STR, $PLZ, $ORT
      Tel=$TEL Mobil=$MOBIL Mail=$MAIL
      Reduziert=$REDUCED Beitrag=$PAYED
EOF

done | tee logs/report.log