| | |
|---|
| | | |
|---|
| | | <select id="selectCockpitDevicePage" resultType="org.sxkj.fw.device.vo.CockpitFwDeviceVO"> |
|---|
| | | select |
|---|
| | | d.*, |
|---|
| | | d.id, |
|---|
| | | d.device_sn, |
|---|
| | | d.airport_id, |
|---|
| | | d.device_name, |
|---|
| | | d.device_type, |
|---|
| | | d.device_att, |
|---|
| | | d.device_model, |
|---|
| | | d.device_specification, |
|---|
| | | d.manufacturer, |
|---|
| | | d.source, |
|---|
| | | d.purpose, |
|---|
| | | d.belong_dept, |
|---|
| | | d.charger, |
|---|
| | | d.contact_phone, |
|---|
| | | d.remark, |
|---|
| | | d.battery_pct, |
|---|
| | | d.azimuth, |
|---|
| | | d.elevation, |
|---|
| | | d.detect_target_cnt, |
|---|
| | | d.effective_range_km, |
|---|
| | | d.work_mode, |
|---|
| | | d.area_code, |
|---|
| | | d.track_status, |
|---|
| | | d.final_outbound_area, |
|---|
| | | d.final_outbound_area_code, |
|---|
| | | d.is_enabled, |
|---|
| | | d.create_user, |
|---|
| | | d.create_dept, |
|---|
| | | d.create_time, |
|---|
| | | d.update_user, |
|---|
| | | d.update_time, |
|---|
| | | d.status, |
|---|
| | | d.is_deleted, |
|---|
| | | NULLIF(trim(d.latitude::text), '')::double precision AS latitude, |
|---|
| | | NULLIF(trim(d.longitude::text), '')::double precision AS longitude, |
|---|
| | | min(ad.id) as area_divide_id, |
|---|
| | | min(dsm.id) as defense_scene_manage_id |
|---|
| | | from |
|---|
