Domoticz

Code: Select all

#!/usr/bin/php
<?php

/* Version 1.0 written by FunFair */
/* 06-03-2018 */

/* 
	Changelog version 1.0
	- first attempt to read out information from the boiler.

*/

/* Instructions:
	- Place script in Domoticz folder /home/pi/domoticz/scripts/p1_meter/ or desired folder.
	- Make sure Curl is installed (sudo apt-get install php-curl).
	- Make sure script is executable (chmod +x filename.php).
	- All echo's are used for debugging.
	- Put script in 'crontab -e' to run every minute. */ 
	  #Example crontab: (*/1 * * * * /home/pi/domoticz/scripts/cvketel/cvketel_data_json.php)
	
		
/* Set IP addresses and idx*/
$IPDomoticz = '192.168.0.200:8080'; #use 'username:password@domoticz-ip:port' in case of password protection.
$IPToon = '192.168.0.11';
$idx_pressure = 254;
$idx_temp = 255;
$idx_setpoint = 256;

/* Get current date */
$datum =  date("d-m-Y");
echo "Request for FROM date: " . $datum . "\n";
echo "Now: ". date("Y-m-d H:i:s") . "\n";

/* Get Boiler Pressure from Toon */
$file_string_pressure = file_get_contents("http://$IPToon/hcb_rrd?action=getRrdData&loggerName=thermstat_boilerChPressure&rra=30days&readableTime=1&nullForNaN=1&from=$datum");
$parsed_json = json_decode($file_string_pressure, true);

if ( empty($parsed_json)) {
        echo "Array is empty. Stop executing\n";
        return;
}

/* Get last value of array */
$keys = array_keys($parsed_json);
end($parsed_json);
$key = key($parsed_json);
$BoilerPressureToon = $parsed_json[$key];
echo "Boiler Pressure from Toon = " . $BoilerPressureToon. " Bar";
echo "\n";

/* Get Boiler Temperature from Toon */
$file_string_pressure = file_get_contents("http://$IPToon/hcb_rrd?action=getRrdData&loggerName=thermstat_boilerTemp&rra=30days&readableTime=1&nullForNaN=1&from=$datum");
$parsed_json = json_decode($file_string_pressure, true);

if ( empty($parsed_json)) {
        echo "Array is empty. Stop executing\n";
        return;
}

/* Get last value of array */
$keys = array_keys($parsed_json);
end($parsed_json);
$key = key($parsed_json);
$BoilerTempToon = $parsed_json[$key];
echo "Boiler Temperature from Toon = " . $BoilerTempToon. " degrees Celcius";
echo "\n";


/* Get Boiler Setpoint from Toon */
$file_string_pressure = file_get_contents("http://$IPToon/hcb_rrd?action=getRrdData&loggerName=thermstat_boilerSetpoint&rra=30days&readableTime=1&nullForNaN=1&from=$datum");
$parsed_json = json_decode($file_string_pressure, true);

if ( empty($parsed_json)) {
        echo "Array is empty. Stop executing\n";
        return;
}

/* Get last value of array */
$keys = array_keys($parsed_json);
end($parsed_json);
$key = key($parsed_json);
$BoilerSetpointToon = $parsed_json[$key];
echo "Boiler Setpoint from Toon = " . $BoilerSetpointToon. " degrees Celcius";
echo "\n";

/* write new values to Domoticz */
$WriteInitValue = curl_init("http://$IPDomoticz/json.htm?type=command&param=udevice&idx=$idx_pressure&nvalue=0&svalue=$BoilerPressureToon");
curl_exec($WriteInitValue);

$WriteInitValue = curl_init("http://$IPDomoticz/json.htm?type=command&param=udevice&idx=$idx_temp&nvalue=0&svalue=$BoilerTempToon");
curl_exec($WriteInitValue);

$WriteInitValue = curl_init("http://$IPDomoticz/json.htm?type=command&param=udevice&idx=$idx_setpoint&nvalue=0&svalue=$BoilerSetpointToon");
curl_exec($WriteInitValue);

