Laravel 8：在不同控制器中实现基于群组ID的报告数据过滤与创建

// routes/web.php

use App\Http\Controllers\WeeklyreportController;
use Illuminate\Support\Facades\Route;

// 定义显示特定群组周报列表的路由
Route::get('/weeklyreports/{group_id}', [WeeklyreportController::class, 'index'])->name('weeklyreports.index');

// 定义为特定群组创建周报的路由
Route::get('/weeklyreports/{group_id}/create', [WeeklyreportController::class, 'create'])->name('weeklyreports.create');

// 定义存储特定群组周报的路由
Route::post('/weeklyreports/{group_id}', [WeeklyreportController::class, 'store'])->name('weeklyreports.store');

// 如果你还需要一个不带group_id的默认周报列表（例如管理员查看所有）
// Route::get('/weeklyreports', [WeeklyreportController::class, 'index_all'])->name('weeklyreports.index_all');

{{-- 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.index', $group->id) }}">查看周报</a>
        <a class="btn btn-success" href="{{ route('weeklyreports.create', $group->id) }}">创建周报</a>
    </div>
@endforeach

// app/Http/Controllers/WeeklyreportController.php

namespace App\Http\Controllers;

use App\Models\Weeklyreport;
use App\Models\Group; // 假设你的群组模型是 Group
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\DB;

class WeeklyreportController extends Controller
{
    /**
     * 显示特定群组的周报列表。
     *
     * @param  int  $groupId  从路由中获取的群组ID
     * @return \Illuminate\Http\Response
     */
    public function index(int $groupId)
    {
        // 验证群组是否存在，或根据业务逻辑进行权限检查
        $group = Group::findOrFail($groupId); // 确保群组存在

        // 根据 group_id 过滤周报数据
        // 假设 Weeklyreport 模型中有一个 'gpid' 字段用于存储群组ID
        $weeklyreports = Weeklyreport::latest()
            ->where('gpid', $groupId) // 利用路由参数过滤结果
            ->paginate(5);

        return view('weeklyreports.index', compact('weeklyreports', 'group')) // 将群组信息也传递给视图
            ->with('i', (request()->input('page', 1) - 1) * 5);
    }

    // ... 其他方法
}

// app/Http/Controllers/WeeklyreportController.php

class WeeklyreportController extends Controller
{
    // ... index 方法

    /**
     * 显示为特定群组创建新周报的表单。
     *
     * @param  int  $groupId  从路由中获取的群组ID
     * @return \Illuminate\Http\Response
     */
    public function create(int $groupId)
    {
        // 验证群组是否存在
        $group = Group::findOrFail($groupId);

        // 将 groupId 传递给视图，以便在表单中关联
        return view('weeklyreports.create', compact('groupId', 'group'));
    }

    // ... store 方法
}

{{-- resources/views/weeklyreports/create.blade.php --}}

<h1>为群组 "{{ $group->name }}" 创建周报</h1>

<form action="{{ route('weeklyreports.store', $groupId) }}" method="POST">
    @csrf
    {{-- 可以添加一个隐藏字段，但通常通过路由参数传递更直接 --}}
    {{-- <input type="hidden" name="group_id" value="{{ $groupId }}"> --}}

    <div class="form-group">
        <label for="name">报告名称:</label>
        <input type="text" name="name" class="form-control" required>
    </div>
    {{-- 其他表单字段 --}}
    <button type="submit" class="btn btn-primary">提交</button>
</form>

// app/Http/Controllers/WeeklyreportController.php

class WeeklyreportController extends Controller
{
    // ... index, create 方法

    /**
     * 将新创建的周报存储到数据库。
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  int  $groupId  从路由中获取的群组ID
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request, int $groupId)
    {
        // 验证群组是否存在
        $group = Group::findOrFail($groupId);

        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',
        ]);

        $weeklyreport = new Weeklyreport;

        $weeklyreport->name = $request->input('name');
        $weeklyreport->date = $request->input('date');
        $weeklyreport->time = $request->input('time');
        $weeklyreport->work_sub = $request->input('work_sub');
        $weeklyreport->work_under = $request->input('work_under');
        $weeklyreport->issue = $request->input('issue');
        $weeklyreport->topic = $request->input('topic');
        $weeklyreport->work_std = $request->input('work_std');
        $weeklyreport->next_date = $request->input('next_date');
        $weeklyreport->next_time = $request->input('next_time');

        // 关键一步：将当前群组ID赋值给周报的 gpid 字段
        $weeklyreport->gpid = $groupId;

        $weeklyreport->save();

        // 插入出勤记录（如果需要）
        if ($request->has('student_id')) {
            $student_id = [];
            foreach ($request->student_id as $id) {
                $student_id[] = [
                    'week_id' => $weeklyreport->id,
                    'student_id' => $id,
                ];
            }
            DB::table('attendance')->insert($student_id);
        }

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