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;
}
