field.php

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

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

class FieldTable extends DataManager
{
    public static function getTableName()
    {
        return 'b_consent_field';
    }

    public static function getMap()
    {
        return array(
            'ID' => array(
                'data_type' => 'integer',
                'primary' => true,
                'autocomplete' => true,
            ),
            'AGREEMENT_ID' => array(
                'data_type' => 'integer',
                'required' => true,
            ),
            'CODE' => array(
                'data_type' => 'string',
                'required' => true,
            ),
            'VALUE' => array(
                'data_type' => 'text',
                'required' => true,
            )
        );
    }

    public static function getConsentFields($agreementId)
    {
        $fields = array();
        $fieldsDb = static::getList(array(
            'filter' => array(
                '=AGREEMENT_ID' => $agreementId
            )
        ));
        while ($field = $fieldsDb->fetch())
        {
            $fields[$field['CODE']] = $field['VALUE'];
        }
 
        return $fields;
    }

    public static function setConsentFields($agreementId, array $fields)
    {
        // remove old fields
        $deleteFieldsDb = static::getList(array(
            'select' => array('ID'),
            'filter' => array(
                '=AGREEMENT_ID' => $agreementId
            )
        ));
        while ($deleteField = $deleteFieldsDb->fetch())
        {
            static::delete($deleteField['ID']);
        }
 
        // add new fields
        foreach ($fields as $code => $value)
        {
            $result = static::add(array(
                'AGREEMENT_ID' => $agreementId,
                'CODE' => $code,
                'VALUE' => $value,
            ));
            $result->isSuccess();
        }
    }
}