Sensor::data() - Code Metrics - uidaho/smartsettia - Measure and Improve Code Quality continuously with Scrutinizer

Sensor::data() A
last analyzed 2017-12-12 04:17 UTC

↳ Parent: Sensor

Complexity

Conditions	1
Paths	1

Size

Total Lines	3
Code Lines	1

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	2

Importance

Changes

Metric	Value
cc	1
eloc	1
nc	1
nop	0
dl	0
loc	3
ccs	0
cts	2
cp	0
crap	2
rs	10
c	0
b	0
f	0

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;
use Spatie\Activitylog\Traits\LogsActivity;
use Illuminate\Support\Facades\Auth;

class Sensor extends Model 
{
    use LogsActivity;

    protected $table = 'sensors';

    /**
     * Update the updated_at and created_at timestamps?
     *
     * @var array
     */
    public $timestamps = false;

    /**
     * The attributes that are mass assignable.
     *
     * @var array
     */
    protected $fillable = array('device_id', 'name', 'type');

    /**
     * The attributes that are visible.
     *
     * @var array
     */
    protected $visible = array('id', 'device_id', 'name', 'type');

    /**
     * The attributes to log in the Activity Log
     *
     * @var array
     */
    protected static $logAttributes = array('id', 'device_id', 'name', 'type');

    /**
     * Only log those that have actually changed after the update.
     *
     * @var array
     */
    protected static $logOnlyDirty = true;

    /**
     * Get the device associated with the sensor.
     */
    public function device()
    {
        return $this->belongsTo('App\Device');
    }

    /**
     * Get the sensor data associated with the sensor.
     */
    public function data()
    {
        return $this->hasMany('App\SensorData');
    }
    
    /**
     * Get the latest sensor data entry associated with the sensor.
     */
    public function getLatestDataAttribute()
    {
        return SensorData::whereRaw('id = (SELECT MAX(id)
                                                    FROM sensor_data
                                                    WHERE sensor_id = ?)', [ $this->id ])->first() ?? (object) [ ];
    }
    
    /**
     * Get the last hour's sensor data averaged by the minute for the sensor.
     */
    public function getLastHourMinutelyAvgDataAttribute()
    {
        return $this->hasMany('App\SensorData')
            ->selectRaw("DATE_FORMAT(created_at, '%Y-%m-%d %H:%i') AS date, AVG(value) AS value")
            ->whereRaw("created_at > DATE_SUB(NOW(), INTERVAL 1 HOUR)")
            ->groupBy("date")
            ->get();
    }
    
    /**
     * Get the last day's sensor data averaged hourly for the sensor.
     */
    public function getLastDayHourlyAvgDataAttribute()
    {
        return $this->hasMany('App\SensorData')
            ->selectRaw("DATE_FORMAT(created_at, '%Y-%m-%d %H') AS date, AVG(value) AS value")
            ->whereRaw("created_at > DATE_SUB(NOW(), INTERVAL 1 DAY)")
            ->groupBy("date")
            ->get();
    }
    
    /**
     * Get the last weeks's sensor data averaged daily for the sensor.
     */
    public function getLastWeekDailyAvgDataAttribute()
    {
        return $this->hasMany('App\SensorData')
            ->selectRaw("DATE_FORMAT(created_at, '%Y-%m-%d') AS date, AVG(value) AS value")
            ->whereRaw("created_at > DATE_SUB(NOW(), INTERVAL 7 DAY)")
            ->groupBy("date")
            ->get();
    }
    
    /**
     * Get the last months's sensor data averaged daily for the sensor.
     */
    public function getLastMonthDailyAvgDataAttribute()
    {
        return $this->hasMany('App\SensorData')
            ->selectRaw("DATE_FORMAT(created_at, '%Y-%m-%d') AS date, AVG(value) AS value")
            ->whereRaw("created_at > DATE_SUB(NOW(), INTERVAL 30 DAY)")
            ->groupBy("date")
            ->get();
    }
    
