2017 © Pedro Peláez
 

library laravel-scopes

Handy scopes for the Laravel's Query Builder.

image

sofa/laravel-scopes

Handy scopes for the Laravel's Query Builder.

  • Friday, November 20, 2015
  • by jarektkaczyk
  • Repository
  • 2 Watchers
  • 4 Stars
  • 1 Installations
  • PHP
  • 0 Dependents
  • 0 Suggesters
  • 1 Forks
  • 0 Open issues
  • 2 Versions
  • 0 % Grown

The README.md

Sofa/Laravel-Scopes

Handy scopes for Laravel's Query Builder., (*1)

Installation

Package requires PHP 5.5.9+ and works with Laravel 5.1.20+ (or standalone illuminate/database 5.1.20., (*2)

  1. Require the package in your composer.json:, (*3)

        "require": {
            ...
            "sofa/laravel-scopes": "~1.0",
        },
    
  2. Call (new Sofa\LaravelScopes\PeriodsAdd)->apply() when you bootstrap your app. In Laravel simply add ServiceProvider to your config/app.php file:, (*4)

        'providers' => [
            // ...
            Sofa\LaravelScopes\ServiceProvider::class,
            // ...
        ],
    

Usage example

Periods

provides extensions of the Query Builder for easy fetching records in given range, relative to NOW. Methods can be used on any eloquent model as well:, (*5)

// Given it's September 11th, 2015

// Query\Builder: count users created in August
DB::table('users')->lastMonth()->count();

// Eloquent\Buidler: get users created on September 10th
User::yesterday()->get();

// count users who logged-in in 2014 & 2015
User::periods('year', 1, 'last_login', true)->count();

// count users created in 2014 & 2015
User::periods('year', -1, null, true)->count();
// or
User::periods('year', -1, true)->count();

// Get subscriptions expiring in October
User::where(...)->nextMonth()->get();

// Get subscriptions expired in past 7 days
User::has(...)->periods('day', -7)->get();

// Get subscriptions expiring in next 30 days
User::periods('day', 30)->get();

Roadmap

  • [x] Periods
  • [ ] Searchable

The Versions

20/11 2015

dev-master

9999999-dev

Handy scopes for the Laravel's Query Builder.

  Sources   Download

MIT

The Requires

 

The Development Requires

database laravel eloquent scopes

20/11 2015

v1.0

1.0.0.0

Handy scopes for the Laravel's Query Builder.

  Sources   Download

MIT

The Requires

 

The Development Requires

database laravel eloquent scopes