1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980 |
- <?php
- namespace App\Console\Commands;
- use App\Components\Helpers;
- use App\Http\Models\Order;
- use App\Http\Models\User;
- use Illuminate\Console\Command;
- use Log;
- class AutoResetUserTraffic extends Command
- {
- protected $signature = 'autoResetUserTraffic';
- protected $description = '自动重置用户可用流量';
- protected static $systemConfig;
- public function __construct()
- {
- parent::__construct();
- self::$systemConfig = Helpers::systemConfig();
- }
- public function handle()
- {
- $jobStartTime = microtime(TRUE);
- // 重置用户流量
- if(self::$systemConfig['reset_traffic']){
- $this->resetUserTraffic();
- }
- $jobEndTime = microtime(TRUE);
- $jobUsedTime = round(($jobEndTime-$jobStartTime), 4);
- Log::info('执行定时任务【'.$this->description.'】,耗时'.$jobUsedTime.'秒');
- }
- // 重置用户流量
- private function resetUserTraffic()
- {
- $userList = User::query()->where('status', '>=', 0)->where('expire_time', '>=', date('Y-m-d'))->get();
- if(!$userList->isEmpty()){
- foreach($userList as $user){
- if(!$user->traffic_reset_day){
- continue;
- }
- // 取出用户购买的有效套餐
- $order = Order::query()
- ->with(['user', 'goods'])
- ->whereHas('goods', function($q){
- $q->where('type', 2);
- })
- ->where('user_id', $user->id)
- ->where('is_expire', 0)
- ->orderBy('oid', 'desc')
- ->first();
- if(!$order){
- continue;
- }
- $month = date('m');
- $today = date('d');
- $last_day = date('t');
- $resetDay = $order->user->traffic_reset_day;
- if($resetDay == $today || ($today == $last_day && $resetDay > $last_day)){
- // 跳过本月,防止异常重置
- if($month == date('m', strtotime($order->expire_at))){
- continue;
- }elseif($month == date('m', strtotime($order->created_at))){
- continue;
- }
- // 重置流量
- User::query()->where('id', $user->id)->update(['u' => 0, 'd' => 0, 'transfer_enable' => $order->goods->traffic*1048576]);
- }
- }
- }
- }
- }
|