示例#1
0
 public function selectByWord()
 {
     $word = Input::get('word');
     if (!isset($word)) {
         return Response::json(array('errCode' => 1, 'message' => '请输入关键字以搜索商品!'));
     }
     //TomLingham/Laravel-Searchy插件——模糊搜索
     $gifts = Gift::where('title', 'like', '%' . $word . '%')->orderBy('created_at', 'desc')->get();
     $per_page = Input::get('per_page');
     $page = Input::get('page');
     //筛选没有结果返回全部礼品
     if (count($gifts) == 0) {
         $gifts = DB::table('gifts')->orderBy('created_at', 'desc')->get();
         if (count($gifts)) {
             return Response::json(array('errCode' => 2, 'message' => '数据库没有数据'));
         }
         $total = $per_page == ceil(count($gifts) / $per_page);
         foreach ($gifts as $gift) {
             $url = GiftPoster::where('gift_id', '=', $gift->id)->first()->url;
             $gift->img = StaitcController::imageWH($url);
         }
         $gifts = StaitcController::page($per_page, $page, $gifts);
         return Response::json(array('errCode' => 0, 'message' => '返回根据关键字筛选的商品', 'gifts' => $gifts));
     }
     foreach ($gifts as $gift) {
         $url = GiftPoster::where('gift_id', '=', $gift->id)->first()->url;
         $gift->img = StaitcController::imageWH($url);
     }
     $total = ceil(count($gifts) / $per_page);
     $gifts = StaitcController::page($per_page, $page, $gifts);
     return Response::json(array('errCode' => 0, 'message' => '返回根据关键字筛选的商品', 'gifts' => $gifts));
 }
示例#2
0
 public function insertData()
 {
     $gifts = json_decode(file_get_contents(app_path() . '/storage/gifts.txt'));
     $topics = json_decode(file_get_contents(app_path() . '/storage/topics.txt'));
     $gift_posters = json_decode(file_get_contents(app_path() . '/storage/gift_posters.txt'));
     $gift_photo_intros = json_decode(file_get_contents(app_path() . '/storage/gift_photo_intros.txt'));
     foreach ($topics as $topic) {
         $t = new Topic();
         $t->id = $topic->id;
         $t->title = $topic->title;
         $t->content = $topic->content;
         $t->topic_url = $topic->topic_url;
         if (!$t->save()) {
             return 'topic_false';
         }
     }
     foreach ($gifts as $gift) {
         $g = new Gift();
         $g->id = $gift->id;
         $g->topic_id = $gift->topic_id;
         $g->title = $gift->title;
         $g->price = $gift->price;
         $g->content = $gift->content;
         if (!$g->save()) {
             return 'gift_false';
         }
     }
     foreach ($gift_posters as $gift_poster) {
         $tp = new GiftPoster();
         $tp->gift_id = $gift_poster->gift_id;
         $tp->url = $gift_poster->url;
         if (!$tp->save()) {
             return 'gift_poster_false';
         }
     }
     foreach ($gift_photo_intros as $gift_photo_intro) {
         $gpi = new GiftPhotoIntro();
         $gpi->gift_id = $gift_photo_intro->gift_id;
         $gpi->url = $gift_photo_intro->url;
         if (!$gpi->save()) {
             return 'gift_photo_intro_false';
         }
     }
     return Response::json(array('errCode' => 0, 'message' => '插入成功'));
 }
示例#3
0
 public static function gifts()
 {
     $gifts = Gift::orderBy('created_at', 'desc')->get();
     foreach ($gifts as $gift) {
         $url = GiftPoster::where('gift_id', '=', $gift->id)->first()->url;
         $gift->img = StaticController::imageWH($url);
     }
     return $gifts;
 }
示例#4
0
 public function addGiftPhotoAndFocus($gifts)
 {
     foreach ($gifts as $gift) {
         $gift->url = GiftPoster::where('gift_id', '=', $gift->id)->first()->url;
         if (Sentry::check()) {
             $gift_focus = GiftFocus::where('user_id', Sentry::getUser()->id)->where('gift_id', $gift->id)->first();
             if (isset($gift_focus)) {
                 $gift->type = 1;
             } else {
                 $gift->type = 0;
             }
         } else {
             $gift->type = 0;
         }
     }
     return $gifts;
 }
示例#5
0
 public function giftAjax()
 {
     // if(!Sentry::check())
     // 	return Response::json(array('errCode'=>1, 'message'=>'请登录'));
     // $user = Sentry::getUser();
     $user = User::find(1);
     $per_page = Input::get('per_page');
     $page = Input::get('page');
     $gift_focus = DB::table('gift_focus')->where('user_id', '=', $user->id)->orderBy('created_at', 'desc')->get();
     //总页数
     $total = ceil(count($gift_focus) / $per_page);
     // dd($total);
     //喜欢的礼品
     $focus = StaticController::page($per_page, $page, $gift_focus);
     // dd(count($focus));
     $gifts = array();
     if ($focus) {
         foreach ($focus as $gift) {
             array_push($gifts, Gift::find($gift->gift_id));
         }
         foreach ($gifts as $candy) {
             $url = GiftPoster::where('gift_id', '=', $candy->id)->first()->url;
             $candy->img = StaticController::imageWH($url);
         }
     }
     return Response::json(array('errCode' => 0, 'message' => '返回用户喜欢的礼品', 'gifts' => $gifts, 'total' => $total));
 }
