package com.panzhihua.service_community.dao;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.panzhihua.common.model.dtos.community.PageComMngCarDTO;
|
import com.panzhihua.common.model.vos.community.ComMngCarVO;
|
import com.panzhihua.service_community.model.dos.ComMngCarDO;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
|
/**
|
* @description: 车辆管理
|
* @author: Null
|
* @date: 2021/3/16 14:28
|
*/
|
@Mapper
|
public interface ComMngCarDAO extends BaseMapper<ComMngCarDO> {
|
|
@Select("<script> " +
|
" SELECT " +
|
" t.id, " +
|
" t.community_id AS communityId, " +
|
" t1.`name` AS communityName, " +
|
" t.area_id AS areaId, " +
|
" t2.area_name AS areaName, " +
|
" t.user_id userId, " +
|
" t.user_name AS userName, " +
|
" t.address, " +
|
" t.mobile, " +
|
" t.plate_num AS plateNum, " +
|
" t.brand, " +
|
" t.color, " +
|
" t.create_at AS createAt, " +
|
" t3.`name` AS createBy " +
|
"FROM " +
|
" com_mng_car t " +
|
" LEFT JOIN com_act t1 ON t.community_id = t1.community_id " +
|
" LEFT JOIN com_mng_struct_area t2 ON t2.id = t.area_id " +
|
" LEFT JOIN sys_user t3 ON t.create_by = t3.user_id " +
|
" WHERE t.source =2 " +
|
"<if test='pageComMngCarDTO.name != null and pageComMngCarDTO.name.trim() != ""'>" +
|
" and t.user_name LIKE concat( '%',#{pageComMngCarDTO.name}, '%' ) " +
|
" </if> " +
|
"<if test='pageComMngCarDTO.communityId != null and pageComMngCarDTO.communityId != 0'>" +
|
" and t.community_id = #{pageComMngCarDTO.communityId} " +
|
" </if> " +
|
"<if test='pageComMngCarDTO.areaName != null'>" +
|
" and t2.area_name LIKE concat( '%',#{pageComMngCarDTO.areaName}, '%' ) " +
|
" </if> " +
|
" order by t.create_at desc" +
|
"</script>")
|
IPage<ComMngCarVO> pageQueryComMngCar(Page page, @Param(value = "pageComMngCarDTO") PageComMngCarDTO pageComMngCarDTO);
|
}
|
