67 lines
2.5 KiB
Python
67 lines
2.5 KiB
Python
from django.db import models
|
|
|
|
# 1. MODEL AREA (Lokasi penempatan mesin-mesin)
|
|
class Area(models.Model):
|
|
nama_area = models.CharField(max_length=100, unique=True)
|
|
keterangan = models.TextField(blank=True, null=True)
|
|
created_at = models.DateTimeField(auto_now_add=True)
|
|
|
|
def __str__(self):
|
|
return self.nama_area
|
|
|
|
|
|
# 2. MODEL MESIN (Identitas perangkat web & hardware ESP32)
|
|
class Mesin(models.Model):
|
|
nama_mesin = models.CharField(max_length=100)
|
|
area = models.ForeignKey(
|
|
Area,
|
|
on_delete=models.SET_NULL,
|
|
null=True,
|
|
blank=True,
|
|
related_name='mesin_list',
|
|
)
|
|
keterangan = models.TextField(blank=True, null=True)
|
|
token = models.CharField(max_length=64, unique=True, blank=True, null=True)
|
|
created_at = models.DateTimeField(auto_now_add=True)
|
|
|
|
# KONDISI STATUS MESIN: Aman untuk data lama karena mengizinkan NULL
|
|
status = models.CharField(max_length=20, null=True, blank=True, default='normal')
|
|
|
|
def __str__(self):
|
|
return self.nama_mesin
|
|
|
|
|
|
# 3. MODEL KWH READINGS (Penyimpanan data log sensor dari ESP32)
|
|
class KwhReadings(models.Model):
|
|
# RELASI: Menghubungkan log data secara otomatis ke ID Mesin terkait
|
|
mesin = models.ForeignKey(
|
|
Mesin,
|
|
on_delete=models.CASCADE, # Jika mesin dihapus, log datanya otomatis bersih
|
|
related_name='readings',
|
|
null=True,
|
|
blank=True
|
|
)
|
|
timestamp = models.DateTimeField(auto_now_add=True)
|
|
|
|
# ─── PENAMAAN SESUAI PENGIRIMAN ESP32 (BAHASA INGGRIS) ───
|
|
apparent_power_va = models.FloatField(help_text="Apparent Power / Voltage (VA)")
|
|
total_current_a = models.FloatField(help_text="Total Current (A)")
|
|
power_factor = models.FloatField(help_text="Power Factor")
|
|
active_power_kwh = models.FloatField(help_text="Total kWh Accumulation")
|
|
|
|
# Kolom hasil kalkulasi matematika backend Django (Daya Aktif Sesaat)
|
|
real_active_power_kw = models.FloatField(help_text="Calculated Active Power (kW)")
|
|
|
|
class Meta:
|
|
# Indexing tingkat lanjut agar database tetap kencang dan query instan
|
|
indexes = [
|
|
models.Index(fields=['mesin', '-id']),
|
|
models.Index(fields=['-id']),
|
|
models.Index(fields=['-timestamp']),
|
|
]
|
|
|
|
def __str__(self):
|
|
nama_perangkat = self.mesin.nama_mesin if self.mesin else "Tanpa Perangkat"
|
|
waktu = self.timestamp.strftime('%Y-%m-%d %H:%M:%S')
|
|
return f"{nama_perangkat} | {waktu} - {self.real_active_power_kw} kW"
|