source: extensions/MyPiwiShop/include/functions.inc.php @ 27568

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

/**
*prefilte calcul
**/
function filter_sets_image_format($ratios)
{
  $res = array();
  
   $query = '
   SELECT id, width, height
   FROM '.IMAGES_TABLE.'
   ;';
        
   $result = pwg_query($query);
   if (pwg_db_num_rows($result))
   {
    while ($row = pwg_db_fetch_assoc($result))
    {
    if ($row['width']>0 && $row['height']>0)
     {
     $ratio = floor($row['width'] / $row['height'] * 100) / 100;
                
    if(($ratio > $ratios[0] && $ratio < $ratios[1]) || ($ratio > $ratios[2] && $ratio < $ratios[3]))
     {
      $res[] = $row['id']; 
     }
        }
   }
 }
        return $res;
}

/**
*product/image
**/
function add_product_image($product, $images)
{
  if (count($product) == 0 or count($images) == 0)
  {
    return;
  }

  $query = '
        DELETE
        FROM '.MPS_PROD_IMG_TABLE.'
        WHERE image_id IN ('.implode(',', $images).')
        AND product_id IN ('.implode(',', $product).')

        ;';
  pwg_query($query);

  $inserts = array();
  foreach ($images as $image_id)
  {
    foreach ( array_unique($product) as $product_id)
    {
      $inserts[] = array(
          'image_id' => $image_id,
          'product_id' => $product_id,
        );
    }
  }
    mass_inserts(
    MPS_PROD_IMG_TABLE,
    array_keys($inserts[0]),
    $inserts
    );
}

/**
*product/image
**/
function deletAll_product_image($product, $images)
{
  $query = '
        DELETE
        FROM '.MPS_PROD_IMG_TABLE.'
        WHERE image_id IN ('.implode(',', $images).')
        AND product_id IN ('.implode(',', $product).')

        ;';
  pwg_query($query);

}

function deletThis_image_Allproduct($images)
{
  $query = '
        DELETE
        FROM '.MPS_PROD_IMG_TABLE.'
        WHERE image_id IN ('.$images.')

        ;';
  pwg_query($query);

}

function add_product_Thisimage($product, $images)
{
  if (count($product) == 0 or count($images) == 0)
  {
    return;
  }

  $query = '
        DELETE
        FROM '.MPS_PROD_IMG_TABLE.'
        WHERE image_id IN ('.implode(',', $images).')

        ;';
  pwg_query($query);

  $inserts = array();
  foreach ($images as $image_id)
  {
    foreach ( array_unique($product) as $product_id)
    {
      $inserts[] = array(
          'image_id' => $image_id,
          'product_id' => $product_id,
        );
    }
  }
    mass_inserts(
    MPS_PROD_IMG_TABLE,
    array_keys($inserts[0]),
    $inserts
    );
}