private function getGraphData($type, $query_ids) { $results = array('cnt' => $type == 'keyword' ? array('facebook' => array(), 'twitter' => array()) : array(), 'min' => 0, 'max' => 0); $search = new Default_Model_DbTable_Search(); foreach ($search->getGraphInfo($query_ids) as $obj) { $darr = getdate($obj['search_published']); $date = mktime(0, 0, 0, $darr['mon'], $darr['mday'], $darr['year']); $campaign = $type == 'keyword' ? $obj['search_source'] : $obj['query_id']; if (isset($results['cnt'][$campaign][$date])) { $results['cnt'][$campaign][$date]++; } else { $results['cnt'][$campaign][$date] = 1; } $results['min'] = $results['min'] && $results['min'] < $date ? $results['min'] : $date; $results['max'] = $results['max'] && $results['max'] > $date ? $results['max'] : $date; } $search_index = new Default_Model_DbTable_SearchIndex(); foreach ($search_index->getGraphInfo($query_ids) as $obj) { $campaign = $type == 'keyword' ? $obj['index_source'] : $obj['query_id']; if (isset($results['cnt'][$campaign][$obj['index_date']])) { $results['cnt'][$campaign][$obj['index_date']] += $obj['index_count']; } else { $results['cnt'][$campaign][$obj['index_date']] = $obj['index_count']; } $results['min'] = $results['min'] && $results['min'] < $obj['index_date'] ? $results['min'] : $obj['index_date']; $results['max'] = $results['max'] && $results['max'] > $obj['index_date'] ? $results['max'] : $obj['index_date']; } return $results; }