function wp_red_caps_options_page()
{
$new_key = $_GET["key_gen"];
if ($new_key == 'y') {
$length = 5;
//should probably make this a function
$randystring_one = substr(str_shuffle("0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ+!"), 0, $length);
$randystring_two = substr(str_shuffle("0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ+!"), 0, $length);
$randystring_three = substr(str_shuffle("0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ+!"), 0, $length);
$randystring_four = substr(str_shuffle("0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ+!"), 0, $length);
$randy_api_key = $randystring_one . $randystring_two . $randystring_three . $randystring_four;
update_option('wp_red_caps_key', $randy_api_key);
}
$sql = "SELECT COUNT(id) as num, type FROM wp_red_caps_data GROUP BY type;";
?>
<style>
a.button {
-webkit-appearance: button;
-moz-appearance: button;
appearance: button;
text-decoration: none;
color: initial;
}
</style>
<?php
$stored_api_key = get_option('wp_red_caps_key');
echo '<h1>Heart Red Caps</h1>';
global $wpdb;
$results = $wpdb->get_var('SELECT COUNT(id) AS NUM FROM wp_red_caps_data');
$totalIssues = $results;
echo '<h3>Total Incidents: ' . $results . '</h3>';
echo '<hr>';
$sql = "SELECT COUNT(id) as num, type FROM wp_red_caps_data GROUP BY type;";
?>
<div id="piechart" style="width: 700px; height: 500px;float:left;"></div>
<div id="columnchart_plain" style="width: 700px; height: 500px;float:left;"></div>
<br style="clear:left;"/>
<div id="piechart1" style="width: 700px; height: 500px;float:left;"></div>
<div id="columnchart_plain1" style="width: 700px; height: 500px;float:left;"></div>
<script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
<script type="text/javascript">
google.charts.load('current', {'packages':['corechart']});
google.charts.setOnLoadCallback(drawChart);
function drawChart() {
var data = google.visualization.arrayToDataTable(<?php
makeData($sql);
?>
);
var options = {
title: 'Total Issues'
};
var chart = new google.visualization.PieChart(document.getElementById('piechart'));
chart.draw(data, options);
}
</script>
<script type="text/javascript">
google.charts.setOnLoadCallback(drawChart);
function drawChart() {
var data = google.visualization.arrayToDataTable(<?php
makeData($sql);
?>
);
var options = {
title: "Total Issues Per Type",
width: 700,
height: 500,
bar: {groupWidth: '95%'},
legend: { position: 'none' },
};
var chart = new google.visualization.ColumnChart(document.getElementById('columnchart_plain'));
chart.draw(data, options);
}
</script>
<?php
$sql = "SELECT COUNT(id) as num FROM wp_red_caps_data WHERE police_contacted = 1;";
$calls = $wpdb->get_results($sql);
$calls = $calls[0];
$called = $calls->num;
$totalIssues = $totalIssues - $called;
?>
<script type="text/javascript">
google.charts.setOnLoadCallback(drawChart);
function drawChart() {
var data = google.visualization.arrayToDataTable([['Called','Num'],['No',<?php
echo $totalIssues;
?>
],['Yes',<?php
echo $called;
?>
]]);
var options = {
title: 'Police Involvement'
};
var chart = new google.visualization.PieChart(document.getElementById('piechart1'));
chart.draw(data, options);
}
</script>
<?php
$sql = "SELECT COUNT(id) as num, reporter_id FROM wp_red_caps_data GROUP BY reporter_id;";
?>
<script type="text/javascript">
google.charts.setOnLoadCallback(drawChart);
function drawChart() {
var data = google.visualization.arrayToDataTable(<?php
makeData($sql);
?>
);
var options = {
title: "Total Issues Per Reporter",
width: 700,
height: 500,
bar: {groupWidth: '95%'},
legend: { position: 'none' },
};
var chart = new google.visualization.ColumnChart(document.getElementById('columnchart_plain1'));
chart.draw(data, options);
}
</script>
<?php
echo '<div style="display:none;">Below is the API KEY that allows the mobile application to connect to this WordPress API. Should you need to generate a new key, all mobile applications currently in use would need to be udated.<br><br>
API KEY: ' . $stored_api_key . '<br><br><a href="/wp-admin/options-general.php?page=wp_red_caps&key_gen=y" class="button">Create a new API key</a></div>';
}
$file .= makeData($movie->trailer);
$file .= makeData($movie->notes);
$file .= makeData($movie->taglines);
$file .= makeData($movie->plotoutline);
$file .= makeData($movie->plots);
$file .= makeData($movie->languages);
$file .= makeData($movie->subtitles);
$file .= makeData($movie->audio);
$file .= makeData($movie->video);
$file .= makeData($movie->country);
$file .= makeData($movie->genres);
$file .= makeData($movie->director);
$file .= makeData($movie->writer);
$file .= makeData($movie->producer);
$file .= makeData($movie->music);
$file .= makeData($movie->cast);
$file .= $NEWLINE;
}
$file = utf8_decode($file);
ob_start();
ob_clean();
header("Content-Disposition: attachment; filename=\"export.csv\"");
header("Content-type: application/csv; charset=utf-8");
header("Pragma: cache");
header("Cache-Control: public, must-revalidate, max-age=0");
header("Connection: close");
header("Expires: " . date("r", time() + 60 * 60));
header("Last-Modified: " . date("r", time()));
header("Content-length: " . strlen($file) . "\r\n");
echo $file;
ob_flush();