Add simple table to prestashop module

IN PROGRESS
Bids
16
Avg Bid (EUR)
172
Project Budget (EUR)
€30 - €250

Project Description:
We are looking for a prestashop developer to add a new table to an existing prestashop stats module. The module is an existing admin module, which shows us some stats. We are using prestashop v1.3.7.

We would like it modified to include a new table with the following columns:
Month | Sales | Shipping costs | Profit per month

Description of columns:
Month: One row for every month.
Sales: the total sold in the given month
Shipping costs: if the order weights 2€, if it bigger than 50gr --> 4€ , if it is bigger than 100gr --> 6€. If the payment method is Cash on Delivery, then add 4€.
Profit: Sales - ShippingCosts - Wholesale price

Prestashop has several tables containing the required information... orders, products, etc...

The other table in the module is showing the following and can be used as an example (but should be removed):
Order ID | Total | Profit | Shipping | Discounts | Profit | Shipping | Discounts

The SQL behind this work should not so complicated as you can see in the example.

I am attaching the php file of the existing module, which creates the sample table. You should have a local prestashop installation so you can test the module while developing.

If we are satisfied with your work, we will hire you for future modifications (for instance in a second stage we want to pull data from Google Analytics).

Thanks.

Skills required:
MySQL, PHP, Prestashop
Additional Files: statsproducter.php
Hire sinabe
Project posted by:
sinabe Spain
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


Hire ecommycom
€ 130
in 2 days
€ 100
in 3 days
€ 100
in 2 days
Hire techwelfare
€ 195
in 3 days
€ 250
in 15 days
€ 220
in 6 days
€ 120
in 2 days
€ 250
in 12 days
Hire committedpro
€ 150
in 5 days
€ 100
in 3 days