ReferenceField::operatorE() - Code Metrics - Inspection of "Added the ability to filter by fields from the adv..." - YetiForceCompany/YetiForceCRM - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — developer ( 762b64...a1cff0 )

by Radosław

created 2023-04-04 13:10 UTC

ReferenceField::operatorE() A

↳ Parent: ReferenceField

Complexity

Conditions	2
Paths	2

Size

Total Lines	7
Code Lines	4

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
eloc	4
dl	0
loc	7
rs	10
c	1
b	0
f	0
cc	2
nc	2
nop	0

<?php
/**
 * Reference query inventory field file.
 *
 * @package UIType
 *
 * @copyright YetiForce S.A.
 * @license YetiForce Public License 5.0 (licenses/LicenseEN.txt or yetiforce.com)
 * @author Radosław Skrzypczak <[email protected]>
 */

declare(strict_types=1);

namespace App\Conditions\QueryFields\Inventory;

/**
 * Reference query inventory field class.
 */
class ReferenceField extends BaseField
{
	/**
	 * Get related column name.
	 *
	 * @return string[]
	 */
	public function getRelatedTableName(): array
	{
		return $this->getRelatedTables($this->fieldModel->getReferenceModules(), $this->fieldModel->getName());
		return $this->getRelatedTables($this->fieldModel->/** @scrutinizer ignore-call */ getReferenceModules(), $this->fieldModel->getName());
	}

	/**
	 * Get formatted column references from related records.
	 *
	 * @param array  $modules
	 * @param string $fieldName
	 *
	 * @return string[]
	 */
	public function getRelatedTables(array $modules, string $fieldName): array
	{
		$relatedTableName = [];
		if ($modules) {

			$moduleName = $this->queryGenerator->getModuleModel();
			$invTableName = $moduleName->getInventoryModel()->getDataTableName();
			$tableName = $moduleName->getBaseTableName();
			$tableIndex = $moduleName->getBaseTableIndex();
			$this->queryGenerator->addJoin(['LEFT JOIN', $invTableName, "{$tableName}.{$tableIndex} = {$invTableName}.crmid"]);
		}
		foreach ($modules as $moduleName) {
			$formattedTables = [];
			$entityFieldInfo = \App\Module::getEntityInfo($moduleName);
			$relatedModuleModel = \Vtiger_Module_Model::getInstance($moduleName);
			$relTableIndexes = $relatedModuleModel->getEntityInstance()->tab_name_index;
			foreach ($entityFieldInfo['fieldnameArr'] as $column) {
				if ($relField = $relatedModuleModel->getFieldByColumn($column)) {
					$referenceTable = $relField->getTableName() . $fieldName;
					$this->queryGenerator->addJoin(['LEFT JOIN',
						"{$relField->getTableName()} {$referenceTable}",
						"{$this->getColumnName()} = {$referenceTable}.{$relTableIndexes[$relField->getTableName()]}",
					]);
					$formattedTables[] = "{$referenceTable}.{$column}";
				}
			}
			$relatedTableName[$moduleName] = \count($formattedTables) > 1 ? new \yii\db\Expression('CONCAT(' . implode(",' ',", $formattedTables) . ')') : current($formattedTables);
		}
		return $relatedTableName;
	}

	/**
	 * Auto operator.
	 *
	 * @return array
	 */
	public function operatorA(): array
	{
		if (\App\Config::performance('SEARCH_REFERENCE_BY_AJAX')) {
			if (false === strpos($this->value, '##')) {
				return [$this->getColumnName() => $this->value];
			}
			$condition = ['or'];
			foreach (explode('##', $this->value) as $value) {
				$condition[] = [$this->getColumnName() => $value];
			}
			return $condition;
		}
		return parent::operatorA();
	}

	/**
	 * Equals operator.
	 *
	 * @return array
	 */
	public function operatorE(): array
	{
		$condition = ['or'];
		foreach ($this->getRelatedTableName() as $formattedName) {
			$condition[] = ['=', $formattedName, $this->getValue()];
		}
		return $condition;
	}

	/**
	 * Equals Id operator.
	 *
	 * @return array
	 */
	public function operatorEid()
	{
		return [$this->getColumnName() => $this->getValue()];
	}

	/**
	 * Not equal operator.
	 *
	 * @return array
	 */
	public function operatorN(): array
	{
		$condition = ['or'];
		foreach ($this->getRelatedTableName() as $formattedName) {
			$condition[] = ['<>', $formattedName, $this->getValue()];
		}
		return $condition;
	}

	/**
	 * Starts with operator.
	 *
	 * @return array
	 */
	public function operatorS()
	{
		$condition = ['or'];
		foreach ($this->getRelatedTableName() as $formattedName) {
			$condition[] = ['like', $formattedName, $this->getValue() . '%', false];
			$condition[] = ['like', $formattedName, /** @scrutinizer ignore-type */ $this->getValue() . '%', false];
		}
		return $condition;
	}

	/**
	 * Ends with operator.
	 *
	 * @return array
	 */
	public function operatorEw()
	{
		$condition = ['or'];
		foreach ($this->getRelatedTableName() as $formattedName) {
			$condition[] = ['like', $formattedName, '%' . $this->getValue(), false];
			$condition[] = ['like', $formattedName, '%' . /** @scrutinizer ignore-type */ $this->getValue(), false];
		}
		return $condition;
	}

	/**
	 * Contains operator.
	 *
	 * @return array
	 */
	public function operatorC(): array
	{
		$condition = ['or'];
		foreach ($this->getRelatedTableName() as $formattedName) {
			$condition[] = ['like', $formattedName, $this->getValue()];
		}
		return $condition;
	}

	/**
	 * Does not contain operator.
	 *
	 * @return array
	 */
	public function operatorK(): array
	{
		$condition = ['or'];
		foreach ($this->getRelatedTableName() as $formattedName) {
			$condition[] = ['not like', $formattedName, $this->getValue()];
		}
		return $condition;
	}

	/**
	 * Is empty operator.
	 *
	 * @return array
	 */
	public function operatorY(): array
	{
		return ['or',
			[$this->getColumnName() => null],
			['=', $this->getColumnName(), ''],
			['=', $this->getColumnName(), 0],
		];
	}

	/**
	 * Is not empty operator.
	 *
	 * @return array
	 */
	public function operatorNy(): array
	{
		return ['and',
			['not', [$this->getColumnName() => null]],
			['<>', $this->getColumnName(), ''],
			['<>', $this->getColumnName(), 0],
		];
	}

	/**
	 * Get order by.
	 *
	 * @param mixed $order
	 *
	 * @return array
	 */
	public function getOrderBy($order = false): array
	{
		$condition = [];
		if ($order && 'DESC' === strtoupper($order)) {
			foreach ($this->getRelatedTableName() as $formattedName) {
				$condition[(string) $formattedName] = SORT_DESC;
			}
		} else {
			foreach ($this->getRelatedTableName() as $formattedName) {
				$condition[(string) $formattedName] = SORT_ASC;
			}
		}
		return $condition;
	}
}


YetiForceCompany / YetiForceCRM

Push — developer ( 762b64...a1cff0 )

ReferenceField::operatorE() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like