protected function doOverviewHome($request, $affiliate)
{
$db = new WPAM_Data_DataAccess();
$accountSummary = $db->getTransactionRepository()->getAccountSummary($affiliate->affiliateId);
$args = array();
$args['aff_id'] = $affiliate->affiliateId;
//show total clicks for today
$args['start_date'] = date("Y-m-d H:i:s", strtotime('today'));
$args['end_date'] = date("Y-m-d H:i:s", strtotime('tomorrow'));
$today_clicks = WPAM_Click_Tracking::get_total_clicks($args);
//show total number of transactions for today
$today_transaction_count = WPAM_Commission_Tracking::get_transaction_count($args);
//show total commission for today
$today_total_commission = WPAM_Commission_Tracking::get_total_commission_amount($args);
//show total clicks for this month
$args['start_date'] = date("Y-m-d H:i:s", strtotime(date("Y-m-01")));
$args['end_date'] = date("Y-m-d H:i:s", strtotime(date("Y-m-01", strtotime("+1 month"))));
$monthly_clicks = WPAM_Click_Tracking::get_total_clicks($args);
//show total number of transactions for this month
$monthly_transaction_count = WPAM_Commission_Tracking::get_transaction_count($args);
//show total commission for this month
$monthly_total_commission = WPAM_Commission_Tracking::get_total_commission_amount($args);
$response = new WPAM_Pages_TemplateResponse('affiliate_cp_home');
$response->viewData['accountStanding'] = $accountSummary->standing;
$response->viewData['commissionRateString'] = $this->getCommissionRateString($affiliate);
$response->viewData['monthVisitors'] = $monthly_clicks;
//$eventSummary->visits;
$response->viewData['monthClosedTransactions'] = $monthly_transaction_count;
//$eventSummary->purchases;
$response->viewData['monthRevenue'] = $monthly_total_commission;
//$monthAccountSummary->credits;
$response->viewData['todayVisitors'] = $today_clicks;
//$todayEventSummary->visits;
$response->viewData['todayClosedTransactions'] = $today_transaction_count;
//$todayEventSummary->purchases;
$response->viewData['todayRevenue'] = $today_total_commission;
//$todayAccountSummary->credits;
if (get_option(WPAM_PluginConfig::$AffEnableImpressions)) {
$response->viewData['monthImpressions'] = $db->getImpressionRepository()->getImpressionsForRange(strtotime(date("Y-m-01")), strtotime(date("Y-m-01", strtotime("+1 month"))), $affiliate->affiliateId);
$response->viewData['todayImpressions'] = $db->getImpressionRepository()->getImpressionsForRange(strtotime('today'), strtotime('tomorrow'), $affiliate->affiliateId);
}
return $response;
}
