20 ترفند و نکته ELOQUENT در لاراول

    
          $article = Article::find($article_id);
	      $article->read_count++;
	      $article->save();

    
          $article = Article::find($article_id);
          $article->increment('read_count');

    
    $user = User::findOrFail($id);

    
    $user = User::where('email', $email)->first();
    if (!$user) {
      User::create([
        'email' => $email
      ]);
}
    
    

    
    $user = User::firstOrCreate(['email' => $email]);

    
    class User extends Model
    {
        public static function boot()
        {
            parent::boot();
            static::updating(function($model)
            {
                // do some logging
                // override some property like $model->something = transform($something);
            });
        }
    }

   
    public static function boot()
    {
      parent::boot();
      self::creating(function ($model) {
        $model->uuid = (string)Uuid::generate();
      });
    }

  
    public function users() {
    return $this->hasMany('App\User');    
    }

   
    public function approvedUsers() {
    return $this->hasMany('App\User')->where('approved', 1)->orderBy('email');
    }

   
    class User extends Model {
    protected $table = 'users';
    protected $fillable = ['email', 'password']; // which fields can be filled with User::create()
    protected $dates = ['created_at', 'deleted_at']; // which fields will be Carbon-ized
    protected $appends = ['field1', 'field2']; // additional values returned in JSON
    }

   
    protected $primaryKey = 'uuid'; // it doesn't have to be "id"
    public $incrementing = false; // and it doesn't even have to be auto-incrementing!
    protected $perPage = 25; // Yes, you can override pagination count PER MODEL (default 15)
    const CREATED_AT = 'created_at';
    const UPDATED_AT = 'updated_at'; // Yes, even those names can be overridden
    public $timestamps = false; // or even not used at all

  
    $user = User::find(1);

   
    $users = User::find([1,2,3]);

   
    $users = User::where('approved', 1)->get();

   
    public function latestPost()
    {
        return $this->hasOne(\App\Post::class)->latest();
    } 

  
    $users = Topic::with('latestPost')->get()->sortByDesc('latestPost.created_at');

   
    if (request('filter_by') == 'likes') {
    $query->where('likes', '>', request('likes_amount', 0));
    }
    if (request('filter_by') == 'date') {
        $query->orderBy('created_at', request('ordering_rule', 'desc'));
    }

   
    $query = Author::query();
    $query->when(request('filter_by') == 'likes', function ($q) {
        return $q->where('likes', '>', request('likes_amount', 0));
    });
    $query->when(request('filter_by') == 'date', function ($q) {
        return $q->orderBy('created_at', request('ordering_rule', 'desc'));
    });

   
    $query = User::query();
    $query->when(request('role', false), function ($q, $role) { 
        return $q->where('role_id', $role);
    });
    $authors = $query->get();

   
    {{ $post->author->name }}

  
    {{ $post->author->name ?? '' }}

   
    public function author()
    {
        return $this->belongsTo('App\Author')->withDefault([
            'name' => 'Guest Author'
        ]);
    }

  
    function getFullNameAttribute()
    {
      return $this->attributes['first_name'] . ' ' . $this->attributes['last_name'];
    }

  
    $clients = Client::orderBy('full_name')->get(); // doesn't work

  
    $clients = Client::get()->sortBy('full_name'); // works!

  
    protected static function boot()
    {
        parent::boot();
    
        // Order by name ASC
        static::addGlobalScope('order', function (Builder $builder) {
            $builder->orderBy('name', 'asc');
        });
    }

  
    // whereRaw
    $orders = DB::table('orders')
    ->whereRaw('price > IF(state = "TX", ?, 100)', [200])
    ->get();

    // havingRaw
    Product::groupBy('category_id')->havingRaw('COUNT(*) > 1')->get();

    // orderByRaw
    User::where('created_at', '>', '2016-01-01')
      ->orderByRaw('(updated_at - created_at) desc')
      ->get();

  
    $task = Tasks::find(1);
    $newTask = $task->replicate();
    $newTask->save();

  
    $users = User::all();
    foreach ($users as $user) {
        // ...

  
    User::chunk(100, function ($users) {
    foreach ($users as $user) {
        // ...
    }
});

  
    php artisan make:model Company

  
    php artisan make:model Company -mcr

  
    $product = Product::find($id);
    $product->updated_at = '2019-01-01 10:00:00';
    $product->save(['timestamps' => false]);

  
    $result = $products->whereNull('category_id')->update(['category_id' => 2]);

    $q->where('gender', 'Male');
    $q->orWhere('age', '>=', 18);
    $q->where('gender', 'Female');
    $q->orWhere('age', '>=', 65);

    $q->where(function ($query) {
    $query->where('gender', 'Male')
        ->where('age', '>=', 18);
    })->orWhere(function($query) {
    $query->where('gender', 'Female')
        ->where('age', '>=', 65); 
})

    $q->where('a', 1);
    $q->orWhere('b', 2);
    $q->orWhere('c', 3);

    
    $q->where('a', 1);
    $q->orWhere(['b' => 2, 'c' => 3]);