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;
}
private function _compare_images(ISC_PRODUCT_IMAGE $image1, ISC_PRODUCT_IMAGE $image2)
{
if ((int)$image1->getSort() < (int)$image2->getSort()) {
return -1;
}
else {
return 1;
}
}
/**
* Takes a product id and product image id and modifies the sorting values of all affected product images to "move this image after another image"
*
* @param ISC_ADMIN_REMOTE $remote
*/
public function remoteMoveImageAfterOtherImage(ISC_ADMIN_REMOTE $remote)
{
// this method is used instead of simply receiving a full serialize of the new product order, it allows us to update more efficiently by knowing which image was moved and only updating the affected sort orders
$response = array();
$productId = false;
$productHash = false;
if (isset($_POST['product'])) {
$productId = (int)@$_POST['product'];
if (!isId($productId) || !ProductExists($productId)) {
$response[] = $remote->MakeXMLTag('error', GetLang('ProductDoesntExist'), true);
} else if (!$GLOBALS["ISC_CLASS_ADMIN_AUTH"]->HasPermission(AUTH_Edit_Products)) {
$response[] = $remote->MakeXMLTag('error', GetLang('Unauthorized'), true);
}
} else if (isset($_POST['hash']) && $_POST['hash']) {
$productHash = $_POST['hash'];
if (!$GLOBALS["ISC_CLASS_ADMIN_AUTH"]->HasPermission(AUTH_Create_Product)) {
$response[] = $remote->MakeXMLTag('error', GetLang('Unauthorized'), true);
}
} else {
$response[] = $remote->MakeXMLTag('error', GetLang('ProductDoesntExist'), true);
}
if (!empty($response)) {
$remote->SendXMLHeader();
$remote->SendXMLResponse($response);
die();
}
$moveId = (int)$_POST['move'];
try {
$moveImage = new ISC_PRODUCT_IMAGE($moveId);
} catch (ISC_PRODUCT_IMAGE_INVALIDID_EXCEPTION $e) {
$response[] = $remote->MakeXMLTag('error', sprintf(GetLang('ProductImageInvalidId'), $moveId), true);
} catch (ISC_PRODUCT_IMAGE_RECORDNOTFOUND_EXCEPTION $e) {
$response[] = $remote->MakeXMLTag('error', sprintf(GetLang('ProductImageNotFound'), $moveId), true);
} catch (Exception $e) {
$response[] = $remote->MakeXMLTag('error', GetLang('ProductImageMoveDatabaseError'), true);
}
if (!empty($response)) {
$remote->SendXMLHeader();
$remote->SendXMLResponse($response);
die();
}
$moveSort = $moveImage->getSort();
if ($productId && $moveImage->getProductId() !== $productId || $productHash && $moveImage->getProductHash() !== $productHash) {
// provided image id does not belong to provided product id
$response[] = $remote->MakeXMLTag('error', sprintf(GetLang('ProductImageMismatchError'), $moveId, $productId), true);
$remote->SendXMLHeader();
$remote->SendXMLResponse($response);
die();
}
if (isset($_POST['after'])) {
$afterId = (int)$_POST['after'];
try {
$afterImage = new ISC_PRODUCT_IMAGE($afterId);
} catch (ISC_PRODUCT_IMAGE_INVALIDID_EXCEPTION $e) {
$response[] = $remote->MakeXMLTag('error', sprintf(GetLang('ProductImageInvalidId'), $afterId), true);
$remote->SendXMLHeader();
$remote->SendXMLResponse($response);
die();
} catch (ISC_PRODUCT_IMAGE_RECORDNOTFOUND_EXCEPTION $e) {
$response[] = $remote->MakeXMLTag('error', sprintf(GetLang('ProductImageNotFound'), $afterId), true);
$remote->SendXMLHeader();
$remote->SendXMLResponse($response);
die();
} catch (Exception $e) {
$response[] = $remote->MakeXMLTag('error', GetLang('ProductImageMoveDatabaseError'), true);
$remote->SendXMLHeader();
$remote->SendXMLResponse($response);
die();
}
if ($productId && $afterImage->getProductId() !== $productId || $productHash && $afterImage->getProductHash() !== $productHash) {
// provided image id does not belong to provided product id
$response[] = $remote->MakeXMLTag('error', sprintf(GetLang('ProductImageMismatchError'), $afterId, $productId), true);
$remote->SendXMLHeader();
$remote->SendXMLResponse($response);
die();
}
$afterSort = $afterImage->getSort();
} else {
$after = false;
$afterSort = -1;
}
if ($moveImage->getProductHash()) {
if (!$GLOBALS["ISC_CLASS_ADMIN_AUTH"]->HasPermission(AUTH_Create_Product)) {
$response[] = GetLang('Unauthorized');
$remote->SendXMLHeader();
$remote->SendXMLResponse($response);
die();
}
} else {
if (!$GLOBALS["ISC_CLASS_ADMIN_AUTH"]->HasPermission(AUTH_Edit_Products)) {
$response[] = GetLang('Unauthorized');
$remote->SendXMLHeader();
$remote->SendXMLResponse($response);
die();
}
}
// create an sql query to shift all sorting values between the two anchor points
if ($moveSort > $afterSort) {
$sql = "UPDATE `[|PREFIX|]product_images` SET imagesort = imagesort + 1 WHERE imageprodid = " . $moveImage->getProductId() . " AND imagesort > " . $afterSort . " AND imagesort < " . $moveSort;
$newSort = $afterSort + 1;
} else {
$sql = "UPDATE `[|PREFIX|]product_images` SET imagesort = imagesort - 1 WHERE imageprodid = " . $moveImage->getProductId() . " AND imagesort > " . $moveSort . " AND imagesort <= " . $afterSort;
$newSort = $afterSort;
}
$db = $GLOBALS['ISC_CLASS_DB'];
$db->Query("SET autocommit = 0");
$db->Query("LOCK TABLES `[|PREFIX|]product_images` WRITE");
$result = $db->Query($sql);
if ($result) {
$moveImage->setSort($newSort);
try {
$moveImage->saveToDatabase(false);
$db->Query("COMMIT");
$response[] = $remote->MakeXMLTag('success', GetLang('ProductImagesSortOrderChanged'), true);
} catch (Exception $e) {
$db->Query("ROLLBACK");
$response[] = $remote->MakeXMLTag('success', GetLang('ProductImageMoveDatabaseError'), true);
}
$db->Query("UNLOCK TABLES");
} else {
$db->Query("ROLLBACK");
$db->Query("UNLOCK TABLES");
$response[] = $remote->MakeXMLTag('success', GetLang('ProductImageMoveDatabaseError'), true);
}
$remote->SendXMLHeader();
$remote->SendXMLResponse($response);
die();
}
