Affiliation with discount code

The purpose of this module is to be attributed to prescribers "authorship" of some sales, to reward them. Creating unique discount codes The "PRO" customers will be assigned a unique and auto-incremented code when registering on the website. When this discount code to be used by another client, it will give them the sale. The « not PRO » customers are not affected by this new dev. "PRO" customers are identified in the MySQL database. Advantage for "downline" In addition to sales tracker, this discount code will allow referrals to have a reduction of xx% on their order. The amount of this reduction must be made: - by a 15% global setting that applies to all - Specifically for some prescribers for another amount. This means create a new page in the administration that shows the complete list of prescribers with the amount of reduction given by their discount code to their clients (default 15%) but with the possibility of change this amount for each prescriber in particular. Code display on the front office Each prescriber will be displayed its unique discount code so that he can distribute to his contacts. It will be displayed on "My Account" and the "PRO" CMS page. The "not PRO" customers are not affected by this display. Statistics for the prescriber In the customer account of the prescriber, create a new page that displays the list of orders in which his coupon code has been used, with this table: Date Order N° Name Amount of order without VAT and without shipping 14/02/2014 12345 DURAND Veronique 47,52€ 05/02/2014 12321 MICHEL Patrick 52,23€ Statistics for back office In the Prestashop back office of [login to view URL] website, it must be possible to view statistics on prescribers over a given period. This page will display the validated orders (= which payment is validated) for each prescriber. A CSV export must be available, it will include: - Contact of the prescriber (name, address, tel, ...) - His discount code - His total amount of orders without VAT and without shipping, on the selected period