Implement dashboard form in PHP, MariaDB/MySQL and JQuery

We are a web development company who are transitioning from ASP classic to PHP. We are looking for a developer to implement a dashboard form for artwork records and upon successful completion we are looking to retain the chosen developer for future PHP work.

The dashboard has been adapted from a Bootstrap 4 template and screenshots have been attached. The Bootstrap pages have been written together with the MariaDB/MySQL database tables, stored procedures and PHP wrapper functions. More details provided below.

DETAILED REQUIREMENTS

-------------------------------------------

Listing page

--------------------

Search - this shall be implemented using autocomplete on the stock number, title and creator

Language drop down - ignore this as this is for future development

Add - implement a form to add an artwork record, this opens up into a modal

Edit - implement a form to edit an artwork, this opens up into a modal

Delete - implement a delete function with confirmation modal before proceeding

Load more - records will not be paged but shall instead use a "Load more" button at the end to load the next few records

Create/Edit modal form

--------------------------------------

AJAX - all forms shall be submitted using jQuery/AJAX

Encoding type - the form may upload image files so will require enctype="multipart/form-data".

Language in ID - all form IDs shall have "-en" at the end which needs to be identified server side when storing in the database. This is here for future use when we implement the dashboard to be multilingual.

Validation - form fields shall be validated in Bootstrap ideally both on the front end and server side to check for duplicate entries of the stock number.

Colour picker - in the general tab is a colour picker, this needs to be a Hex colour picker with the option to add a Hex colour value as well. The standard browser type="colour" shown in the screen shot does not allow this.

Drop downs - all drop down form fields shall be generated from values held in the database.

Artists - in the Artist tab, the artist form fields shall use autocomplete from a table of artists in the database.

Validate creator - an artwork can only have an artist, non artist or anonymous as a creator. These are in separate tabs, the form needs to ensure only one of the tabs are used to provide the values.

HTML editor - we will be using a different HTML editor than the one shown in the screenshot. It will be the Redactor editor [login to view URL]

Photos - the Photos tab will need to allow several photos to be uploaded. We have a separate script which uploads the photos using Dropzone then uses a cropper script to allow the user to crop the images using a viewport. You will need to integrate this into the dashboard.

REQUIRED SKILLS

-----------------------------

- Object Oriented PHP - advanced

- MariaDB/MySQL - advanced

- jQuery - advanced

- Bootstrap 4 - intermediate, most of the Bootstrap code is provided and we can help if you have formatting issues

WHAT IS PROVIDED

--------------------------------

- Open VPN account to connect to our server

- FTP account to connect to test site on server where development must take place

- Access to database through Adminer

- Database shall have all tables and stored procedures defined

- PHP files provided with wrapper functions interfacing to stored procedures

- Dashboard listing page and modal forms already provided and they validate in HTML.

DEADLINE

-----------------

This is quite urgent and we need this competed within 48 hours. Speed of development as well as quality are the criteria we look at if we are to retain the developer for future work.

PHP MySQL JavaScript jQuery / Prototype AJAX

Project ID: #31601695

About the project