scanzy / dbedit Goto Github PK

• trigger to delete links when deleting entity
• procedure to create link table (and set trigger described above)

• design constraint data format for entities.xml
• check in back end
• check in front end
• front end no conflicts between various checks
• review select empty constraint in front end

• name
• username
• new password
• new password confirm
• confirm with current password

• parse xml into array or object
• generate empty xml

• callback to process data before fetch (scanzyload)
• min rows count to show search
• max rows count to show big new button under table
• custom loading, empty table texts

• link types navbar
• on click go to editlink

• scanzyform for generic form building
• formbuilder for specific bootstrap form
• refactor new entity
• refactor edit entity
• test new code

• use scanzytable for tables
• click row to select (jquery .on)
• row highlight on hover

Page to display all enties of specified type

• title entity alias
• new entity button
• entities table

• modal.js
• refactor confirm.js using modal.js
• integration with scanzytable.js
• x button, heading
• size setting

Check required fields with types (throw error)
Check optional fields with types (use defaults)
Not using proto objects
Write about required/optional fields in wiki

• custom content
• custom button classes
• custom button texts
• custom title

• sort by column on load
• sort callback for rows
• sort callback per column
• click th to sort

• description1 description2
• support for alias of linked entity
• refactor links nav
• refactor entity link boxes description
• refactor new/edit link title

• select
• date picker

To use no html in index.php, but call
$("#whatever").scanzyboxes({ request: { whatever }, ... }); in js file

• scanzybox.js
• refactor all project using scanzybox

• import from json
• export to json
• upload from front end
• send for conflicts check
• collect info to resolve conflicts
• resend data with conflicts resolve options

• store error and complete callbacks
• refactor scanzyload
• refactor scanzytable
• refactor scripts using these 2

• hide columns in entities list
• sort by column

• list entities
• entities count
• entities random (count in entities.xml)
• effect on hover

• use try catch
• use showError

• bootstrap & jquery
• translate.js by scanzy
• save data to sessionStorage (login data, entitytypes data)
• topbar with path (appname/entitytype/entityalias)
• topbar with login name and type, help
• url rewrite to index.php

• topbar path
• delete button
• linked element popup list
• form
• delete link api
• title
• edit link api

• fn.extend
• code refactoring

• count rows
• get rows
• get random rows
• get row with id
• insert row
• update row
• delete row
• data null check (for inserts)
• data type check
• data unique check (for inserts and edits)

• formbuilder.js
• scanzyform.js

• entity alias in title
• entity details
• edit and delete buttons
• links types list

User types:

• Viewers (can view)
• Editors (can edit)
• Admins (can edit structure)
• login apis (specify minimum user level)
• login form
• logout button

write lib script to load data from ajax and fetch something with html, same principle of scanzytable.js, more flexible. Rewrite scanzytable.js using scanzyload.js

• scanzyload.js
• refactor scanzytable.js

• multiple
• bool

small white button ("default" style) with only icon to export data in various formats (clipboard to excel ?)

• form with fields (read data type)
• ok cancel buttons (disabled if no edits)
• after create/edit return to details page
• empty/unique check
• exit page prompt
• topbar path
• scroll to invalid field
• int field
• int max min check
• select field
• date field
• bool field
• fields in grid layout

• button in topbar
• custom text
• custom action

problems when content has height less than screen (not enough to scroll)

• improve data check in back end (HTTP is only string)
• bootsrap picker
• date conversion from mysql YYYY-mm-dd to dd/mm/YYYY

• entities.ini (entities names, table, alias)
• {entityname}.ini (entity columns and data types)
• links.ini (link alias and info)
• {linkname}.ini (link extra columns)
• users.ini (passwords)
• config.ini (db credentials)

when url is undefined. do not load data from ajax but use requiredata instead

• use passive mode for scanzytables where needed

• detect not found entities errors
• detect not found links
• detect not found entity types
• detect not found linktypes
• title
• back button
• dashboard button

helpers

• config (XML)
• entitytypes (XML)
• linktypes (XML)
• entities (SQL)
• links (SQL)

first set page alias, then send content to browser with simple switch page alias
for new/edit pages share everything, select actions in js reading page url

• displayname and description
• linked elements count

Store data table (to write to)
Store view table (to read from)

• topbar
• title
• scanzyload
• scanzytable
• scanzyform