/**
* {@inheritDoc}
*/
public function scope(Query $query, TokenInterface $token)
{
$column = $this->config('field');
$value = $token->value();
if (!$column || empty($value)) {
return $query;
}
$tableAlias = $this->_table->alias();
$range = $this->_parseRange($token->value());
if ($range['lower'] !== $range['upper']) {
$conjunction = $token->negated() ? 'AND NOT' : 'AND';
$conditions = ["{$conjunction}" => ["{$tableAlias}.{$column} >=" => $range['lower'], "{$tableAlias}.{$column} <=" => $range['upper']]];
} else {
$cmp = $token->negated() ? '<=' : '>=';
$conditions = ["{$tableAlias}.{$column} {$cmp}" => $range['lower']];
}
if ($token->where() === 'or') {
$query->orWhere($conditions);
} elseif ($token->where() === 'and') {
$query->andWhere($conditions);
} else {
$query->where($conditions);
}
return $query;
}
/**
* {@inheritDoc}
*/
public function scope(Query $query, TokenInterface $token)
{
list($conjunction, $value) = $this->_prepareConjunction($token);
$subQuery = TableRegistry::get('Clients.ClientsRecords')->find()->contain(['Client'])->select(['ClientsRecords.record_id'])->where(['OR' => ["Client.name {$conjunction}" => $value, "Client.lastname {$conjunction}" => $value]]);
$conditions = ['SearchDatasets.entity_id IN' => $subQuery];
if ($token->where() === 'or') {
$query->orWhere($conditions);
} elseif ($token->where() === 'and') {
$query->andWhere($conditions);
}
return $query->where($conditions);
}
/**
* Method that adds lookup fields with the id value to the Where clause in ORM Query
*
* @param \Cake\ORM\Query $query Query instance
* @param string $id Record id
* @return \Cake\ORM\Query
*/
public function findByLookupFields(Query $query, $id)
{
$lookupFields = $this->lookupFields();
if (empty($lookupFields)) {
return $query;
}
$tableName = $this->alias();
// check for record by table's lookup fields
foreach ($lookupFields as $lookupField) {
// prepend table name to avoid CakePHP ORM's ambiguous column errors
if (false === strpos($lookupField, '.')) {
$lookupField = $tableName . '.' . $lookupField;
}
$query->orWhere([$lookupField => $id]);
}
return $query;
}
/**
* {@inheritDoc}
*/
public function scope(Query $query, TokenInterface $token)
{
$column = $this->config('field');
$value = $token->value();
if (!$column || empty($value)) {
return $query;
}
list($conjunction, $value) = $this->_prepareConjunction($token);
$tableAlias = $this->_table->alias();
$conditions = ["{$tableAlias}.{$column} {$conjunction}" => $value];
if ($token->where() === 'or') {
$query->orWhere($conditions);
} elseif ($token->where() === 'and') {
$query->andWhere($conditions);
} else {
$query->where($conditions);
}
return $query;
}
/**
* Handles the "term:" search operator. Which filters all entities matching
* a given collection of terms.
*
* term:cat,dog,bird,...,term-slug
*
* You can provide up to 10 terms as maximum.
*
* @param \Cake\Event\Event $event The event that was triggered
* @param \Cake\ORM\Query $query The query being scoped
* @param \Search\Token $token Operator token
* @return \Cake\ORM\Query Scoped query
*/
public function operatorTerm(Event $event, $query, $token)
{
$slugs = explode(',', $token->value());
$slugs = array_slice($slugs, 0, 10);
if (!empty($slugs)) {
$IN = $token->negated() ? 'NOT IN' : 'IN';
$table = $event->subject();
$pk = $table->primaryKey();
$tableAlias = $table->alias();
$termsIds = TableRegistry::get('Taxonomy.Terms')->find()->select(['id'])->where(['Terms.slug IN' => $slugs])->all()->extract('id')->toArray();
$termsIds = empty($termsIds) ? [0] : $termsIds;
$subQuery = TableRegistry::get('Taxonomy.EntitiesTerms')->find()->select(['entity_id'])->where(['term_id IN' => $termsIds, 'table_alias' => $tableAlias]);
if ($token->where() === 'or') {
$query->orWhere(["{$tableAlias}.{$pk} {$IN}" => $subQuery]);
} elseif ($token->where() === 'and') {
$query->andWhere(["{$tableAlias}.{$pk} {$IN}" => $subQuery]);
} else {
$query->where(["{$tableAlias}.{$pk} {$IN}" => $subQuery]);
}
}
return $query;
}
/**
* Method that adds lookup fields with the matching values to the Where clause in ORM Query
*
* @param \Cake\ORM\Query $query Query instance
* @param array $values Entity lookup-fields values
* @return \Cake\ORM\Query
*/
public function findByLookupFieldsWithValues(Query $query, array $values)
{
$lookupFields = $this->lookupFields();
if (empty($lookupFields) || empty($values)) {
return $query;
}
// check for record by table's lookup fields
foreach ($lookupFields as $lookupField) {
if (!isset($values[$lookupField])) {
continue;
}
$query->orWhere([$lookupField => $values[$lookupField]]);
}
return $query;
}
/**
* Handles "term" search operator.
*
* term:term1-slug,term2-slug,...
*
* @param \Cake\ORM\Query $query The query object
* @param \Search\Parser\TokenInterface $token Operator token
* @return \Cake\ORM\Query
*/
public function operatorterm(Query $query, TokenInterface $token)
{
$terms = explode(',', strtolower($token->value()));
$conjunction = $token->negated() ? 'NOT IN' : 'IN';
if (empty($terms)) {
return $query;
}
$conditions = ["Contents.id {$conjunction}" => TableRegistry::get('Taxonomy.EntitiesTerms')->find()->select(['EntitiesTerms.entity_id'])->where(['EntitiesTerms.table_alias' => $this->alias()])->matching('Terms', function ($q) use($terms) {
return $q->where(['Terms.slug IN' => $terms]);
})];
if (!empty($conditions)) {
if ($token->where() === 'or') {
$query->orWhere($conditions);
} elseif ($token->where() === 'and') {
$query->andWhere($conditions);
} else {
$query->where($conditions);
}
}
return $query;
}
/**
* Custom finder to log in users
*
* @param Query $query Query object to modify
* @param array $options Query options
* @return Query
* @throws \BadMethodCallException
*/
public function findAuth(Query $query, array $options = [])
{
$identifier = Hash::get($options, 'username');
if (empty($identifier)) {
throw new \BadMethodCallException(__d('CakeDC/Users', 'Missing \'username\' in options data'));
}
$query->orWhere([$this->aliasField('email') => $identifier])->find('active', $options);
return $query;
}
/**
* Similar to "_scopeWords" but using MySQL's fulltext indexes.
*
* @param \Cake\ORM\Query $query The query to scope
* @param \Search\TokenInterface $token Token describing a words sequence. e.g `this is a phrase`
* @return \Cake\ORM\Query Scoped query
*/
protected function _scopeWordsInFulltext(Query $query, TokenInterface $token)
{
$value = str_replace(['*', '!'], ['*', '*'], $token->value());
$value = mb_strpos($value, '+') === 0 ? mb_substr($value, 1) : $value;
if (empty($value) || in_array($value, $this->_stopWords())) {
return $query;
}
$not = $token->negated() ? 'NOT' : '';
$value = str_replace("'", '"', $value);
$conditions = ["{$not} MATCH(SearchDatasets.words) AGAINST('{$value}' IN BOOLEAN MODE) > 0"];
if ($token->where() === 'or') {
$query->orWhere($conditions);
} elseif ($token->where() === 'and') {
$query->andWhere($conditions);
} else {
$query->where($conditions);
}
return $query;
}
