<?php

namespace Bitrix\Mail\Internals;

use Bitrix\Main\Entity;
use Bitrix\Main\ORM\Data\Internal\DeleteByFilterTrait;

/**
 * Class MessageAccessTable
 *
 * DO NOT WRITE ANYTHING BELOW THIS
 *
 * <<< ORMENTITYANNOTATION
 * @method static EO_MessageAccess_Query query()
 * @method static EO_MessageAccess_Result getByPrimary($primary, array $parameters = array())
 * @method static EO_MessageAccess_Result getById($id)
 * @method static EO_MessageAccess_Result getList(array $parameters = array())
 * @method static EO_MessageAccess_Entity getEntity()
 * @method static \Bitrix\Mail\Internals\EO_MessageAccess createObject($setDefaultValues = true)
 * @method static \Bitrix\Mail\Internals\EO_MessageAccess_Collection createCollection()
 * @method static \Bitrix\Mail\Internals\EO_MessageAccess wakeUpObject($row)
 * @method static \Bitrix\Mail\Internals\EO_MessageAccess_Collection wakeUpCollection($rows)
 */
class MessageAccessTable extends Entity\DataManager
{
	use DeleteByFilterTrait;

	const ENTITY_TYPE_NO_BIND = 'NO_BIND';
	const ENTITY_TYPE_TASKS_TASK = 'TASKS_TASK';
	const ENTITY_TYPE_CRM_ACTIVITY = 'CRM_ACTIVITY';
	const ENTITY_TYPE_BLOG_POST = 'BLOG_POST';
	const ENTITY_TYPE_IM_CHAT = 'IM_CHAT';
	const ENTITY_TYPE_CALENDAR_EVENT = 'CALENDAR_EVENT';

	public static function getFilePath()
	{
		return __FILE__;
	}

	public static function getTableName()
	{
		return 'b_mail_message_access';
	}

	public static function getMap()
	{
		return array(
			'TOKEN' => array(
				'data_type' => 'string',
				'primary'   => true,
			),
			'MAILBOX_ID' => array(
				'data_type' => 'integer',
				'required'  => true,
			),
			'MESSAGE_ID' => array(
				'data_type' => 'integer',
				'required'  => true,
			),
			'ENTITY_UF_ID' => array(
				'data_type' => 'integer',
				'required'  => true,
			),
			'ENTITY_TYPE' => array(
				'data_type' => 'string',
				'required'  => true,
			),
			'ENTITY_ID' => array(
				'data_type' => 'integer',
				'required'  => true,
			),
			'SECRET' => array(
				'data_type' => 'string',
				'required'  => true,
			),
			'OPTIONS' => array(
				'data_type'  => 'text',
				'serialized' => true,
			),
			new Entity\ReferenceField(
				'CRM_ACTIVITY',
				'\Bitrix\Crm\ActivityTable',
				array(
					'=this.ENTITY_TYPE' => array('?s', self::ENTITY_TYPE_CRM_ACTIVITY),
					'=this.ENTITY_ID' => 'ref.ID',
				)
			),
		);
	}


	/**
	 * Get access binds as string
	 *
	 * @param int $mailboxId Mailbox ID
	 * @param int $messageId Message ID
	 *
	 * @return array|string[]
	 */
	public static function getBinds(int $mailboxId, int $messageId): array
	{
		$binds = MessageAccessTable::query()
			->where('MAILBOX_ID', $mailboxId)
			->where('MESSAGE_ID', $messageId)
			->setDistinct()
			->setSelect([
				'ENTITY_TYPE',
				'ENTITY_ID',
			])
			->fetchAll();

		return array_map(fn(array $bind): string => "{$bind['ENTITY_TYPE']}-{$bind['ENTITY_ID']}", $binds);
	}

}