Domoticz

Code: Select all

        local function calculateYearTotal(rt)
            local yearTotal = 0
            local currentYear = dz.time.rawDate:sub(1,7)
            for id, result in  ipairs(rt) do 
                if rt[id].d:sub(1,7) == currentYear then
                    logWrite(rt[id].d .. " ==>> " .. rt[id].r1)
                    yearTotal = yearTotal + rt[id].r1
                end
            end
            for id, result in  ipairs(rt) do 
                if rt[id].d:sub(1,7) == currentYear then
                    logWrite(rt[id].d .. " ==>> " .. rt[id].r2)
                    yearTotal = yearTotal + rt[id].r2
                end
            end
            return yearTotal * 1000
        end    

Code: Select all

	    local currentYear = dz.time.year
	    dz.log("Current year: " .. currentYear , dz.LOG_FORCE)
	    
	    local previousYear = dz.time.year - 1 
	    dz.log(" Previous year: " .. previousYear , dz.LOG_FORCE)

Code: Select all

dz.time.rawDate:sub(1,7)

Code: Select all

-- Hier de managed counter vullen, die komt niet op het dashboard
-- Per week/maand/jaar

local httpResponses = "yearTotal"

return {
    on      =   {   
                    timer           =   { "every 8 hours" },
                    httpResponses   =   { httpResponses .. "*" } 
                },

    logging =   {   
                    level           =   domoticz.LOG_DEBUG, -- set to LOG_ERROR when script works as expected
                    marker          =   httpResponse   
                },
                
    execute = function(dz, item)
        -- ****************************** Your settings below this line ***************************************************
        usageDevice = dz.devices(1)          -- Replace xxxx with ID of energyDevice you want to track
        yearTotal = dz.devices(536)        -- Create as virtual managed counter (energy) and change yyyy to the ID of the new device
        -- ****************************** No changes required below this line *********************************************
        
        local function logWrite(str,level)
            dz.log(tostring(str),level or dz.LOG_DEBUG)
        end
        
        local function triggerJSON(id, period, delay)
            local delay = delay or 0
            local  URLString   =    dz.settings['Domoticz url'] .. "/json.htm?type=graph&sensor=counter&range=" .. 
                                    period .. "&idx=" .. id 
            dz.openURL({    url = URLString,
                            method = "GET",
                            callback = httpResponses .. "_" .. period}).afterSec(delay)                      
        end
        
        local function calculateYearTotal(rt)
            local yearTotal = 0
            local currentYear = dz.time.rawDate:sub(1,7)
            for id, result in  ipairs(rt) do 
                if rt[id].d:sub(1,7) == currentYear then
                    logWrite(rt[id].d .. " ==>> " .. rt[id].r1)
                    yearTotal = yearTotal + rt[id].r1
                end
            end
            for id, result in  ipairs(rt) do 
                if rt[id].d:sub(1,7) == currentYear then
                    logWrite(rt[id].d .. " ==>> " .. rt[id].r2)
                    yearTotal = yearTotal + rt[id].r2
                end
            end
            return yearTotal * 1000
        end    

        if not item.isHTTPResponse then
            triggerJSON(usageDevice.id, "year")
        elseif item.ok then                                      -- statusCode == 2xx
            yearTotal.update(0,calculateYearTotal(item.json.result))
        else
            logWrite("Could not get (good) data from domoticz. Error (" .. (item.statusCode or 999) .. ")"  ,dz.LOG_ERROR)
            logWrite(item.data)
        end
    end
}

Code: Select all

-- Hier de managed counter vullen, die komt niet op het dashboard
-- Per week/maand/jaar

local scriptVar = 'yearTotal'