    /**
     * Get the last year's sensor data averaged monthly for the sensor.
     */
    public function getLastYearMonthlyAvgDataAttribute()
    {
        return $this->hasMany('App\SensorData')
            ->selectRaw("DATE_FORMAT(created_at, '%Y-%m') AS date, AVG(value) AS value")
            ->whereRaw("created_at > DATE_SUB(NOW(), INTERVAL 1 YEAR)")
            ->groupBy("date")
            ->get();
    }
    
    /**
     * Accessor: Get the sensor's last update time in seconds/minutes/hours since update or converted to user
     * friendly readable format.
     * If the time is less then a day old then display time since it last updated
     * If the time is greater then a day old then display the time in the format of Month day, year 12hour:mins am/pm
     * and using the user's preferred timezone
     *
     *
     * @return string
     */
    public function getUpdatedAtHumanAttribute()
    {
        if ($this->updated_at->diffInDays() > 0) {

                    return $this->updated_at->setTimezone(Auth::user()->timezone)->format('M d, Y h:i a');
        } else {
                    return $this->updated_at->diffForHumans();
        }
    }
    
    /**
     * Accessor: Get the sensor's creation time in seconds/minutes/hours since update or converted to user
     * friendly readable format.
     * If the time is less then a day old then display time since creation
     * If the time is greater then a day old then display the time in the format of Month day, year 12hour:mins am/pm
     * and using the user's preferred timezone
     *
     *
     * @return string
     */
    public function getCreatedAtHumanAttribute()
    {
        if ($this->created_at->diffInDays() > 0) {

                    return $this->created_at->setTimezone(Auth::user()->timezone)->format('M d, Y h:i a');
        } else {
                    return $this->created_at->diffForHumans();
        }
    }
}

