Energy Billing

Moderator: leecollings

Post Reply
koensch
Posts: 15
Joined: Sunday 27 December 2020 22:55
Target OS: Linux
Domoticz version: 2020.2
Location: Netherlands
Contact:

Energy Billing

Post by koensch »

Every year my energy provider gives me a nice report and a bill. Sometimes you have to pay extra, sometimes you get some money back.

My contract year ends this month, so i'm trying to look ahead to get a clear picture of my usage and what i can expect to use in the days to come.

I came up with some SQL script that results in the attached output. So fine, so good.

But how can i make this is to some kind of a plug-in?

The SQL uses the following inputs:
- the day your contract period starts
- the devicenumber for the electricity meter
- the devicenumber for the gas meter

Is there someone who can help me to create a plugin that allows me to enter the above parameters and then displays the result of the SQL?
Attachments
CTE_P1.png
CTE_P1.png (13.44 KiB) Viewed 1334 times
willemd
Posts: 630
Joined: Saturday 21 September 2019 17:55
Target OS: Raspberry Pi / ODroid
Domoticz version: 2024.1
Location: The Netherlands
Contact:

Re: Energy Billing

Post by willemd »

An option:
1) create user variables with contract start- and enddate
2) create a dzvents script that contains the device ID's, reads the user variables and calls a script file with your sqlquery (have a look at asynchronous shell command)
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests