Sarbacane_Mailify - Version 1.0.0.2

Version Notes

Fixes some links

Download this release

Release Info

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


Code changes from version 1.0.0.0 to 1.0.0.2

Files changed (4) hide show
  1. app/code/community/Sarbacane/Mailify/controllers/IndexController.php +13 -13
  2. app/locale/en_US/Sarbacane_Mailify.csv +4 -4
  3. app/locale/es_ES/Sarbacane_Mailify.csv +3 -3
  4. package.xml +5 -7
app/code/community/Sarbacane/Mailify/controllers/IndexController.php CHANGED
@@ -202,33 +202,33 @@ class Sarbacane_Mailify_IndexController extends Mage_Core_Controller_Front_Actio
202
  if($add_customer_data){
203
  $rq_sql = "
204
  SELECT c.email AS email ,cevln.value as lastname , cevfn.value as firstname, 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,sd.sd_id,sd.orders_data
205
- FROM customer_entity c
206
- LEFT JOIN customer_entity_varchar cevln ON cevln.entity_id = c.entity_id AND cevln.attribute_id=7
207
- LEFT JOIN customer_entity_varchar cevfn ON cevfn.entity_id = c.entity_id AND cevfn.attribute_id = 5
208
- LEFT JOIN sales_flat_order sfo ON sfo.customer_id = c.entity_id
209
- LEFT JOIN sarbacanedesktop sd ON sd.email = c.email AND sd.sd_id = ". $sd_id ." AND sd.list_type='C'
210
  WHERE c.store_id = ". $store_id ."
211
  GROUP BY c.entity_id
212
  HAVING nb_orders > 0 AND (sd.sd_id IS NULL OR sd.orders_data != CONCAT(MIN(sfo.base_grand_total),MAX(sfo.base_grand_total),COUNT(sfo.entity_id),SUM(sfo.base_grand_total)))
213
  UNION
214
  SELECT sfo.customer_email AS email ,sfo.customer_lastname as lastname , sfo.customer_firstname as firstname, 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,sd.sd_id,sd.orders_data
215
- FROM sales_flat_order sfo
216
- LEFT JOIN sarbacanedesktop sd ON sd.email = sfo.customer_email AND sd.sd_id = ". $sd_id ." AND sd.list_type='C'
217
  WHERE sd.sd_id IS NULL AND sfo.customer_id IS NULL AND sfo.store_id = ". $store_id ."
218
  GROUP BY sfo.customer_email
219
  HAVING nb_orders > 0 AND (sd.sd_id IS NULL OR sd.orders_data != CONCAT(MIN(sfo.base_grand_total),MAX(sfo.base_grand_total),COUNT(sfo.entity_id),SUM(sfo.base_grand_total)))";
220
  }else{
221
  $rq_sql = "
222
  SELECT c.email AS email ,cevln.value as lastname , cevfn.value as firstname
223
- FROM customer_entity c
224
- LEFT JOIN customer_entity_varchar cevln ON cevln.entity_id = c.entity_id AND cevln.attribute_id=7
225
- LEFT JOIN customer_entity_varchar cevfn ON cevfn.entity_id = c.entity_id AND cevfn.attribute_id = 5
226
- LEFT JOIN sarbacanedesktop sd ON sd.email = c.email AND sd.sd_id = ". $sd_id ." AND sd.list_type='C'
227
  WHERE sd.sd_id IS NULL AND c.store_id = ". $store_id ."
228
  UNION
229
  SELECT sfo.customer_email AS email ,sfo.customer_lastname as lastname , sfo.customer_firstname as firstname
230
- FROM sales_flat_order sfo
231
- LEFT JOIN sarbacanedesktop sd ON sd.email = sfo.customer_email AND sd.sd_id = ". $sd_id ." AND sd.list_type='C'
232
  WHERE sd.sd_id IS NULL AND sfo.customer_id IS NULL AND sfo.store_id = ". $store_id ." ";
233
  }
234
  $rq_sql .=" LIMIT 0, 2500";
