Domoticz

Nefsolive wrote: ↑Tuesday 25 August 2020 10:32 I need help in creating a script that gives me the total cost per month of KWh, but with a date starting on the day (ex 13 of each month and ending on 12 of each month).

I have OWL CM 180.

waaren wrote: ↑Tuesday 25 August 2020 10:44

Nefsolive wrote: ↑Tuesday 25 August 2020 10:32 I need help in creating a script that gives me the total cost per month of KWh, but with a date starting on the day (ex 13 of each month and ending on 12 of each month).

I have OWL CM 180.

What is the name / deviceType and devicesubType in domoticz of this device as seen on the device tab ?

Nefsolive wrote: ↑Tuesday 25 August 2020 10:55 The deviceType is "general" and devicesubType is "kWh".

--[[ 
        script calculates the cost of energy of one kwH device
        KwH costs need to be set in domoticz meters / coiunters settings 

]]--

local scriptVar = 'getCosts'

return 
{
    on = 
    {
        timer = 
        {
            'at 08:00' , --- change to your liking
        },
        
        devices = 
        {
            scriptVar,
        },
        
        httpResponses = 
        {
            scriptVar .. '_*',  
        },
    },

    data = 
    {
        KwHCost = { initial = 0 },
    },
    
    logging = 
    {
        level = domoticz.LOG_DEBUG, -- change to domoticz.LOG_ERROR when all on
        marker = scriptVar,
    },
    
    execute = function(dz, item)

        local sourceDeviceIndex = 2872 -- change to device you want to measure
        local startDayOfMonth = 13

        if item.isTimer or item.isDevice then
            costURL = dz.settings['Domoticz url'] .. '/json.htm?type=settings' -- to get cost setting
            countURL = dz.settings['Domoticz url'] .. '/json.htm?type=graph&sensor=counter&range=year&idx=' .. sourceDeviceIndex -- to get cost setting
            
            dz.openURL(
            {
                url = costURL,
                callback = scriptVar .. '_costs', 
            })
            
            dz.openURL(
            {
                url = countURL,
                callback = scriptVar .. '_logCount', 
            }).afterSec(5)
            return
        end
        
        local function makeMonth(delta)
			if math.floor(delta) ~= delta or delta  < - 11 or delta > 11 then 
                dz.log('Only integers -11 - +11 allowed',dz.LOG_ERROR) 
                return
            end
            local year = dz.time.year 
            if delta < 0 and dz.time.month + delta < 0 then year = dz.time.year - 1 end 
            if delta > 0 and dz.time.month + delta > 12 then year = dz.time.year + 1 end 
			return ( dz.time.month + delta) % 12, year
        end
        
        
        local function getCost(t, day)
            local startMonth, startYear = makeMonth(-1)
            if dz.time.day < day then startMonth, startYear = makeMonth(-2) end
            startDate =  startYear .. '-' .. dz.utils.leadingZeros(startMonth, 2) .. '-' .. dz.utils.leadingZeros(day, 2) 
            endDate =  dz.time.year .. '-' .. dz.utils.leadingZeros(( startMonth + 1 ) % 12 , 2) .. '-' .. dz.utils.leadingZeros((day - 1), 2) 
            local minCounter = 10^32
            local maxCounter = 0
            for _,r in ipairs(t) do
                if tonumber(r.c) > maxCounter and r.d >= startDate and r.d <= endDate then maxCounter = tonumber(r.c) end
                if tonumber(r.c) < minCounter and r.d >= startDate and r.d <= endDate then minCounter = tonumber(r.c) end
            end
            return dz.utils.round( ( maxCounter - minCounter ) * dz.data.KwHCost, 2 ), startDate, endDate
        end

        if item.ok and item.isJSON then
            if item.trigger:find('_costs') then
                dz.data.KwHCost = item.json.CostEnergy
            else
                local energyCost, startDate, endDate = getCost(item.json.result, startDayOfMonth)
                dz.log('Energycost for device ' .. dz.devices(sourceDeviceIndex).name .. ' between ' .. startDate ..' and ' .. endDate .. ' is: € ' .. energyCost, dz.LOG_FORCE  )
            end
        else
            dz.log('There was a problem handling' .. item.trigger, dz.LOG_ERROR)
            dz.log(item, dz.LOG_DEBUG)
        end

    end
}

