Listrak_Remarketing - Version 1.1.0

Version Notes

Fixed install script table setup bug, 2 minor API bug fixes

Download this release

Release Info

Developer Magento Core Team
Extension Listrak_Remarketing
Version 1.1.0
Comparing to
See all releases


Code changes from version 1.0.9 to 1.1.0

Files changed (6) hide show
  1. app/code/community/Listrak/Remarketing/Model/Abandonedcart/Api.php +2 -1
  2. app/code/community/Listrak/Remarketing/Model/Mysql4/Abandonedcart/Collection.php +3 -4
  3. app/code/community/Listrak/Remarketing/controllers/CartController.php +1 -1
  4. app/code/community/Listrak/Remarketing/etc/config.xml +1 -1
  5. app/code/community/Listrak/Remarketing/sql/listrak_remarketing_setup/mysql4-install-1.0.0.php +1 -1
  6. package.xml +5 -5
app/code/community/Listrak/Remarketing/Model/Abandonedcart/Api.php CHANGED
@@ -37,7 +37,8 @@ class Listrak_Remarketing_Model_Abandonedcart_Api extends Mage_Api_Model_Resourc
37
 
38
  $sessions = Mage::getModel("listrak/session")->getCollection()
39
  ->addFieldToFilter('main_table.updated_at', array('lt' => $endDate))
40
- ->addStoreFilter($storeId);
 
41
 
42
  $count = $sessions->count();
43
 
37
 
38
  $sessions = Mage::getModel("listrak/session")->getCollection()
39
  ->addFieldToFilter('main_table.updated_at', array('lt' => $endDate))
40
+ ->addStoreFilter($storeId)
41
+ ->setPageSize(100);
42
 
43
  $count = $sessions->count();
44
 
app/code/community/Listrak/Remarketing/Model/Mysql4/Abandonedcart/Collection.php CHANGED
@@ -19,11 +19,10 @@ class Listrak_Remarketing_Model_Mysql4_Abandonedcart_Collection extends Mage_Cor
19
  ->join(array('q'=>$this->getTable('sales/quote')),
20
  'main_table.quote_id = q.entity_id',
21
  array('items_qty','grand_total'))
22
- ->joinLeft(array('qa' => $this->getTable('sales/quote_address')),
23
  'q.entity_id=qa.quote_id AND qa.address_type="billing"',
24
- array('qa.firstname AS customer_firstName', 'qa.lastname AS customer_lastName'))
25
- ->where('q.items_count > 0 AND q.is_active = 1')
26
- ->distinct();
27
  }
28
 
29
  public function addStoreFilter($storeIds)
19
  ->join(array('q'=>$this->getTable('sales/quote')),
20
  'main_table.quote_id = q.entity_id',
21
  array('items_qty','grand_total'))
22
+ /*->joinLeft(array('qa' => $this->getTable('sales/quote_address')),
23
  'q.entity_id=qa.quote_id AND qa.address_type="billing"',
24
+ array('qa.firstname AS customer_firstName', 'qa.lastname AS customer_lastName'))*/
25
+ ->where('q.items_count > 0 AND q.is_active = 1');
 
26
  }
27
 
28
  public function addStoreFilter($storeIds)
app/code/community/Listrak/Remarketing/controllers/CartController.php CHANGED
@@ -46,7 +46,7 @@ class Listrak_Remarketing_CartController extends Mage_Core_Controller_Front_Acti
46
  }
47
  }
48
  catch(Exception $ex) {
49
- Mage::getModel("listrak/log")->addException($e);
50
  }
51
 
52
  return $this->redirect();
46
  }
47
  }
48
  catch(Exception $ex) {
49
+ Mage::getModel("listrak/log")->addException($ex);
50
  }
51
 
52
  return $this->redirect();
app/code/community/Listrak/Remarketing/etc/config.xml CHANGED
@@ -7,7 +7,7 @@
7
  <config>
8
  <modules>
9
  <Listrak_Remarketing>
10
- <version>1.0.9</version>
11
  </Listrak_Remarketing>
12
  </modules>
13
  <frontend>
7
  <config>
8
  <modules>
9
  <Listrak_Remarketing>
10
+ <version>1.1.0</version>
11
  </Listrak_Remarketing>