示例#6
0
 public function topic()
 {
     $topic_id = Input::get('topic_id');
     $topic = Topic::find($topic_id);
     if (!isset($topic)) {
         if (Request::wantsJson()) {
             return Response::json(array('errCode' => 1, 'message' => 该专题不存在));
         } else {
             return Response::view('errors.missing');
         }
     }
     $gifts = Gift::where('topic_id', '=', $topic->id)->get();
     if (isset($gifts)) {
         $number = 1;
         foreach ($gifts as $gift) {
             $url = GiftPoster::where('gift_id', '=', $gift->id)->first()->url;
             $gift->img = StaticController::imageWH($url);
             $gift->number = $number++;
         }
     }
     $gifts = $this->isGiftLike($gifts);
     $type = $this->isTopicLike($topic_id);
     if (Request::wantsJson()) {
         return Response::json(array('errCode' => 0, 'message' => '返回专题页数据', 'topic' => $topic, 'gifts' => $gifts, 'type' => $type));
     }
     return View::make('index/goodsList')->with(array('topic' => $topic, 'gifts' => $gifts, 'type' => $type));
 }
示例#7
0
 public function run()
 {
     $i = 0;
     for ($i = 0; $i < 200; $i++) {
         GiftPoster::create(['gift_id' => $i + 1, 'url' => 'http://7xl6gj.com1.z0.glb.clouddn.com/19.2.jpg']);
     }
     // GiftPoster::create([
     // 		'gift_id' => 1,
     // 		'url' => 'http://7xl6gj.com1.z0.glb.clouddn.com/19.2.jpg'
     // 	]);
     // GiftPoster::create([
     // 	'gift_id' => 2,
     // 	'url' => 'http://7xl6gj.com1.z0.glb.clouddn.com/35-7.jpg'
     // ]);
     // GiftPoster::create([
     // 	'gift_id' => 3,
     // 	'url' => 'http://7xl6gj.com1.z0.glb.clouddn.com/19.2.jpg'
     // ]);
     // GiftPoster::create([
     // 	'gift_id' => 4,
     // 	'url' => 'http://7xl6gj.com1.z0.glb.clouddn.com/19.2.jpg'
     // ]);GiftPoster::create([
     // 	'gift_id' => 5,
     // 	'url' => 'http://7xl6gj.com1.z0.glb.clouddn.com/35-7.jpg'
     // ]);
     // GiftPoster::create([
     // 	'gift_id' => 6,
     // 	'url' => 'http://7xl6gj.com1.z0.glb.clouddn.com/36-3.jpg'
     // ]);
     // GiftPoster::create([
     // 	'gift_id' => 7,
     // 	'url' => 'http://7xl6gj.com1.z0.glb.clouddn.com/44-10.jpg'
     // ]);
     // GiftPoster::create([
     // 	'gift_id' => 8,
     // 	'url' => 'http://7xl6gj.com1.z0.glb.clouddn.com/19.2.jpg'
     // ]);
     // GiftPoster::create([
     // 	'gift_id' => 9,
     // 	'url' => 'http://7xl6gj.com1.z0.glb.clouddn.com/36-3.jpg'
     // ]);
     // GiftPoster::create([
     // 	'gift_id' => 10,
     // 	'url' => 'http://7xl6gj.com1.z0.glb.clouddn.com/19.2.jpg'
     // ]);
     // GiftPoster::create([
     // 	'gift_id' => 11,
     // 	'url' => 'http://7xl6gj.com1.z0.glb.clouddn.com/36-3.jpg'
     // ]);
     // GiftPoster::create([
     // 	'gift_id' => 12,
     // 	'url' => 'http://7xl6gj.com1.z0.glb.clouddn.com/19.2.jpg'
     // ]);
     // GiftPoster::create([
     // 	'gift_id' => 13,
     // 	'url' => 'http://7xl6gj.com1.z0.glb.clouddn.com/36-3.jpg'
     // ]);
     // GiftPoster::create([
     // 	'gift_id' => 14,
     // 	'url' => 'http://7xl6gj.com1.z0.glb.clouddn.com/19.2.jpg'
     // ]);
     // GiftPoster::create([
     // 	'gift_id' => 15,
     // 	'url' => 'http://7xl6gj.com1.z0.glb.clouddn.com/19.2.jpg'
     // ]);
     // GiftPoster::create([
     // 	'gift_id' => 16,
     // 	'url' => 'http://7xl6gj.com1.z0.glb.clouddn.com/44-10.jpg'
     // ]);
 }