Hi,

I'm trying to convert a query to models:

My query:

$article = DB::table('Article as A')
->join('ArticleDesignation as AD', function ($join) {
$join->on('A.HCode', '=', 'AD.HCode')->on('A.Style','=','AD.Style')->where('AD.Language', 'EN');
})
->join('ArticleVariantsCSG as CSG', function($join) {
$join->on('A.HCode', '=', 'CSG.HCode')->on('A.Style', '=', 'CSG.Style');
})
->join('ArticleColorCodes as ACC', 'CSG.Colorcode', '=', 'ACC.Colorcode')
->join('ArticleVariantsSKU as SKU', function($join) {
$join->on('CSG.HCode', '=', 'SKU.HCode')->on('CSG.Style', '=', 'SKU.Style')->on('CSG.Colorcode', '=', 'SKU.Colorcode');
})
->join('ArticleSizeCodes as ASC', 'SKU.Sizecode', '=', 'ASC.Sizecode')
->select('A.HCode', 'A.Style', 'AD.Designation1', 'CSG.Colorcode' ,'CSG.Picture', 'ACC.LAyer', 'SKU.Position','ASC.Designation AS Size', 'A.SizeRangeAsterix')
->paginate(10);
return $article;

This query is working. I would like give the API more structure with Eloquent Models.

I'm also using awobaz/compoships package to join tables with multiple foreign_keys.

What i have done already:

Created Article, ArticleDesignation, ArticleVariantsCSG, Eloquent Model

Article Model has the relationship

 public function articleDesignation()
    {
        return $this->hasOne(ArticleDesignation::class, ['HCode', 'Style'], ['HCode', 'Style'])
                    ->where('Language', 'EN');
    }
		
		public function articleVariants()
    {
        return $this->hasOne(ArticleVariantsCSG::class, ['HCode', 'Style'], ['HCode', 'Style']);
    }
		

ArticleDesignation Model has the relationship

public function article()
    {
        return $this->belongsTo(Article::class, ['HCode', 'Style'], ['HCode', 'Style']);
    }

ArticleVariantsCSG Model has the relationship

public function article()
    {
        return $this->belongsTo(Article::class, ['HCode', 'Style'], ['HCode', 'Style']);
    }

but now I'm struggling how to convert this ->join('ArticleColorCodes as ACC', 'CSG.Colorcode', '=', 'ACC.Colorcode')