ap.php

<?php
namespace Bitrix\Socialservices;
 
use Bitrix\Main;
 
class ApTable extends Main\Entity\DataManager
{
    public static function getTableName()
    {
        return 'b_socialservices_ap';
    }
 
    public static function getMap()
    {
        return array(
            'ID' => array(
                'data_type' => 'integer',
                'primary' => true,
                'autocomplete' => true,
            ),
            'TIMESTAMP_X' => array(
                'data_type' => 'datetime',
            ),
            'USER_ID' => array(
                'data_type' => 'integer',
                'required' => true,
            ),
            'DOMAIN' => array(
                'data_type' => 'string',
            ),
            'ENDPOINT' => array(
                'data_type' => 'string',
            ),
            'LOGIN' => array(
                'data_type' => 'string',
            ),
            'PASSWORD' => array(
                'data_type' => 'string',
            ),
            'LAST_AUTHORIZE' => array(
                'data_type' => 'datetime',
            ),
            'SETTINGS' => array(
                'data_type' => 'string',
                'serialized' => true,
            ),
        );
    }
 
    public static function onBeforeUpdate(Main\Entity\Event $event)
    {
        $result = new Main\Entity\EventResult();
 
        $data = $event->getParameter("fields");
 
        // modify TIMESTAMP_X for every change other than single LAST_AUTHORIZE update
        if(count($data) > 1 || !array_key_exists('LAST_AUTHORIZE', $data))
        {
            $data['TIMESTAMP_X'] = new Main\Type\DateTime();
            $result->modifyFields($data);
        }
 
        return $result;
    }
 
    public static function getConnection()
    {
        $dbRes = static::getList(array(
            'order' => array('ID' => 'DESC'),
            'limit' => 1,
            'cache' => ['ttl' => 3600],
        ));
 
        return $dbRes->fetch();
    }
}