DigitalPianism_Abandonedcarts - Version 0.1.7

Version Notes

- Add database prefix to the table in the Observer (thanks to mecaniqueorange for the advice)

Download this release

Release Info

Developer Digital Pianism
Extension DigitalPianism_Abandonedcarts
Version 0.1.7
Comparing to
See all releases


Code changes from version 0.1.6 to 0.1.7

Files changed (3) hide show
  1. app/code/community/DigitalPianism/Abandonedcarts/Model/Observer.php +10 -10
  2. app/code/community/DigitalPianism/Abandonedcarts/etc/config.xml +1 -1
  3. package.xml +5 -5
app/code/community/DigitalPianism/Abandonedcarts/Model/Observer.php CHANGED
@@ -198,23 +198,23 @@ class DigitalPianism_Abandonedcarts_Model_Observer extends Mage_Core_Model_Abstr
198
  )
199
  )
200
  ->joinInner(
201
- array('quote_items' => 'sales_flat_quote_item'),
202
  'quote_items.product_id = e.entity_id AND quote_items.price > 0.00',
203
  null)
204
  ->joinInner(
205
- array('quote_table' => 'sales_flat_quote'),
206
  'quote_items.quote_id = quote_table.entity_id AND quote_table.items_count > 0 AND quote_table.is_active = 1 AND quote_table.customer_email IS NOT NULL AND quote_table.abandoned_sale_notified = 0 AND quote_table.store_id = '.$storeId,
207
  null)
208
  ->joinInner(
209
- array('catalog_flat' => 'catalog_product_flat_'.$storeId),
210
  'catalog_flat.entity_id = e.entity_id',
211
  null)
212
  ->joinInner(
213
- array('catalog_enabled' => 'catalog_product_entity_int'),
214
  'catalog_enabled.entity_id = e.entity_id AND catalog_enabled.attribute_id = '.$statusId.' AND catalog_enabled.value = 1',
215
  null)
216
  ->joinInner(
217
- array('inventory' => 'cataloginventory_stock_status'),
218
  'inventory.product_id = e.entity_id AND inventory.stock_status = 1 AND inventory.website_id = '.$websiteId,
219
  null)
220
  ->order('quote_table.updated_at DESC');
@@ -368,23 +368,23 @@ class DigitalPianism_Abandonedcarts_Model_Observer extends Mage_Core_Model_Abstr
368
  )
369
  )
370
  ->joinInner(
371
- array('quote_items' => 'sales_flat_quote_item'),
372
  'quote_items.product_id = e.entity_id AND quote_items.price > 0.00',
373
  null)
374
  ->joinInner(
375
- array('quote_table' => 'sales_flat_quote'),
376
  'quote_items.quote_id = quote_table.entity_id AND quote_table.items_count > 0 AND quote_table.is_active = 1 AND quote_table.customer_email IS NOT NULL AND quote_table.abandoned_notified = 0 AND quote_table.updated_at < "'.$delay.'" AND quote_table.store_id = '.$storeId,
377
  null)
378
  ->joinInner(
379
- array('catalog_flat' => 'catalog_product_flat_'.$storeId),
380
  'catalog_flat.entity_id = e.entity_id',
381
  null)
382
  ->joinInner(
383
- array('catalog_enabled' => 'catalog_product_entity_int'),
384
  'catalog_enabled.entity_id = e.entity_id AND catalog_enabled.attribute_id = '.$statusId.' AND catalog_enabled.value = 1',
385
  null)
386
  ->joinInner(
387
- array('inventory' => 'cataloginventory_stock_status'),
388
  'inventory.product_id = e.entity_id AND inventory.stock_status = 1 AND website_id = '.$websiteId,
389
  null)
390
  ->order('quote_table.updated_at DESC');
198
  )
199
  )
200
  ->joinInner(
201
+ array('quote_items' => Mage::getSingleton("core/resource")->getTableName('sales_flat_quote_item')),
202
  'quote_items.product_id = e.entity_id AND quote_items.price > 0.00',
203
  null)
204
  ->joinInner(
205
+ array('quote_table' => Mage::getSingleton("core/resource")->getTableName('sales_flat_quote')),
206
  'quote_items.quote_id = quote_table.entity_id AND quote_table.items_count > 0 AND quote_table.is_active = 1 AND quote_table.customer_email IS NOT NULL AND quote_table.abandoned_sale_notified = 0 AND quote_table.store_id = '.$storeId,
207
  null)
208
  ->joinInner(
209
+ array('catalog_flat' => Mage::getSingleton("core/resource")->getTableName('catalog_product_flat_'.$storeId)),
210
  'catalog_flat.entity_id = e.entity_id',
211
  null)
