<?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'); }