Minubo_Interface - Version 1.0.15

Version Notes

Software maintenance and minor bug-fixes.

Download this release

Release Info

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


Code changes from version 1.0.14 to 1.0.15

Files changed (14) hide show
  1. app/code/community/Minubo/Interface/Model/Mysql4/Categories.php +2 -2
  2. app/code/community/Minubo/Interface/Model/Mysql4/Creditmemoitems.php +15 -9
  3. app/code/community/Minubo/Interface/Model/Mysql4/Creditmemos.php +4 -4
  4. app/code/community/Minubo/Interface/Model/Mysql4/Customers.php +4 -4
  5. app/code/community/Minubo/Interface/Model/Mysql4/Invoiceitems.php +16 -9
  6. app/code/community/Minubo/Interface/Model/Mysql4/Invoices.php +4 -4
  7. app/code/community/Minubo/Interface/Model/Mysql4/Orderitems.php +30 -21
  8. app/code/community/Minubo/Interface/Model/Mysql4/Orders.php +16 -16
  9. app/code/community/Minubo/Interface/Model/Mysql4/Productcategories.php +4 -4
  10. app/code/community/Minubo/Interface/Model/Mysql4/Products.php +3 -3
  11. app/code/community/Minubo/Interface/Model/Tables.php +2 -2
  12. app/code/community/Minubo/Interface/controllers/ExportController.php +21 -22
  13. app/code/community/Minubo/Interface/etc/config.xml +5 -5
  14. package.xml +5 -5
app/code/community/Minubo/Interface/Model/Mysql4/Categories.php CHANGED
@@ -23,7 +23,7 @@ class Minubo_Interface_Model_Mysql4_Categories extends Mage_Core_Model_Mysql4_Ab
23
  return $id;
24
  }
25
 
26
- public function loadAllByStoreId($store_id=''){
27
  $table = str_replace('_1','_'.$store_id,$this->getMainTable());
28
  $where = $this->_getReadAdapter()->quoteInto("entity_id > ?", 0);
29
  $select = $this->_getReadAdapter()->select()->from($table)
@@ -34,7 +34,7 @@ class Minubo_Interface_Model_Mysql4_Categories extends Mage_Core_Model_Mysql4_Ab
34
  return $this->_getReadAdapter()->fetchAll($select);
35
  }
36
 
37
- public function loadLimitedByStoreId($limit, $offset, $store_id=''){
38
  $table = str_replace('_1','_'.$store_id,$this->getMainTable());
39
  $where = $this->_getReadAdapter()->quoteInto("entity_id > ?", 0);
40
  $select = $this->_getReadAdapter()->select()->from($table)
23
  return $id;
24
  }
25
 
26
+ public function loadAllByStoreId($store_id){
27
  $table = str_replace('_1','_'.$store_id,$this->getMainTable());
28
  $where = $this->_getReadAdapter()->quoteInto("entity_id > ?", 0);
29
  $select = $this->_getReadAdapter()->select()->from($table)
34
  return $this->_getReadAdapter()->fetchAll($select);
35
  }
36
 
37
+ public function loadLimitedByStoreId($limit, $offset, $store_id){
38
  $table = str_replace('_1','_'.$store_id,$this->getMainTable());
39
  $where = $this->_getReadAdapter()->quoteInto("entity_id > ?", 0);
40
  $select = $this->_getReadAdapter()->select()->from($table)
app/code/community/Minubo/Interface/Model/Mysql4/Creditmemoitems.php CHANGED
@@ -7,7 +7,7 @@ class Minubo_Interface_Model_Mysql4_Creditmemoitems extends Mage_Core_Model_Mysq
7
  }
8
 
9
  protected function getColumns() {
10
- return array('entity_id','parent_id','weee_tax_applied_row_amount','base_price','base_weee_tax_row_disposition','tax_amount','base_weee_tax_applied_amount','weee_tax_row_disposition','base_row_total','discount_amount','row_total','weee_tax_applied_amount','base_discount_amount','base_weee_tax_disposition','price_incl_tax','base_tax_amount','weee_tax_disposition','base_price_incl_tax','qty','base_cost','base_weee_tax_applied_row_amnt','price','base_row_total_incl_tax','row_total_incl_tax','product_id','order_item_id','additional_data','description','weee_tax_applied','sku','name','hidden_tax_amount','base_hidden_tax_amount');
11
  }
12
 
13
  public function loadByField($field,$value){
@@ -21,26 +21,32 @@ class Minubo_Interface_Model_Mysql4_Creditmemoitems extends Mage_Core_Model_Mysq
21
  return $id;
22
  }
23
 
24
- public function loadAll(){
25
  $table = $this->getMainTable();
26
- $where = $this->_getReadAdapter()->quoteInto("entity_id > ?", 0);
27
- $select = $this->_getReadAdapter()->select()->from($table)
 
 
 
28
  ->reset('columns')
29
  ->columns($this->getColumns())
30
  ->where($where)
31
- ->order('entity_id');
32
  return $this->_getReadAdapter()->fetchAll($select);
33
  }
34
 
35
- public function loadLimited($limit, $offset){
36
  $table = $this->getMainTable();
37
- $where = $this->_getReadAdapter()->quoteInto("entity_id > ?", 0);
38
- $select = $this->_getReadAdapter()->select()->from($table)
 
 
 
39
  ->reset('columns')
40
  ->columns($this->getColumns())
41
  ->where($where)
42
  ->limit($limit, $offset)
43
- ->order('entity_id');
44
  return $this->_getReadAdapter()->fetchAll($select);
45
  }
46
 
7
  }
8
 
9
  protected function getColumns() {
10
+ return array('cp.entity_id','cp.parent_id','cp.weee_tax_applied_row_amount','cp.base_price','cp.base_weee_tax_row_disposition','cp.tax_amount','cp.base_weee_tax_applied_amount','cp.weee_tax_row_disposition','cp.base_row_total','cp.discount_amount','cp.row_total','cp.weee_tax_applied_amount','cp.base_discount_amount','cp.base_weee_tax_disposition','cp.price_incl_tax','cp.base_tax_amount','cp.weee_tax_disposition','cp.base_price_incl_tax','cp.qty','cp.base_cost','cp.base_weee_tax_applied_row_amnt','cp.price','cp.base_row_total_incl_tax','cp.row_total_incl_tax','cp.product_id','cp.order_item_id','cp.additional_data','cp.description','cp.weee_tax_applied','cp.sku','cp.name','cp.hidden_tax_amount','cp.base_hidden_tax_amount','c.store_id');
11
  }
12
 
13
  public function loadByField($field,$value){
21
  return $id;
22
  }
23
 
24
+ public function loadAllByStoreId($store_id){
25
  $table = $this->getMainTable();
26
+ $tableHeader = $this->getTable('creditmemos');
27
+ $condHeader = $this->_getReadAdapter()->quoteInto('cp.parent_id = c.entity_id','');
28
+ $where = $this->_getReadAdapter()->quoteInto("c.store_id = ?", $store_id);
29
+ $select = $this->_getReadAdapter()->select()->from(array('cp'=>$table))
30
+ ->join(array('c'=>$tableHeader), $condHeader)
31
  ->reset('columns')
32
  ->columns($this->getColumns())
33
  ->where($where)
34
+ ->order('cp.entity_id');
35
  return $this->_getReadAdapter()->fetchAll($select);
36
  }
37
 
