Виталий Юров (Все сообщения пользователя)

$this->setFrameMode(true);

<div class="catalog-bottom" id="<?= $arItemIDs['CATALOG_BOTTOM_COMPOSITE'] ?>">
   <?php
   $frame = $this->createFrame($arItemIDs['CATALOG_BOTTOM_COMPOSITE'], false)->begin();
   $isItemInCartClass = Basket::isItemInCartClass($arItem['ID']);
   ?>
   <div class="catalog-bottom__right" id="<?= $arItemIDs['BASKET_ACTIONS'] ?>">
      <?php if ($arItem['CAN_BUY'] || $availableOnRequest) : ?>
         <button class="catalog-bottom__button button btn-action buy when-in-stock btn-action-add <?php if($isItemInCartClass) { ?>active<?php } ?>" id="" data-product-id="<?= $arItem['ID'] ?>">
         <?php if ($isItemInCartClass) { ?>
            <div class="catalog__cart-ico"></div>
         <?php } else { ?>
            <?= COption::GetOptionString($moduleId, 'button_text_buy') ?>
         <?php } ?>
         </button>
         <?php else : ?>
         <button class="catalog-bottom__button button button_white" data-fancybox data-product="<?= $availableItemID ?>" data-src="#popup-notify">
            <?= GetMessage('NOTIFY') ?>
         </button>
      <?php endif ?>
   </div>
<?php $frame->end();?>

\Bitrix\Main\Loader::includeModule('iblock');
\Bitrix\Main\Loader::includeModule('Highloadblock');

$elementId = 1617059;
$hlBlock = 3;

$property = \Bitrix\Iblock\Elements\ElementCatalogTable::getList([
    'select' => ['VSTROENNAYA_PAMYAT.ITEM', 'OPERATIVNAYA_PAMYAT.ITEM', 'TSVET', 'RECOMMEND.ELEMENT'],
    'filter' => [
        'ID' => $elementId,
    ],
])->fetchObject();

// св-ва тип список
$ownMemory = $property->getVstroennayaPamyat()->getItem()->getValue();
$ramMemory = $property->getOperativnayaPamyat()->getItem()->getValue();

echo "<pre>"; print_r($ownMemory); echo "</pre>";
echo "<pre>"; print_r($ramMemory); echo "</pre>";

// св-во тип справочник
$colorXmlId = $property->getTsvet()->getValue();

if($colorXmlId)
{
    $hldata =  \Bitrix\Highloadblock\HighloadBlockTable::getById($hlBlock)->fetch();
    $hlentity = \Bitrix\Highloadblock\HighloadBlockTable::compileEntity($hldata);
    $hlDataClass = $hldata['NAME'].'Table';

    $arColor = $hlDataClass::getList([
        'select' => [
            'UF_XML_ID',
            'UF_NAME',
            'UF_FILE'
        ],
        'filter' => ['UF_XML_ID' => $colorXmlId]
    ])->Fetch();
}

echo "<pre>"; print_r($arColor); echo "</pre>";

// св-во тип привязка к элементу
foreach($property->getRecommend()->getAll() as $linkElement)
{
    $recommendElementId = $linkElement->getElement()->getId();
    $recommendElementName = $linkElement->getElement()->getName();
    echo "<pre>"; print_r($recommendElementId); echo "</pre>";
    echo "<pre>"; print_r($recommendElementName); echo "</pre>";
}

$elements = \Bitrix\Iblock\Elements\ElementCatalogTable::getByPrimary($elementId, [    'select' => ['ID', 'NAME', 'OPERATIVNAYA_PAMYAT'],
])->fetchAll();

foreach ($elements as $element) {
    echo "<pre>"; print_r($element); echo "</pre>";
}

Array
(
    [ID] => 1617059
    [NAME] => Xiaomi Redmi Note 9 Pro 6/128Gb Зеленый Global Version
    [IBLOCK_ELEMENTS_ELEMENT_CATALOG_OPERATIVNAYA_PAMYAT_ID] => 695186674
    [IBLOCK_ELEMENTS_ELEMENT_CATALOG_OPERATIVNAYA_PAMYAT_IBLOCK_ELEMENT_ID] => 1617059
    [IBLOCK_ELEMENTS_ELEMENT_CATALOG_OPERATIVNAYA_PAMYAT_IBLOCK_PROPERTY_ID] => 316
    [IBLOCK_ELEMENTS_ELEMENT_CATALOG_OPERATIVNAYA_PAMYAT_VALUE] => 727
    [IBLOCK_ELEMENTS_ELEMENT_CATALOG_OPERATIVNAYA_PAMYAT_IBLOCK_GENERIC_VALUE] => 727
)

