model.php

<?php
namespace Bitrix\Report\VisualConstructor\Internal;
 
use Bitrix\Main\ArgumentException;
use Bitrix\Main\Entity\Query\Filter\ConditionTree;
use Bitrix\Main\NotImplementedException;
use Bitrix\Main\Type\DateTime;
use Bitrix\Report\VisualConstructor\Config\Common;
use Bitrix\Report\VisualConstructor\Entity\DashboardRow;
use Bitrix\Report\VisualConstructor\Helper\Util;
use Bitrix\Report\VisualConstructor\Internal\Error\IErrorable;
 
abstract class Model implements IErrorable
{
    const ATTRIBUTE_SLICE_DELIMITER = '__';
    protected $id;
    protected $createdAt;
    protected $updatedAt;
    protected $errors;
    private $deletedEntities = array();
    private $currentDbState = array();
    //private $lazyAttributes;
 
    public function __construct()
    {
        $this->createdAt = new DateTime();
        $this->updatedAt = new DateTime();
    }
 
    public static function getTableClassName()
    {
        throw new NotImplementedException;
    }
 
 
    public static function getMapAttributes()
    {
        return array(
            'ID' => 'id',
            'CREATED_DATE' => 'createdAt',
            'UPDATED_DATE' => 'updatedAt'
        );
    }
 
    public static function getMapReferenceAttributes()
    {
        return array();
    }
 
 
    public function save()
    {
 
        $referenceMapAttributes = static::getMapReferenceAttributes();
 
        foreach ($referenceMapAttributes as $referenceAttributeName => $assoc)
        {
            if (!empty($this->{$referenceAttributeName}))
            {
                switch ($assoc['type'])
                {
                    case Common::MANY_TO_ONE:
                        $this->saveManyToOneReference($this->{$referenceAttributeName}, $assoc);
                        break;
                    case Common::ONE_TO_ONE:
                        //TODO:
                        break;
                }
            }
        }
 
        $ormFields = $this->getConvertedMapAttributesToOrmFields();
        if (!$ormFields['ID'])
        {
            $addResult = $this->add($ormFields);
            $ownerId = $addResult->getId();
            $this->setId($ownerId);
        }
        else
        {
            $ownerId = $ormFields['ID'];
            $changedAttributes = $this->getChangedOrmAttributes($ormFields);
            if ($changedAttributes)
            {
                $this->update(array('ID' => $ownerId), $changedAttributes);
            }
            if (!empty($this->deletedEntities))
            {
                $this->deleteReference($this->deletedEntities);
            }
        }
 
 
 
 
        foreach ($referenceMapAttributes as $referenceAttributeName => $assoc)
        {
            if (!empty($this->{$referenceAttributeName}))
            {
                switch ($assoc['type'])
                {
                    case Common::ONE_TO_MANY:
                        $this->saveOneToManyReferences($this->{$referenceAttributeName}, $assoc, $ownerId);
                        break;
                    case Common::MANY_TO_MANY:
                        $this->saveManyToManyReferences($this->{$referenceAttributeName}, $assoc, $ownerId);
                        break;
                }
            }
        }
 
        return $ownerId;
    }
 
    private function saveOneToManyReferences($references, $assoc, $ownerEntityId)
    {
        foreach ($references as $key => $reference)
        {
            if ($reference instanceof $assoc['targetEntity'])
            {
                $mapReferenceAttributes = $reference::getMapReferenceAttributes();
                $reference->{$mapReferenceAttributes[$assoc['mappedBy']]['join']['field'][0]} = $ownerEntityId;
                $reference->save();
            }
 
        }
    }
 
    private function saveManyToManyReferences($references, $assoc, $ownerEntityId)
    {
        foreach ($references as $key => $reference)
        {
            if ($reference instanceof $assoc['targetEntity'])
            {
                $isReferenceNew = !(boolean)$reference->getId();
                $referenceId = $reference->save();
                if ($isReferenceNew)
                {
                    $column = array_values($assoc['join']['column']);
                    $column = $column[0];
                    $inverseColumn = array_values($assoc['join']['inverseColumn']);
                    $inverseColumn = $inverseColumn[0];
                    $connectData = array(
                        $column[1] => $ownerEntityId,
                        $inverseColumn[1] => $referenceId,
                    );
                    $ormTableClassName = $assoc['join']['tableClassName'];
                    $ormTableClassName::add($connectData);
                }
            }
        }
    }
 
