stockinthechannel2012 - Version 2.2.2

Version Notes

Version 2.2.2:
* Filters with Y / N not working are fixed
* Cron automated import reconfigured for better timing structure.

Download this release

Release Info

Developer stockinchannel
Extension stockinthechannel2012
Version 2.2.2
Comparing to
See all releases


Code changes from version 2.2.1 to 2.2.2

Files changed (6) hide show
  1. app/code/local/Bintime/Sinchimport/Model/Resource/Mysql4/Layer/Filter/Feature.php +6 -13
  2. app/code/local/Bintime/Sinchimport/Model/Sinch.php +17 -16
  3. app/code/local/Bintime/Sinchimport/etc/config.xml +3 -4
  4. app/code/local/Bintime/Sinchimport/sql/sinchimport_setup/filter_sinch_products_s.sql +60 -61
  5. app/code/local/Bintime/Sinchimport/sql/sinchimport_setup/mysql4-upgrade-3.0.8-3.1.0.php +234 -0
  6. package.xml +7 -8
app/code/local/Bintime/Sinchimport/Model/Resource/Mysql4/Layer/Filter/Feature.php CHANGED
@@ -86,17 +86,8 @@ class Bintime_Sinchimport_Model_Resource_Mysql4_Layer_Filter_Feature extends Mag
86
  $truncateSql = "TRUNCATE TABLE {$resultTable}";
87
  $connection->exec($truncateSql);
88
 
89
- $featuresTable = $this->_getTableName('FilterListOfFeatures');
90
- $sql = "TRUNCATE TABLE `$featuresTable`";
91
- $connection->exec($sql);
92
-
93
  $feature = $filter->getAttributeModel();
94
  if (!isset($feature['limit_direction']) || ($feature['limit_direction'] != 1 && $feature['limit_direction'] != 2)) {
95
- if (!is_null($value)) {
96
- $sql = "INSERT INTO `$featuresTable` (category_feature_id, feature_value) VALUES (?)";
97
- $sql = $connection->quoteInto($sql, array($cfid, $value));
98
- $connection->exec($sql);
99
- }
100
  $params = 'null, null';
101
  } else {
102
  $bounds = explode(',', $value);
@@ -106,7 +97,7 @@ class Bintime_Sinchimport_Model_Resource_Mysql4_Layer_Filter_Feature extends Mag
106
  $params .= $bounds[1] != '-' ? (int)$bounds[1] : 'null';
107
  }
108
  $tablePrefix = (string)Mage::app()->getConfig()->getTablePrefix();
109
- $result = $connection->raw_query("CALL ".$this->_getTableName('filter_sinch_products_s')."($cfid, $catId,0, $cfid, $params, '$tablePrefix')");
110
  Varien_Profiler::stop(__METHOD__);
111
  return $resultTable;
112
  }
@@ -125,13 +116,15 @@ class Bintime_Sinchimport_Model_Resource_Mysql4_Layer_Filter_Feature extends Mag
125
  $searchTable = $this->_prepareSearch($filter, $value);
126
  self::$lastResultTable = $searchTable;
127
 
128
- $collection = $filter->getLayer()->getProductCollection();
129
  $feature = $filter->getAttributeModel();
130
- $connection = $this->_getReadAdapter();
 
 
 
131
 
132
  $collection->getSelect()->join(
133
  $searchTable,
134
- "{$searchTable}.entity_id = e.entity_id AND {$searchTable}.feature_value = '$value'",
135
  array()
136
  );
137
 
86
  $truncateSql = "TRUNCATE TABLE {$resultTable}";
87
  $connection->exec($truncateSql);
88
 
 
 
 
 
89
  $feature = $filter->getAttributeModel();
90
  if (!isset($feature['limit_direction']) || ($feature['limit_direction'] != 1 && $feature['limit_direction'] != 2)) {
 
 
 
 
 
91
  $params = 'null, null';
92
  } else {
93
  $bounds = explode(',', $value);
97
  $params .= $bounds[1] != '-' ? (int)$bounds[1] : 'null';
98
  }
99
  $tablePrefix = (string)Mage::app()->getConfig()->getTablePrefix();
100
+ $result = $connection->raw_query("CALL ".$this->_getTableName('filter_sinch_products_s')."($cfid, $catId,0, $cfid, $params ,'$tablePrefix')");
101
  Varien_Profiler::stop(__METHOD__);
102
  return $resultTable;
103
  }
116
  $searchTable = $this->_prepareSearch($filter, $value);
117
  self::$lastResultTable = $searchTable;
118
 
 
119
  $feature = $filter->getAttributeModel();
120
+ $featureId = $feature['feature_id'];
121
+ $featureName = $feature['feature_name'];
122
+
123
+ $collection = $filter->getLayer()->getProductCollection();
124
 
125
  $collection->getSelect()->join(
126
  $searchTable,
127
+ "{$searchTable}.entity_id = e.entity_id AND {$searchTable}.feature_value = '$value' AND {$searchTable}.feature_name = '{$featureName}'",
128
  array()
129
  );
130
 
app/code/local/Bintime/Sinchimport/Model/Sinch.php CHANGED
@@ -265,14 +265,8 @@ class Bintime_Sinchimport_Model_Sinch extends Mage_Core_Model_Abstract
265
  //$import->AddPriceRules();
266
  //$import->ApplyCustomerGroupPrice();
267
 
268
- if (file_exists($this->varDir . FILE_PRICE_RULES)) {
269
- $ftpCred = Mage::getStoreConfig('sinchimport_root/sinch_ftp');
270
- Mage::dispatchEvent('sinch_pricerules_import_ftp', array(
271
- 'ftp_host' => $ftpCred["ftp_server"],
272
- 'ftp_username' => $ftpCred["login"],
273
- 'ftp_password' => $ftpCred["password"]
274
- ));
275
- }
276
 
277
  Mage::log("Finish Sinch import", null, $this->_logFile);
278
  echo "Finish Sinch import\n";
@@ -306,6 +300,9 @@ class Bintime_Sinchimport_Model_Sinch extends Mage_Core_Model_Abstract
306
 
307
  $q = "SELECT RELEASE_LOCK('sinchimport')";
308
  $this->db_do($q);
 
 
 
309
  } catch (Exception $e) {
310
  $this->set_import_error_reporting_message($e);
311
  }
@@ -5713,6 +5710,12 @@ STP DELETE*/
5713
  $link_type[$row['code']] = $row['link_type_id'];
5714
  }
5715
 
 
 
 
 
 
 
