Minubo_Interface - Version 1.0.22

Version Notes

Extensions for Multi-Store-IDs, Stores without costs on items, Orders without delivery addresses (for example with download items)

Download this release

Release Info

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


Code changes from version 1.0.16 to 1.0.22

Files changed (13) hide show
  1. app/code/community/Minubo/Interface/Model/Mysql4/Creditmemoitems.php +20 -1
  2. app/code/community/Minubo/Interface/Model/Mysql4/Creditmemos.php +13 -1
  3. app/code/community/Minubo/Interface/Model/Mysql4/Invoiceitems.php +8 -1
  4. app/code/community/Minubo/Interface/Model/Mysql4/Invoices.php +18 -1
  5. app/code/community/Minubo/Interface/Model/Mysql4/Orderitems.php +19 -3
  6. app/code/community/Minubo/Interface/Model/Mysql4/Orders.php +31 -31
  7. app/code/community/Minubo/Interface/Model/Mysql4/Productattributes.php +61 -83
  8. app/code/community/Minubo/Interface/Model/Mysql4/Products.php +19 -3
  9. app/code/community/Minubo/Interface/Model/Read/Collections.php +1 -0
  10. app/code/community/Minubo/Interface/controllers/ExportController.php +26 -4
  11. app/code/community/Minubo/Interface/etc/config.xml +1 -1
  12. app/code/community/Minubo/Interface/etc/system.xml +124 -108
  13. package.xml +5 -6
app/code/community/Minubo/Interface/Model/Mysql4/Creditmemoitems.php CHANGED
@@ -7,9 +7,28 @@ class Minubo_Interface_Model_Mysql4_Creditmemoitems extends Mage_Core_Model_Mysq
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){
14
  $table = $this->getMainTable();
15
  $where = $this->_getReadAdapter()->quoteInto("$field = ?", $value);
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',
11
+ 'cp.tax_amount','cp.base_weee_tax_applied_amount','cp.weee_tax_row_disposition','cp.base_row_total','cp.discount_amount',
12
+ 'cp.row_total','cp.weee_tax_applied_amount','cp.base_discount_amount','cp.base_weee_tax_disposition','cp.price_incl_tax',
13
+ 'cp.base_tax_amount','cp.weee_tax_disposition','cp.base_price_incl_tax','cp.qty','cp.base_cost',
14
+ 'cp.weee_tax_applied as base_weee_tax_applied_row_amnt','cp.price','cp.base_row_total_incl_tax','cp.row_total_incl_tax',
15
+ 'cp.product_id','cp.order_item_id','cp.additional_data','cp.description','cp.weee_tax_applied','cp.sku','cp.name',
16
+ 'cp.hidden_tax_amount','cp.base_hidden_tax_amount','c.store_id');
17
  }
18
 
19
+ /*
20
+ SELECT
21
+ cp.entity_id, cp.parent_id, cp.weee_tax_applied_row_amount, cp.base_price, cp.base_weee_tax_row_disposition, cp.tax_amount,
22
+ 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,
23
+ 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,
24
+ cp.qty,cp.base_cost,
25
+ -- cp.base_weee_tax_applied_row_amnt, // not available at native instruments
26
+ 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,
27
+ cp.weee_tax_applied, cp.sku,cp.name, cp.hidden_tax_amount, cp.base_hidden_tax_amount, c.store_id
28
+ FROM sales_flat_creditmemo_item cp
29
+ INNER JOIN sales_flat_creditmemo c ON cp.parent_id = c.entity_id
30
+ */
31
+
32
  public function loadByField($field,$value){
33
  $table = $this->getMainTable();
34
  $where = $this->_getReadAdapter()->quoteInto("$field = ?", $value);
app/code/community/Minubo/Interface/Model/Mysql4/Creditmemos.php CHANGED
@@ -14,9 +14,21 @@ class Minubo_Interface_Model_Mysql4_Creditmemos extends Mage_Core_Model_Mysql4_A
14
  'tax_amount','order_id','email_sent','creditmemo_status','state','shipping_address_id','billing_address_id','invoice_id',
15
  'store_currency_code','order_currency_code','base_currency_code','global_currency_code','transaction_id','increment_id',
16
  'created_at','updated_at','hidden_tax_amount','base_hidden_tax_amount','shipping_hidden_tax_amount',
17
- 'base_shipping_hidden_tax_amnt','shipping_incl_tax','base_shipping_incl_tax');
18
  }
19
 
 
 
 
 
 
 
 
 
 
 
 
 
20
  public function loadByField($field,$value){
21
  $table = $this->getMainTable();
22
  $where = $this->_getReadAdapter()->quoteInto("$field = ?", $value);
14
  'tax_amount','order_id','email_sent','creditmemo_status','state','shipping_address_id','billing_address_id','invoice_id',
15
  'store_currency_code','order_currency_code','base_currency_code','global_currency_code','transaction_id','increment_id',
16
  'created_at','updated_at','hidden_tax_amount','base_hidden_tax_amount','shipping_hidden_tax_amount',
17
+ 'shipping_hidden_tax_amount as base_shipping_hidden_tax_amnt','shipping_incl_tax','base_shipping_incl_tax');
18
  }
19
 
20
+ /*
21
+ SELECT entity_id, store_id, adjustment_positive, base_shipping_tax_amount,store_to_order_rate, base_discount_amount, base_to_order_rate, grand_total,
22
+ base_adjustment_negative, base_subtotal_incl_tax, shipping_amount, subtotal_incl_tax, adjustment_negative, base_shipping_amount, store_to_base_rate,
23
+ base_to_global_rate, base_adjustment, base_subtotal, discount_amount, subtotal, adjustment, base_grand_total, base_adjustment_positive, base_tax_amount,
24
+ shipping_tax_amount, tax_amount, order_id, email_sent, creditmemo_status, state, shipping_address_id, billing_address_id, invoice_id, store_currency_code,
25
+ order_currency_code, base_currency_code, global_currency_code, transaction_id, increment_id, created_at, updated_at, hidden_tax_amount, base_hidden_tax_amount,
26
+ shipping_hidden_tax_amount,
27
+ -- base_shipping_hidden_tax_amnt, // not available at native instruments
28
+ shipping_incl_tax, base_shipping_incl_tax
29
+ FROM sales_flat_creditmemo
30
+ */
31
+
32
  public function loadByField($field,$value){
33
  $table = $this->getMainTable();
34
  $where = $this->_getReadAdapter()->quoteInto("$field = ?", $value);
app/code/community/Minubo/Interface/Model/Mysql4/Invoiceitems.php CHANGED
@@ -7,7 +7,14 @@ class Minubo_Interface_Model_Mysql4_Invoiceitems extends Mage_Core_Model_Mysql4_
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){
7
  }
8
 
9
  protected function getColumns() {
10
+ return array('ip.entity_id','ip.parent_id','ip.base_price',
11
+ 'ip.base_weee_tax_row_disposition','ip.weee_tax_applied_row_amount','ip.base_weee_tax_applied_amount',
12
+ 'ip.tax_amount','ip.base_row_total','ip.discount_amount','ip.row_total','ip.weee_tax_row_disposition',
13
+ 'ip.base_discount_amount','ip.base_weee_tax_disposition','ip.price_incl_tax','ip.weee_tax_applied_amount',
14
+ 'ip.base_tax_amount','ip.base_price_incl_tax','ip.qty','ip.weee_tax_disposition','ip.base_cost',
15
+ 'ip.base_weee_tax_applied_row_amnt','ip.price','ip.base_row_total_incl_tax','ip.row_total_incl_tax',
16
+ 'ip.product_id','ip.order_item_id','ip.additional_data','ip.description','ip.weee_tax_applied',
17
+ 'ip.sku','ip.name','ip.hidden_tax_amount','ip.base_hidden_tax_amount','i.store_id');
18
  }
19
 
20
  public function loadByField($field,$value){
app/code/community/Minubo/Interface/Model/Mysql4/Invoices.php CHANGED
@@ -13,9 +13,26 @@ class Minubo_Interface_Model_Mysql4_Invoices extends Mage_Core_Model_Mysql4_Abst
13
  'base_subtotal','discount_amount','billing_address_id','is_used_for_refund','order_id','email_sent','can_void_flag',
14
  'state','shipping_address_id','store_currency_code','transaction_id','order_currency_code','base_currency_code',
15
  'global_currency_code','increment_id','created_at','updated_at','hidden_tax_amount','base_hidden_tax_amount',
16
- 'shipping_hidden_tax_amount','base_shipping_hidden_tax_amnt','shipping_incl_tax','base_shipping_incl_tax');
17
  }
18
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
19
  public function loadByField($field,$value){
20
  $table = $this->getMainTable();
21
  $where = $this->_getReadAdapter()->quoteInto("$field = ?", $value);
13
  'base_subtotal','discount_amount','billing_address_id','is_used_for_refund','order_id','email_sent','can_void_flag',
14
  'state','shipping_address_id','store_currency_code','transaction_id','order_currency_code','base_currency_code',
15
  'global_currency_code','increment_id','created_at','updated_at','hidden_tax_amount','base_hidden_tax_amount',
16
+ 'shipping_hidden_tax_amount','shipping_hidden_tax_amount as base_shipping_hidden_tax_amnt','shipping_incl_tax','base_shipping_incl_tax');
17
  }