$arFilter = [
    'IBLOCK_ID'=> $iblockId,
    'ID' => $elementId,
];

$arSelect = [
    'ID',
    'PROPERTY_TSVET',
    'PROPERTY_VSTROENNAYA_PAMYAT',
    'PROPERTY_OPERATIVNAYA_PAMYAT'
];

$arElement = CIBlockElement::GetList($arOrder, $arFilter, false, false, $arSelect)->Fetch();

$item = \Bitrix\Iblock\Elements\ElementCatalogTable::query()
    ->setSelect( [
        'OPERATIVNAYA_PAMYAT',
        'VSTROENNAYA_PAMYAT'
    ] )
    ->where( 'ID', $elementId)
    ->fetchAll();

echo "<pre>"; print_r($item); echo "</pre>";

Array
(
    [0] => Array
        (
            [IBLOCK_ELEMENTS_ELEMENT_CATALOG_OPERATIVNAYA_PAMYAT_ID] => 695186674
            [IBLOCK_ELEMENTS_ELEMENT_CATALOG_OPERATIVNAYA_PAMYAT_IBLOCK_ELEMENT_ID] => 1617059
            [IBLOCK_ELEMENTS_ELEMENT_CATALOG_OPERATIVNAYA_PAMYAT_IBLOCK_PROPERTY_ID] => 316
            [IBLOCK_ELEMENTS_ELEMENT_CATALOG_OPERATIVNAYA_PAMYAT_VALUE] => 727
            [IBLOCK_ELEMENTS_ELEMENT_CATALOG_OPERATIVNAYA_PAMYAT_IBLOCK_GENERIC_VALUE] => 727
            [IBLOCK_ELEMENTS_ELEMENT_CATALOG_VSTROENNAYA_PAMYAT_ID] => 695186686
            [IBLOCK_ELEMENTS_ELEMENT_CATALOG_VSTROENNAYA_PAMYAT_IBLOCK_ELEMENT_ID] => 1617059
            [IBLOCK_ELEMENTS_ELEMENT_CATALOG_VSTROENNAYA_PAMYAT_IBLOCK_PROPERTY_ID] => 328
            [IBLOCK_ELEMENTS_ELEMENT_CATALOG_VSTROENNAYA_PAMYAT_VALUE] => 687
            [IBLOCK_ELEMENTS_ELEMENT_CATALOG_VSTROENNAYA_PAMYAT_IBLOCK_GENERIC_VALUE] => 687
            [UALIAS_0] => 1617059
        )

)

$q = new \Bitrix\Main\Entity\Query(Bitrix\Iblock\PropertyValueTable::getEntity());

$q->setSelect([
    'PROPERTY_VALUE' => 'PE.VALUE',
    'PROPERTY_CODE' => 'PB.CODE'
]);

$q->setFilter([
    '=IBLOCK_ELEMENT_ID' => $elementId,
    [
        'LOGIC' => 'OR',
        ['PB.CODE'=> 'OPERATIVNAYA_PAMYAT'],
        ['PB.CODE'=> 'VSTROENNAYA_PAMYAT'],
    ]
]);

$q->registerRuntimeField('PE', [
    "data_type"   => '\Bitrix\Iblock\PropertyEnumerationTable',
    'reference'    => [
        '=this.IBLOCK_PROPERTY_ID' => 'ref.PROPERTY_ID',
        '=this.VALUE' => 'ref.ID'
    ],
]);

$q->registerRuntimeField('PB', [
    "data_type"   => '\Bitrix\Iblock\PropertyTable',
    'reference'    => [
        '=this.IBLOCK_PROPERTY_ID' => 'ref.ID',
    ],
]);

$querySql = $q->getQuery();
$result = $q->exec()->fetchAll();


echo "<pre>"; print_r($querySql); echo "</pre>";
echo "<pre>"; print_r($result); echo "</pre>";

$elementId = 1617059;

