FM / Exports

/home/techb158/immovalet.com/platform/plugins/blog/src/Exports/

/home/techb158/immovalet.com/platform/plugins/blog/src/Exports

Name	Size	Mode	Actions
PostExport.php	1643	0644	edit dl rm

Edit: /home/techb158/immovalet.com/platform/plugins/blog/src/Exports/PostExport.php (1643B)

<?php

namespace Botble\Blog\Exports;

use Botble\Base\Enums\BaseStatusEnum;
use Botble\Table\Supports\TableExportHandler;
use Maatwebsite\Excel\Events\AfterSheet;
use PhpOffice\PhpSpreadsheet\Style\Alignment;

class PostExport extends TableExportHandler
{
    /**
     * {@inheritDoc}
     */
    protected function afterSheet(AfterSheet $event)
    {
        parent::afterSheet($event);

$totalRows = $this->collection->count() + 1;

$event->sheet->getDelegate()
            ->getStyle('F1:F' . $totalRows)
            ->getAlignment()
            ->setHorizontal(Alignment::HORIZONTAL_CENTER);

$event->sheet
            ->getDelegate()
            ->getStyle('C1:C' . $totalRows)
            ->getAlignment()
            ->setHorizontal(Alignment::HORIZONTAL_LEFT);

$event->sheet->getDelegate()
            ->getColumnDimension('C')
            ->setWidth(40);

for ($index = 2; $index <= $totalRows; $index++) {

$this->drawingImage($event, 'B', $index);

$status = $event->sheet->getDelegate()
                ->getStyle('G' . $index)
                ->getFont()
                ->getColor();

$value = $event->sheet->getDelegate()
                ->getCell('G' . $index)
                ->getValue();

if ($value == BaseStatusEnum::PUBLISHED) {
                $status->setARGB('1d9977');
            } else {
                $status->setARGB('dc3545');
            }

$event->sheet
                ->getDelegate()
                ->getCell('G' . $index)
                ->setValue(BaseStatusEnum::getLabel($value));
        }
    }
}

collection->count() + 1; $event->sheet->getDelegate() ->getStyle('F1:F' . $totalRows) ->getAlignment() ->setHorizontal(Alignment::HORIZONTAL_CENTER); $event->sheet ->getDelegate() ->getStyle('C1:C' . $totalRows) ->getAlignment() ->setHorizontal(Alignment::HORIZONTAL_LEFT); $event->sheet->getDelegate() ->getColumnDimension('C') ->setWidth(40); for ($index = 2; $index <= $totalRows; $index++) { $this->drawingImage($event, 'B', $index); $status = $event->sheet->getDelegate() ->getStyle('G' . $index) ->getFont() ->getColor(); $value = $event->sheet->getDelegate() ->getCell('G' . $index) ->getValue(); if ($value == BaseStatusEnum::PUBLISHED) { $status->setARGB('1d9977'); } else { $status->setARGB('dc3545'); } $event->sheet ->getDelegate() ->getCell('G' . $index) ->setValue(BaseStatusEnum::getLabel($value)); } } }