Последние сообщения блогов

class CIBlockElementMulti
{
    /**
     * Функция для получения товаров из нескольких инфоблоков с получением и сортировкой свойств
     * Функциональность ограничена, в частных случаях возможно потребует доработки
     *
     * @param array $arOrder
     * @param array $arFilter
     * @param bool|array $arGroupBy
     * @param bool|array $arNavStartParams
     * @param array $arSelectFields
     *
     * @return integer|CIBlockResult
     */
    public function GetList(
      $arOrder = ["SORT" => "ASC"],
      $arFilter = [],
      $arGroupBy = false,
      $arNavStartParams = false,
      $arSelectFields = []
    ) {
        global $DB;
        $sWhere = "";

        if (!is_array($arFilter["IBLOCK_ID"])) {
            return false;
        }

        $sSql = "     
        SEL ECT
        BE.ID                                                                     AS ID,
        BE.IBLOCK_ID                                                              AS IBLOCK_ID,
        B.CODE                                                                    AS IBLOCK_CODE,
        BE.IBLOCK_SECTION_ID                                                      AS IBLOCK_SECTION_ID,
        ";

        $sPropSql = "";
        
        foreach ($arSelectFields as $arField) {
            if (strpos($arField, "PROPERTY_") === false) {
                continue;
            }
            $arProps = [];
            foreach ($arFilter["IBLOCK_ID"] as $iIblockId) {
                $dbRes = \CIBlockProperty::GetList(false, [
                  "ACTIVE" => "Y",
                  "IBLOCK_ID" => $iIblockId,
                  "CODE" => str_replace("PROPERTY_", "", $arField),
                ]);
                if ($arProp = $dbRes->GetNext()) {
                    $arProps[] = "FPS".$iIblockId.".PROPERTY_".$arProp["ID"];
                }
            }
            if (!$arProps) {
                $arProps [] ="''";
            }
            $sPropSql .= "        coalesce(".join(",", $arProps).") AS ".$arField."_VALUE, \r\n";
        }        

        $sSql .= $sPropSql;

        foreach ($arFilter as $sKey => $arValue) {
            if (strpos($sKey, ">CATALOG_PRICE") !== false) {
                $iPriceId = explode("CATALOG_PRICE_", $sKey)[1];
                $sWhere .= " AND ((((CAT_P".$iPriceId.".PRICE > '".$arValue."'))))";
            }elseif (is_numeric($sKey) and is_array($arValue)) {
                if (isset($arValue["LOGIC"])) {
                    $sLogic = $arValue["LOGIC"];
                    unset($arValue["LOGIC"]);
                    $arTmp = [];
                    foreach ($arValue as $arVal2) {
                        $sKey2 = key($arVal2);
                        $arVal2 = reset($arVal2);
                        if (strpos($sKey2, "CATALOG_PRICE") !== false) {
                            $iPriceId = explode("CATALOG_PRICE_", $sKey2)[1];
                            $arTmp[] = "((((CAT_P".$iPriceId.".PRICE BETWEEN '".$arVal2[0]."' AND '".$arVal2[1]."'))))";
                        }
                    }
                    if ($arTmp) {
                        $sWhere .= " AND (".join(" ".$sLogic." ", $arTmp).") ";
                    }
                }
            } elseif ($sKey == "IBLOCK_ID" || $sKey == "ID") {
                if (is_array($arValue)) {
                    $iIds = join("','", $arValue);
                } else {
                    $iIds = $arValue;
                }
                $sWhere.=" AND BE.".$sKey." IN ('".$iIds."')";
            } elseif ($sKey == "ACTIVE") {
                $sWhere .= "  AND BE.ACTIVE = '".$arFilter["ACTIVE"]."'";
            }
        }

        if ($iPriceId) {
        $sSql .= "
        CAT_P".$iPriceId.".ID                                                     AS CATALOG_PRICE_ID_".$iPriceId.",
        CAT_P".$iPriceId.".CATALOG_GROUP_ID                                       AS CATALOG_GROUP_ID_".$iPriceId.",
        CAT_P".$iPriceId.".PRICE                                                  AS CATALOG_PRICE_".$iPriceId.",
        CAT_P".$iPriceId.".CURRENCY                                               AS CATALOG_CURRENCY_".$iPriceId.",
        CAT_P".$iPriceId.".QUANTITY_FROM                                          AS CATALOG_QUANTITY_FROM_".$iPriceId.",
        CAT_P".$iPriceId.".QUANTITY_TO                                            AS CATALOG_QUANTITY_TO_".$iPriceId.",
        'Y'                                                                       AS CATALOG_CAN_ACCESS_".$iPriceId.",
        'Y'                                                                       AS CATALOG_CAN_BUY_".$iPriceId.",
        CAT_P".$iPriceId.".EXTRA_ID                                               AS CATALOG_EXTRA_ID_".$iPriceId.", \r\n";
        }

        $sSql .= " 
        CAT_PR.QUANTITY                                                           AS CATALOG_QUANTITY,
        CAT_PR.QUANTITY_RESERVED                                                  AS CATALOG_QUANTITY_RESERVED,
        IF (CAT_PR.QUANTITY_TRACE = 'D', 'N', CAT_PR.QUANTITY_TRACE)              AS CATALOG_QUANTITY_TRACE,
        CAT_PR.QUANTITY_TRACE                                                     AS CATALOG_QUANTITY_TRACE_ORIG,
        IF (CAT_PR.CAN_BUY_ZERO = 'D', 'Y', CAT_PR.CAN_BUY_ZERO)                  AS CATALOG_CAN_BUY_ZERO,
        CAT_PR.CAN_BUY_ZERO                                                       AS CATALOG_CAN_BUY_ZERO_ORIG,
        IF (CAT_PR.NEGATIVE_AMOUNT_TRACE = 'D', 'Y', CAT_PR.NEGATIVE_AMOUNT_TRACE) AS CATALOG_NEGATIVE_AMOUNT_TRACE,
        CAT_PR.NEGATIVE_AMOUNT_TRACE                                              AS CATALOG_NEGATIVE_AMOUNT_ORIG,
        IF (CAT_PR.SUBSCRIBE = 'D', 'Y', CAT_PR.SUBSCRIBE)                        AS CATALOG_SUBSCRIBE,
        CAT_PR.SUBSCRIBE                                                          AS CATALOG_SUBSCRIBE_ORIG,
        CAT_PR.AVAILABLE                                                          AS CATALOG_AVAILABLE,
        CAT_PR.WEIGHT                                                             AS CATALOG_WEIGHT,
        CAT_PR.WIDTH                                                              AS CATALOG_WIDTH,
        CAT_PR.LENGTH                                                             AS CATALOG_LENGTH,
        CAT_PR.HEIGHT                                                             AS CATALOG_HEIGHT,
        CAT_PR.MEASURE                                                            AS CATALOG_MEASURE,
        CAT_VAT.RATE                                                              AS CATALOG_VAT,
        CAT_PR.VAT_ID                                                             AS CATALOG_VAT_ID,
        CAT_PR.VAT_INCLUDED                                                       AS CATALOG_VAT_INCLUDED,
        CAT_PR.PRICE_TYPE                                                         AS CATALOG_PRICE_TYPE,
        CAT_PR.RECUR_SCHEME_TYPE                                                  AS CATALOG_RECUR_SCHEME_TYPE,
        CAT_PR.RECUR_SCHEME_LENGTH                                                AS CATALOG_RECUR_SCHEME_LENGTH,
        CAT_PR.TRIAL_PRICE_ID                                                     AS CATALOG_TRIAL_PRICE_ID,
        CAT_PR.WITHOUT_ORDER                                                      AS CATALOG_WITHOUT_ORDER,
        CAT_PR.SELECT_BEST_PRICE                                                  AS CATALOG_SELECT_BEST_PRICE,
        CAT_PR.PURCHASING_PRICE                                                   AS CATALOG_PURCHASING_PRICE,
        CAT_PR.PURCHASING_CURRENCY                                                AS CATALOG_PURCHASING_CURRENCY,
        CAT_PR.TYPE                                                               AS CATALOG_TYPE,
        CAT_PR.BUNDLE                                                             AS CATALOG_BUNDLE
        FR OM
        b_iblock B
        INNER JOIN b_lang L ON B.LID = L.LID
        INNER JOIN b_iblock_element BE ON BE.IBLOCK_ID = B.ID
";

        foreach ($arFilter["IBLOCK_ID"] as $iIblockId) {
            $sSql .= "
        LEFT JOIN b_iblock_element_prop_s".$iIblockId." FPS".$iIblockId." ON FPS".$iIblockId.".IBLOCK_ELEMENT_ID = BE.ID \r\n";
        }

        if ($iPriceId) {
            $sSql .= "
        LEFT JOIN b_catalog_price CAT_P".$iPriceId." ON(CAT_P".$iPriceId.".PRODUCT_ID = BE.ID AND CAT_P".$iPriceId.".CATALOG_GROUP_ID = ".$iPriceId.") \r\n";
        }

        $sSql .= "
        LEFT JOIN b_catalog_product CAT_PR ON(CAT_PR.ID = BE.ID)
        LEFT JOIN b_catalog_iblock CAT_IB
        ON((CAT_PR.VAT_ID IS null OR CAT_PR.VAT_ID = 0) AND CAT_IB.IBLOCK_ID = BE.IBLOCK_ID)
        LEFT JOIN b_catalog_vat CAT_VAT
        ON(CAT_VAT.ID = IF ((CAT_PR.VAT_ID IS null OR CAT_PR.VAT_ID = 0), CAT_IB.VAT_ID, CAT_PR.VAT_ID))
        WHERE 1 = 1
        ".$sWhere."\r\n";


        if (!$arFilter["IBLOCK_ID_FULL_LIST"] and is_array($arFilter["IBLOCK_ID"]) and sizeof($arFilter["IBLOCK_ID"])>1)
            $sPreOrder = "IBLOCK_ID asc, ";

        if (strpos(key($arOrder), "PROPERTY_") !== false) {
            $sOrderBy = "ORDER BY ".$sPreOrder.key($arOrder)."_VALUE ".reset($arOrder);
        } elseif (stristr(key($arOrder),"CATALOG")) {
        $sOrderBy = "ORDER BY ".$sPreOrder.key($arOrder)." ".reset($arOrder);
        } else {
            $sOrderBy = "ORDER BY ".$sPreOrder."BE.".key($arOrder)." ".reset($arOrder);
        }

        if ($sOrderBy) {
            $sOrderBy .= ", ID DESC";
        }

        $sSql .= "
        AND (((BE.WF_STATUS_ID = 1 AND BE.WF_PARENT_ELEMENT_ID IS null)))
        ".$sOrderBy;

        $obResCnt = $DB->Query($sSql, false, __LINE__);
        $iCnt = $obResCnt->SelectedRowsCount();

        $obRes = new \CDBResult();
        $obRes->NavQuery($sSql, $iCnt, $arNavStartParams);

        $obRes = new \CIBlockResult($obRes);

        return $obRes;
    }
}

