datatables

Customize a mysqld table layout with the editor.datatables.net plug-in.
In your application, please provide an estimate as to the amount of time necessary to complete this project.

Database structure



Database dump


Github - source files



Milestones

1. Activate the Responsive extension

  • (this is an example - with dummy content)
  • Display primarily - time of call and provider id

  • The provider id cell is the result of a join 

SELECT
  call_logs.time_of_call,
  voip.provider_id
FROM call_logs
  INNER JOIN voip
    ON call_logs.call_to = voip.int_phone

Mobile view (responsive plugin)


2. Disable edit on the following fields :


  • time_of_call
  • provider_id
  • call_from
  • call_to
  • call_recording
  • call_duration
  • call_type

3. Add autocomplete option on address field


Step 1
Step 2