| <?php | |
| // | |
| // Open Web Analytics - An Open Source Web Analytics Framework | |
| // | |
| // Copyright 2006 Peter Adams. All rights reserved. | |
| // | |
| // Licensed under GPL v2.0 http://www.gnu.org/copyleft/gpl.html | |
| // | |
| // Unless required by applicable law or agreed to in writing, software | |
| // distributed under the License is distributed on an "AS IS" BASIS, | |
| // WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. | |
| // See the License for the specific language governing permissions and | |
| // limitations under the License. | |
| // | |
| // $Id$ | |
| // | |
| /** | |
| * Click Browser Types Metric | |
| * | |
| * @author Peter Adams <peter@openwebanalytics.com> | |
| * @copyright Copyright © 2006 Peter Adams <peter@openwebanalytics.com> | |
| * @license http://www.gnu.org/copyleft/gpl.html GPL v2.0 | |
| * @category owa | |
| * @package owa | |
| * @version $Revision$ | |
| * @since owa 1.0.0 | |
| */ | |
| class owa_clickBrowserTypes extends owa_metric { | |
| function owa_clickBrowserTypes($params = null) { | |
| return owa_clickBrowserTypes::__construct($params); | |
| } | |
| function __construct($params = null) { | |
| return parent::__construct($params); | |
| } | |
| function calculate() { | |
| $this->db->selectFrom('owa_click', 'click'); | |
| $this->db->selectColumn("count(distinct click.id) as count, | |
| ua.id, | |
| ua.ua as ua, | |
| ua.browser_type"); | |
| $this->db->join(OWA_SQL_JOIN_LEFT_OUTER,'owa_ua', 'ua', 'ua_id', 'ua.id'); | |
| $this->db->groupBy('ua.browser_type'); | |
| $this->db->orderBy('count'); | |
| return $this->db->getAllRows(); | |
| } | |
| } | |
| ?> |