op){ case Grid::SEARCH_OPTION_EQUAL: $query->where($gridFilter->field, '=', $gridFilter->data); break; case Grid::SEARCH_OPTION_CONTAINS: //contains $query->where($gridFilter->field, 'like', "%" . $gridFilter->data . "%"); break; case Grid::SEARCH_OPTION_LESS_OR_EQUAL: //less or equal $query->where($gridFilter->field, '<=', $gridFilter->data); break; case Grid::SEARCH_OPTION_LESS: //less $query->where($gridFilter->field, '<', $gridFilter->data); break; case Grid::SEARCH_OPTION_GREATER_OR_EQUAL: //greater or equal $query->where($gridFilter->field, '>=', $gridFilter->data); break; case Grid::SEARCH_OPTION_GREATER: //greater $query->where($gridFilter->field, '>', $gridFilter->data); break; default: break; } } } return $query; } public function getScript($gridId, $url, $columns, $actions = NULL, $gridParams = NULL){ if(!empty($gridParams)){ foreach($gridParams as $param){ if(isset($this->param)){ $this->param = $param; } } } $gridJs = '"; return $gridJs; } public function getMetadataScript($gridId, $url, $metadata, $parentId = null, $gridParams = null){ $columns = unserialize(serialize($metadata["grid"]["columns"])); $actions = null; $tableName = $metadata["model"]::getTableName(); foreach($columns as &$column){ if($column["type"] == "field"){ if(empty($column["relation"])){ $column["name"] = "{$tableName}.{$column["name"]}"; }else{ $relation = $column["relation"]; $column["name"] = "{$relation["table"]}.{$relation["field"]}"; } } } if(!empty($metadata["grid"]["actions"])){ $actions = unserialize(serialize($metadata["grid"]["actions"])); foreach($actions as &$action){ $action["url"] = convertBackofficeUrl($action["url"], $metadata, null, $parentId); } } return $this->getScript($gridId, $url, $columns, $actions, $gridParams); } }