Domoticz

Code: Select all

2020-11-09 23:08:00.445 Status: dzVents: !Info: JSON: {
2020-11-09 23:08:00.445 "result" :
2020-11-09 23:08:00.445 [
2020-11-09 23:08:00.445 {
2020-11-09 23:08:00.445 "d" : "2020-10-09",
2020-11-09 23:08:00.445 "ta" : 12.529999999999999,
2020-11-09 23:08:00.445 "te" : 15.0,
2020-11-09 23:08:00.445 "tm" : 10.0
2020-11-09 23:08:00.445 },
2020-11-09 23:08:00.445 {
2020-11-09 23:08:00.445 "d" : "2020-10-10",
2020-11-09 23:08:00.445 "ta" : 10.4,
2020-11-09 23:08:00.445 "te" : 13.0,
2020-11-09 23:08:00.445 "tm" : 8.0
2020-11-09 23:08:00.445 },
etc...

Code: Select all

for _, record in ipairs(item.json.result) do
    if record.d == '2020-10-09' then

        dz.log('Max temperature at ' .. record.d  .. ' was ' .. dz.utils.round(record.te, 1) ..  ' °C' , dz.LOG_FORCE)
        dz.log('Min temperature at ' .. record.d  .. ' was ' .. dz.utils.round(record.tm, 1) ..  ' °C' , dz.LOG_FORCE)
        dz.log('Avg temperature at ' .. record.d  .. ' was ' .. dz.utils.round(record.ta, 1) ..  ' °C' , dz.LOG_FORCE)
        break
    end
end

Code: Select all

return {
	on = {
		devices = {},
		timer = {"at 23:45"
		    },
		httpResponses = {"averageTemp"  -- callback trigger
		    },
	},
	data = {},
	logging = {},
	execute = function(dz, item)
	
    local function logWrite( msg)
            dz.log( tostring(msg), dz.LOG_FORCE)
    end
	
	    
    if (item.isTimer) then
        logWrite("Calling dz temp average..")
        dz.openURL({
            -- 131 outdoor temp sensor
            url = "http://ip-adres:port/json.htm?type=graph&sensor=temp&idx=131&range=month",
            callback = "averageTemp",
        })
    end

    if (item.isHTTPResponse and item.callback == "averageTemp" and item.ok) then
        logWrite("Processing tempTable")
        local tempTable = dz.utils.fromJSON(item.data)
        local heatingstart = 18 -- standard correction factor
        local gd = 0 -- default to zero
        local today = 32 -- direct access, the current day is always the last of 32 entries, except when you first start measuring
        if (heatingstart-tempTable.result[today]["ta"]) > 0 then 
            gd = heatingstart-tempTable.result[today]["ta"]
            -- idx 267 Graaddagen dummy sensor
            dz.devices(267).updateTemperature(gd)
        end
    end

end
}

Code: Select all

local scriptVar = 'averageTemp'

return
{
    on =
    {
        timer =
        {
            'at 23:45',
        },

        httpResponses =
        {
            scriptVar,
        },
    },

    logging =
    {
        level = domoticz.LOG_DEBUG, -- set to domoticz.LOG_ERROR when all OK
        marker = scriptVar,
    },

    execute = function(dz, item)
        local _ = dz.utils._           -- lodash

        if item.isTimer then
            dz.log('Calling dz temp average..', dz.LOG_DEBUG)

            dz.openURL(
            {
                -- 131 outdoor temp sensor
                url = dz.settings['Domoticz url'] ..  '/json.htm?type=graph&sensor=temp&idx=131&range=month',
                callback = scriptVar,
            })
            return
        end

        if item.isHTTPResponse and item.isJSON then
            local heatingStart = 18 -- standard correction factor
            local rt = item.json.result

            dz.log('Finding today in the result table using lodash find', dz.LOG_DEBUG)
            local today = _.find(rt, function (rt) return rt.d == dz.time.rawDate end )

            if today and ( heatingStart - today.ta ) > 0 then
                -- idx 267 Graaddagen dummy sensor
                dz.log('Average temp for today is ' .. dz.utils.round(today.ta, 2 ) .. ' °C ', dz.LOG_DEBUG)
                dz.devices(267).updateTemperature( dz.utils.round( today.ta, 2 ) )
            end
        else
            dz.log('Return table is not OK', dz.LOG_ERROR)
            dz.log(item, dz.LOG_DEBUG)
        end
    end
}