socialcommerce_suite_by_turnto - Version 1.0.3

Version Notes

TurnTo Admin Extension

Download this release

Release Info

Developer TurnTo Networks
Extension socialcommerce_suite_by_turnto
Version 1.0.3
Comparing to
See all releases


Code changes from version 1.0.0 to 1.0.3

Files changed (2) hide show
  1. app/code/community/Turnto/Admin/controllers/AdminControllers/TurntoController.php +28 -4
  2. package.xml +4 -4
app/code/community/Turnto/Admin/controllers/AdminControllers/TurntoController.php CHANGED
@@ -41,7 +41,7 @@ class Turnto_Admin_AdminControllers_TurntoController extends Mage_Adminhtml_Cont
41
 
42
  $resource = Mage::getSingleton('core/resource');
43
  $readConnection = $resource->getConnection('core_read');
44
- $result = $readConnection->fetchAll(
45
  'select '
46
  .' sales_flat_order.entity_id as orderid, '
47
  .' sales_flat_order_item.created_at as orderdate, '
@@ -52,7 +52,7 @@ class Turnto_Admin_AdminControllers_TurntoController extends Mage_Adminhtml_Cont
52
  .' postcode as zip, '
53
  .' customer_firstname as firstname, '
54
  .' customer_lastname as lastname, '
55
- .' sales_flat_order_item.sku as sku, '
56
  .' grand_total as price, '
57
  .' concat((select concat(value,\'/media/catalog/product/\') from core_config_data where path = \'web/unsecure/base_url\'), small_image) as itemimageurl '
58
  .'from sales_flat_order, '
@@ -63,7 +63,31 @@ class Turnto_Admin_AdminControllers_TurntoController extends Mage_Adminhtml_Cont
63
  .' and sales_flat_order.entity_id = sales_flat_order_address.entity_id '
64
  .' and sales_flat_order.entity_id = catalog_product_flat_1.entity_id'
65
  .' and sales_flat_order_item.created_at > str_to_date(\''.$startDate.'\', \'%m/%d/%Y\')');
66
-
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
67
 
68
  $handle = fopen($path . 'histfeed.csv', 'w');
69
 
@@ -136,7 +160,7 @@ class Turnto_Admin_AdminControllers_TurntoController extends Mage_Adminhtml_Cont
136
  .' \'Y\' as INSTOCK, '
137
  .' \'\' as VIRTUALPARENTCODE, '
138
  .' \'\' as CATEGORYPATHJSON, '
139
- .' \'n\' as ISCATEGORY from catalog_product_flat_1) '
140
  .'UNION ALL '
141
  .'(select entity_id as SKU, '
142
  .' \'\' as IMAGEURL, '
41
 
42
  $resource = Mage::getSingleton('core/resource');
43
  $readConnection = $resource->getConnection('core_read');
