��Root Mod By V1rus

Viewing: UserExport.php

<?php

namespace App\Exports;

use App\Models\FormulaUnit;
use App\Models\User;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\WithHeadings;
use Maatwebsite\Excel\Concerns\WithMapping;
use Maatwebsite\Excel\Events\AfterSheet;
use Maatwebsite\Excel\Concerns\WithEvents;
use Maatwebsite\Excel\Concerns\ShouldAutoSize;

class UserExport implements FromCollection, WithHeadings, WithEvents, ShouldAutoSize
{
    /**
     * @return \Illuminate\Support\Collection
     */
    private $platform;
    protected $resultCount;
    public $headings_array = [
        'id' => 'شناسه',
        'platform' => 'پلتفرم',
        'active' => 'فعال',
        'has_app' => 'اپلیکیشن',
        'mobile' => 'موبایل',
        'first_name' => 'نام',
        'last_name' => 'نام خانوادگی',
        'status' => 'وضعیت',
        'job' => 'شغل',
        'last_order' => 'آخرین سفارش',
        'count_orders' => 'تعداد سفارشات',
        'email' => 'ایمیل',
        'description' => 'توضیحات',
        'address' => 'آدرس',
        'payment' => 'پرداختی',
        'state_id' => 'استان',
        'city_id' => 'شهر',
        'expire_date' => 'انقضای حساب',
        'created_at' => 'ثبت نام',
    ];
    public $cols = [
        'id',
        'platform',
        'active',
        'has_app',
        'mobile',
        'first_name',
        'last_name',
        'status',
        'job',
        'last_order',
        'count_orders',
        'email',
        'description',
        'address',
        'payment',
        'state_id',
        'city_id',
        'expire_date',
        'created_at',

    ];

    public function __construct(string $platform = null)
    {
        $this->platform = $platform;
    }

    public function headings(): array
    {
        return $this->headings_array;
    }

    public function collection()
    {
        $result = User::when($this->cols, function ($q) {
            $q->select($this->cols);
        })->when($this->platform, function ($q) {
            $q->where('platform', $this->platform);
        })->with('state', 'city')->orderBy('id', 'desc')->get();

        foreach ($result as $row) {
            $row['id'] = $row->id;
            $row['platform'] = $row->platform;
            $row['active'] = $row->active;
            $row['has_app'] = $row->has_app;
            $row['mobile'] = $row->mobile;
            $row['first_name'] = $row->first_name;
            $row['last_name'] = $row->last_name;
            $row['status'] = $row->status;
            $row['job'] = $row->job;
            $row['last_order'] = $row->last_order;
            $row['count_orders'] = $row->count_orders;
            $row['email'] = $row->email;
            $row['description'] = $row->description;
            $row['address'] = $row->address;
            $row['payment'] = $row->payment;
            $row['state_id'] = $row->state?->state ?? 'ثبت نشده';
            $row['city_id'] = $row->city?->city ?? 'ثبت نشده';
            $row['expire_date'] = $row->expire_date;
            $row['created_at'] = $row->created_at;
        }
        $this->resultCount = count($result) + 1;
        return $result;
    }

    public function registerEvents(): array
    {
        $styleArray = ['font' => ['bold' => true]];
        return [
            AfterSheet::class =>
                function (AfterSheet $event) use ($styleArray) {
                    // bold heading
                    $event->sheet->getStyle("A1:BJ{$this->resultCount}")
                        ->applyFromArray($styleArray);
                    // change direction to rtl
                    $event->sheet->setRightToLeft(true);
                    // center all text

                    $event->sheet
                        ->getStyle("A1:BJ{$this->resultCount}")
                        ->getAlignment()->setHorizontal('center');
                },
        ];
    }
}
User / IP	: 216.73.217.78
Host / Server	: 195.214.235.115 / npln.ir
System	: Linux damavand.pws-dns.net 5.14.0-503.35.1.el9_5.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Apr 4 05:23:43 EDT 2025 x86_64
���Root Mod By V1rus_Alfa

Viewing: UserExport.php

��Root Mod By V1rus_Alfa
