Laravel中通过路由参数实现控制器间数据过滤与创建

// routes/web.php

use App\Http\Controllers\WeeklyreportController;

// 定义一个路由，用于显示特定组的周报列表
// {group_id} 是一个路由参数，它将匹配URL中的任何值，并作为参数传递给控制器方法
Route::get('/weeklyreports/{group_id}', [WeeklyreportController::class, 'index'])->name('weeklyreports.group.index');

// 假设创建周报的路由也需要关联组ID
// Route::get('/weeklyreports/{group}/create', [WeeklyreportController::class, 'create'])->name('weeklyreports.create');
// Route::post('/weeklyreports/{group}', [WeeklyreportController::class, 'store'])->name('weeklyreports.store');

// 如果您希望创建一个独立的资源路由，并允许在创建时指定组ID，可以这样定义：
// Route::resource('weeklyreports', WeeklyreportController::class);
// 并在 create 和 store 方法中处理 group_id。

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

@foreach ($groups as $group)
    <div>
        <span>{{ $group->name }}</span>
        {{-- 使用 route() 辅助函数生成带参数的URL，推荐方式 --}}
        <a class="btn btn-primary" href="{{ route('weeklyreports.group.index', ['group_id' => $group->id]) }}">
            Weekly Report
        </a>
        {{-- 或者使用 URL::to()，但 route() 更具可维护性 --}}
        {{-- <a class="btn btn-primary" href="{{ URL::to('weeklyreports', $group->id) }}">Weekly Report</a> --}}
    </div>
@endforeach

// app/Http/Controllers/WeeklyreportController.php

namespace App\Http\Controllers;

use App\Models\Weeklyreport;
use Illuminate\Http\Request;
use App\Models\Group; // 假设您有 Group 模型

class WeeklyreportController extends Controller
{
    /**
     * 显示特定组的周报列表。
     *
     * @param int $groupId 从路由中接收的组ID
     * @return \Illuminate\Http\Response
     */
    public function index(int $groupId)
    {
        // 根据传入的 groupId 过滤周报
        $weeklyreports = Weeklyreport::latest()
            ->where('gpid', $groupId) // 假设 Weeklyreport 模型中关联组ID的字段名为 'gpid'
            ->paginate(5);

        return view('weeklyreports.index', compact('weeklyreports', 'groupId')) // 将 groupId 传递给视图，以便创建新报告时使用
            ->with('i', (request()->input('page', 1) - 1) * 5);
    }

    // ... 其他方法
}

// routes/web.php

// 使用路由模型绑定，{group} 会自动注入 Group 模型的实例
Route::get('/weeklyreports/{group}/create', [WeeklyreportController::class, 'create'])->name('weeklyreports.create');
Route::post('/weeklyreports/{group}', [WeeklyreportController::class, 'store'])->name('weeklyreports.store');

// 如果您坚持使用 group_id 而不是 Group 模型实例，可以这样：
// Route::get('/weeklyreports/{group_id}/create', [WeeklyreportController::class, 'create'])->name('weeklyreports.create');
// Route::post('/weeklyreports/{group_id}', [WeeklyreportController::class, 'store'])->name('weeklyreports.store');

{{-- resources/views/weeklyreports/index.blade.php (示例) --}}

{{-- 在周报列表页，添加创建按钮 --}}
<a class="btn btn-success" href="{{ route('weeklyreports.create', ['group' => $groupId]) }}">
    Create New Weekly Report
</a>

{{-- ... 显示周报列表的代码 ... --}}

// app/Http/Controllers/WeeklyreportController.php

// ...

    /**
     * 显示创建新周报的表单。
     *
     * @param \App\Models\Group $group 通过路由模型绑定注入的 Group 实例
     * @return \Illuminate\Http\Response
     */
    public function create(Group $group)
    {
        // 将 group 实例或其ID传递给视图，以便在表单中预填充或作为隐藏字段
        return view('weeklyreports.create', compact('group'));
    }

// ...

// app/Http/Controllers/WeeklyreportController.php

// ...

    /**
     * 存储新创建的周报。
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  \App\Models\Group  $group 通过路由模型绑定注入的 Group 实例
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request, Group $group)
    {
        request()->validate([
            'name' => 'required',
            'date' => 'required',
            'time' => 'required',
            'work_sub' => 'required',
            'work_under' => 'required',
            'issue' => 'required',
            'topic' => 'required',
            'work_std' => 'required',
            'next_date' => 'required',
            'next_time' => 'required',
        ]);

        $data = $request->all();
        $weeklyreport = new Weeklyreport;

        $weeklyreport->name = $data['name'];
        $weeklyreport->date = $data['date'];
        $weeklyreport->time = $data['time'];
        $weeklyreport->work_sub = $data['work_sub'];
        $weeklyreport->work_under = $data['work_under'];
        $weeklyreport->issue = $data['issue'];
        $weeklyreport->topic = $data['topic'];
        $weeklyreport->work_std = $data['work_std'];
        $weeklyreport->next_date = $data['next_date'];
        $weeklyreport->next_time = $data['next_time'];

        // 关键一步：将组ID关联到周报
        $weeklyreport->gpid = $group->id; // 使用路由模型绑定获取的 Group 实例的 ID

        $weeklyreport->save();

        // 处理 attendance 逻辑 (保持不变)
        $rr = \DB::table('weeklyreports')->orderBy('created_at', 'desc')->first();
        $student_id = [];
        foreach ($request->student_id as $key => $id) {
            $student_id[] = [
                'week_id' => $weeklyreport->id,
                'student_id' => $id,
            ];
        }
        \DB::table('attendance')->insert($student_id);

        return redirect()->route('weeklyreports.group.index', ['group_id' => $group->id]) // 重定向回特定组的周报列表
                        ->with('success', 'Weeklyreport created successfully.');
    }

// ...