InfoController.php 3.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107
  1. <?php
  2. namespace App\Http\Controllers;
  3. use Illuminate\Http\Request;
  4. use Illuminate\Support\Facades\DB;
  5. use Illuminate\Support\Facades\Auth;
  6. use Illuminate\Support\Facades\Validator;
  7. class InfoController extends Controller
  8. {
  9. public function __construct()
  10. {
  11. }
  12. /* 获取公告信息*/
  13. public function getInfos(Request $request)
  14. {
  15. $input=$request->all();
  16. $page_size=$input['page_size'];
  17. $page_index=$input['page_index'];
  18. $num=($page_index-1)*$page_size;
  19. $count=DB::table('infos')->count();
  20. if($count){
  21. $lists = DB::table('infos')
  22. ->orderBy('is_top','desc')
  23. ->orderBy('top_at','desc')
  24. ->orderBy('added_on', 'desc')
  25. ->skip($num)->take($page_size)->get();
  26. if ($lists) {
  27. return response()->json([
  28. 'error_code' => 200,
  29. 'msg' => '获取成功',
  30. 'data' => $lists,
  31. 'count'=>$count
  32. ]);
  33. } else {
  34. return response()->json([
  35. 'error_code' => 0,
  36. 'msg' => '获取失败'
  37. ]);
  38. }
  39. }else{
  40. return response()->json([
  41. 'error_code' => 200,
  42. 'msg' => '没有获取到数据',
  43. 'data' => [],
  44. 'count'=>$count
  45. ]);
  46. }
  47. }
  48. /* 获取公告详情 */
  49. public function getInfoDetail(Request $request)
  50. {
  51. $input = $request->all();
  52. $data = DB::table('infos')->where('id', $input['id'])->first();
  53. if ($data) {
  54. return response()->json([
  55. 'error_code' => 200,
  56. 'msg' => '获取成功',
  57. 'data' => $data
  58. ]);
  59. } else {
  60. return response()->json([
  61. 'error_code' => 0,
  62. 'msg' => '获取失败'
  63. ]);
  64. }
  65. }
  66. /* 提交意见反馈 */
  67. public function addOptions(Request $request)
  68. {
  69. $input = $request->all();
  70. $rules=[
  71. 'contents'=>'required'
  72. ];
  73. $messages=[
  74. 'contents.required'=>'意见反馈不能为空.',
  75. ];
  76. $validator = Validator::make($input, $rules ,$messages);
  77. if($validator->fails()){
  78. return response()->json([
  79. 'error_code'=>'41113',
  80. 'msg'=>$validator->errors()->first()
  81. ]);
  82. }
  83. $data['uid'] = Auth::user()->id;
  84. $data['contents'] = $input['contents'];
  85. $data['added_on'] = date("Y-m-d H:i:s");
  86. $row = DB::table('options')->insert($data);
  87. if ($row) {
  88. return response()->json([
  89. 'error_code' => 200,
  90. 'msg' => '添加成功',
  91. ]);
  92. } else {
  93. return response()->json([
  94. 'error_code' => 0,
  95. 'msg' => '添加失败'
  96. ]);
  97. }
  98. }
  99. }