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

<?php
defined('MPS_PATH') or die('Hacking attempt!');
/*      *
*** submit change
**/     
        
if(isset($_POST['imgid']))
        {
        $imgid = $_POST['imgid'];
        $imgen = array($imgid);
        if (!isset($_POST['productcheck'])) {
                deletThis_image_Allproduct($imgid);
        }
        else{   

        $product_id = $_POST['productcheck'];
        add_product_Thisimage($product_id, $imgen);
  }
}       
        

global $template, $conf, $page, $element_ids;
 

 $query='SELECT * FROM '.MPS_CONF_TABLE.';';
  $result       = pwg_query($query);
  while($row = pwg_db_fetch_assoc($result)){
   $config = $row ;
  }

  $query='
  SELECT id
  FROM '.IMAGES_TABLE.' 
  WHERE id IN ('.implode(',', $element_ids).')
  
;';
  $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;
  }
        $template->assign(array(
        'mps_conf'                => $config,
        'mps_productcheck' => $productImg,
        ));