andersao / andersao/l5-repository

Is it possible to do sum() for MySQL?

Open
#482 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
PHP
Stars
4.2k
Forks
880
PR merge metrics
No merged PRs in 30d

Description

I tried Criteria for `SELECT sum(revenue) FROM table WHERE status = 1` but couldn't find any way.

```
class CommissionTotalByStatusCriteria implements CriteriaInterface
{
/**
* @var int $status
*/
private $status;
/**
* @var string $sumByField
*/
private $sumByField;
public function __construct(int $status, string $sumByField)
{
$this->status = $status;
$this->sumByField = $sumByField;
}
/**
* Apply criteria in query repository
*
* @param $model
* @param RepositoryInterface $repository
*
* @return mixed
*/
public function apply($model, RepositoryInterface $repository)
{
$total = $model->where('status', $this->status)->sum($this->sumByField);
return $model;
}
}
```

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.