Version Notes
TurnTo Admin Extension
Download this release
Release Info
Developer | TurnTo Networks |
Extension | socialcommerce_suite_by_turnto |
Version | 1.0.0 |
Comparing to | |
See all releases |
Version 1.0.0
- app/code/community/Turnto/Admin/Block/CatalogFeed.php +11 -0
- app/code/community/Turnto/Admin/Block/HistoricalFeed.php +11 -0
- app/code/community/Turnto/Admin/Block/Overview.php +11 -0
- app/code/community/Turnto/Admin/Block/ShowTabsAdminBlock.php +42 -0
- app/code/community/Turnto/Admin/Helper/Data.php +6 -0
- app/code/community/Turnto/Admin/controllers/AdminControllers/TurntoController.php +185 -0
- app/code/community/Turnto/Admin/controllers/IndexController.php +53 -0
- app/code/community/Turnto/Admin/etc/config.xml +79 -0
- app/design/adminhtml/default/default/template/turnto/catalog_feed_tab.phtml +51 -0
- app/design/adminhtml/default/default/template/turnto/historical_feed_tab.phtml +36 -0
- app/design/adminhtml/default/default/template/turnto/overview.phtml +37 -0
- app/etc/modules/Turnto_Admin.xml +10 -0
- package.xml +18 -0
app/code/community/Turnto/Admin/Block/CatalogFeed.php
ADDED
@@ -0,0 +1,11 @@
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
+
<?php
|
2 |
+
|
3 |
+
class Turnto_Admin_Block_CatalogFeed extends Mage_Adminhtml_Block_Template
|
4 |
+
{
|
5 |
+
|
6 |
+
public function __construct()
|
7 |
+
{
|
8 |
+
parent::__construct();
|
9 |
+
$this->setTemplate('turnto/catalog_feed_tab.phtml');
|
10 |
+
}
|
11 |
+
}
|
app/code/community/Turnto/Admin/Block/HistoricalFeed.php
ADDED
@@ -0,0 +1,11 @@
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
+
<?php
|
2 |
+
|
3 |
+
class Turnto_Admin_Block_HistoricalFeed extends Mage_Adminhtml_Block_Template
|
4 |
+
{
|
5 |
+
|
6 |
+
public function __construct()
|
7 |
+
{
|
8 |
+
parent::__construct();
|
9 |
+
$this->setTemplate('turnto/historical_feed_tab.phtml');
|
10 |
+
}
|
11 |
+
}
|
app/code/community/Turnto/Admin/Block/Overview.php
ADDED
@@ -0,0 +1,11 @@
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
+
<?php
|
2 |
+
|
3 |
+
class Turnto_Admin_Block_Overview extends Mage_Adminhtml_Block_Template
|
4 |
+
{
|
5 |
+
|
6 |
+
public function __construct()
|
7 |
+
{
|
8 |
+
parent::__construct();
|
9 |
+
$this->setTemplate('turnto/overview.phtml');
|
10 |
+
}
|
11 |
+
}
|
app/code/community/Turnto/Admin/Block/ShowTabsAdminBlock.php
ADDED
@@ -0,0 +1,42 @@
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
+
<?php
|
2 |
+
|
3 |
+
class Turnto_Admin_Block_ShowTabsAdminBlock extends Mage_Adminhtml_Block_Widget_Tabs
|
4 |
+
{
|
5 |
+
public function __construct()
|
6 |
+
{
|
7 |
+
parent::__construct();
|
8 |
+
$this->setId('turnto_tab_section_id');
|
9 |
+
$this->setTitle(Mage::helper('adminhelper1')->__('TurnTo'));
|
10 |
+
}
|
11 |
+
|
12 |
+
protected function _beforeToHtml()
|
13 |
+
{
|
14 |
+
$this->addTab('turnto_links_tab', array(
|
15 |
+
'label' => Mage::helper('adminhelper1')->__('Overview'),
|
16 |
+
'title' => Mage::helper('adminhelper1')->__('Overview'),
|
17 |
+
'content' => $this->getLayout()->createBlock("adminblock1/Overview")->toHtml(),
|
18 |
+
'active' => true
|
19 |
+
));
|
20 |
+
|
21 |
+
$this->addTab('turnto_catalog_feed_tab', array(
|
22 |
+
'label' => Mage::helper('adminhelper1')->__('Catalog Feed'),
|
23 |
+
'title' => Mage::helper('adminhelper1')->__('Catalog Feed'),
|
24 |
+
'content' => $this->getLayout()->createBlock("adminblock1/CatalogFeed")->toHtml(),
|
25 |
+
'active' => false
|
26 |
+
));
|
27 |
+
|
28 |
+
$this->addTab('turnto_hist_feed_tab', array(
|
29 |
+
'label' => Mage::helper('adminhelper1')->__('Historical Feed'),
|
30 |
+
'title' => Mage::helper('adminhelper1')->__('Historical Feed'),
|
31 |
+
'content' => $this->getLayout()->createBlock("adminblock1/HistoricalFeed")->toHtml(),
|
32 |
+
'active' => false
|
33 |
+
));
|
34 |
+
|
35 |
+
$headBlock = $this->getLayout()->getBlock('head');
|
36 |
+
$headBlock->addItem('css', 'calendar/calender-win2k-1.css');
|
37 |
+
$headBlock->addItem('js', 'calendar/calender.js');
|
38 |
+
$headBlock->addItem('js', 'calendar/calender-setup.js');
|
39 |
+
|
40 |
+
return parent::_beforeToHtml();
|
41 |
+
}
|
42 |
+
}
|
app/code/community/Turnto/Admin/Helper/Data.php
ADDED
@@ -0,0 +1,6 @@
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
+
<?php
|
2 |
+
|
3 |
+
class Turnto_Admin_Helper_Data extends Mage_Core_Helper_Data
|
4 |
+
{
|
5 |
+
|
6 |
+
}
|
app/code/community/Turnto/Admin/controllers/AdminControllers/TurntoController.php
ADDED
@@ -0,0 +1,185 @@
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
+
<?php
|
2 |
+
|
3 |
+
class Turnto_Admin_AdminControllers_TurntoController extends Mage_Adminhtml_Controller_Action
|
4 |
+
{
|
5 |
+
public function indexAction()
|
6 |
+
{
|
7 |
+
$this->loadLayout();
|
8 |
+
|
9 |
+
$this->_addLeft($this->getLayout()->createBlock('Turnto_Admin_Block_ShowTabsAdminBlock'));
|
10 |
+
|
11 |
+
$this->renderLayout();
|
12 |
+
}
|
13 |
+
|
14 |
+
public function redirectAction()
|
15 |
+
{
|
16 |
+
$this->_redirectUrl('http://www.turnto.com');
|
17 |
+
}
|
18 |
+
|
19 |
+
public function postAction()
|
20 |
+
{
|
21 |
+
$post = $this->getRequest()->getPost();
|
22 |
+
$catalogFeed = true;
|
23 |
+
|
24 |
+
try {
|
25 |
+
if (empty($post)) {
|
26 |
+
Mage::throwException($this->__('Invalid form data.'));
|
27 |
+
}
|
28 |
+
|
29 |
+
$path = Mage::getBaseDir('media') . DS . 'turnto/';
|
30 |
+
mkdir($path, 0755);
|
31 |
+
|
32 |
+
if($post['feed_type'] == 'historical'){
|
33 |
+
/* form processing */
|
34 |
+
$startDate = $post['start_date'];
|
35 |
+
|
36 |
+
if($startDate == null || $startDate == ""){
|
37 |
+
Mage::getSingleton('adminhtml/session')->addError("Start Date is required");
|
38 |
+
$this->_redirect('*/*/', array('active_tab' => 'turnto_hist_feed_tab'));
|
39 |
+
return;
|
40 |
+
}
|
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, '
|
48 |
+
.' customer_email as email, '
|
49 |
+
.' sales_flat_order_item.name as itemtitle, '
|
50 |
+
.' concat(\'http://magento.turntodev.com/index.php/\', url_path) as itemurl, '
|
51 |
+
.' item_id as itemlineid, '
|
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, '
|
59 |
+
.' sales_flat_order_item, '
|
60 |
+
.' sales_flat_order_address, '
|
61 |
+
.' catalog_product_flat_1 '
|
62 |
+
.'where sales_flat_order.entity_id = sales_flat_order_item.order_id '
|
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 |
+
|
70 |
+
fwrite($handle, "ORDERID\tORDERDATE\tEMAIL\tITEMTITLE\tITEMURL\tITEMLINEID\tZIP\tFIRSTNAME\tLASTNAME\tSKU\tPRICE\tITEMIMAGEURL");
|
71 |
+
fwrite($handle, "\n");
|
72 |
+
|
73 |
+
foreach($result as $row){
|
74 |
+
foreach($row as $column){
|
75 |
+
fwrite($handle, $column);
|
76 |
+
fwrite($handle, "\t");
|
77 |
+
}
|
78 |
+
|
79 |
+
fwrite($handle, "\n");
|
80 |
+
}
|
81 |
+
|
82 |
+
fclose($handle);
|
83 |
+
|
84 |
+
$message = $this->__('The historical feed was successfully generated. Click the "Download historical feed" link to download.');
|
85 |
+
$catalogFeed = false;
|
86 |
+
}
|
87 |
+
else{
|
88 |
+
/* form processing */
|
89 |
+
|
90 |
+
$resource = Mage::getSingleton('core/resource');
|
91 |
+
$readConnection = $resource->getConnection('core_read');
|
92 |
+
/*
|
93 |
+
$result = $readConnection->fetchAll(
|
94 |
+
'(select sku as SKU, '
|
95 |
+
.' concat((select concat(value, \'media/catalog/product\') from core_config_data where path = \'web/unsecure/base_url\'), small_image) as IMAGEURL, '
|
96 |
+
.' name as TITLE, '
|
97 |
+
.' price as PRICE, '
|
98 |
+
.' \'\' as CURRENCY, '
|
99 |
+
.' \'Y\' as ACTIVE, '
|
100 |
+
.' concat((select concat(value, \'index.php/\') from core_config_data where path = \'web/unsecure/base_url\'), url_path) as ITEMURL, '
|
101 |
+
.' (select ifnull(group_concat(category_id), \'\') from catalog_category_product where product_id = entity_id) as CATEGORY, '
|
102 |
+
.' \'\' as KEYWORDS, '
|
103 |
+
.' \'\' as REPLACEMENTSKU, '
|
104 |
+
.' \'Y\' as INSTOCK, '
|
105 |
+
.' \'\' as VIRTUALPARENTCODE, '
|
106 |
+
.' \'\' as CATEGORYPATHJSON, '
|
107 |
+
.' \'N\' as ISCATEGORY from catalog_product_flat_1) '
|
108 |
+
.'UNION ALL '
|
109 |
+
.'(select entity_id as SKU, '
|
110 |
+
.' \'\' as IMAGEURL, '
|
111 |
+
.' name as TITLE, '
|
112 |
+
.' \'\' as PRICE, '
|
113 |
+
.' \'\' as CURRENCY, '
|
114 |
+
.' \'Y\' as ACTIVE, '
|
115 |
+
.' concat((select concat(value, \'index.php/\') from core_config_data where path = \'web/unsecure/base_url\'), url_path) as ITEMURL, '
|
116 |
+
.' (select ifnull(parent_id, \'\') from catalog_category_entity where entity_id = ccfs.entity_id) as CATEGORY, '
|
117 |
+
.' \'\' as KEYWORDS, '
|
118 |
+
.' \'\' as REPLACEMENTSKU, '.'\'Y\' as INSTOCK, '
|
119 |
+
.' \'\' as VIRTUALPARENTCODE, '
|
120 |
+
.' \'\' as CATEGORYPATHJSON, '
|
121 |
+
.' \'Y\' as ISCATEGORY '
|
122 |
+
.'from catalog_category_flat_store_1 ccfs)');
|
123 |
+
*/
|
124 |
+
|
125 |
+
$result = $readConnection->fetchAll(
|
126 |
+
'(select sku as SKU, '
|
127 |
+
.' concat((select concat(value, \'media/catalog/product\') from core_config_data where path = \'web/unsecure/base_url\'), small_image) as IMAGEURL, '
|
128 |
+
.' name as TITLE, '
|
129 |
+
.' price as PRICE, '
|
130 |
+
.' \'\' as CURRENCY, '
|
131 |
+
.' \'Y\' as ACTIVE, '
|
132 |
+
.' concat((select concat(value, \'index.php/\') from core_config_data where path = \'web/unsecure/base_url\'), url_path) as ITEMURL, '
|
133 |
+
.' (select ifnull(group_concat(category_id), \'\') from catalog_category_product where product_id = entity_id and category_id <> \'1\') as CATEGORY, '
|
134 |
+
.' \'\' as KEYWORDS, '
|
135 |
+
.' \'\' as REPLACEMENTSKU, '
|
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, '
|
143 |
+
.' name as TITLE, '
|
144 |
+
.' \'\' as PRICE, '
|
145 |
+
.' \'\' as CURRENCY, '
|
146 |
+
.' \'Y\' as ACTIVE, '
|
147 |
+
.' concat((select concat(value, \'index.php/\') from core_config_data where path = \'web/unsecure/base_url\'), url_path) as ITEMURL, '
|
148 |
+
.' (select ifnull(parent_id, \'\') from catalog_category_entity where entity_id = ccfs.entity_id and parent_id <> \'1\') as CATEGORY, '
|
149 |
+
.' \'\' as KEYWORDS, '
|
150 |
+
.' \'\' as REPLACEMENTSKU, '.'\'Y\' as INSTOCK, '
|
151 |
+
.' \'\' as VIRTUALPARENTCODE, '
|
152 |
+
.' \'\' as CATEGORYPATHJSON, '
|
153 |
+
.' \'y\' as ISCATEGORY '
|
154 |
+
.'from catalog_category_flat_store_1 ccfs where entity_id <> \'1\')');
|
155 |
+
|
156 |
+
$handle = fopen($path . 'catfeed.csv', 'w');
|
157 |
+
|
158 |
+
fwrite($handle, "SKU\tIMAGEURL\tTITLE\tPRICE\tCURRENCY\tACTIVE\tITEMURL\tCATEGORY\tKEYWORDS\tREPLACEMENTSKU\tINSTOCK\tVIRTUALPARENTCODE\tCATEGORYPATHJSON\tISCATEGORY");
|
159 |
+
fwrite($handle, "\n");
|
160 |
+
|
161 |
+
foreach($result as $row){
|
162 |
+
foreach($row as $column){
|
163 |
+
fwrite($handle, $column);
|
164 |
+
fwrite($handle, "\t");
|
165 |
+
}
|
166 |
+
|
167 |
+
fwrite($handle, "\n");
|
168 |
+
}
|
169 |
+
|
170 |
+
fclose($handle);
|
171 |
+
|
172 |
+
$message = $this->__('The catalog feed was successfully generated. Click the "Download catalog feed" link to download.');
|
173 |
+
}
|
174 |
+
Mage::getSingleton('adminhtml/session')->addSuccess($message);
|
175 |
+
} catch (Exception $e) {
|
176 |
+
Mage::getSingleton('adminhtml/session')->addError($e->getMessage());
|
177 |
+
}
|
178 |
+
|
179 |
+
if($catalogFeed){
|
180 |
+
$this->_redirect('*/*/', array('active_tab' => 'turnto_catalog_feed_tab'));
|
181 |
+
}else{
|
182 |
+
$this->_redirectUrl(Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_WEB).'media/turnto/histfeed.csv');
|
183 |
+
}
|
184 |
+
}
|
185 |
+
}
|
app/code/community/Turnto/Admin/controllers/IndexController.php
ADDED
@@ -0,0 +1,53 @@
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
+
<?php
|
2 |
+
|
3 |
+
class Turnto_Admin_IndexController extends Mage_Core_Controller_Front_Action{
|
4 |
+
public function indexAction(){
|
5 |
+
$resource = Mage::getSingleton('core/resource');
|
6 |
+
$readConnection = $resource->getConnection('core_read');
|
7 |
+
|
8 |
+
$result = $readConnection->fetchAll(
|
9 |
+
'(select sku as SKU, '
|
10 |
+
.' concat((select concat(value, \'media/catalog/product\') from core_config_data where path = \'web/unsecure/base_url\'), small_image) as IMAGEURL, '
|
11 |
+
.' name as TITLE, '
|
12 |
+
.' price as PRICE, '
|
13 |
+
.' \'\' as CURRENCY, '
|
14 |
+
.' \'Y\' as ACTIVE, '
|
15 |
+
.' concat((select concat(value, \'index.php/\') from core_config_data where path = \'web/unsecure/base_url\'), url_path) as ITEMURL, '
|
16 |
+
.' (select ifnull(group_concat(category_id), \'\') from catalog_category_product where product_id = entity_id and category_id <> \'1\') as CATEGORY, '
|
17 |
+
.' \'\' as KEYWORDS, '
|
18 |
+
.' \'\' as REPLACEMENTSKU, '
|
19 |
+
.' \'Y\' as INSTOCK, '
|
20 |
+
.' \'\' as VIRTUALPARENTCODE, '
|
21 |
+
.' \'\' as CATEGORYPATHJSON, '
|
22 |
+
.' \'n\' as ISCATEGORY from catalog_product_flat_1) '
|
23 |
+
.'UNION ALL '
|
24 |
+
.'(select entity_id as SKU, '
|
25 |
+
.' \'\' as IMAGEURL, '
|
26 |
+
.' name as TITLE, '
|
27 |
+
.' \'\' as PRICE, '
|
28 |
+
.' \'\' as CURRENCY, '
|
29 |
+
.' \'Y\' as ACTIVE, '
|
30 |
+
.' concat((select concat(value, \'index.php/\') from core_config_data where path = \'web/unsecure/base_url\'), url_path) as ITEMURL, '
|
31 |
+
.' (select ifnull(parent_id, \'\') from catalog_category_entity where entity_id = ccfs.entity_id and parent_id <> \'1\') as CATEGORY, '
|
32 |
+
.' \'\' as KEYWORDS, '
|
33 |
+
.' \'\' as REPLACEMENTSKU, '.'\'Y\' as INSTOCK, '
|
34 |
+
.' \'\' as VIRTUALPARENTCODE, '
|
35 |
+
.' \'\' as CATEGORYPATHJSON, '
|
36 |
+
.' \'y\' as ISCATEGORY '
|
37 |
+
.'from catalog_category_flat_store_1 ccfs where entity_id <> \'1\')');
|
38 |
+
|
39 |
+
echo "SKU\tIMAGEURL\tTITLE\tPRICE\tCURRENCY\tACTIVE\tITEMURL\tCATEGORY\tKEYWORDS\tREPLACEMENTSKU\tINSTOCK\tVIRTUALPARENTCODE\tCATEGORYPATHJSON\tISCATEGORY";
|
40 |
+
echo "\n";
|
41 |
+
|
42 |
+
foreach($result as $row){
|
43 |
+
foreach($row as $column){
|
44 |
+
echo $column;
|
45 |
+
echo "\t";
|
46 |
+
}
|
47 |
+
|
48 |
+
echo "\n";
|
49 |
+
}
|
50 |
+
}
|
51 |
+
}
|
52 |
+
|
53 |
+
|
app/code/community/Turnto/Admin/etc/config.xml
ADDED
@@ -0,0 +1,79 @@
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
+
<?xml version="1.0"?>
|
2 |
+
|
3 |
+
<config>
|
4 |
+
<modules>
|
5 |
+
<Turnto_Admin>
|
6 |
+
<version>0.1.0</version>
|
7 |
+
</Turnto_Admin>
|
8 |
+
</modules>
|
9 |
+
|
10 |
+
<global>
|
11 |
+
<blocks>
|
12 |
+
<adminblock1>
|
13 |
+
<class>Turnto_Admin_Block</class>
|
14 |
+
</adminblock1>
|
15 |
+
</blocks>
|
16 |
+
<helpers>
|
17 |
+
<adminhelper1>
|
18 |
+
<class>Turnto_Admin_Helper</class>
|
19 |
+
</adminhelper1>
|
20 |
+
</helpers>
|
21 |
+
</global>
|
22 |
+
|
23 |
+
<frontend>
|
24 |
+
<routers>
|
25 |
+
<turntocatfeed>
|
26 |
+
<use>standard</use>
|
27 |
+
<args>
|
28 |
+
<module>Turnto_Admin</module>
|
29 |
+
<frontName>turntocatalogfeed</frontName>
|
30 |
+
</args>
|
31 |
+
</turntocatfeed>
|
32 |
+
</routers>
|
33 |
+
</frontend>
|
34 |
+
|
35 |
+
<admin>
|
36 |
+
<routers>
|
37 |
+
<samplerouter1>
|
38 |
+
<use>admin</use>
|
39 |
+
<args>
|
40 |
+
<module>Turnto_Admin_AdminControllers</module>
|
41 |
+
<frontName>adminturnto</frontName>
|
42 |
+
|
43 |
+
<modules>
|
44 |
+
<sintax after="Turnto_Admin_AdminControllers">Mage_Adminhtml</sintax>
|
45 |
+
</modules>
|
46 |
+
</args>
|
47 |
+
</samplerouter1>
|
48 |
+
</routers>
|
49 |
+
</admin>
|
50 |
+
|
51 |
+
<adminhtml>
|
52 |
+
<menu>
|
53 |
+
<menu1 translate="title" module="adminhelper1">
|
54 |
+
<title>TurnTo</title>
|
55 |
+
<sort_order>200</sort_order>
|
56 |
+
<children>
|
57 |
+
<!-- Note the misleading "module" attribute.
|
58 |
+
It actualy refers to one of the declared helpers -->
|
59 |
+
<item1 translate="title" module="adminhelper1">
|
60 |
+
<title>Integration</title>
|
61 |
+
<action>samplerouter1/Turnto</action>
|
62 |
+
<sort_order>1</sort_order>
|
63 |
+
</item1>
|
64 |
+
<item2 translate="title" module="adminhelper1">
|
65 |
+
<title>Moderation</title>
|
66 |
+
<action>samplerouter1/Turnto/redirect</action>
|
67 |
+
<sort_order>2</sort_order>
|
68 |
+
</item2>
|
69 |
+
<item3 translate="title" module="adminhelper1">
|
70 |
+
<title>Reporting</title>
|
71 |
+
<action>samplerouter1/Turnto/redirect</action>
|
72 |
+
<sort_order>3</sort_order>
|
73 |
+
</item3>
|
74 |
+
</children>
|
75 |
+
</menu1>
|
76 |
+
</menu>
|
77 |
+
</adminhtml>
|
78 |
+
|
79 |
+
</config>
|
app/design/adminhtml/default/default/template/turnto/catalog_feed_tab.phtml
ADDED
@@ -0,0 +1,51 @@
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
+
<h4>Catalog Feed</h4>
|
2 |
+
<p style="width:650px">Go to your Settings in TurnTo Management area and enter:
|
3 |
+
<br>
|
4 |
+
<i><?php echo Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_LINK) . 'turntocatalogfeed';?></i>
|
5 |
+
<br>
|
6 |
+
in the <b>Catalog Feed Url:</b> input field.
|
7 |
+
<br>
|
8 |
+
<br>
|
9 |
+
This will set up the automation of the catalog feed in order to keep you products up to date. </p>
|
10 |
+
<br>
|
11 |
+
<br>
|
12 |
+
<br>
|
13 |
+
To manually create a catalog feed press Generate to build a catalog feed. This feed can be downloaded and uploaded via the TurnTo management form.
|
14 |
+
|
15 |
+
<br>
|
16 |
+
<form id="cat_feed_form" name="cat_feed_form" method="post" action="<?php echo $this->getUrl('*/*/post') ?>">
|
17 |
+
<input name="form_key" type="hidden" value="<?php echo Mage::getSingleton('core/session')->getFormKey() ?>" />
|
18 |
+
<input name="feed_type" type="hidden" value="catalog" />
|
19 |
+
<table>
|
20 |
+
<!--
|
21 |
+
<tr>
|
22 |
+
<td>Site Key:</td>
|
23 |
+
<td><input id="siteKey" name="siteKey" type="text" /></td>
|
24 |
+
</tr>
|
25 |
+
<tr>
|
26 |
+
<td>Auth Key:</td>
|
27 |
+
<td><input id="authKey" name="authKey" type="text" /></td>
|
28 |
+
</tr>
|
29 |
+
-->
|
30 |
+
<tr>
|
31 |
+
<td></td>
|
32 |
+
<td align="right">
|
33 |
+
|
34 |
+
<input id="submit" name="submit" value="Generate" type="submit" /></td>
|
35 |
+
|
36 |
+
</tr>
|
37 |
+
</table>
|
38 |
+
|
39 |
+
|
40 |
+
|
41 |
+
|
42 |
+
|
43 |
+
<?php
|
44 |
+
$file = Mage::getBaseDir('media') . DS . 'turnto/catfeed.csv';
|
45 |
+
|
46 |
+
if(file_exists($file)){
|
47 |
+
echo '<br /><br /><a href="/media/turnto/catfeed.csv">Download catalog feed</a> - created '.date('m/d/Y G:i',filectime($file));
|
48 |
+
}
|
49 |
+
?>
|
50 |
+
</form>
|
51 |
+
|
app/design/adminhtml/default/default/template/turnto/historical_feed_tab.phtml
ADDED
@@ -0,0 +1,36 @@
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
+
<h4>Historical Feed</h4>
|
2 |
+
<p style="width:600px">A one-time historical batch feed of past customers for populating TurnTo products in a text (tab delimited) format. Feeds contain the information about your site's users and their activities on your site. Upload your magento generated historical feed in your TurnTo feed upload tab in the TurnTo settings area.</p>
|
3 |
+
<br />
|
4 |
+
<b>Press Generate to build a historical feed</b>
|
5 |
+
|
6 |
+
<form id="hist_feed_form" name="hist_feed_form" method="post" action="<?php echo $this->getUrl('*/*/post') ?>">
|
7 |
+
<input name="form_key" type="hidden" value="<?php echo Mage::getSingleton('core/session')->getFormKey() ?>" />
|
8 |
+
<input name="feed_type" type="hidden" value="historical" />
|
9 |
+
<table>
|
10 |
+
<tr>
|
11 |
+
<td>From Date:</td>
|
12 |
+
<td>
|
13 |
+
<input name="start_date" id="start_date" readonly="readonly" class="input-text" type="text" />
|
14 |
+
<img title="Select Date" id="start_date_trig" class="v-middle" alt="" src="<?php echo $this->getSkinUrl() . '../default/images/fam_calendar.gif' ?>">
|
15 |
+
</td>
|
16 |
+
</tr>
|
17 |
+
<tr><td colspan="2"> </td></tr>
|
18 |
+
<tr>
|
19 |
+
<td></td>
|
20 |
+
<td align="right"><input type="submit" name="submit" value="Generate" /></td>
|
21 |
+
</tr>
|
22 |
+
</table>
|
23 |
+
</form>
|
24 |
+
|
25 |
+
<script type="text/javascript">
|
26 |
+
//<![CDATA[
|
27 |
+
Calendar.setup({
|
28 |
+
inputField: "start_date",
|
29 |
+
ifFormat: "%m/%e/%Y",
|
30 |
+
showsTime: false,
|
31 |
+
button: "start_date_trig",
|
32 |
+
align: "Bl",
|
33 |
+
singleClick: true
|
34 |
+
});
|
35 |
+
//]]>
|
36 |
+
</script>
|
app/design/adminhtml/default/default/template/turnto/overview.phtml
ADDED
@@ -0,0 +1,37 @@
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
+
<h4>Overview</h4>
|
2 |
+
<p style="margin-top:10px;width:600px">
|
3 |
+
|
4 |
+
|
5 |
+
To install the Social Commerce Suite, first
|
6 |
+
contact TurnTo to set up an account and get a license key for the cloud-based services,
|
7 |
+
then setup your feeds and install the needed Javascript. TurnTo's support team will
|
8 |
+
be happy to guide you through the steps.
|
9 |
+
<br>
|
10 |
+
<br>
|
11 |
+
A link to detailed documentation is below.
|
12 |
+
|
13 |
+
|
14 |
+
|
15 |
+
</p>
|
16 |
+
<p style="margin-top:20px;width:600px">
|
17 |
+
<b>To set up an account with Turnto, contact our Sales team via Email at
|
18 |
+
<a href="mailto:contact@turnto.com">contact@turnto.com</a>
|
19 |
+
</b>
|
20 |
+
</p>
|
21 |
+
<h4 style="margin-top:20px">Feeds</h4>
|
22 |
+
<p style="margin-top:10px;width:650px">
|
23 |
+
1) Catalog Feed<br />
|
24 |
+
Go to your Settings in TurnTo Management area on the TurnTo site and enter <i><?php echo Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_LINK) . 'turntocatalogfeed'; ?></i> in the <b>Catalog Feed Url</b>: input field.
|
25 |
+
This will set up the automation of the catalog feed in order to keep you products up to date.
|
26 |
+
<br /><br />
|
27 |
+
2) Historical Batch Feed<br />
|
28 |
+
A one-time historical batch feed of past customers for populating TurnTo products in a text (tab delimited) format. Feeds contain the information about your site's users and their activities on your site. Upload your magento generated historical feed in your TurnTo feed upload tab in the TurnTo settings area on the turnto website.<br />
|
29 |
+
</p>
|
30 |
+
<h4 style="margin-top:20px">Links</h4><p style="width:600px">Links to helpful information about TurnTo<br /><br />
|
31 |
+
<a href="http://www.turnto.com/docs/home/magentoconnectaccess" alt="TurnTo Documentation">TurnTo Documentation</a>
|
32 |
+
<br /><br />
|
33 |
+
<a href="http://www.turnto.com" alt="Moderation">TurnTo Moderation</a>
|
34 |
+
<br /><br />
|
35 |
+
<a href="http://www.turnto.com" alt="Reports">TurnTo Reports</a>
|
36 |
+
<br /><br />
|
37 |
+
<a href="http://www.turnto.com" alt="Settings">TurnTo Settings</a></p>
|
app/etc/modules/Turnto_Admin.xml
ADDED
@@ -0,0 +1,10 @@
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
+
<?xml version="1.0"?>
|
2 |
+
|
3 |
+
<config>
|
4 |
+
<modules>
|
5 |
+
<Turnto_Admin>
|
6 |
+
<active>true</active>
|
7 |
+
<codePool>community</codePool>
|
8 |
+
</Turnto_Admin>
|
9 |
+
</modules>
|
10 |
+
</config>
|
package.xml
ADDED
@@ -0,0 +1,18 @@
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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>
|
8 |
+
<extends/>
|
9 |
+
<summary>Connect your shoppers to your customers</summary>
|
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>
|