#!/bin/bash

DATE=`date '+%Y%m%d'`

echo `date` "-- Backing up RSCOMMON.bp_revenue_summary table $DATE"

mysqldump -udbuser -predStripe -hdbmaster RSCOMMON bp_revenue_summary > /app/shared/dtmv/billing_reports/RSCOMMON.bp_revenue_summary.$DATE.dump

echo `date` "-- Started monthly DTMV revenue report for $DATE"

/app/tools/stats/bin/revenue_report.pl -p > /app/shared/dtmv/billing_reports/DTMV_BILLING_$DATE.txt

echo `date` "-- Finished monthly DTMV revenue report for $DATE"

/app/tools/stats/bin/email_dtmv_revenue_summary.pl -p "/app/shared/dtmv/billing_reports" -n "DTMV_BILLING_$DATE.txt" -d $DATE

echo `date` "-- Emailed monthly dtmv revenue report for $DATE"