HusseyCoding_CustomOrderGrid - Version 1.1.4

Version Notes

Logic fix for installs using table prefix.

Download this release

Release Info

Developer Hussey Coding
Extension HusseyCoding_CustomOrderGrid
Version 1.1.4
Comparing to
See all releases


Code changes from version 1.1.3 to 1.1.4

app/code/community/HusseyCoding/CustomOrderGrid/Model/Observer.php CHANGED
@@ -94,9 +94,10 @@ class HusseyCoding_CustomOrderGrid_Model_Observer extends Varien_Event_Observer
94
  endif;
95
 
96
  if (in_array('sku', $selected) || in_array('name', $selected)):
97
- $select->joinLeft('sales_flat_order_item',
98
- 'sales_flat_order_item.order_id = main_table.entity_id AND sales_flat_order_item.product_type = "simple"',
99
- array('sku' => new Zend_Db_Expr('GROUP_CONCAT(sales_flat_order_item.sku SEPARATOR ", ")'), 'name' => new Zend_Db_Expr('GROUP_CONCAT(sales_flat_order_item.name SEPARATOR ", ")'))
 
100
  );
101
  $select->group('main_table.entity_id');
102
  endif;
94
  endif;
95
 
96
  if (in_array('sku', $selected) || in_array('name', $selected)):
97
+ $select->joinLeft(
98
+ array('items' => $resource->getTableName('sales/order_item')),
99
+ 'items.order_id = main_table.entity_id AND items.product_type = "simple"',
100
+ array('sku' => new Zend_Db_Expr('GROUP_CONCAT(items.sku SEPARATOR ", ")'), 'name' => new Zend_Db_Expr('GROUP_CONCAT(items.name SEPARATOR ", ")'))
101
  );
102
  $select->group('main_table.entity_id');
103
  endif;
app/code/community/HusseyCoding/CustomOrderGrid/etc/config.xml CHANGED
@@ -2,7 +2,7 @@
2
  <config>
3
  <modules>
4
  <HusseyCoding_CustomOrderGrid>
5
- <version>1.1.3</version>
6
  </HusseyCoding_CustomOrderGrid>
7
  </modules>
8
  <global>
2
  <config>
3
  <modules>
4
  <HusseyCoding_CustomOrderGrid>
5
+ <version>1.1.4</version>
6
  </HusseyCoding_CustomOrderGrid>
7
  </modules>
8
  <global>
package.xml CHANGED
@@ -1,7 +1,7 @@
1
  <?xml version="1.0"?>
2
  <package>
3
  <name>HusseyCoding_CustomOrderGrid</name>
4
- <version>1.1.3</version>
5
  <stability>stable</stability>
6
  <license uri="http://opensource.org/licenses/osl-3.0.php">Open Software License (OSL)</license>
7
  <channel>community</channel>
@@ -10,11 +10,11 @@
10
  <description>Fully customise your Magento admin order grid with Custom Order Grid.&#xD;
11
  &#xD;
12
  This extension allows you to fully customise and sort the order of columns displayed in the admin order grid. It also gives full sorting and filtering capability for all of these columns.</description>
13
- <notes>Reworked extension to use observers instead of rewrites.</notes>
14
  <authors><author><name>Hussey Coding</name><user>husseycoding</user><email>info@husseycoding.co.uk</email></author></authors>
15
- <date>2015-10-16</date>
16
- <time>12:33:01</time>
17
- <contents><target name="magecommunity"><dir name="HusseyCoding"><dir name="CustomOrderGrid"><dir name="Block"><dir name="Sales"><dir name="Order"><dir name="Grid"><dir name="Renderer"><file name="TrackingNumber.php" hash="563be82efb84dd74f6e81ca4cb1ef831"/></dir></dir></dir></dir></dir><dir name="etc"><file name="adminhtml.xml" hash="d396189f4d2de7db2e93919693b12f48"/><file name="config.xml" hash="cdd59f682a352e15160a7c9c5988a8e2"/><file name="system.xml" hash="5a39bb373b18c81ffcede9da2d28a9f1"/></dir><dir name="Helper"><file name="Data.php" hash="9c4c8447a849b4c23e70f8a492a4dd18"/></dir><dir name="Model"><file name="Observer.php" hash="46f70db7331f792aeb200ac54bd03c4c"/><dir name="System"><dir name="Config"><dir name="Source"><file name="Columns.php" hash="431aa07c84b5bb8bea9b4e4f738d2ddd"/><file name="Direction.php" hash="c0e3e328ac9960f9e6d53a8447a24ce2"/><file name="Sort.php" hash="065b1a959eeaa73da03f6794c783e549"/></dir></dir></dir></dir></dir><dir name="Common"><dir name="etc"><file name="system.xml" hash="6c9ba9f227b9adfc9abf97f17b46fdbf"/></dir></dir></dir></target><target name="mageetc"><dir name="modules"><file name="HusseyCoding_CustomOrderGrid.xml" hash="89294e8741d10cfcc680a4a1e7ed4e56"/><file name="HusseyCoding_Common.xml" hash="31e82d3d9b3179c2fa9e002f9669da47"/></dir></target><target name="magedesign"><dir name="adminhtml"><dir name="default"><dir name="default"><dir name="layout"><file name="customordergrid.xml" hash="5210c598b88e2dc6975eaa2936b1c08a"/></dir></dir></dir></dir></target><target name="mageskin"><dir name="adminhtml"><dir name="default"><dir name="default"><dir name="customordergrid"><dir name="js"><file name="customordergrid.js" hash="f02aad55b3a3e46e86149c4c09ee6f7e"/></dir></dir></dir></dir></dir></target></contents>
18
  <compatible/>
