Wisepricer_Syncer - Version 1.1.4.6

Version Notes

Fixed bug: skip ignored products on the level of sql query

Download this release

Release Info

Developer Magento Core Team
Extension Wisepricer_Syncer
Version 1.1.4.6
Comparing to
See all releases


Code changes from version 1.1.4.5 to 1.1.4.6

Files changed (3) hide show
  1. app/code/local/Wisepricer/Syncer/controllers/ProductsController.php +25 -10
  2. app/code/local/Wisepricer/Syncer/etc/config.xml +1 -1
  3. package.xml +5 -6
app/code/local/Wisepricer/Syncer/controllers/ProductsController.php CHANGED
@@ -74,11 +74,20 @@ class Wisepricer_Syncer_ProductsController extends Wisepricer_Syncer_BaseControl
74
 
75
  }
76
  $collection->addFieldToFilter('status', Mage_Catalog_Model_Product_Status::STATUS_ENABLED);
77
- $collection->addAttributeToSelect('import_to_wisepricer');
78
  $collection->addAttributeToFilter('type_id', array('eq' => 'simple'));
79
-
 
 
 
 
 
 
 
 
 
 
80
  if($licenseData->getWebsite()!=0){
81
- $collection->addStoreFilter($licenseData->getWebsite());
82
  }
83
 
84
  if($licenseData->getImport_outofstock()){
@@ -87,6 +96,7 @@ class Wisepricer_Syncer_ProductsController extends Wisepricer_Syncer_BaseControl
87
 
88
  $collection->setPage($pageNum, $count)->load();
89
  // echo '<pre>'.print_r($collection->getData(),true).'</pre>'; die;
 
90
 
91
  $productsOutput=array();
92
 
@@ -94,10 +104,6 @@ class Wisepricer_Syncer_ProductsController extends Wisepricer_Syncer_BaseControl
94
 
95
  foreach ($collection as $product) {
96
 
97
- if($product->getimport_to_wisepricer()==1){
98
- continue;
99
- }
100
-
101
  $productCollData=$product->getData();
102
  $productModel=Mage::getModel('catalog/product')->load($productCollData['entity_id']);
103
 
@@ -114,9 +120,18 @@ class Wisepricer_Syncer_ProductsController extends Wisepricer_Syncer_BaseControl
114
  }elseif($field['wsp_field']=='productimage'){
115
 
116
  if($field['magento_field']=='image'||$field['magento_field']=='small_image'){
 
117
  //TODO add valid media url in case that website uses store code in url check this Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_MEDIA);
118
- $siteUrl=substr_replace(Mage::getUrl('media/catalog/product') ,"",-1);
119
- $productData['productimage']=$siteUrl.$this->productOrigData['image'];
 
 
 
 
 
 
 
 
120
  }else{
121
  $productData['productimage']=$this->productOrigData['image'];
122
  }
@@ -314,7 +329,7 @@ class Wisepricer_Syncer_ProductsController extends Wisepricer_Syncer_BaseControl
314
  'error_details'=>'Unauthorized access.'
315
  );
316
  echo json_encode($returnArr);
317
- die;
318
  }
319
 
320
  $productsEncoded= $post['products'];
74
 
75
  }
76
  $collection->addFieldToFilter('status', Mage_Catalog_Model_Product_Status::STATUS_ENABLED);
 
77
  $collection->addAttributeToFilter('type_id', array('eq' => 'simple'));
78
+
79
+ $collection->addAttributeToFilter(
80
+ array(
81
+ array('attribute' => 'import_to_wisepricer', 'neq' => 1),
82
+ array('attribute' => 'import_to_wisepricer', 'null' => true),
83
+ )
84
+ ,
85
+ '',
86
+ 'left'
87
+ );
88
+
89
  if($licenseData->getWebsite()!=0){
90
+ $collection->addStoreFilter($licenseData->getWebsite());
91
  }
92
 
