<?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 sku(){
        return OracleBasSKU::query()->where(['sku'=>$this->sku,'customerId'=>$this->customerId])->get();
    }
    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');
    }
}