Undoing last revision

git-svn-id: http://svn.mozilla.org/addons/trunk@8303 4eb1ac78-321c-0410-a911-ec516a8615a5

1 files changed, 0 insertions, 518 deletions

diff --git a/site/app/controllers/statistics_controller.php b/site/app/controllers/statistics_controller.php
deleted file mode 100644
index ab10b4b..0000000
--- a/site/app/controllers/statistics_controller.php
+++ /dev/null
@@ -1,518 +0,0 @@
-<?php
-/* ***** BEGIN LICENSE BLOCK *****
- * Version: MPL 1.1/GPL 2.0/LGPL 2.1
- *
- * The contents of this file are subject to the Mozilla Public License Version
- * 1.1 (the "License"); you may not use this file except in compliance with
- * the License. You may obtain a copy of the License at
- * http://www.mozilla.org/MPL/e
- *
- * Software distributed under the License is distributed on an "AS IS" basis,
- * WITHOUT WARRANTY OF ANY KIND, either express or implied. See the License
- * for the specific language governing rights and limitations under the
- * License.
- *
- * The Original Code is addons.mozilla.org site.
- *
- * The Initial Developer of the Original Code is
- * The Mozilla Foundation.
- * Portions created by the Initial Developer are Copyright (C) 2007
- * the Initial Developer. All Rights Reserved.
- *
- * Contributor(s):
- *    Justin Scott <fligtar@mozilla.com> (Original Author)
- *
- * Alternatively, the contents of this file may be used under the terms of
- * either the GNU General Public License Version 2 or later (the "GPL"), or
- * the GNU Lesser General Public License Version 2.1 or later (the "LGPL"),
- * in which case the provisions of the GPL or the LGPL are applicable instead
- * of those above. If you wish to allow use of your version of this file only
- * under the terms of either the GPL or the LGPL, and not to allow others to
- * use your version of this file under the terms of the MPL, indicate your
- * decision by deleting the provisions above and replace them with the notice
- * and other provisions required by the GPL or the LGPL. If you do not delete
- * the provisions above, a recipient may use your version of this file under
- * the terms of any one of the MPL, the GPL or the LGPL.
- *
- * ***** END LICENSE BLOCK ***** */
-
-class StatisticsController extends AppController
-{
-    var $name = 'Statistics';
-    var $uses = array('Addon', 'Addontype', 'Application', 'User', 'Version');
-    var $components = array('Amo', 'Image');
-    var $helpers = array('Html', 'Javascript', 'Localization');
-
-   /**
-    * Require login for all actions
-    */
-    function beforeFilter() {
-        $this->SimpleAuth->enabled = false;
-        $this->SimpleAcl->enabled = false;
-        
-        // beforeFilter() is apparently called before components are initialized. Cake++
-        $this->Amo->startup($this);
-        $this->Amo->checkLoggedIn();
-        
-        //Clean post data
-        $this->Amo->clean($this->data); 
-        
-        $this->layout = 'mozilla';
-        $this->pageTitle = 'Statistics Dashboard'.' :: '.sprintf(_('addons_home_pagetitle'), APP_PRETTYNAME);
-        
-        $this->cssAdd = array('stats', 'jquery-ui/flora/flora.all');
-        $this->publish('cssAdd', $this->cssAdd);
-        
-        $this->jsAdd = array(
-            'mochikit/MochiKit.js',
-            'plotkit/Base.js',
-            'plotkit/Layout.js',
-            'plotkit/Canvas.js',
-            'plotkit/SweetCanvas.js',
-            'jquery-compressed.js',
-            'jquery-ui/ui.tabs.js',
-            'jquery-ui/ui.calendar.js',
-            'jquery-ui/jquery.dimensions.js',
-            'jquery-ui/ui.dialog.js',
-            'jquery-ui/ui.resizable.js',
-            'jquery-ui/ui.mouse.js',
-            'jquery-ui/ui.draggable.js',
-            'stats.js'
-            );
-        $this->publish('jsAdd', $this->jsAdd);
-        
-        $this->breadcrumbs = array('Statistics Dashboard' => '/statistics/index');
-        $this->publish('breadcrumbs', $this->breadcrumbs);
-        
-        $this->publish('subpagetitle', 'Statistics Dashboard');
-    }
-    
-   /**
-    * Index
-    */
-    function index($addon_id = 0) {
-        // If add-on id was specified, go to its statistics
-        if (!empty($addon_id)) {
-            $this->addon($addon_id);
-            return;
-        }
-        // If not, figure out what to do
-        else {
-            $session = $this->Session->read('User');
-            $addons = $this->Addon->getAddonsByUser($session['id']);
-            
-            // If more than one add-on, give choice
-            if (count($addons) > 1) {
-                $this->publish('addons', $addons);
-            }
-            // If only one add-on, show statistics
-            elseif (count($addons) == 1) {
-                $this->addon($addons[0]);
-                return;
-            }
-            // If no add-ons, go to dev cp
-            else {
-                $this->redirect('/developers/index');
-                return;
-            }
-        }
-    }
-    
-   /**
-    * Add-on Statistics
-    */
-    function addon($addon_id) {
-        $this->Amo->clean($addon_id);
-        $this->publish('addon_id', $addon_id);
-        
-        $this->set('subpagetitle', 'Add-on Statistics <sup style="font-size: 50%; font-family: Courier;">BETA</sup>');
-        $this->breadcrumbs['Add-on Statistics'] = '/statistics/addon/'.$addon_id;
-        $this->publish('breadcrumbs', $this->breadcrumbs);
-        
-        // Make sure has permission
-        if (!$this->Amo->checkOwnership($addon_id)) {
-            $this->flash(_('devcp_error_addon_access_denied'), '/developers/index');
-            return;
-        }
-        
-        $this->set('addon_name', $this->Addon->getAddonName($addon_id));
-        $session = $this->Session->read('User');
-        $this->publish('email', $session['email']);
-        $this->publish('all_addons', $this->Addon->getAddonsByUser($session['id']));
-        
-        // Add-on icon
-        $addonIcon = $this->Image->urlForAddonIcon($addon_id);
-        if (empty($addonIcon))
-            $addonIcon = $this->base.'/img/'.DEFAULT_ADDON_ICON;
-        $this->publish('addonIcon', $addonIcon);
-        
-        // Get all valid update ping dates
-        $updatepingDates = $this->Addon->query("SELECT DISTINCT date FROM update_counts WHERE addon_id='{$addon_id}'");
-        $updateDates = array();
-        if (!empty($updatepingDates)) {
-            foreach ($updatepingDates as $updatepingDate) {
-                $updateDates[] = "'{$updatepingDate['update_counts']['date']}'";
-            }
-        }
-        $this->set('updateDates', $updateDates);
-        
-        $bothStart = $this->Addon->query("(SELECT date FROM download_counts WHERE addon_id={$addon_id}) UNION (SELECT date FROM update_counts WHERE addon_id={$addon_id}) ORDER BY date LIMIT 1");
-        $this->publish('bothStart', $bothStart[0][0]['date']);
-        $bothEnd = $this->Addon->query("(SELECT date FROM download_counts WHERE addon_id={$addon_id}) UNION (SELECT date FROM update_counts WHERE addon_id={$addon_id}) ORDER BY date DESC LIMIT 1");
-        $this->publish('bothEnd', $bothEnd[0][0]['date']);
-        
-        // Data for overview
-        $statsQry = $this->Addon->query("SELECT totaldownloads, weeklydownloads, created FROM addons WHERE id={$addon_id}");       
-        $stats['totaldownloads'] = $statsQry[0]['addons']['totaldownloads'];
-        $stats['weeklydownloads'] = $statsQry[0]['addons']['weeklydownloads'];
-        $stats['addon_created'] = $statsQry[0]['addons']['created'];
-        $statsQry = $this->Addon->query("SELECT AVG(count) FROM update_counts WHERE addon_id={$addon_id}");        
-        $stats['avg_updatepings'] = $statsQry[0][0]['AVG(count)'];
-        $statsQry = $this->Addon->query("SELECT AVG(count) FROM download_counts WHERE addon_id={$addon_id}");
-        $stats['avg_downloads'] = $statsQry[0][0]['AVG(count)'];
-        $statsQry = $this->Addon->query("SELECT count, date FROM update_counts WHERE addon_id={$addon_id} ORDER BY date DESC LIMIT 2");
-        $stats['last_updatepings'] = $statsQry[0]['update_counts']['count'];
-        $stats['last_updatepings_date'] = $statsQry[0]['update_counts']['date'];
-        $stats['previous_updatepings'] = $statsQry[1]['update_counts']['count'];
-        $stats['previous_updatepings_date'] = $statsQry[1]['update_counts']['date'];
-        $stats['updateping_change'] = (($stats['last_updatepings'] - $stats['previous_updatepings']) / $stats['previous_updatepings']) * 100;
-        $statsQry = $this->Addon->query("SELECT count, date FROM download_counts WHERE addon_id={$addon_id} ORDER BY date DESC LIMIT 1");
-        $stats['last_downloads'] = $statsQry[0]['download_counts']['count'];
-        $stats['last_downloads_date'] = $statsQry[0]['download_counts']['date'];
-        $this->set('stats', $stats);
-        
-        $this->render('addon', 'mozilla');
-    }
-    
-   /**
-    * JSON data
-    */
-    function json($addon_id, $type = '', $chart = 'downloads', $subchart = '') {
-        $this->publish('chart', $chart);
-        $this->publish('subchart', $subchart);
-        $this->Amo->clean($addon_id);
-        $this->publish('addon_id', $addon_id);
-        
-        // Make sure has permission
-        if (!$this->Amo->checkOwnership($addon_id)) {
-            return;
-        }
-        
-        if ($type == 'historical') {
-            $this->_historicalChart($addon_id, $chart);
-        }
-        elseif ($type == 'breakdown') {
-            $this->_breakdownChart($addon_id, $chart, $subchart);
-        }
-        
-        define('NO_MICROTIME', true);
-        $this->render('json', 'ajax');
-    }
-    
-    function _historicalChart($addon_id, $chart) {
-        $chartType = 'line';
-        $xTicks = array();
-        $values = array();
-        $fullList = array();
-        
-        if (!empty($_GET['start']) && !empty($_GET['end'])) {
-            $date = "{$_GET['start']} ~ {$_GET['end']}";
-            $this->Amo->clean($_GET);
-            $dateQry = "AND date >= '{$_GET['start']}' AND date <= '{$_GET['end']}'";
-        }
-        else {
-            $date = 'All Available Data';
-            $dateQry = '';
-        }
-        
-        if ($chart == 'downloads') {
-            $title = 'Historical Daily Downloads';
-            $data = $this->Addon->query("SELECT * FROM download_counts WHERE addon_id={$addon_id} {$dateQry} ORDER BY date");
-            
-            list($xTicks, $values) = $this->_lineChart($data, 'download_counts');
-        }
-        elseif ($chart == 'updatepings') {
-            $title = 'Historical Daily Active Users';
-            $data = $this->Addon->query("SELECT * FROM update_counts WHERE addon_id={$addon_id} {$dateQry} ORDER BY date");
-            
-            list($xTicks, $values) = $this->_lineChart($data, 'update_counts');
-        }
-        elseif ($chart == 'versions') {
-            $title = 'Historical Add-on Version Usage';
-            $data = $this->Addon->query("SELECT version AS count, date FROM update_counts WHERE addon_id={$addon_id} {$dateQry} ORDER BY date");
-            
-            list($xTicks, $valuesArray) = $this->_top5LineChart($data);
-        }
-        elseif ($chart == 'applications') {
-            $title = 'Historical Application Version Usage';
-            $data = $this->Addon->query("SELECT application AS count, date FROM update_counts WHERE addon_id={$addon_id} {$dateQry} ORDER BY date");
-            
-            list($xTicks, $valuesArray) = $this->_top5LineChart($data);
-        }
-        elseif ($chart == 'status') {
-            $title = 'Historical Add-on Usage Status';
-            $data = $this->Addon->query("SELECT status AS count, date FROM update_counts WHERE addon_id={$addon_id} {$dateQry} ORDER BY date");
-            
-            list($xTicks, $valuesArray) = $this->_top5LineChart($data);
-        }
-        elseif ($chart == 'os') {
-            $title = 'Historical Active Operating System Usage';
-            $data = $this->Addon->query("SELECT os AS count, date FROM update_counts WHERE addon_id={$addon_id} {$dateQry} ORDER BY date");
-            
-            list($xTicks, $valuesArray) = $this->_top5LineChart($data);
-        }
-        
-        $this->publish('chartTitle', $title);
-        $this->publish('type', $chartType);
-        $this->set('xTicks', $xTicks);
-        $this->publish('date', $date);
-        $this->set('fullList', $fullList);
-        if (!empty($valuesArray))
-            $this->set('values', $valuesArray);
-        else
-            $this->set('values', array('Data 1' => $values));
-    }
-    
-    function _breakdownChart($addon_id, $chart, $subchart) {
-        $chartType = 'pie';
-        $xTicks = array();
-        $values = array();
-        $fullList = array();
-        
-        if (empty($_GET['date'])) {
-            $date = $this->Addon->query("SELECT date FROM update_counts ORDER BY date DESC LIMIT 1");
-            $date = $date[0]['update_counts']['date'];
-        }
-        else {
-            $date = $_GET['date'];
-            $this->Amo->clean($date);
-        }
-        
-        if ($chart == 'versions') {
-            $title = 'Versions Currently in Use';
-            $data = $this->Addon->query("SELECT count, version FROM update_counts WHERE addon_id={$addon_id} AND date='{$date}'");
-            
-            if (!empty($data))
-                list($xTicks, $values, $fullList) = $this->_pieChart($data[0]['update_counts']['version'], $data[0]['update_counts']['count']);
-        }
-        elseif ($chart == 'applications') {
-            $title = 'Applications Currently in Use';
-            $data = $this->Addon->query("SELECT count, application FROM update_counts WHERE addon_id={$addon_id} AND date='{$date}'");
-            
-            if (!empty($data)) {
-                $totalCount = $data[0]['update_counts']['count'];
-                $data = $data[0]['update_counts']['application'];
-                
-                $subChartMenu = array();
-                
-                $apps = unserialize($data);
-                $appnames = $this->Application->getGUIDList();
-                
-                $i = 0;
-                $otherCount = 0;
-                foreach ($apps as $app => $versions) {
-                    if (empty($app))
-                        continue;
-                    
-                    $appname = !empty($appnames[$app]) ? $appnames[$app] : 'Unknown App '.$app;
-                    
-                    arsort($versions);
-                    // Only count if no subchart set or if we're on the requested subchart app
-                    if (empty($subchart) || $subchart == $app || '{'.$subchart.'}' == $app) {
-                        foreach ($versions as $version => $count) {
-                            $percentage = ($count / $totalCount) * 100;
-                            if ($percentage >= 2) {
-                                $xTicks[$i] = '{v:'.$i.', label:"'.$appname.' '.$version.'"}';
-                                $values[$i] = "[{$i}, {$count}]";
-                            }
-                            else
-                                $otherCount += $count;
-                                
-                            $fullList[] = '{label:"'.$appname.' '.$version.'", count:'.$count.', percentage:'.round($percentage, 2).'}';
-                            $i++;
-                        }
-                    }
-                    
-                    // Add to subchart menu
-                    $subChartMenu[] = '{guid: "'.str_replace(array('{', '}'), '', $app).'", name:"'.$appname.'"}';
-                }
-                
-                if ($otherCount > 0) {
-                    $xTicks[$i] = '{v:'.$i.', label:"Other"}';
-                    $values[$i] = "[{$i}, {$otherCount}]";
-                }
-                    
-                $this->set('subChartMenu', $subChartMenu);
-            }
-        }
-        elseif ($chart == 'status') {
-            $title = 'Status of Add-ons Currently in Use';
-            $data = $this->Addon->query("SELECT count, status FROM update_counts WHERE addon_id={$addon_id} AND date='{$date}'");
-            
-            if (!empty($data))
-                list($xTicks, $values, $fullList) = $this->_pieChart($data[0]['update_counts']['status'], $data[0]['update_counts']['count']);
-        }
-        elseif ($chart == 'os') {
-            $title = 'Operating Systems Currently in Use';
-            $data = $this->Addon->query("SELECT count, os FROM update_counts WHERE addon_id={$addon_id} AND date='{$date}'");
-            
-            if (!empty($data))
-                list($xTicks, $values, $fullList) = $this->_pieChart($data[0]['update_counts']['os'], $data[0]['update_counts']['count']);
-        }
-        
-        $this->publish('chartTitle', $title);
-        $this->publish('type', $chartType);    
-        $this->set('xTicks', $xTicks);
-        $this->publish('date', $date);
-        $this->set('fullList', $fullList);
-        $this->set('values', array('Data 1' => $values));
-    }
-    
-    function _lineChart($data, $table) {
-        $labelRate = ceil(count($data) / 20);
-        $labelNum = 1;
-        
-        foreach ($data as $k => $v) {
-            if ($labelNum == 1)
-                $label = date('n/j', strtotime($v[$table]['date']));
-            else
-                $label = '';
-            
-            $xTicks[$k] = '{v:'.$k.', label:"'.$label.'"}';
-            $values[$k] = "[{$k}, {$v[$table]['count']}]";
-            
-            if ($labelNum >= $labelRate)
-                $labelNum = 1;
-            else
-                $labelNum++;
-        }
-        
-        return array($xTicks, $values);
-    }
-    
-    function _top5LineChart($data) {
-        $xTicks = array();
-        $values = array();
-        $totalCounts = array();
-        $itemsByDate = array();
-        $top5 = array();
-        
-        if (!empty($data)) {
-            // Get complete totals for every possible value over the date range
-            foreach ($data as $dateRow) {
-                $items = unserialize($dateRow['update_counts']['count']);
-                foreach ($items as $item => $count) {
-                    if (!is_array($count)) {
-                        if (!empty($totalCounts[$item]))
-                            $totalCounts[$item] += $count;
-                        else
-                            $totalCounts[$item] = $count;
-                        
-                        $itemsByDate[$item][$dateRow['update_counts']['date']] = $count;
-                    }
-                    else {
-                        if (empty($appNames))
-                            $appNames = $this->Application->getGUIDList();
-                        $appName = !empty($appNames[$item]) ? $appNames[$item] : 'Unknown App '.$item;
-                        
-                        // If an array, loop through applications to get versions
-                        foreach ($count as $appVersion => $versionCount) {
-                            $appItem = "{$appName} {$appVersion}";
-                            if (!empty($totalCounts[$appItem]))
-                                $totalCounts[$appItem] += $versionCount;
-                            else
-                                $totalCounts[$appItem] = $versionCount;
-                            
-                            $itemsByDate[$appItem][$dateRow['update_counts']['date']] = $versionCount;
-                        }
-                    }
-                }
-            }
-            
-            // Sort by total count
-            arsort($totalCounts);
-            
-            // Pull top 5 for graph
-            $i = 0;
-            foreach ($totalCounts as $value => $totalCount) {
-                if ($i >= 6)
-                    break;
-                
-                $top5[] = $value;
-                $values[$value] = array();
-                $i++;
-            }
-            
-            // Add points for each date
-            $labelRate = ceil(count($data) / 20);
-            $labelNum = 1;
-            foreach ($data as $k => $dateRow) {
-                if ($labelNum == 1)
-                    $label = date('n/j', strtotime($dateRow['update_counts']['date']));
-                else
-                    $label = '';
-                
-                $xTicks[$k] = '{v:'.$k.', label:"'.$label.'"}';
-                foreach ($top5 as $item) {
-                    $count = !empty($itemsByDate[$item][$dateRow['update_counts']['date']]) ? $itemsByDate[$item][$dateRow['update_counts']['date']] : 0;
-                    $values[$item][$k] = "[{$k}, {$count}]";
-                }
-                
-                if ($labelNum >= $labelRate)
-                    $labelNum = 1;
-                else
-                    $labelNum++;
-            }
-        }
-        
-        return array($xTicks, $values);
-    }
-    
-    function _pieChart($data, $totalCount) {
-        $xTicks = array();
-        $values = array();
-        $fullList = array();
-        
-        if (!empty($data)) {
-            $items = unserialize($data);
-            
-            arsort($items);
-            $i = 0;
-            $otherCount = 0;
-            foreach ($items as $item => $count) {
-                $percentage = ($count / $totalCount) * 100;
-                if ($percentage >= 1) {
-                    $xTicks[$i] = '{v:'.$i.', label:"'.$item.'"}';
-                    $values[$i] = "[{$i}, {$count}]";
-                }
-                else
-                    $otherCount += $count;
-                
-                $fullList[] = '{label:"'.$item.'", count:'.$count.', percentage:'.round($percentage, 2).'}';
-                $i++;
-            }
-            
-            if ($otherCount > 0) {
-                $xTicks[$i] = '{v:'.$i.', label:"Other"}';
-                $values[$i] = "[{$i}, {$otherCount}]";
-            }
-        }
-        
-        return array($xTicks, $values, $fullList);
-    }
-
-    function feedback() {
-        $subject = 'Statistics Dashboard Feedback';
-        $body = 'Feedback Type: '.$_POST['type'];
-        $body .= "\nE-mail: ".(!empty($_POST['email']) ? $_POST['email'] : 'Not given');
-        $body .= "\nRelevant chart: ".(!empty($_POST['chart']) ? $_POST['chart'] : 'None');
-        $body .= "\nComments:\n";
-        $body .= $_POST['comments'];
-        
-        mail('amo-developers@mozilla.org', $subject, $body, "From: Filliam H.  Muffman <nobody@mozilla.org>\r\n");
-        
-        exit;
-    }
-}
-
-?>