package com.ruoyi.zhushi.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.zhushi.entity.Inventory;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;
@Mapper
public interface InventoryMapper extends BaseMapper<Inventory> {
/*    @Select("SELECT b.* FROM inventorybase a " +
            "INNER JOIN inventory b ON a.url = b.url " +
            "WHERE a.type = #{type} " +
            "AND b.create_date = #{queryDate} " +
            "AND b.title LIKE CONCAT('%', #{queryWord}, '%')")*/
    List<Inventory>  getInventoriesByParam(@Param("queryWord") String  queryWord,
                                           @Param("queryDate") String queryDate,
                                           @Param("type") String type
                                            );
}
