SeznamSearch.php
public static function searchAllWords($table, $search) // 'typ_zbozi.name', $this->typzboziname
{
$condition = array();
if(isset($search) && $search <> NULL)
{
$name = explode(" ", $search);
$condition = ['and'];
foreach ($name as $key)
{
$condition[] = ['like', $table, $key];
}
}
return $condition;
}
ItemSearch.php
$query->andWhere(SeznamSearch::searchAllWords('typ_zbozi.name', $this->typzboziname));
$query->andWhere(SeznamSearch::searchAllWords('(CASE WHEN zakazniky.is_fa=1 THEN zakazniky.f_name ELSE zakazniky.o_name END)', $this->f_name));