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

<sc ript type="text/javascript">
    jQuery(document).ready(function($){
      $(function () {
         setNavigation();
      });

      function setNavigation() {
         var path = window.location.pathname;
         path = path.replace(/\/$/, "");
         path = decodeURIComponent(path);

         $(".aside-list a").each(function () {
            var href = $(this).attr('href');
            if ('/catalog/<?=$_REQUEST['SECTION_ID']?>' === href) {
               console.log(href);
               $(this).closest('li').addClass('active');
            }
         });
      }
    });
</sc ript>

<?
global $arFilter;
$dir = $APPLICATION->GetCurDir();
$arFilter = Array(
    "PROPERTY_LINK_ADRES" => '%'.$dir.'%'
);
$APPLICATION->IncludeComponent(
   "bitrix:catalog.section", 
   "furniture", 
   array(
      "IBLOCK_TYPE" => "TEXT",
      "IBLOCK_ID" => "15",
      "SECTION_ID" => $_REQUEST["SECTION_ID"],
      "SECTION_CODE" => "",
      "SECTION_USER_FIELDS" => array(
         0 => "",
         1 => "",
      ),
      "ELEMENT_SORT_FIELD" => "RAND",
      "ELEMENT_SORT_ORDER" => "asc",
      "ELEMENT_SORT_FIELD2" => "",
      "ELEMENT_SORT_ORDER2" => "",
      "FILTER_NAME" => "arFilter",
      "INCLUDE_SUBSECTIONS" => "Y",
      "SHOW_ALL_WO_SECTION" => "N",
      "PAGE_ELEMENT_COUNT" => "30",
      "LINE_ELEMENT_COUNT" => "3",
      "PROPERTY_CODE" => array(
         0 => "LINK_ADRES",
         1 => "",
      ),
      "OFFERS_LIMIT" => "1",
      "TEMPLATE_THEME" => "",
      "MESS_BTN_BUY" => "Купить",
      "MESS_BTN_ADD_TO_BASKET" => "В корзину",
      "MESS_BTN_SUBSCRIBE" => "Подписаться",
      "MESS_BTN_DETAIL" => "Подробнее",
      "MESS_NOT_AVAILABLE" => "Нет в наличии",
      "SECTION_URL" => "",
      "DETAIL_URL" => "",
      "SECTION_ID_VARIABLE" => "SECTION_ID",
      "AJAX_MODE" => "N",
      "AJAX_OPTION_JUMP" => "N",
      "AJAX_OPTION_STYLE" => "Y",
      "AJAX_OPTION_HISTORY" => "N",
      "CACHE_TYPE" => "N",
      "CACHE_TIME" => "36000000",
      "CACHE_GROUPS" => "Y",
      "SET_TITLE" => "N",
      "SET_BROWSER_TITLE" => "N",
      "BROWSER_TITLE" => "-",
      "SET_META_KEYWORDS" => "N",
      "META_KEYWORDS" => "",
      "SET_META_DESCRIPTION" => "N",
      "META_DESCRIPTION" => "",
      "ADD_SECTIONS_CHAIN" => "N",
      "DISPLAY_COMPARE" => "N",
      "SET_STATUS_404" => "N",
      "CACHE_FILTER" => "N",
      "PRICE_CODE" => array(
      ),
      "USE_PRICE_COUNT" => "N",
      "SHOW_PRICE_COUNT" => "1",
      "PRICE_VAT_INCLUDE" => "Y",
      "BASKET_URL" => "/personal/basket.php",
      "ACTION_VARIABLE" => "action",
      "PRODUCT_ID_VARIABLE" => "id",
      "USE_PRODUCT_QUANTITY" => "N",
      "ADD_PROPERTIES_TO_BASKET" => "Y",
      "PRODUCT_PROPS_VARIABLE" => "prop",
      "PARTIAL_PRODUCT_PROPERTIES" => "N",
      "PRODUCT_PROPERTIES" => array(
      ),
      "PAGER_TEMPLATE" => "",
      "DISPLAY_TOP_PAGER" => "N",
      "DISPLAY_BOTTOM_PAGER" => "Y",
      "PAGER_TITLE" => "Товары",
      "PAGER_SHOW_ALWAYS" => "Y",
      "PAGER_DESC_NUMBERING" => "N",
      "PAGER_DESC_NUMBERING_CACHE_TIME" => "36000",
      "PAGER_SHOW_ALL" => "Y",
      "AJAX_OPTION_ADDITIONAL" => "",
      "PRODUCT_QUANTITY_VARIABLE" => "quantity"
   ),
   false
);?>

$res = CIBlockElement::GetList(Array("SORT"=>"ASC", "PROPERTY_PRIORITY"=>"ASC"), $arFilter, Array("NAME", "CODE", "SORT", "ID","DATE_ACTIVE_FROM","CNT","PROPERTY_CODE_SERVICE","PROPERTY_TIME_SERVICE", "IBLOCK_SECTION_ID"))->Fetch(); 
print_r($res); echo '<br /><br />';
if ($res['CNT']<1):
      echo 'Добавляем<br />';
/*          $el = new CIBlockElement;
         $PROP[126] = $keyadd['0'];
         $PROP[76] = $keyadd['2'];
         $PROP[77] = $keyadd['3'];
         $params = Array(
            "max_len" => "100",
            "change_case" => "L",
            "replace_space" => "_",
            "replace_other" => "_",
            "delete_repeat_replace" => "true",
         );

         $code = $keyadd['1'];

         $arLoadProductArray = Array(
           "MODIFIED_BY"    => 1, // элемент изменен текущим пользователем
           "CREATED_BY"    => 1, // элемент изменен текущим пользователем
           "IBLOCK_SECTION" => "",
           "IBLOCK_ID"      => 6,
           "CODE" => CUtil::translit($code, "ru", $params),
           "PROPERTY_VALUES"=> $PROP,
           "SORT" => 500,
           "NAME" => $keyadd['1'],
           "ACTIVE" => "Y"
           );

         if($PRODUCT_ID = $el->Add($arLoadProductArray)){

          echo "<pre>"; print_r($PRODUCT_ID); echo "</pre>";
           echo " добавлен";
         }else{
           echo "Error: ".$el->LAST_ERROR;
         }  */
else:
   #обновляем
   $el = new CIBlockElement;
        $PROP[126] = $keyadd['0'];
        $PROP[76] = $keyadd['2'];
        $PROP[77] = $res['PROPERTY_TIME_SERVICE_VALUE'];

   $arLoadProductArray = Array(
     "MODIFIED_BY"    => $USER->GetID(),
     "IBLOCK_SECTION" => $res['IBLOCK_SECTION_ID'],    
      "IBLOCK_ID"      => 6,     
     "PROPERTY_VALUES"=> $PROP,
     "NAME"           => $res['NAME'],
      "CODE" => $res['CODE'],
      "SORT" => $res['SORT'],     
     "ACTIVE"         => "Y"
     );
     
   if($el->Update($res['ID'], $arLoadProductArray)):
      echo 'обновлен '.$res['ID'].'<br />';
   else:
      echo 'не могу обновить '.$res['ID'].' <br />';
   endif;
endif;

CIBlockElement::SetPropertyValues($res['ID'], '6', 'PRICE', $keyadd['2'])