$res = \Bitrix\Iblock\ElementTable::getList(array(
    "select" => array("ID", "NAME"),
    "filter" => array("IBLOCK_ID" => 25, "ID" => 4584),
    "order"  => array("ID" => "ASC")
));
while ($arItem = $res->fetch()) {
    $dbProperty = \CIBlockElement::getProperty(
        $arItem['IBLOCK_ID'], 
        $arItem['ID'], array("sort", "asc"), 
        array()
    );
    while ($arProperty = $dbProperty->GetNext()) {

        $arItem["PROPERTIES"][$arProperty['CODE']] = $arProperty;

    }
  echo "<pre>".print_r($arItem, true)."</pre>";
}

$res = \Bitrix\Iblock\ElementTable::getList(array(
    "select" => array("ID", "*"),
    "filter" => array("IBLOCK_ID" => 25, "ID" => 4584),
    "order"  => array("ID" => "ASC")
));
while ($arItem = $res->fetch()) {
    $propRes = \Bitrix\Iblock\ElementPropertyTable::getList(array(
        "select" => array("ID", "*"),
        "filter" => array("IBLOCK_ELEMENT_ID" => $arItem["ID"],),
        "order"  => array("ID" => "ASC")
    ));
    while($prop = $propRes->Fetch())
    {
        $arItem["PROPERTIES"][$prop["IBLOCK_PROPERTY_ID"]] = $prop;
    }
     echo "<pre>".print_r($arItem, true)."</pre>";
}