5716
  $result = $this->db_do("
5717
  INSERT INTO " . Mage::getSingleton('core/resource')->getTableName('catalog_product_link') . " (
5718
  product_id,
@@ -7746,6 +7749,9 @@ STP DELETE*/
7746
  $this->db_do("UPDATE " . Mage::getSingleton('core/resource')->getTableName('catalog_product_entity_varchar') . "
7747
  SET value = ''
7748
  WHERE entity_type_id=" . $this->_getProductEntityTypeId() . " AND attribute_id=" . $this->_getProductAttributeId('url_key'));
 
 
 
7749
  exec(PHP_RUN_STRING . ' ' . $this->shellDir . 'indexer.php reindexall');
7750
  }
7751
 
@@ -7890,14 +7896,6 @@ STP DELETE*/
7890
  //$import->AddPriceRules();
7891
  //$import->ApplyCustomerGroupPrice();
7892
 
7893
- $ftpCred = Mage::getStoreConfig('sinchimport_root/sinch_ftp');
7894
- Mage::dispatchEvent('sinch_pricerules_import_ftp', array(
7895
- 'ftp_host' => $ftpCred["ftp_server"],
7896
- 'ftp_username' => $ftpCred["login"],
7897
- 'ftp_password' => $ftpCred["password"]
7898
- ));
7899
-
7900
-
7901
  Mage::log("Finish Stock & Price Sinch import", null, $this->_logFile);
7902
  echo "Finish Stock & Price Sinch import\n";
7903
 
@@ -7912,6 +7910,9 @@ STP DELETE*/
7912
 
7913
  $q = "SELECT RELEASE_LOCK('sinchimport')";
7914
  $this->db_do($q);
 
 
 
7915
  } catch (Exception $e) {
7916
  $this->set_import_error_reporting_message($e);
7917
  }
265
  //$import->AddPriceRules();
266
  //$import->ApplyCustomerGroupPrice();
267
 
268
+ $ftpCred = Mage::getStoreConfig('sinchimport_root/sinch_ftp');
269
+ Mage::dispatchEvent('sinch_import_after', array('ftp_cred' => $ftpCred));
 
 
 
 
 
 
270
 
271
  Mage::log("Finish Sinch import", null, $this->_logFile);
272
  echo "Finish Sinch import\n";
300
 
301
  $q = "SELECT RELEASE_LOCK('sinchimport')";
302
  $this->db_do($q);
303
+
304
+ $ftpCred = Mage::getStoreConfig('sinchimport_root/sinch_ftp');
305
+ Mage::dispatchEvent('sinch_import_after', array('ftp_cred' => $ftpCred));
306
  } catch (Exception $e) {
307
  $this->set_import_error_reporting_message($e);
308
  }
5710
  $link_type[$row['code']] = $row['link_type_id'];
5711
  }
5712
 
5713
+ // delete old data
5714
+ $this->db_do("SET FOREIGN_KEY_CHECKS=0");
5715
+ $this->db_do("TRUNCATE " . Mage::getSingleton('core/resource')->getTableName('catalog_product_link'));
5716
+ $this->db_do("TRUNCATE " . Mage::getSingleton('core/resource')->getTableName('catalog_product_link_attribute_int'));
5717
+ $this->db_do("SET FOREIGN_KEY_CHECKS=1");
5718
+
5719
  $result = $this->db_do("
5720
  INSERT INTO " . Mage::getSingleton('core/resource')->getTableName('catalog_product_link') . " (
5721
  product_id,
7749
  $this->db_do("UPDATE " . Mage::getSingleton('core/resource')->getTableName('catalog_product_entity_varchar') . "
7750
  SET value = ''
7751
  WHERE entity_type_id=" . $this->_getProductEntityTypeId() . " AND attribute_id=" . $this->_getProductAttributeId('url_key'));
7752
+
7753
+ Mage::dispatchEvent('sinch_import_url_rewrite_before');
7754
+
7755
  exec(PHP_RUN_STRING . ' ' . $this->shellDir . 'indexer.php reindexall');
7756
  }
7757
 
7896
  //$import->AddPriceRules();
7897
  //$import->ApplyCustomerGroupPrice();
7898
 
 
 
 
 
 
 
 
 
7899
  Mage::log("Finish Stock & Price Sinch import", null, $this->_logFile);
7900
  echo "Finish Stock & Price Sinch import\n";
7901
 
7910
 
7911
  $q = "SELECT RELEASE_LOCK('sinchimport')";
7912
  $this->db_do($q);
7913
+
7914
+ $ftpCred = Mage::getStoreConfig('sinchimport_root/sinch_ftp');
7915
+ Mage::dispatchEvent('sinch_import_after', array('ftp_cred' => $ftpCred));
7916
  } catch (Exception $e) {
7917
  $this->set_import_error_reporting_message($e);
7918
  }
app/code/local/Bintime/Sinchimport/etc/config.xml CHANGED
@@ -4,7 +4,7 @@
4
 
5
  <modules>
6
  <Bintime_Sinchimport>
7
- <version>3.0.8</version>
8
  <depends>
9
  <!-- no dependencies -->
10
  </depends>
@@ -252,12 +252,11 @@
252
  </sinch_cron>
253
  </sinchimport_root>
254
  </default>
255
-
256
  <crontab>
257
  <jobs>
258
  <fullsinchimport>
259
  <schedule>
260
- <cron_expr>0 1 * * *</cron_expr>
261
  </schedule>
262
  <run>
263
  <model>sinchimport/sinch::cron_start_full_import</model>
@@ -266,7 +265,7 @@
266
 
267
  <stockpricesinchimport>
268
  <schedule>
269
- <cron_expr>0 2 * * *</cron_expr>
270
  </schedule>
271
  <run>
272
  <model>sinchimport/sinch::cron_start_stock_price_import</model>
4
 
5
  <modules>
6
  <Bintime_Sinchimport>
7
+ <version>3.1.0</version>
8
  <depends>
9
  <!-- no dependencies -->
10
  </depends>
252
  </sinch_cron>
253
  </sinchimport_root>
254
  </default>
 
255
  <crontab>
256
  <jobs>
257
  <fullsinchimport>
258
  <schedule>
259
+ <cron_expr>0 2 * 6 *</cron_expr>
260
  </schedule>
261
  <run>
262
  <model>sinchimport/sinch::cron_start_full_import</model>
265
 
266
  <stockpricesinchimport>
267
  <schedule>
268
+ <cron_expr>0 8 * * *</cron_expr>
269
  </schedule>
270
  <run>
271
  <model>sinchimport/sinch::cron_start_stock_price_import</model>
app/code/local/Bintime/Sinchimport/sql/sinchimport_setup/filter_sinch_products_s.sql CHANGED
@@ -27,10 +27,8 @@ BEGIN
27
  `feature_value` text
28
  );
