Laravel Code Snippets

Route::get('/clear-cache', function() {
    $exitCode = Artisan::call('cache:clear');
    echo 'Cache emptied';
});
Route::get('/clear-view', function() {
    $exitCode = Artisan::call('view:clear');
    echo 'View cache emptied';
});

namespace App\Http\Controllers;
  
use Illuminate\Http\Request;
use Carbon\Carbon;

class UserController extends Controller
{
   
    public function index()
    {
        $half_month_ago = Carbon::now()->subDays(15);
  
        $sales = User::where('order_date', '>=', $half_month_ago )->get();

    }
}

//
$data = new Invoice;
$data->document = 'Invoice/2020/07';
$data->save();
$id = $data->id;

//
$saleId = DB::table('sales')->insertGetId([
    'document' => 'Invoice/2020/07'
]);

//
$order = Order::create(['document' => 'Invoice/2020/07']);
$id = $order->value('id');

$language = DB::table('languages')->latest()->first();
$language = DB::table('languages')->orderBy('id', 'DESC')->first();

$language = ProgrammingLanguage::latest()->first();
$language = ProgrammingLanguage::select('id')->where('type', $type)->latest('id')->first();
$language = ProgrammingLanguage::orderBy('created_at', 'desc')->first();

$language = ProgrammingLanguage::all()->last();
$type = ProgrammingLanguage::all()->last()->pluck('type');
$latest_id = ProgrammingLanguage::all()->last()->id;
$latest_id = ProgrammingLanguage::orderBy('id', 'desc')->first()->id;

//In AppServiceProvider.php
use Illuminate\Support\Facades\Schema;

public function boot()
{
    //Schema::defaultStringLength(191);
    Schema::defaultStringLength(255);
}

//set max length for each field
$table->string('username', 255);
$table->string('email', 255);

$sales = DB::table('sales')
->orderByRaw("FIELD(state , 'SENT', 'DRAFT', 'DONE', 'CANCEL') ASC")
->get();

$sales = Sale::orderByRaw("FIELD(state , 'SENT', 'DRAFT', 'DONE', 'CANCEL') ASC")
->paginate(100);

//use where
$term = 'Java';
$data = ProgrammingLanguage::where('language', 'like', '"%.$term.%"')->get();

//use json_contains
$keyword = 'Kotlin';
$language = ProgrammingLanguage::whereRaw('json_contains(language, \'["' . $keyword. '"]\')')->get();

//use whereJsonContains in Laravel 5.6+
$flutter = ProgrammingLanguage::whereJsonContains('language', ["Flutter"])->get();
$mobileLanguages = ProgrammingLanguage::whereJsonContains('language', ["Flutter", "React Native"])->get();

//check if record was created succesfully
$message = Message::create($data);
if($message->exists){
	echo 'created';
} else {
	echo 'failed';
}

//check if record was updated succesfully
$affectedRows = Message::where('id', 12)->update(["body" => "Updated body"]);
if($affectedRows > 0){
	echo 'updated';
} else {
	echo 'failed';
}

//in config/app.php
/*
    |--------------------------------------------------------------------------
    | Application Timezone
    |--------------------------------------------------------------------------
    |
    | Here you may specify the default timezone for your application, which
    | will be used by the PHP date and date-time functions. We have gone
    | ahead and set this to a sensible default for you out of the box.
    |
    */
'timezone' => 'America/Chicago'

use Faker\Factory as Faker;

$faker = Faker::create();
DB::table('account')->insert([
    'username' => $faker->userName(),
    'password' => $faker->password(),
    'about' => $faker->sentence(),    
    'created_at' => \Carbon\Carbon::now(),
    'Updated_at' => \Carbon\Carbon::now(),
]);

<script type="text/javascript">

$(function() {    
   
    setInterval( function(){ fetchOrders(); }, 30000 );
    function fetchOrders(){        
        $.ajax({
             type: 'GET',
             dataType: "json",
             url: '{{ url("/ajax/order/fetch") }}',
             success : function(results) {    
                
                if(results.success){
                    var orders = results.data;
                    if(orders.length > 0){
                        for(var i = 0; i < orders.length; i++){
                                                                                    
                                                
                        }
                    }
                }
                
             }
        }); 
    }    
});
</script>

//in view
{!! Request::is('/') ? '' : url('/') !!}

//define route name in route file then check with getName() method in view
Route::get('/', ['as'=>'homepage', 'uses'=>'HomeController@index']);

@if(request()->route()->getName() == 'homepage')
   // 
@else
  //
@endif

//use command
php artisan --version

//view Application.php
class Application extends Container implements ApplicationContract, HttpKernelInterface
{
    /**
     * The Laravel framework version.
     *
     * @var string
     */
    const VERSION = '5.8.38';
 ....
}

//.htaccess
<FilesMatch "^\.env">
    Order allow,deny
    Deny from all
</FilesMatch>

@isset($phoneName)
    {{ $phoneName}}
@endisset

@if(empty($user))
    <p>Guest</p>
@else
    <p>Hello, {{ $user->name }}</p>
@endif

//Laravel 5.7+: print quantity if it exists, otherwise print 0.00
{{ $qty ?? '0.00' }}
{{ $qty or '0.00' }}

@if(isset($student))
    {{ $student->name }}
@endif

"autoload": {
        "psr-4": {
            "App\\": "app/"
        },
        "classmap": [
            "database/seeds",
            "database/factories",
            "app/Libraries"
        ]
    },