12
  </modules>
13
  <frontend>
app/code/community/Listrak/Remarketing/sql/listrak_remarketing_setup/mysql4-install-1.0.0.php CHANGED
@@ -57,7 +57,7 @@ CREATE TABLE IF NOT EXISTS {$this->getTable('listrak/subscriber_update')} (
57
  PRIMARY KEY (`id`)
58
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
59
 
60
- CREATE TABLE IF NOT EXISTS `listrak_remarketing_log` (
61
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
62
  `store_id` int(11) DEFAULT NULL,
63
  `date_entered` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
57
  PRIMARY KEY (`id`)
58
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
59
 
60
+ CREATE TABLE IF NOT EXISTS {$this->getTable('listrak/log')} (
61
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
62
  `store_id` int(11) DEFAULT NULL,
63
  `date_entered` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
package.xml CHANGED
@@ -1,7 +1,7 @@
1
  <?xml version="1.0"?>
2
  <package>
3
  <name>Listrak_Remarketing</name>
4
- <version>1.0.9</version>
5
  <stability>stable</stability>
6
  <license uri="http://s1.listrakbi.com/licenses/magento.txt">Listrak EULA</license>
7
  <channel>community</channel>
@@ -15,11 +15,11 @@
15
  - Ability to disable Magento newsletter welcome messages&#xD;
16
  - Tracks clicks from Listrak emails for conversion reporting&#xD;
17
  - Synchronizes Magento newsletter subscriptions with your Listrak account</description>
18
- <notes>Added Listrak script include for modal subscriber functionality</notes>
19
  <authors><author><name>Listrak</name><user>auto-converted</user><email>magento@listrak.com</email></author></authors>
20
- <date>2012-02-27</date>
21
- <time>15:19:21</time>
22
- <contents><target name="magecommunity"><dir name="Listrak"><dir name="Remarketing"><dir name="Block"><dir name="Adminhtml"><dir name="Abandonedcartreport"><file name="Grid.php" hash="6c9975250ee0d3318fe1a996e19b554f"/></dir><dir name="Emailcapture"><dir name="Edit"><dir name="Tab"><file name="Form.php" hash="d1b495e77fd135af95457ee7c3f1f21c"/></dir><file name="Form.php" hash="dae25c78913b35bb3ad64da797cd82b4"/><file name="Tabs.php" hash="b7c89cd1e1fae23ed52079c6d63ef4ee"/></dir><file name="Edit.php" hash="6a06c2b0dfb5a0414a642bc0cd3b5461"/><file name="Grid.php" hash="9eca43e603861ce2f24ec21a4d3a5064"/></dir><file name="Abandonedcartreport.php" hash="5c348aeec1c636b39ac037b5abc1875a"/><file name="Emailcapture.php" hash="accf0689467c5446e7605cad41e427b0"/><file name="Notifications.php" hash="dec4ef3882d5d11d738576787d05ec61"/></dir><file name="Ecjs.php" hash="1435cf65a3c33850e630364baa87a96e"/><file name="Modal.php" hash="42689930f0f039895e05a39ec4b5c917"/></dir><dir name="Helper"><file name="Data.php" hash="bd33bd2e7c3b6cf34cc28499a1f2eb7f"/></dir><dir name="Model"><dir name="Abandonedcart"><dir name="Api"><file name="V2.php" hash="c7b46e1feab677e41f4f9a3914e415fb"/></dir><file name="Api.php" hash="904d3c39e295d3190c2d4f683fb63f2b"/></dir><dir name="Apiextension"><dir name="Api"><file name="V2.php" hash="ff5a5f68d92c8a790bb00282c30c1378"/></dir><file name="Api.php" hash="2e89fc5ae21b95aa584d3f5e4f47184e"/></dir><dir name="Click"><dir name="Api"><file name="V2.php" hash="510ae6b8032ff54b5f43d94f447f35e2"/></dir><file name="Api.php" hash="b22605c25dd1336188a62fbbecc177bf"/></dir><dir name="Log"><dir name="Api"><file name="V2.php" hash="ace9ca737ebefd47205886fdef504a05"/></dir><file name="Api.php" hash="2a2a52b419cb90c0648209964b961287"/></dir><dir name="Mysql4"><dir name="Abandonedcart"><file name="Collection.php" hash="62e20b7c44dc63b4e7599ae5f37b2a90"/></dir><dir name="Click"><file name="Collection.php" hash="41ff4606dff463ddac76e790a5d9d8d5"/></dir><dir name="Emailcapture"><file name="Collection.php" hash="4dbc86c599e6a390e1f8bde7752f09c2"/></dir><dir name="Log"><file name="Collection.php" hash="1765ae33eb74e9593d8266702cfe4160"/></dir><dir name="Session"><file name="Collection.php" hash="c095fdf0c54184df63ff6dd8636d779e"/></dir><dir name="Subscriberupdate"><file name="Collection.php" hash="1fd68314a80e93f416815273f29bf9f5"/></dir><file name="Abandonedcart.php" hash="446945e10c03137241f2d1eefd8668b6"/><file name="Apiextension.php" hash="4bbee7324ff4e6e4ca70587b023da6a0"/><file name="Click.php" hash="baabaf95e4d4f7f3fb1a2ac1c1965984"/><file name="Emailcapture.php" hash="b68ee210c3bcec8f2fccef7979b022b7"/><file name="Log.php" hash="e244d19b857ee9d03a7955a30d3f6cf3"/><file name="Session.php" hash="454a2c56529a0db4db3a5b8473952f78"/><file name="Subscriberupdate.php" hash="4957865b4aa8bbdda3a50484d7e49880"/></dir><file name="Abandonedcart.php" hash="2bd672054843917133e3ac7d941be42c"/><file name="Apiextension.php" hash="1a5964f749523d74c648d6609673fb08"/><file name="Click.php" hash="8c7e2d5eba20c24fdf3fcf516c772001"/><file name="Emailcapture.php" hash="4987ceda6dda7ca134736895e3cfed74"/><file name="Log.php" hash="577b2308bdbc531c867c67277d513371"/><file name="Observer.php" hash="375845e1ff616e7fa1736ab90335f989"/><file name="Session.php" hash="022a065dcbc893cec1eab6a89863c089"/><file name="Subscriber.php" hash="7addcff01d1c12e88baad9064a362f2c"/><file name="Subscriberupdate.php" hash="77df791c2d17772345f518ce3b4dab90"/></dir><dir name="controllers"><dir name="Adminhtml"><file name="AbandonedcartreportController.php" hash="e1a2c2db0c6cc8cc30f9fdf26636c1a0"/><file name="EmailcaptureController.php" hash="ad7c87ca689bc30eb135fc5d25ae21a2"/></dir><file name="CartController.php" hash="a4e57836e667b885d19d02a60660390b"/><file name="ConfigController.php" hash="7250d699110107b35fa004833dc3595e"/><file name="EmailController.php" hash="7b9e1711e0c964876b8afe46dde9266b"/><file name="TroubleshootingController.php" hash="8e9355a2c91ee3508620fc893aabe050"/></dir><dir name="etc"><file name="adminhtml.xml" hash="0e01a6415641c271f4eb3067419c7f0a"/><file name="api.xml" hash="9e261fb5bfd7fc24870a8f8af5c9b226"/><file name="config.xml" hash="ded230bdc0eee02c5638c595b47c6ff8"/><file name="system.xml" hash="1a7f5f74a95b8679dc231e17a68e158c"/><file name="wsdl.xml" hash="69f888d1d5f3348ba09ad017e7a26f36"/></dir><dir name="sql"><dir name="listrak_remarketing_setup"><file name="mysql4-install-1.0.0.php" hash="d12bcc8b1ee2876c456b67ba6bec7951"/><file name="mysql4-upgrade-1.0.0-1.0.1.php" hash="51d6494a61a2e32907cdc8eaf078274c"/><file name="mysql4-upgrade-1.0.8-1.0.9.php" hash="8c935ec4a7ff8816c1ab1df644c1edf3"/></dir></dir></dir></dir></target><target name="magedesign"><dir name="adminhtml"><dir name="default"><dir name="default"><dir name="layout"><file name="remarketing.xml" hash="44d7027ba447c4aaf0841d32d185ffde"/></dir></dir></dir></dir><dir name="frontend"><dir name="base"><dir name="default"><dir name="layout"><file name="remarketing.xml" hash="3fe421a6b7ea5ab184c8791971b41a6a"/></dir></dir></dir></dir></target><target name="mageetc"><dir name="modules"><file name="Listrak_Remarketing.xml" hash="1fc68edb656e220874e64cffaf7f2dbd"/></dir></target></contents>
23
  <compatible/>
24
  <dependencies/>
25
  </package>
1
  <?xml version="1.0"?>
2
  <package>
3
  <name>Listrak_Remarketing</name>
4
+ <version>1.1.0</version>
5
  <stability>stable</stability>
6
  <license uri="http://s1.listrakbi.com/licenses/magento.txt">Listrak EULA</license>
7
  <channel>community</channel>
15
  - Ability to disable Magento newsletter welcome messages&#xD;
16
  - Tracks clicks from Listrak emails for conversion reporting&#xD;
17
  - Synchronizes Magento newsletter subscriptions with your Listrak account</description>
18
+ <notes>Fixed install script table setup bug, 2 minor API bug fixes</notes>
19
  <authors><author><name>Listrak</name><user>auto-converted</user><email>magento@listrak.com</email></author></authors>
20
+ <date>2012-03-23</date>
21
+ <time>19:23:10</time>
22
+ <contents><target name="magecommunity"><dir name="Listrak"><dir name="Remarketing"><dir name="Block"><dir name="Adminhtml"><dir name="Abandonedcartreport"><file name="Grid.php" hash="6c9975250ee0d3318fe1a996e19b554f"/></dir><dir name="Emailcapture"><dir name="Edit"><dir name="Tab"><file name="Form.php" hash="d1b495e77fd135af95457ee7c3f1f21c"/></dir><file name="Form.php" hash="dae25c78913b35bb3ad64da797cd82b4"/><file name="Tabs.php" hash="b7c89cd1e1fae23ed52079c6d63ef4ee"/></dir><file name="Edit.php" hash="6a06c2b0dfb5a0414a642bc0cd3b5461"/><file name="Grid.php" hash="9eca43e603861ce2f24ec21a4d3a5064"/></dir><file name="Abandonedcartreport.php" hash="5c348aeec1c636b39ac037b5abc1875a"/><file name="Emailcapture.php" hash="accf0689467c5446e7605cad41e427b0"/><file name="Notifications.php" hash="dec4ef3882d5d11d738576787d05ec61"/></dir><file name="Ecjs.php" hash="1435cf65a3c33850e630364baa87a96e"/><file name="Modal.php" hash="42689930f0f039895e05a39ec4b5c917"/></dir><dir name="Helper"><file name="Data.php" hash="bd33bd2e7c3b6cf34cc28499a1f2eb7f"/></dir><dir name="Model"><dir name="Abandonedcart"><dir name="Api"><file name="V2.php" hash="c7b46e1feab677e41f4f9a3914e415fb"/></dir><file name="Api.php" hash="cb00914c4fc47c4fb9b07e0c7ebd5661"/></dir><dir name="Apiextension"><dir name="Api"><file name="V2.php" hash="ff5a5f68d92c8a790bb00282c30c1378"/></dir><file name="Api.php" hash="2e89fc5ae21b95aa584d3f5e4f47184e"/></dir><dir name="Click"><dir name="Api"><file name="V2.php" hash="510ae6b8032ff54b5f43d94f447f35e2"/></dir><file name="Api.php" hash="b22605c25dd1336188a62fbbecc177bf"/></dir><dir name="Log"><dir name="Api"><file name="V2.php" hash="ace9ca737ebefd47205886fdef504a05"/></dir><file name="Api.php" hash="2a2a52b419cb90c0648209964b961287"/></dir><dir name="Mysql4"><dir name="Abandonedcart"><file name="Collection.php" hash="9c172015f9a04da06167ebeaabb80e69"/></dir><dir name="Click"><file name="Collection.php" hash="41ff4606dff463ddac76e790a5d9d8d5"/></dir><dir name="Emailcapture"><file name="Collection.php" hash="4dbc86c599e6a390e1f8bde7752f09c2"/></dir><dir name="Log"><file name="Collection.php" hash="1765ae33eb74e9593d8266702cfe4160"/></dir><dir name="Session"><file name="Collection.php" hash="c095fdf0c54184df63ff6dd8636d779e"/></dir><dir name="Subscriberupdate"><file name="Collection.php" hash="1fd68314a80e93f416815273f29bf9f5"/></dir><file name="Abandonedcart.php" hash="446945e10c03137241f2d1eefd8668b6"/><file name="Apiextension.php" hash="4bbee7324ff4e6e4ca70587b023da6a0"/><file name="Click.php" hash="baabaf95e4d4f7f3fb1a2ac1c1965984"/><file name="Emailcapture.php" hash="b68ee210c3bcec8f2fccef7979b022b7"/><file name="Log.php" hash="e244d19b857ee9d03a7955a30d3f6cf3"/><file name="Session.php" hash="454a2c56529a0db4db3a5b8473952f78"/><file name="Subscriberupdate.php" hash="4957865b4aa8bbdda3a50484d7e49880"/></dir><file name="Abandonedcart.php" hash="2bd672054843917133e3ac7d941be42c"/><file name="Apiextension.php" hash="1a5964f749523d74c648d6609673fb08"/><file name="Click.php" hash="8c7e2d5eba20c24fdf3fcf516c772001"/><file name="Emailcapture.php" hash="4987ceda6dda7ca134736895e3cfed74"/><file name="Log.php" hash="577b2308bdbc531c867c67277d513371"/><file name="Observer.php" hash="375845e1ff616e7fa1736ab90335f989"/><file name="Session.php" hash="022a065dcbc893cec1eab6a89863c089"/><file name="Subscriber.php" hash="7addcff01d1c12e88baad9064a362f2c"/><file name="Subscriberupdate.php" hash="77df791c2d17772345f518ce3b4dab90"/></dir><dir name="controllers"><dir name="Adminhtml"><file name="AbandonedcartreportController.php" hash="e1a2c2db0c6cc8cc30f9fdf26636c1a0"/><file name="EmailcaptureController.php" hash="ad7c87ca689bc30eb135fc5d25ae21a2"/></dir><file name="CartController.php" hash="bab8c133100ae8bcd4ccdeb43329370a"/><file name="ConfigController.php" hash="7250d699110107b35fa004833dc3595e"/><file name="EmailController.php" hash="7b9e1711e0c964876b8afe46dde9266b"/><file name="TroubleshootingController.php" hash="8e9355a2c91ee3508620fc893aabe050"/></dir><dir name="etc"><file name="adminhtml.xml" hash="0e01a6415641c271f4eb3067419c7f0a"/><file name="api.xml" hash="9e261fb5bfd7fc24870a8f8af5c9b226"/><file name="config.xml" hash="627ecc2097446b6676d210928f34784e"/><file name="system.xml" hash="1a7f5f74a95b8679dc231e17a68e158c"/><file name="wsdl.xml" hash="69f888d1d5f3348ba09ad017e7a26f36"/></dir><dir name="sql"><dir name="listrak_remarketing_setup"><file name="mysql4-install-1.0.0.php" hash="9969325db69a8582cd2807343dc1c5bc"/><file name="mysql4-upgrade-1.0.0-1.0.1.php" hash="51d6494a61a2e32907cdc8eaf078274c"/><file name="mysql4-upgrade-1.0.8-1.0.9.php" hash="8c935ec4a7ff8816c1ab1df644c1edf3"/></dir></dir></dir></dir></target><target name="magedesign"><dir name="adminhtml"><dir name="default"><dir name="default"><dir name="layout"><file name="remarketing.xml" hash="44d7027ba447c4aaf0841d32d185ffde"/></dir></dir></dir></dir><dir name="frontend"><dir name="base"><dir name="default"><dir name="layout"><file name="remarketing.xml" hash="3fe421a6b7ea5ab184c8791971b41a6a"/></dir></dir></dir></dir></target><target name="mageetc"><dir name="modules"><file name="Listrak_Remarketing.xml" hash="1fc68edb656e220874e64cffaf7f2dbd"/></dir></target></contents>
23
  <compatible/>
24
  <dependencies/>
25
  </package>