baoshi-was/app/OrderTracking.php

<?php

namespace App;

use App\Traits\ModelTimeFormat;
use Illuminate\Database\Eloquent\Model;

class OrderTracking extends Model
{

    use ModelTimeFormat;
    protected $fillable = [
        'order_package_commodity_id','owner_id','web_order_number',
        'pick_up_at','sale','client','order_client_code',
        'order_remark','pallet_total','planning_sent_at',
        'is_on_duty_shift','is_arrival','signed_at',
        'receive_bill_status','remark','gross_weight','bulk'];

    protected $appends =[
        'ownerName','sku','packageWeight','packageBulk','orderCity','packageLogisticNumber','packageLogistic','orderClientNumber'
    ];
    public function commodities(){
        return $this->hasOne(OrderPackageCommodities::class,'id','order_package_commodity_id');
    }
    public function owner(){
        return $this->hasOne(Owner::class,'id','owner_id');
    }
    public function uploadFile()
    {
        return $this->hasOne(UploadFile::class,'table_id','order_client_code')->where('table_name','order_trackings');
    }

    public function getOwnerNameAttribute(){
        return $this->owner['name'] ?? '';
    }
    public function getSkuAttribute(){
        return ['sku' => $this->commodities['commodity']['sku'] ?? '',
            'skuName' => $this->commodities['commodity']['name'] ?? '',
            'skuAmount' => $this->commodities['amount'] ?? ''];
    }
    public function getPackageWeightAttribute(){
        return $this->commodities->package['weight'] ?? '';
    }
    public function getPackageBulkAttribute(){
        return $this->commodities->package['bulk'] ?? '';
    }
    public function getOrderCityAttribute(){
        return $this->commodities->package->order['city'] ?? '';
    }
    public function getPackageLogisticNumberAttribute(){
        return $this->commodities->package['logistic_number'] ?? '';
    }
    public function getPackageLogisticAttribute(){
        return $this->commodities->package->order->logistic['name'] ?? '';
    }
    public function getOrderClientNumberAttribute(){
        return $this->commodities->package->order['client_code'] ?? '';
    }
}