bakerman.php

<?php

// This would be for the logs model
public function scopeCode($query, $code)
{
    return $query->where('code', $code);
}

// Then this would be your main model
public function scopeNotTransferred($query)
{
    return $query->whereHas('logs', function($query)
    {
        $query->code('transferred');
    }, '<', 1);
}