在 Laravel 中向文本列存储的数组追加数据

// database/migrations/xxxx_xx_xx_create_recruitments_table.php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateRecruitmentsTable extends Migration
{
    public function up()
    {
        Schema::create('recruitments', function (Blueprint $table) {
            $table->id();
            $table->string('title');
            $table->decimal('salary', 10, 2);
            $table->date('term_start');
            $table->date('term_end');
            $table->date('deadline');
            $table->longText('details');
            $table->string('status');
            $table->text('applicants')->nullable(); // 使用 text 类型，并允许为空
            $table->timestamps();
        });
    }

    public function down()
    {
        Schema::dropIfExists('recruitments');
    }
}

// app/Models/Recruitment.php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;

class Recruitment extends Model
{
    use HasFactory;

    protected $fillable = [
        'title',
        'salary',
        'term_start',
        'term_end',
        'deadline',
        'details',
        'status',
        'applicants',
    ];

    protected $casts = [
        'applicants' => 'array' // 将 applicants 字段转换为数组类型
    ];

    public function user(){
        return $this->belongsTo(User::class); // 假设 Recruitment 属于某个 User
    }
}

public function addApplicant($id, Request $reqst){
    $job = Recruitment::find($id);
    $user[] = $reqst->user_id; // 这里创建了一个新的数组，只包含当前 user_id
    $job->applicants = $user;  // 将这个新数组赋值给 applicants，覆盖了原有数据
    $job->save();
    return redirect()->back();
}

// app/Http/Controllers/RecruitmentController.php

use App\Models\Recruitment;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth; // 引入 Auth Facade

class RecruitmentController extends Controller
{
    public function addApplicant($id, Request $reqst)
    {
        $job = Recruitment::find($id);

        if (!$job) {
            return redirect()->back()->with('error', '职位不存在。');
        }

        // 获取当前的申请者数组。如果 applicants 字段为 null，则初始化为空数组。
        // 由于模型中设置了 $casts，这里 $job->applicants 会自动是 PHP 数组或 null。
        $applicants = $job->applicants ?? [];

        // 获取当前用户的 ID
        $newUserId = (int) $reqst->user_id; // 确保 ID 为整数类型

        // 检查用户是否已经申请过，避免重复添加
        if (in_array($newUserId, $applicants)) {
            return redirect()->back()->with('info', '您已申请过该职位，请勿重复申请。');
        }

        // 将新的用户 ID 追加到申请者数组中
        $applicants[] = $newUserId;

        // 将更新后的数组赋值回模型属性
        // Laravel 会在保存时自动将此 PHP 数组序列化为 JSON 字符串
        $job->applicants = $applicants;

        // 保存模型到数据库
        $job->save();

        return redirect()->back()->with('success', '申请成功！');
    }
}

{{-- resources/views/jobs/show.blade.php (示例) --}}

<div class="container">
    <div class="row">
        <div class="card col-sm-12 py-3">
            <div class="card-header border d-flex justify-content-between align-items-center">
                <h3 class="w-75">{{ $job->title }}</h3>
                <div class="w-25">
                    <p class="my-0 my-0">Created at: <span class="text-info">{{ $job->created_at }}</span></p>
                    <p class="my-0 my-0">Last updated at: <span class="text-primary">{{ $job->updated_at }}</span></p>
                </div>
            </div>
            <div class="card-body">
                {{-- display job details here --}}

                <form action="{{ route('add-applicant', ['id' => $job->id ]) }}" method="POST" class="col-sm-12 d-flex justify-content-center align-items-center">
                    @csrf
                    {{-- 确保 user_id 字段的值是当前认证用户的 ID --}}
                    <input type="text" name="user_id" id="user_id" value="{{ Auth::user()->id }}" hidden>
                    <button type="submit" class="btn btn-success w-25">Apply</button>
                </form>
            </div>
        </div>
    </div>
</div>

// routes/web.php

use App\Http\Controllers\RecruitmentController; // 引入控制器

Route::post('/job/{id}/apply', [RecruitmentController::class, 'addApplicant'])->name('add-applicant');