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

<sc ript>
$(document)
   .on('change', $('[name="PROPERTY_COUNTRY"]'), function() {
     $(this).closest('form').trigger('submit')
   })
   .on('submit', $('form'), function(e) {
      e.preventDefault();
      console.log('test');

      $.ajax({
        type: "GET",
        url: 'https://aecsd.org/test',
        data: 'PROPERTY_COUNTRY=' + $('select[name="PROPERTY_COUNTRY"] option:selected').val(),
        success: function(msg){
          alert('success');
         },
         error: function(msg){
           alert('error');
         }
      });
   });
</sc ript>

<sc ript>
   $(document).ready(function(){

      $('select[name="PROPERTY_COUNTRY"]').on('change', function(){
         $(this).closest('form').trigger('submit');
      }).on('submit', $('form'), function(e){
         e.preventDefault();

         $.ajax({
            type: "GET",
            url: 'https://aecsd.org/test',
            data: 'PROPERTY_COUNTRY=' + $('select[name="PROPERTY_COUNTRY"] option:selected').val(),
            success: function(msg){
               alert('success');
            },
            error: function(msg){
               alert('error');
            }
         });
      });

   });

</sc ript>

<?
//$GLOBALS['filter_ex'] = array('PROPERTY_COUNTRY' => 'India');//фильтруем по стране
?>

<?$APPLICATION->IncludeComponent(
   "bitrix:news.list", 
   "pdf_list", 
   array(
      "COMPONENT_TEMPLATE" => "pdf_list",
      "IBLOCK_TYPE" => "ru",
      "IBLOCK_ID" => "54",
      "NEWS_COUNT" => "20",
      "SORT_BY1" => "ACTIVE_FROM",
      "SORT_ORDER1" => "DESC",
      "SORT_BY2" => "SORT",
      "SORT_ORDER2" => "ASC",
      "FILTER_NAME" => "filter_ex",
      "FIELD_CODE" => array(
         0 => "",
         1 => "",
      ),
      "PROPERTY_CODE" => array(
         0 => "",
         1 => "",
      ),
      "CHECK_DATES" => "Y",
      "DETAIL_URL" => "",
      "AJAX_MODE" => "N",
      "AJAX_OPTION_JUMP" => "N",
      "AJAX_OPTION_STYLE" => "Y",
      "AJAX_OPTION_HISTORY" => "N",
      "AJAX_OPTION_ADDITIONAL" => "",
      "CACHE_TYPE" => "A",
      "CACHE_TIME" => "36000000",
      "CACHE_FILTER" => "N",
      "CACHE_GROUPS" => "Y",
      "PREVIEW_TRUNCATE_LEN" => "",
      "ACTIVE_DATE_FORMAT" => "d.m.Y",
      "SET_TITLE" => "Y",
      "SET_BROWSER_TITLE" => "Y",
      "SET_META_KEYWORDS" => "Y",
      "SET_META_DESCRIPTION" => "Y",
      "SET_LAST_MODIFIED" => "N",
      "INCLUDE_IBLOCK_INTO_CHAIN" => "Y",
      "ADD_SECTIONS_CHAIN" => "Y",
      "HIDE_LINK_WHEN_NO_DETAIL" => "N",
      "PARENT_SECTION" => "",
      "PARENT_SECTION_CODE" => "",
      "INCLUDE_SUBSECTIONS" => "Y",
      "STRICT_SECTION_CHECK" => "N",
      "DISPLAY_DATE" => "Y",
      "DISPLAY_NAME" => "Y",
      "DISPLAY_PICTURE" => "Y",
      "DISPLAY_PREVIEW_TEXT" => "Y",
      "PAGER_TEMPLATE" => ".default",
      "DISPLAY_TOP_PAGER" => "N",
      "DISPLAY_BOTTOM_PAGER" => "Y",
      "PAGER_TITLE" => "Новости",
      "PAGER_SHOW_ALWAYS" => "N",
      "PAGER_DESC_NUMBERING" => "N",
      "PAGER_DESC_NUMBERING_CACHE_TIME" => "36000",
      "PAGER_SHOW_ALL" => "N",
      "PAGER_BASE_LINK_ENABLE" => "N",
      "SET_STATUS_404" => "N",
      "SHOW_404" => "N",
      "MESSAGE_404" => ""
   ),
   false
);?>