waaren wrote: ↑Tuesday 25 August 2020 14:37

Nefsolive wrote: ↑Tuesday 25 August 2020 10:55 The deviceType is "general" and devicesubType is "kWh".

Can you check with this one?
For now it only reports the costs to the domoticz log. If you want it in a device or variable let me know.

Code: Select all

--[[ 
        script calculates the cost of energy of one kwH device
        KwH costs need to be set in domoticz meters / coiunters settings 

]]--

local scriptVar = 'getCosts'

return 
{
    on = 
    {
        timer = 
        {
            'at 08:00' , --- change to your liking
        },
        
        devices = 
        {
            scriptVar,
        },
        
        httpResponses = 
        {
            scriptVar .. '_*',  
        },
    },

    data = 
    {
        KwHCost = { initial = 0 },
    },
    
    logging = 
    {
        level = domoticz.LOG_DEBUG, -- change to domoticz.LOG_ERROR when all on
        marker = scriptVar,
    },
    
    execute = function(dz, item)

        local sourceDeviceIndex = 2872 -- change to device you want to measure
        local startDayOfMonth = 13

        if item.isTimer or item.isDevice then
            costURL = dz.settings['Domoticz url'] .. '/json.htm?type=settings' -- to get cost setting
            countURL = dz.settings['Domoticz url'] .. '/json.htm?type=graph&sensor=counter&range=year&idx=' .. sourceDeviceIndex -- to get cost setting
            
            dz.openURL(
            {
                url = costURL,
                callback = scriptVar .. '_costs', 
            })
            
            dz.openURL(
            {
                url = countURL,
                callback = scriptVar .. '_logCount', 
            }).afterSec(5)
            return
        end
        
        local function makeMonth(delta)
			if math.floor(delta) ~= delta or delta  < - 11 or delta > 11 then 
                dz.log('Only integers -11 - +11 allowed',dz.LOG_ERROR) 
                return
            end
            local year = dz.time.year 
            if delta < 0 and dz.time.month + delta < 0 then year = dz.time.year - 1 end 
            if delta > 0 and dz.time.month + delta > 12 then year = dz.time.year + 1 end 
			return ( dz.time.month + delta) % 12, year
        end
        
        
        local function getCost(t, day)
            local startMonth, startYear = makeMonth(-1)
            if dz.time.day < day then startMonth, startYear = makeMonth(-2) end
            startDate =  startYear .. '-' .. dz.utils.leadingZeros(startMonth, 2) .. '-' .. dz.utils.leadingZeros(day, 2) 
            endDate =  dz.time.year .. '-' .. dz.utils.leadingZeros(( startMonth + 1 ) % 12 , 2) .. '-' .. dz.utils.leadingZeros((day - 1), 2) 
            local minCounter = 10^32
            local maxCounter = 0
            for _,r in ipairs(t) do
                if tonumber(r.c) > maxCounter and r.d >= startDate and r.d <= endDate then maxCounter = tonumber(r.c) end
                if tonumber(r.c) < minCounter and r.d >= startDate and r.d <= endDate then minCounter = tonumber(r.c) end
            end
            return dz.utils.round( ( maxCounter - minCounter ) * dz.data.KwHCost, 2 ), startDate, endDate
        end

        if item.ok and item.isJSON then
            if item.trigger:find('_costs') then
                dz.data.KwHCost = item.json.CostEnergy
            else
                local energyCost, startDate, endDate = getCost(item.json.result, startDayOfMonth)
                dz.log('Energycost for device ' .. dz.devices(sourceDeviceIndex).name .. ' between ' .. startDate ..' and ' .. endDate .. ' is: € ' .. energyCost, dz.LOG_FORCE  )
            end
        else
            dz.log('There was a problem handling' .. item.trigger, dz.LOG_ERROR)
            dz.log(item, dz.LOG_DEBUG)
        end

    end
}

Nefsolive wrote: ↑Wednesday 26 August 2020 10:54 I really wanted to pass the values to a device dummy text, you can help me how.

