###############################################################################
#                                                                             #
#                           G R O U P                                         #
#                                                                             #
###############################################################################
group:
#### ENERGY
  energy_group:
    name: 'Energy'
    entities:
      - sensor.frequencia
      - sensor.corrente
      - sensor.potencia_w
      - sensor.voltagem

#### DAILY CONSUMPTIONS
  consumos_diarios:
    name: 'Daily spend'
    entities:
      - sensor.day_energy_vazio
      - sensor.day_energy_fora_vazio
      - sensor.day_energy_total
      - sensor.daily_energia_cost_total
      - history_graph.daily_consumed_energy

#### MONTHLY CONSUMPTIONS
  consumos_mensais_janeiro:
    name: 'Montly spend Janeiro'
    entities:
      - sensor.month_energy_vazio_janeiro
      - sensor.month_energy_fora_vazio_janeiro
      - sensor.fatura_energia_janeiro

  consumos_mensais_fevereiro:
    name: 'Montly spend Fevereiro'
    entities:
      - sensor.month_energy_vazio_fevereiro
      - sensor.month_energy_fora_vazio_fevereiro
      - sensor.fatura_energia_fevereiro

  consumos_mensais_marco:
    name: 'Montly spend Março'
    entities:
      - sensor.month_energy_vazio_marco
      - sensor.month_energy_fora_vazio_marco
      - sensor.fatura_energia_marco

  consumos_mensais_abril:
    name: 'Montly spend Abril'
    entities:
      - sensor.month_energy_vazio_abril
      - sensor.month_energy_fora_vazio_abril
      - sensor.fatura_energia_abril

  consumos_mensais_maio:
    name: 'Montly spend Maio'
    entities:
      - sensor.month_energy_vazio_maio
      - sensor.month_energy_fora_vazio_maio
      - sensor.fatura_energia_maio

  consumos_mensais_junho:
    name: 'Montly spend Junho'
    entities:
      - sensor.month_energy_vazio_junho
      - sensor.month_energy_fora_vazio_junho
      - sensor.fatura_energia_junho

  consumos_mensais_julho:
    name: 'Montly spend Julho'
    entities:
      - sensor.month_energy_vazio_julho
      - sensor.month_energy_fora_vazio_julho
      - sensor.fatura_energia_julho
      - history_graph.julho_consumed_energy

  consumos_mensais_agosto:
    name: 'Montly spend Agosto'
    entities:
      - sensor.month_energy_vazio_agosto
      - sensor.month_energy_fora_vazio_agosto
      - sensor.fatura_energia_agosto

  consumos_mensais_setembro:
    name: 'Montly spend Setembro'
    entities:
      - sensor.month_energy_vazio_setembro
      - sensor.month_energy_fora_vazio_setembro
      - sensor.fatura_energia_setembro

  consumos_mensais_outubro:
    name: 'Montly spend Outubro'
    entities:
      - sensor.month_energy_vazio_outubro
      - sensor.month_energy_fora_vazio_outubro
      - sensor.fatura_energia_outubro

  consumos_mensais_novembro:
    name: 'Montly spend Novembro'
    entities:
      - sensor.month_energy_vazio_novembro
      - sensor.month_energy_fora_vazio_novembro
      - sensor.fatura_energia_novembro

  consumos_mensais_dezembro:
    name: 'Montly spend Dezembro'
    entities:
      - sensor.month_energy_vazio_dezembro
      - sensor.month_energy_fora_vazio_dezembro
      - sensor.fatura_energia_dezembro
#### TOTALIZERS
  totalizadores:
    name: 'Total'
    entities:
      - sensor.house_consumption_total_kwh
      - history_graph.house_consumption_total_euro

###############################################################################
#                                                                             #
#                         S E N S O R                                         #
#                                                                             #
###############################################################################