93
  if($licenseData->getImport_outofstock()){
96
 
97
  $collection->setPage($pageNum, $count)->load();
98
  // echo '<pre>'.print_r($collection->getData(),true).'</pre>'; die;
99
+ //echo $collection->getSelect();die;
100
 
101
  $productsOutput=array();
102
 
104
 
105
  foreach ($collection as $product) {
106
 
 
 
 
 
107
  $productCollData=$product->getData();
108
  $productModel=Mage::getModel('catalog/product')->load($productCollData['entity_id']);
109
 
120
  }elseif($field['wsp_field']=='productimage'){
121
 
122
  if($field['magento_field']=='image'||$field['magento_field']=='small_image'){
123
+
124
  //TODO add valid media url in case that website uses store code in url check this Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_MEDIA);
125
+
126
+ try{
127
+
128
+ $siteUrl=substr_replace(Mage::getUrl('media/catalog/product') ,"",-1);
129
+ $productData['productimage']=$siteUrl.$this->productOrigData['image'];
130
+
131
+ }catch(Exception $e){
132
+
133
+ }
134
+
135
  }else{
136
  $productData['productimage']=$this->productOrigData['image'];
137
  }
329
  'error_details'=>'Unauthorized access.'
330
  );
331
  echo json_encode($returnArr);
332
+ die;
333
  }
334
 
335
  $productsEncoded= $post['products'];
app/code/local/Wisepricer/Syncer/etc/config.xml CHANGED
@@ -2,7 +2,7 @@
2
  <config>
3
  <modules>
4
  <Wisepricer_Syncer>
5
- <version>1.1.4.5</version>
6
  <url>http://www.wisepricer.com/index.php</url>
7
  <modulename>Wisepricer Syncer</modulename>
8
  </Wisepricer_Syncer>
2
  <config>
3
  <modules>
4
  <Wisepricer_Syncer>
5
+ <version>1.1.4.6</version>
6
  <url>http://www.wisepricer.com/index.php</url>
7
  <modulename>Wisepricer Syncer</modulename>
8
  </Wisepricer_Syncer>
package.xml CHANGED
@@ -1,19 +1,18 @@
1
  <?xml version="1.0"?>
2
  <package>
3
  <name>Wisepricer_Syncer</name>
4
- <version>1.1.4.5</version>
5
  <stability>stable</stability>
6
  <license uri="http://www.opensource.org/licenses/osl-3.0.php">OSL</license>
7
  <channel>community</channel>
8
  <extends/>
9
  <summary>WisePricer- Beat your competition</summary>
10
  <description>WisePricer is a new tool that allows you to Track &amp; monitor successful online retailers and update your store prices in real-time. With WisePricer you&#x2019;ll never get left behind the competition.</description>
11
- <notes>Added
12
- reprice to any price field</notes>
13
  <authors><author><name>Moshe</name><user>auto-converted</user><email>moshe@wisepricer.com</email></author></authors>
