public static function all() { $rows = DB::statement("SELECT * FROM " . self::$tablename); $users = new Collection(); foreach ($rows as $row) { $users->push(new User($row)); } return $users; }
/** * * @SWG\Api( * path="/activity_page", * description="约惠主页(有更新20160308)", * @SWG\Operation( * method="GET", summary="获得约惠主页内容", notes="获得约惠主页内容", * type="ActivityPage", * @SWG\ResponseMessage(code=0, message="成功"), * @SWG\Parameter( * name="user_id", * description="用户id", * paramType="query", * required=false, * allowMultiple=false, * type="integer", * defaultValue=-1 * ) * ) * ) */ public function index(Request $request) { $user_id = $request->input('user_id', -1); $response = new BaseResponse(); $ret = (object) null; $banners = Banner::where('banner_position', 1)->get(); $ret->banners = $banners; //分类 $activityClassification = ActivityClassification::all(); $ret->activityClassification = $activityClassification; //包邮 $freePost = FreePost::all(); $ret->freePost = $freePost; //爆品 $conversionGoods = ConversionGoods::all(); //$conversionGoods=$conversionGoods->toArray(); foreach ($conversionGoods as &$v) { $v->has_collection = 0; if ($user_id != -1) { $collection = Collection::where('user_id', $user_id)->where('type', 0)->where('item_id', $v->goods_id)->first(); if ($collection != null) { $v->has_collection = 1; } } } $ret->conversionGoods = $conversionGoods; $response->Data = $ret; return $response->toJson(); }
public function destroy($id) { $response = new BaseResponse(); $order = Collection::find($id); if ($order != null) { $order->delete(); } return $response->toJson(); }
public function getCollectCountAttribute() { return Collection::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="/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(); }
/** * * @SWG\Api( * path="/themes/{id}", * description="主题", * @SWG\Operation( * method="GET", summary="获得主题详情", notes="获得主题详情", * type="Themes", * @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 = Themes::find($id)->toArray(); $theme['has_collection'] = 0; if ($user_id != -1) { $c = Collection::where('user_id', $user_id)->where('type', 1)->where('item_id', $theme['id'])->first(); if ($c != null) { $theme['has_collection'] = 1; } } foreach ($theme['goods'] as &$v) { $v['has_collection'] = 0; if ($user_id != -1) { $collection = Collection::where('user_id', $user_id)->where('type', 0)->where('item_id', $v['id'])->first(); if ($collection != null) { $v['has_collection'] = 1; } } } $response->Data = $theme; return $response->toJson(); }
/** * * @SWG\Api( * path="/search", * description="搜索(新20160216)", * @SWG\Operation( * method="GET", summary="获得搜索列表", notes="获得搜索列表", * type="array", * @SWG\ResponseMessage(code=0, message="成功"), * @SWG\Parameter( * name="user_id", * description="用户id", * paramType="query", * required=false, * allowMultiple=false, * type="integer", * defaultValue=-1 * ),@SWG\Parameter( * name="device_token", * description="设备号", * paramType="query", * required=true, * allowMultiple=false, * type="integer" * ),@SWG\Parameter( * name="type", * description="搜索类型,0:商品,1:主题", * paramType="query", * required=false, * allowMultiple=false, * type="integer", * defaultValue=0 * ),@SWG\Parameter( * name="keywords", * description="搜索关键字", * paramType="query", * required=true, * allowMultiple=false, * type="string" * ), * @SWG\Parameter( * name="PageNum", * description="分页开始位置", * paramType="query", * required=false, * allowMultiple=false, * type="integer", * defaultValue=1 * ),@SWG\Parameter( * name="PerPage", * description="取得长度", * paramType="query", * required=false, * allowMultiple=false, * type="integer", * defaultValue=10 * ) * * ) * ) */ public function index(Request $request) { $start = $request->input('PageNum', 0); $length = $request->input('PerPage', 10); $type = $request->input('type', 0); //0--->商品 1--->主题 $keywords = $request->input('keywords', ''); $user_id = $request->input('user_id', -1); $device_token = $request->input('device_token'); $response = new BaseResponse(); $start = ($start - 1) * $length; if ($type == 0) { $goods = Goods::where('name', 'like', '%' . $keywords . '%')->orWhere('goods_description', 'like', '%' . $keywords . '%'); $total = $goods->count(); $goods = $goods->skip($start)->take($length)->orderBy('id', 'desc'); $rows = $goods->get()->toArray(); } else { $themes = Themes::where('title', 'like', '%' . $keywords . '%')->orWhere('subhead', 'like', '%' . $keywords . '%')->orWhere('themes_description', 'like', '%' . $keywords . '%'); $total = $themes->count(); $themes = $themes->skip($start)->take($length)->orderBy('id', 'desc'); $rows = $themes->get()->toArray(); } foreach ($rows as &$v) { $v['has_collection'] = 0; if ($user_id != -1 && $user_id != 0) { $collection = Collection::where('user_id', $user_id)->where('type', $type)->where('id', $v['id'])->first(); if ($collection != null) { $v['has_collection'] = 1; } } } //搜索记录 $searchRecords = new SearchRecords(); $searchRecords->user_id = $user_id; $searchRecords->device_token = $device_token; $searchRecords->keywords = $keywords; $searchRecords->save(); $response->rows = $rows; $response->total = $total; return $response->toJson(); }