We need to be able to search for values across several tables. Once matching records are found we need to be able to change their fields with click & edit functionality.
Every change has to be loged: User / Old value / New value / DateTime
Matching records will come from different tables with totally different structures.
We need to be able to define and store configurations for the search engine which include:
- Searchable tables (pick from list)
- Searchable fields. (pick from list)
- Editable fields
We will have different user roles running this search. Each role will be able to run only one search profile.
The administrator profile will be able to create new search profiles.
The search will be a select box with client Id values, and a text box for the search value.
Every single table in the databases has a client Id column. Leaving the client Id unset should search across all clients.
You don´t worry about user management, you will receive the value of the corresponding profile in a session variable.
As a proof of your careful reading of this post, please tell us which framework / widget / component would you use to display the table rows and support click & edit functionality.
Hope to hear from you!
Thanks!
Helloo
I'm a experienced PHP developer. Even if bit new to freelancer , I'm not new to the industry. has more than 5 year experience.
You will not loose a single dollar, until you are 100% satisfied..
Answer.....********Search*********..
Thanks
-udana-
Respected sir,
I have 2.5 years experience of IT industry and have expertise in Java,JSP,MySQL,JavaScript,Ajax,CSS and HTML.I am working as a full time freelancer now
Ankit katiyar
#011-25072700
#9818886995