Minubo_Interface - Version 1.0.24

Version Notes

Extension for calculated shipping costs, optional email in customer data for CRM export of selected customers from minubo

Download this release

Release Info

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


Code changes from version 1.0.22 to 1.0.24

Files changed (8) hide show
  1. app/code/community/Minubo/Interface/Model/Mysql4/Customeraddresses.php +9 -1
  2. app/code/community/Minubo/Interface/Model/Mysql4/Customers.php +41 -33
  3. app/code/community/Minubo/Interface/Model/Mysql4/Orderaddresses.php +14 -6
  4. app/code/community/Minubo/Interface/Model/Mysql4/Orders.php +4 -1
  5. app/code/community/Minubo/Interface/Model/Mysql4/Products.php +3 -1
  6. app/code/community/Minubo/Interface/etc/config.xml +1 -1
  7. app/code/community/Minubo/Interface/etc/system.xml +22 -13
  8. package.xml +5 -5
app/code/community/Minubo/Interface/Model/Mysql4/Customeraddresses.php CHANGED
@@ -7,7 +7,15 @@ class Minubo_Interface_Model_Mysql4_Customeraddresses extends Mage_Core_Model_My
7
  }
8
 
9
  protected function getColumns() {
10
- return array('oa.entity_id','oa.customer_address_id','oa.region_id','oa.region','oa.postcode','oa.city','oa.country_id','oa.address_type','MD5(oa.email) AS Customer_HashCode','c.group_id','cg.customer_group_code','o.store_id');
 
 
 
 
 
 
 
 
11
  }
12
 
13
  public function loadByField($field,$value){
7
  }
8
 
9
  protected function getColumns() {
10
+ $r = array('oa.entity_id','oa.customer_address_id','oa.region_id','oa.region','oa.postcode','oa.city',
11
+ 'oa.country_id','oa.address_type','MD5(oa.email) AS Customer_HashCode','c.group_id',
12
+ 'cg.customer_group_code','o.store_id');
13
+ $showemail = Mage::getStoreConfig('minubo_interface/settings/showemail',Mage::app()->getStore());
14
+ if($showemail)
15
+ $field1 = 'email';
16
+ else
17
+ $field1 = "'' as email";
18
+ return array_merge($r, array($field1));
19
  }
20
 
