all(); $page_size=$input['page_size']; $page_index=$input['page_index']; $num=($page_index-1)*$page_size; $count=DB::table('infos')->count(); if($count){ $lists = DB::table('infos') ->orderBy('is_top','desc') ->orderBy('top_at','desc') ->orderBy('added_on', 'desc') ->skip($num)->take($page_size)->get(); if ($lists) { return response()->json([ 'error_code' => 200, 'msg' => '获取成功', 'data' => $lists, 'count'=>$count ]); } else { return response()->json([ 'error_code' => 0, 'msg' => '获取失败' ]); } }else{ return response()->json([ 'error_code' => 200, 'msg' => '没有获取到数据', 'data' => [], 'count'=>$count ]); } } /* 获取公告详情 */ public function getInfoDetail(Request $request) { $input = $request->all(); $data = DB::table('infos')->where('id', $input['id'])->first(); if ($data) { return response()->json([ 'error_code' => 200, 'msg' => '获取成功', 'data' => $data ]); } else { return response()->json([ 'error_code' => 0, 'msg' => '获取失败' ]); } } /* 提交意见反馈 */ public function addOptions(Request $request) { $input = $request->all(); $rules=[ 'contents'=>'required' ]; $messages=[ 'contents.required'=>'意见反馈不能为空.', ]; $validator = Validator::make($input, $rules ,$messages); if($validator->fails()){ return response()->json([ 'error_code'=>'41113', 'msg'=>$validator->errors()->first() ]); } $data['uid'] = Auth::user()->id; $data['contents'] = $input['contents']; $data['added_on'] = date("Y-m-d H:i:s"); $row = DB::table('options')->insert($data); if ($row) { return response()->json([ 'error_code' => 200, 'msg' => '添加成功', ]); } else { return response()->json([ 'error_code' => 0, 'msg' => '添加失败' ]); } } }