mint/api-v8/app/Http/Controllers/ProjectController.php

<?php

namespace App\Http\Controllers;

use App\Models\Project;
use Illuminate\Http\Request;
use App\Http\Api\AuthApi;
use App\Http\Api\StudioApi;
use App\Http\Resources\ProjectResource;
use Illuminate\Support\Str;
use Illuminate\Support\Facades\Log;

class ProjectController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index(Request $request)
    {
        $user = AuthApi::current($request);
        if (!$user) {
            Log::error('notification auth failed {request}', ['request' => $request]);
            return $this->error(__('auth.failed'), 401, 401);
        }
        if ($request->has('studio')) {
            $studioId = StudioApi::getIdByName($request->get('studio'));
        } else {
            $studioId = $user['user_uid'];
        }

        switch ($request->get('view')) {
            case 'studio':
                $table = Project::where('owner_id', $studioId)
                    ->whereNull('parent_id')
                    ->where('type', $request->get('type', 'instance'));
                break;
            case 'project-tree':
                $table = Project::where('uid', $request->get('project_id'))
                    ->orWhereJsonContains('path', $request->get('project_id'));
                break;
            case 'community':
                $table = Project::where('owner_id', '<>', $studioId)
                    ->whereNull('parent_id')
                    ->where('privacy', 'public')
                    ->where('type', $request->get('type', 'instance'));
                break;
            default:
                return $this->error('view', 200, 200);
                break;
        }

        if ($request->has('keyword')) {
            $table = $table->where('title', 'like', '%' . $request->get('keyword') . '%');
        }
        if ($request->has('status')) {
            $table = $table->whereIn('status', explode(',', $request->get('status')));
        }
        $count = $table->count();

        $sql = $table->toSql();
        Log::debug('sql', ['sql' => $sql]);

        $table = $table->orderBy($request->get('order', 'id'), $request->get('dir', 'asc'));

        $table = $table->skip($request->get("offset", 0))
            ->take($request->get('limit', 10000));

        $result = $table->get();

        return $this->ok(
            [
                "rows" => ProjectResource::collection($result),
                "count" => $count,
            ]
        );
    }

    public static function canEdit($user_uid, $studio_uid)
    {
        return $user_uid == $studio_uid;
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
        //
        $user = AuthApi::current($request);
        if (!$user) {
            return $this->error(__('auth.failed'), 401, 401);
        }
        $studioId = StudioApi::getIdByName($request->get('studio_name'));
        if (!self::canEdit($user['user_uid'], $studioId)) {
            return $this->error(__('auth.failed'), 403, 403);
        }
        $new = Project::firstOrNew(['uid' => $request->get('id')]);
        if (Str::isUuid($request->get('id'))) {
            $new->uid = $request->get('id');
        } else {
            $new->uid =  Str::uuid();
        }
        $new->title = $request->get('title');
        $new->description = $request->get('description');
        $new->parent_id = $request->get('parent_id');
        $new->editor_id = $user['user_uid'];
        $new->owner_id = $studioId;
        $new->type = $request->get('type', 'instance');


        if (Str::isUuid($request->get('parent_id'))) {
            $parentPath = Project::where('uid', $request->get('parent_id'))->value('path');
            $parentPath = json_decode($parentPath);
            if (!is_array($parentPath)) {
                $parentPath = array();
            }
            array_push($parentPath, $new->parent_id);
            $new->path = json_encode($parentPath, JSON_UNESCAPED_UNICODE);
        }
        $new->save();

        return $this->ok(new ProjectResource($new));
    }

    /**
     * Display the specified resource.
     *
     * @param  \App\Models\Project  $project
     * @return \Illuminate\Http\Response
     */
    public function show(Project $project)
    {
        //
        return $this->ok(new ProjectResource($project));
    }


    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  \App\Models\Project  $project
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, Project $project)
    {
        //
        $user = AuthApi::current($request);
        if (!$user) {
            return $this->error(__('auth.failed'), 401, 401);
        }
        if (!self::canEdit($user['user_uid'], $project->owner_id)) {
            return $this->error(__('auth.failed'), 403, 403);
        }

        $project->title = $request->get('title');
        $project->description = $request->get('description');
        $project->parent_id = $request->get('parent_id');
        $project->editor_id = $user['user_uid'];
        $project->privacy = $request->get('privacy');


        if (Str::isUuid($request->get('parent_id'))) {
            $parentPath = Project::where('uid', $request->get('parent_id'))->value('path');
            $parentPath = json_decode($parentPath);
            if (!is_array($parentPath)) {
                $parentPath = array();
            }
            array_push($parentPath, $project->parent_id);
            $project->path = json_encode($parentPath, JSON_UNESCAPED_UNICODE);
        }
        $project->save();

        return $this->ok(new ProjectResource($project));
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  \App\Models\Project  $project
     * @return \Illuminate\Http\Response
     */
    public function destroy(Project $project)
    {
        //
    }
}