--[[ 
        script calculates the cost of energy of one kwH device
        KwH costs need to be set in domoticz meters / counters settings 

]]--

local scriptVar = 'getCosts'

return 
{
    on = 
    {
        timer = 
        {
            'at 08:00' , --- change to your liking
        },
        
        devices = 
        {
            scriptVar,
        },
        
        httpResponses = 
        {
            scriptVar .. '_*',  
        },
    },

    data = 
    {
        KwHCost = { initial = 0 },
    },
    
    logging = 
    {
        level = domoticz.LOG_DEBUG, -- change to domoticz.LOG_ERROR when all on
        marker = scriptVar,
    },
    
    execute = function(dz, item)

        local sourceDeviceIndex = 2872 -- change to device you want to measure
        local startDayOfMonth = 13
        local textDevice = dz.devices('getCosts' )  -- change to devicename you want to see the text message (virtual text device)

        if item.isTimer or item.isDevice then
            costURL = dz.settings['Domoticz url'] .. '/json.htm?type=settings' -- to get cost setting
            countURL = dz.settings['Domoticz url'] .. '/json.htm?type=graph&sensor=counter&range=year&idx=' .. sourceDeviceIndex -- to get cost setting
            
            dz.openURL(
            {
                url = costURL,
                callback = scriptVar .. '_costs', 
            })
            
            dz.openURL(
            {
                url = countURL,
                callback = scriptVar .. '_logCount', 
            }).afterSec(5)
            return
        end
        
        local function makeMonth(delta)
            if math.floor(delta) ~= delta or delta  < - 11 or delta > 11 then 
                dz.log('Only integers -11 - +11 allowed',dz.LOG_ERROR) 
                return
            end
            local year = dz.time.year 
            if delta < 0 and dz.time.month + delta < 0 then year = dz.time.year - 1 end 
            if delta > 0 and dz.time.month + delta > 12 then year = dz.time.year + 1 end 
            return ( dz.time.month + delta) % 12, year
        end
        
        
        local function getCost(t, day)
            local startMonth, startYear = makeMonth(-1)
            if dz.time.day < day then startMonth, startYear = makeMonth(-2) end
            startDate =  startYear .. '-' .. dz.utils.leadingZeros(startMonth, 2) .. '-' .. dz.utils.leadingZeros(day, 2) 
            endDate =  dz.time.year .. '-' .. dz.utils.leadingZeros(( startMonth + 1 ) % 12 , 2) .. '-' .. dz.utils.leadingZeros((day - 1), 2) 
            local minCounter = 10^32
            local maxCounter = 0
            for _,r in ipairs(t) do
                if tonumber(r.c) > maxCounter and r.d >= startDate and r.d <= endDate then maxCounter = tonumber(r.c) end
                if tonumber(r.c) < minCounter and r.d >= startDate and r.d <= endDate then minCounter = tonumber(r.c) end
            end
            return dz.utils.round( ( maxCounter - minCounter ) * dz.data.KwHCost, 2 ), startDate, endDate
        end

        if item.ok and item.isJSON then
            if item.trigger:find('_costs') then
                dz.data.KwHCost = item.json.CostEnergy
            else
                local energyCost, startDate, endDate = getCost(item.json.result, startDayOfMonth)
                dz.log('Energycost for device ' .. dz.devices(sourceDeviceIndex).name .. ' between ' .. startDate ..' and ' .. endDate .. ' is: € ' .. energyCost, dz.LOG_FORCE  )
                textDevice.updateText('Energycost for device ' .. dz.devices(sourceDeviceIndex).name .. '\n between ' .. startDate ..' and ' .. endDate .. '\n is: € ' .. energyCost)
            end
        else
            dz.log('There was a problem handling' .. item.trigger, dz.LOG_ERROR)
            dz.log(item, dz.LOG_DEBUG)
        end

    end
}

waaren wrote: ↑Wednesday 26 August 2020 11:31

Nefsolive wrote: ↑Wednesday 26 August 2020 10:54 I really wanted to pass the values to a device dummy text, you can help me how.

This one should do that

Code: Select all

