Forum Domoticz en français

Code : Tout sélectionner

-- Smart-Meter (per 10mn/600s "targetted" time slice) mean power consumption
-- Only use slices > 5mn Domoticz log/graph record time in DB or some values
-- will be overwritten! Time slice is a target value that may be exceeded by
-- last measurement delay that may be minimised by increasing device reports.
--
-- Changelog:
--   31/01/2023, YL, 1st version.
--   01/02/2023, Change basic mean compute to samples approx integration over time.
--   03/02/2023, Log power mean updates with last slice real duration.

-- User editabe settings:
devSmartMeterPwr='SmartMeter W'    -- Real PWR consumtion measurement device name.
devMeanPwrVrtSen='Puissance MOY'   -- Virtual sensor type "usage/electricity" name.
varPwrSum='pwrSum'   -- User variable, decimal/float type, storing current time slice power ~integral.
varPwrLast='pwrLast' -- User variable, decimal/float type, storing last pwr watt value.
maxLastUpdateVrt=600 -- Virtual sensor update rate.
maxPeakPwr=13000     -- Device limit is 63A, measures exceeding are filtered.

commandArray = {}

--
-- Internal fct :
-- Get current script exec time & compute last 'device' or 'uservariable' update time.
--
local function timeLastUpdate(devOrVar, isUserVar)
    t1  = os.time()
    
    if (isUserVar == true) then
        sT0 = uservariables_lastupdate[devOrVar]
    else
        sT0 = otherdevices_lastupdate[devOrVar]
    end

    -- Returns a date time like 2016-12-02 15:30:10
    -- => Format as os.time & compute diff :

    year    = string.sub(sT0, 1, 4)
    month   = string.sub(sT0, 6, 7)
    day     = string.sub(sT0, 9, 10)
    hour    = string.sub(sT0, 12, 13)
    minutes = string.sub(sT0, 15, 16)
    seconds = string.sub(sT0, 18, 19)
    t0      = os.time{year=year, month=month, day=day, hour=hour, min=minutes, sec=seconds}
    tDiff   = os.difftime(t1, t0)

    return(tDiff)
end

--
-- Update virtual sensor
--
local function updateNum(dev, value1)
    local cmd = string.format("%d|0|%d", otherdevices_idx[dev], math.floor(value1))
    table.insert (commandArray, { ['UpdateDevice'] = cmd } )
end

--
-- MAIN
--
if (devicechanged[devSmartMeterPwr]) then
    curPwr = tonumber(devicechanged[devSmartMeterPwr])

    -- Immediately log & return on bad pwr figures...
    if (curPwr > maxPeakPwr) then
        print('WARNING : '..devSmartMeterPwr..' reports '..curPwr..'W !!!')
        return commandArray
    end

    tLastMean = timeLastUpdate(devMeanPwrVrtSen, false)
    
    -- Debug :
    --print(devSmartMeterPwr..': P='..curPwr..'W ; Last : '..tLastMean..'s')

    pwrLast   = uservariables[varPwrLast]
    pwrSum    = uservariables[varPwrSum]
    sumDeltaT = timeLastUpdate(varPwrSum, true)

    -- Calc pwr sum + store. Set current mean pwr if time slice exceeded & reset user vars.
    if (tLastMean > maxLastUpdateVrt) then
       meanPwr = (pwrSum + pwrLast*sumDeltaT) / tLastMean

       --Log update :
       print(string.format('%s : New time slice (after %ds) => Record Pmean=%.2fW', devMeanPwrVrtSen,  tLastMean, meanPwr))

       updateNum(devMeanPwrVrtSen, meanPwr)
       commandArray['Variable:'..varPwrSum]  = '0'
       commandArray['Variable:'..varPwrLast] = tostring(curPwr)
    else
       pwrSum = pwrSum + pwrLast*sumDeltaT

       --Debug :
       --print('Update current Psum='..pwrSum..'Ws ; deltaT='..sumDeltaT..'s')

       commandArray['Variable:'..varPwrLast] = tostring(curPwr)
       commandArray['Variable:'..varPwrSum]  = tostring(pwrSum)
    end
end

return commandArray

Code : Tout sélectionner

$ grep "Record Pmean" /tmp/domoticz.txt | more
2023-06-26 00:02:07.039  Status: LUA: Puissance MOY : New time slice (after 630s) => Record Pmean=1082.18W
2023-06-26 00:12:36.256  Status: LUA: Puissance MOY : New time slice (after 629s) => Record Pmean=640.85W
2023-06-26 00:23:05.450  Status: LUA: Puissance MOY : New time slice (after 629s) => Record Pmean=733.66W
2023-06-26 00:33:34.688  Status: LUA: Puissance MOY : New time slice (after 629s) => Record Pmean=867.63W
2023-06-26 00:44:09.111  Status: LUA: Puissance MOY : New time slice (after 635s) => Record Pmean=859.16W
2023-06-26 00:54:38.313  Status: LUA: Puissance MOY : New time slice (after 629s) => Record Pmean=664.80W
2023-06-26 01:04:51.941  Status: LUA: Puissance MOY : New time slice (after 613s) => Record Pmean=543.72W
2023-06-26 01:15:36.781  Status: LUA: Puissance MOY : New time slice (after 645s) => Record Pmean=581.99W
2023-06-26 01:26:05.986  Status: LUA: Puissance MOY : New time slice (after 629s) => Record Pmean=555.72W
2023-06-26 01:36:24.815  Status: LUA: Puissance MOY : New time slice (after 619s) => Record Pmean=425.39W
2023-06-26 01:48:38.053  Status: LUA: Puissance MOY : New time slice (after 734s) => Record Pmean=601.69W
...

Code : Tout sélectionner

     counter = counter + 1;
                domoticz.devices('PompeUsage').updateElectricity(0,counter)

Code : Tout sélectionner

return {
	on = {
		timer = {
			'at 00:05',					-- specific time

		}
	},
	

	execute = function(domoticz, timer)

            domoticz.variables('CumulPompe').set(0)
            domoticz.devices('Pompe').updateRain(0,0)
            
            print('Reset du compteur de la pompe')
            
	end
}

Code : Tout sélectionner

return {
	on = {
		timer = {
			'every minute',				-- causes the script to be called every minute
		}
	},
	
	execute = function(domoticz, timer)
	
        local currentUsage = domoticz.devices('Usage').actualWatt
        if (currentUsage > 10) then
    
            if (domoticz.variables('PompeStatus').value == 0) then
            
                domoticz.variables('PompeStatus').set(1)
                
                local cumul = domoticz.variables('CumulPompe').value
                cumul = cumul + 1
                domoticz.variables('CumulPompe').set(cumul)
                
                domoticz.notify('Activation pompe detectee')
                
                domoticz.devices('Pompe').updateRain(1,cumul)      
                
            end
        end    
        
        print('Fin script - Compteur pompe')

    end
}

Code : Tout sélectionner

	if item.trigger == 'at 00:05' then
			-- je reset mon compter
	else
			-- je regarde si la pompe a déclacher.
	end