    private function saveManyToOneReference($reference, $assoc)
    {
        if ($reference instanceof $assoc['targetEntity'])
        {
            $reference = clone $reference;
            $reference->{$assoc['inversedBy']} = null;
            $reference->save();
            $this->{$assoc['join']['field'][0]} = $reference->getId();
        }
    }
 
 
 
    private function getConvertedMapAttributesToOrmFields()
    {
        $result = array();
        $fieldsMap = static::getMapAttributes();
        foreach ($fieldsMap as $ormFieldName => $objectProperty)
        {
            $result[$ormFieldName] = $this->{$objectProperty};
        }
        return $result;
    }
 
 
    private function add(array $data)
    {
        $tableClassName = static::getTableClassName();
        $resultData = $tableClassName::add($data);
        $this->currentDbState = $resultData->getData();
        return $resultData;
    }
 
    private function getChangedOrmAttributes($newEntityAttributes)
    {
 
        $oldEntityAttributes = $this->getCurrentDbState();
        unset($oldEntityAttributes['CREATED_DATE']);
        unset($oldEntityAttributes['UPDATED_DATE']);
        unset($newEntityAttributes['CREATED_DATE']);
        unset($newEntityAttributes['UPDATED_DATE']);
        $result = array();
        foreach ($oldEntityAttributes as $key => $value)
        {
            if ($newEntityAttributes[$key] != $value)
            {
                $result[$key] = $newEntityAttributes[$key];
            }
        }
 
        return $result;
    }
 
    private function update($primary, array $data)
    {
        $tableClassName = static::getTableClassName();
        $data['UPDATED_DATE'] = new DateTime();
        unset($data['ID']);
        $resultData = $tableClassName::update($primary, $data);
 
        foreach ($resultData->getData() as $key => $value)
        {
            $this->currentDbState[$key] = $value;
        }
        return $resultData;
    }
 
 
    public static function getClassName()
    {
        return get_called_class();
    }
 
 
    public static function load($filter, array $with = array(), $order = array())
    {
        $models = static::getModelList(array(
            'select' => array('*'),
            'filter' => $filter,
            'with' => $with,
            'order' => $order
        ));
        return array_shift($models);
    }
 
    protected static function getModelList(array $parameters)
    {
        $modelList = array();
        $query = static::getList($parameters);
        while ($row = $query->fetch())
        {
            if (!$modelList[$row['ID']])
            {
                $model = static::buildFromArray($row);
            }
            else
            {
                $model = static::buildFromArray($row, $modelList[$row['ID']]);
            }
            if ($model->id)
            {
                $modelList[$model->id] = $model;
            }
        }
 
        return $modelList;
    }
 
    protected static function getList(array $parameters)
    {
        $tableClass = static::getTableClassName();
        return $tableClass::getList(static::prepareGetListParameters($parameters));
    }
 
    protected static function buildFromArray(array $attributes, $parentEntity = null)
    {
        $model = new static;
        return $model->setAttributes($attributes, $parentEntity);
    }
 
