mint/api-v13/app/Http/Controllers/CourseMemberController.php

<?php

namespace App\Http\Controllers;

use App\Http\Api\UserApi;
use App\Http\Resources\CourseMemberResource;
use App\Models\Course;
use App\Models\CourseMember;
use App\Models\UserInfo;
use App\Services\AuthService;
use Illuminate\Http\Request;
use Illuminate\Http\Response;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

class CourseMemberController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return Response
     */
    public function index(Request $request)
    {
        //
        $user = AuthService::current($request);
        if (! $user) {
            return $this->error(__('auth.failed', [403], 403));
        }
        // 判断当前用户是否有指定的 course 的权限
        $role = CourseMember::where('course_id', $request->input('id', $request->input('course')))
            ->where('user_id', $user['user_uid'])
            ->value('role');
        if (empty($role)) {
            return $this->error(__('auth.failed', [403], 403));
        }

        $result = false;
        $indexCol = [
            'id',
            'user_id',
            'course_id',
            'channel_id',
            'role',
            'editor_uid',
            'updated_at',
            'created_at',
        ];
        switch ($request->input('view')) {
            case 'course':
                // 获取 course 内所有 成员
                $table = CourseMember::where('course_id', $request->input('id'))
                    ->where('is_current', true);
                break;
            case 'timeline':
                /**
                 * 编辑时间线
                 */
                $table = CourseMember::where('user_id', $request->input('userId'));
                if ($request->input('timeline', 'current') === 'current') {
                    $table = $table->where('course_id', $request->input('course'));
                }

                break;
            default:
                return $this->error('无法识别的参数view', 400, 400);
                break;
        }
        if (! empty($request->input('role')) && $request->input('role') !== 'all') {
            $table = $table->where('role', $request->input('role'));
        }
        if (! empty($request->input('status'))) {
            $table = $table->whereIn('status', explode(',', $request->input('status')));
        }
        if (! empty($request->input('search'))) {
            $usersId = UserInfo::where('nickname', 'like', '%'.$request->input('search').'%')
                ->select('userid')
                ->get();
            $table = $table->whereIn('user_id', $usersId);
        }

        $count = $table->count();

        $table = $table->orderBy(
            $request->input('order', 'created_at'),
            $request->input('dir', 'asc')
        );

        $table = $table->skip($request->input('offset', 0))
            ->take($request->input('limit', 1000));

        $result = $table->get();

        // 获取当前用户角色
        $role = CourseMember::where('course_id', $request->input('id'))
            ->where('user_id', $user['user_uid'])
            ->where('is_current', true)
            ->value('role');

        return $this->ok(['rows' => CourseMemberResource::collection($result), 'role' => $role, 'count' => $count]);
    }

    /**
     * Store a newly created resource in storage.
     *
     * @return Response
     */
    public function store(Request $request)
    {
        //
        $user = AuthService::current($request);
        if (! $user) {
            return $this->error(__('auth.failed', [403], 403));
        }
        $validated = $request->validate([
            'user_id' => 'required',
            'course_id' => 'required',
            'role' => 'required',
            'status' => 'required',
        ]);
        // 查找重复的
        if ($validated['status'] !== 'invited') {
            if (CourseMember::where('course_id', $validated['course_id'])
                ->where('user_id', $validated['user_id'])
                ->exists()
            ) {
                return $this->error('member exists', [200], 200);
            }
        }

        if ($validated['status'] === 'invited') {
            $userId = $validated['user_id'];
        } else {
            $userId = $user['user_uid'];
        }

        CourseMember::where('course_id', $validated['course_id'])
            ->where('user_id', $userId)
            ->update(['is_current' => false]);

        $newMember = new CourseMember;
        $newMember->course_id = $validated['course_id'];
        $newMember->role = $validated['role'];
        $newMember->editor_uid = $user['user_uid'];
        $newMember->status = $validated['status'];
        $newMember->user_id = $userId;

        /**
         * 查找course 信息，根据加入方式设置状态
         * open : accepted
         * manual: progressing
         */
        $course = Course::find($validated['course_id']);
        if (! $course) {
            return $this->error('invalid course');
        }
        switch ($course->join) {
            case 'open': // 开放学习课程
                if (
                    $validated['status'] !== 'joined' &&
                    $validated['status'] !== 'invited'
                ) {
                    return $this->error('invalid course', [200], 200);
                }
                break;
            case 'manual': // 人工审核课程
                if (
                    $validated['status'] !== 'applied' &&
                    $validated['status'] !== 'invited'
                ) {
                    return $this->error('invalid course', [200], 200);
                }
                break;
        }
        $newMember->save();

        return $this->ok(new CourseMemberResource($newMember));
    }

    /**
     * Display the specified resource.
     *
     * @return Response
     */
    public function show(Request $request, string $courseId)
    {
        //
        $user = AuthService::current($request);
        if (! $user) {
            return $this->error(__('auth.failed'));
        }
        $userId = $user['user_uid'];
        if (! empty($request->input('user_uid'))) {
            $userId = $request->input('user_uid');
        }
        $member = CourseMember::where('course_id', $courseId)
            ->where('user_id', $userId)
            ->where('is_current', true)
            ->first();
        if ($member) {
            return $this->ok(new CourseMemberResource($member));
        } else {
            return $this->error('no result', 200, 200);
        }
    }

    /**
     * Update the specified resource in storage.
     *
     * @return Response
     */
    public function update(Request $request, CourseMember $courseMember)
    {
        /**
         * 保留原有记录
         * 增加一条新纪录
         * 原有记录变为历史记录
         */
        $user = AuthService::current($request);
        if (! $user) {
            return $this->error(__('auth.failed'));
        }

        $newMember = new CourseMember;
        $newMember->user_id = $courseMember->user_id;
        $newMember->course_id = $courseMember->course_id;
        $newMember->role = $courseMember->role;
        $newMember->status = $courseMember->status;
        $newMember->channel_id = $courseMember->channel_id;
        $newMember->editor_uid = $user['user_uid'];

        $courseMember->is_current = false;
        $courseMember->save();

        if ($request->has('channel_id')) {
            if ($newMember->user_id !== $user['user_uid']) {
                return $this->error(__('auth.failed'));
            }
            $newMember->channel_id = $request->input('channel_id');
        }
        if ($request->has('status')) {
            $newMember->status = $request->input('status');
        }
        $newMember->save();

        return $this->ok(new CourseMemberResource($newMember));
    }

    public function set_channel(Request $request)
    {
        //
        $user = AuthService::current($request);
        if (! $user) {
            return $this->error(__('auth.failed'));
        }

        if ($request->has('channel_id')) {
            $courseMember = CourseMember::where('course_id', $request->input('course_id'))
                ->where('user_id', $user['user_uid'])
                ->where('is_current', true)
                ->first();
            if ($courseMember) {
                $courseMember->channel_id = $request->input('channel_id');
                $courseMember->save();

                return $this->ok(new CourseMemberResource($courseMember));
            } else {
                return $this->error(__('auth.failed'));
            }
        } else {
            return $this->error(__('auth.failed'));
        }
    }

    /**
     * Remove the specified resource from storage.
     *
     * @return Response
     */
    public function destroy(Request $request, CourseMember $courseMember)
    {
        // 查看删除者有没有删除权限
        // 查询删除者的权限
        $user = AuthService::current($request);
        if (! $user) {
            return $this->error(__('auth.failed'));
        }

        $isOwner = Course::where('id', $courseMember->course_id)->where('studio_id', $user['user_uid'])->exists();
        if (! $isOwner) {
            $courseUser = CourseMember::where('course_id', $courseMember->course_id)
                ->where('user_id', $user['user_uid'])
                ->select('role')->first();
            // open 课程 可以删除自己

            if (! $courseUser) {
                // 被删除的不是自己
                if ($courseUser->role === 'student') {
                    // 普通成员没有删除权限
                    return $this->error(__('auth.failed'));
                }
            }
        }

        $delete = $courseMember->delete();

        return $this->ok($delete);
    }

    /**
     * 获取当前用户权限
     *
     * @return Response
     */
    public function curr(Request $request)
    {
        $user = AuthService::current($request);
        if (! $user) {
            return $this->error(__('auth.failed'));
        }
        $courseUser = CourseMember::where('course_id', $request->input('course_id'))
            ->where('user_id', $user['user_uid'])
            ->where('is_current', true)
            ->select(['role', 'channel_id'])->first();
        if ($courseUser) {
            return $this->ok($courseUser);
        } else {
            return $this->error('not member');
        }
    }

    public function export(Request $request)
    {

        $courseUser = CourseMember::where('course_id', $request->input('course_id'))
            ->where('is_current', true)
            ->get();

        $spreadsheet = new Spreadsheet;
        $activeWorksheet = $spreadsheet->getActiveSheet();
        $activeWorksheet->setCellValue('A1', 'nickname');
        $activeWorksheet->setCellValue('B1', 'username');
        $activeWorksheet->setCellValue('C1', 'role');
        $activeWorksheet->setCellValue('D1', 'status');
        $activeWorksheet->setCellValue('E1', 'created_at');

        $currLine = 2;
        foreach ($courseUser as $key => $row) {
            $user = UserApi::getByUuid($row->user_id);
            $activeWorksheet->setCellValue("A{$currLine}", $user['nickName']);
            $activeWorksheet->setCellValue("B{$currLine}", $user['userName']);
            $activeWorksheet->setCellValue("C{$currLine}", $row->role);
            $activeWorksheet->setCellValue("D{$currLine}", $row->status);
            $activeWorksheet->setCellValue("E{$currLine}", $row->created_at);
            $currLine++;
        }
        $writer = new Xlsx($spreadsheet);
        header('Content-Type: application/vnd.ms-excel');
        header('Content-Disposition: attachment; filename="course_member.xlsx"');
        $writer->save('php://output');
    }
}