38
+ public function loadLimitedByStoreId($limit, $offset, $store_id){
39
  $table = $this->getMainTable();
40
+ $tableHeader = $this->getTable('creditmemos');
41
+ $condHeader = $this->_getReadAdapter()->quoteInto('cp.parent_id = c.entity_id','');
42
+ $where = $this->_getReadAdapter()->quoteInto("c.store_id = ?", $store_id);
43
+ $select = $this->_getReadAdapter()->select()->from(array('cp'=>$table))
44
+ ->join(array('c'=>$tableHeader), $condHeader)
45
  ->reset('columns')
46
  ->columns($this->getColumns())
47
  ->where($where)
48
  ->limit($limit, $offset)
49
+ ->order('cp.entity_id');
50
  return $this->_getReadAdapter()->fetchAll($select);
51
  }
52
 
app/code/community/Minubo/Interface/Model/Mysql4/Creditmemos.php CHANGED
@@ -28,9 +28,9 @@ class Minubo_Interface_Model_Mysql4_Creditmemos extends Mage_Core_Model_Mysql4_A
28
  return $id;
29
  }
30
 
31
- public function loadAll(){
32
  $table = $this->getMainTable();
33
- $where = $this->_getReadAdapter()->quoteInto("entity_id > ?", 0);
34
  $select = $this->_getReadAdapter()->select()->from($table)
35
  ->reset('columns')
36
  ->columns($this->getColumns())
@@ -39,9 +39,9 @@ class Minubo_Interface_Model_Mysql4_Creditmemos extends Mage_Core_Model_Mysql4_A
39
  return $this->_getReadAdapter()->fetchAll($select);
40
  }
41
 
42
- public function loadLimited($limit, $offset){
43
  $table = $this->getMainTable();
44
- $where = $this->_getReadAdapter()->quoteInto("entity_id > ?", 0);
45
  $select = $this->_getReadAdapter()->select()->from($table)
46
  ->reset('columns')
47
  ->columns($this->getColumns())
28
  return $id;
29
  }
30
 
31
+ public function loadAllByStoreId($store_id){
32
  $table = $this->getMainTable();
33
+ $where = $this->_getReadAdapter()->quoteInto("store_id = ?", $store_id);
34
  $select = $this->_getReadAdapter()->select()->from($table)
35
  ->reset('columns')
36
  ->columns($this->getColumns())
39
  return $this->_getReadAdapter()->fetchAll($select);
40
  }
41
 
42
+ public function loadLimitedByStoreId($limit, $offset, $store_id){
43
  $table = $this->getMainTable();
44
+ $where = $this->_getReadAdapter()->quoteInto("store_id = ?", $store_id);
45
  $select = $this->_getReadAdapter()->select()->from($table)
46
  ->reset('columns')
47
  ->columns($this->getColumns())
app/code/community/Minubo/Interface/Model/Mysql4/Customers.php CHANGED
@@ -24,11 +24,11 @@ class Minubo_Interface_Model_Mysql4_Customers extends Mage_Core_Model_Mysql4_Abs
24
  return $id;
25
  }
26
 
27
- public function loadAll(){
28
  $table = $this->getMainTable();
29
  $table2 = $this->getTable('customer_group');
30
  $cond2 = $this->_getReadAdapter()->quoteInto('c.group_id = cg.customer_group_id','');
31
- $where = $this->_getReadAdapter()->quoteInto("c.entity_id > ?", 0);
32
  $select = $this->_getReadAdapter()->select()->from(array('c'=>$table))
33
  ->join(array('cg'=>$table2), $cond2)
34
  ->reset('columns')
@@ -38,11 +38,11 @@ class Minubo_Interface_Model_Mysql4_Customers extends Mage_Core_Model_Mysql4_Abs
38
  return $this->_getReadAdapter()->fetchAll($select);
39
  }
40
 
41
- public function loadLimited($limit, $offset){
42
  $table = $this->getMainTable();
43
  $table2 = $this->getTable('customer_group');
44
  $cond2 = $this->_getReadAdapter()->quoteInto('c.group_id = cg.customer_group_id','');
45
- $where = $this->_getReadAdapter()->quoteInto("c.entity_id > ?", 0);
46
  $select = $this->_getReadAdapter()->select()->from(array('c'=>$table))
47
  ->join(array('cg'=>$table2), $cond2)
48
  ->reset('columns')
24
  return $id;
25
  }
26
 
27
+ public function loadAllByStoreId($store_id){
28
  $table = $this->getMainTable();
29
  $table2 = $this->getTable('customer_group');
30
  $cond2 = $this->_getReadAdapter()->quoteInto('c.group_id = cg.customer_group_id','');
31
+ $where = $this->_getReadAdapter()->quoteInto("c.store_id = ?", $store_id);
32
  $select = $this->_getReadAdapter()->select()->from(array('c'=>$table))
33
  ->join(array('cg'=>$table2), $cond2)
34
  ->reset('columns')
38
  return $this->_getReadAdapter()->fetchAll($select);
39
  }
40
 
41
+ public function loadLimitedByStoreId($limit, $offset, $store_id){
42
  $table = $this->getMainTable();
43
  $table2 = $this->getTable('customer_group');
44
  $cond2 = $this->_getReadAdapter()->quoteInto('c.group_id = cg.customer_group_id','');
45
+ $where = $this->_getReadAdapter()->quoteInto("c.store_id = ?", $store_id);
46
  $select = $this->_getReadAdapter()->select()->from(array('c'=>$table))
47
  ->join(array('cg'=>$table2), $cond2)
48
  ->reset('columns')
app/code/community/Minubo/Interface/Model/Mysql4/Invoiceitems.php CHANGED
@@ -7,7 +7,7 @@ class Minubo_Interface_Model_Mysql4_Invoiceitems extends Mage_Core_Model_Mysql4_
7
  }
8
 
9
  protected function getColumns() {
10
- return array('entity_id','parent_id','base_price','base_weee_tax_row_disposition','weee_tax_applied_row_amount','base_weee_tax_applied_amount','tax_amount','base_row_total','discount_amount','row_total','weee_tax_row_disposition','base_discount_amount','base_weee_tax_disposition','price_incl_tax','weee_tax_applied_amount','base_tax_amount','base_price_incl_tax','qty','weee_tax_disposition','base_cost','base_weee_tax_applied_row_amnt','price','base_row_total_incl_tax','row_total_incl_tax','product_id','order_item_id','additional_data','description','weee_tax_applied','sku','name','hidden_tax_amount','base_hidden_tax_amount');
11
  }
12
 
13
  public function loadByField($field,$value){
@@ -21,25 +21,32 @@ class Minubo_Interface_Model_Mysql4_Invoiceitems extends Mage_Core_Model_Mysql4_
21
  return $id;
22
  }
23
 
24
- public function loadAll(){
25
  $table = $this->getMainTable();
26
- $where = $this->_getReadAdapter()->quoteInto("entity_id > ?", 0);
27
- $select = $this->_getReadAdapter()->select()->from($table)
 
 
 
28
  ->reset('columns')
29
  ->columns($this->getColumns())
30
- ->where($where)->order('entity_id');
 
31
  return $this->_getReadAdapter()->fetchAll($select);
32
  }
33
 
