Folk\Entities\SimpleCrud

Complexity

Total Complexity

20

Size/Duplication

Total Lines	120
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	2

Importance

Changes	3
Bugs	1	Features	1

9 Methods

Rating	Name	Duplication	Size	Complexity
A	getLabel()	0	4	1
	getDatabase()	0	1	?
C	getQuery()	0	33	7
A	search()	0	12	4
A	create()	0	6	1
A	read()	0	8	2
A	update()	0	6	1
A	delete()	0	6	1
A	getFirstField()	0	10	3

<?php

namespace Folk\Entities;

use Folk\SearchQuery;
use SimpleCrud\SimpleCrud as SimpleCrudDatabase;

abstract class SimpleCrud extends AbstractEntity implements EntityInterface
{
    protected $searchFields;

    abstract protected function getDatabase();

    protected function getQuery(SearchQuery $search = null, &$page = null)
    {
        $database = $this->getDatabase();
        $entity = $database->get($this->name);

        if ($search === null) {
            return $entity->select()->orderBy('id DESC');
        }

        $page = $search->getPage() ?: 1;

        $query = $entity->select()
            ->orderBy("`{$entity->name}`.`id` DESC")
            ->offset(($page * 50) - 50)
            ->limit(50);

        if ($this->searchFields === null) {
            $this->searchFields = [$this->getFirstField()];
        }

        foreach ($search->getWords() as $k => $word) {
            foreach ($this->searchFields as $field) {
                $query->where("`{$entity->name}`.`{$field}` LIKE :w{$k}", [":w{$k}" => "%{$word}%"]);
            }
        }

        foreach ($search->getConditions() as $name => $value) {
            $related = $database->get($name)->select()->by('id', $value)->all();
            $query->relatedWith($related);
        }

        return $query;
    }

    /**
     * {@inheritdoc}
     */
    public function search(SearchQuery $search = null)
    {
        $query = $this->getQuery($search, $page);

        $result = $query->all()->toArray(true);

        if ($search && (count($result) === 50 || $page > 1)) {
            $search->setPage($page);
        }

        return $result;
    }

    /**
     * {@inheritdoc}
     */
    public function create(array $data)
    {
        $entity = $this->getDatabase()->get($this->name);

        return $entity->create($data)->save(false, true)->id;
    }

    /**
     * {@inheritdoc}
     */
    public function read($id)
    {
        $entity = $this->getDatabase()->get($this->name);

        $row = $entity[$id];

        return $row ? $row->toArray() : null;
    }

    /**
     * {@inheritdoc}
     */
    public function update($id, array $data)
    {
        $entity = $this->getDatabase()->get($this->name);

        return $entity[$id]->set($data)->save(false, true)->toArray();
    }

    /**
     * {@inheritdoc}
     */
    public function delete($id)
    {
        $entity = $this->getDatabase()->get($this->name);

        unset($entity[$id]);
    }

    /**
     * {@inheritdoc}
     */
    public function getLabel($id, array $data)
    {
        return "{$id} - ".$data[$this->getFirstField()];
    }

    /**
     * {@inheritdoc}
     */
    protected function getFirstField()
    {
        $entity = $this->getDatabase()->get($this->name);

        foreach (array_keys($entity->fields) as $key) {
            if ($key !== 'id') {
                return $key;
            }
        }
    }
}