/**
* Currently only works for products containing one single download
*
* @param IsotopeProduct $objProduct
* @param array $arrConfig
*/
public function downloadSingleProduct(IsotopeProduct $objProduct, array $arrConfig = array())
{
if (($objDownload = Download::findByPid($objProduct->getProductId())) !== null && ($strPath = Files::getPathFromUuid($objDownload->singleSRC))) {
// TODO count downloads
// start downloading the file (protected folders also supported)
\Controller::redirect(Environment::getUrl() . '?file=' . $strPath);
}
}
/**
* Find prices for a given product and collection
*
* @param IsotopeProduct|Standard $objProduct
* @param IsotopeProductCollection|ProductCollection $objCollection
* @param array $arrOptions
*
* @return IsotopePrice
*/
public static function findByProductAndCollection(IsotopeProduct $objProduct, IsotopeProductCollection $objCollection, array $arrOptions = array())
{
$t = static::$strTable;
$arrOptions['column'] = array();
$arrOptions['value'] = array();
if ($objProduct->hasAdvancedPrices()) {
$time = \Date::floorToMinute($objCollection->getLastModification());
$arrGroups = static::getMemberGroups($objCollection->getRelated('member'));
$arrOptions['column'][] = "{$t}.config_id IN (" . (int) $objCollection->config_id . ",0)";
$arrOptions['column'][] = "{$t}.member_group IN(" . implode(',', $arrGroups) . ")";
$arrOptions['column'][] = "({$t}.start='' OR {$t}.start<'{$time}')";
$arrOptions['column'][] = "({$t}.stop='' OR {$t}.stop>'" . ($time + 60) . "')";
$arrOptions['order'] = "{$t}.config_id DESC, " . \Database::getInstance()->findInSet('member_group', $arrGroups) . ", {$t}.start DESC, {$t}.stop DESC";
} else {
$arrOptions['column'][] = "{$t}.config_id=0";
$arrOptions['column'][] = "{$t}.member_group=0";
$arrOptions['column'][] = "{$t}.start=''";
$arrOptions['column'][] = "{$t}.stop=''";
}
if ($objProduct->hasVariantPrices() && !$objProduct->isVariant()) {
$arrIds = $objProduct->getVariantIds() ?: array(0);
$arrOptions['column'][] = "{$t}.pid IN (" . implode(',', $arrIds) . ")";
} else {
$arrOptions['column'][] = "{$t}.pid=" . ($objProduct->hasVariantPrices() ? $objProduct->id : $objProduct->getProductId());
}
$objResult = static::find($arrOptions);
return null === $objResult ? null : $objResult->filterDuplicatesBy('pid');
}
/**
* Find related products of a product
* @param IsotopeProduct
* @param array
* @param array
* @return \Model\Collection|null
*/
public static function findByProductAndCategories(IsotopeProduct $objProduct, array $arrCategories, array $arrOptions = array())
{
$t = static::$strTable;
$arrOptions = array_merge(array('column' => array("{$t}.pid=?", "{$t}.category IN (" . implode(',', $arrCategories) . ")"), 'value' => array($objProduct->getProductId()), 'order' => \Database::getInstance()->findInSet("{$t}.category", $arrCategories), 'return' => 'Collection'), $arrOptions);
return static::find($arrOptions);
}