21
  public function loadByField($field,$value){
app/code/community/Minubo/Interface/Model/Mysql4/Customers.php CHANGED
@@ -1,57 +1,65 @@
1
  <?php
2
  class Minubo_Interface_Model_Mysql4_Customers extends Mage_Core_Model_Mysql4_Abstract
3
  {
4
- public function _construct()
5
- {
6
- $this->_init('minubo_interface/customers', 'entity_id');
7
- }
8
 
9
  protected function getColumns() {
10
- return array('entity_id','entity_type_id','attribute_set_id','website_id','MD5(email) AS Customer_HashCode','group_id','increment_id','store_id','created_at','updated_at','is_active','disable_auto_group_change','cg.customer_group_id','cg.customer_group_code','cg.tax_class_id');
11
- }
 
 
 
 
 
 
 
 
12
 
13
- public function loadByField($field,$value){
14
- $table = $this->getMainTable();
15
- $table2 = $this->getTable('customer_group');
16
- $cond2 = $this->_getReadAdapter()->quoteInto('c.group_id = cg.customer_group_id','');
17
- $where = $this->_getReadAdapter()->quoteInto("$field = ?", $value);
18
- $select = $this->_getReadAdapter()->select()->from(array('c'=>$table))
19
  ->join(array('cg'=>$table2), $cond2)
20
  ->reset('columns')
21
  ->columns($this->getColumns())
22
- ->where($where);
23
  $id = $this->_getReadAdapter()->fetchOne($select);
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')
35
  ->columns($this->getColumns())
36
- ->where($where)
37
- ->order('c.entity_id');
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')
49
  ->columns($this->getColumns())
50
- ->where($where)
51
- ->limit($limit, $offset)
52
- ->order('c.entity_id');
53
- return $this->_getReadAdapter()->fetchAll($select);
54
- }
55
 
56
  }
57
  ?>
1
  <?php
2
  class Minubo_Interface_Model_Mysql4_Customers extends Mage_Core_Model_Mysql4_Abstract
3
  {
4
+ public function _construct()
5
+ {
6
+ $this->_init('minubo_interface/customers', 'entity_id');
7
+ }
8
 
9
  protected function getColumns() {
10
+ $r = array('entity_id','entity_type_id','attribute_set_id','website_id','MD5(email) AS Customer_HashCode',
11
+ 'group_id','increment_id','store_id','created_at','updated_at','is_active','disable_auto_group_change',
12
+ 'cg.customer_group_id','cg.customer_group_code','cg.tax_class_id');
13
+ $showemail = Mage::getStoreConfig('minubo_interface/settings/showemail',Mage::app()->getStore());
14
+ if($showemail)
15
+ $field1 = 'email';
16
+ else
17
+ $field1 = "'' as email";
18
+ return array_merge($r, array($field1));
19
+ }
20
 
21
+ public function loadByField($field,$value){
22
+ $table = $this->getMainTable();
23
+ $table2 = $this->getTable('customer_group');
24
+ $cond2 = $this->_getReadAdapter()->quoteInto('c.group_id = cg.customer_group_id','');
25
+ $where = $this->_getReadAdapter()->quoteInto("$field = ?", $value);
26
+ $select = $this->_getReadAdapter()->select()->from(array('c'=>$table))
27
  ->join(array('cg'=>$table2), $cond2)
28
  ->reset('columns')
29
  ->columns($this->getColumns())
30
+ ->where($where);
31
  $id = $this->_getReadAdapter()->fetchOne($select);
32
+ return $id;
33
+ }
34
 
35
+ public function loadAllByStoreId($store_id){
36
+ $table = $this->getMainTable();
37
+ $table2 = $this->getTable('customer_group');
38
+ $cond2 = $this->_getReadAdapter()->quoteInto('c.group_id = cg.customer_group_id','');
39
+ $where = $this->_getReadAdapter()->quoteInto("c.store_id = ?", $store_id);
40
  $select = $this->_getReadAdapter()->select()->from(array('c'=>$table))
41
  ->join(array('cg'=>$table2), $cond2)
42
  ->reset('columns')
43
  ->columns($this->getColumns())
44
+ ->where($where)
45
+ ->order('c.entity_id');
46
  return $this->_getReadAdapter()->fetchAll($select);
47
+ }
48
 
49
+ public function loadLimitedByStoreId($limit, $offset, $store_id){
50
+ $table = $this->getMainTable();
51
+ $table2 = $this->getTable('customer_group');
52
+ $cond2 = $this->_getReadAdapter()->quoteInto('c.group_id = cg.customer_group_id','');
53
+ $where = $this->_getReadAdapter()->quoteInto("c.store_id = ?", $store_id);
54
  $select = $this->_getReadAdapter()->select()->from(array('c'=>$table))
55
  ->join(array('cg'=>$table2), $cond2)
56
  ->reset('columns')
57
  ->columns($this->getColumns())
58
+ ->where($where)
59
+ ->limit($limit, $offset)
60
+ ->order('c.entity_id');
61
+ return $this->_getReadAdapter()->fetchAll($select);
62
+ }
63
 
64
  }
65
  ?>
app/code/community/Minubo/Interface/Model/Mysql4/Orderaddresses.php CHANGED
@@ -7,12 +7,20 @@ class Minubo_Interface_Model_Mysql4_Orderaddresses extends Mage_Core_Model_Mysql
7
  }
8
 
