Sarbacane_Mailify - Version 1.0.0.6

Version Notes

This release fixes an anomaly : we were importing only 2500 customers

Download this release

Release Info

Developer Sarbacane Software
Extension Sarbacane_Mailify
Version 1.0.0.6
Comparing to
See all releases


Code changes from version 1.0.0.5 to 1.0.0.6

app/code/community/Sarbacane/Mailify/Helper/Data.php CHANGED
@@ -68,18 +68,21 @@ class Sarbacane_Mailify_Helper_Data extends Mage_Core_Helper_Abstract
68
  }
69
  }
70
 
71
- public function resetList($list_type, $store_id, $sd_id = '')
72
  {
 
 
 
73
  $resource = Mage::getSingleton('core/resource');
74
  $db_write = $resource->getConnection('core_write');
75
  $sarbacanedesktop = $resource->getTableName('sarbacanedesktop_users');
76
  $rq_sql = '
77
  DELETE FROM `' . $sarbacanedesktop . '`
78
  WHERE `sd_type` = "sd_id"
79
- AND `sd_id` = ' . $db_write->quote($sd_id);
80
  $db_write->query($rq_sql);
81
  }
82
-
83
  public function getToken()
84
  {
85
  $str = $this->getConfiguration('sd_token');
68
  }
69
  }
70
 
71
+ public function resetList($list_id = '')
72
  {
73
+ $id_shop = $this->getStoreidFromList($list_id);
74
+ $list_type = $this->getListTypeFromList($list_id);
75
+
76
  $resource = Mage::getSingleton('core/resource');
77
  $db_write = $resource->getConnection('core_write');
78
  $sarbacanedesktop = $resource->getTableName('sarbacanedesktop_users');
79
  $rq_sql = '
80
  DELETE FROM `' . $sarbacanedesktop . '`
81
  WHERE `sd_type` = "sd_id"
82
+ AND `list_id` = ' . $db_write->quote($id_shop.$list_type);
83
  $db_write->query($rq_sql);
84
  }
85
+
86
  public function getToken()
87
  {
88
  $str = $this->getConfiguration('sd_token');
app/code/community/Sarbacane/Mailify/controllers/Adminhtml/MailifyController.php CHANGED
@@ -78,9 +78,7 @@ class Sarbacane_Mailify_Adminhtml_MailifyController extends Mage_Adminhtml_Contr
78
  {
79
  if (!in_array($sd_list, $old_sd_list_array))
80
  {
81
- $id_shop = Mage::helper('mailify')->getStoreidFromList($sd_list);
82
- $list_type = Mage::helper('mailify')->getListTypeFromList($sd_list);
83
- Mage::helper('mailify')->resetList($list_type, $id_shop);
84
  }
85
  }
86
  }
78
  {
79
  if (!in_array($sd_list, $old_sd_list_array))
80
  {
81
+ Mage::helper('mailify')->resetList($sd_list);
 
 
82
  }
83
  }
84
  }
app/code/community/Sarbacane/Mailify/controllers/IndexController.php CHANGED
@@ -25,8 +25,8 @@ class Sarbacane_Mailify_IndexController extends Mage_Core_Controller_Front_Actio
25
  $sarbacanedesktop_users = $resource->getTableName ( 'sarbacanedesktop_users' );
26
  $rq_sql = 'DELETE FROM `' . $sarbacanedesktop_users . '` WHERE sd_type=\'sd_id\' AND sd_value=\'' . $sdid . '\' AND list_id=\'' . $list . '\'';
27
  $rq = $db_write->query ( $rq_sql );
28
- $rq_sql = '
29
- INSERT INTO `' . $sarbacanedesktop_users . '` (`sd_type`, `sd_value`, `list_id`, `last_call_date` ) VALUES
30
  (\'sd_id\', ' . $db_write->quote ( $sdid ) . ', \'' . $list . '\', \'' . date ( 'Y-m-d H:i:s' ) . '\')';
31
  $rq = $db_write->query ( $rq_sql );
32
  return;
@@ -65,7 +65,7 @@ class Sarbacane_Mailify_IndexController extends Mage_Core_Controller_Front_Actio
65
  if ('delete' == Mage::app ()->getRequest ()->getParam ( 'action' )) {
66
  Mage::helper ( 'mailify' )->deleteSdid ( $sd_id );
67
  } else {
68
- $this->getFormattedContentShops ( $sdid, $last_call_date );
69
  }
70
  }
71
  }
@@ -88,7 +88,7 @@ class Sarbacane_Mailify_IndexController extends Mage_Core_Controller_Front_Actio
88
  $line = 'email;lastname;firstname';
89
  if ($list_type == 'C') {
90
  if ($this->checkIfListWithCustomerData ( $list_type, $store_id )) {
91
- $line .= ';date_first_order;date_last_order;amount_min_order;amount_max_order;amount_avg_order;nb_orders;amount_all_orders';
92
  }
93
  }
94
  $line .= ';action';
@@ -129,7 +129,7 @@ class Sarbacane_Mailify_IndexController extends Mage_Core_Controller_Front_Actio
129
  $store_list = "" . $store ['store_id'] . $list ['list_type'] . ';' . $this->dQuote ( $store ['store_name'] ) . ';'; // TEST
130
  $store_list .= $this->listIsResetted ( $store ['store_id'] . $list ['list_type'], $sd_id ) . ';';
131
  $store_list .= $this->listIsUpdated ( $store ['store_id'], $list ['list_type'], $sd_id ) . ';';
132
- $store_list .= 'Magento;1.0.0.4' . "\n";
133
  echo $store_list;
134
  }
135
  }
@@ -139,10 +139,10 @@ class Sarbacane_Mailify_IndexController extends Mage_Core_Controller_Front_Actio
139
  $resource = Mage::getSingleton ( 'core/resource' );
140
  $db_read = $resource->getConnection ( 'core_read' );
141
  $sarbacanedesktop_users = $resource->getTableName ( 'sarbacanedesktop_users' );
142
- $rq_sql = '
143
- SELECT count(*) AS `nb_in_table`
144
- FROM ' . $sarbacanedesktop_users . '
145
- WHERE `sd_type` = "sd_id"
146
  AND `sd_value` = ' . $db_read->quote ( $sd_id ) . ' AND list_id="' . $list_id . '"';
147
  $nb_in_table = $db_read->fetchOne ( $rq_sql );
148
  if ($nb_in_table == 0)
@@ -172,74 +172,96 @@ class Sarbacane_Mailify_IndexController extends Mage_Core_Controller_Front_Actio
172
  return $value;
173
  }
