blitze\sitemaker\model\mapper\blocks

Complexity

Total Complexity

6

Size/Duplication

Total Lines	62
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	2

Test Coverage

Coverage

100%

Importance

Changes

0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	find_sql()	0	6	2
A	delete()	0	15	2
A	insert()	0	6	1
A	move_blocks_down()	0	10	1

<?php
/**
 *
 * @package sitemaker
 * @copyright (c) 2015 Daniel A. (blitze)
 * @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2
 *
 */

namespace blitze\sitemaker\model\mapper;

use blitze\sitemaker\model\base_mapper;

class blocks extends base_mapper
{
	/** @var string */
	protected $entity_class = 'blitze\sitemaker\model\entity\block';

	/** @var string */
	protected $entity_pkey = 'bid';

	/**
	 * @param array $sql_where
	 * @return string
	 */
	protected function find_sql(array $sql_where)
	{
		return 'SELECT * FROM ' . $this->entity_table .
			((sizeof($sql_where)) ? ' WHERE ' . join(' AND ', $sql_where) : '') . '
			ORDER BY position, weight ASC';
	}

	/**
	 * @param array|\blitze\sitemaker\model\entity\block $condition
	 */
	public function delete($condition)
	{
		parent::delete($condition);

		// move blocks up for position
		if ($condition instanceof $this->entity_class)
		{
			$this->db->sql_query('UPDATE ' . $this->entity_table . '
				SET weight = weight - 1
				WHERE weight > ' . (int) $condition->get_weight() . '
					AND style = ' . (int) $condition->get_style() . '
					AND route_id = ' . (int) $condition->get_route_id() . "
					AND position = '" . $this->db->sql_escape($condition->get_position()) . "'");
		}
	}

	/**
	 * {@inheritdoc}
	 */
	protected function insert(\blitze\sitemaker\model\entity_interface $entity)
	{
		$this->move_blocks_down($entity);

		return parent::insert($entity);
	}

	/**
	 * @param \blitze\sitemaker\model\entity_interface $entity
	 */
	protected function move_blocks_down(\blitze\sitemaker\model\entity_interface $entity)
	{
		/** @type \blitze\sitemaker\model\entity\block $entity */
		$sql = 'UPDATE ' . $this->entity_table . '
			SET weight = weight + 1
			WHERE weight >= ' . (int) $entity->get_weight() . '
				AND route_id = ' . (int) $entity->get_route_id() . '
				AND style = ' . (int) $entity->get_style();
		$this->db->sql_query($sql);
	}
}