public function buildSqlWhere() { $where = $this->config->filter(); $depth = Status::depth($this->statusVariables); if ($depth > 1) { if (!$this->config->connectionField()) { throw new \Ip\Exception("Nested GRID require 'connectionField' setting to be set."); } $where .= ' and (' . $where . ') and ' . $this->config->tableName() . '.`' . $this->config->connectionField() . '` = ' . ipDb()->getConnection()->quote($this->statusVariables['gridParentId' . ($depth - 1)]); } $searchVariables = array(); foreach ($this->statusVariables as $key => $value) { if (preg_match('/^s_/', $key)) { $searchVariables[substr($key, 2)] = $value; } } if (!empty($searchVariables)) { foreach ($this->config->fields() as $fieldData) { if (!empty($fieldData['type']) && $fieldData['type'] == 'Tab') { continue; } $fieldObject = $this->config->fieldObject($fieldData); $fieldQuery = $fieldObject->searchQuery($searchVariables); if ($fieldQuery) { if ($where != ' ') { $where .= ' and '; } $where .= $fieldQuery; } } } return $where; }