mybatis组合条件批量查询

我会带着你远行 2022-12-20 11:17 298阅读 0赞

mybatis组合条件批量查询  
          
         /\*\*  
     \* 根据pos版本,数据版本，餐厅组查询所用菜单版本信息  
     \*  
     \* @param assignAddStoreParamVos 菜单版本  
     \* @return 菜单版本  
     \*/  
    List<TemplateVersionVO> getTemplateVersionInfo(@Param("assignAddStoreParamVos") List<AssignAddStoreParamVO> assignAddStoreParamVos);

<select id="getTemplateVersionInfo" resultMap="BaseResultMap">  
        SELECT  
        DISTINCT tv.id,tv.pos\_menu\_version,tv.sequence\_no,tv.data\_version  
        FROM  
            t\_template\_version tv  
            LEFT JOIN t\_template\_used tu ON tv.pos\_menu\_version = tu.pos\_menu\_version  
            AND tv.sequence\_no = tu.sequence\_no  
            AND tv.data\_version = tu.data\_version  
            LEFT JOIN t\_template\_store\_group tsg ON tsg.data\_version = tu.data\_version  
            AND tsg.channel\_group\_code = tu.channel\_group\_code  
            AND tsg.template\_id = tu.template\_id  
            LEFT JOIN t\_store\_group\_store tsts ON tsts.data\_version = tsg.data\_version  
            AND tsts.store\_group\_code = tsg.store\_group\_code  
        WHERE  
        <if test="assignAddStoreParamVos !=null and assignAddStoreParamVos.size()>0">  
            (tsts.store\_group\_code, tu.data\_version,tv.pos\_menu\_version,tv.sequence\_no) in  
            <foreach collection="assignAddStoreParamVos" item="assignAddStore" index="index" open="(" separator="," close=")">  
                (\#\{assignAddStore.storeGroupCode\}, \#\{assignAddStore.dataVersion\},\#\{assignAddStore.posMenuVersion\},\#\{assignAddStore.sequenceNo\})  
            </foreach>  
        </if>  
            AND tv.\`status\` IN ( 11, 12, 13, 14, 15 )  
    </select>