}
echo json_encode(array("aaData" => $collect));
break;
case "get-detail":
if (isset($_POST['id']) && $_POST['id'] != "") {
if ($query = $data->get_weather_by_id($_POST['id'])) {
while ($rs = $query->fetch_array()) {
echo "<tr><td>Suhu Maksimal</td><td>" . $rs['max_temp'] . "</td></tr>\n\t\t\t\t\t\t\t\t<tr><td>Suhu Rata - Rata</td><td>" . $rs['mean_temp'] . "</td></tr>\n\t\t\t\t\t\t\t\t<tr><td>Suhu Minimal</td><td>" . $rs['min_temp'] . "</td></tr>\n\t\t\t\t\t\t\t\t<tr><td>Suhu Titik Pengembunan (Dew Point)</td><td>" . $rs['dew_point'] . "</td></tr>\n\t\t\t\t\t\t\t\t<tr><td>Rata - Rata Suhu Titik Pengembunan</td><td>" . $rs['mean_dew'] . "</td></tr>\n\t\t\t\t\t\t\t\t<tr><td>Suhu Titik Pengembunan Minimal</td><td>" . $rs['min_dew'] . "</td></tr>\n\t\t\t\t\t\t\t\t<tr><td>Kelembaban Maksimal</td><td>" . $rs['max_humid'] . "</td></tr>\n\t\t\t\t\t\t\t\t<tr><td>Kelembaban Rata - Rata</td><td>" . $rs['mean_humid'] . "</td></tr>\n\t\t\t\t\t\t\t\t<tr><td>Kelembaban Minimal</td><td>" . $rs['min_humid'] . "</td></tr>\n\t\t\t\t\t\t\t\t<tr><td>Ketinggian Permukaan Air Laut Maksimal</td><td>" . $rs['max_sea_level'] . "</td></tr>\n\t\t\t\t\t\t\t\t<tr><td>Rata - Rata Ketinggian Permukaan Air Laut</td><td>" . $rs['mean_sea_level'] . "</td></tr>\n\t\t\t\t\t\t\t\t<tr><td>Ketinggian Permukaan Air Laut Minimal</td><td>" . $rs['min_sea_level'] . "</td></tr>\n\t\t\t\t\t\t\t\t<tr><td>Jarak Pandang Maksimal</td><td>" . $rs['max_visibility'] . "</td></tr>\n\t\t\t\t\t\t\t\t<tr><td>Rata - Rata Jarak Pandang</td><td>" . $rs['mean_visibility'] . "</td></tr>\n\t\t\t\t\t\t\t\t<tr><td>Jarak Pandang Minimal</td><td>" . $rs['min_visibility'] . "</td></tr>\n\t\t\t\t\t\t\t\t<tr><td>Kecepatan Angin Maksimal</td><td>" . $rs['max_wind'] . "</td></tr>\n\t\t\t\t\t\t\t\t<tr><td>Rata - Rata Kecepatan Angin</td><td>" . $rs['mean_wind'] . "</td></tr>\n\t\t\t\t\t\t\t\t<tr><td>Kecepatan Hembusan Angin Maksimal</td><td>" . $rs['max_gust'] . "</td></tr>\n\t\t\t\t\t\t\t\t<tr><td>Curah Hujan</td><td>" . $rs['precip'] . "</td></tr>\n\t\t\t\t\t\t\t\t<tr><td>Sebaran Awan</td><td>" . $rs['cloud_cover'] . "</td></tr>\n\t\t\t\t\t\t\t\t<tr><td>Arah Angin (Dalam Derajat)</td><td>" . $rs['wind_direction'] . "</td></tr>";
}
}
}
break;
case "tambah-cuaca":
$arr = array();
if (isset($_POST['maxtemp']) && $_POST['maxtemp'] != "" && isset($_POST['meantemp']) && $_POST['meantemp'] != "" && isset($_POST['mintemp']) && $_POST['mintemp'] != "" && isset($_POST['dewpoint']) && $_POST['dewpoint'] != "" && isset($_POST['meandew']) && $_POST['meandew'] != "" && isset($_POST['mindew']) && $_POST['mindew'] != "" && isset($_POST['maxhumid']) && $_POST['maxhumid'] != "" && isset($_POST['meanhumid']) && $_POST['meanhumid'] != "" && isset($_POST['minhumid']) && $_POST['minhumid'] != "" && isset($_POST['maxsealevel']) && $_POST['maxsealevel'] != "" && isset($_POST['meansealevel']) && $_POST['meansealevel'] != "" && isset($_POST['minsealevel']) && $_POST['minsealevel'] != "" && isset($_POST['maxvisibility']) && $_POST['maxvisibility'] != "" && isset($_POST['meanvisibility']) && $_POST['meanvisibility'] != "" && isset($_POST['minvisibility']) && $_POST['minvisibility'] != "" && isset($_POST['maxwind']) && $_POST['maxwind'] != "" && isset($_POST['meanwind']) && $_POST['meanwind'] != "" && isset($_POST['maxgust']) && $_POST['maxgust'] != "" && isset($_POST['precip']) && $_POST['precip'] != "" && isset($_POST['cloudcover']) && $_POST['cloudcover'] != "" && isset($_POST['event']) && $_POST['event'] != "" && isset($_POST['winddirection']) && $_POST['winddirection'] != "" && isset($_POST['tgl']) && $_POST['tgl'] != "") {
if ($result = $data->add($_POST['tgl'], $_POST['maxtemp'], $_POST['meantemp'], $_POST['mintemp'], $_POST['dewpoint'], $_POST['meandew'], $_POST['mindew'], $_POST['maxhumid'], $_POST['meanhumid'], $_POST['minhumid'], $_POST['maxsealevel'], $_POST['meansealevel'], $_POST['minsealevel'], $_POST['maxvisibility'], $_POST['meanvisibility'], $_POST['minvisibility'], $_POST['maxwind'], $_POST['meanwind'], $_POST['maxgust'], $_POST['precip'], $_POST['cloudcover'], $_POST['event'], $_POST['winddirection'])) {
$arr['status'] = TRUE;
$arr['msg'] = "Data tersimpan..";
} else {
$arr['status'] = FALSE;
$arr['msg'] = "Gagal menyimpan..";
}
} else {
$arr['status'] = FALSE;
$arr['msg'] = "Harap isi data dengan lengkap..";
}
echo json_encode($arr);
break;
case "hapus-cuaca":
$arr = array();
if (isset($_POST['id']) && $_POST['id'] != "") {
