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.

1. Ga naar je webhost/cruddiy, daar zijn instructies.
2. 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

3. Gebruik de format files extensie voor VScode om de bestanden te formateren.
4. 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.