parent: 0a34b84b | patch | commit | show whitespace
xiaoyong931011
2022-08-29 e40f42c6a8b293a2a1656a5ac70d2c50359b9d36 
20220822
1 files modified
8 ■■■■■ changed files
src/main/resources/mapper/modules/MallGoodsMapper.xml 8 ●●●●● patch | view | raw | blame | history 
 src/main/resources/mapper/modules/MallGoodsMapper.xml


@@ -230,7 +230,13 @@


                    and a.goods_id=#{record.goodsId}


                </if>


                <if test="record.commentType != null and record.commentType != '' and record.commentType == 1">


                    and a.star > 4


                    and a.star <![CDATA[ > ]]> 4


                </if>


                <if test="record.commentType != null and record.commentType != '' and record.commentType == 2">


                    and (a.star <![CDATA[ >= ]]> 3 and a.star <![CDATA[ <= ]]> 4)


                </if>


                <if test="record.commentType != null and record.commentType != '' and record.commentType == 3">


                    and (a.star <![CDATA[ < ]]> 3 )


                </if>


            </if>


        </where>