| | |
| | | s2 = query.getTimePeriod().split(" - ")[1]; |
| | | } |
| | | Page<TParkingRecord> page = parkingRecordService.lambdaQuery() |
| | | .in(TParkingRecord::getParkingLotId,ids) |
| | | .in(null != ids && ids.size() > 0, TParkingRecord::getParkingLotId,ids) |
| | | .like(query.getLicensePlate() != null, TParkingRecord::getLicensePlate, query.getLicensePlate()) |
| | | .eq(query.getStatus() != null, TParkingRecord::getStatus, query.getStatus()) |
| | | .eq(query.getOutParkingType() != null, TParkingRecord::getOutParkingType, query.getOutParkingType()) |
| | |
| | | </foreach> |
| | | </if> |
| | | </where> |
| | | GROUP BY |
| | | time |
| | | ORDER BY |
| | | time |
| | | |
| | | |
| | | GROUP BY time |
| | | </select> |
| | | <select id="getCarColor" resultType="java.util.Map"> |
| | | SELECT |
| | |
| | | FROM |
| | | t_parking_record t1 |
| | | left join t_parking_lot t2 on t2.id = t1.parking_lot_id |
| | | |
| | | <where> |
| | | <if test="parkingRecordQueryDto.parkingLotId !=null"> |
| | | AND t1.parking_lot_id = #{parkingRecordQueryDto.parkingLotId} |