Website changes/reporting/link with mysql database
2596
£75(approx. $94)
- Posted:
- Proposals: 5
- Remote
- #1452392
- Archived
Description
Experience Level: Intermediate
Estimated project duration: less than 1 week
General information for the website: It's a website selling online courses with a management area
Kind of development: Customization of existing website
Description of every page/module: The website is a website which advertises courses that can be booked (over the phone) and also allows people to login and see reports.
We have engineers that go to site and fill in reports on IAuditor software (IPad app), they export this into a csv then put it into a folder on the server.
The server then imports this data to a mysql database when the import script is ran.
Description of requirements/features: 1. Reporting Page which reads data from the MYSQL database, currently some of the filters dont work
- Seems to be using https://github.com/ibamacsr/siema reporting script
2. Need to be able to filter reports by advisor name/site id/site supervisor & company with dates
3. Ignore member names they need to be sorted by COMPANY NAME which should be the first column in the results
4. Report page needs to ignore members and show by company name only with scores.
5. Manage members page – error when you press submit
6. Export report to a csv needs to be an option
7. If logged in as a company then they can see reports but are unable to change dropdown box with company name in – currently not allowing company change but running the form shows all reports anyway.
8. when a csv is imported it also has a pdf of the same name, this needs to be available to view from inside the admin panel
8. When member logs on they have a “your audits” section, pdf’s should be available for download from there
CMS and Admin requirements: as above
Extra notes:
Kind of development: Customization of existing website
Description of every page/module: The website is a website which advertises courses that can be booked (over the phone) and also allows people to login and see reports.
We have engineers that go to site and fill in reports on IAuditor software (IPad app), they export this into a csv then put it into a folder on the server.
The server then imports this data to a mysql database when the import script is ran.
Description of requirements/features: 1. Reporting Page which reads data from the MYSQL database, currently some of the filters dont work
- Seems to be using https://github.com/ibamacsr/siema reporting script
2. Need to be able to filter reports by advisor name/site id/site supervisor & company with dates
3. Ignore member names they need to be sorted by COMPANY NAME which should be the first column in the results
4. Report page needs to ignore members and show by company name only with scores.
5. Manage members page – error when you press submit
6. Export report to a csv needs to be an option
7. If logged in as a company then they can see reports but are unable to change dropdown box with company name in – currently not allowing company change but running the form shows all reports anyway.
8. when a csv is imported it also has a pdf of the same name, this needs to be available to view from inside the admin panel
8. When member logs on they have a “your audits” section, pdf’s should be available for download from there
CMS and Admin requirements: as above
Extra notes:
James G.
100% (5)Projects Completed
9
Freelancers worked with
9
Projects awarded
26%
Last project
9 Feb 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Is the £50 flexible? It is very low for the amount of work that need to be done. Thanks
-
Is the £50 flexible? I
-
Hi is this task still open.
I have worked on similar kind of website.
Its for NISSAN CAR dealers and Mercedes Benz dealer website.
They have the same requirements like you have.
I would love to work on your website.
Please reply me if you would like to work with me.
Thanks
Arun -
Hi,
Thanks for invitation.
In which framework existing site is built upon?
What are the timescales?
Muhamamd
318717318714318660318613
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies