select DATE_FORMAT(oi.create_time ,'%Y-%m-%d') orderDate,sum(oi.total_amount) totalAmount ,count(oi.id) totalNum
from order_info oi where DATE_FORMAT(oi.create_time ,'%Y-%m-%d')=#{lastDay}GROUPBY DATE_FORMAT(oi.create_time ,'%Y-%m-%d')#统计每日金额
select
p.id, p.name , p.brand_id , p.category1_id , p.category2_id , p.category3_id, p.unit_name,
p.slider_urls , p.spec_value , p.status, p.audit_status , p.audit_message , p.create_time , p.update_time , p.is_deleted ,
b.name brandName , c1.name category1Name , c2.name category2Name , c3.name category3Name
from product p
LEFTJOIN brand b on b.id = p.brand_id
LEFTJOIN category c1 on c1.id = p.category1_id
LEFTJOIN category c2 on c2.id = p.category2_id
LEFTJOIN category c3 on c3.id = p.category3_id
where
p.id =#{id}#三级菜单
5.MybatisPlus自定义Sql
//ServicepublicIPage<CategoryBrand>findByPage(Integer page,Integer limit,CategoryBrandDto categoryBrandDto){QueryWrapper<CategoryBrand> wapper =newQueryWrapper<>();if(categoryBrandDto.getCategoryId()!=null){
wapper.eq("category_id",categoryBrandDto.getCategoryId());}if(categoryBrandDto.getBrandId()!=null){
wapper.eq("brand_id",categoryBrandDto.getBrandId());}
wapper.eq("cb.is_deleted",0);Page<CategoryBrand> dbPage =newPage<>(page, limit);return categoryBrandMapper.findByPage(dbPage,wapper);}//MapperIPage<CategoryBrand>findByPage(Page<CategoryBrand> dbPage,@Param(Constants.WRAPPER)QueryWrapper<CategoryBrand> wapper);//Mapper.xml<select id="findByPage" resultMap="categoryBrandMap">
select
cb.id,cb.brand_id,cb.category_id,cb.create_time,cb.update_time,
c.name as categoryName,
b.name as brandName, b.logo
from category_brand cb
left join category c on c.id = cb.category_id
left join brand b on b.id = cb.brand_id
${ew.customSqlSegment}
order by cb.id desc
</select>