public function index(Request $request) { $scope = []; if ($request->has('title')) { $scope['title'] = ['LIKE', '%' . $request->input('title') . '%']; } if ($request->has('information')) { $scope['information'] = ['LIKE', '%' . $request->input('information') . '%']; } if ($request->has('startdate') || $request->has('enddate')) { if (!$request->has('startdate')) { $scope['showtime'] = ['<=', $request->input('enddate') . ' 23:59:59']; } else { if (!$request->has('enddate')) { $scope['showtime'] = ['>=', $request->input('startdate') . ' 00:00:00']; } else { $showtime = [$request->input('startdate') . ' 00:00:00', $request->input('enddate') . ' 23:59:59']; } } } $params = $request->except('page'); if ($request->has('sort')) { $params['sort'] = $request->input('sort'); } else { $params['sort'] = 'id'; } if ($request->has('order')) { $params['order'] = $request->input('order'); } else { $params['order'] = 'desc'; } if (isset($showtime)) { $lives = Live::select('id', 'title', 'showtime', 'information')->whereBetween('showtime', $showtime)->multiwhere($scope)->orderBy($params['sort'], $params['order'])->paginate(30); } else { $lives = Live::select('id', 'title', 'showtime', 'information')->multiwhere($scope)->orderBy($params['sort'], $params['order'])->paginate(30); } return view('live.index', ['params' => $params, 'lives' => $lives]); }
public function zhoubian() { $newsongs = Song::select('id', 'title', 'alias', 'artist')->orderBy('id', 'desc')->take(15)->get(); $songrevs = Songrev::with(['user' => function ($query) { $query->select('id', 'name'); }, 'song' => function ($query) { $query->select('id', 'title'); }])->orderBy('id', 'desc')->take(10)->get(); $hotrevsongs = Songrev::with(['song' => function ($query) { $query->select('id', 'title', 'artist'); }])->where('created_at', '>=', date("Y-m-d H:i:s", strtotime("-30 day")))->select(DB::raw('count(*) as review_count, song_id'))->groupBy('song_id')->orderBy('review_count', 'desc')->take(15)->get(); $hotfavsongs = Songfav::with(['song' => function ($query) { $query->select('id', 'title', 'artist'); }])->where('created_at', '>=', date("Y-m-d H:i:s", strtotime("-30 day")))->select(DB::raw('count(*) as favorite_count, song_id'))->groupBy('song_id')->orderBy('favorite_count', 'desc')->take(15)->get(); $newcreatedfteps = Ftep::with(['ft' => function ($query) { $query->select('id', 'title', 'host'); }])->select('id', 'ft_id', 'title', 'release_date')->orderBy('id', 'desc')->take(10)->get(); $ftrevs = Ftrev::with(['user' => function ($query) { $query->select('id', 'name'); }, 'ft' => function ($query) { $query->select('id', 'title'); }, 'ftep' => function ($query) { $query->select('id', 'title'); }])->orderBy('id', 'desc')->take(10)->get(); $hotrevfts = Ftrev::with(['ft' => function ($query) { $query->select('id', 'title'); }])->where('created_at', '>=', date("Y-m-d H:i:s", strtotime("-30 day")))->select(DB::raw('count(*) as review_count, ft_id'))->groupBy('ft_id')->orderBy('review_count', 'desc')->take(10)->get(); $hotfavfts = Ftfav::with(['ft' => function ($query) { $query->select('id', 'title'); }])->where('created_at', '>=', date("Y-m-d H:i:s", strtotime("-30 day")))->select(DB::raw('count(*) as favorite_count, ft_id'))->groupBy('ft_id')->orderBy('favorite_count', 'desc')->take(10)->get(); $todaylives = Live::select('id', 'title', 'showtime')->whereRaw('date(showtime) = curdate()')->orderBy('showtime')->get(); $newlives = Live::select('id', 'title', 'showtime')->orderBy('id', 'desc')->take(15)->get(); $liverevs = Liverev::with(['user' => function ($query) { $query->select('id', 'name'); }, 'live' => function ($query) { $query->select('id', 'title', 'showtime'); }])->orderBy('id', 'desc')->take(10)->get(); $hotrevlives = Liverev::with(['live' => function ($query) { $query->select('id', 'title', 'showtime'); }])->where('created_at', '>=', date("Y-m-d H:i:s", strtotime("-30 day")))->select(DB::raw('count(*) as review_count, live_id'))->groupBy('live_id')->orderBy('review_count', 'desc')->take(15)->get(); $hotfavlives = Livefav::with(['live' => function ($query) { $query->select('id', 'title', 'showtime'); }])->where('created_at', '>=', date("Y-m-d H:i:s", strtotime("-30 day")))->select(DB::raw('count(*) as favorite_count, live_id'))->groupBy('live_id')->orderBy('favorite_count', 'desc')->take(15)->get(); return view('zhoubian', ['newsongs' => $newsongs, 'songrevs' => $songrevs, 'hotrevsongs' => $hotrevsongs, 'hotfavsongs' => $hotfavsongs, 'newcreatedfteps' => $newcreatedfteps, 'ftrevs' => $ftrevs, 'hotrevfts' => $hotrevfts, 'hotfavfts' => $hotfavfts, 'todaylives' => $todaylives, 'newlives' => $newlives, 'liverevs' => $liverevs, 'hotrevlives' => $hotrevlives, 'hotfavlives' => $hotfavlives]); }