#!/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="ASST CARE SEES SPOTS"

QUERY_URL="http://db1.wspr.live/?query=SELECT%20*%20FROM%20wspr.rx%20WHERE%20time%20%3E%20subtractHours%28now%28%29%2C%202%29%20AND%20tx_sign%20%3D%20%27KC1VZD%27"


#QUERY_URL="http://db1.wspr.live/?query=SELECT%20*%20FROM%20wspr.rx%20WHERE%20time%20%3E%20subtractHours%28now%28%29%2C%202%29%20AND%20tx_sign%20%3D%20%27KC1VZD%27%20AND%20band%20%3D%2028%20LIMIT%2020"


#"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"

CALL_COUNT_FILE="/var/www/html/TOMWATCH/call_count.txt"

# Reset call count at midnight
if [[ $(date +%H:%M) == "00:00" ]]; then
  echo "0" > "$CALL_COUNT_FILE"
fi

# 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"

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

  # Check time and call count
  CURRENT_HOUR=$(date +%H)
  if [[ $CURRENT_HOUR -ge 10 && $CURRENT_HOUR -lt 21 ]]; then
    # Read current call count
    CALL_COUNT=$(cat "$CALL_COUNT_FILE" 2>/dev/null || echo "0")
    
    if [[ $CALL_COUNT -lt 3 ]]; then
      echo "Making call #$((CALL_COUNT + 1)) for the day."
      python3 /var/www/html/TOMWATCH/make_call.py
      python3 /var/www/html/TOMWATCH/make_call_tom.py
      python3 /var/www/html/TOMWATCH/BourneNeckDrive.py
      echo $((CALL_COUNT + 1)) > "$CALL_COUNT_FILE"
    fi
  fi
fi




exit
exit
exit

#!/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="ASST CARE SEES SPOTS"
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"

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

  # Check if the current time is between 12 PM and 8 PM
  CURRENT_HOUR=$(date +%H)
  if [[ $CURRENT_HOUR -ge 9 && $CURRENT_HOUR -lt 20 ]]; then
    echo "Making a call since it's between 12 PM and 8 PM."
    python3 /var/www/html/TOMWATCH/make_call.py
  fi
fi