<sc ript>
   $(document).ready(function(){
      $('select[name="PROPERTY_COUNTRY"]').on('change', function(){
         console.log('onchange event');
         $('form#myform').submit(function(){

            console.log('form submit event');
         });
      });
   });
</sc ript>

<?
require($_SERVER["DOCUMENT_ROOT"]."/bitrix/header.php");
$APPLICATION->SetTitle("Title");
?>
 
 
 
<fo rm>
    <sel ect name="company" style="width: 100px;">
        <option value="Выберите страну">Выберите Компанию</option>
        <option value="National Securities Depository Limited">National Securities Depository Limited</option>
        <option value="National Settlement Depository">National Settlement Depository</option>
        <option value="Merkezi KayД±t KuruluЕџu A.Ећ.">Merkezi KayД±t KuruluЕџu A.Ећ.</option>
        <option value="TDCC Taiwan Depository & Clearing Corporation">TDCC Taiwan Depository & Clearing Corporation</option>
        <option value="Central Depository of Armenia">Central Depository of Armenia</option>
        <option value="CSDC (China Securities Depository and Clearing Corporation)">CSDC (China Securities Depository and Clearing Corporation)</option>
        <option value="Euroclear">Euroclear</option>
        <option value="KSD (Korean Securities Depository)">KSD (Korean Securities Depository)</option>
        <option value="SHCH (Shanghai Clearing House)">SHCH (Shanghai Clearing House)</option>
    </select>
 
    <select name="country">
        <option value="Выберите страну">Выберите страну</option>
        <option value="India">India</option>
        <option value="India">Russia</option>
        <option value="Turkey">Turkey</option>
        <option value="Taiwan">Taiwan</option>
        <option value="Armenia">Armenia</option>
        <option value="China">China</option>
        <option value="Belgium">Belgium</option>
        <option value="Korea">Korea</option>
        <option value="Korea">Korea</option>
    </select>
 
    <input type="date" name="date-fr om" />
    <input type="date" name="date-to" />
 
    <select name="subject" style="width: 140px;">
        <option value="Выберите тему">Выберите тему</option>
        <option value="E-Voting System of NSDL (Video)">E-Voting System of NSDL (Video)</option>
        <option value="E-Voting System of NSDL (Presentation)">E-Voting System of NSDL (Presentation)</option>
        <option value="Creating the E-Voting System for Shareholder Meetings in Russia (Article)">Creating the E-Voting System for Shareholder Meetings in Russia (Article)</option>
        <option value="E-voting System (Presentation)">E-voting System (Presentation)</option>
        <option value="Electronic General Meeting (e-GEM)">Electronic General Meeting (e-GEM)</option>
        <option value="Public Disclosure Platform (PDP)">Public Disclosure Platform (PDP)</option>
        <option value="Implementation of Non-Custody Services">Implementation of Non-Custody Services</option>
        <option value="E-Voting Opportunities">E-Voting Opportunities</option>
        <option value="FinTech and Cyber Resilience (Presentation, WFC Board, May 2017)">FinTech and Cyber Resilience (Presentation, WFC Board, May 2017)</option>
        <option value="Better Corporate Governance With E-voting Gradually Gets Adopted in Taiwan. -a Big Data Analysis of Taiwan’s E-voting in AGMs">Better Corporate Governance With E-voting Gradually Gets Adopted in Taiwan. -a Big Data Analysis of Taiwan’s E-voting in AGMs</option>
        <option value="Cash accounts & New opportunities">Cash accounts & New opportunities</option>
        <option value="Government bonds for individuals">Government bonds for individuals</option>
        <option value="Legal Risk Management for Stock Connect">Legal Risk Management for Stock Connect</option>
        <option value="Cross-border links challenges">Cross-border links challenges</option>
        <option value="CSDs’ role in Implementing Cross-border investments">CSDs’ role in Implementing Cross-border investments</option>
        <option value="China Bond Market">China Bond Market</option>
    </select>
 
