/**
*
* @param Database $query
*/
protected function _search(&$query)
{
$db = $query->getDb();
$search = false;
$buscar = $this->_request->getParam("search");
if (!empty($buscar["value"])) {
$cond = "(";
$or = "";
foreach ($this->_data['columns'] as $val) {
if (count($val) > 0) {
if (!empty($val["search"]) and $val["search"]["active"]) {
if (!empty($val["search"]["searchable_cond"])) {
if (isset($val["search"]["searchable_value"])) {
$valor = str_replace("?", $buscar["value"], $val["search"]["searchable_value"]);
} else {
$valor = $buscar["value"];
}
$cond .= $or . str_replace("?", $db->escape($valor), $val["search"]["searchable_cond"]);
$or = " OR ";
$search = true;
}
}
}
}
$cond .= ") ";
}
if ($search) {
$query->addWhere($cond);
}
}
