function make_wind_csv($fobj, $start_ts, $end_ts)
{
$wharfColumnToHeaderMap = array('dateUTC' => 'Time (UTC)', 'windSpeed' => 'Windspeed (MPH)', 'windDir' => 'Wind Heading (Deg)', 'turbineAmps' => 'Wind Turbine Current (Amps)', 'ADC2' => 'Divert-load (Amps)', '24*turbineAmps' => 'Wind Turbine Power (Watts)', '.8*POWER(ADC2,2)' => 'Divert-load power (Watts)', '24*turbineAmps/6' => 'Wind Turbine Power (Watt-hours) rectangular estimate', '.8*POWER(ADC2,2)/6' => 'Divert-load Power (Watt-hours) rectangular estimate');
fputcsv($fobj, array_values($wharfColumnToHeaderMap));
if ($start_ts != NULL) {
if ($end_ts != NULL) {
$query = "SELECT " . join(', ', array_keys($wharfColumnToHeaderMap)) . " FROM wharf_data WHERE utime >= " . $start_ts . " and utime <= " . $end_ts . " ORDER BY utime asc";
} else {
$query = "SELECT " . join(', ', array_keys($wharfColumnToHeaderMap)) . " FROM wharf_data WHERE utime >= " . $start_ts . " ORDER BY utime asc";
}
} elseif ($end_ts != NULL) {
$query = "SELECT " . join(', ', array_keys($wharfColumnToHeaderMap)) . " FROM wharf_data WHERE utime <= " . $end_ts . " ORDER BY utime asc";
} else {
$query = "SELECT " . join(', ', array_keys($wharfColumnToHeaderMap)) . " FROM wharf_data WHERE utime >= " . (time() - 24 * 3600 * 14) . " ORDER BY utime asc";
}
query2csv($fobj, $query);
}
// $highlightSQL =& Text_Highlighter::factory('SQL',array('numbers'=>true));
// echo "Executed QUERY : ";
// echo $highlightSQL->highlight($sql_query);
highlight_string("Executed QUERY : " . $sql_query);
echo "<BR><BR>";
$results = execute_query($sql_query);
// print_r($results);
// echo "<BR><BR>";
if ($results == "1") {
echo "<table><tr><td>Query Successful!</td></tr></table>";
} else {
query2table($results);
$result2 = execute_query($sql_query);
query2xls($result2, 'query.xls');
$result3 = execute_query($sql_query);
query2csv($result3, 'query.csv');
?>
<P><A HREF="query.xls">Αποτελέσματα σε Excel</A></P>
<P><A HREF="query.csv">Αποτελέσματα σε CSV</A></P>
<?php
}
mysql_close($dbconnection);
} else {
?>
<FORM METHOD=POST action="query.php">
<input type="text" id="query" style="font-family: courier new" size="120" name="query" value="SELECT * FROM "/>
<input type="submit" style="font-family: courier new"/>
<input type="button" style="font-family: courier new" value="Καθαρισμός" onclick="document.all.query.value='';"/>
</form>
