get('position_id')){ $model = $model->where('position_id',$request->get('position_id')); } if ($request->get('title')){ $model = $model->where('title','like','%'.$request->get('title').'%'); } $res = $model->orderBy('sort','desc')->orderBy('id','desc')->with('position')->paginate($request->get('limit',30))->toArray(); $data = [ 'code' => 0, 'msg' => '正在请求中...', 'count' => $res['total'], 'data' => $res['data'] ]; return response()->json($data); } /** * Show the form for creating a new resource. * * @return \Illuminate\Http\Response */ public function create() { //所有广告位置 $positions = Position::orderBy('sort','desc')->get(); return view('admin.advert.create',compact('positions')); } /** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(Request $request) { $this->validate($request,[ 'title' => 'required|string', 'sort' => 'required|numeric', 'thumb' => 'required|string', 'position_id' => 'required|numeric' ]); if (Advert::create($request->all())){ return redirect(route('admin.advert'))->with(['status'=>'添加完成']); } return redirect(route('admin.advert'))->with(['status'=>'系统错误']); } /** * Display the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function show($id) { // } /** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function edit($id) { $advert = Advert::findOrFail($id); //所有广告位置 $positions = Position::orderBy('sort','desc')->get(); foreach ($positions as $position){ $position->selected = $position->id == $advert->position_id ? 'selected' : ''; } return view('admin.advert.edit',compact('positions','advert')); } /** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * @return \Illuminate\Http\Response */ public function update(Request $request, $id) { $this->validate($request,[ 'title' => 'required|string', 'sort' => 'required|numeric', 'thumb' => 'required|string', 'position_id' => 'required|numeric' ]); $advert = Advert::findOrFail($id); if ($advert->update($request->all())){ return redirect(route('admin.advert'))->with(['status'=>'更新成功']); } return redirect(route('admin.advert'))->withErrors(['status'=>'系统错误']); } /** * Remove the specified resource from storage. * * @param int $id * @return \Illuminate\Http\Response */ public function destroy(Request $request) { $ids = $request->get('ids'); if (empty($ids)){ return response()->json(['code'=>1,'msg'=>'请选择删除项']); } if (Advert::destroy($ids)){ return response()->json(['code'=>0,'msg'=>'删除成功']); } return response()->json(['code'=>1,'msg'=>'删除失败']); } }