MyBatisPlus 自定义sql语句的实现

 @Override
    public Map<String, Object> kccxhj(Term term) throws Exception{
        QueryWrapper<EZShangPin> wrapper=new QueryWrapper<>();
        if(MyStrUtils.isNotEmpty(term.getQ())){
            CWMSTmdrdmx tmdrdmx=new CWMSTmdrdmx();
            tmdrdmx.setTm(term.getQ());
            tmdrdmx.setSl(1);
            tmService.recongnizeSptm(tmdrdmx);
            //log("tmdrdmx",tmdrdmx);
            if(tmdrdmx.getResult()==0){
                wrapper.eq("spdm",tmdrdmx.getSpdm());
            }else{
                wrapper.like("spdm+'_'+spmc+'_'+isnull(zjf,'')", term.getQ());
            }
        }
        wrapper.eq(MyStrUtils.isNotEmpty(term.getPpdm()),"fjsx1",term.getPpdm());
        wrapper.eq(MyStrUtils.isNotEmpty(term.getDldm()),"fjsx2",term.getDldm());
        wrapper.eq(MyStrUtils.isNotEmpty(term.getJjdm()),"fjsx3",term.getJjdm());
        wrapper.eq(MyStrUtils.isNotEmpty(term.getNddm()),"fjsx4",term.getNddm());
        wrapper.eq("isnull(tzsy,0)", 0);

        wrapper.eq("ckdm", term.getCurrentsddm());

        return repMapper.kccxhj(wrapper);
    }

@Mapper
@Repository
public interface RepMapper extends BaseMapper {


    Map<String, Object> kccxhj(@Param(Constants.WRAPPER) QueryWrapper wrapper);

}

   <select id="kccxhj" resultType="java.util.Map">

        SELECT SUM(SL) AS zsl,sum(sl*bzsj) as zje
        from(
                select ckdm,ShangPin.spdm,ShangPin.spmc,ShangPin.zjf,shanpin.bzsj,ShangPin.FJSX1,ShangPin.FJSX2,ShangPin.FJSX3,ShangPin.FJSX4,SPKCB.SL
                from shangpin,SPKCB
                where shangpin.spdm=spkcb.SPDM
        ) a
        ${ew.customSqlSegment}

    </select>