1		<?php
2
3		namespace App;
4
5		use Illuminate\Database\Eloquent\Model;
6		use Spatie\Activitylog\Traits\LogsActivity;
7		use Illuminate\Support\Facades\Auth;
8
9		class Sensor extends Model
10		{
11		use LogsActivity;
12
13		protected $table = 'sensors';
14
15		/**
16		* Update the updated_at and created_at timestamps?
17		*
18		* @var array
19		*/
20		public $timestamps = false;
21
22		/**
23		* The attributes that are mass assignable.
24		*
25		* @var array
26		*/
27		protected $fillable = array('device_id', 'name', 'type');
28
29		/**
30		* The attributes that are visible.
31		*
32		* @var array
33		*/
34		protected $visible = array('id', 'device_id', 'name', 'type');
35
36		/**
37		* The attributes to log in the Activity Log
38		*
39		* @var array
40		*/
41		protected static $logAttributes = array('id', 'device_id', 'name', 'type');
42
43		/**
44		* Only log those that have actually changed after the update.
45		*
46		* @var array
47		*/
48		protected static $logOnlyDirty = true;
49
50		/**
51		* Get the device associated with the sensor.
52		*/
53		public function device()
54		{
55		return $this->belongsTo('App\Device');
56		}
57
58		/**
59		* Get the sensor data associated with the sensor.
60		*/
61		public function data()
62		{
63		return $this->hasMany('App\SensorData');
64		}
65
66		/**
67		* Get the latest sensor data entry associated with the sensor.
68		*/
69		public function getLatestDataAttribute()
70		{
71		return SensorData::whereRaw('id = (SELECT MAX(id)
72		FROM sensor_data
73		WHERE sensor_id = ?)', [ $this->id ])->first() ?? (object) [ ];
74		}
75
76		/**
77		* Get the last hour's sensor data averaged by the minute for the sensor.
78		*/
79		public function getLastHourMinutelyAvgDataAttribute()
80		{
81		return $this->hasMany('App\SensorData')
82		->selectRaw("DATE_FORMAT(created_at, '%Y-%m-%d %H:%i') AS date, AVG(value) AS value")
83		->whereRaw("created_at > DATE_SUB(NOW(), INTERVAL 1 HOUR)")
84		->groupBy("date")
85		->get();
86		}
87
88		/**
89		* Get the last day's sensor data averaged hourly for the sensor.
90		*/
91		public function getLastDayHourlyAvgDataAttribute()
92		{
93		return $this->hasMany('App\SensorData')
94		->selectRaw("DATE_FORMAT(created_at, '%Y-%m-%d %H') AS date, AVG(value) AS value")
95		->whereRaw("created_at > DATE_SUB(NOW(), INTERVAL 1 DAY)")
96		->groupBy("date")
97		->get();
98		}
99
100		/**
101		* Get the last weeks's sensor data averaged daily for the sensor.
102		*/
103		public function getLastWeekDailyAvgDataAttribute()
104		{
105		return $this->hasMany('App\SensorData')
106		->selectRaw("DATE_FORMAT(created_at, '%Y-%m-%d') AS date, AVG(value) AS value")
107		->whereRaw("created_at > DATE_SUB(NOW(), INTERVAL 7 DAY)")
108		->groupBy("date")
109		->get();
110		}
111
112		/**
113		* Get the last months's sensor data averaged daily for the sensor.
114		*/
115		public function getLastMonthDailyAvgDataAttribute()
116		{
117		return $this->hasMany('App\SensorData')
118		->selectRaw("DATE_FORMAT(created_at, '%Y-%m-%d') AS date, AVG(value) AS value")
119		->whereRaw("created_at > DATE_SUB(NOW(), INTERVAL 30 DAY)")
120		->groupBy("date")
121		->get();
122		}
123
124		/**
125		* Get the last year's sensor data averaged monthly for the sensor.
126		*/
127		public function getLastYearMonthlyAvgDataAttribute()
128		{
129		return $this->hasMany('App\SensorData')
130		->selectRaw("DATE_FORMAT(created_at, '%Y-%m') AS date, AVG(value) AS value")
131		->whereRaw("created_at > DATE_SUB(NOW(), INTERVAL 1 YEAR)")
132		->groupBy("date")
133		->get();
134		}
135
136		/**
137		* Accessor: Get the sensor's last update time in seconds/minutes/hours since update or converted to user
138		* friendly readable format.
139		* If the time is less then a day old then display time since it last updated
140		* If the time is greater then a day old then display the time in the format of Month day, year 12hour:mins am/pm
141		* and using the user's preferred timezone
142		*
143		*
144		* @return string
145		*/
146	View Code Duplication	public function getUpdatedAtHumanAttribute()
147		{
148		if ($this->updated_at->diffInDays() > 0) {
		0 ignored issues – show Bug introduced 2017-11-26 22:18 UTC by Report Bug Copy Issue Report The property `updated_at` does not seem to exist on `App\Sensor`. Are you sure there is no database migration missing? Checks if undeclared accessed properties appear in database migrations and if the creating migration is correct. Loading history...
149		return $this->updated_at->setTimezone(Auth::user()->timezone)->format('M d, Y h:i a');
150		} else {
151		return $this->updated_at->diffForHumans();
152		}
153		}
154
155		/**
156		* Accessor: Get the sensor's creation time in seconds/minutes/hours since update or converted to user
157		* friendly readable format.
158		* If the time is less then a day old then display time since creation
159		* If the time is greater then a day old then display the time in the format of Month day, year 12hour:mins am/pm
160		* and using the user's preferred timezone
161		*
162		*
163		* @return string
164		*/
165	View Code Duplication	public function getCreatedAtHumanAttribute()
166		{
167		if ($this->created_at->diffInDays() > 0) {
		0 ignored issues – show Bug introduced 2017-11-26 22:18 UTC by Report Bug Copy Issue Report The property `created_at` does not seem to exist on `App\Sensor`. Are you sure there is no database migration missing? Checks if undeclared accessed properties appear in database migrations and if the creating migration is correct. Loading history...
168		return $this->created_at->setTimezone(Auth::user()->timezone)->format('M d, Y h:i a');
169		} else {
170		return $this->created_at->diffForHumans();
171		}
172		}
173		}

uidaho / smartsettia

Sensor::data() A last analyzed 2017-12-12 04:17 UTC

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like

Sensor::data() A
last analyzed 2017-12-12 04:17 UTC