<?php

namespace App\Repository\Movement;

use App\Http\Requests\Movement\IndexRequest;
use App\Models\MovementThroughWarehouses;
use App\Repository\BaseRepository;
use App\Traits\GridTrait;
use Illuminate\Database\Eloquent\Builder;

class MovementRepository extends BaseRepository
{

    use GridTrait;

    public static function getQuery(): Builder
    {
        return MovementThroughWarehouses::query();
    }

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

        $this->makeQueryOrdered(MovementThroughWarehouses::class, $query, $request);
        if (!empty($request->part_name)) {
            $query->whereHas('part', function ($query) use ($request) {
                $query->where(function ($query) use ($request) {
                    $query->where('parts.name', 'LIKE', '%' . $request->part_name . '%')
                        ->orWhere('parts.external_id', 'LIKE', '%' . $request->part_name . '%');
                });
            });
        }

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

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

    public static function addMovement($data)
    {
        $mtw = new MovementThroughWarehouses();
        $mtw->fill($data);
        $mtw->save();
    }
}