Simple PHP MySql Directory Spreadsheet
PHP/MySql app will have Control panel for admin and front end
1. Front will have multiple columns( about 15-20) , I should be able to add additional Coulmn in Cp Name them and describe them. Or I should be able to upload my XL or CSV and Create or Name filed based on headings. Two field will be Check Box , One will be ID and one will be blank “Edited By” or Supervised By” or tracked By
2. I can assign any column as the user names and any column as password after uploading my XL or CSV.
3. This whole thing will be accessible only by these user names and passwords.
4. I can hide certain Column in CP such as Username , password or email from user view. but visible to admin on front or in CP
5. I can assign certain columns as view only (locked) and others as editable, and some blank (may be Note) for new data by user.
6. User should be able to sort and filter data by any column. A Search BOX to search thru all data( except hidden from normal users)
7. Any column that is Checked into check box, have to automatically fill/add/Log (not editable or removable) the editor user’s ID or user name or first name ( I should be able to select what to log in CP) in “Edited By” or Supervised By”
8. Any user who log in system later can see what other user s have supervised or edited. He can select to supervise or edit his own vacant users or he can sort or filter other supervisors. He can not reedit or check already checked checked users but he can white note for checked users by other supervisor.
9. I want a small chart and dash board on top showing
total users , supervisors, total supervised or checked users. Notes added, I mean totalcount or unique count from the tables filled.
I intend to pay around $100.00 USD I expect all this done ASAP, I will pay half after seeing working demo on your site .You will import or upload from my Spreadsheet onto my server i will pay next 25% i will test and pay next 25%