#!/bin/bash

# Variables
OUTPUT_FILE="/var/www/html/TOMWATCH/TOM.txt"
MAIL_FILE="/var/www/html/TOMWATCH/mail_ip.txt"
EMAIL="bradshaw.k1te@lupton.us"
SMTP_FROM="ssmtpLOFT@lupton.us"
SUBJECT="WE-SEE-SPOTS"

# WSPR Query URL for WA2TP on band 7
QUERY_URL="http://db1.wspr.live/?query=SELECT%20*%20FROM%20wspr.rx%20WHERE%20time%20%3E%20subtractHours%28now%28%29%2C%202%29%20AND%20rx_sign%20%3D%20%27WA2TP%27%20AND%20band%20%3D%207%20LIMIT%2010"

# Fetch and save query results
curl -s "$QUERY_URL" > "$OUTPUT_FILE"

# Check if output contains more than 50 characters
if [[ $(wc -c < "$OUTPUT_FILE") -gt 50 ]]; then
  # Prepare email content
  echo "To: $EMAIL" > "$MAIL_FILE"
  echo "From: $SMTP_FROM" >> "$MAIL_FILE"
  echo "Subject: $SUBJECT" >> "$MAIL_FILE"
  echo "" >> "$MAIL_FILE"
  echo "Results from WSPR query for WA2TP on band 7:" >> "$MAIL_FILE"
  echo "" >> "$MAIL_FILE"
  cat "$OUTPUT_FILE" >> "$MAIL_FILE"

  head $OUTPUT_FILE
  
  # Send email using ssmtp
  /usr/sbin/ssmtp "$EMAIL" < "$MAIL_FILE"
fi