81 lines
1.9 KiB
PHP
81 lines
1.9 KiB
PHP
<?php
|
|
|
|
namespace App\Models;
|
|
|
|
use Illuminate\Database\Eloquent\Model;
|
|
use Illuminate\Database\Eloquent\Relations\BelongsTo;
|
|
|
|
class SensorReading extends Model
|
|
{
|
|
protected $fillable = [
|
|
'sensor_id',
|
|
'device_id',
|
|
'value',
|
|
'raw_value',
|
|
'status',
|
|
'battery_level',
|
|
'signal_strength',
|
|
'metadata',
|
|
'reading_time',
|
|
'is_processed'
|
|
];
|
|
|
|
protected $casts = [
|
|
'metadata' => 'array',
|
|
'value' => 'decimal:4',
|
|
'battery_level' => 'decimal:2',
|
|
'signal_strength' => 'integer',
|
|
'reading_time' => 'datetime',
|
|
'is_processed' => 'boolean'
|
|
];
|
|
|
|
// Relasi ke sensor
|
|
public function sensor(): BelongsTo
|
|
{
|
|
return $this->belongsTo(Sensor::class);
|
|
}
|
|
|
|
// Relasi ke device
|
|
public function device(): BelongsTo
|
|
{
|
|
return $this->belongsTo(Device::class);
|
|
}
|
|
|
|
// Scope untuk reading hari ini
|
|
public function scopeToday($query)
|
|
{
|
|
return $query->whereDate('reading_time', today());
|
|
}
|
|
|
|
// Scope untuk reading dalam rentang waktu
|
|
public function scopeBetweenDates($query, $startDate, $endDate)
|
|
{
|
|
return $query->whereBetween('reading_time', [$startDate, $endDate]);
|
|
}
|
|
|
|
// Scope berdasarkan status
|
|
public function scopeByStatus($query, $status)
|
|
{
|
|
return $query->where('status', $status);
|
|
}
|
|
|
|
// Accessor untuk status color
|
|
public function getStatusColorAttribute()
|
|
{
|
|
return match($this->status) {
|
|
'normal' => 'green',
|
|
'warning' => 'yellow',
|
|
'critical' => 'red',
|
|
'error' => 'red',
|
|
default => 'gray'
|
|
};
|
|
}
|
|
|
|
// Accessor untuk formatted value
|
|
public function getFormattedValueAttribute()
|
|
{
|
|
$unit = $this->sensor->unit ?? '';
|
|
return $this->value . ($unit ? ' ' . $unit : '');
|
|
}
|
|
}
|