查詢小抄

查 DB / schema 時，遵守 pro360_api_82 AGENTS 規則：容器 PHP 8.2 + DBFactory。

查 Schema

docker exec -w /project-data cd63f9147e8d php -r 'require "vendor/autoload.php"; $db=\PRO360\Common\DBFactory::get(); foreach($db->fetchRows("SHOW COLUMNS FROM users") as $row){echo json_encode($row, JSON_UNESCAPED_UNICODE|JSON_UNESCAPED_SLASHES).PHP_EOL;}'

查兩個工具人狀態

docker exec -w /project-data cd63f9147e8d php -r 'require "vendor/autoload.php"; $db=\PRO360\Common\DBFactory::get(); foreach($db->fetchRows("SELECT id,email,is_active,is_phone_confirmed,is_identity_confirmed,available_wallet_amount,is_auto_quote_on,last_card_invalid_time FROM users WHERE id IN (8616,8617) ORDER BY id") as $row){echo json_encode($row, JSON_UNESCAPED_UNICODE|JSON_UNESCAPED_SLASHES).PHP_EOL;}'

查 Provider Service / Card

docker exec -w /project-data cd63f9147e8d php -r 'require "vendor/autoload.php"; $db=\PRO360\Common\DBFactory::get(); foreach($db->fetchRows("SELECT id,user_id,business_name,is_active,is_archived,active_pro,quote_category_ids FROM quote_services WHERE user_id IN (8616,8617) ORDER BY user_id,id") as $row){echo json_encode($row, JSON_UNESCAPED_UNICODE|JSON_UNESCAPED_SLASHES).PHP_EOL;} foreach($db->fetchRows("SELECT id,user_id,card_info,is_auto_quote,is_valid,is_default,is_remove,country_code FROM stripe_customers WHERE user_id IN (8616,8617) ORDER BY user_id,id") as $row){echo json_encode($row, JSON_UNESCAPED_UNICODE|JSON_UNESCAPED_SLASHES).PHP_EOL;}'