CRCMS Repository

A specialized data provider layer, based on ORM, only as a data provider, the main role is to separate the coupling before the Controller and Model

Install

You can install the package via composer:

composer require crcms/repository

Laravel

If your version is less than 5.5 please modify config / app.php

'providers' => [
    CrCms\Repository\RepositoryServiceProvider::class,
]

If you'd like to make configuration changes in the configuration file you can pubish it with the following Aritsan command:

php artisan vendor:publish --provider="CrCms\Repository\RepositoryServiceProvider"

Commands

php artisan make:repository TestRepository --model TestModel

php artisan make:magic TestMagic

Example

QueryMagic

use CrCms\Repository\AbstractMagic;
use CrCms\Repository\Contracts\QueryRelate;

class TestMagic extends AbstractMagic
{
    /**
     * @param QueryRelate $queryRelate
     * @param int $id
     * @return QueryRelate
     */
    protected function byName(QueryRelate $queryRelate, string $name)
    {
        return $queryRelate->where('name', $name);
    }

    /**
     * @param QueryRelate $queryRelate
     * @param string $title
     * @return QueryRelate
     */
    protected function byTitle(QueryRelate $queryRelate, string $title)
    {
        return $queryRelate->where('title', 'like', "%{$title}%");
    }

    /**
     * @param QueryRelate $queryRelate
     * @param int $id
     * @return QueryRelate
     */
    protected function byId(QueryRelate $queryRelate, int $id)
    {
        return $queryRelate->where('id', $id);
    }
    
    /**
     * @param QueryRelate $queryRelate
     * @param array $sort
     * @return QueryRelate
     */
    protected function bySort(QueryRelate $queryRelate, array $sort)
    {
        return $queryRelate->orderByArray($sort);
    }
}

Repository

class TestRepository extends AbstractRepository
{
    /**
     * @var array
     */
    protected $guard = [
        'id', 'title','other'
    ];

    /**
     * @return TestModel
     */
    public function newModel(): TestModel
    {
        return app(TestModel::class);
    }

    /**
     * @param int $perPage
     * @return LengthAwarePaginator
     */
    public function paginate(AbstractMagic $magic = null, int $perPage = 15): LengthAwarePaginator
    {
        return $this->whenMagic($magic)->where('built_in', 1)->orderBy($this->getModel()->getKeyName(), 'desc')->paginate($perPage);
    }

    /**
     * @param int $name
     * @param int $title
     */
    public function updateName(string $name, string $title)
    {
        $this->where('name', $name)->update(['title' => $title]);
    }
    
}

Guard Or Scenes

Usually we need to filter the incoming parameter values when adding or modifying and querying the data, and retain the required parameter values.

Guard and scenes are born for this

class TestRepository extends AbstractRepository
{
    /**
     * @var array
     */
    protected $scenes = [
        'create' => ['sort', 'added_at'],
        'modify' => ['sort', 'published_at']
    ];
    
    /**
     * @var array
     */
    protected $guard = [
        'id', 'title', 'other'
    ];
}

$testRepository->create($data, 'create'); //OR
$testRepository->setCurrentScene('create')->create($data); //OR
$testRepository->setGuard(['sort', 'added_at'])->create($data); 

class TestMagic extends AbstractMagic
{
    /**
     * @var array
     */
    protected $scenes = [
        'frontend' => ['name'],
        'backend' => ['title']
    ];
    
    /**
     * @var array
     */
    protected $guard = [
        'title',
    ];

    /**
     * @param QueryRelate $queryRelate
     * @param int $id
     * @return QueryRelate
     */
    protected function byName(QueryRelate $queryRelate, string $name)
    {
        return $queryRelate->where('name', $name);
    }

    /**
     * @param QueryRelate $queryRelate
     * @param string $title
     * @return QueryRelate
     */
    protected function byTitle(QueryRelate $queryRelate, string $title)
    {
        return $queryRelate->where('title', 'like', "%{$title}%");
    }
}

$testRepository->magic(new TestMagic($data, 'frontend'))->paginate(); //OR
$testRepository->magic((new TestMagic($data))->setCurrentScene('frontend'))->paginate(); //OR
$testRepository->magic((new TestMagic($data))->setGuard(['title']))->paginate(); //OR->create($data);

Note: when guard and scenes are both present, scenes has a higher priority. If scenes is empty, it will use guard.

Listener

TestRepository::observer(TestListener::class);

TestListener {

    public function creating(TestRepository $repository, array $data)
    {
		//append the value to be written
		$repository->addData('append_data','value');
		
		//rewrite all values written
		$repository->setData(['key'=>'value']);
    }    
    
    public function created(TestRepository $repository, TestModel $model)
    {
    }    

    public function updating(TestRepository $repository, array $data)
    {
    }    
    
    public function updated(TestRepository $repository, TestModel $model)
    {
    }
    
    public function deleting(TestRepository $repository, array $ids)
    {
    }
    
    public function deleted(TestRepository $repository, Collection $models)
    {
    }
}

