sukohi/eloquent-array

A Laravel package to deal with array values that we can search through where clause.

EloquentArray

A Laravel package to deal with array values that we can search through where clause.
This package is only for Laravel 5.3+., _(*1)

Installation

Execute the following command., _(*2)

composer require sukohi/eloquent-array:6.*

then set EloquentArrayServiceProvider in your config/app.php., _(*3)

Sukohi\EloquentArray\EloquentArrayServiceProvider::class, 

Preparation

Execute the following command to publish and migrate the migration., _(*4)

php artisan vendor:publish --provider="Sukohi\EloquentArray\EloquentArrayServiceProvider"
php artisan migrate

Then set EloquentArrayTrait in your model like so., _(*5)

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;
use Sukohi\EloquentArray\EloquentArrayTrait;

class Item extends Model
{
    use EloquentArrayTrait;
}

Usage

Set

$item = \App\Item::find(1);
$item->setArray('locales', [
    'en' => 'English',
    'es' => 'Spanish',
    'ja' => 'Japanese'
]);
$item->saveArray();

Unset

$item->unsetArray('locales'); // Remove `locales`
$item->saveArray();

// Or

$item->unsetArray('locales', 'en'); // Remove `en`
$item->saveArray();

Delete

A specific array values related to an item will be removed., _(*6)

\App\Item::find(1)->deleteArray('locales');

Clear

All of the array values related to an item will be removed., _(*7)

\App\Item::find(1)->clearArray();

Retrieve

with Key, _(*8)

$item = \App\Item::find(1);
$array = $item->getArray('locales');

/* 

    Array
    (
        [en] => English
        [es] => Spanish
        [ja] => Japanese
    )

*/

without Key, _(*9)

$array = $item->getArray('locales', false);

/* 

    Array
    (
        [0] => English
        [1] => Spanish
        [2] => Japanese
    )

*/

All values, _(*10)

$array = $item->getAllArray();

A Specific Value, _(*11)

echo $item->getArrayValue('locales', 'en'); // English

// with Default Value

echo $item->getArrayValue('locales', 'en', 'Default-Value');

Where Clause

You can use whereArray() method to filter your data like so., _(*12)

$items = \App\Item::whereArray('locales', 'en')->get();

// or

$items = \App\Item::where('id', 1)
    ->orWhereArray('locales', 'en')
    ->get();

Order by Clause

You can use array items name for ORDER BY like so., _(*13)

$items = \App\Item::orderByArray('names', 'en')->get();         // asc
$items = \App\Item::orderByArray('names', 'en', 'asc')->get();

// or

$items = \App\Item::orderByArray('names', 'en', 'desc')->get();

Model

[Set], _(*14)

$item->setModelArray('App\User', 1);   // Model ID
$item->saveArray();

[Set Array], _(*15)

$item->setAllModelArray([
    'App\User' => [1, 2, 3, 4, 5]   // Model IDs
]);
$item->saveArray();

[Unset], _(*16)

$item->unsetModelArray([
    'App\User' => [2, 3]   // Model IDs
]);
$item->saveArray();

[Clear], _(*17)

$item->clearModelArray('App\User');
$item->saveArray();

// or

$item->clearModelArray([
    'App\User',
    'App\Item'
]);
$item->saveArray();

[Retrieve], _(*18)

$users = $item->getModelArray('App\User');

License

This package is licensed under the MIT License.
Copyright 2016 Sukohi Kuhoh, _(*19)