<?php

namespace App;

use App\Traits\ModelTimeFormat;
use Illuminate\Database\Eloquent\Model;
use App\Traits\ModelLogChanging;
use Illuminate\Database\Eloquent\Relations\HasMany;
use Illuminate\Database\Eloquent\Relations\HasOne;

class OracleDOCASNHeader extends Model
{
    use ModelLogChanging;

    use ModelTimeFormat;
    protected $connection="oracle";
    protected $table="Doc_ASN_Header";
    protected $primaryKey="ASNNO";

    function getIncrementing()
    {
        return false;
    }

    public function asnType(): HasOne
    {
        return $this->hasOne(OracleBasCode::class,'code','asntype')
            ->where('codeid','ASN_TYP');
    }

    public function asnStatus(): HasOne
    {
        return $this->hasOne(OracleBasCode::class,'code','asnstatus')
            ->where('codeid','ASN_STS');
    }

    public function basCustomer(): HasOne
    {
        return $this->hasOne(OracleBasCustomer::class,'customerid','customerid')
            ->where('customer_type','OW');
    }

    public function asnDetails(): HasMany
    {
        return $this->hasMany(OracleDOCASNDetail::class,'asnno','asnno')
            ->select('asnno','asnlineno','customerid','sku','skudescrc','linestatus','lotatt08','lotatt05','receivedqty','receivedqty_each','expectedqty','addtime','edittime');
    }
}