18
 
19
+ /*
20
+ SELECT
21
+ entity_id, store_id, base_grand_total, shipping_tax_amount, tax_amount, base_tax_amount, store_to_order_rate,
22
+ base_shipping_tax_amount,
23
+ base_discount_amount,
24
+ base_to_order_rate,
25
+ grand_total,
26
+ shipping_amount,
27
+ subtotal_incl_tax, base_subtotal_incl_tax, store_to_base_rate, base_shipping_amount, total_qty, base_to_global_rate,subtotal,
28
+ base_subtotal, discount_amount, billing_address_id, is_used_for_refund, order_id, email_sent, can_void_flag, state, shipping_address_id,
29
+ store_currency_code, transaction_id, order_currency_code, base_currency_code, global_currency_code, increment_id, created_at, updated_at,
30
+ hidden_tax_amount, base_hidden_tax_amount, shipping_hidden_tax_amount,
31
+ -- base_shipping_hidden_tax_amnt, // not available at native instruments
32
+ shipping_incl_tax, base_shipping_incl_tax
33
+ FROM sales_flat_invoice
34
+ */
35
+
36
  public function loadByField($field,$value){
37
  $table = $this->getMainTable();
38
  $where = $this->_getReadAdapter()->quoteInto("$field = ?", $value);
app/code/community/Minubo/Interface/Model/Mysql4/Orderitems.php CHANGED
@@ -18,13 +18,29 @@ class Minubo_Interface_Model_Mysql4_Orderitems extends Mage_Core_Model_Mysql4_Ab
18
  // op.product_Type doppelt statt op.product_Options weil letzteres Probleme macht
19
  }
20
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
21
  public function loadByField($field,$value){
22
  $table = $this->getMainTable();
23
  $tableHeader = $this->getTable('sales_flat_order');
24
  $condHeader = $this->_getReadAdapter()->quoteInto('op.order_id = o.entity_id','');
25
  $table2 = $this->getTable('sales_flat_order_item');
26
  $cond2 = $this->_getReadAdapter()->quoteInto('op.item_id = IFNULL(oi.parent_item_id,oi.item_id)','');
27
- $where = $this->_getReadAdapter()->quoteInto("$field = ? AND oi.product_type = 'simple' AND o.store_id = ?", $value, $store_id);
28
  $select = $this->_getReadAdapter()->select()->from(array('op'=>$table))
29
  ->join(array('oi'=>$table2), $cond2)
30
  ->join(array('o'=>$tableHeader), $condHeader)
@@ -41,7 +57,7 @@ class Minubo_Interface_Model_Mysql4_Orderitems extends Mage_Core_Model_Mysql4_Ab
41
  $condHeader = $this->_getReadAdapter()->quoteInto('op.order_id = o.entity_id','');
42
  $table2 = $this->getTable('sales_flat_order_item');
43
  $cond2 = $this->_getReadAdapter()->quoteInto('op.item_id = IFNULL(oi.parent_item_id,oi.item_id)','');
44
- $where = $this->_getReadAdapter()->quoteInto("oi.product_type='simple' AND o.store_id = ?", $store_id);
45
  $select = $this->_getReadAdapter()->select()
46
  ->from(array('op'=>$table))
47
  ->join(array('oi'=>$table2), $cond2)
@@ -59,7 +75,7 @@ class Minubo_Interface_Model_Mysql4_Orderitems extends Mage_Core_Model_Mysql4_Ab
59
  $condHeader = $this->_getReadAdapter()->quoteInto('op.order_id = o.entity_id','');
60
  $table2 = $this->getTable('sales_flat_order_item');
61
  $cond2 = $this->_getReadAdapter()->quoteInto('op.item_id = IFNULL(oi.parent_item_id,oi.item_id)','');
62
- $where = $this->_getReadAdapter()->quoteInto("oi.product_type='simple' AND o.store_id = ?", $store_id);
63
  $select = $this->_getReadAdapter()->select()
64
  ->from(array('op'=>$table))
65
  ->join(array('oi'=>$table2), $cond2)
18
  // op.product_Type doppelt statt op.product_Options weil letzteres Probleme macht
19
  }
20
 
