| | |
| | | from xp_qualification_audit xqa |
| | | left join xp_operations_user xou on xqa.operations_user_id = xou.id |
| | | left join xp_operations_role xor on xou.id = xor.operations_user_id |
| | | <where> |
| | | where xqa.is_deleted = 0 |
| | | <if test="query.nickName != null and query.nickName != ''"> |
| | | and xou.nick_name like concat('%',#{query.nickName},'%') |
| | | </if> |
| | |
| | | <if test="query.auditStatus != null"> |
| | | and xqa.audit_status = #{query.auditStatus} |
| | | </if> |
| | | AND xqa.is_deleted = 0 |
| | | </where> |
| | | order by xqa.create_time desc |
| | | </select> |
| | | |
| | |
| | | import java.time.LocalDateTime; |
| | | import java.io.Serializable; |
| | | |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
| | | import com.xiaopeng.common.core.web.domain.BaseModel; |
| | | import io.swagger.annotations.ApiModel; |
| | | import io.swagger.annotations.ApiModelProperty; |
| | |
| | | private Long operationsUserId; |
| | | |
| | | @ApiModelProperty(value = "检测时间") |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss",timezone = "GMT+8") |
| | | private LocalDateTime checkTime; |
| | | |
| | | |
| | |
| | | // 查询车辆当前充电信息 |
| | | XpChargingRecord xpChargingRecord = this.getOne(new LambdaQueryWrapper<XpChargingRecord>() |
| | | .eq(XpChargingRecord::getVehicleId, vehicleId) |
| | | .isNull(XpChargingRecord::getEndRemainingBattery) |
| | | .isNull(XpChargingRecord::getTaskId) |
| | | .orderByDesc(XpChargingRecord::getCreateTime) |
| | | .last("LIMIT 1")); |
| | |
| | | select id, shift_name, shift_color, start_time, end_time, is_rest, |
| | | rest_start_time, rest_end_time, create_by, create_time, update_by, update_time, is_deleted |
| | | from xp_shift |
| | | where is_deleted = 0 |
| | | order by create_time desc |
| | | </select> |
| | | </mapper> |