|
@@ -117,7 +117,7 @@ discard block |
|
|
block discarded – undo |
|
117
|
117
|
?string $alias = null, |
|
118
|
118
|
): Builder { |
|
119
|
119
|
$reactionType = ReactionType::fromName($reactionTypeName); |
|
120
|
|
- $alias = $alias === null ? 'reaction_' . Str::snake($reactionType->getName()) : $alias; |
|
|
120
|
+ $alias = $alias === null ? 'reaction_'.Str::snake($reactionType->getName()) : $alias; |
|
121
|
121
|
|
|
122
|
122
|
$select = $query->getQuery()->columns ?? ["{$this->getTable()}.*"]; |
|
123
|
123
|
$select[] = $query->raw("COALESCE({$alias}.count, 0) as {$alias}_count"); |
|
@@ -125,7 +125,7 @@ discard block |
|
|
block discarded – undo |
|
125
|
125
|
|
|
126
|
126
|
return $query |
|
127
|
127
|
->leftJoin( |
|
128
|
|
- (new ReactionCounter())->getTable() . ' as ' . $alias, |
|
|
128
|
+ (new ReactionCounter())->getTable().' as '.$alias, |
|
129
|
129
|
function (JoinClause $join) use ($reactionType, $alias) { |
|
130
|
130
|
$join->on("{$alias}.reactant_id", '=', "{$this->getTable()}.love_reactant_id"); |
|
131
|
131
|
$join->where("{$alias}.reaction_type_id", $reactionType->getId()); |
|
@@ -145,7 +145,7 @@ discard block |
|
|
block discarded – undo |
|
145
|
145
|
|
|
146
|
146
|
return $query |
|
147
|
147
|
->leftJoin( |
|
148
|
|
- (new ReactionTotal())->getTable() . ' as ' . $alias, |
|
|
148
|
+ (new ReactionTotal())->getTable().' as '.$alias, |
|
149
|
149
|
"{$alias}.reactant_id", |
|
150
|
150
|
'=', |
|
151
|
151
|
"{$this->getTable()}.love_reactant_id" |
Please login to merge, or discard this patch.