[888] => Array
(
[ID] => 28357
[IBLOCK_PROPERTY_ID] => 482
[IBLOCK_ELEMENT_ID] => 4584
[VALUE] => 5485
[VALUE_TYPE] => text
[VALUE_ENUM] => 
[VALUE_NUM] => 5485.0000
[DESCRIPTION] => 
)

../www/                  | s1 (основной сайт)
../www/en/               | s2
../www/ua/               | s3
../ext_www/site1/         | a1 (филиалы)
../ext_www/site1/en/      | a2
../ext_www/site1/ua/      | a3
../ext_www/site2/         | b1
../ext_www/site2/en/      | b2
../ext_www/site3/ua/      | b3
../src/
../composer.json
.......

<?php

namespace MySpace\Helper;

use Bitrix\Main\Context;
use Bitrix\Main\SiteTable;

/**
 * Class Site
 * @package MySpace\Helper
 */
class Site
{
    /**
     * @var
     */
    private $sDocRoot;

    /**
     * Site constructor.
     */
    public function __construct()
    {
        $objServer = Context::getCurrent()->getServer();
        $this->sDocRoot = $objServer->getDocumentRoot();
    }

    /**
     * @return string
     */
    public function getSiteID()
    {
        if (defined("SITE_ID")) {
            switch (SITE_ID) {
                case "en" :
                case "ru" :
                case "ua" :
                    return $this->getSiteIDByLang(SITE_ID);
                    break;
                default :
                    return SITE_ID;
            }
        }

        return "";
    }

