<?php

namespace App\Console\Commands;

use Illuminate\Console\Command;
use Illuminate\Support\Facades\DB;
use Yajny\Member\Models\Click;
use Yajny\Member\Models\Member;
use Yajny\Member\Models\Sale;

class FixOldOrdersUsers extends Command
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'users:fix_old_orders_flag';

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = 'Fix Old order users';

    /**
     * Execute the console command.
     *
     * @return void
     */
    public function handle()
    {
        $orders= Sale::where('created_at', '<', '2022-11-19 00:00:00')
            ->where('status', 'confirmed')
            ->where('confirmed',0)->select(['id','click_id'])->limit(1000)->get();
        $clickIds = [];
        $userIds = [];
        $orderIds = [];
        foreach ($orders as $order) {
            $clickIds[] = $order->click_id;
            $orderIds[] = $order->id;
        }
        $clicks = DB::table('clicks')->whereIn('id', $clickIds)->select('user_id')->get();
        foreach ($clicks as $click) {
            $userIds[]=$click->user_id;
        }
        DB::table('users')->whereIn('user_id', $userIds)->update(['has_old_orders'=>1]);
        DB::table('sales')->whereIn('id', $orderIds)->update(['confirmed'=>1]);
    }
}