| Server IP : 37.220.80.31 / Your IP : 3.146.221.231 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\Currency;
Loc::loadMessages(__FILE__);
/**
* Class DiscountTable
*
* Fields:
* <ul>
* <li> ID int mandatory
* <li> XML_ID string(255) optional
* <li> SITE_ID string(2) mandatory
* <li> TYPE int mandatory
* <li> ACTIVE bool optional default 'Y'
* <li> ACTIVE_FROM datetime optional
* <li> ACTIVE_TO datetime optional
* <li> RENEWAL bool optional default 'N'
* <li> NAME string(255) optional
* <li> SORT int optional default 100
* <li> MAX_DISCOUNT double optional
* <li> VALUE_TYPE string(1) mandatory default 'P'
* <li> VALUE double mandatory default 0.0000
* <li> CURRENCY string(3) mandatory
* <li> TIMESTAMP_X datetime mandatory default 'CURRENT_TIMESTAMP'
* <li> COUNT_PERIOD string(1) mandatory default 'U'
* <li> COUNT_SIZE int mandatory
* <li> COUNT_TYPE bool optional default 'Y'
* <li> COUNT_FROM datetime optional
* <li> COUNT_TO datetime optional
* <li> ACTION_SIZE int mandatory
* <li> ACTION_TYPE bool optional default 'Y'
* <li> MODIFIED_BY int optional
* <li> DATE_CREATE datetime optional
* <li> CREATED_BY int optional
* <li> PRIORITY int optional default 1
* <li> LAST_DISCOUNT bool optional default 'Y'
* <li> VERSION int optional default 1
* <li> NOTES string(255) optional
* <li> CONDITIONS string optional
* <li> UNPACK string optional
* <li> USE_COUPONS bool optional default 'N'
* <li> CREATED_BY_USER reference to {@link \Bitrix\Main\UserTable}
* <li> MODIFIED_BY_USER reference to {@link \Bitrix\Main\UserTable}
* <li> RESTRICTION reference to {@link \Bitrix\Catalog\DiscountRestriction}
* </ul>
*
* @package Bitrix\Catalog
*
* DO NOT WRITE ANYTHING BELOW THIS
*
* <<< ORMENTITYANNOTATION
* @method static EO_Discount_Query query()
* @method static EO_Discount_Result getByPrimary($primary, array $parameters = array())
* @method static EO_Discount_Result getById($id)
* @method static EO_Discount_Result getList(array $parameters = array())
* @method static EO_Discount_Entity getEntity()
* @method static \Bitrix\Catalog\EO_Discount createObject($setDefaultValues = true)
* @method static \Bitrix\Catalog\EO_Discount_Collection createCollection()
* @method static \Bitrix\Catalog\EO_Discount wakeUpObject($row)
* @method static \Bitrix\Catalog\EO_Discount_Collection wakeUpCollection($rows)
*/
class DiscountTable extends Main\Entity\DataManager
{
const TYPE_DISCOUNT = 0;
const TYPE_DISCOUNT_SAVE = 1;
const VALUE_TYPE_PERCENT = 'P';
const VALUE_TYPE_FIX = 'F';
const VALUE_TYPE_SALE = 'S';
const COUNT_PERIOD_TYPE_ALL = 'U';
const COUNT_PERIOD_TYPE_INTERVAL = 'D';
const COUNT_PERIOD_TYPE_PERIOD = 'P';
const COUNT_TYPE_SIZE_DAY = 'D';
const COUNT_TYPE_SIZE_MONTH ='M';
const COUNT_TYPE_SIZE_YEAR = 'Y';
const ACTION_PERIOD_TYPE_ALL = 'U';
const ACTION_PERIOD_TYPE_INTERVAL = 'D';
const ACTION_PERIOD_TYPE_PERIOD = 'P';
const ACTION_TYPE_SIZE_DAY = 'D';
const ACTION_TYPE_SIZE_MONTH ='M';
const ACTION_TYPE_SIZE_YEAR = 'Y';
const ACTUAL_VERSION = 2;
const OLD_VERSION = 1;
/**
* Returns DB table name for entity.
*
* @return string
*/
public static function getTableName()
{
return 'b_catalog_discount';
}
/**
* Returns entity map definition.
*
* @return array
*/
public static function getMap()
{
return array(
'ID' => new Main\Entity\IntegerField('ID', array(
'primary' => true,
'autocomplete' => true,
'title' => Loc::getMessage('DISCOUNT_ENTITY_ID_FIELD')
)),
'XML_ID' => new Main\Entity\StringField('XML_ID', array(
'validation' => array(__CLASS__, 'validateXmlId'),
'title' => Loc::getMessage('DISCOUNT_ENTITY_XML_ID_FIELD')
)),
'SITE_ID' => new Main\Entity\StringField('SITE_ID', array(
'required' => true,
'validation' => array(__CLASS__, 'validateSiteId'),
'title' => Loc::getMessage('DISCOUNT_ENTITY_SITE_ID_FIELD')
)),
'TYPE' => new Main\Entity\IntegerField('TYPE', array(
'required' => true,
'default_value' => self::TYPE_DISCOUNT,
'validation' => array(__CLASS__, 'validateType'),
'title' => Loc::getMessage('DISCOUNT_ENTITY_TYPE_FIELD')
)),
'ACTIVE' => new Main\Entity\BooleanField('ACTIVE', array(
'values' => array('N', 'Y'),
'default_value' => 'Y',
'title' => Loc::getMessage('DISCOUNT_ENTITY_ACTIVE_FIELD')
)),
'ACTIVE_FROM' => new Main\Entity\DatetimeField('ACTIVE_FROM', array(
'default_value' => null,
'title' => Loc::getMessage('DISCOUNT_ENTITY_ACTIVE_FROM_FIELD')
)),
'ACTIVE_TO' => new Main\Entity\DatetimeField('ACTIVE_TO', array(
'default_value' => null,
'title' => Loc::getMessage('DISCOUNT_ENTITY_ACTIVE_TO_FIELD')
)),
'RENEWAL' => new Main\Entity\BooleanField('RENEWAL', array(
'values' => array('N', 'Y'),
'default_value' => 'N',
'title' => Loc::getMessage('DISCOUNT_ENTITY_RENEWAL_FIELD')
)),
'NAME' => new Main\Entity\StringField('NAME', array(
'required' => true,
'validation' => array(__CLASS__, 'validateName'),
'title' => Loc::getMessage('DISCOUNT_ENTITY_NAME_FIELD')
)),
'SORT' => new Main\Entity\IntegerField('SORT', array(
'title' => Loc::getMessage('DISCOUNT_ENTITY_SORT_FIELD')
)),
'MAX_DISCOUNT' => new Main\Entity\FloatField('MAX_DISCOUNT', array(
'title' => Loc::getMessage('DISCOUNT_ENTITY_MAX_DISCOUNT_FIELD')
)),
'VALUE_TYPE' => new Main\Entity\EnumField('VALUE_TYPE', array(
'required' => true,
'values' => array(self::VALUE_TYPE_PERCENT, self::VALUE_TYPE_FIX, self::VALUE_TYPE_SALE),
'default_value' => self::VALUE_TYPE_PERCENT,
'title' => Loc::getMessage('DISCOUNT_ENTITY_VALUE_TYPE_FIELD')
)),
'VALUE' => new Main\Entity\FloatField('VALUE', array(
'required' => true,
'title' => Loc::getMessage('DISCOUNT_ENTITY_VALUE_FIELD')
)),
'CURRENCY' => new Main\Entity\StringField('CURRENCY', array(
'required' => true,
'validation' => array(__CLASS__, 'validateCurrency'),
'title' => Loc::getMessage('DISCOUNT_ENTITY_CURRENCY_FIELD')
)),
'TIMESTAMP_X' => new Main\Entity\DatetimeField('TIMESTAMP_X', array(
'required' => true,
'default_value' => function()
{
return new Main\Type\DateTime();
},
'title' => Loc::getMessage('DISCOUNT_ENTITY_TIMESTAMP_X_FIELD')
)),
'COUNT_PERIOD' => new Main\Entity\EnumField('COUNT_PERIOD', array(
'values' => array(self::COUNT_PERIOD_TYPE_ALL, self::COUNT_PERIOD_TYPE_INTERVAL, self::COUNT_PERIOD_TYPE_PERIOD),
'default_value' => self::COUNT_PERIOD_TYPE_ALL
)),
'COUNT_SIZE' => new Main\Entity\IntegerField('COUNT_SIZE', array(
'default_value' => 0
)),
'COUNT_TYPE' => new Main\Entity\EnumField('COUNT_TYPE', array(
'values' => array(self::COUNT_TYPE_SIZE_DAY, self::COUNT_TYPE_SIZE_MONTH, self::COUNT_TYPE_SIZE_YEAR),
'default_value' => self::COUNT_TYPE_SIZE_YEAR
)),
'COUNT_FROM' => new Main\Entity\DatetimeField('COUNT_FROM', array(
'default_value' => null
)),
'COUNT_TO' => new Main\Entity\DatetimeField('COUNT_TO', array(
'default_value' => null
)),
'ACTION_SIZE' => new Main\Entity\IntegerField('ACTION_SIZE', array(
'default_value' => 0
)),
'ACTION_TYPE' => new Main\Entity\EnumField('ACTION_TYPE', array(
'values' => array(self::ACTION_TYPE_SIZE_DAY, self::ACTION_TYPE_SIZE_MONTH, self::ACTION_TYPE_SIZE_YEAR),
'default_value' => self::ACTION_TYPE_SIZE_YEAR
)),
'MODIFIED_BY' => new Main\Entity\IntegerField('MODIFIED_BY', array(
'title' => Loc::getMessage('DISCOUNT_ENTITY_MODIFIED_BY_FIELD')
)),
'DATE_CREATE' => new Main\Entity\DatetimeField('DATE_CREATE', array(
'default_value' => null,
'title' => Loc::getMessage('DISCOUNT_ENTITY_DATE_CREATE_FIELD')
)),
'CREATED_BY' => new Main\Entity\IntegerField('CREATED_BY', array(
'title' => Loc::getMessage('DISCOUNT_ENTITY_CREATED_BY_FIELD')
)),
'PRIORITY' => new Main\Entity\IntegerField('PRIORITY', array(
'default_value' => 1,
'title' => Loc::getMessage('DISCOUNT_ENTITY_PRIORITY_FIELD')
)),
'LAST_DISCOUNT' => new Main\Entity\BooleanField('LAST_DISCOUNT', array(
'values' => array('N', 'Y'),
'default_value' => 'Y',
'title' => Loc::getMessage('DISCOUNT_ENTITY_LAST_DISCOUNT_FIELD')
)),
'VERSION' => new Main\Entity\EnumField('VERSION', array(
'values' => array(self::OLD_VERSION, self::ACTUAL_VERSION),
'default_value' => self::ACTUAL_VERSION
)),
'NOTES' => new Main\Entity\StringField('NOTES', array(
'validation' => array(__CLASS__, 'validateNotes'),
'title' => Loc::getMessage('DISCOUNT_ENTITY_NOTES_FIELD')
)),
'CONDITIONS' => new Main\Entity\TextField('CONDITIONS', array()),
'CONDITIONS_LIST' => new Main\Entity\TextField('CONDITIONS_LIST', array(
'serialized' => true,
'column_name' => 'CONDITIONS',
'title' => Loc::getMessage('DISCOUNT_ENTITY_CONDITIONS_LIST_FIELD')
)),
'UNPACK' => new Main\Entity\TextField('UNPACK', array()),
'USE_COUPONS' => new Main\Entity\BooleanField('USE_COUPONS', array(
'values' => array('N', 'Y'),
'default_value' => 'N',
'title' => Loc::getMessage('DISCOUNT_ENTITY_USE_COUPONS_FIELD')
)),
'SALE_ID' => new Main\Entity\IntegerField('SALE_ID'),
'CREATED_BY_USER' => new Main\Entity\ReferenceField(
'CREATED_BY_USER',
'\Bitrix\Main\User',
array('=this.CREATED_BY' => 'ref.ID')
),
'MODIFIED_BY_USER' => new Main\Entity\ReferenceField(
'MODIFIED_BY_USER',
'\Bitrix\Main\User',
array('=this.MODIFIED_BY' => 'ref.ID')
),
'SALE_DISCOUNT' => new Main\Entity\ReferenceField(
'SALE_DISCOUNT',
'Bitrix\Sale\Internals\DiscountTable',
array('=this.SALE_ID' => 'ref.ID')
)
);
}
/**
* Returns validators for XML_ID field.
*
* @return array
*/
public static function validateXmlId()
{
return array(
new Main\Entity\Validator\Length(null, 255),
);
}
/**
* Returns validators for SITE_ID field.
*
* @return array
*/
public static function validateSiteId()
{
return array(
new Main\Entity\Validator\Length(null, 2),
);
}
/**
* Returns validators for TYPE field.
*
* @return array
*/
public static function validateType()
{
return array(
array(__CLASS__, 'checkType')
);
}
/**
* Returns validators for NAME field.
*
* @return array
*/
public static function validateName()
{
return array(
new Main\Entity\Validator\Length(null, 255),
);
}
/**
* Returns validators for CURRENCY field.
*
* @return array
*/
public static function validateCurrency()
{
return array(
new Main\Entity\Validator\Length(null, 3),
);
}
/**
* Returns validators for NOTES field.
*
* @return array
*/
public static function validateNotes()
{
return array(
new Main\Entity\Validator\Length(null, 255),
);
}
/**
* Check TYPE field.
*
* @param int $value Current field value.
* @param int|array $primary Primary key.
* @param array $row Current data.
* @param Main\Entity\Field $field Field object.
* @return bool|string
*/
public static function checkType($value, $primary, array $row, Main\Entity\Field $field)
{
if (
$value == self::TYPE_DISCOUNT
|| $value == self::TYPE_DISCOUNT_SAVE
)
{
return true;
}
return Loc::getMessage('DISCOUNT_ENTITY_VALIDATOR_TYPE');
}
/**
* Add discount.
*
* @param array $data Discount data.
* @return Main\Entity\AddResult
*/
public static function add(array $data)
{
$result = new Main\Entity\AddResult();
$result->addError(new Main\Entity\EntityError(
Loc::getMessage('CATALOG_DISCOUNT_ENTITY_MESS_ADD_BLOCKED')
));
return $result;
}
/**
* Updates discount by primary key.
*
* @param mixed $primary Discount primary key.
* @param array $data Discount data.
* @return Main\Entity\UpdateResult
*/
public static function update($primary, array $data)
{
$result = new Main\Entity\UpdateResult();
$result->addError(new Main\Entity\EntityError(
Loc::getMessage('CATALOG_DISCOUNT_ENTITY_MESS_UPDATE_BLOCKED')
));
return $result;
}
/**
* Deletes discount by primary key.
*
* @param mixed $primary Discount primary key.
* @return Main\Entity\DeleteResult
*/
public static function delete($primary)
{
$result = new Main\Entity\DeleteResult();
$result->addError(new Main\Entity\EntityError(
Loc::getMessage('CATALOG_DISCOUNT_ENTITY_MESS_DELETE_BLOCKED')
));
return $result;
}
/**
* Convert discount data to other currency (sale currency).
*
* @param array &$discount Discout data.
* @param string $currency New currency.
* @return void
*/
public static function convertCurrency(&$discount, $currency)
{
$currency = Currency\CurrencyManager::checkCurrencyID($currency);
if ($currency === false || empty($discount) || !is_array($discount))
return;
if (!isset($discount['VALUE_TYPE']) || !isset($discount['CURRENCY']) || $discount['CURRENCY'] == $currency)
return;
switch ($discount['VALUE_TYPE'])
{
case self::VALUE_TYPE_FIX:
case self::VALUE_TYPE_SALE:
$discount['VALUE'] = round(
\CCurrencyRates::convertCurrency($discount['VALUE'], $discount['CURRENCY'], $currency)
);
$discount['CURRENCY'] = $currency;
break;
case self::VALUE_TYPE_PERCENT:
if ($discount['MAX_DISCOUNT'] > 0)
$discount['MAX_DISCOUNT'] = round(
\CCurrencyRates::convertCurrency($discount['MAX_DISCOUNT'], $discount['CURRENCY'], $currency)
);
$discount['CURRENCY'] = $currency;
break;
}
}
/**
* Set exist coupons flag for discount list.
*
* @param array|int $discountList Discount ids for update.
* @param string $use Value for update use coupons.
* @return void
*/
public static function setUseCoupons($discountList, $use)
{
if (!is_array($discountList))
$discountList = array($discountList);
$use = (string)$use;
if ($use !== 'Y' && $use !== 'N')
return;
Main\Type\Collection::normalizeArrayValuesByInt($discountList);
if (empty($discountList))
return;
$conn = Main\Application::getConnection();
$helper = $conn->getSqlHelper();
$conn->queryExecute(
'update '.$helper->quote(self::getTableName()).
' set '.$helper->quote('USE_COUPONS').' = \''.$use.'\' where '.
$helper->quote('ID').' in ('.implode(',', $discountList).')'
);
unset($helper, $conn);
}
}