Controller.php 4.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170
  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. use App\Jobs\TypingJob;
  12. use App\Jobs\GiftJob;
  13. use App\Jobs\RechargeJob;
  14. class Controller extends BaseController
  15. {
  16. use AuthorizesRequests, DispatchesJobs, ValidatesRequests;
  17. public function test(){
  18. /*$easemob = new Easemob();
  19. $rs = $easemob->push_text(1009,'标题','内容');
  20. dd($rs);*/
  21. (new RechargeJob(124))->handle();
  22. }
  23. //audio
  24. /*public function plantask(){
  25. $map = [
  26. ['plantask_status', '=' ,0],
  27. ['updatetime' , '<' ,time()-300],
  28. ];
  29. $list = DB::table('mt_user_match_audio_log')->where($map)->orderBy('id','asc')->get()->toArray();
  30. //dd($list);
  31. if(!empty($list)){
  32. foreach($list as $key => $val){
  33. $msg_id = $val->id;
  34. dispatch((new AudioJob($msg_id))->delay(0));//加入队列
  35. }
  36. //更新
  37. $ids = array_column($list,'id');
  38. $update = [
  39. 'plantask_status' => 1,
  40. ];
  41. DB::table('mt_user_match_audio_log')->whereIn('id',$ids)->update($update);
  42. }
  43. }*/
  44. //video
  45. /*public function plantask(){
  46. $map = [
  47. ['plantask_status', '=' ,0],
  48. ['updatetime' , '<' ,time()-300],
  49. ];
  50. $list = DB::table('mt_user_match_video_log')->where($map)->orderBy('id','asc')->get()->toArray();
  51. //dd($list);
  52. if(!empty($list)){
  53. foreach($list as $key => $val){
  54. $msg_id = $val->id;
  55. dispatch((new VideoJob($msg_id))->delay(0));//加入队列
  56. }
  57. //更新
  58. $ids = array_column($list,'id');
  59. $update = [
  60. 'plantask_status' => 1,
  61. ];
  62. DB::table('mt_user_match_video_log')->whereIn('id',$ids)->update($update);
  63. }
  64. }*/
  65. //typing
  66. /*public function plantask()
  67. {
  68. $map = [
  69. ['plantask_status', '=' ,0]
  70. ];
  71. $list = DB::table('mt_user_match_typing_log')->where($map)->orderBy('id','asc')->get()->toArray();
  72. //dd($list);
  73. if(!empty($list)){
  74. foreach($list as $key => $val){
  75. $msg_id = $val->id;
  76. dispatch((new TypingJob($msg_id))->delay(0));//加入队列
  77. }
  78. //更新
  79. $ids = array_column($list,'id');
  80. $update = [
  81. 'plantask_status' => 1,
  82. ];
  83. DB::table('mt_user_match_typing_log')->whereIn('id',$ids)->update($update);
  84. }
  85. }*/
  86. //gift
  87. /*public function plantask(){
  88. $map = [
  89. ['plantask_status', '=' ,0]
  90. ];
  91. $list = DB::table('mt_gift_user_typing')->where($map)->orderBy('id','asc')->get()->toArray();
  92. //dd($list);
  93. if(!empty($list)){
  94. foreach($list as $key => $val){
  95. $msg_id = $val->id;
  96. dispatch((new GiftJob($msg_id))->delay(0));//加入队列
  97. }
  98. //更新
  99. $ids = array_column($list,'id');
  100. $update = [
  101. 'plantask_status' => 1,
  102. ];
  103. DB::table('mt_gift_user_typing')->whereIn('id',$ids)->update($update);
  104. }
  105. }*/
  106. //recharge
  107. /*public function plantask(){
  108. $map = [
  109. ['table_name' ,'=', 'gold_recharge'],
  110. ['order_status' ,'=', 1],
  111. ['plantask_status' ,'=', 0],
  112. ];
  113. $list = DB::table('mt_pay_order')->where($map)->orderBy('id','asc')->get()->toArray();
  114. //dd($list);
  115. if(!empty($list)){
  116. foreach($list as $key => $val){
  117. $msg_id = $val->id;
  118. dispatch((new RechargeJob($msg_id))->delay(0));//加入队列
  119. }
  120. //更新
  121. $ids = array_column($list,'id');
  122. $update = [
  123. 'plantask_status' => 1,
  124. ];
  125. DB::table('mt_pay_order')->whereIn('id',$ids)->update($update);
  126. }
  127. }*/
  128. }