练手需求

自己根据下述描述，完成表结构设计、0-1的搭建，三次架构代码编写，并用JUnit完成测试

时间要求：3H

全景图读取数据

简要描述

• 获取场景锁定小区列表

请求URL

• /gis/panorama/findCmCell

请求方式

• POST

参数

返回示例

{
    "code": 200,
    "data":[],
    "message":""
  }

返回参数说明

备注

select
CI,
REGION_NAME,
CITY_NAME,
ENBAJ02,
ENODEBNAME,
ENBAG05,
‘LTE’ NET_work,
WORK_FRQBAND,
RRU_SerialNO,
‘’ RRU_NO,
DEVICE_MODEL_LIST,
ENBAH21,
HEIGHT,
ENBAH08,
TOTAL_DOWNTILT
from tdl_cm_cell ff WHERE ff.”TIME” =to_date(‘2024-08-31’,’yyyy-MM-dd’)

UNION ALL

select
NCI CI,
REGION_NAME,
CITY_NAME,
CellName ENBAJ02,
gNBNAME ENODEBNAME,
gNB_ID ENBAG05,
‘NR’ NET_work,
WORK_FRQBAND,
SerialNumber RRU_SerialNO,
‘’ RRU_NO,
VendorUnitTypeNumber DEVICE_MODEL_LIST,
‘’ ENBAH21,
HEIGHT,
Azimuth ENBAH08,
TOTAL_DOWNTILT
from nrcell_cm cc WHERE time= to_date(‘2024-08-31’,’yyyy-MM-dd’)

4G
SELECT ci/nci FROM tdl_cm_cell WHERE RRU_SERIALNO =’219999741006’ AND “TIME” =to_date(‘2024-08-31’,’yyyy-MM-dd’)
5G
SELECT ci/nci FROM nrcell_cm WHERE RRU_SERIALNO =’219999741006’ AND “TIME” =to_date(‘2024-08-31’,’yyyy-MM-dd’)

将二次查询的结果 ci/nci “，“隔开拼接到 RRU_NO 字段中

• 更多返回错误代码请看首页的错误代码描述