for testing and deploying your application
for finding and fixing issues
for empowering human code reviews
<?php
namespace App\Services;
use App\Repositories\Criteria\GroupBy;
use App\Repositories\Criteria\OrderBy;
use App\Repositories\Criteria\RawSelect;
use App\Repositories\Criteria\Where;
use App\Repositories\SolutionRepository;
use Carbon\Carbon;
class SolutionService
{
/** @var SolutionRepository */
private $repository;
/**
* SolutionService constructor.
*/
public function __construct()
$this->repository = app(SolutionRepository::class);
}
public function find($id)
return $this->repository->find($id);
* @param Carbon $from
*
* @return mixed
public function getSubmissionStats($from)
$this->repository->clearCriteria();
$rawSql = 'DATE_FORMAT(created_at,\'%Y-%m-%d\') as date, count(*) as number';
$this->repository->pushCriteria(new RawSelect($rawSql));
$this->repository->pushCriteria(new Where('created_at', $from->format('Y-m-d h:i:s'), '>'));
$this->repository->pushCriteria(new GroupBy('date'));
$this->repository->pushCriteria(new OrderBy('date', 'desc'));
return $this->repository->all();
hustoj /
hustoj-neo