174
  private function processNewSubscribers($list_type, $store_id, $sd_id, $type_action = 'display', $last_call_date) {
 
175
  $resource = Mage::getSingleton ( 'core/resource' );
176
  $db_read = $resource->getConnection ( 'core_read' );
177
  $db_write = $resource->getConnection ( 'core_write' );
178
  $sd_updates = $resource->getTableName ( 'sd_updates' );
179
  $newsletter_subscriber = $resource->getTableName ( 'newsletter_subscriber' );
180
  $sales_flat_order = $resource->getTableName ( 'sales_flat_order' );
 
 
 
181
  $customer_entity = $resource->getTableName ( 'customer_entity' );
182
  $customer_entity_varchar = $resource->getTableName ( 'customer_entity_varchar' );
183
  $core_store = $resource->getTableName ( 'core_store' ); // core store
184
  $attr_firstname = Mage::getModel ( 'customer/customer' )->getAttribute ( 'firstname' )->getAttributeId ();
185
  $attr_lastname = Mage::getModel ( 'customer/customer' )->getAttribute ( 'lastname' )->getAttributeId ();
186
- $rq_sql_limit = '2500';
187
- if ($type_action == 'is_updated')
188
- $rq_sql_limit = '1';
189
  if ($list_type == 'N') {
190
  if ($last_call_date != null && $last_call_date != '') {
191
- $rq_sql = 'SELECT sdu.`email` AS `email`, IFNULL(lastname.`value`, \'\') AS `lastname`, IFNULL(firstname.`value`, \'\') AS `firstname`
192
- FROM `' . $sd_updates . '` AS `sdu`
193
- LEFT JOIN ' . $newsletter_subscriber . ' ns ON ns.subscriber_email = sdu.email
194
- LEFT JOIN ' . $customer_entity_varchar . ' AS `lastname` ON lastname.`entity_id` = ns.`customer_id` AND lastname.`attribute_id` = ' . ( int ) $attr_lastname . '
195
- LEFT JOIN ' . $customer_entity_varchar . ' AS `firstname` ON firstname.`entity_id` = ns.`customer_id` AND firstname.`attribute_id` = ' . ( int ) $attr_firstname . '
196
- WHERE ns.`subscriber_status` = 1 AND sdu.update_time > "' . $last_call_date . '" AND sdu.list_type="N" AND sdu.action="S"
197
- AND ns.`store_id` = ' . ( int ) $store_id . '
198
- LIMIT 0, ' . $rq_sql_limit;
 
199
  } else {
200
- $rq_sql = '
201
- SELECT ns.`subscriber_email` AS `email`, IFNULL(lastname.`value`, \'\') AS `lastname`, IFNULL(firstname.`value`, \'\') AS `firstname`
202
- FROM `' . $newsletter_subscriber . '` AS `ns`
203
- LEFT JOIN ' . $customer_entity_varchar . ' AS `lastname` ON lastname.`entity_id` = ns.`customer_id` AND lastname.`attribute_id` = ' . ( int ) $attr_lastname . '
204
- LEFT JOIN ' . $customer_entity_varchar . ' AS `firstname` ON firstname.`entity_id` = ns.`customer_id` AND firstname.`attribute_id` = ' . ( int ) $attr_firstname . '
205
- WHERE ns.`subscriber_status` = 1
206
- AND ns.`store_id` = ' . ( int ) $store_id . '
207
- LIMIT 0, ' . $rq_sql_limit;
 
208
  }
209
  } else if ($list_type == 'C') {
210
  $add_customer_data = $this->checkIfListWithCustomerData ( $list_type, $store_id );
211
- $rq_sql = "
212
- SELECT c.email AS email ,cevln.value as lastname , cevfn.value as firstname";
213
  if ($add_customer_data) {
214
- $rq_sql .= ", MAX(sfo.base_grand_total) as amount_max_order, MIN(sfo.base_grand_total) as amount_min_order, AVG(sfo.base_grand_total) as amount_avg_order, MIN(sfo.created_at) as date_first_order, MAX(sfo.created_at) as date_last_order, COUNT(sfo.entity_id) as nb_orders, SUM(sfo.base_grand_total) as amount_all_orders";
 
 
 
 
215
  }
216
- $rq_sql .= " FROM $customer_entity c LEFT JOIN $customer_entity_varchar cevln ON cevln.entity_id = c.entity_id AND cevln.attribute_id=7
217
- LEFT JOIN $customer_entity_varchar cevfn ON cevfn.entity_id = c.entity_id AND cevfn.attribute_id = 5";
218
  if ($add_customer_data) {
219
  $rq_sql .= " LEFT JOIN $sales_flat_order sfo ON sfo.customer_id = c.entity_id ";
220
  }
221
  $rq_sql .= " WHERE c.store_id = " . $store_id;
222
  if ($last_call_date != null && $last_call_date != '') {
223
- $rq_sql .= " AND (c.created_at > '" . $last_call_date . "' OR c.updated_at > '" . $last_call_date . "' OR sfo.created_at > '" . $last_call_date . "' OR sfo.updated_at > '" . $last_call_date . "') ";
 
 
 
 
224
  }
225
- $rq_sql .= " GROUP BY c.email
226
- UNION
227
  SELECT sfo.customer_email AS email ,sfo.customer_lastname as lastname, sfo.customer_firstname as firstname";
228
  if ($add_customer_data) {
229
  $rq_sql .= ", MAX(sfo.base_grand_total) as amount_max_order, MIN(sfo.base_grand_total) as amount_min_order, AVG(sfo.base_grand_total) as amount_avg_order, MIN(sfo.created_at) as date_first_order, MAX(sfo.created_at) as date_last_order, COUNT(sfo.entity_id) as nb_orders, SUM(sfo.base_grand_total) as amount_all_orders";
230
  }
231
- $rq_sql .= "
232
- FROM $sales_flat_order sfo
233
- WHERE sfo.customer_id IS NULL AND sfo.store_id = " . $store_id;
234
  if ($last_call_date != null && $last_call_date != '') {
235
  $rq_sql .= " AND (sfo.created_at > '" . $last_call_date . "' OR sfo.updated_at > '" . $last_call_date . "') ";
236
  }
237
- $rq_sql .= " GROUP BY sfo.customer_email ";
238
-
239
- $rq_sql .= " LIMIT 0, " . $rq_sql_limit;
 
 
 
 
 
 
 
 
 
 
 
 
240
  } else {
241
  return;
242
  }
 
243
  if ($type_action == 'is_updated') {
244
  $rq = $db_read->fetchAll ( $rq_sql );
245
  return count ( $rq );
@@ -253,7 +275,7 @@ class Sarbacane_Mailify_IndexController extends Mage_Core_Controller_Front_Actio
253
  if ($add_customer_data) {
254
  $line .= ';' . $this->dQuote ( $r ['date_first_order'] ) . ';' . $this->dQuote ( $r ['date_last_order'] );
255
  $line .= ';' . ( float ) $r ['amount_min_order'] . ';' . ( float ) $r ['amount_max_order'] . ';' . ( float ) $r ['amount_avg_order'];
256
- $line .= ';' . $r ['nb_orders'] . ';' . ( float ) $r ['amount_all_orders'];
257
  $orders_data = $r ['amount_min_order'] . $r ['amount_max_order'];
258
  $orders_data .= $r ['nb_orders'] . $r ['amount_all_orders'];
259
  }
@@ -269,9 +291,6 @@ class Sarbacane_Mailify_IndexController extends Mage_Core_Controller_Front_Actio
269
 
270
  $sd_updates = $resource->getTableName ( 'sd_updates' );
271
 
272
- $rq_sql_limit = '2500';
273
- if ($type_action == 'is_updated')
274
- $rq_sql_limit = '1';
275
  switch ($list_type) {
276
  case 'N' :
277
  case 'C' :
25
  $sarbacanedesktop_users = $resource->getTableName ( 'sarbacanedesktop_users' );
26
  $rq_sql = 'DELETE FROM `' . $sarbacanedesktop_users . '` WHERE sd_type=\'sd_id\' AND sd_value=\'' . $sdid . '\' AND list_id=\'' . $list . '\'';
27
  $rq = $db_write->query ( $rq_sql );
28
+ $rq_sql = '
29
+ INSERT INTO `' . $sarbacanedesktop_users . '` (`sd_type`, `sd_value`, `list_id`, `last_call_date` ) VALUES
30
  (\'sd_id\', ' . $db_write->quote ( $sdid ) . ', \'' . $list . '\', \'' . date ( 'Y-m-d H:i:s' ) . '\')';
31
  $rq = $db_write->query ( $rq_sql );
32
  return;
65
  if ('delete' == Mage::app ()->getRequest ()->getParam ( 'action' )) {
66
  Mage::helper ( 'mailify' )->deleteSdid ( $sd_id );
67
  } else {
68
+ $this->getFormattedContentShops ( $sdid );
69
  }
70
  }
71
  }
88
  $line = 'email;lastname;firstname';
89
  if ($list_type == 'C') {
90
  if ($this->checkIfListWithCustomerData ( $list_type, $store_id )) {
91
+ $line .= ';date_first_order;date_last_order;amount_min_order;amount_max_order;amount_avg_order;nb_orders;amount_all_orders;most_profitable_category';
92
  }
93
  }
94
  $line .= ';action';
129
  $store_list = "" . $store ['store_id'] . $list ['list_type'] . ';' . $this->dQuote ( $store ['store_name'] ) . ';'; // TEST
130
  $store_list .= $this->listIsResetted ( $store ['store_id'] . $list ['list_type'], $sd_id ) . ';';
131
  $store_list .= $this->listIsUpdated ( $store ['store_id'], $list ['list_type'], $sd_id ) . ';';
132
+ $store_list .= 'Magento;1.0.0.6' . "\n";
133
  echo $store_list;
134
  }
135
  }
139
  $resource = Mage::getSingleton ( 'core/resource' );
140
  $db_read = $resource->getConnection ( 'core_read' );
141
  $sarbacanedesktop_users = $resource->getTableName ( 'sarbacanedesktop_users' );
142
+ $rq_sql = '
143
+ SELECT count(*) AS `nb_in_table`
144
+ FROM ' . $sarbacanedesktop_users . '
145
+ WHERE `sd_type` = "sd_id"
146
  AND `sd_value` = ' . $db_read->quote ( $sd_id ) . ' AND list_id="' . $list_id . '"';
147
  $nb_in_table = $db_read->fetchOne ( $rq_sql );
148
  if ($nb_in_table == 0)
172
  return $value;
173
  }
