private function _SetImageData()
{
$this->_prodid = (int)$_GET['product_id'];
// Load the product name
$query = sprintf("select prodname from [|PREFIX|]products where productid='%d'", $GLOBALS['ISC_CLASS_DB']->Quote($this->GetProductId()));
$result = $GLOBALS['ISC_CLASS_DB']->Query($query);
$this->_prodname = $GLOBALS['ISC_CLASS_DB']->FetchOne($result, "prodname");
// Are we showing the image for a particular variation?
if(isset($_GET['variation_id'])) {
$this->_variationid = (int)$_GET['variation_id'];
$query = "SELECT vcimage, vcimagezoom FROM [|PREFIX|]product_variation_combinations WHERE vcproductid='".$this->_prodid."' AND combinationid='".$this->_variationid."'";
$result = $GLOBALS['ISC_CLASS_DB']->Query($query);
if (!$variation = $GLOBALS['ISC_CLASS_DB']->Fetch($result)) {
// Invalid variation
exit;
}
if ($variation['vcimage'] && $variation['vcimagezoom']) {
// use the product image library to get the url which will trigger a resize if necessary
try {
$productImage = new ISC_PRODUCT_IMAGE;
$productImage->setSourceFilePath($variation['vcimage']);
$productImage->setResizedFilePath(ISC_PRODUCT_IMAGE_SIZE_ZOOM, $variation['vcimagezoom']);
$this->_variationImage = $productImage->getResizedUrl(ISC_PRODUCT_IMAGE_SIZE_ZOOM, true, false);
} catch (Exception $exception) {
// nothing
}
}
}
// Otherwise, just load general images for a product
//else {
// Load the images into an array
$productImages = ISC_PRODUCT_IMAGE::getProductImagesFromDatabase($this->GetProductId());
if(!empty($productImages)) {
$i = 0;
foreach ($productImages as $productImage) {
$imgDesc = '';
$zoomImg = '';
$tinyImg = '';
$thumbImg = '';
try{
$zoomImg = $productImage->getResizedUrl(ISC_PRODUCT_IMAGE_SIZE_ZOOM, true);
} catch (Exception $exception) {
// do nothing, will result in returning blank string, which is fine
}
try{
$thumbImg = $productImage->getResizedUrl(ISC_PRODUCT_IMAGE_SIZE_STANDARD, true);
//$GLOBALS['ProductThumbURL'] = $thumbURL;
} catch (Exception $exception) {
}
// if both standard image and zoom image not exist, go to the next image.
if($thumbImg == '' && $zoomImg == '') {
continue;
}
try{
$tinyImg = $productImage->getResizedUrl(ISC_PRODUCT_IMAGE_SIZE_TINY, true);
} catch (Exception $exception) {
// do nothing, will result in returning blank string, which is fine
}
$imgDesc = $productImage->getDescription();
if ($imgDesc == '') {
$imgIndex= $i+1;
$imgDesc = GetLang("Image")." ".$imgIndex;
}
if($zoomImg!= '' ) {
$this->_prodimages['zoom'][] = $zoomImg;
//use standard image if zoom image not exist.
} else {
$this->_prodimages['zoom'][] = $thumbImg;
}
$this->_prodimages['tiny'][] = $tinyImg;
$this->_prodImagesDescriptions[] = $imgDesc;
$i++;
}
//}
// How many images are there?
$this->_prodnumimages = count($this->_prodimages['zoom']);
}
// Which image should we show?
if(isset($_GET['current_image'])) {
$this->_prodcurrentimage = (int)$_GET['current_image'];
} elseif(isset($_GET['variation_id'])) {
$this->_prodcurrentimage = 'variation';
}
}
public function Action_GetProduct()
{
if(empty($this->router->request->details->productId)) {
$this->BadRequest('The details->productId node is missing');
}
$image = new ISC_PRODUCT_IMAGE(); // autoload helper so we can use exceptions defined in the product image class file
unset($image);
$productId = (int)$this->router->request->details->productId;
$productClass = new ISC_PRODUCT($productId);
$product = $productClass->_product;
// stuff that comes directly from the database may be incomplete -- use the image library to make sure
try {
if (!$product['imageid']) {
// no image present in data so throw an exception just to force the removal of data below in the catch{} block
throw new ISC_PRODUCT_IMAGE_EXCEPTION();
}
$image = new ISC_PRODUCT_IMAGE();
$image->populateFromDatabaseRow($product);
// call the image library to make sure resized images are present and then add full urls so they're useful for remote users
$product['imagefiletiny'] = $image->getResizedUrl(ISC_PRODUCT_IMAGE_SIZE_TINY, true, true, false);
$product['imagefilethumb'] = $image->getResizedUrl(ISC_PRODUCT_IMAGE_SIZE_THUMBNAIL, true, true, false);
$product['imagefilestd'] = $image->getResizedUrl(ISC_PRODUCT_IMAGE_SIZE_STANDARD, true, true, false);
$product['imagefilezoom'] = $image->getResizedUrl(ISC_PRODUCT_IMAGE_SIZE_ZOOM, true, true, false);
// call the image library to make sure resized images are present and the sizes are correct
$product['imagefiletinysize'] = implode('x', $image->getResizedFileDimensions(ISC_PRODUCT_IMAGE_SIZE_TINY));
$product['imagefilethumbsize'] = implode('x', $image->getResizedFileDimensions(ISC_PRODUCT_IMAGE_SIZE_THUMBNAIL));
$product['imagefilestdsize'] = implode('x', $image->getResizedFileDimensions(ISC_PRODUCT_IMAGE_SIZE_STANDARD));
$product['imagefilezoomsize'] = implode('x', $image->getResizedFileDimensions(ISC_PRODUCT_IMAGE_SIZE_ZOOM));
} catch (Exception $exception) {
// some sort of problem when dealing with product images - remove image info from the response
unset(
$product['imagefiletiny'],
$product['imagefilethumb'],
$product['imagefilestd'],
$product['imagefilezoom'],
$product['imagefiletinysize'],
$product['imagefilethumbsize'],
$product['imagefilestdsize'],
$product['imagefilezoomsize'],
$product['imagedesc'],
$product['imagedateadded']
);
}
// direct data feed also includes some fields that are irrelevant or unwanted
unset(
$product['imagefile'], // don't provide a link to the non-water-marked image
$product['imageprodid'],
$product['imageprodhash'],
$product['imageisthumb'],
$product['imagesort']
);
if(empty($product)) {
return array();
}
$product['prodlink'] = ProdLink($product['prodname']);
// Fetch any images for the product
$images = new ISC_PRODUCT_IMAGE_ITERATOR(ISC_PRODUCT_IMAGE::generateGetProductImagesFromDatabaseSql((int)$productId));
foreach ($images as $image) {
/** @var $image ISC_PRODUCT_IMAGE */
$imageisthumb = 0;
if ($image->getIsThumbnail()) {
$imageisthumb = 1;
}
try {
$product['images']['item'][] = array(
'imageid' => $image->getProductImageId(),
'imagefiletiny' => $image->getResizedUrl(ISC_PRODUCT_IMAGE_SIZE_TINY, true, true, false),
'imagefilethumb' => $image->getResizedUrl(ISC_PRODUCT_IMAGE_SIZE_THUMBNAIL, true, true, false),
'imagefilestd' => $image->getResizedUrl(ISC_PRODUCT_IMAGE_SIZE_STANDARD, true, true, false),
'imagefilezoom' => $image->getResizedUrl(ISC_PRODUCT_IMAGE_SIZE_ZOOM, true, true, false),
'imagefiletinysize' => implode('x', $image->getResizedFileDimensions(ISC_PRODUCT_IMAGE_SIZE_TINY)),
'imagefilethumbsize' => implode('x', $image->getResizedFileDimensions(ISC_PRODUCT_IMAGE_SIZE_THUMBNAIL)),
'imagefilestdsize' => implode('x', $image->getResizedFileDimensions(ISC_PRODUCT_IMAGE_SIZE_STANDARD)),
'imagefilezoomsize' => implode('x', $image->getResizedFileDimensions(ISC_PRODUCT_IMAGE_SIZE_ZOOM)),
'imageisthumb' => $imageisthumb,
'imagesort' => $image->getSort(),
'imagedesc' => $image->getDescription(),
'imagedateadded' => $image->getDateAdded(),
);
} catch (Exception $exception) {
// skip this image and bring down the count of product images obtained from ISC_PRODUCT
$product['numimages']--;
}
}
// Fetch the categories this product belongs to
$trailCategories = array();
$crumbList = array();
$query = "
SELECT c.categoryid, c.catparentlist
FROM [|PREFIX|]categoryassociations ca
JOIN [|PREFIX|]categories c ON (c.categoryid=ca.categoryid)
WHERE ca.productId='".(int)$productId."'
";
$result = $GLOBALS['ISC_CLASS_DB']->Query($query);
while ($row = $GLOBALS['ISC_CLASS_DB']->Fetch($result)) {
if ($row['catparentlist'] == '') {
$row['catparentlist'] = $row['categoryid'];
}
$cats = explode(",", $row['catparentlist']);
$trailCategories = array_merge($trailCategories, $cats);
$crumbList[$row['categoryid']] = $row['catparentlist'];
}
$trailCategories = implode(",", array_unique($trailCategories));
$categories = array();
if ($trailCategories != '') {
// Now load the names for the parent categories from the database
$query = "
SELECT categoryid, catname
FROM [|PREFIX|]categories
WHERE categoryid IN (".$trailCategories.")
";
$result = $GLOBALS['ISC_CLASS_DB']->Query($query);
while ($row = $GLOBALS['ISC_CLASS_DB']->Fetch($result)) {
$categories[$row['categoryid']] = $row['catname'];
}
}
// Now we have all of the information we need to build the trails, lets actually build them
foreach ($crumbList as $productcatid => $trail) {
$cats = explode(',', $trail);
$catName = '';
$catLink = CatLink($productcatid, $categories[$productcatid]);
foreach ($cats as $categoryid) {
if(isset($categories[$categoryid])) {
if($catName) {
$catName .= ' » ';
}
$catName .= $categories[$categoryid];
}
}
$product['categories']['item'][] = array(
'name' => $catName,
'link' => $catLink,
'id' => $productcatid
);
}
if($product['prodvariationid'] > 0) {
if ($product['prodsaleprice'] != 0) {
$variationBasePrice = $product['prodsaleprice'];
}
else {
$variationBasePrice = $product['prodprice'];
}
$vop = $productClass->_prodvariationoptions;
$vval = $productClass->_prodvariationvalues;
foreach($productClass->_prodvariationcombinations as $variation) {
$variationPrice = CurrencyConvertFormatPrice(CalcProductVariationPrice($variationBasePrice, $variation['vcpricediff'], $variation['vcprice'], $product));
$variationWeight = FormatWeight(CalcProductVariationWeight($product['prodweight'], $variation['vcweightdiff'], $variation['vcweight']), true);
$variationName = array();
$options = explode(',', $variation['vcoptionids']);
foreach($options as $k => $optionId) {
$label = $vop[$k];
$variationName[] = $label.': '.$vval[$label][$optionId];
}
$variationName = implode(', ', $variationName);
$variationRow = array(
'name' => $variationName,
'id' => $variation['combinationid'],
'price' => $variationPrice,
'sku' => $variation['vcsku'],
'weight' => $variationWeight,
);
if($product['prodinvtrack'] == 2) {
$variationRow['stock'] = $variation['vcstock'];
}
if ($variation['vcimage']) {
try {
$image = new ISC_PRODUCT_IMAGE;
$image->setSourceFilePath($variation['vcimage']);
if($variation['vcimagethumb']) {
$image->setResizedFilePath(ISC_PRODUCT_IMAGE_SIZE_THUMBNAIL, $variation['vcimagethumb']);
$variationRow['thumb'] = $image->getResizedFilePath(ISC_PRODUCT_IMAGE_SIZE_THUMBNAIL, true, false);
}
if($variation['vcimagestd']) {
$image->setResizedFilePath(ISC_PRODUCT_IMAGE_SIZE_STANDARD, $variation['vcimagestd']);
$variationRow['standard'] = $image->getResizedFilePath(ISC_PRODUCT_IMAGE_SIZE_STANDARD, true, false);
}
if($variation['vcimagezoom']) {
$image->setResizedFilePath(ISC_PRODUCT_IMAGE_SIZE_ZOOM, $variation['vcimagezoom']);
$variationRow['image'] = $image->getResizedFilePath(ISC_PRODUCT_IMAGE_SIZE_ZOOM, true, false);
}
} catch (Exception $exception) {
// nothing
}
}
$product['variations']['item'][] = $variationRow;
}
}
return $product;
}
/**
* Gets an array of formatted details for a specific combination row such as pricing, weight, images
*
* @param array Database row of combination information
* @param int The customer group to use to determine the final product price (used when getting variation details from back end quote system)
* @return array The formatted combination details
*/
public function GetCombinationDetails($combination, $customerGroupId = null)
{
$thumb = '';
$image = '';
$priceOptions = array(
'variationModifier' => $combination['vcpricediff'],
'variationAdjustment' => $combination['vcprice'],
);
if (!is_null($customerGroupId)) {
$priceOptions['customerGroup'] = $customerGroupId;
}
if($this->GetProductCallForPricingLabel()) {
$variationPrice = $GLOBALS['ISC_CLASS_TEMPLATE']->ParseGL($this->GetProductCallForPricingLabel());
}
else {
$variationPrice = formatProductDetailsPrice($this->_product, $priceOptions);
}
$calculatedPrice = calculateFinalProductPrice($this->_product, $this->_prodcalculatedprice, $priceOptions);
$calculatedPrice = getClass('ISC_TAX')->getPrice(
$calculatedPrice,
$this->_product['tax_class_id'],
getConfig('taxDefaultTaxDisplayProducts')
);
$variationSaveAmount = '';
if($this->_prodretailprice > 0) {
$rrp = calculateFinalProductPrice($this->_product, $this->_prodretailprice, $priceOptions);
$rrp = getClass('ISC_TAX')->getPrice(
$rrp,
$this->_product['tax_class_id'],
getConfig('taxDefaultTaxDisplayProducts')
);
$youSave = $rrp - $calculatedPrice;
if($youSave > 0) {
$variationSaveAmount = CurrencyConvertFormatPrice($youSave);
}
}
$variationWeight = FormatWeight(CalcProductVariationWeight($this->_prodweight, $combination['vcweightdiff'], $combination['vcweight']), true);
// use the product image class for automatic resizing
$productImage = new ISC_PRODUCT_IMAGE;
if ($combination['vcimage']) {
$productImage->setSourceFilePath($combination['vcimage']);
if ($combination['vcimagestd']) {
$productImage->setResizedFilePath(ISC_PRODUCT_IMAGE_SIZE_STANDARD, $combination['vcimagestd']);
$thumb = $productImage->getResizedUrl(ISC_PRODUCT_IMAGE_SIZE_STANDARD, true, false);
}
if ($combination['vcimagezoom']) {
//check if zoom image is large enough for image zoomer
try {
$productImage->setResizedFilePath(ISC_PRODUCT_IMAGE_SIZE_ZOOM, $combination['vcimagezoom']);
list($zoomWidth, $zoomHeight) = $productImage->getResizedFileDimensions(ISC_PRODUCT_IMAGE_SIZE_ZOOM, true, false);
if ($zoomWidth >= ISC_PRODUCT_IMAGE_MIN_ZOOM_WIDTH || $zoomHeight >= ISC_PRODUCT_IMAGE_MIN_ZOOM_HEIGHT) {
$image = $productImage->getResizedUrl(ISC_PRODUCT_IMAGE_SIZE_ZOOM, true, false);
}
} catch (Exception $exception) {
// do nothing, will result in returning blank string, which is fine
}
}
}
// Tracking inventory on a product variation level
if($this->_prodinvtrack == 2) {
$stock = $combination['vcstock'];
}
else {
$stock = $this->_prodcurrentinv;
}
if($stock <= 0 && $this->_prodinvtrack != 0) {
$instock = false;
}
else {
$instock = true;
}
$return = array(
'combinationid' => $combination['combinationid'],
'saveAmount' => $variationSaveAmount,
'price' => $variationPrice,
'unformattedPrice' => formatPrice($calculatedPrice, false, false),
'sku' => $combination['vcsku'],
'weight' => $variationWeight,
'thumb' => $thumb,
'image' => $image,
'instock' => $instock
);
if (GetConfig('ShowInventory') == 1 && (!$this->IsPreOrder() || GetConfig('ShowPreOrderInventory') == 1)) {
$return['stock'] = $stock;
}
return $return;
}
/**
* Get the thumbnail image of this quote item.
*
* @return string Thumbnail image path.
*/
public function getThumbnail()
{
$productData = $this->getProductData();
if (!empty($productData['variation']['vcimage']) && !empty($productData['variation']['vcimagethumb'])) {
try {
$image = new ISC_PRODUCT_IMAGE;
$image->setSourceFilePath($productData['variation']['vcimage']);
$image->setResizedFilePath(ISC_PRODUCT_IMAGE_SIZE_THUMBNAIL, $productData['variation']['vcimagethumb']);
return $image->getResizedUrl(ISC_PRODUCT_IMAGE_SIZE_THUMBNAIL, true, false);
} catch (Exception $exception) {
return '';
}
}
try {
$image = new ISC_PRODUCT_IMAGE();
$image->populateFromDatabaseRow($productData);
return $image->getResizedUrl(ISC_PRODUCT_IMAGE_SIZE_THUMBNAIL, true);
} catch (Exception $exception) {
return '';
}
}
public function processProductImages()
{
GetLib('class.json');
/** @var ISC_LOG */
$log = $GLOBALS['ISC_CLASS_LOG'];
$query = "
SELECT
(SELECT COUNT(*) FROM [|PREFIX|]product_images) AS prodimagecount,
(SELECT COUNT(DISTINCT vcimage, vcimagezoom, vcimagestd, vcimagethumb) FROM [|PREFIX|]product_variation_combinations WHERE vcimage != '') AS varimagecount
";
$result = $this->db->Query($query);
$countrow = $this->db->Fetch($result);
$total = $countrow['prodimagecount'] + $countrow['varimagecount'];
$start = max(0, @(int)$_POST['start']);
$limit = 10;
$completed = 0;
if ($start < $countrow['prodimagecount']) {
$imageIterator = new ISC_PRODUCT_IMAGE_ITERATOR('select * from `[|PREFIX|]product_images` limit ' . $start . ', ' . $limit);
foreach($imageIterator as $imageId => $image) {
try {
// the first argument to saveToDatabase is $generateImages. If true (is by default), the images will be regenerated
$image->saveToDatabase();
} catch (Exception $exception) {
$log->LogSystemDebug('general', 'Exception while processing product image ' . $imageId, $exception->getMessage());
}
++$completed;
}
}
// was there any remaining 'items' to process for this iteration? start on variation images
$var_limit = $limit - $completed;
if ($var_limit > 0) {
$var_start = max(0, $start - $countrow['prodimagecount']);
$query = '
SELECT
vcimage, vcimagezoom, vcimagestd, vcimagethumb
FROM
[|PREFIX|]product_variation_combinations
WHERE
vcimage != ""
GROUP BY
vcimage, vcimagezoom, vcimagestd, vcimagethumb
ORDER BY
vcimage
LIMIT
' . $var_start . ', ' . $var_limit;
$result = $this->db->Query($query);
while ($row = $this->db->Fetch($result)) {
try {
$image = new ISC_PRODUCT_IMAGE;
$image->setSourceFilePath($row['vcimage']);
if ($row['vcimagezoom']) {
$image->setResizedFilePath(ISC_PRODUCT_IMAGE_SIZE_ZOOM, $row['vcimagezoom']);
}
if ($row['vcimagestd']) {
$image->setResizedFilePath(ISC_PRODUCT_IMAGE_SIZE_STANDARD, $row['vcimagestd']);
}
if ($row['vcimagethumb']) {
$image->setResizedFilePath(ISC_PRODUCT_IMAGE_SIZE_THUMBNAIL, $row['vcimagethumb']);
}
$updatedVariation = array(
'vcimagezoom' => $image->getResizedFilePath(ISC_PRODUCT_IMAGE_SIZE_ZOOM, true, false),
'vcimagestd' => $image->getResizedFilePath(ISC_PRODUCT_IMAGE_SIZE_STANDARD, true, false),
'vcimagethumb' => $image->getResizedFilePath(ISC_PRODUCT_IMAGE_SIZE_THUMBNAIL, true, false),
);
$this->db->UpdateQuery('product_variation_combinations', $updatedVariation, "vcimage = '" . $this->db->Quote($row['vcimage']) . "'");
}
catch (Exception $exception) {
$log->LogSystemDebug('general', 'Exception while processing variation image ' . $row['vcimage'], $exception->getMessage());
}
++$completed;
}
}
$result = array('completed' => $completed, 'start' => (int)$start, 'total'=> (int)$total);
ISC_JSON::output('', true, $result);
exit;
}
