/**
* 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;
}
