stagfe2/app/Models/ClientBDTDevice.php

<?php

namespace App\Models;

class ClientBDTDevice extends Model
{
    protected $table = 'client_bdt_device';

    public function device() {
        return $this->hasOne(BDTDevice::class, 'id', 'device_id');
    }

    public function client() {
        return $this->hasOne(Client::class, 'id', 'client_id');
    }

    public function lastDeviceMeasurement() {
        return BDTMeasurement::select('bdt_measurement.*')
        ->join('client_bdt_measurement', 'client_bdt_measurement.bdt_measurement_id','=', 'bdt_measurement.id')
        ->where('client_bdt_measurement.client_id', $this->client_id)
        ->where('bdt_measurement.imei', $this->device->imei)
        ->orderBy('bdt_measurement.created_at', 'DESC')
        ->first();
    }

}