// $temp = $temp + 10;
// //echo("$temp,");
//}
//}
// Special for me
$waterIn_sid = 3;
// 3
$waterOut_sid = 1;
// 1
$waterOut = lib_getLatestValue($waterOut_sid);
if ($waterOut == SXN_NO_VALUE) {
lib_log("CSH", "No value for WaterOut\n");
lib_log("CSH", "-----End-----\n");
//return;
}
$waterIn = lib_getLatestValue($waterIn_sid);
if ($waterIn == SXN_NO_VALUE) {
lib_log("CSH", "No value for WaterIn\n");
lib_log("CSH", "-----End-----\n");
//return;
}
$tdelta = $waterOut - $waterIn;
echo "{$waterOut} {$waterIn} delta={$tdelta}<br>";
system("ls *.ip > ipList.work");
lib_listIpFiles(1, "ipList.work");
lib_readDataTypes();
$g_dbM1->selectAllFromTable(SXN_ADMIN_TABLE_STREAMS, "");
//$numRes = $g_dbM1->retrieveNumberOfResults();
//echo("<br>Number of SIDs: $numRes<br>");
echo "<table border=\"1\">";
echo "<tr>";
if ($do == 'photo') {
$sid = 7;
$command = 'FF_PHOTO';
$parameters = ' ';
$order = $command . ' ' . $parameters;
$valueArray = array($sid, $order, 'new');
$columnArray = array(SXN_CONTROL_COMMANDS_COLUMN_SID, SXN_CONTROL_COMMANDS_COLUMN_COMMAND, SXN_CONTROL_COMMANDS_COLUMN_STATUS);
$g_dbM3->insertRow(SXN_CONTROL_TABLE_COMMANDS, $columnArray, $valueArray);
$sid = 8;
$command = 'FF_PHOTO';
$parameters = ' ';
$order = $command . ' ' . $parameters;
$valueArray = array($sid, $order, 'new');
$columnArray = array(SXN_CONTROL_COMMANDS_COLUMN_SID, SXN_CONTROL_COMMANDS_COLUMN_COMMAND, SXN_CONTROL_COMMANDS_COLUMN_STATUS);
$g_dbM3->insertRow(SXN_CONTROL_TABLE_COMMANDS, $columnArray, $valueArray);
}
$sid302 = lib_getLatestValue(302);
// el
$sid7 = system("ls ../sxn_photo/*sid7*|tail -n 1");
$sid8 = system("ls ../sxn_photo/*sid8*|tail -n 1");
echo "<body>";
echo "<h1><a href=\"sxn_nytomta.php\">Nytomta</h1><br>";
echo "<h2><a href=\"sxn_nytomta.php?do=photo\">Ta bild </a></h2>";
echo "<h2><a href=\"sxn_nytomta.php\"> Uppdatera</a></h2>";
echo "<h1>Elektricitet {$sid302} Watt</h1> <br>";
echo "<img src=\"{$sid7}\" alt=\"Nytomta Camera 7\" width=\"600\" height=\"500\" /><br>";
echo "<img src=\"{$sid8}\" alt=\"Nytomta Camera 8\" width=\"600\" height=\"500\" />";
echo "</body></html>";
?>
function doIt()
{
$sid_lat = 801;
$sid_lon = 802;
$sid_battery_status = 803;
$latitude = lib_getLatestValue($sid_lat);
if ($latitude == SXN_NO_VALUE) {
lib_log("CSH", "No value for latitud t\n");
lib_log("CSH", "-----End-----\n");
}
$longitude = lib_getLatestValue($sid_lon);
if ($longitude == SXN_NO_VALUE) {
lib_log("CSH", "No value for longitude t\n");
lib_log("CSH", "-----End-----\n");
}
$battery_status = lib_getLatestValue($sid_battery_status);
if ($battery_status == SXN_NO_VALUE) {
lib_log("CSH", "No value for battery status t\n");
lib_log("CSH", "-----End-----\n");
}
echo "Mapping ";
}
$targetTemp = (int) lib_recall($labelTargetTemperature) - 1.0;
lib_remember($labelTargetTemperature, $targetTemp);
}
$targetTemp = (int) lib_recall($labelTargetTemperature);
$burnerStatus = (int) lib_recall("CSH_smokeDir");
if ($burnerStatus == 1) {
$burner_ON_OFF = "ON";
}
if ($burnerStatus == 2) {
$burner_ON_OFF = "OFF";
}
$waterTempOut = lib_getLatestValue(1);
$waterTempIn = lib_getLatestValue(3);
$outdoorTemp = lib_getLatestValue(9);
$indoorTemp = lib_getLatestValue(2);
$smokeTemp = lib_getLatestValue(4);
$energy = 100 * ($waterTempOut - $waterTempIn);
echo "<body>";
echo "<table border=\"1\">";
echo "<tr><td><a href=\"sxn_csh.php\">Control Saxen Heater</a></td></tr>";
echo "<tr><td><a href=\"sxn_csh.php?do=inc\">Target + </a></td></tr>";
echo "<tr><td><a href=\"sxn_csh.php?do=dec\">Target - </a></td></tr>";
echo "<tr><td><a href=\"sxn_csh.php?do=log\"> View Log</a></td></tr>";
echo "<tr><td><a href=\"sxn_csh.php?do=csl\"> Clear Log</a></td></tr>";
echo "<tr><td><a href=\"sxn_csh.php\"> Uppdatera</a></td></tr>";
echo "</table>";
echo "<table border=\"1\">";
if ($burner_ON_OFF == "ON") {
echo "<tr><td>Burner Status</td><td bgcolor=\"#37a30e\">{$burner_ON_OFF}</td></tr>";
}
if ($burner_ON_OFF == "OFF") {
$numRes = $dbM->retrieveNumberOfResults();
if ($numRes == 1) {
while ($data = $dbM->retrieveResult()) {
if ($mid == SXN_DATA) {
$tag = $data[SXN_ADMIN_STREAMS_COLUMN_TAG];
//if($tag) $name = $tag;
//echo SXN_USER, SXN_PASSWORD, \"localhost\", SXN_DATABASE_COLLECTOR)";
$dbC = new DataCollector(SXN_USER, SXN_PASSWORD, "localhost", SXN_DATABASE_COLLECTOR);
$dbC->openDataBase();
$success = $dbC->insertData($sid, $dd);
echo "{$sid} {$dd} DATA";
lib_executeSidFunction($sid);
getControlMessage($sid);
}
if ($mid == SXN_LATEST) {
$value = lib_getLatestValue($sid);
echo "{$sid}:{$value}:LATEST";
}
if ($mid == SXN_DERLATEST) {
$value = lib_getLatestDerivative($sid);
echo "{$sid}:{$value}:DERLATEST";
}
if ($mid == SXN_MAILBOX) {
lib_executeSidFunction($sid);
getControlMessage($sid);
echo "{$sid} {$value} MAILBOX";
}
}
}
}
} else {
function lib_listFileContent($mode, $filename)
{
$handle = fopen($filename, "r");
if ($handle) {
while (($line = fgets($handle)) !== false) {
sscanf($line, "%d %s %s %s %s", $sid, $appid, $ip, $yymmdd, $hhmmss);
$stemp = $yymmdd . ' ' . $hhmmss;
$now = date("Y-m-d H:i:s");
//$stemp = '2015-12-27 12:10:12';
//$now = '2015-12-31 16:15:15';
$start = strtotime($stemp);
$end = strtotime($now);
$temp = $end - $start;
$days = floor($temp / 86400);
$rest = $temp % 86400;
$hours = floor($rest / 3600);
$rest = $temp % 3600;
$minutes = floor($rest / 60);
$seconds = $temp % 60;
$nmin = floor($temp / 60);
$latest = lib_getLatestValue($sid);
if ($mode == 1) {
if ($nmin >= 0) {
if ($nmin < 60) {
echo "<tr><td>";
echo "<img src=\"image/online.png\" alt=\"online\" width=64 height=32>";
echo "</td>";
echo "<td><p style=\"color:#000000\">{$filename}</td><td> [{$ip}]</td><td>[{$appid}]</td><td>{$nmin}</td><td>{$latest}</td></p>";
echo "</tr>";
}
if ($nmin >= 60) {
echo "<tr><td>";
echo "<img src=\"image/offline.png\" alt=\"offline\" width=64 height=32>";
echo "</td>";
echo "<td><p style=\"color:#000000\">{$filename}</td><td> [{$ip}]</td><td>[{$appid}]</td><td>{$nmin}</td><td>{$latest}</td></p>";
echo "</tr>";
//echo("<p style=\"color:#0099ff\">$filename [$ip][$appid] Offline($days days $hours hours $minutes minutes) $stemp</p>");
}
} else {
if ($nmin < 0) {
echo "<p style=\"color:#CD0000\">{$filename} [{$ip}][{$appid}] Error({$nmin})</p>";
}
}
}
}
if ($mode == 2) {
if ($nmin >= 0) {
if ($nmin < 60) {
echo " 1";
}
if ($nmin >= 60) {
echo " 2";
}
}
if ($nmin < 0) {
echo " 3";
}
}
} else {
echo "Error lib_listFileContent({$filename})";
}
fclose($handle);
}