9
  protected function getColumns() {
10
- return array('oab.entity_id as customerId','o.created_at','oab.customer_address_id as incrementKey','o.store_id',
11
- 'o.store_id as websiteKey','o.store_name','o.customer_group_id','o.customer_dob','oab.prefix',"ifnull(oab.customer_address_id,concat('g_',oab.entity_id)) as customerNumber",
12
- 'oab.entity_id as billingCustomerAddressKey','oab.entity_id as billingIncrementKey','oab.city','oab.country_id','oab.postcode',
13
- 'oab.region','oab.region_id','oab.address_type',
14
- 'oas.entity_id as shippingIncrementKey','oas.city as shippingCity','oas.country_id as shippingCountry','oas.postcode as shippingPostcode',
15
- 'oas.region as shippingRegion','oas.region_id as shippingRegionId','oas.address_type as shippingAddressType','md5(o.customer_email) as Customer_HashCode');
 
 
 
 
 
 
 
 
16
  }
17
 
18
  public function loadByField($field,$value){
7
  }
8
 
9
  protected function getColumns() {
10
+ $r = array('oab.entity_id as customerId','o.created_at','oab.customer_address_id as incrementKey','o.store_id',
11
+ 'o.store_id as websiteKey','o.store_name','o.customer_group_id','o.customer_dob','oab.prefix',
12
+ "ifnull(oab.customer_address_id,concat('g_',oab.entity_id)) as customerNumber",
13
+ 'oab.entity_id as billingCustomerAddressKey','oab.entity_id as billingIncrementKey','oab.city',
14
+ 'oab.country_id','oab.postcode','oab.region','oab.region_id','oab.address_type',
15
+ 'oas.entity_id as shippingIncrementKey','oas.city as shippingCity','oas.country_id as shippingCountry',
16
+ 'oas.postcode as shippingPostcode','oas.region as shippingRegion','oas.region_id as shippingRegionId',
17
+ 'oas.address_type as shippingAddressType','md5(o.customer_email) as Customer_HashCode');
18
+ $showemail = Mage::getStoreConfig('minubo_interface/settings/showemail',Mage::app()->getStore());
19
+ if($showemail)
20
+ $field1 = 'email';
21
+ else
22
+ $field1 = 'substring(oab.email,1,0) as email';
23
+ return array_merge($r, array($field1));
24
  }
25
 
26
  public function loadByField($field,$value){
app/code/community/Minubo/Interface/Model/Mysql4/Orders.php CHANGED
@@ -7,6 +7,9 @@ class Minubo_Interface_Model_Mysql4_Orders extends Mage_Core_Model_Mysql4_Abstra
7
  }
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',
@@ -14,7 +17,7 @@ class Minubo_Interface_Model_Mysql4_Orders extends Mage_Core_Model_Mysql4_Abstra
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',
17
- 'base_Tax_Amount','base_Shipping_Amount','base_Discount_Amount','base_Grand_Total','base_Subtotal','base_Total_Paid','base_Total_Refunded',
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',
7
  }
8
 
9
  protected function getColumns() {
10
+ $orderaddcost = Mage::getStoreConfig('minubo_interface/settings/orderaddcost',Mage::app()->getStore());
11
+ if($orderaddcost) $orderaddcost = '('.$orderaddcost.') as ';
12
+
13
  $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",
14
  'ifnull(oas.postcode,oab.postcode) as shippingAddressPostcode','ifnull(oas.city,oab.city) as shippingAddressCity','ifnull(oas.country_id,oab.country_id) as shippingAddressCountryId',
15
  'ifnull(oas.entity_id,oab.entity_id) as shippingAddressIncrementId','ifnull(oas.parent_id,oab.parent_id) as shippingAddressParentId',
17
  'shipping_address_id as shippingAddressAddressId',
18
  'o.created_at as shippingAddressCreatedAt','o.updated_at as shippingAddressUpdatedAt','tax_Amount','shipping_Amount','discount_Amount','subtotal','grand_Total','total_Paid',
19
  'total_Refunded','total_Qty_Ordered','total_Canceled','total_Invoiced',
20
+ 'base_Tax_Amount',$orderaddcost.'base_Shipping_Amount','base_Discount_Amount','base_Grand_Total','base_Subtotal','base_Total_Paid','base_Total_Refunded',
21
  'base_Total_Qty_Ordered','base_Total_Canceled','base_Total_Invoiced',
22
  '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',
23
  'global_Currency_Code','base_Currency_Code','store_Currency_Code',
app/code/community/Minubo/Interface/Model/Mysql4/Products.php CHANGED
@@ -8,7 +8,8 @@ class Minubo_Interface_Model_Mysql4_Products extends Mage_Core_Model_Mysql4_Abst
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',
@@ -18,6 +19,7 @@ class Minubo_Interface_Model_Mysql4_Products extends Mage_Core_Model_Mysql4_Abst
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());
8
 
