We are building a web database application with PHP, Bootstrap, w3css, JS, AJAX, etc. I need help with one form.
This consists of a list of records. The left column has two icons, one for viewing (eye icon), the other for editing (pencil icon). The users with the bit "isAdmin" can add, view, and edit. All others can only view.
When the ' view' button (eye icon) is clicked, a modal dialog appears showing selected fields of the current record with their values and a 'close' button. The user can pick values and copy to them to the clipboard.
When the 'edit' button (pencil icon) is clicked, a similar modal dialog appears, with the selected record values, and a set of buttons to Delete, Add, Clone, Close and Save.
The 'trash' button (red trash icon), asks for confirmation before it stores a '1' value in the 'isVoid' field in the record, and displays the message: 'Record has been deleted. Click Close'. The message clears and the form closes when the user clicks on 'Close' or on the 'x' button (x icon) on the upper right hand corner of the form. This function does not erase the record.
There is a message section.
The add button (plus icon), clears the fields and allows user entry. The user clicks on the 'save' button (check icon) to save and on the 'close' (x icon) button to close.
The 'clone' button asks for confirmation and makes a copy of the record, with a new ID (record number), same Company, and all other fields blank. The new record is the current record and is shown in the modal dialog ready for edit. A message is displayed; 'Clone record ready for edit'. The new record is not created in the database until the user clicks on the 'save' button. Messages will preferably display in the modal's footer, to the left of the buttons.
The 'close' button as well as the x button, both close de modal dialog without making any changes. If changes have been made to the fields, displays a message: "Changes will be lost. Click 'close' again to discard all changes, click 'save' to save". The message stays until the user clicks 'save', or 'close'. Clicking on 'save' does not close the dialog.
The 'save' button saves the values shown in modal into the record and keeps the modal open for further edits, or the 'close' button is pressed. After each save, display the message: 'Record Saved'. The message clears when the user clicks on the dialog. 'Save' does not close the dialog.
Clicking away from the dialog, clicking on the 'close' button, or clicking on the x button will have the same effect: a) check if there are changes, b) if there are not then close, otherwise, warn that changes will be lost, c) wait for confirmation and disable closing with other than the 'close' button, etc.
This should be implemented in a manner to minimize network traffic, dynamically retrieving ONLY the record that needs to be processed, only after the user clicks.
The code is to be delivered installed on the same server where it is provided.
WHAT WE HAVE ALREADY
We already have a database, the base form, two modals, icon buttons and tooltips.
Tags and values need to be added.
We will supply a link and the credentials needed to access the database and server via FTP where to install this.
Each function could be a Milestone.
If you are interested, we can supply a link to let you view the partially working model.
54 freelancers are bidding on average $428 for this job
Hi, I'm interested and would like to see the mentioned partially working model. I'm a full stack web developer and can finish the work quickly, contact me any time!