date
BUG_NUMBERS=`mysql -ubugs -pGeige bugs <<END_SQL
select bug_id from bugs where  cf_start_point BETWEEN DATE('0001-01-01')
and NOW() AND resolution = 'WONTFIX';
END_SQL`

echo $SQL_RESULT >otto
echo $BUG_NUMBERS >>otto
if [ "$BUG_NUMBERS" = "" ]; then
  echo Keine Aufgaben gefunden
else
  echo $BUG_NUMBERS
BUG_BODY=`mysql -ubugs -pGeige bugs <<END_SQL
select 'SD', short_desc, 'BI', bug_id from bugs where  cf_start_point BETWEEN DATE('0001-01-01')
and DATE('2020-01-01') AND resolution = 'WONTFIX';
END_SQL`
  echo Hallo, >body.txt
  echo "neue Aufgabe(n):" >>body.txt

  for item in ${BUG_BODY#*bug_id}
  do
    if [[ $item = "SD" ]]
    then
      status=SD
    elif [[ $item = "BI" ]]
    then
      echo $sd >>body.txt
      sd=""
      status=BI
    elif [[ $status = "SD" ]]
    then
      sd="$sd $item"
    elif [[ $status = "BI" ]]
    then
      echo http://www.wagnertech.de/bugzilla/show_bug.cgi?id=$item >>body.txt
    fi
  done

#fi

  mail -s"Neue Aufgabe: ${BUG_NUMBERS#*bug_id}" bonzius@vindelicia.de <body.txt

fi