    /**
     * @param $sSiteLang
     * @return string
     */
    private function getSiteIDByLang($sSiteLang)
    {
        $rsSites = SiteTable::getList(
            array(
                "filter" => array(
                    "=DOC_ROOT" => $this->sDocRoot . "/",
                    "=LANGUAGE_ID" => $sSiteLang
                )
            )
        );

        if ($arSite = $rsSites->fetch()) {
            return $arSite["LID"];
        }

        return "";
    }
}

...

    /**
     * init define constants for iblocks
     */
    private static function initIBlockConstants()
    {
        $rsIBlock = \CIBlock::GetList(
            array(),
            array(
                "=LID" => (new Site())->getSiteID(),
                "CHECK_PERMISSIONS" => "N"
            )
        );

        while ($arIBlock = $rsIBlock->Fetch()) {
            switch ($arIBlock["IBLOCK_TYPE_ID"]) {
...
                case "news":
                    self::define("IBLOCK_ID_NEWS", $arIBlock["ID"]);
                    break;
                case "smi":
                    self::define("IBLOCK_ID_MONITORING_SMI", $arIBlock["ID"]);
                    break;
                case "gallery":
                    self::define("IBLOCK_ID_GALLERY", $arIBlock["ID"]);
                    break;
                case "materials_main":
                    self::define("IBLOCK_ID_MATERIARLS_MAIN", $arIBlock["ID"]);
                    break;
...
            }
        }
    }

...

use Symfony\Component\Console\Output\ConsoleOutput;

$consoleOutput = new ConsoleOutput();

$consoleOutput->write('Сообщение без перехода на новую строку');
$consoleOutput->writeln('Сообщение c переходом на новую строку');

$consoleOutput->write('<info>Сообщение зеленого цвета</info>');
$consoleOutput->write('<error>Сообщение на красном фоне</error>');

use Symfony\Component\Console\Output\ConsoleOutput;
use Symfony\Component\Console\Formatter\OutputFormatterStyle;
....
$consoleOutput = new ConsoleOutput();
$outputStyle = new OutputFormatterStyle('blue', 'red'); //Синим по красному
$consoleOutput->getFormatter()->setStyle('blue-on-red', $outputStyle);
....
$consoleOutput->write('<blue-on-red>Синим по красному</blue-on-red>');

