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 ?