9
  protected function getColumns() {
10
  $cost = Mage::getStoreConfig('minubo_interface/settings/productcost',Mage::app()->getStore());
11
+ if($cost) $cost = '('.$cost.') as ';
12
+
13
  $r = array('entity_id','sku','name','type_id','attribute_set_id','created_at','type_id as typeKey','weight',
14
  'visibility','has_options','gift_message_available','price','special_price',
15
  'special_from_date','special_to_date','tax_class_id','required_options',
19
  'thumbnail_label','updated_at','weight_type','price_view',
20
  'links_exist as links_purchased_separately','links_exist',
21
  'price_type as msrp_display_actual_price_type','short_description');
22
+
23
  $field1 = Mage::getStoreConfig('minubo_interface/settings/productbrand',Mage::app()->getStore());
24
  if(!$field1) $field1 = 'created_at as dummy_brand';
25
  $field2 = Mage::getStoreConfig('minubo_interface/settings/productorigin',Mage::app()->getStore());
app/code/community/Minubo/Interface/etc/config.xml CHANGED
@@ -2,7 +2,7 @@
2
  <config>
3
  <modules>
4
  <Minubo_Interface>
5
- <version>1.0.22</version>
6
  </Minubo_Interface>
7
  </modules>
8
  <global>
2
  <config>
3
  <modules>
4
  <Minubo_Interface>
5
+ <version>1.1.24</version>
6
  </Minubo_Interface>
7
  </modules>
8
  <global>
app/code/community/Minubo/Interface/etc/system.xml CHANGED
@@ -20,7 +20,7 @@
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
  ]]>
@@ -73,15 +73,24 @@
73
  <storeid translate="label">
74
  <label>Store ID (optional, Default: 1)</label>
75
  <frontend_type>text</frontend_type>
76
- <sort_order>4</sort_order>
77
  <show_in_default>1</show_in_default>
78
  <show_in_website>1</show_in_website>
79
  <show_in_store>0</show_in_store>
80
  </storeid>
 
 
 
 
 
 
 
 
 
81
  <orderfields translate="label">
82
  <label>Additional order-field (see sales_flat_order)</label>
83
  <frontend_type>text</frontend_type>
84
- <sort_order>5</sort_order>
85
  <show_in_default>1</show_in_default>
86
  <show_in_website>1</show_in_website>
87
  <show_in_store>0</show_in_store>
@@ -89,7 +98,7 @@
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>
@@ -97,7 +106,7 @@
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>
@@ -105,7 +114,7 @@
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,7 +122,7 @@
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,7 +130,7 @@
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,7 +138,7 @@
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>
@@ -137,7 +146,7 @@
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>
@@ -145,7 +154,7 @@
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>
@@ -153,7 +162,7 @@
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>
@@ -161,7 +170,7 @@
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>
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://www.minubo.com/category/blog-en/">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
  ]]>
73
  <storeid translate="label">
74
  <label>Store ID (optional, Default: 1)</label>
75
  <frontend_type>text</frontend_type>
76
+ <sort_order>5</sort_order>
77
  <show_in_default>1</show_in_default>
78
  <show_in_website>1</show_in_website>
79
  <show_in_store>0</show_in_store>
80
  </storeid>
