Course.php 4.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139
  1. <?php namespace App\Http\Controllers\Admin;
  2. use App\Http\Requests\Admin\Course as Request;
  3. use App\Models\Course as Model;
  4. use Illuminate\Support\Carbon;
  5. /**
  6. * 课程管理
  7. *
  8. * @author jun
  9. *
  10. */
  11. class Course 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. $name = request('name','');
  24. $status = request('status');
  25. $startTime = request('start_time','');
  26. // 查询条件
  27. $map = [];
  28. // 编码ID
  29. if( $name ) $map[] = ['name','=',$name];
  30. if( $startTime ) $map[] = ['insert_time','>=',Carbon::createFromFormat('Y-m-d',$startTime)->startOfDay()->getTimestamp()];
  31. if( $startTime ) $map[] = ['insert_time','<=',Carbon::createFromFormat('Y-m-d',$startTime)->endOfDay()->getTimestamp()];
  32. if( !is_null($status) ) $map[] = ['status','=',$status];
  33. // 查询数据
  34. $list = $Model->query()->where($map)->orderByDesc('id')->paginate(request('limit',config('page_num',10)))->appends(request()->all());
  35. // 循环处理数据
  36. foreach ($list as $key => $value) {
  37. // 重组
  38. $list[$key] = $value;
  39. }
  40. // 分配数据
  41. $this->assign('empty', '<tr><td colspan="20">~~暂无数据</td></tr>');
  42. $this->assign('list', $list);
  43. // 加载模板
  44. return $this->fetch();
  45. }
  46. /**
  47. * 添加
  48. *
  49. * */
  50. public function add(Request $request,Model $Model){
  51. if( request()->isMethod('post') ){
  52. // 验证参数
  53. $request->scene('add')->validate();
  54. // 接收数据
  55. $data['name'] = request('name','');
  56. $data['address'] = request('address','');
  57. $data['image'] = request('image','');
  58. $data['desc'] = request('desc','');
  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. $this->assign('crumbs','新增');
  70. // 加载模板
  71. return $this->fetch();
  72. }
  73. /**
  74. * 修改
  75. *
  76. * */
  77. public function edit(Request $request,Model $Model){
  78. // 接收参数
  79. $id = request('id',0);
  80. // 查询用户
  81. $oldData = $Model->where(['id'=>$id])->first();
  82. // 修改
  83. if(request()->isMethod('post')){
  84. // 验证参数
  85. $request->scene('edit')->validate();
  86. // 接收数据
  87. $data['name'] = request('name','');
  88. $data['address'] = request('address','');
  89. $data['image'] = request('image','');
  90. $data['desc'] = request('desc','');
  91. // 写入数据表
  92. $result = $Model->edit($id,$data);
  93. // 如果操作失败
  94. if( !$result ) return json_send(['code'=>'error','msg'=>'新增失败']);
  95. // 记录行为
  96. $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,2,$oldData,$data);
  97. // 告知结果
  98. return json_send(['code'=>'success','msg'=>'修改成功','action'=>'edit']);
  99. }
  100. // 错误告知
  101. if( !$oldData ) return $this->error('查无数据');
  102. // 分配数据
  103. $this->assign('oldData',$oldData);
  104. $this->assign('crumbs','修改');
  105. // 加载模板
  106. return $this->fetch();
  107. }
  108. /**
  109. * 修改状态
  110. *
  111. * */
  112. public function set_status(Request $request,Model $Model){
  113. // 验证参数
  114. $request->scene('set_status')->validate();
  115. // 设置状态
  116. $id = request('uid',0);
  117. $status = request('status',0);
  118. // 查询用户
  119. $oldData = $Model->where(['uid'=>$id])->first();
  120. // 如果用户不存在
  121. if( !$oldData ) return json_send(['code'=>'error','msg'=>'用户不存在']);
  122. // 执行修改
  123. $result = $Model->edit($id,['status'=>$status]);
  124. // 提示新增失败
  125. if( !$result ) return json_send(['code'=>'error','msg'=>'设置失败']);
  126. // 记录行为
  127. $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,2,$oldData,['status'=>$status]);
  128. // 告知结果
  129. return json_send(['code'=>'success','msg'=>'设置成功','path'=>'']);
  130. }
  131. }