212
  ->joinInner(
213
+ array('catalog_enabled' => Mage::getSingleton("core/resource")->getTableName('catalog_product_entity_int')),
214
  'catalog_enabled.entity_id = e.entity_id AND catalog_enabled.attribute_id = '.$statusId.' AND catalog_enabled.value = 1',
215
  null)
216
  ->joinInner(
217
+ array('inventory' => Mage::getSingleton("core/resource")->getTableName('cataloginventory_stock_status')),
218
  'inventory.product_id = e.entity_id AND inventory.stock_status = 1 AND inventory.website_id = '.$websiteId,
219
  null)
220
  ->order('quote_table.updated_at DESC');
368
  )
369
  )
370
  ->joinInner(
371
+ array('quote_items' => Mage::getSingleton("core/resource")->getTableName('sales_flat_quote_item')),
372
  'quote_items.product_id = e.entity_id AND quote_items.price > 0.00',
373
  null)
374
  ->joinInner(
375
+ array('quote_table' => Mage::getSingleton("core/resource")->getTableName('sales_flat_quote')),
376
  'quote_items.quote_id = quote_table.entity_id AND quote_table.items_count > 0 AND quote_table.is_active = 1 AND quote_table.customer_email IS NOT NULL AND quote_table.abandoned_notified = 0 AND quote_table.updated_at < "'.$delay.'" AND quote_table.store_id = '.$storeId,
377
  null)
378
  ->joinInner(
379
+ array('catalog_flat' => Mage::getSingleton("core/resource")->getTableName('catalog_product_flat_'.$storeId)),
380
  'catalog_flat.entity_id = e.entity_id',
381
  null)
382
  ->joinInner(
383
+ array('catalog_enabled' => Mage::getSingleton("core/resource")->getTableName('catalog_product_entity_int')),
384
  'catalog_enabled.entity_id = e.entity_id AND catalog_enabled.attribute_id = '.$statusId.' AND catalog_enabled.value = 1',
385
  null)
386
  ->joinInner(
387
+ array('inventory' => Mage::getSingleton("core/resource")->getTableName('cataloginventory_stock_status')),
388
  'inventory.product_id = e.entity_id AND inventory.stock_status = 1 AND website_id = '.$websiteId,
389
  null)
390
  ->order('quote_table.updated_at DESC');
app/code/community/DigitalPianism/Abandonedcarts/etc/config.xml CHANGED
@@ -4,7 +4,7 @@
4
 
5
  <modules>
6
  <DigitalPianism_Abandonedcarts>
7
- <version>0.1.6</version>
8
  </DigitalPianism_Abandonedcarts>
9
  </modules>
10
 
4
 
5
  <modules>
6
  <DigitalPianism_Abandonedcarts>
7
+ <version>0.1.7</version>
8
  </DigitalPianism_Abandonedcarts>
9
  </modules>
10
 
package.xml CHANGED
@@ -1,7 +1,7 @@
1
  <?xml version="1.0"?>
2
  <package>
3
  <name>DigitalPianism_Abandonedcarts</name>
4
- <version>0.1.6</version>
5
  <stability>stable</stability>
6
  <license uri="http://opensource.org/licenses/osl-3.0.php">OSL v3.0</license>
7
  <channel>community</channel>
@@ -10,11 +10,11 @@
10
  <description>This extension allows store managers to automatically notice customers with abandoned carts after a customizable number of days via email.&#xD;
11
  &#xD;
12
  Another email can also be sent if one of the abandoned products goes on sale.</description>
13
- <notes>- Improve memory management (30% memory use decrease)</notes>
14
  <authors><author><name>Digital Pianism</name><user>digitalpianism</user><email>contact@digital-pianism.com</email></author></authors>
15
- <date>2014-09-19</date>
16
- <time>10:43:32</time>
17
- <contents><target name="magecommunity"><dir name="DigitalPianism"><dir name="Abandonedcarts"><dir name="Block"><dir name="Adminhtml"><dir name="System"><dir name="Config"><dir name="Form"><file name="Button.php" hash="a27ec4c5bc4cb4e954ebdfebc71cbfd2"/></dir></dir></dir></dir></dir><dir name="Helper"><file name="Data.php" hash="c76d4abfe24cdad55badea279e13a9a1"/></dir><dir name="Model"><file name="Observer.php" hash="7c48610df3eae72c357d3441620edd4d"/></dir><dir name="controllers"><dir name="Adminhtml"><file name="AbandonedcartsController.php" hash="dc840a6de8c229175000df65b0d85289"/></dir></dir><dir name="etc"><file name="adminhtml.xml" hash="8ddca513c0ed7e034c476f3e026ceda8"/><file name="config.xml" hash="1e23c46b57c201de94becbf213848d44"/><file name="system.xml" hash="793efac0feb3c123a1c8869b21f302f1"/></dir><dir name="sql"><dir name="abandonedcarts_setup"><file name="install-0.0.1.php" hash="851338e4a710b5d94fead688b065f4b5"/><file name="upgrade-0.0.1-0.0.2.php" hash="0227c009e49b97bcf3f34f84c49f0927"/></dir></dir></dir></dir></target><target name="mageetc"><dir name="modules"><file name="DigitalPianism_Abandonedcarts.xml" hash="8a7657855486c68d548db4ba48e083d2"/></dir></target><target name="magelocale"><dir name="en_US"><file name="DigitalPianism_AbandonedCarts.csv" hash="4e17b6cae58dd1cdcd43b1113e2e09f4"/><dir name="template"><dir name="email"><dir name="digitalpianism"><file name="sales_abandonedcarts.html" hash="30565f91c47913465fd184a214c14b23"/><file name="sales_abandonedcarts_sale.html" hash="3cdee557727cb0166741062e5fdcf06f"/></dir></dir></dir></dir></target><target name="magedesign"><dir name="adminhtml"><dir name="default"><dir name="default"><dir name="template"><dir name="digitalpianism"><dir name="abandonedcarts"><dir name="system"><dir name="config"><file name="button.phtml" hash="8f7e673ea52cd81b616cac01b1022990"/></dir></dir></dir></dir></dir></dir></dir></dir></target></contents>
18
  <compatible/>
