<?php

namespace App;

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

use App\Traits\ModelLogChanging;

class OracleDOCASNDetail extends Model
{
    use \Awobaz\Compoships\Compoships;
    use ModelLogChanging;

    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,['customerid','sku'],['customerid','sku'])
            ->select('customerid','sku','lotid','alternate_sku1','alternate_sku2','alternate_sku3','descr_c');

    }
}