ИНТЕРНЕТ-МАГАЗИН / Товары со скидками

<?php

$aLibParams = Core_Page::instance()->libParams;

$sXslItemName  = Core_Array::get($aLibParams, 'xsl');

$ShopControllerShow = Core_Page::instance()->object;

$ShopControllerShow
    ->itemsProperties(FALSE)
    ->itemsPropertiesList(FALSE)
    ->group(FALSE)
    ->xsl($sXslItemName)
    ->tags(FALSE)
    ->viewed(FALSE)
    ->show();

<?php

$aLibParams = Core_Page::instance()->libParams;

$iShopId  = Core_Array::get($aLibParams, 'shop-id');

$ShopControllerShow = new Shop_Controller_Show(
    Core_Entity::factory('Shop', $iShopId)
);

$sPattern = rawurldecode(Core_Str::rtrimUri($ShopControllerShow->getEntity()->Structure->getPath())) . '/sale/' . '(page-{page}/)';

$aPatternExpressions = array(
    'page' => '\d+',
);
$Core_Router_Route = new Core_Router_Route($sPattern, $aPatternExpressions);
$matches = $Core_Router_Route->applyPattern(Core::$url['path']);

$page = 0;
if (isset($matches['page']) && is_numeric($matches['page']))
{
    if ($matches['page'] > 1)
    {
        $page = $matches['page'] - 1;
    }
}

$ShopControllerShow->addEntity(
    Core::factory('Core_Xml_Entity')->name('current_sale_page')->value($page)
);

$ShopControllerShow->limit($ShopControllerShow->getEntity()->items_on_page);
$ShopControllerShow->limit(9999);

$ShopControllerShow
    ->shopItems()
    ->queryBuilder()
    ->join('shop_item_discounts', 'shop_item_discounts.shop_item_id', '=', 'shop_items.id')
    ->join('shop_discounts', 'shop_discounts.id', '=', 'shop_item_discounts.shop_discount_id')
    ->where('shop_discounts.active', '=', 1)
    ->where('shop_discounts.start_datetime', '<', Core_Date::timestamp2sql(time()))
    ->where('shop_discounts.end_datetime', '>', Core_Date::timestamp2sql(time()))
    ->where('shop_discounts.deleted', '=', 0)
    ->where('shop_items.modification_id', '=', 0)
    ->groupBy('shop_items.id')
    ->clearOrderBy()
    ->orderBy('RAND()')
 //   ->where('shortcut_id', '=', 0) проверить

    ;

$ShopControllerShow
    ->group(FALSE)
    ->groupsMode('none')
    ->favorite(FALSE);

Core_Page::instance()->object = $ShopControllerShow;