/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$music = new Music();
$musics = $music->select('musics.title', 'musics.is_accepted', 'musics.band', 'musics.id', 'musics.style_id', 'musics.reason', 'musics.path')->where('musics.is_accepted', null)->get();
$music_style = new MusicStyle();
return view('musics')->with('musics', $musics)->with('music_style', $music_style->orderBy('name')->get());
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index(Request $request)
{
/**
* 取得GET方法传过来的参数
* @var [type]
*/
$name = $request->get('name') or "";
$instrument = $request->get('instrument') or "";
$press = $request->get('press') or 0;
$category = $request->get('category') or "";
$onshelf = $request->get('onshelf') or "";
$organizer = $request->get('organizer') or "";
$operator = $request->get('operator') or "";
$date = $request->get('date') or "";
$version = $request->get('version') or "";
$level = $request->get('level') or "";
// if (empty($name) && empty($instrument) && empty($press)
// && empty($category) && empty($onshelf) && empty($organizer)
// && empty($operator) && empty($date)) {
// return view('music');
// }
/**
* 按传过来的参数不同，组合不同的查询语句
* @var Music
*/
$musics = Music::with('instrument')->with('organizer')->with('tags')->with('press')->with('user')->with('editor');
if (!empty($name)) {
$musics->where('name', 'like', "%{$name}%")->orWhere('composer', 'like', "%{$name}%");
}
if (!empty($instrument)) {
$musics->where('instrument_id', '=', "{$instrument}");
}
if (!empty($press)) {
$musics->where('press_id', '=', "{$press}");
}
if (!empty($category)) {
$musics->whereHas('tags', function ($query) use($category) {
$query->where('id', "=", "{$category}");
});
}
if (!empty($onshelf)) {
$musics->where('onshelf', '=', "{$onshelf}");
}
if (!empty($organizer)) {
$musics->where('organizer_id', '=', "{$organizer}");
}
if (!empty($operator)) {
$musics->where('operator', '=', "{$operator}");
}
if (!empty($date)) {
$date_start = $date . " 00:00:00";
$date_end = $date . " 23:23:59";
$musics->whereBetween('created_at', ["{$date_start}", "{$date_end}"]);
}
if (!empty($version)) {
$musics->where('version', $version);
}
if (!empty($level)) {
$musics->where('level', $level);
}
// $musics = $musics->paginate(10)->appends(
// ['name' => $name,
// 'instrument' => $instrument,
// 'press' => $press,
// 'category' => $category,
// 'onshelf' => $onshelf,
// 'organizer' => $organizer,
// 'operator' => $operator,
// 'date' => $date]
// );
// $name = $request->get('name') or "";
// $instrument = $request->get('instrument') or "";
// $press = $request->get('press') or 0;
// $category = $request->get('category') or "";
// $onshelf = $request->get('onshelf') or "";
// $organizer = $request->get('organizer') or "";
// $operator = $request->get('operator') or "";
// $date = $request->get('date') or "";
$musics = $musics->paginate(10)->appends($request->all());
$versions = Music::select('version')->where('version', '<>', '')->distinct()->get();
$data_condition = $this->getCondations();
// return $request->all();
/**
* 将结果返回给视图
*/
return view('music')->with(['musics' => $musics, 'versions' => $versions, 'data_condition' => $data_condition])->withInput($request->all());
}
