public function defineJoin(ARSelectFilter $filter)
{
$filter->joinTable('ProductPrice', 'Product', 'productID AND (ProductPrice.currencyID = "' . $this->application->getDefaultCurrencyCode() . '")', 'ID');
}
private static function getFilesByProductFilter(Product $product)
{
$filter = new ARSelectFilter();
$filter->joinTable('ProductFileGroup', 'ProductFile', 'ID', 'productFileGroupID');
$filter->setOrder(new ARFieldHandle("ProductFileGroup", "position"), ARSelectFilter::ORDER_ASC);
$filter->setCondition(new EqualsCond(new ARFieldHandle(__CLASS__, 'productID'), $product->getID()));
$filter->setOrder(new ARFieldHandle(__CLASS__, 'position'), ARSelectFilter::ORDER_ASC);
return $filter;
}
protected function getSelectFilter()
{
$id = $this->getRequestCategory();
$category = Category::getInstanceByID($id, Category::LOAD_DATA);
$filter = new ARSelectFilter($category->getProductCondition(true));
$filter->joinTable('ProductPrice', 'Product', 'productID AND (ProductPrice.currencyID = "' . $this->application->getDefaultCurrencyCode() . '")', 'ID');
$filter->mergeCondition(new EqualsCond(new ARFieldHandle('ProductPrice', 'type'), ProductPrice::TYPE_GENERAL_PRICE));
foreach ($this->getDisplayedColumns($category) as $column => $type) {
$parts = explode('.', $column);
if (array_shift($parts) == 'specField') {
$field = SpecField::getInstanceByID(array_shift($parts));
if (!$field->isMultiValue->get()) {
$field->defineJoin($filter);
} else {
$values = is_array($this->request->get('filters')) ? $this->request->get('filters') : json_decode($this->request->get('filters'), true);
$values = isset($values[$column]) ? $values[$column] : null;
if ($values) {
foreach (ActiveRecordModel::getRecordSet('SpecFieldValue', select(in(f('SpecFieldValue.ID'), explode(',', urldecode($values))))) as $field) {
$f = new SelectorFilter($field);
$f->defineJoin($filter);
$filter->mergeCondition($f->getCondition());
}
}
}
}
}
return $filter;
}
protected function getSelectFilter()
{
$id = $this->request->get("id");
$id = is_numeric($id) ? $id : substr($this->request->get("id"), 9);
$category = Category::getInstanceByID($id, Category::LOAD_DATA);
$filter = new ARSelectFilter($category->getProductCondition(true));
$filter->joinTable('ProductPrice', 'Product', 'productID AND (ProductPrice.currencyID = "' . $this->application->getDefaultCurrencyCode() . '")', 'ID');
return $filter;
}
protected function getSelectFilter()
{
$f = new ARSelectFilter();
// specField columns
if ($this->isEav()) {
$needsJoin = true;
$fields = EavFieldManager::getClassFieldSet($this->getClassName());
foreach ($fields as $field) {
if (!$field->isMultiValue->get()) {
if ($needsJoin) {
$f->joinTable('EavObject', $this->getClassName(), 'ID', 'eavObjectID');
$needsJoin = false;
}
$field->defineJoin($f);
}
}
}
return $f;
}
/**
* Apply selected product sort order to ARSelectFilter instance
*/
private function applySortOrder(ARSelectFilter $selectFilter, $order)
{
$dir = array_pop(explode('_', $order)) == 'asc' ? 'ASC' : 'DESC';
if (substr($order, 0, 12) == 'product_name') {
$selectFilter->setOrder(Product::getLangOrderHandle(new ARFieldHandle('Product', 'name')), $dir);
} else {
if (substr($order, 0, 5) == 'price') {
$selectFilter->setOrder(new ARFieldHandle('ProductPrice', 'price'), $dir);
$selectFilter->joinTable('ProductPrice', 'Product', 'productID AND (ProductPrice.currencyID = "' . $this->application->getDefaultCurrencyCode() . '")', 'ID');
} else {
if (substr($order, 0, 3) == 'sku') {
$selectFilter->setOrder(new ARFieldHandle('ProductPrice', 'price'), $dir);
$selectFilter->joinTable('ProductPrice', 'Product', 'productID AND (ProductPrice.currencyID = "' . $this->application->getDefaultCurrencyCode() . '")', 'ID');
} else {
if ('newest_arrivals' == $order) {
$selectFilter->setOrder(new ARFieldHandle('Product', 'dateCreated'), 'DESC');
} else {
if (in_array($order, array('rating', 'sku'))) {
$selectFilter->setOrder(new ARFieldHandle('Product', $order), $dir);
} else {
if ('sales_rank' == $order) {
Product::updateSalesRank();
$selectFilter->setOrder(new ARFieldHandle('Product', 'salesRank'), 'DESC');
} else {
if (is_numeric($fieldID = array_shift(explode('-', $order))) && !SpecField::getInstanceByID($fieldID, true)->isMultiValue->get()) {
$field = SpecField::getInstanceByID($fieldID);
$field->defineJoin($selectFilter);
$f = $field->getJoinAlias() . ($field->isSelector() ? '_value' : '') . '.value';
$selectFilter->setOrder(new ARExpressionHandle($f . ' IS NOT NULL'), 'DESC');
$selectFilter->setOrder(new ARExpressionHandle($f . ' != ""'), 'DESC');
$f = new ARExpressionHandle($f);
if ($field->isSelector()) {
$f = MultiLingualObject::getLangOrderHandle($f);
}
$selectFilter->setOrder($f, array_pop(explode('_', $order)) == 'desc' ? 'DESC' : 'ASC');
} else {
$selectFilter->setOrder(new ARFieldHandle('Product', 'isFeatured'), 'DESC');
$selectFilter->setOrder(new ARFieldHandle('Product', 'salesRank'), 'DESC');
$selectFilter->setOrder(new ARFieldHandle('Product', 'position'), 'DESC');
}
}
}
}
}
}
}
}
private static function getRelatedProductsSetFilter(Product $product, $type)
{
$filter = new ARSelectFilter();
$filter->joinTable('ProductRelationshipGroup', 'ProductRelationship', 'ID', 'productRelationshipGroupID');
$filter->setOrder(new ARFieldHandle("ProductRelationshipGroup", "position"), 'ASC');
$filter->setOrder(new ARFieldHandle(__CLASS__, "position"), 'ASC');
$filter->setCondition(new EqualsCond(new ARFieldHandle(__CLASS__, "productID"), $product->getID()));
$filter->mergeCOndition(new EqualsCond(new ARFieldHandle(__CLASS__, "type"), $type));
return $filter;
}
/**
* Adds JOIN definition to ARSelectFilter to retrieve product attribute value for the particular SpecField
*
* @param ARSelectFilter $filter Filter instance
*/
public function defineJoin(ARSelectFilter $filter)
{
$table = $this->getJoinAlias();
$filter->joinTable($this->getValueTableName(), $this->getOwnerClass(), $this->getObjectIDColumnName() . ' AND ' . $table . '.' . $this->getFieldIDColumnName() . ' = ' . $this->getID(), 'ID', $table);
if ($this->isSelector() && !$this->isMultiValue->get()) {
$itemClass = $this->getSelectValueClass();
$valueClass = call_user_func(array($itemClass, 'getValueClass'));
$valueField = call_user_func(array($itemClass, 'getValueIDColumnName'));
$filter->joinTable($valueClass, $table, 'ID', $valueField, $table . '_value');
}
}
/**
* Adds JOIN definition to ARSelectFilter to retrieve product attribute value for the particular SpecField
*
* @param ARSelectFilter $filter Filter instance
*/
public function defineJoin(ARSelectFilter $filter)
{
$table = $this->getJoinAlias();
$filter->joinTable('SpecificationItem', 'Product', 'productID AND ' . $table . '.SpecFieldValueID = ' . $this->specFieldValue->getID(), 'ID', $table);
}
