123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107 |
- <?php
- namespace App\Http\Controllers;
- use Illuminate\Http\Request;
- use Illuminate\Support\Facades\DB;
- use Illuminate\Support\Facades\Auth;
- use Illuminate\Support\Facades\Validator;
- class InfoController extends Controller
- {
- public function __construct()
- {
- }
- /* 获取公告信息*/
- public function getInfos(Request $request)
- {
- $input=$request->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' => '添加失败'
- ]);
- }
- }
- }
|