snetty/laravel-calculated-columns

Create calculated columns for laravel models

dev-master 2016-02-12 10:55 UTC

Requires

• illuminate/database: >=5.1.0

MIT

• Simon Stevens

• laravel

README

An simple way to add calculated columns to your eloquent models

Usage

1. composer require snetty/laravel-calculated-columns
2. add the trait Snetty\LaravelCalculatedColumns\CalculatedColumns; to your models
3. declare your calculated columns in the form protected $calculated_columns = ['new_column_name' => '(SELECT "SOME SUB QUERY")'];
4. You can use :user_id in your subqueries and it will be parsed in automatically. If no user is present, the whole subquery will return false
5. you can now treat the column in eloquent as if it were a physical column