搭乘游轮 Red Sea Aggressor 2 - 7 晚

舱位售价&费用条款

/** * Modern cabin/price grid for the _tab_cabins_prices tab on package nodes. * Replaces the previous boring table with a responsive card layout * featuring "Best Value" highlight, discount pricing, and clear CTAs. */ $package_nid = (int) $node->nid; $_dac_cabins = array(); // Inline DB query — same shape as dac_price_block_fetch_price_db() // but joins taxonomy_term_data to surface cabin names. Cabin data // is intentionally NOT loaded as commerce entities: it's a flat // (name + price) view that doesn't need the full Commerce stack. $_dac_cabins_query = db_query( "SELECT fcn.field_cabin_name_tid AS tid, td.name AS cabin_name, MIN(fcp.commerce_price_amount) AS min_price, MAX(fcp.commerce_price_amount) AS max_price, COUNT(*) AS variants FROM {field_data_field_cabin_package} fcap INNER JOIN {field_data_field_cabin_name} fcn ON fcn.entity_id = fcap.entity_id AND fcn.entity_type = 'commerce_product' AND fcn.deleted = 0 INNER JOIN {taxonomy_term_data} td ON td.tid = fcn.field_cabin_name_tid INNER JOIN {field_data_commerce_price} fcp ON fcp.entity_id = fcap.entity_id AND fcp.entity_type = 'commerce_product' AND fcp.deleted = 0 WHERE fcap.entity_type = 'commerce_product' AND fcap.deleted = 0 AND fcap.field_cabin_package_nid = :nid GROUP BY tid, cabin_name ORDER BY min_price ASC", array(':nid' => $package_nid) ); foreach ($_dac_cabins_query as $row) { $_dac_cabins[] = array( 'tid' => (int) $row->tid, 'name' => $row->cabin_name, 'min' => (int) $row->min_price, 'max' => (int) $row->max_price, 'variants' => (int) $row->variants, ); } // Special offer handling — mirrors the logic in render_price(). $_dac_offer_active = render_offer( render($content['field_special_offer']), render($content['field_special_offer_expiration']) ); $_dac_offer_pct = 0; $_dac_offer_label = ''; if ($_dac_offer_active && !empty($content['field_special_offer_discount'])) { $_dac_offer_pct = (float) strip_tags(render($content['field_special_offer_discount'])); $_dac_offer_label = trim(strip_tags(render($content['field_special_offer_discount']))); } // Resolve user currency once (may be USD, EUR, etc.). $_dac_currency = function_exists('commerce_multicurrency_get_user_currency_code') ? commerce_multicurrency_get_user_currency_code() : 'USD'; // Trip duration for the summary strip. $_dac_duration = isset($_dac_pkg_dmin) ? (int) $_dac_pkg_dmin : 0; ?>

起价

$2,760

此外，该游轮