Article.php 4.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186
  1. <?php namespace App\Http\Controllers\Admin;
  2. use App\Http\Requests\Admin\Article as Request;
  3. use App\Models\Article as Model;
  4. use Illuminate\Support\Facades\DB;
  5. /**
  6. * 分享设置
  7. *
  8. * @author huanglei
  9. *
  10. */
  11. class Article 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){
  22. // 接受参数
  23. $title = request('title','');
  24. $status = request('status');
  25. $startTime = request('start_time','');
  26. $endTime = request('end_time','');
  27. // 查询条件
  28. $map = [];
  29. // 编码ID
  30. if( $title ) $map[] = ['title','LIKE','%'.$title.'%'];
  31. if( $startTime ) $map[] = ['insert_time','>=',strtotime($startTime)];
  32. if( $endTime ) $map[] = ['insert_time','<=',strtotime($endTime)];
  33. if( !is_null($status) ) $map[] = ['status','=',$status];
  34. // 查询数据
  35. $list = $Model->query()->where($map)->orderByDesc('id')->paginate(request('limit',config('page_num',10)))->appends(request()->all());
  36. // 循环处理数据
  37. foreach ($list as $key => $value) {
  38. // 重组
  39. $list[$key] = $value;
  40. }
  41. // 分配数据
  42. $this->assign('empty', '<tr><td colspan="20">~~暂无数据</td></tr>');
  43. $this->assign('list', $list);
  44. // 加载模板
  45. return $this->fetch();
  46. }
  47. /**
  48. * 状态
  49. *
  50. * */
  51. public function set_status( Request $request, Model $Model){
  52. // 验证参数
  53. $request->scene('set_status')->validate();
  54. // 接收参数
  55. $id = request('id',0);
  56. $status = request('status',0);
  57. // 查询数据
  58. $result = $Model->edit($id,['status'=>$status]);
  59. // 提示新增失败
  60. if( !$result ) return json_send(['code'=>'error','msg'=>'设置失败']);
  61. // 告知结果
  62. return json_send(['code'=>'success','msg'=>'设置成功','path'=>'']);
  63. }
  64. /**
  65. * 添加
  66. *
  67. * */
  68. public function add( Request $request, Model $Model){
  69. if( request()->isMethod('post') ){
  70. // 验证参数
  71. $request->scene('add')->validate();
  72. // 组合数据
  73. $data['poster'] = request('poster',0);
  74. $data['title'] = request('title',0);
  75. $data['qrcode_link'] = request('link',0);
  76. $data['content'] = request('description',0);
  77. $data['status'] = request('status',0);
  78. // 验证信息
  79. // if( $data['rebate_type'] == 2 && $data['rebate'] > 9.99 ) return json_send(['code'=>'error','msg'=>'不能设置大于9.99折']);
  80. // 组合数据,写入订单表,子表
  81. DB::beginTransaction();
  82. try {
  83. // 写入
  84. $id = $Model->add($data);
  85. // 提示新增失败
  86. if( !$id ) {
  87. // 回滚
  88. DB::rollBack();
  89. // 提示
  90. return json_send(['code'=>'error','msg'=>'新增失败']);
  91. }
  92. // 提交
  93. DB::commit();
  94. // 记录行为
  95. $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,1,[],$data);
  96. // 告知结果
  97. return json_send(['code'=>'success','msg'=>'新增成功','action'=>'add']);
  98. } catch (\Throwable $th) {
  99. // 回滚
  100. DB::rollBack();
  101. // 提示失败
  102. return json_send(['code'=>'error','msg'=>'内部错误,请重试','data'=>['error'=>$th->getMessage()]]);
  103. }
  104. }
  105. $this->assign('crumbs','新增');
  106. // 加载模板
  107. return $this->fetch();
  108. }
  109. /**
  110. * 编辑
  111. *
  112. * */
  113. public function edit( Request $request, Model $Model){
  114. // 接收参数
  115. $id = request('id',0);
  116. // 查询数据
  117. $oldData = $Model->where(['id'=>$id])->first();
  118. // 修改
  119. if(request()->isMethod('post')){
  120. // 验证参数
  121. $request->scene('edit')->validate();
  122. // 组合数据
  123. $data['poster'] = request('poster',0);
  124. $data['title'] = request('title',0);
  125. $data['qrcode_link'] = request('link',0);
  126. $data['content'] = request('description',0);
  127. $data['status'] = request('status',0);
  128. // 转换时间,默认现在现在生效
  129. $data['update_time'] = time();
  130. // 组合数据,写入订单表,子表
  131. DB::beginTransaction();
  132. try {
  133. // 写入
  134. $result = $Model->edit($id,$data);
  135. // 提示新增失败
  136. if( !$result ) {
  137. // 回滚
  138. DB::rollBack();
  139. // 提示
  140. return json_send(['code'=>'error','msg'=>'修改失败']);
  141. }
  142. // 提交
  143. DB::commit();
  144. // 记录行为
  145. $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,2,[],$data);
  146. // 告知结果
  147. return json_send(['code'=>'success','msg'=>'修改成功','action'=>'edit']);
  148. } catch (\Throwable $th) {
  149. // 回滚
  150. DB::rollBack();
  151. // 提示失败
  152. return json_send(['code'=>'error','msg'=>'内部错误,请重试','data'=>['error'=>$th->getMessage()]]);
  153. }
  154. }
  155. // 如果是没有数据
  156. if( !$oldData ) return $this->error('查无数据');
  157. // 分配数据
  158. $this->assign('oldData',$oldData);
  159. $this->assign('crumbs','修改');
  160. // 加载模板
  161. return $this->fetch();
  162. }
  163. }