34
- public function loadLimited($limit, $offset){
35
  $table = $this->getMainTable();
36
- $where = $this->_getReadAdapter()->quoteInto("entity_id > ?", 0);
37
- $select = $this->_getReadAdapter()->select()->from($table)
 
 
 
38
  ->reset('columns')
39
  ->columns($this->getColumns())
40
  ->where($where)
41
  ->limit($limit, $offset)
42
- ->order('entity_id');
43
  return $this->_getReadAdapter()->fetchAll($select);
44
  }
45
 
7
  }
8
 
9
  protected function getColumns() {
10
+ return array('ip.entity_id','ip.parent_id','ip.base_price','ip.base_weee_tax_row_disposition','ip.weee_tax_applied_row_amount','ip.base_weee_tax_applied_amount','ip.tax_amount','ip.base_row_total','ip.discount_amount','ip.row_total','ip.weee_tax_row_disposition','ip.base_discount_amount','ip.base_weee_tax_disposition','ip.price_incl_tax','ip.weee_tax_applied_amount','ip.base_tax_amount','ip.base_price_incl_tax','ip.qty','ip.weee_tax_disposition','ip.base_cost','ip.base_weee_tax_applied_row_amnt','ip.price','ip.base_row_total_incl_tax','ip.row_total_incl_tax','ip.product_id','ip.order_item_id','ip.additional_data','ip.description','ip.weee_tax_applied','ip.sku','ip.name','ip.hidden_tax_amount','ip.base_hidden_tax_amount','i.store_id');
11
  }
12
 
13
  public function loadByField($field,$value){
21
  return $id;
22
  }
23
 
24
+ public function loadAllByStoreId($store_id){
25
  $table = $this->getMainTable();
26
+ $tableHeader = $this->getTable('invoices');
27
+ $condHeader = $this->_getReadAdapter()->quoteInto('ip.parent_id = i.entity_id','');
28
+ $where = $this->_getReadAdapter()->quoteInto("i.store_id = ?", $store_id);
29
+ $select = $this->_getReadAdapter()->select()->from(array('ip'=>$table))
30
+ ->join(array('i'=>$tableHeader), $condHeader)
31
  ->reset('columns')
32
  ->columns($this->getColumns())
33
+ ->where($where)
34
+ ->order('ip.entity_id');
35
  return $this->_getReadAdapter()->fetchAll($select);
36
  }
37
 
38
+ public function loadLimitedByStoreId($limit, $offset, $store_id){
39
  $table = $this->getMainTable();
40
+ $tableHeader = $this->getTable('invoices');
41
+ $condHeader = $this->_getReadAdapter()->quoteInto('ip.parent_id = i.entity_id','');
42
+ $where = $this->_getReadAdapter()->quoteInto("i.store_id = ?", $store_id);
43
+ $select = $this->_getReadAdapter()->select()->from(array('ip'=>$table))
44
+ ->join(array('i'=>$tableHeader), $condHeader)
45
  ->reset('columns')
46
  ->columns($this->getColumns())
47
  ->where($where)
48
  ->limit($limit, $offset)
49
+ ->order('ip.entity_id');
50
  return $this->_getReadAdapter()->fetchAll($select);
51
  }
52
 
app/code/community/Minubo/Interface/Model/Mysql4/Invoices.php CHANGED
@@ -27,9 +27,9 @@ class Minubo_Interface_Model_Mysql4_Invoices extends Mage_Core_Model_Mysql4_Abst
27
  return $id;
28
  }
29
 
30
- public function loadAll(){
31
  $table = $this->getMainTable();
32
- $where = $this->_getReadAdapter()->quoteInto("entity_id > ?", 0);
33
  $select = $this->_getReadAdapter()->select()->from($table)
34
  ->reset('columns')
35
  ->columns($this->getColumns())
@@ -38,9 +38,9 @@ class Minubo_Interface_Model_Mysql4_Invoices extends Mage_Core_Model_Mysql4_Abst
38
  return $this->_getReadAdapter()->fetchAll($select);
39
  }
40
 
41
- public function loadLimited($limit, $offset){
42
  $table = $this->getMainTable();
43
- $where = $this->_getReadAdapter()->quoteInto("entity_id > ?", 0);
44
  $select = $this->_getReadAdapter()->select()->from($table)
45
  ->reset('columns')
46
  ->columns($this->getColumns())
27
  return $id;
28
  }
29
 
30
+ public function loadAllByStoreId($store_id){
31
  $table = $this->getMainTable();
32
+ $where = $this->_getReadAdapter()->quoteInto("store_id = ?", $store_id);
33
  $select = $this->_getReadAdapter()->select()->from($table)
34
  ->reset('columns')
35
  ->columns($this->getColumns())
38
  return $this->_getReadAdapter()->fetchAll($select);
39
  }
40
 
41
+ public function loadLimitedByStoreId($limit, $offset, $store_id){
42
  $table = $this->getMainTable();
43
+ $where = $this->_getReadAdapter()->quoteInto("store_id = ?", $store_id);
44
  $select = $this->_getReadAdapter()->select()->from($table)
45
  ->reset('columns')
46
  ->columns($this->getColumns())
app/code/community/Minubo/Interface/Model/Mysql4/Orderitems.php CHANGED
@@ -7,23 +7,26 @@ class Minubo_Interface_Model_Mysql4_Orderitems extends Mage_Core_Model_Mysql4_Ab
7
  }
8
 
9
  protected function getColumns() {
10
- return array('o.order_id as orderKey','o.item_id as orderLineKey','oi.product_id as productKey',
11
- 'o.quote_Item_Id','o.is_Virtual','o.free_Shipping',
12
- 'o.is_Qty_Decimal','o.no_Discount','o.created_At','o.updated_At','o.qty_Canceled','o.qty_Invoiced','o.qty_Ordered',
13
- 'o.qty_Refunded','o.qty_Shipped','o.base_cost as cost','o.price','o.base_Price','o.original_Price','o.base_Original_Price',
14
- 'o.tax_Percent','o.tax_Amount','o.base_Tax_Amount','o.tax_Invoiced','o.base_Tax_Invoiced','o.discount_Percent',
15
- 'o.discount_Amount','o.base_Discount_Amount','o.discount_Invoiced','o.base_Discount_Invoiced','o.amount_Refunded',
16
- 'o.base_Amount_Refunded','o.row_Total','o.base_Row_Total','o.row_Invoiced','o.base_Row_Invoiced','o.base_Tax_Before_Discount',
17
- 'o.tax_Before_Discount','o.product_Type','o.product_Options','o.sku','o.applied_Rule_Ids','o.gift_Message_Id');
18
  }
19
 
20
  public function loadByField($field,$value){
21
  $table = $this->getMainTable();
 
 
22
  $table2 = $this->getTable('sales_flat_order_item');
23
- $cond2 = $this->_getReadAdapter()->quoteInto('o.item_id = IFNULL(oi.parent_item_id,oi.item_id)','');
24
- $where = $this->_getReadAdapter()->quoteInto("$field = ? AND oi.product_type = 'simple'", $value);
25
- $select = $this->_getReadAdapter()->select()->from(array('o'=>$table))
26
  ->join(array('oi'=>$table2), $cond2)
 
27
  ->reset('columns')
28
  ->columns($this->getColumns())
29
  ->where($where);
@@ -31,34 +34,40 @@ class Minubo_Interface_Model_Mysql4_Orderitems extends Mage_Core_Model_Mysql4_Ab
31
  return $id;
32
  }
33
 
