Changeset 2081150
- Timestamp:
- 05/06/2019 06:41:12 AM (7 years ago)
- Location:
- avecdo-for-woocommerce
- Files:
-
- 4 edited
- 3 copied
-
tags/1.4.7 (copied) (copied from avecdo-for-woocommerce/trunk)
-
tags/1.4.7/avecdo.php (copied) (copied from avecdo-for-woocommerce/trunk/avecdo.php) (3 diffs)
-
tags/1.4.7/models/WooQueries.php (modified) (2 diffs)
-
tags/1.4.7/readme.txt (copied) (copied from avecdo-for-woocommerce/trunk/readme.txt) (3 diffs)
-
trunk/avecdo.php (modified) (3 diffs)
-
trunk/models/WooQueries.php (modified) (2 diffs)
-
trunk/readme.txt (modified) (3 diffs)
Legend:
- Unmodified
- Added
- Removed
-
avecdo-for-woocommerce/tags/1.4.7/avecdo.php
r2035093 r2081150 4 4 * Plugin URI: http://avecdo.com/ 5 5 * Description: avecdo connector plugin for WooCommerce 6 * Version: 1.4. 66 * Version: 1.4.7 7 7 * Author: Modified Solutions ApS 8 8 * Author URI: https://www.modified.dk/ … … 10 10 * Developer URI: https://www.modified.dk/ 11 11 * Requires at least: 3.5 12 * Tested up to: 5. 0.213 * WC requires at least: 2. 0.2014 * WC tested up to: 3. 5.312 * Tested up to: 5.1.1 13 * WC requires at least: 2.5.0 14 * WC tested up to: 3.6.2 15 15 * 16 16 * Text Domain: avecdo-for-woocommerce … … 31 31 * @var string Version string 32 32 */ 33 define('AVECDO_WOOCOMMERCE_PLUGIN_VERSION', '1.4. 6');33 define('AVECDO_WOOCOMMERCE_PLUGIN_VERSION', '1.4.7'); 34 34 35 35 /** -
avecdo-for-woocommerce/tags/1.4.7/models/WooQueries.php
r1985249 r2081150 468 468 protected function getSalePrice($productId) 469 469 { 470 $query = "SELECT t1.post_id, t1.meta_value as sale_price, t2.meta_value as sale_from, t3.meta_value as sale_to 471 FROM ".$this->wpdb_prefix."postmeta AS t1 INNER JOIN ".$this->wpdb_prefix."postmeta AS t2 ON t2.post_id=t1.post_id AND 472 t2.meta_key='_sale_price_dates_from' INNER JOIN ".$this->wpdb_prefix."postmeta AS t3 ON t3.post_id=t1.post_id 473 AND t3.meta_key='_sale_price_dates_to' WHERE t1.post_id = {$productId} AND t1.meta_key='_sale_price'"; 470 $query = " 471 SELECT 472 t1.post_id, t1.meta_value as sale_price, t2.meta_value as sale_from, t3.meta_value as sale_to 473 FROM ".$this->wpdb_prefix."postmeta AS t1 474 INNER JOIN ".$this->wpdb_prefix."postmeta AS t2 ON t2.post_id=t1.post_id AND 475 t2.meta_key='_sale_price_dates_from' 476 INNER JOIN ".$this->wpdb_prefix."postmeta AS t3 ON t3.post_id=t1.post_id 477 AND t3.meta_key='_sale_price_dates_to' 478 479 WHERE t1.post_id = {$productId} AND t1.meta_key='_sale_price'"; 480 474 481 $query_result = $this->wpdb->get_results($query, OBJECT); 475 482 if ($query_result) { … … 479 486 $inSaleTimeFrame = (($saleFrom && $saleTo) || ($saleFrom && !$saleTo && $query_result->sale_to == 0)); 480 487 return $inSaleTimeFrame ? $query_result->sale_price : null; 488 } else { 489 $query = " 490 SELECT 491 t1.post_id, t1.meta_value as sale_price 492 FROM ".$this->wpdb_prefix."postmeta AS t1 493 WHERE t1.post_id = {$productId} AND t1.meta_key='_sale_price'"; 494 495 $query_result = $this->wpdb->get_results($query, OBJECT); 496 if ($query_result) { 497 $query_result = $query_result[0]; 498 return $query_result->sale_price; 499 } 481 500 } 482 501 return null; -
avecdo-for-woocommerce/tags/1.4.7/readme.txt
r2035093 r2081150 3 3 Tags: feed, service, avecdo, Facebook, Google Shopping, shopping, woocommerce, kelkoo, miinto, Pricerunner, Partner-ads, ecommerce, e-commerce 4 4 Requires at least: 3.5 5 Tested up to: 5. 0.26 Stable tag: 1.4. 65 Tested up to: 5.1.1 6 Stable tag: 1.4.7 7 7 License: Mozilla Public License Version 2.0 8 8 License URI: https://www.mozilla.org/en-US/MPL/2.0/ … … 46 46 == Changelog == 47 47 48 = 1.4.7 = 49 * Fix issues with saleprice if no end time were set 50 * Testet with latest Woocommerce and WordPress 51 48 52 = 1.4.6 = 49 53 * Fix issue with missing methods when checking for external plugins. … … 82 86 83 87 = 1.3.8 = 84 * Minor fix to reduce load when fetching products, and calculating if the product prices are tax inclusive. Tested with Word pPress 4.9.688 * Minor fix to reduce load when fetching products, and calculating if the product prices are tax inclusive. Tested with WordPress 4.9.6 85 89 86 90 = 1.3.7 = 87 * Fix that should hide update notification after plugin is upgraded. Tested with Word pPress 4.9.5 and WooCommerce 3.3.591 * Fix that should hide update notification after plugin is upgraded. Tested with WordPress 4.9.5 and WooCommerce 3.3.5 88 92 89 93 = 1.3.6 = -
avecdo-for-woocommerce/trunk/avecdo.php
r2035093 r2081150 4 4 * Plugin URI: http://avecdo.com/ 5 5 * Description: avecdo connector plugin for WooCommerce 6 * Version: 1.4. 66 * Version: 1.4.7 7 7 * Author: Modified Solutions ApS 8 8 * Author URI: https://www.modified.dk/ … … 10 10 * Developer URI: https://www.modified.dk/ 11 11 * Requires at least: 3.5 12 * Tested up to: 5. 0.213 * WC requires at least: 2. 0.2014 * WC tested up to: 3. 5.312 * Tested up to: 5.1.1 13 * WC requires at least: 2.5.0 14 * WC tested up to: 3.6.2 15 15 * 16 16 * Text Domain: avecdo-for-woocommerce … … 31 31 * @var string Version string 32 32 */ 33 define('AVECDO_WOOCOMMERCE_PLUGIN_VERSION', '1.4. 6');33 define('AVECDO_WOOCOMMERCE_PLUGIN_VERSION', '1.4.7'); 34 34 35 35 /** -
avecdo-for-woocommerce/trunk/models/WooQueries.php
r1985249 r2081150 468 468 protected function getSalePrice($productId) 469 469 { 470 $query = "SELECT t1.post_id, t1.meta_value as sale_price, t2.meta_value as sale_from, t3.meta_value as sale_to 471 FROM ".$this->wpdb_prefix."postmeta AS t1 INNER JOIN ".$this->wpdb_prefix."postmeta AS t2 ON t2.post_id=t1.post_id AND 472 t2.meta_key='_sale_price_dates_from' INNER JOIN ".$this->wpdb_prefix."postmeta AS t3 ON t3.post_id=t1.post_id 473 AND t3.meta_key='_sale_price_dates_to' WHERE t1.post_id = {$productId} AND t1.meta_key='_sale_price'"; 470 $query = " 471 SELECT 472 t1.post_id, t1.meta_value as sale_price, t2.meta_value as sale_from, t3.meta_value as sale_to 473 FROM ".$this->wpdb_prefix."postmeta AS t1 474 INNER JOIN ".$this->wpdb_prefix."postmeta AS t2 ON t2.post_id=t1.post_id AND 475 t2.meta_key='_sale_price_dates_from' 476 INNER JOIN ".$this->wpdb_prefix."postmeta AS t3 ON t3.post_id=t1.post_id 477 AND t3.meta_key='_sale_price_dates_to' 478 479 WHERE t1.post_id = {$productId} AND t1.meta_key='_sale_price'"; 480 474 481 $query_result = $this->wpdb->get_results($query, OBJECT); 475 482 if ($query_result) { … … 479 486 $inSaleTimeFrame = (($saleFrom && $saleTo) || ($saleFrom && !$saleTo && $query_result->sale_to == 0)); 480 487 return $inSaleTimeFrame ? $query_result->sale_price : null; 488 } else { 489 $query = " 490 SELECT 491 t1.post_id, t1.meta_value as sale_price 492 FROM ".$this->wpdb_prefix."postmeta AS t1 493 WHERE t1.post_id = {$productId} AND t1.meta_key='_sale_price'"; 494 495 $query_result = $this->wpdb->get_results($query, OBJECT); 496 if ($query_result) { 497 $query_result = $query_result[0]; 498 return $query_result->sale_price; 499 } 481 500 } 482 501 return null; -
avecdo-for-woocommerce/trunk/readme.txt
r2035093 r2081150 3 3 Tags: feed, service, avecdo, Facebook, Google Shopping, shopping, woocommerce, kelkoo, miinto, Pricerunner, Partner-ads, ecommerce, e-commerce 4 4 Requires at least: 3.5 5 Tested up to: 5. 0.26 Stable tag: 1.4. 65 Tested up to: 5.1.1 6 Stable tag: 1.4.7 7 7 License: Mozilla Public License Version 2.0 8 8 License URI: https://www.mozilla.org/en-US/MPL/2.0/ … … 46 46 == Changelog == 47 47 48 = 1.4.7 = 49 * Fix issues with saleprice if no end time were set 50 * Testet with latest Woocommerce and WordPress 51 48 52 = 1.4.6 = 49 53 * Fix issue with missing methods when checking for external plugins. … … 82 86 83 87 = 1.3.8 = 84 * Minor fix to reduce load when fetching products, and calculating if the product prices are tax inclusive. Tested with Word pPress 4.9.688 * Minor fix to reduce load when fetching products, and calculating if the product prices are tax inclusive. Tested with WordPress 4.9.6 85 89 86 90 = 1.3.7 = 87 * Fix that should hide update notification after plugin is upgraded. Tested with Word pPress 4.9.5 and WooCommerce 3.3.591 * Fix that should hide update notification after plugin is upgraded. Tested with WordPress 4.9.5 and WooCommerce 3.3.5 88 92 89 93 = 1.3.6 =
Note: See TracChangeset
for help on using the changeset viewer.