Create a report from a MySQL Database in WPDataAccess for WP

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 [login to view URL] that uses a footer callback function to obtain what I want. [login to view URL] 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, [login to view URL] - Experience in creating reports and working with databases - Strong attention to detail to ensure accurate calculations in the report.