QuestionController.php 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473
  1. <?php
  2. namespace App\Http\Controllers\Ask;
  3. use App\Http\Controllers\Controller;
  4. use App\Models\Draft;
  5. use App\Models\Question;
  6. use App\Models\QuestionInvitation;
  7. use App\Models\Tag;
  8. use App\Models\User;
  9. use App\Models\UserTag;
  10. use App\Models\XsSearch;
  11. use App\Services\CaptchaService;
  12. use App\Services\NotificationService;
  13. use Illuminate\Http\Request;
  14. use Illuminate\Support\Facades\App;
  15. use Illuminate\Support\Facades\DB;
  16. use Illuminate\Support\Facades\Gate;
  17. use Illuminate\Support\Facades\Validator;
  18. class QuestionController extends Controller
  19. {
  20. /*问题创建校验*/
  21. protected $validateRules = [
  22. 'title' => 'required|max:255',
  23. 'description' => 'sometimes|max:65535',
  24. 'price' => 'sometimes|integer|min:0|max:1000',
  25. 'tags' => 'sometimes|max:128',
  26. 'category_id' => 'sometimes|numeric'
  27. ];
  28. /**
  29. * 问题详情查看
  30. */
  31. public function detail($id, Request $request)
  32. {
  33. $question = Question::find($id);
  34. if (empty($question)) {
  35. abort(404);
  36. }
  37. /*待审核问题游客不可见,管理员和内容作者可见*/
  38. if ($question->status == 0) {
  39. if (Auth()->guest()) {
  40. abort(404);
  41. }
  42. $this->authorize('show', $question);
  43. }
  44. /*问题查看数+1*/
  45. $question->increment('views');
  46. /*已解决问题*/
  47. $bestAnswer = [];
  48. if ($question->status === 2) {
  49. $bestAnswer = $question->answers()->where('adopted_at', '>', 0)->first();
  50. }
  51. if ($request->input('sort', 'default') === 'created_at') {
  52. $answers = $question->answers()->whereNull('adopted_at')->orderBy('created_at', 'DESC')->paginate(10);
  53. } else {
  54. $answers = $question->answers()->whereNull('adopted_at')->orderBy('supports', 'DESC')->orderBy('created_at',
  55. 'ASC')->paginate(10);
  56. }
  57. /*设置通知为已读*/
  58. if ($request->user()) {
  59. $this->readNotifications($question->id, 'question');
  60. }
  61. /*相关问题*/
  62. $relatedQuestions = Question::correlations($question->tags()->pluck('tag_id'));
  63. /*回答草稿箱处理*/
  64. $draftId = $request->query('draftId', '');
  65. $formData['content'] = '';
  66. if($draftId){
  67. $draft = Draft::find($draftId);
  68. if($draft){
  69. $formData['content'] = $draft->editor_content;
  70. }
  71. }
  72. return view("theme::question.detail")->with('question', $question)
  73. ->with('answers', $answers)->with('bestAnswer', $bestAnswer)
  74. ->with('relatedQuestions', $relatedQuestions)->with('formData',$formData);
  75. }
  76. /**
  77. * 问题添加页面显示
  78. */
  79. public function create(Request $request)
  80. {
  81. $to_user_id = $request->query('to_user_id', 0);
  82. $draftId = $request->query('draftId', '');
  83. $draft = Draft::find($draftId);
  84. if ($draftId && !$draft) {
  85. abort(404);
  86. }
  87. $formData = [];
  88. $formData['subject'] = '';
  89. $formData['content'] = '';
  90. $formData['category_id'] = 0;
  91. if($draft){
  92. $draft->form_data = json_decode($draft->form_data,true);
  93. $formData['subject'] = $draft->subject;
  94. $formData['content'] = $draft->editor_content;
  95. $formData['category_id'] = $draft->form_data['category_id'];
  96. $to_user_id = $draft->formData['to_user_id'];
  97. }
  98. $toUser = User::find($to_user_id);
  99. return view("theme::question.create")->with(compact('toUser', 'to_user_id','formData'));
  100. }
  101. /*创建提问*/
  102. public function store(Request $request, CaptchaService $captchaService)
  103. {
  104. $loginUser = $request->user();
  105. if ($request->user()->status === 0) {
  106. return $this->error(route('website.index'), '操作失败!您的邮箱还未验证,验证后才能进行该操作!');
  107. }
  108. /*防灌水检查*/
  109. if (Setting()->get('question_limit_num') > 0) {
  110. $questionCount = $this->counter('question_num_' . $loginUser->id);
  111. if ($questionCount > Setting()->get('question_limit_num')) {
  112. return $this->showErrorMsg(route('website.index'),
  113. '你已超过每小时最大提问数' . Setting()->get('question_limit_num') . ',如有疑问请联系管理员!');
  114. }
  115. }
  116. $request->flash();
  117. /*如果开启验证码则需要输入验证码*/
  118. if (Setting()->get('code_create_question')) {
  119. $captchaService->setValidateRules('code_create_question', $this->validateRules);
  120. }
  121. $this->validate($request,$this->validateRules);
  122. $price = abs($request->input('price'));
  123. if($price > 0 && $request->user()->userData->coins < $price){
  124. return $this->error(route('ask.question.create'),'操作失败!您的金币数不足!');
  125. }
  126. $data = [
  127. 'user_id' => $loginUser->id,
  128. 'category_id' => $request->input('category_id', 0),
  129. 'title' => trim($request->input('title')),
  130. 'description' => clean($request->input('description')),
  131. 'price' => $price,
  132. 'hide' => intval($request->input('hide')),
  133. 'status' => 1,
  134. ];
  135. $question = Question::create($data);
  136. /*判断问题是否添加成功*/
  137. if ($question) {
  138. /*悬赏提问*/
  139. if ($question->price > 0) {
  140. $this->credit($question->user_id, 'ask', -$question->price, 0, $question->id, $question->title);
  141. }
  142. /*添加标签*/
  143. $tagString = trim($request->input('tags'));
  144. Tag::multiSave($tagString, $question);
  145. //记录动态 匿名状态不记录动态
  146. if (!$question->hide) {
  147. $this->doing($question->user_id, 'ask', get_class($question), $question->id, $question->title,
  148. $question->description);
  149. }
  150. /*邀请作答逻辑处理*/
  151. $to_user_id = $request->input('to_user_id', 0);
  152. $this->notify($question->user_id, $to_user_id, 'invite_answer', $question->title, $question->id);
  153. $this->invite($question->id, $to_user_id, $request);
  154. /*用户提问数+1*/
  155. $loginUser->userData()->increment('questions');
  156. UserTag::multiIncrement($loginUser->id, $question->tags()->get(), 'questions');
  157. $this->credit($request->user()->id, 'ask', Setting()->get('coins_ask'), Setting()->get('credits_ask'),
  158. $question->id, $question->title);
  159. if ($question->status == 1) {
  160. $message = '发起提问成功! ' . get_credit_message(Setting()->get('credits_ask'), Setting()->get('coins_ask'));
  161. } else {
  162. $message = '问题发布成功!为了确保问答的质量,我们会对您的提问内容进行审核。请耐心等待......';
  163. }
  164. $this->counter('question_num_' . $question->user_id, 1, 60);
  165. return $this->success(route('ask.question.detail', ['question_id' => $question->id]), $message);
  166. }
  167. return $this->error(route('website.index'), "问题创建失败,请稍后再试");
  168. }
  169. /*显示问题编辑页面*/
  170. public function edit($id, Request $request)
  171. {
  172. $question = Question::find($id);
  173. if (!$question) {
  174. abort(404);
  175. }
  176. /*编辑权限控制*/
  177. $this->authorize('update', $question);
  178. /*编辑问题时效控制*/
  179. if (!Gate::allows('updateInTime', $question)) {
  180. return $this->showErrorMsg(route('website.index'), '你已超过问题可编辑的最大时长,不能进行编辑了。如有疑问请联系管理员!');
  181. }
  182. return view("theme::question.edit")->with(compact('question'));
  183. }
  184. /*问题内容编辑*/
  185. public function update(Request $request, CaptchaService $captchaService)
  186. {
  187. $question_id = $request->input('id');
  188. $question = Question::find($question_id);
  189. if (!$question) {
  190. abort(404);
  191. }
  192. $this->authorize('update', $question);
  193. $request->flash();
  194. /*普通用户修改需要输入验证码*/
  195. if (Setting()->get('code_create_question')) {
  196. $captchaService->setValidateRules('code_create_question', $this->validateRules);
  197. }
  198. $this->validate($request, $this->validateRules);
  199. $question->title = trim($request->input('title'));
  200. $question->description = clean($request->input('description'));
  201. $question->hide = intval($request->input('hide'));
  202. $question->category_id = $request->input('category_id', 0);
  203. $question->save();
  204. $tagString = trim($request->input('tags'));
  205. /*更新标签*/
  206. Tag::multiSave($tagString, $question);
  207. return $this->success(route('ask.question.detail', ['question_id' => $question->id]), "问题编辑成功");
  208. }
  209. /*追加悬赏*/
  210. public function appendReward($id, Request $request)
  211. {
  212. $question = Question::find($id);
  213. if (!$question) {
  214. abort(404);
  215. }
  216. $validateRules = [
  217. 'coins' => 'required|digits_between:1,' . $request->user()->userData->coins
  218. ];
  219. $this->validate($request, $validateRules);
  220. DB::beginTransaction();
  221. try {
  222. $this->credit($request->user()->id, 'append_reward', -abs($request->input('coins')), 0, $question->id,
  223. $question->title);
  224. $question->increment('price', $request->input('coins'));
  225. DB::commit();
  226. return $this->success(route('ask.question.detail', ['question_id' => $id]), "追加悬赏成功");
  227. } catch (\Exception $e) {
  228. DB::rollBack();
  229. return $this->error(route('ask.question.detail', ['question_id' => $id]), "追加悬赏失败,请稍后再试");
  230. }
  231. }
  232. /*问题建议*/
  233. public function suggest(Request $request)
  234. {
  235. $validateRules = [
  236. 'word' => 'required|min:2|max:255',
  237. ];
  238. $this->validate($request, $validateRules);
  239. if (Setting()->get('xunsearch_open', 0) != 1) {
  240. return response('');
  241. }
  242. $word = $request->input('word');
  243. $xsSearch = XsSearch::getSearch();
  244. $model = App::make('App\Models\\Question');
  245. $docs = $xsSearch->model($model)->addQuery('subject:' . $word)->setLimit(10, 0)->search();
  246. $suggestList = '';
  247. foreach ($docs as $doc) {
  248. $question = Question::find($doc->id);
  249. if (!$question) {
  250. continue;
  251. }
  252. $suggestList .= '<li>';
  253. if ($question->status === 2) {
  254. $suggestList .= '<span class="label label-success pull-left mr-5">解决</span>';
  255. }
  256. $suggestList .= '<a href="' . route('ask.question.detail',
  257. ['id' => $doc->id]) . '" target="_blank" class="mr-10">' . XsSearch::getSearch()->highlight($doc->subject) . '</a>';
  258. $suggestList .= '<small class="text-muted">' . $question->answers . ' 回答</small>';
  259. $suggestList .= '</li>';
  260. }
  261. return response($suggestList);
  262. }
  263. /*邀请回答*/
  264. public function invite($question_id, $to_user_id, Request $request)
  265. {
  266. $loginUser = $request->user();
  267. if ($loginUser->id == $to_user_id) {
  268. return $this->ajaxError(50009, '不用邀请自己,您可以直接回答 :)');
  269. }
  270. $question = Question::find($question_id);
  271. if (!$question) {
  272. return $this->ajaxError(50001, 'notFound');
  273. }
  274. if ($this->counter('question_invite_num_' . $loginUser->id) > config('tipask.user_invite_limit')) {
  275. return $this->ajaxError(50007, '超出每天最大邀请次数');
  276. }
  277. $toUser = User::find(intval($to_user_id));
  278. if (!$toUser) {
  279. return $this->ajaxError(50005, '被邀请用户不存在');
  280. }
  281. if (!$toUser->allowedEmailNotify('invite_answer')) {
  282. return $this->ajaxError(50006, '邀请人设置为不允许被邀请回答');
  283. }
  284. /*是否已邀请,不能重复邀请*/
  285. if ($question->isInvited($toUser->email, $loginUser->id)) {
  286. return $this->ajaxError(50008, '该用户已被邀请,不能重复邀请');
  287. }
  288. $invitation = QuestionInvitation::create([
  289. 'from_user_id' => $loginUser->id,
  290. 'question_id' => $question->id,
  291. 'user_id' => $toUser->id,
  292. 'send_to' => $toUser->email
  293. ]);
  294. if ($invitation) {
  295. $this->counter('question_invite_num_' . $loginUser->id, 1);
  296. $subject = $loginUser->name . "在「" . Setting()->get('website_name') . "」向您发起了回答邀请";
  297. $message = "我在 " . Setting()->get('website_name') . " 上遇到了问题「" . $question->title . "」 → " . route("ask.question.detail",
  298. ['question_id' => $question->id]) . ",希望您能帮我解答 ";
  299. $this->sendEmail($invitation->send_to, $subject, $message);
  300. // 记录到通知
  301. NotificationService::notify($loginUser->id, $toUser->id, 'invite_answer', $question->title, $question->id);
  302. return $this->ajaxSuccess('success');
  303. }
  304. return $this->ajaxError(10008, '邀请失败,请稍后再试');
  305. }
  306. public function inviteEmail($question_id, Request $request)
  307. {
  308. $loginUser = $request->user();
  309. if ($this->counter('question_invite_num_' . $loginUser->id) > config('tipask.user_invite_limit')) {
  310. return $this->ajaxError(50007, '超出每天最大邀请次数');
  311. }
  312. $question = Question::find($question_id);
  313. if (!$question) {
  314. return $this->ajaxError(50001, 'question not fund');
  315. }
  316. $validator = Validator::make($request->all(), [
  317. 'sendTo' => 'required|email|max:255',
  318. 'message' => 'required|min:10|max:10000',
  319. ]);
  320. if ($validator->fails()) {
  321. $this->ajaxError(50011, '字段校验失败');
  322. }
  323. $loginUser = $request->user();
  324. $email = $request->input('sendTo');
  325. $content = $request->input('message');
  326. /*是否已邀请,不能重复邀请*/
  327. if ($question->isInvited($email, $loginUser->id)) {
  328. return $this->ajaxError(50008, '该用户已被邀请,不能重复邀请');
  329. }
  330. $invitation = QuestionInvitation::create([
  331. 'from_user_id' => $loginUser->id,
  332. 'question_id' => $question->id,
  333. 'user_id' => 0,
  334. 'send_to' => $email
  335. ]);
  336. if ($invitation) {
  337. $this->counter('question_invite_num_' . $loginUser->id, 1);
  338. $subject = $loginUser->name . "在「" . Setting()->get('website_name') . "」向您发起了回答邀请";
  339. $message = $content;
  340. $this->sendEmail($invitation->send_to, $subject, $message);
  341. return $this->ajaxSuccess('success');
  342. }
  343. return $this->ajaxError(10008, '邀请失败,请稍后再试');
  344. }
  345. public function invitations($question_id, $type)
  346. {
  347. $question = Question::find($question_id);
  348. if (!$question) {
  349. return $this->ajaxError(50001, 'question not fund');
  350. }
  351. $showRows = ($type == 'part') ? 3 : 100;
  352. $invitations = $question->invitations()->where("user_id", ">", 0)->orderBy('created_at',
  353. 'desc')->groupBy('user_id')->take($showRows);
  354. $invitedUsers = [];
  355. foreach ($invitations->get() as $invitation) {
  356. if ($invitation->user()) {
  357. $invitedUsers[] = '<a target="_blank" href="' . route('auth.space.index',
  358. ['user_id' => $invitation->user->id]) . '">' . $invitation->user->name . '</a>';
  359. }
  360. }
  361. $invitedHtml = implode(",&nbsp;", $invitedUsers);
  362. $totalInvitedNum = $invitations->count();
  363. if ($type == 'part' && $totalInvitedNum > $showRows) {
  364. $invitedHtml .= '等 <a id="showAllInvitedUsers" href="javascript:void(0);">' . $totalInvitedNum . '</a> 人';
  365. }
  366. if ($totalInvitedNum > 0) {
  367. $invitedHtml .= '&nbsp;已被邀请';
  368. }
  369. return response($invitedHtml);
  370. }
  371. }