Domoticz

Code: Select all

-- Create custom-sensors StroomKosten, GasKosten, EnergieKosten.
-- Create a text-sensor EnergieRekening.
-- Define the prices and fixed costs
local gasM3Prijs = 1.21259 --cost of gas per M3
local kwhPrijsT1 = 0.25653 --price kWh low
local kwhPrijsT2 = 0.25653 --price kWh high
local kwhPrijs = 0.25653 --price kWh because the rates are equal for this contract.
local kwhPrijsVast = 0.000000 -- fixed charges electricity per day
local gasM3PrijsVast = 0.000000 -- fixed charges gas per day

-- Helper function
local function spaces(count)
    return string.rep(" ", count)
end

return {
    on = {
        timer = {
            'every 15 minutes',
            'at 00:00' -- Reset at midnight
        }
    },
    logging = {
        level = domoticz.LOG_DEBUG,
        marker = "----- Energy cost calculation -----"
    },
    data = {
        -- Store the meter readings from beginning of the day and the last reading
        beginStandT1 = { initial = nil },
        beginStandT2 = { initial = nil },
        laatsteStandT1 = { initial = nil },
        laatsteStandT2 = { initial = nil },
        isReset = { initial = false } -- Check if reset has been executed
    },
    execute = function(domoticz, trigger)
        -- Enhanced debugging for timer triggers
        if trigger.isTimer then
            if trigger.triggerInfo then
                domoticz.log("Timer triggered with: '" .. tostring(trigger.triggerInfo) .. "'", domoticz.LOG_DEBUG)
            else
                domoticz.log("Timer triggered but triggerInfo is nil", domoticz.LOG_DEBUG)
            end
        end
        
        -- Get the device values
        local powerDevice = domoticz.devices('Power')
        local gasDevice = domoticz.devices('Gas')
        
        -- Get the current values from the meter
        local meterStandT1 = powerDevice.rawData[1] -- Total T1 in Watt since installation
        local meterStandT2 = powerDevice.rawData[2] -- Total T2 in Watt since installation
        local gasVandaag = gasDevice.counterToday -- gas usage today directly from the meter
        
        -- Convert Watt to kWh for the total readings
        local meterStandT1kWh = meterStandT1 / 1000
        local meterStandT2kWh = meterStandT2 / 1000
        
        -- Debug: Log the current meter readings
        domoticz.log(string.format("Current meter reading T1: %.3f kWh, T2: %.3f kWh", 
                     meterStandT1kWh, meterStandT2kWh), domoticz.LOG_DEBUG)
        
        -- Perform reset at midnight
        if trigger.isTimer and (os.date("%H:%M") == "00:00") then
            -- Add extra debug logging
            domoticz.log("ATTEMPTING RESET NOW", domoticz.LOG_DEBUG)
            
            -- Reset at midnight - store the meter readings as starting values
            domoticz.data.beginStandT1 = meterStandT1kWh
            domoticz.data.beginStandT2 = meterStandT2kWh
            domoticz.data.laatsteStandT1 = meterStandT1kWh  -- Also start with laatsteStand equal to beginStand
            domoticz.data.laatsteStandT2 = meterStandT2kWh
            domoticz.data.isReset = true  -- Mark that the reset has been executed
            
            domoticz.log("RESET EXECUTED. Starting reading T1: " .. 
                string.format("%.3f", meterStandT1kWh) .. " kWh, Starting reading T2: " .. 
                string.format("%.3f", meterStandT2kWh) .. " kWh", domoticz.LOG_DEBUG)
        end
        
        -- Initialization if needed (first run or after restart)
        if domoticz.data.beginStandT1 == nil or domoticz.data.beginStandT2 == nil then
            domoticz.data.beginStandT1 = meterStandT1kWh
            domoticz.data.beginStandT2 = meterStandT2kWh
            domoticz.data.laatsteStandT1 = meterStandT1kWh
            domoticz.data.laatsteStandT2 = meterStandT2kWh
            domoticz.data.isReset = true  -- Consider this as a reset
            
            domoticz.log("INITIALIZATION EXECUTED. Starting reading T1: " .. 
                string.format("%.3f", meterStandT1kWh) .. " kWh, Starting reading T2: " .. 
                string.format("%.3f", meterStandT2kWh) .. " kWh", domoticz.LOG_DEBUG)
        end
        
        -- Calculate usage for today (current reading - starting reading)
        local stroomVandaagT1 = meterStandT1kWh - domoticz.data.beginStandT1
        local stroomVandaagT2 = meterStandT2kWh - domoticz.data.beginStandT2
        
        -- Check for negative values (shouldn't happen, but just to be safe)
        if stroomVandaagT1 < 0 then stroomVandaagT1 = 0 end
        if stroomVandaagT2 < 0 then stroomVandaagT2 = 0 end
        
        -- Update laatsteStand for next iteration
        domoticz.data.laatsteStandT1 = meterStandT1kWh
        domoticz.data.laatsteStandT2 = meterStandT2kWh
            
        -- Use powerDevice.counterToday for the total electricity today (this is already in kWh)
        local totalStroomVandaag = powerDevice.counterToday
        
        -- Calculate the costs for today
        local kostenStroomT1Vandaag = stroomVandaagT1 * kwhPrijsT1
        local kostenStroomT2Vandaag = stroomVandaagT2 * kwhPrijsT2
        -- local kostenStroomVandaag = kostenStroomT1Vandaag + kostenStroomT2Vandaag + kwhPrijsVast -- (use this line for different rates for low and high)
        local kostenStroomVandaag = totalStroomVandaag * kwhPrijs + kwhPrijsVast -- (use this line if rates for low and high are the same)
        local kostenGasVandaag = (gasVandaag * gasM3Prijs) + gasM3PrijsVast
        local totaleKostenVandaag = kostenStroomVandaag + kostenGasVandaag
        
        -- Log the calculated values
        domoticz.log(string.format("Starting reading T1: %.3f kWh, Starting reading T2: %.3f kWh", domoticz.data.beginStandT1, domoticz.data.beginStandT2), domoticz.LOG_DEBUG)
        domoticz.log(string.format("Electricity today (T1): %.3f kWh", stroomVandaagT1), domoticz.LOG_DEBUG)
        domoticz.log(string.format("Electricity today (T2): %.3f kWh", stroomVandaagT2), domoticz.LOG_DEBUG)
        domoticz.log(string.format("Total electricity today: %.3f kWh", totalStroomVandaag), domoticz.LOG_DEBUG)
        domoticz.log(string.format("Electricity T1 costs today: € %.2f", kostenStroomT1Vandaag), domoticz.LOG_DEBUG)
        domoticz.log(string.format("Electricity T2 costs today: € %.2f", kostenStroomT2Vandaag), domoticz.LOG_DEBUG)
        domoticz.log(string.format("Gas today: %.3f m³", gasVandaag), domoticz.LOG_DEBUG)
        domoticz.log(string.format("Gas costs today: € %.2f", kostenGasVandaag), domoticz.LOG_DEBUG)
        domoticz.log(string.format("Total costs today: € %.2f", totaleKostenVandaag), domoticz.LOG_DEBUG)

        -- Create the text for the sensor
        local tekst = string.format(
            "Gas today: %.3f m³\n" ..
            "Electricity today: %.3f kWh\n" ..
            "Electricity T1 today: %.3f kWh\n" ..
            "Electricity T2 today: %.3f kWh\n" ..
            spaces(18) .. "Fixed costs Electricity: € %.2f \n" ..
            spaces(18) .. "Fixed costs Gas: € %.2f \n" ..
            spaces(18) .. "Gas costs today: € %.2f \n" ..
            spaces(18) .. "T1 costs today: € %.2f \n" ..
            spaces(18) .. "T2 costs today: € %.2f \n" ..
            spaces(18) .. "Electricity costs today: € %.2f \n" ..
            spaces(18) .. "Energy costs today: € %.2f ",
            gasVandaag,
            totalStroomVandaag,
            stroomVandaagT1,
            stroomVandaagT2,
            kwhPrijsVast,
            gasM3PrijsVast,
            kostenGasVandaag,
            kostenStroomT1Vandaag,
            kostenStroomT2Vandaag,
            kostenStroomVandaag,
            totaleKostenVandaag
        )

        -- Update the sensors StroomKosten, GasKosten, EnergieKosten
        local StroomKosten = domoticz.devices('StroomKosten')
        local GasKosten = domoticz.devices('GasKosten')
        local TotaalKosten = domoticz.devices('EnergieKosten')        

        local KwhKosten = tonumber(domoticz.utils.round(kostenStroomVandaag, 2))   
        local GasM3Kosten = tonumber(domoticz.utils.round(kostenGasVandaag, 2))
        local KostenTotaal = tonumber(domoticz.utils.round(totaleKostenVandaag, 2))

        StroomKosten.updateCustomSensor(KwhKosten)
        GasKosten.updateCustomSensor(GasM3Kosten)
        TotaalKosten.updateCustomSensor(KostenTotaal)
        -- end of sensors Update

        -- Update the text sensor EnergieRekening
        local textDevice = domoticz.devices('EnergieRekening')
        if textDevice then
            textDevice.updateText(tekst)
        else
            domoticz.log("Error: Text sensor 'EnergieRekening' not found!", domoticz.LOG_ERROR)
        end
    end
}