File Manager Lite

Dir: /home/u540325668/domains/sostabazar.in/public_html/schooldemo/app/Exports

[..]

MarksDataExport.php (1.14 KB)

StaffDataExport.php (3.17 KB)

StudentDataExport.php (3.65 KB)

TeacherDataExport.php (3.42 KB)

Edit: StudentDataExport.php

<?php

namespace App\Exports;

use App\Imports\FormFieldValuesSheet;
use App\Repositories\FormField\FormFieldsInterface;
use Illuminate\Database\Eloquent\Collection;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\ShouldAutoSize;
use Maatwebsite\Excel\Concerns\WithHeadings;
use Maatwebsite\Excel\Concerns\WithMultipleSheets;
use Maatwebsite\Excel\Concerns\WithStrictNullComparison;
use Maatwebsite\Excel\Concerns\WithTitle;

class StudentDataExport implements FromCollection, WithTitle, WithHeadings, ShouldAutoSize, WithStrictNullComparison, WithMultipleSheets {
    protected mixed $results;
    protected Collection $formFields;

public function __construct() {
        $formFieldsInterface = app(FormFieldsInterface::class);
//        $this->formFields = FormField::select('name', 'type', 'default_values', 'is_required')->get();
        $this->formFields = $formFieldsInterface->all(['name', 'type', 'default_values', 'is_required', 'user_type']);
    }

public function title(): string {
        return 'Main Sheet For Admission';
    }

public function headings(): array {
        $columns = [
            'first_name',
            'last_name',
            'mobile',
            'gender',
            'dob',
            'admission_date',
            'current_address',
            'permanent_address',
            'guardian_email',
            'guardian_first_name',
            'guardian_last_name',
            'guardian_gender',
            'guardian_mobile',
        ];
        foreach ($this->formFields as $data) {
            if($data->user_type == 1) {
                if ($data->type != 'file') {
                    $columns[] = str_replace(' ', '_', $data->name);
                }
            }
        }
        return $columns;
    }

public function sheets(): array {
        $sheets = [];

// add the main data sheet
        $sheets[] = new StudentDataExport();

// add a new sheet for the form field values
        $sheets[] = new FormFieldValuesSheet($this->formFields);

return $sheets;
    }

private function getActionItems() {
        $fields = [
            'student1',
            'example',
            '1234567899',
            'male / female',
            date('d-m-Y'),
            date('d-m-Y'),
            'current address',
            'permanent address',
            'guaridan@example.com',
            'guardian',
            '',
            'male / female',
            '123456789',
        ];
        foreach ($this->formFields as $value) {
            if($value->user_type == 1) {
                switch ($value->type) {
                    case 'text':
                    case 'textarea':
                        $value->is_required == 1 ? array_push($fields, $value->type) : array_push($fields, $value->type . ' OR leave blank');
                        break;
                    case 'number':
                        $value->is_required == 1 ? array_push($fields, "545454") : array_push($fields, "545454 OR leave blank");
                        break;
                    case 'dropdown':
                    case 'radio':
                    case 'checkbox':
                        $value->is_required == 1 ? array_push($fields, '{{ Please Check the Possible Options of it }}') : array_push($fields, '{{ Please Check the Possible Options of it OR leave blank}}');
                        break;
                    default:
                        break;
                }
            }
        }
        return $fields;
    }

public function collection() {
        // store the results for later use
        $this->results = $this->getActionItems();

return collect(array($this->results));
    }
}