eloquent-power-joins

eloquent-power-joins copied to clipboard

Aliases cannot be used on the main model

2

Versions of packages used and PHP. PHP: 8.1 Laravel: 9.16 Eloquent-power-joins: 2.6.4 If I set an alias to the main model from which the relationships originate, the relationships fail, because...

waiaryi

Join type in nested sub-relations

9

Possibility to indicate join type for each relation in joinRelationship callbacks: User::joinRelationship('posts.comments', [     'posts' => function ($join) {         $join->where('posts.published', true);     },     'comments' => function ($join) {         $join->where('comments.approved', true);         $join->left(); //...

dmikam

Conditioning of joins is not consistent

1

I have these two examples: ` $queryBuilder1 = User::query()->joinRelationship('posts.comments', [ 'posts' => function ($join) { $join->where('posts.published', true); }, ]); ` and ` $queryBuilder2 = User::query()->joinRelationship('posts', [ 'posts' => function ($join)...

dmikam

This is from PowerJoinClause:136:143 ```php public function where($column, $operator = null, $value = null, $boolean = 'and') { if ($this->alias && is_string($column) && Str::contains($column, $this->tableName)) { $column = str_replace("{$this->tableName}.", "{$this->alias}.",...

nickfls

Hey Guys, I'm pulling out my hair with this issue since it does not make sense. I hope it's a bug, or something you guys can maybe point me in...

swartjie

Nested joins with belongs to many relations

3

Hi, I use ```php ->JoinRelationship('groups.roles.permissions.module', $powerJoinClause); ``` with ```php $powerJoinClause = [ 'permissions' => [ 'permissions' => function ($join) use ($permissionName) { $join->name($permissionName); }, ], 'module' => function ($join) use...

wangarrius

Hi, I am using leftJoinRelationshipUsingAlias. This simple example should return both table ids but w_id is returning null. ``` ConversionOptionsNew::optionType('wheel-style') ->active() ->inOrder() ->leftJoinRelationshipUsingAlias('wheelSize', 'wheel_size') ->select('conversion_options_new.id', 'wheel_size.id as w_id') ->get(); ```...

jreason

PoweJoinWhereHas on Pivot table is not working

1

### Steps to reproduce Laravel 8.0 MySql 5.7 PHP 7.4 ``` class Product extends Model { public function productCategories() { return $this->hasMany(ProductCategory::class, 'product_id', 'id'); } } public function scopeType($q, $type)...

navaneeth-raman-bhaskar

BelongsToMany with relatedKey

1

Hi, PowerJoins does not work with belongToMany when we use custom related key (6th parameter), for example : ` return $this->belongsToMany("\App\Models\Material", "CUSTOMER_MATERIAL", "CUSTNO", "CARNO", "CUSTNO", "CARNO");` Generated query is :...

simong88

The Joins do not contemplate connections with other databases

12

The joins do not consider if the relationship they are pointing to belongs to another database (within the same server). Also if they have different prefixes, just add the prefix...

mcolominas