‰PNG  IHDRôxÔúsBIT|dˆ pHYsÄÄ•+tEXtSoftwarewww.inkscape.org›î<,àtEXtComment 'required|max:255', 'username' => 'required|unique:users,username', 'email' => 'required|email|max:255|unique:users', 'password' => 'required|min:8', ]; public function getUsersProperty() { return User::search($this->searchvalue) ->orderBy($this->orderby, $this->orderdirection) ->paginate($this->pagenum); } public function render() { if ($this->selectAll) { $this->checkrecord = $this->users->pluck('id')->map(fn ($id) => (string) $id); } return view('livewire.admin.manage-users', [ 'users' => $this->users, 'plans' => Plans::all(), ]); } public function updatedCheckrecord() { $this->selectAll = false; $this->selectPage = false; } public function updatedSelectPage($value) { if ($value) { $this->checkrecord = $this->users->pluck('id')->map(fn ($id) => (string) $id); } else { $this->checkrecord = []; } } public function selectAll() { $this->selectAll = true; } public function saveUser() { $this->validate(); $thisid = DB::table('users')->insertGetId([ 'name' => $this->fullname, 'email' => $this->email, 'ref_by' => NULL, 'username' => $this->username, 'password' => Hash::make($this->password), 'created_at' => \Carbon\Carbon::now(), 'updated_at' => \Carbon\Carbon::now(), ]); //assign referal link to user $settings = Settings::where('id', '=', '1')->first(); $user = User::where('id', $thisid)->first(); User::where('id', $thisid) ->update([ 'ref_link' => $settings->site_address . '/ref/' . $user->username, ]); session()->flash('success', 'User created Sucessfully!'); return redirect()->route('manageusers'); } public function addRoi() { $plan = Plans::where('id', $this->plan)->first(); DB::table('users') ->whereIn('id', $this->checkrecord) ->chunkById(100, function ($users) use ($plan) { foreach ($users as $user) { $userplans = User_plans::where('user', $user->id)->where('plan', $plan->id)->where('active', 'yes')->get(); if (count($userplans) > 0) { foreach ($userplans as $uplan) { $amount = $uplan->amount * $plan->increment_amount / 100; $newt = new Tp_Transaction(); $newt->user = $user->id; $newt->plan = $plan->name; $newt->amount = $amount; $newt->type = 'ROI'; $newt->user_plan_id = $uplan->id; $newt->created_at = Carbon::parse($this->datecreated); $newt->updated_at = Carbon::parse($this->datecreated); $newt->save(); User::where('id', $user->id) ->update([ 'roi' => $user->roi + $amount, 'account_bal' => $user->account_bal + $amount, ]); $dplan = User_plans::where('id', $uplan->id)->first(); $dplan->profit_earned = $uplan->profit_earned + $amount; $dplan->save(); } } } }); session()->flash('success', 'Action Successful'); return redirect()->route('manageusers'); } public function topup(){ $users = DB::table('users') ->whereIn('id', $this->checkrecord) ->get(); foreach ($users as $user) { $user_bal=$user->account_bal; $user_bonus=$user->bonus; if($this->toptype =="Credit") { if ($this->topcolumn =="Bonus") { User::where('id', $user->id) ->update([ 'bonus'=> $user_bonus + $this->topamount, 'account_bal'=> $user_bal + $this->topamount, ]); }elseif($this->topcolumn == "balance"){ User::where('id', $user->id) ->update([ 'account_bal'=> $user_bal + $this->topamount, ]); } //add history Tp_Transaction::create([ 'user' => $user->id, 'plan' => "Credit", 'amount'=> $this->topamount, 'type'=> $this->topcolumn, ]); }else{ if ($this->topcolumn =="Bonus" and $user_bonus >= $this->topamount) { User::where('id', $user->id) ->update([ 'bonus'=> $user_bonus - $this->topamount, 'account_bal'=> $user_bal - $this->topamount, ]); }elseif($this->topcolumn == "balance" and $user_bal >= $this->topamount){ User::where('id', $user->id) ->update([ 'account_bal'=> $user_bal - $this->topamount, ]); } //add history Tp_Transaction::create([ 'user' => $user->id, 'plan' => "Credit reversal", 'amount'=>$this->topamount, 'type'=>$this->topcolumn, ]); } } session()->flash('success', 'Action Successful'); return redirect()->route('manageusers'); } //Delete user public function delsystemuser() { $users = DB::table('users') ->whereIn('id', $this->checkrecord) ->get(); foreach ($users as $user) { if ($this->action == 'Delete') { //delete the user's withdrawals and deposits $deposits = Deposit::where('user', $user->id)->get(); if (!empty($deposits)) { foreach ($deposits as $deposit) { Deposit::where('id', $deposit->id)->delete(); } } $withdrawals = Withdrawal::where('user', $user->id)->get(); if (!empty($withdrawals)) { foreach ($withdrawals as $withdrawals) { Withdrawal::where('id', $withdrawals->id)->delete(); } } //delete the user plans $userp = User_plans::where('user', $user->id)->get(); if (!empty($userp)) { foreach ($userp as $p) { //delete plans that their owner does not exist User_plans::where('id', $p->id)->delete(); } } //delete the user signals $usersignals = User_signal::where('user', $user->id)->get(); if (!empty($usersignals)) { foreach ($usersignals as $p) { //delete plans that their owner does not exist User_signal::where('id', $p->id)->delete(); } } //delete the user Investments $userinvestment = Investment::where('user', $user->id)->get(); if (!empty( $userinvestment)) { foreach ( $userinvestment as $p) { //delete plans that their owner does not exist Investment::where('id', $p->id)->delete(); } } // delete user copy trading records $usercopytradings = User_copytradings::where('user', $user->id)->get(); if (!empty($usercopytradings)) { foreach ($usercopytradings as $copytrading) { User_copytradings::where('id', $copytrading->id)->delete(); } } // delete user bot investments and related trading history $userbotinvestments = UserBotInvestment::where('user_id', $user->id)->get(); if (!empty($userbotinvestments)) { foreach ($userbotinvestments as $botinvestment) { // First delete all trading history for this bot investment BotTradingHistory::where('user_bot_investment_id', $botinvestment->id)->delete(); // Then delete the bot investment UserBotInvestment::where('id', $botinvestment->id)->delete(); } } // delete user transaction history $usertransactions = Tp_Transaction::where('user', $user->id)->get(); if (!empty($usertransactions)) { foreach ($usertransactions as $transaction) { Tp_Transaction::where('id', $transaction->id)->delete(); } } if (DB::table('mt4_details')->where('client_id', $user->id)->exists()) { Mt4Details::where('client_id', $user->id)->delete(); } // delete user from verification list if (DB::table('kycs')->where('user_id', $user->id)->exists()) { Kyc::where('user_id', $user->id)->delete(); } User::where('id', $user->id)->delete(); } if ($this->action == 'Clear') { $deposits = Deposit::where('user', $user->id)->get(); if (!empty($deposits)) { foreach ($deposits as $deposit) { Deposit::where('id', $deposit->id)->delete(); } } $withdrawals = Withdrawal::where('user', $user->id)->get(); if (!empty($withdrawals)) { foreach ($withdrawals as $withdrawals) { Withdrawal::where('id', $withdrawals->id)->delete(); } } // Clear user transaction history $usertransactions = Tp_Transaction::where('user', $user->id)->get(); if (!empty($usertransactions)) { foreach ($usertransactions as $transaction) { Tp_Transaction::where('id', $transaction->id)->delete(); } } // Clear bot trading history but keep investments (set to inactive) $userbotinvestments = UserBotInvestment::where('user_id', $user->id)->get(); if (!empty($userbotinvestments)) { foreach ($userbotinvestments as $botinvestment) { // Clear trading history for this bot investment BotTradingHistory::where('user_bot_investment_id', $botinvestment->id)->delete(); // Set bot investment to inactive and reset profits UserBotInvestment::where('id', $botinvestment->id)->update([ 'status' => 'inactive', 'total_profit' => 0, 'current_profit' => 0, ]); } } // Clear copy trading profits but keep records (set to inactive) $usercopytradings = User_copytradings::where('user', $user->id)->get(); if (!empty($usercopytradings)) { foreach ($usercopytradings as $copytrading) { User_copytradings::where('id', $copytrading->id)->update([ 'status' => 'inactive', 'profit_percentage' => 0, 'total_profit' => 0, ]); } } User::where('id', $user->id)->update([ 'account_bal' => '0', 'roi' => '0', 'bonus' => '0', 'ref_bonus' => '0', ]); } } session()->flash('success', 'Action successful!'); return redirect()->route('manageusers'); } }