订单

yujian

2020-06-09 7220cf2e1bef64b4a26904dfa07b7488d82c181f

订单

 fanli/src/main/java/com/yeshi/fanli/mapping/order/CommonOrderMapper.xml

@@ -1170,9 +1170,6 @@
            <foreach collection="listSource" item="item" open="AND ("
                close=")" separator="or">co.co_source_type = #{item}</foreach>
        </if>
        <if test="notBackSuVip == true">
            <![CDATA[AND co.co_source_type <> 4 AND co.co_source_type <> 5]]>
        </if>
        GROUP BY co.`co_order_no`, co.`co_source_type` ORDER BY
        co.co_third_create_time DESC LIMIT ${start},${count}
    </select>
@@ -1207,9 +1204,6 @@
        <if test="listSource != null and listSource.size() &gt; 0">
            <foreach collection="listSource" item="item" open="AND ("
                close=")" separator="or">co.co_source_type = #{item}</foreach>
        </if>
        <if test="notBackSuVip == true">
            <![CDATA[AND co.co_source_type <> 4 AND co.co_source_type <> 5]]>
        </if>
        GROUP BY co.`co_order_no`, co.`co_source_type` )A
    </select>