OracleDOCASNDetail.php 741 B

1234567891011121314151617181920212223242526272829303132
  1. <?php
  2. namespace App;
  3. use Illuminate\Database\Eloquent\Model;
  4. use App\Traits\ModelTimeFormat;
  5. use App\Traits\ModelLogChanging;
  6. class OracleDOCASNDetail extends Model
  7. {
  8. use ModelLogChanging;
  9. use ModelTimeFormat;
  10. protected $connection="oracle";
  11. protected $table="Doc_ASN_Details";
  12. public function oracleDocAsnHeader(){
  13. return $this->belongsTo('App\OracleDOCASNHeader','asnno','asnno');
  14. }
  15. public function lineStatus()
  16. {
  17. return $this->hasOne(OracleBasCode::class,'code','linestatus')
  18. ->where('codeid','ASN_STS');
  19. }
  20. public function qualityStatus()
  21. {
  22. return $this->hasOne(OracleBasCode::class,'code','lotatt08')
  23. ->where('codeid','QLT_STS');
  24. }
  25. }