Laravel 8 中按组ID筛选周报并实现关联创建教程

// web.php
use App\Http\Controllers\WeeklyreportController;

// 定义带 group_id 参数的周报索引页路由
Route::get('/weeklyreports/{group_id}', [WeeklyreportController::class, 'index'])->name('weeklyreports.index_by_group');

// 定义带 group_id 参数的周报创建页路由
Route::get('/weeklyreports/{group_id}/create', [WeeklyreportController::class, 'create'])->name('weeklyreports.create_for_group');

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

// 如果您还有不带 group_id 的全局周报索引页，可以保留或修改
// Route::get('/weeklyreports', [WeeklyreportController::class, 'index'])->name('weeklyreports.index');

{{-- groups/index.blade.php 或 supervisor/index.blade.php --}}
<a class="btn btn-primary" href="{{ route('weeklyreports.index_by_group', ['group_id' => $group->id]) }}">Weekly Report</a>
{{-- 假设 $group 是当前循环中的组对象，并且它有 id 属性 --}}

// app/Http/Controllers/WeeklyreportController.php
<?php

namespace App\Http\Controllers;

use App\Models\Weeklyreport; // 确保引入 Weeklyreport 模型
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\DB;
use App\Models\Group; // 假设您有 Group 模型

class WeeklyreportController extends Controller
{
    /**
     * 显示特定组的周报列表。
     *
     * @param  int  $groupId
     * @return \Illuminate\Http\Response
     */
    public function index(int $groupId)
    {
        // 过滤周报，只显示属于指定 group_id 的记录
        $weeklyreports = Weeklyreport::latest()
            ->where('gpid', $groupId) // 假设 'gpid' 是 Weeklyreport 模型中存储组ID的列名
            ->paginate(5);

        // 您可能还需要获取组的信息，例如组名，以便在视图中显示
        $group = Group::find($groupId); // 假设您有 Group 模型

        return view('weeklyreports.index', compact('weeklyreports', 'groupId', 'group'))
            ->with('i', (request()->input('page', 1) - 1) * 5);
    }

    // ... 其他方法
}

// app/Http/Controllers/WeeklyreportController.php
    /**
     * 显示为特定组创建新周报的表单。
     *
     * @param  int  $groupId
     * @return \Illuminate\Http\Response
     */
    public function create(int $groupId)
    {
        // 您可能需要验证 $groupId 是否有效，例如 Group::findOrFail($groupId);
        $group = Group::findOrFail($groupId); // 获取组信息

        return view('weeklyreports.create', compact('groupId', 'group'));
    }

{{-- weeklyreports/create.blade.php --}}
<form action="{{ route('weeklyreports.store_for_group', ['group_id' => $groupId]) }}" method="POST">
    @csrf

    {{-- 隐藏字段，确保 group_id 随表单提交 --}}
    <input type="hidden" name="group_id" value="{{ $groupId }}">

    {{-- 其他表单字段，例如 name, date, time 等 --}}
    <div class="form-group">
        <label for="name">报告名称:</label>
        <input type="text" name="name" class="form-control" required>
    </div>
    {{-- ... 其他输入字段 ... --}}

    <button type="submit" class="btn btn-success">创建周报</button>
</form>

// app/Http/Controllers/WeeklyreportController.php
    /**
     * 在存储中创建一个新的周报资源。
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  int  $groupId
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request, int $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',
            // 确保验证 group_id，尽管它是从路由参数传入
            'group_id' => 'required|integer|exists:groups,id',
        ]);

        $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');

        // 将周报与传入的 group_id 关联
        $weeklyreport->gpid = $groupId; // 使用路由参数中的 group_id

        $weeklyreport->save();

        // 处理 attendance 插入逻辑
        if ($request->has('student_id') && is_array($request->student_id)) {
            $student_attendance_data = [];
            foreach ($request->student_id as $studentId) {
                $student_attendance_data[] = [
                    'week_id' => $weeklyreport->id,
                    'student_id' => $studentId,
                    'created_at' => now(),
                    'updated_at' => now(),
                ];
            }
            DB::table('attendance')->insert($student_attendance_data);
        }

        return redirect()->route('weeklyreports.index_by_group', ['group_id' => $groupId])
                        ->with('success', 'Weeklyreport created successfully.');
    }
}