ONE PIECE HACKING

Ngiler SH3LL 360
: / home / tbf / tbfguestbe.tbf.ro / app / Http / Controllers / Api /

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 : ReportController.php \| Size : 5.28 KB
<?php namespace App\Http\Controllers\Api; use App\Exports\ActivitiesXlsExport; use App\Exports\ResponsibilitiesXlsExport; use App\Http\Controllers\Controller; use App\Managers\WordExportManager; use App\Models\Instance; use Barryvdh\DomPDF\Facade\Pdf; use Maatwebsite\Excel\Facades\Excel; use App\Models\GuestCentralizer; use Storage; class ReportController extends Controller { /** * Export Activities generate by AI to excel * * @param Instance $instance * * @return JsonResponse / public function exportActivities(Instance $instance) { $activities = $instance->activities()->where('generated_by_ai', 1)->get(); $fileName = __('general.activities.export_filename') . '.xlsx'; return Excel::download(new ActivitiesXlsExport($activities), $fileName); } /* * Export Responsibilities to excel * * @param Instance $instance * * @return JsonResponse / public function exportResponsibilities(Instance $instance) { $responsibilities = $instance->responsibilities()->get(); $fileName = __('general.responsibilities.export_filename') . '.xlsx'; return Excel::download(new ResponsibilitiesXlsExport($responsibilities), $fileName); } /* * Export Responsibilities to Word * * @param Instance $instance * * @return JsonResponse / public function exportResponsibilitiesDoc(Instance $instance) { $wordExportService = new WordExportManager(); $wordExportService->exportResponsibilities($instance); } /* * Export Procedures to word * * @param Instance $instance * * @return JsonResponse / public function exportProcedures(Instance $instance) { $wordExportService = new WordExportManager(); $wordExportService->exportProcedures($instance); } /* * Export Procedure Manual to Word * * @param Instance $instance * * @return JsonResponse / public function exportProceduresManuals(Instance $instance) { $wordExportService = new WordExportManager(); $wordExportService->exportProcedureManuals($instance); } /* * Export Sale process to word * * @param Instance $instance * * @return JsonResponse / public function exportSaleProcess(Instance $instance) { $wordExportService = new WordExportManager(); $wordExportService->exportSaleProcess($instance); } /* * Export Recruitment to Word * * @param Instance $instance * * @return JsonResponse / public function exportRecruitment(Instance $instance) { $wordExportService = new WordExportManager(); $wordExportService->exportRecruitment($instance); } /* * Export Sale process to PDF * * @param Instance $instance * * @return JsonResponse */ public function exportSaleProcessResource(Instance $instance) { $hexColor = $instance->saleProcessPages?->first()->color ?? '#3CACF8'; $logo = $instance->saleProcessPages?->first()?->logo; $rgb = hexToRgb($hexColor); $title = $instance->saleProcessResources?->first()->headline; $company = [ 'name' => $instance->name, 'website' => $instance->website, 'email' => $instance->email, 'phone' => $instance->phone, ]; $items = $instance->saleProcessResources?->first()->items; $svg = '<svg xmlns="http://www.w3.org/2000/svg" width="100" height="100" viewBox="0 0 100 100"> <polygon points="100,100 0,100 100,0" fill="' . $hexColor . '" /> </svg> '; $imgTriangle = '<img src="data:image/svg+xml;base64,' . base64_encode($svg) . '" class="triangle-img" />'; $pdf2 = Pdf::loadView('pdf.resource_header', compact('title', 'items', 'rgb', 'hexColor', 'imgTriangle', 'company', 'logo')); return $pdf2->download('resursa-gratuita.pdf'); } public function exportQrInvitation() { $emailsToExclude = ['ana_pastrav@heist-industries.com']; // Adresele de email pe care vrei să le excluzi $guests_from_db = GuestCentralizer::whereNotIn('email', $emailsToExclude)->get(); $uniqueGuests = $guests_from_db->unique('email'); foreach ($uniqueGuests as $guest) { var_dump($guest->email); $guests = GuestCentralizer::where('email',$guest->email)->get(); var_dump($guests->count()); $entry_gate = 'A3S2'; $pdf2 = Pdf::loadView('pdf.qr_invitation', compact('entry_gate', 'guests')); // $filePath = Storage::path('public/invitations/invitatie-'.$guest->invitation_id.'.pdf'); // $pdf2->save($filePath); $pdf2->save('invitatie-'.$guest->invitation_id.'.pdf'); // Trimitem email // Mail::to('alex@tbf.ro')->send(new SendInvitationEmail($filePath)); // dd(1); // Actualizam in baza de date statusul } return "marius"; // return $pdf2->download('tbf-party-2023-invitation.pdf'); // return $pdf2->stream('tbf-party-2023-invitation.pdf'); } } Back

Edit File : ReportController.php | Size : 5.28 KB

<?php

namespace App\Http\Controllers\Api;

use App\Exports\ActivitiesXlsExport;
use App\Exports\ResponsibilitiesXlsExport;
use App\Http\Controllers\Controller;
use App\Managers\WordExportManager;
use App\Models\Instance;
use Barryvdh\DomPDF\Facade\Pdf;
use Maatwebsite\Excel\Facades\Excel;
use App\Models\GuestCentralizer;
use Storage;

class ReportController extends Controller
{
    /**
     * Export Activities generate by AI to excel
     * 
     * @param Instance $instance
     * 
     * @return JsonResponse
     */
    public function exportActivities(Instance $instance)
    {
        $activities = $instance->activities()->where('generated_by_ai', 1)->get();

$fileName = __('general.activities.export_filename') . '.xlsx';

return Excel::download(new ActivitiesXlsExport($activities), $fileName);
    }

/**
     * Export Responsibilities to excel
     * 
     * @param Instance $instance
     * 
     * @return JsonResponse
     */
    public function exportResponsibilities(Instance $instance)
    {
        $responsibilities = $instance->responsibilities()->get();

$fileName = __('general.responsibilities.export_filename') . '.xlsx';

return Excel::download(new ResponsibilitiesXlsExport($responsibilities), $fileName);
    }

/**
     * Export Responsibilities to Word
     * 
     * @param Instance $instance
     * 
     * @return JsonResponse
     */
    public function exportResponsibilitiesDoc(Instance $instance)
    {
        $wordExportService = new WordExportManager();
        $wordExportService->exportResponsibilities($instance);
    }

/**
     * Export Procedures to word
     * 
     * @param Instance $instance
     * 
     * @return JsonResponse
     */
    public function exportProcedures(Instance $instance)
    {
        $wordExportService = new WordExportManager();
        $wordExportService->exportProcedures($instance);
    }

/**
     * Export Procedure Manual to Word
     * 
     * @param Instance $instance
     * 
     * @return JsonResponse
     */
    public function exportProceduresManuals(Instance $instance)
    {
        $wordExportService = new WordExportManager();
        $wordExportService->exportProcedureManuals($instance);
    }

/**
     * Export Sale process to word
     * 
     * @param Instance $instance
     * 
     * @return JsonResponse
     */
    public function exportSaleProcess(Instance $instance)
    {
        $wordExportService = new WordExportManager();
        $wordExportService->exportSaleProcess($instance);
    }

/**
     * Export Recruitment to Word
     * 
     * @param Instance $instance
     * 
     * @return JsonResponse
     */
    public function exportRecruitment(Instance $instance)
    {
        $wordExportService = new WordExportManager();
        $wordExportService->exportRecruitment($instance);
    }

/**
     * Export Sale process to PDF
     * 
     * @param Instance $instance
     * 
     * @return JsonResponse
     */
    public function exportSaleProcessResource(Instance $instance)
    {
        $hexColor = $instance->saleProcessPages?->first()->color ?? '#3CACF8';
        $logo = $instance->saleProcessPages?->first()?->logo;
        $rgb = hexToRgb($hexColor);
        $title = $instance->saleProcessResources?->first()->headline;
        $company = [
            'name' => $instance->name,
            'website' => $instance->website,
            'email' => $instance->email,
            'phone' => $instance->phone,
        ];

$items = $instance->saleProcessResources?->first()->items;
        $svg = '<svg xmlns="http://www.w3.org/2000/svg" width="100" height="100" viewBox="0 0 100 100">
            <polygon points="100,100 0,100 100,0" fill="' . $hexColor . '" />
        </svg>
        ';

$imgTriangle = '<img src="data:image/svg+xml;base64,' . base64_encode($svg) . '"  class="triangle-img" />';

$pdf2 = Pdf::loadView('pdf.resource_header', compact('title', 'items', 'rgb', 'hexColor', 'imgTriangle', 'company', 'logo'));
        return $pdf2->download('resursa-gratuita.pdf');
    }

public function exportQrInvitation()
    {
        $emailsToExclude = ['ana_pastrav@heist-industries.com']; // Adresele de email pe care vrei să le excluzi
        
        $guests_from_db = GuestCentralizer::whereNotIn('email', $emailsToExclude)->get();
        $uniqueGuests = $guests_from_db->unique('email');

foreach ($uniqueGuests as $guest) {
            var_dump($guest->email);
            $guests = GuestCentralizer::where('email',$guest->email)->get();
            var_dump($guests->count());
            
            $entry_gate = 'A3S2';
            $pdf2 = Pdf::loadView('pdf.qr_invitation', compact('entry_gate', 'guests'));

// $filePath = Storage::path('public/invitations/invitatie-'.$guest->invitation_id.'.pdf');
    
            // $pdf2->save($filePath);
            $pdf2->save('invitatie-'.$guest->invitation_id.'.pdf');
            
            
            // Trimitem email
            // Mail::to('alex@tbf.ro')->send(new SendInvitationEmail($filePath));
            // dd(1);            
            
            // Actualizam in baza de date statusul
            
        }

return "marius";
    // return $pdf2->download('tbf-party-2023-invitation.pdf');
        
        // return $pdf2->stream('tbf-party-2023-invitation.pdf');
    }
}

Back