Антон Тупиков (Все сообщения пользователя)

$arFilter = Array("USER_ID" => $USER->GetID(), "!@STATUS_ID" => [$arParams['NOT_SHOW_ORDERS']]);

if ($arParams['SHOW_TYPE'][0] == 'S')
{
   $new = [
      "LOGIC" => "OR",
      ["PROPERTY.ORDER_PROPS_ID" => "1", "PROPERTY.VALUE" => "Y"],
      ["PROPERTY.ORDER_PROPS_ID" => "2", "PROPERTY.VALUE" => "Y"]
   ];
}

$arFilter[] = $new;

$rsOrder = Bitrix\Sale\Order::getList([
    'select' => ['*', 'PROPERTY']
    ,'filter' => $arFilter
    ,'order' => ['ID'=>'DESC']
    ,'limit' => 999
]);

elseif ($arParams['SHOW_TYPE'][0] == 'O')
{
   $new = [
      "LOGIC" => "AND",
      ["PROPERTY.ORDER_PROPS_ID" => "1", "PROPERTY.VALUE" => "N"],
      ["PROPERTY.ORDER_PROPS_ID" => "2", "PROPERTY.VALUE" => "N"]
   ];
}

$arFilter = Array("USER_ID" => $USER->GetID(), "!@STATUS_ID" => [$arParams['NOT_SHOW_ORDERS']]);

if ($arParams['SHOW_TYPE'][0] == 'S')
{
   $new = [
      "LOGIC" => "OR",
      ["PROPERTY_VAL_BY_CODE_SUBSCRIPTION_ORDER" => "Y"],
      ["PROPERTY_VAL_BY_CODE_BUY_SUBSCRIPTION" => "Y"]
   ];
   $arFilter[] = $new;
}
$rsOrder = CSaleOrder::GetList(
   array('ID' => 'DESC'),
   $arFilter,
   false,
   false,
   ['PROPERTY_VAL_BY_CODE_SUBSCRIPTION_ORDER', 'PROPERTY_VAL_BY_CODE_BUY_SUBSCRIPTION', '*']
);

Array
(
    [USER_ID] => 1
    [!@STATUS_ID] => Array
        (
            [0] => Array
                (
                    [0] => N
                    [1] => C
                )

        )

    [0] => Array
        (
            [LOGIC] => OR
            [0] => Array
                (
                    [PROPERTY_VAL_BY_CODE_SUBSCRIPTION_ORDER] => Y
                )

            [1] => Array
                (
                    [PROPERTY_VAL_BY_CODE_BUY_SUBSCRIPTION] => Y
                )

        )

)

Array
(
    [PROPERTY_VAL_BY_CODE_SUBSCRIPTION_ORDER] => N
    [PROPERTY_VAL_BY_CODE_BUY_SUBSCRIPTION] => N
    [ID] => 212
    [LID] => s1
)