$logSection = $consoleOutput->section();
$statisticSection = $consoleOutput->section();

$iteratoration = 0;
while(true){
   $logSection->writeln('Итерация ' . $iteratoration);
   if ($iteratoration % 1000 === 0) {
      // Последняя строка в консоле будет обновляться
      $statisticSection->overwrite(($iteratoration / 1000)  . ' тысяч итераций');
   }
   $iterator++;
}

<?php
$eventManager = \Bitrix\Main\EventManager::getInstance();
$eventManager->addEventHandler("catalog", "OnGetOptimalPrice", ["amountForPrice", "onGetPriceEvent"]);

global $basketPrice;
$basketPrice = [];

class amountForPrice
{
    /**
     * [BASE ID: 1] при сумме заказа до 15 000 рублей
     * [SALE_SMAL ID: 2] Мелкий опт от 15.000 руб.
     * [SALE_MIDDLE ID: 4] Средний опт от 50.000 руб.
     * [SALE_LARGE ID: 5] Крупный опт от 100.000 руб.
     */
    // Проставляем ID типов цен
    protected static $baseGroup = 1;
    protected static $smallGroup = 2;
    protected static $middleGroup = 4;
    protected static $largeGroup = 5;

    public function onGetPriceEvent($productID, $quantity = 1, $arUserGroups = [], $renewal = "N", $arPrices = array(), $siteID = false, $arDiscountCoupons = false)
    {
        // Через global, чтоб не вызывалось по несколько раз 
        // OnGetOptimalPrice вызывается для каждого товара
        global $basketPrice;
        if (empty($basketPrice)) {
            $basketPrice = self::getBasketUser();
        } 

        // Получаем доступные цены для товара
        $resOptPrices = \Bitrix\Catalog\PriceTable::getList([
            'filter' => ['=PRODUCT_ID' => $productID],
            'select' => ['CATALOG_GROUP_ID', 'PRICE', 'CURRENCY'],
        ]);
        while($optPrice = $resOptPrices->fetch()){
            $arOptPrices[$optPrice['CATALOG_GROUP_ID']] = $optPrice;
        }

        $arPrice = self::getPrice($basketPrice, $arOptPrices);
        $result = [
            'PRICE' => [
                "ID" => $productID,
                'CATALOG_GROUP_ID' => $arPrice['group'],
                'PRICE' => $arPrice['price'],
                'CURRENCY' => $arPrice['currency'],
                'ELEMENT_IBLOCK_ID' => $productID,
                'VAT_INCLUDED' => "Y",
            ],
            'DISCOUNT' => ['VALUE' => $discount, 'CURRENCY' => $arPrice['currency']],
        ];
        
        return $result;
    }

    /**
     * Функция смотрит цену корзины и выбирает подходящую цену
     * Функции цен уже сам перебразывают цену в зависимости от доступности
     */
    public function getPrice(array $sum, array $arPrices)
    {
        if ($sum[4] >= 100000) {
            $result = self::priceLarge($arPrices);
        } elseif ($sum[2] >= 50000) {
            $result = self::priceMiddle($arPrices);
        } elseif ($sum[1] >= 15000) {
            $result = self::priceSmall($arPrices);
        } else {
            $result = self::priceBase($arPrices);
        }
        return $result;
    }

    public function priceLarge(array $arPrices)
    {
        if (empty($arPrices[self::$largeGroup])) {
            $result = self::priceMiddle($arPrices);
        } else {
            $result = [
                'group' => self::$largeGroup,
                'price' => $arPrices[self::$largeGroup]['PRICE'],
                'currency' => $arPrices[self::$largeGroup]['CURRENCY']
            ];
        }
        return $result;
    }
    public function priceMiddle(array $arPrices)
    {
        if (empty($arPrices[self::$middleGroup])) {
            $result = self::priceSmall($arPrices);
        } else {
            $result = [
                'group' => self::$middleGroup,
                'price' => $arPrices[self::$middleGroup]['PRICE'],
                'currency' => $arPrices[self::$middleGroup]['CURRENCY']
            ];
        }
        return $result;
    }
    public function priceSmall(array $arPrices)
    {
        if (empty($arPrices[self::$smallGroup])) {
            $result = self::priceBase($arPrices);
        } else {
            $result = [
                'group' => self::$smallGroup,
                'price' => $arPrices[self::$smallGroup]['PRICE'],
                'currency' => $arPrices[self::$smallGroup]['CURRENCY']
            ];
        }
        return $result;
    }

