SolutionService::getSubmissionStats() - Code Metrics - hustoj/hustoj-neo - Measure and Improve Code Quality continuously with Scrutinizer

SolutionService::getSubmissionStats() A
last analyzed 2022-03-31 04:51 UTC

↳ Parent: SolutionService

Complexity

Conditions	1
Paths	1

Size

Total Lines	11
Code Lines	7

Duplication

Lines	0
Ratio	0 %

Importance

Changes	2
Bugs	0	Features	0

Metric	Value
cc	1
eloc	7
c	2
b	0
f	0
nc	1
nop	1
dl	0
loc	11
rs	10

<?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();
    }
}


1			<?php
2
3			namespace App\Services;
4
5			use App\Repositories\Criteria\GroupBy;
6			use App\Repositories\Criteria\OrderBy;
7			use App\Repositories\Criteria\RawSelect;
8			use App\Repositories\Criteria\Where;
9			use App\Repositories\SolutionRepository;
10			use Carbon\Carbon;
11
12			class SolutionService
13			{
14			/** @var SolutionRepository */
15			private $repository;
16
17			/**
18			* SolutionService constructor.
19			*/
20			public function __construct()
21			{
22			$this->repository = app(SolutionRepository::class);
23			}
24
25			public function find($id)
26			{
27			return $this->repository->find($id);
28			}
29
30			/**
31			* @param Carbon $from
32			*
33			* @return mixed
34			*/
35			public function getSubmissionStats($from)
36			{
37			$this->repository->clearCriteria();
38
39			$rawSql = 'DATE_FORMAT(created_at,\'%Y-%m-%d\') as date, count(*) as number';
40			$this->repository->pushCriteria(new RawSelect($rawSql));
41			$this->repository->pushCriteria(new Where('created_at', $from->format('Y-m-d h:i:s'), '>'));
42			$this->repository->pushCriteria(new GroupBy('date'));
43			$this->repository->pushCriteria(new OrderBy('date', 'desc'));
44
45			return $this->repository->all();
46			}
47			}
48

hustoj / hustoj-neo

SolutionService::getSubmissionStats() A last analyzed 2022-03-31 04:51 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

SolutionService::getSubmissionStats() A
last analyzed 2022-03-31 04:51 UTC