aDriv4 website!

Linux premium262.web-hosting.com 4.18.0-553.45.1.lve.el8.x86_64 #1 SMP Wed Mar 26 12:08:09 UTC 2025 x86_64
LiteSpeed
67.223.118.65

File Name : UsersExport.php

<?php

namespace App\Exports;

use App\User;
use App\SubscriptionPlan;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\WithHeadings;
use Maatwebsite\Excel\Concerns\ShouldAutoSize;
use Maatwebsite\Excel\Concerns\WithEvents;
use Maatwebsite\Excel\Events\AfterSheet;
use Maatwebsite\Excel\Concerns\WithMapping;
use Maatwebsite\Excel\Concerns\FromQuery;
use Maatwebsite\Excel\Concerns\Exportable;

class UsersExport implements FromCollection, WithHeadings, ShouldAutoSize , WithEvents, WithMapping,FromQuery
{
    use Exportable;
    
    public function query()
    {
         ini_set('memory_limit', '1024M');
        return User::where("usertype", "=","User")->orderBy('id')->get(['id','name','email','phone','plan_id','exp_date','plan_amount']);
    }

public function collection()
    {
          
                return User::where("usertype", "=","User")->orderBy('id')->get(['id','name','email','phone','plan_id','exp_date','plan_amount']);
           
    }

public function map($users): array
    {
        return [             
            $users->id,
            $users->name,
            $users->email,
            $users->phone,
            SubscriptionPlan::getSubscriptionPlanInfo($users->plan_id,'plan_name'),
            date('m-d-Y',$users->exp_date),
             $users->plan_amount
            
        ];
    }

public function headings(): array
    {
        return [
            '#',
            'Name',
            'Email',
            'Phone',
            'Plan',
            'Exp Date',           
            'Amount'
        ];
    }

public function registerEvents(): array
    {
        return [
            AfterSheet::class    => function(AfterSheet $event) {
                $cellRange = 'A1:H1'; // All headers
                $event->sheet->getDelegate()->getStyle($cellRange)->getFont()->setSize(14);
            },
        ];
    }

}

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	soliqmqs/soliqmqs	0755	2024-10-17 05:04:44
..	dir	-	soliqmqs/soliqmqs	0755	2024-10-17 05:04:44
TransactionsExport.php	text/x-php	2.77 KB	soliqmqs/soliqmqs	0644	2024-01-08 05:53:28
UsersExport.php	text/x-php	1.87 KB	soliqmqs/soliqmqs	0644	2024-10-17 07:21:58

For more Private tool come to me!

https://t.me/aDriv4vz