source: extensions/MyPiwiShop/admin/MyPiwiShopBatchUnit.php @ 29449

<?php
defined('MPS_PATH') or die('Hacking attempt!');

//change product check  
  if(isset($_POST['imgid'])) {
   $imgid = $_POST['imgid'];
   $imgen = array($imgid);
   
        if (!isset($_POST['productcheck'])) {
         delet_Allproduct_Thisimage($imgid);
        } else {
         $product_id = $_POST['productcheck'];
         add_product_Thisimage($product_id, $imgen);
    }
  }     
        
//set batch manager unit
  global $template, $element_ids;
 
  $query='
  SELECT `id`, `product`, `noteAdmin`, `price`
  FROM '.MPS_PRODUCT_TABLE.'
  ORDER BY `order`
  ;';
  $result = pwg_query($query);
  
  while($row = pwg_db_fetch_assoc($result)){
   $products[]= $row;
  }

  $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);
  
  while($row = pwg_db_fetch_assoc($result)){
   $productcheck[] = $row;
  }
                
//template assign 
  $template->assign(array(
   'mps_products'         => $products,
   'mps_conf'             => $config,
   'mps_productcheck' => $productcheck,
));