21
+ /*
22
+ select op.order_id as orderKey,op.item_id as orderLineKey,oi.product_id as productKey,
23
+ op.quote_Item_Id,op.is_Virtual,op.free_Shipping,
24
+ op.is_Qty_Decimal,op.no_Discount,op.created_At,op.updated_At,op.qty_Canceled,op.qty_Invoiced,op.qty_Ordered,
25
+ op.qty_Refunded,op.qty_Shipped,op.base_cost as cost,op.price,op.base_Price,op.original_Price,op.base_Original_Price,
26
+ op.tax_Percent,op.tax_Amount,op.base_Tax_Amount,op.tax_Invoiced,op.base_Tax_Invoiced,op.discount_Percent,
27
+ op.discount_Amount,op.base_Discount_Amount,op.discount_Invoiced,op.base_Discount_Invoiced,op.amount_Refunded,
28
+ op.base_Amount_Refunded,op.row_Total,op.base_Row_Total,op.row_Invoiced,op.base_Row_Invoiced,op.base_Tax_Before_Discount,
29
+ op.tax_Before_Discount,op.product_Type,op.product_Type AS product_Options,op.sku,op.applied_Rule_Ids,op.gift_Message_Id,o.store_id
30
+ from sales_flat_order_item op
31
+ inner join sales_flat_order_item oi on op.item_id = IFNULL(oi.parent_item_id,oi.item_id)
32
+ inner join sales_flat_order o on op.order_id = o.entity_id
33
+ where (oi.product_type = 'simple' or oi.product_type = 'virtual' or oi.product_type = 'downloadable') AND o.store_id = 1
34
+ order by op.item_id;
35
+ */
36
+
37
  public function loadByField($field,$value){
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("$field = ? AND (oi.product_type = 'simple' or oi.product_type = 'virtual' or oi.product_type = 'downloadable') AND o.store_id = ?", $value, $store_id);
44
  $select = $this->_getReadAdapter()->select()->from(array('op'=>$table))
45
  ->join(array('oi'=>$table2), $cond2)
46
  ->join(array('o'=>$tableHeader), $condHeader)
57
  $condHeader = $this->_getReadAdapter()->quoteInto('op.order_id = o.entity_id','');
58
  $table2 = $this->getTable('sales_flat_order_item');
59
  $cond2 = $this->_getReadAdapter()->quoteInto('op.item_id = IFNULL(oi.parent_item_id,oi.item_id)','');
60
+ $where = $this->_getReadAdapter()->quoteInto("(oi.product_type = 'simple' or oi.product_type = 'virtual' or oi.product_type = 'downloadable') AND o.store_id = ?", $store_id);
61
  $select = $this->_getReadAdapter()->select()
62
  ->from(array('op'=>$table))
63
  ->join(array('oi'=>$table2), $cond2)
75
  $condHeader = $this->_getReadAdapter()->quoteInto('op.order_id = o.entity_id','');
76
  $table2 = $this->getTable('sales_flat_order_item');
77
  $cond2 = $this->_getReadAdapter()->quoteInto('op.item_id = IFNULL(oi.parent_item_id,oi.item_id)','');
78
+ $where = $this->_getReadAdapter()->quoteInto("(oi.product_type = 'simple' or oi.product_type = 'virtual' or oi.product_type = 'downloadable') AND o.store_id = ?", $store_id);
79
  $select = $this->_getReadAdapter()->select()
80
  ->from(array('op'=>$table))
81
  ->join(array('oi'=>$table2), $cond2)
app/code/community/Minubo/Interface/Model/Mysql4/Orders.php CHANGED
@@ -8,11 +8,9 @@ class Minubo_Interface_Model_Mysql4_Orders extends Mage_Core_Model_Mysql4_Abstra
8
 
9
  protected function getColumns() {
10
  $r = array('o.entity_id as orderKey','increment_id as orderNumber','created_At','updated_At',"ifnull(oab.customer_address_id,concat('g_',oab.entity_id)) as customerKey",
11
- // 'o.customer_id as customerKey','o.coupon_code as Credit_Card_Type',
12
- 'oas.postcode as shippingAddressPostcode','oas.city as shippingAddressCity','oas.country_id as shippingAddressCountryId',
13
- // 'o.coupon_code as parentKey','o.coupon_code as isActive','o.status','o.coupon_code as comment',
14
- 'oas.entity_id as shippingAddressIncrementId','oas.parent_id as shippingAddressParentId',
15
- 'oas.region_id as shippingAddressRegionId','store_Id','billing_Address_Id','shipping_Address_Id','quote_Id','is_Virtual','customer_Group_Id','customer_Is_Guest',
16
  'shipping_address_id as shippingAddressAddressId',
17
  'o.created_at as shippingAddressCreatedAt','o.updated_at as shippingAddressUpdatedAt','tax_Amount','shipping_Amount','discount_Amount','subtotal','grand_Total','total_Paid',
18
  'total_Refunded','total_Qty_Ordered','total_Canceled','total_Invoiced',
@@ -20,8 +18,8 @@ class Minubo_Interface_Model_Mysql4_Orders extends Mage_Core_Model_Mysql4_Abstra
20
  'base_Total_Qty_Ordered','base_Total_Canceled','base_Total_Invoiced',
21
  'store_To_Base_Rate','store_To_Order_Rate','base_To_Global_Rate','base_To_Order_Rate', /* is_active */ 'store_Name','status','state','applied_Rule_Ids',
22
  'global_Currency_Code','base_Currency_Code','store_Currency_Code',
23
- 'order_Currency_Code','shipping_Method','shipping_Description', /* shippingAddressIsActive */ 'oas.address_type as shippingAddressAddressType',
24
- 'oas.region as shippingAddressRegion','op.method as paymentMethod','oab.customer_address_id','md5(o.customer_email) as Customer_HashCode');
25
 
26
  $fields = Mage::getStoreConfig('minubo_interface/settings/orderfields',Mage::app()->getStore());
27
  $f = explode(',', str_replace(' ','',$fields));
@@ -29,22 +27,24 @@ class Minubo_Interface_Model_Mysql4_Orders extends Mage_Core_Model_Mysql4_Abstra
29
  }
30
 
31
  /*
32
- SELECT o.entity_id as orderKey, increment_id as orderNumber, created_At, updated_At, o.customer_id as customerKey,
33
- oas.postcode as shippingAddressPostcode, oas.city as shippingAddressCity, oas.country_id as shippingAddressCountryId,
34
- oas.entity_id as shippingAddressIncrementId, oas.parent_id as shippingAddressParentId,
35
- oas.region_id as shippingAddressRegionId, store_Id,
36
- billing_Address_Id, shipping_Address_Id, quote_Id, is_Virtual, customer_Group_Id, customer_Is_Guest,
37
  shipping_address_id as shippingAddressAddressId,
38
- o.created_at as shippingAddressCreatedAt, o.updated_at as shippingAddressUpdatedAt,
39
- tax_Amount, shipping_Amount, discount_Amount, subtotal, grand_Total, total_Paid,
40
- total_Refunded, total_Qty_Ordered, total_Canceled, total_Invoiced,
41
- base_Tax_Amount, base_Shipping_Amount, base_Discount_Amount, base_Grand_Total, base_Subtotal, base_Total_Paid, base_Total_Refunded,
42
- base_Total_Qty_Ordered, base_Total_Canceled, base_Total_Invoiced,
43
- store_To_Base_Rate, store_To_Order_Rate, base_To_Global_Rate, base_To_Order_Rate, store_Name, status, state, applied_Rule_Ids,
44
- global_Currency_Code, base_Currency_Code, store_Currency_Code,
45
- order_Currency_Code, shipping_Method, shipping_Description, oas.gift_Message_Id
46
  FROM `sales_flat_order` o
47
- inner join sales_flat_order_address oas on o.shipping_address_id = oas.entity_id
 
 
 
48
  */
49
 
50
  public function loadByField($field,$value){
@@ -57,9 +57,9 @@ class Minubo_Interface_Model_Mysql4_Orders extends Mage_Core_Model_Mysql4_Abstra
57
  $cond4 = $this->_getReadAdapter()->quoteInto("o.billing_address_id = oab.entity_id ",'');
58
  $where = $this->_getReadAdapter()->quoteInto("$field = ?", $value);
59
  $select = $this->_getReadAdapter()->select()->from(array('o'=>$table))
60
- ->join(array('oas'=>$table2), $cond2)
61
- ->join(array('op'=>$table3), $cond3)
62
- ->join(array('oab'=>$table4), $cond4)
63
  ->reset('columns')
64
  ->columns($this->getColumns())
65
  ->where($where);
@@ -76,10 +76,10 @@ class Minubo_Interface_Model_Mysql4_Orders extends Mage_Core_Model_Mysql4_Abstra
76
  $table4 = $this->getTable('sales_flat_order_address');
77
  $cond4 = $this->_getReadAdapter()->quoteInto("o.billing_address_id = oab.entity_id ",'');
78
  $where = $this->_getReadAdapter()->quoteInto("o.store_id = ?", $store_id);
79
- $select = $this->_getReadAdapter()->select()->from(array('o'=>$table))
80
- ->join(array('oas'=>$table2), $cond2)
81
- ->join(array('op'=>$table3), $cond3)
82
- ->join(array('oab'=>$table4), $cond4)
83
  ->reset('columns')
84
  ->columns($this->getColumns())
85
  ->where($where)
@@ -98,9 +98,9 @@ class Minubo_Interface_Model_Mysql4_Orders extends Mage_Core_Model_Mysql4_Abstra
98
  $where = $this->_getReadAdapter()->quoteInto("o.store_id = ?", $store_id);
99
  $select = $this->_getReadAdapter()->select()
100
  ->from(array('o'=>$table))
101
- ->join(array('oas'=>$table2), $cond2)
102
- ->join(array('op'=>$table3), $cond3)
103
- ->join(array('oab'=>$table4), $cond4)
104
  ->reset('columns')
105
  ->columns($this->getColumns())
106
  ->where($where)
8
 
9
  protected function getColumns() {
10
  $r = array('o.entity_id as orderKey','increment_id as orderNumber','created_At','updated_At',"ifnull(oab.customer_address_id,concat('g_',oab.entity_id)) as customerKey",
11
+ 'ifnull(oas.postcode,oab.postcode) as shippingAddressPostcode','ifnull(oas.city,oab.city) as shippingAddressCity','ifnull(oas.country_id,oab.country_id) as shippingAddressCountryId',
12
+ 'ifnull(oas.entity_id,oab.entity_id) as shippingAddressIncrementId','ifnull(oas.parent_id,oab.parent_id) as shippingAddressParentId',
13
+ 'ifnull(oas.region_id,oab.region_id) as shippingAddressRegionId','store_Id','billing_Address_Id','shipping_Address_Id','quote_Id','is_Virtual','customer_Group_Id','customer_Is_Guest',
 
 
14
  'shipping_address_id as shippingAddressAddressId',
15
  'o.created_at as shippingAddressCreatedAt','o.updated_at as shippingAddressUpdatedAt','tax_Amount','shipping_Amount','discount_Amount','subtotal','grand_Total','total_Paid',
16
  'total_Refunded','total_Qty_Ordered','total_Canceled','total_Invoiced',
18
  'base_Total_Qty_Ordered','base_Total_Canceled','base_Total_Invoiced',
19
  'store_To_Base_Rate','store_To_Order_Rate','base_To_Global_Rate','base_To_Order_Rate', /* is_active */ 'store_Name','status','state','applied_Rule_Ids',
20
  'global_Currency_Code','base_Currency_Code','store_Currency_Code',
21
+ 'order_Currency_Code','shipping_Method','shipping_Description', /* shippingAddressIsActive */ 'ifnull(oas.address_type,oab.address_type) as shippingAddressAddressType',
22
+ 'ifnull(oas.region,oab.region) as shippingAddressRegion','op.method as paymentMethod','oab.customer_address_id','md5(o.customer_email) as Customer_HashCode');
23
 
24
  $fields = Mage::getStoreConfig('minubo_interface/settings/orderfields',Mage::app()->getStore());
25
  $f = explode(',', str_replace(' ','',$fields));
27
  }
28
 
29
  /*
30
+ SELECT o.entity_id as orderKey,o.increment_id as orderNumber,o.created_At,o.updated_At, ifnull(oab.customer_address_id,concat('g_',oab.entity_id)) as customerKey,
31
+ ifnull(oas.postcode,oab.postcode) as shippingAddressPostcode,ifnull(oas.city,oab.city) as shippingAddressCity,ifnull(oas.country_id,oab.country_id) as shippingAddressCountryId,
32
+ ifnull(oas.entity_id,oab.entity_id) as shippingAddressIncrementId,ifnull(oas.parent_id,oab.parent_id) as shippingAddressParentId,
33
+ ifnull(oas.region_id,oab.region_id) as shippingAddressRegionId,o.store_Id,o.billing_Address_Id,o.shipping_Address_Id,o.quote_Id,o.is_Virtual,o.customer_Group_Id,o.customer_Is_Guest,
 
34
  shipping_address_id as shippingAddressAddressId,
35
+ o.created_at as shippingAddressCreatedAt,o.updated_at as shippingAddressUpdatedAt,o.tax_Amount,o.shipping_Amount,o.discount_Amount,o.subtotal,o.grand_Total,o.total_Paid,
36
+ o.total_Refunded,o.total_Qty_Ordered,o.total_Canceled,o.total_Invoiced,
37
+ o.base_Tax_Amount,o.base_Shipping_Amount,o.base_Discount_Amount,o.base_Grand_Total,o.base_Subtotal,o.base_Total_Paid,o.base_Total_Refunded,
38
+ o.base_Total_Qty_Ordered,o.base_Total_Canceled,o.base_Total_Invoiced,
39
+ o.store_To_Base_Rate,o.store_To_Order_Rate,o.base_To_Global_Rate,o.base_To_Order_Rate,o.store_Name,o.status,o.state,o.applied_Rule_Ids,
40
+ o.global_Currency_Code,o.base_Currency_Code,o.store_Currency_Code,
41
+ o.order_Currency_Code,o.shipping_Method,o.shipping_Description, ifnull(oas.address_type,oab.address_type) as shippingAddressAddressType,
42
+ ifnull(oas.region,oab.region) as shippingAddressRegion,op.method as paymentMethod,oab.customer_address_id,md5(o.customer_email) as Customer_HashCode
43
  FROM `sales_flat_order` o
44
+ left outer join sales_flat_order_address oas on o.shipping_address_id = oas.entity_id
45
+ left outer join sales_flat_order_payment op on o.entity_id = op.parent_id
46
+ left outer join sales_flat_order_address oab on o.billing_address_id = oab.entity_id
47
+ where o.store_id = 1
48
  */
49
 
50
  public function loadByField($field,$value){
57
  $cond4 = $this->_getReadAdapter()->quoteInto("o.billing_address_id = oab.entity_id ",'');
58
  $where = $this->_getReadAdapter()->quoteInto("$field = ?", $value);
59
  $select = $this->_getReadAdapter()->select()->from(array('o'=>$table))
60
+ ->joinLeft(array('oas'=>$table2), $cond2)
61
+ ->joinLeft(array('op'=>$table3), $cond3)
62
+ ->joinLeft(array('oab'=>$table4), $cond4)
63
  ->reset('columns')
64
  ->columns($this->getColumns())
65
  ->where($where);
76
  $table4 = $this->getTable('sales_flat_order_address');
77
  $cond4 = $this->_getReadAdapter()->quoteInto("o.billing_address_id = oab.entity_id ",'');
78
  $where = $this->_getReadAdapter()->quoteInto("o.store_id = ?", $store_id);
79
+ $select = $this->_getReadAdapter()->select()->from(array('o'=>$table))
80
+ ->joinLeft(array('oas'=>$table2), $cond2)
81
+ ->joinLeft(array('op'=>$table3), $cond3)
82
+ ->joinLeft(array('oab'=>$table4), $cond4)
83
  ->reset('columns')
84
  ->columns($this->getColumns())
85
  ->where($where)
98
  $where = $this->_getReadAdapter()->quoteInto("o.store_id = ?", $store_id);
99
  $select = $this->_getReadAdapter()->select()
100
  ->from(array('o'=>$table))
101
+ ->joinLeft(array('oas'=>$table2), $cond2)
102
+ ->joinLeft(array('op'=>$table3), $cond3)
103
+ ->joinLeft(array('oab'=>$table4), $cond4)
104
  ->reset('columns')
105
  ->columns($this->getColumns())
106
  ->where($where)
app/code/community/Minubo/Interface/Model/Mysql4/Productattributes.php CHANGED
@@ -3,109 +3,87 @@ class Minubo_Interface_Model_Mysql4_Productattributes extends Mage_Core_Model_My
3
  {
4
  public function _construct()
5
  {
6
- $this->_init('minubo_interface/productattributes', 'entity_id');
7
  }
8
 
9
  /*
10
- SELECT *
11
- FROM `catalog_product_entity` e
12
- inner join eav_attribute eav on e.entity_type_id = eav.entity_type_id
13
- inner join catalog_product_entity_varchar var on eav.attribute_id = var.attribute_id AND e.entity_id = var.entity_id
14
- inner join eav_attribute_set eas on e.attribute_set_id = eas.attribute_set_id AND e.entity_id = var.entity_id
15
- where e.entity_id > 0 AND eav.attribute_code in ('name','color')
16
  */
17
 
18
  protected function getColumns() {
19
- return array('e.attribute_set_id','eas.attribute_set_name','eav.attribute_id','eav.attribute_code','eav.backend_type','eav.is_required','var.value','var.value_id');
20
  }
21
 
22
  protected function getAttributes() {
23
- $fields = str_replace(' ','',Mage::getStoreConfig('minubo_interface/settings/attributefields',Mage::app()->getStore()));
24
- $f = (strlen($fields)>0 ? ",'".str_replace(",","','",$fields)."'" : '');
25
- return "'name'".$f;
26
  }
27
 
28
  public function loadByField($field,$value){
29
- $table = $this->getMainTable();
30
- $table2 = $this->getTable('eav_attribute');
31
- $cond2 = $this->_getReadAdapter()->quoteInto('e.entity_type_id = eav.entity_type_id AND ','').$this->_getReadAdapter()->quoteInto('eav.backend_type = "varchar"', '');
32
- $table3 = $this->getTable('catalog_product_entity_varchar');
33
- $cond3 = $this->_getReadAdapter()->quoteInto('eav.attribute_id = var.attribute_id AND ','').$this->_getReadAdapter()->quoteInto('e.entity_id = var.entity_id', '');
34
- $table4 = $this->getTable('eav_attribute_set');
35
- $cond4 = $this->_getReadAdapter()->quoteInto('e.attribute_set_id = eas.attribute_set_id AND ','').$this->_getReadAdapter()->quoteInto('e.entity_id = var.entity_id', '');
36
- $where = $this->_getReadAdapter()->quoteInto("$field = ? AND eav.attribute_code in (".$this->getAttributes().")", $value);
37
- $select = $this->_getReadAdapter()->select()->from(array('e'=>$table))
38
- ->join(array('eav'=>$table2), $cond2)
39
- ->join(array('var'=>$table3), $cond3)
40
- ->join(array('eas'=>$table4), $cond4)
41
- ->reset('columns')
42
- ->columns($this->getColumns())
43
- ->where($where);
44
- $id = $this->_getReadAdapter()->fetchOne($select);
45
- return $id;
46
  }
47
 
48
  public function loadAll(){
49
  $table = $this->getMainTable();
50
- $table2 = $this->getTable('eav_attribute');
51
- $cond2 = $this->_getReadAdapter()->quoteInto('e.entity_type_id = eav.entity_type_id AND ','').$this->_getReadAdapter()->quoteInto('eav.backend_type = "varchar"', '');
52
- $table3 = $this->getTable('catalog_product_entity_varchar');
53
- $cond3 = $this->_getReadAdapter()->quoteInto('eav.attribute_id = var.attribute_id AND ','').$this->_getReadAdapter()->quoteInto('e.entity_id = var.entity_id', '');
54
- $table4 = $this->getTable('eav_attribute_set');
55
- $cond4 = $this->_getReadAdapter()->quoteInto('e.attribute_set_id = eas.attribute_set_id AND ','').$this->_getReadAdapter()->quoteInto('e.entity_id = var.entity_id', '');
56
- $where = $this->_getReadAdapter()->quoteInto("e.entity_id > ? AND eav.attribute_code in (".$this->getAttributes().")", 0);
57
  $select = $this->_getReadAdapter()->select()->from(array('e'=>$table))
58
- ->join(array('eav'=>$table2), $cond2)
59
- ->join(array('var'=>$table3), $cond3)
60
- ->join(array('eas'=>$table4), $cond4)
61
- ->reset('columns')
62
- ->columns($this->getColumns())
63
- ->where($where)
64
- ->order('e.entity_id');
65
- /*
66
- echo $select."<br/>";
67
-
68
- $table = $this->getMainTable();
69
- $where = $this->_getReadAdapter()->quoteInto("category_id > ?", 0);
70
- // $select = $this->_getReadAdapter()->select()->from($table)->columns(array('entity_id','parent_id','name'))->where($where)->limit(10,5)->order('created_at');
71
- $select = $this->_getReadAdapter()->select()->from($table)->where($where)->order('category_id');
72
- */
73
-
74
- return $this->_getReadAdapter()->fetchAll($select);
75
-
76
- /*
77
- SELECT e.entity_id AS product_id, var.value AS product_name
78
- FROM catalog_product_entity e, eav_attribute eav, catalog_product_entity_varchar var
79
- WHERE
80
- e.entity_type_id = eav.entity_type_id
81
- AND eav.attribute_code = 'name'
82
- AND eav.attribute_id = var.attribute_id
83
- AND var.entity_id = e.entity_id
84
- */
85
-
86
-
87
  }
88
 
89
  public function loadLimited($limit, $offset){
90
- $table = $this->getMainTable();
91
- $table2 = $this->getTable('eav_attribute');
92
- $cond2 = $this->_getReadAdapter()->quoteInto('e.entity_type_id = eav.entity_type_id','');
93
- $table3 = $this->getTable('catalog_product_entity_varchar');
94
- $cond3 = $this->_getReadAdapter()->quoteInto('eav.attribute_id = var.attribute_id AND ','').$this->_getReadAdapter()->quoteInto('e.entity_id = var.entity_id', '');
95
- $table4 = $this->getTable('eav_attribute_set');
96
- $cond4 = $this->_getReadAdapter()->quoteInto('e.attribute_set_id = eas.attribute_set_id AND ','').$this->_getReadAdapter()->quoteInto('e.entity_id = var.entity_id', '');
97
- $where = $this->_getReadAdapter()->quoteInto("e.entity_id > ? AND eav.attribute_code in (".$this->getAttributes().")", 0);
98
- $select = $this->_getReadAdapter()->select()->from(array('e'=>$table))->reset('columns')
99
- ->join(array('eav'=>$table2), $cond2)
100
- ->join(array('var'=>$table3), $cond3)
101
- ->join(array('eas'=>$table4), $cond4)
102
- ->reset('columns')
103
- ->columns($this->getColumns())
104
- ->where($where)
105
- ->limit($limit, $offset)
106
- ->order('e.entity_id');
107
-
108
- return $this->_getReadAdapter()->fetchAll($select);
109
  }
110
  }
111
  ?>
3
  {
4
  public function _construct()
5
  {
6
+ $this->_init('minubo_interface/productattributes', 'entity_id');
7
  }
8
 
9
  /*
10
+ SELECT *
11
+ FROM `catalog_product_entity` e
12
+ inner join eav_attribute eav on e.entity_type_id = eav.entity_type_id
13
+ inner join catalog_product_entity_varchar var on eav.attribute_id = var.attribute_id AND e.entity_id = var.entity_id
14
+ inner join eav_attribute_set eas on e.attribute_set_id = eas.attribute_set_id AND e.entity_id = var.entity_id
15
+ where e.entity_id > 0 AND eav.attribute_code in ('name','color')
16
  */
17
 
18
  protected function getColumns() {
19
+ return array('e.attribute_set_id','eas.attribute_set_name','eav.attribute_id','eav.attribute_code','eav.backend_type','eav.is_required','var.value','var.value_id','e.entity_id');
20
  }
21
 
22
  protected function getAttributes() {
23
+ $fields = str_replace(' ','',Mage::getStoreConfig('minubo_interface/settings/attributefields',Mage::app()->getStore()));
24
+ $f = (strlen($fields)>0 ? ",'".str_replace(",","','",$fields)."'" : '');
25
+ return "'name'".$f;
26
  }
27
 
28
  public function loadByField($field,$value){
29
+ $table = $this->getMainTable();
30
+ $table2 = $this->getTable('eav_attribute');
31
+ $cond2 = $this->_getReadAdapter()->quoteInto('e.entity_type_id = eav.entity_type_id AND ','').$this->_getReadAdapter()->quoteInto('eav.backend_type = "varchar"', '');
32
+ $table3 = $this->getTable('catalog_product_entity_varchar');
33
+ $cond3 = $this->_getReadAdapter()->quoteInto('eav.attribute_id = var.attribute_id AND ','').$this->_getReadAdapter()->quoteInto('e.entity_id = var.entity_id', '');
34
+ $table4 = $this->getTable('eav_attribute_set');
35
+ $cond4 = $this->_getReadAdapter()->quoteInto('e.attribute_set_id = eas.attribute_set_id AND ','').$this->_getReadAdapter()->quoteInto('e.entity_id = var.entity_id', '');
36
+ $where = $this->_getReadAdapter()->quoteInto("$field = ? AND eav.attribute_code in (".$this->getAttributes().")", $value);
37
+ $select = $this->_getReadAdapter()->select()->from(array('e'=>$table))
38
+ ->join(array('eav'=>$table2), $cond2)
39
+ ->join(array('var'=>$table3), $cond3)
40
+ ->join(array('eas'=>$table4), $cond4)
41
+ ->reset('columns')
42
+ ->columns($this->getColumns())
43
+ ->where($where);
44
+ $id = $this->_getReadAdapter()->fetchOne($select);
45
+ return $id;
46
  }
47
 
48
  public function loadAll(){
49
  $table = $this->getMainTable();
50
+ $table2 = $this->getTable('eav_attribute');
51
+ $cond2 = $this->_getReadAdapter()->quoteInto('e.entity_type_id = eav.entity_type_id AND ','').$this->_getReadAdapter()->quoteInto('eav.backend_type = "varchar"', '');
52
+ $table3 = $this->getTable('catalog_product_entity_varchar');
53
+ $cond3 = $this->_getReadAdapter()->quoteInto('eav.attribute_id = var.attribute_id AND ','').$this->_getReadAdapter()->quoteInto('e.entity_id = var.entity_id', '');
54
+ $table4 = $this->getTable('eav_attribute_set');
55
+ $cond4 = $this->_getReadAdapter()->quoteInto('e.attribute_set_id = eas.attribute_set_id AND ','').$this->_getReadAdapter()->quoteInto('e.entity_id = var.entity_id', '');
56
+ $where = $this->_getReadAdapter()->quoteInto("e.entity_id > ? AND eav.attribute_code in (".$this->getAttributes().")", 0);
57
  $select = $this->_getReadAdapter()->select()->from(array('e'=>$table))
58
+ ->join(array('eav'=>$table2), $cond2)
59
+ ->join(array('var'=>$table3), $cond3)
60
+ ->join(array('eas'=>$table4), $cond4)
61
+ ->reset('columns')
62
+ ->columns($this->getColumns())
63
+ ->where($where)
64
+ ->order('e.entity_id');
65
+ return $this->_getReadAdapter()->fetchAll($select);
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
66
  }
67
 
68
  public function loadLimited($limit, $offset){
69
+ $table = $this->getMainTable();
70
+ $table2 = $this->getTable('eav_attribute');
71
+ $cond2 = $this->_getReadAdapter()->quoteInto('e.entity_type_id = eav.entity_type_id','');
72
+ $table3 = $this->getTable('catalog_product_entity_varchar');
73
+ $cond3 = $this->_getReadAdapter()->quoteInto('eav.attribute_id = var.attribute_id AND ','').$this->_getReadAdapter()->quoteInto('e.entity_id = var.entity_id', '');
74
+ $table4 = $this->getTable('eav_attribute_set');
75
+ $cond4 = $this->_getReadAdapter()->quoteInto('e.attribute_set_id = eas.attribute_set_id AND ','').$this->_getReadAdapter()->quoteInto('e.entity_id = var.entity_id', '');
76
+ $where = $this->_getReadAdapter()->quoteInto("e.entity_id > ? AND eav.attribute_code in (".$this->getAttributes().")", 0);
77
+ $select = $this->_getReadAdapter()->select()->from(array('e'=>$table))->reset('columns')
78
+ ->join(array('eav'=>$table2), $cond2)
79
+ ->join(array('var'=>$table3), $cond3)
80
+ ->join(array('eas'=>$table4), $cond4)
81
+ ->reset('columns')
82
+ ->columns($this->getColumns())
83
+ ->where($where)
84
+ ->limit($limit, $offset)
85
+ ->order('e.entity_id');
86
+ return $this->_getReadAdapter()->fetchAll($select);
 
87
  }
88
  }
89
  ?>
app/code/community/Minubo/Interface/Model/Mysql4/Products.php CHANGED
@@ -7,15 +7,17 @@ class Minubo_Interface_Model_Mysql4_Products extends Mage_Core_Model_Mysql4_Abst
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',
12
  'special_from_date','special_to_date','tax_class_id','required_options',
13
- 'price_type','sku_type','shipment_type','cost','msrp_enabled','msrp',
14
  'small_image','thumbnail','news_from_date','news_to_date','url_key','url_path',
15
  'is_recurring','recurring_profile','image_label','small_image_label',
16
  'thumbnail_label','updated_at','weight_type','price_view',
17
- 'links_purchased_separately','links_exist',
18
- 'msrp_display_actual_price_type','short_description');
19
  $field1 = Mage::getStoreConfig('minubo_interface/settings/productbrand',Mage::app()->getStore());
20
  if(!$field1) $field1 = 'created_at as dummy_brand';
21
  $field2 = Mage::getStoreConfig('minubo_interface/settings/productorigin',Mage::app()->getStore());
@@ -25,6 +27,20 @@ class Minubo_Interface_Model_Mysql4_Products extends Mage_Core_Model_Mysql4_Abst
25
  return array_merge($r, array($field1, $field2), $f);
26
  }
27
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
28
  public function loadByField($field,$value){
29
  $table = $this->getMainTable();
30
  $where = $this->_getReadAdapter()->quoteInto("$field = ?", $value);
7
  }
8
 
9
  protected function getColumns() {
10
+ $cost = Mage::getStoreConfig('minubo_interface/settings/productcost',Mage::app()->getStore());
11
+ if($cost) $cost = $cost.' as ';
12
  $r = array('entity_id','sku','name','type_id','attribute_set_id','created_at','type_id as typeKey','weight',
13
  'visibility','has_options','gift_message_available','price','special_price',
14
  'special_from_date','special_to_date','tax_class_id','required_options',
15
+ 'price_type','price_type as sku_type','shipment_type',$cost.'cost','price as msrp_enabled','price as msrp',
16
  'small_image','thumbnail','news_from_date','news_to_date','url_key','url_path',
17
  'is_recurring','recurring_profile','image_label','small_image_label',
18
  'thumbnail_label','updated_at','weight_type','price_view',
19
+ 'links_exist as links_purchased_separately','links_exist',
20
+ 'price_type as msrp_display_actual_price_type','short_description');
21
  $field1 = Mage::getStoreConfig('minubo_interface/settings/productbrand',Mage::app()->getStore());
22
  if(!$field1) $field1 = 'created_at as dummy_brand';
23
  $field2 = Mage::getStoreConfig('minubo_interface/settings/productorigin',Mage::app()->getStore());
27
  return array_merge($r, array($field1, $field2), $f);
28
  }
29
 
30
+ /*
31
+ SELECT
32
+ entity_id, sku, NAME, type_id, attribute_set_id, created_at, type_id AS typeKey, weight, visibility, has_options,
33
+ gift_message_available, price, special_price, special_from_date, special_to_date, tax_class_id, required_options, price_type,
34
+ -- sku_type, // not available at native instruments
35
+ shipment_type,
36
+ -- cost, // not available at native instruments
37
+ price AS msrp_enabled, price AS msrp, small_image, thumbnail, news_from_date, news_to_date, url_key, url_path, is_recurring,
38
+ recurring_profile, image_label, small_image_label, thumbnail_label, updated_at, weight_type, price_view,
39
+ -- links_purchased_separately, // not available at native instruments
40
+ links_exist, price_type AS msrp_display_actual_price_type, short_description
41
+ FROM catalog_product_flat_1;
42
+ */
43
+
44
  public function loadByField($field,$value){
45
  $table = $this->getMainTable();
46
  $where = $this->_getReadAdapter()->quoteInto("$field = ?", $value);
app/code/community/Minubo/Interface/Model/Read/Collections.php CHANGED
@@ -52,6 +52,7 @@ class Minubo_Interface_Model_Read_Collections extends Minubo_Interface_Model_Rea
52
  public function readCountries($lastChangeDate, $maxChangeDate, $lastOrderID, $maxOrderID, $limit, $offset, $debug, $pdata, $store_id)
53
  {
54
  $countries = Mage::getModel('directory/country')->getResourceCollection()->loadByStore(); // ->toOptionArray(true);
 
55
  return $countries;
56
  }
57
 
52
  public function readCountries($lastChangeDate, $maxChangeDate, $lastOrderID, $maxOrderID, $limit, $offset, $debug, $pdata, $store_id)
53
  {
54
  $countries = Mage::getModel('directory/country')->getResourceCollection()->loadByStore(); // ->toOptionArray(true);
55
+ // $countries = Mage::getModel('directory/country_api')->items();
56
  return $countries;
57
  }
58
 
app/code/community/Minubo/Interface/controllers/ExportController.php CHANGED
@@ -37,6 +37,7 @@ class Minubo_Interface_ExportController extends Mage_Core_Controller_Front_Actio
37
 
38
  public function versionAction()
39
  {
 
40
  // echo Mage::getStoreConfig('minubo_interface/settings/version',Mage::app()->getStore());
41
  echo (string) Mage::getConfig()->getNode()->modules->Minubo_Interface->version;
42
  }
@@ -45,6 +46,8 @@ class Minubo_Interface_ExportController extends Mage_Core_Controller_Front_Actio
45
  {
46
  $this->getParam($lastChangeDate, $maxChangeDate, $lastOrderID, $maxOrderID, $limit, $offset, $debug, $pdata, $store_id, $download);
47
 
 
 
48
  $countries = Mage::getModel('minubo_interface/read_collections')->readCountries($lastChangeDate, $maxChangeDate, $lastOrderID, $maxOrderID, $limit, $offset, $debug, $pdata, $store_id);
49
  echo '# Countries: '.count($countries).'<br>';
50
 
@@ -141,8 +144,6 @@ class Minubo_Interface_ExportController extends Mage_Core_Controller_Front_Actio
141
  function getParam(&$lastChangeDate, &$maxChangeDate, &$lastOrderID, &$maxOrderID, &$limit, &$offset, &$debug, &$pdata, &$store_id, &$download, $nolog = false) {
142
 
143
  $debug = $this->getRequest()->getPost('debug');
144
- if($debug) echo '# memory_get_usage(true): '.memory_get_usage(true).'<br>';
145
- if($debug) echo '# memory_get_usage(false): '.memory_get_usage(false).'<br>';
146
 
147
  $enabled = Mage::getStoreConfig('minubo_interface/settings/active',Mage::app()->getStore());
148
  if(!$enabled) die('Minubo Interface is disabled.');
@@ -151,6 +152,9 @@ class Minubo_Interface_ExportController extends Mage_Core_Controller_Front_Actio
151
  $hash = Mage::getStoreConfig('minubo_interface/settings/hash',Mage::app()->getStore());
152
  if($login!=$hash) die('You are not allowed to access this stuff.');
153
 
 
 
 
154
  $lastChangeDate = $this->getRequest()->getPost('last_change_date');
155
  // if(!$lastChangeDate) $lastChangeDate='2000-01-01';
156
 
@@ -337,7 +341,16 @@ class Minubo_Interface_ExportController extends Mage_Core_Controller_Front_Actio
337
  if($limit>0) {
338
  if($appendStoreId):
339
  if($debug) echo 'readLimitedByStoreId: '.$limit.'/'.$offset.'/'.$store_id.'<br>';
340
- $rows = $model->readLimitedByStoreId($limit, $offset, $store_id);
 
 
 
 
 
 
 
 
 
341
  else:
342
  if($debug) echo 'readLimited: '.$limit.'/'.$offset.'<br>';
343
  $rows = $model->readLimited($limit, $offset);
@@ -345,7 +358,16 @@ class Minubo_Interface_ExportController extends Mage_Core_Controller_Front_Actio
345
  } else {
346
  if($appendStoreId):
347
  if($debug) echo 'readAllByStoreId: '.$store_id.'<br>';
348
- $rows = $model->readAllByStoreId($store_id);
 
 
 
 
 
 
 
 
 
349
  else:
350
  if($debug) echo 'readAll<br>';
351
  $rows = $model->readAll();
37
 
38
  public function versionAction()
39
  {
40
+ $this->getParam($lastChangeDate, $maxChangeDate, $lastOrderID, $maxOrderID, $limit, $offset, $debug, $pdata, $store_id, $download);
41
  // echo Mage::getStoreConfig('minubo_interface/settings/version',Mage::app()->getStore());
42
  echo (string) Mage::getConfig()->getNode()->modules->Minubo_Interface->version;
43
  }
46
  {
47
  $this->getParam($lastChangeDate, $maxChangeDate, $lastOrderID, $maxOrderID, $limit, $offset, $debug, $pdata, $store_id, $download);
48
 
49
+ $store_id = substr($store_id, 0, strpos($store_id.',',','));
50
+
51
  $countries = Mage::getModel('minubo_interface/read_collections')->readCountries($lastChangeDate, $maxChangeDate, $lastOrderID, $maxOrderID, $limit, $offset, $debug, $pdata, $store_id);
52
  echo '# Countries: '.count($countries).'<br>';
53
 
144
  function getParam(&$lastChangeDate, &$maxChangeDate, &$lastOrderID, &$maxOrderID, &$limit, &$offset, &$debug, &$pdata, &$store_id, &$download, $nolog = false) {
145
 
146
  $debug = $this->getRequest()->getPost('debug');
 
 
147
 
148
  $enabled = Mage::getStoreConfig('minubo_interface/settings/active',Mage::app()->getStore());
149
  if(!$enabled) die('Minubo Interface is disabled.');
152
  $hash = Mage::getStoreConfig('minubo_interface/settings/hash',Mage::app()->getStore());
153
  if($login!=$hash) die('You are not allowed to access this stuff.');
154
 
155
+ if($debug) echo '# memory_get_usage(true): '.memory_get_usage(true).'<br>';
156
+ if($debug) echo '# memory_get_usage(false): '.memory_get_usage(false).'<br>';
157
+
158
  $lastChangeDate = $this->getRequest()->getPost('last_change_date');
159
  // if(!$lastChangeDate) $lastChangeDate='2000-01-01';
160
 
341
  if($limit>0) {
342
  if($appendStoreId):
343
  if($debug) echo 'readLimitedByStoreId: '.$limit.'/'.$offset.'/'.$store_id.'<br>';
344
+ $store_ids = split(',', $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);
358
  } else {
359
  if($appendStoreId):
360
  if($debug) echo 'readAllByStoreId: '.$store_id.'<br>';
361
+ $store_ids = split(',', $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();
app/code/community/Minubo/Interface/etc/config.xml CHANGED
@@ -2,7 +2,7 @@
2
  <config>
3
  <modules>
4
  <Minubo_Interface>
5
- <version>1.0.16</version>
6
  </Minubo_Interface>
7
  </modules>
8
  <global>
2
  <config>
3
  <modules>
4
  <Minubo_Interface>
5
+ <version>1.0.22</version>
6
  </Minubo_Interface>
7
  </modules>
8
  <global>
app/code/community/Minubo/Interface/etc/system.xml CHANGED
@@ -1,75 +1,75 @@
1
  <?xml version="1.0"?>
2
  <config>
3
- <sections>
4
- <minubo_interface translate="label" module="minubo_interface">
5
  <label>Minubo Interface</label>
6
  <tab>sales</tab>
7
- <frontend_type>text</frontend_type>
8
- <show_in_default>1</show_in_default>
9
- <show_in_website>1</show_in_website>
10
- <show_in_store>1</show_in_store>
11
- <sort_order>1000</sort_order>
12
- <groups>
13
- <settings translate="label">
14
- <label>Minubo Interface Settings</label>
15
- <frontend_type>text</frontend_type>
16
- <show_in_default>1</show_in_default>
17
- <show_in_website>1</show_in_website>
18
- <show_in_store>1</show_in_store>
19
- <comment>
20
- <![CDATA[
21
- <div style="padding:10px;background-color:#fff;border:1px solid #ddd;margin-bottom:7px;">
22
- This module was developed by <a href="http://www.minubo.com" target="_blank">www.minubo.com</a> - <b>smart metrics now.</b>
23
- <br/>For docs & examples refer to the minubo <a href="http://minubo.com/blog_de?lang=de">blog</a>.
24
- <br/>Need more features in your minubo desktop? Visit <a href="http://www.minubo.com" target="_blank">minubo - smart metrics now.</a> for more information.</a>
25
- </div>
26
- ]]>
27
- </comment>
28
- <fields>
29
- <active translate="label">
30
- <label>Enabled</label>
31
- <frontend_type>select</frontend_type>
32
- <source_model>adminhtml/system_config_source_yesno</source_model>
33
- <sort_order>0</sort_order>
34
- <show_in_default>1</show_in_default>
35
- <show_in_website>1</show_in_website>
36
- <show_in_store>0</show_in_store>
37
- </active>
38
- <version translate="label">
39
- <label>Minubo Interface Version</label>
40
- <frontend_type>label</frontend_type>
41
- <frontend_model>Minubo_Interface_Block_Adminhtml_Version</frontend_model>
42
- <sort_order>1</sort_order>
43
- <show_in_default>1</show_in_default>
44
- <show_in_website>1</show_in_website>
45
- <show_in_store>0</show_in_store>
46
- </version>
47
- <hash translate="label">
48
- <label>Authorization-Code</label>
49
- <frontend_type>text</frontend_type>
50
- <sort_order>2</sort_order>
51
- <show_in_default>1</show_in_default>
52
- <show_in_website>1</show_in_website>
53
- <show_in_store>0</show_in_store>
54
- </hash>
55
- <newhash>
56
- <label>New Authorization-Code</label>
57
- <frontend_type>button</frontend_type>
58
- <frontend_model>minubo_interface/adminhtml_system_config_form_button</frontend_model>
59
- <sort_order>3</sort_order>
60
- <show_in_default>1</show_in_default>
61
- <show_in_website>1</show_in_website>
62
- <show_in_store>0</show_in_store>
63
- </newhash>
64
- <!-- output_type translate="label">
65
- <label>Output type</label>
66
- <frontend_type>select</frontend_type>
67
- <source_model>Minubo_Interface_Model_Options_Options</source_model>
68
- <sort_order>4</sort_order>
69
- <show_in_default>1</show_in_default>
70
- <show_in_website>1</show_in_website>
71
- <show_in_store>0</show_in_store>
72
- </output_type -->
73
  <storeid translate="label">
74
  <label>Store ID (optional, Default: 1)</label>
75
  <frontend_type>text</frontend_type>
@@ -86,10 +86,26 @@
86
  <show_in_website>1</show_in_website>
87
  <show_in_store>0</show_in_store>
88
  </orderfields>
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
89
  <productbrand translate="label">
90
  <label>Additional product-field brand (see catalog_product_flat_1)</label>
91
  <frontend_type>text</frontend_type>
92
- <sort_order>6</sort_order>
93
  <show_in_default>1</show_in_default>
94
  <show_in_website>1</show_in_website>
95
  <show_in_store>0</show_in_store>
@@ -97,7 +113,7 @@
97
  <productorigin translate="label">
98
  <label>Additional product-field country of origin (see catalog_product_flat_1)</label>
99
  <frontend_type>text</frontend_type>
100
- <sort_order>7</sort_order>
101
  <show_in_default>1</show_in_default>
102
  <show_in_website>1</show_in_website>
103
  <show_in_store>0</show_in_store>
@@ -105,7 +121,7 @@
105
  <productfields translate="label">
106
  <label>Additional product-fields (comma-separated, see catalog_product_flat_1)</label>
107
  <frontend_type>text</frontend_type>
108
- <sort_order>8</sort_order>
109
  <show_in_default>1</show_in_default>
110
  <show_in_website>1</show_in_website>
111
  <show_in_store>0</show_in_store>
@@ -113,46 +129,46 @@
113
  <attributefields translate="label">
114
  <label>Additional product-attribute-fields (comma-separated, see eav_attribute.attribute_code -> catalog_product_entity_varchar)</label>
115
  <frontend_type>text</frontend_type>
116
- <sort_order>9</sort_order>
117
  <show_in_default>1</show_in_default>
118
  <show_in_website>1</show_in_website>
119
  <show_in_store>0</show_in_store>
120
  </attributefields>
121
  <lastexportstartdate translate="label">
122
- <label>Last Export started at</label>
123
- <frontend_type>label</frontend_type>
124
- <sort_order>10</sort_order>
125
- <show_in_default>1</show_in_default>
126
- <show_in_website>1</show_in_website>
127
- <show_in_store>0</show_in_store>
128
- </lastexportstartdate>
129
- <lastexportenddate translate="label">
130
- <label>Last Export ended at</label>
131
- <frontend_type>label</frontend_type>
132
- <sort_order>11</sort_order>
133
- <show_in_default>1</show_in_default>
134
- <show_in_website>1</show_in_website>
135
- <show_in_store>0</show_in_store>
136
- </lastexportenddate>
137
- <firstchangedate translate="label">
138
- <label>Last Export from Change-Date</label>
139
- <frontend_type>label</frontend_type>
140
- <sort_order>12</sort_order>
141
- <show_in_default>1</show_in_default>
142
- <show_in_website>1</show_in_website>
143
- <show_in_store>0</show_in_store>
144
- </firstchangedate>
145
- <lastchangedate translate="label">
146
- <label>Last Export to Change-Date</label>
147
- <frontend_type>label</frontend_type>
148
- <sort_order>13</sort_order>
149
- <show_in_default>1</show_in_default>
150
- <show_in_website>1</show_in_website>
151
- <show_in_store>0</show_in_store>
152
- </lastchangedate>
153
- </fields>
154
- </settings>
155
- </groups>
156
- </minubo_interface>
157
- </sections>
158
  </config>
1
  <?xml version="1.0"?>
2
  <config>
3
+ <sections>
4
+ <minubo_interface translate="label" module="minubo_interface">
5
  <label>Minubo Interface</label>
6
  <tab>sales</tab>
7
+ <frontend_type>text</frontend_type>
8
+ <show_in_default>1</show_in_default>
9
+ <show_in_website>1</show_in_website>
10
+ <show_in_store>1</show_in_store>
11
+ <sort_order>1000</sort_order>
12
+ <groups>
13
+ <settings translate="label">
14
+ <label>Minubo Interface Settings</label>
15
+ <frontend_type>text</frontend_type>
16
+ <show_in_default>1</show_in_default>
17
+ <show_in_website>1</show_in_website>
18
+ <show_in_store>1</show_in_store>
19
+ <comment>
20
+ <![CDATA[
21
+ <div style="padding:10px;background-color:#fff;border:1px solid #ddd;margin-bottom:7px;">
22
+ This module was developed by <a href="http://www.minubo.com" target="_blank">www.minubo.com</a> - <b>smart metrics now.</b>
23
+ <br/>For docs & examples refer to the minubo <a href="http://minubo.com/blog_de?lang=de">blog</a>.
24
+ <br/>Need more features in your minubo desktop? Visit <a href="http://www.minubo.com" target="_blank">minubo - smart metrics now.</a> for more information.</a>
25
+ </div>
26
+ ]]>
27
+ </comment>
28
+ <fields>
29
+ <active translate="label">
30
+ <label>Enabled</label>
31
+ <frontend_type>select</frontend_type>
32
+ <source_model>adminhtml/system_config_source_yesno</source_model>
33
+ <sort_order>0</sort_order>
34
+ <show_in_default>1</show_in_default>
35
+ <show_in_website>1</show_in_website>
36
+ <show_in_store>0</show_in_store>
37
+ </active>
38
+ <version translate="label">
39
+ <label>Minubo Interface Version</label>
40
+ <frontend_type>label</frontend_type>
41
+ <frontend_model>Minubo_Interface_Block_Adminhtml_Version</frontend_model>
42
+ <sort_order>1</sort_order>
43
+ <show_in_default>1</show_in_default>
44
+ <show_in_website>1</show_in_website>
45
+ <show_in_store>0</show_in_store>
46
+ </version>
47
+ <hash translate="label">
48
+ <label>Authorization-Code</label>
49
+ <frontend_type>text</frontend_type>
50
+ <sort_order>2</sort_order>
51
+ <show_in_default>1</show_in_default>
52
+ <show_in_website>1</show_in_website>
53
+ <show_in_store>0</show_in_store>
54
+ </hash>
55
+ <newhash>
56
+ <label>New Authorization-Code</label>
57
+ <frontend_type>button</frontend_type>
58
+ <frontend_model>minubo_interface/adminhtml_system_config_form_button</frontend_model>
59
+ <sort_order>3</sort_order>
60
+ <show_in_default>1</show_in_default>
61
+ <show_in_website>1</show_in_website>
62
+ <show_in_store>0</show_in_store>
63
+ </newhash>
64
+ <!-- output_type translate="label">
65
+ <label>Output type</label>
66
+ <frontend_type>select</frontend_type>
67
+ <source_model>Minubo_Interface_Model_Options_Options</source_model>
68
+ <sort_order>4</sort_order>
69
+ <show_in_default>1</show_in_default>
70
+ <show_in_website>1</show_in_website>
71
+ <show_in_store>0</show_in_store>
72
+ </output_type -->
73
  <storeid translate="label">
74
  <label>Store ID (optional, Default: 1)</label>
75
  <frontend_type>text</frontend_type>
86
  <show_in_website>1</show_in_website>
87
  <show_in_store>0</show_in_store>
88
  </orderfields>
89
+ <orderaddcost translate="label">
90
+ <label>Additional order-costs to be calculated to base_Shipping_Amount (f.e. "(o.base_Shipping_Amount+1.50)"; Default:[empty]=sales_flat_order.base_Shipping_Amount)</label>
91
+ <frontend_type>text</frontend_type>
92
+ <sort_order>6</sort_order>
93
+ <show_in_default>1</show_in_default>
94
+ <show_in_website>1</show_in_website>
95
+ <show_in_store>0</show_in_store>
96
+ </orderaddcost>
97
+ <productcost translate="label">
98
+ <label>Calculated product-costs (f.e. "IFNULL(price, 0)*0.3"; Default:[empty]=catalog_product_flat_1.cost)</label>
99
+ <frontend_type>text</frontend_type>
100
+ <sort_order>7</sort_order>
101
+ <show_in_default>1</show_in_default>
102
+ <show_in_website>1</show_in_website>
103
+ <show_in_store>0</show_in_store>
104
+ </productcost>
105
  <productbrand translate="label">
106
  <label>Additional product-field brand (see catalog_product_flat_1)</label>
107
  <frontend_type>text</frontend_type>
108
+ <sort_order>8</sort_order>
109
  <show_in_default>1</show_in_default>
110
  <show_in_website>1</show_in_website>
111
  <show_in_store>0</show_in_store>
113
  <productorigin translate="label">
114
  <label>Additional product-field country of origin (see catalog_product_flat_1)</label>
115
  <frontend_type>text</frontend_type>
116
+ <sort_order>9</sort_order>
117
  <show_in_default>1</show_in_default>
118
  <show_in_website>1</show_in_website>
119
  <show_in_store>0</show_in_store>
121
  <productfields translate="label">
122
  <label>Additional product-fields (comma-separated, see catalog_product_flat_1)</label>
123
  <frontend_type>text</frontend_type>
124
+ <sort_order>10</sort_order>
125
  <show_in_default>1</show_in_default>
126
  <show_in_website>1</show_in_website>
127
  <show_in_store>0</show_in_store>
129
  <attributefields translate="label">
130
  <label>Additional product-attribute-fields (comma-separated, see eav_attribute.attribute_code -> catalog_product_entity_varchar)</label>
131
  <frontend_type>text</frontend_type>
132
+ <sort_order>11</sort_order>
133
  <show_in_default>1</show_in_default>
134
  <show_in_website>1</show_in_website>
135
  <show_in_store>0</show_in_store>
136
  </attributefields>
137
  <lastexportstartdate translate="label">
138
+ <label>Last Export started at</label>
139
+ <frontend_type>label</frontend_type>
140
+ <sort_order>10</sort_order>
141
+ <show_in_default>1</show_in_default>
142
+ <show_in_website>1</show_in_website>
143
+ <show_in_store>0</show_in_store>
144
+ </lastexportstartdate>
145
+ <lastexportenddate translate="label">
146
+ <label>Last Export ended at</label>
147
+ <frontend_type>label</frontend_type>
148
+ <sort_order>11</sort_order>
149
+ <show_in_default>1</show_in_default>
150
+ <show_in_website>1</show_in_website>
151
+ <show_in_store>0</show_in_store>
152
+ </lastexportenddate>
153
+ <firstchangedate translate="label">
154
+ <label>Last Export from Change-Date</label>
155
+ <frontend_type>label</frontend_type>
156
+ <sort_order>12</sort_order>
157
+ <show_in_default>1</show_in_default>
158
+ <show_in_website>1</show_in_website>
159
+ <show_in_store>0</show_in_store>
160
+ </firstchangedate>
161
+ <lastchangedate translate="label">
162
+ <label>Last Export to Change-Date</label>
163
+ <frontend_type>label</frontend_type>
164
+ <sort_order>13</sort_order>
165
+ <show_in_default>1</show_in_default>
166
+ <show_in_website>1</show_in_website>
167
+ <show_in_store>0</show_in_store>
168
+ </lastchangedate>
169
+ </fields>
170
+ </settings>
171
+ </groups>
172
+ </minubo_interface>
173
+ </sections>
174
  </config>
package.xml CHANGED
@@ -1,19 +1,18 @@
1
  <?xml version="1.0"?>
2
  <package>
3
  <name>Minubo_Interface</name>
4
- <version>1.0.16</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>Optional additional fields in order headers (coupon_code).&#xD;
12
- Removed field "product_options" in order lines because of may-be corrupt content.</notes>
13
  <authors><author><name>sven rothe</name><user>minubo</user><email>sven@minubo.com</email></author></authors>
14
- <date>2013-11-01</date>
15
- <time>10:09:54</time>
16
- <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="ec84aecc9efe31e0ac3be742ad973bcb"/><file name="Creditmemos.php" hash="2c9e399bdd89749815e3ebfac0b2337e"/><file name="Customeraddresses.php" hash="51b01e757c7b362dfc7fa6978bbfadb8"/><file name="Customers.php" hash="bc7ea00bed52bee359d4fabc6b6737e7"/><file name="Invoiceitems.php" hash="ae59d2c274a5dd8980f89e08707d342e"/><file name="Invoices.php" hash="4822b837cbdc8f4efb8b9314ca8d9c7f"/><file name="Orderaddresses.php" hash="f0ba0d7ef804ae787f72c67f5f7c31c5"/><file name="Orderitems.php" hash="db5e58f8288bc0882649be768c7f915a"/><file name="Orders.php" hash="527473746c1c83be7a142c116ec8885f"/><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="4e60f5e0bf88984ffa12567ea2e6b3c8"/></dir><dir name="etc"><file name="adminhtml.xml" hash="375c548aacaf6f1bfdf4de3af7b29dfb"/><file name="config.xml" hash="73a4c22fc05f5de651b0fcf9e60478bf"/><file name="system.xml" hash="fa3045a31b3f51b7e2bdbeb8bbf41b30"/></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>
17
  <compatible/>
18
  <dependencies><required><php><min>5.1.0</min><max>6.0.0</max></php></required></dependencies>
19
  </package>
1
  <?xml version="1.0"?>
2
  <package>
3
  <name>Minubo_Interface</name>
4
+ <version>1.0.22</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>Extensions for Multi-Store-IDs, Stores without costs on items, Orders without delivery addresses (for example with download items)</notes>
 
12
  <authors><author><name>sven rothe</name><user>minubo</user><email>sven@minubo.com</email></author></authors>
13
+ <date>2014-04-04</date>
14
+ <time>07:17:34</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="51b01e757c7b362dfc7fa6978bbfadb8"/><file name="Customers.php" hash="bc7ea00bed52bee359d4fabc6b6737e7"/><file name="Invoiceitems.php" hash="0273220176bcf5487b6975fbb485b1cd"/><file name="Invoices.php" hash="8f467284eadc5d1885d1df00d007fdd5"/><file name="Orderaddresses.php" hash="f0ba0d7ef804ae787f72c67f5f7c31c5"/><file name="Orderitems.php" hash="75d14acbb7c45a369549bceb24b3c108"/><file name="Orders.php" hash="2016cdf96c6e4a22ae35ff9c0a57ceaf"/><file name="Productattributes.php" hash="6a4c275d6fabcfae4a901a78ba621856"/><file name="Productcategories.php" hash="56a00cecf2cfe994fdeae9db947f653d"/><file name="Products.php" hash="97a551c7a046a57ae98f1155848b5833"/><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="579e47ecc6c4bd298fefcd7346d65c4d"/></dir><dir name="etc"><file name="adminhtml.xml" hash="375c548aacaf6f1bfdf4de3af7b29dfb"/><file name="config.xml" hash="3b650d55ac622f5c88097f06034052da"/><file name="system.xml" hash="53922cd29b7caf441d86fa68ec9f92fd"/></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>