</form>
 
 
<?require($_SERVER["DOCUMENT_ROOT"]."/bitrix/footer.php");?>

        $arSelect = Array('ID','IBLOCK_ID','UF_NPS_RATEABLE');
   $arFilter = Array("IBLOCK_ID" => 5, "ACTIVE"=>"Y", "UF_NPS_RATEABLE"=> true);


   $subSections = CIBlockSection::GetList($arSelect, false, $arFilter);
   //$subSections = CIBlockSection::GetList($arFilter, false, $arSelect);

   while($items = $subSections->Fetch()){
      echo '<pre>';
      print_r($items);
      echo '</pre>';
   }

<?
require($_SERVER["DOCUMENT_ROOT"]."/bitrix/header.php");
?>


<?
   global $DB;
   $query = "Sel ect DISTINCT nps.dep_id , nps.dep_name As 'Отдел', score as 'Оценка', CONCAT(LAST_NAME,' ', NAME, ' ', SECOND_NAME) as 'ФИО' ,comment as 'Комментарий' Fr om nps, b_user Where nps.user_id=b_user.ID Order By nps.dep_name";

   $results = $DB->Query($query);

   if($results->fetch()!=false){?>
      <table cellpadding="0" cellspacing="0" border="1">
         <thead>
            <tr>
               <th>Отдел</th><th>Оценка</th><th>ФИО</th><th>Комментарий</th>
            </tr>
         </thead>
         <tbody>
   <?
      while($row = $results->fetch()){?>
         <tr>
            <td><?=$row['Отдел']?></td><td><?=$row['Оценка']?></td><td><?=$row['ФИО']?></td><td><?=$row['Комментарий']?></td>
         </tr>
      <?}?>

         </tbody>
      </table>
   <?}


   $file="demo.xls";
   header("Content-type: application/vnd.ms-excel");
   header("Content-Disposition: attachment; filename=$file");


?>



<?require($_SERVER["DOCUMENT_ROOT"]."/bitrix/footer.php");?>

Sel ect dep_name as 'Отдел', Sum(points)/count(points) as 'Средний балл за день', points as 'Оценка', date as 'Дата' Fr om nps
Wh ere dep_id=218
Group by date

With My_CTE(dep_name, points, date)
AS
(
   SEL ECT dep_name AS 'Отдел', AVG(points) AS 'Средний_балл_за_день',  points AS 'Оценка', date AS 'Дата' FR OM nps
   GROUP BY dep_name, date
)

Select dep_name, points, date Fr om My_CTE

