/** * 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 variant of a product * @param IsotopeProduct * @param array * @param array */ public static function findVariantOfProduct(IsotopeProduct $objProduct, array $arrVariant, array $arrOptions = array()) { $t = static::$strTable; $arrColumns = array("{$t}.id IN (" . implode(',', $objProduct->getVariantIds()) . ")", "{$t}." . implode("=? AND {$t}.", array_keys($arrVariant)) . "=?"); $arrOptions = array_merge(array('limit' => 1, 'column' => $arrColumns, 'value' => $arrVariant, 'return' => 'Model'), $arrOptions); return static::find($arrOptions); }