I have the following requirements:
I have a CSV file listing a number of transactions and this format never changes. I need a script to upload this CSV file and store in MySQL. I have other fields in the MySQL that do not exist in the CSV file and those should be edited in the front end by the users.
We then want to display these transactions from the MySQL table on screen in a grid view. When I click a transaction it should open up a form to see the data and allow editing of the data but no deletion of the data for all users (we need some kind of login to manager user rights). We need to track the data that was changed upon saving of the record so we should store changes and who made them.
I then need a PDF or JPG file integration so users can attach 1 or several documents to a record. Then we should be able to view these documents using a flash previewer or something like that. When a document is added, we should change a market in the database that says "Attachments" - Yes/No. When the file is uploaded we need to be able to be able to store this in GDrive but first it needs to be renamed with a completely unique filename like the date + hour + minute + second so yymmddhhmmss. This should keep the files completely unique. Then the file gets stored on GDrive and when we click on the record it should open the form plus a preview of the attachments.
Then we have some admin fields which only an admin can edit and only an admin should be able to see those fields.
All of this exists in the internet already so should be easy to put something together in terms of functions and the design we can do at the end. I have done a similiar system before but that was for another company I worked with with slightly different requirements but still it didn't take more than a weekend with someone proficient in MySQL, PHP and GDrive.