Download the PHP package stats4sd/laravel-file-util without Composer

Laravel File Utility Package

Installation

You can install the package via composer:

Usage

Pre-requisite:

The package has 3 main features, and you can use one or all of them in your project:

• A trait HasUploadFields: this is based heavily on the trait shipped with Laravel Backpack, but customised slightly to our needs.
  • To use the trait, you need no other dependencies.
• 2 Operation classes, to be used with Laravel Backpack.
  • To use these operations, you should install the following extra dependencies:
  • composer require backpack/crud
  • composer require maatwebsite/excel

1. Exporting Data through a Laravel Backpack Crud panel

Both import and export operations use and require the Laravel Excel package.

The ExportOperation lets you link an ModelExport class built with Laravel Excel to your Crud panel.

How to add an Excel Export:

1. Build your ModelExport class as described here

   • To test this operation class, start with the most basic version of an export (e.g. implement FromCollection and just get some items from your CRUD's model. You can always add things later to customise your export.

2. Use your ModelExport class in your CrudController: use App\Exports\TagsExport;

3. Use the ExportOperation in your CrudController: use \Stats4sd\FileUtil\Http\Controllers\Operations\ExportOperation;

4. Add the following in your CrudController: use ExportOperation;

5. Add the following to your CrudController's setup() method: CRUD::set('export.exporter', YourModelExport::class); (replace with the actual name of your ModelExport class)

That's it! The operation adds an "Export" button to the 'top' stack in List view. Click the button to download the File generated from your ModelExport class.

Notes:

• The default file name is the Crud entity_plural_name, with a date-time string appended to the end.
• The default format is .xlsx
• To override, add an export() method to your crud controller.

Everything about the exported file is defined by the ModelExport class. You can customise it using any of the features of Laravel Excel as you would if you were using the package anywhere else in Laravel. All this Operation does is make it easier to quickly link an ModelExport class to a Crud panel.

2. Importing Data through a Laravel Backpack Crud panel

The ImportOperation lets you link an ModelImport class built with Laravel Excel to your Crud panel.

How to add:

1. Build your ModelImport class as described here

2. Build your ImportRequest class as below

3. Use your ModelImport class in your CrudController: use App\Imports\TagsImport;

4. Use the ImportOperation in your CrudController: use \Stats4sd\FileUtil\Http\Controllers\Operations\ImportOperation;

5. Add the following in your CrudController: use ImportOperation;

6. Add the following to your CrudController's setup() method: CRUD::set('import.importer', YourModelImport::class); (replace with the actual name of your ModelImport class)

That's it! The operation adds an "Import" button to the 'top' stack in List view. Click this button to be taken to the Import View. This view contains a basic form with a file upload input and a submit button. Add an Excel file, submit, and the file will be processed by your ModelImport class.

Notes:

• It's recommended to add validation to your importer. (See documentation page on validating rows)
• The import form has support for displaying errors returned from validation. If you use batch imports, you will see errors from the entire batch of rows at once, labeled with the correct row number. This is useful for seeing all errors at once in an Excel file, instead of going row-by-row and having to try importing the same file multiple times until it works with no validation errors.

TO DO: add examples of validation with both ToModel / BatchInserts AND ToCollection concerns

3. File Upload + File Download Operations

1. Use FileController class in your routes\web.php: use \Stats4sd\FileUtil\Http\Controllers\FileController;

2. Add below section in your routes\web.php

3. In config\filesystem.php, add a line to "disks" \ "local" section 'url' => env('APP_URL').'/download/',

4. Use HasUploadFields class in your Model class: use \Stats4sd\FileUtil\Models\Traits\HasUploadFields;

5. Use trait HasUploadFields class in your Model class: use CrudTrait, HasUploadFields;

6. Add below function to your Model class, it will save uploaded files into folder "storage\app\site". File name will be stored in Model class column "files"

7. Add the following to your CrudController's setupCreateOperation() method: CRUD::field('files')->type('upload_multiple')->disk('local')->upload(true)->label('Files or charts for the site')->hint('If you have charts or other files, please upload them here');

Changelog

Please see CHANGELOG for more information on what has changed recently.

Contributing

Please see CONTRIBUTING for details.

Security Vulnerabilities

Please review our security policy on how to report security vulnerabilities.

Credits

• Dan Tang
• All Contributors

License

The MIT License (MIT). Please see License File for more information.