    private function setAttributes(array $attributes, $parentEntity)
    {
        foreach ($attributes as $key => $value)
        {
            if ($value === null)
            {
                unset($attributes[$key]);
            }
        }
        if (!$parentEntity)
        {
            $mapAttributes = static::getMapAttributes();
            foreach ($attributes as $key => $value)
            {
                if (!empty($mapAttributes[$key]))
                {
                    $this->{$mapAttributes[$key]} = $value;
                    $this->currentDbState[$key] = $value;
                    unset($attributes[$key]);
                }
            }
            $parentEntity = $this;
        }
 
        if (empty($attributes))
        {
            return $parentEntity;
        }
 
        $subEntitiesMapAttributes = static::getMapReferenceAttributes();
        $subEntitiesKeys = array_keys($subEntitiesMapAttributes);
 
 
        $subEntityAttributes = array();
        $loadedSubEntitiesKeys = array();
        foreach ($attributes as $key => $value)
        {
            $delimiter = self::ATTRIBUTE_SLICE_DELIMITER;
            $selectedAttributeParts = explode($delimiter, $key);
            if (count($selectedAttributeParts) == 2 && in_array($selectedAttributeParts[0], $subEntitiesKeys))
            {
                $loadedSubEntitiesKeys[$selectedAttributeParts[0]] = $selectedAttributeParts[0];
                $subEntityAttributes[$selectedAttributeParts[0]][$selectedAttributeParts[1]] = $value;
            }
            elseif (count($selectedAttributeParts) >= 2)
            {
                $nestedEntityParentKey = array_shift($selectedAttributeParts);
                $nestedElementKey = implode(self::ATTRIBUTE_SLICE_DELIMITER, $selectedAttributeParts);
                $subEntityAttributes[$nestedEntityParentKey][$nestedElementKey] = $value;
            }
        }
 
        foreach ($subEntityAttributes as $key => $validAttributes)
        {
            if (!empty($subEntitiesMapAttributes[$key]))
            {
                $targetEntityClass = $subEntitiesMapAttributes[$key]['targetEntity'];
                if ($subEntitiesMapAttributes[$key]['type'] != Common::MANY_TO_ONE)
                {
                    if (!isset($parentEntity->{$key}[$validAttributes['ID']]))
                    {
                        $subEntity = $targetEntityClass::buildFromArray($validAttributes);
 
                        $nestedEntityReferenceMap = $subEntity::getMapReferenceAttributes();
 
 
                        if ($subEntitiesMapAttributes[$key]['type'] == Common::ONE_TO_MANY)
                        {
                            if (!empty($nestedEntityReferenceMap[$subEntitiesMapAttributes[$key]['mappedBy']]))
                            {
                                $subEntity->{$subEntitiesMapAttributes[$key]['mappedBy']} = $parentEntity;
                            }
                        }
                        $parentEntity->{$key}[$subEntity->id] = $subEntity;
                    }
                    else
                    {
                        $targetEntityClass::buildFromArray($validAttributes, $parentEntity->{$key}[$validAttributes['ID']]);
                    }
                }
                else
                {
                    $subEntity = $targetEntityClass::buildFromArray($validAttributes);
                    $parentEntity->{$key} = $subEntity;
                }
 
            }
        }
 
 
        return $parentEntity;
    }
 
    protected static function prepareGetListParameters(array $parameters)
    {
        if (!empty($parameters['with']))
        {
            if (!is_array($parameters['with']))
            {
                throw new ArgumentException('"with" must be array');
            }
            if (!isset($parameters['select']))
            {
                $parameters['select'] = array('*');
            }
            elseif (!in_array('*', $parameters['select']) && !in_array('ID', $parameters['select']))
            {
                $parameters['select'][] = 'ID';
            }
            $parameters['select'] = array_merge($parameters['select'], static::buildOrmSelectForReference($parameters['with']));
        }
 
        unset($parameters['with']);
        return $parameters;
    }
 
    protected static function buildOrmSelectForReference(array $with)
    {
        $select = array();
        $referenceAttributes = static::getMapReferenceAttributes();
        foreach ($with as $referenceKey)
        {
            $testNesting = explode('.', $referenceKey);
            $nestedReferenceAttributes = $referenceAttributes;
            $prefix = '';
            $fromKeyNamePrefix = '';
            foreach ($testNesting as $reference)
            {
                if (!empty($nestedReferenceAttributes[$reference]))
                {
                    $prefix = $prefix . $reference . self::ATTRIBUTE_SLICE_DELIMITER;
                    switch ($nestedReferenceAttributes[$reference]['type'])
                    {
                        case Common::ONE_TO_MANY:
                            $targetEntity = $nestedReferenceAttributes[$reference]['targetEntity'];
                            $targetOrmTable = $targetEntity::getTableClassName();
                            $fromKeyNamePrefix = !empty($fromKeyNamePrefix) ? $fromKeyNamePrefix . '.' : '';
                            $select[$prefix] = $fromKeyNamePrefix.$targetOrmTable::getClassName().':'.mb_strtoupper($nestedReferenceAttributes[$reference]['mappedBy']);
                            $fromKeyNamePrefix .= $targetOrmTable::getClassName().':'.mb_strtoupper($nestedReferenceAttributes[$reference]['mappedBy']);
                            $nestedReferenceAttributes = $targetEntity::getMapReferenceAttributes();
                            break;
                        case Common::MANY_TO_MANY:
                            $fromKeyName = array_keys($nestedReferenceAttributes[$reference]['join']['column']);
                            $fromKeyName = $fromKeyName[0];
                            $fromKeyNamePrefix = !empty($fromKeyNamePrefix) ? $fromKeyNamePrefix . '.' : '';
                            $toKeyName = array_keys($nestedReferenceAttributes[$reference]['join']['inverseColumn']);
                            $toKeyName = $toKeyName[0];
                            $select[$prefix] = $fromKeyNamePrefix . $nestedReferenceAttributes[$reference]['join']['tableClassName']
                                . ':'
                                . $fromKeyName
                                . '.'
                                . $toKeyName;
                            $targetEntity = $nestedReferenceAttributes[$reference]['targetEntity'];
                            $nestedReferenceAttributes = $targetEntity::getMapReferenceAttributes();
                            break;
                        case Common::MANY_TO_ONE:
                            $fromKeyNamePrefix = !empty($fromKeyNamePrefix) ? $fromKeyNamePrefix . '.' : '';
                            $select[$prefix] = $fromKeyNamePrefix.mb_strtoupper($reference);
                            $fromKeyNamePrefix .= mb_strtoupper($reference);
                            break;
 
                    }
                }
                else
                {
                    throw new ArgumentException("Reference with name:" . $reference . ' not define in reference map');
                }
            }
        }
        return $select;
    }
 
    public function delete()
    {
        $ownerId = $this->getId();
        $referenceAttributesMap = static::getMapReferenceAttributes();
 
        foreach ($referenceAttributesMap as $referenceKey => $referenceAttributes)
        {
            if (!empty($referenceAttributes['options']['deleteSkip']))
            {
                continue;
            }
 
            if (!$this->{$referenceKey})
            {
                $this->loadAttribute($referenceKey);
            }
 
 
            if ($this->{$referenceKey})
            {
                switch ($referenceAttributes['type'])
                {
                    case Common::ONE_TO_MANY:
                        $this->deleteOneToManyReferences($this->{$referenceKey});
                        break;
                    case Common::MANY_TO_MANY:
                        $this->deleteManyToManyReferences($this->{$referenceKey}, $referenceAttributes, $ownerId);
                        break;
                    case Common::MANY_TO_ONE:
                        $this->deleteManyToOneReference($this->{$referenceKey}, $referenceAttributes, $ownerId);
                        break;
                    case Common::ONE_TO_ONE:
                        //TODO
                        break;
                }
            }
 
        }
        $entityTableClass = static::getTableClassName();
        $deleteEntity = $entityTableClass::delete($ownerId);
        if ($deleteEntity->isSuccess())
        {
            return true;
        }
        else
        {
            $this->errors[] = $deleteEntity->getErrors();
            return null;
        }
    }
 
    private function deleteOneToManyReferences($referenceEntities)
    {
        foreach ($referenceEntities as $referenceEntity)
        {
            $referenceEntity->delete();
        }
    }
 
    private function deleteManyToManyReferences($referenceEntities, $assoc, $ownerId)
    {
        $connectColumn = array_shift($assoc['join']['column']);
        $connectInverseColumn = array_shift($assoc['join']['inverseColumn']);
        foreach ($referenceEntities as $referenceEntity)
        {
            $connectPrimaryKey = array();
            $connectTableClass = $assoc['join']['tableClassName'];
            $connectPrimaryKey[$connectColumn[1]] = $ownerId;
            $connectPrimaryKey[$connectInverseColumn[1]] = $referenceEntity->getId();;
            $connectTableClass::delete($connectPrimaryKey);
            $referenceEntity->delete();
        }
    }
 
    private function deleteManyToOneReference(&$referenceEntity, $assoc, $ownerId)
    {
        if ($referenceEntity  instanceof $assoc['targetEntity'])
        {
            unset($referenceEntity->{$assoc['inversedBy']}[$ownerId]);
        }
    }
 
    public function getId()
    {
        return $this->id;
    }
 
    public function setId($id)
    {
        $this->id = $id;
    }
 
    public function getCreatedAt()
    {
        return $this->createdAt;
    }
 
