package com.panzhihua.service_community.dao;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.panzhihua.common.model.dtos.PageDTO;
|
import com.panzhihua.common.model.dtos.shop.PageComShopOrderSearchDTO;
|
import com.panzhihua.common.model.vos.shop.ComShopOrderVO;
|
import com.panzhihua.common.model.vos.shop.ComShopStoreVO;
|
import com.panzhihua.service_community.model.dos.ComShopOrderDO;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Select;
|
|
/**
|
* @auther cedoo
|
* @create 2021-4-17 17:35:51
|
* @describe 订单表mapper类
|
*/
|
@Mapper
|
public interface ComShopOrderDAO extends BaseMapper<ComShopOrderDO> {
|
|
@Select("<script> " +
|
"SELECT\n" +
|
"id,\n" +
|
"`name`,\n" +
|
"photo_path,\n" +
|
"phone,\n" +
|
"integral,\n" +
|
"create_at \n" +
|
"FROM\n" +
|
"com_mng_volunteer_mng \n" +
|
" where state=2 and community_id=#{comMngVolunteerMngVO.communityId}" +
|
"<if test='comMngVolunteerMngVO.name != null and comMngVolunteerMngVO.name.trim() != ""'>" +
|
" and name like concat(#{comMngVolunteerMngVO.name},'%') \n" +
|
" </if> " +
|
"<if test='comMngVolunteerMngVO.phone != null and comMngVolunteerMngVO.phone.trim() != ""'>" +
|
"AND phone like concat(#{comMngVolunteerMngVO.phone},'%') " +
|
" </if> " +
|
" order by integral desc,create_at desc"+
|
"</script>")
|
IPage<ComShopOrderVO> pageOrderBy(PageDTO page, PageComShopOrderSearchDTO pageComShopOrderSearchDTO);
|
|
}
|
