| Server IP : 37.220.80.31 / Your IP : 3.147.78.151 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/sale/lib/internals/ |
Upload File : |
<?php
/**
* Bitrix Framework
* @package bitrix
* @subpackage sale
* @copyright 2001-2016 Bitrix
*/
namespace Bitrix\Sale\Internals;
use Bitrix\Main;
/**
* Class BuyerStatisticTable
*
* DO NOT WRITE ANYTHING BELOW THIS
*
* <<< ORMENTITYANNOTATION
* @method static EO_BuyerStatistic_Query query()
* @method static EO_BuyerStatistic_Result getByPrimary($primary, array $parameters = array())
* @method static EO_BuyerStatistic_Result getById($id)
* @method static EO_BuyerStatistic_Result getList(array $parameters = array())
* @method static EO_BuyerStatistic_Entity getEntity()
* @method static \Bitrix\Sale\Internals\EO_BuyerStatistic createObject($setDefaultValues = true)
* @method static \Bitrix\Sale\Internals\EO_BuyerStatistic_Collection createCollection()
* @method static \Bitrix\Sale\Internals\EO_BuyerStatistic wakeUpObject($row)
* @method static \Bitrix\Sale\Internals\EO_BuyerStatistic_Collection wakeUpCollection($rows)
*/
class BuyerStatisticTable extends Main\Entity\DataManager
{
/**
* Returns DB table name for entity.
*
* @return string
*/
public static function getTableName()
{
return 'b_sale_buyer_stat';
}
/**
* Returns entity map definition.
*
* @return array
*/
public static function getMap()
{
return array(
new Main\Entity\IntegerField(
'ID',
array(
'autocomplete' => true,
'primary' => true,
)
),
new Main\Entity\StringField(
'LID',
array(
'required' => true,
)
),
new Main\Entity\StringField(
'CURRENCY',
array(
'required' => true,
'size' => 3
)
),
new Main\Entity\StringField(
'USER_ID',
array(
'required' => true,
)
),
new Main\Entity\ReferenceField(
'USER',
'\Bitrix\Main\User',
array('=this.USER_ID' => 'ref.ID'),
array('join_type' => 'INNER')
),
new Main\Entity\DatetimeField('LAST_ORDER_DATE'),
new Main\Entity\FloatField(
'SUM_PAID',
array(
'default_value' => '0.0000'
)
),
new Main\Entity\IntegerField('COUNT_FULL_PAID_ORDER'),
new Main\Entity\IntegerField('COUNT_PART_PAID_ORDER'),
new Main\Entity\ReferenceField(
'GROUP',
'\Bitrix\Main\UserGroup',
array('=this.USER_ID' => 'ref.USER_ID'),
array('join_type' => 'INNER')
),
);
}
/**
* Renew buyer statistic by recalculation of order table and archive order table.
*/
public static function recalculate()
{
$connection = Main\Application::getConnection();
$type = $connection->getType();
if ($type == "mysql")
{
$sqlDelete = "TRUNCATE TABLE ".self::getTableName();
$connection->query($sqlDelete);
$sqlInsertInSelect = "
INSERT INTO ".self::getTableName()." (USER_ID, LID, CURRENCY, LAST_ORDER_DATE, COUNT_FULL_PAID_ORDER, COUNT_PART_PAID_ORDER, SUM_PAID)
SELECT UN.USER_ID, UN.LID, UN.CURRENCY, MAX(UN.DATE_INSERT), SUM(CASE WHEN UN.PAYED = 'Y' THEN 1 ELSE 0 END), SUM(CASE WHEN NOT UN.SUM_PAID = 0 THEN 1 ELSE 0 END), SUM(UN.SUM_PAID)
FROM (
(SELECT USER_ID, LID, CURRENCY, DATE_INSERT, PAYED, SUM_PAID FROM b_sale_order)
UNION
(SELECT USER_ID, LID, CURRENCY, DATE_INSERT, PAYED, SUM_PAID FROM b_sale_order_archive)
) UN
GROUP BY UN.USER_ID, UN.CURRENCY, UN.LID
ORDER BY UN.USER_ID";
$connection->query($sqlInsertInSelect);
}
}
}