public function set_ajax_list_queries($state_info = null)
{
if (!empty($state_info->per_page)) {
if (empty($state_info->page) || !is_numeric($state_info->page)) {
$this->limit($state_info->per_page);
} else {
$limit_page = ($state_info->page - 1) * $state_info->per_page;
$this->limit($state_info->per_page, $limit_page);
}
}
if (!empty($state_info->order_by)) {
$this->order_by($state_info->order_by[0], $state_info->order_by[1]);
}
if (!empty($state_info->search)) {
if (!empty($this->relation)) {
foreach ($this->relation as $relation_name => $relation_values) {
$temp_relation[$this->_unique_field_name($relation_name)] = $this->_get_field_names_to_search($relation_values);
}
}
if ($state_info->search->field !== null) {
if (isset($temp_relation[$state_info->search->field])) {
if (is_array($temp_relation[$state_info->search->field])) {
foreach ($temp_relation[$state_info->search->field] as $search_field) {
$this->or_like($search_field, $state_info->search->text);
}
} else {
$this->like($temp_relation[$state_info->search->field], $state_info->search->text);
}
} elseif (isset($this->relation_n_n[$state_info->search->field])) {
$escaped_text = $this->basic_model->escape_str($state_info->search->text);
$this->having($state_info->search->field . " LIKE '%" . $escaped_text . "%'");
} else {
$this->like($state_info->search->field, $state_info->search->text);
}
} else {
$columns = $this->get_columns();
$search_text = $state_info->search->text;
if (!empty($this->where)) {
foreach ($this->where as $where) {
$this->basic_model->having($where[0], $where[1], $where[2]);
}
}
foreach ($columns as $column) {
if (isset($temp_relation[$column->field_name])) {
if (is_array($temp_relation[$column->field_name])) {
foreach ($temp_relation[$column->field_name] as $search_field) {
$this->or_like($search_field, $search_text);
}
} else {
$this->or_like($temp_relation[$column->field_name], $search_text);
}
} elseif (isset($this->relation_n_n[$column->field_name])) {
//@todo have a where for the relation_n_n statement
} else {
$this->or_like($column->field_name, $search_text);
}
}
}
}
}
protected function set_ajax_list_queries($state_info = null)
{
if (!empty($state_info->per_page)) {
if (empty($state_info->page) || !is_numeric($state_info->page)) {
$this->limit($state_info->per_page);
} else {
$limit_page = ($state_info->page - 1) * $state_info->per_page;
$this->limit($state_info->per_page, $limit_page);
}
}
if (!empty($state_info->order_by)) {
$this->order_by($state_info->order_by[0], $state_info->order_by[1]);
}
if (!empty($state_info->search)) {
if (!empty($this->relation)) {
foreach ($this->relation as $relation_name => $relation_values) {
/*
echo "name: ".$relation_name."<BR>";
echo "<pre>".print_r($relation_values)."</pre>";
echo "unique field name: ".$this->_unique_field_name($relation_name)."<BR>";
echo "get_field_names_to_search: ".$this->_get_field_names_to_search($relation_values)."<BR>";
*/
$temp_relation[$this->_unique_field_name($relation_name)] = $this->_get_field_names_to_search($relation_values);
}
}
if ($state_info->search->field !== null) {
if (isset($temp_relation[$state_info->search->field])) {
//echo "IS relation";
if (is_array($temp_relation[$state_info->search->field])) {
foreach ($temp_relation[$state_info->search->field] as $search_field) {
$this->or_like($search_field, $state_info->search->text);
}
} else {
$this->like($temp_relation[$state_info->search->field], $state_info->search->text);
}
} elseif (isset($this->relation_n_n[$state_info->search->field])) {
$escaped_text = $this->basic_model->escape_str($state_info->search->text);
$this->having($state_info->search->field . " LIKE '%" . $escaped_text . "%'");
} else {
if ($this->basic_model->table_name) {
$search_field = $this->basic_model->table_name . '.' . $state_info->search->field;
} else {
$search_field = $state_info->search->field;
}
if ($addDbName = $this->basic_model->get_additional_database()) {
$search_field = $addDbName . $search_field;
}
$this->like($search_field, $state_info->search->text);
}
} else {
$columns = $this->get_columns();
$search_text = $state_info->search->text;
if (!empty($this->where)) {
foreach ($this->where as $where) {
$this->basic_model->having($where[0], $where[1], $where[2]);
}
}
foreach ($columns as $column) {
if (isset($temp_relation[$column->field_name])) {
if (is_array($temp_relation[$column->field_name])) {
foreach ($temp_relation[$column->field_name] as $search_field) {
$this->or_like($search_field, $search_text);
}
} else {
$this->or_like($temp_relation[$column->field_name], $search_text);
}
} elseif (isset($this->relation_n_n[$column->field_name])) {
//@todo have a where for the relation_n_n statement
} else {
$this->or_like($column->field_name, $search_text);
}
}
}
}
}
protected function set_ajax_list_queries($state_info = null)
{
if (!empty($state_info->per_page)) {
if (empty($state_info->page) || !is_numeric($state_info->page)) {
$this->limit($state_info->per_page);
} else {
$limit_page = ($state_info->page - 1) * $state_info->per_page;
$this->limit($state_info->per_page, $limit_page);
}
}
if (!empty($state_info->order_by)) {
$this->order_by($state_info->order_by[0], $state_info->order_by[1]);
}
if (!empty($state_info->search)) {
if (!empty($this->relation)) {
foreach ($this->relation as $relation_name => $relation_values) {
$temp_relation[$this->_unique_field_name($relation_name)] = $this->_get_field_names_to_search($relation_values);
}
}
if ($state_info->search->field !== null) {
if (isset($temp_relation[$state_info->search->field])) {
if (is_array($temp_relation[$state_info->search->field])) {
foreach ($temp_relation[$state_info->search->field] as $search_field) {
$this->or_like($search_field, $state_info->search->text);
}
} else {
$this->like($temp_relation[$state_info->search->field], $state_info->search->text);
}
} elseif (isset($this->relation_n_n[$state_info->search->field])) {
$escaped_text = $this->basic_model->escape_str($state_info->search->text);
$this->having($state_info->search->field . " LIKE '%" . $escaped_text . "%'");
} else {
$this->like($state_info->search->field, $state_info->search->text);
}
} else {
$columns = $this->get_columns();
$search_text = $state_info->search->text;
if (!empty($this->where)) {
foreach ($this->where as $where) {
$this->basic_model->having($where[0], $where[1], $where[2]);
}
}
//Get the list of actual columns and then before adding it to search ..
//compare it with the field ... does it exists? .. if yes.. great ..
//go ahead and add it to search list.. if not.. just ignore it
$field_types = $this->get_field_types();
$actual_columns = array();
foreach ($field_types as $field) {
if (!isset($field->db_extra) || $field->db_extra != 'auto_increment') {
$actual_columns[] = $field->name;
}
}
foreach ($columns as $column) {
if (isset($temp_relation[$column->field_name])) {
if (is_array($temp_relation[$column->field_name])) {
foreach ($temp_relation[$column->field_name] as $search_field) {
$this->or_like($search_field, $search_text);
}
} else {
$this->or_like($temp_relation[$column->field_name], $search_text);
}
} elseif (isset($this->relation_n_n[$column->field_name])) {
//@todo have a where for the relation_n_n statement
} else {
if (array_search($column->field_name, $actual_columns) === false) {
continue;
}
$this->or_like($column->field_name, $search_text);
}
}
}
}
}