| 1749 | | * count |
| 1750 | | * fetches the count of the query |
| 1751 | | * |
| 1752 | | * This method executes the main query without all the |
| 1753 | | * selected fields, ORDER BY part, LIMIT part and OFFSET part. |
| 1754 | | * |
| 1755 | | * Example: |
| 1756 | | * Main query: |
| 1757 | | * SELECT u.*, p.phonenumber FROM User u |
| 1758 | | * LEFT JOIN u.Phonenumber p |
| 1759 | | * WHERE p.phonenumber = '123 123' LIMIT 10 |
| 1760 | | * |
| 1761 | | * The modified DQL query: |
| 1762 | | * SELECT COUNT(DISTINCT u.id) FROM User u |
| 1763 | | * LEFT JOIN u.Phonenumber p |
| 1764 | | * WHERE p.phonenumber = '123 123' |
| 1765 | | * |
| 1766 | | * @param array $params an array of prepared statement parameters |
| 1767 | | * @return integer the count of this query |
| 1768 | | */ |
| 1769 | | public function count($params = array()) |
| | 1749 | * Get count sql query for this Doctrine_Query instance |
| | 1750 | * Used in Doctrine_Query::count() for returning an integer for the number of records which will |
| | 1751 | * be returned when executed. |
| | 1752 | * |
| | 1753 | * @return string $q |
| | 1754 | */ |
| | 1755 | public function getCountQuery() |
| | 1805 | return $q; |
| | 1806 | } |
| | 1807 | |
| | 1808 | /** |
| | 1809 | * count |
| | 1810 | * fetches the count of the query |
| | 1811 | * |
| | 1812 | * This method executes the main query without all the |
| | 1813 | * selected fields, ORDER BY part, LIMIT part and OFFSET part. |
| | 1814 | * |
| | 1815 | * Example: |
| | 1816 | * Main query: |
| | 1817 | * SELECT u.*, p.phonenumber FROM User u |
| | 1818 | * LEFT JOIN u.Phonenumber p |
| | 1819 | * WHERE p.phonenumber = '123 123' LIMIT 10 |
| | 1820 | * |
| | 1821 | * The modified DQL query: |
| | 1822 | * SELECT COUNT(DISTINCT u.id) FROM User u |
| | 1823 | * LEFT JOIN u.Phonenumber p |
| | 1824 | * WHERE p.phonenumber = '123 123' |
| | 1825 | * |
| | 1826 | * @param array $params an array of prepared statement parameters |
| | 1827 | * @return integer the count of this query |
| | 1828 | */ |
| | 1829 | public function count($params = array()) |
| | 1830 | { |
| | 1831 | $q = $this->getCountQuery(); |
| | 1832 | |
