TASK SPECIFICATION
1. read the requirements carefully to the end. If you have no time to complete
all the tasks, you can skip points marked as OPTIONAL.
2. create MYSQL database and import tables structure and data from dump file.
GENERAL REQUIREMENTS:
* NO mvc frameworks and template engines allowed to complete this task, but
You are free to use different DB abstraction layer frameworks or native
PHP mysql functions and classes.
* HTML and PHP code must be separated as much as possible (different files
for PHP code and HTML templates)
* We would like to see how you understand Object Oriented Programming, so it
will be a plus if you show how you could do the task object orineted.
* Classes must be placed in own class file.
3. TASK 1: create a script which will output HTML page with table of SQL query result.
3.1 DB query must fetch data from 2 tables to generate HTML table of every
user sale statistics for second half of November (from 16th to 30th),
user must be shown even if he has no sales for the period.
3.2 HTML table must have the following structure:
User ID | User name | Total revenue | Revenue rate | Sale amount | Sale rate
where "Total revenue" - sum of all sales for this user
"Revenue rate" - rate of the user "Total revenue" per sum of all
users "Total revenue"'s represented in percents.
"Sale amount" - amount of sales user did in other words (amount
of records for the user in "sale" table)
"Sale rate" - rate of the user "Sale amount" per sum of all
users "Sale amount" represented in percents
3.3. Last row of the table must contain totals of 4 columns:
(Total revenue, Revenue rate, Sale amount, Sale rate)
3.3 Here is example of the result table. Pay attentiong to formatting and alignment.
User ID | User name | Total revenue | Revenue rate | Sale amount | Sale rate
1 | Anton | 120.00 | 6.3 % | 6 | 12 %
2 | Sergei | 85.00 | 4.5 % | 2 | 4 %
3 | Andrei | 0.00 | 0.0 % | 0 | 0 %
4 | Dmitri | 440.00 | 23.2 % | 13 | 26 %
5 | Aleksei | 1 250.00 | 66.0 % | 29 | 58 %
Total: | 1 895.00 | 100.0 % | 50 | 100 %
3.4 OPTIONAL: Optimize DB table indexes for your SQL queries in order there
can be thousands of sale records in database.
4. TASK 2: import HTML table to XLS file
4.1 use jQuery lib for JS part and the (http://phpexcel.codeplex.com/) PHP lib for making XLS file
4.2 above HTML table must be link called "Import to XLS", by pressing the
link JavaScript must gather table cells data with javascript and submit
to a PHP script which will generate XLS file and flush it to user browser
so that user can start or cancel download immediately.
4.3 OPTIONAL: user should stay on the HTML page when download XLS file.
DO NOT open download page in the same window or navigate away.
4.4 OPTIONAL: javascript function could be as a jQuery plugin with an option
to specify any HTML table to be converted to XLS file with your PHP script.
4.5 OPTIONAL: if possible, keep the same cell format in XLS file (Text for text,
number for integer and decimal numbers, strip % from the end of number),
text alignment is not important in XLS file.
5. Take a break when you are done, do not hurry with submitting your code. Follow
one simple rule: wait for 2 hours, if nothing comes up to your mind to check,
fix or change, then it is ready! If you have changed something, wait 2 hours
again, maybe something else will come into your head
6. When ready, submit your work by email to info@daprime.com in ZIP format,
filename must be yourname_surname.zip
7. Show us what you can and GOOD LUCK.
MYSQL
<pre class="sh_sourceCode" rel="code">
-- MySQL dump 10.13 Distrib 5.5.9, for Win32 (x86)
--
-- Host: localhost Database: service_panel
-- ------------------------------------------------------
-- Server version 5.1.58-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `test_user`
--
DROP TABLE IF EXISTS `test_user`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `test_user` (
`ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
`OrderNumber` int(1) unsigned DEFAULT NULL,
`Name` varchar(50) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `test_user`
--
LOCK TABLES `test_user` WRITE;
/*!40000 ALTER TABLE `test_user` DISABLE KEYS */;
INSERT INTO `test_user` VALUES (1,1,'Zahid'),(2,2,'Matt'),(3,3,'Regan'),(4,4,'Elliott'),(5,5,'Du ncan'),(6,6,'Keiran'),(7,7,'Simon'), (8,8,'Noel'),(9,9,'Matthew'),(10,10,'Wade'),(11,11,'Barnaby'),(12,12,'Lee'),(13,13,'Archie'),(14,14,' ; ; ; ;Dwayne'),(15,15,'Arthur'),(16,16,'D ave'),(17,17,'Marko'),(18,18,'Dominic'),(19,19,'Seth'),(20,20,'Victor');
/*!40000 ALTER TABLE `test_user` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `test_sale`
--
DROP TABLE IF EXISTS `test_sale`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `test_sale` (
`ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
`UserID` int(11) unsigned NOT NULL,
`Date` date NOT NULL,
`Revenue` decimal(9,2) unsigned NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=501 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `test_sale`
--
LOCK TABLES `test_sale` WRITE;
/*!40000 ALTER TABLE `test_sale` DISABLE KEYS */;
INSERT INTO `test_sale` VALUES (1,18,'2011-11-20',975.87),(2,20,'2011-11-12',845.73),(3,10,'2011-11-13',448.34),(4,13,'2011-11-29',454.06),(5,17,'2011-11-16',72.73),(6,5,'2011-11-17',423.04),(7,3,'2011-11-17',925.32),(8,6,'2011-11-30',234.22),(9,6,'2011-11-30',688.27),(10,17,'2011-11-24',953.89),(11,8,'2011-11-13',559.14),(12,10,'2011-11-29',995.23),(13,7,'2011-11-11',809.49),(14,20,'2011-11-11',802.62),(15,13,'2011-11-26',520.18),(16,9,'2011-11-10',288.49),(17,18,'2011-11-16',885.82),(18,9,'2011-11-20',264.23),(19,7,'2011-11-28',134.03),(20,4,'2011-11-30',568.19),(21,10,'2011-11-25',766.79),(22,2,'2011-11-14',698.42),(23,6,'2011-11-27',396.90),(24,4,'2011-11-18',72.20),(25,19,'2011-11-19',890.48),(26,14,'2011-11-28',942.98),(27,2,'2011-11-16',466.46),(28,2,'2011-11-19',106.46),(29,12,'2011-11-13',252.86),(30,17,'2011-11-27',17.06),(31,3,'2011-11-19',441.02),(32,10,'2011-11-10',412.74),(33,13,'2011-11-14',498.94),(34,20,'2011-11-17',702.97),(35,6,'2011-11-15',816.05),(36,12,'2011-11-26',818.88),(37,13,'2011-11-21',120.72),(38,17,'2011-11-30',738.62),(39,1,'2011-11-21',492.32),(40,17,'2011-11-12',657.80),(41,17,'2011-11-15',87.37),(42,2,'2011-11-11',484.02),(43,3,'2011-11-29',619.83),(44,4,'2011-11-21',620.66),(45,17,'2011-11-18',975.80),(46,4,'2011-11-12',855.50),(47,3,'2011-11-12',534.83),(48,6,'2011-11-21',512.33),(49,17,'2011-11-16',727.07),(50,6,'2011-11-18',639.11),(51,13,'2011-11-26',952.70),(52,18,'2011-11-24',191.47),(53,13,'2011-11-11',23.92),(54,15,'2011-11-16',91.87),(55,12,'2011-11-22',904.59),(56,17,'2011-11-19',110.88),(57,7,'2011-11-19',900.38),(58,13,'2011-11-19',705.28),(59,6,'2011-11-25',679.13),(60,4,'2011-11-30',438.32),(61,13,'2011-11-24',166.90),(62,11,'2011-11-27',505.35),(63,1,'2011-11-27',586.52),(64,12,'2011-11-22',768.60),(65,10,'2011-11-17',710.37),(66,2,'2011-11-23',548.71),(67,9,'2011-11-20',720.20),(68,9,'2011-11-18',830.41),(69,6,'2011-11-16',300.23),(70,1,'2011-11-21',200.70),(71,3,'2011-11-10',19.47),(72,5,'2011-11-21',898.79),(73,18,'2011-11-20',122.79),(74,9,'2011-11-29',63.43),(75,18,'2011-11-29',192.44),(76,4,'2011-11-28',59.44),(77,5,'2011-11-14',757.09),(78,17,'2011-11-12',463.68),(79,12,'2011-11-19',906.54),(80,17,'2011-11-16',553.03),(81,17,'2011-11-29',968.00),(82,17,'2011-11-22',446.88),(83,17,'2011-11-28',194.00),(84,11,'2011-11-10',496.59),(85,14,'2011-11-16',116.45),(86,9,'2011-11-13',278.42),(87,9,'2011-11-27',427.96),(88,18,'2011-11-24',850.45),(89,2,'2011-11-27',348.18),(90,17,'2011-11-11',45.04),(91,4,'2011-11-26',42.23),(92,18,'2011-11-12',559.81),(93,10,'2011-11-20',404.44),(94,15,'2011-11-17',802.17),(95,5,'2011-11-10',272.78),(96,10,'2011-11-30',395.16),(97,11,'2011-11-19',472.73),(98,9,'2011-11-28',258.33),(99,17,'2011-11-28',814.81),(100,20,'2011-11-24',334.76),(101,9,'2011-11-10',960.60),(102,7,'2011-11-14',499.52),(103,6,'2011-11-19',287.79),(104,17,'2011-11-27',968.82),(105,14,'2011-11-15',911.99),(106,12,'2011-11-19',616.08),(107,6,'2011-11-16',114.76),(108,15,'2011-11-23',259.67),(109,14,'2011-11-13',589.75),(110,10,'2011-11-20',893.32),(111,6,'2011-11-13',829.70),(112,9,'2011-11-24',664.57),(113,12,'2011-11-29',691.96),(114,18,'2011-11-10',171.77),(115,3,'2011-11-11',897.26),(116,13,'2011-11-17',452.01),(117,17,'2011-11-16',330.09),(118,7,'2011-11-17',23.54),(119,13,'2011-11-12',523.72),(120,1,'2011-11-27',541.20),(121,2,'2011-11-22',106.36),(122,6,'2011-11-19',393.87),(123,20,'2011-11-11',266.96),(124,9,'2011-11-27',219.99),(125,12,'2011-11-27',915.44),(126,12,'2011-11-11',929.57),(127,3,'2011-11-29',679.81),(128,14,'2011-11-23',780.85),(129,4,'2011-11-15',258.92),(130,19,'2011-11-10',960.87),(131,2,'2011-11-11',945.24),(132,11,'2011-11-16',526.59),(133,17,'2011-11-11',663.46),(134,17,'2011-11-14',308.27),(135,11,'2011-11-25',886.37),(136,7,'2011-11-28',144.35),(137,9,'2011-11-16',775.58),(138,18,'2011-11-10',113.70),(139,11,'2011-11-20',651.67),(140,3,'2011-11-20',120.28),(141,8,'2011-11-15',754.55),(142,12,'2011-11-10',287.00),(143,2,'2011-11-18',920.15),(144,10,'2011-11-18',31.07),(145,8,'2011-11-17',785.03),(146,15,'2011-11-21',30.56),(147,20,'2011-11-13',291.20),(148,4,'2011-11-28',2.45),(149,5,'2011-11-13',978.12),(150,17,'2011-11-28',38.35),(151,1,'2011-11-30',513.43),(152,7,'2011-11-16',727.11),(153,5,'2011-11-16',85.14),(154,2,'2011-11-21',258.68),(155,19,'2011-11-11',945.46),(156,20,'2011-11-19',405.56),(157,15,'2011-11-25',774.69),(158,1,'2011-11-25',573.64),(159,8,'2011-11-13',453.47),(160,15,'2011-11-19',453.06),(161,17,'2011-11-24',442.73),(162,5,'2011-11-13',455.10),(163,5,'2011-11-19',887.19),(164,20,'2011-11-12',431.44),(165,4,'2011-11-20',683.74),(166,19,'2011-11-11',517.96),(167,6,'2011-11-20',3.45),(168,12,'2011-11-20',716.95),(169,5,'2011-11-23',367.58),(170,1,'2011-11-20',855.02),(171,18,'2011-11-25',745.29),(172,1,'2011-11-11',953.61),(173,11,'2011-11-18',162.04),(174,18,'2011-11-21',36.85),(175,11,'2011-11-19',375.97),(176,7,'2011-11-19',826.70),(177,18,'2011-11-13',5.04),(178,7,'2011-11-16',249.54),(179,20,'2011-11-25',908.22),(180,10,'2011-11-29',327.14),(181,17,'2011-11-22',933.23),(182,1,'2011-11-27',283.23),(183,17,'2011-11-11',953.02),(184,10,'2011-11-25',698.83),(185,17,'2011-11-21',773.13),(186,12,'2011-11-27',253.44),(187,2,'2011-11-16',765.95),(188,15,'2011-11-26',892.86),(189,2,'2011-11-22',655.38),(190,6,'2011-11-18',843.77),(191,11,'2011-11-18',539.64),(192,11,'2011-11-16',295.91),(193,17,'2011-11-28',665.36),(194,17,'2011-11-23',929.54),(195,3,'2011-11-14',840.06),(196,14,'2011-11-21',594.11),(197,17,'2011-11-30',304.08),(198,9,'2011-11-14',181.38),(199,2,'2011-11-22',658.07),(200,10,'2011-11-18',884.75),(201,14,'2011-11-17',708.90),(202,4,'2011-11-15',807.75),(203,19,'2011-11-20',473.36),(204,14,'2011-11-24',648.71),(205,10,'2011-11-16',263.50),(206,4,'2011-11-22',731.32),(207,14,'2011-11-15',203.68),(208,1,'2011-11-20',97.82),(209,15,'2011-11-22',306.55),(210,11,'2011-11-22',623.84),(211,18,'2011-11-15',654.39),(212,14,'2011-11-12',148.07),(213,18,'2011-11-26',418.62),(214,20,'2011-11-25',943.58),(215,2,'2011-11-17',414.37),(216,11,'2011-11-14',288.06),(217,4,'2011-11-25',601.59),(218,12,'2011-11-21',625.04),(219,1,'2011-11-29',769.02),(220,17,'2011-11-17',412.44),(221,20,'2011-11-15',528.66),(222,2,'2011-11-17',593.70),(223,2,'2011-11-11',858.21),(224,1,'2011-11-14',208.82),(225,12,'2011-11-29',983.43),(226,20,'2011-11-28',113.75),(227,8,'2011-11-19',846.60),(228,14,'2011-11-27',172.80),(229,17,'2011-11-20',139.25),(230,8,'2011-11-25',942.35),(231,6,'2011-11-17',128.28),(232,11,'2011-11-12',62.81),(233,14,'2011-11-23',804.20),(234,4,'2011-11-17',542.11),(235,5,'2011-11-25',873.79),(236,12,'2011-11-23',454.67),(237,6,'2011-11-26',962.98),(238,9,'2011-11-21',468.77),(239,13,'2011-11-23',749.77),(240,13,'2011-11-20',487.96),(241,4,'2011-11-29',106.97),(242,12,'2011-11-13',799.52),(243,2,'2011-11-27',38.76),(244,9,'2011-11-24',499.55),(245,8,'2011-11-27',68.30),(246,7,'2011-11-13',260.13),(247,17,'2011-11-13',412.24),(248,18,'2011-11-10',90.20),(249,4,'2011-11-21',975.82),(250,19,'2011-11-21',728.47),(251,8,'2011-11-27',80.64),(252,5,'2011-11-21',476.28),(253,10,'2011-11-11',741.18),(254,14,'2011-11-13',853.11),(255,17,'2011-11-21',162.08),(256,15,'2011-11-15',301.92),(257,5,'2011-11-14',647.30),(258,17,'2011-11-20',10.41),(259,18,'2011-11-16',554.78),(260,1,'2011-11-30',574.41),(261,6,'2011-11-22',984.02),(262,3,'2011-11-15',258.36),(263,9,'2011-11-22',947.21),(264,3,'2011-11-23',920.05),(265,12,'2011-11-14',809.45),(266,5,'2011-11-14',636.59),(267,1,'2011-11-26',250.93),(268,12,'2011-11-24',696.25),(269,4,'2011-11-27',909.29),(270,11,'2011-11-25',786.15),(271,5,'2011-11-27',980.73),(272,20,'2011-11-16',567.32),(273,10,'2011-11-14',832.18),(274,2,'2011-11-11',565.57),(275,20,'2011-11-29',964.67),(276,13,'2011-11-19',98.95),(277,12,'2011-11-16',627.51),(278,17,'2011-11-10',797.94),(279,11,'2011-11-30',148.05),(280,17,'2011-11-10',488.44),(281,7,'2011-11-14',932.54),(282,11,'2011-11-27',261.14),(283,20,'2011-11-12',674.59),(284,13,'2011-11-17',694.24),(285,5,'2011-11-23',149.00),(286,6,'2011-11-16',204.61),(287,14,'2011-11-19',557.07),(288,5,'2011-11-13',611.45),(289,8,'2011-11-14',237.01),(290,12,'2011-11-24',29.16),(291,3,'2011-11-27',82.08),(292,3,'2011-11-29',896.41),(293,15,'2011-11-25',894.34),(294,17,'2011-11-18',786.86),(295,4,'2011-11-20',306.67),(296,14,'2011-11-26',466.26),(297,17,'2011-11-21',606.14),(298,17,'2011-11-23',5.14),(299,5,'2011-11-21',678.34),(300,8,'2011-11-27',794.71),(301,15,'2011-11-19',655.41),(302,20,'2011-11-24',242.28),(303,17,'2011-11-26',557.00),(304,17,'2011-11-26',771.62),(305,15,'2011-11-21',483.71),(306,20,'2011-11-15',392.26),(307,17,'2011-11-12',943.92),(308,14,'2011-11-29',236.80),(309,7,'2011-11-26',36.58),(310,1,'2011-11-20',513.32),(311,19,'2011-11-29',707.97),(312,17,'2011-11-19',882.69),(313,8,'2011-11-25',509.89),(314,6,'2011-11-21',330.91),(315,15,'2011-11-10',838.14),(316,7,'2011-11-12',143.17),(317,6,'2011-11-25',825.06),(318,1,'2011-11-18',698.90),(319,3,'2011-11-27',344.31),(320,9,'2011-11-11',92.88),(321,2,'2011-11-13',763.08),(322,7,'2011-11-25',578.42),(323,17,'2011-11-18',932.55),(324,19,'2011-11-26',445.26),(325,6,'2011-11-11',980.42),(326,5,'2011-11-19',719.23),(327,15,'2011-11-10',705.02),(328,18,'2011-11-26',133.84),(329,3,'2011-11-15',452.34),(330,9,'2011-11-18',786.11),(331,20,'2011-11-26',55.53),(332,17,'2011-11-24',562.93),(333,3,'2011-11-28',729.87),(334,2,'2011-11-24',99.20),(335,15,'2011-11-19',250.63),(336,10,'2011-11-16',199.08),(337,17,'2011-11-26',232.52),(338,3,'2011-11-29',756.86),(339,2,'2011-11-30',59.60),(340,17,'2011-11-10',123.29),(341,11,'2011-11-23',851.46),(342,20,'2011-11-28',32.28),(343,9,'2011-11-22',94.09),(344,18,'2011-11-14',484.33),(345,15,'2011-11-23',97.80),(346,1,'2011-11-20',191.47),(347,14,'2011-11-29',620.48),(348,11,'2011-11-11',30.67),(349,2,'2011-11-16',518.34),(350,2,'2011-11-20',587.86),(351,12,'2011-11-19',290.64),(352,4,'2011-11-15',619.53),(353,20,'2011-11-12',587.66),(354,17,'2011-11-21',840.84),(355,17,'2011-11-13',755.22),(356,9,'2011-11-21',105.00),(357,7,'2011-11-22',204.74),(358,14,'2011-11-21',245.31),(359,7,'2011-11-17',305.03),(360,19,'2011-11-29',539.77),(361,2,'2011-11-18',177.31),(362,18,'2011-11-25',978.41),(363,7,'2011-11-11',301.05),(364,14,'2011-11-25',82.64),(365,17,'2011-11-18',140.06),(366,1,'2011-11-12',817.17),(367,12,'2011-11-10',710.31),(368,11,'2011-11-26',213.93),(369,9,'2011-11-23',325.14),(370,5,'2011-11-10',507.65),(371,12,'2011-11-30',97.87),(372,17,'2011-11-28',203.08),(373,13,'2011-11-19',631.82),(374,11,'2011-11-20',94.69),(375,10,'2011-11-23',121.72),(376,14,'2011-11-10',189.83),(377,19,'2011-11-22',390.45),(378,1,'2011-11-24',627.02),(379,12,'2011-11-14',343.48),(380,8,'2011-11-13',70.80),(381,13,'2011-11-20',539.76),(382,11,'2011-11-30',67.09),(383,4,'2011-11-16',500.78),(384,19,'2011-11-22',762.88),(385,14,'2011-11-26',851.90),(386,10,'2011-11-12',793.77),(387,5,'2011-11-24',113.68),(388,15,'2011-11-29',2.49),(389,3,'2011-11-20',66.99),(390,20,'2011-11-25',59.92),(391,10,'2011-11-10',576.32),(392,5,'2011-11-11',944.70),(393,5,'2011-11-29',258.07),(394,5,'2011-11-23',716.75),(395,7,'2011-11-13',978.95),(396,3,'2011-11-16',532.42),(397,17,'2011-11-19',71.19),(398,17,'2011-11-12',957.59),(399,18,'2011-11-17',122.51),(400,13,'2011-11-30',347.10),(401,8,'2011-11-17',776.06),(402,12,'2011-11-11',252.37),(403,17,'2011-11-25',882.14),(404,10,'2011-11-20',421.06),(405,3,'2011-11-27',517.10),(406,19,'2011-11-28',189.78),(407,9,'2011-11-14',835.57),(408,4,'2011-11-30',106.31),(409,17,'2011-11-20',312.28),(410,15,'2011-11-20',421.81),(411,20,'2011-11-18',298.28),(412,3,'2011-11-11',398.20),(413,8,'2011-11-20',239.18),(414,20,'2011-11-10',214.43),(415,3,'2011-11-15',13.40),(416,11,'2011-11-15',980.69),(417,9,'2011-11-24',342.41),(418,2,'2011-11-18',175.81),(419,4,'2011-11-26',239.55),(420,5,'2011-11-11',354.46),(421,6,'2011-11-30',895.93),(422,7,'2011-11-23',816.75),(423,14,'2011-11-17',338.53),(424,2,'2011-11-13',869.16),(425,2,'2011-11-21',354.37),(426,17,'2011-11-21',321.91),(427,19,'2011-11-17',571.29),(428,17,'2011-11-21',420.24),(429,20,'2011-11-17',691.38),(430,11,'2011-11-11',642.76),(431,10,'2011-11-24',778.91),(432,17,'2011-11-25',332.70),(433,4,'2011-11-26',278.19),(434,9,'2011-11-29',665.22),(435,19,'2011-11-30',90.85),(436,10,'2011-11-11',863.77),(437,19,'2011-11-30',870.30),(438,12,'2011-11-28',21.11),(439,10,'2011-11-28',406.55),(440,4,'2011-11-11',304.75),(441,10,'2011-11-16',89.16),(442,18,'2011-11-24',201.63),(443,12,'2011-11-26',472.45),(444,12,'2011-11-27',203.37),(445,20,'2011-11-17',122.92),(446,4,'2011-11-18',151.24),(447,17,'2011-11-19',126.37),(448,6,'2011-11-20',923.37),(449,2,'2011-11-25',694.52),(450,17,'2011-11-21',67.36),(451,9,'2011-11-15',872.68),(452,18,'2011-11-24',825.94),(453,10,'2011-11-25',623.91),(454,5,'2011-11-26',710.64),(455,15,'2011-11-24',519.29),(456,15,'2011-11-19',703.13),(457,15,'2011-11-12',91.94),(458,14,'2011-11-19',651.17),(459,11,'2011-11-21',557.99),(460,9,'2011-11-26',725.06),(461,7,'2011-11-30',116.81),(462,14,'2011-11-16',994.83),(463,19,'2011-11-28',762.82),(464,5,'2011-11-21',218.17),(465,2,'2011-11-25',448.07),(466,2,'2011-11-13',734.96),(467,18,'2011-11-15',606.01),(468,20,'2011-11-19',587.17),(469,13,'2011-11-20',365.94),(470,19,'2011-11-29',864.93),(471,13,'2011-11-25',455.59),(472,1,'2011-11-21',499.41),(473,7,'2011-11-17',299.62),(474,15,'2011-11-21',286.36),(475,3,'2011-11-13',910.72),(476,9,'2011-11-14',239.67),(477,17,'2011-11-23',510.81),(478,11,'2011-11-16',765.28),(479,17,'2011-11-30',429.17),(480,20,'2011-11-11',561.12),(481,19,'2011-11-13',124.26),(482,12,'2011-11-27',968.64),(483,1,'2011-11-11',30.05),(484,2,'2011-11-23',861.66),(485,15,'2011-11-25',492.38),(486,3,'2011-11-11',280.13),(487,19,'2011-11-11',54.46),(488,18,'2011-11-12',932.45),(489,12,'2011-11-20',488.64),(490,17,'2011-11-24',563.50),(491,13,'2011-11-11',270.37),(492,10,'2011-11-17',909.43),(493,3,'2011-11-12',353.65),(494,13,'2011-11-10',912.40),(495,18,'2011-11-27',764.19),(496,1,'2011-11-16',95.02),(497,19,'2011-11-15',101.86),(498,2,'2011-11-21',292.85),(499,11,'2011-11-27',702.38),(500,5,'2011-11-14',815.36);
/*!40000 ALTER TABLE `test_sale` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2011-11-28 12:01:29
</pre>