Ошибка
Ошибка во время выполнения запроса:
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'My_CTE(dep_name, points, date)
AS
(
SELECT dep_name AS 'Отдел', AVG(points' at line 1!

...
if (!empty($_SESSION['USER_FAVORITES']))
{
      global $favFilter;
      $favFilter = array('ID' => array_flip($_SESSION['USER_FAVORITES']));
?>
<sc ript>
   var isFavorDir = true;
</sc ript>
....

<?$APPLICATION->IncludeComponent(
      "bitrix:catalog.section", 
      "common", 
      array(
         "IS_CATALOG" => "Y",
         "IS_FAVOR" => "Y",
         "COMPARE_PATH" => SITE_DIR."store/compare/",
         "TEMPLATE_THEME" => "",
         "PRODUCT_DISPLAY_MODE" => "Y",
         "ADD_PICT_PROP" => "-",
         "LABEL_PROP" => "-",
         "OFFER_ADD_PICT_PROP" => "FILE",
         "OFFER_TREE_PROPS" => array(
            0 => "-",
         ),
         "PRODUCT_SUBSCRIPTION" => "N",
         "SHOW_DISCOUNT_PERCENT" => "N",
         "SHOW_OLD_PRICE" => "Y",
         "SHOW_CLOSE_POPUP" => "N",
         "MESS_BTN_BUY" => "Купить",
         "MESS_BTN_ADDED_TO_BASKET" => "В корзине",
         "MESS_BTN_ADD_TO_BASKET" => "В корзину",
         "MESS_BTN_SUBSCRIBE" => "Подписаться",
         "MESS_BTN_DETAIL" => "Подробнее",
         "MESS_NOT_AVAILABLE" => "Нет в наличии",
         "AJAX_MODE" => "N",
         "SEF_MODE" => "N",
         "IBLOCK_TYPE" => "services",
         "IBLOCK_ID" => "8",
         "SECTION_ID" => "",
         "SECTION_CODE" => "",
         "SECTION_USER_FIELDS" => array(
            0 => "",
            1 => "",
         ),
         "ELEMENT_SORT_FIELD" => "active_from",
         "ELEMENT_SORT_ORDER" => "desc",
         "ELEMENT_SORT_FIELD2" => "sort",
         "ELEMENT_SORT_ORDER2" => "desc",
         "FILTER_NAME" => "favFilter",
         "INCLUDE_SUBSECTIONS" => "Y",
         "SHOW_ALL_WO_SECTION" => "Y",
         "SECTION_URL" => "",
         "DETAIL_URL" => "//store/#SECTION_CODE_PATH#/#CODE#/",
         "BASKET_URL" => "/personal/cart/",
         "ACTION_VARIABLE" => "action",
         "PRODUCT_ID_VARIABLE" => "id",
         "PRODUCT_QUANTITY_VARIABLE" => "quantity",
         "ADD_PROPERTIES_TO_BASKET" => "Y",
         "PRODUCT_PROPS_VARIABLE" => "prop",
         "PARTIAL_PRODUCT_PROPERTIES" => "Y",
         "SECTION_ID_VARIABLE" => "SECTION_ID",
         "ADD_SECTIONS_CHAIN" => "N",
         "DISPLAY_COMPARE" => "Y",
         "SET_TITLE" => "N",
         "SET_BROWSER_TITLE" => "N",
         "BROWSER_TITLE" => "-",
         "SET_META_KEYWORDS" => "Y",
         "META_KEYWORDS" => "",
         "SET_META_DESCRIPTION" => "N",
         "META_DESCRIPTION" => "",
         "SET_LAST_MODIFIED" => "N",
         "USE_MAIN_ELEMENT_SECTION" => "N",
         "SET_STATUS_404" => "Y",
         "PAGE_ELEMENT_COUNT" => "20",
         "LINE_ELEMENT_COUNT" => "3",
         "PROPERTY_CODE" => array(
            0 => "NEWPRODUCT",
            1 => "",
         ),
         "OFFERS_FIELD_CODE" => array(
            0 => "NAME",
            1 => "",
         ),
         "OFFERS_PROPERTY_CODE" => array(
            0 => "SIZES_SHOES",
            1 => "SIZES_CLOTHES",
            2 => "SLEEVE",
            3 => "COLOR_REF",
            4 => "PRINT",
            5 => "ARTNUMBER",
            6 => "MORE_PHOTO",
            7 => "",
         ),
         "OFFERS_SORT_FIELD" => "active_from",
         "OFFERS_SORT_ORDER" => "asc",
         "OFFERS_SORT_FIELD2" => "sort",
         "OFFERS_SORT_ORDER2" => "desc",
         "OFFERS_LIMIT" => "0",
         "BACKGROUND_IMAGE" => "-",
         "PRICE_CODE" => array(
            0 => "BASE",
         ),
         "USE_PRICE_COUNT" => "N",
         "SHOW_PRICE_COUNT" => "1",
         "PRICE_VAT_INCLUDE" => "N",
         "PRODUCT_PROPERTIES" => array(),
         "USE_PRODUCT_QUANTITY" => "Y",
         "CACHE_TYPE" => "A",
         "CACHE_TIME" => "36000000",
         "CACHE_FILTER" => "Y",
         "CACHE_GROUPS" => "N",
         "DISPLAY_TOP_PAGER" => "N",
         "DISPLAY_BOTTOM_PAGER" => "N",
         "PAGER_TITLE" => "Товары",
         "PAGER_SHOW_ALWAYS" => "N",
         "PAGER_TEMPLATE" => "",
         "PAGER_DESC_NUMBERING" => "N",
         "PAGER_DESC_NUMBERING_CACHE_TIME" => "36000",
         "PAGER_SHOW_ALL" => "N",
         "HIDE_NOT_AVAILABLE" => "N",
         "OFFERS_CART_PROPERTIES" => array(
            0 => "SIZES_SHOES",
            1 => "SIZES_CLOTHES",
            2 => "SLEEVE",
            3 => "COLOR_REF",
            4 => "PRINT",
            5 => "ARTNUMBER",
         ),
         "AJAX_OPTION_JUMP" => "N",
         "AJAX_OPTION_STYLE" => "Y",
         "AJAX_OPTION_HISTORY" => "N",
         "CONVERT_CURRENCY" => "N",
         "CURRENCY_ID" => "RUB",
         "ADD_TO_BASKET_ACTION" => "ADD",
         "PAGER_BASE_LINK_ENABLE" => "N",
         "SHOW_404" => "Y",
         "MESSAGE_404" => "",
         "PAGER_BASE_LINK" => "",
         "PAGER_PARAMS_NAME" => "arrPager",
         "COMPONENT_TEMPLATE" => "common",
         "MESS_BTN_COMPARE" => "Сравнить",
         "SEF_RULE" => "",
         "SECTION_CODE_PATH" => "",
         "AJAX_OPTION_ADDITIONAL" => "",
         "FILE_404" => "",
         "DISABLE_INIT_JS_IN_COMPONENT" => "N"
      ),
      false
   );?>

....

if(\Bitrix\Main\Loader::includeModule("sale"))
    {
        


       $favFilter = array('ID' => array_flip($_SESSION['USER_FAVORITES']));
       $id_list = array();

       foreach ($favFilter['ID'] as $item) {
           $id_list[] = $item;//тут хранятся id всех отложенных товаров
       }

       
       $arSelect = Array("ID", "IBLOCK_ID","NAME", "DATE_ACTIVE_FROM", "PROPERTY_*");


       $arFilter = Array("IBLOCK_ID"=>8, "ID"=>$id_list[0], "ACTIVE_DATE"=>"Y", "ACTIVE"=>"Y");
       $res = CIBlockElement::GetList(Array(), $arFilter, false, false, $arSelect);
       while($ob = $res->GetNextElement())
       {
            $arFields = $ob->GetFields();
            $arProps = $ob->GetProperties();

            echo '<pre>';
            var_dump($arFields);
            echo '</pre>';

            echo '-------Свойства-----';

            echo '<pre>';
            var_dump($arProps);
            echo '</pre>';

            //Получаем торговые предложения

            $IBLOCK_ID = 8; //Номер инфоблока с товарами смотрим в админ панели
            $ID = $id_list[0]; 
            $arInfo = CCatalogSKU::GetInfoByProductIBlock($IBLOCK_ID); 
            if (is_array($arInfo)) 
            {
                //Получаем цены торговых предложений и затем выбираем минимальную цену
                $all_prices = array();
                $rsOffers = CIBlockElement::GetList(array(),array('IBLOCK_ID' => $arInfo['IBLOCK_ID'], 'PROPERTY_'.$arInfo['SKU_PROPERTY_ID'] => $ID));
                while ($arOffer = $rsOffers->GetNext())
                {
                    
                    echo "-----------ТП--------<br/>";
                    $rsPrices = CPrice::GetList(array(), array('PRODUCT_ID' => IntVal($arOffer['ID']),'CATALOG_GROUP_ID' => 1) );//номер типа цен смотрим в админ панели
                    if ($arPrice = $rsPrices->Fetch())
                    {
                       var_dump($arPrice["PRICE"]);
                       $all_prices[] = IntVal($arPrice["PRICE"]);
                    }
                    echo "---------/ТП----------<br/>";
                } 
            }



            echo '----------';
        }



    }

....