Đã hoàn thành

46534 Data Analysis Script PHP/mySQL

This will be fairly easy PHP script for a competent programmer. We need to implement an improved "People who bought this, also bought this" module on our website. What we need a script that will analyse the sales data in this table: TABLEA OrderDetailID int(11) (Primary Key) ProductReference varchar(20) QuantityOrdered int(11) OrderSequenceNumber int(11) UpdateDate mediumtext and output it to another table as follows TABLEB ProductReference (varchar20) Unique Primary ProdrefA (varchar20) ProdrefB (varchar20) ProdrefC (varchar20) ProdrefD (varchar20) ProdrefE (varchar20) ProdrefF (varchar20) Where the ProductReference field is a unique field and the other 6 fields list the most common items that customers ordered alongside the item in ProductReference As part of the analysis TABLEA will (optionally) be compared against our product database (linked on ProductReference field) so that products which are currently out of stock will not be included in the calculation. The exclusion of out of stock products will be an option in the front end. There will be two ways of running the script one will be to analyse the entire database and the second will be to analyse data between two date ranges which will only include dates contained in UpdateDate in TABLEA In either case each time the analysis is run all the contents of TABLEB will be deleted and written afresh. The analysis will be operated from a PHP/Web front end which will allow the option to restrict the date range (as mentioned above) and the option to excluded items not currently in stock (as described above). Once these options have been chosen the user will press a button which will commence the operation. At the end of the analysis the frontend will show the total number of records analysed in TABLEA and the total number of records written to TABLEB and the time taken to carry out the analysis. It would be nice if we could have some kind of method of analysing how long the analysis is going to take and setting a time limit on it as well. **We do not need help with the use of the contents of TABLEB on our website, we already have the modules for this.** NB: We do not allow access to our servers under any circumstances *EVER*. You must have a fully enabled PHP/mySQL server to test your scripts before submitting them. Please read the brief above fully, we consider this to be a full brief of our requirements with only a small amount of further Q&A clarification

Kĩ năng: Bất kì công việc gì, PHP

Xem nhiều hơn: use case module, programmer php mysql, primary modules, primary data, php web modules, one key data, mysql data access, linked int, data front, data analysis help, access to php mysql, php stock data analysis scripts, php data analysis script, what is a test case, how to do data analysis, Requirements analysis, need sales data, need an improved, mysql test, frontend php

Về Bên Thuê:
( 14 nhận xét ) London, United Kingdom

ID dự án: #1795830

Được trao cho:


I should be able to have this done within 1 day, at most 2 ... I can probably finish it today :) I happen to be working on something that uses similar principles to this for myself right now ("people who saw this link Thêm

$100 USD trong 2 ngày
(0 Đánh Giá)