/**
* Here we use multiple models to gather data for displaying graphs
* @param $type type to filter by 'member','team','company'
* @param $id id of type to filter by
* @return $graph_data gathered graph data
*/
public function getGraphData($type = null, $id = null)
{
//set default search data
if ($type == null) {
$type = 'member';
$id = UsersHelper::getUserId();
}
//deal data
$model = new Deal();
$model->set('archived', 0);
$deals_by_stage = $model->getGraphDeals('stage', $type, $id);
$deals_by_status = $model->getGraphDeals('status', $type, $id);
$lead_sources = $model->getLeadSources($type, $id);
$stage_names = array();
$stage_totals = array();
$status_names = array();
$status_totals = array();
$lead_source_names = array();
$lead_totals = array();
//revenue data
$model = new Revenue();
$monthly_revenue = $model->getMonthlyRevenue($type, $id);
$yearly_revenue = $model->getYearlyRevenue($type, $id);
//commission data
$model = new Commission();
$monthly_commissions = $model->getMonthlyCommission($type, $id);
$yearly_commissions = $model->getYearlyCommission($type, $id);
//get lead source names
if (count($lead_sources) > 0) {
foreach ($lead_sources as $lead) {
$lead_source_names[] = $lead['name'];
$lead_totals[] = $lead['y'];
}
}
//get weeks
$weeks = array();
$count = 0;
if ($monthly_revenue) {
foreach ($monthly_revenue as $week) {
$count++;
$weeks[] = "Week " . $count;
}
}
//get months
$months = DateHelper::getMonthNamesShort();
//generate graph data
$graph_data = array('deal_stage' => $deals_by_stage, 'stage_names' => $stage_names, 'stage_totals' => $stage_totals, 'deal_status' => $deals_by_status, 'status_names' => $status_names, 'status_totals' => $status_totals, 'lead_sources' => $lead_sources, 'lead_source_names' => $lead_source_names, 'lead_totals' => $lead_totals, 'monthly_revenue' => $monthly_revenue, 'yearly_revenue' => $yearly_revenue, 'monthly_commissions' => $monthly_commissions, 'yearly_commissions' => $yearly_commissions, 'months' => $months, 'weeks' => $weeks);
return $graph_data;
}