CheckCommission.php 2.1 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485
  1. <?php
  2. namespace App\Console\Commands;
  3. use Illuminate\Console\Command;
  4. use App\Models\Order;
  5. use App\Models\User;
  6. use Illuminate\Support\Facades\DB;
  7. class CheckCommission extends Command
  8. {
  9. /**
  10. * The name and signature of the console command.
  11. *
  12. * @var string
  13. */
  14. protected $signature = 'check:commission';
  15. /**
  16. * The console command description.
  17. *
  18. * @var string
  19. */
  20. protected $description = '返佣服务';
  21. /**
  22. * Create a new command instance.
  23. *
  24. * @return void
  25. */
  26. public function __construct()
  27. {
  28. parent::__construct();
  29. }
  30. /**
  31. * Execute the console command.
  32. *
  33. * @return mixed
  34. */
  35. public function handle()
  36. {
  37. $this->autoCheck();
  38. $this->autoPayCommission();
  39. }
  40. public function autoCheck()
  41. {
  42. if ((int)config('v2board.commission_auto_check_enable', 1)) {
  43. Order::where('commission_status', 0)
  44. ->where('invite_user_id', '!=', NULL)
  45. ->whereNotIn('status', [0, 2])
  46. ->where('updated_at', '<=', strtotime('-3 day', time()))
  47. ->update([
  48. 'commission_status' => 1
  49. ]);
  50. }
  51. }
  52. public function autoPayCommission()
  53. {
  54. $order = Order::where('commission_status', 1)
  55. ->where('invite_user_id', '!=', NULL)
  56. ->get();
  57. foreach ($order as $item) {
  58. $inviter = User::find($item->invite_user_id);
  59. if (!$inviter) continue;
  60. if ((int)config('v2board.withdraw_close_enable', 0)) {
  61. $inviter->balance = $inviter->balance + $item->commission_balance;
  62. } else {
  63. $inviter->commission_balance = $inviter->commission_balance + $item->commission_balance;
  64. }
  65. DB::beginTransaction();
  66. if ($inviter->save()) {
  67. $item->commission_status = 2;
  68. if (!$item->save()) {
  69. DB::rollBack();
  70. continue;
  71. }
  72. DB::commit();
  73. }
  74. }
  75. }
  76. }