kasigi / antic Goto Github PK

In the grid view, add an option to cancel the delete action. Presently only the confirm delete shows with no way to cancel short of refreshing the browser.

Create a mechanism for file uploads / fields.

File fields should optionally have a way to list permissible mime types and files should be scanned against the types.

File permissions should not have execute by default when saved.

Create a processing task that will go off 'randomly' that is capable of handling various housekeeping items.

Tie to a setting where it uses a 'real' cron or checks site settings whether it needs to run.

Tasks:
Fix/update permissions for super-admin group for all tables.

Create function to update table level permissions

Create a get users service.

Optionally specify a list of user id's.

Return:
userID
fname
lname

Require login.

Create a get users service.

Optionally specify a list of group id's

Return:
groupID
groupName

Require login.

Implement child foreign keys on single record edit

Add entries to the log table when:

User Logs In
Authentication Error
Inadequate Permissions
User Deletes a record
User Edits a record
User Creates a record
SQL Error occurs

Create an init/upgrade script that runs to set up the database for the first time or updates the structure from previous versions.

Provide a sorting mechanism on the grid view.

Create the php-to-json interface to support user logins and user management.

It must support these actions:
login
logout
updatePassword

Provide Filtering on Grid View

Create form and add link with status to top navigation.

User should be able to login or logout.

Convert the field display into an angular directive that alters based on the content type.

Default: text input
Support Possibilities:
Boolean (Select+Option of true/false)
INT
FLOAT
Text Area (display for longtext)
Foreign Key (Select+Option functionality as presently implemented)

Create mechanism to update permission on a record

Add a field validation mechanism to highlight individual fields that contain values that do not match allowable types.

Note: an option regex can be specified in the field settings for validation purposes.

Data actions should implement messages on success / failure. In particular, there should be an error message displayed when an action does not complete.

For example - attempting to delete a 'parent' primary key will usually fail.

When a new row is being inserted, the primary key should default to blank. At present it sets the value to zero which causes the insert to fail.

Update the model.json and SQL queries on the back end to detect foreign key child relationships

Allow the model json file to specify "gridDisplayFields". When present, the grid view will display the combination of the fields listed and any primary keys instead of the entire table.

Complete the back-end structure to support a many-to-many data relationship defined via a tie table (tie via foreign keys?)