| Server IP : 173.209.174.21 / Your IP : 216.73.216.79 Web Server : Apache/2.4.58 (Ubuntu) System : Linux wcfs-server 6.8.0-124-generic #124-Ubuntu SMP PREEMPT_DYNAMIC Tue May 26 13:00:45 UTC 2026 x86_64 User : nodor ( 1000) PHP Version : 8.3.6 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : OFF Directory : /proc/thread-self/root/usr/local/bin/ |
Upload File : |
#!/bin/bash
# --- CONFIG ---
PHP_PATH="/usr/bin/php"
EXPORT_SCRIPT="/var/www/wcfs/tabs/export_qbo_nightly.php"
EXPORT_DIR="/var/www/wcfs/tabs/qbo_exports"
EMAIL_TO="nodor@nykoinc.com"
DATE=$(date +%Y%m%d_%H%M%S)
START_DATE=$(date -d "$(date +%Y-%m-01) -2 days" +%Y-%m-%d)
END_DATE=$(date +%Y-%m-%d)
EXPORT_FILE="$EXPORT_DIR/qbo_export_nightly_${DATE}.csv"
# Ensure export directory exists
mkdir -p "$EXPORT_DIR"
# --- EXPORT DATA ---
$PHP_PATH $EXPORT_SCRIPT start=$START_DATE end=$END_DATE > "$EXPORT_FILE"
# --- EMAIL ---
if [ -s "$EXPORT_FILE" ]; then
echo "Attached is the nightly QuickBooks export from $START_DATE to $END_DATE." | \
mailx -s "WCFS QuickBooks Export $START_DATE to $END_DATE" \
-A "$EXPORT_FILE" \
"$EMAIL_TO"
else
echo "No data to export for $START_DATE to $END_DATE. Export file is empty." | \
mailx -s "WCFS QuickBooks Export Skipped $DATE" "$EMAIL_TO"
fi