get('view')) { case 'studio': # 获取studio内所有channel $user = \App\Http\Api\AuthApi::current($request); if($user){ //判断当前用户是否有指定的studio的权限 if($user['user_uid'] === \App\Http\Api\StudioApi::getIdByName($request->get('name'))){ $table = Channel::select($indexCol)->where('owner_uid', $user["user_uid"]); }else{ return $this->error(__('auth.failed')); } }else{ return $this->error(__('auth.failed')); } break; } //处理搜索 if(isset($_GET["search"])){ $table = $table->where('title', 'like', $_GET["search"]."%"); } //获取记录总条数 $count = $table->count(); //处理排序 if(isset($_GET["order"]) && isset($_GET["dir"])){ $table = $table->orderBy($_GET["order"],$_GET["dir"]); }else{ //默认排序 $table = $table->orderBy('updated_at','desc'); } //处理分页 if($request->has("limit")){ if($request->has("offset")){ $offset = $request->get("offset"); }else{ $offset = 0; } $table = $table->skip($offset)->take($request->get("limit")); } //获取数据 $result = $table->get(); if($result){ foreach ($result as $key => $value) { # 获取studio信息 $studio = $userinfo->getName($value->owner_uid); $value->studio = [ 'id'=>$value->owner_uid, 'nickName'=>$studio['nickname'], 'studioName'=>$studio['username'], 'avastar'=>'', 'owner' => [ 'id'=>$value->owner_uid, 'nickName'=>$studio['nickname'], 'userName'=>$studio['username'], 'avastar'=>'', ] ]; } return $this->ok(["rows"=>$result,"count"=>$count]); }else{ return $this->error("没有查询到数据"); } } /** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(Request $request) { // $user = \App\Http\Api\AuthApi::current($request); if($user){ //判断当前用户是否有指定的studio的权限 if($user['user_uid'] === \App\Http\Api\StudioApi::getIdByName($request->get('studio'))){ //查询是否重复 if(Channel::where('name',$request->get('name'))->where('owner_uid',$user['user_uid'])->exists()){ return $this->error(__('validation.exists',['name'])); }else{ $channel = new Channel; $channel->id = app('snowflake')->id(); $channel->name = $request->get('name'); $channel->owner_uid = $user['user_uid']; $channel->type = $request->get('type'); $channel->lang = $request->get('lang'); $channel->editor_id = $user['user_id']; $channel->create_time = time()*1000; $channel->modify_time = time()*1000; $channel->save(); return $this->ok($channel); } }else{ return $this->error(__('auth.failed')); } }else{ return $this->error(__('auth.failed')); } } /** * Display the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function show($id) { // $indexCol = ['uid','name','summary','type','owner_uid','lang','status','updated_at','created_at']; $channel = Channel::where("uid",$id)->select($indexCol)->first(); $userinfo = new \UserInfo(); $studio = $userinfo->getName($channel->owner_uid); $channel->owner_info = $studio; $channel->studio = [ 'id'=>$channel->owner_uid, 'nickName'=>$studio['nickname'], 'studioName'=>$studio['username'], 'avastar'=>'', 'owner' => [ 'id'=>$channel->owner_uid, 'nickName'=>$studio['nickname'], 'userName'=>$studio['username'], 'avastar'=>'', ] ]; return $this->ok($channel); } /** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param \App\Models\Channel $channel * @return \Illuminate\Http\Response */ public function update(Request $request, Channel $channel) { //鉴权 $user = AuthApi::current($request); if($user && $channel->owner_uid === $user["user_uid"]){ $channel->name = $request->get('name'); $channel->type = $request->get('type'); $channel->summary = $request->get('summary'); $channel->lang = $request->get('lang'); $channel->status = $request->get('status'); $channel->save(); return $this->ok($channel); }else{ //非所有者鉴权失败 //TODO 判断是否为协作 return $this->error(__('auth.failed')); } } /** * Remove the specified resource from storage. * * @param \App\Models\Channel $channel * @return \Illuminate\Http\Response */ public function destroy(Channel $channel) { // } }