/
keywords_chart.php
51 lines (34 loc) · 1.63 KB
/
keywords_chart.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
<?php $time_to = time();
$time_from = time() - 1296000;
$keywords = KeywordToLink::getInstance()->database->getAllLinksWithInformation();
$keyword_ids = array();
foreach($keywords as $keyword)
$keyword_ids[] = $keyword->id;
$link_statistics = KeywordToLink::getInstance()->database->getAllLinksClicksMAPForInterval($time_from, $time_to, $keyword_ids);
$display_information = array();
$first_line = array();
foreach($link_statistics as $link_date => $link_statistic) {
$to_add = date('F d, Y', strtotime($link_date));
$current_day_sum = 0;
foreach($keywords as $keyword)
$current_day_sum += (isset($link_statistic[$keyword->id]) ? $link_statistic[$keyword->id] : 0);
$to_add .= "\t " . $current_day_sum;
foreach($keywords as $keyword)
$to_add .= "\t" . (isset($link_statistic[$keyword->id]) ? $link_statistic[$keyword->id] : 0);
$display_information[$link_date] = $to_add;
}
ksort($display_information);
$display_information = implode("\n", $display_information);
?>
<div id="highcharts_information_container" style="display: none"><?php echo $display_information; ?></div>
<div id="highcharts_information">
</div>
<script>
LayoutHelperEasyChart.SetInformation(
'highcharts_information',
'Generated Clicks',
'<?php echo date('F d, Y', $time_from) .' - ' . date('F d, Y', $time_to);?>',
['Everything' <?php foreach($keywords as $keyword) echo ", '" . $keyword->keyword. "'"?>]
);
LayoutHelperEasyChart.SetInformationLines(jQuery('#highcharts_information_container').html());
</script>