sensor:
  - platform: mqtt
    state_topic: 'tele/sdm120/SENSOR'
    value_template: '{{ value_json["ENERGY"]["Voltage"] }}'
    name: 'Voltagem'
    unit_of_measurement: "V"
    icon: mdi:speedometer

  - platform: mqtt
    state_topic: 'tele/sdm120/SENSOR'
    value_template: '{{ value_json["ENERGY"]["Current"] }}'
    name: 'Corrente'
    unit_of_measurement: "A"
    icon: mdi:speedometer

  - platform: mqtt
    state_topic: 'tele/sdm120/SENSOR'
    value_template: '{{ value_json["ENERGY"]["ActivePower"] }}'
    name: "Potência (W)"
    unit_of_measurement: "W"
    icon: mdi:speedometer

  - platform: mqtt
    state_topic: 'tele/sdm120/SENSOR'
    value_template: '{{ value_json["ENERGY"]["ApparentPower"] }}'
    name: 'Active apparent power'
    unit_of_measurement: "VA"
    icon: mdi:speedometer

  - platform: mqtt
    state_topic: 'tele/sdm120/SENSOR'
    value_template: '{{ value_json["ENERGY"]["ReactivePower"] }}'
    name: 'Reactive apparent power'
    unit_of_measurement: "VAR"
    icon: mdi:speedometer

  - platform: mqtt
    state_topic: 'tele/sdm120/SENSOR'
    value_template: '{{ value_json["ENERGY"]["Factor"] }}'
    name: 'Factor Power'
    unit_of_measurement: ""
    icon: mdi:speedometer

  - platform: mqtt
    state_topic: 'tele/sdm120/SENSOR'
    value_template: '{{ value_json["ENERGY"]["Frequency"] }}'
    name: 'Frequencia'
    unit_of_measurement: "HZ"
    icon: mdi:speedometer

  # - platform: mqtt
  #   state_topic: 'tele/sdm120/SENSOR'
  #   value_template: '{{ value_json["ENERGY"]["ApparentPower"] }}'
  #   name: 'Phase Angle'
  #   unit_of_measurement: "Degree"
  #   icon: mdi:speedometer

  - platform: mqtt
    state_topic: 'tele/sdm120/SENSOR'
    value_template: '{{ value_json["ENERGY"]["Total"] }}'
    name: 'Total active energy'
    unit_of_measurement: "Wh"
    icon: mdi:speedometer

  # - platform: mqtt
  #   state_topic: 'tele/sdm120/SENSOR'
  #   value_template: '{{ value_json["ENERGY"]["ApparentPower"] }}'
  #   name: 'Total reactive energy'
  #   unit_of_measurement: "Wh"
  #   icon: mdi:speedometer

  # - platform: mqtt
  #   state_topic: 'tele/sdm120/SENSOR'
  #   value_template: '{{ value_json["ENERGY"]["ApparentPower"] }}'
  #   name: 'Import active energy'
  #   unit_of_measurement: "Wh"
  #   icon: mdi:speedometer

  # - platform: mqtt
  #   state_topic: 'tele/sdm120/SENSOR'
  #   value_template: '{{ value_json["ENERGY"]["ApparentPower"] }}'
  #   name: 'Export active energy'
  #   unit_of_measurement: "Wh"
  #   icon: mdi:speedometer

  # - platform: mqtt
  #   state_topic: 'tele/sdm120/SENSOR'
  #   value_template: '{{ value_json["ENERGY"]["ApparentPower"] }}'
  #   name: 'Import reactive energy'
  #   unit_of_measurement: "VARh"
  #   icon: mdi:speedometer

  # - platform: mqtt
  #   state_topic: 'tele/sdm120/SENSOR'
  #   value_template: '{{ value_json["ENERGY"]["ApparentPower"] }}'
  #   name: 'Export reactive energy'
  #   unit_of_measurement: "VARh"
  #   icon: mdi:speedometer

  - platform: template
    sensors:
      house_consumption_total_kwh:
        friendly_name: 'Total Spend'
        value_template: '{{  ((states.sensor.import_reactive_energy.state | float ) + ( states.sensor.total_active_energy.state | float )) | round(2) }}'
        unit_of_measurement: "kWh"
      # montly_consumption_total_euro_fora_vazio:
      #   friendly_name: 'Montly total fora vazio'
      #   value_template: '{{ (((states.sensor.month_energy_fora_vazio.state | float) * (0.2037 )) | round(2)) }}'
      #   unit_of_measurement: "€"
      # montly_consumption_total_euro_vazio:
      #   friendly_name: 'Montly Total vazio '
      #   value_template: '{{ (((states.sensor.month_energy_vazio.state | float) * (0.0943 )) | round(2)) }}'
      #   unit_of_measurement: "€"
      daily_energia_cost_total:
        friendly_name: "Daily energy cost"
        value_template: >-
          {{ ((float(states.sensor.day_energy_vazio.state) * 0.0954  + float(states.sensor.day_energy_fora_vazio.state) * 0.1897 ) * 1.23 ) | round(2) }}
        unit_of_measurement: "€"
      day_energy_vazio:
        friendly_name: "Daily energy Vazio"
        value_template: >-
          {% if (float(states.sensor.day_energy_total.state) - float(states.sensor.day_energy_fora_vazio.state)) | round (3) >=0 %}
          {{ (float(states.sensor.day_energy_total.state) - float(states.sensor.day_energy_fora_vazio.state)) | round (3)}}
          {% else %}
          0
          {% endif %}
        unit_of_measurement: "kWh"
      fatura_energia_janeiro:
        friendly_name: "Fatura Energia Janeiro"
        value_template: >-
          {{ ((float(states.sensor.month_energy_vazio_janeiro.state) * 0.0954  + float(states.sensor.month_energy_fora_vazio_janeiro.state) * 0.1897 + now().day * 0.1683 + 2.90 ) * 1.23 ) | round(2) }}
        unit_of_measurement: "€"
      fatura_energia_fevereiro:
        friendly_name: "Fatura Energia Fevereiro"
        value_template: >-
          {{ ((float(states.sensor.month_energy_vazio_fevereiro.state) * 0.0954  + float(states.sensor.month_energy_fora_vazio_fevereiro.state) * 0.1897 + now().day * 0.1683 + 2.90 ) * 1.23 ) | round(2) }}
        unit_of_measurement: "€"
      fatura_energia_marco:
        friendly_name: "Fatura Energia Março"
        value_template: >-
          {{ ((float(states.sensor.month_energy_vazio_marco.state) * 0.0954  + float(states.sensor.month_energy_fora_vazio_marco.state) * 0.1897 + now().day * 0.1683 + 2.90 ) * 1.23 ) | round(2) }}
        unit_of_measurement: "€"
      fatura_energia_abril:
        friendly_name: "Fatura Energia Abril"
        value_template: >-
          {{ ((float(states.sensor.month_energy_vazio_abril.state) * 0.0954  + float(states.sensor.month_energy_fora_vazio_abril.state) * 0.1897 + now().day * 0.1683 + 2.90 ) * 1.23 ) | round(2) }}
        unit_of_measurement: "€"
      fatura_energia_maio:
        friendly_name: "Fatura Energia Maio"
        value_template: >-
          {{ ((float(states.sensor.month_energy_vazio_maio.state) * 0.0954  + float(states.sensor.month_energy_fora_vazio_maio.state) * 0.1897 + now().day * 0.1683 + 2.90 ) * 1.23 ) | round(2) }}
        unit_of_measurement: "€"
      fatura_energia_junho:
        friendly_name: "Fatura Energia Junho"
        value_template: >-
          {{ ((float(states.sensor.month_energy_vazio_junho.state) * 0.0954  + float(states.sensor.month_energy_fora_vazio_junho.state) * 0.1897 + now().day * 0.1683 + 2.90 ) * 1.23 ) | round(2) }}
        unit_of_measurement: "€"
      fatura_energia_julho:
        friendly_name: "Fatura Energia Julho"
        value_template: >-
          {{ ((float(states.sensor.month_energy_vazio_julho.state) * 0.0954  + float(states.sensor.month_energy_fora_vazio_julho.state) * 0.1897 + now().day * 0.1683 + 2.90 ) * 1.23 ) | round(2) }}
        unit_of_measurement: "€"
      fatura_energia_agosto:
        friendly_name: "Fatura Energia Agosto"
        value_template: >-
          {{ ((float(states.sensor.month_energy_vazio_agosto.state) * 0.0954  + float(states.sensor.month_energy_fora_vazio_agosto.state) * 0.1897 + now().day * 0.1683 + 2.90 ) * 1.23 ) | round(2) }}
        unit_of_measurement: "€"
      fatura_energia_setembro:
        friendly_name: "Fatura Energia Setembro"
        value_template: >-
          {{ ((float(states.sensor.month_energy_vazio_setembro.state) * 0.0954  + float(states.sensor.month_energy_fora_vazio_setembro.state) * 0.1897 + now().day * 0.1683 + 2.90 ) * 1.23 ) | round(2) }}
        unit_of_measurement: "€"
      fatura_energia_outubro:
        friendly_name: "Fatura Energia Outubro"
        value_template: >-
          {{ ((float(states.sensor.month_energy_vazio_outubro.state) * 0.0954  + float(states.sensor.month_energy_fora_vazio_outubro.state) * 0.1897 + now().day * 0.1683 + 2.90 ) * 1.23 ) | round(2) }}
        unit_of_measurement: "€"
      fatura_energia_novembro:
        friendly_name: "Fatura Energia Novembro"
        value_template: >-
          {{ ((float(states.sensor.month_energy_vazio_novembro.state) * 0.0954  + float(states.sensor.month_energy_fora_vazio_novembro.state) * 0.1897 + now().day * 0.1683 + 2.90 ) * 1.23 ) | round(2) }}
        unit_of_measurement: "€"
      fatura_energia_dezembro:
        friendly_name: "Fatura Energia Dezembro"
        value_template: >-
          {{ ((float(states.sensor.month_energy_vazio_dezembro.state) * 0.0954  + float(states.sensor.month_energy_fora_vazio_dezembro.state) * 0.1897 + now().day * 0.1683 + 2.90 ) * 1.23 ) | round(2) }}
        unit_of_measurement: "€"

  - platform: influxdb
    host: !secret influxdb_host
    scan_interval: 120
    # username: !secret influxdb_user
    # password: !secret influxdb_password
    queries:
      - name: day energy fora vazio
        unit_of_measurement: kWh
        where: '"entity_id" = ''potencia_w'' AND time >= ''{{ now().strftime("%Y-%m-%d 08:00:00")}}'' AND time < ''{{ now().strftime("%Y-%m-%d 22:00:00") }}'' tz(''Europe/Lisbon'')'
        measurement: '"W"'
        group_function: 'integral'
        field: '"value",1h'
        value_template: '{{ (value | float / 1000) | round(1) }}'
      - name: day energy total
        unit_of_measurement: kWh
        where: '"entity_id" = ''potencia_w'' AND time >= ''{{ now().strftime("%Y-%m-%d 00:00:00") }}'' tz(''Europe/Lisbon'')'
        measurement: '"W"'
        group_function: 'integral'
        field: '"value",1h'
        value_template: '{{ (value | float / 1000) | round(1) }}'
      # - name: month energy vazio
      #   measurement: '(select last(value),entity_id FROM kWh'
      #   where:  '"entity_id" = ''day_energy_vazio'' and time >= ''{{ now().strftime("%Y-%m-14 00:00:00")}}''-30d group by time(1d) tz(''Europe/Lisbon''))'
      #   group_function: 'sum'
      #   field: 'last'
      #   unit_of_measurement: kWh
      #   value_template: '{{ (value | float) | round(1) }}'
      # - name: month energy fora vazio
      #   measurement: '(select last(value),entity_id FROM kWh'
      #   where:  '"entity_id" = ''day_energy_fora_vazio'' and time >= ''{{ now().strftime("%Y-%m-14 00:00:00")}}''group by time(1d) tz(''Europe/Lisbon''))'
      #   group_function: 'sum'
      #   field: 'last'
      #   unit_of_measurement: kWh
      #   value_template: '{{ (value | float) | round(1) }}'
      - name: month energy fora vazio janeiro
        measurement: '(select last(value),entity_id FROM kWh'
        where:  '"entity_id" = ''day_energy_fora_vazio'' and time >= ''{{ now().strftime("%Y-12-14 00:00:00")}}'' and time <= ''{{ now().strftime("%Y-01-14 00:00:00")}}''group by time(1d) tz(''Europe/Lisbon''))'
        group_function: 'sum'
        field: 'last'
        unit_of_measurement: kWh
        value_template: '{{ (value | float) | round(1) }}'
      - name: month energy fora vazio fevereiro
        measurement: '(select last(value),entity_id FROM kWh'
        where:  '"entity_id" = ''day_energy_fora_vazio'' and time >= ''{{ now().strftime("%Y-01-14 00:00:00")}}'' and time <= ''{{ now().strftime("%Y-02-14 00:00:00")}}''group by time(1d) tz(''Europe/Lisbon''))'
        group_function: 'sum'
        field: 'last'
        unit_of_measurement: kWh
        value_template: '{{ (value | float) | round(1) }}'
      - name: month energy fora vazio marco
        measurement: '(select last(value),entity_id FROM kWh'
        where:  '"entity_id" = ''day_energy_fora_vazio'' and time >= ''{{ now().strftime("%Y-02-14 00:00:00")}}'' and time <= ''{{ now().strftime("%Y-03-14 00:00:00")}}''group by time(1d) tz(''Europe/Lisbon''))'
        group_function: 'sum'
        field: 'last'
        unit_of_measurement: kWh
        value_template: '{{ (value | float) | round(1) }}'
      - name: month energy fora vazio abril
        measurement: '(select last(value),entity_id FROM kWh'
        where:  '"entity_id" = ''day_energy_fora_vazio'' and time >= ''{{ now().strftime("%Y-03-14 00:00:00")}}'' and time <= ''{{ now().strftime("%Y-04-14 00:00:00")}}''group by time(1d) tz(''Europe/Lisbon''))'
        group_function: 'sum'
        field: 'last'
        unit_of_measurement: kWh
        value_template: '{{ (value | float) | round(1) }}'
      - name: month energy fora vazio maio
        measurement: '(select last(value),entity_id FROM kWh'
        where:  '"entity_id" = ''day_energy_fora_vazio'' and time >= ''{{ now().strftime("%Y-04-14 00:00:00")}}'' and time <= ''{{ now().strftime("%Y-05-14 00:00:00")}}''group by time(1d) tz(''Europe/Lisbon''))'
        group_function: 'sum'
        field: 'last'
        unit_of_measurement: kWh
        value_template: '{{ (value | float) | round(1) }}'
      - name: month energy fora vazio junho
        measurement: '(select last(value),entity_id FROM kWh'
        where:  '"entity_id" = ''day_energy_fora_vazio'' and time >= ''{{ now().strftime("%Y-05-14 00:00:00")}}'' and time <= ''{{ now().strftime("%Y-06-14 00:00:00")}}''group by time(1d) tz(''Europe/Lisbon''))'
        group_function: 'sum'
        field: 'last'
        unit_of_measurement: kWh
        value_template: '{{ (value | float) | round(1) }}'
      - name: month energy fora vazio julho
        measurement: '(select last(value),entity_id FROM kWh'
        where:  '"entity_id" = ''day_energy_fora_vazio'' and time >= ''{{ now().strftime("%Y-06-14 00:00:00")}}'' and time <= ''{{ now().strftime("%Y-07-14 00:00:00")}}''group by time(1d) tz(''Europe/Lisbon''))'
        group_function: 'sum'
        field: 'last'
        unit_of_measurement: kWh
        value_template: '{{ (value | float) | round(1) }}'
      - name: month energy fora vazio agosto
        measurement: '(select last(value),entity_id FROM kWh'
        where:  '"entity_id" = ''day_energy_fora_vazio'' and time >= ''{{ now().strftime("%Y-07-14 00:00:00")}}'' and time <= ''{{ now().strftime("%Y-08-14 00:00:00")}}''group by time(1d) tz(''Europe/Lisbon''))'
        group_function: 'sum'
        field: 'last'
        unit_of_measurement: kWh
        value_template: '{{ (value | float) | round(1) }}'
      - name: month energy fora vazio setembro
        measurement: '(select last(value),entity_id FROM kWh'
        where:  '"entity_id" = ''day_energy_fora_vazio'' and time >= ''{{ now().strftime("%Y-08-14 00:00:00")}}'' and time <= ''{{ now().strftime("%Y-09-14 00:00:00")}}''group by time(1d) tz(''Europe/Lisbon''))'
        group_function: 'sum'
        field: 'last'
        unit_of_measurement: kWh
        value_template: '{{ (value | float) | round(1) }}'
      - name: month energy fora vazio outubro
        measurement: '(select last(value),entity_id FROM kWh'
        where:  '"entity_id" = ''day_energy_fora_vazio'' and time >= ''{{ now().strftime("%Y-09-14 00:00:00")}}'' and time <= ''{{ now().strftime("%Y-10-14 00:00:00")}}''group by time(1d) tz(''Europe/Lisbon''))'
        group_function: 'sum'
        field: 'last'
        unit_of_measurement: kWh
        value_template: '{{ (value | float) | round(1) }}'
      - name: month energy fora vazio novembro
        measurement: '(select last(value),entity_id FROM kWh'
        where:  '"entity_id" = ''day_energy_fora_vazio'' and time >= ''{{ now().strftime("%Y-10-14 00:00:00")}}'' and time <= ''{{ now().strftime("%Y-11-14 00:00:00")}}''group by time(1d) tz(''Europe/Lisbon''))'
        group_function: 'sum'
        field: 'last'
        unit_of_measurement: kWh
        value_template: '{{ (value | float) | round(1) }}'
      - name: month energy fora vazio dezembro
        measurement: '(select last(value),entity_id FROM kWh'
        where:  '"entity_id" = ''day_energy_fora_vazio'' and time >= ''{{ now().strftime("%Y-11-14 00:00:00")}}'' and time <= ''{{ now().strftime("%Y-12-14 00:00:00")}}''group by time(1d) tz(''Europe/Lisbon''))'
        group_function: 'sum'
        field: 'last'
        unit_of_measurement: kWh
        value_template: '{{ (value | float) | round(1) }}'

      - name: month energy vazio janeiro
        measurement: '(select last(value),entity_id FROM kWh'
        where:  '"entity_id" = ''day_energy_vazio'' and time >= ''{{ now().strftime("%Y-12-14 00:00:00")}}'' and time <= ''{{ now().strftime("%Y-01-14 00:00:00")}}''group by time(1d) tz(''Europe/Lisbon''))'
        group_function: 'sum'
        field: 'last'
        unit_of_measurement: kWh
        value_template: '{{ (value | float) | round(1) }}'
      - name: month energy vazio fevereiro
        measurement: '(select last(value),entity_id FROM kWh'
        where:  '"entity_id" = ''day_energy_vazio'' and time >= ''{{ now().strftime("%Y-01-14 00:00:00")}}'' and time <= ''{{ now().strftime("%Y-02-14 00:00:00")}}''group by time(1d) tz(''Europe/Lisbon''))'
        group_function: 'sum'
        field: 'last'
        unit_of_measurement: kWh
        value_template: '{{ (value | float) | round(1) }}'
      - name: month energy vazio marco
        measurement: '(select last(value),entity_id FROM kWh'
        where:  '"entity_id" = ''day_energy_vazio'' and time >= ''{{ now().strftime("%Y-02-14 00:00:00")}}'' and time <= ''{{ now().strftime("%Y-03-14 00:00:00")}}''group by time(1d) tz(''Europe/Lisbon''))'
        group_function: 'sum'
        field: 'last'
        unit_of_measurement: kWh
        value_template: '{{ (value | float) | round(1) }}'
      - name: month energy vazio abril
        measurement: '(select last(value),entity_id FROM kWh'
        where:  '"entity_id" = ''day_energy_vazio'' and time >= ''{{ now().strftime("%Y-03-14 00:00:00")}}'' and time <= ''{{ now().strftime("%Y-04-14 00:00:00")}}''group by time(1d) tz(''Europe/Lisbon''))'
        group_function: 'sum'
        field: 'last'
        unit_of_measurement: kWh
        value_template: '{{ (value | float) | round(1) }}'
      - name: month energy vazio maio
        measurement: '(select last(value),entity_id FROM kWh'
        where:  '"entity_id" = ''day_energy_vazio'' and time >= ''{{ now().strftime("%Y-04-14 00:00:00")}}'' and time <= ''{{ now().strftime("%Y-05-14 00:00:00")}}''group by time(1d) tz(''Europe/Lisbon''))'
        group_function: 'sum'
        field: 'last'
        unit_of_measurement: kWh
        value_template: '{{ (value | float) | round(1) }}'
      - name: month energy vazio junho
        measurement: '(select last(value),entity_id FROM kWh'
        where:  '"entity_id" = ''day_energy_vazio'' and time >= ''{{ now().strftime("%Y-05-14 00:00:00")}}'' and time <= ''{{ now().strftime("%Y-06-14 00:00:00")}}''group by time(1d) tz(''Europe/Lisbon''))'
        group_function: 'sum'
        field: 'last'
        unit_of_measurement: kWh
        value_template: '{{ (value | float) | round(1) }}'
      - name: month energy vazio julho
        measurement: '(select last(value),entity_id FROM kWh'
        where:  '"entity_id" = ''day_energy_vazio'' and time >= ''{{ now().strftime("%Y-06-14 00:00:00")}}'' and time <= ''{{ now().strftime("%Y-07-14 00:00:00")}}''group by time(1d) tz(''Europe/Lisbon''))'
        group_function: 'sum'
        field: 'last'
        unit_of_measurement: kWh
        value_template: '{{ (value | float) | round(1) }}'
      - name: month energy vazio agosto
        measurement: '(select last(value),entity_id FROM kWh'
        where:  '"entity_id" = ''day_energy_vazio'' and time >= ''{{ now().strftime("%Y-07-14 00:00:00")}}'' and time <= ''{{ now().strftime("%Y-08-14 00:00:00")}}''group by time(1d) tz(''Europe/Lisbon''))'
        group_function: 'sum'
        field: 'last'
        unit_of_measurement: kWh
        value_template: '{{ (value | float) | round(1) }}'
      - name: month energy vazio setembro
        measurement: '(select last(value),entity_id FROM kWh'
        where:  '"entity_id" = ''day_energy_vazio'' and time >= ''{{ now().strftime("%Y-08-14 00:00:00")}}'' and time <= ''{{ now().strftime("%Y-09-14 00:00:00")}}''group by time(1d) tz(''Europe/Lisbon''))'
        group_function: 'sum'
        field: 'last'
        unit_of_measurement: kWh
        value_template: '{{ (value | float) | round(1) }}'
      - name: month energy vazio outubro
        measurement: '(select last(value),entity_id FROM kWh'
        where:  '"entity_id" = ''day_energy_vazio'' and time >= ''{{ now().strftime("%Y-09-14 00:00:00")}}'' and time <= ''{{ now().strftime("%Y-10-14 00:00:00")}}''group by time(1d) tz(''Europe/Lisbon''))'
        group_function: 'sum'
        field: 'last'
        unit_of_measurement: kWh
        value_template: '{{ (value | float) | round(1) }}'
      - name: month energy vazio novembro
        measurement: '(select last(value),entity_id FROM kWh'
        where:  '"entity_id" = ''day_energy_vazio'' and time >= ''{{ now().strftime("%Y-10-14 00:00:00")}}'' and time <= ''{{ now().strftime("%Y-11-14 00:00:00")}}''group by time(1d) tz(''Europe/Lisbon''))'
        group_function: 'sum'
        field: 'last'
        unit_of_measurement: kWh
        value_template: '{{ (value | float) | round(1) }}'
      - name: month energy vazio dezembro
        measurement: '(select last(value),entity_id FROM kWh'
        where:  '"entity_id" = ''day_energy_vazio'' and time >= ''{{ now().strftime("%Y-11-14 00:00:00")}}'' and time <= ''{{ now().strftime("%Y-12-14 00:00:00")}}''group by time(1d) tz(''Europe/Lisbon''))'
        group_function: 'sum'
        field: 'last'
        unit_of_measurement: kWh
        value_template: '{{ (value | float) | round(1) }}'