    public function priceBase(array $arPrices)
    {
        $result = [
            'group' => 1,
            'price' => $arPrices[self::$baseGroup]['PRICE'],
            'currency' => $arPrices[self::$baseGroup]['CURRENCY']
        ];
        return $result;
    }

    /**
    * Получение суммы корзины текущего пользователя 
    * Получаем суммы всех типов цен
    */
    public function getBasketUser()
    {
        $resultPrice = [];
        $resultPrice[self::$baseGroup]    = 0;
        $resultPrice[self::$smallGroup]   = 0;
        $resultPrice[self::$middleGroup]  = 0;
        //$resultPrice[self::$largeGroup]   = 0;  // large мы не считаем т.к он уже не учавствует в выборке

        $obBasket = \Bitrix\Sale\Basket::getList([
            'filter' => [
                'FUSER_ID' => \Bitrix\Sale\Fuser::getId(),
                'LID' => SITE_ID,
                'ORDER_ID' => NULL // Т.к корзина связана с заказами, то нам нужна корзина у которой нет заказа
            ],
            'select' => ['QUANTITY', 'PRODUCT_ID', 'CAN_BUY', 'DELAY']
        ]);
        while($arItem = $obBasket->Fetch()){
            // Нам нужны только доступные товары остальные не считаем
            if ($arItem['DELAY'] == 'N' && $arItem['CAN_BUY'] == 'Y') {
                $resPrices = \Bitrix\Catalog\PriceTable::getList([
                    'filter' => ['=PRODUCT_ID' => $arItem['PRODUCT_ID']],
                    'select' => ['CATALOG_GROUP_ID', 'PRICE'],
                ]);
                while ($price = $resPrices->fetch()) {
                    $arItem['PRICES'][$price['CATALOG_GROUP_ID']] = $price['PRICE'];
                }
                // Если вдруг нет у товара цены, то берем следующую т.к нам нужна именно сумма
                $resultPrice[self::$middleGroup] += (($arItem['PRICES'][self::$middleGroup] ?? $arItem['PRICES'][self::$smallGroup] ?? $arItem['PRICES'][self::$baseGroup]) * $arItem['QUANTITY']);
                $resultPrice[self::$smallGroup]  += (($arItem['PRICES'][self::$smallGroup] ?? $arItem['PRICES'][self::$baseGroup]) * $arItem['QUANTITY']);
                $resultPrice[self::$baseGroup]   += ($arItem['PRICES'][self::$baseGroup] * $arItem['QUANTITY']);
            }         
        }
        return $resultPrice;
    }
}

//Класс установки модуля
class mycompany_component1 extends CModule{
    //Пространство имён компонентов
    public $MODULE_COMPONENTS_NAMESPACE = "mycompany";
    //Компоненты модуля
    public $arModuleComponents = ["component1"];
    
    ...
    

    function UnInstallFiles()
    {
        ...
        //Удаление компонентов модуля из /local
        foreach ($this->arModuleComponents as $componentName) {
            if (strlen($componentName) > 0) {
                $resDel=DeleteDirFilesEx("/local/components/" . $this->MODULE_COMPONENTS_NAMESPACE . '/' . $componentName . '/');
            }
        }
        //TODO: удалять папку с компонентами, если она оказывается пустая
        return true;
    }
}

echo strtoupper("абвгд");

setlocale(LC_ALL, 'ru_RU.CP1251');
setlocale(LC_NUMERIC,'C');

locale -a | grep ru_RU

localedef -c -i ru_RU -f CP1251 ru_RU.CP1251

locale -a | grep ru_RU

service httpd restart