| | |
|---|
| | | |
|---|
| | | <select id="getOnlineCommanderPosition" parameterType="java.lang.String" resultType="java.util.Map"> |
|---|
| | | select su.user_name as "userName",su.nick_name as "nickName", |
|---|
| | | aap.user_id as "userId",aap.longitude,aap.latitude,aap.altitude, |
|---|
| | | aap.speed,aap.bearing,aap.create_time as "createTime" |
|---|
| | | aap.user_id as "userId",aap.longitude,aap.latitude, |
|---|
| | | coalesce(cast(aap.altitude as varchar),'') as altitude, |
|---|
| | | coalesce(cast(aap.speed as varchar),'') as speed, |
|---|
| | | coalesce(cast(aap.bearing as varchar),'') as bearing, |
|---|
| | | aap.create_time as "createTime" |
|---|
| | | from ard_app_application aaa |
|---|
| | | inner join sys_user su on aaa.commander_id = su.user_id |
|---|
| | | inner join ard_app_position aap on su.user_id = aap.user_id |
|---|
