<?php


namespace App\Repository\Category;


use App\Http\Requests\Category\CreateRequest;
use App\Http\Requests\Category\IndexRequest;
use App\Http\Requests\Category\UpdateRequest;
use App\Models\Category;
use App\Repository\BaseRepository;
use App\Traits\GridTrait;
use Illuminate\Database\Eloquent\Builder;

class CategoryRepository extends BaseRepository
{
    use GridTrait;

    /**
     * @return Builder
     */
    public static function getQuery() {
        return Category::query();
    }

    /**
     * @param IndexRequest $request
     * @return mixed
     */
    public function search(IndexRequest $request)
    {
        $query = self::getAvailable();

        $this->makeQueryOrdered(Category::class, $query, $request);

        if (isset($request->name) && !empty($request->name)) {
            $query->where('name', 'like', '%' . $request->name . '%');
        }

        if (isset($request->code) && !empty($request->code)) {
            $query->where('code', 'like', '%' . $request->code . '%');
        }

        $perPage = $request->per_page ?? config('crud.defaultPerPage');

        return $query->paginate((int)$perPage)->appends($request->all());
    }

    public function search_specifications(IndexRequest $request)
    {
        $query = self::getAvailable();

        $query->groupBy('name');

        $this->makeQueryOrdered(Category::class, $query, $request);

        $perPage = 1000;

        return $query->paginate((int)$perPage)->appends($request->all());
    }

    /**
     * @param CreateRequest $request
     */
    public function save(CreateRequest $request)
    {
        $model = new Category();

        $request->validate($request->rules());

        $fields = $request->all();

        $model->fill($fields)->save();
    }

    public function saveData($data)
    {
        $fc = mb_strtoupper(mb_substr($data[1], 0, 1));
        $name = $fc.mb_substr($data[1], 1);

        $category = new Category();
        $category->code = $data[0];
        $category->name = $name;
        $category->save();
    }

    /**
     * @param UpdateRequest $request
     */
    public function update(UpdateRequest $request)
    {
        $request->validate($request->rules());

        $fields = $request->all();

        $model =  self::getById($request->id);

        $model->fill($fields)->update();
    }

    /**
     * @param $id
     */
    public function delete($id)
    {
        self::getById($id)->delete();
    }

    /**
     * @param $id
     * @return mixed
     */
    public static function getById($id)
    {
        return static::getAvailable()->findOrFail($id);
    }

    public static function getAll()
    {
        return Category::all();
    }

    public static function getByCode($code)
    {
        return static::getAvailable()->where('code', $code)->first();
    }
}