MANUAL INVOICE CREATION TOOL - EXTRACT MSSQL data to build Invoice then Print as PDF
Budget: $250 – $500 AUD
NEED TO BE DONE IN NEXT 2 DAYS - 3RD JULY 2023
Need a PHP based web tool that users can upload a CSV file with initial data and the web tool converts into a edit able webpage that can edited line by line and then exported to a PDF Invoice
• Running XAMP Server
• All data to be stored in mySQL database
The tool has to extract some data from SQL server DB that is on the local network to populate some fields on the Invoice.
3 Page Website:
1. Patient Name Invoice Page
CSV Load function
Select Customer Function
Extra Text Fields to capture form data
DISPLAY OF TRANSACTION DATA after querying SQL Server database
Calculate Total Price and GST Price
Edit/ Delete/ Add line functions
Save Table function
EXPORT TO PDF TEMPLATE
2. Manual Invoice Page
Same above, but no CSV upload function
Has a TextBox in Patient Name field that can hold 20+ names
3. Displays list of Saved Tables – Name and Date
Can, open, edit or delete the Tables
Need a PHP based web tool that users can upload a CSV file with initial data and the web tool converts into a edit able webpage that can edited line by line and then exported to a PDF Invoice
• Running XAMP Server
• All data to be stored in mySQL database
The tool has to extract some data from SQL server DB that is on the local network to populate some fields on the Invoice.
3 Page Website:
1. Patient Name Invoice Page
CSV Load function
Select Customer Function
Extra Text Fields to capture form data
DISPLAY OF TRANSACTION DATA after querying SQL Server database
Calculate Total Price and GST Price
Edit/ Delete/ Add line functions
Save Table function
EXPORT TO PDF TEMPLATE
2. Manual Invoice Page
Same above, but no CSV upload function
Has a TextBox in Patient Name field that can hold 20+ names
3. Displays list of Saved Tables – Name and Date
Can, open, edit or delete the Tables