--[[ 
        script calculates the cost of energy of one kwH device
        KwH costs need to be set in domoticz meters / counters settings 

]]--

local scriptVar = 'getCosts'

return 
{
    on = 
    {
        timer = 
        {
            'at 08:00' , --- change to your liking
        },
        
        devices = 
        {
            scriptVar,
        },
        
        httpResponses = 
        {
            scriptVar .. '_*',  
        },
    },

    data = 
    {
        KwHCost = { initial = 0 },
    },
    
    logging = 
    {
        level = domoticz.LOG_DEBUG, -- change to domoticz.LOG_ERROR when all on
        marker = scriptVar,
    },
    
    execute = function(dz, item)

        local sourceDeviceIndex = 2872 -- change to device you want to measure
        local startDayOfMonth = 13
        local textDevice = dz.devices('getCosts' )  -- change to devicename you want to see the text message (virtual text device)

        if item.isTimer or item.isDevice then
            costURL = dz.settings['Domoticz url'] .. '/json.htm?type=settings' -- to get cost setting
            countURL = dz.settings['Domoticz url'] .. '/json.htm?type=graph&sensor=counter&range=year&idx=' .. sourceDeviceIndex -- to get cost setting
            
            dz.openURL(
            {
                url = costURL,
                callback = scriptVar .. '_costs', 
            })
            
            dz.openURL(
            {
                url = countURL,
                callback = scriptVar .. '_logCount', 
            }).afterSec(5)
            return
        end
        
        local function makeMonth(delta)
            if math.floor(delta) ~= delta or delta  < - 11 or delta > 11 then 
                dz.log('Only integers -11 - +11 allowed',dz.LOG_ERROR) 
                return
            end
            local year = dz.time.year 
            if delta < 0 and dz.time.month + delta < 0 then year = dz.time.year - 1 end 
            if delta > 0 and dz.time.month + delta > 12 then year = dz.time.year + 1 end 
            return ( dz.time.month + delta) % 12, year
        end
        
        
        local function getCost(t, day)
            local startMonth, startYear = makeMonth(-1)
            if dz.time.day < day then startMonth, startYear = makeMonth(-2) end
            startDate =  startYear .. '-' .. dz.utils.leadingZeros(startMonth, 2) .. '-' .. dz.utils.leadingZeros(day, 2) 
            endDate =  dz.time.year .. '-' .. dz.utils.leadingZeros(( startMonth + 1 ) % 12 , 2) .. '-' .. dz.utils.leadingZeros((day - 1), 2) 
            local minCounter = 10^32
            local maxCounter = 0
            for _,r in ipairs(t) do
                if tonumber(r.c) > maxCounter and r.d >= startDate and r.d <= endDate then maxCounter = tonumber(r.c) end
                if tonumber(r.c) < minCounter and r.d >= startDate and r.d <= endDate then minCounter = tonumber(r.c) end
            end
            return dz.utils.round( ( maxCounter - minCounter ) * dz.data.KwHCost, 2 ), startDate, endDate
        end

        if item.ok and item.isJSON then
            if item.trigger:find('_costs') then
                dz.data.KwHCost = item.json.CostEnergy
            else
                local energyCost, startDate, endDate = getCost(item.json.result, startDayOfMonth)
                dz.log('Energycost for device ' .. dz.devices(sourceDeviceIndex).name .. ' between ' .. startDate ..' and ' .. endDate .. ' is: € ' .. energyCost, dz.LOG_FORCE  )
                textDevice.updateText('Energycost for device ' .. dz.devices(sourceDeviceIndex).name .. '\n between ' .. startDate ..' and ' .. endDate .. '\n is: € ' .. energyCost)
            end
        else
            dz.log('There was a problem handling' .. item.trigger, dz.LOG_ERROR)
            dz.log(item, dz.LOG_DEBUG)
        end

    end
}

waaren wrote: ↑Wednesday 26 August 2020 11:31

Nefsolive wrote: ↑Wednesday 26 August 2020 10:54 I really wanted to pass the values to a device dummy text, you can help me how.

This one should do that

Code: Select all

--[[ 
        script calculates the cost of energy of one kwH device
        KwH costs need to be set in domoticz meters / counters settings 

]]--

local scriptVar = 'getCosts'

return 
{
    on = 
    {
        timer = 
        {
            'at 08:00' , --- change to your liking
        },
        
        devices = 
        {
            scriptVar,
        },
        
        httpResponses = 
        {
            scriptVar .. '_*',  
        },
    },

    data = 
    {
        KwHCost = { initial = 0 },
    },
    
    logging = 
    {
        level = domoticz.LOG_DEBUG, -- change to domoticz.LOG_ERROR when all on
        marker = scriptVar,
    },
    
    execute = function(dz, item)

        local sourceDeviceIndex = 2872 -- change to device you want to measure
        local startDayOfMonth = 13
        local textDevice = dz.devices('getCosts' )  -- change to devicename you want to see the text message (virtual text device)

        if item.isTimer or item.isDevice then
            costURL = dz.settings['Domoticz url'] .. '/json.htm?type=settings' -- to get cost setting
            countURL = dz.settings['Domoticz url'] .. '/json.htm?type=graph&sensor=counter&range=year&idx=' .. sourceDeviceIndex -- to get cost setting
            
            dz.openURL(
            {
                url = costURL,
                callback = scriptVar .. '_costs', 
            })
            
            dz.openURL(
            {
                url = countURL,
                callback = scriptVar .. '_logCount', 
            }).afterSec(5)
            return
        end
        
        local function makeMonth(delta)
            if math.floor(delta) ~= delta or delta  < - 11 or delta > 11 then 
                dz.log('Only integers -11 - +11 allowed',dz.LOG_ERROR) 
                return
            end
            local year = dz.time.year 
            if delta < 0 and dz.time.month + delta < 0 then year = dz.time.year - 1 end 
            if delta > 0 and dz.time.month + delta > 12 then year = dz.time.year + 1 end 
            return ( dz.time.month + delta) % 12, year
        end
        
        
        local function getCost(t, day)
            local startMonth, startYear = makeMonth(-1)
            if dz.time.day < day then startMonth, startYear = makeMonth(-2) end
            startDate =  startYear .. '-' .. dz.utils.leadingZeros(startMonth, 2) .. '-' .. dz.utils.leadingZeros(day, 2) 
            endDate =  dz.time.year .. '-' .. dz.utils.leadingZeros(( startMonth + 1 ) % 12 , 2) .. '-' .. dz.utils.leadingZeros((day - 1), 2) 
            local minCounter = 10^32
            local maxCounter = 0
            for _,r in ipairs(t) do
                if tonumber(r.c) > maxCounter and r.d >= startDate and r.d <= endDate then maxCounter = tonumber(r.c) end
                if tonumber(r.c) < minCounter and r.d >= startDate and r.d <= endDate then minCounter = tonumber(r.c) end
            end
            return dz.utils.round( ( maxCounter - minCounter ) * dz.data.KwHCost, 2 ), startDate, endDate
        end

        if item.ok and item.isJSON then
            if item.trigger:find('_costs') then
                dz.data.KwHCost = item.json.CostEnergy
            else
                local energyCost, startDate, endDate = getCost(item.json.result, startDayOfMonth)
                dz.log('Energycost for device ' .. dz.devices(sourceDeviceIndex).name .. ' between ' .. startDate ..' and ' .. endDate .. ' is: € ' .. energyCost, dz.LOG_FORCE  )
                textDevice.updateText('Energycost for device ' .. dz.devices(sourceDeviceIndex).name .. '\n between ' .. startDate ..' and ' .. endDate .. '\n is: € ' .. energyCost)
            end
        else
            dz.log('There was a problem handling' .. item.trigger, dz.LOG_ERROR)
            dz.log(item, dz.LOG_DEBUG)
        end

    end
}

Nefsolive wrote: ↑Tuesday 15 September 2020 13:01 The script is working, but it is not giving me the correct values ​​between the 13th and 12th of the following month! If you check the switch report, the cost values ​​do not correspond to the script cost values!

waaren wrote: ↑Wednesday 16 September 2020 20:47

