Domoticz

Code: Select all

--[[

        Script to send history data as mail attachment

        requires:
            dzVents >= 3.1.0 (domoticz V2020.2 build >= 12771 )
            installed mail on os level (linux only)

        History:
        20210303 initial release

]]--

local scriptVar = 'mailHistory'

return
{
    on =
    {
        timer =
        {
          'at 00:02', -- shortly after midnight to ensure shortlog contains 24 hours of yesterdays data.
        },

        shellCommandResponses =
        {
            scriptVar,
        },
        httpResponses =
        {
            scriptVar,
        },
    },

    data =
    {
        'tempFile',
    },

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

    execute = function(dz, item)

        --- Your settings below this line

        local powerIDX = 35  -- change to idx of your P1 energy device
        local emailTo = '[email protected]'
        local subject = 'power log'

        --- No changes required below this line

        local function getDeviceLog(idx)
            dz.openURL(
            {
                url = dz.settings['Domoticz url'] .. '/json.htm?type=graph&sensor=counter&range=day&idx=' .. powerIDX,
                callback = scriptVar,
            })
        end

        local function selectRecords(t)
            local yesterday = os.date("%Y-%m-%d",os.time()-24*60*60)
            local res = {}

            for index, record in ipairs(t) do
                if record.d:find(yesterday, 1, true) then
                    table.insert(res, record)
                end
            end
            return dz.utils.toJSON(res)
        end

        local function makeFile(t)
            dz.data.tempFile = os.tmpname()
            file = io.open(dz.data.tempFile, 'w')
            file:write( selectRecords(t))
            file:close()
        end

        local function mailFile(f)
            dz.executeShellCommand(
            {
                command = 'mail -A ' .. f .. ' -s "' .. subject .. '" '  .. emailTo .. ' < /dev/null 2> /dev/null ',
                callback = scriptVar,
                timeout = 20,
            })
        end

        -- main
        if item.isTimer then
            getDeviceLog(powerIDX)
        elseif item.isHTTPResponse then
            if item.json then
                makeFile(item.json.result)
                mailFile(dz.data.tempFile)
            else
                dz.log('Problem retrieving data ' , dz.LOG_ERROR)
                dz.log(item, dz.LOG_DEBUG)
            end
        elseif item.isShellCommandResponse then
            if not(item.ok) then
                dz.log('Problem with shellCommand ' , dz.LOG_ERROR)
                dz.log(item, dz.LOG_DEBUG)
            else
                os.execute('rm ' .. dz.data.tempFile)
            end
        end

    end
}

Code: Select all

requires:
            dzVents >= 3.1.0 (domoticz V2020.2 build >= 12771 )
            installed mail on os level (linux only)

Code: Select all

 sudo ./updatebeta

Code: Select all

mail -A /tmp/lua_Ob8JBf -s "power log" [email protected] < /dev/null 2> /dev/null

Code: Select all

mail -A /tmp/lua_C851pY -s "power log" [email protected] < /dev/null 2> /dev/null

Code: Select all

cat tmp/lua_C851pY

Code: Select all

mail -A /tmp/lua_C851pY -s "power log" [email protected] < /dev/null 

Code: Select all

sudo cat tmp/lua_C851pY