$res = CIBlockElement::GetList(Array("SORT"=>"ASC", "PROPERTY_PRIORITY"=>"ASC"), $arFilter, Array("NAME","ID","DATE_ACTIVE_FROM","CNT","PROPERTY_CODE_SERVICE"))->Fetch(); 
print_r($res); echo '<br /><br />';
if ($res['CNT']!=1):
      #Добавляем
         $el = new CIBlockElement;
         $PROP[126] = $keyadd['0'];
         $PROP[76] = $keyadd['2'];
         $PROP[77] = $keyadd['3'];
         $params = Array(
            "max_len" => "100",
            "change_case" => "L",
            "replace_space" => "_",
            "replace_other" => "_",
            "delete_repeat_replace" => "true",
         );

         $code = $keyadd['1'];

         $arLoadProductArray = Array(
           "MODIFIED_BY"    => 1, // элемент изменен текущим пользователем
           "CREATED_BY"    => 1, // элемент изменен текущим пользователем
           "IBLOCK_SECTION" => "",
           "IBLOCK_ID"      => 6,
           "CODE" => CUtil::translit($code, "ru", $params),
           "PROPERTY_VALUES"=> $PROP,
           "SORT" => 500,
           "NAME" => $keyadd['1'],
           "ACTIVE" => "Y"
           );

         if($PRODUCT_ID = $el->Add($arLoadProductArray)){

          echo "<pre>"; print_r($PRODUCT_ID); echo "</pre>";
           echo " добавлен";
         }else{
           echo "Error: ".$el->LAST_ERROR;
         } 
else:
   #обновляем
   if(CIBlockElement::SetPropertyValues($res['ID'], '6', 'PRICE', $keyadd['2'])):
      echo 'обновлен '.$res['ID'].'<br />';
   else:
      echo 'не могу обновить '.$res['ID'].' <br />';
   endif;
endif;

   #обновляем
   if(CIBlockElement::SetPropertyValues($res['ID'], '6', 'PRICE', $keyadd['2'])):
      echo 'обновлен '.$res['ID'].'<br />';
   else:
      echo 'не могу обновить '.$res['ID'].' <br />';
   endif;

$arFilter = Array(
 "IBLOCK_ID"=>6,
 "PROPERTY_CODE_SERVICE"=>$keyadd['0']
 );
$num = CIBlockElement::GetList(array(),array('IBLOCK_ID'=>6, "PROPERTY_CODE_SERVICE"=>$keyadd['0'], "ACTIVE"=>"Y"),array());
#echo $num.'<br />';
if($num == 0):
   $res = CIBlockElement::GetList(Array("SORT"=>"ASC", "PROPERTY_PRIORITY"=>"ASC"), $arFilter, Array("NAME","ID","DATE_ACTIVE_FROM","PROPERTY_CODE_SERVICE"));
   while($ar_fields = $res->GetNext())
   {
      #Добавляем
         $el = new CIBlockElement;
         $PROP[126] = $keyadd['0'];
         $PROP[76] = $keyadd['2'];
         $PROP[77] = $keyadd['3'];
         $params = Array(
            "max_len" => "100",
            "change_case" => "L",
            "replace_space" => "_",
            "replace_other" => "_",
            "delete_repeat_replace" => "true",
         );

         $code = $keyadd['1'];

         $arLoadProductArray = Array(
           "MODIFIED_BY"    => 1, 
           "CREATED_BY"    => 1,
           "IBLOCK_SECTION" => "",
           "IBLOCK_ID"      => 6,
           "CODE" => CUtil::translit($code, "ru", $params),
           "PROPERTY_VALUES"=> $PROP,
           "SORT" => 500,
           "NAME" => $keyadd['1'],
           "ACTIVE" => "Y"
           );

         if($PRODUCT_ID = $el->Add($arLoadProductArray)){

          echo "<pre>"; print_r($PRODUCT_ID); echo "</pre>";
           echo " добавлен";
         }else{
           echo "Error: ".$el->LAST_ERROR;
         } 
   }
else:
   #обновляем
   if(CIBlockElement::SetPropertyValuesEx($ar_fields['ID'], false, array('PRICE' => $keyadd['2'])))
      echo 'обновлен '.$ar_fields['ID'].'<br />';
endif;

[Bitrix\Main\DB\SqlQueryException] 
Mysql query error: Unknown column 'currency_currency.BASE' in 'where clause' (400)
SEL ECT 
   `currency_currency`.`CURRENCY` AS `CURRENCY`
FR OM `b_catalog_currency` `currency_currency` 

WHERE UPPER(`currency_currency`.`BASE`) like upper('Y')
AND `currency_currency`.`AMOUNT` = 1