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 +6 -3
- app/code/community/Sarbacane/Mailify/controllers/Adminhtml/MailifyController.php +1 -3
- app/code/community/Sarbacane/Mailify/controllers/IndexController.php +65 -46
- app/code/community/Sarbacane/Mailify/etc/config.xml +147 -147
- app/locale/en_US/Sarbacane_Mailify.csv +58 -58
- app/locale/es_ES/Sarbacane_Mailify.csv +58 -58
- package.xml +6 -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($
|
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 `
|
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 |
-
|
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
|
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.
|
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 |
-
|
|
|
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 |
-
|
|
|
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 .= ",
|
|
|
|
|
|
|
|
|
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 |
-
|
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 . "'
|
|
|
|
|
|
|
|
|
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 |
-
|
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
|
238 |
-
|
239 |
-
$rq_sql .= "
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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.
|
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 |
<stability>stable</stability>
|
6 |
<license uri="http://www.opensource.org/licenses/academic.php">AFL</license>
|
7 |
<channel>community</channel>
|
@@ -61,11 +61,11 @@
|
|
61 |
<li>Estadísticas detalladas, geolocalización, detección de aperturas, tiempo de lectura, clics, tipo de mensajería, bajas, direcciones erróneas...</li>
|
62 |
</ul>
|
63 |
<a href="https://es.mailify.com/?utm_source=magento&amp;utm_medium=plugin&amp;utm_campaign=marketplace">es.mailify.com</a></description>
|
64 |
-
<notes>This release
|
65 |
<authors><author><name>Sarbacane Software</name><user>egavard</user><email>connectors@sarbacane.com</email></author></authors>
|
66 |
-
<date>2015-
|
67 |
-
<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="
|
69 |
<compatible/>
|
70 |
-
<dependencies><required><php><min>5.0.0</min><max>5.6.
|
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 |
<li>Estadísticas detalladas, geolocalización, detección de aperturas, tiempo de lectura, clics, tipo de mensajería, bajas, direcciones erróneas...</li>
|
62 |
</ul>
|
63 |
<a href="https://es.mailify.com/?utm_source=magento&amp;utm_medium=plugin&amp;utm_campaign=marketplace">es.mailify.com</a></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>
|