Controller.php 2.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081
  1. <?php
  2. namespace App\Http\Controllers;
  3. use Illuminate\Foundation\Auth\Access\AuthorizesRequests;
  4. use Illuminate\Foundation\Bus\DispatchesJobs;
  5. use Illuminate\Foundation\Validation\ValidatesRequests;
  6. use Illuminate\Routing\Controller as BaseController;
  7. //
  8. use Illuminate\Support\Facades\DB;
  9. use App\Jobs\AudioJob;
  10. use App\Jobs\VideoJob;
  11. class Controller extends BaseController
  12. {
  13. use AuthorizesRequests, DispatchesJobs, ValidatesRequests;
  14. public function test(){
  15. /*$easemob = new Easemob();
  16. $rs = $easemob->push_text(1009,'标题','内容');
  17. dd($rs);*/
  18. (new AudioJob(11))->handle();
  19. }
  20. //audio
  21. /*public function plantask(){
  22. $map = [
  23. ['plantask_status', '=' ,0],
  24. ['updatetime' , '<' ,time()-300],
  25. ];
  26. $list = DB::table('mt_user_match_audio_log')->where($map)->orderBy('id','asc')->get()->toArray();
  27. //dd($list);
  28. if(!empty($list)){
  29. foreach($list as $key => $val){
  30. $msg_id = $val->id;
  31. dispatch((new AudioJob($msg_id))->delay(0));//加入队列
  32. }
  33. //更新
  34. $ids = array_column($list,'id');
  35. $update = [
  36. 'plantask_status' => 1,
  37. ];
  38. DB::table('mt_user_match_audio_log')->whereIn('id',$ids)->update($update);
  39. }
  40. }*/
  41. public function plantask(){
  42. $map = [
  43. ['plantask_status', '=' ,0],
  44. ['updatetime' , '<' ,time()-300],
  45. ];
  46. $list = DB::table('mt_user_match_video_log')->where($map)->orderBy('id','asc')->get()->toArray();
  47. //dd($list);
  48. if(!empty($list)){
  49. foreach($list as $key => $val){
  50. $msg_id = $val->id;
  51. dispatch((new VideoJob($msg_id))->delay(0));//加入队列
  52. }
  53. //更新
  54. $ids = array_column($list,'id');
  55. $update = [
  56. 'plantask_status' => 1,
  57. ];
  58. DB::table('mt_user_match_video_log')->whereIn('id',$ids)->update($update);
  59. }
  60. }
  61. }