1: <?php
2: /**
3: * Magento
4: *
5: * NOTICE OF LICENSE
6: *
7: * This source file is subject to the Open Software License (OSL 3.0)
8: * that is bundled with this package in the file LICENSE.txt.
9: * It is also available through the world-wide-web at this URL:
10: * http://opensource.org/licenses/osl-3.0.php
11: * If you did not receive a copy of the license and are unable to
12: * obtain it through the world-wide-web, please send an email
13: * to license@magentocommerce.com so we can send you a copy immediately.
14: *
15: * DISCLAIMER
16: *
17: * Do not edit or add to this file if you wish to upgrade Magento to newer
18: * versions in the future. If you wish to customize Magento for your
19: * needs please refer to http://www.magentocommerce.com for more information.
20: *
21: * @category Mage
22: * @package Mage_Sales
23: * @copyright Copyright (c) 2012 Magento Inc. (http://www.magentocommerce.com)
24: * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)
25: */
26:
27:
28: /**
29: * Sales Mysql resource helper model
30: *
31: * @category Mage
32: * @package Mage_Sales
33: * @author Magento Core Team <core@magentocommerce.com>
34: */
35: class Mage_Sales_Model_Resource_Helper_Mysql4 extends Mage_Core_Model_Resource_Helper_Mysql4
36: implements Mage_Sales_Model_Resource_Helper_Interface
37: {
38: /**
39: * Update rating position
40: *
41: * @param string $aggregation One of Mage_Sales_Model_Resource_Report_Bestsellers::AGGREGATION_XXX constants
42: * @param array $aggregationAliases
43: * @param string $mainTable
44: * @param string $aggregationTable
45: * @return Mage_Sales_Model_Resource_Helper_Abstract
46: */
47: public function getBestsellersReportUpdateRatingPos($aggregation, $aggregationAliases,
48: $mainTable, $aggregationTable
49: ) {
50: /** @var $reportsResourceHelper Mage_Reports_Model_Resource_Helper_Interface */
51: $reportsResourceHelper = Mage::getResourceHelper('reports');
52:
53: if ($aggregation == $aggregationAliases['monthly']) {
54: $reportsResourceHelper
55: ->updateReportRatingPos('month', 'qty_ordered', $mainTable, $aggregationTable);
56: } elseif ($aggregation == $aggregationAliases['yearly']) {
57: $reportsResourceHelper
58: ->updateReportRatingPos('year', 'qty_ordered', $mainTable, $aggregationTable);
59: } else {
60: $reportsResourceHelper
61: ->updateReportRatingPos('day', 'qty_ordered', $mainTable, $aggregationTable);
62: }
63:
64: return $this;
65: }
66: }
67: