/** * Scope only not-null data * @param query $query Query object * @param string $type Data type ("WATER", "RAIN") * @return mixed New query object */ public function scopeValid($query, $type) { if ($type == 'WATER') { return $query->whereNotNull('water1'); } elseif ($type == 'RAIN') { return $query->whereNotNull('rain1h'); } return $query; }