174
  private function processNewSubscribers($list_type, $store_id, $sd_id, $type_action = 'display', $last_call_date) {
175
+
176
  $resource = Mage::getSingleton ( 'core/resource' );
177
  $db_read = $resource->getConnection ( 'core_read' );
178
  $db_write = $resource->getConnection ( 'core_write' );
179
  $sd_updates = $resource->getTableName ( 'sd_updates' );
180
  $newsletter_subscriber = $resource->getTableName ( 'newsletter_subscriber' );
181
  $sales_flat_order = $resource->getTableName ( 'sales_flat_order' );
182
+ $sales_flat_order_item = $resource->getTableName ( 'sales_flat_order_item' );
183
+ $catalog_category_product = $resource->getTableName ( 'catalog_category_product' );
184
+ $catalog_category_entity_varchar = $resource->getTableName ( 'catalog_category_entity_varchar' );
185
  $customer_entity = $resource->getTableName ( 'customer_entity' );
186
  $customer_entity_varchar = $resource->getTableName ( 'customer_entity_varchar' );
187
  $core_store = $resource->getTableName ( 'core_store' ); // core store
188
  $attr_firstname = Mage::getModel ( 'customer/customer' )->getAttribute ( 'firstname' )->getAttributeId ();
189
  $attr_lastname = Mage::getModel ( 'customer/customer' )->getAttribute ( 'lastname' )->getAttributeId ();
 
 
 
190
  if ($list_type == 'N') {
191
  if ($last_call_date != null && $last_call_date != '') {
192
+ $rq_sql = 'SELECT sdu.`email` AS `email`, IFNULL(lastname.`value`, \'\') AS `lastname`, IFNULL(firstname.`value`, \'\') AS `firstname`
193
+ FROM `' . $sd_updates . '` AS `sdu`
194
+ LEFT JOIN ' . $newsletter_subscriber . ' ns ON ns.subscriber_email = sdu.email
195
+ LEFT JOIN ' . $customer_entity_varchar . ' AS `lastname` ON lastname.`entity_id` = ns.`customer_id` AND lastname.`attribute_id` = ' . ( int ) $attr_lastname . '
196
+ LEFT JOIN ' . $customer_entity_varchar . ' AS `firstname` ON firstname.`entity_id` = ns.`customer_id` AND firstname.`attribute_id` = ' . ( int ) $attr_firstname . '
197
+ WHERE ns.`subscriber_status` = 1 AND sdu.update_time > "' . $last_call_date . '" AND sdu.list_type="N" AND sdu.action="S"
198
+ AND ns.`store_id` = ' . ( int ) $store_id;
199
+ if ($type_action == 'is_updated')
200
+ $rq_sql .= ' LIMIT 0, 1 ';
201
  } else {
202
+ $rq_sql = '
203
+ SELECT ns.`subscriber_email` AS `email`, IFNULL(lastname.`value`, \'\') AS `lastname`, IFNULL(firstname.`value`, \'\') AS `firstname`
204
+ FROM `' . $newsletter_subscriber . '` AS `ns`
205
+ LEFT JOIN ' . $customer_entity_varchar . ' AS `lastname` ON lastname.`entity_id` = ns.`customer_id` AND lastname.`attribute_id` = ' . ( int ) $attr_lastname . '
206
+ LEFT JOIN ' . $customer_entity_varchar . ' AS `firstname` ON firstname.`entity_id` = ns.`customer_id` AND firstname.`attribute_id` = ' . ( int ) $attr_firstname . '
207
+ WHERE ns.`subscriber_status` = 1
208
+ AND ns.`store_id` = ' . ( int ) $store_id;
209
+ if ($type_action == 'is_updated')
210
+ $rq_sql .= ' LIMIT 0, 1 ';
211
  }
212
  } else if ($list_type == 'C') {
213
  $add_customer_data = $this->checkIfListWithCustomerData ( $list_type, $store_id );
214
+ $rq_sql = " SELECT t.email, t.lastname, t.firstname ";
 
215
  if ($add_customer_data) {
216
+ $rq_sql .= " ,t.amount_max_order, t.amount_min_order, t.amount_avg_order, t.date_first_order, t.date_last_order, t.nb_orders, t.amount_all_orders,MAX(ta.amount_for_category), ta.category ";
217
+ }
218
+ $rq_sql .= " FROM ( SELECT c.email AS email,cevln.value AS lastname, cevfn.value AS firstname ";
219
+ if ($add_customer_data) {
220
+ $rq_sql .= ",MAX(sfo.base_grand_total) AS amount_max_order, MIN(sfo.base_grand_total) AS amount_min_order, AVG(sfo.base_grand_total) AS amount_avg_order, MIN(sfo.created_at) AS date_first_order, MAX(sfo.created_at) AS date_last_order, COUNT(sfo.entity_id) AS nb_orders, SUM(sfo.base_grand_total) AS amount_all_orders";
221
  }
222
+ $rq_sql .= " FROM $customer_entity c LEFT JOIN $customer_entity_varchar cevln ON cevln.entity_id = c.entity_id AND cevln.attribute_id=7
223
+ LEFT JOIN $customer_entity_varchar cevfn ON cevfn.entity_id = c.entity_id AND cevfn.attribute_id = 5";
224
  if ($add_customer_data) {
225
  $rq_sql .= " LEFT JOIN $sales_flat_order sfo ON sfo.customer_id = c.entity_id ";
226
  }
227
  $rq_sql .= " WHERE c.store_id = " . $store_id;
228
  if ($last_call_date != null && $last_call_date != '') {
229
+ $rq_sql .= " AND (c.created_at > '" . $last_call_date . "' OR c.updated_at > '" . $last_call_date . "')";
230
+ if($add_customer_data){
231
+
232
+ $rq_sql .= " OR (sfo.created_at > '" . $last_call_date . "' OR sfo.updated_at > '" . $last_call_date . "')";
233
+ }
234
  }
235
+ $rq_sql .= " GROUP BY c.email
236
+ UNION
237
  SELECT sfo.customer_email AS email ,sfo.customer_lastname as lastname, sfo.customer_firstname as firstname";
238
  if ($add_customer_data) {
239
  $rq_sql .= ", MAX(sfo.base_grand_total) as amount_max_order, MIN(sfo.base_grand_total) as amount_min_order, AVG(sfo.base_grand_total) as amount_avg_order, MIN(sfo.created_at) as date_first_order, MAX(sfo.created_at) as date_last_order, COUNT(sfo.entity_id) as nb_orders, SUM(sfo.base_grand_total) as amount_all_orders";
240
  }
241
+ $rq_sql .= " FROM $sales_flat_order sfo ";
242
+ $rq_sql .= " WHERE sfo.customer_id IS NULL AND sfo.store_id = " . $store_id;
 
243
  if ($last_call_date != null && $last_call_date != '') {
244
  $rq_sql .= " AND (sfo.created_at > '" . $last_call_date . "' OR sfo.updated_at > '" . $last_call_date . "') ";
245
  }
246
+ $rq_sql .= " GROUP BY email ";
247
+
248
+ $rq_sql .= " ) as t ";
249
+ if($add_customer_data){
250
+ $rq_sql .= " LEFT JOIN (SELECT ccev.value AS category, SUM(sfoi.row_total) AS amount_for_category, sfo2.customer_email AS email FROM $sales_flat_order sfo2";
251
+ $rq_sql .= " LEFT JOIN $sales_flat_order_item sfoi ON sfo2.entity_id = sfoi.order_id";
252
+ $rq_sql .= " LEFT JOIN $catalog_category_product ccp ON ccp.product_id = sfoi.product_id";
253
+ $rq_sql .= " LEFT JOIN $catalog_category_entity_varchar ccev ON ccev.entity_id = ccp.category_id AND ccev.attribute_id=41 AND ccev.entity_type_id=3";
254
+ $rq_sql .= " WHERE sfo2.entity_id = (SELECT MAX(entity_id) FROM $sales_flat_order WHERE customer_email = sfo2.customer_email) ";
255
+ $rq_sql .= " GROUP BY email,category ";
256
+ $rq_sql .= " ORDER BY amount_for_category DESC) AS ta ON ta.email = t.email ";
257
+ }
258
+ $rq_sql .= " GROUP BY t.email;";
259
+ if ($type_action == 'is_updated')
260
+ $rq_sql .= ' LIMIT 0, 1 ';
261
  } else {
262
  return;
263
  }
264
+
265
  if ($type_action == 'is_updated') {
266
  $rq = $db_read->fetchAll ( $rq_sql );
267
  return count ( $rq );
275
  if ($add_customer_data) {
276
  $line .= ';' . $this->dQuote ( $r ['date_first_order'] ) . ';' . $this->dQuote ( $r ['date_last_order'] );
277
  $line .= ';' . ( float ) $r ['amount_min_order'] . ';' . ( float ) $r ['amount_max_order'] . ';' . ( float ) $r ['amount_avg_order'];
278
+ $line .= ';' . $r ['nb_orders'] . ';' . ( float ) $r ['amount_all_orders'] . ';'. $r['category'];
279
  $orders_data = $r ['amount_min_order'] . $r ['amount_max_order'];
280
  $orders_data .= $r ['nb_orders'] . $r ['amount_all_orders'];
281
  }
291
 
292
  $sd_updates = $resource->getTableName ( 'sd_updates' );
293
 
 
 
 
294
  switch ($list_type) {
295
  case 'N' :
296
  case 'C' :
app/code/community/Sarbacane/Mailify/etc/config.xml CHANGED
@@ -1,148 +1,148 @@
1
- <?xml version="1.0"?>
2
- <!--
3
- /**
4
- * Magento
5
- *
6
- * NOTICE OF LICENSE
7
- *
8
- * This source file is subject to the Academic Free License (AFL 3.0)
9
- * that is bundled with this package in the file LICENSE.txt.
10
- * It is also available through the world-wide-web at this URL:
11
- * http://opensource.org/licenses/afl-3.0.php
12
- * If you did not receive a copy of the license and are unable to
13
- * obtain it through the world-wide-web, please send an email
14
- * to license@magentocommerce.com so we can send you a copy immediately.
15
- *
16
- * @category Sarbacane
17
- * @package Sarbacane_Mailify
18
- * @author Sarbacane Software <contact@sarbacane.com>
19
- * @copyright 2015 Sarbacane Software
20
- * @license http://opensource.org/licenses/afl-3.0.php Academic Free License (AFL 3.0)
21
- */
22
- -->
23
- <config>
24
- <modules>
25
- <Sarbacane_Mailify>
26
- <version>1.0.0.4</version>
27
- </Sarbacane_Mailify>
28
- </modules>
29
- <frontend>
30
- <routers>
31
- <sarbacanedesktop>
32
- <use>standard</use>
33
- <args>
34
- <module>Sarbacane_Mailify</module>
35
- <frontName>sarbacanedesktop</frontName>
36
- </args>
37
- </sarbacanedesktop>
38
- </routers>
39
- <!--
40
- <layout>
41
- <updates>
42
- <sarbacanedesktop>
43
- <file>sarbacanedesktop.xml</file>
44
- </sarbacanedesktop>
45
- </updates>
46
- </layout>
47
- -->
48
- </frontend>
49
- <admin>
50
- <routers>
51
- <adminhtml>
52
- <args>
53
- <modules>
54
- <mailify before="Mage_Adminhtml">Sarbacane_Mailify_Adminhtml</mailify>
55
- </modules>
56
- </args>
57
- </adminhtml>
58
- </routers>
59
- <!--
60
- <routers>
61
- <sarbacanedesktop>
62
- <use>admin</use>
63
- <args>
64
- <module>Sarbacane_Sarbacanedesktop</module>
65
- <frontName>sarbacanedesktop</frontName>
66
- </args>
67
- </sarbacanedesktop>
68
- </routers>
69
- -->
70
- </admin>
71
- <adminhtml>
72
- <menu>
73
- <newsletter>
74
- <children>
75
- <items module="mailify" translate="title">
76
- <title>Mailify</title>
77
- <sort_order>120</sort_order>
78
- <action>adminhtml/mailify</action>
79
- </items>
80
- </children>
81
- </newsletter>
82
- </menu>
83
- <acl>
84
- <resources>
85
- <admin>
86
- <children>
87
- <newsletter>
88
- <children>
89
- <mailify translate="title">
90
- <title>Mailify</title>
91
- <sort_order>120</sort_order>
92
- </mailify>
93
- </children>
94
- </newsletter>
95
- </children>
96
- </admin>
97
- </resources>
98
- </acl>
99
- <layout>
100
- <updates>
101
- <mailify>
102
- <file>mailify.xml</file>
103
- </mailify>
104
- </updates>
105
- </layout>
106
- <translate>
107
- <modules>
108
- <Sarbacane_Mailify>
109
- <files>
110
- <default>Sarbacane_Mailify.csv</default>
111
- </files>
112
- </Sarbacane_Mailify>
113
- </modules>
114
- </translate>
115
- </adminhtml>
116
- <global>
117
- <helpers>
118
- <mailify>
119
- <class>Sarbacane_Mailify_Helper</class>
120
- </mailify>
121
- </helpers>
122
- <blocks>
123
- <mailify>
124
- <class>Sarbacane_Mailify_Block</class>
125
- </mailify>
126
- </blocks>
127
- <resources>
128
- <mailify_setup>
129
- <setup>
130
- <module>Sarbacane_Mailify</module>
131
- </setup>
132
- <connection>
133
- <use>core_setup</use>
134
- </connection>
135
- </mailify_setup>
136
- <mailify_write>
137
- <connection>
138
- <use>core_write</use>
139
- </connection>
140
- </mailify_write>
141
- <mailify_read>
142
- <connection>
143
- <use>core_read</use>
144
- </connection>
145
- </mailify_read>
146
- </resources>
147
- </global>
148
  </config>
1
+ <?xml version="1.0"?>
2
+ <!--
3
+ /**
4
+ * Magento
5
+ *
6
+ * NOTICE OF LICENSE
7
+ *
8
+ * This source file is subject to the Academic Free License (AFL 3.0)
9
+ * that is bundled with this package in the file LICENSE.txt.
10
+ * It is also available through the world-wide-web at this URL:
11
+ * http://opensource.org/licenses/afl-3.0.php
12
+ * If you did not receive a copy of the license and are unable to
13
+ * obtain it through the world-wide-web, please send an email
14
+ * to license@magentocommerce.com so we can send you a copy immediately.
15
+ *
16
+ * @category Sarbacane
17
+ * @package Sarbacane_Mailify
18
+ * @author Sarbacane Software <contact@sarbacane.com>
19
+ * @copyright 2015 Sarbacane Software
20
+ * @license http://opensource.org/licenses/afl-3.0.php Academic Free License (AFL 3.0)
21
+ */
22
+ -->
23
+ <config>
24
+ <modules>
25
+ <Sarbacane_Mailify>
26
+ <version>1.0.0.6</version>
27
+ </Sarbacane_Mailify>
28
+ </modules>
29
+ <frontend>
30
+ <routers>
31
+ <sarbacanedesktop>
32
+ <use>standard</use>
33
+ <args>
34
+ <module>Sarbacane_Mailify</module>
35
+ <frontName>sarbacanedesktop</frontName>
36
+ </args>
37
+ </sarbacanedesktop>
38
+ </routers>
39
+ <!--
40
+ <layout>
41
+ <updates>
42
+ <sarbacanedesktop>
43
+ <file>sarbacanedesktop.xml</file>
44
+ </sarbacanedesktop>
45
+ </updates>
46
+ </layout>
47
+ -->
48
+ </frontend>
49
+ <admin>
50
+ <routers>
51
+ <adminhtml>
52
+ <args>
53
+ <modules>
54
+ <mailify before="Mage_Adminhtml">Sarbacane_Mailify_Adminhtml</mailify>
55
+ </modules>
56
+ </args>
57
+ </adminhtml>
58
+ </routers>
59
+ <!--
60
+ <routers>
61
+ <sarbacanedesktop>
62
+ <use>admin</use>
63
+ <args>
64
+ <module>Sarbacane_Sarbacanedesktop</module>
65
+ <frontName>sarbacanedesktop</frontName>
66
+ </args>
67
+ </sarbacanedesktop>
68
+ </routers>
69
+ -->
70
+ </admin>
71
+ <adminhtml>
72
+ <menu>
73
+ <newsletter>
74
+ <children>
75
+ <items module="mailify" translate="title">
76
+ <title>Mailify</title>
77
+ <sort_order>120</sort_order>
78
+ <action>adminhtml/mailify</action>
79
+ </items>
80
+ </children>
81
+ </newsletter>
82
+ </menu>
83
+ <acl>
84
+ <resources>
85
+ <admin>
86
+ <children>
87
+ <newsletter>
88
+ <children>
89
+ <mailify translate="title">
90
+ <title>Mailify</title>
91
+ <sort_order>120</sort_order>
92
+ </mailify>
93
+ </children>
94
+ </newsletter>
95
+ </children>
96
+ </admin>
97
+ </resources>
98
+ </acl>
99
+ <layout>
100
+ <updates>
101
+ <mailify>
102
+ <file>mailify.xml</file>
103
+ </mailify>
104
+ </updates>
105
+ </layout>
106
+ <translate>
107
+ <modules>
108
+ <Sarbacane_Mailify>
109
+ <files>
110
+ <default>Sarbacane_Mailify.csv</default>
111
+ </files>
112
+ </Sarbacane_Mailify>
113
+ </modules>
114
+ </translate>
115
+ </adminhtml>
116
+ <global>
117
+ <helpers>
118
+ <mailify>
119
+ <class>Sarbacane_Mailify_Helper</class>
120
+ </mailify>
121
+ </helpers>
122
+ <blocks>
123
+ <mailify>
124
+ <class>Sarbacane_Mailify_Block</class>
125
+ </mailify>
126
+ </blocks>
127
+ <resources>
128
+ <mailify_setup>
129
+ <setup>
130
+ <module>Sarbacane_Mailify</module>
131
+ </setup>
132
+ <connection>
133
+ <use>core_setup</use>
134
+ </connection>
135
+ </mailify_setup>
136
+ <mailify_write>
137
+ <connection>
138
+ <use>core_write</use>
139
+ </connection>
140
+ </mailify_write>
141
+ <mailify_read>
142
+ <connection>
143
+ <use>core_read</use>
144
+ </connection>
145
+ </mailify_read>
146
+ </resources>
147
+ </global>
148
  </config>
app/locale/en_US/Sarbacane_Mailify.csv CHANGED
@@ -1,58 +1,58 @@
1
- "mailify","mailify"
2
- "It's easy to manage your newsletter and email campaigns","It's easy to manage your newsletter and email campaigns"
3
- "https://www.youtube.com/embed/eLMy2tSSYgE","https://www.youtube.com/embed/gUGRbfXOJIk"
4
- "This Magento module enables you to synchronize clients and accounts that have subscribed to your newsletter from your shop online using Mailify's email marketing software.","This Magento module enables you to synchronize clients and accounts that have subscribed to your newsletter from your shop online using Mailify's email marketing software."
5
- "Begin the set-up","Begin the set-up"
6
- "Synchronization of your shop data","Synchronization of your shop data"
7
- "Responsive visual editor","Responsive visual editor"
8
- "Detailed statistics","Detailed statistics"
9
- "Optimal deliverability","Optimal deliverability"
10
- "Synchronize and manage all the email lists from your Magento store","Synchronize and manage all the email lists from your Magento store"
11
- "NEW! Create awesome, responsive newsletters thanks to the EmailBuilder","NEW! Create awesome, responsive newsletters thanks to the EmailBuilder"
12
- "Geolocation, openings, opening time, clicks, opt-outs...","Geolocation, openings, opening time, clicks, opt-outs..."
13
- "Optimal deliverability thanks to our renowned professional routing platform","Optimal deliverability thanks to our renowned professional routing platform"
14
- "Create your account for free and start sending emails","Create your account for free and start sending emails"
15
- "No strings attached","No strings attached"
16
- "Why choose Sarbacane?","Why choose Mailify?"
17
- "Create your account for free and start sending emails,"
18
- "Trusted by over 20,000 users worldwide.","Trusted by over 20,000 users worldwide."
19
- "Awarded Best Emailing Solution by Bsoco Awards (an index that compares emailing solutions)","Awarded Best Emailing Solution by Bsoco Awards (an index that compares emailing solutions)"
20
- "All you need to succeed: design, customize, send, and follow-up on your campaigns","All you need to succeed: design, customize, send, and follow-up on your campaigns"
21
- "A tech heldpdesk and a variety of resources to help: videos, tutorials, manuals, tips...","A tech heldpdesk and a variety of resources to help: videos, tutorials, manuals, tips..."
22
- "Need help?","Need help?"
23
- "Email:","Email:"
24
- "support@mailify.com","help@mailify.com"
25
- "Tel:","Tel:"
26
- "+33(0) 328 328 040","(646)-844-0983"
27
- "Website:","Website : "
28
- "http://www.mailify.com/?lng=EN&utm_source=module-magento&utm_medium=plugin&utm_content=lien-sarbacane&utm_campaign=magento","http://www.mailify.com/?lng=EN&utm_source=module-magento&utm_medium=plugin&utm_content=lien-sarbacane&utm_campaign=magento"
29
- "http://www.mailify.com","http://www.mailify.com"
30
- "How to set up the module?","How to set up the module?"
31
- "Do you already have a Mailify account?","Do you already have a Mailify account?"
32
- "Yes","Yes"
33
- "No","No"
34
- "Next","Next"
35
- "Select your shop and pick your settings","Select your shop and pick your settings"
36
- "Create a list in Mailify with newsletter opt-ins","Create a list in Mailify with newsletter opt-ins"
37
- "Create a list in Mailify with your clients who have an account or who have placed an order online","Create a list in Mailify with your clients who have an account or who have placed an order online"
38
- "Add order data (date, amount, etc...)","Add order data (date, amount, etc...)"
39
- "As you enable data from orders, you can also gather extra info in your contact list, and target your recipients in Mailify.","As you enable data from orders, you can also gather extra info in your contact list, and target your recipients in Mailify."
40
- "Below are pieces of information that will be added to your contact list:","Below are pieces of information that will be added to your contact list:"
41
- "- Date of first order","- Date of first order"
42
- "- Date of latest order","- Date of latest order"
43
- "- Total number of orders","- Total number of orders"
44
- "- Total amount of orders","- Total amount of orders"
45
- "- Amount of the cheapest order","- Amount of the cheapest order"
46
- "- Amount of the most expensive order","- Amount of the most expensive order"
47
- "- Average amount of the orders placed","- Average amount of the orders placed"
48
- "Previous","Previous"
49
- "Download and install Mailify","Download and install Mailify"
50
- "https://static.mailify.com/ws/soft-redirect.asp?key=as8Ku4rGIs&com=MagentoInfo&lng=EN","https://static.mailify.com/ws/soft-redirect.asp?key=as8Ku4rGIs&com=MagentoInfo&lng=EN"
51
- "Create your free account","Create your free account"
52
- "Enable the Magento extension in our extensions menu, and then fill in the following fields:","Enable the Magento extension in our extensions menu, and then fill in the following fields:"
53
- "Url","Url"
54
- "Key","Key"
55
- "Generate a new key","Generate a new key"
56
- "Read more","Read more"
57
- "https://static.mailify.com/ws/soft-redirect.asp?key=pS8AD5f3a9&com=MagentoFAQ&lng=EN","https://static.mailify.com/ws/soft-redirect.asp?key=pS8AD5f3a9&com=MagentoFAQ&lng=EN"
58
- "in the help section online","in the help section online"
1
+ "mailify","mailify"
2
+ "It's easy to manage your newsletter and email campaigns","It's easy to manage your newsletter and email campaigns"
3
+ "https://www.youtube.com/embed/eLMy2tSSYgE","https://www.youtube.com/embed/gUGRbfXOJIk"
4
+ "This Magento module enables you to synchronize clients and accounts that have subscribed to your newsletter from your shop online using Mailify's email marketing software.","This Magento module enables you to synchronize clients and accounts that have subscribed to your newsletter from your shop online using Mailify's email marketing software."
5
+ "Begin the set-up","Begin the set-up"
6
+ "Synchronization of your shop data","Synchronization of your shop data"
7
+ "Responsive visual editor","Responsive visual editor"
8
+ "Detailed statistics","Detailed statistics"
9
+ "Optimal deliverability","Optimal deliverability"
10
+ "Synchronize and manage all the email lists from your Magento store","Synchronize and manage all the email lists from your Magento store"
11
+ "NEW! Create awesome, responsive newsletters thanks to the EmailBuilder","NEW! Create awesome, responsive newsletters thanks to the EmailBuilder"
12
+ "Geolocation, openings, opening time, clicks, opt-outs...","Geolocation, openings, opening time, clicks, opt-outs..."
13
+ "Optimal deliverability thanks to our renowned professional routing platform","Optimal deliverability thanks to our renowned professional routing platform"
14
+ "Create your account for free and start sending emails","Create your account for free and start sending emails"
15
+ "No strings attached","No strings attached"
16
+ "Why choose Sarbacane?","Why choose Mailify?"
17
+ "Create your account for free and start sending emails,"
18
+ "Trusted by over 20,000 users worldwide.","Trusted by over 20,000 users worldwide."
19
+ "Awarded Best Emailing Solution by Bsoco Awards (an index that compares emailing solutions)","Awarded Best Emailing Solution by Bsoco Awards (an index that compares emailing solutions)"
20
+ "All you need to succeed: design, customize, send, and follow-up on your campaigns","All you need to succeed: design, customize, send, and follow-up on your campaigns"
21
+ "A tech heldpdesk and a variety of resources to help: videos, tutorials, manuals, tips...","A tech heldpdesk and a variety of resources to help: videos, tutorials, manuals, tips..."
22
+ "Need help?","Need help?"
23
+ "Email:","Email:"
24
+ "support@mailify.com","help@mailify.com"
25
+ "Tel:","Tel:"
26
+ "+33(0) 328 328 040","(646)-844-0983"
27
+ "Website:","Website : "
28
+ "http://www.mailify.com/?lng=EN&utm_source=module-magento&utm_medium=plugin&utm_content=lien-sarbacane&utm_campaign=magento","http://www.mailify.com/?lng=EN&utm_source=module-magento&utm_medium=plugin&utm_content=lien-sarbacane&utm_campaign=magento"
29
+ "http://www.mailify.com","http://www.mailify.com"
30
+ "How to set up the module?","How to set up the module?"
31
+ "Do you already have a Mailify account?","Do you already have a Mailify account?"
32
+ "Yes","Yes"
33
+ "No","No"
34
+ "Next","Next"
35
+ "Select your shop and pick your settings","Select your shop and pick your settings"
36
+ "Create a list in Mailify with newsletter opt-ins","Create a list in Mailify with newsletter opt-ins"
37
+ "Create a list in Mailify with your clients who have an account or who have placed an order online","Create a list in Mailify with your clients who have an account or who have placed an order online"
38
+ "Add order data (date, amount, etc...)","Add order data (date, amount, etc...)"
39
+ "As you enable data from orders, you can also gather extra info in your contact list, and target your recipients in Mailify.","As you enable data from orders, you can also gather extra info in your contact list, and target your recipients in Mailify."
40
+ "Below are pieces of information that will be added to your contact list:","Below are pieces of information that will be added to your contact list:"
41
+ "- Date of first order","- Date of first order"
42
+ "- Date of latest order","- Date of latest order"
43
+ "- Total number of orders","- Total number of orders"
44
+ "- Total amount of orders","- Total amount of orders"
45
+ "- Amount of the cheapest order","- Amount of the cheapest order"
46
+ "- Amount of the most expensive order","- Amount of the most expensive order"
47
+ "- Average amount of the orders placed","- Average amount of the orders placed"
48
+ "Previous","Previous"
49
+ "Download and install Mailify","Download and install Mailify"
50
+ "https://static.mailify.com/ws/soft-redirect.asp?key=as8Ku4rGIs&com=MagentoInfo&lng=EN","https://static.mailify.com/ws/soft-redirect.asp?key=as8Ku4rGIs&com=MagentoInfo&lng=EN"
51
+ "Create your free account","Create your free account"
52
+ "Enable the Magento extension in our extensions menu, and then fill in the following fields:","Enable the Magento extension in our extensions menu, and then fill in the following fields:"
53
+ "Url","Url"
54
+ "Key","Key"
55
+ "Generate a new key","Generate a new key"
56
+ "Read more","Read more"
57
+ "https://static.mailify.com/ws/soft-redirect.asp?key=pS8AD5f3a9&com=MagentoFAQ&lng=EN","https://static.mailify.com/ws/soft-redirect.asp?key=pS8AD5f3a9&com=MagentoFAQ&lng=EN"
58
+ "in the help section online","in the help section online"
app/locale/es_ES/Sarbacane_Mailify.csv CHANGED
@@ -1,58 +1,58 @@
1
- "mailify","mailify"
2
- "It's easy to manage your newsletter and email campaigns","Gestiona tus newsletters y emailing con facilidad"
3
- "https://www.youtube.com/embed/eLMy2tSSYgE","https://www.youtube.com/embed/ADeyEs4FdGY"
4
- "This Magento module enables you to synchronize clients and accounts that have subscribed to your newsletter from your shop online using Mailify's email marketing software.","Este módulo Magento permite sincronizar los clientes, cuentas y altas en la newsletter de tu tienda online con la aplicación de mailing Mailify, y disfrutar de innumerables características..."
5
- "Begin the set-up","Iniciar configuración"
6
- "Synchronization of your shop data","Datos de la tienda sincronizados"
7
- "Responsive visual editor","Editor gráfico responsive"
8
- "Detailed statistics","Estadísticas detalladas"
9
- "Optimal deliverability","Entregabilidad óptima"
10
- "Synchronize and manage all the email lists from your Magento store","Sincronizar y administrar todas las listas de emails de tu tienda Magento"
11
- "NEW! Create awesome, responsive newsletters thanks to the EmailBuilder","¡NUEVO! Crea plantillas de newsletter impresionantes con el EmailBuilder"
12
- "Geolocation, openings, opening time, clicks, opt-outs...","Geolocalización, aperturas, tiempos de lectura, clics, bajas,..."
13
- "Optimal deliverability thanks to our renowned professional routing platform","Entregabilidad optimizada gracias a nuestra reconocida plataforma de enrutamiento profesional"
14
- "Create your account for free and start sending emails","Creación de cuenta y primeros envíos gratuitos"
15
- "No strings attached","Oferta sin compromisos"
16
- "Why choose Mailify?","¿Por qué elegir Mailify?"
17
- "Create your account for free and start sending emails,"
18
- "Trusted by over 20,000 users worldwide.","Más de 20.000 usuarios en España y Francia están encantados por Mailify"
19
- "Awarded Best Emailing Solution by Bsoco Awards (an index that compares emailing solutions)","Elegidos como Mejor Solución de Emailing por los Premios Bsoco"
20
- "All you need to succeed: design, customize, send, and follow-up on your campaigns","Todo lo que necesitas para tener éxito: diseño, personalización, envío y seguimiento de tus campañas"
21
- "A tech heldpdesk and a variety of resources to help: videos, tutorials, manuals, tips...","Soporte técnico y númerosos recursos para asistirte: videos, tutoriales, guías, consejos..."
22
- "Need help?","¿Necesitas ayuda?"
23
- "Email:","Email:"
24
- "support@mailify.com","ayuda@mailify.com"
25
- "Tel:","Tel:"
26
- "+33(0) 328 328 040","+34 93 4763638"
27
- "Website:","Web : "
28
- "http://www.mailify.com/?utm_source=module-magento&utm_medium=plugin&utm_content=lien-sarbacane&utm_campaign=magento","http://es.mailify.com/?lng=ES&utm_source=module-magento&utm_medium=plugin&utm_content=lien-sarbacane&utm_campaign=magento"
29
- "http://www.mailify.com","http://es.mailify.com"
30
- "How to set up the module?","¿Cómo configurar el módulo?"
31
- "Do you already have a Mailify account?","¿Ya eres usuario Mailify?"
32
- "Yes","Sí"
33
- "No","No"
34
- "Next","Siguiente"
35
- "Select your shop and pick your settings","Selecciona tu tienda y la configuración deseada"
36
- "Create a list in Mailify with newsletter opt-ins","Crea una lista de suscriptores en Mailify"
37
- "Create a list in Mailify with your clients who have an account or who have placed an order online","Crea una lista con tus clientes en Mailify"
38
- "Add order data (date, amount, etc...)","Añade información de pedidos (fecha, importe, etc.) "
39
- "As you enable data from orders, you can also gather extra info in your contact list, and target your recipients in Mailify.","Al activar los datos de pedidos, puede recuperar un cierto número de información adicional de su lista de contactos, y realizar los filtros directamente en Mailify."
40
- "Below are pieces of information that will be added to your contact list:","Aquí está la información que se añadirá en su lista de contactos:"
41
- "- Date of first order","- Fecha del primer pedido"
42
- "- Date of latest order","- Fecha del último pedido"
43
- "- Total number of orders","- Número total de pedidos"
44
- "- Total amount of orders","- Importe total de pedidos"
45
- "- Amount of the cheapest order","- Importe de pedido más bajo"
46
- "- Amount of the most expensive order","- Importe de pedido más alto"
47
- "- Average amount of the orders placed","- Importe medio de pedidos"
48
- "Previous","Anterior"
49
- "Download and install Mailify","Descarga e instala Mailify"
50
- "https://static.mailify.com/ws/soft-redirect.asp?key=as8Ku4rGIs&com=MagentoInfo&lng=EN","https://static.mailify.com/ws/soft-redirect.asp?key=as8Ku4rGIs&com=MagentoInfo&lng=ES"
51
- "Create your free account","Crea tu cuenta gratis"
52
- "Enable the Magento extension in our extensions menu, and then fill in the following fields:","Activa la extensión Magento desde el menú ''Extensiones'' en Mailify e introduce los siguientes datos:"
53
- "Url","Url"
54
- "Key","Clave"
55
- "Generate a new key","Generar una nueva clave"
56
- "Read more","Leer más en la"
57
- "https://static.mailify.com/ws/soft-redirect.asp?key=pS8AD5f3a9&com=MagentoFAQ&lng=EN","https://static.mailify.com/ws/soft-redirect.asp?key=pS8AD5f3a9&com=MagentoFAQ&lng=ES"
58
- "in the help section online","ayuda en línea"
1
+ "mailify","mailify"
2
+ "It's easy to manage your newsletter and email campaigns","Gestiona tus newsletters y emailing con facilidad"
3
+ "https://www.youtube.com/embed/eLMy2tSSYgE","https://www.youtube.com/embed/ADeyEs4FdGY"
4
+ "This Magento module enables you to synchronize clients and accounts that have subscribed to your newsletter from your shop online using Mailify's email marketing software.","Este módulo Magento permite sincronizar los clientes, cuentas y altas en la newsletter de tu tienda online con la aplicación de mailing Mailify, y disfrutar de innumerables características..."
5
+ "Begin the set-up","Iniciar configuración"
6
+ "Synchronization of your shop data","Datos de la tienda sincronizados"
7
+ "Responsive visual editor","Editor gráfico responsive"
8
+ "Detailed statistics","Estadísticas detalladas"
9
+ "Optimal deliverability","Entregabilidad óptima"
10
+ "Synchronize and manage all the email lists from your Magento store","Sincronizar y administrar todas las listas de emails de tu tienda Magento"
11
+ "NEW! Create awesome, responsive newsletters thanks to the EmailBuilder","¡NUEVO! Crea plantillas de newsletter impresionantes con el EmailBuilder"
12
+ "Geolocation, openings, opening time, clicks, opt-outs...","Geolocalización, aperturas, tiempos de lectura, clics, bajas,..."
13
+ "Optimal deliverability thanks to our renowned professional routing platform","Entregabilidad optimizada gracias a nuestra reconocida plataforma de enrutamiento profesional"
14
+ "Create your account for free and start sending emails","Creación de cuenta y primeros envíos gratuitos"
15
+ "No strings attached","Oferta sin compromisos"
16
+ "Why choose Mailify?","¿Por qué elegir Mailify?"
17
+ "Create your account for free and start sending emails,"
18
+ "Trusted by over 20,000 users worldwide.","Más de 20.000 usuarios en España y Francia están encantados por Mailify"
19
+ "Awarded Best Emailing Solution by Bsoco Awards (an index that compares emailing solutions)","Elegidos como Mejor Solución de Emailing por los Premios Bsoco"
20
+ "All you need to succeed: design, customize, send, and follow-up on your campaigns","Todo lo que necesitas para tener éxito: diseño, personalización, envío y seguimiento de tus campañas"
21
+ "A tech heldpdesk and a variety of resources to help: videos, tutorials, manuals, tips...","Soporte técnico y númerosos recursos para asistirte: videos, tutoriales, guías, consejos..."
22
+ "Need help?","¿Necesitas ayuda?"
23
+ "Email:","Email:"
24
+ "support@mailify.com","ayuda@mailify.com"
25
+ "Tel:","Tel:"
26
+ "+33(0) 328 328 040","+34 93 4763638"
27
+ "Website:","Web : "
28
+ "http://www.mailify.com/?utm_source=module-magento&utm_medium=plugin&utm_content=lien-sarbacane&utm_campaign=magento","http://es.mailify.com/?lng=ES&utm_source=module-magento&utm_medium=plugin&utm_content=lien-sarbacane&utm_campaign=magento"
29
+ "http://www.mailify.com","http://es.mailify.com"
30
+ "How to set up the module?","¿Cómo configurar el módulo?"
31
+ "Do you already have a Mailify account?","¿Ya eres usuario Mailify?"
32
+ "Yes","Sí"
33
+ "No","No"
34
+ "Next","Siguiente"
35
+ "Select your shop and pick your settings","Selecciona tu tienda y la configuración deseada"
36
+ "Create a list in Mailify with newsletter opt-ins","Crea una lista de suscriptores en Mailify"
37
+ "Create a list in Mailify with your clients who have an account or who have placed an order online","Crea una lista con tus clientes en Mailify"
38
+ "Add order data (date, amount, etc...)","Añade información de pedidos (fecha, importe, etc.) "
39
+ "As you enable data from orders, you can also gather extra info in your contact list, and target your recipients in Mailify.","Al activar los datos de pedidos, puede recuperar un cierto número de información adicional de su lista de contactos, y realizar los filtros directamente en Mailify."
40
+ "Below are pieces of information that will be added to your contact list:","Aquí está la información que se añadirá en su lista de contactos:"
41
+ "- Date of first order","- Fecha del primer pedido"
42
+ "- Date of latest order","- Fecha del último pedido"
43
+ "- Total number of orders","- Número total de pedidos"
44
+ "- Total amount of orders","- Importe total de pedidos"
45
+ "- Amount of the cheapest order","- Importe de pedido más bajo"
46
+ "- Amount of the most expensive order","- Importe de pedido más alto"
47
+ "- Average amount of the orders placed","- Importe medio de pedidos"
48
+ "Previous","Anterior"
49
+ "Download and install Mailify","Descarga e instala Mailify"
50
+ "https://static.mailify.com/ws/soft-redirect.asp?key=as8Ku4rGIs&com=MagentoInfo&lng=EN","https://static.mailify.com/ws/soft-redirect.asp?key=as8Ku4rGIs&com=MagentoInfo&lng=ES"
51
+ "Create your free account","Crea tu cuenta gratis"
52
+ "Enable the Magento extension in our extensions menu, and then fill in the following fields:","Activa la extensión Magento desde el menú ''Extensiones'' en Mailify e introduce los siguientes datos:"
53
+ "Url","Url"
54
+ "Key","Clave"
55
+ "Generate a new key","Generar una nueva clave"
56
+ "Read more","Leer más en la"
57
+ "https://static.mailify.com/ws/soft-redirect.asp?key=pS8AD5f3a9&com=MagentoFAQ&lng=EN","https://static.mailify.com/ws/soft-redirect.asp?key=pS8AD5f3a9&com=MagentoFAQ&lng=ES"
58
+ "in the help section online","ayuda en línea"
package.xml CHANGED
@@ -1,7 +1,7 @@
1
  <?xml version="1.0"?>
2
  <package>
3
  <name>Sarbacane_Mailify</name>
4
- <version>1.0.0.5</version>
5
  <stability>stable</stability>
6
  <license uri="http://www.opensource.org/licenses/academic.php">AFL</license>
7
  <channel>community</channel>
@@ -61,11 +61,11 @@
61
  &lt;li&gt;Estad&#xED;sticas detalladas, geolocalizaci&#xF3;n, detecci&#xF3;n de aperturas, tiempo de lectura, clics, tipo de mensajer&#xED;a, bajas, direcciones err&#xF3;neas...&lt;/li&gt;&#xD;
62
  &lt;/ul&gt;&#xD;
63
  &lt;a href="https://es.mailify.com/?utm_source=magento&amp;amp;utm_medium=plugin&amp;amp;utm_campaign=marketplace"&gt;es.mailify.com&lt;/a&gt;</description>
64
- <notes>This release corrects some links and label anomalies.</notes>
65
  <authors><author><name>Sarbacane Software</name><user>egavard</user><email>connectors@sarbacane.com</email></author></authors>
66
- <date>2015-07-06</date>
67
- <time>07:15:00</time>
68
- <contents><target name="magecommunity"><dir name="Sarbacane"><dir name="Mailify"><dir name="Block"><dir name="Adminhtml"><file name="Mailify.php" hash="f0ad71d64dc619421a67a3af24b23278"/></dir></dir><dir name="Helper"><file name="Data.php" hash="00fbadd2b8c1d7d4c88f20edb09721a9"/></dir><dir name="controllers"><dir name="Adminhtml"><file name="MailifyController.php" hash="3e8e56c95f4453af3fa9853f946bce9e"/></dir><file name="IndexController.php" hash="a84d67560076b3e0a555503fd0bc7889"/></dir><dir name="etc"><file name="config.xml" hash="0c8052e8c0c88f71148193f672cf382a"/></dir><dir name="sql"><dir name="mailify_setup"><file name="mysql4-install-1.0.0.0.php" hash="82834af7ce95c1bd9d3063ffdf3a11f5"/><file name="mysql4-upgrade-1.0.0.0-1.0.0.1.php" hash="35660ae27bb6ef74c885ad86284f9071"/><file name="mysql4-upgrade-1.0.0.1-1.0.0.2.php" hash="35660ae27bb6ef74c885ad86284f9071"/><file name="mysql4-upgrade-1.0.0.2-1.0.0.3.php" hash="35660ae27bb6ef74c885ad86284f9071"/><file name="mysql4-upgrade-1.0.0.3-1.0.0.4.php" hash="2bd5ea1d79115c1a6ba919a708b1fb4b"/></dir></dir></dir></dir></target><target name="mageskin"><dir name="adminhtml"><dir name="default"><dir name="default"><dir name="css"><dir name="Sarbacane_Mailify"><file name="mailify.css" hash="6fcee54bdab10db72a361ec5a139cc7c"/></dir></dir><dir name="images"><file name="sd.png" hash="2038d3c503e8f59d14177a131bef7537"/></dir><dir name="js"><dir name="Sarbacane_Mailify"><file name="mailify.js" hash="d38d9ec858dfdce14e0156acc87c1c50"/></dir></dir></dir></dir></dir></target><target name="magedesign"><dir name="adminhtml"><dir name="default"><dir name="default"><dir name="layout"><file name="mailify.xml" hash="2ce0ac9b7cd4ec8adf80494c86aaae10"/></dir><dir name="template"><dir name="mailify"><file name="mailify.phtml" hash="2207e779b2aabba7bf662405250e6c90"/></dir></dir></dir></dir></dir></target><target name="mage"><dir name="app"><dir name="etc"><dir name="modules"><file name="Sarbacane_Mailify.xml" hash="daf2fd2fbde04d804b1fdd7671273c82"/></dir></dir></dir></target><target name="magelocale"><dir name="es_ES"><file name="Sarbacane_Mailify.csv" hash="42634aab6c690e91c034669088901a5d"/></dir><dir name="en_US"><file name="Sarbacane_Mailify.csv" hash="8a01594aefc32010c79d369b05e12541"/></dir></target></contents>
69
  <compatible/>
70
- <dependencies><required><php><min>5.0.0</min><max>5.6.9</max></php></required></dependencies>
71
  </package>
1
  <?xml version="1.0"?>
2
  <package>
3
  <name>Sarbacane_Mailify</name>
4
+ <version>1.0.0.6</version>
5
  <stability>stable</stability>
6
  <license uri="http://www.opensource.org/licenses/academic.php">AFL</license>
7
  <channel>community</channel>
61
  &lt;li&gt;Estad&#xED;sticas detalladas, geolocalizaci&#xF3;n, detecci&#xF3;n de aperturas, tiempo de lectura, clics, tipo de mensajer&#xED;a, bajas, direcciones err&#xF3;neas...&lt;/li&gt;&#xD;
62
  &lt;/ul&gt;&#xD;
63
  &lt;a href="https://es.mailify.com/?utm_source=magento&amp;amp;utm_medium=plugin&amp;amp;utm_campaign=marketplace"&gt;es.mailify.com&lt;/a&gt;</description>
64
+ <notes>This release fixes an anomaly : we were importing only 2500 customers</notes>
65
  <authors><author><name>Sarbacane Software</name><user>egavard</user><email>connectors@sarbacane.com</email></author></authors>
66
+ <date>2015-10-21</date>
67
+ <time>15:45:54</time>
68
+ <contents><target name="magecommunity"><dir name="Sarbacane"><dir name="Mailify"><dir name="Block"><dir name="Adminhtml"><file name="Mailify.php" hash="f0ad71d64dc619421a67a3af24b23278"/></dir></dir><dir name="Helper"><file name="Data.php" hash="f4abc650d826b085fadb21c0af238021"/></dir><dir name="controllers"><dir name="Adminhtml"><file name="MailifyController.php" hash="0ae0d6822e9c5169870c0980861935eb"/></dir><file name="IndexController.php" hash="ac16f8223cbd1a013ef51cdae6f6e6b2"/></dir><dir name="etc"><file name="config.xml" hash="06a2535b4b545349b39f53faee8d187d"/></dir><dir name="sql"><dir name="mailify_setup"><file name="mysql4-install-1.0.0.0.php" hash="82834af7ce95c1bd9d3063ffdf3a11f5"/><file name="mysql4-upgrade-1.0.0.0-1.0.0.1.php" hash="35660ae27bb6ef74c885ad86284f9071"/><file name="mysql4-upgrade-1.0.0.1-1.0.0.2.php" hash="35660ae27bb6ef74c885ad86284f9071"/><file name="mysql4-upgrade-1.0.0.2-1.0.0.3.php" hash="35660ae27bb6ef74c885ad86284f9071"/><file name="mysql4-upgrade-1.0.0.3-1.0.0.4.php" hash="2bd5ea1d79115c1a6ba919a708b1fb4b"/></dir></dir></dir></dir></target><target name="mageskin"><dir name="adminhtml"><dir name="default"><dir name="default"><dir name="css"><dir name="Sarbacane_Mailify"><file name="mailify.css" hash="6fcee54bdab10db72a361ec5a139cc7c"/></dir></dir><dir name="images"><file name="sd.png" hash="2038d3c503e8f59d14177a131bef7537"/></dir><dir name="js"><dir name="Sarbacane_Mailify"><file name="mailify.js" hash="d38d9ec858dfdce14e0156acc87c1c50"/></dir></dir></dir></dir></dir></target><target name="magedesign"><dir name="adminhtml"><dir name="default"><dir name="default"><dir name="layout"><file name="mailify.xml" hash="2ce0ac9b7cd4ec8adf80494c86aaae10"/></dir><dir name="template"><dir name="mailify"><file name="mailify.phtml" hash="2207e779b2aabba7bf662405250e6c90"/></dir></dir></dir></dir></dir></target><target name="mage"><dir name="app"><dir name="etc"><dir name="modules"><file name="Sarbacane_Mailify.xml" hash="daf2fd2fbde04d804b1fdd7671273c82"/></dir></dir></dir></target><target name="magelocale"><dir name="es_ES"><file name="Sarbacane_Mailify.csv" hash="9b795397896dc1444b6cc072107abaed"/></dir><dir name="en_US"><file name="Sarbacane_Mailify.csv" hash="59f160ee7d95366e2f1202dad25061b5"/></dir></target></contents>
69
  <compatible/>
70
+ <dependencies><required><php><min>5.0.0</min><max>5.6.14</max></php></required></dependencies>
71
  </package>