RiddleAnswer.php 4.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154
  1. <?php namespace App\Http\Controllers\Admin;
  2. use App\Http\Requests\Admin\Riddle\Answer as Request;
  3. use App\Models\Riddle\Answer as Model;
  4. use App\Models\Riddle\Question as Question;
  5. /**
  6. * 灯谜答案
  7. *
  8. * @author 刘相欣
  9. *
  10. */
  11. class RiddleAnswer extends Auth{
  12. protected function _initialize(){
  13. parent::_initialize();
  14. $this->assign('breadcrumb1','灯谜活动');
  15. $this->assign('breadcrumb2','灯谜选项');
  16. }
  17. /**
  18. * 列表页
  19. *
  20. * */
  21. public function index(Model $Model,Question $Question){
  22. // 接收参数
  23. $questionId = request('question_id','');
  24. // 查询条件
  25. $map = [];
  26. // 组合条件
  27. if( $questionId ) $map[] = ['question_id','=',$questionId];
  28. // 查询数据
  29. $list = $Model->query()->where($map)->orderByDesc('id')->paginate(config('page_num',10))->appends(request()->all());
  30. // 循环处理数据
  31. foreach ($list as $key => $value) {
  32. // 重组
  33. $list[$key] = $value;
  34. }
  35. // 问题列表
  36. $questionList = $Question->query()->get(['id','title'])->toArray();
  37. // 分配数据
  38. $this->assign('empty', '<tr><td colspan="20">~~暂无数据</td></tr>');
  39. $this->assign('questionList',$questionList);
  40. $this->assign('list',$list);
  41. // 加载模板
  42. return $this->fetch();
  43. }
  44. /**
  45. * 添加
  46. *
  47. * */
  48. public function add(Request $request,Model $Model,Question $Question){
  49. if( request()->isMethod('post') ){
  50. // 验证参数
  51. $request->scene('add')->validate();
  52. // 接收数据
  53. $data['question_id'] = request('question_id',0);
  54. $data['value'] = request('value','');
  55. // 通过查询
  56. $count = count($Model->getListByQuestion($data['question_id']));
  57. // 最多添加4个选项
  58. if( $count >= 4 ) return json_send(['code'=>'error','msg'=>'最多添加4个选项']);
  59. // 写入数据表
  60. $id = $Model->add($data);
  61. // 如果操作失败
  62. if( !$id ) return json_send(['code'=>'error','msg'=>'新增失败']);
  63. // 记录行为
  64. $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,1,[],$data);
  65. // 告知结果
  66. return json_send(['code'=>'success','msg'=>'新增成功','action'=>'add']);
  67. }
  68. // 问题列表
  69. $questionList = $Question->query()->get(['id','title'])->toArray();
  70. // 分配数据
  71. $this->assign('questionList',$questionList);
  72. $this->assign('crumbs','新增');
  73. // 加载模板
  74. return $this->fetch();
  75. }
  76. /**
  77. * 修改
  78. *
  79. * */
  80. public function edit(Request $request,Model $Model,Question $Question){
  81. // 接收参数
  82. $id = request('id',0);
  83. // 查询用户
  84. $oldData = $Model->where(['id'=>$id])->first();
  85. // 修改
  86. if(request()->isMethod('post')){
  87. // 验证参数
  88. $request->scene('edit')->validate();
  89. // 接收数据
  90. $data['question_id'] = request('question_id',0);
  91. $data['value'] = request('value','');
  92. // 获取当前问题
  93. $oldQuestion = $Model->getOne($data['question_id'],$id,'question_id');
  94. // 如果当前选项值,不是当前的问题ID
  95. if( $oldQuestion != $data['question_id'] ){
  96. // 通过查询
  97. $count = count($Model->getListByQuestion($data['question_id']));
  98. // 最多添加4个选项
  99. if( $count >= 4 ) return json_send(['code'=>'error','msg'=>'最多添加4个选项']);
  100. }
  101. // 写入数据表
  102. $result = $Model->edit($id,$data);
  103. // 如果操作失败
  104. if( !$result ) return json_send(['code'=>'error','msg'=>'修改失败']);
  105. // 记录行为
  106. $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,2,$oldData,$data);
  107. // 告知结果
  108. return json_send(['code'=>'success','msg'=>'修改成功','action'=>'edit']);
  109. }
  110. // 错误告知
  111. if( !$oldData ) return $this->error('查无数据');
  112. // 问题列表
  113. $questionList = $Question->query()->get(['id','title'])->toArray();
  114. // 分配数据
  115. $this->assign('questionList',$questionList);
  116. $this->assign('oldData',$oldData);
  117. $this->assign('crumbs','修改');
  118. // 加载模板
  119. return $this->fetch();
  120. }
  121. /**
  122. * 修改状态
  123. *
  124. * */
  125. public function set_answer(Request $request,Model $Model){
  126. // 验证参数
  127. $request->scene('set_answer')->validate();
  128. // 设置状态
  129. $id = request('id',0);
  130. $status = request('is_answer',0);
  131. // 查询用户
  132. $oldData = $Model->where(['id'=>$id])->first();
  133. // 如果用户不存在
  134. if( !$oldData ) return json_send(['code'=>'error','msg'=>'数据不存在']);
  135. // 执行修改
  136. $result = $Model->query()->where([['question_id','=',$oldData['question_id']]])->update(['is_answer'=>0]);
  137. // 执行修改
  138. $result = $Model->edit($id,['is_answer'=>$status]);
  139. // 提示新增失败
  140. if( !$result ) return json_send(['code'=>'error','msg'=>'设置失败']);
  141. // 记录行为
  142. $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,2,$oldData,['status'=>$status]);
  143. // 告知结果
  144. return json_send(['code'=>'success','msg'=>'设置成功','path'=>'']);
  145. }
  146. }