measureratio.php

<?php
namespace Bitrix\Catalog;
 
use Bitrix\Main,
    Bitrix\Main\Localization\Loc;
 
Loc::loadMessages(__FILE__);
 
class MeasureRatioTable extends Main\Entity\DataManager
{
    public static function getTableName()
    {
        return 'b_catalog_measure_ratio';
    }
 
    public static function getMap()
    {
        return array(
            'ID' => new Main\Entity\IntegerField('ID', array(
                'primary' => true,
                'autocomplete' => true,
                'title' => Loc::getMessage('MEASURE_RATIO_ENTITY_ID_FIELD')
            )),
            'PRODUCT_ID' => new Main\Entity\IntegerField('PRODUCT_ID', array(
                'required' => true,
                'title' => Loc::getMessage('MEASURE_RATIO_ENTITY_PRODUCT_ID_FIELD')
            )),
            'RATIO' => new Main\Entity\FloatField('RATIO', array(
                'required' => true,
                'title' => Loc::getMessage('MEASURE_RATIO_ENTITY_RATIO_FIELD')
            )),
            'IS_DEFAULT' => new Main\Entity\BooleanField('IS_DEFAULT', array(
                'values' => array('N', 'Y'),
                'default_value' => 'N',
                'title' => Loc::getMessage('MEASURE_RATIO_ENTITY_IS_DEFAULT_FIELD')
            )),
            'PRODUCT' => new Main\Entity\ReferenceField(
                'PRODUCT',
                '\Bitrix\Catalog\Product',
                array('=this.PRODUCT_ID' => 'ref.ID'),
                array('join_type' => 'LEFT')
            ),
        );
    }
 
    public static function getCurrentRatio($product)
    {
        if (!is_array($product))
            $product = array($product);
        Main\Type\Collection::normalizeArrayValuesByInt($product, true);
        if (empty($product))
            return false;
 
        $result = array_fill_keys($product, 1);
        $ratioRows = array_chunk($product, 500);
        foreach ($ratioRows as $row)
        {
            $ratioIterator = self::getList(array(
                'select' => array('PRODUCT_ID', 'RATIO'),
                'filter' => array('@PRODUCT_ID' => $row, '=IS_DEFAULT' => 'Y')
            ));
            while ($ratio = $ratioIterator->fetch())
            {
                $ratio['PRODUCT_ID'] = (int)$ratio['PRODUCT_ID'];
                $ratioInt = (int)$ratio['RATIO'];
                $ratioFloat = (float)$ratio['RATIO'];
                $ratioResult  = ($ratioFloat > $ratioInt ? $ratioFloat : $ratioInt);
                if ($ratioResult < CATALOG_VALUE_EPSILON)
                    continue;
                $result[$ratio['PRODUCT_ID']] = $ratioResult;
            }
            unset($module, $moduleIterator);
        }
        unset($row, $ratioRows);
        return $result;
    }
 
    public static function deleteByProduct($id)
    {
        $id = (int)$id;
        if ($id <= 0)
            return;
 
        $conn = Main\Application::getConnection();
        $helper = $conn->getSqlHelper();
        $conn->queryExecute(
            'delete from '.$helper->quote(self::getTableName()).' where '.$helper->quote('PRODUCT_ID').' = '.$id
        );
        unset($helper, $conn);
    }
}