userconsentitem.php

См. документацию.

<?php
namespace Bitrix\Main\UserConsent\Internals;
 
use Bitrix\Main\Localization\Loc;
use Bitrix\Main\ORM\Fields\Relations\Reference;
use Bitrix\Main\ORM\Query\Join;
use Bitrix\Main\ORM\Data\DataManager;
 
Loc::loadMessages(__FILE__);

class UserConsentItemTable extends DataManager
{
    public static function getTableName()
    {
        return 'b_consent_user_consent_item';
    }

    public static function getMap()
    {
        return [
            'ID' => [
                'data_type' => 'integer',
                'primary' => true,
                'autocomplete' => true,
            ],
            'USER_CONSENT_ID' => [
                'data_type' => 'integer',
                'required' => true,
            ],
            'VALUE' => [
                'data_type' => 'text',
                'required' => true,
            ],
            (new Reference(
                'USER_CONSENT',
                ConsentTable::class,
                Join::on('this.USER_CONSENT_ID', 'ref.ID')
            ))
        ];
    }

    public static function addItems(int $userConsentId, array $items): void
    {
        foreach ($items as $item)
        {
            static::add([
                'USER_CONSENT_ID' => $userConsentId,
                'VALUE' => $item['VALUE'],
            ]);
        }
    }

    public static function getItems(int $userConsentId): array
    {
        $items = [];
 
        $queryObject = static::getList([
            'filter' => [
                '=USER_CONSENT_ID' => $userConsentId
            ]
        ]);
        while ($item = $queryObject->fetch())
        {
            $items[] = $item;
        }
 
        return $items;
    }

    public static function removeItems(int $userConsentId): void
    {
        $queryObject = static::getList([
            'select' => ['ID'],
            'filter' => [
                '=USER_CONSENT_ID' => $userConsentId
            ]
        ]);
        while ($item = $queryObject->fetch())
        {
            static::delete($item['ID']);
        }
    }
}