<?php
/**
 * Pimcore
 *
 * This source file is available under two different licenses:
 * - GNU General Public License version 3 (GPLv3)
 * - Pimcore Enterprise License (PEL)
 * Full copyright and license information is available in
 * LICENSE.md which is distributed with this source code.
 *
 * @copyright  Copyright (c) Pimcore GmbH (http://www.pimcore.org)
 * @license    http://www.pimcore.org/license     GPLv3 and PEL
 */

namespace Pimcore\Bundle\AdminBundle\Controller\Admin;

use Pimcore\Bundle\AdminBundle\Controller\AdminController;
use Pimcore\Db;
use Pimcore\Model\DataObject;
use Pimcore\Model\DataObject\Classificationstore;
use Symfony\Component\HttpFoundation\JsonResponse;
use Symfony\Component\HttpFoundation\Request;
use Symfony\Component\Routing\Annotation\Route;

/**
 * @Route("/classificationstore")
 */
class ClassificationstoreController extends AdminController
{
    /**
     * Delete collection with the group-relations
     *
     * @Route("/delete-collection")
     *
     * @param Request $request
     *
     * @return JsonResponse
     */
    public function deleteCollectionAction(Request $request)
    {
        $id = $request->get('id');

        $configRelations = new Classificationstore\CollectionGroupRelation\Listing();
        $configRelations->setCondition('colId = ?', $id);
        $list = $configRelations->load();
        foreach ($list as $item) {
            $item->delete();
        }

        $config = Classificationstore\CollectionConfig::getById($id);
        $config->delete();

        return $this->json(['success' => true]);
    }

    /**
     * @Route("/delete-collection-relation")
     *
     * @param Request $request
     *
     * @return JsonResponse
     */
    public function deleteCollectionRelationAction(Request $request)
    {
        $colId = $request->get('colId');
        $groupId = $request->get('groupId');

        $config = new Classificationstore\CollectionGroupRelation();
        $config->setColId($colId);
        $config->setGroupId($groupId);

        $config->delete();

        return $this->json(['success' => true]);
    }

    /**
     * @Route("/delete-relation")
     *
     * @param Request $request
     *
     * @return JsonResponse
     */
    public function deleteRelationAction(Request $request)
    {
        $keyId = $request->get('keyId');
        $groupId = $request->get('groupId');

        $config = new Classificationstore\KeyGroupRelation();
        $config->setKeyId($keyId);
        $config->setGroupId($groupId);

        $config->delete();

        return $this->json(['success' => true]);
    }

    /**
     * @Route("/delete-group")
     *
     * @param Request $request
     *
     * @return JsonResponse
     */
    public function deleteGroupAction(Request $request)
    {
        $id = $request->get('id');

        $config = Classificationstore\GroupConfig::getById($id);
        $config->delete();

        return $this->json(['success' => true]);
    }

    /**
     * @Route("/create-group")
     *
     * @param Request $request
     *
     * @return JsonResponse
     */
    public function createGroupAction(Request $request)
    {
        $name = $request->get('name');
        $storeId = $request->get('storeId');
        $alreadyExist = false;
        $config = Classificationstore\GroupConfig::getByName($name, $storeId);

        if (!$config) {
            $config = new Classificationstore\GroupConfig();
            $config->setStoreId($storeId);
            $config->setName($name);
            $config->save();
        }

        return $this->json(['success' => !$alreadyExist, 'id' => $config->getName()]);
    }

    /**
     * @Route("/create-store")
     *
     * @param Request $request
     *
     * @return JsonResponse
     *
     * @throws \Exception
     */
    public function createStoreAction(Request $request)
    {
        $name = $request->get('name');

        $config = Classificationstore\StoreConfig::getByName($name);

        if (!$config) {
            $config = new Classificationstore\StoreConfig();
            $config->setName($name);
            $config->save();
        } else {
            throw new \Exception('Store with the given name exists');
        }

        return $this->json(['success' => true, 'storeId' => $config->getId()]);
    }

    /**
     * @Route("/create-collection")
     *
     * @param Request $request
     *
     * @return JsonResponse
     */
    public function createCollectionAction(Request $request)
    {
        $name = $request->get('name');
        $storeId = $request->get('storeId');
        $alreadyExist = false;
        $config = Classificationstore\CollectionConfig::getByName($name, $storeId);

        if (!$config) {
            $config = new Classificationstore\CollectionConfig();
            $config->setName($name);
            $config->setStoreId($storeId);
            $config->save();
        }

        return $this->json(['success' => !$alreadyExist, 'id' => $config->getName()]);
    }

    /**
     * @Route("/grouptree-get-childs-by-id")
     *
     * @param Request $request
     *
     * @return JsonResponse
     */
    public function grouptreeGetChildsByIdAction(Request $request)
    {
        $nodeId = $request->get('node');

        $list = new DataObject\Classificationstore\GroupConfig\Listing();
        $list->setCondition('parentId = ?', $nodeId);
        $list = $list->load();

        $contents = [];

        /** @var $item DataObject\Classificationstore\GroupConfig */
        foreach ($list as $item) {
            $hasChilds = $item->hasChildren();

            $itemConfig = [
                'id' => $item->getId(),
                'text' => 'text 1-' . $item->getName(),
                'leaf' => !$hasChilds,
                'iconCls' => $item->getLevel() < 2 ? 'pimcore_icon_Classificationstore_icon_group' : 'pimcore_icon_Classificationstore_icon_subgroup'
            ];

            $contents[] = $itemConfig;
        }

        return $this->json($contents);
    }

