This repository contains the CRUD generator that is used to generate pages in WaterWeb. It is a fork from cruddiy by jan-vandenberg.
Since only one person is working on this repository, two checklist are used to show what features / bugs are worked on and also what features are implemented. I have no intention of merging this back into the original repository, since the differences have become too big.
- Show Column Comments from SQL as Tooltips for the column name.
- Show SQL errors when updating, creating or deleting.
- Make foreign key references clickable.
- Preview foreign key references (using a tooltip?), also make it selectable (on creation) which columns appear in this reference.
- For a record that is referenced by other records, provide a link to these other table records.
- Add an update, delete and read button to the update, delete and read pages.
- Properly show Boolean / tinyint.
- Abstract the date view using a helper function.
- Fix PHP variables names with invalid characters, also escape SQL queries with `` to allow for all possible names.
- Add support for nullable columns.
- Make css/js files choosable
- Generate enum select statically at creation.
- Replace 0/1 with True False
- Create an abstraction for the html syntax of columns in the read, edit and create pages.
- Save the configuration (column names, checked checkboxes, etc) that were used to generate cruddiy last time.
- Move all config/validation to the top.?
- Flexible columns on the index (Let the user choose which columns of the table are visible)
- Allow custom queries for flexible records
- Bulk updating of records.
- Remember cruddiy configuration
- Show SQL Table comments.
- Pre-fill create form, to duplicate records.
- Advanced searching (remember search parameters) (Mail 8 mei van Klaas).
- Advanced Ordering.
- Split files into folder of the table name.
- Update bootstrap to the newest version.
- Multiple ordering displayed with 1st column, 2nd column.
- Extend the previews recursively.
- After creating, add a create another button (Move back button to the top). (Mail 16 juli van Klaas).
- Add a possibility for custom extensions to the view pages.
- Automatic NAV-bar generation is broken. (WONTFIX)
- Adding having statement to the where clause
- For delete, check for external references before deletion.
- Null filter toevoegen
- ENUMs fatsoenlijk implementeren.
- Knop back brengt je terug naar de index, de opties op de index worden goed onthouden.
- Default values from SQL as defaults in create.
Clone deze repository in de root van WaterWeb, het zit al in de gitignore, dus waterweb heeft hier geen last van.
- Ga naar je webhost/cruddiy, daar zijn instructies.
- Zodra je nieuwe bestanden hebt. Vanuit de root, gebruik de volgende commands om nieuw gegenereerde crud bestanden over te zetten (Dit overschrijft de huidige)
cp -r cruddiy/core/app/ cruddiy/core/temp/
rm cruddiy/core/temp/config.php cruddiy/core/temp/error.php cruddiy/core/temp/helpers.php cruddiy/core/temp/index.php cruddiy/core/temp/navbar.php
#docker-compose exec php var/www/public/cruddiy/vendor/bin/php-cs-fixer fix var/www/public/cruddiy/core/temp
cp cruddiy/core/temp/* manager/modules/crud/
rm -r cruddiy/core/temp
- Gebruik de format files extensie voor VScode om de bestanden te formateren.
- Let op dat je de shared map ook moet overzetten.
(FORK FROM CRUDDIY) Cruddiy is a free no-code PHP Bootstrap CRUD generator with foreign key support.
With Cruddiy you can easily generate some simple, but beautiful, PHP Bootstrap 4 CRUD pages (Create, Read, Update and Delete) with search, pagination and foreign key awareness.