| | |
| | | import com.baomidou.mybatisplus.annotation.IdType; |
| | | import com.baomidou.mybatisplus.annotation.TableId; |
| | | import com.baomidou.mybatisplus.annotation.TableName; |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
| | | import lombok.Data; |
| | | import org.springframework.format.annotation.DateTimeFormat; |
| | | |
| | | import java.io.Serializable; |
| | | import java.util.Date; |
| | |
| | | private String latitude; |
| | | |
| | | private Long userId; |
| | | |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss",timezone = "GMT+8") |
| | | @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") |
| | | private Date recordTime; |
| | | |
| | | } |
| | |
| | | </select> |
| | | |
| | | <select id="getList" resultType="org.springblade.modules.location.vo.LivePersonLocationVO"> |
| | | SELECT lpl.* FROM sys_live_person_location lpl |
| | | SELECT |
| | | lpl.*, |
| | | bu.real_name as realName, |
| | | bu.avatar, |
| | | bd.dept_name as deptName, |
| | | sdu.name as dispatchCompany, |
| | | sd.dispatcherTime as dispatchStartTime, |
| | | sd.end_time as dispatchEndTime |
| | | FROM sys_live_person_location lpl |
| | | LEFT JOIN blade_user bu ON bu.id = lpl.user_id |
| | | LEFT JOIN blade_dept bd ON bd.id = bu.dept_id |
| | | LEFT JOIN sys_dispatcher sd ON sd.user_ids = bu.id |
| | | LEFT JOIN sys_dispatcher_unit sdu ON sdu.id = sd.dispatcher_unit_id |
| | | WHERE 1=1 |
| | | |
| | | </select> |
| | | </mapper> |
| | |
| | | |
| | | @Data |
| | | public class LivePersonLocationVO extends LivePersonLocation { |
| | | |
| | | //头像 |
| | | private String avatar; |
| | | |
| | | //姓名 |
| | | private String realName; |
| | | |
| | | //公司名称 |
| | | private String deptName; |
| | | |
| | | private String dispatchCompany; |
| | | |
| | | private String dispatchStartTime; |
| | | |
| | | private String dispatchEndTime; |
| | | } |
| | |
| | | * @return |
| | | */ |
| | | @GetMapping("/getUserInfo") |
| | | public UserVO getUserInfo(String securityNumber,String cardid){ |
| | | public R getUserInfo(String securityNumber,String cardid){ |
| | | UserVO userInfoBySecurityNumber = userService.getUserInfoBySecurityNumber(securityNumber, cardid); |
| | | //根据保安员编码查询保安员信息 |
| | | return userService.getUserInfoBySecurityNumber(securityNumber,cardid); |
| | | return R.data(userInfoBySecurityNumber); |
| | | } |
| | | |
| | | /** |