#!/usr/bin/env bash
set -u
APP="/var/www/html/favo"
echo "===== FAVO PHASE 2A VERIFY ====="
echo "[1] Migration"
mysql -u master -p favo_test -e "SELECT version, applied_at FROM schema_migrations WHERE version='010_merchant_workspace_crm';"
echo "[2] Routes"
grep -nE "merchant_workspace|merchant_branch_save|merchant_staff_create|crm_customer" "$APP/public/index.php"
echo "[3] Syntax"
find "$APP/app/Controllers" "$APP/app/Services" -type f -name '*.php' -print0 | xargs -0 -n1 php -l | tail -n 8
echo "[4] Permissions"
mysql -u master -p favo_test -e "
SELECT r.name role_name,p.code permission_code
FROM role_permissions rp JOIN roles r ON r.id=rp.role_id
JOIN permissions p ON p.id=rp.permission_id
WHERE p.code IN ('crm.view','branch.manage','staff.manage','merchant.manage')
ORDER BY r.id,p.id;"
echo "[5] Tables/indexes"
mysql -u master -p favo_test -e "
SHOW INDEX FROM customer_events WHERE Key_name='idx_customer_events_merchant_customer_created';
SHOW INDEX FROM purchase_transactions WHERE Key_name='idx_purchase_merchant_customer_created';
SHOW INDEX FROM loyalty_transactions WHERE Key_name='idx_loyalty_account_created';
SHOW INDEX FROM reward_unlocks WHERE Key_name='idx_reward_unlock_customer_merchant_created';"
echo "===== VERIFY COMPLETE ====="