esc_like( '_user_' ) . '%' . $wpdb->esc_like( '_tiered_price_rules_type' );
$results = $wpdb->get_results( $wpdb->prepare( "
SELECT meta_key FROM {$wpdb->postmeta}
WHERE post_id = %d AND meta_key LIKE %s
", $product_id, $meta_keys_like ) );
foreach ( $results as $result ) {
// Extract user ID from meta_key (e.g. _user_123_tiered_price_rules_type)
if ( preg_match( '/^_user_(\d+)_tiered_price_rules_type$/', $result->meta_key, $matches ) ) {
$userId = (int) $matches[1];
$user = get_userdata( $userId );
if ( $user && UserBasedPriceManager::userHasRules( $userId, $product_id, 'edit' ) ) {
$userBasedRule = UserBasedPricingRule::build( $product_id, $userId );
$fileManager->includeTemplate( 'addons/user-based-pricing/user.php', array(
'pricing_rule' => $userBasedRule,
'user' => $user,
'product_id' => $product_id,
'product' => $product,
'loop' => $loop,
) );
$presentUsers[] = $userId;
}
}
}
?>
'advanced',
), ServiceContainer::getInstance()->getSettings()->getLink() );
$settingsLink = sprintf( '%s', esc_url( $settingsLink ),
esc_html__( 'settings', 'tier-pricing-table' ) );
// translators: %s: settings link
echo wp_kses_post( sprintf( __( 'You can disable this feature in the %s if you don\'t need customer-based pricing.',
'tier-pricing-table' ), $settingsLink ) );
?>