THis project is to make a report for my oscommerce shop to report on this contribution
[url removed, login to view],1286
The contribution is installed and working. It automatically generates customer discounts based on how much they have spent with us in the past.
The project is to make a report with the following columns
- Customer Name (should be able to click through to customer details)
- Total Spent (total amount the customer has spend with us)
- Discount Recieved (Amount of money they have recieved as discount for all orders tehy have made, this info is in the database table "orders_total" in column "value" where column "class" = "ot_loyalty_discount")
-Order numbers ( The order numbers that they have placed their orders on)
The whole report should be organised so the total discount Recieved is going from highest to lowest, highest at the top.
For example the report will look like this(see attached)
Please only experienced oscommerce php programmers apply