修改 可以删除贴标签的商品

yujian

2019-05-30 658abf6822afe4ea5390a36de382eb5dc63c2d4d

修改 可以删除贴标签的商品

 fanli/src/main/java/com/yeshi/fanli/mapping/lable/QualityFactoryMapper.xml

@@ -1104,9 +1104,9 @@

    <select id="getAuctionIdbyClassId" resultType="java.lang.Long">
        SELECT h.`sg_goods_id` FROM `yeshi_ec_quality_factory` h    
        WHERE  h.`sg_goods_source` = #{goodsSource} <if test="systemCid != null">AND h.`sg_class_id` = #{systemCid}</if>
        WHERE  h.`sg_goods_source` = #{goodsSource} 
            AND h.`sg_updatetime` <![CDATA[<]]> #{beforeTime}
            AND NOT EXISTS(SELECT lg_goods_id FROM `yeshi_ec_label_goods` lb WHERE lb.`lg_goods_id` = h.`sg_goods_id`)
            <if test="systemCid != null">AND h.`sg_class_id` = #{systemCid}</if>
    </select>