    /**
     * @Route("/getgroup")
     *
     * @param Request $request
     *
     * @return JsonResponse
     */
    public function getgroupAction(Request $request)
    {
        $id = $request->get('id');
        $config = Classificationstore\GroupConfig::getByName($id);

        $data = [
            'storeId' => $config->getStoreId(),
            'id' => $id,
            'name' => $config->getName(),
            'description' => $config->getDescription(),
            'sorter' => (int) $config->getSorter()
        ];

        return $this->json($data);
    }

    /**
     * @Route("/collections")
     *
     * @param Request $request
     *
     * @return JsonResponse
     */
    public function collectionsAction(Request $request)
    {
        if ($request->get('data')) {
            $dataParam = $request->get('data');
            $data = $this->decodeJson($dataParam);

            $id = $data['id'];
            $config = Classificationstore\CollectionConfig::getById($id);

            foreach ($data as $key => $value) {
                if ($key != 'id') {
                    $setter = 'set' . $key;
                    $config->$setter($value);
                }
            }

            $config->save();

            return $this->json(['success' => true, 'data' => $config]);
        } else {
            $start = 0;
            $limit = $request->get('limit') ? $request->get('limit') : 15;

            $orderKey = 'name';
            $order = 'ASC';

            if ($request->get('dir')) {
                $order = $request->get('dir');
            }

            if ($request->get('limit')) {
                $limit = $request->get('limit');
            }
            if ($request->get('start')) {
                $start = $request->get('start');
            }

            $allParams = array_merge($request->request->all(), $request->query->all());
            $sortingSettings = \Pimcore\Bundle\AdminBundle\Helper\QueryParams::extractSortingSettings($allParams);
            if ($sortingSettings['orderKey'] && $sortingSettings['order']) {
                $orderKey = $sortingSettings['orderKey'];
                $order = $sortingSettings['order'];
            }

            if ($request->get('overrideSort') == 'true') {
                $orderKey = 'id';
                $order = 'DESC';
            }

            $allowedCollectionIds = [];
            if ($request->get('oid')) {
                $object = DataObject\Concrete::getById($request->get('oid'));
                $class = $object->getClass();
                $fd = $class->getFieldDefinition($request->get('fieldname'));
                $allowedGroupIds = $fd->getAllowedGroupIds();

                if ($allowedGroupIds) {
                    $db = \Pimcore\Db::get();
                    $query = 'select * from classificationstore_collectionrelations where groupId in (' . implode(',', $allowedGroupIds) .')';
                    $relationList = $db->fetchAll($query);

                    if (is_array($relationList)) {
                        foreach ($relationList as $item) {
                            $allowedCollectionIds[] = $item['colId'];
                        }
                    }
                }
            }

            $list = new Classificationstore\CollectionConfig\Listing();

            $list->setLimit($limit);
            $list->setOffset($start);
            $list->setOrder($order);
            $list->setOrderKey($orderKey);

            $conditionParts = [];
            $db = Db::get();

            $searchfilter = $request->get('searchfilter');
            if ($searchfilter) {
                $conditionParts[] = '(name LIKE ' . $db->quote('%' . $searchfilter . '%') . ' OR description LIKE ' . $db->quote('%'. $searchfilter . '%') . ')';
            }

            $conditionParts[] = ' (storeId = ' . $request->get('storeId') . ')';

            if ($request->get('filter')) {
                $filterString = $request->get('filter');
                $filters = json_decode($filterString);

                foreach ($filters as $f) {
                    $conditionParts[]= $db->quoteIdentifier($f->property) . ' LIKE ' . $db->quote('%' . $f->value . '%');
                }
            }

            if ($allowedCollectionIds) {
                $conditionParts[]= ' id in (' . implode(',', $allowedCollectionIds) . ')';
            }

            $condition = implode(' AND ', $conditionParts);

            $list->setCondition($condition);

            $list->load();
            $configList = $list->getList();

            $rootElement = [];

            $data = [];
            foreach ($configList as $config) {
                $name = $config->getName();
                if (!$name) {
                    $name = 'EMPTY';
                }
                $item = [
                    'storeId' => $config->getStoreId(),
                    'id' => $config->getId(),
                    'name' => $name,
                    'description' => $config->getDescription()
                ];
                if ($config->getCreationDate()) {
                    $item['creationDate'] = $config->getCreationDate();
                }

                if ($config->getModificationDate()) {
                    $item['modificationDate'] = $config->getModificationDate();
                }

                $data[] = $item;
            }
            $rootElement['data'] = $data;
            $rootElement['success'] = true;
            $rootElement['total'] = $list->getTotalCount();

            return $this->json($rootElement);
        }
    }

