ืืขืืขืก ืืึธื ืืืขื ืืื ืืึทืงืืืขื ืึท ืฆืึธืืื ื ืคึฟืึทืจ ืขืืขืงืืจืข ืืื ืืืึทืกืขืจ, ืืื ืืื ืกืึทืคึผืจืืืื - ืืื ืืืื ืืฉืคึผืื ืืึทืงืข ืคืึทืจื ืืฆื ืึทืืื ืคืื? ื ื, ืืึธ, ืื ืงืืึธืืขื ืืื ืึท ืืขืึทืืขื ืฉืืึธืง ืืื ืึท ืงืขืกื, ืึธืืขืจ ืืื ืืึธื ื ืื ืคืึทืจืืจืขื ืขื ืคืืจืขืก ืึทืืข ืื ืฆืืึทื. ืืืจ ืืืื ืืืกืงืืืขื ืฆื ืฉืคึผืึธืจื ืืืึทืกืขืจ (ืืึธืืฉ ืืืจ ืืืื ืืื ืฆื ืฉืคึผืจืืฆื ืึทืจืื ืืื ืื ืงืืึธืืขื). ืขืืืขืืข ืืืจ ืฆืืจืืง ืืื ืฉืืื
ืืื ืืขืฆืื ืก ืกืืืืืฉื ืฆื ืืืื ืึทืกืกืืกืืึทื ื ืืื ืืืื ืงืืื ืืืื ืกืืกืืขื. ืืืื ืขืจ ืคืื ืื ืกืืืืช ืืื ืืขืืืขื ืคึผืื ืงื ืื ืืขืืขืื ืืืื ืฆื ืึธืจืืึทื ืืืืจื ืื ืืึทืืืื ื ืคืื ืึท ืืจืืืก ืกืืืข ืคืื โโืืึทืื ืืื ืื ืคืืืืงืืึทื ืฆื ืงืึทื ืืืื ืืึทื ืืื ืืืืขื ืคืึทืจืฉืืื ืืืืคึผืก ืคืื ืืจืึทืคืก.
ืื ืืื ืคึฟืึธืจืืึทืฆืืข ืืืกืงืจืืืื ืืื ืืขื ืึทืจืืืงื ืืื ื ืืฉื ื ืืึท; ืึทืืข ืื ืืืื ืืื ืืขืจ ืคืึทืจืฉืืืขื ืข ืกืึธืกืื ืืึธืื ืฉืืื ืืืกืงืจืืืื ืืืืฃ ืืขืจ ืืื ืืขืจื ืขืฅ. ืืืขืจ ืืขืืขืจ ืึทืจืืืงื ืืืืฉืึทืืืึทืื ืืืฉืจืืืื ืืืืื ืืืื ืฆืืืึทื ื ืึธืืขืจ ืึทืกืคึผืขืงื. ืืื ืืื ืฆื ืคืึทืจืืืืึทืื ืึทืืข ืื ืึทืคึผืจืึธืืืฉืื ืืื ืงืืืึทืื ืื ืืขืจืกื ืคึผืึทืกืืง ืืืื ืขืจ ืืื. ืืขืจ ืึทืจืืืงื ื ืึธื ืืื ื ืืฉื ืคืืืฉืืขื ืืืง ืืื ืคึฟืึธืจืืึทืฆืืข ืืืขืื ืืึทืื ืืึทืืืื ื, ืึธืืขืจ ืืื ืึท ืืื ืคืื ืงืืฆืขืจ ืคืื ืืื ืืื ืืึธื ืืึธืก. ืึทืืื ืงืึทื ืกืืจืึทืงืืืื ืงืจืืืืง ืืื ืคึฟืืจืืืืื ืคึฟืึทืจ ืคึฟืึทืจืืขืกืขืจืื ื ืืขื ืขื ืืึทืืจืืกื.
ืืืกืืึธืืื ื ืคืื ืื ืคึผืจืึธืืืขื
ืืขืจ ืฆืื ืคืื ืืืึทื ื ืก ืืขื ืืืื ื ืืื ืฆื ืืึทืงืืืขื ืฉืืื ืืจืึทืคืก ืคืื ืืืึทืกืขืจ ืืื ืขืืขืงืืจืข ืงืึทื ืกืึทืืฉืึทื:
- ืึทืืจืื ืคึฟืึทืจ 2 ืืขื
- ืืขืืืขื ืคึฟืึทืจ 2 ืืืึธืื
- (ืึทืคึผืฉืึทื ืึทื) ืืืืงืื ืืื ืืืืืขืฉืืขื
ืขืก ืืขื ืขื ืขืืืขืืข ืฉืืืขืจืืงืืืื ืืื ืืขื:
- ื ืึธืจืืึทื ืืฉืึทืจื ืงืึทืืคึผืึธืื ืึทื ืฅ ืืขื ืขื ืืืืฉืึทืืืึทืื ืืึทื ืฅ ืึธืจืขื. ืืื ืืขืกืืขืจ, ืืืจ ืงืขื ืขื ืืืืขื ืึท ืฉืืจื ืืจืึทืคืืง ืคืื ื ืืืจื ืคืื ื.
ืืืื ืืืจ ืงืืง ืฉืืืขืจ ืืขื ืื, ืืืจ ืงืขื ืขื ืืขืคึฟืื ืขื ืืจืื-ืคึผืึทืจืืื ืงืึทืืคึผืึธืื ืึทื ืฅ ืืืึธืก ืืงืกืคึผืึทื ื ืื ืงืืืคึผืึทืืืืึทืืื ืคืื ืื ื ืึธืจืืึทื ืืฉืึทืจื. ืคึฟืึทืจ ืึท ืืืื ืึทืกืืกืืึทื ื, ืืื ืคึผืจืื ืฆืืคึผ, ืืึธืก ืืื ืึท ืืื ืืื ืฉืืื ืงืึธืืคึผืึธื ืขื ื
ืืื ื-ืืจืึทืฃ ืงืึธืจื , ืึธืืขืจ ืขืก ืืื ืืืื ืึท ืืืกื ืืืืืืขื:- ืขืก ืืื ืฉืืืขืจ ืฆื ืฉืืขืื ืื ืคึผืึทืจืึทืืขืืขืจืก ืคืื ืึท ืืึทืจ ืืฉืึทืจื ืืืืขืจ ืืจืืืก ืื ืืขืจืืืึทืื (ืื ืืจืืื ืคืื ืื ืืึทืจ ืืื ืืึทืฉืืืื ืืื ืคืจืึทืงืฉืึทื ื ืคืื ืึท ืฉืขื, ืืืึธืก ืืืื ืื ืืขืจืืืึทืื ืืขืจ ืืื ืึท ืฉืขื ืืืขื ืืืื ืืึทืฉืืืื ืืื ืคืจืึทืงืฉืึทื ืึทื ื ืืืขืจื)
- ืืืจ ืงืขื ืขื ื ืืฉื ืืืืื ืคืึทืจืฉืืืขื ืข ืขื ืืืืื ืฆื ืืืื ืืจืึทืคืืง (ืืืฉื, ืืขืืคึผืขืจืึทืืืจ ืืื ืืืืืืืื, ืึธืืขืจ ืคืึทืจืืื ืื ืึท ืืึทืจ ืืจืึทืคืืงืก ืืื ืึท ืฉืืจื)
- ื ืื ืืืืื ืืื ืืขืจ ืืืื ืึทืกืืกืืึทื ื ืืืจื ืคืขืืืงืืึทื ื ืืฆื ืื ืืขืจืกื ืคึผืจืืืืืืื ืกืงืืืืข ืืึทืืึทืืืืก (ืืื ืืื, ืึท ืืึทื ืืืืึทื, ืงืขื ื ืืฉื ืฉืขืคึผื ืื ืกืืึธืืื ื MySQL ืึธืืขืจ Postgres), ืึธืืขืจ ืื ืืึทืื ืืขื ืขื ื ืืฉื ืกืืึธืจื ืืื ืื ืืขืจืกื ืึธืคึผืืืืึทื ืืืขื. ืึทืืื, ืคึฟืึทืจ ืืืึทืฉืคึผืื, ืืขืืขืจ ืืึธื ืืืจ ืืืืฉื ืืคืืื ืื ืงืืขื ืกืืขืจ ืืืืืืึทื ืคึผืึทืจืึทืืขืืขืจ ืคืื ืึท ืคึผืึทืจืึทืืขืืขืจ, ืึท ืจืืืืง ืืืฉืกืึธื ืืืขืื ืึท ืงืืืึธืืืื ืืื ืืจืืืก ืืื ืืขืฉืจืืื ืฆื ืื ืืึทืืึทืืืืก
{"entity_id": "sensor.water_cold_hourly", "old_state": {"entity_id": "sensor.water_cold_hourly", "state": "3", "attributes": {"source": "sensor.water_meter_cold", "status": "collecting", "last_period": "29", "last_reset": "2020-02-23T21:00:00.022246+02:00", "meter_period": "hourly", "unit_of_measurement": "l", "friendly_name": "water_cold_hourly", "icon": "mdi:counter"}, "last_changed": "2020-02-23T19:05:06.897604+00:00", "last_updated": "2020-02-23T19:05:06.897604+00:00", "context": {"id": "aafc8ca305ba4e49ad4c97f0eddd8893", "parent_id": null, "user_id": null}}, "new_state": {"entity_id": "sensor.water_cold_hourly", "state": "4", "attributes": {"source": "sensor.water_meter_cold", "status": "collecting", "last_period": "29", "last_reset": "2020-02-23T21:00:00.022246+02:00", "meter_period": "hourly", "unit_of_measurement": "l", "friendly_name": "water_cold_hourly", "icon": "mdi:counter"}, "last_changed": "2020-02-23T19:11:11.251545+00:00", "last_updated": "2020-02-23T19:11:11.251545+00:00", "context": {"id": "0de64b8af6f14bb9a419dcf3b200ef56", "parent_id": null, "user_id": null}}}
ืืื ืืึธืื ืืึทื ืฅ ืึท ืคึผืืึทืฅ ืคืื ืกืขื ืกืึธืจืก (ืืขืืคึผืขืจืึทืืืจ ืกืขื ืกืึธืจืก ืืื ืืขืืขืจ ืฆืืืขืจ, ืืืึทืกืขืจ ืืื ืขืืขืงืืจืข ืืขืืขืจ), ืืื ืขืืืขืืข ืืืื ืืืฉืขื ืขืจืืื ืืึทื ืฅ ืึท ืคึผืืึทืฅ ืคืื ืืึทืื. ืคึฟืึทืจ ืืืึทืฉืคึผืื, ืื SDM220 ืขืืขืงืืจืข ืืขืืขืจ ืึทืืืื ืืืฉืขื ืขืจืืืฅ ืืืขืื ืึท ืืืฅ ืืืึทืืืขืก ืืขืืขืจ 10-15 ืกืขืงืื ืืขืก, ืืื ืืื ืืืึธืื ืืื ืฆื ืื ืกืืึทืืืจื ืืืขืื 8 ืึทืืึท ืืขืืขืจ. ืขืก ืืื ืืืื ืึท ืืึทื ืฅ ืืื ืื ืคืื ืคึผืึทืจืึทืืขืืขืจืก ืืืึธืก ืืขื ืขื ืงืึทืืงืืึทืืืืืื ืืืืืจื ืืืืฃ ืื ืืขืจืข ืกืขื ืกืึธืจืก. ืึทื. ืึทืืข ืื ืืืึทืืืขืก ืงืขื ืขื ืืืืื ืื ืคืืืื ืื ืืึทืืึทืืืืก ืืื 100-200 ืืขืืืืืืื ืืขืืืขื. ืืื ืึท ืืืึธื ืื ืกืืกืืขื ืืืขื ืงืืื ืจืืจื, ืืื ืืื ืึท ืืืืฉ ืื ืืืืฅ ืคืึธืจ ืืืขื ืฉืืึทืจืื (ืืื ืื ืคืึทื ืคืื ืึท ืืืคึผืืฉ ืืืื ืึทืกืืกืืึทื ื ืื ืกืืึทืืืจืื ื ืืืืฃ ืึท Raspberry PI), ืืื ืกืืึธืจืื ื ืืึทืื ืคึฟืึทืจ ืึท ืืึทื ืฅ ืืึธืจ ืืื ื ืืฉื ืื ืงืฉืื.
- ืืืื ืืืจ ืืขื ื ืืึทืืืืืง, ืืืื ืืขืืขืจ ืงืขื ืขื ืฆืืืื ืงืึทื ืกืึทืืฉืึทื ืืื. ืืืจ ืงืขื ืขื ืืืขื ืื ืฆื ืื ืืขืืขืจ ืืื ืงืืื ืฆืืื ืืื ืคืจืขืื ืืืึธืก ืืึธื ืื ืึทืงืืืืืึทืืืืืื ืงืึทื ืกืึทืืฉืึทื ืืืขืจื ืืื. ืืื ืึทืืืขืืืื, ืึทืืข ืขืืขืงืืจืข ืืขืืขืจ ืืืึธืก ืืึธืื ืึท ืืืืืืึทื ืฆืืืื ื (RS232/RS485/Modbus/Zigbee) ืฆืืฉืืขืื ืื ืืขืืขืื ืืืื.
ืขืก ืืื ืขืจืืขืจ ืืืื ืื ืืืื ืงืขื ืขื ืคืฉืื ืืขืกืื ืขืืืขืืข ืื ืกืืึทื ืืึทื ืืึทืก ืคึผืึทืจืึทืืขืืขืจ (ืืืฉื, ืื ืกืืึทื ืืึทื ืืึทืก ืืึทืื ืึธืืขืจ ืงืจืึทื ื), ืึธืืขืจ ืคืฉืื ืืืฉืขื ืขืจืืื ืคึผืึทืืกืื ืืขืืขืจ X ืืืื-ืฉืขื ืึธืืขืจ ืืืืขืจ. ืืขืืึธืื ืืืจ ืืึทืจืคึฟื ืฆื ืืจืึทืืื ืืืขืื ืืื ืืื ืืื ืืืึธืก ืฆื ืืืกืฉืืืืขื ืขืก ืืื ืืื ืฆื ืึธื ืงืืืึทืื ืืืขืจื. ืขืก ืืื ืึท ืจืืืืงืืจื ืคืื ืคืขืื ืืืง ืื ืืืืึทืืขืจ ืืึทืจืืื ืคึฟืึทืจ ืงืืื ืกืืื, ืืื ืื ืึทืงืืขืจืึทืกื ืคืื ืื ืกืืกืืขื ืืื ืึท ืืึทื ืฅ ืจืืืืึทื ืคึฟืจืืื. ืืืจ ืงืขื ื ืืึธื ืืึธืก ืึทืืฅ ืืืืขืจืืขืื ืฆื ืึท ืงืืื ืืืื ืกืืกืืขื ืืื ืึท ืืืื ืึทืกืืกืืึทื ื, ืึธืืขืจ ืงืืื ืืืื ืขืจ ืืื ืงืึทื ืกืึทืื ืื ืคืื ื ืืืขืื ืื ื ืืืขืจ ืคืื ืจืขืงืึธืจืืก ืืื ืื ืืึทืืึทืืืืก, ืืื ืขืก ืืืขื ื ืืฉื ืืืื ืืขืืืขื ืฆื ืืึทืงืืืขื ืกืขื ืกืึธืจืก ืืขืจ ืืื ืึทืืึธื ืึท ืจืืข (ืึท ืืึทืืจืขื ืขืฆืื ื ืคืื ืื ืืืื ืึทืกืืกืืึทื ื ืึทืจืงืึทืืขืงืืฉืขืจ).
ืฆืืืึทื ื 1
ืขืจืฉืืขืจ, ืืึธืืืจ ืืขื ืืืึธืก ืืืื ืึทืกืืกืืึทื ื ืืื ืืืืก ืคืื ืื ืงืขืกืื. ืืขืกืื ืงืึทื ืกืึทืืฉืึทื ืืืืขืจ ืึท ืคึผืขืจืืึธื ืืื ืึท ืืขืืกื ืืขืืืื ืคืึทื ืืงืฉืึทื ืึทืืืื. ืคืื ืงืืจืก, ืขืก ืืื ืืขืืืขื ืืืคึผืืึทืืขื ืึทื ืึท ืืึทื ื ืฆืืึทื ืฆืืจืืง ืืื ืื ืคืึธืจืขื ืคืื ืึท ืกืคึผืขืฉืึทืืืืื ืงืึธืืคึผืึธื ืขื ื - utility_meter.
ืื ืขืกืึทื ืก ืคืื ืื ืงืึธืืคึผืึธื ืขื ื ืืื ืึทื ืขืก ืื ืขืืืืื ืืง ืงืจืืืืฅ ืึท ืืืขืจืืึทืืึทื ืงืจืึทื ื_ืึทืงืงืืืืืึทืืขื_ืืืึทืืื ืืื ืจืืกืขืฅ ืขืก ื ืึธื ืึท ืกืคึผืขืกืืคืืขื ืฆืืื (ืฉืขื / ืืืึธื / ืืืืฉ). ืืขืจ ืงืึธืืคึผืึธื ืขื ื ืืื ืืึธื ืืืึธืจืก ืื ืึทืจืืึทื ืฉืจืืึทื ืืืึทืืขืืืืืง (ืื ืืืขืจื ืคืื ืขืืืขืืข ืกืขื ืกืขืจ), ืึทืืึธื ืืจื ืืื ืฆื ืขื ืืขืจืื ืืขื ืืื ืื ืืืขืจื - ืืืจ ื ืึธืจ ืืึทืงืืืขื ืื ืคืึทืจืืืง ืจืขืืืืืึทื. ืื ืืึทื ืืื ืืืกืงืจืืืื ืืื ืืืืื ืึท ืืืกื ืฉืืจืืช ืืื ืื ืงืึทื ืคืืืืขืจืืืฉืึทื ืืขืงืข
utility_meter:
water_cold_hour_um:
source: sensor.water_meter_cold
cycle: hourly
water_cold_day_um:
source: sensor.water_meter_cold
cycle: daily
ืืึธ ืกืขื ืกืขืจ.ืืืึทืืขืจ_ืืขืืขืจ_ืงืึธืื ืืื ืื ืงืจืึทื ื ืืขืืขืจ ืืืขืจื ืืื ืืืืขืจ ืึทื ืืื ืืึทืงืืืขื
ืืขืจ ืงืึธื ืคึฟืึทืจ ืึทืืจืื ืืื ืืขืืืขื ืืฉืึทืจืฅ ืคึฟืึทืจ lovelace-UI ืงืืงื ืืื ืืึธืก:
- type: history-graph
title: 'Hourly water consumption using vars'
hours_to_show: 48
entities:
- sensor.water_hour
- type: history-graph
title: 'Daily water consumption using vars'
hours_to_show: 360
entities:
- sensor.water_day
ืึทืงืืืึทืืื, ืื ืคึผืจืึธืืืขื ืืื ืืขื ืฆืืืึทื ื ืืืื ืืื ืืขื ืึทืืืขืจืืืึทื. ืืื ืืื ืฉืืื ืืขืจืืื ื, ืคึฟืึทืจ ืืขืืขืจ ืึทืจืืึทื ืฉืจืืึทื ืืืขืจื (ืงืจืึทื ื ืืขืืขืจ ืืืืขื ืขื ืคึฟืึทืจ ืืขืืขืจ ืืืืึทืืขืจ ืืืืขืจ) 1 ืงื ืคืื ืจืขืงืึธืจืืก ืืขื ืขื ืืืฉืขื ืขืจืืืืึทื ืืื ืื ืืึทืืึทืืืืก. ืืขืืขืจ ื ืืฆื ืืขืืขืจ ืืืื ืืืฉืขื ืขืจืืืฅ ืึท ื ืืึท ืืืขืจื, ืืืึธืก ืืื ืืืื ืืืกืืฃ ืฆื ืื ืืึทืืข. ืืืื ืืื ืืืืื ืฆื ืงืืืึทืื ืึท ืฉืขื / ืืขืืืขื / ืืืืงืื / ืืืืืขืฉืืขื ืจืืืื ืื, ืืื ืคึฟืึทืจ ืขืืืขืืข ืืืึทืกืขืจ ืจืืืืขืจื, ืืื ืืืืื ืึท ืคึผืึทืง ืคืื ืขืืขืงืืจืืง ืืขืืขืจ, ืืึธืก ืืืขื ืืืื ืึท ืคึผืืึทืฅ ืคืื ืืึทืื. ื ื, ืืขืจ ืืขื ืื, ืขืก ืืื ื ืืฉื ืึท ืคึผืืึทืฅ ืคืื ืืึทืื, ืึธืืขืจ ืืื ื ืืขืจ ืืืื ืึทืกืืกืืึทื ื ืฉืจืืืื ืึท ืืื ืื ืคืื ืืื ืืืืืง ืืื ืคึฟืึธืจืืึทืฆืืข ืฆื ืื ืืึทืืึทืืืืก, ืื ืืจืืืก ืคืื ืื ืืึทืืึทืืืืก ืืืขื ืืืึทืงืกื ืืืจื ืืืคึผืก ืืื ืืืืื. ืืื ืืื ืืขืจืฉืจืึธืงื ืฆื ืืคืืื ืึธืคึผืฉืึทืฆื ืื ืืจืืืก ืคืื ืืขืจ ืืึทืืข ืคึฟืึทืจ ืืืืงืื ืืื ืืืืืขืฉืืขื ืืฉืึทืจืฅ.
ืืื ืืขืจืฆื, ืื ื ืืฆื ืืขืืขืจ ืืืจื ืืื ืืื ื ืืฉื ืกืึธืืืืข ืื ืคึผืจืึธืืืขื. ืื ืืจืึทืคืืง ืคืื ืื ืืืึทืืืขืก ืืขืฉืืคื ืืืจื ืื ื ืืฆื ืืขืืขืจ ืืื ืึท ืืึทื ืึทืืึทื ืืงืื ืื ืงืจืืกืื ื ืคืื ืงืฆืืข ืืืึธืก ืจืืกืขืฅ ืฆื 0 ืืขืืขืจ ืฉืขื. ืืืจ ืืึทืจืคึฟื ืึท ืงืึทื ืกืึทืืฉืึทื ืืฉืึทืจื ืืืึธืก ืืื ืคืึทืจืฉืืืืืง ืฆื ืืขืจ ืืึทื ืืฆืขืจ, ืืืืืืื ื ืืื ืคืืืข ืืืืขืจ ืืขื ืขื ืงืึทื ืกืืื ืืขืฉืึทืก ืืขืจ ืฆืืึทื. ืืขืจ ื ืึธืจืืึทื ืืขืฉืืืืข-ืืจืึทืฃ ืงืึธืืคึผืึธื ืขื ื ืงืขื ื ืืฉื ืืึธื ืืึธืก, ืึธืืขืจ ืื ืคืื ืืจืืืกื ืืืง ืืื ื-ืืจืึทืฃ ืงืึธืจื ืงืึธืืคึผืึธื ืขื ื ืงืขื ืขื ืืขืืคึฟื ืืื ืื.
ืืึธืก ืืื ืื ืงืึธืจื ืงืึธื ืคึฟืึทืจ lovelace-UI:
- aggregate_func: max
entities:
- color: var(--primary-color)
entity: sensor.water_cold_hour_um
group_by: hour
hours_to_show: 48
name: "Hourly water consumption aggregated by utility meter"
points_per_hour: 1
show:
graph: bar
type: 'custom:mini-graph-card'
ืืื ืึทืืืฉืึทื ืฆื ื ืึธืจืืึทื ืกืขืืืื ืืก ืืื ืกืขื ืกืขืจ ื ืึธืืขื, ืืจืึทืคืืง ืืืคึผ, ืงืึธืืืจ (ืืื ืืื ื ืื ืืื ืืขืจ ื ืึธืจืืึทื ืืึทืจืึทื ืฅ), ืขืก ืืื ืืืืืืืง ืฆื ืืึธื 3 ืกืขืืืื ืืก:
- group_by:hour - ืื ืืจืึทืคืืง ืืืขื ืืืื ืืืฉืขื ืขืจืืืืึทื ืืื ืื ืืึทืจืก ืึทืืืื ื ืฆื ืื ืึธื ืืืื ืคืื ืื ืฉืขื
- points_per_hour: 1 - ืืืื ืืึทืจ ืคึฟืึทืจ ืืขืืขืจ ืฉืขื
- ืืื ืจืืึฟ ืืืคึผืึธืจืืึทื ืืื, aggregate_func: max - ื ืขืืขื ืื ืืึทืงืกืืืื ืืืขืจื ืืื ืืขืืขืจ ืฉืขื. ืขืก ืืื ืืขื ืคึผืึทืจืึทืืขืืขืจ ืืืึธืก ืืืจื ืก ืื ืืขืืืึธืึธื ืืจืึทืคืืง ืืื ืืึทืจืก
ืื ืืืืกื ื ืืฉื ืืึทืฆืึธืื ืืคืืขืจืงืืึทืืงืืึทื ืฆื ืื ืจืืืขืจื ืคืื ืฉืคืืืื ืืืืฃ ืื ืืื ืงืก - ืืึธืก ืืื ืืขืจ ื ืึธืจืืึทื ื ืึทืืืจ ืคืื ืื ืงืึธืืคึผืึธื ืขื ื ืืืื ืขืก ืืื ืงืืื ืืึทืื. ืึธืืขืจ ืขืก ืืื ืืขืืืขื ืงืืื ืืึทืื - ืืื ื ืึธืจ ืืืืกืืขืืจืืื ืืืืฃ ื ืืฆื ืืขืืขืจ ืืึทืื ืืึทืืืื ื ืึท ืคึผืึธืจ ืคืื ืฉืขื ืฆืืจืืง ื ืึธืจ ืคึฟืึทืจ ืื ืฆืืืื ืคืื ืืขื ืึทืจืืืงื (ืืื ืืืขื ืืึทืฉืจืืึทืื ืืืื ืงืจืึทื ื ืฆืืืึทื ื ืืื ืื).
ืืื ืืขื ืืืื ืืื ืืขืืืืื ืฆื ืืืืึทืื ืึทื ืืื ืื ืืึทืื ืึทืจืืืกืืืืึทืื ืืคืืื ืึทืจืืขื ืืื ืื ืืึทืจืก ืึทืงืฉืื ืคืึทืจืืจืึทืืื ืืื ืื ืจืืืืืง ืืืึทืืืขืก. ืืืขืจ ืึทื ืก 'ื ืืฉื ืึทืืข. ืคึฟืึทืจ ืขืืืขืืข ืกืืื, ืื ืืืืกืืขืงืืืื ืืืึทื ืคึฟืึทืจ ืื ืฆืืื ืคืื 11 ืฆื 12:19 ืืืกืคึผืืืื 62 ืืืืขืจ, ืืึธืืฉ ืืืืฃ ืื ืืึธืื ืืจืึทืคืืง ืึท ืืืกื ืืขืืขืจ ืคึฟืึทืจ ืืขืจ ืืขืืืืงืขืจ ืคึผืขืจืืึธื ืคืื ืืขืจ ืืขืืืืงืขืจ ืกืขื ืกืขืจ ืืืจ ืืขื ืงืึทื ืกืึทืืฉืึทื ืคืื XNUMX ืืืืขืจ. ืึธืืขืจ ืขืก ืืื ืึท ืืฉืืง ืึธืืขืจ ืื ืืขื ื ืืขื ืขื ืงืจืื. ืึธืืขืจ ืืื ื ืึธื ืืึธื ื ืื ืคึฟืึทืจืฉืืืื ืืืึธืก ืื ืืึทืื ืืืืฃ ืื ืจืขืื ืฆืขืืจืืื ืึทืืืขืง - ืงืึทื ืกืึทืืฉืึทื ืขืก ืืื ืืขืืืขื ื ืึธืจืืึทื, ืืืึธืก ืืื ืืืื ืงืขื ืืืง ืคึฟืื ืื ืืึธืื ืืจืึทืคืืง.
ืืื ืึทืืืขืืืื, ืืื ืืื ืืขืืืขื ื ืื ืืืืืืช ืฆื ืืขืจืืจืืืื ืื ืืืืืืืขืืงืืื ืคืื ืืขื ืฆืืืึทื ื - ืื ืืจืึทืคืืง ืึผืืขื ืฉืืขื ืืืง ืืืืืื ืึท ืืื ืคืื ืืคืืงืืจืกืืช.
ืขื ืืขื ืงืึธื ืคึฟืึทืจ ืื ืืืืืืื ืกืขื ืกืขืจ.
- aggregate_func: max
entities:
- color: var(--primary-color)
entity: sensor.water_cold_day_um
group_by: interval
hours_to_show: 360
name: "Daily water consumption aggregated by utility meter"
points_per_hour: 0.0416666666
show:
graph: bar
type: 'custom:mini-graph-card'
ืืืืข ืืึธื ืึทื ืืขืจ group_by ืคึผืึทืจืึทืืขืืขืจ ืืื ืืึทืฉืืืื ืฆื ืืขืืึทืืขื, ืืื ืื points_per_hour ืคึผืึทืจืึทืืขืืขืจ ืึผืืืื ืึทืืฅ. ืืื ืืขืจืื ืืืื ืื ืื ืืขืจ ืคึผืจืึธืืืขื ืืื ืืขื ืงืึธืืคึผืึธื ืขื ื - points_per_hour ืึทืจืืขื ืืขืืื ื ืืืืฃ ืืฉืึทืจืฅ ืคืื ืึท ืฉืขื ืึธืืขืจ ืืืืื ืืงืขืจ, ืึธืืขืจ ืขืก ืกืึทืงืก ืืืืฃ ืืจืขืกืขืจืข ืื ืืขืจืืืึทืื. ืึทืืื ืืื ืกืืจ ืฆื ืืึทืงืืืขื ืืืื ืืืึทื ืืื ืืืื ืืึธื, ืืื ืืื ืฆื ืึทืจืืึทื ืื ืืืขืจื 1/24=0.04166666. ืืื ืจืขื ืืคืืื ื ืืฉื ืคืื ืืืืื ืฉืจืืคื ืืื ืืืืืขืฉืืขื ืืฉืึทืจืฅ.
ืฆืืืึทื ื 2
ืืฉืขืช ืืื ื ืึธื ืคึฟืึทืจืฉืืืื ืืืื ืึทืกืืกืืึทื ื, ืืื ืืขืคึฟืื ืขื ืืขื ืืืืืขื:
ื ืคืจืืึทื ื ืงืึทืืขืงืฅ ืงืึทื ืกืึทืืฉืึทื ืืึทืื ืคืื ืขืืืขืืข ืืืืคึผืก ืคืื Xiaomi ืกืึทืงืึทืฅ. ืืืื ืึทืจืืขื ืืื ืึท ืืืกื ืกืืืคึผืืขืจ - ื ืึธืจ ืืืืึทืื ืื ืงืึทื ืกืึทืืฉืึทื ืืืขืจื ืคึฟืึทืจ ืืืึทื ื, ื ืขืืื ืืื ืคึฟืึทืจ ืื ืืืืฉ. ื ืื ืงืืื ืกืงืขืืืฉืืื ืคืืจืืื ืื.
ืืึธืืืจ ืืึธืื ืืืกืงืืกืืขืก ืืืขืื ืืึทื ืืึทื ืื ืึทืืจืืืฉืึทื ืคืื ืื ืกืืึทื ืืึทื ืืึทืก ืืึทืื ืืืึทืืืขืก ืืึทืืื ืืขืจ - ืืื ืฉืืื ืืขืฉืจืืื ืืืืื ืืืขืื ืื "ืคึผืื ืืืขืืงืืื" ืคืื ืืขื ืฆืืืึทื ื. ืขืก ืืื ื ืืฉื ืงืืึธืจ ืืืึธืก ืขืจ ืืื ื ืืฉื ื ืืฆื ืื ืึทืงืืืืืึทืืืืืื ืงืึทื ืกืึทืืฉืึทื ืืืึทืืืขืก, ืืืึธืก ืืขื ืขื ืฉืืื ืืขืืืืื ืืืจื ืื ืืขืืืข ืืืขื ืืื. ืืื ืืืื ืืืื ืื ื, ืื ืึทืืจืืืฉืึทื ืืื ืื ืืึทืื ืืืึทืจื ืืืขื ืึทืจืืขืื ืืขืกืขืจ.
ืคึฟืื ืื ืืืืืขื ืืืจ ืืืขืื ื ืขืืขื ืื ืืขืืึทื ืง ืคืื ืืึทื ืืืึทืื ืงืึทืื ืืื ื ืงืึทื ืกืึทืืฉืึทื ืืืืขืจ ืึท ืคึผืขืจืืึธื. ืืขืจ ืืึธืืขืจ ืจืขืื ื ืืืืื ืื ืืืึทืืืขืก ืคึฟืึทืจ ืืืึทื ื ืืื ื ืขืืื, ืึธืืขืจ ืืืจ ืืืขืื ืืืื ืืืืึทืืขืจ ืืื ืคึผืจืืืืจื ืฆื ืฆืืขื ืึท ืืจืึทืคืืง. ืื ืขืกืึทื ืก ืคืื ืื ืคืืจืืขืืืืื ืืืคึฟื ืืื ืืืื ืคืึทื ืืื ืืื ืืืื.
ืืึธืืืจ ืฉืึทืคึฟื ืึท ืืืขืจืืึทืืึทื ืืืึทืืืืข_ืืืึท_ืื_ืึธื ืืืื_ืคืื_ืฉืขื, ืืื ืืืึธืก ืืืจ ืืืขืื ืจืขืงืึธืจืืืจื ืื ืงืจืึทื ื ืืขืืขืจ ืจืืืื ืื
ื ืืฆื ืื ืืืึทืืขืจ, ืืื ืื ืกืืฃ ืคืื ืื ืฉืขื (ืึธืืขืจ ืืื ืื ืึธื ืืืื ืคืื ืืขืจ ืืืืึทืืขืจ) ืืืจ ืจืขืืขื ืขื ืื ืืืืืง ืฆืืืืฉื ืื ืงืจืึทื ื ืืืืขื ืขื ืืื ืื ืกืืึธืจื ืืื ืื ืึธื ืืืื ืคืื ืื ืฉืขื. ืืขืจ ืืืืืง ืืืขื ืืืื ืื ืงืึทื ืกืึทืืฉืึทื ืคึฟืึทืจ ืื ืงืจืึทื ื ืฉืขื - ืืืจ ืืืขืื ืจืึทืืขืืืขื ืื ืืืขืจื ืืื ืื ืกืขื ืกืขืจ, ืืื ืืื ืืขืจ ืฆืืงืื ืคึฟื ืืืจ ืืืืขื ืึท ืืจืึทืคืืง ืืืืืจื ืืืืฃ ืืขื ืืืขืจื.
ืืืจ ืืืื ืืึทืจืคึฟื ืฆื "ืืึทืฉืืขืืืง" ืื value_at_beginning_of_hour ืืืึทืืขืืืืืง ืืืจื ืฉืจืืืื ืื ืงืจืึทื ื ืืึธืืืึทื ืง ืืืขืจื ืืึธืจื.
ืึทืืข ืืขื ืงืขื ืขื ืืืื ืืขืืื ืืืจื ืื ืืืื ืึทืกืืกืืึทื ื ืืื.
ืืืจ ืืืขื ืืึธืื ืฆื ืฉืจืืึทืื ืึท ืืืกื ืืขืจ ืงืึธื ืืื ืืื ืื ืคืจืืขืจืืืงืข ืฆืืืึทื ื. ืขืจืฉืืขืจ, ืืึธืื ืืื ืื ืืึทืื ืื ืืขืืืข "ืืืขืจืึทืืึทืื". ืืืืก ืคืื ืื ืงืขืกืื ืืืจ ืืึธื ื ืื ืืึธืื ืื "ืืืึทืจืืึทืืืข" ืขื ืืืื, ืึธืืขืจ ืืืจ ืงืขื ืขื ื ืืฆื ืื ืกืขืจืืืืกืขืก ืคืื ืื mqtt ืืขืงืืขืจ. ืืืจ ืืืขืื ืฉืืงื ืืืึทืืืขืก ืืึธืจื ืืื ืื ืจืืืืื = ืืืช ืคืึธื - ืืึธืก ืืืขื ืจืึทืืขืืืขื ืื ืืืขืจื ืื ืืขืจ ืืขืงืืขืจ, ืืื ืขืก ืงืขื ืขื ืืืื ืคึผืืื ืคึฟืื ืืึธืจื ืืื ืงืืื ืฆืืื, ืืคืืื ืืืขื ืื ืืืื ืึทืกืืกืืึทื ื ืืื ืจืขืืึธืึธืืขื. ืืื ืืขืืืื ืึทืืจืื ืืื ืืขืืืขื ืงืึธืื ืืขืจืก ืืื ืึทืืึธื.
- platform: mqtt
state_topic: "test/water/hour"
name: water_hour
unit_of_measurement: l
- platform: mqtt
state_topic: "test/water/hour_begin"
name: water_hour_begin
unit_of_measurement: l
- platform: mqtt
state_topic: "test/water/day"
name: water_day
unit_of_measurement: l
- platform: mqtt
state_topic: "test/water/day_begin"
name: water_day_begin
unit_of_measurement: l
ืึทืืข ืืึทืืืฉ ืืึทืคึผืึทื ื ืืื ืื ืึธืืึทืืืืฉืึทื, ืืืึธืก ืืืืคื ืจืืกืคึผืขืงืืืืืื ืืขืืขืจ ืฉืขื ืืื ืืขืืขืจ ื ืึทืื.
- id: water_new_hour
alias: water_new_hour
initial_state: true
trigger:
- platform: time_pattern
minutes: 0
action:
- service: mqtt.publish
data:
topic: "test/water/hour"
payload_template: >
{{ (states.sensor.water_meter_cold.state|int) - (states.sensor.water_hour_begin.state|int) }}
retain: true
- service: mqtt.publish
data:
topic: "test/water/hour_begin"
payload_template: >
{{ states.sensor.water_meter_cold.state }}
retain: true
- id: water_new_day
alias: water_new_day
initial_state: true
trigger:
- platform: time
at: "00:00:00"
action:
- service: mqtt.publish
data:
topic: "test/water/day"
payload_template: >
{{ (states.sensor.water_meter_cold.state|int) - (states.sensor.water_day_begin.state|int) }}
retain: true
- service: mqtt.publish
data:
topic: "test/water/day_begin"
payload_template: >
{{ states.sensor.water_meter_cold.state }}
retain: true
ืืืืืข ืึธืืึทืืืืฉืึทื ื ืืืจืืคืืจื 2 ืึทืงืฉืึทื ื:
- ืจืขืืขื ืขื ืื ืืืขืจื ืคึฟืึทืจ ืึท ืืขืืึทืืขื ืืื ืื ืืืืืง ืฆืืืืฉื ืื ืึธื ืืืื ืืื ืกืืฃ ืืืึทืืืขืก
- ืืขืจืืืึทื ืืืงื ืื ืืึทืืข ืืืขืจื ืคึฟืึทืจ ืื ืืืืึทืืขืจ ืืขืืึทืืขื
ืื ืงืึทื ืกืืจืึทืงืฉืึทื ืคืื ืืจืึทืคืก ืืื ืืขื ืคืึทื ืืื ืกืึทืืืื ืืืจื ืื ืืขืืืืื ืืืขื ืืขืฉืืืืข-ืืจืึทืฃ:
- type: history-graph
title: 'Hourly water consumption using vars'
hours_to_show: 48
entities:
- sensor.water_hour
- type: history-graph
title: 'Daily water consumption using vars'
hours_to_show: 360
entities:
- sensor.water_day
ืขืก ืงืืงื ืืื ืืึธืก:
ืืื ืคึผืจืื ืฆืืคึผ, ืืึธืก ืืื ืฉืืื ืืืึธืก ืืื ืืืจืฃ. ืื ืืืึทืืข ืคืื โโืืขื ืืืคึฟื ืืื ืึทื ืื ืืึทืื ืืขื ืขื ืืืฉืขื ืขืจืืืืึทื ืึทืืึธื ืคึผืขืจ ืืขืืึทืืขื. ืืขื ืข. ืืืืื 24 ืจืขืงืึธืจืืก ืคึผืขืจ ืืึธื ืคึฟืึทืจ ืึท ืึทืืจืื ืืฉืึทืจื.
ืฆืื ืืึทืืืืขืจื, ืืึธืก ื ืึธื ืืื ื ืืฉื ืกืึธืืืืข ืื ืึทืืืขืืืื ืข ืคึผืจืึธืืืขื ืคืื ืึท ืืจืึธืืื ื ืืึทืืข. ืืืื ืืื ืืืืื ืึท ืืืืืขืฉืืขื ืงืึทื ืกืึทืืฉืึทื ืืจืึทืคืืง, ืืื ืืืขื ืืึธืื ืฆื ืงืจืึธื ืืึทืื ืคึฟืึทืจ ืืืึท ืืื ืืกืืขืจ ืึท ืืึธืจ. ืืื ืืื ื ืืขืจ ืืืื ืึทืกืืกืืึทื ื ืืื ืืืืื ืืืื ืกืืึธืจืืืืฉ ืืขืืืืขืจ ืืึทืฉืืขืืืงื ืคึฟืึทืจ ืื ืืื ืฆืข ืืึทืืึทืืืืก, ืืึธืก ืืืื ืึทื ืึทืืข ืืึทืื ืืื ืื ืกืืกืืขื ืืืขื ืืืื ืกืืึธืจื ืคึฟืึทืจ ืึท ืืึทื ืฅ ืืึธืจ. ืคึฟืึทืจ ืืืึทืฉืคึผืื, ืืื ืึท ืืึธืจ ืืื ืคืึทืจื ืืฆื 200 ืงืืืืง ืืขืืขืจ ืคืื ืืืึทืกืขืจ, ืืืึธืก ืืืื ืึทื ืืึธืก ืืืื 200000 ืืืื ืกื ืืื ืื ืืึทืืึทืืืืก. ืืื ืืืื ืืืจ ื ืขืืขื ืืื ืืฉืืื ืื ืืขืจืข ืกืขื ืกืึธืจืก, ืื ืคืืืืจ ืืืขืจื ืืืื ืึธืจื ืืืขื.
ืฆืืืึทื ื 3
ืฆืื ืืืืง, ืงืืื ืืขื ืืฉื ืืึธืื ืฉืืื ืกืึทืืืื ืืขื ืคึผืจืึธืืืขื ืืืจื ืฉืจืืืื ืื InfluxDB ืืึทืืึทืืืืก. ืื ืืึทืืึทืืืืก ืืื ืกืคึผืขืฆืืขื ืึธืคึผืืืืืืขื ืคึฟืึทืจ ืกืืึธืจืื ื ืฆืืื-ืืืืืจื ืืึทืื ืืื ืืื ืืืขืึทื ืคึฟืึทืจ ืกืืึธืจืื ื ืืืึทืืืขืก ืคืื ืคืึทืจืฉืืืขื ืข ืกืขื ืกืึธืจืก. ืื ืกืืกืืขื ืืืื ืคึผืจืึธืืืืืขืก ืึท SQL-ืืื ืึธื ืคึฟืจืขื ืฉืคึผืจืึทื ืืืึธืก ืึทืืึทืื ืืืจ ืฆื ืขืงืกืืจืึทืงื ืืืึทืืืขืก ืคืื ืื ืืึทืืึทืืืืก ืืื ืืขืจื ืึธื ืึทืืืจืขืืืจื ืืื ืืื ืคืึทืจืฉืืื ืืืขืื. ืฆืื ืกืืฃ, ืคืึทืจืฉืืืขื ืข ืืึทืื ืงืขื ืขื ืืืื ืกืืึธืจื ืคึฟืึทืจ ืคืึทืจืฉืืืขื ืข ืฆืืื. ืคึฟืึทืจ ืืืึทืฉืคึผืื, ืึธืคื ืืฉืึทื ืืื ื ืจืืืื ืื ืืื ืืขืืคึผืขืจืึทืืืจ ืึธืืขืจ ืืืืืืืื ืงืขื ืขื ืืืื ืกืืึธืจื ืคึฟืึทืจ ืืืืื ืึท ืคึผืึธืจ ืคืื ืืืึธืื, ืืฉืขืช ืืขืืืขื ืืืึทืกืขืจ ืงืึทื ืกืึทืืฉืึทื ืจืืืื ืื ืงืขื ืขื ืืืื ืกืืึธืจื ืคึฟืึทืจ ืึท ืืึทื ืฅ ืืึธืจ.
ืืืฅ InfluxDB, ืงืืื ืืขื ืืฉื ืืืื ืื ืืืขื ืืึทื Grafana, ืึท ืกืืกืืขื ืคึฟืึทืจ ืฆืืืืขื ืื ื ืืจืึทืคืก ืืืืืจื ืืืืฃ ืืึทืื ืคึฟืื InfluxDB. ืืจืึทืคืึทื ืึท ืงืขื ืขื ืฆืืขื ืคืึทืจืฉืืืขื ืข ืืืืคึผืก ืคืื ืืจืึทืคืก, ืงืึทืกืืึทืืืื ืืื ืืื ืืขืืึทื, ืืื, ืจืืึฟ ืืืคึผืึธืจืืึทื ืืื, ืื ืืจืึทืคืก ืงืขื ืขื ืืืื "ืคึผืืึทืื" ืืืืฃ ืื ืืึธืืืขืืึทืกืข-ืื ืืืื ืึทืกืืกืืึทื ื.
ืืึทืงืืืขื ืื ืกืคึผืืืขืจื
ืึทืืื, ืขืจืฉืืขืจ ืคืื ืึทืืข, ืืึธืื ืืื ืื ืึธื ืืืืื ืฆื ืืืืื ืื ืืึธืืืึทื ืง ืืืขืจื ืืื ืื ืคืืืงืกืื. ื ืฉืืืง ืคืื ืืขืจ ืืืื ืึทืกืืกืืึทื ื ืงืึทื ืคืืืืขืจืืืฉืึทื (ืืื ืืขื ืืืึทืฉืคึผืื ืืื ืืืขื ืืึธืื ืฉืคึผืึทืก ืืื ื ืื ืืืืื ืงืึทืื, ืึธืืขืจ ืืืื ืืืืก ืืืึทืกืขืจ):
influxdb:
host: localhost
max_retries: 3
default_measurement: state
database: homeassistant
include:
entities:
- sensor.water_meter_hot
- sensor.water_meter_cold
ืืึธืืืจ ืืืกืืืืึทื ืฉืคึผืึธืจื ืื ืืขืืืข ืืึทืื ืืื ืื ืื ืขืจืืขื ืืืื ืึทืกืืกืืึทื ื ืืึทืืึทืืืืก ืึทืืื ื ืืฉื ืฆื ืืืึธืื ืขืก ืืืืืขืจ:
recorder:
purge_keep_days: 10
purge_interval: 1
exclude:
entities:
- sensor.water_meter_hot
- sensor.water_meter_cold
ืืึธืืืจ ืืืฆื ืืืื ืฆื ืื InfluxDB ืงืึทื ืกืึธืื ืืื ืงืึทื ืคืืืืขืจ ืืื ืืืขืจ ืืึทืืึทืืืืก. ืืื ืืึทืืื ืืขืจ, ืืืจ ืืึทืจืคึฟื ืฆื ืงืึทื ืคืืืืขืจ ืืื ืืึทื ื ืืืืขืจ ืืึทืื ืืืขื ืืืื ืกืืึธืจื. ืืขื ืืื ืจืขืืืึทืืืืืึทื ืืืจื ืื ืึทืืื ืืขืจืืคืขื ืข. ืจืืืขื ืฉืึทื ืคึผืึธืืืืืง - ืืึธืก ืืื ืขื ืืขื ืฆื ืืึทืืึทืืืืกืื ืืื ืึท ืืืืคึผื ืืึทืืึทืืืืก, ืืื ืืขืืขืจ ืื ืขืจืืขื ืืึทืืึทืืืืก ืืื ืืืื ืืืืืขื ืข ืกืขืืืื ืืก. ืืืจื ืคืขืืืงืืึทื, ืึทืืข ืืึทืื ืืขื ืขื ืกืืึธืจื ืืื ืึท ืจืืืขื ืฉืึทื ืคึผืึธืืืืืง ืืขืจืืคื ืึทืืืึธืืขื; ืื ืืึทืื ืืืขื ืืืื ืกืืึธืจื ืคึฟืึทืจ ืึท ืืืึธื. ืืื ืืืึธืื ืืื ืึทื ืื ืึทืืจืื ืืึทืื ืืึธื ืืืื ืืขืืืืื ืคึฟืึทืจ ืึท ืืืืฉ, ืื ืืืืื ืฉืจืืคื ืืึทืื ืืึธื ืืืื ืืขืืืืื ืคึฟืึทืจ ืึท ืืึธืจ, ืืื ืื ืืืืืขืฉืืขื ืืึทืื ืืึธื ืงืืื ืืึธื ืืืื ืืืืกืืขืืขืงื. ืืื ืก ืืึทืื ืื ืฆืื ืขืืขื ืจืืืขื ืฉืึทื ืคึผืึธืืืืืง
CREATE RETENTION POLICY "month" ON "homeassistant" DURATION 30d REPLICATION 1
CREATE RETENTION POLICY "year" ON "homeassistant" DURATION 52w REPLICATION 1
CREATE RETENTION POLICY "infinite" ON "homeassistant" DURATION INF REPLICATION 1
ืืืฆื, ืืื ืคืึทืงื, ืื ืืืืคึผื ืืจืืง ืืื ืืึทืื ืึทืืืจืขืืึทืืืึธื ื ืืฆื ืงืขืกืืืืขืจืืืง ืึธื ืคึฟืจืขื. ืืึธืก ืืื ืึท ืืขืงืึทื ืืืึทื ืึทื ืืืืืึธืืึทืืืฉ ืจืึทื ื ืึท ืึธื ืคึฟืจืขื ืืื ืกืคึผืขืฆืืคึฟืืฉ ืื ืืขืจืืืึทืื, ืึทืืืจืขืืึทืืขื ืื ืืึทืื ืคึฟืึทืจ ืืขื ืึธื ืคึฟืจืขื, ืืื ืืืกืืฃ ืื ืจืขืืืืืึทื ืืื ืึท ื ืืึทืข ืืืขืจื. ืืืืืจ ืงืืงื ืืืืฃ ื ืืืืฉืคืื (ืืื ืฉืจืืื ืืื ื ืงืืืื ืคืืจ ืืืื ืขื, ืืืขืจ ืืืขืฉื ืืื ืืื ืืขืืืื ืืจืืื ืืืืื ืืขื ืืืคืขื ืืื ืืืื ืฉืืจื)
CREATE CONTINUOUS QUERY cq_water_hourly ON homeassistant
BEGIN
SELECT max(value) AS value
INTO homeassistant.month.water_meter_hour
FROM homeassistant.autogen.l
GROUP BY time(1h), entity_id fill(previous)
END
ืืขื ืืึทืคึฟืขื:
- ืงืจืืืืฅ ืึท ืงืขืกืืืืขืจืืืง ืึธื ืคึฟืจืขื ืืืื ื ืึธืืขื cq_water_cold_hourly ืืื ืื ืืึธืืขืึทืกืกืืกืืึทื ื ืืึทืืึทืืืืก
- ืื ืืงืฉื ืืืขื ืืืื ืขืงืกืึทืงืืืืึทื ืืขืืขืจ ืฉืขื (ืฆืืื (1 ืฉืขื))
- ืื ืืงืฉื ืืืขื ืกืงืจืึทืคึผ ืึทืืข ืืึทืื ืคืื ืื ืืขืืฉืขืจืืึทื ื 'homeassistant.autogen.l (ืืืืขืจ), ืึทืจืืึทื ืืขืจืขืื ื ืงืึทืื ืืื ืืืืก ืืืึทืกืขืจ ืจืืืื ืื
- ืื ืึทืืืจืขืืึทืืขื ืืึทืื ืืืขื ืืืื ืืจืืคึผื ืืืจื entity_id, ืืืึธืก ืืืขื ืืขืื ืืื ืื ืืึทืืื ืืขืจ ืืืึทืืืขืก ืคึฟืึทืจ ืงืึทืื ืืื ืืืืก ืืืึทืกืขืจ
- ืืื ื ืื ืืืืขืจ ืืึธืืืึทื ืง ืืื ืึท ืืึทื ืึทืืึทื ืืงืื ืื ืงืจืืกืื ื ืกืืงืืืึทื ืก ืืื ืืขืืขืจ ืฉืขื, ืขืก ืืืขื ืืืื ื ืืืืืง ืฆื ื ืขืืขื ืื ืืึทืงืกืืืื ืืืขืจื, ืึทืืื ืึทืืืจืขืืึทืืืึธื ืืืขื ืืืื ืืืจืืืขืงืึธืื ืืืจื ืื ืคึฟืื ืงืฆืืข ืืึทืงืก (ืืืขืจื)
- ืื ื ืืืข ืืืขืจื ืืืขื ืืืื ืืขืฉืจืืื ืฆื homeassistant.month.water_meter_hour, ืืื ืืืืฉ ืืื ืืขืจ ื ืึธืืขื ืคืื ืื ืจืืืขื ืฉืึทื ืคึผืึธืืืืืง ืืื ืึท ืจืืืขื ืฉืึทื ืฆืืึทื ืคืื ืืืื ืืืืฉ. ืืขืจืฆื, ืืึทืื ืืืขืื ืงืึทืื ืืื ืืืืก ืืืึทืกืขืจ ืืืขื ืืืื ืฆืขืืืึธืจืคื ืืื ืืึทืืื ืืขืจ ืจืขืงืึธืจืืก ืืื ืื ืงืึธืจืึทืกืคึผืึทื ืืื ื ืขื ืืืื_ืื ืืื ืืืขืจื ืืื ืื ืืืขืจื ืคืขืื
ืืื ื ืึทืื ืึธืืขืจ ืืืขื ืงืืื ืขืจ ืืื ื ืืฉื ืืื ืฉืืื, ืขืก ืืื ืงืืื ืืืึทืกืขืจ ืงืึทื ืกืึทืืฉืึทื, ืืื ืืขืจืืืขืจ ืขืก ืืขื ืขื ืงืืื ื ืืึทืข ืืืื ืกื ืืื homeassistant.autogen.l. ืฆื ืืืกืืืืื ืคืขืื ืืืง ืืืึทืืืขืก ืืื ืจืขืืืืขืจ ืคึฟืจืืื, ืืืจ ืงืขื ืขื ื ืืฆื ืคืืืื ื (ืคืจืืึทืขืจืืืง). ืืึธืก ืืืขื ืฆืืืื ืืขื InfluxDB ืฆื ื ืืฆื ืื ืืืขืจื ืคืื ืื ืืขืฆืืข ืฉืขื.
ืฆืื ืืึทืืืืขืจื, ืงืขืกืืืืขืจืืืง ืึธื ืคึฟืจืขื ืืื ืึท ืคึผืืงืืืืืขืจืึทืื: ืื ืคืืืื ื (ืคืจืืึทืขืจืืืง) ืืจืืง ืืื ื ืืฉื ืึทืจืืขืื ืืื ืจืขืงืึธืจืืก ืืขื ืขื ืคืฉืื ื ืืฉื ืืืฉืืคื. ืืขืจืฆื, ืืึธืก ืืื ืึท ืืื ืคืื ืื ืกืขืจืืึทืื ืืึทืืึทื ืคึผืจืึธืืืขื ืึทื
ืืื ืก ืืฉืขืง ืืืึธืก ืืขืืจืืคื (ืคืื ืงืืจืก, ืืืจ ืืึทืจืคึฟื ืฆื ืืืึทืจืื ืึท ืคึผืึธืจ ืคืื ืฉืขื):
> select * from homeassistant.month.water_meter_hour group by entity_id
...
name: water_meter_hour
tags: entity_id=water_meter_cold
time value
---- -----
...
2020-03-08T01:00:00Z 370511
2020-03-08T02:00:00Z 370513
2020-03-08T05:00:00Z 370527
2020-03-08T06:00:00Z 370605
2020-03-08T07:00:00Z 370635
2020-03-08T08:00:00Z 370699
2020-03-08T09:00:00Z 370761
2020-03-08T10:00:00Z 370767
2020-03-08T11:00:00Z 370810
2020-03-08T12:00:00Z 370818
2020-03-08T13:00:00Z 370827
2020-03-08T14:00:00Z 370849
2020-03-08T15:00:00Z 370921
ืืึทืืขืจืงืื ื ืึทื ืื ืืืึทืืืขืก ืืื ืื ืืึทืืึทืืืืก ืืขื ืขื ืกืืึธืจื ืืื UTC, ืึทืืื ืื ืจืฉืืื ืืื ืึทื ืืขืจืฉ ืืื 3 ืฉืขื - ืื 7:10 ืืืึทืืืขืก ืืื ืื InfluxDB ืจืขืืืืืึทื ืฉืืืืขื ืฆื ืื 2:5 ืืืึทืืืขืก ืืื ืื ืืจืึทืคืก ืืืืื. ืืืื ืืึธื ืึทื ืฆืืืืฉื XNUMX ืืื XNUMX:XNUMX ืขืก ืืขื ืขื ืคืฉืื ืงืืื ืจืขืงืึธืจืืก - ืืึธืก ืืื ืืขืจ ืืขืืืืงืขืจ ืฉืืจืื ืคืื ืงืขืกืืืืขืจืืืง ืึธื ืคึฟืจืขื.
ืืื ืืืจ ืงืขื ืขื ืืขื, ืื ืึทืืืจืขืืึทืืขื ืืืขืจื ืืื ืืืื ืึท ืืึทื ืึทืืึทื ืืงืื ืื ืงืจืืกืื ื ืกืืงืืืึทื ืก, ืืืืื ืืืื ืกื ืคืึทืื ืืืืื ืืงืขืจ ืึธืคื - ืึทืืึธื ืคึผืขืจ ืฉืขื. ืึธืืขืจ ืืึธืก ืืื ื ืืฉื ืึท ืคึผืจืึธืืืขื - ืืืจ ืงืขื ืขื ืฉืจืืึทืื ืื ืื ืืขืจ ืึธื ืคึฟืจืขื ืืืึธืก ืืืขื ืฆืืจืืงืงืจืืื ืื ืจืืืืืง ืืึทืื ืคึฟืึทืจ ืื ืืจืึทืคืืง.
SELECT difference(max(value))
FROM homeassistant.month.water_meter_hour
WHERE entity_id='water_meter_cold' and time >= now() -24h
GROUP BY time(1h), entity_id
fill(previous)
ืืื ืืืขื ืืขืจืงืืขืจื:
- ืคึฟืื ืื homeassistant.month.
- ืืื ืืื ืฉืืื ืืขืจืืื ื, ืขืืืขืืข ืืืื ืกื ืงืขื ืืืื ืคืขืื ืืืง ืืื ืื ืกืืงืืืึทื ืก ืคืื homeassistant.month.water_meter_hour. ืืืจ ืืืขืื ืจืืืืฉืขื ืขืจืืื ืื ืืึทืื ืืืจื ืืืืคื ืึท ืึธื ืคึฟืจืขื ืืื GROUP BY ืฆืืื (1 ื). ืืขื ืืึธื ืคืื (ืคืจืืึทืขืจืืืง) ืืืขื ืึทืจืืขืื ืืื ืืขืจืืืึทืจื, ืืืฉืขื ืขืจืืืืื ื ืื ืคืขืื ืืืง ืืึทืื (ืื ืคึฟืื ืงืฆืืข ืืืขื ื ืขืืขื ืื ืคืจืืขืจืืืงืข ืืืขืจื)
- ืื ืืขืจืกื ืืืืืืืง ืืึทื ืืื ืืขื ืืงืฉื ืืื ืื ืืืืืง ืคืื ืงืฆืืข, ืืืึธืก ืืืขื ืจืขืืขื ืขื ืื ืืืืืง ืฆืืืืฉื ืฉืขื ืืึทืจืงืก. ืขืก ืืื ื ืืฉื ืึทืจืืขืื ืืืืฃ ืืื ืืื ืจืืงืืืืืขืจื ืึท ืึทืืืจืขืืึทืืืึธื ืคืื ืงืฆืืข. ืืื ืืึธืก ืืืื ืื ืืึทืงืก () ืืขื ืืฆื ืคืจืืขืจ.
ืืขืจ ืืืจืืคืืจืื ื ืจืขืืืืืึทื ืงืืงื ืืื ืืึธืก
name: water_meter_hour
tags: entity_id=water_meter_cold
time difference
---- ----------
...
2020-03-08T02:00:00Z 2
2020-03-08T03:00:00Z 0
2020-03-08T04:00:00Z 0
2020-03-08T05:00:00Z 14
2020-03-08T06:00:00Z 78
2020-03-08T07:00:00Z 30
2020-03-08T08:00:00Z 64
2020-03-08T09:00:00Z 62
2020-03-08T10:00:00Z 6
2020-03-08T11:00:00Z 43
2020-03-08T12:00:00Z 8
2020-03-08T13:00:00Z 9
2020-03-08T14:00:00Z 22
2020-03-08T15:00:00Z 72
ืคืื 2 ืฆื 5 ืืื (UTC) ืขืก ืืื ืงืืื ืงืึทื ืกืึทืืฉืึทื. ืคืื ืืขืกืืืืขืื, ืื ืึธื ืคึฟืจืขื ืืืขื ืฆืืจืืงืงืืืขื ืืขืจ ืืขืืืืงืขืจ ืงืึทื ืกืึทืืฉืึทื ืืืขืจื ืืึทื ืง ืฆื ืคึผืืึธืืืืจื (ืคืจืืึทืขืจืืืง), ืืื ืื ืืืืืง ืคืื ืงืฆืืข ืืืขื ืึทืจืึธืคึผืจืขืืขื ืขื ืืขื ืืืขืจื ืคืื ืืื ืืื ืืขืจ ืจืขืืืืืึทื ืืืขื ืืืื 0, ืืืึธืก ืืื ืคึผืื ืงื ืืืึธืก ืืื ืคืืจืืื ืื.
ืขืก ืืืืืื ื ืึธืจ ืฆื ืืืืขื ืึท ืืจืึทืคืืง. ืฆื ืืึธื ืืึธืก, ืขืคึฟืขื ืขื Grafana, ืขืคึฟืขื ืขื ืขืืืขืืข ืืืืืกืืื ื (ืึธืืขืจ ืฉืึทืคึฟื ืึท ื ืืึทืข) ืืึทืฉืืึธืจื ืืื ืฉืึทืคึฟื ืึท ื ืืึทืข ืืึทืคืืืข. ืื ืืฉืึทืจื ืกืขืืืื ืืก ืืืขื ืืืื ืืื ืืึธืก.
ืืื ืืืขื ืืืืึทืื ืงืึทืื ืืื ืืืืก ืืืึทืกืขืจ ืืึทืื ืืืืฃ ืืขืจ ืืขืืืืงืขืจ ืืจืึทืคืืง. ืื ืืงืฉื ืืื ืคึผืื ืงื ืื ืืขืืืข ืืื ืืื ืืืกืงืจืืืื ืืืืื.
ืืืืึทื ืคึผืึทืจืึทืืขืืขืจืก ืืขื ืขื ืืึทืฉืืืื ืืื ืืืื. ืคึฟืึทืจ ืืืจ ืขืก ืืืขื ืืืื ืึท ืืจืึทืคืืง ืืื ืฉืืจืืช, ืืืึธืก ืืืื ืืื ืืจืขืคึผ (ืืจืขืคึผ). ืืื ืืืขื ืืขืจืงืืขืจื ืื ืกืืึทืง ืคึผืึทืจืึทืืขืืขืจ ืืื ืื. ืขืก ืืขื ืขื ืึท ืคึผืึธืจ ืืขืจ ืึทืจืืืกืืืืึทืื ืึธืคึผืฆืืขืก ืืื ืื, ืึธืืขืจ ืืื ืืขื ืขื ื ืืฉื ืึทืืื ืืฉืืงืึทืืืข.
ืฆื ืืืืื ืื ืจืืืึทืืืื ื ืืฉืึทืจื ืฆื ืืืื ืึทืกืืกืืึทื ื ืืืจ ืืึทืจืคึฟื ืฆื:
- ืึทืจืืืกืืึทื ื ืื ืืฉืึทืจื ืขืืืืื ื ืืึธืืข. ืคึฟืึทืจ ืขืืืขืืข ืกืืื, ืื ืจืืืืืง ืืฉืึทืจื ืืึทื ืืืืืื ื ืกืขืืืื ืืก ืืขื ืขื ืืขืคึฟืื ื ืืืืื ืคึฟืื ืื ืืึทืฉืืึธืจื ืืืึทื
- ืืจืืงื ืืืืฃ ืื ืืจืืึทืขืง ืืืืึทืืขืจ ืฆื ืื ืืฉืึทืจื ื ืึธืืขื ืืื ืกืขืืขืงืืืจื ืืึทื ืืืืื ืคืื ืื ืืขื ืื
- ืืื ืื ืคึฟืขื ืฆืืขืจ ืืืึธืก ืึธืคึผืขื ืก, ืืืื ืฆื ืื ืขืืืขื ืงืืืืื
- ืื ืืฉืขืงืง ืื ืงืจืึทื ื ืฆืืื ืงืืื - ืืืจ ืฉืืขืื ืื ืฆืืื ืงืืื ืืืจื URL
- ืืืืกืงืืืึทืื ืื ืคืืจืืื ืื ืืขืืข. ืืื ืืืื ืคืึทื ืขืก ืืื ืืืื
- ื ืึธืืืึทืื ืื ืจืืืึทืืืื ื URL ืฆื ืื Lovelace-UI ืกืขืืืื ืืก ืงืึธืจื
- type: iframe
id: graf_water_hourly
url: "http://192.168.10.200:3000/d-solo/rZARemQWk/water?orgId=1&panelId=2&from=now-2d&to=now&theme=light"
ืืืืข ืืึธื ืึทื ืื ืฆืืื ืงืืื (ืืขืฆืืข 2 ืืขื) ืืื ืืึทืฉืืืื ืืึธ ืืื ื ืืฉื ืืื ืื ืืึทืฉืืึธืจื ืกืขืืืื ืืก.
ืื ืืจืึทืคืืง ืงืืงื ืืื ืืึธืก. ืืื ืืื ื ืืฉื ืืขืืืืื ื ืืืืก ืืืึทืกืขืจ ืืื ืื ืืขืฆืืข 2 ืืขื, ืึทืืื ืืืืื ืื ืงืึทืื ืืืึทืกืขืจ ืืจืึทืคืืง ืืื ืฆืืขื.
ืืื ื ืึธื ืืึธืื ื ืืฉื ืืึทืฉืืึธืกื ืคึฟืึทืจ ืืื ืืืึธืก ืืจืึทืคืืง ืืื ืืื ืืขืกืขืจ, ืึท ืฉืืจื-ืฉืจืื ืึธืืขืจ ืคืึทืงืืืฉ ืืึทืจืก. ืืขืจืืืขืจ, ืืื ืืืขื ืคืฉืื ืืขืื ืึท ืืืึทืฉืคึผืื ืคืื ืึท ืืขืืืขื ืงืึทื ืกืึทืืฉืึทื ืืฉืึทืจื, ืืืืื ืืึธืก ืืึธื ืืื ืืึทืจืก. ืคึฟืจืืื ืืขื ืขื ืงืึทื ืกืืจืึทืงืืึทื ืขื ืืขื ืฆื ืื ืืืกืงืจืืืื ืืืืื. ืื ืึทืจืืืกืืืืึทืื ืึธืคึผืฆืืขืก ืืขื ืขื:
ืื ืืจืึทืคืืง ืงืืงื ืืื ืืึธืก:
ืึทืืื ืืืขืื ืื ืกืืึทืง ืคึผืึทืจืึทืืขืืขืจ. ืืื ืืขื ืืจืึทืคืืง, ืึท ืืืึทื ืคืื ืงืึทืื ืืืึทืกืขืจ ืืื ืฆืืขื ืืืืฃ ืฉืคึผืืฅ ืคืื ืึท ืืืึทื ืคืื ืืืืก ืืืึทืกืขืจ. ืื ืืึทื ืฅ ืืืื ืงืึธืจืึทืกืคึผืึทื ืื ืฆื ืื ืืึทื ืฅ ืงืึทื ืกืึทืืฉืึทื ืคืื ืงืึทืื ืืื ืืืืก ืืืึทืกืขืจ ืคึฟืึทืจ ืื ืฆืืึทื.
ืึทืืข ืืจืึทืคืก ืืขืืืืื ืืขื ืขื ืืื ืึทืืืฉ. ืืืจ ืงืขื ืขื ืืึธืืืขืจ ืืืื ืืืื ืืืืขืจ ืื ืคืื ื ืคืื ืืื ืืขืจืขืก ืืื ืืขื ืื ืืขืืึทืืืก ืืื ืืืขืจื ืืื ืึท ืกืคึผืขืฆืืคืืฉ ืคืื ื.
ืฆืื ืืึทืืืืขืจื, ืขืก ืืขื ืขื ืืขืืืขื ืึท ืคึผืึธืจ ืคืื ืคืืืขื ืืื ืื ืืืืืืื. ืืืืฃ ืึท ืืึทืจ ืืฉืึทืจื (ื ืื ืขื ืืขื ืึท ืืฉืึทืจื ืืื ืฉืจืื ืฉืืจืืช), ืื ืืืื ืคืื ืื ืืึทืจ ืืื ื ืืฉื ืืื ืื ืืืื ืคืื ืื ืืึธื, ืึธืืขืจ ืืืึท 00:00. ืืขื ืข. ืื ืืื ืงืก ืืขืืคื ืคืื ืื ืืืึทื ืืื ืฆืืขื ืืื ืคึผืืึทืฅ ืคืื ืื ืคืจืืขืจืืืงืข ืืึธื. ืึทืืื ืื ืืจืึทืคืก ืคึฟืึทืจ ืฉืืช ืืื ืืื ืืืง ืืขื ืขื ืฆืืขื ืึท ืืืกื ืฆื ืื ืืื ืงืก ืคืื ืื ืืืืืืฉ ืืึธื ืข. ืืื ืืื ืคืืืืขืจื ืืืืก ืืื ืฆื ืืึทืืืื ืขืก.
ืื ืื ืืขืจ ืคึผืจืึธืืืขื ืืื ืื ืื ืึทืืืืืื ืฆื ืึทืจืืขืื ืจืขืื ืืื ืืืืืขืฉืืขื ืื ืืขืจืืืึทืื. ืืขืจ ืคืึทืงื ืืื ืึทื ืื ืืขื ื ืคืื ืื ืฉืขื / ืืึธื / ืืืึธื ืืื ืคืึทืจืคืขืกืืืงื, ืึธืืขืจ ืื ืืขื ื ืคืื ืื ืืืืฉ ืืื ืึทื ืืขืจืฉ ืืขืืขืจ ืืึธื. ืื ืคืืืงืกืื ืงืขื ืขื ื ืึธืจ ืึทืจืืขืื ืืื ืืืืึทื ืื ืืขืจืืืึทืื. ืืื ืืืฆื ืืืื ืกืืืื ืืื ืืขื ืื ืฆื ืฉืืขืื ืึท ืคืึทืจืคืขืกืืืงื ืืขืืึทืืขื ืคืื 30 ืืขื. ืืึธ, ืื ืืจืึทืคืืง ืืืขื ืืึธืื ืฉืืืืืขื ืึท ืืืกื ืืืืขืจ ืื ืืึธืจ ืืื ืื ืืึทืจืก ืืืขื ื ืืฉื ืคึผืื ืงื ืฉืืืืขื ืฆื ืื ืืืฉืื. ืึธืืขืจ ืืื ื ืืื ืืื ืืื ืืขืจืขืกืืจื ืืื ืืขื ืืึทื ืคืฉืื ืืื ืึท ืึทืจืืืกืืืืึทืื ืืขืืขืจ, ืืื ืืื ืืื ืืื ืืื.
ืืื ืืขื ืืืึท ืืื ืืกืืขืจ ืฆืืืื ืกืึทืืืฉืึทื ื:
- ืืขืื ืึทืจืืืฃ ืืืืฃ ืืืืืขืฉืืขื ืืฉืึทืจืฅ ืืื ืืึทืืจืขื ืขืฆื ืืื ืฆื ืืืืื ืฉืจืืคื ืึธื ืขืก. 52 ืืืืื ืฉืจืืคื ืืึทืจืก ืคึฟืึทืจ ืื ืืึธืจ ืงืืงื ืฉืืื ืืื
- ืืืืจืืื ืืืืืขืฉืืขื ืงืึทื ืกืึทืืฉืึทื ืืื ืืื ืืืคึฟื ื ืื 2, ืืื ื ืืฆื ืืจืึทืคืึทื ืึท ืืืืื ืคึฟืึทืจ ืฉืืื ืืจืึทืคืก. ืขืก ืืืขื ืืืื ืืึทื ืฅ ืึท ืคึผืื ืืืขื ืืืืืื ื. ืืืจ ืงืขื ืขื ืืคืืื ืึธืืืืขืจืืื ืืจืึทืคืก ืคึฟืึทืจ ืื ืืขืฆืืข ืืึธืจ ืคึฟืึทืจ ืคืึทืจืืืืึทื - ืืจืึทืคืึทื ืึท ืงืขื ืขื ืืืื ืืึธื ืืึธืก.
ืกืึธืฃ
ืืื ืืืืืก ื ืืฉื ืคืืจืืืืก, ืืืขืจ ืืื ืืื ืืืกืขืกื ืืื ืื ืกืืจื ืืจืืคืขืก. ืืื ืืืืึทืื ืึทื ืืขืื ืืื ืืื ืคืื ืกืืืื ื ืืื ืึทืืฅ ืืื ืืฉืึทื ืืื ื. ื ืขืืื ืืื ืืขืืืขื ืคืื, ืืืื ื ืืื ืงืืืื, ืืึธืจืื ืืืขื ืืืื ืขืคึผืขืก ืึทื ืืขืจืฉ. ืึทืืข ืืืึธืก ืืืืืื ืืื ืฆื ืึทืจืืขืื ืืื ืืืืืืขืืื ื ืืืืืืืืขืจ ืืืืฃ ืืขืจ ืืขืืข ืคืื โโืงืึทื ืกืึทืืฉืึทื. ืืืขืจ ืืคืืื ืืื ืงืจืึทื ื ืึทืคึผืึทืืืืฅ, ื ืึธืจ ืึท ืืจืืืก ืืื ืื ืืงืึทืืคึผืจืึทืืขื ืกืืืึทื ืคืืืืจ ืืืืฃ ืื ืฆืึธืืื ื ืฆืขืื ืืื ืฉืืื ืืืจื ืื ื ืืื ืึท ืืึทื ืฅ ืคืึทืจืฉืืืืืง ืืืื ืคืื ืงืึทื ืกืึทืืฉืึทื.
ืืจืึธืฅ ืืืื ืึผืืขื 20-ืืึธืจ ืงืึทืจืืขืจืข ืืื ืึท ืคึผืจืึธืืจืึทืืืกื, ืืื ืืื ืึผืืขื ืงืืื ืงืึธื ืืึทืงื ืืื ืืึทืืึทืืืืกืื. ืืขืจืืืขืจ, ืื ืกืืึธืืื ื ืึท ืคืื ืืจืืืกื ืืืง ืืึทืืึทืืืืก ืกืืื ืืื ืขืคึผืขืก ืึทืืื ืึทืืกืืจืึทืงื ืืื ืื ืืงืึทืืคึผืจืึทืืขื ืกืืืึทื. ืึทืืฅ ืืขืืืื
ืืื ืืขื ืืืื ืืื ืืขืจืืื ื ืขืืขืงืืจืข ืงืึทื ืกืึทืืฉืึทื. ืฆืื ืืึทืืืืขืจื, ืืื ืืขืจ ืืึธืืขื ื ืืื ืงืขื ื ืืฉื ืฆืืฉืืขืื ืงืืื ืืจืึทืคืก. ืืืื SDM120 ืืขืืขืจ ืืื ืืขืฉืืืจืื ืคึฟืึทืจ ืืืจ, ืืื ืื ืื ืืขืจืข ืืื ืืืืืฉื ืืืขื ืึทืงืกืขืกื ืืืจื ืืึธืืืืก. ืึธืืขืจ, ืืึธืก ืืื ื ืืฉื ืืืืจืงื ืื ืืขืืข ืคืื โโืืขื ืึทืจืืืงื ืืื ืงืืื ืืืขื - ืื ืืจืึทืคืก ืืืขื ืืืื ืงืึทื ืกืืจืึทืงืืึทื ืืื ืื ืืขืืืข ืืืขื ืืื ืคึฟืึทืจ ืืืึทืกืขืจ.
ืืื ืืขื ืึทืจืืืงื ืืื ืืขืจืืื ืื ืื ืึทืคึผืจืึธืืืฉืื ืืืึธืก ืืื ืืขืคืจืืืื ืืื. ืฉืืจืื ืขืก ืืขื ืขื ืขืืืขืืข ืื ืืขืจืข ืืืขืื ืฆื ืึธืจืืึทื ืืืืจื ืืึทืื ืืึทืืืื ื ืืื ืืืืืฉืืืึทืืึทืืืืฉืึทื ืืืึธืก ืืื ืืึธื ื ืื ืืืืกื ืืืขืื. ืืขืจืฆืืืื ืืืจ ืืืขืื ืืื ืืื ืื ืืึทืืขืจืงืื ืืขื, ืืื ืืืขื ืืืื ืืืืขืจ ืืื ืืขืจืขืกืืจื. ืืื ืืืขื ืืืื ืฆืืคืจืืื ืืื ืงืึทื ืกืืจืึทืงืืืื ืงืจืืืืง ืืื ื ืืึทืข ืืขืืื ืงืขื. ืืื ืืืฃ ืื ืืขืจ ืืืืขืจืืื ืืืขื ืืืื ืขืืขืฆื ืืขืืคื.
ืืงืืจ: www.habr.com