Laravel has a nice way to write queries for your database driver using Query Builder. Something like this:<\/p>\n\n\n\n
<\/p>\n\n\n\n
$orders = Order::where(‘status’, ‘delivered’)->where(‘paid’, true)->get();<\/p>\n\n\n\n
<\/p>\n\n\n\n
This is pretty nice.But this bit of code can be better written if we use local scopes.<\/p>\n\n\n\n
Local scopes allow us to create our Query Builder methods we can chain when we try to retrieve data. For example, instead of First, in our When declaring local scopes, you should use the $orders = Order::delivered()->paid()->get();<\/p>\n\n\n\n <\/p>\n\n\n\n For more dynamic retrieval, you can use dynamic local scopes. Each scope allows you to give parameters.<\/p>\n\n\n\n Laravel uses by default Order::whereStatus(‘delivered’)->paid()->get();<\/p>\n\n\n\n Laravel will search for the Order::whereShippingStatus(‘delivered’)->paid()->get();<\/p>\n\n\n\n <\/p>\n\n\n\n 2.Magic scopes<\/em><\/strong><\/p>\n\n\n\n When building things, you can use the magic scopes that are already embedded<\/p>\n\n\n\n <\/p>\n\n\n\n 3.Do not store model-related static data in configs<\/em><\/strong><\/p>\n\n\n\n Instead of this:<\/p>\n\n\n\n And accessing them using:<\/p>\n\n\n\n I prefer doing this:<\/p>\n\n\n\n And access them using:<\/p>\n\n\n\n Because it\u2019s easier to be used in further operations:<\/p>\n\n\n\n Now we can enjoy scopes:<\/p>\n\n\n\n 4.Use collections instead of raw-array processing<\/em><\/strong><\/p>\n\n\n\n Back in the days, we were used to working with arrays in a raw way:<\/p>\n\n\n\n Now, we can use advanced methods that will help us process the data within arrays. We can filter, transform, iterate and modify data inside an array:<\/p>\n\n\n\n <\/p>\n\n\n\n <\/p>\n\n\n\n Tsuki<\/p>\n\n\n\n->where()<\/code> statements, we can use ->delivered()<\/code> and ->paid()<\/code> in a cleaner way.<\/p>\n\n\n\nOrder<\/code> model, we should add some methods:<\/p>\n\n\n\nclass Order extends Model
{
...
public function scopeDelivered($query) {
return $query->where('status', 'delivered');
} public function scopePaid($query) {
return $query->where('paid', true);
}
}<\/pre>\n\n\n\nscope[Something]<\/code> exact naming. In this way, Laravel will know that this is a scope and will make use of it in your Query Builder. Make sure you include the first argument that is automatically injected by Laravel and is the query builder instance.<\/p>\n\n\n\nclass Order extends Model
{
...
public function scopeStatus($query, string $status) {
return $query->where('status', $status);
}
}$orders = Order::status('delivered')->paid()->get();<\/pre>\n\n\n\nwhere[Something]<\/code> to replace the previous scope. So instead of the previous one, you can do:<\/p>\n\n\n\nsnake_case<\/code> version of Something<\/code> from where[Something]<\/code>. If you have status<\/code> in your DB, you will use the previous example. If you have shipping_status<\/code>, you can use:<\/p>\n\n\n\ncreated_at<\/code> , descending:<\/li><\/ul>\n\n\n\n User::latest()->get();<\/pre>\n\n\n\n
User::latest('last_login_at')->get();<\/pre>\n\n\n\n User::inRandomOrder()->get();<\/pre>\n\n\n\n
BettingOdds.php<\/code><\/p>\n\n\n\nclass BettingOdds extends Model\n{\n ...\n}\n\nconfig\/bettingOdds.php\n\nreturn [\n 'sports' => [\n 'soccer' => 'sport:1',\n 'tennis' => 'sport:2',\n 'basketball' => 'sport:3',\n ...\n ],\n];<\/pre>\n\n\n\nconfig(\u2019bettingOdds.sports.soccer\u2019);<\/pre>\n\n\n\n
BettingOdds.php<\/code><\/p>\n\n\n\nclass BettingOdds extends Model
{
protected static $sports = [
'soccer' => 'sport:1',
'tennis' => 'sport:2',
'basketball' => 'sport:3',
...
];
}<\/pre>\n\n\n\nBettingOdds::$sports['soccer'];<\/pre>\n\n\n\n
class BettingOdds extends Model
{
protected static $sports = [
'soccer' => 'sport:1',
'tennis' => 'sport:2',
'basketball' => 'sport:3',
...
];public function scopeSport($query, string $sport)
{
if (! isset(self::$sports[$sport])) {
return $query;
}
return $query->where('sport_id', self::$sports[$sport]);
}
}<\/pre>\n\n\n\nBettingOdds::sport('soccer')->get();\n<\/pre>\n\n\n\n$fruits = ['apple', 'pear', 'banana', 'strawberry'];foreach ($fruits as $fruit) {
echo 'I have '. $fruit;
}<\/pre>\n\n\n\n$fruits = collect($fruits);$fruits = $fruits->reject(function ($fruit) {
return $fruit === 'apple';
})->toArray();['pear', 'banana', 'strawberry']<\/pre>\n\n\n\n<\/pre>\n
![\"\u3053\u306e\u30a8\u30f3\u30c8\u30ea\u30fc\u3092\u306f\u3066\u306a\u30d6\u30c3\u30af\u30de\u30fc\u30af\u306b\u8ffd\u52a0\"](\"\/\/b.hatena.ne.jp\/images\/entry-button\/button-only@2x.png\")
<\/a>