deleteConditionsFromDbByTypes(array('subscription')); }); class Helpers { public static function getProductCustomFields($id) { global $wpdb; // phpcs:ignore WordPress.DB.DirectDatabaseQuery $wp_fields = $wpdb->get_results( $wpdb->prepare("SELECT DISTINCT CONCAT(fields.meta_key,'=',fields.meta_value) FROM {$wpdb->postmeta} AS fields JOIN {$wpdb->posts} AS products ON products.ID = fields.post_id WHERE products.post_type IN ('product','product_variation') AND products.ID = %d ORDER BY meta_key", $id), ARRAY_N); return array_map(function ($customField) { return array( 'id' => current($customField), 'text' => current($customField), ); }, $wp_fields); } public static function getProductAttributes($ids) { global $wc_product_attributes, $wpdb; if (empty($ids)) { return array(); } $ids = array_map('absint', $ids); $placeholders = implode(', ', array_fill(0, count($ids), '%d')); // $placeholders contains only repeated %d tokens; PHPCS cannot statically see them since they're built at runtime. // phpcs:disable WordPress.DB.DirectDatabaseQuery, WordPress.DB.PreparedSQL.InterpolatedNotPrepared, WordPress.DB.PreparedSQLPlaceholders.UnfinishedPrepare $items = $wpdb->get_results($wpdb->prepare( "SELECT {$wpdb->terms}.term_id, {$wpdb->terms}.name, taxonomy FROM {$wpdb->term_taxonomy} INNER JOIN {$wpdb->terms} USING (term_id) WHERE {$wpdb->terms}.term_id in ({$placeholders})", $ids )); // phpcs:enable return array_values(array_filter(array_map(function ($term) use ($wc_product_attributes) { if ( ! isset($wc_product_attributes[$term->taxonomy])) { return false; } $attribute = $wc_product_attributes[$term->taxonomy]->attribute_label; return array( 'id' => (string)$term->term_id, 'text' => $attribute . ': ' . $term->name, ); }, $items))); } public static function getUsers($ids) { $users = get_users(array( 'fields' => array('ID', 'user_nicename'), 'include' => $ids, 'orderby' => 'user_nicename', )); return array_map(function ($user) { return array( 'id' => (string)$user->ID, 'text' => $user->user_nicename, ); }, $users); } public static function getUserRoles() { global $wp_roles; $all_roles = $wp_roles->roles; $result = array_map(function ($id, $role) { return array( 'id' => (string)$id, 'text' => $role['name'], ); }, array_keys($all_roles), $all_roles); // dummy role for non registered users $result[] = array( 'id' => 'wdp_guest', 'text' => __('Guest', 'advanced-dynamic-pricing-for-woocommerce'), ); return array_values($result); } public static function getUserCapabilities() { global $wp_roles; $all_roles = $wp_roles->roles; $capabilities = array(); foreach ($all_roles as $role) { foreach ($role['capabilities'] as $capability => $value) { $capabilities[] = (string)$capability; } } $result = array_map(function ($capability) { return array( 'id' => $capability, 'text' => $capability, ); }, array_unique($capabilities)); return array_values($result); } public static function getCountries() { $countries = WC()->countries->get_countries(); $result = array_map(function ($id, $text) { return array( 'id' => $id, 'text' => $text, ); }, array_keys($countries), $countries); return array_values($result); } public static function getStates() { $shopCountryState = wc_format_country_state_string(get_option('woocommerce_default_country', '')); $shop_country = isset($shopCountryState['country']) ? $shopCountryState['country'] : null; $countries = WC()->countries->get_countries(); $country_states = WC()->countries->get_states(); $result = array(); foreach ($country_states as $countryCode => $states) { foreach ($states as $id => $text) { $result[] = array( 'id' => $countryCode . ':' . $id, 'text' => $text . (isset($countries[$countryCode]) && $shop_country !== $countryCode ? '(' . $countries[$countryCode] . ')' : ''), ); } } return $result; } public static function getCurrencies() { $allCurrencies = get_woocommerce_currencies(); $result = array(); foreach ($allCurrencies as $code => $name) { $result[] = array( 'id' => $code, 'text' => $name ); } return $result; } public static function getPaymentMethods() { $paymentGateways = WC()->payment_gateways->payment_gateways(); $result = array(); foreach ($paymentGateways as $paymentGateway) { if ( ! isset($paymentGateway->id)) { continue; } $result[] = array( 'id' => $paymentGateway->id, 'text' => $paymentGateway->title ?? $paymentGateway->id, ); } return apply_filters("adp_get_payment_methods", $result); } public static function getAllShippingMethods() { $result = array( array( 'id' => "all", 'text' => __('All', 'advanced-dynamic-pricing-for-woocommerce'), ) ); return array_merge($result, self::getShippingMethods()); } public static function getShippingMethods() { $shippingMethods = array(); foreach (WC()->shipping->get_shipping_methods() as $method) { $shippingMethods[$method->id] = __('[All zones]', 'advanced-dynamic-pricing-for-woocommerce') . " " . $method->method_title; } foreach (\WC_Shipping_Zones::get_zones() as $zone) { $methods = $zone['shipping_methods']; /** @var \WC_Shipping_Method $method */ foreach ($methods as $method) { $shippingMethods[$method->get_rate_id()] = '[' . $zone['zone_name'] . '] ' . $method->get_title(); } } $zone = new \WC_Shipping_Zone(0); $methods = $zone->get_shipping_methods(); /** @var \WC_Shipping_Method $method */ foreach ($methods as $method) { $shippingMethods[$method->get_rate_id()] = __('[Rest of the World]', 'advanced-dynamic-pricing-for-woocommerce') . ' ' . $method->get_title(); } $result = array(); foreach ($shippingMethods as $k => $shippingMethod) { $result[] = array( 'id' => $k, 'text' => $shippingMethod, ); } return $result; } public static function getShippingZones() { $zones = \WC_Shipping_Zones::get_zones(); $result = array(); foreach ($zones as $z) { $result[] = array( 'id' => $z['id'], 'text' => $z['zone_name'], ); } $result[] = array( 'id' => 0, //phpcs:ignore WordPress.WP.I18n.TextDomainMismatch 'text' => __('Locations not covered by your other zones', 'woocommerce'), ); return $result; } public static function getShippingClasses() { $shippingClasses = WC()->shipping->get_shipping_classes(); $result = array(); foreach ($shippingClasses as $shippingClass) { $result[] = array( 'id' => $shippingClass->slug, 'text' => $shippingClass->name, ); } return $result; } public static function getWeekdays() { $result = array( __('Sunday', 'advanced-dynamic-pricing-for-woocommerce'), __('Monday', 'advanced-dynamic-pricing-for-woocommerce'), __('Tuesday', 'advanced-dynamic-pricing-for-woocommerce'), __('Wednesday', 'advanced-dynamic-pricing-for-woocommerce'), __('Thursday', 'advanced-dynamic-pricing-for-woocommerce'), __('Friday', 'advanced-dynamic-pricing-for-woocommerce'), __('Saturday', 'advanced-dynamic-pricing-for-woocommerce'), ); array_walk($result, function (&$item, $key) { $item = array( 'id' => $key, 'text' => $item, ); }); return $result; } public static function getLanguages() { require_once ABSPATH . 'wp-admin/includes/translation-install.php'; $translations = wp_get_available_translations(); $result = []; foreach ($translations as $iso => $lang) { $result[] = [ 'id' => $iso, 'text' => $lang['english_name'], ]; } return $result; } public static function getProductTitle($id) { $product = wc_get_product($id); if (!($product instanceof WC_Product)) { return ""; } if ($product instanceof \WC_Product_Variation) { $formattedVariationList = wc_get_formatted_variation( $product, true, true, true ); return $product->get_name() . '' . $formattedVariationList . ''; } else { return $product->get_name(); } } public static function getThumbnailSrc( $id) { $product = wc_get_product($id); if (!($product instanceof WC_Product)) { return ""; } $src = ''; if ( preg_match( '/src\=["|\'](.*?)["|\']/i', $product->get_image(), $matches ) ) { $src = $matches[1]; } return $src; } public static function getProductName($id) { $post = get_post($id); return $post !== null ? $post->post_name : ""; } public static function getProductId($name) { if (is_int($name)) { if (CacheHelper::getWcProduct($name)) { return $name; } } /** @var WC_Product[] $posts */ $posts = wc_get_products(array( 'name' => $name, 'type' => array_merge(array_keys(wc_get_product_types()), array('variation')) )); $post = reset($posts); if ($post instanceof WC_Product) { return $post->get_id(); } return false; } public static function getProductLink($id) { return get_post_permalink($id); } public static function getCategoryTitle($id) { $term = get_term($id, 'product_cat'); return ! empty($term) && ! is_wp_error($term) ? $term->name : ""; } public static function getBrandTitle($id) { $term = get_term($id, 'product_brand'); return ! empty($term) && ! is_wp_error($term) ? $term->name : ""; } public static function getCategorySlugTitle($slug) { $term = get_term_by('slug', $slug, 'product_cat'); return ! empty($term) && ! is_wp_error($term) ? $term->name : ""; } public static function getCategorySlug($id) { $term = get_term($id, 'product_cat'); return ! empty($term) && ! is_wp_error($term) ? $term->slug : $id; } public static function getCategoryId($name) { return is_numeric($name) ? $name : self::getTermId($name, 'product_cat'); } public static function getCategoryLink($id) { return get_category_link($id); } public static function getCategorySlugLink($slug) { $link = get_term_link($slug, 'product_cat'); return ! empty($link) && ! is_wp_error($link) ? $link : ""; } public static function getTagTitle($id) { $term = get_term($id, 'product_tag'); return ! empty($term) && ! is_wp_error($term) ? $term->name : ""; } public static function getTagId($name) { return is_numeric($name) ? $name : self::getTermId($name, 'product_tag'); } public static function getTagLink($id) { return get_tag_link($id); } public static function getAttributeTitle($id) { global $wc_product_attributes; $term = get_term($id, 'product_tag'); if ($term and ! is_wp_error($term)) { $attribute = $wc_product_attributes[$term->taxonomy]->attribute_label; $ret = $attribute . ': ' . $term->name; } else { $ret = $id; } return $ret; } public static function getAttributeId($name) { return is_numeric($name) ? $name : self::getTermId($name, 'product_tag'); } public static function getAttributeLink($id) { return '';//TODO:?? } public static function getTermId($name, $taxonomy) { $term = get_term_by('name', $name, $taxonomy); if ($term instanceof WP_Term) { return $term->term_id; } return 0; } public static function getTitleByType($id, $type) { if ('products' === $type) { $name = self::getProductTitle($id); } elseif ('product_categories' === $type) { $name = self::getCategoryTitle($id); } elseif ('product_category_slug' === $type) { $name = self::getCategorySlugTitle($id); } elseif ('product_tags' === $type) { $name = self::getTagTitle($id); } elseif ('product_attributes' === $type) { $name = self::getAttributeTitle($id); } elseif (in_array($type, array_keys(self::getCustomProductTaxonomies()))) { $name = self::getProductTaxonomyTermTitle($id, $type); } else { $name = $id; } return $name; } public static function getPermalinkByType($id, $type) { if ('products' === $type) { $link = self::getProductLink($id); } elseif ('product_categories' === $type) { $link = self::getCategoryLink($id); } elseif ('product_category_slug' === $type) { $link = self::getCategorySlugLink($id); } elseif ('product_tags' === $type) { $link = self::getTagLink($id); } elseif ('product_attributes' === $type) { $link = self::getAttributeLink($id); } elseif (in_array($type, array_keys(self::getCustomProductTaxonomies()))) { $link = self::getProductTaxonomyTermPermalink($id, $type); } else { $link = ''; } return $link; } public static function getCustomProductTaxonomies($skipCache = false) { static $customTaxonomies = null; if ( ! $skipCache && $customTaxonomies !== null) { return $customTaxonomies; } $customTaxonomies = array_filter(get_taxonomies(array( 'show_ui' => true, 'show_in_menu' => true, 'object_type' => array('product'), ), 'objects'), function ($tax) { $buildInTaxonomies = array('product_cat', 'product_tag'); return ! in_array($tax->name, $buildInTaxonomies); }); return $customTaxonomies; } public static function getProductTaxonomyTermTitle($termId, $taxonomyName) { $term = get_term($termId, $taxonomyName); return ! empty($term) && ! is_wp_error($term) ? $term->name : ""; } public static function getProductTaxonomyTermPermalink($termId, $taxonomyName) { $termPermalink = get_term_link((int)$termId, $taxonomyName); return ! empty($termPermalink) && ! is_wp_error($termPermalink) ? $termPermalink : ''; } public static function ruleFilterLabel($name, $domain = 'advanced-dynamic-pricing-for-woocommerce') { $map = [ 'Filter by products' => 'product_filter', 'Product set' => 'product_set', 'Product discounts' => 'product_discount', 'Role discounts' => 'role_discount', 'Bulk mode' => 'bulk', 'Gifts' => 'free_product', 'Auto add to cart' => 'auto_add_to_cart', 'Cart/Shipping discounts' => 'cart_adjustment', 'Conditions' => 'cart_condition', 'Discount messages' => 'advertising', 'Offer to buy more' => 'offer_to_buy_more', 'Limits' => 'limits', ]; $map_for_pot = [ //not used in code, we need it to make .pot correctly __('Filter by products' , 'advanced-dynamic-pricing-for-woocommerce'), __('Product discounts' , 'advanced-dynamic-pricing-for-woocommerce'), __('Role discounts' , 'advanced-dynamic-pricing-for-woocommerce'), __('Bulk mode' , 'advanced-dynamic-pricing-for-woocommerce'), __('Gifts' , 'advanced-dynamic-pricing-for-woocommerce'), __('Auto add to cart' , 'advanced-dynamic-pricing-for-woocommerce'), __('Cart adjustments' , 'advanced-dynamic-pricing-for-woocommerce'), __('Conditions' , 'advanced-dynamic-pricing-for-woocommerce'), __('Discount messages' , 'advanced-dynamic-pricing-for-woocommerce'), __('Offer to buy more' , 'advanced-dynamic-pricing-for-woocommerce'), __('Limits' , 'advanced-dynamic-pricing-for-woocommerce'), ]; if(array_key_exists($name, $map)) { $path = WC_ADP_PLUGIN_URL."/BaseVersion/assets/images/".$map[$name].".svg"; // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped, PluginCheck.CodeAnalysis.ImageFunctions.NonEnqueuedImage echo ""; /*?> "; //phpcs:ignore WordPress.WP.I18n.NonSingularStringLiteralText, WordPress.WP.I18n.NonSingularStringLiteralDomain esc_html_e($name, $domain); // translations don't see this line!!! echo ""; } }