CRUD Generator

Database nlenergiev-kapaz

Current Version is up to date

Choose a table
Select an action

Build Read List

Build Create / Update Forms

Build Delete Form
Options from the paginated list
contract_periodMain settings
Cascade delete options
contract_periodField Names Displayed in Admin
contract_periodFilters (drop-down lists to filter results)

Use FlySpeed SQL Query to generate and test your queries

Label
Label displayed next to the drop-down list.
Example : "Author"
Value(s)
Fields to be displayed in the drop-down list, separated by "+".
Example : "authors.name + authors.first_name"
Fields
Fields for the query SQL SELECT.
Example : "authors.name, authors.first_name, articles.authors_id"
Fields to be filtered
The field used to filter the query.
Example : "articles.authors_id"
SQL FROM
SQL FROM query.
Example : "articles Left Join authors On articles.authors_id = authors.id"
Type of values
Text or Boolean.

The query cited as an example will be the following :

SELECT DISTINCT authors.name, authors.first_name, articles.authors_id FROM articles INNER JOIN authors ON articles.authors_id = authors.id

When the user has chosen an item from the list :

SELECT DISTINCT authors.name, authors.first_name, articles.authors_id FROM articles INNER JOIN authors ON articles.authors_id = authors.id WHERE articles.authors_id = [posted value]

Use table.field rather than field to avoid ambiguous queries.

contract_periodcontract_period Fields

Values : None

Values : None

[ROOT_PATH]/
[ROOT_URL]/
Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt
[ROOT_PATH]/
[ROOT_URL]/
If you activate the generation of thumbnails you must create a folder named 'thumbs' inside your upload directory, then 3 folders inside the 'thumbs' directory named 'lg', 'md', 'sm'.

Values : None

Values : None

contract_periodExternal relations

MANY_TO_MANY Relation

Enabling this relationship allows you to associate one or more supplier with each table record contract_period.

The product table is in this case a pure relational table which connects the supplier to the contract_period table.

The READ LIST will display the records of the table supplier in a nested table.

Depending on your choice, the CREATE and EDIT forms will allow to associate the records of the table supplier to the contract_period added/edited,
OR to add/edit/delete the records of the table supplier.

ONE_TO_MANY Relation

If you enable this relationship, the READ LIST will display for each record in the table contract_period the matching entries of the table %original_table% in a sub-drop-down table.

If you enable the Allow users to add/edit/delete records from the READ LIST option the users will be able to add/edit/delete the records from the table product directly from this subtable.

Options for the deletion form

Fields displayed to user in admin to confirm deletion

 

PHP CRUD Generator - Configuration

PHP CRUD Generator - Compare files

PHP CRUD Generator - Authentication module

The user authentication module is enabled

Disable Open the admin page

construct

getTables => Get tables from DB

getTables => generator default table = contract_period

getDbColumns

registerColumnsProperties => From JSON : nlenergiev-kapaz/contract_period.json