VideoCourse.php 5.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172
  1. <?php namespace App\Http\Controllers\Admin;
  2. use App\Facades\Servers\Aliyun\Oss;
  3. use App\Http\Requests\Admin\Video\Course as Request;
  4. use App\Models\Video\Course as Model;
  5. use App\Models\Video\CourseType;
  6. /**
  7. * 课程管理
  8. *
  9. * @author huanglei
  10. *
  11. */
  12. class VideoCourse extends Auth{
  13. protected function _initialize(){
  14. parent::_initialize();
  15. $this->assign('breadcrumb1','课程管理');
  16. $this->assign('breadcrumb2','课程列表');
  17. }
  18. /**
  19. * 首页列表
  20. *
  21. * */
  22. public function index(Model $Model,CourseType $CourseType){
  23. // 接受参数
  24. $name = request('name','');
  25. $status = request('status');
  26. $startTime = request('start_time','');
  27. $endTime = request('end_time','');
  28. // 查询条件
  29. $map = [];
  30. // 编码ID
  31. if( $name ) $map[] = ['name','LIKE','%'.$name.'%'];
  32. if( $startTime ) $map[] = ['insert_time','>=',strtotime($startTime)];
  33. if( $endTime ) $map[] = ['insert_time','<=',strtotime($endTime)];
  34. if( !is_null($status) ) $map[] = ['status','=',$status];
  35. // 查询数据
  36. $list = $Model->query()->where($map)->orderByDesc('id')->paginate(request('limit',config('page_num',10)))->appends(request()->all());
  37. // 循环处理数据
  38. foreach ($list as $key => $value) {
  39. // 类型名称
  40. $value['type_name'] = $CourseType->getOne($value['type_id'],'name');
  41. // 重组
  42. $list[$key] = $value;
  43. }
  44. // 分配数据
  45. $this->assign('empty', '<tr><td colspan="20">~~暂无数据</td></tr>');
  46. $this->assign('list', $list);
  47. // 加载模板
  48. return $this->fetch();
  49. }
  50. /**
  51. * 添加
  52. *
  53. * */
  54. public function add( Request $request, Model $Model,CourseType $CourseType){
  55. if( request()->isMethod('post') ){
  56. // 验证参数
  57. $request->scene('add')->validate();
  58. // 组合数据
  59. $data['thumb'] = request('thumb','');
  60. $data['video_src'] = request('video_src','');
  61. $data['name'] = request('name','');
  62. $data['content'] = request('content','');
  63. $data['start_time'] = request('start_time','');
  64. $data['end_time'] = request('end_time','');
  65. $data['type_id'] = request('type_id',0);
  66. $data['start_time'] = $data['start_time'] ? strtotime($data['start_time']) : 0;
  67. $data['end_time'] = $data['end_time'] ? strtotime($data['end_time']) : 0;
  68. $data['status'] = 1;
  69. // 写入
  70. $id = $Model->add($data);
  71. // 提示新增失败
  72. if( !$id ) return json_send(['code'=>'error','msg'=>'新增失败']);
  73. // 记录行为
  74. $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,1,[],$data);
  75. // 告知结果
  76. return json_send(['code'=>'success','msg'=>'新增成功','action'=>'add']);
  77. }
  78. // 获取类型列表
  79. $typeList = $CourseType->getList();
  80. // 分配数据
  81. $this->assign('crumbs','新增');
  82. $this->assign('typeList',$typeList);
  83. // 加载模板
  84. return $this->fetch();
  85. }
  86. /**
  87. * 编辑
  88. *
  89. * */
  90. public function edit( Request $request, Model $Model,CourseType $CourseType){
  91. // 接收参数
  92. $id = request('id',0);
  93. // 查询数据
  94. $oldData = $Model->where(['id'=>$id])->first();
  95. $oldData = $oldData ? $oldData->toArray() : [];
  96. // 修改
  97. if(request()->isMethod('post')){
  98. // 验证参数
  99. $request->scene('edit')->validate();
  100. // 组合数据
  101. $data['thumb'] = request('thumb','');
  102. $data['video_src'] = request('video_src','');
  103. $data['name'] = request('name','');
  104. $data['content'] = request('content','');
  105. $data['start_time'] = request('start_time','');
  106. $data['end_time'] = request('end_time','');
  107. $data['type_id'] = request('type_id',0);
  108. $data['start_time'] = $data['start_time'] ? strtotime($data['start_time']) : 0;
  109. $data['end_time'] = $data['end_time'] ? strtotime($data['end_time']) : 0;
  110. // 写入
  111. $result = $Model->edit($id,$data);
  112. // 提示新增失败
  113. if( !$result ) return json_send(['code'=>'error','msg'=>'修改失败']);
  114. // 删除结果
  115. unset($oldData['content']);
  116. // 记录行为
  117. $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,2,$oldData,$data);
  118. // 告知结果
  119. return json_send(['code'=>'success','msg'=>'修改成功','action'=>'edit']);
  120. }
  121. // 如果是没有数据
  122. if( !$oldData ) return $this->error('查无数据');
  123. // 获取类型列表
  124. $typeList = $CourseType->getList();
  125. // 分配数据
  126. $this->assign('typeList',$typeList);
  127. $this->assign('oldData',$oldData);
  128. $this->assign('crumbs','修改');
  129. // 加载模板
  130. return $this->fetch();
  131. }
  132. /**
  133. * 状态
  134. *
  135. * */
  136. public function set_status( Request $request, Model $Model){
  137. // 验证参数
  138. $request->scene('set_status')->validate();
  139. // 接收参数
  140. $id = request('id',0);
  141. $status = request('status',0);
  142. // 查询数据
  143. $result = $Model->edit($id,['status'=>$status]);
  144. // 提示新增失败
  145. if( !$result ) return json_send(['code'=>'error','msg'=>'设置失败']);
  146. // 告知结果
  147. return json_send(['code'=>'success','msg'=>'设置成功','path'=>'']);
  148. }
  149. /**
  150. * 获取上传视频签名URL
  151. *
  152. * */
  153. public function get_sign_url() {
  154. // 获取签名URL
  155. $signUrl = Oss::signUrl('kailin-mp', 'uploads/video/'.admin('uid').'/'.date('Ymd').'/'.uniqid().'.mp4',['Content-Type'=>'']);
  156. // 如果签名失败
  157. if( !$signUrl ) return json_send(['code'=>'error','msg'=>'生成签名失败']);
  158. // 签名异常
  159. if( isset($signUrl['error']) ) return json_send(['code'=>'error','msg'=>$signUrl['error']]);
  160. // 下发
  161. return json_send(['code'=>'success','msg'=>'获取成功','data'=>['sign_url'=>$signUrl,'video_src'=>str_ireplace('?'.parse_url($signUrl,PHP_URL_QUERY),'',$signUrl)]]);
  162. }
  163. }