laravel-reverse-mysql

laravel package, basically reverse field from mysql into controller + views, just like crud generator, but with your theme, just provide the stubs.

Why ?

• need custom theme, we just provide simple html stub, edit as you need
• need a lot of additional code after generate
• need generator which simply read your database fields
• no code bloat, no helper files, it just your model, controller and crud blades

Do not use this

• if you need generator with migration included, because this reverse code from mysql
• if you just need crud without additional code
• if you do not have concern on provided themes

Requirements

• Laravel 5.* or 6.* or 8.*
• Laravel Collective
• Your table must contains id & timestamp

Installation

composer require toshim45/laravel-reverse-mysql

then publish the stubs

php artisan vendor:publish --provider="Toshim45\LaravelReverseMysql\ServiceProvider" --tag=stubs-bootstrap5

your stubs will be placed in resources folder, edit as you need, simple stubs provided for you, for simplest stub use --tag=stubs, also for other stubs see example stubs below.

Do all generation before you add some codes to your new model & controller

How To

Basic Usage

• generate model with php artisan make:model {ModelName} -mcr options, make sure your model name is singular PascalCase
• run php artisan reverse:mysql {table-name} -c -r , table name is usually plural snake_case
• there is option --hard-reset to replace all table related MVC files, use it if needed
• run phpfmt or other php formatter
• add this resources to routes
  • for laravel 8 pls adjust the import

Custom Stub

• generate model with php artisan make:model {ModelName} -mcr options, make sure your model name is singular PascalCase
• update content resources/stubs, keep {{tableName}}, {{tableUrlName}} and {{tableContent}} variables, which is used by this generator, var {{tableFilter}} will create filter with equal query, you can change query at model class.
• run php artisan reverse:mysql {table_name} -c -r, table name is usually plural snake_case
• run phpfmt or other php formatter
• add this resources to routes
  • for laravel 8 pls adjust the import

Reserved variables

• tableName
• tableUrlName
• tableContent
• tableTitle
• tableTotal

Stub Example

pls check github examples and copy paste folder content from one of these, into resources/stubs folder:

• jeroennoten-adminlte stub, install jeroennoten-adminlte package before generating crud

Notes

• Tested on OSX, need help for other OS
• Tested on laravel 5.6, 5.8, 6., 8. need help for 7 (i dont think will support for 4.*)
• For code formatting I'm working on formatting generated code, but for now you can use your IDE, already tried some code formatter, almost of them install binary in your vendor folder, I thought that is inappropriate, so just use your IDE formatter
• only support mysql

TODO (Need Help)

• laravel 7
• form.stub so u will be able to customize input type field class
• do u have any ideas ?