Nefsolive wrote: ↑Tuesday 15 September 2020 13:01 The script is working, but it is not giving me the correct values ​​between the 13th and 12th of the following month! If you check the switch report, the cost values ​​do not correspond to the script cost values!

I can't see any issue with the script. It just sum up the relevant values and calculate the total by multiplying it with the cost / kWh.
Maybe you can show the report and point out what you expect and where the difference is?

Hi Waaren,

Thanks for all the support.
I made some changes to the script and found another way to get the calculation, including the relative taxes of energy consumption.
I submit the changed script.

kind regards

--[[
        script calculates the cost of energy of one kwH device
        KwH costs need to be set in domoticz meters / counters settings

]]--

local scriptVar = 'getCosts'

return
{
    on =
    {
        timer =
        {
            'at 07:00' , --- change to your liking
        },

        devices =
        {
            scriptVar,
        },

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

    data =
    {
        KwHCost = { initial = 0 },
		potencia = { initial = 0},
		IEC = { initial = 0}
    },

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

    execute = function(dz, item)

        local sourceDeviceIndex = 1384 -- change to device you want to measure
        local startDayOfMonth = 13
        local textDevice = dz.devices('Custo Mensal' )  -- change to devicename you want to see the text message (virtual text device)

        if item.isTimer or item.isDevice then
            costURL = dz.settings['Domoticz url'] .. '/json.htm?type=settings' -- to get cost setting
            countURL = dz.settings['Domoticz url'] .. '/json.htm?type=graph&sensor=counter&range=year&idx=' .. sourceDeviceIndex -- to get cost setting

            dz.openURL(
            {
                url = costURL,
                callback = scriptVar .. '_costs',
            })

            dz.openURL(
            {
                url = countURL,
                callback = scriptVar .. '_logCount',
            }).afterSec(5)
            return
        end

        local function makeMonth(delta)
            if math.floor(delta) ~= delta or delta  < - 11 or delta > 11 then
                dz.log('Only integers -11 - +11 allowed',dz.LOG_ERROR)
                return
            end
            local year = dz.time.year
            if delta < 0 and dz.time.month + delta < 0 then year = dz.time.year - 1 end
            if delta > 0 and dz.time.month + delta > 12 then year = dz.time.year + 1 end
            return ( dz.time.month + delta) % 12, year
        end


        local function getCost(t, day)
            local startMonth, startYear = makeMonth(0)
            if dz.time.day < day then startMonth, startYear = makeMonth(-1) end
            startDate =  startYear .. '-' .. dz.utils.leadingZeros(startMonth, 2) .. '-' .. dz.utils.leadingZeros(day, 2)
            endDate =  dz.time.year .. '-' .. dz.utils.leadingZeros(( startMonth + 1 ) % 12 , 2) .. '-' .. dz.utils.leadingZeros((day - 1), 2)
            
			local accu = 0
			local daysCounter = 0

            for _,r in ipairs(t) do
				if r.d >= startDate and r.d <= endDate then 
					accu = accu + r.v
					daysCounter = daysCounter + 1
				end
        
            end


			local potenciaKWH = daysCounter * dz.data.potencia 
			local IECCost = accu * dz.data.IEC
			local accuCost = dz.utils.round( (accu * dz.data.KwHCost) + potenciaKWH + 0.0861 + IECCost + 3.02, 2)
			
			
			return accuCost, startDate, endDate
		end

        if item.ok and item.isJSON then
            if item.trigger:find('_costs') then
                dz.data.KwHCost = item.json.CostEnergy
				dz.data.potencia = item.json.CostEnergyT2
				dz.data.IEC = item.json.CostEnergyR1 
            else
                local energyCost, startDate, endDate = getCost(item.json.result, startDayOfMonth)
                dz.log('' .. startDate ..' e ' .. endDate .. ' é de: € ' .. energyCost, dz.LOG_FORCE  )
                textDevice.updateText(' entre ' .. startDate ..' e ' .. endDate .. ' é de: € ' .. energyCost)
            end
        else
            dz.log('There was a problem handling' .. item.trigger, dz.LOG_ERROR)
            dz.log(item, dz.LOG_DEBUG)
        end

    end
}