Website and Membership Configuration Validation

-- Run on the registration-portal database via the mysql-client pod in the mysql namespace
SELECT t.id, t.name, t.domain, t.registration_system_id,
       t.issuer_url, t.client_id, t.theme
FROM tenant t
WHERE t.domain = :hostname;

-- Run on the admin-service database via the mysql-client pod in the mysql namespace
SELECT rs.id, rs.name, rs.type, rs.base_url, rs.auth_key, rs.payment_methods,
       o.id AS org_id, o.name AS org_name
FROM registration_system rs
JOIN organisation o ON rs.organisation_id = o.id
WHERE rs.id = :registration_system_id;

SELECT rs.id, rs.name, rs.auth_key, rs.base_url
FROM registration_system rs
WHERE rs.id = :registration_system_id;

# Use the appropriate kubeconfig for the target environment
export KUBECONFIG=/path/to/kubeconfig.yaml

# Verify Registration Portal deployment in the target namespace
kubectl -n <namespace> get deployment registration-portal

# Verify admin-service deployment
kubectl -n <namespace> get deployment admin-service

# Check ingress or service for the tenant hostname
kubectl -n <namespace> get ingress -o wide

SELECT mt.id, mt.name,
       o.id AS org_id, o.name AS org_name,
       mt.enrol_process_id,
       mt.cross_sell_membership_type_id
FROM membership_type mt
JOIN organisation o ON mt.organisation_id = o.id
WHERE o.name = :organisation_name
ORDER BY mt.name;

SELECT mt.id, mt.name AS membership_type,
       cs.id AS cross_sell_id, cs.name AS cross_sell_type
FROM membership_type mt
LEFT JOIN membership_type cs ON mt.cross_sell_membership_type_id = cs.id
WHERE mt.organisation_id = :organisation_id
ORDER BY mt.name;

SELECT mp.id, mp.name, mp.valid_from, mp.valid_to,
       mt.name AS membership_type,
       mp.enrol_process_id,
       mp.default_criteria_id
FROM membership_period mp
JOIN membership_type mt ON mp.membership_type_id = mt.id
WHERE mt.organisation_id = :organisation_id
  AND mp.valid_from >= :period_start
ORDER BY mt.name, mp.valid_from;

SELECT mc.id, mc.name AS criteria_name,
       mc.min_age, mc.max_age, mc.gender, mc.type_selector,
       p.id AS product_id, p.name AS product_name,
       p.external_id, p.price, p.sales_price
FROM membership_criteria mc
JOIN membership_period mp ON mc.period_id = mp.id
JOIN membership_type mt ON mp.membership_type_id = mt.id
LEFT JOIN product p ON mc.product_id = p.id
WHERE mt.organisation_id = :organisation_id
  AND mp.name = :period_name
ORDER BY mc.name;

-- Run on the WordPress database
SELECT p.ID, p.post_title, p.post_status,
       pm_price.meta_value AS price,
       pm_sale.meta_value AS sale_price
FROM wp_posts p
LEFT JOIN wp_postmeta pm_price ON p.ID = pm_price.post_id AND pm_price.meta_key = '_price'
LEFT JOIN wp_postmeta pm_sale ON p.ID = pm_sale.post_id AND pm_sale.meta_key = '_sale_price'
WHERE p.ID IN (:external_ids)
  AND p.post_type = 'product';

SELECT pd.id, pd.name AS process_name, pd.type,
       ps.id AS step_id, ps.seq, ps.name AS step_name,
       ps.type AS step_type, ps.description,
       ps.jhi_require AS required,
       ps.person_data_key,
       ps.skip_if_set,
       ps.list_options
FROM process_definition pd
JOIN process_step ps ON ps.definition_id = pd.id
WHERE pd.id = :enrol_process_id
ORDER BY ps.seq;

-- Check type-level process
SELECT mt.id, mt.name, mt.enrol_process_id AS type_process_id,
       pd.name AS type_process_name
FROM membership_type mt
LEFT JOIN process_definition pd ON mt.enrol_process_id = pd.id
WHERE mt.id = :membership_type_id;

-- Check period-level override
SELECT mp.id, mp.name, mp.enrol_process_id AS period_process_id,
       pd.name AS period_process_name
FROM membership_period mp
LEFT JOIN process_definition pd ON mp.enrol_process_id = pd.id
WHERE mp.membership_type_id = :membership_type_id;