Create a report from a MySQL Database in WPDataAccess for WP
Budget: $30 – $250 USD
I am looking for a skilled freelancer who can create a service invoice from a MySQL Database using WPDataAccess for WordPress. The report should include specific tables or fields from the database and there will be a JOIN to obtain the customer name from another table.
The freelancer should be familiar with how to use the Advanced Features of WPDataAccess which uses DataTables.net. Note, the code must be valid JSON for it to work in WPDataAccess.
Here is a link to the Javascript code from DataTables.net that uses a footer callback function to obtain what I want.
https://datatables.net/examples/advanced_init/footer_callback.html
More specifically, a single table contains columns including but not limited to: date, name, employee, hours, rate, costs, payments, description.
The purpose of the report is to generate a service ledger that shows the calculation of (Hours * Rate - Costs + Payments) for each row in a virtual column, and then total of the column in the footer.
The report does not need to be generated automatically on a regular basis, but only as needed.
Ideal skills and experience for this job include:
- Proficiency in MySQL, WordPress, WPDataAccess, JSON, Javascript, DataTables.net
- Experience in creating reports and working with databases
- Strong attention to detail to ensure accurate calculations in the report.
The freelancer should be familiar with how to use the Advanced Features of WPDataAccess which uses DataTables.net. Note, the code must be valid JSON for it to work in WPDataAccess.
Here is a link to the Javascript code from DataTables.net that uses a footer callback function to obtain what I want.
https://datatables.net/examples/advanced_init/footer_callback.html
More specifically, a single table contains columns including but not limited to: date, name, employee, hours, rate, costs, payments, description.
The purpose of the report is to generate a service ledger that shows the calculation of (Hours * Rate - Costs + Payments) for each row in a virtual column, and then total of the column in the footer.
The report does not need to be generated automatically on a regular basis, but only as needed.
Ideal skills and experience for this job include:
- Proficiency in MySQL, WordPress, WPDataAccess, JSON, Javascript, DataTables.net
- Experience in creating reports and working with databases
- Strong attention to detail to ensure accurate calculations in the report.