44
+ /*$result = $readConnection->fetchAll(
45
  'select '
46
  .' sales_flat_order.entity_id as orderid, '
47
  .' sales_flat_order_item.created_at as orderdate, '
52
  .' postcode as zip, '
53
  .' customer_firstname as firstname, '
54
  .' customer_lastname as lastname, '
55
+ .' ifnull(parent.sku, sales_flat_order_item.sku) as sku, '
56
  .' grand_total as price, '
57
  .' concat((select concat(value,\'/media/catalog/product/\') from core_config_data where path = \'web/unsecure/base_url\'), small_image) as itemimageurl '
58
  .'from sales_flat_order, '
63
  .' and sales_flat_order.entity_id = sales_flat_order_address.entity_id '
64
  .' and sales_flat_order.entity_id = catalog_product_flat_1.entity_id'
65
  .' and sales_flat_order_item.created_at > str_to_date(\''.$startDate.'\', \'%m/%d/%Y\')');
66
+ */
67
+
68
+ $result = $readConnection->fetchAll(
69
+ 'select sales_flat_order.entity_id as orderid, '
70
+ .'sales_flat_order_item.created_at as orderdate, '
71
+ .'customer_email as email, '
72
+ .'ifnull(parent.name, sales_flat_order_item.name) as itemtitle, '
73
+ .'concat(\'http://magento.turntodev.com/index.php/\', ifnull(parent.url_path, catalog_product_flat_1.url_path)) as itemurl, '
74
+ .'item_id as itemlineid, '
75
+ .'postcode as zip, '
76
+ .'customer_firstname as firstname, '
77
+ .'customer_lastname as lastname, '
78
+ .'ifnull(parent.sku, sales_flat_order_item.sku) as sku, '
79
+ .'grand_total as price, '
80
+ .'concat((select concat(value,\'/media/catalog/product/\') from core_config_data where path = \'web/unsecure/base_url\'), ifnull(parent.small_image, catalog_product_flat_1.small_image)) as itemimageurl '
81
+ .'from sales_flat_order,'
82
+ .'sales_flat_order_item, '
83
+ .'sales_flat_order_address, '
84
+ .'catalog_product_flat_1 '
85
+ .'left join catalog_product_super_link on catalog_product_flat_1.entity_id = catalog_product_super_link.product_id '
86
+ .'left join catalog_product_flat_1 as parent on catalog_product_super_link.parent_id = parent.entity_id '
87
+ .'where sales_flat_order.entity_id = sales_flat_order_item.order_id '
88
+ .'and sales_flat_order.entity_id = sales_flat_order_address.entity_id '
89
+ .'and sales_flat_order.entity_id = catalog_product_flat_1.entity_id '
90
+ .'and sales_flat_order_item.created_at > str_to_date(\''.$startDate.'\', \'%m/%d/%Y\')');
91
 
92
  $handle = fopen($path . 'histfeed.csv', 'w');
93
 
160
  .' \'Y\' as INSTOCK, '
161
  .' \'\' as VIRTUALPARENTCODE, '
162
  .' \'\' as CATEGORYPATHJSON, '
163
+ .' \'n\' as ISCATEGORY from catalog_product_flat_1 where not exists (select 1 from catalog_product_super_link where product_id = catalog_product_flat_1.entity_id)) '
164
  .'UNION ALL '
165
  .'(select entity_id as SKU, '
166
  .' \'\' as IMAGEURL, '
package.xml CHANGED
@@ -1,7 +1,7 @@
1
  <?xml version="1.0"?>
2
  <package>
3
  <name>socialcommerce_suite_by_turnto</name>
4
- <version>1.0.0</version>
5
  <stability>stable</stability>
6
  <license uri="http://www.turntonetworks.com/terms-of-use">TurnTo Networks</license>
7
  <channel>community</channel>
@@ -10,9 +10,9 @@
10
  <description>The TurnTo Social Commerce Suite helps you put the good will you have earned from your customers to work by opening direct communications between your shoppers and your past customers.</description>
11
  <notes>TurnTo Admin Extension</notes>
12
  <authors><author><name>TurnTo Networks</name><user>TurnTo</user><email>contact@turnto.com</email></author></authors>
