orocrm /
crm
| @@ 331-344 (lines=14) @@ | ||
| 328 | * |
|
| 329 | * @return QueryBuilder |
|
| 330 | */ |
|
| 331 | public function getCustomersCountWhatMakeCartsQB($alias) |
|
| 332 | { |
|
| 333 | $qb = $this->createQueryBuilder($alias) |
|
| 334 | ->select( |
|
| 335 | sprintf( |
|
| 336 | 'COUNT(DISTINCT %s.customer) + SUM(CASE WHEN %s.isGuest = true THEN 1 ELSE 0 END)', |
|
| 337 | $alias, |
|
| 338 | $alias |
|
| 339 | ) |
|
| 340 | ); |
|
| 341 | $this->applyActiveChannelLimitation($qb); |
|
| 342 | ||
| 343 | return $qb; |
|
| 344 | } |
|
| 345 | ||
| 346 | /** |
|
| 347 | * @param string $alias |
|
| @@ 303-316 (lines=14) @@ | ||
| 300 | * |
|
| 301 | * @return QueryBuilder |
|
| 302 | */ |
|
| 303 | public function getUniqueCustomersCountQB($alias) |
|
| 304 | { |
|
| 305 | $qb = $this->createQueryBuilder($alias) |
|
| 306 | ->select( |
|
| 307 | sprintf( |
|
| 308 | 'COUNT(DISTINCT %s.customer) + SUM(CASE WHEN %s.isGuest = true THEN 1 ELSE 0 END)', |
|
| 309 | $alias, |
|
| 310 | $alias |
|
| 311 | ) |
|
| 312 | ); |
|
| 313 | $this->applyActiveChannelLimitation($qb); |
|
| 314 | ||
| 315 | return $qb; |
|
| 316 | } |
|
| 317 | ||
| 318 | /** |
|
| 319 | * @return QueryBuilder |
|