19
  <dependencies><required><php><min>5.1.0</min><max>6.0.0</max></php></required></dependencies>
20
  </package>
1
  <?xml version="1.0"?>
2
  <package>
3
  <name>HusseyCoding_CustomOrderGrid</name>
4
+ <version>1.1.4</version>
5
  <stability>stable</stability>
6
  <license uri="http://opensource.org/licenses/osl-3.0.php">Open Software License (OSL)</license>
7
  <channel>community</channel>
10
  <description>Fully customise your Magento admin order grid with Custom Order Grid.&#xD;
11
  &#xD;
12
  This extension allows you to fully customise and sort the order of columns displayed in the admin order grid. It also gives full sorting and filtering capability for all of these columns.</description>
13
+ <notes>Logic fix for installs using table prefix.</notes>
14
  <authors><author><name>Hussey Coding</name><user>husseycoding</user><email>info@husseycoding.co.uk</email></author></authors>
15
+ <date>2016-02-23</date>
16
+ <time>09:54:00</time>
17
+ <contents><target name="magecommunity"><dir name="HusseyCoding"><dir name="CustomOrderGrid"><dir name="Block"><dir name="Sales"><dir name="Order"><dir name="Grid"><dir name="Renderer"><file name="TrackingNumber.php" hash="563be82efb84dd74f6e81ca4cb1ef831"/></dir></dir></dir></dir></dir><dir name="etc"><file name="adminhtml.xml" hash="d396189f4d2de7db2e93919693b12f48"/><file name="config.xml" hash="278e1223f17daaafe946c302b86a0560"/><file name="system.xml" hash="5a39bb373b18c81ffcede9da2d28a9f1"/></dir><dir name="Helper"><file name="Data.php" hash="9c4c8447a849b4c23e70f8a492a4dd18"/></dir><dir name="Model"><file name="Observer.php" hash="1cc495286c3cd5e99aac13c2a0c757e5"/><dir name="System"><dir name="Config"><dir name="Source"><file name="Columns.php" hash="431aa07c84b5bb8bea9b4e4f738d2ddd"/><file name="Direction.php" hash="c0e3e328ac9960f9e6d53a8447a24ce2"/><file name="Sort.php" hash="065b1a959eeaa73da03f6794c783e549"/></dir></dir></dir></dir></dir><dir name="Common"><dir name="etc"><file name="system.xml" hash="6c9ba9f227b9adfc9abf97f17b46fdbf"/></dir></dir></dir></target><target name="mageetc"><dir name="modules"><file name="HusseyCoding_CustomOrderGrid.xml" hash="89294e8741d10cfcc680a4a1e7ed4e56"/><file name="HusseyCoding_Common.xml" hash="31e82d3d9b3179c2fa9e002f9669da47"/></dir></target><target name="magedesign"><dir name="adminhtml"><dir name="default"><dir name="default"><dir name="layout"><file name="customordergrid.xml" hash="5210c598b88e2dc6975eaa2936b1c08a"/></dir></dir></dir></dir></target><target name="mageskin"><dir name="adminhtml"><dir name="default"><dir name="default"><dir name="customordergrid"><dir name="js"><file name="customordergrid.js" hash="f02aad55b3a3e46e86149c4c09ee6f7e"/></dir></dir></dir></dir></dir></target></contents>
18
  <compatible/>
19
  <dependencies><required><php><min>5.1.0</min><max>6.0.0</max></php></required></dependencies>
20
  </package>