    /**
     * @Route("/groups")
     *
     * @param Request $request
     *
     * @return JsonResponse
     */
    public function groupsAction(Request $request)
    {
        if ($request->get('data')) {
            $dataParam = $request->get('data');
            $data = $this->decodeJson($dataParam);

            $id = $data['id'];
            $config = Classificationstore\GroupConfig::getById($id);

            foreach ($data as $key => $value) {
                if ($key != 'id') {
                    $setter = 'set' . $key;
                    $config->$setter($value);
                }
            }

            $config->save();

            return $this->json(['success' => true, 'data' => $config]);
        } else {
            $start = 0;
            $limit = 15;
            $orderKey = 'name';
            $order = 'ASC';

            if ($request->get('dir')) {
                $order = $request->get('dir');
            }

            if ($request->get('sort')) {
                $orderKey = $request->get('sort');
            }

            if ($request->get('limit')) {
                $limit = $request->get('limit');
            }
            if ($request->get('start')) {
                $start = $request->get('start');
            }

            $allParams = array_merge($request->request->all(), $request->query->all());
            $sortingSettings = \Pimcore\Bundle\AdminBundle\Helper\QueryParams::extractSortingSettings($allParams);
            if ($sortingSettings['orderKey'] && $sortingSettings['order']) {
                $orderKey = $sortingSettings['orderKey'];
                $order = $sortingSettings['order'];
            }

            if ($request->get('overrideSort') == 'true') {
                $orderKey = 'id';
                $order = 'DESC';
            }

            $list = new Classificationstore\GroupConfig\Listing();

            $list->setLimit($limit);
            $list->setOffset($start);
            $list->setOrder($order);
            $list->setOrderKey($orderKey);

            $conditionParts = [];
            $db = Db::get();

            $searchfilter = $request->get('searchfilter');
            if ($searchfilter) {
                $conditionParts[] = '(name LIKE ' . $db->quote('%' . $searchfilter . '%') . ' OR description LIKE ' . $db->quote('%'. $searchfilter . '%') . ')';
            }

            if ($request->get('storeId')) {
                $conditionParts[] = '(storeId = ' . $request->get('storeId') . ')';
            }

            if ($request->get('filter')) {
                $filterString = $request->get('filter');
                $filters = json_decode($filterString);

                foreach ($filters as $f) {
                    $conditionParts[]= $db->quoteIdentifier($f->property) . ' LIKE ' . $db->quote('%' . $f->value . '%');
                }
            }

            if ($request->get('oid')) {
                $object = DataObject\Concrete::getById($request->get('oid'));
                $class = $object->getClass();
                $fd = $class->getFieldDefinition($request->get('fieldname'));
                $allowedGroupIds = $fd->getAllowedGroupIds();

                if ($allowedGroupIds) {
                    $conditionParts[]= 'ID in (' . implode(',', $allowedGroupIds) . ')';
                }
            }

            $condition = implode(' AND ', $conditionParts);
            $list->setCondition($condition);

            $list->load();
            $configList = $list->getList();

            $rootElement = [];

            $data = [];
            foreach ($configList as $config) {
                $name = $config->getName();
                if (!$name) {
                    $name = 'EMPTY';
                }
                $item = [
                    'storeId' => $config->getStoreId(),
                    'id' => $config->getId(),
                    'name' => $name,
                    'description' => $config->getDescription()
                ];
                if ($config->getCreationDate()) {
                    $item['creationDate'] = $config->getCreationDate();
                }

                if ($config->getModificationDate()) {
                    $item['modificationDate'] = $config->getModificationDate();
                }

                $data[] = $item;
            }
            $rootElement['data'] = $data;
            $rootElement['success'] = true;
            $rootElement['total'] = $list->getTotalCount();

            return $this->json($rootElement);
        }
    }

    /**
     * @Route("/collection-relations")
     *
     * @param Request $request
     *
     * @return JsonResponse
     */
    public function collectionRelationsAction(Request $request)
    {
        if (($request->get('xaction') == 'update' || $request->get('xaction') == 'create') && $request->get('data')) {
            $dataParam = $request->get('data');
            $data = $this->decodeJson($dataParam);

            if (count($data) == count($data, 1)) {
                $data = [$data];
            }

            foreach ($data as &$row) {
                $colId = $row['colId'];
                $groupId = $row['groupId'];
                $sorter = $row['sorter'];

                $config = new Classificationstore\CollectionGroupRelation();
                $config->setGroupId($groupId);
                $config->setColId($colId);
                $config->setSorter((int) $sorter);

                $config->save();

                $row['id'] = $config->getColId() . '-' . $config->getGroupId();
            }

            return $this->json(['success' => true, 'data' => $data]);
        } else {
            $mapping = ['groupName' => 'name', 'groupDescription' => 'description'];

            $start = 0;
            $limit = 15;
            $orderKey = 'sorter';
            $order = 'ASC';

            if ($request->get('dir')) {
                $order = $request->get('dir');
            }

            $allParams = array_merge($request->request->all(), $request->query->all());
            $sortingSettings = \Pimcore\Bundle\AdminBundle\Helper\QueryParams::extractSortingSettings($allParams);
            if ($sortingSettings['orderKey'] && $sortingSettings['order']) {
                $orderKey = $sortingSettings['orderKey'];
                $order = $sortingSettings['order'];
            }

            if ($request->get('overrideSort') == 'true') {
                $orderKey = 'id';
                $order = 'DESC';
            }

            if ($request->get('limit')) {
                $limit = $request->get('limit');
            }
            if ($request->get('start')) {
                $start = $request->get('start');
            }

            $list = new Classificationstore\CollectionGroupRelation\Listing();

            if ($limit > 0) {
                $list->setLimit($limit);
            }
            $list->setOffset($start);
            $list->setOrder($order);
            $list->setOrderKey($orderKey);

            if ($request->get('filter')) {
                $db = Db::get();
                $condition = '';
                $filterString = $request->get('filter');
                $filters = json_decode($filterString);

                $count = 0;

                foreach ($filters as $f) {
                    if ($count > 0) {
                        $condition .= ' AND ';
                    }
                    $count++;
                    $fieldname = $mapping[$f->field];
                    $condition .= $db->quoteIdentifier($fieldname) . ' LIKE ' . $db->quote('%' . $f->value . '%');
                }
            }

            $colId = $request->get('colId');
            if ($condition) {
                $condition = '( ' . $condition . ' ) AND';
            }
            $condition .= ' colId = ' . $list->quote($colId);

            $list->setCondition($condition);

            $listItems = $list->load();

            $rootElement = [];

            $data = [];
            foreach ($listItems as $config) {
                $item = [
                    'colId' => $config->getColId(),
                    'groupId' => $config->getGroupId(),
                    'groupName' => $config->getName(),
                    'groupDescription' => $config->getDescription(),
                    'id' => $config->getColId() . '-' . $config->getGroupId(),
                    'sorter' => (int) $config->getSorter()
                ];
                $data[] = $item;
            }
            $rootElement['data'] = $data;
            $rootElement['success'] = true;
            $rootElement['total'] = $list->getTotalCount();

            return $this->json($rootElement);
        }
    }

    /**
     * @Route("/list-stores")
     *
     * @param Request $request
     *
     * @return JsonResponse
     */
    public function listStoresAction(Request $request)
    {
        $list = new Classificationstore\StoreConfig\Listing();
        $list = $list->load();

        return $this->json($list);
    }

    /**
     * @Route("/search-relations")
     *
     * @param Request $request
     *
     * @return JsonResponse
     */
    public function searchRelationsAction(Request $request)
    {
        $db = Db::get();

        $storeId = $request->get('storeId');

        $mapping = [
            'groupName' => DataObject\Classificationstore\GroupConfig\Dao::TABLE_NAME_GROUPS .'.name',
            'keyName' => DataObject\Classificationstore\KeyConfig\Dao::TABLE_NAME_KEYS .'.name',
            'keyDescription' => DataObject\Classificationstore\KeyConfig\Dao::TABLE_NAME_KEYS. '.description'];

        $start = 0;
        $limit = 15;
        $orderKey = 'name';
        $order = 'ASC';

        if ($request->get('dir')) {
            $order = $request->get('dir');
        }

        $allParams = array_merge($request->request->all(), $request->query->all());
        $sortingSettings = \Pimcore\Bundle\AdminBundle\Helper\QueryParams::extractSortingSettings($allParams);
        if ($sortingSettings['orderKey'] && $sortingSettings['order']) {
            $orderKey = $sortingSettings['orderKey'];
            $order = $sortingSettings['order'];
        }

        if ($request->get('overrideSort') == 'true') {
            $orderKey = 'id';
            $order = 'DESC';
        }

        if ($request->get('limit')) {
            $limit = $request->get('limit');
        }
        if ($request->get('start')) {
            $start = $request->get('start');
        }

        $list = new Classificationstore\KeyGroupRelation\Listing();

        if ($limit > 0) {
            $list->setLimit($limit);
        }
        $list->setOffset($start);
        $list->setOrder($order);
        $list->setOrderKey($orderKey);

        $conditionParts = [];

        if ($request->get('filter')) {
            $db = Db::get();
            $filterString = $request->get('filter');
            $filters = json_decode($filterString);

            $count = 0;

            foreach ($filters as $f) {
                $count++;
                $fieldname = $mapping[$f->property];
                $conditionParts[]= $fieldname . ' LIKE ' . $db->quote('%' . $f->value . '%');
            }
        }

        $conditionParts[] = '  groupId IN (select id from classificationstore_groups where storeId = ' . $db->quote($storeId) . ')';

        $searchfilter = $request->get('searchfilter');
        if ($searchfilter) {
            $conditionParts[] = '('
                . Classificationstore\KeyConfig\Dao::TABLE_NAME_KEYS . '.name LIKE ' . $db->quote('%' . $searchfilter . '%')
                . ' OR ' . Classificationstore\GroupConfig\Dao::TABLE_NAME_GROUPS . '.name LIKE ' . $db->quote('%' . $searchfilter . '%')
                . ' OR ' . Classificationstore\KeyConfig\Dao::TABLE_NAME_KEYS . '.description LIKE ' . $db->quote('%' . $searchfilter . '%') . ')';
        }
        $condition = implode(' AND ', $conditionParts);
        $list->setCondition($condition);
        $list->setResolveGroupName(1);

        $listItems = $list->load();

        $rootElement = [];

        $data = [];
        foreach ($listItems as $config) {
            $item = [
                'keyId' => $config->getKeyId(),
                'groupId' => $config->getGroupId(),
                'keyName' => $config->getName(),
                'keyDescription' => $config->getDescription(),
                'id' => $config->getGroupId() . '-' . $config->getKeyId(),
                'sorter' => $config->getSorter()
            ];

            $groupConfig = Classificationstore\GroupConfig::getById($config->getGroupId());
            if ($groupConfig) {
                $item['groupName'] = $groupConfig->getName();
            }

            $data[] = $item;
        }
        $rootElement['data'] = $data;
        $rootElement['success'] = true;
        $rootElement['total'] = $list->getTotalCount();

        return $this->json($rootElement);
    }

    /**
     * @Route("/relations")
     *
     * @param Request $request
     *
     * @return JsonResponse
     */
    public function relationsAction(Request $request)
    {
        if (($request->get('xaction') == 'update' || $request->get('xaction') == 'create') && $request->get('data')) {
            $dataParam = $request->get('data');
            $data = $this->decodeJson($dataParam);

            $keyId = $data['keyId'];
            $groupId = $data['groupId'];
            $sorter = $data['sorter'];
            $mandatory = $data['mandatory'];

            $config = new Classificationstore\KeyGroupRelation();
            $config->setGroupId($groupId);
            $config->setKeyId($keyId);
            $config->setSorter($sorter);
            $config->setMandatory($mandatory);

            $config->save();
            $data['id'] = $config->getGroupId() . '-' . $config->getKeyId();

            return $this->json(['success' => true, 'data' => $data]);
        } else {
            $mapping = ['keyName' => 'name', 'keyDescription' => 'description'];

            $start = 0;
            $limit = 15;
            $orderKey = 'name';
            $order = 'ASC';

            if ($request->get('dir')) {
                $order = $request->get('dir');
            }

            $allParams = array_merge($request->request->all(), $request->query->all());
            $sortingSettings = \Pimcore\Bundle\AdminBundle\Helper\QueryParams::extractSortingSettings($allParams);
            if ($sortingSettings['orderKey'] && $sortingSettings['order']) {
                $orderKey = $sortingSettings['orderKey'];
                $order = $sortingSettings['order'];
            }

            if ($request->get('overrideSort') == 'true') {
                $orderKey = 'id';
                $order = 'DESC';
            }

            if ($request->get('limit')) {
                $limit = $request->get('limit');
            }
            if ($request->get('start')) {
                $start = $request->get('start');
            }

            $list = new Classificationstore\KeyGroupRelation\Listing();

            if ($limit > 0) {
                $list->setLimit($limit);
            }
            $list->setOffset($start);
            $list->setOrder($order);
            $list->setOrderKey($orderKey);

            if ($request->get('filter')) {
                $db = Db::get();
                $conditionParts = [];
                $filterString = $request->get('filter');
                $filters = json_decode($filterString);

                $count = 0;

                foreach ($filters as $f) {
                    $count++;
                    $fieldname = $mapping[$f->field];
                    $conditionParts[]= $db->quoteIdentifier($fieldname) . ' LIKE ' . $db->quote('%' . $f->value . '%');
                }
            }

            if (!$request->get('relationIds')) {
                $groupId = $request->get('groupId');
                $conditionParts[]= ' groupId = ' . $list->quote($groupId);
            }

            $relationIds = $request->get('relationIds');
            if ($relationIds) {
                $relationIds = json_decode($relationIds, true);
                $relationParts = [];
                foreach ($relationIds as $relationId) {
                    $keyId = $relationId['keyId'];
                    $groupId = $relationId['groupId'];
                    $relationParts[] = '(keyId = ' . $keyId . ' and groupId = ' . $groupId . ')';
                }
                $conditionParts[] = '(' . implode(' OR ', $relationParts) . ')';
            }

            $condition = implode(' AND ', $conditionParts);

            $list->setCondition($condition);

            $listItems = $list->load();

            $rootElement = [];

            $data = [];
            /** @var $config Classificationstore\KeyGroupRelation */
            foreach ($listItems as $config) {
                $type = $config->getType();
                $definition = json_decode($config->getDefinition());
                $definition = \Pimcore\Model\DataObject\Classificationstore\Service::getFieldDefinitionFromJson($definition, $type);

                $item = [
                    'keyId' => $config->getKeyId(),
                    'groupId' => $config->getGroupId(),
                    'keyName' => $config->getName(),
                    'keyDescription' => $config->getDescription(),
                    'id' => $config->getGroupId() . '-' . $config->getKeyId(),
                    'sorter' => (int) $config->getSorter(),
                    'layout' => $definition,
                    'mandatory' => $config->isMandatory()
                ];

                $data[] = $item;
            }
            $rootElement['data'] = $data;
            $rootElement['success'] = true;
            $rootElement['total'] = $list->getTotalCount();

            return $this->json($rootElement);
        }
    }