###############################################################################
#                                                                             #
#                         HISTORY GRAPH                                       #
#                                                                             #
###############################################################################


history_graph:
  graph_energia_daily:
    name: Daily Consumed Energy
    entities:
      - sensor.day_energy_total
      - sensor.day_energy_vazio
      - sensor.day_energy_fora_vazio
    hours_to_show: 48
    refresh: 30
  graph_energia_montly_julho:
    name: Julho Consumed Energy
    entities:
      - sensor.month_energy_vazio_julho
      - sensor.month_energy_fora_vazio_julho
    hours_to_show: 48
    refresh: 30

###############################################################################
#                                                                             #
#                        C O S T U M I Z E                                    #
#                                                                             #
###############################################################################


homeassistant:
  customize:
#### ENERGIA
    sensor.energy_volt:
      icon: mdi:speedometer
    sensor.energy_hertz:
      icon: mdi:speedometer
    sensor.energy_amp:
      icon: mdi:speedometer
      show_last_changed: true
    sensor.energy_watt:
      icon: mdi:speedometer
      show_last_changed: true
    sensor.energy_power_wh:
      icon: mdi:speedometer
      show_last_changed: true
    sensor.energy_apparent_power:
      icon: mdi:speedometer
      show_last_changed: true
    sensor.daily_energia_cost_total:
      icon: mdi:currency-eur
      show_last_changed: true
    sensor.fatura_energia:
      icon: mdi:currency-eur
      show_last_changed: true
    sensor.montly_consumption_total_euro_fora_vazio:
      icon: mdi:currency-eur
      show_last_changed: true
    sensor.montly_consumption_total_euro_vazio:
      icon: mdi:currency-eur
      show_last_changed: true
    sensor.export_active_energy:
      hidden: true
    sensor.export_reactive_energy:
      hidden: true
    sensor.factor_power:
      hidden: true
    sensor.phase_angle:
      hidden: true
    sensor.total_reactive_energy:
      hidden: true
    sensor.total_active_energy:
      hidden: true
    sensor.reactive_apparent_power:
      hidden: true
    sensor.import_active_energy:
      hidden: true
    sensor.import_reactive_energy:
      hidden: true
    sensor.active_apparent_power:
      hidden: true