34
- public function loadAll(){
35
  $table = $this->getMainTable();
 
 
36
  $table2 = $this->getTable('sales_flat_order_item');
37
- $cond2 = $this->_getReadAdapter()->quoteInto('o.item_id = IFNULL(oi.parent_item_id,oi.item_id)','');
38
- $where = $this->_getReadAdapter()->quoteInto("oi.product_type='simple'", '');
39
  $select = $this->_getReadAdapter()->select()
40
- ->from(array('o'=>$table))
41
  ->join(array('oi'=>$table2), $cond2)
 
42
  ->reset('columns')
43
  ->columns($this->getColumns())
44
  ->where($where)
45
- ->order('o.item_id');
46
  return $this->_getReadAdapter()->fetchAll($select);
47
  }
48
 
49
- public function loadLimited($limit, $offset){
50
  $table = $this->getMainTable();
 
 
51
  $table2 = $this->getTable('sales_flat_order_item');
52
- $cond2 = $this->_getReadAdapter()->quoteInto('o.item_id = IFNULL(oi.parent_item_id,oi.item_id)','');
53
- $where = $this->_getReadAdapter()->quoteInto("oi.product_type='simple'", '');
54
  $select = $this->_getReadAdapter()->select()
55
- ->from(array('o'=>$table))
56
  ->join(array('oi'=>$table2), $cond2)
 
57
  ->reset('columns')
58
  ->columns($this->getColumns())
59
  ->where($where)
60
  ->limit($limit, $offset)
61
- ->order('o.item_id');
62
  return $this->_getReadAdapter()->fetchAll($select);
63
  }
64
 
7
  }
8
 
9
  protected function getColumns() {
10
+ return array('op.order_id as orderKey','op.item_id as orderLineKey','oi.product_id as productKey',
11
+ 'op.quote_Item_Id','op.is_Virtual','op.free_Shipping',
12
+ 'op.is_Qty_Decimal','op.no_Discount','op.created_At','op.updated_At','op.qty_Canceled','op.qty_Invoiced','op.qty_Ordered',
13
+ 'op.qty_Refunded','op.qty_Shipped','op.base_cost as cost','op.price','op.base_Price','op.original_Price','op.base_Original_Price',
14
+ 'op.tax_Percent','op.tax_Amount','op.base_Tax_Amount','op.tax_Invoiced','op.base_Tax_Invoiced','op.discount_Percent',
15
+ 'op.discount_Amount','op.base_Discount_Amount','op.discount_Invoiced','op.base_Discount_Invoiced','op.amount_Refunded',
16
+ 'op.base_Amount_Refunded','op.row_Total','op.base_Row_Total','op.row_Invoiced','op.base_Row_Invoiced','op.base_Tax_Before_Discount',
17
+ 'op.tax_Before_Discount','op.product_Type','op.product_Options','op.sku','op.applied_Rule_Ids','op.gift_Message_Id','o.store_id');
18
  }
19
 
20
  public function loadByField($field,$value){
21
  $table = $this->getMainTable();
22
+ $tableHeader = $this->getTable('sales_flat_order');
23
+ $condHeader = $this->_getReadAdapter()->quoteInto('op.order_id = o.entity_id','');
24
  $table2 = $this->getTable('sales_flat_order_item');
25
+ $cond2 = $this->_getReadAdapter()->quoteInto('op.item_id = IFNULL(oi.parent_item_id,oi.item_id)','');
26
+ $where = $this->_getReadAdapter()->quoteInto("$field = ? AND oi.product_type = 'simple' AND o.store_id = ?", $value, $store_id);
27
+ $select = $this->_getReadAdapter()->select()->from(array('op'=>$table))
28
  ->join(array('oi'=>$table2), $cond2)
29
+ ->join(array('o'=>$tableHeader), $condHeader)
30
  ->reset('columns')
31
  ->columns($this->getColumns())
32
  ->where($where);
34
  return $id;
35
  }
36
 
37
+ public function loadAllByStoreId($store_id){
38
  $table = $this->getMainTable();
39
+ $tableHeader = $this->getTable('sales_flat_order');
40
+ $condHeader = $this->_getReadAdapter()->quoteInto('op.order_id = o.entity_id','');
41
  $table2 = $this->getTable('sales_flat_order_item');
42
+ $cond2 = $this->_getReadAdapter()->quoteInto('op.item_id = IFNULL(oi.parent_item_id,oi.item_id)','');
43
+ $where = $this->_getReadAdapter()->quoteInto("oi.product_type='simple' AND o.store_id = ?", $store_id);
44
  $select = $this->_getReadAdapter()->select()
45
+ ->from(array('op'=>$table))
46
  ->join(array('oi'=>$table2), $cond2)
47
+ ->join(array('o'=>$tableHeader), $condHeader)
48
  ->reset('columns')
49
  ->columns($this->getColumns())
50
  ->where($where)
51
+ ->order('op.item_id');
52
  return $this->_getReadAdapter()->fetchAll($select);
53
  }
54
 
55
+ public function loadLimitedByStoreId($limit, $offset, $store_id){
56
  $table = $this->getMainTable();
57
+ $tableHeader = $this->getTable('sales_flat_order');
58
+ $condHeader = $this->_getReadAdapter()->quoteInto('op.order_id = o.entity_id','');
59
  $table2 = $this->getTable('sales_flat_order_item');
60
+ $cond2 = $this->_getReadAdapter()->quoteInto('op.item_id = IFNULL(oi.parent_item_id,oi.item_id)','');
61
+ $where = $this->_getReadAdapter()->quoteInto("oi.product_type='simple' AND o.store_id = ?", $store_id);
62
  $select = $this->_getReadAdapter()->select()
63
+ ->from(array('op'=>$table))
64
  ->join(array('oi'=>$table2), $cond2)
65
+ ->join(array('o'=>$tableHeader), $condHeader)
66
  ->reset('columns')
67
  ->columns($this->getColumns())
68
  ->where($where)
69
  ->limit($limit, $offset)
70
+ ->order('op.item_id');
71
  return $this->_getReadAdapter()->fetchAll($select);
72
  }
73
 
app/code/community/Minubo/Interface/Model/Mysql4/Orders.php CHANGED
@@ -26,21 +26,21 @@ class Minubo_Interface_Model_Mysql4_Orders extends Mage_Core_Model_Mysql4_Abstra
26
 
27
  /*
28
  SELECT o.entity_id as orderKey, increment_id as orderNumber, created_At, updated_At, o.customer_id as customerKey,
29
- oas.postcode as shippingAddressPostcode, oas.city as shippingAddressCity, oas.country_id as shippingAddressCountryId,
30
- oas.entity_id as shippingAddressIncrementId, oas.parent_id as shippingAddressParentId,
31
- oas.region_id as shippingAddressRegionId, store_Id,
32
- billing_Address_Id, shipping_Address_Id, quote_Id, is_Virtual, customer_Group_Id, customer_Is_Guest,
33
- shipping_address_id as shippingAddressAddressId,
34
  o.created_at as shippingAddressCreatedAt, o.updated_at as shippingAddressUpdatedAt,
35
- tax_Amount, shipping_Amount, discount_Amount, subtotal, grand_Total, total_Paid,
36
- total_Refunded, total_Qty_Ordered, total_Canceled, total_Invoiced,
37
- base_Tax_Amount, base_Shipping_Amount, base_Discount_Amount, base_Grand_Total, base_Subtotal, base_Total_Paid, base_Total_Refunded,
38
- base_Total_Qty_Ordered, base_Total_Canceled, base_Total_Invoiced,
39
- store_To_Base_Rate, store_To_Order_Rate, base_To_Global_Rate, base_To_Order_Rate, store_Name, status, state, applied_Rule_Ids,
40
- global_Currency_Code, base_Currency_Code, store_Currency_Code,
41
  order_Currency_Code, shipping_Method, shipping_Description, oas.gift_Message_Id
42
  FROM `sales_flat_order` o
43
- inner join sales_flat_order_address oas on o.shipping_address_id = oas.entity_id
44
  */
