App\Services\ProblemService

Complexity

Total Complexity

4

Size/Duplication

Total Lines	55
Duplicated Lines	0 %

Importance

Changes	2
Bugs	1	Features	0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	numberOfAcceptedUser()	0	9	1
A	bestSolutions()	0	14	1
A	getResultCount()	0	11	1
A	numberOfSubmitUser()	0	8	1

<?php

namespace App\Services;

use App\Repositories\Criteria\BestSolution;
use App\Repositories\Criteria\Distinct;
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 App\Status;

class ProblemService
{
    public function numberOfAcceptedUser($problemId)
    {
        /** @var SolutionRepository $repository */
        $repository = app(SolutionRepository::class);
        $repository->pushCriteria(new Where('problem_id', $problemId));
        $repository->pushCriteria(new Where('result', Status::ACCEPT));
        $repository->pushCriteria(new Distinct('user_id'));

        return $repository->count();
    }

    public function numberOfSubmitUser($problemId)
    {
        /** @var SolutionRepository $repository */
        $repository = app(SolutionRepository::class);
        $repository->pushCriteria(new Where('problem_id', $problemId));
        $repository->pushCriteria(new Distinct('user_id'));

        return $repository->count();
    }

    /**
     * @param $problemId
     *
     * @return array
     */
    public function getResultCount($problemId)
    {
        /** @var SolutionRepository $repository */
        $repository = app(SolutionRepository::class);
        $repository->pushCriteria(new Where('problem_id', $problemId));
        $repository->pushCriteria(new RawSelect('count(*) as user_count, result'));
        $repository->pushCriteria(new GroupBy('result'));

        app('db')->connection()->statement('SET sql_mode = \'\'');

        return $repository->all();
    }

    public function bestSolutions($problemId, $perPage = 50)
    {
        /** @var SolutionRepository $repository */
        $repository = app(SolutionRepository::class);

        $repository->pushCriteria(new BestSolution());
        $repository->pushCriteria(new Where('problem_id', $problemId));
        $repository->pushCriteria(new Where('result', Status::ACCEPT));
        $repository->pushCriteria(new OrderBy('time_cost', 'asc'));
        $repository->pushCriteria(new OrderBy('score', 'asc'));
        $repository->pushCriteria(new OrderBy('id', 'asc'));
        $repository->pushCriteria(new GroupBy('user_id'));

        return $repository->paginate($perPage);
    }
}