29
 
30
-
31
  IF arg_image = 1 THEN
32
  SET @updquery = CONCAT('
33
-
34
  INSERT INTO `tmp_result` (
35
  entity_id,
36
  category_id,
@@ -44,39 +42,39 @@ BEGIN
44
  feature_name,
45
  feature_value
46
  )(
47
- SELECT
48
- E.entity_id,
49
- PCind.category_id,
50
- E.entity_id,
51
- PCind.category_id as sinch_category,
52
- PR.product_name,
53
- PR.main_image_url,
54
- PR.sinch_manufacturer_id,
55
- CF.category_feature_id,
56
- CF.category_feature_id,
57
- CF.feature_name,
58
- RV.`text`
59
- FROM ', arg_table_prefix, 'catalog_product_entity E
60
- INNER JOIN ', arg_table_prefix, 'catalog_category_product_index PCind
61
- ON (E.entity_id = PCind.product_id)
62
- INNER JOIN ', arg_table_prefix, 'stINch_categories_mapping scm
63
- ON PCind.category_id=scm.shop_entity_id
64
- INNER JOIN ',arg_table_prefix, 'stINch_categories_features CF
65
- ON (scm.store_category_id=CF.store_category_id)
66
- INNER JOIN ',arg_table_prefix, 'stINch_products PR
67
- ON (PR.store_product_id = E.store_product_id)
68
- INNER JOIN ',arg_table_prefix, 'stINch_product_features PF
69
- ON (PR.sinch_product_id = PF.sinch_product_id )
70
- INNER JOIN ',arg_table_prefix, 'stINch_restricted_values RV
71
- ON (PF.restricted_value_id=RV.restricted_value_id)
72
- WHERE
73
- scm.shop_entity_id = ', arg_category_id, '
74
- AND PR.main_image_url <> \'\'
 
75
  )
76
  ');
77
  ELSE
78
  SET @updquery = CONCAT('
79
-
80
  INSERT INTO `tmp_result` (
81
  entity_id,
82
  category_id,
@@ -90,33 +88,34 @@ BEGIN
90
  feature_name,
91
  feature_value
92
  )(
93
- SELECT
94
- E.entity_id,
95
- PCind.category_id,
96
- E.entity_id,
97
- PCind.category_id as sinch_category,
98
- PR.product_name,
99
- PR.main_image_url,
100
- PR.sinch_manufacturer_id,
101
- CF.category_feature_id,
102
- CF.category_feature_id,
103
- CF.feature_name,
104
- RV.text
105
- FROM ', arg_table_prefix ,'catalog_product_entity E
106
- INNER JOIN ', arg_table_prefix, 'catalog_category_product_index PCind
107
- ON (E.entity_id = PCind.product_id)
108
- INNER JOIN ', arg_table_prefix, 'stINch_categories_mapping scm
109
- ON PCind.category_id=scm.shop_entity_id
110
- INNER JOIN ', arg_table_prefix, 'stINch_categories_features CF
111
- ON (scm.store_category_id=CF.store_category_id)
112
- INNER JOIN ', arg_table_prefix, 'stINch_products PR
113
- ON (PR.store_product_id = E.store_product_id)
114
- INNER JOIN ', arg_table_prefix, 'stINch_product_features PF
115
- ON (PR.sinch_product_id = PF.sinch_product_id )
116
- INNER JOIN ', arg_table_prefix, 'stINch_restricted_values RV
117
- ON (PF.restricted_value_id=RV.restricted_value_id)
118
- WHERE
119
- scm.shop_entity_id = ', arg_category_id, '
 
120
  )
121
  ');
122
  END IF;
@@ -159,12 +158,12 @@ BEGIN
159
  ');
160
  ELSE
161
  IF (arg_least IS NOT null AND arg_greatest IS NOT null) THEN
162
- SET @where = CONCAT(' AND TR.feature_value >= ', arg_least, ' AND TR.feature_value <', arg_greatest, ' ');
163
  ELSE
164
  IF arg_least IS null THEN
165
- SET @where = CONCAT(' AND TR.feature_value < ', arg_greatest, ' ');
166
  ELSE
167
- SET @where = CONCAT(' AND TR.feature_value >= ', arg_least, ' ');
168
  END IF;
169
  END IF;
170
 
27
  `feature_value` text
28
  );
29
 
 
30
  IF arg_image = 1 THEN
31
  SET @updquery = CONCAT('
 
32
  INSERT INTO `tmp_result` (
33
  entity_id,
34
  category_id,
42
  feature_name,
43
  feature_value
44
  )(
45
+ SELECT
46
+ e.entity_id,
47
+ ccpi.category_id,
48
+ e.entity_id,
49
+ ccpi.category_id as sinch_category,
50
+ sp.product_name,
51
+ sp.main_image_url,
52
+ sp.sinch_manufacturer_id,
53
+ scf.category_feature_id,
54
+ scf.category_feature_id,
55
+ scf.feature_name,
56
+ srv.text
57
+ FROM ', arg_table_prefix, 'catalog_product_entity e
58
+ INNER JOIN ', arg_table_prefix, 'stINch_products sp
59
+ ON (sp.store_product_id = e.store_product_id)
60
+ INNER JOIN ', arg_table_prefix, 'catalog_category_product_index ccpi
61
+ ON (e.entity_id = ccpi.product_id)
62
+ INNER JOIN ', arg_table_prefix, 'stINch_product_features spf
63
+ ON (spf.sinch_product_id = e.sinch_product_id)
64
+ INNER JOIN ', arg_table_prefix, 'stINch_restricted_values srv
65
+ ON (srv.restricted_value_id = spf.restricted_value_id)
66
+ INNER JOIN ', arg_table_prefix, 'stINch_categories_features scf
67
+ ON (scf.category_feature_id = srv.category_feature_id)
68
+ INNER JOIN ', arg_table_prefix, 'stINch_categories_mapping scm
69
+ ON (scm.shop_store_category_id = scf.store_category_id)
70
+ WHERE
71
+ scm.shop_entity_id = ', arg_category_id, '
72
+ AND PR.main_image_url <> \'\'
73
+ GROUP BY e.entity_id, scf.category_feature_id, scf.feature_name, srv.text
74
  )
75
  ');
76
  ELSE
77
  SET @updquery = CONCAT('
 
78
  INSERT INTO `tmp_result` (
79
  entity_id,
80
  category_id,
88
  feature_name,
89
  feature_value
90
  )(
91
+ SELECT
92
+ e.entity_id,
93
+ ccpi.category_id,
94
+ e.entity_id,
95
+ ccpi.category_id as sinch_category,
96
+ sp.product_name,
97
+ sp.main_image_url,
98
+ sp.sinch_manufacturer_id,
99
+ scf.category_feature_id,
100
+ scf.category_feature_id,
101
+ scf.feature_name,
102
+ srv.text
103
+ FROM ', arg_table_prefix, 'catalog_product_entity e
104
+ INNER JOIN ', arg_table_prefix, 'stINch_products sp
105
+ ON (sp.store_product_id = e.store_product_id)
106
+ INNER JOIN ', arg_table_prefix, 'catalog_category_product_index ccpi
107
+ ON (e.entity_id = ccpi.product_id)
108
+ INNER JOIN ', arg_table_prefix, 'stINch_product_features spf
109
+ ON (spf.sinch_product_id = e.sinch_product_id)
110
+ INNER JOIN ', arg_table_prefix, 'stINch_restricted_values srv
111
+ ON (srv.restricted_value_id = spf.restricted_value_id)
112
+ INNER JOIN ', arg_table_prefix, 'stINch_categories_features scf
113
+ ON (scf.category_feature_id = srv.category_feature_id)
114
+ INNER JOIN ', arg_table_prefix, 'stINch_categories_mapping scm
115
+ ON (scm.shop_store_category_id = scf.store_category_id)
116
+ WHERE
117
+ scm.shop_entity_id = ', arg_category_id, '
118
+ GROUP BY e.entity_id, scf.category_feature_id, scf.feature_name, srv.text
119
  )
120
  ');
121
  END IF;
158
  ');
159
  ELSE
160
  IF (arg_least IS NOT null AND arg_greatest IS NOT null) THEN
161
+ SET @where = CONCAT('TR.feature_value >= ', arg_least, ' AND TR.feature_value <', arg_greatest, ' ');
162
  ELSE
163
  IF arg_least IS null THEN
164
+ SET @where = CONCAT('TR.feature_value < ', arg_greatest, ' ');
165
  ELSE
166
+ SET @where = CONCAT('TR.feature_value >= ', arg_least, ' ');
167
  END IF;
168
  END IF;
169
 
app/code/local/Bintime/Sinchimport/sql/sinchimport_setup/mysql4-upgrade-3.0.8-3.1.0.php ADDED
@@ -0,0 +1,234 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
+ <?php
2
+ $installer = $this;
3
+
4
+ $config = $installer->getConnection()->getConfig();
5
+ $cnx = mysql_connect($config['host'], $config['username'], $config['password']);
6
+ if (!$cnx) {
7
+ throw new Exception('Failed to connect to database.');
8
+ }
9
+
10
+ if (!mysql_select_db($config['dbname'])) {
11
+ throw new Exception('Failed to select a database.');
12
+ }
13
+
14
+ $installer->startSetup();
15
+
16
+ // create a new procedure
17
+ $installer->run("DROP PROCEDURE IF EXISTS ".$installer->getTable('filter_sinch_products_s'));
18
+
19
+ $query = "
20
+ CREATE PROCEDURE " . $installer->getTable('filter_sinch_products_s') . "(
21
+ IN arg_table INT,
22
+ IN arg_category_id INT,
23
+ IN arg_image INT,
24
+ IN arg_category_feature INT,
25
+ IN arg_least INT,
26
+ IN arg_greatest INT,
27
+ IN arg_table_prefix VARCHAR(255)
28
+ )
29
+ BEGIN
30
+ DROP TABLE IF EXISTS `tmp_result`;
31
+
32
+ CREATE TEMPORARY TABLE `tmp_result`(
33
+ `entity_id` int(10) unsigned,
34
+ `category_id` int(10) unsigned,
35
+ `product_id` int,
36
+ `sinch_category_id` int,
37
+ `name` varchar(255),
38
+ `image` varchar(255),
39
+ `supplier_id` int,
40
+ `category_feature_id` int,
41
+ `feature_id` int,
42
+ `feature_name` varchar(255),
43
+ `feature_value` text
44
+ );
45
+
46
+ IF arg_image = 1 THEN
47
+ SET @updquery = CONCAT('
48
+ INSERT INTO `tmp_result` (
49
+ entity_id,
50
+ category_id,
51
+ product_id,
52
+ sinch_category_id,
53
+ name,
54
+ image,
55
+ supplier_id,
56
+ category_feature_id,
57
+ feature_id,
58
+ feature_name,
59
+ feature_value
60
+ )(
61
+ SELECT
62
+ e.entity_id,
63
+ ccpi.category_id,
64
+ e.entity_id,
65
+ ccpi.category_id as sinch_category,
66
+ sp.product_name,
67
+ sp.main_image_url,
68
+ sp.sinch_manufacturer_id,
69
+ scf.category_feature_id,
70
+ scf.category_feature_id,
71
+ scf.feature_name,
72
+ srv.text
73
+ FROM ', arg_table_prefix, 'catalog_product_entity e
74
+ INNER JOIN ', arg_table_prefix, 'stINch_products sp
75
+ ON (sp.store_product_id = e.store_product_id)
76
+ INNER JOIN ', arg_table_prefix, 'catalog_category_product_index ccpi
77
+ ON (e.entity_id = ccpi.product_id)
78
+ INNER JOIN ', arg_table_prefix, 'stINch_product_features spf
79
+ ON (spf.sinch_product_id = e.sinch_product_id)
80
+ INNER JOIN ', arg_table_prefix, 'stINch_restricted_values srv
81
+ ON (srv.restricted_value_id = spf.restricted_value_id)
82
+ INNER JOIN ', arg_table_prefix, 'stINch_categories_features scf
83
+ ON (scf.category_feature_id = srv.category_feature_id)
84
+ INNER JOIN ', arg_table_prefix, 'stINch_categories_mapping scm
85
+ ON (scm.shop_store_category_id = scf.store_category_id)
86
+ WHERE
87
+ scm.shop_entity_id = ', arg_category_id, '
88
+ scm.shop_entity_id = ', arg_category_id, '
89
+ AND PR.main_image_url <> \'\'
90
+ GROUP BY e.entity_id, scf.category_feature_id, scf.feature_name, srv.text
91
+ )
92
+ ');
93
+ ELSE
94
+ SET @updquery = CONCAT('
95
+ INSERT INTO `tmp_result` (
96
+ entity_id,
97
+ category_id,
98
+ product_id,
99
+ sinch_category_id,
100
+ name,
101
+ image,
102
+ supplier_id,
103
+ category_feature_id,
104
+ feature_id,
105
+ feature_name,
106
+ feature_value
107
+ )(
108
+ SELECT
109
+ e.entity_id,
110
+ ccpi.category_id,
111
+ e.entity_id,
112
+ ccpi.category_id as sinch_category,
113
+ sp.product_name,
114
+ sp.main_image_url,
115
+ sp.sinch_manufacturer_id,
116
+ scf.category_feature_id,
117
+ scf.category_feature_id,
118
+ scf.feature_name,
119
+ srv.text
120
+ FROM ', arg_table_prefix, 'catalog_product_entity e
121
+ INNER JOIN ', arg_table_prefix, 'stINch_products sp
122
+ ON (sp.store_product_id = e.store_product_id)
123
+ INNER JOIN ', arg_table_prefix, 'catalog_category_product_index ccpi
124
+ ON (e.entity_id = ccpi.product_id)
125
+ INNER JOIN ', arg_table_prefix, 'stINch_product_features spf
126
+ ON (spf.sinch_product_id = e.sinch_product_id)
127
+ INNER JOIN ', arg_table_prefix, 'stINch_restricted_values srv
128
+ ON (srv.restricted_value_id = spf.restricted_value_id)
129
+ INNER JOIN ', arg_table_prefix, 'stINch_categories_features scf
130
+ ON (scf.category_feature_id = srv.category_feature_id)
131
+ INNER JOIN ', arg_table_prefix, 'stINch_categories_mapping scm
132
+ ON (scm.shop_store_category_id = scf.store_category_id)
133
+ WHERE
134
+ scm.shop_entity_id = ', arg_category_id, '
135
+ GROUP BY e.entity_id, scf.category_feature_id, scf.feature_name, srv.text
136
+ )
137
+ ');
138
+ END IF;
139
+
140
+ PREPARE myquery FROM @updquery;
141
+ EXECUTE myquery;
142
+ DROP PREPARE myquery;
143
+
144
+ IF (arg_least IS null AND arg_greatest IS null) THEN
145
+ SET @query = CONCAT('
146
+ INSERT INTO `', arg_table_prefix, 'SinchFilterResult_', arg_table, '` (
147
+ entity_id,
148
+ category_id,
149
+ product_id,
150
+ sinch_category_id,
151
+ name,
152
+ image,
153
+ supplier_id,
154
+ category_feature_id,
155
+ feature_id,
156
+ feature_name,
157
+ feature_value
158
+ )(
159
+ SELECT
160
+ TR.entity_id,
161
+ TR.category_id,
162
+ TR.product_id,
163
+ TR.sinch_category_id,
164
+ TR.name,
165
+ TR.image,
166
+ TR.supplier_id,
167
+ TR.category_feature_id,
168
+ TR.feature_id,
169
+ TR.feature_name,
170
+ TR.feature_value
171
+ FROM `tmp_result` AS TR
172
+ WHERE TR.category_feature_id = \'', arg_category_feature, '\'
173
+ )
174
+ ON DUPLICATE KEY UPDATE feature_value = TR.feature_value
175
+ ');
176
+ ELSE
177
+ IF (arg_least IS NOT null AND arg_greatest IS NOT null) THEN
178
+ SET @where = CONCAT(' AND TR.feature_value >= ', arg_least, ' AND TR.feature_value <', arg_greatest, ' ');
179
+ ELSE
180
+ IF arg_least IS null THEN
181
+ SET @where = CONCAT(' AND TR.feature_value < ', arg_greatest, ' ');
182
+ ELSE
183
+ SET @where = CONCAT(' AND TR.feature_value >= ', arg_least, ' ');
184
+ END IF;
185
+ END IF;
186
+
187
+ SET @query = CONCAT('
188
+ INSERT INTO `', arg_table_prefix, 'SinchFilterResult_', arg_table, '` (
189
+ entity_id,
190
+ category_id,
191
+ product_id,
192
+ sinch_category_id,
193
+ name,
194
+ image,
195
+ supplier_id,
196
+ category_feature_id,
197
+ feature_id,
198
+ feature_name,
199
+ feature_value
200
+ )(
201
+ SELECT
202
+ TR.entity_id,
203
+ TR.category_id,
204
+ TR.product_id,
205
+ TR.sinch_category_id,
206
+ TR.name,
207
+ TR.image,
208
+ TR.supplier_id,
209
+ TR.category_feature_id,
210
+ TR.feature_id,
211
+ TR.feature_name,
212
+ TR.feature_value
213
+ FROM `tmp_result` AS TR
214
+ WHERE TR.category_feature_id = \'', arg_category_feature, '\'',
215
+ @where,'
216
+ )
217
+ ON DUPLICATE KEY UPDATE feature_value = TR.feature_value
218
+ ');
219
+
220
+ END IF;
221
+
222
+ PREPARE myquery FROM @query;
223
+ EXECUTE myquery;
224
+ DROP PREPARE myquery;
225
+ END
226
+ ";
227
+
228
+ if (!mysql_query($query, $cnx)) {
229
+ throw new Exception("Failed to create stored procedure".$query);
230
+ }
231
+
232
+ mysql_close($cnx);
233
+
234
+ $installer->endSetup();
package.xml CHANGED
@@ -1,7 +1,7 @@
1
  <?xml version="1.0"?>
2
  <package>
3
  <name>stockinthechannel2012</name>
4
- <version>2.2.1</version>
5
  <stability>stable</stability>
6
  <license uri="http://opensource.org/licenses/osl-3.0.php">OSL v3</license>
7
  <channel>community</channel>
@@ -9,15 +9,14 @@
9
  <summary>Import Plugin for the Stock in the Channel Magento Data Feed</summary>
10
  <description>Import Plugin for the Stock in the Channel Magento Data Feed.&#xD;
11
  Requires a Magento Formatted Data feed from http://stockinthechannel.com</description>
12
- <notes>Version 2.2.1:&#xD;
13
- * Category Description database table type limit extended&#xD;
14
- *EAN N/A fix&#xD;
15
- * Fixed Unknown column 'sku' in 'field list error message for stINch_products_mapping_temp&#xD;
16
  </notes>
17
  <authors><author><name>stockinchannel</name><user>stockinchannel</user><email>marketing@stockinthechannel.com</email></author><author><name>Nick Anstee</name><user>nicka101</user><email>nick@stockinthechannel.com</email></author><author><name>Michael Figg</name><user>michaelf</user><email>michael@stockinthechannel.com</email></author></authors>
18
- <date>2017-03-08</date>
19
- <time>17:33:57</time>
20
- <contents><target name="magelocal"><dir name="Bintime"><dir name="Sinchimport"><dir name="Block"><dir name="Adminhtml"><dir name="Catalog"><dir name="Product"><file name="Sinchdistributors.php" hash="20c2452bfbf7206c72b2402e4eaa1541"/></dir></dir></dir><file name="Backupbutton.php" hash="bf42e9a5cd2aae1e8766c8475fcf84aa"/><file name="Importenvironment.php" hash="85ac7cf582ad798fc31d85855319d6e1"/><file name="Importhistory.php" hash="53018d6131869b96ee88f7985cd5c554"/><dir name="Layer"><dir name="Filter"><file name="Feature.php" hash="239d86cde4cf08f5f50183df26e89eea"/></dir><file name="View.php" hash="cd0237e60846199ee9a32e48c4c89cd4"/></dir><file name="List.php" hash="db883cb9fb90fc16e4e9cb5db2050937"/><dir name="Product"><dir name="View"><file name="Media.php" hash="da9cb0526e64507b9ec456e28b4add75"/></dir></dir><file name="Startimportbutton.php" hash="19462ca24375f91a5d261d840046ed76"/><file name="Startstockpriceimportbutton.php" hash="59dbe9b52eea94b0baf78d2bb01d485d"/></dir><dir name="Helper"><file name="Data.php" hash="8a6379053d730de32bdc6034ae83ff87"/><file name="Getdata.php" hash="ae7e1cd6e00174a5eb9d4cd8d79f42ed"/><file name="Image.php" hash="4507e0741e1bf094ce558ffb908dbae8"/></dir><dir name="Model"><file name="Api.php" hash="3af89f70e0ac8bc9c0c0081b132ed836"/><file name="Backup.php" hash="ff2ab7c12726a6fd7e8914f216660a89"/><file name="Category.php" hash="0bffff839c0f48ecd75689654e79f7ce"/><file name="Image.php" hash="b87da6ed365c3265495afdc2f3b04eb2"/><dir name="Layer"><dir name="Filter"><file name="Feature.php" hash="7bf4904f35de94c6a7235dee1be62523"/><file name="Price.php" hash="41292f8d81a586130d0a914d5b6dcfa5"/></dir></dir><file name="Layer.php" hash="2c0131265f18450126d7a0988d6ed284"/><file name="Product.php" hash="3b91221e17aa398e5972b6fb5dd95975"/><dir name="Resource"><dir name="Layer"><dir name="Filter"><file name="Price.php" hash="bb9746143b24c629911affa33fec3393"/></dir></dir><dir name="Mysql4"><dir name="Layer"><dir name="Filter"><file name="Feature.php" hash="55378e57f6c43cb02361cf3ec36701d4"/></dir></dir><file name="Setup.php" hash="dc80686f5d5449c192fa910c79751a9d"/></dir></dir><file name="Sinch.php" hash="a70c158f0021829de362cdb0835f7840"/><dir name="System"><dir name="Config"><file name="CatRewrite.php" hash="7783f4948f34d7fe5045e94962c822fc"/><file name="ProdRewrite.php" hash="26e079c5d012a20d60b008433877657f"/><file name="ServerList.php" hash="2b2606e85f508ebdae6461aa0a5f8a72"/><file name="Subscription.php" hash="2549cb02c0f1e2fb6968cb5d1f1723ba"/></dir></dir><file name="config.php" hash="34088ac238ec7e6ddfccc8629430d1a0"/></dir><dir name="controllers"><file name="AjaxController.php" hash="dceab5aab2a25d831e366e41732f6073"/><file name="BackupController.php" hash="d94589224453aa9df72aa31bc50eb2e0"/><file name="IndexController.php" hash="fe2df4c805fc7d798a6fef383ccef50a"/><file name="ProductController.php" hash="9ddef4868ad4d382ad0724fb1716f200"/><file name="SplitfeaturesController.php" hash="d056fdc368af98d59cf7c0bd328142ec"/></dir><dir name="etc"><file name="api.xml" hash="4b9df3ba0ff94824f06a5c14497034cb"/><file name="config.xml" hash="90cbf462e48a860d159653577ff95660"/><file name="system.xml" hash="498028a265eb9107531b3d7c9efc9958"/></dir><file name="sinch_import_start_ajax.php" hash="c4eedde696225beb7e3d75fbeaa9a5ea"/><dir name="sql"><dir name="sinchimport_setup"><file name="filter_sinch_products_s.sql" hash="005906c8f39dceae2093957c8ba8b0b2"/><file name="mysql4-install-0.1.0.php" hash="5925ffb8574cb35032b9d2866f4da7be"/><file name="mysql4-upgrade-0.1.0-0.1.1.php" hash="93a43b01c4ad6eb9c9638dc1d31ca777"/><file name="mysql4-upgrade-0.1.1-0.1.2.php" hash="710c4d2873fcbe3061b925072d995d73"/><file name="mysql4-upgrade-0.1.2-0.1.3.php" hash="d2892bb825c7baf2139c136fd96f2f66"/><file name="mysql4-upgrade-0.1.3-0.1.4.php" hash="ab6aa72ff697db247423911437830795"/><file name="mysql4-upgrade-0.1.4-0.1.5.php" hash="f195a8bf9fbcc31eca6d066ff1bb98f5"/><file name="mysql4-upgrade-0.1.5-0.1.6.php" hash="f4ee53d9644c16c80327b40fec432d1d"/><file name="mysql4-upgrade-0.1.6-0.1.7.php" hash="987ed4ca76a263580705ec93e0277120"/><file name="mysql4-upgrade-0.1.7-0.1.8.php" hash="e52bb4ef6f982992fcbfcce710698525"/><file name="mysql4-upgrade-0.1.8-0.1.9.php" hash="de6b560cef7edf7914cc4f135b0678b9"/><file name="mysql4-upgrade-0.1.9-0.2.0.php" hash="33618a810c8b88d28fc1b504eb65c657"/><file name="mysql4-upgrade-0.2.0-0.2.1.php" hash="507b285ba1f3eb98d9fb54a3ae29257c"/><file name="mysql4-upgrade-0.2.1-0.2.2.php" hash="55732b89b294191eaecbe3a5e1c7691e"/><file name="mysql4-upgrade-3.0.0-3.0.1.php" hash="3a7b53cbc0585e04afed64b321771a8a"/><file name="mysql4-upgrade-3.0.1-3.0.2.php" hash="12853ce85af460e0d462fbf3297715c0"/><file name="mysql4-upgrade-3.0.2-3.0.3.php" hash="2c0c1a12c567ecacad6647eeffa4f198"/><file name="mysql4-upgrade-3.0.3-3.0.4.php" hash="9c3612df0a873fa6e59ae9f98c5de2b0"/><file name="mysql4-upgrade-3.0.4-3.0.5.php" hash="89138c892702bd3b8f18ccec1b39d5fc"/><file name="mysql4-upgrade-3.0.5-3.0.6.php" hash="d955c0ebd1aed6cf6a50e9f47e6cddc1"/><file name="mysql4-upgrade-3.0.6-3.0.7.php" hash="658b317dc33176b3fb967d95c88dea27"/><file name="mysql4-upgrade-3.0.7-3.0.8.php" hash="9938b6739d3f4a839b01f873c0b15db5"/><file name="storeProcedureGenerator.php" hash="cad9767668d9fb6fba21d3a72196d927"/></dir></dir><file name="stock_price_sinch_import_start_ajax.php" hash="1cc9acad458c3c600ae507f112e37640"/></dir></dir></target><target name="mageetc"><dir name="modules"><file name="Bintime_Sinchimport.xml" hash="8d5661b858250eeb154af10ee19300c3"/></dir></target><target name="magedesign"><dir name="frontend"><dir name="default"><dir name="default"><dir name="layout"><file name="sinchimport.xml" hash="53dd99d9303049f92713aec45c21836f"/></dir><dir name="template"><dir name="sinchimport"><file name="list.phtml" hash="adc46e247797cdad4582792266d381e4"/><file name="media.phtml" hash="af44d0371493235e4d0a5d0e9223bd9e"/><file name="view.phtml" hash="f160f6226d774a82ab1b312ffb30eb3e"/></dir></dir></dir></dir></dir><dir name="adminhtml"><dir name="default"><dir name="default"><dir name="layout"><file name="sinchimport.xml" hash="96b53d22fe6dc3526a9bcef5f470cabe"/></dir><dir name="template"><dir name="sinchimport"><dir name="sales"><dir name="items"><dir name="column"><file name="name.phtml" hash="27c9c11cbf99919dfdf819e788281f5f"/></dir></dir></dir><file name="sinchdistributors.phtml" hash="cfda729147fd7b03b9f1bdc582e0d07f"/></dir></dir></dir></dir></dir></target><target name="mageskin"><dir name="adminhtml"><dir name="default"><dir name="default"><dir name="images"><file name="sinchimport_run.gif" hash="e805ea7eca1f34c75ba0f93780d32d38"/><file name="sinchimport_yes.gif" hash="0afb20898a704a106cb4c598868abf32"/></dir></dir></dir></dir></target></contents>
21
  <compatible/>
22
  <dependencies><required><php><min>5.3.0</min><max>6.0.0</max></php></required></dependencies>
23
  </package>
1
  <?xml version="1.0"?>
2
  <package>
3
  <name>stockinthechannel2012</name>
4
+ <version>2.2.2</version>
5
  <stability>stable</stability>
6
  <license uri="http://opensource.org/licenses/osl-3.0.php">OSL v3</license>
7
  <channel>community</channel>
9
  <summary>Import Plugin for the Stock in the Channel Magento Data Feed</summary>
10
  <description>Import Plugin for the Stock in the Channel Magento Data Feed.&#xD;
11
  Requires a Magento Formatted Data feed from http://stockinthechannel.com</description>
12
+ <notes>Version 2.2.2:&#xD;
13
+ * Filters with Y / N not working are fixed&#xD;
14
+ * Cron automated import reconfigured for better timing structure.&#xD;
 
15
  </notes>
16
  <authors><author><name>stockinchannel</name><user>stockinchannel</user><email>marketing@stockinthechannel.com</email></author><author><name>Nick Anstee</name><user>nicka101</user><email>nick@stockinthechannel.com</email></author><author><name>Michael Figg</name><user>michaelf</user><email>michael@stockinthechannel.com</email></author></authors>
17
+ <date>2017-04-03</date>
18
+ <time>12:40:56</time>
19
+ <contents><target name="magelocal"><dir name="Bintime"><dir name="Sinchimport"><dir name="Block"><dir name="Adminhtml"><dir name="Catalog"><dir name="Product"><file name="Sinchdistributors.php" hash="20c2452bfbf7206c72b2402e4eaa1541"/></dir></dir></dir><file name="Backupbutton.php" hash="bf42e9a5cd2aae1e8766c8475fcf84aa"/><file name="Importenvironment.php" hash="85ac7cf582ad798fc31d85855319d6e1"/><file name="Importhistory.php" hash="53018d6131869b96ee88f7985cd5c554"/><dir name="Layer"><dir name="Filter"><file name="Feature.php" hash="239d86cde4cf08f5f50183df26e89eea"/></dir><file name="View.php" hash="cd0237e60846199ee9a32e48c4c89cd4"/></dir><file name="List.php" hash="db883cb9fb90fc16e4e9cb5db2050937"/><dir name="Product"><dir name="View"><file name="Media.php" hash="da9cb0526e64507b9ec456e28b4add75"/></dir></dir><file name="Startimportbutton.php" hash="19462ca24375f91a5d261d840046ed76"/><file name="Startstockpriceimportbutton.php" hash="59dbe9b52eea94b0baf78d2bb01d485d"/></dir><dir name="Helper"><file name="Data.php" hash="8a6379053d730de32bdc6034ae83ff87"/><file name="Getdata.php" hash="ae7e1cd6e00174a5eb9d4cd8d79f42ed"/><file name="Image.php" hash="4507e0741e1bf094ce558ffb908dbae8"/></dir><dir name="Model"><file name="Api.php" hash="3af89f70e0ac8bc9c0c0081b132ed836"/><file name="Backup.php" hash="ff2ab7c12726a6fd7e8914f216660a89"/><file name="Category.php" hash="0bffff839c0f48ecd75689654e79f7ce"/><file name="Image.php" hash="b87da6ed365c3265495afdc2f3b04eb2"/><dir name="Layer"><dir name="Filter"><file name="Feature.php" hash="7bf4904f35de94c6a7235dee1be62523"/><file name="Price.php" hash="41292f8d81a586130d0a914d5b6dcfa5"/></dir></dir><file name="Layer.php" hash="2c0131265f18450126d7a0988d6ed284"/><file name="Product.php" hash="3b91221e17aa398e5972b6fb5dd95975"/><dir name="Resource"><dir name="Layer"><dir name="Filter"><file name="Price.php" hash="bb9746143b24c629911affa33fec3393"/></dir></dir><dir name="Mysql4"><dir name="Layer"><dir name="Filter"><file name="Feature.php" hash="c8b768e73d62414d36d36d097ff80d96"/></dir></dir><file name="Setup.php" hash="dc80686f5d5449c192fa910c79751a9d"/></dir></dir><file name="Sinch.php" hash="52f9aca211b3cc65efabe4cbe206d2ea"/><dir name="System"><dir name="Config"><file name="CatRewrite.php" hash="7783f4948f34d7fe5045e94962c822fc"/><file name="ProdRewrite.php" hash="26e079c5d012a20d60b008433877657f"/><file name="ServerList.php" hash="2b2606e85f508ebdae6461aa0a5f8a72"/><file name="Subscription.php" hash="2549cb02c0f1e2fb6968cb5d1f1723ba"/></dir></dir><file name="config.php" hash="34088ac238ec7e6ddfccc8629430d1a0"/></dir><dir name="controllers"><file name="AjaxController.php" hash="dceab5aab2a25d831e366e41732f6073"/><file name="BackupController.php" hash="d94589224453aa9df72aa31bc50eb2e0"/><file name="IndexController.php" hash="fe2df4c805fc7d798a6fef383ccef50a"/><file name="ProductController.php" hash="9ddef4868ad4d382ad0724fb1716f200"/><file name="SplitfeaturesController.php" hash="d056fdc368af98d59cf7c0bd328142ec"/></dir><dir name="etc"><file name="api.xml" hash="4b9df3ba0ff94824f06a5c14497034cb"/><file name="config.xml" hash="0263a3f6bdfa779215d12e17ecaa6aa6"/><file name="system.xml" hash="498028a265eb9107531b3d7c9efc9958"/></dir><file name="sinch_import_start_ajax.php" hash="c4eedde696225beb7e3d75fbeaa9a5ea"/><dir name="sql"><dir name="sinchimport_setup"><file name="filter_sinch_products_s.sql" hash="ac4ab2f66b8c755da05488d6bd3118a0"/><file name="mysql4-install-0.1.0.php" hash="5925ffb8574cb35032b9d2866f4da7be"/><file name="mysql4-upgrade-0.1.0-0.1.1.php" hash="93a43b01c4ad6eb9c9638dc1d31ca777"/><file name="mysql4-upgrade-0.1.1-0.1.2.php" hash="710c4d2873fcbe3061b925072d995d73"/><file name="mysql4-upgrade-0.1.2-0.1.3.php" hash="d2892bb825c7baf2139c136fd96f2f66"/><file name="mysql4-upgrade-0.1.3-0.1.4.php" hash="ab6aa72ff697db247423911437830795"/><file name="mysql4-upgrade-0.1.4-0.1.5.php" hash="f195a8bf9fbcc31eca6d066ff1bb98f5"/><file name="mysql4-upgrade-0.1.5-0.1.6.php" hash="f4ee53d9644c16c80327b40fec432d1d"/><file name="mysql4-upgrade-0.1.6-0.1.7.php" hash="987ed4ca76a263580705ec93e0277120"/><file name="mysql4-upgrade-0.1.7-0.1.8.php" hash="e52bb4ef6f982992fcbfcce710698525"/><file name="mysql4-upgrade-0.1.8-0.1.9.php" hash="de6b560cef7edf7914cc4f135b0678b9"/><file name="mysql4-upgrade-0.1.9-0.2.0.php" hash="33618a810c8b88d28fc1b504eb65c657"/><file name="mysql4-upgrade-0.2.0-0.2.1.php" hash="507b285ba1f3eb98d9fb54a3ae29257c"/><file name="mysql4-upgrade-0.2.1-0.2.2.php" hash="55732b89b294191eaecbe3a5e1c7691e"/><file name="mysql4-upgrade-3.0.0-3.0.1.php" hash="3a7b53cbc0585e04afed64b321771a8a"/><file name="mysql4-upgrade-3.0.1-3.0.2.php" hash="12853ce85af460e0d462fbf3297715c0"/><file name="mysql4-upgrade-3.0.2-3.0.3.php" hash="2c0c1a12c567ecacad6647eeffa4f198"/><file name="mysql4-upgrade-3.0.3-3.0.4.php" hash="9c3612df0a873fa6e59ae9f98c5de2b0"/><file name="mysql4-upgrade-3.0.4-3.0.5.php" hash="89138c892702bd3b8f18ccec1b39d5fc"/><file name="mysql4-upgrade-3.0.5-3.0.6.php" hash="d955c0ebd1aed6cf6a50e9f47e6cddc1"/><file name="mysql4-upgrade-3.0.6-3.0.7.php" hash="658b317dc33176b3fb967d95c88dea27"/><file name="mysql4-upgrade-3.0.7-3.0.8.php" hash="9938b6739d3f4a839b01f873c0b15db5"/><file name="mysql4-upgrade-3.0.8-3.1.0.php" hash="3a6b30bc2a0105acdf6e89e90dadb3b9"/><file name="storeProcedureGenerator.php" hash="cad9767668d9fb6fba21d3a72196d927"/></dir></dir><file name="stock_price_sinch_import_start_ajax.php" hash="1cc9acad458c3c600ae507f112e37640"/></dir></dir></target><target name="mageetc"><dir name="modules"><file name="Bintime_Sinchimport.xml" hash="8d5661b858250eeb154af10ee19300c3"/></dir></target><target name="magedesign"><dir name="frontend"><dir name="default"><dir name="default"><dir name="layout"><file name="sinchimport.xml" hash="53dd99d9303049f92713aec45c21836f"/></dir><dir name="template"><dir name="sinchimport"><file name="list.phtml" hash="adc46e247797cdad4582792266d381e4"/><file name="media.phtml" hash="af44d0371493235e4d0a5d0e9223bd9e"/><file name="view.phtml" hash="f160f6226d774a82ab1b312ffb30eb3e"/></dir></dir></dir></dir></dir><dir name="adminhtml"><dir name="default"><dir name="default"><dir name="layout"><file name="sinchimport.xml" hash="96b53d22fe6dc3526a9bcef5f470cabe"/></dir><dir name="template"><dir name="sinchimport"><dir name="sales"><dir name="items"><dir name="column"><file name="name.phtml" hash="27c9c11cbf99919dfdf819e788281f5f"/></dir></dir></dir><file name="sinchdistributors.phtml" hash="cfda729147fd7b03b9f1bdc582e0d07f"/></dir></dir></dir></dir></dir></target><target name="mageskin"><dir name="adminhtml"><dir name="default"><dir name="default"><dir name="images"><file name="sinchimport_run.gif" hash="e805ea7eca1f34c75ba0f93780d32d38"/><file name="sinchimport_yes.gif" hash="0afb20898a704a106cb4c598868abf32"/></dir></dir></dir></dir></target></contents>
20
  <compatible/>
21
  <dependencies><required><php><min>5.3.0</min><max>6.0.0</max></php></required></dependencies>
22
  </package>