開發了一個Repository，說明如下....

Github

Repository Design Pattern for Laravel

Install

To get the latest version of Laravel Exceptions, simply require the project using Composer:

composer require recca0120/laravel-repository

Instead, you may of course manually update your require block and run composer update if you so choose:

{
    "require": {
        "recca0120/laravel-repository": "~1.1.4"
    }
}

Methods

Recca0120\Repository\Contracts\Repository

• find($id);
• function findAll()
• findBy($criteria, $limit = null, $offset = null)
• findOneBy($criteria)
• paginatedAll($perPage = null, $pageName = 'page', $page = null)
• paginatedBy($criteria, $perPage = null, $pageName = 'page', $page = null)
• create($data)
• update($data, $id)
• delete($id)
• newInstance($data)

Usage

Eloquent

Create a Model

Create your model normally, but it is important to define the attributes that can be filled from the input form data.

namespace App;

use Illuminate\Database\Eloquent\Model;

class Post extends Model
{
    protected $fillable = [
        'title',
        'author',
     ];
}

Create a Contract

namespace App\Repositories\Contracts;

interface UserRepository
{

}

Create a Repository

namespace App\Repositories;

use App\Repositories\Contracts\PostRepository as PostRepositoryContract;
use App\Post;
use Recca0120\Repository\EloquentRepository;

class PostRepository extends EloquentRepository implements PostRepositoryContract
{
    public function __construct(Post $model)
    {
        $this->model = $model;
    }
}

Bind

namespace App\Providers;

use Illuminate\Support\ServiceProvider;
use App\Repositories\Contracts\PostRepository as PostRepositoryContract;

class AppServiceProvider extends ServiceProvider
{
    public function register()
    {
        $this->app->singleton(PostRepositoryContract::class, PostRepository::class);
    }
}

Controller

namespace App\Http\Controllers;

use App\Repositories\Contracts\PostRepository;

class PostsController extends Controller
{
    protected $repository;

    public function __construct(PostRepository $repository)
    {
        $this->repository = $repository;
    }
}

Methods

Find all results in Repository

$posts = $this->repository->findAll();

Find all results in Repository with pagination

$posts = $this->repository->paginatedAll();

Create new entry in Repository

$post = $this->repository->create(request()->all());

Update entry in Repository

$post = $this->repository->update(request()->all(), $id);

Delete entry in Repository

$this->repository->delete($id);

New instance

$post = $this->repository->newInstance([
    'author' => 'author'
]);

Find result by id

$post = $this->repository->find($id);

Find by conditions

Using the Criteria

Criteria is support all of Eloquent functions

Single Criteria

use Recca0120\Repository\Criteria;

$criteria = Criteria::create()
    ->select('*')
    ->where('author', '=', 'author')
    ->orWhere('title', '=', 'title')
    ->orderBy('author', 'asc');

$this->repository->findBy($criteria);
// $this->repository->findOneBy($criteria);
// $this->repository->paginatedBy($criteria);

Multiple Criteria

use Recca0120\Repository\Criteria;

$criteria = [];

$criteria[] = Criteria::create()
    ->orderBy('author', 'asc');

$criteria[] = Criteria::create()
    ->where('author', '=', 'author')
    ->orWhere('title', '=', 'title');

$this->repository->findBy($criteria);
// $this->repository->findOneBy($criteria);
// $this->repository->paginatedBy($criteria);

With

use Recca0120\Repository\Criteria;

$criteria = Criteria::create()
    ->with('author', function(Criteria $criteria) {
        return $criteria->where('author', '=', 'author');
    });

$this->repository->findBy($criteria);
// $this->repository->findOneBy($criteria);
// $this->repository->paginatedBy($criteria);

Join

use Recca0120\Repository\Criteria;

$criteria = Criteria::create()
    ->join('author', function (Criteria $criteria) {
        return $criteria->on('posts.author_id', '=', 'author.id');
    });

$this->repository->findBy($criteria);
// $this->repository->findOneBy($criteria);
// $this->repository->paginatedBy($criteria);

Expression

use Recca0120\Repository\Criteria;

$criteria = Criteria::create()
    ->where('created_at', '<=', Criteria::expr('NOW()'));

$this->repository->findBy($criteria);
// $this->repository->findOneBy($criteria);
// $this->repository->paginatedBy($criteria);

Find results by array

use Recca0120\Repository\Criteria;

$posts = $this->repository->findBy([
    'author' => 'author',
    ['title', '=', 'title'],
    Criteria::create()
        ->where('created_at', '<=', Criteria::expr('NOW()'))
]);

Custom Criteria

use Recca0120\Repository\Criteria;

class CustomCriteria extends Criteria
{
    public function __construct($id)
    {
        $this->where('id', '=', $id);
    }
}

$this->repository->findBy(CustomCriteria::create(1));
$this->repository->findBy((new CustomCriteria::create(2))->where('autor', '=', 'autor'));

Illuminte\Support\Collection

Create a Collection

You can use Collection to be your model

namespace App;

use Illuminate\Support\Collection;

class Post extends Collection
{
    public static function make($items = [])
    {
        // it will cast to \Illuminate\Support\Fluent;
        return parent::make([
            [
                'id' => 1,
                'title' => 'title',
                'autor' => 'author'
            ],
            [
                'id' => 2,
                'title' => 'title2',
                'autor' => 'author2'
            ],
        ]);
    }
}

Support Criteria

• where
• orderBy