fuser.php

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

<?php
namespace Bitrix\Sale\Internals;
 
use Bitrix\Main;
use Bitrix\Main\Localization\Loc;
 
Loc::loadMessages(__FILE__);

class FuserTable extends Main\Entity\DataManager
{
    public static function getTableName()
    {
        return 'b_sale_fuser';
    }

    public static function getMap()
    {
        global $DB;
 
        return array(
            'ID' => array(
                'data_type' => 'integer',
                'primary' => true,
                'autocomplete' => true,
            ),
            'DATE_INSERT' => array(
                'data_type' => 'datetime'
            ),
            'DATE_INS' => array(
                'data_type' => 'datetime',
                'expression' => array(
                    $DB->DatetimeToDateFunction('%s'), 'DATE_INSERT'
                )
            ),
            'DATE_UPDATE' => array(
                'data_type' => 'datetime'
            ),
            'DATE_UPD' => array(
                'data_type' => 'datetime',
                'expression' => array(
                    $DB->DatetimeToDateFunction('%s'), 'DATE_UPDATE'
                )
            ),
            new Main\Entity\IntegerField(
                "USER_ID"
            ),
 
            'USER' => array(
                'data_type' => 'Bitrix\Main\User',
                'reference' => array('=this.USER_ID' => 'ref.ID')
            ),
 
            new Main\Entity\StringField(
                'CODE', 
                array(
                    'size' => 32
                )),
        );
    }

    public static function getUserById($id)
    {
        $id = (int)$id;
        if ($id <= 0)
            return false;
        $fuserIterator = self::getList(array(
            'select' => array('USER_ID'),
            'filter' => array('=ID' => $id)
        ));
        if ($fuser = $fuserIterator->fetch())
            return (int)$fuser['USER_ID'];
        return false;
    }
}