19
  <dependencies><required><php><min>4.1.0</min><max>6.0.0</max></php></required></dependencies>
20
  </package>
1
  <?xml version="1.0"?>
2
  <package>
3
  <name>DigitalPianism_Abandonedcarts</name>
4
+ <version>0.1.7</version>
5
  <stability>stable</stability>
6
  <license uri="http://opensource.org/licenses/osl-3.0.php">OSL v3.0</license>
7
  <channel>community</channel>
10
  <description>This extension allows store managers to automatically notice customers with abandoned carts after a customizable number of days via email.&#xD;
11
  &#xD;
12
  Another email can also be sent if one of the abandoned products goes on sale.</description>
13
+ <notes>- Add database prefix to the table in the Observer (thanks to mecaniqueorange for the advice)</notes>
14
  <authors><author><name>Digital Pianism</name><user>digitalpianism</user><email>contact@digital-pianism.com</email></author></authors>
15
+ <date>2014-10-08</date>
16
+ <time>12:14:00</time>
17
+ <contents><target name="magecommunity"><dir name="DigitalPianism"><dir name="Abandonedcarts"><dir name="Block"><dir name="Adminhtml"><dir name="System"><dir name="Config"><dir name="Form"><file name="Button.php" hash="a27ec4c5bc4cb4e954ebdfebc71cbfd2"/></dir></dir></dir></dir></dir><dir name="Helper"><file name="Data.php" hash="c76d4abfe24cdad55badea279e13a9a1"/></dir><dir name="Model"><file name="Observer.php" hash="5d9b5f630388be9659e4f40437e8a8ad"/></dir><dir name="controllers"><dir name="Adminhtml"><file name="AbandonedcartsController.php" hash="dc840a6de8c229175000df65b0d85289"/></dir></dir><dir name="etc"><file name="adminhtml.xml" hash="8ddca513c0ed7e034c476f3e026ceda8"/><file name="config.xml" hash="8d74cc7b72a11d69339e2de87dab9c89"/><file name="system.xml" hash="793efac0feb3c123a1c8869b21f302f1"/></dir><dir name="sql"><dir name="abandonedcarts_setup"><file name="install-0.0.1.php" hash="851338e4a710b5d94fead688b065f4b5"/><file name="upgrade-0.0.1-0.0.2.php" hash="0227c009e49b97bcf3f34f84c49f0927"/></dir></dir></dir></dir></target><target name="mageetc"><dir name="modules"><file name="DigitalPianism_Abandonedcarts.xml" hash="8a7657855486c68d548db4ba48e083d2"/></dir></target><target name="magelocale"><dir name="en_US"><file name="DigitalPianism_AbandonedCarts.csv" hash="4e17b6cae58dd1cdcd43b1113e2e09f4"/><dir name="template"><dir name="email"><dir name="digitalpianism"><file name="sales_abandonedcarts.html" hash="30565f91c47913465fd184a214c14b23"/><file name="sales_abandonedcarts_sale.html" hash="3cdee557727cb0166741062e5fdcf06f"/></dir></dir></dir></dir></target><target name="magedesign"><dir name="adminhtml"><dir name="default"><dir name="default"><dir name="template"><dir name="digitalpianism"><dir name="abandonedcarts"><dir name="system"><dir name="config"><file name="button.phtml" hash="8f7e673ea52cd81b616cac01b1022990"/></dir></dir></dir></dir></dir></dir></dir></dir></target></contents>
18
  <compatible/>
19
  <dependencies><required><php><min>4.1.0</min><max>6.0.0</max></php></required></dependencies>
20
  </package>