45
 
46
  public function loadByField($field,$value){
@@ -63,7 +63,7 @@ class Minubo_Interface_Model_Mysql4_Orders extends Mage_Core_Model_Mysql4_Abstra
63
  return $id;
64
  }
65
 
66
- public function loadAll(){
67
  $table = $this->getMainTable();
68
  $table2 = $this->getTable('sales_flat_order_address');
69
  $cond2 = $this->_getReadAdapter()->quoteInto('o.shipping_address_id = oas.entity_id ','');
@@ -71,7 +71,7 @@ class Minubo_Interface_Model_Mysql4_Orders extends Mage_Core_Model_Mysql4_Abstra
71
  $cond3 = $this->_getReadAdapter()->quoteInto('o.entity_id = op.parent_id ','');
72
  $table4 = $this->getTable('sales_flat_order_address');
73
  $cond4 = $this->_getReadAdapter()->quoteInto("o.billing_address_id = oab.entity_id ",'');
74
- $where = $this->_getReadAdapter()->quoteInto("o.entity_id > ?", 0);
75
  $select = $this->_getReadAdapter()->select()->from(array('o'=>$table))
76
  ->join(array('oas'=>$table2), $cond2)
77
  ->join(array('op'=>$table3), $cond3)
@@ -83,7 +83,7 @@ class Minubo_Interface_Model_Mysql4_Orders extends Mage_Core_Model_Mysql4_Abstra
83
  return $this->_getReadAdapter()->fetchAll($select);
84
  }
85
 