81
+ <showemail translate="label">
82
+ <label>Show e-mail for CRM exports</label>
83
+ <frontend_type>select</frontend_type>
84
+ <source_model>adminhtml/system_config_source_yesno</source_model>
85
+ <sort_order>6</sort_order>
86
+ <show_in_default>1</show_in_default>
87
+ <show_in_website>1</show_in_website>
88
+ <show_in_store>0</show_in_store>
89
+ </showemail>
90
  <orderfields translate="label">
91
  <label>Additional order-field (see sales_flat_order)</label>
92
  <frontend_type>text</frontend_type>
93
+ <sort_order>7</sort_order>
94
  <show_in_default>1</show_in_default>
95
  <show_in_website>1</show_in_website>
96
  <show_in_store>0</show_in_store>
98
  <orderaddcost translate="label">
99
  <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>
100
  <frontend_type>text</frontend_type>
101
+ <sort_order>8</sort_order>
102
  <show_in_default>1</show_in_default>
103
  <show_in_website>1</show_in_website>
104
  <show_in_store>0</show_in_store>
106
  <productcost translate="label">
107
  <label>Calculated product-costs (f.e. "IFNULL(price, 0)*0.3"; Default:[empty]=catalog_product_flat_1.cost)</label>
108
  <frontend_type>text</frontend_type>
109
+ <sort_order>9</sort_order>
110
  <show_in_default>1</show_in_default>
111
  <show_in_website>1</show_in_website>
112
  <show_in_store>0</show_in_store>
114
  <productbrand translate="label">
115
  <label>Additional product-field brand (see catalog_product_flat_1)</label>
116
  <frontend_type>text</frontend_type>
117
+ <sort_order>10</sort_order>
118
  <show_in_default>1</show_in_default>
119
  <show_in_website>1</show_in_website>
120
  <show_in_store>0</show_in_store>
122
  <productorigin translate="label">
123
  <label>Additional product-field country of origin (see catalog_product_flat_1)</label>
124
  <frontend_type>text</frontend_type>
125
+ <sort_order>11</sort_order>
126
  <show_in_default>1</show_in_default>
127
  <show_in_website>1</show_in_website>
128
  <show_in_store>0</show_in_store>
130
  <productfields translate="label">
131
  <label>Additional product-fields (comma-separated, see catalog_product_flat_1)</label>
132
  <frontend_type>text</frontend_type>
133
+ <sort_order>12</sort_order>
134
  <show_in_default>1</show_in_default>
135
  <show_in_website>1</show_in_website>
136
  <show_in_store>0</show_in_store>
138
  <attributefields translate="label">
139
  <label>Additional product-attribute-fields (comma-separated, see eav_attribute.attribute_code -> catalog_product_entity_varchar)</label>
140
  <frontend_type>text</frontend_type>
141
+ <sort_order>13</sort_order>
142
  <show_in_default>1</show_in_default>
143
  <show_in_website>1</show_in_website>
144
  <show_in_store>0</show_in_store>
146
  <lastexportstartdate translate="label">
147
  <label>Last Export started at</label>
148
  <frontend_type>label</frontend_type>
149
+ <sort_order>14</sort_order>
150
  <show_in_default>1</show_in_default>
151
  <show_in_website>1</show_in_website>
152
  <show_in_store>0</show_in_store>
154
  <lastexportenddate translate="label">
155
  <label>Last Export ended at</label>
156
  <frontend_type>label</frontend_type>
157
+ <sort_order>15</sort_order>
158
  <show_in_default>1</show_in_default>
159
  <show_in_website>1</show_in_website>
160
  <show_in_store>0</show_in_store>
162
  <firstchangedate translate="label">
163
  <label>Last Export from Change-Date</label>
164
  <frontend_type>label</frontend_type>
165
+ <sort_order>16</sort_order>
166
  <show_in_default>1</show_in_default>
167
  <show_in_website>1</show_in_website>
168
  <show_in_store>0</show_in_store>
170
  <lastchangedate translate="label">
171
  <label>Last Export to Change-Date</label>
172
  <frontend_type>label</frontend_type>
173
+ <sort_order>17</sort_order>
174
  <show_in_default>1</show_in_default>
