INSTALLATION.md

Installation

Note: If you're looking to use Inventory with MSSQL, you will need to modify the published migrations to suit. By default, multiple cascade delete paths are present on foreign keys, and you'll need to modify and / or remove these for compatibility.

Installation (Laravel 4)

Run the following command:

composer require trexology/laravel-inventory

Now perform a composer update on your project's source.

Then insert the service provider in your app/config/app.php config file:

'Trexology\Inventory\InventoryServiceProvider'

If you want to customize the database tables, you can publish the migration and run it yourself:

php artisan migrate:publish trexology/laravel-inventory

And then run the migration:

php artisan migrate

Otherwise you can run the install command:

php artisan inventory:install

Be sure to publish the configuration if you'd like to customize inventory:

php artisan config:publish trexology/laravel-inventory

Installation (Laravel 5)

Run the following command:

composer require trexology/laravel-inventory

Now perform a composer update on your project's source.

Then insert the service provider in your config/app.php config file: (Skip this step if you are on 5.5 and above)

'Trexology\Inventory\InventoryServiceProvider'

Either publish the assets to customize the database tables using:

php artisan vendor:publish

And then run the migrations:

php artisan migrate

Or use the inventory install command:

php artisan inventory:install

Customize Installation

I don't need to customize my models

If you don't need to create & customize your models, I've included pre-built models.

If you'd like to use them you'll have include them in your use statements:

use Trexology\Inventory\Models\Inventory;

class InventoryController extends BaseController
{
    /*
    * Holds the inventory model
    *
    * @var Inventory
    */
    protected $inventory;

    public function __construct(Inventory $inventory)
    {
        $this->inventory = $inventory;
    }

    public function create()
    {
        $item = new $this->inventory;

        // etc...
    }
}

I want to customize my models

Create the models, but keep in mind the models need:

• The shown fillable attribute arrays (needed for dynamically creating & updating relationship records)
• The shown relationship names (such as stocks())
• The shown relationship type (such as hasOne, hasMany, belongsTo etc)

You are free to modify anything else (such as table names, model names, namespace etc!).

InventoryMetric:

class InventoryMetric extends Model
{
    protected $table = 'metrics';
}

Location:

use Baum\Node;

class Location extends Node
{
    protected $table = 'locations';
}

InventoryCategory:

use Trexology\Inventory\Traits\CategoryTrait;
use Baum\Node;

class InventoryCategory extends Node
{
    use CategoryTrait;

    protected $table = 'categories';

    protected $scoped = ['belongs_to'];

    public function inventories()
    {
        return $this->hasMany('Inventory', 'category_id');
    }
}

InventorySupplier:

use Trexology\Inventory\Traits\SupplierTrait;

class InventorySupplier extends BaseModel
{
    use SupplierTrait;

    protected $table = 'suppliers';

    public function items()
    {
        return $this->belongsToMany('Inventory', 'inventory_suppliers', 'supplier_id')->withTimestamps();
    }
}

Inventory:

use Trexology\Inventory\Traits\AssemblyTrait;
use Trexology\Inventory\Traits\InventoryTrait;
use Trexology\Inventory\Traits\InventoryVariantTrait;

class Inventory extends Model
{
    use InventoryTrait;
    use InventoryVariantTrait;
    use AssemblyTrait;

    protected $table = 'inventories';

    public function category()
    {
        return $this->hasOne('Category', 'id', 'category_id');
    }

    public function metric()
    {
        return $this->hasOne('Metric', 'id', 'metric_id');
    }

    public function sku()
    {
        return $this->hasOne('InventorySku', 'inventory_id', 'id');
    }

    public function stocks()
    {
        return $this->hasMany('InventoryStock', 'inventory_id');
    }

    public function suppliers()
    {
        return $this->belongsToMany('Supplier', 'inventory_suppliers', 'inventory_id')->withTimestamps();
    }

    public function assemblies()
    {
        return $this->belongsToMany($this, 'inventory_assemblies', 'inventory_id', 'part_id')
            ->withPivot(['quantity'])->withTimestamps();
    }
}

InventorySku:

use Trexology\Inventory\Traits\InventorySkuTrait;

class InventorySku extends Model
{
    use InventorySkuTrait;

    protected $table = 'inventory_skus';

    protected $fillable = array(
        'inventory_id',
        'code',
    );

    public function item()
    {
        return $this->belongsTo('Inventory', 'inventory_id', 'id');
    }
}

InventoryStock:

use Trexology\Inventory\Traits\InventoryStockTrait;

class InventoryStock extends Model
{
    use InventoryStockTrait;

    protected $table = 'inventory_stocks';

    protected $fillable = array(
        'inventory_id',
        'location_id',
        'quantity',
        'aisle',
        'row',
        'bin',
    );

    public function item()
    {
        return $this->belongsTo('Inventory', 'inventory_id', 'id');
    }

    public function movements()
    {
        return $this->hasMany('InventoryStockMovement', 'stock_id');
    }

    public function transactions()
    {
        return $this->hasMany('InventoryTransaction', 'stock_id', 'id');
    }

    public function location()
    {
        return $this->hasOne('Location', 'id', 'location_id');
    }
}

InventoryStockMovement:

use Trexology\Inventory\Traits\InventoryStockMovementTrait;

class InventoryStockMovement extends Model
{
    use InventoryStockMovementTrait;

    protected $table = 'inventory_stock_movements';

    protected $fillable = array(
        'stock_id',
        'user_id',
        'before',
        'after',
        'cost',
        'reason',
    );

    public function stock()
    {
        return $this->belongsTo('InventoryStock', 'stock_id', 'id');
    }
}

InventoryTransaction:

use Trexology\Inventory\Traits\InventoryTransactionTrait;
use Trexology\Inventory\Interfaces\StateableInterface;

class InventoryTransaction extends BaseModel implements StateableInterface
{
    use InventoryTransactionTrait;

    protected $table = 'inventory_transactions';

    protected $fillable = array(
        'user_id',
        'stock_id',
        'name',
        'state',
        'quantity',
    );

    public function stock()
    {
        return $this->belongsTo('InventoryStock', 'stock_id', 'id');
    }

    public function histories()
    {
        return $this->hasMany('InventoryTransactionHistory', 'transaction_id', 'id');
    }
}

InventoryTransactionHistory:

use Trexology\Inventory\Traits\InventoryTransactionHistoryTrait;

class InventoryTransactionHistory extends BaseModel
{
    use InventoryTransactionHistoryTrait;

    protected $table = 'inventory_transaction_histories';

    protected $fillable = array(
        'user_id',
        'transaction_id',
        'state_before',
        'state_after',
        'quantity_before',
        'quantity_after',
    );

    public function transaction()
    {
        return $this->belongsTo('InventoryTransaction', 'transaction_id', 'id');
    }
}