DBSqlBuilderCount Class Reference
[Model]

Build count query for a given (SELECT) query. More...

Inheritance diagram for DBSqlBuilderCount:

List of all members.

Protected Member Functions
	get_field_array ()
	Return field list (either fields or group by).
	get_fieldnames ($arr_fields, IDBTable $table)
	get_sql_template ()
	get_substitutes ()

---

Detailed Description

Build count query for a given (SELECT) query.

Note that HAVING clauses get ignored, so don't use them, if automatically build count queries. Use sub queries and joining using DBTableSubquery instead

Author:

Gerd Riesselmann

Definition at line 13 of file dbsqlbuilder.count.cls.php.

---

Member Function Documentation

DBSqlBuilderCount::get_field_array

(

)

[protected]

Return field list (either fields or group by).

Returns:

array

Definition at line 36 of file dbsqlbuilder.count.cls.php.

                                             {
                $ret = array();
                $group_by = Arr::get_item($this->params, 'group_by', array());
                if ($group_by) {
                        foreach($group_by as $g) {
                                $f = $g['field'];
                                $ret[] = $f;
                        }                       
                }
                else {
                        $ret = $this->fields;
                }
                return $ret;
        }

DBSqlBuilderCount::get_fieldnames	(	$	arr_fields,
		IDBTable $	table
	)			[protected]

Reimplemented from DBSqlBuilderSelect.

Definition at line 51 of file dbsqlbuilder.count.cls.php.

                                                                        {
        $count_fields = '*';
        $fieldnames = array();
        if (count($arr_fields) == 0) {
                // * on joins is no good idea
                if (count($this->query->get_subqueries()) > 0) {
                                $arr_fields = array_keys($table->get_table_keys());
                }
                }
                
                foreach($arr_fields as $key => $name) {
                        if (is_numeric($key)) {
                                $fieldnames[] = $this->prefix_column($name, $table);
                        }
                        else {
                                if (!$this->is_function($key)) {
                                        $fieldnames[] = $this->prefix_column($key, $table);
                                }
                        }
                }               
                if (count($fieldnames) > 0) {
                $count_fields = implode(', ', $fieldnames);
            }
                
            if ($count_fields == '*') {
                unset($this->params['distinct']);
            }
            
        return $count_fields;
        }

DBSqlBuilderCount::get_sql_template

(

)

[protected]

Reimplemented from DBSqlBuilderSelect.

Definition at line 14 of file dbsqlbuilder.count.cls.php.

                                              {
                return 'SELECT COUNT(%distinct%!fields) AS c FROM %!from%join%where';
        }

DBSqlBuilderCount::get_substitutes

(

)

[protected]

Reimplemented from DBSqlBuilderSelect.

Definition at line 18 of file dbsqlbuilder.count.cls.php.

                                             {
                $table = $this->query->get_table();
                $ret = array(
                        '%!fields' => $this->get_fieldnames($this->get_field_array(), $table),
                        '%!from' => $this->get_table_and_alias($table),
                        '%distinct' => $this->get_feature_sql($this->params, 'distinct', 'DISTINCT '),
                        '%where' => $this->get_where($this->query->get_wheres()),
                        '%join' => $this->get_join($this->query->get_subqueries()),
                        '%having' => $this->get_having($this->query->get_havings()),
                );
                return $ret;
        }       

---

The documentation for this class was generated from the following file:

• gyro/core/model/base/sqlbuilder/dbsqlbuilder.count.cls.php