ONE PIECE HACKING

Ngiler SH3LL 360
: / home / tbf / tbfguestbe.tbf.ro / app / Console / Commands /

Information Server
MySQL : OFF Perl : OFF CURL : ON WGET : OFF PKEXEC : OFF

Directive	Local Value
IP Address	89.40.16.97
System	Linux server.atelieruldeit.ro 3.10.0-1160.el7.x86_64 #1 SMP Mon Oct 19 16:18:59 UTC 2020 x86_64
User	tbf
PHP Version	7.3.33
Software	Apache
Doc root	Writable

Edit File : ImportInstanceAndUserFromCSV.php \| Size : 3.35 KB
<?php namespace App\Console\Commands; use App\Mail\AdminCreatedMail; use App\Models\Instance; use App\Models\Role; use App\Models\User; use Illuminate\Console\Command; use Illuminate\Support\Facades\Auth; use Illuminate\Support\Facades\Log; use Illuminate\Support\Facades\Mail; use Illuminate\Support\Facades\Storage; use Str; class ImportInstanceAndUserFromCSV extends Command { /** * The name and signature of the console command. * * @var string / protected $signature = 'import:first:users'; /* * The console command description. * * @var string / protected $description = 'Command description'; /* * Execute the console command. */ public function handle() { $file =storage_path('import/parteneri.csv'); $records = array_map('str_getcsv', file($file)); $admin = Role::find(Role::SUPER_ADMIN)->users()->first(); // Incerc sa fac login cu userul de admin de pe instanta if (Auth::loginUsingId($admin->id)) { $this->info('Autentificare reușită! - ' . auth()->user()->email); } else { $this->error('Autentificare esuata! - ' . $admin?->email); dd('exit fara procesare'); } foreach ($records as $key => $line) { if ($key === 0) { continue; // Sari peste prima iterație } $this->info('-----------------\|' . $key); $user = User::where('email', trim($line[2]))->first(); if ($user) { $this->info('User existent - ' . $user->email); continue; } $instance = Instance::where('name', trim($line[0]))->first(); if (!$instance) { $instance = Instance::create(['name' => trim($line[0])]); $this->info('Instanta creata - ' . $instance->id); } else { $this->info('Instanta existenta - ' . $instance->id); } // generate random password for user $randPassword = Str::random(12, [ 'alpha' => true, 'numeric' => true, ]); $userData['password'] = bcrypt($randPassword); $userData['role_id'] = Role::ADMIN; $userData['first_name'] = trim($line[1]); $userData['email'] = trim($line[2]); $userData['instance_id'] = $instance->id; $modules = []; if (trim($line[3]) == "1") { array_push($modules, 1); } if (trim($line[4]) == "1") { array_push($modules, 2); } if (trim($line[5]) == "1") { array_push($modules, 3); } if (trim($line[6]) == "1") { array_push($modules, 4); } $userData['module_ids'] = $modules; $this->info('User ce urmeaza creat - ' . json_encode($userData)); $user = User::create($userData); $this->info('User creat - ' . $user->email . ' \| #'.$user->id); $this->info('Adauga trimiterea de email in queue'); Mail::to($user)->queue(new AdminCreatedMail($user)); $this->info('Asociaza module - ' . json_encode($modules)); $user->modules()->sync($userData['module_ids']); } } } Back

Edit File : ImportInstanceAndUserFromCSV.php | Size : 3.35 KB

<?php

namespace App\Console\Commands;

use App\Mail\AdminCreatedMail;
use App\Models\Instance;
use App\Models\Role;
use App\Models\User;
use Illuminate\Console\Command;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\Log;
use Illuminate\Support\Facades\Mail;
use Illuminate\Support\Facades\Storage;
use Str;

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

/**
     * The console command description.
     *
     * @var string
     */
    protected $description = 'Command description';

/**
     * Execute the console command.
     */
    public function handle()
    {
        $file =storage_path('import/parteneri.csv');
        $records = array_map('str_getcsv', file($file));

$admin = Role::find(Role::SUPER_ADMIN)->users()->first();
       
        // Incerc sa fac login cu userul de admin de pe instanta
        if (Auth::loginUsingId($admin->id)) {
            $this->info('Autentificare reușită! - ' . auth()->user()->email);
        } else {
            $this->error('Autentificare esuata! - ' . $admin?->email);
            dd('exit fara procesare');
        }

foreach ($records as $key => $line) {
            if ($key === 0) {
                continue; // Sari peste prima iterație
            }

$this->info('-----------------|' . $key);

$user = User::where('email', trim($line[2]))->first();
            if ($user) {
                $this->info('User existent - ' . $user->email);
                continue;
            }

$instance = Instance::where('name', trim($line[0]))->first();
            if (!$instance) {
                $instance = Instance::create(['name' => trim($line[0])]);
                $this->info('Instanta creata - ' . $instance->id);
            } else {
                $this->info('Instanta existenta - ' . $instance->id);
            }

// generate random password for user
            $randPassword = Str::random(12, [
                'alpha' => true,
                'numeric' => true,
            ]);
			$userData['password'] = bcrypt($randPassword);
			$userData['role_id'] = Role::ADMIN;
            $userData['first_name'] = trim($line[1]);
            $userData['email'] = trim($line[2]);
            $userData['instance_id'] = $instance->id;

$modules = [];

if (trim($line[3]) == "1") {
                array_push($modules, 1);
            }
            if (trim($line[4]) == "1") {
                array_push($modules, 2);
            }
            if (trim($line[5]) == "1") {
                array_push($modules, 3);
            }
            if (trim($line[6]) == "1") {
                array_push($modules, 4);
            }

$userData['module_ids'] = $modules;

$this->info('User ce urmeaza creat - ' . json_encode($userData));
            $user = User::create($userData);
            
            $this->info('User creat - ' . $user->email . ' | #'.$user->id);
            
            
            $this->info('Adauga trimiterea de email in queue');
            Mail::to($user)->queue(new AdminCreatedMail($user));
            
            $this->info('Asociaza module - ' . json_encode($modules));
            $user->modules()->sync($userData['module_ids']);
        }
    }
}

Back