return 
{
    on = 
    {   
        timer = 
        { 
            'every 8 hours', 
        },
        
        httpResponses =
        { 
            scriptVar .. '*',
        } 
    },

    logging =   
    {   
        level = domoticz.LOG_DEBUG, -- set to LOG_ERROR when script works as expected
        marker = scriptVar,   
    },
                
    execute = function(dz, item)
        -- ****************************** Your settings below this line ***************************************************
        usageDevice = dz.devices(35)     -- Replace with ID of P1 device you want to track
        currentYear = dz.devices(3487)    -- Create as virtual managed counter (energy returned) and change to the ID of the new device
        lastYear = dz.devices(3488)       -- Create as virtual managed (energy returned) and change to the ID of the new device
        -- ****************************** No changes required below this line *********************************************

        local function triggerJSON(id, period, delay)
            local  URLString = dz.settings['Domoticz url'] .. '/json.htm?type=graph&sensor=counter&range=' .. period .. '&idx=' .. id 
            dz.openURL(
            {
                url = URLString,
                callback = scriptVar .. '_' .. period
            }).afterSec(delay or 0)                      
        end
        
        local function calculateYearsTotal(rt)
            local totals = {}
            
            for id, result in  ipairs(rt) do 
                dz.log(rt[id].d .. ' ==>> ' .. ( rt[id].r1 + rt[id].r2 ), dz.LOG_DEBUG)
                totals[rt[id].d:sub(1,4)] = ( totals[rt[id].d:sub(1,4)] or 0 ) + rt[id].r1 + rt[id].r2 
            end
            
            return totals
        end    

        if not item.isHTTPResponse then
            triggerJSON(usageDevice.id, 'year')
        elseif item.ok then                                      -- statusCode == 2xx
           local totals = calculateYearsTotal(item.json.result)
           dz.utils.dumpTable(totals)
           currentYear.updateCounter(totals[tostring(dz.time.year)] * 1000 )
           lastYear.updateCounter(totals[tostring(dz.time.year - 1)] * 1000 )
        else
            dz.log('Could not get (good) data from domoticz. Error (' .. (item.statusCode or 999) .. ')'  ,dz.LOG_ERROR)
            dz.log(item,dz.LOG_DEBUG)
        end
    end
}

Code: Select all

-- Hier de managed counter vullen, die komt niet op het dashboard
-- Per week/maand/jaar

local scriptVar = 'yearTotal'

return
{
    on =
    {
        timer =
        {
            'every minute',
        },

        httpResponses =
        {
            scriptVar .. '*',
        }
    },

    logging =
    {
        level = domoticz.LOG_DEBUG, -- set to LOG_ERROR when script works as expected
        marker = scriptVar,
    },

    execute = function(dz, item)
        -- ****************************** Your settings below this line ***************************************************
        usageDevice = dz.devices(1)     -- Replace with ID of P1 device you want to track
        currentYear = dz.devices(562)    -- Create as virtual managed counter (energy returned) and change to the ID of the new device
        lastYear = dz.devices(563)       -- Create as virtual managed (energy returned) and change to the ID of the new device
        -- ****************************** No changes required below this line *********************************************

        local debug =  _G.logLevel == dz.LOG_DEBUG

        local function dumpSorted(t)
            local st = {}
            for key, _ in pairs(t) do
                table.insert(st, key)
            end
            table.sort(st)
            for _, key in ipairs(st) do
                dz.log(key .. ': '  ..t[key],dz.LOG_DEBUG)
            end
        end

        local function triggerJSON(id, period, delay)
            local  URLString = dz.settings['Domoticz url'] .. '/json.htm?type=graph&sensor=counter&range=' .. period .. '&idx=' .. id
            dz.openURL(
            {
                url = URLString,
                callback = scriptVar .. '_' .. period
            }).afterSec(delay or 0)
        end

        local function calculateYearsTotal(rt)
            local totals = {}

            for id, result in  ipairs(rt) do
                if debug then
                    totals[rt[id].d:sub(1,7)] = ( totals[rt[id].d:sub(1,7)] or 0 ) + rt[id].r1 + rt[id].r2
                end
                totals[rt[id].d:sub(1,4)] = ( totals[rt[id].d:sub(1,4)] or 0 ) + rt[id].r1 + rt[id].r2
            end

            return totals
        end

        if not item.isHTTPResponse then
            triggerJSON(usageDevice.id, 'year')
        elseif item.ok then                                      -- statusCode == 2xx
           local totals = calculateYearsTotal(item.json.result)
           if debug then dumpSorted(totals) end
           currentYear.updateCounter(totals[tostring(dz.time.year)] * 1000 )
           lastYear.updateCounter(totals[tostring(dz.time.year - 1)] * 1000 )
        else
            dz.log('Could not get (good) data from domoticz. Error (' .. (item.statusCode or 999) .. ')'  ,dz.LOG_ERROR)
            dz.log(item,dz.LOG_DEBUG)
        end
    end
}