Exemplos de Grocery_crud_generic_model::build_relation_n_n_subquery em PHP

Exemplo n.º 1

Arquivo: Grocery_crud_model_pdo.php Projeto: ishawge/No-CMS

 function build_relation_n_n_subquery($field, $selection_table, $relation_table, $primary_key_alias_to_selection_table, $primary_key_selection_table, $primary_key_alias_to_this_table, $field_name)
 {
     if ($this->subdriver == 'pgsql') {
         return "(SELECT string_agg(" . $this->protect_identifiers($field) . ", ',') FROM " . $this->protect_identifiers($selection_table) . " LEFT JOIN " . $this->protect_identifiers($relation_table) . " ON " . $this->protect_identifiers($relation_table . "." . $primary_key_alias_to_selection_table) . " = " . $this->protect_identifiers($selection_table . "." . $primary_key_selection_table) . " WHERE cast(" . $this->protect_identifiers($relation_table . "." . $primary_key_alias_to_this_table) . " as character varying ) = cast(" . $this->protect_identifiers($this->table_name . "." . $this->get_primary_key()) . "  as character varying ) GROUP BY " . $this->protect_identifiers($relation_table . "." . $primary_key_alias_to_this_table) . ") AS " . $this->protect_identifiers($field_name);
     } else {
         return parent::build_relation_n_n_subquery($field, $selection_table, $relation_table, $primary_key_alias_to_selection_table, $primary_key_selection_table, $primary_key_alias_to_this_table, $field_name);
     }
 }