Minubo_Interface - Version 1.1.28

Version Notes

Bugfix Categories & ProductCategories with Multi-Store-IDs; Bugfix Customers

Download this release

Release Info

Developer sven rothe
Extension Minubo_Interface
Version 1.1.28
Comparing to
See all releases


Code changes from version 1.1.27 to 1.1.28

Files changed (4) hide show
  1. app/code/community/Minubo/Interface/Model/Mysql4/Orderaddresses.php +3 -3
  2. app/code/community/Minubo/Interface/controllers/ExportController.php +28 -26
  3. app/code/community/Minubo/Interface/etc/config.xml +1 -1
  4. package.xml +5 -5
app/code/community/Minubo/Interface/Model/Mysql4/Orderaddresses.php CHANGED
@@ -36,7 +36,7 @@ public function loadByField($field,$value){
36
  ->from(array('oab'=>$table))
37
  ->join(array('o'=>$table2), $cond2)
38
  ->join(array('oas'=>$table3), $cond3)
39
- ->join(array('cg'=>$table4), $cond2)
40
  ->reset('columns')
41
  ->columns($this->getColumns())
42
  ->where($where);
@@ -57,7 +57,7 @@ public function loadAllByStoreId($store_id){
57
  ->from(array('oab'=>$table))
58
  ->join(array('o'=>$table2), $cond2)
59
  ->join(array('oas'=>$table3), $cond3)
60
- ->join(array('cg'=>$table4), $cond2)
61
  ->reset('columns')
62
  ->columns($this->getColumns())
63
  ->where($where)
@@ -78,7 +78,7 @@ public function loadLimitedByStoreId($limit, $offset, $store_id){
78
  ->from(array('oab'=>$table))
79
  ->join(array('o'=>$table2), $cond2)
80
  ->join(array('oas'=>$table3), $cond3)
81
- ->join(array('cg'=>$table4), $cond2)
82
  ->reset('columns')
83
  ->columns($this->getColumns())
84
  ->where($where)
36
  ->from(array('oab'=>$table))
37
  ->join(array('o'=>$table2), $cond2)
38
  ->join(array('oas'=>$table3), $cond3)
39
+ ->join(array('cg'=>$table4), $cond4)
40
  ->reset('columns')
41
  ->columns($this->getColumns())
42
  ->where($where);
57
  ->from(array('oab'=>$table))
58
  ->join(array('o'=>$table2), $cond2)
59
  ->join(array('oas'=>$table3), $cond3)
60
+ ->join(array('cg'=>$table4), $cond4)
61
  ->reset('columns')
62
  ->columns($this->getColumns())
63
  ->where($where)
78
  ->from(array('oab'=>$table))
79
  ->join(array('o'=>$table2), $cond2)
80
  ->join(array('oas'=>$table3), $cond3)
81
+ ->join(array('cg'=>$table4), $cond4)
82
  ->reset('columns')
83
  ->columns($this->getColumns())
84
  ->where($where)
app/code/community/Minubo/Interface/controllers/ExportController.php CHANGED
@@ -18,10 +18,10 @@
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 Minubo
22
  * @package Minubo_Interface
23
- * @copyright Copyright (c) 2013 Minubo (http://www.minubo.com)
24
- * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)
25
  * @author Sven Rothe <sven@minubo.com>
26
  * */
27
  class Minubo_Interface_ExportController extends Mage_Core_Controller_Front_Action
@@ -127,11 +127,11 @@ class Minubo_Interface_ExportController extends Mage_Core_Controller_Front_Actio
127
  $mtime = microtime();
128
  $mtime = explode(' ', $mtime);
129
  return doubleval($mtime[1]) + doubleval($mtime[0]);
130
- }
131
 
132
- public function getStartlog() {
133
- return $this->getMicrotime();
134
- }
135
 
136
  public function getEndlog($start) {
137
  return '<br># runtime: '.abs($this->getMicrotime()-$start).'<br>'.
@@ -139,7 +139,7 @@ class Minubo_Interface_ExportController extends Mage_Core_Controller_Front_Actio
139
  '# memory_get_usage(false): '.memory_get_usage(false).'<br>'.
140
  '# memory_get_peak_usage(true): '.memory_get_peak_usage(true).'<br>'.
141
  '# memory_get_peak_usage(false): '.memory_get_peak_usage(false).'<br>';
142
- }
143
 
144
  function getParam(&$lastChangeDate, &$maxChangeDate, &$lastOrderID, &$maxOrderID, &$limit, &$offset, &$debug, &$pdata, &$store_id, &$download, $nolog = false) {
145
 
@@ -280,14 +280,14 @@ class Minubo_Interface_ExportController extends Mage_Core_Controller_Front_Actio
280
  {
281
  $renameCols = array('entity_id' => 'category_id');
282
  $colTitles = array('Category_Id','Parent_Id','Position','Category_Name','level','image','url_key','url_path');
283
- $this->handleTable ('categories', 'category', 'categories', $colTitles, Array(), $renameCols, true);
284
  }
285
 
286
  public function productcategoriesAction ()
287
  {
288
  $skipCols = array('is_parent');
289
  $colTitles = array('category_id','product_id','position','store_id','visibility');
290
- $this->handleTable ('productcategories', 'productcategory', 'productcategories', $colTitles, $skipCols, Array(), true);
291
  }
292
 
293
  public function productattributesAction ()
@@ -327,7 +327,7 @@ class Minubo_Interface_ExportController extends Mage_Core_Controller_Front_Actio
327
  $this->handleTable ( 'invoiceitems', 'invoiceitem', 'invoiceitems', Array(), Array(), Array(), true);
328
  }
329
 
330
- public function handleTable ($sqlinterface, $filename, $type, $colTitles = Array(), $skipCols = Array(), $renameCols = Array(), $appendStoreId = false)
331
  {
332
  $start = $this->getMicrotime();
333
  $this->getParam($lastChangeDate, $maxChangeDate, $lastOrderID, $maxOrderID, $limit, $offset, $debug, $pdata, $store_id, $download);
@@ -342,15 +342,17 @@ class Minubo_Interface_ExportController extends Mage_Core_Controller_Front_Actio
342
  if($appendStoreId):
343
  if($debug) echo 'readLimitedByStoreId: '.$limit.'/'.$offset.'/'.$store_id.'<br>';
344
  $store_ids = explode(',', $store_id);
345
- if (count($store_ids)==1) {
346
- $rows = $model->readLimitedByStoreId($limit, $offset, $store_id);
347
- } else {
348
- $rows = $model->readLimitedByStoreId($limit, $offset, $store_ids[0]);
349
- for($i=1; $i<count($store_ids); $i++) {
350
- $rows2 = $model->readLimitedByStoreId($limit, $offset, $store_ids[$i]);
351
- $rows = array_merge($rows, $rows2);
352
- }
353
- }
 
 
354
  else:
355
  if($debug) echo 'readLimited: '.$limit.'/'.$offset.'<br>';
356
  $rows = $model->readLimited($limit, $offset);
@@ -359,15 +361,15 @@ class Minubo_Interface_ExportController extends Mage_Core_Controller_Front_Actio
359
  if($appendStoreId):
360
  if($debug) echo 'readAllByStoreId: '.$store_id.'<br>';
361
  $store_ids = explode(',', $store_id);
362
- if (count($store_ids)==1) {
363
  $rows = $model->readAllByStoreId($store_id);
364
- } else {
365
  $rows = $model->readAllByStoreId($store_ids[0]);
366
- for($i=1; $i<count($store_ids); $i++) {
367
  $rows2 = $model->readAllByStoreId($store_ids[$i]);
368
- $rows = array_merge($rows, $rows2);
369
- }
370
- }
371
  else:
372
  if($debug) echo 'readAll<br>';
373
  $rows = $model->readAll();
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 Minubo
22
  * @package Minubo_Interface
23
+ * @copyright Copyright (c) 2013 Minubo (http://www.minubo.com)
24
+ * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)
25
  * @author Sven Rothe <sven@minubo.com>
26
  * */
27
  class Minubo_Interface_ExportController extends Mage_Core_Controller_Front_Action
127
  $mtime = microtime();
128
  $mtime = explode(' ', $mtime);
129
  return doubleval($mtime[1]) + doubleval($mtime[0]);
130
+ }
131
 
132
+ public function getStartlog() {
133
+ return $this->getMicrotime();
134
+ }
135
 
136
  public function getEndlog($start) {
137
  return '<br># runtime: '.abs($this->getMicrotime()-$start).'<br>'.
139
  '# memory_get_usage(false): '.memory_get_usage(false).'<br>'.
140
  '# memory_get_peak_usage(true): '.memory_get_peak_usage(true).'<br>'.
141
  '# memory_get_peak_usage(false): '.memory_get_peak_usage(false).'<br>';
142
+ }
143
 
144
  function getParam(&$lastChangeDate, &$maxChangeDate, &$lastOrderID, &$maxOrderID, &$limit, &$offset, &$debug, &$pdata, &$store_id, &$download, $nolog = false) {
145
 
280
  {
281
  $renameCols = array('entity_id' => 'category_id');
282
  $colTitles = array('Category_Id','Parent_Id','Position','Category_Name','level','image','url_key','url_path');
283
+ $this->handleTable ('categories', 'category', 'categories', $colTitles, Array(), $renameCols, true, true);
284
  }
285
 
286
  public function productcategoriesAction ()
287
  {
288
  $skipCols = array('is_parent');
289
  $colTitles = array('category_id','product_id','position','store_id','visibility');
290
+ $this->handleTable ('productcategories', 'productcategory', 'productcategories', $colTitles, $skipCols, Array(), true, true);
291
  }
292
 
293
  public function productattributesAction ()
327
  $this->handleTable ( 'invoiceitems', 'invoiceitem', 'invoiceitems', Array(), Array(), Array(), true);
328
  }
329
 
330
+ public function handleTable ($sqlinterface, $filename, $type, $colTitles = Array(), $skipCols = Array(), $renameCols = Array(), $appendStoreId = false, $onlyFirstStoreId = false)
331
  {
332
  $start = $this->getMicrotime();
333
  $this->getParam($lastChangeDate, $maxChangeDate, $lastOrderID, $maxOrderID, $limit, $offset, $debug, $pdata, $store_id, $download);
342
  if($appendStoreId):
343
  if($debug) echo 'readLimitedByStoreId: '.$limit.'/'.$offset.'/'.$store_id.'<br>';
344
  $store_ids = explode(',', $store_id);
345
+ if (count($store_ids)==1) {
346
+ $rows = $model->readLimitedByStoreId($limit, $offset, $store_id);
347
+ } else {
348
+ $rows = $model->readLimitedByStoreId($limit, $offset, $store_ids[0]);
349
+ if(!$onlyFirstStoreId) {
350
+ for($i=1; $i<count($store_ids); $i++) {
351
+ $rows2 = $model->readLimitedByStoreId($limit, $offset, $store_ids[$i]);
352
+ $rows = array_merge($rows, $rows2);
353
+ }
354
+ }
355
+ }
356
  else:
357
  if($debug) echo 'readLimited: '.$limit.'/'.$offset.'<br>';
358
  $rows = $model->readLimited($limit, $offset);
361
  if($appendStoreId):
362
  if($debug) echo 'readAllByStoreId: '.$store_id.'<br>';
363
  $store_ids = explode(',', $store_id);
364
+ if (count($store_ids)==1) {
365
  $rows = $model->readAllByStoreId($store_id);
366
+ } else {
367
  $rows = $model->readAllByStoreId($store_ids[0]);
368
+ for($i=1; $i<count($store_ids); $i++) {
369
  $rows2 = $model->readAllByStoreId($store_ids[$i]);
370
+ $rows = array_merge($rows, $rows2);
371
+ }
372
+ }
373
  else:
374
  if($debug) echo 'readAll<br>';
375
  $rows = $model->readAll();
app/code/community/Minubo/Interface/etc/config.xml CHANGED
@@ -2,7 +2,7 @@
2
  <config>
3
  <modules>
4
  <Minubo_Interface>
5
- <version>1.1.27</version>
6
  </Minubo_Interface>
7
  </modules>
8
  <global>
2
  <config>
3
  <modules>
4
  <Minubo_Interface>
5
+ <version>1.1.28</version>
6
  </Minubo_Interface>
7
  </modules>
8
  <global>
package.xml CHANGED
@@ -1,18 +1,18 @@
1
  <?xml version="1.0"?>
2
  <package>
3
  <name>Minubo_Interface</name>
4
- <version>1.1.27</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>
8
  <extends/>
9
  <summary>Minubo Interface connects your Magento Shop to the All-In-One eCommerce Cloud BI Solution at minubo.com</summary>
10
  <description>Minubo Interface connects your Magento Shop to the All-In-One eCommerce Cloud BI Solution at minubo.com. With this Extension in your Magento Shop your minubo Account at minubo.com can be configured to poll the newest data - of cause without any personalization - every day to bring the information to your screen, which you need to optimize your sales business. See more about minubo at minubo.com Minubo Interface supports Magento 1.5 (or newer). In Backend you can configure the Minubo Interface at System/Configuration/Sales/Minubo Interface (enable/disable, generate access key and see information about last export). Right now, the Minubo Interface is at the end of beta status and you have to change in the Magento Connect Backend the setting to allow download of other than stable releases.</description>
11
- <notes>Customer-Adresses incl. CustomerGroupCode; corrected support link</notes>
12
  <authors><author><name>sven rothe</name><user>minubo</user><email>sven@minubo.com</email></author></authors>
13
- <date>2014-10-24</date>
14
- <time>14:19:41</time>
15
- <contents><target name="magecommunity"><dir name="Minubo"><dir name="Interface"><dir name="Block"><dir name="Adminhtml"><file name="Authhash.php" hash="c98e63efd5e4e42a6bc1c223a75176c3"/><file name="Lastchangedate.php" hash="c82ee55fad83d848f47a8594bd25c5af"/><dir name="System"><dir name="Config"><dir name="Form"><file name="Button.php" hash="c288b69aa22cc9ff5e978ff2b89646e9"/></dir></dir></dir><file name="Version.php" hash="31db32eca5dcaf3ad86c747bb3e11efc"/></dir></dir><dir name="Helper"><file name="Data.php" hash="d9cf690ff97d2014cd3e443c07ab4ea7"/></dir><dir name="Model"><dir name="Export"><file name="Abstractcsv.php" hash="94a1b9c669ff01892994faa507152f9c"/><file name="Csv.php" hash="c3788d63aaa16a83b2f280cfbd40c2f1"/><file name="Status.php" hash="cef67926aef558b87d4e3bcb02386743"/></dir><dir name="Mysql4"><file name="Categories.php" hash="7aaf0b687f5127bd07a2d7b0c8fb47ba"/><file name="Creditmemoitems.php" hash="c59bc4b0e25753bf458fee5583ca6d0a"/><file name="Creditmemos.php" hash="1f9106985961671c236853c563d6a49f"/><file name="Customeraddresses.php" hash="22abe6badaf89f6e172f5f36d7db38ed"/><file name="Customers.php" hash="0d4f8919dfdcc86106a462ca85446390"/><file name="Invoiceitems.php" hash="0273220176bcf5487b6975fbb485b1cd"/><file name="Invoices.php" hash="8f467284eadc5d1885d1df00d007fdd5"/><file name="Orderaddresses.php" hash="ebfd75af42a67bf0d203bc04967cdb50"/><file name="Orderitems.php" hash="75d14acbb7c45a369549bceb24b3c108"/><file name="Orders.php" hash="d961f9fd03eee6fe0efcfbd44d6a5c5d"/><file name="Productattributes.php" hash="6a4c275d6fabcfae4a901a78ba621856"/><file name="Productcategories.php" hash="56a00cecf2cfe994fdeae9db947f653d"/><file name="Products.php" hash="4b7ebada1f3f291058a356e1765243a3"/><file name="Regions.php" hash="f1575516572fbd9a58e8c025fefa95d4"/></dir><dir name="Options"><file name="Options.php" hash="b696a731d9daa7f53c8375f19ad3838f"/><file name="Version.php" hash="fafcca0d77fbbe7fb26b869a845963bf"/></dir><dir name="Read"><file name="Collections.php" hash="3fbc08cae92c333488d43b307a1a07a0"/><file name="Common.php" hash="18b089bb03cbb226b95db428a7c31ef2"/></dir><file name="Tables.php" hash="e0f2ee1d70cc61cac2ad428b09ecf6e7"/></dir><dir name="controllers"><file name="ExportController.php" hash="cd5563418250def3824fc87007763c60"/></dir><dir name="etc"><file name="adminhtml.xml" hash="375c548aacaf6f1bfdf4de3af7b29dfb"/><file name="config.xml" hash="af93a681c53e52bcaba77047f5bb3ca2"/><file name="system.xml" hash="2ebbd93c3bfaacfcd6530e6ccdfa4173"/></dir></dir></dir></target><target name="magedesign"><dir name="adminhtml"><dir name="default"><dir name="default"><dir name="template"><dir name="minubo"><dir name="system"><dir name="config"><file name="button.phtml" hash=""/></dir></dir></dir></dir></dir></dir></dir></target><target name="mageetc"><dir name="modules"><file name="Minubo_Interface.xml" hash=""/></dir></target></contents>
16
  <compatible/>
17
  <dependencies><required><php><min>5.1.0</min><max>6.0.0</max></php></required></dependencies>
18
  </package>
1
  <?xml version="1.0"?>
2
  <package>
3
  <name>Minubo_Interface</name>
4
+ <version>1.1.28</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>
8
  <extends/>
9
  <summary>Minubo Interface connects your Magento Shop to the All-In-One eCommerce Cloud BI Solution at minubo.com</summary>
10
  <description>Minubo Interface connects your Magento Shop to the All-In-One eCommerce Cloud BI Solution at minubo.com. With this Extension in your Magento Shop your minubo Account at minubo.com can be configured to poll the newest data - of cause without any personalization - every day to bring the information to your screen, which you need to optimize your sales business. See more about minubo at minubo.com Minubo Interface supports Magento 1.5 (or newer). In Backend you can configure the Minubo Interface at System/Configuration/Sales/Minubo Interface (enable/disable, generate access key and see information about last export). Right now, the Minubo Interface is at the end of beta status and you have to change in the Magento Connect Backend the setting to allow download of other than stable releases.</description>
11
+ <notes>Bugfix Categories &amp; ProductCategories with Multi-Store-IDs; Bugfix Customers</notes>
12
  <authors><author><name>sven rothe</name><user>minubo</user><email>sven@minubo.com</email></author></authors>
13
+ <date>2014-10-29</date>
14
+ <time>16:13:53</time>
15
+ <contents><target name="magecommunity"><dir name="Minubo"><dir name="Interface"><dir name="Block"><dir name="Adminhtml"><file name="Authhash.php" hash="c98e63efd5e4e42a6bc1c223a75176c3"/><file name="Lastchangedate.php" hash="c82ee55fad83d848f47a8594bd25c5af"/><dir name="System"><dir name="Config"><dir name="Form"><file name="Button.php" hash="c288b69aa22cc9ff5e978ff2b89646e9"/></dir></dir></dir><file name="Version.php" hash="31db32eca5dcaf3ad86c747bb3e11efc"/></dir></dir><dir name="Helper"><file name="Data.php" hash="d9cf690ff97d2014cd3e443c07ab4ea7"/></dir><dir name="Model"><dir name="Export"><file name="Abstractcsv.php" hash="94a1b9c669ff01892994faa507152f9c"/><file name="Csv.php" hash="c3788d63aaa16a83b2f280cfbd40c2f1"/><file name="Status.php" hash="cef67926aef558b87d4e3bcb02386743"/></dir><dir name="Mysql4"><file name="Categories.php" hash="7aaf0b687f5127bd07a2d7b0c8fb47ba"/><file name="Creditmemoitems.php" hash="c59bc4b0e25753bf458fee5583ca6d0a"/><file name="Creditmemos.php" hash="1f9106985961671c236853c563d6a49f"/><file name="Customeraddresses.php" hash="22abe6badaf89f6e172f5f36d7db38ed"/><file name="Customers.php" hash="0d4f8919dfdcc86106a462ca85446390"/><file name="Invoiceitems.php" hash="0273220176bcf5487b6975fbb485b1cd"/><file name="Invoices.php" hash="8f467284eadc5d1885d1df00d007fdd5"/><file name="Orderaddresses.php" hash="446ab372b4b4d136ddce5b1215428fca"/><file name="Orderitems.php" hash="75d14acbb7c45a369549bceb24b3c108"/><file name="Orders.php" hash="d961f9fd03eee6fe0efcfbd44d6a5c5d"/><file name="Productattributes.php" hash="6a4c275d6fabcfae4a901a78ba621856"/><file name="Productcategories.php" hash="56a00cecf2cfe994fdeae9db947f653d"/><file name="Products.php" hash="4b7ebada1f3f291058a356e1765243a3"/><file name="Regions.php" hash="f1575516572fbd9a58e8c025fefa95d4"/></dir><dir name="Options"><file name="Options.php" hash="b696a731d9daa7f53c8375f19ad3838f"/><file name="Version.php" hash="fafcca0d77fbbe7fb26b869a845963bf"/></dir><dir name="Read"><file name="Collections.php" hash="3fbc08cae92c333488d43b307a1a07a0"/><file name="Common.php" hash="18b089bb03cbb226b95db428a7c31ef2"/></dir><file name="Tables.php" hash="e0f2ee1d70cc61cac2ad428b09ecf6e7"/></dir><dir name="controllers"><file name="ExportController.php" hash="945542e0721fd5e1ac07502d31c503bb"/></dir><dir name="etc"><file name="adminhtml.xml" hash="375c548aacaf6f1bfdf4de3af7b29dfb"/><file name="config.xml" hash="c3a80d9e07cf3519495daf113a0628c1"/><file name="system.xml" hash="2ebbd93c3bfaacfcd6530e6ccdfa4173"/></dir></dir></dir></target><target name="magedesign"><dir name="adminhtml"><dir name="default"><dir name="default"><dir name="template"><dir name="minubo"><dir name="system"><dir name="config"><file name="button.phtml" hash=""/></dir></dir></dir></dir></dir></dir></dir></target><target name="mageetc"><dir name="modules"><file name="Minubo_Interface.xml" hash=""/></dir></target></contents>
16
  <compatible/>
17
  <dependencies><required><php><min>5.1.0</min><max>6.0.0</max></php></required></dependencies>
18
  </package>