    /**
     * @Route("/add-collections")
     *
     * @param Request $request
     *
     * @return JsonResponse
     */
    public function addCollectionsAction(Request $request)
    {
        $ids = $this->decodeJson($request->get('collectionIds'));
        $oid = $request->get('oid');
        $object = DataObject\AbstractObject::getById($oid);
        $fieldname = $request->get('fieldname');

        if ($ids) {
            $db = \Pimcore\Db::get();
            $query = 'select * from classificationstore_groups g, classificationstore_collectionrelations c where colId IN (' . implode(',', $ids)
                . ') and g.id = c.groupId';

            $mappedData = [];
            $groupsData = $db->fetchAll($query);

            foreach ($groupsData as $groupData) {
                $mappedData[$groupData['id']] = $groupData;
            }

            $groupIdList = [];

            $allowedGroupIds = null;

            if ($request->get('oid')) {
                $object = DataObject\Concrete::getById($request->get('oid'));
                $class = $object->getClass();
                $fd = $class->getFieldDefinition($request->get('fieldname'));
                $allowedGroupIds = $fd->getAllowedGroupIds();
            }

            foreach ($groupsData as $groupItem) {
                $groupId = $groupItem['groupId'];
                if (!$allowedGroupIds || ($allowedGroupIds && in_array($groupId, $allowedGroupIds))) {
                    $groupIdList[] = $groupId;
                }
            }

            if ($groupIdList) {
                $groupList = new Classificationstore\GroupConfig\Listing();
                $groupCondition = 'id in (' . implode(',', $groupIdList) . ')';
                $groupList->setCondition($groupCondition);

                $groupList = $groupList->load();

                $keyCondition = 'groupId in (' . implode(',', $groupIdList) . ')';

                $keyList = new Classificationstore\KeyGroupRelation\Listing();
                $keyList->setCondition($keyCondition);
                $keyList->setOrderKey(['sorter', 'id']);
                $keyList->setOrder(['ASC', 'ASC']);
                $keyList = $keyList->load();

                foreach ($groupList as $groupData) {
                    $data[$groupData->getId()] = [
                        'name' => $groupData->getName(),
                        'id' => $groupData->getId(),
                        'description' => $groupData->getDescription(),
                        'keys' => [],
                        'collectionId' => $mappedData[$groupId]['colId']
                    ];
                }

                foreach ($keyList as $keyData) {
                    $groupId = $keyData->getGroupId();

                    $keyList = $data[$groupId]['keys'];
                    $type = $keyData->getType();
                    $definition = json_decode($keyData->getDefinition());
                    $definition = \Pimcore\Model\DataObject\Classificationstore\Service::getFieldDefinitionFromJson($definition, $type);

                    if (method_exists($definition, '__wakeup')) {
                        $definition->__wakeup();
                    }

                    $context['object'] = $object;
                    $context['class'] = $object ? $object->getClass() : null;
                    $context['ownerType'] = 'classificationstore';
                    $context['ownerName'] = $fieldname;
                    $context['keyId'] =  $keyData->getKeyId();
                    $context['groupId'] = $groupId;
                    $context['keyDefinition'] = $definition;
                    if (method_exists($definition, 'enrichLayoutDefinition')) {
                        $definition = $definition->enrichLayoutDefinition($object, $context);
                    }

                    $keyList[] = [
                        'name' => $keyData->getName(),
                        'id' => $keyData->getKeyId(),
                        'description' => $keyData->getDescription(),
                        'definition' => $definition
                    ];
                    $data[$groupId]['keys'] = $keyList;
                }
            }
        }

        return $this->json($data);
    }

    /**
     * @Route("/add-groups")
     *
     * @param Request $request
     *
     * @return JsonResponse
     */
    public function addGroupsAction(Request $request)
    {
        $ids = $this->decodeJson($request->get('groupIds'));
        $oid = $request->get('oid');
        $object = DataObject\AbstractObject::getById($oid);
        $fieldname = $request->get('fieldname');

        $keyCondition = 'groupId in (' . implode(',', $ids) . ')';

        $keyList = new Classificationstore\KeyGroupRelation\Listing();
        $keyList->setCondition($keyCondition);
        $keyList->setOrderKey(['sorter', 'id']);
        $keyList->setOrder(['ASC', 'ASC']);
        $keyList = $keyList->load();

        $groupCondition = 'id in (' . implode(',', $ids) . ')';

        $groupList = new Classificationstore\GroupConfig\Listing();
        $groupList->setCondition($groupCondition);
        $groupList->setOrder('ASC');
        $groupList->setOrderKey('id');
        $groupList = $groupList->load();

        $data = [];

        foreach ($groupList as $groupData) {
            $data[$groupData->getId()] = [
                'name' => $groupData->getName(),
                'id' => $groupData->getId(),
                'description' => $groupData->getDescription(),
                'keys' => []
            ];
        }

        foreach ($keyList as $keyData) {
            $groupId = $keyData->getGroupId();

            $keyList = $data[$groupId]['keys'];
            $type = $keyData->getType();
            $definition = json_decode($keyData->getDefinition());
            $definition = \Pimcore\Model\DataObject\Classificationstore\Service::getFieldDefinitionFromJson($definition, $type);

            if (method_exists($definition, '__wakeup')) {
                $definition->__wakeup();
            }

            $context['object'] = $object;
            $context['class'] = $object ? $object->getClass() : null;
            $context['ownerType'] = 'classificationstore';
            $context['ownerName'] = $fieldname;
            $context['keyId'] =  $keyData->getKeyId();
            $context['groupId'] = $groupId;
            $context['keyDefinition'] = $definition;
            if (method_exists($definition, 'enrichLayoutDefinition')) {
                $definition = $definition->enrichLayoutDefinition($object, $context);
            }

            $keyList[] = [
                'name' => $keyData->getName(),
                'id' => $keyData->getKeyId(),
                'description' => $keyData->getDescription(),
                'definition' => $definition
            ];
            $data[$groupId]['keys'] = $keyList;
        }

        return $this->json($data);
    }

