Menu\Mapper\MenuMapper

Complexity

Total Complexity

11

Size/Duplication

Total Lines	70
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	3

Importance

Changes

0

6 Methods

Rating	Name	Duplication	Size	Complexity
A	setDbAdapter()	0	4	1
B	selectAll()	0	27	6
A	insertMenuItem()	0	6	1
A	updateMenuItem()	0	6	1
A	get()	0	9	1
A	forSelect()	0	8	1

<?php

declare(strict_types=1);

namespace Menu\Mapper;

use Zend\Db\Adapter\Adapter;
use Zend\Db\Adapter\AdapterAwareInterface;
use Zend\Db\TableGateway\AbstractTableGateway;

class MenuMapper extends AbstractTableGateway implements AdapterAwareInterface
{
    protected $table = 'menu';

    public function setDbAdapter(Adapter $adapter)
    {
        $this->adapter = $adapter;
    }

    public function selectAll($isActive = null, $filter = [])
    {
        $select = $this->getSql()->select()
            ->join(
                'category',
                'menu.category_uuid = category.category_uuid',
                ['category_name' => 'name', 'category_slug' => 'slug'],
                'left'
            )->join('page', 'page.page_uuid = menu.page_uuid', ['page_id', 'page_slug' => 'slug'], 'left')
            ->order(['order_no' => 'asc']);

        if ($isActive !== null) {
            $select->where(['menu.is_active' => $isActive]);
        }

        if ($filter) {

The expression $filter of type array is implicitly converted to a boolean; are you sure this is intended? If so, consider using ! empty($expr) instead to make it clear that you intend to check for an array without elements.

            if (isset($filter['is_in_header'])) {
                $select->where(['is_in_header' => $filter['is_in_header']]);
            } elseif (isset($filter['is_in_footer'])) {
                $select->where(['is_in_footer' => $filter['is_in_footer']]);
            } elseif (isset($filter['is_in_side'])) {
                $select->where(['is_in_side' => $filter['is_in_side']]);
            }
        }

        return $this->selectWith($select);
    }

    public function insertMenuItem($data)
    {
        $this->insert($data);

        return $this->getLastInsertValue();
    }

    public function updateMenuItem($data, $id)
    {
        $this->update($data, ['menu_id' => $id]);

        return $id;
    }

    public function get($id)
    {
        $select = $this->getSql()->select()
            ->join('page', 'page.page_uuid = menu.page_uuid', ['page_id'], 'left')
            ->join('category', 'category.category_uuid = menu.category_uuid', ['category_id'], 'left')
            ->where(['menu_id' => $id]);

        return $this->selectWith($select)->current();
    }

    public function forSelect()
    {
        $select = $this->getSql()->select()
            ->columns(['menu_id', 'title', 'is_active'])
            ->order(['is_active' => 'desc']);

        return $this->selectWith($select);
    }
}