Cache

class TestRepository {

    public function do(User $user)
    {
        return $this->byIntId($user->id);
    }
}

$repository = new TestRepository;

store

$repository->cache()->do(new User);

forget

$repository->cache()->forget('do')

flush

$repository->cache()->flush()

Repository Methods

public function all(): Collection;

public function get(): Collection;

public function pluck(string $column, string $key = ''): Collection;

public function max(string $column): int;

public function count(string $column = '*'): int;

public function avg($column): int;

public function sum(string $column): int;

public function chunk(int $limit, callable $callback): bool;

public function valueOfString(string $key, string $default = ''): string;

public function valueOfInt(string $key, int $default = 0): int;

public function increment(string $column, int $amount = 1, array $extra = []): int;

public function decrement(string $column, int $amount = 1, array $extra = []): int;

public function delete(): int;

public function deleteByStringId(string $id): int;

public function deleteByIntId(int $id): int;

public function deleteByArray(array $ids): int;

public function paginate(int $perPage = 15) : LengthAwarePaginator;

public function create(array $data) : Model;

public function update(array $data): int;

public function updateByIntId(array $data, int $id) : Model;

public function updateByStringId(array $data, string $id) : Model;

public function byIntId(int $id);

public function byStringId(string $id);

public function byIntIdOrFail(int $id) : Model;

public function byStringIdOrFail(string $id) : Model;

public function oneByString(string $field, string $value): Model;

public function oneByInt(string $field, int $value): Model;

public function oneByStringOrFail(string $field, string $value) : Model;

public function oneByIntOrFail(string $field, int $value) : Model;

public function first();

public function firstOrFail() : Model;

QueryRelate Methods

public function select(array $column = ['*']): QueryRelate;

public function selectRaw(string $expression, array $bindings = []): QueryRelate;

public function skip(int $limit): QueryRelate;

public function take(int $limit): QueryRelate;

public function groupBy(string $column): QueryRelate;

public function groupByArray(array $columns): QueryRelate;

public function orderBy(string $column, string $sort = 'desc'): QueryRelate;

public function orderByArray(array $columns): QueryRelate;

public function distinct(): QueryRelate;

public function where(string $column, string $operator = '=', string $value = ''): QueryRelate;

public function whereClosure(\Closure $callback): QueryRelate;

public function orWhereClosure(\Closure $callback): QueryRelate;

public function orWhere(string $column, string $operator = '=', string $value = ''): QueryRelate;

public function whereBetween(string $column, array $between): QueryRelate;

public function orWhereBetween(string $column, array $between): QueryRelate;

public function whereRaw(string $sql, array $bindings = []): QueryRelate;

public function orWhereRaw(string $sql, array $bindings = []): QueryRelate;

public function orWhereNotBetween($column, array $between): QueryRelate;

public function whereExists(\Closure $callback): QueryRelate;

public function orWhereExists(\Closure $callback): QueryRelate;

public function whereNotExists(\Closure $callback): QueryRelate;

public function orWhereNotExists(\Closure $callback): QueryRelate;

public function whereIn(string $column, array $values): QueryRelate;

public function orWhereIn(string $column, array $values): QueryRelate;

public function whereNotIn(string $column, array $values): QueryRelate;

public function orWhereNotIn(string $column, array $values): QueryRelate;

public function whereNull(string $column): QueryRelate;

public function orWhereNull(string $column): QueryRelate;

public function whereNotNull(string $column): QueryRelate;

public function orWhereNotNull(string $column): QueryRelate;

public function raw(string $sql): QueryRelate;

public function from(string $table): QueryRelate;

public function join(string $table, string $one, string $operator = '=', string $two = ''): QueryRelate;

public function joinClosure(string $table, \Closure $callback): QueryRelate;

public function leftJoin(string $table, string $first, string $operator = '=', string $two = ''): QueryRelate;

public function leftJoinClosure(string $table, \Closure $callback): QueryRelate;

public function rightJoin(string $table, string $first, string $operator = '=', string $two = ''): QueryRelate;

public function rightJoinClosure(string $table, \Closure $callback): QueryRelate;

public function callable(callable $callable): QueryRelate;

public function wheres(array $wheres): QueryRelate;

public function union(QueryRelate $queryRelate): QueryRelate;

public function magic(QueryMagic $queryMagic): QueryRelate;

public function whenMagic(?QueryMagic $queryMagic = null): QueryRelate;

public function with(string $relation): QueryRelate;

public function withArray(array $relations): QueryRelate;

public function without(string $relation): QueryRelate;

public function withoutArray(array $relations): QueryRelate;

public function having(string $column, $operator = null, $value = null): QueryRelate;

public function orHaving(string $column, $operator = null, $value = null): QueryRelate;

public function havingRaw(string $sql, array $bindings = []): QueryRelate;

public function orHavingRaw(string $sql, array $bindings = []): QueryRelate;

public function lockForUpdate(): QueryRelate;

public function sharedLock(): QueryRelate;

License

MIT license