OrderCommodityAssign.php 861 B

123456789101112131415161718192021222324252627282930313233
  1. <?php
  2. namespace App;
  3. use Illuminate\Database\Eloquent\Model;
  4. class OrderCommodityAssign extends Model
  5. {
  6. protected $fillable = [
  7. "order_id", //外键订单
  8. "commodity_id", //外键商品
  9. "amount", //数量 default 0
  10. "produced_at", //生产日期
  11. "valid_at", //失效日期
  12. "batch_number", //批次号
  13. "location", //库位
  14. "region", //库区
  15. "user_id", //操作人
  16. ];
  17. public function order()
  18. { //订单
  19. return $this->hasOne(Order::class,"id","order_id");
  20. }
  21. public function commodity()
  22. { //商品
  23. return $this->hasOne(Commodity::class,"id","commodity_id");
  24. }
  25. public function user()
  26. { //用户
  27. return $this->hasOne(User::class,"id","user_id");
  28. }
  29. }