86
- public function loadLimited($limit, $offset){
87
  $table = $this->getMainTable();
88
  $table2 = $this->getTable('sales_flat_order_address');
89
  $cond2 = $this->_getReadAdapter()->quoteInto('o.shipping_address_id = oas.entity_id ','');
@@ -91,7 +91,7 @@ class Minubo_Interface_Model_Mysql4_Orders extends Mage_Core_Model_Mysql4_Abstra
91
  $cond3 = $this->_getReadAdapter()->quoteInto('o.entity_id = op.parent_id ','');
92
  $table4 = $this->getTable('sales_flat_order_address');
93
  $cond4 = $this->_getReadAdapter()->quoteInto("o.billing_address_id = oab.entity_id ",'');
94
- $where = $this->_getReadAdapter()->quoteInto("o.entity_id > ?", 0);
95
  $select = $this->_getReadAdapter()->select()
96
  ->from(array('o'=>$table))
97
  ->join(array('oas'=>$table2), $cond2)
26
 
27
  /*
28
  SELECT o.entity_id as orderKey, increment_id as orderNumber, created_At, updated_At, o.customer_id as customerKey,
29
+ oas.postcode as shippingAddressPostcode, oas.city as shippingAddressCity, oas.country_id as shippingAddressCountryId,
30
+ oas.entity_id as shippingAddressIncrementId, oas.parent_id as shippingAddressParentId,
31
+ oas.region_id as shippingAddressRegionId, store_Id,
32
+ billing_Address_Id, shipping_Address_Id, quote_Id, is_Virtual, customer_Group_Id, customer_Is_Guest,
33
+ shipping_address_id as shippingAddressAddressId,
34
  o.created_at as shippingAddressCreatedAt, o.updated_at as shippingAddressUpdatedAt,
35
+ tax_Amount, shipping_Amount, discount_Amount, subtotal, grand_Total, total_Paid,
36
+ total_Refunded, total_Qty_Ordered, total_Canceled, total_Invoiced,
37
+ base_Tax_Amount, base_Shipping_Amount, base_Discount_Amount, base_Grand_Total, base_Subtotal, base_Total_Paid, base_Total_Refunded,
38
+ base_Total_Qty_Ordered, base_Total_Canceled, base_Total_Invoiced,
39
+ store_To_Base_Rate, store_To_Order_Rate, base_To_Global_Rate, base_To_Order_Rate, store_Name, status, state, applied_Rule_Ids,
40
+ global_Currency_Code, base_Currency_Code, store_Currency_Code,
41
  order_Currency_Code, shipping_Method, shipping_Description, oas.gift_Message_Id
42
  FROM `sales_flat_order` o
43
+ inner join sales_flat_order_address oas on o.shipping_address_id = oas.entity_id
44
  */
45
 
46
  public function loadByField($field,$value){
63
  return $id;
64
  }
65
 
66
+ public function loadAllByStoreId($store_id){
67
  $table = $this->getMainTable();
68
  $table2 = $this->getTable('sales_flat_order_address');
69
  $cond2 = $this->_getReadAdapter()->quoteInto('o.shipping_address_id = oas.entity_id ','');
71
  $cond3 = $this->_getReadAdapter()->quoteInto('o.entity_id = op.parent_id ','');
72
  $table4 = $this->getTable('sales_flat_order_address');
73
  $cond4 = $this->_getReadAdapter()->quoteInto("o.billing_address_id = oab.entity_id ",'');
74
+ $where = $this->_getReadAdapter()->quoteInto("o.store_id = ?", $store_id);
75
  $select = $this->_getReadAdapter()->select()->from(array('o'=>$table))
76
  ->join(array('oas'=>$table2), $cond2)
77
  ->join(array('op'=>$table3), $cond3)
83
  return $this->_getReadAdapter()->fetchAll($select);
84
  }
85
 
86
+ public function loadLimitedByStoreId($limit, $offset, $store_id){
87
  $table = $this->getMainTable();
88
  $table2 = $this->getTable('sales_flat_order_address');
89
  $cond2 = $this->_getReadAdapter()->quoteInto('o.shipping_address_id = oas.entity_id ','');
91
  $cond3 = $this->_getReadAdapter()->quoteInto('o.entity_id = op.parent_id ','');
92
  $table4 = $this->getTable('sales_flat_order_address');
93
  $cond4 = $this->_getReadAdapter()->quoteInto("o.billing_address_id = oab.entity_id ",'');
94
+ $where = $this->_getReadAdapter()->quoteInto("o.store_id = ?", $store_id);
95
  $select = $this->_getReadAdapter()->select()
96
  ->from(array('o'=>$table))
97
  ->join(array('oas'=>$table2), $cond2)
app/code/community/Minubo/Interface/Model/Mysql4/Productcategories.php CHANGED
@@ -21,9 +21,9 @@ class Minubo_Interface_Model_Mysql4_Productcategories extends Mage_Core_Model_My
21
  return $id;
22
  }
23
 
24
- public function loadAll(){
25
  $table = $this->getMainTable();
26
- $where = $this->_getReadAdapter()->quoteInto("category_id > ?", 0);
27
  $select = $this->_getReadAdapter()->select()->from($table)
28
  ->reset('columns')
29
  ->columns($this->getColumns())
@@ -32,9 +32,9 @@ class Minubo_Interface_Model_Mysql4_Productcategories extends Mage_Core_Model_My
32
  return $this->_getReadAdapter()->fetchAll($select);
33
  }
34
 
35
- public function loadLimited($limit, $offset){
36
  $table = $this->getMainTable();
37
- $where = $this->_getReadAdapter()->quoteInto("category_id > ?", 0);
38
  $select = $this->_getReadAdapter()->select()->from($table)
39
  ->reset('columns')
40
  ->columns($this->getColumns())
21
  return $id;
22
  }
23
 
24
+ public function loadAllByStoreId($store_id){
25
  $table = $this->getMainTable();
26
+ $where = $this->_getReadAdapter()->quoteInto("store_id = ?", $store_id);
27
  $select = $this->_getReadAdapter()->select()->from($table)
28
  ->reset('columns')
29
  ->columns($this->getColumns())
32
  return $this->_getReadAdapter()->fetchAll($select);
33
  }
34
 
35
+ public function loadLimitedByStoreId($limit, $offset, $store_id){
36
  $table = $this->getMainTable();
37
+ $where = $this->_getReadAdapter()->quoteInto("store_id = ?", $store_id);
38
  $select = $this->_getReadAdapter()->select()->from($table)
39
  ->reset('columns')
40
  ->columns($this->getColumns())
app/code/community/Minubo/Interface/Model/Mysql4/Products.php CHANGED
@@ -5,7 +5,7 @@ class Minubo_Interface_Model_Mysql4_Products extends Mage_Core_Model_Mysql4_Abst
5
  {
6
  $this->_init('minubo_interface/products', 'entity_id');
7
  }
8
-
9
  protected function getColumns() {
10
  $r = array('entity_id','sku','name','type_id','attribute_set_id','created_at','type_id as typeKey','weight',
11
  'visibility','has_options','gift_message_available','price','special_price',
@@ -37,7 +37,7 @@ class Minubo_Interface_Model_Mysql4_Products extends Mage_Core_Model_Mysql4_Abst
37
  return $id;
38
  }
39
 
40
- public function loadAllByStoreId($store_id=''){
41
  $table = str_replace('_1','_'.$store_id,$this->getMainTable());
42
  $where = $this->_getReadAdapter()->quoteInto("entity_id > ?", 0);
43
  $select = $this->_getReadAdapter()->select()->from($table)
@@ -48,7 +48,7 @@ class Minubo_Interface_Model_Mysql4_Products extends Mage_Core_Model_Mysql4_Abst
48
  return $this->_getReadAdapter()->fetchAll($select);
49
  }
50
 
51
- public function loadLimitedByStoreId($limit, $offset, $store_id=''){
52
  $table = str_replace('_1','_'.$store_id,$this->getMainTable());
53
  $where = $this->_getReadAdapter()->quoteInto("entity_id > ?", 0);
54
  $select = $this->_getReadAdapter()->select()->from($table)
5
  {
6
  $this->_init('minubo_interface/products', 'entity_id');
7
  }
8
+
9
  protected function getColumns() {
10
  $r = array('entity_id','sku','name','type_id','attribute_set_id','created_at','type_id as typeKey','weight',
11
  'visibility','has_options','gift_message_available','price','special_price',
37
  return $id;
38
  }
39
 
40
+ public function loadAllByStoreId($store_id){
41
  $table = str_replace('_1','_'.$store_id,$this->getMainTable());
42
  $where = $this->_getReadAdapter()->quoteInto("entity_id > ?", 0);
43
  $select = $this->_getReadAdapter()->select()->from($table)
48
  return $this->_getReadAdapter()->fetchAll($select);
49
  }
50
 
51
+ public function loadLimitedByStoreId($limit, $offset, $store_id){
52
  $table = str_replace('_1','_'.$store_id,$this->getMainTable());
53
  $where = $this->_getReadAdapter()->quoteInto("entity_id > ?", 0);
54
  $select = $this->_getReadAdapter()->select()->from($table)
app/code/community/Minubo/Interface/Model/Tables.php CHANGED
@@ -48,7 +48,7 @@ class Minubo_Interface_Model_Tables extends Minubo_Interface_Model_Read_Common
48
  $data = $this->getResource()->loadAll();
49
  return $data;
50
  }
51
- public function readAllByStoreId($storeId)
52
  {
53
  $data = $this->getResource()->loadAllByStoreId($storeId);
54
  return $data;
@@ -59,7 +59,7 @@ class Minubo_Interface_Model_Tables extends Minubo_Interface_Model_Read_Common
59
  $data = $this->getResource()->loadLimited($limit, $offset);
60
  return $data;
61
  }
62
- public function readLimitedByStoreId($limit, $offset, $storeId)
63
  {
64
  $data = $this->getResource()->loadLimitedByStoreId($limit, $offset, $storeId);
65
  return $data;
48
  $data = $this->getResource()->loadAll();
49
  return $data;
50
  }
51
+ public function readAllByStoreId($storeId='1')
52
  {
53
  $data = $this->getResource()->loadAllByStoreId($storeId);
54
  return $data;
59
  $data = $this->getResource()->loadLimited($limit, $offset);
60
  return $data;
61
  }
62
+ public function readLimitedByStoreId($limit, $offset, $storeId='1')
63
  {
64
  $data = $this->getResource()->loadLimitedByStoreId($limit, $offset, $storeId);
65
  return $data;
app/code/community/Minubo/Interface/controllers/ExportController.php CHANGED
@@ -54,13 +54,13 @@ class Minubo_Interface_ExportController extends Mage_Core_Controller_Front_Actio
54
  echo '# Regions: '.count($regions).'<br>';
55
 
56
  $model = Mage::getModel('minubo_interface/tables');
57
- $model->init('categories'.($store_id=='1'?'':$store_id));
58
- $categories = $model->readAll();
59
  echo '# Categories: '.count($categories).'<br>';
60
 
61
  $model = Mage::getModel('minubo_interface/tables');
62
- $model->init('products'.($store_id=='1'?'':$store_id));
63
- $products = $model->readAll();
64
  echo '# Products: '.count($products).'<br>';
65
 
66
  $model = Mage::getModel('minubo_interface/tables');
@@ -69,19 +69,18 @@ class Minubo_Interface_ExportController extends Mage_Core_Controller_Front_Actio
69
  echo '# ProductAttributes: '.count($productattributes).'<br>';
70
 
71
  $model = Mage::getModel('minubo_interface/tables');
72
- $model->init('productcategories'.($store_id=='1'?'':$store_id));
73
- $productcategories = $model->readAll();
74
  echo '# ProductCategories: '.count($productcategories).'<br>';
75
 
76
- // $orders = Mage::getModel('minubo_interface/read_collections')->read($lastChangeDate, '', $lastOrderID, $maxOrderID, $limit, $offset, $debug, $pdata, $store_id);
77
  $model = Mage::getModel('minubo_interface/tables');
78
  $model->init('orders');
79
- $orders = $model->readAll();
80
  echo '# Orders: '.count($orders).'<br>';
81
 
82
  $model = Mage::getModel('minubo_interface/tables');
83
  $model->init('orderitems');
84
- $orderitems = $model->readAll();
85
  echo '# OrderItems: '.count($orderitems).'<br>';
86
 
87
  $model = Mage::getModel('minubo_interface/tables');
@@ -91,7 +90,7 @@ class Minubo_Interface_ExportController extends Mage_Core_Controller_Front_Actio
91
 
92
  $model = Mage::getModel('minubo_interface/tables');
93
  $model->init('customers');
94
- $customers = $model->readAll();
95
  echo '# Customers: '.count($customers).'<br>';
96
 
97
  $model = Mage::getModel('minubo_interface/tables');
@@ -101,22 +100,22 @@ class Minubo_Interface_ExportController extends Mage_Core_Controller_Front_Actio
101
 
102
  $model = Mage::getModel('minubo_interface/tables');
103
  $model->init('creditmemos');
104
- $creditmemos = $model->readAll();
105
  echo '# CreditMemos: '.count($creditmemos).'<br>';
106
 
107
  $model = Mage::getModel('minubo_interface/tables');
108
  $model->init('creditmemoitems');
109
- $creditmemoitems = $model->readAll();
110
  echo '# CreditMemoItems: '.count($creditmemoitems).'<br>';
111
 
112
  $model = Mage::getModel('minubo_interface/tables');
113
  $model->init('invoices');
114
- $invoices = $model->readAll();
115
  echo '# Invoices: '.count($invoices).'<br>';
116
 
117
  $model = Mage::getModel('minubo_interface/tables');
118
  $model->init('invoiceitems');
119
- $invoiceitems = $model->readAll();
120
  echo '# InvoiceItems: '.count($invoiceitems).'<br>';
121
 
122
  }
@@ -238,13 +237,13 @@ class Minubo_Interface_ExportController extends Mage_Core_Controller_Front_Actio
238
  public function ordersAction ()
239
  {
240
  $renameCols = array('entity_id' => 'order_id');
241
- $this->handleTable ('orders', 'order', 'orders', Array(), Array(), $renameCols);
242
  }
243
 
244
  public function orderItemsAction ()
245
  {
246
  $renameCols = array('item_id' => 'orderitem_id');
247
- $this->handleTable ('orderitems', 'orderitem', 'orderitems', Array(), Array(), $renameCols);
248
  }
249
 
250
  public function orderCustomersAction ()
@@ -259,7 +258,7 @@ class Minubo_Interface_ExportController extends Mage_Core_Controller_Front_Actio
259
  public function customersAction ()
260
  {
261
  $renameCols = array('entity_id' => 'customer_id');
262
- $this->handleTable ('customers', 'customer', 'customers', Array(), Array(), $renameCols);
263
  }
264
 
265
  public function customerAddressesAction ()
@@ -284,7 +283,7 @@ class Minubo_Interface_ExportController extends Mage_Core_Controller_Front_Actio
284
  {
285
  $skipCols = array('is_parent');
286
  $colTitles = array('category_id','product_id','position','store_id','visibility');
287
- $this->handleTable ('productcategories', 'productcategory', 'productcategories', $colTitles, $skipCols, Array());
288
  }
289
 
290
  public function productattributesAction ()
@@ -308,20 +307,20 @@ class Minubo_Interface_ExportController extends Mage_Core_Controller_Front_Actio
308
 
309
  public function creditmemosAction ()
310
  {
311
- $this->handleTable ('creditmemos', 'creditmemo', 'creditmemos', Array(), Array(), Array());
312
  }
313
  public function creditmemoItemsAction ()
314
  {
315
- $this->handleTable ('creditmemoitems', 'creditmemoitem', 'creditmemoitems', Array(), Array(), Array());
316
  }
317
 
318
  public function invoicesAction ()
319
  {
320
- $this->handleTable ('invoices', 'invoice', 'invoices', Array(), Array(), Array());
321
  }
322
  public function invoiceItemsAction ()
323
  {
324
- $this->handleTable ( 'invoiceitems', 'invoiceitem', 'invoiceitems', Array(), Array(), Array());
325
  }
326
 
327
  public function handleTable ($sqlinterface, $filename, $type, $colTitles = Array(), $skipCols = Array(), $renameCols = Array(), $appendStoreId = false)
54
  echo '# Regions: '.count($regions).'<br>';
55
 
56
  $model = Mage::getModel('minubo_interface/tables');
57
+ $model->init('categories');
58
+ $categories = $model->readAllByStoreId($store_id);
59
  echo '# Categories: '.count($categories).'<br>';
60
 
61
  $model = Mage::getModel('minubo_interface/tables');
62
+ $model->init('products');
63
+ $products = $model->readAllByStoreId($store_id);
64
  echo '# Products: '.count($products).'<br>';
65
 
66
  $model = Mage::getModel('minubo_interface/tables');
69
  echo '# ProductAttributes: '.count($productattributes).'<br>';
70
 
71
  $model = Mage::getModel('minubo_interface/tables');
72
+ $model->init('productcategories');
73
+ $productcategories = $model->readAllByStoreId($store_id);
74
  echo '# ProductCategories: '.count($productcategories).'<br>';
75
 
 
76
  $model = Mage::getModel('minubo_interface/tables');
77
  $model->init('orders');
78
+ $orders = $model->readAllByStoreId($store_id);
79
  echo '# Orders: '.count($orders).'<br>';
80
 
81
  $model = Mage::getModel('minubo_interface/tables');
82
  $model->init('orderitems');
83
+ $orderitems = $model->readAllByStoreId($store_id);
84
  echo '# OrderItems: '.count($orderitems).'<br>';
85
 
86
  $model = Mage::getModel('minubo_interface/tables');
90
 
91
  $model = Mage::getModel('minubo_interface/tables');
92
  $model->init('customers');
93
+ $customers = $model->readAllByStoreId($store_id);
94
  echo '# Customers: '.count($customers).'<br>';
95
 
96
  $model = Mage::getModel('minubo_interface/tables');
100
 
101
  $model = Mage::getModel('minubo_interface/tables');
102
  $model->init('creditmemos');
103
+ $creditmemos = $model->readAllByStoreId($store_id);
104
  echo '# CreditMemos: '.count($creditmemos).'<br>';
105
 
106
  $model = Mage::getModel('minubo_interface/tables');
107
  $model->init('creditmemoitems');
108
+ $creditmemoitems = $model->readAllByStoreId($store_id);
109
  echo '# CreditMemoItems: '.count($creditmemoitems).'<br>';
110
 
111
  $model = Mage::getModel('minubo_interface/tables');
112
  $model->init('invoices');
113
+ $invoices = $model->readAllByStoreId($store_id);
114
  echo '# Invoices: '.count($invoices).'<br>';
115
 
116
  $model = Mage::getModel('minubo_interface/tables');
117
  $model->init('invoiceitems');
118
+ $invoiceitems = $model->readAllByStoreId($store_id);
119
  echo '# InvoiceItems: '.count($invoiceitems).'<br>';
120
 
121
  }
237
  public function ordersAction ()
238
  {
239
  $renameCols = array('entity_id' => 'order_id');
240
+ $this->handleTable ('orders', 'order', 'orders', Array(), Array(), $renameCols, true);
241
  }
242
 
243
  public function orderItemsAction ()
244
  {
245
  $renameCols = array('item_id' => 'orderitem_id');
246
+ $this->handleTable ('orderitems', 'orderitem', 'orderitems', Array(), Array(), $renameCols, true);
247
  }
248
 
249
  public function orderCustomersAction ()
258
  public function customersAction ()
259
  {
260
  $renameCols = array('entity_id' => 'customer_id');
261
+ $this->handleTable ('customers', 'customer', 'customers', Array(), Array(), $renameCols, true);
262
  }
263
 
264
  public function customerAddressesAction ()
283
  {
284
  $skipCols = array('is_parent');
285
  $colTitles = array('category_id','product_id','position','store_id','visibility');
286
+ $this->handleTable ('productcategories', 'productcategory', 'productcategories', $colTitles, $skipCols, Array(), true);
287
  }
288
 
289
  public function productattributesAction ()
307
 
308
  public function creditmemosAction ()
309
  {
310
+ $this->handleTable ('creditmemos', 'creditmemo', 'creditmemos', Array(), Array(), Array(), true);
311
  }
312
  public function creditmemoItemsAction ()
313
  {
314
+ $this->handleTable ('creditmemoitems', 'creditmemoitem', 'creditmemoitems', Array(), Array(), Array(), true);
315
  }
316
 
317
  public function invoicesAction ()
318
  {
319
+ $this->handleTable ('invoices', 'invoice', 'invoices', Array(), Array(), Array(), true);
320
  }
321
  public function invoiceItemsAction ()
322
  {
323
+ $this->handleTable ( 'invoiceitems', 'invoiceitem', 'invoiceitems', Array(), Array(), Array(), true);
324
  }
325
 
326
  public function handleTable ($sqlinterface, $filename, $type, $colTitles = Array(), $skipCols = Array(), $renameCols = Array(), $appendStoreId = false)
app/code/community/Minubo/Interface/etc/config.xml CHANGED
@@ -2,7 +2,7 @@
2
  <config>
3
  <modules>
4
  <Minubo_Interface>
5
- <version>1.0.14</version>
6
  </Minubo_Interface>
7
  </modules>
8
  <global>
@@ -20,10 +20,10 @@
20
  <sales_flat_order_address>
21
  <table>sales_flat_order_address</table>
22
  </sales_flat_order_address>
23
- <sales_flat_order_payment>
24
- <table>sales_flat_order_payment</table>
25
- </sales_flat_order_payment>
26
- <orderitems>
27
  <table>sales_flat_order_item</table>
28
  </orderitems>
29
  <categories>
2
  <config>
3
  <modules>
4
  <Minubo_Interface>
5
+ <version>1.0.15</version>
6
  </Minubo_Interface>
7
  </modules>
8
  <global>
20
  <sales_flat_order_address>
21
  <table>sales_flat_order_address</table>
22
  </sales_flat_order_address>
23
+ <sales_flat_order_payment>
24
+ <table>sales_flat_order_payment</table>
25
+ </sales_flat_order_payment>
26
+ <orderitems>
27
  <table>sales_flat_order_item</table>
28
  </orderitems>
29
  <categories>
package.xml CHANGED
@@ -1,18 +1,18 @@
1
  <?xml version="1.0"?>
2
  <package>
3
  <name>Minubo_Interface</name>
4
- <version>1.0.14</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>Several enhancements when using other store_id than 1</notes>
12
  <authors><author><name>sven rothe</name><user>minubo</user><email>sven@minubo.com</email></author></authors>
13
- <date>2013-10-24</date>
14
- <time>11:05: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="dd8c0131b7099fb914fbdee1d6e1a468"/><file name="Status.php" hash="cef67926aef558b87d4e3bcb02386743"/></dir><dir name="Mysql4"><file name="Categories.php" hash="134195b236be62eb41f87ace553c445e"/><file name="Creditmemoitems.php" hash="417301b2227b91c6f4289214c287b4e8"/><file name="Creditmemos.php" hash="821c38dffc35468da0b5405a18b49429"/><file name="Customeraddresses.php" hash="93d3c82c80f85de361de5e7e6c4ecf68"/><file name="Customers.php" hash="3d92e8d366554a304f48aaef02dfe5c3"/><file name="Invoiceitems.php" hash="b487f7780366a832e9e28bb7e66e95e0"/><file name="Invoices.php" hash="8b1dcc3491f76eb68ac1ee2c4e965234"/><file name="Orderaddresses.php" hash="648014e35db97bd57c4830e0f4882ad4"/><file name="Orderitems.php" hash="37fa91a9307f37441bdf0ac37794b3a4"/><file name="Orders.php" hash="1c221153e35b0dfc28e0ea0189bf1e83"/><file name="Productattributes.php" hash="3f1d8d692e5a96d231548568bc79b228"/><file name="Productcategories.php" hash="3fe724235a87d4700dc1a2dc9dde7175"/><file name="Products.php" hash="ad3ac6a1f906bc369a74b16b67515606"/><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="2af8284c1653b0637c9d1542397043f1"/><file name="Common.php" hash="18b089bb03cbb226b95db428a7c31ef2"/></dir><file name="Tables.php" hash="01c70cbcfea18fc3081ecab487a59498"/></dir><dir name="controllers"><file name="ExportController.php" hash="4ae2ab5f39317405ff9ed05d8d745b93"/></dir><dir name="etc"><file name="adminhtml.xml" hash="375c548aacaf6f1bfdf4de3af7b29dfb"/><file name="config.xml" hash="f8838fa725018b19871b338cac0d6d3d"/><file name="system.xml" hash="682c1364dd016ebde10820ecfa21382f"/></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.0.15</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>Software maintenance and minor bug-fixes.</notes>
12
  <authors><author><name>sven rothe</name><user>minubo</user><email>sven@minubo.com</email></author></authors>
13
+ <date>2013-10-28</date>
14
+ <time>14:13:10</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="dd8c0131b7099fb914fbdee1d6e1a468"/><file name="Status.php" hash="cef67926aef558b87d4e3bcb02386743"/></dir><dir name="Mysql4"><file name="Categories.php" hash="7aaf0b687f5127bd07a2d7b0c8fb47ba"/><file name="Creditmemoitems.php" hash="ec84aecc9efe31e0ac3be742ad973bcb"/><file name="Creditmemos.php" hash="2c9e399bdd89749815e3ebfac0b2337e"/><file name="Customeraddresses.php" hash="93d3c82c80f85de361de5e7e6c4ecf68"/><file name="Customers.php" hash="bc7ea00bed52bee359d4fabc6b6737e7"/><file name="Invoiceitems.php" hash="ae59d2c274a5dd8980f89e08707d342e"/><file name="Invoices.php" hash="4822b837cbdc8f4efb8b9314ca8d9c7f"/><file name="Orderaddresses.php" hash="648014e35db97bd57c4830e0f4882ad4"/><file name="Orderitems.php" hash="a1b6867985831328480b918af1c3c0d2"/><file name="Orders.php" hash="fdcb02b5802692675f07d813985e210f"/><file name="Productattributes.php" hash="3f1d8d692e5a96d231548568bc79b228"/><file name="Productcategories.php" hash="56a00cecf2cfe994fdeae9db947f653d"/><file name="Products.php" hash="2efaa98815a5b16d85999d2209157ffc"/><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="2af8284c1653b0637c9d1542397043f1"/><file name="Common.php" hash="18b089bb03cbb226b95db428a7c31ef2"/></dir><file name="Tables.php" hash="e0f2ee1d70cc61cac2ad428b09ecf6e7"/></dir><dir name="controllers"><file name="ExportController.php" hash="f16ac4d3affa5c765d80442c189b77d0"/></dir><dir name="etc"><file name="adminhtml.xml" hash="375c548aacaf6f1bfdf4de3af7b29dfb"/><file name="config.xml" hash="7409a775414df492cb52f875e53e9a34"/><file name="system.xml" hash="682c1364dd016ebde10820ecfa21382f"/></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>