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: * Flat sales order status history collection
29: *
30: * @category Mage
31: * @package Mage_Sales
32: * @author Magento Core Team <core@magentocommerce.com>
33: */
34: class Mage_Sales_Model_Resource_Order_Status_Collection extends Mage_Core_Model_Resource_Db_Collection_Abstract
35: {
36: /**
37: * Internal constructor
38: */
39: protected function _construct()
40: {
41: $this->_init('sales/order_status');
42: }
43:
44: /**
45: * Get collection data as options array
46: *
47: * @return array
48: */
49: public function toOptionArray()
50: {
51: return $this->_toOptionArray('status', 'label');
52: }
53:
54: /**
55: * Get collection data as options hash
56: *
57: * @return array
58: */
59: public function toOptionHash()
60: {
61: return $this->_toOptionHash('status', 'label');
62: }
63:
64: /**
65: * Join order states table
66: */
67: public function joinStates()
68: {
69: if (!$this->getFlag('states_joined')) {
70: $this->_idFieldName = 'status_state';
71: $this->getSelect()->joinLeft(
72: array('state_table' => $this->getTable('sales/order_status_state')),
73: 'main_table.status=state_table.status',
74: array('state', 'is_default')
75: );
76: $this->setFlag('states_joined', true);
77: }
78: return $this;
79: }
80:
81: /**
82: * add state code filter to collection
83: *
84: * @param string $state
85: */
86: public function addStateFilter($state)
87: {
88: $this->joinStates();
89: $this->getSelect()->where('state_table.state=?', $state);
90: return $this;
91: }
92:
93: /**
94: * Define label order
95: *
96: * @param string $dir
97: * @return Mage_Sales_Model_Mysql4_Order_Status_Collection
98: */
99: public function orderByLabel($dir = 'ASC')
100: {
101: $this->getSelect()->order('main_table.label '.$dir);
102: return $this;
103: }
104: }
105: