<?php
$gPageTitle = "主卧";
include "../include/templateHeader.php";
include "../include/utils.php";
?>
<a href="../index.php" data-role="button" data-icon="arrow-l">返回</a>
<a href="masterBed.php" data-role="button" data-icon="refresh" data-ajax="false">更新</a>
<ul data-role="listview" data-inset="true" >
<li data-role="list-divider">实况</li>
<?php
$db = new DBHelper();
$query = "select * from tabDataHistory where fldNodeID2=15 order by fldID desc limit 1";
$results = $db->query($query);
if ($row = $results->fetchArray()) {
printf("<li>室温 %d.%d度 <span class='ui-li-count'>%s</span></li>", $row["fldData3"], $row["fldData4"], $row["fldCreatedOn"]);
printf("<li>亮度 %d相对值 <span class='ui-li-count'>%s</span></li>", $row["fldData1"], $row["fldCreatedOn"]);
}
$db->close();
?>
</ul>
<?php
include "../include/templateFooter.php";
public function end()
{
DBHelper::close();
$this->printUpdateFinishMsg();
}
break;
}
}
}
// if data not empty then store into DB
if (!empty($data)) {
Debug::logi("Seems to be a valid request... Try to decode JSON and save to DB.", 'REPORT');
$json = json_decode($data, true);
// check if device is in exception list
if (isset($json['device_id']) && !empty($json['device_id']) && $cfg->isInReportExceptionDevices($json['device_id'])) {
Debug::logi("Report ignored, device " . $json['device_id'] . " is in exception list.");
exit;
}
// open db connection
DBHelper::open();
$values = ReportHelper::buildMySQLValuesArr($json);
$result = DBHelper::insertReport($values);
if (!$result) {
Debug::loge('Inserting report data failed ! ' . DBHelper::getLastError(), 'REPORT');
Debug::loge('Report content ' . print_r($values, true), 'REPORT');
} else {
Debug::logi('Report inserted with success !', 'REPORT');
}
if ($cfg->sendMailOnReportReceived()) {
$package = explode('.', $json['PACKAGE_NAME']);
MailHelper::sendMail($cfg->getReportMailRecipients(), '[MABL] New ' . (isset($json['IS_SILENT']) && $json['IS_SILENT'] > 0 ? 'SILENT ' : '') . 'report received for ' . $package[count($package) - 1] . ' !', ReportHelper::createMailContent(!$result, $package, $json));
}
DBHelper::close();
} else {
Debug::loge('Invalid report request data ! ' . print_r($_REQUEST, true), 'REPORT');
}
