000

<?php

namespace App\Http\Controllers\Backend;

use App\Http\Controllers\Controller;
use App\Jobs\MemberImport;
use App\Models\BV;
use App\Models\Member;
use App\Models\Purchase;
use App\Models\UserExtra;
use App\Models\UserQualificationLog;
use App\Models\UserTeamsiteLicense;
use App\Models\Wallet;
use Illuminate\Http\Request;

class PayRunImportController extends Controller
{
    public function memberImport()
    {
        return view('backend.pay-run.import.member');
    }

public function memberImportStore(Request $request)
    {
        $request->validate([
            'file' => 'required|file|mimes:csv,txt',
        ]);

$file = $request->file;
        $fileName = time() . '.' . $file->getClientOriginalExtension();
        $file->move(public_path('uploads'), $fileName);
        $uploadedFilePath = public_path('uploads') . '/' . $fileName;
        MemberImport::dispatch($uploadedFilePath);
        return response()->json(['success' => true,'msg' => 'We are uploading record in backend']);
    }

public function updateUserIDInALlTable()
    {
        ini_set('memory_limit', '-1');
        ini_set('max_execution_time', '-1');

// $members = Member::where('member_id', 42898)->get();
        $members = Member::get();
        dd($members->count());
        foreach ($members as $value) {
            BV::where('user_id', $value['id'])->update(['user_id' => $value['user_id']]);
            Purchase::where('user_id', $value['id'])->update(['user_id' => $value['user_id']]);
            UserQualificationLog::where('user_id', $value['id'])->update(['user_id' => $value['user_id']]);
            UserTeamsiteLicense::where('user_id', $value['id'])->update(['user_id' => $value['user_id']]);
            UserExtra::where('user_id', $value['id'])->update(['user_id' => $value['user_id']]);
            Wallet::where('user_id', $value['id'])->update(['user_id' => $value['user_id']]);
            // WalletCompplan::where('user_id', $value['id'])->update(['user_id' => $value['user_id']]);

// change sponsor id and personal sponsor id and also clean the downline data its again calulated when the payrun call
            Member::where('sponsor_id', $value['id'])->update(['sponsor_id' => $value['user_id'], 'sponsor_ids' => null]);
            Member::where('personal_sponsor_id', $value['id'])->update(['personal_sponsor_id' => $value['user_id'], 'personal_sponsor_ids' => null]);

$value->update(['id' => $value['user_id']]);
        }
        return "Done";
    }
}