175
  <show_in_website>1</show_in_website>
176
  <show_in_store>0</show_in_store>
package.xml CHANGED
@@ -1,18 +1,18 @@
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>
1
  <?xml version="1.0"?>
2
  <package>
3
  <name>Minubo_Interface</name>
4
+ <version>1.0.24</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>Extension for calculated shipping costs, optional email in customer data for CRM export of selected customers from minubo</notes>
12
  <authors><author><name>sven rothe</name><user>minubo</user><email>sven@minubo.com</email></author></authors>
13
+ <date>2014-07-25</date>
14
+ <time>17:55:25</time>
15
+ <contents><target name="magecommunity"><dir name="Minubo"><dir name="Interface"><dir name="Block"><dir name="Adminhtml"><file name="Authhash.php" hash="c98e63efd5e4e42a6bc1c223a75176c3"/><file name="Lastchangedate.php" hash="c82ee55fad83d848f47a8594bd25c5af"/><dir name="System"><dir name="Config"><dir name="Form"><file name="Button.php" hash="c288b69aa22cc9ff5e978ff2b89646e9"/></dir></dir></dir><file name="Version.php" hash="31db32eca5dcaf3ad86c747bb3e11efc"/></dir></dir><dir name="Helper"><file name="Data.php" hash="d9cf690ff97d2014cd3e443c07ab4ea7"/></dir><dir name="Model"><dir name="Export"><file name="Abstractcsv.php" hash="94a1b9c669ff01892994faa507152f9c"/><file name="Csv.php" hash="c3788d63aaa16a83b2f280cfbd40c2f1"/><file name="Status.php" hash="cef67926aef558b87d4e3bcb02386743"/></dir><dir name="Mysql4"><file name="Categories.php" hash="7aaf0b687f5127bd07a2d7b0c8fb47ba"/><file name="Creditmemoitems.php" hash="c59bc4b0e25753bf458fee5583ca6d0a"/><file name="Creditmemos.php" hash="1f9106985961671c236853c563d6a49f"/><file name="Customeraddresses.php" hash="22abe6badaf89f6e172f5f36d7db38ed"/><file name="Customers.php" hash="4f720e307fd8b8bb2b31b57fcd1809e2"/><file name="Invoiceitems.php" hash="0273220176bcf5487b6975fbb485b1cd"/><file name="Invoices.php" hash="8f467284eadc5d1885d1df00d007fdd5"/><file name="Orderaddresses.php" hash="9c1437a6c5079560f9844bd111749543"/><file name="Orderitems.php" hash="75d14acbb7c45a369549bceb24b3c108"/><file name="Orders.php" hash="201058e7c859fcc75cb1da65e1d8719a"/><file name="Productattributes.php" hash="6a4c275d6fabcfae4a901a78ba621856"/><file name="Productcategories.php" hash="56a00cecf2cfe994fdeae9db947f653d"/><file name="Products.php" hash="4b7ebada1f3f291058a356e1765243a3"/><file name="Regions.php" hash="f1575516572fbd9a58e8c025fefa95d4"/></dir><dir name="Options"><file name="Options.php" hash="b696a731d9daa7f53c8375f19ad3838f"/><file name="Version.php" hash="fafcca0d77fbbe7fb26b869a845963bf"/></dir><dir name="Read"><file name="Collections.php" hash="3fbc08cae92c333488d43b307a1a07a0"/><file name="Common.php" hash="18b089bb03cbb226b95db428a7c31ef2"/></dir><file name="Tables.php" hash="e0f2ee1d70cc61cac2ad428b09ecf6e7"/></dir><dir name="controllers"><file name="ExportController.php" hash="579e47ecc6c4bd298fefcd7346d65c4d"/></dir><dir name="etc"><file name="adminhtml.xml" hash="375c548aacaf6f1bfdf4de3af7b29dfb"/><file name="config.xml" hash="3508d424a5d37ccae2b9d094cc3a6107"/><file name="system.xml" hash="1711ddf1324890727e091062bbb9ce58"/></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>