202
  if($add_customer_data){
203
  $rq_sql = "
204
  SELECT c.email AS email ,cevln.value as lastname , cevfn.value as firstname, 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,sd.sd_id,sd.orders_data
205
+ FROM $customer_entity c
206
+ LEFT JOIN $customer_entity_varchar cevln ON cevln.entity_id = c.entity_id AND cevln.attribute_id=7
207
+ LEFT JOIN $customer_entity_varchar cevfn ON cevfn.entity_id = c.entity_id AND cevfn.attribute_id = 5
208
+ LEFT JOIN $sales_flat_order sfo ON sfo.customer_id = c.entity_id
209
+ LEFT JOIN $sarbacanedesktop sd ON sd.email = c.email AND sd.sd_id = ". $sd_id ." AND sd.list_type='C'
210
  WHERE c.store_id = ". $store_id ."
211
  GROUP BY c.entity_id
212
  HAVING nb_orders > 0 AND (sd.sd_id IS NULL OR sd.orders_data != CONCAT(MIN(sfo.base_grand_total),MAX(sfo.base_grand_total),COUNT(sfo.entity_id),SUM(sfo.base_grand_total)))
213
  UNION
214
  SELECT sfo.customer_email AS email ,sfo.customer_lastname as lastname , sfo.customer_firstname as firstname, 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,sd.sd_id,sd.orders_data
215
+ FROM $sales_flat_order sfo
216
+ LEFT JOIN $sarbacanedesktop sd ON sd.email = sfo.customer_email AND sd.sd_id = ". $sd_id ." AND sd.list_type='C'
217
  WHERE sd.sd_id IS NULL AND sfo.customer_id IS NULL AND sfo.store_id = ". $store_id ."
218
  GROUP BY sfo.customer_email
219
  HAVING nb_orders > 0 AND (sd.sd_id IS NULL OR sd.orders_data != CONCAT(MIN(sfo.base_grand_total),MAX(sfo.base_grand_total),COUNT(sfo.entity_id),SUM(sfo.base_grand_total)))";
220
  }else{
221
  $rq_sql = "
222
  SELECT c.email AS email ,cevln.value as lastname , cevfn.value as firstname
223
+ FROM $customer_entity c
224
+ LEFT JOIN $customer_entity_varchar cevln ON cevln.entity_id = c.entity_id AND cevln.attribute_id=7
225
+ LEFT JOIN $customer_entity_varchar cevfn ON cevfn.entity_id = c.entity_id AND cevfn.attribute_id = 5
226
+ LEFT JOIN $sarbacanedesktop sd ON sd.email = c.email AND sd.sd_id = ". $sd_id ." AND sd.list_type='C'
227
  WHERE sd.sd_id IS NULL AND c.store_id = ". $store_id ."
228
  UNION
229
  SELECT sfo.customer_email AS email ,sfo.customer_lastname as lastname , sfo.customer_firstname as firstname
230
+ FROM $sales_flat_order sfo
231
+ LEFT JOIN $sarbacanedesktop sd ON sd.email = sfo.customer_email AND sd.sd_id = ". $sd_id ." AND sd.list_type='C'
232
  WHERE sd.sd_id IS NULL AND sfo.customer_id IS NULL AND sfo.store_id = ". $store_id ." ";
233
  }
234
  $rq_sql .=" LIMIT 0, 2500";
app/locale/en_US/Sarbacane_Mailify.csv CHANGED
@@ -25,7 +25,7 @@
25
  "Tel:","Tel:"
26
  "+33(0) 328 328 040","(646)-844-0983"
27
  "Website:","Website : "
28
- "http://www.sarbacane.com/?utm_source=module-prestashop&utm_medium=plugin&utm_content=lien-sarbacane&utm_campaign=prestashop","http://www.mailify.com/?lng=EN&utm_source=module-prestashop&utm_medium=plugin&utm_content=lien-sarbacane&utm_campaign=prestashop"
29
  "http://www.sarbacane.com","http://www.mailify.com"
30
  "How to set up the module?","How to set up the module?"
31
  "Do you already have a Sarbacane Desktop account?","Do you already have a Mailify account?"
@@ -47,12 +47,12 @@
47
  "- Average amount of the orders placed","- Average amount of the orders placed"
48
  "Previous","Previous"
49
  "Download and install Sarbacane","Download and install Mailify"
50
- "https://www.sarbacane.com/ws/soft-redirect.asp?key=heXmrxBEUO&com=PrestaShopInfo","https://static.mailify.com/ws/soft-redirect.asp?key=heXmrxBEUO&com=PrestaShopInfo&lng=EN"
51
  "Create your free account","Create your free account"
52
- "Enable the Prestashop extension in our extensions menu, and then fill in the following fields:","Enable the Prestashop 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
- "http://www.sarbacane.com/faq/extensions/configuration-plugin-prestashop/?utm_source=module-prestashop&utm_medium=plugin&utm_content=lien-sarbacane&utm_campaign=prestashop","http://www.mailify.com/faq/extensions/configuration-prestashop/?lng=EN&utm_source=module-prestashop&utm_medium=plugin&utm_content=lien-sarbacane&utm_campaign=prestashop"
58
  "in the help section online","in the help section online"
