README

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 ?

toshim45 / laravel-reverse-mysql

Maintainers

Details