| | |
|---|
| | | private LocalDateTime updateTime; |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * 灯杆编号 |
|---|
| | | * 灯杆ID |
|---|
| | | */ |
|---|
| | | private Long poleCode; |
|---|
| | | private Long poleId; |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * 灯杆名称 |
|---|
| | |
|---|
| | | where c3_mac = #{c3Mac} |
|---|
| | | </select> |
|---|
| | | <select id="listC3mChargingDto" resultType="com.sandu.ximon.dao.bo.C3ChargingBo"> |
|---|
| | | SELECT t1.*, t3.pole_code, |
|---|
| | | SELECT t1.*, |
|---|
| | | t3.id AS pole_id, |
|---|
| | | t3.pole_name |
|---|
| | | FROM c3m_charging t1 |
|---|
| | | LEFT JOIN pole_binding t2 ON t1.mcu_udid = t2.device_code |
|---|
| | | AND t2.device_type = 8 |
|---|
| | | AND t2.device_type = 2 |
|---|
| | | LEFT JOIN pole t3 ON t3.id = t2.pole_id |
|---|
| | | <where> |
|---|
| | | <if test="keyword != null and keyword != ''"> |
|---|