$arResult = \Bitrix\Iblock\PropertyValueTable::getList([
    'select' => [
        'PROPERTY_VALUE' => 'PE.VALUE',
        'PROPERTY_CODE' => 'PB.CODE'
    ],
    'filter' => [
        '=IBLOCK_ELEMENT_ID' => 1617059,
        //'PB.CODE' => 'OPERATIVNAYA_PAMYAT'
        [
            "LOGIC"=>"OR",
            ['PB.CODE'=> 'OPERATIVNAYA_PAMYAT'],
            ['PB.CODE'=> 'VSTROENNAYA_PAMYAT'],
        ]
    ],
    'runtime' => [
        'PE' => [
            'data_type' => '\Bitrix\Iblock\PropertyEnumerationTable',
            'reference' => [
                '=this.IBLOCK_PROPERTY_ID' => 'ref.PROPERTY_ID',
                '=this.VALUE' => 'ref.ID'
            ],
            'join_type' => 'inner'
        ],
        'PB' => [
            'data_type' => '\Bitrix\Iblock\PropertyTable',
            'reference' => [
                '=this.IBLOCK_PROPERTY_ID' => 'ref.ID',
            ],
            'join_type' => 'inner'
        ],
        /*
        new \Bitrix\Main\Entity\ReferenceField(
            'PE',
            '\Bitrix\Iblock\PropertyEnumerationTable',
            array(
                '=this.IBLOCK_PROPERTY_ID' => 'ref.PROPERTY_ID',
                '=this.VALUE' => 'ref.ID'
            )
        ),
        new \Bitrix\Main\Entity\ReferenceField(
            'PB',
            '\Bitrix\Iblock\PropertyTable',
            array(
                '=this.IBLOCK_PROPERTY_ID' => 'ref.ID',
            )
        )
        */
    ]
])->FetchAll();

echo "<pre>"; print_r($arResult); echo "</pre>";

SEL ECT
    PE.VALUE, P.CODE
FR OM
    b_iblock_element_property EP
INNER JOIN
    b_iblock_property_enum PE ON EP.IBLOCK_PROPERTY_ID = PE.PROPERTY_ID AND EP.VALUE = PE.ID
INNER JOIN
    b_iblock_property P ON P.ID = EP.IBLOCK_PROPERTY_ID
WHERE
    (P.CODE = 'OPERATIVNAYA_PAMYAT' OR P.CODE = 'VSTROENNAYA_PAMYAT')
AND 
EP.IBLOCK_ELEMENT_ID = 1617059

array(1) {
  [0]=>
  array(2) {
    ["CODE"]=>
    string(9) "CALCULATE"
    ["TEXT"]=>
    string(38) "Argument 'deliveryId' is null or empty"
  }
}

$arOrderDat = CSaleOrder::DoCalculateOrder(
    SITE_ID,
    $USER->GetID(),
    $basket,
    2, // тип плательщика
    array(
        33 => '',
        35 => '',
        37 => '20',
        52 => '',
        55 => '',
        53 => '',
        56 => '',
        54 => '',
        22 => 'Тестовая Организация',
        6 => '',
        7 => '',
        8 => '',
        9 => '',
        10 => '7714704125',
        11 => '',
        12 => '',
        13 => '',
        14 => '',
        15 => '',
        16 => '',
        17 => 'Василий',
        18 => 'Сергеевич',
        19 => 'Пупкин',
        20 => '2222222',
        21 => 'test@gmail.com',
        24 => 'Россия, Москва, улица Тестовая',
        40 => '',
        92 => '',
        74 => '',
        77 => '',
        76 => '',
        79 => '',
        78 => '',
        73 => '',
        72 => '00:00',
        71 => '00:00',
        75 => '',
        83 => '',
        87 => '',
        90 => '',
        84 => '',
        86 => '',
        89 => '',
        82 => '',
        81 => '',
        88 => '',
        85 => '',
        80 => '',
    ),
    "new56:profile", // доставка
    7, // оплата
    array (

    ),
    $arErrors,
    $arWarnings
);

var_dump($arOrderDat); // возвращает NULL

echo "<pre>"; var_dump($arErrors); echo "</pre>";

// $arErrors содержит ошибку

/*
array(1) {  [0]=>
  array(2) {
    ["CODE"]=>
    string(9) "CALCULATE"
    ["TEXT"]=>
    string(38) "Argument 'deliveryId' is null or empty"
  }
}
*/

<?
if(!defined("B_PROLOG_INCLUDED") || B_PROLOG_INCLUDED!==true)die();

$clearCache = in_array($_REQUEST['mode'], $arResult["MODES"]) ? true : false;
?>

