class Post extends Model
{
    use HasFactory;

    protected $fillable = ['title','body','tags'];

    protected $casts = [
        'tags' => 'array,
    ];
}

$data = [
	'title' => '这是测试',
	'body' => '测试内容',
	'tags' => [
		'标签1',
		'标签2'
	]
];

Post::create($data);

class ChineseArray implements CastsAttributes
{
    public function get(Model $model, string $key, mixed $value, array $attributes): mixed
    {
        return json_decode($value);
    }

 
    public function set(Model $model, string $key, mixed $value, array $attributes): mixed
    {
		// https://www.php.net/manual/en/json.constants.php
		// JSON_UNESCAPED_UNICODE 设置不转义
        return json_encode($value, JSON_UNESCAPED_UNICODE);
    }
}

<?php

namespace App\Enums;

enum SocialNetwork: string
{
   case FACEBOOK = 'facebook';
   case TWITTER = 'twitter';
   case YOUTUBE = 'youtube';
}

<?php

namespace App\Models;

use App\Enums\SocialNetwork;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;

class SocialProfile extends Model
{
    use HasFactory;

    protected $casts = [
        'social_network' => SocialNetwork::class,
    ];
}

$profile = new SocialProfile()
$profile->social_network = SocialNetwork::FACEBOOK;
profile->save();

$profile = new SocialProfile()
$profile->social_network = SocialNetwork::FACEBOOK->value;
$pro

use App\Enums\SocialNetwork;
use Illuminate\Validation\Rules\Enum;

$request->validate([
    'social_network' => [new Enum(SocialNetwork::class)],
]);

<?php

namespace App\Enums;

enum SocialNetwork: string
{
   case FACEBOOK = 'facebook';
   case TWITTER = 'twitter';
   case YOUTUBE = 'youtube';

   public function domains(): array
   {
        return match ($this) {
            SocialNetwork::FACEBOOK => [
                'facebook.com',
                'fb.me',
                'fb.com',
            ],
            SocialNetwork::TWITTER => [
                'twitter.com',
                't.co',
            ],
            SocialNetwork::YOUTUBE => [
                'youtube.com',
                'youtu.be',
            ],
        };
   }
}

<?php

namespace App\Rules;

use App\Enums\SocialNetwork;
use Closure;
use Illuminate\Contracts\Validation\ValidationRule;
use Illuminate\Support\Str;

class SocialNetworkRule implements ValidationRule
{
    /**
     * Get the allowed domains from the SocialNetwork enum
     * and ensure at least one matches the value.
     *
     * @param  \Closure(string): \Illuminate\Translation\PotentiallyTranslatedString  $fail
     */
    public function validate(string $attribute, mixed $value, Closure $fail): void
    {
        $allowedDomains = array_map(
            fn (SocialNetwork $socialNetwork) => $socialNetwork->domains(),
            SocialNetwork::cases()
        );

        $domains = collect($allowedDomains)
            ->flatten()
            ->all();

        if (! Str::contains($value, $domains)) {
            $fail('The :attribute field must be a valid social network.');
        }
    }
}

use Illuminate\Support\Str;

public function getNetwork(string $link): string|null
{
    foreach (SocialNetwork::cases() as $case) {
        if (Str::contains($link, $case->domains())) {
            return $case->value;
        }
    }

    return null;
}

$limit = 5;

$users = User::query()
    ->addSelect([
        'highest_rated_comment_ids' => Comment::query()
            ->selectRaw("SUBSTRING_INDEX(GROUP_CONCAT(comments.id order by rating desc, ','), ',', {$limit})")
            ->whereColumn('comments.user_id', 'users.id')
            ->limit($limit)
    ])
    ->get();

$highestRatedCommentIds = $users->pluck('highest_rated_comment_ids')
    ->map(function (string $commentIds) {
        return explode(',', $commentIds);
    })
    ->flatten();

// $highestRatedCommentIds = [27, 4, 39, 21, 107, ...];

$highestRatedComments = $this->getQueryBuilder()
    ->whereIn('id', $highestRatedCommentIds)
    ->get();

foreach ($users as $user) {
    // Turn the highest_rated_comment_ids property from the user into an array
    $userHighestRatedCommentIds = explode(',', $user->highest_rated_comment_ids);

    // Pull the comments that relate to this user out of the collection of all comments
    // sortBy ensures they are added in the same order as highest_rated_comment_ids i.e. descending rating order
    $userHighestRatedComments = $highestRatedComments
        ->whereIn('id', $userHighestRatedCommentIds)
        ->sortBy(fn (Comment $comment) => array_flip($userHighestRatedCommentIds)[$comment->id])
        ->values();

    // Add the comments to the user
    $user->setRelation('highest_rated_comments', $userHighestRatedComments);
}

<?php

namespace App\Console\Commands;

use Illuminate\Console\Command;
use App\Models\User;

class CreateUserCommand extends Command
{
    protected $signature = 'create:user {username?} {email?} {password?} {--admin : Create an admin user}';

    protected $description = 'Create a new user';

    public function handle()
    {
        $username = $this->argument('username') ?? $this->ask('Enter username:');
        $email = $this->argument('email') ?? $this->ask('Enter email:');
        $password = $this->argument('password') ?? $this->secret('Enter password:');
        $isAdmin = $this->option('admin');

        $user = new User();
        $user->name = $username;
        $user->email = $email;
        $user->password = bcrypt($password);
        $user->is_admin = $isAdmin;
        $user->save();

        $this->info('User created successfully!');
    }
}

$products = Product::find(1);

$products = Product::find([1, 2, 3]);

$products = Product::query()
    ->where('category_id', 1)
    ->where('manufacturer_id', 2)
    ->get();

$products = Product::query()
    ->where([
        'category_id' => 1,
        'manufacturer_id' => 2,
    ])
    ->get();

$products = Product::query()
    ->where([
        'category_id' => 1,
        ['stock_left', '>', 100]
    ])
    ->get();

$products = Product::query()
    ->where(function($query){
        $query->where('category_id', 1)
              ->where('stock_left', '>', 100);
    })
    ->get();

session()->put('cart', 'Cart information');
session()->put('cart_total', 'Cart total');

session()->put([
    'cart' => 'Cart information',
    'cart_total' => 'Cart total'
]);

session()->has('cart');

session()->has(['cart', 'cart_total']);

Cache::put('cart', 'Cart information', 60);
Cache::put('cart_total', 'Cart total', 60);

Cache::put([
    'cart' => 'Cart information',
    'cart_total' => 'Cart total'
], 60);

Schema::table('products', function (Blueprint $table) {
    $table->dropColumn('name');
    $table->dropColumn('description');
    $table->dropColumn('price');
});

Schema::table('products', function (Blueprint $table) {
    $table->dropColumn(['name', 'description', 'price']);
});

Gate::has('edit-post')

Gate::has(['edit-post', 'delete-post'])

App::environment();

App::environment('local');