DiscussionController.php 5.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190
  1. <?php
  2. namespace App\Http\Controllers;
  3. use App\Models\Discussion;
  4. use Illuminate\Http\Request;
  5. use App\Http\Resources\DiscussionResource;
  6. class DiscussionController extends Controller
  7. {
  8. /**
  9. * Display a listing of the resource.
  10. *
  11. * @return \Illuminate\Http\Response
  12. */
  13. public function index(Request $request)
  14. {
  15. //
  16. switch ($request->get('view')) {
  17. case 'question':
  18. $table = Discussion::where('res_id',$request->get('id'))->where('parent',null);
  19. break;
  20. case 'answer':
  21. $table = Discussion::where('parent',$request->get('id'));
  22. break;
  23. }
  24. if(!empty($search)){
  25. $table->where('title', 'like', $search."%");
  26. }
  27. if(!empty($request->get('order')) && !empty($request->get('dir'))){
  28. $table->orderBy($request->get('order'),$request->get('dir'));
  29. }else{
  30. $table->orderBy('updated_at','asc');
  31. }
  32. $count = $table->count();
  33. if(!empty($request->get('limit'))){
  34. $offset = 0;
  35. if(!empty($request->get("offset"))){
  36. $offset = $request->get("offset");
  37. }
  38. $table->skip($offset)->take($request->get('limit'));
  39. }
  40. $result = $table->get();
  41. if($result){
  42. return $this->ok(["rows"=>DiscussionResource::collection($result),"count"=>$count]);
  43. }else{
  44. return $this->error("没有查询到数据");
  45. }
  46. }
  47. /**
  48. * Store a newly created resource in storage.
  49. *
  50. * @param \Illuminate\Http\Request $request
  51. * @return \Illuminate\Http\Response
  52. */
  53. public function store(Request $request)
  54. {
  55. $user = \App\Http\Api\AuthApi::current($request);
  56. if(!$user){
  57. return $this->error(__('auth.failed'));
  58. }
  59. //
  60. // validate
  61. // read more on validation at http://laravel.com/docs/validation
  62. $rules = array(
  63. 'res_id' => 'required',
  64. 'res_type' => 'required',
  65. );
  66. if(!$request->has('parent')){
  67. $rules['title'] = 'required';
  68. }
  69. $validated = $request->validate($rules);
  70. $discussion = new Discussion;
  71. $discussion->res_id = $request->get('res_id');
  72. $discussion->res_type = $request->get('res_type');
  73. $discussion->title = $request->get('title',null);
  74. $discussion->content = $request->get('content',null);
  75. $discussion->parent = $request->get('parent',null);
  76. $discussion->editor_uid = $user['user_uid'];
  77. $discussion->save();
  78. //更新parent children_count
  79. if($request->has('parent')){
  80. $parent = Discussion::find($request->get('parent'));
  81. if($parent){
  82. $parent->increment('children_count',1);
  83. $parent->save();
  84. }
  85. }
  86. $end_point = 'https://api.webpushr.com/v1/notification/send/all';
  87. $http_header = array(
  88. "Content-Type: Application/Json",
  89. "webpushrKey: 90ce3ace1b8e6cc7ea90cb810880b4de",
  90. "webpushrAuthToken: 63019"
  91. );
  92. $req_data = array(
  93. 'title' => "提问", //required
  94. 'message' => "问题:".$request->get('title',""), //required
  95. 'target_url' => 'https://www.webpushr.com', //required
  96. //following parameters are optional
  97. //'name' => 'Test campaign',
  98. //'icon' => 'https://cdn.webpushr.com/siteassets/wSxoND3TTb.png',
  99. //'image' => 'https://cdn.webpushr.com/siteassets/aRB18p3VAZ.jpeg',
  100. //'auto_hide' => 1,
  101. //'expire_push' => '5m',
  102. //'send_at' => '2022-01-04 10:47 +5:30',
  103. 'action_buttons'=> array(
  104. array('title'=> '查看', 'url' => 'https://visuddhinanda.spring.wikipali.org'),
  105. )
  106. );
  107. $ch = curl_init();
  108. curl_setopt($ch, CURLOPT_HTTPHEADER, $http_header);
  109. curl_setopt($ch, CURLOPT_URL, $end_point );
  110. curl_setopt($ch, CURLOPT_POST, 1);
  111. curl_setopt($ch, CURLOPT_POSTFIELDS, json_encode($req_data) );
  112. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  113. $response = curl_exec($ch);
  114. return $this->ok(new DiscussionResource($discussion));
  115. }
  116. /**
  117. * Display the specified resource.
  118. *
  119. * @param \App\Models\Discussion $discussion
  120. * @return \Illuminate\Http\Response
  121. */
  122. public function show(Discussion $discussion)
  123. {
  124. //
  125. return $this->ok(new DiscussionResource($discussion));
  126. }
  127. /**
  128. * Update the specified resource in storage.
  129. *
  130. * @param \Illuminate\Http\Request $request
  131. * @param \App\Models\Discussion $discussion
  132. * @return \Illuminate\Http\Response
  133. */
  134. public function update(Request $request, Discussion $discussion)
  135. {
  136. //
  137. $user = \App\Http\Api\AuthApi::current($request);
  138. if(!$user){
  139. return $this->error(__('auth.failed'));
  140. }
  141. //
  142. if($discussion->editor !== $user['user_uid']){
  143. return $this->error(__('auth.failed'));
  144. }
  145. $discussion->title = $request->get('title',null);
  146. $discussion->content = $request->get('content',null);
  147. $discussion->editor_uid = $user['user_uid'];
  148. $discussion->save();
  149. return $this->ok($discussion);
  150. }
  151. /**
  152. * Remove the specified resource from storage.
  153. *
  154. * @param \App\Models\Discussion $discussion
  155. * @return \Illuminate\Http\Response
  156. */
  157. public function destroy(Discussion $discussion)
  158. {
  159. //
  160. $user = \App\Http\Api\AuthApi::current($request);
  161. if(!$user){
  162. return $this->error(__('auth.failed'));
  163. }
  164. //TODO 其他有权限的人也可以删除
  165. if($discussion->editor !== $user['user_uid']){
  166. return $this->error(__('auth.failed'));
  167. }
  168. $delete = $discussion->delete();
  169. return $this->ok($delete);
  170. }
  171. }