13
- <date>2011-11-08</date>
14
- <time>22:38:31</time>
15
- <contents><target name="magecommunity"><dir name="Turnto"><dir name="Admin"><dir name="Block"><file name="CatalogFeed.php" hash="f974cfdc687bf5edb3fdccb879547200"/><file name="HistoricalFeed.php" hash="a4d2b29c6d8bb2ed59aa884e02abc23b"/><file name="Overview.php" hash="51c8ed09153f1dc3b3d02aa0ab83f195"/><file name="ShowTabsAdminBlock.php" hash="d904239a91cc367e93c138eff3e2b074"/></dir><dir name="Helper"><file name="Data.php" hash="78a1e318ccf05caac4ca7a8c2bd74e43"/></dir><dir name="controllers"><dir name="AdminControllers"><file name="TurntoController.php" hash="4f17918cc8f8418c0f5a4312fd508462"/></dir><file name="IndexController.php" hash="b4c2d1ac31f764751fea770959b6f8af"/></dir><dir name="etc"><file name="config.xml" hash="27ba1dd7b8e34b0587ac647142aee2c7"/></dir></dir></dir></target><target name="mageetc"><dir><dir name="modules"><file name="Turnto_Admin.xml" hash="0932b63ab068e1e8b12ff7b997ae83ee"/></dir></dir></target><target name="magedesign"><dir><dir name="adminhtml"><dir name="default"><dir name="default"><dir name="template"><dir name="turnto"><file name="catalog_feed_tab.phtml" hash="561524e82d8df1d57ecd4b4469890034"/><file name="historical_feed_tab.phtml" hash="3681dee79c6a553d95035c7a2a9d9507"/><file name="overview.phtml" hash="4cc20b32c3b0cd36cd349f0be44e4615"/></dir></dir></dir></dir></dir></dir></target></contents>
16
  <compatible/>
17
  <dependencies><required><php><min>5.0.0</min><max>6.0.0</max></php></required></dependencies>
18
  </package>
1
  <?xml version="1.0"?>
2
  <package>
3
  <name>socialcommerce_suite_by_turnto</name>
4
+ <version>1.0.3</version>
5
  <stability>stable</stability>
6
  <license uri="http://www.turntonetworks.com/terms-of-use">TurnTo Networks</license>
7
  <channel>community</channel>
10
  <description>The TurnTo Social Commerce Suite helps you put the good will you have earned from your customers to work by opening direct communications between your shoppers and your past customers.</description>
11
  <notes>TurnTo Admin Extension</notes>
12
  <authors><author><name>TurnTo Networks</name><user>TurnTo</user><email>contact@turnto.com</email></author></authors>
13
+ <date>2012-02-26</date>
14
+ <time>17:44:21</time>
15
+ <contents><target name="magecommunity"><dir name="Turnto"><dir name="Admin"><dir name="Block"><file name="CatalogFeed.php" hash="f974cfdc687bf5edb3fdccb879547200"/><file name="HistoricalFeed.php" hash="a4d2b29c6d8bb2ed59aa884e02abc23b"/><file name="Overview.php" hash="51c8ed09153f1dc3b3d02aa0ab83f195"/><file name="ShowTabsAdminBlock.php" hash="d904239a91cc367e93c138eff3e2b074"/></dir><dir name="Helper"><file name="Data.php" hash="78a1e318ccf05caac4ca7a8c2bd74e43"/></dir><dir name="controllers"><dir name="AdminControllers"><file name="TurntoController.php" hash="82006059254b836345edca2805be4135"/></dir><file name="IndexController.php" hash="b4c2d1ac31f764751fea770959b6f8af"/></dir><dir name="etc"><file name="config.xml" hash="27ba1dd7b8e34b0587ac647142aee2c7"/></dir></dir></dir></target><target name="mageetc"><dir><dir name="modules"><file name="Turnto_Admin.xml" hash="0932b63ab068e1e8b12ff7b997ae83ee"/></dir></dir></target><target name="magedesign"><dir><dir name="adminhtml"><dir name="default"><dir name="default"><dir name="template"><dir name="turnto"><file name="catalog_feed_tab.phtml" hash="561524e82d8df1d57ecd4b4469890034"/><file name="historical_feed_tab.phtml" hash="3681dee79c6a553d95035c7a2a9d9507"/><file name="overview.phtml" hash="4cc20b32c3b0cd36cd349f0be44e4615"/></dir></dir></dir></dir></dir></dir></target></contents>
16
  <compatible/>
17
  <dependencies><required><php><min>5.0.0</min><max>6.0.0</max></php></required></dependencies>
18
  </package>