Esempio n. 1
0
 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;
 }
Esempio n. 2
0
 /**
  *
  * @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();
 }
Esempio n. 3
0
 public function destroy($id)
 {
     $response = new BaseResponse();
     $order = Collection::find($id);
     if ($order != null) {
         $order->delete();
     }
     return $response->toJson();
 }
Esempio n. 4
0
 public function getCollectCountAttribute()
 {
     return Collection::where('type', 1)->where('item_id', $this->id)->count();
 }
Esempio n. 5
0
 /**
  *
  * @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();
 }
Esempio n. 6
0
 /**
  *
  * @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();
 }
Esempio n. 7
0
 /**
  *
  * @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();
 }
Esempio n. 8
0
 /**
  *
  * @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();
 }