public function getColorsAndSizesDifferences()
 {
     $connection = connectionServer();
     $mapping = new MappingArray();
     $ps_id = "";
     $active = "";
     $category = "";
     $price = "";
     $supplier = "";
     $name = "";
     $collection = "";
     $manufacture = "";
     $qta = "";
     $qta_min = "";
     $size = "";
     $height = "";
     $width = "";
     $name_color = array();
     $quantity = array();
     $name_size = array();
     $model = "";
     $code_color = array();
     $url = "";
     $name_photo = array();
     $code_size = array();
     $sql = "SELECT * FROM new_size_color WHERE 1 ORDER BY reference ASC";
     $to_return = array();
     $result = mysql_query($sql, $connection);
     if (mysql_num_rows($result) > 0) {
         $new_reference = '';
         while ($row = mysql_fetch_array($result)) {
             if (empty($new_reference)) {
                 $new_reference = $row[1];
             }
             if ($new_reference === $row[1]) {
                 $ps_id = $row[0];
                 $active = $row[2];
                 $category = $row[3];
                 $price = $row[4];
                 $supplier = $row[5];
                 $manufacture = $row[6];
                 $qta = $row[7];
                 $qta_min = $row[8];
                 $size = $row[9];
                 $height = $row[10];
                 $width = $row[11];
                 array_push($name_color, $row[12]);
                 array_push($quantity, $row[13]);
                 array_push($name_size, $row[14]);
                 $name = $row[15];
                 $model = $row[16];
                 $collection = $row[17];
                 array_push($code_color, $row[18]);
                 $url = $row[19];
                 array_push($name_photo, $row[20]);
                 array_push($code_size, $row[21]);
             } else {
                 $array_mapping = $mapping->createSingleArrayMapping($price, $active, $new_reference, $name, $category, $supplier, $manufacture, $qta, $qta_min, $width, $height, $size, $model, $collection, $url);
                 $array_triple = $mapping->createSingleArrayTriple($new_reference, $code_color, $code_size);
                 $array_combinations = $mapping->createSingleArrayCombination($new_reference, $code_color, $code_size, $name_color, $name_size, $name_photo, $quantity);
                 $element = array();
                 array_push($element, $array_mapping);
                 array_push($element, $array_triple);
                 array_push($element, $array_combinations);
                 array_push($element, $ps_id);
                 array_push($to_return, $element);
                 $new_reference = $row[1];
                 $name_color = array();
                 $quantity = array();
                 $name_size = array();
                 $code_color = array();
                 $name_photo = array();
                 $code_size = array();
                 $ps_id = $row[0];
                 $active = $row[2];
                 $category = $row[3];
                 $price = $row[4];
                 $supplier = $row[5];
                 $manufacture = $row[6];
                 $qta = $row[7];
                 $qta_min = $row[8];
                 $size = $row[9];
                 $height = $row[10];
                 $width = $row[11];
                 array_push($name_color, $row[12]);
                 array_push($quantity, $row[13]);
                 array_push($name_size, $row[14]);
                 $name = $row[15];
                 $model = $row[16];
                 $collection = $row[17];
                 array_push($code_color, $row[18]);
                 $url = $row[19];
                 array_push($name_photo, $row[20]);
                 array_push($code_size, $row[21]);
             }
         }
         $array_mapping = $mapping->createSingleArrayMapping($price, $active, $new_reference, $name, $category, $supplier, $manufacture, $qta, $qta_min, $width, $height, $size, $model, $collection, $url);
         $array_triple = $mapping->createSingleArrayTriple($new_reference, $code_color, $code_size);
         $array_combinations = $mapping->createSingleArrayCombination($new_reference, $code_color, $code_size, $name_color, $name_size, $name_photo, $quantity);
         $element = array();
         array_push($element, $array_mapping);
         array_push($element, $array_triple);
         array_push($element, $array_combinations);
         array_push($element, $ps_id);
         array_push($to_return, $element);
         closeConnectionServer($connection);
         return $to_return;
     } else {
         closeConnectionServer($connection);
         return 0;
     }
 }
 public function getColorsAndSizesDifferences()
 {
     $connection = connectionServer();
     $mapping = new MappingArray();
     $ps_id = "";
     $active = "";
     $category = "";
     $price = "";
     $supplier = "";
     $name = "";
     $collection = "";
     $manufacture = "";
     $qta = "";
     $qta_min = "";
     $size = "";
     $height = "";
     $width = "";
     $name_color = array();
     $quantity = array();
     $name_size = array();
     $model = "";
     $code_color = array();
     $url = "";
     $name_photo = array();
     $code_size = array();
     $sql = "SELECT ps_tmp_product.ps_id, ps_buffer_product.reference, ps_buffer_product.attivo, ps_buffer_product.categoria, \nps_buffer_product.prezzo, ps_buffer_product.supplier, ps_buffer_product.manufacture, ps_buffer_product.qta, \nps_buffer_product.qta_min, ps_buffer_product.lunghezza, ps_buffer_product.altezza, ps_buffer_product.larghezza, ps_buffer_product.colore,\nps_buffer_product.quantita,ps_buffer_product.taglia, ps_buffer_product.nome, ps_buffer_product.modello,ps_buffer_product.linea, \nps_buffer_product.codice_colore, ps_buffer_product.url, ps_buffer_product.immagine, ps_buffer_product.codice_taglia FROM ps_buffer_product LEFT JOIN ps_tmp_product ON (ps_buffer_product.reference = ps_tmp_product.reference AND ps_buffer_product.codice_colore = ps_tmp_product.codice_colore AND ps_buffer_product.codice_taglia = ps_tmp_product.codice_taglia) WHERE( ps_tmp_product.ps_id IS NULL) ORDER BY ps_buffer_product.reference ASC";
     $to_return = array();
     $result = mysql_query($sql, $connection);
     if (mysql_num_rows($result) > 0) {
         $new_reference = '';
         while ($row = mysql_fetch_array($result)) {
             if (empty($new_reference)) {
                 $new_reference = $row[1];
             }
             if ($new_reference === $row[1]) {
                 $ps_id = $row[0];
                 $active = $row[2];
                 $category = $row[3];
                 $price = $row[4];
                 $supplier = $row[5];
                 $manufacture = $row[6];
                 $qta = $row[7];
                 $qta_min = $row[8];
                 $size = $row[9];
                 $height = $row[10];
                 $width = $row[11];
                 array_push($name_color, $row[12]);
                 array_push($quantity, $row[13]);
                 array_push($name_size, $row[14]);
                 $name = $row[15];
                 $model = $row[16];
                 $collection = $row[17];
                 array_push($code_color, $row[18]);
                 $url = $row[19];
                 array_push($name_photo, $row[20]);
                 array_push($code_size, $row[21]);
             } else {
                 $array_mapping = $mapping->createSingleArrayMapping($price, $active, $new_reference, $name, $category, $supplier, $manufacture, $qta, $qta_min, $width, $height, $size, $model, $collection, $url);
                 $array_triple = $mapping->createSingleArrayTriple($new_reference, $code_color, $code_size);
                 $array_combinations = $mapping->createSingleArrayCombination($new_reference, $code_color, $code_size, $name_color, $name_size, $name_photo, $quantity);
                 $element = array();
                 array_push($element, $array_mapping);
                 array_push($element, $array_triple);
                 array_push($element, $array_combinations);
                 array_push($element, $ps_id);
                 array_push($to_return, $element);
                 $new_reference = $row[1];
                 $name_color = array();
                 $quantity = array();
                 $name_size = array();
                 $code_color = array();
                 $name_photo = array();
                 $code_size = array();
                 $ps_id = $row[0];
                 $active = $row[2];
                 $category = $row[3];
                 $price = $row[4];
                 $supplier = $row[5];
                 $manufacture = $row[6];
                 $qta = $row[7];
                 $qta_min = $row[8];
                 $size = $row[9];
                 $height = $row[10];
                 $width = $row[11];
                 array_push($name_color, $row[12]);
                 array_push($quantity, $row[13]);
                 array_push($name_size, $row[14]);
                 $name = $row[15];
                 $model = $row[16];
                 $collection = $row[17];
                 array_push($code_color, $row[18]);
                 $url = $row[19];
                 array_push($name_photo, $row[20]);
                 array_push($code_size, $row[21]);
             }
         }
         $array_mapping = $mapping->createSingleArrayMapping($price, $active, $new_reference, $name, $category, $supplier, $manufacture, $qta, $qta_min, $width, $height, $size, $model, $collection, $url);
         $array_triple = $mapping->createSingleArrayTriple($new_reference, $code_color, $code_size);
         $array_combinations = $mapping->createSingleArrayCombination($new_reference, $code_color, $code_size, $name_color, $name_size, $name_photo, $quantity);
         $element = array();
         array_push($element, $array_mapping);
         array_push($element, $array_triple);
         array_push($element, $array_combinations);
         array_push($element, $ps_id);
         array_push($to_return, $element);
         closeConnectionServer($connection);
         return $to_return;
     } else {
         closeConnectionServer($connection);
         return 0;
     }
 }