25
  "Tel:","Tel:"
26
  "+33(0) 328 328 040","(646)-844-0983"
27
  "Website:","Website : "
28
+ "http://www.sarbacane.com/?utm_source=module-prestashop&utm_medium=plugin&utm_content=lien-sarbacane&utm_campaign=prestashop","http://www.mailify.com/?lng=EN&utm_source=module-magento&utm_medium=plugin&utm_content=lien-sarbacane&utm_campaign=magento"
29
  "http://www.sarbacane.com","http://www.mailify.com"
30
  "How to set up the module?","How to set up the module?"
31
  "Do you already have a Sarbacane Desktop account?","Do you already have a Mailify account?"
47
  "- Average amount of the orders placed","- Average amount of the orders placed"
48
  "Previous","Previous"
49
  "Download and install Sarbacane","Download and install Mailify"
50
+ "https://www.sarbacane.com/ws/soft-redirect.asp?key=heXmrxBEUO&com=PrestaShopInfo","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 Prestashop 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
+ "http://www.sarbacane.com/faq/extensions/configuration-plugin-prestashop/?utm_source=module-prestashop&utm_medium=plugin&utm_content=lien-sarbacane&utm_campaign=prestashop","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
@@ -25,7 +25,7 @@
25
  "Tel:","Tel:"
26
  "+33(0) 328 328 040","+34 93 4763638"
27
  "Website:","Web : "
28
- "http://www.sarbacane.com/?utm_source=module-prestashop&utm_medium=plugin&utm_content=lien-sarbacane&utm_campaign=prestashop","http://es.mailify.com/?lng=ES&utm_source=module-prestashop&utm_medium=plugin&utm_content=lien-sarbacane&utm_campaign=prestashop"
29
  "http://www.sarbacane.com","http://es.mailify.com"
30
  "How to set up the module?","¿Cómo configurar el módulo?"
31
  "Do you already have a Sarbacane Desktop account?","¿Ya eres usuario Mailify?"
@@ -47,12 +47,12 @@
47
  "- Average amount of the orders placed","- Importe medio de pedidos"
48
  "Previous","Anterior"
49
  "Download and install Sarbacane","Descarga e instala Mailify"
50
- "https://www.sarbacane.com/ws/soft-redirect.asp?key=heXmrxBEUO&com=PrestaShopInfo","https://static.mailify.com/ws/soft-redirect.asp?key=heXmrxBEUO&com=PrestaShopInfo&lng=ES"
51
  "Create your free account","Crea tu cuenta gratis"
52
  "Enable the Prestashop 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
- "http://www.sarbacane.com/faq/extensions/configuration-plugin-prestashop/?utm_source=module-prestashop&utm_medium=plugin&utm_content=lien-sarbacane&utm_campaign=prestashop","https://es.mailify.com/faq/herramientas-analisis-email-marketing/configurar-plugin-prestashop/?lng=ES&utm_source=module-prestashop&utm_medium=plugin&utm_content=lien-sarbacane&utm_campaign=prestashop"
58
  "in the help section online","ayuda en línea"
25
  "Tel:","Tel:"
26
  "+33(0) 328 328 040","+34 93 4763638"
27
  "Website:","Web : "
28
+ "http://www.sarbacane.com/?utm_source=module-prestashop&utm_medium=plugin&utm_content=lien-sarbacane&utm_campaign=prestashop","http://es.mailify.com/?lng=ES&utm_source=module-magento&utm_medium=plugin&utm_content=lien-sarbacane&utm_campaign=magento"
29
  "http://www.sarbacane.com","http://es.mailify.com"
30
  "How to set up the module?","¿Cómo configurar el módulo?"
31
  "Do you already have a Sarbacane Desktop account?","¿Ya eres usuario Mailify?"
47
  "- Average amount of the orders placed","- Importe medio de pedidos"
48
  "Previous","Anterior"
49
  "Download and install Sarbacane","Descarga e instala Mailify"
50
+ "https://www.sarbacane.com/ws/soft-redirect.asp?key=heXmrxBEUO&com=PrestaShopInfo","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 Prestashop 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
+ "http://www.sarbacane.com/faq/extensions/configuration-plugin-prestashop/?utm_source=module-prestashop&utm_medium=plugin&utm_content=lien-sarbacane&utm_campaign=prestashop","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.0</version>
5
  <stability>stable</stability>