    /**
     * @Route("/properties")
     *
     * @param Request $request
     *
     * @return JsonResponse
     */
    public function propertiesAction(Request $request)
    {
        if ($request->get('data')) {
            $dataParam = $request->get('data');
            $data = $this->decodeJson($dataParam);

            $id = $data['id'];
            $config = Classificationstore\KeyConfig::getById($id);

            foreach ($data as $key => $value) {
                if ($key != 'id') {
                    $setter = 'set' . $key;
                    if (method_exists($config, $setter)) {
                        $config->$setter($value);
                    }
                }
            }

            $config->save();
            $item = $this->getConfigItem($config);

            return $this->json(['success' => true, 'data' => $item]);
        } else {
            $storeId = $request->get('storeId');
            $frameName = $request->get('frameName');
            $db = \Pimcore\Db::get();

            $conditionParts = [];

            if ($frameName) {
                $keyCriteria = ' FALSE ';
                $frameConfig = Classificationstore\CollectionConfig::getByName($frameName, $storeId);
                if ($frameConfig) {
                    // get all keys within that collection / frame
                    $frameId = $frameConfig->getId();
                    $groupList = new Classificationstore\CollectionGroupRelation\Listing();
                    $groupList->setCondition('colId = ' . $db->quote($frameId));
                    $groupList = $groupList->load();
                    $groupIdList = [];
                    foreach ($groupList as $groupEntry) {
                        $groupIdList[] = $groupEntry->getGroupId();
                    }

                    if ($groupIdList) {
                        $keyIdList = new Classificationstore\KeyGroupRelation\Listing();
                        $keyIdList->setCondition('groupId in (' . implode(',', $groupIdList) . ')');
                        $keyIdList = $keyIdList->load();
                        if ($keyIdList) {
                            $keyIds = [];
                            /** @var $keyEntry Classificationstore\KeyGroupRelation */
                            foreach ($keyIdList as $keyEntry) {
                                $keyIds[] = $keyEntry->getKeyId();
                            }

                            if ($keyIds) {
                                $keyCriteria = ' id in (' . implode(',', $keyIds) . ')';
                            }
                        }
                    }
                }

                if ($keyCriteria) {
                    $conditionParts[] = $keyCriteria;
                }
            }

            $start = 0;
            $limit = 15;
            $orderKey = 'name';
            $order = 'ASC';

            if ($request->get('dir')) {
                $order = $request->get('dir');
            }

            $allParams = array_merge($request->request->all(), $request->query->all());
            $sortingSettings = \Pimcore\Bundle\AdminBundle\Helper\QueryParams::extractSortingSettings($allParams);
            if ($sortingSettings['orderKey'] && $sortingSettings['order']) {
                $orderKey = $sortingSettings['orderKey'];
                $order = $sortingSettings['order'];
            }

            if ($request->get('overrideSort') == 'true') {
                $orderKey = 'id';
                $order = 'DESC';
            }

            if ($request->get('limit')) {
                $limit = $request->get('limit');
            }
            if ($request->get('start')) {
                $start = $request->get('start');
            }

            $list = new Classificationstore\KeyConfig\Listing();

            if ($limit > 0) {
                $list->setLimit($limit);
            }
            $list->setOffset($start);
            $list->setOrder($order);
            $list->setOrderKey($orderKey);

            $searchfilter = $request->get('searchfilter');
            if ($searchfilter) {
                $conditionParts[] = '(name LIKE ' . $db->quote('%' . $searchfilter . '%') . ' OR description LIKE ' . $db->quote('%'. $searchfilter . '%') . ')';
            }

            if ($storeId) {
                $conditionParts[] = '(storeId = ' . $storeId . ')';
            }

            if ($request->get('filter')) {
                $filterString = $request->get('filter');
                $filters = json_decode($filterString);

                foreach ($filters as $f) {
                    $conditionParts[]= $db->quoteIdentifier($f->property) . ' LIKE ' . $db->quote('%' . $f->value . '%');
                }
            }
            $condition = implode(' AND ', $conditionParts);
            $list->setCondition($condition);

            if ($request->get('groupIds') || $request->get('keyIds')) {
                $db = Db::get();

                if ($request->get('groupIds')) {
                    $ids = $this->decodeJson($request->get('groupIds'));
                    $col = 'group';
                } else {
                    $ids = $this->decodeJson($request->get('keyIds'));
                    $col = 'id';
                }

                $condition = $db->quoteIdentifier($col) . ' IN (';
                $count = 0;
                foreach ($ids as $theId) {
                    if ($count > 0) {
                        $condition .= ',';
                    }
                    $condition .= $theId;
                    $count++;
                }

                $condition .= ')';
                $list->setCondition($condition);
            }

            $list->load();
            $configList = $list->getList();

            $rootElement = [];

            $data = [];
            foreach ($configList as $config) {
                $item = $this->getConfigItem($config);
                $data[] = $item;
            }
            $rootElement['data'] = $data;
            $rootElement['success'] = true;
            $rootElement['total'] = $list->getTotalCount();

            return $this->json($rootElement);
        }
    }

