Changeset 27743 for extensions/MyPiwiShop/admin/MyPiwiShopBatchUnit.php

Timestamp:

Mar 12, 2014, 11:28:47 PM (10 years ago)

Author:

Miklfe

Message:

Version de lancement

File:

• extensions/MyPiwiShop/admin/MyPiwiShopBatchUnit.php (modified) (1 diff)

extensions/MyPiwiShop/admin/MyPiwiShopBatchUnit.php

@@ -20 +20 @@
         
 
-global $template, $conf, $page, $element_ids;
+global $template, $element_ids;
  
-
- $query='SELECT * FROM '.MPS_CONF_TABLE.';';
-  $result       = pwg_query($query);
+ $query='SELECT * FROM '.MPS_PRODUCT_TABLE.' ORDER BY `order`;';
+  $result = pwg_query($query);
+  $products = array();
+  
   while($row = pwg_db_fetch_assoc($result)){
-   $config = $row ;
+  $products[]= $row;
   }
 
-  $query='
-  SELECT id
-  FROM '.IMAGES_TABLE.' 
+  $query='SELECT * FROM '.MPS_CONF_TABLE.';';
+    $result     = pwg_query($query);
+  while($row = pwg_db_fetch_assoc($result)){
+    $config = $row ;
+  }
+
+ $query='
+  SELECT i.id, pi.image_id, pi.product_id
+  FROM '.IMAGES_TABLE.' AS i
+  LEFT JOIN '.MPS_PROD_IMG_TABLE.' AS pi ON pi.image_id = i.id
   WHERE id IN ('.implode(',', $element_ids).')
+  ;';
+  $result = pwg_query($query);
+  $productcheck = array();
   
-;';
-  $productImg = array();
-  $result = pwg_query($query);
-  while($row1 = pwg_db_fetch_assoc($result)){
-
-        $query='
-        SELECT *
-        FROM '.MPS_PROD_IMG_TABLE.' AS pit
-    JOIN '.MPS_PRODUCT_TABLE.' AS t ON t.id = pit.product_id
-        WHERE image_id = '.$row1['id'].'
-        ;';
-        $re = pwg_query($query);
-        $prod = array();
-        $prodid = array();
-        $productCheck = array();
-    while($row = pwg_db_fetch_assoc($re)){
-           $prod = array("id"                   =>$row['id'],
-                                         "product"              =>$row['product'],
-                                     "noteAdmin"        =>$row['noteAdmin'],
-                                     "price"            =>$row['price'],
-                                        );
-           $productCheck[]=$prod;
-           
-       $prodid[] = $row['id'];
-        for($i=0;$i<count($productCheck);$i++){
-        $productCheck[$i]['check'] = 'true';    
-        }
-        }
-
-           $query = '
-        SELECT *
-        FROM '.MPS_PRODUCT_TABLE.'
-        ;';
-        
-        $resu = pwg_query($query);
-        $product = array();
-        while($row2 = pwg_db_fetch_assoc($resu)){
-
-        if (!in_array($row2['id'], $prodid)) {
-        $product[]= $row2;
-        }
-        }
-        for($i=0;$i<count($product);$i++){
-        $product[$i]['check'] = 'false';        
-        }
-
-        $productimg = array_merge($productCheck, $product);
-
-        $productImg[$row1['id']] = $productimg;
+  while($row = pwg_db_fetch_assoc($result)){
+        $productcheck[] = $row;
   }
+                
+  
         $template->assign(array(
-        'mps_conf'                => $config,
-        'mps_productcheck' => $productImg,
+        'mps_products'     => $products,
+        'mps_conf'                 => $config,
+        'mps_productcheck' => $productcheck,
         ));