I will only award this project to someone whom has clearly read and understand my requirements.
I need a basic php code to query a date range in one field in a table and show grouped results and totals.
Sample table and date
id, Reg, Date, Type, Amount
1001027, 1 2015-09-30 gold 20.0
1001028 2 2016-09-15 gold 19.99
1001029 3 2016-09-16 bronze 15.99
1001030 2 2016-09-16 silver 14.99
I will expect to get the following result
1. All records between the date range, Grouped by Reg
2. Showing Amount total per group
3. Showing Amount Total across date search
For example, based on the dates 09/01/2016 and 09/18/2016
Reg, Date, Type, Amount
2 2016-09-15 gold 19.99
2 2016-09-16 silver 14.99
3 2016-09-16 bronze 15.99
Results Total £50.97
There is an excellent datepicker script to download [url removed, login to view]
P.S. The link is a fully working script, all I need is to change the table names to match mine and add the summary totals to the result.
Please refer to the working example before bidding.
11 freelancere byder i gennemsnit $45 på dette job
Let's start! I understand what you need and you will have a 100% complete job on time. I can assure you that if you work with me once, you will always work with me for these kind of projects.
I have already worked on databases and your project seems easy but I got couple of questions to clear before we proceed further. Kindly knock me to have a quick chat. Thanks!!