?>

Code: Select all

-- Script used for Toon Thermostaat utility device, upon changing temp in Domoticz, temperature is sent to Toon. 
--
commandArray = {}

    ToonThermostatSensorName = uservariables['UV_ToonThermostatSensorName'] -- Sensor showing current setpoint
    ToonIP = uservariables['UV_ToonIP']
    
    for deviceName,deviceValue in pairs(devicechanged) do
        if (deviceName == ToonThermostatSensorName) then
            if uservariables['UV_ToonChangedByDomoticz'] == 1 then
                commandArray['Variable:UV_ToonChangedByDomoticz'] = '0'
            else
                SetPoint = otherdevices_svalues[ToonThermostatSensorName]
                ToonCommand = string.format('http://%s/happ_thermstat?action=setSetpoint&Setpoint=%s', ToonIP, SetPoint*100)
                
                print('Setting Toon setpoint to '.. SetPoint)
                commandArray['OpenURL'] = ToonCommand
            end
        end
    end

return commandArray

Code: Select all

-- Time script runs every minute, intended to sync Domoticz with Toon in case the value is changed on the physical device.
-- Updates Toon Thermostat Sensor to value set on Toon
-- Updates Toon Temperature Sensor to value set on Toon
-- Updates Toon Scenes switch based on program set on Toon
-- Updates Toon Auto Program switch to value set on Toon
-- Updates Toon program information text to value set on Toon

