public function getCommentsCountAttribute() { return UserComment::where('type', 1)->where('item_id', $this->id)->count(); }
/** * * @SWG\Api( * path="/goods/{id}", * description="商品", * @SWG\Operation( * method="GET", summary="获得商品详情", notes="获得商品详情", * type="Goods", * @SWG\ResponseMessage(code=0, message="成功"), * @SWG\Parameter( * name="id", * description="商品id", * paramType="path", * required=true, * allowMultiple=false, * type="integer", * ), * @SWG\Parameter( * name="user_id", * description="用户id", * paramType="query", * required=false, * allowMultiple=false, * type="integer", * defaultValue=-1 * ) * * ) * ) */ public function show(Request $request, $id) { $user_id = $request->input('user_id', -1); $response = new BaseResponse(); $theme = Goods::find($id); $theme['has_collection'] = 0; if ($user_id != -1) { $c = Collection::where('user_id', $user_id)->where('type', 0)->where('item_id', $theme['id'])->first(); if ($c != null) { $theme['has_collection'] = 1; } } //var_dump($theme);exit; $comments = UserComment::select('user_comments.*', 'user_infos.nick_name', 'user_infos.head_icon')->leftJoin('user_infos', 'user_infos.id', '=', 'user_comments.user_id')->where('user_comments.type', 0)->where('user_comments.item_id', $theme['id']); $rows = $comments->skip(0)->take(10)->orderBy('id', 'desc')->get()->toArray(); foreach ($rows as &$v) { //$v[''] $sum = Order::select(DB::raw('SUM(total_fee) as total_pay'))->where('user_id', $v['user_id'])->where('status', 4)->first()->toArray(); if ($sum == null || $sum['total_pay'] == null) { $sum = 0; } else { $sum = $sum['total_pay']; } $level = UserLevel::where('sum_lowest', '<=', $sum)->where('sum_highest', '>', $sum)->first()->toArray(); //var_dump($level);exit; $v['level'] = $level['img']; } $theme['comments'] = $rows; $response->Data = $theme; return $response->toJson(); }
/** * * @SWG\Api( * path="/comments/{id}", * @SWG\Operation( * method="DELETE", summary="删除评论", notes="删除评论", * @SWG\ResponseMessage(code=0, message="成功"), * @SWG\Parameter( * name="id", * description="评论id", * paramType="path", * required=true, * type="integer" * ) * ) * ) */ public function destroy($id) { $response = new BaseResponse(); $comment = UserComment::find($id); if ($comment != null) { $comment->delete(); } return $response->toJson(); }
/** * * @SWG\Api( * path="/home/{id}", * description="获取首页项详情", * @SWG\Operation( * method="GET", summary="获得主题详情", notes="获得主题详情", * type="Home", * @SWG\ResponseMessage(code=0, message="成功"), * @SWG\Parameter( * name="id", * description="id", * paramType="path", * required=true, * allowMultiple=false, * type="integer", * ),@SWG\Parameter( * name="device_token", * description="设备号", * paramType="query", * required=true, * allowMultiple=false, * type="integer" * ),@SWG\Parameter( * name="user_id", * description="用户id", * paramType="query", * required=false, * allowMultiple=false, * type="integer", * defaultValue=-1 * ), * * ) * ) */ public function show(Request $request, $id) { // $response = new BaseResponse(); $user_id = $request->input('user_id', -1); $device_token = $request->input('device_token', ''); $home = Home::find($id); if ($home == null) { $response->Code = BaseResponse::CODE_ERROR_BUSINESS; $response->Message = '数据不存在'; return $response->toJson(); } if ($device_token != '') { $readRecords = new ReadRecords(); $readRecords->device_token = $device_token; $readRecords->home_id = $id; $readRecords->save(); } $home = $home->toArray(); if ($home['type'] == 1) { $home['has_collection'] = 0; if ($user_id != -1) { $collection = Collection::where('user_id', $user_id)->where('type', 1)->where('item_id', $home['item_id'])->first(); if ($collection != null) { $home['has_collection'] = 1; } } $comments = UserComment::select('user_comments.*', 'user_infos.nick_name', 'user_infos.head_icon')->leftJoin('user_infos', 'user_infos.id', '=', 'user_comments.user_id')->where('user_comments.type', 1)->where('user_comments.item_id', $home['item']['id']); $rows = $comments->skip(0)->take(10)->orderBy('id', 'desc')->get()->toArray(); foreach ($rows as &$v) { //$v[''] $sum = Order::select(DB::raw('SUM(total_fee) as total_pay'))->where('user_id', $v['user_id'])->where('status', 4)->first()->toArray(); if ($sum == null || $sum['total_pay'] == null) { $sum = 0; } else { $sum = $sum['total_pay']; } $level = UserLevel::where('sum_lowest', '<=', $sum)->where('sum_highest', '>', $sum)->first()->toArray(); //var_dump($level);exit; $v['level'] = $level['name']; } $home['comments'] = $rows; } $response->Data = $home; return $response->toJson(); }