#### CONSUMOS DIÁRIOS
    sensor.consumption_daily_total_kwh:
      icon: mdi:sigma
      show_last_changed: true
    sensor.consumption_daily_total_euro:
      icon: mdi:currency-eur
      show_last_changed: true
    sensor.consumption_daily_total_kwh_fora_de_vazio:
      icon: mdi:circle
    sensor.consumption_daily_total_kwh_vazio:
      icon: mdi:circle-outline

#### CONSUMOS MENSAIS
    sensor.consumption_monthly_total_kwh:
      icon: mdi:sigma
      show_last_changed: true
    sensor.consumption_monthly_total_euro:
      icon: mdi:currency-eur
      show_last_changed: true
    sensor.consumption_monthly_total_kwh_fora_de_vazio:
      icon: mdi:circle
    sensor.consumption_monthly_total_kwh_vazio:
      icon: mdi:circle-outline

#### TOTALIZADORES
    sensor.house_consumption_total_kwh:
      icon: mdi:sigma
      show_last_changed: true
    sensor.house_consumption_total_euro:
      icon: mdi:currency-eur
      show_last_changed: true
    sensor.house_consumption_total_fora_de_vazio:
      icon: mdi:circle
    sensor.house_consumption_total_vazio:
      icon: mdi:circle-outline