    /**
     * @param $config
     *
     * @return array
     */
    protected function getConfigItem($config)
    {
        $name = $config->getName();

        $groupDescription = null;
        $item = [
            'storeId' => $config->getStoreId(),
            'id' => $config->getId(),
            'name' => $name,
            'description' => $config->getDescription(),
            'type' => $config->getType() ? $config->getType() : 'input',
            'definition' => $config->getDefinition()
        ];

        if ($config->getDefinition()) {
            $definition = json_decode($config->getDefinition(), true);
            if ($definition) {
                $item['title'] = $definition['title'];
            }
        }

        if ($config->getCreationDate()) {
            $item['creationDate'] = $config->getCreationDate();
        }

        if ($config->getModificationDate()) {
            $item['modificationDate'] = $config->getModificationDate();
        }

        return $item;
    }

    /**
     * @Route("/add-property")
     *
     * @param Request $request
     *
     * @return JsonResponse
     */
    public function addPropertyAction(Request $request)
    {
        $name = $request->get('name');
        $alreadyExist = false;
        $storeId = $request->get('storeId');

        if (!$alreadyExist) {
            $definition = [
                'fieldtype' => 'input',
                'name' => $name,
                'title' => $name,
                'datatype' => 'data'
            ];
            $config = new Classificationstore\KeyConfig();
            $config->setName($name);
            $config->setTitle($name);
            $config->setType('input');
            $config->setStoreId($storeId);
            $config->setEnabled(1);
            $config->setDefinition(json_encode($definition));
            $config->save();
        }

        return $this->json(['success' => !$alreadyExist, 'id' => $config->getName()]);
    }

    /**
     * @Route("/delete-property")
     *
     * @param Request $request
     *
     * @return JsonResponse
     */
    public function deletePropertyAction(Request $request)
    {
        $id = $request->get('id');

        $config = Classificationstore\KeyConfig::getById($id);
        //        $config->delete();
        $config->setEnabled(false);
        $config->save();

        return $this->json(['success' => true]);
    }

    /**
     * @Route("/edit-store")
     *
     * @param Request $request
     *
     * @return JsonResponse
     *
     * @throws \Exception
     */
    public function editStoreAction(Request $request)
    {
        $id = $request->get('id');
        $data = json_decode($request->get('data'), true);

        $name = $data['name'];
        if (!$name) {
            throw new \Exception('Name must not be empty');
        }

        $description = $data['description'];

        $config = Classificationstore\StoreConfig::getByName($name);
        if ($config && $config->getId() != $id) {
            throw new \Exception('There is already a config with the same name');
        }

        $config = Classificationstore\StoreConfig::getById($id);

        if (!$config) {
            throw new \Exception('Configuration does not exist');
        }

        $config->setName($name);
        $config->setDescription($description);
        $config->save();

        return $this->json(['success' => true]);
    }

    /**
     * @Route("/storetree")
     *
     * @param Request $request
     *
     * @return JsonResponse
     */
    public function storetreeAction(Request $request)
    {
        $result = [];
        $list = new Classificationstore\StoreConfig\Listing();
        $list = $list->load();
        /** @var $item Classificationstore\StoreConfig */
        foreach ($list as $item) {
            $resultItem = [
                'id' => $item->getId(),
                'text' => $item->getName(),
                'expandable' => false,
                'leaf' => true,
                'expanded' => true,
                'description' => $item->getDescription(),
                'iconCls' => 'pimcore_icon_classificationstore'
            ];

            $resultItem['qtitle'] = 'ID: ' . $item->getId();

            if ($item->getDescription()) {
            }
            $resultItem['qtip'] = $item->getDescription() ? $item->getDescription() : ' ';
            $result[] = $resultItem;
        }

        return $this->json($result);
    }

    /**
     * @Route("/get-page")
     *
     * @param Request $request
     *
     * @return JsonResponse
     */
    public function getPageAction(Request $request)
    {
        $table = 'classificationstore_' . $request->get('table');
        $db = \Pimcore\Db::get();
        $id = $request->get('id');
        $storeId = $request->get('storeId');
        $pageSize = $request->get('pageSize');

        if ($request->get('sortKey')) {
            $sortKey = $request->get('sortKey');
            $sortDir = $request->get('sortDir');
        } else {
            $sortKey = 'name';
            $sortDir = 'ASC';
        }
        $sorter = ' order by `' . $sortKey .  '` ' . $sortDir;

        if ($table == 'keys') {
            $query = '
                select *, (item.pos - 1)/ ' . $pageSize . ' + 1  as page from (
                    select * from (
                        select @rownum := @rownum + 1 as pos,  id, name, `type`
                        from `' . $table . '`
                        where enabled = 1 and storeId = ' . $storeId . $sorter . '
                      ) all_rows) item where id = ' . $id . ';';
        } else {
            $query = '
            select *, (item.pos - 1)/ ' . $pageSize . ' + 1  as page from (
                select * from (
                    select @rownum := @rownum + 1 as pos,  id, name
                    from `' . $table . '`
                    where storeId = ' . $storeId . $sorter . '
                  ) all_rows) item where id = ' .  $id . ';';
        }

        $db->query('select @rownum := 0;');
        $result= $db->fetchAll($query);

        $page = (int) $result[0]['page'] ;

        return $this->json(['success' => true, 'page' => $page]);
    }
}
