Changeset 27781 for extensions/MyPiwiShop/admin/MyPiwiShopBatch.php

Timestamp:

Mar 16, 2014, 7:16:27 PM (10 years ago)

Author:

Miklfe

Message:

 

File:

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

extensions/MyPiwiShop/admin/MyPiwiShopBatch.php

@@ -4 +4 @@
 global $template;
 
-  $query='SELECT * FROM '.MPS_PRODUCT_TABLE.' ORDER BY `order`;';
+//set batch manager 
+  $query='
+  SELECT `id`, `product`, `noteAdmin`, `price`
+  FROM '.MPS_PRODUCT_TABLE.' 
+  ORDER BY `order`
+  ;';
   $result = pwg_query($query);
-  $product = array();
   
-  while($row = pwg_db_fetch_assoc($result)){
-  $product[]= $row;
+  while($row = pwg_db_fetch_assoc($result)) {
+   $product[]= $row;
   }
   
-  $query='SELECT * FROM '.MPS_CONF_TABLE.';';
+  $query='
+  SELECT * 
+  FROM '.MPS_CONF_TABLE.'
+  ;';
   $result       = pwg_query($query);
-  while($row = pwg_db_fetch_assoc($result)){
+  
+  while($row = pwg_db_fetch_assoc($result)) {
    $config = $row ;
   }
 
- $template->assign(array(
-  'mps_product' => $product,
-  'mps_conf'    => $config
+//tempate assign
+  $template->assign(array(
+   'mps_product' => $product,
+   'mps_conf'    => $config
   ));