PHP code example of datalogix / laravel-builder-macros

1. Go to this page and download the library: Download datalogix/laravel-builder-macros library. Choose the download type require.

2. Extract the ZIP file and open the index.php.

3. Add this code to the index.php. 
    
        
<?php
require_once('vendor/autoload.php');

/* Start to develop here. Best regards https://php-download.com/ */

datalogix / laravel-builder-macros example snippets


// Params: $column, $query
$query->addSubSelect('primary_address_id', 
    Address::select('id')
        ->where('user_id', $user->id)
        ->primary()
);

// It adds primary_address_id to the result set


$query->defaultSelectAll()
    ->join('contacts', 'users.id', '=', 'contacts.user_id')
    ->addSelect('contacts.name as contact_name');


$query->filter(['name' => 'john'])->get();

// Returns all results where name 

$query->filter(['name' => 'john', 'contact.email' => '@'])->get();

// Returns all results where name 

$query->filter($request->all())->get();


// Params: $relationName, $operator
$query->joinRelation('contact');


// Params: $relationName, $operator
$query->leftJoinRelation('contact');


$userIds = $query->where('user_id', 10)->map(function ($user) {
    return $user->id;
});

// Returns a collection


$query->whereLike('title', 'john')->get();

// Returns all results where title 

$query->whereLike('title', 'john', false)->get();

// Returns all results where title ends with `john`


$query->whereLike('title', 'john', true, false)->get();

// Returns all results where title starts with `john`


$query->whereLike(['title', 'contact.name'], 'john')->get();

// Returns all results where title or contact.name