App\Models\Search\ProblemSearchModel

Complexity

Total Complexity

6

Size/Duplication

Total Lines	31
Duplicated Lines	0 %

Importance

Changes	2
Bugs	0	Features	2

1 Method

Rating	Name	Duplication	Size	Complexity
A	search()	0	26	6

<?php

namespace App\Models\Search;

use App\Models\ProblemModel;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\DB;

class ProblemSearchModel extends Model
{
    protected $table='problem';
    protected $primaryKey='pid';

    public function search($key)
    {
        $result = [];
        //problem code find
        $ret = self::where('pcode', $key)
            ->select('pcode', 'title')
            ->first();
        if(!empty($ret)){
            array_push($result,$ret);
        }
        //problem name find
        if(strlen($key) >= 2){
            $ret = self::whereRaw('MATCH(`title`) AGAINST (? IN BOOLEAN MODE)',[$key])
                ->select('pcode', 'title')
                ->get()->all();
            if(!empty($ret)){
                $result += $ret;
            }
        }
        $problemModel = new ProblemModel();
        foreach ($result as $p_index => $p) {
            if($problemModel->isBlocked($p['pid'])){
                unset($result[$p_index]);
            }
        }
        return $result;
    }
}