ID_, PRIVATE_CLOUD_APPLY_ID_, VIRTUAL_MACHINE_NAME_, INTRANET_IP_, EXTERNAL_IP_, CPU_NUM_, MEMORY_CAPACITY_, SYS_CAPACITY_, DATA_CAPACITY_, CLOUD_TYPE_, SYSTEM_, OTHER_REQUIREMENTS_, CREATE_BY_, CREATE_ORG_NAME_, CREATE_COMPANY_ID_, CREATE_COMPANY_NAME_, CREATE_NAME_, CREATE_ORG_ID_, CREATE_TIME_, UPDATE_BY_, UPDATE_NAME_, UPDATE_COMPANY_NAME_, UPDATE_COMPANY_ID_, UPDATE_ORG_ID_, UPDATE_ORG_NAME_, UPDATE_TIME_, LAST_TIME_, IS_DELE_, VERSION_, TENANT_ID_ SELECT a.VIRTUAL_MACHINE_NAME_, a.INTRANET_IP_, a.EXTERNAL_IP_, a.CPU_NUM_, a.MEMORY_CAPACITY_, a.SYS_CAPACITY_, a.DATA_CAPACITY_, CASE WHEN a.CLOUD_TYPE_ = '1' THEN'XSKY' WHEN a.CLOUD_TYPE_ = '2' THEN'Zstack' END AS cloudType, a.SYSTEM_, a.OTHER_REQUIREMENTS_, CASE WHEN b.INTRANET_AGREEMENT_ = '1' THEN'TCP' WHEN b.INTRANET_AGREEMENT_ = '2' THEN'UDP' END AS intranetAgreement, b.INTRANET_PORT_ AS intranetPort, b.NETWORK_PORT_ AS networkPort, b.PORT_PURPOSE_ AS portPurpose, b.REMARKS_ AS remarks FROM biz_cloud_apply_detail a LEFT JOIN biz_cloud_apply_detail_port b ON a.ID_ = b.PRIVATE_CLOUD_APPLY_DETAILED_ID_ AND b.IS_DELE_ = '0' WHERE a.IS_DELE_ = '0' AND a.PRIVATE_CLOUD_APPLY_ID_ = #{privateCloudApplyId}