AbstractPriceByPostMeta.php
1 week ago
Factory.php
1 week ago
PriceFilteringByPostMeta.php
1 week ago
PriceOrderByPostMeta.php
1 week ago
AbstractPriceByPostMeta.php
45 lines
| 1 | <?php |
| 2 | |
| 3 | namespace WCML\Multicurrency\WpQueryMcPrice; |
| 4 | |
| 5 | abstract class AbstractPriceByPostMeta { |
| 6 | |
| 7 | const WCML_CUSTOM_PRICES_STATUS_ALIAS = 'wcml_mc_status'; |
| 8 | |
| 9 | const WCML_PRICE_ALIAS = 'wcml_org_price'; |
| 10 | |
| 11 | const WCML_MC_PRICE_ALIAS = 'wcml_mc_price'; |
| 12 | |
| 13 | protected $woocommerce_wpml; |
| 14 | |
| 15 | protected $wpdb; |
| 16 | |
| 17 | protected $default_currency; |
| 18 | |
| 19 | protected $client_currency; |
| 20 | |
| 21 | public function __construct( \woocommerce_wpml $woocommerce_wpml, \wpdb $wpdb ) { |
| 22 | $this->woocommerce_wpml = $woocommerce_wpml; |
| 23 | $this->wpdb = $wpdb; |
| 24 | |
| 25 | $this->default_currency = wcml_get_woocommerce_currency_option(); |
| 26 | $this->client_currency = $this->woocommerce_wpml->multi_currency->get_client_currency(); |
| 27 | } |
| 28 | |
| 29 | protected function buildWCMLMultiCurrencyQueryJoin( $clausesJoinSQL ) { |
| 30 | if ( false === strpos( $clausesJoinSQL, ' ' . self::WCML_CUSTOM_PRICES_STATUS_ALIAS . ' ' ) ) { |
| 31 | $clausesJoinSQL .= "\n LEFT JOIN {$this->wpdb->postmeta} AS " . self::WCML_CUSTOM_PRICES_STATUS_ALIAS . " ON ({$this->wpdb->posts}.ID = " . self::WCML_CUSTOM_PRICES_STATUS_ALIAS . ".post_id) and " . self::WCML_CUSTOM_PRICES_STATUS_ALIAS . ".meta_key = '_wcml_custom_prices_status' "; |
| 32 | } |
| 33 | |
| 34 | if ( false === strpos( $clausesJoinSQL, ' ' . self::WCML_PRICE_ALIAS . ' ' ) ) { |
| 35 | $clausesJoinSQL .= "\n LEFT JOIN {$this->wpdb->postmeta} AS " . self::WCML_PRICE_ALIAS . " ON ({$this->wpdb->posts}.ID = " . self::WCML_PRICE_ALIAS . ".post_id) and " . self::WCML_PRICE_ALIAS . ".meta_key = '_price' "; |
| 36 | } |
| 37 | |
| 38 | if ( false === strpos( $clausesJoinSQL, ' ' . self::WCML_MC_PRICE_ALIAS . ' ' ) ) { |
| 39 | $clausesJoinSQL .= "\n LEFT JOIN {$this->wpdb->postmeta} AS " . self::WCML_MC_PRICE_ALIAS . " ON ({$this->wpdb->posts}.ID = " . self::WCML_MC_PRICE_ALIAS . ".post_id) and " . self::WCML_MC_PRICE_ALIAS . ".meta_key = '_price_{$this->client_currency}' "; |
| 40 | } |
| 41 | |
| 42 | return $clausesJoinSQL; |
| 43 | } |
| 44 | } |
| 45 |