baoshi-was/app/OracleDOCASNDetail.php

<?php

namespace App;

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

class OracleDOCASNDetail extends Model
{
    use ModelTimeFormat;
    protected $connection="oracle";
    protected $table="Doc_ASN_Details";


    public function oracleDocAsnHeader(){
        return $this->belongsTo('App\OracleDOCASNHeader','asnno','asnno');
    }
    public function lineStatus()
    {
        return $this->hasOne(OracleBasCode::class,'code','linestatus')
            ->where('codeid','ASN_STS');
    }
    public function qualityStatus()
    {
        return $this->hasOne(OracleBasCode::class,'code','lotatt08')
            ->where('codeid','QLT_STS');
    }
    public function basSku()
    {
        return $this->hasOne(OracleBasSKU::class,'sku','sku')
            ->select('customerid','sku','alternate_sku1');
    }
}