<?if(!$clearCache):?>
<div class="container" id="task_list">
<?endif;?>

    <a href="#" class="btn btn-primary" data-toggle="modal" data-target="#form"><?=GetMessage("ADD")?></a>

    <?foreach($arResult["ITEMS"] as $arItem):?>
        <div class="card my-4" data-id="<?=$arItem["ID"]?>">
            <div class="card-header">
                <?=$arItem["UF_DATETIME"]?>
                <?if(!empty($arItem["UF_DATETIME_COMPLETION"])):?> - <?=$arItem["UF_DATETIME_COMPLETION"]?><?endif;?>
            </div>
            <div class="card-body">
                <h5 class="card-title"><?=$arItem["UF_NAME"]?></h5>
                <p class="card-text"><?=$arItem["UF_COMMENT"]?></p>
                <a href="#" class="card-link" data-toggle="modal" data-target="#form"
                   data-name="<?=$arItem["UF_NAME"]?>" data-datetime="<?=$arItem["UF_DATETIME"]?>"
                   data-datetimeCompletion="<?=$arItem["UF_DATETIME_COMPLETION"]?>" data-comment="<?=$arItem["UF_COMMENT"]?>"
                   data-completed="<?=$arItem["UF_COMPLETED"]?>">
                    <?=GetMessage("EDIT")?>
                </a>
                <a href="#" class="card-link delete" data-mode="delete"><?=GetMessage("DELETE")?></a>
            </div>
            <div class="card-footer">
                <?if(!$arItem["UF_COMPLETED"]):?>
                    <a href="#" class="btn btn btn-secondary complete" data-mode="complete"><?=GetMessage("COMPLETE")?></a>
                <?else:?>
                    <a href="#" class="btn btn btn-secondary return-to-work" data-mode="returnToWork"><?=GetMessage("RETURN_TO_WORK")?></a>
                <?endif;?>
            </div>
        </div>
    <?endforeach;?>

    <?
    if($arParams['ROWS_PER_PAGE'] > 0)
    {
        $APPLICATION->IncludeComponent(
            'bitrix:main.pagenavigation',
            '',
            array(
                'NAV_OBJECT' => $arResult['nav_object'],
                'SEF_MODE' => 'Y',
            ),
            $component,
        );
    }
    ?>

    <div class="modal fade" id="form" tabindex="-1" role="dialog" aria-labelledby="form" aria-hidden="true">
        <div class="modal-dialog modal-dialog-centered" role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title" id="formTitle"><?=GetMessage("FORM_NAME")?></h5>
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">×</span>
                    </button>
                </div>
                <fo rm>
                    <input id="formId" type="hidden" value="">
                    <div class="modal-body">
                        <div class="form-group">
                            <div class="form-check form-check-inline">
                                <label class="form-check-label mr-2" for="formCompleted"><?=GetMessage("FORM_COMPLETED")?></label>
                                <input class="form-check-input" type="checkbox" id="formCompleted" value="">
                            </div>
                        </div>
                        <div class="form-group">
                            <label for="formName"><?=GetMessage("FORM_FIELD_NAME")?></label>
                            <input type="text" class="form-control" id="formName" placeholder="Введите название задачи">
                        </div>
                        <div class="form-group">
                            <label for="formDatetime"><?=GetMessage("FORM_FIELD_DATETIME")?></label>
                            <input type='text' class="form-control" id='formDatetime' placeholder="<?=date("d.m.Y H:i:s")?>" />
                        </div>
                        <div class="form-group">
                            <label for="formDatetimeCompletion"><?=GetMessage("FORM_FIELD_DATETIME_COMPLETION")?></label>
                            <input type='text' class="form-control" id='formDatetimeCompletion' placeholder="<?=date("d.m.Y H:i:s")?>" />
                        </div>
                        <div class="form-group">
                            <label for="formComment"><?=GetMessage("FORM_FIELD_COMMENT")?></label>
                            <textarea class="form-control" id="formComment" rows="3" placeholder="Введите комментарий к задаче"></textarea>
                        </div>

                    </div>
                    <div class="modal-footer">
                        <button type="button" class="btn btn-secondary" data-dismiss="modal" id="formCancel"><?=GetMessage("FORM_BTN_CANCEL")?></button>
                        <button type="button" class="btn btn-primary" id="formSave"><?=GetMessage("FORM_BTN_SAVE")?></button>
                    </div>
                </form>
            </div>
        </div>
    </div>

<?if(!$clearCache):?>
</div>

