andersao / andersao/l5-repository
Is it possible to do sum() for MySQL?
- 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
Assessment
This issue has not been assessed yet.