14
- <date>2013-04-11</date>
15
- <time>15:13:49</time>
16
- <contents><target name="mageskin"><dir name="adminhtml"><dir name="default"><dir name="default"><dir name="images"><dir name="wisepricer"><file name="bullet-green.png" hash="78d917a9d9aea11366bada6e0ae53931"/><file name="validation_advice_bg.gif" hash="ffdad80de989e3b04a977be3778c4347"/><file name="wp-alert-icon.png" hash="0dbbadfbbe2329098d03f8351aa2eaf2"/><file name="wp-logo.png" hash="48db98cdfc570336c942271352f31094"/><file name="wp-save-btn.png" hash="6d8e02c7f5e54dcc705e6436f126c66d"/></dir></dir><dir name="wisepricer"><file name="chosen-sprite.png" hash="8e70d120437ffc6a1bf7cebeca292d5c"/><file name="chosen.css" hash="bcd3f3e697219898e26631ccf29d97ba"/><file name="chosen.proto.js" hash="8259b22f4f337ba9ab63506b5ee4a52f"/><file name="myprototype.js" hash="2325b8b147c5dfaa8531c9d8bafd3648"/><file name="prototype17.js" hash="2325b8b147c5dfaa8531c9d8bafd3648"/><file name="wisepricer.css" hash="bd4dc50e10de4b41ae1c0ab18b2045ad"/></dir></dir></dir></dir></target><target name="magedesign"><dir name="adminhtml"><dir name="default"><dir name="default"><dir name="layout"><file name="syncer.xml" hash="a9d0f0b5af6b7bc28fb3c3b897c1773c"/></dir><dir name="template"><dir name="wisepricer"><file name="mapping.phtml" hash="021a17507985d01b681792f26311bca4"/></dir></dir></dir></dir></dir></target><target name="mageetc"><dir name="modules"><file name="Wisepricer_Syncer.xml" hash="838dc229469d27db4c96a49591b12f55"/></dir></target><target name="magelocal"><dir name="Wisepricer"><dir name="Syncer"><dir name="Block"><dir name="Adminhtml"><file name="Mapping.php" hash="612d45b21f0650d119801cda480cc8d7"/><file name="Register.php" hash="ed2ffde3237ecba2dbdd6002b5077af3"/></dir></dir><dir name="controllers"><file name="BaseController.php" hash="def65eee1964d7c0667e8cb32375e74c"/><file name="ProductsController.php" hash="97fc2612a3a6830eeaf6ef8b3dc0a857"/><file name="SalesController.php" hash="eb9e9d553da503e43632bd5b1451b9be"/><dir name="Adminhtml"><file name="SyncerController.php" hash="22cb1bbb7498960cd518b4b860b185d9"/></dir></dir><dir name="etc"><file name="config.xml" hash="1cdaf61b4db270740c91fa15b33f7004"/></dir><dir name="Helper"><file name="Data.php" hash="025b73c04ab0ca01d2e7c75aaad7fea6"/></dir><dir name="lib"><dir name="phpseclib"><dir name="Crypt"><file name="AES.php" hash="dd67dd1dbc7706e6c740e8430054d5e0"/><file name="DES.php" hash="47ac443f1edd2833cdc2f4eb80aa9a71"/><file name="Hash.php" hash="9be22f6426f2176caebb34a6cd2cb579"/><file name="Random.php" hash="5befc55c3423792c0cd50bc6d4f527b1"/><file name="RC4.php" hash="c6ec724c3a5d807d5ea4645518c37d29"/><file name="Rijndael.php" hash="7a92c95c750dd9ec1b8ce92915b4aa35"/><file name="RSA.php" hash="9bd5734f28d149d183c603643f6dbbb4"/><file name="TripleDES.php" hash="07c384b505d52802803313126e9e3836"/></dir><dir name="Math"><file name="BigInteger.php" hash="61aa9373ea606c928187d168159ac3f8"/></dir><dir name="Net"><file name="SFTP.php" hash="029f797c16ddd23b1d65636a72141115"/><file name="SSH1.php" hash="818d83815fe9bb5741594226bbdad975"/><file name="SSH2.php" hash="db5145effae044c7a1f6e7d778b566f5"/></dir><dir name="PHP"><dir name="Compat"><dir name="Function"><file name="array_fill.php" hash="840a674cac272c5588fa59f9421ed9a3"/><file name="bcpowmod.php" hash="4cb8fab0ee419f4b5a626980bbf04938"/><file name="str_split.php" hash="85cb5961afa62dde933190ee851a6d9a"/></dir></dir></dir></dir></dir><dir name="Model"><file name="Config.php" hash="d669c3dc977ddf71a58c90fa8df3180c"/><file name="Mapping.php" hash="d924ae8bcf54a3ca1224e8680d847fee"/><file name="Observer.php" hash="6d7216c55bb46f202a33f61bcad556d6"/><file name="Reprice.php" hash="ba6050d59ab31cb19e7ffa01e2f58321"/><dir name="Adminhtml"><file name="Attributes.php" hash="cadf0b88a3878ae0ec847b3c116cda43"/></dir><dir name="Mysql4"><file name="Config.php" hash="61b7eb73489844aa0ee041c216bab2db"/><file name="Mapping.php" hash="d97574adda931ce798964c67041f6af5"/><dir name="Config"><file name="Collection.php" hash="c7c7b6844e3ff8893163c392f4132f30"/></dir><dir name="Mapping"><file name="Collection.php" hash="c0f15143db582e070cfb83de92c57d09"/></dir></dir><dir name="Source"><file name="Boolean.php" hash="dbb3f3187972a1a918eec16345de987a"/></dir></dir><dir name="sql"><dir name="syncer_setup"><file name="mysql4-install-1.1.3.8.php" hash="f149922af5a6e5be8a474b4cc68d415f"/><file name="mysql4-upgrade-1.1.3.8-1.1.3.9.php" hash="8d7bcdc6fb908a4906f3af7dfcb28ab8"/><file name="mysql4-upgrade-1.1.3.9-1.1.4.1.php" hash="99396eeee161d50822de7be3aa76cbec"/><file name="mysql4-upgrade-1.1.4.1-1.1.4.2.php" hash="f7d4c87537d4cd570f358bebad578056"/><file name="mysql4-upgrade-1.1.4.4-1.1.4.5.php" hash="6685c36c866b2b7ee9970d5f688ed251"/></dir></dir></dir></dir></target></contents>
17
  <compatible/>