<sc ript type="text/javascript">
window.onl oad=function()
{
    function showModal()
    {
        $('#formSave').on('click', function () {
            console.log('formSave');

            var data = {
                id : $('#formId').val(),
                name: $('#formName').val(),
                datetime : $('#formDatetime').val(),
                datetimeCompletion : $('#formDatetimeCompletion').val(),
                comment : $('#formComment').val(),
                completed : $('#formCompleted').prop("checked") ? true : "",
                mode : $('#formId').val() ? 'edit' : 'add',
            };

            var request = $.ajax({
                url: "<?=$APPLICATION->GetCurPage(true);?>",
                method: "POST",
                data: data ,
            });

            request.done(function( html ) {
                $('#form').modal('hide');
                $('#form').on('hidden.bs.modal', function (e) {
                    $( "#task_list" ).html( html );
                    console.log("ajax");
                    showModal();
                });

            });

            request.fail(function( jqXHR, textStatus ) {
                console.log( "Request failed: " + textStatus );
            });
        });

        $('#form').on('show.bs.modal', function (event)
        {
            var button = $(event.relatedTarget);
            var name = button.data('name');
            var datetime = button.data('datetime');
            var datetimeCompletion = button.data('datetimeCompletion');
            var comment = button.data('comment');
            var completed = button.data('completed');

            var modal = $(this);

            var modalTitle = modal.find('#formTitle');
            var formFieldCompleted = modal.find('#formCompleted');
            var card = button.closest('.card');
            var id = card.data('id');

            var form = modal.find('form');
            var formFieldId = modal.find('#formId');
            var formFieldName = modal.find('#formName');
            var formFieldDatetime = modal.find('#formDatetime');
            var formFieldDatetimeCompletion = modal.find('#formDatetimeCompletion');
            var formFieldComment = modal.find('#formComment');
            var modalBtnSave = modal.find('#formSave');
            var modalBtnCancel = modal.find('#formCancel');

            if(button.attr("class") == "card-link")
            {
                modalTitle.html('<?=getMessage("FORM_TITLE_EDIT");?>');

                if(completed)
                    formFieldCompleted.attr('checked', true);
                else
                    formFieldCompleted.attr('checked', false);

                formFieldName.val(name);
                formFieldDatetime.val(datetime);
                formFieldDatetimeCompletion.val(datetimeCompletion);
                formFieldComment.val(comment);
                formFieldId.val(id);
            }
            else
            {
                modalTitle.html('<?=getMessage("FORM_TITLE_ADD");?>');
                form[0].reset();
                formFieldCompleted.attr('checked', false);
            }
        });

        $('.delete, .return-to-work, .complete').on("click", function()
        {
            var card = $(this).closest('.card');
            var id = card.data('id');
            var mode = $(this).data("mode");

            var data = {
                id : id,
                mode : mode,
            };

            var request = $.ajax({
                url: "<?=$APPLICATION->GetCurPage(true);?>",
                method: "POST",
                data: data ,
            });

            request.done(function( html ) {
                $( "#task_list" ).html( html );
                showModal();
            });

            request.fail(function( jqXHR, textStatus ) {
                console.log( "Request failed: " + textStatus );
            });
        });
    }
    showModal();
}
</sc ript>
<?endif;?>

global $arrFilter;

$arrFilter["ACTIVE_DATE"] = ""; 
$arrFilter["<DATE_ACTIVE_TO"] = '11.08.2016';

$arrFilter = Array(
   "IBLOCK_ID" => 1, 
   "<DATE_ACTIVE_TO" => ConvertTimeStamp(false, "SHOT"), 
   "ACTIVE"=>"Y", 
);
 
$res = CIBlockElement::GetList(Array("SORT"=>"ASC"), $arrFilter, Array("DATE_ACTIVE_TO", "NAME"));
while($ar_fields = $res->GetNext())
{
   echo $ar_fields["NAME"]."<br>";
}

$arStockFilter = array (
   "<DATE_ACTIVE_TO" => ConvertTimeStamp(false, "FULL")
);

$arStockFilter["<DATE_ACTIVE_TO"] = ConvertTimeStamp(false, "FULL");

global $arStockFilter;
$arStockFilter = array (
   "<DATE_ACTIVE_TO" => array(false, ConvertTimeStamp(false, "FULL")),
);

echo '<pre>'.print_r($GLOBALS[$arParams['FILTER_NAME']], true).'</pre>'; 

Array
(
    [ Array
        (
            [0] => 
            [1] => 16.08.2016 15:18:00
        )

)