Update charge cost of a given geofence in batch

[giovaorama]

Hi,
first of all, thanks for your fantastic work with Teslamate.

One of the main use that I made of Teslamate, is keep track of the charging cost.

I mainly charge at home using my wallbox but the real cost pro kW is not fixed, since it depends on a lot of factors.
I know it usually even a couple of months later, when I receive the bill for a given month from my supplier.

Then I take this total value divided by my consumption and I get the actual price of a kW for that month.

Once I knew it

• I open a console my raspberry
• connect to the docker container of the db with
  docker exec -it teslamate-database-1 /bin/bash
• open a session to postgres with
  psql -U teslamate teslamate
• manual update to change cost of a month with a query like
  
  UPDATE charging_processes SET cost=GREATEST(charge_energy_used,charge_energy_added)*0.228 WHERE geofence_id='1' AND start_date::text LIKE '%2026-03%';
  
  to update the cost of march 2026 of the charging sessions at Home (geofence 1) with 0.228 €/kW

Since I think I'm not the only one in this situation, it would be nice to make it less geeky with an nice user interface.

Maybe in the configuration window for each geofence have the possibility to choose if you want to just set the charging cost "for the future" (as it already possible) or update it for a given time interval.

What do you think?