Gecko [ school.pilasatech.net ]

Name	Size	Permission	Date
.htaccess	237 B	-r-xr-xr-x	2026-06-11 02:58
357-20260609142552-20260609143055-20260609143201-20260609143216-20260609155409-20260609184222-20260609205835-20260609210111-20260609211035-20260609211048-20260609211101-20260609211120-20260609212311-20260609214502-20260609221004-20260609234052.	25.7 KB	-rw-r--r--	2022-09-04 08:37
CountriesExport.php	291 B	-rw-r--r--	2024-02-19 06:31
PersonalInfosExport.php	2.57 KB	-rw-r--r--	2024-02-19 06:31
error_log	1.44 KB	-rw-r--r--	2026-06-07 05:47

Rename

<?php

namespace App\Exports;

use App\Models\PersonalInfo;
use Maatwebsite\Excel\Excel;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\Exportable;
use Illuminate\Contracts\Support\Responsable;
use Maatwebsite\Excel\Concerns\WithHeadings;
use Maatwebsite\Excel\Concerns\WithTitle;
use Maatwebsite\Excel\Concerns\ShouldAutoSize;
use Maatwebsite\Excel\Concerns\WithStyles;
use PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;

class PersonalInfosExport implements FromCollection, Responsable,  WithTitle, WithHeadings, ShouldAutoSize, WithStyles
{
    use Exportable;

/**
    * Exportable: We can now download the export without 
    * the need for the facade: Excel::download
    * Responsable: You can now easily return the export class,
    * without the need of calling ->download().
    */

/**
    * It's required to define the fileName within
    * the export class when making use of Responsable.
    */
    private $fileName = 'personalInfos.xlsx';
    
    /**
    * Optional Writer Type
    */
    private $writerType = Excel::XLSX;
    
    /**
    * Optional headers
    */
    private $headers = [
        'Content-Type' => 'text/csv',
    ];

/**
    * @return \Illuminate\Support\Collection
    */
    public function collection()
    {
    	if ($this->year > 0) 
        	return PersonalInfo::whereYear('created_at', $this->year)->get();
        else 
        	return PersonalInfo::all();
    }

public function forYear(int $year)
    {
        $this->year = $year;
        
        return $this;
    }

/**
     * @return string
     */
    public function title(): string
    {
        return 'Year ' . $this->year;
    }

public function headings(): array
    {
        return [
            '#',
            'First Name',
            'Middle Name',
            'Last Name',
            'Gender',
            'Date of Birth',
            'Phone #',
            'Email',
            'Education',
			'Member Type',
			'QR Code',
			'Country',
			'State',
			'Zone',
			'Wereda',
			'City',
			'Specific Place',
			'Registered At',
            'Payment Interval',
            'Amount',
            'Photo',
        ];
    }

public function styles(Worksheet $sheet)
    {
    	$sheet->getStyle('B2')->getFont()->setBold(true);
        return [
            // Style the first row as bold text.
            1    => ['font' => ['bold' => true]],

// Styling a specific cell by coordinate.
            'B2' => ['font' => ['italic' => true]],

// Styling an entire column.
            'A:S'  => ['font' => ['size' => 13]],
        ];
    }
}