18
  <dependencies/>
19
  </package>
1
  <?xml version="1.0"?>
2
  <package>
3
  <name>Wisepricer_Syncer</name>
4
+ <version>1.1.4.6</version>
5
  <stability>stable</stability>
6
  <license uri="http://www.opensource.org/licenses/osl-3.0.php">OSL</license>
7
  <channel>community</channel>
8
  <extends/>
9
  <summary>WisePricer- Beat your competition</summary>
10
  <description>WisePricer is a new tool that allows you to Track &amp; monitor successful online retailers and update your store prices in real-time. With WisePricer you&#x2019;ll never get left behind the competition.</description>
11
+ <notes>Fixed bug: skip ignored products on the level of sql query</notes>
 
12
  <authors><author><name>Moshe</name><user>auto-converted</user><email>moshe@wisepricer.com</email></author></authors>
13
+ <date>2013-05-02</date>
14
+ <time>13:29:20</time>
15
+ <contents><target name="mageskin"><dir name="adminhtml"><dir name="default"><dir name="default"><dir name="images"><dir name="wisepricer"><file name="bullet-green.png" hash="78d917a9d9aea11366bada6e0ae53931"/><file name="validation_advice_bg.gif" hash="ffdad80de989e3b04a977be3778c4347"/><file name="wp-alert-icon.png" hash="0dbbadfbbe2329098d03f8351aa2eaf2"/><file name="wp-logo.png" hash="48db98cdfc570336c942271352f31094"/><file name="wp-save-btn.png" hash="6d8e02c7f5e54dcc705e6436f126c66d"/></dir></dir><dir name="wisepricer"><file name="chosen-sprite.png" hash="8e70d120437ffc6a1bf7cebeca292d5c"/><file name="chosen.css" hash="bcd3f3e697219898e26631ccf29d97ba"/><file name="chosen.proto.js" hash="8259b22f4f337ba9ab63506b5ee4a52f"/><file name="myprototype.js" hash="2325b8b147c5dfaa8531c9d8bafd3648"/><file name="prototype17.js" hash="2325b8b147c5dfaa8531c9d8bafd3648"/><file name="wisepricer.css" hash="bd4dc50e10de4b41ae1c0ab18b2045ad"/></dir></dir></dir></dir></target><target name="magedesign"><dir name="adminhtml"><dir name="default"><dir name="default"><dir name="layout"><file name="syncer.xml" hash="a9d0f0b5af6b7bc28fb3c3b897c1773c"/></dir><dir name="template"><dir name="wisepricer"><file name="mapping.phtml" hash="021a17507985d01b681792f26311bca4"/></dir></dir></dir></dir></dir></target><target name="mageetc"><dir name="modules"><file name="Wisepricer_Syncer.xml" hash="838dc229469d27db4c96a49591b12f55"/></dir></target><target name="magelocal"><dir name="Wisepricer"><dir name="Syncer"><dir name="Block"><dir name="Adminhtml"><file name="Mapping.php" hash="612d45b21f0650d119801cda480cc8d7"/><file name="Register.php" hash="ed2ffde3237ecba2dbdd6002b5077af3"/></dir></dir><dir name="controllers"><file name="BaseController.php" hash="def65eee1964d7c0667e8cb32375e74c"/><file name="ProductsController.php" hash="42132cb0c00bfc0a1bc76940855424c9"/><file name="SalesController.php" hash="eb9e9d553da503e43632bd5b1451b9be"/><dir name="Adminhtml"><file name="SyncerController.php" hash="22cb1bbb7498960cd518b4b860b185d9"/></dir></dir><dir name="etc"><file name="config.xml" hash="9acb355d9aa6f32af5507a0932224c3e"/></dir><dir name="Helper"><file name="Data.php" hash="025b73c04ab0ca01d2e7c75aaad7fea6"/></dir><dir name="lib"><dir name="phpseclib"><dir name="Crypt"><file name="AES.php" hash="dd67dd1dbc7706e6c740e8430054d5e0"/><file name="DES.php" hash="47ac443f1edd2833cdc2f4eb80aa9a71"/><file name="Hash.php" hash="9be22f6426f2176caebb34a6cd2cb579"/><file name="Random.php" hash="5befc55c3423792c0cd50bc6d4f527b1"/><file name="RC4.php" hash="c6ec724c3a5d807d5ea4645518c37d29"/><file name="Rijndael.php" hash="7a92c95c750dd9ec1b8ce92915b4aa35"/><file name="RSA.php" hash="9bd5734f28d149d183c603643f6dbbb4"/><file name="TripleDES.php" hash="07c384b505d52802803313126e9e3836"/></dir><dir name="Math"><file name="BigInteger.php" hash="61aa9373ea606c928187d168159ac3f8"/></dir><dir name="Net"><file name="SFTP.php" hash="029f797c16ddd23b1d65636a72141115"/><file name="SSH1.php" hash="818d83815fe9bb5741594226bbdad975"/><file name="SSH2.php" hash="db5145effae044c7a1f6e7d778b566f5"/></dir><dir name="PHP"><dir name="Compat"><dir name="Function"><file name="array_fill.php" hash="840a674cac272c5588fa59f9421ed9a3"/><file name="bcpowmod.php" hash="4cb8fab0ee419f4b5a626980bbf04938"/><file name="str_split.php" hash="85cb5961afa62dde933190ee851a6d9a"/></dir></dir></dir></dir></dir><dir name="Model"><file name="Config.php" hash="d669c3dc977ddf71a58c90fa8df3180c"/><file name="Mapping.php" hash="d924ae8bcf54a3ca1224e8680d847fee"/><file name="Observer.php" hash="6d7216c55bb46f202a33f61bcad556d6"/><file name="Reprice.php" hash="ba6050d59ab31cb19e7ffa01e2f58321"/><dir name="Adminhtml"><file name="Attributes.php" hash="cadf0b88a3878ae0ec847b3c116cda43"/></dir><dir name="Mysql4"><file name="Config.php" hash="61b7eb73489844aa0ee041c216bab2db"/><file name="Mapping.php" hash="d97574adda931ce798964c67041f6af5"/><dir name="Config"><file name="Collection.php" hash="c7c7b6844e3ff8893163c392f4132f30"/></dir><dir name="Mapping"><file name="Collection.php" hash="c0f15143db582e070cfb83de92c57d09"/></dir></dir><dir name="Source"><file name="Boolean.php" hash="dbb3f3187972a1a918eec16345de987a"/></dir></dir><dir name="sql"><dir name="syncer_setup"><file name="mysql4-install-1.1.3.8.php" hash="f149922af5a6e5be8a474b4cc68d415f"/><file name="mysql4-upgrade-1.1.3.8-1.1.3.9.php" hash="8d7bcdc6fb908a4906f3af7dfcb28ab8"/><file name="mysql4-upgrade-1.1.3.9-1.1.4.1.php" hash="99396eeee161d50822de7be3aa76cbec"/><file name="mysql4-upgrade-1.1.4.1-1.1.4.2.php" hash="f7d4c87537d4cd570f358bebad578056"/><file name="mysql4-upgrade-1.1.4.4-1.1.4.5.php" hash="6685c36c866b2b7ee9970d5f688ed251"/></dir></dir></dir></dir></target></contents>
16
  <compatible/>
17
  <dependencies/>
18
  </package>