mysql - (Laravel) 使用 "Eloquent Relationships"连接 3 个或更多表

Question

我正在尝试使用 Eloquent 关系连接 3 个表，但它没有给出预期的结果。

装运模式

class Shipment extends Model
{
    protected $table = 'ccctadm.Shipment';

    public function customergroupcode()
    {
        return $this->hasMany(DocumentRuleSet::class,'customergroupcode','customergroupcode');
    }
    public function shipmentcategory()
    {
        return $this->hasMany(DocumentRuleSet::class,'shipmentcategory','shipmentcategory');
    }

    public function status()
    {
        return $this->hasMany(DocumentRuleSet::class,'status','status');
    } 
} 

获取数据我正在使用这段代码

   $shipment_data = Shipment::With(['customergroupcode' , 'shipmentcategory','status'])->
Where('shipment_cycle','!=','closed')->get();

我试图让它等同于这个查询

 select B.rulesetname,B.icon ,COUNT(*)As Total  from
[ccct].[ccctadm]. [Shipment] A  INNER  JOIN 
[ccct].[ccctadm].[documentruleset] B
     ON
      A.customergroupcode = B.customergroupcode  AND A.shipmentcategory =  
   B.shipmentcategory AND A.status = B.status INNER
JOIN [ccctadm].[shipassign] S ON  A.id = S.shipmentid AND
 A.shipment_cycle != 'closed'  GROUP BY  rulesetname,B.icon

第一个查询返回 3 个表中的所有数据，但是当第二个查询仅返回 Release 时，这就是我想要的

我只想要这三个表之间有关系的数据而不是所有

我做错了什么？

Answer 1

使用has()方法。它根据关系的存在限制记录。

$shipment_data = Shipment::has('customergroupcode' , 'shipmentcategory','status')->
Where('shipment_cycle','!=','closed')->get();