    public function setCreatedAt(DateTime $createdAt)
    {
        $this->createdAt = $createdAt;
    }
 
    public function getUpdatedAt()
    {
        return $this->updatedAt;
    }
 
    public function setUpdatedAt(DateTime $updatedAt)
    {
        $this->updatedAt = $updatedAt;
    }
 
    public static function loadById($id)
    {
        $entity = static::load(array('ID' => $id));
        return $entity;
    }
 
    public function loadAttribute($attributeName)
    {
        if (property_exists($this, $attributeName) && $this->{$attributeName} == null)
        {
            $entity = static::load(array('ID' => $this->getId()), array($attributeName));
            $this->{$attributeName} = $entity->{$attributeName};
        }
    }
 
 
    public function __call($name , array $arguments)
    {
        $isDeleteReferenceCall = preg_match_all('/^delete(\w+)/', $name, $deleteCallNameParts);
        if ($isDeleteReferenceCall)
        {
            $referenceName = $deleteCallNameParts[1][0];
            $referenceName = mb_strtolower($referenceName);
            $referenceMapAttributes = $this::getMapReferenceAttributes();
            if (!empty($referenceMapAttributes[$referenceName]))
            {
                $entities = !empty($arguments[0]) ? $arguments[0] : array();
                if (!is_array($entities))
                {
                    $entities = array(
                        $entities
                    );
                }
 
                foreach ($entities as $entity)
                {
                    $this->deletedEntities[$referenceName][$entity->getId()] = $entity;
                    unset($this->{$referenceName}[$entity->getId()]);
                }
            }
        }
 
        $isAddReferenceCall = preg_match_all('/^add(\w+)/', $name, $addCallNameParts);
        if ($isAddReferenceCall)
        {
            $referenceName = $addCallNameParts[1][0];
            $referenceName = mb_strtolower($referenceName);
            $referenceMapAttributes = $this::getMapReferenceAttributes();
            if (!empty($referenceMapAttributes[$referenceName]))
            {
                $entities = !empty($arguments[0]) ? $arguments[0] : array();
                if (!is_array($entities))
                {
                    $entities = array(
                        $entities
                    );
                }
 
                foreach ($entities as $entity)
                {
                    $this->{$referenceName}[] = $entity;
                }
            }
        }
 
    }
 
    private function deleteReference($deletedReferenceEntities)
    {
        foreach ($deletedReferenceEntities as $referenceName => $referenceEntities)
        {
            $map = $this::getMapReferenceAttributes();
            $map = $map[$referenceName];
            switch ($map['type'])
            {
                case Common::ONE_TO_MANY:
                    foreach ($referenceEntities as $referenceEntity)
                    {
                        $referenceEntity->delete();
                    }
                    break;
                case Common::MANY_TO_MANY:
                    $connectColumn = array_shift($map['join']['column']);
                    $connectInverseColumn = array_shift($map['join']['inverseColumn']);
 
                    foreach ($referenceEntities as $referenceEntity)
                    {
                        $connectPrimaryKey = array();
                        $connectTableClass = $map['join']['tableClassName'];
                        $connectPrimaryKey[$connectColumn[1]] = $this->getId();
                        $connectPrimaryKey[$connectInverseColumn[1]] = $referenceEntity->getId();
                        $connectTableClass::delete($connectPrimaryKey);
                    }
                    break;
                case Common::ONE_TO_ONE:
                    //TODO
                    break;
                case Common::MANY_TO_ONE:
                    //TODO
                    break;
            }
        }
 
 
    }
 
    public function getErrors()
    {
        return $this->errors;
    }
 
    public function getCurrentDbState()
    {
        return $this->currentDbState;
    }
 
 
    public static function factoryWithHorizontalCells($cellCount = 1)
    {
        $row = new DashboardRow();
        $row->setGId(Util::generateUserUniqueId());
        $map = [
            'type' => 'cell-container',
            'orientation' => 'horizontal',
            'elements' => []
        ];
        for ($i = 0; $i < $cellCount; $i++)
        {
            $cellId = 'cell_' . randString(4);
            $map['elements'][] = [
                'type' => 'cell',
                'id' => $cellId
            ];
        }
        $row->setLayoutMap($map);
 
        return $row;
    }
 
}