queryByCondition

select 
@pageTag(){
t.*
@}
from xzx_user_vehicle_info t
where 1=1  
@//数据权限，该sql语句功能点,如果不考虑数据权限，可以删除此行  
and #function("xzxUserVehicleInfo.query")#

batchDelXzxUserVehicleInfoByIds

• 批量逻辑删除

  update xzx_user_vehicle_info set del_flag = 1 where id in( #join(ids)#)

queryByVehicleInfoList
===
select a.id,m.id as relId,a.vehicle_no as vehicleNo,(select c.storage_name from xzx_sys_storage c where c.id=a.storage_id) as address,
m.name as name,a.weight as weight,m.user_id as userId,a.storage_id as storageId
from xzx_user_vehicle_info a
left join ( select b.id,b.user_id,d.name,b.vehicle_id,d.partner_id
from xzx_user_vehicle_rel b
left join xzx_user_other_info d on b.user_id=d.user_id) m
on a.id=m.vehicle_id
where a.del_flag=0
@if(!isEmpty(vehicleNo)){
AND a.vehicle_no like #'%'+vehicleNo+'%'#
@}
@if(!isEmpty(partnerIds)){
AND m.partner_id in (#join(partnerIds)#)
@}
LIMIT #page#, #limit#

queryByVehicleInfoCount

    select count(a.id)
    from xzx_user_vehicle_info a
    left join ( select b.id,b.user_id,d.name,b.vehicle_id,d.partner_id 
                       from xzx_user_vehicle_rel b
                       left join xzx_user_other_info d on b.user_id=d.user_id) m
                     on a.id=m.vehicle_id 
    where  a.del_flag=0   
    @if(!isEmpty(vehicleNo)){
                            AND a.vehicle_no=#vehicleNo#
                         @} 
     @if(!isEmpty(partnerIds)){
                    AND m.partner_id in (#join(partnerIds)#)
             @}