| Server IP : 37.220.80.31 / Your IP : 3.15.25.131 Web Server : Apache/2.4.52 (Ubuntu) System : Linux 3051455-guretool.twc1.net 5.15.0-107-generic #117-Ubuntu SMP Fri Apr 26 12:26:49 UTC 2024 x86_64 User : www-root ( 1010) PHP Version : 7.4.33 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /var/www/www-root/data/www/dev.artlot24.ru/bitrix/modules/catalog/lib/ |
Upload File : |
<?php
namespace Bitrix\Catalog;
use Bitrix\Main,
Bitrix\Main\Localization\Loc,
Bitrix\Main\ORM,
Bitrix\Main\Type;
Loc::loadMessages(__FILE__);
/**
* Class DiscountEntityTable
*
* Fields:
* <ul>
* <li> ID int mandatory
* <li> DISCOUNT_ID int mandatory
* <li> MODULE_ID string(50) mandatory
* <li> ENTITY string(255) mandatory
* <li> ENTITY_ID int optional
* <li> ENTITY_VALUE string(255) optional
* <li> FIELD_ENTITY string(255) mandatory
* <li> FIELD_TABLE string(255) mandatory
* </ul>
*
* @package Bitrix\Catalog
*
* DO NOT WRITE ANYTHING BELOW THIS
*
* <<< ORMENTITYANNOTATION
* @method static EO_DiscountEntity_Query query()
* @method static EO_DiscountEntity_Result getByPrimary($primary, array $parameters = array())
* @method static EO_DiscountEntity_Result getById($id)
* @method static EO_DiscountEntity_Result getList(array $parameters = array())
* @method static EO_DiscountEntity_Entity getEntity()
* @method static \Bitrix\Catalog\EO_DiscountEntity createObject($setDefaultValues = true)
* @method static \Bitrix\Catalog\EO_DiscountEntity_Collection createCollection()
* @method static \Bitrix\Catalog\EO_DiscountEntity wakeUpObject($row)
* @method static \Bitrix\Catalog\EO_DiscountEntity_Collection wakeUpCollection($rows)
*/
class DiscountEntityTable extends ORM\Data\DataManager
{
const ENTITY_ELEMENT = 'ELEMENT';
const ENTITY_ELEMENT_PROPERTY = 'ELEMENT_PROPERTY';
const ENTITY_PRODUCT = 'PRODUCT';
/**
* Returns DB table name for entity.
*
* @return string
*/
public static function getTableName()
{
return 'b_catalog_discount_entity';
}
/**
* Returns entity map definition.
*
* @return array
*/
public static function getMap()
{
return [
'ID' => new ORM\Fields\IntegerField('ID', [
'primary' => true,
'autocomplete' => true,
'title' => Loc::getMessage('DISCOUNT_ENTITY_ENTITY_ID_FIELD')
]),
'DISCOUNT_ID' => new ORM\Fields\IntegerField('DISCOUNT_ID', [
'required' => true,
'title' => Loc::getMessage('DISCOUNT_ENTITY_ENTITY_DISCOUNT_ID_FIELD')
]),
'MODULE_ID' => new ORM\Fields\StringField('MODULE_ID', [
'required' => true,
'validation' => [__CLASS__, 'validateModuleId'],
'title' => Loc::getMessage('DISCOUNT_ENTITY_ENTITY_MODULE_ID_FIELD')
]),
'ENTITY' => new ORM\Fields\StringField('ENTITY', [
'required' => true,
'validation' => [__CLASS__, 'validateEntity'],
'title' => Loc::getMessage('DISCOUNT_ENTITY_ENTITY_ENTITY_FIELD')
]),
'ENTITY_ID' => new ORM\Fields\IntegerField('ENTITY_ID', [
'title' => Loc::getMessage('DISCOUNT_ENTITY_ENTITY_ENTITY_ID_FIELD')
]),
'ENTITY_VALUE' => new ORM\Fields\StringField('ENTITY_VALUE', [
'title' => Loc::getMessage('DISCOUNT_ENTITY_ENTITY_ENTITY_VALUE_FIELD')
]),
'FIELD_ENTITY' => new ORM\Fields\StringField('FIELD_ENTITY', [
'required' => true,
'validation' => [__CLASS__, 'validateFieldEntity'],
'title' => Loc::getMessage('DISCOUNT_ENTITY_ENTITY_FIELD_ENTITY_FIELD')
]),
'FIELD_TABLE' => new ORM\Fields\StringField('FIELD_TABLE', [
'required' => true,
'validation' => [__CLASS__, 'validateFieldTable'],
'title' => Loc::getMessage('DISCOUNT_ENTITY_ENTITY_FIELD_TABLE_FIELD')
]),
'DISCOUNT' => new ORM\Fields\Relations\Reference(
'DISCOUNT',
'\Bitrix\Catalog\Discount',
['=this.DISCOUNT_ID' => 'ref.ID']
)
];
}
/**
* Returns validators for MODULE_ID field.
*
* @return array
*/
public static function validateModuleId()
{
return [
new ORM\Fields\Validators\LengthValidator(null, 50)
];
}
/**
* Returns validators for ENTITY field.
*
* @return array
*/
public static function validateEntity()
{
return [
new ORM\Fields\Validators\LengthValidator(null, 255)
];
}
/**
* Returns validators for FIELD_ENTITY field.
*
* @return array
*/
public static function validateFieldEntity()
{
return [
new ORM\Fields\Validators\LengthValidator(null, 255)
];
}
/**
* Returns validators for FIELD_TABLE field.
*
* @return array
*/
public static function validateFieldTable()
{
return [
new ORM\Fields\Validators\LengthValidator(null, 255)
];
}
/**
* Delete entity list by discount.
*
* @param int $discount Discount id.
* @return void
*/
public static function deleteByDiscount($discount)
{
$discount = (int)$discount;
if ($discount <= 0)
return;
$conn = Main\Application::getConnection();
$helper = $conn->getSqlHelper();
$conn->queryExecute(
'delete from '.$helper->quote(self::getTableName()).' where '.$helper->quote('DISCOUNT_ID').' = '.$discount
);
unset($helper, $conn);
}
/**
* Return entity by discount list.
*
* @param array $discountList Discount id list.
* @param array $filter Additional filter.
* @param bool $groupModule Group by modules.
* @return array
*/
public static function getByDiscount(array $discountList, $filter = [], $groupModule = true)
{
$groupModule = ($groupModule === true);
$result = [];
if (!empty($discountList))
{
Type\Collection::normalizeArrayValuesByInt($discountList);
if (!empty($discountList))
{
if (!is_array($filter))
$filter = [];
$discountRows = array_chunk($discountList, 500);
foreach ($discountRows as &$row)
{
$filter['@DISCOUNT_ID'] = $row;
$entityIterator = self::getList([
'select' => [
'DISCOUNT_ID', 'MODULE_ID',
'ENTITY', 'ENTITY_ID', 'ENTITY_VALUE', 'FIELD_ENTITY', 'FIELD_TABLE'
],
'filter' => $filter
]);
if ($groupModule)
{
while ($entity = $entityIterator->fetch())
{
unset($entity['DISCOUNT_ID']);
$module = $entity['MODULE_ID'];
$entityCode = $entity['ENTITY'];
if (!isset($result[$module]))
$result[$module] = [];
if (!isset($result[$module][$entityCode]))
$result[$module][$entityCode] = [];
$result[$module][$entityCode][$entity['FIELD_ENTITY']] = $entity;
}
unset($entityCode, $module);
}
else
{
while ($entity = $entityIterator->fetch())
{
$entity['DISCOUNT_ID'] = (int)$entity['DISCOUNT_ID'];
if (!isset($result[$entity['DISCOUNT_ID']]))
$result[$entity['DISCOUNT_ID']] = [];
$result[$entity['DISCOUNT_ID']][] = $entity;
}
}
unset($entity, $entityIterator);
}
unset($row, $discountRows);
}
}
return $result;
}
}