commandArray = {}

    ToonThermostatSensorName = uservariables['UV_ToonThermostatSensorName'] -- Sensor showing current setpoint
    ToonTemperatureSensorName = uservariables['UV_ToonTemperatureSensorName'] -- Sensor showing current room temperature
    ToonScenesSensorName  = uservariables['UV_ToonScenesSensorName'] -- Sensor showing current program
    ToonAutoProgramSensorName = uservariables['UV_ToonAutoProgramSensorName'] -- Sensor showing current auto program status
    ToonProgramInformationSensorName = uservariables['UV_ToonProgramInformationSensorName'] -- Sensor showing displaying program information status
    ToonIP = uservariables['UV_ToonIP']
    DomoticzIP = uservariables['UV_DomoticzIP']

    json = assert(loadfile "/dev-domoticz/scripts/lua/JSON.lua")() -- For Raspberry
    
    local handle = assert(io.popen(string.format('curl http://%s/happ_thermstat?action=getThermostatInfo', ToonIP)))
        local ThermostatInfo = handle:read('*all')
    handle:close()
    
    jsonThermostatInfo = json:decode(ThermostatInfo)
    
    currentSetpoint = tonumber(jsonThermostatInfo.currentSetpoint) / 100
    currentTemperature = tonumber(jsonThermostatInfo.currentTemp) / 100
    currentProgramState = tonumber(jsonThermostatInfo.programState)
    currentActiveState = tonumber(jsonThermostatInfo.activeState)
    currentNextTime = jsonThermostatInfo.nextTime
    currentNextSetPoint = tonumber(jsonThermostatInfo.nextSetpoint) / 100
    
    -- Update the thermostat sensor to current setpoint
    if otherdevices_svalues[ToonThermostatSensorName]*100 ~= currentSetpoint*100 then  
        print('Updating thermostat sensor to new set point: ' ..currentSetpoint)
        commandArray[1] = {['Variable:UV_ToonChangedByDomoticz'] = '1'} -- Set variable changed to 1 to prevent script ToonSetPoint from shooting an event at Toon
        commandArray[2] = {['UpdateDevice'] = string.format('%s|0|%s', otherdevices_idx[ToonThermostatSensorName], currentSetpoint)}
    end
    
    -- Update the temperature sensor to current room temperature
    if otherdevices_svalues[ToonTemperatureSensorName]*100 ~= currentTemperature*100 then 
        print('Updating the temperature sensor to new value: ' ..currentTemperature)
        commandArray[3] = {['UpdateDevice'] = string.format('%s|0|%s', otherdevices_idx[ToonTemperatureSensorName], currentTemperature)}
    end
    
    -- Update the toon scene selector sensor to current program state
    CurrentToonScenesSensorValue = otherdevices_svalues[ToonScenesSensorName]
    
    if currentActiveState == -1 then currentActiveState = '50' -- Manual
    elseif currentActiveState == 0 then currentActiveState = '40' -- Comfort
    elseif currentActiveState == 1 then currentActiveState = '30' -- Home
    elseif currentActiveState == 2 then currentActiveState = '20' -- Sleep
    elseif currentActiveState == 3 then currentActiveState = '10' -- Away
    end
    
    if CurrentToonScenesSensorValue ~= currentActiveState then  -- Update toon selector if it has changed
        print ('Updating Toon Scenes selector')
        commandArray[4] = {['UpdateDevice'] = string.format('%s|1|%s', otherdevices_idx[ToonScenesSensorName], currentActiveState)}
    end
    
    -- Updates the toon auto program switch 
    CurrentToonAutoProgramSensorValue = otherdevices_svalues[ToonAutoProgramSensorName]
    
    if currentProgramState == 0 then currentProgramState = '10' -- No
    elseif currentProgramState == 1 then currentProgramState = '20' -- Yes
    elseif currentProgramState == 2 then currentProgramState = '30' -- Temporary       
    end
    
    if CurrentToonAutoProgramSensorValue ~= currentProgramState then -- Update toon auto program selector if it has changed
        print ('Updating Toon Auto Program selector')
        commandArray[5] = {['UpdateDevice'] = string.format('%s|1|%s', otherdevices_idx[ToonAutoProgramSensorName], currentProgramState)}
    end
    
    -- Updates the toon program information text box
    CurrentToomProgramInformationSensorValue = otherdevices_svalues[ToonProgramInformationSensorName]
    if currentNextTime == 0 or currentNextSetPoint == 0 then
        ToonProgramInformationSensorValue = 'Op ' ..currentSetpoint.. '°'
    else
        ToonProgramInformationSensorValue = 'Om ' ..os.date('%H:%M', currentNextTime).. ' op ' ..currentNextSetPoint.. '°'
    end
    
    if CurrentToomProgramInformationSensorValue ~= ToonProgramInformationSensorValue then
        commandArray[6] = {['UpdateDevice'] = string.format('%s|0|%s', otherdevices_idx[ToonProgramInformationSensorName], ToonProgramInformationSensorValue)}
    end
        
--

return commandArray

Code: Select all

/* Version 1.0 written by Ierlandfan */
/* Version 1.0 modified by DennisD */
/* Version 2.0 rewritten by FunFair */
/* Version 2.1 update by FunFair */
/* Version 3.0 modified by glsf91 for using RRD */
/* Version 3.1 update by FunFair */
/* 05-03-2018 */

Code: Select all

Request for FROM date: 10-03-2018
Now: 2018-03-10 17:11:03
Electricity Usage Toon = 400 Watt
Electricity Production Toon = 0 Watt
Electricity LT counter from Toon = 9530159 Wh
Electricity NT counter from Toon = 8221494 Wh
Electricity production counter LT from Toon = 13 Wh
Electricity production counter NT from Toon = 50 Wh
{
   "status" : "OK",
   "title" : "Update Device"
}

Code: Select all

$datum =  date("d-m-Y");

Code: Select all

$datum =  date("d-m-Y e");

Code: Select all

Request for FROM date: 13-03-2018 Asia/Taipei

Code: Select all

/* Get current date */
date_default_timezone_set("Europe/Amsterdam");
echo "Timezone " . date_default_timezone_get() . "\n";
$datum =  date("d-m-Y");
echo "Request for FROM date: " . $datum . "\n";
echo "Now: ". date("Y-m-d H:i:s") . "\n";