#!/bin/bash

LOG="/var/log/apache2/domlogs/my.evolutionerp.com.au-ssl_log"
OUT="erp_page_analysis.txt"

exec > "$OUT" 2>&1

echo "===================================================="
echo "EVOLUTION ERP PAGE ANALYSIS"
echo "===================================================="
echo

echo "Total requests:"
grep '10/Jul/2026:11:1' "$LOG" | wc -l

echo
echo "===================================================="
echo "TOP page= VALUES"
echo "===================================================="

grep '10/Jul/2026:11:1' "$LOG" \
| sed -n 's/.*page=\([^& ]*\).*/\1/p' \
| sort \
| uniq -c \
| sort -nr

echo
echo "===================================================="
echo "TOP FULL URLS"
echo "===================================================="

grep '10/Jul/2026:11:1' "$LOG" \
| awk -F'"' '{print $2}' \
| sort \
| uniq -c \
| sort -nr \
| head -100

echo
echo "===================================================="
echo "TOP REQUESTING IPS"
echo "===================================================="

grep '10/Jul/2026:11:1' "$LOG" \
| awk '{print $1}' \
| sort \
| uniq -c \
| sort -nr \
| head -100

echo
echo "===================================================="
echo "REPORT / EXPORT ACTIVITY"
echo "===================================================="

grep '10/Jul/2026:11:1' "$LOG" \
| egrep -i \
'report|export|pdf|excel|csv|download|print'

echo
echo "===================================================="
echo "QUOTE ACTIVITY"
echo "===================================================="

grep '10/Jul/2026:11:1' "$LOG" \
| egrep -i 'quote'

echo
echo "===================================================="
echo "DISPATCH ACTIVITY"
echo "===================================================="

grep '10/Jul/2026:11:1' "$LOG" \
| egrep -i 'dispatch'

echo
echo "===================================================="
echo "INVENTORY ACTIVITY"
echo "===================================================="

grep '10/Jul/2026:11:1' "$LOG" \
| egrep -i 'inventory|invedit|inv'

echo
echo "===================================================="
echo "JOBS ACTIVITY"
echo "===================================================="

grep '10/Jul/2026:11:1' "$LOG" \
| egrep -i 'job'

echo
echo "Report written to $OUT"