FoodMenusMapper.java 848 B

123456789101112131415161718192021222324
  1. package com.sky.ioc.mapper;
  2. import com.baomidou.mybatisplus.core.mapper.BaseMapper;
  3. import com.sky.ioc.entity.domain.canteen.FoodMenu;
  4. import com.sky.ioc.entity.domain.canteen.Order;
  5. import com.sky.ioc.entity.domain.system.Users;
  6. import com.sky.ioc.entity.params.IocParam;
  7. import org.apache.ibatis.annotations.Mapper;
  8. import org.apache.ibatis.annotations.Param;
  9. import org.apache.ibatis.annotations.Select;
  10. import java.util.List;
  11. @Mapper
  12. public interface FoodMenusMapper extends BaseMapper<FoodMenu> {
  13. @Select("<script>" +
  14. "SELECT name as cuisineName,price,time_type as cuisineType,type as cuisineTypeTwo from food_menus a where 1=1" +
  15. "<if test='type!=null '>" +
  16. " and time_type= #{type} " +
  17. "</if>"+
  18. "</script>")
  19. List<FoodMenu> getListByType(@Param("type") Integer type);
  20. }