6
  <license uri="http://www.opensource.org/licenses/academic.php">AFL</license>
7
  <channel>community</channel>
@@ -58,13 +58,11 @@
58
  &lt;li&gt;Possibilit&#xE9; de cibler et exploiter les contacts en fonction de leurs donn&#xE9;es de commandes pour des campagnes plus efficaces&lt;/li&gt;&#xD;
59
  &lt;li&gt;Statistiques d&#xE9;taill&#xE9;es, g&#xE9;olocalisation, d&#xE9;tection des ouvertures, temps d'ouvertures, clics, type de messageries, d&#xE9;sabonnements, adresses erronn&#xE9;es, etc.&lt;/li&gt;&#xD;
60
  &lt;/ul&gt;</description>
61
- <notes>First release of this connector for Mailify.&#xD;
62
- &#xD;
63
- It allows you to synchronize all your shop data into Mailify</notes>
64
  <authors><author><name>Sarbacane Software</name><user>egavard</user><email>connectors@sarbacane.com</email></author></authors>
65
- <date>2015-05-20</date>
66
- <time>11:20:07</time>
67
- <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="0209b2a9566288c2b030552d8bb2d85b"/></dir><dir name="controllers"><dir name="Adminhtml"><file name="MailifyController.php" hash="a9088e5aab6fbaef8daa9b0f9aac663d"/></dir><file name="IndexController.php" hash="cfe3cd3960333e32e298aa0324543b88"/></dir><dir name="etc"><file name="config.xml" hash="f1170aa559d1d6ceef7f4ebf22fc8ce8"/></dir><dir name="sql"><dir name="mailify_setup"><file name="mysql4-install-1.0.0.0.php" hash="82834af7ce95c1bd9d3063ffdf3a11f5"/></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="01ed4cea3b25957dbfbb2ad3e99c41e8"/></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="8935ea92f97fa8f488ce2d6e22dcc1f6"/></dir><dir name="en_US"><file name="Sarbacane_Mailify.csv" hash="14e823bac27169a06084b0683ce8a01c"/></dir></target></contents>
68
  <compatible/>
69
  <dependencies><required><php><min>5.0.0</min><max>5.6.9</max></php></required></dependencies>
70
  </package>
1
  <?xml version="1.0"?>
2
  <package>
3
  <name>Sarbacane_Mailify</name>
4
+ <version>1.0.0.2</version>
5
  <stability>stable</stability>
6
  <license uri="http://www.opensource.org/licenses/academic.php">AFL</license>
7
  <channel>community</channel>
58
  &lt;li&gt;Possibilit&#xE9; de cibler et exploiter les contacts en fonction de leurs donn&#xE9;es de commandes pour des campagnes plus efficaces&lt;/li&gt;&#xD;
59
  &lt;li&gt;Statistiques d&#xE9;taill&#xE9;es, g&#xE9;olocalisation, d&#xE9;tection des ouvertures, temps d'ouvertures, clics, type de messageries, d&#xE9;sabonnements, adresses erronn&#xE9;es, etc.&lt;/li&gt;&#xD;
60
  &lt;/ul&gt;</description>
61
+ <notes>Fixes some links</notes>
 
 
62
  <authors><author><name>Sarbacane Software</name><user>egavard</user><email>connectors@sarbacane.com</email></author></authors>
63
+ <date>2015-06-17</date>
64
+ <time>15:06:48</time>
65
+ <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="0209b2a9566288c2b030552d8bb2d85b"/></dir><dir name="controllers"><dir name="Adminhtml"><file name="MailifyController.php" hash="a9088e5aab6fbaef8daa9b0f9aac663d"/></dir><file name="IndexController.php" hash="e34bfde04c99e0fec91c22eb15f52bbc"/></dir><dir name="etc"><file name="config.xml" hash="f1170aa559d1d6ceef7f4ebf22fc8ce8"/></dir><dir name="sql"><dir name="mailify_setup"><file name="mysql4-install-1.0.0.0.php" hash="82834af7ce95c1bd9d3063ffdf3a11f5"/></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="01ed4cea3b25957dbfbb2ad3e99c41e8"/></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="168cc69eed53a792a539ce1045d19aac"/></dir><dir name="en_US"><file name="Sarbacane_Mailify.csv" hash="324d42d9744e33d635020b84fb6262d6"/></dir></target></contents>
66
  <compatible/>
67
  <dependencies><required><php><min>5.0.0</min><max>5.6.9</max></php></required></dependencies>
68
  </package>